Meeting Title: 🚶-Rill-Walkthrogh-on-Kim’s-reports Date: 2024-07-11 Meeting participants: Ryan Luke Daque, Nicolas Sucari
WEBVTT
1 00:05:30.940 ⇒ 00:05:31.850 Nicolas Sucari: Hi! Ryan.
2 00:05:34.700 ⇒ 00:05:35.600 Ryan Luke Daque: Hi! Nicholas.
3 00:05:39.170 ⇒ 00:05:40.249 Ryan Luke Daque: can you hear me?
4 00:05:41.210 ⇒ 00:05:43.369 Nicolas Sucari: Yes, I can hear you. How are you?
5 00:05:43.370 ⇒ 00:05:45.269 Ryan Luke Daque: Yeah, I’m doing great. How are you?
6 00:05:46.540 ⇒ 00:05:48.129 Nicolas Sucari: Yeah. Doing. Fine.
7 00:05:52.040 ⇒ 00:05:54.519 Ryan Luke Daque: Cool? So yeah, I think.
8 00:05:57.388 ⇒ 00:06:03.670 Ryan Luke Daque: What do you call this? Wtam wanted to discuss with you with like all the things that we
9 00:06:04.110 ⇒ 00:06:05.560 Ryan Luke Daque: move to real.
10 00:06:06.510 ⇒ 00:06:07.330 Nicolas Sucari: Okay.
11 00:06:07.940 ⇒ 00:06:10.840 Ryan Luke Daque: So yeah, let me maybe share my screen so that
12 00:06:11.130 ⇒ 00:06:11.700 Ryan Luke Daque: the.
13 00:06:11.700 ⇒ 00:06:12.810 Nicolas Sucari: Yeah, okay.
14 00:06:18.140 ⇒ 00:06:26.529 Nicolas Sucari: he he told you that. Yeah, to show me what about the teams? Report? Right? Like all of the reports that we had a night dash. How we’re moving that into real.
15 00:06:27.090 ⇒ 00:06:28.030 Ryan Luke Daque: Yeah.
16 00:06:28.410 ⇒ 00:06:29.230 Ryan Luke Daque: yeah.
17 00:06:29.230 ⇒ 00:06:29.880 Nicolas Sucari: Okay.
18 00:06:30.350 ⇒ 00:06:31.179 Nicolas Sucari: so yeah, yeah.
19 00:06:31.180 ⇒ 00:06:32.229 Ryan Luke Daque: To have a meeting with.
20 00:06:32.230 ⇒ 00:06:38.869 Nicolas Sucari: Team. Yeah, the idea is to have a weekly meeting with team and go through that report and show her how she can
21 00:06:39.000 ⇒ 00:06:40.470 Nicolas Sucari: start using that.
22 00:06:41.070 ⇒ 00:06:42.183 Ryan Luke Daque: Right? Yeah.
23 00:06:43.070 ⇒ 00:06:46.770 Ryan Luke Daque: so yeah, just to just to recap. Can you see my screen? By the way.
24 00:06:49.200 ⇒ 00:06:49.560 Nicolas Sucari: Yes.
25 00:06:50.390 ⇒ 00:06:56.271 Ryan Luke Daque: Yeah, so this is, these are at the reports.
26 00:06:56.890 ⇒ 00:06:58.290 Ryan Luke Daque: from light dash
27 00:06:58.460 ⇒ 00:07:00.550 Ryan Luke Daque: that we wanted to move to real.
28 00:07:00.830 ⇒ 00:07:01.980 Ryan Luke Daque: So
29 00:07:03.270 ⇒ 00:07:08.220 Ryan Luke Daque: like some of them have already been in there like the vital science and
30 00:07:08.250 ⇒ 00:07:09.370 Ryan Luke Daque: other stuff.
31 00:07:09.530 ⇒ 00:07:18.359 Ryan Luke Daque: I believe the things that I added was this one the warranty dashboard? Well, of course, Kim’s weekly dashboard
32 00:07:20.390 ⇒ 00:07:26.119 Ryan Luke Daque: the goals and forecast. But these these 2 are hidden goals and inventory are hidden, so
33 00:07:26.240 ⇒ 00:07:27.599 Ryan Luke Daque: I think I’ll
34 00:07:28.307 ⇒ 00:07:32.460 Ryan Luke Daque: I I can add, whoever needs to have access to this.
35 00:07:32.510 ⇒ 00:07:35.009 Ryan Luke Daque: But for now I think it’s only
36 00:07:35.160 ⇒ 00:07:37.270 Ryan Luke Daque: me. I think that, I added.
37 00:07:37.410 ⇒ 00:07:40.137 Ryan Luke Daque: but I can like add you and utam, perhaps.
38 00:07:40.750 ⇒ 00:07:41.809 Ryan Luke Daque: okay. This
39 00:07:42.010 ⇒ 00:07:42.850 Ryan Luke Daque: kind of.
40 00:07:43.465 ⇒ 00:07:45.310 Nicolas Sucari: Okay. Okay. Perfect.
41 00:07:45.620 ⇒ 00:07:46.370 Ryan Luke Daque: Yeah, sure.
42 00:07:46.760 ⇒ 00:07:50.350 Ryan Luke Daque: So yeah, we can, we can start with. Maybe Kim’s weekly report.
43 00:07:51.500 ⇒ 00:07:54.749 Nicolas Sucari: Yeah, just 1 1 thing. Can you go to? Okay?
44 00:07:54.860 ⇒ 00:07:56.590 Nicolas Sucari: So go to real.
45 00:07:57.130 ⇒ 00:08:02.959 Nicolas Sucari: can we create kind of a folder like a marketing folder so that we can have, like all
46 00:08:04.100 ⇒ 00:08:05.260 Nicolas Sucari: reports.
47 00:08:05.930 ⇒ 00:08:12.130 Nicolas Sucari: I don’t know. Perfect pro. Probably if you click on pull parts to go like one folder.
48 00:08:13.440 ⇒ 00:08:14.060 Nicolas Sucari: Yeah.
49 00:08:14.060 ⇒ 00:08:14.630 Ryan Luke Daque: Yeah.
50 00:08:14.630 ⇒ 00:08:17.889 Nicolas Sucari: That right like, create a new project and make
51 00:08:17.960 ⇒ 00:08:20.910 Nicolas Sucari: those reports live in
52 00:08:21.550 ⇒ 00:08:23.859 Nicolas Sucari: like a marketing project right.
53 00:08:24.250 ⇒ 00:08:25.479 Ryan Luke Daque: Yeah, we can do that.
54 00:08:25.783 ⇒ 00:08:26.390 Nicolas Sucari: Don’t worry.
55 00:08:26.970 ⇒ 00:08:27.339 Ryan Luke Daque: Yeah, we.
56 00:08:27.340 ⇒ 00:08:29.480 Nicolas Sucari: I, it’s just an idea. Yeah.
57 00:08:29.480 ⇒ 00:08:30.190 Ryan Luke Daque: Yeah.
58 00:08:30.612 ⇒ 00:08:33.999 Ryan Luke Daque: but we’ll have to like, yeah, yeah, we’ll have to create like.
59 00:08:34.000 ⇒ 00:08:36.300 Nicolas Sucari: Don’t worry. Don’t worry. Okay. Yeah. Yeah. Yeah.
60 00:08:36.549 ⇒ 00:08:37.440 Nicolas Sucari: That’s fine.
61 00:08:37.770 ⇒ 00:08:38.450 Ryan Luke Daque: Cool.
62 00:08:39.090 ⇒ 00:08:41.649 Ryan Luke Daque: Yeah, for now it’s like, everything’s in here.
63 00:08:42.730 ⇒ 00:08:47.010 Ryan Luke Daque: So we can go to Kim’s weekly report. So basically, this is
64 00:08:48.222 ⇒ 00:08:54.349 Ryan Luke Daque: by default, it’s always set to like last month last one month. So the the most recent month.
65 00:08:54.810 ⇒ 00:08:56.090 Ryan Luke Daque: And then.
66 00:08:56.910 ⇒ 00:09:02.800 Ryan Luke Daque: yeah, for the time zone. It’s like defaulting to my time zone cause I’m in Asia, but
67 00:09:02.960 ⇒ 00:09:04.840 Ryan Luke Daque: we can like select.
68 00:09:04.840 ⇒ 00:09:09.509 Nicolas Sucari: This. This is already up, right? So if I go to real, I can see this.
69 00:09:09.510 ⇒ 00:09:12.449 Ryan Luke Daque: Yeah, you should be able to see this as well.
70 00:09:14.830 ⇒ 00:09:17.540 Nicolas Sucari: Okay. So this is Kim’s weekly report.
71 00:09:18.090 ⇒ 00:09:18.690 Ryan Luke Daque: Yeah.
72 00:09:18.690 ⇒ 00:09:25.329 Nicolas Sucari: Yeah, perfect. Yeah, I mean, it’s okay. i i i see only 2 time zones. But I think that’s fine.
73 00:09:25.760 ⇒ 00:09:29.169 Nicolas Sucari: BT, that is American, New York and Utah. Okay, perfect.
74 00:09:29.420 ⇒ 00:09:30.100 Nicolas Sucari: Yep.
75 00:09:31.944 ⇒ 00:09:40.810 Nicolas Sucari: One more question. I see that we have, like all of the measures on the left. Can’t we? Like there’s so much white space.
76 00:09:41.240 ⇒ 00:09:42.370 Ryan Luke Daque: Yeah, I know.
77 00:09:42.370 ⇒ 00:09:46.340 Nicolas Sucari: Is there a different way on like ordering this or not?
78 00:09:46.610 ⇒ 00:09:55.539 Ryan Luke Daque: I think at the moment this is just how real is like. All the metrics, all the measures, are at the left, and then all the dimensions are at the the right part.
79 00:09:55.700 ⇒ 00:09:59.319 Ryan Luke Daque: So since, like, there’s only 2 dimensions here, that’s why, like, there’s.
80 00:09:59.320 ⇒ 00:09:59.790 Nicolas Sucari: Yeah, yeah.
81 00:09:59.790 ⇒ 00:10:05.440 Ryan Luke Daque: White space, and I don’t think there’s at at a current state of real. We can’t like
82 00:10:06.080 ⇒ 00:10:07.900 Ryan Luke Daque: move things around.
83 00:10:09.060 ⇒ 00:10:10.900 Nicolas Sucari: Yeah. Okay. Don’t worry.
84 00:10:11.950 ⇒ 00:10:12.680 Ryan Luke Daque: Yeah.
85 00:10:12.680 ⇒ 00:10:13.700 Nicolas Sucari: Okay, perfect.
86 00:10:14.340 ⇒ 00:10:18.799 Nicolas Sucari: And do you have the light dash report there, so that I can see.
87 00:10:19.920 ⇒ 00:10:22.000 Nicolas Sucari: What he was looking online.
88 00:10:22.600 ⇒ 00:10:28.889 Ryan Luke Daque: Yeah. But I think I can’t log in, because, like we, because of the 2 fa for Snowflake.
89 00:10:29.860 ⇒ 00:10:30.620 Nicolas Sucari: Oh, really.
90 00:10:30.620 ⇒ 00:10:33.970 Ryan Luke Daque: It looks like all the reports from light dash is already like
91 00:10:34.840 ⇒ 00:10:36.460 Ryan Luke Daque: unaccessible.
92 00:10:37.020 ⇒ 00:10:38.780 Ryan Luke Daque: I’m not sure it’s on your end
93 00:10:39.030 ⇒ 00:10:43.279 Ryan Luke Daque: if you can access. But like, let me show you what it looks like. Now.
94 00:10:48.760 ⇒ 00:10:50.009 Ryan Luke Daque: yeah, it’s gonna
95 00:10:50.310 ⇒ 00:10:52.520 Ryan Luke Daque: load for a bit, and then
96 00:10:53.152 ⇒ 00:10:57.800 Ryan Luke Daque: since it can’t access, it’s gonna show an error for everything
97 00:10:57.960 ⇒ 00:10:59.239 Ryan Luke Daque: because of the 2 fa.
98 00:10:59.240 ⇒ 00:11:00.469 Nicolas Sucari: Okay, that’s fine.
99 00:11:01.510 ⇒ 00:11:04.950 Nicolas Sucari: Okay, perfect. So this is Weekly Kim’s weekly report. Okay.
100 00:11:07.350 ⇒ 00:11:10.339 Ryan Luke Daque: Number of recipients, open rate, click through rate
101 00:11:10.700 ⇒ 00:11:18.050 Ryan Luke Daque: for all. And then these are the channels right? She can like show like the cost, for example, for each channel
102 00:11:18.630 ⇒ 00:11:20.210 Ryan Luke Daque: that needs to be this.
103 00:11:20.430 ⇒ 00:11:27.200 Ryan Luke Daque: And then, like, she can filter like maybe Google ads, for example. So these are all the measures for Google Ads
104 00:11:27.640 ⇒ 00:11:29.269 Ryan Luke Daque: or direct mail.
105 00:11:29.550 ⇒ 00:11:30.740 Ryan Luke Daque: This would be all the
106 00:11:31.360 ⇒ 00:11:33.010 Ryan Luke Daque: measures available.
107 00:11:33.730 ⇒ 00:11:36.759 Ryan Luke Daque: And then, like she can also like do
108 00:11:37.150 ⇒ 00:11:38.360 Ryan Luke Daque: campaigns.
109 00:11:38.360 ⇒ 00:11:38.980 Nicolas Sucari: Fair.
110 00:11:39.150 ⇒ 00:11:40.150 Ryan Luke Daque: Change it?
111 00:11:40.560 ⇒ 00:11:41.220 Ryan Luke Daque: Yep.
112 00:11:41.580 ⇒ 00:11:42.760 Ryan Luke Daque: And then, yeah.
113 00:11:43.820 ⇒ 00:11:45.749 Nicolas Sucari: Yeah, that’s fine, perfect.
114 00:11:46.480 ⇒ 00:11:51.439 Ryan Luke Daque: Cool and would you be would Kim be looking at other?
115 00:11:51.970 ⇒ 00:11:52.880 Ryan Luke Daque: A
116 00:11:53.440 ⇒ 00:11:56.830 Ryan Luke Daque: dashboards like, for example, the warranties, for example.
117 00:11:57.580 ⇒ 00:11:58.080 Ryan Luke Daque: or is.
118 00:11:58.080 ⇒ 00:11:59.250 Nicolas Sucari: I’m not sure.
119 00:12:00.310 ⇒ 00:12:01.469 Ryan Luke Daque: I see? Yeah.
120 00:12:02.350 ⇒ 00:12:05.277 Ryan Luke Daque: So if that’s if she’s only looking at this, then
121 00:12:06.140 ⇒ 00:12:07.889 Ryan Luke Daque: I don’t know. Maybe we can.
122 00:12:09.610 ⇒ 00:12:13.870 Ryan Luke Daque: Yeah, like you mentioned, like we can have a folder like just for Kim’s weekly report, and then.
123 00:12:13.870 ⇒ 00:12:14.400 Nicolas Sucari: I think.
124 00:12:14.400 ⇒ 00:12:14.790 Ryan Luke Daque: Out there. Yeah.
125 00:12:14.790 ⇒ 00:12:26.400 Nicolas Sucari: No, no, I don’t think like we should have like a photo for weekly reports. I I think we should have a full like we need to split up what our reports or dashboards that we are creating for marketing and.
126 00:12:26.400 ⇒ 00:12:27.259 Ryan Luke Daque: And for it.
127 00:12:27.260 ⇒ 00:12:31.239 Nicolas Sucari: Yeah, marketing, shipping, shipping, shipping, and probably like
128 00:12:31.290 ⇒ 00:12:32.800 Nicolas Sucari: business reports.
129 00:12:32.920 ⇒ 00:12:33.740 Ryan Luke Daque: Right.
130 00:12:33.740 ⇒ 00:12:34.350 Nicolas Sucari: Right it.
131 00:12:36.000 ⇒ 00:12:36.740 Ryan Luke Daque: Yeah.
132 00:12:36.860 ⇒ 00:12:40.980 Nicolas Sucari: Because there you have marketing operations and yeah, and kind of
133 00:12:41.220 ⇒ 00:12:43.669 Nicolas Sucari: business results, or something like that.
134 00:12:43.670 ⇒ 00:12:44.723 Ryan Luke Daque: I guess.
135 00:12:45.300 ⇒ 00:12:47.290 Ryan Luke Daque: Create a ticket for that.
136 00:12:47.290 ⇒ 00:12:50.059 Nicolas Sucari: It’s an idea. Maybe we can add.
137 00:12:50.220 ⇒ 00:12:51.479 Nicolas Sucari: discuss it with.
138 00:12:51.880 ⇒ 00:12:52.710 Ryan Luke Daque: Doesn’t.
139 00:12:52.710 ⇒ 00:12:57.539 Nicolas Sucari: But I think like it’s gonna be easier for them to navigate through
140 00:12:57.670 ⇒ 00:12:58.610 Nicolas Sucari: real.
141 00:12:58.920 ⇒ 00:13:00.000 Ryan Luke Daque: Yeah, makes sense.
142 00:13:00.960 ⇒ 00:13:02.189 Ryan Luke Daque: Yeah, cool. Great.
143 00:13:03.480 ⇒ 00:13:04.139 Ryan Luke Daque: So, so.
144 00:13:04.140 ⇒ 00:13:09.539 Nicolas Sucari: So apart from teams, weekly report. Which one else do, you have like that table that you were working on.
145 00:13:09.540 ⇒ 00:13:13.220 Ryan Luke Daque: This one the paid marketing report. So
146 00:13:13.670 ⇒ 00:13:20.509 Ryan Luke Daque: it marketing performance. So it has all the marketing measures here the impressions, conversion rate clicks cost.
147 00:13:20.780 ⇒ 00:13:23.250 Ryan Luke Daque: and then all the campaign.
148 00:13:23.250 ⇒ 00:13:23.980 Nicolas Sucari: Yeah, perfect.
149 00:13:23.980 ⇒ 00:13:32.369 Ryan Luke Daque: I or the Ids, and also the names like Campaign Id. There’s campaign name. There’s add name, add set, and also platform.
150 00:13:33.400 ⇒ 00:13:37.609 Nicolas Sucari: So if you click on company name, and, like you go like to the dimension.
151 00:13:38.720 ⇒ 00:13:43.545 Nicolas Sucari: you know, when you drill down, kind of not not one like not one.
152 00:13:44.115 ⇒ 00:13:44.340 Ryan Luke Daque: See!
153 00:13:44.340 ⇒ 00:13:45.840 Nicolas Sucari: Can you open? Yeah. Bad. One.
154 00:13:45.840 ⇒ 00:13:46.360 Ryan Luke Daque: Yeah.
155 00:13:46.360 ⇒ 00:13:51.769 Nicolas Sucari: Perfect. Okay? So you can see here impression conversion. Yeah, okay, probably this is super helpful
156 00:13:51.860 ⇒ 00:13:52.900 Nicolas Sucari: form
157 00:13:53.330 ⇒ 00:13:54.999 Nicolas Sucari: for her right.
158 00:13:55.000 ⇒ 00:13:55.906 Ryan Luke Daque: Yep, yeah.
159 00:13:57.700 ⇒ 00:13:58.340 Ryan Luke Daque: Yeah.
160 00:13:58.510 ⇒ 00:14:01.220 Ryan Luke Daque: And I think they they can also like, add
161 00:14:02.895 ⇒ 00:14:04.770 Ryan Luke Daque: percent of total
162 00:14:07.090 ⇒ 00:14:08.699 Ryan Luke Daque: if it’s available.
163 00:14:10.510 ⇒ 00:14:15.449 Ryan Luke Daque: wait. So it’s not here. But so let me check. I don’t think maybe I did not.
164 00:14:16.510 ⇒ 00:14:19.289 Ryan Luke Daque: It’s supposed to be valid, so they should be
165 00:14:20.000 ⇒ 00:14:21.310 Ryan Luke Daque: able to.
166 00:14:29.370 ⇒ 00:14:33.059 Ryan Luke Daque: So maybe impressions. We don’t have percent of total.
167 00:14:34.670 ⇒ 00:14:35.960 Ryan Luke Daque: So clicks.
168 00:14:37.110 ⇒ 00:14:37.910 Ryan Luke Daque: yeah.
169 00:14:38.120 ⇒ 00:14:40.410 Ryan Luke Daque: So for anything that’s like a sum like.
170 00:14:40.410 ⇒ 00:14:40.810 Nicolas Sucari: Yeah.
171 00:14:40.810 ⇒ 00:14:46.459 Ryan Luke Daque: For example, then we can have, we do. We have like percent of total as well. We can add it there.
172 00:14:47.060 ⇒ 00:14:47.970 Ryan Luke Daque: So yeah.
173 00:14:49.380 ⇒ 00:14:50.120 Ryan Luke Daque: cool.
174 00:14:50.430 ⇒ 00:14:52.549 Nicolas Sucari: Okay. Perfect. Yeah. Great.
175 00:14:52.880 ⇒ 00:15:03.520 Ryan Luke Daque: And the other thing that I added, I think, warranties. This is just yeah, customer. And like the item type in this this queue
176 00:15:04.110 ⇒ 00:15:06.669 Ryan Luke Daque: and all all the related warranties
177 00:15:07.100 ⇒ 00:15:08.789 Ryan Luke Daque: measures for that.
178 00:15:08.810 ⇒ 00:15:09.880 Ryan Luke Daque: I just followed what.
179 00:15:09.880 ⇒ 00:15:11.730 Nicolas Sucari: I don’t think this one is.
180 00:15:12.070 ⇒ 00:15:12.950 Nicolas Sucari: Yeah.
181 00:15:13.100 ⇒ 00:15:13.990 Ryan Luke Daque: Yeah, okay.
182 00:15:13.990 ⇒ 00:15:14.730 Nicolas Sucari: This way.
183 00:15:15.824 ⇒ 00:15:17.519 Ryan Luke Daque: What else I think
184 00:15:17.790 ⇒ 00:15:21.029 Ryan Luke Daque: for returns or refunds, I mean.
185 00:15:21.140 ⇒ 00:15:25.700 Ryan Luke Daque: I didn’t create anything, cause we already have that I realized like, it’s
186 00:15:25.920 ⇒ 00:15:29.279 Ryan Luke Daque: in the all orders already. So if we go to all orders.
187 00:15:29.660 ⇒ 00:15:30.800 Ryan Luke Daque: dashboard.
188 00:15:30.840 ⇒ 00:15:34.900 Ryan Luke Daque: it already has the measures for refunds. Total refunds.
189 00:15:36.704 ⇒ 00:15:37.669 Ryan Luke Daque: Discounts.
190 00:15:38.850 ⇒ 00:15:44.680 Ryan Luke Daque: Yeah, like everything here is already. So it’s gonna be redundant if we have another
191 00:15:44.900 ⇒ 00:15:45.630 Ryan Luke Daque: real.
192 00:15:45.630 ⇒ 00:15:48.630 Nicolas Sucari: Yeah. And yeah, I think this is fine.
193 00:15:48.790 ⇒ 00:15:52.780 Nicolas Sucari: And if you wanna see the full pros, where should we look at.
194 00:15:58.800 ⇒ 00:15:59.930 Ryan Luke Daque: do.
195 00:16:00.690 ⇒ 00:16:03.209 Nicolas Sucari: I think it’s in all order items, right? I think.
196 00:16:03.830 ⇒ 00:16:05.080 Ryan Luke Daque: Let’s try.
197 00:16:14.250 ⇒ 00:16:17.130 Nicolas Sucari: Hmm! We don’t have it now right.
198 00:16:17.440 ⇒ 00:16:19.789 Ryan Luke Daque: No, it’s not here. So maybe it’s not all
199 00:16:19.810 ⇒ 00:16:21.150 Ryan Luke Daque: order items.
200 00:16:22.380 ⇒ 00:16:23.290 Ryan Luke Daque: Maybe. Sh-
201 00:16:23.930 ⇒ 00:16:25.340 Ryan Luke Daque: customers.
202 00:16:25.570 ⇒ 00:16:26.530 Ryan Luke Daque: Yeah, cost.
203 00:16:26.530 ⇒ 00:16:27.069 Nicolas Sucari: Oh, it’s.
204 00:16:27.070 ⇒ 00:16:28.250 Ryan Luke Daque: Old. Pro yeah.
205 00:16:28.590 ⇒ 00:16:29.100 Ryan Luke Daque: Yeah.
206 00:16:29.100 ⇒ 00:16:29.700 Nicolas Sucari: Who gave?
207 00:16:29.850 ⇒ 00:16:31.979 Nicolas Sucari: Yeah, because it’s only a shopify. Okay?
208 00:16:32.100 ⇒ 00:16:33.010 Nicolas Sucari: Right?
209 00:16:33.360 ⇒ 00:16:37.700 Nicolas Sucari: Don’t, don’t we? It’s it’s impossible to make like
210 00:16:38.340 ⇒ 00:16:44.140 Nicolas Sucari: like like a huge dashboard with everything on it.
211 00:16:46.100 ⇒ 00:16:47.600 Ryan Luke Daque: In real it.
212 00:16:50.690 ⇒ 00:16:52.040 Nicolas Sucari: You know what I mean right like in.
213 00:16:52.040 ⇒ 00:16:52.710 Ryan Luke Daque: Yeah, like.
214 00:16:52.710 ⇒ 00:17:01.159 Nicolas Sucari: I know that we have like this is specific dashboards to go see, shopify orders to go see pain marketing stuff to go see campaigns.
215 00:17:01.400 ⇒ 00:17:05.819 Nicolas Sucari: refunds. But don’t. Is it possible to have, like all the measures.
216 00:17:05.920 ⇒ 00:17:08.389 Nicolas Sucari: one and, like all the dimensions.
217 00:17:08.690 ⇒ 00:17:16.130 Ryan Luke Daque: Yeah, I don’t think in real it’s possible to do that, because, like, we are like separating, we have like separate models for each dashboard.
218 00:17:17.109 ⇒ 00:17:20.389 Ryan Luke Daque: Be, if if we use something else like maybe
219 00:17:21.240 ⇒ 00:17:21.980 Ryan Luke Daque: light
220 00:17:22.150 ⇒ 00:17:27.320 Ryan Luke Daque: like, based on my experience, like power. Bi, for example, we can do that even if, like it’s different
221 00:17:27.410 ⇒ 00:17:30.799 Ryan Luke Daque: sources, right? But that’s that’s totally a different
222 00:17:31.070 ⇒ 00:17:33.270 Ryan Luke Daque: like tool. But for real like.
223 00:17:33.270 ⇒ 00:17:38.649 Nicolas Sucari: So now for for each dashboard we have like a model. Or how are we doing this?
224 00:17:38.650 ⇒ 00:17:45.970 Ryan Luke Daque: Yes, basically like that. So if I can show you here, like in dashboards, there’s like each dashboard.
225 00:17:45.970 ⇒ 00:17:46.310 Nicolas Sucari: Yeah.
226 00:17:46.310 ⇒ 00:17:48.290 Ryan Luke Daque: Individual like model.
227 00:17:48.370 ⇒ 00:17:51.060 Ryan Luke Daque: It’s getting from a specific
228 00:17:51.350 ⇒ 00:17:52.360 Ryan Luke Daque: model.
229 00:17:52.820 ⇒ 00:17:55.750 Ryan Luke Daque: So it’s not like combining
230 00:17:55.900 ⇒ 00:17:57.009 Ryan Luke Daque: models like.
231 00:17:57.010 ⇒ 00:17:59.210 Nicolas Sucari: So you you can’t combine most
232 00:17:59.390 ⇒ 00:18:00.700 Nicolas Sucari: to one dashboard.
233 00:18:01.000 ⇒ 00:18:03.210 Ryan Luke Daque: At the moment. Not no.
234 00:18:03.440 ⇒ 00:18:04.469 Ryan Luke Daque: it can’t
235 00:18:05.300 ⇒ 00:18:07.650 Ryan Luke Daque: like real. Can’t do that
236 00:18:07.720 ⇒ 00:18:09.469 Ryan Luke Daque: well unless we.
237 00:18:10.720 ⇒ 00:18:14.099 Ryan Luke Daque: unless we join them in the in the source.
238 00:18:14.100 ⇒ 00:18:15.230 Nicolas Sucari: From a normal
239 00:18:15.776 ⇒ 00:18:17.860 Nicolas Sucari: okay, in a different source.
240 00:18:17.860 ⇒ 00:18:20.299 Ryan Luke Daque: Yeah, in a different source. We’ll just have to join
241 00:18:20.340 ⇒ 00:18:21.900 Ryan Luke Daque: and make one big
242 00:18:22.440 ⇒ 00:18:23.770 Ryan Luke Daque: one big table
243 00:18:24.850 ⇒ 00:18:25.330 Ryan Luke Daque: or.
244 00:18:25.330 ⇒ 00:18:25.910 Nicolas Sucari: Okay.
245 00:18:27.710 ⇒ 00:18:28.340 Ryan Luke Daque: Yeah.
246 00:18:28.780 ⇒ 00:18:33.129 Ryan Luke Daque: I guess we can do that. But we’ll have to like, specify, like what fields we need.
247 00:18:34.770 ⇒ 00:18:35.629 Ryan Luke Daque: and just make.
248 00:18:35.630 ⇒ 00:18:36.690 Nicolas Sucari: Yeah, yeah.
249 00:18:37.220 ⇒ 00:18:38.070 Ryan Luke Daque: Yeah.
250 00:18:38.810 ⇒ 00:18:40.859 Nicolas Sucari: Yeah, I was just trying to understand. If.
251 00:18:41.700 ⇒ 00:18:45.480 Nicolas Sucari: like having everything is possible, like the big table
252 00:18:45.740 ⇒ 00:18:51.330 Nicolas Sucari: where you can like, do whatever you want, and not like jump between different dashboards. Right.
253 00:18:51.680 ⇒ 00:18:58.250 Ryan Luke Daque: Makes sense the the tricky part there is to make sure, like nothing’s being duplicated and stuff right
254 00:18:58.440 ⇒ 00:18:59.509 Ryan Luke Daque: like if one.
255 00:18:59.760 ⇒ 00:19:00.430 Nicolas Sucari: Yeah.
256 00:19:01.010 ⇒ 00:19:05.489 Ryan Luke Daque: Like. If one customer has multiple orders. For example, we just have to make sure that
257 00:19:05.900 ⇒ 00:19:09.610 Ryan Luke Daque: data would not be like duplicated and stuff like that.
258 00:19:11.460 ⇒ 00:19:12.659 Nicolas Sucari: Yep. Okay.
259 00:19:12.950 ⇒ 00:19:17.509 Nicolas Sucari: I’m gonna go quickly through the real documentation.
260 00:19:18.500 ⇒ 00:19:19.300 Ryan Luke Daque: Yeah, sure.
261 00:19:19.300 ⇒ 00:19:21.119 Nicolas Sucari: See if we can create like
262 00:19:22.510 ⇒ 00:19:23.670 Nicolas Sucari: new projects.
263 00:19:25.250 ⇒ 00:19:25.960 Ryan Luke Daque: Cool.
264 00:19:26.460 ⇒ 00:19:28.140 Ryan Luke Daque: Oh, what else did I
265 00:19:28.160 ⇒ 00:19:29.420 Ryan Luke Daque: add here.
266 00:19:29.750 ⇒ 00:19:34.750 Ryan Luke Daque: I think, cause it’s hidden. Maybe I can see. But let me.
267 00:19:40.340 ⇒ 00:19:41.660 Ryan Luke Daque: what’s this?
268 00:19:42.620 ⇒ 00:19:45.289 Ryan Luke Daque: Let me try to reopen this
269 00:19:47.030 ⇒ 00:19:48.220 Ryan Luke Daque: locally.
270 00:19:54.710 ⇒ 00:19:55.675 Nicolas Sucari: Really.
271 00:20:04.470 ⇒ 00:20:08.466 Ryan Luke Daque: Yeah. So this is inventory that I’m working on at the moment.
272 00:20:10.990 ⇒ 00:20:12.550 Ryan Luke Daque: and but
273 00:20:14.060 ⇒ 00:20:17.089 Ryan Luke Daque: shipments, goals, and forecast.
274 00:20:17.660 ⇒ 00:20:18.070 Nicolas Sucari: Okay.
275 00:20:18.070 ⇒ 00:20:19.659 Ryan Luke Daque: We also have this one.
276 00:20:20.340 ⇒ 00:20:21.640 Ryan Luke Daque: So this only.
277 00:20:22.010 ⇒ 00:20:22.620 Ryan Luke Daque: Googled.
278 00:20:22.940 ⇒ 00:20:27.260 Ryan Luke Daque: a 1 dimension, actual, actual versus forecast. And then.
279 00:20:27.610 ⇒ 00:20:34.580 Ryan Luke Daque: like gross revenue actuals would be like this. Then forecast would be this something like that
280 00:20:35.510 ⇒ 00:20:36.570 Ryan Luke Daque: air.
281 00:20:37.800 ⇒ 00:20:44.469 Ryan Luke Daque: Yeah, I I think they can. Probably, even if they go into the measure, they can change it into a
282 00:20:45.740 ⇒ 00:20:47.890 Ryan Luke Daque: Oh, yeah, it’s already online, short.
283 00:20:49.660 ⇒ 00:20:50.849 Nicolas Sucari: Hmm! It’s great.
284 00:20:51.490 ⇒ 00:20:54.340 Nicolas Sucari: Can you go back to the code just for me?
285 00:20:57.246 ⇒ 00:20:58.000 Ryan Luke Daque: Yeah. Sure.
286 00:20:58.960 ⇒ 00:21:01.580 Nicolas Sucari: Go to the real Yaml file.
287 00:21:02.030 ⇒ 00:21:02.750 Ryan Luke Daque: Oh, yeah.
288 00:21:02.750 ⇒ 00:21:04.059 Nicolas Sucari: In this code. I think.
289 00:21:05.710 ⇒ 00:21:07.730 Ryan Luke Daque: For that, for this one.
290 00:21:12.040 ⇒ 00:21:16.780 Nicolas Sucari: Let me see, where? Where did you start like your local host just for now.
291 00:21:19.150 ⇒ 00:21:21.230 Ryan Luke Daque: Where did I start?
292 00:21:21.770 ⇒ 00:21:23.410 Ryan Luke Daque: Oh, yeah, I had.
293 00:21:24.990 ⇒ 00:21:26.990 Nicolas Sucari: You. Yeah, I know.
294 00:21:27.290 ⇒ 00:21:30.170 Nicolas Sucari: And let me see you’re gonna get that.
295 00:21:30.730 ⇒ 00:21:33.279 Nicolas Sucari: Can you scroll down a little bit on that?
296 00:21:33.860 ⇒ 00:21:35.330 Nicolas Sucari: This is
297 00:21:36.300 ⇒ 00:21:38.909 Nicolas Sucari: no. Wait, wait, wait, wait, wait, wait, wait! Wait.
298 00:21:40.510 ⇒ 00:21:45.989 Nicolas Sucari: Okay, go to underneath sources there should be. If you close down sources.
299 00:21:47.230 ⇒ 00:21:50.280 Nicolas Sucari: Yeah, there you you have like a real yam file.
300 00:21:50.280 ⇒ 00:21:51.179 Ryan Luke Daque: Oh, yeah. Yeah.
301 00:21:51.180 ⇒ 00:21:51.840 Nicolas Sucari: Done one.
302 00:21:52.410 ⇒ 00:21:53.910 Nicolas Sucari: So here
303 00:21:54.690 ⇒ 00:21:58.369 Nicolas Sucari: you, you see that you have, like title pullparts, to go
304 00:21:59.150 ⇒ 00:22:00.269 Nicolas Sucari: on the top.
305 00:22:00.270 ⇒ 00:22:00.820 Ryan Luke Daque: Yeah.
306 00:22:00.820 ⇒ 00:22:03.549 Nicolas Sucari: I think this is kind of one project right?
307 00:22:03.720 ⇒ 00:22:04.490 Ryan Luke Daque: Yeah.
308 00:22:04.680 ⇒ 00:22:07.149 Ryan Luke Daque: like, we’ll have to have multiple
309 00:22:07.440 ⇒ 00:22:11.090 Ryan Luke Daque: folders for like different projects, one
310 00:22:11.330 ⇒ 00:22:15.869 Ryan Luke Daque: multiple real yaml files for like one for each project.
311 00:22:16.290 ⇒ 00:22:16.850 Nicolas Sucari: Yes.
312 00:22:17.740 ⇒ 00:22:18.380 Ryan Luke Daque: Yep.
313 00:22:18.740 ⇒ 00:22:20.909 Nicolas Sucari: Like you will need to have, like
314 00:22:21.300 ⇒ 00:22:26.810 Nicolas Sucari: 2 dot dashboard folders, 2 models, 2 sources like everything underneath a different.
315 00:22:27.557 ⇒ 00:22:32.320 Ryan Luke Daque: Yeah, it’s gonna be like this. I can show you like how it
316 00:22:33.100 ⇒ 00:22:34.699 Ryan Luke Daque: in the docks.
317 00:22:36.920 ⇒ 00:22:38.880 Ryan Luke Daque: Project project
318 00:22:43.375 ⇒ 00:22:44.310 Ryan Luke Daque: deploy
319 00:22:44.800 ⇒ 00:22:45.780 Ryan Luke Daque: project.
320 00:22:49.890 ⇒ 00:22:51.709 Ryan Luke Daque: Where was that part.
321 00:22:56.120 ⇒ 00:22:57.850 Ryan Luke Daque: What was it in quick start?
322 00:23:03.710 ⇒ 00:23:06.279 Ryan Luke Daque: And this is an example project that they have.
323 00:23:06.280 ⇒ 00:23:08.440 Nicolas Sucari: Go go to project files.
324 00:23:08.550 ⇒ 00:23:10.320 Nicolas Sucari: I think there is one in the
325 00:23:10.750 ⇒ 00:23:12.770 Nicolas Sucari: yeah project, young.
326 00:23:17.280 ⇒ 00:23:20.540 Ryan Luke Daque: But yeah, this is an example of their github
327 00:23:21.150 ⇒ 00:23:26.309 Ryan Luke Daque: for a sample project. So each of these folder is a different project.
328 00:23:26.910 ⇒ 00:23:27.560 Nicolas Sucari: Oh, okay.
329 00:23:27.560 ⇒ 00:23:31.169 Ryan Luke Daque: 3, 1 1 Ops, for example, it has a really ammo.
330 00:23:31.820 ⇒ 00:23:32.200 Ryan Luke Daque: Yeah.
331 00:23:32.200 ⇒ 00:23:34.290 Nicolas Sucari: And if you go to like, can you
332 00:23:34.410 ⇒ 00:23:36.000 Nicolas Sucari: can you preview this.
333 00:23:37.020 ⇒ 00:23:38.264 Ryan Luke Daque: They have us
334 00:23:39.100 ⇒ 00:23:40.540 Ryan Luke Daque: green shot
335 00:23:43.050 ⇒ 00:23:43.780 Ryan Luke Daque: huh!
336 00:23:44.700 ⇒ 00:23:45.260 Ryan Luke Daque: Don’t want.
337 00:23:45.260 ⇒ 00:23:47.550 Nicolas Sucari: Don’t worry. I’m just trying to.
338 00:23:50.010 ⇒ 00:23:53.540 Ryan Luke Daque: Yeah, we can. We can always pull this repository and.
339 00:23:53.940 ⇒ 00:23:54.810 Nicolas Sucari: Yeah. Don’t worry.
340 00:23:55.050 ⇒ 00:23:55.959 Ryan Luke Daque: With the app.
341 00:23:56.240 ⇒ 00:24:00.440 Ryan Luke Daque: But this would be like you like in in here.
342 00:24:01.152 ⇒ 00:24:02.299 Ryan Luke Daque: Where was that
343 00:24:02.990 ⇒ 00:24:05.000 Ryan Luke Daque: like? Each of the folder here
344 00:24:05.570 ⇒ 00:24:06.300 Ryan Luke Daque: would be like.
345 00:24:06.300 ⇒ 00:24:06.770 Nicolas Sucari: Would be.
346 00:24:06.770 ⇒ 00:24:09.899 Ryan Luke Daque: A separate yeah. A separate project.
347 00:24:11.920 ⇒ 00:24:12.590 Nicolas Sucari: Okay.
348 00:24:12.980 ⇒ 00:24:18.989 Ryan Luke Daque: So yeah, we can have like one for marketing, one for orders, I guess. Like one for customers.
349 00:24:20.290 ⇒ 00:24:21.040 Nicolas Sucari: Yeah.
350 00:24:22.370 ⇒ 00:24:24.979 Ryan Luke Daque: And like, Kpis, or like, Yeah.
351 00:24:24.980 ⇒ 00:24:33.790 Nicolas Sucari: Don’t worry, don’t, don’t! Don’t think about that now. I’m gonna try to discuss it with them and see if it’s worth to do all that work because it’s gonna duplicate a lot of
352 00:24:33.900 ⇒ 00:24:37.639 Nicolas Sucari: I’m not duplicate, but have a like a lot of code
353 00:24:37.840 ⇒ 00:24:38.700 Nicolas Sucari: right?
354 00:24:38.880 ⇒ 00:24:39.570 Ryan Luke Daque: Yeah.
355 00:24:40.422 ⇒ 00:24:44.219 Ryan Luke Daque: Well, it shouldn’t be too too hard, though, because we just have to
356 00:24:45.480 ⇒ 00:24:46.700 Ryan Luke Daque: start
357 00:24:47.030 ⇒ 00:24:48.270 Ryan Luke Daque: multiple
358 00:24:48.640 ⇒ 00:24:51.650 Ryan Luke Daque: folders here. Yeah, we just have to move.
359 00:24:51.650 ⇒ 00:24:52.080 Nicolas Sucari: Yeah.
360 00:24:52.080 ⇒ 00:24:53.140 Ryan Luke Daque: Lawyer. Do you have
361 00:24:53.610 ⇒ 00:24:58.050 Ryan Luke Daque: like a marketing, for example? We’ll just have to move it to the other folder.
362 00:24:58.120 ⇒ 00:24:59.899 Ryan Luke Daque: Yeah, and that should be fine.
363 00:25:00.990 ⇒ 00:25:01.700 Nicolas Sucari: Okay.
364 00:25:03.550 ⇒ 00:25:04.340 Nicolas Sucari: Okay.
365 00:25:05.930 ⇒ 00:25:08.346 Nicolas Sucari: Okay. Well, thanks, Ryan.
366 00:25:09.390 ⇒ 00:25:15.930 Nicolas Sucari: is there any other report that you’re working on? That’s not ready yet? Or should I know? And should I talk to.
367 00:25:15.930 ⇒ 00:25:25.670 Ryan Luke Daque: Just this inventory. But yeah, it should be done a like today. So I’m I’m just fixing this one error. And then I.
368 00:25:25.930 ⇒ 00:25:26.250 Nicolas Sucari: Okay.
369 00:25:26.250 ⇒ 00:25:27.909 Ryan Luke Daque: Piece, and then we should be good.
370 00:25:30.290 ⇒ 00:25:30.920 Nicolas Sucari: Okay.
371 00:25:31.300 ⇒ 00:25:32.619 Ryan Luke Daque: This is also a hidden.
372 00:25:32.620 ⇒ 00:25:33.040 Nicolas Sucari: Dashboard!
373 00:25:33.040 ⇒ 00:25:38.849 Ryan Luke Daque: And but anyway, so it’s not. I guess this is like the one of the lesser important ones.
374 00:25:38.980 ⇒ 00:25:41.830 Ryan Luke Daque: because Otam decided these to be hidden.
375 00:25:42.360 ⇒ 00:25:43.890 Ryan Luke Daque: So we’ll have to like
376 00:25:43.910 ⇒ 00:25:48.010 Ryan Luke Daque: grant access to whoever needs access to these. So yeah.
377 00:25:49.780 ⇒ 00:25:50.510 Nicolas Sucari: Okay.
378 00:25:51.890 ⇒ 00:25:52.905 Nicolas Sucari: perfect.
379 00:25:54.690 ⇒ 00:25:56.990 Nicolas Sucari: yeah. I don’t think we have like
380 00:25:57.890 ⇒ 00:26:01.030 Nicolas Sucari: a lot of other stuff that we need to reunite.
381 00:26:01.920 ⇒ 00:26:07.399 Ryan Luke Daque: Yeah, I think so too. The ones that are are assigned to me are just this one
382 00:26:07.710 ⇒ 00:26:11.179 Ryan Luke Daque: other 2 remaining. This is the main parent
383 00:26:11.360 ⇒ 00:26:14.609 Ryan Luke Daque: task. And then this is the for the one for the inventory.
384 00:26:15.390 ⇒ 00:26:17.010 Ryan Luke Daque: And then, yeah, perfect.
385 00:26:18.460 ⇒ 00:26:23.839 Nicolas Sucari: Great. Okay, I’ll talk to Utam probably tomorrow and see what else
386 00:26:24.360 ⇒ 00:26:30.090 Nicolas Sucari: you can get into that backlog so that you know what’s coming for you. Okay.
387 00:26:30.580 ⇒ 00:26:31.900 Ryan Luke Daque: Cool sounds, good.
388 00:26:33.180 ⇒ 00:26:34.149 Nicolas Sucari: Thank you, Ryan.
389 00:26:34.510 ⇒ 00:26:37.259 Ryan Luke Daque: Thanks, Nicholas, have a nice day.
390 00:26:37.390 ⇒ 00:26:38.060 Ryan Luke Daque: Bye-bye.
391 00:26:38.220 ⇒ 00:26:38.880 Nicolas Sucari: You too.