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.

Under scheme GA_NATIVE_PLUS_GBQ, all the ad costs from the connected pipelines will be converted to the currency of Google Analytics View you set in your Cost Data pipeline. Also, OWOX BI automatically updates CostData_ tables within a preset actualization period if you change this View currency.

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 from this article.

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.