Analytics
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
analytics
customers
Report Customer Concentration Risk
Show what share of total revenue comes from the top handful of customers, to flag over-reliance on a small buyer base.
📋 Prompt
Report how concentrated my revenue is among top customers, using orders from [LAST 12 MONTHS]. What to calculate: Total revenue from the top 1% of customers by spend Total revenue from the top 5% of customers by spend Total revenue from the top 10% of customers by spend Each as a % of total store revenue List of the top 20 individual customers by lifetime spend, with their total spend and order count Risk check: Is any single customer responsible for more than [5]% of total revenue in the period? (Meaningful concentration risk if a wholesale/B2B buyer is mixed into consumer revenue) How has the top-10% revenue share trended over the last [4] quarters — is the business becoming more or less dependent on a small group of high spenders? Output format: Summary block: top 1% / 5% / 10% revenue share Table: top 20 customers, lifetime spend, order count, % of total revenue Trend line of top-10% share by quarter Deliverables: All of the above A plain read on the risk level: is this a healthy broad customer base, or is a meaningful chunk of revenue exposed to a handful of accounts that could churn?
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