Release Notes

This page provides information about the changes in each release of Ads Data Hub.

March 11, 2020

Effective April 21, 2020, due to an upstream change, vendors will no longer be able to access RDID data, or the following tables, which include advertiser conversions:

  • adh.google_ads_conversions
  • adh.dv360_youtube_conversions
  • adh.yt_reserve_conversions

These tables have been replaced with the following tables in the vendor schema, which include creative conversions such as pausing or skipping interactions:

  • adh.google_ads_creative_conversions
  • adh.dv360_youtube_creative_conversions
  • adh.yt_reserve_creative_conversions

February 13, 2020

You can now use inventory_type in the following tables to determine where your ad served:

  • adh.google_ads_impressions
  • adh.dv360_youtube_impressions
  • adh.yt_reserve_impressions
  • adh.partner_sold_cross_sell_impressions
  • adh.freewheel_impressions

February 6, 2020

Templated queries

Templated queries are now available in the UI, providing an easier query workflow. These templates are extensible, or ready to be run without modification on your data. Find instructions on how to use them here, or try running a query in the UI.

Partner sold campaign metadata

Ads Data Hub added 3 new tables, allowing vendors to query campaign metadata:

  • adh.partner_sold_cross_sell_creative
  • adh.partner_sold_cross_sell_lineitem
  • adh.partner_sold_cross_sell_order

These tables allow partners to query Partner Sold cross sell campaign metadata.

January 21, 2020

Ads Data Hub now supports VAST creatives (third_party_url and ad_id) for Instant Reserve campaigns in Google Ads and Display and Video 360, which are available to a subset of customers. If you or your customers wants to run VAST creatives on Instant Reserve campaigns, reach out to your YouTube Account Manager.

January 7, 2019

On June 1, 2020, Ads Data Hub will stop populating Google Ads tables with Display and Video 360 data. All adh.google_ads_* tables have corresponding adh.dv360_youtube_* tables, where your data has been populating since November. Rewrite your queries to use the new adh.google_ads_* tables and the Display and Video 360 ID space.

We've added is_dv360 to the adh.google_ads_campaign table. This field allows you to identify Display and Video 360 campaigns running in Google Ads.

We've also added reservation_type to the adh.google_ads_campaign and adh.dv360_youtube_lineitem tables. This field allows you to differentiate between programmatic, instant reserve, and auction campaigns.

December 11, 2019

You can now use change history to view a history of changes to your account.

December 4, 2019

We've added 2 new tables: cm_dt_paths and dv360_paths. These tables make event path analysis easier and more computationally efficient. Learn more

November 4, 2019

Report on DV360 TrueView campaigns in Ads Data Hub

We've added 9 tables, allowing you to report on Display and Video 360 YouTube campaigns (including Google Video Partners) in Ads Data Hub. The tables are:

  • dv360_youtube_adgroup
  • dv360_youtube_advertiser
  • dv360_youtube_campaign
  • dv360_youtube_clicks
  • dv360_youtube_creative
  • dv360_youtube_conversions
  • dv360_youtube_impressions
  • dv360_youtube_insertion_order
  • dv360_youtube_lineitem

October 24, 2019

We've added impression data fields to the adh.*_clicks, adh.*_conversions, and adh.*_active_views tables, simplifying the querying process for impression data. To see an example query using the new fields, look at the samples page.

October 14, 2019

We've added 2 new customer types to the table format documentation: agencies and holding companies. Additionally, we've updated the advertiser and vendor documentation to include additional fields and tables.

September 23, 2019

Query job IDs are now generated differently. For queries where no job ID is specified, Ads Data Hub generates one using 32 random hexadecimal characters. This change doesn't impact users who specify a job ID using ADHv1.

May 21, 2019

Ads Data Hub's new API, Ads Data Hub v1, is now generally available. Learn how to migrate to the new API.

April 17, 2019

You can now test queries and look at synthetic event-level data using the new sandbox role. Learn more.

March 18, 2019

You can now assign users different levels of access to your Ads Data Hub account based on their role in your agency. See Assign access by role for details.

December 6, 2018

You can now query Campaign Manager audience segments data using a new match table and field. See table format for an updated list of fields.

November 26, 2018

Fields deprecated in Google Ads and YouTube reserve tables

The following fields are now deprecated:

  • in adh.google_ads_impressions: activeview_cost, click_cost, conv_cost, cost_usd, device_id_md5, impression_cost, is_gfp, is_mobile_id, line_item_id, output_language, target_type, user_bandwidth
  • in adh.yt_reserve_impressions: campaign_id, device_id_md5, is_gfp, is_mobile_id, output_language, target_type, user_bandwidth
  • in adh.google_ads_active_views: is_gfp
  • in adh.yt_reserve_ads_active_views: is_gfp

Additionally, both adh.google_ads_views and adh.yt_reserve_views are now deprecated.

See table format for suggested workarounds

November 7, 2018

Fields deprecated in city, metro, and region tables

The following fields are now deprecated:

  • in adh.city: latitude, longitude, metro_code, region_code
  • in adh.metro: metro_code, metro_abbrev
  • in adh.region: region_code

See table format for suggested workarounds.

August 24, 2018

AdWords tables were renamed to reflect the new Google Ads name. See table format for an updated list of new table names, and use the new names in the Ads Data Hub interface when writing queries.

August 21, 2018

New dv360_dt metadata tables

You can now query Display & Video 360 Data Transfer metadata in Ads Data Hub. Many other Data Transfer fields and tables were also renamed. See table format for an updated list of fields, and use the new names in the Ads Data Hub interface when writing queries.

August 17, 2018

DV360 / DBM cost and fee fields removed

The following field types will be removed soon, and should no longer be used in queries: event.xbid_total_media_cost, event.xbid_cpm_fee, event.xbid_media_fee, and event.xbid_data_cost. All individual fields (fee 1 through 5, currency options, etc.) related to these types will be removed.

August 3, 2018

New temporary tables

You can now create temporary tables in your queries using the CREATE TABLE statement. You must still specify an output table to run queries with the sole purpose of generating a temporary table. Temporary tables are active for 72 hours before they need to be refreshed. See sample queries, and example below:

CREATE TABLE temp_table AS ( /* query to output to the temporary table */ )

May 2, 2018

New dcm_dt metadata tables

You can now query DCM Data Transfer metadata in Ads Data Hub. See table format and sample queries for more information.

April 12, 2018

New _rdid tables

You can now query mobile device IDs in the _rdid tables. Add _rdid to the end of any adh. table to query device_id_md5 instead of user_id. Use the is_in_rdid_project field to deduplicate events contained in standard and _rdid tables. See table format, sample queries, and join your data for more information.

New account linking workflow

You can now link AdWords, Bid Manager, and Campaign manager accounts with Ads Data Hub through their respective interfaces. You will need to know your Ads Data Hub account ID. Contact support if you have trouble finding it. Learn more

May 1, 2017

New

There is an updated custom query user interface for Ads Data Hub.