Yes. Define a URL pattern like /smoke-damage-restoration/{damage}/{metro}/ and SleekRank renders a page per combination from the sheet. Each combination gets its own H1, list of qualified crews, and meta tags, which is what ranks for queries like wildfire smoke restoration Sacramento across the entire directory.

Store iicrc_fsrt_status as a column with values like certified, master, or expired. A selector mapping injects the FSRT badge on each page, and the per-damage hubs can filter on this flag so only properly certified crews appear in listings across the directory by metro and damage type combination.

Edit the iicrc_fsrt_status column to blank or expired and flush the cache. The badge disappears, the per-damage hubs drop the listing, and the sitemap regenerates on the next cache refresh. The IICRC roster stays the source of truth, so insurance adjusters never book from a stale certification claim.

Yes. Store insurance_billing_carriers as a JSON array column listing carriers like State Farm, Allstate, USAA, and Liberty Mutual. A list mapping renders the carrier list on each page, and a per-carrier hub can publish /smoke-damage-restoration/state-farm/ filtered to crews who bill State Farm directly.

Each generated URL is a real WordPress page with full HTML and ships in the auto-generated XML sitemap. The base template is auto-noindexed. Google treats each crew URL as a distinct page with its own canonical, Open Graph metadata, and LocalBusiness schema markup for structured data display.

Yes. SleekRank uses an existing WordPress page as the template, so Bricks, Elementor, Gutenberg, Oxygen, and classic themes all render through the mapping layer without rewriting the directory design from scratch or migrating any brand-layer styling work currently deployed.

Yes. Store equipment_list as a JSON array column listing items like ozone generators, thermal foggers, HEPA filtration, and air scrubbers. A list mapping renders the equipment stack, and a per-equipment hub can publish /smoke-damage-restoration/ozone-treatment/ filtered to crews with ozone equipment.

Delete the row from the sheet and flush the cache. The crew URL stops resolving and returns 404, the damage and metro hubs update to omit them, and the sitemap regenerates. For planned closures, redirect the slug to the relevant metro hub to preserve link equity across the directory.