Run an MCQL report query
search_reportsRun MCQL queries to fetch Merchant Center reports on products, performance, pricing, and competitiveness. Filter products by querying product_view.
Instructions
Runs a Merchant Center Query Language (MCQL) query via reports:search. Tables: product_view, product_performance_view, price_competitiveness_product_view, price_insights_product_view, non_product_performance_view, best_sellers_product_cluster_view, best_sellers_brand_view, competitive_visibility_top_merchant_view, competitive_visibility_competitor_view, competitive_visibility_benchmark_view. Rules: field names are snake_case in the query but camelCase in the JSON response; no SELECT ; performance views require a WHERE date range, e.g. SELECT offer_id, clicks, impressions FROM product_performance_view WHERE date BETWEEN '2026-07-01' AND '2026-07-31' ORDER BY clicks DESC. price_ views require the Market Insights opt-in. Each result row has exactly one populated view object. This is also the way to FILTER products (product_view) — list_products has no filter.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | MCQL query, e.g. SELECT offer_id, title, price FROM product_view WHERE availability = 'out of stock'. | |
| account | No | Merchant Center account ID (digits, e.g. "123456"). Omit to use the GOOGLE_MERCHANTS_ACCOUNT_ID default. | |
| page_size | No | Max results per page (1..100000; API default 1000). | |
| page_token | No | nextPageToken from the previous response. All other parameters must be identical to the previous call. |