Meeting Title: Rill-Dashboards-Review Date: 2024-09-16 Meeting participants: Ryan Luke Daque, Nicolas Sucari, Uttam Kumaran
WEBVTT
1 00:01:50.660 ⇒ 00:01:51.479 Nicolas Sucari: Hey, Ryan.
2 00:01:54.240 ⇒ 00:01:55.150 Ryan Luke Daque: Hi. Nicholas.
3 00:03:05.710 ⇒ 00:03:08.429 Nicolas Sucari: Were you able to find anything else on the
4 00:03:09.713 ⇒ 00:03:11.040 Nicolas Sucari: Google ads.
5 00:03:12.710 ⇒ 00:03:19.047 Ryan Luke Daque: Yeah, I found the issue. But I’m still like investigation investigating what’s causing it?
6 00:03:22.160 ⇒ 00:03:26.172 Ryan Luke Daque: I don’t know. I can. I can show you. It’s easier, probably, to show it.
7 00:03:27.680 ⇒ 00:03:32.489 Nicolas Sucari: Something that we are like the report that we’re receiving. It’s not matching the data.
8 00:03:32.490 ⇒ 00:03:33.420 Ryan Luke Daque: The
9 00:03:34.660 ⇒ 00:03:36.469 Ryan Luke Daque: Yeah, but it’s
10 00:03:36.820 ⇒ 00:03:38.839 Ryan Luke Daque: it’s most. I think it’s
11 00:03:39.010 ⇒ 00:03:43.009 Ryan Luke Daque: 5 grand, but I’m not sure yet. That’s what I’m trying to investigate. So
12 00:03:43.190 ⇒ 00:03:43.959 Ryan Luke Daque: if we.
13 00:03:43.960 ⇒ 00:03:44.640 Nicolas Sucari: Yeah.
14 00:03:44.640 ⇒ 00:03:48.150 Ryan Luke Daque: So for for Google ads, can you see my screen? By the way.
15 00:03:48.530 ⇒ 00:03:49.300 Nicolas Sucari: Yes, yes.
16 00:03:49.300 ⇒ 00:03:51.913 Ryan Luke Daque: Blue ads, we have we have different
17 00:03:52.510 ⇒ 00:03:57.270 Ryan Luke Daque: stat levels, right? As like, add, we have add stats. This stats.
18 00:03:57.270 ⇒ 00:03:58.020 Nicolas Sucari: Yeah.
19 00:03:58.220 ⇒ 00:04:01.210 Ryan Luke Daque: We have ad group stats. And we have like campaign
20 00:04:01.470 ⇒ 00:04:02.810 Ryan Luke Daque: stats.
21 00:04:02.870 ⇒ 00:04:04.010 Ryan Luke Daque: basically.
22 00:04:04.270 ⇒ 00:04:05.040 Ryan Luke Daque: But so.
23 00:04:05.040 ⇒ 00:04:05.380 Nicolas Sucari: Okay.
24 00:04:05.380 ⇒ 00:04:08.540 Ryan Luke Daque: If if we do a query on ad stats.
25 00:04:09.850 ⇒ 00:04:11.720 Ryan Luke Daque: which is this one
26 00:04:12.730 ⇒ 00:04:19.259 Ryan Luke Daque: we can see like for August, for example, cause that was the issue right? I mean, that was what came.
27 00:04:19.260 ⇒ 00:04:20.930 Nicolas Sucari: Yeah. Yeah. What? Kim shared?
28 00:04:20.930 ⇒ 00:04:23.830 Ryan Luke Daque: Yeah, it’s only showing 18 conversions, and like.
29 00:04:24.500 ⇒ 00:04:26.180 Ryan Luke Daque: which is 11,000
30 00:04:26.340 ⇒ 00:04:27.750 Ryan Luke Daque: conversion value.
31 00:04:28.040 ⇒ 00:04:32.839 Ryan Luke Daque: which is pretty low compared to like what Kim was looking at.
32 00:04:32.840 ⇒ 00:04:33.270 Nicolas Sucari: Yeah.
33 00:04:34.240 ⇒ 00:04:37.950 Ryan Luke Daque: which was like something something around 200 and and 100.
34 00:04:37.950 ⇒ 00:04:40.430 Nicolas Sucari: Kim said, it’s 200 and yeah, 200.
35 00:04:40.430 ⇒ 00:04:40.880 Ryan Luke Daque: Yeah.
36 00:04:41.485 ⇒ 00:04:42.070 Nicolas Sucari: Conversions.
37 00:04:42.280 ⇒ 00:04:44.560 Nicolas Sucari: So maybe it’s not at the ad level.
38 00:04:46.070 ⇒ 00:04:55.400 Ryan Luke Daque: Yeah. So if I go to campaign. Because I did look at Kim screenshot, she was looking at campaign stats. So if we do campaign stats. Oh, wait!
39 00:04:58.060 ⇒ 00:04:59.979 Ryan Luke Daque: I do this.
40 00:05:01.310 ⇒ 00:05:02.669 Ryan Luke Daque: What happened here?
41 00:05:06.200 ⇒ 00:05:09.160 Ryan Luke Daque: We actually see the correct number.
42 00:05:09.390 ⇒ 00:05:10.510 Ryan Luke Daque: which is
43 00:05:11.130 ⇒ 00:05:12.310 Ryan Luke Daque: this, 1, 200.
44 00:05:12.310 ⇒ 00:05:13.620 Nicolas Sucari: Yeah, almost
45 00:05:13.780 ⇒ 00:05:14.480 Nicolas Sucari: excellent.
46 00:05:14.480 ⇒ 00:05:20.549 Ryan Luke Daque: It’s actually exactly the the number that she was looking at, 204.78 and 100
47 00:05:20.680 ⇒ 00:05:22.460 Ryan Luke Daque: 94,000 something.
48 00:05:22.460 ⇒ 00:05:25.940 Nicolas Sucari: The the image. It says 205, but that’s okay.
49 00:05:26.140 ⇒ 00:05:27.940 Ryan Luke Daque: Oh, yeah.
50 00:05:27.940 ⇒ 00:05:28.680 Nicolas Sucari: And it’s
51 00:05:28.830 ⇒ 00:05:36.620 Nicolas Sucari: it’s almost that. So that’s fine. And 194, 5, 61 is. Yes, there is some
52 00:05:36.720 ⇒ 00:05:39.149 Nicolas Sucari: something different, maybe because of the
53 00:05:39.380 ⇒ 00:05:41.030 Nicolas Sucari: time of the day.
54 00:05:43.890 ⇒ 00:05:46.159 Ryan Luke Daque: Oh, right! It’s 205.
55 00:05:46.620 ⇒ 00:05:48.420 Nicolas Sucari: Don’t, but don’t worry. I mean, it’s just.
56 00:05:48.420 ⇒ 00:05:49.480 Ryan Luke Daque: Yeah, like, we’re.
57 00:05:49.480 ⇒ 00:05:52.170 Nicolas Sucari: Almost. Maybe it’s a time
58 00:05:52.210 ⇒ 00:05:55.979 Nicolas Sucari: time zone issue, because, yeah, you’re
59 00:05:56.100 ⇒ 00:05:58.110 Nicolas Sucari: maybe sometimes that happens.
60 00:05:59.930 ⇒ 00:06:01.459 Ryan Luke Daque: But yeah, it’s it’s pretty.
61 00:06:01.460 ⇒ 00:06:02.610 Nicolas Sucari: Almost there. Yeah, it’s.
62 00:06:02.610 ⇒ 00:06:03.390 Ryan Luke Daque: Same, yet.
63 00:06:03.390 ⇒ 00:06:03.970 Nicolas Sucari: 3.
64 00:06:03.970 ⇒ 00:06:05.370 Ryan Luke Daque: So I did some.
65 00:06:05.370 ⇒ 00:06:05.910 Nicolas Sucari: Difference.
66 00:06:06.396 ⇒ 00:06:09.799 Ryan Luke Daque: Yeah, I did some further investigation. And
67 00:06:10.360 ⇒ 00:06:15.149 Ryan Luke Daque: so if I if we look at if I include the campaign Id
68 00:06:15.450 ⇒ 00:06:21.280 Ryan Luke Daque: in here. So and and let’s look at add stats, for example, for now.
69 00:06:30.130 ⇒ 00:06:33.709 Ryan Luke Daque: so in add stats we are for August.
70 00:06:33.780 ⇒ 00:06:39.390 Ryan Luke Daque: Let’s just filter this for. But yeah, for August. It’s just showing one campaign. Id.
71 00:06:39.390 ⇒ 00:06:40.870 Nicolas Sucari: One campaign. Yeah.
72 00:06:40.870 ⇒ 00:06:47.489 Ryan Luke Daque: For almost since February. It’s the same campaign Id, and only it’s only in January
73 00:06:48.330 ⇒ 00:06:56.170 Ryan Luke Daque: something like that. Yeah. But for August it’s just showing one. And it’s so showing 1818 and 11,700.
74 00:06:56.360 ⇒ 00:07:00.450 Ryan Luke Daque: So if I do that similar for ad stats.
75 00:07:01.180 ⇒ 00:07:02.930 Ryan Luke Daque: I mean campaign stats.
76 00:07:04.095 ⇒ 00:07:05.550 Ryan Luke Daque: You can actually.
77 00:07:05.550 ⇒ 00:07:09.435 Nicolas Sucari: The shortcut to comment something on Snowflake.
78 00:07:09.990 ⇒ 00:07:13.040 Ryan Luke Daque: Control and then backslash like this one.
79 00:07:13.040 ⇒ 00:07:13.720 Nicolas Sucari: Okay.
80 00:07:14.190 ⇒ 00:07:15.080 Nicolas Sucari: Okay.
81 00:07:15.940 ⇒ 00:07:19.420 Ryan Luke Daque: So you can see that. For August there’s actually
82 00:07:19.450 ⇒ 00:07:22.330 Ryan Luke Daque: 3 4 campaigns, right?
83 00:07:22.760 ⇒ 00:07:29.410 Ryan Luke Daque: If we if we’re looking at campaign stats. And this was the one that was showing up in Ad. Stats. So it looks like.
84 00:07:29.410 ⇒ 00:07:31.489 Nicolas Sucari: Okay. So the other ones are not showing up.
85 00:07:31.490 ⇒ 00:07:35.259 Ryan Luke Daque: Yeah, even in in September. The other ones aren’t showing up
86 00:07:35.280 ⇒ 00:07:40.330 Ryan Luke Daque: in in July, only these are showing up, except this was the only one showing up
87 00:07:40.600 ⇒ 00:07:41.929 Ryan Luke Daque: so it we don’t.
88 00:07:41.930 ⇒ 00:07:43.560 Nicolas Sucari: Have access to their Google
89 00:07:44.190 ⇒ 00:07:45.980 Nicolas Sucari: Google campaigns, to the right.
90 00:07:46.510 ⇒ 00:07:51.290 Ryan Luke Daque: I don’t think so, but I don’t know. Maybe let’s check. Oh.
91 00:07:52.290 ⇒ 00:07:54.569 Nicolas Sucari: I don’t think so. I don’t think either.
92 00:07:54.810 ⇒ 00:07:55.650 Ryan Luke Daque: Yeah. But
93 00:07:56.010 ⇒ 00:07:59.439 Ryan Luke Daque: so that’s why I’m thinking, maybe it has
94 00:08:00.100 ⇒ 00:08:01.110 Ryan Luke Daque: something to.
95 00:08:01.110 ⇒ 00:08:02.800 Nicolas Sucari: Something to do on cyber chat. Yeah.
96 00:08:02.800 ⇒ 00:08:03.900 Ryan Luke Daque: 5 trend.
97 00:08:04.180 ⇒ 00:08:07.969 Ryan Luke Daque: But yeah, that’s what I’m trying to figure out at the moment.
98 00:08:09.850 ⇒ 00:08:10.545 Ryan Luke Daque: Cause
99 00:08:13.100 ⇒ 00:08:15.999 Ryan Luke Daque: I don’t see any specific
100 00:08:16.560 ⇒ 00:08:18.240 Ryan Luke Daque: filter here.
101 00:08:21.640 ⇒ 00:08:24.006 Ryan Luke Daque: like, unless yeah, maybe if
102 00:08:24.540 ⇒ 00:08:26.590 Ryan Luke Daque: maybe it would be great if we can.
103 00:08:28.130 ⇒ 00:08:28.950 Nicolas Sucari: Access.
104 00:08:28.950 ⇒ 00:08:30.509 Ryan Luke Daque: Access to Google.
105 00:08:33.080 ⇒ 00:08:33.745 Ryan Luke Daque: But
106 00:08:37.360 ⇒ 00:08:38.690 Ryan Luke Daque: but yeah.
107 00:08:40.140 ⇒ 00:08:42.814 Nicolas Sucari: Maybe we’re gonna I’m I’m seeing
108 00:08:44.410 ⇒ 00:08:46.839 Nicolas Sucari: Oh, no, this is his account.
109 00:08:49.570 ⇒ 00:08:57.319 Nicolas Sucari: okay, maybe. What? What if if we send the campaign ids, maybe to Kim and see if that’s okay.
110 00:08:57.430 ⇒ 00:09:05.240 Nicolas Sucari: I I mean, we we can. We can let her know that we almost yeah, we reach to that values, but filtering by campaign.
111 00:09:05.270 ⇒ 00:09:17.220 Nicolas Sucari: So if we change our data source to to be more to to bring the data from the campaigns and not from the ad stats. What’s the difference for us like?
112 00:09:18.470 ⇒ 00:09:23.720 Nicolas Sucari: It will imply more changes on
113 00:09:23.830 ⇒ 00:09:24.730 Nicolas Sucari: unreal
114 00:09:25.430 ⇒ 00:09:32.660 Nicolas Sucari: like what? Which are fields? We we’re gonna miss. If we bring the data from campaign stats and not from in from the app stats.
115 00:09:36.590 ⇒ 00:09:39.060 Ryan Luke Daque: So if if we do that from
116 00:09:43.450 ⇒ 00:09:44.819 Ryan Luke Daque: wait, where was that.
117 00:09:46.110 ⇒ 00:09:48.420 Nicolas Sucari: Yeah, it was in paid marketing performance, I think.
118 00:09:48.420 ⇒ 00:09:49.190 Ryan Luke Daque: Oh, yeah.
119 00:09:53.760 ⇒ 00:09:55.610 Ryan Luke Daque: if we do that from a
120 00:09:56.460 ⇒ 00:09:58.410 Ryan Luke Daque: if we remove the ad.
121 00:09:59.462 ⇒ 00:10:01.879 Nicolas Sucari: You’re you have a filter on dimensions. Yeah.
122 00:10:02.440 ⇒ 00:10:03.810 Ryan Luke Daque: Oh, yeah, that’s why.
123 00:10:04.610 ⇒ 00:10:05.290 Ryan Luke Daque: yeah.
124 00:10:06.650 ⇒ 00:10:10.850 Nicolas Sucari: So we don’t have here like amount of conversions. Maybe it’s
125 00:10:11.530 ⇒ 00:10:13.969 Nicolas Sucari: symmetric that we want to add.
126 00:10:14.200 ⇒ 00:10:16.510 Nicolas Sucari: We have conversion, rate and revenue.
127 00:10:16.530 ⇒ 00:10:18.269 Ryan Luke Daque: And yeah, we can add that.
128 00:10:19.090 ⇒ 00:10:22.330 Nicolas Sucari: Even though I think revenue is conversions right? Maybe.
129 00:10:22.560 ⇒ 00:10:26.319 Ryan Luke Daque: Revenue is the the value. It’s the the dollar amount.
130 00:10:26.320 ⇒ 00:10:27.569 Nicolas Sucari: Conversion, value. Okay.
131 00:10:27.570 ⇒ 00:10:28.590 Ryan Luke Daque: Yeah, yeah.
132 00:10:29.320 ⇒ 00:10:30.480 Ryan Luke Daque: So
133 00:10:30.580 ⇒ 00:10:41.290 Ryan Luke Daque: yeah, that that would. If if we do it from a campaign level, that would mean we would need to remove, add the ad dimension and the ad set, or, like the Add group dimension.
134 00:10:42.090 ⇒ 00:10:45.060 Ryan Luke Daque: And that would be for all platforms as well.
135 00:10:48.960 ⇒ 00:10:50.920 Ryan Luke Daque: yeah, because
136 00:10:51.180 ⇒ 00:10:52.699 Ryan Luke Daque: because the the.
137 00:10:52.700 ⇒ 00:10:58.530 Nicolas Sucari: Maybe maybe we no, yeah. You know what I I think maybe we need to like
138 00:10:59.420 ⇒ 00:11:03.469 Nicolas Sucari: talk to Kim, because maybe we we can do everything
139 00:11:03.610 ⇒ 00:11:10.160 Nicolas Sucari: like we need to figure out if we can do everything at depending on which level we are looking. Okay.
140 00:11:10.770 ⇒ 00:11:25.089 Nicolas Sucari: like, if we have all of the information like, if we have all of the information from all of the data sources by campaign, name or campaign Id, maybe we can use campaign for everyone like campaign for Google or for Amazon.
141 00:11:25.587 ⇒ 00:11:31.800 Nicolas Sucari: And for yeah, Facebook, and get rid of all of the ads
142 00:11:31.920 ⇒ 00:11:33.800 Nicolas Sucari: Id and Ad sets.
143 00:11:33.800 ⇒ 00:11:34.520 Ryan Luke Daque: Yeah, the the.
144 00:11:34.760 ⇒ 00:11:35.280 Nicolas Sucari: Gonna work.
145 00:11:35.280 ⇒ 00:11:39.200 Ryan Luke Daque: Yeah, I think we can do that. But the like, the
146 00:11:39.510 ⇒ 00:11:41.409 Ryan Luke Daque: the con to that is like
147 00:11:41.670 ⇒ 00:11:45.170 Ryan Luke Daque: they won’t be able to drill down to the ad level like, what, how?
148 00:11:45.170 ⇒ 00:11:45.919 Nicolas Sucari: Yeah, I know. I know.
149 00:11:45.920 ⇒ 00:11:46.750 Ryan Luke Daque: With this.
150 00:11:46.750 ⇒ 00:11:51.340 Nicolas Sucari: I know, but but if we but if you’re getting like the conversions
151 00:11:51.780 ⇒ 00:11:53.390 Nicolas Sucari: and the conversions value
152 00:11:53.450 ⇒ 00:12:12.220 Nicolas Sucari: accurately by campaign, I think we should do that. I mean we should get we. We we will need to get rid of the ad name and all of the information from ads. Yeah, we don’t we? We won’t be able to show granularity on that information. But we’re gonna be able to measure correctly by campaign
153 00:12:12.230 ⇒ 00:12:15.209 Nicolas Sucari: by platform. All of those other metrics right?
154 00:12:15.350 ⇒ 00:12:17.669 Ryan Luke Daque: Yeah, we we can definitely do that.
155 00:12:18.189 ⇒ 00:12:22.800 Ryan Luke Daque: Maybe let me try to just figure out for now. If I can.
156 00:12:22.800 ⇒ 00:12:23.530 Nicolas Sucari: Okay.
157 00:12:23.530 ⇒ 00:12:26.090 Ryan Luke Daque: Fix the ad level. Because that’s the only thing
158 00:12:26.540 ⇒ 00:12:35.639 Ryan Luke Daque: that’s the problem, right? It’s it’s just the ad level for Google ads. But if I can figure that out. Then we can do that route. But if not, then we can.
159 00:12:36.070 ⇒ 00:12:40.940 Ryan Luke Daque: We can fall back to the campaign level versions. Okay.
160 00:12:42.000 ⇒ 00:12:42.810 Nicolas Sucari: How you, Tom.
161 00:12:43.580 ⇒ 00:12:44.110 Ryan Luke Daque: Yeah, so.
162 00:12:44.110 ⇒ 00:12:44.700 Nicolas Sucari: Tool
163 00:12:46.280 ⇒ 00:12:51.159 Nicolas Sucari: through those updates that Ryan was working on figuring out the Google ad stuff.
164 00:12:57.610 ⇒ 00:13:00.280 Nicolas Sucari: Perfect. Okay, cool. Yeah. Let’s let’s do that.
165 00:13:00.730 ⇒ 00:13:01.520 Nicolas Sucari: Yeah. Sorry.
166 00:13:01.520 ⇒ 00:13:04.031 Uttam Kumaran: Yeah, I think for this meeting,
167 00:13:04.460 ⇒ 00:13:22.405 Uttam Kumaran: kind of just like, wanna try to get into cadence of us looking at the dashboards each week. And then basically finding out like where we can make any improvements. So I just thought, maybe we go through each dashboard. You guys already talked about the paid marketing, but maybe we could go through shipping and
168 00:13:23.678 ⇒ 00:13:29.519 Uttam Kumaran: any of other clear dashes. And then, Brian, I think on your side, maybe if you just want to take notes.
169 00:13:29.730 ⇒ 00:13:30.100 Ryan Luke Daque: We could take.
170 00:13:30.100 ⇒ 00:13:31.940 Uttam Kumaran: Notes somewhere, just basically
171 00:13:32.110 ⇒ 00:13:35.830 Uttam Kumaran: any changes we want to make to any of the dashboards. That would be perfect.
172 00:13:36.140 ⇒ 00:13:38.780 Ryan Luke Daque: Yeah, sure, I think I’m not sure if we have
173 00:13:39.320 ⇒ 00:13:40.130 Ryan Luke Daque: a notion.
174 00:13:40.130 ⇒ 00:13:41.370 Nicolas Sucari: You want me to share.
175 00:13:41.910 ⇒ 00:13:44.480 Ryan Luke Daque: Document, let me check.
176 00:13:45.430 ⇒ 00:13:50.229 Nicolas Sucari: Maybe we can create. This is gonna be all for full part. So maybe we can create.
177 00:13:51.260 ⇒ 00:13:52.819 Nicolas Sucari: Let me see.
178 00:13:53.100 ⇒ 00:13:55.320 Nicolas Sucari: I I can create a page there in.
179 00:13:55.680 ⇒ 00:13:57.169 Ryan Luke Daque: Yeah, we’ll start there.
180 00:13:59.690 ⇒ 00:14:01.970 Nicolas Sucari: You may update meeting roadmap.
181 00:14:02.450 ⇒ 00:14:02.850 Ryan Luke Daque: We have.
182 00:14:03.904 ⇒ 00:14:06.819 Ryan Luke Daque: Real dashboard in organization. I think this is.
183 00:14:07.410 ⇒ 00:14:10.369 Nicolas Sucari: Yeah, here, perfect. Yeah, that’s
184 00:14:10.580 ⇒ 00:14:13.340 Nicolas Sucari: yeah. If if you want to take notes here, that’s okay.
185 00:14:13.930 ⇒ 00:14:14.670 Ryan Luke Daque: Okay.
186 00:14:15.790 ⇒ 00:14:16.380 Nicolas Sucari: Okay.
187 00:14:17.220 ⇒ 00:14:17.790 Ryan Luke Daque: Cool.
188 00:14:20.210 ⇒ 00:14:24.430 Nicolas Sucari: Let’s go back to real here. So we have 15 dashboards right now.
189 00:14:27.445 ⇒ 00:14:30.109 Nicolas Sucari: Do you wanna start with in all orders
190 00:14:30.340 ⇒ 00:14:31.170 Nicolas Sucari: autumn.
191 00:14:31.740 ⇒ 00:14:32.900 Nicolas Sucari: or she or.
192 00:14:32.900 ⇒ 00:14:33.479 Uttam Kumaran: Yeah derek
193 00:14:33.770 ⇒ 00:14:34.640 Nicolas Sucari: Plans.
194 00:14:35.020 ⇒ 00:14:42.760 Uttam Kumaran: No, let’s let’s just go from the top. And then that way also we can just see what if we want to delete any of these like, let’s just try to run through all 15 today.
195 00:14:42.760 ⇒ 00:14:43.150 Ryan Luke Daque: Yeah.
196 00:14:43.150 ⇒ 00:14:44.889 Uttam Kumaran: As quick as we can, and then
197 00:14:44.970 ⇒ 00:14:48.630 Uttam Kumaran: maybe next, probably as we start to do this on a weekly basis. So so
198 00:14:48.650 ⇒ 00:14:50.140 Uttam Kumaran: get a little bit easier.
199 00:14:51.750 ⇒ 00:14:52.510 Nicolas Sucari: Agree.
200 00:14:52.510 ⇒ 00:15:01.130 Uttam Kumaran: So yeah, let’s let’s just talk about this dashboard. So the goal of this is showing all order items. I think. The title and all looks okay.
201 00:15:01.410 ⇒ 00:15:02.800 Uttam Kumaran: There are.
202 00:15:02.890 ⇒ 00:15:06.960 Uttam Kumaran: If we look at the measures, we have total sales, average quantity per order.
203 00:15:07.520 ⇒ 00:15:18.590 Uttam Kumaran: So if you look at the 1st thing I noticed. And again, I’m gonna kind of do this. I want us to do this kind of from the perspective of of them. So the 1st thing looks like sales drop down like a lot. So
204 00:15:18.600 ⇒ 00:15:20.199 Uttam Kumaran: what is the
205 00:15:21.700 ⇒ 00:15:23.949 Uttam Kumaran: like? Is that just because it’s today.
206 00:15:24.710 ⇒ 00:15:26.277 Uttam Kumaran: or what is
207 00:15:26.800 ⇒ 00:15:27.540 Ryan Luke Daque: It looks.
208 00:15:27.540 ⇒ 00:15:28.800 Nicolas Sucari: Maybe we can do.
209 00:15:29.950 ⇒ 00:15:32.210 Nicolas Sucari: Yeah, previous, like.
210 00:15:32.870 ⇒ 00:15:41.189 Uttam Kumaran: But like, why like, what is that? What is that like? What is that line like? How? Why is it so low? Is it just because it’s it’s the last 2 days.
211 00:15:43.220 ⇒ 00:15:47.640 Ryan Luke Daque: Probably that one is a is on daily. So it looks like it’s for today.
212 00:15:48.380 ⇒ 00:15:53.920 Ryan Luke Daque: And that’s why it’s probably so low. So maybe it. The day has just started right? Right? So.
213 00:15:56.620 ⇒ 00:15:59.869 Uttam Kumaran: Okay. So one thing I think we should try to do is
214 00:16:01.060 ⇒ 00:16:05.000 Uttam Kumaran: filter this to just do only completed days.
215 00:16:05.000 ⇒ 00:16:05.800 Ryan Luke Daque: Yeah.
216 00:16:11.960 ⇒ 00:16:12.760 Nicolas Sucari: Do you know.
217 00:16:12.760 ⇒ 00:16:13.880 Uttam Kumaran: Note that down.
218 00:16:14.290 ⇒ 00:16:16.579 Ryan Luke Daque: I’m I’m I’m noting that down.
219 00:16:18.760 ⇒ 00:16:25.010 Uttam Kumaran: The second thing is, we have total sales, average quantity per order. Average item, sale. Price
220 00:16:26.190 ⇒ 00:16:28.830 Uttam Kumaran: 9 out of total quantities.
221 00:16:29.639 ⇒ 00:16:34.750 Uttam Kumaran: So total quantities is kind of confusing. So if can you hover over that? What does the description say?
222 00:16:36.250 ⇒ 00:16:38.799 Nicolas Sucari: Amount of product quantities per order.
223 00:16:39.820 ⇒ 00:16:47.009 Nicolas Sucari: So I think it’s like the total items. Yeah, exactly like every each line that we have in in all of the orders.
224 00:16:47.620 ⇒ 00:16:51.540 Uttam Kumaran: So maybe we should change that to total items. Total items sold.
225 00:16:52.140 ⇒ 00:16:53.779 Ryan Luke Daque: Yeah, that makes sense.
226 00:16:53.780 ⇒ 00:16:56.300 Uttam Kumaran: And and then we should also change the second one to do all
227 00:16:56.320 ⇒ 00:16:57.360 Uttam Kumaran: average items.
228 00:16:57.360 ⇒ 00:16:59.560 Nicolas Sucari: Average items. Yeah.
229 00:17:00.660 ⇒ 00:17:02.909 Nicolas Sucari: because we have the item sale price.
230 00:17:03.020 ⇒ 00:17:03.740 Nicolas Sucari: Yeah.
231 00:17:04.430 ⇒ 00:17:07.310 Ryan Luke Daque: What was the average item sold.
232 00:17:08.170 ⇒ 00:17:08.920 Uttam Kumaran: Yeah.
233 00:17:10.069 ⇒ 00:17:14.270 Uttam Kumaran: average. Yeah, average items per order and total items sold.
234 00:17:15.109 ⇒ 00:17:16.419 Ryan Luke Daque: Gotcha? Yeah.
235 00:17:19.920 ⇒ 00:17:25.800 Uttam Kumaran: Okay. Otherwise, the graphs looks great. Let’s let’s look at dimensions. So from that, let’s just go from the top.
236 00:17:26.290 ⇒ 00:17:31.090 Uttam Kumaran: So we have platform. Okay, this looks fine. Fulfillment channel.
237 00:17:31.450 ⇒ 00:17:32.690 Uttam Kumaran: fine
238 00:17:32.770 ⇒ 00:17:37.650 Uttam Kumaran: line, order, line, item, order, id order, id customer, email, day name.
239 00:17:37.770 ⇒ 00:17:46.496 Uttam Kumaran: So I think what we should do is, let’s I want to kind of change some of the orderings, Brian. So I think we should move.
240 00:17:47.920 ⇒ 00:17:49.759 Uttam Kumaran: I want to put like the
241 00:17:50.714 ⇒ 00:17:54.040 Uttam Kumaran: product, skew, product name and class
242 00:17:54.910 ⇒ 00:17:56.100 Uttam Kumaran: up higher.
243 00:17:57.430 ⇒ 00:17:59.780 Uttam Kumaran: basically moving the Ids
244 00:18:00.290 ⇒ 00:18:02.289 Uttam Kumaran: to the end or towards the end.
245 00:18:03.110 ⇒ 00:18:05.899 Uttam Kumaran: because they’re commonly filtered by the products.
246 00:18:06.990 ⇒ 00:18:11.790 Uttam Kumaran: Gotcha, basically, it should go the platforms products and then the shipping information.
247 00:18:17.470 ⇒ 00:18:20.399 Uttam Kumaran: Let’s do that. If if that’s possible.
248 00:18:21.840 ⇒ 00:18:22.690 Ryan Luke Daque: Gotcha.
249 00:18:23.520 ⇒ 00:18:24.400 Ryan Luke Daque: Okay?
250 00:18:24.710 ⇒ 00:18:29.152 Ryan Luke Daque: And, like all the other Ids, would be at the end like order. Id, for example.
251 00:18:29.995 ⇒ 00:18:31.030 Nicolas Sucari: Yeah, I think.
252 00:18:31.030 ⇒ 00:18:32.149 Uttam Kumaran: Put it towards the end.
253 00:18:32.150 ⇒ 00:18:35.280 Nicolas Sucari: Yeah, yeah, because it’s maybe it’s like the least.
254 00:18:35.280 ⇒ 00:18:35.910 Ryan Luke Daque: East.
255 00:18:35.910 ⇒ 00:18:38.020 Nicolas Sucari: Useful fields here.
256 00:18:38.020 ⇒ 00:18:38.480 Ryan Luke Daque: Right.
257 00:18:38.480 ⇒ 00:18:43.259 Nicolas Sucari: To have all of the Ids, and maybe the order. You are also at the bottom.
258 00:18:44.770 ⇒ 00:18:45.380 Nicolas Sucari: Yeah.
259 00:18:45.890 ⇒ 00:18:46.620 Ryan Luke Daque: Okay.
260 00:18:47.800 ⇒ 00:18:48.820 Ryan Luke Daque: copy that.
261 00:18:49.340 ⇒ 00:18:52.770 Nicolas Sucari: We have some notes here. We need to check these ones right?
262 00:18:54.470 ⇒ 00:19:00.340 Uttam Kumaran: Yeah. So let’s look at. So, okay, so that’s a sudden. That’s that’s okay on the ordering. Looks like we could do that. I think,
263 00:19:00.900 ⇒ 00:19:03.930 Uttam Kumaran: product, class product, skew product name.
264 00:19:04.970 ⇒ 00:19:06.890 Uttam Kumaran: So customer email.
265 00:19:07.458 ⇒ 00:19:09.330 Uttam Kumaran: I think we should.
266 00:19:12.190 ⇒ 00:19:16.260 Uttam Kumaran: So there’s yeah for the 1st thing. This, there’s this empty customer email.
267 00:19:17.620 ⇒ 00:19:21.819 Uttam Kumaran: I think we should replace that. I don’t know. We should really replace it with
268 00:19:22.550 ⇒ 00:19:24.750 Uttam Kumaran: not available or
269 00:19:24.990 ⇒ 00:19:27.129 Uttam Kumaran: not provided, or something like that.
270 00:19:28.770 ⇒ 00:19:30.370 Uttam Kumaran: where it’s like empty.
271 00:19:32.230 ⇒ 00:19:33.110 Nicolas Sucari: Yeah, these one.
272 00:19:33.960 ⇒ 00:19:36.200 Nicolas Sucari: This is a change for the
273 00:19:36.240 ⇒ 00:19:38.660 Nicolas Sucari: and the tables, right? Like the.
274 00:19:39.290 ⇒ 00:19:39.810 Ryan Luke Daque: The data.
275 00:19:39.810 ⇒ 00:19:42.659 Nicolas Sucari: Kind of we need to. Yeah, we need to change the data model.
276 00:19:44.420 ⇒ 00:19:46.252 Uttam Kumaran: The second thing is
277 00:19:47.170 ⇒ 00:19:52.060 Uttam Kumaran: that we have product, skew and modified products. Queue. Let’s just keep one of those.
278 00:19:55.310 ⇒ 00:19:56.380 Nicolas Sucari: Yeah. Here.
279 00:19:57.650 ⇒ 00:20:02.210 Ryan Luke Daque: What’s the yeah. I’ll have to look into that like what the modified products skews.
280 00:20:02.510 ⇒ 00:20:03.880 Ryan Luke Daque: I wonder if there’s like
281 00:20:06.970 ⇒ 00:20:09.140 Ryan Luke Daque: any difference?
282 00:20:10.950 ⇒ 00:20:13.759 Ryan Luke Daque: But yeah, let me keep a big note.
283 00:20:16.120 ⇒ 00:20:19.792 Uttam Kumaran: The other thing here is, as you can see, there’s
284 00:20:21.190 ⇒ 00:20:23.240 Uttam Kumaran: sipping stuff that’s null.
285 00:20:24.120 ⇒ 00:20:30.989 Uttam Kumaran: I want to replace the null with something that’s more appropriate. Can you click on one of the nulls like just click null, zip, code?
286 00:20:32.050 ⇒ 00:20:36.909 Uttam Kumaran: Are they all? Can you scroll up to see where? What? What platform. These are all coming from.
287 00:20:38.620 ⇒ 00:20:39.790 Ryan Luke Daque: Oh! Fancy!
288 00:20:41.200 ⇒ 00:20:44.999 Uttam Kumaran: So looks like there’s still some nulls coming from shopify, and Amazon.
289 00:20:45.530 ⇒ 00:20:46.460 Ryan Luke Daque: Yeah.
290 00:20:46.820 ⇒ 00:20:49.089 Uttam Kumaran: For the most part it’s probably Fba.
291 00:20:51.050 ⇒ 00:20:57.669 Uttam Kumaran: So the one thing I want to do is make that clear here, so that if there are items that we don’t have the shipping stuff for
292 00:20:58.370 ⇒ 00:21:01.199 Uttam Kumaran: I want. I want there to be a reason for that.
293 00:21:01.550 ⇒ 00:21:07.099 Uttam Kumaran: For example, if we know that the shipping city is null because it’s fulfilled by Amazon.
294 00:21:07.360 ⇒ 00:21:09.379 Uttam Kumaran: In the city we should put
295 00:21:10.380 ⇒ 00:21:14.010 Uttam Kumaran: F like fulfilled by Amazon, unknown, or something like that.
296 00:21:14.830 ⇒ 00:21:20.359 Nicolas Sucari: Like here. I like to create a new shipping city that it’s like Fba.
297 00:21:21.350 ⇒ 00:21:21.980 Uttam Kumaran: Yeah.
298 00:21:24.780 ⇒ 00:21:27.050 Ryan Luke Daque: We. We need some kind of
299 00:21:27.470 ⇒ 00:21:30.000 Ryan Luke Daque: way to determine why it’s not then, like.
300 00:21:30.610 ⇒ 00:21:33.439 Uttam Kumaran: Exactly. Yeah. So you can probably set up a case when.
301 00:21:33.880 ⇒ 00:21:35.040 Ryan Luke Daque: Yeah.
302 00:21:35.040 ⇒ 00:21:42.170 Uttam Kumaran: But basically, yeah, I mean, I think what you should probably do is like, create a new column, create a new column that’s like
303 00:21:43.220 ⇒ 00:21:45.020 Uttam Kumaran: sipping like
304 00:21:45.140 ⇒ 00:21:49.149 Uttam Kumaran: missing data on known reason. And then that way for everything
305 00:21:49.370 ⇒ 00:21:51.019 Uttam Kumaran: you can nvl
306 00:21:51.580 ⇒ 00:21:55.520 Uttam Kumaran: the value. And then, if it’s null, it’ll use the shipping. Unknown reason.
307 00:21:57.180 ⇒ 00:21:57.930 Ryan Luke Daque: Right.
308 00:21:58.920 ⇒ 00:21:59.850 Uttam Kumaran: That seems like the.
309 00:21:59.850 ⇒ 00:22:00.480 Ryan Luke Daque: Most appropriate.
310 00:22:00.480 ⇒ 00:22:01.749 Uttam Kumaran: And I think I don’t know.
311 00:22:02.840 ⇒ 00:22:03.220 Ryan Luke Daque: Should.
312 00:22:03.220 ⇒ 00:22:08.730 Nicolas Sucari: Be a rule that affects this like column on the table, right? The shipping city.
313 00:22:10.030 ⇒ 00:22:13.579 Uttam Kumaran: Well, no, I would say we, we should leave the shipping city as null.
314 00:22:13.870 ⇒ 00:22:14.440 Uttam Kumaran: There should.
315 00:22:14.440 ⇒ 00:22:15.710 Nicolas Sucari: All separate region.
316 00:22:15.710 ⇒ 00:22:16.340 Uttam Kumaran: Field.
317 00:22:16.340 ⇒ 00:22:17.070 Nicolas Sucari: Okay.
318 00:22:17.070 ⇒ 00:22:21.410 Uttam Kumaran: Yeah. And then that one. Then in in here, in real.
319 00:22:21.510 ⇒ 00:22:26.689 Uttam Kumaran: you can basically bring that column in as a like.
320 00:22:27.450 ⇒ 00:22:35.229 Uttam Kumaran: I wouldn’t change the shipping city column, Ryan, I would actually just have a new column. That’s the reason. And then, in real
321 00:22:35.530 ⇒ 00:22:40.499 Uttam Kumaran: cause, really, this is for aesthetics. This isn’t like. I don’t want the the data to have, like.
322 00:22:41.260 ⇒ 00:22:46.500 Uttam Kumaran: I want the data to be really clear that we’re missing it. But then, in real, you can envy all of it, basically.
323 00:22:48.100 ⇒ 00:22:48.810 Ryan Luke Daque: Okay.
324 00:22:49.550 ⇒ 00:22:51.820 Uttam Kumaran: Like. I think you could probably do that in the models.
325 00:22:51.970 ⇒ 00:22:53.590 Ryan Luke Daque: In real models, right?
326 00:22:53.930 ⇒ 00:22:57.759 Uttam Kumaran: And real. Yeah, and real models. Or you could do, yeah, yeah, probably in models.
327 00:22:58.870 ⇒ 00:22:59.949 Uttam Kumaran: Or sources.
328 00:23:04.410 ⇒ 00:23:06.589 Ryan Luke Daque: Yeah, either either of those.
329 00:23:08.080 ⇒ 00:23:13.779 Uttam Kumaran: Okay, so this is all fine. Can we scroll down a little bit more. So shipping State
330 00:23:14.240 ⇒ 00:23:15.420 Uttam Kumaran: staunched.
331 00:23:16.680 ⇒ 00:23:20.240 Uttam Kumaran: So I think we can. We remove the zone States.
332 00:23:21.100 ⇒ 00:23:22.170 Uttam Kumaran: I
333 00:23:22.550 ⇒ 00:23:25.969 Uttam Kumaran: I think there’s a specific calculation for that which is basically
334 00:23:26.310 ⇒ 00:23:28.070 Uttam Kumaran: trying to figure out.
335 00:23:30.960 ⇒ 00:23:35.410 Uttam Kumaran: yeah, I think this is this is just unnecessary. I don’t think we were using that for anything right now.
336 00:23:35.730 ⇒ 00:23:36.320 Ryan Luke Daque: Okay.
337 00:23:38.110 ⇒ 00:23:39.210 Uttam Kumaran: And then
338 00:23:40.290 ⇒ 00:23:43.570 Uttam Kumaran: the last thing on this is has refund.
339 00:23:43.910 ⇒ 00:23:44.970 Uttam Kumaran: There is
340 00:23:45.380 ⇒ 00:23:47.910 Uttam Kumaran: 1.3 k. On with null.
341 00:23:47.910 ⇒ 00:23:48.850 Ryan Luke Daque: Yeah.
342 00:23:49.730 ⇒ 00:23:52.490 Uttam Kumaran: I wonder if those just need to be false or
343 00:23:52.620 ⇒ 00:23:54.100 Uttam Kumaran: where those are coming from?
344 00:23:56.030 ⇒ 00:23:56.890 Uttam Kumaran: Yeah.
345 00:24:06.110 ⇒ 00:24:06.830 Uttam Kumaran: okay.
346 00:24:08.150 ⇒ 00:24:09.660 Nicolas Sucari: Wait, we have more.
347 00:24:20.280 ⇒ 00:24:23.369 Nicolas Sucari: So. Should we like remove all
348 00:24:23.590 ⇒ 00:24:28.549 Nicolas Sucari: these kind of measures that are not related to sales from this dashboard.
349 00:24:28.830 ⇒ 00:24:30.680 Nicolas Sucari: or we should keep everything.
350 00:24:31.450 ⇒ 00:24:32.230 Uttam Kumaran: Yes.
351 00:24:33.619 ⇒ 00:24:36.010 Uttam Kumaran: I didn’t know that. There, I didn’t see those there. So yeah.
352 00:24:36.010 ⇒ 00:24:38.320 Nicolas Sucari: Sorry it was filtered out.
353 00:24:39.030 ⇒ 00:24:42.899 Uttam Kumaran: Yeah. So let’s let’s remove the shipping costs from here.
354 00:24:43.290 ⇒ 00:24:44.340 Uttam Kumaran: Well.
355 00:24:44.340 ⇒ 00:24:45.100 Nicolas Sucari: And don’t.
356 00:24:46.180 ⇒ 00:24:46.789 Ryan Luke Daque: We have a shit.
357 00:24:46.790 ⇒ 00:24:47.550 Uttam Kumaran: Cutting costs from here.
358 00:24:47.550 ⇒ 00:24:48.140 Ryan Luke Daque: Yeah.
359 00:24:49.100 ⇒ 00:24:49.715 Uttam Kumaran: And
360 00:24:53.100 ⇒ 00:24:54.089 Uttam Kumaran: What else.
361 00:24:55.220 ⇒ 00:24:56.980 Nicolas Sucari: Total refund, amount. Maybe yeah.
362 00:24:56.980 ⇒ 00:24:57.630 Uttam Kumaran: Yeah.
363 00:25:00.450 ⇒ 00:25:01.580 Uttam Kumaran: one, item.
364 00:25:01.580 ⇒ 00:25:01.980 Nicolas Sucari: Don’t!
365 00:25:01.980 ⇒ 00:25:06.010 Uttam Kumaran: I don’t know about. I don’t know about refund amount, but item, discount. Let’s get rid of.
366 00:25:06.630 ⇒ 00:25:08.929 Uttam Kumaran: Let’s leave refund amount, but then
367 00:25:09.050 ⇒ 00:25:10.679 Uttam Kumaran: remove item, discount
368 00:25:11.810 ⇒ 00:25:15.990 Uttam Kumaran: cause refunds. You want to see which items are getting refunded. So I think that’s okay.
369 00:25:17.450 ⇒ 00:25:18.290 Uttam Kumaran: Right?
370 00:25:19.030 ⇒ 00:25:19.790 Uttam Kumaran: Right?
371 00:25:20.730 ⇒ 00:25:21.430 Nicolas Sucari: Good.
372 00:25:22.540 ⇒ 00:25:23.230 Nicolas Sucari: But
373 00:25:25.790 ⇒ 00:25:26.660 Nicolas Sucari: yeah.
374 00:25:27.230 ⇒ 00:25:33.500 Nicolas Sucari: So we remove shipment cost and average item discount, and we’ll keep the other ones. Okay.
375 00:25:35.270 ⇒ 00:25:36.150 Nicolas Sucari: it’s fine.
376 00:25:43.620 ⇒ 00:25:44.450 Nicolas Sucari: perfect.
377 00:25:44.960 ⇒ 00:25:46.460 Nicolas Sucari: Let’s go to the next one.
378 00:25:52.160 ⇒ 00:25:53.990 Nicolas Sucari: So this is on. Orders
379 00:25:54.980 ⇒ 00:25:58.300 Nicolas Sucari: should be almost the same right, but
380 00:25:58.510 ⇒ 00:25:59.280 Nicolas Sucari: like a.
381 00:25:59.280 ⇒ 00:25:59.800 Uttam Kumaran: So.
382 00:26:01.220 ⇒ 00:26:02.840 Uttam Kumaran: yeah, so
383 00:26:04.520 ⇒ 00:26:06.610 Uttam Kumaran: average total sales.
384 00:26:06.790 ⇒ 00:26:13.860 Uttam Kumaran: we need to. So yeah, let’s just start with measures. And then we can work our way through everything. So average total sales, can we change this to average?
385 00:26:16.310 ⇒ 00:26:19.889 Uttam Kumaran: this is like average order value. Yeah, average order value.
386 00:26:25.350 ⇒ 00:26:25.900 Ryan Luke Daque: Okay.
387 00:26:29.700 ⇒ 00:26:33.069 Uttam Kumaran: Same thing is, we have this like line that goes down problem.
388 00:26:34.350 ⇒ 00:26:35.090 Uttam Kumaran: So that’s okay.
389 00:26:35.090 ⇒ 00:26:35.720 Nicolas Sucari: Yeah.
390 00:26:35.720 ⇒ 00:26:37.439 Uttam Kumaran: Just we just need to do completed days.
391 00:26:37.440 ⇒ 00:26:38.930 Ryan Luke Daque: It is yep.
392 00:26:41.070 ⇒ 00:26:42.810 Ryan Luke Daque: September 16.th
393 00:26:44.540 ⇒ 00:26:45.539 Nicolas Sucari: Yeah, it’s true.
394 00:26:46.380 ⇒ 00:26:50.569 Uttam Kumaran: Average quantity per order, we can change to average items per order.
395 00:26:57.720 ⇒ 00:27:00.439 Nicolas Sucari: Average product, weight and total product weight.
396 00:27:00.840 ⇒ 00:27:01.640 Nicolas Sucari: Do we.
397 00:27:01.640 ⇒ 00:27:02.240 Uttam Kumaran: Get rid of.
398 00:27:02.240 ⇒ 00:27:03.240 Nicolas Sucari: This, here.
399 00:27:03.390 ⇒ 00:27:04.080 Nicolas Sucari: okay.
400 00:27:04.080 ⇒ 00:27:07.030 Uttam Kumaran: I think. Oh, intent! Put it in shipping.
401 00:27:08.030 ⇒ 00:27:09.200 Nicolas Sucari: Yeah, exactly.
402 00:27:10.760 ⇒ 00:27:11.420 Uttam Kumaran: Okay.
403 00:27:11.640 ⇒ 00:27:12.730 Uttam Kumaran: yeah, let’s do that.
404 00:27:12.730 ⇒ 00:27:15.759 Nicolas Sucari: i i i i think we need to keep on.
405 00:27:15.760 ⇒ 00:27:16.629 Uttam Kumaran: So as soon as yeah.
406 00:27:16.630 ⇒ 00:27:18.100 Nicolas Sucari: Here, yeah.
407 00:27:18.350 ⇒ 00:27:19.469 Uttam Kumaran: Yeah, that makes sense.
408 00:27:20.470 ⇒ 00:27:22.105 Nicolas Sucari: And total fees
409 00:27:24.760 ⇒ 00:27:25.709 Ryan Luke Daque: Yeah, what’s the fees?
410 00:27:25.710 ⇒ 00:27:27.699 Uttam Kumaran: Total fees. I think we should keep here.
411 00:27:30.540 ⇒ 00:27:32.979 Nicolas Sucari: It’s a negative value. I don’t know.
412 00:27:33.840 ⇒ 00:27:34.610 Uttam Kumaran: It will. It’s.
413 00:27:34.610 ⇒ 00:27:35.399 Nicolas Sucari: Correct or not.
414 00:27:35.400 ⇒ 00:27:39.790 Uttam Kumaran: It should be correct. Yeah, because it’s the money we are losing the fees, but
415 00:27:42.050 ⇒ 00:27:42.970 Uttam Kumaran: I guess
416 00:27:43.530 ⇒ 00:27:46.040 Uttam Kumaran: I think. Leave it. I think it’s fine, the way it is.
417 00:27:48.340 ⇒ 00:27:48.930 Nicolas Sucari: Okay.
418 00:27:48.930 ⇒ 00:27:51.980 Uttam Kumaran: Well, it’s only a couple 100 bucks.
419 00:27:53.120 ⇒ 00:27:54.920 Uttam Kumaran: so maybe that’s not right.
420 00:27:55.780 ⇒ 00:27:58.740 Nicolas Sucari: This is the last 3 months. Let’s go to the
421 00:28:00.130 ⇒ 00:28:01.939 Nicolas Sucari: in the air Tours.
422 00:28:02.360 ⇒ 00:28:02.880 Uttam Kumaran: Oh!
423 00:28:02.880 ⇒ 00:28:04.119 Nicolas Sucari: Yeah, something happened.
424 00:28:04.350 ⇒ 00:28:07.010 Nicolas Sucari: Yeah, we are losing some data. Maybe.
425 00:28:08.460 ⇒ 00:28:11.779 Uttam Kumaran: Okay. So maybe that’s a larger thing to look at is the total fees.
426 00:28:12.510 ⇒ 00:28:14.479 Uttam Kumaran: Let’s just make a note on that. And then.
427 00:28:14.540 ⇒ 00:28:15.560 Ryan Luke Daque: Right.
428 00:28:16.630 ⇒ 00:28:19.779 Uttam Kumaran: It’s not too. It’s not like such a priority, though. Honestly.
429 00:28:23.240 ⇒ 00:28:28.159 Uttam Kumaran: okay, cost. So like, let’s look at the dimensions.
430 00:28:29.340 ⇒ 00:28:31.220 Uttam Kumaran: This is all fine.
431 00:28:34.640 ⇒ 00:28:35.990 Nicolas Sucari: Let’s move these 2.
432 00:28:35.990 ⇒ 00:28:41.970 Uttam Kumaran: And we want. I think I think we do need to have the shipping, the shipping locations here, though.
433 00:28:44.520 ⇒ 00:28:45.770 Nicolas Sucari: Yeah.
434 00:28:46.050 ⇒ 00:28:46.880 Nicolas Sucari: maybe
435 00:28:48.700 ⇒ 00:28:54.310 Nicolas Sucari: here we have the refund reason, this other one. I don’t think we had it right.
436 00:29:00.416 ⇒ 00:29:01.770 Uttam Kumaran: Refund reason.
437 00:29:02.100 ⇒ 00:29:04.730 Uttam Kumaran: Let’s leave the refund reason here. That’s fine.
438 00:29:05.250 ⇒ 00:29:08.319 Uttam Kumaran: I think. Only thing, can we? Can we put no reason.
439 00:29:09.440 ⇒ 00:29:09.960 Nicolas Sucari: Yeah.
440 00:29:09.960 ⇒ 00:29:10.920 Uttam Kumaran: Instead.
441 00:29:14.250 ⇒ 00:29:14.660 Ryan Luke Daque: Gotcha.
442 00:29:14.660 ⇒ 00:29:19.110 Uttam Kumaran: And Nico for for the for the weekly email this week. Let’s list all these changes.
443 00:29:20.740 ⇒ 00:29:22.010 Nicolas Sucari: Yeah. Sorry.
444 00:29:22.010 ⇒ 00:29:23.469 Uttam Kumaran: Just a side thought, but.
445 00:29:23.860 ⇒ 00:29:26.749 Nicolas Sucari: Yeah, yeah, I’m gonna grab all of these.
446 00:29:27.330 ⇒ 00:29:28.480 Uttam Kumaran: Okay, cool. Yeah.
447 00:29:28.480 ⇒ 00:29:30.959 Nicolas Sucari: And we, yeah, we’re gonna use this one.
448 00:29:31.710 ⇒ 00:29:32.540 Uttam Kumaran: Okay,
449 00:29:34.390 ⇒ 00:29:38.880 Uttam Kumaran: So for customer email, let’s put, let’s make sure that
450 00:29:38.990 ⇒ 00:29:42.400 Uttam Kumaran: null and empty, they’re all combined.
451 00:29:43.330 ⇒ 00:29:43.930 Ryan Luke Daque: Right.
452 00:29:44.740 ⇒ 00:29:45.899 Uttam Kumaran: Discount code
453 00:29:46.420 ⇒ 00:29:48.670 Uttam Kumaran: discount code. Empty is okay.
454 00:29:49.230 ⇒ 00:29:53.090 Ryan Luke Daque: And the customer email should also be like for nulls and Mts. It would be like
455 00:29:53.370 ⇒ 00:29:56.169 Ryan Luke Daque: not available or not provided as well right.
456 00:29:57.200 ⇒ 00:29:59.509 Uttam Kumaran: Yeah, I would just change to not provided.
457 00:30:04.081 ⇒ 00:30:10.320 Uttam Kumaran: And then, yeah, we we made a note to add the shipping information here. Otherwise this looks pretty good. Right?
458 00:30:11.800 ⇒ 00:30:13.399 Uttam Kumaran: Yeah, what do you think.
459 00:30:17.090 ⇒ 00:30:20.239 Ryan Luke Daque: The no discount codes or the black. We can.
460 00:30:21.520 ⇒ 00:30:23.380 Nicolas Sucari: We we can add or.
461 00:30:23.650 ⇒ 00:30:30.219 Uttam Kumaran: I don’t know. I don’t think we should put anything there. I I think you should just put. I think you should just leave it as null or Yeah.
462 00:30:30.880 ⇒ 00:30:31.450 Ryan Luke Daque: Okay.
463 00:30:33.160 ⇒ 00:30:33.830 Ryan Luke Daque: I don’t want to.
464 00:30:33.830 ⇒ 00:30:34.940 Uttam Kumaran: Confuse.
465 00:30:35.580 ⇒ 00:30:37.650 Ryan Luke Daque: What’s that? Comma.
466 00:30:38.830 ⇒ 00:30:43.030 Uttam Kumaran: That one I don’t think we can do anything about, because that that may actually have been one.
467 00:30:43.030 ⇒ 00:30:44.590 Ryan Luke Daque: Yeah, maybe.
468 00:30:44.590 ⇒ 00:30:45.640 Uttam Kumaran: It’s not our fault.
469 00:30:47.090 ⇒ 00:30:49.610 Nicolas Sucari: And maybe they were trying something. Yeah, or.
470 00:30:50.280 ⇒ 00:30:52.580 Ryan Luke Daque: But yeah, yeah, okay.
471 00:30:54.390 ⇒ 00:30:55.710 Ryan Luke Daque: sounds good.
472 00:30:57.220 ⇒ 00:30:57.720 Nicolas Sucari: Okay.
473 00:31:04.070 ⇒ 00:31:05.930 Uttam Kumaran: Daily Kpis.
474 00:31:09.660 ⇒ 00:31:11.529 Nicolas Sucari: Is, is there a way to like
475 00:31:11.660 ⇒ 00:31:16.919 Nicolas Sucari: change the way we are showing these measures? Or this is the only way to show it here in real.
476 00:31:17.060 ⇒ 00:31:22.049 Uttam Kumaran: Not right now. I think we’re once they release the dashboards. Figure dashboards thing, we’ll make it.
477 00:31:22.980 ⇒ 00:31:27.670 Uttam Kumaran: We’ll we’ll we’ll use that functionality to make this a little bit easier.
478 00:31:35.000 ⇒ 00:31:38.620 Nicolas Sucari: So here we need to review how we are calculating all of these ones. Right?
479 00:31:41.340 ⇒ 00:31:48.360 Nicolas Sucari: I I haven’t been checking, like the actual measures on how they are being calculated, and if we are.
480 00:31:48.360 ⇒ 00:31:51.914 Uttam Kumaran: Well, does anything look? Super. So yeah, I think.
481 00:31:52.750 ⇒ 00:31:56.060 Uttam Kumaran: I want to show. I think, Ryan, I want to show this in order.
482 00:31:56.600 ⇒ 00:31:59.049 Uttam Kumaran: which is like, start with the revenue.
483 00:31:59.560 ⇒ 00:32:00.730 Uttam Kumaran: and then
484 00:32:01.940 ⇒ 00:32:03.240 Uttam Kumaran: it’s like revenue.
485 00:32:03.240 ⇒ 00:32:03.610 Nicolas Sucari: Can’t.
486 00:32:03.610 ⇒ 00:32:10.889 Uttam Kumaran: Discounts, refunds, marketing costs, slipping costs, and then the profit. So scroll all the way down.
487 00:32:11.990 ⇒ 00:32:15.849 Uttam Kumaran: Yeah. So let’s let’s do that. So it’s it’s revenue
488 00:32:15.880 ⇒ 00:32:19.010 Uttam Kumaran: everything in the middle, then profit. And then there’s a.
489 00:32:19.010 ⇒ 00:32:19.460 Nicolas Sucari: Really.
490 00:32:19.460 ⇒ 00:32:20.990 Uttam Kumaran: Bottom. I think you could leave.
491 00:32:21.860 ⇒ 00:32:26.340 Nicolas Sucari: Yeah, revenue is total sales. We start with a cogs.
492 00:32:26.520 ⇒ 00:32:29.759 Nicolas Sucari: discounts, marketing costs, shipping costs.
493 00:32:29.980 ⇒ 00:32:32.020 Nicolas Sucari: refund amount, maybe.
494 00:32:32.450 ⇒ 00:32:36.299 Nicolas Sucari: and last, one should be profit, and then we can add
495 00:32:36.650 ⇒ 00:32:40.220 Nicolas Sucari: shipment, weight impressions cost per click.
496 00:32:40.870 ⇒ 00:32:41.370 Uttam Kumaran: Tackle that.
497 00:32:41.370 ⇒ 00:32:43.679 Nicolas Sucari: Should be before before profit.
498 00:32:47.610 ⇒ 00:32:48.240 Ryan Luke Daque: Yeah.
499 00:32:48.530 ⇒ 00:32:54.580 Nicolas Sucari: So it’s it’s kind of how we are reaching that total profit right from the total sales.
500 00:32:54.770 ⇒ 00:32:55.820 Ryan Luke Daque: Makes sense.
501 00:32:58.200 ⇒ 00:32:58.820 Nicolas Sucari: Okay.
502 00:33:00.120 ⇒ 00:33:03.819 Nicolas Sucari: that’s why I’m saying like, we we have like shipping costs.
503 00:33:03.840 ⇒ 00:33:09.620 Nicolas Sucari: whereas it’s a cost, and it’s a positive value. Why do we have fees as a negative value.
504 00:33:09.620 ⇒ 00:33:10.660 Uttam Kumaran: Oh!
505 00:33:10.660 ⇒ 00:33:14.580 Nicolas Sucari: I’m I’m wondering. That’s why PC. Is kind of odd to me here.
506 00:33:14.580 ⇒ 00:33:15.509 Uttam Kumaran: Okay, I, you.
507 00:33:15.510 ⇒ 00:33:16.989 Nicolas Sucari: Because we don’t like.
508 00:33:17.210 ⇒ 00:33:19.210 Uttam Kumaran: Instead of fees. Yeah.
509 00:33:20.180 ⇒ 00:33:20.969 Uttam Kumaran: I see what you mean.
510 00:33:20.970 ⇒ 00:33:23.720 Nicolas Sucari: Because we have all of all of the costs are
511 00:33:23.880 ⇒ 00:33:25.280 Nicolas Sucari: should be like
512 00:33:25.570 ⇒ 00:33:30.660 Nicolas Sucari: negative value to them. But that’s fine. I mean, we can leave it as if.
513 00:33:32.080 ⇒ 00:33:32.420 Uttam Kumaran: Show you.
514 00:33:32.420 ⇒ 00:33:32.960 Nicolas Sucari: Nice to him.
515 00:33:34.170 ⇒ 00:33:34.860 Ryan Luke Daque: Yeah.
516 00:33:38.640 ⇒ 00:33:40.600 Uttam Kumaran: Let’s flip. Let’s just flip it, Ryan.
517 00:33:41.520 ⇒ 00:33:44.050 Ryan Luke Daque: You mean make it positive. The fees.
518 00:33:44.050 ⇒ 00:33:44.560 Uttam Kumaran: Yeah.
519 00:33:44.560 ⇒ 00:33:45.190 Nicolas Sucari: Yeah.
520 00:33:46.000 ⇒ 00:33:48.640 Ryan Luke Daque: So I guess we do that to all order items.
521 00:33:48.640 ⇒ 00:33:50.020 Uttam Kumaran: I don’t. I?
522 00:33:50.090 ⇒ 00:33:51.890 Uttam Kumaran: Yeah, I think.
523 00:33:52.080 ⇒ 00:33:52.670 Nicolas Sucari: Yeah.
524 00:33:52.950 ⇒ 00:33:54.130 Uttam Kumaran: I’m worried about doing that.
525 00:33:54.130 ⇒ 00:33:54.509 Nicolas Sucari: I mean, if.
526 00:33:54.510 ⇒ 00:33:57.949 Uttam Kumaran: Model, though in case it affects anything but you could just you could do.
527 00:33:57.950 ⇒ 00:33:58.590 Ryan Luke Daque: And do it.
528 00:33:58.590 ⇒ 00:33:59.270 Uttam Kumaran: Yeah.
529 00:33:59.270 ⇒ 00:34:01.790 Ryan Luke Daque: Yeah, we can do it in the in the rail model.
530 00:34:01.900 ⇒ 00:34:05.709 Ryan Luke Daque: or something like any change I will make
531 00:34:07.380 ⇒ 00:34:08.130 Ryan Luke Daque: from this.
532 00:34:08.139 ⇒ 00:34:09.169 Nicolas Sucari: Oh, we need to do something.
533 00:34:09.170 ⇒ 00:34:13.039 Ryan Luke Daque: On the real models, not on the data models.
534 00:34:14.460 ⇒ 00:34:15.370 Ryan Luke Daque: I guess.
535 00:34:17.379 ⇒ 00:34:22.049 Nicolas Sucari: For the let me see, I think it was for this one.
536 00:34:30.299 ⇒ 00:34:34.519 Nicolas Sucari: for these nodes. We should do it in the models right, or you should, or
537 00:34:36.019 ⇒ 00:34:41.279 Nicolas Sucari: or you. You’re saying you just will add it in the in the model for real. Only.
538 00:34:42.530 ⇒ 00:34:44.529 Ryan Luke Daque: Yeah, I think those need to be in the
539 00:34:44.730 ⇒ 00:34:46.469 Ryan Luke Daque: data models as well.
540 00:34:46.929 ⇒ 00:34:47.510 Ryan Luke Daque: I mean.
541 00:34:47.510 ⇒ 00:34:52.320 Nicolas Sucari: Yeah, because we said, we will need to add, add a new column right? Like this, you feel
542 00:34:52.989 ⇒ 00:34:56.129 Nicolas Sucari: that should be in the data tomorrow. But yeah, the other ones should be
543 00:34:56.170 ⇒ 00:34:58.129 Nicolas Sucari: okay if we do it on your rep.
544 00:34:59.260 ⇒ 00:34:59.850 Ryan Luke Daque: Okay.
545 00:35:01.285 ⇒ 00:35:01.819 Ryan Luke Daque: Yeah.
546 00:35:04.350 ⇒ 00:35:10.870 Nicolas Sucari: Okay. So daily, Kpis is okay. So we keep. We did the days as I mentioned, or we should add something else.
547 00:35:13.800 ⇒ 00:35:15.720 Nicolas Sucari: Or maybe we can like.
548 00:35:16.020 ⇒ 00:35:18.380 Nicolas Sucari: Remove the day, too.
549 00:35:19.120 ⇒ 00:35:21.919 Nicolas Sucari: I don’t know why today is important here.
550 00:35:29.990 ⇒ 00:35:30.800 Nicolas Sucari: Do you know what I’m.
551 00:35:30.800 ⇒ 00:35:36.340 Uttam Kumaran: The day is important. Oh, because sometimes they wanted to see like, how does things change based on the day.
552 00:35:38.110 ⇒ 00:35:38.560 Nicolas Sucari: Hmm.
553 00:35:38.560 ⇒ 00:35:43.060 Uttam Kumaran: I think the other thing that could be that could be great. Here Ryan, is actually to add
554 00:35:43.140 ⇒ 00:35:44.210 Uttam Kumaran: quarter.
555 00:35:45.100 ⇒ 00:35:48.659 Uttam Kumaran: It’s actually add quarter, which is like q, 1 q. 2, q. 3.
556 00:35:48.660 ⇒ 00:35:49.450 Ryan Luke Daque: A dimension.
557 00:35:49.450 ⇒ 00:35:50.200 Uttam Kumaran: Month.
558 00:35:50.310 ⇒ 00:35:51.260 Uttam Kumaran: Yeah.
559 00:35:53.250 ⇒ 00:36:00.479 Uttam Kumaran: not not so, Nico. This would be like, we want to look at how January performs versus May across.
560 00:36:00.480 ⇒ 00:36:01.230 Nicolas Sucari: Yeah, yeah, yeah.
561 00:36:01.230 ⇒ 00:36:02.000 Uttam Kumaran: Experience.
562 00:36:03.810 ⇒ 00:36:04.540 Nicolas Sucari: Totally.
563 00:36:06.860 ⇒ 00:36:11.060 Nicolas Sucari: Yeah, because the comparison won’t. It won’t let you compare something
564 00:36:11.140 ⇒ 00:36:12.330 Nicolas Sucari: different
565 00:36:13.370 ⇒ 00:36:16.299 Nicolas Sucari: like this. Oh, maybe custom. Yeah.
566 00:36:17.030 ⇒ 00:36:18.230 Nicolas Sucari: I can do.
567 00:36:18.500 ⇒ 00:36:21.439 Ryan Luke Daque: Like one week if you do it for one week, I guess.
568 00:36:25.620 ⇒ 00:36:27.239 Nicolas Sucari: Yeah, but it’s different
569 00:36:31.230 ⇒ 00:36:36.110 Nicolas Sucari: with the previous week. I can do one weekend. I don’t know April, everyone.
570 00:36:37.350 ⇒ 00:36:38.020 Nicolas Sucari: But
571 00:36:40.460 ⇒ 00:36:42.710 Nicolas Sucari: so you, we have the ability to do it
572 00:36:42.820 ⇒ 00:36:44.409 Nicolas Sucari: from here. But that’s okay.
573 00:36:44.560 ⇒ 00:36:46.470 Nicolas Sucari: I mean adding, the
574 00:36:47.070 ⇒ 00:36:48.739 Nicolas Sucari: the dimension will be easier
575 00:36:48.780 ⇒ 00:36:50.579 Nicolas Sucari: only for quarters. Maybe.
576 00:36:51.110 ⇒ 00:36:51.980 Ryan Luke Daque: And month.
577 00:36:55.200 ⇒ 00:36:55.900 Nicolas Sucari: Yeah.
578 00:36:57.080 ⇒ 00:36:59.150 Ryan Luke Daque: Maybe even a year, if if needed.
579 00:37:02.240 ⇒ 00:37:02.980 Ryan Luke Daque: Yep.
580 00:37:07.230 ⇒ 00:37:11.390 Uttam Kumaran: Yeah, I think, just yeah, yeah, exactly. Perfect. Yeah. Good point.
581 00:37:13.560 ⇒ 00:37:14.420 Uttam Kumaran: Okay.
582 00:37:14.420 ⇒ 00:37:15.160 Nicolas Sucari: Perfect.
583 00:37:15.940 ⇒ 00:37:16.810 Uttam Kumaran: Okay. Cool.
584 00:37:21.200 ⇒ 00:37:26.539 Nicolas Sucari: So let’s go back so then we have the 3 for direct mails.
585 00:37:27.900 ⇒ 00:37:30.489 Nicolas Sucari: order items, orders, and there is mail.
586 00:37:31.380 ⇒ 00:37:32.130 Ryan Luke Daque: Yeah.
587 00:37:42.410 ⇒ 00:37:43.440 Nicolas Sucari: These
588 00:37:43.470 ⇒ 00:37:47.019 Nicolas Sucari: order items, direct mail conversions for order items.
589 00:37:49.530 ⇒ 00:37:53.950 Nicolas Sucari: I think, on the following, on the next ones. We need to
590 00:37:54.180 ⇒ 00:37:58.860 Nicolas Sucari: maybe summarizing one in only one dashboard and not have 3.
591 00:38:00.870 ⇒ 00:38:02.160 Nicolas Sucari: Yeah.
592 00:38:02.160 ⇒ 00:38:04.259 Uttam Kumaran: Stuff is because one is like.
593 00:38:05.680 ⇒ 00:38:06.030 Nicolas Sucari: This is my.
594 00:38:06.030 ⇒ 00:38:08.759 Uttam Kumaran: One shows. One shows the items that are ordered.
595 00:38:11.330 ⇒ 00:38:14.630 Ryan Luke Daque: Like the all orders and all order items right?
596 00:38:15.510 ⇒ 00:38:17.860 Uttam Kumaran: I think it’s fine to keep it separate. I think
597 00:38:18.030 ⇒ 00:38:21.410 Uttam Kumaran: this one, though I don’t know how this is different than.
598 00:38:22.300 ⇒ 00:38:24.559 Nicolas Sucari: And New York call orders right?
599 00:38:24.560 ⇒ 00:38:25.410 Ryan Luke Daque: Yeah.
600 00:38:25.410 ⇒ 00:38:30.460 Uttam Kumaran: Yeah, like, we should get rid of this direct mail, because that the the direct mail of nothing
601 00:38:30.590 ⇒ 00:38:33.059 Uttam Kumaran: is is actually covered in combined marketing.
602 00:38:35.300 ⇒ 00:38:35.940 Nicolas Sucari: Okay.
603 00:38:36.550 ⇒ 00:38:37.480 Uttam Kumaran: You see what I mean?
604 00:38:38.810 ⇒ 00:38:40.150 Nicolas Sucari: Yeah, this one.
605 00:38:40.440 ⇒ 00:38:47.849 Nicolas Sucari: this information of direct mail and the campaigns and these metrics. It should be in the paper marketing performance.
606 00:38:48.090 ⇒ 00:38:49.020 Uttam Kumaran: Yeah.
607 00:38:49.830 ⇒ 00:38:51.130 Nicolas Sucari: Like, if we
608 00:38:51.210 ⇒ 00:38:56.850 Nicolas Sucari: select here direct mail, we should be looking at the same information that we have in the other one. Right?
609 00:38:57.570 ⇒ 00:38:58.300 Nicolas Sucari: Scratch.
610 00:38:59.890 ⇒ 00:39:02.879 Nicolas Sucari: That’s fine. Okay? So we can get rid of direct mail
611 00:39:02.940 ⇒ 00:39:05.499 Nicolas Sucari: and just keep orders and order items.
612 00:39:15.140 ⇒ 00:39:21.969 Ryan Luke Daque: Yeah, we can look at. Should we like be looking at the metrics and dimensions for order items and orders? Direct mail.
613 00:39:23.700 ⇒ 00:39:25.990 Ryan Luke Daque: Yeah, I just think, let’s let’s.
614 00:39:26.500 ⇒ 00:39:29.163 Uttam Kumaran: Yeah, let’s look at yeah, we should just do
615 00:39:31.500 ⇒ 00:39:34.059 Uttam Kumaran: total orders. Total customers.
616 00:39:34.790 ⇒ 00:39:37.630 Uttam Kumaran: total refund amount, total discount amount.
617 00:39:38.180 ⇒ 00:39:41.400 Uttam Kumaran: Yeah, I think this is fine. I think we should do average item
618 00:39:42.050 ⇒ 00:39:43.960 Uttam Kumaran: average items for order here.
619 00:39:48.938 ⇒ 00:39:50.170 Uttam Kumaran: And then I think.
620 00:39:50.170 ⇒ 00:39:51.300 Nicolas Sucari: Instead of these ones.
621 00:39:52.710 ⇒ 00:39:53.510 Uttam Kumaran: Yeah.
622 00:39:54.940 ⇒ 00:39:57.799 Ryan Luke Daque: Same as the average order price
623 00:39:57.850 ⇒ 00:39:59.470 Ryan Luke Daque: probably.
624 00:39:59.790 ⇒ 00:40:01.260 Uttam Kumaran: Well, no, that’s fine.
625 00:40:01.260 ⇒ 00:40:01.970 Ryan Luke Daque: Oh, yeah. Yeah.
626 00:40:01.970 ⇒ 00:40:07.329 Uttam Kumaran: Oh, that’s average. Well, that’s we should do average order value right? What do we call it? In the other one?
627 00:40:10.140 ⇒ 00:40:11.120 Ryan Luke Daque: We.
628 00:40:12.000 ⇒ 00:40:12.600 Nicolas Sucari: Here.
629 00:40:13.320 ⇒ 00:40:13.980 Ryan Luke Daque: Average.
630 00:40:15.973 ⇒ 00:40:18.740 Nicolas Sucari: Total or average total sales
631 00:40:23.640 ⇒ 00:40:24.890 Nicolas Sucari: like we
632 00:40:24.970 ⇒ 00:40:26.290 Nicolas Sucari: change something.
633 00:40:26.980 ⇒ 00:40:28.870 Ryan Luke Daque: No, it wasn’t.
634 00:40:29.800 ⇒ 00:40:31.739 Nicolas Sucari: Average items per order.
635 00:40:34.630 ⇒ 00:40:38.550 Nicolas Sucari: Total items sold. Okay, yeah. But these are not items. These are.
636 00:40:38.750 ⇒ 00:40:39.580 Ryan Luke Daque: Yes.
637 00:40:39.990 ⇒ 00:40:41.969 Ryan Luke Daque: So I guess that’s fine. Total
638 00:40:43.050 ⇒ 00:40:44.909 Ryan Luke Daque: average order price is fine.
639 00:40:45.800 ⇒ 00:40:46.500 Ryan Luke Daque: Yeah.
640 00:40:48.610 ⇒ 00:40:52.800 Nicolas Sucari: Because this one is orders. It’s not like order items. So that’s okay.
641 00:40:54.430 ⇒ 00:40:55.050 Ryan Luke Daque: Okay.
642 00:40:55.840 ⇒ 00:40:59.819 Ryan Luke Daque: but the average order quantity would be average or items per order.
643 00:40:59.820 ⇒ 00:41:01.460 Nicolas Sucari: Yeah, exactly.
644 00:41:02.850 ⇒ 00:41:05.010 Nicolas Sucari: Yeah. The average items per order.
645 00:41:05.010 ⇒ 00:41:05.620 Ryan Luke Daque: So I guess.
646 00:41:05.620 ⇒ 00:41:09.190 Nicolas Sucari: If we go to other items we should have the other ones.
647 00:41:09.930 ⇒ 00:41:10.610 Nicolas Sucari: Yep.
648 00:41:10.870 ⇒ 00:41:11.610 Nicolas Sucari: see.
649 00:41:13.610 ⇒ 00:41:18.579 Ryan Luke Daque: So 4 dimensions, I guess the same Ids would be at the last part. So it will
650 00:41:19.300 ⇒ 00:41:20.099 Ryan Luke Daque: was sorted.
651 00:41:20.100 ⇒ 00:41:20.780 Nicolas Sucari: Yeah.
652 00:41:20.780 ⇒ 00:41:23.520 Ryan Luke Daque: To have the names first.st I guess
653 00:41:23.890 ⇒ 00:41:24.879 Ryan Luke Daque: it’s a pro.
654 00:41:24.880 ⇒ 00:41:26.140 Uttam Kumaran: Yes.
655 00:41:30.470 ⇒ 00:41:34.279 Uttam Kumaran: so quick, so on the on the can you go to direct mail convergence orders?
656 00:41:34.680 ⇒ 00:41:36.375 Uttam Kumaran: I just one thing.
657 00:41:37.490 ⇒ 00:41:40.460 Uttam Kumaran: there’s order number, and we have order.
658 00:41:40.910 ⇒ 00:41:41.880 Uttam Kumaran: Id.
659 00:41:42.120 ⇒ 00:41:44.590 Uttam Kumaran: Let’s just keep the order number.
660 00:41:46.290 ⇒ 00:41:47.000 Ryan Luke Daque: Okay.
661 00:41:47.000 ⇒ 00:41:50.910 Uttam Kumaran: Cause. That’s that matches shopify, cause I think that’s what Kim uses.
662 00:41:51.380 ⇒ 00:41:53.179 Ryan Luke Daque: I don’t know what order Id is. Then.
663 00:41:53.790 ⇒ 00:41:56.040 Uttam Kumaran: Order id. So I mean on shopify. There’s 2.
664 00:41:56.873 ⇒ 00:41:59.790 Ryan Luke Daque: Like, order. Name, something. Yeah.
665 00:41:59.790 ⇒ 00:42:00.530 Uttam Kumaran: Yeah.
666 00:42:00.880 ⇒ 00:42:04.080 Uttam Kumaran: so scroll down a little bit. So this is fine.
667 00:42:07.070 ⇒ 00:42:08.630 Uttam Kumaran: for shipping city.
668 00:42:09.150 ⇒ 00:42:11.810 Uttam Kumaran: Can we do init cap for that?
669 00:42:12.670 ⇒ 00:42:13.360 Ryan Luke Daque: Okay.
670 00:42:13.540 ⇒ 00:42:18.500 Uttam Kumaran: Right cause. It’s so that we just get this a capitalization order. URL is fine.
671 00:42:20.120 ⇒ 00:42:23.096 Uttam Kumaran: This is all good.
672 00:42:25.960 ⇒ 00:42:31.999 Uttam Kumaran: can you look at the this is a small one. But look at the order status, there’s null. Can we figure out what that is?
673 00:42:32.780 ⇒ 00:42:36.400 Uttam Kumaran: I wonder if that’s like partially, or that’s fulfilled, or something I don’t know.
674 00:42:39.160 ⇒ 00:42:40.920 Uttam Kumaran: Yeah, I don’t know. Oh, it’s
675 00:42:42.000 ⇒ 00:42:45.889 Uttam Kumaran: it’s cancelled, but it’s not showing up in cancelled. Maybe I’m not sure.
676 00:42:48.590 ⇒ 00:42:50.529 Nicolas Sucari: It’s only one order, I think.
677 00:42:51.490 ⇒ 00:42:55.709 Uttam Kumaran: Yeah. But see, the refund reason says cancelled. But the order status.
678 00:42:55.840 ⇒ 00:42:56.900 Ryan Luke Daque: So I guess we can.
679 00:42:57.220 ⇒ 00:42:58.540 Ryan Luke Daque: I don’t know. Maybe there’s.
680 00:42:58.540 ⇒ 00:42:59.990 Uttam Kumaran: Make sure if there’s
681 00:43:00.580 ⇒ 00:43:01.510 Uttam Kumaran: yeah.
682 00:43:02.650 ⇒ 00:43:05.189 Uttam Kumaran: maybe it got shipped, and then I don’t know. Okay.
683 00:43:05.190 ⇒ 00:43:05.760 Ryan Luke Daque: Yeah.
684 00:43:05.760 ⇒ 00:43:06.970 Uttam Kumaran: Like. Take a look at that.
685 00:43:08.290 ⇒ 00:43:08.800 Ryan Luke Daque: Gotcha.
686 00:43:09.048 ⇒ 00:43:13.270 Uttam Kumaran: Okay, I think I’m good with this dashboard. Otherwise, like, this is pretty good. I think, like
687 00:43:13.360 ⇒ 00:43:19.819 Uttam Kumaran: Kim is, Kim is is like familiar with using data. So I’m not too worried about giving her too much of both.
688 00:43:22.920 ⇒ 00:43:23.570 Nicolas Sucari: Okay.
689 00:43:24.372 ⇒ 00:43:33.430 Nicolas Sucari: just a question the order number. If we’re gonna stick with this one. This is just getting data from shopify, right, not our
690 00:43:33.540 ⇒ 00:43:34.809 Nicolas Sucari: not our sources.
691 00:43:35.670 ⇒ 00:43:42.259 Uttam Kumaran: Yeah, we’re we’re only sending. Yeah, we’re not. We’re not sending direct mail through Amazon or anything. It’s all shopify.
692 00:43:43.000 ⇒ 00:43:44.450 Nicolas Sucari: Okay, perfect.
693 00:43:51.320 ⇒ 00:43:52.830 Nicolas Sucari: So 2 other items.
694 00:43:58.050 ⇒ 00:43:58.370 Ryan Luke Daque: Sorry.
695 00:43:58.370 ⇒ 00:43:58.949 Nicolas Sucari: Here. We’re at.
696 00:43:58.950 ⇒ 00:43:59.564 Uttam Kumaran: Done.
697 00:44:00.320 ⇒ 00:44:03.769 Uttam Kumaran: So yeah, on the measure side, total revenue from items.
698 00:44:03.860 ⇒ 00:44:08.299 Uttam Kumaran: Let’s just make that total revenue or total sales, or whatever we usually call that
699 00:44:09.560 ⇒ 00:44:13.699 Uttam Kumaran: same thing on average total price from items.
700 00:44:14.180 ⇒ 00:44:16.650 Uttam Kumaran: I think this that’s that may be average
701 00:44:17.100 ⇒ 00:44:20.030 Uttam Kumaran: item price. I’m not sure.
702 00:44:20.190 ⇒ 00:44:21.900 Nicolas Sucari: Average height in price. Yeah.
703 00:44:43.050 ⇒ 00:44:50.530 Nicolas Sucari: so how is this kind of possible to have like more refunds than order items or more refunds than
704 00:44:50.950 ⇒ 00:44:51.990 Nicolas Sucari: orders?
705 00:44:54.870 ⇒ 00:44:55.600 Ryan Luke Daque: Yeah.
706 00:44:55.600 ⇒ 00:44:58.009 Uttam Kumaran: Point I don’t know. Yeah.
707 00:45:01.160 ⇒ 00:45:05.889 Nicolas Sucari: Yeah. Or maybe we are sending like 2 products to each refund.
708 00:45:06.320 ⇒ 00:45:07.270 Nicolas Sucari: But.
709 00:45:07.270 ⇒ 00:45:09.649 Uttam Kumaran: I mean, so so refunds, yeah.
710 00:45:10.970 ⇒ 00:45:13.120 Uttam Kumaran: good point. Yeah, I’m not exactly sure.
711 00:45:18.190 ⇒ 00:45:20.560 Nicolas Sucari: This is just 3 months ago, but
712 00:45:21.230 ⇒ 00:45:22.070 Nicolas Sucari: seems weird.
713 00:45:22.070 ⇒ 00:45:24.650 Ryan Luke Daque: I wonder if total orders is no
714 00:45:24.730 ⇒ 00:45:26.480 Ryan Luke Daque: order
715 00:45:27.610 ⇒ 00:45:31.590 Ryan Luke Daque: id, and then total refunds is line item. But.
716 00:45:31.590 ⇒ 00:45:33.149 Uttam Kumaran: Oh, okay.
717 00:45:34.250 ⇒ 00:45:34.809 Nicolas Sucari: Believe we have.
718 00:45:34.810 ⇒ 00:45:35.350 Ryan Luke Daque: Still, so.
719 00:45:35.350 ⇒ 00:45:36.040 Nicolas Sucari: And.
720 00:45:36.040 ⇒ 00:45:37.480 Ryan Luke Daque: Oh, yeah. Yeah.
721 00:45:37.480 ⇒ 00:45:41.850 Nicolas Sucari: We have one. Yeah, we have here. It’s bigger than the the line items.
722 00:45:42.430 ⇒ 00:45:45.370 Ryan Luke Daque: Yeah, we’ll have to investigate that one.
723 00:45:47.770 ⇒ 00:45:52.170 Ryan Luke Daque: It looks like it’s like for July. There’s like a bike.
724 00:45:53.030 ⇒ 00:45:55.930 Ryan Luke Daque: Yeah, it’s even like per day. It doesn’t make sense.
725 00:45:56.790 ⇒ 00:45:57.610 Ryan Luke Daque: Yeah.
726 00:46:02.780 ⇒ 00:46:04.460 Ryan Luke Daque: yeah, it’s almost twice.
727 00:46:08.370 ⇒ 00:46:09.580 Ryan Luke Daque: Yeah. That’s.
728 00:46:09.580 ⇒ 00:46:13.330 Nicolas Sucari: Yeah, but it’s it’s something that was happening before, too. Because if you go
729 00:46:13.580 ⇒ 00:46:22.579 Nicolas Sucari: to April, April, you have to like double refunds per every per order items. So maybe it’s something we need to look at.
730 00:46:22.650 ⇒ 00:46:25.530 Nicolas Sucari: Yeah, yeah, maybe we are getting duplicates or something.
731 00:46:25.710 ⇒ 00:46:26.390 Ryan Luke Daque: Yeah.
732 00:46:28.720 ⇒ 00:46:29.380 Nicolas Sucari: Okay?
733 00:46:31.042 ⇒ 00:46:34.629 Nicolas Sucari: yeah. Dimensions. I think we can send all of the Ids
734 00:46:35.040 ⇒ 00:46:36.100 Nicolas Sucari: down
735 00:46:36.240 ⇒ 00:46:37.240 Nicolas Sucari: to the bottom.
736 00:46:37.470 ⇒ 00:46:40.159 Nicolas Sucari: We have the Expo pro drive
737 00:46:40.830 ⇒ 00:46:43.179 Nicolas Sucari: here. Do we need to?
738 00:46:45.144 ⇒ 00:46:46.999 Nicolas Sucari: Keep using this autumn?
739 00:46:47.240 ⇒ 00:46:53.000 Nicolas Sucari: I remember we talked about like segmenting and seeing how these different segments grow.
740 00:46:53.180 ⇒ 00:46:54.069 Nicolas Sucari: So maybe we need.
741 00:46:54.070 ⇒ 00:46:54.660 Uttam Kumaran: No, I think.
742 00:46:54.660 ⇒ 00:46:55.590 Nicolas Sucari: This one.
743 00:46:56.400 ⇒ 00:46:57.130 Nicolas Sucari: yeah.
744 00:46:57.130 ⇒ 00:47:00.269 Uttam Kumaran: Yeah, what do we have? So far? So we have all of them.
745 00:47:01.530 ⇒ 00:47:05.669 Uttam Kumaran: I think I think just leaving the leaving the final one that we decided on is, okay.
746 00:47:07.020 ⇒ 00:47:07.669 Nicolas Sucari: Yeah, we have to.
747 00:47:07.670 ⇒ 00:47:12.730 Uttam Kumaran: So actually, yeah, let’s let’s let’s leave it as derived. Because I also want to.
748 00:47:13.040 ⇒ 00:47:18.040 Uttam Kumaran: I wanna make sure that that’s cause. That’s what we agreed on before. So I think leaving is fine for now.
749 00:47:19.120 ⇒ 00:47:22.640 Uttam Kumaran: Okay, let’s see if it’s confusing for her. If she’s using it.
750 00:47:41.640 ⇒ 00:47:42.320 Nicolas Sucari: Okay.
751 00:47:42.890 ⇒ 00:47:44.220 Nicolas Sucari: yeah, I think these
752 00:47:45.160 ⇒ 00:47:46.700 Nicolas Sucari: these images are okay.
753 00:47:52.856 ⇒ 00:47:55.709 Nicolas Sucari: Next one is okay. So we we said.
754 00:47:55.890 ⇒ 00:47:59.899 Nicolas Sucari: Yeah, direct mail. We are, gonna get rid of it. Inventory matrix.
755 00:48:01.000 ⇒ 00:48:04.470 Nicolas Sucari: We’re we’re we’re not doing anything for
756 00:48:04.840 ⇒ 00:48:06.219 Nicolas Sucari: inventory, right?
757 00:48:06.890 ⇒ 00:48:07.760 Nicolas Sucari: Like we, we kind.
758 00:48:09.690 ⇒ 00:48:14.970 Uttam Kumaran: yeah, I don’t think I don’t know if this what is is there another one on inventory?
759 00:48:16.080 ⇒ 00:48:18.559 Nicolas Sucari: No. Yeah. Sold by State daily.
760 00:48:22.220 ⇒ 00:48:31.329 Uttam Kumaran: Yeah, I don’t know. I think we should maybe just hide these until they’re used like the inventories. Inventory metrics were supposed to be about unleash.
761 00:48:35.950 ⇒ 00:48:39.200 Uttam Kumaran: Yeah, let’s just hide both of these like I.
762 00:48:39.500 ⇒ 00:48:41.110 Uttam Kumaran: Let’s just hide these for now.
763 00:48:41.180 ⇒ 00:48:43.220 Uttam Kumaran: or remove the dashboards.
764 00:48:44.150 ⇒ 00:48:44.820 Nicolas Sucari: Yeah.
765 00:48:45.430 ⇒ 00:48:47.249 Uttam Kumaran: And we can come back to this once we’re
766 00:48:47.410 ⇒ 00:48:49.230 Uttam Kumaran: once we get to this point again.
767 00:48:53.310 ⇒ 00:48:56.240 Ryan Luke Daque: Same as inventory sold by state. I guess.
768 00:48:56.240 ⇒ 00:48:56.670 Nicolas Sucari: Yeah, yeah.
769 00:48:56.670 ⇒ 00:48:57.230 Uttam Kumaran: Yeah.
770 00:48:57.610 ⇒ 00:48:58.220 Nicolas Sucari: Yeah.
771 00:49:03.580 ⇒ 00:49:06.410 Nicolas Sucari: Then we have Kim’s weekly report.
772 00:49:14.010 ⇒ 00:49:15.720 Uttam Kumaran: Okay, what do you guys think about this one?
773 00:49:17.360 ⇒ 00:49:20.260 Uttam Kumaran: I think this is seems fine. If she’s okay with this.
774 00:49:21.800 ⇒ 00:49:22.560 Nicolas Sucari: Yeah.
775 00:49:23.070 ⇒ 00:49:24.120 Nicolas Sucari: I mean, so.
776 00:49:24.120 ⇒ 00:49:26.950 Uttam Kumaran: What is per what is purchases, and
777 00:49:27.210 ⇒ 00:49:29.819 Uttam Kumaran: and it’s got to see a decimal point. So.
778 00:49:32.760 ⇒ 00:49:33.699 Ryan Luke Daque: Yes, that’s conversion.
779 00:49:33.700 ⇒ 00:49:34.330 Nicolas Sucari: Perfect.
780 00:49:34.880 ⇒ 00:49:35.480 Nicolas Sucari: Yeah.
781 00:49:35.480 ⇒ 00:49:36.110 Uttam Kumaran: Like, how can you have.
782 00:49:36.110 ⇒ 00:49:36.930 Nicolas Sucari: Something definitely.
783 00:49:36.930 ⇒ 00:49:38.110 Uttam Kumaran: Conversion, really.
784 00:49:38.720 ⇒ 00:49:45.719 Nicolas Sucari: Yeah, because it’s coming from Facebook. So Facebook maybe names the conversion as purchases. And we’re bringing it like that. But maybe we should.
785 00:49:46.024 ⇒ 00:49:49.980 Uttam Kumaran: Purchase can’t be like ha! You can’t have half a purchase right? So.
786 00:49:50.990 ⇒ 00:49:57.210 Ryan Luke Daque: Yeah. But in Facebook, I think they they have like decimal points in the conversions. I’m not sure why. But maybe it’s like.
787 00:49:58.190 ⇒ 00:49:59.710 Uttam Kumaran: Oh, really. Okay.
788 00:49:59.710 ⇒ 00:50:03.449 Ryan Luke Daque: Yeah, has something to do with attribution or something. I don’t know.
789 00:50:04.720 ⇒ 00:50:08.329 Uttam Kumaran: Okay. Okay? Then it’s fine. As long as she’s aware of that. Then.
790 00:50:09.820 ⇒ 00:50:11.420 Nicolas Sucari: Yeah, maybe we can rename.
791 00:50:11.530 ⇒ 00:50:13.779 Nicolas Sucari: Yeah, we can rename it to conversions.
792 00:50:14.410 ⇒ 00:50:17.070 Nicolas Sucari: And we need to. Let’s see.
793 00:50:17.390 ⇒ 00:50:21.400 Nicolas Sucari: we were talking about last previous, not complete.
794 00:50:22.352 ⇒ 00:50:29.889 Nicolas Sucari: Maybe we will need to like. See if we are getting the correct information here, Ryan, with what you are trying to
795 00:50:30.290 ⇒ 00:50:31.980 Nicolas Sucari: work on now, right.
796 00:50:32.890 ⇒ 00:50:33.600 Ryan Luke Daque: Right.
797 00:50:38.920 ⇒ 00:50:40.730 Nicolas Sucari: Because if this is at the ad
798 00:50:40.970 ⇒ 00:50:45.030 Nicolas Sucari: level, as we were seeing before, this is wrong too right.
799 00:50:45.260 ⇒ 00:50:45.880 Ryan Luke Daque: Yeah.
800 00:50:55.430 ⇒ 00:50:56.483 Nicolas Sucari: I think.
801 00:50:57.110 ⇒ 00:50:59.780 Nicolas Sucari: yeah. Kim uses this for cost.
802 00:51:00.690 ⇒ 00:51:04.879 Nicolas Sucari: First.st But yeah, we should review everything.
803 00:51:06.600 ⇒ 00:51:07.210 Ryan Luke Daque: Okay.
804 00:51:13.280 ⇒ 00:51:16.769 Nicolas Sucari: Yeah, because we have opt outs that are only by email.
805 00:51:34.530 ⇒ 00:51:42.530 Nicolas Sucari: Is it okay to show all of these metrics, even though if you go to the average open rate if it’s only for emails and.
806 00:51:44.070 ⇒ 00:51:44.920 Uttam Kumaran: Yeah, that’s fine.
807 00:51:44.920 ⇒ 00:51:45.950 Nicolas Sucari: Want or empty.
808 00:51:45.950 ⇒ 00:51:46.490 Uttam Kumaran: Yeah, yeah.
809 00:51:46.490 ⇒ 00:51:47.210 Nicolas Sucari: Okay, because this is.
810 00:51:47.210 ⇒ 00:51:50.939 Uttam Kumaran: Combined. So we’re always gonna have, like some type of mismatch.
811 00:51:50.990 ⇒ 00:51:54.240 Uttam Kumaran: I just wanted to make sure she has everything for her report
812 00:51:54.260 ⇒ 00:51:58.300 Uttam Kumaran: cause. This is more like we’re configuring it, based on the requirements she gave. You know.
813 00:51:58.500 ⇒ 00:52:04.700 Ryan Luke Daque: Yeah, cause this was initially, she was doing it manually through Google sheets, right? Like for each of the Channel. And then.
814 00:52:04.700 ⇒ 00:52:05.410 Uttam Kumaran: Yeah.
815 00:52:05.410 ⇒ 00:52:07.039 Ryan Luke Daque: This was supposed to be like.
816 00:52:08.130 ⇒ 00:52:10.249 Ryan Luke Daque: so she doesn’t have to do it manually.
817 00:52:13.420 ⇒ 00:52:15.979 Nicolas Sucari: Okay, okay, so let’s keep this one.
818 00:52:18.570 ⇒ 00:52:23.970 Nicolas Sucari: Then we have this one, the marketing performance, the one that we are talking about most.
819 00:52:24.320 ⇒ 00:52:25.090 Ryan Luke Daque: Yeah.
820 00:52:28.720 ⇒ 00:52:30.530 Ryan Luke Daque: there, anything we need to
821 00:52:30.570 ⇒ 00:52:32.140 Ryan Luke Daque: change here.
822 00:52:33.290 ⇒ 00:52:36.699 Uttam Kumaran: Campaign, name, campaign, id platform.
823 00:52:38.270 ⇒ 00:52:38.949 Uttam Kumaran: and I mean.
824 00:52:38.950 ⇒ 00:52:39.810 Nicolas Sucari: Streaming platform.
825 00:52:39.810 ⇒ 00:52:40.520 Uttam Kumaran: Same
826 00:52:44.930 ⇒ 00:52:47.050 Uttam Kumaran: impressions. Conversion rate.
827 00:52:47.230 ⇒ 00:52:50.890 Uttam Kumaran: Okay, so here’s 1 thing, conversion rate looks really
828 00:52:51.540 ⇒ 00:52:53.200 Uttam Kumaran: weird, like.
829 00:52:53.430 ⇒ 00:52:53.880 Ryan Luke Daque: Yeah.
830 00:52:54.330 ⇒ 00:52:55.030 Nicolas Sucari: Okay.
831 00:52:56.260 ⇒ 00:52:59.051 Uttam Kumaran: So let’s look at that. Let’s look at
832 00:53:04.390 ⇒ 00:53:08.130 Uttam Kumaran: cost per click. Cpm, if you scroll down Cpa
833 00:53:08.250 ⇒ 00:53:10.590 Uttam Kumaran: revenue realize.
834 00:53:14.560 ⇒ 00:53:23.039 Uttam Kumaran: I think this is this, I think from like a data standpoint, looks good, meaning like, you know, there’s not like any issues. I think I want to just know
835 00:53:23.230 ⇒ 00:53:26.940 Uttam Kumaran: that the numbers line up to what Kim is saying. That’s it.
836 00:53:27.400 ⇒ 00:53:27.930 Ryan Luke Daque: That’s.
837 00:53:27.930 ⇒ 00:53:29.499 Nicolas Sucari: And that’s what we are trying to.
838 00:53:29.500 ⇒ 00:53:30.520 Uttam Kumaran: Yeah, so, yeah.
839 00:53:30.520 ⇒ 00:53:31.190 Nicolas Sucari: Exactly.
840 00:53:31.630 ⇒ 00:53:37.273 Nicolas Sucari: Yeah, because here we’re showing revenue. And we don’t have revenue for Facebook, Amazon and Google. So this is
841 00:53:39.090 ⇒ 00:53:40.580 Nicolas Sucari: an issue. Maybe we
842 00:53:40.650 ⇒ 00:53:44.840 Nicolas Sucari: can’t get it. But yeah, I mean, we’re trying to investigate that.
843 00:53:52.730 ⇒ 00:53:53.490 Nicolas Sucari: Okay.
844 00:53:55.155 ⇒ 00:54:00.264 Nicolas Sucari: Then we have the return on refunds, model metrics. This one was
845 00:54:01.480 ⇒ 00:54:03.470 Nicolas Sucari: something that we just
846 00:54:03.480 ⇒ 00:54:09.499 Nicolas Sucari: add it here for because we have this one in evidence, and we wanna like
847 00:54:09.600 ⇒ 00:54:10.860 Nicolas Sucari: add it here.
848 00:54:11.570 ⇒ 00:54:15.779 Nicolas Sucari: We just bring brought that query to here.
849 00:54:17.820 ⇒ 00:54:18.310 Ryan Luke Daque: I.
850 00:54:18.310 ⇒ 00:54:19.319 Nicolas Sucari: Created this one.
851 00:54:19.610 ⇒ 00:54:23.170 Nicolas Sucari: but I don’t know if they are using it or not.
852 00:54:25.980 ⇒ 00:54:26.670 Ryan Luke Daque: Okay.
853 00:54:27.470 ⇒ 00:54:28.599 Ryan Luke Daque: see? This might.
854 00:54:28.600 ⇒ 00:54:30.220 Uttam Kumaran: The return refund
855 00:54:30.410 ⇒ 00:54:33.750 Uttam Kumaran: we can. Let’s can we rename this to something better?
856 00:54:34.680 ⇒ 00:54:35.390 Uttam Kumaran: Yep.
857 00:54:37.530 ⇒ 00:54:42.060 Uttam Kumaran: you just say we can say, return and refunds, returns and refunds.
858 00:54:42.400 ⇒ 00:54:48.440 Uttam Kumaran: I think this is fine. I mean, let’s look at the total amount. Okay, so for this. So on the left side.
859 00:54:48.590 ⇒ 00:54:50.269 Uttam Kumaran: some of these need to be numbers.
860 00:54:50.660 ⇒ 00:54:51.954 Uttam Kumaran: Some of these need to be
861 00:54:52.520 ⇒ 00:54:53.430 Uttam Kumaran: dollar signs.
862 00:54:53.430 ⇒ 00:54:54.479 Ryan Luke Daque: So there’s science. Yeah.
863 00:54:54.480 ⇒ 00:54:56.260 Uttam Kumaran: Refund amount on average.
864 00:54:57.320 ⇒ 00:54:59.940 Uttam Kumaran: average, refund amount.
865 00:54:59.940 ⇒ 00:55:05.970 Ryan Luke Daque: Anything that’s amount or like price should be, should have should have a dollar sign like sale price.
866 00:55:06.350 ⇒ 00:55:10.539 Uttam Kumaran: Yeah. And then there’s also like total item, sale price versus.
867 00:55:10.970 ⇒ 00:55:13.550 Uttam Kumaran: So these are things where it’s like, I want to know, like.
868 00:55:14.900 ⇒ 00:55:17.030 Uttam Kumaran: do some of these need to be here, basically.
869 00:55:19.630 ⇒ 00:55:26.149 Ryan Luke Daque: And I guess, like same with others like we should just be filtering until days closed
870 00:55:26.190 ⇒ 00:55:29.529 Ryan Luke Daque: and like the cost, the dimension for customer email like
871 00:55:29.910 ⇒ 00:55:32.490 Ryan Luke Daque: the blacks. And the nose should be like one.
872 00:55:33.800 ⇒ 00:55:36.380 Ryan Luke Daque: And yeah, and just seem like the others.
873 00:55:36.880 ⇒ 00:55:42.640 Ryan Luke Daque: Yeah, the percent would be percentage instead of like the percent sales refund metric there
874 00:55:42.810 ⇒ 00:55:44.890 Ryan Luke Daque: should be in percentage right.
875 00:55:45.270 ⇒ 00:55:45.730 Uttam Kumaran: Practicing.
876 00:55:45.730 ⇒ 00:55:46.190 Nicolas Sucari: Yeah.
877 00:55:46.190 ⇒ 00:55:46.820 Ryan Luke Daque: Yeah.
878 00:55:47.070 ⇒ 00:55:49.320 Uttam Kumaran: And it’s probably not 100%.
879 00:55:49.990 ⇒ 00:55:50.380 Ryan Luke Daque: That’s pretty.
880 00:55:50.380 ⇒ 00:55:52.030 Uttam Kumaran: Probably, like, yeah.
881 00:55:54.730 ⇒ 00:55:55.620 Ryan Luke Daque: Yeah.
882 00:55:58.490 ⇒ 00:56:02.220 Nicolas Sucari: You see, this is what we were so we were saying before.
883 00:56:02.220 ⇒ 00:56:04.380 Ryan Luke Daque: Like more refunds and orders.
884 00:56:04.970 ⇒ 00:56:13.470 Nicolas Sucari: Yeah. Yeah. And the metric is like, like, the measure is is weird because it says the percentage of total sales refunded to customers. So we are refunding.
885 00:56:13.470 ⇒ 00:56:14.440 Ryan Luke Daque: And it move her.
886 00:56:14.840 ⇒ 00:56:16.069 Nicolas Sucari: Orders, and
887 00:56:16.650 ⇒ 00:56:17.783 Nicolas Sucari: like, Yeah,
888 00:56:18.350 ⇒ 00:56:18.670 Ryan Luke Daque: Yeah.
889 00:56:18.670 ⇒ 00:56:20.990 Nicolas Sucari: Exist. So that’s kind of weird.
890 00:56:21.910 ⇒ 00:56:22.459 Ryan Luke Daque: We have to look.
891 00:56:22.460 ⇒ 00:56:30.219 Uttam Kumaran: Yeah, it should be, you know, it should be like, I don’t know 10 to 20%, right? Like how much. That’s what we’re trying to look for. So those are things where, like, we know the numbers off?
892 00:56:30.250 ⇒ 00:56:32.320 Uttam Kumaran: Yeah, they’re trying to figure out, yeah.
893 00:56:33.800 ⇒ 00:56:34.599 Nicolas Sucari: Yeah. And then on the name.
894 00:56:34.600 ⇒ 00:56:35.050 Ryan Luke Daque: And she’ll say.
895 00:56:35.050 ⇒ 00:56:42.219 Nicolas Sucari: Do you think we can clean the stuff that we already talked about modified products? Can you just keep one.
896 00:56:42.410 ⇒ 00:56:43.060 Ryan Luke Daque: Yeah.
897 00:56:43.060 ⇒ 00:56:43.400 Uttam Kumaran: Yeah.
898 00:56:43.400 ⇒ 00:56:44.170 Nicolas Sucari: Both.
899 00:56:46.123 ⇒ 00:56:48.139 Nicolas Sucari: Do something with the noels.
900 00:56:49.710 ⇒ 00:56:50.689 Nicolas Sucari: but yeah.
901 00:56:51.340 ⇒ 00:56:51.950 Ryan Luke Daque: Cool.
902 00:56:55.140 ⇒ 00:56:57.240 Uttam Kumaran: Okay, great. And then.
903 00:56:58.220 ⇒ 00:57:03.969 Uttam Kumaran: yeah. Warehouse still. Oh, so some of these are going to be refunds where we don’t know where it shipped from. Oh.
904 00:57:04.160 ⇒ 00:57:04.830 Nicolas Sucari: Sorry.
905 00:57:05.660 ⇒ 00:57:09.920 Uttam Kumaran: So, yeah, maybe just like, yeah, I think I think some of these are the kind of some of the same issues. But
906 00:57:10.890 ⇒ 00:57:11.690 Uttam Kumaran: yeah.
907 00:57:14.340 ⇒ 00:57:14.880 Ryan Luke Daque: Okay.
908 00:57:16.450 ⇒ 00:57:18.440 Nicolas Sucari: Yeah, we have the shipment services here.
909 00:57:18.540 ⇒ 00:57:20.389 Nicolas Sucari: We don’t have that before.
910 00:57:20.830 ⇒ 00:57:29.519 Nicolas Sucari: But that’s okay. I mean, we can just change the order. Bring the warehouse a little bit upper on this dimensions.
911 00:57:29.570 ⇒ 00:57:31.160 Nicolas Sucari: and get, like the
912 00:57:33.570 ⇒ 00:57:35.709 Nicolas Sucari: more important dimensions to the top
913 00:57:35.910 ⇒ 00:57:38.609 Nicolas Sucari: like selling platform fulfillment channel
914 00:57:38.850 ⇒ 00:57:39.970 Nicolas Sucari: skew.
915 00:57:40.400 ⇒ 00:57:42.510 Nicolas Sucari: maybe product name per class.
916 00:57:44.720 ⇒ 00:57:46.290 Nicolas Sucari: source. Maybe
917 00:57:46.550 ⇒ 00:57:47.360 Nicolas Sucari: I don’t know
918 00:57:50.310 ⇒ 00:57:51.980 Nicolas Sucari: on the shipping information.
919 00:57:58.350 ⇒ 00:57:59.190 Nicolas Sucari: Hey, Rick?
920 00:58:02.610 ⇒ 00:58:03.770 Uttam Kumaran: Okay, that makes sense.
921 00:58:05.430 ⇒ 00:58:06.860 Nicolas Sucari: Go to shipments
922 00:58:15.230 ⇒ 00:58:20.289 Nicolas Sucari: so total shipping amount will be total shipping cost or.
923 00:58:21.990 ⇒ 00:58:23.860 Uttam Kumaran: Yeah, we could do total shipping cost.
924 00:58:24.820 ⇒ 00:58:29.240 Nicolas Sucari: So that we can match that with the Daily Kpi that.
925 00:58:29.240 ⇒ 00:58:29.660 Uttam Kumaran: Yeah.
926 00:58:29.660 ⇒ 00:58:32.570 Nicolas Sucari: Where we have costs. And yeah, okay.
927 00:58:32.800 ⇒ 00:58:33.380 Ryan Luke Daque: Right?
928 00:58:37.970 ⇒ 00:58:38.830 Ryan Luke Daque: So that’s.
929 00:58:38.830 ⇒ 00:58:39.839 Nicolas Sucari: Shipments is, okay.
930 00:58:40.500 ⇒ 00:58:43.740 Nicolas Sucari: average shipping zone. I think this is okay. Right?
931 00:58:45.140 ⇒ 00:58:46.830 Ryan Luke Daque: What’s average shipping zone.
932 00:58:48.230 ⇒ 00:58:49.639 Nicolas Sucari: So, depending on
933 00:58:49.710 ⇒ 00:58:55.989 Nicolas Sucari: where we are, from which warehouse we are shipping. We have different zones across the Us. And this is like the average.
934 00:58:56.740 ⇒ 00:58:57.330 Nicolas Sucari: Go.
935 00:58:57.330 ⇒ 00:58:59.840 Uttam Kumaran: Amigo. Can you actually look at that over the last year?
936 00:59:00.240 ⇒ 00:59:02.929 Uttam Kumaran: So we should. That should be going down.
937 00:59:02.930 ⇒ 00:59:05.009 Nicolas Sucari: Yeah, exactly. That was
938 00:59:05.140 ⇒ 00:59:09.919 Nicolas Sucari: what I was trying to figure out, but it doesn’t seem to be going down.
939 00:59:10.310 ⇒ 00:59:15.639 Nicolas Sucari: However. No, no, yeah. But we have the issue here that we are not bringing the information from.
940 00:59:15.640 ⇒ 00:59:16.720 Uttam Kumaran: Yeah, yeah, yeah.
941 00:59:16.720 ⇒ 00:59:17.370 Nicolas Sucari: Yet.
942 00:59:17.370 ⇒ 00:59:18.040 Uttam Kumaran: Yeah.
943 00:59:19.960 ⇒ 00:59:22.459 Nicolas Sucari: But yeah, it should be going down.
944 00:59:24.420 ⇒ 00:59:27.119 Nicolas Sucari: This is here today. Then let’s see.
945 00:59:27.580 ⇒ 00:59:29.550 Nicolas Sucari: Last 24 months, maybe.
946 00:59:30.760 ⇒ 00:59:31.700 Nicolas Sucari: Hmm.
947 00:59:34.630 ⇒ 00:59:35.380 Ryan Luke Daque: This look like.
948 00:59:35.380 ⇒ 00:59:36.723 Nicolas Sucari: It’s not going down.
949 00:59:37.060 ⇒ 00:59:38.959 Ryan Luke Daque: It’s it’s it’s just, you know.
950 00:59:39.670 ⇒ 00:59:50.530 Nicolas Sucari: We, we should be like when once we bring the new information from the 2 new warehouses. These these lines should clearly go down right.
951 00:59:50.590 ⇒ 00:59:52.429 Nicolas Sucari: like we should see the trend
952 00:59:52.880 ⇒ 00:59:53.840 Nicolas Sucari: going down.
953 00:59:55.950 ⇒ 00:59:57.620 Nicolas Sucari: Let’s hope that happens.
954 01:00:00.000 ⇒ 01:00:00.820 Nicolas Sucari: Okay.
955 01:00:02.380 ⇒ 01:00:08.450 Nicolas Sucari: but we we you see here we have the average shipping cost per order, and it’s decreasing a little bit.
956 01:00:09.120 ⇒ 01:00:10.310 Nicolas Sucari: So maybe
957 01:00:10.870 ⇒ 01:00:12.640 Nicolas Sucari: this is something that we can.
958 01:00:13.220 ⇒ 01:00:14.610 Nicolas Sucari: Yeah, also show.
959 01:00:15.920 ⇒ 01:00:16.870 Nicolas Sucari: You see.
960 01:00:17.580 ⇒ 01:00:18.250 Ryan Luke Daque: Yeah.
961 01:00:23.610 ⇒ 01:00:26.780 Nicolas Sucari: Total orders, average order items per shipment
962 01:00:27.460 ⇒ 01:00:30.229 Nicolas Sucari: at least. Okay, average order quantity.
963 01:00:32.520 ⇒ 01:00:34.890 Nicolas Sucari: So this is items per order.
964 01:00:35.230 ⇒ 01:00:38.519 Ryan Luke Daque: Yeah, so average boy and.
965 01:00:41.080 ⇒ 01:00:43.210 Nicolas Sucari: Latest ship date.
966 01:00:43.680 ⇒ 01:00:45.529 Nicolas Sucari: Okay, these should be also.
967 01:00:45.980 ⇒ 01:00:46.620 Nicolas Sucari: I guess
968 01:00:48.660 ⇒ 01:00:49.780 Nicolas Sucari: this one. Okay.
969 01:00:49.780 ⇒ 01:00:52.291 Uttam Kumaran: Yeah, let’s get rid of that.
970 01:00:56.020 ⇒ 01:00:57.139 Uttam Kumaran: I think we don’t.
971 01:00:57.140 ⇒ 01:00:58.170 Nicolas Sucari: Have here.
972 01:00:58.640 ⇒ 01:01:12.830 Nicolas Sucari: Yeah, we, I think we need to add the the weight and the other measures that we’ve seen in the dashboard. I don’t know which ones average weight and average length. I think I don’t know where they were. I think it were in our all other items.
973 01:01:13.440 ⇒ 01:01:14.950 Nicolas Sucari: Hello! There! Let me check.
974 01:01:14.950 ⇒ 01:01:15.750 Ryan Luke Daque: Orders.
975 01:01:16.070 ⇒ 01:01:17.140 Nicolas Sucari: Yeah, this one
976 01:01:17.610 ⇒ 01:01:20.180 Nicolas Sucari: average product, weight and total product weight.
977 01:01:20.270 ⇒ 01:01:21.519 Nicolas Sucari: Yeah, these 2,
978 01:01:23.360 ⇒ 01:01:26.059 Nicolas Sucari: we should add that here in shipments.
979 01:01:26.560 ⇒ 01:01:27.170 Ryan Luke Daque: Okay.
980 01:01:28.150 ⇒ 01:01:31.170 Ryan Luke Daque: because we’re removing that there in the old orders. Right?
981 01:01:33.570 ⇒ 01:01:34.140 Nicolas Sucari: Yeah.
982 01:01:39.290 ⇒ 01:01:39.850 Ryan Luke Daque: Okay.
983 01:01:42.540 ⇒ 01:01:46.580 Nicolas Sucari: Mexico shipping zone. Yeah, I think the dimensions are
984 01:01:46.590 ⇒ 01:01:47.740 Nicolas Sucari: are looking good.
985 01:01:48.830 ⇒ 01:01:54.179 Ryan Luke Daque: Yeah, but like same with others like ids should be like moved further down. I guess.
986 01:01:54.180 ⇒ 01:01:55.620 Nicolas Sucari: Yeah, just
987 01:01:55.630 ⇒ 01:02:01.230 Nicolas Sucari: well, I don’t know even these ones. Because these ones, if you wanna look into
988 01:02:01.590 ⇒ 01:02:04.890 Nicolas Sucari: well, yeah, I think, yes, that’s okay. We can move them down.
989 01:02:04.990 ⇒ 01:02:09.049 Nicolas Sucari: Yeah, maybe we can bring up warehouse like to have it first.st
990 01:02:09.050 ⇒ 01:02:10.080 Ryan Luke Daque: Yeah, okay.
991 01:02:10.572 ⇒ 01:02:12.050 Nicolas Sucari: And maybe source.
992 01:02:12.860 ⇒ 01:02:13.850 Nicolas Sucari: And
993 01:02:14.590 ⇒ 01:02:18.109 Nicolas Sucari: yeah, warehouse on source. Let’s move. Move that up.
994 01:02:18.610 ⇒ 01:02:20.950 Nicolas Sucari: Maybe that’s more interesting
995 01:02:21.020 ⇒ 01:02:22.050 Nicolas Sucari: for Chuck
996 01:02:22.360 ⇒ 01:02:24.150 Nicolas Sucari: and the shipping zone. Maybe.
997 01:02:24.420 ⇒ 01:02:25.120 Nicolas Sucari: Yeah.
998 01:02:27.030 ⇒ 01:02:27.870 Nicolas Sucari: Okay.
999 01:02:29.640 ⇒ 01:02:31.669 Nicolas Sucari: then we have shopify customers.
1000 01:02:34.830 ⇒ 01:02:42.059 Nicolas Sucari: This one has everything that all this is the we use this dashboard to do all of the analysis for the full pros.
1001 01:02:42.730 ⇒ 01:02:43.750 Nicolas Sucari: I don’t know.
1002 01:02:43.750 ⇒ 01:02:44.149 Uttam Kumaran: You know.
1003 01:02:44.150 ⇒ 01:02:44.730 Nicolas Sucari: To.
1004 01:02:45.370 ⇒ 01:02:48.339 Uttam Kumaran: Yeah. The note on the bottom left. We can get rid of that.
1005 01:02:50.010 ⇒ 01:02:51.000 Uttam Kumaran: No, there’s no.
1006 01:02:51.000 ⇒ 01:02:51.930 Ryan Luke Daque: Okay.
1007 01:02:51.930 ⇒ 01:02:53.949 Uttam Kumaran: And also the country looks like
1008 01:02:54.530 ⇒ 01:02:56.820 Uttam Kumaran: we probably should just remove the country.
1009 01:02:58.010 ⇒ 01:02:59.590 Uttam Kumaran: It was only us.
1010 01:03:01.320 ⇒ 01:03:01.940 Ryan Luke Daque: Okay.
1011 01:03:04.230 ⇒ 01:03:13.849 Nicolas Sucari: But do do we need to to keep this dashboard like who who is like only looking at shopify customers and not about like orders?
1012 01:03:13.850 ⇒ 01:03:14.360 Uttam Kumaran: I think it’s.
1013 01:03:14.360 ⇒ 01:03:15.130 Nicolas Sucari: Monitoring.
1014 01:03:15.130 ⇒ 01:03:20.230 Uttam Kumaran: Yeah. Well, I think it’s on the customer side. We wanna look at who they are, where they’re coming from.
1015 01:03:20.320 ⇒ 01:03:23.829 Uttam Kumaran: And if there’s anything dynamic based on the customer dimensions. Right?
1016 01:03:24.110 ⇒ 01:03:25.450 Uttam Kumaran: So right now.
1017 01:03:25.540 ⇒ 01:03:32.669 Uttam Kumaran: you know, we we do have like we do have. If they’re pool pro. But when we do some attribution it’ll be helpful to look at like.
1018 01:03:33.100 ⇒ 01:03:34.040 Uttam Kumaran: Where are the customers?
1019 01:03:34.040 ⇒ 01:03:35.420 Nicolas Sucari: Okay, it’s coming.
1020 01:03:35.710 ⇒ 01:03:38.309 Uttam Kumaran: I think it’s helpful just to have this here
1021 01:03:38.824 ⇒ 01:03:41.115 Uttam Kumaran: but, like again, I want it. I want to.
1022 01:03:41.950 ⇒ 01:03:46.500 Uttam Kumaran: make sure that it’s not duplicating other stuff we have. But again, let’s say, you want to look at
1023 01:03:46.530 ⇒ 01:03:51.110 Uttam Kumaran: pool pros and the order values associated, or where the cus, like.
1024 01:03:51.110 ⇒ 01:03:52.519 Nicolas Sucari: Yeah, that’s fine.
1025 01:03:52.750 ⇒ 01:03:55.069 Uttam Kumaran: How many customers are in a certain state.
1026 01:04:00.620 ⇒ 01:04:01.490 Uttam Kumaran: Okay.
1027 01:04:04.110 ⇒ 01:04:12.500 Nicolas Sucari: And this we have only these for shopify. Why don’t we try getting like the information from Amazon, or it’s not worth it.
1028 01:04:14.762 ⇒ 01:04:17.910 Uttam Kumaran: Say it again. Oh, yeah. Cause Amazon, we don’t get anything. Actually.
1029 01:04:18.090 ⇒ 01:04:19.540 Uttam Kumaran: we don’t even get email. Okay.
1030 01:04:21.260 ⇒ 01:04:22.040 Uttam Kumaran: So.
1031 01:04:22.820 ⇒ 01:04:32.730 Nicolas Sucari: That’s fine. Okay, yeah. I was trying that that. I mean, that’s fine, like this is a dashboard to see all of the information on the customers where we can. But if we have on Amazon
1032 01:04:32.910 ⇒ 01:04:35.020 Nicolas Sucari: information and we don’t.
1033 01:04:35.300 ⇒ 01:04:39.069 Nicolas Sucari: we’re not able to get it. That’s okay. I mean, we stick to shopify.
1034 01:04:45.030 ⇒ 01:04:45.850 Nicolas Sucari: Okay.
1035 01:04:46.950 ⇒ 01:04:52.479 Nicolas Sucari: so here we have total sales. Total listing customers think this one is okay to have here
1036 01:04:55.650 ⇒ 01:04:58.659 Nicolas Sucari: total orders, total order items.
1037 01:05:01.450 ⇒ 01:05:06.019 Nicolas Sucari: This one, we should rename it. As we said before, average quantity priorities is.
1038 01:05:06.020 ⇒ 01:05:06.380 Ryan Luke Daque: Items.
1039 01:05:06.380 ⇒ 01:05:07.410 Nicolas Sucari: Per order. Right?
1040 01:05:07.880 ⇒ 01:05:08.640 Nicolas Sucari: Yep.
1041 01:05:09.010 ⇒ 01:05:10.769 Nicolas Sucari: And then we have these
1042 01:05:10.800 ⇒ 01:05:21.420 Nicolas Sucari: 2 metrics here that we use to the customer lifetime lifespan. We are using it to calculate the lifetime value. Right? Brian. Yeah, this one was
1043 01:05:21.570 ⇒ 01:05:22.969 Nicolas Sucari: were the ones that we
1044 01:05:24.620 ⇒ 01:05:26.320 Nicolas Sucari: created a while ago.
1045 01:05:27.750 ⇒ 01:05:29.999 Ryan Luke Daque: Yeah, I can’t remember. But
1046 01:05:30.750 ⇒ 01:05:31.590 Ryan Luke Daque: yeah.
1047 01:05:35.760 ⇒ 01:05:36.370 Nicolas Sucari: Perfect.
1048 01:05:36.920 ⇒ 01:05:39.594 Nicolas Sucari: Yeah, yeah, I I remember we
1049 01:05:40.230 ⇒ 01:05:47.730 Nicolas Sucari: team asked for that customer lifetime value. And we had it here because we needed the information from the customers. So yeah, that’s fine.
1050 01:05:51.530 ⇒ 01:05:54.869 Nicolas Sucari: Okay? And then we have warranties and send us tickets.
1051 01:05:55.799 ⇒ 01:05:59.389 Nicolas Sucari: Warranties. We don’t have like a lot of information.
1052 01:06:00.270 ⇒ 01:06:02.810 Nicolas Sucari: So I think this is still okay.
1053 01:06:02.990 ⇒ 01:06:03.700 Nicolas Sucari: Fine.
1054 01:06:06.530 ⇒ 01:06:07.950 Nicolas Sucari: What do you think? Utam
1055 01:06:09.840 ⇒ 01:06:11.160 Nicolas Sucari: on warranties?
1056 01:06:11.870 ⇒ 01:06:12.970 Uttam Kumaran: Yeah, I
1057 01:06:13.530 ⇒ 01:06:16.510 Uttam Kumaran: I think it’s fine the way it is like.
1058 01:06:16.790 ⇒ 01:06:18.890 Nicolas Sucari: Yeah. Snow. No water.
1059 01:06:18.890 ⇒ 01:06:19.955 Uttam Kumaran: Me was at
1060 01:06:21.550 ⇒ 01:06:23.609 Uttam Kumaran: is to maybe add the orders.
1061 01:06:24.260 ⇒ 01:06:25.240 Uttam Kumaran: If we have it.
1062 01:06:27.570 ⇒ 01:06:28.800 Ryan Luke Daque: Order, id.
1063 01:06:29.510 ⇒ 01:06:33.949 Uttam Kumaran: Yeah, like the orders associated. But again, I don’t know what’s in this warranties table. I forgot.
1064 01:06:35.360 ⇒ 01:06:38.069 Ryan Luke Daque: Yeah, I’ll I’ll just take note of it that.
1065 01:06:38.320 ⇒ 01:06:40.042 Ryan Luke Daque: But I guess this is like.
1066 01:06:40.900 ⇒ 01:06:42.020 Ryan Luke Daque: yeah.
1067 01:06:42.780 ⇒ 01:06:46.060 Ryan Luke Daque: not sure if we have order data. But yeah, we’ll see.
1068 01:06:46.970 ⇒ 01:06:52.050 Nicolas Sucari: Yeah, I think the most important one here is the base warranty claim.
1069 01:06:52.070 ⇒ 01:06:53.550 Nicolas Sucari: This should be.
1070 01:06:53.750 ⇒ 01:06:54.500 Ryan Luke Daque: Going down.
1071 01:06:54.500 ⇒ 01:06:59.530 Nicolas Sucari: Cost of. Yeah, of course, and the cost of goods replaced. Obviously. But
1072 01:07:01.160 ⇒ 01:07:02.729 Nicolas Sucari: yeah, this measure, like
1073 01:07:02.980 ⇒ 01:07:06.699 Nicolas Sucari: gives us the idea of how long it takes to
1074 01:07:08.030 ⇒ 01:07:10.049 Nicolas Sucari: to be affected with the warranties.
1075 01:07:14.160 ⇒ 01:07:15.130 Nicolas Sucari: I’m fine.
1076 01:07:16.840 ⇒ 01:07:21.789 Nicolas Sucari: and then we have the send disk tickets. I don’t know if we are still using this
1077 01:07:22.580 ⇒ 01:07:23.780 Nicolas Sucari: for anything
1078 01:07:27.690 ⇒ 01:07:29.760 Nicolas Sucari: this is to do like
1079 01:07:30.170 ⇒ 01:07:31.960 Nicolas Sucari: specific analysis on
1080 01:07:32.730 ⇒ 01:07:34.569 Nicolas Sucari: with with more information. Right?
1081 01:07:39.300 ⇒ 01:07:41.800 Nicolas Sucari: I don’t know when this was created, but.
1082 01:07:42.960 ⇒ 01:07:45.199 Ryan Luke Daque: This might be like just one of the.
1083 01:07:45.200 ⇒ 01:07:46.870 Uttam Kumaran: Mainly created for Cody.
1084 01:07:47.808 ⇒ 01:07:51.820 Uttam Kumaran: But I think same thing. Can we restrict this to the previous day?
1085 01:07:51.820 ⇒ 01:07:53.610 Ryan Luke Daque: Yeah, yeah.
1086 01:07:53.840 ⇒ 01:07:56.410 Uttam Kumaran: I think, Nico, what we’ll do is like once we
1087 01:07:56.990 ⇒ 01:08:05.810 Uttam Kumaran: I think we should, if once we feel comfortable, like with shipping. I think the next thing I want to do is call Cody, and basically see if we can engage with them. So that’ll be the big thing.
1088 01:08:06.600 ⇒ 01:08:10.230 Nicolas Sucari: Yeah, I think we have like 2 big next steps that we need to start.
1089 01:08:10.400 ⇒ 01:08:16.000 Nicolas Sucari: Yeah, talking with them. One is inventory trying to work with the unleashed stuff
1090 01:08:16.130 ⇒ 01:08:18.359 Nicolas Sucari: and see how we can help there.
1091 01:08:18.450 ⇒ 01:08:21.659 Nicolas Sucari: And the other one, yeah, is getting in touch with Cody and see
1092 01:08:21.729 ⇒ 01:08:26.539 Nicolas Sucari: how we can help him create what he needs for customer support, right.
1093 01:08:27.390 ⇒ 01:08:27.979 Uttam Kumaran: Yeah.
1094 01:08:30.290 ⇒ 01:08:41.450 Nicolas Sucari: And then we can also always create new things for chuck, for example, the warehouse performance dashboard. That should be really nice to do, and pretty easily having the information.
1095 01:08:42.689 ⇒ 01:08:48.079 Uttam Kumaran: Yeah, the biggest thing is, once we feel comfortable, like, you know, we saw a lot of things today that are confusing. I think
1096 01:08:48.259 ⇒ 01:08:50.969 Uttam Kumaran: probably after, like one or 2 or more of these.
1097 01:08:51.229 ⇒ 01:08:58.189 Uttam Kumaran: I think we can probably have a good where we’re hosting where we can. We can send updates directly to Dan and Ben.
1098 01:08:58.269 ⇒ 01:09:00.329 Uttam Kumaran: or like once a month, or
1099 01:09:00.489 ⇒ 01:09:17.049 Uttam Kumaran: once every 2 weeks, we can do a data review, as you know, like, if they see they see small things they’re going to be like, what is that? What is that? So I want us. I want all stage family to get through that. And then when we go to them, it’ll be really strong. Right? So that’s kind of like, what I want to get to is hopefully.
1100 01:09:17.139 ⇒ 01:09:21.799 Uttam Kumaran: every 2 weeks or something. We can just bring them on a call and walk them through things we’ve been seeing.
1101 01:09:22.159 ⇒ 01:09:24.399 Uttam Kumaran: and then continue to do the things.
1102 01:09:25.800 ⇒ 01:09:32.760 Nicolas Sucari: Yeah, of course, because if we if we show them this stuff and they see an a number that is odd for them.
1103 01:09:32.859 ⇒ 01:09:36.720 Nicolas Sucari: they are not gonna trust on any of the other stuff. So yeah.
1104 01:09:37.540 ⇒ 01:09:51.799 Nicolas Sucari: I think we need to, as you say, be comfortable with all of the information validated with Jack and Kim, and once we have, once we are ready, we can start sending updates directly from here and meeting and showing real and discussing dashboards with them. Right.
1105 01:09:51.800 ⇒ 01:09:54.843 Uttam Kumaran: I don’t think that’s very far down the line, right like
1106 01:09:55.120 ⇒ 01:09:57.769 Nicolas Sucari: No, no, we’re pretty close. Yeah, yeah.
1107 01:09:59.190 ⇒ 01:10:00.160 Nicolas Sucari: perfect.
1108 01:10:01.540 ⇒ 01:10:02.360 Nicolas Sucari: Okay.
1109 01:10:05.160 ⇒ 01:10:06.230 Nicolas Sucari: excellent.
1110 01:10:06.510 ⇒ 01:10:08.767 Nicolas Sucari: A lot of stuff to do. Ryan.
1111 01:10:09.090 ⇒ 01:10:09.500 Ryan Luke Daque: Snake.
1112 01:10:09.500 ⇒ 01:10:12.619 Nicolas Sucari: A lot of a lot of them are small changes. So.
1113 01:10:12.830 ⇒ 01:10:13.690 Ryan Luke Daque: Yeah.
1114 01:10:14.150 ⇒ 01:10:15.369 Uttam Kumaran: But again, I like that. We’re like.
1115 01:10:15.370 ⇒ 01:10:16.190 Nicolas Sucari: About it.
1116 01:10:16.190 ⇒ 01:10:18.240 Uttam Kumaran: Things that are accomplishable. I feel like.
1117 01:10:18.580 ⇒ 01:10:19.190 Ryan Luke Daque: Yeah.
1118 01:10:19.190 ⇒ 01:10:19.730 Nicolas Sucari: Yeah.
1119 01:10:19.730 ⇒ 01:10:26.709 Ryan Luke Daque: And it’s great like we we saw like weird stuff, like the number of returns. Being higher than the orders, and that that’s like
1120 01:10:26.970 ⇒ 01:10:29.410 Ryan Luke Daque: important stuff to work on. Like.
1121 01:10:29.530 ⇒ 01:10:31.160 Ryan Luke Daque: yeah, so yeah, cool.
1122 01:10:31.160 ⇒ 01:10:31.760 Nicolas Sucari: Yeah.
1123 01:10:32.350 ⇒ 01:10:33.070 Nicolas Sucari: Cool.
1124 01:10:33.530 ⇒ 01:10:34.410 Nicolas Sucari: Okay.
1125 01:10:37.143 ⇒ 01:10:44.819 Nicolas Sucari: Well, let’s talk later, guys, if you want. Ryan, let me know if you need anything else. I think you already
1126 01:10:45.070 ⇒ 01:10:50.480 Nicolas Sucari: have all the notes. But yeah, we can work with the meeting transcript. Then, if not.
1127 01:10:50.840 ⇒ 01:10:51.489 Nicolas Sucari: yep, to see.
1128 01:10:51.490 ⇒ 01:10:51.970 Ryan Luke Daque: Bottle.
1129 01:10:51.970 ⇒ 01:10:52.800 Nicolas Sucari: Something.
1130 01:10:52.990 ⇒ 01:10:57.180 Ryan Luke Daque: I’ll continue with the Google Ads investigation. See if I can like add
1131 01:10:57.260 ⇒ 01:10:59.690 Ryan Luke Daque: the ad level
1132 01:10:59.790 ⇒ 01:11:08.089 Ryan Luke Daque: revenue and conversion. But if not, then we’ll see what we can do. They’ll probably just default to campaign level stuff.
1133 01:11:08.220 ⇒ 01:11:09.040 Ryan Luke Daque: for now.
1134 01:11:09.250 ⇒ 01:11:09.950 Nicolas Sucari: Okay.
1135 01:11:10.340 ⇒ 01:11:23.460 Nicolas Sucari: yeah, that’s good, perfect. And if we need anything else maybe we can. Then ask Kim if we if she can give us access to Google or Amazon. If we need to check those campaigns. Okay.
1136 01:11:23.900 ⇒ 01:11:24.670 Ryan Luke Daque: Sounds good.
1137 01:11:25.840 ⇒ 01:11:27.119 Nicolas Sucari: Perfect. Okay.
1138 01:11:27.410 ⇒ 01:11:30.839 Nicolas Sucari: well, thank you very much. Thanks for Tom. Talk later.
1139 01:11:30.840 ⇒ 01:11:31.830 Ryan Luke Daque: Thanks guys.
1140 01:11:32.780 ⇒ 01:11:33.460 Nicolas Sucari: Alright!
1141 01:11:33.460 ⇒ 01:11:34.080 Ryan Luke Daque: Bye, bye.