Analytics
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
analytics
b2b
Report Wholesale and B2B Order Share
Separate B2B/wholesale company orders from consumer orders to see how much revenue, margin, and volume each channel contributes.
π Prompt
Split revenue and order volume between B2B/wholesale (company account) orders and regular consumer orders for [LAST 90 DAYS]. Per channel: Order count Revenue % of total revenue AOV Average gross margin % (using cost-per-item), since B2B pricing usually runs thinner margin than consumer Top 5 products by revenue within each channel B2B-specific detail: Top 10 company accounts by revenue in the period % of B2B revenue from repeat company orders vs a companyβs first order Average order size for B2B vs consumer Output format: Table: channel, orders, revenue, % of total, AOV, avg margin % Top-10 company accounts table Deliverables: Both tables A clear comparison of unit economics between the two channels β which one drives more revenue vs which one drives more margin dollars β since those can point in different directions and change how much sales effort each channel deserves
How to Use
- 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