Meeting Title: Brainforge x BASC Data Analysis Sync Date: 2025-12-16 Meeting participants: Sezim Zhenishbekova, Henry Zhao, Demilade Agboola
WEBVTT
1 00:00:06.860 ⇒ 00:00:08.490 Henry Zhao: I’ve asked Emilan if he can join us.
2 00:00:09.280 ⇒ 00:00:11.680 Henry Zhao: Can you send the link? I can send it to him, I have the link.
3 00:00:11.680 ⇒ 00:00:12.250 Sezim Zhenishbekova: Okay.
4 00:01:12.290 ⇒ 00:01:20.090 Sezim Zhenishbekova: Do you… do you have Brainforge access to the cursor, or should I… should I just open my own?
5 00:01:20.090 ⇒ 00:01:20.890 Henry Zhao: It’s free.
6 00:01:20.890 ⇒ 00:01:21.690 Sezim Zhenishbekova: Okay.
7 00:02:06.850 ⇒ 00:02:10.070 Sezim Zhenishbekova: So, here I should choose to continue.
8 00:02:11.150 ⇒ 00:02:13.790 Henry Zhao: Let’s see, yes.
9 00:02:20.810 ⇒ 00:02:22.490 Henry Zhao: Do you have access to GitHub?
10 00:02:23.100 ⇒ 00:02:23.640 Sezim Zhenishbekova: No.
11 00:02:24.300 ⇒ 00:02:28.180 Henry Zhao: Okay. I think I’ll just give you the link, that way you can just have it.
12 00:02:30.970 ⇒ 00:02:33.100 Henry Zhao: I wonder if I can do it that way…
13 00:02:33.540 ⇒ 00:02:37.590 Henry Zhao: Is there any bad consequence of me doing that? I think…
14 00:02:40.360 ⇒ 00:02:43.979 Sezim Zhenishbekova: I can check if I have one password.
15 00:02:49.620 ⇒ 00:02:51.709 Henry Zhao: Hi, this link for clone repo.
16 00:02:51.710 ⇒ 00:02:53.230 Sezim Zhenishbekova: I have superbase.
17 00:02:57.880 ⇒ 00:02:59.409 Henry Zhao: Do you have a GitHub account at all?
18 00:03:01.970 ⇒ 00:03:03.130 Sezim Zhenishbekova: Not sure.
19 00:03:03.650 ⇒ 00:03:06.160 Henry Zhao: Okay, you can create one on your own time.
20 00:03:07.450 ⇒ 00:03:08.280 Sezim Zhenishbekova: Yeah,
21 00:03:08.280 ⇒ 00:03:12.489 Henry Zhao: Create one, but then for now, just take the link that I sent you in Slack and just see if that works.
22 00:03:15.590 ⇒ 00:03:20.119 Henry Zhao: Yeah, just copy it, and then… Go to cursor again…
23 00:03:21.050 ⇒ 00:03:26.309 Henry Zhao: No, no, no, so you don’t want to go that in online, because you don’t have access. Of course, you can do a clone repo.
24 00:03:26.940 ⇒ 00:03:30.459 Henry Zhao: And then… copy, paste, yep, clone from URL.
25 00:03:32.500 ⇒ 00:03:34.130 Henry Zhao: Put it some… anywhere you want.
26 00:03:35.080 ⇒ 00:03:37.739 Henry Zhao: I put it somewhere, like, work designated.
27 00:03:37.930 ⇒ 00:03:38.560 Henry Zhao: Like, I wouldn’t.
28 00:03:38.560 ⇒ 00:03:38.900 Sezim Zhenishbekova: Where?
29 00:03:38.900 ⇒ 00:03:40.720 Henry Zhao: my personal…
30 00:03:40.720 ⇒ 00:03:41.450 Sezim Zhenishbekova: dear.
31 00:03:44.540 ⇒ 00:03:46.799 Henry Zhao: Yeah, you can just do select as repository destination.
32 00:03:47.420 ⇒ 00:03:48.399 Sezim Zhenishbekova: Yeah, and you’re… I just…
33 00:03:48.400 ⇒ 00:03:49.890 Henry Zhao: No, no, no, no, you don’t have to do that.
34 00:03:50.630 ⇒ 00:03:52.419 Sezim Zhenishbekova: I’ll just write here, it seems to me.
35 00:03:52.970 ⇒ 00:03:53.600 Henry Zhao: Okay.
36 00:03:54.860 ⇒ 00:03:56.110 Henry Zhao: Yeah, okay, that’s fine.
37 00:03:56.320 ⇒ 00:03:58.199 Henry Zhao: But it’ll create another folder inside there.
38 00:03:58.520 ⇒ 00:04:00.780 Henry Zhao: So do you allow? Oh, you do need to sign in.
39 00:04:01.850 ⇒ 00:04:03.110 Henry Zhao: Okay, that’s why.
40 00:04:03.640 ⇒ 00:04:04.949 Henry Zhao: You can do a low, I guess.
41 00:04:08.100 ⇒ 00:04:09.230 Sezim Zhenishbekova: I can’t find out.
42 00:04:09.230 ⇒ 00:04:09.960 Henry Zhao: Thanks for that.
43 00:04:29.110 ⇒ 00:04:30.530 Henry Zhao: And that’s the code you got?
44 00:05:09.530 ⇒ 00:05:11.150 Sezim Zhenishbekova: sheet…
45 00:05:20.140 ⇒ 00:05:21.640 Sezim Zhenishbekova: Okay,
46 00:05:21.830 ⇒ 00:05:22.920 Sezim Zhenishbekova: What’s going on?
47 00:05:28.010 ⇒ 00:05:30.080 Henry Zhao: I’m only seeing your GitHub screen.
48 00:05:30.720 ⇒ 00:05:31.320 Sezim Zhenishbekova: Huh?
49 00:05:31.470 ⇒ 00:05:34.400 Henry Zhao: I’m only seeing your GitHub screen, I don’t know if you’re looking at something else.
50 00:05:35.160 ⇒ 00:05:39.030 Sezim Zhenishbekova: Yeah, I’m checking on my phone for the notification, but…
51 00:05:39.030 ⇒ 00:05:41.149 Henry Zhao: I think it’s the one you just got in the cursor.
52 00:05:41.970 ⇒ 00:05:42.850 Henry Zhao: Is it not?
53 00:05:43.750 ⇒ 00:05:45.350 Henry Zhao: I thought it was an 8-digit code.
54 00:05:47.200 ⇒ 00:05:49.550 Henry Zhao: That one, 8CEB7273.
55 00:05:50.500 ⇒ 00:05:51.160 Sezim Zhenishbekova: Right.
56 00:05:52.950 ⇒ 00:05:53.710 Henry Zhao: I think.
57 00:05:54.510 ⇒ 00:05:55.960 Henry Zhao: Seems right in the digits.
58 00:05:55.960 ⇒ 00:05:58.669 Sezim Zhenishbekova: Because it’s not like cloud… ugh.
59 00:05:58.670 ⇒ 00:06:00.269 Demilade Agboola: Hi, Henry, how he says him.
60 00:06:00.700 ⇒ 00:06:01.580 Sezim Zhenishbekova: Hi, dear.
61 00:06:01.580 ⇒ 00:06:02.340 Henry Zhao: buddy.
62 00:06:03.000 ⇒ 00:06:06.979 Henry Zhao: We’re really confused about refills. I was hoping you might have more knowledge than we do.
63 00:06:07.460 ⇒ 00:06:13.649 Henry Zhao: Okay, so, first things first, basket is a mess. That’s the first thing you need to…
64 00:06:13.650 ⇒ 00:06:15.550 Demilade Agboola: we figured out, so…
65 00:06:15.550 ⇒ 00:06:16.549 Sezim Zhenishbekova: Oh my goodness!
66 00:06:17.110 ⇒ 00:06:20.160 Demilade Agboola: Yeah, ideally…
67 00:06:20.340 ⇒ 00:06:36.899 Demilade Agboola: the future refills should not be zero. Like, refills should not be zero, and there should be a future refill. However, it does occur that way. Potentially, this is something we could throw to Zach Bask.
68 00:06:36.940 ⇒ 00:06:38.609 Henry Zhao: Because the way I just, like.
69 00:06:38.610 ⇒ 00:06:44.740 Demilade Agboola: do the queries when they ask, like, oh, we’re trying to figure out future refills, is I just do refills greater than zero.
70 00:06:45.640 ⇒ 00:06:46.340 Demilade Agboola: Right.
71 00:06:46.340 ⇒ 00:06:49.300 Henry Zhao: Let me share my screen to show you why I’m confused, okay?
72 00:06:49.300 ⇒ 00:06:50.000 Demilade Agboola: Okay.
73 00:06:50.000 ⇒ 00:07:00.680 Henry Zhao: Okay, so… I have a few queries to kind of figure out what’s going on, right? I just want to know how many refills do we forecast for next month, okay?
74 00:07:00.740 ⇒ 00:07:11.389 Henry Zhao: So, I just want to get a gut check first to see, like, is it 2,000, is it 10,000, is it 20,000? Like, what is the gut check, right? So I ran this query first. Which one did I run first?
75 00:07:12.120 ⇒ 00:07:13.570 Henry Zhao: Oh, no, I deleted it.
76 00:07:16.830 ⇒ 00:07:18.480 Henry Zhao: Come in here. Nope.
77 00:07:19.620 ⇒ 00:07:34.319 Henry Zhao: I ran this one first, right? So, I just looked at it historically, like, shipped date by month, how many people got a refill, in order summary, where transaction row number is 1, and it’s a refill order, and I looked at before today.
78 00:07:34.370 ⇒ 00:07:37.440 Sezim Zhenishbekova: Oh yeah, okay, just a sec, okay, go ahead.
79 00:07:37.600 ⇒ 00:07:44.549 Henry Zhao: So I wanted to look at, like, what I expect for, like, refills in January, and it looks like we’re on track to get, like, 15, 16, 17K, right?
80 00:07:45.410 ⇒ 00:07:47.739 Henry Zhao: That’s, like, kind of where we’re trending in terms of refill orders.
81 00:07:49.040 ⇒ 00:07:53.199 Demilade Agboola: Is refill order…
82 00:08:01.660 ⇒ 00:08:08.960 Demilade Agboola: Like, so you’re just basically… you’re basically using, like, the historic orders to get an idea of what refill orders will look like in the upcoming month, basically.
83 00:08:09.240 ⇒ 00:08:26.580 Henry Zhao: Just looking at the trend to first see, like, is it gut checking? Like, it makes… making sense. So then what I did was I pulled what I thought was, like, just take treatment updated, right? Look at next payment date, because we realized there was, like, hair loss kits which shouldn’t be getting refills.
84 00:08:26.730 ⇒ 00:08:31.519 Henry Zhao: So my initial query was this. My initial query was this.
85 00:08:31.740 ⇒ 00:08:36.339 Henry Zhao: It was next shipping date, Equals 26, 21.
86 00:08:38.720 ⇒ 00:08:53.109 Henry Zhao: My initial query was this, next shipping date, which you said is the table that you use, right? It’s January 2026. I didn’t have this either, because I didn’t think that mattered. And what we got was this sheet.
87 00:08:59.890 ⇒ 00:09:02.570 Henry Zhao: We got what makes sense. It was 11,000 rows.
88 00:09:03.460 ⇒ 00:09:12.640 Henry Zhao: So it made sense, but then we were like, let’s check these, okay? So some of these made a lot of sense. So this one, like, 7 remaining refills, monthly, it made a lot of sense. They had, like…
89 00:09:12.780 ⇒ 00:09:19.510 Henry Zhao: a few months of refills already, and then the next one is next month. Perfect, okay? Then we looked at one where it said remaining refills is zero.
90 00:09:22.530 ⇒ 00:09:34.590 Henry Zhao: And that one didn’t make sense. Well, actually, I think this one did make sense, because there was dose 3 of 5, and they were gonna get dose 6 next month. And we did see that BASC broke it down into 6 different, treatments, even though.
91 00:09:34.590 ⇒ 00:09:34.910 Demilade Agboola: Okay.
92 00:09:34.910 ⇒ 00:09:36.660 Henry Zhao: Treatment with 6 doses, right?
93 00:09:36.930 ⇒ 00:09:54.380 Henry Zhao: Then we were like, what are these negative ones? Like, do we include those? And we also wondered, why is this… there were some that were canceled, like, this one was canceled, and that was it, but it’s still saying there’s a next shipping date of January 1st, 2026, so we’re like, do we include these? And then there’s these completed ones with zero, and it’s a weight loss kit.
94 00:09:55.240 ⇒ 00:09:59.600 Henry Zhao: Like, why is this having a, like, next shipping date of January 2026?
95 00:10:00.830 ⇒ 00:10:03.630 Henry Zhao: Not to mention, this is quarterly… so quarterly.
96 00:10:03.630 ⇒ 00:10:10.030 Sezim Zhenishbekova: Yeah, and also timestamps are very different, like, timestamp here is a bit different than in the past.
97 00:10:10.850 ⇒ 00:10:16.150 Henry Zhao: I was a little lost, I’m like, how can we, by end of day, get a number for Mitesh that is, like…
98 00:10:16.420 ⇒ 00:10:19.150 Henry Zhao: An estimate of the refill orders for next month.
99 00:10:22.030 ⇒ 00:10:24.930 Demilade Agboola: So it’s tricky.
100 00:10:25.110 ⇒ 00:10:29.510 Demilade Agboola: Does he also want by product type, or he doesn’t really care, he just wants to have a round number?
101 00:10:29.510 ⇒ 00:10:42.519 Henry Zhao: He wants it by status. He wants to, like, know we were supposed to get 11,000 refills next month, but we’re only gonna get 10,000 because 250 canceled, 250 will have a payment error, and the 500 got paused. That’s all he is asking for right now.
102 00:10:42.520 ⇒ 00:10:43.809 Demilade Agboola: Alright, gotcha, so…
103 00:10:43.920 ⇒ 00:10:51.480 Demilade Agboola: by status. So my guess is, can we look at the ones that were canceled? Can we look at them in Basque?
104 00:10:51.480 ⇒ 00:10:54.840 Henry Zhao: Yes, so I’ll have Sezum do that, because she’s now our expert at that.
105 00:10:55.610 ⇒ 00:11:09.059 Demilade Agboola: So my idea is, let’s try and get an idea of, like, a journey for the different statuses. So if it says completed, what does that look like in the journey? If it says canceled, is it possible that
106 00:11:09.690 ⇒ 00:11:11.860 Demilade Agboola: The cancellation comes after…
107 00:11:12.000 ⇒ 00:11:19.420 Demilade Agboola: There was a future path, and now, because it’s canceled, we won’t therefore deliver the future 1.
108 00:11:19.770 ⇒ 00:11:20.280 Demilade Agboola: But this.
109 00:11:20.280 ⇒ 00:11:21.229 Henry Zhao: Yeah, but I’m also worried about.
110 00:11:21.230 ⇒ 00:11:21.580 Demilade Agboola: Awesome.
111 00:11:21.580 ⇒ 00:11:27.819 Henry Zhao: Yeah, and I’m also worried if, like, next payment… next streaming date becomes null, if somebody cancels it or pauses it.
112 00:11:28.470 ⇒ 00:11:30.830 Henry Zhao: I’m worried about that, and I don’t know how I would check that.
113 00:11:31.990 ⇒ 00:11:40.409 Henry Zhao: Because we do see some orders with status canceled, or abandoned, or paused with next shipping dates, but we also see ones without it.
114 00:11:40.700 ⇒ 00:11:43.470 Henry Zhao: So, I don’t know what the difference between those would be.
115 00:11:44.490 ⇒ 00:11:46.229 Demilade Agboola: Fair enough, fair enough.
116 00:11:46.770 ⇒ 00:11:50.870 Demilade Agboola: I guess there’s a few questions, like, search them, you can maybe make a list of.
117 00:11:51.960 ⇒ 00:12:02.420 Demilade Agboola: we can throw it to Basque, like, if you have a list of questions where we’re like, okay, when it comes to the treatment of data, so we can make… we can make an answer for, like, we can answer Mitesh right now, that’s fine.
118 00:12:02.930 ⇒ 00:12:08.949 Demilade Agboola: But obviously, there are going to be assumptions we’re going to make, so if you can have a list of, like, those questions where we’re like, okay.
119 00:12:09.150 ⇒ 00:12:25.030 Demilade Agboola: it appears some are completed… some are canceled with the next status date, some are canceled without the next status date, why so? Next shipping date, why so? Like, just a bunch of those questions, we’ll throw it to BASC, they’re the ones that provide the data via the API that we consume, and that’s
120 00:12:26.300 ⇒ 00:12:44.129 Demilade Agboola: And if they can clarify and give us better answers, great. If the answers are such that, like, we’re like, okay, this is very confusing and doesn’t make any sense, we can always push it to them and say, hey, we need you to make those modifications to how the data comes in. They’re very slow with those things, but at the very least, we would have that in front of
121 00:12:44.260 ⇒ 00:12:51.340 Demilade Agboola: the business stakeholders, like the CEO of Eden and all of that, so they know that we’re actively trying to make those changes.
122 00:12:52.530 ⇒ 00:12:56.340 Henry Zhao: Okay, but for now, it looks like next ship… next shipping date is the right field to use, right?
123 00:12:56.340 ⇒ 00:12:58.569 Demilade Agboola: Yeah, for now, we’ll use that as our bunker.
124 00:12:59.010 ⇒ 00:13:02.669 Henry Zhao: Exactly. With the assumption, it makes more sense to me, at least, than next payment date.
125 00:13:03.240 ⇒ 00:13:04.489 Demilade Agboola: Yeah, and also.
126 00:13:04.490 ⇒ 00:13:05.090 Sezim Zhenishbekova: So…
127 00:13:05.090 ⇒ 00:13:12.009 Demilade Agboola: look at the negative… look at some of the treatments with negatives. Let’s get an idea of what potentially is going on there.
128 00:13:12.690 ⇒ 00:13:15.070 Demilade Agboola: Maybe they were…
129 00:13:15.290 ⇒ 00:13:21.599 Demilade Agboola: they were sent stuff that might need to… I don’t know, we would have to just look and get an idea of what’s going on with those ones as well.
130 00:13:24.850 ⇒ 00:13:32.280 Sezim Zhenishbekova: Basically, right now, I will go through all the canceled transactions, drop it in the chat and Slack, so we can start
131 00:13:33.120 ⇒ 00:13:37.249 Sezim Zhenishbekova: Making sense what it is, and then drop the questions that we can request.
132 00:13:37.870 ⇒ 00:13:46.030 Sezim Zhenishbekova: Yeah. What kind of, like, final product do you guys want to see to deliver to them? Ideally, of course, we need the forecast projections.
133 00:13:47.040 ⇒ 00:13:47.710 Demilade Agboola: Right.
134 00:13:47.980 ⇒ 00:13:55.040 Henry Zhao: the numbers for January, in my opinion. Just total number of expected refills, and then break it down into the things we talked about today.
135 00:13:55.260 ⇒ 00:13:56.069 Henry Zhao: So, like.
136 00:13:56.070 ⇒ 00:13:56.480 Sezim Zhenishbekova: It feels…
137 00:13:56.820 ⇒ 00:14:08.840 Henry Zhao: we can… you don’t have to do it by drug type, I don’t think, until he asks for it. When he does ask for it, it’s very easy to break down by drug type, like, that part’s not difficult. But it’s just breaking down by canceled, payment error, paused.
138 00:14:09.740 ⇒ 00:14:14.320 Henry Zhao: And then we can also, if you can, add in, like, new orders.
139 00:14:14.910 ⇒ 00:14:17.910 Henry Zhao: After the refills have gone… gone to zero.
140 00:14:20.080 ⇒ 00:14:22.509 Sezim Zhenishbekova: And then,
141 00:14:23.240 ⇒ 00:14:37.869 Sezim Zhenishbekova: So, where is the most reliable frame? You said the BOSC is kind of a mess, right? Like, we got the information from BigQuery, I was, like, spending time to understand where it matches, where it doesn’t, try to make sense out of it. Is there, like, a single place where it’s…
142 00:14:38.250 ⇒ 00:14:44.239 Sezim Zhenishbekova: Running, like, all the data is there in, like, the most reliable places in that place or not?
143 00:14:44.240 ⇒ 00:14:46.119 Henry Zhao: No, because all of our data comes from Basque.
144 00:14:46.610 ⇒ 00:14:47.079 Sezim Zhenishbekova: Yeah, so that’s.
145 00:14:47.080 ⇒ 00:14:49.829 Demilade Agboola: the problem. So BASC provides us with all the data.
146 00:14:49.960 ⇒ 00:15:03.449 Demilade Agboola: And we get that data via an API. The problem is sometimes the API is wonky, and so what you might do is maybe take an order ID or an order number and go to BASC itself.
147 00:15:04.040 ⇒ 00:15:21.130 Demilade Agboola: get the treatments, like, you can look at the treatment of the customer, of the consumer, and kind of get an idea of what’s going on. I don’t suggest you do it for every single, like, canceled order, because that would be a waste of time. Maybe get 10, or 5, or whatever number. 5 is fine, I think, yeah.
148 00:15:21.480 ⇒ 00:15:38.739 Demilade Agboola: just get 5 of those, go through BASC, and just get an idea of what’s going on. Maybe you might notice a pattern, maybe you might notice if the cancellation comes after a certain date, like, there might be a pattern to it, that’s fine. If you don’t notice a pattern, that’s also fine. The idea is just so that when we talk to BASC, we can go, hey.
149 00:15:39.700 ⇒ 00:15:53.909 Demilade Agboola: we have the data, we know these are all the active, treatments that are going to be delivered in January. These are all the canceled treatments that we assume are to be delivered in January, but won’t be delivered anymore because they were canceled.
150 00:15:54.010 ⇒ 00:15:59.150 Sezim Zhenishbekova: These are the paused ones that, again, were to be delivered in January, but appear to be paused.
151 00:15:59.220 ⇒ 00:16:06.260 Demilade Agboola: These were the ones that, you know, appeared to be delivered in January, but were, maybe completed. We’ll put that there.
152 00:16:06.410 ⇒ 00:16:13.359 Demilade Agboola: And we’ll give that to Mitesh, because Mitesh really wants… would really want an answer to, you know, give to stakeholders. That’s fine.
153 00:16:13.590 ⇒ 00:16:30.429 Demilade Agboola: But we know that we’re making assumptions on that data, so I want us to be able to have a list of those assumptions, like, we’re assuming this, we’re assuming that, and then we can push those assumptions to Basque and be like, yo, these are the assumptions we’re making, are those assumptions right? And if not.
154 00:16:30.720 ⇒ 00:16:35.560 Demilade Agboola: what’s wrong with the data? Why… why are some canceled but have a future date?
155 00:16:36.510 ⇒ 00:16:45.899 Demilade Agboola: canceled, and then he might go, like, Zach Bask, that’s the CEO, might go… actually, when it’s canceled, the next date is not removed from the data, so that’s why it’s that.
156 00:16:46.000 ⇒ 00:16:53.230 Demilade Agboola: Right? Or he might… whatever reasons he’ll give us, we can understand that, and then we can use that to refine our assumptions.
157 00:16:53.330 ⇒ 00:16:54.550 Demilade Agboola: Going forward.
158 00:16:56.110 ⇒ 00:17:00.659 Henry Zhao: But I would… but for the deliverable, it’s not to wait on BAS, because they would take forever.
159 00:17:00.660 ⇒ 00:17:01.200 Demilade Agboola: Exactly.
160 00:17:01.620 ⇒ 00:17:02.450 Sezim Zhenishbekova: Yeah.
161 00:17:02.930 ⇒ 00:17:09.760 Demilade Agboola: Like, no jokes about forever, they literally could take up 3 months or 4 months, so don’t, do not, do not, we don’t bask for anything.
162 00:17:10.470 ⇒ 00:17:15.490 Henry Zhao: So we could probably give Mitesh an estimate by end of day, and then just list out the assumptions, and just say, like, this is
163 00:17:15.910 ⇒ 00:17:30.529 Henry Zhao: came up with, but these are some confusing things that we’re clarifying with BASC. And if the number doesn’t align with, kind of, your expectations of what you thought the number was going to be, it would be one of these assumptions that are, you know, screwing up the data.
164 00:17:31.050 ⇒ 00:17:33.830 Henry Zhao: word it more eloquently than me, but,
165 00:17:34.260 ⇒ 00:17:45.390 Henry Zhao: that’s kind of how I would deliver the final product. So it would look like, from my initial data… from my data polls, from my data analysis, I think there’s gonna be 11,000 refills next month.
166 00:17:45.860 ⇒ 00:17:53.550 Henry Zhao: 200 of them will be canceled, 18 of them will be payment failure, and 500 of them will be paused.
167 00:17:54.510 ⇒ 00:18:03.070 Henry Zhao: However, this pause number could be wrong because of blah blah blah, canceled could be wrong because… it could be overstated because…
168 00:18:03.300 ⇒ 00:18:10.019 Henry Zhao: We’re seeing canceled orders still getting refills, or non-refill products are getting…
169 00:18:11.100 ⇒ 00:18:13.819 Henry Zhao: Shown baskets having refills, something like that.
170 00:18:14.180 ⇒ 00:18:19.570 Demilade Agboola: Yeah, all of them have negative refills, but are still showing up in the future date, so you could just quantify
171 00:18:19.990 ⇒ 00:18:20.850 Demilade Agboola: those assumptions.
172 00:18:20.850 ⇒ 00:18:22.179 Henry Zhao: Oh yeah, quantify them.
173 00:18:23.320 ⇒ 00:18:28.629 Demilade Agboola: That’s it. And then we can now go to BASC and go, why are negative refills showing up in future
174 00:18:29.100 ⇒ 00:18:42.459 Demilade Agboola: with future shipping dates, and they can explain and say, oh, this is what’s going on, there was an error with an API, whatever, like, they can explain all those. But let’s just give them the raw numbers that we have, but, like, we’ll work on data quality behind the scenes.
175 00:18:43.720 ⇒ 00:18:46.160 Henry Zhao: In the meantime, let me be sure to message him real quick.
176 00:19:04.260 ⇒ 00:19:12.720 Henry Zhao: That, and then… So… so, Demolade, if I have a 6-dose semaglutide treatment.
177 00:19:13.230 ⇒ 00:19:18.309 Demilade Agboola: Okay. And it’s… so I get 6 refills, right? And they send it to me monthly, so 6 shipments, right?
178 00:19:19.570 ⇒ 00:19:20.230 Demilade Agboola: Yeah.
179 00:19:20.230 ⇒ 00:19:26.000 Henry Zhao: If that’s 6 different order numbers in BASC, and also, therefore, 6 rows in order summary with different order numbers.
180 00:19:26.850 ⇒ 00:19:27.670 Demilade Agboola: Yes.
181 00:19:29.350 ⇒ 00:19:31.789 Henry Zhao: So then the 12,000 number seems right.
182 00:19:32.880 ⇒ 00:19:45.970 Demilade Agboola: Yeah, yeah, so orders are each time something is shipped. The unique… the unique one is treatment, so each treatment can have multiple orders within the treatment. So, like, orders are subsets, or, like, a smaller…
183 00:19:46.200 ⇒ 00:19:48.519 Demilade Agboola: From others’ makeup treatments, basically.
184 00:19:48.690 ⇒ 00:19:53.010 Henry Zhao: So then, I don’t think, Seism, we even need your part of, like, looking at
185 00:19:53.450 ⇒ 00:19:59.429 Henry Zhao: like, the data step one that I sent you yesterday, I don’t think we need that. I think that this is correct already.
186 00:19:59.430 ⇒ 00:20:01.380 Sezim Zhenishbekova: Like, what you did is already…
187 00:20:01.740 ⇒ 00:20:09.550 Henry Zhao: I think this is correct then, right, Demolade? I think there’s 9,809 refills coming up in January, because that’s the next shipping date for January.
188 00:20:09.870 ⇒ 00:20:13.270 Henry Zhao: And then we can just break down by payment error, canceled already here.
189 00:20:13.930 ⇒ 00:20:14.370 Sezim Zhenishbekova: Yeah.
190 00:20:15.060 ⇒ 00:20:23.110 Demilade Agboola: Yeah, that’s what I’m saying. You’re right there to it, and so you just have to make… clarify the assumptions we’re making on this data, but, like, this… this is literally it.
191 00:20:23.880 ⇒ 00:20:26.170 Henry Zhao: Okay, so it’s almost there. You just…
192 00:20:26.170 ⇒ 00:20:28.540 Sezim Zhenishbekova: Pivot table now.
193 00:20:28.540 ⇒ 00:20:30.269 Henry Zhao: So it’s not as complicated as you thought.
194 00:20:30.500 ⇒ 00:20:37.460 Sezim Zhenishbekova: Yeah, I thought I need to do the forecasting, like, based on many factors from the past data and the future data and all that. Okay.
195 00:20:37.460 ⇒ 00:20:44.830 Henry Zhao: You won’t because it’s already included in here, basically. So, like, all of the returning orders that I sent you are already in here, but in December.
196 00:20:45.890 ⇒ 00:20:46.340 Sezim Zhenishbekova: Okay.
197 00:20:46.340 ⇒ 00:20:49.220 Henry Zhao: Because they haven’t happened yet, right? Like, these things haven’t happened yet.
198 00:20:50.500 ⇒ 00:20:51.150 Sezim Zhenishbekova: Okay.
199 00:20:51.570 ⇒ 00:20:54.699 Sezim Zhenishbekova: Yeah, I’ll… I’ll jump into that. I’ve also been looking into.
200 00:20:54.700 ⇒ 00:20:59.160 Demilade Agboola: Also, another assumption… okay, yeah, this is… this is… This is…
201 00:20:59.990 ⇒ 00:21:12.139 Demilade Agboola: Another assumption we’re making is that the shipment hasn’t happened yet, so the next shipping date is still… like, this one is on a monthly plan, but the next shipping date is maybe the 21st of December.
202 00:21:12.320 ⇒ 00:21:19.179 Demilade Agboola: So, they’re gonna get 21st of December, 21st of January. It wouldn’t be here, because the next shipping date hasn’t yet
203 00:21:19.350 ⇒ 00:21:28.320 Demilade Agboola: Did you get my point? Like, 21st of December shipment would have to go before the next shipment date of the 21st of January will kick in.
204 00:21:28.670 ⇒ 00:21:37.350 Henry Zhao: Yep. We’re just asking her to look into it and ask, but Seism, the one thing we haven’t checked yet is paused, so I go into this, ask now and look for some of the paused examples.
205 00:21:37.600 ⇒ 00:21:37.950 Sezim Zhenishbekova: Yes.
206 00:21:37.950 ⇒ 00:21:50.229 Henry Zhao: if paused is the next shipment, if they were to unpause now, or does it mean they have unpaused, and that’s why they’re getting one next shipping date, and this pause is, like, an old status?
207 00:21:50.480 ⇒ 00:21:55.560 Henry Zhao: Or… are they paused, and we shouldn’t be including this January 4th at all?
208 00:21:56.050 ⇒ 00:22:01.259 Henry Zhao: So, yeah, I just tried to get an understanding of what the paused ones mean. Okay. I have no idea, I’ve never looked into these.
209 00:22:03.520 ⇒ 00:22:08.249 Henry Zhao: So, like, this one would be a good one to look at, because this one has 4 remaining refills. I would look at what their history looks like.
210 00:22:09.090 ⇒ 00:22:20.689 Sezim Zhenishbekova: Okay, so I will dive deep into the canceled logic of 5 orders, pause 5 orders, just to understand what’s going on there, and then just do the pivot tables and prepare the file.
211 00:22:20.690 ⇒ 00:22:25.520 Henry Zhao: Yeah, if you don’t have enough paused examples here, and you need me to pull, like, more historical rows of paused.
212 00:22:25.730 ⇒ 00:22:28.269 Sezim Zhenishbekova: I think you already gave me a historical one, right?
213 00:22:28.270 ⇒ 00:22:29.020 Henry Zhao: I do, yeah.
214 00:22:29.020 ⇒ 00:22:30.229 Sezim Zhenishbekova: I have to look anymore.
215 00:22:30.230 ⇒ 00:22:31.109 Henry Zhao: You’ll use those as well.
216 00:22:31.110 ⇒ 00:22:33.370 Sezim Zhenishbekova: Yeah, yeah, so I have already that for the park.
217 00:22:33.370 ⇒ 00:22:47.850 Henry Zhao: If you look at 5 of the historical ones, and they all, like, didn’t fulfill that refill, like, they were all supposed to get refills in January, but they didn’t, and then they got them in March, June, and September, that’s when they unpaused, then you know that… then you kind of know what paused means, right? It means…
218 00:22:48.360 ⇒ 00:22:50.809 Henry Zhao: supposed to get one in January, but they didn’t because they paused it.
219 00:22:51.760 ⇒ 00:22:52.330 Sezim Zhenishbekova: Okay.
220 00:22:52.330 ⇒ 00:22:52.880 Henry Zhao: Versus if all…
221 00:22:52.880 ⇒ 00:22:53.830 Sezim Zhenishbekova: Which can be…
222 00:22:53.830 ⇒ 00:22:54.520 Henry Zhao: Yeah.
223 00:22:54.520 ⇒ 00:23:04.839 Sezim Zhenishbekova: Yeah, and then, yeah, I need to make sure that if it’s paused, can it be resumed, and if it has ever been resumed after, and what did it look like? Yeah.
224 00:23:05.770 ⇒ 00:23:07.600 Demilade Agboola: I will… I will advise that.
225 00:23:08.290 ⇒ 00:23:12.640 Demilade Agboola: as much as possible, because you can easily go down a hole with all this. You should maybe set.
226 00:23:13.050 ⇒ 00:23:15.350 Demilade Agboola: 45 minutes, like, timer.
227 00:23:15.510 ⇒ 00:23:26.529 Demilade Agboola: Where you’re like, okay, I’m going to do all my investigations in that period, say 45 minutes, and then I will push the numbers plus the assumptions that I’ve made with that. Because it’s very easy to start going down the whole.
228 00:23:26.530 ⇒ 00:23:26.970 Sezim Zhenishbekova: Yeah.
229 00:23:26.970 ⇒ 00:23:31.770 Demilade Agboola: Who’s done this? And before you know it, two hours have gone by, and you have a still couldn’t predict that.
230 00:23:31.770 ⇒ 00:23:37.000 Sezim Zhenishbekova: Yeah, yeah, that’s what’s been happening. Okay, sounds good.
231 00:23:37.000 ⇒ 00:23:42.879 Henry Zhao: And then I get worried… and then I get worried that they will yell at me for, like, going past the budget, but they’re nice about… they’re nice about that part, at least. They haven’t…
232 00:23:43.620 ⇒ 00:23:51.250 Henry Zhao: never criticize us for going past the hours, they will say, like, we need to watch that, but they are more worried about, like, us asking questions and making our assumptions.
233 00:23:51.250 ⇒ 00:23:51.739 Sezim Zhenishbekova: and .
234 00:23:51.740 ⇒ 00:23:54.690 Henry Zhao: And meeting deadlines, and updating our tickets.
235 00:23:55.070 ⇒ 00:23:55.610 Sezim Zhenishbekova: Yeah.
236 00:23:55.610 ⇒ 00:24:04.030 Demilade Agboola: Yeah, and also, if you get blocked, again, this is all new stuff to you, so if you get blocked, please feel free to reach out to… presuming Harry, but, like, I’m also online, so if…
237 00:24:04.030 ⇒ 00:24:07.629 Henry Zhao: Or client eating, yeah. They want Seism to reach on client eating.
238 00:24:07.830 ⇒ 00:24:08.460 Demilade Agboola: Yeah.
239 00:24:08.680 ⇒ 00:24:11.479 Sezim Zhenishbekova: Yeah. Okay, sounds good. Thank you so much.
240 00:24:11.480 ⇒ 00:24:15.260 Henry Zhao: I will be offline right now for about an hour, so if you.
241 00:24:15.260 ⇒ 00:24:21.190 Sezim Zhenishbekova: Okay. Yeah, I need to also be offline for an hour, but then I will get back and work on this. Yeah. It’s a little minute.
242 00:24:21.190 ⇒ 00:24:26.979 Henry Zhao: If it’s gonna be too late, and I haven’t responded, you can just send it to Mitesh. I think it’s that we just meet the deadline, but just…
243 00:24:26.980 ⇒ 00:24:29.949 Sezim Zhenishbekova: What is Rosmetash? I don’t know who’s Matash.
244 00:24:30.860 ⇒ 00:24:33.339 Demilade Agboola: I’m not sure how to explain, but he…
245 00:24:33.340 ⇒ 00:24:39.000 Henry Zhao: I need him then, and just say, like, can somebody check this? And then I will do it as soon as possible, or Robert will jump in, probably.
246 00:24:39.000 ⇒ 00:24:39.370 Sezim Zhenishbekova: Okay.
247 00:24:39.370 ⇒ 00:24:40.369 Henry Zhao: But nobody responds.
248 00:24:40.670 ⇒ 00:24:43.640 Henry Zhao: Okay, sounds good. Thank you. Alright, that’s good. Thank you.
249 00:24:44.280 ⇒ 00:24:44.920 Henry Zhao: Right.