Slack Export

thank you!! also, i have a meeting with Brittany and the new analysts at 3:30 and i think they wanted to ask about what you needed for the vici dial report. is the report okay the way it is or do you want/need changes? if it needs to be changed i would love to have you on that call but if it's good the way it is then i don't think it'll be necessary

Luke Fontaine (luke@shield-legal.com)

2024-01-18 12:56:34

Here's the W9 back, let me know if I missed anything

Debbie (debora@shield-legal.com)

2024-01-18 12:57:52

you need to check a box in section 3 please. i know the answer but legally i can’t fill it out for you lol

Luke Fontaine (luke@shield-legal.com)

2024-01-18 12:58:35

oh whos the new analyst? I think the report is fine the way it is, I'd just say that sometimes on the rows for signed contract talk time and transferred talk time that they tend to flip the order in where they post the numbers, but if the could be more consistent with doing it the same way

Debbie (debora@shield-legal.com)

2024-01-18 12:59:36

it’s edward and bethany? those new people you know about already

Luke Fontaine (luke@shield-legal.com)

2024-01-18 13:00:25

oh whoops, here it is with that checked

Luke Fontaine W9.pdf

🙏:skin_tone_4: Debbie

Luke Fontaine (luke@shield-legal.com)

2024-01-18 13:00:45

oh got you, thought you meant they hired another new analyst

Debbie (debora@shield-legal.com)

2024-01-18 13:04:12

thanks boo

Debbie (debora@shield-legal.com)

2024-01-18 13:05:29

no, i guess they had a few questions? but then they were asking me about the vici dial report. i let brittany know for that, it's a you question but i would ask you if you thought it was necessary

Debbie (debora@shield-legal.com)

2024-01-19 14:05:38

can you send me your personal email so you can get your 1099 via email and paper? or will you just wait for the paper copy?

Luke Fontaine (luke@shield-legal.com)

2024-01-19 14:05:57

Yeah absolutely! Fontainelj@gmail.com

Luke Fontaine (luke@shield-legal.com)

2024-01-19 14:06:06

Do you need anything for my W2?

Debbie (debora@shield-legal.com)

2024-01-19 14:06:17

nope that'll all be automated

Debbie (debora@shield-legal.com)

2024-01-19 14:06:26

you should be able to get that in ADP

Debbie (debora@shield-legal.com)

2024-01-25 12:34:26

this is a group chat with andy and cam

image.png

Debbie (debora@shield-legal.com)

2024-01-25 12:35:13

this is the context for that

image.png

Debbie (debora@shield-legal.com)

2024-01-29 15:08:44

https://docs.google.com/spreadsheets/d/1IicRZnlTMxaDiJsohBkuSCHqAex_dItH/edit#gid=1889760048

👏:skin_tone_4: Debbie

Luke Fontaine (luke@shield-legal.com)

2024-01-29 17:10:55

I just have to share this with you because I'm so proud of myself that I was able to create this entire script from scratch. It was for sure a pain getting there but I did dis SELECT signed_date, current_assignee, SUM(CASE WHEN POSITION('Paraquat - Dicello Filing Project' IN type_of_case)>0 THEN 1 ELSE 0 END) AS ParaquatCasefileInterview, SUM(CASE WHEN POSITION('Camp Lejeune Intake - Dicello - Form 95 2024' IN type_of_case)>0 THEN 1 ELSE 0 END) AS CLJForm95, --SUM(CASE WHEN POSITION('Intuit' IN type_of_case WHERE 'FINAL' IN current_status)>0 THEN 1 ELSE 0 END) AS IntuitFinal, SUM(CASE WHEN current_status LIKE '%FINAL%' AND POSITION ('Intuit' IN type_of_case)>0 THEN 1 ELSE 0 END) AS IntuitFinal, SUM(CASE WHEN current_status LIKE '%FINAL%'AND type_of_case NOT LIKE '%Intuit%' AND POSITION('Shield' IN type_of_case)>0 THEN 1 ELSE 0 END) AS NonIntuitFinal, SUM(CASE WHEN POSITION('WIP' IN current_status)>0 THEN 1 ELSE 0 END) AS WIP, SUM(CASE WHEN POSITION('Transfer' IN current_status)>0 THEN 1 ELSE 0 END) AS Transfer FROM public.financial_log --WHERE signed_date BETWEEN '2024-01-01' AND '2024-01-16' WHERE (POSITION('Paraquat - Dicello Filing Project' IN type_of_case)>0 OR POSITION('Camp Lejeune Intake - Dicello - Form 95 2024' IN type_of_case)>0 --OR POSITION('Intuit' IN type_of_case WHERE 'FINAL' IN current_status)>0) OR POSITION('Intuit' IN type_of_case)>0) OR POSITION('Shield' IN type_of_case)>0 OR POSITION('WIP' IN current_status)>0 OR POSITION('Transfer' IN current_status)>0 GROUP BY signed_date, current_assignee ORDER BY signed_date DESC

Debbie (debora@shield-legal.com)

2024-01-29 17:16:46

this looks like a nightmare to me but GOOD JOB! 🥳

Debbie (debora@shield-legal.com)

2024-01-29 17:16:49

does it work

Debbie (debora@shield-legal.com)

2024-01-29 17:16:56

JK 😂

Luke Fontaine (luke@shield-legal.com)

2024-01-29 17:17:04

No 😭 😭 😭

Luke Fontaine (luke@shield-legal.com)

2024-01-29 17:17:27

Hahah yesss it just slide right into that pivot table 😏

Debbie (debora@shield-legal.com)

2024-01-29 17:17:48

hurrayyyyyy i love it when it slides right in

😂 Luke Fontaine

Debbie (debora@shield-legal.com)

2024-01-30 11:52:43

sorry for all the slacks 😅😅

Luke Fontaine (luke@shield-legal.com)

2024-01-30 16:19:23

Do you know who these are/ have their logos? Nigh Goldenberg - IBEX

Debbie (debora@shield-legal.com)

2024-01-30 16:25:41

unfortunately no. i just checked the email i have for ibex but it's not a real domain

Luke Fontaine (luke@shield-legal.com)

2024-01-30 16:26:29

ah ok, what about goldenberg?

Debbie (debora@shield-legal.com)

2024-01-30 16:28:16

no i dont have any info for them. i can google

Debbie (debora@shield-legal.com)

2024-01-30 16:28:40

https://nighgoldenberg.com/

nighgoldenberg.com

Nigh Goldenberg Raso & Vaughn | Best Personal Injury Law Firm

Fight for your rights with NGRV. With 50+ years combined experience, we specialize in personal injury, product liability, and environmental litigation.

Original URL: https://nighgoldenberg.com/

Luke Fontaine (luke@shield-legal.com)

2024-01-30 16:29:00

you are literalllllllllyyy the best!

Debbie (debora@shield-legal.com)

2024-01-30 16:29:56

i know. i'm working on finding the other law firm too for the hair relaxer campaign with ibex

Debbie (debora@shield-legal.com)

2024-01-30 16:30:16

https://levgoldlaw.com/

LevGold Law

Home - LevGold Law

LevGold Law The Gold Standard in Law GET IN TOUCH Schedule a free consultation today! Contact us SOPHISTICATED EXPERTISE LevGold Law LLC, is a law firm based in Washington, D.C. providing legal representation for mass torts and class action cases. CALL US NOW: <tel:(800)998-8048|(800) 998-8048> Here are some of the mass tort cases we handle: […]

Original URL: https://levgoldlaw.com/

Luke Fontaine (luke@shield-legal.com)

2024-01-30 16:31:03

I don't think that's the same one

Debbie (debora@shield-legal.com)

2024-01-30 16:32:34

how do you know

Luke Fontaine (luke@shield-legal.com)

2024-01-30 16:33:25

Women’s intuition

Debbie (debora@shield-legal.com)

2024-01-30 16:35:53

mmmm i think it's wrong this time but i guess we can hold off on that second one

Debbie (debora@shield-legal.com)

2024-01-31 11:02:39

there’s a new data analyst for shield 🙃 contractor

Luke Fontaine (luke@shield-legal.com)

2024-02-01 16:30:49

Do you by chance know who Oakwood is?

Debbie (debora@shield-legal.com)

2024-02-01 16:40:20

Oakwood Legal?

Luke Fontaine (luke@shield-legal.com)

2024-02-01 16:40:39

yes

Debbie (debora@shield-legal.com)

2024-02-01 16:41:03

https://www.oakwoodlegal.com/ we haven't had an invoice with them since last year, so wanted to make sure

Oakwood Legal Group

Home - Oakwood Legal Group

OAKWOOD LEGAL GROUP Oakwood Legal Group, is California’s premier personal injury law firm. Our lawyers are armed with sophisticated legal training from some of the nation’s top law schools, including ...

Original URL: https://www.oakwoodlegal.com/

Luke Fontaine (luke@shield-legal.com)

2024-02-01 16:41:16

Thank you!! youre the best

💁‍♀️:skin_tone_4: Debbie

Debbie (debora@shield-legal.com)

2024-02-01 17:20:59

quit asking for the totals i dont wanna work either

Luke Fontaine (luke@shield-legal.com)

2024-02-01 17:21:13

Haha you’re the one who started it!

Debbie (debora@shield-legal.com)

2024-02-01 17:21:33

just add to whatever the 1st payment was i dont wanna do math

Debbie (debora@shield-legal.com)

2024-02-06 17:01:02

andy should have the answer for campaign total right? he should

Luke Fontaine (luke@shield-legal.com)

2024-02-06 17:01:26

🤷‍♂️:skintone4:

Luke Fontaine (luke@shield-legal.com)

2024-02-06 17:01:38

Honestly I’m trying to stay in my lane more hahaha

Debbie (debora@shield-legal.com)

2024-02-06 17:01:56

yea me too, i don’t get asked stupid questions like campaign totals tf

Debbie (debora@shield-legal.com)

2024-02-06 17:02:04

where did that question come from

Debbie (debora@shield-legal.com)

2024-02-06 17:02:18

who came up with this pvs group chat. i hate it

Debbie (debora@shield-legal.com)

2024-02-07 15:50:35

heyy we just got another 2M from flatirons and they are all for different campaigns. do you want me to list in 1 slack or multiple?

Luke Fontaine (luke@shield-legal.com)

2024-02-07 15:51:28

in one is fine, can you include the campaign totals pleaseee?

🤬 Debbie

Luke Fontaine (luke@shield-legal.com)

2024-02-07 15:51:33

for each

Debbie (debora@shield-legal.com)

2024-02-07 16:04:38

also when you say campaign totals. do you mean how much was paid into the campaign or how much is supposed to be paid into the campaign?

Luke Fontaine (luke@shield-legal.com)

2024-02-07 16:05:09

how much was paid into campaign, total payments received so far

👍:skin_tone_4: Debbie

Debbie (debora@shield-legal.com)

2024-02-07 16:05:43

actually, follow up question. when Altonese sent the last payment received she only put "multiple campaigns". do you know if anyone ever get the breakdown of that?

Debbie (debora@shield-legal.com)

2024-02-08 13:33:25

hey just a quick question for you! when jack sends in his spend like this, these are all for tiktok right?

image.png

Luke Fontaine (luke@shield-legal.com)

2024-02-08 13:33:57

yes that's correct

Debbie (debora@shield-legal.com)

2024-02-08 13:34:09

thank you!

Debbie (debora@shield-legal.com)

2024-02-08 14:18:04

sorry to be harassing you today, i'm working on a project i haven't touched. when media buyers send in their spend, is that number supposed to match the shield financials dashboard, page 14? or is there somewhere else where the spend matches what they sent in?

Luke Fontaine (luke@shield-legal.com)

2024-02-08 14:19:06

I’ll have to check back what that page is but I’ll let you know in about 40 mins or so

Debbie (debora@shield-legal.com)

2024-02-08 14:19:36

no worries, thank you 🙏:skintone4:

Luke Fontaine (luke@shield-legal.com)

2024-02-08 15:14:09

What page was it? can you send me the link to the dashboard you're talking about

Debbie (debora@shield-legal.com)

2024-02-08 15:14:53

https://lookerstudio.google.com/u/0/reporting/71aa809f-9f69-408b-bf87-bcc99d0bec57/page/p_lyys7rnidd

Debbie (debora@shield-legal.com)

2024-02-08 15:15:59

that's page 14 my bad

Luke Fontaine (luke@shield-legal.com)

2024-02-08 15:19:57

No that's not the amount the media buyers spent, it looks like theres an additional fee on top of that spend, maybe their commission? I'll see if I can find the one that shows their exact spend

Luke Fontaine (luke@shield-legal.com)

2024-02-08 15:20:09

I am about to go into a meeting from 1:30-3

Debbie (debora@shield-legal.com)

2024-02-08 15:24:12

okay i thought it was a little higher than their spend. thank you!!

Debbie (debora@shield-legal.com)

2024-02-12 14:31:10

no grounds to fire me right?

image.png

Debbie (debora@shield-legal.com)

2024-02-16 16:25:08

hey boo, just messaged you in a thread for Sokolove. someone didnt double check the payments so i gave you correct campaign total for Birth Injury, 492,250

Luke Fontaine (luke@shield-legal.com)

2024-02-20 14:14:40

Hey Girlie! do you know who this client is? Levinson

Debbie (debora@shield-legal.com)

2024-02-20 14:15:11

i know them as our vendor? let me see if i can find something

Luke Fontaine (luke@shield-legal.com)

2024-02-20 14:16:51

thank you! We just had a couple of campaigns start with them

Debbie (debora@shield-legal.com)

2024-02-20 14:45:49

https://levinsonstocktonllp.com/

levinson stockton llp

Home

Levinson Stockton LLP, Employment Lawyers ready to fight for you. Contact Us today for a free case evaluation, Call <tel:(858)792-1100|(858)792-1100>

Original URL: https://levinsonstocktonllp.com/

Luke Fontaine (luke@shield-legal.com)

2024-02-20 14:46:29

You da best!!

Debbie (debora@shield-legal.com)

2024-02-20 14:46:42

enjoy it while you can!

🥲 Luke Fontaine

Luke Fontaine (luke@shield-legal.com)

2024-03-05 11:29:50

Hey Girl, hope your tuesdays going well.. so I'm sorry to do this to you... but I need to ask for all the totals in the PVS channel 🙈

Debbie (debora@shield-legal.com)

2024-03-05 11:30:07

🥲 🥲 🥲

Debbie (debora@shield-legal.com)

2024-03-05 11:30:35

i’ll get started i guess 😭 want me to post them in here or over there

Luke Fontaine (luke@shield-legal.com)

2024-03-05 11:31:19

ik I really hate to ask, probably over there so they can at least see were doing them

Debbie (debora@shield-legal.com)

2024-03-05 12:46:06

okay i posted the ones i did. go bug my coworker to do hers now lmao

😂 Luke Fontaine

Luke Fontaine (luke@shield-legal.com)

2024-03-05 12:49:55

you the best

❤️ Debbie

Debbie (debora@shield-legal.com)

2024-03-05 12:50:23

good luck 🫡

Debbie (debora@shield-legal.com)

2024-03-06 16:07:57

heyy i have a quick question. cameron says he can't edit a google sheet that he's an editor to. he says it's locked, but on my end it's not locked so idk what he's talking about. do you know off the top of your head what could be happening?

Luke Fontaine (luke@shield-legal.com)

2024-03-06 16:11:55

if he's an editor he should have full access

Debbie (debora@shield-legal.com)

2024-03-06 16:12:30

that's what i told him too. he just says "nope its locked" 🙄

Debbie (debora@shield-legal.com)

2024-03-11 10:22:16

image.png

Debbie (debora@shield-legal.com)

2024-03-11 10:22:21

i'm cringing lmaooo

Luke Fontaine (luke@shield-legal.com)

2024-03-11 10:23:14

hahaha

Debbie (debora@shield-legal.com)

2024-03-11 10:29:27

is Parsa only tiktok?

Luke Fontaine (luke@shield-legal.com)

2024-03-11 10:38:44

yeah theyre only tiktok

👍:skin_tone_4: Debbie

Debbie (debora@shield-legal.com)

2024-03-12 11:42:01

i have to admit. every time you ask me that god forsaken question i want to hurt you

Luke Fontaine (luke@shield-legal.com)

2024-03-12 12:06:12

I cringe everytime I have to ask!

Debbie (debora@shield-legal.com)

2024-03-12 12:06:36

just do math and add on to the last number i gave you!

Debbie (debora@shield-legal.com)

2024-03-12 12:06:45

you have a masters in data that's easy LOL

Luke Fontaine (luke@shield-legal.com)

2024-03-12 12:08:05

haha! you're literally our accountant!

Debbie (debora@shield-legal.com)

2024-03-12 12:10:36

no i'm not, i'm checked out already

Debbie (debora@shield-legal.com)

2024-03-12 12:10:38

just math

Luke Fontaine (luke@shield-legal.com)

2024-03-12 12:11:11

Oh girl you’re not the only one

Debbie (debora@shield-legal.com)

2024-03-12 12:12:01

at least you still have a job! i'm starting to panic a little but not enough to start applying anywhere. maybe next week

Luke Fontaine (luke@shield-legal.com)

2024-03-12 12:15:46

Oh yeah that’s for sure a next week problem

Debbie (debora@shield-legal.com)

2024-03-12 12:17:49

i told myself i would start to look seriously this week but i'm not there yet

Debbie (debora@shield-legal.com)

2024-03-20 18:59:01

image.png

Luke Fontaine (luke@shield-legal.com)

2024-03-20 18:59:48

🙄

Luke Fontaine (luke@shield-legal.com)

2024-03-25 11:13:36

Happy Monday Debbie! Would you be able to send me a ytd report of my 1099 income for 2024?

Debbie (debora@shield-legal.com)

2024-03-25 11:25:24

happy Monday! does this work?

YTD Luke Fontaine.pdf

Luke Fontaine (luke@shield-legal.com)

2024-03-25 11:26:11

This is perfect! Thank you

Debbie (debora@shield-legal.com)

2024-03-25 11:27:41

awesome no problem!

Debbie (debora@shield-legal.com)

2024-04-01 09:49:03

peek a boo

Luke Fontaine (luke@shield-legal.com)

2024-04-01 09:53:25

how?!? I thought you were dead

Debbie (debora@shield-legal.com)

2024-04-01 09:55:29

april fools i’m alive

👻 Luke Fontaine

Debbie (debora@shield-legal.com)

2024-04-01 13:01:14

still going strong in slack

Debbie (debora@shield-legal.com)

2024-04-13 18:37:15

surprise

Debbie (debora@shield-legal.com)

2024-04-15 16:09:43

i’m tempted to react in one of the channels. should i let them know not to tag altonese since she quit 🤣