Marketer
Advertising, customer payback, repeat purchases, budget and impact testing.
Route steps
- Quick business check: two periods
From basic figures of two periods calculates gross margin, operating profitability, turnover, days of inventory, receivables and payables, the cash cycle, the share of returns and old stock and shows which way each moved. - Advertising: ROAS, ad share and ROMI on margin
Compares the actual return on advertising with the allowable: shows ROAS, ad share, ROMI on margin, break-even and target ad share and ad share allowing for the purchase rate. - CAC and LTV: quick acquisition check
Calculates what a new customer costs to acquire, how much profit they bring over their lifetime and how fast marketing spend pays back. A quick estimate on averages; for the exact payback use Customer cohort. - Customer cohort: payback period and retention
For a cohort of customers calculates cumulative margin by month, CAC payback period, LTV for the period and the LTV to CAC ratio. - RFM segments from your customer table
Splits customers by recency, number of purchases and amount into segments, shows the share of customers and revenue in each and whom to win back first. Everything runs in the browser; the table goes nowhere. - Repeat purchases: what extra points of return are worth
Shows how much extra gross profit a year comes from raising the share of returning customers by a set number of percentage points, what one point is worth and how much can be spent on retention. - Loyalty program economics
Compares the profit from members’ extra purchases with the cost of rewards and running. Allows for part of the member gap not being created by the program, shows the reward rate at which the program breaks even and the points that remain a liability. - Marketing budget from a revenue goal
Works backwards from a revenue goal: needed orders and visits, the allowable cost of a visit, the acquisition and brand budget and its share of revenue. Shows whether your cost of a visit pays back at your margin. - Channel incrementality: test against control
Compares the revenue of a group with ads on against a similar group without them. Shows incremental revenue, incremental return and profit after spend, and compares with the ad platform’s last-click report. - Returns: what they cost and how they hit margin
Calculates the loss from returns: reverse logistics, resale at a discount, write-off, lost profit. Shows the maximum return rate at which profit is zero.
Documents for this route
- Cohort analysis: retention table, curve, LTV forecast and RFM as mathematics
- CRM analytics: RFM, cohorts, retention, LTV/CAC, loyalty
- Circular models: resale, upcycling, repair, rental
- CRM chains and the loyalty program: triggers, frequency, consents, tiers, points lifetime and payback by cohort
- Unit economics (CM1, CM2, CM3) with buyout
- Unit economics with buyout: CM1-CM3, LTV/CAC, customer survival, channel payback
- Bayesian estimates of conversion and buyout: small samples, prior distributions, shrinkage and comparison with the frequentist approach
- A/B tests for promotions and promos: hypothesis, sample, power, p-value, peeking