Meeting Title: Product ID Treatment Sync Date: 2025-06-20 Meeting participants: Rebeccaemch, Demilade Agboola
WEBVTT
1 00:01:10.280 ⇒ 00:01:11.310 Demilade Agboola: Hello!
2 00:01:13.300 ⇒ 00:01:19.869 rebeccaemch: Oh, I just switched over to my hotspot on my phone instead of my Wi-fi, so maybe this will work better.
3 00:01:23.080 ⇒ 00:01:27.769 Demilade Agboola: Okay, let’s see. Give me one second.
4 00:01:55.820 ⇒ 00:01:56.799 Demilade Agboola: Can you see my screen.
5 00:01:58.470 ⇒ 00:01:59.170 rebeccaemch: Yes.
6 00:02:01.090 ⇒ 00:02:02.729 Demilade Agboola: Oh, okay.
7 00:02:40.410 ⇒ 00:02:44.319 Demilade Agboola: alright. So these are where things can get funky.
8 00:02:44.530 ⇒ 00:02:52.329 Demilade Agboola: So like, we see someone on (383) 813-6593 6, 6, 4, 0.
9 00:02:56.270 ⇒ 00:02:58.060 Demilade Agboola: And it’s the same person.
10 00:02:58.500 ⇒ 00:03:05.759 Demilade Agboola: or in this case, where we have someone that is on 8, 1, 5, 6, 6, 3, 8, 9, 9, 4, 4, 0.
11 00:03:07.460 ⇒ 00:03:09.519 rebeccaemch: All within 60 days.
12 00:03:10.920 ⇒ 00:03:12.980 Demilade Agboola: It appears. Yeah.
13 00:03:13.210 ⇒ 00:03:14.110 rebeccaemch: Wow!
14 00:03:15.160 ⇒ 00:03:17.969 rebeccaemch: That’s not a great experience for them.
15 00:03:21.318 ⇒ 00:03:24.010 Demilade Agboola: Let me look into their individual
16 00:03:32.940 ⇒ 00:03:33.770 Demilade Agboola: poster.
17 00:03:36.400 ⇒ 00:03:43.099 rebeccaemch: I mean theoretically, if they switch from one to another, the other 2 should be paused.
18 00:03:43.810 ⇒ 00:03:48.220 rebeccaemch: So the customer Id is 1 0 0 2, 8, 7, 4.
19 00:03:49.990 ⇒ 00:03:53.210 Demilade Agboola: Yes, but we we don’t.
20 00:03:54.080 ⇒ 00:03:56.149 Demilade Agboola: Pausing is a treatment thing.
21 00:03:57.260 ⇒ 00:04:09.590 Demilade Agboola: The order ids are the product. Ids, not order. Ids, product. Ids are an order stain, there is still no clear, easy way to tie, so even if the the treatment is paused.
22 00:04:10.200 ⇒ 00:04:16.429 Demilade Agboola: we still have an active treatment, and when we want to look at that active treatment across the like, the
23 00:04:16.899 ⇒ 00:04:18.699 Demilade Agboola: the customer.
24 00:04:20.690 ⇒ 00:04:27.310 Demilade Agboola: or the product that they are on it would cascade across all the product ids that appear over the last 60 days.
25 00:04:29.970 ⇒ 00:04:34.810 Demilade Agboola: So because we’re like looking at all the product ids that they have up that they have
26 00:04:35.380 ⇒ 00:04:38.249 Demilade Agboola: gotten an order of in the last 60 days.
27 00:04:39.680 ⇒ 00:04:51.649 Demilade Agboola: What that means is, it’s hard for us to now go. This treatment belongs specifically to this product. Id, so now that they have multiple product ids that they’ve engaged with.
28 00:04:51.800 ⇒ 00:04:59.560 Demilade Agboola: It’s hard to say which of the refills belongs to the particular product. Id for that user.
29 00:05:06.290 ⇒ 00:05:11.780 rebeccaemch: What do we need to ask best for cause? They might choose something today.
30 00:05:12.370 ⇒ 00:05:19.710 Demilade Agboola: Alright. So the the easy, the easy answer would be, if we can tag tie like treatments to
31 00:05:19.820 ⇒ 00:05:28.010 Demilade Agboola: order ids, that’s the easiest one. But potentially, even if we can just add product ids into treatments that would help quite a bit.
32 00:05:34.300 ⇒ 00:05:42.109 rebeccaemch: Okay, do you want to ask for that in the Channel? Or do you want me to ask for that? Because I might word it incorrectly.
33 00:05:43.764 ⇒ 00:05:51.919 Demilade Agboola: I can ask, but like they tend like Zack doesn’t, has like. I’ve been asking for some stuff for the past couple of weeks. He’s not responding to my request, so I.
34 00:05:53.880 ⇒ 00:06:09.409 rebeccaemch: Yeah, I get that. But since he just made this change yesterday at like 10 pm. And he knows like, because I asked him how I’m supposed to tell which patients have a 6 month versus the 12 months. So that way we can credit their account.
35 00:06:09.980 ⇒ 00:06:29.199 rebeccaemch: He said that he gives our data team web hooks. And so we should be able to figure it out. And I was like, Okay, well, I’ll get with them. And if we have any issues, I’ll let you know. So maybe I just he knows how important this is. So maybe he’ll push this through today quickly.
36 00:06:29.680 ⇒ 00:06:30.650 Demilade Agboola: Alright!
37 00:06:32.130 ⇒ 00:06:35.100 Demilade Agboola: I’m I’m sending a sample message that you could send to him.
38 00:06:42.290 ⇒ 00:06:44.349 Demilade Agboola: I have worked that thing
39 00:07:58.820 ⇒ 00:08:03.510 Demilade Agboola: just sent you like a sample of what I’m trying to say.
40 00:08:05.010 ⇒ 00:08:10.580 Demilade Agboola: Basically, the only way we’re tying things right now is just based off the customer.
41 00:08:11.660 ⇒ 00:08:16.349 Demilade Agboola: But like multiple customers can like like one customer. Sorry you can have multiple
42 00:08:17.140 ⇒ 00:08:28.270 Demilade Agboola: products that they’ve engaged in the last 60 days, right? And so that would come up on its own. And if we now look at the treatments that they’re on.
43 00:08:28.650 ⇒ 00:08:37.160 Demilade Agboola: it will just say every single treatment that every single or like every single product that they’ve engaged with has the same number of refills left, which is not true.
44 00:08:37.260 ⇒ 00:08:41.100 Demilade Agboola: but we need to be able to either say, like, Hey, this is the product id in treatment.
45 00:08:41.230 ⇒ 00:08:44.840 Demilade Agboola: So this is product Id, and orders that we care about
46 00:08:46.410 ⇒ 00:08:51.750 Demilade Agboola: or does it like a treatment? Id that we can like, just tie everything neatly together with
47 00:08:54.650 ⇒ 00:09:02.030 Demilade Agboola: I could, I mean, obviously, for the ones that are not duplicates. They’re fine like this. We we’ve been able to make sense of them. I can send that to you.
48 00:09:03.078 ⇒ 00:09:05.849 Demilade Agboola: But the duplicates are where we would have issues.
49 00:09:07.330 ⇒ 00:09:10.430 rebeccaemch: And my team can probably go through those.
50 00:09:10.610 ⇒ 00:09:19.650 rebeccaemch: because honestly, because it’s already in that patient profile, then we’ll be able to see right away if there.
51 00:09:19.650 ⇒ 00:09:20.180 Demilade Agboola: Thank you.
52 00:09:34.617 ⇒ 00:09:40.999 Demilade Agboola: I didn’t hear the very last thing you said. I think you might as well cut out, but I can. I will send you the Csu right now.
53 00:09:44.080 ⇒ 00:09:52.840 rebeccaemch: Or I was just saying that, like my team has to go through every single one of these patients anyways, so they would be able to tell
54 00:09:52.960 ⇒ 00:10:14.639 rebeccaemch: if they have refilled remaining or not, we just have to separate them by like monthly quarterly, 6 month, and 12 month, because the main goal of this exercise is to take all of the patients who are on a quarterly 6 or 12 month, plan and credit them back for any months that they haven’t received yet.
55 00:10:18.010 ⇒ 00:10:20.200 Demilade Agboola: Oh, okay. So I just sent.
56 00:10:24.120 ⇒ 00:10:28.310 Demilade Agboola: I just sent the refill like the the doc from this.
57 00:10:33.740 ⇒ 00:10:41.579 Demilade Agboola: so part of why I put the treatment the product names is, if it would help you figure out like the better way to like tie these things together
58 00:10:42.060 ⇒ 00:10:49.389 Demilade Agboola: because you might see like a semi injection for one file like, for instance, this, this is 2, 6, 8, and 6, 6, 3, 8
59 00:10:50.550 ⇒ 00:10:59.200 Demilade Agboola: but it shows that they are in a semi injection. That’s the treatment. So the trip, the refills are for the treatments, basically right?
60 00:11:00.110 ⇒ 00:11:07.299 Demilade Agboola: And so that allows us to know which of the orders we should be tying the refills back to.
61 00:11:10.060 ⇒ 00:11:10.650 rebeccaemch: Okay.
62 00:11:11.150 ⇒ 00:11:11.830 Demilade Agboola: Yeah, so.
63 00:11:12.580 ⇒ 00:11:13.860 rebeccaemch: Yep.
64 00:11:14.600 ⇒ 00:11:15.660 Demilade Agboola: What’s that?
65 00:11:18.090 ⇒ 00:11:19.392 rebeccaemch: I said, Yep, that makes sense.
66 00:11:19.950 ⇒ 00:11:20.540 Demilade Agboola: Yeah.
67 00:11:20.650 ⇒ 00:11:25.800 Demilade Agboola: So once we see like, this is the product name of the like, different, like
68 00:11:25.980 ⇒ 00:11:30.879 Demilade Agboola: of the of the current treatment that has the you know, the number of refills left
69 00:11:31.050 ⇒ 00:11:38.630 Demilade Agboola: it can help us eliminate in terms of when we have duplicates, eliminate the unnecessary products.
70 00:11:41.660 ⇒ 00:11:52.779 rebeccaemch: Okay, I will send over that sentence that you just sent me in a DM, I’m not seeing a Csv, did you send that via email or slack.
71 00:11:53.060 ⇒ 00:11:59.960 Demilade Agboola: Slack. It’s in the initial request thread that you need on the phone.
72 00:12:00.340 ⇒ 00:12:01.890 Demilade Agboola: I just sent it.
73 00:12:08.590 ⇒ 00:12:13.810 rebeccaemch: Gonna die and race with next to you. Very satisfied.
74 00:12:14.630 ⇒ 00:12:19.889 rebeccaemch: Nice looking road. Okay, we have some wool. Is there anything else we can?
75 00:12:36.580 ⇒ 00:12:38.180 rebeccaemch: Okay, got it.
76 00:12:39.120 ⇒ 00:12:39.990 Demilade Agboola: Okay.
77 00:12:42.960 ⇒ 00:12:43.650 rebeccaemch: Yeah.
78 00:12:55.770 ⇒ 00:12:57.450 rebeccaemch: it’s not loading.
79 00:13:26.880 ⇒ 00:13:30.970 Demilade Agboola: So it’s basically a Csv like the Csv of, like the outreach that I have right here.
80 00:14:15.220 ⇒ 00:14:26.610 rebeccaemch: Okay. I pulled open the Csv. I think this might be good and all we need. Let me play with this a little bit, and if we need
81 00:14:27.820 ⇒ 00:14:33.450 rebeccaemch: more clarity, as I like, bring this to the team and we start getting into it.
82 00:14:34.070 ⇒ 00:14:35.970 rebeccaemch: I will let you know.
83 00:14:36.660 ⇒ 00:14:37.640 Demilade Agboola: Okay. Sounds good.
84 00:14:37.640 ⇒ 00:14:41.990 rebeccaemch: We’ll still ask Zach for the the treatment thing.
85 00:14:42.680 ⇒ 00:14:48.490 Demilade Agboola: Yeah, like it’ll, it’ll make this. This would literally have been a 5 min request.
86 00:14:48.860 ⇒ 00:14:53.280 Demilade Agboola: if that that, like the things I mentioned were available, either. One of those 2 things were available.
87 00:14:53.460 ⇒ 00:14:56.670 Demilade Agboola: But because there’s no product id in treatment
88 00:14:57.170 ⇒ 00:15:12.830 Demilade Agboola: because you needed to filter out certain product ids, I’ll just have gone filtered out those product ids. And that gave give me the customize. And how many referrals are left for those product ids. But there isn’t a product. It’s just product name, and that that makes it very tricky to handle for that.
89 00:15:16.380 ⇒ 00:15:24.049 Demilade Agboola: So yeah, like, if I don’t know this, if he, if he can make that available that will make everything so much much easier.
90 00:15:27.980 ⇒ 00:15:31.270 rebeccaemch: Okay, sounds good. I’m on it. Thank you so much for your help.
91 00:15:31.420 ⇒ 00:15:33.400 Demilade Agboola: You’re welcome. Have a great day.
92 00:15:34.060 ⇒ 00:15:36.039 rebeccaemch: You too, bye.