Meeting Title: Ellie-Hyp-Readme-Eden-US Standup Date: 2025-10-23 Meeting participants: Casie Aviles, Samuel Roberts, Zoran Selinger, Awaish Kumar, Rico Rejoso, Mustafa Raja, Uttam Kumaran, Demilade, Amber Lin, Robert Tseng
WEBVTT
1 00:00:53.130 ⇒ 00:00:55.380 Uttam Kumaran: Hello.
2 00:00:55.720 ⇒ 00:00:56.560 Samuel Roberts: Ew.
3 00:00:57.290 ⇒ 00:00:58.070 Uttam Kumaran: Ayy.
4 00:01:07.040 ⇒ 00:01:08.140 Uttam Kumaran: Okay…
5 00:01:33.090 ⇒ 00:01:38.810 Uttam Kumaran: Okay, cool. So, who are we missing? Henry?
6 00:01:44.240 ⇒ 00:01:46.809 Uttam Kumaran: Why is my can all wonky now?
7 00:01:55.190 ⇒ 00:01:56.200 Uttam Kumaran: Nice.
8 00:01:57.090 ⇒ 00:01:58.569 Uttam Kumaran: Welcome back, Awash.
9 00:01:59.040 ⇒ 00:02:00.230 Awaish Kumar: Thank you.
10 00:02:00.760 ⇒ 00:02:01.800 Uttam Kumaran: How was it?
11 00:02:02.200 ⇒ 00:02:08.460 Awaish Kumar: What’d you do? It was pretty good. It was… all Diwali celebrations.
12 00:02:09.259 ⇒ 00:02:10.130 Awaish Kumar: prayers…
13 00:02:10.130 ⇒ 00:02:11.160 Uttam Kumaran: Lots of sweets.
14 00:02:11.160 ⇒ 00:02:12.679 Awaish Kumar: Yeah, lots of food.
15 00:02:15.210 ⇒ 00:02:16.710 Awaish Kumar: Find crackers.
16 00:02:17.380 ⇒ 00:02:18.210 Uttam Kumaran: Nice.
17 00:02:31.260 ⇒ 00:02:33.370 Uttam Kumaran: Okay,
18 00:02:34.490 ⇒ 00:02:40.899 Uttam Kumaran: Cool, so I think Robert is in a braze call, but we can get whatever updates we can get to him.
19 00:02:41.030 ⇒ 00:02:46.820 Uttam Kumaran: Today… I’m doing message…
20 00:02:50.280 ⇒ 00:02:51.999 Uttam Kumaran: Okay, let’s see…
21 00:03:22.050 ⇒ 00:03:30.760 Uttam Kumaran: Okay, so let’s talk about insomnia, so, yesterday, we…
22 00:03:31.560 ⇒ 00:03:40.200 Uttam Kumaran: we confirmed that we can get the export from Braze. Mustafa today is working on, getting those…
23 00:03:40.310 ⇒ 00:03:43.399 Uttam Kumaran: Getting those tickets, getting those…
24 00:03:44.230 ⇒ 00:03:50.190 Uttam Kumaran: files, back into S3 so that we can query in…
25 00:03:50.560 ⇒ 00:03:54.079 Uttam Kumaran: Mother Duck? I think that probably should be done, like, this afternoon.
26 00:03:54.350 ⇒ 00:03:55.380 Uttam Kumaran: And then…
27 00:03:55.670 ⇒ 00:04:02.000 Uttam Kumaran: that should solve, like, a lot of the problems, Amber, that you’re finding. Like, we have all the data should be there, pretty easily modeled at that point.
28 00:04:04.320 ⇒ 00:04:10.460 Awaish Kumar: So did you record the data, like, the access to data stored and the data from Braze?
29 00:04:11.020 ⇒ 00:04:21.779 Uttam Kumaran: Yeah, we have S3 access now, and we can do the export from Braze, and then it landed it all there. It’s landing it as all text files, so Mustafa today is working on…
30 00:04:24.350 ⇒ 00:04:31.950 Uttam Kumaran: transforming that into CSVs, re-uploading that into S3, and then we can start doing some light transformation on top of that.
31 00:04:35.300 ⇒ 00:04:36.859 Samuel Roberts: Wait, so they were text files?
32 00:04:37.420 ⇒ 00:04:39.690 Samuel Roberts: Okay, sorry, maybe I’m a little off.
33 00:04:39.690 ⇒ 00:04:42.590 Uttam Kumaran: The initial export was text files, yeah.
34 00:04:43.400 ⇒ 00:04:48.550 Uttam Kumaran: And so we have to transform that into CSVs to be able to query in Mother Duck.
35 00:04:48.840 ⇒ 00:04:54.069 Samuel Roberts: I thought I was able to get a table in Mother Duck off those, as if you could just treat them as CSVs.
36 00:04:54.460 ⇒ 00:04:56.420 Demilade: Yeah, it’s essentially table.
37 00:04:57.500 ⇒ 00:05:00.580 Demilade: It was text files that could not be queried.
38 00:05:01.380 ⇒ 00:05:02.840 Samuel Roberts: Oh, okay, okay.
39 00:05:03.210 ⇒ 00:05:05.360 Demilade: Now, I’m asking… that was actually a question. Is there any particular.
40 00:05:05.360 ⇒ 00:05:06.510 Samuel Roberts: Oh, sorry, sorry.
41 00:05:07.380 ⇒ 00:05:09.819 Uttam Kumaran: Did you query text files yesterday, Sam?
42 00:05:10.200 ⇒ 00:05:13.400 Samuel Roberts: Yeah, I was able to… the ones that I unzipped,
43 00:05:13.530 ⇒ 00:05:20.299 Samuel Roberts: I thought we were just trying to merge them all, so it was just not a bunch of them. I didn’t realize they were. Let me… let me get that open again, because I don’t think I have that.
44 00:05:20.930 ⇒ 00:05:23.680 Demilade: Yeah, because I did some… I did some queries on some of the data, so I’m.
45 00:05:23.680 ⇒ 00:05:24.670 Samuel Roberts: Yeah, I…
46 00:05:25.690 ⇒ 00:05:27.979 Demilade: If there’s some in particular that didn’t work.
47 00:05:28.450 ⇒ 00:05:33.960 Samuel Roberts: Yeah, I think the trick was to use, like, a certain… yeah, so what I had done was, there.
48 00:05:33.960 ⇒ 00:05:37.379 Uttam Kumaran: Well, all the ones in your note are all TSVs.
49 00:05:39.030 ⇒ 00:05:40.050 Samuel Roberts: Oh…
50 00:05:40.930 ⇒ 00:05:41.370 Uttam Kumaran: Yeah.
51 00:05:41.370 ⇒ 00:05:43.370 Samuel Roberts: Maybe I just ignored the other ones then, but would they…
52 00:05:43.370 ⇒ 00:05:45.249 Uttam Kumaran: I think that’s what I thought, yeah.
53 00:05:45.600 ⇒ 00:05:48.909 Samuel Roberts: Hold on, let me see what happens if I run it without the CSV extension.
54 00:05:50.350 ⇒ 00:05:51.000 Samuel Roberts: It’s a big one.
55 00:05:51.000 ⇒ 00:05:54.710 Uttam Kumaran: But, like, those files aren’t the ones in question.
56 00:05:55.570 ⇒ 00:05:56.729 Uttam Kumaran: I don’t think.
57 00:05:57.360 ⇒ 00:06:01.650 Demilade: Yes, that’s what I’m trying… that’s why I asked, like, what… which data could not be queried, because…
58 00:06:01.650 ⇒ 00:06:02.740 Samuel Roberts: That’s what I’m… yeah.
59 00:06:09.150 ⇒ 00:06:12.139 Samuel Roberts: Was it in the engagement report or the segment export?
60 00:06:12.510 ⇒ 00:06:14.630 Uttam Kumaran: Yeah, Mustafa, which subfolder is it?
61 00:06:14.630 ⇒ 00:06:16.480 Mustafa Raja: approved. Segment export.
62 00:06:17.220 ⇒ 00:06:18.010 Samuel Roberts: segment.
63 00:06:19.020 ⇒ 00:06:20.830 Uttam Kumaran: But where are the text files?
64 00:06:23.440 ⇒ 00:06:25.439 Mustafa Raja: I can send the LinkedIn chat.
65 00:06:25.440 ⇒ 00:06:30.020 Samuel Roberts: Okay, I see a .txt here, let me query this one specifically and see, because it might just be…
66 00:06:30.650 ⇒ 00:06:35.569 Samuel Roberts: like, labeled TXT, I did see some of that, I just tried to re-upload whatever they were called, but…
67 00:06:36.070 ⇒ 00:06:36.740 Uttam Kumaran: Okay.
68 00:06:41.590 ⇒ 00:06:44.290 Samuel Roberts: Let me just drop that one in real quick to test.
69 00:06:45.310 ⇒ 00:06:48.510 Samuel Roberts: Sorry, I thought… when we were talking about it earlier, I thought it was just a,
70 00:06:49.890 ⇒ 00:06:51.390 Samuel Roberts: Yeah, well, I can stop this one.
71 00:06:53.830 ⇒ 00:06:57.420 Uttam Kumaran: Okay, so I’m gonna… so then, yeah, I think the other stuff we’re gonna work on…
72 00:06:57.670 ⇒ 00:07:02.200 Uttam Kumaran: Is we need to do a larger architecture session on the daily flash report.
73 00:07:02.400 ⇒ 00:07:08.450 Uttam Kumaran: So, Sam and I started an architecture diagram. I think Casey’s gonna round that out, and then…
74 00:07:08.720 ⇒ 00:07:13.099 Uttam Kumaran: we can do an architecture review, hopefully, like, Monday or Tuesday.
75 00:07:13.390 ⇒ 00:07:23.389 Uttam Kumaran: One thing, like, broadly, is I think we need to do a couple of different architecture reviews across a couple other clients. Like, for ABC, we’re gonna do one. For…
76 00:07:23.390 ⇒ 00:07:24.430 Samuel Roberts: Let’s see what it did here.
77 00:07:24.430 ⇒ 00:07:26.399 Uttam Kumaran: For Insomnia, we’re gonna do one.
78 00:07:26.970 ⇒ 00:07:39.680 Uttam Kumaran: So I think I’ll just loop in sort of folks, like, kind of like this crew when we do those, and it’ll probably be, like, hour-long meetings where we can talk about the architecture, and then we can propose solutions. So I think I’ll have Awashtemalade
79 00:07:40.060 ⇒ 00:07:44.330 Uttam Kumaran: Soran, you guys there as well, sometime. It’ll be early next week, I think.
80 00:07:46.710 ⇒ 00:07:54.740 Uttam Kumaran: Cool, so I think the biggest thing today is Robert has to review, your work,
81 00:07:55.620 ⇒ 00:08:00.809 Uttam Kumaran: Demolade. I saw your note yesterday, so that’s…
82 00:08:01.050 ⇒ 00:08:06.530 Uttam Kumaran: on him to take a look at that. That is, which…
83 00:08:06.530 ⇒ 00:08:10.880 Demilade: Sure. I moved it to internal reviews. Oh, yeah. Cool.
84 00:08:17.610 ⇒ 00:08:21.299 Samuel Roberts: Okay, I see the text files are… they look like they’re JSON-L files.
85 00:08:21.510 ⇒ 00:08:22.340 Samuel Roberts: Potentially.
86 00:08:22.340 ⇒ 00:08:23.160 Mustafa Raja: Yeah.
87 00:08:23.270 ⇒ 00:08:24.010 Mustafa Raja: So… Okay.
88 00:08:24.010 ⇒ 00:08:25.169 Samuel Roberts: That makes sense. I get it now.
89 00:08:25.170 ⇒ 00:08:27.119 Mustafa Raja: Yeah, so we do need to convert, like.
90 00:08:27.440 ⇒ 00:08:29.920 Samuel Roberts: I think so, yeah, I don’t think it’ll read that,
91 00:08:31.340 ⇒ 00:08:32.690 Samuel Roberts: Actually, let me see if there’s a…
92 00:08:34.270 ⇒ 00:08:39.100 Samuel Roberts: We text… no, no, there’s no JSON. Yeah, okay, never mind, I understand that.
93 00:08:39.230 ⇒ 00:08:41.740 Samuel Roberts: I think I just tested it in CSVs. I get it.
94 00:08:43.390 ⇒ 00:08:50.509 Uttam Kumaran: Yeah, so I think, so I think this is pretty clear, Demolade. I think,
95 00:08:50.940 ⇒ 00:08:53.410 Uttam Kumaran: Robert just needs to give you a review on this, so…
96 00:08:53.600 ⇒ 00:08:58.329 Uttam Kumaran: That’s great. I appreciate you taking the time yesterday to do this.
97 00:08:58.640 ⇒ 00:09:02.030 Uttam Kumaran: And then, ideally, I think the next steps
98 00:09:02.130 ⇒ 00:09:09.310 Uttam Kumaran: In terms of data modeling on this client, is as soon as we have the raw, like, 13 million records for the users.
99 00:09:09.480 ⇒ 00:09:13.240 Uttam Kumaran: We’ll start to build… we can start to build out
100 00:09:13.840 ⇒ 00:09:20.539 Uttam Kumaran: several other things around order campaigns, like the linkage.
101 00:09:21.560 ⇒ 00:09:29.410 Demilade: Yeah, so I, like, I think a very easy win, based off the data that we have, is based off the characteristics that we can see.
102 00:09:29.620 ⇒ 00:09:33.800 Demilade: Like, champions and… value customers.
103 00:09:34.270 ⇒ 00:09:51.699 Demilade: We can start to set triggers for that, so that we can quickly see who the high-value customers are as they, you know, join the platform. So there’s a high-value new customers, but we can actually supercharge it and ensure that we are doing it as soon as they engage in any behavior.
104 00:09:51.860 ⇒ 00:09:58.220 Demilade: ties them to be, like, champion’s behavior, which is, champions are basically, they hire you customers, basically.
105 00:09:59.030 ⇒ 00:10:04.790 Demilade: So, yes, once we have those triggers, we can have them Or, like, campaigns.
106 00:10:05.620 ⇒ 00:10:20.690 Demilade: low value, high value, and we can have that, like, almost on a regular basis, such that they can… you can have a reverse ETL, they can use that for their campaign. They’re more strategic with their campaign. So they pull dollars where it should go to.
107 00:10:21.000 ⇒ 00:10:25.079 Demilade: Just those people who… might not just convert to such a high view.
108 00:10:26.080 ⇒ 00:10:26.710 Uttam Kumaran: Okay.
109 00:10:30.980 ⇒ 00:10:37.899 Uttam Kumaran: Okay, so, I mean, I read it through, I think it’s valid, I think it’s gonna be up to Robert to tell you, like, which
110 00:10:38.870 ⇒ 00:10:43.819 Uttam Kumaran: segments are worth it versus not. Like, looking at it, I feel like it’s probably too many.
111 00:10:44.220 ⇒ 00:10:45.390 Uttam Kumaran: By the gas.
112 00:10:45.630 ⇒ 00:10:48.529 Uttam Kumaran: But let’s see what he says, so…
113 00:10:48.530 ⇒ 00:10:55.860 Demilade: Yeah, there are definitely too many. That’s part of recommendations to, like, combine some of them, because there were some very similar characteristics.
114 00:10:57.640 ⇒ 00:11:06.160 Uttam Kumaran: And then also, I think this is gonna be our first pass at this, but we’re gonna start to loop in orders and campaigns, like other data, so hopefully we’ll have more
115 00:11:06.810 ⇒ 00:11:08.909 Uttam Kumaran: Opportunity to do segments.
116 00:11:09.060 ⇒ 00:11:20.309 Uttam Kumaran: The other thing that’s important here is we also started, like, doing, Segments based on, like, products.
117 00:11:20.600 ⇒ 00:11:24.599 Uttam Kumaran: I… let me see if we have that, so you can take a look.
118 00:11:35.520 ⇒ 00:11:45.689 Uttam Kumaran: And this is something I think Demolade wants, I can… we can start a move to your plate also. We just need to do a similar sort of, like, segmentation exercise.
119 00:11:45.960 ⇒ 00:11:52.400 Uttam Kumaran: for… Insomnia, like, kind of, like, similar to what we did for… Eden.
120 00:11:52.830 ⇒ 00:11:57.469 Uttam Kumaran: Robert did a first pass on this, so I’m gonna wait for him to…
121 00:11:57.630 ⇒ 00:12:00.980 Uttam Kumaran: To give you the information on that, and then we can find out next steps.
122 00:12:02.750 ⇒ 00:12:03.760 Demilade: Okay, sounds good.
123 00:12:04.720 ⇒ 00:12:05.500 Uttam Kumaran: Cool.
124 00:12:06.110 ⇒ 00:12:07.270 Uttam Kumaran: Quick, quick update.
125 00:12:07.270 ⇒ 00:12:10.240 Samuel Roberts: I was able to read in those text files as JSON into Mother Duck.
126 00:12:11.000 ⇒ 00:12:15.409 Uttam Kumaran: Oh, okay then, we don’t need to do any transformation then.
127 00:12:15.560 ⇒ 00:12:16.620 Uttam Kumaran: Mustafa.
128 00:12:16.620 ⇒ 00:12:25.439 Mustafa Raja: Yeah, yeah, it’ll only be the script that, Sam wrote earlier, to convert a zip, to PHT.
129 00:12:26.040 ⇒ 00:12:27.860 Samuel Roberts: Well, they’re already unzipped.
130 00:12:27.860 ⇒ 00:12:28.280 Mustafa Raja: They’re already.
131 00:12:28.280 ⇒ 00:12:29.280 Samuel Roberts: In the Brain Forge folder.
132 00:12:29.280 ⇒ 00:12:30.359 Mustafa Raja: So, so…
133 00:12:30.360 ⇒ 00:12:31.159 Samuel Roberts: Or did I miss something?
134 00:12:31.160 ⇒ 00:12:33.220 Mustafa Raja: I made a new export.
135 00:12:33.940 ⇒ 00:12:35.830 Uttam Kumaran: Yeah, we did a new export last night.
136 00:12:35.830 ⇒ 00:12:36.580 Mustafa Raja: The…
137 00:12:36.580 ⇒ 00:12:37.770 Samuel Roberts: Oh, okay.
138 00:12:37.770 ⇒ 00:12:41.659 Mustafa Raja: It did not include all of the… all of the users, all of the users.
139 00:12:41.660 ⇒ 00:12:45.030 Uttam Kumaran: Well, how long… how long did it take… how long did it take you to run, Sam?
140 00:12:47.810 ⇒ 00:12:56.139 Samuel Roberts: I don’t know, I kept… it messed up my machine, and I had to keep, like, retooling the script to clean up memory and stuff, so… I can rerun it probably pretty quickly.
141 00:12:56.490 ⇒ 00:13:00.729 Uttam Kumaran: Oh, yeah, then Mustafa, just hand this to Sam today, because he already has it up on his end.
142 00:13:00.730 ⇒ 00:13:01.649 Mustafa Raja: Yeah, let me…
143 00:13:01.650 ⇒ 00:13:04.620 Uttam Kumaran: Can you just send… can you just send them the… send him the folder?
144 00:13:04.870 ⇒ 00:13:09.470 Uttam Kumaran: and then send them the folder in Slack, And then also…
145 00:13:09.610 ⇒ 00:13:11.360 Uttam Kumaran: Sam, if you could just, like, put it…
146 00:13:11.940 ⇒ 00:13:21.269 Uttam Kumaran: somewhere in a folder that’s dated as, like, October 23rd export, because these are all time-bound exports, meaning, like, it’s a one-time of everything.
147 00:13:21.530 ⇒ 00:13:26.990 Samuel Roberts: Right. I don’t know yet how we’re gonna do incremental, so I do want to have, like, some understanding that this folder is…
148 00:13:27.400 ⇒ 00:13:29.239 Uttam Kumaran: The one we did today, so…
149 00:13:29.240 ⇒ 00:13:33.600 Samuel Roberts: Okay. So, like, in the Brainforge folder on the S3, put a dated folder and do everything in there?
150 00:13:34.050 ⇒ 00:13:34.720 Uttam Kumaran: Yeah.
151 00:13:34.960 ⇒ 00:13:35.829 Samuel Roberts: Okay, yep.
152 00:13:35.830 ⇒ 00:13:39.050 Awaish Kumar: ways to data store integration, is it not?
153 00:13:39.240 ⇒ 00:13:41.030 Awaish Kumar: Continuously moving data.
154 00:13:42.550 ⇒ 00:13:46.550 Uttam Kumaran: We just haven’t… I haven’t looked at it yet, but definitely not.
155 00:13:46.910 ⇒ 00:13:55.939 Uttam Kumaran: So this is something that, like, we just wanna… I just wanna give as much info as we have to the team, and then it’ll buy us a little bit more time to think about the architecture here.
156 00:13:56.260 ⇒ 00:13:59.690 Uttam Kumaran: Okay. I have to… we’ll have to call… let’s talk to Braze, or…
157 00:13:59.870 ⇒ 00:14:02.750 Samuel Roberts: Yeah. Yeah, figure out some type of ETL solution here.
158 00:14:05.170 ⇒ 00:14:06.870 Uttam Kumaran: Cool. Okay, great.
159 00:14:07.350 ⇒ 00:14:13.960 Uttam Kumaran: Nice. Perfect. Let’s talk about… Eden?
160 00:14:14.160 ⇒ 00:14:17.319 Uttam Kumaran: So, I don’t know, Zoran, if you’re on…
161 00:14:17.960 ⇒ 00:14:22.970 Uttam Kumaran: And then, so, Weish, you’re… you’re… you’re missing all the fun with more catalysts?
162 00:14:23.170 ⇒ 00:14:29.510 Uttam Kumaran: work. But yeah, Zoran, if you want to give maybe the update on how things are going.
163 00:14:29.920 ⇒ 00:14:42.999 Zoran Selinger: Sure, so Ron and myself, we took care of the client side, so the orders should now have the order alias in Catalyst. That’s basically the Basque order ID.
164 00:14:43.000 ⇒ 00:14:56.890 Zoran Selinger: So the order ID is the transaction, basically, ID, starting with PI underscore, that’s in the order ID field in Catalyst, and the order alias is basically Basque’s order ID.
165 00:14:57.460 ⇒ 00:15:15.209 Zoran Selinger: We spent quite a bit of time on it yesterday, because Evan called my friend that works specifically in Google on GA4 and GTM, and he has never heard of what we encountered yesterday. So,
166 00:15:15.400 ⇒ 00:15:26.430 Zoran Selinger: We had to put a little bit of a delay on reading the variable in the data layer, even though it’s pushed.
167 00:15:26.720 ⇒ 00:15:38.860 Zoran Selinger: It’s there, the preview screen shows it’s there, but the code that executes doesn’t see it, so we had to… we had to put… put a little bit of a kind of looping delay.
168 00:15:39.300 ⇒ 00:15:54.660 Zoran Selinger: And then it stops looping when it finally becomes available. It’s very weird. We’ve never seen anything like it before. So… but it works now. We tested it in multiple intakes.
169 00:15:55.190 ⇒ 00:16:02.690 Zoran Selinger: Now, what’s still left to do is the updating of the order status.
170 00:16:03.070 ⇒ 00:16:20.169 Zoran Selinger: On the backend, right? So that’s still… I think we’re still not done with that. I think that still happens manually. We’re still pushing that manually. But, I know we… we initially set it up, with,
171 00:16:20.530 ⇒ 00:16:23.759 Zoran Selinger: With destination functions in segment.
172 00:16:24.210 ⇒ 00:16:27.079 Zoran Selinger: But we don’t have the order alias there.
173 00:16:27.680 ⇒ 00:16:29.959 Zoran Selinger: It’s not available in segment.
174 00:16:30.090 ⇒ 00:16:32.979 Zoran Selinger: A day or two after that.
175 00:16:33.450 ⇒ 00:16:37.759 Zoran Selinger: Henry and Rob… and Rob wanted to,
176 00:16:38.070 ⇒ 00:16:55.559 Zoran Selinger: to find a way to do it, and we were pretty confident they would find a way to do it, but they didn’t, I think. So we’re still missing that, basically server-to-server piece. The updating of the order status is still something that we’re missing.
177 00:16:56.070 ⇒ 00:16:57.160 Zoran Selinger: Nope.
178 00:16:57.160 ⇒ 00:17:11.220 Awaish Kumar: When I met Henry and Rayan, they were talking about setting order alias, like, as you said, you have set up that in pixels. From server to side, we set up the destination function, and
179 00:17:11.359 ⇒ 00:17:18.319 Awaish Kumar: With Henry, and like, we’re just getting all the fields which were available in the…
180 00:17:18.460 ⇒ 00:17:22.019 Awaish Kumar: order summary table and push… pushing it out. We might just have to…
181 00:17:22.200 ⇒ 00:17:27.950 Awaish Kumar: Rename a field, older ID as alias order ID, regret loose.
182 00:17:28.260 ⇒ 00:17:29.060 Zoran Selinger: Okay.
183 00:17:31.400 ⇒ 00:17:34.450 Zoran Selinger: Yeah, so that’s… that’s been the focus. I’m…
184 00:17:34.650 ⇒ 00:17:38.320 Zoran Selinger: I’m not aware of anything else there.
185 00:17:41.820 ⇒ 00:17:49.330 Uttam Kumaran: So, I guess, give me a sense of, like, I know we have our Notion doc for the plan, what is, like, the play-by-play today?
186 00:17:52.890 ⇒ 00:17:57.769 Zoran Selinger: So I have to catch up on the conversations that Orion is currently having.
187 00:17:58.730 ⇒ 00:18:02.270 Zoran Selinger: with, with Carly’s directly.
188 00:18:08.530 ⇒ 00:18:12.779 Zoran Selinger: Oh, looks like I’m needed in another meeting.
189 00:18:12.780 ⇒ 00:18:13.480 Uttam Kumaran: Okay.
190 00:18:13.900 ⇒ 00:18:28.049 Zoran Selinger: I was just… I just opened it, and I see that Ryan has a… has a message for me, and looks like Henry… Henry says that I’m needed in this, in this… it’s probably Kylie’s meeting.
191 00:18:28.050 ⇒ 00:18:41.799 Uttam Kumaran: Okay. Do you guys want to go there, and then, like, can you guys just send me a Slack? Because yesterday, I messaged Robert, he said he thought it was done, I couldn’t get ahold of Henry, and I didn’t know that this issue is still going.
192 00:18:41.950 ⇒ 00:18:43.719 Uttam Kumaran: And I woke up in the morning, and I said…
193 00:18:43.720 ⇒ 00:18:45.160 Zoran Selinger: I didn’t know anything. Number one.
194 00:18:45.590 ⇒ 00:18:46.870 Uttam Kumaran: Yeah, okay, okay.
195 00:18:46.970 ⇒ 00:18:50.580 Zoran Selinger: Because we tested it on the call.
196 00:18:50.580 ⇒ 00:18:54.379 Uttam Kumaran: Okay, so this is a net new… This is, like…
197 00:18:54.910 ⇒ 00:19:03.729 Uttam Kumaran: Okay, okay, I see. Alright, great. That’s what I’m just trying to get at, is, like, was there something else? So it seems like we’ve put a fix in, it just wasn’t…
198 00:19:03.880 ⇒ 00:19:06.160 Uttam Kumaran: And we tested it, and it just wasn’t everything.
199 00:19:06.160 ⇒ 00:19:15.370 Zoran Selinger: Yeah, if there is a… if there is a problem, then it’s… it’s something that… something in Catalyst interface doesn’t show us what we… what we intended.
200 00:19:15.560 ⇒ 00:19:17.940 Zoran Selinger: So let’s… let’s go debug.
201 00:19:18.920 ⇒ 00:19:23.519 Zoran Selinger: Okay, I’m gonna join that call now. Seems to be pretty urgent.
202 00:19:24.270 ⇒ 00:19:25.309 Uttam Kumaran: Okay, okay, alright.
203 00:19:25.310 ⇒ 00:19:25.730 Zoran Selinger: Okay.
204 00:19:25.730 ⇒ 00:19:26.460 Uttam Kumaran: Thanks, Ron.
205 00:19:26.590 ⇒ 00:19:27.280 Zoran Selinger: Cheers.
206 00:19:27.860 ⇒ 00:19:41.939 Uttam Kumaran: Thanks. So yeah, I guess I wish that’s the current, like, status, is, like, we’ve been trying to push this. I think, like, given the amount of time that’s going to that, like, I’m gonna start pushing stuff on Eden back.
207 00:19:42.290 ⇒ 00:19:48.469 Uttam Kumaran: Because I don’t know, like, Amber, I don’t know how much time Zoran and Henry are spending, or, like, logging.
208 00:19:48.620 ⇒ 00:19:51.930 Uttam Kumaran: But, like, I assume that’s taking up the entire cycle.
209 00:19:53.180 ⇒ 00:19:54.130 Awaish Kumar: Yeah.
210 00:19:56.150 ⇒ 00:19:59.240 Demilade: Also, there was a request from, Stuart.
211 00:19:59.460 ⇒ 00:20:07.030 Demilade: I just dropped it in the client’s Aiden channel, where I’m asking Henry about it. Basically, they need an extract
212 00:20:07.310 ⇒ 00:20:10.169 Demilade: from the day before the AWS outage.
213 00:20:10.620 ⇒ 00:20:14.089 Demilade: They just need, the columns are there.
214 00:20:15.820 ⇒ 00:20:23.659 Demilade: I do want to just pull a random BigQuery table, because I wanted to be sure what they were using and what they had created for enough beam.
215 00:20:27.070 ⇒ 00:20:28.880 Uttam Kumaran: Yeah, let me open that.
216 00:20:31.380 ⇒ 00:20:35.730 Demilade: I asked Henry about it, but he hasn’t responded yet, so I assume he’s in a meeting or something.
217 00:20:47.460 ⇒ 00:20:48.970 Uttam Kumaran: Okay,
218 00:20:49.100 ⇒ 00:20:56.169 Uttam Kumaran: Is this something urgent? I guess this is something urgent this week. Amber and Awash, like, what should we do about this? Let me share my screen.
219 00:21:03.570 ⇒ 00:21:10.310 Demilade: I mean, ultimately, I think it’s a simple request. Sometimes, if there’s a table or a query that is the templates for the answer, sure.
220 00:21:10.790 ⇒ 00:21:19.880 Demilade: ultimately, I just don’t want to do something, and then it’s like, oh no, this is the wrong data, but I’d already sent it. That’s kind of why I looked.
221 00:21:19.880 ⇒ 00:21:20.550 Uttam Kumaran: Okay.
222 00:21:32.120 ⇒ 00:21:32.840 Awaish Kumar: Like…
223 00:21:34.110 ⇒ 00:21:40.329 Awaish Kumar: Like, what is the issue here? Like, I didn’t get, like, we can get this data from BigQuery and…
224 00:21:40.480 ⇒ 00:21:41.339 Awaish Kumar: Send it to them.
225 00:21:41.340 ⇒ 00:21:42.050 Demilade: Yeah, we…
226 00:21:42.050 ⇒ 00:21:44.520 Uttam Kumaran: The issue is just, like, you just need validation for the query.
227 00:21:44.950 ⇒ 00:21:45.990 Demilade: Yeah, exactly.
228 00:21:46.130 ⇒ 00:21:48.870 Demilade: if I send some data and Henry’s like.
229 00:21:48.870 ⇒ 00:21:51.500 Uttam Kumaran: I’m glad it’s not working on the attribution stuff, yeah, yeah.
230 00:21:51.500 ⇒ 00:22:00.080 Demilade: Exactly. So, I don’t want to push data that Herring looks at and goes, actually, no, this is the wrong data you sent, or we’ve updated something about this data.
231 00:22:00.620 ⇒ 00:22:01.620 Demilade: That’s what I said.
232 00:22:02.040 ⇒ 00:22:02.600 Demilade: about.
233 00:22:02.600 ⇒ 00:22:07.949 Uttam Kumaran: So then… so then I’ll… yeah, let’s just have… I’ll just have Henry do this, unless, Awesha, you know.
234 00:22:08.280 ⇒ 00:22:10.150 Uttam Kumaran: You’re confident that you can pull this.
235 00:22:14.040 ⇒ 00:22:16.760 Demilade: For instance, like, the hashed IP, I’m not sure where that’s coming from.
236 00:22:23.040 ⇒ 00:22:25.120 Demilade: Okay, so like… It’s just little kids.
237 00:22:26.820 ⇒ 00:22:34.130 Awaish Kumar: Okay, it’s for orders data, like, in the order, like, completed table, we will have
238 00:22:34.360 ⇒ 00:22:37.030 Awaish Kumar: I think almost all of these columns there
239 00:22:37.470 ⇒ 00:22:40.470 Awaish Kumar: And, that’s where we are.
240 00:22:42.260 ⇒ 00:22:46.900 Awaish Kumar: like… Trying to get the correct attribution for NorthMate.
241 00:22:47.730 ⇒ 00:22:54.330 Uttam Kumaran: Yeah, so do you want to just pull that away, or do you want to… I could just wait… the decision is you pull it, or we wait for Henry.
242 00:22:54.330 ⇒ 00:22:55.580 Awaish Kumar: Yeah, I can do that.
243 00:22:56.070 ⇒ 00:22:57.479 Uttam Kumaran: Okay, okay, okay, great.
244 00:22:58.290 ⇒ 00:22:59.910 Uttam Kumaran: So then let me create a ticket for that.
245 00:23:05.310 ⇒ 00:23:05.920 Awaish Kumar: Hold on.
246 00:23:08.140 ⇒ 00:23:15.010 Awaish Kumar: The… yeah, the issue with the North Beam, yeah, Zoron is not here, I… Like, I got a…
247 00:23:15.170 ⇒ 00:23:23.620 Awaish Kumar: IP addresses and the… The API key being used to send data to Nordspeam.
248 00:23:24.490 ⇒ 00:23:33.310 Awaish Kumar: And we don’t have any script in our core base, or in GCP.
249 00:23:33.400 ⇒ 00:23:35.610 Uttam Kumaran: Which is sending the data northbound.
250 00:23:36.020 ⇒ 00:23:40.650 Awaish Kumar: And we have asked… I have asked, AT&T, but they don’t know either.
251 00:23:40.830 ⇒ 00:23:44.520 Awaish Kumar: I’m not sure, like… What else to look for now?
252 00:23:45.680 ⇒ 00:23:47.870 Uttam Kumaran: But did you put… did we talk to Northbeam yet?
253 00:23:48.950 ⇒ 00:24:04.969 Awaish Kumar: I sent a request to Northbeam, asking for, like, helping me identify which API key is being used. They have sent me the API key, which is being used. They have sent some IP addresses, and user agent is Python. That means it’s a script.
254 00:24:05.880 ⇒ 00:24:06.400 Uttam Kumaran: Yeah.
255 00:24:06.790 ⇒ 00:24:07.600 Awaish Kumar: But where’s…
256 00:24:07.600 ⇒ 00:24:10.839 Uttam Kumaran: So, so we should just do your plan, which is we should cancel it, right?
257 00:24:12.880 ⇒ 00:24:18.999 Awaish Kumar: You mean we… but who is going to, like, from where we cancel it? We don’t know where it’s running.
258 00:24:21.390 ⇒ 00:24:23.920 Uttam Kumaran: No, you nixed the Northbeam API key.
259 00:24:24.570 ⇒ 00:24:31.099 Awaish Kumar: Oh, I just… yeah, that’s what I… I recommended, like, you can just… Delete that key, and…
260 00:24:32.600 ⇒ 00:24:37.639 Uttam Kumaran: But I guess my point is, like, do you need that data? Do you need that to continue?
261 00:24:38.210 ⇒ 00:24:43.799 Awaish Kumar: We need that data, but… We don’t want to send data,
262 00:24:44.260 ⇒ 00:24:54.269 Awaish Kumar: like, multiple times. So, Zoran wanted to know, like, what… from where we are sending the data, so that we know what is being sent, and what else… Okay.
263 00:24:54.810 ⇒ 00:24:56.059 Uttam Kumaran: Is there a ticket for that?
264 00:24:56.810 ⇒ 00:25:03.640 Awaish Kumar: There was… there was, I moved it to Durham, I think, maybe.
265 00:25:03.970 ⇒ 00:25:06.910 Awaish Kumar: When I identify the dead keys.
266 00:25:20.220 ⇒ 00:25:21.590 Uttam Kumaran: Which one is it?
267 00:25:31.650 ⇒ 00:25:32.549 Awaish Kumar: It was…
268 00:25:36.420 ⇒ 00:25:37.850 Awaish Kumar: North screen?
269 00:25:39.790 ⇒ 00:25:47.130 Uttam Kumaran: Okay, I can just make a new one, but yeah, I just want to close that one out. So, the solution there is…
270 00:25:52.510 ⇒ 00:26:01.319 Uttam Kumaran: Basically, it’s like, identify… Source of… like, North Beam…
271 00:26:02.660 ⇒ 00:26:04.030 Robert Tseng: Data input.
272 00:26:04.380 ⇒ 00:26:05.549 Uttam Kumaran: Hey, hey, hey.
273 00:26:07.250 ⇒ 00:26:11.890 Uttam Kumaran: And so for this one… We…
274 00:26:12.500 ⇒ 00:26:16.290 Uttam Kumaran: Basically, what we’ve done so far is, like, we asked North Beam.
275 00:26:16.690 ⇒ 00:26:17.860 Awaish Kumar: They…
276 00:26:18.270 ⇒ 00:26:23.839 Uttam Kumaran: They gave us the… like, IPs.
277 00:26:23.990 ⇒ 00:26:28.150 Uttam Kumaran: End user agent. We can’t identify.
278 00:26:28.560 ⇒ 00:26:35.830 Uttam Kumaran: So the recommendation… Is… just cancel… the NB API key.
279 00:26:37.960 ⇒ 00:26:38.960 Awaish Kumar: Yes.
280 00:26:39.330 ⇒ 00:26:40.979 Uttam Kumaran: And then, like, was there any risk?
281 00:26:40.980 ⇒ 00:26:44.990 Awaish Kumar: Yeah, the risk, like, risk is that we…
282 00:26:45.180 ⇒ 00:26:56.309 Awaish Kumar: the dot beam will identify… will not identify them as fully tracked, because they will not receive any server-side response for orders.
283 00:26:56.740 ⇒ 00:27:00.319 Awaish Kumar: So we have to cancel it.
284 00:27:00.640 ⇒ 00:27:05.239 Awaish Kumar: At the same time when we are ready for… with the script, to send the data to our screen.
285 00:27:05.970 ⇒ 00:27:09.859 Uttam Kumaran: Okay, and then, so what… so… where’s that second part?
286 00:27:10.980 ⇒ 00:27:14.080 Awaish Kumar: So right now, like, we,
287 00:27:14.300 ⇒ 00:27:24.610 Awaish Kumar: don’t have, like, we have been investigating, right? So we don’t have any… anything ready after we use Polyatomic, or we write our own script with the… with the…
288 00:27:24.890 ⇒ 00:27:31.340 Awaish Kumar: the data which needs to be sent, and once we are ready to deploy it, we can cancel this and use the new API key.
289 00:27:32.130 ⇒ 00:27:32.830 Uttam Kumaran: Okay.
290 00:27:35.220 ⇒ 00:27:37.500 Uttam Kumaran: So then that’s the solution. Yeah, I mean…
291 00:27:37.700 ⇒ 00:27:42.120 Uttam Kumaran: Probably someone set it up at some other point, I don’t… I have no clue. We can’t find out, then…
292 00:27:42.660 ⇒ 00:27:44.650 Uttam Kumaran: Nobody else is gonna know, so…
293 00:27:44.850 ⇒ 00:27:50.610 Uttam Kumaran: So, I guess, tell me, like, what’s the next steps here? Like, we just logged this… we have this information logged.
294 00:27:51.400 ⇒ 00:27:58.039 Awaish Kumar: I just have to meet with, like, Zoran on understanding what data needs to be sent.
295 00:27:58.540 ⇒ 00:28:01.239 Awaish Kumar: Once we have that,
296 00:28:01.430 ⇒ 00:28:06.489 Awaish Kumar: then we have to figure out if we are going to use Polyatomic for it, or write our own script.
297 00:28:07.010 ⇒ 00:28:10.479 Awaish Kumar: After that, like, just use whatever solution.
298 00:28:11.320 ⇒ 00:28:14.479 Uttam Kumaran: Is this a… this… can this be done? Can we do this next week?
299 00:28:17.030 ⇒ 00:28:22.140 Awaish Kumar: Like, we can come up with a script this week, but yeah, we can deploy it on Monday, maybe.
300 00:28:22.610 ⇒ 00:28:26.470 Uttam Kumaran: Well, like, meaning, like, does… does this have to happen this week?
301 00:28:28.410 ⇒ 00:28:33.280 Awaish Kumar: I don’t think so. We can… Okay.
302 00:28:33.520 ⇒ 00:28:40.809 Uttam Kumaran: That’s the answer I want to hear. Like, is it urgent? Not urgent, then don’t worry about it. We’ll do it next week.
303 00:28:46.560 ⇒ 00:28:52.109 Awaish Kumar: Yeah, I think Catalyst is much more urgent because they are… they have paid them, but…
304 00:28:52.900 ⇒ 00:29:01.290 Uttam Kumaran: Yeah, so create plan for server-side, or, poly… Tracking for…
305 00:29:02.810 ⇒ 00:29:03.500 Awaish Kumar: Cool.
306 00:29:05.140 ⇒ 00:29:05.680 Uttam Kumaran: Great.
307 00:29:11.110 ⇒ 00:29:14.790 Uttam Kumaran: Can you paste, like, the email here?
308 00:29:15.960 ⇒ 00:29:16.819 Awaish Kumar: Oh, yep.
309 00:29:20.180 ⇒ 00:29:20.770 Uttam Kumaran: Alright.
310 00:29:22.230 ⇒ 00:29:31.619 Uttam Kumaran: Cool. I guess to catch you up, Robert, so Zoran hopped, They fixed it.
311 00:29:32.100 ⇒ 00:29:32.830 Uttam Kumaran: some other issues.
312 00:29:32.830 ⇒ 00:29:36.079 Robert Tseng: I… they… I was, yeah, I was on… they…
313 00:29:36.080 ⇒ 00:29:37.010 Uttam Kumaran: Okay, alright.
314 00:29:37.010 ⇒ 00:29:38.559 Robert Tseng: Yeah, I was on a call with them.
315 00:29:38.660 ⇒ 00:29:40.490 Robert Tseng: It’s… it’s not fixed, yeah.
316 00:29:41.170 ⇒ 00:29:43.830 Uttam Kumaran: Okay. I basically was like, look…
317 00:29:44.310 ⇒ 00:29:52.569 Uttam Kumaran: Yeah, I said, like, look, at the end of the day, yesterday, it seemed like everything was right, and he’s like, yeah, it also… so, I don’t know, I don’t know what I could have done, so…
318 00:29:52.570 ⇒ 00:30:07.470 Robert Tseng: Yeah, I think the solution is I need to go back to what I had already started on Monday and push my solution. I think the way that, whatever, Henry, Zoran and Ryan have been… I just don’t believe that they’re gonna make it… they’re gonna be able to get it to work.
319 00:30:07.510 ⇒ 00:30:14.640 Robert Tseng: In… on the client side. This should just be a… a model, just like how Awish and I set up,
320 00:30:14.660 ⇒ 00:30:37.519 Robert Tseng: segment destinations to push data into meta using a destination function with a model that we’re… that we’re… that we’re running in dbt, like, that’s… that’s what we should do. Like, we have every field that they need there. Like, I don’t know why… I mean, I understand GTM is just very hard to QA. You deploy something, then you wait, like, 12 hours for everything to blow up, and then you have to go and, like.
321 00:30:37.520 ⇒ 00:30:44.890 Robert Tseng: It’s just a very reactive, like, process, so things didn’t actually show up the way that they expected, and we just need to have a backup
322 00:30:44.890 ⇒ 00:30:53.479 Robert Tseng: that’s more stable, that comes from our warehouse, we know exactly, like, what… what field we’re… what fields we’re using. So, I think that’s… that’s what I have to help them with.
323 00:30:53.970 ⇒ 00:31:02.600 Awaish Kumar: Okay, Leah, Robert for… like, we… last week, I helped them, like, create destination function and… and they modeled.
324 00:31:02.820 ⇒ 00:31:03.950 Awaish Kumar: I agree. Yeah.
325 00:31:04.410 ⇒ 00:31:10.849 Awaish Kumar: Like, exactly the way we did, but it’s just that, like, what they were pushing on Catalyst wasn’t…
326 00:31:11.170 ⇒ 00:31:14.280 Awaish Kumar: like, the… exactly what Catalyst needed.
327 00:31:14.550 ⇒ 00:31:17.629 Awaish Kumar: Maybe we need a few more fields to…
328 00:31:17.630 ⇒ 00:31:33.659 Robert Tseng: I think that was it. We just need to add a few more fields, and I was… I was start… I was doing that on Monday before I stepped back, because the team was like, it’s okay, we got it, but I don’t think we got it, so we gotta… we just gotta continue… continue that work that you start… I guess you were working with it last week.
329 00:31:36.670 ⇒ 00:31:44.709 Uttam Kumaran: Okay, so in the meantime, what I said to Amber is, like, we’re probably just running up the hour, so I’m just gonna kinda de-prio stuff.
330 00:31:44.940 ⇒ 00:31:46.240 Uttam Kumaran: Is that fair?
331 00:31:46.660 ⇒ 00:31:51.719 Robert Tseng: Yeah, like, literally nothing else matters, so, like, it… Okay. Yeah. Yeah.
332 00:31:51.720 ⇒ 00:31:52.400 Uttam Kumaran: Okay.
333 00:31:53.490 ⇒ 00:31:57.439 Robert Tseng: I mean, it’s not great for our team, because then people are not utilized, they’re not working, whatever, but, like, we are…
334 00:31:57.440 ⇒ 00:32:07.290 Uttam Kumaran: No, but I just don’t… I just can’t, like… this is… this is an example of a situation where, like, I don’t want to keep doing other stuff, and do this, and then we, like, just don’t make many money this week.
335 00:32:07.290 ⇒ 00:32:07.650 Robert Tseng: X.
336 00:32:07.650 ⇒ 00:32:07.970 Uttam Kumaran: So…
337 00:32:07.970 ⇒ 00:32:08.460 Robert Tseng: Yeah.
338 00:32:08.460 ⇒ 00:32:16.129 Uttam Kumaran: my point here is, like, let’s just deeper… if there’s anything here, so I think still awaits, there’s a couple of tickets that I would like you to…
339 00:32:16.320 ⇒ 00:32:18.340 Awaish Kumar: To take on, which is, like, this…
340 00:32:18.600 ⇒ 00:32:20.210 Uttam Kumaran: Orders, export.
341 00:32:20.350 ⇒ 00:32:27.779 Uttam Kumaran: But is there… if there’s nothing else here that’s, urgent, then I’m gonna… which doesn’t seem like status-wise, I’m gonna move this all back.
342 00:32:31.100 ⇒ 00:32:38.529 Robert Tseng: Sure, but, like, I don’t really think it impacts our margins, because our… the people that are on this account are all fixed anyway, so we just… I mean, we…
343 00:32:38.530 ⇒ 00:32:40.809 Uttam Kumaran: No, Zoron and Henry are not fixed.
344 00:32:41.360 ⇒ 00:32:45.120 Robert Tseng: Yeah, but they need to be involved in this solution, or… or not, like.
345 00:32:45.120 ⇒ 00:32:51.610 Uttam Kumaran: So then… but so then… so then Demolade and… but there’s other… meaning there’s… there’s other client work that we need done.
346 00:32:51.960 ⇒ 00:32:53.020 Robert Tseng: Okay, well, yeah, then just.
347 00:32:53.020 ⇒ 00:32:53.450 Uttam Kumaran: move them over.
348 00:32:53.450 ⇒ 00:32:58.760 Robert Tseng: other stuff, because… Like, we’ll just be running it up, yeah.
349 00:32:59.220 ⇒ 00:33:02.070 Uttam Kumaran: Yeah, there’s insomnia work, and there’s other work, so I just want to shift.
350 00:33:02.070 ⇒ 00:33:03.500 Robert Tseng: Okay, great. Yeah.
351 00:33:03.500 ⇒ 00:33:04.889 Uttam Kumaran: I want to shift resources, yeah.
352 00:33:05.670 ⇒ 00:33:10.700 Uttam Kumaran: Okay, cool.
353 00:33:14.560 ⇒ 00:33:17.210 Uttam Kumaran: And then for this one, we need to do…
354 00:33:17.650 ⇒ 00:33:21.150 Uttam Kumaran: Something with Awash on this COGS architecture review.
355 00:33:21.660 ⇒ 00:33:25.820 Uttam Kumaran: okay…
356 00:33:30.900 ⇒ 00:33:34.459 Uttam Kumaran: Amber, what… did this one get done?
357 00:33:40.810 ⇒ 00:33:42.640 Amber Lin: Not yet.
358 00:33:43.780 ⇒ 00:33:44.280 Uttam Kumaran: Okay.
359 00:33:44.280 ⇒ 00:33:45.570 Amber Lin: I can do that today.
360 00:33:46.510 ⇒ 00:33:51.090 Amber Lin: Demolala, just send me the… send me the numbers, and I can draft a message.
361 00:33:51.090 ⇒ 00:33:53.549 Uttam Kumaran: What is this impact for? This is for…
362 00:33:53.890 ⇒ 00:33:56.760 Amber Lin: This is for… back.
363 00:33:57.310 ⇒ 00:33:59.129 Amber Lin: Yeah, the past data.
364 00:33:59.870 ⇒ 00:34:02.780 Uttam Kumaran: Oh, yeah, for the missing bass.
365 00:34:02.780 ⇒ 00:34:03.290 Amber Lin: X.
366 00:34:03.290 ⇒ 00:34:05.270 Uttam Kumaran: Like, pharmacy, yeah.
367 00:34:09.400 ⇒ 00:34:12.159 Uttam Kumaran: Great. Yeah, if you can do this today, Amber, this would be great.
368 00:34:14.270 ⇒ 00:34:17.539 Amber Lin: I also found the hours in…
369 00:34:17.860 ⇒ 00:34:21.680 Amber Lin: clockified, and currently, this week.
370 00:34:21.960 ⇒ 00:34:28.860 Amber Lin: Henry’s at 13, Zoran’s at 13. I don’t have hours from Lottie yet.
371 00:34:29.310 ⇒ 00:34:33.020 Uttam Kumaran: Okay, yeah, then we’re already gonna be basically at the top, so…
372 00:34:33.420 ⇒ 00:34:36.469 Uttam Kumaran: Okay, cool. So, everything else, I’m gonna move.
373 00:34:38.880 ⇒ 00:34:45.389 Amber Lin: Like, the refunds and stuff for Henry, I think we should move out, because he won’t have time for that anyways.
374 00:34:46.219 ⇒ 00:34:46.829 Uttam Kumaran: Yeah.
375 00:34:49.849 ⇒ 00:34:50.739 Uttam Kumaran: Cool.
376 00:34:51.289 ⇒ 00:34:57.169 Uttam Kumaran: Look, this is, like, the… the day-to-day adjustments that we have to make that we weren’t making, like…
377 00:34:57.539 ⇒ 00:35:03.329 Uttam Kumaran: a couple months ago, that, like, this is, like, what… it’s fine, the client fires will happen.
378 00:35:03.919 ⇒ 00:35:06.729 Uttam Kumaran: But, like, we just… we have to adjust, that’s fine.
379 00:35:06.839 ⇒ 00:35:10.469 Uttam Kumaran: Okay, cool. So… this is great.
380 00:35:10.809 ⇒ 00:35:15.499 Uttam Kumaran: Let’s talk about insomnia.
381 00:35:15.659 ⇒ 00:35:19.319 Uttam Kumaran: If, yeah, if everybody’s good to just stay on for a sec.
382 00:35:19.599 ⇒ 00:35:27.939 Uttam Kumaran: So, update again is, like, we got all the 13 million export into S3, we’re…
383 00:35:28.149 ⇒ 00:35:33.829 Uttam Kumaran: we’re bringing that into Mother Duck for modeling, so that should be done.
384 00:35:34.519 ⇒ 00:35:47.569 Uttam Kumaran: Couple pieces that need review from you, Robert. We… Demolade worked on a, like, basically, segmentation.
385 00:35:48.309 ⇒ 00:35:54.039 Uttam Kumaran: For… Rfm data, For you to review.
386 00:35:54.479 ⇒ 00:35:57.939 Uttam Kumaran: So that would be great.
387 00:35:58.119 ⇒ 00:36:08.309 Uttam Kumaran: And then… We’re also working on, like, an architecture review for the daily scorecard stuff.
388 00:36:09.069 ⇒ 00:36:15.959 Uttam Kumaran: So we should have a proposal next week on, like, new architecture.
389 00:36:19.099 ⇒ 00:36:25.899 Uttam Kumaran: Anything else from, like, Bray’s side, or any other updates? So that should unblock Amber’s work today.
390 00:36:26.639 ⇒ 00:36:30.149 Uttam Kumaran: And that should be done today, probably.
391 00:36:34.160 ⇒ 00:36:36.699 Robert Tseng: Yeah, I’ll review,
392 00:36:38.730 ⇒ 00:36:45.909 Robert Tseng: De Milade’s work. I think the message that I sent, basically, I was on a call with Brace. I know that there was some duplicative effort.
393 00:36:45.930 ⇒ 00:37:02.329 Robert Tseng: I don’t know… I understand we’re using… we’re tapping the Braze endpoints to be able to pull data into an S3 bucket. There is a whole, they call it currents. It’s basically, like, their real-time event stream that
394 00:37:02.640 ⇒ 00:37:06.610 Robert Tseng: It’s available on the platform for us to go and pull that data in.
395 00:37:07.720 ⇒ 00:37:13.700 Robert Tseng: I think my understanding is there’s more data that’s updated more incrementally at the… at the…
396 00:37:13.700 ⇒ 00:37:29.870 Robert Tseng: velocity that we want coming from there. So, I don’t exactly know the difference between what’s in that… what’s in Currents versus what, we’re getting from Braze API currently, but it seems like we should be pulling data from… from Currents.
397 00:37:30.760 ⇒ 00:37:42.859 Robert Tseng: Yeah, and that’s going to resolve the duplicative, like, it’s going to resolve the duplicate transactions, and we’re gonna have to update the marketing performance tracker, because…
398 00:37:43.050 ⇒ 00:37:57.529 Robert Tseng: you know, the way that we’ve been setting up that tracker is we’re just exporting out of Braze’s platform. I was, like, grilling the Braze lady, and she was like, yeah, nobody… none of our customers use our… the Braze platform to really measure conversions. I was like.
399 00:37:57.620 ⇒ 00:38:06.100 Robert Tseng: what the… are you serious? So, I mean, it seems like all of their… all Brace customers export out of Currents.
400 00:38:06.260 ⇒ 00:38:25.340 Robert Tseng: and then they calculate conversions themselves, because… precisely because there’s no deduplication happening there. So, a single order can be counted in multiple campaigns, which, like, was the whole problem in the first place. So, I think if we stop doing… this will… this will fundamentally change the way that we update
401 00:38:25.550 ⇒ 00:38:36.570 Robert Tseng: the tracker, because these exports out of the UI are just, like, not… it’s just not gonna be… it’s not gonna be right. So, we do… I think that’s… that’s what I have learned from… from them.
402 00:38:37.490 ⇒ 00:38:43.890 Uttam Kumaran: So, can… are you… how can I help today to get, like, an update to client on, like, what you learned?
403 00:38:44.340 ⇒ 00:38:44.809 Robert Tseng: I’m gonna say that.
404 00:38:44.810 ⇒ 00:38:45.610 Uttam Kumaran: Monday.
405 00:38:46.090 ⇒ 00:39:00.769 Robert Tseng: Yeah, no, I think, I can… I can share, I can help share the update to them on, like, what we’re doing, like, differently, but… and… but yeah, it’s like, I guess my question is, like, we haven’t tested current, so we don’t actually know, like, how fast can we, like.
406 00:39:01.120 ⇒ 00:39:12.980 Robert Tseng: Yeah. Yeah, you know, I got… I’m hoping by Monday, when the CEO’s back on the call, I can tell him we fixed the problem, and there’s no more duplicate transactions and reporting going forward.
407 00:39:12.980 ⇒ 00:39:16.249 Uttam Kumaran: No way it’s gonna happen by Monday. Monday’s gonna be tough.
408 00:39:16.840 ⇒ 00:39:18.309 Robert Tseng: Well, you know, we’re just gonna…
409 00:39:18.310 ⇒ 00:39:21.090 Uttam Kumaran: We’re low on… we’re low on time already this week, so it’ll have to be…
410 00:39:21.090 ⇒ 00:39:21.509 Robert Tseng: Okay, I mean.
411 00:39:21.510 ⇒ 00:39:22.219 Uttam Kumaran: next week.
412 00:39:22.550 ⇒ 00:39:23.190 Robert Tseng: Okay.
413 00:39:23.190 ⇒ 00:39:29.620 Uttam Kumaran: So the couple things I want to unblock, though, like, this is where I’m not just saying, no, I have something else for you. We should have Amber’s stuff.
414 00:39:29.640 ⇒ 00:39:45.140 Uttam Kumaran: ready, you should have the segment stuff ready, and we should have all the 13 million users in Mother Duck ready for other analysis. So, we’ve made, like, good headway on a couple other things. Okay.
415 00:39:45.240 ⇒ 00:39:59.369 Uttam Kumaran: So, at least we have, again, like, the rest of today and tomorrow before Monday to kind of send updates. I want to send an… I’m gonna send an update. If you don’t mind, I can send an… and you recorded that breaks call, I can basically send an update today.
416 00:39:59.420 ⇒ 00:40:09.360 Uttam Kumaran: like, after this, with, like, some of our updates on S3, some of our updates on the Braze export, the architecture work that we’re doing for the daily stuff, and the speeding.
417 00:40:09.490 ⇒ 00:40:10.139 Uttam Kumaran: And then…
418 00:40:10.140 ⇒ 00:40:10.640 Robert Tseng: Yep.
419 00:40:10.640 ⇒ 00:40:19.049 Uttam Kumaran: Again, you can walk in on Monday saying, hey, we’re reviewing the architecture entirety, we found all these things that are embrace, we’ll come up with a proposal on, like, what to do next.
420 00:40:19.430 ⇒ 00:40:21.600 Uttam Kumaran: Okay. And you’ll have some analysis.
421 00:40:22.350 ⇒ 00:40:22.980 Robert Tseng: Okay.
422 00:40:23.830 ⇒ 00:40:35.800 Uttam Kumaran: So I think the biggest thing today is if you can review and give feedback to Demilade, and then as soon as Amber’s ready, the same thing, we could probably do another pass at stuff tomorrow, and then set you up for Monday.
423 00:40:36.260 ⇒ 00:40:38.050 Robert Tseng: Perfect. Alright, we’ll see that.
424 00:40:39.500 ⇒ 00:40:40.360 Uttam Kumaran: Solid.
425 00:40:43.150 ⇒ 00:40:49.060 Uttam Kumaran: Okay, I’m glad that we make… we’re making… this client, we’re making a lot of strides, and this is a lot of, like, low-hanging fruit stuff, so I’m glad.
426 00:40:49.060 ⇒ 00:40:50.350 Robert Tseng: Yeah.
427 00:40:52.280 ⇒ 00:40:57.240 Uttam Kumaran: Cool. Okay, anything else, like, we want to talk about?
428 00:40:57.970 ⇒ 00:40:59.450 Uttam Kumaran: I guess we could talk about…
429 00:41:00.100 ⇒ 00:41:03.579 Uttam Kumaran: For Remi, you’re just handling stuff, is there anything, like, I can help with there?
430 00:41:04.230 ⇒ 00:41:21.019 Robert Tseng: I don’t believe that Henry extended the analysis, so I might have to take an hour before, just so I’m not, like, just rehashing the same thing, like, whatever, like, I think I’ll… there’s nothing that you have to take on, but the deck is ready, I know what I’m gonna share, but I think I just wanna…
431 00:41:21.440 ⇒ 00:41:26.159 Robert Tseng: do a couple of the follow-ups from last week that I don’t… I don’t really think he got to, so…
432 00:41:27.130 ⇒ 00:41:27.900 Uttam Kumaran: Yeah, do you want, like.
433 00:41:27.900 ⇒ 00:41:28.320 Robert Tseng: Yeah.
434 00:41:28.320 ⇒ 00:41:33.189 Uttam Kumaran: me and you can meet and talk through it if it’s helpful, I don’t know, it’s just… yeah.
435 00:41:33.540 ⇒ 00:41:48.769 Robert Tseng: I mean, I think it’s… it’s, no, I mean, it’s just, like, adding a couple reports. It was so easy. Like, it was just adding a couple reports to one of the dashboards that we shared with them, so it will take me, like, 30 minutes. It’s not gonna take long.
436 00:41:49.350 ⇒ 00:41:50.690 Uttam Kumaran: Okay, cool.
437 00:41:50.690 ⇒ 00:41:57.530 Robert Tseng: But if you want to be at that… at the… on the call with the head of Brock, like, I’m welcome… welcome to introduce you, or whatever, and we can, you know, have you there.
438 00:41:57.530 ⇒ 00:42:01.429 Uttam Kumaran: Yeah, I’d love to… I’d love to be there. Yeah, I’m happy to be there.
439 00:42:01.760 ⇒ 00:42:02.450 Robert Tseng: Okay.
440 00:42:03.120 ⇒ 00:42:10.559 Robert Tseng: Yeah, alright, yeah, I need… I need to send them a message, because I didn’t end up… I don’t know if you guys actually edited the deck that I asked for review yesterday. We did.
441 00:42:10.560 ⇒ 00:42:11.629 Uttam Kumaran: I didn’t… We did.
442 00:42:11.630 ⇒ 00:42:14.629 Robert Tseng: Oh, I didn’t send the message, so I need to send it to them right after this call.
443 00:42:14.630 ⇒ 00:42:20.130 Uttam Kumaran: Yeah, so I’ll just run through that really quickly. Like, you have the summary, you have, like.
444 00:42:20.510 ⇒ 00:42:24.110 Uttam Kumaran: we’ve made all, sort of, the core changes. I think…
445 00:42:24.390 ⇒ 00:42:26.450 Uttam Kumaran: You should just go run through again.
446 00:42:26.720 ⇒ 00:42:27.949 Uttam Kumaran: Yeah, this should be…
447 00:42:27.950 ⇒ 00:42:28.320 Robert Tseng: Okay, fair.
448 00:42:28.320 ⇒ 00:42:29.180 Uttam Kumaran: pretty decent.
449 00:42:29.830 ⇒ 00:42:30.960 Robert Tseng: Cool, thanks.
450 00:42:31.660 ⇒ 00:42:39.090 Uttam Kumaran: Okay, great. So then, I feel pretty good about Insomnia, I feel pretty good about README. On Ellie stuff,
451 00:42:39.880 ⇒ 00:42:51.360 Uttam Kumaran: Yeah, I mean, again, it’s… I think it’s sort of just, like, in-deck world, but if nothing there, then we can just wait until next week to talk about it, since we have another week there. There’s nothing else on our side, like, I’ve pushed everything forward, so…
452 00:42:51.690 ⇒ 00:42:54.000 Uttam Kumaran: Cool.
453 00:42:54.200 ⇒ 00:42:55.609 Uttam Kumaran: And then…
454 00:42:55.610 ⇒ 00:43:12.679 Amber Lin: Question about Remo. I’m… I don’t have context to what happened earlier this week on that meeting. I saw that Serv is not able to come to the demo today. My question is, is the demo with Remo still happening today? Have you played anything? I haven’t seen anything in the chat at all.
455 00:43:15.850 ⇒ 00:43:21.989 Robert Tseng: I think you should… you should nudge them. I don’t think they’ll actually book it, but yeah. I see, I see.
456 00:43:21.990 ⇒ 00:43:27.290 Amber Lin: Because SERP is also not free at that time, so I… Likely that it’s not happening.
457 00:43:27.770 ⇒ 00:43:28.410 Robert Tseng: Oh yeah.
458 00:43:28.770 ⇒ 00:43:33.779 Amber Lin: Yeah, I’ll go… I’ll go grab them for a demo, but I don’t know if they are even ready.
459 00:43:36.670 ⇒ 00:43:41.599 Uttam Kumaran: I mean, yeah, I guess, like, talk to me about the ca- like, are we just still, like, pushing as usual?
460 00:43:42.560 ⇒ 00:43:50.880 Robert Tseng: Yeah, well, I mean, I guess we’re just paying to… we’re just being paid to tell them to book meetings with us and do more demos. Like, I think we’re doing what we should be doing, so I don’t know.
461 00:43:50.880 ⇒ 00:43:53.880 Uttam Kumaran: Okay, so Amber, I’m gonna just put a ticket for that. Yeah.
462 00:43:53.880 ⇒ 00:43:54.440 Robert Tseng: Yeah.
463 00:43:55.000 ⇒ 00:44:06.369 Robert Tseng: Yeah, I mean, they have these open-ended promises that they’re not fulfilling, so we’re just, like, holding them accountable. Hey, book a meeting with us. Hey, is it actually going to go live November 1st? Probably not, so…
464 00:44:06.790 ⇒ 00:44:13.150 Uttam Kumaran: Okay, great. Sorry, I know I keep asking that, but I… I just need everything, and I need everything…
465 00:44:13.260 ⇒ 00:44:16.000 Uttam Kumaran: in linear, so I…
466 00:44:16.000 ⇒ 00:44:16.530 Robert Tseng: Yeah.
467 00:44:16.530 ⇒ 00:44:25.840 Uttam Kumaran: I’m just… everything I know that’s happening, I just really need to show up here so that I can follow up on it, so that’s… that’s helpful. And then I’m gonna cancel, like, basically anything else about…
468 00:44:26.610 ⇒ 00:44:28.250 Uttam Kumaran: this. Cool.
469 00:44:28.250 ⇒ 00:44:30.570 Robert Tseng: Yeah, all the awesome stuff is… we’re good, so…
470 00:44:30.970 ⇒ 00:44:47.709 Uttam Kumaran: Okay, cool. So we should have really good progress on… so just to do a bigger recap, we should have good progress on, insomnia today, so that’s where I kind of want this crew’s attention to focus. I’m… I’m really excited we have, we have the meeting with… with README later.
471 00:44:47.710 ⇒ 00:44:57.419 Uttam Kumaran: We have a couple of sales stuff later today. We have this Eden recurring issue, but, like, again, I’ll just… we’ll just keep nudging.
472 00:44:58.160 ⇒ 00:45:04.269 Uttam Kumaran: For hype, I’ve produced a, also, like, a one-pager,
473 00:45:05.170 ⇒ 00:45:09.260 Uttam Kumaran: Robert, you can take a look, has kind of everything we’ve worked on.
474 00:45:09.380 ⇒ 00:45:13.890 Uttam Kumaran: Like, roughly, we’re still building work… we’re still building diagrams for them.
475 00:45:14.110 ⇒ 00:45:23.430 Uttam Kumaran: we’re… I basically… I asked them to start to give us some milestones, but everything’s in that doc for you. And then, yeah. So, I think that’s the…
476 00:45:23.780 ⇒ 00:45:24.930 Awaish Kumar: just…
477 00:45:25.700 ⇒ 00:45:26.400 Uttam Kumaran: Sorry?
478 00:45:26.920 ⇒ 00:45:33.569 Awaish Kumar: Yeah, right now, they just need that, like, they need us to help them understand data flows and all the tools.
479 00:45:33.570 ⇒ 00:45:40.560 Uttam Kumaran: Yeah. Yeah, Wish, take a look at that doc I wrote. I met with them on Tuesday, so I… we did another… we did another session, so…
480 00:45:40.690 ⇒ 00:45:42.290 Uttam Kumaran: Cool. And then…
481 00:45:42.480 ⇒ 00:45:55.249 Uttam Kumaran: I guess, like, in… on this call, like, who has… who has more time today? Awaish, do you have… what do you… does… who has… who has, kind of, like, free bandwidth? I think… Awash, there’s some stuff in Urban Stems, I think Demolade, there’s a couple things there.
482 00:45:55.750 ⇒ 00:46:01.749 Uttam Kumaran: Maybe, maybe not, but if you have bandwidth, let me know, because I think there’s probably some, like, tech debt stuff we can work on.
483 00:46:03.450 ⇒ 00:46:07.430 Awaish Kumar: Okay, I can. Like, on Earth terms, I already have some
484 00:46:07.650 ⇒ 00:46:10.209 Awaish Kumar: things, like, on the Northwind side, and…
485 00:46:10.590 ⇒ 00:46:13.019 Uttam Kumaran: Okay. Yeah, push that through.
486 00:46:15.200 ⇒ 00:46:20.449 Demilade: For urban stems, it’s largely… There’s some…
487 00:46:20.760 ⇒ 00:46:25.830 Demilade: errors that, like, Perry has been pointing out, so just to kind of investigate that.
488 00:46:26.370 ⇒ 00:46:30.880 Demilade: Okay. And then… ain’t no…
489 00:46:31.470 ⇒ 00:46:38.060 Demilade: maybe push some changes to some subscription stuff, so I’ll just look at that and ensure it’s not breaking stuff today.
490 00:46:38.660 ⇒ 00:46:39.300 Awaish Kumar: Okay.
491 00:46:40.830 ⇒ 00:46:41.300 Uttam Kumaran: Okay.
492 00:46:41.300 ⇒ 00:46:44.520 Demilade: And then, yeah, just find out you get the historical revenue in.
493 00:46:45.780 ⇒ 00:46:46.420 Uttam Kumaran: Okay.
494 00:46:47.640 ⇒ 00:46:57.009 Uttam Kumaran: Okay, cool. Alright, message me if you need anything. I think good progress this week. Yeah, let’s… we close out today, and we can… I think the biggest thing, we can get something out for Insomnia.
495 00:46:57.180 ⇒ 00:46:58.419 Uttam Kumaran: Tomorrow, that’d be great.
496 00:46:59.380 ⇒ 00:47:00.160 Uttam Kumaran: Okay.
497 00:47:00.270 ⇒ 00:47:02.080 Uttam Kumaran: Alright. Thanks, guys.
498 00:47:02.190 ⇒ 00:47:02.880 Uttam Kumaran: Talk to you soon.
499 00:47:02.880 ⇒ 00:47:03.599 Demilade: And clear.
500 00:47:04.020 ⇒ 00:47:04.730 Robert Tseng: Thank you.
501 00:47:04.730 ⇒ 00:47:05.370 Samuel Roberts: Al.