deleted-U06N28XTLE7
2024-04-24 18:04:10

@Ryan TIP and Shield Dashboard is off by 128:

Ryan (ryan@themedialab.agency)
2024-04-24 18:28:00

Try now

deleted-U06N28XTLE7
2024-04-24 18:28:44

its now off by 1

Ryan (ryan@themedialab.agency)
2024-04-24 18:29:20

That’s fine, just tell me which case hyper off on

Ryan (ryan@themedialab.agency)
2024-04-24 18:29:34

Send a screenshot showing and telling us which one, we’ll get it fixed

deleted-U06N28XTLE7
2024-04-24 18:31:19
Ryan (ryan@themedialab.agency)
2024-04-24 18:31:48

Share it on the logistics channel as normal, will get it reconciled. Thank you.

deleted-U06N28XTLE7
2024-04-24 18:32:34

ok sounds good

Ryan (ryan@themedialab.agency)
2024-04-29 10:46:42

Ask Tony, not sure what those leads source was, from Shield or direct from them

deleted-U06N28XTLE7
2024-07-01 11:08:58

@Ryan Looker Studio is not able to connect to the data set configuration for the TIP Dashboard

Ryan (ryan@themedialab.agency)
2024-07-01 11:09:18

@deleted-U06N28XTLE7, which page do you use?

Ryan (ryan@themedialab.agency)
2024-07-01 11:09:29

Reconciliation?

Ryan (ryan@themedialab.agency)
2024-07-01 11:09:51

It's a Google LookerStudio issue

deleted-U06N28XTLE7
2024-07-01 11:09:51

the billable leads All time

Ryan (ryan@themedialab.agency)
2024-07-01 11:09:54

Ok

Ryan (ryan@themedialab.agency)
2024-07-01 11:12:40

@deleted-U06N28XTLE7, stand by for alternate solution

πŸ‘ deleted-U06N28XTLE7
Ryan (ryan@themedialab.agency)
2024-07-01 11:49:37

@deleted-U06N28XTLE7, LookerStudio is working again, will get you onto Looker Enterprise soon with those two pages.

deleted-U06N28XTLE7
2024-07-15 16:15:35

@Ryan what you did you mean by the following: Tony had sent me more Transferred to PD from Connex One on Friday. do you mean for week to Friday last week or just Friday by itself

Ryan (ryan@themedialab.agency)
2024-07-15 16:17:24

On Thursday Tony sent me an updated June Connex One report that has 1689 hours of PD talk time and your reports showed about 1000 hours. Just have Tony okay your CNX1 report please.

Ryan (ryan@themedialab.agency)
2024-07-15 16:17:25

Ty

deleted-U06N28XTLE7
2024-07-15 16:21:24

The reason why the June reports were off is because once Nick McFadden, David and I got together on Friday we determined there 4 categories of PD talk time that should have been included that I was not told about before Friday, and now I have included those columns today and those were added to the June report that I did for Tony per Nick's request

Ryan (ryan@themedialab.agency)
2024-07-15 17:04:22

@deleted-U06N28XTLE7, got it. Thank for confirming.

deleted-U06N28XTLE7
2024-08-15 18:01:49

@Ryan the shield legal side of the dashboard is off by 95 from yesterday.

Ryan (ryan@themedialab.agency)
2024-08-15 18:13:04

@deleted-U06N28XTLE7 , check now

Ryan (ryan@themedialab.agency)
2024-08-15 18:13:24

It should be only 94 from my reconciliation this morning.

deleted-U06N28XTLE7
2024-08-19 17:36:19

@Ryan The TIP side of the dashboard is over by 12 compared to the shield side:

deleted-U06N28XTLE7
2024-09-04 18:17:42

@Ryan the following lead# 343194 is not in the billable dashboard for the following case type: MD Juv Hall - BG - Meirowitz Wasserberg - Shield Legal Signed e-signed 12/08/23, LR-Status Signed e-signed Final

Ryan (ryan@themedialab.agency)
2024-09-05 11:21:00

*Thread Reply:* This one was fixed

deleted-U06N28XTLE7
2024-09-09 14:24:42

*Thread Reply:* @Ryan this lead#343194 is still not showing up in the billable dashboard

☝️:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2024-09-09 16:22:45

*Thread Reply:* @deleted-U06N28XTLE7, I put a LR Lead ID search box on the page for you, it's there: https://lookerstudio.google.com/reporting/11eba4ad-c936-4627-9e27-16b43f13b22c/page/p_jjec6oa0tc

deleted-U06N28XTLE7
2024-09-09 16:25:15

*Thread Reply:* @Ryan awesome thank you

πŸ™:skin_tone_4: Ryan
deleted-U06N28XTLE7
2024-09-04 18:48:59

@Ryan also the following Lead # 420970 needs to be removed from the billable dashboard as an agent put this into a Signed e-Signed Client Opt Out and there was actually no signed contract for this client, so I fixed LR to reflect that, which is now only Client Opt out. thank you

βœ… Ryan
Ryan (ryan@themedialab.agency)
2024-09-05 11:23:34

*Thread Reply:* @deleted-U06N28XTLE7, done as well, make sure it does not reappear in the dashboard tomorrow please.

Ryan (ryan@themedialab.agency)
2024-09-05 09:42:51

Will do Dennis, thanks

deleted-U06N28XTLE7
2024-09-06 17:42:23

@Ryan the shield dashboard is over by 1 compared to the TIP dashboard.

Ryan (ryan@themedialab.agency)
2024-09-06 17:44:36

@deleted-U06N28XTLE7 , which day and campaign?

deleted-U06N28XTLE7
2024-09-06 17:46:49

It is for September 4th, and the campaign is Firefighting foam-Dicello/Flatirons

πŸ‘:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2024-09-07 08:12:07

*Thread Reply:* It was actually 15 Sextortions that I should have made 14 Gaming Addictions, that was my mistake.

deleted-U06N28XTLE7
2024-09-09 15:57:23

@Ryan also the following lead# 585873 went signed and declined on 9/06/24 and it is in the billable dashboard as signed e-sign Flagged

☝️:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2024-09-09 16:31:24

@deleted-U06N28XTLE7, thank you

deleted-U06N28XTLE7
2024-09-10 17:44:05

@Ryan TIP side is over by 1 from yesterday because there is a test lead in there lead# 577737

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

Fixed

πŸ™Œ deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-09-10 18:27:40

@Ryan the dashboard is still off by 1 on the TIP side

Ryan (ryan@themedialab.agency)
2024-09-10 18:32:29

Fixed again

πŸ™Œ deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-09-10 18:33:03

thank you

πŸ™:skin_tone_4: Ryan
deleted-U06N28XTLE7
2024-09-13 17:22:50

@Ryan the dashboard is off by 2 on the shield legal side:

☝️:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2024-09-14 08:01:04

*Thread Reply:* It was 2 Mark Maniora tests

Ryan (ryan@themedialab.agency)
2024-09-14 08:01:07

*Thread Reply:* fixed

deleted-U06N28XTLE7
2024-09-19 13:22:01

@Ryan The following lead# 517625 for case type CPAP-DL-Flatirons-Shield Legal, this lead was never a signed client in Law Ruler so if you could please remove this from the billable dashboard, the agent back in May looks like put it in the wrong status for being an Intake form, this is regular non-billable Disqualified client in LR.

the following lead# 512639 for case type CPAP-DL-Flatirons-Shield Legal is Signed e-Sign Secondary Interview-Completed on the dashboard but LR status is Signed e-Sign RE-TRIGGERED, so if you could please update the billable dashboard to reflect this as well.

βœ… Ryan
Ryan (ryan@themedialab.agency)
2024-09-19 16:46:43

*Thread Reply:* these were done this morning, then I spent 3 hours doing a full 2024 reconciliation so this is why I want all of the new ones before I do this again.

deleted-U06N28XTLE7
2024-09-19 16:51:18

*Thread Reply:* Ok sounds good

deleted-U06N28XTLE7
2024-09-19 16:33:20

@Ryan the following lead#'s 538121 & 542454 both need to be removed the billable dashboard because these are actually secondary interview case types not the original Intake case type lead numbers.

and lead number 538121 is a secondary interview for : BG - Sex Abuse - Michigan|Secondary Interview - Completed

βœ… Ryan
deleted-U06N28XTLE7
2024-09-19 16:45:27

@Ryan also the following lead# 550120 needs to be moved out the billable dashboard , this case type is actually: BG - Sex Abuse - Maryland|Secondary Interview - Completed

it is in the dashboard currently as MD Juv Hall Abuse - DL - Flatirons - Shield Legal

Ryan (ryan@themedialab.agency)
2024-09-19 16:46:05

@deleted-U06N28XTLE7, send me all of these before I do more fixes of other peoples mistakes. How many will you have in total?

deleted-U06N28XTLE7
2024-09-19 16:50:25

Sorry about that, I didn't catch the last one until afterwards, there isn't anymore as of today

Ryan (ryan@themedialab.agency)
2024-09-19 16:51:38

I'll get these done in the AM when I do declines. Ty.

deleted-U06N28XTLE7
2024-09-19 16:52:56

Sounds good Thank you

deleted-U06N28XTLE7
2024-10-04 17:33:05

@Ryan 10/04/24 Dashboard Reconciliation: TIP and Shield is off by 3, the TIP side shows three more than the shield side:

Ryan (ryan@themedialab.agency)
2024-10-04 18:14:47

It was a mistake made by Mark Maniora on naming contract, I fixed it. He put too many delimiters in and it choped off the (TC) (TIP) portion and so it will not show in the TIP dashboard unless it has the (TIP). :facepalm::skintone_4:

Ryan (ryan@themedialab.agency)
2024-10-04 18:15:03

Give it 15 minutes, it will be fixed.

πŸ‘ deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-10-08 17:43:19

@Ryan 10/08/24 Dashboard Reconciliation: TIP and Shield is off by 1, the TIP side shows one more than the Shield side:

βœ… Ryan
Ryan (ryan@themedialab.agency)
2024-10-08 18:49:12

@deleted-U06N28XTLE7, fixed.

πŸ‘ deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-10-29 16:12:24

@Ryan 10/29/24 Dashboard Reconciliation: TIP and Shield is off by 1, the TIP side shows one more than the Shield side:

Ryan (ryan@themedialab.agency)
2024-10-29 16:13:47

@deleted-U06N28XTLE7, which case and which day?

deleted-U06N28XTLE7
2024-10-29 16:15:52

October 25th and case type: CA Juvenile Hall Abuse - Miller - Kugel - Shield Legal

Ryan (ryan@themedialab.agency)
2024-10-29 16:20:48

Fixed, it was missing the (TIP) call center value

deleted-U06N28XTLE7
2024-10-29 16:21:02

thank you

πŸ™:skin_tone_4: Ryan
deleted-U06N28XTLE7
2024-11-05 16:40:48

@Ryan 11/05/24 Dashboard Reconciliation: TIP and Shield is off by 4, the Shield side shows four more than the TIP side:

deleted-U06N28XTLE7
2024-11-06 16:49:43

@Ryan 11/06/24 Dashboard Reconciliation: TIP and Shield is off by 3, the Shield side shows three more than the TIP side:

The shield side is one over on each of the following days: 11/01, 11/02, and 11/04.

Ryan (ryan@themedialab.agency)
2024-11-06 16:52:14

That because someone forgot to list (TIP) in the Shield name.

πŸ‘ deleted-U06N28XTLE7
Ryan (ryan@themedialab.agency)
2024-11-06 17:28:04

Actually, my DB commit did not go through earlier and 3 of the DECLINES failed to remove from SL. Try now.

πŸ‘ deleted-U06N28XTLE7
Ryan (ryan@themedialab.agency)
2024-11-14 16:35:52

Doing declines in about 10 minutes, Aidan was sick today

πŸ‘ deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-12-09 17:12:54

@Ryan 12/09/24 Dashboard Reconciliation: TIP and Shield is off by 11, the Shield side shows 11 less than the TIP side

deleted-U06N28XTLE7
2024-12-09 17:13:28
Ryan (ryan@themedialab.agency)
2024-12-09 17:54:33

Your dashboard had a broken filter, try again. Fixed

πŸ‘ deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-12-12 16:50:49

@Ryan Hi i was wondering why the following statuses are not showing up in the Billable Leads All Time when I thought these were billable , because when we did reporting on Monday for the weekly reporting these were in there but not showing up now for the cases.

Ryan (ryan@themedialab.agency)
2024-12-12 17:31:58

*Thread Reply:* Let’s discuss in the AM. Edward and I updated the report and filtered those out.

πŸ‘ deleted-U06N28XTLE7
Ryan (ryan@themedialab.agency)
2024-12-12 17:32:12

*Thread Reply:* We have a Case Review page for those tho

πŸ‘ deleted-U06N28XTLE7
deleted-U06N28XTLE7
2024-12-23 18:08:42

@Ryan 650389 this lead went Signed and Declined on 12/20 but is still in the billable dashboard as Signed e-Sign FLAGGED, if you could please remove from the Billable leads all Time side that would be awesome

Ryan (ryan@themedialab.agency)
2024-12-23 18:46:14

Is it in both per the reconcile or just TIP Side ?

deleted-U06N28XTLE7
2024-12-23 18:52:25
deleted-U06N28XTLE7
2024-12-23 18:53:06
Ryan (ryan@themedialab.agency)
2024-12-23 18:55:31

Ask Edward to do first thing when he’s back in, if it messes up SL side let me know

πŸ‘ deleted-U06N28XTLE7
Ryan (ryan@themedialab.agency)
2025-01-15 09:46:35

Dennis, can we push the security kickoff meeting to tomorrow, I’m juggling financial stuff this morning and not gonna be finished in time

deleted-U06N28XTLE7
2025-01-15 09:47:09

No worries, we can definitely do that

Ryan (ryan@themedialab.agency)
2025-01-15 09:47:23

Actually, Friday at 9:30 Pacific time is perfect for me

deleted-U06N28XTLE7
2025-01-15 09:48:29

that works as well, it will give more time for the antibiotics to kick into my system and I won't sound like deaths door on the call LOL 🀣

deleted-U06N28XTLE7
2025-01-15 09:54:39

I updated the meeting on the calendar to reflect friday at 9:30am PST

Ryan (ryan@themedialab.agency)
2025-01-15 09:56:24

Ty

Ryan (ryan@themedialab.agency)
2025-01-17 08:39:10

@deleted-U06N28XTLE7 Dennis, sorry but I JUST got 47 declines for Flatirons to remove from Shield. Lets do our security data meeting on Monday at 9AM please.

deleted-U06N28XTLE7
2025-01-17 08:39:58

Ok, no worries, I totally understand

Ryan (ryan@themedialab.agency)
2025-01-17 08:40:14

Thanks, it was a backlog of old deals we didn't know were getting declined

deleted-U06N28XTLE7
2025-01-17 08:41:24

not a problem, Edward was just telling about why there was so many declines all of a sudden, I changed the calendar event day and time

😎 Ryan