Merchant Report
merchant_reportMerchant Center reports with a Merchant Reports query (SQL-like, SELECT only). Tables: product_performance_view (clicks, impressions, click_through_rate, conversions, conversion_value by date, offer_id, title, brand, category_l1…, marketing_method = ORGANIC or ADS; needs a WHERE date BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD'), product_view (current state: id, offer_id, title, price, availability, aggregated_reporting_context_status, item_issues, click_potential), price_competitiveness_product_view (your price vs the benchmark), price_insights_product_view (suggested price and predicted effect), best_sellers_product_cluster_view and best_sellers_brand_view (market best sellers, need report_date and report_granularity). Example: SELECT offer_id, title, clicks, impressions FROM product_performance_view WHERE date BETWEEN '2026-09-01' AND '2026-09-30' ORDER BY clicks DESC LIMIT 20. Returns at most 1000 rows; cite the account and the date range with every number.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | A Merchant Reports SELECT query. | |
| account | No | Google account e-mail to read as, when you have several; an agent reads as the account connected to it. | |
| merchant | Yes | The Merchant Center account id (from merchant_accounts). | |
| next_page | No | The next_page token of the previous answer. |