deleted-U06C7A8PVLJ
2024-12-03 11:21:35

Hey @Zekarias Haile The instructions Joe gave me was to first text him. Once he gives you the green light that he is ready to help assist you he will then request for you to reboot your computer and to re-login. Once you are logged in to just wait for him to take control of your computer and from there he will be able to assist.

Zekarias Haile (zhaile@shield-legal.com)
2024-12-03 11:25:41

Thanks Edward. I will do that.

deleted-U06C7A8PVLJ
2024-12-03 12:04:05

You're welcome @Zekarias Haile

deleted-U06C7A8PVLJ
2025-01-02 11:24:13

Dashboard

accounts.google.com
deleted-U06C7A8PVLJ
2025-01-02 14:53:08

@Zekarias Haile Ryan is in a meeting with me and asked you to hop into it. I shall send you the link

Zekarias Haile (zhaile@shield-legal.com)
2025-01-02 14:53:44

pls

Zekarias Haile (zhaile@shield-legal.com)
2025-01-02 14:55:51

Thanks Edward!

deleted-U06C7A8PVLJ
2025-01-02 14:56:03

You're welcome @Zekarias Haile

Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 10:05:36

Hi @deleted-U06C7A8PVLJ we are on the call with Ryan. Are you able to join?

deleted-U06C7A8PVLJ
2025-01-06 10:26:00

Sorry for late reply @Zekarias Haile I had told Ryan I was gonna be running a bit late but thanks for checking up on me

Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 10:26:52

NP! got it.

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-02-10 10:19:20

@deleted-U06C7A8PVLJ I think there is a Wood Pellet exposure injury Missing S1s, can you please check?

deleted-U06C7A8PVLJ
2025-02-10 10:33:49

Should all be good to go @Zekarias Haile

Zekarias Haile (zhaile@shield-legal.com)
2025-02-10 10:34:31

Ty!

deleted-U06C7A8PVLJ
2025-02-10 10:34:40

Yw

Zekarias Haile (zhaile@shield-legal.com)
2025-02-25 10:48:38

Gm @deleted-U06C7A8PVLJ there's missing S1s for wood pellet Injury T2. Can you please check?

Zekarias Haile (zhaile@shield-legal.com)
2025-02-25 10:55:01

Missing S1 for the 9 leads

👀 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-02-25 10:55:34

I see ! I shall run a query for all t2, t1 and t3 to see if I see any missing. One sec Zek

Zekarias Haile (zhaile@shield-legal.com)
2025-02-25 10:56:08

pls

Zekarias Haile (zhaile@shield-legal.com)
2025-02-25 10:56:09

Ty

deleted-U06C7A8PVLJ
2025-02-25 10:59:39

Okay should be good to go now let me know

Zekarias Haile (zhaile@shield-legal.com)
2025-02-25 11:00:21

Ty!

deleted-U06C7A8PVLJ
2025-02-25 11:01:22

YW ! I only saw 1 that wasn't on there so hopefully they all show if not might be something from SL end? I am not sure but all S1s for all three wood campaigns show that they have S1s from my end

Zekarias Haile (zhaile@shield-legal.com)
2025-02-25 11:01:47

I see that too. Ty

deleted-U06C7A8PVLJ
2025-02-25 11:02:22

Perfect. yw

Zekarias Haile (zhaile@shield-legal.com)
2025-02-27 15:41:45

Hey Edward, Ryan told me that you are taking Looker enterprise course on udemy, and I wanted to know how do you like the course so far?

deleted-U06C7A8PVLJ
2025-02-27 15:48:25

Hey @Zekarias Haile! The course is actually going really well! I haven’t used Power BI or Tableau before, but so far, Looker seems intuitive and easy to use. I purchased two courses—one focuses on using "Explores," which are data models built on top of SQL-based databases (like BigQuery tables that we use). Explores allow users to query data and create visualizations directly within Looker. The course explains that traditional BI tools like Power BI and Tableau often require an ETL process to clean and transform data before it’s used for reporting. Looker, on the other hand, leverages LookML, which acts as a modeling layer rather than an ETL tool. LookML defines how data is structured and relationships between tables, but the actual data transformation (ETL) is typically handled upstream in a data warehouse like BigQuery. LookML is maintained by developers or administrators within Looker Enterprise. So, the course I’m currently taking is focused on the analytics side—learning how to use Looker, its features, and key terminology. Once I complete this, they recommend moving on to the next course, which covers LookML and how to model data effectively for Looker Enterprise.

deleted-U06C7A8PVLJ
2025-02-27 15:51:25

If you are interested in taking the same one I can share you the link and I recommend getting it on a udemy sale which can be around $10-20 per a course with lifetime access

Zekarias Haile (zhaile@shield-legal.com)
2025-02-27 15:56:27

Great! Thanks for the detail info. I would love to to take a look so please share the course with me. Thanks!

deleted-U06C7A8PVLJ
2025-02-27 15:58:24

No prob ! Here it is

🙏 Zekarias Haile
deleted-U06C7A8PVLJ
2025-03-05 16:30:08

Hey @Zekarias Haile Sorry for the delay from my end. I was taking good notes and asking him questions on the side and over the phone afterwards to ensure once I press that update button nothing goes wrong so once I got all of that resolved I ran my query and I am done with my part. Since I took good notes on this in the future I can do it in a timely manner since I am not sure if you are about to leave / you clock out time is

Zekarias Haile (zhaile@shield-legal.com)
2025-03-05 16:32:28

No worries @deleted-U06C7A8PVLJ. I'm about to leave in 30min, so i will finish up tomorrow. Good job 💪

👀 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-03-05 16:32:50

Thanks for understanding ! Sounds good. Have a great rest of your shift and thank you !!

Zekarias Haile (zhaile@shield-legal.com)
2025-03-05 16:33:13

you as well. Ty!

deleted-U06C7A8PVLJ
2025-03-06 09:49:42

Hey @Zekarias Haile Friendly heads up it may take me 1-2 hours to complete S1s today. Ryan and I had a meeting and we think the AWS code is overriding wood pellet values where it is setting them back to their original value. Meaning all the S1s I ever done are now gone and seems like it is doing this daily. I am noticing this now but based on a slack message I saw Ryan noticed it a month ago. So has to be the python code they have. So may take some time for me to do my part today

deleted-U06C7A8PVLJ
2025-03-06 09:49:58

I have 260 blank S1s to look for

Zekarias Haile (zhaile@shield-legal.com)
2025-03-06 09:52:33

Understood. Thanks for the heads up @deleted-U06C7A8PVLJ. You got this bro 💪

deleted-U06C7A8PVLJ
2025-03-06 09:53:02

You're welcomes and thank you 🥹

🙏 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-03-07 11:55:28

Im sorry I muted you it has background noise 😊

deleted-U06C7A8PVLJ
2025-03-07 12:40:04

No worries I think my mic was acting weird when that happen

🙏 Zekarias Haile
deleted-U06C7A8PVLJ
2025-03-07 12:40:07

Thank you for muting me

Zekarias Haile (zhaile@shield-legal.com)
2025-03-07 12:44:09

Np @deleted-U06C7A8PVLJ

Zekarias Haile (zhaile@shield-legal.com)
2025-03-07 12:44:32

Did u say Ryan record today's meeting?

deleted-U06C7A8PVLJ
2025-03-07 12:48:48

I think you asked and he said yes and then I think you asked him again through the chat and then I said that you can. Not sure if we did

deleted-U06C7A8PVLJ
2025-03-07 12:49:00

But I simply just took notes and screenshots, etc from the Tip's side

Zekarias Haile (zhaile@shield-legal.com)
2025-03-07 12:52:52

ohh I see. I thought you said he is recording. But not a problem. I will listen the fireflies note.

deleted-U06C7A8PVLJ
2025-03-07 12:54:08

Sorry about that Zek

Zekarias Haile (zhaile@shield-legal.com)
2025-03-07 12:55:23

no worries. it's not your fault at all

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-03-12 16:25:19

hi @deleted-U06C7A8PVLJ I'm showing these LR Lead ID doesn't have S1

693550 695334 695676 695675 69007 For T2 694004 For T1

deleted-U06C7A8PVLJ
2025-03-12 16:58:31

*Thread Reply:* I added the S1s for these all except 69007 since looks like it is missing a digit?

Zekarias Haile (zhaile@shield-legal.com)
2025-03-12 16:52:44

@deleted-U06C7A8PVLJ just a friendly reminder, Ryan said you need to post in both table and slack channels. Whenever you done. TY

deleted-U06C7A8PVLJ
2025-03-12 16:55:13

Sorry ! You mean to post this type of table in logistics chat? :

deleted-U06C7A8PVLJ
2025-03-12 16:55:21

When completing my things in the morning?

deleted-U06C7A8PVLJ
2025-03-12 16:55:49

Or to post when I back fill all the S1s for wood pellet and that other campaign

Zekarias Haile (zhaile@shield-legal.com)
2025-03-12 17:00:49

Im not sure what he meant but he said ask Edward to post the s1 in both table and slack channel

deleted-U06C7A8PVLJ
2025-03-12 17:01:30

I think that is what he means. Do you know if he is taking tomorrow and Friday off or is that for next week?

Zekarias Haile (zhaile@shield-legal.com)
2025-03-13 09:06:40

I think it’s for next week. Coz we have meeting later

deleted-U06C7A8PVLJ
2025-03-13 09:07:04

Ah that makes sense. Thanks for the update !

Zekarias Haile (zhaile@shield-legal.com)
2025-03-13 09:07:29

Np!

☝️:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-03-13 14:32:23

Hey @Zekarias Haile He is here (esteban) and ready to talk

Zekarias Haile (zhaile@shield-legal.com)
2025-03-13 14:32:53

ok. Coming

☝️:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-03-13 14:37:42

```-- This will give you all the fields and their values for all Wood Pellet Case Types

SELECT lrleadid, typeofcase, parentcasetype, casetyperetainercode, lpcontractid, lpcontractname, lpcontractsettingsprice, lpcontractscheduledowprice, lpleadid, lpleads1 FROM SL table goes here WHERE typeofcase IN ( 'Wood Pellet Exposure Injury T1 - Crump - ELG - Shield Legal', 'Wood Pellet Exposure Property - Crump - ELG - Shield Legal', 'Wood Pellet Exposure Injury T2 - Crump - ELG - Shield Legal' ) ORDER BY lpleads1 ASC;```

🙏 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-03-13 15:28:42
deleted-U06C7A8PVLJ
2025-03-14 13:04:20

Received. Does he want you to do something with this by today?

Zekarias Haile (zhaile@shield-legal.com)
2025-03-14 13:06:19

yes, he wants me to do the reconciliation that Esteban posted yesterday

deleted-U06C7A8PVLJ
2025-03-14 13:07:31

Gotcha. Yeah I think I will be done with the S1s for wood pellet in 30-60 mins and from there I can watch the video how and we can talk about what is needed for the reconciliation if that works?

Zekarias Haile (zhaile@shield-legal.com)
2025-03-14 13:08:49

sounds good. Ty

deleted-U06C7A8PVLJ
2025-03-14 13:09:05

You're welcome bro

deleted-U06C7A8PVLJ
2025-03-14 14:03:35

I finished the S1s for wood pellet. I think I shall be taking a lunch pretty soon and then watch that video. I just need to type in the SQL query to update those 434 LR leads for wood pellet and we should be back filled for those

Zekarias Haile (zhaile@shield-legal.com)
2025-03-14 14:06:40

Sounds good. Enjoy your lunch and let me know when you’re ready. Ty!

deleted-U06C7A8PVLJ
2025-03-14 14:26:42

Thank you ! Okay I shall be going into lunch at 12:30 pm and if you want to watch the video together I think 1pm may work for my end if it works for your end

Zekarias Haile (zhaile@shield-legal.com)
2025-03-14 14:29:28

I already watched it. So I will join you once u watched it.

deleted-U06C7A8PVLJ
2025-03-14 14:29:48

Sounds good !

Zekarias Haile (zhaile@shield-legal.com)
2025-03-17 12:49:20

Hey @deleted-U06C7A8PVLJ can you please add me on Chowchilla channel?

deleted-U06C7A8PVLJ
2025-03-17 13:01:20

Hey @Zekarias Haile Added

Zekarias Haile (zhaile@shield-legal.com)
2025-03-17 13:03:35

Ty!

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-03-17 13:45:47

I have a question for u. Are u at ur desk?

deleted-U06C7A8PVLJ
2025-03-17 14:05:34

Off by 1 in TIP's end.

deleted-U06C7A8PVLJ
2025-03-17 14:05:50

This is the client it is missing

deleted-U06C7A8PVLJ
2025-03-17 14:06:24

However on TIP's dashboard which is v2 all 7 are there

Zekarias Haile (zhaile@shield-legal.com)
2025-03-18 14:31:19

@deleted-U06C7A8PVLJ Im showing missing S1 for T2 on March 16

deleted-U06C7A8PVLJ
2025-03-18 14:41:37

@Zekarias Haile Checking

👀 Zekarias Haile
deleted-U06C7A8PVLJ
2025-03-18 14:45:15

Okay should be good now

Zekarias Haile (zhaile@shield-legal.com)
2025-03-18 14:47:39

Ty!

:triplets_parrot: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-03-24 13:57:57

Hey Zek. Martin R requested that I switched these to Michigan Injury Pollution instead of the other michigan one since that is the correct one (what is shown in LR). So I just updated these right now and I am informing you as well just in case you need to update it from your end as well in SL dashboard.

Martin R. (https://tortintakepros.slack.com/team/U072B7ZV4SH)
Zekarias Haile (zhaile@shield-legal.com)
2025-03-24 14:29:52

Hi Edward, so you changed to Michigan Pollution? And did Ryan know about that?

deleted-U06C7A8PVLJ
2025-03-24 14:30:44

Hi @Zekarias Haile I had so far just informed you since he (Ryan) may just let you know to change it from your end (my guess) but if you prefer for me to let him know instead I can

deleted-U06C7A8PVLJ
2025-03-24 14:30:59

Since I feel like he will be delegating these small type of tasks to us (my feeling)

Zekarias Haile (zhaile@shield-legal.com)
2025-03-24 14:31:28

yeah, that would be good if you could let him know. Ty

deleted-U06C7A8PVLJ
2025-03-24 14:31:42

Sounds good !

Zekarias Haile (zhaile@shield-legal.com)
2025-03-24 14:32:16

yup you are correct but just for sake of informing him

Zekarias Haile (zhaile@shield-legal.com)
2025-03-24 14:32:36

u and me are going to do it haha

deleted-U06C7A8PVLJ
2025-03-24 14:32:49

Yeah you are right haha

deleted-U06C7A8PVLJ
2025-03-24 14:32:59

Okay I just forwarded the message to him and us to be on safe side as well

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-03-25 14:50:22

@deleted-U06C7A8PVLJ can you please check this missing S1 for Wood T2 please

deleted-U06C7A8PVLJ
2025-03-25 14:53:08

@Zekarias Haile Updated

🙏 Zekarias Haile
:lets_go: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-03-27 10:13:11

Hi Edward, do u know if we have this contract?

Zekarias Haile (https://themedialaboratory.slack.com/team/U07P7DV2A0Z)
:eyes_3d: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-03-27 10:16:35

To me these look the same (except the ACTs) part but since they have similar count I would say yes

Zekarias Haile (zhaile@shield-legal.com)
2025-03-27 10:19:38

Do u have Leadespedia coontract ID for both?

Zekarias Haile (zhaile@shield-legal.com)
2025-03-27 10:23:53

Ryan said CA- JUV-DL/Flatiron is the correct one. Thanks for ur help @deleted-U06C7A8PVLJ

deleted-U06C7A8PVLJ
2025-03-27 10:43:37

Sorry was on break and then had to talk to someone afterwards

Zekarias Haile (zhaile@shield-legal.com)
2025-03-27 10:50:21

*Thread Reply:* No worries

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-03-27 10:43:47

If they are the same shouldn't they ahve same leadspedia contract?

deleted-U06C7A8PVLJ
2025-03-27 10:43:54

I think they may be it? :

Zekarias Haile (zhaile@shield-legal.com)
2025-03-27 10:47:36

I know, they should have the same contract id

Zekarias Haile (zhaile@shield-legal.com)
2025-03-27 10:48:15

so he told me to use 1355

deleted-U06C7A8PVLJ
2025-03-27 10:50:36

Gotcha yeah sounds correct to me

deleted-U06C7A8PVLJ
2025-03-27 10:51:12

Yeah we can find those by going into Law ruler and into notes and if you see something like what i showed you thru screenshots above, it is always the last 4 digits

deleted-U06C7A8PVLJ
2025-03-27 10:51:39

But if they change it to a different case type such as T1 to T2 then it wouldn't be what's shown in LR but rather in our dashboard under shield contracts

Zekarias Haile (zhaile@shield-legal.com)
2025-03-27 10:53:39

Got it, thanks man again

:cool_doge: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-03-28 13:00:28

hey @deleted-U06C7A8PVLJ I don't see this neither on the dash nor on the database.... I'm wondering if this was on different date

I checked 2024/07/04

deleted-U06C7A8PVLJ
2025-03-28 13:07:54

Since this is a signed & declined it wouldn't pull up in the dashboard (unless you have a specific look / dashboard that shows signed and declines) which the SL vs TIP comparison table shouldn't show s&ds

deleted-U06C7A8PVLJ
2025-03-28 13:08:02

It is showing in TIP's database

deleted-U06C7A8PVLJ
2025-03-28 13:08:18

It's signed date is 2024/07/04

Zekarias Haile (zhaile@shield-legal.com)
2025-03-28 13:10:51

you're right but what I meant when I say in the dash is that it should show more than 1 lead in SL since the signed & declined is not removed manually.... but now when I try to look it's showing me nothing

Zekarias Haile (zhaile@shield-legal.com)
2025-03-28 13:11:15

does that make sense?

deleted-U06C7A8PVLJ
2025-03-28 13:25:23

Ohhh gotcha

deleted-U06C7A8PVLJ
2025-03-28 13:25:36

Yeah if it is removed in TIP then should be 1 more in SL since you would need to remove it in SL too

deleted-U06C7A8PVLJ
2025-03-28 13:25:39

But you can't find it in SL?

Zekarias Haile (zhaile@shield-legal.com)
2025-03-28 13:28:59

yup

deleted-U06C7A8PVLJ
2025-03-28 13:29:15

I wonder if it was in SL to begin with lol

😀 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-03-28 13:29:43

who knows haha

🤣 deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-03-28 13:31:33

It looks like it wasnt there as you said haha

Zekarias Haile (zhaile@shield-legal.com)
2025-03-28 13:31:57

self reconciled lead... appreciated haha

Zekarias Haile (zhaile@shield-legal.com)
2025-03-28 13:32:57

I guess SL knew that it is going to be declined so it didn't record it at the first place

deleted-U06C7A8PVLJ
2025-03-28 14:44:36

Oh wow 🤣

deleted-U06C7A8PVLJ
2025-03-28 14:44:38

Yeah I agree

deleted-U06C7A8PVLJ
2025-03-28 14:44:49

Can't verify something that isn't there to be verified 🤣

😄 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:16:31

Good morning @deleted-U06C7A8PVLJ on 3/29 Wood pellet T2 and property and Michigan pollution has missing S1s. Please take a look when you get a chance. Ty!

deleted-U06C7A8PVLJ
2025-03-31 09:17:15

Good Morning @Zekarias Haile Sounds good !

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:18:58
Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:34:49

*Thread Reply:* This was blank as you can see

deleted-U06C7A8PVLJ
2025-03-31 09:22:22

I ran a query for all three wood pellets and I am not seeing any with blank S1s

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:24:39

No. I just randomly assigned S1s yesterday when I do the financials. Wondering if we can get the right one

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:25:14
Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:25:53

Here's how I did it

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:26:31

it's for 3/29 btw not today's (3/30)

deleted-U06C7A8PVLJ
2025-03-31 09:27:31

So to confirm do you want me to fill in the blank S1s or to replace S1s with different S1s for certain clients?

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:31:43

I want to confirm JA has Wood T2 and MI pollution deal yesterday and ML has wood property, as I randomly filled the S1s yesterday. Does that make sense?

deleted-U06C7A8PVLJ
2025-03-31 09:32:43

Gotcha that makes more sense. And you are referring to specifically 3/29 correct

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:33:28

yes

deleted-U06C7A8PVLJ
2025-03-31 09:33:49

Okay I shall look into that then

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 09:34:22

Thanks

☝️:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-03-31 10:04:15

Type of Case: Michigan Pollution - Ben Crump Law - ELG - Shield Legal Signed Date: 03-29-2025 LRLeadID: 705337 LPLeadS1: PL-FacebookMB-MLtestdetna_2

✅ Zekarias Haile
deleted-U06C7A8PVLJ
2025-03-31 10:04:30

This one is for Michigan Pollution let me know if you need the injury one

deleted-U06C7A8PVLJ
2025-03-31 10:04:38

I shall look for the wood pellets too

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 10:05:50

it was only Michigan Pollution no Injury

deleted-U06C7A8PVLJ
2025-03-31 10:15:47

Okay perfect

deleted-U06C7A8PVLJ
2025-03-31 10:18:04

This is the T2 wood pellet for 3-29-2025

deleted-U06C7A8PVLJ
2025-03-31 10:19:02

Same date but wood pellet (regular)

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 10:19:44

regular means property?

deleted-U06C7A8PVLJ
2025-03-31 10:19:48

Yes

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 10:19:56

on 29/ we had T2 and property only

deleted-U06C7A8PVLJ
2025-03-31 10:20:04

Yes

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 10:20:40

alright so both are for JA?

deleted-U06C7A8PVLJ
2025-03-31 10:20:54

Looks like it for both wood pellets

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 10:21:10

got it. Ty @deleted-U06C7A8PVLJ

☝️:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-03-31 10:21:11

Pollution one looks like ML

Zekarias Haile (zhaile@shield-legal.com)
2025-03-31 10:21:20

yup

🙏:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-04-01 13:07:58

Im showing missing S1s on the declines. please take a look

Zekarias Haile (zhaile@shield-legal.com)
2025-04-01 13:43:09

NVM, Actually I figured

deleted-U06C7A8PVLJ
2025-04-01 13:48:29

Sorry @Zekarias Haile I was in lunch

deleted-U06C7A8PVLJ
2025-04-01 13:48:46

Let me know if you still need any assistance

Zekarias Haile (zhaile@shield-legal.com)
2025-04-01 13:50:28

No worries. Will do. Thanks!

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-04-02 15:35:56

@deleted-U06C7A8PVLJ am I correct?

:eyes_3d: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-04-02 15:54:56

I would say you are correct

deleted-U06C7A8PVLJ
2025-04-02 15:55:05

That one came in today so we should be working on that tomorrow

Zekarias Haile (zhaile@shield-legal.com)
2025-04-02 15:56:43

Sounds good. I Just wanna confirm. Also a friendly reminder for you when you do the S1s this is going to be Cam's. TY!

deleted-U06C7A8PVLJ
2025-04-02 15:57:39

Copy that. This one is Cam's noted

🙏 Zekarias Haile
deleted-U06C7A8PVLJ
2025-04-02 15:57:53

Don't want a repeat of yesterday's post 🤣

😅 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-02 15:58:18

I know we dont haha

😆 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-04-03 12:22:01

I am assuming from yesterday post from Cam when he says google he is referring to himself right lol @Zekarias Haile

deleted-U06C7A8PVLJ
2025-04-03 12:22:13

That's what I put for this morning as the S1 for Nath K

Zekarias Haile (zhaile@shield-legal.com)
2025-04-03 12:30:03

yes, that is correct

Zekarias Haile (zhaile@shield-legal.com)
2025-04-03 12:30:13

Thanks for that

deleted-U06C7A8PVLJ
2025-04-03 13:02:33

Perfect. & You're welcomes. Thanks for the confirmation

👍 Zekarias Haile
deleted-U06C7A8PVLJ
2025-04-04 10:20:21

Good morning @Zekarias Haile

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:20:40

GM @deleted-U06C7A8PVLJ Im showing missing S1 for paraquat DL_ML

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:20:46
Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 11:56:25

*Thread Reply:* it was 9 CP and 3 JA earlier. Now im showing 8CP and 4 JA Any idea why?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 11:56:35

*Thread Reply:* @deleted-U06C7A8PVLJ

deleted-U06C7A8PVLJ
2025-04-04 12:06:31

*Thread Reply:* Hmm I did not update a S1 unless it was blank so not 100 sure tbh

👍 Zekarias Haile
deleted-U06C7A8PVLJ
2025-04-04 12:06:41

*Thread Reply:* Which was based on our earlier message

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 12:07:58

*Thread Reply:* The blank was the one you assigned to CP… that was on top

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 12:08:03

*Thread Reply:* Has 2 leads

deleted-U06C7A8PVLJ
2025-04-04 10:20:58

I shall check that out rn one second

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:22:14

And Wood T2

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:22:18

pls

deleted-U06C7A8PVLJ
2025-04-04 10:22:34

Hmm I wonder what paraquat case type that is

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:23:31

What do u mean by that? It's Paraquat- Dicello- Meadow Law

deleted-U06C7A8PVLJ
2025-04-04 10:23:45

Ohh okay I know SL has different name compared to TIP

deleted-U06C7A8PVLJ
2025-04-04 10:23:48

For same case type haha

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:23:53

it's most likely for CP

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:24:00

ohh I see

deleted-U06C7A8PVLJ
2025-04-04 10:26:17

Okay for the Paraquat one it is in "Disqualified status" and I checked if they signed the retainer and they never did

deleted-U06C7A8PVLJ
2025-04-04 10:26:29

So technically this shouldn't be in the dashboard at all.

deleted-U06C7A8PVLJ
2025-04-04 10:26:37

So for me to review it from TIP I have to put it as signed & Declined status

deleted-U06C7A8PVLJ
2025-04-04 10:26:45

to remove it from TIP **

deleted-U06C7A8PVLJ
2025-04-04 10:27:36

Do you still need the S1 for it though?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:28:37

yes please, since it's on e-signs yesterday, I have to record it and will remove when you post the declines

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:29:00

yes please, since it's on e-signs yesterday, I have to record it and will remove when you post the declines

deleted-U06C7A8PVLJ
2025-04-04 10:29:03

copy that

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:29:35

so it's going to be umder today's declines or probably tomorrow?

deleted-U06C7A8PVLJ
2025-04-04 10:35:00

I would put it as todays

deleted-U06C7A8PVLJ
2025-04-04 10:35:09

Since the status is disqualified

deleted-U06C7A8PVLJ
2025-04-04 10:35:17

But for me to remove it from TIP's dashboard I have to put it as signed and declined

deleted-U06C7A8PVLJ
2025-04-04 10:35:22

That's how Ryan's dashboard works

deleted-U06C7A8PVLJ
2025-04-04 10:35:25

For TIP's end

deleted-U06C7A8PVLJ
2025-04-04 10:35:33

Also here is the S1 for wood pellet

deleted-U06C7A8PVLJ
2025-04-04 10:35:34

FacebookMB-MLSCCITY1

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:36:52

Sounds good.

deleted-U06C7A8PVLJ
2025-04-04 10:37:32

I am only seeing one blank / missing S1 which is the one I gave you for wood pellet

deleted-U06C7A8PVLJ
2025-04-04 10:37:36

I am looking up the paraquat again

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:37:44

This for Wood T2 right?

deleted-U06C7A8PVLJ
2025-04-04 10:37:50

Yes

🙏 Zekarias Haile
deleted-U06C7A8PVLJ
2025-04-04 10:41:35

PL-FacebookMB-CPCMP-PQ_F6

deleted-U06C7A8PVLJ
2025-04-04 10:41:39

Would be for the paraquat one

deleted-U06C7A8PVLJ
2025-04-04 10:41:54

If it is just those two S1s we should be good

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:43:34

Thanks Man!

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 10:43:48

yes, it should be good now

deleted-U06C7A8PVLJ
2025-04-04 10:44:03

Sounds good and np

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 14:03:45

Hey @Tort iNtake

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 14:04:36

i was sending u to change it

deleted-U06C7A8PVLJ
2025-04-04 14:44:15

Thank you @Zekarias Haile sorry just eeing this

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 14:53:27

No worries man

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 14:53:32

Im tired now

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 14:54:13

looking forward for the meeting just ended now

Zekarias Haile (zhaile@shield-legal.com)
2025-04-04 14:54:16

hahah

deleted-U06C7A8PVLJ
2025-04-04 16:16:23

haha

deleted-U06C7A8PVLJ
2025-04-07 15:21:10

Hey @Zekarias Haile

deleted-U06C7A8PVLJ
2025-04-07 15:21:12

Question for you

deleted-U06C7A8PVLJ
2025-04-07 15:21:20

Do you handle any of the secondary / VSS stuff in SL?

deleted-U06C7A8PVLJ
2025-04-07 15:21:35

Such as if one goes from a billable status to now a non-billable status you need to update it from your end as well?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-07 15:21:45

Fortunately no

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

Haha

deleted-U06C7A8PVLJ
2025-04-07 15:22:13

Oh okay since I am seeing some that are going from billable to non billable and wanted to make sure I inform you about it

deleted-U06C7A8PVLJ
2025-04-07 15:22:18

But I think I shall also ask this to Ryan

deleted-U06C7A8PVLJ
2025-04-07 15:22:22

Since maybe he does?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-07 15:22:26

Do you know Alexandria?

deleted-U06C7A8PVLJ
2025-04-07 15:22:30

Yes

Zekarias Haile (zhaile@shield-legal.com)
2025-04-07 15:22:35

Do you know Alexandria?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-07 15:22:44

You should ask her

Zekarias Haile (zhaile@shield-legal.com)
2025-04-07 15:22:57

She would probably give you an answer

deleted-U06C7A8PVLJ
2025-04-07 15:22:58

I see ! Okay I shall ask her thank you 🙌:skintone2:

Zekarias Haile (zhaile@shield-legal.com)
2025-04-07 15:23:03

Np!

Zekarias Haile (zhaile@shield-legal.com)
2025-04-08 11:19:05

Hey @deleted-U06C7A8PVLJ are those leads in Secondary interview status? that's what Im showing

Edward Weber (https://themedialaboratory.slack.com/team/U06C7A8PVLJ)
deleted-U06C7A8PVLJ
2025-04-08 11:19:17

Correct

Zekarias Haile (zhaile@shield-legal.com)
2025-04-08 11:19:31

And I dont see them on the billable leads

Zekarias Haile (zhaile@shield-legal.com)
2025-04-08 11:19:36

and TIP dash

deleted-U06C7A8PVLJ
2025-04-08 11:20:48

Yeah the screenshot shows I added them into the dashboard since those rows once inserted then goes into the dashboard?

deleted-U06C7A8PVLJ
2025-04-08 11:21:14

Example

Zekarias Haile (zhaile@shield-legal.com)
2025-04-08 11:22:55

hmm I dont see on the Billable leads and Tip dash when I filter with those dates tho

Zekarias Haile (zhaile@shield-legal.com)
2025-04-08 11:24:00

Plus, those were added as intake I would assume when during sign e-sign process

deleted-U06C7A8PVLJ
2025-04-08 11:24:07

I think it was never added in TIP I had to add it manully

deleted-U06C7A8PVLJ
2025-04-08 11:24:22

So that is why SL doesn't have

deleted-U06C7A8PVLJ
2025-04-08 11:24:24

My guess

Zekarias Haile (zhaile@shield-legal.com)
2025-04-08 11:24:29

and also it doesnt have Sl

deleted-U06C7A8PVLJ
2025-04-08 11:24:40

I am not sure if you do secondaries?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-08 11:24:45

yes probably

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

I haven't done yet

Zekarias Haile (zhaile@shield-legal.com)
2025-04-08 11:25:18

But will ask Ryan how to handle it

deleted-U06C7A8PVLJ
2025-04-08 11:27:12

Yeah I would ask him to be on safe side

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 11:33:11

SELECT campaign, sum(cdailyleads) FROM dashboard.matviewfinancialdetails WHERE revdate BETWEEN '2025-03-01' AND '2025-03-31' AND saletype = 'Contract' AND cdailyleads > 0 GROUP BY campaign ORDER BY campaign ASC

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 13:52:10

going rest room brb

deleted-U06C7A8PVLJ
2025-04-10 14:07:20

kk

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 14:08:09

Actually I dont see that number on the dashboard that I thought he mentioned

deleted-U06C7A8PVLJ
2025-04-10 14:16:07

I see what # do you see on the dashboard?

deleted-U06C7A8PVLJ
2025-04-10 14:26:45

I shall hop off it and once he says hop on lets hop on lol

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 14:51:00

I was double checking everything and I see that Bard powerport doesnt seem right

deleted-U06C7A8PVLJ
2025-04-10 15:18:18

Sorry was at lunch

deleted-U06C7A8PVLJ
2025-04-10 15:18:22

What seems off about Bard?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 15:24:47

No worries

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 15:25:33

I think the total should be 24,003.44

deleted-U06C7A8PVLJ
2025-04-10 15:26:43

Oh okay perfect

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 15:27:25

But that is going to widen the gap for sure

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 15:27:36

But that is going to widen the gap for sure

deleted-U06C7A8PVLJ
2025-04-10 15:27:55

I would just ask Ryan if $ is okay for what is shown in #34 ?

deleted-U06C7A8PVLJ
2025-04-10 15:28:00

34 the dashboard

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 15:28:34

I did,, did you see that above your message

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 15:28:42

but he didnt answer

deleted-U06C7A8PVLJ
2025-04-10 15:28:51

Yeah you are right

deleted-U06C7A8PVLJ
2025-04-10 15:28:59

Maybe we need to create a thread and retag him on it? lol

😆 Zekarias Haile
deleted-U06C7A8PVLJ
2025-04-10 15:36:14

He used #34 but our #34 is different than his #34

deleted-U06C7A8PVLJ
2025-04-10 15:36:24

He has like #34.b and we have #34.a or something

🤣 deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 15:37:06

or really ? dont remember that tho

deleted-U06C7A8PVLJ
2025-04-10 15:37:37

It could be

deleted-U06C7A8PVLJ
2025-04-10 15:38:34

I think you should post a link to that dashboard and ask Ryan is this the correct one since this one says #34 but our number looks different compared to what we saw earlier ago

deleted-U06C7A8PVLJ
2025-04-10 15:40:13

Yeah because if he says yes to that link then he has a filter that we are not seeing or it got updated after our talk with him lol

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 15:52:21

Ryan is out of office now

deleted-U06C7A8PVLJ
2025-04-10 15:57:11

I see

deleted-U06C7A8PVLJ
2025-04-10 15:57:30

Okay. Do you want to later on today or tomorrow make a quick little recording on what we did today so we can use it for next month if we have questions

deleted-U06C7A8PVLJ
2025-04-10 15:57:38

Like a training / recording for us on google meet

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 15:57:57

Let's do tmrw pls

deleted-U06C7A8PVLJ
2025-04-10 15:58:06

sounds good

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 16:49:34

@deleted-U06C7A8PVLJ is he saying that the cost matches? im confused

deleted-U06C7A8PVLJ
2025-04-10 16:52:29

To me it sounds like we are good to update

deleted-U06C7A8PVLJ
2025-04-10 16:52:52

So I think we are in the clear to update and insert pgadmin

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 16:58:06

Right? I was hoping a go head message from him

deleted-U06C7A8PVLJ
2025-04-10 16:58:28

Yeah I would just say I shall update / insert those rows then

deleted-U06C7A8PVLJ
2025-04-10 16:58:54

He will most likely just like your comment or say yes

deleted-U06C7A8PVLJ
2025-04-10 16:59:03

But I think you are in the clear since to me sounds like it is a yes

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 17:00:04

i see

Zekarias Haile (zhaile@shield-legal.com)
2025-04-10 17:00:22

I guess we are going to do it tomorrow morning

deleted-U06C7A8PVLJ
2025-04-10 17:21:01

🥹

deleted-U06C7A8PVLJ
2025-04-10 17:21:14

I feel like there is something missing and we both don't know what it is

deleted-U06C7A8PVLJ
2025-04-10 17:21:18

Sadly

deleted-U06C7A8PVLJ
2025-04-10 17:21:55

Because I understood what he was saying all up in the video but if there is anything else then I may not remember which is why we are trying to record it (our own version) so we can use in the future.

Zekarias Haile (zhaile@shield-legal.com)
2025-04-11 09:18:54

Good morning @deleted-U06C7A8PVLJ

Zekarias Haile (zhaile@shield-legal.com)
2025-04-11 09:18:59

Unfortunately yeah

Zekarias Haile (zhaile@shield-legal.com)
2025-04-11 09:19:49

I feel like know I understood it and started to make sense… but here we are haha

deleted-U06C7A8PVLJ
2025-04-11 09:21:58

Good morning @Zekarias Haile Ah it happens

Zekarias Haile (zhaile@shield-legal.com)
2025-04-11 09:26:23

Thanks again for your help man

deleted-U06C7A8PVLJ
2025-04-11 09:27:32

No problemo @Zekarias Haile

deleted-U06C7A8PVLJ
2025-04-11 15:52:48

Hi @Zekarias Haile I wanted to see if you have time where we can create our little SOP for what we did yesterday for record keeping for us for next month lol

Zekarias Haile (zhaile@shield-legal.com)
2025-04-11 15:57:52

@deleted-U06C7A8PVLJ I was doing some stuff that I wanted to finish.. Can we push it to Monday please? Im sorry for pushing agian

deleted-U06C7A8PVLJ
2025-04-11 15:58:12

No worries you are fine. Monday works too

Zekarias Haile (zhaile@shield-legal.com)
2025-04-11 15:58:38

Will see you Monday hopefully haha

deleted-U06C7A8PVLJ
2025-04-11 16:37:52

Sounds good see you monday haha

👀 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 14:14:27

Hey @deleted-U06C7A8PVLJ How are you doing?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 14:14:46

What time shall we meet today?

deleted-U06C7A8PVLJ
2025-04-14 14:24:19

Hey Zek I am doing well how are you

deleted-U06C7A8PVLJ
2025-04-14 14:24:41

I think any time after 1:30pm-ish should be fine with me. I do have a meeting at 1:00 pm which should be about 30-ish mins

Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 14:25:33

Doing well as well, thanks! Sounds good. Pls ping me when done with the meeting.

deleted-U06C7A8PVLJ
2025-04-14 14:26:13

Sounds like a plan 🙌

👍 Zekarias Haile
deleted-U06C7A8PVLJ
2025-04-14 15:11:39

Hey Zek looks like my meeting has been canceled so I am available if needed

Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 15:12:58

all right

Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 15:13:16

shall we meet at the conference room?

deleted-U06C7A8PVLJ
2025-04-14 15:14:01

If there is one available we can.

deleted-U06C7A8PVLJ
2025-04-14 15:14:37

We can record it from our desks too if needed

Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 15:17:28

Yeah let’s check CR#2

Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 15:17:34

Coming to you

deleted-U06C7A8PVLJ
2025-04-14 15:17:41

Sounds good

Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 15:39:47
Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 15:40:17

to get Column L & M

Zekarias Haile (zhaile@shield-legal.com)
2025-04-14 15:41:12

To get SL Sold lead Verticals

deleted-U06C7A8PVLJ
2025-04-14 15:56:11

EOM TIP Financial Dashboard Final Steps

Loom
🙏 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-17 13:00:03

Hey @deleted-U06C7A8PVLJ wondering if you have returned the 13 to 12 already? I see discrepancies on 4/14 .. wo

Ryan Vaspra (https://themedialaboratory.slack.com/team/UJF2W0EB1)
Zekarias Haile (zhaile@shield-legal.com)
2025-04-17 13:20:25

I see para 13 CP +2 and JA +1 TIP has 3 more

deleted-U06C7A8PVLJ
2025-04-17 13:20:34

Hey @Zekarias Haile Coming back from lunch. We need to change the paraquat cases from paraquat 12 to 13 ?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-17 13:21:51

no worries. Remember Ryan told us to change Paraquat 12 to 13 on April 15 as per Cam request?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-17 13:22:27

im talking about this

Ryan Vaspra (https://themedialaboratory.slack.com/team/UJF2W0EB1)
deleted-U06C7A8PVLJ
2025-04-17 13:22:41

Yes. He stated to do that as long as it was changed in Law Ruler first

deleted-U06C7A8PVLJ
2025-04-17 13:22:53

One of them wasn't so I didn't make any changes to it because of that

deleted-U06C7A8PVLJ
2025-04-17 13:23:18

Per Ryan's instructions. Do you know if all paraquat 12 in general

Zekarias Haile (zhaile@shield-legal.com)
2025-04-24 10:27:26

Gm @deleted-U06C7A8PVLJ when you posted the lead Id I think u missed two digit on the second one

Zekarias Haile (zhaile@shield-legal.com)
2025-04-24 10:27:46

Gm @deleted-U06C7A8PVLJ when you posted the lead Id I think u missed two digit on the second one

deleted-U06C7A8PVLJ
2025-04-24 10:27:46

Good morning @Zekarias Haile

deleted-U06C7A8PVLJ
2025-04-24 10:27:56

Nope that one is correct. I double checked it on law ruler too

deleted-U06C7A8PVLJ
2025-04-24 10:27:59

I thought the same thing haha

Zekarias Haile (zhaile@shield-legal.com)
2025-04-24 10:28:12

ohh really... okay

deleted-U06C7A8PVLJ
2025-04-24 10:28:13

It is 2021 old and got signed 2025

Zekarias Haile (zhaile@shield-legal.com)
2025-04-24 10:28:18

that funny tho

deleted-U06C7A8PVLJ
2025-04-24 10:28:30

Yup I was surprised too

Zekarias Haile (zhaile@shield-legal.com)
2025-04-24 10:28:36

ohh I see... make sense

Zekarias Haile (zhaile@shield-legal.com)
2025-04-24 10:28:55

Thanks for the clarification man

deleted-U06C7A8PVLJ
2025-04-24 10:29:53

No prob good catch too

👀 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:44:34
Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:44:58
Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:46:05

Good morning @deleted-U06C7A8PVLJ these are from 04/25... missing S1s when you get a chance pls let me know

deleted-U06C7A8PVLJ
2025-04-28 09:46:07

Good Moring Zek ! That is strange. Form my end it isn't showing any blank S1s

deleted-U06C7A8PVLJ
2025-04-28 09:46:12

From **

Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:46:29

it's not 4/27's

Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:46:41

it's for 4/25

deleted-U06C7A8PVLJ
2025-04-28 09:47:54

I ran query for march 1 to today

deleted-U06C7A8PVLJ
2025-04-28 09:47:59

And no b lank S1s

deleted-U06C7A8PVLJ
2025-04-28 09:48:48

I shall do a query for those dates to give you S1s?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:49:26

I see... probably try that specific date

Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:52:12

And also any idea why these dashes are not showing sign ins?

deleted-U06C7A8PVLJ
2025-04-28 09:52:34

I put the date from 04-25-2025 to current date and all have S1s

Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:53:02

Sounds good. Will cross check this.. Ty!

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-04-28 09:53:04

That is a good question. Something may be going on with Looker studio?

Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:53:17

right

deleted-U06C7A8PVLJ
2025-04-28 09:53:30

That or something brokey

Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:53:37

hmm

deleted-U06C7A8PVLJ
2025-04-28 09:54:03

Worth mentioning to Ryan to see what he says lol

deleted-U06C7A8PVLJ
2025-04-28 09:54:06

For the dashboard not working

Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:54:13

yeah

Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 09:54:18

im gonna do that

deleted-U06C7A8PVLJ
2025-04-28 09:55:14

Sounds like a plan. 🙌:skintone2:

🙏 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-28 16:05:54

657852, 660279

deleted-U06C7A8PVLJ
2025-04-28 16:09:04

Fixed

deleted-U06C7A8PVLJ
2025-04-28 16:09:54

I updated in LR and PGadmin in TIP's end to not have same leadspedia id #

🙏:skin_tone_4: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-29 13:22:00

These are few of the LR ids that are tied into one LP Id

:eyes_3d: deleted-U06C7A8PVLJ
🫡 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-04-30 15:53:27

Hey @Zekarias Haile I have a favor to ask you

Zekarias Haile (zhaile@shield-legal.com)
2025-04-30 15:54:01

Sure

deleted-U06C7A8PVLJ
2025-04-30 15:54:18

May you check Ahsan's desk to see if you see samsung buds (white ones). I may have left mine there

Zekarias Haile (zhaile@shield-legal.com)
2025-04-30 15:54:19

Im might ask few hundred bucks

deleted-U06C7A8PVLJ
2025-04-30 15:54:23

I texted him as well

Zekarias Haile (zhaile@shield-legal.com)
2025-04-30 15:54:35

Checking

Zekarias Haile (zhaile@shield-legal.com)
2025-04-30 15:54:44

Yes

Zekarias Haile (zhaile@shield-legal.com)
2025-04-30 15:54:51

It’s here

deleted-U06C7A8PVLJ
2025-04-30 15:54:58

I shall pop by then. Thank you @Zekarias Haile

Zekarias Haile (zhaile@shield-legal.com)
2025-04-30 15:55:06

Np

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:01:14

@deleted-U06C7A8PVLJ Can you check this pls? Cam is saying that this is not in LR and double check it not showing it either

deleted-U06C7A8PVLJ
2025-05-01 13:02:45

Yes I can check.

deleted-U06C7A8PVLJ
2025-05-01 13:03:06

I am on lunch I can have it ready afterwards unless it is urgent urgent ?

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:03:58

No worries. Let me know when u return from lunch

deleted-U06C7A8PVLJ
2025-05-01 13:09:29

Thank you 🙏

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:18:12

Im sorry to bother you on your lunch. But can I check it on publicfinanciallog table?

deleted-U06C7A8PVLJ
2025-05-01 13:18:35

I would think so

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:18:36

Cam is waiting on us

deleted-U06C7A8PVLJ
2025-05-01 13:18:50

Yeah should be public financial log

deleted-U06C7A8PVLJ
2025-05-01 13:18:54

_

deleted-U06C7A8PVLJ
2025-05-01 13:19:00

Between spaces

👍:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:21:10

is it public.? public.financial_log

deleted-U06C7A8PVLJ
2025-05-01 13:21:22

Yes

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:21:31

ok

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:21:54

yeah not pulling anything on that table

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:22:27

what time are u returning from lunch?

deleted-U06C7A8PVLJ
2025-05-01 13:22:44

11:30

✅ Zekarias Haile
deleted-U06C7A8PVLJ
2025-05-01 13:29:57

Okay I am available if needed

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:30:50

631908 found it on LR just want to let you know. FYI

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:31:19

Sorry about that again for taking your time

deleted-U06C7A8PVLJ
2025-05-01 13:32:32

That is weird. They both have different S1s

deleted-U06C7A8PVLJ
2025-05-01 13:32:41

I will update to the what in LR if that is the case?

deleted-U06C7A8PVLJ
2025-05-01 13:32:58

Wait sorry

deleted-U06C7A8PVLJ
2025-05-01 13:33:03

I sent wrong lead ID LOL

deleted-U06C7A8PVLJ
2025-05-01 13:33:35

Matches with PGadmin

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:33:38

No worries

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:33:47

are u on call center channel?

deleted-U06C7A8PVLJ
2025-05-01 13:33:55

Yes

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:34:11

on shiled call center?

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:35:10
Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:35:39

Let see what is the deal with this

deleted-U06C7A8PVLJ
2025-05-01 13:36:13

Copy. Let me know what you need help with if that being me changing the status in tip's database?

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:39:47

Will do. Ty

deleted-U06C7A8PVLJ
2025-05-01 13:57:12

May you pop by with your laptop. Cameron is asking for something that is urgent

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 13:57:30

sure

deleted-U06C7A8PVLJ
2025-05-01 13:57:40

thank you @Zekarias Haile

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 15:29:45

@deleted-U06C7A8PVLJ does your chair lean backward? i found one that looks like yours and wondering

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 15:29:57

random question

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 15:30:35

that you don't need to check LR or Tip database to answer it hahah

deleted-U06C7A8PVLJ
2025-05-01 15:30:56

It doesn't have to lean back or it can up to you how you set it up

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 15:31:37

i wanted but it's not

Zekarias Haile (zhaile@shield-legal.com)
2025-05-01 15:32:03

u will show me when u come in here

deleted-U06C7A8PVLJ
2025-05-05 10:27:14

-- GET the count of leads worked from LR Status Report to compare to SL Sold Leads -- SELECT fl.parent_case_type, COUNT(<a href="http://rs.lr">rs.lr</a>_lead_id) FROM financial_log fl JOIN raw_status_report rs ON <a href="http://fl.lr">fl.lr</a>_lead_id = <a href="http://rs.lr">rs.lr</a>_lead_id WHERE fl.signed_date BETWEEN '2025-03-01' AND '2025-03-31' AND lead_source LIKE '%Shield%' AND fl.current_status LIKE '%e-Sign%' _--billable leads only_ GROUP BY fl.parent_case_type

Zekarias Haile (zhaile@shield-legal.com)
2025-05-05 10:37:47

*Thread Reply:* This query is not providing me anything

🫠 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-05-05 10:38:53

*Thread Reply:* Checking

👍:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-05-05 10:39:37

*Thread Reply:* You need it for all of April right

Zekarias Haile (zhaile@shield-legal.com)
2025-05-05 10:40:05

*Thread Reply:* Yes

deleted-U06C7A8PVLJ
2025-05-05 10:40:42
deleted-U06C7A8PVLJ
2025-05-05 10:40:47

*Thread Reply:* I ran it and gave me these

Zekarias Haile (zhaile@shield-legal.com)
2025-05-05 10:41:12

*Thread Reply:* Nice!

:meow_attention: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-05-05 10:41:27

*Thread Reply:* can u also send me March's please

Zekarias Haile (zhaile@shield-legal.com)
2025-05-05 10:41:49

*Thread Reply:* I want to compare to what Ryan sent me for March last month

deleted-U06C7A8PVLJ
2025-05-05 10:42:33
Zekarias Haile (zhaile@shield-legal.com)
2025-05-05 10:43:34

*Thread Reply:* Gracias Amigo! 😊

deleted-U06C7A8PVLJ
2025-05-05 10:44:01

*Thread Reply:* De nada :facewithcowboy_hat:

deleted-U06C7A8PVLJ
2025-05-05 10:27:17

I would try this one

deleted-U06C7A8PVLJ
2025-05-05 10:27:45

https://www.loom.com/share/c6564f3e5a224aee88a9787fa87af85d Here would be the video for it too

Loom
Zekarias Haile (zhaile@shield-legal.com)
2025-05-05 10:28:38

Thanks! @deleted-U06C7A8PVLJ

:laptop_parrot: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-05-05 16:19:06

-- GET ROWS SELECT parentcasetype, sum(grossrevenue) FROM public.financiallog WHERE signeddate BETWEEN '2024-02-01' AND '2024-02-29' AND leadsource LIKE '%Shield Legal%' AND currentstatus LIKE '%Signed e-Sign%' GROUP BY parentcasetype ORDER BY parentcase_type ASC;

deleted-U06C7A8PVLJ
2025-05-15 08:52:05

Morning Zek. I shall post when S1s are complete

Zekarias Haile (zhaile@shield-legal.com)
2025-05-15 09:27:34

Gm, Edward, sure..

:laptop_parrot: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-05-19 09:54:47

Good morning Edward! When u get a chance can u pls check this S1 from 5/16

deleted-U06C7A8PVLJ
2025-05-19 09:56:03

Good morning @Zekarias Haile Sure do you need the lead for it? 722328

Zekarias Haile (zhaile@shield-legal.com)
2025-05-19 09:58:21

Thanks!

Zekarias Haile (zhaile@shield-legal.com)
2025-05-19 09:59:08

How many signed up do u see for 5/16 on Firefighting Foam- Douglas-ML?

deleted-U06C7A8PVLJ
2025-05-19 10:01:24

You're welcome. There is only one that is signed final for 5/16

🙏:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-05-19 10:03:02

Ty!

Zekarias Haile (zhaile@shield-legal.com)
2025-05-19 10:03:30

one more last question for morning haha

Zekarias Haile (zhaile@shield-legal.com)
2025-05-19 10:05:13

Can u check this S1 for Camp Lejuene? I assigned to CP. That is for 5/17

deleted-U06C7A8PVLJ
2025-05-19 10:22:23

Yes the lead ID for that one is 79447

🙏:skin_tone_3: Zekarias Haile
🙏:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-05-20 13:56:38

Hey @deleted-U06C7A8PVLJ did u see Ryan's post on shield - Analytics?

deleted-U06C7A8PVLJ
2025-05-20 14:28:05

Hey @Zekarias Haile Just reviewing this now haha

Zekarias Haile (zhaile@shield-legal.com)
2025-05-20 14:31:17

no worries

deleted-U06C7A8PVLJ
2025-05-20 14:31:41

Yeah we need Sobo's team to first update it in Law Ruler

deleted-U06C7A8PVLJ
2025-05-20 14:31:48

Then we can make those changes

Zekarias Haile (zhaile@shield-legal.com)
2025-05-20 14:32:02

I told Sobo to update it

Zekarias Haile (zhaile@shield-legal.com)
2025-05-20 14:32:13

and Im updating it on SL side

deleted-U06C7A8PVLJ
2025-05-20 14:32:56

Oh okay once he updates it then I shall update it from my end too. I shall put a "reminder" notification about this in slack just in case lol

Zekarias Haile (zhaile@shield-legal.com)
2025-05-20 14:33:18

sounds good haha

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-05-27 09:02:23

Good morning Zek. I shall post S1s soon once completed

Zekarias Haile (zhaile@shield-legal.com)
2025-05-27 09:07:39

Gm @deleted-U06C7A8PVLJ, okay.

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-05-28 09:04:41

Good morning Zek. I shall post when S1s are complete

Zekarias Haile (zhaile@shield-legal.com)
2025-05-28 09:30:54

Gm Edward, sure.

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-05-29 14:01:27

@deleted-U06C7A8PVLJ pls take a look this missing S1. not sure if this the one Ryan was mentioning earlier

deleted-U06C7A8PVLJ
2025-05-29 14:02:35

Yeah should be good to go now @Zekarias Haile

deleted-U06C7A8PVLJ
2025-05-29 14:02:39

I think it was that one

deleted-U06C7A8PVLJ
2025-05-29 14:02:46

May need to refresh page

Zekarias Haile (zhaile@shield-legal.com)
2025-05-29 14:02:47

and this too

deleted-U06C7A8PVLJ
2025-05-29 14:03:06

Sounds good. I am going through the S1s right now to fill in any blanks

🙏:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-05-29 16:00:32

@deleted-U06C7A8PVLJ friendly reminder if u haven't removed the declines yet. I see the Dash is off by 1

:eyes_3d: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-05-29 16:01:45

let me double check

👍:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-05-29 16:02:54

Do we know what case type it is? I double checked the one this morning and that one is signed & declined

Zekarias Haile (zhaile@shield-legal.com)
2025-05-29 16:04:16
Zekarias Haile (zhaile@shield-legal.com)
2025-05-29 16:04:56

it's Chow- DL- FL

deleted-U06C7A8PVLJ
2025-05-29 16:06:37

Weird since that one is already signed & declined

deleted-U06C7A8PVLJ
2025-05-29 16:07:07

May need to refresh page or might be a different lead?

Zekarias Haile (zhaile@shield-legal.com)
2025-05-29 16:20:45

I think I got it the issue is on 5/26.. Will fix it. Thanks Edward again!

deleted-U06C7A8PVLJ
2025-05-29 17:01:26

Thank you @Zekarias Haile

:yourewelcome: Zekarias Haile
deleted-U06C7A8PVLJ
2025-06-04 13:05:34

That makes sense

deleted-U06C7A8PVLJ
2025-06-04 13:05:38

I noticed we are getting a lot of those

deleted-U06C7A8PVLJ
2025-06-04 13:05:44

I shall run it right now

Zekarias Haile (zhaile@shield-legal.com)
2025-06-04 13:05:57

yup. Ty!

deleted-U06C7A8PVLJ
2025-06-04 13:06:37

Ty

Zekarias Haile (zhaile@shield-legal.com)
2025-06-04 14:25:50

are u gonna do something? it's already 180 ... im kinda confused

deleted-U06C7A8PVLJ
2025-06-04 14:26:04

Nope I think he is just adding that into my notes just in case

Zekarias Haile (zhaile@shield-legal.com)
2025-06-04 14:26:16

okay

deleted-U06C7A8PVLJ
2025-06-04 14:26:16

I was going to do something but I realize we are already at 180 so we good

Zekarias Haile (zhaile@shield-legal.com)
2025-06-04 14:26:26

sounds good

deleted-U06C7A8PVLJ
2025-06-06 09:53:30

Good morning Zek. I am running lambdas as we speak

Zekarias Haile (zhaile@shield-legal.com)
2025-06-06 09:54:50

Gm, Edward. Okay, thanks!

:cool_doge: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-06-06 09:55:55

so to be clear are u running the lambda every morning to make sure there are no missing leads or u used run it everyday

deleted-U06C7A8PVLJ
2025-06-06 09:56:26

Lambdas runs on its own every morning and I am running it again when I get here to see if we find any outliners

Zekarias Haile (zhaile@shield-legal.com)
2025-06-06 09:56:45

sounds good

:cool_doge: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-06-06 09:57:09

can we schedule it to run twice in the morning?

deleted-U06C7A8PVLJ
2025-06-06 09:57:19

But I think it only needs to be ran "a second time" because lately the first time it would fail due to those extra leads that has issues

deleted-U06C7A8PVLJ
2025-06-06 09:57:53

So until we fix that error I think even if we ran is 10x it would be the same as 1x or 0x since we have two leads with errors

deleted-U06C7A8PVLJ
2025-06-06 09:57:57

I will see if we get those errors again today

Zekarias Haile (zhaile@shield-legal.com)
2025-06-06 09:59:15

I see

Zekarias Haile (zhaile@shield-legal.com)
2025-06-06 09:59:26

Let me know pls

Zekarias Haile (zhaile@shield-legal.com)
2025-06-06 09:59:30

how that goes

deleted-U06C7A8PVLJ
2025-06-06 10:02:10

Yeah it error out again

deleted-U06C7A8PVLJ
2025-06-06 10:02:47

Due to same LR leads. Going to delete them run it and then add it again. However I wonder how to fix this in the future. I think there is something not matching with leadspedia

Zekarias Haile (zhaile@shield-legal.com)
2025-06-06 10:09:19

hmm yeah we need to fix that

Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 11:00:05

The it looks like lpcontractname is not changed to reflect the new changes? And for paraquat 1 I only see 4 but it think they are 6 for 2021

deleted-U06C7A8PVLJ
2025-06-10 11:00:43

Hmm I shall look into it

👀 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 13:21:09

Hey Edward what happened to this lead again pls refresh my memory 713984

👀 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-06-10 13:24:15

Hey Zek. I see what you are referring to

deleted-U06C7A8PVLJ
2025-06-10 13:24:20

Let me send you a screenshot of an email

deleted-U06C7A8PVLJ
2025-06-10 13:24:47
deleted-U06C7A8PVLJ
2025-06-10 13:24:57

Looks like Nancy from Flatirons has access to a dashboard

deleted-U06C7A8PVLJ
2025-06-10 13:25:22

I think this is where we talk to Mal and ask her if the costs changed between these timeframe?

deleted-U06C7A8PVLJ
2025-06-10 13:25:28

I think that is what Nick M was referring to

deleted-U06C7A8PVLJ
2025-06-10 13:27:46

What is weird is this case was signed on 06/04/2025 and not 4/18

deleted-U06C7A8PVLJ
2025-06-10 13:27:55

So I wonder why it is like that as well

Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 13:31:29

hmm shall we talk to Mal now then or

Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 13:32:35

ohh you already slacked Mal

deleted-U06C7A8PVLJ
2025-06-10 13:33:24

Yeah I slacked her to be on safe side

deleted-U06C7A8PVLJ
2025-06-10 13:33:29

She said it is a Ryan / Cam question

deleted-U06C7A8PVLJ
2025-06-10 13:33:37

If ryan doesn't answer then I may need to slack cameron

Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 13:34:42

I see

deleted-U06C7A8PVLJ
2025-06-10 13:36:04

Yeah I never heard of us billing for a lead but not for a signed contract lol

👆:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 14:16:42

@deleted-U06C7A8PVLJ how urgent is Nancy thing... I was finishing the EOM... reconciling the last step... wondering if u want me to look into it now if it's urgent

deleted-U06C7A8PVLJ
2025-06-10 14:20:56

I would say it should be looked into and have an answer by today (in my opinion) because she and dave are the ones who pays dicello who then pays us lol

deleted-U06C7A8PVLJ
2025-06-10 14:21:28

So they are important but as long as we can provide an answer today I think we should be fine since I told her we are looking into this

Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 14:23:19

sounds good..

deleted-U06C7A8PVLJ
2025-06-10 14:24:14

Sorry about that Zek

deleted-U06C7A8PVLJ
2025-06-10 14:24:29

I ask Ryan but maybe we need to ask Nick M to ask Cameron maybe?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 14:25:10

Ask Nick what?

deleted-U06C7A8PVLJ
2025-06-10 14:25:56

About that lead (nancy email)

Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 14:31:24

ohh give me sec to check on my side and we can ask him

Zekarias Haile (zhaile@shield-legal.com)
2025-06-10 14:31:34

ohh give me sec to check on my side and we can ask him

deleted-U06C7A8PVLJ
2025-06-10 14:34:49

Sounds good

deleted-U06C7A8PVLJ
2025-06-10 16:52:40

Hi @Zekarias Haile would you know the name of the dashboard we were looking at earlier ago

deleted-U06C7A8PVLJ
2025-06-10 17:02:59

Thank you ! It says I need to request access for it lol

deleted-U06C7A8PVLJ
2025-06-10 17:04:31

I posted this in the chat my question I am about to ask you but I looks like Nancy / Dave from flatirons may want us to include those 130 + 8 demayo clients in the dashboard for them to view

deleted-U06C7A8PVLJ
2025-06-10 17:04:40

As a friendly heads up. I am waiting to see what Ryan says

Zekarias Haile (zhaile@shield-legal.com)
2025-06-11 11:20:03

I thought I replied haha

Zekarias Haile (zhaile@shield-legal.com)
2025-06-11 11:20:48

I will start working on those 130 demo cases today

deleted-U06C7A8PVLJ
2025-06-11 11:21:27

Thank you ! Are you referring to adding them in the dashboard?

deleted-U06C7A8PVLJ
2025-06-11 11:22:03

This is the full list if needed

🙏:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-06-11 11:22:20

138 (130 we have intakes and secondaries and 8 we created the intake and we have secondaries for those).

Zekarias Haile (zhaile@shield-legal.com)
2025-06-11 11:22:37

Im refrering to changing the names to Demayo... but once i finished it will start showup on the dash I would asssume

deleted-U06C7A8PVLJ
2025-06-11 11:22:56

Ohhh I see what you are referring too

deleted-U06C7A8PVLJ
2025-06-11 11:23:03

Yes 130 would need their names changed to DeMayo

Zekarias Haile (zhaile@shield-legal.com)
2025-06-11 11:23:18

sounds good

deleted-U06C7A8PVLJ
2025-06-11 11:23:28

thank you ☝️:skintone2:

:yourewelcome: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-11 12:49:28

@deleted-U06C7A8PVLJ I see the old names on TIP dash.. this on Dec 1st 2021

deleted-U06C7A8PVLJ
2025-06-11 12:50:14

I see. Are you able to see the lead? To confirm if they both the same lead

Zekarias Haile (zhaile@shield-legal.com)
2025-06-11 12:52:00
deleted-U06C7A8PVLJ
2025-06-11 13:06:31

I shall check ty Zek 🙂

👍:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-06-11 13:48:08

That one doesn't look like it is part of the DeMayo client list

Zekarias Haile (zhaile@shield-legal.com)
2025-06-11 13:52:12

i see... but as I told u yesterday.. I see only 4 Demayos on TIP dash for 2021 but in the sheet it shows 6... wanted to reconcile now since I dont want to go back again

deleted-U06C7A8PVLJ
2025-06-11 13:52:58

Gotcha. So as long as the 130 Demayo are on TIP's end you would be fine?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-11 13:58:43

for all 130 to be fully changed I have to change all the cases on the sheet right? but I do that TIP and SL dash will be off... for example for 2021 TIP has 4 DeMayo Paraquat 1 cases... but if did change all the sheet Demayo Paraqaut 1 SL would have 2 more extra

deleted-U06C7A8PVLJ
2025-06-11 14:00:00

Sorry Zek I am not understanding

deleted-U06C7A8PVLJ
2025-06-11 14:00:21

The other day I took the 130 and updated them to DeMayo in TIP's end so from there it should also reflect the same thing in SL when you adjust it?

deleted-U06C7A8PVLJ
2025-06-11 14:00:24

That is my understanding

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 12:02:11

Gm, Ed heads up Nick has meeting rn... so we are not meeting now

deleted-U06C7A8PVLJ
2025-06-13 12:03:30

Good morning Zek. Thank you for the friendly heads up. I let Nick M know I will be doing WFH today

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 12:04:10

ohh got it. I thought u are here...

deleted-U06C7A8PVLJ
2025-06-13 12:23:20

Oh no I have been doing a lot of flatirons reconciliation so I've been sleeping a bit later to just put in a few more hours in to get it done

deleted-U06C7A8PVLJ
2025-06-13 12:23:34

On Monday I will be at the office since I would of reset my sleep schedule back to normal lol

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 12:26:37

ohh I see.. dont work too hard haha... enjoy your weekend man

deleted-U06C7A8PVLJ
2025-06-13 12:34:33

I appreciate it Zek 🙏:skintone2: How is Ryan's stuff going do you know if we finished for the month of May yet haha

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 12:36:28

Np!

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 12:37:18

😅 that is has been my question for the whole week and I havent gotten an answer yet haha

deleted-U06C7A8PVLJ
2025-06-13 12:39:03

Yeah I think it is because of Mark and cam with the pricing. I think they wanna lower and lower tip's costs

deleted-U06C7A8PVLJ
2025-06-13 12:39:16

So maybe it will be done on 07/01 joking 😆

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 13:36:40

yeah...

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 13:37:03

then we will finish both May and June at the same time haha

deleted-U06C7A8PVLJ
2025-06-13 13:56:28

True 🤣

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 14:49:07

@deleted-U06C7A8PVLJ Do u guys updated the invoice by month for June for those mentioned cases?

deleted-U06C7A8PVLJ
2025-06-13 14:53:51

Yeah the ones James mentioned yes

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 14:57:09

Okay. Ty

deleted-U06C7A8PVLJ
2025-06-13 15:12:55

Yeah he just told me he wants it updated to 196 instead

deleted-U06C7A8PVLJ
2025-06-13 15:12:58

Now I gotta rerun it lol

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 15:41:42

Yeah saw that

deleted-U06C7A8PVLJ
2025-06-13 15:49:33

Yeah but we good now 🙂

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 15:51:27

So PFAS, NV, Soup are the one got updated?

deleted-U06C7A8PVLJ
2025-06-13 15:52:03

Yeah they should have. For only this month #s

Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 15:52:17

okay

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 13:00:02

141126 this is missing S1. when you get a chance please take a look

Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 13:35:55

*Thread Reply:* 124600 this one is also missing S1

deleted-U06C7A8PVLJ
2025-06-16 15:05:26

I updated those you mentioned above. As for my screenshot I am assuming you or someone is changing the customer on these?

deleted-U06C7A8PVLJ
2025-06-16 15:05:32

To make them as a DeMayo customer?

deleted-U06C7A8PVLJ
2025-06-16 15:05:35

If so I like it lol

deleted-U06C7A8PVLJ
2025-06-16 15:22:13

These include the extra 35 Demayo. They are for hair relaxer only for the extra 35

🙏:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-06-16 15:25:33

Do you also put the dollar amount such as 20k in paraquat?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 15:28:20

*Thread Reply:* No. It will be like this 20000

deleted-U06C7A8PVLJ
2025-06-16 15:38:27

*Thread Reply:* 20k = 20000 yes

deleted-U06C7A8PVLJ
2025-06-16 15:25:41

If so you may also need to know how much it is for Hair Relaxer DeMayo right

Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 15:29:18

*Thread Reply:* Nick told me that it is 5072.46

deleted-U06C7A8PVLJ
2025-06-16 15:29:33

*Thread Reply:* Perfect ! 🙂

deleted-U06C7A8PVLJ
2025-06-16 15:30:02

*Thread Reply:* 762142 762144 762145 These are three leads from the 35 I gave you that we did not do their intakes at all (the bottom ones) so those I will have to calculate differently 🥹 lol

deleted-U06C7A8PVLJ
2025-06-16 15:30:30

*Thread Reply:* So essentially 32 sign ups from SL while those three they did on their own (the intakes)

✅ Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 15:31:18

*Thread Reply:* Good to know.. not sure how we handle it as we only have intakes... but we will talk about once u calculated it haha

Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 15:31:32

*Thread Reply:* Ty!

deleted-U06C7A8PVLJ
2025-06-16 15:36:56

*Thread Reply:* Yeah I would just proceed as normal and let me worry about the ones we didn't complete the intakes but they did. That is something I will have to hard code

Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 15:37:36

*Thread Reply:* makes sense

deleted-U06C7A8PVLJ
2025-06-16 15:38:04

*Thread Reply:* Yes so as long as the ones you can find have customer in it as "Flatirons" I can find them easy for my report for Flatirons

deleted-U06C7A8PVLJ
2025-06-16 15:38:17

*Thread Reply:* Which looks like is what you are doing so TY for that

Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 15:38:26

*Thread Reply:* Np man

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-06-16 15:30:56

I updated the case type names in PGadmin so we should be good to go 🙂

🙏:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 16:42:47

@deleted-U06C7A8PVLJ Good afternoon. All marked in green are missing S1s. Please take a look when u get a chance

deleted-U06C7A8PVLJ
2025-06-17 16:43:29

Copy. May you send me the .xlsx with just the green and I'll get that done right now

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 16:44:45

I can send u the LR Id if u need that

deleted-U06C7A8PVLJ
2025-06-17 16:45:48

Basically if you send me the lead IDs like 12345, 239923, etc I can copy into PGadmin and find it

deleted-U06C7A8PVLJ
2025-06-17 16:45:53

Or .xlsx works too

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 16:46:03

yeah got u

deleted-U06C7A8PVLJ
2025-06-17 16:46:15

Thank you 🙏:skintone2:

:yourewelcome: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 16:48:17

125134 126695 126699 126823 127827 128654 128718 132276

deleted-U06C7A8PVLJ
2025-06-17 16:51:43

Thank you Zek

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 16:52:20

No probelma Amigo!

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 16:55:15

another one 132276

deleted-U06C7A8PVLJ
2025-06-17 17:00:12

Thank you

deleted-U06C7A8PVLJ
2025-06-17 17:00:17

132276 you sent twice

deleted-U06C7A8PVLJ
2025-06-17 17:00:22

I updated all above the S1s

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 17:00:37

Ohh my bad

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 17:00:42

Thanks!

deleted-U06C7A8PVLJ
2025-06-17 17:00:55

No problemo 🙂

deleted-U06C7A8PVLJ
2025-06-17 17:01:02

:facewithcowboy_hat:

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 17:01:10

Haha

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 17:01:33

So I was misspelling problemo earlier hahah

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 17:01:46

Now I know hah

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 17:02:10

I said problema

deleted-U06C7A8PVLJ
2025-06-17 17:02:54

Ah that might still be correct. For males it is o but females I think it is an A

deleted-U06C7A8PVLJ
2025-06-17 17:03:03

Depending on who you are talking too

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 17:03:21

Ohh I see

deleted-U06C7A8PVLJ
2025-06-17 17:05:45

Yeah but you know what formally you should say with an A I looked it up. But typically when I hear or try to speak spanish, I learned for males it is usually o but problema is correct since that one is unisex apparently lol

deleted-U06C7A8PVLJ
2025-06-17 17:05:51

So you had it right.

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 17:09:46

Okay Im glad im correct hahah

Zekarias Haile (zhaile@shield-legal.com)
2025-06-17 17:09:54

Thanks for checking on that haha

deleted-U06C7A8PVLJ
2025-06-17 17:20:06

OHhh yeahhh :cool_doge:

Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 13:11:37

@deleted-U06C7A8PVLJ from the 35 I see these leads are Firefighting 234332 234600

deleted-U06C7A8PVLJ
2025-06-18 13:12:06

Those leads are case numbers I believe you meant to grab law ruler id

Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 13:13:28

Ohh the Lead Id column is not LR id?

deleted-U06C7A8PVLJ
2025-06-18 13:14:03

Hmm send me a screenshot?

deleted-U06C7A8PVLJ
2025-06-18 13:14:08

Sorry not at my desk

Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 13:14:51
Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 13:14:56

No worries

deleted-U06C7A8PVLJ
2025-06-18 13:15:29

Makes sense. Should just be from column A

Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 13:15:41
Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 13:16:00

yeah I used Column A

deleted-U06C7A8PVLJ
2025-06-18 13:16:39

Ah that screenshot we should use column B

✅ Zekarias Haile
deleted-U06C7A8PVLJ
2025-06-18 13:16:51

I pasted those wrong

deleted-U06C7A8PVLJ
2025-06-18 13:16:57

My apologies

Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 13:17:05

No worries

:gratitude_thank_you: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 14:06:03

247440 762142 Hair Relaxer - DL - Flatirons - Shield Legal 250950 762144 Hair Relaxer - DL - Flatirons - Shield Legal 250037 762145 Hair Relaxer - DL - Flatirons - Shield Legal

Tried both column A and B and it looks like none of them are LR ids

deleted-U06C7A8PVLJ
2025-06-18 14:06:33

@Zekarias Haile Those looks like it is the "blank" intake ones I was telling you about

deleted-U06C7A8PVLJ
2025-06-18 14:06:49

If it is a lead that is starting with 76... I would say that is the ones we created as fillers

Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 14:07:09

ahh make sense

deleted-U06C7A8PVLJ
2025-06-18 14:07:20

So I think we don't need any action from your end for those yet until we locate the sign date and if they say yes these are SL

deleted-U06C7A8PVLJ
2025-06-18 14:07:42

So should be a total of 10 that doesn't need your action on

deleted-U06C7A8PVLJ
2025-06-18 14:07:56
Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 14:08:16

sounds good. Thanks for clarifying that... Will finish up the remaining when I come back from lunch

deleted-U06C7A8PVLJ
2025-06-18 14:08:18

163 DeMayos yes but 10 no (until we get an answer)

✅ Zekarias Haile
deleted-U06C7A8PVLJ
2025-06-18 14:08:24

Thank you @Zekarias Haile

🙏:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 16:19:04

@deleted-U06C7A8PVLJ finally, I'm done with DeMayo!

deleted-U06C7A8PVLJ
2025-06-18 16:22:30

Woot woot yas :meow_attention:

deleted-U06C7A8PVLJ
2025-06-18 16:22:33

Great job @Zekarias Haile

🙌:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-06-19 11:06:55

Hey Zek. I am not feeling too well. A bit nauseous from what I ate yesterday. I told Nick and I am WFH for today. Going to work on S1s and Declines now though

Zekarias Haile (zhaile@shield-legal.com)
2025-06-19 11:09:59

Hey Edward, I'm sorry to hear that. No worries. feel better soon

deleted-U06C7A8PVLJ
2025-06-19 11:11:04

Thank you Zek 🙏. I still have to do some dashboard stuff for doug 😅 But thankfully my weekly report is done and we don't have Ryan EOM stuff to do since we are done

Zekarias Haile (zhaile@shield-legal.com)
2025-06-19 11:13:12

That is good at least. Don't work to hard then haha

🙏:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-06-19 11:15:35

You right

deleted-U06C7A8PVLJ
2025-06-20 10:26:19

Good morning Zek

deleted-U06C7A8PVLJ
2025-06-20 10:26:35

I wanted to share an email with you that flatirons is asking of us (to include these in the flatirons dashboard)

deleted-U06C7A8PVLJ
2025-06-20 10:27:17

Currently the dashboard is giving them this error but for DeMayo only

deleted-U06C7A8PVLJ
2025-06-20 10:28:02

Also by Monday they would want to see all 173 DeMayo clients on there however 7 paraquats are missing and 22 hair relaxer clients are missing (both DeMayo).

deleted-U06C7A8PVLJ
2025-06-20 10:28:29

I also don't have access to that dashboard so wanted to see if you can give me access to it as well plz 🙏:skintone2:

Zekarias Haile (zhaile@shield-legal.com)
2025-06-20 11:02:03

*Thread Reply:* Granted u access.

deleted-U06C7A8PVLJ
2025-06-20 11:03:43

*Thread Reply:* Thank you @Zekarias Haile

:yourewelcome: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-20 10:29:18

Good morning Edward, Sure will take a look at it.

Zekarias Haile (zhaile@shield-legal.com)
2025-06-20 10:29:29

okay, I will give you access

deleted-U06C7A8PVLJ
2025-06-20 10:31:06

Thank you Zek 🙏:skintone2:

:yourewelcome: Zekarias Haile
deleted-U06C7A8PVLJ
2025-06-20 13:55:12

List of all demayo clients and their sign dates and other fields

deleted-U06C7A8PVLJ
2025-06-20 14:24:25

97883 97926 97924 97497 97910

deleted-U06C7A8PVLJ
2025-06-20 14:51:07

128799 128718 128654 100058

deleted-U06C7A8PVLJ
2025-06-20 14:54:08

131600 132192 132276

deleted-U06C7A8PVLJ
2025-06-20 14:56:12

98510

Zekarias Haile (zhaile@shield-legal.com)
2025-06-20 15:07:34
deleted-U06C7A8PVLJ
2025-06-20 15:29:00

Sadly I tried it but still not working. I am thinking it but also be due to other fields or maybe how the customer is named

Zekarias Haile (zhaile@shield-legal.com)
2025-06-20 15:34:30

Hmm.. probably we have to check the filter (control) itself…

deleted-U06C7A8PVLJ
2025-06-20 15:36:50

Oh okay we shall check that whenever you get back from lunch

✅ Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-20 15:49:33

Im back. Pls come

deleted-U06C7A8PVLJ
2025-06-20 15:49:59

Oh okay be there in 1-2 mins grabbing my stuff

Zekarias Haile (zhaile@shield-legal.com)
2025-06-20 15:50:07

Got it

deleted-U06C7A8PVLJ
2025-06-20 15:56:29

246422 246421

deleted-U06C7A8PVLJ
2025-06-20 15:57:21

135329 135355

deleted-U06C7A8PVLJ
2025-06-20 16:01:17

112553 137152 140460 140483

deleted-U06C7A8PVLJ
2025-06-20 16:03:24

142644 142563

deleted-U06C7A8PVLJ
2025-06-20 16:28:05

SELECT ** FROM public.mediarawv2 WHERE rev_date >= '2020-01-01' AND customer = 'Dicello/Crump/DeMayo Flatirons (TIP)'

deleted-U06C7A8PVLJ
2025-06-20 16:33:05

UPDATE pub.cmediarawV2 SET customer = '' WHERE idx_id IN ( )

deleted-U06C7A8PVLJ
2025-06-20 16:35:56

SELECT ** FROM public.mediarawv2 WHERE idx_id IN (

)

deleted-U06C7A8PVLJ
2025-06-20 16:58:21

Dicello/Crump/DeMayo Flatirons (BLX)

deleted-U06C7A8PVLJ
2025-06-20 18:09:37

Yeah before we add those clients in let's see what Cameron says

Zekarias Haile (zhaile@shield-legal.com)
2025-06-20 18:32:41

Sure thing

deleted-U06C7A8PVLJ
2025-06-20 19:05:43

Thank you 🙏

:yourewelcome: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-23 11:27:26

Good morning @deleted-U06C7A8PVLJ when u got a chance can u please check this missing S1s on 6/20

deleted-U06C7A8PVLJ
2025-06-23 11:35:52

Good morning @Zekarias Haile Checking

deleted-U06C7A8PVLJ
2025-06-23 11:38:05

Hmm all is showing filled out to me:

deleted-U06C7A8PVLJ
2025-06-23 11:38:48

I shall check gaming 2

Zekarias Haile (zhaile@shield-legal.com)
2025-06-23 11:38:53

Ohh okay, very good

Zekarias Haile (zhaile@shield-legal.com)
2025-06-23 11:38:59

please do

Zekarias Haile (zhaile@shield-legal.com)
2025-06-23 11:39:05

Ty!

deleted-U06C7A8PVLJ
2025-06-23 11:41:27

Okay I filled out three blank gaming 2's so maybe that should fix it

Zekarias Haile (zhaile@shield-legal.com)
2025-06-23 11:42:43

Can I have the dates please

deleted-U06C7A8PVLJ
2025-06-23 11:46:41

I believe it was these three:

🙏:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-23 11:47:18

Thanks!

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-06-24 10:43:45

Good morning Zek. I am working on the S1s now

deleted-U06C7A8PVLJ
2025-06-24 10:44:00

Also I wanted to see if you know what to do for those 28 DeMayo cases

deleted-U06C7A8PVLJ
2025-06-24 10:44:06

Or if you need me to swing by and help

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 10:44:10

Good morning Edward, okay

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 10:45:19

No I can do it since Cam said we can use as SL leads

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 10:45:56

So I don’t see any difference to the one we did before right? If we are going to treat them as SL

deleted-U06C7A8PVLJ
2025-06-24 10:46:54

Yeah I think we are going to treat them the same as regular SL leads

deleted-U06C7A8PVLJ
2025-06-24 10:47:09

So regular prices and for media buyer he said we can use him

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 10:47:25

yup

deleted-U06C7A8PVLJ
2025-06-24 10:47:27

For customer I think we can put BLX on the 18 and the other 10 regular customers

deleted-U06C7A8PVLJ
2025-06-24 10:47:44

Nancy emailed me so if we can get this done today it would make her happy lol

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 10:48:55

ohh I was thinking to avoid BLX at all ,,, Since we are treating them as SL

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 10:49:11

yeah, for sure we will

deleted-U06C7A8PVLJ
2025-06-24 10:51:56

Ohhh I think you are right

deleted-U06C7A8PVLJ
2025-06-24 10:51:59

Nvm on what I said for Blx

✅ Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 11:02:37

are you going to change them to SL in TIP database as well just to make it uniform

deleted-U06C7A8PVLJ
2025-06-24 11:03:23

That is a good question lol

deleted-U06C7A8PVLJ
2025-06-24 11:03:58

Let me ask Nick M about that since it still has to say BCL since I think that is the BLX ones

deleted-U06C7A8PVLJ
2025-06-24 11:04:13

Might just be switched to BCL - SL and not BLX

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 11:04:50

Yeah that’s what I think.. but let’s hear form Nick

deleted-U06C7A8PVLJ
2025-06-24 11:05:26

Yeah since if that is the case I can then change it and then make a note of those in the profiles so that if someone reads it I will put supervisor + cameron approval lol

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 11:06:18

hhaha... yeah that was my thought too

:meow_attention: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 14:30:57

@deleted-U06C7A8PVLJ Im done with the 18 BLX’s

deleted-U06C7A8PVLJ
2025-06-24 14:31:11

Woot woot :meow_attention: Great job @Zekarias Haile

:thank_you: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 14:31:22

But not sure what im gonna do with the 10 tho I forgot haha

deleted-U06C7A8PVLJ
2025-06-24 14:31:59

Yeah we will do them normally. I think it was 7 paraquat 12 and 3 hair relaxer flatirons so we would just add normal customer names for those and media buyer is CR

deleted-U06C7A8PVLJ
2025-06-24 14:32:19

Case type name was paraquat 12 and hair relaxer DL flatirons

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 14:32:33

Ohh okay.. so it’s going to be the same

deleted-U06C7A8PVLJ
2025-06-24 14:32:41

Yeah

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 14:32:52

Got it. We will do them after lunch

deleted-U06C7A8PVLJ
2025-06-24 14:33:01

Sounds good. Thank you once again :cool_doge:

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 14:33:06

Np!

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 15:57:00

@deleted-U06C7A8PVLJ The 10 leads are not added to the TIP database yet right?

deleted-U06C7A8PVLJ
2025-06-24 16:22:39

Sorry for late reply. let me check

deleted-U06C7A8PVLJ
2025-06-24 16:22:47

Can you provide me the ID of one of them

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 16:30:04

No worries

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 16:30:20

771447 769975

deleted-U06C7A8PVLJ
2025-06-24 16:31:22

Thank you ! checking

✅ Zekarias Haile
deleted-U06C7A8PVLJ
2025-06-24 16:35:45

I think the ones you gave me are different case types

deleted-U06C7A8PVLJ
2025-06-24 16:35:49

I got MI and Instant soup

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 16:36:23

Oh my bad

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 16:36:54

753708 753709

deleted-U06C7A8PVLJ
2025-06-24 16:38:36

Checking

deleted-U06C7A8PVLJ
2025-06-24 16:39:03

Ah they are not on there because it has "3P signed e-sign". So I would need to create those in TIP first so that you can see them on SL right

deleted-U06C7A8PVLJ
2025-06-24 16:41:23

If that is the case. I will work on adding those today and tomorrow you can add those 10

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 16:44:05

I already added them on SL side.

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 16:50:46

*Thread Reply:* I used the e-sign date on the excel

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 16:46:46

Did you ask Nick something? he told me to talk you... I would assume it's about this stuff but want to make sure

deleted-U06C7A8PVLJ
2025-06-24 21:10:22

Hey Zek. I just asked him if you were around still at the office that is all. I wanted to ask you more about this dashboard but we can talk more about it tomorrow 🙂

✅ Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-26 12:45:01

Good morning @deleted-U06C7A8PVLJ I hope you're doing well. Wanted to check with you

deleted-U06C7A8PVLJ
2025-06-26 13:59:06

@Zekarias Haile Good Afternoon Zek. Thanks for checking. I had to start a bit later today since I was working on the dashboard stuff for Cameron for a good hot minute so I shall be posting the S1s etc soon . sorry about that

Zekarias Haile (zhaile@shield-legal.com)
2025-06-26 14:07:36

No worries. Yeah Nick just told me that.

deleted-U06C7A8PVLJ
2025-06-26 14:11:29

Thanks for checking. Going to fix something real quick for Cameron and I'll be hopping on that shortly

Zekarias Haile (zhaile@shield-legal.com)
2025-06-26 14:12:40

Np! Sure.

deleted-U06C7A8PVLJ
2025-06-30 13:35:36

378207 386165 389439 396968 413759 423707 437599 443071 456917 457743 460373 469065 471728 475642 481802 485245 485666 487685 487754

deleted-U06C7A8PVLJ
2025-06-30 13:44:08

Hi Zek. I could be wrong but I think the customer might be different (an extra space is my guess) since these two should be 2 - 40,000 instead of 1 - 20,000 x 2

deleted-U06C7A8PVLJ
2025-06-30 13:45:11

I think the same for this one too

Zekarias Haile (zhaile@shield-legal.com)
2025-06-30 13:46:04

Are u seeing it in SL database?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-30 13:46:29

might be they have different signed date?

deleted-U06C7A8PVLJ
2025-06-30 13:47:26

I ran this as a query in Shield Legal Bi in bigquery but if they have different sign dates maybe that is why

deleted-U06C7A8PVLJ
2025-06-30 13:47:40

Just posting just in case but maybe that could be the reason which makes sense

Zekarias Haile (zhaile@shield-legal.com)
2025-06-30 13:48:41

oh okay.. I thought u were checking on progress... but will take a look later.

deleted-U06C7A8PVLJ
2025-06-30 13:50:40

Okay

deleted-U06C7A8PVLJ
2025-06-30 13:50:49

Sorry autocorrect on my phone

deleted-U06C7A8PVLJ
2025-06-30 13:50:59

I meant to say oh okay

Zekarias Haile (zhaile@shield-legal.com)
2025-06-30 13:51:28

No worries.

:cat_roomba_exceptionally_fast: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-07-02 12:35:54

```-- TIP Daily Routine -- FIND MISSING S1s in TIP DB SELECT lrleadid,casetype,firstname,lastname,currentassignee --SELECT lrleadid,typeofcase,firstname,lastname,currentassignee,casedescription

-- FIND & DELETE TEST NAMED LEADS SELECT ** FROM public.financiallog WHERE (LOWER(firstname) LIKE '%test%' OR LOWER(lastname) LIKE '%test%'OR LOWER(casedescription) LIKE '%test%' OR LOWER(currentassignee) LIKE '%test%') AND lrleadid <> '64829' AND LOWER(casedescription) NOT LIKE '%testicular%' AND currentstatus NOT LIKE '%DECLINED%' ORDER BY typeofcase,lastname ASC;```

🙏:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 10:43:50

Good morning @deleted-U06C7A8PVLJ I hope you're having a great morning! I think you are WFH today right?

deleted-U06C7A8PVLJ
2025-07-03 10:44:06

Good morning Zek & Yes

deleted-U06C7A8PVLJ
2025-07-03 10:44:15

Going thru the S1s and Declines

🙏:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 10:45:01

ok, I saw the test leads but wanted to confirm with u ( wanted u to do it haha

deleted-U06C7A8PVLJ
2025-07-03 10:45:18

Ahhh yes there were a few this time

Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 10:45:40

yup... I will be waiting thanks

deleted-U06C7A8PVLJ
2025-07-03 10:45:51

I removed them 😬

Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 10:46:01

Great

Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 10:46:05

Gracias

deleted-U06C7A8PVLJ
2025-07-03 10:46:13

De nada :facewithcowboy_hat:

Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 11:24:19

S1 is missing for this. pls take a look for me when u get a chance 413759

deleted-U06C7A8PVLJ
2025-07-03 11:39:42

Interesting. Okay going to reply back to Abe's Jira post and I will get that fixed shortly

Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 11:40:06

No worries. Take ur time

:meow_attention: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-07-03 11:47:03

Okay jira comment finished and S1 updated. It is strange how those get removed

Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 11:47:58

Thanks

:yourewelcome: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 12:14:28

you added the S1 on lpleadid column just minor issue

deleted-U06C7A8PVLJ
2025-07-03 12:15:48

Good catch ty. I adjusted it. I thought I was looking at s1 haha

Zekarias Haile (zhaile@shield-legal.com)
2025-07-03 12:16:02

No worries, thanks

Zekarias Haile (zhaile@shield-legal.com)
2025-07-07 12:40:40

Good morning @deleted-U06C7A8PVLJ Can you please check when you a get a chance. It's for 7/5

deleted-U06C7A8PVLJ
2025-07-07 12:44:36

Good morning @Zekarias Haile. Are they blank?

Zekarias Haile (zhaile@shield-legal.com)
2025-07-07 12:45:20

yes, the OSOL 1 lead is blank

deleted-U06C7A8PVLJ
2025-07-07 12:47:20

Hmm I am not seeing blanks for those

Zekarias Haile (zhaile@shield-legal.com)
2025-07-07 12:59:20

ohh that's weird it was blank.. but now it's all good. Thanks bro

deleted-U06C7A8PVLJ
2025-07-07 13:10:06

Oh I see. it is magic 🪄:maleelf::skintone_2:

😆 Zekarias Haile
deleted-U06C7A8PVLJ
2025-07-08 11:27:41

Hey @Zekarias Haile For ryan's EOM process, I updated the pricing for call center costs and agent commissions

deleted-U06C7A8PVLJ
2025-07-08 11:27:49

I am working on updating the talk time almost done with that

Zekarias Haile (zhaile@shield-legal.com)
2025-07-08 11:39:13

Halo, sounds good. Thanks

Zekarias Haile (zhaile@shield-legal.com)
2025-07-08 11:39:56

And let me know when u work on AWKO dash... I can help and also want to learn Looker E

deleted-U06C7A8PVLJ
2025-07-08 11:42:13

That works ! Cameron sent me a different slack to work on a separate dashboard for him haha

deleted-U06C7A8PVLJ
2025-07-08 11:42:27

But I will get the questions for Andy and I will send to him

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

haha im sorry man

Zekarias Haile (zhaile@shield-legal.com)
2025-07-08 11:42:39

okay

deleted-U06C7A8PVLJ
2025-07-08 11:42:53

Yeah but the one he is asking me to do is a lot more simple thankfully

Zekarias Haile (zhaile@shield-legal.com)
2025-07-08 11:43:06

Great

Zekarias Haile (zhaile@shield-legal.com)
2025-07-08 12:54:45

NEC Dicello/Flatirons. It's off by 3 when I checked on SL database I show 1251 like the dash

deleted-U06C7A8PVLJ
2025-07-08 13:00:36

TIP Operations Dashboard v1.2

accounts.google.com
deleted-U06C7A8PVLJ
2025-07-08 18:03:51

Okay I have talk time updated. However I am asking Ryan a question if he wants me to multiple it by 2 for e-sign and secondaries since for case reviews I do not have it as multiplied by 2.

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

Sounds good, thanks bro!

deleted-U06C7A8PVLJ
2025-07-09 11:40:58

Hey Zek. I am working from home today. However wanted to let you know I finished the talk time

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 11:41:38

Good Morning Edward, okay, thanks man!

deleted-U06C7A8PVLJ
2025-07-09 11:43:32

Thank you ! Also can you do me a favor? I left some stacks of paper at my desk. Can you take a picture of them and share with me if that is okay? Alex took notes of some things she wants on the dashboard and I forgot to pick them up 😅

deleted-U06C7A8PVLJ
2025-07-09 11:43:48

It is the VGA questions lol

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 11:44:12

Np! Absolutely, will do it now

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 11:45:22

You need all pages right?

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 11:45:47

Or the one marked with pen?

deleted-U06C7A8PVLJ
2025-07-09 11:46:52

Yes to ones marked as pen

deleted-U06C7A8PVLJ
2025-07-09 11:47:00

If you give me the #s that would work too

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 11:47:47

Only the # pages?

deleted-U06C7A8PVLJ
2025-07-09 11:50:10

I think so. Like #10 she mark blue, #19, etc or pics work either or

deleted-U06C7A8PVLJ
2025-07-09 11:50:16

The stack consist of two case types

deleted-U06C7A8PVLJ
2025-07-09 11:54:12

Thank you Zek !!

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 11:54:30
Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 11:54:44

No problem

deleted-U06C7A8PVLJ
2025-07-09 11:55:32

Thank you. They pretty much (both stacks) share the same or similar questions? lol

deleted-U06C7A8PVLJ
2025-07-09 11:55:58

I didn't get the chance to read them when Alex sent me but looks like it

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 11:56:34

I havent read myself just sent it to you hhaha

deleted-U06C7A8PVLJ
2025-07-09 11:58:47

Oh okay haha. Other than talk time and call center / agent costs we are good?

deleted-U06C7A8PVLJ
2025-07-09 11:59:04

The only thing I need to do left would be VSS reconciliation

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 11:59:27

okay sounds good

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:00:10

778522 can u double check when this lead got signed in? you know more about LR and wanted to check it

deleted-U06C7A8PVLJ
2025-07-09 12:01:34

Thank you. Will check

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:02:04

Np! I see it in the slack channel but not on the dash

deleted-U06C7A8PVLJ
2025-07-09 12:04:12

That is weird since It is in a final status in law ruler and in tip's database? lol

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:06:17

I know... not even in signed and declined status right?

deleted-U06C7A8PVLJ
2025-07-09 12:08:42

Correct it is signed e-sign final in tip and in law ruler

deleted-U06C7A8PVLJ
2025-07-09 12:08:54

So it should be showing on the dashboard

deleted-U06C7A8PVLJ
2025-07-09 12:09:06

I can try to put it signed & decline and re-add to final ? lol

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:09:51

May be let's give it a minute if it's able to make it?

deleted-U06C7A8PVLJ
2025-07-09 12:10:40

Okay done. May need to refresh dashboard

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:13:27

Thanks man

deleted-U06C7A8PVLJ
2025-07-09 12:13:47

Did it work?

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:15:26

Not yet

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:15:41

Tried refresh it

deleted-U06C7A8PVLJ
2025-07-09 12:17:42
Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:21:53

hmm I don't know why not seeing this

deleted-U06C7A8PVLJ
2025-07-09 12:25:17

That looks like a different lead ID # compared to the one you sent above?

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:27:43

yes, it's. Im saying this is the only one Im showing

deleted-U06C7A8PVLJ
2025-07-09 12:28:03

Ohhh I see

deleted-U06C7A8PVLJ
2025-07-09 12:28:30

You sorting by dates?

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:28:37

yes

deleted-U06C7A8PVLJ
2025-07-09 12:28:50

Probably the e-sign date may be different is my guess

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:29:03

ohh it's under July 5

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:29:37

I just saw that on your screenshot. But why that happened?

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:29:51

Was expecting under July 8

deleted-U06C7A8PVLJ
2025-07-09 12:30:59

Got signed on 5th

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:32:37

I see

Zekarias Haile (zhaile@shield-legal.com)
2025-07-09 12:32:48

Thanks man

deleted-U06C7A8PVLJ
2025-07-09 12:42:42

You're welcome

deleted-U06C7A8PVLJ
2025-07-10 11:04:07

Hey Zek. I am omw to the office. As a friendly heads up

Zekarias Haile (zhaile@shield-legal.com)
2025-07-10 11:05:27

Good morning Edward, okay

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-07-10 11:22:11

Also Rose asked when we think everything would be closed by

Zekarias Haile (zhaile@shield-legal.com)
2025-07-10 11:24:16

Yeah saw that. I think I should be able to finish today. But Ryan scheduled for yesterday and not sure if we are able to complete without Ryan reviewed it

Zekarias Haile (zhaile@shield-legal.com)
2025-07-11 12:30:41

we have EOM meeting now

deleted-U06C7A8PVLJ
2025-07-11 12:31:12

Okay going to hop on now. Thank you @Zekarias Haile

🙏:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-07-17 12:41:17

Good morning @deleted-U06C7A8PVLJ how are you doing? How is the dashboard task going?

Zekarias Haile (zhaile@shield-legal.com)
2025-07-17 12:41:44

can you please check this missing S1

deleted-U06C7A8PVLJ
2025-07-17 12:42:44

Good morning @Zekarias Haile I am doing alright and yourself

deleted-U06C7A8PVLJ
2025-07-17 12:42:52

The dashboard is a work in progress

deleted-U06C7A8PVLJ
2025-07-17 12:42:55

Yes I can check

Zekarias Haile (zhaile@shield-legal.com)
2025-07-17 12:43:29

Doing well man, nice nice!

Zekarias Haile (zhaile@shield-legal.com)
2025-07-17 12:43:37

gracias

deleted-U06C7A8PVLJ
2025-07-17 12:45:40

Updated 🙂 & De nada :facewithcowboy_hat:

🙏:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-07-17 12:45:57

My package was supposed to come yesterday but got delayed so I am hoping it will come today (reason for WFH)

deleted-U06C7A8PVLJ
2025-07-17 12:46:04

Requires signature and is very heavy lol

Zekarias Haile (zhaile@shield-legal.com)
2025-07-17 12:48:19

I see, is that the printing machine?

deleted-U06C7A8PVLJ
2025-07-17 12:48:38

Yes it is one of them. About 150lb

Zekarias Haile (zhaile@shield-legal.com)
2025-07-17 12:49:36

ohh it's heavy for sure. Nice man, happy for you!

deleted-U06C7A8PVLJ
2025-07-17 12:52:32

Thank you I appreciate it. Hopefully there isn't any fires over there

Zekarias Haile (zhaile@shield-legal.com)
2025-07-17 12:53:11

The well known Dicello of course haha

🥹 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-07-21 13:34:59

Hi Zek. Do you know by any chance the contract to this new case type: "San Bernardino Juv Hall - DL - DL - Shield Legal"

Zekarias Haile (zhaile@shield-legal.com)
2025-07-21 15:09:40

*Thread Reply:* @deleted-U06C7A8PVLJ I dont see this contract on Leadspedia. I remember it has only one lead

deleted-U06C7A8PVLJ
2025-07-21 15:17:50

*Thread Reply:* Oh okay. yeah for now the S1 is going to be blank for this one unless you or Ryan have a specific S1 you want me to associate it to I can update it

Zekarias Haile (zhaile@shield-legal.com)
2025-07-21 15:22:06

*Thread Reply:* I see ... It would be great if you can ask Ryan

deleted-U06C7A8PVLJ
2025-07-21 15:22:31

*Thread Reply:* Okay sounds good

👍:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-07-21 13:35:22

Since we have some re-triggers for these so trying to find the appropriate S1 for this one

deleted-U06C7A8PVLJ
2025-07-21 13:35:29

796446

Zekarias Haile (zhaile@shield-legal.com)
2025-07-21 14:14:15

Good morning @deleted-U06C7A8PVLJ I will check it. Sorry about the late reply

deleted-U06C7A8PVLJ
2025-07-21 14:18:49

No worries take your time 😬

deleted-U06C7A8PVLJ
2025-07-21 15:06:43

I went ahead and move this into S&D status

Olivia Roman (https://tortintakepros.slack.com/team/U07SBM5MB32)
👍:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 11:15:07

Good morning @deleted-U06C7A8PVLJ are you on the way to office? I want you to reran the lambda as we are missing more signups. Cam is waiting on that

deleted-U06C7A8PVLJ
2025-07-23 11:15:40

Good morning Zek. Yes I am be on my way shortly

👍:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-07-23 11:42:03

I am not sure if Ryan gave you AWS access but if he did we can click on that link and click test and it will run. Once it shows "green" it means it was successful if it is red that means it is a coding error lol

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:01:19

```5b-b716a2046199 LP Lead ID: S3OHXSM5 [INFO] 2025-07-23T16:59:38.856Z 1e762c2d-8b95-4eed-895b-b716a2046199 Added finlog entry: FinancialLog(lrleadid=118304, signeddate=datetime.date(2022, 11, 22)) [INFO] 2025-07-23T16:59:38.919Z 1e762c2d-8b95-4eed-895b-b716a2046199 #4778/6309: [INFO] 20250723T16:59:38.919Z 1e762c2d-8b95-4eed-895b-b716a2046199 LR Lead ID: 118298 [INFO] 2025-07-23T16:59:38.919Z 1e762c2d-8b95-4eed-895b-b716a2046199 Idle Time: 2025-07-22 17:56:20 [INFO] 2025-07-23T16:59:38.919Z 1e762c2d-8b95-4eed-895b-b716a2046199 Case Desc.: MWIL5OCP [INFO] 2025-07-23T16:59:39.687Z 1e762c2d-8b95-4eed-895b-b716a2046199 LP Lead ID: MWIL5OCP [INFO] 2025-07-23T16:59:40.000Z 1e762c2d-8b95-4eed-895b-b716a2046199 Added finlog entry: FinancialLog(lrleadid=118298, signeddate=datetime.date(2022, 11, 22)) [INFO] 2025-07-23T16:59:40.063Z 1e762c2d-8b95-4eed-895b-b716a2046199 #4779/6309: [INFO] 20250723T16:59:40.063Z 1e762c2d-8b95-4eed-895b-b716a2046199 LR Lead ID: 118254 [INFO] 2025-07-23T16:59:40.063Z 1e762c2d-8b95-4eed-895b-b716a2046199 Idle Time: 2025-07-22 17:56:20 [INFO] 2025-07-23T16:59:40.064Z 1e762c2d-8b95-4eed-895b-b716a2046199 Case Desc.: QVEQ7PT3 [INFO] 2025-07-23T16:59:40.829Z 1e762c2d-8b95-4eed-895b-b716a2046199 LP Lead ID: QVEQ7PT3 [INFO] 2025-07-23T16:59:41.142Z 1e762c2d-8b95-4eed-895b-b716a2046199 Added finlog entry: FinancialLog(lrleadid=118254, signeddate=datetime.date(2022, 12, 2)) [INFO] 2025-07-23T16:59:41.205Z 1e762c2d-8b95-4eed-895b-b716a2046199 #4780/6309: [INFO] 202507_23T16:59:41.205Z 1e762c2d-8b95-4eed-895b-b716a2046199 LR Lead ID: 118259 [INFO] 2025-07-23T16:59:41.205Z 1e762c2d-8b95-4eed-895b-b716a2046199 Idle Time: 2025-07-22 17:56:20 [INFO] 2025-07-23T16:59:41.205Z 1e762c2d-8b95-4eed-895b-b716a2046199 Case Desc.: CA Juvenile Hall Abuse - ACTS/VAN - Shield Legal

YTZLYALR [INFO] 2025-07-23T16:59:41.707Z 1e762c2d-8b95-4eed-895b-b716a2046199 LP Lead ID: [INFO] 2025-07-23T16:59:42.020Z 1e762c2d-8b95-4eed-895b-b716a2046199 Added finlog entry: FinancialLog(lrleadid=118259, signeddate=datetime.date(2022, 11, 22)) [INFO] 2025-07-23T16:59:42.083Z 1e762c2d-8b95-4eed-895b-b716a2046199 #4781/6309: [INFO] 20250723T16:59:42.083Z 1e762c2d-8b95-4eed-895b-b716a2046199 LR Lead ID: 118189 [INFO] 2025-07-23T16:59:42.084Z 1e762c2d-8b95-4eed-895b-b716a2046199 Idle Time: 2025-07-22 17:56:20 [INFO] 2025-07-23T16:59:42.084Z 1e762c2d-8b95-4eed-895b-b716a2046199 Case Desc.: 2CL7NR2X [INFO] 2025-07-23T16:59:42.869Z 1e762c2d-8b95-4eed-895b-b716a2046199 LP Lead ID: 2CL7NR2X [INFO] 2025-07-23T16:59:43.181Z 1e762c2d-8b95-4eed-895b-b716a2046199 Added finlog entry: FinancialLog(lrleadid=118189, signeddate=datetime.date(2022, 11, 22)) [INFO] 2025-07-23T16:59:43.244Z 1e762c2d-8b95-4eed-895b-b716a2046199 #4782/6309: [INFO] 20250723T16:59:43.245Z 1e762c2d-8b95-4eed-895b-b716a2046199 LR Lead ID: 118183 [INFO] 2025-07-23T16:59:43.245Z 1e762c2d-8b95-4eed-895b-b716a2046199 Idle Time: 2025-07-22 17:56:20 [INFO] 2025-07-23T16:59:43.245Z 1e762c2d-8b95-4eed-895b-b716a2046199 Case Desc.: IE4QHYNB [INFO] 2025-07-23T16:59:43.995Z 1e762c2d-8b95-4eed-895b-b716a2046199 LP Lead ID: IE4QHYNB [INFO] 2025-07-23T16:59:44.306Z 1e762c2d-8b95-4eed-895b-b716a2046199 Added finlog entry: FinancialLog(lrleadid=118183, signeddate=datetime.date(2022, 11, 22)) [INFO] 2025-07-23T16:59:44.370Z 1e762c2d-8b95-4eed-895b-b716a2046199 #4783/6309: [INFO] 202507_23T16:59:44.370Z 1e762c2d-8b95-4eed-895b-b716a2046199 LR Lead ID: 118174 [INFO] 2025-07-23T16:59:44.370Z 1e762c2d-8b95-4eed-895b-b716a2046199 Idle Time: 2025-07-22 17:56:20 [INFO] 2025-07-23T16:59:44.370Z 1e762c2d-8b95-4eed-895b-b716a2046199 Case Desc.: AJDPZLVA 2025-07-23T16:59:44.400Z 1e762c2d-8b95-4eed-895b-b716a2046199 Task timed out after 512.11 seconds

END RequestId: 1e762c2d-8b95-4eed-895b-b716a2046199 REPORT RequestId: 1e762c2d-8b95-4eed-895b-b716a2046199 Duration: 512111.02 ms Billed Duration: 512000 ms Memory Size: 512 MB Max Memory Used: 190 MB XRAY TraceId: 1-68811300-195f01a1298f666d39257c5e SegmentId: 3956220d1fa1b793 Sampled: true ```

deleted-U06C7A8PVLJ
2025-07-23 12:08:28

Sorry pgadmin is acting up on me. Can you check your settings for the TIP database and send me a screenshot of it

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:09:20

Sure

deleted-U06C7A8PVLJ
2025-07-23 12:13:26

Thank you

deleted-U06C7A8PVLJ
2025-07-23 12:17:09

Okay I got my pgadmin to work I am going to debug that code

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:18:08

great

deleted-U06C7A8PVLJ
2025-07-23 12:26:30

These are the steps just in case you need them. I am taking the law ruler lead IDs within that error and going to export the full table, delete those lead rows, run lambdas code then import the full table back

🙏:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-07-23 12:26:54

I ran the table (Select **) and it is still running.

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:27:12

Thank you!

deleted-U06C7A8PVLJ
2025-07-23 12:27:29

Waiting for this to finish so I can download the .csv. Then I am going to delete those rows and run lambdas which should fix the error for now. But I am not sure how Ryan fixed it the last time. Might is a quick fix lol

deleted-U06C7A8PVLJ
2025-07-23 12:27:32

Mine **

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:28:50

quick is great haha

deleted-U06C7A8PVLJ
2025-07-23 12:30:27

Waiting for this to download

👍:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-07-23 12:35:50

Yeah it is still downloading as we speak

deleted-U06C7A8PVLJ
2025-07-23 12:35:56

Not sure when it will finish

deleted-U06C7A8PVLJ
2025-07-23 12:36:22

SELECT ** FROM rawstatusreport

If you run this from TIP's end see if you can download the entire .csv

deleted-U06C7A8PVLJ
2025-07-23 12:36:30

Maybe it could be my laptop

deleted-U06C7A8PVLJ
2025-07-23 12:36:46
deleted-U06C7A8PVLJ
2025-07-23 12:40:09

Okay I downloaded the issue rows only for timing purposes and then I delete them in the table. Can you run lambdas to see if you still get the error ? @Zekarias Haile

deleted-U06C7A8PVLJ
2025-07-23 12:40:32

We need to manually add these back into the table when successful

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:41:20

okay

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:41:27

Let me run it

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:50:41

{ "errorMessage": "2025-07-23T17:50:12.463Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Task timed out after 512.07 seconds" }

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:50:49

it failed again

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:51:24

```.384Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Added finlog entry: FinancialLog(lrleadid=116612, signeddate=datetime.date(2022, 11, 20)) [INFO] 2025-07-23T17:50:05.451Z 99ae1748-233a-43f2-a301-d3ea868a65c7 #4751/6153: [INFO] 20250723T17:50:05.451Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LR Lead ID: 116603 [INFO] 2025-07-23T17:50:05.451Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Idle Time: 2025-07-22 17:56:25 [INFO] 2025-07-23T17:50:05.451Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Case Desc.: 20MHNKIP [INFO] 2025-07-23T17:50:06.324Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LP Lead ID: 20MHNKIP [INFO] 2025-07-23T17:50:06.654Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Added finlog entry: FinancialLog(lrleadid=116603, signeddate=datetime.date(2022, 11, 21)) [INFO] 2025-07-23T17:50:06.721Z 99ae1748-233a-43f2-a301-d3ea868a65c7 #4752/6153: [INFO] 20250723T17:50:06.721Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LR Lead ID: 116564 [INFO] 2025-07-23T17:50:06.722Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Idle Time: 2025-07-22 17:56:25 [INFO] 2025-07-23T17:50:06.722Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Case Desc.: YQ5BTFRZ [INFO] 2025-07-23T17:50:07.563Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LP Lead ID: YQ5BTFRZ [INFO] 2025-07-23T17:50:07.894Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Added finlog entry: FinancialLog(lrleadid=116564, signeddate=datetime.date(2022, 11, 20)) [INFO] 2025-07-23T17:50:07.961Z 99ae1748-233a-43f2-a301-d3ea868a65c7 #4753/6153: [INFO] 20250723T17:50:07.961Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LR Lead ID: 116563 [INFO] 2025-07-23T17:50:07.961Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Idle Time: 2025-07-22 17:56:25 [INFO] 2025-07-23T17:50:07.961Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Case Desc.: O4MBN2Z6 [INFO] 2025-07-23T17:50:08.816Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LP Lead ID: O4MBN2Z6 [INFO] 2025-07-23T17:50:09.146Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Added finlog entry: FinancialLog(lrleadid=116563, signeddate=datetime.date(2022, 11, 21)) [INFO] 2025-07-23T17:50:09.213Z 99ae1748-233a-43f2-a301-d3ea868a65c7 #4754/6153: [INFO] 20250723T17:50:09.213Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LR Lead ID: 116725 [INFO] 2025-07-23T17:50:09.213Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Idle Time: 2025-07-22 17:56:25 [INFO] 2025-07-23T17:50:09.214Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Case Desc.: None [INFO] 2025-07-23T17:50:09.744Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LP Lead ID: [INFO] 2025-07-23T17:50:10.075Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Added finlog entry: FinancialLog(lrleadid=116725, signeddate=datetime.date(2022, 11, 20)) [INFO] 2025-07-23T17:50:10.142Z 99ae1748-233a-43f2-a301-d3ea868a65c7 #4755/6153: [INFO] 20250723T17:50:10.142Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LR Lead ID: 116531 [INFO] 2025-07-23T17:50:10.142Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Idle Time: 2025-07-22 17:56:25 [INFO] 2025-07-23T17:50:10.142Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Case Desc.: GUOEZIPA [INFO] 2025-07-23T17:50:10.937Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LP Lead ID: GUOEZIPA [INFO] 2025-07-23T17:50:11.268Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Added finlog entry: FinancialLog(lrleadid=116531, signeddate=datetime.date(2022, 11, 20)) [INFO] 2025-07-23T17:50:11.334Z 99ae1748-233a-43f2-a301-d3ea868a65c7 #4756/6153: [INFO] 20250723T17:50:11.335Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LR Lead ID: 116535 [INFO] 2025-07-23T17:50:11.335Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Idle Time: 2025-07-22 17:56:25 [INFO] 2025-07-23T17:50:11.335Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Case Desc.: QMT51FAB [INFO] 2025-07-23T17:50:12.146Z 99ae1748-233a-43f2-a301-d3ea868a65c7 LP Lead ID: QMT51FAB 2025-07-23T17:50:12.463Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Task timed out after 512.07 seconds

END RequestId: 99ae1748-233a-43f2-a301-d3ea868a65c7 REPORT RequestId: 99ae1748-233a-43f2-a301-d3ea868a65c7 Duration: 512067.50 ms Billed Duration: 512000 ms Memory Size: 512 MB Max Memory Used: 231 MB Init Duration: 2215.10 ms
XRAY TraceId: 1-68811ecf-6880d8df539c36e3506179d9 SegmentId: 3074cdf3026402a4 Sampled: true ```

deleted-U06C7A8PVLJ
2025-07-23 12:51:57

If that is the case we may need Ryan's assistance on this since I am not sure what could be the issue with this

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:52:57

would you mind asking since you are more familiar with it?

deleted-U06C7A8PVLJ
2025-07-23 12:55:57

I would just send a screenshot of the error your are getting and send it to Ryan since that is what I would say haha

deleted-U06C7A8PVLJ
2025-07-23 12:56:08

Only because I have my hands tied for a dashboard cameron needs asap too

Zekarias Haile (zhaile@shield-legal.com)
2025-07-23 12:56:31

i see will do

✅ deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-07-24 11:45:31

@Zekarias Haile I shall be heading my way to the office friendly heads up

Zekarias Haile (zhaile@shield-legal.com)
2025-07-24 11:46:50

Good morning @deleted-U06C7A8PVLJ alright

Zekarias Haile (zhaile@shield-legal.com)
2025-07-24 15:43:03

@deleted-U06C7A8PVLJ Since I will be WFH next week, I would appreciate if you could do the s1s in the morning as you used to it. I know you’re busy with Flatirons stuff

deleted-U06C7A8PVLJ
2025-07-24 15:44:58

Sounds good @Zekarias Haile. I will do my best to get those do asap in the morning

deleted-U06C7A8PVLJ
2025-07-24 15:45:04

done **

Zekarias Haile (zhaile@shield-legal.com)
2025-07-24 15:45:32

Thank you!

deleted-U06C7A8PVLJ
2025-07-24 15:46:01

I can also ask Ryan if possible if I can show you how to do those just in case since my sleep schedule is off due to working longer hours at the flatirons stuff and I don't want to delay your stuff so showing you how can be a good back up if needed

deleted-U06C7A8PVLJ
2025-07-24 15:46:31

not sure if that is the stuff Nick M was stating he wants me to transfer to you since they want me to focus majority of the flatirons stuff

Zekarias Haile (zhaile@shield-legal.com)
2025-07-24 15:47:11

Yeah, that is something we need to talk in details.

Zekarias Haile (zhaile@shield-legal.com)
2025-07-24 15:47:44

When I come back the following week we can discuss I guess

deleted-U06C7A8PVLJ
2025-07-24 15:48:08

Yeah that makes sense. The S1s are not hard though I got it down pretty well

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

okay, how long does it takes you to finish the s1s and slack alerts

deleted-U06C7A8PVLJ
2025-07-24 15:51:19

I think it can be done 15-30 minutes

deleted-U06C7A8PVLJ
2025-07-24 15:51:33

I have been seeing about 5-10 missing S1s a day

deleted-U06C7A8PVLJ
2025-07-24 15:51:58

Then I update the signed & declines and go into slack for those S1s and tag media buyers like this: @johnsmith DQ

deleted-U06C7A8PVLJ
2025-07-24 15:52:09

And that's it. So total can be done 15-30 minutes for most days

Zekarias Haile (zhaile@shield-legal.com)
2025-07-24 15:52:13

I see

deleted-U06C7A8PVLJ
2025-07-24 15:53:41

Yeah not too hard and it has gotten better since when we had those wood pellets it was bad lol

deleted-U06C7A8PVLJ
2025-07-24 15:53:47

(coding error from aws or something)

Zekarias Haile (zhaile@shield-legal.com)
2025-07-24 15:54:40

I know right haha

:meow_party: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-07-29 19:22:45

Hey @deleted-U06C7A8PVLJ How are you doing? I was chatting with Ryan and we were wondering if you can run the lambda this weekend? as Ryan will be out and I will be doing the morning numbers

deleted-U06C7A8PVLJ
2025-07-29 20:10:27

Hey @Zekarias Haile It is going well ! Thank for asking. Just so I know if it is possible from my end around what time does it need to be ran?

Zekarias Haile (zhaile@shield-legal.com)
2025-07-29 20:16:15

You’re welcome! I think around 7-7:30am should work fine.

deleted-U06C7A8PVLJ
2025-07-29 20:48:43

Hmm. I think I can but for 7-7:30am that might be a bit too early for me since I have to pick up my GF around 12:30am (she gets off work around that time) so I don't wanna risk awaking up late lol. I can set up a few alarms if needed but 9-10am I can for sure. If no one can I can do it if needed but just want to be transparent since weekends I wake up a bit later due to that + extra rest lol

deleted-U06C7A8PVLJ
2025-07-29 20:49:35

If you need me to show you how I can as well but if you are on PTO I understand and I can run it. Or if it can be ran 1 or 2 am I can do that too lol

deleted-U06C7A8PVLJ
2025-07-29 20:49:46

If you need me to show you how I can as well but if you are on PTO I understand and I can run it. Or if it can be ran 1 or 2 am I can do that too lol

Zekarias Haile (zhaile@shield-legal.com)
2025-07-29 21:03:08

I totally understand that and Im sorry to put you in this situation.. I would love to learn how to but I think first I need to talk Ryan if he is okay me running the TIP lambda( and planning to mention that Monday)…

Zekarias Haile (zhaile@shield-legal.com)
2025-07-29 21:05:31

I think Sunday 9am would be fine.. and for Saturday will ask Ryan if it’s okay you running it around 9am

Zekarias Haile (zhaile@shield-legal.com)
2025-07-29 21:06:26

But I wanted to say thank you so much for your help and sorry about to bother you after hours

deleted-U06C7A8PVLJ
2025-07-29 21:10:11

Ah you are fine. I don't mind helping and I understand being hesitant to do TIP stuff when being part of SL and wanting to get Ryan's approval on that first. Okay that works with me and I can try to do 7:30 am but I know for sure those two times would work (9am ish)

Zekarias Haile (zhaile@shield-legal.com)
2025-07-29 21:38:39

Understood. I will confirm with Ryan and will let you know. Thanks

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Zekarias Haile (zhaile@shield-legal.com)
2025-08-01 19:57:44

Hey @deleted-U06C7A8PVLJ how are you doing? I confirmed with Ryan that it’s okay if you run it @9am tomorrow and Sunday. Thanks for your help again.

Zekarias Haile (zhaile@shield-legal.com)
2025-08-02 11:16:50

Good morning @deleted-U06C7A8PVLJ I don’t think you need to run the lambda today. The numbers looks correct. Thanks tho

deleted-U06C7A8PVLJ
2025-08-02 12:18:12

Good morning Zek 🌞 Glad to hear 🙏

🙏:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-08-03 12:03:14

Good morning @deleted-U06C7A8PVLJ we are also good on numbers today so no need to run it. Fyi. Thanks

Zekarias Haile (zhaile@shield-legal.com)
2025-08-03 12:03:28

Good morning @deleted-U06C7A8PVLJ we are also good on numbers today so no need to run it. Fyi. Thanks

Zekarias Haile (zhaile@shield-legal.com)
2025-08-07 13:43:24

94744

Zekarias Haile (zhaile@shield-legal.com)
2025-08-13 10:47:31
deleted-U06C7A8PVLJ
2025-08-13 15:21:54
deleted-U06C7A8PVLJ
2025-08-14 11:54:10

631908 & PL-FacebookMB-JACMP-003la Let's update the date to 11/14/2024

Zekarias Haile (zhaile@shield-legal.com)
2025-08-14 12:30:13

*Thread Reply:* This one

deleted-U06C7A8PVLJ
2025-08-14 12:42:22

*Thread Reply:* Oh right let me double check sorry she sent me two screenshots of two different things I think that is why

Zekarias Haile (zhaile@shield-legal.com)
2025-08-14 12:42:52

*Thread Reply:* Got it, no worries

Zekarias Haile (zhaile@shield-legal.com)
2025-08-14 12:13:27

This has been updated

deleted-U06C7A8PVLJ
2025-08-14 12:13:44

Thank you Zek ! I shall review real quick

👍:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-08-14 12:14:53

Thank you looks updated to me. Let me see if there are any others

Zekarias Haile (zhaile@shield-legal.com)
2025-08-14 12:15:37

No probelema @deleted-U06C7A8PVLJ

🤣 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-08-14 12:16:42

If they are a signed & decline status they will need to be removed from SL and they won't appear in the flatirons dashboard

deleted-U06C7A8PVLJ
2025-08-14 12:16:44

Sounds about right?

deleted-U06C7A8PVLJ
2025-08-14 12:16:52

SL database

Zekarias Haile (zhaile@shield-legal.com)
2025-08-14 12:19:31

that is correct

deleted-U06C7A8PVLJ
2025-08-14 12:21:45

PL-FacebookMB-MLIllinoisJuveFORM6 709104 signed & decline

deleted-U06C7A8PVLJ
2025-08-14 12:21:56

That makes sense if that is the case I think this one should have it's status changed

Zekarias Haile (zhaile@shield-legal.com)
2025-08-14 12:24:43

That has been already removed since it was in the today's S&D

deleted-U06C7A8PVLJ
2025-08-14 12:25:15

Oh okay perfect thank you for that update. i think i may have one left

Zekarias Haile (zhaile@shield-legal.com)
2025-08-14 12:26:04

Np, sounds good

deleted-U06C7A8PVLJ
2025-08-14 12:28:06

631908 "LA County Foster Care Abuse - ACTS - DL/Flatirons - Shield Legal" PL-FacebookMB-JACMP-003la current date: 05/04/2025 but should be replaced with 11/14/2024

Zekarias Haile (zhaile@shield-legal.com)
2025-08-14 12:29:32

I think this is the same lead id that we did first today

deleted-U06C7A8PVLJ
2025-08-14 12:37:43

Hmm let me check it just might be lol

Zekarias Haile (zhaile@shield-legal.com)
2025-08-15 12:23:45

@deleted-U06C7A8PVLJ when do you think you will be able to update the July cc cost? Rose is asking me

deleted-U06C7A8PVLJ
2025-08-15 12:24:31

Hi @Zekarias Haile I shall work on that shortly I think I can get that done in 30 minutes since Mal sent me the case types but they are not the correct names so I gotta do some digging but shouldn't be that long

Zekarias Haile (zhaile@shield-legal.com)
2025-08-15 12:25:00

ohh I see. Thanks man

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-08-15 12:25:16

Yeah I am going to take a look right now to see

Zekarias Haile (zhaile@shield-legal.com)
2025-08-18 16:14:42

Hey @deleted-U06C7A8PVLJ when do you think you will post the declines? and can you please check these missing s1s for me? 665903 665977

deleted-U06C7A8PVLJ
2025-08-25 15:21:08

637745 682733 These two were moved to signed & declined

👍:skin_tone_3: Zekarias Haile