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 | ||
| Entity | Account | performance_account | dim | The name of your account. |
| Account ID | performance_account_id | dim | ID of the account. | |
| Agency | performance_agency | dim | Name of the agency. | |
| Agency ID | performance_agency_id | dim | ID of the agency. | |
| Campaign | performance_campaign | dim | Name of the campaign. | |
| Campaign ID | performance_campaign_id | dim | ID of the campaign. | |
| Ad group | performance_ad_group | dim | Name of the ad group. | |
| Ad group ID | performance_ad_group_id | dim | ID of the ad group. | |
| Ad name | performance_content_ad | dim | Name of the content ad. | |
| Ad ID | performance_content_ad_id | dim | ID of the content ad. | |
| Creative | performance_creative | dim | The creative title/name/headline. | |
| Creative ID | performance_creative_id | dim | The creative ID. | |
| Delivery | Media source | performance_media_source | dim | Media source where the content is being promoted. |
| Media source ID | performance_media_source_id | dim | ID of the media source. Can only be included with 'Media source' breakdown. | |
| Media source slug | performance_media_source_slug | dim | Slug of the media source. Can only be included with 'Media source' breakdown. | |
| Browser | performance_browser | dim | Web browser type. | |
| Publishers | performance_publishers | dim | Publisher where the content is being promoted. | |
| Placement | performance_placement | dim | Placement where the content is being promoted. | |
| Environment | performance_environment | dim | Environment where the content is being promoted. | |
| Device | performance_device | dim | Device type. | |
| Operating system | performance_operating_system | dim | The operating system. | |
| Country | performance_country | dim | Country. | |
| State / Region | performance_state_region | dim | State / region. | |
| DMA | performance_dma | dim | Designated Market Area. | |
| General | Bid | performance_bid | dim | Bid amount. |
| Bidding Type | performance_bidding_type | dim | Bidding Type. | |
| Daily budget | performance_daily_budget | dim | Maximum daily budget. | |
| Currency | performance_currency | dim | The currency. | |
| Creative assets | URL | performance_url | dim | Web address of the ad. |
| Display URL | performance_display_url | dim | Advertiser's display url. | |
| Brand name | performance_brand_name | dim | Advertiser's brand name. | |
| Description | performance_description | dim | Description of the ad. | |
| Image hash | performance_image_hash | dim | Image hash. | |
| Image URL | performance_image_url | dim | Url of the image. | |
| Call to action | performance_call_to_action | dim | Call to action text. | |
| Uploaded | performance_uploaded | dim | The time when the ad was uploaded. | |
| Uploaded date | performance_uploaded_date | dim | The date when the ad was uploaded. | |
| Batch Name | performance_batch_name | dim | The name of the upload batch. | |
| Impressions | performance_impressions | met | Impressions | |
| Clicks | performance_clicks | met | The amount of clicks. | |
| CTR | performance_ctr | met | Click through rate. (Clicks / Impressions) - The percentage of clicks received per impressions served. | |
| Avg. CPC | performance_average_cpc | met | The average cost per click on an ad. | |
| Avg. CPM | performance_average_cpm | met | The average cost per thousand ad impressions. Impression is counted whenever an ad is served to the user. | |
| Spend | performance_spend | met | Sum of media spend, data spend, license fee and margin. | |
| Spend (USD) | performance_spend_usd | met | Sum of media spend, data spend, license fee and margin. | |
| Spend (GBP) | performance_spend_gbp | met | Sum of media spend, data spend, license fee and margin. | |
| Spend (EUR) | performance_spend_eur | met | Sum of media spend, data spend, license fee and margin. | |
| Media Spend | performance_media_spend | met | Cost of buying media. | |
| Data cost | performance_data_cost | met | Cost of data usage from various data providers. | |
| License Fee | performance_license_fee | met | Zemanta's license fee. | |
| Margin | performance_margin | met | A percentage representing the profit margin. | |
| Native Measurable Impressions | performance_measurable_impressions | met | Impressions for which we measured viewability. | |
| Native Viewable Impressions | performance_viewable_impressions | met | Number of impressions that were viewed by a person. Impression is counted as viewed when 50% of the ad is in view for 1 second. | |
| Native Not-Measurable Impressions | performance_not_measurable_impressions | met | Impressions for which we couldn't measure viewability. (Impressions/Native Measurable Impressions) | |
| Native Not-Viewable Impressions | performance_not_viewable_impressions | met | Number of impressions that were not viewed by a person. (Native Measurable Impressions/Native Viewable Impressions) | |
| % Native Measurable Impressions | performance_percentage_of_measurable_impressions | met | Percentage of impressions that were measurable. (Native Measurable Impressions/Impressions) | |
| % Native Viewable Impressions | performance_percentage_of_viewable_impressions | met | Percentage of viewable impressions out of all measurable impressions. (Native Viewable Impressions/Native Measurable Impressions) | |
| Native Impression Distribution (Viewable) | performance_impression_distribution_viewable | met | Percentage of viewable impressions out of all impressions. | |
| Native Impression distribution (Not-measurable) | performance_impression_distribution_not_measurable | met | Percentage of not-measurable impressions out of all impressions. Not-measurable Impressions / impressions. | |
| Native Impression Distribution (Not-Viewable) | performance_impression_distribution_not_viewable | met | Percentage of not-viewable impressions out of all impressions. Not-Viewable Impressions / impressions. | |
| Visits | performance_visits | met | Total number of sessions within a date range. | |
| Unique Users | performance_unique_users | met | The total number of unique people who visited your site. | |
| New Users | performance_new_users | met | The total number of unique people who visited your site for the first time. | |
| Returning Users | performance_returning_users | met | The total number of unique people who already visited your site in the past. | |
| % New Users | performance_percentage_of_new_users | met | The total number of unique people who already visited your site in the past. | |
| Pageviews | performance_pageviews | met | Total number of pageviews made during the selected date range. | |
| Pageviews per Visit | performance_pageviews_per_visits | met | Average number of pageviews per visit. | |
| Bounced Visits | performance_bounced_visits | met | Number of visitors that didn't navigate to more than one page on the site. | |
| Non-Bounced Visits | performance_non_bounced_visits | met | Number of visitors that navigated to than one page on the site. | |
| Bounce Rate | performance_bounce_rate | met | Percentage of visits resulted in only one page view. (Bounced Visits/Visits) | |
| Total Seconds | performance_total_seconds | met | Total seconds spend on site. | |
| Total minute | performance_total_minutes | met | Total minutes spend on site. | |
| Time on Site | performance_time_on_site | met | Total time spend on site. | |
| Avg. Cost per Visit | performance_avg_cost_per_visit | met | The average cost per visit to your site. Only visits generated by visitors responding to an ad are included. (Spend/Visits) | |
| Avg. Cost per New Visitor | performance_avg_cost_per_new_visitor | met | The average cost per visit to your site. New visitor is a user that visited your site for the first time. (Spend/New Users) | |
| Avg. Cost per Pageview | performance_avg_cost_per_pageview | met | The average cost per pageview on your site. Only visits generated by visitors responding to an ad are included. | |
| Avg. Cost per Non-Bounced Visit | performance_avg_cost_per_non_bounced_visit | met | The average cost per visitor that viewed more than one page in a session. | |
| Avg. Cost per Minute | performance_avg_cost_per_minute | met | The average cost per minute that visitor spent on your site. Only visitors responding to an ad are included. | |
| Avg. Cost per Unique User | performance_avg_cost_per_unique_user | met | Cost per unique user. | |
| Video Start | performance_video_start | met | Number of video ads start to play. | |
| Video 25% | performance_video_first_quartile | met | Number of video ads start to play through 25% of their duration. | |
| Video 50% | performance_video_midpoint | met | Number of video ads start to play through 50% of their duration. | |
| Video 75% | performance_video_third_quartile | met | Number of video ads start to play through 75% of their duration. | |
| Video Complete | performance_video_complete | met | Number of video ads start to play through to completion. | |
| Video Progress 3s | performance_video_progress_3s | met | Video progress 3s. | |
| Avg. CPV | performance_avg_cpv | met | The average cost per 3 seconds video watch. (Spend/Video Progress 3s) | |
| Avg. CPCV | performance_avg_cpcv | met | The average cost per completed video watch. Spend / Video completed. | |
| Avg. VCPM | performance_avg_vcpm | met | Average cost per thousand viewed impressions. (Spend/(1000 * Native Viewable Impressions)) |