Meeting Title: Analyst Team Daily Date: 2025-02-27 Meeting participants: Uttam Kumaran, Jakob Kagel, Bo Yoon, Robert Tseng
WEBVTT
1 00:01:20.100 ⇒ 00:01:20.900 Jakob Kagel: Yo.
2 00:01:20.900 ⇒ 00:01:21.270 Uttam Kumaran: Hey!
3 00:01:23.720 ⇒ 00:01:24.830 Jakob Kagel: How’s it going.
4 00:01:29.230 ⇒ 00:01:30.360 Uttam Kumaran: How’s it going? Dude?
5 00:01:31.280 ⇒ 00:01:33.610 Jakob Kagel: Oh, it’s going well, well, how about yourself?
6 00:01:34.510 ⇒ 00:01:39.659 Uttam Kumaran: Good ready for tomorrow. It’s been a good week overall.
7 00:01:39.870 ⇒ 00:01:42.525 Jakob Kagel: Yeah, how are we looking with the client?
8 00:01:42.820 ⇒ 00:01:44.200 Uttam Kumaran: It’s good, better.
9 00:01:45.008 ⇒ 00:01:48.839 Jakob Kagel: So tomorrow they’re gonna decide if they’re gonna renew or not.
10 00:01:49.040 ⇒ 00:01:53.500 Uttam Kumaran: I think tomorrow, either tomorrow or Monday.
11 00:01:54.800 ⇒ 00:01:58.170 Uttam Kumaran: But we’re looking really good. I mean, today, I think we’ll have.
12 00:01:58.560 ⇒ 00:02:03.640 Uttam Kumaran: We’ll have gorgeous day to them. We’ll have both of these dashboards done, and then
13 00:02:04.220 ⇒ 00:02:06.980 Uttam Kumaran: I may push something out for otendo.
14 00:02:08.240 ⇒ 00:02:09.699 Uttam Kumaran: Also. So
15 00:02:10.500 ⇒ 00:02:16.090 Uttam Kumaran: yeah, I feel pretty good. I mean, we got some category worked on. I’m also meeting with them again tomorrow.
16 00:02:16.290 ⇒ 00:02:21.330 Uttam Kumaran: So we did what we could. I feel I feel a lot better than Monday for sure.
17 00:02:21.330 ⇒ 00:02:23.779 Uttam Kumaran: Okay, yeah. Sounds good yeah. For sure.
18 00:02:25.500 ⇒ 00:02:43.027 Jakob Kagel: Yeah. So I mean on the gross margin one, right? Like, I updated all the views like with the like the new product category. I mean, you’re still gonna be, I think, affected by like what I just showed that like, there’s a lot that are uncategorized, and those are probably all the Amazon ones
19 00:02:43.620 ⇒ 00:02:44.130 Jakob Kagel: but.
20 00:02:44.130 ⇒ 00:02:46.380 Uttam Kumaran: Yeah, let me let me just
21 00:02:46.630 ⇒ 00:02:50.750 Uttam Kumaran: like if we just stay on the line and let me see if I could just fix it, cause I think.
22 00:02:50.750 ⇒ 00:02:54.980 Jakob Kagel: Right? Exactly. That’s what I was gonna say is like, let’s just see if we can fix it real quick.
23 00:02:54.980 ⇒ 00:02:57.307 Uttam Kumaran: I think I know what it is.
24 00:02:58.450 ⇒ 00:03:01.839 Uttam Kumaran: feel like. It’s because they may not be capitalized.
25 00:03:02.410 ⇒ 00:03:03.550 Uttam Kumaran: Let’s see.
26 00:03:10.480 ⇒ 00:03:14.458 Jakob Kagel: If it’s something, is that simple? Then, yeah, exactly. We just.
27 00:03:18.180 ⇒ 00:03:20.419 Uttam Kumaran: Yeah, I feel like I didn’t really.
28 00:03:21.740 ⇒ 00:03:29.765 Uttam Kumaran: I didn’t really look at the values I just like applied the same thing. But something.
29 00:03:30.830 ⇒ 00:03:33.199 Uttam Kumaran: no, it’s too good to be true.
30 00:04:23.420 ⇒ 00:04:28.629 Uttam Kumaran: Okay, let me just make a change. And I’ll run it again. But we can probably
31 00:04:29.985 ⇒ 00:04:32.679 Uttam Kumaran: talk about. If there’s I don’t think
32 00:04:32.940 ⇒ 00:04:35.719 Uttam Kumaran: I think that’s the only thing on your side. Right, Jacob.
33 00:04:36.110 ⇒ 00:05:00.360 Jakob Kagel: I was gonna add, like the same way I did the splits like for cogs and everything like for product category. I was, gonna do the product category splits like for discount and refund as well. So I didn’t include them in like the those ones, because, like they’re just, it’s too wide like you wouldn’t be able to see them all in one view. So I was just gonna create separate splits for those.
34 00:05:01.100 ⇒ 00:05:01.810 Uttam Kumaran: Okay.
35 00:05:02.290 ⇒ 00:05:09.270 Jakob Kagel: Yeah, I mean, yeah, I think that’s yeah. That that’s really all I think that
36 00:05:09.970 ⇒ 00:05:13.515 Jakob Kagel: like for now I guess to add to gross margin
37 00:05:14.640 ⇒ 00:05:16.560 Jakob Kagel: as long as you’re okay with it.
38 00:05:16.920 ⇒ 00:05:22.665 Uttam Kumaran: Yeah, I’m fine with that cool, I guess.
39 00:05:23.030 ⇒ 00:05:39.159 Jakob Kagel: Yeah, I’ll just go in and like, yeah, like you said, I mean, I’ll go ahead and make the change like on the Amazon dashboard and then fix the underlying. Then it should come through no problem. I mean, I think we only have maybe 2 or 3 product category views on there. So yeah, it shouldn’t be too much to change.
40 00:05:42.790 ⇒ 00:05:45.099 Uttam Kumaran: Yeah, I’m seeing them all come in as a
41 00:05:45.480 ⇒ 00:05:52.250 Uttam Kumaran: uncategorized now. So let me work on that. I guess, Robert, we can move on to talk about stuff for
42 00:05:53.010 ⇒ 00:05:55.809 Uttam Kumaran: for Eden while I’m making this change.
43 00:05:59.040 ⇒ 00:06:06.810 Robert Tseng: Okay, I mean, there’s a there’s an they came back with a couple of Amazon dash iteration. I mean, I is this, I know you guys talking about gross.
44 00:06:06.810 ⇒ 00:06:12.050 Uttam Kumaran: Oh, yeah. So the yeah, I made a made those changes.
45 00:06:12.610 ⇒ 00:06:14.100 Robert Tseng: You made the modeling changes.
46 00:06:14.590 ⇒ 00:06:19.959 Uttam Kumaran: Yeah, the other one. So labors is a separate category. Units is fixed.
47 00:06:20.430 ⇒ 00:06:24.620 Uttam Kumaran: and then I haven’t. We haven’t done the subscribe and save yet.
48 00:06:25.400 ⇒ 00:06:29.000 Robert Tseng: Okay, that’s fine. I’ll just make a quick change and send it over.
49 00:06:29.170 ⇒ 00:06:34.559 Uttam Kumaran: Okay, save like that. Is there. Is there a version of that.
50 00:06:34.940 ⇒ 00:06:40.840 Robert Tseng: On shopify or or no. Those are just the normal subscription. So this is just like, somewhere in Amazon, there’s a flag for that.
51 00:06:41.420 ⇒ 00:06:47.050 Robert Tseng: Yeah, it’s it’s based on. Yeah, subscriber plus like this offer tag, or whatever.
52 00:06:47.950 ⇒ 00:06:49.109 Robert Tseng: I think
53 00:06:49.560 ⇒ 00:06:56.139 Robert Tseng: I didn’t look into it. But I think Justin gave like a example of like, how you would find a subscribe and save Guy.
54 00:06:56.330 ⇒ 00:06:57.030 Uttam Kumaran: Okay.
55 00:06:57.610 ⇒ 00:06:58.290 Robert Tseng: But
56 00:06:59.610 ⇒ 00:07:12.349 Robert Tseng: but it’s good. I mean he he likes the Amazon dash, he said. He wants us. He want, he like added, like 5 people to that that channel. So that’s exactly the kind of engagement we want to see.
57 00:07:12.970 ⇒ 00:07:13.950 Robert Tseng: So.
58 00:07:14.470 ⇒ 00:07:15.460 Uttam Kumaran: Nice.
59 00:07:15.760 ⇒ 00:07:19.939 Robert Tseng: Thank you, Jacob. That’s that’s been. That’s been a. It’s been a good one.
60 00:07:20.100 ⇒ 00:07:25.720 Jakob Kagel: No, yeah, no, no need to think, you know. But yeah, definitely tried my best. I appreciate it.
61 00:07:26.190 ⇒ 00:07:26.770 Robert Tseng: Yeah.
62 00:07:30.830 ⇒ 00:07:37.179 Robert Tseng: I guess. Alright, bo, since you’re since you’re here, we’ll just kind of chat through the even stuff real quick.
63 00:07:40.140 ⇒ 00:07:40.680 Bo Yoon: Yeah.
64 00:07:42.590 ⇒ 00:07:45.459 Robert Tseng: I didn’t review what you sent over, but I will now
65 00:07:48.050 ⇒ 00:07:53.310 Robert Tseng: me pull it up so we can kind of just give some feedback on it.
66 00:07:58.930 ⇒ 00:08:00.410 Robert Tseng: Okay?
67 00:08:02.950 ⇒ 00:08:03.690 Robert Tseng: Oh.
68 00:08:06.860 ⇒ 00:08:09.479 Robert Tseng: alright. So exec dash here, let’s take a look.
69 00:08:09.750 ⇒ 00:08:14.660 Robert Tseng: So you updated all the tiles here, and then
70 00:08:18.650 ⇒ 00:08:21.270 Robert Tseng: does this revenue number make sense.
71 00:08:22.580 ⇒ 00:08:27.079 Robert Tseng: I think this is misleading. Bo, like this looks like
72 00:08:27.480 ⇒ 00:08:31.799 Robert Tseng: revenue is 14 million. So I would I would change this.
73 00:08:32.370 ⇒ 00:08:32.889 Robert Tseng: I would just.
74 00:08:34.260 ⇒ 00:08:35.890 Bo Yoon: Remove the total, then.
75 00:08:36.330 ⇒ 00:08:37.770 Robert Tseng: Yeah, just remove the total.
76 00:08:38.220 ⇒ 00:08:38.929 Bo Yoon: Okay.
77 00:08:39.350 ⇒ 00:08:42.340 Robert Tseng: Yeah, so we’ll remove that. Then.
78 00:08:44.210 ⇒ 00:08:48.320 Robert Tseng: Yeah, I mean, this is what this is the standard playing.
79 00:08:49.342 ⇒ 00:08:57.430 Robert Tseng: Something off here. The filter looks like it’s just on a
80 00:08:58.580 ⇒ 00:09:04.670 Robert Tseng: it looks like it’s on total orders. But I’m seeing new like new, so I don’t know if this.
81 00:09:04.670 ⇒ 00:09:10.319 Bo Yoon: Oh, could I? Yeah, I’ll just switch those the the location.
82 00:09:11.450 ⇒ 00:09:11.890 Robert Tseng: Yeah.
83 00:09:11.890 ⇒ 00:09:15.989 Bo Yoon: The the total orders to the 1st time orders place.
84 00:09:16.390 ⇒ 00:09:28.510 Robert Tseng: Yeah, I have not clicked on it. But yeah, I think if I were looking at 1st time it should be news. It should be new, everything, and then, if I flip total, it should be. It shouldn’t be new kind of like what we did for the other.
85 00:09:29.110 ⇒ 00:09:33.039 Robert Tseng: And then great. This looks better.
86 00:09:33.540 ⇒ 00:09:43.279 Robert Tseng: Yikes point 5 3 million. Does that make sense? 500,000 profitability revenue?
87 00:09:44.640 ⇒ 00:09:48.240 Robert Tseng: Yeah, okay, I can buy that. Yeah.
88 00:09:49.950 ⇒ 00:09:55.789 Robert Tseng: And then new profitability, average net profit.
89 00:09:59.560 ⇒ 00:10:08.659 Robert Tseng: new profitability per order. I think if I’m Josh, I’m looking at this.
90 00:10:10.530 ⇒ 00:10:12.580 Robert Tseng: What would I say?
91 00:10:22.831 ⇒ 00:10:25.219 Bo Yoon: For for that chart, I I thought.
92 00:10:25.330 ⇒ 00:10:30.009 Bo Yoon: I mean that we need is something showing the Cox
93 00:10:30.490 ⇒ 00:10:33.639 Bo Yoon: or the profitability of something. So
94 00:10:34.610 ⇒ 00:10:38.319 Bo Yoon: I added the chart to the bottom. But we can.
95 00:10:39.060 ⇒ 00:10:46.319 Bo Yoon: The the logic is very simple. It’s just the the root new revenue minus the the Cox.
96 00:10:46.670 ⇒ 00:10:56.670 Robert Tseng: How is this gonna be different from? Is this gonna be different from the calculation on the profitability dashboard? Because we’re we’re still waiting for that from a wish, or like what’s what’s the progress on that one.
97 00:10:58.190 ⇒ 00:11:02.030 Bo Yoon: That. I think a waste that just
98 00:11:02.330 ⇒ 00:11:05.409 Bo Yoon: updated something. I’ll I’ll have to check on that.
99 00:11:06.680 ⇒ 00:11:10.019 Bo Yoon: But the logic is going to be similar or the same.
100 00:11:11.730 ⇒ 00:11:12.410 Robert Tseng: Okay.
101 00:11:12.940 ⇒ 00:11:13.590 Bo Yoon: Yeah.
102 00:11:16.330 ⇒ 00:11:18.230 Robert Tseng: I’m going to.
103 00:11:19.430 ⇒ 00:11:22.749 Robert Tseng: Sorry. I know that this is like iterative, but I think
104 00:11:23.210 ⇒ 00:11:28.779 Robert Tseng: there, I would actually probably change this view here.
105 00:11:29.360 ⇒ 00:11:35.599 Robert Tseng: Yeah, I’ll send you a table structure. You can change.
106 00:11:35.870 ⇒ 00:11:37.330 Robert Tseng: And then.
107 00:11:38.700 ⇒ 00:11:44.549 Robert Tseng: yeah, that’s that’s fine. I mean, I I would rather still just like deploy it. They can see.
108 00:11:45.090 ⇒ 00:12:01.540 Robert Tseng: Actually, I don’t know. I feel like that’s gonna ask a bunch of questions. That’s fine. Okay? So you know the the edits here and then owe you some more specific feedback on this one. I think I just wanna change this table structure. And then I would also,
109 00:12:02.550 ⇒ 00:12:08.550 Robert Tseng: yeah, there’s like a visual that I think we should add, okay, so that’s that.
110 00:12:10.960 ⇒ 00:12:16.500 Robert Tseng: Then, yeah. Any anything else that you have ready for feedback.
111 00:12:16.960 ⇒ 00:12:20.117 Bo Yoon: Yes, so for the weight loss.
112 00:12:23.260 ⇒ 00:12:30.760 Bo Yoon: there are some products that where customers actually gain weight, post treatment.
113 00:12:31.390 ⇒ 00:12:32.699 Robert Tseng: Yeah, that makes sense.
114 00:12:33.060 ⇒ 00:12:35.920 Bo Yoon: That that makes sense. So should I still include it like this?
115 00:12:36.260 ⇒ 00:12:38.620 Robert Tseng: Yeah, I think I think we should. We should show when.
116 00:12:38.620 ⇒ 00:12:39.130 Bo Yoon: Okay.
117 00:12:39.350 ⇒ 00:12:39.950 Robert Tseng: Yeah.
118 00:12:40.920 ⇒ 00:12:48.590 Bo Yoon: Okay? And yeah, I’m using the new model that Tom post yesterday. And
119 00:12:50.900 ⇒ 00:12:52.659 Bo Yoon: yeah, the data makes sense.
120 00:12:54.040 ⇒ 00:12:54.450 Robert Tseng: Okay.
121 00:12:54.450 ⇒ 00:12:59.420 Bo Yoon: Doesn’t have. Yeah, it doesn’t have duplicates, I believe, anymore.
122 00:13:00.430 ⇒ 00:13:04.410 Bo Yoon: Did you remove the the duplicates as well, Otam or.
123 00:13:05.330 ⇒ 00:13:06.799 Uttam Kumaran: I have not touched.
124 00:13:07.830 ⇒ 00:13:08.940 Bo Yoon: Oh! You have not.
125 00:13:09.200 ⇒ 00:13:09.840 Uttam Kumaran: Yeah.
126 00:13:11.750 ⇒ 00:13:18.860 Bo Yoon: Hmm, okay, what about the age column is is that completed? Was there an update on that.
127 00:13:20.722 ⇒ 00:13:22.320 Uttam Kumaran: Was I on.
128 00:13:22.672 ⇒ 00:13:23.377 Bo Yoon: Remember the
129 00:13:23.730 ⇒ 00:13:25.700 Uttam Kumaran: Cause I don’t. I don’t remember.
130 00:13:26.790 ⇒ 00:13:29.439 Uttam Kumaran: Yeah, I didn’t push anything for that yet.
131 00:13:29.640 ⇒ 00:13:32.870 Bo Yoon: Oh, okay, yeah, let me.
132 00:13:34.990 ⇒ 00:13:39.140 Uttam Kumaran: Let me know what you need. I mean I can. If it’s something easy I can get it done.
133 00:13:39.470 ⇒ 00:13:42.989 Robert Tseng: Wait, Bo, can you share your screen again so I can give you a bit of feedback on that?
134 00:13:43.280 ⇒ 00:13:43.800 Robert Tseng: Oh.
135 00:13:43.800 ⇒ 00:13:46.390 Bo Yoon: On the weight loss. Okay, let me let me just.
136 00:13:46.390 ⇒ 00:13:48.290 Robert Tseng: Yeah, yeah, finish. Finish your thought, yeah.
137 00:13:48.510 ⇒ 00:13:53.629 Bo Yoon: So the format on the age column. Some of them are like this 4 digits.
138 00:13:53.630 ⇒ 00:13:58.540 Uttam Kumaran: Oh, shit. Yeah, yeah. You did tell me, okay, I will.
139 00:14:00.380 ⇒ 00:14:03.250 Uttam Kumaran: But like you, do, you need to change anything if I just fix it.
140 00:14:04.400 ⇒ 00:14:07.199 Bo Yoon: Oh, no, it will just update.
141 00:14:07.806 ⇒ 00:14:11.059 Uttam Kumaran: I’ll fix it, it’ll it’ll it’ll flow through.
142 00:14:11.600 ⇒ 00:14:13.239 Bo Yoon: Okay. Okay. Sounds good.
143 00:14:13.370 ⇒ 00:14:13.900 Uttam Kumaran: Okay.
144 00:14:14.720 ⇒ 00:14:18.929 Robert Tseng: Okay, yeah, let’s go back to the visual. I had a couple of things that I wanted to say on that.
145 00:14:18.930 ⇒ 00:14:19.840 Bo Yoon: Yeah, sure.
146 00:14:23.750 ⇒ 00:14:27.241 Robert Tseng: How do I draw on your screen? I forgot how to do this.
147 00:14:27.810 ⇒ 00:14:30.280 Uttam Kumaran: There’s a little thing on the left bottom left.
148 00:14:30.280 ⇒ 00:14:31.800 Robert Tseng: I see it. Yeah, yeah, okay.
149 00:14:31.800 ⇒ 00:14:34.340 Uttam Kumaran: And then I try to. I try to do the disappearing marker.
150 00:14:35.640 ⇒ 00:14:42.050 Uttam Kumaran: If you click on, if you click on, draw. The second option is vanishing. Pen. Oh, it goes away. Otherwise you have to.
151 00:14:42.050 ⇒ 00:14:42.810 Robert Tseng: That’s right.
152 00:14:43.570 ⇒ 00:14:48.629 Robert Tseng: Okay, yeah. So, but I would just say, make sure that when you look at like.
153 00:14:49.680 ⇒ 00:14:59.820 Robert Tseng: when, yeah, when you create these labels make sure that they are this like user friendly. So I think.
154 00:14:59.820 ⇒ 00:15:00.709 Bo Yoon: I got a.
155 00:15:01.390 ⇒ 00:15:05.335 Robert Tseng: I don’t think we need a right average on everything.
156 00:15:07.460 ⇒ 00:15:13.900 Robert Tseng: I think we can. Just we can just have like it, just like you have like a table like a chart title. Just have a
157 00:15:14.210 ⇒ 00:15:24.750 Robert Tseng: table, tiles like average weight metrics by treatment or something, and then you can remove all the average here so that it’s a bit cleaner.
158 00:15:25.570 ⇒ 00:15:29.530 Robert Tseng: And then, yeah, this needs a bit cleaner. Those yeah, like this.
159 00:15:30.060 ⇒ 00:15:37.369 Robert Tseng: I don’t think we should ever show count of user. Id, we should just say, number, like number of users, or like user number, or whatever. Yeah.
160 00:15:37.726 ⇒ 00:15:44.850 Bo Yoon: I think the update on the model changed all the all the titles. It’s different from what I saw. Yeah.
161 00:15:45.330 ⇒ 00:15:47.129 Bo Yoon: But but I’ll change it. Yeah.
162 00:15:47.130 ⇒ 00:15:50.982 Robert Tseng: Yeah. And then last, small thing is here like,
163 00:15:52.550 ⇒ 00:15:56.490 Robert Tseng: post 30 days. If we could just do like.
164 00:15:59.600 ⇒ 00:16:04.599 Robert Tseng: yeah, in parentheses. Post 30 capital. D, like, I,
165 00:16:04.920 ⇒ 00:16:08.900 Robert Tseng: yeah, for like day, month, year, I usually just use abbreviations.
166 00:16:11.100 ⇒ 00:16:14.619 Bo Yoon: So just d instead of base. That’s the phone.
167 00:16:15.070 ⇒ 00:16:20.160 Robert Tseng: Or like make the post post 30, I mean. I wish I could just edit this. But like
168 00:16:20.520 ⇒ 00:16:22.491 Robert Tseng: this is a stylistic thing. But
169 00:16:23.890 ⇒ 00:16:28.609 Robert Tseng: any qualifier for your metric should usually be in parentheses
170 00:16:29.143 ⇒ 00:16:33.579 Robert Tseng: so just like average weight, and then parentheses. Post 30 d.
171 00:16:34.870 ⇒ 00:16:36.810 Bo Yoon: Okay. Okay.
172 00:16:40.320 ⇒ 00:16:48.529 Robert Tseng: Okay, yeah. Other than that, that name. This looks good. I would like to. I would like to ship something today. So if we can get this one out. At least that would be good.
173 00:16:49.290 ⇒ 00:16:56.300 Bo Yoon: Okay, yeah. I’ll fix those 2 dashboards right now, after this meeting. Then.
174 00:16:58.200 ⇒ 00:17:01.309 Robert Tseng: And then I will share kind of something that I’ve been working on.
175 00:17:02.380 ⇒ 00:17:07.310 Robert Tseng: So yeah, I’ve been building out like a demand forecast for Eden. So.
176 00:17:07.310 ⇒ 00:17:08.130 Uttam Kumaran: Let’s go.
177 00:17:09.640 ⇒ 00:17:15.070 Robert Tseng: Yeah, so basically, and this was kind of painful, because I like had to manually pull this data. But like
178 00:17:16.130 ⇒ 00:17:24.350 Robert Tseng: these are the 3 products that we report forecast. For to pharmacy, I mean, there’s some things I need to change about this. And I’m just like experimenting with some of the
179 00:17:24.530 ⇒ 00:17:27.839 Robert Tseng: growth rate calculations. What’s the bet? Best one to go with.
180 00:17:28.109 ⇒ 00:17:28.815 Robert Tseng: But
181 00:17:31.170 ⇒ 00:17:40.999 Robert Tseng: yeah, I think the output of this is, I’m gonna have to give them like a per product forecast, at least the March number. They’re gonna hand to their pharmacy.
182 00:17:41.200 ⇒ 00:17:47.979 Robert Tseng: Eventually, I would like this data to come in more like automatically, or I’m gonna hand it off, and someone else is gonna maintain it.
183 00:17:48.090 ⇒ 00:17:52.610 Robert Tseng: But yeah, I just wanted to to flash this. So you guys could see.
184 00:17:52.940 ⇒ 00:17:59.379 Robert Tseng: And then what I’m thinking about like weekly business review, or just like a daily view for the
185 00:17:59.840 ⇒ 00:18:02.480 Robert Tseng: execs to kind of look at.
186 00:18:02.970 ⇒ 00:18:10.854 Robert Tseng: Yeah, I feel like the dashboard thing is all like nice and all for visuals and stuff. But I think just having like a clean
187 00:18:12.150 ⇒ 00:18:13.090 Robert Tseng: Mike
188 00:18:13.950 ⇒ 00:18:21.350 Robert Tseng: product tracker like this is something like a pared down version of what I had built for rubble before.
189 00:18:24.670 ⇒ 00:18:33.610 Robert Tseng: yeah, I would want, like every product name by their category, like functional category, whether it’s weight, loss, or metabolism, whatever.
190 00:18:35.180 ⇒ 00:18:36.420 Robert Tseng: And then
191 00:18:36.670 ⇒ 00:18:42.559 Robert Tseng: I don’t know. Maybe it’s like gummies like, you know, stuff like something like that. And then
192 00:18:42.710 ⇒ 00:18:53.570 Robert Tseng: we have like these numbers that are just. This is all updated dynamically. So I kind of want to be, I’m gonna demo this to them probably this week, probably tomorrow when I do my check in with the execs.
193 00:18:53.710 ⇒ 00:19:08.689 Robert Tseng: But I feel like we have most of this data that way. We can have product level sales. It’s just like a different view connecting that with, like some of the vanity metrics like page views and stuff. Because so so the brand team can actually know, like
194 00:19:09.050 ⇒ 00:19:17.890 Robert Tseng: the traffic that they’re driving to the website for some of these products like, is it actually translating to sales? Or how efficient is it? How efficient is that traffic.
195 00:19:18.050 ⇒ 00:19:40.899 Robert Tseng: And then I kinda also wanna like, unify that with like our products, the product team and like how they end up launching like new new drugs and stuff. So anyway, like this is like a bit of a longer term longer term play. But ideally, once we have something like this set up. I think this is like a 2 to 4 week project. I want to get them to sign off on it.
196 00:19:41.240 ⇒ 00:19:49.190 Robert Tseng: And yeah, like. I think this would be a helpful tool for the execs to look at.
197 00:19:50.570 ⇒ 00:19:57.900 Uttam Kumaran: Yeah, I think as long as you. If you just have a way like we can just run a query, basically, and give you the raw to fill all that out.
198 00:19:59.310 ⇒ 00:20:03.419 Uttam Kumaran: Or you could probably query and build that first.st And then we can.
199 00:20:03.850 ⇒ 00:20:06.440 Uttam Kumaran: Yeah, let’s just keep that updated. Basically.
200 00:20:07.320 ⇒ 00:20:19.460 Robert Tseng: Yeah, I don’t mind. It’s a bit manual. And someone just updates this once a week. Kind of thing for now. But like, yeah, I’m not gonna build out every detail. I’m just, I’m just trying to like outline it. So you can kinda see like, what’s what I what’s coming.
201 00:20:20.740 ⇒ 00:20:21.560 Robert Tseng: Yeah.
202 00:20:22.550 ⇒ 00:20:33.964 Robert Tseng: okay? And then, hopefully, that’s enough of like the modeling work that like forecasting work that I will do for them. This is not my forte, and I don’t really enjoy doing that.
203 00:20:35.080 ⇒ 00:20:35.770 Bo Yoon: Okay.
204 00:20:35.770 ⇒ 00:20:37.492 Bo Yoon: Are you doing that in python?
205 00:20:37.780 ⇒ 00:20:41.837 Robert Tseng: No, I just, I just did this in Google sheets. Bro, like, I.
206 00:20:42.330 ⇒ 00:20:42.770 Uttam Kumaran: I mean, dude.
207 00:20:42.770 ⇒ 00:20:53.939 Uttam Kumaran: This is it like I feel like if they can build this out, and then we can re ingest the goals, and we can show achievement and stuff like that. But like, yeah, I feel like, honestly, if that spreadsheet
208 00:20:54.620 ⇒ 00:20:58.780 Uttam Kumaran: that’s probably the best spreadsheet I’ve seen that actually shows everything in one place.
209 00:20:59.300 ⇒ 00:20:59.910 Robert Tseng: Yeah.
210 00:21:00.120 ⇒ 00:21:06.480 Uttam Kumaran: That’s fine. And then, as soon as they get to using that, we can move, move them to tableau eventually. But like, that’s really great.
211 00:21:06.890 ⇒ 00:21:11.779 Robert Tseng: Yeah, cool. So that’s that.
212 00:21:12.550 ⇒ 00:21:15.570 Robert Tseng: I think I am also having to.
213 00:21:16.400 ⇒ 00:21:24.230 Robert Tseng: They don’t have one pass to share tableau cred. So now we’re gonna add 10 more viewer seats. So that’s my last update. There.
214 00:21:24.860 ⇒ 00:21:25.550 Uttam Kumaran: Okay.
215 00:21:26.310 ⇒ 00:21:26.890 Robert Tseng: Yeah.
216 00:21:28.075 ⇒ 00:21:34.340 Uttam Kumaran: I, okay. So this categories fixes.
217 00:21:37.430 ⇒ 00:21:39.739 Uttam Kumaran: Should basically finish here in a sec.
218 00:21:39.970 ⇒ 00:21:42.920 Uttam Kumaran: I’m gonna finish the age thing.
219 00:21:44.990 ⇒ 00:21:48.305 Uttam Kumaran: Do we wanna just go. Can we go make the change for the
220 00:21:49.370 ⇒ 00:21:52.539 Uttam Kumaran: the Javi thing while we’re on this call for the other stuff.
221 00:21:53.360 ⇒ 00:21:54.279 Robert Tseng: Oh, my! Gosh!
222 00:21:55.020 ⇒ 00:22:02.150 Uttam Kumaran: Yeah, do you? Wanna just go? Do you wanna just go check the the new hype real quick
223 00:22:02.880 ⇒ 00:22:03.620 Uttam Kumaran: and.
224 00:22:03.620 ⇒ 00:22:04.700 Robert Tseng: Yeah, yeah, sure.
225 00:22:05.100 ⇒ 00:22:15.479 Uttam Kumaran: And then you should be able to actually remove that old flavor, and then flavor is now a dimension in the table, so you can just swap it out and then save and replace.
226 00:22:16.450 ⇒ 00:22:17.599 Uttam Kumaran: and we’ll be good.
227 00:22:18.620 ⇒ 00:22:19.490 Robert Tseng: Okay.
228 00:22:19.490 ⇒ 00:22:22.590 Uttam Kumaran: Subscribe and save, I will spend.
229 00:22:23.360 ⇒ 00:22:28.269 Uttam Kumaran: I will spend 6 min looking for that. If I find it, I’ll push it. If it’s not, then I may
230 00:22:28.840 ⇒ 00:22:29.670 Uttam Kumaran: Kk.
231 00:22:30.340 ⇒ 00:22:31.650 Robert Tseng: Okay. No worries.
232 00:22:34.280 ⇒ 00:22:37.220 Uttam Kumaran: So that’s all I can promise.
233 00:22:44.081 ⇒ 00:22:48.320 Uttam Kumaran: And then, beau, I I assume. Nothing.
234 00:22:48.450 ⇒ 00:22:50.540 Uttam Kumaran: no progress on no kendo stuff.
235 00:22:53.338 ⇒ 00:22:56.690 Bo Yoon: No. Actually actually built like a few graphs.
236 00:22:57.340 ⇒ 00:22:58.200 Uttam Kumaran: Oh, you did. Okay.
237 00:22:58.200 ⇒ 00:22:59.180 Bo Yoon: Yeah.
238 00:22:59.890 ⇒ 00:23:01.679 Uttam Kumaran: One sec. Well, can I see it?
239 00:23:02.460 ⇒ 00:23:04.130 Bo Yoon: Yeah, sure.
240 00:23:04.130 ⇒ 00:23:05.929 Uttam Kumaran: Nice. Let’s go.
241 00:23:09.740 ⇒ 00:23:10.809 Bo Yoon: Where is this?
242 00:23:29.510 ⇒ 00:23:30.370 Robert Tseng: Alright.
243 00:23:30.660 ⇒ 00:23:31.240 Robert Tseng: Well.
244 00:23:37.610 ⇒ 00:23:39.400 Robert Tseng: let’s see.
245 00:23:46.110 ⇒ 00:23:48.559 Robert Tseng: Look at this one.
246 00:24:08.670 ⇒ 00:24:09.340 Robert Tseng: Hmm!
247 00:24:10.930 ⇒ 00:24:13.201 Robert Tseng: Oh, you literally just ingested the
248 00:24:15.100 ⇒ 00:24:18.970 Uttam Kumaran: I just check. Well, I I yeah, I killed this one. I basically
249 00:24:19.540 ⇒ 00:24:22.580 Uttam Kumaran: put this in the repo and swapped it.
250 00:24:22.870 ⇒ 00:24:23.819 Robert Tseng: I see?
251 00:24:25.730 ⇒ 00:24:26.799 Robert Tseng: But yeah.
252 00:24:26.800 ⇒ 00:24:32.609 Uttam Kumaran: There’s a pro. There is a product category. There’s 2 fields now there’s flavor, and there’s category.
253 00:24:34.480 ⇒ 00:24:39.709 Uttam Kumaran: I didn’t know whether you still wanted to keep flavor so you can do category.
254 00:24:43.270 ⇒ 00:24:44.100 Robert Tseng: Let me see.
255 00:24:52.370 ⇒ 00:25:06.910 Robert Tseng: But they’re both off of order, line or yeah, no, I think flavor is different from category. He wanted it by flavor and he wanted to see all the flavors, which is why I was like, we kind of have to expand Jacob’s expression here.
256 00:25:08.120 ⇒ 00:25:12.179 Uttam Kumaran: Just let me, so I guess I didn’t know what other flavors there were.
257 00:25:12.180 ⇒ 00:25:13.260 Jakob Kagel: I don’t know either.
258 00:25:13.260 ⇒ 00:25:16.359 Uttam Kumaran: Okay, then I can keep expand. I’ll keep expanding it. That’s fine.
259 00:25:16.360 ⇒ 00:25:28.140 Jakob Kagel: Yeah, I mean, I can. I can help with that. I mean, there’s really only a couple more, but I can extract them like from the list. It’s like there’s like cookies and cream white chocolate like a couple of others.
260 00:25:29.280 ⇒ 00:25:31.270 Jakob Kagel: I can just send you over the list here.
261 00:25:31.270 ⇒ 00:25:32.730 Uttam Kumaran: Yeah. Just send me the list.
262 00:25:36.570 ⇒ 00:25:42.310 Robert Tseng: Okay, cool. So I think that’ll that’ll deal with that request. And then.
263 00:25:42.880 ⇒ 00:25:51.130 Robert Tseng: yeah, I mean, a lot of this stuff is on sub subscriber subscription and save. So I’m probably not gonna push anything to them today because it’s not gonna have most of what he’s asking for.
264 00:25:51.380 ⇒ 00:26:01.380 Robert Tseng: But the other thing that we could check right now is the Ltv calc, so
265 00:26:02.840 ⇒ 00:26:06.114 Robert Tseng: yeah, let’s go do customers. And
266 00:26:11.380 ⇒ 00:26:15.319 Uttam Kumaran: And then, Jacob, that up the categories, fixes is done. So that’s in there.
267 00:26:15.670 ⇒ 00:26:18.929 Jakob Kagel: Alright. I’ll just make sure that it’s up to date. Yep.
268 00:26:29.360 ⇒ 00:26:36.553 Uttam Kumaran: You guys should see my Vs code dude. I have, like, I like 8 repos open. It’s like I have, like.
269 00:26:37.230 ⇒ 00:26:39.304 Uttam Kumaran: it’s there’s a lot going on.
270 00:26:41.400 ⇒ 00:26:43.090 Uttam Kumaran: Oh, I’m using cursor, though.
271 00:26:44.280 ⇒ 00:26:45.460 Robert Tseng: Is it helpful.
272 00:26:45.460 ⇒ 00:26:48.799 Uttam Kumaran: Yes, it’s actually so helpful.
273 00:26:49.250 ⇒ 00:26:57.139 Uttam Kumaran: I mean, like it didn’t help me know what to do like. It’s not like you should do this, but if you know what you’re doing it like.
274 00:26:57.910 ⇒ 00:27:02.840 Uttam Kumaran: it’s just like it’s like auto correct on steroids. So it just like cuts another 20% off.
275 00:27:02.980 ⇒ 00:27:04.120 Uttam Kumaran: However.
276 00:27:04.260 ⇒ 00:27:08.830 Uttam Kumaran: you can kind of loop around where you keep it like, make this change, make this change and like
277 00:27:09.140 ⇒ 00:27:10.260 Uttam Kumaran: it doesn’t.
278 00:27:10.800 ⇒ 00:27:12.979 Uttam Kumaran: It doesn’t help unless you know what you’re doing.
279 00:27:14.480 ⇒ 00:27:17.779 Uttam Kumaran: It’s like not gonna teach you. Dbt, it’s gonna like.
280 00:27:18.580 ⇒ 00:27:22.809 Uttam Kumaran: but if you kinda know, then it auto corrects like super fast.
281 00:27:40.010 ⇒ 00:27:45.129 Bo Yoon: Are you? You? You still want to see the the reviews dashboard. Now.
282 00:27:45.810 ⇒ 00:27:50.450 Robert Tseng: Yeah, you should. I’m just working in public, so you can do your thing.
283 00:27:52.000 ⇒ 00:27:58.599 Bo Yoon: Alright, yeah, it’s just the 2 graphs in the top of the Pdf file that you shared
284 00:27:59.340 ⇒ 00:28:02.370 Bo Yoon: the average rating by week.
285 00:28:03.940 ⇒ 00:28:09.180 Bo Yoon: And the other one was proven rejected graph
286 00:28:10.800 ⇒ 00:28:13.339 Bo Yoon: pending. Should I? Should I get rid of pending.
287 00:28:14.080 ⇒ 00:28:15.725 Uttam Kumaran: Yeah, I guess. Let me pull up
288 00:28:16.260 ⇒ 00:28:16.840 Bo Yoon: Hmm.
289 00:28:18.340 ⇒ 00:28:20.179 Uttam Kumaran: Let me pull this up in
290 00:28:26.980 ⇒ 00:28:27.929 Uttam Kumaran: these stuff.
291 00:28:28.520 ⇒ 00:28:31.529 Uttam Kumaran: Oh, you just have the 2. Okay, the 2 views.
292 00:28:33.210 ⇒ 00:28:37.540 Bo Yoon: Yeah, the the 2 views. And I was working on the on the next from the table. But
293 00:28:38.190 ⇒ 00:28:40.118 Bo Yoon: I’ll have to figure it out.
294 00:28:41.000 ⇒ 00:28:43.809 Uttam Kumaran: Yeah, I feel like average rating per week.
295 00:28:43.930 ⇒ 00:28:47.710 Uttam Kumaran: That’s fine reviews over time.
296 00:28:50.990 ⇒ 00:28:53.100 Uttam Kumaran: That’s also fine.
297 00:28:53.400 ⇒ 00:28:56.869 Uttam Kumaran: I think we like what other dimensionality is in there.
298 00:28:58.180 ⇒ 00:28:59.530 Bo Yoon: On on which one.
299 00:28:59.530 ⇒ 00:28:59.980 Uttam Kumaran: In.
300 00:28:59.980 ⇒ 00:29:00.750 Bo Yoon: On this one.
301 00:29:00.750 ⇒ 00:29:03.509 Uttam Kumaran: In general, like in the yeah, like.
302 00:29:03.950 ⇒ 00:29:09.310 Uttam Kumaran: what else can we cut this by? If you just click, you click here?
303 00:29:27.370 ⇒ 00:29:32.495 Uttam Kumaran: it would be good to cut it by like different.
304 00:29:34.510 ⇒ 00:29:36.790 Uttam Kumaran: yeah, it’d be cool to cut it by product.
305 00:29:36.960 ⇒ 00:29:39.740 Uttam Kumaran: I can also add the product category in here.
306 00:29:43.350 ⇒ 00:29:45.840 Uttam Kumaran: And then this, maybe we should be a bar or something.
307 00:29:47.280 ⇒ 00:29:49.990 Bo Yoon: Or did any? Is there no product at all?
308 00:29:51.720 ⇒ 00:29:52.740 Bo Yoon: A bar?
309 00:29:54.060 ⇒ 00:29:55.967 Bo Yoon: How do you make this? A bar?
310 00:29:59.830 ⇒ 00:30:00.640 Bo Yoon: Hmm!
311 00:30:01.240 ⇒ 00:30:01.770 Uttam Kumaran: Thank you.
312 00:30:01.770 ⇒ 00:30:04.859 Bo Yoon: Yeah, so very new to the event.
313 00:30:04.860 ⇒ 00:30:10.430 Uttam Kumaran: No, no, I know. I also don’t know. But it’s basically so it’s gotta be somewhere in here.
314 00:30:10.740 ⇒ 00:30:12.439 Bo Yoon: Yeah, it’s got to be somewhere.
315 00:30:12.900 ⇒ 00:30:13.610 Bo Yoon: Hmm.
316 00:30:15.870 ⇒ 00:30:18.150 Uttam Kumaran: Oh, yeah, okay, thank you.
317 00:30:19.710 ⇒ 00:30:23.360 Uttam Kumaran: Maybe it’s this that’s line.
318 00:30:26.350 ⇒ 00:30:27.340 Bo Yoon: Able.
319 00:30:31.270 ⇒ 00:30:33.360 Uttam Kumaran: Maybe it’s maybe it is an editor.
320 00:30:47.750 ⇒ 00:30:48.580 Bo Yoon: Oh!
321 00:31:10.200 ⇒ 00:31:15.869 Uttam Kumaran: Maybe you can’t. I don’t know, Jacob. Where do you know? Where? Where do we go to make to just like make this a bar.
322 00:31:16.666 ⇒ 00:31:21.407 Jakob Kagel: So sorry you’re in tub or no, you’re in meta base. Oh, go to
323 00:31:24.400 ⇒ 00:31:30.600 Jakob Kagel: There should be. It’s like at the bottom. Yeah. Visualization at the bottom there and then. Yeah, there.
324 00:31:30.600 ⇒ 00:31:31.450 Bo Yoon: Oh!
325 00:31:32.620 ⇒ 00:31:34.070 Jakob Kagel: Yeah. A bar.
326 00:31:39.170 ⇒ 00:31:41.050 Bo Yoon: Area for
327 00:32:01.150 ⇒ 00:32:05.849 Bo Yoon: it. Do, do you think a bar is okay? I think the line looks better.
328 00:32:07.160 ⇒ 00:32:14.240 Uttam Kumaran: Yeah, I guess I but I I think lines better. But I just wanna see it broken out.
329 00:32:16.796 ⇒ 00:32:17.489 Bo Yoon: By product.
330 00:32:17.550 ⇒ 00:32:18.640 Uttam Kumaran: My product.
331 00:32:20.990 ⇒ 00:32:21.850 Bo Yoon: Alright.
332 00:32:38.550 ⇒ 00:32:46.860 Bo Yoon: Jacob, do you know how to add a filter for products like another filter?
333 00:32:50.250 ⇒ 00:32:56.400 Uttam Kumaran: You click on show, editor. It should be here, but maybe it’s if it’s empty, then
334 00:32:58.420 ⇒ 00:33:01.100 Uttam Kumaran: I don’t know. Maybe there’s nothing in there.
335 00:33:02.370 ⇒ 00:33:08.840 Uttam Kumaran: I would just play around to see like what else we can cut it by. And then you can just throw everything into the dashboard. I mean
336 00:33:09.770 ⇒ 00:33:11.340 Uttam Kumaran: just to get something there
337 00:33:14.410 ⇒ 00:33:17.880 Uttam Kumaran: like we wanna see like total reviews this week.
338 00:33:20.050 ⇒ 00:33:23.580 Uttam Kumaran: This week, last week, this month, last month.
339 00:33:23.930 ⇒ 00:33:27.529 Uttam Kumaran: right? Like that sort of stuff percent changes anything like that.
340 00:33:27.840 ⇒ 00:33:30.100 Uttam Kumaran: It’s it’s totally fine.
341 00:33:30.100 ⇒ 00:33:32.850 Jakob Kagel: Sorry was I on mute just then when I was talking?
342 00:33:32.850 ⇒ 00:33:33.910 Jakob Kagel: Yes.
343 00:33:35.797 ⇒ 00:33:44.080 Jakob Kagel: but yeah, no, I think you got it. I mean, if you go into the editor. That’s like where you can do the different splits there.
344 00:33:44.190 ⇒ 00:33:53.150 Jakob Kagel: if that’s what you’re asking, or if you’re asking, I don’t know if you were asking. Like to overlay it. Kind of like how you do in tableau. Right? What are you trying to add? Product, name.
345 00:33:54.670 ⇒ 00:33:55.360 Bo Yoon: Yeah.
346 00:33:55.360 ⇒ 00:33:56.000 Jakob Kagel: Yeah.
347 00:33:57.410 ⇒ 00:34:04.380 Jakob Kagel: yeah, that should work. I mean, if you do it, I think you just if you just toggle exactly, maybe moving the order. But
348 00:34:04.500 ⇒ 00:34:06.190 Jakob Kagel: this should give you.
349 00:34:06.310 ⇒ 00:34:18.589 Jakob Kagel: because right now it’s just giving you status. Is that what it is? And it’s like, okay, do this, go to visualization. Go to this like the one. No like, show visualization where you were. Go to the bottom left there.
350 00:34:18.710 ⇒ 00:34:21.500 Jakob Kagel: Click on the settings. Yeah, click on that.
351 00:34:22.130 ⇒ 00:34:27.630 Jakob Kagel: Okay? So it looks like, add hit. Add another series there
352 00:34:28.820 ⇒ 00:34:31.730 Jakob Kagel: and then. Yeah, add pending is fine.
353 00:34:31.880 ⇒ 00:34:36.119 Jakob Kagel: but I know that’s just that. But it should show up there in the x-axis.
354 00:34:36.239 ⇒ 00:34:39.790 Jakob Kagel: That’s why it’s weird that it’s not showing up
355 00:34:40.040 ⇒ 00:34:41.810 Jakob Kagel: because it should be in there.
356 00:34:47.038 ⇒ 00:34:55.090 Jakob Kagel: cause. Normally, there is like, if you do have an extra value that you can add in there. Then you should. There would be an option to add it there
357 00:34:55.350 ⇒ 00:34:57.360 Jakob Kagel: like, if it is not showing up.
358 00:34:57.930 ⇒ 00:35:04.930 Jakob Kagel: So take out. Go to the editor real quick, and just take out a month real quick and just see if it comes back. Null.
359 00:35:05.910 ⇒ 00:35:07.739 Jakob Kagel: They just take it out. Yeah.
360 00:35:11.610 ⇒ 00:35:15.889 Jakob Kagel: Okay. So now, it’s showing by product name.
361 00:35:20.410 ⇒ 00:35:22.899 Jakob Kagel: that’s a weird visualization.
362 00:35:25.860 ⇒ 00:35:29.200 Bo Yoon: How how many products do they have this much.
363 00:35:29.200 ⇒ 00:35:31.430 Jakob Kagel: Only like 17 or something right.
364 00:35:31.430 ⇒ 00:35:33.099 Bo Yoon: Oh, there’s only like 17.
365 00:35:33.330 ⇒ 00:35:37.870 Jakob Kagel: Yeah, if you go to the editor real quick.
366 00:35:40.920 ⇒ 00:35:43.639 Bo Yoon: Yeah, I mean, that should.
367 00:35:43.910 ⇒ 00:35:46.740 Jakob Kagel: But I don’t know why it’s doing that. That’s really weird.
368 00:35:48.310 ⇒ 00:35:52.289 Jakob Kagel: Go to the table, view real quick, like, go to show visualization
369 00:35:52.610 ⇒ 00:35:58.019 Jakob Kagel: and then go to at the bottom in the bottom middle there, where it has the bars. Switch it to table.
370 00:35:59.510 ⇒ 00:36:12.059 Jakob Kagel: Okay? So status. So it’s like creating an individual line. It looks like for every single product name. Okay, there are a lot of product names here. So do we want to do product, name or product category, then.
371 00:36:13.571 ⇒ 00:36:21.610 Uttam Kumaran: Product, I think. Just leave it as product name. I’m gonna add product category to the table. I just sort of want to create a bunch of views in there that like
372 00:36:22.200 ⇒ 00:36:27.030 Uttam Kumaran: we can just ship something, you know, so sure.
373 00:36:27.030 ⇒ 00:36:32.389 Jakob Kagel: You can do product, name. You can order it by the count, and then you can like limit to like the top 10.
374 00:36:33.300 ⇒ 00:36:34.210 Uttam Kumaran: Perfect.
375 00:36:34.210 ⇒ 00:36:34.930 Jakob Kagel: Yeah.
376 00:36:35.850 ⇒ 00:36:40.760 Jakob Kagel: So if you want to do that, yeah, exactly. And then if you go into the editor like.
377 00:36:40.760 ⇒ 00:36:41.330 Jakob Kagel: order it.
378 00:36:41.330 ⇒ 00:36:41.890 Bo Yoon: And.
379 00:36:42.610 ⇒ 00:36:44.251 Jakob Kagel: Then you can just do
380 00:36:45.290 ⇒ 00:36:50.099 Jakob Kagel: yeah, at the bottom. There should be row limit. Yeah, click on row limit there.
381 00:36:51.040 ⇒ 00:36:55.600 Jakob Kagel: right? And then just hit like 25, or something or 10. Whatever you want to do, it doesn’t matter.
382 00:36:55.650 ⇒ 00:36:56.680 Bo Yoon: Okay.
383 00:36:57.180 ⇒ 00:37:00.730 Jakob Kagel: And then it’ll just give you the top. Yeah, the top ones. Yeah.
384 00:37:02.380 ⇒ 00:37:08.849 Jakob Kagel: And now you could add back in the if you wanted to do it by month instead. I think bars probably best here.
385 00:37:12.680 ⇒ 00:37:17.319 Bo Yoon: Or and then we can add the months.
386 00:37:18.120 ⇒ 00:37:18.760 Jakob Kagel: Right.
387 00:37:18.760 ⇒ 00:37:19.490 Bo Yoon: Back.
388 00:37:23.570 ⇒ 00:37:28.120 Jakob Kagel: But yeah, I would just limit it. To like the last 12 months is normally what I would do.
389 00:37:32.380 ⇒ 00:37:33.930 Jakob Kagel: You can do it in
390 00:37:37.950 ⇒ 00:37:44.310 Jakob Kagel: I normally just do it in the editor if you go to show editor and then click on filter.
391 00:37:44.710 ⇒ 00:37:52.289 Jakob Kagel: Not there, that’s fine, but the purple like the purple filter at the bottom, and then you can do date created.
392 00:37:52.600 ⇒ 00:37:55.019 Jakob Kagel: and then you can do their last 12 months.
393 00:37:55.020 ⇒ 00:37:56.730 Bo Yoon: Oh, okay.
394 00:37:56.730 ⇒ 00:37:59.441 Jakob Kagel: No worries. Tableau is way better, I mean.
395 00:37:59.780 ⇒ 00:38:01.980 Bo Yoon: Oh, why is this?
396 00:38:03.560 ⇒ 00:38:08.609 Bo Yoon: Yeah, it’s making weird.
397 00:38:09.170 ⇒ 00:38:13.759 Jakob Kagel: Okay, so it looks like they don’t have any tickets, or what for like 5 months, basically.
398 00:38:16.250 ⇒ 00:38:16.890 Bo Yoon: Hmm.
399 00:38:29.420 ⇒ 00:38:31.610 Uttam Kumaran: I mean. But dude, this is so far in the past
400 00:38:33.740 ⇒ 00:38:36.819 Uttam Kumaran: like this is October 24.th
401 00:38:42.390 ⇒ 00:38:42.990 Jakob Kagel: Right.
402 00:38:42.990 ⇒ 00:38:47.370 Robert Tseng: So we turned off data for like a few months, while we were not active with them.
403 00:38:49.720 ⇒ 00:38:51.580 Uttam Kumaran: Oh, shit. You’re right.
404 00:38:51.580 ⇒ 00:38:52.250 Uttam Kumaran: Yeah.
405 00:38:52.250 ⇒ 00:38:52.850 Uttam Kumaran: Oh, okay.
406 00:38:53.020 ⇒ 00:38:56.089 Jakob Kagel: April, though, is the last one they had tickets for right.
407 00:38:56.090 ⇒ 00:38:57.190 Uttam Kumaran: Alright, just.
408 00:38:57.635 ⇒ 00:39:02.670 Robert Tseng: Didn’t arrange it in in a date order. I think maybe.
409 00:39:04.100 ⇒ 00:39:09.809 Uttam Kumaran: Yeah, but it’s oh, but it’s role limit 20 meaning if the top 20 may not be in that.
410 00:39:10.120 ⇒ 00:39:10.430 Robert Tseng: Yeah.
411 00:39:11.560 ⇒ 00:39:13.960 Jakob Kagel: Right. You can take that out exactly.
412 00:39:14.200 ⇒ 00:39:17.019 Uttam Kumaran: Well, it’s gonna you’re just gonna yeah.
413 00:39:18.830 ⇒ 00:39:20.260 Bo Yoon: Oh, yeah, we’ve seen.
414 00:39:21.160 ⇒ 00:39:27.309 Uttam Kumaran: I mean, just cut. Yeah, just cut the just cut the date off like last 12 months.
415 00:39:28.260 ⇒ 00:39:29.480 Uttam Kumaran: And
416 00:39:29.950 ⇒ 00:39:43.179 Uttam Kumaran: yeah, I don’t know. I I knew there was gonna be some stuff not in here. So just toss in a bunch of just literally just toss in a bunch of stuff. And then I just wanna have something here because I want to talk. Talk to him about it tomorrow.
417 00:39:44.610 ⇒ 00:39:47.580 Bo Yoon: Okay. The product name just disappeared as well.
418 00:39:48.010 ⇒ 00:39:48.780 Bo Yoon: And.
419 00:39:51.300 ⇒ 00:39:53.030 Jakob Kagel: Yeah, this is real. Quick is.
420 00:39:54.550 ⇒ 00:40:01.070 Jakob Kagel: Okay, go back to the visualization show visualization. Okay?
421 00:40:01.650 ⇒ 00:40:06.380 Jakob Kagel: And so there’s no product name. Go to the bottom left that visualization one. Yeah.
422 00:40:07.380 ⇒ 00:40:08.350 Jakob Kagel: Hmm!
423 00:40:09.590 ⇒ 00:40:11.970 Jakob Kagel: That’s weird. Why does it do that?
424 00:40:16.460 ⇒ 00:40:19.939 Jakob Kagel: Because you should be able to add it like on the X-axis.
425 00:40:21.060 ⇒ 00:40:23.350 Uttam Kumaran: Maybe you can’t do by 3 dimensions.
426 00:40:26.910 ⇒ 00:40:34.980 Uttam Kumaran: Well, what is status? Just get rid of status and just have add another series. What is that series within status.
427 00:40:34.980 ⇒ 00:40:36.320 Jakob Kagel: It’s gonna be serious within stuff.
428 00:40:36.320 ⇒ 00:40:40.670 Uttam Kumaran: Oh, product. So you can change. So change status of it to product. Name.
429 00:40:44.090 ⇒ 00:40:48.189 Uttam Kumaran: yeah, okay, so I’ll get you category.
430 00:40:49.920 ⇒ 00:40:50.670 Bo Yoon: Okay.
431 00:40:51.820 ⇒ 00:40:52.240 Uttam Kumaran: But just.
432 00:40:52.240 ⇒ 00:40:56.320 Bo Yoon: So. So I guess we’ll just have to make 2 separate different.
433 00:40:56.690 ⇒ 00:41:06.720 Uttam Kumaran: Well, just I just I I guess what I’m saying is, just throw a bunch of these in there. Don’t worry if they look great or not. But just like I want to have a dashboard that shows
434 00:41:07.250 ⇒ 00:41:12.060 Uttam Kumaran: that shows them an overview of there.
435 00:41:13.750 ⇒ 00:41:14.660 Uttam Kumaran: Reviews.
436 00:41:15.000 ⇒ 00:41:23.629 Uttam Kumaran: Right? So one suggestion is, take a second and look at the data and think about like 5 or 7 views that would help them. Just give them an overview.
437 00:41:24.209 ⇒ 00:41:34.100 Uttam Kumaran: Right? They probably wanna look at what are the average reviews which products are getting the most released? They probably want to look at like changes, week over week, month over month.
438 00:41:34.340 ⇒ 00:41:38.200 Uttam Kumaran: Right? So take a little bit of creative control, and then just
439 00:41:38.540 ⇒ 00:41:46.829 Uttam Kumaran: give it a go, and then let me know what you don’t need like. A perfect thing is like, Okay, we can’t. We shouldn’t aggregate on name. We should aggregate category
440 00:41:47.691 ⇒ 00:41:50.180 Uttam Kumaran: and I can start bringing that stuff in.
441 00:41:51.330 ⇒ 00:41:55.379 Uttam Kumaran: So just throw a couple of things in there and then we can. We can iterate from there.
442 00:41:56.790 ⇒ 00:42:00.810 Bo Yoon: Oh, yeah, okay, that’s good.
443 00:42:03.500 ⇒ 00:42:10.809 Uttam Kumaran: Chatgpt is your friend, by the way, so I would you could even just throw in all the and basically throw in all the tables Emos.
444 00:42:11.320 ⇒ 00:42:13.700 Bo Yoon: You can. It’ll probably just give you like.
445 00:42:14.830 ⇒ 00:42:16.689 Uttam Kumaran: And ideas about what you can do.
446 00:42:17.450 ⇒ 00:42:19.129 Bo Yoon: Okay. Sounds good.
447 00:42:20.530 ⇒ 00:42:22.710 Uttam Kumaran: Okay, guys, I gotta hop.
448 00:42:23.740 ⇒ 00:42:24.300 Bo Yoon: Yep.
449 00:42:25.407 ⇒ 00:42:29.400 Uttam Kumaran: So I’m gonna keep. I’ll keep. I’ll fix the age thing here soon.
450 00:42:30.540 ⇒ 00:42:32.200 Bo Yoon: Okay. Yeah. Sounds good.
451 00:42:33.220 ⇒ 00:42:34.370 Jakob Kagel: Thank you.
452 00:42:34.520 ⇒ 00:42:35.250 Bo Yoon: Yeah.
453 00:42:35.450 ⇒ 00:42:36.920 Bo Yoon: Thank you. Bye.