Meeting Title: Zoom Meeting Date: 2024-11-01 Meeting participants: Luke Daque, Nicolas Sucari
WEBVTT
1 00:00:44.690 ⇒ 00:00:45.979 Luke Daque: Hi, Nicholas!
2 00:00:49.120 ⇒ 00:00:49.739 Luke Daque: Hello.
3 00:00:50.610 ⇒ 00:00:52.379 Nicolas Sucari: Hey, Ryan, how are you?
4 00:00:52.970 ⇒ 00:00:55.120 Luke Daque: Yeah. Doing. Well, how are you?
5 00:00:56.440 ⇒ 00:00:57.440 Nicolas Sucari: I’m fine.
6 00:00:59.960 ⇒ 00:01:03.830 Luke Daque: It’s weird. I actually thought it was Saturday today. But
7 00:01:04.030 ⇒ 00:01:05.103 Luke Daque: still Friday.
8 00:01:06.850 ⇒ 00:01:13.170 Luke Daque: because it’s it’s it’s a holiday here in the Philippines. So like everybody else, is like already in a
9 00:01:13.360 ⇒ 00:01:13.860 Luke Daque: week.
10 00:01:13.860 ⇒ 00:01:14.490 Nicolas Sucari: Oh!
11 00:01:14.490 ⇒ 00:01:16.480 Luke Daque: Stuff. Yeah, do it?
12 00:01:16.480 ⇒ 00:01:21.139 Nicolas Sucari: I didn’t know you. You need to tell me that. I mean we can
13 00:01:21.420 ⇒ 00:01:23.150 Nicolas Sucari: you? You can take the day off.
14 00:01:23.750 ⇒ 00:01:28.587 Luke Daque: I mean, it’s fine. It’s still already, like night time here. So there’s nothing, really, nothing
15 00:01:29.590 ⇒ 00:01:31.579 Luke Daque: to be okay. Yeah. So.
16 00:01:32.950 ⇒ 00:01:33.560 Luke Daque: but
17 00:01:35.370 ⇒ 00:01:36.809 Luke Daque: how’s everything on your end?
18 00:01:38.110 ⇒ 00:01:39.970 Nicolas Sucari: Everything’s going fine.
19 00:01:40.980 ⇒ 00:01:44.730 Nicolas Sucari: yeah, I’m traveling today. I’m going to to the Us.
20 00:01:45.693 ⇒ 00:01:48.960 Nicolas Sucari: I’m probably meeting Utam. Yeah.
21 00:01:48.960 ⇒ 00:01:50.557 Luke Daque: Nice, that’s cool.
22 00:01:51.550 ⇒ 00:01:55.159 Luke Daque: Is it like, are you going for vacation, or something, or like what.
23 00:01:55.830 ⇒ 00:02:01.649 Nicolas Sucari: Yeah, I’m going for a vacation. I’m I’m gonna be working next week. But from from there, from Florida. And
24 00:02:01.930 ⇒ 00:02:07.679 Nicolas Sucari: and the week after that one I’m gonna be. I’m gonna be off. Yeah, I’m gonna I’m going to New York.
25 00:02:08.009 ⇒ 00:02:08.449 Luke Daque: Oh, cool!
26 00:02:08.964 ⇒ 00:02:12.979 Nicolas Sucari: But yeah, I’m probably meeting with Samsung. We’ll send a picture.
27 00:02:13.180 ⇒ 00:02:18.870 Luke Daque: Yeah, that would be great. I might be going to the Us next year, cause I was like.
28 00:02:18.870 ⇒ 00:02:19.640 Nicolas Sucari: Like it landed.
29 00:02:19.640 ⇒ 00:02:25.276 Luke Daque: To around August next year, because I was invited to a wedding.
30 00:02:25.710 ⇒ 00:02:26.270 Nicolas Sucari: Oh!
31 00:02:26.270 ⇒ 00:02:33.809 Luke Daque: My my cousin’s wedding. We were actually close when we were kids, but they transferred to us so.
32 00:02:33.810 ⇒ 00:02:35.390 Nicolas Sucari: Yeah, they moved there. Yeah.
33 00:02:35.390 ⇒ 00:02:36.760 Luke Daque: Moved there already. So
34 00:02:37.150 ⇒ 00:02:40.280 Luke Daque: but yeah, so it depends. I might
35 00:02:40.620 ⇒ 00:02:46.285 Luke Daque: be going, but it depends on, because I still have to. Well, the whole family is going. So
36 00:02:47.030 ⇒ 00:02:47.550 Nicolas Sucari: Oh, yeah.
37 00:02:47.550 ⇒ 00:02:50.389 Luke Daque: Visa. But the kids I’ll have to like
38 00:02:50.520 ⇒ 00:02:54.359 Luke Daque: get their us visas or something like that. So yeah, if that.
39 00:02:54.360 ⇒ 00:02:56.560 Nicolas Sucari: If it’s easy to get the visas.
40 00:02:57.820 ⇒ 00:02:59.519 Nicolas Sucari: is it easy for you? Yeah.
41 00:02:59.920 ⇒ 00:03:03.729 Luke Daque: Not I, will you? You have to apply for it, and you get
42 00:03:04.110 ⇒ 00:03:08.110 Luke Daque: reviewed and stuff like that. But I think it should be pretty fine.
43 00:03:08.110 ⇒ 00:03:09.720 Nicolas Sucari: Should be pretty. Yeah, okay.
44 00:03:09.720 ⇒ 00:03:10.230 Luke Daque: Yeah.
45 00:03:10.230 ⇒ 00:03:11.340 Nicolas Sucari: Yeah, thanks for us.
46 00:03:11.640 ⇒ 00:03:22.359 Nicolas Sucari: Yeah, I got my visa. So everything’s going fine. But yeah, if you need like the visa now, like for the 1st time. Like to renew. The visa is kind of easy from here now, but if you get try to get like a new one.
47 00:03:22.900 ⇒ 00:03:23.319 Luke Daque: It’s kind of.
48 00:03:23.320 ⇒ 00:03:24.440 Nicolas Sucari: Difficult. Yeah.
49 00:03:24.440 ⇒ 00:03:26.160 Luke Daque: Yeah, yeah.
50 00:03:27.160 ⇒ 00:03:28.799 Nicolas Sucari: And that’s fine. Cool.
51 00:03:29.240 ⇒ 00:03:30.590 Nicolas Sucari: Yeah, okay.
52 00:03:30.990 ⇒ 00:03:31.390 Luke Daque: Yeah.
53 00:03:31.390 ⇒ 00:03:38.110 Nicolas Sucari: Maybe when you go there next year, let me know, and I don’t know. We can tell Utam, and maybe do like a
54 00:03:38.660 ⇒ 00:03:39.790 Nicolas Sucari: I don’t know.
55 00:03:41.020 ⇒ 00:03:46.661 Nicolas Sucari: Yeah, although everyone on the team, we can invite us, everyone on the team to the Us. Maybe I don’t know.
56 00:03:46.930 ⇒ 00:03:49.729 Luke Daque: Nice. Yeah, that might. That would be great.
57 00:03:50.080 ⇒ 00:03:53.680 Nicolas Sucari: That would be great. Yeah, we can do like a work retreat there somewhere.
58 00:03:54.350 ⇒ 00:03:55.020 Luke Daque: Yeah.
59 00:03:55.020 ⇒ 00:03:57.470 Nicolas Sucari: Just drink beer and not work.
60 00:03:58.310 ⇒ 00:03:58.785 Luke Daque: Right.
61 00:04:00.770 ⇒ 00:04:01.790 Nicolas Sucari: Okay.
62 00:04:02.040 ⇒ 00:04:03.033 Nicolas Sucari: Cool. Yeah.
63 00:04:03.530 ⇒ 00:04:04.220 Luke Daque: Cool.
64 00:04:04.710 ⇒ 00:04:07.130 Nicolas Sucari: Okay, let’s go into Javi.
65 00:04:07.130 ⇒ 00:04:14.390 Luke Daque: Sure. I’ve I I don’t know if you’ve seen the updates I did yesterday, but like late
66 00:04:14.530 ⇒ 00:04:21.210 Luke Daque: at like morning here, like night time in us, but I did push a Pr for 2
67 00:04:22.000 ⇒ 00:04:23.030 Luke Daque: real
68 00:04:23.717 ⇒ 00:04:27.119 Luke Daque: and dashboard. So let me share my screen
69 00:04:27.500 ⇒ 00:04:33.019 Luke Daque: that those are already like the results of the models already included as well.
70 00:04:33.340 ⇒ 00:04:38.670 Luke Daque: And I also just created the basic real dashboards for those models.
71 00:04:39.140 ⇒ 00:04:41.190 Luke Daque: Can you see my screen, by the way.
72 00:04:41.760 ⇒ 00:04:42.520 Nicolas Sucari: Yes.
73 00:04:43.440 ⇒ 00:04:44.326 Luke Daque: Yeah, so
74 00:04:45.430 ⇒ 00:04:47.060 Luke Daque: yeah, just a quick.
75 00:04:49.190 ⇒ 00:04:54.610 Nicolas Sucari: Just. And just to understand, did you create, like new tables or pro tables?
76 00:04:54.610 ⇒ 00:04:57.950 Luke Daque: Yeah, I can show you. So I created
77 00:04:59.160 ⇒ 00:05:04.699 Luke Daque: these 2, these intermediate models for Oquendo and Georgia’s in Dbt.
78 00:05:04.700 ⇒ 00:05:05.370 Nicolas Sucari: Thanks.
79 00:05:05.858 ⇒ 00:05:07.810 Luke Daque: And then I created
80 00:05:07.980 ⇒ 00:05:10.920 Luke Daque: fact tables, 3 of them like fact messages.
81 00:05:10.990 ⇒ 00:05:13.339 Luke Daque: reviews and tickets.
82 00:05:14.100 ⇒ 00:05:21.200 Luke Daque: And I basically just made these as sources for real. So we have tickets, reviews, and messages.
83 00:05:21.650 ⇒ 00:05:23.790 Nicolas Sucari: Yeah. Coming from March. Okay. Excellent.
84 00:05:23.790 ⇒ 00:05:24.300 Luke Daque: Yeah.
85 00:05:24.860 ⇒ 00:05:31.229 Luke Daque: and then created dashboards out of that like tickets. Dashboard, for example, would be this one.
86 00:05:31.580 ⇒ 00:05:37.249 Nicolas Sucari: Yeah, okay, just directly from those all models. So it’s coming. Everything is coming from that table. Perfect.
87 00:05:37.250 ⇒ 00:05:43.480 Luke Daque: Yeah, but we’ll have to, of course, discuss with maybe pay us, or whoever is like the stakeholder for this one
88 00:05:43.550 ⇒ 00:05:47.599 Luke Daque: to see like what else they want to see here. Or if there’s like
89 00:05:48.360 ⇒ 00:05:55.263 Luke Daque: measures that they don’t need, or we, we can add and stuff like that. So I just added basic ones, like total number of tickets.
90 00:05:55.590 ⇒ 00:05:58.410 Luke Daque: Average time to resolution.
91 00:05:59.284 ⇒ 00:06:04.740 Luke Daque: Average response time. A number of reopened tickets closed, tickets open and
92 00:06:04.840 ⇒ 00:06:08.240 Luke Daque: pending if there are any, but so far it looks like there’s none.
93 00:06:09.080 ⇒ 00:06:09.800 Nicolas Sucari: Okay.
94 00:06:09.800 ⇒ 00:06:14.300 Luke Daque: We can. Also, I included ticket Id, because that’s usually the what
95 00:06:14.580 ⇒ 00:06:19.550 Luke Daque: is used to look for tickets. But we can also add ticket name, perhaps. But
96 00:06:19.710 ⇒ 00:06:20.529 Luke Daque: yeah, it depends.
97 00:06:20.530 ⇒ 00:06:21.210 Nicolas Sucari: See how the name.
98 00:06:21.210 ⇒ 00:06:25.490 Luke Daque: Mentioned. I think so. I if I can recall
99 00:06:26.765 ⇒ 00:06:27.510 Luke Daque: So
100 00:06:29.030 ⇒ 00:06:30.930 Luke Daque: yeah, I think there was a name.
101 00:06:31.680 ⇒ 00:06:34.449 Luke Daque: But yeah, we can. We can add stuff like that
102 00:06:35.147 ⇒ 00:06:46.270 Luke Daque: customer name. There’s like a lot of nulls, though, so I’m not sure like why, these are nulls. It looks like there are tickets, with no customers related to them. It appears.
103 00:06:46.930 ⇒ 00:06:47.330 Nicolas Sucari: Okay.
104 00:06:48.676 ⇒ 00:06:59.369 Nicolas Sucari: But wait I I let me check so this dashboard that is the one for tickets. This is coming from gorgeous or kendo.
105 00:07:00.390 ⇒ 00:07:02.659 Luke Daque: Tickets is from.
106 00:07:04.310 ⇒ 00:07:05.970 Nicolas Sucari: Broadside ticket model.
107 00:07:06.220 ⇒ 00:07:06.730 Nicolas Sucari: Of course.
108 00:07:06.730 ⇒ 00:07:07.340 Luke Daque: Yes.
109 00:07:08.410 ⇒ 00:07:09.080 Nicolas Sucari: Okay.
110 00:07:10.188 ⇒ 00:07:12.279 Luke Daque: Only for for messages and.
111 00:07:12.280 ⇒ 00:07:12.990 Nicolas Sucari: Reviews.
112 00:07:12.990 ⇒ 00:07:15.580 Luke Daque: Gorgeous and reviews, is from Okendo.
113 00:07:16.250 ⇒ 00:07:21.739 Nicolas Sucari: Okay, excellent. Okay, so we are not. We are like, we’re not like matching any of those.
114 00:07:21.740 ⇒ 00:07:25.410 Luke Daque: I? Yeah, I didn’t match anything yet. That’s what I was
115 00:07:25.740 ⇒ 00:07:26.550 Luke Daque: like.
116 00:07:27.660 ⇒ 00:07:32.550 Luke Daque: try. That’s what I can like. Try to do to see if there’s any way I can match with
117 00:07:32.610 ⇒ 00:07:36.910 Luke Daque: both the tickets and reviews or the orders if it’s possible.
118 00:07:36.970 ⇒ 00:07:39.620 Luke Daque: like maybe through customer name, but like
119 00:07:40.310 ⇒ 00:07:40.800 Luke Daque: the the
120 00:07:41.970 ⇒ 00:07:43.049 Luke Daque: again. Yeah.
121 00:07:43.050 ⇒ 00:07:49.380 Nicolas Sucari: We can ask. We can ask them, what they need, and then try to see. Yeah, exactly.
122 00:07:49.380 ⇒ 00:07:51.999 Luke Daque: Yeah, cool. Yeah, we don’t have to like.
123 00:07:52.870 ⇒ 00:07:55.529 Nicolas Sucari: Perfect. So we have ticket orders and messages.
124 00:07:55.530 ⇒ 00:07:58.070 Luke Daque: We have tickets, we have messages.
125 00:07:58.610 ⇒ 00:08:00.859 Luke Daque: This is also from gorgeous
126 00:08:01.530 ⇒ 00:08:11.059 Luke Daque: if we do all time, for example, just basic measures as well, total messages, total agent and customer messages. But so far
127 00:08:12.325 ⇒ 00:08:20.709 Luke Daque: we don’t have tables for Co. For customer messages, but it’s supposed to be available in 5 Tran
128 00:08:21.456 ⇒ 00:08:24.720 Luke Daque: as long as we get it from
129 00:08:25.270 ⇒ 00:08:27.949 Luke Daque: from from 5 tran. But so far
130 00:08:27.990 ⇒ 00:08:30.280 Luke Daque: the tables we have are just customer
131 00:08:30.600 ⇒ 00:08:33.746 Luke Daque: and messages there. There should have been like,
132 00:08:34.480 ⇒ 00:08:40.089 Luke Daque: oh, yeah, yeah, I’ll have to look into this like, why, this is serial, because I’m like joining customer tomorrow.
133 00:08:40.090 ⇒ 00:08:41.309 Nicolas Sucari: Customer Message.
134 00:08:41.440 ⇒ 00:08:44.790 Luke Daque: Cause I think there’s a customer id here somewhere.
135 00:08:45.500 ⇒ 00:08:48.330 Luke Daque: or something like that. Or maybe it’s the ticket.
136 00:08:49.580 ⇒ 00:08:51.899 Luke Daque: But yeah, we can look into this?
137 00:08:53.574 ⇒ 00:08:58.480 Luke Daque: Yeah. A message. Id, this can also be name. We can change this to name
138 00:08:58.930 ⇒ 00:09:03.769 Luke Daque: ticket Id, which is similar to the other one. Just customers as well.
139 00:09:04.190 ⇒ 00:09:05.750 Luke Daque: Yeah, I just added.
140 00:09:05.790 ⇒ 00:09:08.450 Luke Daque: like, random, like basic stuff.
141 00:09:08.660 ⇒ 00:09:11.959 Luke Daque: But yeah, we can ask them, like what they need from
142 00:09:12.020 ⇒ 00:09:13.420 Luke Daque: these 2.
143 00:09:13.980 ⇒ 00:09:18.500 Nicolas Sucari: You already deployed all of these. You already deployed all of these dashboards right.
144 00:09:18.500 ⇒ 00:09:24.300 Luke Daque: Yes, this is already deployed. So we can also see reviews, for instance, which is from Okinda
145 00:09:24.990 ⇒ 00:09:27.309 Luke Daque: and total reviews rating.
146 00:09:28.280 ⇒ 00:09:33.089 Luke Daque: Yeah, this one, I don’t know. Maybe we can remove these because it’s not showing anything.
147 00:09:35.670 ⇒ 00:09:36.060 Nicolas Sucari: Okay.
148 00:09:38.100 ⇒ 00:09:39.490 Nicolas Sucari: okay, excellent.
149 00:09:40.230 ⇒ 00:09:43.079 Nicolas Sucari: Okay, I think that’s fine.
150 00:09:44.770 ⇒ 00:09:50.980 Nicolas Sucari: we yeah, we will need to share this with pay us, I think. And and the man and see how
151 00:09:51.626 ⇒ 00:09:59.929 Nicolas Sucari: yeah, what they need or what we can like do on top of each of the tables, so that we can start like matching the information with other tables right?
152 00:10:00.340 ⇒ 00:10:01.810 Luke Daque: Yeah, makes sense.
153 00:10:02.330 ⇒ 00:10:02.960 Nicolas Sucari: Okay?
154 00:10:03.480 ⇒ 00:10:19.420 Nicolas Sucari: Excellent. Yeah. I think this is great. I’m gonna I’m gonna send a message to everyone in the Channel, all the internal one, so that pay us and Robert can start taking a look, and if they want we can meet. And next week, probably Monday, Tuesday
155 00:10:19.913 ⇒ 00:10:27.279 Nicolas Sucari: or in the Monday internal meeting that we have. We can review this and see what they want to share with the man. On Tuesday, right.
156 00:10:27.690 ⇒ 00:10:28.400 Luke Daque: Okay.
157 00:10:28.810 ⇒ 00:10:29.940 Luke Daque: sounds cool.
158 00:10:30.250 ⇒ 00:10:32.949 Nicolas Sucari: In the meantime. I think we can
159 00:10:33.100 ⇒ 00:10:35.080 Nicolas Sucari: keep working on the.
160 00:10:35.400 ⇒ 00:10:36.500 Luke Daque: Refunds.
161 00:10:36.620 ⇒ 00:10:41.329 Luke Daque: Yeah, I did start working on that. So I, this is like the login
162 00:10:41.808 ⇒ 00:10:50.139 Luke Daque: for Javi coffee to shopify. I’m trying to look for refunds here. I can’t really find anything. I even like customize this.
163 00:10:50.290 ⇒ 00:10:52.050 Luke Daque: and there’s no
164 00:10:52.690 ⇒ 00:10:55.780 Luke Daque: refund related stuff.
165 00:10:55.970 ⇒ 00:10:57.990 Luke Daque: But there is, returns.
166 00:10:58.410 ⇒ 00:11:00.430 Luke Daque: The only problem is there?
167 00:11:01.407 ⇒ 00:11:06.549 Luke Daque: Returns is actually different, I believe, from returns from refunds.
168 00:11:07.860 ⇒ 00:11:08.340 Nicolas Sucari: Yeah.
169 00:11:08.340 ⇒ 00:11:11.129 Luke Daque: I say, yeah, it’s a bit. It’s it’s different.
170 00:11:11.640 ⇒ 00:11:12.685 Luke Daque: And
171 00:11:13.810 ⇒ 00:11:18.649 Luke Daque: But yeah, I did try to check here in like, just the shopify analytics
172 00:11:18.900 ⇒ 00:11:25.557 Luke Daque: like total orders. For example, 128,000. We are already matching that. So if we look at the
173 00:11:26.410 ⇒ 00:11:27.710 Luke Daque: all orders.
174 00:11:29.090 ⇒ 00:11:31.080 Luke Daque: where was that one over here
175 00:11:31.290 ⇒ 00:11:35.029 Luke Daque: and Pdt. For that was September, I believe.
176 00:11:35.490 ⇒ 00:11:37.040 Luke Daque: Yeah. September.
177 00:11:38.860 ⇒ 00:11:43.119 Nicolas Sucari: Okay? Oh, no, we are, I think. Oh, yeah, that’s fine.
178 00:11:44.740 ⇒ 00:11:45.500 Nicolas Sucari: Hmm.
179 00:11:46.990 ⇒ 00:11:53.330 Luke Daque: 128. But this is just shopify. So yeah, 1, 2, 8, 1, 3, 2
180 00:11:53.670 ⇒ 00:11:58.970 Luke Daque: versus 1, 2, 8, 1, 3, 2. So we should be good in terms of orders related.
181 00:12:00.037 ⇒ 00:12:07.390 Luke Daque: Revenue sales. It looks like here. Sales is computed this way, so it is gross minus discount
182 00:12:07.550 ⇒ 00:12:14.047 Luke Daque: minus returns and stuff like that. We, I don’t think we currently have that. Maybe we can create.
183 00:12:14.510 ⇒ 00:12:19.089 Luke Daque: I can create the yeah, this metric. So we can compare
184 00:12:19.400 ⇒ 00:12:25.479 Luke Daque: this number because we only have revenue at the moment. Where’s the revenue here.
185 00:12:25.910 ⇒ 00:12:27.509 Luke Daque: somewhere here, revenue?
186 00:12:27.730 ⇒ 00:12:30.869 Luke Daque: So it would. This would be the gross sales, and then minus.
187 00:12:30.870 ⇒ 00:12:31.360 Nicolas Sucari: Yeah.
188 00:12:31.360 ⇒ 00:12:36.019 Luke Daque: Funds. Which is this minus discounts this one.
189 00:12:36.840 ⇒ 00:12:41.539 Luke Daque: And what else was that? Yeah, we can. We can. I can add all of these like shipping.
190 00:12:41.540 ⇒ 00:12:42.500 Nicolas Sucari: Turn, shipping.
191 00:12:42.500 ⇒ 00:12:44.340 Luke Daque: Yeah, shipping, total shipping.
192 00:12:44.930 ⇒ 00:12:53.109 Nicolas Sucari: I think we can do that. I mean, we have all of the metrics separately. I think we can do that directly on the dashboard file right the yamo file.
193 00:12:53.110 ⇒ 00:12:57.809 Luke Daque: Yeah, yeah, we can do that as long as we all the sub metrics are there like tab.
194 00:12:57.810 ⇒ 00:12:58.369 Nicolas Sucari: Yeah, yeah.
195 00:12:58.370 ⇒ 00:13:01.860 Luke Daque: Decent fees. So I don’t, you know, like we have tax.
196 00:13:02.280 ⇒ 00:13:07.769 Luke Daque: there’s no duties and fees here, but maybe we can probably add that if it’s missing.
197 00:13:08.480 ⇒ 00:13:09.413 Luke Daque: But yeah,
198 00:13:10.100 ⇒ 00:13:12.870 Luke Daque: but yeah, the the the refunds thing is
199 00:13:13.170 ⇒ 00:13:17.929 Luke Daque: something I cannot find in shopify at the moment. So yeah, we can.
200 00:13:19.550 ⇒ 00:13:20.020 Nicolas Sucari: Really kind.
201 00:13:20.020 ⇒ 00:13:28.349 Luke Daque: This matches like, if we create a measure that’s total sales and it’s already matching, then we can definitely conclude that.
202 00:13:28.960 ⇒ 00:13:29.889 Luke Daque: oh, wait! This is.
203 00:13:29.890 ⇒ 00:13:30.470 Nicolas Sucari: Yeah, yeah.
204 00:13:30.470 ⇒ 00:13:31.919 Luke Daque: Not refunds.
205 00:13:32.860 ⇒ 00:13:35.399 Luke Daque: Yeah, this might be different, though.
206 00:13:36.230 ⇒ 00:13:38.800 Nicolas Sucari: Yeah, I don’t know where they are getting the refunds from.
207 00:13:39.240 ⇒ 00:13:40.040 Luke Daque: Yeah.
208 00:13:40.600 ⇒ 00:13:42.140 Nicolas Sucari: But yeah, maybe we can ask.
209 00:13:42.480 ⇒ 00:13:42.980 Luke Daque: Yeah, that’s.
210 00:13:42.980 ⇒ 00:13:44.310 Nicolas Sucari: I asked, and see
211 00:13:44.970 ⇒ 00:13:52.180 Nicolas Sucari: like to show us what, how, how he’s building that metric, or where he’s getting that metric from. Shopify and see where we can get that. Okay.
212 00:13:52.180 ⇒ 00:13:52.940 Luke Daque: Yeah.
213 00:13:53.310 ⇒ 00:13:54.510 Luke Daque: okay, cool.
214 00:13:54.810 ⇒ 00:13:59.509 Luke Daque: I guess I don’t think we also have returns anywhere for shopify.
215 00:14:01.920 ⇒ 00:14:03.510 Nicolas Sucari: I think we have.
216 00:14:05.710 ⇒ 00:14:06.730 Nicolas Sucari: You don’t have.
217 00:14:06.730 ⇒ 00:14:07.369 Luke Daque: That’s fine
218 00:14:07.660 ⇒ 00:14:12.279 Luke Daque: unless it’s a field in orders, right? Like, if there’s a return.
219 00:14:13.130 ⇒ 00:14:14.950 Luke Daque: Yeah, it doesn’t look like.
220 00:14:17.280 ⇒ 00:14:22.799 Nicolas Sucari: We we have there in order, line in shopify. There is a table that’s called order, line refund.
221 00:14:23.330 ⇒ 00:14:25.180 Luke Daque: Order, line refund.
222 00:14:25.590 ⇒ 00:14:28.319 Nicolas Sucari: If you go raw shopify. Yeah, that one.
223 00:14:30.340 ⇒ 00:14:30.770 Luke Daque: But this.
224 00:14:30.770 ⇒ 00:14:35.190 Nicolas Sucari: And you have a refund. Id. Yeah, that’s refund you’re talking about returns
225 00:14:36.150 ⇒ 00:14:37.690 Luke Daque: Yeah, returns.
226 00:14:38.220 ⇒ 00:14:40.909 Luke Daque: maybe it has like, refund type.
227 00:14:42.390 ⇒ 00:14:43.260 Luke Daque: Yeah.
228 00:14:43.260 ⇒ 00:14:43.600 Nicolas Sucari: Right.
229 00:14:43.600 ⇒ 00:14:44.150 Luke Daque: Tonight.
230 00:14:45.350 ⇒ 00:14:47.689 Luke Daque: Yeah, I think the returns is different.
231 00:14:47.980 ⇒ 00:14:52.540 Luke Daque: because it look because the returns is also calculated differently.
232 00:14:55.830 ⇒ 00:15:01.719 Nicolas Sucari: We have a refund table, also refunds. Okay, we. We need to match refunds on the order line refund, maybe
233 00:15:01.920 ⇒ 00:15:04.840 Nicolas Sucari: returns. I think it’s in orders.
234 00:15:05.680 ⇒ 00:15:06.130 Luke Daque: Yeah.
235 00:15:06.130 ⇒ 00:15:06.660 Nicolas Sucari: Lying.
236 00:15:07.136 ⇒ 00:15:11.900 Luke Daque: Order returns. I don’t think there is. I checked
237 00:15:12.530 ⇒ 00:15:14.060 Luke Daque: return additional.
238 00:15:14.090 ⇒ 00:15:15.290 Luke Daque: returned
239 00:15:15.710 ⇒ 00:15:17.020 Luke Daque: Field. Here.
240 00:15:18.630 ⇒ 00:15:19.965 Luke Daque: Yeah, but I think
241 00:15:20.470 ⇒ 00:15:25.200 Luke Daque: pay us is more concerned on the refunds as opposed to returns right? Or
242 00:15:25.430 ⇒ 00:15:27.749 Luke Daque: is it the other way around? Is it more?
243 00:15:28.240 ⇒ 00:15:29.170 Luke Daque: Does she want to know.
244 00:15:29.170 ⇒ 00:15:29.690 Nicolas Sucari: Yeah.
245 00:15:29.690 ⇒ 00:15:33.469 Luke Daque: Return numbers we can, we can verify that with him, with him as well.
246 00:15:33.470 ⇒ 00:15:38.409 Nicolas Sucari: Yeah, I think it’s more. I think it’s more in the refunds. But yeah, I think we need to check with him again.
247 00:15:38.850 ⇒ 00:15:39.596 Luke Daque: Yeah. Okay?
248 00:15:40.460 ⇒ 00:15:46.599 Luke Daque: Cause I was thinking, maybe he’s looking at the returns number and comparing it to the refunds number.
249 00:15:46.790 ⇒ 00:15:47.420 Luke Daque: which might.
250 00:15:47.420 ⇒ 00:15:47.960 Nicolas Sucari: Yeah.
251 00:15:47.960 ⇒ 00:15:50.469 Luke Daque: Be like one of the reasons why.
252 00:15:51.400 ⇒ 00:15:55.050 Nicolas Sucari: Okay, now let’s check that again and see what we can do. Okay.
253 00:15:55.440 ⇒ 00:15:57.169 Luke Daque: Okay. Sounds good.
254 00:15:58.019 ⇒ 00:16:06.749 Nicolas Sucari: And apart from all of these I think we were you able to create that integration between Google Sheets and Bytran, so that we.
255 00:16:07.960 ⇒ 00:16:13.769 Luke Daque: Oh, yeah, I forgot about that. I can. I can like add that now. Cause. But I don’t think the
256 00:16:14.020 ⇒ 00:16:17.039 Luke Daque: we have anything yet from the Google drive right?
257 00:16:17.040 ⇒ 00:16:18.650 Nicolas Sucari: No, yeah, I should.
258 00:16:19.860 ⇒ 00:16:20.490 Luke Daque: Yeah.
259 00:16:20.490 ⇒ 00:16:21.140 Nicolas Sucari: There we go.
260 00:16:21.910 ⇒ 00:16:27.550 Nicolas Sucari: But do you want to create like a template, to see or or not? Yet like? It’s not worth it yet.
261 00:16:28.400 ⇒ 00:16:40.824 Luke Daque: I think it’s not worth it, because we’ll have to change it again once we get the actual template with the actual fields. So it’s like we’re just gonna do double work double like, do it again.
262 00:16:41.160 ⇒ 00:16:41.589 Nicolas Sucari: Okay.
263 00:16:42.730 ⇒ 00:16:44.090 Nicolas Sucari: cool. That’s fine.
264 00:16:44.350 ⇒ 00:16:50.589 Luke Daque: But it should be working well, because we already did that for pool parts we were able to like create
265 00:16:51.740 ⇒ 00:16:52.510 Luke Daque: great
266 00:16:53.540 ⇒ 00:16:56.269 Luke Daque: right for the unit shipments. I believe.
267 00:16:58.160 ⇒ 00:17:00.930 Luke Daque: So. Yeah, it should be good. It should be fine.
268 00:17:01.990 ⇒ 00:17:10.290 Nicolas Sucari: Okay, yeah. Okay, so I’m gonna send those 3 things to pay us. And Robert that, we have all of the gorgeous and Okando
269 00:17:10.530 ⇒ 00:17:16.229 Nicolas Sucari: tables there, and they can take a look in real for messaging tickets. And
270 00:17:16.910 ⇒ 00:17:24.709 Nicolas Sucari: the other table, too. I’m gonna send that we’re gonna keep working on the
271 00:17:25.182 ⇒ 00:17:30.537 Nicolas Sucari: refunds. And just ask if we need to focus on refunds or returns. Okay?
272 00:17:31.580 ⇒ 00:17:40.939 Nicolas Sucari: And that, we are still missing the yeah, they are still they, they need. They need to send us the Google sheet file so that we can create that integration. Okay.
273 00:17:41.450 ⇒ 00:17:42.545 Luke Daque: Yeah. Sounds good.
274 00:17:42.910 ⇒ 00:17:44.130 Nicolas Sucari: I think those are.
275 00:17:44.870 ⇒ 00:17:45.500 Luke Daque: Chat? Who comes.
276 00:17:45.500 ⇒ 00:18:02.499 Nicolas Sucari: That’s all of the things that we have. Then, if we have some time like, if you’re not, if they don’t send anything, and we are done working with the other stuff. I think we can start adding, like the product categories to the order and all order line tables and creating a shipment table, or something like that in real right.
277 00:18:03.780 ⇒ 00:18:04.790 Luke Daque: Right
278 00:18:05.379 ⇒ 00:18:09.089 Luke Daque: from shop, from all orders, right? And all order items, I believe.
279 00:18:10.460 ⇒ 00:18:15.090 Nicolas Sucari: Yeah, yeah, so that we can, we can do kind of more of a product analysis.
280 00:18:15.910 ⇒ 00:18:16.355 Luke Daque: Gotcha.
281 00:18:17.360 ⇒ 00:18:17.990 Nicolas Sucari: Okay.
282 00:18:18.570 ⇒ 00:18:23.760 Nicolas Sucari: But that’s not a priority, though. Right now, I mean, let’s keep working on what we have. And if we.
283 00:18:24.160 ⇒ 00:18:33.070 Nicolas Sucari: it is just to show them what we can do with real like. If we want to answer some quick questions about what’s the most sold product or, yeah, something like that.
284 00:18:33.270 ⇒ 00:18:33.890 Nicolas Sucari: we can do.
285 00:18:33.890 ⇒ 00:18:34.210 Luke Daque: Yeah.
286 00:18:34.210 ⇒ 00:18:35.600 Nicolas Sucari: Analysis. Okay.
287 00:18:36.150 ⇒ 00:18:36.820 Nicolas Sucari: Yep.
288 00:18:37.470 ⇒ 00:18:38.890 Nicolas Sucari: cool. Excellent.
289 00:18:38.890 ⇒ 00:18:39.680 Luke Daque: That’s good.
290 00:18:41.150 ⇒ 00:18:44.569 Nicolas Sucari: Great, excellent Ryan. Thank you. I’m gonna send that.
291 00:18:45.129 ⇒ 00:18:47.929 Luke Daque: Anything else. We’re missing here
292 00:18:48.638 ⇒ 00:18:52.819 Luke Daque: this one. So I can. I can work on this adding product categories.
293 00:18:54.110 ⇒ 00:18:55.660 Luke Daque: shipment stable.
294 00:19:01.580 ⇒ 00:19:02.300 Luke Daque: Yeah.
295 00:19:04.135 ⇒ 00:19:04.630 Luke Daque: wait.
296 00:19:12.080 ⇒ 00:19:12.670 Luke Daque: Yep.
297 00:19:12.670 ⇒ 00:19:13.119 Nicolas Sucari: Yeah, I think.
298 00:19:13.120 ⇒ 00:19:13.730 Luke Daque: That’s good.
299 00:19:13.730 ⇒ 00:19:24.570 Nicolas Sucari: I. I think this is okay for the Google one. They are missing the file matching Amazon and shopify. I asked Brian to send what he was working on. He didn’t answer. I’m gonna ask again.
300 00:19:25.090 ⇒ 00:19:25.640 Luke Daque: Right.
301 00:19:25.640 ⇒ 00:19:37.110 Nicolas Sucari: Keep that in the in that column. And yeah, we can leave the shipment stuff for later. The product one is just we have time. If not, don’t, don’t, don’t bother on it. Okay.
302 00:19:37.640 ⇒ 00:19:39.190 Luke Daque: Okay. Sounds good.
303 00:19:39.740 ⇒ 00:19:43.039 Nicolas Sucari: Yeah, let’s focus 1st on the refunds and return stuff.
304 00:19:43.580 ⇒ 00:19:44.300 Luke Daque: Okay.
305 00:19:44.780 ⇒ 00:19:45.510 Luke Daque: Cool.
306 00:19:45.850 ⇒ 00:19:54.640 Nicolas Sucari: And on pool parts. Did you read that message that from Utam that he sent like? Let’s do this in real. I don’t know what he meant with that.
307 00:19:56.610 ⇒ 00:19:57.970 Luke Daque: 4 parts.
308 00:20:00.840 ⇒ 00:20:05.330 Nicolas Sucari: Go to client pull parts. No, no, not in the external one in the internal one
309 00:20:07.110 ⇒ 00:20:08.780 Nicolas Sucari: about the skill list.
310 00:20:11.760 ⇒ 00:20:13.280 Nicolas Sucari: I don’t know what did him
311 00:20:13.290 ⇒ 00:20:16.209 Nicolas Sucari: mean with, let’s get this into real.
312 00:20:18.610 ⇒ 00:20:19.300 Luke Daque: Hmm.
313 00:20:22.100 ⇒ 00:20:23.259 Nicolas Sucari: Right. I don’t know.
314 00:20:23.260 ⇒ 00:20:24.490 Luke Daque: Yeah.
315 00:20:26.080 ⇒ 00:20:31.309 Luke Daque: well, what’s this? Do I? Is it? Sq, list analysis?
316 00:20:40.530 ⇒ 00:20:42.189 Luke Daque: Oh, this is the
317 00:20:42.840 ⇒ 00:20:44.780 Luke Daque: let’s do the chat.
318 00:20:58.180 ⇒ 00:21:03.470 Luke Daque: Yeah, we we we can’t put it in real unless we get the
319 00:21:03.630 ⇒ 00:21:05.090 Luke Daque: the list. Right?
320 00:21:05.490 ⇒ 00:21:08.420 Luke Daque: So yeah, I’m also like a bit confused. This.
321 00:21:09.040 ⇒ 00:21:09.720 Nicolas Sucari: Yeah, I’m gonna
322 00:21:10.150 ⇒ 00:21:11.020 Nicolas Sucari: chat.
323 00:21:11.420 ⇒ 00:21:19.479 Nicolas Sucari: Yeah, we need that. We need that skew metrics. But I I think we have something that we prepared a couple of weeks ago. I’m gonna try to find that
324 00:21:20.150 ⇒ 00:21:20.870 Luke Daque: Yeah.
325 00:21:21.960 ⇒ 00:21:27.229 Nicolas Sucari: But yeah, I don’t know what he meant with adding that into real, because we have all of the data there. So
326 00:21:27.470 ⇒ 00:21:35.860 Nicolas Sucari: it would be just creating a new table with all of the skews. But that’s not gonna be something nice to see in real
327 00:21:35.880 ⇒ 00:21:39.089 Nicolas Sucari: right, because it’s just gonna be like a huge list of skews.
328 00:21:40.070 ⇒ 00:21:45.660 Luke Daque: Yeah, unless there’s like any reason they need to drill down to anything
329 00:21:45.710 ⇒ 00:21:48.350 Luke Daque: else other than just the skew names.
330 00:21:48.900 ⇒ 00:21:52.540 Nicolas Sucari: Exactly, because if we don’t have any metric like, it’s kind of weird, right?
331 00:21:52.800 ⇒ 00:21:53.190 Luke Daque: Yeah.
332 00:21:54.520 ⇒ 00:21:55.960 Luke Daque: yeah, makes sense.
333 00:21:56.960 ⇒ 00:21:57.590 Nicolas Sucari: Okay.
334 00:21:58.780 ⇒ 00:21:59.750 Luke Daque: Okay.
335 00:22:01.790 ⇒ 00:22:02.610 Nicolas Sucari: Great.
336 00:22:03.130 ⇒ 00:22:08.569 Nicolas Sucari: So let’s keep doing that. And yeah, they don’t think we have anything else right.
337 00:22:09.750 ⇒ 00:22:11.159 Luke Daque: I think so. Yeah.
338 00:22:12.090 ⇒ 00:22:12.890 Luke Daque: cool.
339 00:22:14.140 ⇒ 00:22:15.870 Luke Daque: Cool. Sounds good.
340 00:22:15.870 ⇒ 00:22:19.930 Nicolas Sucari: Excellent. Yeah, I think we are. We are okay. Thank you. Ryan.
341 00:22:20.110 ⇒ 00:22:22.289 Luke Daque: Thanks, Nico. Have a nice rest of the day.
342 00:22:22.290 ⇒ 00:22:23.349 Nicolas Sucari: Let’s talk later.
343 00:22:23.640 ⇒ 00:22:25.609 Luke Daque: Yeah. See you. Bye-bye.
344 00:22:25.610 ⇒ 00:22:26.190 Nicolas Sucari: Bye-bye.