Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-08 15:00:10

https://console.cloud.google.com/bigquery?project=shield-legal-bi&ws=!1m0

accounts.google.com
Google Cloud Platform
Google Cloud Platform lets you build, deploy, and scale applications, websites, and services on the same infrastructure as Google.
Original URL: https://console.cloud.google.com/bigquery?project=shield-legal-bi&ws=!1m0
Ahsan (ahsan@shield-legal.com)
2024-07-09 10:29:52

Hey Nick might have to work from home today, my car is not starting this am

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 11:20:42

Ok sounds good. I need some help with pulling a set of docs out of Law Ruler. Think it would be good to get you familiar with the UI. I will need the Intake Forms and Signed Retainers for each lead in the spreadsheet I am about to send you. If you need some help on where to find it please hop on a call with Jackson Nakagawa. I told him you might be coming his way.

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 11:20:55
BaypointELG_-_PFAS-Custom Report-2024-07-08.xlsx
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 11:35:15

Going to skip meeting today. Just please get all those docs extracted, continue on making the fix for Ryan in AWS, and put together a report on how you want to restructure the Financial side

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 11:44:17

Actually before the Ryan stuff please connect with Cindy so we can get this API completed ASAP.

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 15:42:52

Where are you at with the docs and Cindy?

Ahsan (ahsan@shield-legal.com)
2024-07-09 15:44:20

When I test the uri for the updating the matter id or lead I get an error, so I have requested access to her postman collection, in the middle of pulling that list now. Btw the is there a faster way to do a mass export of docs or just one at a time?

Ahsan (ahsan@shield-legal.com)
2024-07-09 15:47:20

Did Cindy ever share the collection access directly or just send the code?

Ahsan (ahsan@shield-legal.com)
2024-07-09 15:47:25
image.png
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 15:54:23
shield legal.postman_collection.json
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 15:55:45

No there is no way to bulk export. You need to do it individually

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 15:56:26

If you can't import that collection let me know

Ahsan (ahsan@shield-legal.com)
2024-07-09 15:57:42

Already did a request for collection access but it may not hurt to fire off an email to her. Also was is Jackson’s email. My slack can bring up anyone on the tip side

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 16:11:04

I shared the collection with you directly. Please check and let me know if you can access it

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 16:11:24

jackson@tortintakeprofessional.com

👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2024-07-09 16:13:11

Yea I have access

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-09 18:35:43

@Ahsan please send me the docs that you have pulled so far

Ahsan (ahsan@shield-legal.com)
2024-07-18 12:27:47

*Thread Reply:* This is done and loaded on the google sheet, tab name is the same as this file name

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-18 18:06:29

*Thread Reply:* So use that one instead of the intake tab since I sent them the Secondary Interview already

Ahsan (ahsan@shield-legal.com)
2024-07-26 13:45:22

Prepped a few new test leads for vanlaw for our 12.

For Torticity we need them to provide some more campiagnid s. Their api wont let me reuse the one we have to some other test leads. So I am going to fire off an email requesting some more for testing.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-26 13:47:38

Might need you to lead that convo. I am working on something for Cam

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-26 13:48:25

Reach out to Torticity

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-07-26 13:49:26

Also, they said to just pass the rest of the questions from the form how ever we want it to be so try adding some test data for that to so we can see if it gets created on their side.

👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2024-07-31 10:32:54

Hey Troy just reached out. Taking this meeting at home right now.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-08-01 17:15:58

https://app.getpostman.com/join-team?invite_code=d1f7aecd8f4b06cc1a411882516571cc&target_code=e6d360cab3b04810a47d5d0b02a6c4ec

app.getpostman.com
A teammate invited you to join their Postman team
Build, share, and collaborate on API solutions with your teammates in Postman.
Original URL: https://app.getpostman.com/join-team?invite_code=d1f7aecd8f4b06cc1a411882516571cc&target_code=e6d360cab3b04810a47d5d0b02a6c4ec
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-08-01 17:17:14
Wagstaff APIs.postman_collection.json
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-09-16 13:18:16
Law Ruler API Guide (2).pdf
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-09-16 13:22:37

Hillel hcharm@wagstafflawfirm.com

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-09-26 19:07:27

@Ahsan what values do you have for the ones I have highlighted?

image.png
Ahsan (ahsan@shield-legal.com)
2024-09-27 09:57:36

Those fields should be set as the fields that populate off the lead. Let me check the juel test lead to make sure those fields are filled out. Will do so after the doc appt, on around 12ish. Also Paraqueat didnt trigger last night. SO looking into that as well.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-10-25 11:37:43

I need to skip the meeting with Rahul unfortunately. I trust you got it though

Ahsan (ahsan@shield-legal.com)
2024-10-25 11:39:01

Copy, we also dont know if he is going to show. We didnt send a meeting invite til yesterday, and he still has his auto accept on. Dustin did send me the test logs so we should be good if he shows.

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-10-25 18:57:44

How did it go?

Ahsan (ahsan@shield-legal.com)
2024-10-25 18:59:39

Well enough. Sent the code to Rahul as well. He saw how we would get the 500 error and then a 200 in between the number of calls. He just wants the exact payload log now for the 500 errors we got. That log hit a table in gcp I don’t have access to so I will have Dustin pull that Monday to send to the SA so they can dig on their end.

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-10-25 19:11:44

OK good job handling that

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-10-30 15:38:39
Plaintiff Intakes.zip
Nick 5 intakes (1).xlsx
Ahsan (ahsan@shield-legal.com)
2024-12-06 17:58:07

VGA report. Leads all have been re-triggered into their system.

Impacted VGA leads.xlsx
Ahsan (ahsan@shield-legal.com)
2025-01-08 16:40:38

Hey Nick, I gone through the code a few times and have a pretty good understanding of what each cell is doing. I talked with Edward about his portion. So I want to confirm a few things about this refactor.

• The cell that handles the date ( cell 8 which is the date range) just needs to update to catch the last 6 months since that is the last time we got med records right? ◦ Edward says if the date is updated nothing should break

Ahsan (ahsan@shield-legal.com)
2025-01-09 17:59:30

Also got a trace back error for a config file

fl test.py
Ahsan (ahsan@shield-legal.com)
2025-01-09 18:05:44

got it, ty!

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-01-29 17:46:27

Chowchilla Womens Prison Abuse - ACTS - AWD - Shield Legal

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-24 10:49:06
Flatirons Benchmark 20250219.xlsx
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-24 11:10:24
Flatirons Benchmark (11).xlsx
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-24 11:10:35
Decline Reason Updates.xlsx
Ahsan (ahsan@shield-legal.com)
2025-02-24 12:14:51

Need to send this excel to Nico, he didn't provide his email or Abe's, can you send me both their emails when you have a chance so I can send this list to them.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-24 12:37:11

nhorattas@dicellolevitt.com

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-24 12:38:21

mabramowitz@dicellolevitt.com

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-24 12:38:25

add myself and Cameron

Ahsan (ahsan@shield-legal.com)
2025-02-24 12:38:36

Will do

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-24 15:49:29

make sure the leads that we determined a new match for are included in the mapping Brittany team is doing and going to be updated with the next pull. Luis is making all the changes to the statuses and then we will need to rerun tomorrow morning to make sure all of those are brought in

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 11:15:01

Hey I need the latest version of the gcp report. Can you run and send it to me. Send me what you have but can you confirm with Luis how many they have gone to update from the list we put together with Nicoo

👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2025-02-27 11:15:34

on it

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 11:21:10

Also, check your email. Abe has updated the spreadsheet and wants us to match up our ID. Make sure this doesn't change our automation and please put that together for him

👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2025-02-27 11:35:00

Is that email form abe supposed to have a spreadsheet? There is nothing attached.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 11:36:39
Flatirons_Medical_Record_Tracker_02_27_2025.xlsx
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 11:36:43

guess it didnt forward but here it is

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:21:39

update?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:21:47

need a copy to send

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:35:48

?

Ahsan (ahsan@shield-legal.com)
2025-02-27 12:43:06

just finished the huddle, almost done

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:43:56

Ok but remember anything Flatirons is top priority that includes those huddles

Ahsan (ahsan@shield-legal.com)
2025-02-27 12:44:54

yea code is running

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:45:48

did you reach out to Luis?

Ahsan (ahsan@shield-legal.com)
2025-02-27 12:47:57

Luis hasn’t had any changes since Monday. Only a couple changed. Waiting on that list

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:49:09

He completed all of CPAP and has not started on AFFF?

Ahsan (ahsan@shield-legal.com)
2025-02-27 12:50:49

Esteban did AFF for that. Luis said he had a few for flat irons and he is sending me that list, he also said that list is the one tony and cam have already. So if you have that one, that is the data I would be using.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:51:35

I shot you the link to the shared google sheet

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:52:00

Why did Esteban change those statuses? It was supposed to be Luis

Ahsan (ahsan@shield-legal.com)
2025-02-27 12:52:11

got, going through it now

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:52:37

He was supposed to change the statuses according to Cam's choices in column E

Ahsan (ahsan@shield-legal.com)
2025-02-27 12:53:00

I will get with him and luis and figure this out.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:53:39

Ya the meeting Cam and Tony and I had was Luis would be updating these and then notating what he has completed

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 12:53:55

All of those were supposed to be updated prior to our pull

Ahsan (ahsan@shield-legal.com)
2025-02-27 13:06:07

check group dm with dutin, file is there.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:07:40

ok and then please let me know about Luis. Will need to include the difference in my message

Ahsan (ahsan@shield-legal.com)
2025-02-27 13:13:30

Will do. These are the differences. • 560172 • 574643 • 237484

Ahsan (ahsan@shield-legal.com)
2025-02-27 13:13:51

Adding Luis into flat irons searing and sending him, Mondays recon with Nico.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:16:30

He has access to the google sheet I shared with you

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:17:01

Make sure he is flagging which are completed moving foward. Can just be another column

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:29:37

Please make sure that those he did edit the status were captured properly in the report

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:34:11

is the last benchmark file esteban posted the one you are using?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:34:50

nevermind i see your update

Ahsan (ahsan@shield-legal.com)
2025-02-27 13:35:12

I wasnt on the distro list, so I got the latest files from Edward.

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:36:41

thanks

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:37:46

are you able to see the Flatiron-Financial-Checkallweeks query in the SL project?

Ahsan (ahsan@shield-legal.com)
2025-02-27 13:40:10

checking

Ahsan (ahsan@shield-legal.com)
2025-02-27 13:41:40

Yea dont see that in sl bi gcp

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:46:10

ok well I will send you the SQL shortly but I want to include in the code updating the financial part

Ahsan (ahsan@shield-legal.com)
2025-02-27 13:46:18

ok

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:49:00
Flatiron-Financial-Check_all_weeks.sql
👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:49:17
Camp Lejeune EO Split by week.sql
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:50:35

Now the caveat is that I will usually throw this in a pivot and then there are some customer considerations depending on the case type. Also, need to make sure case types are being combined that need to be

Ahsan (ahsan@shield-legal.com)
2025-02-27 13:51:59

do we have a list of the casetype that have to be combined to is it based by tort type? And is the combining done across the board or is it more discretionary the combining?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:52:28

the mapping is combining the case types so follow that

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:52:48

ex. AFFF has the PFAS Water Contamination

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:52:57

but only for AFFF NC

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:55:05

Anything with a split tab will need to remove the highlighted customers and the NC tab will need to just have the highlights. AFFF NC gets the military exposure ones but no one else

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:57:09
image.png
👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 13:58:30

Camp lejuene will get choose one of these options accordingly:

image.png
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 14:00:02

tricky part is that this goes off of the year weeks so the will be a 53 and/or 0 week at the year mark. 53 and 0 should be combined

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 14:00:22

as week 1

Ahsan (ahsan@shield-legal.com)
2025-02-27 14:00:49

OK, If I run into issues I will get with Dustin.

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 14:01:08

therefore going into 2025 the week numbers are off by 1

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 14:01:33

we can rename it not a problem but the code splits them due to the year week mark

Ahsan (ahsan@shield-legal.com)
2025-02-27 14:01:47

Running through the code to add in the logic we need.

Ahsan (ahsan@shield-legal.com)
2025-02-27 14:01:57

OK Will account for those adjustments as well.

🙏 Nicholas McFadden
Ahsan (ahsan@shield-legal.com)
2025-02-27 15:33:02

Talked with Estebhan, and he couldnt find any matches for AFF.

Ahsan (ahsan@shield-legal.com)
2025-02-27 17:27:16

Dustin and I ran the new match profile and the numbers shift quite a bit, from 690ish to 1350 ish. Is it good with you I send an update email to Abe to let him know numbers shifted and we are looking further into the matches. And he will get the match report on Friday instead once we have more certainty in where the shifts in numbers occurred.

The total row count is about 7600 leads and before the new match profile we were around almost 700 off, doubling the amount off is concerning and I would like to be sure the matches we have are good.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-27 18:59:40

Do more investigation and figure out why things have changed before you reach out to him.

Ahsan (ahsan@shield-legal.com)
2025-02-27 19:27:04

Will do

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:10:12

Need to get an updated list of matches for Abe

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:18:26

First priority

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:34:25

Yea talking with Esteban right on about it.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:34:55

Is Brittany in the office?

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:42:07

I didnt see her but she normally doesnt show til after 9:30 or so. Let me ping her team.

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:43:09

Not in yet

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:44:15

Abe is fired up and she has the messages too. I need you to collaborate with them and get a list of matches so far asap, then if you determined the reason for the increases let me know,

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:46:09

Talked with Edward and Esteban on that already. Abe's team added 2 columns. Edward was not made aware of those changes so the code didnt look for those 2 new columns and essentially doubled the row count as duplicates. Edward says Brittany was made aware of the new rows but did not tell Edward so he didnt update the script. Hence the fire.

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:47:35

Esteban had matched 60 so far on AFF, gave him the update match profile so we are working through that now. Also added Luis in the Flat Irons channel so he is aware when the spreadsheet is updated so he can do his process. Luis was never in the channel, which is odd since he owned the status change process.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:47:37

We have the declines that we went over with Nico but I though Luis might have a spreadsheet or something he was tracking for flatirons decline reasons missing. Can you see if he has anything? We need to be notifying DL about issues and sending back reports

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:47:45

This should make coms smoother on our end.

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:48:38

Luis has a spreadsheet for the reasonings, I had Luis share that sheet with Esteban and Aiden since Luis's sheet has both Dl and our LR id

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:49:27

They add two new columns but did that screw anything up? Is the report i sent out wrong or just treat we haven’t utilized the new columns yet?

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:50:30

No the new columns doubled the row count for what we send according to Edward. I am having Edward look into how much stuff shifted so we have have a response back ass to why this happened.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:51:10

We need to be notifying DL on a daily basis of decline reasoning issues. We need to get their matches updated.

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:51:28

Doubled the counts?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:51:49

Si then there’s duplicates in my report?

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:53:45

We dont believe so, but the counts increased on Edwards script.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:55:30

Please document any issues with the DL data we are having, counts, matches, declines needing reasonings. I got to get this to him in some form in the next hour or two. I’m going to a doctors appointment so I’ll be a little unavailable. When Brittany gets in make sure to colab with her in what she thinks needs to be delivered but I need yall to get this done.

Ahsan (ahsan@shield-legal.com)
2025-02-28 11:56:42

We are documenting everything, we know Dls two columns did stuff, how big of an impact we are finding out so we can point to the failures of where they didnt follow the process without truly blaming them.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-28 11:57:37

Moving forward we need to be checking to make sure things don’t change. They are gonna test us to make sure we are reviewing everything every day now

👍:skin_tone_4: Ahsan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-10 13:19:00
gcp_reporting 20250303 (1).xlsx
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-26 18:49:06

Hey Flatirons is going to be in the office tomorrow and Cam wants us to be available to meet with them between 11:30_2:30

Ahsan (ahsan@shield-legal.com)
2025-03-26 18:49:35

Yea Dustin told me, currently updating the template so tomorrow’s run should be good

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-26 18:49:38

Not the whole time just they will be available sometime within that so be ready to explain process and discuss what we have going on

Ahsan (ahsan@shield-legal.com)
2025-03-26 18:49:59

Yea have the pipeline docs and everything good to go

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 13:21:25

Please go and update the financials for me today since I am at the conference.

Ahsan (ahsan@shield-legal.com)
2025-04-09 13:21:43

already in the middle of that

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 13:21:48

Then send me the final of the 3 docs so I can forward

Ahsan (ahsan@shield-legal.com)
2025-04-09 16:39:45

Hey Nick I checked multiple campaign the week number under the row labels column does not match the existing template output. The signed contract's value does not match for the expected week number, off by one row. is that the norm. Also using the config file to determine the appropriate case type, specifically for CA juv, what case types should be counted for the campaign filter? Anything and everything CA? Like Los Padrinos Juv Hall , CA Juv Hall Dention , LA Juv Hall Abuse TV

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 16:43:49

Yes after because how it calculates the weeks there are technically a 53 and 0 “weeks” for 2024. I add them together but that creates an off of the numbering.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 16:44:24

So everything shift by one in 2025

Ahsan (ahsan@shield-legal.com)
2025-04-09 16:44:30

oh, ok, hat makes more sense now.

Ahsan (ahsan@shield-legal.com)
2025-04-09 16:45:09

so that output from the sql query is what the retained cases should be

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 16:45:44

CA Juvenile and LA TV but not Los Padrinos (since has its own)

Ahsan (ahsan@shield-legal.com)
2025-04-09 16:51:45

ok just wanted to make sure,

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 17:04:18

There is another LA in I think

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 17:04:27

I believe it’s 3 that go into it

Ahsan (ahsan@shield-legal.com)
2025-04-09 17:05:34

Only other one than los padrinos would be the foster care under la

Ahsan (ahsan@shield-legal.com)
2025-04-09 17:06:05

Only other one than los padrinos would be the foster care under la

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 17:07:31

Ya I believe La foster, La TV, and CA Juv are all together

👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2025-04-09 17:49:54

sent you the email. Also made a backup of the fl report folder so you can see the csv, outputs from the queries here

Ahsan (ahsan@shield-legal.com)
2025-04-09 17:50:17

shared the link to your shield as well.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 17:51:49

Ok thanks

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 17:52:44

It all tied out? Looked like the counts were relatively the same and you accounted for and combined the extra week?

Ahsan (ahsan@shield-legal.com)
2025-04-09 17:57:22

Yea, checked each tab, it all looked good, filtered and adjusted for the NC campaigns as well. But this being my first time doing it I am not a 100 that its flawless.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 17:58:02

Compare to last iteration

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 17:58:09

Shouldn’t be drastically off

Ahsan (ahsan@shield-legal.com)
2025-04-09 17:58:21

Also froze the top 14 rows to make it easier to navigate the tabs as well. IDK if Nancy's or your life on this sheet would be easier with but thought it would be helpful;

Ahsan (ahsan@shield-legal.com)
2025-04-09 17:59:23

I dont have last weeks financial injection just the raw output, if you can forward last weeks send I can look that over tonight as a double check and let you know in the am if I find anything off

Ahsan (ahsan@shield-legal.com)
2025-04-09 17:59:49

I dont have last weeks financial injection just the raw output, if you can forward last weeks send I can look that over tonight as a double check and let you know in the am if I find anything off

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 18:09:25
template1_output 20250330
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 18:09:40
template2_output 20250330
Ahsan (ahsan@shield-legal.com)
2025-04-09 18:09:47

cool will look it over and compare

🙏 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 18:51:42

Am I good to send it

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 18:51:52

Haven’t had a chance to check and want to send before 5

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 18:55:05

Also is the email ok to forward or do I need to grab from drive?

Ahsan (ahsan@shield-legal.com)
2025-04-09 19:26:04

Email is good

🙏 Nicholas McFadden
Ahsan (ahsan@shield-legal.com)
2025-04-09 19:26:15

Drive is for us

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 19:26:32

Thanks

Ahsan (ahsan@shield-legal.com)
2025-04-09 19:27:15

Sorry for late reply, battling traffic. Running through last weeks financials for comparison. I will dm if I notice anything

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-09 19:40:26

Ok ya let me know I forwarded it already

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-10 09:35:06

Need you to be on call with Meadow at 12:45

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-10 09:36:21

Dustin and I will be on too. Let’s let them lead and be just to the point. This will be probably be a tense meeting

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-10 09:36:46

Be ready to do any live tests or setup while in the call

Ahsan (ahsan@shield-legal.com)
2025-04-10 10:24:00

Yea I figured. Already building new test leads for all 3 vga campaigns and double checking the mappings for the logic pii fix we implemented.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-10 10:34:01

Also do a thorough check of logs to make sure no missed sends

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-10 10:34:34

Just want to make sure we have all the bases covered

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-10 10:35:26

Have some examples that failed on hand

Ahsan (ahsan@shield-legal.com)
2025-04-10 11:12:39

Yea once I double check the mappings for the vga campaigns and have dustin merge in that logic, going to re-trigger those 41 outstanding. And what fails from there, if any will be the examples we have.

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-11 18:04:05

Hey forwarded you a message from Nancy

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-11 18:04:16

Can’t review at this moment

Ahsan (ahsan@shield-legal.com)
2025-04-11 18:04:46

Yea reading email now. Want me to respond and say looking into it?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-11 18:05:04

Yes please

👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2025-04-11 18:20:43

Just responded to nancy. You are cc’d on it.

🙏 Nicholas McFadden
Ahsan (ahsan@shield-legal.com)
2025-04-17 16:07:14
template1.xlsx
template2.xlsx
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-28 13:17:18

Hey can you put together your official resignation letter and send it to me? Need to share with Shellie

Ahsan (ahsan@shield-legal.com)
2025-04-28 13:51:48

Yea will send it to you after I finish this flatirons stuff

Ahsan (ahsan@shield-legal.com)
2025-04-29 18:03:08
 
    campaign,
    customer, 
    SUM(e_signed_contracts) as Signed_Contracts, 
    SUM(e_daily_revenue) as Cost, 
    EXTRACT(WEEK(MONDAY) FROM rev_date) AS week, 
    EXTRACT(YEAR FROM rev_date) as year 

FROM `shield-legal-bi.sl_dashboard.financial_details`
WHERE rev_date between '2023-12-11' AND DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
    AND customer Like '%Flatirons%'
GROUP BY 
    campaign,
    customer, 
    EXTRACT(WEEK(MONDAY) FROM rev_date),
    EXTRACT(YEAR FROM rev_date)