A historic homeowner needing chimney rebuild work and a commercial GC looking for a structural retaining-wall mason are running different searches with different stakes. A directory that lists 4,000 brick masons sliced by wall type and historic-restoration credential is the search surface that captures both. Hand-building 4,000 pages from MCAA membership lists and 50 state contractor licensing boards is a multi-year editorial project nobody finishes. SleekRank reads MCAA as the primary source and the state license rosters as overlays, joins them on contractor name and state, and emits one WordPress page per mason at /brick-masons/{slug}/.

The joined dataset is the directory. Add 80 newly licensed masons from the Ohio Construction Industry Licensing Board and the pages go live on the next cache refresh. Update the wall_types column when a mason adds restoration work and the relevant pages pick it up. State license status drives a trust pill that turns green when the license is active, amber when it is within 90 days of renewal, and disappears when it lapses.

Mappings push data into slots. The mason's business name lands in the H1, wall_types drive a badge row, MCAA membership renders an industry-affiliation pill, and address columns populate LocalBusiness schema. The XML sitemap auto-includes all 4,000 URLs and Search Console picks them up on the normal crawl.

Masonry buyers do not search for "masons near me." They search for chimney restoration in a specific historic district, or structural retaining wall work for a commercial site, or lime mortar repointing on a 19th-century facade. The intent is narrow, and the directory that wins the search has to be narrow too. A directory that slices 4,000 masons by wall type, MCAA affiliation, state license, and historic credential captures each intent separately because no aggregator can afford that depth across 50 state boards.

The hard part of building it used to be the maintenance. State licenses renew on their own schedule, MCAA membership rolls over annually, masons retire or merge shops, and the directory drifts out of accuracy the day after launch. SleekRank treats the joined MCAA plus state licensing data as the directory.

You design one base page, map the columns once, and the data layer drives every mason's profile, every badge, every filter, every sitemap entry. License renewals, MCAA changes, retirements, and new credentials flow through automatically. The directory keeps pace with the trade instead of aging out the day it ships, and historic restoration ranks for its own intent without a separate WordPress tree.