Yes. Map thx_certs and authorized_brands columns with list mappings so they render as badge rows. THX renders with the official logo file, audio brands render with their respective brand marks. Both refresh from the sheet on the cache window when credentials or authorizations change.

SleekRank groups the installer sheet by authorized_brands and publishes a hub per brand value. Add a URL pattern like /home-theater/brand/{slug}/ and the McIntosh, Sonance, JL Audio, B&W, Marantz, and Anthem hubs appear automatically with their matching installers listed and linked.

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, commercial, marine, automotive. Add a second URL pattern that includes project_type as a path segment. The directory generates a URL per installer per project type, each with its own H1 and copy block tuned to that intent.

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

Yes. Add an acoustic_partners column with values like RPG, Vicoustic, GIK. Map it as a list and render the partner logos in a dedicated template block. Many home theater buyers ask which acoustic specialist their installer works with, so surfacing the partnership clears that question.

Yes. The base template supports Gravity Forms and Fluent Forms with hidden fields. The installer slug and service city 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 team.

The cacheDuration in the page group config controls refresh frequency. Home theater directories typically use 43200 seconds for a twice-daily refresh, which is fast enough for new dealer additions and certification renewals without hitting the data source on every page load.