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_performance_year | dim | |
| Year of week (Sun-Sat) | campaign_performance_year_of_week | dim | ||
| Year of week (Mon-Sun) | campaign_performance_year_of_week_iso | dim | ||
| Year & month | campaign_performance_year_month | dim | ||
| Month | campaign_performance_month | dim | ||
| Year & week (Sun-Sat) | campaign_performance_year_week | dim | ||
| Year & week (Mon-Sun) | campaign_performance_year_week_iso | dim | ||
| Week (Sun-Sat) | campaign_performance_week | dim | ||
| Week (Mon-Sun) | campaign_performance_week_iso | dim | ||
| Day of month | campaign_performance_day_of_month | dim | ||
| Day of week (Sun-Sat) | campaign_performance_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | campaign_performance_day_of_week_name_iso | dim | ||
| Date | campaign_performance_date | dim | ||
| Datetime | campaign_performance_atom | dim | ||
| Campaign | Campaign name | campaign_performance_campaign_name | dim | Name of the campaign. |
| Campaign ID | campaign_performance_campaign_id | dim | ID of the campaign. | |
| Campaign type | campaign_performance_campaign_type | dim | Type of the campaign. | |
| Campaign status | campaign_performance_campaign_status | dim | Status of the campaign. | |
| Budget pacing | campaign_performance_budget_pacing | dim | Budget pacing. | |
| From new platform | campaign_performance_new_platform | dim | Is campaign from new platform. | |
| Creative type | campaign_performance_creative_type | dim | Creative type. | |
| Campaign timezone | campaign_performance_campaign_timezone | dim | Timezone of the campaign. | |
| Campaign start date & time | campaign_performance_start_datetime | dim | Start time and date of the campaign. | |
| Campaign start date | campaign_performance_start_date | dim | Start date of the campaign. | |
| Campaign end date & time | campaign_performance_end_datetime | dim | End time and date of the campaign. | |
| Campaign end date | campaign_performance_end_date | dim | End date of the campaign. | |
| Impressions | campaign_performance_impressions | met | Number of times ad displayed on someone's screen. | |
| Clicks | campaign_performance_clicks | met | Number of times someone clicks your ad. | |
| Reach | campaign_performance_reach | met | Reach. | |
| Bid impressions | campaign_performance_bid_impressions | met | Bid impression. | |
| CTR | campaign_performance_ctr | met | Click through rate. Clicks / Impressions - The percentage of clicks received per impressions served. | |
| VCR | campaign_performance_video_completion_rate | met | Video completion rate - Percentage of video ads that play through completion. | |
| Frequency | campaign_performance_frequency | met | Frequency. | |
| Win rate | campaign_performance_win_rate | met | Win rate - The percentage of impressions won the bids made. | |
| Total spent | campaign_performance_spent | met | Sum of the Media Spent and Data Spent. | |
| Media spent | campaign_performance_media_spent | met | Amount spent to win impressions. | |
| Data cost | campaign_performance_data_cost | met | Amount spent to serve impressions to audience you matched or purchased. | |
| eCPM | campaign_performance_effective_cost_per_mille | met | Effective cost per mille - The amount you pay per one thousand impression. | |
| eCPC | campaign_performance_effective_cost_per_click | met | Effective cost per click. The amount of spent divided my the number of clicks. | |
| eCPCV | campaign_performance_effective_cost_per_complete_view | met | Cost per complete view - The amount spent divide by video ads that play through completion. | |
| Video start | campaign_performance_start_count | met | Number of video ads start to play. | |
| Video 25% | campaign_performance_first_count | met | Number of video ads start to play through 25% of their duration. | |
| Video 50% | campaign_performance_mid_count | met | Number of video ads start to play through 50% of their duration. | |
| Video 75% | campaign_performance_third_count | met | Number of video ads start to play through 75% of their duration. | |
| Video 100% | campaign_performance_complete_count | met | Number of video ads start to play through to completion. | |
| Hours viewed | campaign_performance_audio_video_viewed | met | Total time spent on audio video. Metric is displayed in hours. | |
| Total budget | campaign_performance_budget_total | met | The total of budget. | |
| Daily budget | campaign_performance_budget_day | met | Daily budget - The amount to spend on average each day. | |
| Max bid | campaign_performance_max_bid | met | Max bid - The amount up to which you allow us to bid. |