Customer profiling and segmentation: counts and economics

Customer profiling and segmentation start with a rule that assigns customers to groups, followed by a table describing each group's economics. Use customer counts, net revenue, contribution, and product mix from recorded sales and costs. Keep the membership list so every profile can be rebuilt.

A profile should help a business decide where to review service effort, commercial terms, or category coverage. It should not turn a small sales history into an invented persona. The useful deliverable is a reproducible summary with a clear denominator.

Define the group before describing it

Choose one decision and one observation period. For example, a US distributor wants to compare customers with an active service agreement against spot buyers during September 2026. Its primary segmentation rule is Contract for an agreement active on September 1, 2026, and Spot otherwise.

That rule comes from a verified account attribute. It is not inferred from the amount a customer spent. Keep the rule fixed during this comparison; review customers whose agreements change separately.

The broader method for B2B customer segmentation from ledger records covers choosing groups. Here the task is the quantitative profile produced after membership is settled. If the rule uses recorded purchasing actions instead, behavioral segmentation owns that definition.

Prepare the sales and cost rows

Use a stable customer ID, invoice ID, date, product category, net revenue, product cost, and separately recorded variable service cost. Bring the agreed segment attribute from the account list. Investigate any customer with missing or conflicting membership before publishing the profile.

Revenue should reflect returns and allowances consistently. The IRS describes net receipts as gross receipts less returns and allowances. Use finance's approved period and allocation policy for the management comparison; the profile is not a substitute for financial statements.

These illustrative September rows occupy A2:G8 on a Sales sheet. Each invoice has one product category. All amounts are USD. Variable service cost is incremental delivery and handling cost in this example, separate from product COGS.

Build one row per customer

On a Customers sheet, list P01:P04 once in A2:A5, with the verified segment in B. Use C for revenue, D for COGS, E for variable service cost, F for contribution, and G for category A revenue.

In Google Sheets, SUMIFS adds values matching the specified criteria. The formulas below use customer ID for the totals and customer ID plus category for the mix numerator. Covirage is not affiliated with Google.

C2 =SUMIFS(Sales!$E$2:$E$8,Sales!$B$2:$B$8,A2)
D2 =SUMIFS(Sales!$F$2:$F$8,Sales!$B$2:$B$8,A2)
E2 =SUMIFS(Sales!$G$2:$G$8,Sales!$B$2:$B$8,A2)
F2 =C2-D2-E2
G2 =SUMIFS(Sales!$E$2:$E$8,Sales!$B$2:$B$8,A2,Sales!$D$2:$D$8,"A")

Fill down. The resulting customer rows are:

Contribution here is revenue minus the two stated cost categories. Fixed sales salaries, rent, and corporate costs remain outside it. Do not call the result net profit.

Produce the segment profile

Create a Profile sheet with Contract and Spot in A2:A3. Use B for customer count, C for revenue, D for contribution, E for contribution margin, F for category A revenue, G for category A mix, and H for revenue per customer.

COUNTIFS counts matching records, so count the customer rows, not the invoice rows:

B2 =COUNTIFS(Customers!$B$2:$B$5,A2)
C2 =SUMIFS(Customers!$C$2:$C$5,Customers!$B$2:$B$5,A2)
D2 =SUMIFS(Customers!$F$2:$F$5,Customers!$B$2:$B$5,A2)
E2 =IF(C2=0,"",D2/C2)
F2 =SUMIFS(Customers!$G$2:$G$5,Customers!$B$2:$B$5,A2)
G2 =IF(C2=0,"",F2/C2)
H2 =IF(B2=0,"",C2/B2)

Percentages are rounded to one decimal after calculation. Contract contribution margin is 450 / 1,500 = 30.0%; its category A mix is 1,000 / 1,500 = 66.7%. Both groups have $750 revenue per customer, but the cost and product profiles differ.

The reconciliation is explicit: 1,500 + 1,500 = $3,000 revenue; 450 + 300 = $750 contribution; and 1,000 + 200 = $1,200 category A revenue. Independently, 3,000 - 1,800 - 450 = $750 contribution. Total margin is 750 / 3,000 = 25.0%, calculated from totals.

Turn the profile into a review

The example supports reviewing variable service effort in the Spot group and checking category coverage. It does not prove that changing a contract would change purchasing, or that every spot buyer has unmet category A demand. Inspect the customer rows and ask the account owner before proposing an action.

Add recency and order frequency only when the decision needs them; RFM analysis covers that separate ranking. For shopper histories across locations and channels, use the retail customer segmentation workflow.

Where profiles go wrong

• Counting invoices as customers. Customers with more invoices then dominate the apparent group size.
• Using overlapping groups in a total. One primary membership per customer makes the profile additive; overlapping tags require separate presentations.
• Calling missing costs zero. Keep uncosted sales visible and withhold contribution comparisons until coverage is understood.
• Changing periods or cost definitions. The same segment name does not make unequal observation windows comparable.
• Inferring motives from purchases. Product mix describes recorded revenue, not personality or future demand.

Build your own customer profile in Covirage

Bring a sample of your own customer list, sales export, and matched cost records with stable IDs and explicit segment attributes. Covirage maps the columns, its tools compute and check the group economics, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring your own file.

See sales insights for the supporting commercial context.