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 | ||
| Organization | Organization name | campaign_performance_organization_name | dim | Name of the organization. |
| Organization ID | campaign_performance_organization_id | dim | ID of the organization. | |
| Agency | Agency name | campaign_performance_agency_name | dim | Name of the agency. |
| Agency ID | campaign_performance_agency_id | dim | ID of the agency. | |
| Advertiser | Advertiser name | campaign_performance_advertiser_name | dim | Name of the advertiser. |
| Advertiser ID | campaign_performance_advertiser_id | dim | ID of the advertiser. | |
| Exchange | Exchange name | campaign_performance_exchange_name | dim | Name of the exchange. |
| Exchange ID | campaign_performance_exchange_id | dim | ID of the exchange. | |
| Campaign | Campaign name | campaign_performance_campaign_name | dim | Name of the campaign. |
| Campaign ID | campaign_performance_campaign_id | dim | ID of the campaign. | |
| Campaign goal type | campaign_performance_campaign_goal_type | dim | Goal type for the campaign. | |
| Campaign goal value | campaign_performance_campaign_goal_value | dim | Goal value of the campaign. | |
| Campaign budget | campaign_performance_campaign_budget | dim | Budget for the campaign. | |
| Campaign currency code | campaign_performance_campaign_currency_code | dim | Currency code of the campaign. | |
| Campaign start date | campaign_performance_campaign_start_date | dim | Start date for the campaign. | |
| Campaign start datetime | campaign_performance_campaign_start_date_time | dim | Start datetime for the campaign. | |
| Campaign end date | campaign_performance_campaign_end_date | dim | End date for the campaign. | |
| Campaign end datetime | campaign_performance_campaign_end_date_time | dim | End datetime for the campaign. | |
| Campaign initial start date | campaign_performance_campaign_initial_start_date | dim | Initial start date for the campaign. | |
| Campaign initial start datetime | campaign_performance_campaign_initial_start_datetime | dim | Start initial datetime for the campaign. | |
| Campaign timezone | campaign_performance_campaign_timezone | dim | Timezone of the campaign. | |
| Campaign timezone code | campaign_performance_campaign_timezone_code | dim | Timezone code of the campaign. | |
| Strategy | Strategy name | campaign_performance_strategy_name | dim | Name of the strategy. |
| Strategy ID | campaign_performance_strategy_id | dim | ID of the strategy. | |
| Strategy type | campaign_performance_strategy_type | dim | Type of the strategy. | |
| Strategy goal type | campaign_performance_strategy_goal_type | dim | Goal type for the strategy. | |
| Strategy goal value | campaign_performance_strategy_goal_value | dim | Goal value of the strategy. | |
| Strategy channel | campaign_performance_strategy_channel | dim | Channel of the strategy. | |
| Strategy budget | campaign_performance_strategy_budget | dim | Budget for the strategy. | |
| Strategy supply type | campaign_performance_strategy_supply_type | dim | Supply type of the strategy | |
| Strategy start date | campaign_performance_strategy_start_date | dim | Start date of the strategy | |
| Strategy start datetime | campaign_performance_strategy_start_datetime | dim | Start datetime for the strategy. | |
| Strategy end date | campaign_performance_strategy_end_date | dim | End date for the strategy. | |
| Strategy end datetime | campaign_performance_strategy_end_datetime | dim | End datetime for the strategy. | |
| Attribution | Attribution group | campaign_performance_attribution_group | dim | Attribution group. |
| Deal | Deal name | campaign_performance_deal_name | dim | Name of the deal. |
| Deal ID | campaign_performance_deal_id | dim | ID of the deal. | |
| Deal group name | campaign_performance_deal_group_name | dim | Group name of the deal. | |
| Deal group ID | campaign_performance_deal_group_id | dim | Group ID of the deal. | |
| Deal external ID | campaign_performance_deal_external_id | dim | External ID of the deal. | |
| Deal price type | campaign_performance_deal_price_type | dim | Price type of the deal. | |
| Deal publisher ID | campaign_performance_deal_publisher_id | dim | Publisher ID of the deal. | |
| Concept | Concept name | campaign_performance_concept_name | dim | Name of the concept. |
| Concept ID | campaign_performance_concept_id | dim | ID of the concept. | |
| Creative | Creative name | campaign_performance_creative_name | dim | Name of the creative. |
| Creative ID | campaign_performance_creative_id | dim | ID of the creative. | |
| Creative size | campaign_performance_creative_size | dim | Size of the creative. | |
| Others | Client product estimate | campaign_performance_client_product_estimate | dim | Client product estimate. |
| Prisma IO number | campaign_performance_io_number | dim | Prisma insertion order number. | |
| Prisma campaign ID | campaign_performance_prisma_campaign_id | dim | Prisma campaign ID. | |
| Third party placement name | campaign_performance_tpas_placement_name | dim | Name of the third party placement. | |
| Third party placement ID | campaign_performance_tpas_placement_id | dim | ID of the third party placement. | |
| Impressions | campaign_performance_impressions | met | Number of impressions won. | |
| Clicks | campaign_performance_clicks | met | Number of clicks. | |
| Total conversions | campaign_performance_total_conversions | met | Number of total attributed conversions. | |
| Post-click conversions | campaign_performance_post_click_conversions | met | Number of conversions attributed to clicks. | |
| Uniques | campaign_performance_uniques | met | Number of uniques. | |
| CTR | campaign_performance_ctr | met | Number of impressions that yielded a click. (Clicks / impressions). | |
| CTC | campaign_performance_ctc | met | Number of clicks that yielded a conversion. (Post Click Conversions / Clicks). | |
| Total spend | campaign_performance_total_spend | met | The total spend amount inclusive of all costs and fees configured in MediaMath platform. | |
| Total spend (USD) | campaign_performance_total_spend_usd | met | The total spend amount inclusive of all costs and fees configured in MediaMath platform (USD). | |
| Total spend (EUR) | campaign_performance_total_spend_eur | met | The total spend amount inclusive of all costs and fees configured in MediaMath platform (EUR). | |
| Total spend (GBP) | campaign_performance_total_spend_gbp | met | The total spend amount inclusive of all costs and fees configured in MediaMath platform (GBP). | |
| Total spend eCPA | campaign_performance_total_spend_cpa | met | Total spend cost per action. (Total Spend / Total Conversions). | |
| Total spend eCPC | campaign_performance_total_spend_cpc | met | Total spend cost per click. (Total Spend / Clicks). | |
| Total spend CPCV | campaign_performance_total_spend_cpcv | met | Total spend cost per completed view. (Total Spend / Video Complete). | |
| Total spend eCPM | campaign_performance_total_spend_cpm | met | Total spend cost per mille. ((Total Spend / Impressions) x 1000). | |
| Total spend post-click CPA | campaign_performance_total_spend_pc_cpa | met | Total spend post click cost per action. (Total Spend / Post-click Conversions). | |
| Total spend post-view CPA | campaign_performance_total_spend_pv_cpa | met | Total spend post view cost per action. (Total Spend / Post-click Conversions) | |
| Total ad cost | campaign_performance_total_ad_cost | met | All the costs prior to the addition of MediaMath Fees and customer margin. | |
| Total ad cost eCPA | campaign_performance_total_ad_cost_cpa | met | Total ad cost per action. (Total Ad Cost / Total Conversions). | |
| Total ad cost eCPC | campaign_performance_total_ad_cost_cpc | met | Total ad cost per click. (Total Ad Cost / Clicks). | |
| Total ad cost CPCV | campaign_performance_total_ad_cost_cpcv | met | Total ad cost per completed view. (Total ad cost / complete count). | |
| Total ad cost eCPM | campaign_performance_total_ad_cost_cpm | met | Total ad cost per mille. ((Total Ad Cost / Total Impressions) x 1000). | |
| Total ad cost post-click eCPA | campaign_performance_total_ad_cost_pc_cpa | met | Total ad post click cost per action. (Total Ad Cost / Post-click Conversions). | |
| Media cost | campaign_performance_media_cost | met | Cost of procuring the media, including any fees thereon. | |
| Media cost eCPA | campaign_performance_media_cost_cpa | met | Media cost per action. (Media Cost / Total Conversions). | |
| Media cost eCPC | campaign_performance_media_cost_cpc | met | Media cost per click. (Media Cost / Clicks). | |
| Media cost CPCV | campaign_performance_media_cost_cpcv | met | Media cost per completed view. (Media Cost / Video Complete). | |
| Media cost eCPM | campaign_performance_media_cost_cpm | met | Media cost per mille. ((Media Cost / Impressions) x 1000). | |
| Media cost post-click CPA | campaign_performance_media_cost_pc_cpa | met | Media post click cost per action. (Media Cost / Post-click Conversions). | |
| Video starts | campaign_performance_video_start | met | Number of times the video was started. | |
| Video closes | campaign_performance_video_close | met | Number of times the video was closed. | |
| Video pauses | campaign_performance_video_pause | met | Number of times the video was paused. Can occur multiple times per one impression. | |
| Video resumes | campaign_performance_video_resume | met | Number of times the video was resumed. | |
| Video mutes | campaign_performance_video_mute | met | Number of times the video was muted. Can occur multiple times per one impression. | |
| Video unmutes | campaign_performance_video_unmute | met | Number of times the video was un-muted. Can occur multiple times per one impression. | |
| Video collapses | campaign_performance_video_collapse | met | Number of times the video was collapsed. | |
| Video expand | campaign_performance_video_expand | met | Number of times the video was expanded. Can occur multiple times per one impression. | |
| Video rewinds | campaign_performance_video_rewind | met | Number of times the video was rewind. | |
| Video play rate | campaign_performance_video_play_rate | met | The percentage of video play rate. (Video Start / Impressions). | |
| Video companion impressions | campaign_performance_video_companion_impressions | met | Number of impressions recorded on the companion banner. | |
| Video companion clicks | campaign_performance_video_companion_clicks | met | Number of clicks recorded on the companion banner. | |
| Video companion CTR | campaign_performance_video_companion_ctr | met | Video companion click-through-rate. ((Video Companion Clicks / Video Companion Impressions) * 1000). | |
| Video engaged impressions | campaign_performance_video_engaged_impressions | met | Number of times the user reached the lesser of 30 seconds or video completion. | |
| Video engaged rate | campaign_performance_video_engaged_rate | met | Percentage of how many users reached the lesser of 30 seconds or video completion. (Video Engaged Impressions / Impressions). | |
| Video fullscreen | campaign_performance_video_fullscreen | met | Number of times video was full-screened. Can occur multiple times per one impression. | |
| Video 25% | campaign_performance_video_first_quartile | met | Number of times the user reached 25% (7.5 sec cap) of the video. | |
| Video 50% | campaign_performance_video_midpoint | met | Number of times the user reached 50% (15 sec cap) of the video impression. | |
| Video 75% | campaign_performance_video_third_quartile | met | Number of times the user reached 75% (22.5 sec cap) of the video impression. | |
| Video 100% | campaign_performance_video_complete | met | Number of times the user reached 100% of the video. | |
| Video 25% rate | campaign_performance_video_first_quartile_rate | met | Percentage of how many user reached 25% of the video. (Video First Quartile / Video Start). | |
| Video 50% rate | campaign_performance_video_midpoint_rate | met | Percentage of how many users reached 50% of the video. (Video Midpoint / Video Start). | |
| Video 75% rate | campaign_performance_video_third_quartile_rate | met | Percentage of how many users reached 75% of the video. (Video Third Quartile / Video Start). | |
| Video 100% rate | campaign_performance_video_complete_rate | met | Percentage of users who reached 100% of the video. (Video Completed / Video Start). | |
| Video 25% rate impression based | campaign_performance_video_first_quartile_rate_impression_based | met | Percentage of how many user reached 25% of the video impressions. (video First Quartile / Impressions). | |
| Video 50% rate impression based | campaign_performance_video_midpoint_rate_impression_based | met | Percentage of how many users reached 50% of the video impressions. (Video Midpoint / Impressions). | |
| Video 75% rate impression based | campaign_performance_video_third_quartile_rate_impression_based | met | Percentage of how many users reached 75% of the video impressions. (Video Third Quartile / Impressions). | |
| Video 100% rate impression based | campaign_performance_video_complete_rate_impression_based | met | Percentage of how many users reached 100% of the video impressions. (Video Complete / Impressions). | |
| Video skippable impressions | campaign_performance_video_skippable_impressions | met | Number of impressions that were skippable. | |
| Video skipped impressions | campaign_performance_video_skipped_impressions | met | Number of times the video was skipped. | |
| Video skipped rate | campaign_performance_video_skipped_rate | met | Percentage of times the video was skipped. (Video Skipped Impressions / Video Skippable Impressions). | |
| Ad serving cost | campaign_performance_adserving_cost | met | Cost of the Ad Serving technology involved with the delivery of creatives. | |
| Ad verification cost | campaign_performance_adverification_cost | met | Cost of the Ad Verification involved with the impressions. | |
| Audience verification cost | campaign_performance_audience_verification_cost | met | Cost of validating the demographic information (age, gender, country) on impressions delivered. | |
| Billed spend | campaign_performance_billed_spend | met | Total to be billed to client based on ad costs and fees. Note, although costs may be tracked under the above listed costs or fees, they may not be included on the invoice included MediaMath's. | |
| Client exchange cost | campaign_performance_client_exchange_cost | met | Client exchange Cost. | |
| Client margin share | campaign_performance_client_margin_share | met | Client's share of margin taken. | |
| Client exchange cost | campaign_performance_contextual_cost | met | Contextual targeting costs involved with your campaign - EXCEPTION: Integral Ad Science falls into MM Data Cost. | |
| Dynamic creative cost | campaign_performance_dynamic_creative_cost | met | Cost of the Dynamic Creatives vendor involved with the delivery of creatives. | |
| Total ad cost vCPM | campaign_performance_total_ad_cost_vcpm | met | Total ad cost viewable cost per mille. ((Total Ad Cost / Viewable Impressions) x 1000). | |
| UDI data cost | campaign_performance_udi_data_cost | met | Costs associated with "User-defined integration" with the customer's data vendor via configuration of a data pixel in MediaMath platform. | |
| Margin | campaign_performance_margin | met | Amount of margin per customer's configuration. | |
| Managed service fee | campaign_performance_managed_service_fee | met | Managed service fee on campaigns where "Managed by: MediaMath". | |
| MediaMath total fee | campaign_performance_mm_total_fee | met | Sum of all MediaMath fees (Platform Access Fee + Managed Service Fee + Optimization Fee + PMP Standard Fee + PMP Optimization Fee + MM Margin Share) where applicable. | |
| Optimization fee | campaign_performance_optimization_fee | met | Optimization fee applied on strategies where optimization is enabled (Strategy with goal types of ROI, CPA, CPC, CTR, Viewability Rate, Viewable CPM, CPM Reach, Video Completion Rate) and when a Campaign has Dynamic Budget Allocation (DBA) enabled. | |
| Platform access fee | campaign_performance_platform_access_fee | met | MediaMath platform usage fee. | |
| PMP standard fee (optimization disabled) | campaign_performance_pmp_no_opto_fee | met | Fee from client-sourced PMP-D strategies where optimization is disabled. | |
| PMP standard fee | campaign_performance_pmp_opto_fee | met | Fee from client-sourced PMP-D strategies where optimization is enabled. | |
| Source media enablement fee | campaign_performance_source_media_enablement_fee | met | Source media enablement fee. | |
| Source platform access fee | campaign_performance_source_platform_access_fee | met | Source platform access fee. | |
| Measurable impressions | campaign_performance_measurable_impressions | met | Number of delivered impressions where the third-party measurement vendor was able to determine if the impression was viewable or not. | |
| Measurability rate | campaign_performance_measurability_rate | met | Measurability rate. (Measurable Impressions / Total Impressions). | |
| In view impressions | campaign_performance_in_view_impressions | met | Number of impressions that are in view. | |
| 100% In view impressions | campaign_performance_in_view_100_percent | met | Number of impressions that are 100% in view. | |
| 100% In view rate | campaign_performance_in_view_100_rate | met | In view 100% rate. | |
| In view 15 seconds | campaign_performance_in_view_15_seconds | met | Number of impressions that are in view for 15 seconds. | |
| In view 15 seconds rate | campaign_performance_in_view_15_seconds_rate | met | In view 15 seconds rate. (In View - 15 Seconds / Measurable Impressions). | |
| In view 5 seconds | campaign_performance_in_view_5_seconds | met | Number of impressions that are in view for 5 seconds. | |
| In view 5 seconds rate | campaign_performance_in_view_5_seconds_rate | met | In view 5 seconds rate. (In View - 5 Seconds / Measurable Impressions). | |
| Post-click revenue | campaign_performance_post_click_revenue | met | Revenue amount for conversions attributed to clicks. | |
| Post-click AOV | campaign_performance_post_click_aov | met | Post click average order value. (Post-Click Revenue / Post-Click Conversions). | |
| Post-click media cost ROI | campaign_performance_post_click_media_cost_roi | met | Post click media cost ROI. (Post-Click Revenue / Media Cost). | |
| Post-click total ad cost ROI | campaign_performance_post_click_total_ad_cost_roi | met | Post click total ad cost. (Post-Click Revenue / Total Ad Cost). | |
| Post-click total spend ROI | campaign_performance_post_click_total_spend_roi | met | Post click total spend ROI. (Post-Click Revenue / Total Spend). | |
| Viewability cost | campaign_performance_viewability_cost | met | Cost of ad viewability measurement based on the number of impressions measured (all or sample). | |
| Viewability rate | campaign_performance_viewability_rate | met | Viewability rate. (In-view Impressions / Measurable Impressions). | |
| Viewability rate 100% | campaign_performance_viewability_rate_100 | met | Viewability rate 100. (In-view 100% Impressions / Measurable Impressions). | |
| Facebook actions | campaign_performance_facebook_actions | met | Number of Facebook actions. | |
| Facebook app installs | campaign_performance_facebook_app_installs | met | Number of Facebook app installs. | |
| Facebook likes | campaign_performance_facebook_likes | met | Number of Facebook likes. | |
| Facebook page engagement | campaign_performance_facebook_page_engagement | met | Number of Facebook page engagement. | |
| Facebook post comments | campaign_performance_facebook_post_comments | met | Number of Facebook post comments. | |
| Facebook post reactions | campaign_performance_facebook_post_reactions | met | Number of Facebook post reactions. | |
| Facebook post shares | campaign_performance_facebook_post_shares | met | Number of Facebook post shares. |