Meeting Title: Brainforge x Green Forge Project Check-in Date: 2026-03-02 Meeting participants: Demilade Agboola, Mustafa Raja
WEBVTT
1 00:00:27.010 ⇒ 00:00:28.050 Mustafa Raja: Hey…
2 00:00:29.750 ⇒ 00:00:31.130 Demilade Agboola: Hi, Mustafa, how are you?
3 00:00:31.610 ⇒ 00:00:33.000 Mustafa Raja: Yeah, doing good, how are you?
4 00:00:33.270 ⇒ 00:00:35.089 Demilade Agboola: I’m doing very well. I’m doing very well.
5 00:00:35.870 ⇒ 00:00:39.620 Mustafa Raja: Yeah, okay, let me share my screen, and then let’s go through this, right?
6 00:00:41.150 ⇒ 00:00:41.730 Demilade Agboola: Sure.
7 00:00:47.330 ⇒ 00:00:49.290 Mustafa Raja: No, no, it’s so lucky, yeah.
8 00:00:54.040 ⇒ 00:00:59.550 Mustafa Raja: Yeah, so, so you’d seen that, you know, for October 20th.
9 00:00:59.930 ⇒ 00:01:09.689 Mustafa Raja: These… these just wouldn’t match, right? So, cohort sizes… A lot of… Now, if I…
10 00:01:11.740 ⇒ 00:01:16.159 Mustafa Raja: I think… use this for dot, if I set it to 1…
11 00:01:19.340 ⇒ 00:01:22.479 Mustafa Raja: The sum is going to exactly match with the cohort.
12 00:01:24.550 ⇒ 00:01:28.340 Mustafa Raja: column in, tableau, right?
13 00:01:28.550 ⇒ 00:01:34.229 Mustafa Raja: So if you were to look into 2004, 2004, 35, 33,
14 00:01:34.430 ⇒ 00:01:40.040 Mustafa Raja: $39.95, and we see that these are actually exactly matching.
15 00:01:41.190 ⇒ 00:01:44.380 Demilade Agboola: Is this… are you using staging data, or are you using the.
16 00:01:44.380 ⇒ 00:01:52.959 Mustafa Raja: Yeah, this one… this one, this is… I just created this topic to specifically work with the staging data.
17 00:01:53.110 ⇒ 00:01:58.399 Mustafa Raja: Now, the issue with this filter is that it messes up all other data.
18 00:01:58.780 ⇒ 00:02:06.329 Mustafa Raja: For example, this is a… this is… I believe this is some of… The orders, right? So…
19 00:02:06.640 ⇒ 00:02:09.880 Mustafa Raja: cumulative orders, and I’m going to sum it.
20 00:02:13.920 ⇒ 00:02:17.150 Mustafa Raja: And then… Yeah, you see?
21 00:02:18.130 ⇒ 00:02:22.050 Mustafa Raja: 7897, right? For October 2024, right?
22 00:02:22.860 ⇒ 00:02:27.390 Mustafa Raja: For October 2024, it’s a lot more than that.
23 00:02:28.960 ⇒ 00:02:30.370 Demilade Agboola: Hold on a second, let me check.
24 00:02:37.150 ⇒ 00:02:38.189 Mustafa Raja: How was your weekend?
25 00:02:39.130 ⇒ 00:02:41.289 Demilade Agboola: It was pretty good, actually.
26 00:02:41.290 ⇒ 00:02:42.600 Mustafa Raja: I played tennis.
27 00:02:43.560 ⇒ 00:02:45.230 Mustafa Raja: Oh, yeah, I just love that.
28 00:02:45.530 ⇒ 00:02:49.309 Demilade Agboola: And then I was able to rest for the rest of it, so…
29 00:02:49.860 ⇒ 00:02:53.309 Demilade Agboola: Yeah, it was pretty, it was pretty good, it was pretty okay.
30 00:02:54.590 ⇒ 00:02:55.690 Mustafa Raja: Yeah, that’s nice.
31 00:02:55.890 ⇒ 00:02:56.829 Demilade Agboola: How was yours?
32 00:02:58.240 ⇒ 00:03:01.410 Mustafa Raja: Mine was exciting.
33 00:03:02.150 ⇒ 00:03:03.919 Demilade Agboola: In a… in a good way?
34 00:03:04.280 ⇒ 00:03:07.650 Demilade Agboola: Yeah, I don’t know.
35 00:03:07.760 ⇒ 00:03:08.550 Mustafa Raja: Nope.
36 00:03:08.670 ⇒ 00:03:10.419 Mustafa Raja: The war’s here, you know?
37 00:03:11.190 ⇒ 00:03:14.110 Demilade Agboola: Oh, fair. How close are you to all of that, though?
38 00:03:14.740 ⇒ 00:03:19.260 Mustafa Raja: I… so I’m bordering both Afghanistan and Iran.
39 00:03:19.900 ⇒ 00:03:21.320 Demilade Agboola: Oh…
40 00:03:22.110 ⇒ 00:03:27.630 Demilade Agboola: Because I just figured you were in, like, Pakistan, so I didn’t know you were close to all of that, but yeah, that’s…
41 00:03:27.810 ⇒ 00:03:36.179 Mustafa Raja: I’m like, Pakistan is, like, in the center of all of this. Whenever… whenever it happens.
42 00:03:37.070 ⇒ 00:03:37.950 Demilade Agboola: Gotcha.
43 00:03:38.860 ⇒ 00:03:42.820 Demilade Agboola: That’s crazy, though. Like, this whole weekend was actually…
44 00:03:43.590 ⇒ 00:03:44.949 Mustafa Raja: I’m getting crazy.
45 00:03:44.980 ⇒ 00:03:46.440 Demilade Agboola: Yeah.
46 00:03:46.990 ⇒ 00:03:48.300 Demilade Agboola: Okay, yeah.
47 00:03:52.080 ⇒ 00:03:57.219 Demilade Agboola: But how closely to, like, all of the action, like, all the stuff that’s happening in Tehran and all of that?
48 00:03:58.280 ⇒ 00:04:05.720 Mustafa Raja: I think, Avish is more closer to that than me, because, on his side, they have curfew.
49 00:04:05.990 ⇒ 00:04:08.470 Mustafa Raja: On my side, it’s a lot more chill.
50 00:04:09.290 ⇒ 00:04:10.550 Demilade Agboola: Interesting, wow.
51 00:04:11.730 ⇒ 00:04:12.500 Demilade Agboola: Okay.
52 00:04:15.200 ⇒ 00:04:23.400 Demilade Agboola: That is very interesting, like… And I know, like, Iran started attacking the other, like.
53 00:04:23.920 ⇒ 00:04:27.179 Mustafa Raja: Yeah, yeah, but it didn’t do it on Pakistan.
54 00:04:27.710 ⇒ 00:04:28.420 Demilade Agboola: Yeah, yeah, yeah.
55 00:04:28.420 ⇒ 00:04:30.280 Mustafa Raja: We have good relations with them, so…
56 00:04:32.290 ⇒ 00:04:34.619 Demilade Agboola: Unless that’s… that’s one good thing.
57 00:04:34.960 ⇒ 00:04:36.170 Mustafa Raja: Heh, yeah.
58 00:04:37.220 ⇒ 00:04:41.669 Demilade Agboola: Because I heard that they even bombed one of the biggest, like, refineries in Saudi Arabia.
59 00:04:42.250 ⇒ 00:04:43.190 Mustafa Raja: Yeah.
60 00:04:43.490 ⇒ 00:04:50.429 Mustafa Raja: They did… they, like… they didn’t spare any one of the GCC countries.
61 00:04:50.620 ⇒ 00:04:51.620 Demilade Agboola: Yeah, yeah.
62 00:04:52.590 ⇒ 00:04:54.949 Demilade Agboola: It’s actually quite insane, to be honest.
63 00:04:57.750 ⇒ 00:05:07.959 Mustafa Raja: But I think it’s going to end soon, to be honest. I think this is… it’s… I think, and this is my… this is only my idea, I think this is going to last only this week.
64 00:05:10.170 ⇒ 00:05:12.910 Mustafa Raja: Otherwise, it’s going to affect the world’s economy, I believe.
65 00:05:13.720 ⇒ 00:05:16.020 Demilade Agboola: Yeah, I mean, oil prices are already going up, to be honest.
66 00:05:16.950 ⇒ 00:05:17.770 Mustafa Raja: Yeah.
67 00:05:18.240 ⇒ 00:05:22.359 Mustafa Raja: Even the Saudi oil refinery, you know, is going to affect the oil prices or not.
68 00:05:26.110 ⇒ 00:05:26.830 Demilade Agboola: True.
69 00:05:27.930 ⇒ 00:05:30.800 Demilade Agboola: Sure, can you go back to the… can you go back to…
70 00:05:31.440 ⇒ 00:05:32.050 Mustafa Raja: Yep.
71 00:05:32.240 ⇒ 00:05:33.300 Demilade Agboola: Actually, the topic.
72 00:05:34.950 ⇒ 00:05:36.770 Mustafa Raja: Of course…
73 00:05:36.770 ⇒ 00:05:39.190 Demilade Agboola: So, can I see the columns in the topic?
74 00:05:39.380 ⇒ 00:05:41.650 Mustafa Raja: Oh, yeah, yeah, yeah, so here it is.
75 00:05:42.800 ⇒ 00:05:44.169 Demilade Agboola: I was trying… yeah.
76 00:05:45.140 ⇒ 00:05:51.450 Demilade Agboola: Airbn… Can you pick his lifetime macro?
77 00:05:52.350 ⇒ 00:05:53.680 Mustafa Raja: Sorry, sorry, can you say that again?
78 00:05:53.790 ⇒ 00:05:56.380 Demilade Agboola: Yes, use that filter, please. It’s lifetime.
79 00:05:56.380 ⇒ 00:05:57.120 Mustafa Raja: Which one?
80 00:05:57.330 ⇒ 00:06:02.229 Mustafa Raja: Is Lifetime. Lifetime. Oh, this one.
81 00:06:02.480 ⇒ 00:06:08.750 Mustafa Raja: Wait, let me get rid of this one. Is lifetime max row… sorry, not this one.
82 00:06:09.290 ⇒ 00:06:11.260 Mustafa Raja: And what should be the value?
83 00:06:13.770 ⇒ 00:06:15.240 Mustafa Raja: It’s true, or something?
84 00:06:15.240 ⇒ 00:06:16.130 Demilade Agboola: Yes, it’s true.
85 00:06:20.600 ⇒ 00:06:33.970 Mustafa Raja: Okay… This looks interesting… 21.116. Okay, this is a lot closer, 17956, 19136.
86 00:06:34.760 ⇒ 00:06:46.140 Mustafa Raja: 17, 19… And then, 18, 12, 13, 13… 18, 12, 13, 13… 11, 18, 16, 14…
87 00:06:46.310 ⇒ 00:06:51.469 Mustafa Raja: 11, 18… okay, yeah, this is, this is like… this is like… Almost on bar.
88 00:06:52.020 ⇒ 00:06:52.710 Demilade Agboola: Yeah.
89 00:06:53.890 ⇒ 00:06:54.479 Demilade Agboola: So, yeah, that…
90 00:06:54.480 ⇒ 00:06:55.450 Mustafa Raja: at this point.
91 00:06:55.910 ⇒ 00:06:58.000 Demilade Agboola: And what’s the filter that was done…
92 00:06:58.530 ⇒ 00:07:03.810 Demilade Agboola: On it. This lifetime mature is what you use to find the cumulative
93 00:07:04.560 ⇒ 00:07:10.420 Demilade Agboola: Actually, you know what, add… can you add lifetime cumulative orders? There’s a column called lifetime cumulative orders.
94 00:07:11.380 ⇒ 00:07:16.670 Mustafa Raja: Lifetime cumulative orders, after, should I also remove this one? This filter, and then add…
95 00:07:16.670 ⇒ 00:07:22.210 Demilade Agboola: No, just put it there. Actually, no, you know what, do both. Let’s first add it, and then let’s remove it.
96 00:07:23.910 ⇒ 00:07:26.350 Mustafa Raja: Okay, so adding it creates…
97 00:07:26.540 ⇒ 00:07:32.829 Mustafa Raja: Multiple rows for each month. And that is because we need to add it in as a sum.
98 00:07:33.140 ⇒ 00:07:34.400 Mustafa Raja: study.
99 00:07:35.720 ⇒ 00:07:37.749 Mustafa Raja: We need to add it as an aggregate.
100 00:07:37.990 ⇒ 00:07:42.839 Mustafa Raja: And then… yeah, I think it’s exactly the same. And then let me remove this.
101 00:07:43.310 ⇒ 00:07:47.180 Demilade Agboola: Yeah, so you won’t actually need that filter, basically, because…
102 00:07:47.180 ⇒ 00:07:49.420 Mustafa Raja: Oh, I think we…
103 00:07:49.420 ⇒ 00:07:50.279 Demilade Agboola: You do it.
104 00:07:50.630 ⇒ 00:07:54.369 Demilade Agboola: Yeah, you do. Actually, no, remove the sum. Remove the sum…
105 00:07:54.800 ⇒ 00:07:57.189 Mustafa Raja: Let me, yeah, let me actually… What’s the quote sum.
106 00:07:59.240 ⇒ 00:08:05.100 Demilade Agboola: just use the lifetime alone, let me see what that does. And actually, no, don’t use it as a sum, use it as a…
107 00:08:05.580 ⇒ 00:08:09.590 Demilade Agboola: Just use it as, like, instead of swimming, it’s like you did… So remove everything.
108 00:08:09.590 ⇒ 00:08:12.320 Mustafa Raja: Yeah, let me, let me… so in this…
109 00:08:14.360 ⇒ 00:08:19.000 Mustafa Raja: So, yeah, the problem with this is this, you know?
110 00:08:19.000 ⇒ 00:08:20.790 Demilade Agboola: Can you move the songs?
111 00:08:21.490 ⇒ 00:08:22.390 Demilade Agboola: Let’s see that.
112 00:08:22.390 ⇒ 00:08:25.260 Mustafa Raja: Yeah, let me remove the other ones.
113 00:08:26.440 ⇒ 00:08:27.429 Demilade Agboola: I ain’t move.
114 00:08:27.950 ⇒ 00:08:33.100 Mustafa Raja: Yeah, I still, you know, still creating multiple ones.
115 00:08:33.669 ⇒ 00:08:39.069 Mustafa Raja: I think, I think, this is good enough, the max row filter.
116 00:08:39.070 ⇒ 00:08:40.780 Demilade Agboola: We should be able to work with that.
117 00:08:40.960 ⇒ 00:08:43.220 Mustafa Raja: You know, and get this over the line.
118 00:08:43.870 ⇒ 00:08:47.240 Demilade Agboola: Alright, sure, that’s fine. Like, I… then I’ll just merge the PR.
119 00:08:47.350 ⇒ 00:08:51.309 Demilade Agboola: Because I’ve added, like, lifetime callout size, I’ve added the.
120 00:08:52.290 ⇒ 00:08:59.029 Mustafa Raja: Okay, so this one… so the lifetime thing is the new addition to dbt model, right?
121 00:08:59.620 ⇒ 00:09:06.570 Demilade Agboola: is Lifetime Metro, yeah, that’s the new addition. So I will merge… so this is staging. I just… once I merge it, it’ll be available in prod, and then you can use it then.
122 00:09:06.570 ⇒ 00:09:07.590 Mustafa Raja: Okay, duty.
123 00:09:08.040 ⇒ 00:09:10.800 Mustafa Raja: Okay, then one more last…
124 00:09:10.800 ⇒ 00:09:12.419 Demilade Agboola: A separate, yeah, you know.
125 00:09:12.420 ⇒ 00:09:13.260 Mustafa Raja: Oh, okay.
126 00:09:14.110 ⇒ 00:09:15.310 Mustafa Raja: this one.
127 00:09:17.860 ⇒ 00:09:20.180 Mustafa Raja: One more thing from this ticket.
128 00:09:20.440 ⇒ 00:09:25.140 Mustafa Raja: And I think this is the last thing from this ticket, is… This one.
129 00:09:27.250 ⇒ 00:09:28.349 Demilade Agboola: Which one is that?
130 00:09:29.060 ⇒ 00:09:32.210 Mustafa Raja: Yeah, I’m opening it up, sorry.
131 00:09:37.220 ⇒ 00:09:40.879 Mustafa Raja: Okay, Some cohort Chinese in this.
132 00:09:44.950 ⇒ 00:09:46.580 Mustafa Raja: Good times…
133 00:09:58.550 ⇒ 00:10:01.530 Mustafa Raja: Okay, and then over here…
134 00:10:13.620 ⇒ 00:10:23.479 Mustafa Raja: Yeah, you see, you see, this, this, the ones, the values in the offer are all good, but in the others, they’re not good at all.
135 00:10:28.830 ⇒ 00:10:30.950 Demilade Agboola: So, things like what the cohort size.
136 00:10:32.040 ⇒ 00:10:37.669 Mustafa Raja: Yeah, so for cohort size, so for March 2025, it’s 2470, right?
137 00:10:37.880 ⇒ 00:10:40.690 Mustafa Raja: March 2025, coach ice is way off.
138 00:10:41.270 ⇒ 00:10:45.579 Mustafa Raja: And then let’s take a look at April 2025, and it’s 15.
139 00:10:46.280 ⇒ 00:10:47.519 Demilade Agboola: Let me see.
140 00:10:48.220 ⇒ 00:10:53.150 Mustafa Raja: 1554 for April 2025, and then… yeah, it’s just way off.
141 00:10:54.040 ⇒ 00:10:56.570 Demilade Agboola: So it’s the offer versus others. Can you go back, please?
142 00:10:57.170 ⇒ 00:11:01.000 Mustafa Raja: Yeah, the offer ones, you’d see that these are good, actually.
143 00:11:08.070 ⇒ 00:11:10.760 Demilade Agboola: And this is still the cohort retention.
144 00:11:10.910 ⇒ 00:11:12.240 Demilade Agboola: Or is it a different model?
145 00:11:14.310 ⇒ 00:11:15.000 Demilade Agboola: like…
146 00:11:15.000 ⇒ 00:11:17.939 Mustafa Raja: I think this is… this might be a different one.
147 00:11:18.590 ⇒ 00:11:21.119 Mustafa Raja: Cool TV… yeah, this is a different one.
148 00:11:21.680 ⇒ 00:11:25.710 Mustafa Raja: Let’s actually take a look into this, which tables are in here.
149 00:11:25.710 ⇒ 00:11:29.230 Demilade Agboola: Can you check… can you… you could just go to… Pablo.
150 00:11:29.230 ⇒ 00:11:30.840 Mustafa Raja: Yeah, I’m going to do…
151 00:11:30.840 ⇒ 00:11:31.540 Demilade Agboola: Okay.
152 00:11:38.140 ⇒ 00:11:39.229 Mustafa Raja: I think it was just…
153 00:11:56.060 ⇒ 00:11:58.120 Mustafa Raja: So, this is in revenue.
154 00:11:58.750 ⇒ 00:12:05.260 Mustafa Raja: Our aviation channel cohort Performance… How do I see. Yeah, so it’s this table, return on ad spend.
155 00:12:06.620 ⇒ 00:12:08.549 Demilade Agboola: Return on ad spend.
156 00:12:20.330 ⇒ 00:12:21.770 Demilade Agboola: I’m trying to, like…
157 00:12:25.970 ⇒ 00:12:34.789 Demilade Agboola: And then you should be including the same… can you go back to your chart? Because if the offer matches, then it should just be a function of how are you defining offer?
158 00:12:35.250 ⇒ 00:12:35.960 Demilade Agboola: like, not.
159 00:12:35.960 ⇒ 00:12:40.599 Mustafa Raja: Oh, yeah, let me… let me… let me show you the query.
160 00:12:41.010 ⇒ 00:12:42.420 Mustafa Raja: Yeah, so this is it.
161 00:12:43.460 ⇒ 00:12:50.729 Mustafa Raja: So, if the channel is the offer, then it goes into the offer, If not, then it’s another.
162 00:12:52.400 ⇒ 00:12:54.960 Demilade Agboola: Something is off with that thing, let me see.
163 00:13:01.300 ⇒ 00:13:07.200 Demilade Agboola: Is this the only two, like, once I… is this the only thing left, like, that is with the Tableau migration?
164 00:13:08.070 ⇒ 00:13:13.480 Mustafa Raja: That is with this ticket. We… you have another one, this one. Sorry.
165 00:13:13.480 ⇒ 00:13:14.450 Demilade Agboola: Which one is that?
166 00:13:20.260 ⇒ 00:13:30.029 Mustafa Raja: So it’s… it’s an issue with, the LOD. We cannot recreate this, the same LOD in, what’s it called? Omni?
167 00:13:30.280 ⇒ 00:13:40.249 Mustafa Raja: We have seen it with one of the solutions that Avaish did. We could just replic- we couldn’t replicate it in Omni, it had to be done, in DBT.
168 00:13:40.590 ⇒ 00:13:42.220 Mustafa Raja: And it’s this dashboard.
169 00:13:45.630 ⇒ 00:13:46.750 Demilade Agboola: Okay, I’ll look at that.
170 00:13:46.750 ⇒ 00:13:51.230 Mustafa Raja: Let me know if you… let me know if you have too much on your plate, I could delegate this to…
171 00:13:51.490 ⇒ 00:13:52.450 Mustafa Raja: Okay, okay.
172 00:13:52.450 ⇒ 00:13:56.820 Demilade Agboola: That’s fine. I just wanted to be sure that there wasn’t any other tickets that was…
173 00:13:56.820 ⇒ 00:14:01.019 Mustafa Raja: Yeah, there is. Is it this one? And there might be one more.
174 00:14:01.780 ⇒ 00:14:06.129 Mustafa Raja: This one, but these two should have the same solution.
175 00:14:06.260 ⇒ 00:14:10.820 Mustafa Raja: Let me know if I should delegate this to you, so you can make sure that, you know, these both are the same thing.
176 00:14:11.400 ⇒ 00:14:12.060 Demilade Agboola: Okay.
177 00:14:13.490 ⇒ 00:14:15.409 Demilade Agboola: What’s the issue with this, though?
178 00:14:20.100 ⇒ 00:14:22.689 Mustafa Raja: Let me, sorry, come back.
179 00:14:22.690 ⇒ 00:14:24.809 Demilade Agboola: Can I go back to… so I’m reading the…
180 00:14:25.360 ⇒ 00:14:26.709 Mustafa Raja: Oh, sorry, sorry, yeah.
181 00:14:26.840 ⇒ 00:14:27.860 Demilade Agboola: Let’s funny that.
182 00:14:27.860 ⇒ 00:14:33.269 Mustafa Raja: I created this ticket on, on Friday, so I’ve, like, forgotten what was the issue.
183 00:14:35.500 ⇒ 00:14:43.489 Mustafa Raja: So, I think it’s the… it’s just that for both of these values, we should have one at this value, which Omni doesn’t do.
184 00:14:46.010 ⇒ 00:14:47.609 Demilade Agboola: For whole data.
185 00:14:47.970 ⇒ 00:14:48.859 Mustafa Raja: You know?
186 00:14:49.280 ⇒ 00:14:51.550 Mustafa Raja: So this is a level of detail thing.
187 00:14:54.020 ⇒ 00:14:54.929 Demilade Agboola: Okay.
188 00:14:54.930 ⇒ 00:14:56.619 Mustafa Raja: Is this… does this make sense?
189 00:14:56.750 ⇒ 00:14:58.779 Demilade Agboola: Yeah, it does. You can tag it to me as well.
190 00:14:59.770 ⇒ 00:15:01.319 Mustafa Raja: Okay, okay,
191 00:15:02.080 ⇒ 00:15:06.079 Mustafa Raja: Should I tag you, or just assign it to you, and you can assign it to me back?
192 00:15:06.230 ⇒ 00:15:15.100 Mustafa Raja: Yeah, yeah, assign it to me back once this is fixed in dbt, and then I’ll take it and apply it to the dashboard.
193 00:15:20.200 ⇒ 00:15:25.199 Mustafa Raja: Yeah, so for now, for the other ticket, for this one…
194 00:15:25.960 ⇒ 00:15:30.639 Mustafa Raja: Not this one. This one. We, this should be… no, no.
195 00:15:30.970 ⇒ 00:15:36.280 Mustafa Raja: This one, yeah. This should be it. This, this last thing.
196 00:15:37.280 ⇒ 00:15:39.660 Mustafa Raja: They should be able to get us through.
197 00:15:42.380 ⇒ 00:15:43.840 Demilade Agboola: Yeah, this one.
198 00:15:47.570 ⇒ 00:15:54.480 Mustafa Raja: I don’t know if the issue really, let me actually see if I’m even using the… Correct.
199 00:15:55.530 ⇒ 00:15:56.879 Mustafa Raja: table in…
200 00:15:59.990 ⇒ 00:16:01.100 Mustafa Raja: the topic.
201 00:16:08.540 ⇒ 00:16:13.049 Mustafa Raja: Oh, actually, congratulations on the… On completing the first year.
202 00:16:13.870 ⇒ 00:16:18.369 Demilade Agboola: Oh yeah, thank you. It’s one of those… time just flies.
203 00:16:19.940 ⇒ 00:16:26.619 Mustafa Raja: It’s been… it’s been… so I came in… I came into Green Forge on… in… in May.
204 00:16:27.100 ⇒ 00:16:31.819 Mustafa Raja: I think I, it’s just 2 months away from my first year to be completed.
205 00:16:32.030 ⇒ 00:16:34.329 Demilade Agboola: Yeah, you’re almost there, you’re almost there.
206 00:16:36.200 ⇒ 00:16:43.369 Mustafa Raja: I thought you were, like, 2-3 years in already. I didn’t know that you were… this was your first year. Yeah.
207 00:16:43.370 ⇒ 00:16:51.239 Demilade Agboola: In Brainforge, you know? Like, I just… I joined… Ultime brought me on board in March of last year. He was just like, dude, we need to have you on the team.
208 00:16:52.360 ⇒ 00:16:55.290 Demilade Agboola: If it happened, come on, come on, Ironman.
209 00:16:56.180 ⇒ 00:17:01.819 Demilade Agboola: I mean, lucky for him, at that point in time, I was actually looking to switch jobs, so… I was like, alright, cool, I’m coming.
210 00:17:01.820 ⇒ 00:17:02.840 Mustafa Raja: Yeah, that’s nice.
211 00:17:02.980 ⇒ 00:17:03.889 Demilade Agboola: Yeah, so…
212 00:17:11.079 ⇒ 00:17:12.090 Demilade Agboola: Let’s see…
213 00:17:15.160 ⇒ 00:17:15.859 Demilade Agboola: No.
214 00:17:16.980 ⇒ 00:17:17.720 Demilade Agboola: Yes.
215 00:17:21.470 ⇒ 00:17:22.790 Demilade Agboola: Let’s try something.
216 00:17:23.920 ⇒ 00:17:24.710 Mustafa Raja: Okay.
217 00:17:24.710 ⇒ 00:17:28.049 Demilade Agboola: Do you have access to the BigQuery?
218 00:17:28.560 ⇒ 00:17:29.360 Demilade Agboola: I’ll share it to you.
219 00:17:29.360 ⇒ 00:17:29.960 Mustafa Raja: Nope.
220 00:17:30.900 ⇒ 00:17:31.750 Demilade Agboola: I’m gonna do it myself.
221 00:17:32.910 ⇒ 00:17:33.670 Mustafa Raja: Okay.
222 00:17:35.930 ⇒ 00:17:40.460 Demilade Agboola: console… Because I’m like…
223 00:18:05.000 ⇒ 00:18:08.770 Demilade Agboola: on, spin.
224 00:18:23.060 ⇒ 00:18:23.910 Demilade Agboola: Let’s see…
225 00:18:58.850 ⇒ 00:18:59.550 Demilade Agboola: So…
226 00:19:17.840 ⇒ 00:19:21.480 Demilade Agboola: Alright, I’m trying to do…
227 00:19:29.700 ⇒ 00:19:32.450 Demilade Agboola: So I’m trying to do the direct query in…
228 00:19:37.640 ⇒ 00:19:38.670 Mustafa Raja: Iniquity.
229 00:19:38.670 ⇒ 00:19:40.750 Demilade Agboola: Yes, I’m just trying to do a…
230 00:19:49.900 ⇒ 00:19:50.610 Demilade Agboola: Right.
231 00:20:06.770 ⇒ 00:20:10.959 Demilade Agboola: I’m trying to… Is it close to…
232 00:20:24.770 ⇒ 00:20:25.699 Demilade Agboola: Going across time.
233 00:20:28.160 ⇒ 00:20:29.030 Demilade Agboola: Bones.
234 00:20:46.200 ⇒ 00:20:47.959 Demilade Agboola: Almost there. Sorry.
235 00:20:48.740 ⇒ 00:20:49.930 Mustafa Raja: Okay, no worries.
236 00:22:09.920 ⇒ 00:22:14.580 Demilade Agboola: Can I see the card numbers for… can you go to Tableau? Can I see what the card numbers look like?
237 00:22:16.160 ⇒ 00:22:20.149 Mustafa Raja: So this. This would be the correct numbers, yeah.
238 00:23:20.660 ⇒ 00:23:21.740 Demilade Agboola: Hmm…
239 00:23:30.740 ⇒ 00:23:32.699 Mustafa Raja: Do you think this migration went well?
240 00:23:34.250 ⇒ 00:23:35.649 Demilade Agboola: I think, I think so.
241 00:23:36.510 ⇒ 00:23:42.939 Demilade Agboola: It’s been pretty… It was pretty… it was pretty fast.
242 00:23:43.050 ⇒ 00:23:44.860 Demilade Agboola: Like, honestly, I’m pretty fussed.
243 00:23:45.460 ⇒ 00:23:52.480 Mustafa Raja: Yeah, I guess, I guess we could… we only had… we had, major issues with a few of the charts only, right?
244 00:23:52.760 ⇒ 00:23:55.020 Mustafa Raja: Which I think should be expected, right?
245 00:23:56.230 ⇒ 00:24:00.070 Demilade Agboola: Yeah, for the most part, like, again, I think it was a pretty… pretty smooth…
246 00:24:00.360 ⇒ 00:24:09.920 Demilade Agboola: Migration, especially when you think about the fact that you’re converting things from… like… 1 beta…
247 00:24:10.890 ⇒ 00:24:13.130 Demilade Agboola: System to another data system.
248 00:24:14.400 ⇒ 00:24:17.929 Demilade Agboola: Like, that doesn’t… like, that’s not always the easiest, because, like.
249 00:24:18.950 ⇒ 00:24:22.010 Demilade Agboola: Certain things are weird across systems.
250 00:24:22.710 ⇒ 00:24:24.330 Mustafa Raja: Yeah, I guess you’re arguing.
251 00:24:24.560 ⇒ 00:24:28.810 Demilade Agboola: Yeah, so, like, translating the logic across systems is not always the easiest.
252 00:24:33.350 ⇒ 00:24:34.000 Mustafa Raja: Yep.
253 00:24:35.080 ⇒ 00:24:38.080 Demilade Agboola: Sorry, can I see the total cohort size?
254 00:24:38.880 ⇒ 00:24:40.669 Mustafa Raja: Total cohort size…
255 00:24:40.670 ⇒ 00:24:42.399 Demilade Agboola: Do you… do you put that there?
256 00:24:44.120 ⇒ 00:24:47.989 Mustafa Raja: Hmm… Is there a total bonus size?
257 00:24:48.280 ⇒ 00:24:55.250 Demilade Agboola: That’s fine. Alright, so here’s the thing, and I’ll quickly share my screen.
258 00:24:55.810 ⇒ 00:24:56.520 Mustafa Raja: Market.
259 00:24:57.170 ⇒ 00:25:00.019 Demilade Agboola: Something is… something’s wrong somewhere.
260 00:25:00.430 ⇒ 00:25:03.920 Demilade Agboola: with, in the sandstop.
261 00:25:06.940 ⇒ 00:25:12.010 Demilade Agboola: I’m saying here are sum up the distinct… you do months since first order as it goes to 1, right?
262 00:25:13.380 ⇒ 00:25:16.089 Mustafa Raja: I think… not here.
263 00:25:16.820 ⇒ 00:25:19.340 Mustafa Raja: Not in this one, not in this query.
264 00:25:25.890 ⇒ 00:25:28.260 Mustafa Raja: It was in the other one, I believe, only.
265 00:25:35.270 ⇒ 00:25:39.129 Mustafa Raja: I think here this one is excluded only, I think.
266 00:25:54.420 ⇒ 00:25:55.929 Demilade Agboola: That was a good book with.
267 00:25:56.880 ⇒ 00:25:59.589 Demilade Agboola: I’m trying to see if I can match the numbers…
268 00:26:03.220 ⇒ 00:26:04.390 Mustafa Raja: Yeah…
269 00:26:24.330 ⇒ 00:26:26.240 Mustafa Raja: Yeah, it’s a lot different still, no?
270 00:26:27.260 ⇒ 00:26:27.880 Demilade Agboola: What’s that?
271 00:26:28.900 ⇒ 00:26:32.890 Mustafa Raja: I think it’s a lot diff… mmm, is it… yeah, it’s a lot different.
272 00:26:33.860 ⇒ 00:26:35.949 Demilade Agboola: Yeah, yeah, it’s not very much in the cohort.
273 00:26:37.600 ⇒ 00:26:40.410 Demilade Agboola: It’s close. It’s just not matching.
274 00:26:40.410 ⇒ 00:26:44.360 Mustafa Raja: I think we want to match the other one, no? The offer one was already good, no?
275 00:26:44.740 ⇒ 00:26:51.170 Demilade Agboola: Yeah, yeah, but if we’re matching this… Then…
276 00:26:53.510 ⇒ 00:26:59.019 Demilade Agboola: So this is what I’m saying, like, we’re above it, which is what I expect, because if we’re doing…
277 00:27:00.510 ⇒ 00:27:01.350 Demilade Agboola: S.
278 00:27:12.070 ⇒ 00:27:15.770 Demilade Agboola: We’re doing not equals to… this.
279 00:27:21.660 ⇒ 00:27:25.280 Demilade Agboola: Because, in fact, let me even put it in context for you, in fact.
280 00:27:25.670 ⇒ 00:27:31.420 Demilade Agboola: We should be higher than this, because What you’re looking for is…
281 00:27:36.900 ⇒ 00:27:37.670 Demilade Agboola: this.
282 00:27:45.850 ⇒ 00:27:50.650 Demilade Agboola: Right, there’s a list, we’re only looking at… 20.
283 00:28:41.610 ⇒ 00:28:42.390 Demilade Agboola: Where’s mine?
284 00:28:51.270 ⇒ 00:28:52.140 Demilade Agboola: Hmm…
285 00:30:06.410 ⇒ 00:30:07.639 Mustafa Raja: Is this closer now?
286 00:30:09.500 ⇒ 00:30:11.680 Demilade Agboola: That’s what I’m trying to compare. One sec.
287 00:30:35.390 ⇒ 00:30:39.580 Mustafa Raja: I think scrollbar should be able to get the two in one view now.
288 00:30:42.200 ⇒ 00:30:43.850 Mustafa Raja: There’s a way to remove that.
289 00:30:44.600 ⇒ 00:30:47.309 Mustafa Raja: I don’t think… I don’t think there is a way.
290 00:30:48.390 ⇒ 00:30:50.689 Demilade Agboola: I know there is. I think I’ve seen…
291 00:30:50.690 ⇒ 00:30:51.550 Mustafa Raja: Oh.
292 00:30:51.730 ⇒ 00:30:52.460 Mustafa Raja: Okay, okay.
293 00:30:54.330 ⇒ 00:30:55.989 Demilade Agboola: But it’s just annoying.
294 00:30:56.300 ⇒ 00:31:00.430 Mustafa Raja: I tried to do, but I couldn’t find any solution for this.
295 00:31:09.470 ⇒ 00:31:11.639 Demilade Agboola: Let’s get Justin my screen.
296 00:31:13.120 ⇒ 00:31:13.940 Demilade Agboola: Much better.
297 00:31:17.770 ⇒ 00:31:18.660 Demilade Agboola: Okay.
298 00:31:19.330 ⇒ 00:31:22.420 Demilade Agboola: So this is 7 missing 10.
299 00:31:23.010 ⇒ 00:31:27.210 Demilade Agboola: They’re saying 216, it’s kind of low… higher, like, lower.
300 00:31:27.630 ⇒ 00:31:31.019 Demilade Agboola: This is around the same… actually, no, I think…
301 00:31:34.660 ⇒ 00:31:36.360 Mustafa Raja: I think for February 2020, so…
302 00:31:37.020 ⇒ 00:31:37.700 Demilade Agboola: Yeah.
303 00:31:46.090 ⇒ 00:31:50.970 Demilade Agboola: 47… It’s a weird lore, I think.
304 00:31:53.390 ⇒ 00:31:57.170 Demilade Agboola: This is… We’re lower.
305 00:31:59.420 ⇒ 00:32:02.470 Demilade Agboola: That’s amazing. I wonder what’s going on here. Oh, shit.
306 00:32:12.830 ⇒ 00:32:21.059 Demilade Agboola: But ultimately, even if you use this, this should be, like, what you’re getting. That’ll be way higher than, like, what… I don’t know why your numbers are so low, like…
307 00:32:21.380 ⇒ 00:32:24.509 Demilade Agboola: That’s what is stressing me out, though, like…
308 00:32:26.920 ⇒ 00:32:29.729 Demilade Agboola: Can I see your, your, your logic again?
309 00:32:30.430 ⇒ 00:32:31.260 Mustafa Raja: Yep.
310 00:32:36.430 ⇒ 00:32:39.019 Mustafa Raja: So this is the whole logic.
311 00:32:40.830 ⇒ 00:32:43.259 Demilade Agboola: You’re doing this…
312 00:32:44.330 ⇒ 00:32:52.449 Mustafa Raja: And I’m not even split… the filter… so you, you added one filter for, pharmacies, right?
313 00:32:52.840 ⇒ 00:32:55.169 Demilade Agboola: Yeah. Or actually, channels.
314 00:32:55.700 ⇒ 00:32:59.910 Mustafa Raja: Oh, sorry, yeah, channels, so that’s… that’s… I haven’t done it…
315 00:33:00.430 ⇒ 00:33:02.239 Demilade Agboola: That way, so…
316 00:33:04.450 ⇒ 00:33:07.390 Mustafa Raja: So if I do it, then the values are going to go lower.
317 00:33:11.460 ⇒ 00:33:12.859 Mustafa Raja: Which is another issue.
318 00:33:32.200 ⇒ 00:33:34.140 Mustafa Raja: The table is the correct one, right?
319 00:33:35.140 ⇒ 00:33:38.430 Mustafa Raja: This, is this correctable? Return on ad spend.
320 00:33:39.260 ⇒ 00:33:42.210 Mustafa Raja: I see that it’s being used here.
321 00:33:42.410 ⇒ 00:33:44.810 Mustafa Raja: That’s why we’re working with it.
322 00:33:45.780 ⇒ 00:33:54.109 Mustafa Raja: Another issue is if I… if I were to filter it, I don’t think that it changes anything here. So, if I… let me add just one…
323 00:33:54.700 ⇒ 00:33:59.940 Mustafa Raja: Let’s add… let me just affiliate… I think that this isn’t going to change anything.
324 00:34:00.850 ⇒ 00:34:02.679 Mustafa Raja: Oh, it does change, sorry.
325 00:34:06.140 ⇒ 00:34:13.050 Mustafa Raja: Yeah, earlier I was trying to put a filter, and it didn’t have any effect, so I assumed that something might be broken there, too.
326 00:35:05.050 ⇒ 00:35:06.430 Mustafa Raja: So, what do you think about this?
327 00:35:12.960 ⇒ 00:35:14.070 Demilade Agboola: One second.
328 00:35:14.960 ⇒ 00:35:15.610 Mustafa Raja: Nope.
329 00:36:52.200 ⇒ 00:36:53.249 Demilade Agboola: Let’s try something.
330 00:36:53.960 ⇒ 00:36:54.630 Mustafa Raja: Yep.
331 00:37:05.660 ⇒ 00:37:06.550 Demilade Agboola: lists?
332 00:37:14.590 ⇒ 00:37:18.450 Demilade Agboola: I’m trying to, I’ll send it, I’ll send the query over to you now.
333 00:37:20.060 ⇒ 00:37:20.760 Mustafa Raja: Okay.
334 00:39:21.010 ⇒ 00:39:22.070 Demilade Agboola: Sorry, my boy.
335 00:39:22.340 ⇒ 00:39:24.449 Demilade Agboola: Well, to send it to you.
336 00:40:11.890 ⇒ 00:40:21.559 Demilade Agboola: So, you would have to put… So, replace… March… With the name of…
337 00:40:22.110 ⇒ 00:40:27.549 Demilade Agboola: the column, like, how it is put in there. But, like, just try… try… I sent it in the chat.
338 00:40:28.600 ⇒ 00:40:29.950 Mustafa Raja: Zoom chat, okay.
339 00:40:31.970 ⇒ 00:40:36.300 Mustafa Raja: Okay, so I should just replace it with this, and then it should work, right?
340 00:40:36.800 ⇒ 00:40:42.869 Demilade Agboola: Try, no, try replacing it with, like, replace matched with the name of the column, like the…
341 00:40:43.480 ⇒ 00:40:49.409 Demilade Agboola: dollar sign, prod dbt match, blah blah blah. So you see the word match in there.
342 00:40:50.170 ⇒ 00:40:50.490 Mustafa Raja: Yeah.
343 00:40:50.490 ⇒ 00:40:51.420 Demilade Agboola: felt much.
344 00:40:55.030 ⇒ 00:40:57.200 Mustafa Raja: Okay, replace this with mast, right?
345 00:40:57.740 ⇒ 00:40:58.310 Demilade Agboola: Yes.
346 00:40:58.980 ⇒ 00:41:00.929 Demilade Agboola: Or replace matched with that.
347 00:41:01.460 ⇒ 00:41:03.080 Mustafa Raja: Yeah, give me a moment.
348 00:41:35.790 ⇒ 00:41:38.450 Mustafa Raja: Yeah, let me know… yeah, it looks good or not.
349 00:41:40.500 ⇒ 00:41:41.080 Mustafa Raja: Oh…
350 00:41:41.080 ⇒ 00:41:41.710 Demilade Agboola: So this…
351 00:41:41.710 ⇒ 00:41:43.110 Mustafa Raja: Also, then, right?
352 00:41:43.110 ⇒ 00:41:45.059 Demilade Agboola: Yes, he has another one here.
353 00:41:46.450 ⇒ 00:41:47.780 Mustafa Raja: Okay, I didn’t see it.
354 00:41:47.970 ⇒ 00:41:50.819 Mustafa Raja: Yeah, this, is it… is it better now?
355 00:41:51.300 ⇒ 00:41:53.559 Demilade Agboola: Yes. Stress evening, does it work?
356 00:41:54.470 ⇒ 00:41:56.449 Mustafa Raja: Let me see… update.
357 00:41:59.430 ⇒ 00:42:00.100 Mustafa Raja: Hmm.
358 00:42:00.100 ⇒ 00:42:00.690 Demilade Agboola: Sure.
359 00:42:11.640 ⇒ 00:42:12.869 Mustafa Raja: What is the error?
360 00:42:17.190 ⇒ 00:42:19.449 Demilade Agboola: Also, the offer, I think the offer should be capital O.
361 00:42:19.750 ⇒ 00:42:20.540 Demilade Agboola: To be honest.
362 00:42:24.070 ⇒ 00:42:27.030 Demilade Agboola: Okay, alright, yeah, this is the…
363 00:42:28.370 ⇒ 00:42:30.399 Demilade Agboola: Oh, God, can make the strings.
364 00:42:33.100 ⇒ 00:42:37.630 Demilade Agboola: wants to separate that by white space, but they are. Like, try…
365 00:42:37.630 ⇒ 00:42:38.480 Mustafa Raja: Oh, good.
366 00:42:39.210 ⇒ 00:42:40.370 Demilade Agboola: That’s our module.
367 00:42:41.310 ⇒ 00:42:42.030 Demilade Agboola: Okay.
368 00:42:42.410 ⇒ 00:42:44.970 Demilade Agboola: Like, we aren’t concoctinating anything.
369 00:42:46.690 ⇒ 00:42:49.870 Demilade Agboola: Could it be that we need to add space between each of these?
370 00:42:54.040 ⇒ 00:42:55.840 Demilade Agboola: Let me just… do that.
371 00:42:55.840 ⇒ 00:42:56.780 Mustafa Raja: Good climate.
372 00:43:04.620 ⇒ 00:43:06.409 Mustafa Raja: This is a big question here.
373 00:43:08.720 ⇒ 00:43:09.410 Demilade Agboola: What’s here?
374 00:43:10.180 ⇒ 00:43:11.929 Mustafa Raja: This error is coming from BigQuery.
375 00:43:12.610 ⇒ 00:43:13.290 Demilade Agboola: Yes.
376 00:43:14.320 ⇒ 00:43:15.040 Demilade Agboola: Richard.
377 00:43:15.390 ⇒ 00:43:17.220 Demilade Agboola: Oh, I’ve seen it. I’ve seen the error.
378 00:43:17.670 ⇒ 00:43:22.350 Demilade Agboola: Between Influencer and influencers, there was… No comma.
379 00:43:23.840 ⇒ 00:43:24.780 Demilade Agboola: Can you see it?
380 00:43:25.750 ⇒ 00:43:29.690 Mustafa Raja: Between influencer and influencer… oh, yeah.
381 00:43:29.990 ⇒ 00:43:31.170 Demilade Agboola: I found the area.
382 00:43:31.290 ⇒ 00:43:31.970 Demilade Agboola: Can we trade now?
383 00:43:32.330 ⇒ 00:43:33.580 Mustafa Raja: Yay, yep.
384 00:43:36.360 ⇒ 00:43:43.180 Mustafa Raja: Okay… Expected keyword then, but god, the literal this.
385 00:43:44.650 ⇒ 00:43:46.669 Demilade Agboola: Oh, put equals to the offer?
386 00:43:48.840 ⇒ 00:43:52.560 Demilade Agboola: put when blah blah blah channel is equal… no, no, first equals to the offer.
387 00:43:54.540 ⇒ 00:43:57.190 Demilade Agboola: Equals, yeah. Equals, equals 3.
388 00:43:58.480 ⇒ 00:43:59.159 Demilade Agboola: No, no, no.
389 00:43:59.160 ⇒ 00:43:59.550 Mustafa Raja: Oh, cool.
390 00:43:59.550 ⇒ 00:44:00.759 Demilade Agboola: to sign, yeah.
391 00:44:01.530 ⇒ 00:44:02.700 Demilade Agboola: Enter it again.
392 00:44:05.920 ⇒ 00:44:07.060 Mustafa Raja: Okay.
393 00:44:15.380 ⇒ 00:44:16.830 Mustafa Raja: I think it’s the same.
394 00:44:17.830 ⇒ 00:44:19.450 Demilade Agboola: Yeah, it looks the same.
395 00:44:22.820 ⇒ 00:44:25.230 Mustafa Raja: It added one more column that’s null.
396 00:44:34.010 ⇒ 00:44:46.290 Mustafa Raja: So, for March 195, 1260, and plus 600 to… 160…
397 00:44:46.690 ⇒ 00:44:49.930 Mustafa Raja: In 69th is still falling short.
398 00:44:50.080 ⇒ 00:44:51.200 Demilade Agboola: Yeah, still short.
399 00:44:53.330 ⇒ 00:44:57.250 Mustafa Raja: Yeah, I thought that we might just be… Nope.
400 00:44:57.890 ⇒ 00:45:01.309 Demilade Agboola: It’s not going to be a sum, like, let’s see, what’s the core size?
401 00:45:02.940 ⇒ 00:45:03.710 Mustafa Raja: Sorry?
402 00:45:03.900 ⇒ 00:45:06.670 Demilade Agboola: Core size is 1260.
403 00:45:07.630 ⇒ 00:45:08.790 Mustafa Raja: than 600.
404 00:45:10.460 ⇒ 00:45:13.320 Demilade Agboola: That was, like, one-eighth, basically.
405 00:45:13.950 ⇒ 00:45:15.300 Demilade Agboola: 1862.
406 00:45:16.460 ⇒ 00:45:19.469 Mustafa Raja: Yeah, and then it’s 2400 here.
407 00:45:20.330 ⇒ 00:45:22.219 Demilade Agboola: Okay, still very short.
408 00:45:22.420 ⇒ 00:45:23.860 Mustafa Raja: Yeah, still short.
409 00:45:26.350 ⇒ 00:45:30.500 Demilade Agboola: What about the lowers, let’s see. 15, 40, 54…
410 00:45:32.320 ⇒ 00:45:37.380 Mustafa Raja: And then… 2100, I believe.
411 00:45:37.880 ⇒ 00:45:40.270 Demilade Agboola: Yeah, so I was trying to find… Yeah, it’s still short.
412 00:45:42.970 ⇒ 00:45:50.200 Mustafa Raja: Then 1400 here, and then… 900… And 300, it’s still short.
413 00:45:50.800 ⇒ 00:45:52.749 Mustafa Raja: It’s short by 100 or something.
414 00:45:56.180 ⇒ 00:46:03.160 Mustafa Raja: This one, 191470. So this becomes 1370?
415 00:46:03.830 ⇒ 00:46:05.650 Mustafa Raja: This is a large shirt.
416 00:46:06.000 ⇒ 00:46:07.569 Mustafa Raja: This is Lake Harvest.
417 00:46:07.570 ⇒ 00:46:11.320 Demilade Agboola: Something is… something’s wrong somewhere, and that’s why I did things here.
418 00:46:16.010 ⇒ 00:46:21.870 Mustafa Raja: I mean… Are we sure that this is the right table, though?
419 00:46:23.160 ⇒ 00:46:26.950 Mustafa Raja: Are you working on this one exactly in BigQuery?
420 00:46:27.870 ⇒ 00:46:28.620 Demilade Agboola: Yes.
421 00:46:29.160 ⇒ 00:46:31.510 Mustafa Raja: Okay, okay. Then this should be good.
422 00:46:32.160 ⇒ 00:46:36.750 Mustafa Raja: And we don’t have any joins too, so we are working with this table only.
423 00:46:39.480 ⇒ 00:46:43.409 Mustafa Raja: So… so there’s no other table that’s messing up the results.
424 00:46:44.170 ⇒ 00:46:47.469 Mustafa Raja: It should be with how we are querying, I believe.
425 00:46:48.160 ⇒ 00:46:56.430 Demilade Agboola: I’m going to do something. I’ll make a fix to the table, and I’ll ask you to use that fix, that column instance, as the channel group. I’ll see if that works.
426 00:46:57.270 ⇒ 00:47:02.520 Mustafa Raja: Do you want to take a look at this query, the whole query that Omni is using to create these results?
427 00:47:03.540 ⇒ 00:47:04.210 Demilade Agboola: Sure.
428 00:47:04.910 ⇒ 00:47:06.400 Mustafa Raja: Yeah, this is the query.
429 00:47:13.010 ⇒ 00:47:14.050 Demilade Agboola: Perfect sense to me.
430 00:47:14.730 ⇒ 00:47:17.270 Mustafa Raja: Oh, yeah, I’m sharing the screen.
431 00:47:17.510 ⇒ 00:47:20.529 Mustafa Raja: I can share it in the Zoom chat.
432 00:47:22.170 ⇒ 00:47:23.980 Mustafa Raja: Let me share it in the Zoom chat.
433 00:47:26.920 ⇒ 00:47:30.090 Demilade Agboola: No, it’s quite long, I don’t think it would work in the Zoom chat.
434 00:47:31.700 ⇒ 00:47:32.700 Mustafa Raja: Oh, yeah, I agree.
435 00:47:33.310 ⇒ 00:47:34.850 Mustafa Raja: Give me a moment, then.
436 00:47:36.420 ⇒ 00:47:37.560 Mustafa Raja: Hmm…
437 00:47:45.000 ⇒ 00:47:48.229 Mustafa Raja: Yeah, I sent you in the… What’s it called?
438 00:47:48.520 ⇒ 00:47:49.580 Mustafa Raja: In the Slack.
439 00:48:49.100 ⇒ 00:48:52.030 Mustafa Raja: Have you been following the updates this week?
440 00:48:53.650 ⇒ 00:48:54.539 Mustafa Raja: For the world politics.
441 00:48:56.580 ⇒ 00:48:57.719 Demilade Agboola: I’ll play it, Tommy.
442 00:48:58.550 ⇒ 00:49:00.059 Mustafa Raja: The world politics.
443 00:49:00.770 ⇒ 00:49:02.290 Demilade Agboola: I’m… I mean, a bit.
444 00:49:03.420 ⇒ 00:49:04.200 Mustafa Raja: Okay, okay.
445 00:49:04.450 ⇒ 00:49:07.270 Mustafa Raja: Do you sort of use Instagram or something for that?
446 00:49:08.920 ⇒ 00:49:09.850 Demilade Agboola: Fair… what?
447 00:49:10.510 ⇒ 00:49:14.069 Mustafa Raja: Do you use Instagram for that? Like, do you get, you know?
448 00:49:14.500 ⇒ 00:49:21.999 Demilade Agboola: Not really. I do, like, Twitter. There’s certain accounts I follow that just, like, tweet only, like, political or financial news.
449 00:49:22.700 ⇒ 00:49:25.270 Mustafa Raja: Okay, okay, okay, yeah, I don’t use Twitter at all.
450 00:49:25.540 ⇒ 00:49:28.340 Mustafa Raja: I get my news from Instagram.
451 00:49:34.190 ⇒ 00:49:38.530 Mustafa Raja: Yeah, I think I should do Twitter, because Utam also uses Twitter.
452 00:49:38.900 ⇒ 00:49:42.289 Mustafa Raja: And I think Twitter is just more authentic, or something.
453 00:49:43.860 ⇒ 00:49:51.780 Demilade Agboola: Okay, yeah, I… Alright, I’m trying to, like, read the query, that’s why I sound a bit distracted.
454 00:49:52.480 ⇒ 00:49:54.039 Mustafa Raja: No, no, no, it’s okay.
455 00:54:45.640 ⇒ 00:54:47.270 Demilade Agboola: Oh…
456 00:54:49.040 ⇒ 00:54:50.040 Mustafa Raja: Did we get it?
457 00:54:50.540 ⇒ 00:54:52.359 Demilade Agboola: Not yet, but I have an idea what’s going on.
458 00:54:53.260 ⇒ 00:54:54.020 Mustafa Raja: Okay, okay.
459 00:54:55.480 ⇒ 00:54:56.980 Demilade Agboola: Omnis are playing in max.
460 00:54:58.970 ⇒ 00:54:59.470 Demilade Agboola: Q2.
461 00:54:59.470 ⇒ 00:55:01.110 Mustafa Raja: Why am I be playing Max?
462 00:55:03.690 ⇒ 00:55:08.410 Mustafa Raja: Here. But this is what, Cursor suggested me to do.
463 00:55:10.930 ⇒ 00:55:13.140 Mustafa Raja: Let me add sums here also.
464 00:55:13.570 ⇒ 00:55:27.779 Mustafa Raja: So, cumulative revenue… So let me aggregate it to a sum also… And then… I think Gohu says…
465 00:55:30.240 ⇒ 00:55:33.509 Demilade Agboola: It’s doing these things, customers, Max, that’s cool what it says.
466 00:55:36.030 ⇒ 00:55:36.940 Mustafa Raja: Sorry?
467 00:55:36.940 ⇒ 00:55:38.049 Demilade Agboola: This thing’s customized.
468 00:55:38.050 ⇒ 00:55:39.259 Mustafa Raja: Customers, okay, okay.
469 00:55:39.430 ⇒ 00:55:47.420 Mustafa Raja: Busting customers… The sum… Hopefully that fixes it.
470 00:55:48.040 ⇒ 00:55:50.930 Mustafa Raja: Doesn’t fix it. I don’t think this.
471 00:55:51.180 ⇒ 00:55:52.680 Mustafa Raja: This fixed it.
472 00:55:58.720 ⇒ 00:56:00.630 Mustafa Raja: Yeah, this didn’t fix it.
473 00:56:00.940 ⇒ 00:56:02.649 Mustafa Raja: Because it’s too? No.
474 00:56:05.090 ⇒ 00:56:07.300 Demilade Agboola: I think you might need a modeling fix for this.
475 00:56:07.990 ⇒ 00:56:09.840 Mustafa Raja: Mmm, yeah, I think they seem…
476 00:56:12.090 ⇒ 00:56:18.219 Mustafa Raja: I think it’s just how, Omni, you know, aggregates stuff, and how Tableau does it, right?
477 00:56:20.660 ⇒ 00:56:24.330 Mustafa Raja: Yeah, it’s just a level of detail thing then, right?
478 00:56:28.780 ⇒ 00:56:29.680 Mustafa Raja: Okay, then…
479 00:56:30.770 ⇒ 00:56:34.250 Demilade Agboola: I have a meeting, so I need to hop, but yeah, I would look into it.
480 00:56:36.450 ⇒ 00:56:39.510 Mustafa Raja: Yeah, it would be nice if we can get this through.
481 00:56:39.620 ⇒ 00:56:41.170 Mustafa Raja: early this week?
482 00:56:41.190 ⇒ 00:56:43.880 Demilade Agboola: In the first half, because…
483 00:56:43.880 ⇒ 00:56:48.470 Mustafa Raja: I think this week, any, any time, this is going down.
484 00:56:49.360 ⇒ 00:56:55.520 Demilade Agboola: Yeah, that’s fair, that’s fair. I will… I will look into… I’ll look into that.
485 00:56:55.860 ⇒ 00:56:59.909 Mustafa Raja: And then we… and then… and then I think you have 2 more tickets.
486 00:57:00.220 ⇒ 00:57:01.580 Mustafa Raja: Two more.
487 00:57:01.580 ⇒ 00:57:02.310 Demilade Agboola: Tomorrow.
488 00:57:03.380 ⇒ 00:57:07.540 Mustafa Raja: These are two tickets, but I think the fix is going to be the same.
489 00:57:07.540 ⇒ 00:57:09.010 Demilade Agboola: Alright, sounds good.
490 00:57:09.050 ⇒ 00:57:10.970 Mustafa Raja: I’ll push that today.
491 00:57:10.970 ⇒ 00:57:13.070 Demilade Agboola: And then we’ll have a…
492 00:57:13.650 ⇒ 00:57:15.430 Mustafa Raja: Nye, thank you!
493 00:57:15.430 ⇒ 00:57:16.090 Demilade Agboola: Alright.
494 00:57:16.620 ⇒ 00:57:18.579 Mustafa Raja: Yeah, you’ve been a good help, thank you so much.
495 00:57:20.730 ⇒ 00:57:21.600 Mustafa Raja: Yeah.