Meeting Title: Shopify Analysis Slide Edits Review Date: 2025-12-01 Meeting participants: Amber Lin, Henry Zhao
WEBVTT
1 00:06:27.740 ⇒ 00:06:28.770 Henry Zhao: Hello.
2 00:06:31.200 ⇒ 00:06:32.070 Amber Lin: Hi there!
3 00:06:34.480 ⇒ 00:06:42.520 Henry Zhao: Cool, so the slides should be easy to edit, because they’re all just copied from that Excel, so I just need… you can just change things in Excel, and it should also update in the slides.
4 00:06:42.670 ⇒ 00:06:44.710 Amber Lin: Okay, sounds good.
5 00:06:45.000 ⇒ 00:06:52.059 Amber Lin: Hmm… Yeah, let’s start from… do you want to share screen, and we can go through them?
6 00:06:55.550 ⇒ 00:06:56.510 Henry Zhao: Second.
7 00:07:16.420 ⇒ 00:07:17.999 Henry Zhao: Hmm, do you know which one it was?
8 00:07:18.370 ⇒ 00:07:19.180 Henry Zhao: Interesting.
9 00:07:21.070 ⇒ 00:07:21.880 Henry Zhao: Nope.
10 00:07:22.480 ⇒ 00:07:23.620 Henry Zhao: Delete this…
11 00:07:29.150 ⇒ 00:07:29.930 Henry Zhao: Nope.
12 00:07:34.170 ⇒ 00:07:35.650 Henry Zhao: Is this the live one?
13 00:07:37.100 ⇒ 00:07:45.829 Amber Lin: No, not this one. The one we worked on last time, so the Shopify analysis.
14 00:07:46.920 ⇒ 00:07:48.780 Amber Lin: Can you send me the updated link?
15 00:08:00.180 ⇒ 00:08:01.980 Amber Lin: Yeah, in the Zoom chat.
16 00:08:06.390 ⇒ 00:08:07.779 Henry Zhao: Okay, these are the ones we need to edit?
17 00:08:11.680 ⇒ 00:08:17.520 Amber Lin: go… yeah, let’s look at Robert’s comments.
18 00:08:36.020 ⇒ 00:08:37.610 Henry Zhao: Default? But yeah, okay.
19 00:08:42.110 ⇒ 00:08:44.219 Henry Zhao: Need to reference where the data is coming from.
20 00:08:48.890 ⇒ 00:08:51.020 Henry Zhao: Need to reference where the data’s coming from.
21 00:08:52.920 ⇒ 00:08:57.599 Amber Lin: And guess which table we used, for that specific graph.
22 00:08:58.830 ⇒ 00:09:00.110 Henry Zhao: Do we need to do that?
23 00:09:00.690 ⇒ 00:09:05.319 Amber Lin: In the methods… In the methods and key assumptions.
24 00:09:08.870 ⇒ 00:09:09.670 Henry Zhao: Okay.
25 00:09:11.300 ⇒ 00:09:14.189 Amber Lin: We would just say we used the orders table, right?
26 00:09:15.770 ⇒ 00:09:18.600 Amber Lin: Yeah, so that… that’s all we need.
27 00:09:19.150 ⇒ 00:09:24.030 Amber Lin: And then… need to change the axes…
28 00:09:24.420 ⇒ 00:09:28.189 Amber Lin: And then the… I guess the title as well.
29 00:09:29.680 ⇒ 00:09:30.450 Henry Zhao: Okay?
30 00:09:42.630 ⇒ 00:09:44.599 Henry Zhao: You said it just got rid of not… is not significant?
31 00:09:47.430 ⇒ 00:09:53.760 Amber Lin: We would just… I think we would just say Shopify… Or weekly orders over time.
32 00:09:58.410 ⇒ 00:09:59.060 Henry Zhao: Like that?
33 00:10:00.540 ⇒ 00:10:02.420 Amber Lin: Yeah.
34 00:10:15.520 ⇒ 00:10:18.160 Henry Zhao: Pino doesn’t let you put K afterwards.
35 00:10:22.570 ⇒ 00:10:23.430 Amber Lin: Hmm…
36 00:10:26.850 ⇒ 00:10:31.110 Amber Lin: I suppose we have to divide it manually.
37 00:10:31.950 ⇒ 00:10:33.739 Amber Lin: If they don’t let us.
38 00:10:34.190 ⇒ 00:10:35.560 Henry Zhao: I think we can just do it this way.
39 00:10:38.720 ⇒ 00:10:40.339 Amber Lin: Oh, great.
40 00:10:40.520 ⇒ 00:10:41.840 Amber Lin: Well, that’s so cool.
41 00:10:41.980 ⇒ 00:10:44.290 Henry Zhao: Except for the zero, that’s annoying. Ugh, hold on.
42 00:10:47.760 ⇒ 00:10:48.710 Henry Zhao: The heck?
43 00:10:54.760 ⇒ 00:10:57.109 Henry Zhao: Why is… huh?
44 00:11:00.400 ⇒ 00:11:01.330 Henry Zhao: What the heck?
45 00:11:10.020 ⇒ 00:11:11.380 Henry Zhao: I know, I know.
46 00:11:17.820 ⇒ 00:11:18.530 Henry Zhao: Done.
47 00:11:20.470 ⇒ 00:11:21.799 Henry Zhao: I don’t know why that works, but…
48 00:11:24.800 ⇒ 00:11:25.590 Amber Lin: Okay.
49 00:11:25.970 ⇒ 00:11:27.920 Amber Lin: What else did he say?
50 00:11:28.290 ⇒ 00:11:31.010 Amber Lin: Oh, I guess the legend.
51 00:11:33.400 ⇒ 00:11:34.080 Henry Zhao: What about the legend?
52 00:11:34.080 ⇒ 00:11:37.570 Amber Lin: Well, I would… I guess the…
53 00:11:37.690 ⇒ 00:11:44.410 Amber Lin: you know, the two lines of total USD of Shopify orders. We could call that… I guess we could call that.
54 00:11:44.640 ⇒ 00:11:49.920 Amber Lin: Shopify sales… total revenue… total sales?
55 00:11:50.870 ⇒ 00:11:55.580 Amber Lin: Like… Total sales, and we can add in…
56 00:12:03.550 ⇒ 00:12:04.610 Amber Lin: And.
57 00:12:04.610 ⇒ 00:12:05.759 Henry Zhao: Who’s it even getting it from?
58 00:12:07.390 ⇒ 00:12:08.530 Henry Zhao: Where’s he even getting it from?
59 00:12:12.960 ⇒ 00:12:21.450 Amber Lin: Let’s see… custom… probably in custom… oh, not that one. Customized? And then… Legend.
60 00:12:21.650 ⇒ 00:12:22.850 Amber Lin: Most likely.
61 00:12:23.050 ⇒ 00:12:24.950 Henry Zhao: I think it’s serious, serious. Yeah.
62 00:12:27.200 ⇒ 00:12:29.300 Amber Lin: Oh, how do we rename that?
63 00:12:33.980 ⇒ 00:12:35.119 Henry Zhao: Alright, let’s click, click it.
64 00:12:35.570 ⇒ 00:12:37.219 Amber Lin: Oh, I see.
65 00:12:37.220 ⇒ 00:12:41.169 Henry Zhao: Total sales in USD? What do you want to say?
66 00:12:41.170 ⇒ 00:12:43.850 Amber Lin: We can just… you can just say… yeah.
67 00:12:46.740 ⇒ 00:12:47.339 Amber Lin: And then…
68 00:12:47.340 ⇒ 00:12:47.670 Henry Zhao: Yep.
69 00:12:47.670 ⇒ 00:12:50.270 Amber Lin: How do we talk about the line?
70 00:12:51.620 ⇒ 00:12:56.040 Amber Lin: Could we just say slope equals $5.32?
71 00:12:57.520 ⇒ 00:12:59.239 Amber Lin: I just… I can do that.
72 00:13:02.290 ⇒ 00:13:03.040 Henry Zhao: Just like that.
73 00:13:03.360 ⇒ 00:13:05.610 Amber Lin: Yeah. Okay, that makes more sense.
74 00:13:06.460 ⇒ 00:13:07.420 Henry Zhao: You think so? Okay.
75 00:13:13.270 ⇒ 00:13:13.880 Amber Lin: Cool.
76 00:13:13.910 ⇒ 00:13:14.759 Henry Zhao: I should make these bigger.
77 00:13:27.690 ⇒ 00:13:29.239 Amber Lin: Right? This music’s better, right?
78 00:13:29.510 ⇒ 00:13:30.020 Henry Zhao: Yeah.
79 00:13:30.020 ⇒ 00:13:30.800 Amber Lin: I agree.
80 00:13:31.860 ⇒ 00:13:33.490 Henry Zhao: Otherwise, in the slides, it’s really small.
81 00:13:38.920 ⇒ 00:13:44.510 Henry Zhao: Well, was there a guide for what we needed to… Nope.
82 00:13:57.240 ⇒ 00:13:58.430 Henry Zhao: 1824.
83 00:14:01.380 ⇒ 00:14:02.890 Henry Zhao: It just needs to be 18, then.
84 00:14:06.750 ⇒ 00:14:08.469 Henry Zhao: Then maybe we can make this 24.
85 00:14:09.420 ⇒ 00:14:10.730 Henry Zhao: This is fine, I think.
86 00:14:12.240 ⇒ 00:14:14.919 Henry Zhao: He’ll give us, he’ll give us the feedback if he doesn’t think it’s fine.
87 00:14:16.540 ⇒ 00:14:17.920 Henry Zhao: Okay, this one we’re not showing?
88 00:14:19.060 ⇒ 00:14:20.279 Henry Zhao: Let’s see if there’s any other comments.
89 00:14:20.280 ⇒ 00:14:22.429 Amber Lin: What do you say?
90 00:14:26.630 ⇒ 00:14:29.589 Amber Lin: I think the first one is resolved, you can resolve it.
91 00:14:29.620 ⇒ 00:14:33.019 Henry Zhao: Let’s say slide 4, what is he saying?
92 00:14:34.010 ⇒ 00:14:40.569 Amber Lin: Ignore my comments. He said… okay, I’m looking at repeats, so… okay.
93 00:14:40.570 ⇒ 00:14:41.899 Henry Zhao: Cause your video’s really bad.
94 00:14:42.300 ⇒ 00:14:43.539 Henry Zhao: I don’t know if you saw it.
95 00:14:44.750 ⇒ 00:14:46.820 Henry Zhao: Year-over-year was really bad, I don’t know if you saw it.
96 00:14:47.280 ⇒ 00:14:55.299 Amber Lin: Yeah, can we… can you give me the year-over-year numbers? I’m gonna make a… I’m just gonna add a table. Like, we don’t have to put it in the.
97 00:14:55.300 ⇒ 00:14:55.950 Henry Zhao: It’s already in there.
98 00:14:55.950 ⇒ 00:14:57.469 Amber Lin: You can put the table.
99 00:14:57.650 ⇒ 00:14:58.599 Henry Zhao: It’s already in there.
100 00:14:59.010 ⇒ 00:15:01.709 Henry Zhao: Yeah, just here over here. This is very nonsensical.
101 00:15:03.090 ⇒ 00:15:04.209 Henry Zhao: All over the place.
102 00:15:04.410 ⇒ 00:15:07.360 Amber Lin: Is there a year-over-year sales?
103 00:15:07.780 ⇒ 00:15:11.469 Amber Lin: like, last year’s sales, I know we queried that.
104 00:15:11.870 ⇒ 00:15:21.450 Amber Lin: So, like, 2023 sales, 2024, like, what’s the total sales numbers? I know we… I think we queried it on Mother Duck?
105 00:15:23.940 ⇒ 00:15:26.550 Henry Zhao: We have a… Here, here, Rio.
106 00:15:28.020 ⇒ 00:15:29.280 Henry Zhao: Do you want to see that?
107 00:15:29.560 ⇒ 00:15:36.730 Amber Lin: Yeah, because I will put it in the… I’m gonna put it in the table. Can you copy that table for me, or…
108 00:15:37.350 ⇒ 00:15:38.690 Henry Zhao: Oh, you’re resending nothing.
109 00:15:39.940 ⇒ 00:15:44.510 Amber Lin: Yeah, I think that will help give them… A good idea.
110 00:15:44.660 ⇒ 00:15:45.280 Amber Lin: I was…
111 00:15:45.280 ⇒ 00:15:47.330 Henry Zhao: Well, it’s not really sensical, though.
112 00:15:48.520 ⇒ 00:15:52.919 Henry Zhao: Because there’s only 3 years of data, so this one is, like, what’s actually making things go up.
113 00:15:54.620 ⇒ 00:15:59.640 Amber Lin: Yeah, I’m not gonna do the… yeah, I’m not gonna do the…
114 00:16:00.040 ⇒ 00:16:04.740 Amber Lin: I’m just gonna copy and paste this table, like, I’m not gonna do the percentage growth.
115 00:16:05.450 ⇒ 00:16:08.090 Amber Lin: Yeah, you can… Oh, okay.
116 00:16:08.090 ⇒ 00:16:10.229 Henry Zhao: What? Do you want me to copy and paste it, or do you want to just grab it from here?
117 00:16:10.730 ⇒ 00:16:17.770 Amber Lin: Yeah, can you copy and paste it? I’ll make you a… I’ll make you a table, and then we can paste it into it.
118 00:16:18.980 ⇒ 00:16:20.919 Amber Lin: Let me go find a table.
119 00:16:24.450 ⇒ 00:16:26.720 Amber Lin: Oh, I’m also meeting with Robert.
120 00:16:26.930 ⇒ 00:16:30.899 Amber Lin: Soon, so I might have to hop in, like, 5 minutes, but yeah.
121 00:16:30.900 ⇒ 00:16:32.519 Henry Zhao: Yeah, you can just get his feedback on this.
122 00:16:32.520 ⇒ 00:16:34.750 Amber Lin: Yeah, we have most of it.
123 00:16:36.060 ⇒ 00:16:37.389 Amber Lin: Yeah, okay.
124 00:16:37.990 ⇒ 00:16:39.740 Henry Zhao: Slide…
125 00:16:40.090 ⇒ 00:16:46.540 Amber Lin: Before he does have comments. Slide 5…
126 00:16:46.880 ⇒ 00:16:50.279 Amber Lin: Okay, he’s good with 55. Okay, slide…
127 00:16:50.760 ⇒ 00:16:56.639 Amber Lin: 7. Slide 7, he says, smooth these curves. I agree, it is a little bit wonky.
128 00:16:56.640 ⇒ 00:16:57.850 Henry Zhao: Where I offered that?
129 00:16:57.850 ⇒ 00:17:03.290 Amber Lin: I’m sorry, it’s my bad, I… no, I think we… we said Robert’s not gonna like this.
130 00:17:03.290 ⇒ 00:17:05.170 Henry Zhao: Yeah, no, that’s what I was… I just messed it, because that’s funny.
131 00:17:07.700 ⇒ 00:17:14.129 Amber Lin: Okay, so he has a few questions. Traffic to Shopify… okay, I’m gonna say…
132 00:17:14.329 ⇒ 00:17:22.830 Amber Lin: traffic to Shopify. Yeah, is this, like… Shopify website visitors?
133 00:17:24.040 ⇒ 00:17:25.420 Henry Zhao: Where? This one?
134 00:17:25.420 ⇒ 00:17:26.840 Amber Lin: Yeah, slide 7.
135 00:17:27.420 ⇒ 00:17:28.640 Henry Zhao: Yeah, it should be, because it’s cloud.
136 00:17:28.640 ⇒ 00:17:31.350 Amber Lin: Okay, I’m gonna resolve his comments there.
137 00:17:31.630 ⇒ 00:17:32.769 Henry Zhao: Cool from Klaviyo.
138 00:17:32.770 ⇒ 00:17:44.250 Amber Lin: Okay. Data pull… From Claivio… I don’t think I spelled that correctly. And then…
139 00:17:45.040 ⇒ 00:17:50.089 Amber Lin: How do you… he asked, how do you know this is driven by Amazon buyers?
140 00:17:52.090 ⇒ 00:17:53.780 Amber Lin: We don’t know, actually.
141 00:17:54.160 ⇒ 00:17:57.060 Amber Lin: Yeah. I just made a… I said, could be.
142 00:17:57.090 ⇒ 00:17:58.920 Henry Zhao: Indeed.
143 00:17:58.920 ⇒ 00:17:59.620 Amber Lin: Okay.
144 00:18:03.610 ⇒ 00:18:06.420 Henry Zhao: Take a 2-week, 4-week rolling average. That works.
145 00:18:08.610 ⇒ 00:18:11.710 Amber Lin: Oh, whoa, that looks smoother.
146 00:18:12.080 ⇒ 00:18:14.869 Henry Zhao: Looks smoother, but I think he wants us to do the 2-4 week rolling average.
147 00:18:14.870 ⇒ 00:18:15.590 Amber Lin: Okay.
148 00:18:15.930 ⇒ 00:18:16.550 Henry Zhao: Right?
149 00:18:18.060 ⇒ 00:18:19.279 Amber Lin: How will we do that?
150 00:18:20.560 ⇒ 00:18:21.740 Henry Zhao: You’d have to calculate it.
151 00:18:21.760 ⇒ 00:18:22.420 Amber Lin: Okay.
152 00:18:48.110 ⇒ 00:18:49.820 Henry Zhao: Why’d just do that?
153 00:19:39.920 ⇒ 00:19:41.320 Henry Zhao: This is months anyway.
154 00:19:46.810 ⇒ 00:19:47.780 Henry Zhao: This month’s?
155 00:19:47.970 ⇒ 00:19:48.650 Henry Zhao: Yeah.
156 00:19:51.230 ⇒ 00:19:53.810 Amber Lin: What can we say?
157 00:19:57.520 ⇒ 00:20:00.040 Henry Zhao: Let’s look at the 2-month rolling average.
158 00:20:11.570 ⇒ 00:20:18.529 Henry Zhao: I don’t ever understand why a date that’s named month, a program would ever, ever, ever use it as, like, a line.
159 00:20:19.980 ⇒ 00:20:21.529 Henry Zhao: Like, that should be programmed into it.
160 00:20:22.410 ⇒ 00:20:22.920 Henry Zhao: And how often?
161 00:20:22.920 ⇒ 00:20:25.659 Amber Lin: But it happened last time, too, it was so funny.
162 00:20:31.280 ⇒ 00:20:35.200 Henry Zhao: Still looks freaky. I don’t know how I like this. This honestly scares me a little bit more.
163 00:20:36.330 ⇒ 00:20:37.610 Henry Zhao: That’s like a horror movie.
164 00:20:41.650 ⇒ 00:20:43.490 Amber Lin: Wait, where’s the conversion?
165 00:20:44.300 ⇒ 00:20:44.950 Henry Zhao: It’s… it’s low.
166 00:20:44.950 ⇒ 00:20:48.260 Amber Lin: Oh, because we did a different access for it, let me see.
167 00:20:49.270 ⇒ 00:20:50.410 Henry Zhao: It’s so annoying.
168 00:20:56.600 ⇒ 00:20:57.260 Henry Zhao: Hmm.
169 00:20:57.840 ⇒ 00:21:01.430 Henry Zhao: This… I don’t… I’m not happy with this, so…
170 00:21:06.510 ⇒ 00:21:08.260 Henry Zhao: Come on, man, this is so…
171 00:21:36.280 ⇒ 00:21:37.199 Henry Zhao: Oh my god.
172 00:21:41.480 ⇒ 00:21:42.900 Henry Zhao: This looks the opposite.
173 00:21:43.860 ⇒ 00:21:45.680 Henry Zhao: So it’s actually going down.
174 00:21:46.500 ⇒ 00:21:47.319 Amber Lin: Which one?
175 00:21:49.050 ⇒ 00:21:52.219 Henry Zhao: What the heck? Alright, I’m gonna… I screw this, and just…
176 00:21:53.610 ⇒ 00:21:57.529 Amber Lin: Okay, I will have to hop, let me know how that goes.
177 00:21:58.280 ⇒ 00:21:59.040 Henry Zhao: Okay.
178 00:21:59.260 ⇒ 00:21:59.900 Amber Lin: Okay.
179 00:22:00.590 ⇒ 00:22:01.270 Henry Zhao: See you later.
180 00:22:01.290 ⇒ 00:22:02.010 Amber Lin: Yeah.
181 00:22:03.470 ⇒ 00:22:05.670 Amber Lin: Hey, that should be all the graphs were…
182 00:22:06.360 ⇒ 00:22:11.129 Amber Lin: Oh, and then he has another comment on slide 8 about revenue provision.
183 00:22:11.410 ⇒ 00:22:12.070 Henry Zhao: Okay.
184 00:22:12.070 ⇒ 00:22:12.879 Amber Lin: Let me know.
185 00:22:16.100 ⇒ 00:22:16.870 Henry Zhao: Enjoy.
186 00:22:17.890 ⇒ 00:22:18.770 Amber Lin: Talk to you later.