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

@deleted-U06C7A8PVLJ, Good Morning. We have a rush request from Andy and Cameron to get our client AWKO a LookerE board setup with dashboard pages for Video Gaming Addiction and LDS. The request came from the client and we need it by Friday. Cloning the Flatirons, changing the Explores to those case types and getting that ready should be easier second time, so let us know you are good on this quick turnaround. Please work with @Zekarias Haile on this, we need at least two of you to get "new client" dashboards built as Andy and Cameron choose who is in line for early rollout.

👍:skin_tone_3: Zekarias Haile
deleted-U06C7A8PVLJ
2025-07-08 10:20:28

Good morning @Ryan Sounds good. Do we know what fields we are wanting to see as the end result ?

Andy Rogers (andy@shield-legal.com)
2025-07-08 10:24:07

@deleted-U06C7A8PVLJ I think I would need to see what is available. How hard is it for me to see something with you and then make some changes if needed?

deleted-U06C7A8PVLJ
2025-07-08 10:48:59

I think for the sake of being able to have it prepared by Friday it may be wiser for us to choose what fields and then from there I can clean / convert them into a format that the database supports then connect and create the visuals for the dashboard.

Would it be fine if I were to send you the intake questions and we can select from there and if we need to add or remove as we go?

Also did the client state what is the overall goal or what they want to see or just mentioned a dashboard in general?

Ryan (ryan@themedialab.agency)
2025-07-08 10:57:43

@deleted-U06C7A8PVLJ, send the Case Type Export Template CSV with all questions here for @Andy Rogers, @Andy Rogers, you can highlight a color to omit them. That way we don't waste time on which of the intake Qs we need. 😎

deleted-U06C7A8PVLJ
2025-07-08 11:00:25

Sounds good. I shall get that prepared ✅

deleted-U06C7A8PVLJ
2025-07-08 11:02:07

Mormon Victim Abuse - AWKO - AWKO - Shield Legal and Gaming Addiction - AWKO - Goldlaw - Shield Legal, Gaming Addiction 2 - AWKO - Bradley Grombacher - Shield Legal and Gaming Addiction 3 - AWKO - Bradley Grombacher - Shield Legal sounds about right or which specific AWKO case types for video gaming addiction?

Andy Rogers (andy@shield-legal.com)
2025-07-08 11:07:36

@deleted-U06C7A8PVLJ So we are all on the same page. THe client has NOT goven me any speicfics. We are trying to close a giant deal and one of the things I am needing to overcome is some of the “snazzy” reporting they get from Intake Desk https://www.intakedesk.com/

So I am going to need to be able to show what we are building and I want to be able to demonstrate how this will help.

Send me an excel or something and I can highlight what I believe we should put on it

@Ryan ^

Intake Desk
deleted-U06C7A8PVLJ
2025-07-08 11:09:46

That makes sense. @Andy Rogers & @Ryan For the case types I mentioned above does that sound about right? Or am I missing one since I want to pull the questions but just want to ensure I am looking at the right case type for VGA / LDS for AWKO

deleted-U06C7A8PVLJ
2025-07-08 11:57:17

Okay here is the intake questions for LDS. I selected both case types which are:

  1. Mormon Victim Abuse OSOL - AWKO - AWKO - Shield Legal
  2. Mormon Victim Abuse - AWKO - AWKO - Shield Legal I am working on getting the VGA ones @Andy Rogers
deleted-U06C7A8PVLJ
2025-07-08 12:20:39

Here are the intake questions for VGA:

  1. Gaming Addiction - AWKO - Goldlaw - Shield Legal
  2. Gaming Addiction - AWKO - Bradley Grombacher (TIP) - Shield Legal There are two other VGA case types (Gaming addiction 2 - AWKO and Gaming addiction 3 - AWKO) which I excluded for now so we have something to work with which are the two above.
deleted-U06C7A8PVLJ
2025-07-08 12:21:10

If we want to work with just one of the mormon ones and one of the gaming addiction ones to start with that may work too @Andy Rogers @Ryan

deleted-U06C7A8PVLJ
2025-07-08 13:54:35

https://shieldlegal.cloud.looker.com/boards/22 @Andy Rogers

☝️:skin_tone_4: Ryan
Ryan (ryan@themedialab.agency)
2025-07-08 14:08:05

Thanks Edward.

:yourewelcome: deleted-U06C7A8PVLJ
Ryan (ryan@themedialab.agency)
2025-07-08 14:08:09

@Andy Rogers

Andy Rogers (andy@shield-legal.com)
2025-07-09 10:21:04

@deleted-U06C7A8PVLJ @deleted-U06F9N9PB2A Good morning Edward. Checking to see where we are with respect to seeing something this morning. @Joe Santana

deleted-U06C7A8PVLJ
2025-07-09 11:36:15

Good morning @Andy Rogers Currently still building the dashboard and will share link today when finished for VGA case type

:fastparrot: Ryan
Ryan (ryan@themedialab.agency)
2025-07-11 09:00:19

@deleted-U06C7A8PVLJ , what’s status on these AWKO dashboards for Andy?

deleted-U06C7A8PVLJ
2025-07-11 10:47:07

@Ryan I shared and created one for him and currently in the process today finishing up another based on a meeting I had with him yesterday

Ryan (ryan@themedialab.agency)
2025-07-11 10:47:52

@deleted-U06C7A8PVLJ , great. I got his sales slides ready, good stuff

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-07-11 15:28:36

@Ryan @Andy Rogers: Update on the dashboard project. I added a new dashboard for VGA. You can view the second dashboard in our board: https://shieldlegal.cloud.looker.com/boards/23 This link will have all the dashboards on there. Currently now working on the Mormon / LDS dashboards which will be complete by today

Ryan (ryan@themedialab.agency)
2025-07-11 15:30:25

@deleted-U06C7A8PVLJ , thank you!

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-07-11 15:30:30

@Andy Rogers Sending you some screenshots of what to click on while looking at the board to be able to view those dashboards. @deleted-U07CRGCBVJA FYI tagging you for visibility

deleted-U07CRGCBVJA
2025-07-11 15:31:32

@deleted-U07CRGCBVJA has joined the conversation

deleted-U06C7A8PVLJ
2025-07-12 02:08:39

Hi @Andy Rogers I've completed the four dashboards for you and wanted to make it easy to access them. You can use the link below to view everything, and I’ll also include a screenshot showing exactly where to click to jump into each dashboard quickly: 👉 https://shieldlegal.cloud.looker.com/boards/23 Please don’t hesitate to reach out if you have any questions or if you’d like me to clarify any of the data. A quick note: The dashboards are currently static due to time constraints and the complexity of building backend automation. However, if you or the client would like these dashboards to automatically update (e.g., daily refresh), I’ll need around 1–2 weeks to build, test, and deploy that automation pipeline properly. I focused on getting you a high-quality deliverable that’s already up to date as of two days ago, so you can see what’s possible. Looking forward to your feedback! @deleted-U07CRGCBVJA @Ryan Tagging you guys for visibility purposes

deleted-U06C7A8PVLJ
2025-07-12 02:10:01

Noticed my screenshot sent twice (same one) but this one is the other one I meant to send

deleted-U07CRGCBVJA
2025-07-12 18:39:26

Fantastic Edward! Apologies for not responding earlier, just left office, we’ll be in touch! Thanks again!

Andy Rogers (andy@shield-legal.com)
2025-07-12 18:49:50

@deleted-U06C7A8PVLJ thank you so much! You killed it

deleted-U06C7A8PVLJ
2025-07-13 00:11:40

You're welcome 🙌 @Andy Rogers @deleted-U07CRGCBVJA & No worries Joe