Yes. Map wqa_status as a list and contaminant_focus as a list mapping so both render as badge rows. WQA renders with the official credential icon, contaminant focus renders with chemistry symbols and risk-level coloring. Both refresh from the sheet on the cache window when credentials change.

SleekRank groups the installer sheet by contaminant_focus and publishes a hub per contaminant. Add a URL pattern like /water-treatment/contaminant/{slug}/ and the iron, arsenic, PFAS, radon, lead, nitrate, and hardness hubs appear automatically with the matching installers listed.

Yes. The base template includes a JSON-LD LocalBusiness block. SleekRank fills placeholders from the row data including service area, phone, review count, and price range. Per installer rich snippets render in search results from the same source data without separate plugin configuration.

Yes. Add a project_types column with values like residential_well, commercial_well, agricultural_well, municipal_supplement. Add a second URL pattern that includes project_type as a path segment. The directory generates a URL per installer per project type with H1 copy tuned to intent.

Update the wqa_status cell in the sheet. The page refreshes on the cache window with the expired credential removed and the installer drops out of any WQA filtered hub. The badge disappears automatically without a sweep across every related page or hub.

Yes. Add columns for treatment_technologies with values like reverse_osmosis, ion_exchange, oxidation, carbon_filtration, uv_disinfection. Map as a list and render as badges. Buyers comparing treatment systems ask which technology fits their contaminant profile, so surfacing the spec reduces qualification calls.

Yes. The base template supports Gravity Forms and Fluent Forms with hidden fields. The installer slug and service state pass into the form submission so leads land in your CRM tagged with the source page. Form routing rules assign each lead to the matching installer or regional team.

The cacheDuration in the page group config controls refresh frequency. Water treatment directories typically use 86400 seconds for a daily refresh, which is fast enough for new credentials, contaminant focus changes, and state grant program updates without hitting the data source on every page load.