Ryan (ryan@themedialab.agency)
2024-01-17 11:53:58

Guys, I'm going into the focus-mode for SL schema, Brian, please do same with "on-demand tasks allowing" for TIP and Luke same for AI Project.

👍 Brian Hirst
Ryan (ryan@themedialab.agency)
2024-01-17 11:56:08

So i will cancel meeting, lets make good progress on schemas, and Looker prototype will be next week.

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

@Ryan I just got out of my meeting with Fivetran on getting our trial/POC is setup. I have some questions regarding the Postgres DB that I will need answered before my next meeting with them tomorrow. Can you send me a meeting invite for when you are free later today to discuss?

Ryan (ryan@themedialab.agency)
2024-01-17 12:45:56

Sure

Ryan (ryan@themedialab.agency)
2024-01-18 10:52:24

A new LawRuler login for us and the accounting team to use instead of Tony's:

tipfinancials@tortintakeprofessionals.com Tip7180$

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

@Ryan when are you free to meet with bytecode tomorrow?

Ryan (ryan@themedialab.agency)
2024-01-18 12:29:27

Just replied to all on the chain.

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-18 12:32:46

@Ryan we discussed in the meeting to meet tomorrow not the 26th. Do you have availability?

Ryan (ryan@themedialab.agency)
2024-01-18 12:34:06

Ah, got it. What times are we thinking?

Ryan (ryan@themedialab.agency)
2024-01-18 12:35:02

I'm going to be on the go most tomorrow but if you want to schedule it early as possible, I can either make it or have them record it for me and I'll watch after. Make sure Luke, Brian and Mike can join.

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

I have something @ 10am but otherwise free

Ryan (ryan@themedialab.agency)
2024-01-18 12:35:37
  1. User Setup in FiveTran (1 user or invite us)
  2. Nick's FiveTran Q&A
  3. Harvest App Q&A
Ryan (ryan@themedialab.agency)
2024-01-18 12:36:44

I'll invite a dev user to Harvest so the "standard data source connector" can be trained on real sample data. Need Invoices and Expenses and Clients and Projects data from the app.

Ryan (ryan@themedialab.agency)
2024-01-18 12:41:11

@here, https://brandlyticsio.harvestapp.com/, username is analytics@shield-legal.com, please setup a password @Nicholas McFadden, so we can share here and get API access.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-18 16:24:57

password is: SLNV$7180

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

@here try logging in and let me know if you can access with those credentials

Ryan (ryan@themedialab.agency)
2024-01-18 16:39:19

Ty!

🙏 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-30 13:48:30

@Brian Hirst @Luke Fontaine sent you both invites to Fivetran yesterday. If you got and can access please let me know so we are setup for our meetings tomorrow

👍 Brian Hirst
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-30 13:49:47

Also, is there a pre-built connection either of you would like to see/use first for the demos (Facebook Ads, Google Analytics, etc)?

Ryan (ryan@themedialab.agency)
2024-01-30 14:15:10

Harvest

👍 Nicholas McFadden
Luke Fontaine (luke@shield-legal.com)
2024-01-30 15:34:17

Received your invite and able to set up my account

😎 Ryan
👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-31 11:09:41

Hey getting pulled into help Dicello

☝️:skin_tone_4: Ryan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-31 11:09:59

hopefully will be done before meeting

Ryan (ryan@themedialab.agency)
2024-01-31 11:10:09

I know the feeling. Let us know.

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-31 11:12:42

Also, I have Fivetran completing initial Harvest sync right now should be done soon

Ryan (ryan@themedialab.agency)
2024-01-31 11:14:55

Boom pow!

Ryan (ryan@themedialab.agency)
2024-01-31 11:14:57

Nice

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-06 15:24:31

GitHub: analytics@shield-legal.com SLnv$7180

Brian Hirst (brian@themedialab.agency)
2024-02-06 15:28:26

@Nicholas McFadden Can I get the confirmation code?

Brian Hirst (brian@themedialab.agency)
2024-02-06 15:28:36

It just got sent

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-06 15:30:40

793134

Ryan (ryan@themedialab.agency)
2024-02-06 16:54:56

Got it, ty

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-29 14:27:17

Just read the firefly.ai summary of the call for the first time. It does a pretty good job, pretty impressed.

Ryan (ryan@themedialab.agency)
2024-02-29 14:27:43

It does!

Ryan (ryan@themedialab.agency)
2024-02-29 14:27:50

I was impressed too.

Luke Fontaine (luke@shield-legal.com)
2024-02-29 14:28:08

same here, it's a really impressive software

Ryan (ryan@themedialab.agency)
2024-02-29 14:28:16

API for ConnexOne

👍 Nicholas McFadden
Ryan (ryan@themedialab.agency)
2024-02-29 14:28:43

Luke, you missed a great meeting. No achema but just status.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-29 14:28:43

Exactly what I was thinking

😎 Ryan
Ryan (ryan@themedialab.agency)
2024-02-29 14:29:25

We have a lot going going on but really happy to be working on it with this team. 🙏:skintone3:

🙌:skin_tone_4: Luke Fontaine
👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-29 14:30:12

They might have something built in but we can integrate this or use a speech to text model in vertex AI for transcriptions. Then push it to ChatGPT or Gemini to accomplish something similar

Luke Fontaine (luke@shield-legal.com)
2024-02-29 14:30:54

Oh I know, reading through the transcript, and you're right, especially with the dev we've been doing it wouldn't hurt to better understand the process of pulling the lambda pything script connecting to Github

Ryan (ryan@themedialab.agency)
2024-02-29 15:09:52

Please!

Ryan (ryan@themedialab.agency)
2024-02-29 15:10:39

@Luke Fontaine , learning python lambdas will let you start from the beginning and move quick to transforms and dashboard and app portals. 💥

👍 Nicholas McFadden
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-29 17:07:39

@here I've been talking with Dwight, he is very knowledgeable in SQL and actually has had experience using dbt! Being considerate of his time, I think we should pull him into our session with dbt, include him in some of the schema discussions, and when we get around to the SL/BLX data use him as another set of hands for dev.

Ryan (ryan@themedialab.agency)
2024-02-29 17:42:12

Excellent @Nicholas McFadden very considerate of his time

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-29 17:42:57

Need to check things with Mike but he seemed happy to help out

Ryan (ryan@themedialab.agency)
2024-02-29 17:43:10

Will do

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-29 17:43:43

Are you saying you’re going to check with him?

Ryan (ryan@themedialab.agency)
2024-02-29 17:43:49

Yes

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-29 17:43:53

I was planning to reach out

Ryan (ryan@themedialab.agency)
2024-02-29 17:44:11

You can, if he balks, let me know

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-02-29 17:45:21

Ok no worries. Hopefully he won’t, but we just need briefly for now and we can work with Mike in the future to be fair to his workload

Ryan (ryan@themedialab.agency)
2024-02-29 17:45:44

Make sense

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-06-25 09:23:58

@here sorry for the early message gentlemen but I am trying to reconcile Flatirons for Cam by 8:30. We have used the awslegacyviews>matiewfinancialdetails table to pull the financial information. However, when reconciling there are no LeadIDs. Where should I be pulling to see the LeadIDs being attributed to Flatirons financials? Just want to make sure I am pulling from the correct place

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-06-25 09:33:21

There is a awslegagcypublic>financal_log in TIP project with LeadIDs but is this safe to use?

Ryan (ryan@themedialab.agency)
2024-06-25 09:40:41

Yes!

Ryan (ryan@themedialab.agency)
2024-06-25 09:40:44

Sade to use.

🙏 Nicholas McFadden