Ryan (ryan@themedialab.agency)
2025-06-02 11:25:03

@Ryan has joined the channel

Cameron Rentch (cameron@internetthings.com)
2025-06-02 11:26:41

@Cameron Rentch has joined the channel

Brian Hirst (brian@themedialab.agency)
2025-06-02 11:26:41

@Brian Hirst has joined the channel

James Turner (jturner@shield-legal.com)
2025-06-02 11:26:41

@James Turner has joined the channel

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 11:26:41

@Nicholas McFadden has joined the channel

Maximus (maximus@internetthings.com)
2025-06-02 11:26:41

@Maximus has joined the channel

Jack A. (jack@crediready.com)
2025-06-02 11:26:42

@Jack A. has joined the channel

Caleb Peters (caleb@shield-legal.com)
2025-06-02 11:26:42

@Caleb Peters has joined the channel

John Ventura (jventura@shield-legal.com)
2025-06-02 11:26:42

@John Ventura has joined the channel

slackbot
2025-06-02 11:26:44

tony from Tort Intake Professionals was added to this channel by ryanvaspra. You can review their permissions in Channel Details. Happy collaborating!

deleted-U04HFGHL4RW
2025-06-02 11:26:44

@deleted-U04HFGHL4RW has joined the channel

Ryan (ryan@themedialab.agency)
2025-06-02 11:27:16

@here Slack Alerts for June 2nd, 2025 through the past hour:

image.png
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 11:27:40

@Ryan I am reviewing with Brian now

Ryan (ryan@themedialab.agency)
2025-06-02 11:27:54

We'll have a link to a dashboard from @James Turner, soon that will update in real time about every 30 minutes with new e-signs.

Ryan (ryan@themedialab.agency)
2025-06-02 11:28:00

Thanks Nick!

James Turner (jturner@shield-legal.com)
2025-06-02 11:40:10

Thus currently shows ALL status changes, but has a filter to only include the ones with e-Sign as the "To-Status"

James Turner (jturner@shield-legal.com)
2025-06-02 11:41:00

At the moment it shows Secondary campaigns as well, but I can tweak it too only show Intake campaigns if you would prefer @Cameron Rentch @Ryan

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 11:42:32

can you give me access?

👍 James Turner
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 11:42:38

@James Turner

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 11:43:19

thanks

James Turner (jturner@shield-legal.com)
2025-06-02 11:43:27

Sent- I also made sure to include the Leadspedia Contract ID when possible

James Turner (jturner@shield-legal.com)
2025-06-02 11:43:49

Sent- I also made sure to include the Leadspedia Contract ID when possible

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 11:46:53

@Ryan so far things seem to be coming over correctly maybe some taking longer to go final. Getting stopped in QA so you will see in slack but not have an email until e-signed final

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 11:49:26

hold up maybe spoke too soon

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 11:49:45

MI Abuse looked clean. Reviewing Chowchilla now

James Turner (jturner@shield-legal.com)
2025-06-02 11:52:24

Let me know if it's only campaigns after 2,053, inspecting something on my end.

Ryan (ryan@themedialab.agency)
2025-06-02 11:57:09

@Cameron Rentch @Maximus @Jack A. @John Ventura @Caleb Peters

MB's your dashboards now have "e-Sign Alerts" page, page 1, that will refresh every 15 to 30 minutes with e-signs for today only. Please use these as we debug why the Slack versions are not working. This data is direct from LawRuler for only e-Signs for Shield for each of you.

@James Turner is creating a single one that will have all of yours in them for @Cameron Rentch, @Yan Ashrapov to monitor all e-signs. He'll put that link here soon. @James Turner, be sure you share it to everyone here.

@Dustin Surwill is speeding up the data refresh from LR to get these to you as FAST AS POSSIBLE.

❤️ Maximus
Yan Ashrapov (yashrapov@shield-legal.com)
2025-06-02 11:57:59

@Yan Ashrapov has joined the channel

Dustin Surwill (dsurwill@shield-legal.com)
2025-06-02 11:57:59

@Dustin Surwill has joined the channel

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 12:01:24

We think there is an issue between Zapier and the LR emails

👍 James Turner
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 12:01:43

Leads are in LP and LR and we have emails just not slack alerts

Yan Ashrapov (yashrapov@shield-legal.com)
2025-06-02 12:04:49

@Ryan thanks for the update. Waiting for the update regarding the link

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 12:05:19

Who has access to the tipcontracts@shield-legal.com email?

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

@Nicholas McFadden that is an alias for devin@shield-legal.com

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

Look in Dev Logins for his UN and PW

James Turner (jturner@shield-legal.com)
2025-06-02 13:01:23

@everyone - I created a new dashboard with the metrics requested by Ryan. Includes basic lead info from Lawruler, and leadspedia for only billable leads.

Note that if a lead is updated and later deemed non-billable, it will not appear here anymore. For that reason, you may see numbers going up and down with time.

I am also in the proccess of getting this on a closer to real time setup, currently it is every hour but that will soon change to every half hour.

https://lookerstudio.google.com/reporting/ed69cf3c-76a6-47d2-a82f-30f684dd5359 Please let me know if permissions are not working for you, and also let me know what of Marcs emails I should be adding. I don't want to spam him if I can avoid it.

👌:skin_tone_4: Yan Ashrapov
Ryan (ryan@themedialab.agency)
2025-06-02 13:06:04

@James Turner , sent his emails to you in email

👍 James Turner
Ryan (ryan@themedialab.agency)
2025-06-02 13:06:25

And thank you for the rush. Let us know as we increase data refresh rate

Maximus (maximus@internetthings.com)
2025-06-02 13:06:36

I can see it

👍 James Turner
👍:skin_tone_4: Ryan
Cameron Rentch (cameron@internetthings.com)
2025-06-03 10:26:38

@James Turner we need a filter to be able to sort by media buyer (in leadspedia field is "CD") and also by "S1". Thank you

👍 James Turner
👍:skin_tone_4: Ryan
James Turner (jturner@shield-legal.com)
2025-06-03 11:48:16

*Thread Reply:* I added the S1 filter, and that's good to go.

Currently investigating how to add the media buyer field to existing billable data.

James Turner (jturner@shield-legal.com)
2025-06-03 12:13:46

*Thread Reply:* Found a method, testing and implementing now.

James Turner (jturner@shield-legal.com)
2025-06-03 12:29:02

@Cameron Rentch I believe this update should serve you, and the media buyer team well! Let me know if you would like to add anything else!

20250603-1725-48.9502537.mp4
Cameron Rentch (cameron@internetthings.com)
2025-06-03 13:07:24

@James Turner can you please add a date filter option for each media buyer

James Turner (jturner@shield-legal.com)
2025-06-03 13:39:27

Happy to say it's already built on there! The filter above Leadspedia S1 is a date selection, where you can select the start and end of the window you are looking for.

Once they select the date window they want, they can compound those filters.

20250603-1838-21.3816544.mp4
Ryan (ryan@themedialab.agency)
2025-06-03 14:08:49

@James Turner , slack reminder to load the billableleadslp into Looker Enterpride explore. Please make sure we crest model file measures and not numerical dimensions.

✅ James Turner
James Turner (jturner@shield-legal.com)
2025-06-03 18:25:58

*Thread Reply:* @Ryan Added as a model, and set up a very basic dashboard only covering specific data points. Please let me know what you think- I can add more fields as Marc needs.

image.png
Ryan (ryan@themedialab.agency)
2025-06-03 18:41:16

*Thread Reply:* I’ll look soon

Ryan (ryan@themedialab.agency)
2025-06-04 10:42:36

*Thread Reply:* Great, I will clone this dashboard, take a closer look at it and give it to Marc.