Zekarias Haile (zhaile@shield-legal.com)
2024-12-09 12:06:36

Good morning @Brian Hirst

Zekarias Haile (zhaile@shield-legal.com)
2024-12-09 12:08:44

Ryan tasked me to work on a dashboard and I'm wondering if you can assist me whenever you are free today. Thanks!

Brian Hirst (brian@themedialab.agency)
2024-12-09 12:10:31

For sure Which program? And how about 12?

Zekarias Haile (zhaile@shield-legal.com)
2024-12-09 12:17:54

TY! It's on Looker.

Zekarias Haile (zhaile@shield-legal.com)
2024-12-09 12:18:33

Can we make it 11:45? to have more time as we have a meeting at 12:30

Brian Hirst (brian@themedialab.agency)
2024-12-09 12:19:23

Yep!

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2024-12-09 12:25:23

Invite sent.

Zekarias Haile (zhaile@shield-legal.com)
2024-12-09 14:05:49

Error ID: 9b40fcf3

Zekarias Haile (zhaile@shield-legal.com)
2024-12-12 13:27:12

Hey @Brian Hirst if you have time today, could you help me go over some stuff please?

Brian Hirst (brian@themedialab.agency)
2024-12-12 13:27:46

Surely. How about 4? And what are we going over

Zekarias Haile (zhaile@shield-legal.com)
2024-12-12 13:30:02

sounds good. Thanks. It's Looker stuff

Brian Hirst (brian@themedialab.agency)
2024-12-12 13:30:22

Enterprise or data studio?

Zekarias Haile (zhaile@shield-legal.com)
2024-12-12 13:30:34

data studio

Brian Hirst (brian@themedialab.agency)
2024-12-12 13:30:40

Ok

👍 Zekarias Haile
Brian Hirst (brian@themedialab.agency)
2024-12-13 10:34:16

Are you ready to hop on for a bit?

Zekarias Haile (zhaile@shield-legal.com)
2024-12-13 10:35:59

yup, let me send you the invite link

Zekarias Haile (zhaile@shield-legal.com)
2024-12-13 10:36:38

To join the video meeting, click this link: https://meet.google.com/avo-qqzh-upi Otherwise, to join by phone, dial and enter this PIN: 845 116 335# To view more phone numbers, click this link: https://tel.meet/avo-qqzh-upi?hs=5

meet.google.com
Meet
Real-time meetings by Google. Using your browser, share your video, desktop, and presentations with teammates and customers.
Original URL: https://tel.meet/avo-qqzh-upi?hs=5
Zekarias Haile (zhaile@shield-legal.com)
2025-02-21 13:25:36

Hey Brian, how is it going?

Brian Hirst (brian@themedialab.agency)
2025-02-21 13:26:44

Good thanks

Zekarias Haile (zhaile@shield-legal.com)
2025-02-21 13:27:18

I was working on creating the media buyer table stuff and Im wondering how are you sending the data to bigquery

Brian Hirst (brian@themedialab.agency)
2025-02-21 13:28:52

Which data?

Zekarias Haile (zhaile@shield-legal.com)
2025-02-21 13:34:11

the data you pushed either from retool or form?

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

Retool and BigQuery are linked via a connection through their respective apps and I use SQL to add to BigQuery from Retool

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-02-24 10:44:01

Good morning, I hope you had a nice weekend.

Zekarias Haile (zhaile@shield-legal.com)
2025-02-24 10:48:54

I was wondering if we are able push some test data to check the table?

Brian Hirst (brian@themedialab.agency)
2025-02-24 11:37:58

Yeah, can we do it after the meeting today?

Zekarias Haile (zhaile@shield-legal.com)
2025-02-24 11:48:07

sounds good

Brian Hirst (brian@themedialab.agency)
2025-02-24 13:59:09

Want to hop on a quick one to run those tests?

Zekarias Haile (zhaile@shield-legal.com)
2025-02-24 14:13:30

ohh im sorry just saw it

Zekarias Haile (zhaile@shield-legal.com)
2025-02-24 14:14:08

can we do it now?

Brian Hirst (brian@themedialab.agency)
2025-02-24 14:18:57

yep!

👍 Zekarias Haile
Brian Hirst (brian@themedialab.agency)
2025-02-24 14:19:19

meet.google.com/crq-frxx-zvc

Zekarias Haile (zhaile@shield-legal.com)
2025-02-27 14:12:22

Hey Brian, how are you doing? Have you had a chance to ask Ryan about the tables that we talked about last monday?

Brian Hirst (brian@themedialab.agency)
2025-02-27 14:13:28

I haven’t Him and I have a call tomorrow at some point. I’ll bring them up. Can you send me the monday board item this is referring to?

Zekarias Haile (zhaile@shield-legal.com)
2025-02-27 14:18:50

sounds good. Here's monday board link. https://tortintakeprofessionals.monday.com/boards/6304263960/views/156553659/pulses/8250477495?userId=66544495

:the_horns: Brian Hirst
Zekarias Haile (zhaile@shield-legal.com)
2025-02-27 14:31:26

"Ryan Vaspra: 00:00 And we'll get her done. And then this is kind of how I'll do the next set of tables. I'll kind of teach you. You go do it and then do it. You make sure that they link to the tables properly. So that done, you'll know exactly all of these data input, you know, AKA IO underscore table names that Brian Hurst has to quickly get the portal built for us to add a media buyer. Media buyers log in and add their, their spend and their ad platform and their, and their leadpedia vertical."

This is from excerpted from fireflies note. To give you a hint on what Ryan is looking

👍 Brian Hirst
Zekarias Haile (zhaile@shield-legal.com)
2025-03-14 21:14:03

Hey @Brian Hirst when you get a chance please add me to slack channels(all campaigns that has channels). Sorry for bothering you after hours

Zekarias Haile (zhaile@shield-legal.com)
2025-06-03 16:29:08

Hi Brian, when do you think you will be pushing the media buyers data?

Brian Hirst (brian@themedialab.agency)
2025-06-04 08:56:18

Working on it now I’m having issues with the vertical ID’s

👍:skin_tone_3: Zekarias Haile
Brian Hirst (brian@themedialab.agency)
2025-06-12 12:18:03

Did you make the verticals table in BigQuery?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 12:18:38

No, I didn't

Brian Hirst (brian@themedialab.agency)
2025-06-12 12:18:54

Do you know who did

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 12:22:09

not sure,, but Nick is going to look into it I think

Brian Hirst (brian@themedialab.agency)
2025-06-12 12:22:37

Ok I need that updated for the media spendtable

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 12:22:57

got it

Brian Hirst (brian@themedialab.agency)
2025-06-19 11:01:40

Hey Zekarias, are you in front of a computer right now? I wanted to show you something in the table

Zekarias Haile (zhaile@shield-legal.com)
2025-06-19 11:02:16

hey, yes

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

Cool

Brian Hirst (brian@themedialab.agency)
2025-06-19 11:02:59

meet.google.com/ghs-srsb-ovb

Zekarias Haile (zhaile@shield-legal.com)
2025-06-23 11:32:23

Good morning Brian, I wanted to check to see if u reached out to Ryan about the Nitido

Brian Hirst (brian@themedialab.agency)
2025-06-23 11:32:47

No, I was going to ask him right now. I still need to meet with Media Buyers

Zekarias Haile (zhaile@shield-legal.com)
2025-06-23 11:33:46

okay

Zekarias Haile (zhaile@shield-legal.com)
2025-06-27 13:18:59

Hey Brian, how is it going with Nitido stuff?

Brian Hirst (brian@themedialab.agency)
2025-06-27 13:20:55

I haven’t gotten a real answer. Are you using the media spend table?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-27 13:21:15

Not yet

Zekarias Haile (zhaile@shield-legal.com)
2025-06-27 13:21:22

Just checking

Zekarias Haile (zhaile@shield-legal.com)
2025-06-27 13:21:33

With you

Zekarias Haile (zhaile@shield-legal.com)
2025-06-27 13:22:27

What did Cam or media buyers say about it? Want to ask Nick’s perspective on this

Brian Hirst (brian@themedialab.agency)
2025-06-27 13:48:22

Nick doesn’t deal with that part. I’ve talked to media buyers and I’m waiting on Cam

👍:skin_tone_3: Zekarias Haile