Executive Overview — Department Health
Total Ad Spend (Week)
…
Marketing · Sep 6–12
Total Leads (Week)
…
All sources
NABP Accreditation
…
Warehouse readiness
Licenses in Progress
…
Applications filed
Department Status
📣 Marketing🟢 Live
Loading…
🛒 Purchasing🟢 Live
Loading…
🪪 Licensing🟢 Live
Loading…
📦 Inventory🔵 Building
Connecting data source…
🏭 Warehouse / NABP🟢 Live
Loading…
📈 Sales⏳ Pending
StatusData source not yet connected
Next StepShare Sales sheet link
System Completion — $5,000 Bonus Checklist
📋 Bonus Requirements
All depts mapped & trackedIn Progress
Dashboards functional✅ Partial (5/6 depts)
Trends visible (MoM/YoY)Building
Profitability & ROI measurable❌ Needs financial data
Data accurate & verifiedPartial
Management approvalPending completion
🚀 What Management Can See Now
Marketing spend & leads✅ Live
Purchasing by vendor✅ Live
Licensing state progress✅ Live
NABP accreditation %✅ Live
Sales pipeline KPIs⏳ Pending sheet
Financial / P&L❌ Not yet connected
Marketing — Live KPI Tracker · Sep 2026
Ad Spend (This Week)
…
…
Total Leads (Week)
…
…
Google Clicks (Week)
…
…
Lead → Sales Handoff
…
…
📢 Campaign Spend Breakdown (This Week)
🎯 Lead Sources (This Week)
📱 Social Media
…
💵 Revenue & ROI
Revenue Generated (Marketing-Attr.)TBD — confirm with Sales/Austin
Gross Profit GeneratedTBD — needs COGS from Purchasing
ROAS / ROITBD — Revenue ÷ Ad Spend pending
Customers Acquired YTD1 (East Coast Pharmacy, Aug 31)
CAC (YTD)…
🚀 Campaign Performance (Week)
| Campaign | Spend | Impressions | Clicks / CTR | Notes |
|---|---|---|---|---|
| Loading… | ||||
Purchasing / Suppliers — Order History
Total Spend (All Time)
…
…
Total Orders
…
Unique order numbers
Active Vendors
…
…
Received Orders
…
Payment completion
🏭 Spend by Vendor
📅 Monthly Purchasing Volume
📋 Recent Orders
| Vendor | Date Ordered | Product | Qty | Cost | Status |
|---|---|---|---|---|---|
| Loading… | |||||
⚠️ Metrics Needed (Austin's Requirements)
Gross Margin by Supplier❌ Needs sell price data
Supplier Fulfillment Rate❌ Needs lead-time tracking
Purchase-to-Sale ROI❌ Needs sales cost data
Savings from Negotiations❌ Needs baseline price data
Inventory — VGP Diabetic Supplies
🔵 Data source connected — pulling live inventory. Some metrics require additional tracking setup.
Total SKUs
…
Products tracked
In Stock
…
Units available
Low Stock Items
…
Below reorder threshold
Out of Stock
…
Immediate reorder needed
📊 Austin's Required Metrics — Tracking Status
Inventory Value ($)⏳ Calculating from product data
Inventory Turns⏳ Needs movement history
Days Inventory Outstanding⏳ Building
Sell-Through Rate❌ Needs sales linkage
Expiration Exposure⏳ Expiry dates needed per SKU
Aging Inventory⏳ Needs receive dates
Fulfillment Time⏳ Order-to-ship tracking needed
Shipping Cost / Order❌ Needs shipping data input
Loading inventory data…
Licensing / Compliance — State Coverage
Licensed States
…
Active licenses
Applications In Progress
…
Filed / processing
Not Started
…
No action yet
Total License Types
5
RX · OTC · Non-Ctrl · CS · DEA
📊 Licensing Status Breakdown
📋 License Applications by State
| State | License Type | Status | Assigned To | Notes |
|---|---|---|---|---|
| Loading… | ||||
Warehouse — NABP Drug Distributor Accreditation
NABP Readiness
…
Of all required items
Completed Items
…
…
Remaining
…
In progress or not started
Overdue Items
…
Immediate attention needed
📈 NABP Readiness Trend (Jul–Now)
📍 Facility Details
Facility4554 N 126th St, Butler WI 53007
Designated RepresentativeAmond Tilley
Accreditation TypeNABP Drug Distributor (formerly VAWD)
High-Priority Items…
Status🟢 Nearly Complete
⚠️ Austin's Required Warehouse Metrics — Status
NABP Readiness %✅ Live
Receiving/Shipping Volume⏳ Needs daily log
Order Accuracy⏳ Tracking setup needed
Fulfillment Time⏳ Order timestamps needed
Shipping Cost / Order❌ Needs carrier data
Returns / Damages❌ Tracking not yet set up
Warehouse Productivity❌ Needs labor tracking
Sales — Data Source Pending
⏳ Sales sheet not yet connected. Share the Sales Google Sheet to activate this dashboard.
📊 Austin's Required Sales Metrics — Status
Sales by day/week/month❌ Sheet needed
Orders & Average Order Value❌ Sheet needed
New vs Repeat Customers❌ Sheet needed
Customer Lifetime Value❌ Sheet needed
Lead Volume & Conversion⏳ Partial (from Marketing)
Sales Pipeline Value❌ Sheet needed
Revenue / GP by Salesperson❌ Sheet needed
Win/Loss Rates❌ Sheet needed
Sales by State/Territory❌ Sheet needed
Customer Retention/Churn❌ Sheet needed