Google Ad Manager Updates

Updates on the Google Ad Manager data source, including new metrics, dimensions, and other features.

May 2023

2023-05-16

New fields added:

• Ad Exchange ad request CTR
• Ad Exchange ad request eCPM
• Ad Exchange ad requests
• Ad Exchange CPC
• Ad Exchange lift
• Ad Exchange matched request eCPM
• Ad Exchange product code
• Ad location
• Ad location ID
• Ad server begin to render impressions
• Ad server unfiltered begin to render impressions
• Ad type
• Ad type ID
• Advertiser vertical
• Bid average CPM
• Bid count
• Branding type code
• Child partner name
• Deal bid rate
• Deal bids
• Deals bid requests
• Deals win rate
• Deals winning bids
• Drop-off rate
• Exchange bidding deal id
• Exchange bidding deal type
• Fill rate
• Google-sold auction impressions
• Google-sold impressions
• Google-sold reservation impressions
• Inventory ownership code
• Mediation chains served
• Mediation fill rate
• Mediation passbacks
• Mediation third-party eCPM
• Partner-sold ad requests
• Partner-sold code served count
• Partner-sold impressions
• Programmatic eligible ad requests
• Programmatic match rate
• Programmatic responses served
• Total ad requests
• Total ad requests
• Total creative serves
• Total error count
• Total impressions
• Total responses served
• Total unmatched ad requests
• TrueView skip rate
• TrueView views
• TrueView VTR
• URL
• URL ID
• Web property code
• 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 successful responses

February 2023

2023-02-14

Due to changes needed in the API upgrade to v202205, many fields have been deprecated and replaced with new ones. Learn more about the actions you need to take.

New fields added:

• Advertiser domain
• Bandwidth
• Bidder
• Branding type
• Buyer network
• Buying agency
• Carrier
• Carrier ID
• Channel
• Country code
• Dynamic allocation
• Dynamic allocation ID
• First look pricing rule
• First look pricing rule ID
• Inventory ownership
• Network partner ID
• Network partner name
• Operating system
• Operating system ID
• Programmatic deal ID
• Programmatic deal name
• Site
• Targeting type
• Targeting type code
• Unified pricing rule
• Unified pricing rule ID
• Video ad duration
• Video ad type
• Video ad type ID

Deprecated fields:

• Ad Exchange % of viewable impressions of all measurable impressions
• Ad Exchange ad client ID
• Ad Exchange ad format name
• Ad Exchange ad size type
• Ad Exchange advertiser
• Ad Exchange agency
• Ad Exchange branding type
• Ad Exchange buyer network
• Ad Exchange channel
• Ad Exchange country
• Ad Exchange country code
• Ad Exchange creative sizes
• Ad Exchange deal
• Ad Exchange deal ID
• Ad Exchange deal type
• Ad Exchange DSP buyer network
• Ad Exchange eligible impressions
• Ad Exchange estimated % of impressions
• Ad Exchange expansion type
• Ad Exchange inventory ownership
• Ad Exchange landing page domain
• Ad Exchange mobile carrier
• Ad Exchange mobile device
• Ad Exchange mobile inventory type
• Ad Exchange network partner
• Ad Exchange OS
• Ad Exchange platform type
• Ad Exchange pricing rule
• Ad Exchange pricing rule ID
• Ad Exchange product
• Ad Exchange request sources
• Ad Exchange site
• Ad Exchange tag
• Ad Exchange tag code
• Ad Exchange targeting type
• Ad Exchange total number of active view measurable impressions
• Ad Exchange total number of impressions
• Ad Exchange transaction type
• Ad Exchange URL channel
• Ad Exchange URL channel
• Ad Exchange user bandwidth
• Ad Exchange video ad duration
• Ad Exchange video ad format
• AdExchange average time in seconds for an ad impression
• Coverage
• Deals ad requests

November 2022

2022-11-10

New dimensions added:

• Serving restriction ID

• Serving restriction name

August 2022

2022-08-09

New fields added:

• Creative image URL

• Creative image (renders in platforms that support it)

March 2022

2022-03-03

The field "Total conversion revenue" has had its data type change. It was an integer showing micros and now is currency type field.

January 2022

2022-01-19

Upgraded the data source to API version v202105.

October 2021

2021-10-13

Upgraded the data source to API version v202102.

June 2021

2021-06-23

Upgraded the data source to API version v202011.

April 2021

2021-04-15:

Upgraded the connector to API version v202008.

Jan. 2021

2021-01-27 -

The following name changes have taken affect:

Old display name	New display name	Old backend name	New backend name
CTR (%)	--	CTR	CTR_perc
Ad server CTR	Ad server CTR (%)	adServerCTR	adServerCTR_perc

2021-01-28:

Upgraded the connector to API version v202005.

Oct. 2020

2020-10-29:

Upgraded the connector to API version v202002.

The following fields were marked as deprecated and will stop returning data as of Nov. 27th (BigQuery only):

• 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

July 2020

2020-07-22 -

The following fields were deprecated, please remove them from your reporting:

• All salespeople ID
• All salespeople
• Average revenue per visitor
• Forecasted volume of the ProposalLineItem
• Rate card ID
• Rate card
• Unified volume of the ProposalLineItem
• Unreconciled volume of the ProposalLineItem

2020-07-29 -

The connector has been updated to API version v201911.

The following fields were deprecated, please remove or update to use the replacement fields:

• Unique visitors (use 'Total unique visitors' instead)
• Average impressions per visitor (use 'Average impressions per unique visitor' instead)

The following fields were added:

• Total unique visitors
• Average impressions per unique visitor
• Total reach impressions
• Total Active View eligible impressions
• Total Active View measurable impressions
• Total Active View viewable impressions
• Total Active View % measurable impressions
• Total Active View % viewable impressions

June 2020

2020-06-24 -

The following fields have been deprecated as the API version we are using no longer supports them:

• Ad requests
• Ad request CTR

April 2020

2020-04-28 -

Added support for custom "key-values". Note that inventory key-values must be setup as "dimensions" inside Google Ad Manager inventory interface to be available as a custom dimensions for the connector.

Added new fields:

• Total ad requests
• Total responses served
• Total unmatched ad requests
• Total fill rate
• Ad server responses served
• AdSense responses served
• Ad Exchange responses served
• 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

March 2020

2020-03-17:

The connector has been updated to use Google Ad Manager API v 201908.

Jan. 2020

2020-01-24:

The connector has been updated to use Google Ad Manager API v 201905.

Nov. 2019

2019-11-28:

The connector has been updated to use Google Ad Manager API v 201902.

The following fields have been added:

• Ad connector country criteria ID
• Ad connector country
• Ad connector inventory type
• Ad connector creative size
• Ad connector brand
• Ad connector advertiser
• Ad connector device
• Ad connector device category
• Ad connector tag ID
• Ad connector deal ID
• Ad connector app ID
• Ad connector impressions
• Ad connector clicks
• Ad connector CTR
• Ad connector queries
• Ad connector matched queries
• Ad connector cost
• Programmatic channel ID
• Programmatic channel

The following fields have been deprecated due to the API version upgrade - please remove or replace them with their AdSense counterparts:

• Dynamic allocation clicks
• Dynamic allocation clicks %
• Dynamic allocation CTR
• Dynamic allocation eCPM
• Dynamic allocation impressions
• Dynamic allocation impressions %
• Dynamic allocation revenue
• Total dynamic allocation revenue %
• Total dynamic allocation revenue % (without CPD)
• Buyer ID
• Buyer

July 2019

2019-07-09:

The Google Ad Manager connector has been updated to use API version v201811. 

May 2019

2019-05-28:

The Google Ad Manager connector has been updated to use API version v201808. 

April 2019

2019-04-16:

The following dimensions are marked as deprecated as they will be no longer available in v201808 API will we upgrade to. They will be removed on 2019-05-27:

• Ad request size (deprecated)
• Verified advertiser ID (deprecated)
• Verified advertiser (deprecated)

"Cost per unit" has been renamed to "Rate" to match the UI.

Mar. 2019

2019-03-20 - New dimensions added:

• Rate card
• Rate card ID

2019-03-21 - New dimensions added:

• Ad Exchange deal ID
• Ad Exchange deal
• Ad Exchange deal type
• Ad Exchange pricing rule ID
• Ad Exchange pricing rule
• Ad Exchange transaction type

2019-03-25 - New metrics and dimensions added:

• Unique visitors
• Average revenue per visitor
• Average impressions per visitor
• Video metadata key ID
• Video metadata key name
• Video vast version
• Video redirect third party

Feb. 2019

2019-02-27:

The Google Ad Manager connector has been updated to use API version 201805. 

Jan. 2019

2019-01-03:

The proper "Total Impressions" field was not exposed before. To fix this, the original "Impressions" field has been renamed to "Total impressions (deprecated)". There is now a new "Total Impressions" field that has the correct information.

2019-01-22:

The following fields have been marked as "deprecated" and will no longer return values. They will be removed Feb 26th, 2019, so please update your queries.

• Mediation Impressions (deprecated)
• Mediation Estimated Revenue (deprecated)
• Mediation eCPM (deprecated)
• Mediation group ID (deprecated)
• Mediation group (deprecated)
• Mediation network (deprecated)
• Mediation network tag (deprecated)

"TOTAL_INVENTORY_LEVEL"-* metrics were marked as deprecated in the API and replaced with "TOTAL_LINE_ITEM_LEVEL"-* metrics instead. We kept the old names and aliased them to instead reference the "TOTAL_LINE_ITEM_LEVEL"-* versions so that existing queries do not break.

Nov. 2018

2018-11-20:

The Google Ad Manager connector has been updated to use API version 201802.

The following fields have been added:

• Demand channel ID
• Demand channel
• Request type
• Yield group ID
• Yield group
• Yield partner
• Yield partner tag

The following fields have been marked as deprecated. They will be removed in January 2019. Please switch to using the new "Yield" fields added to replace these:

• Mediation group ID (deprecated)
• Mediation group (deprecated)
• Mediation network (deprecated)
• Mediation network tag (deprecated)

Oct. 2018

New dimension has been added to Google Ad Manager - 2018-10-11:

• Programmatic order

May 2018

2018-05-22:

The Google Ad Manager connector was updated to use API versions v201711/v201802.

Partner Management metrics were also added in this update to Google Ad Manager:

• Host impressions
• Host clicks
• Host CTR
• Unfilled impressions
• Partner impressions
• Partner clicks
• Partner CTR
• Gross revenue
• Host impressions (partner finance)
• Host revenue (partner finance)
• Host eCPM (partner finance)
• Revenue (partner finance)
• eCPM (partner finance)
• Gross revenue (partner finance)

April 2018

New dimension added for Google Ad Manager - 2018-04-26:

• Ad Exchange advertiser