Last Mile / Dashboard Prototype — sample data

Dashboard

Single operational view across Metrc, LeafLink, and Sheets.

Label data work
22% → <5% target
Primary metric — within 1 month of rollout
Pre-sale compliance
100% verified
OMMA + OBNDD before fulfillment
Menu staleness
14 min
Under the 20-minute ceiling
P&L coverage
100% of transactions
Labor · costs · returns per order
Label labor, before vs. after
Share of the day spent fixing batch, harvest & test data
Today (manual)
20–30%
With panel
<5%
Compliance status
Customer verification across OMMA + OBNDD
Audit trail on
86% verified 8% expiring soon 6% unverified
Integration health
Metrc ConnectBatch · harvest · test results
Synced
LeafLink BrandOrders & products (webhooks)
Synced
Google SheetsSafe log + tracking · read-only
Connected
OMMA / OBNDD scrapersChange-monitoring active
Watching
Alerts
3 open
OMMA layout change detected — scraper on watch; no silent misses.
12 min ago
2 licenses expiring within 14 days — Tulsa Green Wellness, Moore Skyline.
1 hr ago
Menus refreshed — 142 available products, 6 min ago.
6 min ago

Label generation

Batch numbers, harvest dates, and test results pulled straight from Metrc — no copy/paste in the happy path.

BatchProductHarvest dateTest resultLabelsStatusAction
B-2417Northern LightsAug 18, 2026Passed48Draft
B-2418Blue DreamAug 19, 2026Passed32Ready
B-2419OG KushAug 21, 2026PendingAwaiting results
B-2420Wedding CakeAug 22, 2026Passed64Printed

Compliance automation

Every LeafLink customer cross-checked against OMMA + OBNDD before sale. Unverified or expired accounts are flagged or blocked.

OMMA portal layout changed. Scraper is on change-monitoring watch; verification continues against cached results while we re-target. No silent misses. View audit log →
CustomerOMMAOBNDDLast checkedStatusDetail
Tulsa Green Wellness
License OK-2024-1182
Valid Registered Today, 08:14 Verified
OKC Herbal Collective
License OK-2024-0947
Valid Registered Today, 08:14 Verified
Moore Skyline Wellness
License OK-2024-0771
Expires in 9d Registered Today, 08:14 Expiring
Norman Bloom Supply
License OK-2025-0019
Unverified Today, 08:14 Unverified
Lawton Prairie Herbal
License OK-2023-1445
Expired Revoked Today, 08:14 Flagged — blocked

Live menu

Available-product menu that updates automatically. Updated 6 min ago · under the 20-min ceiling

ProductCategoryBatchTHCPriceStockAvailability
Northern LightsFlowerB-241719.4%$2,400 / lb48Available
Blue DreamFlowerB-241817.1%$2,150 / lb32Available
OG Kush CartridgeVapeB-241982.6%$18 / unit1,240Low stock
Wedding CakeFlowerB-242021.8%$2,600 / lb64Available
Sour Gummies 100mgEdibleB-241210mg / pc$14 / unit640Available
Dark Chocolate 50mgEdibleB-24095mg / pc$12 / unit0Out of stock

Transaction-level P&L

Labor, costs, and returns for every order leaving the building — joined from LeafLink orders and the existing Sheets.

Sheets connected · read-only
Gross revenue (month)
$482,410
Labor
$96,480
COGS + returns
$241,205
Net margin
30.0%
$144,725 net
OrderCustomerRevenueLaborCOGSReturnsNet
ORD-10482Tulsa Green Wellness$8,400$1,120$4,200$0$3,080
ORD-10481OKC Herbal Collective$12,900$1,540$6,450$600$4,310
ORD-10480Norman Bloom Supply$6,200$890$3,100$0$2,210
ORD-10479Broken Arrow Leaf Co.$9,750$1,240$4,875$0$3,635
ORD-10478Stillwater Botanics$4,100$610$2,050$0$1,440

Sheets stay the system of record — the panel reads the safe log and tracking spreadsheets without replacing them.

CRM map & heatmap

A LeafLink-style customer map — territory rep, account dots, last purchase, and recency — with 30/60/90-day tiers.

Territory rep
Territory map
Current LeafLink customer visualization (reference)
≤30d 31–60d 61–90d >90d cold
LeafLink customer mapping reference
Reference: the client's LeafLink customer map. The panel rebuilds this view with client-managed recency heat tiers.
Top accounts by recency
Tulsa Green Wellness
Last order 4d ago · Dana Ruiz
OKC Herbal Collective
Last order 11d ago · Marcus Lee
Norman Bloom Supply
Last order 47d ago · Jordan Wells
Broken Arrow Leaf Co.
Last order 72d ago · Dana Ruiz
Stillwater Botanics
Last order 118d ago · Marcus Lee

Outreach

Email and text to accounts, with open tracking on both channels.

New message
Recipient
Channel
Subject
Message
Recent sends
Open tracking on
Email to Tulsa Green Wellness
"Fresh Northern Lights back in stock" · 92% opened · 41% replied
SMS to OKC Herbal Collective
"OG Kush cartridges restocked" · delivered · 3 replies
Email to Norman Bloom Supply
"October menu now live" · 61% opened

Inventory aging

Aging product is auto-discounted at your threshold, so it moves without manual price edits.

Age threshold
days
Auto-discount
Products past threshold are discounted automatically.
ProductBatchAgeStatusPriceDiscountAction
Sour Gummies 100mgB-241234dFresh$14 / unitNone
Dark Chocolate 50mgB-240958dApproaching$12 / unitNone
Pineapple ExpressB-240174dOver threshold$2,050 / lb15%Auto-discounted
GelatoB-239891dOver threshold$2,300 / lb20%Auto-discounted

Users & roles

Six built-in roles. Access is granted by role only — enforced server-side on every module.

UserRoleTerritoryStatus
Jeff Caldwell
jeff@intellivega.com
AdminAllActive
Dana Ruiz
dana@calvindistro.com
Sales repNorthActive
Marcus Lee
marcus@calvindistro.com
Sales repCentralActive
Priya Shah
priya@calvindistro.com
ComplianceAllActive
Role → module matrix
Built in, enforced server-side
ModuleAdminOps/LabelComplianceFinanceSales mgrSales rep
Label generation
Compliance
Live menuView
P&L & Sheets
CRM map & heatmapOwn territory
OutreachOwn territory
Inventory aging