Meeting Title: Omni Migration Project Check-in Date: 2026-02-26 Meeting participants: Greg Stoutenburg, Mustafa Raja
WEBVTT
1 00:00:21.820 ⇒ 00:00:23.689 Greg Stoutenburg: Arka, no, no, no, no!
2 00:00:28.590 ⇒ 00:00:29.350 Mustafa Raja: Hey.
3 00:00:33.870 ⇒ 00:00:35.180 Mustafa Raja: Hey, Mustafa, how’s it going?
4 00:00:36.000 ⇒ 00:00:37.429 Mustafa Raja: Yeah, going good, how are you?
5 00:00:37.910 ⇒ 00:00:39.060 Greg Stoutenburg: Doing alright.
6 00:00:40.590 ⇒ 00:00:45.099 Mustafa Raja: Were you able to take a look at some of the comments that I left?
7 00:00:45.730 ⇒ 00:00:49.429 Greg Stoutenburg: Let’s see… I haven’t seen any today, so let me.
8 00:00:50.840 ⇒ 00:00:54.180 Mustafa Raja: Yeah, let’s take a look at… let’s first take a look at what’s it called.
9 00:00:54.180 ⇒ 00:00:56.550 Greg Stoutenburg: Okay. Do you want to screen share? Walk me through it?
10 00:00:56.550 ⇒ 00:00:58.300 Mustafa Raja: Yeah, let me do… let me try.
11 00:00:58.300 ⇒ 00:00:58.950 Greg Stoutenburg: Cool.
12 00:01:06.970 ⇒ 00:01:07.800 Mustafa Raja: Okay.
13 00:01:11.440 ⇒ 00:01:12.350 Mustafa Raja: This one.
14 00:01:12.790 ⇒ 00:01:20.749 Mustafa Raja: And then… This one… Actually… let’s go from here.
15 00:01:28.860 ⇒ 00:01:30.850 Mustafa Raja: Isn’t this true?
16 00:01:32.590 ⇒ 00:01:37.780 Greg Stoutenburg: Yeah, I created one thread in the migration channel yesterday. Yep, that’s it, yep.
17 00:01:44.950 ⇒ 00:01:47.100 Mustafa Raja: Yeah, my Wi-Fi is a little slow, I’m on the.
18 00:01:47.100 ⇒ 00:01:49.589 Greg Stoutenburg: I was gonna say, it stopped moving.
19 00:01:51.720 ⇒ 00:01:53.580 Mustafa Raja: Yeah, empty.
20 00:01:59.060 ⇒ 00:02:01.169 Mustafa Raja: Let’s just go from here, okay.
21 00:02:02.380 ⇒ 00:02:05.269 Mustafa Raja: Yeah, so…
22 00:02:07.340 ⇒ 00:02:17.259 Mustafa Raja: Yeah, so there’s one, only one filter left. This filter is a little confusing, because there’s already a date range, and then there’s this date also.
23 00:02:17.260 ⇒ 00:02:17.700 Greg Stoutenburg: Okay.
24 00:02:17.700 ⇒ 00:02:23.879 Mustafa Raja: So I’ll figure this out, you know? I have this one configured, I’ll figure out what this does, and then I’ll add that.
25 00:02:24.210 ⇒ 00:02:29.740 Mustafa Raja: The rest of it should be done. The bottom chart is different than top blue.
26 00:02:30.160 ⇒ 00:02:33.840 Mustafa Raja: Let’s see what you sent here. The bottom chart is different.
27 00:02:37.360 ⇒ 00:02:40.479 Mustafa Raja: Oh, so this is for profit.
28 00:02:42.830 ⇒ 00:02:58.559 Mustafa Raja: This is, different grain of value. Oh, yeah, yeah, if you would see that, this is just a different grain, right? So we are just, here they are just saying negative 0.5 million, right? And you’d see it’s negative, 500,000 here.
29 00:02:58.560 ⇒ 00:02:59.260 Greg Stoutenburg: Oh.
30 00:02:59.770 ⇒ 00:03:00.690 Greg Stoutenburg: Yeah.
31 00:03:01.230 ⇒ 00:03:03.630 Mustafa Raja: There’s just different green, and I think…
32 00:03:03.630 ⇒ 00:03:04.820 Greg Stoutenburg: Good catch, okay.
33 00:03:04.930 ⇒ 00:03:05.500 Greg Stoutenburg: You see.
34 00:03:05.500 ⇒ 00:03:09.850 Mustafa Raja: that this is 0.0, this just doesn’t tell us anything.
35 00:03:10.810 ⇒ 00:03:11.490 Greg Stoutenburg: Yeah.
36 00:03:13.000 ⇒ 00:03:16.319 Mustafa Raja: Yeah. So, let’s see, whereas the top one, yeah…
37 00:03:17.060 ⇒ 00:03:18.360 Greg Stoutenburg: Okay, so…
38 00:03:18.360 ⇒ 00:03:20.459 Mustafa Raja: I think this might just add more value.
39 00:03:21.170 ⇒ 00:03:22.020 Greg Stoutenburg: Yeah.
40 00:03:22.620 ⇒ 00:03:26.199 Mustafa Raja: Let me know your thoughts. If so, I can just close this, call it up.
41 00:03:26.200 ⇒ 00:03:31.939 Greg Stoutenburg: Yeah, let’s just close that one out. Yeah, in the hundreds is better than in the millions. Thank you for catching that.
42 00:03:32.590 ⇒ 00:03:34.599 Greg Stoutenburg: What’s the one that you said is a bug?
43 00:03:35.630 ⇒ 00:03:39.330 Mustafa Raja: Yeah, yeah, let me take a look at that one also.
44 00:03:39.550 ⇒ 00:03:44.149 Mustafa Raja: I think… calculus is profit…
45 00:03:46.800 ⇒ 00:03:49.720 Mustafa Raja: The 6 was a bug, okay.
46 00:03:49.990 ⇒ 00:03:51.000 Mustafa Raja: Hmm…
47 00:03:52.830 ⇒ 00:04:00.639 Mustafa Raja: Yeah, so you’d see that, this is a CAC, right? So cost… I think this is cost to bring on a customer, right?
48 00:04:01.080 ⇒ 00:04:01.670 Greg Stoutenburg: Yep.
49 00:04:02.240 ⇒ 00:04:03.479 Mustafa Raja: I don’t think that’s customers.
50 00:04:03.480 ⇒ 00:04:04.400 Greg Stoutenburg: acquisition costs, yeah.
51 00:04:04.400 ⇒ 00:04:15.280 Mustafa Raja: Yeah, so a quick, simple check would be, you know, if you would hover over this, and there’s going to be a tooltip that’ll pop up.
52 00:04:15.280 ⇒ 00:04:25.149 Mustafa Raja: And that tooltip would have two things. One, profit. The other one would be CAC. And the values that are being shown over here are profit.
53 00:04:25.380 ⇒ 00:04:26.579 Mustafa Raja: And not CAC.
54 00:04:26.780 ⇒ 00:04:27.210 Greg Stoutenburg: Okay.
55 00:04:27.920 ⇒ 00:04:36.510 Mustafa Raja: So Tableau is showing, profit, profit in, in these. So, so $1.3 million is the profit, and you’d see in the, in the y-axis.
56 00:04:36.900 ⇒ 00:04:46.849 Mustafa Raja: Why access has CAC, so 0 to 120, no way $1.3 million is going to be, you know, in line with 120, right?
57 00:04:46.850 ⇒ 00:04:47.250 Greg Stoutenburg: I see.
58 00:04:47.710 ⇒ 00:04:53.160 Mustafa Raja: So, we can actually take a look at this, if this opens.
59 00:04:53.350 ⇒ 00:04:58.329 Mustafa Raja: My internet is just, you know, acting up. It just decided to act up on me.
60 00:04:58.430 ⇒ 00:04:59.500 Greg Stoutenburg: No problem.
61 00:04:59.770 ⇒ 00:05:00.400 Greg Stoutenburg: Yeah.
62 00:05:01.620 ⇒ 00:05:05.150 Mustafa Raja: Let’s take a look. Let’s just, you know, confirm.
63 00:05:05.420 ⇒ 00:05:05.970 Greg Stoutenburg: Yep.
64 00:05:10.900 ⇒ 00:05:13.439 Mustafa Raja: Okay, this is working fine.
65 00:05:30.600 ⇒ 00:05:32.169 Mustafa Raja: Any moment now.
66 00:05:33.290 ⇒ 00:05:47.520 Mustafa Raja: Oh, yeah, here we go. Yeah, so this CAC, right. So you’d see, you’d see this in this, what’s it called, in this tooltip, you’d see this CAC, that’s 119, and then there’s profit, that’s negative.
67 00:05:47.520 ⇒ 00:05:49.160 Greg Stoutenburg: Got it, yep, yep, yep.
68 00:05:49.160 ⇒ 00:05:56.409 Mustafa Raja: 1 million, and this is just, you know, mapping the wrong thing. Yeah, that’s just, that’s just it, you know?
69 00:05:56.410 ⇒ 00:06:00.429 Greg Stoutenburg: Now let’s look at the Omni screenshot again. You need to show me again.
70 00:06:00.910 ⇒ 00:06:03.180 Mustafa Raja: Oh, yeah, yeah. Yeah, just.
71 00:06:03.180 ⇒ 00:06:04.560 Greg Stoutenburg: It was number 6, right?
72 00:06:04.930 ⇒ 00:06:10.690 Greg Stoutenburg: Okay, so then in 6, here, each dot shows CAC.
73 00:06:11.090 ⇒ 00:06:11.920 Mustafa Raja: Yeah, yeah.
74 00:06:11.920 ⇒ 00:06:12.400 Greg Stoutenburg: then…
75 00:06:12.400 ⇒ 00:06:14.789 Mustafa Raja: What the actual value should be, you know?
76 00:06:14.990 ⇒ 00:06:15.870 Greg Stoutenburg: Okay.
77 00:06:16.780 ⇒ 00:06:17.740 Greg Stoutenburg: Okay.
78 00:06:17.960 ⇒ 00:06:21.400 Greg Stoutenburg: Good. Okay, good.
79 00:06:21.580 ⇒ 00:06:27.490 Greg Stoutenburg: So then, we do just want CAC, yeah, we don’t want CAC versus profit. Okay. Nice catch, yep, thank you.
80 00:06:27.900 ⇒ 00:06:28.650 Greg Stoutenburg: Very good.
81 00:06:28.650 ⇒ 00:06:29.220 Mustafa Raja: Inc.
82 00:06:29.550 ⇒ 00:06:38.400 Mustafa Raja: Okay, now… okay, so for this, I just need to figure this out. I’ll do this at the end, because the rest of the filters are good.
83 00:06:38.400 ⇒ 00:06:38.860 Greg Stoutenburg: Yeah.
84 00:06:38.880 ⇒ 00:06:43.690 Mustafa Raja: We work on the other QA. I don’t want to spend time on this right now. Yeah, no.
85 00:06:43.690 ⇒ 00:06:45.160 Greg Stoutenburg: Go for the lighter lift, yeah.
86 00:06:45.160 ⇒ 00:06:52.289 Mustafa Raja: Yeah, yeah. Let’s take a look on… let’s see if this… okay, so the links, if they are working…
87 00:06:52.290 ⇒ 00:06:55.729 Greg Stoutenburg: Yeah, Slack might be the easiest place to go, because I was just doing them in order.
88 00:06:56.680 ⇒ 00:06:59.029 Mustafa Raja: Oh, yeah, okay, hmm.
89 00:07:00.400 ⇒ 00:07:08.670 Mustafa Raja: So, for this, yeah, so, you said, so in your initial comment was, this is 2 charts, but this is actually 3 charts.
90 00:07:08.670 ⇒ 00:07:23.019 Mustafa Raja: So I, I, what’s it called? I, removed the two-chart screenshot, updated it with three charts. Now, the issue is that Omni cannot replicate this in… Omni cannot merge these three charts into one.
91 00:07:23.040 ⇒ 00:07:28.639 Mustafa Raja: Right. Okay. So we have to… we have to split this. This is something that I investigated with Demi also.
92 00:07:28.640 ⇒ 00:07:32.540 Greg Stoutenburg: Okay. And his solution was, you know, just split them.
93 00:07:32.780 ⇒ 00:07:33.500 Greg Stoutenburg: Okay.
94 00:07:34.060 ⇒ 00:07:36.590 Mustafa Raja: Yeah, so this is what I did.
95 00:07:36.590 ⇒ 00:07:46.179 Greg Stoutenburg: Now, do they line up now? Because I think that was… that was one of the issues where if you just had a vertical view and you were just scrolling down, the… the months didn’t quite line up.
96 00:07:46.180 ⇒ 00:07:54.549 Mustafa Raja: Okay, yeah. So, so, so what’s happening, in the filter, you see? Let me open it up, actually.
97 00:07:55.400 ⇒ 00:07:58.269 Mustafa Raja: Let me open it up, and let’s take a look.
98 00:08:08.480 ⇒ 00:08:19.630 Mustafa Raja: Okay, hmm… now they’re showing the full months. So what was happening prior to that? Even if this filter was last 6 months.
99 00:08:19.630 ⇒ 00:08:21.770 Greg Stoutenburg: This dashboard was being cut off.
100 00:08:22.260 ⇒ 00:08:37.759 Mustafa Raja: Yeah, this dashboard was being cut off at December, and it was not showing January and February, right? But in Omni, I didn’t… I didn’t cut off in December, because after a few months, we’ll have… we would have to, you know…
101 00:08:37.760 ⇒ 00:08:47.960 Mustafa Raja: reconfigure this chart, but it seems like some filter might have, you know, gone up or down, and this is now showing… yeah, this should be… this should be now exactly the same now. Okay.
102 00:08:48.710 ⇒ 00:08:50.350 Greg Stoutenburg: Let’s see how it looks in Eden, then.
103 00:08:51.260 ⇒ 00:08:54.750 Mustafa Raja: Yeah, yeah, well… Okay.
104 00:08:58.260 ⇒ 00:09:00.329 Mustafa Raja: Okay, I added these.
105 00:09:00.330 ⇒ 00:09:00.940 Greg Stoutenburg: Nice, yep.
106 00:09:00.940 ⇒ 00:09:02.360 Mustafa Raja: my printers and stuff.
107 00:09:02.360 ⇒ 00:09:03.470 Greg Stoutenburg: Yep, thank you.
108 00:09:05.090 ⇒ 00:09:09.140 Mustafa Raja: Okay, this one is… okay, this one, this one needs to be updated.
109 00:09:09.680 ⇒ 00:09:11.400 Mustafa Raja: Okay, I was… okay.
110 00:09:12.750 ⇒ 00:09:13.389 Greg Stoutenburg: Yeah, CC…
111 00:09:13.390 ⇒ 00:09:16.200 Mustafa Raja: I did these two. I’m bid these two.
112 00:09:16.510 ⇒ 00:09:19.809 Greg Stoutenburg: Yep. And then… okay.
113 00:09:20.460 ⇒ 00:09:21.460 Mustafa Raja: Yeah.
114 00:09:21.650 ⇒ 00:09:30.160 Mustafa Raja: Okay, so, so, so… I guess, I guess we’re good, good, good with, you know, splitting these, and then I just make sure that…
115 00:09:31.130 ⇒ 00:09:31.920 Greg Stoutenburg: Just make them wind up.
116 00:09:31.920 ⇒ 00:09:40.820 Mustafa Raja: Yeah, in the screenshot, this has January and February. Right. Anyways, I’ll make sure that this has that.
117 00:09:41.020 ⇒ 00:09:41.810 Greg Stoutenburg: Okay, cool.
118 00:09:42.800 ⇒ 00:10:00.339 Mustafa Raja: This, I need to investigate deep, you know, what’s happening. I did, ping Demilade on one of this finance stuff, on a finance KPI dashboard. He was able to mitigate that. I’ll see what his solution was to sort of replicate it here.
119 00:10:00.640 ⇒ 00:10:01.680 Greg Stoutenburg: Okay, great.
120 00:10:02.760 ⇒ 00:10:08.180 Mustafa Raja: Yeah, for this, need filters. Okay, I added filters.
121 00:10:08.400 ⇒ 00:10:09.480 Greg Stoutenburg: Yep, great.
122 00:10:09.480 ⇒ 00:10:14.089 Mustafa Raja: I want to take a look at that, let’s take a look at that. Yeah, these are the filters.
123 00:10:14.090 ⇒ 00:10:15.059 Greg Stoutenburg: Yep, there they are.
124 00:10:16.170 ⇒ 00:10:21.370 Mustafa Raja: Yeah, this is just a text key. Okay, now this is something deep.
125 00:10:21.570 ⇒ 00:10:25.090 Mustafa Raja: Two things. Pltv, right?
126 00:10:26.520 ⇒ 00:10:31.450 Mustafa Raja: BMTV… Okay, so…
127 00:10:33.790 ⇒ 00:10:47.040 Mustafa Raja: So here, the PLTV that’s being used, in Omni is coming directly from, what’s it called? DBT, right? But, the Tableau one isn’t using the PLTV…
128 00:10:47.810 ⇒ 00:10:59.809 Mustafa Raja: Sorry. Tableau 1 isn’t using the PLTV days that that’s coming from DBT. It’s actually calculating a different PLTV within Tableau itself.
129 00:11:00.410 ⇒ 00:11:01.410 Mustafa Raja: Does that make sense?
130 00:11:01.650 ⇒ 00:11:02.630 Greg Stoutenburg: Yes.
131 00:11:02.810 ⇒ 00:11:05.030 Mustafa Raja: You know, it’s,
132 00:11:05.150 ⇒ 00:11:11.649 Mustafa Raja: I tried to replicate that, I tried to calculate it within Omni, it just didn’t make sense.
133 00:11:11.650 ⇒ 00:11:14.439 Greg Stoutenburg: because.
134 00:11:14.520 ⇒ 00:11:27.639 Mustafa Raja: So, the way Tableau calculates this is, it would calculate it over, on overall data, right? But Omni does it, with, only the present data within the table, with all the filters.
135 00:11:27.790 ⇒ 00:11:34.900 Greg Stoutenburg: Okay. So, the values are going to differ. So that’s why, in the ticket I’m suggesting, I would need some…
136 00:11:36.130 ⇒ 00:11:37.200 Mustafa Raja: some help.
137 00:11:37.600 ⇒ 00:11:40.679 Greg Stoutenburg: Okay. And, is Demi’s gonna be able to do that?
138 00:11:41.400 ⇒ 00:11:46.349 Mustafa Raja: Yeah, Demi should be able to do that. I think he’s just a little, busy, though.
139 00:11:46.350 ⇒ 00:11:46.760 Greg Stoutenburg: Yeah.
140 00:11:46.760 ⇒ 00:11:49.820 Mustafa Raja: So, we’ll need to, you know… Give some…
141 00:11:49.820 ⇒ 00:11:50.290 Greg Stoutenburg: Get away from.
142 00:11:50.290 ⇒ 00:11:51.240 Mustafa Raja: Dying with him.
143 00:11:51.600 ⇒ 00:11:56.700 Mustafa Raja: Yeah, anyone would… yeah, both of… any… any of both should be able to do that.
144 00:11:56.700 ⇒ 00:11:59.639 Greg Stoutenburg: Yeah, let’s just go ahead and… Similar thing with this.
145 00:12:01.990 ⇒ 00:12:14.640 Mustafa Raja: So this is, level of, level of… what’s, what’s downloading? Forget it. Level of, detail, yeah. Level of detail. So, so what happens is…
146 00:12:15.000 ⇒ 00:12:29.399 Mustafa Raja: Yeah, so what happens is, we want to make sure that, we get, the maximum cumulative repurchase rate, for both… keeping both of them, you know, fixing both of them. Yep.
147 00:12:29.600 ⇒ 00:12:32.310 Mustafa Raja: Which doesn’t work in Omni.
148 00:12:33.800 ⇒ 00:12:40.129 Mustafa Raja: So… Yeah, we’d have to get this from DBT.
149 00:12:40.130 ⇒ 00:12:40.830 Greg Stoutenburg: Okay.
150 00:12:41.130 ⇒ 00:12:42.000 Greg Stoutenburg: Okay.
151 00:12:44.840 ⇒ 00:12:50.310 Mustafa Raja: Yeah, actually, last night I did some more digging on Alludin.
152 00:12:50.520 ⇒ 00:12:52.460 Mustafa Raja: It will be in Omni.
153 00:12:53.020 ⇒ 00:12:54.300 Mustafa Raja: After any…
154 00:13:00.110 ⇒ 00:13:10.729 Mustafa Raja: Let me know if I should spend some more time on level of detail, because I figured this out last night, that this is something, this is a concept, and I read into it a little.
155 00:13:11.090 ⇒ 00:13:22.700 Mustafa Raja: I… if Demilade and Avesh are busy, I could try and replicate it again, because I didn’t view it with the lens of level of detail, you know?
156 00:13:22.700 ⇒ 00:13:23.839 Greg Stoutenburg: Yeah. Would that make…
157 00:13:24.150 ⇒ 00:13:30.529 Mustafa Raja: I just was trying to, you know, somehow create it, and then I got introduced to this concept.
158 00:13:31.640 ⇒ 00:13:32.180 Greg Stoutenburg: Sorry.
159 00:13:33.320 ⇒ 00:13:41.729 Mustafa Raja: Yeah, so let’s first try and get Demi or Avish on this. If not possible, then I’d take a crack at it.
160 00:13:41.730 ⇒ 00:13:47.189 Greg Stoutenburg: Yeah, good idea. Yeah, we’ll raise this for Awash. Can you actually just assign it to him?
161 00:13:47.390 ⇒ 00:13:58.310 Greg Stoutenburg: And, since you’re, you know, since you’re here already, assign it to him, and… and drop it in Slack in the team channel for this. And we’ll just say, like, hey, there’s some…
162 00:13:58.850 ⇒ 00:14:03.329 Greg Stoutenburg: There’s a description of something we need help for, at the bottom of the ticket.
163 00:14:04.750 ⇒ 00:14:06.110 Mustafa Raja: Okay.
164 00:14:08.600 ⇒ 00:14:11.400 Greg Stoutenburg: Yeah, cool. Yeah, cause I’ll… I need to,
165 00:14:11.900 ⇒ 00:14:21.199 Greg Stoutenburg: I need to do QA for the next set of folders, and that’ll… that should probably be higher priority, because I know you can… you can tick those off faster than investigating the LOD stuff.
166 00:14:21.910 ⇒ 00:14:29.680 Mustafa Raja: Yeah, that’s… that’s for sure. Okay, and the last one is, you know, this was just, you know, reverse the…
167 00:14:29.680 ⇒ 00:14:30.200 Greg Stoutenburg: Oh, yeah, okay.
168 00:14:30.200 ⇒ 00:14:31.020 Mustafa Raja: Cool.
169 00:14:31.020 ⇒ 00:14:40.809 Greg Stoutenburg: Yeah, and that’s probably more like a nitpick than anything. I just, as much as possible, we just want it to look like Tableau suddenly appears in Omni, you know, just minimize their questions, so that’s all that was about.
170 00:14:42.180 ⇒ 00:14:43.070 Mustafa Raja: Yeah.
171 00:14:43.290 ⇒ 00:14:43.860 Greg Stoutenburg: Yep.
172 00:14:44.790 ⇒ 00:14:45.570 Greg Stoutenburg: Cool.
173 00:14:46.010 ⇒ 00:14:47.699 Greg Stoutenburg: Alright, looks good to me.
174 00:14:48.480 ⇒ 00:14:50.490 Mustafa Raja: We have one more, wait.
175 00:14:51.320 ⇒ 00:14:52.860 Greg Stoutenburg: Oh yeah, that’s right, there was another one.
176 00:14:53.430 ⇒ 00:14:56.629 Mustafa Raja: There’s actually another one after this, too.
177 00:14:57.280 ⇒ 00:14:57.670 Greg Stoutenburg: Go.
178 00:14:57.670 ⇒ 00:15:02.820 Mustafa Raja: Okay, so this was done, but with this, let’s talk about these ones.
179 00:15:03.340 ⇒ 00:15:05.919 Mustafa Raja: So, did I explain it again?
180 00:15:05.920 ⇒ 00:15:07.410 Greg Stoutenburg: Alright, they’re all missing cohorts.
181 00:15:08.440 ⇒ 00:15:13.529 Mustafa Raja: Yeah, so what happens is, let me actually show you what happened.
182 00:15:15.170 ⇒ 00:15:17.719 Mustafa Raja: Is it how Omni does stuff?
183 00:15:21.200 ⇒ 00:15:25.880 Mustafa Raja: Okay, so this has cohort, this has cohort… What doesn’t have cohort?
184 00:15:28.330 ⇒ 00:15:29.840 Mustafa Raja: It’s revenue per person.
185 00:15:31.700 ⇒ 00:15:34.079 Mustafa Raja: Okay, let’s, let’s hand it this.
186 00:15:35.930 ⇒ 00:15:36.870 Mustafa Raja: This one.
187 00:15:37.700 ⇒ 00:15:39.670 Greg Stoutenburg: This one has cohort size, I see it.
188 00:15:40.390 ⇒ 00:15:42.660 Mustafa Raja: Yeah, but, we need…
189 00:15:43.210 ⇒ 00:15:45.570 Greg Stoutenburg: Oh, revenue per customer, yeah. Yeah, yeah.
190 00:15:47.170 ⇒ 00:15:48.759 Mustafa Raja: Revenue per customer…
191 00:15:50.980 ⇒ 00:15:53.740 Greg Stoutenburg: Wait, sorry, go back to the QA ticket.
192 00:15:55.010 ⇒ 00:16:02.299 Greg Stoutenburg: I think we’re looking at the wrong chart. So right here, yeah, it’s showing missing revenue per customer right here in the table you’re pointing at now. So that’s… that’s what it looks like in Tableau.
193 00:16:02.480 ⇒ 00:16:05.279 Greg Stoutenburg: So we need to find monthly churn rate by product.
194 00:16:05.660 ⇒ 00:16:12.710 Greg Stoutenburg: find that in Omni, and that’s what needs missing… that’s what needs revenue per customer, and orders per customer.
195 00:16:13.560 ⇒ 00:16:15.499 Mustafa Raja: Yeah, here we, here we have, here we have.
196 00:16:17.420 ⇒ 00:16:18.220 Mustafa Raja: This is…
197 00:16:18.220 ⇒ 00:16:21.910 Greg Stoutenburg: Oh, I see, I just grabbed the left side. Okay, I got confused by my own screenshot.
198 00:16:23.240 ⇒ 00:16:26.200 Mustafa Raja: Okay, let’s take a look at this.
199 00:16:26.320 ⇒ 00:16:35.499 Mustafa Raja: So, what that is going to be is a sum of, revenue per customer, right, for the month.
200 00:16:35.500 ⇒ 00:16:35.830 Greg Stoutenburg: Yep.
201 00:16:35.830 ⇒ 00:16:41.700 Mustafa Raja: If I do that, revenue per customer… Revenue per customer on this.
202 00:16:42.130 ⇒ 00:16:44.180 Mustafa Raja: And then let’s just aggregate this.
203 00:16:49.790 ⇒ 00:16:53.699 Mustafa Raja: You’ll see that this gets added into the pivoted side of the table.
204 00:16:54.460 ⇒ 00:16:55.560 Mustafa Raja: Does that make sense?
205 00:16:56.190 ⇒ 00:16:56.920 Greg Stoutenburg: Yeah.
206 00:16:57.060 ⇒ 00:17:00.289 Mustafa Raja: It should… it should rather be.
207 00:17:00.290 ⇒ 00:17:00.620 Greg Stoutenburg: Yeah.
208 00:17:00.620 ⇒ 00:17:01.200 Mustafa Raja: Thank you, John.
209 00:17:01.200 ⇒ 00:17:03.109 Greg Stoutenburg: I want it as a new column. Yeah.
210 00:17:03.110 ⇒ 00:17:09.420 Mustafa Raja: Yeah, so, so why, why, why this happens is because this is a major… And.
211 00:17:09.420 ⇒ 00:17:17.799 Greg Stoutenburg: Omni, by default, adds that into the pivoted side of the table. Okay. And there is no way for us to get it out of there.
212 00:17:18.229 ⇒ 00:17:20.799 Greg Stoutenburg: Okay, so would this require dbt work?
213 00:17:22.450 ⇒ 00:17:29.729 Mustafa Raja: I… when I investigated this with Milade, he just said, split this into two tables.
214 00:17:29.980 ⇒ 00:17:30.560 Greg Stoutenburg: Okay.
215 00:17:30.560 ⇒ 00:17:35.639 Mustafa Raja: You know, one for all of this, and one for the heat map.
216 00:17:36.130 ⇒ 00:17:36.850 Greg Stoutenburg: Okay.
217 00:17:37.130 ⇒ 00:17:37.779 Greg Stoutenburg: That’s fine.
218 00:17:37.780 ⇒ 00:17:43.880 Mustafa Raja: This is where I need your insight. You know, if you’re good with it, I can go ahead, work on it.
219 00:17:43.880 ⇒ 00:17:55.420 Greg Stoutenburg: I’m good with that, yeah, that’s… that’s a good solution. If they… if they were to raise a fuss about it, which I think is very unlikely, then we would say, okay, well, here’s the technical limitation, we can proceed forward with it if you want.
220 00:17:56.080 ⇒ 00:18:01.810 Mustafa Raja: Okay, yeah, this makes sense. And this is, for all of the heat maps. Heat maps are just like this.
221 00:18:01.810 ⇒ 00:18:03.450 Greg Stoutenburg: Got it. Okay. Yep.
222 00:18:07.910 ⇒ 00:18:09.170 Mustafa Raja: All products.
223 00:18:09.820 ⇒ 00:18:10.780 Mustafa Raja: byproduct.
224 00:18:11.740 ⇒ 00:18:14.939 Mustafa Raja: Wait, yeah, this is done, actually.
225 00:18:15.090 ⇒ 00:18:19.059 Greg Stoutenburg: Okay. And then total orders, and then order.
226 00:18:19.900 ⇒ 00:18:20.720 Mustafa Raja: Wait.
227 00:18:21.230 ⇒ 00:18:31.930 Mustafa Raja: Okay, this… This doesn’t match, yes. Let me see if I added a comment. I think I added a ticket for Demel RD.
228 00:18:32.120 ⇒ 00:18:34.259 Mustafa Raja: Let me, let me find that ticket.
229 00:18:35.490 ⇒ 00:18:39.200 Mustafa Raja: Yeah, this one. Debug. Yeah.
230 00:18:40.120 ⇒ 00:18:45.430 Mustafa Raja: Yeah. So, this is the same, level of… what’s it called?
231 00:18:45.430 ⇒ 00:18:46.890 Greg Stoutenburg: Yeah, a lot of detail, yep.
232 00:18:46.890 ⇒ 00:18:59.760 Mustafa Raja: Now, this is, this ticket made me, or this issue made me look into LOD itself, because, it was popping up a lot, for a lot of the issues. So,
233 00:19:00.200 ⇒ 00:19:08.499 Mustafa Raja: Particularly for this, this LOD cannot be implemented in Omni itself, because, this involves
234 00:19:08.500 ⇒ 00:19:23.609 Mustafa Raja: level of detail for a table, for a table that has two tables merged into it, merged into it. And what we are doing, we are joining the two tables in topic, and topics cannot have dimensions.
235 00:19:23.610 ⇒ 00:19:29.549 Mustafa Raja: So this LOD has to be implemented, via… what’s it called? dbt.
236 00:19:30.250 ⇒ 00:19:31.270 Greg Stoutenburg: Hmm. Okay.
237 00:19:31.270 ⇒ 00:19:33.980 Mustafa Raja: If that makes sense. We can go through it in detail if you want.
238 00:19:34.260 ⇒ 00:19:39.379 Greg Stoutenburg: Yeah, no, that makes sense. I think that’s… I mean, what’s…
239 00:19:44.010 ⇒ 00:19:48.469 Greg Stoutenburg: So, it’s going to get us the cohort size, right?
240 00:19:49.670 ⇒ 00:19:54.500 Greg Stoutenburg: Which… which value is it not going to be able to get right to get in the table for us?
241 00:19:55.370 ⇒ 00:19:59.339 Mustafa Raja: So, let me show you my virtual chart, actually.
242 00:20:00.900 ⇒ 00:20:10.469 Mustafa Raja: Not this one… Not this one… Not this one…
243 00:20:10.940 ⇒ 00:20:13.029 Mustafa Raja: What button do you press to see that view?
244 00:20:13.610 ⇒ 00:20:17.230 Mustafa Raja: Oh, it’s just, swipe up with 3 fingers on the trackpad.
245 00:20:17.440 ⇒ 00:20:25.289 Greg Stoutenburg: Oh, man, I gotta learn how to do that. Control, or on keyboard, if you want to do this with keyboard, it’s control and up key.
246 00:20:26.280 ⇒ 00:20:27.050 Greg Stoutenburg: Okay.
247 00:20:27.950 ⇒ 00:20:29.330 Mustafa Raja: Yeah, if you want keyboard.
248 00:20:29.550 ⇒ 00:20:31.110 Greg Stoutenburg: Slick. Thanks.
249 00:20:31.460 ⇒ 00:20:32.620 Mustafa Raja: Yeah…
250 00:20:33.140 ⇒ 00:20:40.710 Mustafa Raja: Okay, I don’t have the cursor chat right now. Anyways, so, yeah, so, what was happening is,
251 00:20:40.710 ⇒ 00:20:57.190 Mustafa Raja: So this cohort size that you see, that is correct, shouldn’t be correct, really, because that’s being corrected using a filter, so that’s just a cheat code to get the cohort size right in the chart. But what that makes, you know, so…
252 00:20:57.190 ⇒ 00:20:57.670 Greg Stoutenburg: Yeah.
253 00:20:57.670 ⇒ 00:21:07.899 Mustafa Raja: This filter, this filter makes the cohort size correct with the current implementation that we have, but it messes up all other values that you were mentioning in the ticket.
254 00:21:07.900 ⇒ 00:21:08.890 Greg Stoutenburg: Okay.
255 00:21:09.340 ⇒ 00:21:12.529 Mustafa Raja: So this is where LOD might help us.
256 00:21:12.770 ⇒ 00:21:14.559 Greg Stoutenburg: Got it. Okay.
257 00:21:14.560 ⇒ 00:21:20.470 Mustafa Raja: So we wouldn’t have to rely on this filter to get, Cohort, right?
258 00:21:20.930 ⇒ 00:21:28.569 Mustafa Raja: And then if we can get rid of this filter, we might, you know, get all of the other values fixed.
259 00:21:29.030 ⇒ 00:21:31.199 Greg Stoutenburg: Okay, that sounds like one to pursue.
260 00:21:32.740 ⇒ 00:21:47.669 Mustafa Raja: Yeah, I have assigned this to Demiladi. I have a Zoom clip linked to it, and I have a Zoom meeting also, because Demilade and I went and dig… dug up deep into this. I think last week we did that.
261 00:21:47.850 ⇒ 00:21:48.550 Greg Stoutenburg: Okay.
262 00:21:49.590 ⇒ 00:21:53.800 Mustafa Raja: I think last week, on Friday, we had a… we had a…
263 00:21:54.500 ⇒ 00:22:02.080 Mustafa Raja: hour and a half long meeting, you know, debugging this, trying to debug this, and, you know, we just said, yeah, it has to go in dbt.
264 00:22:02.250 ⇒ 00:22:02.850 Greg Stoutenburg: Yeah.
265 00:22:03.510 ⇒ 00:22:04.010 Greg Stoutenburg: Okay.
266 00:22:04.010 ⇒ 00:22:08.140 Mustafa Raja: Okay, let’s go back, let’s go back, and… And…
267 00:22:08.430 ⇒ 00:22:11.380 Mustafa Raja: I mean, let me just pull it up again.
268 00:22:12.860 ⇒ 00:22:14.380 Greg Stoutenburg: That’s the one that we just looked at, I think.
269 00:22:14.680 ⇒ 00:22:15.580 Mustafa Raja: Yeah, definitely.
270 00:22:15.580 ⇒ 00:22:16.040 Greg Stoutenburg: Yeah, okay.
271 00:22:18.170 ⇒ 00:22:19.949 Mustafa Raja: Okay, for this…
272 00:22:20.840 ⇒ 00:22:35.100 Mustafa Raja: And, I need, I need some… I need to dig it, dig a little bit more, because, right before this meeting, I was looking at it, and I figured, okay, the filters aren’t changing anything.
273 00:22:35.210 ⇒ 00:22:44.200 Mustafa Raja: So, so I… and to create this, create these two, you know, what’s it called, sections, the offer and other.
274 00:22:44.920 ⇒ 00:22:59.139 Mustafa Raja: I had to create a custom field, with SQL, and that might have caused this issue, so I’m going to take a look at that, you know, make sure that my logic is correct, and make sure the filter is working.
275 00:22:59.140 ⇒ 00:23:04.430 Greg Stoutenburg: Okay. Because I think it’s just the filters. And Demilade and I also debugged this.
276 00:23:04.470 ⇒ 00:23:08.950 Mustafa Raja: And he gave me a list of, what’s it called?
277 00:23:09.560 ⇒ 00:23:11.319 Mustafa Raja: What was it? What was it?
278 00:23:11.500 ⇒ 00:23:23.870 Mustafa Raja: Yeah, a list of, channels that we are listening to for others, you know, for other category. I believe if, once I filter to those, we should be good.
279 00:23:24.640 ⇒ 00:23:26.270 Greg Stoutenburg: Okay. Okay, great.
280 00:23:26.830 ⇒ 00:23:30.489 Greg Stoutenburg: That sounds good to me. Yeah, and then I’m going to work on this one now.
281 00:23:31.990 ⇒ 00:23:53.640 Greg Stoutenburg: Okay, great. While you do that, I’m gonna get moving on the next set for the next folder, and those will be all the highest priority dashboards. So, I’ve asked… it’s not confirmed yet, but I’ve asked to schedule time with ELT for early next week to give them an overview. So, the goal will be to make sure that everything that’s in the highest priority dashboards is all set, ready to go.
282 00:23:53.640 ⇒ 00:23:54.300 Mustafa Raja: Okay.
283 00:23:54.440 ⇒ 00:23:54.860 Greg Stoutenburg: Yeah.
284 00:23:54.860 ⇒ 00:23:58.730 Mustafa Raja: Okay, okay. Now, one, one last thing.
285 00:23:59.290 ⇒ 00:24:02.840 Mustafa Raja: Before we move on. Yep. These are the tickets.
286 00:24:02.980 ⇒ 00:24:05.079 Mustafa Raja: For the dashboards? For the new one?
287 00:24:05.080 ⇒ 00:24:06.020 Greg Stoutenburg: ones? Yeah.
288 00:24:06.270 ⇒ 00:24:10.880 Mustafa Raja: Yeah, so… This is good.
289 00:24:11.220 ⇒ 00:24:11.940 Greg Stoutenburg: Okay.
290 00:24:13.380 ⇒ 00:24:19.499 Mustafa Raja: This is also good, abandoned orders. These two need same melody.
291 00:24:19.500 ⇒ 00:24:20.210 Greg Stoutenburg: Okay.
292 00:24:20.960 ⇒ 00:24:37.650 Mustafa Raja: Wait, so this is, this is actually the same LOD for both of those, so, it’s the same thing that’s blocking the both. Okay. Need to work on this. Sorry, not this. This. I’ll work on this right after.
293 00:24:37.700 ⇒ 00:24:43.580 Mustafa Raja: And then… I was able to create this one, but, it has some,
294 00:24:43.900 ⇒ 00:24:48.869 Mustafa Raja: issues with it, so I’m going to investigate those, so that’s why I have it in revision.
295 00:24:48.870 ⇒ 00:24:51.429 Greg Stoutenburg: Okay, and those are all for deliveries, right?
296 00:24:52.370 ⇒ 00:24:58.379 Mustafa Raja: Yeah, the subscription ones that we, took a look at in yesterday’s…
297 00:24:59.170 ⇒ 00:25:00.440 Greg Stoutenburg: Got it. Okay.
298 00:25:00.670 ⇒ 00:25:02.859 Greg Stoutenburg: Great, awesome, great progress.
299 00:25:03.350 ⇒ 00:25:04.020 Mustafa Raja: Thank you.
300 00:25:04.020 ⇒ 00:25:04.630 Greg Stoutenburg: Yeah.
301 00:25:04.770 ⇒ 00:25:07.130 Greg Stoutenburg: Alright, excellent work. Let’s keep it up!
302 00:25:07.130 ⇒ 00:25:11.519 Mustafa Raja: Okay, let me know if you are going to notify Avish.
303 00:25:11.850 ⇒ 00:25:13.250 Mustafa Raja: for…
304 00:25:14.440 ⇒ 00:25:21.319 Mustafa Raja: this. Oh, no, not this. This, not this, yeah. Where did it go? I did assign a ticket to him.
305 00:25:21.320 ⇒ 00:25:24.470 Greg Stoutenburg: Lifecycle marketing? Or no, retention?
306 00:25:25.200 ⇒ 00:25:27.139 Greg Stoutenburg: This, yeah. Oh, this one, yeah.
307 00:25:27.140 ⇒ 00:25:27.750 Mustafa Raja: Yeah, you wait.
308 00:25:27.750 ⇒ 00:25:28.130 Greg Stoutenburg: You wave.
309 00:25:28.130 ⇒ 00:25:31.830 Mustafa Raja: So, let me know if you’re going to notify him, or I should notify him.
310 00:25:31.830 ⇒ 00:25:37.009 Greg Stoutenburg: Yeah, could you just drop a notice for him in the, migration channel?
311 00:25:37.410 ⇒ 00:25:38.460 Mustafa Raja: Yeah, I’ll do that.
312 00:25:38.460 ⇒ 00:25:41.079 Greg Stoutenburg: And just say that we need a support on that one? Yeah, thanks.
313 00:25:42.330 ⇒ 00:25:42.950 Mustafa Raja: Okay.
314 00:25:42.950 ⇒ 00:25:45.479 Greg Stoutenburg: Cool. Awesome. Thanks, Mustafa.
315 00:25:45.940 ⇒ 00:25:47.009 Mustafa Raja: Thank you, have a good day.
316 00:25:47.010 ⇒ 00:25:48.490 Greg Stoutenburg: Yep, you too. See ya. Bye.
317 00:25:48.840 ⇒ 00:25:49.440 Mustafa Raja: Bye.