Meeting Title: Uttam_Jakob Date: 2025-02-18 Meeting participants: Jakob Kagel, Uttam Kumaran
WEBVTT
1 00:04:26.630 ⇒ 00:04:27.690 Jakob Kagel: Yo.
2 00:04:28.660 ⇒ 00:04:29.620 Uttam Kumaran: No.
3 00:04:29.960 ⇒ 00:04:31.030 Jakob Kagel: What’s up?
4 00:04:31.100 ⇒ 00:04:34.009 Uttam Kumaran: What up, dude? How’s it going.
5 00:04:35.110 ⇒ 00:04:45.419 Jakob Kagel: I was. It was entertaining. It’s like, I won’t talk too much about it. But at home depot it’s like some crazy like politics
6 00:04:45.620 ⇒ 00:04:49.209 Jakob Kagel: with this like I don’t know. It’s like when it’s 1 team.
7 00:04:49.210 ⇒ 00:04:49.900 Uttam Kumaran: No.
8 00:04:49.900 ⇒ 00:04:57.920 Jakob Kagel: Another team owns some data that you rely on. Like, you know, it’s like we need this like payments data for like our segmentation model. And they’re like.
9 00:04:58.200 ⇒ 00:04:59.580 Jakob Kagel: yeah, like.
10 00:05:00.580 ⇒ 00:05:09.940 Jakob Kagel: basically, you ask them to do something. And then it’s like they kick the can on this like these people kick the can on this like in a way that I’ve just like. I’ve never seen this before, like.
11 00:05:10.216 ⇒ 00:05:19.069 Uttam Kumaran: Dude. It’s so crazy because you’re like dude. Don’t we play for the same fucking team? But then you’d be surprised because that team’s roadmap will be like 0, and they’re like.
12 00:05:19.070 ⇒ 00:05:19.530 Jakob Kagel: Right.
13 00:05:19.530 ⇒ 00:05:21.550 Uttam Kumaran: Fired. So like, let’s just sandbag.
14 00:05:22.320 ⇒ 00:05:49.999 Jakob Kagel: Yeah, I mean that. I mean, like, I don’t know exactly. But it it’s just like, Yeah, I don’t know that. There, it’s wild. And then, just like the incompetence of like some of these people is like mind boggling to where they’re like. Do they promise something like they kick it to another team. And then this team is like is like it team or whatever. And they’re like, yeah, okay, we can implement it. We’ll implement it in a month, and then in a month you ask them like, Okay, why is it not implemented now, on the day that you said it was, gonna be
15 00:05:50.600 ⇒ 00:05:57.920 Jakob Kagel: a whole month to work on it. And then they’re like, Okay, yeah, like, we kick it to this other team or whatever like.
16 00:05:58.260 ⇒ 00:06:13.800 Jakob Kagel: And then, because their excuse was like, they’re like, we don’t have right access for the table. I’m like, Bro. You had a month like you didn’t know you didn’t have access to right to this table like, what are you talking about like this is insane like a month like.
17 00:06:14.510 ⇒ 00:06:16.189 Uttam Kumaran: Just like log into the thing.
18 00:06:16.330 ⇒ 00:06:24.119 Jakob Kagel: Yeah, I did like, they’re like, Oh, yeah, we’re done with discovery. It’s gonna take us a month like to do this. I’m like, Okay.
19 00:06:24.120 ⇒ 00:06:25.850 Uttam Kumaran: It’s a fucking thing.
20 00:06:25.850 ⇒ 00:06:26.960 Jakob Kagel: You have my.
21 00:06:26.960 ⇒ 00:06:27.620 Uttam Kumaran: Let’s go.
22 00:06:27.620 ⇒ 00:06:38.390 Jakob Kagel: Didn’t try to see if you could like. I don’t know. Have access to the table or something, anyway. Yeah, yeah, whatever it you know you. You got your own sort of.
23 00:06:38.795 ⇒ 00:06:43.254 Uttam Kumaran: We have a, we have a version, mini version of this.
24 00:06:43.660 ⇒ 00:06:51.270 Jakob Kagel: Yeah, man, I mean, yeah, I mean, I’m really trying to. I’m trying my best man. It is just challenging, though, you know, I mean? Because it’s like.
25 00:06:51.510 ⇒ 00:06:58.630 Jakob Kagel: I don’t want to sort of like, make these dashboards and stuff. And then somebody comes back to me. And it’s like, Okay, why are these numbers? Not right? You know. So.
26 00:06:58.630 ⇒ 00:06:59.189 Uttam Kumaran: No, no.
27 00:06:59.190 ⇒ 00:07:13.369 Jakob Kagel: Having to go into the tables and like, sort of, you know, validate like these fields and stuff. And I don’t want to just be the person that’s always like pointing out like, Hey, like this is wrong, or like this is not matching this, or like, you know, whatever. But it’s just like.
28 00:07:13.370 ⇒ 00:07:14.460 Uttam Kumaran: No, it’s true.
29 00:07:14.460 ⇒ 00:07:34.939 Jakob Kagel: Right? It’s like, yeah. And I’m happy to like on some of the engineering stuff. I mean, I’m not like, you know, the most like super super technical. But like, I really just need somebody to show me like a couple of things, or whatever like one time. And I’m happy to sort of like help more in that role, too, if that’s like kind of more, the support that you need.
30 00:07:36.130 ⇒ 00:07:42.260 Jakob Kagel: But yeah, exactly. It’s just like there’s no point in us even building it. If it’s not, the numbers are not going to be right.
31 00:07:42.260 ⇒ 00:07:48.030 Uttam Kumaran: No, we’re gonna get better at like what our data mart structure is. And this client
32 00:07:49.140 ⇒ 00:07:52.800 Uttam Kumaran: we sort of just got. And we sort of started in a weird place where.
33 00:07:52.990 ⇒ 00:07:53.660 Jakob Kagel: Yeah.
34 00:07:53.660 ⇒ 00:07:56.279 Uttam Kumaran: Try to build some stuff, but we never did the background work.
35 00:07:57.044 ⇒ 00:08:03.139 Uttam Kumaran: It’s also prime. It was prime, you know, primarily pie setting was driving a lot, but he’s a lot. He’s less involved now.
36 00:08:03.310 ⇒ 00:08:04.060 Jakob Kagel: Right.
37 00:08:04.670 ⇒ 00:08:08.250 Uttam Kumaran: And like, yeah, there’s just issues. So I I just wanna get through these 2
38 00:08:08.380 ⇒ 00:08:13.249 Uttam Kumaran: build up any sort of data modeling stuff we need in order to do that, and then keep going.
39 00:08:13.420 ⇒ 00:08:33.810 Jakob Kagel: Sounds good man. Alright cool. Well, yeah, let’s talk about it real quick. I think the 1st thing right. I think so. Pies had posted like in the slack. Right? There’s like, basically, he was saying, there’s like 2 options. We could do right with Meta base. I think one is right that we were connected to like analytics right now, and we connect to the other one. And then here, let me pull up what he said. Right?
40 00:08:37.110 ⇒ 00:08:39.290 Uttam Kumaran: If I do, the second option.
41 00:08:39.710 ⇒ 00:08:46.290 Uttam Kumaran: Does that help you at all? Or does that like like? Is it just how it works to start replacing stuff. The new country.
42 00:08:46.290 ⇒ 00:08:52.609 Jakob Kagel: Sorry I found it so. The second option is, try and set up the data connection to Snowflake for the new table from scratch
43 00:08:53.980 ⇒ 00:08:56.409 Uttam Kumaran: Does that like destroy.
44 00:08:56.410 ⇒ 00:08:59.420 Jakob Kagel: That. Oh, he sent it here. Okay, hold on.
45 00:08:59.730 ⇒ 00:09:00.710 Jakob Kagel: Yeah.
46 00:09:06.000 ⇒ 00:09:11.170 Jakob Kagel: whatever you did before to sync analytics to Probmart. So what did you do before. Exactly.
47 00:09:11.280 ⇒ 00:09:16.289 Jakob Kagel: cause you said it got stuck right like you said you synced it. But then there was like an error. Basically.
48 00:09:16.290 ⇒ 00:09:18.360 Uttam Kumaran: Yeah, I mean, I just go and change this.
49 00:09:19.600 ⇒ 00:09:23.769 Uttam Kumaran: But I did this, and then it like fucked up like every single view. So I change it back.
50 00:09:24.270 ⇒ 00:09:25.240 Jakob Kagel: Okay.
51 00:09:25.730 ⇒ 00:09:29.639 Uttam Kumaran: So what I can do is I can just create a new one when it’s a broad march.
52 00:09:29.900 ⇒ 00:09:35.279 Jakob Kagel: So can I just ask a quick question, real quick. So what’s the purpose of having analytics and prod marks like.
53 00:09:35.280 ⇒ 00:09:39.119 Uttam Kumaran: No purpose. We we’re moving to a new structure.
54 00:09:39.330 ⇒ 00:09:43.670 Uttam Kumaran: Cause like Anna, we’re moving to new structure that we have broad staging and dev environments.
55 00:09:43.670 ⇒ 00:09:44.480 Jakob Kagel: Right.
56 00:09:44.480 ⇒ 00:10:00.660 Uttam Kumaran: So we re, we just created a new one called Prodmarts, which is the active one. This needs to get deprecated. I can’t deprecate it because Meta Base is pointing to it. I can’t change Meta Base from pointing to it, because Meta Base is a piece of fucking shit and like, I hate having to deal with this.
57 00:10:01.130 ⇒ 00:10:01.650 Jakob Kagel: Yeah.
58 00:10:01.650 ⇒ 00:10:07.799 Uttam Kumaran: I tried to change this, but then I have to go into 80 fucking questions and move them over.
59 00:10:07.970 ⇒ 00:10:11.149 Uttam Kumaran: And I tried to do that yesterday last night, and it didn’t work.
60 00:10:12.270 ⇒ 00:10:12.830 Jakob Kagel: Okay.
61 00:10:12.830 ⇒ 00:10:23.110 Uttam Kumaran: I have to listen to a pep. Talk about why I need to accommodate for that which I’m not here to listen to. And so I’m like, okay, what can I do? Can I either? I can make a new connection here
62 00:10:24.300 ⇒ 00:10:28.579 Uttam Kumaran: and then can you just swap that in, or is it like you have to rebuild everything.
63 00:10:30.370 ⇒ 00:10:54.640 Jakob Kagel: I, honestly, I don’t know. I mean I assume it could just be swapped in, but I don’t know, because there, I mean there is the possibility. Right? Then, if you swap it out like that, that, I feel like all the tables, basically like all the existing dashboard views, basically go blank right? So I don’t know if that’s something that we can sort of like easily, like test right where we can maybe just like.
64 00:10:54.640 ⇒ 00:10:56.711 Uttam Kumaran: I’m gonna make. I’m gonna make the new one, and then
65 00:10:56.900 ⇒ 00:11:04.929 Jakob Kagel: Right cause we, if we can do it. It’s not a big deal. If we can easily switch it back. You know what I don’t want to do is basically do something
66 00:11:05.080 ⇒ 00:11:17.950 Jakob Kagel: like that where it’s like we do a bunch of steps. And then it’s like everything breaks and we can’t switch it back. I mean, I wanna let’s just talk about maybe 2 like sort of like the like, what is already good in there and then, like.
67 00:11:18.250 ⇒ 00:11:22.419 Uttam Kumaran: Yeah, so can I. Can. I ask you, can you go through this?
68 00:11:22.580 ⇒ 00:11:25.179 Uttam Kumaran: So I had Nico set this up.
69 00:11:25.180 ⇒ 00:11:26.140 Jakob Kagel: Right, yeah.
70 00:11:27.220 ⇒ 00:11:28.870 Uttam Kumaran: I like.
71 00:11:29.310 ⇒ 00:11:33.809 Uttam Kumaran: It’s really not valuable, though, like so the way it is, cause like
72 00:11:34.830 ⇒ 00:11:37.630 Uttam Kumaran: this is like sum 4, some 5 like.
73 00:11:38.190 ⇒ 00:11:47.956 Uttam Kumaran: I just really wanted to see, like what metrics are in this dashboard. And then, which metrics are still giving us issues.
74 00:11:48.980 ⇒ 00:12:12.160 Jakob Kagel: And that’s exactly what I was gonna like. Talk about, too. I mean, I think what he did is like is not bad here. I mean, I think it is good if we sort of like when we finish, at least like with this cogs here, I mean, I’ll go through and and update this. I mean, I think he, he took everything, basically from metabase. So I think the only thing that has to be updated is cogs. But I do think it’s good if we have like.
75 00:12:12.300 ⇒ 00:12:15.680 Jakob Kagel: like a clear like definition, or like.
76 00:12:16.020 ⇒ 00:12:23.460 Jakob Kagel: you know, we were basically like aligned on definitions, because that was kind of like a big thing that we had to go back and forth on a lot too.
77 00:12:23.460 ⇒ 00:12:29.539 Uttam Kumaran: No, that’s that’s exactly like I wanted this dashboard to be the place where this this document to be, the place where we could talk about
78 00:12:29.800 ⇒ 00:12:33.690 Uttam Kumaran: the definitions in one piece, just like within this week.
79 00:12:34.345 ⇒ 00:12:35.870 Uttam Kumaran: But still, like I don’t.
80 00:12:36.480 ⇒ 00:12:38.209 Uttam Kumaran: I don’t think this is like
81 00:12:39.550 ⇒ 00:12:42.740 Uttam Kumaran: I feel like I still have to make a bunch of changes to this like.
82 00:12:43.310 ⇒ 00:12:45.309 Jakob Kagel: What do you think like? What? What do you mean? Because.
83 00:12:45.310 ⇒ 00:12:48.060 Uttam Kumaran: For example, like, why do I have 2
84 00:12:49.390 ⇒ 00:12:52.299 Uttam Kumaran: product weight in pounds, product weight in pounds around it?
85 00:12:52.760 ⇒ 00:12:56.329 Jakob Kagel: Yeah, but that’s not his fault. I don’t think I mean that was so. I mean.
86 00:12:56.330 ⇒ 00:13:01.540 Uttam Kumaran: It’s like what I would rather this be is just like we need to make sure that product
87 00:13:03.950 ⇒ 00:13:07.590 Uttam Kumaran: wait is somewhere right.
88 00:13:07.880 ⇒ 00:13:11.580 Uttam Kumaran: And then what I can do. I can, I can say, cool. This is the
89 00:13:12.280 ⇒ 00:13:17.859 Uttam Kumaran: this is the table. And I can tell you that product weight is coming from whatever it was like
90 00:13:18.730 ⇒ 00:13:20.030 Uttam Kumaran: back orders.
91 00:13:23.270 ⇒ 00:13:26.800 Uttam Kumaran: This is what I want. Yeah, right?
92 00:13:28.210 ⇒ 00:13:33.100 Uttam Kumaran: Cause, this is so much easier because I can just tell you, okay, you want product weight there, because I don’t.
93 00:13:33.230 ⇒ 00:13:36.469 Uttam Kumaran: I don’t care that you use it in some 2 and some 3.
94 00:13:36.680 ⇒ 00:13:41.919 Uttam Kumaran: I’m sort of like you want product weight, and I’ll I’ll just make sure. Product weights here, here’s where you can get it.
95 00:13:42.590 ⇒ 00:13:47.609 Uttam Kumaran: And that’s sort of like that’s a translation, right? That’s not happening.
96 00:13:48.140 ⇒ 00:14:00.800 Jakob Kagel: Right. I see what you’re saying that it’s like hard to read. Yeah, for sure. I mean, I don’t know why there’s product weight and product weight around it. But when I asked Pius about it, he said, basically to use both. But I don’t see how that makes sense, because.
97 00:14:00.800 ⇒ 00:14:05.870 Uttam Kumaran: That’s the question is like, I think it’s really clear to be like, okay here. If we have product weight
98 00:14:06.170 ⇒ 00:14:10.200 Uttam Kumaran: rounded, then I’ll then I might. I’m gonna leave a comment that’s like.
99 00:14:11.490 ⇒ 00:14:13.690 Uttam Kumaran: What is this? Right? And so I can go look.
100 00:14:13.850 ⇒ 00:14:14.200 Jakob Kagel: Right.
101 00:14:14.200 ⇒ 00:14:17.579 Uttam Kumaran: Like what’s going on, or I can be like. Seems like we’re over counting.
102 00:14:18.830 ⇒ 00:14:20.960 Jakob Kagel: Right? Yeah, exactly.
103 00:14:23.000 ⇒ 00:14:28.628 Jakob Kagel: But yeah. So I’m looking through to like the feedback that he gave like on the ones.
104 00:14:29.310 ⇒ 00:14:45.289 Jakob Kagel: that like, I worked on right? So it’s really we clarified on Number one, which was just like the shipping revenue piece. So my understanding is like to add shipping discounted price as shipping revenue.
105 00:14:45.290 ⇒ 00:14:46.190 Uttam Kumaran: Yes.
106 00:14:46.390 ⇒ 00:14:54.870 Jakob Kagel: Right. So that’s clarified. And that’s how I have it already. So that doesn’t have to get changed. It was just a clarification. And then.
107 00:14:55.880 ⇒ 00:15:04.620 Jakob Kagel: I mean, I don’t know. Do you want to go through like just a whole list of things? Or do you want to just focus on the cogs. I mean, the cogs is probably like 90% of the like value.
108 00:15:04.620 ⇒ 00:15:10.170 Uttam Kumaran: Can we like? Do you think it’s? Can we just go through this this thing?
109 00:15:11.450 ⇒ 00:15:12.550 Uttam Kumaran: And like.
110 00:15:12.980 ⇒ 00:15:16.600 Uttam Kumaran: I think this is, there’s I don’t think there’s another way for us to just sort of be like
111 00:15:17.550 ⇒ 00:15:20.769 Uttam Kumaran: these 5 things need to get ironed out, and that’ll be super.
112 00:15:21.760 ⇒ 00:15:23.499 Uttam Kumaran: It’ll just be a little bit clearer.
113 00:15:23.830 ⇒ 00:15:29.200 Uttam Kumaran: like I mean, I don’t know that there’s like, I think probably half of these are like duplicates. So
114 00:15:29.330 ⇒ 00:15:37.270 Uttam Kumaran: let’s just look like this is just fully loaded order value line item price.
115 00:15:37.530 ⇒ 00:15:41.140 Uttam Kumaran: I’m basically gonna go. And do you know what I’m gonna do is I’m gonna.
116 00:15:41.140 ⇒ 00:15:56.549 Jakob Kagel: The fully loaded order value is just the full like, it’s the fully loaded gross margin. It’s just the dollar amount instead of like the percentage. So it’s like the average order value minus all of those fields is what that is.
117 00:15:57.760 ⇒ 00:16:03.059 Jakob Kagel: And he said, That’s good to go. I mean that that is fine. He looked at that and said, It’s fine.
118 00:16:04.590 ⇒ 00:16:08.860 Uttam Kumaran: Okay, I’m just gonna I just put into chat to give me like the entire list.
119 00:16:10.830 ⇒ 00:16:11.849 Uttam Kumaran: Let me just paste it.
120 00:16:11.850 ⇒ 00:16:20.850 Jakob Kagel: I mean, I can tell you what the list is, honestly, because it’s probably only I mean, it’s really only 2 things. It’s like the fully loaded gross margin, and then it’s like the net sales.
121 00:16:21.390 ⇒ 00:16:23.969 Uttam Kumaran: For example, like order shipping costs, do you?
122 00:16:24.650 ⇒ 00:16:26.840 Uttam Kumaran: That needs to be like figured out right.
123 00:16:27.290 ⇒ 00:16:30.305 Jakob Kagel: No, that’s fine. As far as I know.
124 00:16:30.640 ⇒ 00:16:32.539 Uttam Kumaran: But I guess fine meaning like.
125 00:16:33.850 ⇒ 00:16:38.979 Jakob Kagel: Yes, that field exists. In fact, orders is what I’m saying when I’m saying it’s fine.
126 00:16:39.590 ⇒ 00:16:45.480 Uttam Kumaran: I guess I want this document to just show any field you’re pulling into this dashboard. Basically.
127 00:16:45.480 ⇒ 00:16:46.000 Jakob Kagel: Sure.
128 00:16:46.000 ⇒ 00:16:48.790 Uttam Kumaran: Even if the field is okay, right? Yeah.
129 00:16:49.110 ⇒ 00:16:53.019 Uttam Kumaran: because it may be okay. Now and then, when we someone, someone
130 00:16:53.280 ⇒ 00:16:56.890 Uttam Kumaran: when we say it’s good. It’s gonna be like that’s not good. And then I want it to be like.
131 00:16:57.420 ⇒ 00:17:00.749 Uttam Kumaran: Okay, put in here. Why, it’s not working.
132 00:17:01.250 ⇒ 00:17:01.840 Jakob Kagel: Yeah.
133 00:17:01.840 ⇒ 00:17:05.809 Uttam Kumaran: Cross correlate to what we do know about this metric right?
134 00:17:05.849 ⇒ 00:17:10.950 Jakob Kagel: Sure. Yeah, okay, well, I can help you. We can do that right now, really fast on.
135 00:17:10.950 ⇒ 00:17:11.349 Uttam Kumaran: Okay.
136 00:17:11.569 ⇒ 00:17:16.919 Jakob Kagel: I would just say everything that’s fully loaded. Gross margin is coming from fact orders.
137 00:17:17.149 ⇒ 00:17:21.129 Jakob Kagel: So if you want to just drag that fact orders table down.
138 00:17:22.140 ⇒ 00:17:27.460 Uttam Kumaran: So this is the table. So then I want, yeah. So then I guess, like, okay, so all this is coming from.
139 00:17:28.820 ⇒ 00:17:34.679 Uttam Kumaran: Okay, all of this is basically so different. It’s like calculations. I’m gonna just say, this is like a
140 00:17:35.270 ⇒ 00:17:36.510 Uttam Kumaran: calculation.
141 00:17:36.960 ⇒ 00:17:37.720 Jakob Kagel: Right.
142 00:17:58.230 ⇒ 00:18:01.070 Uttam Kumaran: Let me just go through and label. The calculations
143 00:18:18.790 ⇒ 00:18:25.410 Uttam Kumaran: feel like this is something that should end up in the right.
144 00:18:27.970 ⇒ 00:18:38.699 Jakob Kagel: Yeah, I mean, I I think this kind of documentation would be very helpful for sure. I mean, especially as we go forward. I mean, that’s the thing like about the ticket, like, too. It’s like, okay.
145 00:18:40.250 ⇒ 00:18:43.629 Jakob Kagel: word word vomit, basically. But he.
146 00:18:43.630 ⇒ 00:18:45.480 Uttam Kumaran: No, it didn’t have anything in it like.
147 00:18:45.480 ⇒ 00:18:49.629 Jakob Kagel: Ticket, and there’s no like, Yeah, there’s no definitions or like, you know.
148 00:18:49.830 ⇒ 00:18:56.170 Jakob Kagel: And I mean, I’m not like, yeah, I mean, I’m not really complaining, or whatever. But I’m just saying like, Yeah, we could do it better for sure.
149 00:19:08.660 ⇒ 00:19:12.680 Uttam Kumaran: Okay, can you just help me like, let’s just rip through cleaning this.
150 00:19:12.680 ⇒ 00:19:16.519 Jakob Kagel: Yeah, yeah, I can pull it up. I can open it, too.
151 00:19:17.400 ⇒ 00:19:18.060 Uttam Kumaran: Yeah.
152 00:19:18.520 ⇒ 00:19:19.810 Jakob Kagel: Yeah, sure thing.
153 00:19:38.810 ⇒ 00:19:40.250 Uttam Kumaran: Like this is
154 00:19:47.070 ⇒ 00:19:53.249 Jakob Kagel: I mean, some of them are confusing, maybe because there’s like, you know, there’s like aggregations that you have to do in Meta Base, or whatever.
155 00:19:53.250 ⇒ 00:19:56.280 Jakob Kagel: That’s fine. I just sort of know what column and what the
156 00:19:56.280 ⇒ 00:19:58.220 Jakob Kagel: only care about the columns. Then, yeah.
157 00:19:58.220 ⇒ 00:20:04.419 Uttam Kumaran: So I guess I want to know, like one of the basically like the dashboard question, I want to know.
158 00:20:04.610 ⇒ 00:20:07.510 Uttam Kumaran: sort of like, what the Meta base.
159 00:20:08.310 ⇒ 00:20:14.000 Uttam Kumaran: like what is this called? This is called a metric name, Meta, base metric.
160 00:20:14.350 ⇒ 00:20:16.360 Uttam Kumaran: This is like the
161 00:20:21.940 ⇒ 00:20:24.480 Uttam Kumaran: for example, this is a calculation.
162 00:20:34.120 ⇒ 00:20:36.429 Uttam Kumaran: and these are all sums, right? Basically.
163 00:20:38.800 ⇒ 00:20:40.440 Jakob Kagel: Yeah, those are, yeah.
164 00:20:43.660 ⇒ 00:20:45.540 Uttam Kumaran: Oh, this would be cogs
165 00:21:52.160 ⇒ 00:21:58.349 Uttam Kumaran: like what Meta base should I just get rid of Meta? Base metric column like.
166 00:22:00.974 ⇒ 00:22:06.949 Jakob Kagel: Hold on. Sorry. I’m just working on the sheet, but sorry. Which column is that there’s gonna be column C here.
167 00:22:06.950 ⇒ 00:22:10.180 Uttam Kumaran: Because, like, yeah, like, I guess I don’t really.
168 00:22:11.210 ⇒ 00:22:12.790 Jakob Kagel: Yeah, I mean, I would. I would rewrite.
169 00:22:12.790 ⇒ 00:22:20.539 Uttam Kumaran: It’s like on the only yeah. I don’t care about what it’s really called in Meta base, like I care about the question, I guess, but
170 00:22:23.440 ⇒ 00:22:26.630 Uttam Kumaran: like having it be some one, some 2, some 3. It’s like.
171 00:22:26.940 ⇒ 00:22:31.959 Jakob Kagel: Who cares? Yeah, it’s like, we just care about the fields and where they’re coming from. Basically, yeah.
172 00:22:33.070 ⇒ 00:22:35.820 Uttam Kumaran: So let’s just. I’ll just make sure that these are all.
173 00:22:35.820 ⇒ 00:22:44.650 Jakob Kagel: Highlighting the cogs ones, because these are the like fields. So we can just not. You know, we have to update those completely, anyway. So.
174 00:22:49.890 ⇒ 00:22:54.490 Jakob Kagel: and then I don’t know. I mean, there’s a lot of stuff that he included in here, too. That’s like
175 00:22:56.650 ⇒ 00:23:00.629 Jakob Kagel: I would say, work in progress. That’s not really like.
176 00:23:00.800 ⇒ 00:23:04.550 Jakob Kagel: I mean, it’s fine. I don’t think it’s a big deal, because they’re all like
177 00:23:04.840 ⇒ 00:23:07.579 Jakob Kagel: sort of the best version of what we have. But
178 00:23:08.520 ⇒ 00:23:14.919 Jakob Kagel: like the product, category and stuff like that. All has the same deprecated cogs, too. So I just have to
179 00:23:15.210 ⇒ 00:23:16.780 Jakob Kagel: highlight all that.
180 00:25:03.650 ⇒ 00:25:04.610 Uttam Kumaran: Alright. You, too.
181 00:25:11.930 ⇒ 00:25:13.380 Uttam Kumaran: So like, okay.
182 00:25:13.870 ⇒ 00:25:16.530 Uttam Kumaran: But these are all duplicates, right? Like.
183 00:25:17.330 ⇒ 00:25:19.200 Jakob Kagel: Sorry I can’t see. Okay.
184 00:25:19.580 ⇒ 00:25:25.750 Jakob Kagel: what you’re saying right there on fully loaded gross margin. Yeah, exactly. Because it’s the same thing. It’s just yeah.
185 00:25:25.750 ⇒ 00:25:26.880 Uttam Kumaran: So.
186 00:25:28.270 ⇒ 00:25:31.380 Jakob Kagel: I mean, I can tell you there’s really only it’s those fields.
187 00:25:31.380 ⇒ 00:25:38.860 Uttam Kumaran: Like. I don’t. I don’t, I guess, like that’s why I don’t. I don’t really care about like what question it goes into. I just wanna make sure that the metric
188 00:25:39.250 ⇒ 00:25:42.609 Uttam Kumaran: you have to find is accurate. So like, can I just get rid of like
189 00:25:42.820 ⇒ 00:25:45.320 Uttam Kumaran: all? Can I just get rid of like all of these.
190 00:25:45.570 ⇒ 00:25:55.400 Jakob Kagel: I would just start a new tab here. And I’m just gonna I can just copy over like the fields. And I can do this in like 30 seconds, and I can show you, and I can explain to you, like how everything is calculated.
191 00:25:55.400 ⇒ 00:25:58.269 Uttam Kumaran: Let’s just get rid of. Just get rid of the ones out of here.
192 00:25:59.250 ⇒ 00:26:00.962 Uttam Kumaran: That’s fine. I mean
193 00:26:01.390 ⇒ 00:26:04.299 Uttam Kumaran: because I don’t get this. I’m not married to this. I want to just have it be like.
194 00:26:04.300 ⇒ 00:26:04.930 Jakob Kagel: That’s work. Yeah.
195 00:26:04.930 ⇒ 00:26:10.509 Uttam Kumaran: Not clear with like what you need. So I’m just gonna get rid of the lines. 13.
196 00:26:10.510 ⇒ 00:26:25.770 Jakob Kagel: I would say, like the yeah. You can delete that whole like 13 to 21. And then in the dashboard question, where you have fully loaded gross margin, you can say, fully loaded, gross margin, comma gross like, fully loaded Aov or whatever.
197 00:26:26.330 ⇒ 00:26:30.770 Jakob Kagel: Yeah, you can just add it in there, because it’s the same fields, you know.
198 00:26:35.230 ⇒ 00:26:36.429 Uttam Kumaran: Perfect. So it’s what.
199 00:26:36.430 ⇒ 00:26:36.810 Jakob Kagel: Yeah.
200 00:26:40.870 ⇒ 00:26:42.900 Uttam Kumaran: Refund percentage.
201 00:26:42.900 ⇒ 00:26:46.460 Jakob Kagel: Yeah, refund percentage is like, really by itself, like.
202 00:26:46.700 ⇒ 00:26:58.337 Jakob Kagel: that’s how they told me to calculate. It. Basically was with this, like, minus discounts, like, you know, to do the net sales, and then just do the percent refund out of that
203 00:26:58.690 ⇒ 00:27:06.170 Uttam Kumaran: So can we build like, for example, having to say some is not really helpful. So can we just build the calculation here based on these.
204 00:27:06.170 ⇒ 00:27:07.940 Jakob Kagel: Yeah, totally. So it’s just.
205 00:27:07.940 ⇒ 00:27:12.729 Uttam Kumaran: And I’m then I’m just gonna ditch these. Well, I guess we just need to shop of shipping discounted price.
206 00:27:12.730 ⇒ 00:27:16.879 Jakob Kagel: No, I would just keep. Yeah. I would just keep the field names exactly like.
207 00:27:18.230 ⇒ 00:27:22.549 Uttam Kumaran: Well, because the thing is is like these are all above here. These are all here.
208 00:27:23.810 ⇒ 00:27:27.460 Uttam Kumaran: That’s why I’m almost like a dashboard question. I don’t really care about.
209 00:27:27.950 ⇒ 00:27:31.779 Uttam Kumaran: because the only net new thing is refund percentage. The metric.
210 00:27:34.320 ⇒ 00:27:37.990 Jakob Kagel: Okay, I mean, I’m fine. However, you want to organize it. Yeah.
211 00:27:37.990 ⇒ 00:27:43.300 Uttam Kumaran: I’m I’m almost like total total line items. Price. We already have
212 00:27:44.360 ⇒ 00:27:50.219 Uttam Kumaran: refund amount. We don’t have total discounts. We don’t have order shipping cost we do have above
213 00:27:50.700 ⇒ 00:27:55.440 Uttam Kumaran: shipping discounted price, so total discounts.
214 00:27:55.840 ⇒ 00:28:02.699 Uttam Kumaran: Let me find them once, and then that way I can do shipping discounted price, and that way
215 00:28:02.930 ⇒ 00:28:04.119 Uttam Kumaran: I can move.
216 00:28:05.630 ⇒ 00:28:11.030 Uttam Kumaran: I’m almost like, okay, I’m just gonna move these up in here.
217 00:28:17.800 ⇒ 00:28:20.050 Uttam Kumaran: So take this one with me up here.
218 00:28:20.840 ⇒ 00:28:26.360 Uttam Kumaran: So if you can just make this calculation just be like, actually what it is is using these words
219 00:28:26.600 ⇒ 00:28:27.810 Uttam Kumaran: that would be fire.
220 00:28:28.370 ⇒ 00:28:32.180 Jakob Kagel: Yeah, sure. So on number 16, yeah, I got you.
221 00:30:25.780 ⇒ 00:30:28.829 Uttam Kumaran: So all of these online, 30 to 39, can I delete.
222 00:30:31.230 ⇒ 00:30:33.440 Jakob Kagel: 30 to 39 like.
223 00:30:33.440 ⇒ 00:30:35.859 Uttam Kumaran: You’re the same thing as 18 to 27.
224 00:30:35.860 ⇒ 00:30:42.279 Jakob Kagel: Fields. I mean, they’re they’re the deprecated ones, anyway. So yeah, I mean, I would say, just delete them. Yeah.
225 00:30:57.840 ⇒ 00:31:00.179 Uttam Kumaran: And we’re down to 50 now. Great.
226 00:33:10.950 ⇒ 00:33:20.989 Jakob Kagel: But yeah, it’s really just I mean, it’s really just those 3 calculations like gross margin net sales and cogs.
227 00:33:21.310 ⇒ 00:33:25.989 Jakob Kagel: And then it’s just like trying to do the different splits like, based on those.
228 00:33:26.110 ⇒ 00:33:28.429 Jakob Kagel: Oh, that’s it. Yeah.
229 00:33:30.430 ⇒ 00:33:32.319 Jakob Kagel: So I updated.
230 00:33:33.270 ⇒ 00:33:36.610 Uttam Kumaran: Alright, just like sorted. I just basically like sorted the whole thing.
231 00:33:38.440 ⇒ 00:33:44.720 Uttam Kumaran: Just so I can see. Like, if there’s any duplicates like cogs product costs. I can delete this one.
232 00:33:46.950 ⇒ 00:33:59.879 Uttam Kumaran: This one I can delete order box costs delete. This one order, pick costs delete this one
233 00:34:11.909 ⇒ 00:34:17.260 Uttam Kumaran: populations basically rest of them.
234 00:34:26.060 ⇒ 00:34:31.580 Jakob Kagel: Yeah, I I kind of feel like you should have like one. That’s just the the
235 00:34:32.100 ⇒ 00:34:38.749 Jakob Kagel: fields. And then you should have like another table that’s separate. That’s below it. That’s the calculations.
236 00:34:40.844 ⇒ 00:34:43.790 Uttam Kumaran: I see. Yeah, I mean, ideally, I wanna see one.
237 00:34:44.420 ⇒ 00:34:49.250 Uttam Kumaran: We want to know what dimensions you need, what metrics you need and what your calculations are. Then we saw.
238 00:34:49.469 ⇒ 00:34:55.120 Jakob Kagel: If you do it this way, too. You can like color, code it with like the field names or the tables, and then.
239 00:34:55.120 ⇒ 00:34:55.690 Uttam Kumaran: Yeah.
240 00:34:55.699 ⇒ 00:34:59.389 Jakob Kagel: To see like which calculations use. Which table? Yeah.
241 00:35:01.000 ⇒ 00:35:03.729 Uttam Kumaran: So this feels like we’re at the
242 00:35:06.720 ⇒ 00:35:08.609 Uttam Kumaran: we’re kind of at the finish line. Right? Is this.
243 00:35:08.610 ⇒ 00:35:13.789 Jakob Kagel: Yeah, I can. I can clean this up for you. I mean, this is like, I understand what you’re trying to.
244 00:35:13.790 ⇒ 00:35:20.299 Uttam Kumaran: I’m well, I’m trying to see everything. But okay, now, I think let’s work on. Let’s just talk about the ones that are highlighted.
245 00:35:22.140 ⇒ 00:35:22.730 Jakob Kagel: Yeah.
246 00:35:23.040 ⇒ 00:35:33.829 Uttam Kumaran: Like if I was to just create a thing called status. I’m just gonna put the things that are highlighted as broken right for now, so I can sort by it. And let’s just make sure we can go through
247 00:35:34.950 ⇒ 00:35:37.250 Uttam Kumaran: and address all of these.
248 00:35:37.970 ⇒ 00:35:47.210 Jakob Kagel: Yeah, I mean, everything that’s broken should just be addressed by the cogs. Like, basically, if we fix this analytics schema thing.
249 00:35:47.370 ⇒ 00:35:48.050 Uttam Kumaran: Yes.
250 00:35:48.050 ⇒ 00:35:49.770 Jakob Kagel: All that should be fixed.
251 00:35:49.770 ⇒ 00:35:50.340 Uttam Kumaran: Okay.
252 00:35:50.700 ⇒ 00:35:51.720 Jakob Kagel: That’s it. Yeah.
253 00:35:51.720 ⇒ 00:35:55.610 Uttam Kumaran: So great. So it looks like at the moment. It’s just
254 00:35:56.170 ⇒ 00:36:04.279 Uttam Kumaran: all of these ones. The other things I want to look at is like, for example, why are we doing this product category in Meta base
255 00:36:04.800 ⇒ 00:36:07.429 Uttam Kumaran: like, can I? Should I just go ahead and do this? In fact, order.
256 00:36:09.066 ⇒ 00:36:14.880 Jakob Kagel: Sorry. One second. So you’re saying the product category case one product. Name, okay, like, from order line items.
257 00:36:14.880 ⇒ 00:36:21.210 Uttam Kumaran: And then also, you can see here we have 3 different product category calculations.
258 00:36:21.860 ⇒ 00:36:31.420 Jakob Kagel: Right. But these are all for different views, like one of these is, for, like an accessories view, they requested one is, for, like the free gifts like these are all like requests in the ticket.
259 00:36:31.420 ⇒ 00:36:32.490 Uttam Kumaran: Oh, okay. Okay.
260 00:36:32.490 ⇒ 00:36:41.670 Jakob Kagel: So these are all just different views. Yeah, these are not like, like, he doesn’t have the name like like they all have, like, the calculation wouldn’t be like, product name.
261 00:36:41.670 ⇒ 00:36:44.260 Jakob Kagel: I see. Okay, yeah, yeah, exactly. Yeah.
262 00:36:46.220 ⇒ 00:36:47.526 Uttam Kumaran: Okay. So
263 00:36:49.050 ⇒ 00:36:53.640 Uttam Kumaran: alright, let’s fix this thing that we were doing. So I’m just gonna make sure that this is all lined up.
264 00:36:54.130 ⇒ 00:36:54.790 Uttam Kumaran: Oh.
265 00:36:54.790 ⇒ 00:37:02.929 Jakob Kagel: Yeah, while you while you do that here, I’m gonna I’m gonna create a new tab on the sheet. And I’m gonna show you. I think it’ll be like I have the idea of how to like simply.
266 00:37:02.930 ⇒ 00:37:03.490 Uttam Kumaran: Okay.
267 00:37:03.670 ⇒ 00:37:04.710 Uttam Kumaran: Okay. Okay.
268 00:37:05.100 ⇒ 00:37:07.180 Jakob Kagel: So you do that, I’ll do this. Yeah.
269 00:41:21.750 ⇒ 00:41:27.039 Uttam Kumaran: Okay, which it’s there.
270 00:41:27.970 ⇒ 00:41:29.050 Jakob Kagel: Is it working?
271 00:41:29.270 ⇒ 00:41:29.880 Uttam Kumaran: Yeah.
272 00:41:31.520 ⇒ 00:41:33.709 Jakob Kagel: Okay, cool. Hold on. Let me just
273 00:41:34.080 ⇒ 00:41:36.010 Jakob Kagel: look on my end real quick.
274 00:41:59.110 ⇒ 00:42:00.180 Jakob Kagel: So
275 00:42:04.580 ⇒ 00:42:14.150 Jakob Kagel: I’m still seeing Bubble bag cost like I’m I’m still not seeing them. Maybe I have to rescan real quick. But you’re saying, you see it. Hold on!
276 00:42:22.250 ⇒ 00:42:27.830 Jakob Kagel: Do I need to change like hold on! I need to change my database then, or what.
277 00:42:28.120 ⇒ 00:42:31.990 Uttam Kumaran: Well, if you use prodmart snowflake.
278 00:42:33.780 ⇒ 00:42:35.210 Jakob Kagel: The database.
279 00:42:35.870 ⇒ 00:42:37.830 Uttam Kumaran: You shouldn’t see the new cost.
280 00:42:39.520 ⇒ 00:42:44.810 Jakob Kagel: Right? So I guess that’s my question here, can I? Maybe can I share my screen real quick?
281 00:42:44.810 ⇒ 00:42:45.470 Uttam Kumaran: Yeah, yeah.
282 00:42:45.970 ⇒ 00:42:47.280 Jakob Kagel: Okay, hold on
283 00:42:50.320 ⇒ 00:42:52.270 Jakob Kagel: cool. You can see my screen right?
284 00:42:52.270 ⇒ 00:42:52.960 Uttam Kumaran: Yes.
285 00:42:53.440 ⇒ 00:43:02.739 Jakob Kagel: Okay. So if I’m in here and I’m like, Okay, I wanna build like a new question.
286 00:43:03.150 ⇒ 00:43:10.239 Jakob Kagel: Then I still only have, like I have in Javi snowflake prod. Right like is this.
287 00:43:13.176 ⇒ 00:43:15.210 Uttam Kumaran: What the fuck is that.
288 00:43:21.840 ⇒ 00:43:27.860 Uttam Kumaran: One you should see Prog mart Snowflake.
289 00:43:29.880 ⇒ 00:43:33.130 Jakob Kagel: Okay, there it is. Okay. Got it? Okay?
290 00:43:33.590 ⇒ 00:43:42.929 Jakob Kagel: Alright. So then I just have to. I guess, yeah, I just have to rebuild everything from order line with this. But I should. Okay, this is okay. One question, real quick is like.
291 00:43:43.630 ⇒ 00:43:50.640 Jakob Kagel: if I’m building a dashboard I can use right? It doesn’t matter. I can use them from both
292 00:43:51.590 ⇒ 00:43:52.569 Jakob Kagel: like I don’t have.
293 00:43:52.570 ⇒ 00:43:56.469 Uttam Kumaran: Well, I would rather we use everything from Prodmart, Snowflake.
294 00:43:56.470 ⇒ 00:43:57.399 Jakob Kagel: Right, so, then.
295 00:43:57.400 ⇒ 00:44:00.739 Uttam Kumaran: I guess my question is like, Do you have to go? Is that like a
296 00:44:01.170 ⇒ 00:44:03.690 Uttam Kumaran: switch, or is like I gotta rebuild everything.
297 00:44:03.690 ⇒ 00:44:12.600 Jakob Kagel: I think I probably have to rebuild everything I mean. I can check, though. Let’s but let’s look at a an example real quick, and see if it’s like switchable.
298 00:44:15.660 ⇒ 00:44:22.229 Jakob Kagel: So yeah, let’s say, like for cogs accessories here. Any question.
299 00:44:22.500 ⇒ 00:44:30.590 Jakob Kagel: So Jabby Snowflake, hmm, okay, cause this is just fact order line.
300 00:44:31.743 ⇒ 00:44:38.469 Jakob Kagel: Okay? So if I switch this to fact order line from problem marts, okay, it makes me start over.
301 00:44:38.850 ⇒ 00:44:39.580 Uttam Kumaran: Oh!
302 00:44:40.430 ⇒ 00:44:46.229 Jakob Kagel: I mean, it’s fine. It’s not that much like honestly like it’s not that much like to do, I mean, I don’t know.
303 00:44:46.400 ⇒ 00:44:53.740 Jakob Kagel: When do you need it by, though, basically, I mean, I can do it. I can do it by end of day. Tomorrow I can fix all that.
304 00:44:53.740 ⇒ 00:44:55.760 Uttam Kumaran: I’m trying to get this out today.
305 00:44:55.920 ⇒ 00:45:02.210 Jakob Kagel: Day. I mean, I can do it today, but then I need tomorrow off I’ll crank it out tonight.
306 00:45:02.670 ⇒ 00:45:04.529 Uttam Kumaran: Well here, how about we do this?
307 00:45:06.480 ⇒ 00:45:09.160 Uttam Kumaran: I’m gonna I’ll just run the clone
308 00:45:10.930 ⇒ 00:45:15.479 Uttam Kumaran: and let’s just get this out like with still pointing from analytics.
309 00:45:15.820 ⇒ 00:45:20.210 Uttam Kumaran: I’m gonna have some. I’m gonna we’ll figure out doing this migration piece by piece
310 00:45:20.460 ⇒ 00:45:23.280 Uttam Kumaran: later. Cause I just want to get this to them today.
311 00:45:23.540 ⇒ 00:45:25.610 Uttam Kumaran: even if it’s pointing to analytics.
312 00:45:25.970 ⇒ 00:45:28.950 Jakob Kagel: I mean, if we’re gonna do that, I mean, it’s not like.
313 00:45:29.330 ⇒ 00:45:35.180 Uttam Kumaran: We’re gonna have to do it eventually. But like I would rather just like, I’ll keep. We’ll just keep band dating it. It’s fine.
314 00:45:35.920 ⇒ 00:45:44.500 Jakob Kagel: I mean, alright. Well, let’s just talk about real quick. I mean, let’s just talk about like what we’re actually gonna include like in this version of the dashboard, right? I mean.
315 00:45:44.820 ⇒ 00:45:45.900 Jakob Kagel: so
316 00:45:46.400 ⇒ 00:45:58.549 Jakob Kagel: we’re gonna include fully loaded, gross margin, gross margin, Aov refund percent cogs, accessories, cogs, free gifts. Right? That’s 5 views already. Right? So
317 00:45:59.010 ⇒ 00:46:15.069 Jakob Kagel: the ones that I have like still in production that we could include like. And this is like fairly easily. To include, too is just like the net margin, which would be, you know, just based on refund and total discount and shipping.
318 00:46:15.830 ⇒ 00:46:34.069 Jakob Kagel: and then, like I can do the breakout. Now, if we have these on the product classes like or I mean on the sorry, on the the individual, like types, I mean, how how many views are we trying to? Because, like, we have a lot that are in sandbox or that like
319 00:46:34.320 ⇒ 00:46:41.179 Jakob Kagel: we can produce? But how many do you think that we really like have to deliver, because I can crank these out like pretty quick.
320 00:46:41.600 ⇒ 00:46:42.159 Uttam Kumaran: But I don’t.
321 00:46:42.160 ⇒ 00:46:46.429 Uttam Kumaran: What are those just not finished, or what? What’s the deal with those.
322 00:46:46.430 ⇒ 00:46:52.470 Jakob Kagel: Well, I’ll I’ll go back to like the I’ll go back to like sort of the
323 00:46:52.760 ⇒ 00:46:56.449 Jakob Kagel: the feedback, or whatever that I that I shared.
324 00:46:56.750 ⇒ 00:47:00.330 Uttam Kumaran: And we can go through them sort of like, step by step, like good.
325 00:47:00.330 ⇒ 00:47:04.350 Jakob Kagel: On the ticket. Okay, here, let me stop sharing just for one second.
326 00:47:04.660 ⇒ 00:47:05.300 Uttam Kumaran: For sure.
327 00:47:05.510 ⇒ 00:47:11.800 Jakob Kagel: I can send you. I’m gonna send you like the 9 things that are in the ticket. And then let’s just walk through those yeah.
328 00:47:14.460 ⇒ 00:47:18.250 Jakob Kagel: shit like, yeah.
329 00:47:22.950 ⇒ 00:47:29.030 Jakob Kagel: Cause there’s not like, I mean, this is what is in the ticket I just sent to you on slack, right? There’s not like
330 00:47:29.170 ⇒ 00:47:32.490 Jakob Kagel: super clear requirements other than like.
331 00:47:33.200 ⇒ 00:47:37.969 Jakob Kagel: define and implement fully loaded, gross margin and reporting. Right?
332 00:47:42.720 ⇒ 00:47:45.280 Jakob Kagel: so you have the list. Right? You see it on slack.
333 00:47:46.560 ⇒ 00:47:48.529 Jakob Kagel: Okay, yeah, yeah, let me just.
334 00:47:49.780 ⇒ 00:47:59.949 Jakob Kagel: I’ll just talk to every single one and give you just real quick, like the status. So reach percent is good. We that’s fine. Everything is good there. Net sales
335 00:48:00.330 ⇒ 00:48:07.720 Jakob Kagel: is fine now to like. We verified that right with the the plus discounted shipping. So that’s good.
336 00:48:07.990 ⇒ 00:48:11.358 Jakob Kagel: This number 3 is like considered blocked.
337 00:48:12.580 ⇒ 00:48:15.889 Jakob Kagel: I I asked him like about it, like on the
338 00:48:16.720 ⇒ 00:48:22.070 Jakob Kagel: like when I did it, or whatever I I was like. I don’t really know sort of what
339 00:48:22.500 ⇒ 00:48:24.879 Jakob Kagel: to include for this, because, like.
340 00:48:25.340 ⇒ 00:48:29.340 Jakob Kagel: I don’t know, what does it mean? Discrepancies related to shipping. Does this mean like.
341 00:48:30.190 ⇒ 00:48:33.740 Uttam Kumaran: Exactly. I agree. So fuck that, yeah, that’s yeah.
342 00:48:33.740 ⇒ 00:48:35.550 Jakob Kagel: So exactly. So that one
343 00:48:35.890 ⇒ 00:48:57.939 Jakob Kagel: we’re just gonna leave that off, define and implement fully loaded. Gross margin. That’s done. Yeah. Add gross margin per order. Aov. That’s done. Implement breakdown for gross margin percent of net revenue and gross margin. Aov. So to me, this just means, I think, right like, have the individual fields that make up the gross margin.
344 00:48:57.940 ⇒ 00:48:58.630 Uttam Kumaran: Yes.
345 00:48:58.820 ⇒ 00:49:03.819 Jakob Kagel: Show those right? So that’s easy. You can do that. There’s no problem.
346 00:49:03.950 ⇒ 00:49:05.320 Jakob Kagel: And then
347 00:49:05.660 ⇒ 00:49:12.879 Jakob Kagel: track accessories, cogs. So now that we have cogs in order line. That was number 7, so that will be solved
348 00:49:13.010 ⇒ 00:49:36.670 Jakob Kagel: and then set up a process to monitor free gift expenses. That’s the free gift view. We can also do that. I’m assuming 8 is also cogs, basically, cogs of free gift expenses. So I’m gonna use the same cogs calculation from order line. Now that we have the new fields and just use that free Regex, basically to capture like free gifts right.
349 00:49:36.670 ⇒ 00:49:37.350 Uttam Kumaran: Yes.
350 00:49:37.350 ⇒ 00:49:51.437 Jakob Kagel: So that’s done so that one’s fine and then work with data engineering to implement bucketing by concentrate slash protein. We don’t need them to do that. We can do that if we have the right fields for cogs in
351 00:49:53.130 ⇒ 00:49:55.979 Jakob Kagel: in order line item which we have now so.
352 00:49:56.350 ⇒ 00:49:57.089 Uttam Kumaran: Right, yeah.
353 00:49:57.090 ⇒ 00:50:03.541 Jakob Kagel: Yeah. So we got so that’s fine, exactly. And those fields should be the same as what’s in
354 00:50:04.300 ⇒ 00:50:14.930 Jakob Kagel: like a fact order. So we can do gross margin by, you know, each of these groups or whatever. Okay? So the only one that’s blocked is number 3.
355 00:50:14.930 ⇒ 00:50:17.880 Uttam Kumaran: So, yeah, I think if you can get the breakdowns.
356 00:50:18.100 ⇒ 00:50:21.570 Uttam Kumaran: the accessories, cogs, the gifts, and then the
357 00:50:21.760 ⇒ 00:50:24.619 Uttam Kumaran: I mean, it looks like the product category thing is already done.
358 00:50:25.190 ⇒ 00:50:25.940 Jakob Kagel: Right.
359 00:50:25.940 ⇒ 00:50:26.630 Uttam Kumaran: Right.
360 00:50:26.890 ⇒ 00:50:30.139 Jakob Kagel: Yeah, okay, I mean, I can crank this out like.
361 00:50:30.140 ⇒ 00:50:35.990 Uttam Kumaran: Those 3. So then I’m just gonna make sure, like before we hop off, I’m just gonna make sure that the analytics
362 00:50:36.260 ⇒ 00:50:41.980 Uttam Kumaran: thing is like solved for you right now. I just wanna we’ll move on from this Meta base thing.
363 00:50:42.958 ⇒ 00:50:45.051 Uttam Kumaran: It’s fine. So let me just
364 00:50:49.530 ⇒ 00:50:52.120 Jakob Kagel: But that’s good. I mean, I feel good about it.
365 00:50:52.370 ⇒ 00:50:56.470 Jakob Kagel: especially like if we have the cog solve. Now that solves
366 00:50:57.070 ⇒ 00:51:00.090 Jakob Kagel: sort of all the other ones that were blocked except shipping.
367 00:51:31.040 ⇒ 00:51:32.749 Uttam Kumaran: Okay, it should be good. Now.
368 00:51:34.600 ⇒ 00:51:37.920 Jakob Kagel: Alright sounds good. Well, that’s what I’m gonna do. I’m gonna.
369 00:51:37.920 ⇒ 00:51:38.245 Uttam Kumaran: Okay.
370 00:51:38.570 ⇒ 00:51:46.025 Jakob Kagel: I got all those views. I’m gonna send the update in the same format like for the list. I’m done
371 00:51:47.650 ⇒ 00:51:53.920 Jakob Kagel: I will update. So Amazon dashboard. Okay, let’s actually sorry. One last last thing.
372 00:51:53.920 ⇒ 00:51:57.834 Uttam Kumaran: Yeah. So the Amazon dash? I just asked. I just asked
373 00:51:59.750 ⇒ 00:52:03.300 Uttam Kumaran: Robert about that. He said he sent like one piece of feedback.
374 00:52:04.320 ⇒ 00:52:13.310 Jakob Kagel: Right. So the only piece of feedback that he sent I already fixed that but I think the question I just wanted to make sure. Let me just look real quick.
375 00:52:13.310 ⇒ 00:52:19.229 Uttam Kumaran: Can you ask? Cancel? Yeah, I I can’t see your screen, but it’s like, can you ask, cancel order rate?
376 00:52:22.830 ⇒ 00:52:24.399 Jakob Kagel: One second.
377 00:52:25.240 ⇒ 00:52:37.450 Jakob Kagel: Okay, it’s more about like, okay. So I just did orders. I did average order value.
378 00:52:37.610 ⇒ 00:52:47.479 Jakob Kagel: So net sales. So yeah, so that was the feedback was just to switch everything to net sales, and the net sales, like calculation should not be compromised.
379 00:52:51.120 ⇒ 00:52:52.060 Jakob Kagel: Okay.
380 00:52:52.060 ⇒ 00:52:54.850 Uttam Kumaran: The other feedback was, can you add canceled order, rate.
381 00:52:55.990 ⇒ 00:53:02.070 Jakob Kagel: Oh, did he say I didn’t see that? I can try. Yeah.
382 00:53:02.400 ⇒ 00:53:08.600 Jakob Kagel: I I have to check. I don’t know about the like. If there’s the, I assume that’s just a field, in fact, orders. But yeah.
383 00:53:09.180 ⇒ 00:53:12.110 Jakob Kagel: if it’s in there, then yeah, I can add it, of course.
384 00:53:25.630 ⇒ 00:53:26.840 Jakob Kagel: Where did he say that dude.
385 00:53:26.880 ⇒ 00:53:30.360 Uttam Kumaran: Instead, if you search for quick, fix.
386 00:53:35.100 ⇒ 00:53:38.399 Jakob Kagel: Oh, there, okay. Oh, he sent it this morning. Yeah.
387 00:53:39.480 ⇒ 00:53:40.480 Jakob Kagel: Okay.
388 00:53:44.130 ⇒ 00:53:46.620 Jakob Kagel: sure. Yeah. I can add that.
389 00:53:49.530 ⇒ 00:53:51.030 Uttam Kumaran: I think that’s the last thing.
390 00:53:52.430 ⇒ 00:53:53.290 Jakob Kagel: Alright.
391 00:53:59.610 ⇒ 00:54:00.550 Jakob Kagel: Okay.
392 00:54:02.670 ⇒ 00:54:07.340 Uttam Kumaran: Okay, sick dude. If we can get those basically like 3 things
393 00:54:08.200 ⇒ 00:54:12.500 Uttam Kumaran: done, then we can call it on these dashboards for probably for another few days.
394 00:54:12.640 ⇒ 00:54:17.419 Jakob Kagel: No worries alright, yeah. Let me let me crank it out. Then. Yeah.
395 00:54:17.420 ⇒ 00:54:18.620 Uttam Kumaran: Okay. Okay. Sick.
396 00:54:18.830 ⇒ 00:54:19.759 Jakob Kagel: I’ll see. Yep.
397 00:54:19.760 ⇒ 00:54:20.810 Uttam Kumaran: Alright dude! Thanks.
398 00:54:20.810 ⇒ 00:54:21.469 Jakob Kagel: Yeah, for sure.