Retention Analysis

A leading global workforce management platform experienced concerning retention trends during Q4 2023. The company, serving 13,700+ businesses needed urgent analysis to understand:

  • What's driving the dramatic increase in customer churn?
  • Which services and regions are most affected by retention challenges?
  • How is revenue expansion from existing customers being impacted?
  • What external factors correlate with the retention decline?

Executive Summary

Monthly customer churn has doubled from 0.13% to 0.27%, while revenue expansion from existing customers has declined from 102.87% to 100.68%.

This analysis reveals the problem is concentrated in specific services (IC) and regions (AMS and EMEA), pointing to external economic factors rather than company-wide issues.

Key Insights

Service-Specific Vulnerability

  • Individual Contractor (IC) service drives 93% of all churn
  • IC churn rate nearly doubled: 0.33% to 0.63%
  • Employer of Record (EOR) maintains perfect 0% churn
  • Clear distinction between discretionary vs. essential services

Geographic Concentration

  • 90% of churn concentrated in AMS and EMEA regions
  • Both regions converging at ~0.26% churn by December
  • APAC and Brazil remain largely unaffected
  • Regional economic factors appear to be primary driver

Revenue Expansion Deterioration

  • Net Revenue Retention declined from 102.87% to 100.68%
  • Dual pressure: customers leaving AND reducing spend
  • Contractor business unit volatile, EOR unit steadily declining
  • APAC only region showing accelerating expansion

Strategic Recommendations

Immediate Actions: Implement economic resilience programs including flexible pricing, value demonstration campaigns, and early warning systems for contract reduction patterns.

Portfolio Strategy: Accelerate growth in resilient regions (APAC) and services (EOR), while developing retention programs specifically for economic-sensitive segments.

Market Position: Reframe contractor services as cost-saving solutions during economic downturns rather than growth investments.


Data Schema

customer_monthly_revenue data table

Column Data Type Description
month DATE Revenue month
customer_id INT Unique customer identifier
service_id INT Service identifier
contracts INT Active service contracts count
total_saas_revenue_usd FLOAT Monthly SaaS revenue per service

dim_customer data table

Column Data Type Description
customer_id INT Primary customer key
country STRING Customer country location
region STRING Geographic region code

dim_service data table

Column Data Type Description
id INT Service identifier
name STRING Service name (IC, EOR, SHD, PR, GP)
business_unit STRING Internal business unit assignment
standard_monthly_fee STRING Standard pricing per contract

Monthly Churn Rate Analysis

Customer monthly churn rate has steadily increased from August to December 2023

Loading...
No Results

While churn rate remains low (less than 0.3%), the consistent month-over-month increase is concerning. However, strong customer acquisition (From 12K to 13.7K customers) is offsetting churn impact.

Service-Level Performance Analysis

Individual Contributor (IC) service represents +93% of total churned customers

Loading...

IC churn rate increased every month except November

Loading...
No Results
  • August to September: +30% increase (0.33% to 0.43%)
  • September to October: +28% increase (0.43% to 0.55%)
  • November to December: +11% increase (0.57% to 0.63%)

In term of impact:

  • Total IC customers churned: 206 over 5 months
  • December alone: 52 customers (highest monthly loss)
  • Customer base growth: Despite churn, IC customer base grew from 7,885 to 8,251

Regional Performance Segmentation

90% of customer churn occurs in the AMS and EMEA regions

Loading...
  • AMS region dominates churn impact with 74 total churned customers (58% of all churn)
  • EMEA accounts for 41 churned customers (32%)
  • Other regions (APAC, BRAZIL) show minimal churn impact

Both AMS and EMEA show concerning deterioration of the churn rate

Loading...

The convergence of both regions suggests common external factors (economic conditions, competitive pressure) affecting Western markets simultaneously, while other regions remain largely unaffected.

Net Revenue Retention Analysis

Overall NRR

NRR is on a concerning downward trend throughout Q4 2023

Loading...

Business Unit Patterns

Loading...
  • The Contractor business unit is volatile. Exceptional August (107%), near-flat September (100.84%), then stabilized around 102.5%:
  • On the other hand the EOR business units has a steady decline from 102.40% to 101.57%. It is more predictable but consistently weakening.

Regional NRR Performance

AMS performances are on the decline with a barely positive expansion

Loading...

EMEA follow a similar pattern with a gradual decline

Loading...

APAC is the only region with accelerating expansion

Loading...

Strategic Hypothesis

Core Hypothesis: Economic Recession Impact

Q4 2023 economic conditions (rising interest rates, budget tightening, recession concerns) caused companies in Western markets to reduce discretionary contractor spending, driving increased churn in Individual Contractor services while essential Employer of Record services remained stable.

Supporting Evidence

Geographic Concentration

  • 90% of churn concentrated in AMS and EMEA regions (Western markets)
  • APAC/BRAZIL: Minimal churn impact during same period
  • Implication: Economic factors are region-specific, not platform-wide

Service Differentiation

  • IC service: 93% of total churned customers, churn doubled from 0.33% to 0.63%
  • EOR service: Perfect 0% churn across all months
  • Implication: Economic pressure affects contractor spend vs. employee payroll

Revenue Contraction Timing

  • Overall NRR decline: From 102.87% (August) to 100.68% (December)
  • Dual pressure: Companies both leaving (churn) AND reducing spend (low NRR)
  • Implication: Companies reducing both headcount and per-employee spend

Strategic Recommendations

Economic-Resilient Service Portfolio

  • IC Service: Flexible pricing programs for contractor management
  • Value Proposition Shift: Position IC as cost-saving tool vs. growth investment
  • EOR Expansion: Accelerate growth in recession-resistant payroll services

Geographic Risk Mitigation

  • APAC Market Investment: Scale successful expansion in resilient region
  • AMS/EMEA Retention Programs: Targeted campaigns for economic-sensitive markets

Customer Success Intervention

  • Early Warning System: Identify customers reducing contracts before full churn
  • Proactive Outreach: Engagement campaigns for contract-reducing customers
  • Economic Support Programs: Extended payment terms and seasonal pricing