Google Ad Manager fields

Prev Next

Supermetrics brings all your Google Ad Manager data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

478 metrics279 dimensionsCustom fields

ACCOUNT

account
AccountId
advertiserName
advertiserID
adNetworkName
adNetworkID
REQUESTED_AD_SIZES

ACTIVE VIEW

TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS
TOTAL_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS
TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE
TOTAL_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS
TOTAL_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE
TOTAL_ACTIVE_VIEW_AVERAGE_VIEWABLE_TIME
TOTAL_ACTIVE_VIEW_REVENUE
ADSENSE_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS
ADSENSE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS
ADSENSE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE
ADSENSE_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS
ADSENSE_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE
ADSENSE_ACTIVE_VIEW_AVERAGE_VIEWABLE_TIME
ADSENSE_ACTIVE_VIEW_REVENUE
AD_SERVER_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS
AD_SERVER_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS
AD_SERVER_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE
AD_SERVER_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS
AD_SERVER_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE
AD_SERVER_ACTIVE_VIEW_AVERAGE_VIEWABLE_TIME
AD_SERVER_ACTIVE_VIEW_REVENUE
AD_EXCHANGE_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS
AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS
AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE
AD_EXCHANGE_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS
AD_EXCHANGE_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE
AD_EXCHANGE_ACTIVE_VIEW_AVERAGE_VIEWABLE_TIME
AD_EXCHANGE_ACTIVE_VIEW_REVENUE

AD CONNECTOR

DP_COUNTRY_CRITERIA_ID
DP_COUNTRY_NAME
DP_INVENTORY_TYPE
DP_CREATIVE_SIZE
DP_BRAND_NAME
DP_ADVERTISER_NAME
DP_ADX_BUYER_NETWORK_NAME
DP_MOBILE_DEVICE_NAME
DP_DEVICE_CATEGORY_NAME
DP_TAG_ID
DP_DEAL_ID
DP_APP_ID
CLASSIFIED_ADVERTISER_ID
CLASSIFIED_ADVERTISER_NAME
CLASSIFIED_BRAND_ID
CLASSIFIED_BRAND_NAME
AD_EXCHANGE_OPTIMIZATION_TYPE
DP_IMPRESSIONS
DP_CLICKS
DP_CTR
DP_QUERIES
DP_MATCHED_QUERIES
DP_COST
DP_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS
DP_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS
DP_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS
DP_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE
DP_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE

AD EXCHANGE

EXCHANGE_BIDDING_DEAL_ID
EXCHANGE_BIDDING_DEAL_TYPE
ADXimpressions
ADXtargetedImpressions
ADXclicks
ADXtargetedClicks
ADXCTR
ADXimpressionsPerc
ADXclicksPerc
ADXrevenue
ADXrevenuePercWithoutCPD
ADXrevenuePercWithCPD
ADXCPM
AD_EXCHANGE_COST_PER_CLICK
AD_EXCHANGE_LIFT_EARNINGS
AD_EXCHANGE_MATCHED_REQUEST_ECPM

AD REQUESTS

AD_EXCHANGE_MATCH_RATE
AD_REQUESTS_RPM
MATCHED_AD_REQUESTS
MATCHED_AD_REQUESTS_CTR
MATCHED_AD_REQUESTS_RPM
AD_EXCHANGE_TOTAL_REQUEST_CTR
AD_EXCHANGE_TOTAL_REQUEST_ECPM
AD_EXCHANGE_TOTAL_REQUESTS

AD SERVER

adServerImpressions
adServerTargetedImpressions
adServerClicks
adServerTargetedClicks
adServerCTR
adServerCPMCPCrevenue
adServerCPDrevenue
adServerCPArevenue
adServerRevenue
adServereCPMwithoutCPD
adServereCPMwithCPD
adServerImpressionsPerc
adServerClicksPerc
adServerRevenueWithoutCPD
adServerRevenueWithCPD
adServerDeliveryIndicator
AD_SERVER_DOWNLOADED_IMPRESSIONS
AD_SERVER_UNFILTERED_IMPRESSIONS
AD_SERVER_UNFILTERED_CLICKS
AD_SERVER_BEGIN_TO_RENDER_IMPRESSIONS
AD_SERVER_UNFILTERED_BEGIN_TO_RENDER_IMPRESSIONS

ADSENSE

adsenseImpressions
adsenseTargetedImpressions
adsenseClicks
adsenseTargetedClicks
adsenseCTR
adsenseRevenue
adsenseCPM
adsenseImpressionsPerc
adsenseClicksPerc
adsenseRevenuePercWithoutCPD
adsenseRevenuePercWithCPD

BID

BID_COUNT
BID_AVERAGE_CPM

BUYERS

PROGRAMMATIC_DEAL_ID
PROGRAMMATIC_DEAL_NAME
BUYING_AGENCY_NAME
BUYER_NETWORK_NAME
BIDDER_NAME
ADVERTISER_DOMAIN_NAME
ADVERTISER_VERTICAL_NAME

CREATIVES

creativeName
creativeID
creativeImageURL
creativeImage
creativeType
creativeSize
creativeBillingType
CREATIVE_SIZE_DELIVERED
MASTER_COMPANION_CREATIVE_ID
MASTER_COMPANION_CREATIVE_NAME

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

DEALS

DEALS_BID_REQUESTS
DEALS_BIDS
DEALS_BID_RATE
DEALS_WINNING_BIDS
DEALS_WIN_RATE

DEMAND CHANNEL

DEMAND_CHANNEL_ID
DEMAND_CHANNEL_NAME

DEPRECATED

PROPOSAL_AGENCY_NAME
PRODUCT_TEMPLATE_ID
WORKFLOW_ID
AD_REQUEST_SIZE
PRODUCT_ID
ACTIVITY_GROUP_NAME_BASE
INVENTORY_OWNERSHIP_NAME
ALL_SALESPEOPLE_NAME
RATE_CARD_ID
AD_EXCHANGE_ADVERTISER_NAME
ALL_SALESPEOPLE_ID
activityID
activityName
activityGroupID
VERIFIED_ADVERTISER_NAME
RATE_CARD_NAME
PROPOSAL_ID
AD_EXCHANGE_DEAL_ID
AD_EXCHANGE_OS_VERSION_NAME
AD_EXCHANGE_DEAL_NAME
activityGroupName
AD_EXCHANGE_DEAL_TYPE
WORKFLOW_NAME
ADXpricingRuleID
PRODUCT_NAME
ADXpricingRule
PRODUCT_TEMPLATE_NAME
AD_EXCHANGE_TRANSACTION_TYPE_NAME
PROPOSAL_AGENCY_ID
BUYER_NAME
VERIFIED_ADVERTISER_ID
BUYER_ID
PROPOSAL_LINE_ITEM_NAME
mediationNetworkTag
PROPOSAL_NAME
mediationNetwork
ALL_SALESPEOPLE_NAME_BASE
mediationGroupID
INVENTORY_OWNERSHIP_CODE
mediationGroupName
NETWORK_PARTNER_NAME
NETWORK_PARTNER_ID
SALES_PIPELINE_PIPELINE_GROSS_REVENUE
BILLING_REALIZED_RATE
SALES_CONTRACT_REMAINING_BUDGET
RECONCILIATION_RECONCILED_REVENUE
UNIFIED_REVENUE_UNIFIED_NET_REVENUE
CONTRACTED_REVENUE_LOCAL_CONTRACTED_AGENCY_COMMISSION
dynamicAllocationClicks
SALES_TOTAL_TOTAL_CONTRACTED_VOLUME
mediationEstimatedRevenue
dynamicAllocationCLicksPerc
mediationCPM
adServerCodeServed
AD_REQUESTS_CTR
BILLING_BILLABLE_VAT
dynamicAllocationCPM
SALES_TOTAL_TOTAL_CONTRACTED_NET_REVENUE_WITH_VAT
dynamicAllocationCTR
SALES_TOTAL_TOTAL_REMAINING_BUDGET
dynamicAllocationImpressionsPerc
SALES_CONTRACT_BUDGET
dynamicAllocationImpressions
CONTRACTED_REVENUE_LOCAL_CONTRACTED_GROSS_REVENUE
dynamicAllocationRevenue
BILLING_BILLABLE_NET_REVENUE
dynamicAllocationRevenuePerc
RECONCILIATION_THIRD_PARTY_VOLUME
dynamicAllocationRevenuePercWithoutCPD
BILLING_LOCAL_BILLABLE_GROSS_REVENUE
AD_REQUESTS
BILLING_CAP_QUANTITY
UNIFIED_REVENUE_UNRECONCILED_VOLUME
SALES_CONTRACT_BUFFERED_CLICKS
UNIFIED_REVENUE_FORECASTED_VOLUME
SALES_TOTAL_TOTAL_CONTRACTED_GROSS_REVENUE
UNIFIED_REVENUE_UNIFIED_VOLUME
SCHEDULED_LOCAL_SCHEDULED_NET_REVENUE
REACH
EXPECTED_REVENUE_EXPECTED_NET_REVENUE
REACH_AVERAGE_REVENUE
UNIFIED_REVENUE_UNIFIED_GROSS_REVENUE
REACH_FREQUENCY
SALES_CONTRACT_CONTRACTED_CLICKS
AD_REQUESTS_COVERAGE
CONTRACTED_REVENUE_LOCAL_CONTRACTED_VAT
DEALS_AD_REQUESTS
CONTRACTED_REVENUE_CONTRACTED_NET_REVENUE
AD_EXCHANGE_ACTIVE_VIEW_MEASURABLE
SCHEDULED_SCHEDULED_IMPRESSIONS
AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE
RECONCILIATION_CLICK_DISCREPANCY
AD_EXCHANGE_ACTIVE_VIEW_ENABLED_IMPRESSIONS
RECONCILIATION_RECONCILED_VOLUME
AD_EXCHANGE_ACTIVE_VIEW_MEASURED_IMPRESSIONS
SALES_PIPELINE_PIPELINE_AGENCY_COMMISSION
AD_EXCHANGE_ACTIVE_VIEW_VIEWED_IMPRESSIONS
RECONCILIATION_DFP_VOLUME
AD_EXCHANGE_AVERAGE_VIEWABLE_TIME
DISCOUNTS_BREAKDOWN_BILLABLE_NET_OVERALL_DISCOUNT
controlImpressions
BILLING_BILLABLE_NET_REVENUE_BEFORE_MANUAL_ADJUSTMENT
controlClicks
BILLING_BILLABLE_AGENCY_COMMISSION
controlCTR
BILLING_BILLABLE_GROSS_REVENUE_BEFORE_MANUAL_ADJUSTMENT
optimizedImpressions
EXPECTED_REVENUE_LOCAL_EXPECTED_NET_REVENUE
optimizedClicks
SALES_TOTAL_TOTAL_CONTRACTED_AGENCY_COMMISSION
nonOptimizedImpressions
SALES_TOTAL_TOTAL_CONTRACTED_NET_REVENUE
nonOptimizedClicks
SCHEDULED_LOCAL_SCHEDULED_GROSS_REVENUE
extraClicks
SCHEDULED_SCHEDULED_VOLUME
optimizedCTR
SALES_TOTAL_TOTAL_SCHEDULED_NET_REVENUE
optimizedLift
mediationImpressions
optimizedCoverage
UNIFIED_REVENUE_LOCAL_UNIFIED_NET_REVENUE
OPTIMIZATION_BEHIND_SCHEDULE_IMPRESSIONS
UNIFIED_REVENUE_LOCAL_UNIFIED_GROSS_REVENUE
OPTIMIZATION_NO_CLICKS_RECORDED_IMPRESSIONS
SALES_CONTRACT_CONTRACTED_VOLUME
OPTIMIZATION_SPONSORSHIP_IMPRESSIONS
SALES_CONTRACT_CONTRACTED_IMPRESSIONS
OPTIMIZATION_AS_FAST_AS_POSSIBLE_IMPRESSIONS
CONTRACTED_REVENUE_CONTRACTED_AGENCY_COMMISSION
OPTIMIZATION_NO_ABSOLUTE_LIFETIME_GOAL_IMPRESSIONS
CONTRACTED_REVENUE_CONTRACTED_VAT
OPTIMIZATION_CONTROL_REVENUE
CONTRACTED_REVENUE_LOCAL_CONTRACTED_NET_REVENUE
OPTIMIZATION_OPTIMIZED_REVENUE
CONTRACTED_REVENUE_CONTRACTED_GROSS_REVENUE
OPTIMIZATION_CONTROL_ECPM
SALES_CONTRACT_BUFFERED_IMPRESSIONS
OPTIMIZATION_OPTIMIZED_ECPM
BILLING_LOCAL_BILLABLE_NET_REVENUE
OPTIMIZATION_FREED_UP_IMPRESSIONS
RECONCILIATION_REVENUE_DISCREPANCY
OPTIMIZATION_ECPM_LIFT
RECONCILIATION_IMPRESSION_DISCREPANCY
VIEW_THROUGH_CONVERSIONS
RECONCILIATION_DISCREPANCY
CONVERSIONS_PER_THOUSAND_IMPRESSIONS
BILLING_BILLABLE_GROSS_REVENUE
CLICK_THROUGH_CONVERSIONS
SALES_PIPELINE_LOCAL_PIPELINE_AGENCY_COMMISSION
CONVERSIONS_PER_CLICK
SALES_PIPELINE_LOCAL_PIPELINE_GROSS_REVENUE
VIEW_THROUGH_REVENUE
SALES_PIPELINE_LOCAL_PIPELINE_NET_REVENUE
CLICK_THROUGH_REVENUE
SALES_PIPELINE_PIPELINE_NET_REVENUE
TOTAL_CONVERSIONS
BILLING_LOCAL_BILLABLE_NET_REVENUE_BEFORE_MANUAL_ADJUSTMENT
TOTAL_CONVERSION_REVENUE
DISCOUNTS_BREAKDOWN_CONTRACTED_NET_OVERALL_DISCOUNT
DISCOUNTS_BREAKDOWN_CONTRACTED_NET_NON_BILLABLE
BILLING_REALIZED_CPM
GRP_POPULATION
BILLING_DELIVERY_ROLLOVER_FROM_PREVIOUS
GRP_UNIQUE_AUDIENCE
BILLING_LOCAL_BILLABLE_AGENCY_COMMISSION
GRP_UNIQUE_AUDIENCE_SHARE
BILLING_LOCAL_BILLABLE_VAT
GRP_AUDIENCE_IMPRESSIONS
BILLING_LOCAL_BILLABLE_GROSS_REVENUE_BEFORE_MANUAL_ADJUSTMENT
GRP_AUDIENCE_IMPRESSIONS_SHARE
BILLING_BILLABLE_VOLUME
GRP_AUDIENCE_REACH
EXPECTED_REVENUE_LOCAL_EXPECTED_GROSS_REVENUE
GRP_AUDIENCE_AVERAGE_FREQUENCY
SALES_TOTAL_LOCAL_TOTAL_CONTRACTED_NET_REVENUE_WITH_VAT
GRP_GROSS_RATING_POINTS
SALES_TOTAL_LOCAL_TOTAL_CONTRACTED_AGENCY_COMMISSION
UNIFIED_REVENUE_FORECASTED_GROSS_REVENUE
SALES_TOTAL_LOCAL_TOTAL_CONTRACTED_GROSS_REVENUE
SALES_TOTAL_LOCAL_TOTAL_SCHEDULED_GROSS_REVENUE
SALES_TOTAL_LOCAL_TOTAL_CONTRACTED_NET_REVENUE
UNIFIED_REVENUE_UNRECONCILED_NET_REVENUE
SALES_TOTAL_TOTAL_SCHEDULED_VOLUME
UNIFIED_REVENUE_LOCAL_UNRECONCILED_NET_REVENUE
SALES_TOTAL_TOTAL_BUDGET
UNIFIED_REVENUE_UNRECONCILED_GROSS_REVENUE
SCHEDULED_SCHEDULED_GROSS_REVENUE
UNIFIED_REVENUE_LOCAL_UNRECONCILED_GROSS_REVENUE
SCHEDULED_SCHEDULED_NET_REVENUE
UNIFIED_REVENUE_FORECASTED_NET_REVENUE
SCHEDULED_SCHEDULED_CLICKS
UNIFIED_REVENUE_LOCAL_FORECASTED_NET_REVENUE
EXPECTED_REVENUE_EXPECTED_GROSS_REVENUE
UNIFIED_REVENUE_LOCAL_FORECASTED_GROSS_REVENUE
SALES_TOTAL_TOTAL_SCHEDULED_GROSS_REVENUE
SALES_TOTAL_LOCAL_TOTAL_SCHEDULED_NET_REVENUE
UNIFIED_REVENUE_UNIFIED_AGENCY_COMMISSION
UNIFIED_REVENUE_LOCAL_UNIFIED_AGENCY_COMMISSION

DYNAMIC ALLOCATION

DYNAMIC_ALLOCATION_OPPORTUNITY_IMPRESSIONS_COMPETING_TOTAL
DYNAMIC_ALLOCATION_OPPORTUNITY_ELIGIBLE_IMPRESSIONS_TOTAL
DYNAMIC_ALLOCATION_OPPORTUNITY_IMPRESSIONS_NOT_COMPETING_TOTAL
DYNAMIC_ALLOCATION_OPPORTUNITY_IMPRESSIONS_NOT_COMPETING_TOTALPERCENT
DYNAMIC_ALLOCATION_OPPORTUNITY_SATURATION_RATE_TOTAL
DYNAMIC_ALLOCATION_OPPORTUNITY_MATCH_RATE_TOTAL
DYNAMIC_ALLOCATION_OPPORTUNITY_UNFILLED_IMPRESSIONS_COMPETING

GEOGRAPHY

countryName
countryID
regionName
regionID
metroName
metroID
cityName
cityID
postCode
postCodeID
COUNTRY_CODE

INVENTORY

adUnitID
adUnitName
TOP_LEVEL_AD_UNIT_ID
TOP_LEVEL_AD_UNIT_NAME
customTargetingID
customCriteria
placementID
placementName
targeting
FIRST_LOOK_PRICING_RULE_ID
FIRST_LOOK_PRICING_RULE_NAME
DYNAMIC_ALLOCATION_ID
DYNAMIC_ALLOCATION_NAME
CHANNEL_NAME
AD_EXCHANGE_PRODUCT_CODE
AD_EXCHANGE_PRODUCT_NAME
SITE_NAME
URL_ID
URL_NAME
AD_TYPE_ID
AD_TYPE_NAME

INVOICED IMPRESSIONS

INVOICED_IMPRESSIONS
INVOICED_UNFILLED_IMPRESSIONS

LINE ITEMS

LINE_ITEM_NAME
lineItemID
lineItemType
LINE_ITEM_START_DATE
LINE_ITEM_END_DATE
LINE_ITEM_START_DATE_TIMEZONE
LINE_ITEM_END_DATE_TIMEZONE
LINE_ITEM_STATUS
LINE_ITEM_IS_ARCHIVED
LINE_ITEM_PRIORITY
LINE_ITEM_TARGET_PLATFORM
LINE_ITEM_ENVIRONMENT_TYPE
LINE_ITEM_CONTRACTED_QUANTITY
LINE_ITEM_GOAL_QUANTITY
LINE_ITEM_COST_TYPE
LINE_ITEM_COST_PER_UNIT
LINE_ITEM_DELIVERY_INDICATOR
LINE_ITEM_LAST_RECONCILIATION_DATE_TIME
LINE_ITEM_RECONCILIATION_STATUS
LINE_ITEM_DEAL_INFO
PROPOSAL_LINE_ITEM_LAST_RECONCILIATION_DATE_TIME
PROPOSAL_LINE_ITEM_RECONCILIATION_STATUS
LINE_ITEM_LABELS
LINE_ITEM_LABEL_IDS
LINE_ITEM_OPTIMIZABLE
LINE_ITEM_DELIVERY_PACING
LINE_ITEM_FREQUENCY_CAP

MEDIATION

mediationType

MOBILE & VIDEO

MOBILE_APP_NAME
MOBILE_DEVICE_NAME
MOBILE_INVENTORY_TYPE
VIDEO_FALLBACK_POSITION
VIDEO_METADATA_KEY_ID
VIDEO_METADATA_KEY_NAME
VIDEO_REDIRECT_THIRD_PARTY
VIDEO_VAST_VERSION
VIDEO_BREAK_TYPE
VIDEO_BREAK_TYPE_NAME
VIDEO_AD_REQUEST_DURATION_ID
VIDEO_AD_REQUEST_DURATION
POSITION_OF_POD
OPERATING_SYSTEM_VERSION_ID
OPERATING_SYSTEM_VERSION_NAME
CARRIER_ID
CARRIER_NAME
BANDWIDTH_NAME
VIDEO_AD_DURATION
VIDEO_AD_TYPE_ID
VIDEO_AD_TYPE_NAME

ORDER

orderName
orderID
ORDER_START_DATE
ORDER_START_DATE_TIMEZONE
ORDER_END_DATE
ORDER_END_DATE_TIMEZONE
ORDER_STATUS
ORDER_IS_PROGRAMMATIC
ORDER_IS_ARCHIVED
ORDER_TRAFFICKER_ID
ORDER_TRAFFICKER

OTHER

UNIFIED_PRICING_RULE_ID
UNIFIED_PRICING_RULE_NAME
NIELSEN_SEGMENT
NIELSEN_DEMOGRAPHICS
NIELSEN_RESTATEMENT_DATE
ADVERTISER_NAME_BASE
SALESPERSON_NAME_BASE
GRP_DEMOGRAPHICS
AD_REQUEST_AD_UNIT_SIZES
AD_REQUEST_CUSTOM_CRITERIA
PROPOSAL_LINE_ITEM_ID
CREATIVE_NAME_BASE
ORDER_NAME_BASE
ACTIVITY_NAME_BASE
METRO_NAME_BASE
MASTER_COMPANION_CREATIVE_NAME_BASE
AD_UNIT_NAME_BASE
PLACEMENT_NAME_BASE
COUNTRY_NAME_BASE
REGION_NAME_BASE
CITY_NAME_BASE
POSTAL_CODE_BASE
CONTENT_NAME_BASE
CONTENT_BUNDLE_NAME_BASE
PARTNER_MANAGEMENT_PARTNER_NAME_BASE
PARTNER_MANAGEMENT_PARTNER_LABEL_NAME_BASE
contentBundle
contentID
contentName
contentBundleID
adUnitCode
AD_EXCHANGE_BID_TYPE
DEVICE_CATEGORY_NAME_BASE
LINE_ITEM_CONTRACTED_UNITS
AD_EXCHANGE_MOBILE_APP_NAME
AD_EXCHANGE_THIRD_PARTY_BUYER_ACCOUNT_NAME
AD_EXCHANGE_THIRD_PARTY_NETWORK_TAG_CURRENCY
AD_EXCHANGE_THIRD_PARTY_NETWORK_TAG_NAME
WEB_PROPERTY_CODE
RICH_MEDIA_CUSTOM_EVENT_TIME_NONCALC
RICH_MEDIA_VIDEO_VIEW_RATE_NONCALC
RICH_MEDIA_VIDEO_VIEW_TIME_NONCALC
RICH_MEDIA_INTERACTION_RATE_NONCALC
VIDEO_VIEWERSHIP_VIEW_THROUGH_RATE_NONCALC
RICH_MEDIA_AVERAGE_DISPLAY_TIME_NONCALC
VIDEO_VIEWERSHIP_AVERAGE_VIEW_TIME_NONCALC
VIDEO_VIEWERSHIP_AVERAGE_VIEW_RATE_NONCALC
DYNAMIC_ALLOCATION_OPPORTUNITY_MATCH_RATE_TOTAL_NONCALC
PARTNER_MANAGEMENT_HOST_REVENUE
PARTNER_MANAGEMENT_HOST_ECPM
PARTNER_MANAGEMENT_PARTNER_REVENUE
PARTNER_MANAGEMENT_PARTNER_ECPM
NIELSEN_IMPRESSIONS
SALESPERSON_PERFORMANCE_SHARED_PIPELINE_NET_REVENUE
SALESPERSON_PERFORMANCE_SHARED_PIPELINE_GROSS_REVENUE
SALESPERSON_PERFORMANCE_SHARED_UNIFIED_NET_REVENUE
SALESPERSON_PERFORMANCE_SHARED_UNIFIED_GROSS_REVENUE
NIELSEN_POPULATION_BASE
NIELSEN_IMPRESSIONS_INDEX
NIELSEN_UNIQUE_AUDIENCE
NIELSEN_AUDIENCE_REACHPERCENT
NIELSEN_AVERAGE_FREQUENCY
NIELSEN_GROSS_RATING_POINTS
NIELSEN_IMPRESSIONS_SHAREPERCENT
NIELSEN_POPULATION_SHAREPERCENT
NIELSEN_AUDIENCE_SHAREPERCENT
NIELSEN_AUDIENCE_INDEX
DISCOUNTS_BREAKDOWN_CONTRACTED_NET_PRODUCT_ADJUSTMENT
DISCOUNTS_BREAKDOWN_CONTRACTED_NET_PROPOSAL_DISCOUNT
DISCOUNTS_BREAKDOWN_CONTRACTED_NET_ADVERTISER_DISCOUNT
SELL_THROUGH_SELL_THROUGH_RATE
SELL_THROUGH_AVAILABLE_IMPRESSIONS
SELL_THROUGH_RESERVED_IMPRESSIONS
SELL_THROUGH_FORECASTED_IMPRESSIONS
VIDEO_ERRORS_VAST_2_ERROR_COUNT
VIDEO_VIEWERSHIP_VIEW_THROUGH_RATE
VIDEO_VIEWERSHIP_ENGAGED_VIEW
VIDEO_VIEWERSHIP_SKIP_BUTTON_SHOWN
dynamicAllocationImpressionsOON
adServerCTROON
adServerClicksOON
adServerImpresionsOON
adServerLineItemRevenueWithCPD
unfilledImpressionsOON
revenueLineItem
impressionsIncludingOON
DISCOUNTS_BREAKDOWN_CONTRACTED_NET_EXCLUDED_PREMIUMS
DISCOUNTS_BREAKDOWN_BILLABLE_NET_EXCLUDED_PREMIUMS
DISCOUNTS_BREAKDOWN_BILLABLE_NET_ADVERTISER_DISCOUNT
DISCOUNTS_BREAKDOWN_BILLABLE_NET_PRODUCT_ADJUSTMENT
DISCOUNTS_BREAKDOWN_BILLABLE_NET_PROPOSAL_DISCOUNT
VIDEO_OPTIMIZATION_CONTROL_ENGAGED_VIEW
VIDEO_OPTIMIZATION_CONTROL_COMPLETES
VIDEO_OPTIMIZATION_OPTIMIZED_COMPLETES
VIDEO_OPTIMIZATION_CONTROL_COMPLETION_RATE
VIDEO_OPTIMIZATION_OPTIMIZED_COMPLETION_RATE
VIDEO_OPTIMIZATION_COMPLETION_RATE_LIFT
VIDEO_OPTIMIZATION_CONTROL_SKIP_BUTTON_SHOWN
VIDEO_OPTIMIZATION_OPTIMIZED_SKIP_BUTTON_SHOWN
VIDEO_OPTIMIZATION_OPTIMIZED_ENGAGED_VIEW
VIDEO_OPTIMIZATION_CONTROL_VIEW_THROUGH_RATE
VIDEO_OPTIMIZATION_OPTIMIZED_VIEW_THROUGH_RATE
VIDEO_OPTIMIZATION_VIEW_THROUGH_RATE_LIFT
VIDEO_INTERACTION_VIDEO_SKIPS
VIDEO_INTERACTION_AVERAGE_INTERACTION_RATE
VIDEO_INTERACTION_PAUSE
VIDEO_INTERACTION_RESUME
VIDEO_INTERACTION_REWIND
VIDEO_INTERACTION_MUTE
VIDEO_INTERACTION_UNMUTE
VIDEO_INTERACTION_COLLAPSE
VIDEO_INTERACTION_EXPAND
VIDEO_INTERACTION_FULL_SCREEN

PARTNER MANAGEMENT

PARTNER_MANAGEMENT_PARTNER_NAME
PARTNER_MANAGEMENT_PARTNER_ID
PARTNER_MANAGEMENT_PARTNER_LABEL_NAME
PARTNER_MANAGEMENT_PARTNER_LABEL_ID
PARTNER_MANAGEMENT_ASSIGNMENT_NAME
PARTNER_MANAGEMENT_ASSIGNMENT_ID
CHILD_PARTNER_NAME
PARTNER_MANAGEMENT_HOST_IMPRESSIONS
PARTNER_MANAGEMENT_HOST_CLICKS
PARTNER_MANAGEMENT_HOST_CTR
PARTNER_MANAGEMENT_UNFILLED_IMPRESSIONS
PARTNER_MANAGEMENT_PARTNER_IMPRESSIONS
PARTNER_MANAGEMENT_PARTNER_CLICKS
PARTNER_MANAGEMENT_PARTNER_CTR
PARTNER_MANAGEMENT_GROSS_REVENUE
PARTNER_FINANCE_HOST_IMPRESSIONS
PARTNER_FINANCE_HOST_REVENUE
PARTNER_FINANCE_HOST_ECPM
PARTNER_FINANCE_PARTNER_REVENUE
PARTNER_FINANCE_PARTNER_ECPM
PARTNER_FINANCE_GROSS_REVENUE

PARTNER SALES

PARTNER_SALES_FILLED_QUERIES
PARTNER_SALES_PARTNER_IMPRESSIONS
PARTNER_SALES_PARTNER_CODE_SERVED
PARTNER_SALES_GOOGLE_IMPRESSIONS
PARTNER_SALES_GOOGLE_RESERVATION_IMPRESSIONS
PARTNER_SALES_GOOGLE_AUCTION_IMPRESSIONS
PARTNER_SALES_QUERIES
PARTNER_SALES_SELL_THROUGH_RATE

PROGRAMMATIC

PROGRAMMATIC_RESPONSES_SERVED
PROGRAMMATIC_MATCH_RATE
TOTAL_PROGRAMMATIC_ELIGIBLE_AD_REQUESTS

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts

REQUEST

REQUEST_TYPE

RICH MEDIA

RICH_MEDIA_BACKUP_IMAGES
RICH_MEDIA_DISPLAY_TIME
RICH_MEDIA_AVERAGE_DISPLAY_TIME
RICH_MEDIA_EXPANSIONS
RICH_MEDIA_EXPANDING_TIME
RICH_MEDIA_INTERACTION_COUNT
RICH_MEDIA_INTERACTION_TIME
RICH_MEDIA_INTERACTION_RATE
RICH_MEDIA_AVERAGE_INTERACTION_TIME
RICH_MEDIA_INTERACTION_IMPRESSIONS
RICH_MEDIA_MANUAL_CLOSES
RICH_MEDIA_FULL_SCREEN_IMPRESSIONS
RICH_MEDIA_VIDEO_INTERACTIONS
RICH_MEDIA_VIDEO_INTERACTION_RATE
RICH_MEDIA_VIDEO_MUTES
RICH_MEDIA_VIDEO_PAUSES
RICH_MEDIA_VIDEO_PLAYES
RICH_MEDIA_VIDEO_MIDPOINTS
RICH_MEDIA_VIDEO_COMPLETES
RICH_MEDIA_VIDEO_REPLAYS
RICH_MEDIA_VIDEO_STOPS
RICH_MEDIA_VIDEO_UNMUTES
RICH_MEDIA_VIDEO_VIEW_TIME
RICH_MEDIA_VIDEO_VIEW_RATE
RICH_MEDIA_CUSTOM_EVENT_TIME
RICH_MEDIA_CUSTOM_EVENT_COUNT

SALESPERSON

salespersonID
salespersonName
PROGRAMMATIC_BUYER_ID
PROGRAMMATIC_BUYER_NAME
PROGRAMMATIC_CHANNEL_ID
PROGRAMMATIC_CHANNEL_NAME

SERVING RESTRICTION

SERVING_RESTRICTION_ID
SERVING_RESTRICTION_NAME

TARGETING

AUDIENCE_SEGMENT_ID
AUDIENCE_SEGMENT_NAME
AUDIENCE_SEGMENT_DATA_PROVIDER_NAME
customEventID
customEventName
customEventType
deviceID
deviceName
BRANDING_TYPE_CODE
BRANDING_TYPE_NAME
TARGETING_TYPE_CODE
TARGETING_TYPE_NAME
AD_LOCATION_ID
AD_LOCATION_NAME

TEMPLATE

NATIVE_STYLE_ID
NATIVE_STYLE_NAME
NATIVE_TEMPLATE_ID
NATIVE_TEMPLATE_NAME

TIME

today
Year
month
Yearmonth
yearweek
yearweekiso
yearweekiso_daterange
Dayofweek
DayofweekName
dayOfMonth
Date
Hour

TOTAL

codeServedCount
impressions
targetedimpressions
unfilledImpressions
clicks
targetedClicks
CTR
revenueExcludingCPD
revenue
eCPMwithoutCPD
eCPMwithCPD
SDK_MEDIATION_CREATIVE_IMPRESSIONS
SDK_MEDIATION_CREATIVE_CLICKS
TOTAL_AD_REQUESTS
TOTAL_RESPONSES_SERVED
TOTAL_UNMATCHED_AD_REQUESTS
TOTAL_FILL_RATE
AD_SERVER_RESPONSES_SERVED
ADSENSE_RESPONSES_SERVED
AD_EXCHANGE_RESPONSES_SERVED
DROPOFF_RATE

TRUE VIEW

VIDEO_TRUEVIEW_SKIP_RATE
VIDEO_TRUEVIEW_VIEWS
VIDEO_TRUEVIEW_VTR

VIDEO ERRORS

VIDEO_VIEWERSHIP_TOTAL_ERROR_RATE
VIDEO_ERRORS_VAST_ERROR_100_COUNT
VIDEO_ERRORS_VAST_ERROR_101_COUNT
VIDEO_ERRORS_VAST_ERROR_102_COUNT
VIDEO_ERRORS_VAST_ERROR_200_COUNT
VIDEO_ERRORS_VAST_ERROR_201_COUNT
VIDEO_ERRORS_VAST_ERROR_202_COUNT
VIDEO_ERRORS_VAST_ERROR_203_COUNT
VIDEO_ERRORS_VAST_ERROR_300_COUNT
VIDEO_ERRORS_VAST_ERROR_301_COUNT
VIDEO_ERRORS_VAST_ERROR_302_COUNT
VIDEO_ERRORS_VAST_ERROR_303_COUNT
VIDEO_ERRORS_VAST_ERROR_400_COUNT
VIDEO_ERRORS_VAST_ERROR_401_COUNT
VIDEO_ERRORS_VAST_ERROR_402_COUNT
VIDEO_ERRORS_VAST_ERROR_403_COUNT
VIDEO_ERRORS_VAST_ERROR_405_COUNT
VIDEO_ERRORS_VAST_ERROR_500_COUNT
VIDEO_ERRORS_VAST_ERROR_501_COUNT
VIDEO_ERRORS_VAST_ERROR_502_COUNT
VIDEO_ERRORS_VAST_ERROR_503_COUNT
VIDEO_ERRORS_VAST_ERROR_600_COUNT
VIDEO_ERRORS_VAST_ERROR_601_COUNT
VIDEO_ERRORS_VAST_ERROR_602_COUNT
VIDEO_ERRORS_VAST_ERROR_603_COUNT
VIDEO_ERRORS_VAST_ERROR_604_COUNT
VIDEO_ERRORS_VAST_ERROR_900_COUNT
VIDEO_ERRORS_VAST_ERROR_901_COUNT

VIDEO REALTIME

VIDEO_IMPRESSIONS_REAL_TIME
VIDEO_MATCHED_QUERIES_REAL_TIME
VIDEO_UNMATCHED_QUERIES_REAL_TIME
VIDEO_TOTAL_QUERIES_REAL_TIME
VIDEO_CREATIVE_SERVE_REAL_TIME
VIDEO_VAST_TOTAL_ERROR_COUNT_REAL_TIME

VIDEO VIEWERSHIP

VIDEO_VIEWERSHIP_START
VIDEO_VIEWERSHIP_FIRST_QUARTILE
VIDEO_OPTIMIZATION_CONTROL_STARTS
VIDEO_OPTIMIZATION_OPTIMIZED_STARTS
VIDEO_VIEWERSHIP_MIDPOINT
VIDEO_VIEWERSHIP_THIRD_QUARTILE
VIDEO_VIEWERSHIP_COMPLETE
VIDEO_VIEWERSHIP_AVERAGE_VIEW_RATE
VIDEO_VIEWERSHIP_AVERAGE_VIEW_TIME
VIDEO_VIEWERSHIP_COMPLETION_RATE
VIDEO_VIEWERSHIP_TOTAL_ERROR_COUNT
VIDEO_VIEWERSHIP_VIDEO_LENGTH
VIDEO_VIEWERSHIP_AUTO_PLAYS
VIDEO_VIEWERSHIP_CLICK_TO_PLAYS

VISITOR REACH

UNIQUE_REACH
UNIQUE_REACH_IMPRESSIONS
UNIQUE_REACH_FREQUENCY

YIELD

YIELD_GROUP_ID
YIELD_GROUP_NAME
YIELD_PARTNER
YIELD_PARTNER_TAG
YIELD_GROUP_CALLOUTS
YIELD_GROUP_SUCCESSFUL_RESPONSES
YIELD_GROUP_BIDS
YIELD_GROUP_BIDS_IN_AUCTION
YIELD_GROUP_AUCTIONS_WON
YIELD_GROUP_IMPRESSIONS
YIELD_GROUP_ESTIMATED_REVENUE
YIELD_GROUP_ESTIMATED_CPM
YIELD_GROUP_MEDIATION_FILL_RATE
YIELD_GROUP_MEDIATION_PASSBACKS
YIELD_GROUP_MEDIATION_THIRD_PARTY_ECPM
YIELD_GROUP_MEDIATION_CHAINS_SERVED