BigQuery Data Transfer Service data source change log

This page provides details about changes to BigQuery Data Transfer Service data source schemas and schema mappings. For information about upcoming changes to the BigQuery Data Transfer Service connectors, you can search this page for data sources, such as Google Ads API or Display & Video 360 API, or for specific table names or values.

Campaign Manager 360

The BigQuery Data Transfer Service for Campaign Manager 360 connector periodically updates to support new, deprecated, or migrated columns. The BigQuery Data Transfer Service for Campaign Manager 360 connector retrieves data from Campaign Manager 360 Data Transfer files.

The following sections outline the changes. Changes are organized by release date, and each entry provides information on the changes you need to make to continue receiving data from Campaign Manager 360.

July 07, 2025

Campaign Manager 360 made an announcement to update its criterion IDs for browser, operating system, mobile make and model, and ISP data to align with the cross-platform data standards. After the migration, Campaign Manager 360 will stop populating values for deprecated columns and will start populating the new columns. The impacted columns are as follows:

Deprecated columns New columns
DBM_Browser_Platform_ID DV360_Browser_Platform_Reportable_ID
DBM_ISP_ID DV360_ISP_Reportable_ID
DBM_Operating_System_ID DV360_Operating_System_Reportable_ID
DBM_Mobile_Make_ID DV360_Mobile_Make_Reportable_ID
DBM_Mobile_Model_ID DV360_Mobile_Model_Reportable_ID

Display & Video 360 API

The BigQuery Data Transfer Service for Display & Video 360 connector periodically updates to support new columns and adapt to changes introduced by new Display & Video 360 API versions. The BigQuery Data Transfer Service for Display & Video 360 connector uses the supported API version to retrieve configuration data.

The following sections outline the changes when updating to a new Display & Video 360 API version. Changes are organized by release date, and each entry provides information on the changes you need to make for you to continue receiving data from Display & Video 360.

August 26, 2025

The Display & Video 360 connector plans to update the Display & Video 360 API version used to retrieve configuration data from v3 to v4. Changes from the API upgrade are listed in the following section. For more information, see Display & Video 360 API v3 to v4 migration guide.

This update for the Display & Video 360 connector is planned to start on August 26, 2025.

Deprecated Tables

The following tables will stop receiving new data. Existing data will remain, but no further updates will be populated.

  • CampaignTargeting
  • InsertionOrderTargeting

Tables with renamed columns

Tables affected Deprecated columns New columns
  • AdGroupTargeting
  • LineItemTargeting
 audienceGroupDetails.includedFirstAndThirdPartyAudienceGroups audienceGroupDetails.includedFirstPartyAndPartnerAudienceGroups
audienceGroupDetails.includedFirstAndThirdPartyAudienceGroups.settings audienceGroupDetails.includedFirstPartyAndPartnerAudienceGroups.settings
audienceGroupDetails.includedFirstAndThirdPartyAudienceGroups.settings.firstAndThirdPartyAudienceId audienceGroupDetails.includedFirstPartyAndPartnerAudienceGroups.settings.firstPartyAndPartnerAudienceId
audienceGroupDetails.includedFirstAndThirdPartyAudienceGroups.settings.recency audienceGroupDetails.includedFirstPartyAndPartnerAudienceGroups.settings.recency
audienceGroupDetails.excludedFirstAndThirdPartyAudienceGroup audienceGroupDetails.excludedFirstPartyAndPartnerAudienceGroup
audienceGroupDetails.excludedFirstAndThirdPartyAudienceGroup.settings audienceGroupDetails.excludedFirstPartyAndPartnerAudienceGroup.settings
audienceGroupDetails.excludedFirstAndThirdPartyAudienceGroup.settings.firstAndThirdPartyAudienceId audienceGroupDetails.excludedFirstPartyAndPartnerAudienceGroup.settings.firstPartyAndPartnerAudienceId
audienceGroupDetails.excludedFirstAndThirdPartyAudienceGroup.settings.recency audienceGroupDetails.excludedFirstPartyAndPartnerAudienceGroup.settings.recency

Tables with deprecated columns

Tables affected Deprecated columns
Creative reviewStatus.publisherReviewStatuses

The BigQuery Data Transfer Service for Google Ads periodically updates to support new columns and adapt to changes introduced by new Google Ads API versions. The BigQuery Data Transfer Service for Google Ads connector uses the supported API version in the Google Ads connector.

The following sections outline the changes when updating to a new Google Ads API version. Changes are organized by release date, and each entry provides information on the changes you need to make for you to continue receiving data from Google Ads.

For more information about the Google Ads API release schedule, see Timetable.

August 1, 2025

Google Ads transfers plans to update the Google Ads API version from v18 to v20. After the API upgrade, the column values for newly transferred data in the affected tables will change. For more information, see Google Ads API upgrade.

Table: p_ads_Ad_customer_id

Columns impacted Deprecated data type
ad_group_type VIDEO_OUTSTREAM
ad_group_ad_ad_type VIDEO_OUTSTREAM

Table: p_ads_Campaign_customer_id

Columns impacted Deprecated data type
campaign_advertising_channel_sub_type VIDEO_OUTSTREAM

Table: p_ads_DisplayVideoKeywordStats_customer_id

Columns impacted Deprecated data type
campaign_advertising_channel_sub_type VIDEO_OUTSTREAM

January 20, 2025

Google Ads transfers plans to update the Google Ads API version from v16 to v18. After the API upgrade, the column values for newly transferred data in the affected tables will change. For more information, see Google Ads API upgrade.

This update for the Google Ads connector started on January 20, 2025, and was completed on February 4, 2025.

Table: p_ads_Campaign_customer_id

Columns impacted Old value (v16) New value (v18)
campaign_advertising_channel_type DISCOVERY DEMAND_GEN

Table: p_ads_Ad_customer_id

Columns impacted Old value (v16) New value (v18)
ad_type

DISCOVERY_MULTI_ASSET_AD

DISCOVERY_CAROUSEL_AD

DISCOVERY_VIDEO_RESPONSIVE_AD

DEMAND_GEN_MULTI_ASSET_AD

DEMAND_GEN_CAROUSEL_AD

DEMAND_GEN_VIDEO_RESPONSIVE_AD

Table: Asset

Columns impacted Old value (v16) New value (v18)
asset_type DISCOVERY_CAROUSEL_CARD DEMAND_GEN_CAROUSEL_CARD

To ensure your queries work after the update, change your queries to select both old and new values. For example, if you have the following WHERE condition in your SQL query:

WHERE asset_type='DISCOVERY_CAROUSEL_CARD'

Replace with the following statement:

WHERE
  asset_type='DISCOVERY_CAROUSEL_CARD'
  OR asset_type='DEMAND_GEN_CAROUSEL_CARD'

June 24, 2024

Google Ads transfers plans to update the Google Ads API version from v14 to v16. In this API upgrade, the column names for newly transferred data in the affected tables are changed. Also, some columns are deprecated. For more information, see Google Ads API upgrade.

This update for the Google Ads connector started on June 17, 2024, and was completed on June 23, 2024.

Tables affected Deprecated columns New columns
  • ShoppingProductStats
  • ShoppingProductConversionStats
 segments_product_bidding_category_level1 segments_product_category_level1
segments_product_bidding_category_level2 segments_product_category_level2
segments_product_bidding_category_level3 segments_product_category_level3
segments_product_bidding_category_level4 segments_product_category_level4
segments_product_bidding_category_level5 segments_product_category_level5
  • ProductGroupStats
 ad_group_criterion_listing_group_case_value_product_bidding_category_id ad_group_criterion_listing_group_case_value_product_category_category_id
ad_group_criterion_listing_group_case_value_product_bidding_category_level ad_group_criterion_listing_group_case_value_product_category_level
  • AssetGroupListingFilter
 asset_group_listing_group_filter_case_value_product_bidding_category_id asset_group_listing_group_filter_case_value_product_category_category_id
asset_group_listing_group_filter_case_value_product_bidding_category_level asset_group_listing_group_filter_case_value_product_category_level
asset_group_listing_group_filter_vertical asset_group_listing_group_filter_listing_source

With Google Ads API v14, new columns, such as segments_product_category_level1 and segments_product_category_level2, were added to the BigQuery table schema but were populated with null. With the update to Google Ads API v16, these new columns will be populated with new values. Deprecated columns, such as segments_product_bidding_category_level1 and segments_product_bidding_category_level2, will be populated with null, but will still remain in the table schema.

For each pair of columns, only one column is populated with values from the Google Ads API while the other will be populated with null. To ensure your existing queries keep working after the update, update your queries to choose one of the two columns. For example, if you have the following statement in your SQL query:

segments_product_bidding_category_level1

Replace with the following statement that specifies the correct column:

IFNULL(segments_product_category_level1, segments_product_bidding_category_level1)

Transfer configurations that are created after June 24th 2024 will always use the new columns. Deprecated columns will still remain in the table schema but populated with null.

Google Analytics API

The BigQuery Data Transfer Service for Google Analytics connector periodically updates to support new columns and adapt to changes introduced by new Google Analytics Data API versions. The BigQuery Data Transfer Service for Google Analytics connector uses the latest supported API version to retrieve reporting data.

The following sections outline the changes when updating to a new Google Analytics Data API version. Changes are organized by release date, and each entry provides information on the changes you need to make to continue receiving data from Google Analytics.

September 22, 2025

The Google Analytics connector plans to deprecate tables and update schemas to reflect changes in Google Analytics Data API v1. These changes are listed in the following sections.

This update for the Google Analytics connector is planned to start on September 22, 2025.

Deprecated tables

The following table shows the tables that will be deprecated and replaced with new tables with updated schemas. Note that the p_ga4_conversions and p_ga4_inAppPurchases tables will be discontinued after this update. Both deprecated and new tables will be populated until September 22, 2025 to allow time for migration. You can filter out deprecated tables using the Table Filter option in the transfer configuration.

Deprecated Table New Table
p_ga4_audiences p_ga4_Audiences
p_ga4_conversions Deprecated
p_ga4_demographicDetails p_ga4_DemographicDetails
p_ga4_ecommercePurchase p_ga4_EcommercePurchase
p_ga4_events p_ga4_Events
p_ga4_inAppPurchases Deprecated
p_ga4_landingPage p_ga4_LandingPage
p_ga4_pagesAndScreens p_ga4_PagesAndScreens
p_ga4_promotions p_ga4_Promotions
p_ga4_techDetails p_ga4_TechDetails
p_ga4_trafficAcquisition p_ga4_TrafficAcquisition
p_ga4_userAcquisition p_ga4_UserAcquisition

Updated table schemas

New table schemas can be found on the Google Analytics report transformation page.

Summary of schema changes:

  • Corrected schemas: The schemas for traffic acquisition, user acquisition, and landing page reports are corrected. For example, traffic acquisition and user acquisition report schemas were previously swapped, and the landing page report was missing the landingPage dimension.
  • Field renaming and discontinuation: The conversions field is renamed to keyEvents across all reports to align with current Google Analytics terminology. Consequently, the "conversions" report itself is discontinued.
  • Data type changes: Revenue fields change from INTEGER to FLOAT in BigQuery to accurately represent floating-point micro values as returned by the API.
  • New table and field naming convention: Field names in new tables use camelCase (for example, eventCount) for consistency with the Google Analytics API, replacing the previous snake_case (for example, event_count).

YouTube Reporting API

The BigQuery Data Transfer Service for YouTube Content Owner connector and YouTube Channel connector periodically updates to support new reports introduced by YouTube Reporting API and deprecate old reports.

The following sections outline the changes when new reports are introduced by YouTube Reporting API. Changes are organized by release date, and each entry provides information on the changes you need to make to continue receiving data from YouTube.

September 22, 2025

The YouTube Content Owner connector and The YouTube Channel connector plan to introduce new reports and deprecate old reports to reflect the YouTube shorts view count change. These changes are listed in the following sections.

New reports are planned to start on July 7, 2025. No action is required from you to get the new reports. The deprecation of old reports is planned to start on September 22, 2025.

YouTube Content Owner connector - deprecated tables

For the YouTube Content Owner connector, the following table shows the BigQuery tables that will be deprecated and replaced with new tables with updated schemas. Both deprecated and new tables will be populated until September 22, 2025 to allow time for migration. After September 22, 2025, only the new tables will be populated. The value for suffix is the table suffix you configured when you created the transfer.

Deprecated Table New Table
p_content_owner_asset_basic_a2_suffix p_content_owner_asset_basic_a3_suffix
p_content_owner_asset_combined_a2_suffix p_content_owner_asset_combined_a3_suffix
p_content_owner_asset_device_os_a2_suffix p_content_owner_asset_device_os_a3_suffix
p_content_owner_asset_playback_location_a2_suffix p_content_owner_asset_playback_location_a3_suffix
p_content_owner_asset_province_a2_suffix p_content_owner_asset_province_a3_suffix
p_content_owner_asset_traffic_source_a2_suffix p_content_owner_asset_traffic_source_a3_suffix
p_content_owner_basic_a3_suffix p_content_owner_basic_a4_suffix
p_content_owner_combined_a2_suffix p_content_owner_combined_a3_suffix
p_content_owner_device_os_a2_suffix p_content_owner_device_os_a3_suffix
p_content_owner_playback_location_a2_suffix p_content_owner_playback_location_a3_suffix
p_content_owner_playlist_basic_a1_suffix p_content_owner_playlist_basic_a2_suffix
p_content_owner_playlist_combined_a1_suffix p_content_owner_playlist_combined_a2_suffix
p_content_owner_playlist_device_os_a1_suffix p_content_owner_playlist_device_os_a2_suffix
p_content_owner_playlist_playback_location_a1_suffix p_content_owner_playlist_playback_location_a2_suffix
p_content_owner_playlist_province_a1_suffix p_content_owner_playlist_province_a2_suffix
p_content_owner_playlist_traffic_source_a1_suffix p_content_owner_playlist_traffic_source_a2_suffix
p_content_owner_province_a2_suffix p_content_owner_province_a3_suffix
p_content_owner_subtitles_a2_suffix p_content_owner_subtitles_a3_suffix
p_content_owner_traffic_source_a2_suffix p_content_owner_traffic_source_a3_suffix
p_content_owner_shorts_ad_revenue_summary_a1_suffix p_content_owner_shorts_ad_revenue_summary_a2_suffix
p_content_owner_shorts_country_ad_revenue_summary_a1_suffix p_content_owner_shorts_country_ad_revenue_summary_a2_suffix
p_content_owner_shorts_day_ad_revenue_summary_a1_suffix p_content_owner_shorts_day_ad_revenue_summary_a2_suffix
p_content_owner_shorts_global_ad_revenue_summary_a1_suffix p_content_owner_shorts_global_ad_revenue_summary_a2_suffix

YouTube Channel connector - deprecated tables

For the YouTube Channel connector, the following table shows the BigQuery tables that will be deprecated and replaced with new tables with updated schemas. Both deprecated and new tables will be populated until September 22, 2025 to allow time for migration. After September 22, 2025, only the new tables will be populated. The value for suffix is the table suffix you configured when you created the transfer.

Deprecated Table New Table
p_channel_basic_a2_suffix p_channel_basic_a3_suffix
p_channel_combined_a2_suffix p_channel_combined_a3_suffix
p_channel_device_os_a2_suffix p_channel_device_os_a3_suffix
p_channel_playback_location_a2_suffix p_channel_playback_location_a3_suffix
p_channel_province_a2_suffix p_channel_province_a3_suffix
p_channel_subtitles_a2_suffix p_channel_subtitles_a3_suffix
p_channel_traffic_source_a2_suffix p_channel_traffic_source_a3_suffix
p_playlist_basic_a1_suffix p_playlist_basic_a2_suffix
p_playlist_combined_a1_suffix p_playlist_combined_a2_suffix
p_playlist_device_os_a1_suffix p_playlist_device_os_a2_suffix
p_playlist_playback_location_a1_suffix p_playlist_playback_location_a2_suffix
p_playlist_province_a1_suffix p_playlist_province_a2_suffix
p_playlist_traffic_source_a1_suffix p_playlist_traffic_source_a2_suffix

Updated table schemas

The new tables will have a new column named engaged_views. For more information about this metric, see Shorts Viewcounting Changes.