Ryan (ryan@themedialab.agency)
2025-08-20 11:04:02

@Ryan has joined the channel

Marc Barmazel (marc@sunrisessm.com)
2025-08-20 11:28:44

@Marc Barmazel has joined the channel

Cameron Rentch (cameron@internetthings.com)
2025-08-20 11:28:44

@Cameron Rentch has joined the channel

Zekarias Haile (zhaile@shield-legal.com)
2025-08-20 11:28:44

@Zekarias Haile has joined the channel

James Turner (jturner@shield-legal.com)
2025-08-20 11:28:44

@James Turner has joined the channel

Nick Ward (nicholas@tortintakeprofessionals.com)
2025-08-20 11:28:44

@Nick Ward has joined the channel

Carter Matzinger (cmatzinger@tortintakeprofessionals.com)
2025-08-20 11:28:44

@Carter Matzinger has joined the channel

Andy Rogers (andy@shield-legal.com)
2025-08-20 11:28:44

@Andy Rogers has joined the channel

slackbot
2025-08-20 11:28:50

tony from Tort Intake Professionals was added to this channel by ryanvaspra. You can review their permissions in Channel Details. Happy collaborating!

deleted-U04HFGHL4RW
2025-08-20 11:28:51

@deleted-U04HFGHL4RW has joined the channel

deleted-U04GZ79CPNG
2025-08-20 11:28:52

@deleted-U04GZ79CPNG has joined the channel

deleted-U06C7A8PVLJ
2025-08-20 11:28:53

@deleted-U06C7A8PVLJ has joined the channel

deleted-U08LK2U7YBW
2025-08-20 11:28:53

@deleted-U08LK2U7YBW has joined the channel

Ryan (ryan@themedialab.agency)
2025-08-20 11:47:21
image.png
Ryan (ryan@themedialab.agency)
2025-08-20 11:47:32
image.png
Ryan (ryan@themedialab.agency)
2025-08-20 11:47:45

has renamed the channel from "adminsltipsystemsreonciliation" to "adminsltip_reconcile"

Ryan (ryan@themedialab.agency)
2025-08-20 12:32:58

@Joe Santana ☝️:skintone4:

Ryan (ryan@themedialab.agency)
2025-08-20 12:44:44

@deleted-U04GZ79CPNG ☝️:skintone4:

Ryan (ryan@themedialab.agency)
2025-08-20 13:09:55

So @deleted-U04GZ79CPNG @Zekarias Haile, once @deleted-U06C7A8PVLJ posts tomorrows DECLINES, and Zek completes them. Then you can start August 2025 and backwards all the way to December 2023 to ensure we are reconciled. I'll expect this to take probably two to three days of effort but before Monday's report pull is the goal so we don't have miss counts.

Remember, never pull "today" for reports for clients out of any system @deleted-U04GZ79CPNG, LawRuler, Data Warehouse, etc.

👀 deleted-U06C7A8PVLJ, Zekarias Haile
Ryan (ryan@themedialab.agency)
2025-08-20 13:18:48

@deleted-U04GZ79CPNG @Zekarias Haile @deleted-U06C7A8PVLJ, let me know who else needs access if they do not already:

👍:skin_tone_3: Zekarias Haile
👀 deleted-U06C7A8PVLJ
🙌 deleted-U04GZ79CPNG
deleted-U04GZ79CPNG
2025-08-20 13:29:12

@Ryan I will be having a member of my team assist me with this. Can you make sure that esteban@tortintakeprofessionals.com has access to this dashboard?

Ryan (ryan@themedialab.agency)
2025-08-20 13:53:35

He does now @deleted-U04GZ79CPNG, and made TIP Operations Board his Home on Looker Enterprise.

deleted-U04GZ79CPNG
2025-08-20 14:13:25

Thank you!!

deleted-U06C7A8PVLJ
2025-08-21 12:58:04

@Ryan @Zekarias Haile S1's, Contract ID's, and Slack Alerts done. 802164, 830129, 830143, 826557, 701833, 827395, 827112, 822630, 813794, 810283, 806501, 790413, 820748, 818910, 563929, 747979, 804708, 734251, 727878, 728291, 402833, 353806, 711326, 710461, 710417, 701373, 604130, 428194

✅ Ryan
👀 Zekarias Haile
Ryan (ryan@themedialab.agency)
2025-08-21 13:01:44

@deleted-U072JS2NHRQ @Zekarias Haile @deleted-U06C7A8PVLJ, lets post all of these here so sales and leadership can follow along

Aidan Celeste (https://themedialaboratory.slack.com/team/U072JS2NHRQ)
<p>@Zekarias Haile Dashboard Reconciliation: Aug-Nov 2024</p> <p>August 2024 - TIP • Asbestos - Bailey Glasser - Shield Legal: 1 || Not in Shield Dash. TIP has 7 for Asbestos - BG - Levinson &amp; Shield has 7 for Asbestos - Bailey Glasser/Levinson (TC) (TIP) - Contract • Camp Lejeune - DL - Flatirons - Shield Legal: 14 || Shield Missing 1 • Chowchilla Womens Prison Abuse - ACTS - Levinson (TC) (TIP) - Shield Legal: 54 || Shield Missing 2 • Chowchilla Womens Prison Abuse - AWKO - AWKO (TIP) - Shield Legal: 20 || shield has 2 extra • Cooper Surgical IVF Botched Embryos - BS - BS - Shield Legal: 4 || Shield completely missing all 4 • MD Juv Hall - BG - Ghozland - Shield Legal: 11 || shield missing 1 • Paraquat - AWD - Wagstaff - Shield Legal: 22 || Shield missing 1 August 2024 - SHIELD • Camp Lejeune - Dicello/Flatirons (TIP) - Contract: 13 || Shield is missing 1 • Chowchilla Womens Prison Abuse - ACTS/Levinson (TC) (TIP) - Contract: 56 || Shield has 2 extra • Chowchilla Womens Prison Abuse - AWKO/AWKO (TIP) - Contract: 18 || Shield is missing 2 • Firefighting Foam - Bailey Glasser (TIP) - Contract: 1 || Not in TIP • Firefighting Foam - Cochran Firm (TIP) - Contract:1 || Not in TIP • Liquid Destroyed Embryo - Burg Simpson (TIP) - Contract: 4 || Shield Missing 4 • Maryland Juvenile Hall Abuse - BG/Ghozland (TIP) - Contract: 10 || shield missing 1 • Paraquat - AWD/Wagstaff (TIP) - Contract: 21 || Missing 1 - TIP has 22 --------------------------------------------------------------------------------------------------------------------------------------</p> <p>September 2024 - TIP Firefighting Foam - BG - Flanagan - Shield Legal: 8 || SHIELD MISSING 1</p> <p>September 2024 - SHIELD Firefighting Foam - Bailey Glasser/Flanagan (TikTok) (TIP) - Contract: 7 || SHIELD MISSING 1</p> <p>--------------------------------------------------------------------------------------------------------------------------------------</p> <p>October 2024 - TIP Illinois Juvenile Hall Abuse - BG - Meirowitz &amp; Wasserberg (TIP) - Shield Legal: 15 || SHIELD MISSING 1</p> <p>October 2024 - SHIELD Illinois Juvenile Hall Abuse - BG/Meirowitz &amp; Wasserberg (TIP) - Contract: 14 || SHIELD MISSING 1 Illinois Juvenile Hall Abuse - BG/Walsh (TIP) - Contract: 1 || Might be the one Shield is missing - might go in: "Illinois Juvenile Hall Abuse - BG/Meirowitz &amp; Wasserberg (TIP) - Contract"</p> <p>--------------------------------------------------------------------------------------------------------------------------------------</p> <p>November 2024 - TIP &amp; SHIELD good to go 👍:skin<em>tone</em>3:</p>
Slack Conversation
👀 deleted-U06C7A8PVLJ, Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-08-22 10:44:13

*Thread Reply:* Aug 2024 is reconciled

Aug 2024.png
🙏:skin_tone_4: Ryan
Zekarias Haile (zhaile@shield-legal.com)
2025-08-22 11:18:03

*Thread Reply:* Sep 2024 is reconciled.

Sep 2024.png
🙏:skin_tone_4: Ryan
Zekarias Haile (zhaile@shield-legal.com)
2025-08-22 12:11:51

*Thread Reply:* Oct 2024 is reconciled.

Oct 2024.png
🙏:skin_tone_4: Ryan
deleted-U072JS2NHRQ
2025-08-21 13:02:04

@deleted-U072JS2NHRQ has joined the channel

Zekarias Haile (zhaile@shield-legal.com)
2025-08-21 15:53:49

@Ryan @Cameron Rentch @deleted-U072JS2NHRQ @deleted-U04GZ79CPNG Aug 2025 is reconciled

image.png
deleted-U04GZ79CPNG
2025-08-21 15:55:08

@Ryan Esteban and I no longer have access to the reconciliation board

Ryan (ryan@themedialab.agency)
2025-08-21 16:14:02

The new one ?

Ryan (ryan@themedialab.agency)
2025-08-21 16:14:26

@deleted-U04GZ79CPNG

Ryan (ryan@themedialab.agency)
2025-08-21 16:14:28

?

Zekarias Haile (zhaile@shield-legal.com)
2025-08-21 16:35:09

Posting here for visibility

Martin R. (https://themedialaboratory.slack.com/team/U072B7ZV4SH)
<p>December 2024 - TIP: • Asbestos - BG - Kuzyk Law - Shield Legal 82 Missing 2 • Asbestos - Bailey Glasser - Shield Legal 20 Missing Two • Chowchilla Womens Prison Abuse - ACTS - ACTS (TIP) - Shield Legal 11 Missing 1 • Chowchilla Womens Prison Abuse - ACTS - Van (TIP) - Shield Legal 11 Has 1 more than Shield • Firefighting Foam - Crump - ELG - Shield Legal 56 1 more than Shield • Intuit Privacy Violations - Hilliard - Shield Legal 1,495 Has 2 more than Shield • Michigan Juv Hall Abuse - Bailey Glasser - Van - Shield Legal 40 1 less than Shield December 2024- SHIELD: • Asbestos - Bailey Glasser (TIP) - Contract 18 Missing 2 • Asbestos - Bailey Glasser/Kuzyk Law (TIP) - Contract 84 Has 2 more • Chowchilla Womens Prison Abuse - ACTS Law Firm (TIP) - Contract 12 Has 1 more • Chowchilla Womens Prison Abuse - ACTS Law Firm/Van (TIP) - Contract 10 Missing 1 • Firefighting Foam - Carson/ELG (TIP) - Contract 1 Not in TIP • Firefighting Foam - Crump/ELG (TikTok) (TIP) - Contract 4 1 less • Intuit Privacy Lawsuit - Hilliard (TIP) - Contract 1,493 2 less • Michigan Juvenile Hall Abuse - Bailey Glasser/Van (TIP) - Contract 41 1 more @Zekarias Haile</p>
Slack Conversation
Zekarias Haile (zhaile@shield-legal.com)
2025-08-27 13:54:31

*Thread Reply:* Dec 2024 is reconciled.

image.png
Ryan (ryan@themedialab.agency)
2025-08-21 17:01:26

@deleted-U06CVB2MHRN @deleted-U04GZ79CPNG @Zekarias Haile, this dashboard has been moved from SL Operations to TIP Operations Team folder, you have access now to .

👍:skin_tone_3: Zekarias Haile
deleted-U04GZ79CPNG
2025-08-21 17:38:13

Thank you!!

deleted-U06C7A8PVLJ
2025-08-22 11:52:49

@Ryan @Zekarias Haile S1's, Contract ID's, and Slack Alerts done.

423421 588417 708291 708912 763142 778702 789302 803522 811931 812629 816906 822738 825430 830919 831051 831087 831207

☝️:skin_tone_2: deleted-U06C7A8PVLJ
☝️:skin_tone_3: Zekarias Haile
☝️:skin_tone_4: Ryan
Zekarias Haile (zhaile@shield-legal.com)
2025-08-22 14:03:48

*Thread Reply:* April 2024 is reconciled.

April 2024.png
Zekarias Haile (zhaile@shield-legal.com)
2025-08-22 15:55:47

*Thread Reply:* June 2024 is reconciled.

image.png
Zekarias Haile (zhaile@shield-legal.com)
2025-08-22 16:29:29

*Thread Reply:* July 2024 is reconciled.

image.png
Zekarias Haile (zhaile@shield-legal.com)
2025-08-25 11:00:19

*Thread Reply:* Jan 2024 is reconciled.

Jan 2024.png
Zekarias Haile (zhaile@shield-legal.com)
2025-08-25 11:35:19

*Thread Reply:* Feb 2024 is reconciled.

image.png
🙏:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2025-08-25 12:03:10

*Thread Reply:* thanks guys, looking good!

:yourewelcome: Zekarias Haile
deleted-U06C7A8PVLJ
2025-08-25 12:37:12

@Ryan @Zekarias Haile S1's, Contract ID's, and Slack Alerts done. 802791 831729 831957 794146 831882 794795 801789 827144 822445 753693 818254 736470

👍:skin_tone_3: Zekarias Haile
👍:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-08-25 13:41:04

*Thread Reply:* March 2024 is reconciled.

image.png
Zekarias Haile (zhaile@shield-legal.com)
2025-08-25 14:44:39

July 2025 is reconciled

image.png
:meow_party: deleted-U06C7A8PVLJ
James Turner (jturner@shield-legal.com)
2025-08-26 11:24:40

*Thread Reply:* Can you please send me a csv of all of the leads?

James Turner (jturner@shield-legal.com)
2025-08-26 11:26:36

*Thread Reply:* just lawrulerleadid, billabledate (if applicable), and casetype

Zekarias Haile (zhaile@shield-legal.com)
2025-08-26 15:43:35

*Thread Reply:* what csv? wasn't sure you were asking me. sorry for the late reply

deleted-U06C7A8PVLJ
2025-08-26 11:56:41

@Ryan @Zekarias Haile S1's, Contract ID's, and Slack Alerts done. 834277, 833856, 680882, 833337, 833564, 833164, 832378, 827484, 813337, 806768, 807856, 805412, 814088, 821064

👍:skin_tone_3: Zekarias Haile
👍:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-08-27 13:48:49

@Ryan @Zekarias Haile S1's, Contract ID's, and Slack Alerts done. 834734 803934 834957 822501 820534 821056 652963 663129 661186 654690 650859

👍:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-08-28 13:34:27

June 2025 is reconciled.

image.png
deleted-U06C7A8PVLJ
2025-08-28 13:54:31

@Ryan @Zekarias Haile S1's, Contract ID's, and Slack Alerts done. 835419 836095 771747

👍:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-08-29 11:31:01

May 2025 is reconciled.

image.png
deleted-U06C7A8PVLJ
2025-08-29 12:08:11

@Ryan @Zekarias Haile S1's, Contract ID's, and Slack Alerts done. 824998 827203 836422 835331 833095 820894 802795 797926 692395 695092 685760

👍:skin_tone_3: Zekarias Haile
deleted-U04GG7BCZ5M
2025-08-29 13:09:31

@deleted-U04GG7BCZ5M has joined the channel

✅ deleted-U04GG7BCZ5M
Zekarias Haile (zhaile@shield-legal.com)
2025-08-29 16:20:07

Feb 2025 is reconciled.

image.png
🙏:skin_tone_4: Ryan
Zekarias Haile (zhaile@shield-legal.com)
2025-08-29 16:47:57

April 2025 is matched.

image.png
✅ Ryan