Multi-branch revenue and funnel analytics dashboardLive
RichDoc SaaS
A 4-branch analytics platform reconciling 17 months and 23,555 revenue rows into channel attribution, booking funnels, and no-show risk views.
Overview
RichDoc SaaS turns multi-branch revenue ledgers, channel data, and booking funnels into an analytics surface operators can act on.
It reconciles 23,555 rows across 17 months, then exposes branch, channel, treatment, and booking-stage analysis through SQL views and a React dashboard. Google Apps Script, Puppeteer, and Supabase power the repeated collection and weekly reporting loop.
The strength is prioritizing operating signals over decorative charts. No-show hotspots, channel attribution, and branch-level performance sit close to the actions operators need to take.
Core skills
Revenue reconciliation and multi-CRM format integration
Funnel, channel, and treatment-level operations analytics
Automated collection with Google Apps Script, Puppeteer, and Supabase
Implementation
- 1Collected ledgers from Drive and Sheets, normalized duplicates and format drift, then built analysis units with Supabase SQL views.
- 2Built branch, channel, treatment, and booking-stage filters in React, with mobile card views for operators.
- 3Automated weekly WoW reporting and no-show hotspot alerts in an operator-friendly format.
Strengths
- Turns 23,555 revenue rows into reusable branch, channel, and treatment analysis models.
- Automates data collection, blog monitoring, sheet parsing, and 17-month backfill.
- Surfaces operationally actionable signals such as 20%+ no-show hotspots.
Metrics
23,555
rows reconciled
17mo
span
13
views
196
commits
Tech stack
React 19ViteSupabaseGoogle Apps ScriptVercel FunctionsPuppeteerRecharts
Screenshots