deleted-U04R23BEW3V
2024-03-21 13:47:25

Hey Ryan! I’m currently in an ER with my wife. She’s got a medical emergency going on. I likely won’t be back to the office today to complete the BLX DQ report. I owe you a double report for tomorrow. I’m very sorry for the inconvenience

Ryan (ryan@themedialab.agency)
2024-03-21 14:50:58

Understand, best wishes for your partner.

deleted-U04R23BEW3V
2024-03-22 13:19:53

Much appreciated sir. My distain for the American health care system was reaffirmed yesterday but that's beyond my control.

Ryan (ryan@themedialab.agency)
2024-03-22 13:37:16

I feel you, lets sue more insurance companies to teach them a lesson for greedilly ruining it. LOL

deleted-U04R23BEW3V
2024-03-22 13:40:57

Lol you're speaking my language. Let's get after them!

deleted-U04R23BEW3V
2024-03-25 15:15:35

Hey Ryan! An agent just pointed out to me that Law Ruler deleted a Leadspedia ID in 409523. It says Agent 128 deleted it but she'd never touched the file. It's a Civil Rights LSA case so there's no retainer. Not sure if that'll cause problems for you or your team but I wanted to bring it to your attention regardless.

Ryan (ryan@themedialab.agency)
2024-03-25 15:29:47

*Thread Reply:* Have them add the file back Jackson, sent you information via the email. Please let me know the new LeadID when done.

deleted-U04R23BEW3V
2024-03-25 15:38:56

*Thread Reply:* On it. I'll let you know when the LeadID comes back

deleted-U04R23BEW3V
2024-10-21 18:03:56

Hey Ryan! I've been fighting with Law Ruler's server lag for the last 8 hours trying to complete the DQ reporting for Shield Legal. It doesn't look like I'll be able to complete the BLX reporting today (I'm waiting 15 minutes for the server to respond for each query). I'll get you the BLX reports first thing tomorrow if I'm not able to complete them today. I'm very sorry

Ryan (ryan@themedialab.agency)
2024-10-21 18:07:31

No problem.

deleted-U04R23BEW3V
2024-10-22 18:45:11

Still working on the DQ report for you. I promise I haven't forgotten

Ryan (ryan@themedialab.agency)
2025-01-21 13:41:12

@deleted-U04R23BEW3V, ASAP, need to know how to tell on this tab which are INJURY ONLY so i can fix everything

Ryan (ryan@themedialab.agency)
2025-01-21 13:41:52

Can you make a new column, highlight it YELLOW and tell me which is INJURY ONLY or do the same with a column and tell me the VALUES I need to filter on to know how map to the new revenue Cam is asking for

deleted-U04R23BEW3V
2025-01-21 13:42:22

Absolutely! Let me get on that right now!

Ryan (ryan@themedialab.agency)
2025-01-21 13:42:38

Thank you

Ryan (ryan@themedialab.agency)
2025-01-21 13:42:46

Going to lunch, let me know.

deleted-U04R23BEW3V
2025-01-21 13:42:54

Will do

deleted-U04R23BEW3V
2025-01-21 13:48:28

I added Column G "Injury Only" and highlighted the cell yellow for the applicable clients. They are rows 761-808 of the Report Data tab. I omitted files where the property ownership question was not specified. If you'd like me to include those, I'd be more than happy to highlight those as well

Ryan (ryan@themedialab.agency)
2025-01-21 15:20:48

I just need all 807 in there,

Ryan (ryan@themedialab.agency)
2025-01-21 15:21:03

So I know which ones are INJURY and which are not, are all 807 in there?

Ryan (ryan@themedialab.agency)
2025-01-21 15:21:14

@deleted-U04R23BEW3V

Ryan (ryan@themedialab.agency)
2025-01-21 15:21:40

I see they are, perfect

Ryan (ryan@themedialab.agency)
2025-01-21 15:21:42

thank you

Ryan (ryan@themedialab.agency)
2025-01-21 15:22:12

@deleted-U04R23BEW3V,hop on real quick

Ryan (ryan@themedialab.agency)
2025-01-21 15:28:47

Current billing 807

Modified billing Diagnosed with injury: 371 Property owners ONLY (no injury): 436

Updated total billing = 663,200

Mich Pollu.csv
deleted-U04R23BEW3V
2025-01-21 15:36:43

Ready to go! There were 36 leads with missing S1's from the report. Those 36 are all manual lead creations from agents

deleted-U04R23BEW3V
2025-01-21 15:37:14

The Injury Only group has been moved to the top of the spreadsheet for convenience