Meeting Title: Bi-weekly Data infra／tech debt call Date: 2025-03-04 Meeting participants: Luke Daque, Caio Velasco
WEBVTT
1 00:00:52.740 ⇒ 00:00:53.493 Caio Velasco: Hey! Luke!
2 00:00:57.140 ⇒ 00:00:58.519 Luke Daque: Kyle, how’s it going.
3 00:00:59.190 ⇒ 00:01:00.389 Caio Velasco: Good! How are you?
4 00:01:00.920 ⇒ 00:01:02.029 Luke Daque: Yeah, doing? Well.
5 00:01:05.700 ⇒ 00:01:07.090 Luke Daque: It looks like.
6 00:01:11.080 ⇒ 00:01:14.479 Luke Daque: and awaii both decline the invite.
7 00:01:15.880 ⇒ 00:01:16.710 Caio Velasco: True.
8 00:01:17.100 ⇒ 00:01:23.990 Luke Daque: Yeah. And yeah, maybe let’s wait a bit for Nicholas and see if there’s anything we need to discuss
9 00:01:24.540 ⇒ 00:01:25.850 Luke Daque: for today.
10 00:01:28.340 ⇒ 00:01:30.110 Luke Daque: How’s everything on your end?
11 00:01:30.790 ⇒ 00:01:41.050 Caio Velasco: No, everything’s good, everything’s good. I just have some some questions regarding the Amazon dash. Gross selection.
12 00:01:41.980 ⇒ 00:01:47.200 Caio Velasco: that dashboard. Because I I’ve noticed some
13 00:01:47.710 ⇒ 00:01:51.959 Caio Velasco: that Utah has been tagging me on the Amazon dashboard.
14 00:01:52.908 ⇒ 00:01:58.670 Caio Velasco: Updated now on slack the the stuff
15 00:01:59.120 ⇒ 00:02:05.510 Caio Velasco: I’m just tagged on the gorgeous part which I believe has been delivered, so I’m not sure if there’s any new stuff.
16 00:02:06.040 ⇒ 00:02:09.229 Caio Velasco: or if I have to be working on the Amazon as well, so.
17 00:02:10.630 ⇒ 00:02:11.340 Luke Daque: Sure.
18 00:02:12.650 ⇒ 00:02:13.969 Caio Velasco: Then I’ll ask him.
19 00:02:15.320 ⇒ 00:02:16.640 Luke Daque: Okay. Cool.
20 00:02:16.890 ⇒ 00:02:20.950 Caio Velasco: You are focused on on the how’s it called.
21 00:02:23.670 ⇒ 00:02:24.840 Luke Daque: I understand that.
22 00:02:25.460 ⇒ 00:02:26.940 Caio Velasco: Stack blitz right.
23 00:02:27.220 ⇒ 00:02:33.088 Luke Daque: Oh, stack bits. Yeah, yeah, there’s still a lot to to do. We’re stuck. Let’s
24 00:02:34.150 ⇒ 00:02:38.049 Luke Daque: Yeah, they want to like, recreate the
25 00:02:38.908 ⇒ 00:02:43.089 Luke Daque: dashboards that they currently have, for, like bare metric, like
26 00:02:43.780 ⇒ 00:02:49.519 Luke Daque: like the monthly recurring revenue and stuff like that. And they want, like further
27 00:02:51.150 ⇒ 00:02:58.970 Luke Daque: be able to drill down further than just like the the monthly recurring revenue like, if it’s possible to break it down by
28 00:03:00.200 ⇒ 00:03:03.920 Luke Daque: what do you call this like plan and stuff like that. So
29 00:03:04.290 ⇒ 00:03:10.060 Luke Daque: yeah, that’s still, I’m working. That’s what I’m like, mostly spending my time on.
30 00:03:11.150 ⇒ 00:03:20.630 Caio Velasco: Okay? And then a question that I have. I? Well, I’ve been looking at what proper, and
31 00:03:21.170 ⇒ 00:03:31.839 Caio Velasco: I believe I wish I was we’re talking about in terms of many questions they have regarding Amazon stuff, the net margin of the gross margin.
32 00:03:32.720 ⇒ 00:03:34.600 Luke Daque: Yesterday. I guess right.
33 00:03:34.950 ⇒ 00:03:37.140 Caio Velasco: Yeah, I think so. There was a couple.
34 00:03:37.140 ⇒ 00:03:37.860 Luke Daque: Yeah.
35 00:03:38.163 ⇒ 00:03:45.760 Caio Velasco: And I think for when I I mean I I haven’t studied it yet, so I’m not sure I don’t know much about it. But
36 00:03:46.308 ⇒ 00:03:52.560 Caio Velasco: as I’ve been looking at the questions, those questions are basically issues.
37 00:03:53.550 ⇒ 00:03:56.269 Caio Velasco: Yeah, having defined.
38 00:03:56.740 ⇒ 00:04:13.640 Caio Velasco: let’s say, the variables. For example, people are asking how cops can be should be signed, or or I don’t know what is effect order line, or something like that. But those things they weren’t defined before we started. They started working on that.
39 00:04:15.160 ⇒ 00:04:20.339 Luke Daque: Yeah, I think I think it was. But I think
40 00:04:23.030 ⇒ 00:04:31.826 Luke Daque: yeah, it was only like me and pay us that we’re working on it so like I was creating the models. And then Payas was asking me to add, like
41 00:04:32.230 ⇒ 00:04:36.939 Luke Daque: stuff there, so you can add it to the dashboard, for example.
42 00:04:37.330 ⇒ 00:04:47.650 Luke Daque: So I guess that’s like, but yeah, I think the the disconnect there is like Robert doesn’t know what the the fields were
43 00:04:48.050 ⇒ 00:04:51.209 Luke Daque: like, how they were defined because it was just me and pay us.
44 00:04:51.480 ⇒ 00:04:55.577 Luke Daque: So yeah, I think it. It would be great, like the
45 00:04:56.620 ⇒ 00:05:05.660 Luke Daque: the Google sheets that we already are starting like to get like definitions of the measures and stuff like that. That would be great like for documentation
46 00:05:05.950 ⇒ 00:05:11.889 Luke Daque: like for anybody like want to look at like, for example, Robert, who’s
47 00:05:12.430 ⇒ 00:05:15.820 Luke Daque: I’m gonna be working on creating dashboards. You’ll be able to
48 00:05:15.990 ⇒ 00:05:18.169 Luke Daque: check it there and stuff like that.
49 00:05:18.690 ⇒ 00:05:28.479 Caio Velasco: Okay, yeah, because, for example, like, even if we were to define the dim or effective, or whatever those things are, are things we
50 00:05:28.740 ⇒ 00:05:31.809 Caio Velasco: created, based on
51 00:05:32.300 ⇒ 00:05:43.299 Caio Velasco: what whatever we had to do like in terms of understanding business, for example. So I mean something even before that, like a step back.
52 00:05:43.817 ⇒ 00:06:03.410 Caio Velasco: For example, when I was working at gorgeous, I had to really understand what is what is a micro water ticket fields, and what do they mean, because after we have those things well defined, then if you, wanna, you know, build cogs in a way or in a different way, then it’s just a matter of
53 00:06:03.570 ⇒ 00:06:09.479 Caio Velasco: going wherever the information is, and and using that, you know. Say, you know what I mean.
54 00:06:09.790 ⇒ 00:06:11.440 Luke Daque: Exactly. Yeah. I agree.
55 00:06:12.830 ⇒ 00:06:17.460 Caio Velasco: So let’s see if I can do something in the spreadsheet for that step.
56 00:06:18.090 ⇒ 00:06:21.050 Caio Velasco: And I also saw another one
57 00:06:21.160 ⇒ 00:06:25.500 Caio Velasco: another. Spreadsheet for calls, 3 PM. Assumptions.
58 00:06:25.780 ⇒ 00:06:27.410 Caio Velasco: What? What is that?
59 00:06:29.705 ⇒ 00:06:34.789 Luke Daque: Yeah, that was created by? I asked. And then
60 00:06:36.153 ⇒ 00:06:42.800 Luke Daque: let me open it again. So it has like the breakdown of the
61 00:06:43.752 ⇒ 00:06:46.470 Luke Daque: what do you call the cost?
62 00:06:46.920 ⇒ 00:06:50.389 Luke Daque: Like, for example, a product based on the products weight.
63 00:06:50.520 ⇒ 00:06:55.010 Luke Daque: the shipping cost would be different for each weight class.
64 00:06:55.590 ⇒ 00:06:57.820 Luke Daque: or like range of like the weight.
65 00:06:58.080 ⇒ 00:07:00.949 Luke Daque: So that’s like the cost associated to it.
66 00:07:01.610 ⇒ 00:07:04.130 Luke Daque: And let’s see, let me open it.
67 00:07:04.320 ⇒ 00:07:08.960 Luke Daque: So there’s also like box costs. So these are all shipping costs.
68 00:07:09.520 ⇒ 00:07:14.490 Luke Daque: so based on weight like the shipping assumptions. Tab, for example, is based on weight. For
69 00:07:14.690 ⇒ 00:07:17.710 Luke Daque: for one, I I guess, Kilo.
70 00:07:18.030 ⇒ 00:07:21.259 Luke Daque: it will be around $5.58,
71 00:07:21.680 ⇒ 00:07:24.550 Luke Daque: and then for a 2 kg
72 00:07:26.450 ⇒ 00:07:31.060 Luke Daque: product that would be like $6.22 something like that.
73 00:07:31.680 ⇒ 00:07:35.780 Luke Daque: And those those that logic we don’t. We didn’t.
74 00:07:36.140 ⇒ 00:07:39.810 Caio Velasco: We didn’t, or we don’t receive that from the client.
75 00:07:41.390 ⇒ 00:07:45.646 Luke Daque: I believe this was
76 00:07:47.020 ⇒ 00:07:57.530 Luke Daque: yeah, I think pay us would be the better person to answer this question, because he was the one who created this, and I believe he did share it with the client. And it’s the client that
77 00:07:57.720 ⇒ 00:07:59.669 Luke Daque: I did these in here.
78 00:08:00.380 ⇒ 00:08:06.319 Caio Velasco: Okay, cool. Yeah. That’s exactly what I was talking about. Like the like. Basically, the logic.
79 00:08:07.010 ⇒ 00:08:07.690 Luke Daque: Yeah.
80 00:08:07.960 ⇒ 00:08:10.530 Luke Daque: But we already did add this to the
81 00:08:11.340 ⇒ 00:08:14.069 Luke Daque: models. Right? So if you look in
82 00:08:14.330 ⇒ 00:08:17.760 Luke Daque: the fact orders, for example, or the fact, order lines.
83 00:08:18.370 ⇒ 00:08:23.569 Luke Daque: We should be included in there as like the cogs cost, or something.
84 00:08:24.420 ⇒ 00:08:27.589 Luke Daque: Cost of goods sold shipping cost.
85 00:08:30.086 ⇒ 00:08:32.820 Caio Velasco: Meeting in the DVD. Model.
86 00:08:34.409 ⇒ 00:08:40.519 Luke Daque: Yeah, let me let me check when I believe that’s in order line items, for example.
87 00:08:41.679 ⇒ 00:08:42.579 Luke Daque: Yeah, he
88 00:08:46.189 ⇒ 00:08:52.879 Luke Daque: let me try to open the repository.
89 00:08:56.929 ⇒ 00:08:59.029 Luke Daque: Or maybe it’s in shipment.
90 00:09:02.344 ⇒ 00:09:02.979 Luke Daque: No.
91 00:09:05.829 ⇒ 00:09:07.159 Luke Daque: Directory.
92 00:09:08.069 ⇒ 00:09:08.939 Luke Daque: Okay?
93 00:09:12.139 ⇒ 00:09:18.619 Luke Daque: Yeah. So in in fact, order lines, for example, there’s
94 00:09:23.859 ⇒ 00:09:26.969 Luke Daque: total cogs, fields and new cogs.
95 00:09:27.979 ⇒ 00:09:32.319 Luke Daque: So from Row 1 22 maybe I can share my screen. That would be easier.
96 00:09:32.320 ⇒ 00:09:39.729 Caio Velasco: Yeah. And then the question, should we use this meeting because it’s recorded? Or can we just huddle? Or what do you think.
97 00:09:40.330 ⇒ 00:09:41.779 Luke Daque: Yeah, that’s a good question.
98 00:09:42.400 ⇒ 00:09:48.109 Luke Daque: well, I guess we we have nothing else to talk about, anyway, because it’s just the 2 of us here, so maybe we can just use this
99 00:09:49.030 ⇒ 00:09:49.680 Luke Daque: better.
100 00:09:50.350 ⇒ 00:09:51.930 Luke Daque: Can you see my screen? By the way.
101 00:09:52.640 ⇒ 00:09:53.240 Caio Velasco: Yeah.
102 00:09:54.080 ⇒ 00:10:00.829 Luke Daque: Yeah. So this part and the order line items, and this one, these are all coming from
103 00:10:02.430 ⇒ 00:10:04.640 Luke Daque: from the the this sheet.
104 00:10:05.519 ⇒ 00:10:10.560 Luke Daque: So, yeah, if you look at. So it’s in in, in, in the intermediate
105 00:10:10.800 ⇒ 00:10:13.799 Luke Daque: model of shopify order line. So you could look at that.
106 00:10:15.710 ⇒ 00:10:17.970 Luke Daque: Then we just shopify order line.
107 00:10:18.600 ⇒ 00:10:23.110 Luke Daque: I believe this is also in Amazon as well.
108 00:10:24.320 ⇒ 00:10:29.547 Luke Daque: So here you can see, we are joining of before
109 00:10:30.590 ⇒ 00:10:38.520 Luke Daque: Google sheets, or Google tabs like shipping assumption box cost
110 00:10:39.270 ⇒ 00:10:47.390 Luke Daque: big fees and platform fees, which are all this one shipping assumptions but big fees and platform fees.
111 00:10:48.530 ⇒ 00:10:57.080 Luke Daque: So that’s where we get the yeah, the the the codes product cost.
112 00:10:58.318 ⇒ 00:11:00.711 Caio Velasco: Sorry for the dumb question.
113 00:11:02.160 ⇒ 00:11:04.989 Luke Daque: Cogs. This is cost of goods sold, basically.
114 00:11:05.420 ⇒ 00:11:06.710 Caio Velasco: Okay. Yeah. Yeah.
115 00:11:07.450 ⇒ 00:11:08.760 Luke Daque: So, yeah.
116 00:11:10.620 ⇒ 00:11:18.190 Luke Daque: so that’s that way. I believe that way, we can calculate the net revenue. So we have total revenue based on the price.
117 00:11:18.350 ⇒ 00:11:19.880 Luke Daque: right? Product price.
118 00:11:20.640 ⇒ 00:11:27.170 Luke Daque: Where is it? Somewhere here? Product price, yeah. But
119 00:11:28.230 ⇒ 00:11:32.119 Luke Daque: product price would be the total here. This one be like the total.
120 00:11:32.300 ⇒ 00:11:35.400 Caio Velasco: Revenue, and then, if we.
121 00:11:36.250 ⇒ 00:11:43.379 Luke Daque: If we subtract the discounts, the tax, the what else?
122 00:11:44.830 ⇒ 00:11:50.140 Luke Daque: And the cost, like all of these costs. Shipping cost product cost
123 00:11:51.254 ⇒ 00:11:59.550 Luke Daque: unit box cost. Then then we can get the net revenue and we’ll be able to. Yeah, break it down
124 00:11:59.880 ⇒ 00:12:02.819 Luke Daque: by whatever cost is associated to it.
125 00:12:04.190 ⇒ 00:12:08.339 Luke Daque: Come from discounted tax to all the other cost of goods sold.
126 00:12:09.090 ⇒ 00:12:09.910 Luke Daque: That’s what.
127 00:12:09.910 ⇒ 00:12:10.330 Caio Velasco: Okay.
128 00:12:10.330 ⇒ 00:12:10.940 Luke Daque: And.
129 00:12:11.410 ⇒ 00:12:18.810 Caio Velasco: Okay, and those the all. This logic came from interaction between Javi And- and pilots.
130 00:12:19.580 ⇒ 00:12:21.640 Luke Daque: That’s what I understand as well. Yep.
131 00:12:22.000 ⇒ 00:12:31.249 Luke Daque: So yeah, it would be best to ask pay us for this one, and maybe we can define. It added to the Google sheet that we have for the definition of the measures.
132 00:12:32.535 ⇒ 00:12:33.220 Luke Daque: Yeah.
133 00:12:34.260 ⇒ 00:12:36.919 Caio Velasco: Okay, okay, I see, yeah. So maybe we’ll.
134 00:12:37.020 ⇒ 00:12:38.470 Luke Daque: Yeah, cause that’s so like.
135 00:12:38.470 ⇒ 00:12:40.556 Caio Velasco: That’s where.
136 00:12:41.600 ⇒ 00:12:42.999 Luke Daque: I, yeah, yeah, go ahead.
137 00:12:43.640 ⇒ 00:12:47.470 Caio Velasco: But I was just gonna say that, can you open the the other spreadsheet.
138 00:12:49.590 ⇒ 00:12:50.310 Luke Daque: This one.
139 00:12:50.840 ⇒ 00:12:51.769 Caio Velasco: No, the other one.
140 00:12:51.770 ⇒ 00:12:53.640 Caio Velasco: I didn’t on mute. Yeah.
141 00:12:54.920 ⇒ 00:12:55.386 Luke Daque: Yeah, but
142 00:12:57.430 ⇒ 00:12:59.780 Caio Velasco: Can try to find the name here.
143 00:13:00.740 ⇒ 00:13:01.490 Luke Daque: Me!
144 00:13:02.850 ⇒ 00:13:03.470 Caio Velasco: It’s.
145 00:13:03.470 ⇒ 00:13:04.470 Luke Daque: Let’s just the.
146 00:13:06.705 ⇒ 00:13:08.940 Caio Velasco: Yeah.
147 00:13:08.940 ⇒ 00:13:11.150 Luke Daque: I I guess this one. Yeah, I think you have.
148 00:13:13.020 ⇒ 00:13:23.920 Caio Velasco: If you go. Yes, in entity, definition, that’s like where I would expect, like what are cost? Water, what is revenue? What is this? What is that? What is that? What is the discount? XYZ.
149 00:13:24.680 ⇒ 00:13:26.500 Luke Daque: Yeah, makes sense.
150 00:13:27.826 ⇒ 00:13:36.999 Caio Velasco: Okay? Maybe I can start from this. And we can. I think that would be helpful for me to like, understand, what is the
151 00:13:37.260 ⇒ 00:13:40.649 Caio Velasco: yeah mean, what is the project at the end of the day?
152 00:13:41.260 ⇒ 00:13:42.000 Luke Daque: Yeah.
153 00:13:44.300 ⇒ 00:13:50.470 Caio Velasco: Okay, okay, cool, cool. I’ll start by by doing that in our you can.
154 00:13:50.770 ⇒ 00:13:55.440 Caio Velasco: If I should focus on this or or any anything else, contest.
155 00:13:55.970 ⇒ 00:13:56.970 Luke Daque: Sounds good.
156 00:13:57.390 ⇒ 00:13:59.689 Caio Velasco: Sounds good. Thanks, man. Appreciate it.
157 00:14:00.090 ⇒ 00:14:01.949 Luke Daque: Yeah, no worries, no problem.
158 00:14:03.330 ⇒ 00:14:10.189 Luke Daque: Yeah. I guess that. We also have like a meeting at 10 in in a minute. So maybe we can just
159 00:14:10.690 ⇒ 00:14:12.020 Luke Daque: transfer there.
160 00:14:12.930 ⇒ 00:14:13.880 Caio Velasco: Oh, you do!
161 00:14:14.790 ⇒ 00:14:20.079 Luke Daque: Or maybe oh, it looks like you moved. It was here earlier.
162 00:14:20.720 ⇒ 00:14:25.800 Caio Velasco: Yeah, I think we had 2, the ae, and then the data center. But yeah, we’ve done.
163 00:14:25.800 ⇒ 00:14:26.939 Luke Daque: They canceled it.
164 00:14:29.630 ⇒ 00:14:31.720 Caio Velasco: Alright. Yeah. Okay. Okay. Cool.
165 00:14:32.060 ⇒ 00:14:32.929 Luke Daque: Sounds good.
166 00:14:33.040 ⇒ 00:14:33.830 Caio Velasco: Thanks.
167 00:14:33.830 ⇒ 00:14:34.630 Caio Velasco: Thank you.
168 00:14:34.800 ⇒ 00:14:35.359 Luke Daque: Bye, bye.
169 00:14:36.100 ⇒ 00:14:36.840 Caio Velasco: Correct!
170 00:14:38.210 ⇒ 00:14:38.950 Caio Velasco: Oh.