ECP Sales Dashboard v10

🔌 LEAFLINK API — Orders
Source: Leaflink Orders API → Supabase ETL (auto-refreshed every 6 hours)
Supabase REST API → orders + line_items tables

🔌 LEAFLINK API — Inventory
Source: Leaflink Products API → Supabase ETL (auto-refreshed every 6 hours)
Supabase REST API → products table

🔌 QUICKBOOKS API — A/R Aging
Source: QuickBooks Online API → Supabase ETL (auto-refreshed every 6 hours)
Supabase REST API → ar_aging table

📄 MANUAL UPLOAD — Outfield CRM Notes
Source: Outfield field reports (uploaded by Matt, weekly)

📄 MANUAL REFERENCE — Fridge Tracker
Source: Fridge deployment master workbook (updated on change)

🧮 COMPUTED — Budget & Benchmarks
Source: Budget forecast from Supabase (imported from Excel pro forma)

How data flows: API sources (green) are synced to Supabase every 6 hours via GitHub Actions ETL. Dashboards fetch live data directly from Supabase REST API on page load. Manual sources (yellow) update when Matt uploads new files and runs the import script. | Last loaded: —

Executive Summary

Incl. 24% MI excise tax (P&L / investor view)

Loading live data...

Month Rank

Week Rank

Orders Today

vs Budget

Action Items

Revenue Intelligence

LIVE

Total Revenue

YTD Actual

—

YTD Budget

—

Variance

—

YE Pace

—

Excise Tax (Budget Assumed)

—

Flat 24% of YTD revenue

Excise Tax (Actual)

—

Per-order tax from Leaflink

Variance ($)

—

Budget assumed − actual

Actual Effective Rate

—

vs 24% budget assumption

House Brands (HC, Armada, Pleasantea)

YTD Actual

—

YTD Budget

—

Variance

—

YE Pace

—

Licensed Partners (MJ, UA, CQ, BDL, Feel)

YTD Actual

—

YTD Budget

—

Variance

—

YE Pace

—

Monthly Revenue vs Budget

Category	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Annual
Loading revenue data...

Monthly Revenue vs Budget

Green = House | Blue = Licensed | Yellow dashed = Budget | Red dashed = Pace

Co-Pack Revenue (Buzzn/Buzzin 100) is not tracked in Leaflink — billed separately at month-end. Annual co-pack budget: $2,584,950. Shown on Financial Dashboard only.

Order Lifecycle All data LIVE from API

📥 Submitted

—

currently in queue

→

✅ Accepted

—

currently in queue

→

⚠️ Backorder

—

currently held

→

📦 Fulfilled

—

awaiting shipment

→

MTD Revenue (Shipped + Complete)

— —

🚚 Shipped

—

orders MTD

WTD

—

Today

—

→

✔️ Complete

—

Pipeline Activity

Orders MTD

—

POD MTD

—

On-Cadence Rate

—

Account Penetration

—

A/R Summary

Current (0-30)

—

Past Due (31-60)

—

Overdue (61+)

—

Time-to-Ship Performance

Order placed → Shipped (MTD, Shipped + Complete orders)

—

days

Median

Half of orders ship faster

—

days

Average

Pulled up by slow orders

—

days

P90

90% ship within this

—

orders

Sample

Orders measured

Distribution

Same day1-2d3-5d6-10d11+d

Pending Order Age Distribution

How long current pending orders (Submitted, Accepted, Backorder, Fulfilled) have been in the system

ECP Sales Dashboard

Executive Summary

Revenue Intelligence

Monthly Revenue vs Budget

Monthly Revenue vs Budget

Order Lifecycle All data LIVE from API

Pipeline Activity

A/R Summary

Time-to-Ship Performance

Pending Order Age Distribution

Trend Charts

Revenue Trend (26 weeks)

POD Trend (26 weeks)

Orders per Week (26 weeks)

AOV Trend (26 weeks)

Rep Performance

Rep Scorecard

Customer Intelligence

Collections & A/R

A/R Cash Flow — Scheduled Due vs Actually Paid

Past Due % of Total A/R

Portfolio Strategy

Brand Revenue Trends — Month over Month

Top Product Lines — 13-Week Revenue Trend

Brand Revenue Mix

Fridge Program Analytics

Account Performance

Action Center

Order Blockers ACTION REQUIRED

Inventory Alerts

Priority Actions

ECP Sales Dashboard

Executive Summary

Revenue Intelligence

Monthly Revenue vs Budget

Monthly Revenue vs Budget

Order Lifecycle All data LIVE from API

Pipeline Activity

A/R Summary

Time-to-Ship Performance

Pending Order Age Distribution

Trend Charts

Revenue Trend (26 weeks)

POD Trend (26 weeks)

Orders per Week (26 weeks)

AOV Trend (26 weeks)

Rep Performance

Rep Scorecard

Customer Intelligence

Collections & A/R

A/R Cash Flow — Scheduled Due vs Actually Paid

Past Due % of Total A/R

Portfolio Strategy

Brand Revenue Trends — Month over Month

Top Product Lines — 13-Week Revenue Trend

Brand Revenue Mix

Fridge Program Analytics

Account Performance

Action Center

Order Blockers ACTION REQUIRED

Inventory Alerts

Priority Actions

Flag Item