On February 14, 2023 we will be making updates to fields in the Google Ad Manager data source. This is due to changes needed in the API upgrade to v202205.
The updates include field deprecations, field value changes, and updates to the timezone behavior which are all described in detail below.
Field deprecations
The following table contains all fields that will be deprecated, as well as a list of actions to take for each. Some have replacements that you can use now, some will have new fields added as part of the update, and some are being retired completely and should be removed.
If the deprecated fields are not removed or replaced in your reporting, they will return empty values.
Deprecated field name | Replacement/Action required |
|---|---|
AD_EXCHANGE_CLICKS (not customer facing - used in calculations) | Yes - ADXClicks Will use this in calculations as needed. No customer action needed |
Coverage | Yes - AD_EXCHANGE_MATCH_RATE |
Ad Exchange estimated % of impressions | Yes - use existing field: Ad Exchange active view % measurable impressions |
Ad Exchange % of viewable impressions of all measurable impressions | Yes - use existing field: Ad Exchange active view % viewable impressions |
AdExchange average time in seconds for an ad impression | Yes - use existing field: AdExchange active view avg (sec) |
Ad Exchange total number of impressions | Yes - use existing field: Ad Exchange active view eligible impressions |
Ad Exchange eligible impressions | Yes - use existing field: Ad Exchange active view measurable impressions |
Ad Exchange total number of active view measurable impressions | Yes - use existing field: Ad Exchange active view viewable impressions |
Deals ad requests | No replacement. Remove from queries |
Ad Exchange ad size type | No replacement. Remove from queries |
Ad Exchange platform type | No replacement. Remove from queries |
Ad Exchange pricing rule ID | Yes - UNIFIED_PRICING_RULE_ID and FIRST_LOOK_PRICING_RULE_ID |
Ad Exchange pricing rule | Yes - UNIFIED_PRICING_RULE_NAME and FIRST_LOOK_PRICING_RULE_NAME |
Ad Exchange tag | No replacement. Remove from queries |
Ad Exchange URL channel | No replacement. Remove from queries |
Ad Exchange ad client ID | No replacement. Remove from queries |
Ad Exchange creative sizes | Yes - use existing field: Creative size |
Ad Exchange ad format name | No replacement. Remove from queries |
Ad Exchange channel | Yes - CHANNEL_NAME |
Ad Exchange product | Yes - use existing field: Ad Exchange product |
Ad Exchange site | Yes - SITE_NAME |
Ad Exchange request sources | Yes - DYNAMIC_ALLOCATION_NAME |
Ad Exchange advertiser | Yes - use existing field: Classified advertiser name |
Ad Exchange agency | Yes - BUYING_AGENCY_NAME |
Ad Exchange branding type | Yes - BRANDING_TYPE_NAME |
Ad Exchange buyer network | Yes - BUYER_NETWORK_NAME |
Ad Exchange deal ID | Yes - PROGRAMMATIC_DEAL_ID |
Ad Exchange deal | Yes - PROGRAMMATIC_DEAL_NAME |
Ad Exchange deal type | Yes - use existing field: Programmatic channel |
Ad Exchange DSP buyer network | Yes - BIDDER_NAME |
Ad Exchange expansion type | No replacement. Remove from queries |
Ad Exchange country code) | Yes - COUNTRY_CODE |
Ad Exchange country | Yes - use existing field: Country |
Ad Exchange inventory ownership | Yes - INVENTORY_OWNERSHIP_NAME |
Ad Exchange landing page domain | Yes - ADVERTISER_DOMAIN_NAME |
Ad Exchange mobile carrier | Yes - CARRIER_NAME and CARRIER_ID |
Ad Exchange mobile device | Yes - use existing field: Mobile device |
Ad Exchange mobile inventory type | Yes - use existing field: Mobile inventory type |
Ad Exchange OS | Yes - OPERATING_SYSTEM_VERSION_NAME and OPERATING_SYSTEM_VERSION_ID |
Ad Exchange network partner | Yes - NETWORK_PARTNER_NAME and NETWORK_PARTNER_ID |
Ad Exchange tag code | No replacement. Remove from queries |
Ad Exchange targeting type | Yes - TARGETING_TYPE_NAME and TARGETING_TYPE_CODE |
Ad Exchange URL channel | No replacement. Remove from queries |
Ad Exchange user bandwidth | Yes - BANDWIDTH_NAME |
Ad Exchange video ad duration | Yes - VIDEO_AD_DURATION |
Ad Exchange video ad format | Yes - VIDEO_AD_TYPE_NAME and VIDEO_AD_TYPE_ID |
Ad Exchange transaction type | Yes - use existing field: Programmatic channel |
Time zone changes
The Ad Exchange Historical report supported both publisher time zone and Pacific Standard Time. As Google is removing the Ad Exchange Historical report in v202205, any data that was using that report will instead use the Historical report, which supports only the publisher time zone.
This change in time zone behavior may affect the data. However, it should still align with the UI reporting after the updates.
Field value changes
Some values returned by specific fields may change in this version update. Those affected are listed below:
Ad exchange deal/ new PROGRAMMATIC_DEAL_NAME field - the value “Open auction" will return as "(Not applicable)"
Ad Exchange DSP buyer network/new BIDDER_NAME field - the value “(No DSP)” will return as “Google Ads”. The value “Google: DCLK Bid Manager” will return as “DV360”
Creative size - the value “Native” will instead return the actual sizes of the creative used