Meeting Title: AE-Planning-Session Date: 2024-10-21 Meeting participants: Luke Daque, Nicolas Sucari


WEBVTT

1 00:06:07.090 00:06:07.970 Nicolas Sucari: Hey, Ryan.

2 00:06:18.720 00:06:19.340 Luke Daque: Hello!

3 00:06:20.650 00:06:22.250 Nicolas Sucari: Can you hear me? Oh, I can hear you! There.

4 00:06:23.570 00:06:24.600 Luke Daque: Hello! How’s how are you?

5 00:06:24.600 00:06:25.079 Nicolas Sucari: How are you?

6 00:06:25.080 00:06:27.389 Luke Daque: Good. Yeah. Doing. Well, how are you?

7 00:06:28.290 00:06:30.810 Nicolas Sucari: It was a good chill weekend also

8 00:06:31.350 00:06:32.699 Nicolas Sucari: this match to do.

9 00:06:33.240 00:06:34.100 Nicolas Sucari: Yeah.

10 00:06:34.780 00:06:35.880 Nicolas Sucari: how about you.

11 00:06:36.670 00:06:38.847 Luke Daque: Yeah, pretty pretty fine as well.

12 00:06:39.460 00:06:41.430 Luke Daque: we celebrated our sons

13 00:06:41.460 00:06:46.430 Luke Daque: birthday. Well, actually, his birthday is tomorrow. But we celebrated it, and on.

14 00:06:46.430 00:06:46.790 Nicolas Sucari: Early.

15 00:06:46.790 00:06:48.034 Luke Daque: And he hackers.

16 00:06:48.930 00:06:50.860 Luke Daque: Yeah, like, it’s where

17 00:06:51.200 00:06:53.609 Luke Daque: less, more time and stuff like that. So.

18 00:06:54.600 00:06:55.759 Nicolas Sucari: How old is he?

19 00:06:56.310 00:06:59.810 Luke Daque: He’s 11 now. Yeah. Turning 11.

20 00:06:59.810 00:07:00.610 Nicolas Sucari: Nice.

21 00:07:00.790 00:07:01.480 Luke Daque: Yeah.

22 00:07:01.690 00:07:02.700 Nicolas Sucari: He’s big.

23 00:07:02.810 00:07:03.790 Nicolas Sucari: Oh, yeah.

24 00:07:05.410 00:07:05.770 Luke Daque: I’m flying.

25 00:07:05.770 00:07:06.460 Nicolas Sucari: How old are you?

26 00:07:07.490 00:07:08.780 Luke Daque: I’m

27 00:07:09.160 00:07:10.540 Luke Daque: 39.

28 00:07:11.430 00:07:14.030 Nicolas Sucari: Oh, you look younger, that’s cool.

29 00:07:14.550 00:07:15.210 Nicolas Sucari: Oh, that’s.

30 00:07:15.210 00:07:15.770 Luke Daque: Beautiful.

31 00:07:17.060 00:07:17.980 Nicolas Sucari: 31.

32 00:07:17.980 00:07:19.530 Luke Daque: 31. Yeah, cool.

33 00:07:19.810 00:07:20.910 Luke Daque: That’s yeah.

34 00:07:21.060 00:07:22.580 Luke Daque: Not so far.

35 00:07:23.470 00:07:25.670 Nicolas Sucari: No, I don’t have kids yet.

36 00:07:25.930 00:07:26.640 Luke Daque: Yeah.

37 00:07:28.722 00:07:37.764 Nicolas Sucari: Okay, I don’t know if we have like a lot of stuff to do this week. Maybe we need to start with this from all parts.

38 00:07:38.410 00:07:39.720 Luke Daque: So 2.

39 00:07:40.850 00:07:44.889 Nicolas Sucari: We have those 2 things because for Kim we don’t have anything but.

40 00:07:44.890 00:07:45.440 Luke Daque: Right.

41 00:07:45.440 00:07:49.320 Nicolas Sucari: We just received that email. I don’t know if you received the file from Eunice.

42 00:07:49.630 00:07:52.779 Luke Daque: I did check, but I don’t think so. I didn’t see any.

43 00:07:53.260 00:07:54.670 Luke Daque: Yeah. Or maybe.

44 00:07:54.670 00:07:58.490 Nicolas Sucari: Let me download it and send it to you if you want to, through the slack channel.

45 00:07:59.020 00:08:00.089 Luke Daque: Yeah, sure.

46 00:08:00.200 00:08:01.469 Luke Daque: Yeah, that’d be great.

47 00:08:01.800 00:08:02.850 Luke Daque: I can

48 00:08:03.750 00:08:07.920 Luke Daque: try to figure that out. So I guess maybe that would be the 1st one.

49 00:08:08.730 00:08:16.779 Nicolas Sucari: Yeah, because we will need to. Yeah, we need to like match what we have in the Po number field with this new field that’s called

50 00:08:17.020 00:08:19.299 Nicolas Sucari: SO. Number. I don’t know.

51 00:08:19.300 00:08:19.780 Luke Daque: It’s.

52 00:08:19.780 00:08:33.050 Nicolas Sucari: Yeah, I don’t know what this stands for it. But yeah, that’s where I just identified. But yeah, I mean, we don’t need to replace the entire column. It’s like just the new ones will all come in there right.

53 00:08:37.679 00:08:39.409 Luke Daque: Yeah, I’ll I’ll

54 00:08:39.969 00:08:42.879 Luke Daque: are we receiving this through?

55 00:08:44.750 00:08:48.510 Luke Daque: Yeah, this is still the same file, right? That we are receiving through email.

56 00:08:48.510 00:08:49.370 Nicolas Sucari: Same file.

57 00:08:49.370 00:08:49.960 Luke Daque: So I.

58 00:08:49.960 00:08:50.409 Nicolas Sucari: Be fine.

59 00:08:50.410 00:08:53.229 Luke Daque: This will also already show up in

60 00:08:54.910 00:08:55.640 Nicolas Sucari: In snowflake.

61 00:08:55.640 00:08:56.270 Luke Daque: Ready!

62 00:08:56.850 00:08:58.099 Nicolas Sucari: I think. Yes.

63 00:08:58.750 00:09:00.059 Luke Daque: Yeah, and then.

64 00:09:00.060 00:09:01.420 Nicolas Sucari: Bad. Maybe

65 00:09:02.080 00:09:02.650 Nicolas Sucari: fake

66 00:09:03.290 00:09:04.440 Nicolas Sucari: because.

67 00:09:04.580 00:09:06.199 Luke Daque: Is this a junk field?

68 00:09:06.720 00:09:07.360 Luke Daque: As soon as.

69 00:09:07.360 00:09:12.550 Nicolas Sucari: I think so. Yes, let me let me check the same file. But from last week

70 00:09:12.960 00:09:15.550 Nicolas Sucari: YCY 6.

71 00:09:15.960 00:09:18.620 Luke Daque: I’ll I’m checking Snowflake now.

72 00:09:19.590 00:09:20.980 Luke Daque: Let me just

73 00:09:21.170 00:09:22.120 Luke Daque: open, but

74 00:09:22.520 00:09:23.680 Luke Daque: push

75 00:09:23.960 00:09:25.760 Luke Daque: notification.

76 00:09:26.030 00:09:29.700 Nicolas Sucari: It’s. It’s a new field that’s between po number and create date.

77 00:09:29.940 00:09:31.890 Luke Daque: I see that wasn’t there before.

78 00:09:32.310 00:09:34.049 Nicolas Sucari: No, it wasn’t there before. No.

79 00:09:34.050 00:09:38.229 Luke Daque: And before it was we were using po number before right.

80 00:09:39.510 00:09:42.920 Luke Daque: which I can just snowflake real quick.

81 00:09:45.345 00:09:46.560 Luke Daque: Email.

82 00:09:47.000 00:09:48.480 Nicolas Sucari: I can check to.

83 00:09:51.200 00:09:56.649 Luke Daque: So for uni shipments. It looks like spo number.

84 00:09:57.560 00:09:59.990 Luke Daque: it doesn’t look like it’s there yet.

85 00:10:04.930 00:10:14.589 Nicolas Sucari: Yeah, the field is okay. Your number is still there, but it’s empty. And now they are like they adding the information in in a new column next to it that’s called.

86 00:10:16.200 00:10:17.919 Nicolas Sucari: yeah, exactly.

87 00:10:18.160 00:10:19.629 Luke Daque: Yeah, but it looks like

88 00:10:20.670 00:10:24.270 Luke Daque: did. Did you just receive the email today? Or something.

89 00:10:24.660 00:10:26.399 Nicolas Sucari: Yeah. Today, 5 am.

90 00:10:27.100 00:10:31.930 Luke Daque: 5 am. Which is like 2 h ago. Let me check

91 00:10:33.106 00:10:42.009 Luke Daque: I can try to refresh the data in 5 Tran, but but so far the so number does not exist in Snowflake yet, so maybe.

92 00:10:42.220 00:10:44.640 Nicolas Sucari: Yeah, because we don’t have that problem over there.

93 00:10:45.160 00:10:52.650 Luke Daque: Yeah, I might need to refresh it manually from 5 transfer now, so that it would show up. But we’ll see.

94 00:10:53.440 00:10:59.910 Nicolas Sucari: But let. But the file is like the new file is there, and we don’t have the column, or we don’t have the file.

95 00:11:00.972 00:11:02.287 Luke Daque: Let me check the file.

96 00:11:08.860 00:11:13.329 Luke Daque: So the file name is Bt. Swim tracker. Report. October 20.

97 00:11:14.880 00:11:17.110 Luke Daque: Best Betty. Swim

98 00:11:18.080 00:11:20.710 Luke Daque: tracking. Report. Nope, it!

99 00:11:21.180 00:11:22.909 Luke Daque: We don’t have the file yet.

100 00:11:23.460 00:11:26.689 Luke Daque: Looks like it’s also named differently. I wonder if this is.

101 00:11:27.750 00:11:28.380 Nicolas Sucari: No, the.

102 00:11:28.380 00:11:28.880 Luke Daque: Manually.

103 00:11:28.880 00:11:31.670 Nicolas Sucari: Name. No, the name that I sent.

104 00:11:32.855 00:11:33.500 Nicolas Sucari: Wait!

105 00:11:33.620 00:11:35.060 Nicolas Sucari: Let me show you if you wanna.

106 00:11:36.220 00:11:36.910 Luke Daque: Yeah.

107 00:11:36.910 00:11:42.309 Nicolas Sucari: The because the name when I download the name when I download the file without

108 00:11:42.640 00:11:46.969 Nicolas Sucari: in in Arc, it changed the name automatically. So don’t

109 00:11:47.480 00:11:51.200 Nicolas Sucari: trust the name that I send on to like the actual name is

110 00:11:51.550 00:11:55.100 Nicolas Sucari: Bt. Swim tracking, tracking number report.

111 00:11:55.680 00:11:58.639 Nicolas Sucari: It’s the same that it that we’ve been receiving

112 00:11:59.570 00:12:00.560 Nicolas Sucari: every week.

113 00:12:02.150 00:12:08.510 Luke Daque: Yeah. So the latest we received was out here in 5. Plan is on the 14.th So

114 00:12:08.700 00:12:11.120 Luke Daque: I guess we haven’t received the one for today.

115 00:12:11.120 00:12:17.510 Nicolas Sucari: Or or maybe it. Yeah, maybe that it didn’t triggered yet, for today I don’t know at what time.

116 00:12:17.710 00:12:18.300 Luke Daque: Yeah.

117 00:12:18.300 00:12:19.459 Nicolas Sucari: Reading just now, of like.

118 00:12:19.660 00:12:24.269 Luke Daque: Yeah, that’s that’s why I’m gonna try to refresh it. In 5 grand.

119 00:12:25.900 00:12:29.120 Luke Daque: this is email

120 00:12:29.860 00:12:33.269 Luke Daque: campaign. Spend versus here.

121 00:12:39.070 00:12:39.910 Nicolas Sucari: It says.

122 00:12:41.140 00:12:42.050 Nicolas Sucari: Yeah.

123 00:12:43.570 00:12:46.309 Luke Daque: Oh, it’s the Google drive one that I

124 00:12:48.410 00:12:49.659 Luke Daque: created it. Yes.

125 00:12:50.240 00:12:54.060 Luke Daque: yeah. The last refresh was 9 h ago. So

126 00:12:54.380 00:12:56.829 Luke Daque: let me refresh it now manually.

127 00:13:22.400 00:13:25.080 Nicolas Sucari: Yeah, we need to add that column in

128 00:13:25.130 00:13:27.980 Nicolas Sucari: the terrible definition on Site Run

129 00:13:29.420 00:13:32.540 Nicolas Sucari: email on that unit shipment database right?

130 00:13:33.130 00:13:33.940 Luke Daque: Yeah.

131 00:13:34.090 00:13:37.380 Luke Daque: it should automatically add it once it

132 00:13:37.760 00:13:39.319 Luke Daque: gets the new.

133 00:13:39.790 00:13:42.819 Luke Daque: Oh, yeah, it looks like it’s so number.

134 00:13:44.330 00:13:45.140 Nicolas Sucari: He’s there.

135 00:13:49.340 00:13:52.850 Luke Daque: Yeah, I just refreshed it. So maybe it’s gonna it’s syncing now.

136 00:13:53.650 00:13:56.169 Luke Daque: But anyway, yeah, well, that’s waiting.

137 00:13:56.850 00:13:59.730 Luke Daque: I can work on that I’ll have to.

138 00:13:59.910 00:14:03.099 Luke Daque: So I guess the data in here, which is

139 00:14:03.660 00:14:07.130 Luke Daque: it looks like it’s the order number right from.

140 00:14:08.000 00:14:08.660 Nicolas Sucari: Yeah.

141 00:14:08.770 00:14:09.569 Nicolas Sucari: from trip 5.

142 00:14:10.295 00:14:11.020 Luke Daque: Shopify?

143 00:14:12.690 00:14:13.660 Luke Daque: Yeah.

144 00:14:13.990 00:14:15.000 Luke Daque: so I can.

145 00:14:15.620 00:14:16.310 Luke Daque: Hmm.

146 00:14:18.540 00:14:22.719 Luke Daque: So the pri tricky part now is like the older orders

147 00:14:22.760 00:14:25.789 Luke Daque: would be coming from po number. But then

148 00:14:26.470 00:14:29.369 Luke Daque: there’s a couple of weeks where it’s blank and we can’t.

149 00:14:30.000 00:14:33.380 Luke Daque: We don’t have anything to join them on.

150 00:14:33.490 00:14:34.700 Luke Daque: And then for the

151 00:14:34.960 00:14:39.210 Luke Daque: for this week, and moving forward. It will be from so number, right.

152 00:14:39.470 00:14:41.439 Nicolas Sucari: Cycling. Yes, yes.

153 00:14:41.770 00:14:43.690 Luke Daque: So that’s pretty tricky.

154 00:14:44.350 00:14:46.279 Luke Daque: I guess the the most.

155 00:14:48.070 00:14:57.570 Luke Daque: Well, I guess I can. I can do that. That’s fine. Between the Po number and the so number. But the I guess the most tricky part is the the weeks where we actually don’t have anything.

156 00:14:59.370 00:15:00.930 Luke Daque: We’ll have to.

157 00:15:01.960 00:15:05.239 Nicolas Sucari: Oh, I can see now the file! Let me check.

158 00:15:06.560 00:15:07.359 Luke Daque: At u ea.

159 00:15:07.360 00:15:08.350 Nicolas Sucari: Po number.

160 00:15:08.750 00:15:10.550 Nicolas Sucari: in snowflake. Yes.

161 00:15:10.550 00:15:12.709 Luke Daque: Oh, so maybe it’s done. Let me check

162 00:15:13.230 00:15:13.860 Luke Daque: see you, Evan.

163 00:15:13.860 00:15:19.099 Nicolas Sucari: Dso, number. Oh, yeah, I can see it at the end now. It’s a new field with the last file.

164 00:15:19.950 00:15:21.970 Luke Daque: So it’s probably done syncing. Let me.

165 00:15:22.580 00:15:22.930 Nicolas Sucari: Yeah.

166 00:15:22.930 00:15:23.960 Luke Daque: Michigan.

167 00:15:27.990 00:15:32.690 Luke Daque: Yep, it looks like the new file is there already, so we should be.

168 00:15:34.020 00:15:35.940 Nicolas Sucari: The new column is at the end.

169 00:15:36.370 00:15:37.949 Luke Daque: It’s not, you know.

170 00:15:42.930 00:15:44.350 Nicolas Sucari: I can share. If you want.

171 00:15:44.350 00:15:47.379 Luke Daque: Yeah, we should have it. We have

172 00:15:48.210 00:15:52.159 Luke Daque: how many? 46 rows of data

173 00:15:52.640 00:15:56.149 Luke Daque: in the file? It’s also 4 to 6. Yep, we should be good.

174 00:15:56.830 00:15:57.630 Nicolas Sucari: Excellent.

175 00:15:59.200 00:16:01.129 Luke Daque: Hi! Cool I can.

176 00:16:01.130 00:16:12.900 Nicolas Sucari: Yeah, that’s what we will need to do. We need to use the po number from the previous ones. Then we have, like, some part that is empty. We don’t have either po number or so number. That’s where we need to backfill

177 00:16:13.473 00:16:19.799 Nicolas Sucari: and then we have the the starting from this week, the East so number that we need to keep

178 00:16:20.178 00:16:32.339 Nicolas Sucari: and we need to match like those 3 different things in order to backfill. What do you? What do you prefer like? We need to ask you needs to send us like a custom report, and we can do it manually. Or is there any other way that you

179 00:16:32.390 00:16:33.609 Nicolas Sucari: do? You prefer.

180 00:16:40.680 00:16:44.989 Nicolas Sucari: like I I what would be the easiest? Them to send us?

181 00:16:46.173 00:16:47.420 Nicolas Sucari: A report.

182 00:16:49.010 00:16:54.969 Luke Daque: Yeah, maybe that’s the easiest. We just let them send us a report. We’ll put that in 5 Tran, and then we’ll

183 00:16:55.100 00:16:57.517 Luke Daque: use that to populate the missing

184 00:16:58.070 00:16:59.140 Luke Daque: data.

185 00:17:00.900 00:17:01.420 Nicolas Sucari: Okay.

186 00:17:01.420 00:17:02.890 Luke Daque: Even if it’s just

187 00:17:03.810 00:17:08.399 Luke Daque: well, I guess it should be same the same with this right or something.

188 00:17:10.930 00:17:11.819 Nicolas Sucari: Let me.

189 00:17:11.930 00:17:14.100 Nicolas Sucari: So if this is already there.

190 00:17:14.150 00:17:16.179 Nicolas Sucari: Oh, no, okay. Now we need to do that.

191 00:17:16.180 00:17:21.760 Luke Daque: Or just even order id, and and so number would be fine. Then.

192 00:17:22.410 00:17:22.815 Luke Daque: like

193 00:17:23.220 00:17:23.859 Nicolas Sucari: Okay.

194 00:17:24.170 00:17:26.639 Luke Daque: The the Unis order Id

195 00:17:27.760 00:17:33.429 Luke Daque: and the second column would be the shopify order number, or the so number. In this case.

196 00:17:34.110 00:17:35.560 Luke Daque: right? Okay.

197 00:17:36.670 00:17:40.900 Nicolas Sucari: So what? Yeah, okay, so we’ll need to create like, the

198 00:17:42.550 00:17:44.449 Luke Daque: It’s like a mapping file or something.

199 00:17:44.450 00:17:47.050 Nicolas Sucari: Yeah, something like that. Exactly.

200 00:17:47.660 00:17:54.170 Nicolas Sucari: Okay. And once that is ready, or until they send us that, we can start working on

201 00:17:54.530 00:17:57.800 Nicolas Sucari: getting those that new field

202 00:17:57.900 00:17:59.880 Nicolas Sucari: to also

203 00:18:00.160 00:18:05.579 Nicolas Sucari: not not be visible in real. But we need to match po number and so number, so that we have like the same.

204 00:18:07.200 00:18:13.720 Nicolas Sucari: I don’t know the information into one dimension in real, so that we can see those new orders

205 00:18:13.820 00:18:16.189 Nicolas Sucari: in the shipments. App dashboard right.

206 00:18:16.190 00:18:16.990 Luke Daque: Right.

207 00:18:17.720 00:18:18.340 Luke Daque: Yep.

208 00:18:18.340 00:18:19.000 Nicolas Sucari: Okay.

209 00:18:19.120 00:18:22.549 Nicolas Sucari: I’ll I’ll let you decide how to do all of that.

210 00:18:23.180 00:18:23.555 Luke Daque: Okay.

211 00:18:24.370 00:18:29.759 Nicolas Sucari: That’s cool. Okay, I’ll I’ll send that email to Eunice trying to ask for that

212 00:18:29.900 00:18:30.650 Nicolas Sucari: past week.

213 00:18:30.650 00:18:31.350 Luke Daque: That’s good.

214 00:18:31.770 00:18:36.819 Nicolas Sucari: Data. And yeah, and I don’t know if we have anything else with Eunice.

215 00:18:37.220 00:18:39.010 Nicolas Sucari: That should be. It.

216 00:18:39.930 00:18:40.720 Luke Daque: Yeah.

217 00:18:41.740 00:18:42.295 Luke Daque: Okay.

218 00:18:43.020 00:18:47.416 Luke Daque: yeah. The other thing that I was thinking of maybe working on was the

219 00:18:48.500 00:18:52.899 Luke Daque: like, remember, I, I created the dummy data for

220 00:18:54.213 00:18:55.520 Luke Daque: the quoting.

221 00:18:56.180 00:18:56.530 Nicolas Sucari: Yeah.

222 00:18:56.530 00:19:04.560 Luke Daque: For the real. Maybe if I don’t have if I have, if I have like, if I’m done with this unit and any other stuff. I can

223 00:19:04.780 00:19:10.129 Luke Daque: start working on the dummy data for the other as well.

224 00:19:10.130 00:19:16.300 Nicolas Sucari: We? We have that one. Yeah. Once we finish the units, we need to check those those bt.

225 00:19:16.450 00:19:17.640 Nicolas Sucari: and.

226 00:19:17.640 00:19:18.250 Luke Daque: Yeah.

227 00:19:18.250 00:19:19.180 Nicolas Sucari: The message that I.

228 00:19:19.180 00:19:20.539 Luke Daque: One from chuck. Yeah.

229 00:19:20.540 00:19:21.220 Nicolas Sucari: Yeah.

230 00:19:21.420 00:19:27.529 Nicolas Sucari: we need to check that. Why we are not getting that that skews imported into a list.

231 00:19:28.140 00:19:28.460 Luke Daque: Right.

232 00:19:28.460 00:19:30.689 Nicolas Sucari: Then, yeah, we can move into any other.

233 00:19:32.160 00:19:35.169 Nicolas Sucari: any other data dummy data that we need to prepare. I think.

234 00:19:35.350 00:19:36.176 Luke Daque: Sounds good.

235 00:19:37.000 00:19:37.790 Nicolas Sucari: Excellent

236 00:19:39.740 00:19:43.319 Nicolas Sucari: cool. Thanks, Ryan. Let’s talk if you need anything. Okay.

237 00:19:43.490 00:19:45.820 Luke Daque: Yeah, sounds good. Thanks. See you later.

238 00:19:45.820 00:19:46.540 Nicolas Sucari: Bye, bye.

239 00:19:46.540 00:19:47.230 Luke Daque: Bye, bye.