Meeting Title: Marketing Metrics Sync Date: 2026-03-06 Meeting participants: Awaish Kumar, Mustafa Raja
WEBVTT
1 00:00:23.770 ⇒ 00:00:25.110 Mustafa Raja: Hey, how are you?
2 00:00:25.600 ⇒ 00:00:33.610 Awaish Kumar: I… I just… Waterloo… ask something. I…
3 00:00:35.030 ⇒ 00:00:38.640 Awaish Kumar: Here, yeah, I added this new model.
4 00:00:39.650 ⇒ 00:00:40.100 Mustafa Raja: Okay.
5 00:00:41.720 ⇒ 00:00:46.210 Awaish Kumar: So, I refreshed the… Oh, it’s an SDG.
6 00:00:47.020 ⇒ 00:00:52.990 Mustafa Raja: Yeah, yeah, so, 12 more minutes for, the main one to run, right?
7 00:00:54.240 ⇒ 00:00:58.230 Mustafa Raja: Or, or has the main, GitHub job run already?
8 00:00:58.230 ⇒ 00:00:58.840 Awaish Kumar: Yes.
9 00:01:00.450 ⇒ 00:01:02.559 Awaish Kumar: Man one has run, so…
10 00:01:02.910 ⇒ 00:01:07.529 Mustafa Raja: Let’s copy this name exactly, and then let’s search it over so we know, you know.
11 00:01:08.120 ⇒ 00:01:09.279 Awaish Kumar: Sandy, let’s go up.
12 00:01:09.280 ⇒ 00:01:15.809 Mustafa Raja: Let’s copy this name, product, sales, summary by transaction, the whole thing, yeah, and let’s just find it, you know?
13 00:01:17.210 ⇒ 00:01:24.600 Mustafa Raja: So this is in staging only. Let’s, let’s, let’s, let’s do another sync with connection.
14 00:01:27.540 ⇒ 00:01:28.340 Awaish Kumar: -Oh.
15 00:01:29.030 ⇒ 00:01:29.820 Mustafa Raja: Yeah, this is…
16 00:01:29.820 ⇒ 00:01:30.940 Awaish Kumar: Thanks for Teijing.
17 00:01:31.750 ⇒ 00:01:33.849 Awaish Kumar: Okay, I haven’t watched the PR, sorry.
18 00:01:34.530 ⇒ 00:01:35.769 Mustafa Raja: Oh, okay, okay.
19 00:01:35.770 ⇒ 00:01:43.680 Awaish Kumar: It’s just… Yeah, my question was not that. Basically, I just noticed… My question was… Oh…
20 00:01:43.910 ⇒ 00:01:48.459 Awaish Kumar: Once we have… once I merge this, it will appear as a…
21 00:01:48.720 ⇒ 00:01:51.200 Awaish Kumar: As a model here, as a view. Yeah.
22 00:01:51.400 ⇒ 00:01:55.580 Mustafa Raja: So is this… this is also… this is also what we call a model, right?
23 00:01:56.400 ⇒ 00:02:02.999 Mustafa Raja: Yes. But, to be able to use it, we need to add that in a topic, or create a topic around it, you know?
24 00:02:03.760 ⇒ 00:02:05.719 Awaish Kumar: Okay, let’s create a topic.
25 00:02:06.100 ⇒ 00:02:08.340 Mustafa Raja: And then, yeah, let’s just select the view.
26 00:02:08.990 ⇒ 00:02:13.529 Mustafa Raja: And we can search in anything here. You can search even the staging model.
27 00:02:13.760 ⇒ 00:02:16.479 Mustafa Raja: Yeah, so this is the staging one.
28 00:02:16.870 ⇒ 00:02:21.720 Mustafa Raja: And you can get started, you know, staging one, with the staging one.
29 00:02:24.030 ⇒ 00:02:25.620 Awaish Kumar: Okay, and what should I…
30 00:02:26.010 ⇒ 00:02:32.300 Mustafa Raja: So we need to give the topic a name, and then, if you want to add…
31 00:02:32.300 ⇒ 00:02:34.570 Awaish Kumar: Global name, so it’s easier.
32 00:02:34.840 ⇒ 00:02:35.520 Awaish Kumar: Find.
33 00:02:36.640 ⇒ 00:02:37.700 Mustafa Raja: Sorry, sorry?
34 00:02:38.110 ⇒ 00:02:41.689 Awaish Kumar: For now, I just keep the same, this name, and we can relip it afterwards.
35 00:02:41.690 ⇒ 00:02:49.940 Mustafa Raja: Okay, so then what we’ll do is we’ll choose a folder, so these are 3 folders, right? If you want to add it in any of these folders.
36 00:02:50.260 ⇒ 00:02:53.580 Mustafa Raja: Feel free to add, else you can just go ahead and create.
37 00:02:54.510 ⇒ 00:02:55.890 Awaish Kumar: Oh.
38 00:02:56.710 ⇒ 00:02:58.360 Mustafa Raja: So you can create a new folder.
39 00:02:58.880 ⇒ 00:03:03.130 Awaish Kumar: It is in… should be in revenue, but it’s new… And revenue marketing.
40 00:03:03.940 ⇒ 00:03:06.230 Mustafa Raja: Okay, okay, yeah, let’s just create an…
41 00:03:06.660 ⇒ 00:03:08.629 Mustafa Raja: Yayin, you can now use it.
42 00:03:10.510 ⇒ 00:03:11.590 Awaish Kumar: Okay…
43 00:03:15.740 ⇒ 00:03:17.230 Awaish Kumar: And yeah, just…
44 00:03:21.450 ⇒ 00:03:23.140 Awaish Kumar: I mean, there’s one.
45 00:03:24.900 ⇒ 00:03:25.870 Awaish Kumar: Great.
46 00:03:26.770 ⇒ 00:03:27.380 Awaish Kumar: So cool.
47 00:03:27.380 ⇒ 00:03:27.970 Mustafa Raja: Yup.
48 00:03:28.780 ⇒ 00:03:32.260 Awaish Kumar: the… What is the…
49 00:03:35.970 ⇒ 00:03:39.960 Awaish Kumar: Okay, I don’t know, I don’t understand this ticket, basically.
50 00:03:40.270 ⇒ 00:03:47.010 Awaish Kumar: So I just… whatever… I just went from my… Understanding of the dashboard.
51 00:03:47.510 ⇒ 00:03:49.250 Awaish Kumar: Created the model.
52 00:03:49.970 ⇒ 00:03:53.450 Awaish Kumar: But I don’t know what you meant by that ticket.
53 00:03:54.130 ⇒ 00:04:10.700 Mustafa Raja: Okay, so that ticket… what that ticket is saying is that there are a few fields here that require level of detail, just like the other ones that we created. The same thing, for this one, you know?
54 00:04:11.030 ⇒ 00:04:12.650 Awaish Kumar: Why… what happened to this?
55 00:04:12.650 ⇒ 00:04:18.249 Mustafa Raja: Yeah, so, maybe, any filter here might have messed up.
56 00:04:18.649 ⇒ 00:04:21.779 Mustafa Raja: You know, in the dashboard, any filter might have messed up, so…
57 00:04:23.300 ⇒ 00:04:24.550 Awaish Kumar: I don’t know what it’s…
58 00:04:25.190 ⇒ 00:04:29.040 Mustafa Raja: Let’s… let’s… let’s look into a group.
59 00:04:31.820 ⇒ 00:04:34.330 Awaish Kumar: Yeah, but we are not making changes in Tableau.
60 00:04:42.490 ⇒ 00:04:45.609 Mustafa Raja: Okay. Oh, oh, why?
61 00:04:46.860 ⇒ 00:04:49.169 Mustafa Raja: Why would I do this now?
62 00:04:49.740 ⇒ 00:04:53.530 Mustafa Raja: Also, I am almost done with, what’s it called?
63 00:04:55.020 ⇒ 00:04:56.919 Mustafa Raja: The one that I was assigned.
64 00:04:57.540 ⇒ 00:05:08.469 Mustafa Raja: Do you want to take a look at that? I split that into two tables, because, I needed to pivot that, and, Omni’s pivot doesn’t play good with my years.
65 00:05:09.460 ⇒ 00:05:12.279 Mustafa Raja: So, let me know if you want to take a look at that, or…
66 00:05:13.360 ⇒ 00:05:21.069 Mustafa Raja: What you can do is, non-GLP is the same dashboard, but with one more filter, if this does not work.
67 00:05:22.430 ⇒ 00:05:23.870 Mustafa Raja: the other ticket.
68 00:05:23.970 ⇒ 00:05:27.189 Mustafa Raja: It’s the same dashboard with one more filter.
69 00:05:29.540 ⇒ 00:05:31.299 Awaish Kumar: Okay, let’s try this one.
70 00:05:31.680 ⇒ 00:05:32.500 Mustafa Raja: Okay, okay.
71 00:05:32.500 ⇒ 00:05:33.590 Awaish Kumar: Can I have a product.
72 00:05:40.010 ⇒ 00:05:40.999 Awaish Kumar: For a group.
73 00:05:47.430 ⇒ 00:05:51.810 Awaish Kumar: And, I can have a… Customize product name.
74 00:05:54.430 ⇒ 00:05:56.159 Awaish Kumar: What the heck?
75 00:06:09.400 ⇒ 00:06:10.090 Awaish Kumar: Fort?
76 00:06:11.410 ⇒ 00:06:13.160 Awaish Kumar: What’s happening?
77 00:06:14.590 ⇒ 00:06:17.549 Awaish Kumar: And then we have the ad spend.
78 00:06:21.210 ⇒ 00:06:22.650 Awaish Kumar: Or update…
79 00:06:45.340 ⇒ 00:06:46.410 Mustafa Raja: Hmm…
80 00:06:52.810 ⇒ 00:06:55.520 Awaish Kumar: So, product group didn’t get populated or something?
81 00:06:56.850 ⇒ 00:06:57.750 Awaish Kumar: Indeed.
82 00:07:11.660 ⇒ 00:07:18.900 Mustafa Raja: Hmm, maybe we can filter based on… we can say null on… we can say exclude null on product group.
83 00:07:20.470 ⇒ 00:07:23.540 Awaish Kumar: But my point is… Oof.
84 00:07:32.890 ⇒ 00:07:34.170 Awaish Kumar: Should we just…
85 00:07:38.260 ⇒ 00:07:39.080 Awaish Kumar: Hmm.
86 00:07:44.200 ⇒ 00:07:49.539 Awaish Kumar: We have teens. Okay, what is the… Let’s add date filter.
87 00:08:26.870 ⇒ 00:08:29.169 Mustafa Raja: Okay,
88 00:08:37.710 ⇒ 00:08:39.170 Mustafa Raja: Core size fixed.
89 00:08:41.030 ⇒ 00:08:43.590 Mustafa Raja: Burnside, isabel?
90 00:08:44.500 ⇒ 00:08:46.170 Mustafa Raja: chosen this.
91 00:08:52.550 ⇒ 00:08:57.190 Awaish Kumar: In order to… Current Facebook person holding.
92 00:08:58.810 ⇒ 00:09:00.980 Awaish Kumar: Chris, 25,000.
93 00:09:05.730 ⇒ 00:09:07.529 Awaish Kumar: And how much is food eat?
94 00:09:22.700 ⇒ 00:09:29.720 Awaish Kumar: 2626237… Okay, that’s correct.
95 00:09:35.630 ⇒ 00:09:38.539 Awaish Kumar: So it includes these both days, right? Do you know?
96 00:09:39.270 ⇒ 00:09:40.550 Mustafa Raja: Sorry.
97 00:09:40.550 ⇒ 00:09:42.179 Awaish Kumar: Is it inclusive of both dates?
98 00:09:42.180 ⇒ 00:09:43.889 Mustafa Raja: Yeah, yeah, yeah, it’s inclusive, yeah.
99 00:09:44.880 ⇒ 00:09:46.380 Awaish Kumar: Same for this?
100 00:09:46.720 ⇒ 00:09:47.470 Mustafa Raja: Yeah.
101 00:09:47.830 ⇒ 00:09:49.560 Awaish Kumar: Okay, then it’s correct dates.
102 00:09:51.000 ⇒ 00:09:54.319 Awaish Kumar: Okay, let me just debug the model a little bit.
103 00:09:55.040 ⇒ 00:09:57.180 Awaish Kumar: And look at Finnish tattoofur.
104 00:09:57.780 ⇒ 00:10:00.859 Mustafa Raja: Okay, okay, I am done with the… with the other one.
105 00:10:01.250 ⇒ 00:10:04.119 Mustafa Raja: with the one that I was given. The…
106 00:10:04.120 ⇒ 00:10:08.009 Awaish Kumar: If you are here, then if you’re done, you can stay here, we can deposit.
107 00:10:08.530 ⇒ 00:10:09.430 Mustafa Raja: Oh, okay.
108 00:10:10.610 ⇒ 00:10:13.110 Awaish Kumar: What’s going on, injectable simmer?
109 00:10:18.180 ⇒ 00:10:19.470 Awaish Kumar: 6 million…
110 00:10:21.920 ⇒ 00:10:22.820 Mustafa Raja: Oh, gosh.
111 00:10:23.210 ⇒ 00:10:25.939 Awaish Kumar: Okay, we don’t have Red Kids 7000.
112 00:10:26.370 ⇒ 00:10:27.840 Awaish Kumar: to profile…
113 00:10:33.720 ⇒ 00:10:36.280 Awaish Kumar: 2764.
114 00:10:57.620 ⇒ 00:10:59.350 Awaish Kumar: Word doesn’t work.
115 00:11:07.580 ⇒ 00:11:08.440 Awaish Kumar: Boom.
116 00:11:14.070 ⇒ 00:11:16.140 Awaish Kumar: Kill is very simple, so…
117 00:11:37.790 ⇒ 00:11:38.560 Awaish Kumar: Good.
118 00:11:43.990 ⇒ 00:11:45.080 Awaish Kumar: 6, 5th…
119 00:11:53.990 ⇒ 00:11:57.190 Awaish Kumar: Can you just check if it is exactly 30 days?
120 00:13:35.010 ⇒ 00:13:40.179 Mustafa Raja: I added dashboards, but I added charts, but those aren’t appearing on dashboard at all.
121 00:13:43.830 ⇒ 00:13:47.460 Mustafa Raja: Analog… Oh, this one, okay.
122 00:13:55.380 ⇒ 00:13:56.990 Mustafa Raja: Do you want retention?
123 00:13:57.480 ⇒ 00:14:01.090 Mustafa Raja: What’s there on… This goes on.
124 00:15:39.860 ⇒ 00:15:41.000 Mustafa Raja: Word…
125 00:16:09.770 ⇒ 00:16:14.389 Mustafa Raja: Okay. Okay, yeah, I’m… I’m actually done now there.
126 00:16:15.240 ⇒ 00:16:18.759 Mustafa Raja: Do you want to take a look? Because I split the table into two tables.
127 00:16:22.400 ⇒ 00:16:25.140 Awaish Kumar: Yeah, like, if the number’s matching, that’s it, then…
128 00:16:25.140 ⇒ 00:16:27.080 Mustafa Raja: Yeah, numbers are exactly the same.
129 00:16:27.730 ⇒ 00:16:29.900 Awaish Kumar: Yeah, it should be good, right?
130 00:16:31.190 ⇒ 00:16:32.650 Awaish Kumar: Are you wanting me to have a look?
131 00:16:33.490 ⇒ 00:16:34.819 Awaish Kumar: Can you share your screen.
132 00:16:35.350 ⇒ 00:16:45.509 Mustafa Raja: Yeah, yeah, so, here… So, it’s because how Omni plays with Meggers.
133 00:16:45.690 ⇒ 00:17:02.959 Mustafa Raja: I needed to pivot the table, and measures are automatically added to the pivoted side of the table, and we cannot exclude them, so that’s why I separated this into two tables, one heat map, and one actual table. Now…
134 00:17:04.640 ⇒ 00:17:06.990 Mustafa Raja: We can see, we can match the values here.
135 00:17:08.819 ⇒ 00:17:22.080 Mustafa Raja: And you’ll see that these are actually matching, so 400335333996, so 4002353339963995.
136 00:17:22.200 ⇒ 00:17:35.429 Mustafa Raja: These are all matching, and then… 1582, 13, 81… 1582, 1381… Then, 12, 41, 13, 54…
137 00:17:36.590 ⇒ 00:17:42.340 Mustafa Raja: And then same for here, 5.3, 5.1, 4.8, 4.8, 4.6.
138 00:17:43.380 ⇒ 00:17:43.910 Mustafa Raja: 2.
139 00:17:43.910 ⇒ 00:17:44.720 Awaish Kumar: Good morning.
140 00:17:44.760 ⇒ 00:17:46.210 Mustafa Raja: Jeez.
141 00:17:46.930 ⇒ 00:17:48.800 Mustafa Raja: And then, similar for this.
142 00:17:49.040 ⇒ 00:17:50.220 Awaish Kumar: I just saw it.
143 00:17:50.650 ⇒ 00:17:51.460 Mustafa Raja: Okay.
144 00:17:52.110 ⇒ 00:17:58.399 Mustafa Raja: Yeah, then this is… Good, let me mark it as done also.
145 00:17:59.370 ⇒ 00:18:00.810 Awaish Kumar: Yeah, and you’re late.
146 00:18:01.880 ⇒ 00:18:03.819 Mustafa Raja: Yeah, let’s take a look at the…
147 00:18:04.020 ⇒ 00:18:05.230 Awaish Kumar: Listen, fine.
148 00:18:05.230 ⇒ 00:18:05.830 Mustafa Raja: the last…
149 00:18:05.980 ⇒ 00:18:06.690 Awaish Kumar: lost one.
150 00:18:10.770 ⇒ 00:18:15.850 Mustafa Raja: I think it’s for use… Nope.
151 00:18:18.200 ⇒ 00:18:19.020 Mustafa Raja: Okay.
152 00:18:21.800 ⇒ 00:18:23.560 Mustafa Raja: Do you want to share screen or something?
153 00:18:27.830 ⇒ 00:18:33.739 Awaish Kumar: I… I can’t see… So, it says 1.
154 00:18:33.940 ⇒ 00:18:35.300 Awaish Kumar: Only one product.
155 00:18:36.950 ⇒ 00:18:43.309 Awaish Kumar: Why? I’m not able to see why there’s no… Is there a filter?
156 00:18:45.450 ⇒ 00:18:47.959 Awaish Kumar: There’s a filter on simultane.
157 00:18:49.190 ⇒ 00:18:51.509 Mustafa Raja: Yeah, and then standardized product.
158 00:18:52.490 ⇒ 00:18:54.379 Mustafa Raja: There’s filter on there, too.
159 00:18:54.380 ⇒ 00:18:57.980 Awaish Kumar: So… It’s removing injections, that’s why.
160 00:18:58.200 ⇒ 00:18:59.319 Awaish Kumar: It is half.
161 00:18:59.490 ⇒ 00:19:08.060 Awaish Kumar: Hmm. But this number is still… Still higher than… what I’m seeing in Picture.
162 00:19:08.980 ⇒ 00:19:09.920 Mustafa Raja: Oh.
163 00:19:12.590 ⇒ 00:19:17.490 Awaish Kumar: Hmm… This is 25,691.
164 00:19:17.650 ⇒ 00:19:18.360 Mustafa Raja: Yeah.
165 00:19:18.700 ⇒ 00:19:20.979 Awaish Kumar: There should be… Don’t be told.
166 00:19:20.980 ⇒ 00:19:23.090 Mustafa Raja: Oh, 22,000, hmm.
167 00:19:24.600 ⇒ 00:19:28.250 Awaish Kumar: These are all correct, also.
168 00:19:31.180 ⇒ 00:19:33.110 Awaish Kumar: It shows the same date range.
169 00:19:34.190 ⇒ 00:19:39.100 Mustafa Raja: Hmm… Okay.
170 00:19:44.820 ⇒ 00:19:46.429 Mustafa Raja: from this table.
171 00:19:47.070 ⇒ 00:19:50.439 Mustafa Raja: And we know that this table is, the right one.
172 00:19:53.440 ⇒ 00:19:58.599 Mustafa Raja: You know, the one that we’re querying is the right table to query.
173 00:19:59.440 ⇒ 00:20:10.270 Awaish Kumar: Yeah, it’s… It’s bringing in from… you can see it here… Product… Set summary by transaction.
174 00:20:11.460 ⇒ 00:20:13.330 Mustafa Raja: Okay, listen to the Christmas.
175 00:20:13.940 ⇒ 00:20:14.920 Awaish Kumar: What’s that?
176 00:20:15.840 ⇒ 00:20:18.569 Mustafa Raja: This is a… this is a joint… join table, no?
177 00:20:18.850 ⇒ 00:20:21.369 Mustafa Raja: So, product sale summary plus…
178 00:20:21.780 ⇒ 00:20:22.910 Awaish Kumar: Product good.
179 00:20:24.100 ⇒ 00:20:26.420 Awaish Kumar: This is coming from Winterfund, then.
180 00:20:27.570 ⇒ 00:20:32.659 Awaish Kumar: Let me just… but it is… the ad spend is coming from, basically.
181 00:20:33.990 ⇒ 00:20:35.660 Awaish Kumar: I think this ad is bad.
182 00:20:36.350 ⇒ 00:20:37.590 Awaish Kumar: It’s coming from…
183 00:20:37.990 ⇒ 00:20:39.060 Mustafa Raja: Product sales.
184 00:20:39.740 ⇒ 00:20:42.709 Awaish Kumar: This, and this is going to actually buy transaction.
185 00:20:43.530 ⇒ 00:20:44.310 Mustafa Raja: Hmm.
186 00:20:46.500 ⇒ 00:20:48.139 Awaish Kumar: There’s no problem with that.
187 00:21:12.080 ⇒ 00:21:12.909 Awaish Kumar: We’re the same.
188 00:21:26.640 ⇒ 00:21:29.420 Awaish Kumar: So this is a left join between these two tables.
189 00:21:29.540 ⇒ 00:21:31.640 Awaish Kumar: Testing product customer count.
190 00:21:33.620 ⇒ 00:21:35.659 Awaish Kumar: Where does this exist?
191 00:21:39.270 ⇒ 00:21:40.759 Awaish Kumar: Okay, this is you.
192 00:21:45.110 ⇒ 00:21:46.119 Mustafa Raja: Yeah, I guess…
193 00:21:46.120 ⇒ 00:21:46.840 Awaish Kumar: Storm?
194 00:21:47.320 ⇒ 00:21:50.809 Mustafa Raja: Yeah, I guess we can create this join in inside Omni then, right?
195 00:21:52.190 ⇒ 00:21:53.500 Awaish Kumar: Yeah, we can…
196 00:21:55.350 ⇒ 00:21:57.209 Mustafa Raja: But yeah, let’s just figure out the…
197 00:21:57.210 ⇒ 00:21:59.059 Awaish Kumar: what I just created for…
198 00:21:59.700 ⇒ 00:22:05.430 Awaish Kumar: This is for total. Oh, this is for new one. So this one I just created in.
199 00:22:07.750 ⇒ 00:22:08.480 Mustafa Raja: Do you believe?
200 00:22:09.390 ⇒ 00:22:13.970 Awaish Kumar: In the dbt… What a thing?
201 00:22:21.510 ⇒ 00:22:26.629 Mustafa Raja: So our, so our numbers are matching with, with what’s it called,
202 00:22:27.510 ⇒ 00:22:30.130 Mustafa Raja: BigQuery, but not with Tableau.
203 00:22:33.040 ⇒ 00:22:34.010 Awaish Kumar: Yes.
204 00:22:35.520 ⇒ 00:22:36.260 Mustafa Raja: Hmm.
205 00:22:40.210 ⇒ 00:22:45.970 Awaish Kumar: And the tableau numbers are higher. If it is lower, then I’m… I’m not concerned.
206 00:22:46.270 ⇒ 00:22:49.690 Awaish Kumar: Because with the time, We can add more.
207 00:22:50.040 ⇒ 00:22:51.000 Awaish Kumar: Spend.
208 00:22:51.630 ⇒ 00:22:55.540 Awaish Kumar: But the number is lower than the one in Tableau.
209 00:22:56.220 ⇒ 00:22:58.499 Awaish Kumar: And it should not be like that.
210 00:23:02.080 ⇒ 00:23:06.899 Mustafa Raja: So what we really need to figure out is what’s happening inside Tableau then, right?
211 00:23:07.790 ⇒ 00:23:09.050 Awaish Kumar: Yes.
212 00:23:09.630 ⇒ 00:23:12.660 Awaish Kumar: I don’t know what happened to this one.
213 00:23:13.400 ⇒ 00:23:18.169 Mustafa Raja: Yeah, with the known GLS, with the known GLP,
214 00:23:18.320 ⇒ 00:23:23.520 Mustafa Raja: Dashboard, we can take a look at this chart, if this is broken.
215 00:23:25.940 ⇒ 00:23:26.580 Awaish Kumar: Thank you.
216 00:23:26.900 ⇒ 00:23:28.180 Mustafa Raja: It would be…
217 00:23:43.040 ⇒ 00:23:51.240 Mustafa Raja: Okay, this is broken for non-GLP also. I think it might be, might be because of time, you know?
218 00:23:52.020 ⇒ 00:23:58.750 Mustafa Raja: Tableau might have refreshed with… with… suspicious dates… Or something.
219 00:24:00.090 ⇒ 00:24:01.180 Awaish Kumar: I don’t think so.
220 00:24:02.510 ⇒ 00:24:03.480 Awaish Kumar: Okay, now we have…
221 00:24:03.480 ⇒ 00:24:05.219 Mustafa Raja: Last 3 days.
222 00:24:06.610 ⇒ 00:24:08.929 Mustafa Raja: Yeah, last 3 days will bring up data.
223 00:24:11.050 ⇒ 00:24:14.170 Mustafa Raja: If you select that, you know, the circle.
224 00:24:14.170 ⇒ 00:24:17.989 Awaish Kumar: Oh, that… Oh, I just won’t…
225 00:24:28.190 ⇒ 00:24:29.999 Awaish Kumar: Okay, now you’ll see.
226 00:24:30.450 ⇒ 00:24:32.339 Awaish Kumar: The sprint is the same.
227 00:24:32.600 ⇒ 00:24:38.960 Awaish Kumar: That means it is coming from the same table, for the birth, and the table is called
228 00:24:39.190 ⇒ 00:24:41.179 Awaish Kumar: Product summary by transaction.
229 00:24:41.980 ⇒ 00:24:47.840 Awaish Kumar: And… And, it doesn’t match.
230 00:24:48.670 ⇒ 00:24:50.110 Awaish Kumar: with this one.
231 00:24:51.510 ⇒ 00:24:58.430 Awaish Kumar: So now I’m just… Going back to the original one instead of… Using this new one.
232 00:24:59.500 ⇒ 00:25:03.890 Awaish Kumar: So we don’t… now we don’t… we know that we are not messing up, because…
233 00:25:04.330 ⇒ 00:25:06.500 Awaish Kumar: This day was just something funky.
234 00:25:06.500 ⇒ 00:25:10.809 Mustafa Raja: This is the old one, right? This is what exactly Tableau uses.
235 00:25:11.130 ⇒ 00:25:15.599 Awaish Kumar: Yeah, and we don’t… Basically, need to put this joint here.
236 00:25:21.680 ⇒ 00:25:24.709 Awaish Kumar: Oh, it says, actually, the correct one.
237 00:25:24.980 ⇒ 00:25:27.400 Awaish Kumar: 5620.
238 00:25:29.850 ⇒ 00:25:30.690 Awaish Kumar: Yeah.
239 00:25:31.800 ⇒ 00:25:34.519 Awaish Kumar: It basically says the script value is Tableau.
240 00:25:36.150 ⇒ 00:25:41.049 Mustafa Raja: Hmm… Then maybe the new model needs some adjustment.
241 00:25:42.700 ⇒ 00:25:45.169 Awaish Kumar: Moral needs adjustment, but why does…
242 00:25:45.470 ⇒ 00:25:49.760 Awaish Kumar: Because… let’s see the carry. What else is just the left joint.
243 00:25:50.490 ⇒ 00:25:52.000 Awaish Kumar: There’s nothing, like…
244 00:25:55.670 ⇒ 00:25:56.630 Awaish Kumar: Promot, promo…
245 00:26:00.920 ⇒ 00:26:04.409 Awaish Kumar: Nothing special is happening here, it just says left sign.
246 00:26:04.960 ⇒ 00:26:09.620 Awaish Kumar: On these ones… on dates.
247 00:26:10.590 ⇒ 00:26:14.700 Mustafa Raja: And left John shouldn’t mess with, our base table, right?
248 00:26:16.680 ⇒ 00:26:21.960 Awaish Kumar: Yes, and it should not, because it will have all the… And then it will…
249 00:26:23.070 ⇒ 00:26:24.610 Mustafa Raja: So Dan shouldn’t miss.
250 00:26:33.190 ⇒ 00:26:33.900 Mustafa Raja: Hmm…
251 00:26:52.890 ⇒ 00:26:53.530 Awaish Kumar: Hmm.
252 00:26:58.410 ⇒ 00:27:00.570 Mustafa Raja: Give me 10 minutes, I’ll be back.
253 00:27:01.180 ⇒ 00:27:01.950 Awaish Kumar: Okay.
254 00:27:03.840 ⇒ 00:27:07.180 Mustafa Raja: I’m in meetings, I’ll be just AFK for 10 minutes.
255 00:27:08.400 ⇒ 00:27:09.150 Awaish Kumar: Okay, okay.
256 00:34:47.389 ⇒ 00:34:48.289 Mustafa Raja: Hey, Ambass.
257 00:34:58.060 ⇒ 00:35:00.800 Awaish Kumar: Yeah, can you please… are you in the forge?
258 00:35:03.120 ⇒ 00:35:04.689 Mustafa Raja: Sorry? No, I’m not.
259 00:35:05.480 ⇒ 00:35:11.190 Awaish Kumar: So he actually… Mitesh said that, we should add a total row.
260 00:35:11.370 ⇒ 00:35:14.030 Awaish Kumar: In the first report we created.
261 00:35:14.590 ⇒ 00:35:16.259 Mustafa Raja: Okay. Let me add that.
262 00:35:16.520 ⇒ 00:35:19.759 Mustafa Raja: In the big table, right?
263 00:35:20.870 ⇒ 00:35:24.159 Mustafa Raja: Yeah, there’s one vegetable, actually.
264 00:35:24.160 ⇒ 00:35:24.920 Awaish Kumar: Or this one.
265 00:35:25.790 ⇒ 00:35:27.940 Awaish Kumar: We should have maybe totaler over here.
266 00:35:28.170 ⇒ 00:35:28.979 Mustafa Raja: Okay, okay.
267 00:35:29.090 ⇒ 00:35:30.049 Mustafa Raja: Let me do that.
268 00:35:40.930 ⇒ 00:35:41.484 Mustafa Raja: Mmm…
269 00:36:00.950 ⇒ 00:36:01.620 Awaish Kumar: And…
270 00:36:45.290 ⇒ 00:36:46.790 Mustafa Raja: Okay, I’ve published that.
271 00:36:48.440 ⇒ 00:36:52.519 Mustafa Raja: I’ve published over the total column. Oh, sorry, total row.
272 00:36:54.490 ⇒ 00:36:55.719 Awaish Kumar: Okay, yeah.
273 00:36:56.500 ⇒ 00:36:58.270 Awaish Kumar: Send me the image.
274 00:37:00.140 ⇒ 00:37:01.690 Mustafa Raja: Okay…
275 00:37:03.410 ⇒ 00:37:04.600 Awaish Kumar: Or maybe…
276 00:37:06.280 ⇒ 00:37:10.189 Mustafa Raja: I’m downloading a PNG, I’ll share it in Slack with you.
277 00:37:10.890 ⇒ 00:37:11.520 Awaish Kumar: Okay.
278 00:37:39.490 ⇒ 00:37:41.180 Awaish Kumar: Okay, now it is matching.
279 00:37:42.380 ⇒ 00:37:43.360 Mustafa Raja: Oh, that’s good.
280 00:37:46.040 ⇒ 00:37:47.130 Awaish Kumar: We just need to…
281 00:37:52.220 ⇒ 00:37:53.590 Awaish Kumar: How to round it?
282 00:37:56.680 ⇒ 00:38:02.769 Mustafa Raja: Oh, rounded… Just, wait, let me… this button?
283 00:38:05.550 ⇒ 00:38:06.580 Mustafa Raja: This one?
284 00:38:10.680 ⇒ 00:38:11.869 Mustafa Raja: Yeah, one more.
285 00:38:14.990 ⇒ 00:38:16.909 Awaish Kumar: And then you can add dollar sign, too.
286 00:38:20.690 ⇒ 00:38:26.319 Mustafa Raja: Yeah, if you click it, but now you’ll have to round it again. This is Omni for you.
287 00:38:34.090 ⇒ 00:38:37.189 Awaish Kumar: And I have to bring these changes also.
288 00:38:42.940 ⇒ 00:38:44.870 Awaish Kumar: Just gonna take some time.
289 00:38:51.740 ⇒ 00:38:52.710 Awaish Kumar: What else?
290 00:38:56.540 ⇒ 00:39:06.400 Awaish Kumar: Okay, can you create a… Can you… yeah, I’m working on this, this one, new orders.
291 00:39:06.960 ⇒ 00:39:11.100 Awaish Kumar: Can you, in parallel, work on the other one?
292 00:39:11.550 ⇒ 00:39:13.140 Mustafa Raja: Non-GLP1, yeah.
293 00:39:15.230 ⇒ 00:39:18.349 Awaish Kumar: Not the null, not yet one, the other… this one.
294 00:39:18.570 ⇒ 00:39:19.190 Awaish Kumar: Total.
295 00:39:21.990 ⇒ 00:39:24.190 Mustafa Raja: Okay, the charts. Okay, okay.
296 00:39:24.190 ⇒ 00:39:26.370 Awaish Kumar: Okay, in the same… Dashboard, yeah.
297 00:39:26.370 ⇒ 00:39:28.290 Mustafa Raja: The dashboard, but the other chart, okay.
298 00:39:28.640 ⇒ 00:39:29.210 Awaish Kumar: Yeah.
299 00:39:33.310 ⇒ 00:39:36.070 Awaish Kumar: Can you share the link of… link to the dash?
300 00:39:38.150 ⇒ 00:39:40.400 Awaish Kumar: Yes, and for that…
301 00:39:40.400 ⇒ 00:39:41.270 Mustafa Raja: Only ink.
302 00:39:41.980 ⇒ 00:39:42.650 Awaish Kumar: Sorry?
303 00:39:42.820 ⇒ 00:39:43.760 Mustafa Raja: OmniOne.
304 00:39:44.560 ⇒ 00:39:45.240 Awaish Kumar: Hmm?
305 00:39:48.700 ⇒ 00:39:54.630 Awaish Kumar: And for this, you have to actually… create a… Topic?
306 00:39:56.930 ⇒ 00:39:59.899 Awaish Kumar: And these are the sources, you have to join these two tables.
307 00:40:01.320 ⇒ 00:40:05.099 Mustafa Raja: Okay, I see that you haven’t attached this workbook to a dashboard yet.
308 00:40:06.260 ⇒ 00:40:07.630 Mustafa Raja: Do you want to do that?
309 00:40:09.310 ⇒ 00:40:12.209 Awaish Kumar: Yeah, I haven’t attached… okay, yeah, I…
310 00:40:12.390 ⇒ 00:40:15.759 Mustafa Raja: Yeah, let’s just… let’s just attach it, and then so we know, you know.
311 00:40:16.060 ⇒ 00:40:18.399 Mustafa Raja: We are working in separate things.
312 00:40:21.670 ⇒ 00:40:23.499 Mustafa Raja: What is wrong on that thing.
313 00:40:24.490 ⇒ 00:40:28.300 Awaish Kumar: Is it a marketing, or is it a… What is this?
314 00:40:28.560 ⇒ 00:40:36.689 Mustafa Raja: This was… this is… I think this is solely for… yeah, this is… I think this is market… marketing, you know, marketing metrics.
315 00:40:36.710 ⇒ 00:40:40.960 Awaish Kumar: Unless… new product.
316 00:40:41.710 ⇒ 00:40:42.810 Awaish Kumar: ROS.
317 00:40:43.320 ⇒ 00:40:44.010 Awaish Kumar: Okay.
318 00:40:49.510 ⇒ 00:40:50.280 Awaish Kumar: Okay.
319 00:40:55.130 ⇒ 00:41:02.999 Mustafa Raja: And I’ll be, I’ll be joining the, staging model with the other, with the other one in Tableau.
320 00:41:03.000 ⇒ 00:41:06.049 Awaish Kumar: No, no, these are… these both should be in the production.
321 00:41:07.810 ⇒ 00:41:10.860 Mustafa Raja: Okay, okay, so I’ll be joining these two, right?
322 00:41:10.860 ⇒ 00:41:13.200 Awaish Kumar: Yeah, I can show you, right, exactly.
323 00:41:15.580 ⇒ 00:41:16.100 Awaish Kumar: Oh, how?
324 00:41:16.100 ⇒ 00:41:18.919 Mustafa Raja: Product sales summary and product customers, okay.
325 00:41:21.110 ⇒ 00:41:25.720 Awaish Kumar: Yes, but you, you, you… You have to join it on this key.
326 00:41:31.180 ⇒ 00:41:33.560 Awaish Kumar: These both tables should be in production.
327 00:41:33.810 ⇒ 00:41:35.090 Awaish Kumar: You can see that.
328 00:41:35.460 ⇒ 00:41:35.940 Mustafa Raja: Interesting.
329 00:41:35.940 ⇒ 00:41:42.490 Awaish Kumar: To create a new topic, joining these two, Using this logic.
330 00:41:44.890 ⇒ 00:41:49.450 Mustafa Raja: Date is… date and purchase date, and then standardized product name and product name. Okay.
331 00:41:49.610 ⇒ 00:41:52.089 Mustafa Raja: Let me take a screenshot of this so I don’t forget.
332 00:41:52.930 ⇒ 00:41:53.830 Mustafa Raja: Thank you.
333 00:41:57.300 ⇒ 00:41:57.980 Awaish Kumar: We’re good.
334 00:41:58.380 ⇒ 00:41:59.540 Mustafa Raja: Yeah, I’m good.
335 00:43:12.500 ⇒ 00:43:13.260 Awaish Kumar: Hmm.
336 00:43:15.780 ⇒ 00:43:17.360 Awaish Kumar: Product users…
337 00:43:42.280 ⇒ 00:43:44.080 Mustafa Raja: The distinct product.
338 00:43:45.030 ⇒ 00:43:47.030 Mustafa Raja: Okay, I already have a topic for this.
339 00:43:48.520 ⇒ 00:43:50.000 Mustafa Raja: Revenue by products.
340 00:43:51.890 ⇒ 00:43:52.310 Awaish Kumar: Sorry?
341 00:43:52.780 ⇒ 00:43:56.289 Mustafa Raja: I already had… I have a topic, with the join.
342 00:43:59.100 ⇒ 00:44:01.199 Awaish Kumar: Okay, do you have the correct join, or…
343 00:44:01.570 ⇒ 00:44:02.919 Mustafa Raja: Yeah, yeah,
344 00:44:12.490 ⇒ 00:44:14.380 Mustafa Raja: Yep, the joins are correct.
345 00:45:40.210 ⇒ 00:45:43.149 Mustafa Raja: Do you have the SQL to create the product group?
346 00:45:48.050 ⇒ 00:45:48.760 Awaish Kumar: Yes.
347 00:45:50.290 ⇒ 00:45:51.610 Mustafa Raja: Okay, I might need it.
348 00:46:48.620 ⇒ 00:46:49.490 Mustafa Raja: Thank you.
349 00:49:24.130 ⇒ 00:49:30.200 Mustafa Raja: Okay, and then… My name’s your top.
350 00:49:37.430 ⇒ 00:49:40.399 Mustafa Raja: What part of… what part of your job do you like the most?
351 00:49:43.140 ⇒ 00:49:45.060 Mustafa Raja: What part of your job do you like the most?
352 00:49:47.110 ⇒ 00:49:53.780 Awaish Kumar: Yeah, I’m willing… Building data, infrastructure, and pipelines.
353 00:49:54.660 ⇒ 00:49:56.000 Mustafa Raja: And, and, and…
354 00:49:56.000 ⇒ 00:49:57.640 Awaish Kumar: engineering work, yeah.
355 00:49:58.200 ⇒ 00:50:05.700 Mustafa Raja: Oh, and, and, and, does that… does that, does, dashboarding come under that?
356 00:50:06.640 ⇒ 00:50:07.640 Awaish Kumar: Nope.
357 00:50:08.220 ⇒ 00:50:09.670 Mustafa Raja: Oh, okay, okay.
358 00:50:11.130 ⇒ 00:50:12.020 Mustafa Raja: Amen.
359 00:50:12.020 ⇒ 00:50:16.410 Awaish Kumar: I’ve… yeah, I’ve never done… Dashboarding so much, I just…
360 00:50:17.970 ⇒ 00:50:18.700 Mustafa Raja: Okay.
361 00:50:19.210 ⇒ 00:50:22.390 Awaish Kumar: I just did, like, in some jobs, just for…
362 00:50:22.520 ⇒ 00:50:26.500 Awaish Kumar: covering up for somebody, or something like that. But that’s not my core.
363 00:50:26.850 ⇒ 00:50:27.820 Awaish Kumar: expertise.
364 00:50:28.730 ⇒ 00:50:29.360 Mustafa Raja: Okay.
365 00:51:34.050 ⇒ 00:51:35.560 Mustafa Raja: Yeah, that’s the log name.
366 00:53:00.500 ⇒ 00:53:04.749 Mustafa Raja: Is your family still here in Karachi, or have they also.
367 00:53:07.230 ⇒ 00:53:08.400 Awaish Kumar: Yeah, encouraging.
368 00:53:08.970 ⇒ 00:53:10.010 Mustafa Raja: Oh, okay.
369 00:53:46.500 ⇒ 00:53:48.700 Mustafa Raja: How are the flights looking like?
370 00:53:51.370 ⇒ 00:53:53.260 Awaish Kumar: Yeah, flights are working fine.
371 00:53:53.900 ⇒ 00:53:56.739 Awaish Kumar: There has been a lot of flights.
372 00:53:57.650 ⇒ 00:54:04.499 Awaish Kumar: It’s basically… Although fully booked right now, but they are going.
373 00:54:04.830 ⇒ 00:54:05.380 Awaish Kumar: Trudeau.
374 00:54:05.380 ⇒ 00:54:05.940 Mustafa Raja: Nope.
375 00:54:06.480 ⇒ 00:54:08.360 Awaish Kumar: But they’re mostly, they are going to Europe.
376 00:54:08.590 ⇒ 00:54:09.280 Awaish Kumar: Do I see.
377 00:54:10.070 ⇒ 00:54:10.960 Mustafa Raja: Okay.
378 01:00:56.740 ⇒ 01:00:57.720 Mustafa Raja: Okay, I’m good.
379 01:01:04.590 ⇒ 01:01:08.399 Mustafa Raja: Yeah, my staff, my, the, the, the…
380 01:01:08.890 ⇒ 01:01:13.439 Mustafa Raja: Marketing metrics, total orders, new products is…
381 01:01:13.690 ⇒ 01:01:22.789 Mustafa Raja: Done. I worked in a branch, so once you are done, I’ll then merge it. I’ll then merge my branch in, you know?
382 01:01:23.750 ⇒ 01:01:25.590 Mustafa Raja: So there’s no conflicts and stuff.
383 01:01:25.770 ⇒ 01:01:27.629 Awaish Kumar: Is it working? Like, is it okay?
384 01:01:27.630 ⇒ 01:01:29.489 Mustafa Raja: Would you need any DVD?
385 01:01:29.950 ⇒ 01:01:30.570 Mustafa Raja: Nope.
386 01:01:31.560 ⇒ 01:01:32.310 Awaish Kumar: Okay.
387 01:01:32.990 ⇒ 01:01:35.390 Awaish Kumar: Okay, but indeed, this one…
388 01:01:35.390 ⇒ 01:01:39.310 Mustafa Raja: I needed was a product group, which you provided.
389 01:01:41.680 ⇒ 01:01:45.710 Awaish Kumar: Okay, is it a… is it a, like, you made DVD changes, or just the…
390 01:01:46.600 ⇒ 01:01:47.430 Mustafa Raja: Sorry?
391 01:01:48.360 ⇒ 01:01:50.520 Awaish Kumar: Did you make any DVD change?
392 01:01:50.820 ⇒ 01:01:52.029 Mustafa Raja: No, not for this.
393 01:01:52.420 ⇒ 01:01:57.060 Mustafa Raja: I think the first one needed a dbt change for new product users.
394 01:01:59.510 ⇒ 01:02:01.890 Awaish Kumar: Yeah, that’s… and also revenue.
395 01:02:02.560 ⇒ 01:02:05.739 Awaish Kumar: That’s where I got stuck, yeah.
396 01:02:05.740 ⇒ 01:02:11.289 Mustafa Raja: When I started it, I got stuck at, the product user, new product users.
397 01:02:11.700 ⇒ 01:02:14.000 Mustafa Raja: And I never got to this one.
398 01:02:14.880 ⇒ 01:02:15.599 Mustafa Raja: You know.
399 01:02:16.600 ⇒ 01:02:17.380 Awaish Kumar: Okay, okay.
400 01:02:21.230 ⇒ 01:02:22.330 Awaish Kumar: Nope.
401 01:02:25.200 ⇒ 01:02:27.399 Awaish Kumar: I’m just fine, trying to find out.
402 01:02:27.640 ⇒ 01:02:30.049 Awaish Kumar: How he’s basically calculating.
403 01:02:31.000 ⇒ 01:02:36.810 Awaish Kumar: Yeah, like, adding so much context in the tableau is… Jesus.
404 01:02:36.810 ⇒ 01:02:44.969 Mustafa Raja: But on a bright side, we’re now centralizing this, right?
405 01:02:46.630 ⇒ 01:02:50.790 Awaish Kumar: Yeah, but then we are also adding a lot of things in… Omni.
406 01:02:51.590 ⇒ 01:02:54.829 Awaish Kumar: Yeah, that is correct. Because it’s not a…
407 01:02:57.680 ⇒ 01:03:05.710 Awaish Kumar: It can be problematic in the… when we maybe have to do… One more… migration.
408 01:03:06.270 ⇒ 01:03:10.089 Mustafa Raja: Yeah, hopefully, hopefully not…
409 01:03:17.130 ⇒ 01:03:25.870 Mustafa Raja: While you do this, I’ll take a look at the other one. At least, at least for the simpler table like this.
410 01:03:26.680 ⇒ 01:03:28.850 Mustafa Raja: Yeah.
411 01:03:32.300 ⇒ 01:03:32.900 Awaish Kumar: Okay.
412 01:03:33.190 ⇒ 01:03:35.650 Awaish Kumar: It’s doing bags only, IASD.
413 01:07:53.830 ⇒ 01:07:56.460 Awaish Kumar: Oh, by the way, how you… how do you add if…
414 01:07:57.940 ⇒ 01:08:00.380 Awaish Kumar: If we just add a column like…
415 01:08:08.420 ⇒ 01:08:13.970 Awaish Kumar: If we just add a column, like, max, renew…
416 01:08:17.069 ⇒ 01:08:20.779 Awaish Kumar: User counts… this thing?
417 01:08:25.220 ⇒ 01:08:29.600 Mustafa Raja: So this would be a level of detail, though, no?
418 01:08:30.689 ⇒ 01:08:33.329 Awaish Kumar: So this, basically, for each… Date?
419 01:08:36.080 ⇒ 01:08:38.189 Awaish Kumar: New product user.
420 01:08:40.040 ⇒ 01:08:41.830 Awaish Kumar: Huh, new, new product.
421 01:08:42.200 ⇒ 01:08:43.060 Awaish Kumar: Name.
422 01:08:43.220 ⇒ 01:08:45.900 Awaish Kumar: We’ll have a user count, which one says 6.
423 01:08:46.050 ⇒ 01:08:49.000 Awaish Kumar: It takes the max value.
424 01:08:50.380 ⇒ 01:08:51.630 Awaish Kumar: for each cohort.
425 01:08:54.840 ⇒ 01:08:58.509 Mustafa Raja: Okay, so the normal max isn’t going to work here, right?
426 01:08:59.640 ⇒ 01:09:01.989 Awaish Kumar: No, this is not normal, Max, right?
427 01:09:01.990 ⇒ 01:09:07.759 Mustafa Raja: Okay, let’s go, let’s go to the… let’s go to the Omni. There is a way to do that.
428 01:09:11.310 ⇒ 01:09:14.289 Mustafa Raja: Let’s go… let’s go to Omni, there’s a way to do that.
429 01:09:16.140 ⇒ 01:09:20.480 Mustafa Raja: So, which column here do you want to do that with?
430 01:09:21.810 ⇒ 01:09:22.929 Awaish Kumar: New product is account.
431 01:09:22.939 ⇒ 01:09:26.679 Mustafa Raja: Yeah, let’s click on these three dots here, and then modeling.
432 01:09:27.889 ⇒ 01:09:30.579 Mustafa Raja: And then new level of detail field.
433 01:09:32.709 ⇒ 01:09:36.469 Mustafa Raja: And then you should be able to do something like that here.
434 01:09:39.399 ⇒ 01:09:41.079 Mustafa Raja: So you want to do max, right?
435 01:09:41.599 ⇒ 01:09:46.279 Mustafa Raja: And then fixed dimension would be your… whatever fixed dimension you want.
436 01:09:48.579 ⇒ 01:09:49.859 Mustafa Raja: Do you want to do some?
437 01:09:51.700 ⇒ 01:09:52.330 Awaish Kumar: Who knows?
438 01:09:54.590 ⇒ 01:09:55.989 Mustafa Raja: Yeah, let’s try it out.
439 01:10:03.780 ⇒ 01:10:04.580 Awaish Kumar: Hmm.
440 01:10:16.040 ⇒ 01:10:21.580 Mustafa Raja: I did try making some of these with this level of detail, but,
441 01:10:22.380 ⇒ 01:10:25.869 Mustafa Raja: Didn’t work quite well for me, so maybe you can figure it out.
442 01:10:30.160 ⇒ 01:10:31.930 Awaish Kumar: Where the hell?
443 01:10:32.570 ⇒ 01:10:34.290 Awaish Kumar: Where is the column name?
444 01:10:39.010 ⇒ 01:10:43.020 Awaish Kumar: pick on… Why it’s not screwing?
445 01:10:44.990 ⇒ 01:10:47.900 Mustafa Raja: Just search it if you… if you know it.
446 01:10:49.600 ⇒ 01:10:53.500 Awaish Kumar: Yeah, but I’ve gone to see… Broke there.
447 01:10:54.720 ⇒ 01:10:55.440 Mustafa Raja: Yeah.
448 01:10:55.860 ⇒ 01:10:56.580 Awaish Kumar: Okay.
449 01:11:13.820 ⇒ 01:11:15.400 Mustafa Raja: Let’s see how this plays out.
450 01:11:16.290 ⇒ 01:11:17.400 Mustafa Raja: Is this good?
451 01:11:18.280 ⇒ 01:11:21.160 Awaish Kumar: But this… this is not we need, right? This is…
452 01:11:30.390 ⇒ 01:11:31.309 Mustafa Raja: Is this good?
453 01:11:31.480 ⇒ 01:11:32.090 Awaish Kumar: No.
454 01:11:32.880 ⇒ 01:11:34.819 Awaish Kumar: Not what I…
455 01:11:40.190 ⇒ 01:11:46.900 Awaish Kumar: Yeah, like… The way we created the other ones, right?
456 01:11:48.440 ⇒ 01:11:51.320 Awaish Kumar: That you added… DVD.
457 01:11:51.460 ⇒ 01:11:53.220 Awaish Kumar: Updates just now.
458 01:11:55.270 ⇒ 01:11:56.439 Awaish Kumar: in these PRs.
459 01:12:06.680 ⇒ 01:12:18.040 Mustafa Raja: Yeah, I think… yeah, I had a similar issue. I tried doing it via… via LED in Omni, and I never got the results that I wanted.
460 01:12:18.040 ⇒ 01:12:25.820 Awaish Kumar: I… I’m saying, even if I add this thing in the… In the… in my…
461 01:12:26.450 ⇒ 01:12:27.200 Mustafa Raja: Quinny.
462 01:12:27.560 ⇒ 01:12:30.469 Awaish Kumar: In my, yeah, in the model itself.
463 01:12:30.840 ⇒ 01:12:36.540 Awaish Kumar: Oh… How then we are going to include this in, this.
464 01:12:37.470 ⇒ 01:12:38.540 Mustafa Raja: Oh…
465 01:12:38.740 ⇒ 01:12:47.350 Mustafa Raja: I think we can add, we can add the SQL, custom SQL, directly to the… No, no, I’m saying I want to add this in the…
466 01:12:47.350 ⇒ 01:12:48.510 Awaish Kumar: DVD itself.
467 01:12:49.460 ⇒ 01:12:50.230 Mustafa Raja: Oh.
468 01:12:50.380 ⇒ 01:12:52.630 Mustafa Raja: Yeah, I just asked Kersa to do that.
469 01:12:52.950 ⇒ 01:12:57.130 Awaish Kumar: Yeah, I… Kassel edit it for me.
470 01:12:57.750 ⇒ 01:13:03.220 Awaish Kumar: But then… Point is, once I add it in here, it comes to Omni.
471 01:13:03.550 ⇒ 01:13:06.810 Awaish Kumar: Then in Omni, how we are going to use that.
472 01:13:06.810 ⇒ 01:13:13.439 Mustafa Raja: Oh, yeah, the connect… you just need to refresh the connection if the dbt model already has that.
473 01:13:13.440 ⇒ 01:13:20.309 Awaish Kumar: Yeah, but the thing is, what I’m… what I’m trying to say is, for example, let’s say this is date.
474 01:13:22.940 ⇒ 01:13:23.680 Awaish Kumar: Meme.
475 01:13:24.620 ⇒ 01:13:28.800 Awaish Kumar: Here’s the value… user account.
476 01:13:29.430 ⇒ 01:13:34.590 Awaish Kumar: This is Max… That we created, right?
477 01:13:34.740 ⇒ 01:13:35.219 Mustafa Raja: Hmm.
478 01:13:35.960 ⇒ 01:13:36.760 Awaish Kumar: Indeed.
479 01:13:39.850 ⇒ 01:13:41.169 Awaish Kumar: For the data…
480 01:13:47.620 ⇒ 01:13:48.710 Awaish Kumar: Yeah, product.
481 01:13:52.350 ⇒ 01:13:53.070 Awaish Kumar: Neat.
482 01:13:54.610 ⇒ 01:13:57.080 Awaish Kumar: Maybe for the same date we have worked.
483 01:13:58.330 ⇒ 01:13:59.190 Awaish Kumar: Right.
484 01:14:00.630 ⇒ 01:14:02.919 Awaish Kumar: So, if the user count is 1,
485 01:14:06.320 ⇒ 01:14:08.519 Awaish Kumar: Oh, you’re saying it should be the same.
486 01:14:09.890 ⇒ 01:14:10.900 Awaish Kumar: Yeah, like…
487 01:14:19.020 ⇒ 01:14:19.760 Awaish Kumar: Please.
488 01:14:21.930 ⇒ 01:14:22.680 Awaish Kumar: user group.
489 01:14:24.120 ⇒ 01:14:28.880 Awaish Kumar: In the max user count, What’s going to happen is…
490 01:14:29.250 ⇒ 01:14:35.029 Awaish Kumar: In the max, we are saying partition by date, Partition by user count.
491 01:14:35.520 ⇒ 01:14:36.920 Awaish Kumar: Get us the mix.
492 01:14:44.160 ⇒ 01:14:45.150 Awaish Kumar: Rando.
493 01:14:45.340 ⇒ 01:14:50.920 Awaish Kumar: But if in that analytical functions, it’s always going to…
494 01:14:51.870 ⇒ 01:14:53.729 Awaish Kumar: Have value for each of them.
495 01:14:57.620 ⇒ 01:15:01.389 Awaish Kumar: Only if, like, this value is 1, that it should still be gone.
496 01:15:05.290 ⇒ 01:15:06.070 Mustafa Raja: Okay.
497 01:15:07.670 ⇒ 01:15:10.750 Awaish Kumar: This is not… What do you…
498 01:15:13.330 ⇒ 01:15:18.679 Awaish Kumar: Should be doing, like, Tableau says first… Date, first product, name.
499 01:15:20.080 ⇒ 01:15:21.490 Awaish Kumar: And then it…
500 01:15:24.550 ⇒ 01:15:26.280 Awaish Kumar: New product users.
501 01:15:27.450 ⇒ 01:15:30.000 Awaish Kumar: People who purchase first time, right?
502 01:15:30.540 ⇒ 01:15:31.210 Mustafa Raja: Hmm.
503 01:15:32.350 ⇒ 01:15:37.449 Awaish Kumar: For people who purchase the first time in this product, on this date.
504 01:15:42.400 ⇒ 01:15:44.120 Awaish Kumar: Yeah, my…
505 01:15:49.590 ⇒ 01:15:56.380 Awaish Kumar: Right now, what it is doing is… Trying to get a max… Of this.
506 01:15:56.590 ⇒ 01:15:59.080 Awaish Kumar: And then some… the values.
507 01:16:03.210 ⇒ 01:16:04.110 Mustafa Raja: Yeah.
508 01:16:06.310 ⇒ 01:16:07.639 Mustafa Raja: And what do we want?
509 01:16:10.120 ⇒ 01:16:13.130 Awaish Kumar: I don’t know if it is… like, yeah, then…
510 01:16:14.250 ⇒ 01:16:21.399 Awaish Kumar: And while doing that, if we do that, we get the exact same numbers, but there’s the thing that how we are going to get that, because
511 01:16:22.610 ⇒ 01:16:25.260 Awaish Kumar: The table will also have all these rows.
512 01:16:26.340 ⇒ 01:16:27.110 Mustafa Raja: Hmm.
513 01:16:29.100 ⇒ 01:16:34.969 Awaish Kumar: 3, 4. So, instead of… when we sum, I want to see, like, Product E…
514 01:16:35.140 ⇒ 01:16:39.700 Awaish Kumar: We should only have 2 from the first… Code.
515 01:16:39.910 ⇒ 01:16:46.409 Awaish Kumar: 3 from the second cohort, and 4 from the… Third code… It should be 9.
516 01:16:47.410 ⇒ 01:16:51.309 Awaish Kumar: Instead of… it should not sum all of these, it should just sum these.
517 01:16:52.390 ⇒ 01:16:56.590 Awaish Kumar: Because… This is the same cohort, right?
518 01:16:57.210 ⇒ 01:16:57.950 Mustafa Raja: Yeah.
519 01:16:58.070 ⇒ 01:17:02.190 Awaish Kumar: Let me just select… you want to select… For what?
520 01:17:02.570 ⇒ 01:17:05.340 Awaish Kumar: Like, the value, only the… for the…
521 01:17:06.150 ⇒ 01:17:08.139 Mustafa Raja: For the unique date, we want to get.
522 01:17:08.190 ⇒ 01:17:09.660 Awaish Kumar: For the first.
523 01:17:11.390 ⇒ 01:17:13.130 Mustafa Raja: For the unique date we want to get, Max.
524 01:17:13.250 ⇒ 01:17:17.240 Awaish Kumar: I just want to get the one single value out of these three.
525 01:17:17.480 ⇒ 01:17:18.230 Mustafa Raja: Yeah.
526 01:17:20.950 ⇒ 01:17:21.820 Mustafa Raja: That’s the thing.
527 01:17:21.820 ⇒ 01:17:24.160 Awaish Kumar: How you are doing it in Omni for other…
528 01:17:26.890 ⇒ 01:17:32.460 Mustafa Raja: I… to be honest, I just gave the definition, and Cursor ripped it for me.
529 01:17:32.830 ⇒ 01:17:34.699 Mustafa Raja: That’s what I did.
530 01:17:35.060 ⇒ 01:17:37.889 Mustafa Raja: I could try and, you know…
531 01:17:38.090 ⇒ 01:17:40.460 Mustafa Raja: Do that for this model if you want.
532 01:17:40.880 ⇒ 01:17:44.819 Mustafa Raja: Because I have the chat context, and it’s working in a way.
533 01:17:56.170 ⇒ 01:17:57.369 Awaish Kumar: What is this?
534 01:17:58.010 ⇒ 01:18:00.949 Mustafa Raja: This is the sum function because this is an aggregate, right?
535 01:18:05.410 ⇒ 01:18:07.100 Awaish Kumar: Okay…
536 01:18:10.350 ⇒ 01:18:18.799 Mustafa Raja: We need… if you want to look into the underlying definition, you need to edit the dimension, not the aggregate.
537 01:18:20.580 ⇒ 01:18:21.270 Awaish Kumar: Damn.
538 01:18:22.160 ⇒ 01:18:23.560 Mustafa Raja: New product user count.
539 01:18:23.680 ⇒ 01:18:25.490 Mustafa Raja: some… Hmm.
540 01:18:26.090 ⇒ 01:18:29.649 Awaish Kumar: Okay, but this is just summing it, right?
541 01:18:32.520 ⇒ 01:18:38.540 Mustafa Raja: Yeah, yeah. If you want the underlying definition of that, just search for new product user count.
542 01:18:38.810 ⇒ 01:18:39.570 Mustafa Raja: You know?
543 01:18:40.290 ⇒ 01:18:41.630 Mustafa Raja: And edit that.
544 01:18:48.350 ⇒ 01:18:49.809 Awaish Kumar: So, what’d you say?
545 01:18:50.520 ⇒ 01:18:53.539 Mustafa Raja: Let’s search for new product use account.
546 01:18:54.550 ⇒ 01:18:55.840 Mustafa Raja: Let’s search for it.
547 01:18:59.560 ⇒ 01:19:03.039 Mustafa Raja: And let’s… let’s disable these fields in use.
548 01:19:03.680 ⇒ 01:19:05.560 Mustafa Raja: New product use account.
549 01:19:07.510 ⇒ 01:19:10.670 Mustafa Raja: New product use account… it’s… it’s this one, no?
550 01:19:12.580 ⇒ 01:19:13.809 Mustafa Raja: And this…
551 01:19:15.110 ⇒ 01:19:15.749 Awaish Kumar: It is hard.
552 01:19:16.060 ⇒ 01:19:17.059 Mustafa Raja: This one, yeah.
553 01:19:18.080 ⇒ 01:19:22.079 Mustafa Raja: Didn’t we… why didn’t we work with the level of detail one?
554 01:19:46.780 ⇒ 01:19:48.360 Awaish Kumar: Let’s see…
555 01:19:56.930 ⇒ 01:19:57.819 Mustafa Raja: What’s his name?
556 01:19:58.910 ⇒ 01:20:00.020 Awaish Kumar: Nothing changed.
557 01:20:06.530 ⇒ 01:20:07.600 Awaish Kumar: Didn’t update.
558 01:20:10.440 ⇒ 01:20:17.419 Mustafa Raja: Yeah, I think what we should do is we should go into the level of… let’s aggregate the level of detail directly, no?
559 01:20:18.170 ⇒ 01:20:19.309 Mustafa Raja: We could do that.
560 01:20:19.630 ⇒ 01:20:22.019 Mustafa Raja: Just aggregate this one.
561 01:20:22.140 ⇒ 01:20:23.190 Mustafa Raja: Directly.
562 01:20:23.510 ⇒ 01:20:24.410 Mustafa Raja: This one?
563 01:20:26.040 ⇒ 01:20:27.100 Mustafa Raja: Aggregate.
564 01:20:32.950 ⇒ 01:20:34.619 Mustafa Raja: It’s exactly the same.
565 01:20:53.270 ⇒ 01:20:55.420 Awaish Kumar: Yeah, it is a shame, because…
566 01:20:55.570 ⇒ 01:20:58.360 Awaish Kumar: It is not selecting only one way.
567 01:20:58.760 ⇒ 01:21:00.510 Awaish Kumar: It is reflecting everything.
568 01:21:04.840 ⇒ 01:21:10.009 Awaish Kumar: Can I… Straight up this, can I… can we ask?
569 01:21:13.720 ⇒ 01:21:15.569 Mustafa Raja: Can we just get Max from this?
570 01:21:18.060 ⇒ 01:21:20.469 Awaish Kumar: We can get max, yes. Then what?
571 01:21:22.240 ⇒ 01:21:24.709 Mustafa Raja: Would that work, I’m asking?
572 01:21:26.720 ⇒ 01:21:28.670 Mustafa Raja: We aggregated with max.
573 01:21:29.140 ⇒ 01:21:31.170 Mustafa Raja: Is that… would that work?
574 01:21:35.390 ⇒ 01:21:37.210 Awaish Kumar: This is my expired.
575 01:21:37.350 ⇒ 01:21:38.690 Awaish Kumar: partition, then…
576 01:21:38.690 ⇒ 01:21:39.540 Mustafa Raja: Oh, okay.
577 01:21:40.510 ⇒ 01:21:42.900 Awaish Kumar: Summit for this product.
578 01:21:45.640 ⇒ 01:21:48.890 Mustafa Raja: Meaning, you just summed for each day, right?
579 01:22:00.550 ⇒ 01:22:02.459 Awaish Kumar: Tells we can do here…
580 01:22:10.680 ⇒ 01:22:13.819 Awaish Kumar: Let me ask… Pick me off.
581 01:22:15.030 ⇒ 01:22:16.070 Awaish Kumar: Moby.
582 01:23:15.010 ⇒ 01:23:16.879 Mustafa Raja: This is the same, though, no?
583 01:23:18.070 ⇒ 01:23:19.010 Awaish Kumar: Yes.
584 01:23:27.880 ⇒ 01:23:33.980 Awaish Kumar: But I try this… this different… Bye.
585 01:23:49.220 ⇒ 01:23:56.360 Awaish Kumar: If I partition by this and only select the one rules, Then the sum is different.
586 01:23:57.430 ⇒ 01:24:00.760 Awaish Kumar: What matches with almost with the tableau.
587 01:24:01.550 ⇒ 01:24:10.829 Mustafa Raja: Mmm… Can we give this to Keshir, and ask it to make sure the model is reflecting this?
588 01:24:13.430 ⇒ 01:24:17.499 Awaish Kumar: Yeah, but we can’t… I can’t do this in Khasser, because…
589 01:24:18.800 ⇒ 01:24:22.589 Awaish Kumar: Cursor, the model is at a date level, granularity.
590 01:24:24.160 ⇒ 01:24:29.569 Awaish Kumar: So, for each, it is going from 2 days for each day. So, which is doing correctly?
591 01:24:30.250 ⇒ 01:24:31.900 Awaish Kumar: for each date.
592 01:24:32.170 ⇒ 01:24:33.350 Awaish Kumar: And the product name.
593 01:24:33.970 ⇒ 01:24:36.589 Awaish Kumar: It gets the mix of this.
594 01:24:38.570 ⇒ 01:24:39.500 Mustafa Raja: Okay, okay.
595 01:24:39.870 ⇒ 01:24:41.920 Awaish Kumar: This will filter out the rows.
596 01:24:42.080 ⇒ 01:24:43.599 Awaish Kumar: That we don’t want to do.
597 01:24:45.480 ⇒ 01:24:46.410 Mustafa Raja: Okay…
598 01:24:47.030 ⇒ 01:24:47.770 Awaish Kumar: So…
599 01:25:05.600 ⇒ 01:25:07.480 Awaish Kumar: Will that be a problem?
600 01:25:10.940 ⇒ 01:25:13.039 Mustafa Raja: Can I sh- can I share my screen?
601 01:25:14.480 ⇒ 01:25:15.110 Awaish Kumar: Yes.
602 01:25:20.060 ⇒ 01:25:26.489 Mustafa Raja: So, with the model that I’m using, Cursor also created this
603 01:25:27.330 ⇒ 01:25:35.180 Mustafa Raja: You know? And when this filter is true, only then I am able to get the right values.
604 01:25:36.220 ⇒ 01:25:37.390 Mustafa Raja: With the sum.
605 01:25:40.380 ⇒ 01:25:42.489 Awaish Kumar: Oh, okay, okay.
606 01:25:43.130 ⇒ 01:25:44.659 Mustafa Raja: Does… does this help?
607 01:25:44.840 ⇒ 01:25:45.750 Awaish Kumar: Yeah, yeah.
608 01:25:46.270 ⇒ 01:25:52.570 Awaish Kumar: So this is just, like, okay, for each row, you are just… Mix.
609 01:25:53.480 ⇒ 01:25:54.110 Awaish Kumar: field.
610 01:25:54.110 ⇒ 01:25:57.679 Mustafa Raja: Yeah, yeah. Which is true for one value only.
611 01:25:57.680 ⇒ 01:26:02.590 Awaish Kumar: We figured out the… Okay.
612 01:26:02.590 ⇒ 01:26:07.050 Mustafa Raja: Yeah, and then, maybe let me find the PR also.
613 01:26:07.620 ⇒ 01:26:11.569 Mustafa Raja: That I can share, because I, I was just looking at it…
614 01:26:13.450 ⇒ 01:26:17.110 Awaish Kumar: If I do that… Will it…
615 01:26:18.870 ⇒ 01:26:21.390 Awaish Kumar: Will my number for it changes?
616 01:26:22.040 ⇒ 01:26:29.929 Mustafa Raja: Because this way, we are selecting, I feel this way, we are selecting one row per date, right?
617 01:26:39.270 ⇒ 01:26:44.459 Awaish Kumar: Yeah, but then… The problem is… When we do that.
618 01:26:47.590 ⇒ 01:26:49.620 Awaish Kumar: After I have this filter.
619 01:26:50.540 ⇒ 01:26:55.989 Awaish Kumar: We’re in a chart where there is a wide spend coming in from some other table.
620 01:26:56.730 ⇒ 01:27:03.150 Awaish Kumar: That will fail, because I will spend… It’s spread across these rows.
621 01:27:05.980 ⇒ 01:27:09.539 Mustafa Raja: Oh, okay, so other rows would fail then.
622 01:27:13.400 ⇒ 01:27:15.649 Mustafa Raja: Otherwise, for failure then, okay.
623 01:27:30.360 ⇒ 01:27:31.830 Mustafa Raja: Yeah, that makes sense.
624 01:34:19.340 ⇒ 01:34:21.339 Mustafa Raja: The other one is super simple.
625 01:34:24.270 ⇒ 01:34:31.300 Mustafa Raja: Oh, by simple, I mean totally dependent on, this one, with some…
626 01:34:32.660 ⇒ 01:34:34.739 Mustafa Raja: You know, separate filters, that’s all.
627 01:34:36.030 ⇒ 01:34:42.600 Awaish Kumar: Okay, yeah, I’m also about… yeah, I just got a… Go over it, so…
628 01:34:43.270 ⇒ 01:34:45.559 Mustafa Raja: Oh, that’s nice. Oh, how?
629 01:34:46.540 ⇒ 01:34:53.889 Awaish Kumar: Yeah, I just asked, send my carry to Lobby, and it… Basically words.
630 01:34:55.280 ⇒ 01:34:56.350 Mustafa Raja: That’s nice.
631 01:34:58.110 ⇒ 01:35:01.979 Awaish Kumar: also use the SQL syntax, like partition by and all.
632 01:35:04.050 ⇒ 01:35:04.990 Awaish Kumar: added that.
633 01:35:05.290 ⇒ 01:35:07.180 Awaish Kumar: I’m adding just the final link.
634 01:35:07.580 ⇒ 01:35:08.760 Awaish Kumar: Next ones.
635 01:35:09.770 ⇒ 01:35:11.250 Mustafa Raja: That’s nice.
636 01:35:16.920 ⇒ 01:35:19.379 Awaish Kumar: And get new purchases.
637 01:35:38.940 ⇒ 01:35:45.200 Mustafa Raja: Would you know why the level of detail of Omni does not work for us?
638 01:36:12.800 ⇒ 01:36:16.980 Awaish Kumar: Yeah, I don’t know, and I don’t… I now have time to debug that.
639 01:36:17.480 ⇒ 01:36:19.450 Mustafa Raja: Yeah, that’s fair.
640 01:36:56.730 ⇒ 01:36:58.160 Awaish Kumar: And what is the best?
641 01:47:24.040 ⇒ 01:47:25.199 Awaish Kumar: Hi, how’s up?
642 01:47:27.200 ⇒ 01:47:30.350 Awaish Kumar: Yeah, I’m trying to… trying to publish, it says…
643 01:47:30.690 ⇒ 01:47:33.179 Awaish Kumar: A newer version of this document has been published.
644 01:47:34.040 ⇒ 01:47:35.750 Awaish Kumar: So… kinda…
645 01:47:35.750 ⇒ 01:47:39.569 Mustafa Raja: Can you share your screen? Let’s copy your stuff.
646 01:47:40.220 ⇒ 01:47:43.269 Mustafa Raja: Let’s copy the query, and then we can work with that.
647 01:47:44.670 ⇒ 01:47:46.969 Mustafa Raja: Can you share your screen? Yeah.
648 01:47:47.980 ⇒ 01:47:52.219 Mustafa Raja: Okay, so it says that a new version, newer version is populated, right?
649 01:47:52.990 ⇒ 01:47:54.899 Mustafa Raja: Dr. And you’re…
650 01:47:57.170 ⇒ 01:47:57.690 Awaish Kumar: Nope.
651 01:47:58.530 ⇒ 01:48:10.190 Mustafa Raja: Okay, so, so at the bottom, you’d see, we can copy, this, yeah, copy, and then let’s, let’s copy the ID, yeah?
652 01:48:10.990 ⇒ 01:48:17.750 Mustafa Raja: let’s copy the ID, and then what we can do is come out of this draft, start a new draft,
653 01:48:18.230 ⇒ 01:48:19.790 Mustafa Raja: And, you know, work with that.
654 01:48:20.670 ⇒ 01:48:23.449 Awaish Kumar: Come out of this draft, what do you mean, like, leave draft?
655 01:48:23.640 ⇒ 01:48:24.810 Mustafa Raja: Yeah, leaf draft.
656 01:48:27.470 ⇒ 01:48:28.920 Mustafa Raja: And then, sorry about it.
657 01:48:30.110 ⇒ 01:48:30.790 Awaish Kumar: Huh?
658 01:48:31.100 ⇒ 01:48:32.920 Mustafa Raja: Start edit, click edit.
659 01:48:37.480 ⇒ 01:48:42.970 Mustafa Raja: Okay, we might… hmm… So…
660 01:48:47.330 ⇒ 01:48:48.055 Mustafa Raja: Hmm…
661 01:48:51.320 ⇒ 01:48:52.020 Awaish Kumar: Did you publish.
662 01:48:52.020 ⇒ 01:48:57.110 Mustafa Raja: Yeah, yeah, I did. Now, let’s… let’s go into the model.
663 01:48:58.080 ⇒ 01:49:00.400 Mustafa Raja: Well, let’s actually leave draft.
664 01:49:02.140 ⇒ 01:49:02.710 Awaish Kumar: Nothing?
665 01:49:02.710 ⇒ 01:49:07.960 Mustafa Raja: Let’s actually leave draft and start… create a new branch, and then we can work in that.
666 01:49:08.380 ⇒ 01:49:13.040 Mustafa Raja: Let’s go… let’s click this model here, sorry, this model.
667 01:49:15.120 ⇒ 01:49:18.030 Mustafa Raja: And then branch, and then create a new branch.
668 01:49:20.670 ⇒ 01:49:22.130 Mustafa Raja: Name it anything.
669 01:49:24.490 ⇒ 01:49:25.839 Mustafa Raja: It is, yeah.
670 01:49:28.350 ⇒ 01:49:29.140 Awaish Kumar: This one?
671 01:49:29.140 ⇒ 01:49:30.370 Mustafa Raja: Yeah, shared model, yeah.
672 01:49:33.380 ⇒ 01:49:36.690 Mustafa Raja: Now, now let’s just, let’s, let’s go into the edit.
673 01:49:36.950 ⇒ 01:49:43.890 Mustafa Raja: Over here, yeah, and then let’s, let’s import tab, and then let’s paste the query.
674 01:49:47.980 ⇒ 01:49:48.860 Mustafa Raja: Yeah.
675 01:49:49.330 ⇒ 01:49:52.390 Mustafa Raja: And then let’s publish content drafts.
676 01:49:52.930 ⇒ 01:49:54.680 Mustafa Raja: This’ll push our stuff.
677 01:49:59.160 ⇒ 01:50:07.779 Mustafa Raja: And then, let’s… let’s just get… let’s just make it… what’s it called? Let’s just discard the changes and edit, so, you know, it’s usable again.
678 01:50:09.860 ⇒ 01:50:15.199 Mustafa Raja: Here, on the right… on the left side, you’ll see this card changes. Left side.
679 01:50:15.640 ⇒ 01:50:21.459 Mustafa Raja: Top… yeah, yeah, this one, let’s… let’s discard, since now we have it already.
680 01:50:21.680 ⇒ 01:50:25.590 Mustafa Raja: And then now we can leave draft and, you know, we’re done.
681 01:50:31.870 ⇒ 01:50:33.960 Mustafa Raja: We can go into the dashboard.
682 01:50:35.580 ⇒ 01:50:36.790 Awaish Kumar: Only the weekend.
683 01:50:37.130 ⇒ 01:50:38.270 Awaish Kumar: Drop this.
684 01:50:38.680 ⇒ 01:50:39.480 Mustafa Raja: Yeah.
685 01:50:44.370 ⇒ 01:50:48.720 Awaish Kumar: So, this is the query for… pink dog ones…
686 01:50:49.330 ⇒ 01:50:51.730 Awaish Kumar: I worked on, and this is the one.
687 01:50:53.020 ⇒ 01:50:55.009 Mustafa Raja: This is what one I worked on, yeah.
688 01:50:56.760 ⇒ 01:50:58.240 Awaish Kumar: Okay, you rename this?
689 01:50:59.550 ⇒ 01:51:05.980 Mustafa Raja: No, no, no, this is the… what’s it called? The topic was different, you know? We worked in different topics.
690 01:51:06.280 ⇒ 01:51:09.940 Mustafa Raja: Because my topic had to have a join, no?
691 01:51:10.940 ⇒ 01:51:15.929 Awaish Kumar: Okay, now can I… how can I point this to… Choose the correct…
692 01:51:17.890 ⇒ 01:51:23.740 Mustafa Raja: I think if we do that, we might have to, you know…
693 01:51:26.460 ⇒ 01:51:38.199 Mustafa Raja: bring the queries… what we will have to do is, we’ll have to start a new query with the correct topic, and then copy our stuff into that. Does that make sense?
694 01:51:40.660 ⇒ 01:51:41.330 Awaish Kumar: Whoa.
695 01:51:41.960 ⇒ 01:51:42.680 Awaish Kumar: What?
696 01:51:43.150 ⇒ 01:51:45.609 Mustafa Raja: Let’s discard the changes.
697 01:51:48.310 ⇒ 01:51:55.810 Mustafa Raja: Okay. Yeah… For now, I think what we should do is we should rename, at least rename the topic.
698 01:51:56.050 ⇒ 01:52:03.629 Mustafa Raja: And then, I can make sure that on Monday, I transfer this to, the broad one.
699 01:52:04.850 ⇒ 01:52:06.089 Awaish Kumar: Okay, let’s edit.
700 01:52:07.810 ⇒ 01:52:13.550 Mustafa Raja: Yeah, we’ll have to go into the topic and then set a label for the topic. That’s all we need to do.
701 01:52:19.870 ⇒ 01:52:21.170 Awaish Kumar: So we need to… Sure.
702 01:52:22.400 ⇒ 01:52:28.290 Mustafa Raja: So, yeah, these two… the two above charts, do we need them, or can we get rid of them?
703 01:52:29.700 ⇒ 01:52:31.959 Awaish Kumar: Like, I just added this one, I don’t… I don’t…
704 01:52:31.960 ⇒ 01:52:36.650 Mustafa Raja: Okay, okay. Yeah, these two, then we should delete, right? Or, yeah, hide.
705 01:52:42.460 ⇒ 01:52:44.850 Awaish Kumar: So, okay, let’s hide this.
706 01:52:49.750 ⇒ 01:52:50.660 Mustafa Raja: Yeah.
707 01:53:15.990 ⇒ 01:53:18.160 Awaish Kumar: And the other one is complete in the upload.
708 01:53:18.570 ⇒ 01:53:28.890 Mustafa Raja: The other one, with the second… second, second table is complete. I can copy this over with the… add the new filters.
709 01:53:29.420 ⇒ 01:53:34.579 Mustafa Raja: And, you know, quickly cut this over there, too.
710 01:53:38.800 ⇒ 01:53:39.940 Awaish Kumar: The GLP one?
711 01:53:41.040 ⇒ 01:53:46.759 Mustafa Raja: Yeah, I, because it’s the same thing, except, different products.
712 01:53:51.690 ⇒ 01:53:54.310 Awaish Kumar: Oh, I mean, you mentioned that the…
713 01:53:57.360 ⇒ 01:53:59.850 Mustafa Raja: Yeah, non… yeah, non-GLP-1.
714 01:54:00.290 ⇒ 01:54:03.159 Awaish Kumar: Okay, so this is the same, right? You have to create the…
715 01:54:04.690 ⇒ 01:54:09.980 Mustafa Raja: Yeah, this is all the same, except I think the… I think there are more products in the…
716 01:54:14.910 ⇒ 01:54:16.889 Awaish Kumar: Yeah, but what I’m saying is…
717 01:54:17.250 ⇒ 01:54:22.619 Awaish Kumar: You can copy these now from… How I’m doing it.
718 01:54:22.620 ⇒ 01:54:31.260 Mustafa Raja: Yeah, I’m just going to copy the whole thing, the whole query, and then I’m just going to play with filters, you know? That’s what I did with my other table also.
719 01:54:36.840 ⇒ 01:54:38.170 Awaish Kumar: I’m doing it.
720 01:54:48.110 ⇒ 01:55:06.610 Mustafa Raja: So, copy this… Bring it here… And he… yard… And then… rulebook.
721 01:55:07.830 ⇒ 01:55:10.720 Mustafa Raja: And then let me import this tab.
722 01:55:14.420 ⇒ 01:55:19.300 Mustafa Raja: And then… Last 3 days…
723 01:55:22.600 ⇒ 01:55:23.730 Mustafa Raja: I understand.
724 01:55:40.810 ⇒ 01:55:43.640 Mustafa Raja: Screen 1 6, okay…
725 01:55:44.640 ⇒ 01:55:48.940 Mustafa Raja: Other than equal to… this is not equal to… we’ll get rid of all of these.
726 01:55:53.170 ⇒ 01:55:59.589 Mustafa Raja: This, this… Continuz I’m back, many groovies abound.
727 01:56:03.120 ⇒ 01:56:04.180 Mustafa Raja: Fair enough.
728 01:56:05.190 ⇒ 01:56:06.900 Mustafa Raja: Okay…
729 01:56:12.710 ⇒ 01:56:15.639 Mustafa Raja: When we make it past 3 days.
730 01:56:29.220 ⇒ 01:56:30.730 Mustafa Raja: Only through seminar.
731 01:56:43.230 ⇒ 01:56:46.920 Mustafa Raja: Hmm, ad spend is coming out to be a little larger.
732 01:56:52.130 ⇒ 01:56:53.460 Mustafa Raja: Should I share screen?
733 01:56:59.420 ⇒ 01:57:00.500 Mustafa Raja: So here…
734 01:57:01.400 ⇒ 01:57:10.180 Mustafa Raja: I believe I have the correct filters, and then ad spend is just somewhat more than what it should be.
735 01:57:11.070 ⇒ 01:57:13.750 Mustafa Raja: New product uses on 2.
736 01:57:14.090 ⇒ 01:57:18.789 Awaish Kumar: That’s okay, because… How much?
737 01:57:21.460 ⇒ 01:57:22.250 Mustafa Raja: I think it’s…
738 01:57:22.770 ⇒ 01:57:26.790 Awaish Kumar: Yeah, like, just give me the dates, I can verify.
739 01:57:27.450 ⇒ 01:57:31.660 Mustafa Raja: Oh, okay, the dates are…
740 01:57:32.290 ⇒ 01:57:34.900 Mustafa Raja: 5th of March till 7th of March.
741 01:57:35.580 ⇒ 01:57:39.380 Awaish Kumar: 5th of March, and… Can verify in BigQuery.
742 01:57:40.000 ⇒ 01:57:40.750 Mustafa Raja: Yeah.
743 01:57:41.290 ⇒ 01:57:51.829 Mustafa Raja: And we are excluding, injectable… actually, we should just look for, there’s… yeah, this one.
744 01:57:53.700 ⇒ 01:57:56.330 Mustafa Raja: what this is cold.
745 01:57:58.270 ⇒ 01:58:00.809 Awaish Kumar: Excellent summary, my…
746 01:58:04.850 ⇒ 01:58:05.650 Awaish Kumar: Oh, dude.
747 01:58:10.510 ⇒ 01:58:12.650 Awaish Kumar: 5? 52 semi.
748 01:58:13.240 ⇒ 01:58:15.619 Mustafa Raja: Yeah, March 5th to 7th, yes.
749 01:58:16.340 ⇒ 01:58:20.309 Mustafa Raja: Okay. And then let’s, let’s, let’s look at this, this one, this one.
750 01:58:20.890 ⇒ 01:58:21.580 Mustafa Raja: So…
751 01:58:23.350 ⇒ 01:58:23.730 Awaish Kumar: Mom.
752 01:58:27.500 ⇒ 01:58:30.940 Awaish Kumar: Ideologists… You’re all right.
753 01:59:05.600 ⇒ 01:59:07.429 Awaish Kumar: It is 4445.
754 01:59:09.100 ⇒ 01:59:10.830 Mustafa Raja: Yeah, 4445, yeah.
755 01:59:11.510 ⇒ 01:59:18.200 Awaish Kumar: It’s okay, so it doesn’t match with Tableau, that’s not a problem, because I lose a little bit.
756 01:59:20.320 ⇒ 01:59:23.799 Mustafa Raja: Yeah, it sinks once a day, I know that.
757 01:59:23.980 ⇒ 01:59:25.140 Awaish Kumar: So it’s,
758 01:59:26.280 ⇒ 01:59:31.900 Awaish Kumar: Like, yeah, it does not refresh yet, so we have the data from BigQuery, which is correct.
759 01:59:32.680 ⇒ 01:59:35.489 Mustafa Raja: Okay, so this is… this whole thing is matching then, right?
760 01:59:36.300 ⇒ 01:59:39.649 Awaish Kumar: I don’t know about bolting, I just checked, it is, it is matching.
761 01:59:39.650 ⇒ 01:59:44.179 Mustafa Raja: Okay, let’s, let’s, can we, is it possible for us to also check this?
762 01:59:45.790 ⇒ 01:59:47.589 Mustafa Raja: For the same product?
763 01:59:47.920 ⇒ 01:59:49.510 Mustafa Raja: New product usage?
764 01:59:50.330 ⇒ 01:59:54.559 Awaish Kumar: Oh, you’re using the same my… Hmm, yeah, okay.
765 01:59:55.170 ⇒ 01:59:55.560 Mustafa Raja: and…
766 01:59:55.560 ⇒ 01:59:57.269 Awaish Kumar: topic I’ve been using.
767 01:59:58.940 ⇒ 02:00:12.070 Mustafa Raja: Yeah, yeah, I’m using the same one. This is for the, this is just to, you know, shift over the other one, you know? I just copied whatever you had and changed the filters.
768 02:00:12.610 ⇒ 02:00:14.880 Awaish Kumar: Okay, but give me the dates and…
769 02:00:15.260 ⇒ 02:00:21.299 Mustafa Raja: Oh, yeah, seeing it! 5… 5th of March, 7th of March?
770 02:00:21.700 ⇒ 02:00:23.200 Mustafa Raja: New product.
771 02:00:23.910 ⇒ 02:00:27.130 Mustafa Raja: Yeah, product is the same,
772 02:00:27.510 ⇒ 02:00:29.249 Mustafa Raja: The same one that we just did.
773 02:00:31.590 ⇒ 02:00:37.729 Mustafa Raja: And then, I just want to check new product uses, and once we are good with that, yeah, we can, you know, call it a day.
774 02:00:38.140 ⇒ 02:00:39.410 Awaish Kumar: We have 85, yeah.
775 02:00:40.630 ⇒ 02:00:47.710 Mustafa Raja: Oh, that’s nice, that’s pretty cool, actually. Let me, let me add, let me add dollars, and then…
776 02:00:49.130 ⇒ 02:00:53.889 Mustafa Raja: And then, yeah, this is good, I’m just going to publish it, and I’m going to add filters also.
777 02:00:59.730 ⇒ 02:01:06.029 Mustafa Raja: Okay… Okay, yeah, this is good.
778 02:01:06.330 ⇒ 02:01:07.400 Awaish Kumar: Then let’s…
779 02:01:08.040 ⇒ 02:01:08.710 Mustafa Raja: Right.
780 02:01:09.770 ⇒ 02:01:11.529 Mustafa Raja: Where did it be?
781 02:01:13.250 ⇒ 02:01:14.990 Mustafa Raja: This one.
782 02:01:18.180 ⇒ 02:01:21.580 Mustafa Raja: Okay, who can… Go.
783 02:01:22.010 ⇒ 02:01:30.550 Mustafa Raja: And then you can… oh, you should go up… And then you should… Let’s spread a little…
784 02:01:31.870 ⇒ 02:01:33.160 Mustafa Raja: Not this much.
785 02:01:34.230 ⇒ 02:01:35.689 Awaish Kumar: Yeah, it just moved.
786 02:01:36.910 ⇒ 02:01:42.530 Mustafa Raja: Yeah, okay, now… what is the name, actually?
787 02:01:49.850 ⇒ 02:01:50.650 Mustafa Raja: Oh my god.
788 02:01:50.650 ⇒ 02:01:57.330 Awaish Kumar: Just add a ticket for changing the… The topic to the product.
789 02:01:57.330 ⇒ 02:02:01.649 Mustafa Raja: I’ll add, I’ll add the ticket. Give me a moment, just…
790 02:02:06.100 ⇒ 02:02:10.790 Mustafa Raja: Okay, now I’ll go to… let’s first publish this.
791 02:02:11.870 ⇒ 02:02:13.440 Mustafa Raja: linear…
792 02:02:17.370 ⇒ 02:02:22.019 Mustafa Raja: I’m going to… Assign a ticket to myself here.
793 02:02:22.740 ⇒ 02:02:24.300 Awaish Kumar: Yes.
794 02:02:25.630 ⇒ 02:02:27.140 Mustafa Raja: Indeed,
795 02:02:31.820 ⇒ 02:02:33.020 Mustafa Raja: That’s awesome.
796 02:02:33.400 ⇒ 02:02:35.759 Awaish Kumar: Serve the topic from a staging tool.
797 02:02:37.540 ⇒ 02:02:41.080 Mustafa Raja: Okay, King, so… Some of the topics…
798 02:02:41.080 ⇒ 02:02:42.050 Awaish Kumar: topic name.
799 02:02:44.720 ⇒ 02:02:46.280 Mustafa Raja: Hmm, perfect.
800 02:02:49.950 ⇒ 02:02:56.749 Mustafa Raja: I’m just going to add the links to the charts, or the dashboards.
801 02:03:03.970 ⇒ 02:03:05.700 Mustafa Raja: Hmm…
802 02:03:09.350 ⇒ 02:03:10.550 Mustafa Raja: Lean draft.
803 02:03:12.630 ⇒ 02:03:14.630 Mustafa Raja: Yes, this one.
804 02:03:15.070 ⇒ 02:03:20.760 Mustafa Raja: Yeah, I’m going to assign this message. Okay. Okay.
805 02:03:22.370 ⇒ 02:03:27.130 Awaish Kumar: And, tickets assigned to them, you can mark them done, right?
806 02:03:28.120 ⇒ 02:03:38.139 Mustafa Raja: Yes, but I have to add some filters. I’m marking them done, and I’m adding filters, and then I’ll… End my day.
807 02:03:40.050 ⇒ 02:03:41.630 Awaish Kumar: Probably how I’m just…
808 02:03:42.710 ⇒ 02:03:47.629 Mustafa Raja: Yeah, feel free to… feel free to hop off. Thank you so much for your help.
809 02:03:48.800 ⇒ 02:03:53.970 Awaish Kumar: No worries, thank you, I will just send a… Update in client.
810 02:03:55.110 ⇒ 02:03:56.250 Awaish Kumar: channel. Okay.
811 02:03:58.410 ⇒ 02:03:59.799 Awaish Kumar: Okay, thank you.
812 02:04:00.190 ⇒ 02:04:01.490 Mustafa Raja: Thank you, have a good day.
813 02:04:01.920 ⇒ 02:04:03.800 Awaish Kumar: Yeah, you too. Good night.
814 02:04:04.160 ⇒ 02:04:05.240 Mustafa Raja: Goodbye, bye.