Karlsruhe lost the fewest customers so far. It now holds the largest pool of customers about to go.
12.5%churned so far lowest of 5 cities
32customers at risk now
€38.2Krevenue at risk
A spreadsheet sorts by one column. This view compares two rankings at once.
Why they leave
Late payment is the loudest signal.
Of customers more than 60 days overdue, 75% have already left. That is 3.8× the average.
Where to start
27 customers carry half the money at risk.
Rank the 83 by revenue and the curve bends early. Call these 27 first, the rest can wait for next week.
27customers 50% of €99.8K
14customers already 30%
This week's plan
Three moves, 83 customers.
46
Loyalty offers
They switched provider before and will do it again.
35
Payment plans
More than 30 days overdue. Fix the bill, keep the customer.
2
Personal calls
No clear trigger. A conversation finds it.
Customer
City
Tariff
Probability
Revenue
Action
Beyond this week
Four fixes that stop the next 83.
35of 83Billing
Offer the payment plan at day 30, not day 60.
Past 60 days overdue, 75% of customers leave. Between 31 and 60 days it is still 42%. That is the window to act.
54of 83Retention
Put previous switchers on a loyalty track.
Customers who changed provider before leave twice as often (39%). They are 54 of this week’s 83.
27of 83Pricing
Rework the BasisStrom tariff.
26.5% of its active customers sit above the trigger, the highest of six tariffs. SmartStrom: 2.5%.
32of 83Regional
Give Karlsruhe a named retention owner.
Lowest churn history, largest risk pool today. It is a blind spot, not a safe city.
Counts show at-risk customers in scope for each fix; one customer can match several.
Partner
Built on SAP BDC. Read in under a minute every day.
We model your SAP data once in SAP Business Data Cloud. The data refreshes every day, the briefing lands every Monday: what is at risk, why, and what to do next.
SAP Datasphere & BW/4HANA modelling
SAP Business Data Cloud architecture
SAP Analytics Cloud & data storytelling
SAP Databricks, ML & agentic BI
Source systems
SAP systemsS/4HANA · ERP · BW
Non-SAP systemsSQL databases · cloud apps · files
Business Data Cloud
SAP DatasphereAnalytic model AM_DATENSET_CHURNHarmonised customer, contract & billing data
Zero-copy Delta Share
SAP DatabricksChurn scoring & MLProbability per customer · risk drivers