How to get the product count of any shopping campaign ?

[Faizan Zulfiqar]

Hi

Please tell me how can I retrieve all the products of any campaign or product count of any campaign?

[Google Ads API Forum Advisor Prod]

Hi Faizan,

Thanks for reaching out. You could use the Shopping Performance report to retrieve the products of a campaign if you specify the CampaignId in the WHERE clause. The campaign statistics aggregated at the product (OfferId field) level. You could retrieve the fields that you are interested in by specifying them in the SELECT clause. Please let me know if you have any further concerns.

Thanks and regards,
Xiaoming, Google Ads API Team

 

ref:_00D1U1174p._5001UV0QuU:ref

[Faizan Zulfiqar]

Hi Xiaoming,

I have used the same method but the products I am getting not matching with the number of products showing when hovering on product groups. I am attaching the screenshot for your reference.

Kindly tell me what am i doing wrong 
Thank you

[Google Ads API Forum Advisor Prod]

Hi Faizan,

If you see any discrepancies between the report metrics and data from the UI, could you please send us both screenshots as long as the report definition and the client customer Id via the Reply privately to author option? All I can see now is one screenshot with the product data.

Thanks and regards,
Xiaoming, Google Ads API Team

 

ref:_00D1U1174p._5001UV0QuU:ref

[Faizan Zulfiqar]

Hi

I have sent you private message and waiting for the reply.

[Google Ads API Forum Advisor Prod]

Hi Faizan,

I have replied to your last query but I don’t know for what reason you did not receive it. After you login in your manager account, select the customer account 916-976-0035 and then click on the Ad groups tap on the left hand side and then select the Ad Group #5d42e59327088 and then on the right top corner select the last 30 days for the date range. When you hover on the m3 group you would be able to see the product data. If you still see the discrepancies please contact the Product team for further assistance as this is Google Ads UI related issue. You could login in your account and navigate to ? -> Get help to raise the concerns on this issue.

Thanks and regards,
Xiaoming, Google Ads API Team

 

ref:_00D1U1174p._5001UV0QuU:ref