In Google Analytics, go to the “Admin” page. In the “Property” column, click “Data Import”. You need to create a new Data Set.
Click the “Create” button. As a “Data Set type”, select “Cost Data”. In “Data Set details”, type in the new Data Set name. Select the views that will use data from the Data Set. In “Data Set schema”, add the following columns: “Clicks”, “Cost”, “Impressions”, “Content”, “Campaign”, “Keyword”. As “Import behavior”, select “Summation”. That’s it. Now you have a Data Set you need to setup a cost data import Pipeline in OWOX BI Let’s now adjust the Pipeline.
Go to the bi.owox.com page. In the Pipeline block, click “Create pipeline”. Select the ad service you want to export cost data from. Provide access to the ad service account
(or select the existing one). Provide access to your Google Analytics account
(or select the existing one). Select a Google Analytics property and data set. Select the Google Analytics view to display the imported cost data. Click “Create”. Great work! Now, your ad cost data is being uploaded to Google Analytics.