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 Ryan is in a meeting with me and asked you to hop into it. I shall send you the link
Hi @deleted-U06C7A8PVLJ we are on the call with Ryan. Are you able to join?
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
NP! got it.
@deleted-U06C7A8PVLJ I think there is a Wood Pellet exposure injury Missing S1s, can you please check?
Gm @deleted-U06C7A8PVLJ there's missing S1s for wood pellet Injury T2. Can you please check?
I see ! I shall run a query for all t2, t1 and t3 to see if I see any missing. One sec Zek
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
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?
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.
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
Great! Thanks for the detail info. I would love to to take a look so please share the course with me. Thanks!
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
No worries @deleted-U06C7A8PVLJ. I'm about to leave in 30min, so i will finish up tomorrow. Good job 💪
Thanks for understanding ! Sounds good. Have a great rest of your shift and thank you !!
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
Understood. Thanks for the heads up @deleted-U06C7A8PVLJ. You got this bro 💪
Im sorry I muted you it has background noise 😊
No worries I think my mic was acting weird when that happen
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
But I simply just took notes and screenshots, etc from the Tip's side
ohh I see. I thought you said he is recording. But not a problem. I will listen the fireflies note.
no worries. it's not your fault at all
hi @deleted-U06C7A8PVLJ I'm showing these LR Lead ID doesn't have S1
693550 695334 695676 695675 69007 For T2 694004 For T1
*Thread Reply:* I added the S1s for these all except 69007 since looks like it is missing a digit?
@deleted-U06C7A8PVLJ just a friendly reminder, Ryan said you need to post in both table and slack channels. Whenever you done. TY
Sorry ! You mean to post this type of table in logistics chat? :
Or to post when I back fill all the S1s for wood pellet and that other campaign
Im not sure what he meant but he said ask Edward to post the s1 in both table and slack channel
I think that is what he means. Do you know if he is taking tomorrow and Friday off or is that for next week?
I think it’s for next week. Coz we have meeting later
Np!
ok. Coming
```-- 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;```
Received. Does he want you to do something with this by today?
yes, he wants me to do the reconciliation that Esteban posted yesterday
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?
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
Sounds good. Enjoy your lunch and let me know when you’re ready. Ty!
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
I already watched it. So I will join you once u watched it.
Hey @deleted-U06C7A8PVLJ can you please add me on Chowchilla channel?
I have a question for u. Are u at ur desk?
@deleted-U06C7A8PVLJ Im showing missing S1 for T2 on March 16
Ty!
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.
Hi Edward, so you changed to Michigan Pollution? And did Ryan know about that?
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
Since I feel like he will be delegating these small type of tasks to us (my feeling)
yeah, that would be good if you could let him know. Ty
yup you are correct but just for sake of informing him
Okay I just forwarded the message to him and us to be on safe side as well
@deleted-U06C7A8PVLJ can you please check this missing S1 for Wood T2 please
Hi Edward, do u know if we have this contract?
Do u have Leadespedia coontract ID for both?
Ryan said CA- JUV-DL/Flatiron is the correct one. Thanks for ur help @deleted-U06C7A8PVLJ
Sorry was on break and then had to talk to someone afterwards
*Thread Reply:* No worries
If they are the same shouldn't they ahve same leadspedia contract?
I know, they should have the same contract id
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
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
Got it, thanks man again
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
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
Yeah if it is removed in TIP then should be 1 more in SL since you would need to remove it in SL too
It looks like it wasnt there as you said haha
self reconciled lead... appreciated haha
I guess SL knew that it is going to be declined so it didn't record it at the first place
Can't verify something that isn't there to be verified 🤣
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!
*Thread Reply:* This was blank as you can see
I ran a query for all three wood pellets and I am not seeing any with blank S1s
No. I just randomly assigned S1s yesterday when I do the financials. Wondering if we can get the right one
So to confirm do you want me to fill in the blank S1s or to replace S1s with different S1s for certain clients?
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?
Gotcha that makes more sense. And you are referring to specifically 3/29 correct
Thanks
Type of Case: Michigan Pollution - Ben Crump Law - ELG - Shield Legal Signed Date: 03-29-2025 LRLeadID: 705337 LPLeadS1: PL-FacebookMB-MLtestdetna_2
This one is for Michigan Pollution let me know if you need the injury one
it was only Michigan Pollution no Injury
got it. Ty @deleted-U06C7A8PVLJ
Im showing missing S1s on the declines. please take a look
No worries. Will do. Thanks!
That one came in today so we should be working on that tomorrow
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!
I know we dont haha
I am assuming from yesterday post from Cam when he says google he is referring to himself right lol @Zekarias Haile
Perfect. & You're welcomes. Thanks for the confirmation
GM @deleted-U06C7A8PVLJ Im showing missing S1 for paraquat DL_ML
*Thread Reply:* it was 9 CP and 3 JA earlier. Now im showing 8CP and 4 JA Any idea why?
*Thread Reply:* Hmm I did not update a S1 unless it was blank so not 100 sure tbh
*Thread Reply:* The blank was the one you assigned to CP… that was on top
What do u mean by that? It's Paraquat- Dicello- Meadow Law
Okay for the Paraquat one it is in "Disqualified status" and I checked if they signed the retainer and they never did
So for me to review it from TIP I have to put it as signed & Declined status
yes please, since it's on e-signs yesterday, I have to record it and will remove when you post the declines
yes please, since it's on e-signs yesterday, I have to record it and will remove when you post the declines
so it's going to be umder today's declines or probably tomorrow?
But for me to remove it from TIP's dashboard I have to put it as signed and declined
I am only seeing one blank / missing S1 which is the one I gave you for wood pellet
looking forward for the meeting just ended now
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?
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
Hey @deleted-U06C7A8PVLJ are those leads in Secondary interview status? that's what Im showing
And I dont see them on the billable leads
Yeah the screenshot shows I added them into the dashboard since those rows once inserted then goes into the dashboard?
hmm I dont see on the Billable leads and Tip dash when I filter with those dates tho
Plus, those were added as intake I would assume when during sign e-sign process
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
Actually I dont see that number on the dashboard that I thought he mentioned
I shall hop off it and once he says hop on lets hop on lol
I was double checking everything and I see that Bard powerport doesnt seem right
But that is going to widen the gap for sure
But that is going to widen the gap for sure
I would just ask Ryan if $ is okay for what is shown in #34 ?
I did,, did you see that above your message
Maybe we need to create a thread and retag him on it? lol
He has like #34.b and we have #34.a or something
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
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
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 is he saying that the cost matches? im confused
Right? I was hoping a go head message from him
Yeah I would just say I shall update / insert those rows then
But I think you are in the clear since to me sounds like it is a yes
I guess we are going to do it tomorrow morning
I feel like there is something missing and we both don't know what it is
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.
I feel like know I understood it and started to make sense… but here we are haha
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
@deleted-U06C7A8PVLJ I was doing some stuff that I wanted to finish.. Can we push it to Monday please? Im sorry for pushing agian
Hey @deleted-U06C7A8PVLJ How are you doing?
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
Doing well as well, thanks! Sounds good. Pls ping me when done with the meeting.
Hey Zek looks like my meeting has been canceled so I am available if needed
EOM TIP Financial Dashboard Final Steps
Hey @deleted-U06C7A8PVLJ wondering if you have returned the 13 to 12 already? I see discrepancies on 4/14 .. wo
I see para 13 CP +2 and JA +1 TIP has 3 more
Hey @Zekarias Haile Coming back from lunch. We need to change the paraquat cases from paraquat 12 to 13 ?
no worries. Remember Ryan told us to change Paraquat 12 to 13 on April 15 as per Cam request?
im talking about this
Yes. He stated to do that as long as it was changed in Law Ruler first
One of them wasn't so I didn't make any changes to it because of that
Per Ryan's instructions. Do you know if all paraquat 12 in general
Gm @deleted-U06C7A8PVLJ when you posted the lead Id I think u missed two digit on the second one
Gm @deleted-U06C7A8PVLJ when you posted the lead Id I think u missed two digit on the second one
Nope that one is correct. I double checked it on law ruler too
Good morning @deleted-U06C7A8PVLJ these are from 04/25... missing S1s when you get a chance pls let me know
Good Moring Zek ! That is strange. Form my end it isn't showing any blank S1s
I see... probably try that specific date
I put the date from 04-25-2025 to current date and all have S1s
Sounds good. Will cross check this.. Ty!
That is a good question. Something may be going on with Looker studio?
I updated in LR and PGadmin in TIP's end to not have same leadspedia id #
These are few of the LR ids that are tied into one LP Id
May you check Ahsan's desk to see if you see samsung buds (white ones). I may have left mine there
@deleted-U06C7A8PVLJ Can you check this pls? Cam is saying that this is not in LR and double check it not showing it either
I am on lunch I can have it ready afterwards unless it is urgent urgent ?
No worries. Let me know when u return from lunch
Im sorry to bother you on your lunch. But can I check it on publicfinanciallog table?
yeah not pulling anything on that table
631908 found it on LR just want to let you know. FYI
Sorry about that again for taking your time
Copy. Let me know what you need help with if that being me changing the status in tip's database?
May you pop by with your laptop. Cameron is asking for something that is urgent
@deleted-U06C7A8PVLJ does your chair lean backward? i found one that looks like yours and wondering
that you don't need to check LR or Tip database to answer it hahah
It doesn't have to lean back or it can up to you how you set it up
-- 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
*Thread Reply:* This query is not providing me anything
*Thread Reply:* Nice!
*Thread Reply:* can u also send me March's please
*Thread Reply:* I want to compare to what Ryan sent me for March last month
https://www.loom.com/share/c6564f3e5a224aee88a9787fa87af85d Here would be the video for it too
Thanks! @deleted-U06C7A8PVLJ
-- 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;
Gm, Edward, sure..
Good morning Edward! When u get a chance can u pls check this S1 from 5/16
Good morning @Zekarias Haile Sure do you need the lead for it? 722328
How many signed up do u see for 5/16 on Firefighting Foam- Douglas-ML?
You're welcome. There is only one that is signed final for 5/16
one more last question for morning haha
Can u check this S1 for Camp Lejuene? I assigned to CP. That is for 5/17
Yes the lead ID for that one is 79447
Hey @deleted-U06C7A8PVLJ did u see Ryan's post on shield - Analytics?
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
sounds good haha
Gm @deleted-U06C7A8PVLJ, okay.
Gm Edward, sure.
@deleted-U06C7A8PVLJ pls take a look this missing S1. not sure if this the one Ryan was mentioning earlier
Sounds good. I am going through the S1s right now to fill in any blanks
@deleted-U06C7A8PVLJ friendly reminder if u haven't removed the declines yet. I see the Dash is off by 1
Do we know what case type it is? I double checked the one this morning and that one is signed & declined
I think I got it the issue is on 5/26.. Will fix it. Thanks Edward again!
are u gonna do something? it's already 180 ... im kinda confused
Nope I think he is just adding that into my notes just in case
I was going to do something but I realize we are already at 180 so we good
Gm, Edward. Okay, thanks!
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
Lambdas runs on its own every morning and I am running it again when I get here to see if we find any outliners
sounds good
can we schedule it to run twice in the morning?
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
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
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
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
Hey Edward what happened to this lead again pls refresh my memory 713984
I think this is where we talk to Mal and ask her if the costs changed between these timeframe?
What is weird is this case was signed on 06/04/2025 and not 4/18
Yeah I never heard of us billing for a lead but not for a signed contract lol
@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
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
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
I ask Ryan but maybe we need to ask Nick M to ask Cameron maybe?
ohh give me sec to check on my side and we can ask him
ohh give me sec to check on my side and we can ask him
Hi @Zekarias Haile would you know the name of the dashboard we were looking at earlier ago
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
I will start working on those 130 demo cases today
Thank you ! Are you referring to adding them in the dashboard?
138 (130 we have intakes and secondaries and 8 we created the intake and we have secondaries for those).
Im refrering to changing the names to Demayo... but once i finished it will start showup on the dash I would asssume
@deleted-U06C7A8PVLJ I see the old names on TIP dash.. this on Dec 1st 2021
I see. Are you able to see the lead? To confirm if they both the same lead
That one doesn't look like it is part of the DeMayo client list
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
Gotcha. So as long as the 130 Demayo are on TIP's end you would be fine?
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
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?
Gm, Ed heads up Nick has meeting rn... so we are not meeting now
Good morning Zek. Thank you for the friendly heads up. I let Nick M know I will be doing WFH today
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
On Monday I will be at the office since I would of reset my sleep schedule back to normal lol
ohh I see.. dont work too hard haha... enjoy your weekend man
I appreciate it Zek 🙏:skintone2: How is Ryan's stuff going do you know if we finished for the month of May yet haha
😅 that is has been my question for the whole week and I havent gotten an answer yet haha
Yeah I think it is because of Mark and cam with the pricing. I think they wanna lower and lower tip's costs
then we will finish both May and June at the same time haha
@deleted-U06C7A8PVLJ Do u guys updated the invoice by month for June for those mentioned cases?
So PFAS, NV, Soup are the one got updated?
okay
141126 this is missing S1. when you get a chance please take a look
*Thread Reply:* 124600 this one is also missing S1
I updated those you mentioned above. As for my screenshot I am assuming you or someone is changing the customer on these?
These include the extra 35 Demayo. They are for hair relaxer only for the extra 35
*Thread Reply:* No. It will be like this 20000
If so you may also need to know how much it is for Hair Relaxer DeMayo right
*Thread Reply:* Nick told me that it is 5072.46
*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
*Thread Reply:* So essentially 32 sign ups from SL while those three they did on their own (the intakes)
*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
*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
*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
*Thread Reply:* Which looks like is what you are doing so TY for that
*Thread Reply:* Np man
I updated the case type names in PGadmin so we should be good to go 🙂
@deleted-U06C7A8PVLJ Good afternoon. All marked in green are missing S1s. Please take a look when u get a chance
Copy. May you send me the .xlsx with just the green and I'll get that done right now
Basically if you send me the lead IDs like 12345, 239923, etc I can copy into PGadmin and find it
125134 126695 126699 126823 127827 128654 128718 132276
So I was misspelling problemo earlier hahah
Ah that might still be correct. For males it is o but females I think it is an A
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 from the 35 I see these leads are Firefighting 234332 234600
Those leads are case numbers I believe you meant to grab law ruler id
No worries
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
@Zekarias Haile Those looks like it is the "blank" intake ones I was telling you about
If it is a lead that is starting with 76... I would say that is the ones we created as fillers
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
sounds good. Thanks for clarifying that... Will finish up the remaining when I come back from lunch
163 DeMayos yes but 10 no (until we get an answer)
@deleted-U06C7A8PVLJ finally, I'm done with DeMayo!
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
Hey Edward, I'm sorry to hear that. No worries. feel better soon
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
That is good at least. Don't work to hard then haha
I wanted to share an email with you that flatirons is asking of us (to include these in the flatirons dashboard)
Currently the dashboard is giving them this error but for DeMayo only
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).
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:
*Thread Reply:* Thank you @Zekarias Haile
Good morning Edward, Sure will take a look at it.
List of all demayo clients and their sign dates and other fields
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
Hmm.. probably we have to check the filter (control) itself…
Oh okay we shall check that whenever you get back from lunch
SELECT ** FROM public.mediarawv2 WHERE rev_date >= '2020-01-01' AND customer = 'Dicello/Crump/DeMayo Flatirons (TIP)'
UPDATE pub.cmediarawV2 SET customer = '' WHERE idx_id IN ( )
Yeah before we add those clients in let's see what Cameron says
Good morning @deleted-U06C7A8PVLJ when u got a chance can u please check this missing S1s on 6/20
Okay I filled out three blank gaming 2's so maybe that should fix it
Thanks!
Also I wanted to see if you know what to do for those 28 DeMayo cases
No I can do it since Cam said we can use as SL leads
So I don’t see any difference to the one we did before right? If we are going to treat them as SL
Yeah I think we are going to treat them the same as regular SL leads
So regular prices and for media buyer he said we can use him
For customer I think we can put BLX on the 18 and the other 10 regular customers
Nancy emailed me so if we can get this done today it would make her happy lol
ohh I was thinking to avoid BLX at all ,,, Since we are treating them as SL
are you going to change them to SL in TIP database as well just to make it uniform
Let me ask Nick M about that since it still has to say BCL since I think that is the BLX ones
Yeah that’s what I think.. but let’s hear form Nick
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
hhaha... yeah that was my thought too
@deleted-U06C7A8PVLJ Im done with the 18 BLX’s
Woot woot :meow_attention: Great job @Zekarias Haile
But not sure what im gonna do with the 10 tho I forgot haha
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
Case type name was paraquat 12 and hair relaxer DL flatirons
Ohh okay.. so it’s going to be the same
@deleted-U06C7A8PVLJ The 10 leads are not added to the TIP database yet right?
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
If that is the case. I will work on adding those today and tomorrow you can add those 10
*Thread Reply:* I used the e-sign date on the excel
Did you ask Nick something? he told me to talk you... I would assume it's about this stuff but want to make sure
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 🙂
Good morning @deleted-U06C7A8PVLJ I hope you're doing well. Wanted to check with you
@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
No worries. Yeah Nick just told me that.
Thanks for checking. Going to fix something real quick for Cameron and I'll be hopping on that shortly
378207 386165 389439 396968 413759 423707 437599 443071 456917 457743 460373 469065 471728 475642 481802 485245 485666 487685 487754
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
might be they have different signed date?
I ran this as a query in Shield Legal Bi in bigquery but if they have different sign dates maybe that is why
Just posting just in case but maybe that could be the reason which makes sense
oh okay.. I thought u were checking on progress... but will take a look later.
No worries.
```-- 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;```
Good morning @deleted-U06C7A8PVLJ I hope you're having a great morning! I think you are WFH today right?
Going thru the S1s and Declines
ok, I saw the test leads but wanted to confirm with u ( wanted u to do it haha
S1 is missing for this. pls take a look for me when u get a chance 413759
Interesting. Okay going to reply back to Abe's Jira post and I will get that fixed shortly
No worries. Take ur time
Okay jira comment finished and S1 updated. It is strange how those get removed
Thanks
you added the S1 on lpleadid column just minor issue
Good catch ty. I adjusted it. I thought I was looking at s1 haha
Good morning @deleted-U06C7A8PVLJ Can you please check when you a get a chance. It's for 7/5
ohh that's weird it was blank.. but now it's all good. Thanks bro
Oh I see. it is magic 🪄:maleelf::skintone_2:
Hey @Zekarias Haile For ryan's EOM process, I updated the pricing for call center costs and agent commissions
I am working on updating the talk time almost done with that
And let me know when u work on AWKO dash... I can help and also want to learn Looker E
That works ! Cameron sent me a different slack to work on a separate dashboard for him haha
But I will get the questions for Andy and I will send to him
Yeah but the one he is asking me to do is a lot more simple thankfully
NEC Dicello/Flatirons. It's off by 3 when I checked on SL database I show 1251 like the dash
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.
Hey Zek. I am working from home today. However wanted to let you know I finished the talk time
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 😅
I think so. Like #10 she mark blue, #19, etc or pics work either or
Thank you. They pretty much (both stacks) share the same or similar questions? lol
I didn't get the chance to read them when Alex sent me but looks like it
I havent read myself just sent it to you hhaha
Oh okay haha. Other than talk time and call center / agent costs we are good?
The only thing I need to do left would be VSS reconciliation
778522 can u double check when this lead got signed in? you know more about LR and wanted to check it
Np! I see it in the slack channel but not on the dash
That is weird since It is in a final status in law ruler and in tip's database? lol
I know... not even in signed and declined status right?
I can try to put it signed & decline and re-add to final ? lol
May be let's give it a minute if it's able to make it?
That looks like a different lead ID # compared to the one you sent above?
yes, it's. Im saying this is the only one Im showing
I just saw that on your screenshot. But why that happened?
Good morning Edward, okay
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
Okay going to hop on now. Thank you @Zekarias Haile
Good morning @deleted-U06C7A8PVLJ how are you doing? How is the dashboard task going?
Good morning @Zekarias Haile I am doing alright and yourself
Updated 🙂 & De nada :facewithcowboy_hat:
My package was supposed to come yesterday but got delayed so I am hoping it will come today (reason for WFH)
ohh it's heavy for sure. Nice man, happy for you!
Thank you I appreciate it. Hopefully there isn't any fires over there
The well known Dicello of course haha
Hi Zek. Do you know by any chance the contract to this new case type: "San Bernardino Juv Hall - DL - DL - Shield Legal"
*Thread Reply:* @deleted-U06C7A8PVLJ I dont see this contract on Leadspedia. I remember it has only one lead
*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
*Thread Reply:* I see ... It would be great if you can ask Ryan
*Thread Reply:* Okay sounds good
Since we have some re-triggers for these so trying to find the appropriate S1 for this one
Good morning @deleted-U06C7A8PVLJ I will check it. Sorry about the late reply
I went ahead and move this into S&D status
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
Good morning Zek. Yes I am be on my way shortly
https://us-east-1.console.aws.amazon.com/lambda/home?region=us-east-1#/applications/TIP-Py311 This is link to run the lambdas
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
```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 ```
Sorry pgadmin is acting up on me. Can you check your settings for the TIP database and send me a screenshot of it
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
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
SELECT ** FROM rawstatusreport
If you run this from TIP's end see if you can download the entire .csv
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
We need to manually add these back into the table when successful
{
"errorMessage": "2025-07-23T17:50:12.463Z 99ae1748-233a-43f2-a301-d3ea868a65c7 Task timed out after 512.07 seconds"
}
```.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 ```
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
would you mind asking since you are more familiar with it?
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
Only because I have my hands tied for a dashboard cameron needs asap too
@Zekarias Haile I shall be heading my way to the office friendly heads up
Good morning @deleted-U06C7A8PVLJ alright
@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
Sounds good @Zekarias Haile. I will do my best to get those do asap in the morning
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
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
Yeah, that is something we need to talk in details.
When I come back the following week we can discuss I guess
Yeah that makes sense. The S1s are not hard though I got it down pretty well
okay, how long does it takes you to finish the s1s and slack alerts
Then I update the signed & declines and go into slack for those S1s and tag media buyers like this: @johnsmith DQ
And that's it. So total can be done 15-30 minutes for most days
Yeah not too hard and it has gotten better since when we had those wood pellets it was bad lol
I know right haha
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
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?
You’re welcome! I think around 7-7:30am should work fine.
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
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
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
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)…
I think Sunday 9am would be fine.. and for Saturday will ask Ryan if it’s okay you running it around 9am
But I wanted to say thank you so much for your help and sorry about to bother you after hours
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)
Understood. I will confirm with Ryan and will let you know. Thanks
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.
Good morning @deleted-U06C7A8PVLJ I don’t think you need to run the lambda today. The numbers looks correct. Thanks tho
Good morning Zek 🌞 Glad to hear 🙏
Good morning @deleted-U06C7A8PVLJ we are also good on numbers today so no need to run it. Fyi. Thanks
Good morning @deleted-U06C7A8PVLJ we are also good on numbers today so no need to run it. Fyi. Thanks
631908 & PL-FacebookMB-JACMP-003la Let's update the date to 11/14/2024
*Thread Reply:* Oh right let me double check sorry she sent me two screenshots of two different things I think that is why
Thank you Zek ! I shall review real quick
Thank you looks updated to me. Let me see if there are any others
No probelema @deleted-U06C7A8PVLJ
If they are a signed & decline status they will need to be removed from SL and they won't appear in the flatirons dashboard
That makes sense if that is the case I think this one should have it's status changed
That has been already removed since it was in the today's S&D
Oh okay perfect thank you for that update. i think i may have one left
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
I think this is the same lead id that we did first today
@deleted-U06C7A8PVLJ when do you think you will be able to update the July cc cost? Rose is asking me
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
ohh I see. Thanks man
Hey @deleted-U06C7A8PVLJ when do you think you will post the declines? and can you please check these missing s1s for me? 665903 665977
637745 682733 These two were moved to signed & declined