Merchant Center report query
merchant_report_queryRun Merchant Center reports with MCQL queries to check product status or free-listing performance and retrieve raw result rows.
Instructions
Run a Merchant Center report (Merchant API reports:search) with an MCQL query, for example product status or free-listing performance. Returns Google's raw result rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | No | Merchant Center Query Language (MCQL) statement. Tables include product_view (must select id) and product_performance_view (clicks, impressions by date or offer) | SELECT id, offer_id, title, aggregated_reporting_context_status FROM product_view LIMIT 50 |