Meeting Title: Eden Migration Project Check-in Date: 2026-03-06 Meeting participants: Uttam Kumaran, Awaish Kumar, Mustafa Raja, Demilade Agboola
WEBVTT
1 00:00:50.890 ⇒ 00:00:51.980 Awaish Kumar: Hi.
2 00:00:52.430 ⇒ 00:01:00.809 Uttam Kumaran: Hey, okay, so I wanna just meet with everybody that’s on the Eden migration, and on default, and just, like.
3 00:01:01.080 ⇒ 00:01:03.260 Uttam Kumaran: try to drive this to the end, I’m just…
4 00:01:03.890 ⇒ 00:01:09.160 Uttam Kumaran: I mean, we could talk about the Eden migration stuff. I’ve just, like, I’ve been asking a couple times, Mustafa, like.
5 00:01:09.580 ⇒ 00:01:15.820 Uttam Kumaran: are we on track? And I’m not… he’s not saying anything at all in Slack, and then I saw Greg’s message this morning.
6 00:01:15.990 ⇒ 00:01:21.870 Uttam Kumaran: So, I just want to know, like, where we are, and, like, what’s remaining, so we can make sure that this is done.
7 00:01:23.690 ⇒ 00:01:33.359 Uttam Kumaran: Mustafa, I’m just, like, I’m just not… I’m just really not happy with, like, the communication on the Omni migration. Like, I’ve probably asked every single morning.
8 00:01:33.660 ⇒ 00:01:40.079 Uttam Kumaran: this week, for, like, let me know where I can help, or what’s the status, and, like, I’m not seeing anything in that channel.
9 00:01:40.220 ⇒ 00:01:44.290 Uttam Kumaran: Like, all the messages have been from Awash, Or Greg?
10 00:01:44.670 ⇒ 00:01:47.899 Uttam Kumaran: And, like, Greg is out, and, like, you’re the EP on this, and, like.
11 00:01:48.850 ⇒ 00:01:50.970 Uttam Kumaran: Like, have no clue what’s going on.
12 00:01:52.800 ⇒ 00:01:58.659 Mustafa Raja: Yeah, so, there are some, DBT tickets, but those are already assigned to…
13 00:01:58.660 ⇒ 00:02:00.959 Uttam Kumaran: Yeah, but dude, like I said yesterday, like.
14 00:02:01.150 ⇒ 00:02:03.320 Uttam Kumaran: This needs to be done yesterday.
15 00:02:03.800 ⇒ 00:02:11.449 Uttam Kumaran: Like, why… why… why didn’t you raise a flag yesterday that still stuff is not done? Like, assigning it to somebody is not enough.
16 00:02:12.690 ⇒ 00:02:16.070 Mustafa Raja: It’s not done, right? So what do we… like, it’s Friday now.
17 00:02:16.160 ⇒ 00:02:18.919 Uttam Kumaran: And, like, I’m gonna go… I have to go take all that on.
18 00:02:19.850 ⇒ 00:02:28.830 Uttam Kumaran: I asked every single day this week, tell me when you need help. I said it so explicitly yesterday, and still today, it’s not done. And then Greg sends a message this morning.
19 00:02:29.980 ⇒ 00:02:34.710 Uttam Kumaran: Like, are we on the same page that, like, this is, like, a miss.
20 00:02:35.860 ⇒ 00:02:36.520 Mustafa Raja: Yeah.
21 00:02:37.490 ⇒ 00:02:38.460 Uttam Kumaran: What happened?
22 00:02:40.540 ⇒ 00:02:48.980 Mustafa Raja: I did, I did communicate with, Greg, that we have these tickets that I need.
23 00:02:49.100 ⇒ 00:02:49.670 Mustafa Raja: Db.
24 00:02:49.670 ⇒ 00:02:53.569 Uttam Kumaran: Where? I’m only seeing a message from you on Wednesday.
25 00:02:53.930 ⇒ 00:02:54.539 Uttam Kumaran: In the chat.
26 00:02:54.540 ⇒ 00:02:58.790 Mustafa Raja: Greg and I, we used to meet every day.
27 00:03:00.060 ⇒ 00:03:02.729 Mustafa Raja: We used to sync, on Zoom.
28 00:03:02.880 ⇒ 00:03:06.329 Mustafa Raja: And that’s where I would, you know, communicate my…
29 00:03:06.330 ⇒ 00:03:14.330 Uttam Kumaran: I know, but dude, I… I’m just… yesterday, I remember I called yesterday, I said, guys, I’m… I’m concerned this is not gonna finish.
30 00:03:14.750 ⇒ 00:03:20.769 Uttam Kumaran: I need to hear… more. Why… like, I’m just trying to get to the issue, like…
31 00:03:21.170 ⇒ 00:03:25.450 Uttam Kumaran: I told you and Demi, ask for help, and you guys didn’t ask for any help.
32 00:03:27.110 ⇒ 00:03:36.910 Mustafa Raja: Yeah, I believe, I believe we, relegated some of the, but all of the, tickets that were assigned to Demi to…
33 00:03:37.560 ⇒ 00:03:45.519 Mustafa Raja: you? And then, Avish had some, but all of these are just DBT tickets.
34 00:03:46.150 ⇒ 00:03:52.179 Mustafa Raja: Okay. I guess, what I really needed to do was, communicate more on the Slack.
35 00:03:52.540 ⇒ 00:03:56.000 Awaish Kumar: I just planned a working session with Mustra and Demi.
36 00:03:56.270 ⇒ 00:04:00.600 Awaish Kumar: For 2 hours now to finish all the DBT and the modeling stuff.
37 00:04:02.110 ⇒ 00:04:02.500 Uttam Kumaran: Okay.
38 00:04:02.990 ⇒ 00:04:06.740 Awaish Kumar: We can skip retro and work on this, and let’s see,
39 00:04:06.880 ⇒ 00:04:13.329 Awaish Kumar: how far we can get, like, there are two pending on my plate, and there are two, three on yours, so we can…
40 00:04:13.590 ⇒ 00:04:17.649 Awaish Kumar: try to close that one out, that is for Josh, and then…
41 00:04:18.010 ⇒ 00:04:21.820 Awaish Kumar: And then, yeah, continue working there until… Yeah, so can we…
42 00:04:21.829 ⇒ 00:04:27.099 Uttam Kumaran: Can we just, like, look at the stuff right now? Because I just want to know what I need to do today, so I can…
43 00:04:27.369 ⇒ 00:04:29.719 Uttam Kumaran: Help out, and we can get this out the door.
44 00:04:29.909 ⇒ 00:04:35.499 Uttam Kumaran: So… like, I can look at the tickets, or what’s a good place to just, like.
45 00:04:36.349 ⇒ 00:04:38.239 Uttam Kumaran: Get aligned on what’s remaining.
46 00:04:39.480 ⇒ 00:04:41.880 Mustafa Raja: Yeah, they said tickets wouldn’t have enough contacts, I believe.
47 00:04:42.440 ⇒ 00:04:44.630 Uttam Kumaran: Okay, yeah, maybe a ways you can share.
48 00:04:47.570 ⇒ 00:04:51.399 Awaish Kumar: So these are the ones assigned to you, and I don’t know.
49 00:04:52.390 ⇒ 00:04:56.189 Awaish Kumar: The Robert… the one that is Robert talking about, is there a ticket for that?
50 00:04:56.730 ⇒ 00:05:10.199 Mustafa Raja: No, there isn’t. And I was just looking into that. I’m using the exact same table that, that’s, in the, Tableau, and the values are slightly different.
51 00:05:10.390 ⇒ 00:05:13.249 Mustafa Raja: So we might want to take a look at that.
52 00:05:24.160 ⇒ 00:05:29.130 Awaish Kumar: Okay, yeah, I think, these are the tickets, so you can… if you want, I can go in.
53 00:05:34.010 ⇒ 00:05:37.080 Uttam Kumaran: Okay, so I can do some of these. So, like.
54 00:05:37.080 ⇒ 00:05:41.320 Awaish Kumar: Can you… Explain what is this, like… Yeah.
55 00:05:41.980 ⇒ 00:05:43.860 Mustafa Raja: Yeah, so,
56 00:05:44.240 ⇒ 00:06:03.279 Mustafa Raja: In the, in the OmniLink, you’d see that, it’s the last chart, and the other, section, has huge mismatches. The offer section, is pretty much, correct, but the other one.
57 00:06:03.400 ⇒ 00:06:12.509 Mustafa Raja: And it has a lot of mismatches, so that’s just what we need to fix. And I believe, it’s going to come from…
58 00:06:13.030 ⇒ 00:06:14.490 Mustafa Raja: Dbt.
59 00:06:15.730 ⇒ 00:06:19.959 Mustafa Raja: Since I’m using the same table that’s in Tableau.
60 00:06:22.470 ⇒ 00:06:24.970 Uttam Kumaran: Okay, alright, I can do that. What else?
61 00:06:26.090 ⇒ 00:06:28.940 Mustafa Raja: Then there are more declines.
62 00:06:29.130 ⇒ 00:06:29.720 Uttam Kumaran: Okay.
63 00:06:29.720 ⇒ 00:06:38.770 Mustafa Raja: These two should have exact same solution. So with one DBT solution, I should be able to, build the dashboard for both of these.
64 00:06:41.670 ⇒ 00:06:43.000 Uttam Kumaran: Okay, so…
65 00:06:43.130 ⇒ 00:06:49.559 Uttam Kumaran: I guess, but, like, can I… can we look at all the remaining tickets for the migration that need to get done today, not just mine?
66 00:06:50.000 ⇒ 00:06:53.089 Awaish Kumar: These are 3, and there are 2Ds assigned to it.
67 00:06:53.090 ⇒ 00:06:56.069 Uttam Kumaran: But is there… is this in a project? Like, can we just look at the project?
68 00:06:56.070 ⇒ 00:07:00.400 Mustafa Raja: Yeah, it’s in Tableau to OmniMigration.
69 00:07:01.030 ⇒ 00:07:02.520 Mustafa Raja: Yeah, this one, yeah.
70 00:07:07.130 ⇒ 00:07:08.090 Awaish Kumar: Oh, damn.
71 00:07:15.010 ⇒ 00:07:16.329 Awaish Kumar: Can I slide by…
72 00:07:16.330 ⇒ 00:07:20.290 Uttam Kumaran: There’s 1, 2, 3, 4, 5, 6…
73 00:07:22.480 ⇒ 00:07:23.010 Mustafa Raja: maybe…
74 00:07:23.010 ⇒ 00:07:24.580 Uttam Kumaran: My tickets aren’t in here.
75 00:07:27.480 ⇒ 00:07:28.810 Mustafa Raja: I wish, maybe…
76 00:07:28.810 ⇒ 00:07:30.019 Uttam Kumaran: I can share, I can share.
77 00:07:30.630 ⇒ 00:07:31.230 Awaish Kumar: Okay.
78 00:07:34.660 ⇒ 00:07:36.030 Awaish Kumar: No, this is…
79 00:07:36.030 ⇒ 00:07:37.410 Uttam Kumaran: I can share. Oh, wait, I can share.
80 00:07:37.860 ⇒ 00:07:38.500 Awaish Kumar: Okay.
81 00:07:40.690 ⇒ 00:07:43.439 Uttam Kumaran: So this is the Eden Tablet Omni migration, right? So…
82 00:07:43.710 ⇒ 00:07:45.500 Uttam Kumaran: These are all the tickets remaining.
83 00:07:47.350 ⇒ 00:07:53.789 Mustafa Raja: So the ones that are assigned to Greg aren’t related to the… aren’t related to building the dashboards?
84 00:07:54.530 ⇒ 00:07:56.819 Uttam Kumaran: But where are those ones that are assigned to me?
85 00:07:57.920 ⇒ 00:07:59.219 Mustafa Raja: Can you scroll down?
86 00:08:03.070 ⇒ 00:08:15.550 Mustafa Raja: I may have not, assigned them to… Okay, yeah, can we make sure literally all… what… I don’t know, it’s probably not in the project, can we just make sure all of the tickets that need to get done today are in one view? Yeah.
87 00:08:16.110 ⇒ 00:08:17.310 Mustafa Raja: Let me do that.
88 00:08:19.060 ⇒ 00:08:20.279 Awaish Kumar: Are you sharing the screen?
89 00:08:21.250 ⇒ 00:08:22.329 Uttam Kumaran: I am, I am.
90 00:08:22.790 ⇒ 00:08:25.510 Awaish Kumar: Why aren’t… Unseated.
91 00:08:26.280 ⇒ 00:08:27.480 Awaish Kumar: Okay, yeah.
92 00:08:27.480 ⇒ 00:08:28.599 Uttam Kumaran: Okay, hold on one second.
93 00:08:42.320 ⇒ 00:08:43.660 Mustafa Raja: Yeah, it should be in now.
94 00:08:45.230 ⇒ 00:08:48.830 Awaish Kumar: Okay, but the ones assigned to me are not here now?
95 00:08:49.530 ⇒ 00:08:55.130 Uttam Kumaran: Yeah, Ms. Safa, can you just take one minute and just make sure everything… As in here.
96 00:08:57.830 ⇒ 00:09:00.220 Uttam Kumaran: Anything related that needs to get done today, as in.
97 00:09:00.570 ⇒ 00:09:04.969 Awaish Kumar: Different status, that’s why. This is 1… 1494.
98 00:09:11.130 ⇒ 00:09:16.080 Mustafa Raja: 149, and one for 94, yeah. These two are in the project, yeah.
99 00:09:16.620 ⇒ 00:09:19.729 Awaish Kumar: Just move them into a 2-doin cycle, so that we can see it.
100 00:09:19.730 ⇒ 00:09:20.400 Mustafa Raja: New York.
101 00:09:28.640 ⇒ 00:09:29.180 Awaish Kumar: Yep.
102 00:09:33.460 ⇒ 00:09:37.770 Awaish Kumar: Yeah, so these… These are the ones…
103 00:09:38.150 ⇒ 00:09:45.699 Awaish Kumar: These are the only ones that I work on, but the Robert… the message that Robert sent is not here, like…
104 00:09:46.160 ⇒ 00:09:47.549 Uttam Kumaran: What’s… what’s the message?
105 00:09:48.240 ⇒ 00:09:53.750 Awaish Kumar: he sent a message in Client Eden for one of the dashboards, which is… which seems broken.
106 00:09:54.090 ⇒ 00:09:59.770 Awaish Kumar: And we don’t have a ticket for that, but I’m just going to work on And close it out.
107 00:10:12.380 ⇒ 00:10:13.050 Uttam Kumaran: Okay.
108 00:10:27.150 ⇒ 00:10:28.550 Uttam Kumaran: Yeah, guys.
109 00:10:29.070 ⇒ 00:10:31.330 Uttam Kumaran: We messed up. This is not great.
110 00:10:34.700 ⇒ 00:10:35.550 Uttam Kumaran: Reds.
111 00:10:40.480 ⇒ 00:10:41.460 Uttam Kumaran: Okay.
112 00:10:51.750 ⇒ 00:10:59.200 Uttam Kumaran: Okay, so Awash, like, maybe me and you can take the rest? Mustafa, I just really have, like… you can please, please just make sure, like.
113 00:10:59.480 ⇒ 00:11:02.820 Uttam Kumaran: All these things are all the remaining work.
114 00:11:02.960 ⇒ 00:11:07.000 Uttam Kumaran: Like, you’re the… you and Greg are the only people on this that have been leading this.
115 00:11:07.290 ⇒ 00:11:18.460 Uttam Kumaran: And, like, I really need you to take this to the finish line. It’s… you haven’t done that this week, and so take today and just really try to see if you can make sure to assist us in getting these out.
116 00:11:18.850 ⇒ 00:11:22.339 Uttam Kumaran: So that we can, like, close this out, because…
117 00:11:22.690 ⇒ 00:11:25.960 Uttam Kumaran: the cl- the CEO of Eden is, like.
118 00:11:26.430 ⇒ 00:11:36.579 Uttam Kumaran: does not… they can’t use this right now. So all of our work… we’re at the finish line, and we’re not closing it out. It’s, like, so frustrating to me. So I’ve asked… every day, I’ve asked.
119 00:11:36.710 ⇒ 00:11:45.909 Uttam Kumaran: So, like, we can… I mean, we can address that later, but, like, whatever you can do today to just make sure that all the stuff that’s in here
120 00:11:46.030 ⇒ 00:11:54.749 Uttam Kumaran: is here, like, would be so helpful. I think, Awash, like, me and you, like, we can… we can start… I’m gonna start working now on this.
121 00:11:54.920 ⇒ 00:11:56.360 Uttam Kumaran: I try to drive it out.
122 00:11:58.160 ⇒ 00:12:04.270 Uttam Kumaran: I don’t know if you need help on anything else, or, like, what your schedule is like today. I’m just gonna try to work on this, and then…
123 00:12:06.550 ⇒ 00:12:10.830 Awaish Kumar: Yeah, I’m also, because I think we closed this, like, CTM meeting,
124 00:12:11.770 ⇒ 00:12:15.230 Awaish Kumar: And it was… it went, I think, well, so we don’t have any…
125 00:12:15.490 ⇒ 00:12:18.469 Awaish Kumar: plenty to rush there, so I can also work on this.
126 00:12:18.990 ⇒ 00:12:19.590 Uttam Kumaran: Okay.
127 00:12:21.070 ⇒ 00:12:27.300 Uttam Kumaran: Can you send an… Can you send a note to Josh?
128 00:12:28.160 ⇒ 00:12:30.080 Uttam Kumaran: And say, we’re working on this right now.
129 00:12:32.970 ⇒ 00:12:34.260 Awaish Kumar: Okay, I gotcha.
130 00:12:34.890 ⇒ 00:12:37.930 Uttam Kumaran: Okay, because I’m not… I’m not in that… any of those channels.
131 00:12:39.550 ⇒ 00:12:44.000 Awaish Kumar: Yeah, I don’t know, like, the gag mentioned that he’s going to send a note, like.
132 00:12:44.000 ⇒ 00:12:49.250 Uttam Kumaran: Out. Yeah, Greg’s out of office. So, he’s not on, he’s on vacation.
133 00:12:49.250 ⇒ 00:12:49.889 Awaish Kumar: of life.
134 00:12:50.960 ⇒ 00:12:51.550 Uttam Kumaran: Huh?
135 00:12:52.710 ⇒ 00:12:56.440 Awaish Kumar: I think he just sent a message today, so that’s why, but I think I can send.
136 00:12:56.440 ⇒ 00:12:58.410 Uttam Kumaran: Yeah, if you can send, like.
137 00:13:04.620 ⇒ 00:13:07.890 Awaish Kumar: Okay, let’s see if I’m in the channel…
138 00:13:11.360 ⇒ 00:13:14.960 Uttam Kumaran: And then, Mustafa, like, what are you… what are you working on as part of this?
139 00:13:16.250 ⇒ 00:13:23.469 Mustafa Raja: So, for me, I, I need, I need the, dbt fixes to work on stuff.
140 00:13:32.480 ⇒ 00:13:35.589 Awaish Kumar: Uten, are you in the For Josh channel?
141 00:13:35.590 ⇒ 00:13:36.430 Uttam Kumaran: I’m not.
142 00:13:37.580 ⇒ 00:13:38.880 Awaish Kumar: Okay, let me ask.
143 00:18:11.880 ⇒ 00:18:14.650 Uttam Kumaran: So, this one is blocked by what? Like, there’s no indication.
144 00:18:14.650 ⇒ 00:18:15.179 Mustafa Raja: I’m like.
145 00:18:15.180 ⇒ 00:18:16.599 Uttam Kumaran: What this is blocked by.
146 00:18:18.570 ⇒ 00:18:20.059 Mustafa Raja: Let me put that.
147 00:20:36.220 ⇒ 00:20:40.499 Uttam Kumaran: And so I’m gonna… oh, what email should I use to log into Tableau?
148 00:20:42.890 ⇒ 00:20:44.779 Awaish Kumar: Robert’s email.
149 00:20:45.950 ⇒ 00:20:47.910 Awaish Kumar: In the one pass.
150 00:20:52.320 ⇒ 00:20:54.000 Awaish Kumar: Proverter tried.com.
151 00:21:04.450 ⇒ 00:21:08.390 Uttam Kumaran: Alright, if you’re logged in, can you just tell me the code? Sorry, I haven’t logged in in a while.
152 00:21:12.020 ⇒ 00:21:14.039 Awaish Kumar: Sorry, tell me… tell you what?
153 00:21:14.520 ⇒ 00:21:20.579 Uttam Kumaran: If you’re logged into the… to that account, can you just tell me what the verification code is? I just sent it.
154 00:21:23.080 ⇒ 00:21:27.140 Uttam Kumaran: For Tableau. I just haven’t logged in to that account in a while.
155 00:21:29.170 ⇒ 00:21:31.250 Awaish Kumar: Yeah, okay, intended.
156 00:21:32.040 ⇒ 00:21:34.070 Awaish Kumar: The code is…
157 00:21:37.880 ⇒ 00:21:39.790 Awaish Kumar: 148100.
158 00:21:41.460 ⇒ 00:21:44.320 Uttam Kumaran: Can I say that one more time? 148100.
159 00:21:44.430 ⇒ 00:21:45.620 Uttam Kumaran: Alright, thanks.
160 00:24:27.970 ⇒ 00:24:31.850 Uttam Kumaran: In Tableau, can you… can you go to a… can you… can you see the SQL query, or no?
161 00:24:33.480 ⇒ 00:24:36.700 Mustafa Raja: I don’t think that we can in a web…
162 00:24:36.830 ⇒ 00:24:53.130 Mustafa Raja: In the web version, I think we can… if it’s a custom query, then we can only look into it in the tablet desktop. Else, we can take a look at the definitions. If we hover over it, there’ll be a drop-down button over it.
163 00:24:53.290 ⇒ 00:24:59.309 Mustafa Raja: field, and then, in that, there’ll be a button for describe that’ll have the definition of the metric.
164 00:25:00.170 ⇒ 00:25:04.369 Uttam Kumaran: Okay, so what I’m seeing is that there’s just a bunch of filters on this.
165 00:25:06.210 ⇒ 00:25:07.239 Uttam Kumaran: Oh, this is…
166 00:25:07.240 ⇒ 00:25:07.660 Mustafa Raja: Beautiful.
167 00:25:07.660 ⇒ 00:25:10.609 Uttam Kumaran: filters Okay, hold on, I’ll just…
168 00:25:11.790 ⇒ 00:25:16.130 Mustafa Raja: For that, we have to edit… we have to be in an edit mode.
169 00:25:16.660 ⇒ 00:25:17.000 Uttam Kumaran: Yeah.
170 00:25:17.000 ⇒ 00:25:19.150 Mustafa Raja: Into the chart in itself.
171 00:31:39.580 ⇒ 00:31:42.629 Uttam Kumaran: Is there a way for me to refresh?
172 00:31:43.030 ⇒ 00:31:47.449 Uttam Kumaran: to, like, run this, so then I can go see the query in Snowflake.
173 00:31:49.710 ⇒ 00:31:51.599 Uttam Kumaran: Or in, whatever, in BigQuery?
174 00:31:52.810 ⇒ 00:31:53.790 Uttam Kumaran: For Eden?
175 00:31:56.630 ⇒ 00:32:03.140 Uttam Kumaran: Cause I’ve, I’ve looked, like, I don’t know, the filters and everything is fine.
176 00:32:10.520 ⇒ 00:32:11.410 Awaish Kumar: Yeah, no.
177 00:32:13.490 ⇒ 00:32:19.209 Awaish Kumar: I think the only way… yeah, you can actually just… can select the individual.
178 00:32:19.850 ⇒ 00:32:25.530 Awaish Kumar: Metric you want to see on the left-hand side, and then click and go into the…
179 00:32:27.390 ⇒ 00:32:31.829 Awaish Kumar: like, the describe only, then you can see the query for each.
180 00:32:32.120 ⇒ 00:32:37.400 Awaish Kumar: If you click on this drop-down, On each metric, yeah.
181 00:32:37.830 ⇒ 00:32:40.370 Awaish Kumar: You can see describe, or something like that.
182 00:32:42.240 ⇒ 00:32:46.850 Awaish Kumar: So it’s a column coming from return on ad spend, so it’s calculated in TMP.
183 00:32:48.360 ⇒ 00:32:54.490 Mustafa Raja: if it’s a calculation in, or Tableau, it’ll have a definition inside here.
184 00:32:54.490 ⇒ 00:32:59.090 Uttam Kumaran: But, like, when this… when this runs, like, can I just execute this?
185 00:33:00.050 ⇒ 00:33:00.910 Uttam Kumaran: Or no.
186 00:33:03.480 ⇒ 00:33:04.660 Mustafa Raja: I don’t know about that.
187 00:33:04.660 ⇒ 00:33:08.510 Awaish Kumar: You can, like, if you change the filter or anything, it will re-execute itself.
188 00:33:09.670 ⇒ 00:33:13.519 Mustafa Raja: But the underlying… underlying SQL wouldn’t be visible, no.
189 00:33:13.520 ⇒ 00:33:15.869 Uttam Kumaran: Yeah, because it’s based on the sync.
190 00:34:15.290 ⇒ 00:34:17.470 Uttam Kumaran: Okay, looks like this is what’s missing.
191 00:34:18.810 ⇒ 00:34:21.540 Mustafa Raja: Yeah, this is an, this is a level of detail.
192 00:34:21.760 ⇒ 00:34:27.370 Mustafa Raja: And then I… I couldn’t replicate in, what’s it called?
193 00:34:28.290 ⇒ 00:34:29.210 Mustafa Raja: Omni?
194 00:34:29.449 ⇒ 00:34:30.529 Mustafa Raja: And.
195 00:34:31.320 ⇒ 00:34:32.709 Uttam Kumaran: What is this doing?
196 00:34:34.940 ⇒ 00:34:37.599 Mustafa Raja: I think for… I think,
197 00:34:38.280 ⇒ 00:34:43.749 Mustafa Raja: It selects, you know, first order month, and then first order product, and then channel, and then…
198 00:34:43.909 ⇒ 00:34:48.690 Mustafa Raja: For all of these, it calculates the maximum cumulative revenue.
199 00:34:50.190 ⇒ 00:34:52.249 Mustafa Raja: Is this a level of detail.
200 00:34:53.670 ⇒ 00:34:55.300 Mustafa Raja: Omni does have that.
201 00:34:55.480 ⇒ 00:35:00.569 Mustafa Raja: But, I’ve been unable to, you know, perfectly execute that.
202 00:35:30.810 ⇒ 00:35:34.149 Mustafa Raja: I think in the other section, the cohort size is also different.
203 00:35:53.320 ⇒ 00:35:56.219 Mustafa Raja: Yeah, I think if we get this, elderine…
204 00:35:56.970 ⇒ 00:36:00.150 Mustafa Raja: In there, we should be good for this.
205 00:36:50.010 ⇒ 00:36:53.280 Uttam Kumaran: I mean, what do we think we should do, Aish, from this, like…
206 00:37:05.390 ⇒ 00:37:06.890 Mustafa Raja: I think it’s a little…
207 00:37:06.960 ⇒ 00:37:09.920 Uttam Kumaran: We should add, this is another… measure?
208 00:37:10.080 ⇒ 00:37:11.329 Uttam Kumaran: Or another metric?
209 00:37:12.410 ⇒ 00:37:18.170 Awaish Kumar: Yeah, I did a similar thing for Rumusva, some other model, where I added it in DBT.
210 00:37:19.600 ⇒ 00:37:26.470 Mustafa Raja: Yeah, I wish I didn’t just that as a dimension, and that gave exactly perfectly values.
211 00:37:26.470 ⇒ 00:37:28.100 Uttam Kumaran: What… what was the PR?
212 00:37:31.330 ⇒ 00:37:31.830 Mustafa Raja: Professor.
213 00:37:33.720 ⇒ 00:37:42.030 Awaish Kumar: It’s just, like, a group, like, you can partition by these three and take the max value. I don’t know which.
214 00:37:42.030 ⇒ 00:37:44.780 Uttam Kumaran: Yeah, it’s just like, you just did a window function.
215 00:37:45.640 ⇒ 00:37:46.020 Awaish Kumar: Yeah.
216 00:37:46.020 ⇒ 00:37:47.969 Uttam Kumaran: But what, what is the,
217 00:37:48.450 ⇒ 00:37:49.859 Uttam Kumaran: Well, did you push the PR line?
218 00:37:49.860 ⇒ 00:37:54.370 Awaish Kumar: First, next… Let me just…
219 00:37:54.970 ⇒ 00:37:58.069 Uttam Kumaran: It’s this one, the Aligned Max Cumulative repurchase Rate.
220 00:38:01.880 ⇒ 00:38:03.700 Awaish Kumar: I think that one, yes.
221 00:38:05.540 ⇒ 00:38:06.689 Awaish Kumar: No, huh?
222 00:38:07.650 ⇒ 00:38:10.690 Awaish Kumar: This is different. Let me just find another one.
223 00:38:45.450 ⇒ 00:38:47.689 Awaish Kumar: Oh yeah, this one. This is the same, yeah.
224 00:38:47.920 ⇒ 00:38:55.420 Awaish Kumar: So, here you can see it’s a partition by… First auto month… And…
225 00:38:57.990 ⇒ 00:39:00.280 Uttam Kumaran: Okay. Just to customize.
226 00:39:02.440 ⇒ 00:39:03.380 Uttam Kumaran: Okay.
227 00:39:07.350 ⇒ 00:39:10.909 Uttam Kumaran: Mustafa, do you want to try to rip this? You want me to make the PR?
228 00:39:12.170 ⇒ 00:39:15.779 Mustafa Raja: Oh, yeah, yeah, yeah, I can, I can take that.
229 00:39:16.700 ⇒ 00:39:21.350 Mustafa Raja: So I’ll just ask her to do, to add this in dbt, right?
230 00:39:26.620 ⇒ 00:39:31.339 Mustafa Raja: And the other two tickets that are on your plate are also the same thing.
231 00:39:31.630 ⇒ 00:39:35.880 Mustafa Raja: It’s just, this same window thing.
232 00:39:36.100 ⇒ 00:39:41.919 Uttam Kumaran: Okay, I think basically what you need to do is… is kind of follow Oasis pattern.
233 00:39:43.500 ⇒ 00:39:48.130 Uttam Kumaran: and just adding, like, using this PR as a guide, you can use cursor.
234 00:39:48.480 ⇒ 00:39:53.750 Uttam Kumaran: And you basically just need to replicate these… These three in there.
235 00:39:54.540 ⇒ 00:39:56.780 Mustafa Raja: Okay, can you share that, yeah, please?
236 00:39:57.560 ⇒ 00:39:59.000 Uttam Kumaran: Here, oh, I’ll send it to you.
237 00:40:04.670 ⇒ 00:40:05.420 Mustafa Raja: Thank you.
238 00:40:11.530 ⇒ 00:40:14.250 Uttam Kumaran: So, you’re gonna make this change to…
239 00:40:14.370 ⇒ 00:40:17.929 Uttam Kumaran: the tape… what is the table? Return on ad spend, right? So…
240 00:40:18.570 ⇒ 00:40:19.050 Mustafa Raja: Yeah.
241 00:40:19.050 ⇒ 00:40:22.220 Uttam Kumaran: Turn on Add Spend Table.
242 00:40:22.800 ⇒ 00:40:25.039 Uttam Kumaran: Needs, window, functions…
243 00:40:27.420 ⇒ 00:40:27.920 Awaish Kumar: Mmm…
244 00:40:42.580 ⇒ 00:40:47.210 Awaish Kumar: We need revenue, and we need, score size…
245 00:40:48.250 ⇒ 00:40:48.970 Mustafa Raja: Yeah.
246 00:40:52.170 ⇒ 00:40:57.830 Mustafa Raja: And then… Revenue per customer, we can just calculate that, right?
247 00:41:05.250 ⇒ 00:41:07.609 Uttam Kumaran: Yeah, so you’ll need 3, I think.
248 00:41:08.490 ⇒ 00:41:09.830 Uttam Kumaran: And then ag…
249 00:41:10.130 ⇒ 00:41:16.580 Mustafa Raja: I think revenue per customer would be cohort divided by revenue, right?
250 00:41:17.990 ⇒ 00:41:21.320 Awaish Kumar: Yeah, yeah. Only 200 revenue and code size.
251 00:41:21.320 ⇒ 00:41:22.820 Uttam Kumaran: Only two, yeah, yeah.
252 00:41:26.140 ⇒ 00:41:27.519 Uttam Kumaran: Okay, give it a shot.
253 00:41:29.880 ⇒ 00:41:30.510 Mustafa Raja: Okay.
254 00:41:35.890 ⇒ 00:41:37.070 Awaish Kumar: Okay…
255 00:42:03.760 ⇒ 00:42:04.450 Uttam Kumaran: Okay.
256 00:42:04.670 ⇒ 00:42:07.369 Uttam Kumaran: So, we can take that. What else?
257 00:42:13.030 ⇒ 00:42:14.570 Mustafa Raja: The other two tickets?
258 00:42:14.860 ⇒ 00:42:20.530 Mustafa Raja: Those would have the same issue. By same issue, I mean same type of issue.
259 00:42:20.770 ⇒ 00:42:21.930 Mustafa Raja: It’s just.
260 00:42:23.200 ⇒ 00:42:23.600 Uttam Kumaran: Okay.
261 00:42:23.600 ⇒ 00:42:25.330 Mustafa Raja: Level of that we are missing?
262 00:42:27.480 ⇒ 00:42:32.590 Uttam Kumaran: Boise, do you wanna… rip the PRs for those? Seems just like the exact same thing.
263 00:42:46.260 ⇒ 00:42:47.650 Awaish Kumar: Okay.
264 00:42:50.800 ⇒ 00:42:52.910 Awaish Kumar: Well, non-GLP one.
265 00:42:56.350 ⇒ 00:43:00.979 Mustafa Raja: Yeah, I think… I think it’s the same… it’s the same, dimension that we need.
266 00:43:01.590 ⇒ 00:43:07.780 Mustafa Raja: For both of those, so one fix should be able to help us get both of those.
267 00:43:08.450 ⇒ 00:43:10.109 Awaish Kumar: Okay, let’s see.
268 00:43:14.120 ⇒ 00:43:17.949 Uttam Kumaran: And then what is this, what is the product?
269 00:43:18.610 ⇒ 00:43:23.179 Uttam Kumaran: Revenue Velocity Snapshot Dashboard. Like, what is that… what is that?
270 00:43:23.800 ⇒ 00:43:24.360 Uttam Kumaran: Issue.
271 00:43:24.360 ⇒ 00:43:25.250 Awaish Kumar: That’s what…
272 00:43:25.960 ⇒ 00:43:27.640 Mustafa Raja: Yeah, so…
273 00:43:27.640 ⇒ 00:43:30.739 Awaish Kumar: That numbers don’t match, we just have to QA that.
274 00:43:31.240 ⇒ 00:43:31.820 Mustafa Raja: Yeah.
275 00:43:32.540 ⇒ 00:43:34.020 Mustafa Raja: Yeah.
276 00:43:34.020 ⇒ 00:43:36.439 Awaish Kumar: I’m just looking at that right now.
277 00:43:36.750 ⇒ 00:43:38.020 Mustafa Raja: Oh, you are? Okay.
278 00:43:39.160 ⇒ 00:43:40.509 Uttam Kumaran: You want me to look too?
279 00:43:42.590 ⇒ 00:43:46.559 Awaish Kumar: Yeah, we can try.
280 00:43:46.560 ⇒ 00:43:51.520 Mustafa Raja: If we should, share the screen? If we should share the screen?
281 00:43:51.900 ⇒ 00:43:52.640 Uttam Kumaran: Yeah.
282 00:43:54.050 ⇒ 00:43:56.809 Mustafa Raja: I can… I can explain what’s going on under there.
283 00:43:57.600 ⇒ 00:44:06.300 Awaish Kumar: So, the thing is, there’s… The… we have total revenue 30-day. I just saw the QREPQs.
284 00:44:06.900 ⇒ 00:44:09.070 Awaish Kumar: It uses this filter.
285 00:44:10.140 ⇒ 00:44:11.500 Mustafa Raja: And…
286 00:44:12.570 ⇒ 00:44:25.729 Awaish Kumar: Number comes out as… And… And in the… Omni, the number is… Like, 62 million.
287 00:44:27.160 ⇒ 00:44:30.529 Mustafa Raja: And this is with the… with the…
288 00:44:31.270 ⇒ 00:44:40.359 Mustafa Raja: transaction revenue only, right? So, the other things that were in the query are presented as filters in here, in Omni.
289 00:44:40.970 ⇒ 00:44:42.700 Mustafa Raja: So, order date, and then…
290 00:44:44.230 ⇒ 00:44:49.929 Awaish Kumar: I understand that we are… I saw that you’re using same filters, like, past 30 days.
291 00:44:50.080 ⇒ 00:44:54.679 Awaish Kumar: And these ones. Crystal, the number is lower than…
292 00:44:55.510 ⇒ 00:44:58.320 Awaish Kumar: the Tableau one, I try to query the…
293 00:44:58.690 ⇒ 00:45:07.000 Awaish Kumar: theory in BigQuery, which is higher dock bar, that is understandable, because Tableau Snapshot is,
294 00:45:07.480 ⇒ 00:45:09.329 Awaish Kumar: Extrated once in a day.
295 00:45:09.980 ⇒ 00:45:12.440 Awaish Kumar: So, particular number is higher, it’s okay.
296 00:45:12.630 ⇒ 00:45:16.050 Awaish Kumar: How many numbers should match to BigQu number, at least?
297 00:45:16.970 ⇒ 00:45:19.370 Mustafa Raja: Okay, can you go back there?
298 00:45:19.580 ⇒ 00:45:24.309 Mustafa Raja: And can you, in the bottom tab, you’d see…
299 00:45:24.880 ⇒ 00:45:27.170 Mustafa Raja: You would see this, weight.
300 00:45:27.300 ⇒ 00:45:29.780 Mustafa Raja: You’d see this one. Sorry.
301 00:45:30.360 ⇒ 00:45:33.900 Mustafa Raja: this tab. Can we go in this tab? At the bottom?
302 00:45:36.940 ⇒ 00:45:37.850 Awaish Kumar: This one?
303 00:45:38.330 ⇒ 00:45:38.950 Mustafa Raja: Yeah.
304 00:45:41.430 ⇒ 00:45:48.949 Mustafa Raja: So this one, so this one, is the, is the, correct exact same table.
305 00:45:49.240 ⇒ 00:45:52.929 Mustafa Raja: Demiladia pointed it out, that,
306 00:45:53.590 ⇒ 00:45:56.560 Mustafa Raja: We should be using, fact transactions.
307 00:45:56.720 ⇒ 00:46:04.200 Mustafa Raja: And the revenue, revenue details topic had some fact transactions, but some other table.
308 00:46:05.020 ⇒ 00:46:09.870 Mustafa Raja: But even with that, even with this, we are not getting the… You know?
309 00:46:10.310 ⇒ 00:46:11.610 Mustafa Raja: BigQuery value.
310 00:46:19.410 ⇒ 00:46:19.970 Awaish Kumar: Hmm.
311 00:47:28.970 ⇒ 00:47:33.220 Mustafa Raja: I’m wondering if you would want to take a look at, the joints.
312 00:47:38.650 ⇒ 00:47:43.290 Awaish Kumar: Hmm… I just… 1.1’s 10.
313 00:47:49.910 ⇒ 00:47:51.610 Awaish Kumar: And joins happening here.
314 00:47:53.140 ⇒ 00:47:56.880 Mustafa Raja: No, no, not here. The joins are in the topic, no?
315 00:47:57.400 ⇒ 00:48:02.269 Mustafa Raja: So, revenue details we do in the revenue and marketing performance folder.
316 00:48:04.940 ⇒ 00:48:09.019 Mustafa Raja: So, at the bottom, there would be market… marketing and revenue and marketing per… yeah.
317 00:48:09.360 ⇒ 00:48:13.860 Mustafa Raja: And then, in here, there’s going to be Revenue Details V2.
318 00:48:17.770 ⇒ 00:48:19.229 Mustafa Raja: Yeah, this one.
319 00:48:23.370 ⇒ 00:48:27.469 Mustafa Raja: I think what the, what the…
320 00:48:28.190 ⇒ 00:48:34.739 Mustafa Raja: Dashboard needs is only a join between products and, fact transactions.
321 00:48:35.900 ⇒ 00:48:38.519 Awaish Kumar: Premium products and the fact transactions.
322 00:48:38.670 ⇒ 00:48:45.630 Mustafa Raja: Yeah, I don’t see, so… Sorry? Fact transactions is as base for you, no.
323 00:48:50.600 ⇒ 00:48:52.659 Awaish Kumar: Oh, okay, 5 transactions.
324 00:48:52.810 ⇒ 00:48:56.130 Mustafa Raja: Yeah. Yeah.
325 00:48:56.330 ⇒ 00:49:08.250 Mustafa Raja: And I’m wondering if… I wouldn’t recommend that, because this is being used in other ones also, so maybe we would want to create a new one specifically for this?
326 00:49:09.950 ⇒ 00:49:10.920 Awaish Kumar: Yeah, let’s do that.
327 00:49:10.920 ⇒ 00:49:11.650 Mustafa Raja: I need it.
328 00:49:11.960 ⇒ 00:49:17.010 Mustafa Raja: We could copy this, create a new one with fact transactions, and… You know?
329 00:49:17.330 ⇒ 00:49:23.239 Mustafa Raja: We’ll have to copy the YAML in the file, yeah, and then create a new topic.
330 00:49:28.980 ⇒ 00:49:30.420 Mustafa Raja: Fact transactions.
331 00:49:34.880 ⇒ 00:49:36.960 Mustafa Raja: Yeah, let’s do this, and then…
332 00:49:40.150 ⇒ 00:49:44.170 Mustafa Raja: And then we would want to name the… Topic tuna?
333 00:49:47.000 ⇒ 00:49:47.920 Awaish Kumar: Oh, this one.
334 00:49:48.650 ⇒ 00:49:49.280 Mustafa Raja: Yeah.
335 00:49:50.100 ⇒ 00:49:53.810 Awaish Kumar: So… Okay.
336 00:49:53.810 ⇒ 00:49:56.169 Mustafa Raja: It’s calling Debbie Snap or something, yeah.
337 00:49:56.860 ⇒ 00:49:57.500 Awaish Kumar: Yeah.
338 00:50:03.930 ⇒ 00:50:06.639 Awaish Kumar: To make a difference, yeah.
339 00:50:06.810 ⇒ 00:50:07.340 Mustafa Raja: new.
340 00:50:23.290 ⇒ 00:50:25.220 Awaish Kumar: Hey, joins.
341 00:50:27.020 ⇒ 00:50:30.229 Mustafa Raja: I think we only need the DIM products here.
342 00:50:33.500 ⇒ 00:50:35.620 Awaish Kumar: Yes, and…
343 00:50:35.620 ⇒ 00:50:38.500 Mustafa Raja: In line number 8. Okay. Yeah, this, this…
344 00:50:48.660 ⇒ 00:50:50.889 Mustafa Raja: I say let’s get rid of line number.
345 00:50:51.500 ⇒ 00:50:56.620 Mustafa Raja: 6 and 7 also, and then let’s just… Yeah.
346 00:50:58.170 ⇒ 00:51:03.370 Mustafa Raja: Yeah, let’s try this, if this… Gives us good values.
347 00:51:08.240 ⇒ 00:51:09.080 Awaish Kumar: Okay.
348 00:51:19.540 ⇒ 00:51:22.960 Mustafa Raja: But we can duplicate a query, from… okay.
349 00:51:24.240 ⇒ 00:51:25.890 Awaish Kumar: Let’s try from…
350 00:51:27.380 ⇒ 00:51:32.580 Mustafa Raja: revenue… Revenue by, revenue snapshot for Josh, right?
351 00:51:34.830 ⇒ 00:51:36.350 Awaish Kumar: Oh, wait, it’s not here.
352 00:51:37.280 ⇒ 00:51:38.340 Mustafa Raja: Let’s refresh.
353 00:51:40.530 ⇒ 00:51:42.500 Mustafa Raja: Did we save it, actually?
354 00:51:44.180 ⇒ 00:51:45.140 Awaish Kumar: Yes, yes.
355 00:51:45.140 ⇒ 00:51:45.870 Mustafa Raja: That’s cool.
356 00:51:46.480 ⇒ 00:51:49.230 Mustafa Raja: Okay, let’s refresh this then.
357 00:51:50.280 ⇒ 00:51:52.290 Mustafa Raja: Yeah, I saved this repet.
358 00:51:53.890 ⇒ 00:52:00.359 Mustafa Raja: No, no, let’s refresh the chart one, you know, the one that we want to see, yeah, let’s refresh this.
359 00:52:14.920 ⇒ 00:52:16.600 Awaish Kumar: Yeah, revenue snapshot football.
360 00:52:21.920 ⇒ 00:52:24.219 Awaish Kumar: Okay, why this is out of…
361 00:52:27.770 ⇒ 00:52:28.520 Mustafa Raja: Funny?
362 00:52:30.330 ⇒ 00:52:33.030 Awaish Kumar: Why I’m seeing these as two different?
363 00:52:33.590 ⇒ 00:52:45.919 Mustafa Raja: Yeah, so, the base view, gets the name of the topic, and then the other table remains a separate table, but it has the join, you know? The join is there, but it’s just a separate table.
364 00:52:47.220 ⇒ 00:52:51.289 Awaish Kumar: Okay, and how do we know that join happened on what column?
365 00:52:52.780 ⇒ 00:52:55.489 Mustafa Raja: Yeah, so if you go back to the topic…
366 00:52:57.750 ⇒ 00:53:04.310 Mustafa Raja: And then press Ctrl, and then, click the… Dim products.
367 00:53:08.960 ⇒ 00:53:16.960 Mustafa Raja: It’s, it’s not taking… It’s actually in the relationships file, to be honest. So if you would scroll up on the…
368 00:53:18.550 ⇒ 00:53:27.100 Mustafa Raja: Yeah, you’d find the… Let me, actually, let me, send you the link, link for relationships.
369 00:53:35.200 ⇒ 00:53:36.760 Mustafa Raja: I’ve shared in the Zoom chat.
370 00:53:39.750 ⇒ 00:53:41.930 Mustafa Raja: I’ve shared the link in the Zoom chat.
371 00:53:44.670 ⇒ 00:53:47.350 Mustafa Raja: Yeah, from here, you’ll have to find the join.
372 00:53:50.350 ⇒ 00:53:52.190 Mustafa Raja: This is all the joins, you know?
373 00:53:59.390 ⇒ 00:54:03.150 Mustafa Raja: We could, we could CTRL-F and dim product, you know?
374 00:54:06.560 ⇒ 00:54:07.300 Awaish Kumar: Okay.
375 00:54:24.840 ⇒ 00:54:26.040 Awaish Kumar: See you soon.
376 00:54:27.110 ⇒ 00:54:27.920 Awaish Kumar: How’d go.
377 00:54:33.740 ⇒ 00:54:35.499 Awaish Kumar: Can I do a doctor.
378 00:54:39.810 ⇒ 00:54:41.039 Mustafa Raja: Let’s keep going.
379 00:54:45.810 ⇒ 00:54:48.459 Mustafa Raja: Yeah, so… 987.
380 00:54:50.600 ⇒ 00:54:57.340 Awaish Kumar: Okay. Transactions, with artificial product ID? Okay.
381 00:54:58.260 ⇒ 00:55:01.330 Awaish Kumar: Let’s go here, then. We can select,
382 00:55:35.770 ⇒ 00:55:37.789 Awaish Kumar: Oh, okay, this is the same.
383 00:55:40.110 ⇒ 00:55:43.060 Mustafa Raja: Oh, is it exactly the same as BigQuery?
384 00:55:43.610 ⇒ 00:55:46.009 Mustafa Raja: I think this is the one that I was getting, no?
385 00:55:46.370 ⇒ 00:55:46.990 Awaish Kumar: Damon.
386 00:55:47.180 ⇒ 00:55:51.549 Awaish Kumar: So, is it, possible that it is reading from cash?
387 00:55:51.550 ⇒ 00:55:52.660 Mustafa Raja: Yeah, it is.
388 00:55:53.170 ⇒ 00:55:55.270 Awaish Kumar: How can we unclear that?
389 00:55:56.030 ⇒ 00:56:10.229 Mustafa Raja: I think it’s, it has to be set up in the model… Omni… Geshy… Oh, negative dash.
390 00:56:21.280 ⇒ 00:56:22.870 Mustafa Raja: Yeah, so…
391 00:56:42.470 ⇒ 00:56:44.490 Mustafa Raja: Dad, drunk without cafe.
392 00:56:56.000 ⇒ 00:56:57.369 Awaish Kumar: That was good.
393 00:56:58.690 ⇒ 00:56:59.390 Mustafa Raja: funny?
394 00:57:10.190 ⇒ 00:57:13.239 Mustafa Raja: Oh yeah, it’s, refresh without caching dashboard.
395 00:57:15.140 ⇒ 00:57:15.920 Awaish Kumar: Sorry?
396 00:57:16.670 ⇒ 00:57:20.580 Mustafa Raja: If you go in the… wait, let me… let me mark it.
397 00:57:21.750 ⇒ 00:57:26.330 Mustafa Raja: Can you click this, at the top left?
398 00:57:29.120 ⇒ 00:57:31.280 Mustafa Raja: Over here, top left.
399 00:57:36.790 ⇒ 00:57:39.109 Mustafa Raja: Yeah, so run without cachet.
400 00:57:40.140 ⇒ 00:57:41.689 Awaish Kumar: I just did that.
401 00:57:43.480 ⇒ 00:57:44.620 Mustafa Raja: Oh, okay, okay.
402 00:57:45.140 ⇒ 00:57:48.900 Awaish Kumar: Okay, can I see what… okay, it’s Dates Form.
403 00:57:49.220 ⇒ 00:57:50.430 Awaish Kumar: It’s fab.
404 00:57:53.570 ⇒ 00:57:56.460 Awaish Kumar: through… It’s March.
405 00:58:29.230 ⇒ 00:58:30.010 Mustafa Raja: Oh.
406 00:58:32.960 ⇒ 00:58:38.790 Mustafa Raja: Okay, this is… Different. But we haven’t put all of the filters yet, no?
407 00:58:41.350 ⇒ 00:58:48.659 Mustafa Raja: For example, you’re filtering based on current status, and in the dashboard, we are not filtering right now, you know?
408 00:58:50.510 ⇒ 00:58:51.949 Awaish Kumar: Hmm, I’m gonna add a filter.
409 00:58:51.950 ⇒ 00:58:52.650 Mustafa Raja: Is it?
410 00:58:52.860 ⇒ 00:58:56.730 Mustafa Raja: Yeah, let’s add… let’s add the filter for current status.
411 00:58:57.070 ⇒ 00:58:57.940 Mustafa Raja: You know?
412 00:58:58.610 ⇒ 00:59:00.479 Awaish Kumar: That’s… that’s not in…
413 00:59:02.370 ⇒ 00:59:06.770 Mustafa Raja: Abandoned, canceled, and there was one other, I forgot.
414 00:59:09.780 ⇒ 00:59:11.229 Mustafa Raja: Oh yeah, Andrew.
415 00:59:22.510 ⇒ 00:59:22.990 Awaish Kumar: Okay.
416 00:59:22.990 ⇒ 00:59:24.469 Mustafa Raja: This is exactly the same.
417 00:59:25.550 ⇒ 00:59:29.430 Awaish Kumar: Okay, so we are rematch with the table.
418 00:59:30.240 ⇒ 00:59:33.089 Awaish Kumar: Oh, why not then Tableau? I don’t know.
419 00:59:33.630 ⇒ 00:59:35.689 Mustafa Raja: Yeah, the blue one is…
420 00:59:38.940 ⇒ 00:59:39.880 Mustafa Raja: Tableau.
421 00:59:41.030 ⇒ 00:59:44.110 Awaish Kumar: I don’t know what date it is expecting with this, so…
422 00:59:44.110 ⇒ 00:59:50.709 Mustafa Raja: Oh, yeah… oh, and we cannot actually see it, because I think that’s… that’s just embedded in the query, no?
423 01:00:00.710 ⇒ 01:00:08.039 Awaish Kumar: Okay… And then with… It is actually a higher number.
424 01:00:12.300 ⇒ 01:00:18.370 Mustafa Raja: Can we run the data only in BigQuery to see what it gives us for that?
425 01:00:18.870 ⇒ 01:00:23.069 Mustafa Raja: So the query part of the date, and see what dates it gives.
426 01:00:23.280 ⇒ 01:00:24.609 Mustafa Raja: Is that possible?
427 01:00:26.040 ⇒ 01:00:27.210 Awaish Kumar: In the… in where?
428 01:00:27.960 ⇒ 01:00:29.209 Mustafa Raja: In BigQuery.
429 01:00:30.820 ⇒ 01:00:36.689 Mustafa Raja: So, is BigQuery able to give us a date range for the given query, is what I’m trying to say.
430 01:00:41.540 ⇒ 01:00:42.640 Awaish Kumar: Oh, you’re in…
431 01:00:43.840 ⇒ 01:00:45.240 Mustafa Raja: I mean…
432 01:00:46.510 ⇒ 01:00:53.320 Mustafa Raja: I mean, for this part, is it able to give us, the date range that it is selecting?
433 01:00:54.030 ⇒ 01:00:57.560 Awaish Kumar: This is the Tableau query, this is not a big query Sometimes.
434 01:00:57.560 ⇒ 01:01:02.050 Mustafa Raja: Yeah, I was just trying to figure out if the dates are different for Tableau and us, you know?
435 01:01:02.530 ⇒ 01:01:08.129 Awaish Kumar: Yeah, but… Yeah, but if we… if I do this…
436 01:01:09.110 ⇒ 01:01:11.270 Awaish Kumar: It is just going to give us a…
437 01:01:11.530 ⇒ 01:01:12.420 Mustafa Raja: Oh, okay, okay.
438 01:01:12.420 ⇒ 01:01:13.869 Awaish Kumar: Kitty. It is.
439 01:01:13.870 ⇒ 01:01:14.590 Mustafa Raja: Okay.
440 01:01:15.340 ⇒ 01:01:22.070 Mustafa Raja: Oh, yeah, okay, okay. No worries, thank you. I just wanted to, you know, see if, if there’s a possibility for that.
441 01:01:29.300 ⇒ 01:01:29.940 Mustafa Raja: I mean…
442 01:01:43.870 ⇒ 01:01:45.210 Mustafa Raja: 217.
443 01:01:49.740 ⇒ 01:01:52.720 Mustafa Raja: This is… Closer.
444 01:01:53.820 ⇒ 01:01:56.020 Awaish Kumar: It’s possible that it is…
445 01:02:00.130 ⇒ 01:02:03.110 Awaish Kumar: Yeah, but it is using Karan D, because,
446 01:02:07.540 ⇒ 01:02:11.369 Awaish Kumar: The query says auditory greater than this.
447 01:02:12.480 ⇒ 01:02:15.179 Awaish Kumar: Whatever date is, it’s just going to…
448 01:02:16.160 ⇒ 01:02:17.010 Mustafa Raja: Hmm.
449 01:02:19.310 ⇒ 01:02:21.680 Awaish Kumar: Today, minus 30 is what?
450 01:02:25.440 ⇒ 01:02:27.009 Awaish Kumar: Let me just say…
451 01:02:44.570 ⇒ 01:02:45.360 Awaish Kumar: Okay.
452 01:02:46.770 ⇒ 01:02:48.680 Awaish Kumar: It includes this as well.
453 01:02:50.380 ⇒ 01:02:52.940 Awaish Kumar: And it starts from 4th Feb.
454 01:02:53.600 ⇒ 01:02:57.060 Awaish Kumar: We can show this, because this will be higher, and that’s okay.
455 01:02:58.010 ⇒ 01:03:01.689 Awaish Kumar: You can say double is just showing the old numbers.
456 01:03:05.330 ⇒ 01:03:05.935 Mustafa Raja: Mmm…
457 01:03:11.310 ⇒ 01:03:13.310 Awaish Kumar: Yeah, because, I don’t know, like…
458 01:03:14.930 ⇒ 01:03:18.509 Mustafa Raja: What’s the phantom? Sorry, what does the…
459 01:03:22.420 ⇒ 01:03:23.390 Mustafa Raja: Yeah.
460 01:03:23.660 ⇒ 01:03:31.430 Mustafa Raja: Sorry, I’m wondering what does the filter become in, Omni? Is it then… should it now be 31 days?
461 01:03:33.280 ⇒ 01:03:34.669 Awaish Kumar: Where’s check go?
462 01:03:59.750 ⇒ 01:04:01.809 Awaish Kumar: It’s not 31 days.
463 01:04:08.540 ⇒ 01:04:11.359 Mustafa Raja: I think calculating, today also, no?
464 01:04:18.050 ⇒ 01:04:19.849 Awaish Kumar: Yes,
465 01:04:23.350 ⇒ 01:04:27.269 Awaish Kumar: Okay, yeah, this is how… but this is how it’s doing, right? Either…
466 01:04:29.140 ⇒ 01:04:31.019 Awaish Kumar: Why should I do it on the…
467 01:04:34.190 ⇒ 01:04:36.690 Awaish Kumar: Further for this report.
468 01:04:54.040 ⇒ 01:04:54.920 Awaish Kumar: Alright.
469 01:04:56.270 ⇒ 01:05:00.599 Mustafa Raja: It’s minus 30 days inclusive today, so that becomes 31, right?
470 01:05:01.110 ⇒ 01:05:02.140 Awaish Kumar: Yes, yes.
471 01:05:10.090 ⇒ 01:05:10.920 Mustafa Raja: Yeah.
472 01:05:11.810 ⇒ 01:05:13.300 Awaish Kumar: What should I do, right?
473 01:05:14.880 ⇒ 01:05:18.660 Mustafa Raja: Yeah, I think we do 31. What do you say?
474 01:05:23.280 ⇒ 01:05:24.660 Uttam Kumaran: Why? 30 days.
475 01:05:25.920 ⇒ 01:05:29.399 Awaish Kumar: So, yeah, it says 30 days minus today.
476 01:05:30.180 ⇒ 01:05:35.550 Awaish Kumar: that, it becomes 4th Feb using this function.
477 01:05:35.850 ⇒ 01:05:40.990 Awaish Kumar: And from 4th Feb, it just says greater than or equal to, that means it includes today.
478 01:05:41.210 ⇒ 01:05:45.169 Awaish Kumar: And if you count the days, it becomes 31 days, including today.
479 01:05:47.500 ⇒ 01:05:48.580 Uttam Kumaran: Hmm…
480 01:05:51.340 ⇒ 01:05:52.180 Awaish Kumar: Thank you.
481 01:05:55.660 ⇒ 01:05:56.460 Awaish Kumar: Yeah.
482 01:05:59.130 ⇒ 01:06:07.079 Awaish Kumar: where it says 30 days, I think we should maybe just try to explain that, like, use the 30 days project.
483 01:06:09.670 ⇒ 01:06:11.949 Mustafa Raja: Omni is just going to say 31 on filter.
484 01:06:22.560 ⇒ 01:06:27.780 Awaish Kumar: I’m not sure what the Josh’s requirement is. He wants to see the today’s revenue, or…
485 01:06:27.920 ⇒ 01:06:30.559 Awaish Kumar: He wants to see up till yesterday.
486 01:06:31.790 ⇒ 01:06:33.010 Uttam Kumaran: Up till close.
487 01:06:33.310 ⇒ 01:06:34.690 Uttam Kumaran: So do close.
488 01:06:36.870 ⇒ 01:06:40.160 Uttam Kumaran: Meaning… If today is halfway…
489 01:06:40.510 ⇒ 01:06:45.830 Uttam Kumaran: And you’re gonna nix… you’re not gonna go midday 30 days ago, right? So just do…
490 01:06:46.360 ⇒ 01:06:49.169 Uttam Kumaran: Yesterday, close until 30 days.
491 01:06:50.340 ⇒ 01:06:52.000 Mustafa Raja: Okay, so that becomes 30 days.
492 01:06:52.520 ⇒ 01:06:56.000 Awaish Kumar: But that is, like… We just removed today part.
493 01:06:56.000 ⇒ 01:06:56.620 Mustafa Raja: Yeah.
494 01:06:56.620 ⇒ 01:06:57.260 Uttam Kumaran: Yeah.
495 01:06:59.190 ⇒ 01:07:03.569 Awaish Kumar: So, okay, so that was not happening in Tableau, so we can just…
496 01:07:03.570 ⇒ 01:07:06.930 Uttam Kumaran: That’s fine, I’ll… I’ll… Yeah, let’s just…
497 01:07:08.190 ⇒ 01:07:14.930 Uttam Kumaran: just note… note down that that’s… that’s the thing we’re doing. It’s more accurate to do past 30 days closed.
498 01:07:17.470 ⇒ 01:07:19.409 Uttam Kumaran: The vast 30 complete days.
499 01:07:20.370 ⇒ 01:07:24.609 Mustafa Raja: Yeah, and… yeah, we can do complete days, if you… if you…
500 01:07:25.220 ⇒ 01:07:26.650 Awaish Kumar: Yeah, I would prefer that.
501 01:07:28.270 ⇒ 01:07:29.080 Mustafa Raja: you know…
502 01:07:48.670 ⇒ 01:07:50.400 Awaish Kumar: Okay, that’s.
503 01:07:54.120 ⇒ 01:07:59.380 Mustafa Raja: So this… we can identify the… okay. Yeah, this… we can do this, okay.
504 01:08:17.020 ⇒ 01:08:18.490 Awaish Kumar: Let’s see what it does.
505 01:08:27.800 ⇒ 01:08:29.590 Awaish Kumar: Not exactly…
506 01:08:30.420 ⇒ 01:08:32.649 Mustafa Raja: I can build that filter.
507 01:08:33.590 ⇒ 01:08:34.180 Awaish Kumar: Okay, nope.
508 01:08:35.149 ⇒ 01:08:35.869 Mustafa Raja: Yeah.
509 01:08:38.439 ⇒ 01:08:43.939 Mustafa Raja: Yeah, you can, you can publish this, I can take it from there.
510 01:08:48.899 ⇒ 01:08:50.049 Awaish Kumar: Let’s.
511 01:08:52.439 ⇒ 01:08:55.449 Mustafa Raja: We have some more values, too, if you want to take a look at that.
512 01:08:55.590 ⇒ 01:08:58.740 Mustafa Raja: Now that we know, you know, what’s… how’s the definitions working?
513 01:09:00.819 ⇒ 01:09:06.909 Awaish Kumar: Let’s rename it… 38 rabbit.
514 01:09:24.209 ⇒ 01:09:28.419 Awaish Kumar: Okay, just try to close this, and I’m looking at the other…
515 01:09:46.390 ⇒ 01:09:47.850 Mustafa Raja: Yeah, this is good now.
516 01:09:51.599 ⇒ 01:09:53.719 Awaish Kumar: Yeah, same for total orders.
517 01:10:08.690 ⇒ 01:10:10.070 Mustafa Raja: Okay…
518 01:10:11.430 ⇒ 01:10:22.649 Mustafa Raja: Can we take a look at 60 days now? I think, 30-day definition would be the same across 30 days, right? So, let’s take a look at 60 days and how that’s, you know, responding.
519 01:10:27.330 ⇒ 01:10:31.329 Awaish Kumar: Like, 60 days will be the same, right? Last 60 days, except…
520 01:10:31.330 ⇒ 01:10:33.540 Mustafa Raja: Okay, so excluding today, okay.
521 01:11:07.660 ⇒ 01:11:08.480 Mustafa Raja: Okay.
522 01:11:10.330 ⇒ 01:11:18.539 Mustafa Raja: And then, this, sorry, let me, let me mark it. This, so this is yesterday, right?
523 01:11:18.920 ⇒ 01:11:22.830 Mustafa Raja: So that just becomes excluding today and, and past Monday, right?
524 01:11:26.440 ⇒ 01:11:27.490 Awaish Kumar: Yes, yes.
525 01:11:27.930 ⇒ 01:11:29.799 Mustafa Raja: Okay, I just wanted to confirm.
526 01:11:31.010 ⇒ 01:11:35.239 Mustafa Raja: So the values aren’t exactly going to match. That’s correct?
527 01:11:36.070 ⇒ 01:11:39.819 Awaish Kumar: Yeah, they… doesn’t matter if they match with Tableau, but they should match with…
528 01:11:40.920 ⇒ 01:11:41.790 Mustafa Raja: BigQuery.
529 01:11:41.940 ⇒ 01:11:44.999 Mustafa Raja: Okay, I don’t have access to that, though.
530 01:11:46.050 ⇒ 01:11:48.230 Awaish Kumar: Yeah, if I want.
531 01:11:49.100 ⇒ 01:11:50.600 Mustafa Raja: It’s in one bus, okay, okay.
532 01:11:57.060 ⇒ 01:12:01.209 Awaish Kumar: I can look at new revenue, how this is coming.
533 01:12:05.500 ⇒ 01:12:06.110 Mustafa Raja: Oh, shit.
534 01:12:12.250 ⇒ 01:12:14.940 Awaish Kumar: New order from a new $32.
535 01:12:28.690 ⇒ 01:12:30.800 Awaish Kumar: User Auto Control.
536 01:12:31.960 ⇒ 01:12:32.700 Awaish Kumar: Okay.
537 01:13:23.580 ⇒ 01:13:25.389 Awaish Kumar: Meeting Natham Thi, how are you?
538 01:19:12.970 ⇒ 01:19:20.669 Mustafa Raja: Okay, Avish, should I just create a PR for your review, for the… for the LOD stuff?
539 01:19:21.500 ⇒ 01:19:25.220 Awaish Kumar: Okay, yeah, K2PR, but are you able to publish changes for this one?
540 01:19:29.150 ⇒ 01:19:32.820 Mustafa Raja: Can you go back? I think I already did.
541 01:19:34.610 ⇒ 01:19:38.069 Mustafa Raja: Go back in the dashboard, it should be at the bottom.
542 01:19:38.300 ⇒ 01:19:39.859 Mustafa Raja: Bottom of the dashboard.
543 01:19:42.390 ⇒ 01:19:44.510 Mustafa Raja: Let’s go bottom of the dashboard.
544 01:19:47.470 ⇒ 01:19:53.919 Mustafa Raja: Yeah, I need to restructure that, so it’s, yeah, 30-day revenue, you know, at the bottom right.
545 01:19:54.250 ⇒ 01:19:56.760 Mustafa Raja: I just need to put it in a bottom right.
546 01:19:57.420 ⇒ 01:20:03.780 Mustafa Raja: This is… this is some… something other that I worked on. Top left, so bottom right is what we were… just worked on.
547 01:20:05.480 ⇒ 01:20:09.050 Awaish Kumar: Yeah, so I need to restructure this.
548 01:20:11.680 ⇒ 01:20:12.320 Awaish Kumar: Okay.
549 01:20:15.720 ⇒ 01:20:17.380 Mustafa Raja: And I’m creating a PR for that.
550 01:20:23.040 ⇒ 01:20:25.140 Awaish Kumar: Like, let’s close this first.
551 01:20:26.010 ⇒ 01:20:31.189 Mustafa Raja: Okay, okay, let me… I can review it in parallel, just…
552 01:20:31.650 ⇒ 01:20:33.119 Awaish Kumar: Let me just close this first.
553 01:20:33.760 ⇒ 01:20:34.490 Mustafa Raja: What’s it?
554 01:22:02.970 ⇒ 01:22:05.209 Mustafa Raja: I’m going to work in a branch.
555 01:22:05.510 ⇒ 01:22:09.569 Mustafa Raja: So, to… what’s it called?
556 01:22:09.850 ⇒ 01:22:13.940 Mustafa Raja: Restructure this, so you can, you know, go ahead and edit.
557 01:22:14.260 ⇒ 01:22:17.330 Mustafa Raja: the metric. Does that make sense?
558 01:22:19.250 ⇒ 01:22:22.150 Mustafa Raja: I’m talking about the Omni dashboard.
559 01:22:23.540 ⇒ 01:22:25.600 Awaish Kumar: This, this dashboard, or the other one?
560 01:22:25.600 ⇒ 01:22:29.710 Mustafa Raja: Yeah, this one, this one. I’m saying that I’m going to create a branch and work on that.
561 01:22:29.950 ⇒ 01:22:39.490 Mustafa Raja: So you can, you know, go ahead and create, work on metrics. But I think, this does make sense, so much so that I can take it over from here.
562 01:22:41.710 ⇒ 01:22:42.530 Awaish Kumar: Okay.
563 01:22:46.930 ⇒ 01:22:53.180 Awaish Kumar: Okay, let’s… then let’s regroup when you’re done in, like, maybe 30 minutes, or… An hour.
564 01:22:53.180 ⇒ 01:22:53.990 Mustafa Raja: Okay, good.
565 01:22:54.830 ⇒ 01:22:56.319 Mustafa Raja: 30 minutes makes sense.
566 01:22:56.800 ⇒ 01:22:57.480 Awaish Kumar: Okay.
567 01:22:58.020 ⇒ 01:23:02.600 Awaish Kumar: And then for… These ones are too low.
568 01:23:02.620 ⇒ 01:23:06.840 Mustafa Raja: Yeah, maybe you can… maybe you can, you know, take a look at the other ones.
569 01:23:06.960 ⇒ 01:23:10.950 Mustafa Raja: While I, you know… Okay, reframe this, okay?
570 01:23:12.520 ⇒ 01:23:13.459 Awaish Kumar: Sure.
571 01:23:13.850 ⇒ 01:23:16.029 Mustafa Raja: I also have created a VR.
572 01:23:16.220 ⇒ 01:23:20.030 Mustafa Raja: So you can take a look at that, if that, you know, looks good or not.
573 01:23:20.580 ⇒ 01:23:23.419 Uttam Kumaran: Do we want to just do that right now and merge it in?
574 01:23:24.690 ⇒ 01:23:25.710 Mustafa Raja: Right.
575 01:23:26.250 ⇒ 01:23:26.980 Awaish Kumar: Yes.
576 01:23:26.980 ⇒ 01:23:29.429 Mustafa Raja: For the retention one, yeah, the retention dashboard.
577 01:23:31.630 ⇒ 01:23:33.069 Mustafa Raja: I’ll just get to the PR.
578 01:23:37.460 ⇒ 01:23:38.910 Mustafa Raja: Yes, this one.
579 01:24:27.320 ⇒ 01:24:34.200 Awaish Kumar: So, we are already taking a max here, I think, in the… The dashboard, maybe others.
580 01:24:35.350 ⇒ 01:24:39.999 Awaish Kumar: Select, like, is there option to select, like, any value in aggregation, or what?
581 01:24:40.000 ⇒ 01:24:44.310 Mustafa Raja: Yeah, yeah, yeah, we can select some average, or whatever we want.
582 01:24:46.180 ⇒ 01:24:52.029 Awaish Kumar: No, like, for this one, for example, I just need a single value record, because it’s already aggregating.
583 01:24:53.010 ⇒ 01:24:53.750 Mustafa Raja: Okay.
584 01:24:53.920 ⇒ 01:24:58.320 Mustafa Raja: So do you… do you suggest that we not aggregate in… No, no.
585 01:24:58.320 ⇒ 01:25:00.040 Awaish Kumar: How can only…
586 01:25:00.940 ⇒ 01:25:05.740 Mustafa Raja: Oh yeah, in Omni, yeah, in Omni, the described definition was, max.
587 01:25:09.100 ⇒ 01:25:11.869 Awaish Kumar: Okay, yeah, that… that’s final thought.
588 01:25:14.670 ⇒ 01:25:16.689 Awaish Kumar: This is the row number…
589 01:25:24.620 ⇒ 01:25:33.660 Awaish Kumar: Okay, we only need the code size and revenue, I think, and that’s… Here, so… All good.
590 01:25:34.340 ⇒ 01:25:42.660 Mustafa Raja: I think, if you would take a look at the PR validation for dbt, that GitHub run.
591 01:25:42.850 ⇒ 01:25:46.489 Mustafa Raja: Oh, sorry, the GitHub Actions run, you know, it’s failing.
592 01:26:00.120 ⇒ 01:26:02.770 Awaish Kumar: An expected amplifier-based output.
593 01:26:13.130 ⇒ 01:26:16.680 Awaish Kumar: So… I think you need a comma here.
594 01:26:17.870 ⇒ 01:26:18.920 Mustafa Raja: Oh, okay, okay.
595 01:26:19.210 ⇒ 01:26:21.120 Mustafa Raja: Let me put that under me.
596 01:26:22.320 ⇒ 01:26:25.470 Mustafa Raja: Let me create… let me create that comment.
597 01:26:26.110 ⇒ 01:26:27.160 Mustafa Raja: Quickly.
598 01:26:28.960 ⇒ 01:26:30.549 Mustafa Raja: Hey, hey Demi.
599 01:26:35.280 ⇒ 01:26:38.200 Mustafa Raja: Is there a way for me to, you know, test this locally?
600 01:26:38.360 ⇒ 01:26:40.080 Mustafa Raja: Before, you know…
601 01:26:43.010 ⇒ 01:26:44.470 Demilade Agboola: Tell us what locally, sorry.
602 01:26:45.880 ⇒ 01:26:48.270 Demilade Agboola: like, this… this.
603 01:26:49.180 ⇒ 01:26:53.310 Mustafa Raja: Yeah, this thing, yeah, this specific model that I’m working on, you know.