Attendance

What a rolling attendance average is and why it matters more

One Sunday tells you almost nothing. Here is how the 4-week and 13-week averages actually work.

6 min read

Ask AI · in the $19/mo plan

Ask your own records a question. Is attendance actually trending down, or was that one week?” — answered from the records you already keep. It reads your church and no other, and it can't invent a number.

10 questions a month included · no AI add-on to buy

Somebody asks how attendance is doing, and the honest answer is almost never a single Sunday. Last week could have been up because the weather broke, or down because half the youth group was away at a tournament. Treat either as the answer and you will spend the year reacting to noise instead of watching what is actually happening.

The number worth watching is the rolling average — a small set of recent Sundays, averaged together, recalculated every week. It is not a complicated idea. It just takes some getting used to, and it changes what you say in a board meeting once you start using it.

If you want the number rather than the theory, paste your own weekly counts into the free attendance tracker and it will work out the average, the trend, and the high and low Sunday for you — no signup, and nothing you type leaves the page.

What “rolling” means

A rolling average moves. It is not the average of a fixed period like “this quarter” that resets on a calendar date. Instead, every week you drop the oldest Sunday out of the window and add the newest one in, so the window is always the same size and always current. A four-week rolling average calculated today is the mean of the last four Sundays. Calculated next week, it drops this week's oldest Sunday and picks up the new one. The window slides forward, one week at a time, forever.

That sliding is the whole point. A quarterly average tells you how the quarter went, after the fact, once the quarter is already over and there is nothing left to do about it. A rolling average tells you where things stand right now, today, using the most recent stretch of weeks as the lens. You never have to wait for a period to end to know how you are doing — there is a current answer every single Sunday, and it is only ever a week old.

It also has a plainer name in most people's heads: a moving average. Weather forecasters, retailers, and anyone who tracks a number that bounces around week to week use the exact same trick. Church attendance bounces around for reasons that have nothing to do with the health of the church — a long weekend, a snowstorm two counties over, the county fair — and a rolling average is the simplest tool available for seeing past that bounce to whatever is actually underneath it.

Why one Sunday tells you so little

Say a church of 140 runs 132, 148, 121, and 139 across four ordinary Sundays. Nothing happened in that church. Nobody left, nobody joined in any meaningful number. What happened is a normal spread of weather, sports schedules, a stomach bug going around, and a long weekend. The range from 121 to 148 is a 22 percent swing on numbers that are, underneath, flat.

If you report the 121 alone, you sound like you are declining. If you report the 148 alone, you sound like you just had a great month. Neither is true. The average of those four Sundays is 135 — close to where the church actually sits. That is the number a board, a search committee, or a denominational report should see, not whichever Sunday happened to fall in the reporting window.

The four-week window: what it's for

A four-week rolling average is short enough to feel current. If attendance genuinely starts sliding — not one bad Sunday but a real shift — the four-week average will show it within a month, while a raw week-to-week glance would still be arguing about whether last Sunday was “just the weather.”

It is also short enough to still carry some seasonal noise. Four Sundays in early September, when school just started and travel is winding down, will look different from four Sundays in July almost no matter what the church is doing. The four-week average smooths weekly noise; it does not smooth seasonal noise. For that you need a longer window.

The 13-week window: what it's for

Thirteen weeks is roughly a quarter of a year, and it does something the four-week average cannot: it absorbs most of a season inside itself. A 13-week average that includes both the slow tail of summer and the busier run into fall is less likely to be fooled by either. It moves slowly, on purpose. A single unusual month barely nudges it, and a single unusual Sunday inside that month barely nudges it either — which is exactly the point. You are trading responsiveness for stability, on purpose, because the question you are asking with this number is a slower one.

That slowness is a feature, not a delay. The 13-week number answers a different question than the four-week number. The four-week average asks, “what is happening lately?” The 13-week average asks, “is this a season, or has something actually changed?” A four-week dip that the 13-week average barely registers is probably a rough month. A four-week dip that the 13-week average is starting to follow is worth a real conversation.

Reading the two together

The useful move is not picking one window, it is watching both at once. When the four-week and 13-week averages sit close together and move together, the church is in a stable stretch, up or down. When the four-week average pulls noticeably away from the 13-week — climbing above it or falling below it — that gap is the earliest honest signal you will get that something is shifting, well before it would show up as an obvious trend in a raw attendance chart.

It is worth remembering that seasons repeat. The honest comparison is not this month against last month; it is this September against last September. A rolling average smooths the weekly and even monthly noise, but it will still dip every summer and climb every fall if your church does that every year. Read the shape against itself, year over year, before you read too much into any single slope.

What the average can't tell you

A rolling average, however carefully chosen, is still a headcount. It cannot tell you whether the 135 people in the room this month are the same 135 who were there in March, or a completely different set who happen to add up to a similar total. A church can hold a flat average for a year while quietly losing longtime attenders and gaining new ones at close to the same rate — and the average will never flinch. That kind of churn only shows up at the level of the person: someone who used to be there every week and has now missed three in a row. The rolling average is where you look for the shape of the crowd. Following an individual guest's path is where you look for what is actually happening to the people inside that shape.

The same caution applies in the other direction. A rolling average can also make a genuine bright spot look like nothing, if you only glance at the number instead of asking who is behind it. A flat four-week average can be hiding real growth — a wave of new families arriving right as a handful of longtime attenders move away for work or retire out of state. The total looks unchanged. The church underneath it does not feel unchanged at all to the people living through it. That is exactly why the average is a starting question, not a finishing one.

SundayBridge charts your attendance against its own history, so the rolling average is something you see on the dashboard rather than something you build in a spreadsheet by hand. You can add or edit each gathering with a named roster or a simple headcount. It still does not run check-in at the door or print labels.

Putting it in front of a board

If you take one habit from this, make it this: stop leading with a single Sunday's number in any report meant to describe how the church is doing. Lead with the rolling average, name the window you're using (“the four-week average is 138, the 13-week average is 131”), and let a board member ask about a specific Sunday if they want to. That order — average first, single week second, if at all — is the difference between a report people trust and a report people learn to discount because it swings so much from month to month. It is a small change in habit, and it is one of the more useful ones a weekly admin rhythm can build in.

Frequently asked questions

What is a rolling average, exactly?
It is the average of the most recent set number of Sundays, recalculated every week. A four-week rolling average on the third Sunday of March is the mean of that Sunday plus the three before it. Next Sunday, the oldest week drops off and the newest one joins. It moves forward one week at a time, always looking at the same size window.
Why four weeks and not two, or eight?
Two weeks is barely more than a single Sunday, so it still swings with the weather. Eight weeks is slow to reflect a real change, so you find out late. Four weeks is short enough to react to and long enough to smooth out normal variation. It is a starting point, not a law — some churches prefer six.
Should we use the rolling average or the raw count for our annual report or board meeting?
Use both, but lead with the average. The raw count for a single headline Sunday (Easter, a dedication, a big baptism day) is a fair thing to celebrate on its own. For anything about the health or direction of the church — the number a board should act on — the rolling average is the honest number, because it is not distorted by whichever Sunday you happened to pick.
Does a 13-week average replace the 4-week one, or run alongside it?
Alongside. The four-week number tells you what is happening right now — this month, this stretch. The thirteen-week number, roughly a quarter, tells you whether that stretch is a blip or a season. When the two agree, you can be fairly confident in what you are seeing. When they disagree, that disagreement is itself useful information.
Can a rolling average hide a real problem?
Yes, in one specific way: it can mask churn. A steady total can conceal new people arriving while a quiet trickle of regulars stops coming, and the average will look fine for months before it finally moves. The average tells you the crowd size is stable. It does not tell you whether it is the same people. For that you have to look at individuals, not the trend line.