Where Value Comes From
See which customers and offers create lasting value
Data Stories LabInteractive dashboardCar workshops · customer value
-
Customers
-
Avg lifetime LTV
-
Avg 12-month LTV
-
Fully-loaded profit
gross profit minus ad spend
Lifetime LTV by branch
Average lifetime value of a customer, by region
Source: Malaysian car-workshop chain, customer and transaction data.
Lifetime LTV by offer
The promotion a customer walks in on shapes their value
Source: Malaysian car-workshop chain, customer and transaction data.
Fully-loaded profit by offer (RM)
Gross profit at a 40% margin, minus ad spend
Source: Malaysian car-workshop chain, customer and ad-spend data.
LTV cohort curves by offer (RM, day 7 to 365)
Free-diagnostic offers book little on day one, then pull clear by month twelve
Source: Malaysian car-workshop chain, cohort LTV by day.
-
Repeat rate
-
Avg visits / customer
-
Whale revenue share
top 10% of customers
-
Whales
Repeat rate by offer
Free-diagnostic offers buy the habit of coming back
Source: Malaysian car-workshop chain, repeat-purchase data.
Revenue concentration (whale curve)
A small group of customers drives most of the revenue
Source: Malaysian car-workshop chain, customer revenue.
Visits per customer
Distribution of service visits across the customer base
Source: Malaysian car-workshop chain, service-visit data.
Whale rate by branch
Whales cluster where the location and offer stories pointed
Source: Malaysian car-workshop chain, customer revenue by branch.
-
Blended CAC
-
Best source (lifetime LTV)
-
Paid-acquired customers
-
Free-channel share
organic, referral, walk-in
Lifetime LTV by source
Referral and organic bring the highest-value customers
Source: Malaysian car-workshop chain, customer value by channel.
CAC by source (RM)
What each paid channel costs to acquire a customer
Source: Malaysian car-workshop chain, ad-spend data.
Return on acquisition (lifetime LTV : CAC)
Cheap channels can return more per Ringgit even at lower value
Source: Malaysian car-workshop chain, LTV and CAC by channel.
Customers by source
Share of the customer base by acquisition channel
Source: Malaysian car-workshop chain, acquisition data.
-
Blended CAC
-
Target CAC (30% of 12-mo LTV)
-
Lifetime LTV : CAC
-
Double-down cells
First-year LTV : CAC by offer
Return on acquisition in the first twelve months
Source: Malaysian car-workshop chain, first-year LTV and CAC.
Target vs actual CAC by offer (RM)
The CAC ceiling is set by value, at 30% of 12-month LTV
Source: Malaysian car-workshop chain, CAC ceilings.
Decision table: CAC ceilings by branch and offer
Rank every branch-and-offer cell by first-year return on acquisition
| Branch | Offer | 12-mo LTV | CAC | CAC ceiling (30%) | LTV:CAC | Verdict |
|---|
Source: Malaysian car-workshop chain, branch-and-offer economics.