Meeting Title: Refill Data Analysis Sync Date: 2025-12-16 Meeting participants: Sezim Zhenishbekova, Henry Zhao
WEBVTT
1 00:02:16.990 ⇒ 00:02:18.000 Henry Zhao: Hi, Seism.
2 00:02:18.750 ⇒ 00:02:19.840 Sezim Zhenishbekova: Hi, how are you?
3 00:02:19.840 ⇒ 00:02:20.930 Henry Zhao: Are you home already?
4 00:02:22.630 ⇒ 00:02:25.879 Sezim Zhenishbekova: Can you… just a second, let me connect my headphones.
5 00:02:35.380 ⇒ 00:02:36.150 Sezim Zhenishbekova: Okay.
6 00:02:36.680 ⇒ 00:02:37.820 Sezim Zhenishbekova: Welcome back to the…
7 00:02:43.850 ⇒ 00:02:55.930 Henry Zhao: That’s figured out here. So, I’m just gonna do a form of data… Go to filter… Status…
8 00:02:57.330 ⇒ 00:02:58.980 Henry Zhao: Pause, see how many we have.
9 00:02:59.750 ⇒ 00:03:00.800 Henry Zhao: Geez.
10 00:03:02.750 ⇒ 00:03:04.330 Sezim Zhenishbekova: I hear you’re pretty good.
11 00:03:05.080 ⇒ 00:03:10.419 Henry Zhao: 240? Wait… Well, I guess that is 2%. Okay. Makes sense then.
12 00:03:10.420 ⇒ 00:03:11.959 Sezim Zhenishbekova: Can you hear me now?
13 00:03:13.570 ⇒ 00:03:14.419 Henry Zhao: Yeah, can you hear me?
14 00:03:14.420 ⇒ 00:03:16.640 Sezim Zhenishbekova: Okay, okay, I can hear you now, okay.
15 00:03:16.660 ⇒ 00:03:19.330 Henry Zhao: Wow, 240 is a lot more than I thought.
16 00:03:21.250 ⇒ 00:03:29.519 Henry Zhao: Alright, so actually… I can pull this for you real quick, is what I just realized, so… Mask, order…
17 00:03:30.370 ⇒ 00:03:36.909 Henry Zhao: A mask treatment… Updated… Treatment updated.
18 00:03:37.420 ⇒ 00:03:42.540 Henry Zhao: Where… status equals… pending.
19 00:03:46.130 ⇒ 00:03:47.310 Henry Zhao: What did Bobby say?
20 00:03:55.090 ⇒ 00:03:58.770 Henry Zhao: Update with status if to pause. Status to pause.
21 00:03:59.550 ⇒ 00:04:00.830 Henry Zhao: Not pending. Pot.
22 00:04:01.890 ⇒ 00:04:02.550 Sezim Zhenishbekova: Yes.
23 00:04:03.260 ⇒ 00:04:08.540 Henry Zhao: So I want each treatment ID, I want to see the first time they did it.
24 00:04:09.340 ⇒ 00:04:10.840 Henry Zhao: When the last time they did it.
25 00:04:12.490 ⇒ 00:04:16.240 Henry Zhao: Okay, and then… What is there?
26 00:04:18.649 ⇒ 00:04:20.329 Henry Zhao: stream ID in.
27 00:04:23.070 ⇒ 00:04:24.440 Henry Zhao: Just gotta do this one second
28 00:04:27.760 ⇒ 00:04:30.030 Henry Zhao: Some SQL magic here…
29 00:04:31.610 ⇒ 00:04:32.780 Henry Zhao: A1…
30 00:04:37.600 ⇒ 00:04:40.159 Henry Zhao: Grab all 240 of these and look at them.
31 00:04:40.980 ⇒ 00:04:45.700 Henry Zhao: Gee, what the… It’s on the first column.
32 00:04:49.720 ⇒ 00:04:51.129 Henry Zhao: Group by one.
33 00:04:51.760 ⇒ 00:04:55.880 Henry Zhao: Order by… 2? Alright.
34 00:04:59.030 ⇒ 00:05:05.520 Henry Zhao: So… A lot of these paws that… Before December.
35 00:05:07.790 ⇒ 00:05:08.710 Henry Zhao: So…
36 00:05:10.910 ⇒ 00:05:20.310 Henry Zhao: So yeah, we can say that this is people that, if they unpause, they would be getting the refill, but they didn’t necessarily pause it in December, okay? That’s the answer.
37 00:05:21.900 ⇒ 00:05:23.560 Henry Zhao: Make sense? I’m looking at the first.
38 00:05:23.560 ⇒ 00:05:24.639 Sezim Zhenishbekova: Can you repeat it?
39 00:05:24.860 ⇒ 00:05:31.120 Henry Zhao: Yeah, so I just looked at each treatment ID, like, when did they pause it the earliest, and when did they pause it the latest?
40 00:05:31.620 ⇒ 00:05:36.669 Henry Zhao: The fact that we have stuff from, like, much earlier means that if they…
41 00:05:37.320 ⇒ 00:05:40.810 Henry Zhao: had unpaused it now, they would have gotten the refill in January.
42 00:05:43.340 ⇒ 00:05:45.579 Henry Zhao: Not necessarily that they paused it now.
43 00:05:47.250 ⇒ 00:05:52.730 Sezim Zhenishbekova: So, it’s like… So, if they passed it.
44 00:05:53.220 ⇒ 00:05:56.790 Sezim Zhenishbekova: just now, it means that they wouldn’t get the refill in January.
45 00:05:58.210 ⇒ 00:06:00.889 Henry Zhao: None of these guys are gonna get in January, because they’re paused, I think.
46 00:06:00.890 ⇒ 00:06:01.959 Sezim Zhenishbekova: Okay, okay.
47 00:06:01.960 ⇒ 00:06:04.399 Henry Zhao: Because we grabbed anyone that’s paused, right?
48 00:06:04.400 ⇒ 00:06:09.039 Sezim Zhenishbekova: Yeah, like, I tried to figure out, like, who decides that it’s passed or not.
49 00:06:09.330 ⇒ 00:06:10.609 Henry Zhao: Oh, that doesn’t matter.
50 00:06:10.610 ⇒ 00:06:11.430 Sezim Zhenishbekova: Yeah.
51 00:06:11.640 ⇒ 00:06:18.000 Henry Zhao: I think either one composite. So, like, the pharmacy composite, the user… the customer composite, doesn’t matter. So let’s just check one.
52 00:06:18.180 ⇒ 00:06:19.610 Henry Zhao: Look what the history looks like.
53 00:06:19.740 ⇒ 00:06:26.760 Henry Zhao: So this one paused in June, so we want to maybe see… Hello.
54 00:06:29.400 ⇒ 00:06:32.690 Henry Zhao: They got a bunch of stuff until June, and then they paused it.
55 00:06:32.860 ⇒ 00:06:34.379 Henry Zhao: But it’s not done, so…
56 00:06:37.130 ⇒ 00:06:41.769 Sezim Zhenishbekova: But it’s also only 2%, so I was like, it’s probably not big of a…
57 00:06:41.770 ⇒ 00:06:42.260 Henry Zhao: Yeah, that’s.
58 00:06:42.260 ⇒ 00:06:43.549 Sezim Zhenishbekova: So, anyways…
59 00:06:43.550 ⇒ 00:06:47.379 Henry Zhao: So this confirms it. It was delivered in June, they paused it, great. Okay.
60 00:06:47.980 ⇒ 00:06:52.850 Sezim Zhenishbekova: It was delivered in June, and they paused it, and still unpaused yet, right?
61 00:06:52.850 ⇒ 00:06:57.050 Henry Zhao: Not paused. So yeah, you can say that these are people that are paused.
62 00:06:57.470 ⇒ 00:06:59.200 Henry Zhao: From any, from any time?
63 00:06:59.980 ⇒ 00:07:02.420 Henry Zhao: But if they unpause, they would get a refill in January.
64 00:07:04.240 ⇒ 00:07:05.089 Henry Zhao: Make sense?
65 00:07:05.090 ⇒ 00:07:05.680 Sezim Zhenishbekova: Yeah.
66 00:07:06.810 ⇒ 00:07:08.000 Henry Zhao: That’s it, and you’re done.
67 00:07:08.000 ⇒ 00:07:08.480 Sezim Zhenishbekova: Yeah.
68 00:07:08.770 ⇒ 00:07:11.519 Henry Zhao: Yeah. You have the chart,
69 00:07:12.430 ⇒ 00:07:14.270 Henry Zhao: I think you’re ready to send those numbers.
70 00:07:14.980 ⇒ 00:07:27.319 Sezim Zhenishbekova: So basically, right now, I need to just predict based on… so right now, I just sorted and created the pivot tables where, I sort if the refill rates are legit and what’s the status.
71 00:07:27.610 ⇒ 00:07:33.610 Sezim Zhenishbekova: And then based on those logics, I rely on the January months, I feel.
72 00:07:34.660 ⇒ 00:07:46.459 Henry Zhao: Yeah, just that pie chart you gave, as long as it adds up to 9,800 or whatever. So we expect 9,800 refills in January, and then those percentages of payment error, paused, etc.
73 00:07:46.990 ⇒ 00:07:50.149 Sezim Zhenishbekova: Is that it? Like, I said… okay. Okay.
74 00:07:50.380 ⇒ 00:07:54.570 Henry Zhao: Yep. Because remember, we’ve validated that nothing else really matters right now.
75 00:07:54.570 ⇒ 00:07:55.810 Sezim Zhenishbekova: Yeah, okay.
76 00:07:56.100 ⇒ 00:07:57.730 Sezim Zhenishbekova: Perfect, then.
77 00:07:57.730 ⇒ 00:08:02.760 Henry Zhao: So you can email it to Mitesh, and just copy Robert and Mignie.
78 00:08:02.760 ⇒ 00:08:06.879 Sezim Zhenishbekova: Yeah. Can you please also send Mitesh’s email? Because I don’t have it.
79 00:08:06.880 ⇒ 00:08:07.930 Henry Zhao: Send it to you in Slack.
80 00:08:08.150 ⇒ 00:08:08.760 Sezim Zhenishbekova: Yes.
81 00:08:09.210 ⇒ 00:08:09.710 Henry Zhao: Okay.
82 00:08:10.130 ⇒ 00:08:10.909 Sezim Zhenishbekova: Thank you.
83 00:08:11.140 ⇒ 00:08:11.830 Henry Zhao: Perfect.
84 00:08:11.830 ⇒ 00:08:13.739 Sezim Zhenishbekova: Right, cognate it.
85 00:08:13.740 ⇒ 00:08:14.360 Henry Zhao: Me too.