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 |
Ad Exchange product | Yes - use existing field: Ad Exchange product |
Ad Exchange site | Yes - Site |
Ad Exchange request sources | Yes - Dynamic allocation ID |
Ad Exchange advertiser | Yes - use existing field: Classified advertiser name |
Ad Exchange agency | Yes - Buying agency |
Ad Exchange branding type | Yes - Branding type |
Ad Exchange buyer network | Yes - Buyer network |
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 |
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 |
Ad Exchange landing page domain | Yes - Advertiser domain |
Ad Exchange mobile carrier | Yes - Carrier 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 and Operating system 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 and Targeting type code |
Ad Exchange URL channel | No replacement. Remove from queries |
Ad Exchange user bandwidth | Yes - Bandwidth |
Ad Exchange video ad duration | Yes - Video ad duration |
Ad Exchange video ad format | Yes - Video ad type 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