Supported cost data sources (CostData_ tables)

OWOX BI supports two schemes of the cost data import via the Google Analytics Cost Data → Google BigQuery pipeline. Below, we will describe each scheme in detail.

GA_NATIVE_PLUS_GBQ

Under this scheme, the Google Analytics Cost Data → Google BigQuery pipeline imports the next data:

  • Google Ads costs collected to the connected Google Analytics property via the native Google integration.
    Note, if you tag your Google Ads campaigns manually, make sure you define source and medium as follows: "source = google", "medium ≠ organic". Otherwise, Google Ads costs won't be imported to Google BigQuery.
  • Cost data collected to Google BigQuery via the Ad platforms → Google BigQuery pipelines.
    Note, to import cost data into the CostData_ tables, you should connect the required Ad platform → Google BigQuery pipelines with your Google Analytics Cost Data → Google BigQuery pipeline. Find the instructions here.

GA_NATIVE%2BGBQ.png

OWOX BI automatically updates the imported data if it changes in your ad account. Learn more about data actualization from this article.

GA_ONLY

Under this scheme, the Google Analytics Cost Data → Google BigQuery pipeline imports the following data:

GA_ONLY.png

Note that the adSource, campaignId, campaignName, adGroupId, adGroupName, and adAccount fields will contain NULL for all the imported ad costs.

OWOX BI automatically updates the imported data if it changes in your ad account. Learn more about data actualization.

To read about the currency OWOX BI uses to store data in the CostData_ tables, navigate to this article.

If you have any questions, contact us at bi@owox.com.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.