Meeting Title: AE-Planning-Session Date: 2024-10-07 Meeting participants: Nicolas Sucari, Ryan Luke Daque
WEBVTT
1 00:01:35.780 ⇒ 00:01:36.620 Ryan Luke Daque: Hello!
2 00:01:40.160 ⇒ 00:01:41.030 Nicolas Sucari: Hi! Ryan.
3 00:01:42.020 ⇒ 00:01:43.549 Ryan Luke Daque: Hi, Nico! How’s it going.
4 00:01:44.290 ⇒ 00:01:45.180 Nicolas Sucari: How are you?
5 00:01:45.910 ⇒ 00:01:47.629 Ryan Luke Daque: Doing? Well, how’s your weekend.
6 00:01:48.760 ⇒ 00:01:49.959 Nicolas Sucari: It was good.
7 00:01:50.050 ⇒ 00:01:51.239 Nicolas Sucari: How about you?
8 00:01:52.540 ⇒ 00:01:55.009 Ryan Luke Daque: Yeah, it was pretty fine. Nothing
9 00:01:55.080 ⇒ 00:01:56.849 Ryan Luke Daque: too much going on.
10 00:01:59.240 ⇒ 00:02:00.730 Nicolas Sucari: You were able to rest
11 00:02:01.300 ⇒ 00:02:02.130 Nicolas Sucari: chill weekend.
12 00:02:02.130 ⇒ 00:02:05.580 Ryan Luke Daque: Yes. Yeah. Yeah. Chill. Pretty chill.
13 00:02:06.320 ⇒ 00:02:07.350 Nicolas Sucari: Yeah, me, too.
14 00:02:07.490 ⇒ 00:02:08.539 Nicolas Sucari: was fine.
15 00:02:08.620 ⇒ 00:02:10.539 Nicolas Sucari: Was really nice weather here.
16 00:02:11.100 ⇒ 00:02:11.906 Ryan Luke Daque: Oh, nice.
17 00:02:12.450 ⇒ 00:02:13.070 Ryan Luke Daque: Yeah. Here.
18 00:02:13.070 ⇒ 00:02:13.910 Nicolas Sucari: Yeah.
19 00:02:13.910 ⇒ 00:02:16.579 Ryan Luke Daque: Pretty much raining every afternoon. So
20 00:02:17.110 ⇒ 00:02:20.649 Ryan Luke Daque: if you want to go out, it should be in the morning. It’s not raining.
21 00:02:21.280 ⇒ 00:02:22.200 Ryan Luke Daque: So yeah.
22 00:02:22.200 ⇒ 00:02:24.719 Nicolas Sucari: Yeah, here is starting to
23 00:02:25.170 ⇒ 00:02:28.519 Nicolas Sucari: be a little bit more water. So that’s.
24 00:02:29.010 ⇒ 00:02:30.100 Nicolas Sucari: Kind of nice.
25 00:02:30.380 ⇒ 00:02:34.116 Nicolas Sucari: but it’s not that that hot that you can stand.
26 00:02:34.490 ⇒ 00:02:34.919 Ryan Luke Daque: So it’s.
27 00:02:34.920 ⇒ 00:02:40.169 Nicolas Sucari: Kind of the like the best weather ever, where you can go out and do whatever you want.
28 00:02:40.630 ⇒ 00:02:41.180 Nicolas Sucari: Yeah.
29 00:02:41.180 ⇒ 00:02:43.210 Ryan Luke Daque: That’s always nice, I think.
30 00:02:43.210 ⇒ 00:02:50.819 Nicolas Sucari: I think today it was going to rain. But yeah, I don’t know. Sky is kind of in doubt of if it’s gonna rain or not.
31 00:02:50.820 ⇒ 00:02:51.930 Ryan Luke Daque: The rain or not. Yeah.
32 00:02:51.930 ⇒ 00:02:54.030 Nicolas Sucari: Yeah, yeah. Still deciding.
33 00:02:56.690 ⇒ 00:02:57.550 Nicolas Sucari: but cool.
34 00:02:58.052 ⇒ 00:03:00.977 Nicolas Sucari: So what? I’m still, it’s gonna be around this week.
35 00:03:01.270 ⇒ 00:03:01.680 Ryan Luke Daque: Yeah.
36 00:03:01.680 ⇒ 00:03:09.240 Nicolas Sucari: Think we should. We should aim on working on all of the things for Kim trying to.
37 00:03:09.240 ⇒ 00:03:10.300 Ryan Luke Daque: See if we can fix it.
38 00:03:10.300 ⇒ 00:03:13.319 Nicolas Sucari: I’ve seen. I’ve seen you send a pull request right.
39 00:03:13.940 ⇒ 00:03:15.859 Ryan Luke Daque: Yeah, I think we have.
40 00:03:16.180 ⇒ 00:03:19.109 Ryan Luke Daque: The only thing that I’m missing now is the
41 00:03:20.869 ⇒ 00:03:25.180 Ryan Luke Daque: what? What do you call this? Was it direct mail coming from.
42 00:03:25.540 ⇒ 00:03:27.130 Nicolas Sucari: Okay. Post pilot.
43 00:03:27.310 ⇒ 00:03:31.390 Ryan Luke Daque: Post pilot. Yeah, that’s just the thing. I was able to fix that
44 00:03:31.440 ⇒ 00:03:33.490 Ryan Luke Daque: G Google ads.
45 00:03:33.530 ⇒ 00:03:35.691 Ryan Luke Daque: And I did check double check the
46 00:03:36.520 ⇒ 00:03:38.267 Ryan Luke Daque: the others that
47 00:03:39.000 ⇒ 00:03:42.160 Ryan Luke Daque: the one kept from Klavio like SMS and email.
48 00:03:42.378 ⇒ 00:03:43.249 Nicolas Sucari: Should be good. Okay.
49 00:03:43.250 ⇒ 00:03:46.810 Ryan Luke Daque: As long as they’re in a campaign level. So we should be good
50 00:03:47.430 ⇒ 00:03:54.079 Ryan Luke Daque: the Facebook still has a little bit of discrete discrepancy. But I didn’t look further into that anymore.
51 00:03:54.430 ⇒ 00:03:55.400 Nicolas Sucari: Yeah, how are you?
52 00:03:55.870 ⇒ 00:03:58.340 Ryan Luke Daque: Yeah, I’ll be focusing on
53 00:03:58.880 ⇒ 00:04:04.570 Ryan Luke Daque: just the the pool post pilot, and then we should be good. I guess.
54 00:04:05.440 ⇒ 00:04:12.990 Nicolas Sucari: Excellent. Okay, yeah. I think it that all we will be able to finish kind of all of that there and then.
55 00:04:13.831 ⇒ 00:04:19.569 Nicolas Sucari: We received the Uni shipments report today. The Po number is not there.
56 00:04:19.700 ⇒ 00:04:27.259 Nicolas Sucari: My only concern there is I. I’m I’m fine with the epo number. Don’t being there. They are still owing us. To add that.
57 00:04:27.260 ⇒ 00:04:27.800 Ryan Luke Daque: Information.
58 00:04:27.800 ⇒ 00:04:29.080 Nicolas Sucari: Connect to the report.
59 00:04:29.150 ⇒ 00:04:31.040 Nicolas Sucari: But once they they
60 00:04:31.280 ⇒ 00:04:39.740 Nicolas Sucari: once they did, they do that like how we’re gonna update all of these weeks that we don’t have the Po number for these reports. Yeah, we should go.
61 00:04:40.130 ⇒ 00:04:43.050 Nicolas Sucari: We should go back manually and start adding
62 00:04:43.692 ⇒ 00:04:46.720 Nicolas Sucari: to each row, or how, how? Yeah.
63 00:04:47.680 ⇒ 00:04:49.238 Ryan Luke Daque: Yeah, that’s a good question.
64 00:04:50.160 ⇒ 00:04:55.159 Ryan Luke Daque: do. Would we have a report that has the historical data for that, though?
65 00:04:55.600 ⇒ 00:04:56.100 Ryan Luke Daque: Or.
66 00:04:56.100 ⇒ 00:04:57.180 Nicolas Sucari: I’m not sure.
67 00:04:57.360 ⇒ 00:04:58.320 Nicolas Sucari: Yeah, we’ll have to.
68 00:04:58.320 ⇒ 00:04:59.340 Ryan Luke Daque: Figure out
69 00:04:59.480 ⇒ 00:05:02.650 Ryan Luke Daque: depends on like what happens once they fix that
70 00:05:02.690 ⇒ 00:05:07.270 Ryan Luke Daque: like. If they have a historical report, that would be best case scenario.
71 00:05:07.270 ⇒ 00:05:08.190 Nicolas Sucari: But they can just.
72 00:05:08.190 ⇒ 00:05:09.010 Ryan Luke Daque: Note that.
73 00:05:09.130 ⇒ 00:05:10.479 Ryan Luke Daque: but if not.
74 00:05:11.020 ⇒ 00:05:20.619 Ryan Luke Daque: I don’t know. We’ll have to find a different approach, like if there’s we can do some some kind of mapping to like which po number or
75 00:05:21.530 ⇒ 00:05:21.880 Nicolas Sucari: Okay.
76 00:05:22.550 ⇒ 00:05:23.830 Ryan Luke Daque: Yeah, something like that.
77 00:05:24.150 ⇒ 00:05:40.199 Nicolas Sucari: I I think we can do it. I think we we can do it. Because we have we have in that report a lot of information for each of the shipments that they’ve been doing, and we will be able to match that with something from shopify because of the orders are in shopify. So
78 00:05:40.757 ⇒ 00:05:45.139 Nicolas Sucari: yeah, maybe it’s something more manual that we will need to work on.
79 00:05:45.461 ⇒ 00:05:53.329 Nicolas Sucari: But yeah, I think we can. We can do it. Once we have that po number in the report so that we can see what what we need.
80 00:05:53.630 ⇒ 00:06:00.029 Nicolas Sucari: Also, I I’m not sure if they are, gonna use the same field that they have there on the report
81 00:06:00.320 ⇒ 00:06:04.830 Nicolas Sucari: for the new one so maybe what we will need to do is to add
82 00:06:05.189 ⇒ 00:06:13.220 Nicolas Sucari: yeah, to to add one field or one column in in Snowflake to read that new column that will come in the report.
83 00:06:13.770 ⇒ 00:06:14.320 Ryan Luke Daque: Right.
84 00:06:14.320 ⇒ 00:06:14.900 Nicolas Sucari: Okay.
85 00:06:15.180 ⇒ 00:06:16.290 Ryan Luke Daque: Makes sense. Yeah.
86 00:06:16.650 ⇒ 00:06:27.150 Nicolas Sucari: Because Justin told us that the Po number will come in a with a new kind of column name. That’s customer order number, or something like that.
87 00:06:27.620 ⇒ 00:06:28.370 Ryan Luke Daque: Okay.
88 00:06:29.580 ⇒ 00:06:36.469 Nicolas Sucari: So yeah, we will need to check that. But don’t worry. I think we can check that once we once they update the report and see what we have.
89 00:06:36.780 ⇒ 00:06:37.340 Nicolas Sucari: Right?
90 00:06:37.340 ⇒ 00:06:38.900 Ryan Luke Daque: Okay, right?
91 00:06:40.860 ⇒ 00:06:41.205 Nicolas Sucari: Cool.
92 00:06:41.750 ⇒ 00:06:43.445 Nicolas Sucari: Apart from that
93 00:06:44.860 ⇒ 00:06:49.719 Nicolas Sucari: I don’t know if Uta mentioned about the real project to you.
94 00:06:50.010 ⇒ 00:06:51.319 Nicolas Sucari: I think. Yes, right.
95 00:06:51.620 ⇒ 00:06:53.260 Ryan Luke Daque: Yeah, the real
96 00:06:53.787 ⇒ 00:06:56.410 Ryan Luke Daque: yeah, the the 10 h thing.
97 00:06:57.305 ⇒ 00:07:03.919 Ryan Luke Daque: That will be split between Patrick and I, I believe because he’ll be doing the data integration part. And once he’s done with
98 00:07:03.990 ⇒ 00:07:05.230 Ryan Luke Daque: that help.
99 00:07:05.390 ⇒ 00:07:13.270 Ryan Luke Daque: I’ll be doing the data modeling. I think it should be based on what I saw from the document. It should be pretty straightforward, so
100 00:07:13.400 ⇒ 00:07:14.159 Ryan Luke Daque: hopefully it.
101 00:07:14.160 ⇒ 00:07:14.930 Nicolas Sucari: Yeah.
102 00:07:14.930 ⇒ 00:07:20.599 Ryan Luke Daque: True like when once we really have the data. And it’s really just that straightforward. Then it should be pretty.
103 00:07:21.280 ⇒ 00:07:25.019 Ryan Luke Daque: We should be able to take care of that. Yeah, easily.
104 00:07:25.160 ⇒ 00:07:28.449 Ryan Luke Daque: So yeah, hope so. But they haven’t.
105 00:07:29.289 ⇒ 00:07:30.130 Nicolas Sucari: Yeah.
106 00:07:30.463 ⇒ 00:07:33.740 Nicolas Sucari: they have to give us access to the Github space. I think.
107 00:07:33.740 ⇒ 00:07:34.330 Ryan Luke Daque: Right.
108 00:07:34.330 ⇒ 00:07:40.279 Nicolas Sucari: First, st and then Patrick can start working on the integration between Snowflake and Click House.
109 00:07:41.950 ⇒ 00:07:44.120 Nicolas Sucari: that’s like the 1st step to that.
110 00:07:44.120 ⇒ 00:07:44.390 Ryan Luke Daque: Right.
111 00:07:44.390 ⇒ 00:08:00.970 Nicolas Sucari: There, I think. And then, once we have the data in in Snowflake, we can then start the modeling. But yeah, it should be pretty straightforward. We have like 2 tables, and we need to create 2 dashboards in real, and they have, like all of the dimensions and metrics that they want in that document.
112 00:08:00.970 ⇒ 00:08:02.290 Ryan Luke Daque: That document. Yeah.
113 00:08:02.754 ⇒ 00:08:10.629 Ryan Luke Daque: so, but like, ideally or like, based on the timeline, it should start next week, right? Not this week.
114 00:08:10.670 ⇒ 00:08:13.370 Ryan Luke Daque: Or was it supposed to be for this week.
115 00:08:16.410 ⇒ 00:08:26.199 Nicolas Sucari: I’m not sure. I mean, I think Uta wanted to start this week with that 10 h, but they need to give us access to Github first.st
116 00:08:26.200 ⇒ 00:08:27.960 Ryan Luke Daque: Right? Makes sense. Okay.
117 00:08:28.590 ⇒ 00:08:39.659 Nicolas Sucari: Yeah. So let’s let’s let’s keep working on pool parts. Let’s try to finish that up and send to Kim. If we have that ready before Thursday. I think that will be good to send her.
118 00:08:39.669 ⇒ 00:08:40.259 Ryan Luke Daque: Yeah.
119 00:08:40.260 ⇒ 00:08:40.990 Nicolas Sucari: You got I would.
120 00:08:40.990 ⇒ 00:08:41.410 Ryan Luke Daque: Very much.
121 00:08:41.419 ⇒ 00:08:41.829 Nicolas Sucari: Yes.
122 00:08:41.830 ⇒ 00:08:50.550 Ryan Luke Daque: To finish it today. Cause I I’ve been like working on this for for more than a week already. It’s pretty yeah.
123 00:08:51.180 ⇒ 00:08:53.780 Ryan Luke Daque: And for the chat. Gpt one. I think
124 00:08:54.150 ⇒ 00:09:02.459 Ryan Luke Daque: maybe we can look into an 8 N instead of like, we’re using the workflow, because, like, based on what we’ve seen
125 00:09:02.908 ⇒ 00:09:10.470 Ryan Luke Daque: what Miguel was doing last Friday. I think it is possible to do it in 8. N, so.
126 00:09:10.650 ⇒ 00:09:12.810 Ryan Luke Daque: but yeah, that’s in case.
127 00:09:12.810 ⇒ 00:09:13.790 Nicolas Sucari: Let me know if you.
128 00:09:13.790 ⇒ 00:09:14.720 Ryan Luke Daque: Time. Yeah.
129 00:09:14.720 ⇒ 00:09:21.869 Nicolas Sucari: Yeah, yeah, if if you finish this pull our stuff and we don’t have yet the Github access for
130 00:09:21.930 ⇒ 00:09:27.459 Nicolas Sucari: the real project, let me know what we can spend some time with Miguel trying to figure out how to use an atem
131 00:09:27.540 ⇒ 00:09:29.760 Nicolas Sucari: to create that connectivity stuff. Okay.
132 00:09:29.870 ⇒ 00:09:31.220 Ryan Luke Daque: Sounds good.
133 00:09:31.590 ⇒ 00:09:37.969 Nicolas Sucari: I think that’s a good plan. Yeah. Okay, cool. Let’s talk later, or let me know if you need anything else. Okay.
134 00:09:38.430 ⇒ 00:09:39.340 Ryan Luke Daque: Yeah, sure.
135 00:09:40.560 ⇒ 00:09:41.200 Ryan Luke Daque: Sounds good.
136 00:09:41.200 ⇒ 00:09:42.170 Nicolas Sucari: Excellent.
137 00:09:42.860 ⇒ 00:09:43.460 Ryan Luke Daque: Just.
138 00:09:43.460 ⇒ 00:09:43.869 Nicolas Sucari: That’s right.
139 00:09:43.870 ⇒ 00:09:46.139 Ryan Luke Daque: Slack if there’s anything else like.
140 00:09:46.140 ⇒ 00:09:46.690 Nicolas Sucari: Yeah.
141 00:09:46.690 ⇒ 00:09:48.880 Ryan Luke Daque: Something comes up urgent or something. Yeah.
142 00:09:49.020 ⇒ 00:09:54.069 Nicolas Sucari: I don’t think we have anything right now. But yeah, I’ll let you know. Okay.
143 00:09:54.070 ⇒ 00:09:56.349 Ryan Luke Daque: Sounds good. Thanks, Nico. Have a nice day.
144 00:09:56.350 ⇒ 00:09:57.679 Nicolas Sucari: Thanks, bye, bye.
145 00:09:57.810 ⇒ 00:09:58.480 Ryan Luke Daque: Bye-bye.