Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | data_year | dim | |
| Year of week (Sun-Sat) | data_year_of_week | dim | ||
| Year of week (Mon-Sun) | data_year_of_week_iso | dim | ||
| Year & month | data_year_month | dim | ||
| Month | data_month | dim | ||
| Year & week (Sun-Sat) | data_year_week | dim | ||
| Year & week (Mon-Sun) | data_year_week_iso | dim | ||
| Week (Sun-Sat) | data_week | dim | ||
| Week (Mon-Sun) | data_week_iso | dim | ||
| Day of month | data_day_of_month | dim | ||
| Day of week (Sun-Sat) | data_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | data_day_of_week_name_iso | dim | ||
| Date | data_date | dim | ||
| Datetime | data_atom | dim | ||
| Campaign | Campaign name | data_campaign_name | dim | Name of the campaign. |
| Campaign ID | data_campaign_id | dim | ID of the campaign. | |
| Ad set name | data_ad_set_name | dim | Name of the ad set. | |
| Ad set ID | data_ad_set_id | dim | ID of the ad set. | |
| Creative name | data_creative_name | dim | Name of the creative. | |
| Creative ID | data_creative_id | dim | ID of the creative. | |
| Geographic | Country | data_geo_country | dim | Geo country. |
| Region | data_geo_region | dim | Geo region. | |
| Demographic | Age | data_age | dim | Age of the users. |
| Gender | data_gender | dim | Gender of users. | |
| Delivery | Device type | data_device_type | dim | Device type. |
| Impressions | data_impressions | met | Number of impressions. | |
| Creative spend | data_spend | met | Total cost spent on creative. | |
| Survey spend | data_survey_spend | met | Total cost spent on surveys. | |
| Amount spent | data_amount_spent | met | Total spent on campaigns. It is calculated as Creative spend + Survey spend. | |
| Budget delivered | data_budget_delivered | met | All in-platform budget delivered within the selected date range is included. Data is subject to change and is not necessarily used for billing purposes. | |
| CPM | data_cpm | met | Cost Per Thousand, using the Latin “Mille” instead of thousand. The amount an advertiser pays a website for every thousand times a brand’s ad is shown. Calculated as 1000 x total cost (or budget) / impressions. | |
| Clicks | data_clicks | met | The number of clicks. | |
| CTR | data_ctr | met | Click-through rate. Calculated as clicks / impressions. | |
| Creative media fees | data_media_fees | met | Total cost for creative media. | |
| Creative non media fees | data_non_media_fees | met | Total cost for creative non media. | |
| Survey media fees | data_survey_media_fees | met | Total cost for survey media. | |
| Survey non media fees | data_survey_non_media_fees | met | Total cost for survey non media. | |
| Inventory cost | data_inventory_cost | met | Total cost for inventory. | |
| Results | data_results | met | Number of results. | |
| Click results | data_click_results | met | Number of results coming from users who clicked the ad. | |
| View results | data_view_results | met | Number of results coming from users who saw the ad. | |
| Cost per result | data_cpa | met | Cost per result. It is calculated as Creative spend / Results. | |
| Revenue | data_revenue | met | Revenue is the money generated from normal business operations, calculated as the average sales price times the number of units sold. | |
| ROAS | data_roas | met | Return on ad spend. The amount of revenue generated by all customers who made a purchase and received advertising messaging). It is calculated as Revenue / Creative spend. | |
| 100% completion rate | data_completion_rate | met | Full completion rate. It is calculated as Completed views / Impressions. | |
| Completed views | data_completed_views | met | Number of views that were completed. | |
| CPCV | data_cpcv_local | met | Cost Per Completed View. It is calculated as Creative spend / Completed views. | |
| Completed views (Audible & Visible) | data_avoc | met | Audible and Visible On Complete. | |
| 100% completion rate (Audible & Visible) | data_avoc_rate | met | Completion rate (Audible & Visible). It is calculated as Completed views (Audible & Visible) / Impressions. | |
| CPCV (Audible & visible) | data_avoc_cpcv_local | met | Cost per completed view (audible & visible). It is calculated as Creative spend / Completed views (Audible & Visible). | |
| Creative agency fee | data_agency_fees | met | Total creative agency cost. | |
| Survey agency fees | data_survey_agency_fees | met | Total survey agency cost. | |
| Net creative spend | data_net_spend | met | Total cost for creative (net). | |
| Net survey spend | data_survey_net_spend | met | Total cost for survey (net). | |
| Net CPM | data_net_cpm | met | Cost per mille/thousand (net). It is calculated as 1000 * (Net survey spend + Net creative spend) / Impressions. | |
| Net Cost per result | data_net_cpa | met | Net cost per result. It is calculated as Net creative spend / results. | |
| Net ROAS | data_net_roas | met | Return on ad spend (net). It is calculated as Revenue / Net creative spend. | |
| Net CPCV | data_net_cpcv | met | Cost Per Completed View (net). | |
| NET CPCV (Audible & Visible) | data_net_avoc_cpcv_local | met | Cost Per Completed View audible & visible (net). |