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. 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 |
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.
0 Comments