Reporting

Combine Merchant Center products with Google Ads Shopping and Performance Max results

Puts each product's Google Ads cost, conversions and ROAS next to its Merchant Center status and price, and separates the products that spend without converting from the ones that cannot show because they are disapproved.

When to use it

When you want to see which products spend money without selling in Shopping or Performance Max, and which ones never show because of a Merchant Center issue.

What you get

A product table with Merchant Center status next to Google Ads results, and three action lists.

Does it change anything in my account?

No. The assistant only reads your data and reports back.

Works with

Merchant Center, Google Ads

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.

Related searches

These prompts work best when your AI assistant is connected to your accounts with Opus Growth.

Connect your accounts free

More prompts

ReportingRead-only

Build a monthly scorecard of your brand's visibility in AI answers and compare it with last month

Measures the same question set in ChatGPT, Perplexity and Gemini every month, checks whether you are cited in Google's AI answers, and combines this with AI referrals in GA4 and brand searches in Search Console. States measurement noise and tool limits openly.

When to use itYou want to track your visibility in AI search every month on the same yardstick, not just once, and see whether your work is paying off.

SEO Intelligence, GA4, Search Console
ReportingRead-only

List your most-clicked products on Google and the ones with no impressions

Reads product performance in free listings and Shopping ads and separates the most-clicked products, the ones with no recorded conversions and the approved products that got no impressions at all in the period.

When to use itWhen you want to know which Merchant Center products get clicks on Google and which ones never show.

Merchant Center
ReportingRead-only

Measure conversion lag before you judge the last few days

Works out, per campaign, how many days after the click conversions are recorded, estimates how incomplete the last few days still are and says whether a bidding decision should wait.

When to use itWhen conversions look down over the last few days and you want to know whether late-arriving conversions explain it before you touch bids or budgets.

Google Ads
ReportingChanges after your approval

Monthly paid channel efficiency ranking with a budget split proposal

A ranking of every paid channel by cost per conversion, with spend share vs conversion share and a proposed budget split for next month.

When to use itWhen a new month is starting and you need to decide which paid channels deserve more or less budget.

Google Ads, Meta Ads, TikTok Ads