ECP Command Center

Emerald Canning Partners — Admin Dashboard
Sales Finance Production Schedule GitHub
Loading system status...
Good morning, Matt
Revenue Pulse
...

🎯 Priority Actions

Auto-generated from live data — ranked by urgency × dollar impact

Analyzing data...
...
Pipeline
...
Past Due A/R
...
Orders Stuck 72h+
...
Accounts At Risk

⚡ Recent Alerts

Loading...

🔗 Quick Links

Sales DashboardRevenue, reps, customers → Finance DashboardA/R, P&L, collections → Production ScheduleRuns, capacity, Lume → LeaflinkOrders, products →
...
Pipeline Value
...
MTD Revenue
...
Past Due A/R
...
Active Alerts (Today)

📦 Order Pipeline

Loading...

💰 A/R Aging Summary

Loading...

⚡ Recent Orders (Last 7 Days)

Loading...
...
MTD Revenue
...
Budget Target
...
Variance
...
Projected Pace

📊 Budget vs Actual (Monthly)

Loading...

📈 P&L Summary (Latest)

Loading...

📅 Monthly Revenue Trend

Loading...

📋 Demand Letter Pipeline

Loading...

📈 Past-Due A/R Trend (90 Days)

Weekly total of all 31+ day balances

Loading...

⬆️ Tier Movement (Getting Worse)

Accounts that moved to a higher aging tier since last snapshot

Loading...

📊 Collections by Tier

Loading...

📊 Customer Health Summary

Loading...

⚠️ At Risk & Churned

Loading...
...
Revenue at Risk
Lifetime rev of at-risk + churned

🔄 Win-Back Opportunities

Churned accounts with $20K+ lifetime revenue

Loading...

🆕 New This Month

Accounts whose first order is in the current month

Loading...

🔴 Accounts Needing Attention

Accounts with no orders in 60+ days, sorted by lifetime revenue (highest value at risk first)

Loading...

🔔 Blocker Alert History (Last 30 Days)

Loading...

👥 User Accounts

Manage who can access ECP dashboards and what they can see.

viewer
Sales dashboard only
manager
Sales + Finance + Schedule
admin
Everything + Command Center
Loading users...

➕ Create New User

🔄 ETL Sync Status

Loading...

📈 Database Stats

Loading...

📋 ETL Run History (Last 7 Days)

Loading...

🌐 Infrastructure

Dashboardsdashboards.emeraldcanningpartners.com
DatabaseSupabase (PostgreSQL)
ETLGitHub Actions (every 6h)
Blocker Monitor8am + 2pm ET weekdays
AuthSupabase Auth (per-person, role-based)
Repommcalpine6/ecp-Dashboards