API Reference

Google Merchant Center / API Reference

merchant_report

Merchant Center tool. Run a Merchant Center report query (MCQL) and return its rows. MCQL is SQL-like, one table per query: SELECT ... FROM ... WHERE ... ORDER BY ... LIMIT. Performance tables need a date range, e.g. WHERE date BETWEEN '2026-08-01' AND '2026-08-31'. Only AND (no OR). Tables include product_performance_view, product_view, price_competitiveness_product_view, price_insights_product_view, best_sellers_product_cluster_view, best_sellers_brand_view, competitive_visibility_competitor_view, non_product_performance_view. Example: SELECT offer_id, title, clicks, impressions FROM product_performance_view WHERE date BETWEEN '2026-08-01' AND '2026-08-31' ORDER BY clicks DESC LIMIT 20 Args: account_id: Merchant Center account id. query: The MCQL query. max_rows: Maximum rows across pages. Default 1000.

This is a read-only tool: it returns merchant report for your Google Merchant Center account. It changes nothing.

Ask Claude

You do not call this tool yourself. Ask for the outcome and the client picks the tool:

Merchant report in my Google Merchant Center account for [query].

It takes 2 required and 1 optional parameter.

Parameters

ParameterTypeRequiredDescription
account_idstringYesAccount Id
querystringYesQuery
max_rowsintegerNoMax Rows

Related Google Merchant Center tools

Before you can call it

This tool needs a connected Google Merchant Center account. The Google Merchant Center connect guide covers how to authorize it and what it unlocks, and the quickstart gets a client talking to the server in about five minutes.

Start free — 30 tool calls a month

No card required. Connect Google Ads, Meta Ads, GA4 or Search Console and ask Claude for the outcome — it picks the tool.