Google Ads Data Transfer into BigQuery does not bring in all tables

[nealpatrick]

I am using the Data Transfer process to bring in my Google Ads data. While many tables are populated, the tables/views for Shopping: ShoppingProductConversionStats and ShoppingProductStats are empty. Is there something that I need to do in order to ensure that this information is brought into Bigquery as well?

[Roderick]

Hey @nealpatrick,

I am not an expert in this area, however I did do a little poking around in the knowledge base.

Yes, there are some things you can do to ensure that the ShoppingProductConversionStats and ShoppingProductStats tables are populated when you use the Data Transfer process to bring in your Google Ads data.

First, make sure that you are using the correct Data Transfer process. There are two different processes available: the Data Transfer API and the Google Ads Data Transfer tool. The Data Transfer API is a more flexible option, but it requires more technical expertise to use. The Google Ads Data Transfer tool is a more user-friendly option, but it is not as flexible.

Second, make sure that you are selecting the correct data sources. When you use the Data Transfer process, you can select from a variety of data sources, including Google Ads, Google Analytics, and Google Merchant Center. Make sure that you are selecting the data sources that contain the data you want to bring into BigQuery.

Third, make sure that you are using the correct destination table. When you use the Data Transfer process, you can specify the destination table where you want to bring the data. Make sure that you are specifying a table that exists in BigQuery.

Finally, make sure that you are using the correct configuration settings. When you use the Data Transfer process, you can configure a variety of settings, including the frequency of the transfer, the format of the data, and the storage location for the data. Make sure that you are configuring the settings that meet your needs.

If you are still having trouble, please contact Google Ads support for further assistance.

[Snoshone07]

Hi @nealpatrickIt sounds like you're successfully transferring most of your Google Ads data, but you're encountering issues with the ShoppingProductConversionStats and ShoppingProductStats tables being empty in BigQuery.

Here are a few things you can check to troubleshoot the issue:

1. Check Campaign Types: Ensure that your Google Ads account is actively running Shopping campaigns. If there are no active Shopping campaigns or product ads, the tables might remain empty because there's no relevant data to populate.

2. API Data Availability: Not all data types are immediately available through the BigQuery Data Transfer process, especially for specific ad formats like Shopping. Double-check if the Shopping conversion data is available in Google Ads and whether any specific permissions or settings are required to retrieve it via API.

3. Conversion Tracking Setup: Ensure that conversion tracking is properly set up for Shopping ads. If conversion tracking is not correctly configured in Google Ads, you might not see any data reflected in those tables.

4. Scheduled Updates: Check if the data is delayed. Sometimes, Shopping data may not populate instantly. Try waiting for the next scheduled transfer or manually triggering a refresh to see if the data appears.

5. Alternative Solution: If the tables remain empty after checking the above points, you could consider using a third-party connector like Windsor.ai, which might give you more flexibility in fetching granular Shopping campaign data into BigQuery.

Hope this helps!