This page provides information about the changes in each release of Ads Data Hub for Marketers. ## November 4, 2026 **Update to description of methodology** We have updated the [Description of methodology](https://developers.google.com/ads-data-hub/marketers/resources/description-of-methodology) page with the following changes: - Updated the general information section to note that Ads Data Hub is accessed through both the UI and API. - Removed "YouTube Reserve" from the Out-of-scope buying flows row in the Google Ads and Display \& Video 360 YouTube Traffic table. - Renamed the "Mobile identifiers" section to "Device identifiers" and removed outdated iOS 14.5 and third-party cookie timeline notes. ## October 16, 2026 **Connections source permissions and migration** Existing connections in the **Connections** tab are moving to an updated Connections experience that uses the service account shown under **Settings \> Details \> Service account** (usually `service-@gcp-sa-adsdatahub.iam.gserviceaccount.com`) to read sources and write destinations. Before your connections are moved, grant that service account the required [source and destination roles](https://developers.google.com/ads-data-hub/marketers/guides/user-provided-data-matching#source_permissions_and_connection_requirements) and convert connections that use unsupported data sources, wildcard Cloud Storage paths, or unsupported field types. See [Migrate existing connections](https://developers.google.com/ads-data-hub/marketers/guides/user-provided-data-matching#migrate_existing_connections) for details. ## August 10, 2026 **Data prefill for newly linked accounts** During the first 7 days following Ads Data Hub account creation, linked customer IDs (CIDs) automatically receive up to 21 days of historical data backfilled. This lets you begin executing queries without waiting for daily data to accumulate to meet privacy and aggregation thresholds. See [Account setup](https://developers.google.com/ads-data-hub/marketers/guides/account-setup#link_data). ## July 16, 2026 **Update to MRC-accredited queries** The environment classification in the `device_type` output column of MRC Accredited queries has been updated: the value previously reported as "OTT" has been renamed to "Connected TV". This change affects the categorization of records derived from the underlying `mobile_browser_class` field in Ads Data Hub impression tables (where `mobile_browser_class` corresponds to streaming or TV environments). ## July 8, 2026 **Google TV inventory and views** Ads Data Hub now supports Google TV inventory: - A new `GOOGLE_TV` value has been added to features and tables containing the `inventory_type` field. - Google TV ad events will have their `inventory_type` set to `GOOGLE_TV`. - The Google TV ad events with cross-product use consent will continue to be included in the `google_ads` and `dv360_youtube` views. - The following new query views (or tables) have been added to include the Google TV ad events without cross product use consent: - `google_ads_impressions_policy_isolated_google_tv` - `google_ads_creative_conversions_policy_isolated_google_tv` - `google_ads_active_views_policy_isolated_google_tv` - `dv360_video_impressions_policy_isolated_google_tv` - `dv360_video_creative_conversions_policy_isolated_google_tv` - `dv360_video_active_views_policy_isolated_google_tv` ## March 31, 2026 **Expansion of ad format measurement** Ads Data Hub for Marketers now supports ad format data. A new field, `ad_format_type`, has been added to impressions tables, which lets you query which YouTube ad formats were served in your campaigns---for example, In-stream, Shorts, and In-feed formats. ## February 20, 2026 **Create and update BigQuery tables in SQL scripts** Ads Data Hub now supports `CREATE` and `MERGE` statements on BigQuery tables directly in SQL scripts. See [Create and update BigQuery tables](https://developers.google.com/%0Aads-data-hub/marketers/guides/create-tables#create_and_update_bigquery_tables) for details. ## January 9, 2026 **Name multiple exported tables at report execution time** Now, when you create multiple tables in a single query, you can choose to set the table names in the SQL query (traditional behavior) or use a placeholder parameter for the table names (new option). When you use the table parameter and run your report, Ads Data Hub prompts you to enter BigQuery destinations for each table. This lets you set different destinations whenever you run a report, without having to edit the SQL query. [Learn more about exporting and naming multiple tables](https://developers.google.com/ads-data-hub/marketers/guides/create-tables#export_multiple_tables). ## October 30, 2025 **Update to description of methodology** We have updated the [Description of methodology](https://developers.google.com/ads-data-hub/marketers/resources/description-of-methodology) page with the following change: A new "Reporting method" column has been added to the metric table. ## July 18, 2025 **Update to description of methodology** We have updated the [Description of methodology](https://developers.google.com/ads-data-hub/marketers/resources/description-of-methodology) page with the following changes: - The Out-of-scope ad format section in the table was updated to remove "YouTube sold through YouTube Reserve." - Ten new metrics were added to the metric table. - A note about reservation traffic was added. ## July 14, 2025 **Update to Search Ads 360 and Display \& Video 360 fields and tables** In line with the updates to the Search Ads 360 and Display \& Video 360 fields and tables, you should update your queries that contains the following fields and make use of the new fields and tables: **Search Ads 360 fields** | Current | New | |---|---| | `segment_value_1` | - `sa360_adgroup_id` - `sa360_campaign_id` - `sa360_keyword_id` | **Search Ads 360 tables** | Current | New | |---|---| | `page_search_match_table` | - `paid_search_ad_group` - `paid_search_campaign` - `paid_search_keyword` | So for queries that make use of `segment_value_1` and `page_search_match_table` to extract the Search Ads 360 ad group ID, you should update your queries from this: SELECT segment_value_1 from page_search_match_table into this: SELECT sa360_adgroup_id from paid_search_ad_group **Display \& Video 360 fields** | Current | New | |---|---| | `dv360_browser_id` | `dv360_browser_reportable_id` | | `dv360_isp_id` | `dv360_isp_reportable_id` | | `dv360_mobile_make_id` | `dv360_mobile_make_reportable_id` | | `dv360_mobile_model_id` | `dv360_mobile_model_reportable_id` | | `dv360_operating_system_id` | `dv360_operating_system_reportable_id` | ## May 9, 2025 **Update to description of methodology** - Due to the revocation of the Media Rating Council (MRC), details pertaining to "YouTube Reserve" have been removed and are no longer within scope of service. ## April 22, 2025 **New feature: User-provided data matching using Private Cloud Match** User-provided data matching (UPDM) lets you bring in first-party data that you've collected about a user --- such as information from your websites, apps, or physical stores --- and join it in Ads Data Hub with that same user's signed-in activity from Google ad data, helping you generate rich customer insights while protecting user privacy. Private Cloud Match supports one data source: BigQuery. Private Cloud Match uses standard Ads Data Hub analysis queries to generate match tables rather than the Connections tab. Private Cloud Match does not require additional onboarding, and data never leaves the your VPC-SC perimeter. [Learn more about UPDM using Private Cloud Match](https://developers.google.com/ads-data-hub/marketers/guides/user-provided-data-matching?updm_source=pcm). ## March 27, 2025 **Update to description of methodology** We have updated the [Description of methodology](https://developers.google.com/ads-data-hub/marketers/resources/description-of-methodology) page with the following changes to the "What's included in the audit process?" section: - The Out-of-scope ad format section in the table now includes multi-format video ads such as video view campaigns (VVC) and video reach campaigns (VRC). - Two metrics were removed from the metric table, as they are not included in the MRC accreditation: "Unmeasurable impressions (net of general invalid traffic)" and "Viewable percentage (net of general invalid traffic)". ## March 26, 2025 CTV IFAs are now available in the Google Ads and Display \& Video 360 YouTube impressions views (`google_ads_impressions_rdid` and `dv360_youtube_impressions_rdid`). Learn about [filtering for CTV traffic](https://developers.google.com/ads-data-hub/guides/rdid-matching#filter_for_ctv_traffic). ## November 21, 2024 **Update to description of methodology** We have updated the [Description of methodology](https://developers.google.com/ads-data-hub/marketers/resources/description-of-methodology) page with the following changes: - In filtration methodology reporting, the level wherein discrepancies in spam reporting are captured at post-processing time has been corrected from "campaign level" to "event level". The numerical value for discrepancies in spam reporting has also been changed from "\<0.01%" to "\<1%". ## November 11, 2024 **New feature: Scheduler** With this update, you can schedule and run reports and user lists on a daily, weekly, or monthly basis. See [Run a report on a schedule](https://developers.google.com/ads-data-hub/marketers/guides/run-queries#schedule). **New design: Reports** Ads Data Hub for Marketers is launching an updated report experience in the UI. This update brings query details, job settings (including filtered row summary), privacy information, and the new scheduler together in one view, collectively referred to as a "report". This new design gives you a complete view of your report while making it easier to make changes with less moving around the UI. Check out the new tutorial [in the UI](https://adsdatahub.google.com/marketers), and see our updated [Guides documentation](https://developers.google.com/ads-data-hub/marketers/guides/run-queries), which reflects the new experience. ## October 30, 2024 **Updates to policy-isolated views** To adhere to recent regulatory compliance changes (see [Consent requirements for the EEA](https://developers.google.com/ads-data-hub/marketers/resources/consent-requirements "Consent requirements for the EEA")), Ads Data Hub has expanded its policy-isolated views to support more Google services. If you run queries on EEA user data from these Google services, you may need to update and rerun your queries to include the new views. The following list of updated Campaign Manager 360 views are also documented in the table schemas under [Reference](https://developers.google.com/ads-data-hub/marketers/reference/table-schemas): #### Updated Campaign Manager 360 policy-isolated views - cm_dt_active_view_plus_policy_isolated_android_tv - cm_dt_active_view_plus_policy_isolated_google_tv - cm_dt_active_view_plus_policy_isolated_other - cm_dt_activities_attributed_policy_isolated_maps - cm_dt_activities_attributed_policy_isolated_accomodations - cm_dt_activities_attributed_policy_isolated_gmail - cm_dt_activities_attributed_policy_isolated_playstore - cm_dt_activities_attributed_policy_isolated_shopping - cm_dt_activities_events_policy_isolated_maps - cm_dt_activities_events_policy_isolated_other - cm_dt_activities_events_policy_isolated_playstore - cm_dt_activities_events_policy_isolated_shopping - cm_dt_activities_events_policy_isolated_unconsented_floodlights - cm_dt_clicks_policy_isolated_accomodations - cm_dt_clicks_policy_isolated_assistant - cm_dt_clicks_policy_isolated_gmail - cm_dt_clicks_policy_isolated_maps - cm_dt_clicks_policy_isolated_other - cm_dt_clicks_policy_isolated_shopping - cm_dt_impressions_policy_isolated_android_tv - cm_dt_impressions_policy_isolated_google_tv - cm_dt_impressions_policy_isolated_other - cm_dt_rich_media_policy_isolated_android_tv - cm_dt_rich_media_policy_isolated_google_tv - cm_dt_rich_media_policy_isolated_other ## September 11, 2024 **Update to description of methodology** We have updated the [Description of methodology](https://developers.google.com/ads-data-hub/marketers/resources/description-of-methodology) page with the following changes: - Minor updates were made to the Introduction section to clarify the purpose of the document. - "OTT" has been corrected to "CTV" in the "Out-of-scope" column of the audit process table. - "YouTube: Views" has been updated to "TrueView: Views". ## July 19, 2024 **Update to description of methodology** Due to the anticipated deprecation of third-party cookies on Chrome ([see blog post](https://privacysandbox.com/news/update-on-the-plan-for-phase-out-of-third-party-cookies-on-chrome/)), Ads Data Hub is no longer seeking MRC accreditation for cookie matching. We have updated the [Description of methodology](https://developers.google.com/ads-data-hub/marketers/resources/description-of-methodology) page to remove cookie matching from the description of the accreditation audit process. ## May 10, 2024 **New feature: User-provided data matching** User-provided data matching (UPDM) lets you bring in first-party data that you've collected about a user---such as information from your websites, apps, or physical stores---and join it in Ads Data Hub with that same user's signed-in activity from Google ad data, helping you generate richer customer insights while protecting user privacy. UPDM already supports a number of data sources, such as Google Cloud Storage, Amazon S3, and sFTP. [Learn more about user-provided data matching](https://developers.google.com/ads-data-hub/marketers/guides/user-provided-data-matching). ## May 3, 2024 **Update to engaged audiences** Ads Data Hub for Marketers has expanded engaged audience lists to be eligible for activation in all Google owned and operated campaign types, such as Search, Shopping, and Performance Max. To learn more, see [Build and manage audiences](https://developers.google.com/ads-data-hub/marketers/guides/audience-activation). ## April 26, 2024 **Fixed: Templated query** On March 6, 2024, the Ads Data Hub for Marketers UI incorrectly showed two different MRC-accredited YouTube Reserve viewability report templates. One of the templates could potentially give you incorrect results if your ads were shown to users in the EEA. This bad query template was removed on April 26. ## April 1, 2024 **YouTube Masthead queries** To continue improving Ads Data Hub's performance, the legacy `is_masthead` field in the `dv360_youtube_creative` table is deprecated. To segment YouTube Masthead inventory moving forward, you will need to update your queries to use `adgroup_type IN ('VIDEO_MASTHEAD')` from the `dv360_youtube_adgroup` table. Note that this does not affect the `is_masthead` field in the `yt_reserve_creative` table. ## March 20, 2024 **Fixed** Fixed the column names in the query for the Google Ads MRC report template called "Video viewability by device type". If you ran the query between March 6, 2024 and March 20, 2024, your report may be missing some column names. ## March 18, 2024 **Fixed: Templated query issue** On March 6, 2024, a bug was introduced to the MRC-accredited Google Ads video viewability templated query ("Video viewability by device type") where the columns of the resulting report were given incorrect names. For example: `_f0`, `_f1`, and `_f2` were returned instead of `num_impressions`, `num_measurable_impressions`, and `num_viewable_impressions`. This was fixed on March 18, 2024. ## March 6, 2024 **Changed** The MRC templated queries have been updated to reference the new policy-isolated views instead of the legacy views. The queries are still functionally the same. ## January 16, 2024 **Consent requirements for the European Economic Area** As a part of Google's ongoing commitment to a privacy-centric digital advertising ecosystem, we are strengthening the enforcement of our [EU user consent policy](https://www.google.com/about/company/user-consent-policy/ "EU user consent policy"). By March 2024, all customers, irrespective of region, will need to attest that appropriate consent has been obtained pursuant to the [Ads Data Hub Policies](https://developers.google.com/ads-data-hub/marketers/resources/policies "Ads Data Hub Policies"), complying with the [EU user consent policy](https://www.google.com/about/company/user-consent-policy/ "EU user consent policy") where applicable, for any first-party data uploaded to Ads Data Hub. Beginning today, Ads Data Hub includes: - A new attestation to indicate that you have obtained consent for data uploaded into Ads Data Hub - New policy-isolated tables that split data out by Google services, and - Updated templates to help you write queries that comply with our [EU user consent policy](https://www.google.com/about/company/user-consent-policy/ "EU user consent policy") To learn more about these changes, and what actions you should take, see [Consent requirements for the European Economic Area](https://developers.google.com/ads-data-hub/marketers/resources/consent-requirements "Consent requirements for the EEA"). ## December 13, 2023 **New guided tutorials** Starting today, Ads Data Hub for Marketers includes a collection of step-by-step tutorials that teach you how to accomplish specific tasks. Tutorials are embedded in a companion panel in the web UI, visually guiding you through each task. This initial launch introduces two modules focused on onboarding tasks: **Adding Users** and **Linking Accounts**. Note that some tutorials require that you have a certain [user role](https://developers.google.com/%0Aads-data-hub/marketers/guides/assign-access-by-role) in order to perform the task. To see the modules that are available to you, click **help Help \> Start a tutorial**. ## November 14, 2023 Following the [September 2022 announcement](https://developers.google.com/ads-data-hub/marketers/resources/release-notes#september_22_2022), the `google_ads_clicks` and `dv360_youtube_clicks` tables will be deprecated on March 6, 2024. Update your queries before the deprecation to avoid interruptions in reporting. For queries that use the deprecated tables, adjust them to use the creative conversions tables as follows: - Replace `google_ads_clicks` with `google_ads_creative_conversions` - Replace `dv360_youtube_clicks` with `dv360_youtube_creative_conversions` There are no changes to the field names between the old and new tables. For queries that count the number of clicks from a deprecated clicks table, adjust the query to sum the clicks instead, for example: SELECT COUNT(*) from google_ads_clicks should become: SELECT SUM(num_clicks) from google_ads_creative_conversions ## November 13, 2023 Fixed a bug in the MRC-accredited video viewability queries where Google Video Platform (GVP) was being excluded. Note that if you ran the queries from May 3, 2023 - November 7, 2023, there is a risk that GVP was not returned in results. ## November 9, 2023 **Noise injection** Ads Data Hub for Marketers now includes an additional privacy mode option. Starting today, you can choose to run queries using difference checks or using noise injection. Noise injection mode protects user privacy while providing reasonably accurate results, eliminating the need for difference checks. [Learn more about using noise injection in Ads Data Hub](https://developers.google.com/ads-data-hub/marketers/guides/noise-injection). **Deprecation of paths tables** Due to global privacy regulations, the Campaign Manager 360 and Display \& Video 360 paths tables, `adh.cm_paths` and `adh.dv360_paths`, are being deprecated. You can continue to use the paths tables until February 28, 2024. Once the tables are decommissioned, you can use the **Linear attribution model (CM event table)** template for similar analyses. ## November 8, 2023 We've updated the parameters fields in the job start page to be more helpful. All parameter fields now have persistent messaging about formatting requirements under the input box, as well as date pickers to make selections easier. ## October 24, 2023 You can now create first-party audience lists using the UI. First-party lists allow you to create, maintain, and activate audiences using their consented first-party data only. This lets you write queries that segment and target specific audiences using solely your first-party data, expanding the capabilities of engaged audiences beyond remarketing. [Learn more about first party audiences](https://developers.google.com/ads-data-hub/marketers/guides/audience-activation). ## October 18, 2023 Due to the upstream [deprecation of frequency-based audiences in Display \& Video 360](https://support.google.com/displayvideo/answer/13439592), frequency capping audiences are no longer supported in Ads Data Hub. ## September 20, 2023 Ads Data Hub for Marketers now supports data-driven attribution (DDA) for Google Ads. DDA gives credit for conversions based on how people engage with your ads by assigning partial credit to each touchpoint. This launch introduces the support of DDA and the ability to compare it with last-click attribution. **Schema updates** The following fields have been added to the `google_ads_conversions` table: - `conversion_attribution_model_type` - `num_conversion_micros` - `model_comparison.data_driven_conversion_micros` - `model_comparison.last_click_conversion_micros` - `event_occurrence_time_usec` This launch also introduces the `google_ads_conversion_settings` metadata table to differentiate between conversions using the DDA and LCA models. For details, see the [table schemas](https://developers.google.com/ads-data-hub/marketers/reference/table-schemas/advertisers#google-ads-conversions-settings). **New report templates** To get started with DDA and to compare it with the LCA model, see the new conversion templates when you create a new report. **Query migration** To learn how to migrate your existing queries to use DDA or to maintain the previous behavior, see [Sample queries](https://developers.google.com/ads-data-hub/marketers/resources/sample-queries#work_with_attribution_models). ## September 6, 2023 Ads Data Hub has updated the sandbox dataset to improve its usability. These enhancements allow marketers to minimize the time spent on query troubleshooting and preserve their privacy budget by reducing the need to test queries on production data. The updates include: - Enhanced data representation to improve consistency and to more closely simulate realistic marketing data (for example, by removing negative values and adjusting conversion rate to eliminate zero row results) - Corrected common UI parsing errors - Updated error messaging for improved clarity to facilitate query troubleshooting - Automated date range setting in the UI when the user selects the sandbox dataset ## August 23, 2023 Ads Data Hub has added First Party audience lists to allow advertisers to create, maintain, and activate audiences using their consented 1P data only. This enables Google Ads and Display \& Video 360 advertisers to write queries that segment and target specific audiences using solely their 1P data, expanding the capabilities of Engaged Audiences beyond remarketing and frequency capping alone. This capability is currently available only using the API. [Learn more](https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.userLists). ## August 15, 2023 Ads Data Hub now supports BigQuery temporary table syntax. Previously, temporary tables in Ads Data Hub were approximated by creating persistent tables which would expire after 72 hours. Now, using the `CREATE TEMP TABLE` statement, you can create session-level tables that are not subject to privacy checks. To learn more about temporary and persistent tables in Ads Data Hub, see [Create tables](https://developers.google.com/ads-data-hub/marketers/guides/create-tables). ## July 20, 2023 Ads Data Hub for Marketers has made several changes to the landing page and navigation. ### Home A new **Home** page centralizes useful metrics and actions: - **Recent activity:** view stats on errors encountered, reports generated, and audiences populated - **Recent executions:** view details of reports that were recently run - **Recently viewed:** return to reports that you recently viewed - **Create a new...:** quickly initiate common tasks, such as creating a new report or audience ### Reports This release also renames **Queries** to **Reports**. Queries are now referred to as reports, though the terms may still be used interchangeably in some contexts. ### Jobs Information previously contained in the **Jobs** page has moved to **Recent executions** and **Reports**. ## July 18, 2023 Ads Data Hub has added the capability to query Connected TV (CTV) Identifiers for Advertising (IFA) within its resettable device identifier (RDID) tables. This feature allows marketers to analyze and gain insights related to user activity on connected TV platforms. [Learn more](https://developers.google.com/ads-data-hub/marketers/guides/rdid-matching). ## June 15, 2023 Ads Data Hub for Marketers now includes YouTube Shorts data in Google Ads and Display \& Video 360. These [schema](https://developers.google.com/ads-data-hub/marketers/reference/table-schemas/) changes have been made to support YouTube Shorts: - New values, `VIDEO_VIEW`, `VIDEO_REACH`, and `VIDEO_ACTION` added to - `dv360_adgroup.adgoup_type` - `google_ads_adgroup.adgroup_type` - New field, `youtube_page_type` (available only to marketers) added to - `google_ads_impressions` - `dv360_youtube_impressions` - `freewheel_impressions` - `partner_sold_cross_sell_impressions` - `yt_reserve_impressions` ## June 2, 2023 You can now preview the output table structure that would be generated by [using a report template](https://developers.google.com/ads-data-hub/marketers/guides/run-queries#create_a_query). A new **Sample Report** tab in the template card displays the columns as table headers. No data is shown---only column names are visible, so you can quickly understand what to expect from running a report from the template, saving you time and potentially reducing [privacy budget](https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.adsDataCustomers/getDataAccessBudget) usage. ## May 25, 2023 The current release fixes a bug in the MRC-accredited YouTube Reserve **Video viewability** report template, where events that occurred before July 6, 2022 were incorrectly excluded from the results. Note that if you query data prior to July 6, 2022 using the MRC-accredited YouTube Reserve Video viewability query template, there is the potential for out-of-scope and unaccredited traffic to be replicated in the results. ## May 22, 2023 Ads Data Hub for Marketers engaged audiences now allow you to use your first-party data and **YouTube** event-level data to decide which users and segments to reach. To learn about use cases and how to create engaged audiences see [Engaged audiences](https://developers.google.com/ads-data-hub/marketers/guides/audience-activation#engaged_audiences). ## May 3, 2023 Ads Data Hub made changes to the MRC-approved templated viewability queries available in the [UI](https://adsdatahub.google.com/marketers#). The MRC in-scope traffic are explicitly defined, following MRC reporting best practices. These changes future-proof the templates for new ad traffic enablement. Google Ads: Changed the filtering on an impression's `inventory_type` and `adgroup_type` from exclude (`!=`) to include (`IN`) style. Display \& Video 360: 1. Changed the filtering on an impression's `inventory_type` from exclude (`!=`) to include (`IN`) style. 2. Joined the ad events table with the ad group metadata table, and then perform relevant filtering on an impression's `adgroup_type`. YouTube Reserve: 1. Changed the filtering on an impression's `inventory_type` from exclude (`!=`) to include (`IN`) style. 2. Use the impression's `format_category` field to refine the scope on "VIDEO" format events. Note that if you query data prior to July 6, 2022 using the MRC-accredited YouTube Reserve Video viewability query template, there is the potential for out-of-scope and unaccredited traffic to be replicated in the results. ## May 2, 2023 As part of our effort to expand available Google inventory, Ads Data Hub for Marketers now supports Gmail ads. Beginning today, you can query campaigns that serve on Gmail inventory. - Gmail data will be available in Google Ads tables. [Link your Google Ads accounts](https://developers.google.com/ads-data-hub/marketers/guides/link-accounts#link_your_google_ads_account). - Use the `inventory_type` field to distinguish Gmail from ads serving on other inventory. Learn how to use this field with the new [sample query](https://developers.google.com/ads-data-hub/marketers/resources/sample-queries#inventory_type). - Gmail data is not available in [RDID tables](https://developers.google.com/ads-data-hub/marketers/guides/rdid-matching). ## April 18, 2023 You can now link YouTube Reservation bought through Google Ads. See [Link your Google Ads account](https://developers.google.com/ads-data-hub/guides/link-accounts#youtube_reservation). ## March 22, 2023 The template library has a new look. This page now allows you to search and filter templates by use case, data source, inventory type, and MRC accreditation. Learn about [creating reports](https://developers.google.com/ads-data-hub/marketers/guides/run-queries). ## March 14, 2023 Ads Data Hub supports [BigQuery Omni](https://cloud.google.com/bigquery/docs/connections-api-intro) functionality. To learn how to bring your Amazon S3 and Azure Blob Storage data into Ads Data Hub for Marketers, see [BigQuery external connections](https://developers.google.com/%0Aads-data-hub/marketers/guides/bq-connections). ## March 7, 2023 Ads Data Hub is adding a new field, `impression_id`, to Freewheel tables. This field had [previously been added](https://developers.google.com/ads-data-hub/marketers/resources/ads-data-hub/marketers/resources/release-notes#october_22_2020) to Google Ads, Display \& Video 360 YouTube, Partner Sold - Cross Sell, and YouTube Reserve event tables. This introduces a way to join clicks, conversions, and Active Views to impressions for Freewheel. `impression_id` is a join key that is unique to individual impressions. ## February 28, 2023 ### URL parameters As part of our ongoing commitment to protect user data and privacy, we have launched a new Personally Identifiable Information (PII) protection feature in Ads Data Hub for Marketers that applies to the `content_url` field. Over the next few weeks, we will deploy the change to full effect. After this launch, you may notice that URL parameters based on the `content_url` field that may contain PII are missing in outputted datasets. ### Attribution event type It's now easier to understand how many of your conversions were attributed to engaged views versus clicks. Ads Data Hub now surfaces Engaged View Conversions (EVCs) and Click-through Conversions (CTCs). To match what displays in front-end reporting, a new column, `attribution_event_type`, is now available in the Google Ads and Display \& Video 360 conversions tables. This new column can be used in [analysis queries](https://developers.google.com/ads-data-hub/marketers/guides/run-queries). In addition to launching the new column, beginning on March 1, 2023, new query templates will be available in the UI that allow you to drill down by approved segments. Learn about [EVCs](https://developers.google.com/ads-data-hub/marketers/resources/glossary#engaged_view_conversion_evc) and [CTCs](https://developers.google.com/ads-data-hub/marketers/resources/glossary#click_through_conversion_ctc). ## February 22, 2023 **Query advisor** is a new feature that surfaces actionable advice during query development, if your SQL is valid but might trigger undesirable results. To learn more, see [Query advisor](https://developers.google.com/ads-data-hub/marketers/guides/best-practices#query_advisor). ## February 3, 2023 The `active_view_data` field and its derived fields have been deprecated and replaced with a new format. Affected fields: - adh.google_ads_impressions.num_active_view_eligible_impression - adh.google_ads_impressions.num_active_view_measurable_impression - adh.google_ads_impressions.active_view_data - adh.dv360_youtube_impressions.num_active_view_eligible_impression - adh.dv360_youtube_impressions.num_active_view_measurable_impression - adh.dv360_youtube_impressions.active_view_data - adh.yt_reserve_impressions.num_active_view_eligible_impression - adh.yt_reserve_impressions.num_active_view_measurable_impression - adh.freewheel_impressions.num_active_view_eligible_impression - adh.freewheel_impressions.num_active_view_measurable_impression - adh.freewheel_impressions.active_view.active_view_data To map deprecated fields with their replacements, see [Migration schema](https://developers.google.com/%0Aads-data-hub/marketers/reference/viewability-metrics/schema#migration_schema). ## December 6, 2022 The `active_view_data` and its derived fields were deprecated and replaced with a new format on January 31, 2023. Affected fields: - adh.google_ads_impressions.num_active_view_eligible_impression - adh.google_ads_impressions.num_active_view_measurable_impression - adh.google_ads_impressions.active_view_data - adh.dv360_youtube_impressions.num_active_view_eligible_impression - adh.dv360_youtube_impressions.num_active_view_measurable_impression - adh.dv360_youtube_impressions.active_view_data - adh.yt_reserve_impressions.num_active_view_eligible_impression - adh.yt_reserve_impressions.num_active_view_measurable_impression - adh.freewheel_impressions.num_active_view_eligible_impression - adh.freewheel_impressions.num_active_view_measurable_impression - adh.freewheel_impressions.active_view.active_view_data To map deprecated fields with their replacements, see [Migration schema](https://developers.google.com/%0Aads-data-hub/marketers/reference/viewability-metrics/schema#migration_schema). ## November 3, 2022 Ads Data Hub now supports viewability metrics for any display-measured ads on YouTube that have Active View metrics, including Masthead CPM and in-feed videos. Learn more about [querying YouTube viewability metrics](https://developers.google.com/ads-data-hub/marketers/reference/viewability-metrics/overview).
## October 4, 2022 Ads Data Hub now enables a [filtered row summary](https://developers.google.com/ads-data-hub/marketers/guides/legacy-diff-checks#filtered_row_summary) by default for new analysis queries created using the UI. This update also introduces an automatic configuration mode to filtered row summaries. Queries saved prior to this change will retain their current enablement state, mode, and configuration. Filtered row summaries don't apply to audience queries, and remain disabled by default for new analysis queries created using the API. Learn about [automatic mode](https://developers.google.com/ads-data-hub/marketers/guides/legacy-diff-checks#automatic_mode) for filtered row summaries. ## September 27, 2022 Advanced viewability metrics [documentation](https://developers.google.com/ads-data-hub/marketers/reference/viewability-metrics/overview), previously located under Guides, is now located under Reference. ## September 22, 2022 Ads Data Hub is introducing schema changes to make querying your YouTube data easier and more consistent with YouTube reporting. Previously, YouTube click data was split between clicks and creative conversions tables. This update brings click data into the creative conversions tables. The following fields have been added to the `dv360_youtube_creative_conversions` and `google_ads_creative_conversions` tables: - `num_clicks` - `num_video_views` - `advertiser_cost_usd` - `advertiser_cost_local_micros` These new fields can be used to rewrite your queries to remove joins to the `dv360_youtube_clicks` and `google_ads_clicks` tables, which will be deprecated in a future update. ## August 10, 2022 A bug was fixed in the Invalid traffic API which caused TrueView views to be double counted for conversion-optimized campaigns in Display \& Video 360 and Google Ads. The issue persisted from approximately August 1, 2021 - July 30, 2022. Only 1.8% of MRC in-scope campaigns in Ads Data Hub were affected, and impact was limited to TrueView views retrieved via the Invalid traffic API. ## July 29, 2022 A new field, `is_trueview`, is now available to marketers. This field can be used to identify TrueView views, and is available in the following tables: - `google_ads_clicks` - `dv360_youtube_clicks` ## July 25, 2022 Regression modeling is now generally available. You can use [linear and logistic regression models](https://developers.google.com/ads-data-hub/marketers/guides/regression-modeling) to generate predictions using advertising data. ## July 18, 2022 As [announced on July 1, 2022](https://developers.google.com/ads-data-hub/marketers/resources/release-notes#july_1_2022), starting from today, Ads Data Hub will contain a more complete set of conversions for YouTube inventory bought in Google Ads and Display \& Video 360. This launch will bring more consistency between the conversion data of these products and Ads Data Hub reporting. The following tables are affected: - `dv360_youtube_conversions` - `google_ads_conversions` ## July 6, 2022 You can now use `format_category` in the following tables to determine the YouTube ad format: - `adh.google_ads_impressions` - `adh.dv360_youtube_impressions` - `adh.yt_reserve_impressions` - `adh.partner_sold_cross_sell_impressions` - `adh.freewheel_impressions` ## July 1, 2022 Beginning on July 18, 2022, Ads Data Hub will contain a more complete set of conversions for YouTube inventory bought in Google Ads and Display \& Video 360. This launch will bring more consistency between the conversion data of these products and Ads Data Hub reporting. The following tables will be affected: - `dv360_youtube_conversions` - `google_ads_conversions` ## June 24, 2022 The `is_in_rdid_project` field will be deprecated across tables on June 27, 2022. Update your queries to use `is_app_traffic` instead. ## May 18, 2022 A correctness fix was applied to columns `Invalid_Eligible_Impressions` and `Invalid_Measurable_Impressions` in the [`generateIvtReport`](https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers/generateIvtReport) method. These columns were incorrect from January 10, 2022 - May 18, 2022. This affected \<1% of Ads Data Hub customers. ## March 21, 2022 Campaign Manager 360 dynamic data is now available in Ads Data Hub. You can use the following 10 fields (available in the `clicks` and `impressions` tables) to analyze dynamic creative campaigns: - `event.dynamic_profile` - `event.dynamic_profile_id` - `event.feed` - `event.feed_reporting_label` - `event.feed_reporting_dimension1` - `event.feed_reporting_dimension2` - `event.feed_reporting_dimension3` - `event.feed_reporting_dimension4` - `event.feed_reporting_dimension5` - `event.feed_reporting_dimension6` If you aren't familiar working with arrays, read documentation on using [UNNEST](https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#unnest_operator) and [SAFE_ORDINAL](https://cloud.google.com/spanner/docs/array_functions#offset_and_ordinal). Additionally, review [samples](https://developers.google.com/ads-data-hub/marketers/samples/writing-queries#dynamic_data_in_campaign_manager_360_data_transfer) for examples of how to use these fields. ## February 16, 2022 Beginning in February 2022, Ads Data Hub will restrict the number of times that a user can query the same data for a given table. If you haven't yet been contacted by a Google representative regarding this change, it's because you aren't impacted. [Learn how to refactor your queries to avoid encountering this privacy check](https://developers.google.com/ads-data-hub/marketers/guides/best-practices#dont_query_the_same_data_more_than_strictly_necessary). ## January 10, 2022 You can now use the `metricType` parameter in `generateIvtReport` requests to designate the platform you want to measure and report on. To learn about the parameters that `metricType` supports, read the [reference documentation](https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers/generateIvtReport#metrictype). ## December 14, 2021 Regression modeling is now in open beta. You can use linear and logistic regression models to generate predictions using advertising data. To sign up, contact your Google representative. To learn more, read the [regression modeling documentation](https://developers.google.com/ads-data-hub/marketers/guides/regression-modeling). ## December 6, 2021 Ads Data Hub is making changes to how empty input tables are handled. Previously, jobs reading from an empty input table would fail with a "table not found" error. Now, these jobs will return an empty result set. ## December 3, 2021 Google Ads is making changes that impact asset-based ads. As a result of these changes, `video_ad_duration` will be more accurate. Additionally, `creative_format_type` is now `YOUTUBE_VIDEO`, not `TYPE_VIDEO`. Any queries using impacted fields will continue to run successfully. ## December 1, 2021 To align with other platforms, Ads Data Hub is making changes to how unmeasurable impressions are calculated. - **Previous** calculation: `num_unmeasureable_impressions` = `num_enabled_impressions` - `num_measurable_impressions` - **New** calculation: `num_unmeasureable_impressions` = `num_impressions` - `num_measurable_impressions` This change also fixes an issue where the [Invalid traffic API](https://developers.google.com/ads-data-hub/marketers/resources/ads-data-hub/marketersguides/query_viewability_metrics) erroneously reported unmeasurable impressions as zero from approximately August 1, 2021 - December 1, 2021. ## November 8, 2021 All `*_paths` tables are disabled for accounts that aren't actively using them. The `*_paths` tables won't be enabled for new accounts by default. Contact your Google representative if you need access. ## November 2, 2021 Ads Data Hub added 3 new [Advanced active view metric](https://developers.google.com/ads-data-hub/marketers/reference/viewability-metrics/overview) queries to the [templated queries](https://developers.google.com/ads-data-hub/marketers/guides/run-queries) page. These queries are now available for your use. ## October 22, 2021 Ads Data Hub is deprecating 24 fields on November 11, 2021. These fields are duplicated across a number of tables. To ensure that your queries continue to work, update queries that references these fields in accordance with the [migration guide](https://developers.google.com/ads-data-hub/marketers/brandmeasurement/viewability/schema#migration_schema). The following 3 fields: - `num_active_view_eligible_impression` - `num_active_view_measurable_impression` - `active_view_data` Will be deprecated in the following 4 tables: - `adh.google_ads_impressions` - `adh.dv360_youtube_impressions` - `adh.yt_reserve_impressions` - `adh.partner_sold_cross_sell_impressions` And the following 3 fields: - `num_active_view_viewable_impression` - `active_view.view_state` - `active_view.active_view_data` Will be deprecated in the following 4 tables: - `adh.google_ads_active_views` - `adh.dv360_youtube_active_views` - `adh.yt_reserve_active_views` - `adh.partner_sold_cross_sell_active_views` ## October 12, 2021 A new set of viewability metrics, collectively known as "Advanced Active View metrics", are now available in Ads Data Hub. These metrics replace existing signal-based integrations on January 3, 2021. Advanced Active View metrics enable the computation of a broader set of metrics, with a more robust schema that's easier to use. To learn more, read the [viewability documentation](https://developers.google.com/ads-data-hub/marketers/brandmeasurement/viewability/overview). ## October 6, 2021 Past outage: Ads Data Hub experienced a disruption of query services from Saturday, October 2, 2021 to Sunday, October 3, 2021. As a result, some queries may not run. ## September 22, 2021 `advertiser_timezone` is now populating in the following tables: \* `google_ads_customer` \* `dv360_youtube_advertiser` \* `yt_reserve_order` \* `partner_sold_cross_sell_order` `advertiser_timezone` surfaces the [IANA time zone](https://www.iana.org/time-zones) of the ads buying platform. This allows queries to return results in the same timezone as the front-end settings set by the advertiser. Learn how to use the `advertiser_timezone` field in this [sample query](https://developers.google.com/ads-data-hub/marketers/samples/writing-queries#google_ads_advertiser_time_zone_settings). ## July 19, 2021 The `skippable_ad_type` field is moving from the `yt_reserve_lineitem` table to the `yt_reserve_creative` table. The `yt_reserve_lineitem.skippable_ad_type` field will be deprecated on September 19, 2021. Update your queries to use `skippable_ad_type.yt_reserve_creative`. ## July 8, 2021 The Media Rating Council (MRC) audit of Ads Data Hub's first-party viewability measurement reporting is complete. Third-party vendors can now initiate accreditation of their YouTube third-party viewability measurement reporting with the MRC. [Learn more about MRC-accredited viewability metrics and find sample queries](https://developers.google.com/ads-data-hub/marketers/guides/query_viewability_metrics) ## July 1, 2021 ### Job results preview You can now preview the first 20 rows of your query results on the "Jobs" page. To try it out, [run a query in Ads Data Hub](https://developers.google.com/ads-data-hub/marketers/guides/run-queries) and click **Preview** once your query finishes running. ### In-product notifications Account notifications are now available via a notifications panel in Ads Data Hub. You'll be able to see notifications about new features, deprecations, outages, and more. ## May 24, 2021 Ads Data Hub is expanding opportunities for participation in user studies, market research, and pilots. To receive emails about upcoming research: 1. Navigate to **Settings** in [Ads Data Hub](https://adsdatahub.google.com/marketers#/). 2. Under "Email preferences", click the checkbox below "Feedback and testing". ## April 9, 2021 Ads Data Hub released 1 new table and 2 new fields (across 2 tables). The new table and fields provide information on inventory in app stores serving through Google Display and Video networks. The new fields are `app_id` and `app_store_id` (both found in `{google_ads/dv360_youtube}_impressions`), and the new table is `mobile_app_info`. Learn more by reading the field descriptions, or running the [sample query](https://developers.google.com/ads-data-hub/marketers/samples/writing-queries#app_store_impressions). ## March 15, 2021 Ads Data Hub is migrating API support from Google Groups to [Google IssueTracker](https://developers.google.com/issue-tracker). Migrating channels will enable the support team to respond to requests more effectively and facilitate knowledge sharing between users experiencing identical issues. Support for the Google Group will be turned down on April 1, 2021. Effective immediately, you can [view open issues](https://issuetracker.google.com/issues?q=componentid:650788+status:open) in the new group and [create new issues](https://issuetracker.google.com/issues/new?component=650788&template=1553722). ## February 26, 2021 As [announced on November 10, 2020](https://developers.google.com/ads-data-hub/marketers/resources/release-notes#november_10_2020), the following fields are now deprecated: - `operating_system_version_ids`: Replace with `operating_system`. - `snippet_url.*`: Has been deprecated since March 2020. - `beacon_url`: Has been deprecated since March 2020. - `region_code`: Replace with `region_name`. - `metro_code`: Replace with `metro_name`. - `metro_abbrev`: Replace with `metro_name`. - `longitude`: Use `city` or `metro` instead. - `latitude`: Use `city` or `metro` instead. ## February 23, 2021 Edit: As of June 2022, Ads Data Hub no longer supports YouTube audio ads. ~~Ads Data Hub now supports YouTube audio ads. You can identify YouTube audio ad~~ ~~groups in The Google Ads and Display \& Video 360 adgroup tables by using~~ ~~`google_ads_adgroup/dv360_youtube_adgroup.adgroup_type = YOUTUBE_AUDIO`.~~ [~~Learn more about YouTube audio ads~~](https://blog.google/products/ads-commerce/youtube-music-audio-ads/) ## February 22, 2021 Ads Data Hub made changes to the MRC-approved templated queries available in the UI. Some of these changes impact the names of output columns. The changes are outlined below. Viewability: - Updated to join impressions and active views on the new `impression_id` field. - Now excludes YouTube TV from inventory type. YouTube TV is out of scope for MRC accreditation, so it is now filtered from results. - `num_unmesurable_impressions` was corrected to `num_unmeasurable_impressions`. - Updated to correctly classify mobile app metrics as OTT. This has a minor impact on a small fraction of impressions. Invalid traffic: - The "TrueView: Views" metric name was rebranded to "YouTube views" for Display \& Video 360. - The following device types were aligned with the viewability queries: - "Desktop" was changed to "Desktop Web". - "Mobile_Web" was changed to "Mobile Web". - "Mobile_App" was changed to "Mobile app" - "OTT" was changed to "Ott". ## February 5, 2021 Ads Data Hub has made multiple changes related to MRC-accreditation: - The [description of methodology](https://developers.google.com/ads-data-hub/marketers/resources/description_of_methodology) has been updated to include MRC-approved general invalid traffic metrics. - The [query viewability and invalid traffic metrics](https://developers.google.com/ads-data-hub/marketers/guides/query_viewability_metrics) tutorial now includes formulas for calculating viewability metrics net of general invalid traffic. ## February 3, 2021 Beginning March 1, 2021 the `adh.cm_dt_activities` and `adh.dv360_dt_activities` tables won't populate with new data. Queries that use these tables will still run, but won't return current data. Ensure that your queries are rewritten to use the following tables: - `adh.cm_dt_activities_events` - `adh.cm_dt_activities_attributed` - `adh.dv360_activities_attributed` ## January 25, 2021 The results page now provides information when rows (including filtered row summaries) are filtered from your results. [Learn more about filtered row summaries](https://developers.google.com/ads-data-hub/marketers/guides/filtered-row-summary) ## January 13, 2021 Ads Data Hub now shows the expected number of bytes that a query will use, before you run it. This can be used to estimate how long the query will take to run. ## December 10, 2020 You can now use Ads Data Hub to build and manage audience lists for use in Google Ads, and Display \& Video 360. [Learn more about audience activation](https://developers.google.com/ads-data-hub/marketers/guides/audience-activation) ## December 4, 2020 The Ads Data Hub policies were updated to include more information related to audience activation features, acceptable use, and sensitive interest information and categories. ## November 10, 2020 Ads Data Hub is removing 9 fields. These fields are either inconsistently populated, or have been previously deprecated. Effective January 29, 2021, the fields will all return `null`. Effective February 26, 2021, the fields will be removed from the schema. - `operating_system_version_ids`: Replace with `operating_system`. - `snippet_url.*`: Has been deprecated since March 2020. - `beacon_url`: Has been deprecated since March 2020. - `region_code`: Replace with `region_name`. - `metro_code`: Replace with `metro_name`. - `metro_abbrev`: Replace with `metro_name`. - `longitude`: Use `city` or `metro` instead. - `latitude`: Use `city` or `metro` instead. ## November 5, 2020 Vendors now no longer have access to `dv360_dt_*` and `cm_dt_*` tables. ## November 2, 2020 Ads Data Hub added 2 new statistical models for use in performance measurement, [Markov chain analysis](https://developers.google.com/ads-data-hub/marketers/guides/markov) and the [Shapley value method](https://developers.google.com/ads-data-hub/marketers/guides/shapley). Both models can be used to compute the modeled contribution that a campaign, advertising channel, or other touchpoint had on conversions. ## October 30, 2020 You can now use [query history audits](https://developers.google.com/ads-data-hub/marketers/guides/query-history-audit) to generate logs of all jobs run using your Ads Data Hub account. ## October 22, 2020 Ads Data Hub is adding a new field, `impression_id`, to all Google Ads, Display \& Video 360 YouTube, partner-sold cross-sell, and YouTube Reserve event tables. Historically, users depended on `query_id` to join clicks, conversions, and Active Views to impressions. However, this caused reporting discrepancies in cases where multiple ad impressions existed in one query (such as ad pods on YouTube). `impression_id` improves this workflow by providing a join key that is unique to individual impressions. ## October 20, 2020 You can now launch support resources from the Ads Data Hub UI. Launch the help panel by clicking Help . The panel allows you to: - View relevant help articles. - Contact support. - Send feedback. ## October 15, 2020 Linking Google Ads accounts is now easier. Read more about self-service account linking [here](https://developers.google.com/ads-data-hub/marketers/guides/link-accounts#link_your_google_ads_account). ## October 1, 2020 Ads Data Hub is deprecating `adh.cm_dt_activities` and `adh.dv360_activities`. These tables are being deprecated to allow for improvements that will enable support for additional attribution models and continuously streaming data. The improved tables are available for all users, and should be used for query development moving forward: - `adh.cm_dt_activities_events` - `adh.cm_dt_activities_attributed` - `adh.dv360_activities_attributed` ## August 27, 2020 Ads Data Hub now supports customer-managed encryption keys, allowing you to control the cryptographic keys used to encrypt your data at rest. [Learn more about enabling customer-managed encryption keys](https://developers.google.com/ads-data-hub/marketers/guides/cmek) ## July 17, 2020 As a prerequisite to additional security features, Ads Data Hub is introducing restrictions governing changes to the specific Google Cloud project used for administrating your Ads Data Hub account. These changes won't impact your account functionality and don't require action. Learn more about [designating an admin project](https://developers.google.com/ads-data-hub/marketers/guides/account-setup#designate_an_admin_project). ## June 25, 2020 Effective immediately, the `cm_dt_events` table is deprecated. A Google representative should have reached out with instructions regarding how to rewrite any queries that depended on this table. ## June 19, 2020 You can now open query results in Google Sheets and Data Studio directly from the completed job in Ads Data Hub. [Learn how to view results](https://developers.google.com/ads-data-hub/marketers/guides/run-queries#view_your_results) ## June 15, 2020 Display \& Video 360 YouTube data is now being populated in `adh.dv360_youtube_*` tables. This data was previously available in `adh.google_ads_*` tables. See the [earlier release note](https://developers.google.com/ads-data-hub/marketers/resources/release-notes#january_7_2019) for additional details on modifying your queries for compatibility with the new tables. ## June 3, 2020 You can now query offline events uploaded using the Campaign Manager Offline Conversions API in Ads Data Hub. Offline events can take up to 14 days to appears in the `adh.dv360_dt_activities` and `adh.cm_dt_activities` tables. ## June 2, 2020 The feature formerly known as "row merge" has been renamed to "filtered row summary". All functionality remains the same, and you should continue using filtered row summaries as you were using row merges before. This change extends only to the feature's name. ## June 1, 2020 Ads Data Hub is releasing the following updates to improve usability: ### Schema assistant You can now search the "Table schemas" sidebar for tables and fields. Fields can be copied or added to your query using the click of a button. ### Export to Data Studio and Google Sheets You now have more options for how to work with your results outside of Ads Data Hub. You can explore results in Data Studio and Google Sheets, in addition to BigQuery. ### Help menu The help menu now provides more robust support options. You can find contextually recommended articles, contact support, and send feedback all from the same menu ## May 8, 2020 Linking Display and Video 360 and Campaign manager accounts is now easier, with self-service account linking. Read more about the new account linking process [here](https://developers.google.com/ads-data-hub/marketers/guides/link-accounts). ## 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 ## April 16, 2020 Display \& Video 360 YouTube data is no longer automatically populated unless explicitly requested. If you want to enable Display \& Video 360 YouTube data, submit a ticket to Ads Data Hub support via the [Ads Data Hub support form](https://support.google.com/ads-data-hub/marketers/contact/adh_support). Then, select **Ads Data Hub UI access and functionality issues**, and request "Feature enablement for Display \& Video 360 YouTube data". ## 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](https://developers.google.com/ads-data-hub/marketers/guides/run-queries), or try running a query in the [UI](https://adsdatahub.google.com/marketers#/). ### 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](https://developers.google.com/ads-data-hub/marketers/guides/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](https://developers.google.com/ads-data-hub/marketers/guides/paths) ## 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](https://developers.google.com/ads-data-hub/marketers/samples/writing-queries#ad_skips). ## October 14, 2019 We've added 2 new customer types to the table format documentation: [agencies](https://developers.google.com/ads-data-hub/marketers/reference/table-format/agencies) and [holding companies](https://developers.google.com/ads-data-hub/marketers/reference/table-format/holding_companies). Additionally, we've updated the [advertiser](https://developers.google.com/ads-data-hub/marketers/reference/table-format/advertisers) and [vendor](https://developers.google.com/ads-data-hub/marketers/reference/table-format/vendors) 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. ## June 14th, 2019 The `adh.cm_dt_floodlight` table has been removed from the Data Transfer schema. This table hasn't been populated with data since mid-2018. This shouldn't be confused with the `adh.cm_dt_activities` table, which contains account activity data and is used for attribution. If you have questions, [contact support](https://developers.google.com/ads-data-hub/marketers/support). ## May 21, 2019 Ads Data Hub's new API, [Ads Data Hub v1](https://developers.google.com/ads-data-hub/marketers/reference/rest), is now generally available. Learn how to [migrate to the new API](https://developers.google.com/ads-data-hub/marketers/reference/migrating). ## April 17, 2019 You can now test queries and look at synthetic event-level data using the new sandbox role. [Learn more](https://developers.google.com/ads-data-hub/marketers/guides/sandbox). ## 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](https://developers.google.com/ads-data-hub/marketers/guides/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](https://developers.google.com/ads-data-hub/marketers/reference/table-format/advertisers) 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](https://developers.google.com/ads-data-hub/marketers/reference/table-format/advertisers) 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](https://developers.google.com/ads-data-hub/marketers/reference/table-format/advertisers#gdn_trueview) for suggested workarounds. ## August 24, 2018 AdWords tables were renamed to reflect the new Google Ads name. See [table format](https://developers.google.com/ads-data-hub/marketers/reference/table-format/advertisers) 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](https://developers.google.com/ads-data-hub/marketers/reference/table-format/advertisers#display--video-360-metadata) 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](https://developers.google.com/ads-data-hub/marketers/samples/writing-queries#match_floodlight_variables_with_temp_tables), 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](https://developers.google.com/ads-data-hub/marketers/reference/table-format/advertisers#dcm-metadata-dt-match-tables) and [sample queries](https://developers.google.com/ads-data-hub/marketers/samples/writing-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](https://developers.google.com/ads-data-hub/marketers/reference/table-format/advertisers), [sample queries](https://developers.google.com/ads-data-hub/marketers/samples/writing-queries), and [join your data](https://developers.google.com/ads-data-hub/marketers/guides/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](https://developers.google.com/ads-data-hub/marketers/guides/link-accounts) ## May 1, 2017 ### New There is an updated custom query user interface for Ads Data Hub.