Meeting Title: Uttam-Kumaran’s-Personal-Meeting-Room Date: 2024-06-26 Meeting participants: Brian Pei, Uttam Kumaran
WEBVTT
1 00:03:32.350 ⇒ 00:03:34.389 Brian Pei: Broken ass, app dude.
2 00:03:36.702 ⇒ 00:03:39.589 Uttam Kumaran: So many years. You can’t use zoom.
3 00:03:39.590 ⇒ 00:03:41.360 Brian Pei: Broken ass app
4 00:03:41.910 ⇒ 00:03:47.414 Brian Pei: dude. Well, I’ve I’ve logged in with my personal email. That might have been part of the problem.
5 00:03:47.720 ⇒ 00:03:51.529 Uttam Kumaran: Okay, yeah, I do them. I would. I pay. I get you a paid account if you want one.
6 00:03:51.530 ⇒ 00:03:55.040 Brian Pei: I do not. I really do not want to deal
7 00:03:55.780 ⇒ 00:03:57.000 Brian Pei: that shit.
8 00:03:57.000 ⇒ 00:03:59.729 Uttam Kumaran: Okay, I’m working on shipment dupes. But
9 00:04:00.060 ⇒ 00:04:00.800 Uttam Kumaran: yeah.
10 00:04:01.090 ⇒ 00:04:04.760 Brian Pei: It’s it’s easy, man, it’s all in shopify.
11 00:04:04.760 ⇒ 00:04:06.920 Uttam Kumaran: Yeah, there’s like, I think it’s just
12 00:04:07.120 ⇒ 00:04:09.690 Uttam Kumaran: I’m gonna find out where the issues are coming from.
13 00:04:09.960 ⇒ 00:04:12.008 Brian Pei: The ship station items
14 00:04:12.770 ⇒ 00:04:15.259 Brian Pei: you join on line. Item, key.
15 00:04:15.260 ⇒ 00:04:15.899 Uttam Kumaran: And app.
16 00:04:15.900 ⇒ 00:04:18.040 Brian Pei: There’s line item he dubs for sure.
17 00:04:18.040 ⇒ 00:04:18.550 Uttam Kumaran: Okay.
18 00:04:19.584 ⇒ 00:04:33.039 Brian Pei: That’s how I fixed Amazon, but that fix was supposed to fix Amazon and shopify, and only fixed Amazon. But let me let me open up the real shit first.st This should take like 30 seconds.
19 00:04:33.040 ⇒ 00:04:37.419 Uttam Kumaran: Yeah do the direct mail first, st cause we’re gonna meet with them. And then I wanna just get the next steps from here.
20 00:04:37.850 ⇒ 00:04:39.120 Uttam Kumaran: and then we probably
21 00:04:40.120 ⇒ 00:04:43.040 Uttam Kumaran: won’t have anything until next week. Most likely.
22 00:04:43.090 ⇒ 00:04:44.280 Uttam Kumaran: That’s Major.
23 00:04:44.520 ⇒ 00:04:47.366 Brian Pei: I can fuck up the Duke shit
24 00:04:48.180 ⇒ 00:04:50.220 Uttam Kumaran: Any of the interns reach out to you.
25 00:04:51.410 ⇒ 00:04:53.779 Brian Pei: Nobody. DM’s me
26 00:04:54.060 ⇒ 00:04:55.080 Brian Pei: straight up.
27 00:04:55.340 ⇒ 00:04:56.509 Brian Pei: Oh, what’s that?
28 00:04:56.510 ⇒ 00:04:57.030 Uttam Kumaran: Okay.
29 00:04:57.030 ⇒ 00:04:58.318 Brian Pei: How did you even
30 00:04:58.910 ⇒ 00:05:02.650 Brian Pei: did you interview people or did? Are you just handing out internships like handy.
31 00:05:05.164 ⇒ 00:05:11.969 Uttam Kumaran: No, I will. One person I got introduced by Clint, who’s like a college kid who just graduated. But he’s like
32 00:05:12.360 ⇒ 00:05:16.610 Uttam Kumaran: he wanted to work in data. So I gave him an opportunity. And then
33 00:05:16.680 ⇒ 00:05:23.959 Uttam Kumaran: 3 other people came through a friend. My my cousin has a company in India, and they have a bunch of engineers, and they’re like they had a bunch of
34 00:05:24.020 ⇒ 00:05:25.260 Uttam Kumaran: new grad
35 00:05:25.670 ⇒ 00:05:26.899 Uttam Kumaran: that are like
36 00:05:27.170 ⇒ 00:05:30.210 Uttam Kumaran: trying to get the data stuff. And he’s like we can’t really handle.
37 00:05:30.980 ⇒ 00:05:34.120 Uttam Kumaran: We don’t have data stuff for them, like, Yeah, go my way. I’ll
38 00:05:34.310 ⇒ 00:05:35.730 Uttam Kumaran: give us some opportunity.
39 00:05:35.880 ⇒ 00:05:37.330 Brian Pei: We’re not paying them right.
40 00:05:37.330 ⇒ 00:05:38.010 Uttam Kumaran: Now.
41 00:05:38.150 ⇒ 00:05:40.559 Brian Pei: Good good good man, good man.
42 00:05:41.560 ⇒ 00:05:44.390 Uttam Kumaran: I mean, I would have considered it. But like
43 00:05:44.940 ⇒ 00:05:48.249 Uttam Kumaran: I’m really happy that I’m not because it’s kind of a lot.
44 00:05:48.250 ⇒ 00:05:49.750 Brian Pei: Oh, man, don’t do that.
45 00:05:51.033 ⇒ 00:05:52.919 Brian Pei: Where’s share?
46 00:05:54.250 ⇒ 00:05:55.476 Brian Pei: Share? Screen?
47 00:06:00.980 ⇒ 00:06:02.420 Brian Pei: Stop.
48 00:06:04.520 ⇒ 00:06:05.620 Brian Pei: Ap.
49 00:06:06.280 ⇒ 00:06:07.930 Brian Pei: 5, 6, 9.
50 00:06:08.640 ⇒ 00:06:10.100 Brian Pei: This one.
51 00:06:12.310 ⇒ 00:06:14.480 Brian Pei: Okay. And then I do.
52 00:06:15.970 ⇒ 00:06:19.330 Brian Pei: I was already in this bitch, but I’ll do it again.
53 00:06:21.250 ⇒ 00:06:24.239 Brian Pei: Dude, look at me, remembering real start and shit. That’s crazy.
54 00:06:24.240 ⇒ 00:06:25.760 Uttam Kumaran: I know
55 00:06:26.000 ⇒ 00:06:28.280 Uttam Kumaran: yo, I just talked to real head of sales.
56 00:06:28.530 ⇒ 00:06:32.990 Uttam Kumaran: We have like a we have a monthly yo dude, and I had a sick, fucking sales day.
57 00:06:33.490 ⇒ 00:06:35.009 Uttam Kumaran: We’re going to stop talking.
58 00:06:35.010 ⇒ 00:06:36.750 Brian Pei: Good. I’m happy for you.
59 00:06:36.750 ⇒ 00:06:38.279 Uttam Kumaran: We’re getting some stuff, cooking.
60 00:06:40.170 ⇒ 00:06:42.690 Brian Pei: Through real or just in general.
61 00:06:42.933 ⇒ 00:06:50.730 Uttam Kumaran: Through like a couple of different through real and through other stuff real, he said. He’s gonna toss me to some stuff I just have to give him some materials, and then
62 00:06:51.380 ⇒ 00:06:56.110 Uttam Kumaran: we’re going after some stuff in manufacturing similar to the account. Nick’s working on.
63 00:06:56.490 ⇒ 00:06:57.270 Brian Pei: Okay.
64 00:06:57.460 ⇒ 00:06:59.980 Uttam Kumaran: So I have some partners that we’re kind of working through.
65 00:07:03.070 ⇒ 00:07:04.700 Uttam Kumaran: yeah, we’re working on it.
66 00:07:04.700 ⇒ 00:07:05.760 Brian Pei: You have A
67 00:07:06.620 ⇒ 00:07:10.569 Brian Pei: August Kpi. You try to start new projects by September.
68 00:07:11.460 ⇒ 00:07:15.749 Uttam Kumaran: I am trying to start new projects literally next minute.
69 00:07:16.020 ⇒ 00:07:16.765 Brian Pei: Okay.
70 00:07:17.510 ⇒ 00:07:20.330 Uttam Kumaran: As soon as humanly possible.
71 00:07:20.360 ⇒ 00:07:21.650 Uttam Kumaran: ideally.
72 00:07:22.620 ⇒ 00:07:24.449 Uttam Kumaran: superhumanly possible.
73 00:07:25.650 ⇒ 00:07:29.729 Brian Pei: Which one of these you, you know this? Which one of these can I just take out right now?
74 00:07:29.730 ⇒ 00:07:31.899 Uttam Kumaran: Everything except for New York.
75 00:07:31.900 ⇒ 00:07:33.370 Brian Pei: Yeah, makes sense
76 00:07:34.290 ⇒ 00:07:37.639 Brian Pei: that makes sense. And then time ranges. I assume.
77 00:07:37.640 ⇒ 00:07:41.319 Uttam Kumaran: I would just get rid of anything. That’s yeah. I would get rid of the 6 h.
78 00:07:41.320 ⇒ 00:07:42.390 Brian Pei: Aunt.
79 00:07:43.730 ⇒ 00:07:45.039 Uttam Kumaran: Yeah, that’s probably fine.
80 00:07:45.040 ⇒ 00:07:46.409 Brian Pei: That’s it. Okay, cool
81 00:07:49.290 ⇒ 00:07:52.369 Brian Pei: soon to tell you a little bit preview.
82 00:07:53.780 ⇒ 00:07:55.729 Brian Pei: Just does this shit, huh?
83 00:07:56.140 ⇒ 00:07:57.439 Uttam Kumaran: Bro. Yes.
84 00:07:58.360 ⇒ 00:08:03.559 Uttam Kumaran: think about if looker fucking did anything like this when we fucking were working.
85 00:08:03.910 ⇒ 00:08:05.370 Uttam Kumaran: Jesus fuck.
86 00:08:06.770 ⇒ 00:08:09.270 Brian Pei: Dude. I get it. You’re a you’re a real boy.
87 00:08:11.700 ⇒ 00:08:14.920 Uttam Kumaran: I’m gonna ride this horse into the sunset.
88 00:08:17.340 ⇒ 00:08:19.940 Brian Pei: Campaigns, coupon codes.
89 00:08:23.210 ⇒ 00:08:26.400 Brian Pei: What happens if I do this? Oh.
90 00:08:29.220 ⇒ 00:08:32.159 Uttam Kumaran: Hit the hit, the thing on the right. No contacts column.
91 00:08:33.789 ⇒ 00:08:39.469 Uttam Kumaran: Oh, so the one thing you need to do is if you go go back to the edit metrics.
92 00:08:41.480 ⇒ 00:08:45.029 Uttam Kumaran: It’s on the yeah. If you next to deploy.
93 00:08:45.450 ⇒ 00:08:46.130 Brian Pei: Oh!
94 00:08:47.600 ⇒ 00:08:49.930 Uttam Kumaran: And if you scroll down to like
95 00:08:50.060 ⇒ 00:08:53.410 Uttam Kumaran: these different things, there’s a valid percent of total.
96 00:08:53.870 ⇒ 00:08:56.979 Uttam Kumaran: So you can do total orders as true.
97 00:08:57.070 ⇒ 00:09:00.389 Uttam Kumaran: Anything where you want to also allow percent of total. Yep.
98 00:09:01.730 ⇒ 00:09:04.990 Brian Pei: To not, Max? Not men.
99 00:09:04.990 ⇒ 00:09:11.720 Uttam Kumaran: I think I would get rid of the Max and Min shit cause there’s probably like no need to have those like. Those are kind of it automatically does it. But.
100 00:09:14.450 ⇒ 00:09:16.349 Brian Pei: Yeah, I I’m down. I don’t.
101 00:09:16.350 ⇒ 00:09:18.480 Uttam Kumaran: Shopping amounts and stuff like that, you know.
102 00:09:20.400 ⇒ 00:09:21.250 Uttam Kumaran: Yeah.
103 00:09:23.160 ⇒ 00:09:25.509 Brian Pei: The average stuff is fine, right?
104 00:09:25.510 ⇒ 00:09:29.730 Uttam Kumaran: Why does it need it? We don’t need to see the shipping amounts here, she just wants to know, like
105 00:09:29.990 ⇒ 00:09:31.869 Uttam Kumaran: to sales, and what product.
106 00:09:31.870 ⇒ 00:09:33.569 Brian Pei: So she doesn’t need weight in her.
107 00:09:33.830 ⇒ 00:09:35.899 Brian Pei: Yeah, wait doesn’t matter.
108 00:09:36.240 ⇒ 00:09:37.750 Brian Pei: Discount, amount.
109 00:09:38.270 ⇒ 00:09:41.080 Brian Pei: order, refund revenue.
110 00:09:42.850 ⇒ 00:09:43.420 Uttam Kumaran: Yeah.
111 00:09:43.420 ⇒ 00:09:45.590 Brian Pei: Wonder if this does order of operations.
112 00:09:45.590 ⇒ 00:09:46.460 Uttam Kumaran: Like Braz.
113 00:09:46.460 ⇒ 00:09:47.160 Brian Pei: First.st
114 00:09:47.460 ⇒ 00:09:48.210 Uttam Kumaran: Dies.
115 00:09:48.210 ⇒ 00:09:49.777 Brian Pei: And then total orders.
116 00:09:52.210 ⇒ 00:09:55.690 Brian Pei: and then probably refund and discount.
117 00:09:56.310 ⇒ 00:09:59.709 Uttam Kumaran: And then also look at the dimensions. There’s some, probably some. Should we need.
118 00:10:03.960 ⇒ 00:10:06.940 Brian Pei: It may have postcard id. Probably not. I don’t even know what that is.
119 00:10:06.940 ⇒ 00:10:12.280 Uttam Kumaran: I think maybe leave that, because that’s probably what we get from post pilot.
120 00:10:13.240 ⇒ 00:10:14.609 Uttam Kumaran: but like
121 00:10:15.440 ⇒ 00:10:18.650 Uttam Kumaran: the shipping with height stuff don’t need that shit.
122 00:10:18.650 ⇒ 00:10:20.910 Brian Pei: This is Pi. Now 1st name, last name.
123 00:10:20.910 ⇒ 00:10:23.139 Uttam Kumaran: Oh, yeah, we should probably get rid of that.
124 00:10:23.940 ⇒ 00:10:25.800 Brian Pei: Email’s fine. Maybe
125 00:10:25.900 ⇒ 00:10:26.830 Brian Pei: maybe not.
126 00:10:27.210 ⇒ 00:10:29.550 Brian Pei: I guess she’s not going to go down by email address.
127 00:10:29.950 ⇒ 00:10:30.910 Brian Pei: Hi, SIM.
128 00:10:31.090 ⇒ 00:10:31.960 Uttam Kumaran: Well.
129 00:10:33.140 ⇒ 00:10:35.080 Uttam Kumaran: just leave email and then
130 00:10:35.230 ⇒ 00:10:41.640 Uttam Kumaran: get rid of like the main, any of the lat. Long. And then the actual. There’s an address field, but keep the city.
131 00:10:55.320 ⇒ 00:10:59.070 Brian Pei: Where’s the save button? I want to save this. It just says, Deploy.
132 00:11:00.022 ⇒ 00:11:01.350 Uttam Kumaran: It automatically saves.
133 00:11:03.160 ⇒ 00:11:03.930 Brian Pei: Oh!
134 00:11:06.180 ⇒ 00:11:06.930 Uttam Kumaran: Ya!
135 00:11:07.690 ⇒ 00:11:08.869 Brian Pei: Cool alright.
136 00:11:09.500 ⇒ 00:11:15.389 Brian Pei: and I just gotta do it for order. I. So this one was by order, and then I need order. Item.
137 00:11:16.240 ⇒ 00:11:18.140 Brian Pei: do the same thing.
138 00:11:38.540 ⇒ 00:11:39.290 Brian Pei: Oops.
139 00:12:26.410 ⇒ 00:12:27.600 Uttam Kumaran: Where
140 00:12:27.690 ⇒ 00:12:29.409 Uttam Kumaran: ol.id!
141 00:13:11.430 ⇒ 00:13:12.280 Uttam Kumaran: Od!
142 00:13:23.360 ⇒ 00:13:24.210 Uttam Kumaran: What happened?
143 00:13:26.050 ⇒ 00:13:26.750 Brian Pei: Nothing.
144 00:13:26.950 ⇒ 00:13:28.981 Brian Pei: Okay. I’m just going back to
145 00:13:29.960 ⇒ 00:13:30.630 Brian Pei: Rocky.
146 00:13:32.610 ⇒ 00:13:35.950 Brian Pei: The sequel that I have in there double check. It.
147 00:13:47.390 ⇒ 00:13:51.540 Uttam Kumaran: Yeah, I didn’t know whether it needed to be in models or sources.
148 00:13:51.950 ⇒ 00:13:53.540 Uttam Kumaran: Guess it doesn’t. Yeah.
149 00:13:53.540 ⇒ 00:13:57.650 Brian Pei: I don’t think it matters. I did it in sources, because most of the other ones were in sources.
150 00:14:07.610 ⇒ 00:14:09.030 Brian Pei: and the.
151 00:14:09.030 ⇒ 00:14:11.360 Uttam Kumaran: Amount and the shipping weight.
152 00:15:36.070 ⇒ 00:15:38.370 Uttam Kumaran: Oh, you’re right. What? The fuck?
153 00:15:40.390 ⇒ 00:15:45.069 Uttam Kumaran: Oh, wait what the line item key. But the order item, Id is different.
154 00:15:46.450 ⇒ 00:15:47.490 Brian Pei: It is. Yeah. The
155 00:15:47.930 ⇒ 00:15:50.329 Brian Pei: the line item key is, what does join.
156 00:15:50.620 ⇒ 00:15:52.749 Uttam Kumaran: What the fuck are these both, then.
157 00:15:52.750 ⇒ 00:15:55.550 Brian Pei: But it’s different from order. Item Id. And I don’t know why.
158 00:15:57.060 ⇒ 00:15:58.429 Uttam Kumaran: Payment dates.
159 00:16:03.900 ⇒ 00:16:05.570 Uttam Kumaran: Oh, shit
160 00:16:10.390 ⇒ 00:16:11.360 Uttam Kumaran: fuck!
161 00:16:30.760 ⇒ 00:16:31.880 Uttam Kumaran: Okay, hold on
162 00:17:08.369 ⇒ 00:17:11.579 Uttam Kumaran: this guy ordered a brush and a pump.
163 00:17:14.490 ⇒ 00:17:15.819 Uttam Kumaran: 2 items.
164 00:17:21.790 ⇒ 00:17:25.729 Uttam Kumaran: but they both are the same line item key
165 00:17:27.869 ⇒ 00:17:33.399 Uttam Kumaran: and the line item, key joins to the order line. Id.
166 00:17:44.280 ⇒ 00:17:45.430 Uttam Kumaran: Really.
167 00:17:49.780 ⇒ 00:17:53.199 Uttam Kumaran: they look like they’re different, though.
168 00:18:06.290 ⇒ 00:18:08.629 Uttam Kumaran: What might just filter to this guy?
169 00:18:09.410 ⇒ 00:18:12.550 Uttam Kumaran: Oh, what the fuck is the order! Id, though
170 00:18:59.780 ⇒ 00:19:01.450 Uttam Kumaran: there’s 3,
171 00:19:03.430 ⇒ 00:19:06.760 Uttam Kumaran: 2 with the same id. Oh, no!
172 00:19:08.740 ⇒ 00:19:10.230 Uttam Kumaran: One’s 30
173 00:19:11.620 ⇒ 00:19:12.770 Uttam Kumaran: pounds.
174 00:19:48.180 ⇒ 00:19:52.899 Uttam Kumaran: This is 30 pounds. So what the fuck, booster pump.
175 00:19:57.040 ⇒ 00:20:00.310 Uttam Kumaran: And what is this? That’s 270 pounds.
176 00:20:11.130 ⇒ 00:20:13.229 Brian Pei: You wanted me to deploy these 2.
177 00:20:13.450 ⇒ 00:20:16.019 Brian Pei: I just went through and triple checked everything.
178 00:20:16.330 ⇒ 00:20:17.260 Brian Pei: Yeah, like, I mean.
179 00:20:17.260 ⇒ 00:20:19.202 Uttam Kumaran: We look at the dashboard real quick.
180 00:20:19.480 ⇒ 00:20:22.329 Brian Pei: So this one I’ll do.
181 00:20:22.480 ⇒ 00:20:25.599 Brian Pei: This one is direct mail by order. Id.
182 00:20:26.580 ⇒ 00:20:27.190 Uttam Kumaran: Okay.
183 00:20:29.020 ⇒ 00:20:32.670 Brian Pei: You got money, you got money coming in. You got orders, which is
184 00:20:32.890 ⇒ 00:20:35.600 Brian Pei: basically around the same number of orders
185 00:20:35.880 ⇒ 00:20:37.470 Brian Pei: in the Google Sheet.
186 00:20:37.580 ⇒ 00:20:39.129 Brian Pei: Got some refunds. You got all that.
187 00:20:39.130 ⇒ 00:20:40.520 Uttam Kumaran: Total, sends.
188 00:20:41.280 ⇒ 00:20:42.050 Brian Pei: Total. Where?
189 00:20:42.580 ⇒ 00:20:43.449 Brian Pei: What’s this?
190 00:20:44.200 ⇒ 00:20:45.230 Uttam Kumaran: Like the
191 00:20:45.390 ⇒ 00:20:48.599 Uttam Kumaran: how many? Oh, these are just all the conversions.
192 00:20:48.870 ⇒ 00:20:53.220 Brian Pei: This is direct mail Google Sheet and are joined onto orders.
193 00:20:53.910 ⇒ 00:20:54.820 Brian Pei: What are I do.
194 00:20:54.820 ⇒ 00:20:56.550 Uttam Kumaran: Okay. Cool. Okay. Okay. Great.
195 00:20:56.550 ⇒ 00:21:00.359 Brian Pei: And then the other. One is by order. Item.
196 00:21:00.940 ⇒ 00:21:01.580 Uttam Kumaran: Okay.
197 00:21:02.200 ⇒ 00:21:06.939 Brian Pei: Which should be. It’s about the same, but more money.
198 00:21:08.480 ⇒ 00:21:10.079 Uttam Kumaran: Why is it more money?
199 00:21:11.340 ⇒ 00:21:13.920 Brian Pei: Should it not be more money?
200 00:21:16.210 ⇒ 00:21:18.020 Brian Pei: Should it be exactly the same?
201 00:21:18.880 ⇒ 00:21:19.690 Brian Pei: Yeah.
202 00:21:20.760 ⇒ 00:21:21.700 Brian Pei: really.
203 00:21:21.830 ⇒ 00:21:26.619 Brian Pei: Well, the join is A is a fuzzy join because I got, I got email, and I got conversion date.
204 00:21:28.750 ⇒ 00:21:29.290 Uttam Kumaran: Okay.
205 00:21:30.177 ⇒ 00:21:33.120 Brian Pei: Let’s see, let me think of a reason why.
206 00:21:33.120 ⇒ 00:21:35.456 Uttam Kumaran: But that’s okay. I mean, one is
207 00:21:36.500 ⇒ 00:21:39.049 Uttam Kumaran: They may have ordered more things.
208 00:21:41.650 ⇒ 00:21:42.580 Uttam Kumaran: Well.
209 00:21:43.050 ⇒ 00:21:44.730 Uttam Kumaran: can you see the product in here?
210 00:21:49.260 ⇒ 00:21:50.860 Uttam Kumaran: Okay, cool. You can’t see it.
211 00:21:50.860 ⇒ 00:21:52.389 Brian Pei: Adam. Name. Yeah.
212 00:21:54.380 ⇒ 00:21:55.310 Brian Pei: So
213 00:21:55.470 ⇒ 00:21:57.609 Brian Pei: yeah, the join is.
214 00:21:57.610 ⇒ 00:22:01.370 Uttam Kumaran: But 766 is the same thing on both right. 766 orders.
215 00:22:01.540 ⇒ 00:22:02.760 Brian Pei: Yeah, that’s the same.
216 00:22:03.400 ⇒ 00:22:04.840 Uttam Kumaran: But the revenue is different.
217 00:22:05.010 ⇒ 00:22:10.099 Brian Pei: The revenue is higher when I’m joining to get the order. Item. Id
218 00:22:11.040 ⇒ 00:22:12.080 Brian Pei: a.
219 00:22:12.080 ⇒ 00:22:17.570 Uttam Kumaran: Are you taking the order price? Or what are you taking for revenue? Because you again, you’re gonna duplicate the order price.
220 00:22:18.100 ⇒ 00:22:21.270 Brian Pei: Revenue would be from
221 00:22:22.850 ⇒ 00:22:24.350 Brian Pei: revenue.
222 00:22:25.130 ⇒ 00:22:26.359 Uttam Kumaran: Like, edit. Yeah.
223 00:22:26.360 ⇒ 00:22:26.970 Brian Pei: Wouldn’t.
224 00:22:27.090 ⇒ 00:22:29.249 Brian Pei: Where is revenue? Revenue
225 00:22:30.870 ⇒ 00:22:34.770 Brian Pei: from the order total? Oh, this should not be order, total price.
226 00:22:34.770 ⇒ 00:22:41.360 Uttam Kumaran: It should be the order here. I’ll tell you. I can tell you. The field this is coming from shop. It’s coming from shopify right.
227 00:22:42.200 ⇒ 00:22:45.619 Brian Pei: Yeah, I think I had it here, too. Let me see.
228 00:22:47.170 ⇒ 00:22:48.470 Brian Pei: A
229 00:22:49.250 ⇒ 00:22:51.059 Brian Pei: shopify order items
230 00:22:54.450 ⇒ 00:22:56.270 Brian Pei: has.
231 00:22:59.640 ⇒ 00:23:00.639 Brian Pei: Where is it?
232 00:23:05.080 ⇒ 00:23:07.690 Uttam Kumaran: Item, total price, or
233 00:23:08.350 ⇒ 00:23:12.845 Uttam Kumaran: Oh, wait, hold on! Let me look at what the logic is right on total price. I think that may be
234 00:23:13.700 ⇒ 00:23:15.000 Uttam Kumaran: with the quantity.
235 00:23:17.400 ⇒ 00:23:19.249 Brian Pei: Yeah, it was looking at
236 00:23:20.010 ⇒ 00:23:21.050 Brian Pei: ordered.
237 00:23:22.170 ⇒ 00:23:23.309 Brian Pei: And fuck, is it
238 00:23:25.490 ⇒ 00:23:28.839 Brian Pei: your order line? Item, it was looking at order, total price.
239 00:23:29.130 ⇒ 00:23:31.780 Brian Pei: in which case, if you have 2 line items.
240 00:23:32.230 ⇒ 00:23:34.830 Brian Pei: you are double counting that. And so I just need to swap.
241 00:23:34.830 ⇒ 00:23:37.039 Uttam Kumaran: Take, you should take the item total price.
242 00:23:37.040 ⇒ 00:23:39.270 Brian Pei: Item, total price should be revenue.
243 00:23:40.090 ⇒ 00:23:43.510 Brian Pei: So this is gonna be item and total
244 00:23:44.020 ⇒ 00:23:45.100 Brian Pei: Christ.
245 00:23:48.380 ⇒ 00:23:52.890 Brian Pei: make sure. And this should be item, total price.
246 00:23:53.560 ⇒ 00:23:55.670 Uttam Kumaran: And then can you change it to total?
247 00:23:56.190 ⇒ 00:23:58.089 Uttam Kumaran: Can you change it to
248 00:23:58.290 ⇒ 00:24:00.929 Uttam Kumaran: valid percent of total like, do that stuff.
249 00:24:01.500 ⇒ 00:24:02.300 Brian Pei: Right.
250 00:24:03.460 ⇒ 00:24:04.900 Brian Pei: true.
251 00:24:05.580 ⇒ 00:24:08.330 Uttam Kumaran: And then maybe, can you total revenue from items
252 00:24:10.340 ⇒ 00:24:11.380 Uttam Kumaran: a dead.
253 00:24:18.080 ⇒ 00:24:19.400 Brian Pei: Say that last part again.
254 00:24:19.400 ⇒ 00:24:22.918 Uttam Kumaran: Can you do total revenue from items as a label.
255 00:24:25.570 ⇒ 00:24:28.790 Uttam Kumaran: and then same thing for the average revenue from items?
256 00:24:34.260 ⇒ 00:24:38.809 Uttam Kumaran: And then can you also add a total order. Items as account distinct order. App.
257 00:24:38.840 ⇒ 00:24:40.919 Uttam Kumaran: I order. Item, id.
258 00:24:43.130 ⇒ 00:24:46.239 Brian Pei: In addition to total orders, or instead of total orders.
259 00:24:46.240 ⇒ 00:24:47.496 Uttam Kumaran: In addition, in addition.
260 00:24:48.200 ⇒ 00:24:52.290 Uttam Kumaran: as a item, it’s item order. Ideas is the is the field.
261 00:24:53.310 ⇒ 00:24:54.130 Brian Pei: Move
262 00:24:54.420 ⇒ 00:24:55.660 Brian Pei: orders.
263 00:24:56.820 ⇒ 00:24:59.620 Brian Pei: items, total order.
264 00:25:00.220 ⇒ 00:25:03.240 Uttam Kumaran: Total. Can you do total order items? No. S.
265 00:25:04.630 ⇒ 00:25:05.749 Brian Pei: You have? Ocd.
266 00:25:06.260 ⇒ 00:25:09.079 Uttam Kumaran: Yeah, and then distinct item, order, id.
267 00:25:09.440 ⇒ 00:25:10.150 Brian Pei: Yeah.
268 00:25:12.360 ⇒ 00:25:14.669 Brian Pei: let me make sure that’s the one, because some.
269 00:25:14.670 ⇒ 00:25:16.420 Uttam Kumaran: Yeah, I’m looking. I’m looking at it. Yeah.
270 00:25:16.990 ⇒ 00:25:18.699 Brian Pei: Oh, fuck, okay.
271 00:25:19.690 ⇒ 00:25:20.490 Uttam Kumaran: Aye.
272 00:25:20.490 ⇒ 00:25:24.409 Brian Pei: Item, order Id. This is total orders is still fine.
273 00:25:27.100 ⇒ 00:25:29.989 Brian Pei: this is item price, item, refund
274 00:25:31.540 ⇒ 00:25:33.000 Brian Pei: shipping amount.
275 00:25:33.000 ⇒ 00:25:34.109 Uttam Kumaran: Do we need that.
276 00:25:34.720 ⇒ 00:25:35.330 Brian Pei: No.
277 00:25:35.690 ⇒ 00:25:38.359 Brian Pei: I don’t know what what she wants. I don’t know this person to you.
278 00:25:38.360 ⇒ 00:25:40.640 Uttam Kumaran: Get rid of that. Just get rid of the shipping stuff.
279 00:25:40.640 ⇒ 00:25:41.380 Brian Pei: Okay.
280 00:25:48.375 ⇒ 00:25:51.850 Uttam Kumaran: Can you add the cut? Can we add customer? Id.
281 00:25:52.860 ⇒ 00:25:53.590 Uttam Kumaran: yeah.
282 00:25:54.500 ⇒ 00:25:58.070 Uttam Kumaran: or it’s actually, we’ll just have customer email. So you can just do like.
283 00:25:58.370 ⇒ 00:26:02.719 Uttam Kumaran: Oh, and we actually do have customer id. So you can just do count distinct customer id.
284 00:26:04.510 ⇒ 00:26:05.540 Uttam Kumaran: And then
285 00:26:05.790 ⇒ 00:26:09.820 Uttam Kumaran: that’s great. You can move that you can have the customer id in the other one too, and then we should be good.
286 00:26:11.520 ⇒ 00:26:12.960 Brian Pei: Customer.
287 00:26:14.640 ⇒ 00:26:15.670 Uttam Kumaran: Total customers.
288 00:26:16.150 ⇒ 00:26:16.780 Brian Pei: Sure.
289 00:26:22.620 ⇒ 00:26:23.470 Uttam Kumaran: Perfect.
290 00:26:23.670 ⇒ 00:26:26.089 Brian Pei: And I’ll bring this over.
291 00:26:26.430 ⇒ 00:26:29.399 Brian Pei: So this just auto saves. I don’t even have to control. S.
292 00:26:29.400 ⇒ 00:26:36.890 Uttam Kumaran: You’ll you’ll yeah. I’ll show you exactly what to do after. So if you want to add this, the other one, and then you can go ahead and make the Pr. And I’ll approve, and then
293 00:26:37.120 ⇒ 00:26:38.360 Uttam Kumaran: I’ll show you how to.
294 00:26:38.700 ⇒ 00:26:40.330 Uttam Kumaran: It’ll end up deploying.
295 00:26:42.250 ⇒ 00:26:44.640 Brian Pei: Just making sure all the dimensions are
296 00:26:46.410 ⇒ 00:26:50.139 Brian Pei: shipping platform. Oh, shipman with don’t need that!
297 00:26:52.810 ⇒ 00:26:55.749 Brian Pei: And then, by order, model
298 00:26:56.980 ⇒ 00:26:59.490 Brian Pei: campaign customer.
299 00:27:01.030 ⇒ 00:27:02.849 Uttam Kumaran: Can you get rid of shipping country code?
300 00:27:03.000 ⇒ 00:27:03.740 Uttam Kumaran: Yeah.
301 00:27:10.610 ⇒ 00:27:11.310 Uttam Kumaran: yeah.
302 00:27:12.030 ⇒ 00:27:13.540 Brian Pei: Get rid of it from here, too.
303 00:27:20.570 ⇒ 00:27:23.079 Brian Pei: back, and then we do.
304 00:27:24.940 ⇒ 00:27:26.510 Brian Pei: It’s a customer.
305 00:27:31.250 ⇒ 00:27:32.939 Uttam Kumaran: I think you had a copy already.
306 00:27:33.270 ⇒ 00:27:37.260 Brian Pei: I did, but I don’t know. Does does all orders also have customer rights?
307 00:27:37.260 ⇒ 00:27:38.819 Uttam Kumaran: Yeah, does it does?
308 00:27:38.820 ⇒ 00:27:39.420 Brian Pei: Guy.
309 00:27:41.420 ⇒ 00:27:45.619 Brian Pei: and then I’ll take out the oh, I took out shipping amount from here already.
310 00:27:47.930 ⇒ 00:27:49.860 Uttam Kumaran: What is average total price.
311 00:27:51.210 ⇒ 00:27:53.829 Uttam Kumaran: Fuck is total, what is total price.
312 00:27:54.430 ⇒ 00:28:00.220 Brian Pei: That is, I guess, the average of the price among all orders. This is.
313 00:28:00.720 ⇒ 00:28:02.999 Uttam Kumaran: Can you just do average order price
314 00:28:05.230 ⇒ 00:28:06.670 Uttam Kumaran: like, what is total?
315 00:28:06.840 ⇒ 00:28:07.879 Uttam Kumaran: Where is that coming.
316 00:28:07.880 ⇒ 00:28:11.684 Brian Pei: Yeah, this this is a orders. Now, not order. Item.
317 00:28:12.030 ⇒ 00:28:13.460 Uttam Kumaran: Referencing another
318 00:28:13.540 ⇒ 00:28:17.210 Uttam Kumaran: is that referencing a column, or is, or what is total price?
319 00:28:17.230 ⇒ 00:28:18.660 Uttam Kumaran: That’s from the table.
320 00:28:19.625 ⇒ 00:28:20.370 Brian Pei: Yeah.
321 00:28:20.370 ⇒ 00:28:21.370 Uttam Kumaran: Oh, okay. Okay. Good.
322 00:28:21.370 ⇒ 00:28:22.820 Brian Pei: I don’t know which table, though
323 00:28:23.650 ⇒ 00:28:25.159 Brian Pei: I have it right here.
324 00:28:26.000 ⇒ 00:28:28.300 Brian Pei: Oh, whoops! That was my.
325 00:28:28.300 ⇒ 00:28:30.170 Uttam Kumaran: Total prices. Well.
326 00:28:30.440 ⇒ 00:28:32.239 Uttam Kumaran: there’s an order. Total price.
327 00:28:32.240 ⇒ 00:28:34.229 Brian Pei: There’s total price from
328 00:28:34.760 ⇒ 00:28:36.340 Brian Pei: direct mail.
329 00:28:36.390 ⇒ 00:28:38.600 Brian Pei: and then there’s the
330 00:28:38.800 ⇒ 00:28:39.340 Brian Pei: the other.
331 00:28:39.784 ⇒ 00:28:40.230 Uttam Kumaran: People!
332 00:28:40.580 ⇒ 00:28:44.789 Brian Pei: Order total price from shopify orders. I don’t know which one you actually want.
333 00:28:45.130 ⇒ 00:28:50.040 Brian Pei: Order, total price comes from shopify orders. Table total price comes from the Google sheet.
334 00:28:50.220 ⇒ 00:28:51.329 Uttam Kumaran: They look the same.
335 00:28:51.860 ⇒ 00:28:52.960 Brian Pei: They’re yeah.
336 00:28:53.030 ⇒ 00:28:54.080 Brian Pei: I would hope so.
337 00:28:54.220 ⇒ 00:28:57.210 Uttam Kumaran: Can you bring it from shop? Can you bring it from shopify.
338 00:28:57.650 ⇒ 00:28:59.560 Brian Pei: Yeah, I’d prefer from shopify.
339 00:29:00.090 ⇒ 00:29:03.519 Brian Pei: What if the shopify one is order, total price.
340 00:29:04.750 ⇒ 00:29:06.680 Brian Pei: order, total price. Okay?
341 00:29:08.690 ⇒ 00:29:11.399 Brian Pei: So anywhere, it says, total price.
342 00:29:12.600 ⇒ 00:29:15.750 Brian Pei: Okay, so this is order, total price. So that’s good.
343 00:29:16.390 ⇒ 00:29:19.200 Brian Pei: Then this should be order, total price.
344 00:29:20.700 ⇒ 00:29:22.240 Brian Pei: total quantity comes from.
345 00:29:22.240 ⇒ 00:29:24.410 Uttam Kumaran: Can you just call it average order price.
346 00:29:25.020 ⇒ 00:29:27.870 Uttam Kumaran: or average or average order? Yeah, okay, okay.
347 00:29:28.960 ⇒ 00:29:33.329 Brian Pei: And then let me go back to order. Item, to make sure that total price is not being
348 00:29:33.630 ⇒ 00:29:36.769 Brian Pei: item. Total price is good. Item, total price is good. Alright.
349 00:29:37.590 ⇒ 00:29:38.749 Brian Pei: and I’m ripping it.
350 00:29:39.370 ⇒ 00:29:41.679 Uttam Kumaran: Okay, rip it, and then I’ll approve, and then
351 00:29:41.770 ⇒ 00:29:43.910 Uttam Kumaran: we can log in and both see it live.
352 00:29:44.210 ⇒ 00:29:45.530 Brian Pei: Dashboards.
353 00:29:50.440 ⇒ 00:29:53.870 Brian Pei: 5, 6, 9. Which is this one?
354 00:29:54.660 ⇒ 00:29:59.250 Brian Pei: Nope, just kidding. It is Ep. 5, 6, 9.
355 00:29:59.720 ⇒ 00:30:00.660 Uttam Kumaran: Yeah, I see it.
356 00:30:00.870 ⇒ 00:30:01.580 Brian Pei: Okay.
357 00:30:07.670 ⇒ 00:30:09.150 Brian Pei: VP. 5, 6, 9.
358 00:30:10.370 ⇒ 00:30:15.059 Brian Pei: Let me make sure I go to the files. Dashboard. Yaml, is there?
359 00:30:23.110 ⇒ 00:30:23.910 Brian Pei: yeah.
360 00:30:24.290 ⇒ 00:30:25.230 Brian Pei: Oh.
361 00:30:25.690 ⇒ 00:30:28.310 Brian Pei: your trip date question. That’s the
362 00:30:29.660 ⇒ 00:30:33.930 Brian Pei: that’s the only identifier we have to join
363 00:30:35.050 ⇒ 00:30:37.779 Brian Pei: to get the specific order of the customer.
364 00:30:40.570 ⇒ 00:30:43.550 Uttam Kumaran: Well, you also join on conversion, date and ship date.
365 00:30:44.570 ⇒ 00:30:52.779 Brian Pei: That’s my just in case there’s a missing stuff. Let me triple check, though. Oh, yes, I do because
366 00:30:53.784 ⇒ 00:31:01.859 Brian Pei: they could have so customer emails not enough right? Because one customer can have multiple orders on different dates.
367 00:31:02.070 ⇒ 00:31:05.030 Brian Pei: And so it just it looks at one date first, st
368 00:31:05.440 ⇒ 00:31:07.920 Brian Pei: for the order created that at.
369 00:31:08.050 ⇒ 00:31:11.770 Brian Pei: and then, if there’s no match there, it looks at the ship date just in case there’s a match.
370 00:31:11.770 ⇒ 00:31:14.250 Uttam Kumaran: Oh, I see. I see. Okay.
371 00:31:14.250 ⇒ 00:31:20.709 Brian Pei: It doesn’t duplicate or double count, because it’s kind of like a Co. It’s a coalesce without a coalesce.
372 00:31:20.710 ⇒ 00:31:23.450 Uttam Kumaran: Yeah, yeah, yeah, it’s a or, and then that takes the 1st one.
373 00:31:23.450 ⇒ 00:31:29.590 Brian Pei: I wanna look at created first, st and then just in case there is no match. Look at ship date, because I don’t trust the
374 00:31:29.850 ⇒ 00:31:32.509 Brian Pei: the post pilot date to always be correct.
375 00:31:34.645 ⇒ 00:31:36.960 Brian Pei: Because their definition of conversion date
376 00:31:37.240 ⇒ 00:31:38.740 Brian Pei: might not align.
377 00:31:39.440 ⇒ 00:31:44.900 Brian Pei: So it’s it’s just. It’s a it’s a coalesce to make sure that it captures as much as possible.
378 00:31:48.310 ⇒ 00:31:50.210 Brian Pei: and
379 00:31:50.390 ⇒ 00:31:56.230 Brian Pei: and yeah, I did a count one count one count distinct order id, and it’s
380 00:31:57.250 ⇒ 00:32:00.130 Brian Pei: good State. Alright.
381 00:32:01.970 ⇒ 00:32:02.860 Brian Pei: Bitch.
382 00:32:08.950 ⇒ 00:32:12.309 Brian Pei: Yeah. 7, 66 to 70, 66. So there’s no dukes.
383 00:32:12.550 ⇒ 00:32:13.210 Uttam Kumaran: Okay.
384 00:32:13.802 ⇒ 00:32:15.580 Brian Pei: Cool, alright, sweet.
385 00:32:16.711 ⇒ 00:32:19.019 Uttam Kumaran: It’s about to finish running.
386 00:32:19.020 ⇒ 00:32:23.660 Brian Pei: You want me to deploy from my local host? Or are you gonna deploy.
387 00:32:24.120 ⇒ 00:32:26.039 Uttam Kumaran: So as soon as it merges
388 00:32:26.310 ⇒ 00:32:29.269 Uttam Kumaran: I’m gonna have you run real project refresh.
389 00:32:29.510 ⇒ 00:32:31.520 Uttam Kumaran: and then it should all be good.
390 00:32:32.850 ⇒ 00:32:35.100 Brian Pei: Okay. So go. I’m gonna go to Main.
391 00:32:36.440 ⇒ 00:32:38.640 Brian Pei: When it merges. I’ll fetch origin.
392 00:32:48.050 ⇒ 00:32:48.670 Uttam Kumaran: Cool.
393 00:32:51.639 ⇒ 00:32:52.259 Brian Pei: Georgian.
394 00:32:52.840 ⇒ 00:32:54.109 Uttam Kumaran: Wait one sec. Come on.
395 00:32:54.110 ⇒ 00:32:55.320 Brian Pei: Didn’t pull anything.
396 00:33:02.470 ⇒ 00:33:03.709 Uttam Kumaran: Okay, go for it.
397 00:33:05.942 ⇒ 00:33:07.418 Brian Pei: Georgian Pol origin
398 00:33:09.410 ⇒ 00:33:11.290 Brian Pei: exit out of real.
399 00:33:13.280 ⇒ 00:33:17.199 Brian Pei: Then make sure I’m in, master. Oh, fuck! I forgot to
400 00:33:17.240 ⇒ 00:33:18.670 Brian Pei: set that up. That’s fine.
401 00:33:19.630 ⇒ 00:33:22.290 Brian Pei: And then, when am I doing real? What?
402 00:33:22.290 ⇒ 00:33:24.039 Uttam Kumaran: Real project. Refresh.
403 00:33:27.770 ⇒ 00:33:30.859 Uttam Kumaran: Okay? And if you open up real on your side.
404 00:33:32.190 ⇒ 00:33:34.260 Brian Pei: Locally or like actual, real.
405 00:33:34.750 ⇒ 00:33:37.600 Uttam Kumaran: Actual real. I see it there. Cool. Okay.
406 00:33:37.600 ⇒ 00:33:38.240 Brian Pei: There! It!
407 00:33:38.510 ⇒ 00:33:39.880 Uttam Kumaran: Okay. Great. I gotta jump.
408 00:33:39.880 ⇒ 00:33:41.669 Brian Pei: So yep, later.
409 00:33:41.670 ⇒ 00:33:42.910 Uttam Kumaran: Fair talking, slack.