SleekRank reads any CSV or Google Sheet you point it at, so the workflow is: download the latest PHIUS Certified Consultant roster CSV from phius.org, drop it into the configured path, and trigger the cache refresh. PHIUS does not publish an open API, so the import is a manual quarterly step that takes about two minutes.

Use two page groups with different urlPatterns, one at /passivhaus-consultants/{slug}/ reading the PHIUS CSV and another at /passivhaus-designers/{slug}/ reading the PHI export. Both share the same WordPress base page if the layout suits both, or you can build separate base pages with different credential-specific copy.

The PHIUS roster shows only active certifications, so when the next CSV import runs, lapsed consultants no longer appear in the source data. SleekRank stops rendering their page on the next cache cycle. For history, keep an archive table or flip a status column to lapsed and use a meta mapping to noindex the page instead of removing it.

Yes. PHIUS publishes certified project counts per consultant in the same roster. Add a projects column and a projectTypes column (single-family, multifamily, retrofit, commercial) and use a tag mapping for the count plus a list mapping for the types. Most directories sort or filter on these to highlight consultants with more completed work.

Pair the page group with a SleekPixel template that takes name and certification class as parameters. Each consultant page gets a unique OG image showing 'Sarah Chen, PHIUS+ Rater, Seattle WA' rendered against the firm's brand template. Social shares and SERP image cards then carry the credential plus location combination.

Add rows to the source CSV or sheet for in-house consultants the firm has trained outside the formal PHIUS pathway, with a different value in the certClass column (such as 'In-House Trained'). The page renders the same way, and you can use mapped conditional copy or template logic to display a different credential line for non-PHIUS rows.

The PHIUS find-a-pro tool is one search page that returns filtered results. SleekRank gives every consultant a permanent, indexable WordPress URL on your domain, which Google can crawl and rank for 'Passivhaus consultant Seattle' style queries. The PHIUS tool drives traffic to phius.org, your SleekRank directory drives that same traffic to your site.

Passive House Institute publishes the global PHI Certified Designer database separately. Pull both rosters (PHIUS for North America, PHI for global) into a single sheet with a credentialBody column, and SleekRank renders both under the same /passivhaus-consultants/{slug}/ pattern. Use the credentialBody field to differentiate copy or styling per row.