By importing cost data into Google Analytics, you may get reliable and efficient data that helps you stay on top of your expenses and ad spend. Cost data includes information on impressions, clicks, costs, keywords, ad groups, campaigns, and a lot more that comes from other non-Google social media platforms. You can save time and money by importing cost data. All of this is significant because it enables effective employee performance tracking software such as Controlio, allowing you to compare productivity across teams and conduct Return on Investment (ROI) analysis. You may import cost data from many sources into Google Analytics in a variety of additional ways. A low-cost, straightforward option is to manually enter the cost data into Google Analytics.
Configuring a Google Analytics Data Set
The first step is to create a data set type, name, and schema in Google Analytics. The sort of data you wish to import—in this case, cost data—is known as the data set type. The blueprint that connects the data you add with the data that already exists is called the schema. The dimension and measure are translated by the schema into a format that Google Analytics can comprehend. You must have access to the Google Analytics account, property, and view (business name, division, and destination for your data) in order to accomplish this. To import your cost data, click Admin after you have chosen the account, property, and view (business name, division, and destination for your data). After selecting Admin, select the Data Import label under property. You should be able to add a new data set when a new screen appears. learn more
Click on the “+New Data Set” button, which should be red. An example of where you should begin setting up the data set is shown below. The data set type, name, and schema must now be filled up. Once more, the schema aids in converting the metric and dimension into a format that Google Analytics can comprehend. Decide what kind of data you want to import first, starting with the data set type. Since you are importing cost data in this instance, you would select cost data under Summary Data Import. Entering the data set’s details, including its name and the views you choose to display it in, comes next. Setting the data set schema would be the last stage. To accomplish this, select the columns—such as Click, Cost, Source, etc.—for which you wish to import data. You may now obtain your cost data after setting up the data set in Google Analytics.
Acquire Cost Information from the Source
Obtaining the pricing information directly from the source (such as Facebook Ads, Bing Ads, etc.) is the second stage. Remember that it ought to be a CSV file. To accomplish this, sign in to Bing Ads or another platform. There may probably be columns in the CSV file that need to be removed; these will be covered in the next steps. Now that you have the source’s cost data, you must correct the CSV file’s format.
Compare the CSV file to the data set schema
Configuring the CSV file to correspond with the data set format you produced in Google Analytics is the third step. The plan’s structure that connects the data you upload with the preexisting data is called a schema. Among the components of a schema are impressions, medium, source, clicks, and cost. However, an error would occur if these numbers were merely imported into Google Analytics. You have to translate it so that the schema matches.We must translate the metrics in order for Google Analytics to comprehend which metrics are part of your data. An illustration of a properly formatted header and schema can be found below. Any additional information from this schema will not function. Google Analytics searches for a match with the file you are importing in order to import data. The dimension and metric values linked to that data collection are appended to the current data upon finding a match. The second factor is to ensure that every named column is filled; no rows or columns should be vacant. You can now upload the CSV file to Google Analytics after matching or translating the schema.
Add a file to Google Analytics.
Uploading the cost data (CSV file) into Google Analytics is the fourth step. To import the cost data, select the account, property, and view in Google Analytics. To upload the cost data, click Manage Uploads on the data set you created after selecting Data Import under Admin. After that, select the file you want to upload to Google Analytics by clicking Upload File.
Cost Data File Status
Verifying the cost data’s current state is the fifth step. The file will upload in approximately 30 seconds. At first, it will say “pending.” You should be able to view the completed status beneath the data set you generated if the upload was successful. You ought to be able to see the mistakes you did if there is a failed status. You can upload the cost data again after making the necessary corrections in the CSV file.
How to access Google Analytics’ imported cost data
After you have successfully uploaded your cost data into Google Analytics, examined your data, and gotten familiar with it, then you can proceed into the next step, which is the sixth step. To do this, go into your reporting section in Google Analytics, having selected your desired account, property, or view. There should be a sidebar with numerous options on the left side of the screen in Google Analytics where you can view the cost data. Select acquisition, followed by campaigns, and lastly, cost analysis. Hopefully, you will be able to view the upload cost data under the source/medium you imported when the cost analysis appears. I suggest changing the date in Google Analytics to the date your expense data was uploaded if you don’t see it listed. If not, you should be able to view the precise cost information once the CSV file has been submitted.
In Conclusion
Business experts can save time and analyze data more effectively by importing cost data. When comparing it to other advertising and marketing platforms, importing cost data might completely alter a company’s ROI and campaign effectiveness. Save time and money by beginning to import your cost data. For additional guidance or information, get in touch with us right now or post a comment below!
