03 / Case study

Church App KPI Tracker

Responsive dashboard for YouTube reach, separate service check-ins, ministry progress, trends, projections, and board-ready exports.

ReactViteApps Script37 tests / 16 files

View repository Back to work

Overview

I built a responsive React/Vite dashboard that gives a church board one place to review YouTube reach, service check-ins, ministry progress, trends, and projections. I kept public reach separate from verified participation so views are not presented as attendance.

Church App KPI Tracker dashboard with Eagle's Ark header, participation check-in, and KPI cards — Dashboard overview / authentic project screenshot

Contribution

I built the dashboard shell, YouTube metrics flow through Apps Script, service check-ins, and board-facing views for trends, projections, CSV export, and PDF/print. I also kept check-in records separate from public reach in the data model and interface.

Export workflowBoard-ready CSV and PDF/print actions support review outside the dashboard.

Separate signalsPublic reach and participation remain distinct in the data model and interface.

Implementation

I used React and Vite for the interface, with Apps Script handling the YouTube integration so the API key stays server-side. I used browser storage for local check-ins and added UI, data, privacy, workflow, and PDF tests.

Church App KPI Tracker trend chart, projection view, and export controls — Trend and board-ready tools / authentic project screenshot

Outcome & Reflection

I finished with 37 tests across 16 files passing, along with typecheck, lint, and the production build. The board-ready CSV/PDF workflow and the separation between reach and participation are decisions I would carry forward; I have not claimed a business outcome because one has not been measured yet.

37 tests / 16 filesUI, data, privacy, workflow, and PDF coverage.

ValidationTypecheck, lint, and production build passing.

Next project

Overview

Contribution

Implementation

Outcome & Reflection

Free Bird