Ramos Law — Executive Dashboard

Executive Overview

Select a data file to load overview

Total Leads

—

Signed Clients

—

Qualified Leads

—

Qualified Lead Rate

—

Rejected Lead Rate

—

Client Referral Rate

—

Qualified Lead Rate — Trend

Monthly trend

📁

No Attorney Tracker File Selected

Please select a file with source Attorney Tracker to see this tab's data.

Attorney Performance

Select a data file above to load attorney performance

—

Total Value

—

Settlements

Total Settlement Value

iFormulaSum of all settlement amounts for all attorneys in selected period.

Source: Attorney Tracker

—

Avg Settlement

iFormula — MeanTotal Settlement Value ÷ Total Settled Cases

Formula — MedianMiddle settlement value when all cases sorted ascending. Removes outlier distortion.

Source: Attorney Tracker

—

Mean firm-wide

Best Division

iFormulaDivision with highest adjusted settlement value in period.

Source: Attorney Tracker (division formula v1)

—

Top performer this period

Attorneys Tracked

iFormulaCount of distinct attorney names with at least 1 settlement in selected period.

Source: Attorney Tracker

—

AI-Generated Insights · Auto-generated from settlement data

—Select a data file to load insights.

Settlement Value by Division

Adjusted value

Trending Up vs. Down by Division

Trending attorneys by division

Rank	Attorney	Division	Cases	Total Value	Avg Settlement	Median Est.	Outlier %	Trend

↑ Trending Up

MoM adjusted settlement value > +5%

Attorney	Division
Select a data file

↓ Trending Down

MoM adjusted settlement value < −5% — needs attention

Attorney	Division
Select a data file

Division Settlement Value Breakdown

Adjusted settlement value by division

Select a data file to load division breakdown

Attorney Performance

Total Firm Settlement Value

iFormulaSum of all attorney settlement amounts in period.
Source: Attorney Tracker

$75.3M

↑ +49.03% MoM

Firm Avg Settlement

iFormula — MeanTotal Value ÷ Total Cases
Formula — MedianMiddle settlement value sorted ascending.
Source: Attorney Tracker

$114K

Median: $68K

Best Division

iFormulaDivision with highest adjusted settlement value in period.
Source: Attorney Tracker

Pre-Lit

~$43M value

Settlement Value by Division

Firm aggregate · May 2026

Division Trend Summary

MoM direction · All divisions

Pre-Litigation↑ Strong

Litigation↑ Improving

Arizona Pre-Lit↓ Declining

LitPath→ Mixed

🔒

Individual Attorney Rankings Restricted

Individual attorney performance data, rankings, and leaderboards are available to authorized C-suite roles only. Contact your administrator to request elevated access.

Pipeline & Lead Intelligence

IntakeOps live feed

—

Active Leads

Total Active

—

48-hr Burst

—

Lead → Case Conv.

—

Top State

—

Lead Source Distribution

—

Case Type Breakdown

—

Lead Intake by Weekday

—

Disposition by Weekday

—

📁

No QuickBooks File Selected

Please select a file with source QuickBooks to see this tab's data.

Revenue & Financial Performance

Select a QuickBooks data file to load revenue

Total Revenue YTD

—

Avg Revenue per Case

—

Current Month Revenue

—

Cases Settled YTD

—

Monthly Revenue Trend

YTD monthly revenue

Revenue by Office

Office breakdown

Attorney Revenue Leaderboard

Ranked by total revenue

#	Attorney	Cases	Total Revenue	Avg per Case	% of Total
Select a QuickBooks data file

📁

No QuickBooks File Selected

Please select a file with source QuickBooks to see this tab's data.

Practice Area Breakdown

Select a QuickBooks data file to load practice areas

Highest Revenue Area

—

Highest Avg Case Value

—

Revenue by Case Type

Case type revenue breakdown

Case Type Breakdown

Revenue and share of total

Case Type	Revenue	% of Total
Select a QuickBooks data file

Executive Dashboard

Enter OTP

Create Password

Forgot Password

Verify OTP

Reset Password

Authenticated!