Media Math Fields
Dimensions (88)
API Name: advertiser_id
NinjaCat System ID: media_math:DIM_advertiser_id
Data Type: integer
API Name: advertiser_name
NinjaCat System ID: media_math:DIM_advertiser_name
Data Type: text
API Name: attribution_group
NinjaCat System ID: media_math:DIM_attribution_group
Data Type: text
API Name: audience_name
NinjaCat System ID: media_math:DIM_audience_name
Data Type: text
API Name: audience_path
NinjaCat System ID: media_math:DIM_audience_path
Data Type: text
API Name: browser_version
NinjaCat System ID: media_math:DIM_browser_version
Data Type: text
API Name: campaign_budget
NinjaCat System ID: media_math:DIM_campaign_budget
Data Type: decimal
Display As: currency
API Name: campaign_currency_code
NinjaCat System ID: media_math:DIM_campaign_currency_code
Data Type: text
API Name: campaign_end_date
NinjaCat System ID: media_math:DIM_campaign_end_date
Data Type: datetime
Display As: date_time
API Name: campaign_goal_type
NinjaCat System ID: media_math:DIM_campaign_goal_type
Data Type: text
API Name: campaign_goal_value
NinjaCat System ID: media_math:DIM_campaign_goal_value
Data Type: decimal
Display As: currency
NinjaCat System ID: media_math:DIM_CampaignGroup
Data Type: text
Aggregates To: DIM_CAMPAIGN_GROUPS
API Name: campaign_initial_start_date
NinjaCat System ID: media_math:DIM_campaign_initial_start_date
Data Type: datetime
Display As: date_time
API Name: campaign_name
NinjaCat System ID: media_math:DIM_campaign_name
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME
API Name: campaign_start_date
NinjaCat System ID: media_math:DIM_campaign_start_date
Data Type: datetime
Display As: date_time
API Name: campaign_timezone
NinjaCat System ID: media_math:DIM_campaign_timezone
Data Type: text
API Name: campaign_timezone_code
NinjaCat System ID: media_math:DIM_campaign_timezone_code
Data Type: text
API Name: connection_speed
NinjaCat System ID: media_math:DIM_connection_speed
Data Type: text
API Name: connection_type
NinjaCat System ID: media_math:DIM_connection_type
Data Type: text
API Name: country_code
NinjaCat System ID: media_math:DIM_country_code
Data Type: text
Display As: country
Aggregates To: DIM_COUNTRIES
API Name: country_name
NinjaCat System ID: media_math:DIM_country_name
Data Type: text
Display As: title_case
API Name: creative_name
NinjaCat System ID: media_math:DIM_creative_name
Data Type: text
API Name: creative_size
NinjaCat System ID: media_math:DIM_creative_size
Data Type: text
NinjaCat System ID: media_math:DIM_DATA_SOURCE
Data Type: text
Aggregates To: DIM_DATA_SOURCE
API Name: start_date
NinjaCat System ID: media_math:DIM_DATE
Data Type: date
Aggregates To: DIM_DATE
NinjaCat System ID: media_math:DIM_DayOfMonthNC
Data Type: integer
Aggregates To: DIM_DAY_OF_MONTH
NinjaCat System ID: media_math:DIM_DayOfWeekNC
Data Type: text
Display As: day_of_week
Aggregates To: DIM_DAY_OF_WEEK
API Name: day_part_name
NinjaCat System ID: media_math:DIM_day_part_name
Data Type: text
API Name: deal_external_id
NinjaCat System ID: media_math:DIM_deal_external_id
Data Type: text
API Name: exchange_name
NinjaCat System ID: media_math:DIM_exchange_name
Data Type: text
NinjaCat System ID: media_math:DIM_EXTERNAL_ID
Data Type: text
Aggregates To: DIM_EXTERNAL_ID
API Name: frequency_bin
NinjaCat System ID: media_math:DIM_frequency_bin
Data Type: text
API Name: inventory_type
NinjaCat System ID: media_math:DIM_inventory_type
Data Type: text
API Name: metro_name
NinjaCat System ID: media_math:DIM_metro_name
Data Type: text
Display As: title_case
NinjaCat System ID: media_math:DIM_MonthOfYearNC
Data Type: text
Display As: date_month_of_year
Aggregates To: DIM_MONTH_OF_YEAR
NinjaCat System ID: media_math:DIM_NETWORK
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK
API Name: operating_system
NinjaCat System ID: media_math:DIM_operating_system
Data Type: text
API Name: organization_id
NinjaCat System ID: media_math:DIM_organization_id
Data Type: integer
API Name: organization_name
NinjaCat System ID: media_math:DIM_organization_name
Data Type: text
API Name: pixel_external_id
NinjaCat System ID: media_math:DIM_pixel_external_id
Data Type: text
API Name: pixel_tag_type
NinjaCat System ID: media_math:DIM_pixel_tag_type
Data Type: text
NinjaCat System ID: media_math:DIM_QuarterNC
Data Type: text
Display As: quarter
Aggregates To: DIM_QUARTER
API Name: region_name
NinjaCat System ID: media_math:DIM_region_name
Data Type: text
Display As: title_case
API Name: strategy_budget
NinjaCat System ID: media_math:DIM_strategy_budget
Data Type: decimal
Display As: currency
API Name: strategy_channel
NinjaCat System ID: media_math:DIM_strategy_channel
Data Type: text
API Name: strategy_end_date
NinjaCat System ID: media_math:DIM_strategy_end_date
Data Type: datetime
Display As: date_time
API Name: strategy_goal_type
NinjaCat System ID: media_math:DIM_strategy_goal_type
Data Type: text
API Name: strategy_goal_value
NinjaCat System ID: media_math:DIM_strategy_goal_value
Data Type: decimal
Display As: currency
API Name: strategy_name
NinjaCat System ID: media_math:DIM_strategy_name
Data Type: text
API Name: strategy_start_date
NinjaCat System ID: media_math:DIM_strategy_start_date
Data Type: datetime
Display As: date_time
API Name: strategy_supply_type
NinjaCat System ID: media_math:DIM_strategy_supply_type
Data Type: text
API Name: strategy_type
NinjaCat System ID: media_math:DIM_strategy_type
Data Type: text
NinjaCat System ID: media_math:DIM_ACCOUNT_ID
Data Type: text
Aggregates To: DIM_ACCOUNT_ID
API Name: tpas_placement_id
NinjaCat System ID: media_math:DIM_tpas_placement_id
Data Type: text
API Name: tpas_placement_name
NinjaCat System ID: media_math:DIM_tpas_placement_name
Data Type: text
NinjaCat System ID: media_math:DIM_WeekOfYearNC
Data Type: text
Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY
Metrics (130)
API Name: adserving_cost
NinjaCat System ID: media_math:MET_adserving_cost
Data Type: decimal
Display As: currency
API Name: adverification_cost
NinjaCat System ID: media_math:MET_adverification_cost
Data Type: decimal
Display As: currency
API Name: audience_index
NinjaCat System ID: media_math:MET_audience_index
Data Type: integer
API Name: average_bid_amount_cpm
NinjaCat System ID: media_math:MET_average_bid_amount_cpm
Data Type: decimal
Display As: currency
API Name: average_win_amount_cpm
NinjaCat System ID: media_math:MET_average_win_amount_cpm
Data Type: decimal
Display As: currency
API Name: bid_rate
NinjaCat System ID: media_math:MET_bid_rate
Data Type: decimal
Display As: percent
API Name: billed_spend
NinjaCat System ID: media_math:MET_billed_spend
Data Type: decimal
Display As: currency
API Name: clicks
NinjaCat System ID: media_math:MET_clicks
Data Type: integer
Aggregates To: MET_CLICKS
API Name: client_exchange_cost
NinjaCat System ID: media_math:MET_client_exchange_cost
Data Type: decimal
Display As: currency
API Name: client_margin_share
NinjaCat System ID: media_math:MET_client_margin_share
Data Type: decimal
Display As: currency
API Name: contextual_cost
NinjaCat System ID: media_math:MET_contextual_cost
Data Type: decimal
Display As: currency
NinjaCat System ID: media_math:MET_COUNT_NC
Data Type: integer
Aggregates To: MET_COUNT_NC
API Name: ctr
NinjaCat System ID: media_math:MET_ctr
Data Type: decimal
Display As: percent
Aggregates To: MET_CTR
API Name: dynamic_creative_cost
NinjaCat System ID: media_math:MET_dynamic_creative_cost
Data Type: decimal
Display As: currency
API Name: impressions
NinjaCat System ID: media_math:MET_impressions
Data Type: integer
Aggregates To: MET_IMPRESSIONS
API Name: in_view
NinjaCat System ID: media_math:MET_in_view
Data Type: decimal
Display As: float
API Name: in_view_100_percent
NinjaCat System ID: media_math:MET_in_view_100_percent
Data Type: decimal
Display As: float
API Name: in_view_15_seconds
NinjaCat System ID: media_math:MET_in_view_15_seconds
Data Type: decimal
Display As: float
API Name: in_view_15_seconds_rate
NinjaCat System ID: media_math:MET_in_view_15_seconds_rate
Data Type: decimal
Display As: percent
API Name: in_view_5_seconds
NinjaCat System ID: media_math:MET_in_view_5_seconds
Data Type: decimal
Display As: float
API Name: in_view_5_seconds_rate
NinjaCat System ID: media_math:MET_in_view_5_seconds_rate
Data Type: decimal
Display As: percent
API Name: managed_service_fee
NinjaCat System ID: media_math:MET_managed_service_fee
Data Type: decimal
Display As: currency
API Name: margin
NinjaCat System ID: media_math:MET_margin
Data Type: decimal
Display As: currency
API Name: matched_bid_opportunities
NinjaCat System ID: media_math:MET_matched_bid_opportunities
Data Type: integer
API Name: matched_impressions
NinjaCat System ID: media_math:MET_matched_impressions
Data Type: integer
API Name: matched_users
NinjaCat System ID: media_math:MET_matched_users
Data Type: integer
API Name: max_bid_amount_cpm
NinjaCat System ID: media_math:MET_max_bid_amount_cpm
Data Type: decimal
Display As: currency
API Name: max_win_amount_cpm
NinjaCat System ID: media_math:MET_max_win_amount_cpm
Data Type: decimal
Display As: currency
API Name: measurability_rate
NinjaCat System ID: media_math:MET_measurability_rate
Data Type: decimal
Display As: percent
API Name: measurable
NinjaCat System ID: media_math:MET_measurable
Data Type: decimal
Display As: float
API Name: media_cost
NinjaCat System ID: media_math:MET_media_cost
Data Type: decimal
Display As: currency
API Name: media_cost_cpa
NinjaCat System ID: media_math:MET_media_cost_cpa
Data Type: decimal
Display As: currency
API Name: media_cost_cpc
NinjaCat System ID: media_math:MET_media_cost_cpc
Data Type: decimal
Display As: currency
API Name: media_cost_cpcv
NinjaCat System ID: media_math:MET_media_cost_cpcv
Data Type: decimal
Display As: currency
API Name: media_cost_cpm
NinjaCat System ID: media_math:MET_media_cost_cpm
Data Type: decimal
Display As: currency
API Name: media_cost_pc_cpa
NinjaCat System ID: media_math:MET_media_cost_pc_cpa
Data Type: decimal
Display As: currency
API Name: media_cost_pv_cpa
NinjaCat System ID: media_math:MET_media_cost_pv_cpa
Data Type: decimal
Display As: currency
API Name: media_cost_roi
NinjaCat System ID: media_math:MET_media_cost_roi
Data Type: integer
API Name: media_cost_vcpm
NinjaCat System ID: media_math:MET_media_cost_vcpm
Data Type: decimal
Display As: currency
API Name: min_bid_amount_cpm
NinjaCat System ID: media_math:MET_min_bid_amount_cpm
Data Type: decimal
Display As: currency
API Name: min_win_amount_cpm
NinjaCat System ID: media_math:MET_min_win_amount_cpm
Data Type: decimal
Display As: currency
API Name: mm_data_cost
NinjaCat System ID: media_math:MET_mm_data_cost
Data Type: decimal
Display As: currency
API Name: mm_margin_share
NinjaCat System ID: media_math:MET_mm_margin_share
Data Type: decimal
Display As: currency
API Name: mm_total_fee
NinjaCat System ID: media_math:MET_mm_total_fee
Data Type: decimal
Display As: currency
API Name: non_watermark_impressions
NinjaCat System ID: media_math:MET_non_watermark_impressions
Data Type: integer
API Name: non_watermark_spend
NinjaCat System ID: media_math:MET_non_watermark_spend
Data Type: decimal
Display As: currency
API Name: optimization_fee
NinjaCat System ID: media_math:MET_optimization_fee
Data Type: decimal
Display As: currency
API Name: platform_access_fee
NinjaCat System ID: media_math:MET_platform_access_fee
Data Type: decimal
Display As: currency
API Name: pmp_no_opto_fee
NinjaCat System ID: media_math:MET_pmp_no_opto_fee
Data Type: decimal
Display As: currency
API Name: pmp_opto_fee
NinjaCat System ID: media_math:MET_pmp_opto_fee
Data Type: decimal
Display As: currency
API Name: post_click_aov
NinjaCat System ID: media_math:MET_post_click_aov
Data Type: decimal
Display As: currency
API Name: post_click_conversions
NinjaCat System ID: media_math:MET_post_click_conversions
Data Type: integer
API Name: post_click_media_cost_roi
NinjaCat System ID: media_math:MET_post_click_media_cost_roi
Data Type: integer
API Name: post_click_revenue
NinjaCat System ID: media_math:MET_post_click_revenue
Data Type: decimal
Display As: currency
API Name: post_click_total_ad_cost_roi
NinjaCat System ID: media_math:MET_post_click_total_ad_cost_roi
Data Type: integer
API Name: post_click_total_spend_roi
NinjaCat System ID: media_math:MET_post_click_total_spend_roi
Data Type: integer
API Name: post_view_aov
NinjaCat System ID: media_math:MET_post_view_aov
Data Type: decimal
Display As: currency
API Name: post_view_conversions
NinjaCat System ID: media_math:MET_post_view_conversions
Data Type: decimal
Display As: float
API Name: post_view_conversions_raw
NinjaCat System ID: media_math:MET_post_view_conversions_raw
Data Type: integer
API Name: post_view_media_cost_roi
NinjaCat System ID: media_math:MET_post_view_media_cost_roi
Data Type: integer
API Name: post_view_revenue
NinjaCat System ID: media_math:MET_post_view_revenue
Data Type: decimal
Display As: currency
API Name: post_view_revenue_raw
NinjaCat System ID: media_math:MET_post_view_revenue_raw
Data Type: decimal
Display As: currency
API Name: post_view_total_ad_cost_roi
NinjaCat System ID: media_math:MET_post_view_total_ad_cost_roi
Data Type: integer
API Name: post_view_total_spend_roi
NinjaCat System ID: media_math:MET_post_view_total_spend_roi
Data Type: integer
API Name: privacy_compliance_cost
NinjaCat System ID: media_math:MET_privacy_compliance_cost
Data Type: decimal
Display As: currency
API Name: revenue
NinjaCat System ID: media_math:MET_revenue
Data Type: decimal
Display As: currency
API Name: revenue_raw
NinjaCat System ID: media_math:MET_revenue_raw
Data Type: decimal
Display As: currency
API Name: rr_per_1k_imps
NinjaCat System ID: media_math:MET_rr_per_1k_imps
Data Type: decimal
Display As: percent
API Name: total_ad_cost
NinjaCat System ID: media_math:MET_total_ad_cost
Data Type: decimal
Display As: currency
API Name: total_ad_cost_cpa
NinjaCat System ID: media_math:MET_total_ad_cost_cpa
Data Type: decimal
Display As: currency
API Name: total_ad_cost_cpc
NinjaCat System ID: media_math:MET_total_ad_cost_cpc
Data Type: decimal
Display As: currency
API Name: total_ad_cost_cpcv
NinjaCat System ID: media_math:MET_total_ad_cost_cpcv
Data Type: decimal
Display As: currency
API Name: total_ad_cost_cpm
NinjaCat System ID: media_math:MET_total_ad_cost_cpm
Data Type: decimal
Display As: currency
API Name: total_ad_cost_pc_cpa
NinjaCat System ID: media_math:MET_total_ad_cost_pc_cpa
Data Type: decimal
Display As: currency
API Name: total_ad_cost_pv_cpa
NinjaCat System ID: media_math:MET_total_ad_cost_pv_cpa
Data Type: decimal
Display As: currency
API Name: total_ad_cost_roi
NinjaCat System ID: media_math:MET_total_ad_cost_roi
Data Type: integer
API Name: total_ad_cost_vcpm
NinjaCat System ID: media_math:MET_total_ad_cost_vcpm
Data Type: decimal
Display As: currency
API Name: total_aov
NinjaCat System ID: media_math:MET_total_aov
Data Type: decimal
Display As: currency
API Name: total_bid_amount_cpm
NinjaCat System ID: media_math:MET_total_bid_amount_cpm
Data Type: decimal
Display As: currency
API Name: total_conversions
NinjaCat System ID: media_math:MET_total_conversions
Data Type: decimal
Display As: float
Aggregates To: MET_CONVERSIONS
API Name: total_revenue
NinjaCat System ID: media_math:MET_total_revenue
Data Type: decimal
Display As: currency
API Name: total_spend
NinjaCat System ID: media_math:MET_total_spend
Data Type: decimal
Display As: currency
Aggregates To: MET_COST
API Name: total_spend_cpa
NinjaCat System ID: media_math:MET_total_spend_cpa
Data Type: decimal
Display As: currency
Aggregates To: MET_CPA
API Name: total_spend_cpc
NinjaCat System ID: media_math:MET_total_spend_cpc
Data Type: decimal
Display As: currency
Aggregates To: MET_CPC
API Name: total_spend_cpcv
NinjaCat System ID: media_math:MET_total_spend_cpcv
Data Type: decimal
Display As: currency
API Name: total_spend_cpm
NinjaCat System ID: media_math:MET_total_spend_cpm
Data Type: decimal
Display As: currency
Aggregates To: MET_CPM
API Name: total_spend_pc_cpa
NinjaCat System ID: media_math:MET_total_spend_pc_cpa
Data Type: decimal
Display As: currency
API Name: total_spend_pv_cpa
NinjaCat System ID: media_math:MET_total_spend_pv_cpa
Data Type: decimal
Display As: currency
API Name: total_spend_roi
NinjaCat System ID: media_math:MET_total_spend_roi
Data Type: integer
API Name: total_spend_vcpm
NinjaCat System ID: media_math:MET_total_spend_vcpm
Data Type: decimal
Display As: currency
API Name: total_win_amount_cpm
NinjaCat System ID: media_math:MET_total_win_amount_cpm
Data Type: decimal
Display As: currency
API Name: udi_data_cost
NinjaCat System ID: media_math:MET_udi_data_cost
Data Type: decimal
Display As: currency
API Name: video_collapse
NinjaCat System ID: media_math:MET_video_collapse
Data Type: integer
API Name: video_companion_clicks
NinjaCat System ID: media_math:MET_video_companion_clicks
Data Type: integer
API Name: video_companion_ctr
NinjaCat System ID: media_math:MET_video_companion_ctr
Data Type: decimal
Display As: percent
API Name: video_companion_impressions
NinjaCat System ID: media_math:MET_video_companion_impressions
Data Type: integer
API Name: video_complete
NinjaCat System ID: media_math:MET_video_complete
Data Type: integer
API Name: video_complete_rate
NinjaCat System ID: media_math:MET_video_complete_rate
Data Type: decimal
Display As: percent
API Name: video_engaged_impressions
NinjaCat System ID: media_math:MET_video_engaged_impressions
Data Type: integer
API Name: video_engaged_rate
NinjaCat System ID: media_math:MET_video_engaged_rate
Data Type: decimal
Display As: percent
API Name: video_expand
NinjaCat System ID: media_math:MET_video_expand
Data Type: integer
API Name: video_first_quartile
NinjaCat System ID: media_math:MET_video_first_quartile
Data Type: integer
API Name: video_first_quartile_rate
NinjaCat System ID: media_math:MET_video_first_quartile_rate
Data Type: decimal
Display As: percent
API Name: video_fullscreen
NinjaCat System ID: media_math:MET_video_fullscreen
Data Type: integer
API Name: video_midpoint
NinjaCat System ID: media_math:MET_video_midpoint
Data Type: integer
API Name: video_midpoint_rate
NinjaCat System ID: media_math:MET_video_midpoint_rate
Data Type: decimal
Display As: percent
API Name: video_play_rate
NinjaCat System ID: media_math:MET_video_play_rate
Data Type: decimal
Display As: percent
API Name: video_resume
NinjaCat System ID: media_math:MET_video_resume
Data Type: integer
API Name: video_rewind
NinjaCat System ID: media_math:MET_video_rewind
Data Type: integer
API Name: video_skippable_impressions
NinjaCat System ID: media_math:MET_video_skippable_impressions
Data Type: integer
API Name: video_skipped_impressions
NinjaCat System ID: media_math:MET_video_skipped_impressions
Data Type: integer
API Name: video_skipped_rate
NinjaCat System ID: media_math:MET_video_skipped_rate
Data Type: decimal
Display As: percent
API Name: video_third_quartile
NinjaCat System ID: media_math:MET_video_third_quartile
Data Type: integer
API Name: video_third_quartile_rate
NinjaCat System ID: media_math:MET_video_third_quartile_rate
Data Type: decimal
Display As: percent
API Name: video_unmute
NinjaCat System ID: media_math:MET_video_unmute
Data Type: integer
API Name: viewability_rate
NinjaCat System ID: media_math:MET_viewability_rate
Data Type: decimal
Display As: percent
API Name: viewability_rate_100_percent
NinjaCat System ID: media_math:MET_viewability_rate_100_percent
Data Type: decimal
Display As: percent
API Name: watermark_impressions
NinjaCat System ID: media_math:MET_watermark_impressions
Data Type: integer
API Name: watermark_spend
NinjaCat System ID: media_math:MET_watermark_spend
Data Type: decimal
Display As: currency
API Name: watermark_spend_pct
NinjaCat System ID: media_math:MET_watermark_spend_pct
Data Type: decimal
Display As: percent
API Name: win_rate
NinjaCat System ID: media_math:MET_win_rate
Data Type: decimal
Display As: percent
Updated 6 months ago