Brian Hirst (brian@themedialab.agency)
2024-01-04 11:01:10

30 seconds

Mike (mike@shield-legal.com)
2024-01-04 11:01:20

kk

Mike (mike@shield-legal.com)
2024-01-08 12:41:33

good morning and happy monday! out of curiosity, what is "SQL bootcamp" and is it something I can sign up for as well lol

Brian Hirst (brian@themedialab.agency)
2024-01-08 12:43:23

It's a collection or references from an old employee here. I know nothing about SQL, but these new projects Ryan has me on necessitates a basic understanding so I'm going to dedicate 4 hours a week to it

Mike (mike@shield-legal.com)
2024-01-08 12:43:24

I mean I know what SQL is and I know what bootcamp is lol.. mainly wondering if it's an internal training thing or some kind of learning platform like udemy

Mike (mike@shield-legal.com)
2024-01-08 12:43:30

ahhh gotcha

Brian Hirst (brian@themedialab.agency)
2024-01-08 12:43:41

More like a study session lol

Mike (mike@shield-legal.com)
2024-01-08 12:43:56

lol gotcha

Mike (mike@shield-legal.com)
2024-01-08 12:44:10

damn I was hoping to get some free training 😄

Mike (mike@shield-legal.com)
2024-01-08 12:44:34

I know sql decently well, but could def use a refresher

Brian Hirst (brian@themedialab.agency)
2024-01-08 12:44:34

I just want the info implanted in my brain lol

Mike (mike@shield-legal.com)
2024-01-08 12:44:41

right on!

Mike (mike@shield-legal.com)
2024-01-08 12:44:57

it's a nice skill to have

Brian Hirst (brian@themedialab.agency)
2024-01-08 12:45:39

I know, I've been avoiding it haha

Mike (mike@shield-legal.com)
2024-01-08 12:48:52

I think you might actually end up liking it once you get the hang of it. for the most part sql is platform/language agnostic and it's very powerful.. plus writing sql statements looks like hacker shit in a movie 🤣

Brian Hirst (brian@themedialab.agency)
2024-01-08 12:53:01

I just need to dive into it

Mike (mike@shield-legal.com)
2024-01-08 12:56:16

if there's anything I can do to help you please don't hesitate to ask

Brian Hirst (brian@themedialab.agency)
2024-01-08 13:02:43

Thanks! I’m sure I will

💯 Mike
Mike (mike@shield-legal.com)
2024-01-15 10:22:28

good morning. I hope you had a great weekend! do you have any idea yet what your availability looks like this week?

Brian Hirst (brian@themedialab.agency)
2024-01-15 10:26:22

Hey Mike, you too! Yeah Today booked up Tuesday 11:30 - 2 Wednesday 8-11 Thurdays 8-11, 12-2, 3-5 Friday all open til 1

Can we get together tomorrow and you can show me FB form integrations?

Mike (mike@shield-legal.com)
2024-01-15 10:28:25

works for me! we've got like 10 api integrations incoming today, so I'm trying to balance the workload between us all

Brian Hirst (brian@themedialab.agency)
2024-01-15 10:41:25

Cool cool! Yeah I have some daily stuff today then a meeting, then a project relating to the meeting today, but the rest of the week is pretty structured,

Mike (mike@shield-legal.com)
2024-01-15 10:41:42

lol I feel that

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:52:28

Good morning Mike Can I hae a couple minutes of your time with a question?

Mike (mike@shield-legal.com)
2024-02-29 09:53:14

of course. what's up?

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:53:47

I need help with a lawruler JSON

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:53:56

I may be overthinking it

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:54:27

Do you have an example of a JSON you use to import things into lawruler?

Mike (mike@shield-legal.com)
2024-02-29 09:55:04

unfortunately I do not.. we only get data out of LR, not put it in

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:55:22

Tony and Brett decided they want a new dialer and I'm tasked with implementing it ASAP of course

Mike (mike@shield-legal.com)
2024-02-29 09:55:40

to replace vicidial or ?

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:55:43

yep

Mike (mike@shield-legal.com)
2024-02-29 09:55:54

I bet that's going to be fun

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:56:11

Which was supposed to be the end all be all dialer

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:56:17

Oh yeah

Mike (mike@shield-legal.com)
2024-02-29 09:56:35

if you have your json payload already I don't mind taking a look at it. not sure how much help I can be, but I definitely don't mind trying

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:57:16

I don't I use a the Leadspedia Module

Brian Hirst (brian@themedialab.agency)
2024-02-29 09:57:59

Wait I had an idea

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:02:23

It didn't work how I wanted it to lol

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:03:30

Basically trying to turn this into a JSON

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:04:50

Actually scratch that one, I can use a simpler one

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:23:49

Ok I have the JSON done and validated. It is not passing though. Could you help me trouble shoot?

Mike (mike@shield-legal.com)
2024-02-29 10:25:45

sorry, I'm on a call with Joe. we had a user account get compromised so we're dealing with the fallout from that

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:26:07

All good

Mike (mike@shield-legal.com)
2024-02-29 10:38:08

can you send me the json payload please?

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:38:35

{ "Key": "Dhh8wb4yuqjkiQ7uTRs9CY6C", "FirstName": "{firstname}", "LastName": "{lastname}", "CellPhone": "{phonehome}", "Email1": "{emailaddress}", "LeadProvider": "{Shiel Legal - Lead Gen}", "Status": "{New Lead}", "Summary": "{LeadID}", "Custom10042": "{S1}", "Custom10043": "{LEV - ELGTCMC - 531 - 1497}", "Custom9108": "{pfasexposure}", "Custom9109": "{diagnosedwithanyofthefollowing}", "Custom9110": "{yearofdiagnosis}", "Custom9111": "{timewhendiagnosed}", "Custom9112": "{havea_lawyer}", "Custom15058": "{comments}", "CaseType": "PFAS - Levinson (TC/MC) - ELG - Shield Legal" }

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:39:06

This is the response Invalid data/parameters please review your post

Mike (mike@shield-legal.com)
2024-02-29 10:39:57

hmm.. the json itself is valid

Mike (mike@shield-legal.com)
2024-02-29 10:41:04

are you posting that to LR, and is that the response LR is giving you?

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:41:10

IDK if the custom fields need to be in an array or not

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:41:20

I was trying to post it to LR from LP

Mike (mike@shield-legal.com)
2024-02-29 10:50:21

this is a long shot, but try to remove the spaces between the keys and values like "Key":"Dhh8wb4yuqjkiQ7uTRs9CY6C"

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:52:30

Same response

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:52:37

I guess I'll email Lawruler

Mike (mike@shield-legal.com)
2024-02-29 10:53:37

damn.. sorry man, I really wanted to be able to help 😕

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:54:02

All good! I was trying to get ahead of what my next task was going to be while I had a sec

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:54:24

Bc this change is going to take me like 40 hours lol

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:54:48

Hopefully they use this dialer for at least a year this time

Mike (mike@shield-legal.com)
2024-02-29 10:54:49

lol I can only imagine man.. definitely don't envy you on this one

Mike (mike@shield-legal.com)
2024-02-29 10:55:20

yea changing platforms like that is or can be a massive project

Mike (mike@shield-legal.com)
2024-02-29 10:55:53

if anything comes up that I can help with on my end just ping me

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:56:10

Will do! Thanks Mike

Mike (mike@shield-legal.com)
2024-02-29 10:56:20

anytime bud!

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:57:08

I will need your help with a leadspedia API project next week though! I keep putting it on the backburner bc it's not a high priority but it still needs to get done sooner or later lol

Mike (mike@shield-legal.com)
2024-02-29 10:58:08

Dwight is leaving tomorrow to go on vacation for a week so I'm going to have to pick up the extra load while he's gone. let's touch base next week and see how everything looks

Brian Hirst (brian@themedialab.agency)
2024-02-29 10:58:22

SOunds good

Mike (mike@shield-legal.com)
2024-02-29 10:59:02

tyvm!

Brian Hirst (brian@themedialab.agency)
2024-03-12 16:49:14

meet.google.com/zwc-crsv-uek

Brian Hirst (brian@themedialab.agency)
2024-03-19 11:19:36

Hey Mike I have some clarifying questions

Mike (mike@shield-legal.com)
2024-03-19 11:19:49

ok shoot

Brian Hirst (brian@themedialab.agency)
2024-03-19 11:21:35

Is "date_received" lead created date?

Brian Hirst (brian@themedialab.agency)
2024-03-19 11:21:50

or when the whole packet was received

Mike (mike@shield-legal.com)
2024-03-19 11:24:33

I believe it's the latter. My Internet just dropped out

Brian Hirst (brian@themedialab.agency)
2024-03-19 11:28:12

Here's a report with all those leads. and the status's. both date received scenarios are in there

Brian Hirst (brian@themedialab.agency)
2024-03-19 11:28:30
BG2-Custom Report-2024-03-19.xlsx
Mike (mike@shield-legal.com)
2024-03-19 12:33:45

sorry about that. I'm on lte for time being. I just need to know the custom merge tags for those 2 fields. they aren't listed in our field map at all

Brian Hirst (brian@themedialab.agency)
2024-03-19 12:55:00

I can’t find them either. That’s weird. I’m trying to use the email automation template to find them but it’s bugging out

Mike (mike@shield-legal.com)
2024-03-19 15:24:01

hey bud. did you ever have any luck tracking down those field names?

Brian Hirst (brian@themedialab.agency)
2024-03-19 15:27:14

I have not I would try "leadcreateddate" "sentesigndate" esignsigneddate"

Or ask Nick Mcfadden

Mike (mike@shield-legal.com)
2024-03-19 15:27:37

awesome. thank you very much!

Brian Hirst (brian@themedialab.agency)
2024-03-21 14:44:11

Can you send me the Zapier PW?

Mike (mike@shield-legal.com)
2024-03-21 14:46:31

b2U$KkbPj/6p@

Brian Hirst (brian@themedialab.agency)
2024-03-21 14:47:24

ty!

Mike (mike@shield-legal.com)
2024-03-21 14:47:32

yessir

Mike (mike@shield-legal.com)
2024-04-11 12:47:14

hey bud. I'm sure you're covered up today, but if you get a few minutes could I talk you into making me a test lead for ACTS Med Mal pleeeease? dwight is out today so I'm on my own, and going in 100 different directions

Brian Hirst (brian@themedialab.agency)
2024-04-11 12:47:44

Surely

Brian Hirst (brian@themedialab.agency)
2024-04-11 12:47:51

in LR?

Mike (mike@shield-legal.com)
2024-04-11 12:47:58

yessir

Mike (mike@shield-legal.com)
2024-04-11 12:48:59

client says everything looks good, but they aren't getting the documents. I think it's due to a setting dwight forgot to set, but it's a royal pain in the ass to test bc they can only be used once and then they dupe out

Brian Hirst (brian@themedialab.agency)
2024-04-11 12:49:34

Ok, I need to remember how to do this. Nothing is set up in LP yet

Brian Hirst (brian@themedialab.agency)
2024-04-11 12:49:39

SO i cant do it that way

Mike (mike@shield-legal.com)
2024-04-11 12:50:00

hahaha that was my problem. dwight's been doing this long enough that I basically forgot how to do it

Brian Hirst (brian@themedialab.agency)
2024-04-11 12:50:07

We only have a leadbuyer contract set up

Mike (mike@shield-legal.com)
2024-04-11 12:51:21

dwight's last test lead was Donovan Calvin Testing 419839. idk if that helps or not, but it should have all the fields and everything

Mike (mike@shield-legal.com)
2024-04-11 12:57:54

I just emailed the client to see if they know which fields SA uses to determine if a lead is a dupe. I'm hoping we can just modify those fields and repost existing leads

Brian Hirst (brian@themedialab.agency)
2024-04-11 13:00:47

Lead # 471577

Mike (mike@shield-legal.com)
2024-04-11 13:01:19

thank you so much! I owe you another one.. add it to my tab lol

Brian Hirst (brian@themedialab.agency)
2024-04-11 13:01:26

hahhaha

Brian Hirst (brian@themedialab.agency)
2024-04-11 13:01:32

wait did you need it esigned too?

Mike (mike@shield-legal.com)
2024-04-11 13:01:56

yea, I need the documents too please sir

Brian Hirst (brian@themedialab.agency)
2024-04-11 13:02:02

ok one sec

Brian Hirst (brian@themedialab.agency)
2024-04-11 13:06:48

We don't have any e-sign docs for them

Brian Hirst (brian@themedialab.agency)
2024-04-11 13:06:57

I can load a dummy one in?

Mike (mike@shield-legal.com)
2024-04-11 13:07:43

do you mean we don't have any docs across the field, or just the test lead?

Brian Hirst (brian@themedialab.agency)
2024-04-11 13:07:56

We don't have a retainer for them,

Mike (mike@shield-legal.com)
2024-04-11 13:08:54

ahh ok.. we might not need it then. the client just told us to go live with it, so I'm just going to turn it on and watch it throughout the day

Mike (mike@shield-legal.com)
2024-04-11 13:09:20

I know we have a couple of other integrations where there are either no documents, or just 1 or 2

Mike (mike@shield-legal.com)
2024-04-11 13:10:05

if a lead is "pre-litigation" would there even be any docs?

Brian Hirst (brian@themedialab.agency)
2024-04-11 13:10:57

Lead # 471577

:the_horns::skin_tone_2: Mike
Brian Hirst (brian@themedialab.agency)
2024-04-11 13:11:39

I just signed an initialed a word doc that said "ACTS Med Mal"

Mike (mike@shield-legal.com)
2024-04-11 13:11:52

awesome. again, thank you so much!

💯 Brian Hirst
Brian Hirst (brian@themedialab.agency)
2024-04-29 15:15:11

Damon is gone from TIP btw. Idk what happened

Brian Hirst (brian@themedialab.agency)
2024-04-29 15:16:39

IDK how I didn't know for so long either

Mike (mike@shield-legal.com)
2024-04-29 15:35:13

yea he's been gone for a few weeks. he apparently told cam one monday morning that he "didn't sign up to be available 24/7" and resigned

Mike (mike@shield-legal.com)
2024-04-29 15:35:43

I mainly know because I had to lock out all of his accounts

Brian Hirst (brian@themedialab.agency)
2024-04-29 15:37:55

Got it. Yeah I was just looking at a channel and I saw "deactivated" next to his name

Mike (mike@shield-legal.com)
2024-04-29 15:38:34

it was unexpected, but I think he had been planning it for a little while

Brian Hirst (brian@themedialab.agency)
2024-04-29 15:39:07

Weird. Was he replaced or was his job just changed. I don't even really know what he did

Mike (mike@shield-legal.com)
2024-04-29 15:39:52

I'm not sure. there have been so many changes in that department lately that idk who does what anymore lol

Brian Hirst (brian@themedialab.agency)
2024-04-29 15:40:38

Fortunately I've been more and more removed from TIP ongoings

Mike (mike@shield-legal.com)
2024-04-29 15:40:55

I kinda picked up on that during that call earlier

Mike (mike@shield-legal.com)
2024-04-29 15:41:13

I'm happy for you (as long as that is what you wanted)

Brian Hirst (brian@themedialab.agency)
2024-04-29 15:42:05

Ryan's thrown me into software development stuff and I'm a little out of my element but nothing I cant figure out I guess

Mike (mike@shield-legal.com)
2024-04-29 15:42:37

I feel that man. if there's anything at all I can do to help you, I owe you a few

Brian Hirst (brian@themedialab.agency)
2024-04-29 15:44:33

I will for a Leeadspedia API project soon! like later this week or next if you're available!

Mike (mike@shield-legal.com)
2024-04-29 15:44:56

just hmu when you're ready!

💯 Brian Hirst
Brian Hirst (brian@themedialab.agency)
2024-05-08 13:36:33

Do you know when the Trusted Form will be on the form leads?

Mike (mike@shield-legal.com)
2024-05-08 13:49:59

going to try to look into tomorrow. I believe the actual integration will have to be done by the MBs

Brian Hirst (brian@themedialab.agency)
2024-05-08 13:50:34

They aren't passing to the other leads either. Only one lead that sold had a trusted form value. TFNG3AOY

Mike (mike@shield-legal.com)
2024-05-08 13:51:35

I have not implemented it anywhere. if it's leads from landing pages then mark and/or latoya handle those

Brian Hirst (brian@themedialab.agency)
2024-05-08 13:51:48

Ok

Brian Hirst (brian@themedialab.agency)
2024-05-08 13:52:07

I'll talk to Mark then.

Brian Hirst (brian@themedialab.agency)
2024-06-13 16:00:40

Can we get in a quick huddle tomorrow so I can get your expertise for something I want to semi automate? Its generating and sending exclusion lists from LP out.

Mike (mike@shield-legal.com)
2024-06-13 16:11:53

of course! I'm not sure how my day is going to look tomorrow, so just ping me and I'll fit it in

Brian Hirst (brian@themedialab.agency)
2024-06-13 16:17:45

I don't have any meetings so I can do whenever

Brian Hirst (brian@themedialab.agency)
2024-07-01 12:30:09

Hey Mike, What's your cell?

Mike (mike@shield-legal.com)
2024-07-01 12:30:29

Mike (mike@shield-legal.com)
2024-07-01 12:35:38

Everything cool?

Brian Hirst (brian@themedialab.agency)
2024-07-01 12:36:03

Yeah, I just didn't have it

Mike (mike@shield-legal.com)
2024-07-01 12:36:22

ahh gotcha

Brian Hirst (brian@themedialab.agency)
2024-08-14 10:36:27

Hey Mike, Can I have some of your time today? I need your assistance with something

Mike (mike@shield-legal.com)
2024-08-14 10:48:18

Hey Brian. what's up?

Brian Hirst (brian@themedialab.agency)
2024-08-14 10:48:42

I needed some help with Leadspedia API

Mike (mike@shield-legal.com)
2024-08-14 10:50:41

such as?

Brian Hirst (brian@themedialab.agency)
2024-08-14 10:51:17

Sending exclusion list emails

Brian Hirst (brian@themedialab.agency)
2024-10-02 13:37:10

Hey Mike, Can we get together tomorrow at 11am your time? I need some help with a leadspedia API project. It's a simple task I've been doing ad hoc for years with no issues but I wanted to see if it was worth automating. I wanted to talk to you about the parameters and if it was even feasible in the application media buyers would use it in.

Mike (mike@shield-legal.com)
2024-10-03 09:59:31

Hey Brian. are you available around 11 your time? my morning is pretty much blocked

Brian Hirst (brian@themedialab.agency)
2024-10-03 10:01:31

I am

Mike (mike@shield-legal.com)
2024-10-03 10:01:57

good deal. do you want to send out invites?

Brian Hirst (brian@themedialab.agency)
2024-10-03 10:05:53

yes indeed. Should be a quick one, I think I have my answer but I wanted you to confirm.

Mike (mike@shield-legal.com)
2024-10-03 10:06:13

sounds good. talk to ya then!

Brian Hirst (brian@themedialab.agency)
2024-10-03 10:06:29

Thanks Mike

💯 Mike
Brian Hirst (brian@themedialab.agency)
2024-10-14 14:14:20

Do you know what happened with Brett Curry? I remember I saw he was gone but didn't hear anything about it.

Mike (mike@shield-legal.com)
2024-10-14 14:53:43

I can't remember man. We process so many user off boarding requests every day that it's hard to keep track of them all

Brian Hirst (brian@themedialab.agency)
2024-10-14 14:54:08

Fair lol