Case Study: City of Tallahassee achieves a reduction in leak notification time from 50+ days to 7 days with Alteryx

Customer Water Leak Detection And Notification

The City of Tallahassee, which operates municipal water utilities, faced a growing problem: leak detection relied on manual review of monthly bills, meaning customers could experience continuous, billable leaks for weeks or months before action. The city needed an automated way to scan consumption data, detect anomalous patterns consistent with customer‑side leaks, notify customers quickly, and provide technicians with prioritization tools.

Using an Alteryx workflow that evaluates the prior 72 hours of hourly consumption and flags meters with continuous flow and average daily use roughly 2.5× their historical norm, the city links flagged meters to billing and contact metadata, sends automated emails and robo‑calls to opted‑in customers, and publishes dashboards in Tableau for dispatch and key accounts. The daily‑running solution cut the average time to customer notification from over 50 days to seven days, enabled technicians to prioritize the largest leaks, and has led to frequent customer savings often exceeding $500 after repairs.

City of Tallahassee

Brian Scott

Innovation Manager