Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | campaign_stats__year | dim | |
| Year of week (Sun-Sat) | campaign_stats__year_of_week | dim | ||
| Year of week (Mon-Sun) | campaign_stats__year_of_week_iso | dim | ||
| Year & month | campaign_stats__year_month | dim | ||
| Month | campaign_stats__month | dim | ||
| Year & week (Sun-Sat) | campaign_stats__year_week | dim | ||
| Year & week (Mon-Sun) | campaign_stats__year_week_iso | dim | ||
| Week (Sun-Sat) | campaign_stats__week | dim | ||
| Week (Mon-Sun) | campaign_stats__week_iso | dim | ||
| Day of month | campaign_stats__day_of_month | dim | ||
| Day of week (Sun-Sat) | campaign_stats__day_of_week_name | dim | ||
| Day of week (Mon-Sun) | campaign_stats__day_of_week_name_iso | dim | ||
| Date | campaign_stats__date | dim | ||
| Datetime | campaign_stats__atom | dim | ||
| Client | Client name | campaign_client_name | dim | Name of the client. |
| Client ID | campaign_brand__client_id | dim | ID of the client. | |
| Brand name | campaign_brand__brand_name | dim | Name of the brand. | |
| Brand ID | campaign_brand__brand_id | dim | ID of the brand. | |
| Campaign | Campaign name | campaign_campaign_name | dim | Name of the campaign. |
| Campaign ID | campaign_campaign_id | dim | ID of the campaign. | |
| Initiative name | campaign_initiative_name | dim | Initiative name of the campaign. | |
| Campaign start date | campaign_start_date | dim | The first day of the campaign. | |
| Campaign end date | campaign_end_date | dim | The last day of the campaign. | |
| Campaign status | campaign_status | dim | The campaign's status: Planning, Live, or Approved. | |
| Line item | Line item name | campaign_line_item__line_item_name | dim | Name of the line item. |
| Line item ID | campaign_line_item__line_item_id | dim | ID of the line item. | |
| Impressions | campaign_stats__impressions | met | The gross number of impressions won. | |
| Clicks | campaign_stats__clicks | met | Gross number of clicks. | |
| CTR | campaign_stats__click_through_rate | met | Click-Through Rate (Click/ Impressions). | |
| Gross total spend | campaign_stats__total_spend | met | Total amount spend on media, ad serving and data including margin or markup. | |
| eCPM | campaign_stats__ecpm | met | Effective cost per 1000 imps (Total spend/ Impressions * 1000). | |
| eCPC | campaign_stats__ecpc | met | Effective cost-per-click (Total spend/ clicks). | |
| Net ad server spend | campaign_stats__ad_serving_spend | met | Amount of spend on ad serving. | |
| Net data spend | campaign_stats__data_spend | met | Detailed Net and Gross: Amount spent on audience data. | |
| Net inventory spend | campaign_stats__inventory_spend | met | Net inventory spend. | |
| Net media spend | campaign_stats__media_spend | met | Net media spend. | |
| Conversions | campaign_stats__total_conversions | met | Total conversion. | |
| CTC (click-through conversions) | campaign_stats__click_through_conversion | met | Click-Through conversion: Conversion recorded after user clicked an ad (Conversions/ Click conversions). | |
| Click conversions | campaign_stats__click_conversions | met | Total click conversions. | |
| eCPA | campaign_stats__ecpa | met | Effective cost per action (Total spend/ Conversions). | |
| Delivered units | campaign_stats__delivered_units | met | Delivered units. | |
| Number of interacts | campaign_stats__interactions | met | Total number of interactions. | |
| Video starts | campaign_stats__video_starts | met | The number of times the audio or video ads was started to be viewed. | |
| AV 100% | campaign_stats__video_completions | met | The number of times the audio or video ads was view to completion. | |
| AV completion rate | campaign_stats__video_complete_rate | met | AV complete rate. (AV 100% / Av starts). | |
| Viewed | campaign_stats__total_view_conversions | met | Total view conversions. | |
| eCPCV | campaign_stats__ecpcv | met | Effective cost per completed video. Cost of a running video to completion (Total spend/ AV 100%). | |
| eCPV | campaign_stats__ecpv | met | Effective cost per visitor. (Total spend/ Total view conversions). |