Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 14:36:38

yeah this is a hard one to pin down

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-07-29 14:43:35

extra emails to search for

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 14:44:03

if they exist they'll be in one of the csvs

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 14:44:41
job.md
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-07-29 14:44:44

by search for I mean omit because if it is there then they received it since this isn't limited to just DL

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 14:45:38

ahh want me to run this again and add these to the NOT LIKE list? Want the query to remove duplicate leadids or would you like all the data?

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-29 14:54:20

bencrumpcases@bencrump.com,processing@simmonsfirm.com

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:07:51

I added these to the NOT LIKE column and we went from 3,893 missing email leads to 17,918 when I added these handful of emails to the NOT LIKE. Here is the query I am using.

    l.id AS missing_leadid,
    ct.name AS campaign_name,
    ls.name AS status_name,
    l.createdate,
    'Missing Attorney Email' AS issue_type
FROM lead l
JOIN case_type ct ON l.casetypeid = ct.id
JOIN lead_status ls ON l.statusid = ls.id
WHERE
    ls.id IN (1074, 1075)  -- Should have triggered attorney emails
    AND l.id NOT IN (
        -- Exclude leads that already have attorney email records
        SELECT DISTINCT lh.leadid
        FROM lead_history lh
        WHERE lh.username LIKE '%intakes@tortintakeprofessionals.com%'
        AND lh.username NOT LIKE '%esigntracker@robot.zapier.com%'
        AND lh.username NOT LIKE '%leadpool@robot.zapier.com%'
        AND lh.username NOT LIKE '%tony@tortintakeprofessionals.com%'
        AND lh.username NOT LIKE '%brettmichael@tortintakeprofessionals.com%'
        AND lh.username NOT LIKE '%alan@tortintakeprofessionals.com%'
        AND lh.username NOT LIKE '%luis@tortintakeprofessionals.com%'
        AND lh.username NOT LIKE '%jackson@tortintakeprofessionals.com%'
        AND lh.username NOT LIKE '%alicia@tortintakeprofessionals.com%'
        AND lh.username NOT LIKE '%cassie@tortintakeprofessionals.com%'
        AND lh.username NOT LIKE '%data@shield-legal.com%'
        AND lh.username NOT LIKE '%management@tortintakeprofessionals.com%'
        AND lh.username NOT LIKE '%screenersubmit@robot.zapier.com%'
        AND lh.username NOT LIKE '%flags@robot.zapier.com%'
        AND lh.username NOT LIKE '%rr@openjar.com%'
        AND lh.username NOT LIKE '%commissionautomation@robot.zapier.com%'
        AND lh.username NOT LIKE '%notifications@law.lawruler.net%'
        AND lh.username NOT LIKE '%declinebot@robot.zapier.com%'
        AND lh.username NOT LIKE '%hfhfhgjfjfjjffiiii2@gmail.com%'
        -- New attorney emails to exclude
        AND lh.username NOT LIKE '%akinard@elglaw.com%'
        AND lh.username NOT LIKE '%Jonathan@elglaw.com%'
        AND lh.username NOT LIKE '%AFFFIntake@elglaw.com%'
        AND lh.username NOT LIKE '%dan@levinsonlegalgroup.com%'
        AND lh.username NOT LIKE '%bencrumpcases@bencrump.com%'
        AND lh.username NOT LIKE '%processing@simmonsfirm.com%'
        AND lh.username NOT LIKE '%Intakes@sgghlaw.com%'
        AND lh.username NOT LIKE '%kasia@sgghlaw.com%'
        AND lh.username NOT LIKE '%parker@sgghlaw.com%'
        AND lh.username NOT LIKE '%rmeadow@meadowlawfirm.com%'
        AND lh.username NOT LIKE '%acrowell@meadowlawfirm.com%'
        AND lh.username NOT LIKE '%jgordon@meadowlawfirm.com%'
        AND lh.username NOT LIKE '%kyle@meadowlawfirm.com%'
        AND lh.username NOT LIKE '%jbecker@meadowlawfirm.com%'
        AND lh.username NOT LIKE '%claims@dicellolevitt.com%'
        AND lh.username NOT LIKE '%biolabcontracts@smstrial.com%'
    )
ORDER BY ct.name, l.createdate DESC
Result_noemail-additional.csv
Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-29 15:12:52

mainfax@dicellolevitt.com,william@williammattar.com

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:13:37

ill keep an eye out for the full list and we'll approach this again so I dont keep sending reports

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:15:59

More complete exclusion list = fewer false positives

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-29 15:18:38

how did the file jump up when it should be limiting based on the emails added?

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:19:29

good question .. let me dive on it

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:25:34

it was because I'd added them to NOT LIKE -- here is the updated query that output 3,229 -- Find leads that should have gotten attorney emails but have NO attorney email records SELECT l.id AS missing_leadid, ct.name AS campaign_name, ls.name AS status_name, l.createdate, 'Missing Attorney Email' AS issue_type FROM lead l JOIN case_type ct ON l.casetypeid = ct.id JOIN lead_status ls ON l.statusid = ls.id WHERE ls.id IN (1074, 1075) -- Should have triggered attorney emails AND l.id NOT IN ( -- Exclude leads that have ANY attorney email communication SELECT DISTINCT lh.leadid FROM lead_history lh WHERE ( -- Look for ANY attorney email communication (not just intakes@) lh.username LIKE '%@elglaw.com%' OR lh.username LIKE '%@levinsonlegalgroup.com%' OR lh.username LIKE '%@bencrump.com%' OR lh.username LIKE '%@simmonsfirm.com%' OR lh.username LIKE '%@sgghlaw.com%' OR lh.username LIKE '%@meadowlawfirm.com%' OR lh.username LIKE '%@dicellolevitt.com%' OR lh.username LIKE '%@smstrial.com%' OR lh.username LIKE '%intakes@tortintakeprofessionals.com%' ) AND lh.username NOT LIKE '%esigntracker@robot.zapier.com%' AND lh.username NOT LIKE '%leadpool@robot.zapier.com%' AND lh.username NOT LIKE '%tony@tortintakeprofessionals.com%' AND lh.username NOT LIKE '%brettmichael@tortintakeprofessionals.com%' AND lh.username NOT LIKE '%alan@tortintakeprofessionals.com%' AND lh.username NOT LIKE '%luis@tortintakeprofessionals.com%' AND lh.username NOT LIKE '%jackson@tortintakeprofessionals.com%' AND lh.username NOT LIKE '%alicia@tortintakeprofessionals.com%' AND lh.username NOT LIKE '%cassie@tortintakeprofessionals.com%' AND lh.username NOT LIKE '%data@shield-legal.com%' AND lh.username NOT LIKE '%management@tortintakeprofessionals.com%' AND lh.username NOT LIKE '%screenersubmit@robot.zapier.com%' AND lh.username NOT LIKE '%flags@robot.zapier.com%' AND lh.username NOT LIKE '%rr@openjar.com%' AND lh.username NOT LIKE '%commissionautomation@robot.zapier.com%' AND lh.username NOT LIKE '%notifications@law.lawruler.net%' AND lh.username NOT LIKE '%declinebot@robot.zapier.com%' AND lh.username NOT LIKE '%hfhfhgjfjfjjffiiii2@gmail.com%' ) ORDER BY ct.name, l.createdate DESC;

run1.csv
Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:25:48

take a look at this

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:27:28

the issue is their are no null so I am trying tricks to pull this data

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:32:39

Can you just grab one specific lead that you KNOW should have gotten an attorney email but didn't, and show me everything about it?

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:32:51

And give me the lead id so I am not shooting in the dark?

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 15:33:10

And give me the lead id so I am not shooting in the dark?

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-29 16:34:26

88372

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 16:37:17

the reason being is that leadid is duplicated 39 times and is sent to dozens of people ... ill think on it tonight and give it another whirl in the morning

dupes_example.csv
Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 16:42:07

thanks carter that was helpful

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 16:42:28

find another few

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 16:42:35

just so I can confirm some things

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-29 16:43:12

different campaigns or same?

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 16:43:45

im digging on it now -- whatever, doesnt matter I am just trying to fully understand these flows and why and what is happening so I don't keep throwing around SQL queries without the full picture

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 16:44:16

So for lead 88372: • It went through the process and got DECLINED • It sent internal notifications to Shield Legal team But it never got sent to an external law firm attorney

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 16:44:42

still making a clear picture of whats going on

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-29 16:45:49

there are a variety of different reasons and yes I will grab a few more

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 16:46:10

thats what makes this more abstract, the variety

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-29 16:47:01

Can you show me an example of a lead that DID get sent to an external attorney correctly?

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 10:39:24

Hey Carter -- still waiting on these examples. I need 3 of each at least. This is something I am going to have to really dig on the entire logs of the leadid you send over so I can see these journeys and I can identify a way to get this data because brute forcing SQL is worthless until I can have a better picture.

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 10:39:34

Thanks

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:20:28

ok thanks...let me look into that now...I have some free time

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:21:35

Cool. And man your car is sweet lol

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:21:40

good job

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:22:15

lol thanks. Yeah it's been a good one.

🙏 Chris Krecicki
Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:23:44

so in the meeting today we discussed also a good point of reference to make sure they were signed docs would be esigned date as a main filed finding completed docs...obviously the email is the hardest part

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:24:46

yeah once I can see some solid variations between missing/not sent versus sent. I can dive on this. Otherwise I am just brute forcing SQL to see if we can pull them without me seeing the full picture

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:24:50

I was just looking over the list you sent of lead status

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:25:08

I was absorbed in this new ai agent for the tort finder. Didnt even realize the time

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:25:10

yeah Dustin said it would take a bit of both

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:26:01

Find a handful you know were not sent. And a handful for sure that were properly sent. The data is so ... strewn, if that is a word.

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:26:05

We'll find the truth.

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:26:33

Once I can really see their journeys through the system I should be able to identify how to programmatically differentiate them.

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:26:40

do you have an updated list of what you have sorted so far since we found more emails to see if it filtered them out?

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:27:21

Just what I sent over. No nulls exist in the database and every lead is sent to someone. It's a mess. Once I have those things from you I will have some more tools to actually sort this out.

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:27:34

ok

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:27:34

Our data is .. so patchy .. and different everywhere,

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:28:21

It's very difficult to answer some of these questions unless I actually can see what the journeys look like. Why? I am hoping to find some markers that will let me alter these SQL statements,

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:39:06

ok looking through a few of these some have api integration too

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:39:18

here is an example of that 758517

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:39:23

its a mess carter lol thats why this is so hard to see

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:39:31

yeah for sure.

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:39:33

Create SEC webhook triggered - Response: HTTP Code: OK - Reponse: {"attempt":"019852e4d0eb009ace2ae73a3960df71","id":"019852e4-d0eb-009a-ce2a-e73a3960df71","requestid":"019852e4d0eb009ace2a_e73a3960df71","status":"success"}

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:39:36

just find a handful of IDs that absolutely the lawyer did not get

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:39:38

and a few that they did

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:39:40

that is the message for that

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:40:01

im going to have to pull the database entries for the lead ids and really pin down whats going on and what is consistant

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:40:39

thats why the CSV has some and some were sent, it's the consistency i am going to be looking for once you get the ids -- because then i can have a clear picture and identify some marker

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:40:43

I agree. but once we get this formula down on what pulls it we will be able to create a db search in the future lets say every 15 days to see if this happens again

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:40:50

for sure

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:40:54

ill even mark it on my calendar

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:41:02

i do something like that for legal

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:41:47

ok, I am sure setting up some sort of automation would be bad once we figure out how to search the db.

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:42:01

i run our compliance surveillance pipeline for them: finds new employees from the last 60 days, pull 10 audio files, transcribes and then uses LLM to answer questions.

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:42:07

it might be easier moving forward to since data seems to be getting a little more consistent

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:42:18

once we understand the journey well be able to nail it down

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:42:28

yeah I saw that audio surveillance...it was pretty cool

🙏 Chris Krecicki
Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:42:32

🙂

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:42:34

this stuff is fun

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:43:04

wait till you see the transcription chat bot for the call center and review guys -- waiting on Tyson to ahdnle some permissions issue int he DB for some users using the routes

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:43:13

Once he is done with that I am going to hold a small workshop

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:43:17

I wish there was a way for us to know which campaigns are set up with api and which ones are email triggered

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:43:32

Another thing we'll have to drill down once we sort this out.

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:43:42

If it's possible. I'll figure it out.

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:44:04

seems like there should be a basic trigger or tag or something that would pull if there is api present

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:44:48

Yeah hopefully the same approach with studying the journeys can reveal some marker (that is unknown to us right now outside of guesses)

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:44:57

brb got to finish this thing for dustin

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:50:53

masstortintake@baileyglasser.com

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:54:01

oh we've got all those just get me like 5-10 lead ids you know sent and the ones you know didnt

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:55:37

its the leadid we're looking for

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:55:52

i have all those emails

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 13:56:03

they came out on the first run

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:56:06

I know but I have to go through each of these to see which ones didn't send

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 13:56:42

ok so you do have them all because the first list you had didn't have them all

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 14:00:38

trying to get through the list of the 17000 leads to find the ones that didn't send

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 14:01:15

no rush, i have to finish a few projects

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 14:03:34

543457

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 14:03:55

lets keep it all in one csv you can send over

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 14:05:20

its just guess work at this point. If I get lucky to grab an id and find one

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 14:07:06

haha and once you find them I have to figure out wtf is going on with their journey and find some markers so we can make a consistent SQL query so we can setup an automation lolol

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 14:07:13

wild hu?

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 14:07:43

maybe you can run the report again and see if it does a better job pulling out the ones that have emails. I am just randomly grabbing and ID and putting into lawruler, looking in the activity logs to see if I see an email

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 14:09:16

give me an hour to finish this up and ill run another one

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 14:09:24

cool

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-30 14:21:23

this file is much smaller -- not sure if it is any more help though.

Result_nonemails.csv
Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 17:58:20

518914 500122 426639 91557 91538 70144 626918 622920 34822 544709 541627 504208 468995 396679 360090 319598 421278 445321 444723 127688 127268 811863 808665 765493 678965 231736 775434 770586 766375 765087 764979 764057 62220 801452 776791 776547 776468 776224 753621 739472 714764 682252 704853 778246 479200

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-30 17:58:40

not sure about the crump files as there might be a different process but here are a few I found

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 10:38:22

awesome -- to confirm this list is ones that were not sent

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 10:38:51

lmk and ill start diving on this today

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 10:43:04

the only ones I would need to double check on are the crump ones. They so email delivered but they do not have an email address....so maybe there is an internal process. I will check that out

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 10:46:04

well for these above, all were 100% for sure no email sent to the lawyer, you put together a good list above

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 10:46:17

so I can dive on the journeys

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 10:52:19

no, I had some crump ones in there, I just need to confirm or you could ask someone in integration if that means an email was sent

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 10:52:28

I'll give you an id for one

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 10:53:05

let me roll through some of these .. ill focus on this today

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 10:55:35

if you look on 2/9/24 it says system Email Status: delivered.

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 10:55:51

that is the one I am not sure about since we work with Crump here

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 10:56:51

yeah the issue is it ALWAYS sends an email to Someone

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 10:59:49

but usually it shows an email address where it sends...on crumps they don't

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:02:31

let me dig on some of this

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:02:33

brb

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:03:17

"AmexBenCrump@onderlaw.com, jon@bencrump.com",98129,AMEX Discrimination - Crump/Onder - Shield Legal,1075,Signed e-Sign FINAL

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:14:19

Ok. Digging on this. I have found something obscure.

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:14:57

Lead # 794693 -- 07/10/2025 03:53:22 PM Tort Intake Email sent via Scheduled AFFF PFAS Military Base Exposure - Levinson - ELG - TC SA - Shield Legal was triggered to , akinard@elglaw.com,Jonathan@elglaw.com,AFFFIntake@elglaw.com,dan@levinsonlegalgroup.com by Tort Intake

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:15:11

Where you see "Shield Legal was triggered to ," and then some emails.

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:17:21

Lead #623038 -- Email sent via Scheduled CA Juvenile Detention Abuse - Crump - Slater - Shield Legal - Declines was triggered to , bencrumpcases@bencrump.com,intake@sssfirm.com,selene@sssfirm.com,aslater@sssfirm.com by Tort Intake

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:17:25

however

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:19:13

Lead # 91781 -- 11/10/2022 10:50:07 AM Tort Intake Email sent via Scheduled AMEX Discrimination - Crump/Onder was triggered to , by Tort Intake Just like in the Terrell Blackmon case, this shows: "triggered to ," with what appears to be a blank recipient field. Followed by "Email Status : delivered" and "Email Status : opened"

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:19:52

So it seems we're looking in the logs for the marker: "Crump/Onder was triggered to , by Tort Intake"

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:20:26

I think I figured it out

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:36:46

ok cool

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:37:17

ill give you an update before I leave this is much more abstract of an issue than I thought

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:37:28

the only other piece would be if an api was triggered so there would be success or some sort of payload response

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:37:42

you'd think that -- i am going to spend more time on this

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:37:49

ill let you know in a bit where I am with this

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:38:13

deal

🙏 Chris Krecicki
Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:38:43

I do know I have seen quite a few with the api success response so it does exist

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:39:53

its just hard to believe how ... hard it is to get answers from the data. I am hoping with Tyson taking ownership of the data that this will eventually be cleaner

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:40:30

Between law ruler, looker, our postgres, and other data sources. Everything has wrong, missing or different data.

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:40:36

So give me a bit

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:41:47

yeah I know...it's everywhere.

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:41:51

thanks for digging in

🙏 Chris Krecicki
Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:42:07

anytime

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:50:24

also ... if you need a list of all the lawyers, for whatever reason, keep this on hand, these were the unique emails for lawyers only I pulled from a list of a few hundred thousand signed and the declined leads.

Lawyers-Emails.xlsx
Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:50:31

talk in a few

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:52:54

I was doing a brief look and I don't see an openjar.com on there

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:53:09

that was a marketing firm that popped up as well

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:53:13

this was just from the signed e-sign final and the declined I removed openjar

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:53:19

i didnt think that was a lawfirm

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:53:21

is it?

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:53:30

no but they did work for them

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:53:37

signed retainers and sent it to them

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:53:44

then openjar claimed it as theirs lol

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:53:54

💀

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:53:54

my old company did that a lot for people

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-07-31 11:54:11

so keep that one in there for cases being delivered or not

Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 11:54:26

lol ok diving back on this