Guides
Shape Help Center

Sizmek Fields

Suggest Edits

Dimensions (72)

Account

NinjaCat System ID: sizmek:DIM_ACCOUNT
Data Type: text
Aggregates To: DIM_ACCOUNT

Ad Size

API Name: ad_size
NinjaCat System ID: sizmek:DIM_ad_size
Data Type: text

Advertisement ID

API Name: advertisement_id
NinjaCat System ID: sizmek:DIM_advertisement_id
Data Type: text

Advertisement Name

API Name: advertisement_name
NinjaCat System ID: sizmek:DIM_advertisement_name
Data Type: text

Advertisement Type

API Name: advertisement_type
NinjaCat System ID: sizmek:DIM_advertisement_type
Data Type: text

Advertiser Id

API Name: advertiser_id
NinjaCat System ID: sizmek:DIM_advertiser_id
Data Type: text
Aggregates To: DIM_ADVERTISER_ID

Advertiser Name

API Name: advertiser_name
NinjaCat System ID: sizmek:DIM_advertiser_name
Data Type: text

ADX Audit Status

API Name: adx_audit_status
NinjaCat System ID: sizmek:DIM_adx_audit_status
Data Type: text

ADX Creative Id

API Name: adx_creative_id
NinjaCat System ID: sizmek:DIM_adx_creative_id
Data Type: text

Appnexus Audit Feedback

API Name: apn_audit_feedback
NinjaCat System ID: sizmek:DIM_apn_audit_feedback
Data Type: text

Appnexus Audit Status

API Name: apn_audit_status
NinjaCat System ID: sizmek:DIM_apn_audit_status
Data Type: text

Appnexus Creative Id

API Name: apn_creative_id
NinjaCat System ID: sizmek:DIM_apn_creative_id
Data Type: text

Billing Type

API Name: billing_type
NinjaCat System ID: sizmek:DIM_billing_type
Data Type: text

Browser

API Name: browser
NinjaCat System ID: sizmek:DIM_browser
Data Type: text

Campaign Currency

API Name: campaign_currency
NinjaCat System ID: sizmek:DIM_campaign_currency
Data Type: text

Campaign End Date

API Name: campaign_end_date
NinjaCat System ID: sizmek:DIM_campaign_end_date
Data Type: text
Aggregates To: DIM_CAMPAIGN_END_DATE

Campaign Group

NinjaCat System ID: sizmek:DIM_CampaignGroup
Data Type: text
Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign Id

API Name: campaign_id
NinjaCat System ID: sizmek:DIM_campaign_id
Data Type: text
Aggregates To: DIM_CAMPAIGN_ID

Campaign Name

API Name: campaign_name
NinjaCat System ID: sizmek:DIM_campaign_name
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Campaign Start Date

API Name: campaign_start_date
NinjaCat System ID: sizmek:DIM_campaign_start_date
Data Type: text
Aggregates To: DIM_CAMPAIGN_START_DATE

Campaign Time Zone

API Name: campaign_time_zone
NinjaCat System ID: sizmek:DIM_campaign_time_zone
Data Type: text

Clicks Source

API Name: clicks_source
NinjaCat System ID: sizmek:DIM_clicks_source
Data Type: text

Conversion Source

API Name: conversion_source
NinjaCat System ID: sizmek:DIM_conversion_source
Data Type: text

Cross-device Conversion Source

API Name: cross_device_conversion_source
NinjaCat System ID: sizmek:DIM_cross_device_conversion_source
Data Type: text

Currency

NinjaCat System ID: sizmek:DIM_CURRENCY
Data Type: text
Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: sizmek:DIM_DATA_SOURCE
Data Type: text
Aggregates To: DIM_DATA_SOURCE

Date

API Name: date
NinjaCat System ID: sizmek:DIM_date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: sizmek:DIM_DAY_OF_MONTH
Data Type: integer
Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: sizmek:DIM_DAY_OF_WEEK
Data Type: text
Display As: day_of_week
Aggregates To: DIM_DAY_OF_WEEK

Delivery Channel

API Name: delivery_channel
NinjaCat System ID: sizmek:DIM_delivery_channel
Data Type: text

Device

API Name: device
NinjaCat System ID: sizmek:DIM_device
Data Type: text

External Id

NinjaCat System ID: sizmek:DIM_EXTERNAL_ID
Data Type: text
Aggregates To: DIM_EXTERNAL_ID

FBX Body

API Name: fbx_body
NinjaCat System ID: sizmek:DIM_fbx_body
Data Type: text

FBX Caption

API Name: fbx_caption
NinjaCat System ID: sizmek:DIM_fbx_caption
Data Type: text

FBX Link

API Name: fbx_image
NinjaCat System ID: sizmek:DIM_fbx_image
Data Type: text

FBX Link

API Name: fbx_link
NinjaCat System ID: sizmek:DIM_fbx_link
Data Type: text

FBX Message

API Name: fbx_message
NinjaCat System ID: sizmek:DIM_fbx_message
Data Type: text

FBX Title

API Name: fbx_title
NinjaCat System ID: sizmek:DIM_fbx_title
Data Type: text

Flight End Date

API Name: flight_end_date
NinjaCat System ID: sizmek:DIM_flight_end_date
Data Type: text

Flight ID

API Name: flight_id
NinjaCat System ID: sizmek:DIM_flight_id
Data Type: text

Flight Name

API Name: flight_name
NinjaCat System ID: sizmek:DIM_flight_name
Data Type: text

Flight Start Date

API Name: flight_start_date
NinjaCat System ID: sizmek:DIM_flight_start_date
Data Type: text

Impression Day Conversion Source

API Name: impression_day_conversion_source
NinjaCat System ID: sizmek:DIM_impression_day_conversion_source
Data Type: text

Impression Day Cross-device Conversion Source

API Name: impression_day_cross_device_conversion_source
NinjaCat System ID: sizmek:DIM_impression_day_cross_device_conversion_source
Data Type: text

Impressions Source

API Name: impressions_source
NinjaCat System ID: sizmek:DIM_impressions_source
Data Type: text

In Target Impressions Source For Reach

API Name: in_target_reach_vendor_source
NinjaCat System ID: sizmek:DIM_in_target_reach_vendor_source
Data Type: text

Last Pricing Value

API Name: last_pricing_value
NinjaCat System ID: sizmek:DIM_last_pricing_value
Data Type: text

Line Item ID

API Name: line_item_id
NinjaCat System ID: sizmek:DIM_line_item_id
Data Type: text

Line Item Name

API Name: line_item_name
NinjaCat System ID: sizmek:DIM_line_item_name
Data Type: text

Media Format

API Name: media_format
NinjaCat System ID: sizmek:DIM_media_format
Data Type: text

Media Type

API Name: media_type
NinjaCat System ID: sizmek:DIM_media_type
Data Type: text

Month Of Year

NinjaCat System ID: sizmek:DIM_MONTH_OF_YEAR
Data Type: text
Display As: date_month_of_year
Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: sizmek:DIM_NETWORK
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK

Operating System

API Name: operating_system
NinjaCat System ID: sizmek:DIM_operating_system
Data Type: text

Placement

API Name: placement
NinjaCat System ID: sizmek:DIM_placement
Data Type: text

Pricing Type

API Name: pricing_type
NinjaCat System ID: sizmek:DIM_pricing_type
Data Type: text

Publisher Name

API Name: publisher_name
NinjaCat System ID: sizmek:DIM_publisher_name
Data Type: text

Quarter

NinjaCat System ID: sizmek:DIM_QUARTER
Data Type: text
Display As: quarter
Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: sizmek:DIM_ROW
Data Type: text
Aggregates To: DIM_ROW

Salesforce Id

API Name: salesforce_id
NinjaCat System ID: sizmek:DIM_salesforce_id
Data Type: text

Sizmek Integrated Viewability Source

API Name: rf_integrated_viewability_source
NinjaCat System ID: sizmek:DIM_rf_integrated_viewability_source
Data Type: text

Sizmek integrated Viewability Vendor

API Name: rf_integrated_viewability_vendor
NinjaCat System ID: sizmek:DIM_rf_integrated_viewability_vendor
Data Type: text

Sub Network Id

API Name: sub_network_id
NinjaCat System ID: sizmek:DIM_sub_network_id
Data Type: text

Sub Network Name

API Name: sub_network_name
NinjaCat System ID: sizmek:DIM_sub_network_name
Data Type: text

System Account ID

NinjaCat System ID: sizmek:DIM_ACCOUNT_ID
Data Type: text
Aggregates To: DIM_ACCOUNT_ID

Tactic Name

API Name: tactic_name
NinjaCat System ID: sizmek:DIM_tactic_name
Data Type: text

Thirdparty Ad Id

API Name: thirdparty_ad_id
NinjaCat System ID: sizmek:DIM_thirdparty_ad_id
Data Type: text

Tid

API Name: tactic_id
NinjaCat System ID: sizmek:DIM_tactic_id
Data Type: text

Week Of Year

NinjaCat System ID: sizmek:DIM_WEEK_OF_YEAR
Data Type: text
Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Yahoo Audit Feedback

API Name: yax_audit_feedback
NinjaCat System ID: sizmek:DIM_yax_audit_feedback
Data Type: text

Yahoo Audit Status

API Name: yax_audit_status
NinjaCat System ID: sizmek:DIM_yax_audit_status
Data Type: text

Year

NinjaCat System ID: sizmek:DIM_Year
Data Type: text
Aggregates To: DIM_YEAR

Metrics (83)

AOV

NinjaCat System ID: sizmek:MET_aov
Data Type: decimal
Display As: currency
Formula: sizmek:MET_client_revenue / sizmek:MET_conversions

Audience Guarantee Cost

API Name: audience_guarantee_cost
NinjaCat System ID: sizmek:MET_audience_guarantee_cost
Data Type: integer

Average Frequency

API Name: average_frequency
NinjaCat System ID: sizmek:MET_average_frequency
Data Type: integer

Average Video Completion Rate

API Name: average_video_completion_rate
NinjaCat System ID: sizmek:MET_average_video_completion_rate
Data Type: integer

Clicks

API Name: clicks
NinjaCat System ID: sizmek:MET_clicks
Data Type: integer
Aggregates To: MET_CLICKS

Client Revenue

API Name: client_revenue
NinjaCat System ID: sizmek:MET_client_revenue
Data Type: decimal
Display As: currency

Companion Clicks

API Name: companion_clicks
NinjaCat System ID: sizmek:MET_companion_clicks
Data Type: integer
Aggregates To: MET_COMPANION_CLICKS

Companion Views

API Name: companion_views
NinjaCat System ID: sizmek:MET_companion_views
Data Type: integer

Conversions

API Name: conversions
NinjaCat System ID: sizmek:MET_conversions
Data Type: integer
Aggregates To: MET_CONVERSIONS

Conv. Rate

NinjaCat System ID: sizmek:MET_conversion_rate
Data Type: decimal
Display As: percent
Aggregates To: MET_CONVERSION_RATE
Formula: sizmek:MET_conversions / sizmek:MET_ActionLeadingToConv

Cost / Conv.

NinjaCat System ID: sizmek:MET_cpa
Data Type: decimal
Display As: currency
Aggregates To: MET_CPA
Formula: sizmek:MET_spend / sizmek:MET_conversions

Count (Unique Dimensions)

NinjaCat System ID: sizmek:MET_COUNT_NC
Data Type: integer
Aggregates To: MET_COUNT_NC

CPC

NinjaCat System ID: sizmek:MET_cpc
Data Type: decimal
Display As: currency
Aggregates To: MET_CPC
Formula: sizmek:MET_spend / sizmek:MET_clicks

CPM

NinjaCat System ID: sizmek:MET_cpm
Data Type: decimal
Display As: currency
Aggregates To: MET_CPM
Formula: 1000 * sizmek:MET_spend / sizmek:MET_impressions

Cross-Device Conversion Rate

NinjaCat System ID: sizmek:MET_cross_device_conversion_rate
Data Type: decimal
Display As: percent
Formula: (sizmek:MET_cross_device_conversions * 100) / sizmek:MET_impressions

Cross-Device Conversions

API Name: cross_device_conversions
NinjaCat System ID: sizmek:MET_cross_device_conversions
Data Type: integer

Cross-Device CPA

NinjaCat System ID: sizmek:MET_cross_device_cpa
Data Type: decimal
Display As: currency
Formula: sizmek:MET_spend / sizmek:MET_cross_device_conversions

CTR

NinjaCat System ID: sizmek:MET_ctr
Data Type: decimal
Display As: percent
Aggregates To: MET_CTR
Formula: sizmek:MET_clicks / sizmek:MET_impressions

Cumulative In Target Impressions

API Name: cumulative_in_target_impressions
NinjaCat System ID: sizmek:MET_cumulative_in_target_impressions
Data Type: integer

Cumulative Uniques In Target

API Name: cumulative_uniques_in_target
NinjaCat System ID: sizmek:MET_cumulative_uniques_in_target
Data Type: integer

Data Cost

API Name: data_cost
NinjaCat System ID: sizmek:MET_data_cost
Data Type: decimal
Display As: currency

DSP Spend

API Name: dsp_spend
NinjaCat System ID: sizmek:MET_dsp_spend
Data Type: integer

Effective CTR

NinjaCat System ID: sizmek:MET_effective_ctr
Data Type: integer
Formula: sizmek:MET_clicks / sizmek:MET_paid_impressions

Effective Target CPM

NinjaCat System ID: sizmek:MET_effective_target_cpm
Data Type: decimal
Display As: currency
Formula: sizmek:MET_spend * 1000 / sizmek:MET_in_target_impressions

Gross Rating Points

NinjaCat System ID: sizmek:MET_gross_rating_points
Data Type: decimal
Display As: percent
Formula: sizmek:MET_in_target_impressions / sizmek:MET_total_population * 100

Impression Day Client Revenue

API Name: impression_day_client_revenue
NinjaCat System ID: sizmek:MET_impression_day_client_revenue
Data Type: decimal
Display As: currency

Impression Day Client Sizmek Client Revenue

API Name: impression_day_rf_client_revenue
NinjaCat System ID: sizmek:MET_impression_day_rf_client_revenue
Data Type: decimal
Display As: currency

Impression Day Conversion Rate

NinjaCat System ID: sizmek:MET_impression_day_conversion_rate
Data Type: decimal
Display As: percent
Formula: (sizmek:MET_impression_day_conversions * 100) / sizmek:MET_impressions

Impression Day Conversions

API Name: impression_day_conversions
NinjaCat System ID: sizmek:MET_impression_day_conversions
Data Type: integer

Impression Day Cross-device Conversions

API Name: impression_day_cross_device_conversions
NinjaCat System ID: sizmek:MET_impression_day_cross_device_conversions
Data Type: integer

Impression Day Performance

API Name: impression_day_performance
NinjaCat System ID: sizmek:MET_impression_day_performance
Data Type: integer

Impression Day ROAS

NinjaCat System ID: sizmek:MET_impression_day_roas
Data Type: decimal
Display As: currency
Formula: sizmek:MET_impression_day_client_revenue / sizmek:MET_spend

Impression Day Sizmek AOV

NinjaCat System ID: sizmek:MET_impression_day_rf_aov
Data Type: decimal
Display As: currency
Formula: sizmek:MET_impression_day_client_revenue / sizmek:MET_conversions

Impression Day Sizmek Click Conversions

API Name: impression_day_rf_click_conversions
NinjaCat System ID: sizmek:MET_impression_day_rf_click_conversions
Data Type: integer

Impression Day Sizmek Conversions

API Name: impression_day_rf_conversions
NinjaCat System ID: sizmek:MET_impression_day_rf_conversions
Data Type: integer

Impression Day Sizmek Cross-device Conversions

API Name: impression_day_rf_cross_device_conversions
NinjaCat System ID: sizmek:MET_impression_day_rf_cross_device_conversions
Data Type: integer

Impression Day Value

API Name: impression_day_value
NinjaCat System ID: sizmek:MET_impression_day_value
Data Type: integer

Impressions

API Name: impressions
NinjaCat System ID: sizmek:MET_impressions
Data Type: integer
Aggregates To: MET_IMPRESSIONS

Incremental Uniques In Target

API Name: incremental_uniques_in_target
NinjaCat System ID: sizmek:MET_incremental_uniques_in_target
Data Type: integer

In Target Impressions

API Name: in_target_impressions
NinjaCat System ID: sizmek:MET_in_target_impressions
Data Type: integer

In-Target Impressions %

NinjaCat System ID: sizmek:MET_in_target_impressions_percentage
Data Type: decimal
Display As: percent
Formula: sizmek:MET_in_target_impressions * 100 / sizmek:MET_vendor_impressions

Media Cost

API Name: media_cost
NinjaCat System ID: sizmek:MET_media_cost
Data Type: decimal
Display As: currency
Aggregates To: MET_MEDIA_COST

Negative Responses

API Name: negative_responses
NinjaCat System ID: sizmek:MET_negative_responses
Data Type: integer

Paid Impressions

API Name: paid_impressions
NinjaCat System ID: sizmek:MET_paid_impressions
Data Type: integer

Partner Commission

API Name: partner_commission
NinjaCat System ID: sizmek:MET_partner_commission
Data Type: integer

Partner Margin Percent

API Name: partner_margin_percent
NinjaCat System ID: sizmek:MET_partner_margin_percentage
Data Type: integer

Performance

API Name: performance
NinjaCat System ID: sizmek:MET_performance
Data Type: integer

Positive Responses

API Name: positive_responses
NinjaCat System ID: sizmek:MET_positive_responses
Data Type: integer

Publisher Impressions

API Name: publisher_impressions
NinjaCat System ID: sizmek:MET_publisher_impressions
Data Type: integer

% Reach

NinjaCat System ID: sizmek:MET_percent_population_reach
Data Type: decimal
Display As: percent
Formula: (sizmek:MET_cumulative_in_target_impressions * 100) / sizmek:MET_total_population

Refresh Time

API Name: refresh_time
NinjaCat System ID: sizmek:MET_refresh_time
Data Type: integer

ROAS

NinjaCat System ID: sizmek:MET_roas
Data Type: decimal
Display As: currency
Formula: sizmek:MET_client_revenue / sizmek:MET_spend

Sizmek Click Conversion Rate

NinjaCat System ID: sizmek:MET_rf_click_conversion_rate
Data Type: decimal
Display As: percent
Formula: (sizmek:MET_rf_click_conversions * 100)/ sizmek:MET_rf_impressions

Sizmek Click Conversions

API Name: rf_click_conversions
NinjaCat System ID: sizmek:MET_rf_click_conversions
Data Type: integer

Sizmek Clicks

API Name: rf_clicks
NinjaCat System ID: sizmek:MET_rf_clicks
Data Type: integer

Sizmek Client Revenue

API Name: rf_client_revenue
NinjaCat System ID: sizmek:MET_rf_client_revenue
Data Type: decimal
Display As: currency

Sizmek Conversion Rate

NinjaCat System ID: sizmek:MET_rf_conversion_rate
Data Type: decimal
Display As: percent
Formula: (sizmek:MET_rf_conversions * 100)/ sizmek:MET_rf_impressions

Sizmek Conversions

API Name: rf_conversions
NinjaCat System ID: sizmek:MET_rf_conversions
Data Type: integer

Sizmek Cross-device Conversions

API Name: rf_cross_device_conversions
NinjaCat System ID: sizmek:MET_rf_cross_device_conversions
Data Type: integer

Sizmek Cross-Device CPA

NinjaCat System ID: sizmek:MET_rf_cross_device_cpa
Data Type: decimal
Display As: currency
Formula: sizmek:MET_spend / sizmek:MET_rf_cross_device_conversions

Sizmek DSP Spend Native

API Name: rf_dsp_spend_native
NinjaCat System ID: sizmek:MET_rf_dsp_spend_native
Data Type: integer

Sizmek Exchange Rate

API Name: rf_exchange_rate
NinjaCat System ID: sizmek:MET_rf_exchange_rate
Data Type: integer

Sizmek Impressions

API Name: rf_impressions
NinjaCat System ID: sizmek:MET_rf_impressions
Data Type: integer

Sizmek Integrated Viewability Inview Impressions

API Name: vendor_in_view_impressions
NinjaCat System ID: sizmek:MET_vendor_in_view_impressions
Data Type: integer

Sizmek Integrated Viewability Measured Impressions

API Name: viewability_vendor_measured_impressions
NinjaCat System ID: sizmek:MET_viewability_vendor_measured_impressions
Data Type: integer

Sizmek In View Impressions

API Name: rf_in_view_impressions
NinjaCat System ID: sizmek:MET_rf_in_view_impressions
Data Type: integer

Sizmek Viewability Measured Impressions

API Name: rf_viewability_measured_impressions
NinjaCat System ID: sizmek:MET_rf_viewability_measured_impressions
Data Type: integer

Sizmek View Conversions

NinjaCat System ID: sizmek:MET_view_conversions
Data Type: integer
Formula: sizmek:MET_rf_conversions - sizmek:MET_rf_click_conversions

Spend

API Name: spend
NinjaCat System ID: sizmek:MET_spend
Data Type: decimal
Display As: currency
Aggregates To: MET_COST

Survey Impressions

API Name: survey_impressions
NinjaCat System ID: sizmek:MET_survey_impressions
Data Type: integer

Total Population

API Name: total_population
NinjaCat System ID: sizmek:MET_total_population
Data Type: integer

Total Responses

NinjaCat System ID: sizmek:MET_total_responses
Data Type: integer
Formula: sizmek:MET_positive_responses + sizmek:MET_negative_responses

Value

API Name: value
NinjaCat System ID: sizmek:MET_value
Data Type: decimal
Display As: currency

Vendor Impressions

API Name: vendor_impressions
NinjaCat System ID: sizmek:MET_vendor_impressions
Data Type: integer

Video Clicks

API Name: video_clicks
NinjaCat System ID: sizmek:MET_video_clicks
Data Type: integer

Video Completion Rate

NinjaCat System ID: sizmek:MET_companion_ctr
Data Type: decimal
Display As: percent
Formula: (sizmek:MET_video_completions * 100)/ sizmek:MET_video_starts

Video Completions

API Name: video_completions
NinjaCat System ID: sizmek:MET_video_completions
Data Type: integer
Aggregates To: MET_VIDEO_COMPLETIONS

Video CTR

NinjaCat System ID: sizmek:MET_video_ctr
Data Type: integer
Formula: sizmek:MET_video_clicks / sizmek:MET_video_views

Video First Quartile Reached

API Name: video_first_quartile_reached
NinjaCat System ID: sizmek:MET_video_first_quartile_reached
Data Type: integer

Video Midpoint Reached

API Name: video_midpoint_reached
NinjaCat System ID: sizmek:MET_video_midpoint_reached
Data Type: integer

Video Starts

API Name: video_starts
NinjaCat System ID: sizmek:MET_video_starts
Data Type: integer
Aggregates To: MET_VIDEO_STARTS

Video Third Quartile Reached

API Name: video_third_quartile_reached
NinjaCat System ID: sizmek:MET_video_third_quartile_reached
Data Type: integer

Video Views

API Name: video_views
NinjaCat System ID: sizmek:MET_video_views
Data Type: integer
Aggregates To: MET_VIDEO_VIEWS

Updated 6 months ago