Hi, I'm running google ads shopping campaigns for a company. I want to download ads performance data for all the products uploaded via Google Merchant Center and are eligible for ads. I need the data in the product level. The data should include performance metrics like impressions, clicks, cpc, etc. product attributes like item id, title, link, price, etc. ad group, campaign name, and some other data. And I need to do this using Google Ads API. I've already set up the API(v6) and executed
get_campaign script successfully. So, is it doable? If it is, can you help me with the valid
Google Ads Query Language. And, if it's not doable, how can I get the data that fulfils my requirement to some extent? Please help. Thanks in advanced.