Release Notes
April 2024
We have upgraded our Google Ad Manager connector from version 202311 to 202402 of the Google Ad Manager API. As part of the upgrade, we have added the following columns: - ad_server_cpm_and_cpc_revenue_gross
- ad_server_all_revenue_gross
For more information, see Google Ad Manager API's changelog.
February 2024
We have added a new configuration option, Custom dimensions, to the connector setup form. You can now select and sync custom dimensions in reports. For more information, see our setup instructions.
December 2023
We have upgraded our Google Ad Manager connector from version 202305 to 202311 of the Google Ad Manager API. As a part of the upgrade, we have made the following changes:
- Removed the
adsense_active_view_revenue
andad_exchange_active_view_revenue
columns - Added a new dimension attributes,
LINE_ITEM_COMPUTED_STATUS
For more information about the changes, see Google Ad Manager's API changelog.
October 2023
We have added the ability to update the Historical Sync Time Frame value even after a Google connector has been set up.
The following connectors now support this feature:
- Google Ads
- Google Ads Manager
- Google Analytics 4
- Google Campaign Manager 360
- Google Display Video 360
- Google Search Ads 360
- Google Search Console.
WARNING: Updating the timeframe option to a larger value will trigger a connector re-sync.
August 2023
We have added a new configuration option, Custom fields, to the connector setup form. You can now select and sync up to 15 custom fields in a report. For more information, see our setup instructions.
May 2023
We have upgraded our Google Ad Manager connector from version 202211 to 202305 of the Google Ad Manager API. As part of the upgrade, we have made the following changes:
We have added the following new columns:
BID_AVERAGE_CPM
BID_COUNT
DEALS_BIDS
DEALS_BID_RATE
DEALS_BID_REQUESTS
DEALS_WINNING_BIDS
DEALS_WIN_RATE
PROGRAMMATIC_MATCH_RATE
PROGRAMMATIC_RESPONSES_SERVED
TOTAL_PROGRAMMATIC_ELIGIBLE_AD_REQUESTS
YIELD_GROUP_AUCTIONS_WON
YIELD_GROUP_BIDS
YIELD_GROUP_BIDS_IN_AUCTION
YIELD_GROUP_CALLOUTS
YIELD_GROUP_ESTIMATED_CPM
YIELD_GROUP_ESTIMATED_REVENUE
YIELD_GROUP_IMPRESSIONS
YIELD_GROUP_MEDIATION_CHAINS_SERVED
YIELD_GROUP_MEDIATION_FILL_RATE
YIELD_GROUP_MEDIATION_PASSBACKS
YIELD_GROUP_MEDIATION_THIRD_PARTY_ECPM
YIELD_GROUP_SUCCESSFUL_RESPONSES
We have added the following new dimensions:
AD_TECHNOLOGY_PROVIDER_DOMAIN
AD_TECHNOLOGY_PROVIDER_ID
AD_TECHNOLOGY_PROVIDER_NAME
BID_RANGE
BID_REJECTION_REASON
BID_REJECTION_REASON_NAME
DATE_PT
DAY_OF_WEEK_PT
IS_ADX_DIRECT
MONTH_YEAR_PT
TCF_VENDOR_ID
TCF_VENDOR_NAME
WEEK_PT
We have removed the following dimensions:
INVENTORY_OWNERSHIP_CODE
INVENTORY_OWNERSHIP_NAME
NETWORK_PARTNER_ID
NETWORK_PARTNER_NAME
For more information about the changes, see Google Ad Manager API's changelog.
December 2022
We have upgraded our Google Ad Manager connector from version 202205 to 202211 of the Ad Manager API and handled deprecations and updates. Learn more about the deprecations and changes in Google's Ad Manager API documentation.
Removed columns:
OPTIMIZATION_AS_FAST_AS_POSSIBLE_IMPRESSIONS
OPTIMIZATION_BEHIND_SCHEDULE_IMPRESSIONS
OPTIMIZATION_CONTROL_CLICKS
OPTIMIZATION_CONTROL_CTR
OPTIMIZATION_CONTROL_ECPM
OPTIMIZATION_CONTROL_IMPRESSIONS
OPTIMIZATION_CONTROL_REVENUE
OPTIMIZATION_COVERAGE
OPTIMIZATION_ECPM_LIFT
OPTIMIZATION_EXTRA_CLICKS
OPTIMIZATION_FREED_UP_IMPRESSIONS
OPTIMIZATION_LIFT
OPTIMIZATION_NON_OPTIMIZED_CLICKS
OPTIMIZATION_NON_OPTIMIZED_IMPRESSIONS
OPTIMIZATION_NO_ABSOLUTE_LIFETIME_GOAL_IMPRESSIONS
OPTIMIZATION_NO_CLICKS_RECORDED_IMPRESSIONS
OPTIMIZATION_OPTIMIZED_CLICKS
OPTIMIZATION_OPTIMIZED_CTR
OPTIMIZATION_OPTIMIZED_ECPM
OPTIMIZATION_OPTIMIZED_IMPRESSIONS
OPTIMIZATION_OPTIMIZED_REVENUE
OPTIMIZATION_SPONSORSHIP_IMPRESSIONS
New columns:
AD_SERVER_BEGIN_TO_RENDER_IMPRESSIONS
AD_SERVER_UNFILTERED_BEGIN_TO_RENDER_IMPRESSIONS
NIELSEN_IN_TARGET_RATIO
PARTNER_SALES_FILLED_QUERIES
PARTNER_SALES_GOOGLE_AUCTION_IMPRESSIONS
PARTNER_SALES_GOOGLE_IMPRESSIONS
PARTNER_SALES_GOOGLE_RESERVATION_IMPRESSIONS
PARTNER_SALES_PARTNER_CODE_SERVED
PARTNER_SALES_PARTNER_IMPRESSIONS
PARTNER_SALES_QUERIES
PARTNER_SALES_SELL_THROUGH_RATE
VIDEO_CREATIVE_SERVE_REAL_TIME
VIDEO_IMPRESSIONS_REAL_TIME
VIDEO_MATCHED_QUERIES_REAL_TIME
VIDEO_TOTAL_QUERIES_REAL_TIME
VIDEO_UNMATCHED_QUERIES_REAL_TIME
VIDEO_VAST3_ERROR_100_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_101_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_102_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_200_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_201_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_202_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_203_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_300_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_301_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_302_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_303_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_400_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_401_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_402_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_403_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_405_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_500_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_501_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_502_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_503_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_600_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_601_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_602_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_603_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_604_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_900_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_901_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_406_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_407_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_408_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_409_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_410_COUNT_REAL_TIME
VIDEO_VAST_TOTAL_ERROR_COUNT_REAL_TIME
New dimensions:
EXCHANGE_BIDDING_DEAL_ID
EXCHANGE_BIDDING_DEAL_TYPE
New dimension attributes:
CHILD_PARTNER_NAME
November 2022
We have added a new field, Ad unit view, to the connector setup form. Now, you can choose Top Level, Flat, or Hierarchical ad unit view.
June 2022
We have upgraded our Google Ad Manager connector from version 202111 to 202205 of the Ad Manager API and handled deprecations and updates. Learn more about the deprecations and changes in Google's Ad Manager API documentation.
Removed columns:
AD_EXCHANGE_ACTIVE_VIEW_ENABLED_IMPRESSIONS
AD_EXCHANGE_ACTIVE_VIEW_MEASURABLE
AD_EXCHANGE_ACTIVE_VIEW_MEASURED_IMPRESSIONS
AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE
AD_EXCHANGE_ACTIVE_VIEW_VIEWED_IMPRESSIONS
AD_EXCHANGE_AD_CTR
AD_EXCHANGE_AD_ECPM
AD_EXCHANGE_AD_REQUESTS
AD_EXCHANGE_AD_REQUEST_CTR
AD_EXCHANGE_AD_REQUEST_ECPM
AD_EXCHANGE_AVERAGE_VIEWABLE_TIME
AD_EXCHANGE_CLICKS
AD_EXCHANGE_COVERAGE
AD_EXCHANGE_CPC
AD_EXCHANGE_CTR
AD_EXCHANGE_DEALS_AD_REQUESTS
AD_EXCHANGE_DEALS_BID_RESPONSES
AD_EXCHANGE_DEALS_MATCHED_REQUESTS
AD_EXCHANGE_DEALS_MATCH_RATE
AD_EXCHANGE_ESTIMATED_REVENUE
AD_EXCHANGE_IMPRESSIONS
AD_EXCHANGE_LIFT
AD_EXCHANGE_MATCHED_ECPM
AD_EXCHANGE_MATCHED_REQUESTS
AD_EXCHANGE_VIDEO_ABANDONMENT_RATE
AD_EXCHANGE_VIDEO_AUTO_PLAY
AD_EXCHANGE_VIDEO_CLICK_TO_PLAY
AD_EXCHANGE_VIDEO_COLLAPSE
AD_EXCHANGE_VIDEO_COMPLETE
AD_EXCHANGE_VIDEO_COMPLETION_RATE
AD_EXCHANGE_VIDEO_DROPOFF_RATE
AD_EXCHANGE_VIDEO_EXPAND
AD_EXCHANGE_VIDEO_FULL_SCREEN
AD_EXCHANGE_VIDEO_MIDPOINT
AD_EXCHANGE_VIDEO_MUTE
AD_EXCHANGE_VIDEO_PAUSE
AD_EXCHANGE_VIDEO_QUARTILE_1
AD_EXCHANGE_VIDEO_QUARTILE_3
AD_EXCHANGE_VIDEO_RESUME
AD_EXCHANGE_VIDEO_REWIND
AD_EXCHANGE_VIDEO_SKIPPED
AD_EXCHANGE_VIDEO_START
AD_EXCHANGE_VIDEO_TOTAL_ERROR_RATE
AD_EXCHANGE_VIDEO_TOTAL_VAST_ERROR_COUNT
AD_EXCHANGE_VIDEO_TRUEVIEW_SKIP_RATE
AD_EXCHANGE_VIDEO_TRUEVIEW_VIEWS
AD_EXCHANGE_VIDEO_TRUEVIEW_VTR
AD_EXCHANGE_VIDEO_UNMUTE
AD_EXCHANGE_VIDEO_VAST2_ERROR_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_100_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_101_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_102_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_200_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_201_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_202_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_203_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_300_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_301_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_302_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_303_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_400_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_401_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_402_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_403_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_405_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_500_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_501_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_502_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_503_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_600_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_601_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_602_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_603_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_604_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_900_COUNT
AD_EXCHANGE_VIDEO_VAST_ERROR_901_COUNT
AD_SERVER_ALL_REVENUE_GROSS
AD_SERVER_CPM_AND_CPC_REVENUE_GROSS
Removed dimensions:
AD_EXCHANGE_ADVERTISER_DOMAIN
AD_EXCHANGE_ADVERTISER_NAME
AD_EXCHANGE_ADVERTISER_VERTICAL
AD_EXCHANGE_AD_LOCATION
AD_EXCHANGE_AD_TYPE
AD_EXCHANGE_AGENCY
AD_EXCHANGE_BID_TYPE_CODE
AD_EXCHANGE_BRANDING_TYPE_CODE
AD_EXCHANGE_BRANDING_TYPE
AD_EXCHANGE_BRAND_NAME
AD_EXCHANGE_BUYER_NETWORK_ID
AD_EXCHANGE_BUYER_NETWORK_NAME
AD_EXCHANGE_CHANNEL_NAME
AD_EXCHANGE_COUNTRY_CODE
AD_EXCHANGE_COUNTRY_NAME
AD_EXCHANGE_CREATIVE_SIZES
AD_EXCHANGE_CUSTOM_CHANNEL_CODE
AD_EXCHANGE_CUSTOM_CHANNEL_ID
AD_EXCHANGE_DATE
AD_EXCHANGE_DEAL_ID
AD_EXCHANGE_DEAL_NAME
AD_EXCHANGE_DEVICE_CATEGORY
AD_EXCHANGE_DFP_AD_UNIT_ID
AD_EXCHANGE_DFP_AD_UNIT
AD_EXCHANGE_DFP_MOBILE_APP_NAME
AD_EXCHANGE_DSP_BUYER_NETWORK_NAME
AD_EXCHANGE_EXPANSION_TYPE
AD_EXCHANGE_INVENTORY_OWNERSHIP
AD_EXCHANGE_INVENTORY_SIZE_CODE
AD_EXCHANGE_INVENTORY_SIZE
AD_EXCHANGE_MOBILE_APP_RESOLVED_ID
AD_EXCHANGE_MOBILE_CARRIER_NAME
AD_EXCHANGE_MOBILE_DEVICE_NAME
AD_EXCHANGE_MOBILE_INVENTORY_TYPE
AD_EXCHANGE_MONTH
AD_EXCHANGE_NETWORK_PARTNER_NAME
AD_EXCHANGE_OPERATING_SYSTEM
AD_EXCHANGE_PRICING_RULE_ID
AD_EXCHANGE_PRICING_RULE_NAME
AD_EXCHANGE_REQUEST_SOURCES
AD_EXCHANGE_SITE_NAME
AD_EXCHANGE_TAG_CODE
AD_EXCHANGE_TAG_NAME
AD_EXCHANGE_TARGETING_TYPE_CODE
AD_EXCHANGE_TARGETING_TYPE
AD_EXCHANGE_TRANSACTION_TYPE_CODE
AD_EXCHANGE_TRANSACTION_TYPE
AD_EXCHANGE_URL_ID
AD_EXCHANGE_URL
AD_EXCHANGE_USER_BANDWIDTH_NAME
AD_EXCHANGE_VIDEO_AD_DURATION_RAW
AD_EXCHANGE_VIDEO_AD_DURATION
AD_EXCHANGE_VIDEO_AD_TYPE
AD_EXCHANGE_WEB_PROPERTY_CODE
AD_EXCHANGE_WEEK
New columns:
AD_EXCHANGE_COST_PER_CLICK
AD_EXCHANGE_LIFT_EARNINGS
AD_EXCHANGE_MATCHED_REQUEST_CTR
AD_EXCHANGE_MATCHED_REQUEST_ECPM
AD_EXCHANGE_MATCH_RATE
AD_EXCHANGE_TOTAL_REQUESTS
AD_EXCHANGE_TOTAL_REQUEST_CTR
AD_EXCHANGE_TOTAL_REQUEST_ECPM
DROPOFF_RATE
VIDEO_TRUEVIEW_SKIP_RATE
VIDEO_TRUEVIEW_VIEWS
VIDEO_TRUEVIEW_VTR
New dimensions:
ADVERTISER_DOMAIN_NAME
ADVERTISER_VERTICAL_NAME
AD_LOCATION_ID
AD_LOCATION_NAME
AD_TYPE_ID
AD_TYPE_NAME
BANDWIDTH_ID
BANDWIDTH_NAME
BIDDER_ID
BIDDER_NAME
BRANDING_TYPE_CODE
BRANDING_TYPE_NAME
BUYER_NETWORK_ID
BUYER_NETWORK_NAME
BUYING_AGENCY_NAME
CARRIER_ID
CARRIER_NAME
CHANNEL_NAME
COUNTRY_CODE
DYNAMIC_ALLOCATION_ID
DYNAMIC_ALLOCATION_NAME
FIRST_LOOK_PRICING_RULE_ID
FIRST_LOOK_PRICING_RULE_NAME
INVENTORY_OWNERSHIP_CODE
INVENTORY_OWNERSHIP_NAME
NETWORK_PARTNER_ID
NETWORK_PARTNER_NAME
OPERATING_SYSTEM_VERSION_ID
OPERATING_SYSTEM_VERSION_NAME
PROGRAMMATIC_DEAL_ID
PROGRAMMATIC_DEAL_NAME
SERVING_RESTRICTION_ID
SERVING_RESTRICTION_NAME
SITE_NAME
TARGETING_TYPE_CODE
TARGETING_TYPE_NAME
URL_ID
URL_NAME
VIDEO_AD_DURATION
VIDEO_AD_TYPE_ID
VIDEO_AD_TYPE_NAME
WEB_PROPERTY_CODE
November 2021
We have upgraded our Google Ad Manager connector from version 202102 to 202111 of the Ad Manager API and handled deprecations and updates. Learn more about the deprecations and changes in Google Ad Manager's API documentation.
Removed columns:
AD_SERVER_INVENTORY_LEVEL_WITH_CPD_PERCENT_REVENUE
TOTAL_INVENTORY_LEVEL_ALL_REVENUE
TOTAL_INVENTORY_LEVEL_WITH_CPD_AVERAGE_ECPM
New dimensions:
INVENTORY_SHARE_ASSIGNMENT_ID
INVENTORY_SHARE_ASSIGNMENT_NAME
INVENTORY_SHARE_OUTCOME
New columns:
TOTAL_VIDEO_MATCHED_OPPORTUNITIES
TOTAL_VIDEO_MATCHED_DURATION
TOTAL_VIDEO_DURATION
TOTAL_VIDEO_BREAK_START
TOTAL_VIDEO_BREAK_END
April 2021
We have upgraded our Google Ad Manager connector from version 202008 to 202102 of the Ad Manager API and handled deprecations and updates. Learn more about the deprecations and changes in Google Ad Manager's API documentation.
Removed dimensions:
AD_EXCHANGE_MOBILE_APP_NAME
Removed columns:
DYNAMIC_ALLOCATION_INVENTORY_LEVEL_WITH_CPD_PERCENT_REVENUE
New dimensions:
AD_EXCHANGE_DFP_MOBILE_APP_NAME
AD_EXCHANGE_MOBILE_APP_RESOLVED_ID
BROWSER_NAME
CLASSIFIED_YIELD_PARTNER_NAME
DOMAIN
MOBILE_APP_RESOLVED_ID
UNIFIED_PRICING_RULE_ID
UNIFIED_PRICING_RULE_NAME
VIDEO_PLACEMENT_NAME
New columns:
CREATIVE_LOAD_TIME_0_500_MS_PERCENT
CREATIVE_LOAD_TIME_500_1000_MS_PERCENT
CREATIVE_LOAD_TIME_1_2_S_PERCENT
CREATIVE_LOAD_TIME_2_4_S_PERCENT
CREATIVE_LOAD_TIME_4_8_S_PERCENT
CREATIVE_LOAD_TIME_GREATER_THAN_8_S_PERCENT
UNVIEWED_REASON_SLOT_NEVER_ENTERED_VIEWPORT_PERCENT
UNVIEWED_REASON_USER_SCROLLED_BEFORE_AD_FILLED_PERCENT
UNVIEWED_REASON_USER_SCROLLED_BEFORE_AD_LOADED_PERCENT
UNVIEWED_REASON_USER_SCROLLED_BEFORE_1_S_PERCENT
UNVIEWED_REASON_OTHER_PERCENT
PAGE_NAVIGATION_TO_TAG_LOADED_TIME_0_500_MS_PERCENT
PAGE_NAVIGATION_TO_TAG_LOADED_TIME_500_1000_MS_PERCENT
PAGE_NAVIGATION_TO_TAG_LOADED_TIME_1_2_S_PERCENT
PAGE_NAVIGATION_TO_TAG_LOADED_TIME_2_4_S_PERCENT
PAGE_NAVIGATION_TO_TAG_LOADED_TIME_4_8_S_PERCENT
PAGE_NAVIGATION_TO_TAG_LOADED_TIME_GREATER_THAN_8_S_PERCENT
PAGE_NAVIGATION_TO_FIRST_AD_REQUEST_TIME_0_500_MS_PERCENT
PAGE_NAVIGATION_TO_FIRST_AD_REQUEST_TIME_500_1000_MS_PERCENT
PAGE_NAVIGATION_TO_FIRST_AD_REQUEST_TIME_1_2_S_PERCENT
PAGE_NAVIGATION_TO_FIRST_AD_REQUEST_TIME_2_4_S_PERCENT
PAGE_NAVIGATION_TO_FIRST_AD_REQUEST_TIME_4_8_S_PERCENT
PAGE_NAVIGATION_TO_FIRST_AD_REQUEST_TIME_GREATER_THAN_8_S_PERCENT
TAG_LOAD_TO_FIRST_AD_REQUEST_TIME_0_500_MS_PERCENT
TAG_LOAD_TO_FIRST_AD_REQUEST_TIME_500_1000_MS_PERCENT
TAG_LOAD_TO_FIRST_AD_REQUEST_TIME_1_2_S_PERCENT
TAG_LOAD_TO_FIRST_AD_REQUEST_TIME_2_4_S_PERCENT
TAG_LOAD_TO_FIRST_AD_REQUEST_TIME_4_8_S_PERCENT
TAG_LOAD_TO_FIRST_AD_REQUEST_TIME_GREATER_THAN_8_S_PERCENT
New dimension attributes:
LINE_ITEM_AVERAGE_NUMBER_OF_VIEWERS
January 2021
We have upgraded our Google Ad Manager connector from version 202005 to 202008 of the Ad Manager API and handled deprecations and updates. Learn more about the deprecations and changes in Google Ad Manager's API documentation.
We deprecated the following columns on January 13, 2021 to support version 202008 of the Ad Manager API:
grp_population
grp_unique_audience
grp_unique_audience_share
grp_audience_impressions
grp_audience_impressions_share
grp_audience_reach
grp_audience_average_frequency
grp_gross_rating_points
Be sure to update your queries. Learn more about available report columns in Google Ad Manager's API documentation.
December 2020
We have added a new connector setup test to validate if we can sync the report you selected in the setup form. This test fails if you select Columns, Dimensions, or Dimension Attributes that are incompatible with the report type.
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the following connectors by adding the auth
section to payloads:
- AdRoll
- Facebook Pages
- Front
- Google Ad Manager
- Help Scout
- LinkedIn Ad Analytics
- Optimizely
- Pipedrive
- SurveyMonkey
- Zendesk Chat
- Zendesk Support
August 2020
We are temporarily discontinuing cms_metadata dimension
support.
July 2020
We have removed dimensions that are no longer supported in the Google Ad Manager reporting service. Read more about available dimensions in Google's Ad Manager API documentation.
Removed dimensions:
order_delivery_status
parent_ad_unit_id
parent_ad_unit_name
placement_status
video_break_type
video_break_type_name
is_first_look_deal
ad_unit_status
We have upgraded our Google Ad Manager connector from version 201911 to 202005 of the Ad Manager API and handled deprecations and updates. Read more about the deprecations and changes in Google's Ad Manager API documentation.
New dimensions:
custom_spot_id
custom_spot_name
nielsen_device_id
nielsen_device_name
New columns:
ad_server_cpm_and_cpc_revenue_gross
ad_server_all_revenue_gross
ad_exchange_video_auto_play
ad_exchange_video_click_to_play
ad_exchange_video_start
ad_exchange_video_midpoint
ad_exchange_video_complete
ad_exchange_video_completion_rate
ad_exchange_video_collapse
ad_exchange_video_expand
ad_exchange_video_full_screen
ad_exchange_video_mute
ad_exchange_video_pause
ad_exchange_video_resume
ad_exchange_video_rewind
ad_exchange_video_skipped
ad_exchange_video_unmute
ad_exchange_video_vast2_error_count
ad_exchange_video_vast_error_100_count
ad_exchange_video_vast_error_101_count
ad_exchange_video_vast_error_102_count
ad_exchange_video_vast_error_200_count
ad_exchange_video_vast_error_201_count
ad_exchange_video_vast_error_202_count
ad_exchange_video_vast_error_203_count
ad_exchange_video_vast_error_300_count
ad_exchange_video_vast_error_301_count
ad_exchange_video_vast_error_302_count
ad_exchange_video_vast_error_303_count
ad_exchange_video_vast_error_400_count
ad_exchange_video_vast_error_401_count
ad_exchange_video_vast_error_402_count
ad_exchange_video_vast_error_403_count
ad_exchange_video_vast_error_405_count
ad_exchange_video_vast_error_500_count
ad_exchange_video_vast_error_501_count
ad_exchange_video_vast_error_502_count
ad_exchange_video_vast_error_503_count
ad_exchange_video_vast_error_600_count
ad_exchange_video_vast_error_601_count
ad_exchange_video_vast_error_602_count
ad_exchange_video_vast_error_603_count
ad_exchange_video_vast_error_604_count
ad_exchange_video_vast_error_900_count
ad_exchange_video_vast_error_901_count
ad_exchange_video_total_vast_error_count
ad_exchange_video_total_error_rate
total_video_opportunities
total_video_capped_opportunities
dp_ecpm
June 2020
You can now configure your Google Ad Manager connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
We have upgraded our Google Ad Manager connector from version 201908 to 201911 of the Ad Manager API and handled deprecations and updates. Read more about the deprecations and changes in Google's Ad Manager API documentation.
New dimensions:
cms_metadata
child_network_id
child_network_code
Deprecated dimensions:
proposal_line_item_id
proposal_line_item_name
proposal_id
proposal_name
all_salespeople_id
all_salespeople_name
sales_team_id
sales_team_name
proposal_agency_id
proposal_agency_name
product_id
product_name
product_template_id
product_template_name
rate_card_id
rate_card_name
workflow_id
workflow_name
package_id
package_name
product_package_id
product_package_name
New columns:
unique_reach_frequency
unique_reach_impressions
unique_reach
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
Deprecated columns:
reach_frequency
reach_average_revenue
reach
contracted_revenue_contracted_net_revenue
contracted_revenue_local_contracted_net_revenue
contracted_revenue_contracted_gross_revenue
contracted_revenue_local_contracted_gross_revenue
contracted_revenue_contracted_vat
contracted_revenue_local_contracted_vat
contracted_revenue_contracted_agency_commission
contracted_revenue_local_contracted_agency_commission
sales_contract_contracted_impressions
sales_contract_contracted_clicks
sales_contract_contracted_volume
sales_contract_budget
sales_contract_remaining_budget
sales_contract_buffered_impressions
sales_contract_buffered_clicks
scheduled_scheduled_impressions
scheduled_scheduled_clicks
scheduled_scheduled_volume
scheduled_scheduled_net_revenue
scheduled_local_scheduled_net_revenue
scheduled_scheduled_gross_revenue
scheduled_local_scheduled_gross_revenue
sales_total_total_budget
sales_total_total_remaining_budget
sales_total_total_contracted_volume
sales_total_total_contracted_net_revenue
sales_total_local_total_contracted_net_revenue
sales_total_total_contracted_gross_revenue
sales_total_local_total_contracted_gross_revenue
sales_total_total_contracted_agency_commission
sales_total_local_total_contracted_agency_commission
sales_total_total_contracted_net_revenue_with_vat
sales_total_local_total_contracted_net_revenue_with_vat
sales_total_total_scheduled_volume
sales_total_total_scheduled_net_revenue
sales_total_local_total_scheduled_net_revenue
sales_total_total_scheduled_gross_revenue
sales_total_local_total_scheduled_gross_revenue
unified_revenue_unreconciled_net_revenue
unified_revenue_local_unreconciled_net_revenue
unified_revenue_unreconciled_gross_revenue
unified_revenue_local_unreconciled_gross_revenue
unified_revenue_forecasted_net_revenue
unified_revenue_local_forecasted_net_revenue
unified_revenue_forecasted_gross_revenue
unified_revenue_local_forecasted_gross_revenue
unified_revenue_unified_net_revenue
unified_revenue_local_unified_net_revenue
unified_revenue_unified_gross_revenue
unified_revenue_local_unified_gross_revenue
unified_revenue_unified_agency_commission
unified_revenue_local_unified_agency_commission
unified_revenue_unreconciled_volume
unified_revenue_forecasted_volume
unified_revenue_unified_volume
expected_revenue_expected_net_revenue
expected_revenue_local_expected_net_revenue
expected_revenue_expected_gross_revenue
expected_revenue_local_expected_gross_revenue
sales_pipeline_pipeline_net_revenue
sales_pipeline_local_pipeline_net_revenue
sales_pipeline_pipeline_gross_revenue
sales_pipeline_local_pipeline_gross_revenue
sales_pipeline_pipeline_agency_commission
sales_pipeline_local_pipeline_agency_commission
reconciliation_dfp_volume
reconciliation_third_party_volume
reconciliation_reconciled_volume
reconciliation_discrepancy
reconciliation_reconciled_revenue
reconciliation_impression_discrepancy
reconciliation_click_discrepancy
reconciliation_revenue_discrepancy
billing_billable_net_revenue
billing_local_billable_net_revenue
billing_billable_gross_revenue
billing_local_billable_gross_revenue
billing_billable_net_revenue_before_manual_adjustment
billing_local_billable_net_revenue_before_manual_adjustment
billing_billable_gross_revenue_before_manual_adjustment
billing_local_billable_gross_revenue_before_manual_adjustment
billing_billable_vat
billing_local_billable_vat
billing_billable_agency_commission
billing_local_billable_agency_commission
billing_cap_quantity
billing_billable_volume
billing_delivery_rollover_from_previous
billing_realized_cpm
billing_realized_rate
discounts_breakdown_contracted_net_overall_discount
discounts_breakdown_billable_net_overall_discount
discounts_breakdown_contracted_net_non_billable
Deprecated dimension attributes:
proposal_start_date_time
proposal_end_date_time
proposal_creation_date_time
proposal_sold_date_time
proposal_is_sold
proposal_probability_to_close
proposal_status_v2
proposal_archival_status
proposal_currency
proposal_exchange_rate
proposal_agency_commission_rate
proposal_vat_rate
proposal_discount
proposal_advertiser_discount
proposal_advertiser
proposal_advertiser_id
proposal_agencies
proposal_agency_ids
proposal_po_number
proposal_primary_salesperson
proposal_secondary_salespeople
proposal_creator
proposal_sales_planners
proposal_pricing_model
proposal_billing_source
proposal_billing_cap
proposal_billing_schedule
proposal_applied_team_names
proposal_approval_stage
proposal_inventory_release_date_time
proposal_local_budget
proposal_local_remaining_budget
proposal_flat_fee
proposal_is_programmatic
proposal_line_item_start_date_time
proposal_line_item_end_date_time
proposal_line_item_rate_type
proposal_line_item_reservation_status
proposal_line_item_cost_per_unit
proposal_line_item_local_cost_per_unit
proposal_line_item_cost_per_unit_gross
proposal_line_item_local_cost_per_unit_gross
proposal_line_item_type_and_priority
proposal_line_item_size
proposal_line_item_archival_status
proposal_line_item_product_adjustment
proposal_line_item_buffer
proposal_line_item_target_rate_net
proposal_line_item_billing_source
proposal_line_item_billing_cap
proposal_line_item_billing_schedule
proposal_line_item_goal_percentage
proposal_line_item_cost_adjustment
proposal_line_item_comments
proposal_line_item_reconciliation_status
proposal_line_item_last_reconciliation_date_time
proposal_line_item_flat_fee
product_package_item_archival_status
proposal_line_item_type
product_template_rate_type
product_template_status
product_template_type_and_priority
product_template_product_type
product_template_description
product_product_template_name
product_rate_type
product_status
product_type_and_priority
product_product_type
product_notes
product_inventory_sizes
product_rate
packaged_product_rate
proposal_agency_type
proposal_agency_credit_status
proposal_agency_external_id
proposal_agency_comment
salespeople_proposal_contribution
salesperson_proposal_contribution
product_package_notes
product_package_items
product_package_status
package_comments
package_start_date_time
package_end_date_time
October 2019
You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months (default)
- 24 months
- All time
August 2019
We have upgraded our Google Ad Manager connector from version 201811 to 201908 of the Ad Manager API and handled deprecation and updates. Read more about the deprecations and changes in Google's Ad Manager API documentation.
New dimensions:
programmatic_channel_id
programmatic_channel
dp_deal_id
dp_app_id
video_break_type
video_break_type_name
video_ad_request_duration_id
video_ad_request_duration
classified_advertiser_id
classified_advertiser_name
classified_brand_id
classified_brand_name
ad_exchange_optimization_type
Deprecated dimensions:
buyer_id
buyer_name
content_hierarchy
New columns:
dp_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
Deprecated columns:
ad_server_inventory_level_percent_impressions
ad_server_inventory_level_percent_clicks
ad_server_inventory_level_without_cpd_percent_revenue
dynamic_allocation_inventory_level_impressions
dynamic_allocation_inventory_level_clicks
dynamic_allocation_inventory_level_ctr
dynamic_allocation_inventory_level_revenue
dynamic_allocation_inventory_level_average_ecpm
dynamic_allocation_inventory_level_percent_impressions
dynamic_allocation_inventory_level_percent_clicks
dynamic_allocation_inventory_level_without_cpd_percent_revenue
total_inventory_level_impressions
total_inventory_level_clicks
total_inventory_level_ctr
total_inventory_level_cpm_and_cpc_revenue
total_inventory_level_without_cpd_average_ecpm
January 2019
Since acquiring DoubleClick, Google has re-branded all DoubleClick sources. We have renamed the DoubleClick connectors as follows:
- DoubleClick Campaign Manager to Campaign Manager
- DoubleClick for Publishers to Google Ad Manager
- AdWords to Google Ads
This name change applies to the Fivetran dashboard and our documentation.
December 2018
We have upgraded the connector to the DoubleClick API version 201811.
May 2018
We have reduced the data window dynamically by one day in case of report failure.