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

Data is exported to a separate table each day. Tables are saved with name in format 'CostData_YYYYMMDD'.

Table schema

Google BigQuery field name Google BigQuery data type Description / Google Analytics dimension or metric
source STRING Source
medium STRING Medium
campaign STRING Campaign
keyword STRING Keyword
adContent STRING Ad Content
date STRING Date
adCost FLOAT Cost
impressions INTEGER Impressions
adClicks INTEGER Clicks
adAccount STRING Contains info about the source ad account:
1) from the adGroup field when the non-Google costs are uploaded to Google Analytics via OWOX BI;
2) from the AdAccount field when the non-Google costs are uploaded to Google BigQuery via OWOX BI.
adSource STRING Name of ad platform
campaignId STRING The campaign ID
campaignName STRING The campaign name
campaignType STRING

The type of ad campaign the costs were spent on. Thanks to this field, OWOX BI can filter out mobile ad traffic while attributing session cost.
Possible values:
APP: mobile app ad costs
WEB: website traffic ad costs
null: couldn't identify the type of campaign

The campaign type is identified only when:

1) the cost data was imported from another Google BigQuery table to which it was collected via an OWOX BI campaign;

2) the cost data refers to Google Ads and was imported via BigQuery Data Transfer Service for Google Ads.

The APP-type cost data will not be attributed to sessions in the session data table.

adGroup STRING The ad group
adGroupId STRING The ad group ID
adGroupName STRING The ad group name
dataSource  STRING Internal technical information

Notethe adSource, campaignId, campaignName, adGroupId, adGroupName, and adAccount fields contain NULL for Google Ads costs uploaded to Google BigQuery via OWOX BI.

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

0 Comments

Please sign in to leave a comment.