Yes. Define a URL pattern like /water-damage-restoration/{category}/{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 Cat 3 black water Houston across the directory.

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

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

Yes. Store insurance_billing_carriers as a JSON array column listing carriers like Allstate, State Farm, USAA, and Liberty Mutual. A list mapping renders the carrier list on each page, and a per-carrier hub can publish /water-damage-restoration/allstate-billing/ filtered to crews who bill Allstate 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 proper 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 in the directory.

Yes. Store equipment_list as a JSON array column listing items like LGR dehumidifiers, air movers, HEPA filtration, and moisture meters. A list mapping renders the equipment stack, and a per-equipment hub can publish /water-damage-restoration/lgr-dehu/ filtered to crews with LGR equipment in inventory.

Delete the row from the sheet and flush the cache. The crew URL stops resolving and returns 404, the category 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 builder.