Task IntentAnalytics
Analyze Revenue by Channel
Break down revenue attribution across all sales channels including online store, POS, social commerce, and marketplaces.
What This Sidekick Query Does
Break down revenue attribution across all sales channels including online store, POS, social commerce, and marketplaces.
Prompts
Copy, adapt, and run this directly in Shopify Sidekick.
Analyze revenue across all my Shopify sales channels: Channels to Analyze: Online Store (direct website) Shopify POS (if applicable) Shop App Instagram Shopping Facebook Shop Google Shopping Amazon / other marketplaces (if connected) Wholesale / B2B channel Buy Button (embedded on external sites) Per Channel Metrics: Total revenue and % of total Number of orders Average order value Conversion rate Customer acquisition cost (if ad spend known) Profit margin after channel fees Growth rate vs previous period Cross-Channel Analysis: Which channels are growing fastest? Which channels have highest AOV? Which channels drive highest customer lifetime value? Channel overlap: do customers buy across multiple channels? Revenue concentration risk (what if top channel drops 50%?) ShopifyQL Queries: Provide ready-to-use ShopifyQL queries for: Revenue by channel for any date range Order count by channel by month AOV trends by channel Recommendations: Channels to invest more in (high ROI) Channels to reduce spend on (low ROI) New channels to consider adding Channel-specific optimization tips
Expected Output
Break down revenue attribution across all sales channels including online store, POS, social commerce, and marketplaces.
Tips to Improve Results
Copy the prompt above
Open Shopify Sidekick in your Shopify admin
Paste the prompt and replace the bracketed placeholders with your details
Review Sidekick's response and apply the suggestions