Yes. Certifications stored as a JSON array column where each entry has vendor, name, level, year_earned, and credential_id. A list mapping renders one badge per certification on the consultant page, and credential_id can link to the vendor's verification page for one-click validation.

Use a stacks JSON array column. The consultant appears on every stack hub they are certified on (Salesforce, HubSpot, Outreach), and the personal page lists all stacks. There is no need to duplicate the roster row, so a new cert propagates across every hub at once.

Each cert in the JSON array has an expiration date. A scheduled task flags expiring certs in the next 60 days. Expired certs render as expired or hide automatically based on a visibility flag, and the consultant drops from hubs that require the expired credential.

Each generated URL is a real WordPress page with full HTML, sitemap inclusion, and per-page meta mappings. The base template is auto-noindexed so it never competes with the children. Indexing typically lands within a few crawls of the sitemap update.

Yes. Motion is a single-value column (PLG, sales-led, hybrid, enterprise, ABM). It drives a selector mapping that flips the case-study block in the template based on the motion, and hub URLs like /revops/salesforce/plg/ filter by motion plus stack.

Yes. Engagement type is a column (project, fractional, interim, advisory, full-time contract). Hubs can filter on engagement type, so /revops/salesforce/fractional/ surfaces only consultants available for fractional executive work. Buyers searching by engagement model find the right consultants.

Yes. A case_studies JSON array stores anonymised engagement summaries (industry, scope, MQL-to-SQL lift, pipeline lift, time-to-impact). A list mapping renders the case studies on the consultant page filtered by the industry or motion the visitor is browsing.

Yes. SleekRank uses an existing WordPress page as the template, so Bricks, Elementor, Gutenberg, Oxygen, and classic themes all work because the rendering happens on the page output. The directory inherits whatever the firm's site already looks like.