Ryan (ryan@themedialab.agency)
2024-01-08 11:24:43

@Cameron Rentch, when you envisioned sample ads in the external client dashboards, are you envisioning these to be at the Vertical / Case Type level only? And not lower, such as Contract level? Database design question.

FYI @Nicholas McFadden @Brian Hirst @Luke Fontaine

Luke Fontaine (luke@shield-legal.com)
2024-01-08 11:24:45

@Luke Fontaine has joined the channel

Ryan (ryan@themedialab.agency)
2024-01-08 12:15:53

@Nicholas McFadden, morning. After starting Fivetran Free Trial setup, would you mind setting it up, it asks some specific BigQuery inputs to get the free trial going. Once you have it going, I'll give CC information for monthly plan.

👇:skintone4:

image.png
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-08 12:18:00

@Ryan acknowledged. Will do

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-08 12:19:05

Trying to hold ADP's feet to fire today so we aren't letting them off the line until the API setup is done. Once I am done with them will dive into this

🙏:skin_tone_4: Ryan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-08 14:46:05

setting it up now

😎 Ryan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-08 15:24:20

@Ryan FYI I think Fivetran is only going to be good for well established data sources (Google Ads, MailChimp, etc.) I may still have to code in GCP or perhaps DBT for LawRuler, ADP, and Vici. I have sent an email confirming and have set a meeting with their trial setup person (Cole) tomorrow.

Ryan (ryan@themedialab.agency)
2024-01-08 15:25:05

Amanda at ByteCode said you use Cloud Funtion still called from Fivetran

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-08 15:25:17

Is it me or did Bytcecode make it seem like Fivetran could hand all of our pipelines and not just the well established companies?

Ryan (ryan@themedialab.agency)
2024-01-08 15:25:43

Load raw into BigQuery, the reason is we can then orchestrate all in one place.

Ryan (ryan@themedialab.agency)
2024-01-08 15:25:59

For non-standard and standard, email Amanda with any questions

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

Right okay they did say for standard and non-standard then

Ryan (ryan@themedialab.agency)
2024-01-08 15:26:37

Cool

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-08 15:26:44

I will speak with the Fivetran people

👏:skin_tone_4: Ryan
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-08 15:40:00

Update: they do have a custom connectors solution but it is just managing/orchestrating the Google Cloud Functions that are actually doing the extraction. Therefore, any connector we need that is not prebuilt we will have to code in Cloud Functions. Not a problem but something to note for any future data needs.

Ryan (ryan@themedialab.agency)
2024-01-08 15:40:58

Sounds good. We’ll use more standard connectors for Google ads, Google Analytics and others for social when we unleash your data skills.

Ryan (ryan@themedialab.agency)
2024-01-08 15:41:37

So Python still needed on non-standard to dataframe and load into raw yeah?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-01-08 15:42:46

Yes still has to be coded in Python for anything non-standard. Not sure if they need anything inside the function to properly interface but I will find out in my meeting with them tomorrow.

Ryan (ryan@themedialab.agency)
2024-01-08 15:57:01

Perfect. This sounds like pretty simple functions. Luke has some “quotes Python skills” but not sure if he can help you with out some of your training when it’s simple raw reference update pipelines that should run every 5 minutes.

Ryan (ryan@themedialab.agency)
2024-01-08 15:57:16

But let’s see and we can cross that bridge together with him.

👍 Nicholas McFadden
BRETT SHIELD SLACK (brettmichael@shield-legal.com)
2024-03-01 18:06:15

@BRETT SHIELD SLACK has left the channel

deleted-U04GU9EUV9A
2024-03-01 18:06:51

@deleted-U04GU9EUV9A has joined the channel

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-01 18:15:19

@Tony @deleted-U04GU9EUV9A @deleted-U05EFH3S2TA Law Ruler won't work on the requests I sent yesterday until we have provided all questions at once. Can you guys get me your list of questions by Monday afternoon so we can get them working? Willing to meet Monday morning to hash it out, let me know.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-05 11:24:47

@here We have a new SOW from Law Ruler in order to get our answers to using contact ID as our primary key so we can connect to ConnexOne, Dicello, etc. Who manages our Law Ruler contract and ultimately able to sign off on this SOW?

Ryan (ryan@themedialab.agency)
2024-03-05 11:25:46

@deleted-U04KC9L4HRB and @Tony , but don’t recall who signed it.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-03-05 14:42:34

@Ryan I got with Tony, thanks!

🙏:skin_tone_4: Ryan
Mike (mike@shield-legal.com)
2024-06-18 12:59:34

@Mike has left the channel