Data is exported to a separate table each day. Tables are saved with name in format 'CostData_YYYYMMDD'.
Table schema
| Google BigQuery alias | Google BigQuery data type | Google Analytics dimension or metric |
source |
STRING | Source |
medium |
STRING | Medium |
campaign |
STRING | Campaign |
keyword |
STRING | Keyword |
adContent |
STRING | Ad Content |
date |
STRING | Date |
sessions |
INTEGER | Sessions |
adCost |
FLOAT | Cost |
impressions |
INTEGER | Impressions |
adClicks |
INTEGER | Clicks |
0 Comments