Uploading costs to Google Analytics¶
Go to the “Integrations” tab in the R7K12 interface. In the “Data upload” section, select Google Analytics.
To create a cost export, you must have an integration with at least one advertising system. You can learn how to create integrations with advertising systems for exporting costs in the Integrations with advertising systems section.
Choose to show “All”, then use your mouse to select the accounts whose costs need to be uploaded to Google Analytics. Click the “Next” button. We recommend creating a separate import into a separate data set for each advertising system.
The next step is to select a Google Analytics account.
A warning will appear saying that the dialog for adding an account will open. Sign in.
Next, you need to select a property, a data set, and a view. If you do not have a data set for importing costs, you need to create one. Go to the “Admin” tab in the Google Analytics interface.
Then, in the property settings, go to “Data Import”.
After that, click the “Create” button.
Select the “Cost Data” option and click the “Next” button.
Now enter a convenient name for the data set in the “Name” field and select the views. Click the “Next” button.
In the data set schema, select 3 additional columns: Cost, Number of clicks, Number of impressions.
Scrolling further down, set three more columns: Campaign, Keyword, Ad Content.
For the import behavior, select “Summation” and click the “Save” button.
Now, in the R7K12 interface, specify the property, the data set, and the required view. Click the “Next” button.
The last step is to specify the start date for the data upload. Cost data can be exported for the last 90 days. After that, click the “Save” button.
You can also export data from our system to Google BigQuery. Learn more about the integration in the R7K12 Integration with Google BigQuery section.