Ahsan (ahsan@shield-legal.com)
2025-01-07 11:01:12

@Ahsan has joined the channel

Daniel Schussler (dschussler@shield-legal.com)
2025-01-07 11:03:52

@Daniel Schussler has joined the channel

Dwight Thomas (dwight@shield-legal.com)
2025-01-07 11:03:52

@Dwight Thomas has joined the channel

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

@Zekarias Haile has joined the channel

Dustin Surwill (dsurwill@shield-legal.com)
2025-01-07 11:03:52

@Dustin Surwill has joined the channel

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-01-07 11:03:53

@Nicholas McFadden has joined the channel

Malissa (malissa@shield-legal.com)
2025-01-07 11:03:53

@Malissa has joined the channel

Greg Owen (gregowen@shield-legal.com)
2025-01-07 11:03:53

@Greg Owen has joined the channel

Mark Maniora (markmaniora@shield-legal.com)
2025-01-07 11:03:53

@Mark Maniora has joined the channel

slackbot
2025-01-07 11:03:58

Tort Intake Professionals has joined this channel by invitation from Shield Legal.

deleted-U04GZ79CPNG
2025-01-07 11:03:59

@deleted-U04GZ79CPNG has joined the channel

deleted-U072JS2NHRQ
2025-01-07 11:04:00

@deleted-U072JS2NHRQ has joined the channel

deleted-U06C7A8PVLJ
2025-01-07 11:04:01

@deleted-U06C7A8PVLJ has joined the channel

deleted-U06CVB2MHRN
2025-01-07 11:04:01

@deleted-U06CVB2MHRN has joined the channel

deleted-U07SBM5MB32
2025-01-07 11:04:02

@deleted-U07SBM5MB32 has joined the channel

deleted-U072B7ZV4SH
2025-01-07 11:04:03

@deleted-U072B7ZV4SH has joined the channel

Ahsan (ahsan@shield-legal.com)
2025-01-07 11:04:20

set the channel description: Singular channel for all the data people

deleted-U072B7ZV4SH
2025-01-07 11:04:33

here we go again

😂 deleted-U072JS2NHRQ, deleted-U06CVB2MHRN, deleted-U07SBM5MB32
deleted-U055HQT39PC
2025-01-07 11:05:23

@deleted-U055HQT39PC has joined the channel

deleted-U04R23BEW3V
2025-01-07 11:05:23

@deleted-U04R23BEW3V has joined the channel

deleted-U05496RCQ9M
2025-01-07 11:05:23

@deleted-U05496RCQ9M has joined the channel

deleted-U062D2YJ15Y
2025-01-07 11:05:24

@deleted-U062D2YJ15Y has joined the channel

deleted-U06GD22CLDC
2025-01-07 11:05:24

@deleted-U06GD22CLDC has joined the channel

deleted-U04GG7BCZ5M
2025-01-07 11:05:24

@deleted-U04GG7BCZ5M has joined the channel

James Turner (jturner@shield-legal.com)
2025-01-07 11:05:24

@James Turner has joined the channel

James Turner (jturner@shield-legal.com)
2025-01-07 11:09:37

beep boop bop

tenor_gif6207575309109461872.gif
😂 deleted-U072JS2NHRQ, deleted-U06C7A8PVLJ, deleted-U072B7ZV4SH, deleted-U06CVB2MHRN
deleted-U06CVB2MHRN
2025-01-07 11:10:14
IMG_5149
😂 deleted-U072JS2NHRQ, deleted-U072B7ZV4SH, Malissa
deleted-U072JS2NHRQ
2025-01-07 11:13:31

oh neptune

😂 deleted-U072B7ZV4SH, deleted-U06CVB2MHRN, Malissa
deleted-U06GD22CLDC
2025-01-07 11:42:16

hackerman

😂 Malissa, deleted-U072JS2NHRQ, Nicholas McFadden, deleted-U06C7A8PVLJ, deleted-U072B7ZV4SH
Malissa (malissa@shield-legal.com)
2025-01-07 12:20:55

so... in all seriousness.... what's the why behind this channel? Like... Why are we here? Where did we come from? How was this created? What is the answer to the ultimate question?

Ahsan (ahsan@shield-legal.com)
2025-01-07 12:31:59

*Thread Reply:* This channel purpose is to have a unified channel for the data folks to prevent duplicate reporting.

👍 Malissa
deleted-U072JS2NHRQ
2025-01-07 12:24:31

who are you people

🤣 deleted-U072B7ZV4SH, deleted-U06CVB2MHRN
deleted-U072JS2NHRQ
2025-01-07 12:24:57

I think it's just so all the data people are in 1 chat I believe, but I'll leave that up to others to confirm or deny

deleted-U07SBM5MB32
2025-01-07 12:28:10

Yeah it seems like based on yesterday's meeting, maybe they wanted to just put all us together so we know which of our tasks overlaps/relates to other departments', like a cross functional effort to make sure the data flows right

👍 Malissa
Ahsan (ahsan@shield-legal.com)
2025-01-07 12:32:32

@here

This channel purpose is to have a unified channel for the data folks to prevent duplicate reporting.

🫡 deleted-U07SBM5MB32, deleted-U072JS2NHRQ, deleted-U06CVB2MHRN
👍 Malissa
🙌 deleted-U04GG7BCZ5M
deleted-U072B7ZV4SH
2025-01-07 12:38:05

spongebob

😂 Malissa, deleted-U06CVB2MHRN, deleted-U072JS2NHRQ
deleted-U072B7ZV4SH
2025-01-07 12:38:13

ok last one

😂 deleted-U072JS2NHRQ
Ahsan (ahsan@shield-legal.com)
2025-01-07 18:39:23

Hey @deleted-U055HQT39PC these are the mappings of Smart Advocate's system. the JSON description is the default fields for most Smart Advocate cases. I have included all the Fields for Medows' case types. Gaming Addiction - Ben Crump Law - Meadow Law - Shield Legal & Gaming Addiction - Meadow Law/Levinson/TC (TIP) - Shield Legal

Copy of JSONFieldDescription.xlsx
Gaming UDFs (2).xls
Ahsan (ahsan@shield-legal.com)
2025-01-08 17:18:15

This is the database ERD for those that may need to every do sql https://drive.google.com/file/d/1BRoyIW-CU9g-Mx-kiLd7SkcmthnbLevc/view?usp=sharing

🙌:skin_tone_2: deleted-U072B7ZV4SH
deleted-U083HCG9AUR
2025-01-22 18:23:59

@deleted-U083HCG9AUR has joined the channel

Josh Josue (jjosue@shield-legal.com)
2025-01-31 13:55:17

@Josh Josue has joined the channel

deleted-U07SBM5MB32
2025-02-05 11:11:42

@Ahsan I was told that Meadows wants their Smart Advocate number for the VGA daily report - would you be able to run a script to pull that information so I can match them up? Apologies in advance if that's not something you do

Ahsan (ahsan@shield-legal.com)
2025-02-05 11:14:50

*Thread Reply:* I have a script already that pulls the sa id for leads we send in successfully.

deleted-U07SBM5MB32
2025-02-05 11:16:14

*Thread Reply:* Got it, so would I send you the leads that were finalized/declined yesterday so you can pull those IDs or does the script produce a masterlist for everything with a SA #? Just trying to figure out the new process

Ahsan (ahsan@shield-legal.com)
2025-02-05 11:18:30

*Thread Reply:* This is all the successful leads that posted for the Gaming Addiction - Ben Crump Law - Meadow Law - Shield Legal Levinson is not in here yet.

bquxjob_50d0b8ca_194d71d04b8.csv
Ahsan (ahsan@shield-legal.com)
2025-02-05 11:18:56

*Thread Reply:* M: is the meadow id

deleted-U07SBM5MB32
2025-02-05 11:19:28

*Thread Reply:* Thank you! And thanks for the heads up about Levinson, I'll keep a note of any of the leads in that specific case type.

Ahsan (ahsan@shield-legal.com)
2025-02-05 11:20:18

*Thread Reply:* The dataware house is built off the case type id so most reports we send wont have the case id name listed.

deleted-U07SBM5MB32
2025-02-05 11:22:55

*Thread Reply:* Thanks for letting me know! I think there might be something that Edward worked on that shows a list of all the case type IDs

Ahsan (ahsan@shield-legal.com)
2025-02-05 11:23:35

*Thread Reply:* This is the LR link that shows the case type name and its id

https://tortintakeprofessionals.lawruler.com/cases.aspx

deleted-U07SBM5MB32
2025-02-05 11:23:48

*Thread Reply:* Thank you!

Ahsan (ahsan@shield-legal.com)
2025-02-05 11:54:17

*Thread Reply:* @deleted-U07SBM5MB32 working on on the Gaming Addiction - Meadow Law/Levinson/TC (TIP) - Shield Legal pushes right now.

deleted-U07SBM5MB32
2025-02-05 11:55:13

*Thread Reply:* Thank you!

Ahsan (ahsan@shield-legal.com)
2025-02-12 13:08:26

These are the generic SA fields you requested. @deleted-U062D2YJ15Y @deleted-U05496RCQ9M @deleted-U055HQT39PC

SA Default List.txt
👍:skin_tone_3: deleted-U05496RCQ9M
✅ deleted-U055HQT39PC
Ahsan (ahsan@shield-legal.com)
2025-02-12 13:22:31

*Thread Reply:* Updated the payload file for SubType @deleted-U062D2YJ15Y

🙌 deleted-U062D2YJ15Y
Ahsan (ahsan@shield-legal.com)
2025-02-12 16:02:44

Hey @deleted-U04R23BEW3V here is the logging report for Bard PowerPort - Bay Point - Simmons - Shield Legal In the external ID column, S is for simmons and BP is baypoint

bquxjob_26befaaf_194fc2a6047.csv
deleted-U08E306T7SM
2025-02-17 17:31:37

@deleted-U08E306T7SM has joined the channel

deleted-U08FJ290LUX
2025-03-05 15:31:08

@deleted-U08FJ290LUX has joined the channel

deleted-U08GMHAPRK2
2025-03-05 15:31:08

@deleted-U08GMHAPRK2 has joined the channel

deleted-U072JS2NHRQ
2025-03-27 12:46:43

Posting here for visibility: @deleted-U04GZ79CPNG @Dustin Surwill I'm trying to build the Chowchilla AWD benchmark through the BQ database, but the lrdump code isn't pulling every update that it should from LawRuler, can you check into this more @Dustin Surwill. There's a lead that's showing as 'IN PROCESS' in the db, but in LawRuler it's been in FINAL since 3.7.25 (694142).

We can't use the db unless we're 100% sure that it's actually updating all the information that it's supposed to.

Below are some example leads that I found have outdated/old status's in BQ vs LawRuler:

651026
658187
680433
682968
688934
527703
492765
506998
510749
512103
541911
567921
591119
596354
624047
630042
635637
636064
636206
658022
680104
681189
684835
692780
447300
529774
560725
560793
560872
576697
619888
651164
661193
672860
687563
691780
692397
628679
665961
687169
692734
692777
508437
617460
645006
675394
693394
693454
693736
411462
415644
455696
459775
508723
521906
526507
528913
529153
529997
533195
542192
550282
560577
560693
577226
605663
611950
624887
628326
628611
628619
628920
629259
629950
630176
635213
636294
637670
693577
693721
693683
693559
693451
693087
691958
689210
686768
686354
685848
686060
683337
681176
677404
667304
666372
657260
653822
64567
Dustin Surwill (dsurwill@shield-legal.com)
2025-03-27 13:37:49

*Thread Reply:* Looking at the db dump logs, there was a lot of errors around that time (3/7/2025) that have since been fixed

Ahsan (ahsan@shield-legal.com)
2025-03-28 14:40:21

@deleted-U08GMHAPRK2 when requesting access to the ERD and other docs please use your tort email so we do not flag the request as a phishing scam. Please and thank you!

deleted-U08GMHAPRK2
2025-03-28 14:49:17

Sorry......didn't notice at the time.....all good for now.....

Ahsan (ahsan@shield-legal.com)
2025-03-28 14:52:48

*Thread Reply:* NP, just in the future use tort so we know who is actually requesting access.

Ahsan (ahsan@shield-legal.com)
2025-03-28 14:54:24

@deleted-U05496RCQ9M @deleted-U062D2YJ15Y or @deleted-U055HQT39PC the flatirons naming scheme/convention how do we make the determination for the case type name? Also what does NC mean?

image.png
Ahsan (ahsan@shield-legal.com)
2025-03-28 15:07:04

*Thread Reply:* @deleted-U055HQT39PC thank you :thank_you: 🐐

🙌 deleted-U055HQT39PC
Ahsan (ahsan@shield-legal.com)
2025-03-28 15:08:24

@James Turner for the pctid_data, which is the most up to date table/view and which is constantly update that we can ping off of for reporting?

James Turner (jturner@shield-legal.com)
2025-03-28 15:30:17

Lemme grab that for you one sec-

James Turner (jturner@shield-legal.com)
2025-03-28 15:34:16

tort-intake-professionals.pctiddata.pctiddatafromexcel

Excel Ref Sheet -> saves as pctiddatafrom_excel

James Turner (jturner@shield-legal.com)
2025-03-28 15:34:32

If you are looking for PCTID data mixed with Lead data I have that as well

James Turner (jturner@shield-legal.com)
2025-03-28 15:35:59
image.png
James Turner (jturner@shield-legal.com)
2025-03-28 15:37:28

Ideally I would like to get the source off of Excel and into Retool eventually, that's part of the long term goal

Ahsan (ahsan@shield-legal.com)
2025-04-01 14:16:14

@James Turner for the pctid_data_from_excel table in pctid is partnerfirm and partnerfirm2/3 co equal co counsels or is there a hierarchy depending on the case type?

James Turner (jturner@shield-legal.com)
2025-04-01 14:17:37

The hierarchy of primary firm, partner firm, partner firm 2/3 is determined by what comes first in the original case name

Ahsan (ahsan@shield-legal.com)
2025-04-01 14:18:18

*Thread Reply:* So are they co equal or not? Or is it that partner 2/3 work more like an overflow?

James Turner (jturner@shield-legal.com)
2025-04-01 14:19:46

*Thread Reply:* More like an overflow. We toyed with the idea of having all partner firms contained in one row as a string but went with this for simplicity.

Ahsan (ahsan@shield-legal.com)
2025-04-01 14:28:31

*Thread Reply:*

🤣 deleted-U06C7A8PVLJ
Ahsan (ahsan@shield-legal.com)
2025-04-01 16:36:38

@deleted-U055HQT39PC @deleted-U062D2YJ15Y @deleted-U05496RCQ9M for any meadow campaigns going forward please include the contact card fields onto the intake tab. The new checks in place by SA have been breaking the payloads. We have built code logic now to handle this issue but having those fields populate on the intake tab can help as an added check for us.

Not an immediate priority just whenever we get to it. Please and thank you! You all are the 🐐s

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

Happy Birthday @deleted-U072JS2NHRQ 🎉 🎉

---- From Engineering

:lets_go: deleted-U06C7A8PVLJ
❤️ deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-14 10:33:58

*Thread Reply:* thank you guys! 🙂

Ahsan (ahsan@shield-legal.com)
2025-04-14 16:49:21

@deleted-U05496RCQ9M @deleted-U055HQT39PC lead for faux prod retainer is 711999

Ahsan (ahsan@shield-legal.com)
2025-04-14 16:49:38

@deleted-U05496RCQ9M @deleted-U055HQT39PC lead for faux prod retainer is 711999

deleted-U072JS2NHRQ
2025-04-25 11:10:44

@here just a reminder to please please change your test leads back to Test Lead Dispos as they're affecting the reporting and show up in either the Benchmark, the Operations Dashboard, or both. Thank you!

👍 James Turner, Zekarias Haile
👍:skin_tone_3: Daniel Schussler
👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2025-04-30 16:53:00

@deleted-U072JS2NHRQ & @deleted-U06CVB2MHRN this is the framework for object drop and creation when making dashboards ``-- Drop the flatirons financial table Drop TableProject.dataset.tablename`;

-- rebuild flatirons financial table create table Project.dataset.tablename as ( Query insert here );

-- alter data schema data types alter table 'Project.dataset.tablename' col 1 as xxxx col 2 as xxx.......```

🐐 deleted-U06CVB2MHRN, deleted-U072JS2NHRQ
:laptop_parrot: deleted-U06CVB2MHRN, deleted-U072JS2NHRQ
Ahsan (ahsan@shield-legal.com)
2025-04-30 16:54:45

@deleted-U072JS2NHRQ & @deleted-U06CVB2MHRN this is the framework for object drop and creation when making dashboards ``-- Drop the flatirons financial table Drop TableProject.dataset.tablename`;

-- rebuild flatirons financial table create table Project.dataset.tablename as ( Query insert here );

-- alter data schema data types alter table 'Project.dataset.tablename' col 1 as xxxx col 2 as xxx.......```

Ahsan (ahsan@shield-legal.com)
2025-05-12 12:06:53

@here donuts in the cave for all on behalf of Darrel and I

🙌:skin_tone_3: deleted-U07SBM5MB32
❤️ James Turner
👻 deleted-U04GG7BCZ5M
:thank_you: Malissa
deleted-U05496RCQ9M
2025-05-12 12:07:20

i didn't know ghosts could talk

😂 deleted-U072JS2NHRQ, deleted-U06CVB2MHRN, Malissa, deleted-U06C7A8PVLJ
Malissa (malissa@shield-legal.com)
2025-05-12 12:08:27

*Thread Reply:* you gotta visit the Haunted Museum

🤣 deleted-U05496RCQ9M, Zekarias Haile
Ahsan (ahsan@shield-legal.com)
2025-05-12 12:40:09

*Thread Reply:* As a model minority I understand we are seen and not heard 😆

😭 deleted-U05496RCQ9M, Nicholas McFadden
😯 Malissa
😂 Nicholas McFadden
deleted-U06CVB2MHRN
2025-05-12 12:07:30
doctor-who-wilfred.gif
😂 deleted-U072JS2NHRQ, deleted-U08FJ290LUX, Nicholas McFadden
Malissa (malissa@shield-legal.com)
2025-05-12 12:08:03

WILF 😭

😭 deleted-U06CVB2MHRN
James Turner (jturner@shield-legal.com)
2025-05-12 12:09:45

I'll swing by in a little bit~

deleted-U04GG7BCZ5M
2025-05-12 12:19:39

Thank you Ahsan 🫃

deleted-U06CVB2MHRN
2025-05-12 12:22:54

Thank you @Ahsan

IMG_6406
🙏 Josh Josue
😂 deleted-U072B7ZV4SH
deleted-U06C7A8PVLJ
2025-05-12 13:20:26

rip

😂 deleted-U072JS2NHRQ
deleted-U06C7A8PVLJ
2025-05-12 13:20:41

I think someone called this number and brought @Ahsan back for just for today

Malissa (malissa@shield-legal.com)
2025-05-12 13:21:05

that gif is some uncanny valley @deleted-U06C7A8PVLJ

:eyes_3d: deleted-U06C7A8PVLJ
😂 deleted-U072JS2NHRQ
deleted-U06CVB2MHRN
2025-05-12 13:22:21

I do not claim this negative energy 🙏:skintone3: @deleted-U06C7A8PVLJ

:meow_attention: deleted-U06C7A8PVLJ
😂 Malissa
Mark Maniora (markmaniora@shield-legal.com)
2025-05-27 10:15:47

@Mark Maniora has left the channel

Dwight Thomas (dwight@shield-legal.com)
2025-06-01 03:29:08
Key Links
Greg Owen (gregowen@shield-legal.com)
2025-06-02 10:25:53

@Greg Owen has left the channel

Malissa (malissa@shield-legal.com)
2025-07-17 16:31:17

@Malissa has left the channel