Meeting Title: Brainforge x Stackblitz Date: 2025-01-20 Meeting participants: Luke Daque, Mitchell Wright, Uttam Kumaran
WEBVTT
1 00:05:31.570 ⇒ 00:05:32.839 Luke Daque: Hey? Good Tom! How’s it going.
2 00:05:33.380 ⇒ 00:05:34.189 Uttam Kumaran: Hey! Good morning!
3 00:05:34.590 ⇒ 00:05:35.590 Luke Daque: Good evening.
4 00:05:39.570 ⇒ 00:05:45.670 Uttam Kumaran: But yeah, I think mainly it’s just setting up snowflake setting up dbt, core.
5 00:05:46.557 ⇒ 00:05:49.359 Uttam Kumaran: I think in terms of core
6 00:05:51.340 ⇒ 00:05:55.479 Uttam Kumaran: I think this may be the 1st time we did core since Bullport. So
7 00:05:57.180 ⇒ 00:05:59.980 Uttam Kumaran: I don’t know. Do you want to try to handle it? And moving over scripts.
8 00:06:01.430 ⇒ 00:06:02.609 Luke Daque: Yeah, we can do that.
9 00:06:03.790 ⇒ 00:06:06.380 Uttam Kumaran: I think maybe me and you can talk about the steps
10 00:06:07.283 ⇒ 00:06:13.769 Uttam Kumaran: and then I’m gonna I can handle Snowflake, and I’m gonna record the whole process for snowflake.
11 00:06:15.790 ⇒ 00:06:16.520 Luke Daque: Sure.
12 00:06:17.070 ⇒ 00:06:19.424 Luke Daque: Is it just the 2 of us? I think there’s
13 00:06:21.450 ⇒ 00:06:23.660 Uttam Kumaran: Somebody else like from style.
14 00:06:23.660 ⇒ 00:06:26.739 Uttam Kumaran: Mitchell Mitchell is a client he’s on. He’s probably on his way.
15 00:06:26.980 ⇒ 00:06:28.020 Luke Daque: Okay, cool?
16 00:06:29.630 ⇒ 00:06:38.630 Luke Daque: Oh, yeah. So I guess we’re gonna be setting up dpt core.
17 00:06:40.030 ⇒ 00:06:41.515 Luke Daque: Let me just
18 00:06:43.810 ⇒ 00:06:48.289 Uttam Kumaran: So the main setup is just like we need to. You know you. You know how we have our template repo.
19 00:06:48.880 ⇒ 00:06:49.710 Luke Daque: Right.
20 00:06:50.160 ⇒ 00:06:54.779 Uttam Kumaran: We’ll just bring that over. And then it’s just setting up the.
21 00:06:55.750 ⇒ 00:07:03.259 Uttam Kumaran: It’s basically you’ll you’ll just make sure that the profiles and stuff can connect locally, and then it’s moving to Github actions.
22 00:07:03.400 ⇒ 00:07:05.190 Uttam Kumaran: At least the one simple job.
23 00:07:06.000 ⇒ 00:07:08.630 Luke Daque: Okay, gotcha.
24 00:07:10.670 ⇒ 00:07:16.049 Luke Daque: Yeah. Let me clone the repo while we’re waiting
25 00:07:31.660 ⇒ 00:07:33.630 Luke Daque: tablets.
26 00:07:40.860 ⇒ 00:07:41.990 Mitchell Wright: Hey? What’s going on.
27 00:07:42.960 ⇒ 00:07:43.749 Uttam Kumaran: How are you?
28 00:07:44.020 ⇒ 00:07:45.959 Mitchell Wright: Good. Good. How are you guys doing.
29 00:07:46.240 ⇒ 00:07:51.619 Uttam Kumaran: Good I I guess I’ll introduce you to Luke. Luke is an engineer on my team.
30 00:07:52.211 ⇒ 00:07:58.639 Uttam Kumaran: Yeah. Knows about stockpits. And yeah, we’re ready to go so maybe we could just
31 00:07:58.740 ⇒ 00:08:00.548 Uttam Kumaran: jump right into it.
32 00:08:01.000 ⇒ 00:08:01.789 Mitchell Wright: Yeah, let’s do it.
33 00:08:02.380 ⇒ 00:08:09.290 Uttam Kumaran: I think that I sent a little bit of notes on just getting Snowflake. Set up getting polytomic. Set up and getting Dbt. Core set up.
34 00:08:09.850 ⇒ 00:08:12.440 Uttam Kumaran: I think all of those things are.
35 00:08:12.900 ⇒ 00:08:16.729 Uttam Kumaran: Except for polytomic. I feel pretty comfortable getting that done this week.
36 00:08:17.350 ⇒ 00:08:45.860 Uttam Kumaran: Dbt, core, basically, we’re gonna we have a template repo that we typically use and we’ll we’ll clone that into the Dbt repo that you provided and then we’ll basically get that hooked up to Snowflake. So set up profiles and everything. And then we’ll create one job, for now that just runs daily that we can sort of slot everything into, and then we can make a decision on jobs and frequency down the line. Just make sure, like the pipes are connected.
37 00:08:47.370 ⇒ 00:08:56.469 Uttam Kumaran: for Snowflake. I’ll just be using my stack Blitz email and sort of run through the free trial process.
38 00:08:57.039 ⇒ 00:09:06.610 Uttam Kumaran: I I don’t think they require. I don’t believe they require a credit card initially. I think they can give you 14 day free trial. But then, after that
39 00:09:06.760 ⇒ 00:09:10.329 Uttam Kumaran: it’ll require a a card from your side.
40 00:09:10.880 ⇒ 00:09:14.470 Mitchell Wright: Okay, no worries. I can definitely provide that.
41 00:09:14.690 ⇒ 00:09:15.280 Uttam Kumaran: Okay?
42 00:09:15.745 ⇒ 00:09:18.890 Uttam Kumaran: So I’ll go ahead and get that set up. And then.
43 00:09:19.710 ⇒ 00:09:23.236 Uttam Kumaran: do you guys have any? Do you have any preference on like
44 00:09:25.296 ⇒ 00:09:29.259 Uttam Kumaran: cloud location. We just do like us East for everything.
45 00:09:29.260 ⇒ 00:09:36.149 Mitchell Wright: Yeah, Usc will be great, because we’ve got kind of split across California and Europe. So.
46 00:09:36.410 ⇒ 00:09:39.489 Uttam Kumaran: Where do you are you guys on aws for anything?
47 00:09:41.190 ⇒ 00:09:43.560 Uttam Kumaran: Do you have, or do you have a do you have a preference on
48 00:09:44.460 ⇒ 00:09:47.730 Uttam Kumaran: On setting up on azure versus aws.
49 00:09:48.240 ⇒ 00:09:51.130 Mitchell Wright: Probably aws would be good. Yeah.
50 00:09:51.860 ⇒ 00:09:53.960 Uttam Kumaran: Okay, cool. So we’ll we’ll get that set up.
51 00:09:54.510 ⇒ 00:09:57.610 Uttam Kumaran: And then also, as part of like broadly set up.
52 00:09:57.980 ⇒ 00:10:03.920 Uttam Kumaran: we create like warehouses. You’ll get the role. We’ll create all the roles. I’ll invite everyone as users.
53 00:10:06.180 ⇒ 00:10:07.020 Uttam Kumaran: And.
54 00:10:07.020 ⇒ 00:10:11.669 Mitchell Wright: What do you guys do for our back? What’s been your way of managing that.
55 00:10:11.670 ⇒ 00:10:14.498 Uttam Kumaran: Yeah, so typically we will do
56 00:10:15.210 ⇒ 00:10:23.530 Uttam Kumaran: So we’ll do a role. So now, Snowflake has service account, like user types. So we’ll set up a service account for
57 00:10:23.980 ⇒ 00:10:31.909 Uttam Kumaran: either. If you have bi tools or for for Dvt, for example, we’ll set up a service account. Those are all like key pair off
58 00:10:32.379 ⇒ 00:10:38.249 Uttam Kumaran: and then for everyone else, we’ll basically create users. And then we’ll task. We’ll put everyone into like we have a
59 00:10:38.400 ⇒ 00:10:44.200 Uttam Kumaran: transformation role. We have, like ingest roles, transformation roles and reporting roles.
60 00:10:45.360 ⇒ 00:10:50.440 Uttam Kumaran: For for now what the 3 of us will just have access to will be in all 3.
61 00:10:50.460 ⇒ 00:11:18.429 Uttam Kumaran: As you want to add users, you basically can pick, for example, polytomic the service account will have the ingest role it won’t have like transform or the reporting role. When you have an analyst, come in, you may. You may want them to just be able to read everything. And we’ll we’ll slot them into the the analyst role, the the reader role. And then Dbt will have the transformation role where it can read from
62 00:11:19.043 ⇒ 00:11:32.700 Uttam Kumaran: it could read from raw, and then basically do transformations in the intermediate. And we sort of break things up like we we do. We’ll all polyatomic, will get shoved somewhere, and then we’ll create like a raw schema which is like basic transformations cleanup.
63 00:11:32.930 ⇒ 00:11:36.009 Uttam Kumaran: We’ll create intermediate and then we’ll create a march
64 00:11:36.190 ⇒ 00:11:37.299 Uttam Kumaran: and sort of run that way.
65 00:11:37.300 ⇒ 00:11:44.289 Mitchell Wright: Yeah, cool. Yep. That sounds exactly like what I would kind of do.
66 00:11:44.810 ⇒ 00:11:50.230 Uttam Kumaran: Is there anyone else on your side, like in terms of analysts or people that need data that I can? Just
67 00:11:50.800 ⇒ 00:11:52.300 Uttam Kumaran: okay. If not, then it’s fine.
68 00:11:52.300 ⇒ 00:12:06.209 Mitchell Wright: Right now it’ll it’ll just be me. And then I think we’ll we’ll wanna get some of the engineers up and running with. You know, just basically like a ability to query from
69 00:12:07.560 ⇒ 00:12:23.510 Mitchell Wright: probably start with, like, you know, intermediate or or mark, maybe just mark, the thing is like it’s gonna take us time to model stuff. So maybe we just start. And then they can kind of do. But I think I think as we get a couple of people in there, and they
70 00:12:24.400 ⇒ 00:12:28.190 Mitchell Wright: start to realize, you know, the value of it, that it’ll
71 00:12:28.640 ⇒ 00:12:34.210 Mitchell Wright: it’ll start gaining a bit more traction with people internally.
72 00:12:34.580 ⇒ 00:12:48.370 Uttam Kumaran: Cool. Yeah. And I’m happy to help on like adoption and training again. The nice thing is we try to do the governance and the R back stuff from the start, because it’s like absolute nightmare trying to go back on some of these things. So
73 00:12:48.390 ⇒ 00:12:51.420 Uttam Kumaran: yeah, yeah, just make sure that we have like.
74 00:12:51.660 ⇒ 00:12:55.620 Uttam Kumaran: As soon as you create new users, it’s clear which role to slot them in
75 00:12:56.093 ⇒ 00:12:59.780 Uttam Kumaran: in terms of polytomic. Do you want me to go ahead and like
76 00:13:00.010 ⇒ 00:13:04.800 Uttam Kumaran: I can engage and get like you on an email and get stuff
77 00:13:04.950 ⇒ 00:13:08.550 Uttam Kumaran: again. I’ll just use the stack list email to sort of get things going. Is that fine?
78 00:13:08.770 ⇒ 00:13:16.669 Mitchell Wright: Yeah, yeah. Feel free to kind of run point on getting that all set up and and definitely a CC Me on stuff
79 00:13:16.840 ⇒ 00:13:25.269 Mitchell Wright: so that I’m aware of. What’s going on. And yeah, especially with polytomic. Just so I can
80 00:13:25.490 ⇒ 00:13:31.840 Mitchell Wright: talk to Ghalib about it and make sure he’s giving us the best deal.
81 00:13:32.310 ⇒ 00:13:35.509 Uttam Kumaran: Okay, great and then
82 00:13:37.128 ⇒ 00:13:48.310 Uttam Kumaran: the last thing is, I guess I wanted to go through that spreadsheet that you shared as well. Last time we looked at it, and then I just wanna kinda confirm
83 00:13:50.890 ⇒ 00:13:53.459 Uttam Kumaran: what sources we’re going after initially,
84 00:13:54.540 ⇒ 00:14:02.150 Mitchell Wright: Yeah, so yeah, so I think, talking about sources. We’ve got.
85 00:14:02.600 ⇒ 00:14:07.770 Mitchell Wright: Let’s see, I don’t think I shared with you like the basic data
86 00:14:08.390 ⇒ 00:14:11.689 Mitchell Wright: diagram. But essentially, we have
87 00:14:12.640 ⇒ 00:14:14.980 Mitchell Wright: let me just pull this up and maybe I’ll share my screen.
88 00:14:14.980 ⇒ 00:14:17.380 Uttam Kumaran: Yeah, like, I have this full metrics.
89 00:14:18.940 ⇒ 00:14:26.419 Mitchell Wright: Yeah, yeah. I mean, before we even get there, right? Is getting the ingestion of the
90 00:14:26.800 ⇒ 00:14:28.480 Mitchell Wright: the various
91 00:14:30.290 ⇒ 00:14:40.280 Mitchell Wright: like databases internally, and like getting stripe we and and hooking up hubspot all that kind of stuff.
92 00:14:40.400 ⇒ 00:14:45.282 Mitchell Wright: so getting getting all of our sources. So maybe it’d be helpful to kind of like go through
93 00:14:46.450 ⇒ 00:14:53.151 Mitchell Wright: the sources right? So essentially, we have a handful of postgres databases on
94 00:14:55.650 ⇒ 00:15:02.190 Mitchell Wright: on on our side, for, like our internal databases. And then I think we’re gonna want
95 00:15:02.500 ⇒ 00:15:06.727 Mitchell Wright: to get stripe data in there, and I’m not sure
96 00:15:08.950 ⇒ 00:15:21.879 Mitchell Wright: ever. So we moved off of 5 tran to stripe data connect, I don’t necessarily know, like the difference there, of what pros and cons of one versus the other, because I wasn’t involved in the finance data.
97 00:15:22.270 ⇒ 00:15:26.949 Uttam Kumaran: Data connect. They’ll do a direct link, but then they charge
98 00:15:27.270 ⇒ 00:15:30.380 Uttam Kumaran: on like a per transaction. It’s like an additional charge.
99 00:15:33.050 ⇒ 00:15:39.040 Uttam Kumaran: I have a feeling that polytomic just might be cheaper, although I can kind of do the math. Once I start seeing the volume.
100 00:15:39.520 ⇒ 00:15:40.080 Mitchell Wright: Okay.
101 00:15:41.540 ⇒ 00:15:49.689 Uttam Kumaran: yeah. Yeah, I can. I can. I can take on just doing that math. I just have to look at the volume they charge like and additional, like some
102 00:15:50.020 ⇒ 00:15:53.590 Uttam Kumaran: percent fee commute directly.
103 00:15:53.710 ⇒ 00:15:59.800 Uttam Kumaran: I don’t know. I guess when I when we go to polytomic, I’ll get a sense of like what the overall pricing is gonna be
104 00:16:02.030 ⇒ 00:16:07.109 Uttam Kumaran: in terms of like actual benefit in terms of like refresh times and stuff.
105 00:16:07.460 ⇒ 00:16:09.659 Uttam Kumaran: Also, I’m not 100% sure.
106 00:16:10.040 ⇒ 00:16:16.460 Mitchell Wright: Yeah, okay, yeah. If you yeah, I’m just pulling up the stripe. I guess they call data pipeline.
107 00:16:16.620 ⇒ 00:16:17.280 Uttam Kumaran: Yeah.
108 00:16:20.500 ⇒ 00:16:26.200 Mitchell Wright: If they have any public pricing here. Okay, 3 cents per transaction.
109 00:16:26.800 ⇒ 00:16:29.109 Uttam Kumaran: Yeah, I feel like, that’s high. It’s just like.
110 00:16:29.110 ⇒ 00:16:36.160 Mitchell Wright: Yeah, especially because you’re like a little bit more of A B to C, almost so.
111 00:16:36.160 ⇒ 00:16:38.059 Uttam Kumaran: That’s yeah. I guess I can.
112 00:16:38.670 ⇒ 00:16:52.470 Uttam Kumaran: Well, once I once I get, once we get like polytomic, I’m sure he’ll just have a sync stuff, and then I’ll ask him sort of how pricing happens, and I can help you sort of put pressure on in terms of getting a good deal there
113 00:16:54.090 ⇒ 00:16:57.879 Uttam Kumaran: Hubspot also, I think, has.
114 00:16:57.880 ⇒ 00:17:02.579 Mitchell Wright: So we did. We did pay for their hubspot of.
115 00:17:03.190 ⇒ 00:17:04.089 Uttam Kumaran: The Snowflake Thing.
116 00:17:04.099 ⇒ 00:17:17.179 Mitchell Wright: But essentially, we’ll let us sync because they all that also gives us some advanced workflow stuff. So yeah, we already paid for that. It’s probably overpriced, but we wanted the additional workflow stuff, and the the snowflake stuff was like a
117 00:17:17.309 ⇒ 00:17:22.429 Mitchell Wright: like a bonus on there, so we won’t need that to come from polytomic.
118 00:17:22.710 ⇒ 00:17:24.270 Uttam Kumaran: So I’ll probably just
119 00:17:25.720 ⇒ 00:17:32.089 Uttam Kumaran: I mean, once we have Snowflake everything set up, I’ll make sure that you have the details. I do think that it’s just going in
120 00:17:32.530 ⇒ 00:17:40.550 Uttam Kumaran: to Hubspot and setting some stuff up. There may be a couple of things to like that. Maybe we mean, you need to walk through on what? To sync
121 00:17:41.313 ⇒ 00:17:45.190 Uttam Kumaran: for the most part, I just I assume it’s gonna be just
122 00:17:45.680 ⇒ 00:17:49.749 Uttam Kumaran: all the events are you thinking about beyond?
123 00:17:50.220 ⇒ 00:17:55.429 Uttam Kumaran: Are you thinking about like? Is that for mostly like Crm, is that for like sales stuff, or.
124 00:17:55.430 ⇒ 00:18:07.469 Mitchell Wright: So Hubspot, we, we purchased their marketing hub. So we’ll be doing emails email marketing and that kind of stuff out of there. We also have the sales hub. So that will be Crm data as well.
125 00:18:08.790 ⇒ 00:18:13.639 Mitchell Wright: And then and then we have segment. For all of our event. Stuff.
126 00:18:13.830 ⇒ 00:18:14.380 Uttam Kumaran: Okay.
127 00:18:14.380 ⇒ 00:18:19.120 Mitchell Wright: But the events, I mean we should sync the events we currently have. But
128 00:18:20.710 ⇒ 00:18:24.505 Mitchell Wright: our venting is all kinds of messed up right now. So
129 00:18:25.340 ⇒ 00:18:33.700 Mitchell Wright: I don’t know. Yeah, we should do it. But I don’t know how much value I’m going to really get out of the current events, and then it’s going to be a whole nother project for us to actually get
130 00:18:33.940 ⇒ 00:18:34.530 Mitchell Wright: newer.
131 00:18:35.130 ⇒ 00:18:40.859 Mitchell Wright: Yeah. So so that’s gonna be something we have to work on.
132 00:18:41.770 ⇒ 00:18:45.449 Mitchell Wright: So yeah, I think for now, just like we’re gonna get the
133 00:18:46.210 ⇒ 00:18:57.776 Mitchell Wright: get the sources set up and then and then maybe we can. Do you know, some light transformation and cleanup of those initial raw sources of, you know, renaming and
134 00:18:58.600 ⇒ 00:19:05.210 Mitchell Wright: any kind of like easy, calculated fields whatever, and and get all of that up and running, and then
135 00:19:05.350 ⇒ 00:19:11.180 Mitchell Wright: we and then I think we kinda meet together again, and we’ll reevaluate what the next things we need to do are.
136 00:19:11.630 ⇒ 00:19:16.929 Uttam Kumaran: Yeah, basically, I think that I’ll be going off the like entities that you kind of had
137 00:19:17.561 ⇒ 00:19:30.199 Uttam Kumaran: again, for the most part straightforward, just trying to get towards a cohesive view of like users and customers right? Which will be a mix of postgres and stripe and then also trying to get
138 00:19:30.450 ⇒ 00:19:32.139 Uttam Kumaran: as much of the core.
139 00:19:32.763 ⇒ 00:19:36.070 Uttam Kumaran: Like page view sessions, that sort of stuff.
140 00:19:36.410 ⇒ 00:19:41.609 Mitchell Wright: Yeah, that stuff will be great. And I think the way we’ll get to that data is via segment.
141 00:19:41.610 ⇒ 00:19:43.120 Uttam Kumaran: Yeah, yeah.
142 00:19:43.520 ⇒ 00:19:44.450 Mitchell Wright: Okay. Cool.
143 00:19:45.650 ⇒ 00:19:52.620 Uttam Kumaran: Okay, fair. And then, yeah, I assume out of everything. Probably the sales deal flow.
144 00:19:52.760 ⇒ 00:19:55.139 Uttam Kumaran: Crm stuff is probably like least priority.
145 00:19:55.280 ⇒ 00:20:05.060 Mitchell Wright: Yeah, we don’t really have much of a b 2 b motion right now. So that’s gonna be a future looking so really, so right now, essentially.
146 00:20:05.620 ⇒ 00:20:14.067 Mitchell Wright: we log in on a daily basis to bare metrics and are using them for like financial reporting stuff.
147 00:20:15.720 ⇒ 00:20:18.940 Mitchell Wright: I mean, I don’t know that we.
148 00:20:19.290 ⇒ 00:20:21.340 Uttam Kumaran: If everything’s flowing into stripe.
149 00:20:21.570 ⇒ 00:20:26.020 Uttam Kumaran: The only thing you probably don’t have in there is like costs and stuff like that.
150 00:20:26.130 ⇒ 00:20:29.439 Uttam Kumaran: But again, nothing of what you mentioned was really
151 00:20:29.630 ⇒ 00:20:32.450 Uttam Kumaran: around financial reporting short term. So.
152 00:20:32.790 ⇒ 00:20:36.530 Mitchell Wright: Yeah, but that’s actually now that you bring that up. That’s like.
153 00:20:36.750 ⇒ 00:20:42.339 Mitchell Wright: probably that we should get a better handle on.
154 00:20:43.070 ⇒ 00:20:45.970 Mitchell Wright: So like, for example, our main.
155 00:20:47.136 ⇒ 00:20:53.469 Mitchell Wright: I don’t know a ton about actually our our architecture. I know we use a lot of cloudflare for stuff.
156 00:20:53.590 ⇒ 00:20:54.656 Mitchell Wright: And then,
157 00:20:55.360 ⇒ 00:21:07.339 Mitchell Wright: we have just a monster anthropic Bill, because Claude is the main Llm that we’re using. So I don’t know if you’ve done much work with like
158 00:21:07.680 ⇒ 00:21:11.849 Mitchell Wright: pulling cost data out of cloudflare, or
159 00:21:12.720 ⇒ 00:21:15.570 Mitchell Wright: I don’t even know what our options are from anthropic.
160 00:21:15.720 ⇒ 00:21:17.423 Uttam Kumaran: Okay, yeah. Let me
161 00:21:19.560 ⇒ 00:21:22.755 Uttam Kumaran: Let me note that down and think about it.
162 00:21:23.320 ⇒ 00:21:29.638 Uttam Kumaran: cause that way. Yeah, I think the revenue side. I feel really comfortable with the cost side.
163 00:21:30.240 ⇒ 00:21:38.856 Uttam Kumaran: I think if those 2 are the biggest, then we can just be like, okay, how do I could talk to gleeve, too, and ask like, Okay, what’s the process of getting these in?
164 00:21:39.710 ⇒ 00:21:46.689 Uttam Kumaran: And if not, then we can write something. But that helps. So we have that. So sales.
165 00:21:47.110 ⇒ 00:21:49.759 Uttam Kumaran: And then, yeah, I guess, where does email
166 00:21:50.720 ⇒ 00:21:53.099 Uttam Kumaran: is that stuff live in terms of marketing?
167 00:21:53.100 ⇒ 00:21:59.360 Mitchell Wright: No. So right now, Hubspot, we just barely signed that contract, and we’ll be going live with them
168 00:22:00.090 ⇒ 00:22:16.299 Mitchell Wright: like over the next 4 to 6 weeks we’ve got we use active campaign at the moment. But I don’t really want to put effort into getting that data, cause I cause we’re gonna be out of there very soon. So if there’s if there’s any kind of
169 00:22:16.930 ⇒ 00:22:22.228 Mitchell Wright: like pre work we can do or think through there, maybe we can do that, but otherwise
170 00:22:23.520 ⇒ 00:22:26.149 Mitchell Wright: yeah, let’s we’ll we’ll probably just
171 00:22:26.890 ⇒ 00:22:29.640 Mitchell Wright: wait on that a little bit until we get that up and running.
172 00:22:30.030 ⇒ 00:22:52.130 Uttam Kumaran: Once, you see, once I sync Hubspot, we’ll see if there’s any emails. Typically, the email types of reporting is like overall volume. And then looking at conversion to events like of the people who we email for, what campaign? How did that result in events on the site subscriptions? Right? So. And that’s all joined through email and time.
173 00:22:53.300 ⇒ 00:23:03.050 Uttam Kumaran: that’s typically like what we can do. That’s like a good place to start for like email reporting. Typically people want to see like overall volume like, How much are we sending? What’s all the rates.
174 00:23:03.450 ⇒ 00:23:04.699 Mitchell Wright: Yeah. Open rate, click through rate.
175 00:23:04.700 ⇒ 00:23:11.540 Uttam Kumaran: Then it’s like a 1 specific campaign. How did that result in like and activation? Or, yeah.
176 00:23:11.540 ⇒ 00:23:20.419 Mitchell Wright: Yep, yep, exactly. Yep, that’s all the kind of stuff we’ll want from that as well. So yep, you’re already already thinking there. So that’s great.
177 00:23:21.650 ⇒ 00:23:27.760 Uttam Kumaran: Cool. So we’ll get started. I’ll talk to polyatomic, and then.
178 00:23:27.940 ⇒ 00:23:32.209 Uttam Kumaran: yeah, we’ll probably have Snowflake set up, probably by end of tomorrow.
179 00:23:32.510 ⇒ 00:23:37.039 Uttam Kumaran: and then we’re working on Dbt core stuff. So you should see changes in the repo today.
180 00:23:38.250 ⇒ 00:23:39.150 Mitchell Wright: Awesome.
181 00:23:41.990 ⇒ 00:23:51.249 Mitchell Wright: cool. Okay. Yeah. And then what do you guys do? As far as like, what kind of cadence for syncing? Do you do that async, or synchronous like what’s.
182 00:23:51.250 ⇒ 00:23:54.559 Uttam Kumaran: Yeah, we we usually, I think we usually try to talk
183 00:23:54.750 ⇒ 00:23:57.375 Uttam Kumaran: to you once a week at minimum.
184 00:23:57.750 ⇒ 00:23:58.480 Mitchell Wright: Yeah, yeah.
185 00:23:58.480 ⇒ 00:24:10.579 Uttam Kumaran: I think there’s like there’s a couple I mean one, you know, we’re all people. So it’s nice to say, Hi, but also there’s probably like some small things that we can batch and do there. For the most part, we’re Async.
186 00:24:10.680 ⇒ 00:24:19.459 Uttam Kumaran: A lot of this sort of work looks to be at least initially like set up an infra. I think, as we have questions about specific models.
187 00:24:19.847 ⇒ 00:24:31.339 Uttam Kumaran: We can probably batch that on a call, but for the most part we’ll do as much Async. We use notion a lot. So for anything that’s sort of like longer form, we can write it up there and and share for feedback.
188 00:24:31.590 ⇒ 00:24:36.729 Uttam Kumaran: But again, even just going off your bolt metrics thing is probably what I’ll use to
189 00:24:36.990 ⇒ 00:24:40.269 Uttam Kumaran: as like our main home to to track our progress towards that.
190 00:24:40.590 ⇒ 00:24:42.890 Uttam Kumaran: If that’s fair, then I can just try to grab
191 00:24:43.230 ⇒ 00:24:46.799 Uttam Kumaran: sometime like towards the end of the week each week.
192 00:24:47.461 ⇒ 00:24:52.920 Uttam Kumaran: But of course, like. However, you feel if you want to talk more often, that’s totally fine.
193 00:24:53.140 ⇒ 00:24:58.900 Mitchell Wright: Yeah, no, that that works for me. And I think that having
194 00:25:00.940 ⇒ 00:25:12.549 Mitchell Wright: like asynchronous, you know, drop stuff in the slack channel. I’ll be quick to respond and pull in whoever I need to. If it’s not something I can help with. And I I really just wanna
195 00:25:13.060 ⇒ 00:25:14.480 Mitchell Wright: move things forward.
196 00:25:14.690 ⇒ 00:25:15.440 Uttam Kumaran: Okay? Great.
197 00:25:15.440 ⇒ 00:25:24.680 Uttam Kumaran: yeah. I think the I think the only other. Once we get to Dbt modeling, we can also add user reviewer and stuff and and sort of allow you to check the tables before we push logic.
198 00:25:24.820 ⇒ 00:25:31.520 Uttam Kumaran: That’s usually our process. But yeah, we’re gonna move as fast as we can. So.
199 00:25:31.820 ⇒ 00:25:35.230 Mitchell Wright: Cool. Okay. Awesome. I’m excited.
200 00:25:35.840 ⇒ 00:25:36.600 Uttam Kumaran: Thanks.
201 00:25:36.730 ⇒ 00:25:37.740 Mitchell Wright: Okay.
202 00:25:38.190 ⇒ 00:25:42.519 Uttam Kumaran: Yeah, I guess we’ll we’ll hit you on slack if anything, and then cool. Have a good week. Otherwise.
203 00:25:42.520 ⇒ 00:25:46.999 Mitchell Wright: Yeah, let me know what else you guys need as it comes up. But I’m excited to
204 00:25:47.130 ⇒ 00:25:57.189 Mitchell Wright: get some get some progress on this stuff. Thank you. Guys for yeah, this is gonna be great. I’m I’m really excited. This will be huge for us.
205 00:25:57.750 ⇒ 00:25:58.280 Uttam Kumaran: Cool.
206 00:25:59.360 ⇒ 00:26:00.620 Mitchell Wright: Catch you guys later.