Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Campaign | Campaign name | campaign_campaign_name | dim | Name of the campaign, a coordinated media delivery plan that includes placements, creatives, etc. |
| Campaign ID | campaign_campaign_id | dim | ID associated with a Campaign. | |
| 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 | ||
| Media buyer | Media buyer name | campaign_performance__media_buyer_name | dim | A person or entity that purchases and monitors advertising space. |
| Media buyer ID | campaign_performance__media_buyer_id | dim | ID associated with a media buyer. | |
| Advertiser | Advertiser name | campaign_performance__advertiser_name | dim | A person, company or brand that attempts to target and engage customers/prospects through paid media. |
| Advertiser ID | campaign_performance__advertiser_id | dim | ID associated with an advertiser. | |
| Site | Site name | campaign_performance__site_name | dim | Publisher, ad network, website, or SSP which provides inventory space where media can be bought. |
| Site ID | campaign_performance__site_id | dim | ID associated with a site. | |
| Market | Market | campaign_performance__market | dim | The media market within which an ad was served. |
| Content category | Content category name | campaign_performance__content_category_name | dim | Content categories are used to group placements in reports. |
| Content category ID | campaign_performance__content_category_id | dim | ID associated with a content category. | |
| Strategy | Strategy name | campaign_performance__strategy_name | dim | Name of the strategy. Strategies are used to group placements in reports. They are typically used to describe marketing approaches for each placement. For example ‘10 percent discount’, ‘Free shipping’ and ‘Free Trial Membership'. |
| Strategy ID | campaign_performance__strategy_id | dim | ID associated with a strategy. | |
| Placement | Placement name | campaign_performance__placement_name | dim | An object that contains tags and represents a unit of available ad space on a web page. |
| Placement ID | campaign_performance__placement_id | dim | ID associated with a placement. | |
| Third party ID placement | campaign_performance__third_party_id_placement | dim | Identifier for a placement created by a third party. | |
| Cost group | campaign_performance__cost_group | dim | A group of two or more placements within a single publisher that are bought as a package. | |
| Cost group ID | campaign_performance__cost_group_id | dim | Identifier assigned by Report Builder to a cost group. | |
| Start date | campaign_performance__start_date | dim | Placement start date (inherited from campaign when absent). | |
| End date | campaign_performance__end_date | dim | Placement end date (inherited from campaign when absent). | |
| Creative | Creative name | campaign_performance__creative_name | dim | The visual advertisement that will be shown to users. |
| Creative ID | campaign_performance__creative_id | dim | ID associated with a creative. | |
| Creative type | campaign_performance__creative_type | dim | Type of the creative. | |
| Creative group 1 | campaign_performance__creative_group_1 | dim | Collection of related creatives that have been grouped together. | |
| Creative group 1 ID | campaign_performance__creative_group_1_id | dim | ID associated with creative group 1. | |
| Creative group 2 | campaign_performance__creative_group_2 | dim | An Additional collection of related creatives that have been grouped together. | |
| Creative group 2 ID | campaign_performance__creative_group_2_id | dim | ID associated with creative group 2. | |
| Third party ID creative | campaign_performance__third_party_id_creative | dim | In ad server, there is a free-form field for third party IDS. | |
| Ad size | campaign_performance__dimensions | dim | Pixel dimensions associated with a unique creative ad. | |
| Expand dimensions | campaign_performance__expand_dimensions | dim | The size in pixels of the fully expanded creative. | |
| Cost | Media cost rate | campaign_performance__media_cost_rate | dim | The rate applied to cost type. |
| Effective media cost rate | campaign_performance__effective_media_cost_rate | dim | The fixed cost calculated CPM (see Cost Cap Period) or applied Media Cost Rate (CPM/CPC). | |
| Media cost type | campaign_performance__media_cost_type | dim | The cost model applied to media (CPM, CPC, CPA). | |
| FT cost type | campaign_performance__ft_cost_type | dim | The media cost model for the placement (for example, CPM, or CPC). | |
| Cost cap period | campaign_performance__cost_cap_period | dim | The period a fixed cost cap applies to. | |
| Total ads requested | campaign_performance__total_ads_requested | met | The number of times the ad has been served. Uses a 'Count on Decision' methodology as determined by IAB. This metric is net of GIVT filtration. | |
| Clicks | campaign_performance__clicks | met | The total number of times the ad has been clicked on. | |
| CTR | campaign_performance__ctr | met | The number of clicks per total ads. Calculated as Clicks / Total ads requested. | |
| Total cost | campaign_performance__total_cost | met | The combination of media total cost and FT Cost. | |
| CPM | campaign_performance__cpm | met | The average cost per 1,000 impressions. Calculated by (Total cost / Total ads requested) x 1000. | |
| CPC | campaign_performance__cpc | met | Cost per click. Calculated as Total cost / Clicks. | |
| Total spotlights | campaign_performance__total_spotlights | met | The number of last touch attributed conversions from users that have reached any of the targeted spotlight pages. | |
| Total conversion value | campaign_performance__total_conversion_value | met | Total value captured as a passed value against the selected spotlights (from combined non-viewable impressions). | |
| Total ads booked | campaign_performance__total_ads_booked | met | The total number of time ads have been booked. This appears as Booked Units in the campaign manager. The number of expected delivered units (as in, impressions, clicks, or conversions) based on the selected Media Cost Type. This is required if the Cost Cap Period is Total and the Media Cost Type is Fix. Otherwise, this is optional. | |
| Alt gif total ads requested | campaign_performance__alt_gif_total_ads_requested | met | The number of times the backup GIF has been called from the ad server; mostly due to the user not having an HTML5 compatible browser. This metric is net of GIVT filtration. | |
| No script total ads requested | campaign_performance__no_script_total_ads_requested | met | The number of times the backup GIF has been called from the ad server due to the user not having JavaScript installed/enabled on their computer. This metric is net of GIVT filtration. | |
| Combined impressions rendered | campaign_performance__combined_impressions_rendered | met | Combination of Desktop, Mobile App, and Mobile Web rendered Impressions. This metric is net of GIVT filtration. | |
| Standard impressions | campaign_performance__standard_impressions | met | The number of times the standard ad has been served. | |
| Enhanced impressions | campaign_performance__enhanced_impressions | met | The number of times the enhanced ad has been served. | |
| Combined viewable impressions | campaign_performance__combined_viewable_impressions | met | Combination of Desktop, Mobile App, and Mobile Web-Viewable Impressions. This metric is net of GIVT filtration. | |
| Unique clicks | campaign_performance__unique_clicks | met | The estimated number of unique cookies associated with a click on an ad during the reporting period. | |
| Unique CTR | campaign_performance__unique_ctr | met | The number of unique clicks per total ads. Calculated as Unique clicks / Total ads requested. | |
| Expand CTR | campaign_performance__expand_ctr | met | The number of clicks per ads requested on expand ads. Calculated as Clicks / Expand views. | |
| Standard clicks | campaign_performance__standard_clicks | met | The number of times the standard ad has been clicked on. | |
| Standard CTR | campaign_performance__standard_ctr | met | The number of clicks per ads requested on standard ads. Calculated as Standard clicks / Standard impressions. | |
| Enhanced clicks | campaign_performance__enhanced_clicks | met | The number of times the enhanced ad has been clicked on. | |
| Enhanced CTR | campaign_performance__enhanced_ctr | met | The number of clicks per ads requested on enhanced ads. Calculated as Enhanced clicks / Enhanced impressions. | |
| Click (no script) | campaign_performance__click_no_script | met | A click on an ad where a no script tag was called rather than the script tag. | |
| Alt image click | campaign_performance__backup_gif_click | met | The number of clicks on the backup GIF. | |
| ClickTag 1 | campaign_performance__clicktag_1 | met | The number of clicks on the clickTag 1 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 2 | campaign_performance__clicktag_2 | met | The number of clicks on the clickTag 2 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 3 | campaign_performance__clicktag_3 | met | The number of clicks on the clickTag 3 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 4 | campaign_performance__clicktag_4 | met | The number of clicks on the clickTag 4 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 5 | campaign_performance__clicktag_5 | met | The number of clicks on the clickTag 5 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 6 | campaign_performance__clicktag_6 | met | The number of clicks on the clickTag 6 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 7 | campaign_performance__clicktag_7 | met | The number of clicks on the clickTag 7 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 8 | campaign_performance__clicktag_8 | met | The number of clicks on the clickTag 8 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 9 | campaign_performance__clicktag_9 | met | The number of clicks on the clickTag 9 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 10 | campaign_performance__clicktag_10 | met | The number of clicks on the clickTag 10 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 11 | campaign_performance__clicktag_11 | met | The number of clicks on the clickTag 11 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 12 | campaign_performance__clicktag_12 | met | The number of clicks on the clickTag 12 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 13 | campaign_performance__clicktag_13 | met | The number of clicks on the clickTag 13 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 14 | campaign_performance__clicktag_14 | met | The number of clicks on the clickTag 14 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 15 | campaign_performance__clicktag_15 | met | The number of clicks on the clickTag 15 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 16 | campaign_performance__clicktag_16 | met | The number of clicks on the clickTag 16 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 17 | campaign_performance__clicktag_17 | met | The number of clicks on the clickTag 17 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 18 | campaign_performance__clicktag_18 | met | The number of clicks on the clickTag 18 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 19 | campaign_performance__clicktag_19 | met | The number of clicks on the clickTag 19 section of the Flash ad. Maximum of 20 variations. | |
| ClickTag 20 | campaign_performance__clicktag_20 | met | The number of clicks on the clickTag 20 section of the Flash ad. Maximum of 20 variations. | |
| Media cost total | campaign_performance__media_cost_total | met | The units of media cost type multiplied by the media cost rate. For example for CPM (impressions/1000) x Media Cost Rate. | |
| Total income | campaign_performance__total_income | met | The combination of all income. | |
| Total ROI | campaign_performance__total_roi | met | Total return on investment. Calculated as Total income - Total cost. | |
| Booked cost | campaign_performance__booked_cost | met | The expected cost for the placement or package. This is required when the Cost Cap Period is Total. This is optional when the Cost Cap Period is None. | |
| Interactions (unique by ads requested) | campaign_performance__interactions_unique_by_ads_requested | met | The number of users who interacted with the ad. | |
| Interaction rate | campaign_performance__interaction_rate | met | The total number of interactions as a percentage of ads requested. Calculated by Interactions (unique by ads requested) / Total ads requested. | |
| Total interaction time (sec) | campaign_performance__total_interaction_time | met | The total time value of all interactions in seconds. | |
| Average interaction time (sec) | campaign_performance__average_interaction_time | met | The average time (seconds) the user has been interacting with the ad. Calculated by Total interaction time / Interactions (unique by ads requested). | |
| Expand views (unique by ads requested) | campaign_performance__expand_views | met | The number of times an expand ad was seen by a user while the ad was expanded. | |
| Expand rate | campaign_performance__expand_rate | met | The rate in which an ad is viewed in the expanded state. Calculated by Total number of expands / Total ads requested. | |
| Fullscreen | campaign_performance__fullscreen | met | The number of video creatives that played in fullscreen mode. | |
| Total conversion value (from clicks) | campaign_performance__total_conversion_value_from_clicks | met | Total value captured as a passed value against the selected spotlights following an attributed click event. | |
| Total conversion value (from views) | campaign_performance__total_conversion_value_from_views | met | Total value captured as a passed value against the selected spotlights following a view attributed event. | |
| Total spotlight rate | campaign_performance__total_spotlight_rate | met | Calculated by Total spotlights / Total ads requested. | |
| Total spotlights (from clicks) | campaign_performance__total_spotlights_from_clicks | met | The number of last touch attributed conversions from users | |
| Total spotlight rate (from clicks) | campaign_performance__total_spot_rate_from_clicks | met | Calculated by Total spotlights (from clicks) / Total ads requested. | |
| Total spotlights (from views) | campaign_performance__total_spotlights_from_views | met | The number of last touch attributed conversions from users that have reached any of the targeted spotlight pages following an ad with no click. | |
| Total spotlight rate (from views) | campaign_performance__total_spot_rate_from_views | met | Calculated by Total spotlights (from views) / Total ads requested. | |
| Total video start | campaign_performance__total_video_start | met | The number of total videos which began to play net of GIVT. | |
| Total video 25% played | campaign_performance__total_video_25_played | met | The number of times any video is viewed to 25% completion. Net of GIVT. | |
| Total video 50% played | campaign_performance__total_video_50_played | met | The number of times any video is viewed to 50% completion. Net of GIVT. | |
| Total video 75% played | campaign_performance__total_video_75_played | met | The number of times any video is viewed to 75% completion. Net of GIVT. | |
| Total video completes | campaign_performance__total_video_completes | met | The number of times any video is viewed to completion. Net of GIVT. | |
| Total video replays | campaign_performance__total_video_replays | met | The number of times any video is replayed. Net of GIVT. | |
| Total video mutes | campaign_performance__total_video_mute | met | The number of times any video is muted. Net of GIVT. | |
| Total video unmutes | campaign_performance__total_video_unmute | met | The number of times any video is unmuted. Net of GIVT. | |
| Total video 25% played rate | campaign_performance__total_video_25_played_rate | met | The rate at which video is viewed to 25% completion. Net of GIVT. Calculated by Total video 25% played / Total video start. | |
| Total video 50% played rate | campaign_performance__total_video_50_played_rate | met | The rate at which video is viewed to 50% completion. Net of GIVT. Calculated by Total video 50% played / Total video start. | |
| Total video 75% played rate | campaign_performance__total_video_75_played_rate | met | The rate at which video is viewed to 75% completion. Net of GIVT. Calculated by Total video 75% played / Total video start. | |
| Total video completion rate | campaign_performance__total_video_completion_rate | met | The rate started videos are completed. Net of GIVT. Calculated by Total video completes / Total video start. |