Admin Console
Aug 27, 2026 · 09:41 AM PDT
Analytics Team Console
Full pipeline visibility, merchant drilldowns, lease extraction status, data verification, and system health — restricted to internal staff.
System Health
Total Merchants
47
↑ 9 since Q1 · 41 POS connected
Leases in System
39
29 verified · 7 OCR · 3 pending
Open Risk Flags
14
2 high · 7 medium · 5 watch
Webhook Events (24h)
312
0 errors · 100% ingestion rate
Merchant Registry
All enrolled merchants — full detail
| Business | Category | Monthly rent | Lease expires | POS sync | Verification | Risk | Status |
|---|---|---|---|---|---|---|---|
| El Buen Sabor 2214 Mission St · A |
Food & Beverage | $3,200 | Apr 2026 | Live | ✓ Staff confirmed | Medium | Active |
| Flores Beauty 2248 Mission St · B |
Personal Services | $2,600 | Nov 2027 | Live | ✓ Staff confirmed | Low | Active |
| Tacos Reyes 2290 Mission St · A |
Food & Beverage | $4,100 | Jun 2026 | Partial | ⚠ Unverified | High | Active |
| Barrio Cuts 2301 Mission St · C |
Personal Services | $1,800 | Month-to-month | Live | ⟳ OCR pending | High | Active |
| Avenida Market 2318 Mission St · D |
Retail | $2,950 | Jan 2028 | Not connected | ✓ Staff confirmed | Watch | Onboarding |
| La Farmacia 2340 Mission St · B |
Health & Wellness | $3,400 | Mar 2027 | Live | ✓ Staff confirmed | Low | Active |
Lease extraction queue
3 pending review
Tacos Reyes · 2290 Mission St
Rent adj. unverified
ADA unverified
Barrio Cuts · 2301 Mission St
OCR in progress
New upload · Avenida Market
Queued
Risk event log
Tacos Reyes — lease expiry < 6 months
High
Barrio Cuts — month-to-month tenancy
High
El Buen Sabor — renewal window opens in 8 mo
Medium
Corridor-level rent spike detected
Watch
Flores Beauty — lease renewed · 3 yr term
Resolved
Data Integrity & Pipeline
Verification status
Staff-confirmed records
29 / 39
OCR-extracted (unverified)
7 / 39
Pending extraction
3 / 39
Policy reminder
Unverified OCR records are never used to drive funder-facing reports. Verification state is a first-class field on all lease and survey records.
System configuration
Firestore write guard
corridor_totals · allow write: if false
Rhombus webhook auth
Shared secret — awaiting Paul Martin confirmation
ShowCalculator endpoint
Firebase Functions v2 SDK · Admin SDK write only
URL param spoofing guard
Client-side display only · No browser Firestore writes
Briefing Mode
Partner-facing chart deck · No individual data exposed
OCR auto-write to Firestore
Must route through human confirmation before write
ROI Model Assumptions (Editable)
Corridor Impact Calculator — source assumptions
These values drive the Municipality / Funder projection view. All outputs are labeled "Modeled projection" on the partner dashboard.
Avg annual revenue / biz
$148,000
Retention lift (assumed)
14%
Program cost (annual)
$162,000
Projection window
24 months
Benefit growth rate
log1p(m)
Compounding (M13+)
+$8,000/mo
These are modeled projections, not verified revenue data. The funder dashboard labels all outputs "Modeled projection" automatically. Do not present as live figures.
Ready to deploy the Firestore security rule?
One pending item: allow write: if false on corridor_totals — closes the spoofing vector.
Convoi Cooperative · Analytics / Admin Console · Internal Only · Mock Dashboard