Meeting Title: Project-Reviews Date: 2024-08-21 Meeting participants: Ryan Luke Daque, Nicolas Sucari
WEBVTT
1 00:01:22.890 ⇒ 00:01:23.710 Nicolas Sucari: Hey, Ryan.
2 00:01:24.940 ⇒ 00:01:26.000 Ryan Luke Daque: Hi. Nicholas.
3 00:02:35.340 ⇒ 00:02:37.409 Nicolas Sucari: I don’t know if the time is gonna join
4 00:02:40.180 ⇒ 00:02:44.430 Nicolas Sucari: But yeah, he asked me to send that thread on
5 00:02:45.760 ⇒ 00:02:48.350 Nicolas Sucari: on that client for cars. Go channel.
6 00:02:50.490 ⇒ 00:02:51.360 Ryan Luke Daque: yeah.
7 00:02:54.290 ⇒ 00:02:57.560 Ryan Luke Daque: he just sent the email as well, like, how?
8 00:02:57.840 ⇒ 00:02:59.280 Ryan Luke Daque: So? It looks like it’s.
9 00:02:59.640 ⇒ 00:03:00.200 Nicolas Sucari: And let me.
10 00:03:00.200 ⇒ 00:03:02.225 Ryan Luke Daque: The email is coming from
11 00:03:02.710 ⇒ 00:03:04.280 Ryan Luke Daque: from post pilot.
12 00:03:05.340 ⇒ 00:03:06.050 Ryan Luke Daque: They were the ones.
13 00:03:06.050 ⇒ 00:03:06.470 Nicolas Sucari: Yeah.
14 00:03:06.470 ⇒ 00:03:10.409 Ryan Luke Daque: It up. So yeah, I’m also like, read trying to read through
15 00:03:11.540 ⇒ 00:03:13.519 Ryan Luke Daque: what happened here.
16 00:03:15.300 ⇒ 00:03:15.885 Ryan Luke Daque: So
17 00:04:08.480 ⇒ 00:04:09.700 Ryan Luke Daque: well, if we just
18 00:04:10.070 ⇒ 00:04:11.209 Ryan Luke Daque: base this.
19 00:04:11.210 ⇒ 00:04:12.400 Nicolas Sucari: And I’m really
20 00:04:12.830 ⇒ 00:04:20.429 Nicolas Sucari: yeah. I’m trying to read through the thread, but I don’t know if there is like anywhere that we are asking for postcard dates, or something like that.
21 00:04:20.700 ⇒ 00:04:25.159 Ryan Luke Daque: It doesn’t look like there is, and if if we just base it off on
22 00:04:28.910 ⇒ 00:04:31.680 Ryan Luke Daque: on what they mentioned, and Jane even
23 00:04:32.140 ⇒ 00:04:38.049 Ryan Luke Daque: provided a link. The this conversion list, let me let me share my screen. I think that would be easier.
24 00:04:38.050 ⇒ 00:04:38.850 Nicolas Sucari: Yeah. Okay.
25 00:04:39.560 ⇒ 00:04:43.005 Nicolas Sucari: yeah. That conversion list, I think, is the one that
26 00:04:43.820 ⇒ 00:04:46.030 Nicolas Sucari: that we have there on on.
27 00:04:46.030 ⇒ 00:04:46.690 Ryan Luke Daque: Yeah, but.
28 00:04:46.690 ⇒ 00:04:50.120 Nicolas Sucari: Pilot, and that’s different from what we are receiving. Right.
29 00:04:50.440 ⇒ 00:04:56.949 Ryan Luke Daque: It. The yeah, that’s what I’m looking at. So it does look like it’s it’s different because we are receiving
30 00:04:57.750 ⇒ 00:04:59.270 Ryan Luke Daque: this one.
31 00:04:59.590 ⇒ 00:05:00.760 Nicolas Sucari: Yeah, exactly that. That’s.
32 00:05:00.760 ⇒ 00:05:01.160 Ryan Luke Daque: Yes.
33 00:05:01.160 ⇒ 00:05:02.480 Nicolas Sucari: What I was doing. Yeah.
34 00:05:02.480 ⇒ 00:05:03.080 Ryan Luke Daque: Yeah.
35 00:05:03.450 ⇒ 00:05:04.630 Ryan Luke Daque: So
36 00:05:05.410 ⇒ 00:05:07.039 Ryan Luke Daque: so it might be a different
37 00:05:07.970 ⇒ 00:05:08.950 Ryan Luke Daque: email.
38 00:05:09.880 ⇒ 00:05:11.829 Ryan Luke Daque: Okay, let me set up
39 00:05:13.690 ⇒ 00:05:15.929 Ryan Luke Daque: because this doesn’t have the
40 00:05:16.270 ⇒ 00:05:21.060 Ryan Luke Daque: postcards, calls, orders, revenue roas. It only has, like the price
41 00:05:21.620 ⇒ 00:05:22.969 Ryan Luke Daque: for a campaign.
42 00:05:23.330 ⇒ 00:05:24.160 Ryan Luke Daque: So.
43 00:05:25.110 ⇒ 00:05:27.870 Ryan Luke Daque: and this shows that its conversion date.
44 00:05:28.500 ⇒ 00:05:31.589 Ryan Luke Daque: So I wonder if there’s any other report here.
45 00:05:38.400 ⇒ 00:05:39.490 Ryan Luke Daque: Vi. Pestle
46 00:05:41.060 ⇒ 00:05:43.359 Ryan Luke Daque: look like there’s any other report here.
47 00:05:44.320 ⇒ 00:05:46.449 Ryan Luke Daque: So maybe this is different.
48 00:05:53.800 ⇒ 00:05:57.809 Ryan Luke Daque: Yeah, it’s it’s most likely it’s it’s different. It’s not this one.
49 00:08:37.770 ⇒ 00:08:42.829 Nicolas Sucari: Yeah, okay, apart from that, I just emailed
50 00:08:43.740 ⇒ 00:08:47.390 Nicolas Sucari: her again, so that we can set a meeting
51 00:08:50.510 ⇒ 00:08:57.449 Nicolas Sucari: apart from that. So what we had there on the board. So okay, you already have the customer lifetime value
52 00:08:59.440 ⇒ 00:09:04.549 Nicolas Sucari: and the average customer lifespan. That is, from
53 00:09:05.390 ⇒ 00:09:08.420 Nicolas Sucari: what we talked before. Okay, perfect.
54 00:09:08.460 ⇒ 00:09:10.559 Nicolas Sucari: Go back to the task.
55 00:09:14.733 ⇒ 00:09:15.920 Nicolas Sucari: Wait. Wait.
56 00:09:17.800 ⇒ 00:09:20.547 Nicolas Sucari: Okay. So for for revenue. And Ross
57 00:09:21.330 ⇒ 00:09:24.329 Nicolas Sucari: like, what? What is like the next step on that one.
58 00:09:29.500 ⇒ 00:09:34.049 Ryan Luke Daque: for Facebook and Google, at least, I’ll have to look into
59 00:09:35.250 ⇒ 00:09:38.189 Ryan Luke Daque: the documentation again for Facebook and Google
60 00:09:38.230 ⇒ 00:09:42.190 Ryan Luke Daque: cause currently the data that we have from 5 Tran
61 00:09:42.290 ⇒ 00:09:44.300 Ryan Luke Daque: or Facebook and Google are
62 00:09:44.640 ⇒ 00:09:45.520 Ryan Luke Daque: that it
63 00:09:46.040 ⇒ 00:09:50.279 Ryan Luke Daque: on a campaign level for revenue. So
64 00:09:51.507 ⇒ 00:09:54.379 Ryan Luke Daque: yeah, I’ll see. I’ll try to find a way to.
65 00:09:55.050 ⇒ 00:09:59.530 Ryan Luke Daque: If there’s a way to break it down to the ad level
66 00:09:59.870 ⇒ 00:10:01.210 Ryan Luke Daque: that way, we can.
67 00:10:02.180 ⇒ 00:10:07.609 Ryan Luke Daque: Yeah, we can add it in the combined marketing performance to the ad up to the ad level.
68 00:10:09.590 ⇒ 00:10:10.300 Nicolas Sucari: Okay.
69 00:10:10.700 ⇒ 00:10:11.480 Nicolas Sucari: okay.
70 00:10:13.830 ⇒ 00:10:18.290 Nicolas Sucari: okay, perfect. So I’m checking now the
71 00:10:18.600 ⇒ 00:10:23.130 Nicolas Sucari: average customer lifetime value. So the one that you
72 00:10:23.993 ⇒ 00:10:27.560 Nicolas Sucari: bring us customer life lifespan.
73 00:10:28.050 ⇒ 00:10:31.809 Nicolas Sucari: That is the purchase free frequency, right?
74 00:10:33.320 ⇒ 00:10:33.920 Nicolas Sucari: But.
75 00:10:33.920 ⇒ 00:10:35.190 Ryan Luke Daque: Is, the.
76 00:10:38.070 ⇒ 00:10:39.909 Nicolas Sucari: I’m trying to do cold weight.
77 00:10:40.834 ⇒ 00:10:43.035 Ryan Luke Daque: Yeah, let me let me share my screen again.
78 00:10:43.410 ⇒ 00:10:44.020 Ryan Luke Daque: Cool?
79 00:10:44.020 ⇒ 00:10:47.479 Nicolas Sucari: Revenue, you know. Wait, I can find it here.
80 00:10:49.270 ⇒ 00:10:50.320 Ryan Luke Daque: So
81 00:10:50.340 ⇒ 00:10:53.770 Ryan Luke Daque: I was actually just following the medium.
82 00:10:55.143 ⇒ 00:10:56.570 Ryan Luke Daque: Yeah thing.
83 00:10:56.740 ⇒ 00:10:59.559 Ryan Luke Daque: So according to this one, the the customer
84 00:10:59.630 ⇒ 00:11:04.580 Ryan Luke Daque: average customer lifespan, or like the customer lifespan is basically just the
85 00:11:05.130 ⇒ 00:11:06.869 Ryan Luke Daque: difference between the 1st
86 00:11:07.120 ⇒ 00:11:12.059 Ryan Luke Daque: order, date and the last order date of that specific customer. Right?
87 00:11:12.330 ⇒ 00:11:13.680 Ryan Luke Daque: And this is in days. But.
88 00:11:13.680 ⇒ 00:11:14.390 Nicolas Sucari: So it.
89 00:11:14.940 ⇒ 00:11:16.569 Nicolas Sucari: Where are you?
90 00:11:17.020 ⇒ 00:11:18.840 Nicolas Sucari: How to calculate? Average?
91 00:11:19.860 ⇒ 00:11:21.110 Nicolas Sucari: I don’t know. Where.
92 00:11:21.370 ⇒ 00:11:25.340 Nicolas Sucari: Where is the that link? That’s the one that’s not the one I added to.
93 00:11:25.340 ⇒ 00:11:26.460 Ryan Luke Daque: Yeah. So if you go.
94 00:11:26.460 ⇒ 00:11:28.819 Nicolas Sucari: Oh, yeah, okay. Okay, okay, yeah. I get it here.
95 00:11:28.820 ⇒ 00:11:31.309 Ryan Luke Daque: 5. Yeah, it says, here, yeah.
96 00:11:31.957 ⇒ 00:11:35.630 Ryan Luke Daque: to visit this blog post, how to get the customer.
97 00:11:35.630 ⇒ 00:11:36.959 Nicolas Sucari: Yeah, yeah, perfect. Perfect.
98 00:11:36.960 ⇒ 00:11:38.289 Ryan Luke Daque: So, yeah, this is this, is it.
99 00:11:38.290 ⇒ 00:11:39.320 Nicolas Sucari: Got it? Yeah.
100 00:11:39.320 ⇒ 00:11:46.420 Ryan Luke Daque: So I use this basically to get the average customer lifespan, which is what we are able to see here. But this is
101 00:11:46.510 ⇒ 00:11:49.310 Ryan Luke Daque: I made this in in year, not in day.
102 00:11:49.470 ⇒ 00:11:51.318 Ryan Luke Daque: That’s because it said
103 00:11:52.490 ⇒ 00:11:55.980 Ryan Luke Daque: it needs to be converted to year, if we need.
104 00:11:56.040 ⇒ 00:11:59.430 Ryan Luke Daque: if we need to use it for the customer lifetime. Calculation, right?
105 00:12:00.350 ⇒ 00:12:05.929 Ryan Luke Daque: So so that’s in year. So point 42 years is the average customer lifespan.
106 00:12:06.240 ⇒ 00:12:11.288 Ryan Luke Daque: and then that this one we multiply by.
107 00:12:13.070 ⇒ 00:12:15.059 Ryan Luke Daque: we multiply it by
108 00:12:15.140 ⇒ 00:12:19.100 Ryan Luke Daque: the average customer value. Then we get the customer lifetime value.
109 00:12:19.130 ⇒ 00:12:24.650 Ryan Luke Daque: And the average customer value I used was, this one average order value. Yeah.
110 00:12:25.300 ⇒ 00:12:25.690 Nicolas Sucari: Perfect.
111 00:12:27.000 ⇒ 00:12:28.399 Ryan Luke Daque: This is what we get.
112 00:12:30.000 ⇒ 00:12:30.940 Ryan Luke Daque: Yeah.
113 00:12:30.940 ⇒ 00:12:31.390 Nicolas Sucari: Okay.
114 00:12:31.390 ⇒ 00:12:32.860 Ryan Luke Daque: Good so far.
115 00:12:33.630 ⇒ 00:12:35.560 Ryan Luke Daque: and perhaps you
116 00:12:36.340 ⇒ 00:12:39.019 Ryan Luke Daque: I think we should also already see.
117 00:12:42.270 ⇒ 00:12:43.350 Ryan Luke Daque: Where is that.
118 00:12:44.470 ⇒ 00:12:47.319 Nicolas Sucari: You shopify earlier? I think it was right. I know. Yeah.
119 00:12:47.360 ⇒ 00:12:48.760 Nicolas Sucari: Paid marketing there.
120 00:12:50.920 ⇒ 00:12:52.110 Nicolas Sucari: Dcp.
121 00:12:52.110 ⇒ 00:12:53.600 Ryan Luke Daque: And missed the
122 00:12:55.130 ⇒ 00:12:58.069 Ryan Luke Daque: I think I missed adding it, yeah. So let me see.
123 00:12:58.070 ⇒ 00:12:59.300 Nicolas Sucari: Adidas.
124 00:12:59.320 ⇒ 00:13:02.220 Nicolas Sucari: I think that’s Cpa. Actually
125 00:13:02.610 ⇒ 00:13:03.640 Nicolas Sucari: that
126 00:13:04.000 ⇒ 00:13:14.769 Nicolas Sucari: cost per like. I just mentioned Kim like the what was the naming that we should use? And she just she just asked me to
127 00:13:15.160 ⇒ 00:13:23.210 Nicolas Sucari: don’t use Cpc, because Cpc is confusing because she thinks about that as cost per click. And we are not using clicks. We are using conversions.
128 00:13:23.370 ⇒ 00:13:32.870 Nicolas Sucari: So let’s leave it as Cpa, if you want. But let’s use the the measures that we set total spend over conversions. Okay.
129 00:13:33.590 ⇒ 00:13:34.320 Ryan Luke Daque: Right?
130 00:13:34.600 ⇒ 00:13:44.319 Ryan Luke Daque: Yeah, I’ll I’ll update it. I don’t. I think I missed this updating the real part on on that one. But yeah, it should already be in the models, though. In the Pr.
131 00:13:45.377 ⇒ 00:13:48.579 Ryan Luke Daque: Yeah, we should already have the cost
132 00:13:48.600 ⇒ 00:13:49.810 Ryan Luke Daque: revenue
133 00:13:49.840 ⇒ 00:13:51.529 Ryan Luke Daque: and Cpc, so
134 00:13:51.690 ⇒ 00:13:53.959 Ryan Luke Daque: I mean the revenue Roas and Cpc.
135 00:13:54.160 ⇒ 00:13:57.090 Ryan Luke Daque: But I wasn’t able to update the
136 00:13:57.900 ⇒ 00:13:58.739 Ryan Luke Daque: the real part.
137 00:13:58.740 ⇒ 00:14:03.350 Nicolas Sucari: Yeah, in the Mars. You have it here. Yeah, yeah, yeah. You have it as Cpc.
138 00:14:03.700 ⇒ 00:14:04.149 Ryan Luke Daque: It’s check.
139 00:14:04.150 ⇒ 00:14:06.080 Nicolas Sucari: Change data. Cpa, if you want.
140 00:14:06.080 ⇒ 00:14:08.090 Ryan Luke Daque: Yep, we’ll do that.
141 00:14:09.050 ⇒ 00:14:14.440 Nicolas Sucari: Perfect. Yeah, okay, there are a bunch of lines that we need to replace. Cpc for Cpa, Amc.
142 00:14:15.080 ⇒ 00:14:15.720 Ryan Luke Daque: Yeah.
143 00:14:17.240 ⇒ 00:14:17.930 Nicolas Sucari: Okay.
144 00:14:24.800 ⇒ 00:14:25.919 Nicolas Sucari: Easy. One.
145 00:14:29.890 ⇒ 00:14:33.919 Ryan Luke Daque: And this is being used by this one
146 00:14:34.190 ⇒ 00:14:34.860 Ryan Luke Daque: right.
147 00:14:34.860 ⇒ 00:14:35.570 Nicolas Sucari: Yeah.
148 00:14:35.920 ⇒ 00:14:36.810 Ryan Luke Daque: Yeah, exactly.
149 00:14:36.810 ⇒ 00:14:38.020 Nicolas Sucari: So we need to add it. There.
150 00:14:38.020 ⇒ 00:14:40.509 Ryan Luke Daque: See, I’ll have to add it here.
151 00:14:50.270 ⇒ 00:14:51.969 Ryan Luke Daque: so I guess this would be.
152 00:14:54.590 ⇒ 00:14:55.570 Nicolas Sucari: That would be.
153 00:14:55.570 ⇒ 00:14:57.170 Ryan Luke Daque: Yes. Yeah.
154 00:14:57.170 ⇒ 00:14:59.749 Nicolas Sucari: It’s okay. Some of cost. That’s okay.
155 00:15:00.870 ⇒ 00:15:03.189 Nicolas Sucari: Okay, okay. You already have the Cpa, yeah.
156 00:15:03.360 ⇒ 00:15:04.100 Ryan Luke Daque: Yeah.
157 00:15:05.680 ⇒ 00:15:08.710 Ryan Luke Daque: And then we also need the revenue
158 00:15:10.980 ⇒ 00:15:13.300 Ryan Luke Daque: and draw us.
159 00:15:26.320 ⇒ 00:15:28.330 Ryan Luke Daque: But I don’t think.
160 00:15:30.520 ⇒ 00:15:33.575 Nicolas Sucari: The Cpa is okay, to be a sum, or it should be
161 00:15:35.260 ⇒ 00:15:41.379 Ryan Luke Daque: Yeah, I’m thinking about it because it’s it’s cost per conversion. So we might.
162 00:15:42.392 ⇒ 00:15:46.379 Ryan Luke Daque: In this case, I guess we need to add the conversion.
163 00:15:46.920 ⇒ 00:15:50.869 Ryan Luke Daque: so that it would be like cost divided by conversions.
164 00:15:51.930 ⇒ 00:15:55.180 Ryan Luke Daque: Yeah, it could be a yeah. So
165 00:16:04.450 ⇒ 00:16:05.740 Ryan Luke Daque: Yup, that
166 00:16:05.960 ⇒ 00:16:06.730 Ryan Luke Daque: shit.
167 00:16:09.940 ⇒ 00:16:11.740 Nicolas Sucari: But you already have conversions.
168 00:16:12.603 ⇒ 00:16:14.170 Nicolas Sucari: No, you don’t have it. Okay, okay.
169 00:16:14.170 ⇒ 00:16:15.059 Ryan Luke Daque: No, I don’t.
170 00:16:27.920 ⇒ 00:16:29.300 Nicolas Sucari: Okay, perfect.
171 00:16:30.580 ⇒ 00:16:33.670 Ryan Luke Daque: Yeah, homes and ads. I don’t think we have
172 00:16:34.980 ⇒ 00:16:36.090 Ryan Luke Daque: no
173 00:16:41.950 ⇒ 00:16:42.750 Ryan Luke Daque: or
174 00:16:46.200 ⇒ 00:16:47.410 Ryan Luke Daque: just well.
175 00:18:18.241 ⇒ 00:18:25.069 Ryan Luke Daque: yeah, I’ll I’ll I’ll continue working on this. But the other things that are still on my
176 00:18:25.720 ⇒ 00:18:27.220 Ryan Luke Daque: plate is, yes.
177 00:18:28.410 ⇒ 00:18:32.790 Ryan Luke Daque: yeah, migrating the email data. So I’m still waiting for the new
178 00:18:33.530 ⇒ 00:18:37.160 Ryan Luke Daque: other other new tables here. I’m also like wondering cause.
179 00:18:37.410 ⇒ 00:18:38.510 Ryan Luke Daque: I think
180 00:18:38.590 ⇒ 00:18:39.669 Ryan Luke Daque: Uta mentioned
181 00:18:40.590 ⇒ 00:18:41.550 Ryan Luke Daque: that
182 00:18:43.000 ⇒ 00:18:45.500 Ryan Luke Daque: Eunice was already there.
183 00:18:46.110 ⇒ 00:18:47.620 Ryan Luke Daque: he said. It’s done.
184 00:18:47.780 ⇒ 00:18:49.590 Ryan Luke Daque: but I don’t see it anywhere
185 00:18:49.720 ⇒ 00:18:51.010 Ryan Luke Daque: as well as
186 00:18:52.170 ⇒ 00:18:54.729 Ryan Luke Daque: attentive campaigns spent.
187 00:18:55.170 ⇒ 00:18:57.699 Ryan Luke Daque: and he’s still currently working on.
188 00:18:58.070 ⇒ 00:19:02.819 Ryan Luke Daque: Oh, he just merged it today. So I guess I just now. So I guess
189 00:19:03.270 ⇒ 00:19:04.460 Ryan Luke Daque: this would show up.
190 00:19:06.325 ⇒ 00:19:06.900 Nicolas Sucari: Yeah.
191 00:19:08.470 ⇒ 00:19:12.669 Ryan Luke Daque: So I can. I can continue working on this as soon as I see them.
192 00:19:14.180 ⇒ 00:19:14.970 Ryan Luke Daque: Here.
193 00:19:15.410 ⇒ 00:19:16.376 Ryan Luke Daque: But yeah.
194 00:19:16.940 ⇒ 00:19:22.820 Ryan Luke Daque: I continue working on this for the email, the what do you call this? The migration for email data.
195 00:19:22.820 ⇒ 00:19:24.340 Nicolas Sucari: Yeah, okay, perfect.
196 00:19:24.340 ⇒ 00:19:25.050 Ryan Luke Daque: And
197 00:19:25.920 ⇒ 00:19:27.350 Ryan Luke Daque: I think there’s
198 00:19:27.380 ⇒ 00:19:31.930 Ryan Luke Daque: the other one, this one. This is what we talked about the missing conversions
199 00:19:32.683 ⇒ 00:19:38.070 Ryan Luke Daque: in the email for Jane. And then this one is the other one that I’m I’ll be working on.
200 00:19:38.210 ⇒ 00:19:39.329 Ryan Luke Daque: Haven’t started. Yeah.
201 00:19:39.330 ⇒ 00:19:40.410 Nicolas Sucari: Perfect.
202 00:19:40.480 ⇒ 00:19:52.829 Nicolas Sucari: Yeah, don’t worry about the the other meeting. It’s just to. So Raj is joining the team to take on everything on the analysis side and visualization. We’re trying to get
203 00:19:52.910 ⇒ 00:19:55.480 Nicolas Sucari: better reports, and he will be owning
204 00:19:55.530 ⇒ 00:20:00.539 Nicolas Sucari: all of the the analysis, and probably he will be working on some
205 00:20:00.670 ⇒ 00:20:03.328 Nicolas Sucari: moulding to to help us.
206 00:20:03.990 ⇒ 00:20:12.889 Nicolas Sucari: But yeah, the idea was just to like a quick onboarding with him, and if he has any other any questions on the data modeling stuff he can ask you.
207 00:20:13.240 ⇒ 00:20:14.770 Ryan Luke Daque: Cool, sounds good.
208 00:20:14.890 ⇒ 00:20:15.880 Ryan Luke Daque: sure.
209 00:20:15.880 ⇒ 00:20:16.580 Nicolas Sucari: Perfect.
210 00:20:17.180 ⇒ 00:20:18.919 Nicolas Sucari: Okay, thanks. Ryan.
211 00:20:18.920 ⇒ 00:20:23.349 Ryan Luke Daque: Thanks. See you see you in the next meeting. Thanks, bye.