Help Needed: Analyzing Performance of Individual Headlines in Google Ads App Campaign via BigQuery Transfer

[Rakesh Sarma]

Hi everyone,

I've recently deployed an app campaign and I'm looking to analyze its performance using the Google Ads BigQuery Transfer. I joined the p_ads_Ad table with the p_ads_AdStats_ table, but I'm struggling to extract performance metrics for individual headlines.

In my dataset, the headlines are stored in the ad_group_ad_ad_app_ad_headlines column as JSON, formatted like this:

json

[{"text":"Up To x% Off Men's Apparel"},{"text":"Shop Fashion Deals Now"},{"text":"Top Brands in Fashion"},{"text":"Men's Shirts, T-shirts"},{"text":"Latest Men's Apparel"}]

Unfortunately, I can't seem to correlate these headlines with their respective performance metrics.

Has anyone faced a similar issue or could provide guidance on how to achieve this? Any help would be greatly appreciated!

Thank you!

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

From the information, I understand that you are using the "BigQuery Data Transfer Service for Google Ads connector" to fetch the performance metrics of individual headlines for an App campaign. 

Note that your concern is out of scope for the Google Ads API support team, as our team can only help you with technical queries or concerns related to direct interaction with the Google Ads API.

So, I would recommend you reach out to the GCP Product support team, as they are better equipped to assist you on this. I hope this clarifies.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vGfuR:ref" (ADR-00272620)

Thanks,
 

Google Ads API Team