Meeting Title: AE-Planning-Session Date: 2024-09-09 Meeting participants: Ryan Luke Daque, Nicolas Sucari


WEBVTT

1 00:03:40.810 00:03:41.709 Nicolas Sucari: I ran.

2 00:03:42.060 00:03:42.979 Nicolas Sucari: are you.

3 00:03:43.220 00:03:44.830 Ryan Luke Daque: Hi, Nicholas, how’s it going

4 00:03:45.880 00:03:46.550 Ryan Luke Daque: doing? Well.

5 00:03:46.550 00:03:47.860 Nicolas Sucari: All good. How

6 00:03:48.250 00:03:50.100 Nicolas Sucari: excellent! How was your weekend.

7 00:03:50.750 00:03:53.150 Ryan Luke Daque: Yeah, it was pretty fine. Nothing

8 00:03:53.700 00:03:56.480 Ryan Luke Daque: special. But yeah, it’s cool.

9 00:03:57.550 00:03:58.690 Nicolas Sucari: That’s great.

10 00:04:02.230 00:04:03.250 Nicolas Sucari: Excellent!

11 00:04:04.520 00:04:05.000 Ryan Luke Daque: You had a lot.

12 00:04:05.000 00:04:06.539 Nicolas Sucari: Good. I went to the

13 00:04:06.900 00:04:10.840 Nicolas Sucari: yeah. I wasn’t working. On Friday. I went to the mountain here in

14 00:04:10.990 00:04:13.820 Nicolas Sucari: Argentina, bona, Rcd.

15 00:04:13.910 00:04:15.999 Nicolas Sucari: And they went skiing 3 days.

16 00:04:16.000 00:04:18.079 Ryan Luke Daque: Oh, wow! That’s cool!

17 00:04:19.260 00:04:28.119 Nicolas Sucari: Yeah, it’s nice. It was. It was awesome because it it snowed on Thursday so then Friday.

18 00:04:28.270 00:04:32.340 Nicolas Sucari: Saturday and Sunday was amazing snow, and it was

19 00:04:32.700 00:04:37.650 Nicolas Sucari: all sunny. So yeah, it was like, optimal conditions.

20 00:04:41.100 00:04:42.140 Nicolas Sucari: really, fun.

21 00:04:42.630 00:04:44.499 Ryan Luke Daque: Yeah, that’s cool. Nice.

22 00:04:46.950 00:05:01.019 Nicolas Sucari: Yeah. Okay. So I don’t know if Adam’s gonna join. I think he has our meeting right now. But we were talking about pool parts before. I don’t know if you’re working on anything right now

23 00:05:01.660 00:05:05.920 Nicolas Sucari: about ballparks. You were checking about some

24 00:05:06.050 00:05:08.029 Nicolas Sucari: flow failures right.

25 00:05:09.070 00:05:18.050 Ryan Luke Daque: Yeah. Well, the real refresh flow failure. Well, the intraday dbt, is doing well. So there’s no failure there which is a good thing it’s been

26 00:05:18.656 00:05:23.160 Ryan Luke Daque: going well for a while now, without any failures. So that’s cool.

27 00:05:23.240 00:05:28.800 Ryan Luke Daque: The real refreshes. Yeah. I tried working on that last week, but I haven’t really.

28 00:05:29.393 00:05:34.859 Ryan Luke Daque: I figured out a way to fix it. So I’m I’m trying to ask for help from Patrick. He’s like

29 00:05:34.910 00:05:38.979 Ryan Luke Daque: more experienced in workflows, so maybe he will be able to fit.

30 00:05:38.980 00:05:39.740 Nicolas Sucari: This.

31 00:05:40.434 00:05:44.139 Ryan Luke Daque: The other thing I’m working on is I’m trying to test the chat

32 00:05:44.160 00:05:48.231 Ryan Luke Daque: gpt, or like openai integration to our workflows.

33 00:05:48.970 00:05:52.754 Ryan Luke Daque: so it would do like code review. And then, as well as

34 00:05:53.780 00:05:55.199 Ryan Luke Daque: what do you call this

35 00:05:55.370 00:05:56.050 Ryan Luke Daque: like

36 00:05:56.350 00:05:57.650 Ryan Luke Daque: trying to figure out

37 00:05:58.570 00:06:03.950 Ryan Luke Daque: if the workflow fails like, if there’s any quick fix to any workflow failure. So so.

38 00:06:03.950 00:06:04.370 Nicolas Sucari: Okay.

39 00:06:04.370 00:06:05.250 Ryan Luke Daque: That one.

40 00:06:05.650 00:06:11.410 Ryan Luke Daque: And then, yeah, like like, I mentioned last week, I was gonna also work on

41 00:06:11.500 00:06:15.930 Ryan Luke Daque: looking into the Google Ads and Facebook Ads revenue and try to see if we can.

42 00:06:17.530 00:06:19.350 Ryan Luke Daque: add those for the

43 00:06:20.290 00:06:22.210 Ryan Luke Daque: the app level. Yeah.

44 00:06:23.160 00:06:39.709 Nicolas Sucari: I think. We need to work on that this week so that we can send something to Kim because it’s been yeah. Now like 2 or 3 weeks that we were talking about that. So if you can check Facebook and Google and see if we can add that it would be great

45 00:06:41.190 00:06:48.140 Nicolas Sucari: and then maybe I don’t know if Raj is gonna be. Maybe he’s gonna be working today tomorrow.

46 00:06:48.260 00:06:48.750 Ryan Luke Daque: Okay.

47 00:06:48.750 00:07:01.410 Nicolas Sucari: To Wednesday. I I don’t know. I’m I’m not sure about that. Like put on needs to have a conversation with him. Try to understand when he’s available and not so that we can rely on him on working on

48 00:07:01.530 00:07:17.865 Nicolas Sucari: on this kind of stuff. And if not, we are, gonna handle it. I can. Yeah, I will start looking into some dashboards and see what we need to to work on. And I’m gonna ask you about the modeling and having the data ready to to do that.

49 00:07:18.720 00:07:20.980 Nicolas Sucari: so that we can both handle

50 00:07:21.080 00:07:23.510 Nicolas Sucari: anything regarding Walmarts.

51 00:07:24.330 00:07:48.260 Nicolas Sucari: but yeah, may may this week if we can finish up that Facebook and Google stuff for Kim. Let’s see if we can do that. And then we can add that to the report. See how that works. And also I’ll be preparing a new task. Well, not a new task. But we we already have it there about creating new dashboard to compare the different warehouses so that we can create something for chuck

52 00:07:48.714 00:07:54.930 Nicolas Sucari: that he that he relies on when understanding how each warehouse is performing. Okay.

53 00:07:54.930 00:07:55.500 Ryan Luke Daque: Okay.

54 00:07:55.700 00:07:56.799 Ryan Luke Daque: sounds good. I think.

55 00:07:56.800 00:08:05.739 Nicolas Sucari: We have. Yeah, I think we have all of the information for that one. It’s just like, bringing the different parts into a same

56 00:08:05.860 00:08:08.179 Nicolas Sucari: query. And then.

57 00:08:08.721 00:08:19.389 Nicolas Sucari: yeah, creating the dashboard. Because, we have everything on shipments. And yeah, I think if we combine some stuff from shipments with orders. We’ll have everything right.

58 00:08:20.400 00:08:21.559 Ryan Luke Daque: Yeah, sounds good.

59 00:08:23.340 00:08:29.789 Nicolas Sucari: Perfect. Yeah. So that’s like the the 2 things that I want to work on this week. Try to have

60 00:08:29.810 00:08:36.479 Nicolas Sucari: that warehouse comparison or check. And yeah, and to try finish the conversion starts with

61 00:08:36.900 00:08:49.069 Nicolas Sucari: with Kim about post pilot, they answered. And they added a new date. So maybe in the Conversions List report that we are getting. We have, like all the necessary information.

62 00:08:49.639 00:08:53.430 Nicolas Sucari: To to get the conversions for each of the campaigns

63 00:08:53.800 00:08:55.819 Nicolas Sucari: by at level, I think.

64 00:08:57.040 00:09:04.509 Nicolas Sucari: and then that’s for payment for how’s it? Sorry for direct email. So maybe that source is like

65 00:09:04.850 00:09:09.760 Nicolas Sucari: solved by now, we need to focus on Facebook and Google, maybe.

66 00:09:10.620 00:09:11.770 Ryan Luke Daque: Gotcha.

67 00:09:12.150 00:09:14.580 Nicolas Sucari: Well, Facebook, Google and Amazon, I think, yeah.

68 00:09:14.980 00:09:17.049 Ryan Luke Daque: I see? Yeah, okay.

69 00:09:18.967 00:09:32.539 Nicolas Sucari: And then on our stuff. Today, we received the Unis email with the shipment, and there are new 2 warehouses there. I can see there are some orders shipped from

70 00:09:32.550 00:09:35.000 Nicolas Sucari: California and some from Texas.

71 00:09:35.060 00:09:36.200 Nicolas Sucari: So

72 00:09:36.420 00:09:43.400 Nicolas Sucari: we need to. Yeah, now, that’s getting into real directly or automatically, or we need to do some manual stuff.

73 00:09:47.020 00:09:48.270 Ryan Luke Daque: Ed, can you say that again.

74 00:09:49.360 00:09:53.309 Nicolas Sucari: Yeah, we received the wise email with the

75 00:09:53.360 00:09:55.289 Nicolas Sucari: new shipments from Unis.

76 00:09:55.310 00:09:56.570 Nicolas Sucari: Oh, and I can see, like.

77 00:09:56.570 00:09:56.890 Ryan Luke Daque: We.

78 00:09:56.890 00:09:59.829 Nicolas Sucari: We have. We have the new facilities in there. Yeah.

79 00:09:59.830 00:10:03.610 Ryan Luke Daque: I haven’t checked. Let me let me check that real quick.

80 00:10:05.140 00:10:05.710 Nicolas Sucari: So.

81 00:10:05.710 00:10:06.030 Ryan Luke Daque: If.

82 00:10:06.030 00:10:10.349 Nicolas Sucari: Goes automatically into snowflake, or we need to do something manually.

83 00:10:11.940 00:10:17.670 Ryan Luke Daque: So let’s see what time this got sent an hour ago, or like.

84 00:10:19.410 00:10:23.060 Nicolas Sucari: So Utam Utam forwarded forward it to us. But

85 00:10:23.180 00:10:23.850 Nicolas Sucari: yeah.

86 00:10:23.850 00:10:24.570 Ryan Luke Daque: Think I saw.

87 00:10:24.570 00:10:31.409 Nicolas Sucari: We don’t forward it to us an hour ago. But yeah, the we get the automatic. Yeah.

88 00:10:31.410 00:10:37.091 Ryan Luke Daque: Check. 5. Yeah, it should be going into Snowflake as soon as 5 tran

89 00:10:38.000 00:10:44.039 Ryan Luke Daque: the the run. The the connector runs in 5 Tran, which is I I forgot, like how often it

90 00:10:44.640 00:10:49.959 Ryan Luke Daque: it does that I think it was being done daily. But let me double check here.

91 00:10:51.054 00:10:52.745 Ryan Luke Daque: Okay, what’s this?

92 00:10:53.480 00:10:55.139 Ryan Luke Daque: A Eunice

93 00:10:55.840 00:11:04.290 Ryan Luke Daque: voice tracking report? So, yeah, this was synced 3 h ago. So it should now be in Snowflake. We can check it out real quick if you want.

94 00:11:09.790 00:11:12.640 Ryan Luke Daque: So the carrier, are you saying the carrier?

95 00:11:12.950 00:11:17.269 Ryan Luke Daque: Oh, it’s the facility, right, Alessandro, and row row one. Okay.

96 00:11:18.740 00:11:21.729 Ryan Luke Daque: So I suppose Alessandro is

97 00:11:22.340 00:11:23.800 Ryan Luke Daque: ups oh.

98 00:11:24.500 00:11:26.520 Ryan Luke Daque: or like, how how do you know which?

99 00:11:29.131 00:11:32.240 Ryan Luke Daque: Which shipping city this is?

100 00:11:35.450 00:11:36.330 Ryan Luke Daque: Hello!

101 00:11:39.270 00:11:40.694 Nicolas Sucari: Sorry I was on mute

102 00:11:40.980 00:11:42.280 Ryan Luke Daque: Sorry.

103 00:11:42.680 00:11:45.879 Nicolas Sucari: Yeah, I think Alessandra is California one and.

104 00:11:46.080 00:11:46.860 Ryan Luke Daque: I see.

105 00:11:47.170 00:11:49.938 Nicolas Sucari: Roanoke is the one in Dallas.

106 00:11:50.400 00:11:51.180 Ryan Luke Daque: Okay. Sounds.

107 00:11:51.180 00:11:52.110 Nicolas Sucari: Let me check.

108 00:11:52.700 00:11:55.879 Ryan Luke Daque: Yeah, let me share my screen so we can, we can check it

109 00:11:56.340 00:11:57.050 Ryan Luke Daque: both.

110 00:11:58.910 00:12:02.810 Ryan Luke Daque: So yeah, I was looking at. So it looks like, so the

111 00:12:03.090 00:12:10.259 Ryan Luke Daque: since utam forward. This forwarded this to us again, so looks like I received 2 of the same

112 00:12:10.750 00:12:11.620 Ryan Luke Daque: files.

113 00:12:11.620 00:12:14.959 Nicolas Sucari: No, because 1 1. You received it by the.

114 00:12:14.960 00:12:16.060 Ryan Luke Daque: Right. Nope.

115 00:12:16.060 00:12:20.159 Nicolas Sucari: The group email and the other one put on forward it. Okay.

116 00:12:20.160 00:12:21.359 Ryan Luke Daque: Right. So I always.

117 00:12:21.360 00:12:22.100 Nicolas Sucari: And gate.

118 00:12:22.460 00:12:26.180 Ryan Luke Daque: That’s going to be a duplicate which is going to be.

119 00:12:26.250 00:12:28.869 Ryan Luke Daque: I’m not sure if that’s gonna be a problem. But

120 00:12:29.660 00:12:32.282 Ryan Luke Daque: cause I think I already did.

121 00:12:34.590 00:12:37.650 Ryan Luke Daque: I did have a deduplication in

122 00:12:37.930 00:12:39.800 Ryan Luke Daque: in the staging model, but.

123 00:12:40.550 00:12:41.270 Nicolas Sucari: Okay.

124 00:12:41.400 00:12:41.990 Nicolas Sucari: But.

125 00:12:41.990 00:12:45.500 Ryan Luke Daque: And for the raw file. Yeah, it looks like, I wait.

126 00:12:46.150 00:12:48.679 Ryan Luke Daque: Yeah, there’s 2 of these.

127 00:12:49.190 00:12:52.820 Ryan Luke Daque: So this would be loaded twice in snowflake

128 00:12:54.675 00:12:56.899 Ryan Luke Daque: but it looks like the

129 00:12:57.330 00:12:59.550 Ryan Luke Daque: the 5 Tran

130 00:12:59.930 00:13:01.240 Ryan Luke Daque: pipeline. Yeah.

131 00:13:02.600 00:13:05.540 Ryan Luke Daque: what was last seen 3 h ago. So it

132 00:13:05.840 00:13:07.210 Ryan Luke Daque: so this means the one.

133 00:13:07.210 00:13:07.639 Nicolas Sucari: So that.

134 00:13:07.640 00:13:13.009 Ryan Luke Daque: Utahm sent did not get into 5 grand yet, so I can probably delete this.

135 00:13:13.360 00:13:16.039 Ryan Luke Daque: so it won’t get duplicated.

136 00:13:17.360 00:13:20.280 Ryan Luke Daque: Yep. So I removed the one that autumn sent.

137 00:13:22.148 00:13:24.940 Ryan Luke Daque: So this is the Google drive, the Google.

138 00:13:24.940 00:13:25.470 Nicolas Sucari: Yeah.

139 00:13:25.470 00:13:29.400 Ryan Luke Daque: Drive folder. By the way, where the files get sent to?

140 00:13:30.136 00:13:32.840 Ryan Luke Daque: So yeah. So if we check here.

141 00:13:36.970 00:13:38.490 Ryan Luke Daque: you should see them

142 00:13:39.590 00:13:41.280 Ryan Luke Daque: based on

143 00:13:48.170 00:13:49.550 Ryan Luke Daque: what we

144 00:13:52.110 00:13:54.170 Ryan Luke Daque: based on, like the the

145 00:13:54.420 00:13:56.870 Ryan Luke Daque: file that was sent 3 h ago.

146 00:13:57.720 00:13:59.659 Ryan Luke Daque: So I guess we can check

147 00:13:59.770 00:14:00.800 Ryan Luke Daque: this one.

148 00:14:03.190 00:14:07.409 Ryan Luke Daque: Yeah, that’s it. Well, this one is September 3.

149 00:14:16.280 00:14:18.040 Ryan Luke Daque: It doesn’t look like

150 00:14:19.430 00:14:21.039 Ryan Luke Daque: we got anything

151 00:14:21.660 00:14:22.420 Ryan Luke Daque: yet.

152 00:14:24.750 00:14:25.450 Ryan Luke Daque: Hmm.

153 00:14:34.100 00:14:37.139 Nicolas Sucari: In the shipments table. I’m not seeing it also. So.

154 00:14:39.837 00:14:41.690 Ryan Luke Daque: Wait a minute.

155 00:14:48.780 00:14:49.620 Ryan Luke Daque: By

156 00:14:54.290 00:14:57.290 Ryan Luke Daque: yeah, the the latest one we got is the

157 00:14:57.440 00:15:00.069 Ryan Luke Daque: September 2. So let me try to

158 00:15:01.990 00:15:04.900 Ryan Luke Daque: wait. There’s a Mal informed file.

159 00:15:05.510 00:15:08.429 Ryan Luke Daque: So there’s an error actually in Snowflake.

160 00:15:09.070 00:15:10.810 Ryan Luke Daque: The error.

161 00:15:17.300 00:15:19.240 Ryan Luke Daque: So there’s 2 errors, one

162 00:15:19.510 00:15:23.450 Ryan Luke Daque: from the September 2, file and one from the September

163 00:15:24.180 00:15:25.790 Ryan Luke Daque: 9. 5.

164 00:15:26.750 00:15:28.389 Ryan Luke Daque: Not sure why this

165 00:15:28.680 00:15:30.620 Ryan Luke Daque: going into an error?

166 00:15:36.520 00:15:40.260 Ryan Luke Daque: Yeah, I’ll I’ll look into this cause it looks like this.

167 00:15:40.260 00:15:41.000 Nicolas Sucari: Okay.

168 00:15:41.260 00:15:42.419 Ryan Luke Daque: To errors.

169 00:15:43.960 00:15:46.520 Ryan Luke Daque: It doesn’t look like 5. Grand was able to

170 00:15:47.670 00:15:48.620 Ryan Luke Daque: read

171 00:15:48.870 00:15:52.640 Ryan Luke Daque: these latest 2 files for some reason.

172 00:15:54.450 00:15:56.640 Ryan Luke Daque: But yeah, I’ll look into this?

173 00:15:57.590 00:15:58.980 Ryan Luke Daque: Not sure? Why.

174 00:16:02.430 00:16:03.415 Ryan Luke Daque: yeah,

175 00:16:04.440 00:16:05.550 Ryan Luke Daque: yeah, I can

176 00:16:05.680 00:16:07.010 Ryan Luke Daque: probably

177 00:16:07.300 00:16:09.849 Ryan Luke Daque: prioritize this one today. And then.

178 00:16:10.040 00:16:14.359 Ryan Luke Daque: once this is fixed, I can start working on the Google ads and Facebook ads. One

179 00:16:14.510 00:16:19.459 Ryan Luke Daque: cause, I believe the like this one. Isn’t that important? The real refresh one

180 00:16:19.820 00:16:20.540 Ryan Luke Daque: and.

181 00:16:20.540 00:16:24.209 Nicolas Sucari: Okay, what is the real refreshment? What is about.

182 00:16:25.250 00:16:30.269 Ryan Luke Daque: Well, from what I understand, it’s just a a workflow that refreshes the real sources.

183 00:16:32.180 00:16:33.290 Ryan Luke Daque: on a cronja.

184 00:16:33.585 00:16:33.880 Nicolas Sucari: Okay.

185 00:16:34.570 00:16:35.950 Ryan Luke Daque: Every every

186 00:16:36.170 00:16:37.430 Ryan Luke Daque: few hours

187 00:16:38.254 00:16:42.369 Ryan Luke Daque: it was Udam that created this. And it’s still failing until now. So yeah.

188 00:16:42.900 00:16:44.229 Ryan Luke Daque: it’s not really that.

189 00:16:44.230 00:16:44.760 Nicolas Sucari: But yeah.

190 00:16:46.200 00:16:47.609 Nicolas Sucari: figure out how to.

191 00:16:48.050 00:16:50.820 Nicolas Sucari: Yeah, that’s okay. Let’s figure out how to

192 00:16:51.120 00:16:57.200 Nicolas Sucari: get those those new orders into a shipment table, and then let’s go with the

193 00:16:57.240 00:17:00.849 Nicolas Sucari: marketing stuff, and then we come back to this one. Okay, to read.

194 00:17:00.950 00:17:01.660 Nicolas Sucari: Yep. Sounds.

195 00:17:01.660 00:17:02.310 Ryan Luke Daque: It’s been.

196 00:17:03.740 00:17:09.710 Nicolas Sucari: Perfect. Let me know if I can help on anything. I’m still trying to get in contact with the 0

197 00:17:10.228 00:17:17.040 Nicolas Sucari: support team so that they can help us work on the tax mapping stuff that it’s going on.

198 00:17:17.050 00:17:24.369 Nicolas Sucari: And because they talked with the unleashed people, and they they are bringing that information from 0. So we are gonna keep

199 00:17:24.430 00:17:25.710 Nicolas Sucari: asking about that.

200 00:17:25.940 00:17:26.740 Ryan Luke Daque: Okay.

201 00:17:29.350 00:17:29.670 Nicolas Sucari: Exactly.

202 00:17:29.670 00:17:30.390 Ryan Luke Daque: Said, okay.

203 00:17:30.390 00:17:33.269 Nicolas Sucari: Well, thanks, Ryan, let’s talk later. If you want.

204 00:17:33.520 00:17:36.969 Ryan Luke Daque: Sure sounds good. Thanks, Nicholas. Have a nice rest of your day.

205 00:17:36.970 00:17:37.580 Nicolas Sucari: Bye.

206 00:17:37.700 00:17:38.210 Nicolas Sucari: bye, bye.