shopify_custom_query
Execute custom ShopifyQL queries to analyze sales, orders, customers, sessions, and marketing data when pre-built tools don't meet specific metric requirements.
Instructions
Run a custom ShopifyQL query for advanced analytics. Use this when the pre-built tools don't cover your specific metric needs. Available tables: sales, orders, customers, sessions, shop_campaign_insights.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | A valid ShopifyQL query. Example: FROM sales SHOW total_sales, net_sales GROUP BY product_type SINCE -30d ORDER BY total_sales DESC LIMIT 10 |