Unable to retrieve "Conversions (by conv. time)" and "Conv. value (by conv. time)" in shopping_performance_view.

[TOM]

I want to generate a report as shown in the image below, but I am unable to retrieve Conversions (by conv. time) and Conv. value (by conv. time) because there are no available metrics to use.  

This is my query.

SELECT
shopping_performance_view.resource_name,
segments.product_merchant_id,
segments.product_item_id,
segments.product_feed_label,
metrics.clicks,
metrics.cost_micros,
metrics.impressions
FROM shopping_performance_view
WHERE segments.date BETWEEN '%s' AND '%s'
ORDER BY metrics.clicks DESC

 Please help me. What should I do?  

Thank you in advance.

[Google Ads API Forum Advisor]

Hi,

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

I would suggest you to check this document to map the user interface metrics to the Google Ads API. Note that the retrieval of the metrics metrics.conversions_by_conversion_date and metrics.conversions_value_by_conversion_date from the shopping_performance_view is not yet supported in the Google Ads API. However, I will raise a request to add these metrics to be available in the Google Ads API. We cannot provide a scheduled timeline for the availability of this feature in the Google Ads API. I would recommend you to follow our release notes and blog post for future updates.

Thanks,
 

Google Ads API Team

Feedback
How was our support today?

               
[2025-03-04 11:16:28Z GMT] This message is in relation to case "ref:!00D1U01174p.!5004Q02vH5te:ref" (ADR-00291301)

[TOM]

Thank you for your response.

I hope that shopping_performance_view will support metrics.conversions_by_conversion_date and metrics.conversions_value_by_conversion_date soon.

I also tried using the campaign report.
Here is the query I tested:

SELECT
campaign.id,
campaign.name,

segments.product_merchant_id,
segments.product_item_id,
segments.product_feed_label,
metrics.clicks,
metrics.cost_micros,

metrics.impressions,
metrics.conversions_by_conversion_date,
metrics.conversions_value_by_conversion_date
FROM campaign

However, it did not pass the validator, even though there are available segments listed in this documentation:
Google Ads API Fields - Campaign

Why is this happening?

We can use other reports instead, as long as the results are as shown in the attached image.

[Google Ads API Forum Advisor]

Hi,

I would like to inform you that even though the fields that you have provided (segments.product_merchant_id, segments.product_item_id, and segments.product_feed_label) in the given GAQL query are present under the segments list in the campaign report, all the mentioned fields in the campaign report are not compatible. To know the list of compatible fields for which we can retrieve the data via the API, you can apply a filtering condition to the statement 'Is campaign specified in the FROM clause of your query?' which is present under the Fields/Segments/Metrics, and then set the drop-down to 'Yes, it is' which will list down all the compatible fields in the campaign report.

Also, the fields that can be added in the select clause while building a query using the campaign report are considered as all the supported fields in the campaign resource via the Google Ads API. 

I hope this helps! Feel free to get back to us in case of any further queries.

Thanks,
 

Google Ads API Team

Feedback
How was our support today?

               

[2025-03-05 03:58:55Z GMT] This message is in relation to case "ref:!00D1U01174p.!5004Q02vH5te:ref" (ADR-00291301)