Meeting Title: Data Roadmapping_Javvy Coffee Date: 2025-03-03 Meeting participants: Luke Daque, Steven Kootz, Uttam Kumaran, Demilade Agboola, Bo Yoon, Robert Tseng, Awaish Kumar
WEBVTT
1 00:00:31.300 ⇒ 00:00:32.340 Luke Daque: Hello!
2 00:00:48.480 ⇒ 00:00:49.570 Luke Daque: Hello! Hello!
3 00:00:51.750 ⇒ 00:00:52.540 Demilade Agboola: Hello!
4 00:00:57.540 ⇒ 00:00:58.970 Payas Parab (TikTok): Hey, guys, how are you.
5 00:01:00.650 ⇒ 00:01:02.219 Luke Daque: Doing well, doing well.
6 00:01:02.620 ⇒ 00:01:03.380 Demilade Agboola: Pretty good.
7 00:01:03.380 ⇒ 00:01:04.200 Luke Daque: How about you?
8 00:01:06.627 ⇒ 00:01:07.759 Payas Parab (TikTok): Doing all right.
9 00:01:10.030 ⇒ 00:01:10.650 Uttam Kumaran: Hey, guys.
10 00:01:10.650 ⇒ 00:01:11.360 Luke Daque: Hair.
11 00:01:12.300 ⇒ 00:01:14.330 Uttam Kumaran: How’s the hair? Yeah, how’s the hair?
12 00:01:15.610 ⇒ 00:01:19.950 Luke Daque: It’s always fun. Seeing chaos here.
13 00:01:21.550 ⇒ 00:01:34.590 Payas Parab (TikTok): Oh, yeah, sorry. I’m in the car right now, so I can’t. I can’t show you the hair, unfortunately. But what’s what’s on docket for today. One of these days I’m gonna like, do something crazy, though. So just to shock you guys like Green, I’ll die it green or something.
14 00:01:34.990 ⇒ 00:01:36.100 Uttam Kumaran: Yes.
15 00:01:38.440 ⇒ 00:01:40.239 Demilade Agboola: I don’t think it will shock us anymore.
16 00:01:40.540 ⇒ 00:01:41.859 Demilade Agboola: You’ve kind of told us.
17 00:01:42.285 ⇒ 00:01:49.599 Uttam Kumaran: I wanted to dye my hair blonde for a long time, but everybody I know, including
18 00:01:49.810 ⇒ 00:01:54.720 Uttam Kumaran: my barber, said, Don’t do it, but that just makes me want to do the thing.
19 00:01:55.540 ⇒ 00:01:56.370 Payas Parab (TikTok): Alright! Let’s do!
20 00:01:57.110 ⇒ 00:02:01.310 Uttam Kumaran: I don’t like. When people tell me I can’t do the thing. I don’t really understand.
21 00:02:02.120 ⇒ 00:02:07.029 Payas Parab (TikTok): We should set. We should set a goal, Tom, if we had a certain revenue this year. You have to get frosted tips.
22 00:02:07.030 ⇒ 00:02:08.850 Uttam Kumaran: Yeah, I will do it.
23 00:02:08.850 ⇒ 00:02:09.530 Payas Parab (TikTok): Go blonde.
24 00:02:09.539 ⇒ 00:02:12.249 Uttam Kumaran: The number is a lot lower than you think.
25 00:02:14.152 ⇒ 00:02:18.477 Uttam Kumaran: If if we can just get Joby to renew, I may do it.
26 00:02:20.620 ⇒ 00:02:23.630 Payas Parab (TikTok): Dude you should let him on know is like yo if we got
27 00:02:23.630 ⇒ 00:02:27.729 Payas Parab (TikTok): yes, we got this. I’m going blonde. There’s a lot riding on this.
28 00:02:29.450 ⇒ 00:02:29.969 Uttam Kumaran: If I.
29 00:02:29.970 ⇒ 00:02:30.389 Payas Parab (TikTok): Did you get.
30 00:02:30.390 ⇒ 00:02:36.389 Uttam Kumaran: If I go. If if I go blonde, then everyone needs to have their camera on in meetings, because then I’m just going to be the only one sitting here
31 00:02:37.239 ⇒ 00:02:51.420 Uttam Kumaran: embarrassed. The only tile. Everybody’s driving, getting food, just watching me with blonde hair sitting, you know. That’s that’s my that would be my, you know. Concession.
32 00:02:53.290 ⇒ 00:03:00.420 Payas Parab (TikTok): Yeah, that dude. I also did you ask him on for some free coffee dude? He.
33 00:03:00.420 ⇒ 00:03:01.379 Uttam Kumaran: Oh, I didn’t.
34 00:03:01.380 ⇒ 00:03:02.919 Payas Parab (TikTok): So many samples.
35 00:03:03.500 ⇒ 00:03:05.350 Uttam Kumaran: I will ask him.
36 00:03:05.350 ⇒ 00:03:09.590 Payas Parab (TikTok): Like 8 bottles of pure negative margin, just.
37 00:03:10.028 ⇒ 00:03:20.559 Uttam Kumaran: I am not I. It’s hard for me to ask when we’re not doing what he’s paying for but I will ask
38 00:03:20.690 ⇒ 00:03:24.059 Uttam Kumaran: if we get the renewal, and things go well. But
39 00:03:24.750 ⇒ 00:03:30.991 Uttam Kumaran: yeah, I would prefer to just get the cash in. So we can make more money here. That’s it.
40 00:03:32.506 ⇒ 00:03:37.189 Uttam Kumaran: But yeah, when I come when we come to la, I’ll ask. I’ll I’ll get a sample from you.
41 00:03:37.990 ⇒ 00:03:38.945 Payas Parab (TikTok): Sweet.
42 00:03:40.140 ⇒ 00:03:42.360 Payas Parab (TikTok): Also there’s a demi Lotte. Welcome.
43 00:03:42.570 ⇒ 00:03:44.630 Payas Parab (TikTok): Steven also joined today right.
44 00:03:45.010 ⇒ 00:03:45.880 Uttam Kumaran: Yes.
45 00:03:48.100 ⇒ 00:03:50.409 Steven Kootz: Nice Hello! Nice to meet you.
46 00:03:50.860 ⇒ 00:03:53.641 Payas Parab (TikTok): You guys ready for the greatest client of all time.
47 00:03:55.490 ⇒ 00:03:56.420 Demilade Agboola: I’m not sure if that’s a good thing.
48 00:03:56.420 ⇒ 00:03:56.860 Steven Kootz: Alrighty!
49 00:03:59.260 ⇒ 00:04:01.068 Payas Parab (TikTok): It’s fun. It’s fun, fun, stuff.
50 00:04:01.970 ⇒ 00:04:03.761 Uttam Kumaran: Another day in the life.
51 00:04:04.620 ⇒ 00:04:17.579 Uttam Kumaran: cool. So I guess let’s talk about where things are. So I think really right now, it’s sort of all hands on deck in terms of the questions that we’re answering in slack
52 00:04:18.207 ⇒ 00:04:23.449 Uttam Kumaran: I believe everybody here except them a lot. I’ll add you so you can see this.
53 00:04:23.912 ⇒ 00:04:26.450 Uttam Kumaran: You guys should be able to see
54 00:04:28.270 ⇒ 00:04:30.259 Uttam Kumaran: the items that we’re going through in slack
55 00:04:30.961 ⇒ 00:04:38.700 Uttam Kumaran: this is really between me. Luke away. And Robert, we’re basically going through, and one by one, just taking off
56 00:04:38.830 ⇒ 00:04:43.090 Uttam Kumaran: several items that came in from feedback yesterday.
57 00:04:44.430 ⇒ 00:04:53.070 Uttam Kumaran: I guess we’ll maybe I’ll leave that for a sec. I just want to talk through any other actions. Outside of those questions that need to happen this week.
58 00:04:53.170 ⇒ 00:04:57.150 Uttam Kumaran: I’m looking in that stuff from last week.
59 00:04:57.717 ⇒ 00:05:02.010 Uttam Kumaran: I mean, it doesn’t look like much movement on the gorgeous dashboard.
60 00:05:02.810 ⇒ 00:05:11.020 Uttam Kumaran: It looks like everything else we have moved forward. I think we’re still really trying to push out the gross margin. Dash!
61 00:05:12.710 ⇒ 00:05:14.160 Uttam Kumaran: Is there any other?
62 00:05:14.400 ⇒ 00:05:20.289 Uttam Kumaran: I think that? And the Okendo dash, I guess, Bo, did you have a chance to make any other further progress on
63 00:05:20.560 ⇒ 00:05:21.640 Uttam Kumaran: that work?
64 00:05:23.110 ⇒ 00:05:26.161 Bo Yoon: Yeah, I made a few more graphs. But I
65 00:05:27.020 ⇒ 00:05:33.070 Bo Yoon: I I think I still need the the product category. And the other thing that I asked for.
66 00:05:33.980 ⇒ 00:05:34.480 Uttam Kumaran: Okay.
67 00:05:34.480 ⇒ 00:05:35.040 Uttam Kumaran: Okay.
68 00:05:38.100 ⇒ 00:05:41.069 Uttam Kumaran: okay, let me note that down. I thought I added it.
69 00:05:42.100 ⇒ 00:05:42.980 Uttam Kumaran: I’ll check
70 00:05:52.477 ⇒ 00:06:00.189 Uttam Kumaran: do you think we can do a like? Can you do? Once I add that, can you do a loom walkthrough of that dashboard and send it to the channel.
71 00:06:00.720 ⇒ 00:06:02.280 Bo Yoon: Oh, yeah. Yeah. Sure.
72 00:06:02.280 ⇒ 00:06:04.260 Uttam Kumaran: And then Robert can get feedback. Async.
73 00:06:19.580 ⇒ 00:06:21.639 Payas Parab (TikTok): Can I ask you a quick question, Utah?
74 00:06:21.870 ⇒ 00:06:22.500 Uttam Kumaran: Yeah.
75 00:06:22.930 ⇒ 00:06:27.970 Payas Parab (TikTok): For gorgeous. I went to do it. Did you pull in Kyle’s pull request? I know you guys had
76 00:06:28.230 ⇒ 00:06:30.839 Payas Parab (TikTok): wrap that up on Thursday or Friday.
77 00:06:30.970 ⇒ 00:06:34.819 Payas Parab (TikTok): cause I don’t see it in Meta Base like the fields that we kind of.
78 00:06:35.230 ⇒ 00:06:39.239 Payas Parab (TikTok): We’re working on. I I don’t see them in there. So I don’t know if it’s like a Meta base
79 00:06:39.440 ⇒ 00:06:44.640 Payas Parab (TikTok): issue, or it’s like this whole like prod marks versus analytics thing. I don’t know what what’s going on there I can.
80 00:06:46.060 ⇒ 00:06:49.640 Payas Parab (TikTok): I can send you like a screenshot. But did we pull that in to Prague?
81 00:06:49.640 ⇒ 00:06:55.419 Uttam Kumaran: Yeah. Just slack me once, just slack a channel. Once you hit the issue because I don’t wanna wait for this meeting to.
82 00:06:55.980 ⇒ 00:07:03.860 Uttam Kumaran: Yeah. Yeah. Okay, I mean, yeah, just whatever the problem is, just
83 00:07:04.780 ⇒ 00:07:07.109 Uttam Kumaran: send in a slack. We’ll resolve.
84 00:07:07.707 ⇒ 00:07:12.529 Uttam Kumaran: But I mean at this point, like I may, if I it’s just on the to do so.
85 00:07:13.370 ⇒ 00:07:15.890 Uttam Kumaran: I don’t know. One of us has to take this.
86 00:07:16.110 ⇒ 00:07:19.480 Uttam Kumaran: So you tell me whether this is gonna be possible this week.
87 00:07:19.680 ⇒ 00:07:20.620 Uttam Kumaran: I’m
88 00:07:20.740 ⇒ 00:07:28.269 Uttam Kumaran: don’t know whether this is going to be possible, especially on top of the stuff for pool parts like it just may be something I have to take.
89 00:07:32.750 ⇒ 00:07:40.490 Payas Parab (TikTok): I I think it should. I like, I’m gonna I’m gonna go do that today. Let me let me take a stab at it for like a little bit first, st and then
90 00:07:41.014 ⇒ 00:07:44.490 Payas Parab (TikTok): cause I was gonna start with that and then jump to cool parts. So let me just
91 00:07:44.600 ⇒ 00:07:49.210 Payas Parab (TikTok): do that I I don’t think it should be. It’s not like anything crazy, right? This one’s a lot easier than.
92 00:07:49.210 ⇒ 00:07:50.410 Uttam Kumaran: No other metrics.
93 00:07:50.870 ⇒ 00:07:52.750 Uttam Kumaran: It’s like kindergarten.
94 00:07:53.220 ⇒ 00:07:59.750 Payas Parab (TikTok): Yeah, it’s just like how many people, what time average time to reply to an agent and shit it, like, I imagine, literally like.
95 00:07:59.750 ⇒ 00:08:09.306 Uttam Kumaran: You should. Honestly, you should honestly take a look at Sahana’s agent performance. Mock up that we did for Eden, and just do that. Just do that.
96 00:08:09.830 ⇒ 00:08:11.320 Payas Parab (TikTok): Yeah, I should be able to do that today.
97 00:08:11.530 ⇒ 00:08:16.439 Uttam Kumaran: Okay, I’ll ping you at the end of the day. Just slack me with whatever the this data issue.
98 00:08:16.440 ⇒ 00:08:18.559 Payas Parab (TikTok): Yeah, I’ll slack that. Yeah, we’ll do.
99 00:08:18.560 ⇒ 00:08:23.389 Uttam Kumaran: Okay, cool. I think I want to spend the rest of the time. Maybe, Robert, just talking about
100 00:08:23.550 ⇒ 00:08:25.549 Uttam Kumaran: the stuff in flight for today.
101 00:08:25.941 ⇒ 00:08:27.770 Uttam Kumaran: I know there’s a bunch of movement.
102 00:08:28.010 ⇒ 00:08:31.529 Uttam Kumaran: I’m happy to go one by one.
103 00:08:32.210 ⇒ 00:08:36.200 Uttam Kumaran: How do you wanna how do you want to attack these.
104 00:08:38.210 ⇒ 00:08:41.339 Robert Tseng: Yeah, I I see a waste typing in slack.
105 00:08:41.340 ⇒ 00:08:41.799 Uttam Kumaran: So.
106 00:08:42.505 ⇒ 00:08:45.939 Robert Tseng: But we she could just say it at school like I I know I
107 00:08:46.520 ⇒ 00:08:52.310 Robert Tseng: you know, whatever you, whatever you’re typing out, you can just say I’m pull up the dashboard. I’ll show you guys where we’re at.
108 00:08:52.310 ⇒ 00:08:52.900 Uttam Kumaran: Cool.
109 00:09:06.595 ⇒ 00:09:07.370 Robert Tseng: Man
110 00:09:09.570 ⇒ 00:09:16.360 Robert Tseng: like Arc, like, you know, resets your tabs every day, so like whatever I had open last night is, I have to open them again.
111 00:09:17.300 ⇒ 00:09:27.489 Uttam Kumaran: Yeah, my, I use arc arc is great. Honestly, what I should start doing is start sharing each folder I have for every client. I’ve done a good job of like having everything there.
112 00:09:28.110 ⇒ 00:09:37.739 Uttam Kumaran: but it’s also good that it deletes, because I’m like a tab fiend like I’ll have like a thousand tabs, and arc is not really helped. That, except it just gets rid of them, which is nice. But.
113 00:09:38.660 ⇒ 00:09:38.954 Robert Tseng: Yeah.
114 00:09:51.650 ⇒ 00:09:56.070 Robert Tseng: give me like one more minute and I will both hold up.
115 00:10:08.580 ⇒ 00:10:35.759 Robert Tseng: Okay, cool. So on the left is the previous gross margin dashboard. I already added some stuff. But then I just decided to move it to another environment to build out so I’ll ignore those tiles. But yeah, basically, like, I think our gross margin calculation was off. It was including like weight and quantity doesn’t make any sense. So I think kind of to align with a wish on that. So my question is.
116 00:10:36.880 ⇒ 00:10:50.250 Robert Tseng: yeah for the gross mark. I I guess I know we have like this equation that I don’t really know where I asked, or Jacob got this from. I didn’t really see a message with this specifically, but from a high level like
117 00:10:52.010 ⇒ 00:10:59.069 Robert Tseng: whether. Oh, yeah, I don’t really want to talk about the specifics of this equation. Gross margin should be pre-tax
118 00:11:00.490 ⇒ 00:11:04.849 Robert Tseng: sales revenue that’s after discount and doesn’t include shipping.
119 00:11:05.190 ⇒ 00:11:08.890 Robert Tseng: And so I understand now, after waste broke it down
120 00:11:09.316 ⇒ 00:11:12.580 Robert Tseng: in the fact orders table. We’re able to do that
121 00:11:16.140 ⇒ 00:11:20.485 Robert Tseng: and the the fact orders. Price
122 00:11:21.930 ⇒ 00:11:27.960 Robert Tseng: includes like this is after tax. After shipping I sent, I sent a Pdf. Of A
123 00:11:28.010 ⇒ 00:11:48.069 Robert Tseng: of a of a sample order detail to show that. So that like kind of gets us like, it’s not exactly what we need. And so that’s why I needed to like, I, yeah, I need to get to a version where, at the order level, we’re able to show pre-tax revenue that’s after discount and excluding shipping.
124 00:11:48.100 ⇒ 00:12:08.379 Robert Tseng: So I need that at the order level, because, like, I think that’s probably the faster way to aggregate it. But then, since we’re break breaking this out by product as well, we need this at the order line level. So I kind of gave. Here’s an example of what I think would be a better view. This is just like monthly profitability by customer type and product.
125 00:12:08.550 ⇒ 00:12:15.700 Robert Tseng: I don’t think this calculation is right yet, because if we look at the editor and kind of how I’ve calculated gross profit.
126 00:12:17.900 ⇒ 00:12:40.680 Robert Tseng: yeah, I’m doing sales revenue minus discount minus like cogs. Which I think, yeah, I think the cogs component, I think we’re good on. We don’t need to talk anymore about that and discounts we’ve we’ve isolated it. But just that revenue piece is a little bit off, which is kind of why, I said, there. I sent a link to Metabase, a report where I was like looking at situations where
127 00:12:42.280 ⇒ 00:12:47.080 Robert Tseng: maybe I can just pull up some. I know. I sent a bunch of messages late. So.
128 00:12:48.395 ⇒ 00:12:52.009 Robert Tseng: where is that link I sent?
129 00:13:00.970 ⇒ 00:13:08.669 Robert Tseng: Yeah. So I looked at when like price is higher than pre tax price. Oh, man, is this just like a public link?
130 00:13:09.060 ⇒ 00:13:10.010 Robert Tseng: Okay?
131 00:13:14.130 ⇒ 00:13:15.500 Robert Tseng: not that helpful?
132 00:13:31.470 ⇒ 00:13:42.800 Robert Tseng: Okay, yeah. So in this situation, yeah, I’m looking at like the sales revenue of
133 00:13:43.620 ⇒ 00:13:54.800 Robert Tseng: we. I was just trying to get to that pre-tax, that pre-tax revenue there. So once I’m clear, once we’ve cleared that part up, I think that would help, I think, a way she just sent a message. I don’t know I didn’t. I didn’t read it. But
134 00:13:55.390 ⇒ 00:14:02.519 Robert Tseng: yeah, I think that’s that’s the main thing. I want to get out of this call. So I can get this. The sales piece of this equation correct.
135 00:14:03.570 ⇒ 00:14:12.950 Awaish Kumar: Yeah. So I I sent a a new message to you. So what was happening in our model was, there was some.
136 00:14:13.320 ⇒ 00:14:18.329 Awaish Kumar: There was an issue between Amazon and shopify data.
137 00:14:18.750 ⇒ 00:14:24.029 Awaish Kumar: In in shopify we have 2 fields in our fact, order, line table.
138 00:14:24.510 ⇒ 00:14:28.190 Awaish Kumar: one called price, and other one is called pretext price,
139 00:14:30.760 ⇒ 00:14:38.290 Awaish Kumar: So in shopify price is basically was showing pre-tax pre shipping, pre-discount price.
140 00:14:39.270 ⇒ 00:14:42.820 Awaish Kumar: and the pre-tax price field is shows pre-tax
141 00:14:43.000 ⇒ 00:14:45.730 Awaish Kumar: pre shipping. But after discount Price
142 00:14:45.980 ⇒ 00:14:55.809 Awaish Kumar: and in Amazon we were calculating it ourselves, and we did it like we just like kind of
143 00:14:59.013 ⇒ 00:15:11.720 Awaish Kumar: was switched between these 2, so like pretext, was showing the price, and like, and vice versa. So this is, I have just pushed a fix, so this will be the current, like the
144 00:15:11.890 ⇒ 00:15:19.709 Awaish Kumar: new scenario price field and the pretext price field. There will be 2 fields where one will show
145 00:15:20.320 ⇒ 00:15:25.919 Awaish Kumar: the price will show pre-tax pre-shipping and the pre-discount price.
146 00:15:28.100 ⇒ 00:15:34.219 Awaish Kumar: And the pre-tax price is basically the pre-tax pre-shipping after discount price.
147 00:15:36.570 ⇒ 00:15:42.260 Robert Tseng: Okay. So just so everyone’s clear, like, pre tax price, you’re saying that this is
148 00:15:42.690 ⇒ 00:15:45.640 Robert Tseng: before discount. And this is before tax.
149 00:15:47.040 ⇒ 00:15:48.350 Robert Tseng: And it does not include shipping.
150 00:15:48.350 ⇒ 00:15:49.430 Awaish Kumar: That’s nice.
151 00:15:50.800 ⇒ 00:15:51.339 Awaish Kumar: Yes.
152 00:15:53.380 ⇒ 00:15:54.160 Robert Tseng: Okay?
153 00:15:56.370 ⇒ 00:16:03.420 Robert Tseng: That’s fine. I think my issue was that. Okay? I look at this scenario where
154 00:16:04.170 ⇒ 00:16:13.269 Robert Tseng: I looked at any situation where the pre-tax revenue was less then, like the sales price.
155 00:16:13.570 ⇒ 00:16:20.950 Robert Tseng: And so that’s what that’s what this. That’s what this chart is where I looked at it.
156 00:16:22.130 ⇒ 00:16:24.529 Robert Tseng: And this is price minus cogs versus like.
157 00:16:24.530 ⇒ 00:16:34.740 Awaish Kumar: It is, it is less because, like it is after discount price, like pre-dex price field
158 00:16:35.680 ⇒ 00:16:41.860 Awaish Kumar: giving us the price after discounts. So, for example, if 50 was the total price.
159 00:16:42.510 ⇒ 00:16:54.299 Awaish Kumar: then the total, the price field will show the total price. 50 and and there was a discount of $20. For example, then 50 minus 20 is equal to 30, and the pretext price field show 30.
160 00:16:56.160 ⇒ 00:16:56.760 Uttam Kumaran: Yeah.
161 00:16:59.460 ⇒ 00:17:00.470 Robert Tseng: Okay.
162 00:17:07.089 ⇒ 00:17:10.219 Uttam Kumaran: Because you’re taxed on the total sale amount, not the pre discount.
163 00:17:10.960 ⇒ 00:17:12.230 Robert Tseng: Yeah, yeah.
164 00:17:14.550 ⇒ 00:17:21.469 Robert Tseng: Okay, so then, I probably will end up using just the pretax, I think sounds like, that’s what we need to use.
165 00:17:21.470 ⇒ 00:17:22.210 Uttam Kumaran: Yes.
166 00:17:22.599 ⇒ 00:17:23.849 Robert Tseng: Okay, cool.
167 00:17:23.979 ⇒ 00:17:24.719 Robert Tseng: That’s fine.
168 00:17:24.720 ⇒ 00:17:32.059 Uttam Kumaran: That should all be that should all be there. And now all the like, this pier got pushed and moved, and it’s it’s ran so.
169 00:17:32.450 ⇒ 00:17:57.490 Robert Tseng: Okay, great. So looking at this, this pivot table. So yeah, I think hopefully, all these profitability metrics will be updated by customer type by product category. There’s a bunch of orders that are not categorized. These are actually all Amazon orders. So I think I asked the question like, wait? Why, I forgot. I mean whatever. Just maybe we’ll re ask the question, why why does Amazon not have a customer type?
170 00:17:58.960 ⇒ 00:18:03.749 Uttam Kumaran: Let’s move on to the next question. I’ll find I have not had a chance of finding the answer yet, but I will find.
171 00:18:05.250 ⇒ 00:18:06.440 Uttam Kumaran: But keep move on to the next.
172 00:18:07.540 ⇒ 00:18:10.509 Robert Tseng: Let me see. I asked a bunch of questions here, so.
173 00:18:10.510 ⇒ 00:18:20.079 Uttam Kumaran: The null, the null one. That’s our bad. Yeah, you shouldn’t. There shouldn’t be null values, because when you add null to anything, it’ll know the whole thing
174 00:18:20.390 ⇒ 00:18:28.340 Uttam Kumaran: for some reason, something coming into the calculation that is null, and I don’t know where it is. I’m gonna fix this
175 00:18:28.680 ⇒ 00:18:32.509 Uttam Kumaran: upstream, but I have to. It’ll take a little bit more time to go isolate.
176 00:18:33.210 ⇒ 00:18:38.240 Robert Tseng: Okay, yeah. Cause I was like doing a check on the cogs. And it just like didn’t really add up. So.
177 00:18:38.240 ⇒ 00:18:40.259 Uttam Kumaran: Shouldn’t be happening. Yeah, should happen.
178 00:18:40.260 ⇒ 00:18:58.820 Robert Tseng: I added this, and it started to tie out but yeah, I mean, I guess I’m just kinda I mean, I just want people to see like, okay, what? I started this at like 10 pm. Last night. And I spent like 2 h like just going in and doing data validation on what we consider to be like the out, the output. And there’s just so many things off that
179 00:18:58.830 ⇒ 00:19:13.579 Robert Tseng: guys, if you just like, looked at, did checks with the fact order or line table that you would, you would see all this. So this is kind of reiterating the point. I don’t want to see another dashboard iteration unless you guys are record a loom as well, showing like
180 00:19:13.790 ⇒ 00:19:42.659 Robert Tseng: what like talk through the logic they used to built it. Tell me what data validation checks you use. Like, yeah, I I, anyway. So I just feel like, this is all low hanging fruit that I I wish we caught this like a month ago. Frankly. So I think, that’s kind of where we’re at. But I mean, generally, I think all these other cuts should probably okay. What I’m basically doing is I’m going back in and I’m gonna just rebuild this this dashboard and ship it out.
181 00:19:43.570 ⇒ 00:19:44.820 Robert Tseng: But yeah, I think
182 00:19:45.586 ⇒ 00:19:53.489 Robert Tseng: the gross profit. The margin is not 70%, I think, whatever it was showing like, that doesn’t make that that seems way too high.
183 00:19:54.910 ⇒ 00:20:03.270 Robert Tseng: And yeah. So I think the new. The new reports will probably show something that’s much lower than I mean. We were saying that shopify had like
184 00:20:03.450 ⇒ 00:20:17.879 Robert Tseng: 87% gross margin, which is kind of absurd. So I I don’t really think that that was yeah, anyway. So that’s that’s kind of why, what prompted me to go, and just like, kind of got got this whole thing.
185 00:20:21.210 ⇒ 00:20:25.600 Robert Tseng: Yeah, I would say. The last piece to this was.
186 00:20:25.710 ⇒ 00:20:29.660 Robert Tseng: I mean, this is all just breaking down the sales stuff. So I’m I’m good on that.
187 00:20:30.490 ⇒ 00:20:36.694 Robert Tseng: Yeah, I think that’s it. That’s it. I think that’s it for me. Like, if we can kind of clear up.
188 00:20:37.350 ⇒ 00:20:42.279 Robert Tseng: yeah, just at least get this view. View, Queen. I think from here I can go and build out everything else.
189 00:20:45.200 ⇒ 00:20:46.010 Robert Tseng: Yeah.
190 00:20:50.680 ⇒ 00:20:51.330 Uttam Kumaran: Okay?
191 00:20:53.150 ⇒ 00:20:59.690 Uttam Kumaran: yeah, I think probably for the short term we’ll solve these. I don’t know yet who’s gonna take on
192 00:21:00.400 ⇒ 00:21:05.919 Uttam Kumaran: ownership over these these 2. I’m speaking with Sahana later today
193 00:21:06.150 ⇒ 00:21:09.579 Uttam Kumaran: about potentially bringing her in to own these. But.
194 00:21:10.496 ⇒ 00:21:29.410 Robert Tseng: Think I don’t really want to bring. So I mean second thought, like, I know, I was open to it. But this contract ends next week. I don’t know if we will be able to renew, so I feel like just I’ll just. I’ll just finish it. We’ll push it, and you know it’s fine, like, I don’t wanna on board her onto something that may not continue after next week.
195 00:21:30.100 ⇒ 00:21:32.020 Robert Tseng: Yeah, yeah.
196 00:21:33.670 ⇒ 00:21:36.489 Uttam Kumaran: Okay, cool. So we’re I’m we’re gonna be working on
197 00:21:36.730 ⇒ 00:21:41.190 Uttam Kumaran: fixing all these and then sort of going back to the dashboard in the next like 2 h.
198 00:21:41.320 ⇒ 00:21:43.670 Uttam Kumaran: so we’ll make sure these are all all through.
199 00:21:44.930 ⇒ 00:21:45.700 Robert Tseng: Okay.
200 00:21:46.752 ⇒ 00:21:58.160 Uttam Kumaran: And then, yeah, I’m I’m emailing back and forth with ship with, I’m emailing back and forth to try to get the north beam stuff figured out, and then I’m just gonna push the O. Kendo fix, and
201 00:21:58.460 ⇒ 00:22:02.010 Uttam Kumaran: if I have time over the next 3 h I’ll probably get something out for
202 00:22:02.527 ⇒ 00:22:04.850 Uttam Kumaran: gorgeous, too, while I’m in there.
203 00:22:06.360 ⇒ 00:22:07.040 Robert Tseng: Okay.
204 00:22:08.390 ⇒ 00:22:13.679 Uttam Kumaran: Okay, anything else on Joby. We want to talk through.
205 00:22:17.670 ⇒ 00:22:27.900 Uttam Kumaran: I think the big thing ideally, Robert is and Steven, it’s sort of a little bit on on your plate is if we can get a roadmap for the future, maybe that’ll help with the renewal discussion a little bit.
206 00:22:28.381 ⇒ 00:22:44.060 Uttam Kumaran: So one thing I think, Steven, as we’re working towards this this week, is, you sort of now have context on some of the challenges we’re going through. One of the things I think could be helpful for next week, when we’re pitching, the renewal is to have what the next like month, 2 month roadmap could look like
207 00:22:44.478 ⇒ 00:22:48.590 Uttam Kumaran: and something visual that they can see. So that would be nice to sort of work towards that.
208 00:22:49.980 ⇒ 00:22:52.260 Uttam Kumaran: But yeah, please let me know if there’s any other questions.
209 00:22:52.780 ⇒ 00:22:53.839 Steven Kootz: Yeah, for sure.
210 00:22:55.190 ⇒ 00:23:08.509 Robert Tseng: There’s actually one more thing from last week. I think it was feedback on the Amazon dash, I think, in the client channel I had tagged you, Tom, on a couple of changes I was waiting on. I kind of let it drop after that, but
211 00:23:08.800 ⇒ 00:23:11.230 Robert Tseng: I’m trying to bring it back up.
212 00:23:11.730 ⇒ 00:23:17.197 Robert Tseng: Justin had given some feedback on a dashboard.
213 00:23:18.080 ⇒ 00:23:22.070 Uttam Kumaran: Yeah, subscribe and save is the only thing that one.
214 00:23:22.940 ⇒ 00:23:28.253 Uttam Kumaran: I couldn’t find it. And Kyle is out right now, so have to.
215 00:23:29.050 ⇒ 00:23:31.260 Uttam Kumaran: I guess I’ll just take a look at it again today.
216 00:23:33.790 ⇒ 00:23:41.249 Robert Tseng: Okay, I’ll just forward that message something for us to bump on as well.
217 00:23:46.400 ⇒ 00:23:55.160 Robert Tseng: Yeah, it was product category at the order line which we have now order flag which we needed to add to back order. And then.
218 00:23:55.320 ⇒ 00:23:57.259 Robert Tseng: yeah, I mean you. I think you already fixed.
219 00:23:57.260 ⇒ 00:23:59.109 Uttam Kumaran: Total spend is good. Yeah.
220 00:23:59.110 ⇒ 00:24:00.610 Robert Tseng: Yeah, okay.
221 00:24:03.260 ⇒ 00:24:09.327 Uttam Kumaran: Okay, cool. Alright. So we’re a bunch of us are working for the next few hours, just like breaking through some of these. But
222 00:24:09.820 ⇒ 00:24:12.269 Uttam Kumaran: yeah, we’ll just slack as we get through some of these items.
223 00:24:15.060 ⇒ 00:24:15.655 Robert Tseng: Alright!
224 00:24:16.950 ⇒ 00:24:17.750 Uttam Kumaran: Thanks guys.
225 00:24:18.350 ⇒ 00:24:19.139 Robert Tseng: Thanks guys.
226 00:24:20.260 ⇒ 00:24:21.090 Luke Daque: Thanks everyone. Goodbye!
227 00:24:21.480 ⇒ 00:24:22.110 Luke Daque: Bye, bye.