Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-31 23:32:04

@Brian Hirst Do you know if we are using the "Case Id" field in LawRuler for anything?

Brian Hirst (brian@themedialab.agency)
2024-02-01 10:00:51

Which field is CaseID? I'm not seeing it. To answer your question, I don't use it for anything. I'll need to know which field you're talking about for sure to say yes or no.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-01 10:11:49

Ok I think it’s actually hidden from the normal dashboards so that’s good

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-01 10:12:07

We’re looking for a field not being used

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-01 10:16:10

Thanks

Brian Hirst (brian@themedialab.agency)
2024-02-13 15:13:14

If you have a din radio you can use this. Hella easy to install https://www.amazon.com/Touchscreen-Wireless-Multimedia-Navigation-Bluetooth/dp/B0BLH2HLGF/ref=ascdfB0BLH2HLGF/?tag=hyprod-20&linkCode=df0&hvadid=647168045652&hvpos=&hvnetw=g&hvrand=17021171431291719540&hvpone=&hvptwo=&hvqmt=&hvdev=c&hvdvcmdl=&hvlocint=&hvlocphy=9031316&hvtargid=pla-1967566067721&psc=1&mcid=b2e5157b0aa43a64aff4e2daa8516964|https://www.amazon.com/Touchscreen-Wireless-Multimedia-Navigation-Bluetooth/dp/B0BLH[…]pla-1967566067721&psc=1&mcid=b2e5157b0aa43a64aff4e2daa8516964

amazon.com
Amazon.com: Single Din Touchscreen Car Stereo CarPlay Wireless Android Auto, 6.9 Inch Radio Multimedia with GPS Navigation Hands Free Calling WiFi FM SWC USB, Bluetooth Car Audio Receiver : Electronics
Buy Single Din Touchscreen Car Stereo CarPlay Wireless Android Auto, 6.9 Inch Radio Multimedia with GPS Navigation Hands Free Calling WiFi FM SWC USB, Bluetooth Car Audio Receiver: In-Dash Navigation - <a href="http://Amazon.com">Amazon.com</a> ✓ FREE DELIVERY possible on eligible purchases
Original URL: https://www.amazon.com/Touchscreen-Wireless-Multimedia-Navigation-Bluetooth/dp/B0BLH2HLGF/ref=asc_df_B0BLH2HLGF/?tag=hyprod-20&amp;linkCode=df0&amp;hvadid=647168045652&amp;hvpos=&amp;hvnetw=g&amp;hvrand=17021171431291719540&amp;hvpone=&amp;hvptwo=&amp;hvqmt=&amp;hvdev=c&amp;hvdvcmdl=&amp;hvlocint=&amp;hvlocphy=9031316&amp;hvtargid=pla-1967566067721&amp;psc=1&amp;mcid=b2e5157b0aa43a64aff4e2daa8516964
👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-13 15:14:21

I’ll definitely see if this works! Thanks!

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

you cut out

Brian Hirst (brian@themedialab.agency)
2024-03-11 18:58:31

Hey Nick Are you free tomorrow morning? I want to get everything in order for what needs to be done by who. I've got a lot of work ahead of me making all these custom JSONs for each contract so I want to be able to just change them all one more time and not have to go back and do it again

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-11 19:34:31

Yes what time

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

Whatever time you get in and have an hour to jump on with me and James to go through it

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

I'm open til 1 or so

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-11 19:51:52

Let’s do it early. I got a lot on my plate and need to knock this out

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-11 19:52:53

6:30_7:30am PST

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-11 19:54:44

That work? Or a little later?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-11 19:58:30

maybe closer to 6:45_7:45 😂 I'll slack you after I grab my coffee and am on my way.

Brian Hirst (brian@themedialab.agency)
2024-03-11 20:06:28

Sounds good James probably needs to be on part of it too

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-11 20:10:58

I told him

Brian Hirst (brian@themedialab.agency)
2024-03-11 20:14:02

Sounds good! Closer to 730 when I get back from the gym

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-11 20:43:38

Ok sounds good

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-12 13:26:00

shot you a meeting invite

Brian Hirst (brian@themedialab.agency)
2024-03-12 13:55:15

Currently 131 live contracts in LP It has taken about 25 minutes to set up and flip each one from Vici to Connex once I am in a working rhythm and not interrupted. I've done 1/2 but I need to go back and amend all of them with the new fields. So about 12 minutes per contract for the ones that are already made so that's about 12 hours, Then the second half of the new automations at 27 hours of work. Moving forward this will also add ~10 minutes to new contracts.

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-13 11:53:19

FYI never got time with Cam

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-13 11:53:35

When I talk to him I’ll let you know

Brian Hirst (brian@themedialab.agency)
2024-03-13 11:53:49

I wasn’t holding my breathe haha

🤣 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-13 11:54:05

Good don’t lol

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-20 14:37:03

Hey what’s your cell?

Brian Hirst (brian@themedialab.agency)
2024-03-20 15:16:26

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-04-01 17:12:28

Would you be able to hop on a call with the ConnexOne guys and I about the current test and with Zapier?

Brian Hirst (brian@themedialab.agency)
2024-04-01 18:01:49

Hey I’m mobile right now Just got lunch and am at a coffee shop working. Contact Mark Maniora about the zapper testing He got all the necessities

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-04-01 18:02:33

Ok are you free tomorrow morning?

Brian Hirst (brian@themedialab.agency)
2024-04-01 18:28:00

Yep

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-04-01 18:30:27

What time?

Brian Hirst (brian@themedialab.agency)
2024-04-01 18:55:04

As long as we’re done before 11

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-04-01 19:13:04

PST?

Brian Hirst (brian@themedialab.agency)
2024-04-01 19:33:02

Yeah

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-04-01 20:37:29

9am?

Brian Hirst (brian@themedialab.agency)
2024-04-01 20:52:46

Works for me!

Brian Hirst (brian@themedialab.agency)
2024-04-01 20:53:01

Invite Mark Maniora

👍 Nicholas McFadden
Brian Hirst (brian@themedialab.agency)
2024-04-11 13:03:56

We're all on TIP BI Pipeline meeting

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-12-17 12:57:26

Hey try seeing if you have the Shield project now

Brian Hirst (brian@themedialab.agency)
2024-12-17 13:19:29

I can check in a bit I’m in security at the airport

Brian Hirst (brian@themedialab.agency)
2025-01-20 13:33:25

Hey Nick, Ryan told me to tell you we're on

Brian Hirst (brian@themedialab.agency)
2025-02-13 11:34:38

I'm having a brain fart Can you tell me why this query isnt working

SELECT ** FROM tort-intake-professionals.leadspedia_all_contracts.leadspedia_all_contracts WHERE contractnamex LIKE '%Wood%'

Brian Hirst (brian@themedialab.agency)
2025-02-13 11:35:02

Well it works but it is giving me no data

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-13 11:35:04

I did it in the SL project

Brian Hirst (brian@themedialab.agency)
2025-02-13 11:35:27

Shield Legal BI?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-13 11:35:29

I didn’t check the tip

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-13 11:35:31

Ya

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-13 11:36:04

TIP is what everything is running on, isn’t it

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-13 11:36:29

Well in that case I can go back take a look at that one but worst case we shift to the SL project

Brian Hirst (brian@themedialab.agency)
2025-02-13 11:37:22

My apps run off there but the tables are all good.

Ok, so I ran that query in Shield BI and it is missing these 2 contracts

image.png
Brian Hirst (brian@themedialab.agency)
2025-02-13 11:37:42

Maybe more but definitely these 2

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

Ok so interestingly those were the ones that Mal said she was missing yesterday too

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

The only thing I can think of is if any of the IDs are off vertical, buyer, contract, etc. it would potentially drop it because it can't find a match

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

I forced another sync for the TIP project. Currently it is scheduled to update every 6 hours. It says it ran once this morning but running it again just in case

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

When I pull just the contracts report I get only 9 contracts

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-02-13 12:08:55

These are the 9 contracts that it has to merge to

contract_data_df.csv
Brian Hirst (brian@themedialab.agency)
2025-03-03 10:34:53

Do you have a bigquery table for "leads post log" from leadspedia

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 11:30:14

Hey sorry that I am just getting to this but what do you mean by leads post log? Like just a table of all of the leads in LP? If so, then yes.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 11:33:14

If you have access to the SL BQ then its in the leadspedia dataset and you can use either the allleads or allsold_leads tables

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 11:33:28

https://console.cloud.google.com/bigquery?ws=!1m5!1m4!4m3!1sshield-legal-bi!2sleadspedia!3sall_sold_leads

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=!1m5!1m4!4m3!1sshield-legal-bi!2sleadspedia!3sall_sold_leads
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 11:33:40

https://console.cloud.google.com/bigquery?ws=!1m5!1m4!4m3!1sshield-legal-bi!2sleadspedia!3sall_leads

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=!1m5!1m4!4m3!1sshield-legal-bi!2sleadspedia!3sall_leads
Brian Hirst (brian@themedialab.agency)
2025-03-04 11:41:47

It's not sold leads or all leads. It's the "Leads Post Log," specifically I'm looking to match Lead ID from that log with the message token of "lead already exists" to the corresponding lead in "all leads" that have the response of "no match"

Brian Hirst (brian@themedialab.agency)
2025-03-04 11:42:40

In LP if you go Leads>logs>leads posts log you'll find it

Brian Hirst (brian@themedialab.agency)
2025-03-04 11:43:17

Ryan said it would be in a bigquery table

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 11:56:07

Ok I will look for what youre talking about and let you know

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 12:01:22

I am going to put a ticket in with LP to see if they can quickly point me in the right direction

👍 Brian Hirst
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 14:00:33

Hey figured it out and made the this table for it: https://console.cloud.google.com/bigquery?ws=!1m5!1m4!4m3!1sshield-legal-bi!2sleadspedia!3sposts_log

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=!1m5!1m4!4m3!1sshield-legal-bi!2sleadspedia!3sposts_log
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 14:12:41

@Brian Hirst can you check the data that I pulled vs what you expect there to be? It oddly pulled exactly 247 records for each month which seems unlikely for it to be exactly the same and that low

👀 Brian Hirst
Brian Hirst (brian@themedialab.agency)
2025-03-04 14:30:09

Thanks!

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 14:36:27

Hey I figured out it was just an issue with the code

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 14:36:59

I thought there would be more than 1k records so it was pulling the same set everytime

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 14:38:24

its fixed and has the 265 records that are showing in LP

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 14:41:54

please review the table now and let me know if this is what you needed

Brian Hirst (brian@themedialab.agency)
2025-03-04 14:43:55

I’m not sure if it’s what I need yet. I still trying to figure out how I’m going to try and solve this

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 14:52:29

shit hold on

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 14:55:33

this endpoint seems to be different than all the others. You can only pull by DAY so if we want the logs since 2019 I have to iterate through everyday plus paginate if over 1K.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 15:02:35

I will update the function to at least pull everyday rn for you to test with but we will have to make some new code to handle this

Brian Hirst (brian@themedialab.agency)
2025-03-04 15:29:06

From now forward should be good

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-04 15:30:45

Well right now it will update and then drop it every day until we can get it fixed or I can just leave it as a specific day and then I can manually update/change the date when you need in the meantime

:the_horns: Brian Hirst
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-05 13:36:15

Hey I worked on the code and I am pulling in everything since the beginning of LP. Have to iterate through every day since 6-1-2019 so it is going to take a minute for it to pull everything in.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-05 13:40:32

Once I have done that I will switch it to just adding each day but it will try to do it every hour by appending the new information. I will then need to build in a deduplication of some sort to remove the multiple iterations for the day. I have added a load_timestamp column so in the interim your SQL query will need to deduplicate off of the latest value in that day.

Brian Hirst (brian@themedialab.agency)
2025-03-05 13:43:07

It just needs to be moving forward Not historic

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-05 14:04:04

Lol well too bad you have everything now

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-05 14:04:28

We can now work on the daily update portion

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-05 14:06:37

how often will you have to do this match up? What is it for exactly? The reason I ask is if I were to make a script that at 12:01 deletes all but the latest record for that day will that be okay? During the day you will have to dedup it yourself but it will be clean the next day.

Brian Hirst (brian@themedialab.agency)
2025-03-05 14:22:54

Hahahaha So some leads are “no match” in LP bc they are dupes in LR “Duplicate” is reserved for LP duplicates only

Brian Hirst (brian@themedialab.agency)
2025-03-05 14:23:14

Cam doesn’t like that

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-03-05 14:38:44

Ok will have to include the de-duping on the pull from LP each time it pulls. This is something we have been needing to do anyways but can be tricky to implement. I will start working on it now though and you have at least everything up to this point now. If you need an update I can try to do it manually

Brian Hirst (brian@themedialab.agency)
2025-03-05 14:39:09

Don’t worry about it

👍 Nicholas McFadden
Brian Hirst (brian@themedialab.agency)
2025-06-02 10:30:54

Hey Nick, you have 15 minutes? Something with these postings is making 0 sense and I cannot find where the issue starts\

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

Hey just sitting down to this

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

ya lets hop on a quick gmeet

Brian Hirst (brian@themedialab.agency)
2025-06-02 10:51:42

meet.google.com/nfg-ngos-oyj

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-02 15:00:25

what was one of the ones we did not have a slack for?

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

I got access to that email account

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

I want to see if they are in this mailbox

Brian Hirst (brian@themedialab.agency)
2025-06-02 15:01:06

DL - FL - 439 - 1665 - Tracy Robinson - S1:PL-FacebookMB-MLChowchillaFORMai6 DL - FL - 439 - 1665 - Amorette Becker - S1:PL-FacebookMB-MLFORM240811 DL - FL - 439 - 1665 - Kori Butler - S1:PL-FacebookMB-MLChowchillaFORMai6 DL - FL - 439 - 1665 - Tierra Tittle - S1:PL-FacebookMB-MLChowchillaFORM2009AI2 DL - FL - 439 - 1665 - Rashanda Dawkins - S1:PL-GoogleMB-CRCMP-ChowchillaADG-search

Brian Hirst (brian@themedialab.agency)
2025-06-02 15:01:20

All these are Chowchilla's

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

Tracy Robinson has an email from 9am

Brian Hirst (brian@themedialab.agency)
2025-06-02 15:03:34
image.png
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-03 13:36:55

Hey for the media buyer spend are they going to be entering in the spend individually or as an aggregate. For example, if Maximus spends $100 at 10am and then another $100 at noon does he put $200 in the second entry or each time he just puts $100?

Brian Hirst (brian@themedialab.agency)
2025-06-03 13:45:10

One entry for one day for now. Spend is not updated enough in the platform for a media buyer to accurately say what his spend is hour to hour.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-03 15:31:34

Ok thanks

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-03 15:31:47

So I got access to that email account

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-03 15:32:17

i get the Final emails but not all of the slack related ones

Brian Hirst (brian@themedialab.agency)
2025-06-03 15:45:38

Ok Same as mine then sounds like

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-03 15:47:58

Ya so there is an email that just has the LP ID that seems to be the trigger for the slack info

Brian Hirst (brian@themedialab.agency)
2025-06-12 12:02:36

Hey, you got a sec? having an issue with not all verticals being in bigquery

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-12 12:15:16

11:30ish maybe?

Brian Hirst (brian@themedialab.agency)
2025-06-12 12:16:03

Did you make the verticals table in the SL BigQuery database?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-12 12:16:18

I don’t think so

Brian Hirst (brian@themedialab.agency)
2025-06-12 12:16:38

Ok, nvm then. Do you know who did?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-12 12:32:18

Which veritic table? Which project?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-12 12:34:20

Ok are you talking about verticals in Leadspedia on SL?

Brian Hirst (brian@themedialab.agency)
2025-06-12 12:34:39

Yeah

Brian Hirst (brian@themedialab.agency)
2025-06-12 12:34:41

Sorry

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-17 12:45:36

Hey wanted to check in

Brian Hirst (brian@themedialab.agency)
2025-06-17 12:49:20

Sure, what with

Brian Hirst (brian@themedialab.agency)
2025-06-17 12:49:44

I'm on with James RN making this spend app media buyer proof

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

Last we spoke was about the verticals

Brian Hirst (brian@themedialab.agency)
2025-06-17 12:50:40

Verticals are updated

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-17 12:52:12

Ok good

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-17 12:52:39

Happy to hop on the call to understand what is being done

Brian Hirst (brian@themedialab.agency)
2025-06-17 12:53:04

Media Spend app works great, I've been using it manually to populate spend data daily. Going to meet witht he media buyer to show how to use and upsert

Brian Hirst (brian@themedialab.agency)
2025-06-17 12:56:09

Want to look at the app?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-06-17 12:58:03

Ya sure and if you can show me the data that is getting pushed to GCP

Brian Hirst (brian@themedialab.agency)
2025-06-17 12:59:42

Jump on the meeting I just sent and I'll give you a quick ruhn through. James is helping me get through a block but I can show you how it works real quick

👍 Nicholas McFadden
Brian Hirst (brian@themedialab.agency)
2025-08-27 12:45:50

Hey Nick, you have 3 minutes? I have a question about how you were mapping and a potential oversight we can implement a best practices on before it turns into something manual

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-08-27 12:56:29

can you meet a lttile later today?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-08-27 12:56:38

1:30ish?

Brian Hirst (brian@themedialab.agency)
2025-08-27 13:06:56

Yeah, but I could probably communicate through here too. Anyways, there's a new vertical in LP but it is going to a campaign with a different name in LR. This lead under this vertical in LP is going to LR under this casetype

image.png
image.png
Brian Hirst (brian@themedialab.agency)
2025-08-27 13:07:37

This is something we are trying to move away from

Brian Hirst (brian@themedialab.agency)
2025-08-27 13:08:52

Would it be best to have the LP vertical name in the LR casetypes for more continuity?