Hub/Analytics/Analyze Revenue by Channel
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