Meeting Title: Zoom Meeting Date: 2024-10-29 Meeting participants: Luke Daque, Nicolas Sucari
WEBVTT
1 00:00:05.820 ⇒ 00:00:06.510 Luke Daque: Hello!
2 00:00:07.430 ⇒ 00:00:08.690 Nicolas Sucari: Can’t hear you. Now. Yeah.
3 00:00:08.900 ⇒ 00:00:10.580 Luke Daque: Yeah, that’s what’s weird.
4 00:00:10.580 ⇒ 00:00:11.400 Nicolas Sucari: Problem yeah.
5 00:00:11.810 ⇒ 00:00:14.889 Luke Daque: Maybe maybe my mic wasn’t
6 00:00:15.750 ⇒ 00:00:16.320 Luke Daque: picked up.
7 00:00:16.990 ⇒ 00:00:17.710 Luke Daque: Yeah, one.
8 00:00:18.560 ⇒ 00:00:26.090 Nicolas Sucari: I. I just refreshed the source. And that worked. Yeah, I was getting an error. But I think it’s because the source wasn’t getting refreshed.
9 00:00:26.120 ⇒ 00:00:30.140 Nicolas Sucari: so I can see everything now. I think you changed the
10 00:00:30.300 ⇒ 00:00:32.840 Nicolas Sucari: shopify order metric dashboard! Right.
11 00:00:33.860 ⇒ 00:00:39.680 Luke Daque: Yeah, the one, the the one that had dev in it. But it’s now appointing to prod. So I removed the dev.
12 00:00:41.200 ⇒ 00:00:42.150 Nicolas Sucari: Okay.
13 00:00:42.150 ⇒ 00:00:42.750 Luke Daque: Yeah.
14 00:00:44.350 ⇒ 00:00:46.540 Nicolas Sucari: But you’re pointing to Prod.
15 00:00:46.750 ⇒ 00:00:48.340 Nicolas Sucari: but my only
16 00:00:48.550 ⇒ 00:00:53.950 Nicolas Sucari: my only concern is what I thought we should let me share like. Give me a minute.
17 00:00:54.720 ⇒ 00:00:55.069 Luke Daque: For sure.
18 00:00:55.070 ⇒ 00:00:56.150 Nicolas Sucari: Share.
19 00:01:00.390 ⇒ 00:01:08.570 Nicolas Sucari: Yeah, okay, so you you changed go to Bs code. You changed this file right?
20 00:01:08.610 ⇒ 00:01:10.050 Nicolas Sucari: You made
21 00:01:10.070 ⇒ 00:01:12.690 Nicolas Sucari: these change like this file
22 00:01:12.770 ⇒ 00:01:22.110 Nicolas Sucari: to get from prod right? But the so it’s getting from this model now. Okay, so it’s getting from the pro table. That is this one. That’s okay.
23 00:01:22.430 ⇒ 00:01:26.869 Nicolas Sucari: But but Payas was using this
24 00:01:27.200 ⇒ 00:01:28.110 Nicolas Sucari: this
25 00:01:28.320 ⇒ 00:01:29.720 Nicolas Sucari: query.
26 00:01:30.410 ⇒ 00:01:32.710 Luke Daque: Yeah, which we.
27 00:01:34.580 ⇒ 00:01:43.520 Nicolas Sucari: Because he was. He was like differentiating for new and returning customers and just filtering out the Tiktok shop fault. That’s why, if I
28 00:01:43.940 ⇒ 00:01:46.985 Nicolas Sucari: now go to this dashboard that I have it like here, you know.
29 00:01:47.220 ⇒ 00:01:48.380 Luke Daque: Show Amazon.
30 00:01:49.180 ⇒ 00:01:55.280 Nicolas Sucari: Yeah, it will show everything. That’s why that’s why I my idea was not to change like this model here.
31 00:01:55.840 ⇒ 00:01:56.280 Luke Daque: To check.
32 00:01:56.280 ⇒ 00:02:05.769 Nicolas Sucari: But to change this file instead, and instead of here getting from the Dev table, we should have here the dev
33 00:02:05.970 ⇒ 00:02:07.289 Nicolas Sucari: the prod table.
34 00:02:07.290 ⇒ 00:02:08.430 Luke Daque: Abroad. Yeah.
35 00:02:08.430 ⇒ 00:02:14.160 Nicolas Sucari: Yeah, and that. And and when I when I did this to change, if I change this to prod.
36 00:02:14.730 ⇒ 00:02:16.860 Nicolas Sucari: this is pro.
37 00:02:17.630 ⇒ 00:02:20.850 Luke Daque: Yeah, that. Yeah, that should work. Yeah.
38 00:02:21.090 ⇒ 00:02:29.270 Luke Daque: But we should. We can. We can remove line 11 to 19. The order line cost. Ct, cause. I already added that to the.
39 00:02:30.210 ⇒ 00:02:31.800 Nicolas Sucari: So these can be removed.
40 00:02:32.610 ⇒ 00:02:33.810 Luke Daque: Yes, that’s correct.
41 00:02:35.620 ⇒ 00:02:36.060 Nicolas Sucari: Okay.
42 00:02:36.060 ⇒ 00:02:36.890 Luke Daque: Back, now.
43 00:02:38.480 ⇒ 00:02:39.010 Nicolas Sucari: Underneath.
44 00:02:39.010 ⇒ 00:02:39.660 Luke Daque: And
45 00:02:41.220 ⇒ 00:02:43.200 Luke Daque: and remove the join.
46 00:02:47.740 ⇒ 00:02:48.250 Nicolas Sucari: Everything.
47 00:02:49.380 ⇒ 00:02:50.320 Luke Daque: Well, let me know.
48 00:02:51.470 ⇒ 00:02:54.080 Luke Daque: Yeah, I think you can just remove everything
49 00:02:55.240 ⇒ 00:02:56.090 Luke Daque: from.
50 00:02:56.090 ⇒ 00:02:57.409 Nicolas Sucari: Okay, so like this.
51 00:02:57.410 ⇒ 00:02:58.729 Luke Daque: Yeah, like that. Yeah.
52 00:02:58.770 ⇒ 00:03:03.029 Luke Daque: including the the parentheses and the line. The 1st row.
53 00:03:03.160 ⇒ 00:03:04.699 Luke Daque: Just remove the 1st row.
54 00:03:05.920 ⇒ 00:03:06.670 Luke Daque: Yep.
55 00:03:06.900 ⇒ 00:03:08.790 Luke Daque: that should work.
56 00:03:09.740 ⇒ 00:03:10.519 Luke Daque: Oh, wait.
57 00:03:11.540 ⇒ 00:03:14.280 Luke Daque: I think you can also remove the case
58 00:03:14.920 ⇒ 00:03:19.220 Luke Daque: statement because we already have customer type in there as well.
59 00:03:20.970 ⇒ 00:03:30.410 Luke Daque: So we just need where is tick. Tock shop is false, so it it can be select star from broad fact orders. Where is tick. Tock shop is false.
60 00:03:31.770 ⇒ 00:03:32.380 Nicolas Sucari: This.
61 00:03:34.230 ⇒ 00:03:34.850 Luke Daque: Yeah.
62 00:03:36.930 ⇒ 00:03:38.020 Nicolas Sucari: Let’s try it.
63 00:03:39.500 ⇒ 00:03:41.750 Nicolas Sucari: The only thing is I have these.
64 00:03:45.950 ⇒ 00:03:47.700 Nicolas Sucari: Should I rename this.
65 00:03:48.620 ⇒ 00:03:52.399 Luke Daque: Yeah, I guess. Remove the depth cause. It’s confusing.
66 00:03:53.090 ⇒ 00:03:55.350 Nicolas Sucari: Yeah. But wait, let me do something.
67 00:03:57.810 ⇒ 00:04:00.369 Nicolas Sucari: Should I copy duplicated
68 00:04:10.440 ⇒ 00:04:12.210 Nicolas Sucari: because this should be prod.
69 00:04:16.110 ⇒ 00:04:18.220 Luke Daque: Yeah, that that should be fine.
70 00:04:21.160 ⇒ 00:04:23.709 Nicolas Sucari: And can I go back here? Yeah.
71 00:04:25.620 ⇒ 00:04:27.040 Nicolas Sucari: to keep everything
72 00:04:27.960 ⇒ 00:04:29.249 Nicolas Sucari: there we go right.
73 00:04:31.150 ⇒ 00:04:32.160 Luke Daque: Yeah, okay, that
74 00:04:32.350 ⇒ 00:04:33.280 Luke Daque: that’s fine.
75 00:04:33.280 ⇒ 00:04:39.510 Nicolas Sucari: So if I use this one now, this is the one that we created, and I generate a dashboard with it
76 00:04:39.610 ⇒ 00:04:40.350 Nicolas Sucari: right.
77 00:04:40.720 ⇒ 00:04:41.450 Luke Daque: Yeah.
78 00:04:41.820 ⇒ 00:04:42.740 Luke Daque: or you can update
79 00:04:43.490 ⇒ 00:04:45.649 Luke Daque: shopify orders dashboard
80 00:04:46.000 ⇒ 00:04:47.900 Luke Daque: and point it to.
81 00:04:48.180 ⇒ 00:04:52.250 Luke Daque: I mean the the source to prod shopify orders.
82 00:04:53.010 ⇒ 00:04:53.600 Luke Daque: Yeah.
83 00:04:53.600 ⇒ 00:04:54.199 Nicolas Sucari: Use one.
84 00:04:54.440 ⇒ 00:04:59.899 Luke Daque: Model. Yeah. Instead of broad fact orders model. It will be proud, shopify orders, model.
85 00:05:02.590 ⇒ 00:05:05.820 Nicolas Sucari: Yeah. But the only thing here is that in this one
86 00:05:07.630 ⇒ 00:05:09.490 Nicolas Sucari: I need to add.
87 00:05:10.080 ⇒ 00:05:13.319 Nicolas Sucari: I need to add a clause to just use upsource, shopify right?
88 00:05:16.190 ⇒ 00:05:17.948 Luke Daque: All right. Yes, that’s correct.
89 00:05:24.170 ⇒ 00:05:25.220 Nicolas Sucari: It’s the case.
90 00:05:26.000 ⇒ 00:05:26.530 Luke Daque: Obviously.
91 00:05:26.530 ⇒ 00:05:27.490 Nicolas Sucari: Source.
92 00:05:27.700 ⇒ 00:05:28.960 Nicolas Sucari: Equals
93 00:05:30.510 ⇒ 00:05:31.519 Nicolas Sucari: should be fine.
94 00:05:32.380 ⇒ 00:05:33.220 Luke Daque: Yep.
95 00:05:37.100 ⇒ 00:05:37.960 Nicolas Sucari: Fine.
96 00:05:39.180 ⇒ 00:05:40.829 Nicolas Sucari: and these should be fine right.
97 00:05:41.950 ⇒ 00:05:42.870 Luke Daque: Yep.
98 00:05:43.950 ⇒ 00:05:44.650 Luke Daque: it’s good.
99 00:05:44.650 ⇒ 00:05:45.560 Nicolas Sucari: Curious.
100 00:05:49.660 ⇒ 00:05:52.990 Nicolas Sucari: We have returning, and you know the customer type subscription order.
101 00:05:54.010 ⇒ 00:05:54.830 Nicolas Sucari: cool
102 00:05:55.730 ⇒ 00:05:56.430 Nicolas Sucari: right.
103 00:05:57.820 ⇒ 00:05:58.710 Luke Daque: Yep.
104 00:05:58.910 ⇒ 00:05:59.400 Luke Daque: Yeah.
105 00:05:59.400 ⇒ 00:06:06.179 Nicolas Sucari: Make an update. Okay, wait. Before updating this live. Let me create a pull request. Maybe right?
106 00:06:08.565 ⇒ 00:06:11.899 Nicolas Sucari: Create new branch. This would be.
107 00:06:12.290 ⇒ 00:06:13.420 Nicolas Sucari: yeah.
108 00:06:13.600 ⇒ 00:06:15.050 Nicolas Sucari: She’ll be fine
109 00:06:15.590 ⇒ 00:06:16.520 Nicolas Sucari: role.
110 00:06:18.030 ⇒ 00:06:19.829 Nicolas Sucari: mobile, real.
111 00:06:24.740 ⇒ 00:06:26.020 Nicolas Sucari: which branch.
112 00:06:27.710 ⇒ 00:06:32.580 Nicolas Sucari: So these are the only changes I’m doing. Publish branch. It’s okay.
113 00:06:33.630 ⇒ 00:06:35.280 Nicolas Sucari: I need to commit
114 00:06:41.400 ⇒ 00:06:42.090 Nicolas Sucari: great.
115 00:06:42.400 ⇒ 00:06:43.450 Nicolas Sucari: I can push.
116 00:06:44.120 ⇒ 00:06:44.680 Luke Daque: Yep.
117 00:06:48.550 ⇒ 00:06:49.959 Nicolas Sucari: Yes, that’s fine.
118 00:06:50.090 ⇒ 00:06:52.190 Nicolas Sucari: and I can preview the pull request.
119 00:06:59.220 ⇒ 00:07:02.319 Nicolas Sucari: And I’ll yeah, we’ll add you as a viewer.
120 00:07:04.490 ⇒ 00:07:06.829 Luke Daque: I think you can just merge it right away.
121 00:07:07.700 ⇒ 00:07:10.142 Luke Daque: because the this repo doesn’t have
122 00:07:11.480 ⇒ 00:07:13.900 Luke Daque: settings to have reviews.
123 00:07:19.430 ⇒ 00:07:20.670 Nicolas Sucari: Okay merged.
124 00:07:20.700 ⇒ 00:07:21.970 Nicolas Sucari: We did Branch.
125 00:07:22.490 ⇒ 00:07:28.599 Nicolas Sucari: That’s it. So now we have that one there. So if I go back to
126 00:07:29.200 ⇒ 00:07:30.250 Nicolas Sucari: here
127 00:07:30.870 ⇒ 00:07:31.660 Nicolas Sucari: right
128 00:07:33.750 ⇒ 00:07:35.049 Nicolas Sucari: and here
129 00:07:38.840 ⇒ 00:07:41.170 Nicolas Sucari: I need to fetch origin
130 00:07:42.970 ⇒ 00:07:44.140 Nicolas Sucari: full origin.
131 00:07:45.420 ⇒ 00:07:48.280 Nicolas Sucari: That’s it. So we have this one here. That’s fine.
132 00:07:49.225 ⇒ 00:07:49.960 Nicolas Sucari: The
133 00:07:50.790 ⇒ 00:07:55.419 Nicolas Sucari: shopify order model. This is getting from prod. So this is fine.
134 00:07:56.040 ⇒ 00:07:58.670 Nicolas Sucari: cool, and if I now go to
135 00:07:58.770 ⇒ 00:08:00.420 Nicolas Sucari: local host right?
136 00:08:01.660 ⇒ 00:08:02.340 Nicolas Sucari: Yep.
137 00:08:03.380 ⇒ 00:08:04.660 Nicolas Sucari: I got these
138 00:08:04.780 ⇒ 00:08:06.220 Nicolas Sucari: and then update.
139 00:08:06.860 ⇒ 00:08:07.480 Luke Daque: Yeah.
140 00:08:08.310 ⇒ 00:08:10.599 Luke Daque: we should. It should show in a bit.
141 00:08:11.450 ⇒ 00:08:12.229 Luke Daque: I see. I see.
142 00:08:12.230 ⇒ 00:08:12.920 Nicolas Sucari: Everyone.
143 00:08:13.530 ⇒ 00:08:15.880 Luke Daque: It’s it’s probably because the
144 00:08:17.530 ⇒ 00:08:20.419 Luke Daque: yeah, it’s gonna take a while to refresh. I guess.
145 00:08:22.240 ⇒ 00:08:23.530 Nicolas Sucari: To refresh the source.
146 00:08:24.340 ⇒ 00:08:25.070 Luke Daque: Oh.
147 00:08:25.620 ⇒ 00:08:26.820 Luke Daque: did you?
148 00:08:27.290 ⇒ 00:08:30.539 Luke Daque: Did you create a branch from Maine? Did you pull from Maine.
149 00:08:32.230 ⇒ 00:08:34.619 Nicolas Sucari: Yeah, yeah, I have your your latest.
150 00:08:34.620 ⇒ 00:08:35.480 Luke Daque: Oh, okay.
151 00:08:37.520 ⇒ 00:08:40.009 Nicolas Sucari: There’s something wrong with the cogs
152 00:08:42.690 ⇒ 00:08:45.389 Nicolas Sucari: with the total product cost. Okay, let me check.
153 00:08:45.750 ⇒ 00:08:47.960 Luke Daque: Yeah, maybe just refresh or something.
154 00:08:48.450 ⇒ 00:08:49.450 Nicolas Sucari: Yeah, maybe just.
155 00:08:49.450 ⇒ 00:08:51.080 Luke Daque: In in local, right.
156 00:08:51.080 ⇒ 00:08:52.799 Nicolas Sucari: Yeah. Locally, it was working.
157 00:08:53.480 ⇒ 00:08:56.999 Luke Daque: It’s probably just. It’s probably just needs a refresh.
158 00:09:01.040 ⇒ 00:09:02.880 Nicolas Sucari: It’s working here. See.
159 00:09:05.250 ⇒ 00:09:09.150 Luke Daque: Or can you try doing a real project? Update so that it
160 00:09:09.430 ⇒ 00:09:11.739 Luke Daque: refreshes the sources in.
161 00:09:14.490 ⇒ 00:09:16.020 Nicolas Sucari: And you say.
162 00:09:16.730 ⇒ 00:09:17.340 Nicolas Sucari: here.
163 00:09:17.340 ⇒ 00:09:18.520 Luke Daque: And yeah.
164 00:09:19.430 ⇒ 00:09:21.699 Nicolas Sucari: So I need to kill it. Open.
165 00:09:22.400 ⇒ 00:09:25.910 Nicolas Sucari: CD. Javi. Real project, refresh.
166 00:09:26.160 ⇒ 00:09:27.250 Luke Daque: Yes, that’s right.
167 00:09:27.800 ⇒ 00:09:29.180 Luke Daque: so it’ll refresh.
168 00:09:35.850 ⇒ 00:09:39.039 Luke Daque: Yep. Can can you check real now? It should be
169 00:09:39.650 ⇒ 00:09:41.850 Luke Daque: real. The status of the
170 00:09:42.050 ⇒ 00:09:43.070 Luke Daque: models.
171 00:09:45.110 ⇒ 00:09:46.790 Nicolas Sucari: With, this is local host.
172 00:10:04.450 ⇒ 00:10:05.790 Nicolas Sucari: It’s working, I think.
173 00:10:06.460 ⇒ 00:10:08.740 Nicolas Sucari: but there is an issue here.
174 00:10:27.690 ⇒ 00:10:29.900 Luke Daque: Can you? Can you click status?
175 00:10:30.770 ⇒ 00:10:34.869 Luke Daque: It’s yeah. It looks so. I think it’s still pending.
176 00:10:36.320 ⇒ 00:10:39.900 Luke Daque: Next refresh is 2, 20.
177 00:10:43.040 ⇒ 00:10:45.100 Luke Daque: Last refresh is 2 20.
178 00:10:47.200 ⇒ 00:10:50.309 Nicolas Sucari: That was, it was what I when I ran that real
179 00:10:50.420 ⇒ 00:10:52.039 Nicolas Sucari: project refresh right.
180 00:10:53.030 ⇒ 00:10:54.269 Luke Daque: Yeah, why is that
181 00:10:57.290 ⇒ 00:10:59.159 Luke Daque: shopify orders?
182 00:11:07.850 ⇒ 00:11:12.649 Luke Daque: The total pro, let me check. Because so I already added, the total product cost in.
183 00:11:13.420 ⇒ 00:11:15.659 Nicolas Sucari: Yeah, I’ve seen it. That’s why it’s weird.
184 00:11:18.350 ⇒ 00:11:19.030 Luke Daque: Bye.
185 00:11:21.040 ⇒ 00:11:21.510 Nicolas Sucari: Error!
186 00:11:23.120 ⇒ 00:11:25.390 Nicolas Sucari: Let me check.
187 00:11:29.680 ⇒ 00:11:33.160 Luke Daque: Mine looks to be working. I’m i i just opened it.
188 00:11:34.160 ⇒ 00:11:37.380 Nicolas Sucari: You are on a local host, or.
189 00:11:37.380 ⇒ 00:11:39.070 Luke Daque: In no, in the
190 00:11:41.320 ⇒ 00:11:41.840 Nicolas Sucari: The ui.
191 00:11:41.840 ⇒ 00:11:43.479 Luke Daque: The deployed one. Yeah.
192 00:11:45.050 ⇒ 00:11:45.520 Luke Daque: yeah.
193 00:11:45.520 ⇒ 00:11:49.650 Nicolas Sucari: Okay, that’s it. I think it’s working now it should. It was taking some time.
194 00:11:49.940 ⇒ 00:11:50.580 Luke Daque: Yeah.
195 00:11:52.840 ⇒ 00:11:57.040 Nicolas Sucari: So we need to match this with Meta Base right now. So it should be the same.
196 00:11:57.810 ⇒ 00:11:58.390 Luke Daque: Yep.
197 00:11:58.390 ⇒ 00:12:00.600 Nicolas Sucari: Or if you go previous month!
198 00:12:01.530 ⇒ 00:12:02.290 Nicolas Sucari: Whooped.
199 00:12:05.080 ⇒ 00:12:06.849 Luke Daque: Yeah, that should be the same. Now.
200 00:12:11.400 ⇒ 00:12:13.530 Nicolas Sucari: If I go to Meta Base
201 00:12:16.210 ⇒ 00:12:17.250 Nicolas Sucari: and.
202 00:12:17.250 ⇒ 00:12:19.010 Luke Daque: 1 8. So you’re
203 00:12:20.660 ⇒ 00:12:23.499 Luke Daque: you’re using GMT plus 3
204 00:12:25.350 ⇒ 00:12:26.090 Luke Daque: in real.
205 00:12:26.090 ⇒ 00:12:28.699 Nicolas Sucari: Oh, yeah, yeah, I need to change that wait.
206 00:12:30.350 ⇒ 00:12:32.100 Nicolas Sucari: I need to go to Utc, right?
207 00:12:33.070 ⇒ 00:12:34.580 Luke Daque: Yeah, I think, yeah.
208 00:12:38.500 ⇒ 00:12:41.270 Nicolas Sucari: And if I go to database, which one was.
209 00:12:45.810 ⇒ 00:12:52.959 Luke Daque: I think our analytics, if I remember, and then scroll down there should be like staging periodic.
210 00:12:52.960 ⇒ 00:12:53.720 Nicolas Sucari: If we want.
211 00:12:53.890 ⇒ 00:12:54.470 Luke Daque: Yeah.
212 00:12:59.460 ⇒ 00:13:03.570 Luke Daque: but I don’t think that’s updated, though.
213 00:13:04.510 ⇒ 00:13:05.710 Nicolas Sucari: No wait.
214 00:13:08.440 ⇒ 00:13:10.349 Luke Daque: Last one month, I guess.
215 00:13:14.830 ⇒ 00:13:18.130 Luke Daque: So. It’s 1, 1, 7, 9, 3, 3. There.
216 00:13:22.030 ⇒ 00:13:24.700 Luke Daque: I think it’s another. It’s it’s all it’s
217 00:13:26.110 ⇒ 00:13:27.390 Luke Daque: it’s because
218 00:13:29.070 ⇒ 00:13:33.450 Luke Daque: pay us was converting it to a different time zone, if I remember it correctly.
219 00:13:34.560 ⇒ 00:13:36.010 Nicolas Sucari: Pacific time, right.
220 00:13:36.590 ⇒ 00:13:38.510 Luke Daque: Yeah, let’s try pacific time.
221 00:13:40.115 ⇒ 00:13:44.249 Nicolas Sucari: Wait. But in order to try pacific time, I need to.
222 00:13:46.207 ⇒ 00:13:50.750 Nicolas Sucari: We need to add, because we don’t have it here because Edt is not pacific time right?
223 00:13:51.170 ⇒ 00:13:51.680 Nicolas Sucari: No.
224 00:13:51.740 ⇒ 00:13:53.190 Luke Daque: Right, yeah.
225 00:13:54.300 ⇒ 00:13:56.090 Nicolas Sucari: So we’ll need to add these
226 00:13:56.400 ⇒ 00:13:57.050 Nicolas Sucari: in.
227 00:13:57.050 ⇒ 00:13:57.670 Luke Daque: Yeah.
228 00:13:57.670 ⇒ 00:13:58.560 Nicolas Sucari: Here
229 00:13:59.710 ⇒ 00:14:03.509 Nicolas Sucari: there was a way. If I open
230 00:14:06.020 ⇒ 00:14:07.610 Nicolas Sucari: new window.
231 00:14:08.680 ⇒ 00:14:10.790 Nicolas Sucari: and if I open pull parts.
232 00:14:11.280 ⇒ 00:14:12.380 Nicolas Sucari: let me check.
233 00:14:15.740 ⇒ 00:14:18.520 Nicolas Sucari: There was yeah, something like this, right.
234 00:14:29.590 ⇒ 00:14:31.529 Luke Daque: Yeah, there, there we should have.
235 00:14:33.220 ⇒ 00:14:34.909 Luke Daque: We can add.
236 00:14:36.880 ⇒ 00:14:40.670 Nicolas Sucari: Okay, wait. This should go in the models and
237 00:14:41.800 ⇒ 00:14:46.139 Nicolas Sucari: no in the dashboard. Sorry, and they add it here in the models. So
238 00:14:47.520 ⇒ 00:14:48.990 Nicolas Sucari: should go here
239 00:14:49.140 ⇒ 00:14:49.870 Nicolas Sucari: right.
240 00:14:50.730 ⇒ 00:14:51.840 Nicolas Sucari: Yep, yep.
241 00:14:53.070 ⇒ 00:14:54.889 Nicolas Sucari: so I need to save this
242 00:14:57.090 ⇒ 00:14:59.010 Nicolas Sucari: Should I merge it directly.
243 00:14:59.480 ⇒ 00:15:02.879 Luke Daque: We, we have specific time. There. Is it America.
244 00:15:04.830 ⇒ 00:15:07.130 Nicolas Sucari: I think it’s America.
245 00:15:07.670 ⇒ 00:15:08.919 Nicolas Sucari: No, this one.
246 00:15:09.430 ⇒ 00:15:10.979 Luke Daque: Los Angeles. Okay.
247 00:15:11.960 ⇒ 00:15:14.500 Luke Daque: let’s let’s try local first.st
248 00:15:14.500 ⇒ 00:15:15.949 Nicolas Sucari: Yeah, let’s wait. Let’s.
249 00:15:15.950 ⇒ 00:15:16.330 Luke Daque: And so.
250 00:15:16.330 ⇒ 00:15:16.970 Nicolas Sucari: You feel.
251 00:15:16.970 ⇒ 00:15:17.669 Luke Daque: That’s just.
252 00:15:26.330 ⇒ 00:15:28.889 Nicolas Sucari: Let’s delete. Let’s have those ones.
253 00:15:30.180 ⇒ 00:15:31.190 Nicolas Sucari: I don’t know
254 00:15:31.620 ⇒ 00:15:36.100 Nicolas Sucari: what this is. Month, week to date, month to quarter to year. Today
255 00:15:37.040 ⇒ 00:15:38.310 Nicolas Sucari: previous.
256 00:15:38.940 ⇒ 00:15:40.320 Nicolas Sucari: We don’t use this.
257 00:15:40.510 ⇒ 00:15:42.530 Luke Daque: I don’t know if we need to. But
258 00:15:43.450 ⇒ 00:15:49.489 Luke Daque: yeah, I don’t. Let’s just remove it if we’re not using it. So we don’t add more complications.
259 00:15:50.470 ⇒ 00:15:51.620 Nicolas Sucari: Okay, let me.
260 00:15:54.940 ⇒ 00:15:57.389 Nicolas Sucari: One will start here
261 00:16:23.250 ⇒ 00:16:25.500 Nicolas Sucari: a hundred 17.9.
262 00:16:26.070 ⇒ 00:16:27.469 Luke Daque: Yeah, I think that’s correct.
263 00:16:28.850 ⇒ 00:16:31.310 Luke Daque: If you compare it to Meta base. Yep.
264 00:16:31.600 ⇒ 00:16:32.770 Nicolas Sucari: Yeah.
265 00:16:32.770 ⇒ 00:16:33.560 Luke Daque: Noise.
266 00:16:33.560 ⇒ 00:16:34.365 Nicolas Sucari: Cool.
267 00:16:35.640 ⇒ 00:16:36.829 Nicolas Sucari: This is amazing.
268 00:16:36.860 ⇒ 00:16:38.459 Nicolas Sucari: Create a new subs.
269 00:16:39.260 ⇒ 00:16:43.700 Luke Daque: Yeah, that’s incorrect, I think by us mentioned, he’s still gonna fix. He needs to fix.
270 00:16:43.700 ⇒ 00:16:44.440 Nicolas Sucari: Snap.
271 00:16:48.060 ⇒ 00:16:48.800 Nicolas Sucari: Great!
272 00:16:50.380 ⇒ 00:16:53.140 Nicolas Sucari: How do we? We don’t have that metric.
273 00:16:53.290 ⇒ 00:16:55.490 Luke Daque: We have the customer type dimension.
274 00:16:57.340 ⇒ 00:16:57.790 Nicolas Sucari: Oh, okay.
275 00:16:57.790 ⇒ 00:16:59.789 Luke Daque: So new and returning. Yep.
276 00:17:04.740 ⇒ 00:17:05.190 Nicolas Sucari: Okay.
277 00:17:05.190 ⇒ 00:17:06.329 Luke Daque: Return. Yeah.
278 00:17:09.619 ⇒ 00:17:13.799 Nicolas Sucari: Yeah, but it’s different. Right? Total return, total, new.
279 00:17:14.660 ⇒ 00:17:16.829 Luke Daque: Yeah, I I think everything there is
280 00:17:18.490 ⇒ 00:17:21.853 Luke Daque: still pay us needs to fix. Because I think he
281 00:17:22.500 ⇒ 00:17:24.989 Luke Daque: he mentioned like he was using a different
282 00:17:25.000 ⇒ 00:17:26.659 Luke Daque: date or something I don’t know.
283 00:17:27.819 ⇒ 00:17:31.599 Nicolas Sucari: Wait. So this is working. So maybe I can
284 00:17:32.149 ⇒ 00:17:34.969 Nicolas Sucari: create a pull request for this one right?
285 00:17:35.430 ⇒ 00:17:36.100 Luke Daque: Yes.
286 00:17:37.230 ⇒ 00:17:39.080 Luke Daque: but I don’t think
287 00:17:39.350 ⇒ 00:17:41.620 Luke Daque: it would have been great if real has
288 00:17:42.202 ⇒ 00:17:44.140 Luke Daque: a way to make it default.
289 00:17:44.840 ⇒ 00:17:49.439 Luke Daque: because currently it’s I think it’s defaulting to whatever local time zone you have.
290 00:17:51.410 ⇒ 00:17:53.039 Nicolas Sucari: Way to default it, you know.
291 00:17:53.040 ⇒ 00:17:57.519 Luke Daque: I did. I did check it last time. I don’t think there is at the moment, but
292 00:17:57.630 ⇒ 00:17:59.939 Luke Daque: I don’t know if there’s any updates yet.
293 00:18:14.830 ⇒ 00:18:17.260 Nicolas Sucari: No, it’s available. Time zones.
294 00:18:17.580 ⇒ 00:18:18.460 Luke Daque: Yeah.
295 00:18:19.450 ⇒ 00:18:21.269 Luke Daque: they don’t have default
296 00:18:21.430 ⇒ 00:18:22.500 Luke Daque: time zone.
297 00:18:23.180 ⇒ 00:18:23.860 Luke Daque: No.
298 00:18:25.490 ⇒ 00:18:26.070 Nicolas Sucari: Bye, bye.
299 00:18:27.050 ⇒ 00:18:30.622 Nicolas Sucari: so should I create a pull. Request this one.
300 00:18:31.020 ⇒ 00:18:31.570 Luke Daque: Yeah.
301 00:18:32.240 ⇒ 00:18:35.890 Nicolas Sucari: Should I create a branch, or should I go directly to mine? What do you think.
302 00:18:37.510 ⇒ 00:18:42.329 Luke Daque: Just create a branch to make just to make sure we’re not missing the main.
303 00:18:43.000 ⇒ 00:18:43.680 Nicolas Sucari: Okay.
304 00:18:55.400 ⇒ 00:18:56.569 Nicolas Sucari: there we go.
305 00:18:56.770 ⇒ 00:18:58.089 Nicolas Sucari: This is
306 00:18:59.110 ⇒ 00:18:59.830 Nicolas Sucari: wait.
307 00:19:18.810 ⇒ 00:19:19.880 Nicolas Sucari: Okay.
308 00:19:20.990 ⇒ 00:19:24.120 Nicolas Sucari: Oh, should I add these to the other ones, too?
309 00:19:25.410 ⇒ 00:19:27.620 Luke Daque: Oh, yeah, yeah, that’s a good
310 00:19:28.040 ⇒ 00:19:31.719 Luke Daque: good one. Let’s just add it to all the dashboards.
311 00:19:32.780 ⇒ 00:19:33.940 Nicolas Sucari: Go here.
312 00:19:33.980 ⇒ 00:19:35.440 Nicolas Sucari: let’s copy this
313 00:19:36.760 ⇒ 00:19:37.850 Nicolas Sucari: here.
314 00:19:40.320 ⇒ 00:19:43.190 Nicolas Sucari: add this here, the unique Kpi
315 00:19:45.730 ⇒ 00:19:47.139 Nicolas Sucari: here, right
316 00:19:47.880 ⇒ 00:19:49.280 Nicolas Sucari: should be there
317 00:19:52.830 ⇒ 00:19:54.080 Nicolas Sucari: and
318 00:19:59.250 ⇒ 00:20:00.810 Nicolas Sucari: click under this.
319 00:20:06.250 ⇒ 00:20:07.430 Nicolas Sucari: It’s fine, right?
320 00:20:08.010 ⇒ 00:20:10.679 Nicolas Sucari: Yep. So if I go to
321 00:20:10.800 ⇒ 00:20:11.890 Nicolas Sucari: here
322 00:20:15.620 ⇒ 00:20:16.840 Nicolas Sucari: Midtown
323 00:20:18.430 ⇒ 00:20:20.689 Nicolas Sucari: meeting time zones, I can commit
324 00:20:21.480 ⇒ 00:20:22.400 Nicolas Sucari: push.
325 00:20:24.180 ⇒ 00:20:24.615 Luke Daque: Mute.
326 00:20:26.720 ⇒ 00:20:27.470 Luke Daque: cool.
327 00:20:27.470 ⇒ 00:20:28.469 Nicolas Sucari: That’s it, right?
328 00:20:28.760 ⇒ 00:20:29.075 Luke Daque: Yep.
329 00:20:29.540 ⇒ 00:20:30.700 Luke Daque: Nice
330 00:20:40.880 ⇒ 00:20:42.080 Luke Daque: nice merge.
331 00:20:42.080 ⇒ 00:20:42.740 Nicolas Sucari: Yeah.
332 00:20:43.470 ⇒ 00:20:44.853 Luke Daque: And we should be good.
333 00:20:48.210 ⇒ 00:20:50.140 Nicolas Sucari: Wait. And now
334 00:20:51.100 ⇒ 00:20:52.929 Nicolas Sucari: I need to go
335 00:20:53.850 ⇒ 00:20:58.820 Nicolas Sucari: here. No, I need to go to the local host one and update right.
336 00:21:02.110 ⇒ 00:21:03.300 Luke Daque: Yeah.
337 00:21:14.280 ⇒ 00:21:15.460 Nicolas Sucari: this is correct.
338 00:21:18.000 ⇒ 00:21:18.909 Nicolas Sucari: Let me see.
339 00:21:23.710 ⇒ 00:21:24.230 Nicolas Sucari: Yep.
340 00:21:24.909 ⇒ 00:21:25.589 Luke Daque: Nice.
341 00:21:29.690 ⇒ 00:21:30.290 Nicolas Sucari: Okay.
342 00:21:30.390 ⇒ 00:21:31.060 Nicolas Sucari: okay.
343 00:21:31.990 ⇒ 00:21:33.040 Nicolas Sucari: excellent.
344 00:21:33.880 ⇒ 00:21:34.940 Luke Daque: Perfect.
345 00:21:35.730 ⇒ 00:21:38.189 Nicolas Sucari: Thanks, Ryan. Sorry for that.
346 00:21:38.230 ⇒ 00:21:39.310 Nicolas Sucari: Needed to
347 00:21:39.630 ⇒ 00:21:42.529 Nicolas Sucari: validate. We were doing the correct stuff here.
348 00:21:42.640 ⇒ 00:21:43.360 Nicolas Sucari: Okay.
349 00:21:46.020 ⇒ 00:21:46.730 Nicolas Sucari: cool.
350 00:21:48.570 ⇒ 00:21:52.399 Nicolas Sucari: okay. Let’s keep trying to figure out, what else do we need?
351 00:21:55.130 ⇒ 00:21:58.223 Luke Daque: I’ll yeah for me. I think I’ll continue
352 00:21:58.790 ⇒ 00:22:02.889 Luke Daque: working on figuring out the refunds, or like returns.
353 00:22:05.590 ⇒ 00:22:06.230 Nicolas Sucari: Okay.
354 00:22:06.790 ⇒ 00:22:07.800 Nicolas Sucari: makes sense.
355 00:22:10.090 ⇒ 00:22:12.289 Nicolas Sucari: Thank you. I’m gonna
356 00:22:12.380 ⇒ 00:22:18.929 Nicolas Sucari: continue with what’s going on here trying to read. And I’ll let I let know. I will
357 00:22:19.360 ⇒ 00:22:25.870 Nicolas Sucari: send a note to pay us, telling that we are already getting his shopify table from props. Okay.
358 00:22:26.190 ⇒ 00:22:26.780 Nicolas Sucari: yep.
359 00:22:26.780 ⇒ 00:22:27.500 Luke Daque: Cool.
360 00:22:28.030 ⇒ 00:22:28.415 Luke Daque: cool.
361 00:22:28.800 ⇒ 00:22:29.470 Nicolas Sucari: Thanks.
362 00:22:29.620 ⇒ 00:22:30.330 Nicolas Sucari: bye.
363 00:22:31.290 ⇒ 00:22:32.289 Luke Daque: Thanks, bye, bye.