Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time breakdown | Year | campaign_impressions_impressions__year | dim | Year. |
| Year & month | campaign_impressions_impressions__year_month | dim | Year & month. | |
| Month | campaign_impressions_impressions__month | dim | Month. | |
| Year & week (Mon-Sun) | campaign_impressions_impressions__year_week_iso | dim | Year & week (Monday-Sunday). | |
| Year & week (Sun-Sat) | campaign_impressions_impressions__year_week | dim | Year & week (Sunday-Saturday). | |
| Week (Mon-Sun) | campaign_impressions_impressions__week_iso | dim | Week (Monday-Sunday). | |
| Week (Sun-Sat) | campaign_impressions_impressions__week | dim | Week (Sunday-Saturday). | |
| Day of month | campaign_impressions_impressions__day_of_month | dim | Day of month. | |
| Day of week (Mon-Sun) | campaign_impressions_impressions__day_of_week_iso | dim | Day of week (Monday-Sunday). | |
| Day of week (Sun-Sat) | campaign_impressions_impressions__day_of_week | dim | Day of week (Sunday-Saturday). | |
| Date | campaign_impressions_impressions__date | dim | Date. | |
| Datetime | campaign_impressions_impressions__date_time | dim | Datetime. | |
| Campaign | Campaign ID | campaign_impressions_impressions__campaign_id | dim | ID of the campaign. |
| Campaign name | campaign_impressions_impressions__campaign_name | dim | Name of the campaign. | |
| Browser | Browser family | campaign_impressions_impressions__browser_family | dim | Browser family. |
| Browser major | campaign_impressions_impressions__browser_major | dim | Browser major. | |
| Browser minor | campaign_impressions_impressions__browser_minor | dim | Browser minor. | |
| Browser patch | campaign_impressions_impressions__browser_patch | dim | Browser patch. | |
| Creative | Creative ID | campaign_impressions_impressions__creative_id | dim | Creative ID. |
| Creative description | campaign_impressions_impressions__creative_description | dim | Creative description. | |
| Creative advertiser reference | campaign_impressions_impressions__creative_advertiser_reference | dim | Creative advertiser reference. | |
| Advertiser reference | campaign_impressions_impressions__advertiser_reference | dim | Advertiser reference. | |
| Device | Device ID | campaign_impressions_impressions__device_id | dim | ID of the device. |
| Device name | campaign_impressions_impressions__device_name | dim | Name of the device. | |
| Operating system | OS family | campaign_impressions_impressions__os_family | dim | Operating system family. |
| OS major | campaign_impressions_impressions__os_major | dim | Operating system major. | |
| OS minor | campaign_impressions_impressions__os_minor | dim | Operating system minor. | |
| OS patch | campaign_impressions_impressions__os_patch | dim | Operating system patch. | |
| Partner | Partner ID | campaign_impressions_impressions__partner_id | dim | ID of the partner. |
| Partner name | campaign_impressions_impressions__partner_name | dim | name of the partner. | |
| Partnership model ID | campaign_impressions_impressions__partnership_model_id | dim | Partnership model ID. | |
| Partnership model name | campaign_impressions_impressions__partnership_model_name | dim | Partnership model name. | |
| Traffic source | Traffic source ID | campaign_impressions_impressions__traffic_source_id | dim | Traffic source ID. |
| Traffic source name | campaign_impressions_impressions__traffic_source_name | dim | Traffic source name. | |
| User context | User context ID | campaign_impressions_impressions__user_context_id | dim | User context ID. |
| User context name | campaign_impressions_impressions__user_context_name | dim | User context name. | |
| Impressions | campaign_impressions_impressions__total_impressions | met | Total number of impressions. | |
| Time breakdown | Year | campaign_clicks_clicks__year | dim | Year. |
| Year & month | campaign_clicks_clicks__year_month | dim | Year & month. | |
| Month | campaign_clicks_clicks__month | dim | Month. | |
| Year & week (Mon-Sun) | campaign_clicks_clicks__year_week_iso | dim | Year & week (Monday-Sunday). | |
| Year & week (Sun-Sat) | campaign_clicks_clicks__year_week | dim | Year & week (Sunday-Saturday). | |
| Week (Mon-Sun) | campaign_clicks_clicks__week_iso | dim | Week (Monday-Sunday). | |
| Week (Sun-Sat) | campaign_clicks_clicks__week | dim | Week (Sunday-Saturday). | |
| Day of month | campaign_clicks_clicks__day_of_month | dim | Day of month. | |
| Day of week (Mon-Sun) | campaign_clicks_clicks__day_of_week_iso | dim | Day of week (Monday-Sunday). | |
| Day of week (Sun-Sat) | campaign_clicks_clicks__day_of_week | dim | Day of week (Sunday-Saturday). | |
| Date | campaign_clicks_clicks__date | dim | Date. | |
| Datetime | campaign_clicks_clicks__date_time | dim | Datetime. | |
| Campaign | Campaign ID | campaign_clicks_clicks__campaign_id | dim | ID of the campaign. |
| Campaign name | campaign_clicks_clicks__campaign_name | dim | Name of the campaign. | |
| Customer type | campaign_clicks_clicks__type | dim | Type of the customer. | |
| Browser | Browser family | campaign_clicks_clicks__browser_family | dim | Browser family. |
| Browser major | campaign_clicks_clicks__browser_major | dim | Browser major. | |
| Browser minor | campaign_clicks_clicks__browser_minor | dim | Browser minor. | |
| Browser patch | campaign_clicks_clicks__browser_patch | dim | Browser patch. | |
| Geolocation | Country code | campaign_clicks_clicks__country | dim | Country code. |
| Country name | campaign_clicks_clicks__country_name | dim | Country name. | |
| Creative | Creative ID | campaign_clicks_clicks__creative_id | dim | Creative ID. |
| Creative description | campaign_clicks_clicks__creative_description | dim | Creative description. | |
| Creative advertiser reference | campaign_clicks_clicks__creative_advertiser_reference | dim | Creative advertiser reference. | |
| Advertiser reference | campaign_clicks_clicks__advertiser_reference | dim | Advertiser reference. | |
| Device | Device ID | campaign_clicks_clicks__device_id | dim | ID of the device. |
| Device name | campaign_clicks_clicks__device_name | dim | Name of the device. | |
| Operating system (OS) | OS family | campaign_clicks_clicks__os_family | dim | Operating system family. |
| OS major | campaign_clicks_clicks__os_major | dim | Operating system major. | |
| OS minor | campaign_clicks_clicks__os_minor | dim | Operating system minor. | |
| OS patch | campaign_clicks_clicks__os_patch | dim | Operating system patch. | |
| Partner | Partner ID | campaign_clicks_clicks__partner_id | dim | ID of the partner. |
| Partner name | campaign_clicks_clicks__partner_name | dim | Name of the partner. | |
| Partnership model ID | campaign_clicks_clicks__partnership_model_id | dim | Partnership model ID. | |
| Partnership model name | campaign_clicks_clicks__partnership_model_name | dim | Partnership model name. | |
| Traffic source | Traffic source ID | campaign_clicks_clicks__traffic_source_id | dim | Traffic source ID. |
| Traffic source name | campaign_clicks_clicks__traffic_source_name | dim | Traffic source name. | |
| User context | User context ID | campaign_clicks_clicks__user_context_id | dim | User context ID. |
| User context name | campaign_clicks_clicks__user_context_name | dim | User context name. | |
| Clicks | campaign_clicks_clicks__total_clicks | met | Total number of clicks. | |
| Converted clicks | campaign_clicks_clicks__total_clicks_converted | met | Total number of converted clicks. | |
| Click conversion rate | campaign_clicks_clicks__click_conversion_rate | met | Click conversion rate (converted clicks / clicks). | |
| Unique clicks | campaign_clicks_clicks__total_unique_clicks | met | Total number of unique clicks. | |
| Time breakdown | Year | campaign_conversions_conversions__year | dim | Year. |
| Year & month | campaign_conversions_conversions__year_month | dim | Year & month. | |
| Month | campaign_conversions_conversions__month | dim | Month. | |
| Year & week (Mon-Sun) | campaign_conversions_conversions__year_week_iso | dim | Year & week (Monday-Sunday). | |
| Year & week (Sun-Sat) | campaign_conversions_conversions__year_week | dim | Year & week (Sunday-Saturday). | |
| Week (Mon-Sun) | campaign_conversions_conversions__week_iso | dim | Week (Monday-Sunday). | |
| Week (Sun-Sat) | campaign_conversions_conversions__week | dim | Week (Sunday-Saturday). | |
| Day of month | campaign_conversions_conversions__day_of_month | dim | Day of month. | |
| Day of week (Mon-Sun) | campaign_conversions_conversions__day_of_week_iso | dim | Day of week (Monday-Sunday). | |
| Day of week (Sun-Sat) | campaign_conversions_conversions__day_of_week | dim | Day of week (Sunday-Saturday). | |
| Date | campaign_conversions_conversions__date | dim | Date. | |
| Datetime | campaign_conversions_conversions__date_time | dim | Datetime. | |
| Campaign | Campaign ID | campaign_conversions_conversions__campaign_id | dim | ID of the campaign. |
| Campaign name | campaign_conversions_conversions__campaign_name | dim | Name of the campaign. | |
| Customer type | campaign_conversions_conversions__type | dim | Type of the customer. | |
| Currency | campaign_conversions_conversions__currency | dim | Currency code. | |
| Product category | campaign_conversions_conversions__category | dim | Product category. | |
| Browser | Browser family | campaign_conversions_conversions__browser_family | dim | Browser family. |
| Browser major | campaign_conversions_conversions__browser_major | dim | Browser major. | |
| Browser minor | campaign_conversions_conversions__browser_minor | dim | Browser minor. | |
| Browser patch | campaign_conversions_conversions__browser_patch | dim | Browser patch. | |
| Conversion | Conversion metric ID | campaign_conversions_conversions__conversion_metric_id | dim | Conversion metric ID. |
| Conversion metric name | campaign_conversions_conversions__conversion_metric_name | dim | Conversion metric name. | |
| Conversion reference | campaign_conversions_conversions__conversion_reference | dim | Conversion reference. | |
| Conversion status | campaign_conversions_conversions__conversion_status | dim | Conversion status. | |
| Conversion type ID | campaign_conversions_conversions__conversion_type_id | dim | Conversion type ID. | |
| Conversion type name | campaign_conversions_conversions__conversion_type_name | dim | Conversion type name. | |
| Geolocation | Country | campaign_conversions_conversions__country | dim | Country code. |
| Country name | campaign_conversions_conversions__country_name | dim | Country name. | |
| Creative | Creative ID | campaign_conversions_conversions__creative_id | dim | Creative ID. |
| Creative description | campaign_conversions_conversions__creative_description | dim | Creative description. | |
| Creative advertiser reference | campaign_conversions_conversions__creative_advertiser_reference | dim | Creative advertiser reference. | |
| Customer reference | campaign_conversions_conversions__customer_reference | dim | Customer reference. | |
| Customer type | campaign_conversions_conversions__customer_type | dim | Type of the. | |
| Advertiser reference | campaign_conversions_conversions__advertiser_reference | dim | Advertiser reference. | |
| SKU | campaign_conversions_conversions__sku | dim | Stock Keeping Unit. | |
| Device | Device ID | campaign_conversions_conversions__device_id | dim | Device ID. |
| Device name | campaign_conversions_conversions__device_name | dim | Device name. | |
| Operating system | OS family | campaign_conversions_conversions__os_family | dim | Operating system family. |
| OS major | campaign_conversions_conversions__os_major | dim | Operating system major. | |
| OS minor | campaign_conversions_conversions__os_minor | dim | Operating system minor. | |
| OS patch | campaign_conversions_conversions__os_patch | dim | Operating system patch. | |
| Partner | Partner ID | campaign_conversions_conversions__partner_id | dim | ID of the partner. |
| Partner name | campaign_conversions_conversions__partner_name | dim | Partner name. | |
| Partnership model ID | campaign_conversions_conversions__partnership_model_id | dim | Partnership model ID. | |
| Partnership model name | campaign_conversions_conversions__partnership_model_name | dim | Partnership model name. | |
| Traffic source | Traffic source ID | campaign_conversions_conversions__traffic_source_id | dim | Traffic source ID. |
| Traffic source name | campaign_conversions_conversions__traffic_source_name | dim | Traffic source name. | |
| User context | User context ID | campaign_conversions_conversions__user_context_id | dim | User context ID. |
| User context name | campaign_conversions_conversions__user_context_name | dim | User context name. | |
| Voucher | Voucher code | campaign_conversions_conversions__voucher_code | dim | Voucher code. |
| Voucher status | campaign_conversions_conversions__voucher_status | dim | Voucher status. | |
| Voucher status name | campaign_conversions_conversions__voucher_status_name | dim | Voucher status name. | |
| Conversions | campaign_conversions_conversions__total_conversions | met | Total number of conversions. | |
| Conversion items | campaign_conversions_conversions__total_conversion_items | met | Total number of conversion items. | |
| Total commission | campaign_conversions_conversions__total_commission | met | Total commission for approved, rejected & pending commissions. | |
| Partner commission | campaign_conversions_conversions__total_partner_commission | met | Total partner commission. | |
| Total order value | campaign_conversions_conversions__total_order_value | met | Total order value. | |
| Average order value | campaign_conversions_conversions__average_order_value | met | Average order value (total order value / conversions). | |
| eCPA | campaign_conversions_conversions__e_cpa | met | Effective cost per action (total commission / conversions). | |
| ROAS | campaign_conversions_conversions__roas | met | Return on advertising spend (total order value / commission). | |
| Average order size | campaign_conversions_conversions__average_order_size | met | Average order size. |