Church Operations and Planning Center

Guest to Member Pathway Report

A report that follows first-time guests from their first visit through the follow-up call, the membership class, a group, a serving team, and membership. It shows where people stop, how long each step takes, and which follow-up workflow steps have stalled.

Sample data. All names, organizations, and figures are fictional.

Guest to Member Pathway Report: Pathway: DashboardOpen larger image

About this sample

Most churches can count first-time guests, but few can say what happened to them a year later. This report groups guests by the year they first visited and counts how many reached each next step, using Planning Center People workflow cards, Check-Ins for the membership class, Groups memberships, and Services schedules. It also shows the furthest step each guest reached, so staff can see where most people stop.

The second half looks at the follow-up process itself: median days from first visit to the pastor's phone call by month, open workflow cards by step with past-due counts, and a campus comparison. The PDF version adds short written notes and options for staff to consider.

What it includes

  • Six-step pathway from first visit to membership, by year of first visit
  • Furthest step reached, to show where guests stop
  • Median and 75th percentile days between steps
  • Days to the follow-up call by month against a seven-day target
  • Open workflow cards by step with past-due counts
  • Campus comparison
  • Two-page PDF with plain-English notes
  • Power BI rebuild guide with the key DAX measures

Screenshots

Select an image to see it larger.

More in Church Operations and Planning Center

Weekly Leadership Snapshot

A one-page weekly dashboard for a senior pastor and staff that compares Sunday with the same Sunday last year. It brings attendance, kids check-ins, first-time guests, giving against budget, groups, and serving coverage from Planning Center into one view.

  • Power BI
  • PDF report

Sample data

Giving Analytics Dashboard

A four-page giving dashboard for a church finance team: giving units, recurring share, first-time and lapsed givers, giving bands, fund mix, monthly giving against budget, and a building campaign tracker. It comes with a Power BI rebuild kit that includes the data tables, a theme file, and every DAX measure.

  • Power BI
  • Excel

Sample data