Unable to pull all conversion by time for product level view

[Apurv Agrawal]

I want to pull data at product id , campaign id level broken down by conversion action for metrics all conv by time. Attached image is what i want to replicate . I have tried using shopping performance view but it doesnt support all conv by time metrics 

[Google Ads API and AdWords API Forum]

Hi,

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

You can use the below query to retrieve the data present in the screenshot using Google Ads API.

SELECT segments.conversion_action, campaign.id, metrics.all_conversions_value, segments.product_item_id, 

metrics.all_conversions, campaign.name FROM shopping_performance_view

I hope this clarifies your concern. Please feel free to reach out to us for the concerns related to Google Ads API.

[Google Ads API and AdWords API Forum]

Hi,

Please be informed that I have removed your response from the forums as it contains the PII information. 

Based on the provided screenshot, I understand that you want to retrieve the All conv. value(by conv. time) and All conv. (by conv. time) columns through the Google Ads API. Please note that it’s not possible to retrieve the All conv. value(by conv. time) and All conv. (by conv. time) columns for product level from the shopping_performance_view resource through the Google Ads API. Kindly note that you can use the campaign resource to retrieve the All conv. value(by conv. time) and All conv. (by conv. time) columns via Google Ads API.

Thanks & Regards,

Google Ads API Team.

On Monday, June 9, 2025 at 1:55:40 PM UTC+5:30 ap...@maino.ai wrote:

Hi Team , my issue is that i want to get all_conversions_value by time . Look at the attached image the above query gives  all_conversions_value  (yellow columns) but i need  all_conversions_value  by time (orange highlighted columns)

[Apurv Agrawal]

Hi Team , 

I tried using the campaign API as per the documentation it says that it supports product id segments but when i am building query in GAQL on campaign , the product id is not supported in segments ?

[Google Ads API and AdWords API Forum]

Hi,

The reason you are experiencing the 'product_item_id' is not a valid field in the SELECT clause when "Campaign'' is the resource in the FROM clause is because the product_item_id is not a selectable and not valid field from the campaign resource. To know the supported fields, I would suggest to enable the 'Yes,it is' in the Fields/Segments/Metrics.

Regarding your concern to retrieve the All conv. value(by conv. time) and All conv. (by conv. time) columns through the Google Ads API, as informed earlier it’s not possible to retrieve the All conv. value(by conv. time) and All conv. (by conv. time) columns for product level from the shopping_performance_view resource through the Google Ads API. However, I will raise a request for this feature to be available in the Google Ads API. I cannot provide a scheduled timeline for the availability of this feature in the API. I would recommend you to kindly follow our Release Notes and Blog post for future updates.