NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.
You will get the data in the table 'BlendedAdSpend' (with partitioning by date field by days) with the schema below:
| Field name | Type | |
|---|---|---|
utmId |
STRING | The main component of schema, that allows Non-Google costs to be matched with website's traffic. More about utm_id. |
source |
STRING | The source of the ad costs. |
medium |
STRING | The medium of the ad costs. |
campaign |
STRING | The campaign of the ad costs. |
keyword |
STRING | The keyword of the ad costs. |
adContent |
STRING | The adContent of the ad costs. |
adGroup |
STRING | The ad group name of the ad costs. Please note that the field is only applicable for google / cpc |
date |
DATE | The date is formatted as YYYY-MM-DD. |
adCost |
FLOAT | The sum of ad costs. |
impressions |
INTEGER | The total number of impressions. |
adClicks |
INTEGER | Total number of times users have clicked on an ad to reach the property. |
currency |
STRING | The code of a currency. |
adAccount |
STRING | Contains info about the source ad account. |
changedTime |
INTEGER | Time, when this information was written to table. Can be used for analysis and for some datamarts. |
dataSource |
STRING | The source of data. |
campaignType |
STRING | The type of ad campaign the costs were spent on. |
campaignId |
STRING | The ID of ad campaign the costs were spent on. |
campaignName |
STRING | The name of ad campaign the costs were spent on. |
adGroupId |
STRING | The ad group ID. |
adGroupName |
STRING | The ad group name. |
adSource |
STRING | Data source. |
pipelineId |
STRING | Internal technical information. |
0 Comments