merchant_report

com.ecomdly/ecomdly · Verify this server

Merchant 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.