Help to retrive product statistics from google ads api in GAQL

[Denil Nicolosi]

Hi, 
I'm trying to get some information that I can see in the report section of google ads. Specifically, like the attached figure, I would like to get the information "QI persa rete di ricerca(budget)" which should be called "metrics.search_budget_lost_absolute_top_impression_share" for each product.
I've explored the "campaign", "product_group_view" and "shopping_performance_view" tables but I can't get this data by product.
I have used the interactive query builder and table reference documentation but there is no connection to the metrics in question and the shopping product.
Thanks for the support

[Google Ads API Forum Advisor]

Hi Denil,

Thanks for reaching out to Google Ads API Forum.

Please note that Google Ads API mirrors the Google Ads UI. Meaning by using the Google Ads API, you can get and manage the data that you are seeing in the UI. 

With that being said, can you provide us with the full (not cropped) and non-redacted screenshot of the Google Ads UI data that you want to retrieve in Google Ads API? This is for us to be able to perform and to replicate the data on our side.

You may then send the requested information via the Reply privately to the author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Links included in this email:

• Google Ads API - https://developers.google.com/google-ads/api/docs/start 

Regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2kpckX:ref