Meeting Title: Eden | Standup Date: 2025-09-30 Meeting participants: Demilade Agboola, Henry Zhao, Amber Lin
WEBVTT
1 00:03:31.560 ⇒ 00:03:32.640 Demilade Agboola: Hi, Harry.
2 00:03:35.490 ⇒ 00:03:36.870 Henry Zhao: Hey Demilone, how’s it going?
3 00:03:37.510 ⇒ 00:03:42.690 Demilade Agboola: Pretty good. So for this cutout, then, I’m about to push a fix. I’ve seen where the…
4 00:03:42.850 ⇒ 00:03:44.970 Demilade Agboola: Error is coming from.
5 00:03:45.390 ⇒ 00:03:46.080 Henry Zhao: Okay.
6 00:03:46.670 ⇒ 00:03:53.420 Demilade Agboola: But… It will probably take me about 30 minutes to test it before pushing.
7 00:03:53.550 ⇒ 00:03:55.159 Henry Zhao: What was the error coming from?
8 00:03:56.640 ⇒ 00:04:01.939 Demilade Agboola: So, the new… From the int offline channel spend.
9 00:04:02.250 ⇒ 00:04:17.870 Demilade Agboola: That’s where the names are weird, or the new variant names are in. Now, since we’re joining them, it kind of is spreading it, so I need to standardize it in a way that it joins correctly to how we have things already set up previously.
10 00:04:18.750 ⇒ 00:04:26.649 Henry Zhao: Yeah, just to be clear, the CIO stuff built was not supposed to change anything else, so, like, the INT, whatever, shouldn’t have been joined to that one.
11 00:04:27.690 ⇒ 00:04:35.250 Demilade Agboola: Yeah, that is fair. I mean, it was fine before, but then the product name…
12 00:04:35.800 ⇒ 00:04:36.960 Henry Zhao: isn’t…
13 00:04:37.010 ⇒ 00:04:41.839 Demilade Agboola: the same… in the same format, but it’s fine, I will… I will do that now.
14 00:04:42.280 ⇒ 00:04:45.920 Henry Zhao: So, did you just basically revert the CIO one to the non-CIO one?
15 00:04:47.650 ⇒ 00:04:53.810 Demilade Agboola: No, actually, so what I’m trying to do now, and just… .
16 00:04:56.250 ⇒ 00:04:59.040 Henry Zhao: Yeah, it should be fixed if you just reverted to the non-CIO one, right?
17 00:04:59.760 ⇒ 00:05:07.619 Demilade Agboola: Yeah, it’s not necessarily about the CI one, it’s more about the source that is coming in right now.
18 00:05:08.200 ⇒ 00:05:15.260 Demilade Agboola: because we’re adding Catalyst in the app, I mean, the product name in Catalyst is quite different, so I need to standardize it.
19 00:05:16.120 ⇒ 00:05:17.600 Demilade Agboola: In a way, Dominique.
20 00:05:18.000 ⇒ 00:05:22.680 Demilade Agboola: That makes it match the… The way it was, and with how we do it here.
21 00:05:23.280 ⇒ 00:05:23.920 Henry Zhao: Okay.
22 00:05:26.120 ⇒ 00:05:30.630 Amber Lin: I… so sorry, I… it’s left over.
23 00:05:32.970 ⇒ 00:05:40.820 Amber Lin: Okay, I heard we need to standardize the names and catalysts. Is there a ticket for that?
24 00:05:42.550 ⇒ 00:05:48.380 Demilade Agboola: Not necessarily catalysts, but, there was a ticket, it’s for the cutter thing.
25 00:05:49.610 ⇒ 00:05:58.760 Demilade Agboola: I thought it was done. It is not, though I am trying to push the fix now.
26 00:06:00.500 ⇒ 00:06:02.899 Amber Lin: Okay, so I’ll update the pointing.
27 00:06:08.050 ⇒ 00:06:10.729 Amber Lin: Well, I’ll just… I can just make a…
28 00:06:11.380 ⇒ 00:06:13.220 Amber Lin: Extra one, what is it called?
29 00:06:14.130 ⇒ 00:06:16.020 Demilade Agboola: I mean, it’s technically still this…
30 00:06:16.170 ⇒ 00:06:18.289 Demilade Agboola: Oh, it’s still the same ticket, yeah.
31 00:06:18.410 ⇒ 00:06:20.810 Amber Lin: So I’ll just say it’s, 3 points.
32 00:06:21.690 ⇒ 00:06:22.310 Demilade Agboola: Dear.
33 00:06:22.620 ⇒ 00:06:23.420 Amber Lin: Okay.
34 00:06:28.340 ⇒ 00:06:37.619 Amber Lin: Alright, there was… This one that Brad asked for, how many points would that be?
35 00:06:42.990 ⇒ 00:06:45.470 Demilade Agboola: Alright, switching up, you know, the screen.
36 00:06:46.430 ⇒ 00:06:53.599 Demilade Agboola: Brad. Alright, so this is a modeling task, as well as a dashboard task, so they’re two different tickets.
37 00:06:53.610 ⇒ 00:06:55.330 Amber Lin: So for the modeling.
38 00:06:55.330 ⇒ 00:07:01.569 Demilade Agboola: part of this, I will… It should take me about one point or two. It’s not the…
39 00:07:04.450 ⇒ 00:07:05.890 Amber Lin: And they’re in the visual…
40 00:07:05.890 ⇒ 00:07:06.620 Demilade Agboola: real.
41 00:07:07.230 ⇒ 00:07:08.430 Amber Lin: Yes.
42 00:07:09.230 ⇒ 00:07:13.000 Demilade Agboola: I was just gonna say, since we, like, we want to be on the safer side, that’s just the two, like, over
43 00:07:13.320 ⇒ 00:07:14.659 Demilade Agboola: That’s a lot of students in here.
44 00:07:14.900 ⇒ 00:07:15.840 Demilade Agboola: It’s ginger.
45 00:07:16.450 ⇒ 00:07:22.070 Amber Lin: And then, how many points for the visualization, Harry, do you think?
46 00:07:25.770 ⇒ 00:07:27.260 Henry Zhao: Probably just one point.
47 00:07:27.570 ⇒ 00:07:28.390 Amber Lin: Okay.
48 00:07:30.830 ⇒ 00:07:43.210 Amber Lin: Alright, so today… Let’s see… so where’s here? Nope, I’ll check on his tickets in a bit.
49 00:07:48.500 ⇒ 00:07:52.950 Amber Lin: And so… Inc.
50 00:07:53.360 ⇒ 00:07:57.289 Amber Lin: Donna, you’re just working on these two today.
51 00:07:57.630 ⇒ 00:08:04.610 Henry Zhao: And Demolani, the SLA dash that we talked about last week, there will need to be some modeling, just giving you a heads up.
52 00:08:06.740 ⇒ 00:08:07.399 Amber Lin: Oh, this one’s.
53 00:08:07.400 ⇒ 00:08:08.430 Demilade Agboola: Just send, just send me.
54 00:08:08.750 ⇒ 00:08:09.330 Henry Zhao: Yeah.
55 00:08:09.460 ⇒ 00:08:11.480 Henry Zhao: But it should be pretty easy.
56 00:08:12.180 ⇒ 00:08:17.159 Demilade Agboola: Yeah, just… just… yeah, just let me know what that entails, and boom, you got it.
57 00:08:17.440 ⇒ 00:08:18.110 Henry Zhao: Nope, I will.
58 00:08:22.590 ⇒ 00:08:35.149 Amber Lin: When do you think the modeling for this would be done by? I know the SLA would be more of a priority for this. Is the SLA one ticketed out?
59 00:08:36.950 ⇒ 00:08:41.370 Demilade Agboola: I don’t believe so Henry just mentioned it now, so…
60 00:08:41.470 ⇒ 00:08:43.100 Demilade Agboola: I don’t know if the ticket’s fair.
61 00:08:43.100 ⇒ 00:08:47.360 Amber Lin: Let me just… Ticketing.
62 00:08:50.150 ⇒ 00:08:59.400 Demilade Agboola: Also, the noise… the noise you’re talking about, are you talking about the… I just… that’s just your comment. Are you talking about the pharmacy? Or, like, what nulls did you notice?
63 00:08:59.670 ⇒ 00:09:01.630 Demilade Agboola: Yeah, so that’s part of what I’ve been…
64 00:09:01.870 ⇒ 00:09:06.370 Demilade Agboola: I would have been… we have a ticket open for that. Basque has not been firing…
65 00:09:07.280 ⇒ 00:09:10.049 Demilade Agboola: Well, let me… so, Amber, this is for you to take notes.
66 00:09:11.020 ⇒ 00:09:18.830 Demilade Agboola: It’s one of our open tickets, and it’s one of the things that would affect us being able to go into SLA and pharmacy analytics.
67 00:09:19.630 ⇒ 00:09:25.680 Demilade Agboola: Busk fires orders to us, But in the orders that they fly to us, the pharmacies are known.
68 00:09:28.470 ⇒ 00:09:35.480 Demilade Agboola: The alternative to finding out what pharmacies the orders are being carried out is if we join into the products.
69 00:09:35.640 ⇒ 00:09:53.039 Demilade Agboola: And each product has, like, each variant of a product has the pharmacy they’re associated with, so we can use that to fill in the nulls. Again, which is when we ask for the product sheet, BASC doesn’t always respond. So we have two areas of failure from Basque. One is the API, which is not firing.
70 00:09:53.310 ⇒ 00:09:57.390 Demilade Agboola: In pharmacies, and two, is they don’t also send us the product information.
71 00:09:58.450 ⇒ 00:09:59.319 Henry Zhao: Can I ask a question?
72 00:09:59.320 ⇒ 00:09:59.990 Amber Lin: Hmm.
73 00:10:00.190 ⇒ 00:10:00.810 Demilade Agboola: Yeah.
74 00:10:01.230 ⇒ 00:10:09.659 Henry Zhao: Do you know by any chance, Demolade, what this orders report is? Like, what… if I can send this to BigQuery, or if we’re already sending it to BigQuery?
75 00:10:10.330 ⇒ 00:10:16.289 Demilade Agboola: No, we’re not… we’re not already signing to BigQuery. So this… the only way you can get these orders is if you manually export it.
76 00:10:16.780 ⇒ 00:10:17.250 Demilade Agboola: Thank you.
77 00:10:17.250 ⇒ 00:10:18.479 Henry Zhao: She was born and raised.
78 00:10:18.770 ⇒ 00:10:24.280 Demilade Agboola: Yeah, but they have… so Basque has APIs, 3 APIs. They have the order-completed API.
79 00:10:24.470 ⇒ 00:10:30.980 Demilade Agboola: they have the order shipped and the order updated. So, order updated is, like, lets you know what’s happening each step of the process.
80 00:10:30.980 ⇒ 00:10:31.380 Henry Zhao: this one?
81 00:10:31.380 ⇒ 00:10:32.040 Demilade Agboola: Right.
82 00:10:33.420 ⇒ 00:10:34.210 Demilade Agboola: Yeah.
83 00:10:34.330 ⇒ 00:10:35.580 Demilade Agboola: For some reason. So…
84 00:10:36.510 ⇒ 00:10:43.520 Demilade Agboola: they have 3 different APIs, so it… so this is what we’ve cleaned. So AutoSharm is built off of the different APIs.
85 00:10:44.240 ⇒ 00:10:58.020 Demilade Agboola: But effectively, all the different APIs, they’re not firing the pharmacy. At one point, I had to send this to Basque, and I pointed this out, like, 2 months ago, or maybe even 3 months ago, that
86 00:10:58.340 ⇒ 00:11:02.590 Demilade Agboola: In that particular month, about 80% of all orders, they fired to us.
87 00:11:02.760 ⇒ 00:11:18.909 Demilade Agboola: non-pharmacies. If it’s 1%, 2%, you can still get, you know, pretty good analytics out of it, but if 80% of your orders don’t have pharmacies associated with it, you can’t do any meaningful SLE analytics or any serious analytics about.
88 00:11:18.910 ⇒ 00:11:19.420 Henry Zhao: Yeah.
89 00:11:19.770 ⇒ 00:11:22.929 Demilade Agboola: But the drop-off in this data is from…
90 00:11:22.930 ⇒ 00:11:27.589 Henry Zhao: the Basque platform to BigQuery, or to the webhook? Like, where is that getting dropped?
91 00:11:27.590 ⇒ 00:11:35.429 Demilade Agboola: So the… the drop-off is from the webhook to us, but I don’t… so it’s either they’re not firing it in the webhook so we can’t receive it.
92 00:11:35.680 ⇒ 00:11:47.990 Demilade Agboola: But it’s not just there. We’re receiving the orders, but the orders don’t have any pharmacies, so it’s the webhook. But there’s a webhook ticket where I have specifically said we need pharmacy data. It’s one of our tickets here.
93 00:11:48.140 ⇒ 00:11:49.520 Demilade Agboola: And number two.
94 00:11:49.800 ⇒ 00:12:04.030 Demilade Agboola: And Zach took on us, so Zach is CEO, but Zach has taken ownership of that and said they are working on it, but it’s been months now, no response. Number two is the second point of failure is for each of the orders.
95 00:12:04.030 ⇒ 00:12:15.000 Demilade Agboola: they have a variant ID. If you tie it back to the products, the products, each variant ID is associated with the pharmacy. So we can go, okay, so this variant tied back to this variant.
96 00:12:15.260 ⇒ 00:12:22.439 Demilade Agboola: They can then associate the pharmacy and use it to at least fill that gap, but then they’re also inconsistent with when they send us
97 00:12:22.670 ⇒ 00:12:24.080 Demilade Agboola: product information.
98 00:12:24.390 ⇒ 00:12:25.160 Demilade Agboola: Cool.
99 00:12:25.450 ⇒ 00:12:27.630 Demilade Agboola: We have two points of failures, basically.
100 00:12:28.990 ⇒ 00:12:29.990 Henry Zhao: Got it.
101 00:12:33.350 ⇒ 00:12:38.100 Amber Lin: Gotcha. So, is the modeling task blocked?
102 00:12:39.630 ⇒ 00:12:48.229 Demilade Agboola: I mean, we could do the thing, but it wouldn’t be good analytics, I’ll be very honest with you. If you have so… if you have a large percentage of your orders missing pharmacy.
103 00:12:48.780 ⇒ 00:12:54.780 Demilade Agboola: data, it’s hard to then drill into the data and make conclusive evidence of, like, hey.
104 00:12:55.230 ⇒ 00:13:00.590 Demilade Agboola: you’re missing your SLAs, because we’re not seeing the others, like, a bulk of the others.
105 00:13:01.240 ⇒ 00:13:02.569 Demilade Agboola: the pharmacist.
106 00:13:05.300 ⇒ 00:13:12.439 Demilade Agboola: Like, it’s just non-pharmacies. We don’t know what pharmacies are, you know, performing good or bad, because there’s no pharmacy tag to it.
107 00:13:14.130 ⇒ 00:13:21.759 Amber Lin: I see. Harry, does this affect any other part of the dashboard, or is this the only thing remaining?
108 00:13:22.090 ⇒ 00:13:24.870 Henry Zhao: I’m just… I’m just trying to see if I can make them a macro.
109 00:13:24.920 ⇒ 00:13:29.849 Amber Lin: I have to pivot, right? So right now, I’m building it in Tableau, but I’m missing things, there’s things that are…
110 00:13:29.850 ⇒ 00:13:31.420 Henry Zhao: More complex than…
111 00:13:32.170 ⇒ 00:13:39.710 Henry Zhao: like, for example, they look at business days, so I need to, like, factor in holidays. That’s, like, just, like, one example of something that I didn’t expect.
112 00:13:40.310 ⇒ 00:13:42.009 Henry Zhao: So I can either do them like a…
113 00:13:42.570 ⇒ 00:13:44.989 Henry Zhao: Half-assed job, where it’s, like, just kind of good enough.
114 00:13:45.160 ⇒ 00:13:47.359 Henry Zhao: Or I’ll maybe make them a macro.
115 00:13:48.610 ⇒ 00:13:50.700 Henry Zhao: So they can click a button in Google Sheets.
116 00:13:50.830 ⇒ 00:13:54.820 Henry Zhao: So they export it still every day, but I click a button, and it does it for them.
117 00:13:56.100 ⇒ 00:14:01.879 Demilade Agboola: Amber, can we escalate this? Because this pharmacy thing, I’m pretty sure if you search, you can find it.
118 00:14:01.880 ⇒ 00:14:02.350 Amber Lin: Okay, so you have it.
119 00:14:02.350 ⇒ 00:14:10.240 Demilade Agboola: idea of how long it’s been going on. But this pharmacy thing has been on for a month. We need to escalate it. Wherever I need to get Josh involved.
120 00:14:10.460 ⇒ 00:14:12.869 Demilade Agboola: Like, can you help us find it? It’s…
121 00:14:13.780 ⇒ 00:14:15.770 Demilade Agboola: Yeah. There’s a ticker for it.
122 00:14:17.090 ⇒ 00:14:22.719 Amber Lin: Yeah, I… I think I know what it is. It’s… Is it this?
123 00:14:24.500 ⇒ 00:14:31.490 Demilade Agboola: Investigate… yes, can you click 675? Can you go into 675?
124 00:14:32.590 ⇒ 00:14:37.390 Demilade Agboola: Yeah, this is it. All pharmacies need to be updated with actual pharmacy names, yeah.
125 00:14:38.110 ⇒ 00:14:41.159 Demilade Agboola: this, I can’t remember where… so it’s no longer a low.
126 00:14:41.160 ⇒ 00:14:41.780 Amber Lin: That’s.
127 00:14:41.780 ⇒ 00:14:42.210 Demilade Agboola: this…
128 00:14:42.210 ⇒ 00:14:46.029 Amber Lin: This is when I… when we were building for Josh.
129 00:14:46.660 ⇒ 00:14:47.280 Amber Lin: And.
130 00:14:47.280 ⇒ 00:14:47.750 Demilade Agboola: Yes.
131 00:14:47.750 ⇒ 00:14:48.200 Amber Lin: That’s…
132 00:14:48.200 ⇒ 00:14:52.720 Demilade Agboola: So, can you see… I said we need… so if you… sorry, can you go into…
133 00:14:54.840 ⇒ 00:14:57.999 Demilade Agboola: Click it, you’ll see my investigation, and…
134 00:14:58.000 ⇒ 00:14:58.650 Amber Lin: Hmm.
135 00:15:01.960 ⇒ 00:15:05.290 Demilade Agboola: You see my investigation into it, and you can see what I said.
136 00:15:06.360 ⇒ 00:15:10.900 Demilade Agboola: Over 80% of orders, so it started getting really bad, if you look into that.
137 00:15:11.390 ⇒ 00:15:16.159 Demilade Agboola: So over 80% of orders We’re missing.
138 00:15:16.410 ⇒ 00:15:34.320 Demilade Agboola: like, missing pharmacy data. But before, like, months ago, it was, like, 1% of orders, which is fine. Like, you can… you can push for that, but 1% is still fine. You can make good analytics. But when we got to, like, 60-80% of all orders, like, we can’t do any… anything reasonable. And this has been… this has been mentioned months ago.
139 00:15:34.590 ⇒ 00:15:34.940 Amber Lin: That’s fair.
140 00:15:34.940 ⇒ 00:15:35.410 Demilade Agboola: sightless.
141 00:15:35.410 ⇒ 00:15:42.069 Amber Lin: And this is, right now, we’re at… what percentage are we at?
142 00:15:42.950 ⇒ 00:15:46.049 Demilade Agboola: I’ll need to rerun the query to find the exact percentage, but yeah.
143 00:15:53.660 ⇒ 00:15:59.130 Demilade Agboola: But 1%, 1-2% was, like, maybe 6 months ago, at the beginning of the year, but now it’s… it’s really bad.
144 00:16:08.220 ⇒ 00:16:15.330 Amber Lin: I’ll escalate that, I’ll assign the ticket to me. So, I would say your,
145 00:16:15.890 ⇒ 00:16:17.889 Amber Lin: Your modeling task is blocked.
146 00:16:18.450 ⇒ 00:16:19.290 Amber Lin: Right.
147 00:16:19.700 ⇒ 00:16:20.250 Amber Lin: Where this…
148 00:16:20.250 ⇒ 00:16:26.910 Demilade Agboola: I mean, we could always find ways around it, but it would always be slow and manual.
149 00:16:27.700 ⇒ 00:16:35.489 Demilade Agboola: The idea of why we’re using all these APIs is so that we can be, like, it’s automated, it’s fires, we have things going.
150 00:16:36.780 ⇒ 00:16:38.270 Amber Lin: Monthly.
151 00:16:38.770 ⇒ 00:16:43.059 Demilade Agboola: Right now, if we’re going to do it, we’ll probably have to rely on exports.
152 00:16:43.510 ⇒ 00:16:48.299 Demilade Agboola: And then, if we’re relying on exports, then what’s the point of the entire infrastructure we have built?
153 00:16:53.670 ⇒ 00:16:54.260 Demilade Agboola: Oh, dear.
154 00:16:54.260 ⇒ 00:16:58.500 Amber Lin: But Henry, you’re gonna go with the macro for now, right?
155 00:17:00.040 ⇒ 00:17:02.789 Amber Lin: If it’s delayed, they’re not gonna respond that fast.
156 00:17:02.970 ⇒ 00:17:03.710 Henry Zhao: Yeah
157 00:17:05.740 ⇒ 00:17:10.920 Henry Zhao: My other thought was to give them the order number so they can do a VLOOKUP, so that’s another option.
158 00:17:13.190 ⇒ 00:17:15.430 Henry Zhao: But that would need the modeling.
159 00:17:21.700 ⇒ 00:17:24.349 Demilade Agboola: I mean, for anyone, it’s fine, we could always do…
160 00:17:24.490 ⇒ 00:17:27.600 Demilade Agboola: Daily exports of orders and grids.
161 00:17:28.170 ⇒ 00:17:36.880 Demilade Agboola: a thing of the others and the pharmacists. Again, it’s not like it’s not doable. It is doable, it’s just…
162 00:17:37.480 ⇒ 00:17:39.120 Demilade Agboola: Far from efficient.
163 00:17:39.510 ⇒ 00:17:47.690 Demilade Agboola: We run the risk of things like duplicates and stuff like that if you’re not extremely careful with some things, especially when you’re exporting.
164 00:17:49.630 ⇒ 00:17:51.290 Demilade Agboola: item. Not pending.
165 00:17:52.170 ⇒ 00:17:52.940 Amber Lin: Gotcha.
166 00:17:54.110 ⇒ 00:17:55.880 Henry Zhao: I’ll add the requirements now in the…
167 00:17:58.310 ⇒ 00:17:59.020 Amber Lin: Okay.
168 00:18:17.840 ⇒ 00:18:25.730 Amber Lin: And then, I think, Karen, mostly I just want to clean up, your task with you, and then assign the deadlines.
169 00:18:26.090 ⇒ 00:18:28.999 Henry Zhao: Sorry, let me clean… let me give this to Melani first.
170 00:18:29.220 ⇒ 00:18:35.200 Amber Lin: Okay, and then, let’s put some due dates on these. We have…
171 00:18:37.050 ⇒ 00:18:39.170 Amber Lin: Have that for end of week.
172 00:18:39.610 ⇒ 00:18:41.519 Amber Lin: And I have…
173 00:18:41.930 ⇒ 00:18:51.019 Amber Lin: The two modeling tickets for Brad. When do you think which one would be done? I think this one needs to be done first? I don’t know.
174 00:18:53.790 ⇒ 00:18:57.440 Demilade Agboola: on… I see 8… sorry, 974.
175 00:18:58.420 ⇒ 00:19:01.929 Amber Lin: Well… 974 is the one we just added.
176 00:19:04.060 ⇒ 00:19:08.370 Demilade Agboola: I mean, we see the… like, what are the requirements?
177 00:19:10.270 ⇒ 00:19:12.309 Amber Lin: Henry’s adding them right now.
178 00:19:18.090 ⇒ 00:19:21.030 Demilade Agboola: So for this, we can set…
179 00:19:26.350 ⇒ 00:19:30.309 Demilade Agboola: I will say this one… I will need to confirm that there’s the…
180 00:19:32.120 ⇒ 00:19:35.710 Demilade Agboola: Do webhooks give us some of the data that
181 00:19:36.260 ⇒ 00:19:39.729 Demilade Agboola: Will be here, because the webhooks are not always automated.
182 00:19:40.100 ⇒ 00:19:43.520 Demilade Agboola: It gave us some of the data that you would see in the Basque plant.
183 00:19:44.490 ⇒ 00:19:51.750 Demilade Agboola: But, yeah, if everything is there, this should be… Gone today.
184 00:19:52.180 ⇒ 00:19:53.540 Demilade Agboola: Worst case, tomorrow.
185 00:19:56.670 ⇒ 00:19:57.330 Amber Lin: Okay.
186 00:19:57.860 ⇒ 00:20:01.559 Amber Lin: Mmm… We’ll aim for today, then.
187 00:20:01.990 ⇒ 00:20:04.060 Amber Lin: And then, what about this one?
188 00:20:04.480 ⇒ 00:20:06.009 Amber Lin: God’s request.
189 00:20:06.780 ⇒ 00:20:11.940 Demilade Agboola: So browse request, duplicate this. Yeah, this should be done by Stand Up tomorrow.
190 00:20:12.650 ⇒ 00:20:13.280 Amber Lin: Okay.
191 00:20:13.870 ⇒ 00:20:15.749 Demilade Agboola: I also just realize when I see things like…
192 00:20:15.940 ⇒ 00:20:18.379 Demilade Agboola: Today, I actually mean stand up tomorrow.
193 00:20:19.060 ⇒ 00:20:22.240 Amber Lin: Oh, okay. Makes sense, we’re on different dates.
194 00:20:22.700 ⇒ 00:20:23.520 Demilade Agboola: Yeah.
195 00:20:24.480 ⇒ 00:20:26.589 Amber Lin: Okay.
196 00:20:28.680 ⇒ 00:20:29.510 Amber Lin: Alright.
197 00:20:32.310 ⇒ 00:20:35.930 Amber Lin: And, Henry, are you ready?
198 00:20:36.680 ⇒ 00:20:37.939 Henry Zhao: One second, sorry, almost ready.
199 00:20:37.940 ⇒ 00:20:39.240 Amber Lin: Okay, sounds good.
200 00:20:42.520 ⇒ 00:20:43.679 Henry Zhao: Alright, now I’m ready.
201 00:20:44.530 ⇒ 00:20:50.479 Amber Lin: Alright, just looking at these…
202 00:20:50.850 ⇒ 00:20:57.569 Henry Zhao: Okay, I can go through each one of those. So, move PQ to dbt, Awash is approving the PR right now, he said he would look at it this morning.
203 00:20:57.750 ⇒ 00:20:58.170 Amber Lin: Okay.
204 00:20:58.170 ⇒ 00:21:00.720 Henry Zhao: Brad Katie, that’s the one we just talked about.
205 00:21:01.610 ⇒ 00:21:03.830 Henry Zhao: This one is…
206 00:21:03.970 ⇒ 00:21:11.430 Henry Zhao: I’m done on my end, I’m just waiting on their support to respond on how to clean the tables, but that’s pretty much it.
207 00:21:11.660 ⇒ 00:21:13.950 Henry Zhao: The data is now being sent.
208 00:21:14.080 ⇒ 00:21:18.289 Henry Zhao: This Adam one, I have a meeting with him today. I’m just gonna ask him some questions on that.
209 00:21:20.000 ⇒ 00:21:21.089 Henry Zhao: The Christina one…
210 00:21:21.090 ⇒ 00:21:22.819 Amber Lin: note the estimates yet.
211 00:21:22.820 ⇒ 00:21:23.839 Henry Zhao: No, not yet.
212 00:21:23.950 ⇒ 00:21:26.310 Henry Zhao: Because I have no idea what he even wants yet, so…
213 00:21:34.180 ⇒ 00:21:42.069 Amber Lin: You know, when we saw her response, seems like once they do it, we need to run it by Zora.
214 00:21:42.310 ⇒ 00:21:44.389 Amber Lin: So, we’ll just keep track.
215 00:21:46.080 ⇒ 00:21:48.039 Henry Zhao: Yeah, I have a meeting with him right after this.
216 00:21:48.370 ⇒ 00:21:49.440 Amber Lin: Oh, okay.
217 00:21:49.640 ⇒ 00:21:53.020 Henry Zhao: This one is done, I already answered his questions, so you can just mark that as done.
218 00:21:58.020 ⇒ 00:22:00.980 Henry Zhao: this… What’s this one again?
219 00:22:01.470 ⇒ 00:22:03.480 Henry Zhao: Just haven’t done that yet.
220 00:22:04.300 ⇒ 00:22:06.290 Henry Zhao: Oh yeah, it’s waiting on…
221 00:22:07.280 ⇒ 00:22:11.809 Henry Zhao: waiting on Zoran to put in real data, so that I can look at Catalyst data.
222 00:22:16.600 ⇒ 00:22:17.200 Henry Zhao: Yep.
223 00:22:17.200 ⇒ 00:22:23.869 Amber Lin: Do you think this is very high priority? Because I know they need to do the reconciliation.
224 00:22:24.460 ⇒ 00:22:27.449 Henry Zhao: They say it is, but if we miss one month, I don’t think it’s the end of the world.
225 00:22:28.080 ⇒ 00:22:28.760 Amber Lin: Okay.
226 00:22:29.250 ⇒ 00:22:32.809 Amber Lin: Do I have a ticket for that?
227 00:22:33.890 ⇒ 00:22:39.569 Henry Zhao: Yeah, it’s… it’s… all of these are blocked by that one ticket, pretty much. The…
228 00:22:40.550 ⇒ 00:22:43.910 Henry Zhao: Fill in… yeah, I fill in UTM tracking table and provide join key, basically.
229 00:22:44.610 ⇒ 00:22:45.440 Amber Lin: Okay.
230 00:22:47.250 ⇒ 00:22:49.200 Amber Lin: I’ll just say that’s urgent.
231 00:22:49.880 ⇒ 00:22:51.769 Amber Lin: Okay.
232 00:22:52.140 ⇒ 00:22:56.060 Henry Zhao: Okay, same thing, RSP stitching also happens with that.
233 00:22:56.060 ⇒ 00:22:59.149 Amber Lin: Is this and this the same thing?
234 00:22:59.740 ⇒ 00:23:04.509 Henry Zhao: No, that’s, like, 887’s after 8, 9, 30, so I would put 887 next cycle.
235 00:23:04.930 ⇒ 00:23:05.950 Amber Lin: Yeah, okay.
236 00:23:07.470 ⇒ 00:23:10.050 Henry Zhao: It’s probably actually cycle 19. That’s, like, the last step.
237 00:23:10.270 ⇒ 00:23:14.760 Henry Zhao: It’s, like, start attribution stitching, then it’s, like, testing and making the tables, and then it’s, like, cleanup, basically.
238 00:23:14.760 ⇒ 00:23:16.390 Amber Lin: Oh, okay.
239 00:23:17.730 ⇒ 00:23:21.249 Henry Zhao: Yeah. Okay, and then add new view for… what’s the Atom one?
240 00:23:22.340 ⇒ 00:23:26.470 Amber Lin: I feel like… like, he also has not asked for this.
241 00:23:26.960 ⇒ 00:23:32.579 Amber Lin: Oh, is there any… since we’re meeting with Adam, is there anything we need to clarify with…
242 00:23:32.810 ⇒ 00:23:41.210 Amber Lin: With Adam, I know we’re still doing the modeling here, like, demo, is there any questions you want to clarify with Adam?
243 00:23:43.620 ⇒ 00:23:46.080 Henry Zhao: I also don’t have too much time with Adam, so…
244 00:23:46.080 ⇒ 00:23:47.170 Amber Lin: Oh, I see.
245 00:23:47.170 ⇒ 00:23:47.740 Henry Zhao: Yep.
246 00:23:48.860 ⇒ 00:23:50.780 Henry Zhao: Because we’re mainly there to talk about attribution.
247 00:23:51.270 ⇒ 00:23:52.090 Amber Lin: Okay.
248 00:23:54.300 ⇒ 00:23:55.600 Amber Lin: Okay, let’s see.
249 00:23:55.600 ⇒ 00:23:58.080 Henry Zhao: I can always schedule a follow-up meeting afterwards, yeah, if we need.
250 00:23:59.250 ⇒ 00:24:03.029 Amber Lin: Feel like that, like… I… I will push out…
251 00:24:03.170 ⇒ 00:24:05.600 Amber Lin: Because we haven’t done the modeling yet.
252 00:24:05.600 ⇒ 00:24:07.600 Henry Zhao: Agreed, since we have a lot of stuff done this week, yeah.
253 00:24:07.600 ⇒ 00:24:08.270 Amber Lin: Yep.
254 00:24:08.650 ⇒ 00:24:13.450 Amber Lin: And then… Judd’s dashboard fixes…
255 00:24:13.450 ⇒ 00:24:16.530 Henry Zhao: Yeah, this one is just the first bullet point I need to fix, because of…
256 00:24:16.710 ⇒ 00:24:19.910 Henry Zhao: So, Demulata, you were able to break it down by date? It was not too hard?
257 00:24:21.200 ⇒ 00:24:22.810 Demilade Agboola: No, no, no, it wasn’t too hard.
258 00:24:23.140 ⇒ 00:24:26.870 Henry Zhao: Okay. Because sometimes when I have date and months mixed, it gets really messy.
259 00:24:27.240 ⇒ 00:24:27.970 Amber Lin: Hmm.
260 00:24:28.530 ⇒ 00:24:29.140 Henry Zhao: So…
261 00:24:29.210 ⇒ 00:24:31.320 Demilade Agboola: My credit is having you.
262 00:24:33.360 ⇒ 00:24:37.720 Henry Zhao: Yeah, some people think it’s just changing month to date, but it’s not, because then all the logic changes. Alright, anyway…
263 00:24:38.120 ⇒ 00:24:41.529 Amber Lin: That’s not here or there. Is this still 2 points?
264 00:24:41.860 ⇒ 00:24:43.499 Henry Zhao: Yeah, that should be pretty easy.
265 00:24:43.940 ⇒ 00:24:45.509 Henry Zhao: Based on reverse…
266 00:24:46.520 ⇒ 00:24:51.199 Henry Zhao: I’ll make it unblocked. Yeah, exactly, correct. Okay. And then the next one, I would move to…
267 00:24:51.610 ⇒ 00:24:55.370 Henry Zhao: So the final… no, yeah, that one, I would move to the next cycle.
268 00:24:55.840 ⇒ 00:24:58.599 Amber Lin: Yeah, Kazura hasn’t… isn’t done yet, right?
269 00:24:59.150 ⇒ 00:25:02.879 Henry Zhao: And because we need to put in segments. So, segment would be our control group.
270 00:25:03.030 ⇒ 00:25:08.320 Henry Zhao: So we want to also implement segment tracking, so we can compare segment and edge layer.
271 00:25:10.320 ⇒ 00:25:10.930 Henry Zhao: Yeah.
272 00:25:11.210 ⇒ 00:25:11.680 Amber Lin: I see.
273 00:25:11.990 ⇒ 00:25:13.099 Henry Zhao: Okay, so start dashboards.
274 00:25:13.100 ⇒ 00:25:13.870 Amber Lin: Mr. Shinks, yeah.
275 00:25:13.870 ⇒ 00:25:17.060 Henry Zhao: Okay, and then audit tableau dashes for affiliate spend, what is that?
276 00:25:18.630 ⇒ 00:25:21.489 Amber Lin: This is… A week ago.
277 00:25:21.850 ⇒ 00:25:23.950 Amber Lin: Product sales summary about transactions.
278 00:25:23.950 ⇒ 00:25:25.230 Henry Zhao: Oh yeah, this is… this is…
279 00:25:25.440 ⇒ 00:25:28.140 Henry Zhao: This is done because I made a different ticket for this.
280 00:25:28.880 ⇒ 00:25:30.650 Amber Lin: So I’ll choose my, I guess, too.
281 00:25:30.650 ⇒ 00:25:33.129 Henry Zhao: No, it’s done, because I had to audit it.
282 00:25:34.020 ⇒ 00:25:34.690 Amber Lin: Fuck.
283 00:25:35.340 ⇒ 00:25:36.070 Amber Lin: M.
284 00:25:37.800 ⇒ 00:25:39.120 Amber Lin: Cool.
285 00:25:39.720 ⇒ 00:25:43.189 Henry Zhao: Yeah, that’s true. It was last cycle, I guess. Alright.
286 00:25:44.480 ⇒ 00:25:53.290 Amber Lin: That one… oh, actually… This… I know that this is so long ago. This is…
287 00:25:53.760 ⇒ 00:25:56.120 Amber Lin: Do you think we should still do this?
288 00:25:57.560 ⇒ 00:25:58.990 Henry Zhao: Yeah, I can put it in next cycle.
289 00:25:59.850 ⇒ 00:26:00.390 Amber Lin: Okay.
290 00:26:00.770 ⇒ 00:26:02.609 Henry Zhao: I don’t know why it’s urgent, nobody has mentioned it.
291 00:26:02.610 ⇒ 00:26:11.620 Amber Lin: It’s not… Okay. Nobody has talked… Adam has not asked about it. That one, though.
292 00:26:12.760 ⇒ 00:26:14.579 Henry Zhao: Yeah, this one is done at just.
293 00:26:14.580 ⇒ 00:26:15.500 Amber Lin: Oh, okay.
294 00:26:15.910 ⇒ 00:26:19.739 Henry Zhao: No, it’s not done. Put it as blocks for now. There’s just one little tweak.
295 00:26:21.130 ⇒ 00:26:24.790 Henry Zhao: I need to make… after the modeling press is done.
296 00:26:24.790 ⇒ 00:26:25.350 Amber Lin: Hmm.
297 00:26:28.240 ⇒ 00:26:30.949 Henry Zhao: Yeah, Demolati just fixed the other issue, so…
298 00:26:32.410 ⇒ 00:26:34.610 Amber Lin: Is this the same ticket as the other one?
299 00:26:34.610 ⇒ 00:26:35.430 Henry Zhao: No.
300 00:26:35.990 ⇒ 00:26:39.850 Amber Lin: Oh, this is a complete neat dish. Oh…
301 00:26:42.920 ⇒ 00:26:44.399 Henry Zhao: This one I haven’t even looked at yet, so…
302 00:26:45.470 ⇒ 00:26:47.199 Henry Zhao: Just been so busy with other things.
303 00:26:47.350 ⇒ 00:26:48.879 Amber Lin: I see.
304 00:26:49.150 ⇒ 00:26:50.159 Amber Lin: I need to go and figure.
305 00:26:50.160 ⇒ 00:26:52.849 Henry Zhao: out what Annie did, and then try to make that for Catalysts.
306 00:27:03.120 ⇒ 00:27:07.220 Henry Zhao: That I haven’t done yet either, but I need to at least get it started today, so…
307 00:27:07.630 ⇒ 00:27:09.609 Amber Lin: Oh, I see, I see, okay.
308 00:27:10.010 ⇒ 00:27:16.840 Amber Lin: I was wondering if we can have it next week, but nope. Do you think this would be… let’s say end of this week?
309 00:27:16.840 ⇒ 00:27:20.669 Henry Zhao: It will get started this week, but then next week, it will bleed into next week for the cleaning part.
310 00:27:21.070 ⇒ 00:27:22.320 Amber Lin: Oh, okay.
311 00:27:22.760 ⇒ 00:27:25.210 Henry Zhao: The cleaning and enforcement, basically.
312 00:27:25.210 ⇒ 00:27:27.970 Amber Lin: Let’s just make a different ticket.
313 00:27:28.120 ⇒ 00:27:28.760 Henry Zhao: Okay.
314 00:27:29.010 ⇒ 00:27:29.560 Amber Lin: Yes.
315 00:27:31.380 ⇒ 00:27:34.670 Henry Zhao: The template itself, yeah. So monitor, yeah.
316 00:27:34.970 ⇒ 00:27:39.940 Henry Zhao: Monitor, adherence to… UTM Clinic.
317 00:27:40.140 ⇒ 00:27:41.010 Henry Zhao: Let’s a template.
318 00:27:43.260 ⇒ 00:27:44.660 Henry Zhao: And clean, yeah.
319 00:27:46.740 ⇒ 00:27:49.830 Henry Zhao: So that would be the 3 points, and then this one is really just one point.
320 00:27:51.300 ⇒ 00:27:52.110 Amber Lin: Sounds good.
321 00:27:52.470 ⇒ 00:27:58.090 Amber Lin: So, I’ll have this… That’s the next cycle…
322 00:28:02.120 ⇒ 00:28:05.870 Henry Zhao: Yeah, this makes more sense, actually, because I need to finish this, and then marketing needs to…
323 00:28:06.430 ⇒ 00:28:07.180 Amber Lin: actually do…
324 00:28:07.180 ⇒ 00:28:07.579 Henry Zhao: And then we…
325 00:28:07.580 ⇒ 00:28:09.010 Amber Lin: We will… okay.
326 00:28:10.270 ⇒ 00:28:11.270 Amber Lin: Oh, patient.
327 00:28:15.210 ⇒ 00:28:27.130 Amber Lin: There we have… These… Oh, we talked about that… Do… We can’t do that yet.
328 00:28:28.100 ⇒ 00:28:32.110 Amber Lin: And so…
329 00:28:32.110 ⇒ 00:28:34.360 Henry Zhao: This… I need to talk to Zoran about.
330 00:28:40.510 ⇒ 00:28:41.630 Amber Lin: Yeah.
331 00:28:42.490 ⇒ 00:28:43.899 Henry Zhao: We can put this as in progress.
332 00:28:44.560 ⇒ 00:28:46.160 Henry Zhao: Cause I’m about to meet up with him in one minute.
333 00:28:46.610 ⇒ 00:28:47.440 Amber Lin: Okay.
334 00:28:47.650 ⇒ 00:28:55.450 Amber Lin: And then, this is from Robert. So this is from a while ago. Robert was like, I…
335 00:28:56.060 ⇒ 00:28:59.610 Amber Lin: Like, not clear what data’s coming from, like this thread.
336 00:29:00.450 ⇒ 00:29:03.290 Henry Zhao: Okay, this… you can put it as in progress, and maybe just push it to next week.
337 00:29:05.720 ⇒ 00:29:07.990 Amber Lin: Yeah, this is more of an internal task.
338 00:29:07.990 ⇒ 00:29:08.550 Henry Zhao: Yeah.
339 00:29:08.840 ⇒ 00:29:16.080 Amber Lin: So… Still feel like you have a lot this cycle.
340 00:29:17.480 ⇒ 00:29:23.259 Amber Lin: Phil, let’s see… Blocked. Some things will get unblocked.
341 00:29:23.480 ⇒ 00:29:27.209 Amber Lin: Okay Okay, doesn’t look that bad anymore.
342 00:29:27.410 ⇒ 00:29:28.360 Henry Zhao: Yeah.
343 00:29:28.360 ⇒ 00:29:34.499 Amber Lin: Alright, sounds good, that’s all. We’re at time, so we can… we can hop off.
344 00:29:35.020 ⇒ 00:29:36.779 Amber Lin: And then we’ll see you guys tomorrow.
345 00:29:37.060 ⇒ 00:29:38.440 Henry Zhao: See ya, see you guys tomorrow.
346 00:29:38.440 ⇒ 00:29:41.029 Amber Lin: Bye, I’ll escalate the pharmacy issue.
347 00:29:41.630 ⇒ 00:29:42.520 Henry Zhao: Okay, thanks.
348 00:29:42.520 ⇒ 00:29:43.710 Amber Lin: Alright, bye.
349 00:29:44.340 ⇒ 00:29:45.590 Demilade Agboola: Thank you, bye.