Meeting Title: Analytics Engineering Daily Sync Date: 2025-02-25 Meeting participants: Luke Daque, Uttam Kumaran, Awaish Kumar, Caio Velasco
WEBVTT
1 00:04:46.420 ⇒ 00:04:47.270 Luke Daque: Hello!
2 00:04:47.500 ⇒ 00:04:48.290 Uttam Kumaran: Hey!
3 00:04:50.960 ⇒ 00:04:52.250 Luke Daque: How’s it going.
4 00:04:52.250 ⇒ 00:04:53.400 Uttam Kumaran: Good! How are you?
5 00:04:54.380 ⇒ 00:05:04.639 Luke Daque: And well just created a notion ticket for all the bare metrics for stackbooks.
6 00:05:08.670 ⇒ 00:05:09.690 Uttam Kumaran: Okay, cool.
7 00:05:10.680 ⇒ 00:05:15.890 Uttam Kumaran: Yeah. So maybe maybe we can even walk through. Because I made some changes to that template. Doc.
8 00:05:16.270 ⇒ 00:05:23.259 Uttam Kumaran: I kind of want to. Actually, I want to show you guys a couple of things that I’m doing for one of our other clients, and we’ll give you a sense of like
9 00:05:23.460 ⇒ 00:05:28.830 Uttam Kumaran: how we’re gonna basically templatize some of the larger architecture organization work.
10 00:05:29.707 ⇒ 00:05:33.250 Uttam Kumaran: I think I’ll once Kyle’s okay. Kyle’s cool.
11 00:05:35.050 ⇒ 00:05:37.699 Uttam Kumaran: Hey? So let me let me just share that.
12 00:05:38.060 ⇒ 00:05:42.549 Uttam Kumaran: And then I just wanna kind of share what I’ve been working on for these guys and
13 00:05:44.231 ⇒ 00:05:46.460 Uttam Kumaran: we can sort of talk about
14 00:05:47.410 ⇒ 00:05:51.939 Uttam Kumaran: basically how I’m starting to organize the entire architecture. So
15 00:05:59.451 ⇒ 00:06:02.210 Uttam Kumaran: great, so basically like
16 00:06:02.390 ⇒ 00:06:06.459 Uttam Kumaran: for urban stems, I basically got like something like this. They built
17 00:06:06.730 ⇒ 00:06:15.537 Uttam Kumaran: and I spent probably like 10 h worth of meetings talking to everybody at the company to learn about everything. So I started building, basically
18 00:06:16.160 ⇒ 00:06:21.540 Uttam Kumaran: like, I’m basically building out all of their documentation.
19 00:06:22.021 ⇒ 00:06:27.089 Uttam Kumaran: So one is, I’m sort of going through. They have 2 etl tools. They have stitch and hevo.
20 00:06:27.230 ⇒ 00:06:29.820 Uttam Kumaran: So I’m going through and making sure that I have
21 00:06:30.530 ⇒ 00:06:34.880 Uttam Kumaran: all the sources sort of listed here in one way or another.
22 00:06:35.080 ⇒ 00:06:37.800 Uttam Kumaran: Some of these are active, some of these are not active.
23 00:06:38.040 ⇒ 00:06:43.399 Uttam Kumaran: They have this, many Google sheets going in so. And then they have a bunch of also stuff through hevo
24 00:06:43.620 ⇒ 00:06:47.450 Uttam Kumaran: right? Then. The other thing I’m working on is, I’m sort of looking at
25 00:06:48.234 ⇒ 00:06:51.690 Uttam Kumaran: where stuff is landing in raw intermediate and march
26 00:06:51.980 ⇒ 00:06:54.750 Uttam Kumaran: right now. They don’t have any notion of intermediate.
27 00:06:54.850 ⇒ 00:06:58.269 Uttam Kumaran: They just have like A. They just have reporting tables.
28 00:06:58.390 ⇒ 00:07:00.670 Uttam Kumaran: So this will be empty, but it
29 00:07:00.940 ⇒ 00:07:03.390 Uttam Kumaran: kind of make our point that like there’s no
30 00:07:03.590 ⇒ 00:07:13.150 Uttam Kumaran: all these things should get moved to there, right? So that’s the point I’ll be making. And then I’m gonna work on like the looker dashboards. They have probably like 10 or 15 dashboards that are
31 00:07:13.550 ⇒ 00:07:14.820 Uttam Kumaran: key to them.
32 00:07:16.350 ⇒ 00:07:24.690 Uttam Kumaran: so this is a I’m working on this. I think probably I should have a version of this ready by the end of this week that we can start to adapt to every client
33 00:07:24.820 ⇒ 00:07:32.790 Uttam Kumaran: the other thing I’m working on is this pairs extremely closely to? The the semantic
34 00:07:33.030 ⇒ 00:07:36.180 Uttam Kumaran: plat I call calling it like platform documentation.
35 00:07:36.490 ⇒ 00:07:41.380 Uttam Kumaran: and I’m sort of extending it to to a bunch of things. One is, we have our metrics and dimensions.
36 00:07:41.860 ⇒ 00:07:46.919 Uttam Kumaran: we have our dashboard template, we have a new analysis template.
37 00:07:47.870 ⇒ 00:07:51.359 Uttam Kumaran: We have our March documentation ideally.
38 00:07:51.530 ⇒ 00:08:06.429 Uttam Kumaran: march documentation metrics, and these are all sort of validated together. Right? So you shouldn’t be able to. The all the metrics should end up here from the March documentation template. Same with definitions. Right? So this
39 00:08:06.880 ⇒ 00:08:10.369 Uttam Kumaran: we will maintain, and it should flow into everything else.
40 00:08:10.960 ⇒ 00:08:14.300 Uttam Kumaran: And then we have our data source documentation. So it’s gonna be the source.
41 00:08:14.880 ⇒ 00:08:16.910 Uttam Kumaran: What? What? The objects are.
42 00:08:17.660 ⇒ 00:08:21.900 Uttam Kumaran: Right? So like, we’re getting orders. Blah, blah, blah. So what we’re getting from there
43 00:08:22.500 ⇒ 00:08:24.509 Uttam Kumaran: and then it’s gonna have the type
44 00:08:25.855 ⇒ 00:08:30.610 Uttam Kumaran: like, or basically like, what business domain is this from
45 00:08:30.720 ⇒ 00:08:36.780 Uttam Kumaran: the description? Who’s the owner? What pipeline tools using? What’s the method? What’s the frequency? Where’s the destination?
46 00:08:37.330 ⇒ 00:08:40.630 Uttam Kumaran: So we’ll have this for every single core source.
47 00:08:41.240 ⇒ 00:08:45.470 Uttam Kumaran: And then, also on the platform side, we’re gonna start looking at tools and costs.
48 00:08:46.010 ⇒ 00:08:49.749 Uttam Kumaran: and this is something that every client will get out of the box.
49 00:08:51.960 ⇒ 00:09:01.670 Uttam Kumaran: one. It allows us to go in here and start to make proposals because we walk into a client, and we just want to like document everything. Then we can start making proposals. For example, I’m like.
50 00:09:02.020 ⇒ 00:09:07.160 Uttam Kumaran: delete 2 of these at polyatomic delete redshift. Add snowflake things like that.
51 00:09:07.778 ⇒ 00:09:10.949 Uttam Kumaran: So that’s sort of like what I’m working on right now.
52 00:09:11.988 ⇒ 00:09:13.140 Uttam Kumaran: I’m filling this out.
53 00:09:13.490 ⇒ 00:09:17.170 Uttam Kumaran: I did a bunch of work on this yesterday. I’m sort of continuing to work on this today.
54 00:09:19.350 ⇒ 00:09:21.340 Uttam Kumaran: But any thoughts on this.
55 00:09:23.540 ⇒ 00:09:31.699 Luke Daque: Yeah, this looks great so far, it looks like it has all the things you needed from like an end to end. Perspective on on the semantic.
56 00:09:31.960 ⇒ 00:09:32.815 Uttam Kumaran: Layer,
57 00:09:34.060 ⇒ 00:09:36.669 Luke Daque: But this is, I think this would be like.
58 00:09:37.358 ⇒ 00:09:39.329 Luke Daque: what do you call that like?
59 00:09:40.770 ⇒ 00:09:50.159 Luke Daque: This is not gonna be our final version, right like putting it all in Google sheets like, maybe we’ll just we’ll use something else in the future or something.
60 00:09:50.450 ⇒ 00:10:01.270 Uttam Kumaran: Yeah, like, I don’t. I don’t see. I want us to get it right before we think about the fee, the Usability, right? And Google sheets flexible enough. But yeah, I’ll think about like.
61 00:10:01.510 ⇒ 00:10:07.149 Uttam Kumaran: is there a better way? For example, this is very manual.
62 00:10:07.580 ⇒ 00:10:16.690 Uttam Kumaran: like, I would prefer us to have dot Doc. Definitions in Dbt, and we somehow build this from there
63 00:10:17.340 ⇒ 00:10:17.860 Uttam Kumaran: like.
64 00:10:17.860 ⇒ 00:10:18.380 Luke Daque: Yeah.
65 00:10:18.380 ⇒ 00:10:19.930 Uttam Kumaran: Logic. Things like that.
66 00:10:20.630 ⇒ 00:10:25.269 Uttam Kumaran: We can use AI for some of this whatever, but I want to get it right before
67 00:10:26.210 ⇒ 00:10:28.119 Uttam Kumaran: getting it fast. So.
68 00:10:28.120 ⇒ 00:10:28.890 Luke Daque: Right.
69 00:10:29.090 ⇒ 00:10:34.780 Uttam Kumaran: We’ll struggle through this, and then we’ll sort of work on. How do we improve the speed at which
70 00:10:34.910 ⇒ 00:10:36.880 Uttam Kumaran: this is updated, and stuff like that.
71 00:10:37.990 ⇒ 00:10:42.720 Luke Daque: Would also like need to figure out like, who’s gonna be
72 00:10:43.980 ⇒ 00:10:46.320 Luke Daque: populating all of this right? Is it like.
73 00:10:47.270 ⇒ 00:10:52.730 Uttam Kumaran: It’s basically gonna be like the Ae on every client. I think that’s gonna be owning this.
74 00:10:52.900 ⇒ 00:10:53.720 Luke Daque: Yeah.
75 00:10:54.100 ⇒ 00:11:05.149 Uttam Kumaran: Right cause. I’m sort of acting as like de on every client. I kind of see the responsibility of the ae to sort of make sure this updated. I think we don’t need to have this updated
76 00:11:05.260 ⇒ 00:11:12.559 Uttam Kumaran: like every week, but I do think that as part of adding new models.
77 00:11:13.770 ⇒ 00:11:17.480 Uttam Kumaran: part of the check should be. Did we add this to the
78 00:11:18.010 ⇒ 00:11:21.450 Uttam Kumaran: did we add this to the documentation? Basically.
79 00:11:24.590 ⇒ 00:11:29.549 Caio Velasco: I have a question. It looks really good. In
80 00:11:29.840 ⇒ 00:11:34.910 Caio Velasco: the only question I I have go to the data source documentation tab, please.
81 00:11:39.920 ⇒ 00:11:48.210 Caio Velasco: Okay. So as I see, this is a spreadsheet that can start to be filled.
82 00:11:48.390 ⇒ 00:11:49.070 Caio Velasco: Hmm!
83 00:11:49.490 ⇒ 00:11:56.110 Caio Velasco: I think if I look at the metrics dimension tab the 1st one. This is something that we just know. After we have
84 00:11:56.260 ⇒ 00:12:06.519 Caio Velasco: an idea of a data model like we would have, we would know what the fact table would be. Of course, we usually know that orders customers. Those things are normal, but that’s
85 00:12:06.710 ⇒ 00:12:08.970 Caio Velasco: usually after we started.
86 00:12:09.460 ⇒ 00:12:14.069 Caio Velasco: For example, when I’m working on the gorgeous dashboard dashboard now.
87 00:12:14.300 ⇒ 00:12:19.950 Caio Velasco: and I still have to go on part of those gorgeous database. Understand where
88 00:12:20.170 ⇒ 00:12:25.969 Caio Velasco: which day? Which column I wanna get something that is connected to a specific metric
89 00:12:26.090 ⇒ 00:12:29.060 Caio Velasco: is that something that comes before this.
90 00:12:30.940 ⇒ 00:12:33.840 Uttam Kumaran: Yeah, it’s tough. Because I think, like.
91 00:12:35.250 ⇒ 00:12:41.160 Uttam Kumaran: I feel like it’s our job to do the investigative work of like what is landed right? Cause.
92 00:12:41.850 ⇒ 00:12:43.430 Uttam Kumaran: Of course, we’re going to say
93 00:12:43.710 ⇒ 00:12:47.539 Uttam Kumaran: we connected to Portable. That means it may or may not be there.
94 00:12:47.660 ⇒ 00:12:52.960 Uttam Kumaran: Well, the requirements we’re gonna get is a dashboard requirements. And then we’re gonna sort of have to fill in the gap.
95 00:12:53.330 ⇒ 00:13:00.279 Uttam Kumaran: Right? So I think there’s. And then, as we have questions, that’s exactly the stuff that you’re doing, which is
96 00:13:00.820 ⇒ 00:13:04.299 Uttam Kumaran: okay. We searched for it a little bit. I found a couple of things.
97 00:13:04.590 ⇒ 00:13:15.750 Uttam Kumaran: What do you think like that is an iterative process because both parties don’t know exactly the format it landed in. I. The one thing, though, is, once we do gorgeous.
98 00:13:16.390 ⇒ 00:13:19.270 Uttam Kumaran: we have, we’re gonna we would have done it for every client.
99 00:13:19.700 ⇒ 00:13:27.550 Uttam Kumaran: So, for example, Zendesk, work, we already we’ve done it for one client like a wish I could show you sort of how we structured that.
100 00:13:27.800 ⇒ 00:13:35.690 Uttam Kumaran: And anytime we do shopify work. We don’t shopify for 5 clients. So that is our benefit, as brain forge is that
101 00:13:36.130 ⇒ 00:13:42.180 Uttam Kumaran: we will slowly start to have seen most common connectors to where
102 00:13:42.570 ⇒ 00:13:49.159 Uttam Kumaran: ideally this process is a little bit faster. Gorgeous is the 1st time we’re sort of interacting with gorgeous.
103 00:13:49.480 ⇒ 00:13:57.360 Uttam Kumaran: But for the next client, we basically like, you’re the gorgeous expert. And we’ve done a full data mart documentation on it. So
104 00:13:57.460 ⇒ 00:14:01.059 Uttam Kumaran: that’s the stuff. I think that’s really, really cool to me is that
105 00:14:01.420 ⇒ 00:14:07.760 Uttam Kumaran: that isn’t like a 1 time thing right like in a typical company. You’d you’d have to do this one time, and it’s sort of like useless.
106 00:14:07.890 ⇒ 00:14:11.390 Uttam Kumaran: This. It helps us for all of our future clients.
107 00:14:12.870 ⇒ 00:14:21.939 Uttam Kumaran: And of course, again, I want I want clients when they see this to be like. Nobody on their team has done this level of documentation
108 00:14:22.540 ⇒ 00:14:26.909 Uttam Kumaran: like we wanna constantly hit them over the head with. Why, we’re valuable.
109 00:14:27.230 ⇒ 00:14:38.600 Uttam Kumaran: right? And these are things that they can see from our team, the things from our team. They, a lot of clients, aren’t in Github. They’re not in Dbt, they’re not in the. They may not be in the warehouse.
110 00:14:39.610 ⇒ 00:14:47.139 Uttam Kumaran: So for us to be able to produce artifacts like this, as also artifacts like the figma.
111 00:14:47.630 ⇒ 00:14:50.180 Uttam Kumaran: This is our show and tell right.
112 00:14:50.620 ⇒ 00:15:01.390 Uttam Kumaran: And I know it’s it’s like, not actually the work. But like this is what saves us the time to go. Do everything like I’m telling you. Nobody in the for this company has done this.
113 00:15:01.640 ⇒ 00:15:05.949 Uttam Kumaran: and for all of our companies nobody is doing this nobody cares enough. And so
114 00:15:06.200 ⇒ 00:15:11.699 Uttam Kumaran: I think it’s really helpful that we create these artifacts. And then we’re able to sort of show our work
115 00:15:11.940 ⇒ 00:15:16.840 Uttam Kumaran: as much as we can for the analysts. They have a break because they’re doing dashboards right? So.
116 00:15:18.390 ⇒ 00:15:24.590 Caio Velasco: Nice. Nice. No, that’s that’s really nice. And this is something that I mean, we never know where, where we can
117 00:15:24.820 ⇒ 00:15:28.964 Caio Velasco: get in in the future. But this could be a product itself.
118 00:15:29.310 ⇒ 00:15:33.144 Uttam Kumaran: Oh, yeah, believe me, I know I mean the
119 00:15:33.730 ⇒ 00:15:39.609 Uttam Kumaran: the, the common thing in consulting this is what a lot of people they’re like. Oh, why don’t we turn that to the product? I’m like
120 00:15:39.800 ⇒ 00:15:54.849 Uttam Kumaran: one. It’s hard frauding. A product company is a different challenge. Second, we we’re just gonna charge more like everybody. I just want us to be like we are even better. We move even faster. And so we charge more money, and then everybody makes more. Right? That’s our
121 00:15:54.990 ⇒ 00:15:57.409 Uttam Kumaran: flywheel, you know.
122 00:15:59.580 ⇒ 00:16:23.659 Uttam Kumaran: so yeah, I mean again, this is what we know we can do. The problem is, we typically will will think. Let me just get the the data models out and everything will be solved. The client is left for like a week without knowing what exactly we’re working on. So this buys us that time builds that trust allows them to really see the size and scope right? For, like urban stems I’m like. And this isn’t even everything I’m like.
123 00:16:24.100 ⇒ 00:16:36.520 Uttam Kumaran: Look at all like there’s 1520 Google sheets. There’s multiple shopify’s coming in and I haven’t even started on how it’s getting into the warehouse.
124 00:16:39.010 ⇒ 00:16:40.010 Uttam Kumaran: Like.
125 00:16:40.310 ⇒ 00:16:56.759 Uttam Kumaran: And I’m gonna start drawing lines. It’s gonna start getting a little bit like insane. And I’m gonna basically show them like this is the situation. And then we’re going to start doing like XX like, show them the money. They’ll save the time they’ll save the things we can cut all that stuff
126 00:16:56.910 ⇒ 00:17:03.260 Uttam Kumaran: like they have. They have 2 different bi tools. They have tons of dashboards that no one’s looking at
127 00:17:03.460 ⇒ 00:17:07.899 Uttam Kumaran: like. So that’s a really satisfying thing that people customers want to see.
128 00:17:08.339 ⇒ 00:17:12.650 Uttam Kumaran: And then we’re basically, the plan is really obvious, right like of what we’re gonna do.
129 00:17:13.000 ⇒ 00:17:17.079 Uttam Kumaran: Similarly, when we walk into a company and fill out something like.
130 00:17:17.680 ⇒ 00:17:29.039 Uttam Kumaran: fill out something like this, the the plan becomes really obvious on like, okay, what we need to do it, doesn’t. It doesn’t leave much room for ambiguity, and the ambiguity is really the thing that we should be working on
131 00:17:29.680 ⇒ 00:17:36.729 Uttam Kumaran: working on getting these requirements and doing this. This is like the easy work, but it’s something that everybody will want. The client may want it.
132 00:17:36.880 ⇒ 00:17:40.849 Uttam Kumaran: but people on the client side may want it. We may want it once.
133 00:17:42.630 ⇒ 00:17:49.360 Uttam Kumaran: and I think this this itself, this that this, this spreadsheet you’re I’m right, is sort of some sort of like
134 00:17:49.670 ⇒ 00:17:53.229 Uttam Kumaran: Brainforge client documentation product.
135 00:17:53.900 ⇒ 00:18:03.869 Uttam Kumaran: It. Right now, the product is Google Sheet. We could think about some other form factor of having this live on the website under a client page, or something like that. But again, I don’t want.
136 00:18:05.500 ⇒ 00:18:12.280 Uttam Kumaran: I don’t want to confuse like the look and feel for it like just working right so great.
137 00:18:12.750 ⇒ 00:18:13.420 Caio Velasco: Nice.
138 00:18:14.920 ⇒ 00:18:18.699 Uttam Kumaran: Okay. Cool. What can we talk about?
139 00:18:21.180 ⇒ 00:18:21.870 Uttam Kumaran: Bye-bye.
140 00:18:23.060 ⇒ 00:18:30.530 Awaish Kumar: I have this, like the the latest changes you pushed on the Admin profile
141 00:18:31.080 ⇒ 00:18:33.840 Awaish Kumar: is, was that working for you?
142 00:18:37.790 ⇒ 00:18:41.440 Uttam Kumaran: Let me check. I don’t recall.
143 00:18:57.450 ⇒ 00:19:00.300 Uttam Kumaran: Yeah, I’m trying to fix the intraday run.
144 00:19:00.990 ⇒ 00:19:05.140 Uttam Kumaran: It’s not working. For some reason. I need a little bit more time to fix it.
145 00:19:05.721 ⇒ 00:19:09.370 Uttam Kumaran: But why? I can run production locally if you need to.
146 00:19:09.860 ⇒ 00:19:27.029 Awaish Kumar: Actually, I was trying to run staging. And for some reason this profiles dot Ymil file I’m seeing, have the data data base and the schema both set to add in data warehouse.
147 00:19:27.280 ⇒ 00:19:37.870 Awaish Kumar: And and even if I change schema to something like broad data, Mount DVD. Mode or something, it is still takes the adding data warehouse as the.
148 00:19:38.280 ⇒ 00:19:42.379 Uttam Kumaran: Yeah. So let me show you what’s going. Let me show you what’s going on there.
149 00:19:47.410 ⇒ 00:19:51.920 Uttam Kumaran: so we in profiles.
150 00:19:52.990 ⇒ 00:19:54.510 Uttam Kumaran: We are.
151 00:19:54.620 ⇒ 00:19:56.490 Uttam Kumaran: Yeah, we have these 2. Because
152 00:19:56.670 ⇒ 00:19:59.260 Uttam Kumaran: I, what I found out is these 2 are the same.
153 00:19:59.980 ⇒ 00:20:08.940 Uttam Kumaran: And then basically, what happens is we have to run this this Macro called called get custom schema.
154 00:20:09.090 ⇒ 00:20:11.930 Uttam Kumaran: and this is what actually puts it into the
155 00:20:12.060 ⇒ 00:20:16.000 Uttam Kumaran: into the right folder. And then, if you see for Eden, we have
156 00:20:16.660 ⇒ 00:20:26.950 Uttam Kumaran: intermediate marts. And thing here in the Dbt project. So what happens is, let’s let’s take a model, for example.
157 00:20:27.940 ⇒ 00:20:38.019 Uttam Kumaran: let’s say we we’re looking@customers.sql. There’s 2 factors, right? Is it in dev staging prod? And is it an intermediate marks or raw.
158 00:20:38.210 ⇒ 00:20:47.599 Uttam Kumaran: based on those 2 factors, it assigns it the proper prefix and assigns it the proper
159 00:20:50.050 ⇒ 00:20:52.060 Uttam Kumaran: like suffix, basically.
160 00:20:53.650 ⇒ 00:20:59.349 Awaish Kumar: Okay, yeah. But I was trying to run it. I’m just constantly getting this error.
161 00:20:59.690 ⇒ 00:21:03.990 Awaish Kumar: The on the project. Id, so I was not sure.
162 00:21:04.410 ⇒ 00:21:05.750 Uttam Kumaran: Did you pull latest?
163 00:21:06.995 ⇒ 00:21:07.509 Awaish Kumar: Yes!
164 00:21:09.360 ⇒ 00:21:11.740 Uttam Kumaran: Okay, maybe just slack me there. I’ll take a look.
165 00:21:15.390 ⇒ 00:21:16.100 Awaish Kumar: Okay.
166 00:21:16.350 ⇒ 00:21:16.940 Uttam Kumaran: Okay.
167 00:21:19.470 ⇒ 00:21:22.489 Uttam Kumaran: And then, did you also set set up your local credentials.
168 00:21:25.310 ⇒ 00:21:27.639 Awaish Kumar: These environment, variables, right.
169 00:21:27.640 ⇒ 00:21:28.270 Uttam Kumaran: Yeah.
170 00:21:28.920 ⇒ 00:21:32.249 Awaish Kumar: Yes, yes, I I do. I set them. And
171 00:21:33.050 ⇒ 00:21:38.388 Awaish Kumar: was. I was getting error on the basically the name of the project. Id
172 00:21:38.770 ⇒ 00:21:39.639 Uttam Kumaran: Oh! This one!
173 00:21:40.433 ⇒ 00:21:41.300 Awaish Kumar: Yeah, we.
174 00:21:43.326 ⇒ 00:21:45.660 Uttam Kumaran: Because this is running successfully.
175 00:21:47.190 ⇒ 00:21:47.980 Awaish Kumar: Okay.
176 00:21:49.430 ⇒ 00:21:52.720 Uttam Kumaran: Right, and it’s it’s naming things accurately.
177 00:21:58.140 ⇒ 00:21:59.760 Awaish Kumar: Yes, so.
178 00:22:01.780 ⇒ 00:22:06.649 Uttam Kumaran: Yeah, just send me send me what you’re getting, and then share with me your branch name, too, and I can check it out.
179 00:22:12.810 ⇒ 00:22:13.540 Uttam Kumaran: okay?
180 00:22:16.230 ⇒ 00:22:22.229 Uttam Kumaran: yeah. Kyle, I do. We do. We wanna talk about stuff for Javi while we have a moment here.
181 00:22:24.330 ⇒ 00:22:37.409 Caio Velasco: Well, we can. I well, I started trying to like search the database for gorgeous and and understand more about what do they mean by Macro? What do they mean by tickets and and the other things? And
182 00:22:38.082 ⇒ 00:22:46.812 Caio Velasco: well, in the beginning I I saw that the for example, the macro macro stable has
183 00:22:47.740 ⇒ 00:22:52.689 Caio Velasco: a column called Usage, where they’re basically, I assume counting
184 00:22:53.420 ⇒ 00:22:57.420 Caio Velasco: how many times that Macro was applied to a ticket
185 00:22:58.187 ⇒ 00:23:05.550 Caio Velasco: and I mean for the 1st question they were just interested in which markets are being used the most
186 00:23:06.041 ⇒ 00:23:19.920 Caio Velasco: so I assume that. Well, if you go to the macro stable and just order by the usage. That’s what you want. But at the same time of thinking like, is there any other way that we could that we should be counting across tickets.
187 00:23:20.040 ⇒ 00:23:29.940 Caio Velasco: And then I started to try. Well, I I got there are 89 macros, distinct macros. And then I say, I’m gonna get one or or another. Let’s see if I can find them
188 00:23:30.170 ⇒ 00:23:42.219 Caio Velasco: within the tickets table. And I couldn’t. I mean, this is just not there in any column. I tried to look for Jay’s on every every kind of column, and I didn’t find anything.
189 00:23:42.400 ⇒ 00:23:46.679 Caio Velasco: And so then I was like, how are macros being attached to tickets then?
190 00:23:47.190 ⇒ 00:23:50.990 Caio Velasco: And then when I went to their website, I saw that they have.
191 00:23:51.591 ⇒ 00:24:10.270 Caio Velasco: well, the developers page where you can search for the day zone stuff. And then in the main page there’s nothing related to Macros like a property in the Json. But then, if you go create yourself like there is a second. You can create yourself and see the Json on on the right. Then there is a macro property.
192 00:24:10.550 ⇒ 00:24:10.830 Uttam Kumaran: Yeah.
193 00:24:10.830 ⇒ 00:24:18.870 Caio Velasco: There should be a column, but this column is not in the ticket stated. So then that’s where I stopped like I was trying to see if I could find something else.
194 00:24:20.290 ⇒ 00:24:23.790 Uttam Kumaran: Can I connect you with the portable folks
195 00:24:24.190 ⇒ 00:24:28.349 Uttam Kumaran: and we can just have them go diagnose. Because.
196 00:24:28.830 ⇒ 00:24:36.620 Uttam Kumaran: yeah, I think your message is perfect context for them. If it’s not there, then they should go. Make sure that they’re bringing that in
197 00:24:38.280 ⇒ 00:24:44.570 Uttam Kumaran: Do you mind if I just do that right now you. You probably can just copy, paste your whole message. We have a slack channel with them.
198 00:24:45.828 ⇒ 00:24:50.160 Uttam Kumaran: That way. You can just talk directly to them.
199 00:24:52.034 ⇒ 00:24:52.500 Caio Velasco: And.
200 00:24:52.744 ⇒ 00:25:02.290 Uttam Kumaran: For all of our for all of our vendors, I try to create. Yeah, for all the vendors. I try to create a slack channel so that we can quickly iterate. So I’ll just tag you there and then.
201 00:25:03.780 ⇒ 00:25:04.980 Uttam Kumaran: Yeah, feel free.
202 00:25:06.000 ⇒ 00:25:12.209 Caio Velasco: Okay, cool. And but then that let me understand. So
203 00:25:12.610 ⇒ 00:25:18.660 Caio Velasco: we did the portable ingestion, or was it done for from by then.
204 00:25:18.660 ⇒ 00:25:25.179 Uttam Kumaran: Well, portable is like 5 trend, meaning. We just give them the Api key. They give us everything so.
205 00:25:25.180 ⇒ 00:25:25.720 Caio Velasco: Yep.
206 00:25:26.400 ⇒ 00:25:39.219 Uttam Kumaran: Like I can log in. We we didn’t. I can check. And again, like, I think this is probably more on the deep like I I looked, and I saw that there’s no, we’re not doing any real configuration meaning, we just said, Give us everything.
207 00:25:40.150 ⇒ 00:25:40.710 Caio Velasco: Over.
208 00:25:41.490 ⇒ 00:25:47.870 Uttam Kumaran: Yeah, like, I’m asking for accounts, custom fields, everything. So
209 00:25:50.610 ⇒ 00:25:54.630 Uttam Kumaran: I think this is also, maybe it’s it also on the on the
210 00:25:55.240 ⇒ 00:26:05.689 Uttam Kumaran: connector. It says that this is a new source for them, so maybe they can add it. Those guys are really responsive. They’ll add it if it’s easy, so I’ll just tag you here just literally.
211 00:26:05.690 ⇒ 00:26:06.250 Caio Velasco: Okay.
212 00:26:06.500 ⇒ 00:26:09.920 Uttam Kumaran: Send them what it is. But just make it very clear like
213 00:26:10.570 ⇒ 00:26:13.520 Uttam Kumaran: this is literally the question we need. And this is what we tried
214 00:26:13.920 ⇒ 00:26:18.350 Uttam Kumaran: so that they don’t have to read like that much, and then they’ll go figure it out.
215 00:26:19.580 ⇒ 00:26:26.999 Caio Velasco: Perfect perfect maybe you can open the the spreadsheet that I have, but just in a bit to see if
216 00:26:27.340 ⇒ 00:26:28.710 Caio Velasco: if that’s
217 00:26:29.280 ⇒ 00:26:35.669 Caio Velasco: what I should be sharing with them the question because I I thought I put the column now as QA. Not as comment.
218 00:26:36.263 ⇒ 00:26:40.159 Caio Velasco: Then I would share basically that question. I guess.
219 00:26:40.560 ⇒ 00:26:44.620 Uttam Kumaran: Yeah, I guess. Show me where? Oh, okay, yeah. I see that.
220 00:26:45.900 ⇒ 00:26:46.470 Caio Velasco: Yep.
221 00:26:46.470 ⇒ 00:26:49.649 Uttam Kumaran: Yeah, yeah, I don’t know.
222 00:26:54.750 ⇒ 00:26:55.789 Uttam Kumaran: Like this one.
223 00:26:58.710 ⇒ 00:27:00.040 Caio Velasco: Yes.
224 00:27:07.900 ⇒ 00:27:12.960 Uttam Kumaran: Yeah, I would say, this is correct.
225 00:27:13.800 ⇒ 00:27:15.480 Uttam Kumaran: This is also correct.
226 00:27:16.200 ⇒ 00:27:18.190 Uttam Kumaran: This is the question for portable.
227 00:27:18.780 ⇒ 00:27:20.700 Caio Velasco: Perfect, cool.
228 00:27:22.870 ⇒ 00:27:26.730 Uttam Kumaran: Great. This is perfect. By the way, yeah, the maximum.
229 00:27:26.730 ⇒ 00:27:31.080 Caio Velasco: Perfect, perfect. And then I also created this ignitions. Tab
230 00:27:31.473 ⇒ 00:27:36.866 Caio Velasco: just because when I was starting the like before, I start the work like what the heck is. Macro.
231 00:27:37.150 ⇒ 00:27:40.171 Caio Velasco: Yeah, yeah, no, it’s so. I had to like, study this.
232 00:27:40.410 ⇒ 00:27:46.479 Uttam Kumaran: So what is it? By the way, is it like? Is it like literally the brackets, like dynamic variables, or something.
233 00:27:46.750 ⇒ 00:27:53.080 Caio Velasco: So I think Microsoft is just a pre-made automated response to most common
234 00:27:53.520 ⇒ 00:28:00.549 Caio Velasco: questions by customers or queries by customers. That’s it. And then they just build macros for that, and then associate
235 00:28:00.690 ⇒ 00:28:01.759 Caio Velasco: with a ticket.
236 00:28:02.160 ⇒ 00:28:06.020 Caio Velasco: So there can be many macros per ticket or something like that.
237 00:28:06.390 ⇒ 00:28:11.017 Caio Velasco: Okay, so there should be a ticket, but they’re not there.
238 00:28:11.270 ⇒ 00:28:15.479 Uttam Kumaran: Okay, okay, these ones should be a little bit
239 00:28:18.680 ⇒ 00:28:20.450 Uttam Kumaran: easier. I don’t know.
240 00:28:24.150 ⇒ 00:28:30.149 Caio Velasco: Yeah. Oh, yeah, I’ll check those now. The few is also yeah, trying to see if I can find
241 00:28:30.280 ⇒ 00:28:33.350 Caio Velasco: it, because I try to to use a column. Huge.
242 00:28:33.350 ⇒ 00:28:37.460 Uttam Kumaran: So gorgeous, gorgeous is basically the same thing as like Zendesk.
243 00:28:37.570 ⇒ 00:28:38.480 Uttam Kumaran: Right?
244 00:28:38.800 ⇒ 00:28:40.359 Caio Velasco: I’d say, so, yeah.
245 00:28:40.570 ⇒ 00:28:42.459 Uttam Kumaran: Okay. So then, yeah, maybe I think
246 00:28:43.200 ⇒ 00:28:54.570 Uttam Kumaran: one of the things I’ll also think about is like, whenever maybe we should think about anytime, we get a category of like a let’s say we get customer service. We always have a notion of. Like the March model, we create
247 00:28:54.670 ⇒ 00:28:56.979 Uttam Kumaran: the regardless of the
248 00:28:57.270 ⇒ 00:29:11.350 Uttam Kumaran: source meaning gorgeous or Zendesk. This is our north star. Like set of 5 tables we’re going for to answer like 80% of the questions. Then, for example, gorgeous may have, Macro Zendesk may have something else that’s like, maybe one layer on top.
249 00:29:12.238 ⇒ 00:29:16.850 Uttam Kumaran: Okay, that’s that’s actually really helpful to think of it. Like, yeah, okay.
250 00:29:17.650 ⇒ 00:29:20.112 Caio Velasco: No, I’m sure they they copied each other.
251 00:29:20.560 ⇒ 00:29:21.210 Uttam Kumaran: Huh!
252 00:29:21.210 ⇒ 00:29:24.319 Caio Velasco: And I’m sure they copied each other. Now they are new.
253 00:29:24.320 ⇒ 00:29:25.559 Uttam Kumaran: Oh, yeah, I mean.
254 00:29:26.115 ⇒ 00:29:26.670 Caio Velasco: No.
255 00:29:26.670 ⇒ 00:29:29.679 Uttam Kumaran: They’re they’re all just different flavors of the same thing.
256 00:29:31.910 ⇒ 00:29:35.499 Uttam Kumaran: Yeah. And then I also, the nice thing is like.
257 00:29:35.850 ⇒ 00:29:40.079 Uttam Kumaran: if if it’s like a vendor problem. We can call them. So then, because
258 00:29:40.390 ⇒ 00:29:55.630 Uttam Kumaran: we’re now like implementing them, they everybody picks up our phone. So whoever we want to talk to like we can quickly get on the phone with any of the big vendors we actually we I was, we actually implemented gorgeous for someone else a while ago.
259 00:29:56.633 ⇒ 00:30:02.510 Uttam Kumaran: So I have some contact there. But yeah, whatever we need from them, we can get. So okay, that’s helpful.
260 00:30:02.510 ⇒ 00:30:03.120 Caio Velasco: Okay.
261 00:30:07.610 ⇒ 00:30:10.010 Uttam Kumaran: Anything else.
262 00:30:14.850 ⇒ 00:30:23.310 Uttam Kumaran: Yeah, Luke, I think the biggest thing is. Yeah. See if you can do some damage on that docs I’m gonna send it to. I’m gonna send it to Mitch just to be like.
263 00:30:23.930 ⇒ 00:30:25.220 Uttam Kumaran: we’re working on this.
264 00:30:25.420 ⇒ 00:30:26.230 Uttam Kumaran: Yeah.
265 00:30:26.532 ⇒ 00:30:27.440 Luke Daque: Should I like?
266 00:30:27.570 ⇒ 00:30:31.109 Luke Daque: Should that be like the priority? For now I guess.
267 00:30:31.110 ⇒ 00:30:34.070 Uttam Kumaran: You know, I would say, keep working on the bare metric stuff.
268 00:30:34.440 ⇒ 00:30:35.210 Luke Daque: Yeah.
269 00:30:35.210 ⇒ 00:30:40.909 Uttam Kumaran: I’ll I’ll I just wanted if you, whatever you can do in the docs with like 30 min or an hour.
270 00:30:41.250 ⇒ 00:30:43.750 Uttam Kumaran: just get something in there that way? I can.
271 00:30:44.230 ⇒ 00:30:44.870 Uttam Kumaran: I think, Yeah.
272 00:30:44.870 ⇒ 00:30:45.300 Luke Daque: Yeah, we can.
273 00:30:45.300 ⇒ 00:30:47.629 Uttam Kumaran: I can send something over. And then, yeah.
274 00:30:48.530 ⇒ 00:30:49.250 Luke Daque: Okay.
275 00:30:49.930 ⇒ 00:30:51.799 Uttam Kumaran: And then, yeah, what’s the real challenge?
276 00:30:53.110 ⇒ 00:30:59.880 Luke Daque: Yeah, I think it’s it’s just a 2 fa because I didn’t realize we already added the 2 fa there, so we can’t.
277 00:31:00.080 ⇒ 00:31:04.430 Luke Daque: I was using the staff@stackbits.com.
278 00:31:04.640 ⇒ 00:31:07.439 Luke Daque: Okay. I didn’t get the other 2. Okay.
279 00:31:09.700 ⇒ 00:31:17.519 Luke Daque: Yeah, I’ll probably just create a service account for this. So we can use that to connect to snowflake. Yeah, that way, we should be good.
280 00:31:18.390 ⇒ 00:31:26.040 Uttam Kumaran: Okay, yeah, if if it’s if it ends up being too challenging, just ping me, I can. I need to fix real for a couple of other clients today. So
281 00:31:26.320 ⇒ 00:31:27.480 Uttam Kumaran: just for me.
282 00:31:28.060 ⇒ 00:31:29.130 Luke Daque: Sure sounds good.
283 00:31:30.830 ⇒ 00:31:31.580 Uttam Kumaran: Okay.
284 00:31:32.460 ⇒ 00:31:33.340 Uttam Kumaran: Awesome.
285 00:31:33.570 ⇒ 00:31:40.809 Uttam Kumaran: Thanks. Guys, good meeting. Yeah. I think I’m gonna try to get all the engineering team onto a meeting. Maybe in a week or 2.
286 00:31:40.810 ⇒ 00:31:41.480 Luke Daque: Sure.
287 00:31:41.480 ⇒ 00:31:45.329 Uttam Kumaran: You know, kind of 2 things. 2 things on the roadmap, one
288 00:31:46.820 ⇒ 00:31:50.600 Uttam Kumaran: I want to do a demo of this new documentation process with everybody.
289 00:31:51.164 ⇒ 00:31:59.219 Uttam Kumaran: Second, probably. Hopefully, by the start of May, we’re thinking about working towards some sort of incentive program
290 00:31:59.410 ⇒ 00:32:08.259 Uttam Kumaran: where we’re able to incentivize. And like, it’s basically like, what is our like bonus structure, for everyone across engineering. So
291 00:32:08.450 ⇒ 00:32:11.460 Uttam Kumaran: we’re about 60% done with the planning there.
292 00:32:12.119 ⇒ 00:32:30.349 Uttam Kumaran: Basically, it’s like, based on the number of clients you’re taking on successfully the the number of escalations you’re taking on. And then there’s also things like, if the client renews with the client upsells. We’re working on basically performance incentives. Ideally, the whole goal is
293 00:32:31.070 ⇒ 00:32:44.549 Uttam Kumaran: as everyone here gets better and better and is able to take on more. You get more money, for that is the short of it. So we’re working on that. So like, please look on the way for that. And then we’re also.
294 00:32:45.570 ⇒ 00:32:53.687 Uttam Kumaran: I think, 2 other things. So 2 things on the product management side. So Nico is rolling off of pool parts and
295 00:32:54.490 ⇒ 00:33:04.700 Uttam Kumaran: Joby. So I’ll be just taking over on Pm. Across all clients. He’s moving on. He’s moving to another part of the company and sort of helping us with some Pm. Work there.
296 00:33:06.660 ⇒ 00:33:10.230 Uttam Kumaran: And we are hiring. We have 2 really great
297 00:33:10.420 ⇒ 00:33:17.589 Uttam Kumaran: lead. Pm’s in process, one of which is, gonna start a trial with us next week.
298 00:33:19.310 ⇒ 00:33:23.019 Uttam Kumaran: So there is more Pm, support coming in the next like 4 weeks.
299 00:33:23.410 ⇒ 00:33:31.149 Uttam Kumaran: I hopefully sooner. Yeah, as you can tell, like we’re we’re trying very hard. I think that’ll fix a lot of these problems.
300 00:33:31.792 ⇒ 00:33:34.450 Uttam Kumaran: I mean, I’m not going anywhere, but like
301 00:33:34.770 ⇒ 00:33:41.817 Uttam Kumaran: someone needs to spend a lot more time on this than me some other stuff needs my attention. So
302 00:33:42.520 ⇒ 00:33:45.389 Uttam Kumaran: Just bear with me for the next, like 2, 3 weeks
303 00:33:45.580 ⇒ 00:33:47.662 Uttam Kumaran: while we figured this stuff out. And
304 00:33:48.150 ⇒ 00:33:49.810 Uttam Kumaran: yeah, that should be coming soon.
305 00:33:51.000 ⇒ 00:33:52.500 Caio Velasco: Cool, nice.
306 00:33:52.500 ⇒ 00:33:56.859 Luke Daque: Yeah, I was. I forgot what I was about to ask or raise
307 00:33:59.650 ⇒ 00:34:00.900 Uttam Kumaran: Sorry, and I interrupted you.
308 00:34:00.900 ⇒ 00:34:03.080 Luke Daque: Yeah, no worries, but
309 00:34:04.670 ⇒ 00:34:12.039 Luke Daque: can’t remember. But I think one more thing, I think there’s there’s still a worse. I’m I was still doing the Klavio
310 00:34:12.230 ⇒ 00:34:13.900 Luke Daque: manual source.
311 00:34:13.900 ⇒ 00:34:14.530 Uttam Kumaran: Oh, okay.
312 00:34:14.530 ⇒ 00:34:24.060 Luke Daque: For the pool parts. Should should we be like moving that the most managing 4 parts? Now, yeah.
313 00:34:25.290 ⇒ 00:34:29.639 Luke Daque: let me check what that was, I think that was the Revenue Clay View Revenue.
314 00:34:30.699 ⇒ 00:34:31.944 Uttam Kumaran: Yeah, I guess.
315 00:34:34.359 ⇒ 00:34:38.819 Uttam Kumaran: Can. You just slack me in the pool parts channel with that, and I’ll trying to hand it off.
316 00:34:38.820 ⇒ 00:34:39.889 Luke Daque: Yeah, sure.
317 00:34:40.239 ⇒ 00:34:42.590 Luke Daque: Yeah, it’s the Klavio revenue.
318 00:34:43.607 ⇒ 00:34:50.070 Luke Daque: I think that’s the only thing that we haven’t automated. One of the sources.
319 00:34:51.960 ⇒ 00:34:55.950 Luke Daque: Yeah, there was one more thing. But yeah, I’ll maybe just slack you once I if I remember it.
320 00:34:58.080 ⇒ 00:34:58.690 Uttam Kumaran: Okay.
321 00:34:58.690 ⇒ 00:35:06.319 Caio Velasco: Quick, quick question, Tom. For the venue portable selecting. Should I tag Ethan, or someone else, or just run it.
322 00:35:06.320 ⇒ 00:35:11.900 Uttam Kumaran: You can just tag. Ethan is a CEO. You can tag him. He’ll respond. Yeah.
323 00:35:12.930 ⇒ 00:35:14.280 Caio Velasco: Okay. Cool. Thanks.
324 00:35:16.180 ⇒ 00:35:22.950 Uttam Kumaran: Okay. Awesome. Thanks, guys. I know we have just the 2 standups. And then I’m I’m beyond all day. So yeah, feel free to stop me.
325 00:35:23.610 ⇒ 00:35:24.220 Luke Daque: Nothing.
326 00:35:24.690 ⇒ 00:35:25.220 Uttam Kumaran: Thanks.