Sort your customers by how many times they've ordered. Look at the first row: one order, then nothing. A huge first row is the ordinary shape of a consumer brand doing fine.

The first row also breaks your averages. In one skincare brand's six-year order file, the blended average customer is worth $142 in lifetime revenue. The top 20% of customers start at $157, so the average customer wouldn't make the top fifth. The median customer bought once. $142 is nobody.

The skincare file, sorted

The skincare file holds 18,319 customers over six years, a file small enough to print. That size is deliberate: you can check every number in it by hand, and so can your finance lead.

Measured. Blended average: $142. The top 20% of customers start at $157.

A customer with two or more orders is worth 5.4 times a one-order customer. Three in four customers sit in the first row and bring in about a third of the revenue. The other quarter brings in two thirds. Because 74% of the file sits in one row, the median customer sits there too, and the mean lands in the gap between two groups that behave nothing alike.

Any average you report about customers belongs beside the two rows it came from. Report it alone and the room will picture a typical customer who doesn't exist.

A mean without a shape is a rumor with a decimal point.

Where the average does damage

The blended average does its damage in one place: your acquisition budget. Put $142 next to your acquisition cost and it looks like headroom. So your team bids harder, widens targeting and accepts worse traffic. Three times out of four, that spend buys a $66 customer who never comes back.

You're running two businesses: a trial business and a repeat business. Bid off the decomposed table, never the average. The same error reaches payback math. A blended lifetime value prices every new customer at $142, when three in four customers in the skincare file were worth $66.

If the first row holds more than half your customers and less than half your revenue, the two businesses need separate math. A file with a small first row can keep buying strangers. A file with a large one has bought most of the strangers it can afford, so its next dollar belongs to the first row.

The returning-customer rate on your storefront dashboard won't warn you. It's an order metric, not a customer metric: it divides the period's buyers who had ordered before by everyone who bought in that period. Cut acquisition and it rises, because the denominator lost its strangers. The rate can climb for two quarters while the file shrinks underneath it.

What the Monday meeting misses

Sit in a Monday growth meeting and watch where the questions go. The media buyer has last week's spend and return by channel, and every number on that screen has a person who will be asked about it. Late in the meeting the founder asks how repeat looks. Someone says the post-purchase flow is live and the open rates are good.

The number that would change that meeting is the share of last quarter's new customers who came back. It sits in the order table, uncomputed, because computing it is on nobody's job description. Acquisition gets a number every week, while the first row gets an anecdote. Bring the two rows into that room and the question moves from whether the flow is live to what the first row is worth.

Pull the two rows

Work from the order table, net of refunds and cancellations, never from a dashboard report. The pull is in For Your Analyst.

Sort by order count, never by dollars. The two populations separate on frequency, and spend follows from it. A dollar band lumps a one-time buyer who bought a big bundle in with a regular who buys small, and it hides the row you need to price.

An afternoon if your customer IDs are clean; a few days if they aren't. Resolve identity first either way. One customer split across two email addresses reads as two one-time buyers, which inflates the first row and shrinks the second. Match on customer ID, then normalized email, then phone, so every person is counted once.

Read the first row's share only for customers old enough to have had a fair chance to come back. Last month's buyers haven't had one, and counting them makes the first row look worse than it is.

Do this

• Export your orders. Count orders per customer and write two rows, bought once and bought two or more, with customers, share and average lifetime revenue.
• Price the first row before you buy another stranger.