How to get product counts for Smart Shopping Ad

[Bat-Ochir Enkhbaatar]

How to get product counts for Smart Shopping Ad using GoogleAdsAPI ?

There is conversation about this, but it recommended to use Shopping Performance report of AdWords API. I want to use GoogleAdsAPI only.

Thank you,

Bat

[Google Ads API Forum Advisor]

Hello Bat,

Thank you for reaching out to us.

In the Google Ads API's perspective, you can get product counts by using the shopping_performance_view and utilize this segment field (segments.product_item_id).

Regards,

Mark Kevin Albios Google Ads API Team

ref:_00D1U1174p._5004Q2NSKdC:ref

[Google Ads API Forum Advisor]

Hi Bat-Ochir,

I work with Mark and will assist you. I had to delete your last post as it contained logs. Here is a redacted version:


Thank you for your support.


I tried  shopping_performance_view  but no success. Could you help to build correct query?

 I am getting empty results for all my queries. For example:

SELECT shopping_performance_view.resource_name FROM shopping_performance_view

SELECT segments.product_type_l1, campaign.id, ad_group.id FROM shopping_performance_view WHERE customer.id = 1684984350 AND campaign.id = 14527668859 AND ad_group.id = 121937616370

SELECT campaign.id, ad_group.id, segments.product_item_id FROM shopping_performance_view WHERE customer.id = 1684984350 AND campaign.id = 14527668859 AND ad_group.id = 121937616370


This is my product group in Ads manager. I want to get same data in popup.



Attaching AdGroup info for reference


There's a good reason nothing is returned, according to Excluding zero impressions by segmenting zero impressions are always excluded when segmenting a report, provided all metrics are zero. All metrics are 0 in your case, hence with segmenting nothing is returned.

The issue is that "SELECT shopping_performance_view.resource_name FROM shopping_performance_view" also doesn't return anything. I reproduced this behavior and will raise it with my team. We will get back to you as soon as possible.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2NSKdC:ref