Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-07 10:45:53

@here need this for Abe asap: Can I please get a listing of all the AFFF cases with their injuries and with both the SL ID and the DL case number on the spreadsheet.

For ease of reference and to ensure we are on the same page, here are columns that I also expect to be included: • First name • Last name • SSN (if we have it) • Email • Home address • Zip code • DOB • Phone number • SL ID • DL case number • Injuries If able to break out for an injury per column great, if not, that is ok. Goal is speed here.

✅ deleted-U06CVB2MHRN
deleted-U06C7A8PVLJ
2025-02-07 10:50:39

@Nicholas McFadden Would that be for intake and secondary or just intake?

deleted-U06CVB2MHRN
2025-02-07 10:51:35

Also is that every AFFF or just the Dicello ones

deleted-U04GZ79CPNG
2025-02-07 10:54:19

Look for ssn in secondary. Just Dicello ones

✅ deleted-U06CVB2MHRN
deleted-U06CVB2MHRN
2025-02-07 10:55:16

gotcha!

Dustin Surwill (dsurwill@shield-legal.com)
2025-02-07 11:05:55

We can merge a LR report with SSN and Injuries with a filtered version of the flatirons benchmark report.

deleted-U06CVB2MHRN
2025-02-07 11:15:42

Do we want only these statuses?

image.png
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-07 11:35:42

they want declines too

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-07 11:35:57

make sure there aren't any in "Final - Sent"

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-07 11:36:12

otherwise include that too please

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-07 11:37:43

the more they can get the better

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-07 11:37:56

if it is an issue let me know and I will relay that to them

✅ deleted-U06CVB2MHRN
deleted-U06CVB2MHRN
2025-02-11 20:00:10

I am out for the night. This is what I have been able to matchup/confirm 4608 Leads so far. Will continue tomorrow morning.

Lead Matchup Project - My Report (1).csv
:headbanging_parrot: deleted-U04GZ79CPNG
:cat_roomba_exceptionally_fast: deleted-U06C7A8PVLJ