Guest-to-Member Funnel
Cohort tracking from first visit through group membership — the number that predicts long-term health.
Cohort tracking from first visit through small-group membership — the single number that best predicts long-term church health.
| Category | Operations |
| Church-health domain | Open the Front Door |
| Data-privacy tier | Medium — guest names + contact, no new sensitive collection |
| Mastery-ladder target | Level 4 · Context |
| Build stack | Planning Center People + Workflows; Make.com; Google Sheets; optional Claude API |
The problem
Most churches lose first-time guests almost immediately and have no reliable way to see it. Hospitality reporting puts average second-visit retention at roughly 6–10%, with growing churches retaining about 21% of first-time guests versus about 9% for non-growing ones — a more-than-2x gap that tracks with overall health. Carey Nieuwhof reports that about 70% of church leaders say they have no effective process for assimilating first-time guests (36% have none at all).
The leak hides because ChMS tools report current pipeline state, not time-anchored cohorts. You can see who's in "Connect" today; you can't see what percent of the guests who first visited in March are in a group by September. That cohort curve is the number worth watching.
What good looks like
Every first-timer is tagged with a first-visit date and routed through a five-stage workflow — Visit → Return → Connect → Group → Member. Each week, stage transitions flow into a sheet keyed by cohort month, and a funnel chart lands in a connections Slack channel. Leadership can finally answer: "Of last quarter's guests, how many are now in a group?"
An honest note on the premise. That "% in a group at six months predicts five-year health" framing is directionally supported but is folk-extrapolation, not a peer-reviewed finding. What is well-sourced: McIntosh & Arn found active new members average ~7 new friends in their first six months while dropouts average fewer than 2; Gallup found members with a best friend in the congregation attend weekly far more often (72% vs. 51%). So early relational connection strongly correlates with retention — the exact predictive multiplier does not.
Market scan
| Tool | Fit | Pricing (verify) |
|---|---|---|
| Planning Center People + Workflows | Captures the 5 stages; no cohort curve | Free |
| Breeze ChMS | Pipeline tracking | From $50/mo flat |
| Church Community Builder | Stage tracking | Custom quote |
| Text In Church | Templated guest follow-up | $31–81/mo |
| Clearstream | Guest texting | Credit-based |
| Subsplash | App + sequences | ~$300–600/mo loaded |
The gap: almost none of these natively shows cohort retention. The DIY value is purely analytical — pull Workflow + Group membership via the Planning Center API into a sheet, compute retention by cohort month, render the chart. No new PII is collected; it's better math on data you already hold.
Data privacy & security
- Medium sensitivity — names and contact info are PII, but you collect nothing new.
- Keep the pipeline inside Planning Center + a controlled Google Sheet; use read-only API tokens.
- Send aggregate counts only (no names) to any LLM, and use the API tier, not a personal chatbot.
How to build it
- Build the 5-stage Workflow in Planning Center People.
- Tag every first-timer with a first-visit date.
- Use Make.com on a weekly schedule to call the Planning Center API and write Workflow + Group status to a sheet keyed by cohort month.
- Compute the % reaching each stage per cohort; chart the funnel.
- Optional: a Claude API call summarizes the aggregated chart into a one-paragraph staff note.
Rollout plan
- Q1: Stand up the Workflow and start tagging. Even without analytics, the discipline helps.
- Q2: Wire the weekly export and the first cohort chart.
- Q3: Watch three cohorts mature; identify the stage where you lose the most people and fix that one.
Effort & cost
- Build: ~10–20 hours for someone comfortable with Make.com; ~1 hr/week oversight.
- Run: ~$15/mo (Planning Center People free + Make.com free–$12 + a few dollars of API).
Sources
- Lifeway hospitality research — https://research.lifeway.com/2025/05/15/6-insights-for-better-church-hospitality/
- Effective Church Group (retention) — https://effectivechurch.com/retaining-first-time-guests/
- Carey Nieuwhof — https://careynieuwhof.com/how-to-a-lose-first-time-guest-in-10-minutes-or-less/
- Gallup, friendship & attendance — https://news.gallup.com/poll/16006/friendship-feeds-flock.aspx
- Planning Center pricing — https://www.planningcenter.com/pricing
Honesty flag: the "predicts five-year health" multiplier is unverified folk wisdom; the friendship-drives-retention correlation is well-sourced. The 21%/9% figures appear in secondary church-consulting sources, not a primary dataset.