Case Studies
Real projects, real outcomes. From 9M-order dashboards to unified multi-CRM pipelines — see the work and the results.
Delivered. Measured. Verified.
Every case study is a real engagement with documented outcomes.
Hospitality & ExperiencesFrom Attribution Chaos to Marketing Clarity
How a wellness retreat discovered its Facebook ROAS was 70% higher than reported — and why a 27% revenue drop had nothing to do with ad creative.
Housecall Pro
REST API
GoHighLevel
Marketplace API
Google Apps Script
No server · No middleware
Google Sheets
Master Data Store
Looker Studio
Live Dashboard
Two CRMs. One Master View. Zero Middleware.
A Google Apps Script pipeline that unified Housecall Pro and GoHighLevel into a single Looker Studio dashboard — 15,149 records synced on first run, 0 SaaS fees added.
New Leads
186
▲ 12% vs last mo
GoHighLevel
Book Rate
42%
▲ 4 pts vs last mo
GHL + HCP
Jobs In Progress
34
Housecall Pro
Estimates Written
$128K
▲ 9% vs last mo
Housecall Pro
Completed Revenue
$94K
▲ 7% vs last mo
Housecall Pro
AR Outstanding
$21K
▼ 2% vs last mo
Housecall Pro
Lead Pipeline
GHLWIP by Job Type
HCP34 active jobs total
Book Rate Trend
GHL▲ +4 pts month-over-month
Leads by Source
GHLCompleted Revenue (30d)
HCPAR Ageing
HCPTotal: $21,000
Estimates Written vs Closed (30d)
HCPWritten
Closed
Active WIP Trend
HCP5 Dashboards on 9 Million Orders
A full replacement of a legacy Looker extension — rebuilt in React + TypeScript with 99% fewer API calls and custom chart rendering.