Meeting Title: Zoom Meeting Date: 2025-04-04 Meeting participants: Robert Tseng, Awaish Kumar, Demilade Agboola
WEBVTT
1 00:00:14.010 ⇒ 00:00:15.289 Robert Tseng: Hey! Damn lotto!
2 00:00:15.760 ⇒ 00:00:16.420 Demilade Agboola: Hi Robert!
3 00:00:17.513 ⇒ 00:00:26.856 Robert Tseng: Yeah, we’re just like we’re stuck in a pretty tough spot right now, I think, just I don’t know how much context you have on it. But I mean, I don’t know what
4 00:00:27.320 ⇒ 00:00:31.369 Robert Tseng: oasis doing. I’ve just been just trying to figure it out.
5 00:00:33.180 ⇒ 00:00:37.699 Robert Tseng: So basically, like we excluded some orders from.
6 00:00:39.800 ⇒ 00:00:50.720 Robert Tseng: I guess if you could follow just this thread here, like in Eden, analytics like, you know, I
7 00:00:52.770 ⇒ 00:00:57.739 Robert Tseng: you can catch up by looking at this like everybody’s attention, is on this right now, like
8 00:00:57.930 ⇒ 00:01:05.399 Robert Tseng: we pushed the change that adjusted the Ncac. Numbers, it was supposed to exclude orders with 1st Utm source. The offer.
9 00:01:05.560 ⇒ 00:01:25.150 Robert Tseng: In a way, she’s claiming that, like, you know, 40% of orders come from the offer, and no one believes that Rob is saying it’s really not that many like it. So I just I have Rob’s query pulled up here. I’m like trying to just like redo it from scratch myself. And like
10 00:01:25.400 ⇒ 00:01:30.450 Robert Tseng: I already spoke on the phone with a wish. But like, I don’t really know.
11 00:01:30.910 ⇒ 00:01:42.680 Robert Tseng: I mean, yeah. He still has not given me like a order list, which is like what I want and until that, like I just anyway, that’s we’re just we’re just stuck until I can
12 00:01:43.430 ⇒ 00:01:44.940 Robert Tseng: like we’re saying.
13 00:01:45.700 ⇒ 00:01:55.430 Robert Tseng: you know we’re off by like we’re saying it’s like 10,000 orders lifetime. And Rob is saying 500. It’s just like not nowhere close. And
14 00:01:55.740 ⇒ 00:02:21.569 Robert Tseng: I don’t even know where, like where we went wrong. So it, it seemed like it was such a simple like, ask like, we were just getting rid of like this is the only filter that I really see here. It’s just anything that’s not Utm source this. And I I don’t know what the heck happened that we’re not able to. Well, anyway, I I just I’m I’m kind of just
15 00:02:21.750 ⇒ 00:02:26.020 Robert Tseng: in a i i don’t know what to make. I don’t know how to make sense of this, either
16 00:02:32.500 ⇒ 00:02:36.079 Demilade Agboola: I’m looking at always. Just commit
17 00:02:53.180 ⇒ 00:02:55.669 Robert Tseng: What is going on? Why can I not execute this
18 00:02:56.610 ⇒ 00:03:02.329 Robert Tseng: FTUM. FTUM. Come on! What is going on from source.
19 00:03:02.760 ⇒ 00:03:09.740 Robert Tseng: Oh, course, let’s just call this test.
20 00:03:15.350 ⇒ 00:03:16.490 Robert Tseng: hey?
21 00:03:19.400 ⇒ 00:03:22.370 Robert Tseng: Kidding me right? And this is still not working
22 00:03:57.000 ⇒ 00:04:01.370 Robert Tseng: the Oh, wait!
23 00:04:58.780 ⇒ 00:05:03.319 Robert Tseng: I just slacked you. This is Rob’s query on like, how he’s looked at this.
24 00:05:03.540 ⇒ 00:05:07.459 Robert Tseng: I just don’t know why oasis query is like, so far off.
25 00:05:14.070 ⇒ 00:05:18.260 Robert Tseng: Okay, sure, I’m seeing the same thing. 21,000 users. Okay?
26 00:05:18.800 ⇒ 00:05:21.980 Robert Tseng: Alright, that’s interesting.
27 00:05:49.870 ⇒ 00:05:50.760 Robert Tseng: Yes.
28 00:09:14.210 ⇒ 00:09:18.160 Demilade Agboola: What if I was able to show? I think I just saw the aggregations I was able to show?
29 00:09:18.800 ⇒ 00:09:25.240 Demilade Agboola: Shouldn’t you just be able to like, unravel that, and so we can see the the orders.
30 00:09:25.580 ⇒ 00:09:26.829 Demilade Agboola: No extra good
31 00:09:31.770 ⇒ 00:09:32.590 Robert Tseng: Sorry.
32 00:09:32.750 ⇒ 00:09:34.070 Robert Tseng: What are you trying to say
33 00:09:34.830 ⇒ 00:09:41.209 Demilade Agboola: I’ve seen since I’ve seen a wish has done like an aggregation of the orders before and after for the month
34 00:09:41.500 ⇒ 00:09:43.159 Demilade Agboola: I got the month of March.
35 00:09:43.420 ⇒ 00:09:45.429 Demilade Agboola: if he’s been able to do that.
36 00:09:45.770 ⇒ 00:09:53.009 Demilade Agboola: and he just like unravel it like, instead of like ruling and talking to like the count. Let’s just get the the raw.
37 00:09:53.320 ⇒ 00:09:54.440 Demilade Agboola: the raw data.
38 00:09:56.570 ⇒ 00:10:22.750 Robert Tseng: Okay, well, I mean, I I what I’m saying is like, I thought, like Rob, basically wrote the query for him on how he should do this, and I just feel like he he I mean I this is the I. I did the same approach, but I think he just he just did like his own, join logic and didn’t use what Rob said. And that’s why we don’t have the same amount of filtering like it. It must be a filtering problem. That’s why rob’s query is coming back way lower.
39 00:10:23.020 ⇒ 00:10:34.900 Robert Tseng: I don’t know why he filtered it this way like I I didn’t. I don’t have all the context. I you know, anyway, but so I can only say like the this is the difference. I don’t. I don’t know the why, this is like
40 00:10:35.570 ⇒ 00:10:44.029 Robert Tseng: this was supposed to be done last Friday, and, oh, my God! I cannot save the team every time like losing my mind.
41 00:10:45.060 ⇒ 00:10:46.160 Robert Tseng: Oh.
42 00:10:47.570 ⇒ 00:11:03.319 Robert Tseng: okay. Sorry. I’m like having a meltdown, because, like, I publish this stuff. And then I get like 10 calls and like, I do not know how to defend the team’s work. It just it just makes us look like we have no idea what we’re doing. I should. I don’t know what to do
43 00:11:07.500 ⇒ 00:11:10.070 Demilade Agboola: Yeah, it sounds very stressful.
44 00:11:30.320 ⇒ 00:11:31.950 Robert Tseng: Do you have a recommendation
45 00:11:36.970 ⇒ 00:11:43.690 Demilade Agboola: It’s hard to recommend when like, I’m not sure what the underlying data is like. How the shift occurred.
46 00:12:09.260 ⇒ 00:12:12.339 Demilade Agboola: oh, one second
47 00:14:29.910 ⇒ 00:14:33.069 Robert Tseng: Hey? Wish? Sorry, can we? Just can we? I
48 00:14:33.320 ⇒ 00:14:39.479 Robert Tseng: can. We just try to close this out like I’m I’m like paralyzed. I do not know how to help
49 00:14:41.270 ⇒ 00:14:42.340 Awaish Kumar: Okay.
50 00:14:42.530 ⇒ 00:14:45.739 Awaish Kumar: So like what I’m saying here is
51 00:14:46.130 ⇒ 00:14:51.200 Awaish Kumar: that when I when we I added this filter to filter out
52 00:14:51.450 ⇒ 00:14:55.550 Awaish Kumar: the Utm source where it is the offer.
53 00:14:56.020 ⇒ 00:14:58.380 Awaish Kumar: I just added this field where cross?
54 00:14:59.320 ⇒ 00:15:07.210 Awaish Kumar: But the but I didn’t realize that there are some orders where Utm sources null to sell
55 00:15:07.210 ⇒ 00:15:10.310 Robert Tseng: Your model, you included Knowles. Isn’t that? Isn’t that
56 00:15:10.310 ⇒ 00:15:14.270 Awaish Kumar: No, no, I’m not. I didn’t include it. As when I say
57 00:15:14.500 ⇒ 00:15:19.519 Awaish Kumar: filter where the 1st item source is not equal to the offer.
58 00:15:19.860 ⇒ 00:15:27.590 Awaish Kumar: the database automatically. All the values where it is. Null it it. Those are. Those get filtered out.
59 00:15:29.050 ⇒ 00:15:32.559 Awaish Kumar: So those were removed from the model. You can
60 00:15:32.560 ⇒ 00:15:34.160 Robert Tseng: So the nulls were removed
61 00:15:34.550 ⇒ 00:15:35.380 Awaish Kumar: Yes.
62 00:15:36.310 ⇒ 00:15:44.059 Robert Tseng: Isn’t that what I’m saying like? Isn’t that the same thing? It’s like we we got rid of all the nulls. And I mean, that’s huge.
63 00:15:51.020 ⇒ 00:15:57.759 Robert Tseng: So okay, what’s the Rob’s query. I sent it to you again. He had multiple layers of filtering in there
64 00:16:00.030 ⇒ 00:16:00.840 Awaish Kumar: He’s
65 00:16:01.260 ⇒ 00:16:14.709 Awaish Kumar: he’s doing this carries identifying those 26 orders which I discussed with you, that they are not marked as the offer, but they should have been marked. So this is to identify those
66 00:16:16.690 ⇒ 00:16:26.049 Robert Tseng: Okay. But like, if you like, I literally just went out there. And I was like, yeah, we 40% of orders we excluded.
67 00:16:26.280 ⇒ 00:16:32.490 Robert Tseng: And I’m I’m and we’re wrong. And like I I bet it’s like.
68 00:16:33.120 ⇒ 00:16:38.399 Robert Tseng: I don’t even know how I come back from that like I I tried to like just
69 00:16:39.370 ⇒ 00:16:45.720 Robert Tseng: I mean, clearly, most of that is going to be null. It’s not actually the offer. So just like
70 00:16:46.850 ⇒ 00:16:51.850 Robert Tseng: the I don’t know if you’re in the thread or not, I mean oh, God, I
71 00:16:52.090 ⇒ 00:17:00.409 Robert Tseng: I just feel like a complete idiot for just going up there and saying that. And I’ve been taking like heat for the past hour hour and a half.
72 00:17:00.590 ⇒ 00:17:04.829 Robert Tseng: I’m like completely cooked, like I don’t. I don’t know what to. I don’t know what to say
73 00:17:09.910 ⇒ 00:17:14.069 Awaish Kumar: Right? Yeah, I’m I’m sorry for that. I I didn’t.
74 00:17:14.500 ⇒ 00:17:19.299 Awaish Kumar: Yeah, I just forgot, like, if there are some Youtube source as well as well
75 00:17:21.099 ⇒ 00:17:21.929 Robert Tseng: Okay,
76 00:17:23.229 ⇒ 00:17:28.679 Robert Tseng: so what? What needs to happen? What can we? What can we do to? Yeah, like, please, please tell me.
77 00:17:28.680 ⇒ 00:17:30.119 Robert Tseng: I just push the
78 00:17:30.600 ⇒ 00:17:37.520 Awaish Kumar: Like. I just pushed a Pr. To only exclude the offer orders, and add all those none
79 00:17:38.750 ⇒ 00:17:39.930 Robert Tseng: What’s the magnitude?
80 00:17:40.080 ⇒ 00:17:43.039 Robert Tseng: How many orders are impacted? Everyone’s gonna want to know that
81 00:17:43.040 ⇒ 00:17:44.380 Awaish Kumar: Because I want to
82 00:17:44.380 ⇒ 00:17:47.970 Robert Tseng: And I said, 40%, it’s not 40%. How percent is it
83 00:17:48.590 ⇒ 00:17:53.070 Awaish Kumar: So like only the for the march, 2,025
84 00:17:53.260 ⇒ 00:17:59.340 Awaish Kumar: only the 7, 79 orders are marked as the offer
85 00:17:59.530 ⇒ 00:18:00.210 Robert Tseng: Okay.
86 00:18:00.590 ⇒ 00:18:03.549 Awaish Kumar: In the new orders. New new customers right
87 00:18:04.550 ⇒ 00:18:07.430 Robert Tseng: Yeah, I mean, believable.
88 00:18:07.850 ⇒ 00:18:12.320 Demilade Agboola: Do you have an orders list for that, like a list of orders? So we can, you know.
89 00:18:16.570 ⇒ 00:18:17.969 Demilade Agboola: like a list of
90 00:18:21.690 ⇒ 00:18:23.789 Awaish Kumar: Yeah, I I can show you
91 00:18:33.050 ⇒ 00:18:35.200 Awaish Kumar: in this Google Sheet here.
92 00:18:43.480 ⇒ 00:18:48.309 Awaish Kumar: I share the Zoom channel, the sheet where
93 00:19:26.840 ⇒ 00:19:36.089 Robert Tseng: Okay, we need to like trigger manual refreshes on these data sources so that they can reflect oasis, new pr change. I need to see what this Ncac. Number actually is.
94 00:19:37.326 ⇒ 00:19:45.620 Awaish Kumar: Damn Ade! If you can approve it, I can request I just
95 00:19:46.730 ⇒ 00:19:55.250 Robert Tseng: Yeah way for in a few minutes. So I’m gonna have to go. I mean, I’ll write the message. You you guys need to refresh the data.
96 00:19:55.550 ⇒ 00:20:06.219 Robert Tseng: Some some please, please. One of you. Just trigger the refresh on the product. Roast Ltv dashboard. Kind of show exactly what what the like. How like the how it changed.
97 00:20:06.744 ⇒ 00:20:11.609 Robert Tseng: Yeah, I mean we we we we messed up on this one so
98 00:20:12.367 ⇒ 00:20:26.770 Robert Tseng: all I can do is write the message, but I I have to step away. I’ve literally spent 2 h on this just like answering questions and pretty much getting yelled at. And now, having to just come to this call, so like
99 00:20:27.060 ⇒ 00:20:34.709 Robert Tseng: God. This is an absolutely terrible day. But, I I have to move on. There are other things I have to take care of as well.
100 00:20:35.020 ⇒ 00:20:50.480 Robert Tseng: So yeah, if we could just get the Pr approved, I’ll write the apologetic message and then please refresh the data show that the Cac is actually not that high. Yeah, I think that’s that’s all we can do for right now.
101 00:20:51.790 ⇒ 00:20:54.570 Robert Tseng: Alright, I’m gonna I’m gonna jump off. For now, thanks, guys.