PI Dashboard

Total Leads

— today

Total Spend

G M V O 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

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

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 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 Spend CVFO Revenue CPL CPA ROAS
Loading…

Spend By Week By State

Wk End State Leads Contacted Routed Pending Signs Contact Sign FB Google 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 Spend CVFO Revenue CPL CPA ROAS
Loading…

Spend By Day By State

Day State Leads Contacted Routed Pending Signs Contact Sign FB Google 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…