ILLUSTRATIVE · DUMMY DATAAs of Oct 28, 2026
Expert acquisition → first task

Find the delay.
Help experts get started.

A growth operations work sample: turn a pipeline export into a prioritized follow-up queue, a realistic staffing plan, and a testable experiment.

Qualified experts waiting 14+ days15336% of 425 qualified records
First tasks completed23413% of 1,799 valid contacts
Records held for review4All duplicate copies excluded

From first contact to first task

Same cohort

First five to review

Review all →

The dataset is invented. This demonstrates how I would find stalled experts, size an opportunity, and test a fix on an authorized export—not results achieved at AfterQuery.

01 / FOLLOW-UP QUEUE

Review the record. Find the reason.

A missing activation event is a signal to investigate. Confirm the cause before sending a reminder.

Days since qualification

Review notes are saved in this browser when storage is available. Export a copy before switching devices.

02 / PIPELINE PERFORMANCE

Compare channels. Keep the denominator.

Compare conversion, time to activation, and recorded acquisition cost. Recent cohorts have had less time to activate.

Weekly contact cohorts

Read cohort counts

Time and cost to activate

Median time includes activated records only. Cost includes all recorded acquisition cost in the channel divided by activations. Sample costs are fictional; missing uploaded costs stay unavailable. “Small n” flags denominators under 30.

03 / CHANNEL STRATEGY

Compare the options. Make the tradeoff explicit.

Start with the sample’s conversion rates. Change a channel’s volume, effort, and cost to see what your assumptions imply.

Rates are conditional: responses / contacts, qualified / responses, and activations / qualified. Default effort uses 2 / 8 / 20 / 10 minutes per contact / response / qualified / activation, with $0.30 tools cost per contact. Labor and nonlabor cost are editable assumptions. Expert compensation is excluded unless added. Persona selection changes qualification guidance, not conversion rates.

Plan a weekly allocation & stress-test assumptions

Each channel’s entered volume is its weekly ceiling. A cost-first feasible allocation is compared with an activation-per-hour allocation; the higher-yield plan is shown. This is a planning heuristic, not a guaranteed optimum. Costs and effort scale linearly.

04 / CAPACITY PLANNER

Set the target. Check the workload.

Work backward from first-task completions using the loaded funnel, then compare required effort with available capacity.

Adjust effort and cost assumptions

Observed means observed in the loaded dataset, including dummy data. Effort is assumed. Capacity excludes response lag, fixed overhead, and expert compensation.

05 / EXPERIMENT PLAN

Size the opportunity. Test before scaling.

Rank one-stage improvements, then design an onboarding pilot with a clear denominator and quality guardrails.

Each scenario changes one stage and holds the others constant across the channel’s contact cohort. Overlapping gains cannot be added. Mathematical upside is not evidence that the intervention will work.

Control → treatment

Current onboarding → a checklist plus one reminder. Randomize eligible experts and follow every participant for 14 days.

Primary metric & guardrails

First-task completion within 14 days / all randomized eligible experts. Track task quality, opt-outs, and operator minutes.

The activation rate for all qualified experts is not a baseline for the stalled cohort. The first pilot tests feasibility. Recovery requires staff time even when no new sourcing is needed.

06 / DATA QUALITY

Check the inputs. Trust the calculation.

Hold every copy of duplicate IDs, invalid dates, missing stages, and invalid costs before calculating the funnel.

Uploads are processed in this browser, never sent to a server. Use record IDs rather than names or contact information. Maximum file size: 5 MB; 20,000 rows.

Definitions and CSV format

Contacted = invitation sent. Responded = any reply. Qualified = meets a documented rubric. Activated = first task completed.

Required columns: record_id, channel, contacted_at, responded_at, qualified_at, activated_at. Optional: acquisition_cost_usd. Use dates in YYYY-MM-DD format. Leave absent events blank.

The sample uses seeded randomness across six channels and 17 weeks. Three error rows are added to 1,800 intended records. Holding both copies of one duplicate plus two other errors leaves 1,799 valid records.

07 / EXPERT DISCOVERY

Define the expert. Find evidence of fit.

Start with the project’s qualification rubric. Research profiles, verify experience, and confirm availability before outreach.

Practitioner sourcing brief

Optional publication research

Crossref finds publication authors, not a verified directory of practitioners. Authorship does not establish credentials, availability, or project fit.

Opens Crossref in a new tab. Publication research is optional; the demo works without external services.

Open Crossref directly ↗
08 / OUTREACH DRAFTS

Make the next step easy to understand.

Prepare a follow-up for the selected record. Review the facts and contact permissions before using it.

Live preview · Export only

No email account, send button, or delivery integration. Fictional records do not represent real people.

A sample workflow