Pool service traffic is route-shaped. "Weekly pool service Scottsdale", "saltwater pool cleaning Sarasota", "pool opening Long Island", "pool closing Northern Virginia". The shops that win the work are the ones whose existing routes pass the customer's house. A single archive cannot reflect routes, and writing service-by-city combinations by hand misses the underlying scheduling reality.

SleekRank reads the shop roster and uses one base WordPress page as the template. Each row becomes a URL with company name, services, pool types served (plaster, vinyl, fiberglass, saltwater), chemical certifications, weekly route days, and coverage zip codes mapped in. Add a row when a new shop joins, edit route_zips when a shop adds a Wednesday route, and the directory updates within the cache window.

Route_day is the column that decides bookings. Pool owners scan for shops whose Tuesday or Thursday route matches their preferred service day. Storing weekly route days per shop turns a scheduling constraint into a search filter that routes leads to shops with actual capacity on the right day.

Pool service is one of the most route-constrained home service categories. A shop running a Tuesday route through one neighborhood and a Thursday route through another cannot pick up a Friday-only customer at the price of a Tuesday-route customer, and most service companies set pricing accordingly. Customers do not know this, and a generic directory does not show it.

SleekRank's per-combination URLs let route days appear in the data so the per-city hub shows shops whose Tuesday route covers the customer's zip. Beyond ranking, saltwater versus chlorine versus mineral systems are three different chemistry profiles, and a shop staffed for chlorine maintenance is not automatically staffed for saltwater. Storing pool_types_served and certifications in the sheet means the directory routes the saltwater customer to a saltwater specialist on the first click, and prices match the actual job profile rather than averaging across types.