Meeting Title: Insomnia: Taxonomy Meeting (INS 165) Date: 2025-10-14 Meeting participants: Awaish Kumar, Mustafa Raja, Rico Rejoso, Uttam Kumaran


WEBVTT

1 00:00:29.260 00:00:30.579 Rico Rejoso: Hey guys, good morning.

2 00:00:31.210 00:00:32.259 Mustafa Raja: And…

3 00:00:34.200 00:00:37.640 Rico Rejoso: Okay, let me just ping our thumb.

4 00:00:41.270 00:00:41.950 Awaish Kumar: Hello?

5 00:00:42.460 00:00:43.140 Mustafa Raja: Hey.

6 00:01:20.520 00:01:23.119 Awaish Kumar: Let’s start, I think we could…

7 00:01:23.710 00:01:26.040 Awaish Kumar: So I understand the ticket.

8 00:01:26.750 00:01:31.100 Awaish Kumar: And I think, what you are looking for is…

9 00:01:32.050 00:01:43.450 Awaish Kumar: Some way to group these campaigns together, right? So, like, we can…

10 00:01:43.860 00:01:50.780 Awaish Kumar: For example, either group them, or whatever you call, period segments, or… Things like that.

11 00:01:50.780 00:01:51.739 Mustafa Raja: Hmm, yeah.

12 00:01:51.950 00:01:55.690 Awaish Kumar: So… You understand?

13 00:01:57.450 00:02:06.000 Awaish Kumar: To do that, like, I have two questions. Do we have a say in deciding what should be the campaign name?

14 00:02:07.100 00:02:14.239 Mustafa Raja: I don’t think so. Their marketing team, works… works with that.

15 00:02:14.510 00:02:17.900 Mustafa Raja: I don’t think we have, we have a scene that…

16 00:02:18.530 00:02:25.609 Awaish Kumar: Yeah, like, right now, marketing team is deciding for the offer names. Yeah. We are just, like, taking the…

17 00:02:25.790 00:02:29.055 Awaish Kumar: Action on top of that, but…

18 00:02:29.860 00:02:33.510 Awaish Kumar: To create a standard way of doing that, we have to…

19 00:02:33.750 00:02:38.209 Awaish Kumar: move it from other way around. We will come up with a structure

20 00:02:38.320 00:02:49.439 Awaish Kumar: Like, how we should name the campaigns. Maybe which can include some product name, some include offer name, or something like that. And we propose that to the marketing team.

21 00:02:51.030 00:02:56.580 Mustafa Raja: Okay, so we are going to propose them how they should name the campaigns.

22 00:02:57.820 00:02:58.590 Uttam Kumaran: Yes.

23 00:02:59.980 00:03:00.840 Mustafa Raja: Okay.

24 00:03:00.840 00:03:07.590 Awaish Kumar: There are two parts here, like, one is we just figure out how we can group them together from the campaign means.

25 00:03:08.490 00:03:09.539 Awaish Kumar: Part of it, but…

26 00:03:09.920 00:03:15.660 Awaish Kumar: I don’t know, like, tomorrow someone is going to come in, and maybe he names it in a way which is…

27 00:03:15.980 00:03:21.409 Awaish Kumar: Which we haven’t seen, and we are not able to categorize it in any category, right?

28 00:03:22.360 00:03:30.490 Awaish Kumar: We have to build some standards, how we can name it. So that’s what exactly we have to figure out, right?

29 00:03:31.150 00:03:33.239 Awaish Kumar: Is that a way of getting the…

30 00:03:33.590 00:03:38.299 Awaish Kumar: A campaign name, maybe it should include a product name, it should include a…

31 00:03:38.970 00:03:56.349 Awaish Kumar: something like offer name, things like that. And from there, we… once we have a standard, we are all going to name it that way, and we will know that, okay, the first chunk of this campaign name is the product name, second chunk is offer name.

32 00:03:56.430 00:03:59.130 Awaish Kumar: And the rest is a message, or whatever.

33 00:04:01.620 00:04:02.380 Mustafa Raja: Yeah.

34 00:04:05.920 00:04:07.249 Mustafa Raja: I guess I.

35 00:04:07.250 00:04:14.460 Uttam Kumaran: Yeah, so I think maybe it’s, maybe it’s helpful, Awash, for you to show, like, do you have one for Eden, like, a…

36 00:04:14.810 00:04:19.940 Uttam Kumaran: sort of a taxonomy structure, and then we can have Mustafa work on one.

37 00:04:20.350 00:04:26.079 Uttam Kumaran: for… the campaigns. We can also add this to our data platform documentation, like I…

38 00:04:26.180 00:04:28.489 Uttam Kumaran: Taxonomy creation sheet or something.

39 00:04:29.200 00:04:33.130 Awaish Kumar: Yeah, like, we do have something on… Comfortable.

40 00:04:34.340 00:04:36.579 Awaish Kumar: I’ll have to find that out,

41 00:04:43.450 00:04:44.443 Awaish Kumar: Hi.

42 00:04:58.290 00:04:58.850 Uttam Kumaran: Hello?

43 00:05:39.180 00:05:42.100 Awaish Kumar: Sorry, I can share that link with you.

44 00:05:42.580 00:05:47.950 Awaish Kumar: In this rack, that’s basically… What I just described, but…

45 00:05:48.250 00:05:54.430 Awaish Kumar: that will have proper structure for Aiden, and it will be something like this, for example.

46 00:05:54.930 00:05:57.190 Awaish Kumar: Should I be sharing them.

47 00:06:00.940 00:06:04.020 Awaish Kumar: This is in the chat, I have sent,

48 00:06:07.800 00:06:14.580 Awaish Kumar: The message, so you can see, like, first is… Channel that did… Memor for a team named…

49 00:06:15.320 00:06:26.000 Awaish Kumar: But yeah, we have a complete structure for ANN. I will find the sheet and send it to you. But, yeah, it’s like…

50 00:06:26.000 00:06:27.040 Mustafa Raja: So this is…

51 00:06:27.040 00:06:27.990 Awaish Kumar: Extended.

52 00:06:28.470 00:06:34.249 Mustafa Raja: Okay, so this is the format that Eden people, name… name… name the, campaign.

53 00:06:34.250 00:06:39.579 Uttam Kumaran: Yeah, so basically, it’s like the… it’s the… we’re proposing what the naming convention should be.

54 00:06:39.580 00:06:40.680 Mustafa Raja: Okay.

55 00:06:41.650 00:06:42.510 Mustafa Raja: Okay.

56 00:06:42.510 00:06:49.759 Uttam Kumaran: So, given, like, right now for Insomnia, they have campaigns and products and discounts that are named all types of stuff.

57 00:06:49.890 00:07:01.670 Uttam Kumaran: But there’s no, like, naming conventions. So our job is to propose the naming convention that has all the dimensionality we need when they go to name a campaign or something like that.

58 00:07:03.680 00:07:16.539 Uttam Kumaran: So I think, like, kind of two things that would be really helpful in terms of, like, tickets here. One would be, I think we should go ahead and establish, like, an Insomnia tickets data platform.

59 00:07:16.790 00:07:18.280 Uttam Kumaran: Documentation?

60 00:07:19.210 00:07:22.490 Uttam Kumaran: And then second is we should create a…

61 00:07:22.900 00:07:28.120 Uttam Kumaran: Like, naming conventions, like, sheet in there.

62 00:07:28.270 00:07:29.470 Awaish Kumar: That would be great.

63 00:07:30.320 00:07:37.030 Awaish Kumar: So this is something, I… although for… like, we have two different ways of doing it.

64 00:07:37.210 00:07:41.710 Awaish Kumar: And then the other one is much more relevant to Insomnia, that’s about for campaigns.

65 00:07:41.930 00:07:46.699 Awaish Kumar: And I can… afterwards, but this… this is also, like, something similar. We…

66 00:07:48.130 00:07:53.699 Awaish Kumar: Have to decide… have to, like… Customize the specific conventions.

67 00:07:53.840 00:07:58.160 Awaish Kumar: So we, like, different people were naming different products, you know, different ways.

68 00:07:58.320 00:08:01.949 Awaish Kumar: Kind of a difficult… I created a chart like this.

69 00:08:02.080 00:08:05.020 Awaish Kumar: And ask them to follow this naming convention.

70 00:08:05.020 00:08:05.740 Mustafa Raja: Aww.

71 00:08:05.740 00:08:06.530 Awaish Kumar: So…

72 00:08:07.190 00:08:17.290 Awaish Kumar: Next time, whenever they put the product name, they will just find out what is standard way of naming that, and then put it in campaigns, or whatever offers.

73 00:08:19.360 00:08:22.300 Mustafa Raja: Okay, yeah, that, that, that makes sense.

74 00:08:27.250 00:08:29.629 Awaish Kumar: Okay, and in the meantime, I…

75 00:08:29.890 00:08:33.890 Awaish Kumar: Yeah, to do that, we just have to…

76 00:08:34.100 00:08:40.040 Awaish Kumar: explore the sample. I have been doing that. I’ve been looking at the sample data you have shared.

77 00:08:40.750 00:08:41.419 Mustafa Raja: Yeah.

78 00:08:41.429 00:08:45.989 Awaish Kumar: Like, I would say, like, First is the channel, that’s why I…

79 00:08:46.169 00:08:48.349 Awaish Kumar: I suggested the map and the…

80 00:08:48.599 00:08:55.179 Awaish Kumar: Zoom, chat, like, so, like, this is… this is… what does this show is that…

81 00:08:56.009 00:09:01.929 Awaish Kumar: We have data, we have channel… Then we have some, offer or clear.

82 00:09:01.930 00:09:02.840 Mustafa Raja: Yeah, yeah.

83 00:09:03.210 00:09:04.460 Awaish Kumar: And then a message.

84 00:09:04.680 00:09:05.290 Mustafa Raja: Yeah.

85 00:09:06.250 00:09:13.180 Awaish Kumar: From this, we have to find a standard error, which not just works for them, but also works for us, so…

86 00:09:13.180 00:09:13.830 Mustafa Raja: Okay.

87 00:09:14.150 00:09:15.679 Awaish Kumar: I want to find one of the middle.

88 00:09:15.950 00:09:17.089 Mustafa Raja: Hmm, okay.

89 00:09:18.430 00:09:24.129 Mustafa Raja: the products that they have in, Braze, are a little weird.

90 00:09:25.090 00:09:26.300 Mustafa Raja: So…

91 00:09:26.620 00:09:28.900 Awaish Kumar: Campaign names, I don’t know what products.

92 00:09:28.900 00:09:38.149 Mustafa Raja: Yeah, yeah, from these campaign names, it’s very, let me share my screen, so I can show you what products look like.

93 00:09:39.070 00:09:45.700 Mustafa Raja: So this is from Braze, and if I were to edit… so this is…

94 00:09:46.140 00:09:53.980 Mustafa Raja: Okay, it’s now much better, but there are some products which are just numbers. A lot of them are good.

95 00:09:54.820 00:10:00.739 Mustafa Raja: names, but some of them are numbers. I don’t know if this is, valid data even or not.

96 00:10:01.720 00:10:07.410 Mustafa Raja: What the, so these are… these would be the products that we have in, Braze.

97 00:10:08.970 00:10:18.239 Awaish Kumar: Okay, but yeah, that’s the thing, like, the data which is coming… the data which is being exported is in that sheet.

98 00:10:19.540 00:10:22.880 Awaish Kumar: contain product name. That only contains campaign name.

99 00:10:23.640 00:10:25.080 Mustafa Raja: Yeah.

100 00:10:25.670 00:10:30.480 Awaish Kumar: So we have to include product names as well in the campaign name.

101 00:10:30.770 00:10:32.490 Mustafa Raja: Okay, okay, T, okay.

102 00:10:38.620 00:10:48.809 Mustafa Raja: Yeah, apart from that… We also want, taxonomy for RFM and offer types.

103 00:10:48.970 00:10:53.990 Mustafa Raja: Offer types, I guess, we have discussed. These would be the offers, or something like, right?

104 00:10:53.990 00:11:00.540 Awaish Kumar: Yeah, there’s, like, we have to set, like, the way I have shared it in the message, we just figured out

105 00:11:01.190 00:11:06.370 Awaish Kumar: What should be the first date, or a channel name, or a product name? What will be the second state?

106 00:11:06.640 00:11:09.039 Awaish Kumar: And how they will be diff…

107 00:11:09.290 00:11:11.899 Awaish Kumar: Separated through an underspoon, or a…

108 00:11:12.700 00:11:24.619 Awaish Kumar: iPhone or whatever, and just any standard template of doing that. Congress going to see any campaign that’s being launched will be named in this standard format.

109 00:11:24.850 00:11:25.860 Awaish Kumar: That’s all.

110 00:11:26.480 00:11:27.400 Mustafa Raja: Okay.

111 00:11:27.640 00:11:35.390 Mustafa Raja: Yeah, and one more thing is they already have, Rmf categories…

112 00:11:38.120 00:11:40.920 Mustafa Raja: I’m trying to look which API was that.

113 00:11:43.360 00:11:45.450 Mustafa Raja: I don’t remember one.

114 00:11:48.140 00:11:48.920 Awaish Kumar: R.

115 00:11:49.400 00:11:52.619 Awaish Kumar: the data which is coming from Braze, the, like.

116 00:11:52.890 00:11:56.670 Awaish Kumar: Can we… is there any, like, specific product name there?

117 00:11:58.500 00:11:59.360 Awaish Kumar: infield.

118 00:11:59.360 00:12:03.739 Uttam Kumaran: If we, if we export data by users.

119 00:12:03.740 00:12:14.140 Mustafa Raja: There’s this purchase, field, and that field would have, the…

120 00:12:14.470 00:12:18.429 Mustafa Raja: The products that a particular user has been buying.

121 00:12:19.170 00:12:20.680 Mustafa Raja: For the last 90 days.

122 00:12:23.530 00:12:29.140 Mustafa Raja: So this would have whatever the… whatever products a certain user has purchased over 90 days.

123 00:12:29.690 00:12:33.419 Mustafa Raja: And this would have whatever campaigns they have received over 90 days.

124 00:12:33.680 00:12:42.519 Mustafa Raja: What we are trying to do is drill down by, products and campaigns. Only this, endpoint works.

125 00:12:42.520 00:13:01.009 Mustafa Raja: But we do not have access to the data because they have their own data store connected, and so we want to… so what happens is, when we call this API, the zip files, they get stored in their data stores, and we don’t have access to these zip files right now.

126 00:13:02.170 00:13:03.180 Awaish Kumar: Go ahead.

127 00:13:03.440 00:13:05.010 Mustafa Raja: But the schema looks like this.

128 00:13:05.010 00:13:07.850 Awaish Kumar: But this is going to client’s data store.

129 00:13:09.130 00:13:11.000 Mustafa Raja: Can you say that again?

130 00:13:11.810 00:13:13.019 Awaish Kumar: So, if we…

131 00:13:13.220 00:13:21.960 Awaish Kumar: implement this endpoint, we are going to put the data in some storage, in our client’s storage, right?

132 00:13:21.960 00:13:22.750 Mustafa Raja: Yeah, yeah.

133 00:13:23.370 00:13:26.580 Awaish Kumar: So, I know, client can give us access as well.

134 00:13:28.000 00:13:29.250 Mustafa Raja: Yeah, yeah.

135 00:13:30.880 00:13:38.060 Mustafa Raja: Yeah, I’m just, I guess we have, we have talked about, offer types and taxonomy for product.

136 00:13:38.060 00:13:38.720 Awaish Kumar: Yeah, that’s…

137 00:13:38.720 00:13:41.829 Mustafa Raja: This RM, RFM…

138 00:13:42.390 00:13:48.430 Awaish Kumar: I’m just saying that the data we are looking to analyze is available through an endpoint.

139 00:13:49.240 00:13:49.790 Mustafa Raja: Yeah.

140 00:13:49.880 00:13:51.330 Awaish Kumar: utilize that.

141 00:13:51.630 00:13:53.300 Mustafa Raja: Yeah, yeah, yeah, yeah.

142 00:13:53.860 00:13:54.660 Mustafa Raja: Okay.

143 00:13:56.750 00:13:58.579 Awaish Kumar: If… if it is something.

144 00:13:58.580 00:14:04.040 Uttam Kumaran: But I guess I’m not following, because you can’t… we can’t bring in the data, right, until they’re easily exported.

145 00:14:04.040 00:14:08.480 Mustafa Raja: Yeah, yeah, we have some, examples over here.

146 00:14:08.630 00:14:14.169 Mustafa Raja: That, Robert was able to manually export. That’s all we have right now.

147 00:14:15.250 00:14:16.130 Uttam Kumaran: Okay.

148 00:14:16.380 00:14:22.479 Mustafa Raja: Yeah, this, this would be, this would be the sheet. I shared this with Avish earlier.

149 00:14:22.480 00:14:27.360 Awaish Kumar: Yeah, yeah, so, like, he shared a sheet with me, which only has campaign names.

150 00:14:27.370 00:14:43.560 Awaish Kumar: So, one thing is to build that taxonomy and force insomnia team to have the campaign name that way, so we can basically drill down our analyze to product levels and offer types. But then, most of our shorter endpoint.

151 00:14:43.680 00:14:46.909 Awaish Kumar: Which basically has, has all this information.

152 00:14:47.240 00:14:51.340 Awaish Kumar: available, so I’m not sure why we are not losing that.

153 00:14:52.260 00:15:01.220 Mustafa Raja: So, we don’t have access to the, first, the data store that saves it, but, one more thing is that, this…

154 00:15:01.220 00:15:03.460 Awaish Kumar: India hasn’t given us the access, or…

155 00:15:04.130 00:15:06.859 Mustafa Raja: Yeah, Insomnia hasn’t given the access, right?

156 00:15:07.290 00:15:08.429 Awaish Kumar: We can ask for that.

157 00:15:08.430 00:15:09.530 Uttam Kumaran: I have not given it.

158 00:15:12.330 00:15:16.710 Uttam Kumaran: Yeah, yeah, we’re gonna ask… basically, they’re… I’m gonna get it this week.

159 00:15:16.860 00:15:31.549 Mustafa Raja: Yeah, and one more thing, this endpoint is, by user and not by, campaigns also. So this is whatever a user has been doing in our platform so far.

160 00:15:34.320 00:15:37.729 Mustafa Raja: And the sheet really is by campaigns.

161 00:15:39.860 00:15:45.930 Awaish Kumar: But you mentioned that we have the list of, for example, user abesh got

162 00:15:46.230 00:15:52.519 Awaish Kumar: emails for 5 campaigns, I will get that information from this endpoint, right?

163 00:15:53.060 00:15:55.519 Mustafa Raja: user Avish has… yeah, yeah, yeah.

164 00:15:56.740 00:15:58.560 Mustafa Raja: Yeah, for past 90 days.

165 00:15:58.560 00:16:00.050 Awaish Kumar: We’ll have all the data.

166 00:16:00.590 00:16:01.270 Mustafa Raja: Yeah.

167 00:16:04.690 00:16:07.179 Mustafa Raja: For past 90 days, though. That’s the only patch.

168 00:16:07.180 00:16:11.860 Awaish Kumar: Yeah, so we… Basically, you can incrementally just sync the data, right?

169 00:16:12.140 00:16:13.510 Mustafa Raja: Yeah, yeah.

170 00:16:14.700 00:16:20.690 Awaish Kumar: Oh, but is there a requirement, like, right now, that we want to get past one year’s data right now, or is it…

171 00:16:20.690 00:16:29.179 Mustafa Raja: I don’t think so. There isn’t a requirement for that. And if we had, I don’t think there’s any other way for getting that.

172 00:16:29.380 00:16:38.210 Mustafa Raja: This is the only endpoint I was able to find that is able to give us purchases by user, and also campaigns a user has received.

173 00:16:40.690 00:16:41.920 Awaish Kumar: No, Mike, Mike.

174 00:16:42.430 00:16:44.999 Awaish Kumar: My question is, maybe the export

175 00:16:45.390 00:16:52.780 Awaish Kumar: the XA export, which you showed earlier, That way, we might get… Historical data.

176 00:16:52.780 00:16:55.360 Mustafa Raja: Oh, yeah, yeah, yeah, yeah, we can, we can infer that.

177 00:16:55.360 00:17:01.089 Awaish Kumar: To that endpoint, we might not get historical data. That might be the challenge, so that’s…

178 00:17:03.390 00:17:13.140 Awaish Kumar: But that won’t solve anything for historical stuff, because all the taxonomy we are going to propose will be applied to the upcoming campaigns.

179 00:17:15.109 00:17:16.019 Mustafa Raja: Oh, yeah.

180 00:17:16.509 00:17:17.879 Mustafa Raja: That is also true.

181 00:17:21.069 00:17:30.269 Awaish Kumar: Okay, so I think we should plan… I can also look at this sample data and propose something, and, we can maybe

182 00:17:30.519 00:17:38.029 Awaish Kumar: Again, talk on Slack about it, and

183 00:17:39.289 00:17:43.049 Awaish Kumar: And I will share the items Google Sheet in the meantime.

184 00:17:43.209 00:17:49.589 Awaish Kumar: What the standard looks like, and… Off of that.

185 00:17:49.590 00:17:58.950 Uttam Kumaran: Yeah, I think, I want to create OH, I want to add it to our data platform documentation, like our template, also.

186 00:18:00.090 00:18:01.280 Uttam Kumaran: So that would be great.

187 00:18:05.400 00:18:06.420 Awaish Kumar: Perfect.

188 00:18:13.940 00:18:16.850 Awaish Kumar: Sorry, was that ask from me, or…

189 00:18:17.950 00:18:24.069 Uttam Kumaran: Yeah, if you can add… if you can add, like, a template taxonomy sheet to…

190 00:18:25.010 00:18:26.950 Awaish Kumar: Yeah, yeah, yeah, I don’t know that, because…

191 00:18:26.950 00:18:28.520 Uttam Kumaran: boilerplate template. Yeah.

192 00:18:28.520 00:18:29.170 Awaish Kumar: Fair.

193 00:18:30.760 00:18:33.999 Awaish Kumar: That’s what I said, I will edit it there, and then I…

194 00:18:34.140 00:18:37.869 Awaish Kumar: The next steps will help with, first of all, with, like.

195 00:18:38.420 00:18:43.920 Awaish Kumar: Also, like, standardizing the name, whatever that is, And we can,

196 00:18:44.060 00:18:46.760 Awaish Kumar: Basically, put it in this,

197 00:18:47.090 00:18:53.500 Awaish Kumar: sheet for insomnia. That’s the first one step, like, for doing the…

198 00:18:54.140 00:18:56.720 Awaish Kumar: Analysis. And another step is to…

199 00:18:57.030 00:19:02.000 Awaish Kumar: Also, get access for that data, the data stored.

200 00:19:02.000 00:19:05.499 Mustafa Raja: So… Yeah, I think what I’m trying to get there.

201 00:19:07.750 00:19:08.720 Uttam Kumaran: Yeah, I’m trying to…

202 00:19:09.310 00:19:11.400 Awaish Kumar: So, would you be following that, Utham, or…

203 00:19:12.120 00:19:14.310 Uttam Kumaran: Yeah, yeah, yeah, I’ll get… I’m gonna get it this week.

204 00:19:15.150 00:19:17.650 Awaish Kumar: Okay, so, yeah, we are clear on the text.

205 00:19:18.480 00:19:19.140 Uttam Kumaran: Cheese.

206 00:19:22.130 00:19:27.969 Mustafa Raja: Yeah, this is good. This meeting gave me a lot of clarity on what needs to be done over here.

207 00:19:29.000 00:19:29.730 Awaish Kumar: Okay.

208 00:19:30.340 00:19:31.170 Uttam Kumaran: Cheers.

209 00:19:33.630 00:19:34.250 Mustafa Raja: Thank you.

210 00:19:34.250 00:19:35.189 Uttam Kumaran: Thank you both.

211 00:19:35.360 00:19:37.139 Mustafa Raja: Thank you. Have a good day.