Unified Customer View
One row per customer.
We stitched order, campaign and CRM data into a single customer-level table, making CLV, recency and frequency easy to calculate and track over time.
Case Study · Retail | CLV & Retention
Customers not coming back even after discounts?
How a retail brand used CLV & retention analytics to grow repeat orders sustainably instead of burning money on offers.
Headline result: +38% increase in repeat purchases in 4 months.
Context
A mid-sized retail brand was acquiring new customers at a healthy pace, but repeat orders were stagnating. Despite frequent discounts and campaigns, long-term value per customer was flat.
Leadership knew retention mattered, but they lacked a clear view of who was coming back, when, and why.
Key Challenges
- All performance reports focused on new orders and top-line revenue.
- No customer-level view of cohorts or long-term value.
- Discounts were used blindly without understanding payback.
- Marketing & CRM teams worked with different, conflicting numbers.
What DASTATS Built
Retention & CLV Cohorts
Who comes back, and when?
Cohort dashboards showed first-time buyers vs. repeat customers, time between orders, and how CLV evolved by acquisition channel and campaign.
Segmented Campaign Playbook
Right offer, right group.
We defined segments (new, promising, at-risk, lapsing) and aligned distinct campaign strategies and KPIs for each group.
Impact
+38% Repeat Purchase Rate
Targeted campaigns and better timing increased second and third orders without increasing overall discount budget.
Clear CLV by Channel
The brand saw which channels attracted customers who stayed and spent more, not just who converted first.
Retention Became a KPI
Retention and CLV were added to monthly and quarterly review dashboards, shifting focus beyond “this month’s revenue”.
What We Used
- Data sources: order database / platform exports, campaign data, CRM.
- Modeling & transformations: SQL / Python (if applicable) and BI data model.
- Reporting: Power BI (or your BI of choice) with cohort & CLV views.
Related Solutions
Want to understand what actually drives your repeat revenue?
Share your current reports and data sources. We’ll outline a retention and CLV view tailored to your brand.