| Subcategory | Category | Campaign | Status | Avg transfer price | Max bid (TPB) | Transfer leads | Loss % | Stall % | Bind % | Same-day bind % | ACV | Broker quote % | Instant quote % | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Campaign | Status | Bid | Avg position | Implied position (now) | Max bid (TPB) | Outbid by | Transfers | Matched | Loss % | Closes 30d | Transfers 30d | Transfer 30D closes | 30D conv. | Avg AOV (30D) | Median AOV (30D) | AOV | Avg Rev / Lead | Action | Auto-win | |
| Phone / Campaign | Industry | Status | Bid | Transfers | Move to phone |
One row per Tivly-lead company with a per-line-of-coverage status:
N/A (not requested) ·
Pending (requested, nothing back yet) ·
Submitted (sent to a market, no quote back yet — request_for_quote_line_item status submitted, never shown where another market already answered that line; legacy feed: no new submitted rows since 2026-04-21, so recent leads rarely show S) ·
Quote placed (a real quote exists in insurance.quote, or — for GL — an approved ISC quote in isc_applications matched exact-1) ·
Bound (a deals_v2 coverage line bound).
Requested lines = the company SKU ∪ intake line items the customer's own request record confirms (CRM insurance types or Tivly required types; an intake GL line also counts when the company has no request record) — industry auto-added intake lines alone stay N/A. Same mapping as the Funnel drill. Urgency is the real service_analysis field. Filter by date range, urgency, or any coverage column; click a company name to open its detail, or its Dossier cell to jump to the dossier.
Exp. revenue (next to Exp. value) = Harper revenue if this lead binds (commission + Harper service fee, 100% conversion, no probability — never premium). Exp. value = Exp. revenue × historical close-rate × urgency (the triage/priority number): urgency is urgency_score ÷ 100 (clamped 0–1), or a neutral 0.5 when there is no completed urgency run. Both are quote-derived when every required line is priced (Σ premium × commission + fee), a peer/industry estimate otherwise (est./partial badge, fee already included); hover a cell for the full breakdown. Both are blank when there is no revenue basis — never a fabricated $0 (urgency never manufactures a value).
Who answered every Tivly transfer, who is free right now, and which campaigns are ringing unanswered. Answered by shows an agent only when a call record (Quo or Genesys) verifies it — Lead id on call means the Tivly rep read this lead's id aloud on that call; Pending means a Quo call is still live; Conflict means the sources disagree and Tivly only is Tivly's name, unverified. Agents, live calls and the roster are now; transfers and missed follow the window.
Transfers
Roster
| Agent | Status | In status | Calls | Talk | Current company |
|---|
Missed by campaign
| Campaign | Missed | Share | Last missed |
|---|
Sebastian's six failure-mode lists. Each card shows the accounts on the list, estimated Harper revenue with how it was estimated, and how many are active now (customer or underwriter activity in the window). DR's count sits next to Verified now: rows the record already contradicts (dead, test, paid, bound, already answered) are removed and listed with their reason — never counted. Times come from the record, in Pacific time.
Where our leads go. Every company lands in exactly one node per degree, so each degree’s counts sum to the universe: Source (first-match-wins: partnerships · Bold Penguin · Benepath · Tivly · Google / Meta / ChatGPT ads · organic / direct · other) → Intake (live transfer ≥ 5-min talk · missed / abandoned · not yet contacted) → Pipeline (quoted · submitted · nothing) → Outcome (sold · lost · open). Premium (largest real quoted premium per company) shows on the Quoted band; Harper revenue (order-grain first-year revenue) on the Sold band. Per-source spend + CPL is Tivly’s billed lead cost plus admin-entered spend for the other channels (blank when unknown — never a fabricated $0).
Where our leads go
Allocation breakdown
How each stage splits. “% of stage” is the share of that box; “% of total” is the share of all leads. Click a row to drill into its companies.
Industry rows are the lead's REAL business industry (its own Business Category/Subcategory mapped to the canonical taxonomy) — not the campaign it came in on, so a broad campaign's roofers, daycares and recruiters land in their true industries.
Closes = distinct Tivly-lead companies whose policy bound in the lookback (spined on bound_at). Cancellations = policies that cancelled (spined on cancelled_date). Hot 🔥 = meaningful net increase in closes vs the prior equal-length period; 🆕 new = none in the prior period. Revenue is gross first-year (revops parity). Click any count for the customers behind it.
One row per SKU (SEGMENT-STATE-COVERAGE, e.g. GAR-FL-GL), grouped from the company→sku_code map joined with harper-prod metrics.
Revenue is lifetime fee-inclusive order-grain (commission + Harper service fee); AOV is the 90-day matured bind cohort (revenue ÷ binds); Avg lead value is lifetime revenue ÷ transfer leads; Closes/Transfers 30D are the trailing 30 days. Spend is billed Tivly lead cost (marketing_revops.transfer_leads, keyed by tivly_lead_id; the CRM companies.tivly_lead_cost is the pre-2026-06-15 fallback). Default shows SKUs with ≥5 companies. Click a SKU for its companies + which campaigns (live/paused) they came from.
Mark a campaign as an experiment on the Campaigns tab (click a campaign → Add as experiment, set a hypothesis). Every lead from the selected experiment campaign(s) appears below with its per-line coverage outcome, the number of interactions we had, and whether an application was received.
$ Sold that line Y Quote back S Submitted — no quote yet No Requested — no quote blank = not requested · S is a precision-first undercount (only firm market submissions; legacy feed, no new submitted rows since 2026-04-21)
Every dashboard bid and phone-number change, with the actor from Clerk (name + email + user id), the old → new values, the time, and the campaign. One row per committed change; newest first. Read-only, from marketing_revops.campaign_change_event.
| When ▼ | Campaign | Type | Old → New | Who | Details |
|---|