PI Dashboard

Total Leads

—

— today

Total Spend

—

G — M — V — O — T — R — B —

— active campaigns

Avg CPL

—

cost per lead

Lead Sources

—

active projects

Leads by Referrer

Leads by Source

Spend by Referrer

Spend by Source

Salesforce Pipeline

SF Leads

—

— open

Routed

—

— % conversion rate

Re-Route Count

—

— % of routed

Signed

—

— total matters

Total Settlement

—

— won matters

SF Leads by Status and Created Date

Matters by Stage

Ringba Call Tracking

Total Calls

—

— live now

Answer Rate

—

— connected

Conversion Rate

—

— converted

Avg Duration

—

— telco cost

Calls Over Time

Calls by Number Pool

Campaign Performance

Campaign Publisher Target Total Routed Signed Converted Paid Avg Dur. Calls
Loading…

Five9 Call Tracking

Total Calls

—

— inbound

Answer Rate

—

— answered

Transferred

—

— outbound

Avg Talk Time

—

— total cost

Calls Over Time

Calls by Disposition

Campaign Performance

Campaign Total Inbound Outbound Answered Answer % Avg Talk Transferred Calls
Loading…

Leads Over Time

Leads by Referrer

Leads by UTM Source

Spend Over Time (Google + Meta + Vibe + OpenAI + Radio + Billboard)

Spend by Referrer

Spend by UTM Source

Search

Google Ads Performance

Impressions

—

— campaigns

Clicks

—

— CTR

Total Spend

—

— avg CPL

Lead Actions

—

tracked by Google

Google Campaigns by Spend

Campaign Impressions Clicks CTR Spend Avg CPL Lead Actions Routed Signed CPR
Loading…

Meta Ads Performance

Impressions

—

total views

Clicks

—

— CTR

Total Spend

—

— avg CPL

Lead Actions

—

Meta-tracked form fills

Meta Campaigns by Spend

Campaign Account Spend Impressions Clicks CTR Avg CPL Leads Routed Signed CPR
Loading…
Show
Page 1

Vibe CTV Performance

Impressions

—

— campaigns

Completed Views

—

— VTR

Total Spend

—

— avg CPM

Households

—

unique reached

Vibe Campaigns by Spend

Campaign Advertiser Spend Impressions Completed Views VTR CPM Households
Loading…
Show
Page 1

OpenAI Ads Performance

Impressions

—

— campaigns

Clicks

—

— CTR

Total Spend

—

— avg CPC

Conversions

—

tracked by OpenAI

Leads

—

— CPL

Contacted

—

— of leads

Routed

—

— of leads

Signed

—

— of leads

OpenAI Campaigns by Spend

Campaign Account Spend Impressions Clicks CTR CPC Conversions Leads Contacted Routed Signed CPL
Loading…
Show
Page 1

TikTok Ads Performance

Impressions

—

— campaigns

Clicks

—

— CTR

Total Spend

—

— avg CPC

Conversions

—

tracked by TikTok

Leads

—

— CPL

Contacted

—

— of leads

Routed

—

— of leads

Signed

—

— of leads

TikTok Campaigns by Spend

Campaign Account Spend Impressions Clicks CTR CPC Conversions Leads Contacted Routed Signed CPL
Loading…
Show
Page 1

Configure Report

No joins — single table query

No filters added

Select columns and click Run Query

My Saved Reports

No saved reports yet. Save reports from Report Builder or AI Query.

The below cards show the data for leads created within the date range. Spend = total FB spend; Revenue = Signs × avg CVFO (state-based forecast).

Settled Cases view — the same report, with Close, % CL, Settlement, Ovation Fee and $ Won added to the end of every table. $ Won = all settlement dollars on matters closing in this range at any stage except Lost / Rejected. Settlement and Ovation Fee count only matters flagged won (stage Close / Fee Collected). Only those won stages carry a real close date — at every other stage close_date is a month-end forecast, so part of $ Won is dated by estimate.
Platform Account
Date basis
Export whole report:

FB Overall

Leads Contacted Routed Pending Signs Proj S %C %R %RC %S %PS CPL CPRL CPA CVFO Spend Revenue ROAS PROAS
Loading…

FB by State

State ⇅ Leads ⇅ Contacted ⇅ Routed ⇅ Signs ⇅ % Contacted ⇅ % Routed ⇅ % RSigned ⇅ % Signed ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ CVFO ⇅ Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

FB by Campaign

Campaign Name ⇅ Leads ⇅ Con ⇅ Rte ⇅ Signs ⇅ % Con ⇅ % Rte ⇅ % RSign ⇅ % Sign ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ CVFO ⇅ Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

FB by Campaign by State

Campaign / State ⇅ Leads ⇅ Con ⇅ Rte ⇅ Signs ⇅ % Con ⇅ % Rte ⇅ % RSign ⇅ % Sign ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ CVFO ⇅ Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

FB by Adset

Adset Name ⇅ Leads ⇅ Con ⇅ Rte ⇅ Signs ⇅ % Con ⇅ % Rte ⇅ % RSign ⇅ % Sign ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ CVFO ⇅ Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

FB by Adset by State

Adset / State ⇅ Leads ⇅ Con ⇅ Rte ⇅ Signs ⇅ % Con ⇅ % Rte ⇅ % RSign ⇅ % Sign ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ CVFO ⇅ Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

FB by Ad

Ad Name ⇅ Leads ⇅ Con ⇅ Rte ⇅ Signs ⇅ % Con ⇅ % Rte ⇅ % RSign ⇅ % Sign ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ CVFO ⇅ Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

FB by Ad by State

Ad / State ⇅ Leads ⇅ Con ⇅ Rte ⇅ Signs ⇅ % Con ⇅ % Rte ⇅ % RSign ⇅ % Sign ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ CVFO ⇅ Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

FB by Account

Account ⇅ Leads ⇅ Contacted ⇅ Routed ⇅ Signs ⇅ % Contacted ⇅ % Routed ⇅ % RSigned ⇅ % Signed ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ CVFO ⇅ Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

FB by Account & State

Acct ⇅ State ⇅ Leads ⇅ Contacted ⇅ Routed ⇅ Signs ⇅ % Contacted ⇅ % Routed ⇅ % RSigned ⇅ % Signed ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ CVFO ⇅ Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

By Referrer

Referrer ⇅ Leads ⇅ Con ⇅ Rte ⇅ Signs ⇅ % Con ⇅ % Rte ⇅ % RSign ⇅ % Sign ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ ROAS ⇅
Loading…

By Partner

Partner ⇅ Rte ⇅ Pending ⇅ Declined ⇅ Signs ⇅ % D ⇅ % P ⇅ % S ⇅ Falloff ⇅ F % ⇅ % Monetized ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ FB ⇅ Revenue ⇅ ROAS ⇅
Loading…

By Partner (First Look)

Partner ⇅ Rte ⇅ Pending ⇅ Declined ⇅ Signs ⇅ % D ⇅ % P ⇅ % S ⇅ Falloff ⇅ F % ⇅ % Monetized ⇅
Loading…

By Partner (Second Look)

Partner ⇅ Re-Route Cnt ⇅ Pending ⇅ Declined ⇅ Signs ⇅ % D ⇅ % P ⇅ % S ⇅ Falloff ⇅ F % ⇅ % Monetized ⇅
Loading…

By Lead Source

Source ⇅ Leads ⇅ Con ⇅ Rte ⇅ Signs ⇅ % Con ⇅ % Rte ⇅ %RSign ⇅ % Sign ⇅ CPL ⇅ CPRL ⇅ CPA ⇅ FB Spend ⇅ Revenue ⇅ ROAS ⇅
Loading…

The below cards show actual routed and sign counts within the date range. Contacted counts are of the leads within the range, how many were contacted, not total contacted leads for the date range. Signed % is simply the signed for the week / leads created for the week. This is useful, but can't distort it, for example if we brought few new leads in and signed a bunch of older leads, this number would be inflated. It's still useful in general to keep an eye on sign volume to new lead volume.

Total Spend

Spend By Week

Wk End ⇅ Leads ⇅ Contacted ⇅ Routed ⇅ Pending ⇅ Signs ⇅ Contact ⇅ Sign ⇅ FB ⇅ Google ⇅ Vibe ⇅ Radio ⇅ Billboard ⇅ Spend ⇅ CVFO ⇅ Revenue ⇅ CPL ⇅ CPA ⇅ ROAS ⇅
Loading…

Spend By Week By State

Wk End ⇅ State ⇅ Leads ⇅ Contacted ⇅ Routed ⇅ Pending ⇅ Signs ⇅ Contact ⇅ Sign ⇅ FB ⇅ Google ⇅ Vibe ⇅ Radio ⇅ Billboard ⇅ Spend ⇅ CVFO ⇅ Revenue ⇅ CPL ⇅ CPA ⇅ ROAS ⇅
Loading…

Total Spend By Day

Routed / Contacted / Signed By Day

Spend By Day

Day ⇅ Leads ⇅ Contacted ⇅ Routed ⇅ Pending ⇅ Signs ⇅ Contact ⇅ Sign ⇅ FB ⇅ Google ⇅ Vibe ⇅ Radio ⇅ Billboard ⇅ Spend ⇅ CVFO ⇅ Revenue ⇅ CPL ⇅ CPA ⇅ ROAS ⇅
Loading…

Spend By Day By State

Day ⇅ State ⇅ Leads ⇅ Contacted ⇅ Routed ⇅ Pending ⇅ Signs ⇅ Contact ⇅ Sign ⇅ FB ⇅ Google ⇅ Vibe ⇅ Radio ⇅ Billboard ⇅ Spend ⇅ CVFO ⇅ Revenue ⇅ CPL ⇅ CPA ⇅ ROAS ⇅
Loading…

FB CPA Heatmap tile size = FB spend · color = CPA (red high → green low)

Radio Spend

Manually tracked radio buys. A total entered over a date range is split evenly across each day (one row per day + state + referrer). The list is filtered by the date range in the header above (and optionally by state).

Add Radio Spend

Radio

Referrer URLs are sourced from leads currently in the warehouse. New URLs appear automatically once leads from a new landing page arrive.

Spend Entries

—
Date State Referrer Spend Notes Added by Added at Actions
Loading…
Page 1

Billboard Spend

Manually tracked billboard buys. A total entered over a date range is split evenly across each day (one row per day + state + referrer). The list is filtered by the date range in the header above (and optionally by state).

Add Billboard Spend

Billboard

Referrer URLs are sourced from leads currently in the warehouse. New URLs appear automatically once leads from a new landing page arrive.

Spend Entries

—
Date State Referrer Spend Notes Added by Added at Actions
Loading…
Page 1

Manage Users

Admin-only. Change roles, remove users, or invite new ones.

Email Name Role Created Last Login Actions
Loading…