Meeting Title: Data Service Standup Date: 2026-03-10 Meeting participants: Brylle Girang, Uttam Kumaran, Demilade Agboola, Mustafa Raja, Awaish Kumar, Awaish Kumar
WEBVTT
1 00:00:47.620 ⇒ 00:00:48.620 Awaish Kumar: Hello?
2 00:00:50.160 ⇒ 00:00:54.900 Demilade Agboola: Bernal, I think we need to add, greg, to these calls.
3 00:00:55.960 ⇒ 00:00:57.490 Demilade Agboola: Especially for, like, default.
4 00:01:03.780 ⇒ 00:01:07.210 Brylle Girang: Awish, can you add Greg? But I’m not sure if he’ll be able to attend today.
5 00:01:07.210 ⇒ 00:01:11.939 Mustafa Raja: I think for default, his SL would be Robert, no?
6 00:01:14.980 ⇒ 00:01:16.920 Demilade Agboola: SL over Europe, I don’t know.
7 00:01:17.690 ⇒ 00:01:25.930 Brylle Girang: Yeah, I think, most of what Greg’s doing is strat… strategy… strategy related and not data, is that right?
8 00:01:26.450 ⇒ 00:01:30.640 Mustafa Raja: Yeah, yeah, that is correct.
9 00:01:32.380 ⇒ 00:01:33.019 Mustafa Raja: For Eden.
10 00:01:33.020 ⇒ 00:01:33.600 Brylle Girang: Yeah.
11 00:01:33.760 ⇒ 00:01:38.599 Mustafa Raja: Bi migration, he can be here, but not for default, I think.
12 00:01:40.310 ⇒ 00:01:44.109 Demilade Agboola: Oh, no, no, there have been some changes, so, like, yes, for defaults, he should actually be here.
13 00:01:44.490 ⇒ 00:01:45.310 Mustafa Raja: Oh.
14 00:01:51.060 ⇒ 00:02:02.269 Brylle Girang: Well, I don’t think so, because this is still, like, a data service stand-up, and we’re focused on the data for extremes, but starting tomorrow, when we transition to, like, the CSO plus SLs.
15 00:02:02.500 ⇒ 00:02:06.529 Brylle Girang: meeting cadence, then Greg should definitely be there.
16 00:02:06.900 ⇒ 00:02:08.439 Demilade Agboola: Okay, alright, sounds good then.
17 00:02:09.400 ⇒ 00:02:12.359 Mustafa Raja: Yeah, we’re changing our meeting… meeting schedules or something?
18 00:02:12.770 ⇒ 00:02:15.349 Brylle Girang: Yeah, we’ll talk more about that, Mustafa, in our…
19 00:02:15.350 ⇒ 00:02:15.900 Awaish Kumar: I ended up.
20 00:02:16.030 ⇒ 00:02:17.739 Brylle Girang: EP meeting later.
21 00:02:18.040 ⇒ 00:02:19.100 Mustafa Raja: Okay.
22 00:02:19.480 ⇒ 00:02:23.009 Awaish Kumar: Yeah, let me just get back to work.
23 00:02:23.190 ⇒ 00:02:29.020 Awaish Kumar: Yeah, we can decide, like, I heard yesterday that we are going to…
24 00:02:29.140 ⇒ 00:02:32.800 Awaish Kumar: Change, how the stand-ups work.
25 00:02:33.030 ⇒ 00:02:37.980 Awaish Kumar: So for that reason, like, just for maybe to today, until they…
26 00:02:38.380 ⇒ 00:02:41.509 Awaish Kumar: come up with a new plan. We are going to follow this.
27 00:02:42.530 ⇒ 00:02:46.290 Awaish Kumar: And for that, like, we can get started on the stand-ups.
28 00:02:54.830 ⇒ 00:02:59.630 Awaish Kumar: Oh, okay, starting with the… Magic spoons.
29 00:03:01.040 ⇒ 00:03:03.919 Awaish Kumar: How is it going, Navalardi?
30 00:03:04.390 ⇒ 00:03:07.799 Awaish Kumar: I heard back from Ashwini yesterday that
31 00:03:07.920 ⇒ 00:03:10.070 Awaish Kumar: He has delivered Magic Spoon work.
32 00:03:10.830 ⇒ 00:03:22.450 Demilade Agboola: Yeah, so he has delivered the, local data, the data that he ran on his local device, but he has not yet done the spins perfect setup, so that will be the final step.
33 00:03:25.350 ⇒ 00:03:26.859 Awaish Kumar: And today’s off.
34 00:03:27.910 ⇒ 00:03:29.779 Demilade Agboola: Oh, he’s off? I did not know he was off today.
35 00:03:30.340 ⇒ 00:03:39.089 Awaish Kumar: Okay, so I… Yeah, so I’m not… not sure what… maybe you can discuss that tomorrow when he’s back.
36 00:03:39.500 ⇒ 00:03:41.010 Demilade Agboola: Okay, sounds good.
37 00:03:41.260 ⇒ 00:03:42.430 Awaish Kumar: Try to close it.
38 00:03:43.430 ⇒ 00:03:46.740 Brylle Girang: Demi, sorry, what is the client?
39 00:03:46.910 ⇒ 00:03:53.030 Brylle Girang: what’s the client’s feedback there? Like, are they… are they rushing us when it comes to spin? I don’t think so, right?
40 00:03:53.030 ⇒ 00:03:58.620 Demilade Agboola: No, no, they aren’t. But ultimately, I don’t want it to over… I don’t want to overextend.
41 00:03:58.740 ⇒ 00:04:08.719 Demilade Agboola: And that’s kind of why I’m trying to ensure that we close it before it becomes a priority on their end, and they’re saying that we haven’t done what we need to do.
42 00:04:10.430 ⇒ 00:04:18.950 Awaish Kumar: Yeah, so Sprint’s pipeline is kind of stuck here for some time, and I want to get that, done as soon as possible.
43 00:04:19.589 ⇒ 00:04:24.389 Demilade Agboola: Yes, and also, if we can’t get it done as soon as possible, I want it to be very clear.
44 00:04:24.509 ⇒ 00:04:26.519 Demilade Agboola: So that, if they…
45 00:04:26.520 ⇒ 00:04:29.579 Awaish Kumar: I don’t think it’ll take so long, so let me know.
46 00:04:29.580 ⇒ 00:04:29.910 Demilade Agboola: Exactly.
47 00:04:29.910 ⇒ 00:04:30.620 Awaish Kumar: That group.
48 00:04:31.110 ⇒ 00:04:44.249 Demilade Agboola: Because I want us to be able to say, if anything happens, we can defend Ashwini and say, hey, we’ve looked at it, this was the best task that could have been done, there was nothing else we could have done. I don’t want a situation where we now have to start scrambling around last minute.
49 00:04:48.850 ⇒ 00:04:50.199 Awaish Kumar: Okay, apart from that.
50 00:04:51.000 ⇒ 00:04:57.209 Demilade Agboola: Apart from that, yeah, so maintenance work is in progress. I’m also currently working on the dbt run configuration.
51 00:04:57.370 ⇒ 00:05:03.940 Demilade Agboola: So that would be 43 and 38. So I did 38 this morning, looked around, and then 43 is in progress.
52 00:05:05.870 ⇒ 00:05:11.250 Awaish Kumar: Okay, moving on to the… CTA…
53 00:05:14.380 ⇒ 00:05:21.140 Awaish Kumar: But this, yeah, I… What?
54 00:05:28.500 ⇒ 00:05:30.550 Awaish Kumar: What is… what is this, Bill?
55 00:05:40.200 ⇒ 00:05:45.260 Brylle Girang: So this was created when you had the CES3 group, and this was based on the transcript.
56 00:05:51.990 ⇒ 00:05:54.519 Awaish Kumar: Okay, I don’t think we need this ticket.
57 00:05:56.030 ⇒ 00:06:01.620 Awaish Kumar: And, I… Asked yesterday to create a…
58 00:06:02.640 ⇒ 00:06:05.790 Awaish Kumar: A data modeling placeholder together? I can’t see that.
59 00:06:08.010 ⇒ 00:06:08.569 Awaish Kumar: Yeah, dude.
60 00:06:08.570 ⇒ 00:06:22.850 Brylle Girang: data modeling. Is that CT24, or the star schema? Yeah. Let me, let me enrich that one. I think for CTA, our main issue here is the CES models, and Ashwin is still block.
61 00:06:23.270 ⇒ 00:06:24.970 Brylle Girang: with the goods.
62 00:06:25.590 ⇒ 00:06:27.689 Awaish Kumar: That’s not the problem.
63 00:06:28.350 ⇒ 00:06:45.809 Awaish Kumar: basically, like, we delivered CES modeling where we could have done, and he’s blocked on the data, and we have already let them know, the client, that we don’t have this data, so we can’t do that. So the blog ones are… we can move them to backlog for now.
64 00:06:46.090 ⇒ 00:06:51.880 Awaish Kumar: If we want to, because we can’t do anything about it right now until we have more data.
65 00:06:53.350 ⇒ 00:07:13.149 Awaish Kumar: Then, this is the star schema for the models that I have developed. So, what I will be doing is here, based on the base model, I will convert into a star schema, and then, update our aggregations based on… on top of that. So, this is, and that will, kind of move us towards closure of CES modeling.
66 00:07:16.480 ⇒ 00:07:17.110 Brylle Girang: Okay.
67 00:07:17.500 ⇒ 00:07:18.620 Awaish Kumar: And then…
68 00:07:18.790 ⇒ 00:07:26.650 Awaish Kumar: Yeah, actually, he should be working on identity stitching. I have asked him yesterday, he should get started on that and try to…
69 00:07:27.080 ⇒ 00:07:28.320 Awaish Kumar: Close that.
70 00:07:30.310 ⇒ 00:07:39.769 Brylle Girang: So, since identity stitching is our main priority for this week, do you think that Ashwini has, like, the bandwidth to focus on that?
71 00:07:40.350 ⇒ 00:07:45.620 Awaish Kumar: For this week, we have two priorities. We have… CES Modeling Star Schema.
72 00:07:45.620 ⇒ 00:07:46.570 Brylle Girang: I’m just curious, yeah.
73 00:07:46.570 ⇒ 00:07:48.270 Awaish Kumar: And then identity switching.
74 00:07:48.400 ⇒ 00:07:54.030 Awaish Kumar: I am taking on CES modeling because I’ve already spent a lot of time on it.
75 00:07:55.510 ⇒ 00:08:04.269 Awaish Kumar: So I will be taking it to finish line, converting into, perfect models, and then updating all of our aggregations for that audit report.
76 00:08:04.550 ⇒ 00:08:08.079 Awaish Kumar: And… and… and actually should have, that,
77 00:08:08.280 ⇒ 00:08:12.150 Awaish Kumar: availability for identity streaking. I don’t think he…
78 00:08:12.760 ⇒ 00:08:16.680 Awaish Kumar: Yeah, he has a lot on the plate, so that’s the only thing for CTA for him.
79 00:08:17.550 ⇒ 00:08:18.240 Brylle Girang: Okay.
80 00:08:22.660 ⇒ 00:08:23.340 Brylle Girang: too deep.
81 00:08:25.360 ⇒ 00:08:32.429 Awaish Kumar: And then for Element, I started already on where to go. This is in progress, and it should be…
82 00:08:32.659 ⇒ 00:08:35.240 Awaish Kumar: Kind of done, so I will just move it to done.
83 00:08:36.409 ⇒ 00:08:40.269 Awaish Kumar: After some review… yeah, after I run some QA.
84 00:08:40.390 ⇒ 00:08:47.200 Awaish Kumar: And… this is… I don’t know why it’s still here, this is kind of done. I don’t know if it’s a new ticket, or…
85 00:08:48.460 ⇒ 00:08:52.780 Awaish Kumar: Because… What I remember from
86 00:08:53.610 ⇒ 00:08:57.639 Awaish Kumar: the… the work I have done, I think I have shipped… shipped this.
87 00:08:59.780 ⇒ 00:09:04.330 Brylle Girang: Okay, so where to go is done, okay, gotcha. So I…
88 00:09:04.330 ⇒ 00:09:10.360 Awaish Kumar: I think… Where to go is in QA validation, where… which is going to be closed?
89 00:09:10.950 ⇒ 00:09:18.090 Awaish Kumar: Today, so where to go is done, kind of… will be done today. This is done, and there are no new…
90 00:09:18.850 ⇒ 00:09:21.130 Awaish Kumar: modeling tickets for Element for now.
91 00:09:21.760 ⇒ 00:09:27.860 Brylle Girang: Okay. I think our biggest risk here is Amazon, since we still don’t have the Polytonic connector.
92 00:09:28.040 ⇒ 00:09:31.809 Brylle Girang: For that one, and that’s also blocking our modeling piece.
93 00:09:32.210 ⇒ 00:09:33.730 Brylle Girang: There, so.
94 00:09:34.230 ⇒ 00:09:37.569 Awaish Kumar: So, Shivani, from the client.
95 00:09:39.370 ⇒ 00:09:43.729 Awaish Kumar: They already, asked this question yesterday, and…
96 00:09:44.070 ⇒ 00:09:47.140 Awaish Kumar: in our channel with Polytomic, and
97 00:09:47.740 ⇒ 00:09:55.319 Awaish Kumar: Gallup responded that it will be done in a day or two. So, but, yeah, that’s the only thing we can do for now.
98 00:09:55.580 ⇒ 00:09:57.850 Awaish Kumar: Keep pushing it,
99 00:09:59.300 ⇒ 00:10:06.320 Awaish Kumar: For Polytomic, that we need this, and just let them… let the client know that we are doing this. Apart from that.
100 00:10:06.550 ⇒ 00:10:08.529 Awaish Kumar: And there’s nothing we can do right now.
101 00:10:09.770 ⇒ 00:10:10.410 Brylle Girang: Okay.
102 00:10:18.460 ⇒ 00:10:24.280 Awaish Kumar: Moving on to default, yeah, double audi.
103 00:10:29.710 ⇒ 00:10:33.899 Demilade Agboola: So for default, we’re trying to get out the…
104 00:10:34.600 ⇒ 00:10:43.920 Demilade Agboola: finalize the GTM dashboard, yeah, GTM dashboard today. We’re very close to the end, we’re just basically QAing it, and we should be able to…
105 00:10:44.100 ⇒ 00:10:48.559 Demilade Agboola: Show the team… we’ve shown the team, like, the link yesterday, we’ll just…
106 00:10:48.860 ⇒ 00:10:50.509 Demilade Agboola: Probably just do a Zoom clip.
107 00:10:50.720 ⇒ 00:10:53.980 Demilade Agboola: And showed Tim the data to be a while, because.
108 00:10:53.980 ⇒ 00:10:56.480 Awaish Kumar: And in terms of, like, client health, how’s it going?
109 00:10:57.830 ⇒ 00:11:03.779 Demilade Agboola: So we’re trying to restore that, so part of that is the call that we have tomorrow, and trying to get that to a good spot.
110 00:11:05.920 ⇒ 00:11:06.610 Awaish Kumar: Okay.
111 00:11:08.200 ⇒ 00:11:11.099 Awaish Kumar: So do you think right now it’s in, like, yellow spot?
112 00:11:12.370 ⇒ 00:11:13.540 Demilade Agboola: Yeah, I’ll probably see yellow.
113 00:11:14.110 ⇒ 00:11:17.670 Awaish Kumar: And do you need any help from anyone in the team?
114 00:11:18.540 ⇒ 00:11:23.549 Demilade Agboola: I think right now, with Mustafa and I, like, fully focused on this, I think we’re in a good spot.
115 00:11:24.260 ⇒ 00:11:24.960 Awaish Kumar: Okay.
116 00:11:28.650 ⇒ 00:11:32.700 Awaish Kumar: And yeah, most of all, if you have any updates for your tickets…
117 00:11:33.240 ⇒ 00:11:43.660 Mustafa Raja: So, so I, yesterday I worked on GTM metrics, I added, all of the, all rest of the,
118 00:11:43.740 ⇒ 00:12:02.370 Mustafa Raja: graphs that needed to be there. Right now, what we’re doing is we’re just making sure, yeah, all of the underlying data definitions are correct. So, yeah, that’s going to be our focus today, making sure that, you know, we get the GTM metrics over the line.
119 00:12:03.630 ⇒ 00:12:04.440 Awaish Kumar: Okay.
120 00:12:09.310 ⇒ 00:12:23.015 Awaish Kumar: Okay, moving on to the Eden, for the Eden, yeah, we… Delivered these, like, the… Du…
121 00:12:23.860 ⇒ 00:12:25.660 Awaish Kumar: These both work streams.
122 00:12:26.990 ⇒ 00:12:34.620 Awaish Kumar: This one is blocked because it’s a work in progress, reporting team works on it, and then they send them some feedback, I don’t know…
123 00:12:34.980 ⇒ 00:12:40.150 Awaish Kumar: It should be downloaded block, because, like, robert put it in blocked.
124 00:12:40.520 ⇒ 00:12:44.700 Awaish Kumar: But it’s kind of done, like, whatever modeling was required, it is done.
125 00:12:44.820 ⇒ 00:12:47.519 Awaish Kumar: And we, just continue evolving that.
126 00:12:49.440 ⇒ 00:12:55.240 Awaish Kumar: Then moving on… to one ticket from Aishini, and
127 00:12:55.650 ⇒ 00:12:58.300 Awaish Kumar: I don’t know, why is… is it still here?
128 00:12:58.470 ⇒ 00:13:00.820 Awaish Kumar: It should have been moved to Dome.
129 00:13:01.770 ⇒ 00:13:07.049 Awaish Kumar: I hope it is done, so I will confirm with Dharvity Ashwani, and… and close that out.
130 00:13:08.550 ⇒ 00:13:14.280 Awaish Kumar: Apart from that, I don’t think we have anything on, on the analytic side.
131 00:13:14.460 ⇒ 00:13:15.389 Awaish Kumar: On Eden.
132 00:13:16.000 ⇒ 00:13:23.860 Brylle Girang: Yeah. The fiasco last week, when it comes to the ETIN dashboard, those are already closed, like, Mustafa and Demi?
133 00:13:26.310 ⇒ 00:13:28.590 Brylle Girang: Like, the dashboard work that we did?
134 00:13:29.470 ⇒ 00:13:36.099 Mustafa Raja: Yes, but Greg is going through it. One… one more QA pass.
135 00:13:36.680 ⇒ 00:13:38.829 Mustafa Raja: So we might see some tickets there.
136 00:13:39.660 ⇒ 00:13:40.270 Brylle Girang: Okay.
137 00:13:47.450 ⇒ 00:13:51.980 Awaish Kumar: Set up Omnibus, okay. I think, yeah, these are all…
138 00:13:52.880 ⇒ 00:13:56.559 Awaish Kumar: Like, kind of… like, the platform-related tickets.
139 00:13:57.530 ⇒ 00:14:03.400 Awaish Kumar: So, Greg can look into that, but there’s no dashboarding work. We have closed that last week.
140 00:14:05.760 ⇒ 00:14:13.699 Awaish Kumar: I have replied on this ticket. Mustafa, I hope you are seeing that Slack, Slack.
141 00:14:13.700 ⇒ 00:14:26.849 Mustafa Raja: So what they need is, they want to add a pharmacy filter over the charts, right? I think we just need to shift the topic to sort of support that.
142 00:14:29.650 ⇒ 00:14:35.880 Awaish Kumar: So, yeah, yeah, like, we are at… we are at the end of the stand-up, so basically.
143 00:14:36.270 ⇒ 00:14:41.149 Awaish Kumar: I just want to deep dive on this ticket with Murta, if anyone want to listen.
144 00:14:42.340 ⇒ 00:14:45.669 Awaish Kumar: Otherwise, yeah, feel free to… To get back to work.
145 00:14:46.800 ⇒ 00:14:48.100 Brylle Girang: Thank you. Bye-bye.
146 00:14:48.100 ⇒ 00:14:48.570 Awaish Kumar: My…
147 00:14:48.830 ⇒ 00:14:50.069 Demilade Agboola: Thank you, bye.
148 00:14:55.600 ⇒ 00:14:59.579 Awaish Kumar: Yeah, so on this one, Mustwa,
149 00:15:05.040 ⇒ 00:15:09.429 Awaish Kumar: So thing is, not everything is possible.
150 00:15:10.200 ⇒ 00:15:13.780 Awaish Kumar: Number one,
151 00:15:14.040 ⇒ 00:15:20.570 Awaish Kumar: So, when there is any request, we are trying to find out if that is possible. If yes, then we should do it.
152 00:15:20.710 ⇒ 00:15:35.800 Awaish Kumar: If not, then we should say that it’s not possible, right? And we should not just try at tumbling it one way or other, if that’s… it doesn’t make… if that doesn’t make sense. That’s the number one. Second thing is.
153 00:15:36.480 ⇒ 00:15:41.429 Awaish Kumar: the table you mentioned, I clearly said, like, I can’t do that in that table. It’s not possible.
154 00:15:41.660 ⇒ 00:15:45.640 Awaish Kumar: Yeah. It’s a pushback. We always do that. Like, I got…
155 00:15:45.870 ⇒ 00:15:55.509 Awaish Kumar: some requests multiple times, and we have… we have said no, because it doesn’t make sense to add pharmacy in there, because I can’t split the ad spend by pharmacies.
156 00:15:55.820 ⇒ 00:16:01.209 Awaish Kumar: We run ads for our campaigns for the products. We don’t run by pharmacy.
157 00:16:02.350 ⇒ 00:16:07.070 Awaish Kumar: Second thing, third thing is, basically.
158 00:16:07.950 ⇒ 00:16:16.650 Awaish Kumar: Yeah, if you can add a chart in that dashboard, Which only depends on, for example…
159 00:16:17.100 ⇒ 00:16:23.989 Awaish Kumar: The orders data, and you can calculate retention from that, and you can add a chart
160 00:16:24.410 ⇒ 00:16:29.310 Awaish Kumar: then you can completely do that. Our pharmacy information is available at order level.
161 00:16:30.120 ⇒ 00:16:37.110 Awaish Kumar: So, if you can create a credit chart using, like… we already have a few topics related to retention, like,
162 00:16:37.640 ⇒ 00:16:43.139 Awaish Kumar: Code retention, summary, summary daily, and… And things like that.
163 00:16:44.640 ⇒ 00:16:50.699 Awaish Kumar: So… If we want to include pharmacy in any of those models, if we want to…
164 00:16:50.880 ⇒ 00:17:03.940 Awaish Kumar: use maybe fact transactions table, if you want to use order summary table. So, we can try, we can look into that, and if it’s possible, we should do that. But if not, then we can say, yeah, it’s not possible.
165 00:17:05.750 ⇒ 00:17:08.219 Mustafa Raja: Okay, yeah, I think,
166 00:17:08.369 ⇒ 00:17:15.230 Mustafa Raja: I think, what would happen is, after changing the topic, I’ll have to recreate the charts.
167 00:17:16.190 ⇒ 00:17:21.340 Mustafa Raja: And then… We’ll have to make sure that the data is all correct.
168 00:17:21.800 ⇒ 00:17:26.689 Mustafa Raja: After that. So yeah, it’s a… it’s a big stretch. It seems like a big stretch.
169 00:17:32.010 ⇒ 00:17:35.090 Awaish Kumar: To which thing is… which… where is it needed?
170 00:17:35.330 ⇒ 00:17:38.620 Mustafa Raja: I think it’s for the top… top 4 charts.
171 00:17:40.080 ⇒ 00:17:42.220 Mustafa Raja: Yeah, these four, I think…
172 00:17:43.720 ⇒ 00:17:49.450 Awaish Kumar: So, like, for this, I think it is possible, in a sense that this is just revenue data.
173 00:17:49.870 ⇒ 00:17:50.250 Mustafa Raja: And fun.
174 00:17:50.250 ⇒ 00:17:58.140 Awaish Kumar: We have a fun… for each order, we have a pharmacy information. We can divide our…
175 00:18:01.000 ⇒ 00:18:06.680 Awaish Kumar: Yeah, I don’t know, like, we have… I have to get the killer… It’s like the…
176 00:18:06.950 ⇒ 00:18:19.589 Awaish Kumar: killer requirements I need to get. Like, what is the… if I include the pharmacy in here, what is the definition of new order revenue and returning revenue? For example, this is… new order revenue and returning revenue depends on a user.
177 00:18:19.950 ⇒ 00:18:22.200 Awaish Kumar: So, if a user orders first time.
178 00:18:23.570 ⇒ 00:18:27.550 Awaish Kumar: That means a new user has come. Then it is a new order revenue.
179 00:18:28.140 ⇒ 00:18:28.840 Awaish Kumar: Oof.
180 00:18:29.190 ⇒ 00:18:34.920 Awaish Kumar: If the same user, is placing an order, Hmm…
181 00:18:35.590 ⇒ 00:18:41.209 Awaish Kumar: which has already done out of Eden, then he’s not a new user, it’s a returning revenue.
182 00:18:41.590 ⇒ 00:18:44.509 Awaish Kumar: For ETIN, because this user is already in the ETIN system.
183 00:18:46.620 ⇒ 00:18:47.430 Awaish Kumar: Okay.
184 00:18:47.620 ⇒ 00:19:01.510 Awaish Kumar: So once, we… we can, like, we already have a filter for that. In the, in the, for example, fake transaction, there is a filter. It’s first order. If it’s a first order, let’s say new order revenue, if it’s not a first order, there is a returning revenue.
185 00:19:01.640 ⇒ 00:19:08.059 Awaish Kumar: And then there is a pharmacy information attached to each order, you can figure out, okay, for the new… now, for the new user.
186 00:19:10.250 ⇒ 00:19:18.349 Awaish Kumar: how they were served, like, if there are 100 new users, then which pharmacist sends the orders to them, right? That’s how…
187 00:19:19.810 ⇒ 00:19:20.650 Mustafa Raja: Yeah.
188 00:19:21.160 ⇒ 00:19:27.320 Awaish Kumar: You can do that. That is one of the ways. If they want to mirror it like that, I don’t know if they want to mirror it like that, or…
189 00:19:27.720 ⇒ 00:19:35.220 Awaish Kumar: like, if you can explain this in writing to them, okay, this is what the definition looks like, and I can adjust this chart to include this.
190 00:19:35.450 ⇒ 00:19:37.239 Awaish Kumar: So it will clarify things.
191 00:19:37.850 ⇒ 00:19:49.280 Mustafa Raja: Okay, and if we scroll down, there’s going to be an expense chart. Do you think this total expenses could be broken down by… by pharmacy? I think this is coming from my ad spend, right?
192 00:19:50.940 ⇒ 00:19:53.879 Awaish Kumar: Is it a… yeah, that’s… yeah, this is coming from ads.
193 00:19:55.090 ⇒ 00:19:57.479 Mustafa Raja: Yeah, it’s been cogs, you know.
194 00:19:58.450 ⇒ 00:20:07.379 Awaish Kumar: Something… clearly not, like, COGS could be… could be done, right? COGS is, like, cost on goods supplied, so…
195 00:20:08.390 ⇒ 00:20:11.890 Awaish Kumar: If you are bringing in foreign product.
196 00:20:12.080 ⇒ 00:20:17.410 Awaish Kumar: Like, we have to see the data, if there is a pharmacy information.
197 00:20:17.640 ⇒ 00:20:23.459 Awaish Kumar: So, is it just connected to a product, or is it also connected to a pharmacy?
198 00:20:23.970 ⇒ 00:20:29.109 Awaish Kumar: But you can do that, because it is coming… still coming from order data. So for each order.
199 00:20:29.670 ⇒ 00:20:44.259 Awaish Kumar: we are going to figure out which product is ordered, right? And for that product, what is the cost? And then we have the pharmacy at order level, like, from which pharmacy this is coming from. So basically.
200 00:20:44.520 ⇒ 00:20:49.320 Awaish Kumar: We can do that, but for Edison, yeah, we can’t do that.
201 00:20:50.280 ⇒ 00:20:51.010 Mustafa Raja: Okay.
202 00:20:52.240 ⇒ 00:20:53.620 Awaish Kumar: Hi, Anton.
203 00:20:53.840 ⇒ 00:20:55.890 Uttam Kumaran: Hey guys, I’m just listening in.
204 00:20:55.970 ⇒ 00:21:00.379 Awaish Kumar: Yeah, we are… we’re just done with the stand-up, we are discussing one of the tickets on Eden.
205 00:21:00.960 ⇒ 00:21:04.310 Uttam Kumaran: Okay, okay, okay. Okay, no problem, I’ll, I’ll, I’ll drop.
206 00:21:05.030 ⇒ 00:21:05.660 Awaish Kumar: Okay.
207 00:21:05.910 ⇒ 00:21:06.580 Uttam Kumaran: Okay, thanks.
208 00:21:11.010 ⇒ 00:21:21.509 Mustafa Raja: Yeah, so, for this then, I, one thing that I exactly don’t know is, in the ticket, which charts are we referring to, you know?
209 00:21:21.860 ⇒ 00:21:24.969 Mustafa Raja: So maybe that’s going to be one question, and then…
210 00:21:25.730 ⇒ 00:21:32.129 Awaish Kumar: Yeah, but I want to… One, like, let’s clarify that, like…
211 00:21:34.290 ⇒ 00:21:41.449 Awaish Kumar: don’t jump… just jump to implementation. That’s one thing, right? If you get a request and you just…
212 00:21:41.590 ⇒ 00:21:46.319 Awaish Kumar: try to figure it out yourself. For these things, we can’t do that, like, we are…
213 00:21:46.840 ⇒ 00:21:50.919 Awaish Kumar: On an engineering side, you can do that, because if someone said, I need some
214 00:21:51.100 ⇒ 00:21:56.820 Awaish Kumar: sign-up page, right? You… we are going to go and figure out how do I build that page.
215 00:21:57.480 ⇒ 00:22:05.619 Awaish Kumar: And nobody’s going to question you, because you have to figure out you are an engineer. This is all business requirements. We have to get this from…
216 00:22:06.320 ⇒ 00:22:12.080 Awaish Kumar: for example, Greg, maybe, who is closer to the clients, or client himself.
217 00:22:12.700 ⇒ 00:22:13.450 Mustafa Raja: Nope.
218 00:22:13.680 ⇒ 00:22:25.650 Awaish Kumar: what the definition looks like. Do you want me to add in here? Do you want me to add in this? This includes added spend. I can’t divide ad spend by pharmacy, so it’s not possible to add it here.
219 00:22:25.650 ⇒ 00:22:26.410 Mustafa Raja: Okay.
220 00:22:28.320 ⇒ 00:22:33.989 Awaish Kumar: Same, like, this one, this here, it can be added, right? So, it just depends on where…
221 00:22:34.330 ⇒ 00:22:36.539 Awaish Kumar: It needs to be. And then.
222 00:22:37.150 ⇒ 00:22:43.370 Awaish Kumar: And we can say, like, this, for example, if it’s coming from same table, where the edition coming from? Okay, like, this is going to…
223 00:22:44.800 ⇒ 00:22:56.460 Awaish Kumar: break, right, the… So, for that, like, okay, we might have to build a new model, which includes Hmm…
224 00:22:56.620 ⇒ 00:23:05.180 Awaish Kumar: This breakdown, new order was written by pharmacies, and then we create a chart from that and include it in this dashboard.
225 00:23:05.980 ⇒ 00:23:09.959 Awaish Kumar: So I… I need this… all these details to actually…
226 00:23:10.780 ⇒ 00:23:24.090 Awaish Kumar: give you an answer on, okay, which table you can choose, what data you can use, how we can implement DBT model. Otherwise, I… yeah, it’s… it’s not… we don’t know how… what to do.
227 00:23:26.280 ⇒ 00:23:27.060 Mustafa Raja: Okay.
228 00:23:30.300 ⇒ 00:23:38.510 Awaish Kumar: Yeah, maybe you can just, yeah, write down all of these if you don’t know answer, then write down what we have discussed, and even ask Greg, like.
229 00:23:39.330 ⇒ 00:23:40.949 Awaish Kumar: Please clarify this.
230 00:23:41.570 ⇒ 00:23:44.089 Mustafa Raja: Okay. Yeah, I think that’s the way to go.
231 00:23:46.340 ⇒ 00:23:47.050 Awaish Kumar: Okay.
232 00:23:48.100 ⇒ 00:23:49.360 Awaish Kumar: That’s all.
233 00:23:49.630 ⇒ 00:23:51.020 Mustafa Raja: Yeah, thank you.
234 00:23:51.020 ⇒ 00:23:51.639 Awaish Kumar: Thank you.