No RSA performance data in Google Ads API though it should exist in Ad_Group_Ads table

[Zolifu]

Hi,

I'm curious when reading that RSA asset report exists on performance (Ad_Group_Ad table),
why is that missing from data transfers?

I cannot find a table with ads_AdGroup or p_ads_AdGroupAsset
Among tables i get for p_ads_AdGroup i can only find tables that are not containing impression or click data per asset 'headline' or 'description'.

Can someone help me where these metrics are hidden?

[Snoshone07]

Hi @Zolifu you’ve raised an interesting point regarding the availability of RSA asset performance data in the Google Ads Data Transfer. Unfortunately, the Google Ads Data Transfer doesn’t always include every granular metric that you might find directly in the Google Ads interface or via the API, especially when it comes to newer or more detailed data like RSA asset performance.

What You Can Do:

1. Google Ads API:

   • To access detailed RSA asset performance data, you might need to rely on the Google Ads API, specifically querying the AdGroupAdAssetView resource. This will give you the metrics like impressions and clicks for individual assets (headlines, descriptions, etc.).

2. Custom Solution:

   • Once you pull this data using the API, you can write a custom script or use Google Cloud Functions to load it into BigQuery, if that’s where you need the data to reside.

3. Check Reporting Tools:

   • Double-check any reporting tools or integrations you use to see if they’ve recently added support for these fields.

Additional Resource:

If you’re looking for an easier way to handle and automate this, you might want to check out Windsor.ai’s Google Ads connector. It allows you to access a wide range of fields from Google Ads, and it integrates smoothly with BigQuery. You can just Google their 'Google Ads list of fields' and you'll easily find it online

Hope this helps!