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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions