Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | advertiser_year | dim | |
| Year of week (Sun-Sat) | advertiser_year_of_week | dim | ||
| Year of week (Mon-Sun) | advertiser_year_of_week_iso | dim | ||
| Year & month | advertiser_year_month | dim | ||
| Month | advertiser_month | dim | ||
| Year & week (Sun-Sat) | advertiser_year_week | dim | ||
| Year & week (Mon-Sun) | advertiser_year_week_iso | dim | ||
| Week (Sun-Sat) | advertiser_week | dim | ||
| Week (Mon-Sun) | advertiser_week_iso | dim | ||
| Day of month | advertiser_day_of_month | dim | ||
| Day of week (Sun-Sat) | advertiser_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | advertiser_day_of_week_name_iso | dim | ||
| Date | advertiser_date | dim | ||
| Datetime | advertiser_atom | dim | ||
| Advertiser | Advertiser ID | advertiser_advertiser_id | dim | The ID of the advertiser |
| Advertiser name | advertiser_advertiser_name | dim | The name of the advertiser | |
| Campaign | Campaign ID | advertiser_campaign_id | dim | The ID of the campaign |
| Campaign name | advertiser_campaign_name | dim | The name of the campaign | |
| Campaign budget | advertiser_campaign_budget | dim | The budget set for the campaign | |
| Campaign start date | advertiser_campaign_start_date | dim | The start date of the campaign | |
| Campaign end date | advertiser_campaign_end_date | dim | The end date of the campaign | |
| Campaign bid amount | advertiser_campaign_bid_amount | dim | The bid amount of the campaign | |
| Budget type | advertiser_budget_type | dim | The budget type | |
| Line item | Line item ID | advertiser_line_item_id | dim | The ID of the line item |
| Line item name | advertiser_line_item_name | dim | The name of the line item | |
| Line item start date | advertiser_line_item_start_date | dim | The start date of the line item | |
| Line item end date | advertiser_line_item_end_date | dim | The end date of the line item | |
| Line item bid amount | advertiser_line_item_bid_amount | dim | The bid amount of the line item | |
| Line item budget | advertiser_line_item_budget | dim | The budget set for the line item | |
| Creative | Creative ID | advertiser_creative_id | dim | The ID of the creative |
| Creative name | advertiser_creative_name | dim | The name of the creative | |
| Creative size | advertiser_creative_size | dim | The size of the creative | |
| Creative URL | advertiser_creative_url | dim | The URL address of the creative | |
| Geo | Metro (DMA) | advertiser_metro | dim | |
| Country | advertiser_country | dim | ||
| Region | advertiser_region | dim | ||
| Age and gender | Age | advertiser_age | dim | |
| Gender | advertiser_gender | dim | ||
| Device | Device type | advertiser_device_type | dim | The type of the device |
| Operating system | advertiser_operating_system | dim | The operating system | |
| Browser | advertiser_browser | dim | The browser that was used | |
| Other | Publisher ID | advertiser_publisher_id | dim | The ID of the publisher |
| Demand type | advertiser_demand_type | dim | The type of the demand | |
| Guaranteed | advertiser_guaranteed | dim | ||
| Pacing | advertiser_pacing | dim | ||
| Status | advertiser_status | dim | ||
| ClickThrough URL | advertiser_clickthough_url | dim | The URL of the click-through. | |
| Impressions | advertiser_impressions | met | The number of impressions | |
| Clicks | advertiser_clicks | met | The number of clicks | |
| CTR | advertiser_ctr | met | The percentage of ads that were clicked. Clicks / Impressions | |
| Advertiser spent (USD) | advertiser_advertiser_spent | met | The amount spent on advertising. | |
| Advertiser spent (EUR) | advertiser_advertiser_spent_usd_to_eur | met | The amount spent converted to EUR. | |
| Advertiser spent (GBP) | advertiser_advertiser_spent_usd_to_gbp | met | The amount spent converted to GBP. | |
| eCPM | advertiser_cpm | met | Cost per 1000 impressions | |
| eCPC | advertiser_cost_per_click | met | The cost per click. Advertiser spent / Clicks | |
| Conversions (PCC) | advertiser_conversions_pcc | met | Post click conversions. The number of conversions that occurred after a user clicked a LiveIntent ad within the post click attribution window selected | |
| Conversions (PVC) | advertiser_conversions_pvc | met | Post view conversions. The number of conversions that occurred after a user was delivered an impressions but did not click on a LiveIntent Ad within the post view attribution window selected | |
| Total conversions | advertiser_total_conversions | met | The sum of post click conversions (PCC) and post view conversions (PVC). It is calculated as Conversions (PCC) + Conversions (PVC) | |
| Conversion rate | advertiser_conversion_rate | met | The percentage of users who completed a desired action (conversion). Total conversions / Impressions | |
| CCR | advertiser_ccr | met | Click-to-Conversion Rate. Conversions (PCC) / Clicks. | |
| ROAS | advertiser_roas | met | Return of ad spend. User purchase amount (Total) / Advertiser spent. | |
| User purchase amount (PCC) | advertiser_upa_pcc | met | The amount spent on a product or a service | |
| User purchase amount (PVC) | advertiser_upa_pvc | met | The amount spent on a product or a service | |
| User purchase amount (Total) | advertiser_upa_total | met | The total amount spent on a product or a service |