LIBERTY CHURCH

Network overview

THIS WEEK

Healthy momentum across campuses

Attendance, first-time guests, giving, and engagement are summarized from the current sample data model.

TREND

Attendance by ministry

CAMPUS HEALTH

Current snapshot

SUNDAY-SATURDAY WEEK

Attendance year-over-year

Use Load Adults + PCO for a read-only accuracy check: Adults from LCDataMain, other metrics from Planning Center.
Total Attendance Adults + Kids + Nursery + Youth
Campus Adults Kids Nursery Youth Served Guests Total Attendance

WEEKEND SNAPSHOT

Campus Details

SERVICE BREAKDOWN

Counts by service

SYNC PREVIEW

Weekly metrics list rows

Preview only. Builds one row per campus/week in the same shape as your LCDataMain CSV without writing to SharePoint.
Future list Title + Wk + Date + A1-A5 + K1-K5 + N1-N5 + Youth1-Youth5 + Guests + Served + Totals
Title Wk Date A1 A2 A3 A4 A5 K1 K2 K3 K4 K5 N1 N2 N3 N4 N5 Youth1 Youth2 Youth3 Youth4 Youth5 GU1 Served Adult_Totals Kids_Totals Nurs_Totals Student_Totals ATT_Totals SyncStatus

PLANNING CENTER CHECK-INS

Guided PCO setup

Start with Step 1. Adults remain manual headcount only.
1
Check the connection Confirms the secure backend can talk to Planning Center.
2
Choose the campus event Load PCO events, then choose the event ID for the selected campus.
3
Fetch rooms Pull PCO rooms for mapped campuses into the room mapping editor.
4
Preview totals Review Kids, Nursery, Youth, and Serving rollups.

STEP 2

Campus event map

For now, map one campus first. Load PCO events, choose the correct event ID for Blue Angel, save, then fetch rooms.

Campus Kids/Nursery/Youth event ID Serving event ID Weekend service name
Only the event map is saved here. PCO credentials stay on the backend.
Advanced backend settings

STEP 3

Room mapping

Each PCO room should be assigned to Nursery, Kids, Youth, Serving, or Ignore. New rooms from PCO appear here as unmapped.

PCO location Assigned category Status

STEP 4

Preview room rollup

0 total
PCO location Liberty category Service Check-ins Source

SERVICE HEADCOUNTS

Weekend input console

Enter adult headcounts quickly after each gathering. Kids, Nursery, Youth, and Serving come from Planning Center.

Ready for LCDataMain

MANUAL ENTRY

Adult headcount

ADULT COUNTS

Adults by service

RECENT INPUTS

Submitted headcounts

FINANCE VISIBILITY

Giving and legacy giving

Finance-restricted view

CAMPUS GIVING

Two-year summary

PREACHING RHYTHM

Pastor schedule

ORGANIZATION CARE

Time off requests

APPROVAL QUEUE

Staff requests

INTEGRATION READINESS

SharePoint field map

Confirm column names before Graph sync

FIELD CONTRACT

Required source columns

Module Liberty Pulse field Source Expected column Status Notes

DATA FOUNDATION

Microsoft 365 Lists integration

MICROSOFT GRAPH

Connection setup

Enter the Tenant ID and Client ID from your Microsoft app registration, then test the sources.

PRIMARY SOURCE

LCDataMain

Most Liberty Pulse metrics will come from your SharePoint list at the LibertyChurchData site.

Open LCDataMain in SharePoint
Tenant libertychurch20.sharepoint.com Site /sites/LibertyChurchData List LCDataMain

NEXT STEPS SOURCE

Next Steps

Next Steps activity will be read from its own SharePoint list so decisions, follow-up, and spiritual growth markers can stay distinct from weekend attendance totals.

Open Next Steps in SharePoint
Tenant libertychurch20.sharepoint.com Site /sites/LibertyChurchData List Next Steps

PREACHING SOURCE

PreachingCalendar

The preaching calendar currently comes from the CampusPastors SharePoint list, with sermon assets in the 2026 Sermon Series folder.

Open PreachingCalendar list Open sermon planning folder
Tenant libertychurch20.sharepoint.com Site /sites/CampusPastors List PreachingCalendar Sermons Shared Documents / Sermon Planning / 2026 Sermon Series

FIELD MAP

Core metrics to map

  • Campus
  • Service date or week
  • Adults attendance
  • Kids, Nursery, and Youth
  • GU1 first-time guests
  • Engagement: served
  • Group attendance
  • Giving and legacy giving

NEXT STEPS MAP

Growth markers to map

  • Person or household
  • Campus
  • Step type
  • Request or decision date
  • Assigned follow-up owner
  • Status or completion stage

SECURITY

Role-based access

Executive Admin: all metrics, finance, users, approvals Campus Pastor: own campus metrics, schedule, requests Ministry Staff: ministry-specific attendance, GU1, and engagement Finance: giving and legacy giving reports

NEXT BUILD STEP

Replace sample data with Microsoft Graph

This prototype is structured so the sample arrays in app.js can become Graph API reads from LCDataMain and Next Steps. The safest production path is Microsoft Entra ID sign-in, Graph permissions scoped to the LibertyChurchData SharePoint site, and a small backend for finance-sensitive queries and audit logs.

Saved