Per-tech revenue, jobs, avg ticket, close rate, Ramp COGS margin. Read-only. Revenue on job_status='completed' only.
💎
Implications (per memory rule 1)
🎯 Bucket touched
Pure ST + Migrated (ST-era jobs only)
⚠️ Problem
sold_by_id ≠ technician_id. Some techs (Kalen) can't log into ST so their work shows under wrong tech or empty per CLAUDE.md memory.
💰 $ at stake
Mis-credited revenue = wrong commission decisions. Kalen's work invisible if not corrected.
✅ Action unlocked
Use sold_by_id field with Ashton-creates-Kalen's-estimates rule applied. Cross-check with Ramp.
📊 Full bucket diagram + 4 data-integrity findings: BSP HCP Intelligence Report (📊 The Buckets · 📅 Timeline · 💸 LTV · 🔍 Why this matters · 🎯 The 4 Findings)
Total Revenue
...
Completed Jobs
...
Avg Ticket
...
Gross Margin (net of Ramp)
...
Ramp COGS Applied
...
Loading data quality...
Tech Performance (click headers to sort)
Tech
Revenue
Jobs
Avg Ticket
Sold
Dismissed
Close %
Ramp COGS
Margin $
Margin %
Status
Loading...
Benchmarks: ST industry close rate 39.2%. Pills show above / below. Kalen is not in ST so his sales show under Ashton or blank. Ramp COGS uses titan.ramp_transactions.st_technician_id. Techs with no Ramp mapping show Not captured yet (null margin %), not zero margin.