ShotVet
Veterinary operations analytics for a multi-clinic group — from manual Excel exports to live, cross-channel dashboards.
Headline outcome
10x
Faster onboarding
SigmaLookerThe challenge
Where they started.
A multi-clinic veterinary group with no technical team, no data ownership, custom Looker and Google Sheets reports without underlying pipelines. Marketing data disconnected from commerce. KPIs weren't standardized for their business model. Every clinic manager had their own spreadsheet with 'the real numbers.'
The approach
What we actually built.
01
Unified data ingestion
Airbyte for CRM and commerce, custom Python in Airflow for the edges. First time the clinics had continuous sync.
02
Marketing unification
Hubspot CRM data piped to warehouse; audiences pushed back out to Google Ads via Hightouch. Closed the loop.
03
dbt transformation
Built the warehouse layer with KPI definitions specific to the veterinary business model. Tests on every metric.
04
Org-wide Sigma reporting
Every clinic and central ops team on the same dashboard, same definitions, same numbers.
Results
The numbers that shifted.
10x
Faster clinic onboarding to analytics
+65%
ROI boost on marketing
0
Manual spreadsheets in reporting