BQ migration to DTS based on API v12

[Andrzej Mykowski]

Hello,

I was informed in the email from Google that on the 24.04.2023 that there will be a major change on the schema of the tables within BQ and we are working to prepare for it.

I would like to ask you for help with few questions as I was not able to find any official materials on this topic:

Currently we are seeing that for each transfer that we create which as a source has "Google Ads (formerly AdWords)" there are 2 additional created by BQ with a suffix "_converted"

Questions:

1. why do I see 2 "_converted" transfers? 
2. what will happen to these on 24.04.2023 <- GA date? Which will be preserved & which deleted? Will only the label change?
3. right now we have the "_converted" ones disabled <- do we need to enable them on or prior to 24.04.2023?
4. I saw that in the new schema there is no explicit connection between search query and keyword instead there is a link between a search query and ad. On the other hand in the views backward compatibility doc [https://developers.google.com/google-ads/api/fields/v13/search_term_view] I see that the new view will still hold this info. Question: from which tables and via what linking this info is retrieved?
5. why do some tables e.g. p_ads_PlacementStats_customer_id are still not retrieving info i.e. coming back blank? Will this change on 24.04?
6. in the email [attached below] it is stated that current transfers will start failing on the 24.04 -> will this be switched off by client or by table or any other mechanism [I'm asking because it will take a month]?
7. right now our code creates transfers based on Google Ads (formerly AdWords) -"adwords"; after 24.04.2023 do we need to update the code [.setDataSourceId("googleads")] or the "adwords" source will link to Google Ads?

Please let me know if I need to provide any more information.

We’re writing to let you know the date for the General Availability (GA) of BigQuery Data Transfer Service (DTS) for Google Ads will be April 24, 2023.

What do you need to know?

We previously notified you about the DTS for Google Ads launch and your transition as response to the sunset of Adwords API. We created new transfer configurations within your projects in BigQuery to prepare to transition your Adwords configurations to Google Ads. These created configurations did not initiate any data transfer and were used exclusively for testing purposes.

Here’s the timeline for the Google Ads GA and the sunset of Google Adwords:

Key Dates

What will happen?

March 20 to April 23, 2023

• The new Google Ads based configurations will start populating data in your BigQuery datasets from the Google Ads data source.

• The Google Ads transfers will result in new tables in existing datasets, and your existing views will incorporate data from the new tables and will stay backwards compatible.

April 24, 2023

• DTS will be GA for Google Ads. 

• DTS will reject the creation of new Adwords based transfer configurations. 

• Deprecation of DTS for Adwords. 

April 24, 2023 to May 21, 2023

• All Adwords-based transfers will start returning transfer errors.

May 22, 2023

• Sunset of DTS for Adwords. 

• Google Adwords will no longer be available as a data source for DTS.

[Google Ads API and AdWords API Forum]

Re-posting the last inquiry (https://groups.google.com/g/adwords-api/c/-bUGTwNibzA) from the forum as it wasn't routed to our support queue.

Regards,
Google Ads API Team