BigQuery Data Transfer Service data source change log
This page provides details about changes to BigQuery Data Transfer Service data sourceschemas and schema mappings. For information about upcoming changes to the BigQuery Data Transfer Serviceconnectors, you can search this page for data sources, such asGoogle Ads API orDisplay & Video 360 API, or for specific table names orvalues.
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 connectorretrieves data from Campaign Manager 360Data 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 tocontinue receiving data from Campaign Manager 360.
July 07, 2025
Campaign Manager 360 made anannouncement 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 supportnew columns and adapt to changes introduced by newDisplay & Video 360API versions.The BigQuery Data Transfer Service for Display & Video 360 connector uses thesupported API version to retrieveconfiguration data.
The following sections outline the changes when updating to a newDisplay & Video 360 API version. Changes are organized by release date,and each entry provides information on the changes you need to make for you tocontinue receiving data from Display & Video 360.
August 26, 2025
The Display & Video 360 connectorplans to update theDisplay & Video 360 API versionused to retrieve configuration data fromv3 tov4.Changes from the API upgrade are listed in the following section. For more information, seeDisplay & 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.
CampaignTargetingInsertionOrderTargeting
Tables with renamed columns
| Tables affected | Deprecated columns | New columns |
|---|---|---|
| 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 |
Google Ads API
The BigQuery Data Transfer Service for Google Ads periodically updates to supportnew columns and adapt to changes introduced by newGoogle AdsAPI versions.The BigQuery Data Transfer Service for Google Ads connector uses thesupported API versionin the Google Ads connector.
The following sections outline the changes when updating to a newGoogle Ads API version. Changes are organized by release date,and each entry provides information on the changes you need to make for you tocontinue receiving data from Google Ads.
For more information about the Google Ads API release schedule,seeTimetable.
March 2, 2026
TheGoogle Ads connectorplans to update theGoogle Ads API versionfromv21 tov22.After the API upgrade, the column values for newly transferred data in the affectedtables will change. For more information, seeGoogle Ads API upgrade.
| Deprecated columns | New columns | Tables affected |
|---|---|---|
metrics_average_cpv | metrics_trueview_average_cpv |
|
metrics_video_view_rate | metrics_video_trueview_view_rate |
|
metrics_video_views | metrics_video_trueview_views |
|
By Jan 16, 2026, the Google Ads connector will add the columnsmetrics_trueview_average_cpv,metrics_video_trueview_view_rate andmetrics_video_trueview_views to the table schema and populate them withnull. After the update to Google Ads API v22 on March 2, 2026, these new columns will be populated with new values. Some columns are now deprecated, such asmetrics_average_cpv,metrics_video_view_rate andmetrics_video_views. Deprecated columns are now populated withnull, 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 is populated withnull. In response to the Google Ads API v22 update, update your queries to specify one of the two columns. For example, if your SQL query selects the columnmetrics_average_cpv, update the query so that it specifies the correct column:
IFNULL(metrics_average_cpv,metrics_trueview_average_cpv)
If you usecustom reports, see theGoogle Ads API v22 reference page and theGoogle Ads API release notes to update impacted GAQL queries after theGoogle Ads connector is upgraded to Google Ads v22 API.If you usecustom reports, see theGoogle Ads API v22 reference page and theGoogle Ads API release notes to update impacted GAQL queries after theGoogle Ads connector is upgraded to Google Ads v22 API.
August 1, 2025
Google Ads transfersplans to update theGoogle Ads API versionfromv18 tov20.After the API upgrade, the column values for newly transferred data in the affectedtables will change. For more information, seeGoogle 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 transfersplans to update theGoogle Ads API versionfromv16 tov18.After the API upgrade, the column values for newly transferred data in the affectedtables will change. For more information, seeGoogle 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 toselect both old and new values. For example, if you have the followingWHEREcondition in your SQL query:
WHEREasset_type='DISCOVERY_CAROUSEL_CARD'
Replace with the following statement:
WHEREasset_type='DISCOVERY_CAROUSEL_CARD'ORasset_type='DEMAND_GEN_CAROUSEL_CARD'
June 24, 2024
Google Ads transfersplans to update theGoogle Ads API versionfrom v14 tov16.In this API upgrade, the column names for newly transferred data in the affectedtables are changed. Also, some columns are deprecated. For more information, seeGoogle 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 |
|---|---|---|
| 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 | |
| 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 | |
| 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 assegments_product_category_level1 andsegments_product_category_level2, were added to the BigQuery table schema but were populated withnull. With the update to Google Ads API v16, these new columns will be populated with new values. Deprecated columns, such assegments_product_bidding_category_level1 andsegments_product_bidding_category_level2, will be populated withnull, 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 withnull. 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_level1Replace 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 withnull.
Google Analytics API
The BigQuery Data Transfer Service for Google Analytics connector periodically updates to supportnew columns and adapt to changes introduced by newGoogle Analytics Data API versions.The BigQuery Data Transfer Service for Google Analytics connector uses the latestsupported API version to retrieve reporting data.
The following sections outline the changes when updating to a newGoogle Analytics Data API version. Changes are organized by release date,and each entry provides information on the changes you need to make tocontinue receiving data from Google Analytics.
September 22, 2025
Note: These changes only affect users who used the Google Analytics connector before April 25, 2025.The Google Analytics connectorplans to deprecate tables and update schemas to reflect changes inGoogle 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 thep_ga4_conversions andp_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 theTable 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 theGoogle 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
landingPagedimension. - Field renaming and discontinuation: The conversions field is renamed to
keyEventsacross all reports to align with current Google Analytics terminology. Consequently, the "conversions" report itself is discontinued. - Data type changes: Revenue fields change from
INTEGERtoFLOATin 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 previoussnake_case(for example,event_count).
Google Play Console
The BigQuery Data Transfer Service for Google Play connector periodically updatesto support new reports and changes of current reports introduced by Google Play.
The following sections outline the changes organized by release date.
December 1, 2025
Google Play plans to make the following changes to theEarnings report. The changes will be reflected in the BigQuery tablep_Earnings_suffix. These changes are listed in the following sections.
Renamed columns
The following Google Play columns will be renamed.
| Deprecated columns | New columns |
|---|---|
Base_Plan_ID | Base_Plan_or_Purchase_Option_ID |
Product_id | Package_ID |
Column value change
The columnProduct_Type will change from a numeric representation toa human-readable string.
New column
A new columnSales_Channel will be added to the Earnings report. This field provides information on where the sale originates from.
Salesforce Bulk API
The BigQuery Data Transfer Service for Salesforce connectorperiodically updates to support changes introduced by theSalesforce Bulk API.
The following sections outline the changes when the Salesforceconnector updates to a new Bulk API version. Changes are organized by releasedate, and each entry provides information on the changes you need to make foryou to continue receiving data from Salesforce.
October 14, 2025
As part of the Salesforce connector GA release, theSalesforce connector now uses Salesforce Bulk APIV1 version 64.0. Several fields that were supported in the SalesforceBulk API V1 version 53.0 are no longer supported.
Deprecated fields
The following table shows the fields deprecated with the Salesforceconnector GA release, along with thesObject name associated with each field.
| Deprecated Field | sObject name |
|---|---|
EffectiveDate | MobSecurityCertPinConfig |
PermissionsAllowObjectDetectionTraining | Profile |
PermissionsAllowObjectDetection | Profile |
PermissionsAllowObjectDetectionTraining | PermissionSet |
PermissionsAllowObjectDetection | PermissionSet |
MaximumPermissionsAllowObjectDetectionTraining | PermissionSetLicense |
MaximumPermissionsAllowObjectDetection | PermissionSetLicense |
PermissionsAllowObjectDetectionTraining | UserPermissionAccess |
PermissionsAllowObjectDetection | UserPermissionAccess |
PermissionsAllowObjectDetectionTraining | MutingPermissionSet |
PermissionsAllowObjectDetection | MutingPermissionSet |
OptionsHstsHeaders | Domain |
UserPreferencesHideInvoicesRedirectConfirmation | User |
UserPreferencesHideStatementsRedirectConfirmation | User |
UserPreferencesHideInvoicesRedirectConfirmation | UserChangeEvent |
UserPreferencesHideStatementsRedirectConfirmation | UserChangeEvent |
YouTube Reporting API
The BigQuery Data Transfer Service for YouTube Content Owner connector andYouTube Channel connector periodically updates to support new reportsintroduced byYouTube Reporting APIand deprecate old reports.
The following sections outline the changes when new reports are introduced byYouTube Reporting API. Changes are organized by release date, and eachentry provides information on the changes you need to make to continue receivingdata from YouTube.
September 22, 2025
The YouTube Content Owner connectorandThe YouTube Channel connectorplan to introduce new reports and deprecate old reports to reflect theYouTubeshorts view count change.These changes are listed in the following sections.
New reports are planned to start on July 7, 2025. No action is requiredfrom you to get the new reports. The deprecation of old reports is planned tostart on September 22, 2025.
YouTube Content Owner connector - deprecated tables
For the YouTube Content Owner connector, the following table shows theBigQuery tables that will be deprecated and replaced with newtables with updated schemas. Both deprecated and new tables will be populateduntil September 22, 2025 to allow time for migration. After September 22, 2025,only the new tables will be populated. The value forsuffix is thetable 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 theBigQuery tables that will be deprecated and replaced with newtables with updated schemas. Both deprecated and new tables will be populateduntil September 22, 2025 to allow time for migration. After September 22, 2025,only the new tables will be populated. The value forsuffix is thetable 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 namedengaged_views. For moreinformation about this metric, seeShorts Viewcounting Changes.
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-15 UTC.