Free tool
Customer Cohort Profit Calculator
See which customer groups cover acquisition cost and leave contribution behind.
This customer cohort profit calculator compares two acquired-customer groups over the same observation window. Alongside contribution per customer, its One-Time Customer Cost view separates people who purchased once from those who repeated. Enter each buyer group’s observed first-order contribution and explicitly assigned acquisition spend to see cost recovery, the remaining contribution gap or surplus, and the difference between one-time and repeat buyers.
Revenue can make two cohorts look similar while costs and repeat behavior tell a different story. Use the core comparison for matched observation windows, or select the promotion-customer or first-product view for eligible 90-day or 180-day cohorts. The advanced views add first-return customer rates, observed contribution snapshots and tested acquisition-recovery checkpoints. Customer Lifetime Value provides a blended customer view, while Customer Payback focuses on the orders needed to recover acquisition cost.
Observed customer groups · Matched windows · One-time and repeat economics · Optional 90/180-day views
Calculation mode
Use a consistent scope and cost basis for every figure.
The example is illustrative. Replace it with your own figures; results update as you type. Your entries stay in this page until you choose to copy them.
Need help finding your figures in Shopify?
Copy an input checklist for Sidekick. Store reports may not contain every cost or scenario assumption; verify the source and mark missing figures rather than guessing.
Cohort A
Cohort A: observed buyer groups
Cohort B
Cohort B: observed buyer groups
How this tool works
How cohort and buyer-group economics are compared
For each cohort, add first-order contribution and repeat-order contribution, subtract acquisition spend once and divide by acquired customers. The headline compares Cohort A with Cohort B. Within each cohort, entered one-time and repeat-buyer first contributions must sum to total first-order net revenue less variable costs, and their acquisition allocations must sum to total acquisition spend. Repeat buyers also receive the contribution from their repeat orders; the group comparison divides each after-acquisition result by its own customer count.
In the advanced views, select a 90-day or 180-day snapshot and use the same eligible acquired-customer population throughout. Every included customer needs the full selected observation period. The selected cumulative contribution before acquisition must reconcile to the first-plus-repeat totals; acquisition spend is deducted once from each snapshot. The first-return rate divides customers with a first-order return by acquired customers. Returns already reflected in net revenue are not deducted again. First-product ranking uses contribution per customer, and recovery reports only the earliest tested snapshot that covers acquisition spend. Neither establishes causation or an exact payback date.
Contribution per acquired customer = (first-order contribution + repeat-order contribution − acquisition spend) ÷ acquired customers. One-time contribution after acquisition = entered one-time first-order contribution − assigned one-time acquisition spend. Buyer-group gap = repeat-buyer contribution per customer − one-time contribution per customer.
What the average hides about one-time and repeat buyers
Cohort A contains 1,000 customers observed for six months: 700 purchased once and 300 repeated. Its one-time buyers generated $28,000 of first-order contribution before their $14,000 acquisition allocation. That covers all $14,000 of assigned acquisition spend, with none uncovered, and leaves a $14,000 surplus, or $20 per one-time buyer. Repeat buyers generated $12,000 from first orders plus $20,000 from repeat orders. After their $6,000 acquisition allocation, they leave $26,000, or about $86.7 each. The repeat-minus-one-time gap is about $66.7 per customer. Combined contribution is $40,000, or $40 per acquired customer. A matched Cohort B at $33 per customer is $7 lower. The subgroup figures come from entered records and reconcile to totals; they are not distributed in proportion to customer counts. In the 180-day view, entering A’s cumulative pre-acquisition contribution as $45,000 at day 90 and $60,000 at day 180 gives $25 and $40 after acquisition per customer. Day 90 is the earliest tested checkpoint covering its $20,000 acquisition spend; the actual recovery date could be earlier. With 100 first-return customers, the first-return customer rate is 10%.
Your full calculation
| Measure | Result · USD |
|---|---|
| Cohort A: acquired customers | 1,000 |
| Cohort A: repeat customers | 300 |
| Cohort A: one-time customers in window | 700 |
| Cohort A: repeat-customer rate | 30% |
| Cohort A: first-order contribution | $40,000.0 |
| Cohort A: repeat-order contribution | $20,000.0 |
| Cohort A: contribution before acquisition | $60,000.0 |
| Cohort A: acquisition spend | $20,000.0 |
| Cohort A: allocated acquisition cost per acquired customer | $20.0 |
| Cohort A: contribution after acquisition | $40,000.0 |
| Cohort A: contribution per acquired customer | $40.0 |
| Cohort A: acquisition spend covered by positive contribution | $20,000.0 |
| Cohort A: acquisition spend not covered | $0.0 |
| Cohort A: negative operating contribution before acquisition | $0.0 |
| Cohort A: one-time first-order contribution | $28,000.0 |
| Cohort A: one-time allocated acquisition spend | $14,000.0 |
| Cohort A: one-time acquisition cost per customer | $20.0 |
| Cohort A: one-time contribution after acquisitionPositive is surplus after allocated acquisition spend; negative is a shortfall. | $14,000.0 |
| Cohort A: one-time contribution per customer | $20.0 |
| Cohort A: one-time acquisition spend covered | $14,000.0 |
| Cohort A: one-time acquisition spend not covered | $0.0 |
| Cohort A: one-time negative operating contribution before acquisition | $0.0 |
| Cohort A: repeat-buyer first-order contribution | $12,000.0 |
| Cohort A: repeat-buyer total contribution before acquisition | $32,000.0 |
| Cohort A: repeat-buyer allocated acquisition spend | $6,000.0 |
| Cohort A: repeat-buyer acquisition cost per customer | $20.0 |
| Cohort A: repeat-buyer contribution after acquisitionIncludes first and repeat orders within the window; positive is surplus and negative is shortfall. | $26,000.0 |
| Cohort A: repeat-buyer contribution per customer | $86.7 |
| Cohort A: repeat-buyer acquisition spend covered | $6,000.0 |
| Cohort A: repeat-buyer acquisition spend not covered | $0.0 |
| Cohort A: repeat-buyer negative operating contribution before acquisition | $0.0 |
| Cohort A: repeat minus one-time contribution per customerUndefined if either observed buyer group has no customers. Descriptive, not causal. | $66.7 |
| Cohort B: acquired customers | 1,000 |
| Cohort B: repeat customers | 200 |
| Cohort B: one-time customers in window | 800 |
| Cohort B: repeat-customer rate | 20% |
| Cohort B: first-order contribution | $35,000.0 |
| Cohort B: repeat-order contribution | $13,000.0 |
| Cohort B: contribution before acquisition | $48,000.0 |
| Cohort B: acquisition spend | $15,000.0 |
| Cohort B: allocated acquisition cost per acquired customer | $15.0 |
| Cohort B: contribution after acquisition | $33,000.0 |
| Cohort B: contribution per acquired customer | $33.0 |
| Cohort B: acquisition spend covered by positive contribution | $15,000.0 |
| Cohort B: acquisition spend not covered | $0.0 |
| Cohort B: negative operating contribution before acquisition | $0.0 |
| Cohort B: one-time first-order contribution | $28,000.0 |
| Cohort B: one-time allocated acquisition spend | $12,000.0 |
| Cohort B: one-time acquisition cost per customer | $15.0 |
| Cohort B: one-time contribution after acquisitionPositive is surplus after allocated acquisition spend; negative is a shortfall. | $16,000.0 |
| Cohort B: one-time contribution per customer | $20.0 |
| Cohort B: one-time acquisition spend covered | $12,000.0 |
| Cohort B: one-time acquisition spend not covered | $0.0 |
| Cohort B: one-time negative operating contribution before acquisition | $0.0 |
| Cohort B: repeat-buyer first-order contribution | $7,000.0 |
| Cohort B: repeat-buyer total contribution before acquisition | $20,000.0 |
| Cohort B: repeat-buyer allocated acquisition spend | $3,000.0 |
| Cohort B: repeat-buyer acquisition cost per customer | $15.0 |
| Cohort B: repeat-buyer contribution after acquisitionIncludes first and repeat orders within the window; positive is surplus and negative is shortfall. | $17,000.0 |
| Cohort B: repeat-buyer contribution per customer | $85.0 |
| Cohort B: repeat-buyer acquisition spend covered | $3,000.0 |
| Cohort B: repeat-buyer acquisition spend not covered | $0.0 |
| Cohort B: repeat-buyer negative operating contribution before acquisition | $0.0 |
| Cohort B: repeat minus one-time contribution per customerUndefined if either observed buyer group has no customers. Descriptive, not causal. | $65.0 |
| A minus B: contribution per customer over 6 months | $7.0 |
Questions & answers
Understanding your result
What does the One-Time Customer Cost view measure?
It shows the count, observed first-order contribution, assigned acquisition spend and contribution per customer for buyers who purchased once inside the window. It compares that result with repeat buyers using each group’s own entries. One-time buyers may still return later. The result is contribution after the costs entered, before fixed overhead, tax and financing; it is not company net profit.
How are recovered and unrecovered acquisition costs calculated?
The amount covered is positive contribution before acquisition, capped at the acquisition spend assigned to that group. Uncovered acquisition cost is the remainder. Negative operating contribution is shown separately because the full after-acquisition shortfall can exceed acquisition spend. A positive after-acquisition result is a contribution surplus. Enter the observed subgroup contributions and explicit acquisition allocations; the calculator does not distribute cohort averages by customer share.
How do the promotion-customer and first-product views work?
Compare first-promotion customers with non-promotion customers, or two clearly defined first-product or category groups. Use a matched 90-day or 180-day window with the same eligible customer population, observed contribution and first-return customer counts. A first-product ranking describes contribution per customer. Customer mix, timing and other factors can explain a difference, so the result is not a causal verdict about an offer or product.
Does a recovery checkpoint tell me the exact CAC payback date?
No. It identifies the earliest tested 90-day or 180-day snapshot whose cumulative contribution covers acquisition spend. Recovery may have occurred earlier between or before those observations. Later returns or costs can reduce cumulative contribution and reverse coverage. These snapshots measure contribution, not the timing of cash receipts or an exact cash-payback date.