deleted-U06C7A8PVLJ
2024-11-22 13:18:52

Hi Ryan. I wanted to give you a friendly heads up that I went ahead and texted Joe in order to have PGAdmin installed for my PC so I can start helping with the S1's and declines starting Monday. Once he gets back to me and I have it installed (since from what Aidan told me, we need admin permission to install certain programs which has to go through Joe for that). So once I got that installed I can start helping which I hope he gets back to me about this today.

deleted-U06C7A8PVLJ
2024-11-22 13:19:55

Just wanted to point that out there since I know this is an important task and I am hoping Joe gets back to me about it today since there are times from my experience he doesn't get back to me til a different day

Ryan (ryan@themedialab.agency)
2024-11-22 14:08:08

@deleted-U06C7A8PVLJ, thanks for the follow up and sounds good.

deleted-U06C7A8PVLJ
2024-11-22 14:09:16

You're welcome @Ryan He got back to me thru text and stated he is working on that but seems like he is having issues at the moment and will get back to me later on - update

🙏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2024-11-26 13:44:12

Hi Ryan. I had a question for me getting things set up. I was told someone else had to get an AWS account created for them to use PGAdmin; if that is the case I wanted to know if one has been created already or if that is still in the process so that hopefully when Joe gets back to me everything will be good to go for that

Ryan (ryan@themedialab.agency)
2024-11-26 13:58:21

Once you have your PG Admin, I will get you, your PG Admin POSTGRES database login and password, url, db name, etc. and AWS Accounts. or James Turner will,

Ryan (ryan@themedialab.agency)
2024-11-26 13:59:01

I'll handle those User Adds, Joe handles "client software" like PG Admin.

deleted-U06C7A8PVLJ
2024-11-26 14:00:10

Copy that. Thank you Ryan.

🙏:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2024-12-03 10:54:49

Keep this private, for TIP AWS Lightsail > PostGres DB for PRODUCTION:

db_un: dbmasteruser db_pw: Q`7B2(R8d`;m`n}l%kj2M7q^S&amp;:}1z,F db: tip_master port: 5432 server: <a href="http://ls-ee79dd780a352064468e4dc5bfef3cbc5675526f.cezd6k0feuf4.us-west-2.rds.amazonaws.com">ls-ee79dd780a352064468e4dc5bfef3cbc5675526f.cezd6k0feuf4.us-west-2.rds.amazonaws.com</a>

deleted-U06C7A8PVLJ
2024-12-03 10:56:01

Copy that Ryan

🙏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2024-12-03 11:18:22

Okay aidan showed me how to add that stuff into postgres and looks like I can pull stuff now. He is going to show me how to work on the S1's tomorrow as well (I know you trained me and showed me video but just in case as well)

deleted-U06C7A8PVLJ
2024-12-03 11:19:22

Also Joe texted me to let the team know that when they request assistance from him to text him that they are available. Then when Joe gives the green light to reboot their computer, login and just wait for him to take control of their computer and he will do the rest.

Ryan (ryan@themedialab.agency)
2024-12-03 11:23:13

Sounds good, ty

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Ryan (ryan@themedialab.agency)
2024-12-05 08:11:44

@deleted-U06C7A8PVLJ

edward@tortintakeprofessionals.com_credentials.csv
deleted-U06C7A8PVLJ
2024-12-05 08:13:49

Thank you ! I will run this tomorrow since Aidan was kind enough to run it this morning for me. I will start with S1s and then declines

Ryan (ryan@themedialab.agency)
2024-12-05 08:15:15

Ty

Ryan (ryan@themedialab.agency)
2024-12-05 08:16:09

Got a cool SQL challenge for you that will come up soon if you have 5 minutes for me to show you...

Ryan (ryan@themedialab.agency)
2024-12-05 08:40:47

```-- 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;

-- FIND MISSING S1s in TIP DB SELECT ** FROM public.financiallog WHERE signeddate = CURRENTDATE - INTERVAL '1 day' AND currentstatus LIKE 'Signed e-Sign%' AND (leadsource LIKE 'Shield Legal%' or leadsource LIKE 'No Billing%') ORDER BY typeofcase,last_name ASC;

-- MAKE S1s by Parent Case Type and LP Lead IDs

SELECT signeddate, 'BCL - ML - 491 - 1643' as AltID, firstname, lastname,'S1:'as S1Label, lpleads1,lpleadid,typeofcase,lpcontractid FROM public.financiallog WHERE signeddate = CURRENTDATE - INTERVAL '1 day' AND currentstatus LIKE 'Signed e-Sign%' AND leadsource LIKE 'Shield Legal%' AND (lpleadid = 'Referral' OR lpleadid = 'TV' OR lpleadid LIKE '') ORDER BY typeofcase,lastname,lpcontractscheduledow_price ASC;

-- FIND MISSING S1s in TIP DB SELECT typeofcase, COUNT(typeofcase) as lrcasecount, lpcontractid, lpcontractname, COUNT(lpcontractid) AS lpidcount, CASE WHEN COUNT(typeofcase) = COUNT(lpcontractid) THEN 'True' ELSE 'False' END AS arecountsequal FROM public.financiallog WHERE typeofcase LIKE '%Flatirons%' AND leadsource LIKE 'Shield Legal%' AND signeddate = CURRENTDATE - INTERVAL '1 day' --AND currentstatus LIKE 'Signed e-Sign%' --AND lrcasecount <> lpidcount GROUP BY typeofcase,lpcontractid,lpcontract_name;```

Ryan (ryan@themedialab.agency)
2024-12-05 08:43:40
image.png
deleted-U06C7A8PVLJ
2024-12-06 16:47:02

Hey @Ryan here is the SQL query I came up with let me know if it looks correct or if you have any questions.

```-- Update case names in public.financiallog table UPDATE public.financiallog SET typeofcase = CASE WHEN typeofcase = 'BG - Sex Abuse - Illinois' THEN 'Illinois Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser' WHEN typeofcase = 'DL - Flatirons - Sex Abuse - IL' THEN 'Illinois Juvenile Hall Abuse SEC - DL - Flatirons - Dicello Levitt' WHEN typeofcase = 'BG - Sex Abuse - Michigan' THEN 'Michigan Juvenile Hall Abuse SEC - BG - DL - Flatirons - Bailey Glasser' WHEN typeofcase = 'DL/Flatirons - Sex Abuse - New Hampshire' THEN 'New Hampshire YDC Abuse SEC - DL - Flatirons - Dicello Levitt' WHEN typeofcase = 'BG - Sex Abuse - New Jersey' THEN 'New Jersey Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser' WHEN typeofcase = 'DL - Flatirons - Sex Abuse - NJ' THEN 'New Jersey Juvenile Hall Abuse SEC - DL - Flatirons - Dicello Levitt' WHEN typeofcase = 'BG - Sex Abuse - Pennsylvania' THEN 'Pennsylvania Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser' WHEN typeofcase = 'DL - Flatirons - Sex Abuse - PA' THEN 'Pennsylvania Juvenile Hall Abuse SEC - DL - Flatirons - Dicello Levitt' -- Maryland Juv Hall Abuse Sec will be manually created and duplicated within law ruler to prevent issues with LR lead ID key -- Maryland Juvenile Hall Abuse SEC - BG - DL - Flatirons - Bailey Glasser will be imported into the database with next automated update WHEN typeofcase = 'BG - Sex Abuse - Maryland' THEN 'Maryland Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser' ELSE typeofcase END;

-- Update case names in rawstatustable UPDATE public.rawstatustable SET typeofcase = CASE WHEN typeofcase = 'BG - Sex Abuse - Illinois' THEN 'Illinois Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser' WHEN typeofcase = 'DL - Flatirons - Sex Abuse - IL' THEN 'Illinois Juvenile Hall Abuse SEC - DL - Flatirons - Dicello Levitt' WHEN typeofcase = 'BG - Sex Abuse - Michigan' THEN 'Michigan Juvenile Hall Abuse SEC - BG - DL - Flatirons - Bailey Glasser' WHEN typeofcase = 'DL/Flatirons - Sex Abuse - New Hampshire' THEN 'New Hampshire YDC Abuse SEC - DL - Flatirons - Dicello Levitt' WHEN typeofcase = 'BG - Sex Abuse - New Jersey' THEN 'New Jersey Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser' WHEN typeofcase = 'DL - Flatirons - Sex Abuse - NJ' THEN 'New Jersey Juvenile Hall Abuse SEC - DL - Flatirons - Dicello Levitt' WHEN typeofcase = 'BG - Sex Abuse - Pennsylvania' THEN 'Pennsylvania Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser' WHEN typeofcase = 'DL - Flatirons - Sex Abuse - PA' THEN 'Pennsylvania Juvenile Hall Abuse SEC - DL - Flatirons - Dicello Levitt' -- Maryland Juv Hall Abuse Sec will be manually created and duplicated within law ruler to prevent issues with LR lead ID key -- Maryland Juvenile Hall Abuse SEC - BG - DL - Flatirons - Bailey Glasser will be imported into the database with next automated update WHEN typeofcase = 'BG - Sex Abuse - Maryland' THEN 'Maryland Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser' ELSE typeofcase END;

==================================================================================================================================================```

deleted-U06C7A8PVLJ
2024-12-06 16:53:39

Also after talking to James and Alan about this push to ensure it doesn't affect other individuals & their department, Alan wants to push for this change for Monday since he needs to prepare some leads for those changes which he probably won't be able to get that done til Monday

deleted-U06C7A8PVLJ
2024-12-06 16:54:07

Based on what I am being told by them

Ryan (ryan@themedialab.agency)
2024-12-06 18:15:39

@deleted-U06C7A8PVLJ , can you add the fields parent_casetype, client, co-counsel to those renames? Then we’ll be good to run Monday. Nice work.

The generate financial log lambda ripped the type of case name into four fields. These fields will ensure the dashboard has filters/slicers that makes sense.

deleted-U06C7A8PVLJ
2024-12-06 18:50:07

Copy that. I shall include those and I'll send it to you when I get the chance so you can give me your okay before we run it thru PGAdmin

Ryan (ryan@themedialab.agency)
2024-12-06 19:51:23

Thank you

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2024-12-09 10:05:21

Good morning Ryan. I had a question for the dashboard - is Case Review - Agent Disqualified a status that should be on the dashboard? I ask since pulling up reporting team's monday reports for Cameron we sometimes have that status on there and the previous statuses prior to that are sometimes not a final status. If you need an example here is one: 639207

Ryan (ryan@themedialab.agency)
2024-12-09 10:05:59

Send me Google Meet, we can add filters to remove it.

deleted-U06C7A8PVLJ
2024-12-09 10:06:46

Oh okay when would you like to have that scheduled?

Ryan (ryan@themedialab.agency)
2024-12-09 10:09:47

@deleted-U06C7A8PVLJ send me a google meet now if you are free

Ryan (ryan@themedialab.agency)
2024-12-09 10:09:52

won't take 2 minutes

deleted-U06C7A8PVLJ
2024-12-09 10:10:35

Okay one moment

deleted-U06C7A8PVLJ
2024-12-09 10:12:17

Okay I believe it was sent to ryan@brandlytics.io

Ryan (ryan@themedialab.agency)
2024-12-09 10:13:59

send to ryan@shield-legal.com or just post link here please, I am finishg TIP EOM.

deleted-U06C7A8PVLJ
2024-12-09 10:14:30

Ryan & Edward - Dashboard Monday, December 9 · 8:00 – 9:00am Time zone: America/Los_Angeles Google Meet joining info Video call link: https://meet.google.com/vyu-dvxw-bfn Or dial: ‪(US) ‬ PIN: ‪173 777 296‬# More phone numbers: https://tel.meet/vyu-dvxw-bfn?pin=4913724792982

meet.google.com
Meet
Real-time meetings by Google. Using your browser, share your video, desktop, and presentations with teammates and customers.
Original URL: https://meet.google.com/vyu-dvxw-bfn
meet.google.com
Meet
Real-time meetings by Google. Using your browser, share your video, desktop, and presentations with teammates and customers.
Original URL: https://tel.meet/vyu-dvxw-bfn?pin=4913724792982
Ryan (ryan@themedialab.agency)
2024-12-09 10:33:20

Non-Billable Status SQL

SELECT ** FROM public.financial_log WHERE current_status LIKE 'Signed - Declined - Processed' AND current_status LIKE 'Signed &amp; DECLINED' AND current_status LIKE 'Case Review - Firm Rejected' AND current_status LIKE 'Case Review - Agent Disqualified' AND current_status LIKE 'Case Review - Disqualified' AND current_status LIKE 'Case Review - Firm Declined' AND current_status LIKE '%Contact Attempted%' AND current_status LIKE '%Contacted%' AND current_status LIKE '%Disqualified' AND current_status LIKE '%Billed%' AND current_status LIKE '%Can%t Contact' AND lead_source LIKE '%No Billings%'

Ryan (ryan@themedialab.agency)
2024-12-09 10:33:38

Billable SQL Status

SELECT ** FROM public.financial_log WHERE current_status NOT LIKE 'Signed - Declined - Processed' AND current_status NOT LIKE 'Signed &amp; DECLINED' AND current_status NOT LIKE 'Case Review - Firm Rejected' AND current_status NOT LIKE 'Case Review - Agent Disqualified' AND current_status NOT LIKE 'Case Review - Disqualified' AND current_status NOT LIKE 'Case Review - Firm Declined' AND current_status NOT LIKE '%Contact Attempted%' AND current_status NOT LIKE '%Contacted%' AND current_status NOT LIKE '%Disqualified' AND current_status NOT LIKE '%Billed%' AND current_status NOT LIKE '%Can%t Contact' AND lead_source NOT LIKE '%No Billings%' ORDER by current_status ASC;

deleted-U06C7A8PVLJ
2024-12-23 08:22:29

Good morning @Ryan I wanted to know if you can add me into the chat for this one: So that I can post a Signed & Decline one for this lead ID # 616706

image.png
deleted-U06C7A8PVLJ
2024-12-23 08:25:21

Thank you ! This one I cannot find in the slack channel 🤔 (in the terms of lead 616706)

deleted-U06C7A8PVLJ
2024-12-23 08:26:39

It is within this message

nh-juvenile-abuse_2024-10-25_17:00_PDT.xlsx
deleted-U06C7A8PVLJ
2024-12-23 08:26:48

Do I reply back to it and tag as normal?

Ryan (ryan@themedialab.agency)
2024-12-23 08:30:22

Just post the decline, I guess we forgot to post one?

deleted-U06C7A8PVLJ
2024-12-23 08:30:39

Copy that

deleted-U06C7A8PVLJ
2024-12-24 08:51:10

Good morning Ryan. May you add me to the chat for Michigan Pollution - Ben Crump Law - ELG - Shield Legal so I can post the S1s in there

✅ Ryan
deleted-U06C7A8PVLJ
2024-12-30 14:25:33

Hi Ryan. Happy Mondays. Quick question for your request change for:

NJ Sex Abuse SEC - DL - TC to NJ Juveline Hall Abuse SEC - DL - TC - DiCello Levitt

What specific tables would you like us to change? So that we can write our SQL query correctly if I may ask

Ryan (ryan@themedialab.agency)
2024-12-30 14:29:06

UPDATE public.financial_log

Update the typeofcase, cocounsel, retainercode, parentcasetype in the AWS Postgres table.

deleted-U06C7A8PVLJ
2024-12-30 14:29:18

Thank you @Ryan!

deleted-U06C7A8PVLJ
2024-12-31 10:56:44

Good morning Ryan, Happy tuesdays ! Question. For this change:

NJ Sex Abuse SEC - DL - TC to NJ Juveline Hall Abuse SEC - DL - TC - DiCello Levitt

Shouldn't it just be a name change with typeofcase?

If so wouldn't cocounsel, retainercode, parentcasetype be the same for AWS Postgres Table and we are only changing typeofcase?

deleted-U06C7A8PVLJ
2024-12-31 11:12:00

What we got: UPDATE public.financiallog SET typeofcase = 'NJ Juveline Hall Abuse SEC - DL - TC - DiCello Levitt' WHERE typeof_case = 'NJ Sex Abuse SEC - DL - TC';

Ryan (ryan@themedialab.agency)
2024-12-31 11:20:57

No, cause the python labmada parses typeofcase into those, so that the Pickers in a dashboard will work. lead_source is very important to update

Ryan (ryan@themedialab.agency)
2024-12-31 11:21:27

ypeofcase, cocounsel, retainercode, parentcasetype, lead_source (or whatever the field is called)

deleted-U06C7A8PVLJ
2024-12-31 11:22:26

Copy that. I shall review this with James. Thank you @Ryan

🙏:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2025-01-02 10:53:42

STEP 1, 3, 4, ETC. for TIP Revenue Pricing Update in AWS from TIP BI Ops App (via BigQuery)

EOM_TIP_io_rev_rates_PostGres_REV_UPDATE.sql
Ryan (ryan@themedialab.agency)
2025-01-02 14:22:23
image.png
Ryan (ryan@themedialab.agency)
2025-01-02 14:28:07
  1. Use iorevrates table SQL in BQ to get the results, prices and agent commissions for CRQs, RET, POST (no agent commissions on these FYI): https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1stort-intake-professionals!2sus-central1!3sead4bdc0-cd8b-49c2-b772-252af997b536!2e1
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?ws=!1m7!1m6!12m5!1m3!1stort-intake-professionals!2sus-central1!3sead4bdc0-cd8b-49c2-b772-252af997b536!2e1
Ryan (ryan@themedialab.agency)
2025-01-02 14:29:54
  1. Use whatever tools you want to produce this SQL:
EOM_Dec2024_TIP_Revenue_UpdateSQL_chatgpt.sql
deleted-U06C7A8PVLJ
2025-01-06 09:35:58

Hi Ryan. Happy Monday. I wanted to know if we can push our 10am for a little later such as 10:30am or 11am. I am a bit tied down with a task that I need to complete & I can hop on afterwards. Just want to give a friendly heads up since I know our meeting is in 25 mins

Ryan (ryan@themedialab.agency)
2025-01-06 10:11:41

Hop on when you’re ready

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-01-10 10:04:12

Good morning @Ryan. May I request to be added into this chat for tagging the DQs for S1s please. I think this is the only one I had trouble finding this morning which makes sense

image.png
deleted-U06C7A8PVLJ
2025-01-13 10:08:36

To confirm Ryan for those signed & Declines for their POST retrainer etc you want that to be Signed & DECLINED status in the tipfinanciallog so that they are not billable? Since pre-retainer stuff you already marked as that

Ryan (ryan@themedialab.agency)
2025-01-13 10:09:35

Yes, and then test Ops and Financial dashboards to make sure they don’t come into Looker Studio. We can check this is DBT in our meeting today.

👀 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-01-13 10:10:02

Copy that. That makes sense

🙏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-01-14 09:18:42

Sorry Ryan I thought I marked those as declined will do that shortly when I back from my 10 break

deleted-U06C7A8PVLJ
2025-01-14 09:18:48

@Ryan

Ryan (ryan@themedialab.agency)
2025-01-14 11:06:53

The S1s didn't save either @deleted-U06C7A8PVLJ, please rush to fix, I'm doing numbers late

Ryan (ryan@themedialab.agency)
2025-01-14 11:07:40

Michigan Pollution, ML Facebook please

deleted-U06C7A8PVLJ
2025-01-14 11:07:54

Checking @Ryan

deleted-U06C7A8PVLJ
2025-01-14 11:09:36

From my end the S1s look good. One of them didn't save for some odd reason but I know I did click on the "save" button so not sure if it is pgadmin or myself somehow

Ryan (ryan@themedialab.agency)
2025-01-14 11:09:45

Great

deleted-U06C7A8PVLJ
2025-01-14 11:09:50

Let me know if it shows from your end since S1s looked good to me

deleted-U06C7A8PVLJ
2025-01-14 11:10:06
image.png
Ryan (ryan@themedialab.agency)
2025-02-03 11:06:13

-- Get the rows SELECT ** FROM directorcommissionv2 WHERE revyear >= '2024' ORDER BY revyear, rev_month ASC;

-- Update Row For Quarterly Commissions UPDATE public.directorcommissionv2 SET numesignedcontracts='1669', directorcommissionmonthly='27656', directorcommissionquarterly='1' WHERE revyear = '2024' AND revmonth = '12'

Ryan (ryan@themedialab.agency)
2025-02-04 14:56:42

Hey Edward, excuse my out. I just got overstimulated while trying to brain dump for you guys.

deleted-U06C7A8PVLJ
2025-02-04 15:12:12

Hey @Ryan don't sweat it. I appreciate you reaching out. I have my moments where I am overwhelmed and/or stressed so I get it. It's better to let it out versus to keep it all in

deleted-U06C7A8PVLJ
2025-02-04 15:12:28

But you did answer my question and I was able to add them into the PGadmin public.financial log table so thank you for that

deleted-U06C7A8PVLJ
2025-02-04 15:12:43

I will be posting shortly the ones that I updated / changed into the group chat for your end

Ryan (ryan@themedialab.agency)
2025-02-04 15:16:29

Thanks Ed!

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

You're welcome 🙌

Ryan (ryan@themedialab.agency)
2025-02-06 12:42:06

EOM - POST - Update Prices in Financial_Log (BE CAREFULE, MUST RUN EACH TWICE)

```--GET VSS SELECT ** FROM public.financiallog WHERE signeddate BETWEEN '2025-01-01' AND '2025-01-31' AND typeofcase IN ( 'CA Juvenile Hall Abuse DOCS - ACTS - ACTS - ACTS', 'Chowchilla Womens Prison Abuse VSS - ACTS - ACTS - ACTS', 'Chowchilla Womens Prison Abuse DOCS - ACTS - ACTS - ACTS', 'LA County Foster Care Abuse PFS - ACTS - Levinson - ACTS', 'Illinois Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'Maryland Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'MI Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'New Jersey Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'Pennsylvania Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'NJ Juveline Hall Abuse SEC - DL - TC - DiCello Levitt', 'Arizona Juvenile Detention Center - ML - Secondary Interview', 'Gaming Addiction - Meadow Law - SEC - Meadow Law', 'LA County Foster Care Abuse PFS - Oakwood - Oakwood - Oakwood', 'Chowchilla - Van - Long Form Interview' ) ORDER BY typeofcase ASC;

--UPDATE **RUN TWICE UPDATE public.financiallog SET contractrevenue = CASE WHEN typeofcase = 'CA Juvenile Hall Abuse DOCS - ACTS - ACTS - ACTS' THEN 475 WHEN typeofcase IN ( 'Chowchilla Womens Prison Abuse VSS - ACTS - ACTS - ACTS', 'Chowchilla Womens Prison Abuse DOCS - ACTS - ACTS - ACTS' ) THEN 425 WHEN typeofcase = 'LA County Foster Care Abuse PFS - ACTS - Levinson - ACTS' THEN 475 WHEN typeofcase IN ( 'Illinois Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'Maryland Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'MI Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'New Jersey Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'Pennsylvania Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser' ) THEN 475 WHEN typeofcase = 'NJ Juveline Hall Abuse SEC - DL - TC - DiCello Levitt' THEN 475 WHEN typeofcase = 'Arizona Juvenile Detention Center - ML - Secondary Interview' THEN 475 WHEN typeofcase = 'LA County Foster Care Abuse PFS - Oakwood - Oakwood - Oakwood' THEN 425 WHEN typeofcase = 'Chowchilla - Van - Long Form Interview' THEN 425 ELSE 0 END, agentcommission = 0, talktimeexpense = 0, grossrevenue = contractrevenue + talktimerevenue, netrevenue = contractrevenue + talktimerevenue WHERE signeddate BETWEEN '2025-01-01' AND '2025-01-31' AND typeofcase IN ( 'CA Juvenile Hall Abuse DOCS - ACTS - ACTS - ACTS', 'Chowchilla Womens Prison Abuse VSS - ACTS - ACTS - ACTS', 'Chowchilla Womens Prison Abuse DOCS - ACTS - ACTS - ACTS', 'LA County Foster Care Abuse PFS - ACTS - Levinson - ACTS', 'Illinois Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'Maryland Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'MI Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'New Jersey Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'Pennsylvania Juvenile Hall Abuse SEC - BG - BG - Bailey Glasser', 'NJ Juveline Hall Abuse SEC - DL - TC - DiCello Levitt', 'Arizona Juvenile Detention Center - ML - Secondary Interview', 'Gaming Addiction - Meadow Law - SEC1- Meadow Law', 'Gaming Addiction - Meadow Law - SEC2- Meadow Law', 'Gaming Addiction - Meadow Law - SEC3- Meadow Law', 'LA County Foster Care Abuse PFS - Oakwood - Oakwood - Oakwood', 'Chowchilla - Van - Long Form Interview' );

--UPDATE **RUN TWICE UPDATE public.financiallog SET contractrevenue = CASE WHEN currentstatus = 'VGA 2nd Interview Completed - Tier 1' THEN 150 WHEN currentstatus = 'VGA 2nd Interview Completed - Tier 2' THEN 100 WHEN currentstatus = 'VGA 2nd Interview Completed - Tier 3' THEN 75 ELSE 0 -- Default value in case of missing currentstatus END, agentcommission = 0, talktimeexpense = 0, grossrevenue = contractrevenue + talktimerevenue, netrevenue = contractrevenue + talktimerevenue WHERE typeofcase = 'Gaming Addiction - Meadow Law - SEC - Meadow Law' AND signeddate BETWEEN '2024-12-01' AND '2024-12-31' AND current_status IN ( 'VGA 2nd Interview Completed - Tier 1', 'VGA 2nd Interview Completed - Tier 2', 'VGA 2nd Interview Completed - Tier 3' );```

deleted-U06C7A8PVLJ
2025-02-06 13:16:34

Copy that Ryan. I took good notes and a lot of it is making more sense. I'll think of ways to make it more efficient til we build the SQL stuff in DBT where it does it all for us. Great job on the training as always

🙏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-02-07 09:18:50

Good morning @Ryan. May you add me to this chat:

image.png
deleted-U06C7A8PVLJ
2025-02-07 09:19:19

I don't think I am in this one and if I am must be a name that I am not familiar with lol

Ryan (ryan@themedialab.agency)
2025-02-07 09:27:35

@deleted-U06C7A8PVLJ, send directly to Cam and the MB or post in Call Center to Cam to let him know, we don't have a channel for that that I can find

deleted-U06C7A8PVLJ
2025-02-07 09:28:17

Oh okay I shall post in the call center chat to ask him to create one or that we need one to be created? Sounds about right?

deleted-U06C7A8PVLJ
2025-02-07 11:13:23

Update on my question above:

image.png
deleted-U06C7A8PVLJ
2025-02-07 11:13:41

Which makes me wonder why we have a S1 for it hmm lol

Ryan (ryan@themedialab.agency)
2025-02-07 11:15:51

Not sure, just leave it as is I guess

deleted-U06C7A8PVLJ
2025-02-07 11:22:38

Sounds like a plan

Ryan (ryan@themedialab.agency)
2025-02-07 11:28:46

Transfer from another lead likely

deleted-U06C7A8PVLJ
2025-02-07 11:42:10

Ohhh that would make sense actually

deleted-U06C7A8PVLJ
2025-02-10 10:29:38

548065

deleted-U06C7A8PVLJ
2025-02-10 10:55:22
image.png
deleted-U06C7A8PVLJ
2025-02-10 12:31:37

Hey Ryan. I finished matching Malissa's report with TIP's dashboard to complete the VSS Monthly Completions Scratch report and I was able to add that lead we had issues with by changing to the proper case type. Thanks !

As for the numbers matching, I noticed row 4, 5 and 10 don't match each other since Malissa report is missing those extra leads. The dashboard has them but not her report. I sent those to her and she told me Alan is the one who sends her that report. I had informed Alan in person if he needs those "missing ones" from his report and he told me no. But I am providing this info to you just in case if it is needed from your end

image.png
deleted-U06C7A8PVLJ
2025-02-10 12:32:04

Column J I had included the extra law ruler ID #s that are missing on their report and I sent these to Malissa as well

image.png
deleted-U06C7A8PVLJ
2025-02-10 12:32:09

These are on the dashboard though

Ryan (ryan@themedialab.agency)
2025-02-10 12:32:11

Remove the ones and tell them to mark in LR so they match.

Ryan (ryan@themedialab.agency)
2025-02-10 12:32:31

Simple fix for reconciliation where they must match.

deleted-U06C7A8PVLJ
2025-02-10 12:33:29

Sorry I am not following. They are the current status in Law Ruler as we speak

Ryan (ryan@themedialab.agency)
2025-02-10 12:35:47

They don’t need to add any, then just leave it as is and they don’t have to match.

deleted-U06C7A8PVLJ
2025-02-10 12:35:59

Oh okay perfect I figured that

deleted-U06C7A8PVLJ
2025-02-10 12:36:11

Okay well everything has been added to the dashboard so we should be good to go

🙏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-02-11 15:33:38

Hey Ryan, I wanted to provide you a friendly heads up that I requested 2/17/2025 off (next Monday). I hope this doesn't cause an inconvenience from my end to you for the S1s and declines for that day. I can ask Aidan to cover me if you like that additional support?

Ryan (ryan@themedialab.agency)
2025-02-11 15:47:33

I'll do the S1s, all good. Just send me an OOO reminder in Google Calendar

deleted-U06C7A8PVLJ
2025-02-11 15:47:57

Will do @Ryan. Thank you

Ryan (ryan@themedialab.agency)
2025-02-13 08:10:31

Edward, those are all for Caleb, the Michigan youth

deleted-U06C7A8PVLJ
2025-02-13 08:12:22

I see this in Law Ruler:

image.png
deleted-U06C7A8PVLJ
2025-02-13 08:13:32

I went through all 24 of them (1 of them is a test lead) and I couldn't find a S1

image.png
Ryan (ryan@themedialab.agency)
2025-02-13 08:13:33

Make them HmJack

Ryan (ryan@themedialab.agency)
2025-02-13 08:13:40

JA

Ryan (ryan@themedialab.agency)
2025-02-13 08:13:53

You can look in the daily numbers channel and see who spent on what in the scenario

Ryan (ryan@themedialab.agency)
2025-02-13 08:14:00

#dailynumbers

deleted-U06C7A8PVLJ
2025-02-13 08:14:10
image.png
deleted-U06C7A8PVLJ
2025-02-13 08:15:57

Thank you ! I am not sure what S1 would be for JA; just any one that has JA on there?

Ryan (ryan@themedialab.agency)
2025-02-13 08:16:36

PL-Facebook_MB-JA

deleted-U06C7A8PVLJ
2025-02-13 08:16:48

Thank you

Ryan (ryan@themedialab.agency)
2025-02-14 13:02:06

Also double check all S1s are in place and the contract ids are correct!

deleted-U06C7A8PVLJ
2025-02-14 13:02:42

Sounds good ! Are we changing the partner at all or co-console? I think not right

Ryan (ryan@themedialab.agency)
2025-02-14 13:03:12

Always, it’s get parsed, use yesterdays as the example

deleted-U06C7A8PVLJ
2025-02-14 13:03:53

Copy. I will work on that now and I will send you a screenshot of it just to ensure it looks correct to you as well

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

But seems straightforward

Ryan (ryan@themedialab.agency)
2025-02-14 13:04:15

I trust you, just let me know when done.

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-02-14 13:16:23

If they do have S1s in place already keep them the same regardless of the tier right @Ryan

🙏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-02-14 13:26:25

I believe sobo and his team are figuring out which leads that needs to be regular wood, t1 and t2 and once they are done they are going to provide me those leads which then I can make those updates in the database. I did finish the updates for Malissa end but some are not in the database so I will have to run "Test" and make sure it is a billable status to get them on there. But one last question on this, does the screenshots look correct to you on what they should be?

image.png
image.png
deleted-U06C7A8PVLJ
2025-02-14 13:26:35

I based it off Shield Contracts tab

Ryan (ryan@themedialab.agency)
2025-02-14 13:27:36

Let me know when all complete! It does, thank you.

deleted-U06C7A8PVLJ
2025-02-14 13:30:10

Okay perfect ! Thank you. I will let you know when everything is ready since sobo team is changing it on LR as we speak and once they do that I will update from database from my end

deleted-U06C7A8PVLJ
2025-02-14 15:40:04

@Ryan All completed from my end and also from Sobo's end

deleted-U06C7A8PVLJ
2025-02-14 15:41:02

These three Malissa report: 684575 684682 684708 I can't find them in PGadmin in public.financiallog nor in public.rawstatus_report. Malissa stated these should be Wood Pellet Exposure Injury T2 - Crump - ELG - Shield Legal Otherwise everything has been updated accordantly @Ryan

deleted-U06C7A8PVLJ
2025-02-17 04:00:00

Hey Ryan. I am sending you a friendly heads up I will not be here today since I am on PTO. Have a wonderful day.

☝️:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-02-19 08:13:20

Good Morning Ryan. I wanted to see if there was a delay on receiving the decline report? I usually receive it by 10 mins ago but haven't yet

deleted-U06C7A8PVLJ
2025-02-19 08:13:37

Disregard it just came literally right now lol

deleted-U06C7A8PVLJ
2025-02-19 08:13:42

Wow haha

Ryan (ryan@themedialab.agency)
2025-02-19 08:14:19

@deleted-U06C7A8PVLJ , LR issues. Make sure Ststus Report worked and we have sign ups in DB after you run Gen Log. I had a delayed one on Sunday.

deleted-U06C7A8PVLJ
2025-02-19 08:15:43

Copy that. Looks good to me from my end

image.png
Ryan (ryan@themedialab.agency)
2025-02-19 08:15:54

Ty

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Ryan (ryan@themedialab.agency)
2025-02-27 07:54:26

Wait to start until we meet.

deleted-U06C7A8PVLJ
2025-02-27 07:54:59

Good morning Ryan. Oh okay I will pause doing S1s, etc

deleted-U06C7A8PVLJ
2025-02-27 07:55:31

Are you still in Vegas or head out if I may ask?

Ryan (ryan@themedialab.agency)
2025-02-27 08:07:26

I’m at home

👀 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-02-27 08:07:37

Copy

deleted-U06C7A8PVLJ
2025-02-27 08:07:57

Okay will be ready for it in a hour then

deleted-U06C7A8PVLJ
2025-02-28 08:26:47

Good morning Ryan. Would Michigan Pollution - Ben Crump Law - ELG - Shield Legal be 1667 and Michigan Pollution INJURY - Ben Crump Law - ELG - Shield Legal would be 1687. Want to confirm so that all Michigan Pollution INJURY - Ben Crump Law - ELG - Shield Legal match since some are 1667 and some are 1687

image.png
Ryan (ryan@themedialab.agency)
2025-02-28 08:27:20

Correct

deleted-U06C7A8PVLJ
2025-02-28 08:27:31

Oh okay makes sense. Thank you

Ryan (ryan@themedialab.agency)
2025-02-28 08:27:41

Yw

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Ryan (ryan@themedialab.agency)
2025-03-05 11:10:18

Can you produce the 140 rows into the WHEN statements for contract revenue and the WHEN statements for the agent_commission. We should have 280 rows. give ot me in SQL text file.

deleted-U06C7A8PVLJ
2025-03-05 11:22:31

Must run twice this script above minimum - Note

deleted-U06C7A8PVLJ
2025-03-05 12:36:43

@Ryan Just writing out my steps so I can reference them in the future.

Looking at the BigQuery SQL query, I see that it returns 76 case types (as shown in my screenshot). Meanwhile, the PGAdmin query shows 140 case types.

From what I understand, the goal here is to compare the two: If all 76 case types from BigQuery are different from those in PGAdmin, we only update those specific 76 values—specifically for contract revenue and agent commission—while keeping the rest of the 140 case types unchanged.

Basically, we retain all 140 case types from the PGAdmin query, but if any of the 76 from BigQuery have different values, we update them accordingly. Does that sound right?

image.png
image.png
Ryan (ryan@themedialab.agency)
2025-03-05 12:37:25

Call my cell phone, I’m driving. 858–2 89–7818.

deleted-U06C7A8PVLJ
2025-03-05 12:37:33

Sounds good. I shall call you shortly

deleted-U06C7A8PVLJ
2025-03-05 16:19:50

I had ran the SQL query that we discussed today in training exactly twice. I made sure both had the same amount of case types and I took the values from BigQuery and inserted into my PGAdmin query. I made sure the dates are from feb 1 to feb 28th. I also included a "return" statement at the end of the query just so I can see which rows were affected. Otherwise it is the same query but with different contract revenue values and agent commission values. Sending you the exact same query for your reference as well @Ryan

EOM_TIP_02_ActiveCaseTypes_Revenue_ChatGPT_UPDATE_query - Step 2.sql
deleted-U06C7A8PVLJ
2025-03-05 16:19:56

I shall let Zek know that I finished my part

deleted-U06C7A8PVLJ
2025-03-05 20:01:21

Hey @Ryan ,

I have an idea to help track what’s changing. In the morning, once I finish my S1s and everything matches, I can generate a SQL query that gives us all the law ruler ID numbers, case types, and values for wood pellet.

If you know how to get that into an .xlsx file in pgAdmin, that would be great—but if not, I can probably just copy it from pgAdmin and paste it into an .xlsx file.

Later in the day, if there’s a mismatch, I can rerun the query and use a script to compare the two files, generating an output that shows the differences—like which IDs were added, removed, or modified in any way.

Let me know what you think and/or if we should add anything else to that script!

deleted-U06C7A8PVLJ
2025-03-05 20:02:01

Just an idea since if we can put what is correct in the morning into an Excel file and later on it doesn't matches, I can compare the two .xlsx with python

Ryan (ryan@themedialab.agency)
2025-03-05 20:02:04

Perfect, PG admin in the ribbon of buttons in the data set has a download to CSV button

deleted-U06C7A8PVLJ
2025-03-05 20:02:31

Thank you ! Okay I shall look into that tomorrow for us. Have a great evening

👏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-03-06 07:47:32

Good morning @Ryan Permission to work on S1s? I posted the wood pellet count prior to it and I can post it after completing it?

deleted-U06C7A8PVLJ
2025-03-06 07:47:57

Also I was able to take the time last time to create a functional script that will compare both .xlsx and it will tell us the difference

Ryan (ryan@themedialab.agency)
2025-03-06 07:51:30

Did you run generate fun log lambda yet?

deleted-U06C7A8PVLJ
2025-03-06 07:53:39

Not yet just posted it to show. I shall run it right now

Ryan (ryan@themedialab.agency)
2025-03-06 07:55:23

No!

Ryan (ryan@themedialab.agency)
2025-03-06 07:55:26

Wait.

Ryan (ryan@themedialab.agency)
2025-03-06 07:55:39

Standby and let’s review logs first.

deleted-U06C7A8PVLJ
2025-03-06 07:57:05

May I call you?

deleted-U06C7A8PVLJ
2025-03-06 07:57:29

As soon as you said don't run it I was under the assumption it needs to be ran so I ran it 🥹

deleted-U06C7A8PVLJ
2025-03-06 07:57:36

That is prior to your message above

deleted-U06C7A8PVLJ
2025-03-06 07:57:51

I also created the script last time to help us compare the differences !

deleted-U06C7A8PVLJ
2025-03-06 07:57:55

last night **

Ryan (ryan@themedialab.agency)
2025-03-06 09:39:54

Mind adding these two people JUST to TIP Operations datastudio dashboard. Can do later today.

Brittany Barnett (https://themedialaboratory.slack.com/team/U04GZ79CPNG)
<p>@Ryan Hello! I have some new people that just started this week. Would you be able to give them access to the dashboard? <a href="mailto:ngaston@tortintakeprofessionals.com">ngaston@tortintakeprofessionals.com</a> and <a href="mailto:mclark@tortintakeprofessionals.com">mclark@tortintakeprofessionals.com</a> are their email addresses.</p>
Slack Conversation
deleted-U06C7A8PVLJ
2025-03-06 09:41:18

Oh yes the new hires I can

Ryan (ryan@themedialab.agency)
2025-03-06 09:41:26

Ty

👀 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-03-12 17:03:26

Sorry Ryan I need to ask for clarity on something. Once I complete the S1s am I also posting a screenshot of what the dashboard looks like (such as comparing TIP's # with SL #s) so we know what that looks like in the beginning? Zek mentioned to me about posting a table into slack and I am trying to remember if it was that or just the wood pellets

Ryan (ryan@themedialab.agency)
2025-03-12 17:10:18

The quick goal is to get the S ones added back if they’re from Slack prior, you might have to dig into LawRuler. If they’re not old ones that got erased, then you need to allocate the according to their sign date or at least lead created date. Once you’ve got S1 assigned, then can reconcile on the shield side.

deleted-U06C7A8PVLJ
2025-03-12 17:11:43

Ohhh gotcha that makes sense. And how soon do we need this to be resolved? Since may take me half a day up to a full day to get all the S1s for the wood pellet since I think it is around 300ish last time I was doing it. Just because I was going into the slack channel and getting it from there and if not on there then I would dig into law ruler, etc

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

I think the other case types I am hoping they don't have much S1s

Ryan (ryan@themedialab.agency)
2025-03-12 17:19:13

@deleted-U06C7A8PVLJ just worry about the two in #logistics channel for reconciliation for now. You can give yourself a week or two to do old ones.

Ryan (ryan@themedialab.agency)
2025-03-12 17:19:55

And we’d like to be reconciled, so that reports aren’t wrong with dashboards, so let’s take care of the ones we posted in a logistics channel ASAP, please

deleted-U06C7A8PVLJ
2025-03-12 17:21:27

Okay if that is the case tomorrow I shall work on back filling them all for those two case types for the S1s and will update you and zek about it tomorrow since I believe I should be able to complete that by tomorrow depending on how many S1s there are blank

Ryan (ryan@themedialab.agency)
2025-03-12 17:21:42

Perfect

Ryan (ryan@themedialab.agency)
2025-03-12 17:21:45

Let them know

deleted-U06C7A8PVLJ
2025-03-12 17:21:52

Okay sounds good

Ryan (ryan@themedialab.agency)
2025-03-18 14:16:29

Please ensure the 4th <#C056VR4KUMS|maryland-juv-hall-abuse> that was declined as marked declined, cameron counted it.

Cameron Rentch (https://themedialaboratory.slack.com/team/UHMC40W4E)
<p>which one was DQ'd in channel? How do I know which one in <b>#C056VR4KUMS</b> was DQ'd?</p>
Slack Conversation
Ryan (ryan@themedialab.agency)
2025-03-18 14:17:05

From yesterday, 3-17-25, channel has four, dashboard has three.

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

Copy not sure how I missed that one but I will double check next time around. Thank you for letting me know

👏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-03-18 14:41:23

I updated the slack message to reflect it as a DQ

Ryan (ryan@themedialab.agency)
2025-05-07 15:50:53

@deleted-U06C7A8PVLJ you still at office?

Ryan (ryan@themedialab.agency)
2025-05-07 15:51:11

I have a quicker solution for you on agent_commissions updates

deleted-U06C7A8PVLJ
2025-05-07 15:51:21

Hey @Ryan yes I am

deleted-U06C7A8PVLJ
2025-05-07 15:51:25

I am all ears

Ryan (ryan@themedialab.agency)
2025-05-07 15:53:53

https://www.loom.com/share/daa14c63c1bc4760a2a1099ed3944dc7

:eyes_3d: deleted-U06C7A8PVLJ
Ryan (ryan@themedialab.agency)
2025-05-07 15:55:22

Share to James too, but make sure Tony confirms that "yes" category points ** $10 per point is still how they are calculated and have Brian Hirst add it back in the Portal and tell Malissa to continue to add them. Meaning, we are "revertign" to store them at the billable lead level but final commissions will come from iptipmonthly_expenses for the Financials By Day table.

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-05-07 15:56:26

Gotcha that makes sense ! thank you for the share. I shall reach out to them to confirm this info

🙏:skin_tone_4: Ryan
deleted-U06C7A8PVLJ
2025-05-07 16:19:43

Update: I had slack that to Brian and I also met with Malissa who explained it to me (what it should look like when Brian adds it to retool). I see what you are referring to now. I think everything should be good for me. I will complete this tomorrow since today is Ahsan last day (unless he is here Monday which is a maybe) and I am still picking his brain for some of the weekly flatirons financial stuff

deleted-U06C7A8PVLJ
2025-05-07 16:20:12

It is now more clicking in to me how things are working lol

deleted-U06C7A8PVLJ
2025-05-09 20:38:57

Sorry Ryan. I am currently still working on the talk time stuff. Nick M pulled me on the side to work on a flatirons report for Cameron about MD Juv Hall abuse where they need to know by today what are those discrepancies and things are not matching. If I were to work on this tomorrow as well is that fine? And does the secondary talk time affect our #s?

deleted-U06C7A8PVLJ
2025-05-09 20:39:00

@Ryan

deleted-U06C7A8PVLJ
2025-05-09 20:39:21

I finished building the SQL query to get the talk time for it and currently working on that as we speak (to get talk time for blx)

deleted-U06C7A8PVLJ
2025-05-09 20:57:47

Scratch that Ryan. I am getting it done as we speak. I don't want to push this any longer to the side. I'll post into our chat (zek and you and I) once completed

deleted-U06C7A8PVLJ
2025-05-09 21:44:03

Hey Ryan. I shall work on talk time tomorrow because I ran the SQL queries and when I do sum() to add talk time in Excel it is giving me differently talk time #s for the week. Also Nick M is asking me to prepare an email for Cameron for discrepancies for MD Juv hall abuse comparing it with their report and they want that today too. I want to be able to also test out the SQL query I created to ensure it is pulling latest status as well. Sorry Ryan for the delay in this task. I previously had a table and query made to calculate this but looks like someone delete that including I still need time for the secondary as well

deleted-U06C7A8PVLJ
2025-05-09 21:45:12

I prefer to test things with a fresh mind and a solid tested SQL query. I think I may need to try sum() in Google sheets instead of Excel is giving me differently #s everytime

Ryan (ryan@themedialab.agency)
2025-05-09 22:31:31

Sounds good, thanks Edward and don’t fret, thanks for the effort

deleted-U06C7A8PVLJ
2025-05-09 23:40:22

Thank you Ryan ! I appreciate it. Tomorrow is a new day I am ready to conquer this 🙌:skintone2:

😎 Ryan
Ryan (ryan@themedialab.agency)
2025-06-11 13:04:52

hop on this call, more EOM stuff

deleted-U06C7A8PVLJ
2025-06-11 13:05:57

Yes I am on 🙂

deleted-U06C7A8PVLJ
2025-06-11 13:06:05

Just have mic off / listening

Ryan (ryan@themedialab.agency)
2025-06-11 13:29:44

Didn't mean to get on you there. Just be confident and think through your financial routines and you'll know the answers to some of these questions. All good my man.

deleted-U06C7A8PVLJ
2025-06-11 13:31:17

Thank you Ryan & no worries. I am the type to like to confirm things twice (especially if it deals with financials or things that would be harder to revert back) to cover my basis

Ryan (ryan@themedialab.agency)
2025-06-11 13:40:52

I understand.

🙌:skin_tone_2: deleted-U06C7A8PVLJ
Ryan (ryan@themedialab.agency)
2025-06-23 12:59:20

Good morning Edward, do you mind sending me and cameron in a direct message the link to the tip financials spreadsheet, he needs to see the directors commission tap. Thank you.

deleted-U06C7A8PVLJ
2025-06-23 13:00:25

Good morning Ryan. Yes I can

Ryan (ryan@themedialab.agency)
2025-06-23 16:46:11

*Thread Reply:* Thank you

:yourewelcome: deleted-U06C7A8PVLJ
Ryan (ryan@themedialab.agency)
2025-07-08 13:44:37

Can you get Andy access to the looker enterprise flatirons dashboards ASAP and send them the link to the board and then set up some time with him to show him the features and the three dot menu, like schedule delivery so he can demo that

Ryan (ryan@themedialab.agency)
2025-07-08 13:44:52

@deleted-U06C7A8PVLJ , you don’t mind doing it right now, and send him the link. I’d appreciate it. He wants to get comfortable with the platform.

deleted-U06C7A8PVLJ
2025-07-08 13:45:03

Yes that works I can do that now

deleted-U06C7A8PVLJ
2025-07-08 13:46:30

Scratch that I got the answer

deleted-U06C7A8PVLJ
2025-07-08 13:47:21

Access granted. I am going to pop by Andy's office to talk to him so I will also let him know

deleted-U06C7A8PVLJ
2025-07-08 17:41:38

Hey Ryan. Should these two be multiplied by 2 ? For talk time: I am using the spreadsheet that Aidan gave me long time ago to calculate the talk time

image.png
image.png
image.png
image.png
deleted-U06C7A8PVLJ
2025-07-08 17:42:04

I can remove the 2 if needed if we are not multiplying it by 2.

image.png
Ryan (ryan@themedialab.agency)
2025-07-08 18:15:13

Yes

Ryan (ryan@themedialab.agency)
2025-07-08 18:15:39

No, wait only e-signs are dropping TT rev

Ryan (ryan@themedialab.agency)
2025-07-08 18:15:44

Got it?

deleted-U06C7A8PVLJ
2025-07-08 19:32:49

Oh okay. May I check with you tomorrow about it Ryan. I did update the talk time but just want to make sure it is done correctly when I am in front of my PC again

deleted-U06C7A8PVLJ
2025-07-08 19:33:50

Since there is case review, e-sign and secondaries so based on what you are mentioning it would be e-signs removing the multiplication of 2

Ryan (ryan@themedialab.agency)
2025-07-08 22:05:48

That is correct, you don’t need to triple check with me

deleted-U06C7A8PVLJ
2025-07-09 11:40:27

Thank you Ryan

Ryan (ryan@themedialab.agency)
2025-07-14 10:15:02

I had to rerun the GenFinLog lambda 2-3 times this weekend to ensure all e-signs got in there.

Ryan (ryan@themedialab.agency)
2025-07-14 10:15:04

FYI

Ryan (ryan@themedialab.agency)
2025-07-26 06:36:21

@deleted-U06C7A8PVLJ Are you running GenFinLog this morning? It seems to be running twice each time I run it this morning, showing log entries of different active records processing over processed. (eg. 738 / 4802 while seeing 2475 of 4747)

deleted-U06C7A8PVLJ
2025-07-27 22:23:22

@Ryan Hi Ryan. I do not run it during the weekends

🙏:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2025-08-26 14:11:20

@deleted-U06C7A8PVLJ

Ryan (ryan@themedialab.agency)
2025-08-26 14:11:32

Please join LR