Meeting Title: Farm Ops Analytics Channel Request Review Date: 2025-06-20 Meeting participants: rebeccaemch, Demilade Agboola
WEBVTT
1 00:00:53.220 ⇒ 00:00:54.450 Demilade Agboola: Hi! Rebecca!
2 00:00:55.240 ⇒ 00:00:56.600 rebeccaemch: Hi! Good morning! How are you?
3 00:00:56.820 ⇒ 00:00:58.170 Demilade Agboola: I’m pretty good. How are you?
4 00:00:58.990 ⇒ 00:01:00.689 rebeccaemch: Doing good. Thank you.
5 00:01:01.920 ⇒ 00:01:05.781 Demilade Agboola: Okay, so let’s try and jump right into it.
6 00:01:07.010 ⇒ 00:01:12.200 rebeccaemch: Yes, and I don’t want to like totally derail today’s conversation, but
7 00:01:12.340 ⇒ 00:01:27.360 rebeccaemch: even more important than figuring out the vial sizes which we can definitely get to at the end of today’s conversation. I want to start with the request from the Farm Ops Analytics Channel. Have you had a chance to review that.
8 00:01:27.804 ⇒ 00:01:31.366 Demilade Agboola: Yeah, I have looked at it, and it kind of ties into this.
9 00:01:31.780 ⇒ 00:01:36.839 Demilade Agboola: because part of the reason why we’re doing all this, like Val size workaround is because Basque
10 00:01:37.040 ⇒ 00:01:46.960 Demilade Agboola: doesn’t allow an easy way to tie the treatment back to the orders. So it’s kind of hard to go. This is this treatment that had. You know
11 00:01:48.360 ⇒ 00:01:54.369 Demilade Agboola: this long to go, and this is how many orders they’ve placed. So they have, like this number of refills left.
12 00:01:55.270 ⇒ 00:01:56.840 rebeccaemch: Hmm, okay.
13 00:01:57.030 ⇒ 00:02:01.173 Demilade Agboola: Cause like, and I could quickly share my screen to show you what I mean.
14 00:02:04.710 ⇒ 00:02:05.939 Demilade Agboola: Can you see my screen.
15 00:02:05.940 ⇒ 00:02:06.860 rebeccaemch: Yes.
16 00:02:06.860 ⇒ 00:02:14.330 Demilade Agboola: Alright. So if we go into here, we
17 00:02:15.060 ⇒ 00:02:30.669 Demilade Agboola: I’ve been looking at a lot of things today. Alright. So like this is what we get when we try and look at the treatment data. So we do have a field where we have the remaining file sizes or remaining refills left.
18 00:02:31.560 ⇒ 00:02:37.470 Demilade Agboola: The problem is, we know who the customer is, but
19 00:02:37.580 ⇒ 00:02:40.000 Demilade Agboola: we don’t know necessarily what the
20 00:02:40.950 ⇒ 00:02:46.419 Demilade Agboola: the like. There’s no treatment Id, that we can associate with the orders. So if
21 00:02:46.740 ⇒ 00:02:49.829 Demilade Agboola: a customer potentially has 2 different
22 00:02:50.516 ⇒ 00:02:53.199 Demilade Agboola: treatments going on, it would
23 00:02:53.420 ⇒ 00:02:59.000 Demilade Agboola: we would cascade that like answer across multiple treatments.
24 00:02:59.260 ⇒ 00:03:00.439 Demilade Agboola: Should you go? I mean.
25 00:03:00.760 ⇒ 00:03:01.600 rebeccaemch: Yeah.
26 00:03:02.400 ⇒ 00:03:07.919 rebeccaemch: So if worst case scenario, we would just have duplicates. But then we could probably
27 00:03:08.380 ⇒ 00:03:12.669 rebeccaemch: run I don’t know something to remove duplicates.
28 00:03:14.242 ⇒ 00:03:18.670 Demilade Agboola: Sure, if if if yeah, I mean, we could have duplicates.
29 00:03:19.120 ⇒ 00:03:21.550 Demilade Agboola: But we could also have inaccurate like.
30 00:03:23.580 ⇒ 00:03:30.710 Demilade Agboola: how do I put it this way. So like if, for instance, have like 3 fields left, and they have 2 different product ids that they’re on.
31 00:03:31.710 ⇒ 00:03:43.659 Demilade Agboola: it would say it would put the answers for both of them across, like the different ones as well. So potentially, you could have 4 answers, you would have 4 responses.
32 00:03:43.780 ⇒ 00:03:56.229 Demilade Agboola: So product product. Ida might get both 10 and 11 refills left product. Id. B. Could also get 10 and 11 refills left, and you might not be sure which is which actually.
33 00:03:56.860 ⇒ 00:03:57.570 rebeccaemch: Hmm.
34 00:03:58.000 ⇒ 00:03:59.719 Demilade Agboola: That’s the worrying.
35 00:04:02.260 ⇒ 00:04:09.460 Demilade Agboola: But I could always do a join based off the customer. Id. And just say, Hey, for every customer with the treatment. That is.
36 00:04:09.640 ⇒ 00:04:16.820 Demilade Agboola: at very least we know what semi is, and so we can just go like I don’t care for, like you know, mic and big.
37 00:04:17.610 ⇒ 00:04:20.309 Demilade Agboola: All of these are all the product sends Usama right.
38 00:04:21.850 ⇒ 00:04:28.350 rebeccaemch: Yes, and I. I have a list of all the products and their ids.
39 00:04:29.350 ⇒ 00:04:30.610 Demilade Agboola: Yeah, unfortunately.
40 00:04:30.610 ⇒ 00:04:33.050 rebeccaemch: Inside of that sheet as well, so that might help.
41 00:04:33.470 ⇒ 00:04:35.500 Demilade Agboola: Yeah, I saw the product.
42 00:04:35.500 ⇒ 00:04:36.760 rebeccaemch: Go ahead!
43 00:04:37.040 ⇒ 00:04:45.920 Demilade Agboola: Unfortunately, no product ids here as well, which would have made it easier to tie and say, Hey, for every customer with this product Id get the number of fields left.
44 00:04:46.260 ⇒ 00:04:57.269 Demilade Agboola: but we only have customers on product name. So what I can do is I can filter out these to only include like summer. So if it doesn’t have like Seme in it.
45 00:04:57.480 ⇒ 00:04:59.249 Demilade Agboola: I don’t care for it to be joined on.
46 00:05:00.100 ⇒ 00:05:02.219 Demilade Agboola: and then I can give you that refill
47 00:05:03.950 ⇒ 00:05:05.830 Demilade Agboola: the refuel. Can’t space left that
48 00:05:08.000 ⇒ 00:05:10.319 Demilade Agboola: even here, too, you can kind of see the same.
49 00:05:10.320 ⇒ 00:05:15.230 rebeccaemch: Yeah, all of the product things are.
50 00:05:16.010 ⇒ 00:05:17.909 rebeccaemch: I’m pretty specific.
51 00:05:21.120 ⇒ 00:05:22.025 Demilade Agboola: Yeah.
52 00:05:24.210 ⇒ 00:05:28.229 rebeccaemch: The paste. All of these product names in there.
53 00:05:30.510 ⇒ 00:05:36.469 Demilade Agboola: Unfortunately, you seem to be cutting in and out. I’m not sure if it’s like my Internet, or it’s your Internet.
54 00:05:44.280 ⇒ 00:05:45.080 Demilade Agboola: Hello.
55 00:05:48.830 ⇒ 00:05:49.460 rebeccaemch: Oh!
56 00:05:51.300 ⇒ 00:05:52.020 Demilade Agboola: Jeremy.
57 00:05:52.020 ⇒ 00:05:53.690 rebeccaemch: Oh, yep, I can hear you now.
58 00:05:54.030 ⇒ 00:06:01.300 Demilade Agboola: Okay, I didn’t have the last like statement she made cause the network was cutting out.
59 00:06:01.300 ⇒ 00:06:12.019 rebeccaemch: Sorry. I think that so basically, I was just saying that there’s 50, something variance on this list.
60 00:06:12.250 ⇒ 00:06:13.020 Demilade Agboola: Okay.
61 00:06:13.500 ⇒ 00:06:20.749 rebeccaemch: So if you can search by product name, that would be ideal.
62 00:06:23.060 ⇒ 00:06:27.930 Demilade Agboola: Okay, so potentially, what I’ll I’ll do is I’m literally walking in as we speak.
63 00:06:28.140 ⇒ 00:06:35.360 Demilade Agboola: So here we can see the different people who have treatments.
64 00:06:35.700 ⇒ 00:06:37.580 Demilade Agboola: and what I will do now.
65 00:06:39.523 ⇒ 00:06:44.350 Demilade Agboola: So what I’ll do now is, I have.
66 00:06:45.861 ⇒ 00:06:53.810 rebeccaemch: Can we put like does not include B, 12 does not include sublingual.
67 00:06:56.680 ⇒ 00:06:57.610 Demilade Agboola: Oh.
68 00:07:02.620 ⇒ 00:07:05.899 Demilade Agboola: so you can. Okay, got that name?
69 00:07:17.640 ⇒ 00:07:18.669 Demilade Agboola: B, 12.
70 00:07:19.150 ⇒ 00:07:21.519 rebeccaemch: B. 12, and also sublingual.
71 00:07:22.070 ⇒ 00:07:23.480 Demilade Agboola: Okay.
72 00:07:38.230 ⇒ 00:07:41.010 Demilade Agboola: right? That’s there.
73 00:07:41.630 ⇒ 00:07:44.030 rebeccaemch: Probably does not include gummy.
74 00:07:45.930 ⇒ 00:07:47.010 Demilade Agboola: Okay.
75 00:07:50.300 ⇒ 00:07:53.720 Demilade Agboola: I could just use gone right? Like, there’s no other. Yeah.
76 00:07:57.660 ⇒ 00:07:59.730 Demilade Agboola: alright. So just
77 00:08:03.860 ⇒ 00:08:05.490 Demilade Agboola: alright. So what I’ll do.
78 00:08:05.490 ⇒ 00:08:08.179 rebeccaemch: Those remaining is more than 0.
79 00:08:10.630 ⇒ 00:08:15.700 Demilade Agboola: Yeah, I’ll definitely do that like my, what I’m trying to now do now is get the
80 00:08:15.830 ⇒ 00:08:22.140 Demilade Agboola: customer Id, and join into the list of everybody who’s gotten
81 00:08:27.650 ⇒ 00:08:31.240 Demilade Agboola: basically, everyone who’s gotten what’s it called.
82 00:08:31.820 ⇒ 00:08:32.760 rebeccaemch: A refill.
83 00:08:33.360 ⇒ 00:08:34.549 Demilade Agboola: An order
84 00:08:35.890 ⇒ 00:08:44.390 Demilade Agboola: it was had an order after the you know, the 1st of January, and orders like this. Alright, so I’ll join into this, and we’ll
85 00:08:47.037 ⇒ 00:08:49.010 Demilade Agboola: so remaining refills.
86 00:08:53.150 ⇒ 00:08:56.060 Demilade Agboola: It’s greater than 0.
87 00:08:57.800 ⇒ 00:08:58.969 Demilade Agboola: Sorry for me.
88 00:08:59.260 ⇒ 00:09:00.500 Demilade Agboola: There’s still.
89 00:09:05.810 ⇒ 00:09:06.510 rebeccaemch: These.
90 00:09:10.370 ⇒ 00:09:11.710 Demilade Agboola: And then.
91 00:09:12.530 ⇒ 00:09:13.270 rebeccaemch: Thank you.
92 00:09:18.940 ⇒ 00:09:21.829 rebeccaemch: Should we also say, with status, active
93 00:09:24.490 ⇒ 00:09:27.769 rebeccaemch: status will be active if they have any refills remaining so.
94 00:09:27.990 ⇒ 00:09:30.880 Demilade Agboola: Oh, yeah, what would you.
95 00:09:30.880 ⇒ 00:09:36.849 rebeccaemch: Say status is not completed, because you see scroll left, please.
96 00:09:37.350 ⇒ 00:09:39.869 rebeccaemch: You see status right there where it says completed.
97 00:09:40.130 ⇒ 00:09:40.830 Demilade Agboola: Yeah.
98 00:09:40.830 ⇒ 00:09:43.999 rebeccaemch: Yeah, so it’ll have to be status not completed.
99 00:09:44.350 ⇒ 00:09:54.180 Demilade Agboola: Gotcha but then automatically, if the refers to 0 should be completed right.
100 00:09:54.180 ⇒ 00:09:56.139 rebeccaemch: Well, yeah, I guess you’re right. Yeah.
101 00:09:56.490 ⇒ 00:10:06.320 Demilade Agboola: Alright, let’s let’s try this. So when we have customers. So this is everyone we’ve been. Would you get to see the count of orders done.
102 00:10:07.050 ⇒ 00:10:08.420 Demilade Agboola: or you don’t care for that.
103 00:10:11.840 ⇒ 00:10:17.930 rebeccaemch: If you could produce both, that would be fine count of orders done, and count of orders left.
104 00:10:20.396 ⇒ 00:10:26.979 Demilade Agboola: Yeah, I I reason I’m doing that is so that we can have some sense of like a parameter if things are wrong.
105 00:10:27.300 ⇒ 00:10:38.450 Demilade Agboola: So like. If the 3 fields are done, and then the numbers are still like the numbers of orders are low, we can go. Something seems off here. That’s kind of why I’m thinking of adding it.
106 00:10:38.780 ⇒ 00:10:41.899 rebeccaemch: Okay. I don’t need any of the monthly.
107 00:10:43.180 ⇒ 00:10:46.940 Demilade Agboola: You don’t need any of the monthly like the membership Plans Monthly.
108 00:10:47.310 ⇒ 00:10:52.869 rebeccaemch: I mean, I guess. Sure we couldn’t have it on there, but we’ll just probably filter it out.
109 00:10:53.660 ⇒ 00:10:55.909 Demilade Agboola: Okay, if you don’t need it, I could take it out right now.
110 00:10:57.720 ⇒ 00:10:58.260 rebeccaemch: Okay.
111 00:10:58.820 ⇒ 00:11:03.259 rebeccaemch: I guess it would be good to know how many patients total there are.
112 00:11:03.840 ⇒ 00:11:05.069 Demilade Agboola: Alright gotcha! So.
113 00:11:05.070 ⇒ 00:11:06.370 rebeccaemch: Let’s just leave it in.
114 00:11:10.290 ⇒ 00:11:12.699 rebeccaemch: Oh, you can do it by product. Id.
115 00:11:13.750 ⇒ 00:11:14.780 Demilade Agboola: Yeah.
116 00:11:14.780 ⇒ 00:11:16.399 rebeccaemch: Okay, we have a product.
117 00:11:16.400 ⇒ 00:11:16.970 Demilade Agboola: Not at all.
118 00:11:16.970 ⇒ 00:11:17.770 rebeccaemch: 50, something.
119 00:11:17.770 ⇒ 00:11:28.140 Demilade Agboola: But this is from the orders. So I’m I’m looking at the orders that have been fulfilled for each of these product ids. That’s what’s going on here. But I’m trying to join it back to this.
120 00:11:28.310 ⇒ 00:11:32.090 Demilade Agboola: But the problem is, there’s no product here with the treatment.
121 00:11:32.090 ⇒ 00:11:35.269 Demilade Agboola: Oh, man, there’s no problem with the treatment.
122 00:11:35.430 ⇒ 00:11:43.049 Demilade Agboola: It’s just if someone has 2 like concurrent products going on, it will spread across both of them.
123 00:11:43.710 ⇒ 00:11:44.639 Demilade Agboola: That’s kind of.
124 00:11:44.770 ⇒ 00:11:48.580 rebeccaemch: Worry. And that’s kind of what I’m trying to like. Just.
125 00:11:49.090 ⇒ 00:11:51.050 Demilade Agboola: Mitigate. But let’s see.
126 00:11:58.390 ⇒ 00:12:01.220 Demilade Agboola: fulfilled orders.
127 00:12:04.790 ⇒ 00:12:07.430 Demilade Agboola: and want to select
128 00:12:24.960 ⇒ 00:12:30.209 Demilade Agboola: when brass I don’t.
129 00:12:31.360 ⇒ 00:12:37.850 Demilade Agboola: IT go orders and
130 00:12:49.530 ⇒ 00:12:51.210 Demilade Agboola: then name and show us.
131 00:13:05.910 ⇒ 00:13:10.110 Demilade Agboola: So if that task had done the
132 00:13:10.250 ⇒ 00:13:15.109 Demilade Agboola: data like and fix things, it would be so much, much easier.
133 00:13:16.960 ⇒ 00:13:18.890 Demilade Agboola: I give those the treatment. Id.
134 00:15:17.010 ⇒ 00:15:19.399 Demilade Agboola: so are you. There.
135 00:15:20.690 ⇒ 00:15:21.609 rebeccaemch: Yeah, I’m here.
136 00:15:21.970 ⇒ 00:15:26.519 Demilade Agboola: Alright. So this is where, like I, things can get weird.
137 00:15:27.247 ⇒ 00:15:30.590 Demilade Agboola: So for this, it’s saying that this person
138 00:15:30.780 ⇒ 00:15:43.519 Demilade Agboola: with a quarterly membership plan of 1, 2, 1, 2, 9, 9 has one fulfilled order, and has 2 remaining orders. Right? But it’s also saying that same person has one
139 00:15:45.490 ⇒ 00:15:51.679 Demilade Agboola: fulfilled order with one remaining refill. And so my guess is what’s going on. There is that they probably have
140 00:15:52.610 ⇒ 00:16:03.239 Demilade Agboola: to like some different orders with different refill amount. And because we’re not tying it also based on product. Id, it’s just taking all the like refills left.
141 00:16:04.957 ⇒ 00:16:06.150 Demilade Agboola: Put it in.
142 00:16:07.430 ⇒ 00:16:09.560 Demilade Agboola: Yeah, let me look at this.
143 00:16:12.580 ⇒ 00:16:18.579 rebeccaemch: So it’s including their 1st fill whenever they had 2 left, and it’s including their last fill whenever they had one left.
144 00:16:18.880 ⇒ 00:16:25.959 Demilade Agboola: Yeah, but I could. I could do something here. I could filter out by the last updated date.
145 00:16:27.420 ⇒ 00:16:27.944 rebeccaemch: Okay.
146 00:16:29.290 ⇒ 00:16:31.367 Demilade Agboola: Let’s try that.
147 00:16:41.500 ⇒ 00:16:46.649 rebeccaemch: They were doing this. Here’s the problem, though.
148 00:16:46.950 ⇒ 00:16:54.000 rebeccaemch: if you do enough damage to kill people
149 00:17:26.139 ⇒ 00:17:28.829 rebeccaemch: morning, how do you mind
150 00:17:45.340 ⇒ 00:18:02.179 rebeccaemch: some white concrete down here, and maybe even some white concrete down here as well.
151 00:18:03.440 ⇒ 00:18:05.299 rebeccaemch: 20 slides right now.
152 00:18:16.634 ⇒ 00:18:25.050 rebeccaemch: Trust me, this one.
153 00:18:36.730 ⇒ 00:18:46.873 rebeccaemch: Hello! Let’s get started today. We’re playing the whole game right? The rules are super simple. If
154 00:18:48.900 ⇒ 00:18:51.560 rebeccaemch: if you stop me, Mikey, then keep it
155 00:18:54.900 ⇒ 00:18:55.590 rebeccaemch: awesome.
156 00:19:01.540 ⇒ 00:19:02.250 rebeccaemch: Oh.
157 00:20:37.700 ⇒ 00:20:38.950 rebeccaemch: well.
158 00:20:52.890 ⇒ 00:20:55.170 Demilade Agboola: Alright. So this is kind of
159 00:20:56.520 ⇒ 00:20:59.360 Demilade Agboola: potentially what I was trying to allude to.
160 00:21:00.370 ⇒ 00:21:08.220 Demilade Agboola: So this customer only has one treatment, id or treatment plan where they have like refills remaining
161 00:21:09.140 ⇒ 00:21:13.410 Demilade Agboola: right? So they have 2. But then they seem to have
162 00:21:14.180 ⇒ 00:21:19.160 Demilade Agboola: 3 different products that they have bought, and
163 00:21:19.420 ⇒ 00:21:22.169 Demilade Agboola: they’ve had orders fulfilled on those like
164 00:21:22.640 ⇒ 00:21:34.549 Demilade Agboola: on that like product, so or 4 different ones. Actually. So, they have one fulfilled order for this, this, this. But because we’ve not. We’ve been able to tie based on product Id.
165 00:21:35.620 ⇒ 00:21:40.000 Demilade Agboola: it’s just basically saying, all all of them have 2 remaining refills which is not true.
166 00:21:40.550 ⇒ 00:21:45.209 Demilade Agboola: It’s potentially one or 2 of them, or pro, actually, just one of them has it.
167 00:21:45.600 ⇒ 00:21:46.899 Demilade Agboola: But we don’t know which.
168 00:21:57.870 ⇒ 00:21:58.490 Demilade Agboola: Yeah.
169 00:22:06.070 ⇒ 00:22:08.980 rebeccaemch: Yeah, we get that
170 00:22:14.810 ⇒ 00:22:15.470 rebeccaemch: cool.
171 00:22:39.940 ⇒ 00:22:40.670 rebeccaemch: Yes.
172 00:23:46.330 ⇒ 00:23:54.249 rebeccaemch: Yeah, I think it is my Internet, because it seems to be going in and out like even the Zoom will like disappear and then reappear.
173 00:23:55.240 ⇒ 00:23:58.070 rebeccaemch: It’s not not too bad.
174 00:23:58.070 ⇒ 00:24:01.650 Demilade Agboola: If there’s any way you can’t like restart your Internet or something.
175 00:24:04.200 ⇒ 00:24:06.479 Demilade Agboola: Yeah, let me check.
176 00:24:13.550 ⇒ 00:24:14.580 rebeccaemch: Right now.
177 00:24:20.550 ⇒ 00:24:21.450 rebeccaemch: Okay.
178 00:25:25.360 ⇒ 00:25:45.100 rebeccaemch: okay, I just got some more information. So it looks like my team has already paused about a thousand orders. So the status of those should say paused. Which means that we don’t have to include those inside of our report, even though they’ll still say that they have refills.
179 00:25:45.470 ⇒ 00:25:52.429 rebeccaemch: So if you want to filter out status, report status of paused, then that may take some patience out.
180 00:25:53.580 ⇒ 00:25:56.500 Demilade Agboola: Oh, okay, is
181 00:26:02.681 ⇒ 00:26:06.788 Demilade Agboola: okay, something, and see if
182 00:26:11.060 ⇒ 00:26:13.650 Demilade Agboola: alright. So this will be a bit.
183 00:26:19.630 ⇒ 00:26:23.600 Demilade Agboola: The problem here is like, what time I had that. So this is from the refills.
184 00:26:25.330 ⇒ 00:26:31.519 Demilade Agboola: and this is from like the orders. So I can see that this is most likely. This actually.
185 00:26:32.710 ⇒ 00:26:33.480 rebeccaemch: Let’s see.
186 00:26:33.920 ⇒ 00:26:35.404 rebeccaemch: Okay, that’s weird.
187 00:26:36.120 ⇒ 00:26:36.950 Demilade Agboola: Yeah.
188 00:26:37.670 ⇒ 00:26:38.510 rebeccaemch: You know Hawaii.
189 00:26:38.510 ⇒ 00:26:44.169 Demilade Agboola: The problem like that’s why I said, like the refills, there’s no like easy way to tie treatment backs to
190 00:26:45.560 ⇒ 00:26:46.719 Demilade Agboola: the orders.
191 00:26:48.270 ⇒ 00:26:49.430 rebeccaemch: Yeah.
192 00:26:49.430 ⇒ 00:26:53.869 Demilade Agboola: Kinda hard to just go like these are the products
193 00:26:54.020 ⇒ 00:26:59.279 Demilade Agboola: that we’re looking for. There’s no product id filter. So that’s also that’s also what makes him even trickier.
194 00:26:59.740 ⇒ 00:27:00.710 rebeccaemch: Ma’am.
195 00:27:02.470 ⇒ 00:27:05.139 Demilade Agboola: But I can also remove the.
196 00:27:06.400 ⇒ 00:27:09.949 rebeccaemch: Now I can die even better of my favorite.
197 00:27:17.410 ⇒ 00:27:24.080 rebeccaemch: Oh, yeah, cause some of those where they have changed from one product to another may have been paused
198 00:27:26.020 ⇒ 00:27:29.319 rebeccaemch: so that might help clear some things out for you.
199 00:27:29.540 ⇒ 00:27:30.030 Demilade Agboola: Okay.
200 00:27:31.150 ⇒ 00:27:32.610 Demilade Agboola: I see.
201 00:27:35.260 ⇒ 00:28:09.110 rebeccaemch: No, said Buddy, which is fine.
202 00:28:09.280 ⇒ 00:28:19.239 rebeccaemch: It’s what he wants, sir.
203 00:28:28.908 ⇒ 00:28:31.780 Demilade Agboola: Okay, so we’re moving and paused.
204 00:28:35.430 ⇒ 00:28:53.990 rebeccaemch: Oh, I’ve made a mistake.
205 00:28:54.610 ⇒ 00:28:55.070 rebeccaemch: Companies.
206 00:29:00.120 ⇒ 00:29:03.860 rebeccaemch: He wanted God as well, mostly dirt. And like.
207 00:29:04.550 ⇒ 00:29:28.629 rebeccaemch: yeah, over there, let’s do it.
208 00:29:33.040 ⇒ 00:29:50.060 rebeccaemch: Well, we want to exclude all of the semaglutide, plus b 12, because semaglutide plus b 12 is what we want them to fill. Now.
209 00:29:51.230 ⇒ 00:29:52.100 Demilade Agboola: Oh, okay.
210 00:29:58.450 ⇒ 00:30:02.150 rebeccaemch: Because that’s why we put in lower is not like B, 12.
211 00:30:02.530 ⇒ 00:30:11.049 Demilade Agboola: Yeah. But from the orders it seems that’s like some product. Id numbers 1, 2, 9, 9 is Sema, plus B to B, 12, right.
212 00:30:15.800 ⇒ 00:30:18.339 Demilade Agboola: Because the list you sent out people like.
213 00:30:18.340 ⇒ 00:30:28.329 rebeccaemch: Oh, yes, actually, yes, you are correct. 1, 2, 9, 9 is one of the ones that we do need to cancel, because that’s from precision. I take that back. Sorry.
214 00:30:30.800 ⇒ 00:30:34.700 rebeccaemch: and 2, 6, 8. We do need to discontinue those as well.
215 00:30:34.920 ⇒ 00:30:41.359 Demilade Agboola: So should we? That means from the treatments we do need to see, like how many refills are left right.
216 00:30:42.140 ⇒ 00:30:43.360 rebeccaemch: Yeah. Yep.
217 00:30:43.570 ⇒ 00:30:43.955 Demilade Agboola: Or.
218 00:31:07.650 ⇒ 00:31:08.730 rebeccaemch: As long as manhood.
219 00:31:54.770 ⇒ 00:31:56.063 Demilade Agboola: We have
220 00:32:00.690 ⇒ 00:32:02.980 Demilade Agboola: bachelor fields oops.
221 00:32:28.530 ⇒ 00:32:34.470 Demilade Agboola: Okay? So the but
222 00:32:39.440 ⇒ 00:32:47.019 Demilade Agboola: the pro, so part of part of what I just did now is to add the the product names.
223 00:32:48.120 ⇒ 00:32:54.079 Demilade Agboola: So like. So in the situation where we see, like, these 2 respond like these 2 values.
224 00:32:54.787 ⇒ 00:33:01.590 Demilade Agboola: because they do have orders for both, 2, 6, 8, and 6, 6, 3, 2, or 3, 9.
225 00:33:02.510 ⇒ 00:33:10.759 Demilade Agboola: We can see that the actual value of the actual treatment is this, it’s not this.
226 00:33:11.790 ⇒ 00:33:13.539 Demilade Agboola: So the like.
227 00:33:13.840 ⇒ 00:33:16.010 Demilade Agboola: How to it makes it easier to exclude.
228 00:33:16.240 ⇒ 00:33:18.270 rebeccaemch: These grows where they don’t match.
229 00:33:20.120 ⇒ 00:33:23.680 Demilade Agboola: The problem is that this is still very like
230 00:33:24.760 ⇒ 00:33:29.080 Demilade Agboola: it’s still very weird to use. Still, going to be very clunky to use.
231 00:33:30.020 ⇒ 00:33:32.910 rebeccaemch: Yeah, so
232 00:33:32.910 ⇒ 00:33:46.140 rebeccaemch: looks like 2, 6, 8 is an older formula. And then they switched to 6, 6, 3, 9, which is a newer formula. And so 2, 6, 8 shouldn’t be active anymore. So I don’t know why that’s
233 00:33:46.480 ⇒ 00:33:51.390 rebeccaemch: like that order should be either paused or completed.
234 00:33:51.390 ⇒ 00:33:56.139 Demilade Agboola: So the the reason why we’re seeing this is because it’s coming from the orders.
235 00:33:56.430 ⇒ 00:34:02.090 Demilade Agboola: So this doesn’t speak to the treatment. This is like they’ve placed the order, and they’ve had 2 fulfilled orders of that.
236 00:34:02.090 ⇒ 00:34:03.030 rebeccaemch: Yeah.
237 00:34:04.830 ⇒ 00:34:13.140 Demilade Agboola: But the problem is with treatments like again, this, this is why it’s frustrating. If there was a clear treatment like Id
238 00:34:13.409 ⇒ 00:34:22.410 Demilade Agboola: or a clear treatment like product. Id that we could just use and say, Hey for this product, id match it! To this it would be easy to know, like, hey!
239 00:34:22.730 ⇒ 00:34:29.889 Demilade Agboola: We fulfill 2 of these orders. This has transitioned to this, and therefore the only 2 orders left for this treatment in total.
240 00:34:31.960 ⇒ 00:34:33.340 rebeccaemch: It’s weird.
241 00:34:34.270 ⇒ 00:34:39.140 rebeccaemch: So if we had the treatment web hook.
242 00:34:40.050 ⇒ 00:34:42.560 rebeccaemch: then we would be able to figure this out.
243 00:34:43.139 ⇒ 00:34:48.079 Demilade Agboola: Yeah. So quick. Question. For instance, the 2, 6, 8 also transition to 6, 6, 3, 8.
244 00:34:52.230 ⇒ 00:34:55.509 rebeccaemch: For some patients, but not for all patients.
245 00:34:57.080 ⇒ 00:35:01.569 Demilade Agboola: Cause. I I was. If the duplicate. If the duplicates are like
246 00:35:02.150 ⇒ 00:35:08.479 Demilade Agboola: people transitioning, I would say I could just filter out the orders by the most recent order. Like.
247 00:35:09.170 ⇒ 00:35:10.069 Demilade Agboola: keep bluffing.
248 00:35:10.825 ⇒ 00:35:11.580 rebeccaemch: Correct.
249 00:35:12.380 ⇒ 00:35:12.993 Demilade Agboola: Got him.
250 00:35:17.400 ⇒ 00:35:18.250 Demilade Agboola: Can you hear me?
251 00:35:21.450 ⇒ 00:35:22.120 rebeccaemch: Hmm!
252 00:35:22.970 ⇒ 00:35:23.963 rebeccaemch: I guess.
253 00:35:31.670 ⇒ 00:35:32.500 Demilade Agboola: Hello!
254 00:35:38.220 ⇒ 00:35:38.930 rebeccaemch: Embrace.
255 00:35:40.990 ⇒ 00:35:42.310 Demilade Agboola: Hello!
256 00:35:44.520 ⇒ 00:35:47.089 rebeccaemch: Yeah dude don’t put you right.
257 00:35:58.870 ⇒ 00:36:00.060 rebeccaemch: Okay. Hello.
258 00:36:00.630 ⇒ 00:36:01.629 Demilade Agboola: Oh! Can you hear me?
259 00:36:01.840 ⇒ 00:36:07.829 rebeccaemch: Okay, so sorry. Like the past. Yeah, I haven’t been able to hear anything my Internet dropped. But it’s back up now.
260 00:36:08.150 ⇒ 00:36:15.250 Demilade Agboola: Alright. What what I’m trying to say is this, if things are transitioning like, is this like, if we know that
261 00:36:15.780 ⇒ 00:36:24.589 Demilade Agboola: things are transitions from one phone to another. So in this case we’re transitioning from maybe 2, 6, 8 to 6, 5, 9, 2, 0, 9, 6,
262 00:36:24.850 ⇒ 00:36:31.450 Demilade Agboola: or transitioning from, I don’t know. 2, 6, 8, or 8, 1, 5 to 6, 6, 3, 8.
263 00:36:37.810 ⇒ 00:36:41.600 rebeccaemch: Can we filter it by? If the patient
264 00:36:41.720 ⇒ 00:36:47.860 rebeccaemch: has had a fill in the last 60 days, and then you remove all of the ones prior.
265 00:36:50.580 ⇒ 00:36:55.440 Demilade Agboola: So what what do you mean by feel like they’ve had an order of that product in the last 60 days.
266 00:36:55.440 ⇒ 00:36:55.950 rebeccaemch: Yeah.
267 00:36:56.740 ⇒ 00:37:04.289 Demilade Agboola: Okay. Alright cause I was doing from the beginning of year. So let’s do. Last 60 days. Last 60 days would be.
268 00:37:05.794 ⇒ 00:37:07.289 rebeccaemch: Let me just do.
269 00:37:08.550 ⇒ 00:37:09.120 Demilade Agboola: Right.
270 00:37:10.965 ⇒ 00:37:12.340 rebeccaemch: Because.
271 00:37:21.000 ⇒ 00:37:22.340 rebeccaemch: yeah, just number one.
272 00:37:22.490 ⇒ 00:37:25.699 rebeccaemch: No, I assume it’s a different.
273 00:37:37.230 ⇒ 00:37:41.430 Demilade Agboola: Alright. So we have way, less duplicates. Actually, after this.
274 00:37:44.820 ⇒ 00:37:49.810 rebeccaemch: Okay. Looks like, soon.
275 00:37:53.590 ⇒ 00:37:57.990 Demilade Agboola: I mean there’s still some, though. Seems like it’s cut off again.