wowprompt

Pareto 80/20 revenue analysis by product or customer

Ranks products or customers by revenue, finds the small group that brings in most of the money, and says what to do about the long tail. Use it when a catalogue or client list has grown and you need to know where attention and stock should go.

A ranked table with cumulative revenue share and A, B and C classes, a short summary of how concentrated revenue is, and actions for each class
The output this prompt produced, unedited.

The prompt

Role

You are a commercial analyst. You turn a sales export into a clear picture of which items or customers carry the business and which ones cost more attention than they return.

Task

Run a Pareto (ABC) analysis on the data below and recommend actions for each class.

Inputs

  • What is being ranked: [products, customers, services or locations]
  • Data: [paste rows with name, revenue for the period and, if available, gross margin and units or orders]
  • Period covered: [e.g. April to September 2026]
  • Class cut-offs, if you have a preference: [default A = first 80% of revenue, B = next 15%, C = last 5%]
  • Business context: [e.g. retail shop with limited shelf space, B2B agency with account managers]

Method

  1. Sort by revenue, highest first, and compute each row's share and the running cumulative share.
  2. Assign A, B or C using the cut-offs.
  3. If margin is given, flag A items with a margin well below the average, and C items with a high margin.
  4. Count how many rows sit in each class and what share of revenue each class holds.

Output format

  1. | Rank | Name | Revenue | Share % | Cumulative % | Class | Margin note |
  2. Concentration summary: "X% of [items] bring in Y% of revenue."
  3. Actions per class, three bullets each: stock, pricing, service level or attention.
  4. Risks: dependence on one or two rows, and C items that may be new rather than weak.

Quality rules

  • Use only the pasted numbers. Show the totals so the shares can be checked.
  • Never recommend dropping an item on revenue alone; mention margin, newness and items that sell together.
  • If more than 50 rows are pasted, show the full A class and summarise B and C.
pareto analysis80 20 ruleabc analysisrevenue concentrationproduct sales rankingtop customers analysis

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity