Try out all OWOX BI features with a trial period Start for free

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.

Scheme №1: Cost data from Google Analytics (used until February 12, 2021)

Under this scheme, the Google Analytics Cost Data → Google BigQuery pipelines import the following data:

  • Google Ads costs collected to the connected Google Analytics property via the native Google integration.
    Note that under this scheme, the adSource, campaignId, campaignName, adGroupId, adGroupName, and adAccount fields will contain NULL for all Google Ads costs imported to Google BigQuery.
  • Cost data collected to Google Analytics via the Ad platforms → Google Analytics pipelines.

Scheme №2: Google Ads costs from Google Analytics + cost data from Google BigQuery (used from February 12, 2021)

Google Analytics Cost Data → Google BigQuery pipelines, created within the current scheme, import:

  • 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.

OWOX BI automatically updates information in the CostData_ tables within a preset actualization period.
If you have questions about data import into the CostData_ tables, 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.