Building a Retention Metrics Dashboard (What to Track and Why)

Most marketplace founders obsess over growth metrics.

Monthly Active Users. New Signups. Transaction Volume.

They ignore retention until it's too late.

The truth: A marketplace with 30% monthly retention will beat one with 10% retention—even if the second has 3x more new users.

Here's what to track, why it matters, and how to turn retention data into decisions.

Why Retention Matters More Than Growth

The leaky bucket problem:

Marketplace A:

• •1,000 new users per month
• •10% retention (90% churn)
• •Month 12: 1,100 active users

Marketplace B:

• •500 new users per month
• •40% retention (60% churn)
• •Month 12: 6,200 active users

Marketplace B wins with half the acquisition.

The economics:

Customer Acquisition Cost (CAC): $30 Average Transaction Value: $200 Platform Commission: 20% = $40 revenue

If customer books once: $40 revenue - $30 CAC = $10 profit

If customer books 5x: $200 revenue - $30 CAC = $170 profit

17x more profit from retention.

The Core Retention Metrics

Metric 1: Repeat Purchase Rate

Definition: % of customers who make 2+ purchases

How to calculate:

Repeat Rate = (Customers with 2+ purchases / Total customers) × 100

Benchmarks by marketplace type:

• •Service marketplaces: 30-50%
• •Product marketplaces: 20-40%
• •B2B marketplaces: 40-60%
• •High-frequency services (cleaning, food): 50-70%

How to track:

SQL query:

SELECT
  COUNT(DISTINCT CASE WHEN purchase_count >= 2 THEN customer_id END) * 100.0 /
  COUNT(DISTINCT customer_id) as repeat_rate
FROM (
  SELECT
    customer_id,
    COUNT(*) as purchase_count
  FROM bookings
  GROUP BY customer_id
) customer_purchases;

What it tells you:

• •Below benchmark = retention problem
• •Improving over time = good retention tactics
• •Declining = urgent retention issue

Metric 2: Cohort Retention

Definition: % of users from a specific cohort who are still active over time

Cohort structure:

What to look for:

• •Retention curves flattening (good) - Churn stabilizes
• •Improving cohorts (great) - Product getting better
• •Declining cohorts (bad) - Product degrading

How to build:

Google Sheets formula:

=COUNTIFS(signups!$A:$A, cohort_month, transactions!$B:$B, ">="&cohort_month, transactions!$B:$B, "<"&EDATE(cohort_month,1)) / COUNTIF(signups!$A:$A, cohort_month)

Or use analytics tools:

• •Amplitude (best for product analytics)
• •Mixpanel (good for cohorts)
• •Google Analytics 4 (basic cohort reports)

Metric 3: Time to Second Purchase

Definition: Average days between first and second purchase

Benchmarks:

• •Fast-frequency services: 7-14 days (cleaning, food delivery)
• •Medium-frequency: 30-60 days (home services, wellness)
• •Low-frequency: 90-180 days (major home projects, B2B)

How to calculate:

SELECT
  AVG(DATEDIFF(second_purchase, first_purchase)) as avg_days_to_second
FROM (
  SELECT
    customer_id,
    MIN(purchase_date) as first_purchase,
    MIN(CASE WHEN purchase_order = 2 THEN purchase_date END) as second_purchase
  FROM (
    SELECT
      customer_id,
      purchase_date,
      ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY purchase_date) as purchase_order
    FROM bookings
  ) ranked_purchases
  GROUP BY customer_id
  HAVING COUNT(*) >= 2
) time_to_second;

Why it matters:

• •Faster = stronger engagement
• •Benchmark your own over time
• •Target: Reduce by 10-20% quarterly

Metric 4: Churn Rate

Definition: % of customers who don't return within expected timeframe

How to calculate:

For monthly subscription or high-frequency:

Monthly Churn = (Customers who left in month / Total customers at start of month) × 100

For transaction-based:

Churned = Customer hasn't transacted in 2× average purchase frequency

Example:

• •Average purchase frequency: 45 days
• •Consider churned if: No purchase in 90 days

Benchmarks:

• •Excellent: < 5% monthly churn
• •Good: 5-10% monthly churn
• •Needs work: 10-20% monthly churn
• •Critical: > 20% monthly churn

SQL for transaction-based churn:

SELECT
  COUNT(*) * 100.0 / (SELECT COUNT(*) FROM customers WHERE created_at < DATE_SUB(NOW(), INTERVAL 90 DAY)) as churn_rate
FROM customers c
WHERE
  c.created_at < DATE_SUB(NOW(), INTERVAL 90 DAY)
  AND NOT EXISTS (
    SELECT 1
    FROM bookings b
    WHERE b.customer_id = c.id
    AND b.created_at > DATE_SUB(NOW(), INTERVAL 90 DAY)
  );

Metric 5: Customer Lifetime Value (LTV)

Definition: Total revenue generated by average customer over their lifetime

Simple calculation:

LTV = Average Order Value × Purchase Frequency × Customer Lifespan

Example:

• •AOV: $150
• •Purchase frequency: 6x per year
• •Lifespan: 3 years
• •LTV = $150 × 6 × 3 = $2,700

More accurate (cohort-based):

LTV = Sum of all revenue from cohort / Number of customers in cohort

Track by cohort to see if improving over time.

Relationship to CAC:

• •LTV:CAC ratio target: 3:1 minimum
• •Great marketplaces: 5:1 or better
• •Struggling marketplaces: < 2:1

Metric 6: Net Revenue Retention (NRR)

Definition: Revenue from a cohort compared to their first month (includes expansion)

How to calculate:

NRR = (Starting MRR + Expansion - Churn) / Starting MRR × 100

Example:

• •Cohort started with: $10,000 MRR (100 customers × $100)
• •Month 12: Same customers generate $12,000 (expanded usage)
• •NRR = $12,000 / $10,000 = 120%

Benchmarks:

• •> 100% = Great! Revenue expanding from existing customers
• •90-100% = Good, minimal revenue churn
• •< 90% = Revenue churn problem

Best for:

• •Subscription models
• •Commission-based with growing usage
• •B2B marketplaces

Metric 7: Provider Retention

Don't forget the supply side!

Key provider metrics:

Active Provider Rate:

Active Providers = Providers with 1+ booking in last 30 days / Total approved providers

Target: 40-60% (many will be inactive, that's OK)

Provider Churn:

Provider Churn = Providers with 0 bookings in 90 days / Total providers

Target: < 30% quarterly

Provider Engagement:

Average Bookings per Active Provider = Total bookings / Active providers

Track trend: Should increase over time as you get better matching

The Retention Dashboard

What to include (refresh weekly):

Section 1: Headline Metrics

• •Total Active Users (transacted in last 30 days)
• •Repeat Purchase Rate (90-day window)
• •Customer Churn Rate (monthly)
• •LTV:CAC Ratio

Section 2: Cohort Analysis

• •Cohort retention table (last 12 cohorts)
• •Cohort retention curve (visual)
• •Best and worst performing cohorts

Section 3: Engagement Metrics

• •Average time to 2nd purchase
• •Average purchase frequency
• •Average days since last purchase
• •% of users at risk of churning (> 2× frequency)

Section 4: Revenue Metrics

• •Revenue by cohort
• •Net Revenue Retention
• •Average Order Value trend
• •Revenue from repeat vs new customers

Section 5: Provider Metrics

• •Active provider rate
• •Provider churn
• •Bookings per provider
• •Provider satisfaction (if surveyed)

Identifying Churn Signals

Early warning signs a customer will churn:

Signal 1: Extended Time Since Last Purchase

Rule:

• •If typical frequency is 30 days
• •User at 40+ days since last = 60% churn risk
• •User at 60+ days = 80% churn risk

Action: Trigger re-engagement campaign

Signal 2: Declining Engagement

Metrics to watch:

• •Logins decreasing
• •Time on site decreasing
• •Provider profiles viewed decreasing
• •Search frequency decreasing

Action: Survey user, offer incentive

Signal 3: Negative Experience

Indicators:

• •Cancelled booking
• •Disputed charge
• •Negative review left
• •Support ticket filed

Action: Immediate outreach, fix the problem

Signal 4: Price Sensitivity

Indicators:

• •Only books with discounts
• •Always chooses cheapest provider
• •Cart abandons when seeing price

Action: Offer loyalty program, communicate value

Signal 5: Competitor Research

Indicators:

• •Searches for competitor names
• •Clicks competitor ads (if you can track)
• •Engages with competitor social content

Action: Competitive differentiation messaging

Improving Retention

Tactic 1: Onboarding Optimization

The first experience sets retention trajectory.

Onboarding checklist:

• • Welcome email within 5 minutes
• • Guide them to complete first booking within 24 hours
• • Follow-up after first booking (ask for review)
• • Day 7: Educational content ("How to get most from [marketplace]")
• • Day 14: Encourage second booking

Metric to track:

• •% who complete first booking within 7 days (target: 40%+)
• •% who complete second booking within 30 days (target: 25%+)

Tactic 2: Email Automation

Retention email sequences:

Repeat booking nudge:

• •Trigger: 7 days after first booking
• •Subject: "Ready for your next [service]?"
• •Include: Provider they used, similar providers, special offer

At-risk customer:

• •Trigger: 1.5× average frequency with no booking
• •Subject: "We miss you - here's 20% off your next booking"
• •Include: Popular providers, new features, testimonial

Milestone celebration:

• •Trigger: 5th booking, 10th booking, etc.
• •Subject: "You're a VIP! Here's a thank you gift"
• •Include: Exclusive discount, early access to features

Tactic 3: Loyalty Program

Simple structure that works:

Tier 1 (Bronze): 3+ bookings

• •5% off all future bookings
• •Priority support

Tier 2 (Silver): 10+ bookings

• •10% off all future bookings
• •Early access to new providers
• •Quarterly bonus credits

Tier 3 (Gold): 25+ bookings

• •15% off all future bookings
• •Dedicated account manager
• •Exclusive providers

Impact: 30-50% increase in repeat rate

Tactic 4: Personalization

Data you should use:

Past behavior:

• •Preferred providers
• •Preferred service types
• •Preferred price range
• •Booking frequency
• •Preferred times/days

Personalized experiences:

• •Homepage shows relevant providers
• •Search defaults to their preferences
• •Email recommendations based on history
• •Push notifications for preferred provider availability

Impact: 20-40% increase in engagement

Tactic 5: Surprise and Delight

Random acts of appreciation:

Examples:

• •Random $10 credit after good review
• •Birthday discount (50% off)
• •"You're our 1,000th booking!" celebration
• •Hand-written thank you note for VIPs
• •Exclusive event invitations

Cost: Low (select few customers) Impact: High (word-of-mouth, loyalty)

Common Retention Mistakes

Mistake #1: No Retention Tracking

The trap: "We're growing, so retention must be fine."

Reality: High churn hidden by high acquisition

Fix: Build retention dashboard this week

Mistake #2: Treating All Customers the Same

The trap: Same experience for first-time and loyal customers

Reality: VIP customers deserve VIP treatment

Fix: Segment and personalize

Mistake #3: Ignoring At-Risk Signals

The trap: Wait until customer churns to react

Reality: Can prevent 50-70% of churn with early intervention

Fix: Build at-risk customer campaigns

Mistake #4: No Win-Back Strategy

The trap: "They churned, they're gone forever."

Reality: 20-30% of churned customers will return with right offer

Fix: Automated win-back sequence (90 days after churn)

Mistake #5: Forgetting Provider Retention

The trap: Only track customer metrics

Reality: If providers churn, customers have no one to book

Fix: Track provider engagement and satisfaction

Your Retention Roadmap

Week 1: Baseline

• • Calculate current repeat purchase rate
• • Build basic cohort analysis
• • Identify avg time to 2nd purchase
• • Calculate churn rate

Week 2: Dashboard

• • Set up retention dashboard (use our template)
• • Configure automated reporting
• • Share with team weekly

Week 3: Quick Wins

• • Launch onboarding email sequence
• • Create at-risk customer segment
• • Send re-engagement campaign

Week 4: Long-term Strategy

• • Design loyalty program
• • Plan personalization roadmap
• • Set quarterly retention goals

Ongoing:

• • Weekly dashboard review
• • Monthly retention deep-dive
• • Quarterly cohort analysis

Working with Directorism

We help founders turn retention data into sharper product and lifecycle decisions.

Our Retention Optimization Service

What we do:

• •Build complete retention dashboard
• •Identify top 5 churn causes
• •Implement retention campaigns
• •Design loyalty program
• •90-day optimization sprint

Investment: $7,500 Timeline: 90 days Target outcome: clearer retention bottlenecks and a measurable repeat-usage plan

---

Ready to fix your retention?

Request a retention discovery call. We'll review your current metrics and identify the retention questions most worth solving first.

Request Retention Discovery →