requesting data for product listing ads from 'ad_group_ad' view

[Subhash]

Hi There

Prior to migration we were able to request ad level data for product listing ads from the AD_PERFORMANCE report type.

Now that we have migrated the 'ad_group_ad' view does not seem to return data for product listing ads, among other ad types.

The API query I am using is below. Can you please advise?

Best,

Max

--

SELECT campaign.name, ad_group.name, ad_group_ad.ad.text_ad.headline, ad_group_ad.ad.text_ad.description1, ad_group_ad.ad.call_ad.description1, ad_group_ad.ad.text_ad.description2, ad_group_ad.ad.call_ad.description2, ad_group_ad.ad.display_url, ad_group_ad.ad.id, ad_group_ad.ad.type, ad_group_ad.status, segments.ad_network_type, ad_group.status, campaign.status, metrics.impressions, metrics.clicks, metrics.ctr, metrics.cost_micros, ad_group_ad.ad.id, segments.slot, segments.device, segments.keyword.ad_group_criterion, ad_group_ad.ad.device_preference, ad_group_ad.ad.final_mobile_urls, ad_group_ad.ad.final_urls, ad_group_ad.ad.tracking_url_template, ad_group_ad.ad.url_custom_parameters, ad_group_ad.labels, ad_group_ad.ad.expanded_text_ad.headline_part1, ad_group_ad.ad.expanded_text_ad.headline_part2, ad_group_ad.ad.expanded_text_ad.description, ad_group_ad.ad.legacy_responsive_display_ad.description, ad_group_ad.ad.expanded_dynamic_search_ad.description, ad_group_ad.ad.expanded_text_ad.path1, ad_group_ad.ad.expanded_text_ad.path2, ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.responsive_search_ad.descriptions, ad_group_ad.ad.responsive_search_ad.path1, ad_group_ad.ad.responsive_search_ad.path2, ad_group_ad.ad.expanded_text_ad.headline_part3, ad_group_ad.ad.expanded_text_ad.description2, ad_group_ad.ad.final_url_suffix FROM ad_group_ad WHERE metrics.impressions > 0 AND segments.date BETWEEN '2022-05-15' AND '2022-05-15' PARAMETERS omit_unselected_resource_names = true

--

[Google Ads API Forum Advisor]

Hello Subhash,

Thanks for reaching out to the Google Ads API forum. With regards to your concern, for pulling the report for product performance level you may use the product_group_view resource. 

Could you please confirm if that is what you are looking for? If not then for better understanding, could you please share the complete logs of the report from in AdWords API or share the specific fields name which one you were expecting on Ads API?
Please send the requested details via the Reply privately to the author option. If this option is not available, you may send the details directly to our googleadsapi-support@google.com alias by referring to this thread. Let me know if you have any questions.

Best regards,

Jakeia Sabrina Google Ads API Team

 

ref:_00D1U1174p._5004Q2YbuTd:ref

[Google Ads API Forum Advisor]

Hi Max,

Thanks for getting back to us.

You may use ad_group_ad report to get data related to 'Shopping Ad'. You may use below simple GAQL and see if you able to see expected data:

SELECT campaign.name, ad_group.name, 
ad_group_ad.ad.text_ad.headline, ad_group_ad.ad.text_ad.description1, 
ad_group_ad.ad.call_ad.description1, ad_group_ad.ad.text_ad.description2,
ad_group_ad.ad.call_ad.description2, 
ad_group_ad.ad.display_url, 
ad_group_ad.ad.id

, ad_group_ad.ad.type, ad_group_ad.status, 
ad_group.status, campaign.status, metrics.impressions, 
metrics.clicks, metrics.ctr, metrics.cost_micros, 
ad_group_ad.ad.device_preference, ad_group_ad.ad.final_mobile_urls, 
ad_group_ad.ad.final_urls, ad_group_ad.ad.tracking_url_template, 
ad_group_ad.ad.url_custom_parameters, ad_group_ad.labels, 
ad_group_ad.ad.expanded_text_ad.headline_part1, 
ad_group_ad.ad.expanded_text_ad.headline_part2, 
ad_group_ad.ad.expanded_text_ad.description, 
ad_group_ad.ad.legacy_responsive_display_ad.description, 
ad_group_ad.ad.expanded_dynamic_search_ad.description, 
ad_group_ad.ad.expanded_text_ad.path1, 
ad_group_ad.ad.expanded_text_ad.path2, 
ad_group_ad.ad.responsive_search_ad.headlines, 
ad_group_ad.ad.responsive_search_ad.descriptions, 
ad_group_ad.ad.responsive_search_ad.path1, 
ad_group_ad.ad.responsive_search_ad.path2, 
ad_group_ad.ad.expanded_text_ad.headline_part3, 
ad_group_ad.ad.expanded_text_ad.description2,
 ad_group_ad.ad.final_url_suffix, 
ad_group_ad.ad.shopping_comparison_listing_ad.headline, 
ad_group_ad.ad.shopping_product_ad, ad_group_ad.ad.shopping_smart_ad 
FROM ad_group_ad 
WHERE metrics.impressions > 0 AND segments.date = '2022-05-15'

If you’re still unable to see, you may privately provide us the complete Ads UI screenshot showing expected data along with the customer ID, so that we can check better.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2YbuTd:ref

[Google Ads API Forum Advisor]

Hi Sabhash,

Thank you for your patience.

Let me reiterate the response of my colleague Yassar response, which you can see below:

Hi Max,

Thanks for getting back to us.

You may use ad_group_ad report to get data related to 'Shopping Ad'. You may use below simple GAQL and see if you able to see expected data:

If you’re still unable to see, you may privately provide us the complete Ads UI screenshot showing expected data along with the customer ID, so that we can check better.

SELECT campaign.name, ad_group.name, 
ad_group_ad.ad.text_ad.headline, ad_group_ad.ad.text_ad.description1, 
ad_group_ad.ad.call_ad.description1, ad_group_ad.ad.text_ad.description2,
ad_group_ad.ad.call_ad.description2, 
ad_group_ad.ad.display_url, 
ad_group_ad.ad.id, ad_group_ad.ad.type, ad_group_ad.status, 
ad_group.status, campaign.status, metrics.impressions, 
metrics.clicks, metrics.ctr, metrics.cost_micros, 
ad_group_ad.ad.device_preference, ad_group_ad.ad.final_mobile_urls, 
ad_group_ad.ad.final_urls, ad_group_ad.ad.tracking_url_template, 
ad_group_ad.ad.url_custom_parameters, ad_group_ad.labels, 
ad_group_ad.ad.expanded_text_ad.headline_part1, 
ad_group_ad.ad.expanded_text_ad.headline_part2, 
ad_group_ad.ad.expanded_text_ad.description, 
ad_group_ad.ad.legacy_responsive_display_ad.description, 
ad_group_ad.ad.expanded_dynamic_search_ad.description, 
ad_group_ad.ad.expanded_text_ad.path1, 
ad_group_ad.ad.expanded_text_ad.path2, 
ad_group_ad.ad.responsive_search_ad.headlines, 
ad_group_ad.ad.responsive_search_ad.descriptions, 
ad_group_ad.ad.responsive_search_ad.path1, 
ad_group_ad.ad.responsive_search_ad.path2, 
ad_group_ad.ad.expanded_text_ad.headline_part3, 
ad_group_ad.ad.expanded_text_ad.description2,
ad_group_ad.ad.final_url_suffix, 
ad_group_ad.ad.shopping_comparison_listing_ad.headline, 
ad_group_ad.ad.shopping_product_ad, ad_group_ad.ad.shopping_smart_ad 
 
FROM ad_group_ad 
 
WHERE metrics.impressions > 0 AND segments.date = '2022-05-15'

This code is solved by locating your ad_group_ad report to get data related to 'Shopping Ad' and retrieving it using a modify query. Did you take these steps? If so, can you please send us your UI screenshot to verify the data that you are expecting, as well as your logs or cid, so that we can assist you even further and verify the issue?

Please let me know if you have further concerns, and our team will be happy to provide support


Best,

Anthony Cyril Google Ads API Team

ref:_00D1U1174p._5004Q2YbuTd:ref