Meeting Title: Analyst Team Daily Date: 2025-03-03 Meeting participants: Uttam Kumaran, Robert Tseng
WEBVTT
1 00:00:19.790 ⇒ 00:00:20.730 Uttam Kumaran: Hey!
2 00:00:21.480 ⇒ 00:00:22.340 Robert Tseng: Hey?
3 00:00:24.990 ⇒ 00:00:27.830 Robert Tseng: I am in the I’m in the Zone.
4 00:00:27.830 ⇒ 00:00:28.610 Uttam Kumaran: Okay.
5 00:00:28.790 ⇒ 00:00:31.000 Uttam Kumaran: I interview was good.
6 00:00:31.000 ⇒ 00:00:31.930 Robert Tseng: Oh, yeah.
7 00:00:33.760 ⇒ 00:00:36.520 Uttam Kumaran: I I think I mean.
8 00:00:37.170 ⇒ 00:00:41.219 Uttam Kumaran: I don’t know like she’s kind of like a mixed bag of like skills.
9 00:00:43.400 ⇒ 00:00:49.219 Uttam Kumaran: I honestly think a little at minimum. She can come, help me with ABC and like, take over basically, like
10 00:00:49.880 ⇒ 00:00:51.870 Uttam Kumaran: all the Pm shit I’m doing there
11 00:00:54.370 ⇒ 00:00:59.319 Uttam Kumaran: and like it would be very. I mean, I could tell that if she starts to look at the work that we’re doing there
12 00:00:59.420 ⇒ 00:01:01.310 Uttam Kumaran: she’d be very, very interested.
13 00:01:01.850 ⇒ 00:01:02.450 Robert Tseng: Yeah.
14 00:01:02.930 ⇒ 00:01:06.140 Uttam Kumaran: So that that probably buys at least like
15 00:01:06.890 ⇒ 00:01:08.969 Uttam Kumaran: 4 or 5 h of my time a week.
16 00:01:11.500 ⇒ 00:01:15.690 Uttam Kumaran: I mean, that may be a good place to start.
17 00:01:16.451 ⇒ 00:01:21.159 Uttam Kumaran: I mean, I would prefer she go on to something that’s like more heavy. But
18 00:01:24.750 ⇒ 00:01:26.040 Uttam Kumaran: I don’t know
19 00:01:27.020 ⇒ 00:01:27.770 Robert Tseng: Okay.
20 00:01:31.650 ⇒ 00:01:33.410 Uttam Kumaran: I could think about it a little bit longer.
21 00:01:37.360 ⇒ 00:01:45.696 Robert Tseng: Yeah, I mean, I like, I guess I I mentioned she feel like she’s a generalist can can plug into a lot of different areas.
22 00:01:48.200 ⇒ 00:01:54.160 Uttam Kumaran: Yeah, I agree. And and I think she’s like, has the same similar mindset to me where I’m like.
23 00:01:55.070 ⇒ 00:02:00.880 Uttam Kumaran: the work is the work. But our goal is to like just every time we do it, to get to make it faster. So
24 00:02:01.470 ⇒ 00:02:02.009 Uttam Kumaran: I’m
25 00:02:03.190 ⇒ 00:02:06.090 Uttam Kumaran: We’ll see you, I mean again, like I,
26 00:02:06.710 ⇒ 00:02:10.680 Uttam Kumaran: if people are good, they’ll shine. That’s it. So I might give her something.
27 00:02:10.870 ⇒ 00:02:14.039 Uttam Kumaran: And okay, so I can. I can.
28 00:02:14.590 ⇒ 00:02:15.730 Uttam Kumaran: I can figure it out.
29 00:02:17.020 ⇒ 00:02:17.640 Robert Tseng: Cool.
30 00:02:19.180 ⇒ 00:02:24.810 Robert Tseng: I mean. She told me she was very excited. She like I mean I don’t know. She’s she seems very proactive.
31 00:02:25.340 ⇒ 00:02:27.689 Uttam Kumaran: Yeah, yeah, no. I think she’s. I think
32 00:02:28.850 ⇒ 00:02:33.119 Uttam Kumaran: she definitely like, seems really high energy and like, wants to do something in this space.
33 00:02:33.380 ⇒ 00:02:40.479 Uttam Kumaran: I think she’s gonna have. She’s definitely I could see why she would have trouble getting a job because people don’t hire people like that
34 00:02:41.615 ⇒ 00:02:50.130 Uttam Kumaran: like meaning like nobody wants like I mean, maybe, except for me, but like nobody wants to hear
35 00:02:51.110 ⇒ 00:02:52.819 Uttam Kumaran: that you could do everything.
36 00:02:52.950 ⇒ 00:02:59.759 Uttam Kumaran: I tell that to a lot. I tell that to a lot of my friends who are interviewing because they’re like, I don’t know like on this. On this I’m like, believe me, like
37 00:03:00.120 ⇒ 00:03:04.759 Uttam Kumaran: no corporate person you want to hear is gonna be wants to hear your like dream.
38 00:03:05.242 ⇒ 00:03:08.060 Uttam Kumaran: But I do. I want to hear.
39 00:03:09.110 ⇒ 00:03:11.341 Uttam Kumaran: So for people like her, I think it’s
40 00:03:12.030 ⇒ 00:03:19.434 Uttam Kumaran: We’re a good place to be, because also, like, I don’t know, I feel I feel it’s unfortunate. Sometimes we have to hire people in like distinct roles, because.
41 00:03:20.570 ⇒ 00:03:22.860 Robert Tseng: It’s it’s too liquid right now. Yeah.
42 00:03:22.860 ⇒ 00:03:27.960 Uttam Kumaran: And me, and you don’t have a role like. And so what the fuck like? Why is everyone else get a role? You know.
43 00:03:28.180 ⇒ 00:03:28.700 Robert Tseng: Yeah.
44 00:03:28.700 ⇒ 00:03:30.597 Uttam Kumaran: It’s a luxury.
45 00:03:31.230 ⇒ 00:03:31.790 Robert Tseng: Yeah.
46 00:03:32.350 ⇒ 00:03:38.347 Uttam Kumaran: So I like, when people are like Yo, if I need this, you need me to do this. Today we’ll do this tomorrow. We’ll do this. And
47 00:03:40.190 ⇒ 00:03:40.843 Uttam Kumaran: so, yeah.
48 00:03:45.840 ⇒ 00:03:46.510 Robert Tseng: Cool.
49 00:03:47.470 ⇒ 00:03:50.260 Uttam Kumaran: Okay, let me keep working on some Javi stuff.
50 00:04:09.160 ⇒ 00:04:11.719 Robert Tseng: I’ll I’ll just stay on here. Yeah, yeah.
51 00:04:11.910 ⇒ 00:04:14.530 Uttam Kumaran: Gonna stay on for this.
52 00:04:14.650 ⇒ 00:04:16.160 Robert Tseng: Please let me know.
53 00:04:16.160 ⇒ 00:04:18.420 Uttam Kumaran: Yeah, for the subscribe and save.
54 00:04:21.050 ⇒ 00:04:25.000 Uttam Kumaran: They wanted it by like product.
55 00:04:28.710 ⇒ 00:04:31.460 Robert Tseng: Correct. So if we could get it at the order line.
56 00:04:31.750 ⇒ 00:04:38.779 Robert Tseng: I also have, like, yeah, the thing. The subscription tagging on the order line is kind of kind of off fact, order line is kind of off.
57 00:05:42.580 ⇒ 00:05:43.389 Robert Tseng: Don’t like that.
58 00:05:46.120 ⇒ 00:05:47.370 Robert Tseng: No.
59 00:05:48.890 ⇒ 00:05:50.230 Robert Tseng: Why did that happen?
60 00:05:52.560 ⇒ 00:05:53.470 Robert Tseng: Okay.
61 00:05:59.840 ⇒ 00:06:01.070 Robert Tseng: over here
62 00:06:04.110 ⇒ 00:06:07.020 Robert Tseng: just want this looking. Really.
63 00:06:31.110 ⇒ 00:06:33.370 Robert Tseng: Yeah, come back. It looks better
64 00:06:36.620 ⇒ 00:06:40.500 Robert Tseng: in alphabetical order. And that’s fine. Nothing like that.
65 00:06:41.370 ⇒ 00:06:42.060 Robert Tseng: Bye.
66 00:06:44.980 ⇒ 00:06:48.400 Robert Tseng: Great. That’s just very clear.
67 00:06:49.010 ⇒ 00:06:49.940 Robert Tseng: Love that.
68 00:06:50.300 ⇒ 00:06:52.080 Robert Tseng: Okay, there’s our order
69 00:06:57.940 ⇒ 00:07:01.469 Robert Tseng: dude. I want to be paid $80 an hour and just click around on this crap.
70 00:07:03.810 ⇒ 00:07:06.210 Uttam Kumaran: Do not do not get me started.
71 00:07:07.995 ⇒ 00:07:09.780 Robert Tseng: Ridiculous.
72 00:07:09.780 ⇒ 00:07:11.659 Uttam Kumaran: Do not get me started like.
73 00:07:11.660 ⇒ 00:07:13.450 Robert Tseng: Okay. Okay. I won’t say anything.
74 00:07:15.460 ⇒ 00:07:23.759 Uttam Kumaran: Whatever you’re feeling, I may smile when I wake up in the morning. But yeah, I am like
75 00:07:24.940 ⇒ 00:07:29.740 Uttam Kumaran: the day will come when this fucking type of bull this bullshit ends.
76 00:07:32.870 ⇒ 00:07:36.569 Uttam Kumaran: I just I just hate excuses I just like
77 00:07:37.300 ⇒ 00:07:39.100 Uttam Kumaran: don’t like. I just like cannot.
78 00:07:39.320 ⇒ 00:07:40.859 Uttam Kumaran: I cannot imagine.
79 00:07:43.010 ⇒ 00:07:43.720 Robert Tseng: Yeah.
80 00:09:22.890 ⇒ 00:09:27.530 Robert Tseng: and breakout
81 00:09:35.830 ⇒ 00:09:37.610 Robert Tseng: should be a staff bar.
82 00:09:37.850 ⇒ 00:09:38.975 Robert Tseng: What would be a stack?
83 00:09:50.980 ⇒ 00:09:52.919 Robert Tseng: Maybe this doesn’t even make sense.
84 00:10:11.210 ⇒ 00:10:12.000 Robert Tseng: Get that?
85 00:10:35.090 ⇒ 00:10:35.910 Robert Tseng: Hello!
86 00:11:29.040 ⇒ 00:11:33.080 Robert Tseng: See? It’s just oh.
87 00:11:40.380 ⇒ 00:11:41.470 Robert Tseng: how does that work?
88 00:12:02.680 ⇒ 00:12:04.560 Robert Tseng: Yeah, that looks good.
89 00:13:27.220 ⇒ 00:13:30.010 Uttam Kumaran: Dude, fucking pious needs to just fuck off.
90 00:13:30.970 ⇒ 00:13:32.020 Uttam Kumaran: Oh, my God!
91 00:13:34.520 ⇒ 00:13:35.440 Robert Tseng: What happened?
92 00:13:37.090 ⇒ 00:13:38.450 Uttam Kumaran: I don’t know like.
93 00:13:42.100 ⇒ 00:13:43.560 Robert Tseng: Is he asking for something?
94 00:13:43.560 ⇒ 00:13:44.670 Uttam Kumaran: No
95 00:13:52.730 ⇒ 00:13:55.159 Uttam Kumaran: I talked to Amon on Friday.
96 00:13:56.680 ⇒ 00:14:04.250 Uttam Kumaran: and he’s picking me about something we talked about, and pious as Bert is coming in, and and promising shit
97 00:14:04.430 ⇒ 00:14:06.269 Uttam Kumaran: that he didn’t talk to him about.
98 00:14:09.020 ⇒ 00:14:19.799 Uttam Kumaran: And why is like, why is pious like, I’m worried about spending your build time of productionalizing a thing. Stop talking to him about this shit. You’re not fucking talk. You’re not leading this client.
99 00:14:23.320 ⇒ 00:14:24.230 Uttam Kumaran: It’s like.
100 00:14:27.430 ⇒ 00:14:36.600 Uttam Kumaran: do the fucking, gorgeous dashboard that you fucking tried to. You need to do last week. Why are you sitting here responding to a mon? I don’t get it.
101 00:14:39.930 ⇒ 00:14:41.670 Uttam Kumaran: Jesus Christ!
102 00:14:46.520 ⇒ 00:14:47.570 Uttam Kumaran: Oh.
103 00:14:48.600 ⇒ 00:14:49.640 Robert Tseng: I see.
104 00:14:50.240 ⇒ 00:14:51.129 Uttam Kumaran: Whatever it is.
105 00:17:08.310 ⇒ 00:17:09.679 Robert Tseng: All of
106 00:17:15.460 ⇒ 00:17:16.470 Robert Tseng: Whoa
107 00:17:20.050 ⇒ 00:17:23.579 Robert Tseng: pay price. Retax price.
108 00:17:33.470 ⇒ 00:17:35.729 Robert Tseng: Where is the line? Item price.
109 00:17:56.340 ⇒ 00:18:01.079 Robert Tseng: That’s because you join this completely unnecessary.
110 00:18:02.650 ⇒ 00:18:06.870 Robert Tseng: Just do a straight from line item, you don’t need to do join. Why, the hell’s join for?
111 00:18:08.900 ⇒ 00:18:10.000 Robert Tseng: Yeah. Okay.
112 00:18:12.240 ⇒ 00:18:19.019 Robert Tseng: Yep. Nope, we’re gonna we’re gonna also for that one
113 00:18:39.560 ⇒ 00:18:41.910 Robert Tseng: cost and cost box.
114 00:18:42.360 ⇒ 00:18:43.140 Robert Tseng: Plus.
115 00:18:47.910 ⇒ 00:18:51.830 Robert Tseng: No, no, it was straight up
116 00:19:05.740 ⇒ 00:19:13.630 Robert Tseng: that one off 1st password that is discount by this Cox.
117 00:19:14.230 ⇒ 00:19:16.410 Robert Tseng: That is correct.
118 00:19:18.330 ⇒ 00:19:20.749 Robert Tseng: Cause that bakes in the
119 00:19:23.890 ⇒ 00:19:25.470 Robert Tseng: screen, calls.
120 00:19:44.820 ⇒ 00:19:46.429 Uttam Kumaran: Share the personal.
121 00:20:00.630 ⇒ 00:20:03.339 Robert Tseng: Yeah, but I don’t pay for shipping in this case
122 00:20:57.620 ⇒ 00:21:05.180 Robert Tseng: all of the time. The shipping cost is just not, and
123 00:21:27.890 ⇒ 00:21:30.810 Robert Tseng: some events baked into the price.
124 00:21:32.590 ⇒ 00:21:34.929 Robert Tseng: It’s because they never pay for it.
125 00:21:49.220 ⇒ 00:21:55.960 Robert Tseng: hey? Would would you know, if the order line price
126 00:21:57.190 ⇒ 00:22:04.440 Robert Tseng: includes shipping like for order, price, fact, order price. It does. But for fact, order line.
127 00:22:05.940 ⇒ 00:22:07.109 Robert Tseng: I’m not sure.
128 00:22:07.250 ⇒ 00:22:09.010 Uttam Kumaran: Fact orders
129 00:22:15.960 ⇒ 00:22:28.479 Uttam Kumaran: you’re saying for the it’s just the item price amount is price item, price amount
130 00:22:32.367 ⇒ 00:22:39.570 Uttam Kumaran: I can. There’s there’s there’s item price, there’s price, pre tax price, total discount tax amount.
131 00:22:42.000 ⇒ 00:22:44.910 Robert Tseng: Yeah, I guess you wouldn’t be able to tell from there. Hmm!
132 00:22:45.310 ⇒ 00:22:46.290 Robert Tseng: That’s fine.
133 00:22:48.800 ⇒ 00:22:55.239 Uttam Kumaran: If you pull up the another way is, if you pull up a specific shopify order, you can also just compare the order lines to.
134 00:22:55.240 ⇒ 00:22:57.219 Robert Tseng: Yeah, yeah, I’m I’m doing that.
135 00:22:57.220 ⇒ 00:22:58.050 Uttam Kumaran: Okay. Okay.
136 00:23:08.470 ⇒ 00:23:13.920 Robert Tseng: Name point 9 5 2 most must.
137 00:23:22.110 ⇒ 00:23:24.280 Robert Tseng: I think it does include it.
138 00:23:28.530 ⇒ 00:23:29.280 Robert Tseng: But
139 00:23:33.860 ⇒ 00:23:35.180 Robert Tseng: can I share my screen.
140 00:23:35.630 ⇒ 00:23:36.180 Uttam Kumaran: Yeah.
141 00:23:39.700 ⇒ 00:23:41.780 Robert Tseng: Okay? So I’m looking at this order.
142 00:23:42.350 ⇒ 00:23:44.070 Robert Tseng: Back orders, back order, line
143 00:23:44.410 ⇒ 00:23:51.109 Robert Tseng: shopify total price. Here is 58, 28, which matches what’s here, and that includes a 5, 95 shipping.
144 00:23:53.321 ⇒ 00:23:59.710 Robert Tseng: When I take the price here, which is after discount before tax.
145 00:24:00.070 ⇒ 00:24:02.630 Robert Tseng: And supposedly, yeah.
146 00:24:03.000 ⇒ 00:24:06.040 Robert Tseng: But yeah, supposedly pre tax and after discount
147 00:24:06.920 ⇒ 00:24:17.460 Robert Tseng: and if I add these together, I get 55.8 off by a few dollars, which I’m assuming is just the tax rate, because if I add up this tax amount, then I get the same amount
148 00:24:18.020 ⇒ 00:24:27.509 Robert Tseng: which to me tells me that within the price the cost of shipping is baked into it already, somehow, even though it’s a separate line item here.
149 00:24:29.270 ⇒ 00:24:30.790 Uttam Kumaran: They’re saying we should deduct it.
150 00:24:35.175 ⇒ 00:24:42.329 Robert Tseng: Well, no, I mean, I’m I’m okay with keeping it in there, because if we’re going to recognize cost.
151 00:24:42.330 ⇒ 00:24:51.019 Uttam Kumaran: It is already in there. I think that’s a correct assumption, because I’m looking at the logic. And it looks like we’re removing those items, including shipping price.
152 00:24:51.760 ⇒ 00:24:54.960 Robert Tseng: Yeah, I think it’s included in there which is like.
153 00:24:55.870 ⇒ 00:24:58.160 Uttam Kumaran: That’s probably they pay the shipping amount.
154 00:25:00.420 ⇒ 00:25:14.329 Robert Tseng: Yeah, I guess I was just because we had talked about like, Oh, we don’t actually know what the shipping is until the order is set sent out. But if it’s already baked into the line item price, then that means we are breaking out shipping by line. Item. Somehow.
155 00:25:15.890 ⇒ 00:25:19.340 Uttam Kumaran: We don’t know what the shipping is in terms of like what they paid.
156 00:25:19.520 ⇒ 00:25:26.540 Uttam Kumaran: but like they pay a upfront shipping cost like the cost to actually ship
157 00:25:26.750 ⇒ 00:25:29.970 Uttam Kumaran: from Javi side is different than that.
158 00:25:32.320 ⇒ 00:25:34.789 Robert Tseng: Oh, I see it’s not 5, 95.
159 00:25:35.230 ⇒ 00:25:40.069 Uttam Kumaran: 5 95 is yeah, 5, 95 is basically like a flat rate.
160 00:25:40.410 ⇒ 00:25:44.339 Uttam Kumaran: The actual cost may differ, but they sort of cover it all.
161 00:25:45.800 ⇒ 00:25:51.590 Robert Tseng: Got it. So it’s saying, Here, shipping cost is 7. Yeah, they’ll win some on some, and they’ll lose some on some of the shipping.
162 00:25:51.720 ⇒ 00:25:55.530 Uttam Kumaran: Yeah, I think so.
163 00:25:55.790 ⇒ 00:26:02.960 Robert Tseng: Okay, that makes sense that, why would they calculate shipping? So yeah, I mean, that’s how that’s how zoning works. Yeah, okay.
164 00:26:06.190 ⇒ 00:26:07.660 Robert Tseng: interesting.
165 00:26:08.750 ⇒ 00:26:16.000 Robert Tseng: Okay. But then the the what they charge to the customer in terms of shipping is already baked into the price. Okay.
166 00:26:17.040 ⇒ 00:26:21.440 Robert Tseng: okay, well, that’s that’s interesting.
167 00:26:25.190 ⇒ 00:26:29.880 Robert Tseng: Okay, whatever I don’t. I don’t wanna think too much about it right now, but that that clears it up. Cool
168 00:26:34.460 ⇒ 00:26:35.140 Robert Tseng: right.
169 00:26:35.330 ⇒ 00:26:37.770 Robert Tseng: Finish this in like 5 min.
170 00:26:59.860 ⇒ 00:27:00.550 Robert Tseng: Wow!
171 00:27:01.330 ⇒ 00:27:08.759 Uttam Kumaran: I think I’m gonna do a big 2 birds, one stone with this Pr, I’ll give you the customer type returning for Amazon
172 00:27:09.090 ⇒ 00:27:12.200 Uttam Kumaran: and like the reviews work. So let’s finish this.
173 00:27:20.870 ⇒ 00:27:22.840 Uttam Kumaran: Steven asked some good questions.
174 00:27:23.600 ⇒ 00:27:24.930 Robert Tseng: Yeah, so far, I think.
175 00:27:24.930 ⇒ 00:27:26.220 Uttam Kumaran: Liking the question.
176 00:27:28.100 ⇒ 00:27:33.406 Uttam Kumaran: I was for a minute there this afternoon. I was like no questions coming through.
177 00:29:44.280 ⇒ 00:29:46.340 Robert Tseng: Alright. It’s already after discount.
178 00:29:51.250 ⇒ 00:29:52.749 Robert Tseng: Yeah, it’s not for discount.
179 00:29:53.450 ⇒ 00:29:55.590 Robert Tseng: So I don’t need to resubtract it again. Okay.
180 00:29:59.510 ⇒ 00:30:00.740 Robert Tseng: with catch.
181 00:42:45.650 ⇒ 00:42:47.670 Robert Tseng: Oh, what if I did
182 00:45:50.250 ⇒ 00:45:52.619 Robert Tseng: so I flipped these.
183 00:46:11.570 ⇒ 00:46:14.120 Robert Tseng: and you can look at the trends
184 00:46:24.790 ⇒ 00:46:30.440 Robert Tseng: and filter by warm category. Here.
185 00:46:35.990 ⇒ 00:46:37.860 Robert Tseng: what’s the best way to do this?
186 00:47:01.510 ⇒ 00:47:04.420 Robert Tseng: And this will just tell me it’s like.
187 00:47:04.750 ⇒ 00:47:08.239 Robert Tseng: okay, shipping is consistently a big cost center.
188 00:47:10.410 ⇒ 00:47:11.080 Robert Tseng: Okay?
189 00:47:19.420 ⇒ 00:47:22.989 Robert Tseng: Whereas platform fees are not picking. Costs
190 00:47:23.140 ⇒ 00:47:26.840 Robert Tseng: are expensive for accessories and shakes.
191 00:47:28.020 ⇒ 00:47:30.880 Robert Tseng: Big costs are not expensive all the time.
192 00:47:32.910 ⇒ 00:47:38.009 Robert Tseng: Want it to be relative product cost makes sense.
193 00:47:43.920 ⇒ 00:47:46.260 Robert Tseng: Is that helpful? Or is that just distraction?
194 00:47:46.380 ⇒ 00:47:47.179 Robert Tseng: It’s like.
195 00:47:50.650 ⇒ 00:47:55.660 Robert Tseng: okay, whatever. It’s fine, anything I should take out one month.
196 00:48:18.160 ⇒ 00:48:19.280 Robert Tseng: Here it happens.
197 00:50:58.230 ⇒ 00:51:01.580 Robert Tseng: Let’s wrap this up. You don’t need to give them every day.
198 00:51:15.200 ⇒ 00:51:18.010 Robert Tseng: We’ll break it up by offer. Name.
199 00:51:32.310 ⇒ 00:51:33.160 Robert Tseng: Yeah.
200 00:52:12.230 ⇒ 00:52:14.889 Robert Tseng: Oh, wonder by flavor. Huh?
201 00:52:16.300 ⇒ 00:52:19.189 Robert Tseng: Okay, fine. I can add that. And then that’s it.
202 00:52:21.370 ⇒ 00:52:23.160 Robert Tseng: It’s not like they ask for offer.
203 00:52:27.400 ⇒ 00:52:28.630 Robert Tseng: Bit clean.
204 00:53:42.190 ⇒ 00:53:48.000 Uttam Kumaran: So how do we provide on? What? The oh.
205 00:53:49.470 ⇒ 00:53:59.110 Uttam Kumaran: rating on customer satisfaction, joining with blah blah create a Boolean left score
206 00:54:29.120 ⇒ 00:54:33.820 Uttam Kumaran: the left review invite to, and tickets new. If there’s a ticket. Id.
207 00:54:34.180 ⇒ 00:54:37.959 Uttam Kumaran: please create a Boolean called, send survey.
208 00:54:39.780 ⇒ 00:54:40.460 Uttam Kumaran: Okay.
209 00:54:45.470 ⇒ 00:54:51.019 Uttam Kumaran: Macros. Use as an array. No, Macro fused as an array.
210 00:54:55.560 ⇒ 00:54:59.050 Uttam Kumaran: Oh, oh.
211 00:55:40.900 ⇒ 00:55:51.360 Uttam Kumaran: message id tickets, messages row
212 00:56:04.110 ⇒ 00:56:08.910 Uttam Kumaran: so fat tickets. Needs to join to
213 00:56:42.280 ⇒ 00:56:45.589 Uttam Kumaran: raw, gorgeous messages. Macro.
214 00:56:47.210 ⇒ 00:56:49.550 Uttam Kumaran: Okay. But then what the fuck is this?
215 00:56:50.780 ⇒ 00:56:52.340 Uttam Kumaran: Back messages.
216 00:57:28.420 ⇒ 00:57:34.509 Uttam Kumaran: Oh, this is every message, every macro use of macro message is one to one. Okay,
217 00:57:43.650 ⇒ 00:57:51.360 Uttam Kumaran: The macros used as an array for every ticket so
218 00:58:13.640 ⇒ 00:58:21.390 Uttam Kumaran: left. Join to fact messages, and I want to bring in
219 00:58:25.780 ⇒ 00:58:30.720 Uttam Kumaran: array ag of the oh.
220 00:58:33.880 ⇒ 00:58:47.500 Uttam Kumaran: let’s join on, then froze, and I want to bring in. What is that? The macro, not Macro name.
221 00:58:48.950 ⇒ 00:58:53.240 Uttam Kumaran: want to bring in DM, dot Macro names.
222 00:58:56.320 ⇒ 00:59:03.599 Uttam Kumaran: streamlines, breakout of ticket fields just the same.
223 00:59:42.850 ⇒ 00:59:43.530 Uttam Kumaran: What’s anymore
224 00:59:45.970 ⇒ 00:59:52.769 Uttam Kumaran: for custom fields, I would look at it. I looked at a few rows and what it’s flattened, the nested structure
225 00:59:53.320 ⇒ 00:59:56.310 Uttam Kumaran: label and value. So you just want.
226 01:00:18.390 ⇒ 01:00:19.980 Uttam Kumaran: where’s the ticket. Feel?
227 01:00:27.800 ⇒ 01:00:29.810 Uttam Kumaran: Oh, okay, so
228 01:00:55.300 ⇒ 01:01:00.189 Robert Tseng: Refunded at the order along way. So we do need to use order line for that one
229 01:01:00.440 ⇒ 01:01:02.250 Robert Tseng: fine. It’s okay.
230 01:01:16.120 ⇒ 01:01:23.270 Robert Tseng: Alright, price.
231 01:01:25.660 ⇒ 01:01:27.660 Robert Tseng: So sales would be.
232 01:01:29.040 ⇒ 01:01:32.500 Robert Tseng: It already has everything baked, and they don’t need discount. It’s free.
233 01:01:32.970 ⇒ 01:01:35.370 Robert Tseng: It’s just price minus
234 01:01:40.590 ⇒ 01:01:42.569 Robert Tseng: the big discounted price.
235 01:01:58.270 ⇒ 01:01:59.780 Robert Tseng: Let’s do
236 01:02:05.970 ⇒ 01:02:10.070 Robert Tseng: refund amount oops
237 01:02:16.440 ⇒ 01:02:17.660 Robert Tseng: over.
238 01:02:22.830 ⇒ 01:02:23.540 Robert Tseng: Go ahead.
239 01:02:56.280 ⇒ 01:02:58.730 Robert Tseng: Think, discount.
240 01:03:06.430 ⇒ 01:03:07.180 Robert Tseng: Okay?
241 01:03:18.800 ⇒ 01:03:22.489 Robert Tseng: No, we’re not gonna do a line chart.
242 01:03:37.730 ⇒ 01:03:39.529 Robert Tseng: It’s not on the same line, though.
243 01:03:45.080 ⇒ 01:03:46.890 Robert Tseng: Pretty much our sale this time.
244 01:03:47.500 ⇒ 01:03:48.740 Robert Tseng: It makes sense.
245 01:03:50.090 ⇒ 01:03:51.069 Robert Tseng: I see.
246 01:03:53.060 ⇒ 01:03:57.899 Robert Tseng: I don’t even know why that’s helpful, but fine. We’ll do it.
247 01:03:58.430 ⇒ 01:03:59.739 Robert Tseng: Work with complaint.
248 01:04:11.230 ⇒ 01:04:13.480 Robert Tseng: refine, share sales.
249 01:05:18.930 ⇒ 01:05:25.940 Robert Tseng: Yeah, but you kind of need to put them on the same axis, because otherwise well, it’s just for trend detection, anyway. So
250 01:05:26.760 ⇒ 01:05:29.600 Robert Tseng: just keep them separate. We don’t need to conflate it.
251 01:05:37.830 ⇒ 01:05:40.420 Robert Tseng: Oh, volatile! Does that make sense?
252 01:05:42.570 ⇒ 01:05:45.070 Robert Tseng: Whoa! Whoa! Whoa! All time.
253 01:05:52.630 ⇒ 01:05:54.830 Robert Tseng: all one by one.
254 01:06:06.970 ⇒ 01:06:07.630 Robert Tseng: Yeah.
255 01:06:07.900 ⇒ 01:06:08.760 Robert Tseng: So that’s.
256 01:06:15.170 ⇒ 01:06:18.140 Uttam Kumaran: The dog sleeps with his tongue out. It’s so funny.
257 01:06:24.720 ⇒ 01:06:25.860 Uttam Kumaran: good.
258 01:11:14.980 ⇒ 01:11:20.204 Robert Tseng: yeah, just a product names you. If you want to do category, you have to go down to the
259 01:11:22.060 ⇒ 01:11:31.960 Robert Tseng: order line and then the order line. I don’t know. Are you really gonna be able to get a refund percentage? Did anybody even ask for that? Why do we even do that
260 01:11:32.650 ⇒ 01:11:34.919 Robert Tseng: scope creep. Don’t get anybody here.
261 01:11:35.160 ⇒ 01:11:37.930 Robert Tseng: Yeah, I don’t think anybody asked for it.
262 01:11:38.900 ⇒ 01:11:42.790 Robert Tseng: Okay, announcements exit perfect.
263 01:11:47.650 ⇒ 01:12:00.760 Robert Tseng: So we’ll at that one not necessary. Unnecessary and
264 01:12:01.590 ⇒ 01:12:07.050 Robert Tseng: gross profit per order by customer type, gross profit per order.
265 01:12:11.080 ⇒ 01:12:12.520 Robert Tseng: No, don’t need that.
266 01:12:14.690 ⇒ 01:12:25.870 Robert Tseng: Okay. So final review, gross margin trends and breakouts, sales, revenue price should be.
267 01:12:30.900 ⇒ 01:12:31.920 Uttam Kumaran: There’s not
268 01:12:36.830 ⇒ 01:12:38.550 Uttam Kumaran: here agent, phone.
269 01:12:44.980 ⇒ 01:12:46.917 Robert Tseng: Hey? Can I? Can I walk you through?
270 01:12:48.365 ⇒ 01:12:49.110 Uttam Kumaran: Alright!
271 01:12:49.590 ⇒ 01:12:53.069 Robert Tseng: Then, once I talk it through, I think it should be good to set
272 01:12:57.690 ⇒ 01:13:03.370 Robert Tseng: cool. So left is original, and then this new one. So
273 01:13:05.300 ⇒ 01:13:11.040 Robert Tseng: yeah, I guess top policy have. We have total monthly sales, or like a previous month.
274 01:13:11.540 ⇒ 01:13:27.360 Robert Tseng: it’ll be oh, I’m already. I’m already catching myself. There’s some global filters that need to be added. We need to have it filtered by past full months. Make sure that we’re not including any orders that got returned, or just canceled, or whatever so have to make sure to add those in.
275 01:13:27.560 ⇒ 01:13:37.510 Robert Tseng: But assuming those are right. Yeah, this gives us a sense of what the sales and profitability metrics were the past the past month.
276 01:13:38.280 ⇒ 01:13:41.360 Robert Tseng: Here’s like a breakdown of the different cost components.
277 01:13:41.963 ⇒ 01:13:44.029 Robert Tseng: So we can see that
278 01:13:44.750 ⇒ 01:13:47.400 Robert Tseng: for a total gross profit. Last
279 01:13:47.970 ⇒ 01:13:51.190 Robert Tseng: month was about 1.5 million
280 01:13:51.848 ⇒ 01:14:03.310 Robert Tseng: you know half of it. They lost to accessories that they were giving away for free, and then kind of these are the other 2 parts, mostly protein coffee and coffee. Concentrate, as we would expect.
281 01:14:05.630 ⇒ 01:14:16.070 Robert Tseng: Then, by customer type and product category. We have monthly gross profit. Gross profit for each product, category by customer type.
282 01:14:16.636 ⇒ 01:14:21.489 Robert Tseng: Still kind of blank on the returning. I might just hide this for now.
283 01:14:23.360 ⇒ 01:14:25.689 Robert Tseng: If we haven’t been able to figure out the Amazon piece.
284 01:14:26.430 ⇒ 01:14:29.420 Uttam Kumaran: Well, it should be there. Yeah. But oh.
285 01:14:30.231 ⇒ 01:14:32.889 Uttam Kumaran: yeah, it should. It’ll flow in. I’ll just make sure it’s there.
286 01:14:32.890 ⇒ 01:14:34.969 Robert Tseng: Okay, maybe I just have to refresh it all good
287 01:14:35.724 ⇒ 01:14:40.265 Robert Tseng: and then same thing with monthly gross margin side.
288 01:14:42.740 ⇒ 01:14:45.460 Robert Tseng: basically. How I would read. This is.
289 01:14:46.880 ⇒ 01:14:53.790 Robert Tseng: they lose a lot of money on accessories. They make a lot of money on coffee bundles and other whatever falls into other.
290 01:14:59.670 ⇒ 01:15:05.060 Robert Tseng: yeah, somehow, syrup web is becoming more profitable.
291 01:15:05.671 ⇒ 01:15:15.969 Robert Tseng: Seems like to be the most recent kind of trend. But this is great, like, I feel like, now that I have this kind of view. I can actually go and do wd weekly business reviews with them.
292 01:15:16.170 ⇒ 01:15:21.520 Robert Tseng: and we can start to dig into like, what are what’s driving some of these changes and what not.
293 01:15:23.066 ⇒ 01:15:26.469 Robert Tseng: I think it’s interesting that new customer
294 01:15:27.060 ⇒ 01:15:36.730 Robert Tseng: margin is way lower than returning, but I suppose that would make sense. Because
295 01:15:37.700 ⇒ 01:15:39.520 Robert Tseng: I guess, why would that make sense?
296 01:15:41.250 ⇒ 01:15:48.020 Robert Tseng: Why would returning customers be so much more profitable if the cost components are just
297 01:15:48.200 ⇒ 01:15:51.859 Robert Tseng: product cost shipping box, pick platform fees.
298 01:15:54.520 ⇒ 01:15:55.210 Robert Tseng: Hmm.
299 01:15:56.350 ⇒ 01:15:57.650 Uttam Kumaran: Where is that?
300 01:15:59.160 ⇒ 01:16:00.980 Robert Tseng: I’m just thinking, like looking at.
301 01:16:01.520 ⇒ 01:16:08.449 Robert Tseng: Yeah, like gross margin between new and returning customers. Why would there be such a big discrepancy?
302 01:16:12.210 ⇒ 01:16:18.570 Robert Tseng: like it looks like gross margin for returning customers is like 46% past month versus 14%.
303 01:16:21.810 ⇒ 01:16:23.649 Uttam Kumaran: Is it the same across all months.
304 01:16:25.000 ⇒ 01:16:29.880 Robert Tseng: Yeah, well, actually, maybe this is just saying it’s.
305 01:16:32.560 ⇒ 01:16:34.460 Uttam Kumaran: Well, looks like other.
306 01:16:35.230 ⇒ 01:16:41.039 Robert Tseng: Yeah, yeah, it’s it’s like, total. Yeah, this, this is this, these totals are misleading, I think.
307 01:16:42.030 ⇒ 01:16:44.280 Robert Tseng: because I think 14 plus 46 plus 46
308 01:16:45.310 ⇒ 01:16:48.280 Robert Tseng: probably adds up, wait, that does it. That doesn’t.
309 01:16:49.640 ⇒ 01:16:52.250 Robert Tseng: Well, yeah, I don’t understand how I read this.
310 01:16:56.330 ⇒ 01:17:04.880 Robert Tseng: I I was just I thought that maybe it’s just like how, how it’s weighted into profitability overall.
311 01:17:05.280 ⇒ 01:17:09.210 Robert Tseng: But no. And I think it’s it is just suggesting that
312 01:17:12.450 ⇒ 01:17:17.020 Robert Tseng: I okay, I see, because new customers we send them a lot more free shit.
313 01:17:17.600 ⇒ 01:17:18.690 Uttam Kumaran: Oh!
314 01:17:19.260 ⇒ 01:17:19.890 Robert Tseng: Yeah.
315 01:17:21.770 ⇒ 01:17:22.570 Uttam Kumaran: So it’s like that.
316 01:17:22.570 ⇒ 01:17:23.650 Uttam Kumaran: I’m okay.
317 01:17:23.980 ⇒ 01:17:27.160 Robert Tseng: Yeah, so this is like, 1st time margin.
318 01:17:28.040 ⇒ 01:17:30.690 Robert Tseng: And then we send them less
319 01:17:30.830 ⇒ 01:17:36.660 Robert Tseng: free stuff later on. And then, like, I guess that helps us helps helps with the margin.
320 01:17:37.620 ⇒ 01:17:39.479 Robert Tseng: Okay, that makes sense to me.
321 01:17:41.616 ⇒ 01:17:48.960 Robert Tseng: By flavor interesting that certain flavors have more a bigger margin than others.
322 01:17:52.330 ⇒ 01:17:53.230 Robert Tseng: Like.
323 01:17:57.590 ⇒ 01:18:00.989 Robert Tseng: I mean, everything is arranged alphabetically right now. Maybe I should.
324 01:18:01.150 ⇒ 01:18:08.069 Robert Tseng: I don’t know. Maybe it’s still readable, but like no flavor has low margin.
325 01:18:08.570 ⇒ 01:18:09.860 Robert Tseng: That’s interesting.
326 01:18:11.460 ⇒ 01:18:12.369 Robert Tseng: I went in the office.
327 01:18:12.370 ⇒ 01:18:13.250 Uttam Kumaran: Flavors.
328 01:18:15.100 ⇒ 01:18:22.739 Robert Tseng: Yeah. Coffee with no flavor, I guess, is they don’t really get like the margin is like 0. I don’t know what’s up with that
329 01:18:23.540 ⇒ 01:18:30.339 Robert Tseng: unless it’s just that like, oh, it’s a product that isn’t really a coffee flavor that doesn’t.
330 01:18:31.030 ⇒ 01:18:34.059 Uttam Kumaran: Correct. So the way the macro works.
331 01:18:34.420 ⇒ 01:18:43.749 Uttam Kumaran: And I’m like literally looking at it right now is, yeah. Anything that isn’t flavored gets put into no flavor. So that’ll be a catch. All. So you need to, you need to do. But this by
332 01:18:43.880 ⇒ 01:18:46.509 Uttam Kumaran: product category and by, yeah.
333 01:18:46.910 ⇒ 01:18:48.230 Robert Tseng: I should hide it. Yeah.
334 01:18:48.620 ⇒ 01:18:55.270 Uttam Kumaran: Or you can just filter to the certain product categories where everything’s a flavor like concentrate or something.
335 01:18:55.760 ⇒ 01:18:56.799 Robert Tseng: Oh, I see!
336 01:18:57.700 ⇒ 01:18:59.979 Uttam Kumaran: Or you or you could hide it. Yeah.
337 01:19:00.510 ⇒ 01:19:02.490 Uttam Kumaran: you know, it’s 1 or the other
338 01:19:03.890 ⇒ 01:19:09.669 Uttam Kumaran: ideal, like ideally, they would want to look at by category and by flavor, you know.
339 01:19:10.400 ⇒ 01:19:11.264 Uttam Kumaran: So
340 01:19:12.740 ⇒ 01:19:13.430 Robert Tseng: Yeah.
341 01:19:13.830 ⇒ 01:19:15.790 Robert Tseng: But so that’s that’s why I have it.
342 01:19:16.390 ⇒ 01:19:19.650 Robert Tseng: I have by category. And then I have by flavor.
343 01:19:24.890 ⇒ 01:19:34.779 Robert Tseng: But yeah, I just I didn’t do the whole new versus returning thing. Maybe I should. Okay, I’ll just add that. Okay, I can make that change. And then high flavor here. I want them to get
344 01:19:35.660 ⇒ 01:19:39.630 Robert Tseng: distracted by that. Yeah. So gross profit.
345 01:19:40.110 ⇒ 01:19:46.249 Robert Tseng: Amazon. Shopify Tiktok. Gross margin, new returning empty. The empty. You said, it’s gonna be fixed.
346 01:19:46.600 ⇒ 01:19:50.209 Robert Tseng: Yeah, subscription type is the one that’s kind of weird
347 01:19:51.130 ⇒ 01:19:56.349 Robert Tseng: back order line. There’s no sub. I don’t know. There’s a few subscription fields here.
348 01:19:57.332 ⇒ 01:20:03.179 Robert Tseng: I just use is subscription order, and it seems like a lot of them are just not labeled with that.
349 01:20:05.450 ⇒ 01:20:07.370 Uttam Kumaran: Fact, order, line.
350 01:20:11.030 ⇒ 01:20:13.619 Robert Tseng: Yeah, it looks like 60%.
351 01:20:14.010 ⇒ 01:20:18.210 Uttam Kumaran: Well, none of the none of the Amazon ones are gonna be under subscription.
352 01:20:19.905 ⇒ 01:20:20.460 Robert Tseng: Okay.
353 01:20:21.940 ⇒ 01:20:26.829 Robert Tseng: So I mean, I can just call them well, they’re just not subscription. So.
354 01:20:28.920 ⇒ 01:20:32.549 Uttam Kumaran: I I mean, I’m I’m gonna when I bring in subscribe and save.
355 01:20:33.260 ⇒ 01:20:40.420 Uttam Kumaran: I will try to. I will. I’m basically going in and making the like fixing the Amazon stuff. So like, I added, returning.
356 01:20:40.770 ⇒ 01:20:46.109 Uttam Kumaran: that got fixed everywhere in Amazon. Now, anything that touches Amazon has that, and then
357 01:20:46.510 ⇒ 01:20:54.629 Uttam Kumaran: subscribe and save. Yeah, I the problem I’m seeing with the subscribe and save right now is I’m getting it as like a
358 01:20:58.050 ⇒ 01:21:05.500 Uttam Kumaran: not on the product level. I’m getting like a summary table, so I’m not.
359 01:21:05.500 ⇒ 01:21:06.320 Robert Tseng: I see.
360 01:21:07.040 ⇒ 01:21:09.339 Uttam Kumaran: Like, I’m getting at the skew level.
361 01:21:10.010 ⇒ 01:21:13.509 Uttam Kumaran: I’m not 100% sure if I can get it at like.
362 01:21:19.320 ⇒ 01:21:26.470 Uttam Kumaran: Well, yeah, I don’t know if I can get at this individual level.
363 01:21:26.470 ⇒ 01:21:31.689 Robert Tseng: It doesn’t have to be at or individual like order at at. Can we get at the order level.
364 01:21:32.570 ⇒ 01:21:36.820 Uttam Kumaran: No, they didn’t give it to us, so they ordered. They gave it to me at the product, and
365 01:21:39.070 ⇒ 01:21:44.619 Uttam Kumaran: like I don’t know what I asin is marketplace id skew.
366 01:21:44.940 ⇒ 01:21:45.600 Robert Tseng: Hmm.
367 01:21:46.820 ⇒ 01:21:50.879 Uttam Kumaran: And then they just give me like a bunch of units. I mean, I I can.
368 01:21:51.400 ⇒ 01:21:55.110 Uttam Kumaran: I looked through to. I looked through a bunch of tables. I couldn’t really see it.
369 01:21:55.410 ⇒ 01:21:56.110 Robert Tseng: That’s fine!
370 01:21:58.450 ⇒ 01:22:01.910 Uttam Kumaran: I do have the totals by product.
371 01:22:04.250 ⇒ 01:22:05.180 Robert Tseng: Okay.
372 01:22:06.610 ⇒ 01:22:12.480 Uttam Kumaran: Like, I can tell you, for a given skew and a given week.
373 01:22:13.440 ⇒ 01:22:20.119 Uttam Kumaran: I could tell you how, for every product, yeah, for every product, how much, how much was shipped?
374 01:22:21.180 ⇒ 01:22:22.360 Uttam Kumaran: And
375 01:22:25.540 ⇒ 01:22:35.830 Uttam Kumaran: yeah, well, it’s kind of weird. The table they gave me is like week, one week, 2 week, 3. 0, it’s for like the products bought in a given week on subscribe and save
376 01:22:36.250 ⇒ 01:22:41.289 Uttam Kumaran: it. Basically like, it’s the churn rate. It’s like.
377 01:22:43.050 ⇒ 01:22:47.199 Uttam Kumaran: it’s like what happened in week? One. What happened? Week? 2. What happened in week? 3.
378 01:22:47.560 ⇒ 01:22:48.380 Robert Tseng: I see.
379 01:22:48.980 ⇒ 01:22:50.399 Uttam Kumaran: So by week. 4.
380 01:22:51.650 ⇒ 01:22:53.700 Uttam Kumaran: Yeah, a lot of these are lower.
381 01:23:00.060 ⇒ 01:23:02.869 Uttam Kumaran: That’s not. That’s not super helpful for you.
382 01:23:03.940 ⇒ 01:23:06.775 Robert Tseng: And that’s helpful for a different use. Case.
383 01:23:08.270 ⇒ 01:23:10.899 Robert Tseng: yeah, probably on the Amazon dash. Specifically.
384 01:23:12.160 ⇒ 01:23:12.930 Uttam Kumaran: Yeah.
385 01:23:13.240 ⇒ 01:23:15.920 Robert Tseng: Yeah, but for their gross margin, which is fine.
386 01:23:16.140 ⇒ 01:23:20.400 Robert Tseng: But okay, I think what I’ll do here is a lot of this is false or empty.
387 01:23:23.910 ⇒ 01:23:31.400 Robert Tseng: I don’t know why it would not be true, like, I haven’t seen anything that’s actually his subscription order.
388 01:23:33.720 ⇒ 01:23:35.320 Robert Tseng: Okay? Is this the right way to do it?
389 01:23:37.640 ⇒ 01:23:39.829 Uttam Kumaran: You should see the shopify ones.
390 01:23:41.430 ⇒ 01:23:44.750 Robert Tseng: Yeah, I would expect there to be some that are true here.
391 01:23:46.260 ⇒ 01:23:50.360 Robert Tseng: but I am at the order line level. So
392 01:23:56.040 ⇒ 01:23:57.075 Robert Tseng: so
393 01:24:07.910 ⇒ 01:24:15.070 Uttam Kumaran: I’m in shopify order. I’m pulling the subscription recurring order and is.
394 01:24:17.120 ⇒ 01:24:22.019 Uttam Kumaran: basically it’s like, if Sro and Sro.
395 01:24:22.660 ⇒ 01:24:26.349 Uttam Kumaran: it’s a tag. Yeah. So there’s there’s multiple tags.
396 01:24:26.510 ⇒ 01:24:28.750 Uttam Kumaran: So we’re basically bringing in.
397 01:24:29.040 ⇒ 01:24:38.139 Uttam Kumaran: We’re bringing in the the orders and tagging them a subscription recurring order and subscription or subscription. 1st order based on shopify order tags.
398 01:24:41.580 ⇒ 01:24:46.400 Robert Tseng: Okay, let me look at just shopify.
399 01:24:48.850 ⇒ 01:24:56.340 Robert Tseng: So, yeah, like, nothing is true. Everything is false.
400 01:25:01.120 ⇒ 01:25:02.279 Uttam Kumaran: We’ll look at.
401 01:25:03.280 ⇒ 01:25:06.330 Uttam Kumaran: Let me take a look at the table, shopify tags.
402 01:25:23.190 ⇒ 01:25:27.570 Robert Tseng: Which is fine, because I think the proxy I can use.
403 01:25:27.740 ⇒ 01:25:34.260 Robert Tseng: It’s just customer type, right? It does new and returning. Would that be a proxy for subscription type, like.
404 01:25:36.100 ⇒ 01:25:37.009 Robert Tseng: Wouldn’t I expect to see.
405 01:25:37.010 ⇒ 01:25:41.990 Uttam Kumaran: Not really because you have one time orders that people can order multiple one time.
406 01:25:44.250 ⇒ 01:25:50.700 Robert Tseng: I see. So it’s it’s really just like it’s like order type. It’s customer type versus order type.
407 01:25:51.310 ⇒ 01:25:52.110 Uttam Kumaran: Yeah.
408 01:25:52.110 ⇒ 01:25:52.710 Robert Tseng: Yeah.
409 01:26:00.440 ⇒ 01:26:10.159 Robert Tseng: yeah. And it’s like, every, do we have order type in the back order table? Probably do.
410 01:26:10.640 ⇒ 01:26:11.410 Uttam Kumaran: Yes.
411 01:26:14.270 ⇒ 01:26:19.459 Robert Tseng: Well, yeah, if we get that at the fact that I could just join it to the fact order line and then just pull in
412 01:26:20.715 ⇒ 01:26:21.420 Robert Tseng: ordered.
413 01:26:21.798 ⇒ 01:26:25.509 Uttam Kumaran: Like you. Oh, yeah, yeah, I guess
414 01:26:27.470 ⇒ 01:26:31.070 Uttam Kumaran: you could join to fact, you could join a fact orders, and probably just do that.
415 01:26:31.480 ⇒ 01:26:35.390 Robert Tseng: Yeah, okay, that’s fine. We’ll just do that.
416 01:26:39.250 ⇒ 01:26:40.130 Robert Tseng: Okay?
417 01:26:40.610 ⇒ 01:26:47.198 Robert Tseng: Then, just walking through the rest. Last part, yeah. Then we have cogs, monthly cogs, breakout
418 01:26:49.370 ⇒ 01:26:57.049 Robert Tseng: my product category. I do it quarterly here just because I don’t know. Like I was just being creative. I could do monthly. So
419 01:26:57.320 ⇒ 01:27:00.510 Robert Tseng: quarter I’ll put down by flavor
420 01:27:00.810 ⇒ 01:27:03.940 Robert Tseng: waiver. And then a couple of refund impact stuff.
421 01:27:04.450 ⇒ 01:27:09.800 Robert Tseng: Yeah, so that’s pretty much it. I think that’s what I want to ship them tonight or yeah. Today.
422 01:27:16.480 ⇒ 01:27:22.119 Robert Tseng: I literally didn’t reuse anything from the old dashboard. I literally had to build everything again.
423 01:27:50.940 ⇒ 01:27:54.069 Robert Tseng: Work getting it done in an hour.
424 01:27:55.340 ⇒ 01:28:00.450 Robert Tseng: It’s okay, almost there. It’s just this final touches, products.
425 01:28:12.010 ⇒ 01:28:17.059 Uttam Kumaran: So this is saying, if shopify tags are in, if the
426 01:28:17.400 ⇒ 01:28:21.960 Uttam Kumaran: but the Sro tag is not the fucking actual tag
427 01:28:25.740 ⇒ 01:28:28.710 Uttam Kumaran: shopify tags is Sro, right?
428 01:28:31.170 ⇒ 01:28:31.910 Uttam Kumaran: Come on.
429 01:28:32.160 ⇒ 01:28:36.800 Uttam Kumaran: So if the Sro tag there’s no way, because the tags are this.
430 01:28:38.190 ⇒ 01:28:41.569 Uttam Kumaran: So I need to break this up again.
431 01:28:41.690 ⇒ 01:28:44.449 Uttam Kumaran: Why are we doing a list act of this
432 01:28:54.710 ⇒ 01:29:01.350 Uttam Kumaran: when you’re trying to say if an order like, why would you do? Why would you do this? Who the fuck wrote this.
433 01:29:38.890 ⇒ 01:29:39.659 Uttam Kumaran: where’s the tab?
434 01:29:40.200 ⇒ 01:29:43.870 Uttam Kumaran: Where is this used? Otherwise it’s not even used anywhere.
435 01:29:44.890 ⇒ 01:29:49.819 Uttam Kumaran: Ditch this don’t need to aggregate it
436 01:30:01.520 ⇒ 01:30:02.380 Uttam Kumaran: here.
437 01:30:33.190 ⇒ 01:30:40.750 Uttam Kumaran: I’m pretty sure the tags logic was all busted. So I’m gonna push a fix for this.
438 01:30:41.210 ⇒ 01:30:41.930 Robert Tseng: Okay.
439 01:30:48.250 ⇒ 01:30:49.910 Robert Tseng: good. What is going on?
440 01:33:06.550 ⇒ 01:33:07.460 Robert Tseng: The same?
441 01:34:16.850 ⇒ 01:34:18.199 Robert Tseng: Yeah. That makes sense.
442 01:34:42.200 ⇒ 01:34:43.660 Robert Tseng: What? The heck?
443 01:34:44.960 ⇒ 01:34:47.760 Robert Tseng: Why wouldn’t she lovely?
444 01:34:50.290 ⇒ 01:34:50.950 Robert Tseng: Oh.
445 01:34:53.420 ⇒ 01:34:54.540 Uttam Kumaran: Whiteboard.
446 01:34:57.060 ⇒ 01:34:58.050 Uttam Kumaran: There you go!
447 01:35:04.072 ⇒ 01:35:08.799 Robert Tseng: Wanna read it. Yes, this is correct. It’s pretty consistent.
448 01:35:09.540 ⇒ 01:35:10.370 Robert Tseng: There you go.
449 01:35:21.590 ⇒ 01:35:25.470 Uttam Kumaran: Which was the one you were looking at. Is subscription recurring order.
450 01:35:26.100 ⇒ 01:35:26.930 Robert Tseng: Yeah.
451 01:35:27.300 ⇒ 01:35:28.860 Uttam Kumaran: Okay, yeah, I fixed it alright.
452 01:35:30.390 ⇒ 01:35:32.230 Robert Tseng: Or is subscription order?
453 01:35:33.870 ⇒ 01:35:39.860 Robert Tseng: There’s 3. There’s subscription. 1st order sub is subscription order, and is subscription recurring? Order.
454 01:35:40.270 ⇒ 01:35:45.870 Uttam Kumaran: Okay, yeah, I see, like I see true, false. And all those now.
455 01:35:47.200 ⇒ 01:35:49.450 Robert Tseng: So use the subscription. Recurring order.
456 01:35:50.445 ⇒ 01:35:55.780 Uttam Kumaran: Yes, I will. I just have to push this Pr, and then it’ll work. Yeah.
457 01:35:55.780 ⇒ 01:35:57.460 Robert Tseng: Okay, no worries.
458 01:36:13.660 ⇒ 01:36:16.130 Robert Tseng: I guess, when you push it and let me know. Refresh.
459 01:36:16.310 ⇒ 01:36:16.985 Uttam Kumaran: Okay.
460 01:36:21.230 ⇒ 01:36:23.810 Robert Tseng: Oh, last piece is pretty fun.
461 01:37:09.710 ⇒ 01:37:13.850 Uttam Kumaran: So how can this be? Subscription? How can it be both?
462 01:37:16.980 ⇒ 01:37:19.709 Uttam Kumaran: And subscription 1st order.
463 01:37:26.600 ⇒ 01:37:29.196 Robert Tseng: What’s this else is?
464 01:37:35.020 ⇒ 01:37:36.180 Robert Tseng: after
465 01:37:39.180 ⇒ 01:37:41.020 Robert Tseng: revenue after?
466 01:37:42.100 ⇒ 01:37:42.980 Robert Tseng: Alright.
467 01:37:48.530 ⇒ 01:37:50.669 Robert Tseng: yeah, I mean, it is half for tax
468 01:37:58.390 ⇒ 01:38:03.170 Robert Tseng: discount and packs, including.
469 01:38:28.570 ⇒ 01:38:31.110 Uttam Kumaran: Who’s here?
470 01:38:38.860 ⇒ 01:38:39.820 Robert Tseng: Beautiful
471 01:41:14.310 ⇒ 01:41:15.410 Robert Tseng: oh, man!
472 01:44:44.070 ⇒ 01:44:44.750 Uttam Kumaran: One.
473 01:48:16.890 ⇒ 01:48:17.620 Robert Tseng: Hmm!
474 01:48:22.400 ⇒ 01:48:23.500 Robert Tseng: Hey! There!
475 01:48:23.500 ⇒ 01:48:24.270 Uttam Kumaran: Yep.
476 01:48:26.730 ⇒ 01:48:31.558 Robert Tseng: I’m trying to. I’ve been adding the global filters to the gross margin, dash and
477 01:48:32.250 ⇒ 01:48:36.839 Robert Tseng: there isn’t really a field called order status, but we have, like a fulfillment status
478 01:48:37.260 ⇒ 01:48:44.870 Robert Tseng: fulfilled as only shopify and Tiktok partial and restock. I’m assuming Afn and Mfn. These are Amazon ones.
479 01:48:44.870 ⇒ 01:48:45.440 Uttam Kumaran: Yes.
480 01:48:45.832 ⇒ 01:48:50.149 Robert Tseng: When I when I click that, then everything kind of breaks.
481 01:48:51.080 ⇒ 01:48:55.540 Robert Tseng: I wonder if that’s because
482 01:49:01.770 ⇒ 01:49:08.530 Robert Tseng: well, I guess I could. I could figure that out if I go here and I go to
483 01:49:09.320 ⇒ 01:49:15.390 Robert Tseng: fulfillment. Status is yeah.
484 01:49:16.080 ⇒ 01:49:20.580 Robert Tseng: at the order line level, it’s fulfilled, partial restocked.
485 01:49:21.030 ⇒ 01:49:30.079 Robert Tseng: But then, if we do it. In fact, orders we have fill mint question mark.
486 01:49:34.140 ⇒ 01:49:35.060 Robert Tseng: I see.
487 01:49:36.280 ⇒ 01:49:42.809 Robert Tseng: So yeah, that makes sense. We can’t get order. Does that? Does that mean we don’t get order line for Amazon orders.
488 01:49:44.623 ⇒ 01:49:45.650 Uttam Kumaran: We do.
489 01:49:48.920 ⇒ 01:49:52.859 Robert Tseng: Hmm, I guess.
490 01:49:54.540 ⇒ 01:49:59.829 Robert Tseng: Yeah, I guess I’m not sure why fulfillment statuses would be different across
491 01:50:00.080 ⇒ 01:50:02.420 Robert Tseng: back orders and back order aligned. Then.
492 01:50:07.420 ⇒ 01:50:09.150 Uttam Kumaran: Oh, I can check.
493 01:50:10.050 ⇒ 01:50:11.749 Robert Tseng: You see, you see what I’m saying, though.
494 01:50:11.750 ⇒ 01:50:15.960 Uttam Kumaran: Yeah, that shouldn’t be different unless each line. Yeah.
495 01:50:17.510 ⇒ 01:50:20.889 Uttam Kumaran: I guess. Let me look at fact. Let me look at Amazon order line.
496 01:53:06.080 ⇒ 01:53:10.260 Robert Tseng: Sales is.
497 02:03:04.510 ⇒ 02:03:08.450 Robert Tseng: did Amazon data just like stop coming in after February 7.th
498 02:03:09.050 ⇒ 02:03:11.020 Uttam Kumaran: It’s like sinking right now.
499 02:03:11.230 ⇒ 02:03:12.090 Robert Tseng: Oh, I see!
500 02:03:12.670 ⇒ 02:03:14.019 Uttam Kumaran: Yeah, it’s like I.
501 02:03:14.850 ⇒ 02:03:17.419 Uttam Kumaran: I turn it on like once every few weeks.
502 02:03:17.700 ⇒ 02:03:19.580 Robert Tseng: Yeah, yeah, that’s
503 02:05:43.120 ⇒ 02:05:43.990 Robert Tseng: cool.
504 02:14:10.570 ⇒ 02:14:11.290 Uttam Kumaran: Ben.
505 02:14:22.510 ⇒ 02:14:25.130 Uttam Kumaran: hey, yeah.
506 02:17:29.790 ⇒ 02:17:30.459 Robert Tseng: That’s good.
507 02:17:31.830 ⇒ 02:17:33.120 Robert Tseng: Really. The redo.
508 02:17:39.299 ⇒ 02:17:41.420 Robert Tseng: Okay, almost done. Almost done.
509 02:18:05.379 ⇒ 02:18:09.610 Robert Tseng: They even add it here, isn’t it?
510 02:18:10.139 ⇒ 02:18:11.150 Robert Tseng: Comments
511 02:18:14.680 ⇒ 02:18:15.559 Robert Tseng: the heck.
512 02:18:16.070 ⇒ 02:18:17.829 Robert Tseng: Oh, it’s just pre tax price
513 02:18:20.830 ⇒ 02:18:26.209 Robert Tseng: or no. It’s just it’s just price straight up. Price
514 02:20:28.750 ⇒ 02:20:29.710 Robert Tseng: very cool.
515 02:20:34.430 ⇒ 02:20:38.019 Robert Tseng: I’ll be buying a few minutes, probably by 8.
516 02:20:39.070 ⇒ 02:20:40.030 Robert Tseng: Hopefully.
517 02:20:40.460 ⇒ 02:20:43.590 Robert Tseng: Actually, I have to stop by 8. Otherwise, I’m gonna burn out.
518 02:20:44.000 ⇒ 02:20:45.370 Robert Tseng: And it’s only Monday.
519 02:22:43.440 ⇒ 02:22:45.889 Robert Tseng: this screen, okay, it will be.
520 02:22:49.080 ⇒ 02:22:49.750 Robert Tseng: you know.
521 02:24:38.800 ⇒ 02:24:41.240 Uttam Kumaran: Yes, okay, cool. Alright.
522 02:24:41.620 ⇒ 02:24:43.209 Uttam Kumaran: I’m about to be done.
523 02:24:43.770 ⇒ 02:24:44.530 Robert Tseng: Yeah.
524 02:24:46.490 ⇒ 02:24:48.409 Uttam Kumaran: Whole bunch of fixes.
525 02:24:49.240 ⇒ 02:24:49.960 Uttam Kumaran: Okay, cool.
526 02:24:49.960 ⇒ 02:24:51.120 Robert Tseng: Let’s go.
527 02:24:51.620 ⇒ 02:24:52.910 Uttam Kumaran: So gorgeous.
528 02:24:53.120 ⇒ 02:24:57.999 Uttam Kumaran: All the gorgeous modeling that Pius needs to get done is ready.
529 02:24:58.930 ⇒ 02:25:09.449 Uttam Kumaran: I fix couple of random things here and there, and yeah, fixed. Let’s see, for
530 02:25:11.380 ⇒ 02:25:15.352 Uttam Kumaran: yeah, the tags are, the tag will be working now.
531 02:25:17.950 ⇒ 02:25:21.330 Uttam Kumaran: yeah. And a bunch of fixes for tickets, basically.
532 02:25:22.700 ⇒ 02:25:26.355 Uttam Kumaran: And then as soon as this all runs in production, I’ll I’ll
533 02:25:27.050 ⇒ 02:25:29.169 Uttam Kumaran: just make sure it shows up in the database.
534 02:25:30.190 ⇒ 02:25:30.870 Robert Tseng: Great.
535 02:25:39.260 ⇒ 02:25:42.290 Uttam Kumaran: Wonderful. I didn’t get to anything I wanted to do today.
536 02:25:42.880 ⇒ 02:25:44.810 Robert Tseng: Dude. Yeah.
537 02:25:45.810 ⇒ 02:25:48.330 Robert Tseng: How much for the renewals?
538 02:25:48.950 ⇒ 02:25:50.040 Uttam Kumaran: I know.
539 02:25:50.850 ⇒ 02:26:00.810 Robert Tseng: Okay, th, this is like our one week of trying for Dobby just to see if we can renew them. You know we just totally deserve to lose them. And you know.
540 02:26:00.980 ⇒ 02:26:04.289 Robert Tseng: do what we can just say we tried. But yeah.
541 02:26:04.400 ⇒ 02:26:06.049 Robert Tseng: I think that’s the way I see it.
542 02:26:06.800 ⇒ 02:26:07.969 Uttam Kumaran: I’m with you.
543 02:26:09.480 ⇒ 02:26:17.400 Uttam Kumaran: I’m with you, I mean, like, honestly, if if pies can get out the stuff from gorgeous, then
544 02:26:17.970 ⇒ 02:26:22.289 Uttam Kumaran: that’s basically the last thing I need from him, and he doesn’t have to take on any new work for them.
545 02:26:22.730 ⇒ 02:26:28.049 Uttam Kumaran: cause I’m gonna take on the address matching stuff. I don’t want him. I’m not gonna spend money on like
546 02:26:28.570 ⇒ 02:26:33.370 Uttam Kumaran: I haven’t even looked at like, I mean, I’m gonna look at it. I haven’t even looked at any of what that is, but
547 02:26:34.410 ⇒ 02:26:40.110 Uttam Kumaran: I just don’t see how how we can spend another like 100 h on like
548 02:26:42.120 ⇒ 02:26:50.929 Uttam Kumaran: couple of lines of python. I mean the the data. Science is good, but, like, I don’t want to do any. I don’t want to do any more work on that stuff.
549 02:26:51.460 ⇒ 02:26:52.040 Robert Tseng: Yeah.
550 02:26:53.040 ⇒ 02:26:58.620 Uttam Kumaran: So then at that point it’ll where where it will be reduced to. Pius will be off. Jacob will be off
551 02:26:58.960 ⇒ 02:27:00.269 Uttam Kumaran: then. It’s just.
552 02:27:01.490 ⇒ 02:27:04.519 Uttam Kumaran: It’s just that the new Aes and then
553 02:27:05.770 ⇒ 02:27:09.999 Uttam Kumaran: the the dashboarding, I mean, I may ask the haunted to take it.
554 02:27:10.420 ⇒ 02:27:14.260 Uttam Kumaran: I don’t know. It’s another risk, so we’ll see.
555 02:27:17.000 ⇒ 02:27:17.740 Robert Tseng: Wow!
556 02:27:19.590 ⇒ 02:27:27.599 Uttam Kumaran: But I wanna get I will. I just wanna move pious off of all this. It’s just so. It’s just too unreliable, like we’ll set, it’ll set up.
557 02:27:28.230 ⇒ 02:27:32.970 Uttam Kumaran: It’ll set Stephen up poorly.
558 02:27:33.840 ⇒ 02:27:34.490 Robert Tseng: Yeah.
559 02:27:39.190 ⇒ 02:27:42.820 Uttam Kumaran: Oh, dude! We didn’t work on the shit for urban stems.
560 02:27:44.140 ⇒ 02:27:44.770 Robert Tseng: Yeah.
561 02:27:51.810 ⇒ 02:27:57.819 Robert Tseng: yeah, we we have early in the week. We we have some margin here. We can. We can catch up tomorrow.
562 02:27:59.800 ⇒ 02:28:00.420 Uttam Kumaran: Yeah.
563 02:28:00.720 ⇒ 02:28:05.160 Robert Tseng: Yeah, this is my one day of doing joby stuff. And I’m not doing anymore.
564 02:28:05.740 ⇒ 02:28:08.809 Robert Tseng: I basically just rebuilt both dashboards. So.
565 02:28:11.490 ⇒ 02:28:19.060 Uttam Kumaran: Yeah, I think, I think on the analyst side, yeah, we’re kind of in a bind. I really like, I want
566 02:28:19.230 ⇒ 02:28:24.350 Uttam Kumaran: us. I want to go get someone that’s like, actually can like.
567 02:28:25.400 ⇒ 02:28:31.430 Uttam Kumaran: understand of the business. And then, like, build dashboards, I
568 02:28:32.990 ⇒ 02:28:39.699 Uttam Kumaran: I don’t want to bring on anyone else that’s like Super Junior onto that sort of stuff. But I can’t be. I don’t. I don’t wanna like
569 02:28:40.160 ⇒ 02:28:43.750 Uttam Kumaran: spend money on that right now. So is what it is.
570 02:28:44.300 ⇒ 02:28:45.010 Robert Tseng: Yeah.
571 02:28:48.650 ⇒ 02:28:54.970 Robert Tseng: I don’t. I just I don’t believe that dashboarding should be your main thing. I feel like it’s just like a.
572 02:28:55.390 ⇒ 02:29:00.000 Uttam Kumaran: I don’t agree. Yeah, me neither. I always did it as part of my other. My job.
573 02:29:00.000 ⇒ 02:29:06.869 Robert Tseng: Yeah, I just like, don’t understand how people can’t do it like it was. It’s never like the main thing. But you you just have to do it like.
574 02:29:07.060 ⇒ 02:29:17.640 Robert Tseng: If you’re good, you’ll just finish it quick, and then you’ll start like using it to, you know, mon, you’ll monitor it week to week and find, discover your own projects like I don’t know. Let’s.
575 02:29:19.860 ⇒ 02:29:24.609 Robert Tseng: but I guess I guess that’s just not how people see it.
576 02:29:26.450 ⇒ 02:29:31.229 Uttam Kumaran: Yeah, I don’t know in my world. I feel like the Aes should also build the dashboards.
577 02:29:33.060 ⇒ 02:29:37.849 Robert Tseng: Yeah, I mean David. Laude said he could. He would. He was used to like
578 02:29:38.260 ⇒ 02:29:43.790 Robert Tseng: doing at least mock ups and and stuff so.
579 02:29:44.350 ⇒ 02:29:47.680 Uttam Kumaran: Yeah. So I’m gonna keep pushing on that. I mean.
580 02:29:48.700 ⇒ 02:29:53.969 Uttam Kumaran: I’m hoping that all the Aes can, just because they have the best understanding of the nuances.
581 02:29:56.120 ⇒ 02:29:56.770 Robert Tseng: Yeah.
582 02:29:59.140 ⇒ 02:30:13.480 Robert Tseng: dashboarding work scales. Well, like the more we do it, we have templates, we can put other people to use it. People are just used to doing copy paste and like not really thinking through it. So I just
583 02:30:13.580 ⇒ 02:30:16.620 Robert Tseng: yeah, I don’t know. I think that’s that’s the problem.
584 02:30:17.130 ⇒ 02:30:20.640 Robert Tseng: But also like how it will become easier in the future.
585 02:30:24.410 ⇒ 02:30:30.190 Uttam Kumaran: Yeah, I just like, I don’t know. I I feel like, on one hand, I’m like, it’s
586 02:30:30.480 ⇒ 02:30:33.459 Uttam Kumaran: yeah. Well, if we talk about that, then.
587 02:30:33.940 ⇒ 02:30:35.650 Uttam Kumaran: Yeah, I’m not like.
588 02:30:39.010 ⇒ 02:30:43.599 Uttam Kumaran: I don’t know. It’s unclear to me. If, like, Beau will be able to handle something like this.
589 02:30:45.510 ⇒ 02:30:47.979 Robert Tseng: Yeah, I don’t. I don’t think I don’t think he can.
590 02:30:49.710 ⇒ 02:30:53.570 Robert Tseng: I’m still waiting on his Eden style. I have no idea what the heck he’s doing today.
591 02:31:06.020 ⇒ 02:31:06.993 Uttam Kumaran: Yeah, I
592 02:31:25.410 ⇒ 02:31:27.880 Robert Tseng: What is this random ass join?
593 02:31:33.670 ⇒ 02:31:40.770 Robert Tseng: Don’t need that right? We just do sorry product labor.
594 02:31:46.730 ⇒ 02:31:50.449 Robert Tseng: literally the same thing. I do not understand what we’re doing there.
595 02:31:54.000 ⇒ 02:31:55.010 Robert Tseng: Okay.
596 02:32:03.410 ⇒ 02:32:09.219 Robert Tseng: he’s not no favor.
597 02:32:20.170 ⇒ 02:32:32.180 Robert Tseng: I don’t think this needs to be a dashboard view, or there should be bye week. Really.
598 02:33:54.014 ⇒ 02:33:55.789 Robert Tseng: It’s a new formatting
599 02:35:10.360 ⇒ 02:35:14.669 Robert Tseng: sales for Amazon do not include refund amount.
600 02:35:15.300 ⇒ 02:35:18.139 Robert Tseng: Well, yeah, that makes sense to me
601 02:35:31.170 ⇒ 02:35:35.990 Robert Tseng: like, how do you make stuff like this? So garbage.
602 02:47:33.770 ⇒ 02:47:38.300 Uttam Kumaran: Alright, dude! Everything should be good to go.
603 02:47:39.670 ⇒ 02:47:40.410 Robert Tseng: Okay.
604 02:47:53.480 ⇒ 02:47:56.200 Uttam Kumaran: Okay, yeah. I’m gonna probably spend some time
605 02:47:56.630 ⇒ 02:48:02.760 Uttam Kumaran: later finishing up some stuff for urban stems. But anything else today.
606 02:48:15.500 ⇒ 02:48:19.599 Robert Tseng: dude! I don’t know. I’m still building this dashboard. I haven’t thought about anything else.
607 02:48:20.222 ⇒ 02:48:21.400 Uttam Kumaran: Okay. Okay. Okay.
608 02:48:22.010 ⇒ 02:48:26.990 Robert Tseng: Yeah, I mean, I, I did some.
609 02:48:27.820 ⇒ 02:48:34.396 Robert Tseng: I okay, I can. I can share a bit about partner stuff. I updated
610 02:48:36.743 ⇒ 02:48:43.519 Robert Tseng: I updated our partner status across amplitude, mix panel. I shifted it from Pongo to Brainforge.
611 02:48:43.520 ⇒ 02:48:43.990 Uttam Kumaran: Nice.
612 02:48:44.521 ⇒ 02:48:50.369 Robert Tseng: I also apply to a few more vendor partnerships. And
613 02:48:50.730 ⇒ 02:48:56.090 Robert Tseng: I booked 2 meetings this week.
614 02:48:58.040 ⇒ 02:49:00.740 Robert Tseng: Yeah, just discovery calls, I suppose?
615 02:49:04.980 ⇒ 02:49:05.800 Robert Tseng: Yeah.
616 02:49:06.080 ⇒ 02:49:10.370 Robert Tseng: And then I’m talking to a potential analyst.
617 02:49:11.218 ⇒ 02:49:17.579 Robert Tseng: I think, probably like Sahana level kind of person. Tomorrow
618 02:49:18.240 ⇒ 02:49:25.589 Robert Tseng: I still get pm, like reaching out. I I don’t know if I’ll take any of the calls. Probably not at this point. But
619 02:49:26.270 ⇒ 02:49:29.100 Robert Tseng: yeah, I guess if you have any.
620 02:49:29.240 ⇒ 02:49:36.049 Robert Tseng: if you’re like making any moves on the hiring side, like when you want amber to start, or anything. Just just keep me in the loop on that.
621 02:49:36.360 ⇒ 02:49:37.983 Uttam Kumaran: Okay, yeah, I would.
622 02:49:40.100 ⇒ 02:49:47.719 Uttam Kumaran: even on the analysts. If you want to just toss them all to me, I can. I can take it. I sort of want to make sure you have like
623 02:49:48.030 ⇒ 02:49:51.229 Uttam Kumaran: as much time for sales stuff. The other thing I’m doing is
624 02:49:51.390 ⇒ 02:49:59.520 Uttam Kumaran: I’m gonna bring on. I’m think I’m gonna bring on my friend just to piece. Take off like the 1st round screens and stuff like that.
625 02:50:00.493 ⇒ 02:50:01.820 Uttam Kumaran: For us.
626 02:50:02.290 ⇒ 02:50:02.810 Robert Tseng: Okay.
627 02:50:02.810 ⇒ 02:50:04.750 Uttam Kumaran: Basically, I just told him, like.
628 02:50:05.322 ⇒ 02:50:16.749 Uttam Kumaran: he’s the one he’s the guy who wanted like 1 50, I think. Honestly, he could be good long term for us. But right now it’s not possible. But I think I’m gonna bring him on fractionally, just to like Go source
629 02:50:17.464 ⇒ 02:50:26.570 Uttam Kumaran: and I’m basically gonna say, we want everybody we want, we have prior agency experience, and he can sort of work to go take. Probably
630 02:50:27.520 ⇒ 02:50:34.010 Uttam Kumaran: I I don’t know. Maybe at least 5 to 10 h off both of our plates in terms of like getting us screening of really good people.
631 02:50:37.300 ⇒ 02:50:43.249 Uttam Kumaran: so that should solve that. And then, yeah, I’m gonna I’m gonna decide what to do. I mean, I’m gonna connect.
632 02:50:44.410 ⇒ 02:50:47.090 Uttam Kumaran: I just don’t know if we can afford to lose
633 02:50:48.420 ⇒ 02:50:51.799 Uttam Kumaran: bow right now and then have everything on Sahana, but.
634 02:50:52.110 ⇒ 02:50:53.400 Robert Tseng: Yeah, no, we should.
635 02:50:56.210 ⇒ 02:51:02.820 Uttam Kumaran: I’m basically gonna try and get some. I’m just gonna keep pushing to bring on one other person that’s senior level that we can have internally.
636 02:51:05.160 ⇒ 02:51:09.921 Uttam Kumaran: that can actually like, think about the business. So
637 02:51:11.060 ⇒ 02:51:12.784 Uttam Kumaran: I’ll do that. And then, yeah, I guess.
638 02:51:18.330 ⇒ 02:51:24.689 Uttam Kumaran: yeah, I feel like, I just wanna try and get you all the stuff for the for the renewals tomorrow.
639 02:51:30.370 ⇒ 02:51:31.060 Robert Tseng: Okay.
640 02:51:32.510 ⇒ 02:51:43.809 Robert Tseng: yeah. I mean, I think tomorrow will probably be have to keep the ball rolling on Eden stuff. But between that and sales, like. I mean, I did spend a good. I did spend some time on sales today, so.
641 02:51:43.810 ⇒ 02:51:50.780 Uttam Kumaran: Okay, cool. Yeah. I would just push anything else on the recruiting side, like, even if you have calls, I know they just break up
642 02:51:51.340 ⇒ 02:51:54.810 Uttam Kumaran: the day. If you want me to take them, I can take them because I just take those like
643 02:51:55.290 ⇒ 02:51:57.310 Uttam Kumaran: I just take those in my sleep now.
644 02:51:57.570 ⇒ 02:51:58.260 Robert Tseng: Okay.
645 02:51:58.880 ⇒ 02:52:03.710 Uttam Kumaran: So if you’re like someone seems decent, you can just send them to me, and that way I
646 02:52:03.820 ⇒ 02:52:09.539 Uttam Kumaran: I’ll I also. Sometimes we don’t need I? I just talk to people, and I just keep them in the loop on stuff. So
647 02:52:13.170 ⇒ 02:52:14.150 Uttam Kumaran: yeah.
648 02:52:20.320 ⇒ 02:52:21.030 Robert Tseng: Okay.
649 02:52:22.970 ⇒ 02:52:25.180 Uttam Kumaran: Okay, cool. Alright. I’m gonna get some food.
650 02:52:25.640 ⇒ 02:52:27.089 Robert Tseng: Yeah. Alright. See? Ya.
651 02:52:27.300 ⇒ 02:52:28.460 Uttam Kumaran: Thanks, Sue, bye.