Channel sales dashboard
Five sales and marketing systems normalized into one database, so monthly and investor reporting comes from a single source.
- Functional energy drink brand
- Dashboards
How it fits together
Comes in
- Shopify
- TikTok Shop
- Meta Ads
- QuickBooks Online
- Impact
Runs through
- Node.js sync
- Supabase
Goes out
- Sales dashboard
- Investor reporting
The problem
Every month someone logged into six platforms and rebuilt the same spreadsheet. Channels couldn’t be compared because each one reported revenue differently.
What we built
Shopify, TikTok Shop, Meta Ads, QuickBooks Online and Impact feed one Supabase database. Everything is normalized to one row per channel per day: gross and net revenue, orders, units and cost of goods.
What the team sees
A Next.js dashboard with blended performance, channel breakdowns and margin over time. The next channel has a slot waiting for it.