People Reports
Getting Started
IntroductionNotificationsMy AccountMy ChurchA Child's BibleOn Your PhoneInstall SanctuaryOSFlock
OverviewMembersMember ProfileHouseholdsDashboardCampaignsChildren's ProfilesEngagementImportMerge DuplicatesOnboardingReportsPeople ReportsSteward
OverviewDashboardSessionsNew SessionSession DetailDepositsNew DepositDeposit DetailDonorsDonor ProfilePledgesRecurring GivingOnline GivingGiving PagesImportBulk ActionsStatementsFundsDonor JourneyReportsGather
OverviewDashboardCalendarCheck-In PickerCheck-In ConsoleSelf Check-In KioskAttendance RecordsRecord DetailChildren's Check-InChildren's ConsoleOrder of ServiceRun SheetEventsAbsence AlertsReportsSongsServe
OverviewDashboardTeamsTeam DetailVolunteersVolunteer DetailScheduleTeam SchedulingMy UpcomingSongsSetlistsSetlist DetailAvailabilityMy AvailabilityScreeningConfirmationsVolunteer RequestsReportsCircles
OverviewDashboardGroupsGroup DetailPublic Group FinderLeadersJoin RequestsTake AttendanceAttendanceLapsed MembersUnassignedSmall Group ChatsReportsPeople Reports
FlockPeople Reports answers questions about your people with any people and any columns: who is in no small group, who serves on which team, who changed status this month, who was a member at the end of last year. You filter, group and pivot, save a report, share it, and have it emailed on a schedule. Every figure comes from the People Ledger, the record of every change to a person, so every report agrees with every other, today or as of any date.
Getting Here
Navigation: Flock → People Reports, or the People report tab on Flock → Reports.
Direct URL: /reports/people
Who Can Use It
- Open, run and download: Super Admin, Lead Pastor, Pastor, Reporting Only, Flock Leader and Campus Admin. A Campus Admin opens it without Flock
- Save, share and schedule: the same roles except Reporting Only, which is read-only
- Who is in a report: everyone at your campus. A Campus Admin gets only their campus, and a Flock Leader with a Flock Leader Scope only their own people, on every run, whatever the report's filters say
Which columns you can choose depends on your roles. Profile, custom fields and the ledger are for everyone who opens People Reports. Circles columns are for everyone but a Campus Admin. Gather and Serve columns are for Super Admin, Lead Pastor, Pastor and Reporting Only, and Serve shows a person's screening standing only, never a result. Pathway columns are for the onboarding roles. Care columns are only a count of open care items, never a confidential one and never what an item says. Giving columns exist only for people who can see giving; for anyone else they are not in the list at all, and engagement scores are worked out without the giving part.
The Home Page
| Field | Type | Description |
|---|---|---|
| Your reports | Cards | The reports you saved, each with when it was last run and how many people it had, who it is shared with, and whether it is emailed. |
| Shared with you | Cards | Reports other staff shared with you, with who saved them. |
| Starter reports | Cards | Ready-made reports to open and adjust (below). |
| The People Ledger | Cards | The movement views, the first-time visitor funnel and the event journal (below). |
| New report | Button | Starts a report with Name, Membership status and Campus. |
Starter Reports
- First-time visitors: who came for the first time in the period, in three tabs (first service, first small group meeting, first event), and whether they came back
- Members not in a small group: people counted as members who are in no small group today
- Quiet Time (marker) by group: each attendance marker, Yes when marked at least once in the period, grouped by primary small group
- Volunteers by team: everyone on a Serve team, by team, with how often they served in the period and their screening standing
- Inactive members: members (people on a status that counts as a member) who have attended nothing, no service, small group meeting, event or serving, in 12 months or more, longest unseen first, with their groups and contact details. Change the months and save it; schedule it monthly to have it emailed to the staff you choose
- Lapsed in Circles: people in a small group who missed meetings in the last 90 days and attended none
- Status changes this month: everyone whose membership status changed this month
- Members as of year end: members at the end of last year, on the status and campus they had then, for a statistical return
- People with their groups, teams and markers: members with their custom fields, primary small group, Serve teams and each attendance marker in the last 3 months
Building a Report
Edit report opens the settings beside the results; the results run again as you change them.
| Field | Type | Description |
|---|---|---|
| Who | Filter | Which people. Each filter is a field, an operator and a value: is, is not, is any of, contains, before, after, between, in the period, has a value, has no value, ≥ and ≤, as the field allows. Match ALL or ANY of these, and + Group nests a group of filters (up to four deep). Saved views of the filter can be picked from Saved views. |
| People as of a date | Checkbox | Reports the people as they were at the end of the period, or on a date you pick: who was in Flock then, with the status, category, campus, household and groups they had then. |
| Period | Select | This month, Last month, Last 3 months, This quarter, Last quarter, This year, Last year, Last 30 days, Last 90 days or Custom, on your church’s calendar. Meetings, services, serving, markers, giving and ledger columns count in it; columns that read the period are tagged "period". A saved relative period stays relative, so "Last month" is always last month. |
| Columns | List | Pick columns by area (Profile, Custom fields, Circles, Gather, Serve, Engagement, Pathway, Care, Giving, Ledger), find one by name, and order them with the arrows. |
| Group by | Selects | Up to two fields. Each group shows its count and, for number columns, the total and average. |
| Pivot (counts) | Selects | A table of counts, one field down and one across, for example Category × Status. Click a cell to see its people. |
| Sort | Select | By name, or by any column shown, ascending or descending. |
When a report uses a detail your access does not include, that column is left out for you and a filter on it matches nobody, so you see fewer people, never more; the report says how many parts were left out.
What the Columns Cover
- Profile: every person field, your custom fields, your church's category under its own name, title, household and role in it, and whether they count as a member
- Circles: groups, primary group, role in a group, meetings attended and missed and the rate, each attendance marker (marked in the period, and how often), last attended, prospect since
- Gather: services attended, last attended, weeks in a row, first visit (what and when), children's room, and Last attended anything and Months since last attended: the latest of a service, a small group meeting (attended or walked into), an event check-in and a confirmed serving slot. Months are counted from that, or from when the person was added or your records began if later, so nobody reads as unseen for longer than your records go back
- Serve: teams, roles, times served, confirmed rate, next serving, screening standing
- Engagement: score, band and the parts in use
- Pathway: workflow, stage and days in stage
- Care: the number of open care items
- Giving: for the roles that see giving, counted by the same rule as every Steward figure
- Ledger: status at the end of the period, status changes, became or stopped being a member, added in the period, groups joined or left
Saving, Sharing and Scheduling
- Click Save report and give it a name. It is saved for you
- Click Share to share it with Just me, Roles at my campus (the roles you tick) or Everyone who can open People Reports
- Click Schedule to have it emailed as a spreadsheet, Weekly on a day you choose or Monthly, on the 1st, to the staff you choose
A shared report runs with each viewer's own access: the same definition, with fewer people and columns for someone who may see less, never more. Only its owner changes it; anyone else can Save a copy. A report's last run keeps only when, by whom and how many people, never the result.
Scheduled reports go at 7 AM, your church's time, once on their day. Only staff who can open the report themselves can be chosen (share it with them first), and each gets it built with their own access. Stop emailing it ends the schedule. Nothing is scheduled until someone schedules a report.
Downloads
Download Excel gives an .xlsx with a header block (church, who is included, the filter in words, the columns, the period and the as-of date), subtotals that recalculate as you filter, and a pivot sheet when the report has a pivot. CSV gives the rows, with every cell a spreadsheet would run made safe. A pivot cell's or a figure's people can be downloaded on their own with Download these. Every download, scheduled email and ledger export is recorded in the Activity Log.
The People Ledger
People Ledger on the home page opens its views. Each runs over a period (Last month, This month, Last quarter, This year, Last year or Custom), and every figure opens the people behind it, each with the day and the reason they moved.
| Field | Type | Description |
|---|---|---|
| Membership movement | Table | Per membership status: opening, in by reason (new person, imported, new from a connect card or form, changed in, restored, moved in from another campus), out by reason (changed out, archived, merged, deleted, moved to another campus), closing. It always balances; members are counted by your church’s rule for who counts as a member. |
| Category movement | Table | The same, per category, when your church has categories. |
| Circles movement | Table | Per small group: members at the start, joined, left (with primary-group moves), at the end. Not for a Campus Admin. |
| Serve movement | Table | Per Serve team: on the team at the start, joined, left, at the end. For the roles that see Serve columns. |
| First-time visitor funnel | Table | First contacts by month: came back within 30, 60 and 90 days, joined a group, became a member. |
| Event journal | List | Every change to a person, newest first: day, person, what happened, the group, team or field, from and to, and how it came in (in the app, import, bulk change, connect card or form, background job, merge, or history from before the ledger). Filter by what happened, how it came in, a person or a group or team; Download Excel or CSV. |
The ledger records every change to a person as it happens, from every page, import and bulk change. History from before it started was rebuilt from the Activity Log, and where the log had no old values (an import, a bulk change) one line brings each person to what their record says, so the ledger at today always matches the records. Custom fields are in it only when their Track history option is ticked (Settings → Custom Fields).