Revenue cohort audit
A six-week analysis of customer revenue by acquisition period, channel and subscription term, with a reconciled LTV model.
Who this is for
The audit suits subscription or in-app purchase teams with at least nine months of transaction history and a live decision about acquisition spend, pricing, renewal or market mix. It is especially useful when product, finance and growth reports disagree about net revenue or customer lifetime value.
The question we answer
We establish how much net revenue distinct customer cohorts have produced, how quickly they pay back acquisition cost, and which observed differences are substantial enough to influence a decision. We separate measured revenue from projected revenue throughout.
Included
- A 60-minute scoping call and written data inventory
- Reconciliation of gross receipts, tax, store commission, refunds and chargebacks
- Weekly or monthly cohorts by first paid event
- Segmentation by agreed dimensions such as channel, country, plan term or product
- Retention, revenue per payer, cumulative revenue and payback curves
- An LTV range with assumptions and sensitivity tests
- A calculation workbook, chart pack and decision brief
- Two review sessions with product, growth and finance stakeholders
Raw event collection, tracking implementation, attribution vendor procurement and production data engineering are not included. If the exports cannot support a requested split, we show the gap rather than substitute false precision.
How the six weeks run
1. Definitions and evidence
In week one we agree the unit of analysis, observation window, treatment of trials and refunds, currency conversion and the precise meaning of net revenue. Your team provides transaction-level or customer-period exports through an agreed secure transfer route.
2. Reconcile before comparing
Weeks two and three are for quality checks and reconciliation against finance totals. Duplicate transactions, missing customer identifiers, grace periods and restored purchases are logged. Work pauses for approval if the unexplained variance is material.
3. Cohorts and LTV range
Weeks four and five cover cohort curves, segment comparisons and the modelled tail beyond observed data. We test how conclusions change under conservative and central assumptions.
4. Decisions and handover
The final week brings the evidence into a 90-minute working session. We agree which CAC ceilings, payback windows or pricing questions the analysis supports. You receive editable files and a recorded calculation walkthrough.
Preparation and constraints
Please nominate one finance owner and one product or growth owner. Before kickoff, prepare transaction IDs, customer or anonymous payer IDs, transaction dates, product identifiers, amounts, currency, refund status and acquisition channel where available. Personal names, email addresses and advertising IDs are neither requested nor needed.
Fee and next step
Audits start at £8,400 + VAT. A wider market set, historical currency conversion, fragmented billing sources or unusually large reconciliation gaps may increase the fee; those factors are priced before work begins. Forty per cent is due to reserve the start date.