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.
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
2018-10-11
New dimension has been added to Google Ad Manager:
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
2018-04-26
New dimension added for Google Ad Manager:
Ad Exchange advertiser