Fill in before sending
[Google Ads account][30]
Use my Opus Growth connection for this. If you cannot see the tool you need, search among the Opus Growth tools (with search_tools if it is in your list); if you cannot reach the tools at all, do not guess, tell me.
I want to review my Google Ads account [Google Ads account] and my Merchant Center account together, product by product. Only read, do not change anything.
1. Check that the Merchant Center account is linked to this Google Ads account. If it is not, stop and tell me.
2. Pull the last [30] days of product-level results from Google Ads: cost, clicks, conversions and conversion value by product ID in Shopping and Performance Max campaigns (shopping_performance_view, segments.product_item_id).
3. List the Merchant Center products with their status and match them by product ID. Ignore upper and lower case when matching. If the same product ID exists in more than one country, combine it into one row and show the status per country separately.
4. Build one table: product, Merchant Center status, price, cost, conversions, conversion value, ROAS.
5. Make three lists: products that spend money without any conversions, products that convert well but get little spend, and products that cannot show in ads because they are disapproved. List the limited products separately: open their details and say in which country they have an issue in Shopping ads.
Show amounts in the account currency. Cost (metrics.cost_micros) is in micros, divide it by 1,000,000. Conversion value (metrics.conversions_value) is already in currency units, do not divide it.