Meeting Title: Zoom Meeting Date: 2024-10-10 Meeting participants: Nicolas Sucari, Ryan Luke Daque


WEBVTT

1 00:00:16.600 00:00:17.260 Ryan Luke Daque: Hello!

2 00:00:19.460 00:00:20.520 Ryan Luke Daque: Hey, Ryan.

3 00:00:21.190 00:00:21.460 Nicolas Sucari: How are you?

4 00:00:21.759 00:00:22.059 Ryan Luke Daque: Shit

5 00:00:22.590 00:00:24.400 Ryan Luke Daque: doing well doing? Well.

6 00:00:26.760 00:00:31.609 Ryan Luke Daque: Yeah, let me share my screen so we can start.

7 00:00:33.260 00:00:33.890 Nicolas Sucari: Okay.

8 00:00:37.110 00:00:39.400 Ryan Luke Daque: There you go. Can you see my screen.

9 00:00:39.740 00:00:40.650 Nicolas Sucari: Yes.

10 00:00:42.230 00:00:43.330 Ryan Luke Daque: yeah. So

11 00:00:44.540 00:00:50.939 Ryan Luke Daque: where do I start here? So basically based on the conversation we had? I mean

12 00:00:51.010 00:00:53.320 Ryan Luke Daque: Patrick and the real.

13 00:00:53.320 00:00:54.000 Nicolas Sucari: Yeah.

14 00:00:54.830 00:00:56.450 Ryan Luke Daque: Like here. Even here.

15 00:00:56.919 00:01:00.870 Ryan Luke Daque: Patrick did mention he did load. He was loading

16 00:01:00.930 00:01:05.940 Ryan Luke Daque: the Fdc. Auction prod, and the Fdc. Dsp. Prod

17 00:01:06.430 00:01:07.610 Ryan Luke Daque: tables.

18 00:01:07.610 00:01:08.200 Nicolas Sucari: Yeah.

19 00:01:08.648 00:01:15.370 Ryan Luke Daque: So which is based on the documentation. It’s these 2 that the 2 main tables.

20 00:01:15.370 00:01:16.899 Nicolas Sucari: Yeah. The main tables. Okay?

21 00:01:16.900 00:01:25.460 Ryan Luke Daque: Yeah. But I think he might need to add these as well the reference tables, because these are what’s being used for the joins.

22 00:01:26.485 00:01:27.955 Ryan Luke Daque: Here, like

23 00:01:28.850 00:01:37.490 Nicolas Sucari: But but these dimensions are not in those tables. I mean those main tables are not created in base. With with the other reference tables.

24 00:01:37.760 00:01:42.520 Nicolas Sucari: I thought the reference tables were just to look for more information for those

25 00:01:42.550 00:01:43.720 Nicolas Sucari: higher stuff.

26 00:01:43.730 00:01:48.310 Nicolas Sucari: But if you go to the main tables, what are the columns that you have there. For example.

27 00:01:48.560 00:01:50.599 Ryan Luke Daque: Yeah, sure, let’s check.

28 00:01:51.110 00:01:55.680 Ryan Luke Daque: So, yeah, these are the main tables like, this is one of them. Fd.

29 00:01:55.680 00:01:56.880 Nicolas Sucari: Yeah, let’s go with that option.

30 00:01:56.880 00:01:57.580 Ryan Luke Daque: Front.

31 00:01:59.170 00:02:01.050 Ryan Luke Daque: It’s loading.

32 00:02:04.470 00:02:06.410 Ryan Luke Daque: Yeah, I’m not sure why it’s loading.

33 00:02:08.830 00:02:11.429 Ryan Luke Daque: But yeah, we should be able to see it here.

34 00:02:12.328 00:02:14.420 Ryan Luke Daque: But it’s just loading for now.

35 00:02:14.420 00:02:18.470 Nicolas Sucari: If you, if you, if you click on sources there like the source.

36 00:02:18.980 00:02:21.179 Ryan Luke Daque: Here you go. Yeah, you can see they have the

37 00:02:21.380 00:02:24.690 Ryan Luke Daque: cool. So there’s our occurred. So.

38 00:02:25.110 00:02:28.639 Nicolas Sucari: Yeah, exactly. So. I think that are already the tables that I mentioned.

39 00:02:28.640 00:02:31.909 Ryan Luke Daque: Yeah, the the dimensions. Yes, that’s correct.

40 00:02:33.640 00:02:38.069 Nicolas Sucari: So yeah, so you don’t need the reference tables like loaded there, I think.

41 00:02:39.040 00:02:41.144 Ryan Luke Daque: But here it says,

42 00:02:46.910 00:02:51.280 Ryan Luke Daque: yeah. I wonder what this means? Like it, it says, join to table

43 00:02:51.650 00:02:54.880 Ryan Luke Daque: this one that they might dial them dimensions.

44 00:02:58.290 00:03:02.359 Nicolas Sucari: But yeah, but they they want to show like the add unit. There. Right?

45 00:03:02.400 00:03:06.869 Nicolas Sucari: Let’s go to the table and see if we have there the add units. Already there.

46 00:03:07.100 00:03:11.689 Ryan Luke Daque: Yeah, I think we should have. Yeah, this one add unit, Id.

47 00:03:12.060 00:03:13.550 Ryan Luke Daque: which is this.

48 00:03:14.560 00:03:15.850 Nicolas Sucari: So I think

49 00:03:16.010 00:03:18.079 Nicolas Sucari: like what? What we only need

50 00:03:18.310 00:03:21.970 Nicolas Sucari: I don’t know. I I think we only need to work on yet. That

51 00:03:22.120 00:03:29.240 Nicolas Sucari: last column that you have there like showing dashboard. If we already have the the dimension and the metrics ready in those tables.

52 00:03:29.540 00:03:34.810 Nicolas Sucari: maybe we can just create the dashboard with that dimensions and metrics, and see if that is what they are asking.

53 00:03:36.910 00:03:37.644 Ryan Luke Daque: Okay.

54 00:03:38.380 00:03:42.159 Nicolas Sucari: You see, I think you have all of the columns there right.

55 00:03:43.350 00:03:44.960 Ryan Luke Daque: Yeah, it looks like it.

56 00:03:46.560 00:03:53.659 Ryan Luke Daque: Yeah. In that case, then maybe we can directly create a dashboard. For example, like, we.

57 00:03:53.660 00:03:56.189 Nicolas Sucari: I don’t know if some of the metrics will need some

58 00:03:56.540 00:03:58.519 Nicolas Sucari: like specific modeling.

59 00:03:58.640 00:04:00.469 Nicolas Sucari: but I don’t. I don’t think so right.

60 00:04:00.960 00:04:04.790 Nicolas Sucari: I think it’s just naming conventions and anything else right?

61 00:04:08.890 00:04:11.320 Ryan Luke Daque: Yeah, it doesn’t look like it.

62 00:04:12.010 00:04:12.760 Ryan Luke Daque: Yep.

63 00:04:17.010 00:04:18.157 Ryan Luke Daque: I wonder if

64 00:04:21.890 00:04:25.429 Ryan Luke Daque: they didn’t have the the what do you call this?

65 00:04:25.940 00:04:28.759 Ryan Luke Daque: The dashboard name, so I guess we can just name it.

66 00:04:28.760 00:04:32.410 Nicolas Sucari: Yeah, yeah, mean, like the main tables. Yeah.

67 00:04:32.900 00:04:38.029 Nicolas Sucari: So we we need to have like 2 different, 2 dashboards, one that one and one the other one.

68 00:04:38.260 00:04:39.880 Ryan Luke Daque: Yeah, we’ll just name it.

69 00:04:39.920 00:04:43.630 Ryan Luke Daque: Fdc, prod underscore dashboard, I guess.

70 00:04:44.710 00:04:45.400 Ryan Luke Daque: Yeah.

71 00:04:45.400 00:04:46.030 Nicolas Sucari: That’s fine!

72 00:04:49.140 00:04:49.980 Ryan Luke Daque: Okay.

73 00:04:54.590 00:04:57.400 Ryan Luke Daque: yeah, let’s try that. So I.

74 00:04:58.460 00:05:02.340 Ryan Luke Daque: So this is not it yet. But I, we should have data here.

75 00:05:02.500 00:05:03.510 Ryan Luke Daque: They just

76 00:05:03.620 00:05:04.290 Ryan Luke Daque: it.

77 00:05:04.290 00:05:05.020 Nicolas Sucari: Yeah.

78 00:05:05.020 00:05:11.079 Ryan Luke Daque: I can. Yeah, I’ll have to like, rename this stuff and change the metrics to like. Based on this one

79 00:05:11.840 00:05:13.759 Ryan Luke Daque: number of options and stuff. Yeah.

80 00:05:13.760 00:05:18.919 Nicolas Sucari: Yeah, I think that is like the only thing that they were asking for us, because they gave us all of the data and.

81 00:05:19.060 00:05:19.520 Ryan Luke Daque: Hmm.

82 00:05:19.520 00:05:20.470 Nicolas Sucari: Yeah, it was true.

83 00:05:20.470 00:05:21.230 Ryan Luke Daque: Okay.

84 00:05:21.770 00:05:23.570 Ryan Luke Daque: Sounds good. Then.

85 00:05:23.570 00:05:29.259 Nicolas Sucari: Let’s let’s try doing that. And maybe we can ping see it once we have that ready in that channel

86 00:05:29.490 00:05:31.969 Nicolas Sucari: and see if that’s what? What we.

87 00:05:32.750 00:05:34.908 Nicolas Sucari: what they are looking for.

88 00:05:35.540 00:05:37.820 Nicolas Sucari: But yeah, I don’t think there is a kind of

89 00:05:37.910 00:05:44.310 Nicolas Sucari: anything else we need to work on, and if they do. If they say that we need like any other modeling.

90 00:05:44.340 00:05:45.399 Nicolas Sucari: we can do it.

91 00:05:46.680 00:05:47.770 Ryan Luke Daque: Okay. Sounds good.

92 00:05:47.770 00:05:49.880 Nicolas Sucari: I mean, it sounds pretty simple, I know.

93 00:05:50.520 00:05:51.309 Ryan Luke Daque: Yeah, it’s.

94 00:05:51.310 00:05:58.139 Nicolas Sucari: Yeah. And it sounds like we don’t need to do anything just like really dashboard. And that’s it. But I’m not sure about that.

95 00:05:58.280 00:06:04.129 Nicolas Sucari: So let’s try that and see what happens. Because I what I can see is that we already have the column name right, and the

96 00:06:04.390 00:06:05.490 Nicolas Sucari: and everything on the table.

97 00:06:05.490 00:06:06.950 Ryan Luke Daque: Like it. Yeah.

98 00:06:07.270 00:06:12.290 Ryan Luke Daque: it looks like it’s so ha! Like our occurred. For example, you can just add

99 00:06:15.810 00:06:17.549 Ryan Luke Daque: something like this.

100 00:06:18.958 00:06:21.979 Ryan Luke Daque: and then it’s called this.

101 00:06:23.400 00:06:24.959 Ryan Luke Daque: Well, I guess they

102 00:06:25.600 00:06:28.180 Ryan Luke Daque: they want to show it as this.

103 00:06:28.660 00:06:30.269 Nicolas Sucari: Yeah, yeah, let’s use that one.

104 00:06:30.270 00:06:31.599 Ryan Luke Daque: With the underscore.

105 00:06:32.000 00:06:33.309 Nicolas Sucari: With the underscore, yeah.

106 00:06:33.620 00:06:34.400 Ryan Luke Daque: And then

107 00:06:35.980 00:06:39.059 Ryan Luke Daque: they’ll have description. Which is

108 00:06:39.320 00:06:40.490 Ryan Luke Daque: this one.

109 00:06:41.600 00:06:42.450 Nicolas Sucari: Exactly

110 00:06:48.860 00:06:55.769 Nicolas Sucari: what you can duplicates and mentions. Because you already have our occurred, you know. Maybe

111 00:06:59.790 00:07:00.950 Nicolas Sucari: it says duplicate.

112 00:07:00.950 00:07:01.500 Ryan Luke Daque: I wonder!

113 00:07:04.570 00:07:07.520 Nicolas Sucari: Because you have it on the time series, maybe

114 00:07:08.200 00:07:08.740 Nicolas Sucari: on top.

115 00:07:08.790 00:07:09.280 Ryan Luke Daque: Shouldn’t.

116 00:07:09.280 00:07:09.850 Nicolas Sucari: Dimensions.

117 00:07:09.850 00:07:10.720 Ryan Luke Daque: Be fine.

118 00:07:13.430 00:07:14.020 Nicolas Sucari: Hmm.

119 00:07:18.250 00:07:22.230 Nicolas Sucari: That one. Yeah, I think the time because you’re using the time series.

120 00:07:25.650 00:07:28.410 Ryan Luke Daque: I don’t know. So let yeah, let’s remove that.

121 00:07:28.960 00:07:31.029 Ryan Luke Daque: Let’s try add unit.

122 00:07:32.320 00:07:34.400 Ryan Luke Daque: So it should be underscore.

123 00:07:40.530 00:07:42.809 Ryan Luke Daque: And then the description would be

124 00:07:44.070 00:07:45.220 Ryan Luke Daque: not.

125 00:07:46.820 00:07:47.370 Nicolas Sucari: Yeah.

126 00:07:51.370 00:07:52.549 Nicolas Sucari: yeah, that’s fine.

127 00:07:54.260 00:08:00.069 Ryan Luke Daque: Okay, yeah, I’ll continue working on this. So I don’t think we need models then, because we’re not joining anything.

128 00:08:01.180 00:08:05.100 Nicolas Sucari: I mean the mobile should be only a simple query, selecting all right.

129 00:08:05.934 00:08:10.195 Ryan Luke Daque: We don’t even need it anymore. Like, we don’t even need source as well.

130 00:08:10.690 00:08:13.370 Nicolas Sucari: But you can create a dashboard without source, and all.

131 00:08:14.330 00:08:15.780 Ryan Luke Daque: Yeah, based on.

132 00:08:16.380 00:08:17.530 Ryan Luke Daque: I think the.

133 00:08:17.530 00:08:18.190 Nicolas Sucari: Action.

134 00:08:18.650 00:08:22.459 Ryan Luke Daque: Yeah, I think. Where did I? It’s like part of

135 00:08:22.590 00:08:25.689 Ryan Luke Daque: I I saw it like here.

136 00:08:33.789 00:08:35.760 Ryan Luke Daque: Where was that? I think.

137 00:08:36.590 00:08:43.360 Nicolas Sucari: That’s fine. I mean, if you if you’ve seen it, that’s I’m okay. I haven’t seen it yet. Be like like created a dashboard with outsourcing.

138 00:08:43.360 00:08:43.780 Ryan Luke Daque: Here.

139 00:08:43.780 00:08:44.600 Nicolas Sucari: That’s fine!

140 00:08:44.940 00:08:46.640 Ryan Luke Daque: I think. Let’s see here.

141 00:08:46.710 00:08:50.489 Ryan Luke Daque: cause they don’t have the click house

142 00:08:50.590 00:08:55.680 Ryan Luke Daque: connector yet in their documentation. So it’s an actually olap engine here.

143 00:08:56.330 00:08:56.920 Nicolas Sucari: Okay.

144 00:08:56.920 00:08:57.900 Ryan Luke Daque: So

145 00:08:58.220 00:09:03.760 Ryan Luke Daque: yeah, so I just basically followed whatever it said here. So it looks like we can

146 00:09:04.598 00:09:14.109 Ryan Luke Daque: directly create dashboards out of the con connector as long as we don’t have any joins. But if we need to join 2 models, for example, or 2 tables, then we’ll have to.

147 00:09:14.110 00:09:14.460 Nicolas Sucari: Yeah.

148 00:09:14.460 00:09:15.290 Ryan Luke Daque: Model.

149 00:09:15.660 00:09:16.480 Nicolas Sucari: Yeah, exactly.

150 00:09:16.480 00:09:24.929 Ryan Luke Daque: Yeah, okay, sounds good. Then I’ll I’ll continue working on this, and I should have something to show later. But I don’t.

151 00:09:24.930 00:09:25.440 Nicolas Sucari: For Kim.

152 00:09:25.440 00:09:27.839 Ryan Luke Daque: I don’t know if I mean for this one.

153 00:09:28.120 00:09:30.380 Ryan Luke Daque: But I we I won’t.

154 00:09:30.945 00:09:34.819 Ryan Luke Daque: Maybe I won’t push any Prs yet, or maybe I can just create one. And then we can.

155 00:09:35.250 00:09:36.289 Ryan Luke Daque: We can work on that

156 00:09:37.420 00:09:42.379 Ryan Luke Daque: for Kim. I, yeah, I did merge the one that you approved.

157 00:09:42.630 00:09:46.660 Ryan Luke Daque: So there were some changes there. Where was that?

158 00:09:47.000 00:09:48.829 Ryan Luke Daque: But it’s still not

159 00:09:48.840 00:09:51.939 Ryan Luke Daque: really exactly the same as what

160 00:09:52.370 00:09:57.870 Ryan Luke Daque: she had in her like, for example, their Facebook is different. It’s now even more.

161 00:09:58.160 00:09:59.809 Ryan Luke Daque: 1, 64.

162 00:09:59.810 00:10:00.560 Nicolas Sucari: Hmm.

163 00:10:02.160 00:10:04.889 Ryan Luke Daque: Let’s try by week. Yeah, it’s the same.

164 00:10:05.050 00:10:06.810 Ryan Luke Daque: Google ads is

165 00:10:06.880 00:10:12.700 Ryan Luke Daque: like, she said, it’s 200. But I’m it’s here. It’s 203.

166 00:10:14.020 00:10:14.530 Nicolas Sucari: Yeah, it.

167 00:10:14.530 00:10:14.790 Ryan Luke Daque: Yeah.

168 00:10:14.790 00:10:20.189 Nicolas Sucari: If it is like 1% difference, I think we are fine under 2% different. I think we’re fine.

169 00:10:20.540 00:10:23.700 Nicolas Sucari: The one that is kind of different is SMS right?

170 00:10:25.040 00:10:26.430 Ryan Luke Daque: SMS,

171 00:10:27.330 00:10:29.990 Ryan Luke Daque: yeah 190. And we had

172 00:10:30.360 00:10:33.094 Ryan Luke Daque: 39. Yeah. And this is

173 00:10:34.230 00:10:35.050 Ryan Luke Daque: coming from.

174 00:10:35.050 00:10:35.519 Nicolas Sucari: This is right.

175 00:10:35.983 00:10:36.910 Ryan Luke Daque: Oh, yeah.

176 00:10:36.910 00:10:39.419 Nicolas Sucari: No. Yeah. Attentive SMS is attentive.

177 00:10:39.940 00:10:42.119 Ryan Luke Daque: Oh, no! SMS is

178 00:10:42.560 00:10:47.659 Ryan Luke Daque: no, no, this is correct. I believe ours, because.

179 00:10:48.270 00:10:52.589 Ryan Luke Daque: like for attentive and klaviyo, she, she added, both the campaign

180 00:10:54.010 00:10:54.720 Ryan Luke Daque: flow of things.

181 00:10:54.720 00:10:57.480 Nicolas Sucari: It’s it’s it’s only the okay. Excellent.

182 00:10:57.480 00:11:02.850 Ryan Luke Daque: So direct. Mail she said it was 26, but we had 49 here, so it’s

183 00:11:03.070 00:11:14.320 Ryan Luke Daque: also fixed where it was not showing everything, because, like of the nulls, null values for some reason. But I fixed that. But it’s also like now, it’s even more than

184 00:11:15.300 00:11:16.440 Ryan Luke Daque: okay.

185 00:11:16.650 00:11:19.729 Ryan Luke Daque: Well, what she has, which is something I don’t seem.

186 00:11:19.730 00:11:21.470 Nicolas Sucari: Post pilot, actually.

187 00:11:21.470 00:11:23.321 Ryan Luke Daque: Yeah, this is post violent thing.

188 00:11:23.880 00:11:26.049 Ryan Luke Daque: I wonder I haven’t really

189 00:11:26.290 00:11:31.070 Ryan Luke Daque: check the data from post Pilot. If we have, we are having duplicates.

190 00:11:31.626 00:11:33.659 Ryan Luke Daque: Like this one, for example.

191 00:11:34.210 00:11:34.900 Ryan Luke Daque: Cause, that’s what.

192 00:11:34.900 00:11:35.880 Nicolas Sucari: Remember, from.

193 00:11:35.880 00:11:36.150 Ryan Luke Daque: And.

194 00:11:36.150 00:11:38.330 Nicolas Sucari: Yeah. We have duplicates.

195 00:11:38.520 00:11:42.629 Ryan Luke Daque: Yeah. And I had to like, remove the duplicates. So I guess.

196 00:11:42.630 00:11:43.680 Nicolas Sucari: Maybe this is also.

197 00:11:44.135 00:11:44.590 Ryan Luke Daque: Thing

198 00:11:45.300 00:11:47.560 Ryan Luke Daque: I need to check for duplicates. Yeah.

199 00:11:47.560 00:11:54.480 Nicolas Sucari: Also remember that post pilot. We had the issue about the postcard date and the conversion.

200 00:11:54.480 00:11:55.200 Ryan Luke Daque: Right.

201 00:11:55.200 00:11:55.770 Nicolas Sucari: Alright.

202 00:11:56.020 00:12:01.609 Nicolas Sucari: so I don’t know where, where, where. I don’t know where Kim is getting that revenue number.

203 00:12:01.660 00:12:06.330 Nicolas Sucari: but we’ll maybe we can discuss with them in in. Maybe we can discuss with her in the call

204 00:12:07.700 00:12:10.180 Nicolas Sucari: so that we can check those numbers. But yeah.

205 00:12:10.670 00:12:16.010 Nicolas Sucari: that’s that’s cool. We can show her that we updated the other ones, and we can go directly to check these ones.

206 00:12:16.540 00:12:17.789 Ryan Luke Daque: Okay. Sounds good.

207 00:12:18.130 00:12:30.480 Nicolas Sucari: And I think I’m gonna just cancel the meeting with Jack. We don’t have anything to talk with him, and we haven’t been working on anything regarding shipment. Right? We are still waiting for Unis to.

208 00:12:30.480 00:12:31.840 Ryan Luke Daque: Yeah, tool, right?

209 00:12:31.840 00:12:36.809 Nicolas Sucari: That’s the Po number on the report. I’m I’m gonna email Justin again

210 00:12:37.130 00:12:42.180 Nicolas Sucari: to see what’s the status of that one. But yeah, we don’t have anything else, I think, to discuss.

211 00:12:43.040 00:12:44.239 Ryan Luke Daque: Okay. Sounds good.

212 00:12:44.240 00:12:47.180 Nicolas Sucari: I can. I can send an update through slack channel. I think.

213 00:12:48.810 00:12:50.040 Ryan Luke Daque: Okay. Cool.

214 00:12:50.590 00:12:52.060 Nicolas Sucari: Excellent. Okay.

215 00:12:52.450 00:13:02.379 Nicolas Sucari: cool. Let me know if you need anything else here for for real project. If you need to talk to pat. Also let me know, and we can create like a quick meeting and go through it. Okay.

216 00:13:02.680 00:13:03.770 Ryan Luke Daque: Sure, no problem.

217 00:13:04.170 00:13:04.580 Nicolas Sucari: Excellent.

218 00:13:04.580 00:13:07.109 Ryan Luke Daque: Sounds good. Thanks, Ryan. Thank you. Bye-bye.

219 00:13:07.110 00:13:07.740 Nicolas Sucari: Bye-bye.