Gads transfer to BigQuery missing Pmax data

[ahorakova]

Hi, 

I am having issue when loading data from Google Ads to BigQuery via the official connector (data transfer). Even I have checked the checkbox in data transfer to include Pmax campaigns (and the new tables appeared in the dataset in BQ), I can't see the metrics for Pmax campaigns in p_ads_CampaignAssetStats_xxx table. These campaigns are completely missing. But I can see the name and id of Pmax in p_ads_Campaign_xxx table, so something about the Pmax campaigns is loading, but not the metrics.

Any ideas what is the problem?

Thank you for your answer,

Anna

[Snoshone07]

Hi @ahorakova the issue you’re experiencing—where PMax campaign names and IDs appear in the p_ads_Campaign_xxx table, but the corresponding metrics are missing from the p_ads_CampaignAssetStats_xxx table—is actually quite common.

Reason why it happens

1. PMax Campaign Limitations
   Performance Max campaigns are still relatively new, and Google Ads’ Data Transfer connector has some limitations when exporting metrics for PMax campaigns. Google is actively evolving its reporting structure for these campaigns, so not all metrics or assets are currently available through this connector.

2. Data Processing Delays
   Metrics for PMax campaigns sometimes take longer to sync and populate in BigQuery due to delays in Google’s data processing pipeline.

3. Connector Configuration
   While you mentioned enabling PMax campaigns during the setup, it’s worth verifying that the specific metrics and dimensions you’re looking for are compatible with the p_ads_CampaignAssetStats_xxx table.

Steps to Troubleshoot and Resolve

1. Confirm Metrics Availability for PMax Campaigns

• Double-check whether Google Ads supports the exact metrics you’re trying to access for PMax campaigns in BigQuery.
• Refer to the Google Ads API documentation to confirm which fields and metrics are compatible with PMax campaigns.

1. Check Other Tables for the Data
   PMax campaign metrics might sometimes show up in other tables, such as:

• p_ads_CampaignStats_xxx
• p_ads_AdGroupStats_xxx
  Run some queries on these tables to see if the data is available elsewhere.

1. Verify Using the Google Ads API
   You can directly query the Google Ads API to check if the PMax campaign metrics are being returned. If the API does show the data but BigQuery doesn’t, the issue is likely with the Data Transfer Service itself, rather than the campaigns.

Alternative Solution: Use a Third-Party Tool

If the Google Ads Data Transfer connector continues to fall short, consider using third-party tools like Windsor.ai. These tools can offer:

• Greater flexibility in extracting and loading PMax campaign metrics.
• Seamless integration between Google Ads and BigQuery.
• Compatibility with Google Ads’ latest updates, ensuring you don’t miss important data from PMax campaigns.

Key Takeaways

• Confirm whether PMax metrics are supported in the p_ads_CampaignAssetStats_xxx table.
• Check other tables in your BigQuery dataset to locate PMax data.
• Use the Google Ads API to validate whether the data exists.
• Explore tools like Windsor.ai for a more flexible and reliable data integration solution.