Needs Attention
Live
--
Pending Orders
--
Queue Failures
--
Errors (24h)
--
MC API (Month)
Today
Quizzes
--
Searches
--
Paid Reports
--
Revenue Today
--
Revenue
This Week
--
This Month
--
All Time
--
Recent Activity
Loading activity...
R2 Photo Ingest (24h)
Loading\u2026
Customer Feedback
No feedback yet
Admin Audit Log
Loading...
System Health
Scheduled Tasks
VIN Tracker
Checks sold status of negotiated VINs via recents API
Last Activity
--
VINs Sold
--
Pending Check
--
Schedule
Manual trigger
Quick Actions
Error Log
Loading...
Business Metrics
Total Sessions
—
Paid Reports
—
Conversion Rate
—
Est. Revenue
—
Funnel
Loading...
Tier Distribution
Loading...
Activity (Last 7 Days)
Loading...
Report Queue Health
Pending
—
Completed
—
Failed
—
Success Rate
—
Sold VIN Tracker
VINs Tracked
—
Avg Savings
—
Avg Days to Sell
—
FFP Accuracy
—
Total Sessions
—
Pending Release
—
Released
—
Instant
—
Show:
Loading sessions…
Human-Assisted Orders
Trail Boss and Wrangler orders that need your action.
Total Orders
—
Awaiting Action
—
In Progress
—
Delivered
—
Show:
Click Refresh or switch to this tab to load orders.
Tier Pricing & Stripe URLs
Negotiation Package ($49) · data-fp-tier="listings"
Scout ($99) · data-fp-tier="scout"
Trail Boss ($199) · data-fp-tier="trail_boss" · legacy: scout_pro
Saves to both
scout_pro_* (legacy) and trail_boss_* (current) keys for backward compat. Expert Curation Add-On ($100) · data-fp-tier="scout_addon"
Wrangler ($499) · data-fp-tier="concierge"
Site Settings
Send History
Loading send history...
Templates
Templates are stored in Supabase and fetched at send time. Use {{variable}} for dynamic values. Changes go live on the next email send — no redeploy needed.
Instant
Results Email
Sent after free quiz completes
›
{{first_name}}
{{car1_name}}
{{car1_year}}
{{car1_price}}
{{ai_summary}}
{{results_url}}
24hr
Decision Guide Upsell
Sent 24 hours after results
›
{{first_name}}
{{car1_name}}
{{zip}}
{{results_url}}
{{guide_price}}
{{scout_price}}
72hr
Human Wrangler Upsell
Sent 72 hours after results
›
{{first_name}}
{{car1_name}}
{{zip}}
{{concierge_url}}
{{scout_pro_price}}
{{concierge_price}}
Manual
Report Ready
Sent when you release a pending session
›
{{first_name}}
{{tier}}
{{top_car}}
{{report_url}}
Vendor Stack & Usage
Track spend, plan limits, and upgrade triggers across the stack. Update monthly or when things change.
Under 60%
60–85%
Over 85%
Monthly Burn
$0
Annual Fixed
$0
Next Upgrade Trigger
—
Stripe
Payments
MarketCheck
Car Data API
0 calls500 / mo
Supabase
Database & Auth
0 MB500 MB
NetlifyV2 API
Hosting & Deploy
0 GB100 GB BW
ResendV2 API
Transactional Email
0 sent100 / day
Cloudflare
DNS & CDN
GoDaddy
Domain Registrar
Zoho
Business Email / CRM
Anthropic
AI / Claude
Pending Reports
Reports that failed Phase 2 and need retry or manual delivery. Customers are waiting.
Loading queue…
Cost Sheet
What each product costs the buyer, what it costs us to deliver, and how many workflows fire per flow.
Product Pricing
| Product | Buyer Pays | Our Cost | Margin | Edge Fn Calls | API Calls |
|---|---|---|---|---|---|
| Quiz + Guide | Free | ~$0.05 | -$0.05 | 3 | 1 Claude + 3 MC + 3 MPG + 3 NHTSA |
| Free Search | Free | ~$0.01 | -$0.01 | 1 | 1 Claude + 1-2 MC + 1 MC Facets |
| Negotiation Package | $49 | ~$0.04 | $47.24 | 2 | 1 Claude + 1 MC Price + 1 MC VIN History |
| Scout | $99 | ~$0.08 | $95.75 | 4 | 2 Claude + 2 MC + 1 MC FSBO + 1 MC Price + 1 MC VIN |
| Trail Boss | $199 | ~$0.09 + 15-30 min | ~$193 | 2-3 | Same as Scout + human curation |
| Wrangler | $499 | ~$0.12 + hours | ~$493 | 3+ | Same as Trail Boss + trade-in + dealer negotiation |
| Trade-In Estimate | Free | ~$0.002 | -$0.002 | 1 | 1 MC Inventory Search + NHTSA VIN decode |
| VIN Direct | Free preview | ~$0.01 | -$0.01 | 1 | 1 MC VIN Search |
Margin = buyer price - API cost - Stripe fee (2.9% + $0.30). Free tiers are acquisition cost.
Flow Chains
Quiz → Guide (Free)
quiz.html
→ Quiz Processing v12 [Claude + 3x MC]
→ Enrich Cars v4 [MPG + NHTSA]
→ results.html
→ Guide & Search Report v15 [Claude guide]
→ report.html (Phase 1)
Search → Report ($49)
search.html
→ Free Search (Edge Fn) [Regex/Claude + MC Facets + Supabase cache]
→ results displayed
→ Stripe $49
→ Guide & Search Report v15 [MC expanded]
→ Rank Listings v9 [Claude rank]
→ report.html (Phase 1)
FastTrack VIN → Negotiation Package ($49)
search.html
→ VIN Decode v1 [1x MC]
→ report.html (preview)
→ Stripe $49
→ Negotiation Package v10 [MC Price + VIN History + Claude]
→ report.html (Phase 2)
Scout ($99) — Automated, Zero Human
search.html (user filters results)
→ Stripe $99
→ Free Search (Edge Fn) [dealer rerun]
+ FSBO Search [private party]
→ merge + dedup
→ Rank Listings v9 [Claude top 3]
→ report.html (3-car comparison)
→ user picks 1
→ Negotiation Package v10
→ report.html (Phase 2)
Trail Boss ($199) — Human-Assisted
User submits free text → Stripe $199
→ lands in admin Queue
→ human searches + curates + emails back and forth
→ picks top 3
→ Rank Listings v9 + Negotiation Package v10
→ same report output as Scout
Maximum Automated Chain (Search → Scout → Negotiation)
Free Search (Edge Fn) → FSBO Search → merge → Rank Listings → top 3 comparison → pick 1 → Negotiation Package
= 4 edge function calls, ~8 API calls, ~$0.08 platform cost, instant delivery
= 4 edge function calls, ~8 API calls, ~$0.08 platform cost, instant delivery
Monthly Platform Cost (at scale)
| Service | What For | Est. Monthly |
|---|---|---|
| MarketCheck | Inventory, pricing, comparables, sold tracking | ~$53 |
| Anthropic (Claude) | Classification, ranking, guides, negotiation | ~$40 |
| Supabase | Database, auth, config | $0-25 |
| Resend | Receipts, followup emails | $0-5 |
| NHTSA + MPG + Wiki | Safety ratings, fuel economy, photos | Free |
| Stripe | Payment processing | 2.9% + $0.30/txn |
| Total Platform | Fixed costs before Stripe fees | ~$95-125 |
Estimates assume 500 quizzes, 1,000 searches, 100 paid reports/month. Sold VIN tracker adds ~$36/mo (200 VINs/day).
Edge Function Routes (api.js)
| Route | Purpose | Method |
|---|---|---|
| /api/search | Public inventory search (normalize, MC facets, Supabase cache) | POST |
| /api/quiz | Quiz answers to 3 car matches (Claude Sonnet) | POST |
| /api/guide | Decision Guide generation (Claude Sonnet, 6 tabs) | POST |
| /api/search-report | Search report + async ranking pipeline (waitUntil) | POST |
| /api/rank | Score/rank listings (Claude Haiku, async) | POST |
| /api/negotiate | Negotiation package (MC Price, comp-blend FFP, leverage) | POST |
| /api/trade-in | Trade-in valuation (MC inventory, calibrated ranges) | POST |
| /api/vin-decode | Single VIN/URL lookup (NHTSA + MC) | POST |
| /api/receipt | Purchase receipt email (Resend) | POST |
| /api/send-email | Report delivery email (Resend) | POST |
| /api/normalize | Car name parsing (regex + Claude Haiku fallback) | POST |
| /api/vehicle-specs | MPG + NHTSA safety (fueleconomy.gov, cached) | GET |
| /api/vin-tracker | Sold VIN tracker (MC recents, daily cron) | GET |
| /api/feedback | User feedback submission | POST |