Most churches can tell you how many people visited last Sunday. Almost none can tell you how many of those same people came back the Sunday after, or the one after that. It is not that the number is hard to find — it is that nobody ever writes down the one fact that would let you find it later: who was here, and when.
You do not need a database for this. A spreadsheet, or even a notebook, will get you a real second-visit rate within a month, as long as you are willing to do the same small thing every Sunday and check it every month. Here is the method.
Why this number is worth the trouble
A guest count tells you the room was fuller. It does not tell you whether it was fuller with new people who stuck, or fuller with new people who never came back, replaced next week by an entirely different set of new people. Those are very different churches to be, and they can look identical on an attendance chart. Second-visit rate is the number that tells them apart.
It also tends to surface a truth most teams sense but have never confirmed. Ask a greeter, a pastor, or a volunteer coordinator to guess the percentage of guests who come back a second time, and you will usually get an answer somewhere between confident and wildly optimistic. Write the actual names down for a quarter and the guess is often wrong in the same direction every time — not because the team is dishonest, but because the return visits are the ones people remember, and the ones who vanished are, by definition, easy to forget.
It is also one of the few church metrics that is entirely within your control to define and track without buying anything. You already have the guests. You already have someone at the door who could write their name down. The only missing piece is the habit of checking, a month later, whether the names from last month showed up again.
Set up the sheet before the first Sunday
Open a spreadsheet — Google Sheets or Excel, whichever your team already has open on a normal Tuesday — and give it five columns: name, first-visit date, phone or email if you have it, second-visit date, and notes. That last column matters more than it looks; it is where you write “came with a coworker,” or “sat with the Andersons,” the kind of detail that means nothing on its own and everything when someone is deciding how to follow up.
Add one row per first-time guest, every Sunday, and nothing else. Resist the urge to also track regulars or members in the same sheet — this is a guest log, not a directory, and it stays useful only if it stays small and specific. If your church already runs a simple check-in process at the door, this sheet is just the guest half of it, kept somewhere your team can update by hand.
Decide, once, what a second visit means
Write your definition at the top of the sheet so nobody has to guess later. A reasonable default: a second visit is any Sunday attendance within eight weeks of the first, regardless of whether the weeks in between were skipped. Some churches use four weeks; some use twelve, especially if their guests are more likely to visit monthly than weekly to begin with. The exact number matters less than picking one and using it every time you calculate the rate, so a change in the number reflects a change in guests, not a change in how you counted.
Write down what does not count, too. A guest who comes back the same afternoon for a potluck did not have a second Sunday. A member’s out-of-town relative who visits once for a wedding is not really a prospect at all, and including them will quietly inflate a number that is supposed to tell you something true. The definition only earns its keep if it excludes the cases that would otherwise flatter you.
This is the same discipline behind reading attendance honestly instead of comparing numbers that were never measured the same way twice. A rate you cannot reproduce is worse than no rate at all, because it feels like data while giving you nothing to act on. Write the definition once, tape it to the inside cover of the notebook or pin it to the top row of the sheet, and do not relitigate it every month.
Check the sheet on the same day every month
Pick a recurring date — the first Monday of the month works well — and go down the list of guests from your defined window back. For each name, mark whether they have shown up again since, using your own attendance memory, the greeters’ recollection, or whatever record you already keep. Fill in the second-visit date column where you can. Leave it blank where you cannot, honestly, rather than guessing to make the number look better.
Then do the arithmetic a reader could check themselves: count the guests who first visited in your window, count how many of those have a second-visit date filled in, and divide. A church that welcomed twenty first-time guests in a quarter, with seven who came back, has a second-visit rate of thirty-five percent for that quarter. Write the number and the date you calculated it at the bottom of the sheet, and do it again next month.
Keep every past calculation instead of overwriting the cell. A single number tells you almost nothing on its own — thirty-five percent could be excellent or alarming depending on your church. Four or five months of the same number, tracked the same way, tells you whether a new greeter rotation, a changed follow-up habit, or a new small-group push is actually moving anything, or whether it just felt like it was.
Turn a blank row into a next step, not a data point
The sheet is not just a scoreboard. Every blank second-visit column is a person nobody has reached out to, and that is where the real work is. This is the same territory as the guest-to-member path: a name without an owner and a date tends to sit exactly where it was left. Add two more columns if it helps — who is following up, and by when — and you have turned a passive log into something a volunteer coordinator can actually run a meeting from.
If your church runs a big outreach Sunday — an Easter service, a community event, a VBS week — the same sheet handles the spike, it just fills faster. The discipline of following up after a big Sunday is this exact log, run at higher volume for a few weeks, with the same monthly check afterward to see whether the spike left anything behind.
Where a spreadsheet starts to strain
A hand-kept sheet works well for a church logging a handful of new guests most Sundays. It starts to strain in familiar ways: someone forgets to add a row, a name gets entered twice under slightly different spellings, the file lives on one laptop and the person who owns it goes on vacation, or the follow-up columns quietly stop getting filled in because nobody is reminding anyone to check. None of these are failures of the method — they are the ordinary cost of doing anything by hand, and they show up eventually no matter how disciplined the team is.
SundayBridge exists for churches at that point: a guest becomes a follow-up with an owner and a date automatically, and each person's record keeps a timeline of every visit, so a second-visit rate is a report you read rather than a sheet you reconstruct by hand every month. But the sheet above is a completely legitimate way to learn whether this number matters to your church before you decide whether it is worth changing how you track it.
Start smaller than feels useful
If five columns and a monthly ritual still feels like too much, start smaller. Keep a single running list of first-time guest names in a notebook by the door, and just once a month, read down the list and ask your greeting team which names they have seen again. You will not get a precise percentage this way, but you will get an answer to the only question that actually matters at the start: are the people we welcome coming back, or not. That answer is worth having even before the spreadsheet is built.