Open navigation

Google Ad Manager field deprecations and updates - February 14, 2023

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
Will be added as new field

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
Will be added as new field

Ad Exchange pricing rule

Yes -  UNIFIED_PRICING_RULE_NAME and FIRST_LOOK_PRICING_RULE_NAME
Will be added as new field

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
Will be added as new field

Ad Exchange product

Yes - use existing field: Ad Exchange product

Ad Exchange site

Yes -  SITE_NAME
Will be added as new field

Ad Exchange request sources

Yes -  DYNAMIC_ALLOCATION_NAME
Will be added as new field

Ad Exchange advertiser

Yes - use existing field: Classified advertiser name

Ad Exchange agency

Yes -  BUYING_AGENCY_NAME
Will be added as new field

Ad Exchange branding type

Yes -  BRANDING_TYPE_NAME
Will be added as new field

Ad Exchange buyer network

Yes -  BUYER_NETWORK_NAME
Will be added as new field

Ad Exchange deal ID

Yes -  PROGRAMMATIC_DEAL_ID
Will be added as new field

Ad Exchange deal

Yes -  PROGRAMMATIC_DEAL_NAME
Will be added as new field

Ad Exchange deal type

Yes - use existing field: Programmatic channel

Ad Exchange DSP buyer network

Yes -  BIDDER_NAME
Will be added as new field

Ad Exchange expansion type

No replacement. Remove from queries

Ad Exchange country code)

Yes -  COUNTRY_CODE
Will be added as new field

Ad Exchange country

Yes - use existing field: Country

Ad Exchange inventory ownership

Yes -  INVENTORY_OWNERSHIP_NAME
Will be added as new field

Ad Exchange landing page domain

Yes -  ADVERTISER_DOMAIN_NAME
Will be added as new field

Ad Exchange mobile carrier 

Yes -  CARRIER_NAME and CARRIER_ID
Will be added as new field

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
Will be added as new field

Ad Exchange network partner

Yes -  NETWORK_PARTNER_NAME and NETWORK_PARTNER_ID
Will be added as new field

Ad Exchange tag code

No replacement. Remove from queries

Ad Exchange targeting type

Yes -  TARGETING_TYPE_NAME and TARGETING_TYPE_CODE
Will be added as new field

Ad Exchange URL channel 

No replacement. Remove from queries

Ad Exchange user bandwidth 

Yes -  BANDWIDTH_NAME
Will be added as new field

Ad Exchange video ad duration 

Yes -  VIDEO_AD_DURATION
Will be added as new field

Ad Exchange video ad format

Yes -  VIDEO_AD_TYPE_NAME and VIDEO_AD_TYPE_ID
Will be added as new field

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

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.