Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | campaigns_report_year | dim | |
| Year of week (Sun-Sat) | campaigns_report_year_of_week | dim | ||
| Year of week (Mon-Sun) | campaigns_report_year_of_week_iso | dim | ||
| Year & month | campaigns_report_year_month | dim | ||
| Month | campaigns_report_month | dim | ||
| Year & week (Sun-Sat) | campaigns_report_year_week | dim | ||
| Year & week (Mon-Sun) | campaigns_report_year_week_iso | dim | ||
| Week (Sun-Sat) | campaigns_report_week | dim | ||
| Week (Mon-Sun) | campaigns_report_week_iso | dim | ||
| Day of month | campaigns_report_day_of_month | dim | ||
| Day of week (Sun-Sat) | campaigns_report_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | campaigns_report_day_of_week_name_iso | dim | ||
| Date | campaigns_report_date | dim | ||
| Datetime | campaigns_report_atom | dim | ||
| Advertiser | Advertiser Name | campaigns_report_advertiser | dim | The name of the advertiser |
| Client Name | campaigns_report_client | dim | The name of the client | |
| Campaign | Campaign Name | campaigns_report_campaign | dim | The name of the campaign |
| Campaign ID | campaigns_report_campaign_id | dim | The ID of the campaign | |
| Campaign Creator Email | campaigns_report_campaign_creator | dim | The email of the campaign creator | |
| Campaign Creator Name | campaigns_report_campaign_creator_name | dim | The name of the campaign creator | |
| Ad | Ad Group Name | campaigns_report_ad_group | dim | The name of the ad group |
| Ad Group ID | campaigns_report_ad_group_id | dim | The ID of the ad group | |
| Ad Variation Title | campaigns_report_article_title | dim | The title of the ad variation | |
| Ad Variation ID | campaigns_report_variation_id | dim | The ID of the ad variation. | |
| Ad Variation Number | campaigns_report_variation_no | dim | The number of the ad variation | |
| Ad Image URL | campaigns_report_image_url | dim | The URL of the ad image | |
| Ad Theme | campaigns_report_theme | dim | The theme of the ad | |
| Ad Call-To-Action | campaigns_report_cta | dim | The CTA statement of the ad | |
| Ad Teaser | campaigns_report_text | dim | The teaser of the ad | |
| Click URL | campaigns_report_target_url | dim | The link that a visitor goes to when he/she clicks on the ad | |
| Ad Creation Date | campaigns_report_article_creation_date | dim | The date the ad was created | |
| Ad Creation Datetime | campaigns_report_article_creation_datetime | dim | The date and time the ad was created. | |
| Ad Update Date | campaigns_report_article_update_date | dim | The date the ad was updated | |
| Ad Update Datetime | campaigns_report_article_update_datetime | dim | The date and time the ad was updated | |
| Other | Publisher Name | campaigns_report_location | dim | The publisher that showed the impression |
| Currency | campaigns_report_currency | dim | ||
| Impressions | campaigns_report_impressions | met | The number of impressions | |
| Clicks | campaigns_report_clicks | met | The number of clicks | |
| CTR | campaigns_report_ctr | met | Click Through Rate, the percentage of ads that were clicked. Clicks / Impressions | |
| Spend | campaigns_report_spend | met | The amount of money was spent | |
| CPC | campaigns_report_cpc | met | Cost Per Click | |
| CPM | campaigns_report_cpm | met | Cost per 1000 impressions | |
| Spend in Campaign Currency | campaigns_report_spend_in_currency | met | The amount of money was spent in campaign | |
| CPC in Campaign Currency | campaigns_report_cpc_in_currency | met | Cost Per Click in Campaign Currency | |
| CPM in Campaign Currency | campaigns_report_cpm_in_currency | met | Cost per 1000 impressions in campaign currency |