technology

Using Data Analytics to Improve Pool Route Management

Industry expertise since 2004

Superior Pool Routes ยท 12 min read ยท December 28, 2024

Using Data Analytics to Improve Pool Route Management โ€” pool service business insights

๐Ÿ“Œ Key Takeaway: Treat your route like a dataset, not a paper map. The pool service operators who pull ahead this decade are the ones tracking stops per day, drive time per stop, chemistry trends per pool, and revenue per ZIP โ€” then acting on what those numbers actually say.

Most pool service businesses still run on a clipboard mindset. The technician knows roughly which houses get serviced on Tuesday, the office knows roughly who paid this month, and the owner knows roughly whether last summer was better than this one. Roughly is fine when you have twenty accounts. It falls apart somewhere around eighty. By the time you cross two hundred stops a week, the gap between what you think is happening on your routes and what is actually happening becomes the single largest drag on your profit. Since 2004, we have watched that pattern repeat in every market we sell routes into โ€” Florida, Texas, Nevada, Arizona, California โ€” and the fix is always the same. Stop guessing. Start measuring. The good news is that you do not need a data science team to do it. You need a handful of numbers, the discipline to look at them every week, and a willingness to change the route when the numbers tell you to.

Start With Stops Per Day, Not Stops Per Week

The single most useful number in a pool service operation is stops per technician per day. Not stops per week, not accounts on the books โ€” stops actually completed in an eight-hour day. Once you measure it honestly, you usually find that a tech who claims to service twenty-two pools a day is finishing eighteen, with the remaining four either pushed to the next day or skimmed past in three minutes flat. That gap is where margin dies.

Track it the simple way first. Log the time the tech opens the gate at each stop and the time they close it. A weekly chemical-only stop in a residential pool should fall in a tight band โ€” call it eighteen to twenty-five minutes including drive time from the previous house. When a particular stop consistently runs longer, the data is telling you something: the customer added a spa, the pool is filthy because they let the cover stay on too long, or the tech is using that stop to take a break. All three deserve a response, and none of them are visible on a clipboard.

Once you have a clean baseline, push the number. Routes we underwrite for sale typically run between sixteen and twenty-four stops per tech per day depending on density. If your route is sitting at twelve and the houses are within a few miles of each other, you have a routing problem, a tech problem, or a scope-creep problem. The data will tell you which.

Drive Time Is the Hidden Cost Center

Drive time between stops is the second number that pays for itself the moment you start watching it. A truck moving is a truck losing money โ€” no chemicals are being applied, no equipment is being inspected, no customer is being served. Yet most operators have no idea what their average minutes-between-stops actually is.

When you start logging it, the picture clarifies fast. Healthy urban or suburban routes in Phoenix, Dallas, Orlando, or the Inland Empire tend to land between four and eight minutes of drive time between stops. Rural or exurban routes run longer and need different pricing to compensate. If your average is creeping past ten minutes in a dense market, you are almost always looking at a route that grew by accretion โ€” one new account here, another across town there โ€” until the geometry stopped making sense.

The fix is unglamorous but powerful: cluster by ZIP and by day. Pull every active account into a spreadsheet with ZIP code, service day, and weekly fee. Sort. You will frequently find a Wednesday route that crosses three ZIP codes when it could be consolidated into one, or a Thursday route that has two outlier houses adding forty-five minutes of round-trip drive for sixty dollars of weekly revenue. Those outliers either get repriced, swapped with a competitor for a closer account, or dropped. The decision becomes obvious once the numbers are on the page.

Chemistry Trends Tell You Which Pools Are Actually Profitable

Most operators bill a flat monthly rate and absorb whatever chemical cost the pool demands. That works on average, but averages hide the pools that are eating you alive. The way out is to log chlorine, pH, cyanuric acid, calcium hardness, and salt readings at every visit and watch the trend per pool over a season.

A pool that consistently demands two or three times the baseline chlorine โ€” because of shade, bather load, dogs, runoff, or a failing surface โ€” is not a normal account. It is a subsidized account being paid for by your other customers. When you see that pattern in the data across six or eight weeks, you have three honest options: raise the price to match the actual chemical and labor draw, narrow the scope of service so the customer pays for the extras separately, or release the account. Without the trend data, you never see the subsidy, and you wonder why your chemical line item keeps climbing faster than revenue.

Chemistry trends also catch equipment problems before the customer does. A salt cell that is failing shows up as a slow downward drift in free chlorine three or four weeks before the homeowner notices the water turning. Catching it through the data, calling the customer proactively, and quoting the cell replacement is the difference between a routine service relationship and a frustrated customer shopping for a new pool guy.

Customer Lifetime Value Reframes Every Pricing Decision

Pool service is a subscription business, even if you do not call it that. The right question is not what is this stop worth today but what is this account worth over the years it stays on the route. Customer lifetime value โ€” average monthly revenue multiplied by average tenure in months, minus the cost to serve โ€” is the number that should sit behind every pricing, hiring, and acquisition decision you make.

In the markets we have worked in since 2004, well-run residential pool service accounts tend to stay on a route for years, not months. The math compounds quickly. A customer paying a modest monthly fee for five or six years is worth dramatically more than a higher-paying customer who churns at eighteen months. Once you internalize that, the way you handle complaints changes. The cost of fielding a difficult phone call and waiving one cleaning fee is a rounding error against the lifetime value of keeping that account on the books. The cost of a chronically rude tech, or a missed Friday service before a Saturday pool party, is enormous โ€” even if the immediate refund is small.

Calculate LTV by segment. New construction neighborhoods often produce shorter tenures because homeowners are still settling and shopping. Established neighborhoods with mature landscaping and older owners often produce the longest tenures and the highest cumulative value, even at lower headline prices. The data will tell you which kind of customer to chase with your marketing dollar and which to be careful about over-investing in.

Churn Is the Number Owners Avoid for Too Long

The mirror of lifetime value is churn โ€” the percentage of accounts you lose in a given period. Most owners can tell you their gross account count and their revenue, but very few can tell you their monthly or annual churn rate without doing the arithmetic on the spot. That is the number you most need to know, because churn is the leak in the bucket. Adding accounts faster than you lose them feels like growth; in reality it is treadmill work that masks an underlying problem.

Tracking churn is straightforward. Each month, divide the number of accounts lost by the number of accounts you started the month with. A healthy residential pool service route in a stable market typically runs in the low single digits per month, with seasonal spikes around homeowner moves and pool closures in cooler climates. When the rate climbs, the question is why โ€” and the data usually answers it before your gut does. Cluster the lost accounts by tech, by ZIP, by tenure, and by reason. If one technician is responsible for a disproportionate share of cancellations, you have a coaching or staffing decision. If one neighborhood is hemorrhaging accounts, you have a competitor moving in or a service quality issue clustered in a single route day. If most of your losses are happening in the first ninety days, your onboarding is broken.

The operators we work with who watch churn weekly tend to keep it tight. The ones who only notice it at year-end tend to discover, around February, that they spent a full season acquiring accounts to replace accounts they did not have to lose.

Revenue Per ZIP Tells You Where to Grow and Where to Trim

When you map your accounts against ZIP codes and overlay revenue, you stop making growth decisions emotionally and start making them geographically. Revenue per ZIP โ€” total monthly recurring revenue from accounts in a given ZIP, divided by the number of accounts there โ€” surfaces the routes that are actually carrying the business and the ones that look busy but are not contributing.

A ZIP with thirty accounts at strong average pricing and tight drive times is a ZIP you defend. You market there, you ask for referrals there, you accept new accounts there even when the schedule looks full because the marginal cost of adding the thirty-first stop is almost nothing. A ZIP with six scattered accounts at average pricing and twelve-minute drive times between them is a ZIP you either grow deliberately to critical mass, trade with a competitor for accounts in your stronger ZIPs, or wind down. Sitting in the middle is the most expensive option, and it is also the most common because it requires no decision.

Pair revenue per ZIP with a simple density score โ€” accounts per square mile within the ZIP โ€” and the route picture sharpens further. High revenue, high density is the gold standard. High revenue, low density is fine if your pricing accounts for the drive. Low revenue, low density is where margins go to die.

Build the Habit Before You Buy the Software

There is a real temptation, once you start thinking this way, to go shopping for a platform. Resist it for at least a quarter. Every metric described above can be tracked in a spreadsheet with columns for date, tech, stop, start time, end time, ZIP, monthly fee, and chemistry readings. The reason to start there is that the habit of looking matters more than the tool you use to look. Owners who buy software before they have a measurement habit end up with a dashboard nobody opens. Owners who build the spreadsheet habit first know exactly what they want their software to do when they are ready to upgrade, and they pick the right product because they have lived in the data.

When you do upgrade, choose tools that integrate billing, routing, and service notes in one place. The biggest gains come not from any single feature but from removing the friction between collecting the data and acting on it. If your tech has to open three apps to log a chemistry reading, the reading does not get logged. If your office has to re-key route changes into a billing system, the route does not get changed.

What This Looks Like at Scale

A pool service operation that is genuinely run on numbers behaves differently from one that is not. The owner walks into Monday morning knowing which routes ran long the previous week, which pools showed chemistry drift, which accounts hit ninety days without a referral ask, and which ZIPs gained or lost net accounts. The weekly conversation with technicians is concrete: this stop is averaging twenty-eight minutes when it should be twenty, what is going on. The pricing conversation with customers is grounded: your pool has needed forty percent more chlorine than average this season, here is what we are seeing and here is what it will take to keep your water clear. The acquisition conversation with new accounts is selective: we are taking accounts in these ZIPs on these days because that is where we can serve you well.

That is the real point of data analytics in this business. It is not about dashboards or algorithms. It is about replacing rough impressions with specific numbers so that every decision โ€” pricing, routing, hiring, growth โ€” is made on something firmer than memory. The operators who run this way tend to grow steadily, defend their margins through bad seasons, and command higher multiples when they eventually sell.

If you are building a route from scratch or expanding the one you have, the framework is the same. Measure what matters, watch it weekly, and let the numbers drive the changes. When you are ready to add density to your operation, take a look at our current inventory of Pool Routes For Sale โ€” and bring the metrics above into the conversation. We have been pricing, building, and transferring routes since 2004, and the routes that hold their value over time are the ones their owners actually understood.

Ready to Buy a Pool Route?

Get pool service accounts at half the industry price.

Call Now Get a Quote