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


WEBVTT

1 00:00:11.590 00:00:12.440 Nicolas Sucari: Hey, Ryan.

2 00:00:12.620 00:00:13.669 Luke Daque: And it was.

3 00:00:14.560 00:00:15.480 Nicolas Sucari: How are you?

4 00:00:16.070 00:00:17.780 Luke Daque: Yeah. Doing. Well, how are you?

5 00:00:18.450 00:00:19.410 Nicolas Sucari: I’m good.

6 00:00:19.670 00:00:22.579 Nicolas Sucari: thanks, thanks to join. I don’t wanna

7 00:00:23.350 00:00:29.490 Nicolas Sucari: keep you here for for long, so just wanted to share what I’m trying to to do for

8 00:00:29.510 00:00:32.190 Nicolas Sucari: Javi. I’m trying to update all of the notion page.

9 00:00:32.250 00:00:41.769 Nicolas Sucari: I need it. Yeah, we need to share with the man kind of a roadmap of what we are doing. I think I have all the tasks let me share. Yeah.

10 00:00:42.180 00:00:43.060 Nicolas Sucari: this.

11 00:00:43.940 00:00:46.360 Nicolas Sucari: I think we have almost everything here.

12 00:00:46.550 00:00:47.310 Nicolas Sucari: So for.

13 00:00:47.310 00:00:47.670 Luke Daque: Interesting.

14 00:00:47.670 00:00:51.979 Nicolas Sucari: I created. Well, the Javi page that you already know.

15 00:00:52.000 00:00:56.480 Nicolas Sucari: I added, here all the tools I’m gonna add here the link to the dashboards

16 00:00:56.580 00:00:58.209 Nicolas Sucari: and the real project

17 00:00:58.900 00:01:01.119 Nicolas Sucari: and then I created this roadmap

18 00:01:01.380 00:01:03.319 Nicolas Sucari: where we added some stuff.

19 00:01:03.320 00:01:03.800 Luke Daque: Like.

20 00:01:04.110 00:01:13.030 Nicolas Sucari: We have all of these done. We are working on the refunds and return stuff. I we have here, and we are working to match

21 00:01:13.180 00:01:14.939 Nicolas Sucari: metabase, unreal, right?

22 00:01:15.310 00:01:17.200 Luke Daque: Right? Which is, yeah, okay.

23 00:01:17.580 00:01:26.889 Nicolas Sucari: Then, okay, no gorgeous. We started yesterday to to sync that data. I’m gonna check if that’s ready. And then I’m gonna close this one. And then I created, like this kind of

24 00:01:27.665 00:01:38.370 Nicolas Sucari: roadmap or tasks that we need to to work on. So we will need to do some modeling on gorgeous and ocado, I think, for gorgeous, I added here, like the message a man sent.

25 00:01:38.950 00:01:42.979 Luke Daque: Yeah, I think I already have something ready for that. Do we already.

26 00:01:42.980 00:01:43.470 Nicolas Sucari: Excellent.

27 00:01:43.470 00:01:45.060 Luke Daque: Access to 5 grand.

28 00:01:45.750 00:01:48.080 Nicolas Sucari: Yeah, yeah, yeah, we have access to 5.

29 00:01:49.080 00:01:50.640 Luke Daque: Yeah, if you can

30 00:01:50.840 00:01:53.530 Luke Daque: maybe give me access as well about each.

31 00:01:53.530 00:01:57.070 Nicolas Sucari: Yeah, it’s on the, it’s on the share email. So.

32 00:01:57.070 00:01:57.509 Luke Daque: Oh, okay.

33 00:01:57.510 00:01:59.240 Nicolas Sucari: Be able to see it in one password.

34 00:01:59.560 00:02:01.590 Luke Daque: And yeah, okay, gotcha, okay.

35 00:02:01.680 00:02:08.850 Luke Daque: yeah, I, I did start working on the models for that based on 5 trans, Erd, so yeah, we can, we can work.

36 00:02:08.850 00:02:09.690 Nicolas Sucari: Excellent.

37 00:02:10.330 00:02:15.699 Nicolas Sucari: Yeah, I think what we will. Okay, gorgeous. It seems to still sinking.

38 00:02:15.790 00:02:17.130 Nicolas Sucari: It’s doing the historical thing.

39 00:02:17.555 00:02:19.680 Luke Daque: Yeah, no problem. It’s good.

40 00:02:19.680 00:02:26.419 Nicolas Sucari: Kendo. I saw it yesterday on on Snowflake. So I think it’s it’s already there.

41 00:02:26.820 00:02:27.560 Luke Daque: Okay.

42 00:02:27.740 00:02:35.050 Nicolas Sucari: Yeah, what we will need to do is we will need to check on 5. Tran this.

43 00:02:36.750 00:02:47.580 Nicolas Sucari: so that we can. Yeah, we can reduce. Maybe we can reduce if I know we are just doing the initial thing for Kendo. But I think we need to check here, like in shopify

44 00:02:47.640 00:02:51.780 Nicolas Sucari: if this table, if we’re using it or not, if we’re not using it.

45 00:02:51.780 00:02:52.240 Luke Daque: And.

46 00:02:52.240 00:02:53.680 Nicolas Sucari: Gonna clean this up. Okay.

47 00:02:54.020 00:02:55.300 Luke Daque: Alright, makes sense.

48 00:02:55.710 00:03:07.030 Nicolas Sucari: Yeah. So if you can check that, it will be great. But that’s okay. So this is, this is going fine. So yeah, I added, gorgeous and the kind of modeling. So if you have something that’s okay, I can. I can add you here.

49 00:03:08.290 00:03:09.349 Nicolas Sucari: Yeah, I can.

50 00:03:09.350 00:03:15.409 Luke Daque: I can start creating one from Oquendo as well, because I I just did it for gorgeous.

51 00:03:15.690 00:03:16.140 Nicolas Sucari: Okay.

52 00:03:16.498 00:03:19.009 Luke Daque: Based on 5 trans, crd, but yeah.

53 00:03:19.860 00:03:27.739 Nicolas Sucari: The okay? And then I added, Yeah, I added, the product categories that we will need to add to the order all orders and.

54 00:03:27.740 00:03:28.130 Luke Daque: When you’re like.

55 00:03:28.130 00:03:32.299 Nicolas Sucari: Table. You remember that we don’t have product category and that kind of stuff.

56 00:03:33.310 00:03:36.159 Luke Daque: What? Which one is the product categories. Again.

57 00:03:36.970 00:03:42.475 Nicolas Sucari: If we go here or wait, I can show you in real. There is nothing that.

58 00:03:43.620 00:03:44.130 Nicolas Sucari: Oh.

59 00:03:44.130 00:03:46.040 Luke Daque: Right right. The name it was. It was.

60 00:03:46.040 00:03:46.470 Nicolas Sucari: Yeah.

61 00:03:46.970 00:03:47.470 Luke Daque: Yeah.

62 00:03:47.630 00:03:51.140 Luke Daque: Okay, yeah, yeah. I remember now, I can do that.

63 00:03:51.820 00:03:55.100 Nicolas Sucari: Cool. Yeah, there is nothing that we we don’t have like any

64 00:03:55.130 00:04:01.719 Nicolas Sucari: product categories. And also like, if we add it in the fact product fact or fact order table. We can add it here, too.

65 00:04:01.810 00:04:06.400 Nicolas Sucari: because there is nothing saying like, which product is, we just have the name, I think.

66 00:04:06.670 00:04:07.250 Luke Daque: Right.

67 00:04:07.250 00:04:07.970 Nicolas Sucari: Yeah.

68 00:04:08.320 00:04:09.600 Luke Daque: Which is very.

69 00:04:09.600 00:04:10.720 Nicolas Sucari: Not here.

70 00:04:10.860 00:04:13.800 Nicolas Sucari: but we savvy doing the order line metrics.

71 00:04:14.340 00:04:14.880 Luke Daque: Yeah.

72 00:04:14.880 00:04:18.120 Nicolas Sucari: But yeah, you see the title and name. It’s kind of

73 00:04:18.310 00:04:18.940 Nicolas Sucari: super nice.

74 00:04:18.940 00:04:20.579 Luke Daque: Yeah, okay.

75 00:04:22.270 00:04:33.179 Nicolas Sucari: One of the product categories will help. And then I created this one. That’s the one with that Brian was working on trying to match Amazon and shopify customer data.

76 00:04:33.340 00:04:43.019 Nicolas Sucari: Aman is asking like to try to match these customers. I know it’s kind of impossible, because Amazon doesn’t share the email. Right?

77 00:04:44.350 00:04:45.000 Nicolas Sucari: So.

78 00:04:45.000 00:04:45.620 Luke Daque: Okay.

79 00:04:46.000 00:04:50.280 Nicolas Sucari: So he we Brian started working on doing some matching

80 00:04:50.300 00:04:57.129 Nicolas Sucari: with the address and names. But let’s see, I I just asked him to share what he’s been doing. But let’s see what.

81 00:04:57.130 00:04:57.580 Luke Daque: Yeah.

82 00:04:57.580 00:04:59.279 Nicolas Sucari: And then we can continue.

83 00:04:59.660 00:05:09.629 Nicolas Sucari: But in terms of priority. I think once you are done with this stuff of the refunds. And yeah, checking that, the data is, okay.

84 00:05:09.630 00:05:10.070 Luke Daque: Yeah.

85 00:05:10.070 00:05:11.990 Nicolas Sucari: Should do like this.

86 00:05:12.230 00:05:14.440 Luke Daque: The modeling gotcha. Okay

87 00:05:14.670 00:05:22.940 Luke Daque: for the refunds, though. It would be. It’s a bit difficult if we don’t really have context as to like what the actual number should be

88 00:05:23.270 00:05:30.170 Luke Daque: like. Yeah. Pias mentioned, it was a bit low. But we we actually need like, how low is it? Right? Like, what? What’s that.

89 00:05:30.170 00:05:31.860 Nicolas Sucari: Yeah, yeah, yeah, of course.

90 00:05:31.860 00:05:32.780 Luke Daque: Yeah, yeah.

91 00:05:33.240 00:05:38.019 Nicolas Sucari: I mean, we need the access to shopify, and once we have that we can check the right number right.

92 00:05:38.350 00:05:46.240 Luke Daque: Right. So while waiting for that, maybe I can just start with the modeling, or like matching Amazon, or shopify versus customer data.

93 00:05:46.740 00:05:53.729 Nicolas Sucari: Okay, yeah, that’s cool. For this one. The only thing is, I know Brian started to work on something.

94 00:05:54.139 00:06:03.409 Nicolas Sucari: So my idea was him to share what he’s what he’s been doing, so that you can have like a kind of a starting point, and you don’t start from scratch

95 00:06:03.974 00:06:08.820 Nicolas Sucari: so let’s wait. Like, maybe, he he answers today hopefully.

96 00:06:08.820 00:06:09.320 Luke Daque: Sure.

97 00:06:09.566 00:06:17.690 Nicolas Sucari: And he can share what he what he’s been doing. But yeah, I think we can start we if if you don’t have nothing to do in this one. That’s okay. And.

98 00:06:17.690 00:06:18.020 Luke Daque: Yeah.

99 00:06:18.020 00:06:20.190 Nicolas Sucari: You already tried to match.

100 00:06:20.430 00:06:21.020 Nicolas Sucari: I think we.

101 00:06:21.020 00:06:21.490 Luke Daque: Meta Base.

102 00:06:21.490 00:06:31.379 Nicolas Sucari: Yeah, Meta base and real, we match the total orders. But we need, we, we need to keep working on the new subs. And yeah, right? And that kind of stuff.

103 00:06:32.470 00:06:34.270 Luke Daque: Yep cool, I’ll I’ll.

104 00:06:34.270 00:06:34.650 Nicolas Sucari: And.

105 00:06:34.650 00:06:37.679 Luke Daque: To con communicate with, pay us as well like. He might have.

106 00:06:37.680 00:06:38.490 Nicolas Sucari: Query again.

107 00:06:38.690 00:06:40.820 Luke Daque: Have a new dashboard for that.

108 00:06:41.260 00:06:41.579 Nicolas Sucari: It’s great!

109 00:06:41.580 00:06:44.330 Luke Daque: We can use that to verify. Yeah.

110 00:06:44.680 00:06:45.340 Luke Daque: cool.

111 00:06:45.340 00:06:46.140 Nicolas Sucari: So

112 00:06:46.290 00:06:53.968 Nicolas Sucari: I I added you to the channel Fungo Javi Tech. That’s the one with

113 00:06:54.860 00:06:56.690 Nicolas Sucari: a man that he’s from Javi.

114 00:06:57.159 00:06:57.630 Luke Daque: Right.

115 00:06:57.850 00:07:04.570 Nicolas Sucari: But for if you want to ask anything for Payasco in the client, Javi Coffee Channel. Okay, yep.

116 00:07:04.570 00:07:05.860 Luke Daque: Okay. Sounds good.

117 00:07:06.220 00:07:12.449 Nicolas Sucari: Excellent. My idea is to use this roadmap so that we can track what we.

118 00:07:12.580 00:07:23.080 Nicolas Sucari: what we are gonna be doing and how, when we are completing the stuff and all of that. So if you can like you, you can manage these as as a very as as you wish. Just move

119 00:07:23.090 00:07:27.759 Nicolas Sucari: things around. If you need to create a new task just created.

120 00:07:27.860 00:07:31.153 Nicolas Sucari: I’m gonna try to keep it up to date.

121 00:07:31.580 00:07:38.659 Nicolas Sucari: and if we are talking every day. I think we can do it. I mean, it’s it’s for visibility for us and for for a man, too. Okay.

122 00:07:39.120 00:07:39.799 Luke Daque: Sounds good.

123 00:07:40.840 00:07:44.289 Nicolas Sucari: This should be like our homepage for every meeting.

124 00:07:45.026 00:07:46.299 Nicolas Sucari: Moving forward.

125 00:07:46.540 00:07:47.981 Luke Daque: Yeah, makes sense. That’s great.

126 00:07:48.630 00:07:51.829 Nicolas Sucari: Yeah, cool. And here I, yeah, we’re adding

127 00:07:52.040 00:07:53.350 Nicolas Sucari: the meetings.

128 00:07:53.856 00:08:08.809 Nicolas Sucari: So I think this is, this is nice and I’m I’m adding here all of the email updates or weekly updates that we are sharing. I prepare each week, as I do for pull parts like accomplishments that we

129 00:08:08.840 00:08:11.269 Nicolas Sucari: or things that we are working on every week.

130 00:08:11.340 00:08:12.580 Nicolas Sucari: Okay, yeah.

131 00:08:12.850 00:08:18.909 Nicolas Sucari: And in documents here in resources, I just add some stuff. This is the one I shared from DVD,

132 00:08:19.345 00:08:26.099 Nicolas Sucari: I used obviously chatgpt to create this. But we need to give some context about this. So maybe.

133 00:08:26.100 00:08:26.420 Luke Daque: Yeah.

134 00:08:26.420 00:08:29.069 Nicolas Sucari: We create new metrics or.

135 00:08:29.342 00:08:37.229 Nicolas Sucari: moving forward, we can add, like a little bit more context of what we are doing. Where is this data coming from? Why are we using those metrics? Okay.

136 00:08:37.580 00:08:42.499 Luke Daque: Sounds good. We can even add that to the to the models Yaml file as well. So we have documents.

137 00:08:42.500 00:08:45.579 Nicolas Sucari: Yeah, yeah, exactly. Yeah.

138 00:08:46.595 00:08:51.630 Nicolas Sucari: And then this one is just to track when we are doing these things, or.

139 00:08:51.630 00:08:52.140 Luke Daque: Gotcha.

140 00:08:52.140 00:09:04.100 Nicolas Sucari: It’s maybe we can add here, Sync frequency daily, this is fine, I think, yeah, okay, anything else you’d like to add, let me know, and we can also add it. Okay.

141 00:09:04.100 00:09:05.560 Luke Daque: Okay. Sounds good.

142 00:09:06.555 00:09:15.840 Nicolas Sucari: What else do we have here? I created this one yesterday for the meeting that we had. No, not this one. I have to change it. But yeah, I created one specifically for jolly.

143 00:09:15.840 00:09:16.300 Luke Daque: Yeah, I think.

144 00:09:16.300 00:09:20.350 Nicolas Sucari: I saw that. Okay, yeah, in the presentation, yeah.

145 00:09:21.740 00:09:22.490 Nicolas Sucari: cool

146 00:09:22.760 00:09:28.449 Nicolas Sucari: anything else that you’d like to add here that you think it’s gonna be useful for Javi, for us

147 00:09:28.460 00:09:33.040 Nicolas Sucari: or for us. And Robert. Let me know when we can work on it. Okay.

148 00:09:33.210 00:09:34.640 Luke Daque: Okay. Sounds good.

149 00:09:35.010 00:09:49.050 Nicolas Sucari: Cool, excellent I’m gonna share these with the man. And well, I’m gonna add the dashboards. But yeah, let me know if you, if you need anything else, if you’re blocked on something and I can ping Robert pay us or a man. Okay.

150 00:09:49.380 00:09:50.460 Luke Daque: Sounds good.

151 00:09:50.930 00:09:51.710 Nicolas Sucari: Excellent

152 00:09:52.210 00:09:52.960 Nicolas Sucari: cool.

153 00:09:53.220 00:09:54.670 Nicolas Sucari: Thank you, Ryan.

154 00:09:54.730 00:09:57.919 Nicolas Sucari: Let’s talk later. If you need anything. Okay.

155 00:09:58.300 00:09:59.430 Luke Daque: Thanks, bye, bye.

156 00:09:59.600 00:10:00.320 Nicolas Sucari: Bye-bye.