all_coversions_value in shopping_performance_view

[Vk Kv]

Hello, trying to select all_conversions_value in shopping_performance_view, however, it throws an error, that field is not selectable. Tried both in GAQL and directly through API. 
GAQL traceback and screenshot from documentation on  shopping_performance_view. Any help appreciated, thanks!

• API Version: v11
• Query: "SELECT segments.product_item_id, metrics.clicks, metrics.impressions, metrics.average_cpc, metrics.search_impression_share, metrics.all_coversions_value, metrics.cost_micros, metrics.all_conversions, metrics.cost_per_all_conversions, metrics.search_absolute_top_impression_share, metrics.all_conversions_value FROM shopping_performance_view"
  
  
• Result: Invalid Query (errors below) 'metrics.all_coversions_value' is not a valid field in the SELECT clause when 'shopping_performance_view' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'.
  
  
• 
  
  

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to our API support team.

Upon checking your Query it seems that you misspelled this query metrics.all_coversions_value and you added two coversions_value with this you may try this query below:

SELECT
 
segments.product_item_id,
 
metrics.clicks,
 
metrics.impressions,
 
metrics.average_cpc,
 
metrics.search_impression_share,
 
metrics.all_conversions_value,
 
metrics.cost_micros,
 
metrics.cost_per_all_conversions,
 
metrics.search_absolute_top_impression_share
 
FROM shopping_performance_view

Also, you can make use of Query Builder to help you construct and validate queries. Let us know if this helps.


Best regards,

Anthony Cyril Google Ads API Team

ref:_00D1U1174p._5004Q2eNe6e:ref