Marketing — Sam Aguiar Injury Lawyers

Leads

Monthly Deep dive →

Leads by month

Leads by source (top 10)

Time frameMonthly

Sourcelitify_pm__Intake__c — Marketing Center (Intake Marketing Source Matrix)

Fields usedCreatedDate, litify_pm__Source__c

Signed Cases

Monthly Deep dive →

Signed cases by month

Signed cases by source (top 10)

Time frameMonthly

Sourcelitify_pm__Matter__c — Open Date based

Fields usedlitify_pm__Open_Date__c, litify_pm__Source__c

Spend

Monthly Deep dive →

Spend by month

Spend share by source (top 8)

Time frameMonthly

Sourcelitify_mktgROI__Monthly_Marketing_Spend__c

Fields usedMonthly_Spend_Start_Date__c, Spend__c, Source__c

Source Matrix

Window total Deep dive →

Source	Leads	Signed	Conv %	Spend	Cost / Signed
Television Ad	440	78	17.7%	$283,061	$3,629
Billboard Ad	126	38	30.2%	$169,832	$4,469
Sponsorship	0	0	—	$79,025	—
Social Media	22	1	4.5%	$47,121	$47,121
Google Ads	60	12	20.0%	$28,625	$2,385
SEO	1,116	120	10.8%	$23,682	$197
Radio Ad	9	5	55.6%	$23,144	$4,629
Google LSA (Louisville)	160	28	17.5%	$21,865	$781
Google LSA (Lexington)	128	25	19.5%	$12,354	$494
OTT / CTV	0	0	—	$8,166	—
Word of Mouth	1,040	410	39.4%	$0	$0
Returning Client	290	124	42.8%	$0	$0
Employee (Attorney)	83	70	84.3%	$0	$0
Employee (Non Attorney)	33	25	75.8%	$0	$0
AI Chatbot	66	21	31.8%	$0	$0
Attorney Referral	48	20	41.7%	$0	$0
Employee (Owner)	11	9	81.8%	$0	$0
Google	4	3	75.0%	$0	$0
Unknown	9	3	33.3%	$0	$0
Health Care Provider Referral	5	2	40.0%	$0	$0
Unknown Referral Source	128	2	1.6%	$0	$0
Former Employee	1	1	100.0%	$0	$0
Legal Aid Society	1	1	100.0%	$0	$0
Bus Ad	2	0	0.0%	$0	—
News Story	9	0	0.0%	$0	—

Time frameWindow total

SourceSpend + Intake + Matter joined by Source.Name

Fields usedlitify_pm__Source__c (Intake/Matter), litify_mktgROI__Source__c (Spend)

CaveatSource labels are not yet normalized across Spend and Matter — small mismatches can split a source into two rows. Known issue (see Marketing Spend Entry SOP): Sponsorship shows high spend with ~0 attributed signed cases because of a Spend.Source vs Matter.Source label mismatch — read it as an attribution gap, not as dead spend. See marketing-center-source-of-truth-map.

Cost / Signed by Source

Window total Deep dive →

Source	Spend	Signed	Cost / Signed
Television Ad	$283,061	78	$3,629
Billboard Ad	$169,832	38	$4,469
Sponsorship	$79,025	0	—
Social Media	$47,121	1	$47,121
Google Ads	$28,625	12	$2,385
SEO	$23,682	120	$197
Radio Ad	$23,144	5	$4,629
Google LSA (Louisville)	$21,865	28	$781
Google LSA (Lexington)	$12,354	25	$494
OTT / CTV	$8,166	0	—

Time frameWindow total

SourceSpend ÷ Signed by source (paid sources only)

Fields usedlitify_mktgROI__Source__c, litify_pm__Source__c

CaveatCost/Signed assumes Spend.Source and Matter.Source labels match. Sponsorship is a known mismatch (see Marketing Spend Entry SOP) — its '—' / sky-high cost reflects unjoined attribution, not zero return. Lexington and Louisville LSA are tracked separately and must never be combined.

Headline Metrics

Window total Deep dive →

Metric	Value
Lead → Signed conversion	26.3%
Marketing cost / signed case	$698
Avg leads / month	421
Avg signed / month	110
Avg spend / month	$77,431

Time frameWindow total

SourceDerived from Leads, Signed, Spend

Fields usedAggregates above

Geography

Window total Deep dive →

Signed cases by region

Leads by region

Top city — Leads	Leads	Top city — Signed	Signed
Louisville, KY Kentucky	1,039	Louisville, KY Kentucky	630
Lexington, KY Kentucky	72	Lexington, KY Kentucky	41
Shepherdsville, KY Kentucky	34	Shepherdsville, KY Kentucky	26
Lou, KY Kentucky	23	Lou, KY Kentucky	18
Jeffersonville, IN Indiana	21	Shively, KY Kentucky	10
Bardstown, KY Kentucky	17	Jeffersonville, IN Indiana	9
Louisville	16	Georgetown, KY Kentucky	9
New Albany, IN Indiana	14	Elizabethtown, KY Kentucky	8
Elizabethtown, KY Kentucky	13	Radcliff, KY Kentucky	8
Clarksville, IN Indiana	12	Clarksville, IN Indiana	6

Time frameWindow total

Sourcelitify_pm__Intake__c + litify_pm__Matter__c — geo fields, firm-defined region map

Fields usedCase_City__c, Case_State__c, Matter_City__c, lit_Matter_County__c, Matter_State__c

CaveatIntake records often lack county, so intake-region rollup falls back to state-only and reports more as Unknown than matters do.

Demographics

Signed cases (current window) Deep dive →

Signed by age band

Signed by language (top 6)

Top ZIP	Signed
40220	1
40209	1
40117	1
40228	1
40291	1

Time frameSigned cases (current window)

Sourcelitify_pm__Matter__c — audience fields

Fields usedMatter_Postal_Code__c, Client_Age__c, Primary_Language__c

CaveatPopulation coverage varies: ZIP ~76%, Age ~99%, Language ~17%. Language is a floor, not actual.

Lexington

Window total Deep dive →

Metric	Value
Lexington leads	76
Lexington signed cases	42
Share of total signed	4.2%

Time frameWindow total

Sourcelitify_pm__Matter__c + Intake__c — city / county filter

Fields usedMatter_City__c, lit_Matter_County__c, Case_City__c

Spanish

Window total Deep dive →

Metric	Value
Spanish-language signed (floor)	48
Share of total signed	4.8%

Time frameWindow total

Sourcelitify_pm__Matter__c — language filter

Fields usedPrimary_Language__c

CaveatPrimary_Language__c is only ~17% populated on Matter. Counts are floor, not actual.