Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | performance_year | dim | |
| Year of week (Sun-Sat) | performance_year_of_week | dim | ||
| Year of week (Mon-Sun) | performance_year_of_week_iso | dim | ||
| Year & month | performance_year_month | dim | ||
| Month | performance_month | dim | ||
| Year & week (Sun-Sat) | performance_year_week | dim | ||
| Year & week (Mon-Sun) | performance_year_week_iso | dim | ||
| Week (Sun-Sat) | performance_week | dim | ||
| Week (Mon-Sun) | performance_week_iso | dim | ||
| Day of month | performance_day_of_month | dim | ||
| Day of week (Sun-Sat) | performance_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | performance_day_of_week_name_iso | dim | ||
| Date | performance_date | dim | ||
| Datetime | performance_atom | dim | ||
| Advertiser | Advertiser name | performance_advertiser_name | dim | Name of the advertiser. |
| Advertiser hash | performance_advertiser_hash | dim | Advertiser hash value. | |
| Subcampaign | Subcampaign name | performance_subcampaign_name | dim | Name of the subcampaign |
| Subcampaign hash | performance_subcampaign_hash | dim | Subcampaign hash value | |
| Creative | Creative name | performance_creative_name | dim | Creative name |
| Creative hash | performance_creative_hash | dim | Creative hash value | |
| Creative status | performance_creative_status | dim | Creative status | |
| Creative type | performance_creative_type | dim | Creative type | |
| Creative created at | performance_creative_created_at | dim | Date and time when the creative was created | |
| Creative updated at | performance_creative_updated_at | dim | Date and time when the creative was updated | |
| Creative width | performance_creative_width | dim | Creative width | |
| Creative height | performance_creative_height | dim | Creative height | |
| Category | Category name | performance_category_name | dim | Category name |
| Category hash | performance_category_hash | dim | Category hash value | |
| Other | Device type | performance_device_type | dim | Type of device |
| Country | performance_country | dim | Country | |
| Currency | performance_currency | dim | The currency code of the account. | |
| User segment | performance_user_segment | dim | User segment | |
| Impressions | performance_impression_count | met | The number of times your ad has been displayed on a screen. | |
| Cost | performance_cost | met | Campaign cost. | |
| Clicks | performance_clicks_count | met | Number of clicks. | |
| Conversions | performance_conversions_count | met | The number of conversions. | |
| Conversion value | performance_conversions_value | met | The monetary impact of your conversions. | |
| CTR | performance_ctr | met | Clicks / Impressions | |
| Conversion rate | performance_cr | met | Conversions / Clicks | |
| eCPM | performance_ecpm | met | Effective Cost Per Mille: (Cost / Impressions) * 1000. | |
| eCPC | performance_ecpc | met | Effective Cost Per Click: Cost / Clicks | |
| eCPA | performance_ecpa | met | Effective Cost Per Action: Cost / Conversions | |
| ROAS | performance_roas | met | Return on ad spend: Conversion value / Cost | |
| Time | Year | branding_year | dim | |
| Year of week (Sun-Sat) | branding_year_of_week | dim | ||
| Year of week (Mon-Sun) | branding_year_of_week_iso | dim | ||
| Year & month | branding_year_month | dim | ||
| Month | branding_month | dim | ||
| Year & week (Sun-Sat) | branding_year_week | dim | ||
| Year & week (Mon-Sun) | branding_year_week_iso | dim | ||
| Week (Sun-Sat) | branding_week | dim | ||
| Week (Mon-Sun) | branding_week_iso | dim | ||
| Day of month | branding_day_of_month | dim | ||
| Day of week (Sun-Sat) | branding_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | branding_day_of_week_name_iso | dim | ||
| Date | branding_date | dim | ||
| Datetime | branding_atom | dim | ||
| Advertiser | Advertiser name | branding_advertiser_name | dim | Name of the advertiser. |
| Advertiser hash | branding_advertiser_hash | dim | Advertiser hash value. | |
| Subcampaign | Subcampaign name | branding_subcampaign_name | dim | Name of the subcampaign. Not compatible with Frequency and Reach metrics. |
| Subcampaign hash | branding_subcampaign_hash | dim | Subcampaign hash value. Not compatible with Frequency and Reach metrics. | |
| Creative | Creative name | branding_creative_name | dim | Creative name. Not compatible with Frequency and Reach metrics. |
| Creative hash | branding_creative_hash | dim | Creative hash value. Not compatible with Frequency and Reach metrics. | |
| Creative status | branding_creative_status | dim | Creative status. Not compatible with Frequency and Reach metrics. | |
| Creative type | branding_creative_type | dim | Creative type. Not compatible with Frequency and Reach metrics. | |
| Creative created at | branding_creative_created_at | dim | Date and time when the creative was created. Not compatible with Frequency and Reach metrics. | |
| Creative updated at | branding_creative_updated_at | dim | Date and time when the creative was updated. Not compatible with Frequency and Reach metrics. | |
| Creative width | branding_creative_width | dim | Creative width. Not compatible with Frequency and Reach metrics. | |
| Creative height | branding_creative_height | dim | Creative height. Not compatible with Frequency and Reach metrics. | |
| Other | Device type | branding_device_type | dim | Type of device. Not compatible with Viewability metric. |
| Country | branding_country | dim | Country. Not compatible with Viewability, Frequency or Reach metrics. | |
| Currency | branding_currency | dim | The currency code of the account. | |
| Impressions | branding_impression_count | met | The number of times your ad has been displayed on a screen. | |
| Cost | branding_cost | met | Campaign cost. | |
| Clicks | branding_clicks_count | met | Number of clicks. | |
| Completed video views | branding_completed_views | met | The number of completed video views. | |
| CTR | branding_ctr | met | Clicks / Impressions. | |
| eCPM | branding_ecpm | met | Effective Cost Per Mille: (Cost / Impressions) * 1000. | |
| eCPC | branding_ecpc | met | Effective Cost Per Click: Cost / Clicks. | |
| eCPCV | branding_ecpv | met | Effective Cost Per Completed View: Cost / Completed video views. | |
| VCR | branding_vcr | met | Video Completion Rate: Completed video views / Impressions | |
| Viewability | branding_viewability | met | Share of impressions that were considered viewable. | |
| Frequency | branding_user_frequency | met | The average number of times each person viewed your ad. | |
| Reach | branding_user_reach | met | The total number of people who have seen your ad or content. |