Retrieve all the products from the Google Adwords with Conversion details

[Rukesh Prajapati]

Hello all,

I am working with Google Ads API (https://developers.google.com/google-ads/api/docs/client-libs/php).
My goal is to retrieve all the product info from my google Adwords(https://prnt.sc/T7jUz9nZ7fIm).

I need all products with its name, id, clicks, conversions, costs etc.

I tried to retrieve those with below query:

SELECT  segments.product_item_id,  segments.product_title,  metrics.clicks,  metrics.cost_micros,  metrics.impressions,  metrics.conversions,  metrics.all_conversions FROM  shopping_performance_view WHERE segments.date DURING LAST_30_DAYS

I could get the product info. However, I need info from ALL_TIME instead of LAST_30_DAYS. How do I do that?
I guess All_TIME is not supported here in google ads api. It only exists in Adwords API(deprecated).


Also, I received only limited number of products. Not all product were there.


How could I retried all products from ALL_TIME?

Is my query above correct approach to get products? Or, is there another way for it?

Regards,
Rukesh

[Google Ads API Forum Advisor]

Hi Rukesh,

Thank you for raising this concern to the Google Ads API Forum. 

To answer your questions in general, you may try to remove the date filter because the data defaults to all when no date filter is set. Let me know what goes after.

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2bmHuL:ref