Meeting Title: Nicolas-Sucari’s-Zoom-Meeting Date: 2024-08-09 Meeting participants: Ryan Luke Daque, Nicolas Sucari
WEBVTT
1 00:00:36.220 ⇒ 00:00:37.210 Ryan Luke Daque: Hi! Nicholas.
2 00:00:39.580 ⇒ 00:00:40.739 Ryan Luke Daque: can you hear me?
3 00:00:41.230 ⇒ 00:00:43.339 Nicolas Sucari: I can hear you. Hi, Ryan, how are you?
4 00:00:43.910 ⇒ 00:00:45.500 Ryan Luke Daque: Yeah, I’m doing. Well. How are you?
5 00:00:46.210 ⇒ 00:00:47.920 Nicolas Sucari: All good, all good.
6 00:00:48.230 ⇒ 00:00:49.890 Nicolas Sucari: I was just trying to
7 00:00:49.990 ⇒ 00:00:54.940 Nicolas Sucari: gather that graph that Utam was asking for pull parts.
8 00:00:55.292 ⇒ 00:01:02.699 Nicolas Sucari: We already send something to them. They like it, but they are asking for something else, and I wanted to ask you about
9 00:01:04.110 ⇒ 00:01:12.659 Nicolas Sucari: if we don’t have some measures in those dashboards. How easy is to like add something, or if you know where I can get like
10 00:01:12.730 ⇒ 00:01:14.150 Nicolas Sucari: other information
11 00:01:14.410 ⇒ 00:01:18.610 Nicolas Sucari: they’re asking, let me show you if you want. They are asking for
12 00:01:20.620 ⇒ 00:01:24.180 Nicolas Sucari: total customers, no total listing customers.
13 00:01:24.260 ⇒ 00:01:29.020 Nicolas Sucari: and I don’t think we have that information right directly on
14 00:01:29.060 ⇒ 00:01:31.220 Nicolas Sucari: shopify customers, dashboard.
15 00:01:33.330 ⇒ 00:01:35.339 Ryan Luke Daque: In real. You’re right.
16 00:01:35.510 ⇒ 00:01:39.440 Nicolas Sucari: Yeah, in real, in real. I’m using this one. Wait, let me move this here.
17 00:01:42.000 ⇒ 00:01:42.860 Nicolas Sucari: I’m using.
18 00:01:42.860 ⇒ 00:01:43.350 Ryan Luke Daque: Some
19 00:01:43.840 ⇒ 00:01:48.930 Nicolas Sucari: Yeah, forget about this. Probably sport. Pro, no. Okay.
20 00:01:49.332 ⇒ 00:01:52.770 Nicolas Sucari: so what I was trying to get is, yes.
21 00:01:53.480 ⇒ 00:01:55.589 Ryan Luke Daque: There’s customer id, but it’s a
22 00:01:55.820 ⇒ 00:01:59.330 Ryan Luke Daque: to dimension, right? It’s not a measure.
23 00:01:59.810 ⇒ 00:02:01.670 Nicolas Sucari: Yeah, exactly. I thought I mentioned.
24 00:02:02.704 ⇒ 00:02:05.489 Ryan Luke Daque: What about the total, distinct customers.
25 00:02:05.490 ⇒ 00:02:18.409 Nicolas Sucari: Yeah, this is this is this is what what I used before. And I send this. But they are asking like, they don’t want to see total, distinct customer station. What they just want to see total customers. Probably we can
26 00:02:18.460 ⇒ 00:02:19.475 Nicolas Sucari: like
27 00:02:21.210 ⇒ 00:02:25.969 Nicolas Sucari: I don’t know, because total customers it means it’s the same as total orders. Right?
28 00:02:26.670 ⇒ 00:02:28.710 Ryan Luke Daque: Yeah, that should be the same. Yeah.
29 00:02:28.710 ⇒ 00:02:32.980 Nicolas Sucari: Like that. It should be the same like they want to see like those lawyers right.
30 00:02:33.200 ⇒ 00:02:34.940 Ryan Luke Daque: Right? Yeah, cause that’s
31 00:02:35.590 ⇒ 00:02:40.289 Ryan Luke Daque: because that’s like the number of order. Ids, which is like, yeah.
32 00:02:40.290 ⇒ 00:02:40.760 Nicolas Sucari: Okay.
33 00:02:40.760 ⇒ 00:02:44.290 Ryan Luke Daque: Similar to like, yeah, it would be the same. So we can do that.
34 00:02:45.040 ⇒ 00:02:45.980 Ryan Luke Daque: Okay. But.
35 00:02:47.410 ⇒ 00:02:48.070 Nicolas Sucari: So they want.
36 00:02:48.070 ⇒ 00:02:48.390 Ryan Luke Daque: Seen.
37 00:02:48.390 ⇒ 00:02:54.258 Nicolas Sucari: Average order value total orders. Okay, that this would be total customers and
38 00:02:54.720 ⇒ 00:02:58.149 Nicolas Sucari: lifetime value lifetime value. We don’t have it here right.
39 00:02:59.884 ⇒ 00:03:02.800 Ryan Luke Daque: Yeah, it doesn’t look like we have it.
40 00:03:02.800 ⇒ 00:03:03.360 Nicolas Sucari: Oh!
41 00:03:03.360 ⇒ 00:03:07.780 Ryan Luke Daque: But how? How do we solve the like lifetime value, though
42 00:03:08.340 ⇒ 00:03:10.269 Ryan Luke Daque: like would it be the.
43 00:03:11.250 ⇒ 00:03:11.860 Ryan Luke Daque: I guess.
44 00:03:11.860 ⇒ 00:03:12.620 Nicolas Sucari: I’m not sure.
45 00:03:12.620 ⇒ 00:03:14.220 Ryan Luke Daque: Customer Id, and then
46 00:03:15.200 ⇒ 00:03:24.119 Ryan Luke Daque: like, if we can get the email customer email, for example, and then the total amount of orders for that specific customer. Then I guess that’s the
47 00:03:24.680 ⇒ 00:03:26.350 Ryan Luke Daque: I guess that’s the lifetime value.
48 00:03:26.350 ⇒ 00:03:31.979 Nicolas Sucari: But but do do we calculate that lifetime value anywhere in
49 00:03:32.020 ⇒ 00:03:33.559 Nicolas Sucari: currently it doesn’t.
50 00:03:34.780 ⇒ 00:03:36.290 Nicolas Sucari: I don’t. I don’t think so right.
51 00:03:36.290 ⇒ 00:03:37.370 Ryan Luke Daque: Yeah.
52 00:03:38.310 ⇒ 00:03:39.870 Nicolas Sucari: Lifetime.
53 00:03:39.870 ⇒ 00:03:41.644 Ryan Luke Daque: I guess we’ll have to create
54 00:03:41.940 ⇒ 00:03:45.479 Nicolas Sucari: Okay, wait. We have customer lifetime value in
55 00:03:46.030 ⇒ 00:03:52.389 Nicolas Sucari: customers. Yaml, file here in mark customers. Wait a minute
56 00:03:55.182 ⇒ 00:03:57.770 Nicolas Sucari: from analytic smart.
57 00:04:02.050 ⇒ 00:04:03.579 Nicolas Sucari: Don’t we? Have here
58 00:04:06.780 ⇒ 00:04:07.650 Nicolas Sucari: quantity.
59 00:04:09.360 ⇒ 00:04:12.010 Nicolas Sucari: No, it’s not analytic. Smart.
60 00:04:14.680 ⇒ 00:04:18.120 Nicolas Sucari: Okay, now, it’s not analytics. Probably it’s
61 00:04:22.780 ⇒ 00:04:24.839 Nicolas Sucari: dbt, no.
62 00:04:28.750 ⇒ 00:04:31.250 Nicolas Sucari: let me check something real quick.
63 00:04:36.090 ⇒ 00:04:37.110 Nicolas Sucari: hmm.
64 00:04:37.140 ⇒ 00:04:39.389 Nicolas Sucari: we don’t have lifetime value.
65 00:04:40.060 ⇒ 00:04:40.830 Ryan Luke Daque: Yeah.
66 00:04:42.610 ⇒ 00:04:45.840 Nicolas Sucari: But I’m I’m seeing it in Vs code. In
67 00:04:47.690 ⇒ 00:04:57.119 Nicolas Sucari: like, we have a a measure that’s customer lifetime value calculated in mobile marts, customers in the customers. Yaml file.
68 00:04:57.970 ⇒ 00:05:00.053 Ryan Luke Daque: Wait! Let me open my.
69 00:05:00.470 ⇒ 00:05:00.880 Nicolas Sucari: I mean.
70 00:05:00.880 ⇒ 00:05:01.659 Ryan Luke Daque: Is, your.
71 00:05:02.370 ⇒ 00:05:04.520 Nicolas Sucari: Wait, wait. I can share my Vs code.
72 00:05:07.450 ⇒ 00:05:10.050 Nicolas Sucari: how do I change what I’m sharing? Okay, here.
73 00:05:13.130 ⇒ 00:05:15.349 Ryan Luke Daque: I guess you need to stop sharing and then share.
74 00:05:15.350 ⇒ 00:05:16.800 Nicolas Sucari: Oh, no, that’s it, I think.
75 00:05:16.800 ⇒ 00:05:18.460 Ryan Luke Daque: Yeah, yeah, I see, yeah.
76 00:05:18.640 ⇒ 00:05:23.100 Ryan Luke Daque: customer lifetime. Valued. Yeah, it looks like it’s coming from.
77 00:05:23.490 ⇒ 00:05:27.400 Nicolas Sucari: Customer sample file. So it’s here in Model March.
78 00:05:28.150 ⇒ 00:05:30.279 Nicolas Sucari: but it’s under DVD project.
79 00:05:30.860 ⇒ 00:05:32.600 Ryan Luke Daque: So if that is
80 00:05:34.000 ⇒ 00:05:37.540 Ryan Luke Daque: yeah, I guess we we can just sum that up in the real
81 00:05:37.910 ⇒ 00:05:40.190 Ryan Luke Daque: models, and then we should have a
82 00:05:40.650 ⇒ 00:05:42.740 Ryan Luke Daque: lifetime value. I guess.
83 00:05:43.670 ⇒ 00:05:44.659 Nicolas Sucari: So we need to add.
84 00:05:44.660 ⇒ 00:05:45.390 Ryan Luke Daque: For it.
85 00:05:45.610 ⇒ 00:05:51.919 Ryan Luke Daque: Yeah, we need to add a measure in in real. That’s customer lifetime value
86 00:05:52.220 ⇒ 00:05:54.089 Ryan Luke Daque: or like lifetime value.
87 00:05:54.490 ⇒ 00:05:57.350 Ryan Luke Daque: which is basically just a sum of that
88 00:05:57.390 ⇒ 00:05:58.450 Ryan Luke Daque: field.
89 00:05:59.550 ⇒ 00:06:02.870 Nicolas Sucari: Okay. So we should like, we need to add the source
90 00:06:03.270 ⇒ 00:06:07.089 Nicolas Sucari: to get like a customer’s table, or something right.
91 00:06:08.070 ⇒ 00:06:08.740 Ryan Luke Daque: Yeah.
92 00:06:09.320 ⇒ 00:06:09.900 Nicolas Sucari: Query.
93 00:06:10.070 ⇒ 00:06:15.360 Ryan Luke Daque: Don’t we have a there’s a shopify customers that Yaml. Maybe that’s it.
94 00:06:15.970 ⇒ 00:06:21.580 Nicolas Sucari: No, but shopify customers is getting the rate like it’s getting from. Wait.
95 00:06:23.288 ⇒ 00:06:26.289 Nicolas Sucari: Because, yeah, it’s getting from another place.
96 00:06:26.490 ⇒ 00:06:29.529 Nicolas Sucari: How can I? Okay to this. Okay.
97 00:06:29.630 ⇒ 00:06:32.400 Nicolas Sucari: sure, too. Can you see 2 things? Now.
98 00:06:33.120 ⇒ 00:06:36.042 Ryan Luke Daque: He, I can only see the
99 00:06:36.550 ⇒ 00:06:39.509 Ryan Luke Daque: yeah, I can see. Yeah, I can see 2 things now.
100 00:06:41.290 ⇒ 00:06:42.000 Nicolas Sucari: Like that.
101 00:06:44.340 ⇒ 00:06:45.349 Nicolas Sucari: Yeah, I think so.
102 00:06:45.350 ⇒ 00:06:45.970 Ryan Luke Daque: So.
103 00:06:45.970 ⇒ 00:06:47.949 Nicolas Sucari: But if I move them okay, let me see.
104 00:06:49.550 ⇒ 00:06:51.109 Nicolas Sucari: Still seeing 2 things.
105 00:06:51.530 ⇒ 00:06:53.890 Ryan Luke Daque: No, I can only see the Vs code.
106 00:06:54.420 ⇒ 00:06:55.030 Nicolas Sucari: Okay.
107 00:06:56.350 ⇒ 00:06:58.179 Nicolas Sucari: Shit. How do I?
108 00:06:58.220 ⇒ 00:06:59.449 Nicolas Sucari: Okay, now? Yes.
109 00:07:00.180 ⇒ 00:07:00.990 Nicolas Sucari: perfect.
110 00:07:00.990 ⇒ 00:07:06.569 Ryan Luke Daque: Yeah, so shopify customers, and the other like the the query you had in.
111 00:07:08.100 ⇒ 00:07:09.840 Ryan Luke Daque: I mean the the real
112 00:07:11.110 ⇒ 00:07:12.150 Ryan Luke Daque: well.
113 00:07:14.070 ⇒ 00:07:16.600 Nicolas Sucari: The real one. Yeah, because shopify.
114 00:07:16.600 ⇒ 00:07:19.880 Ryan Luke Daque: The real one is, yeah. The real one is shopify customers.
115 00:07:19.880 ⇒ 00:07:23.709 Nicolas Sucari: Shopify customers. So it’s it’s getting from.
116 00:07:26.160 ⇒ 00:07:28.200 Nicolas Sucari: this is getting from analytics.
117 00:07:28.950 ⇒ 00:07:30.350 Nicolas Sucari: skating from here.
118 00:07:30.590 ⇒ 00:07:32.590 Nicolas Sucari: smart tables.
119 00:07:33.880 ⇒ 00:07:35.640 Nicolas Sucari: shopify customers. You see.
120 00:07:36.270 ⇒ 00:07:36.970 Ryan Luke Daque: Right.
121 00:07:46.140 ⇒ 00:07:49.029 Nicolas Sucari: But sorry.
122 00:07:49.409 ⇒ 00:07:53.199 Ryan Luke Daque: What about the customer? The lifetime value? Where which model.
123 00:07:53.200 ⇒ 00:07:58.410 Nicolas Sucari: The lifetime value. Yeah, it’s in another model, and I don’t. I can’t see it here in
124 00:07:59.660 ⇒ 00:08:06.599 Nicolas Sucari: in in Snowflake, because I don’t have access, because it’s here on Mobile March.
125 00:08:07.090 ⇒ 00:08:07.529 Ryan Luke Daque: You mean you.
126 00:08:07.530 ⇒ 00:08:09.570 Nicolas Sucari: Under DVD project right? And
127 00:08:09.620 ⇒ 00:08:12.280 Nicolas Sucari: when I when when I go to see this
128 00:08:12.540 ⇒ 00:08:16.250 Nicolas Sucari: customers, this is here lifetime, customer lifetime value.
129 00:08:16.840 ⇒ 00:08:17.200 Ryan Luke Daque: So it’s.
130 00:08:17.200 ⇒ 00:08:17.710 Nicolas Sucari: And show.
131 00:08:17.710 ⇒ 00:08:21.379 Ryan Luke Daque: Shopify discounts versus repeated orders.
132 00:08:22.420 ⇒ 00:08:24.899 Ryan Luke Daque: Is there any other customer lifetime.
133 00:08:24.900 ⇒ 00:08:25.879 Nicolas Sucari: Okay, this one.
134 00:08:26.660 ⇒ 00:08:27.770 Nicolas Sucari: this one, right?
135 00:08:28.610 ⇒ 00:08:29.670 Ryan Luke Daque: Yeah.
136 00:08:31.100 ⇒ 00:08:32.299 Nicolas Sucari: Scheduled Diego.
137 00:08:34.400 ⇒ 00:08:37.730 Nicolas Sucari: Oh, I went to the database. Okay, now let me go back.
138 00:08:40.730 ⇒ 00:08:43.500 Ryan Luke Daque: Yeah, I guess we’ll have to add that
139 00:08:43.650 ⇒ 00:08:46.949 Ryan Luke Daque: to the shopify customers model in Dbt.
140 00:08:47.880 ⇒ 00:08:48.605 Ryan Luke Daque: and
141 00:08:49.580 ⇒ 00:08:51.859 Ryan Luke Daque: so we can use it like we can.
142 00:08:53.220 ⇒ 00:08:55.930 Ryan Luke Daque: we can add a metric for it in real.
143 00:08:57.390 ⇒ 00:08:58.710 Nicolas Sucari: Okay, get it.
144 00:08:59.260 ⇒ 00:09:05.859 Nicolas Sucari: Oh, if I do, this was discomforce of repeat orders. Limit 10. Let me run this one.
145 00:09:08.860 ⇒ 00:09:11.790 Ryan Luke Daque: It has discounts, so it doesn’t
146 00:09:12.270 ⇒ 00:09:13.840 Ryan Luke Daque: have any.
147 00:09:14.030 ⇒ 00:09:16.320 Nicolas Sucari: Yeah, this one customer lifetime value, right?
148 00:09:16.660 ⇒ 00:09:20.610 Ryan Luke Daque: Yeah, but it’s not. It’s only tied to the discount code and not.
149 00:09:20.610 ⇒ 00:09:21.010 Nicolas Sucari: Yeah.
150 00:09:21.010 ⇒ 00:09:23.070 Ryan Luke Daque: Customers. So we have to make
151 00:09:24.240 ⇒ 00:09:28.470 Ryan Luke Daque: something like that in the shopify customers model basically.
152 00:09:29.050 ⇒ 00:09:31.100 Nicolas Sucari: We don’t have it here anywhere.
153 00:09:32.480 ⇒ 00:09:33.280 Nicolas Sucari: No.
154 00:09:34.960 ⇒ 00:09:35.640 Nicolas Sucari: yep.
155 00:09:36.550 ⇒ 00:09:37.700 Nicolas Sucari: yeah.
156 00:09:39.380 ⇒ 00:09:46.399 Ryan Luke Daque: We’ll have to figure out like what the current logic is for that one. I’m not sure I can’t remember creating that. So maybe somebody else
157 00:09:46.700 ⇒ 00:09:49.619 Ryan Luke Daque: created that before, maybe Utam or something.
158 00:09:49.990 ⇒ 00:09:50.740 Ryan Luke Daque: But.
159 00:09:51.350 ⇒ 00:09:52.919 Nicolas Sucari: So this is here.
160 00:09:53.800 ⇒ 00:09:54.770 Nicolas Sucari: you see.
161 00:09:59.730 ⇒ 00:10:01.930 Nicolas Sucari: customer lifetime value
162 00:10:07.260 ⇒ 00:10:12.030 Nicolas Sucari: in total try. Okay, yeah, we need to check this right? I don’t know how to
163 00:10:12.160 ⇒ 00:10:13.090 Nicolas Sucari: Toddles.
164 00:10:13.290 ⇒ 00:10:15.980 Ryan Luke Daque: Yes, it looks like R.
165 00:10:16.330 ⇒ 00:10:18.180 Ryan Luke Daque: Repeat order. So.
166 00:10:18.870 ⇒ 00:10:21.340 Nicolas Sucari: Total spend, while the customer repeat orders.
167 00:10:22.210 ⇒ 00:10:30.749 Ryan Luke Daque: So it’s from shopify orders. It’s it’s just some of item total price. So if if item total price is in
168 00:10:32.571 ⇒ 00:10:35.909 Ryan Luke Daque: shopify customers. I’m not sure what it’s called there.
169 00:10:35.950 ⇒ 00:10:39.719 Ryan Luke Daque: but then we can just sum it per customer id
170 00:10:40.070 ⇒ 00:10:43.390 Ryan Luke Daque: in real, and that should give us the total lifetime.
171 00:10:43.390 ⇒ 00:10:47.219 Nicolas Sucari: But I don’t know if we have like item total price here
172 00:10:50.820 ⇒ 00:10:51.490 Nicolas Sucari: it.
173 00:10:53.640 ⇒ 00:10:55.920 Ryan Luke Daque: Alright cause. It’s.
174 00:10:56.680 ⇒ 00:10:57.380 Nicolas Sucari: Yeah.
175 00:10:57.380 ⇒ 00:10:58.939 Ryan Luke Daque: This is Customer.
176 00:10:58.940 ⇒ 00:10:59.849 Nicolas Sucari: That’s not
177 00:11:00.210 ⇒ 00:11:01.319 Nicolas Sucari: not all over the right.
178 00:11:01.320 ⇒ 00:11:06.030 Ryan Luke Daque: Probably in. Yeah. It’s probably in all orders or all
179 00:11:06.040 ⇒ 00:11:07.730 Ryan Luke Daque: order items, even.
180 00:11:08.270 ⇒ 00:11:10.460 Nicolas Sucari: Yeah, I think it should be.
181 00:11:11.040 ⇒ 00:11:13.480 Ryan Luke Daque: I think it’s all in all order items.
182 00:11:14.720 ⇒ 00:11:15.290 Nicolas Sucari: Yeah.
183 00:11:25.250 ⇒ 00:11:28.250 Nicolas Sucari: we’re looking for item, total price.
184 00:11:28.770 ⇒ 00:11:29.590 Ryan Luke Daque: Yeah.
185 00:11:30.960 ⇒ 00:11:33.399 Ryan Luke Daque: it should be in all order items.
186 00:11:33.400 ⇒ 00:11:35.170 Nicolas Sucari: Item, sale price.
187 00:11:39.310 ⇒ 00:11:40.659 Nicolas Sucari: Or is this one
188 00:11:43.660 ⇒ 00:11:45.370 Nicolas Sucari: item, sale, price.
189 00:11:46.830 ⇒ 00:11:49.840 Ryan Luke Daque: Yeah, I think that’s it. Item, sale price.
190 00:11:51.750 ⇒ 00:11:53.219 Nicolas Sucari: Yeah, because we don’t have.
191 00:11:53.950 ⇒ 00:11:56.809 Ryan Luke Daque: But we don’t have customers right in that
192 00:11:57.250 ⇒ 00:12:00.270 Ryan Luke Daque: or customer. Maybe there’s a customer. Id.
193 00:12:05.340 ⇒ 00:12:06.700 Ryan Luke Daque: yeah, I think we need a
194 00:12:07.760 ⇒ 00:12:09.530 Ryan Luke Daque: a mapping table.
195 00:12:13.240 ⇒ 00:12:13.880 Nicolas Sucari: Yeah.
196 00:12:14.000 ⇒ 00:12:16.439 Nicolas Sucari: okay, so not that simple. Okay.
197 00:12:20.750 ⇒ 00:12:24.350 Nicolas Sucari: okay. Yeah. I think we need to.
198 00:12:25.200 ⇒ 00:12:26.690 Ryan Luke Daque: Yeah, we need to add that.
199 00:12:27.410 ⇒ 00:12:34.840 Nicolas Sucari: So probably it. It should be good to add that lifetime value measure into this
200 00:12:36.010 ⇒ 00:12:38.319 Nicolas Sucari: into this dashboard right.
201 00:12:38.320 ⇒ 00:12:42.810 Ryan Luke Daque: Yeah, right? Which is the which is coming from the customers model. So yeah.
202 00:12:43.070 ⇒ 00:12:43.540 Nicolas Sucari: If we can.
203 00:12:43.540 ⇒ 00:12:45.670 Ryan Luke Daque: Lifetime value in.
204 00:12:45.670 ⇒ 00:12:46.160 Nicolas Sucari: Yeah.
205 00:12:46.160 ⇒ 00:12:47.990 Ryan Luke Daque: Or smaller. Naturally.
206 00:12:48.690 ⇒ 00:12:51.209 Ryan Luke Daque: Yeah, I think that’s possible. Yeah.
207 00:12:52.130 ⇒ 00:12:55.729 Nicolas Sucari: Okay, very probably we need to create a ticket for that one. Alright.
208 00:12:56.090 ⇒ 00:12:56.420 Ryan Luke Daque: Yeah.
209 00:12:56.420 ⇒ 00:12:57.310 Nicolas Sucari: Oh.
210 00:13:00.930 ⇒ 00:13:02.030 Nicolas Sucari: okay.
211 00:13:02.840 ⇒ 00:13:04.699 Nicolas Sucari: I can do that right now.
212 00:13:05.210 ⇒ 00:13:12.489 Nicolas Sucari: And yeah, I’m gonna ask you them if we need that one like right away, like the client is asking for that, but I don’t know.
213 00:13:13.240 ⇒ 00:13:14.010 Ryan Luke Daque: Hmm.
214 00:13:17.260 ⇒ 00:13:18.520 Nicolas Sucari: Pull apart.
215 00:13:22.470 ⇒ 00:13:23.540 Nicolas Sucari: Add
216 00:13:25.220 ⇒ 00:13:26.640 Nicolas Sucari: customer
217 00:13:28.770 ⇒ 00:13:30.370 Nicolas Sucari: lifetime
218 00:13:32.710 ⇒ 00:13:34.980 Nicolas Sucari: audio to the
219 00:13:35.230 ⇒ 00:13:36.720 Nicolas Sucari: shopify.
220 00:13:47.110 ⇒ 00:13:47.670 Ryan Luke Daque: Yeah.
221 00:13:53.850 ⇒ 00:13:56.590 Ryan Luke Daque: So first, st we need to add it in the shopify customers.
222 00:13:56.590 ⇒ 00:13:57.450 Nicolas Sucari: Yeah.
223 00:13:57.690 ⇒ 00:13:59.649 Nicolas Sucari: I would like to invite you.
224 00:14:01.460 ⇒ 00:14:02.110 Ryan Luke Daque: Yeah.
225 00:14:03.320 ⇒ 00:14:04.000 Ryan Luke Daque: weird.
226 00:14:04.000 ⇒ 00:14:05.210 Nicolas Sucari: Customer. Small it is.
227 00:14:05.210 ⇒ 00:14:06.600 Ryan Luke Daque: Yeah.
228 00:14:09.630 ⇒ 00:14:12.729 Nicolas Sucari: So we need to add it here as a source right?
229 00:14:15.070 ⇒ 00:14:16.960 Ryan Luke Daque: Right, either there, or maybe the
230 00:14:17.890 ⇒ 00:14:23.649 Ryan Luke Daque: well, I guess we can add it there. Yeah, I guess we can just add it there. We don’t have to add it in the model.
231 00:14:39.420 ⇒ 00:14:44.269 Nicolas Sucari: Yeah. But yeah, because we if we add it there, then the model is calling everything. I think
232 00:14:44.380 ⇒ 00:14:45.080 Nicolas Sucari: right.
233 00:14:46.500 ⇒ 00:14:47.260 Ryan Luke Daque: Yeah.
234 00:14:47.260 ⇒ 00:14:49.740 Nicolas Sucari: You know we will need to add it here right?
235 00:14:51.690 ⇒ 00:14:52.210 Nicolas Sucari: Yep.
236 00:14:52.494 ⇒ 00:14:54.770 Ryan Luke Daque: We’ll have to add it there as well.
237 00:15:02.420 ⇒ 00:15:03.380 Nicolas Sucari: These.
238 00:15:03.640 ⇒ 00:15:06.150 Nicolas Sucari: and then the measure
239 00:15:07.680 ⇒ 00:15:09.240 Nicolas Sucari: lifetime value
240 00:15:09.890 ⇒ 00:15:10.940 Nicolas Sucari: 5
241 00:15:10.970 ⇒ 00:15:12.290 Nicolas Sucari: time
242 00:15:12.960 ⇒ 00:15:15.989 Nicolas Sucari: value to the dashboard.
243 00:15:17.120 ⇒ 00:15:18.000 Nicolas Sucari: Here.
244 00:15:18.200 ⇒ 00:15:22.930 Nicolas Sucari: let’s go to the dashboard to see it’s typically customers here. Right?
245 00:15:26.260 ⇒ 00:15:27.060 Nicolas Sucari: Okay.
246 00:15:27.460 ⇒ 00:15:28.140 Nicolas Sucari: yep.
247 00:15:38.600 ⇒ 00:15:39.500 Nicolas Sucari: okay.
248 00:15:41.590 ⇒ 00:15:47.279 Nicolas Sucari: perfect. I’ll have it here in backlog, probably, and move it into ready.
249 00:15:48.750 ⇒ 00:15:49.580 Nicolas Sucari: Okay.
250 00:15:50.523 ⇒ 00:15:53.880 Nicolas Sucari: do you think it’s something quick to do, Ryan?
251 00:15:55.030 ⇒ 00:15:58.710 Ryan Luke Daque: Yeah, I can. Yeah, I think I can work on that
252 00:15:59.840 ⇒ 00:16:02.039 Ryan Luke Daque: now if it’s needed.
253 00:16:02.670 ⇒ 00:16:07.290 Nicolas Sucari: Yeah, they are asking that one if you can. Just yeah, try to
254 00:16:07.400 ⇒ 00:16:10.589 Nicolas Sucari: get that done, let let me know I can.
255 00:16:10.600 ⇒ 00:16:14.770 Nicolas Sucari: Once that is in real. I can take it out and export what they need right.
256 00:16:15.200 ⇒ 00:16:16.810 Ryan Luke Daque: Okay. Sounds good.
257 00:16:17.310 ⇒ 00:16:20.489 Nicolas Sucari: If it is, if it’s easy. If you’re like finding any
258 00:16:20.620 ⇒ 00:16:28.890 Nicolas Sucari: problem with that, let me know. And we just I’m gonna say that we don’t have that in the data we were, we gonna work it next week, right?
259 00:16:28.940 ⇒ 00:16:31.050 Nicolas Sucari: But if you can do it, let me know. Okay.
260 00:16:31.050 ⇒ 00:16:32.780 Ryan Luke Daque: Yeah, sure. Sounds good.
261 00:16:33.320 ⇒ 00:16:35.920 Nicolas Sucari: Thank you. Thank you very much for your help.
262 00:16:36.460 ⇒ 00:16:39.789 Ryan Luke Daque: No problem. Thanks, Nicholas. Have a nice rest of your day.
263 00:16:40.400 ⇒ 00:16:41.070 Nicolas Sucari: Bye, bye.
264 00:16:41.430 ⇒ 00:16:42.090 Ryan Luke Daque: Bye, bye.