Meeting Title: Pharmacy Team Data Sync Date: 2025-07-16 Meeting participants: Fireflies.ai Notetaker Tigran, Awaish Kumar, Henry Zhao, Robert Tseng, Annie Yu, Amber Lin, Demilade Agboola, Mitesh Patel
WEBVTT
1 00:01:17.180 ⇒ 00:01:18.820 Robert Tseng: Hello! Hello!
2 00:01:25.960 ⇒ 00:01:28.300 Robert Tseng: What’s going on here?
3 00:01:42.900 ⇒ 00:01:45.340 Robert Tseng: Hello! Can! Can can anyone hear me?
4 00:01:46.010 ⇒ 00:01:46.730 Annie Yu: Yes.
5 00:01:46.870 ⇒ 00:01:47.510 Robert Tseng: Okay.
6 00:01:48.120 ⇒ 00:01:49.729 Robert Tseng: Alright. Thank you.
7 00:01:59.200 ⇒ 00:02:04.770 Robert Tseng: Okay, give me like one sec. I’m gonna pull up some stuff and then get into it.
8 00:02:35.560 ⇒ 00:02:38.719 Robert Tseng: Okay, let’s get started.
9 00:02:44.320 ⇒ 00:02:45.600 Robert Tseng: Okay, so
10 00:02:47.080 ⇒ 00:02:57.599 Robert Tseng: today’s fair. I’m just gonna go through the existing tickets in this cycle. Just wanna kind of keep moving things along. And then, yeah, I will.
11 00:02:58.830 ⇒ 00:03:01.301 Robert Tseng: I, yeah, we’ll just we’ll just do that.
12 00:03:02.440 ⇒ 00:03:14.479 Robert Tseng: so couple of things. Top of mind, yeah. One is the booth win situation. This is something that the pharmacy team is continually see? Continuously asking for. So
13 00:03:14.980 ⇒ 00:03:21.320 Robert Tseng: I mean, there’s a couple of related requests to the farm farm Ops team. But I just wanna make sure that we’re all on track here. So
14 00:03:21.861 ⇒ 00:03:29.710 Robert Tseng: I know that I guess Dame Lot is not on this call, so I won’t hit on the 1st thing that Rebecca brought up yesterday. But
15 00:03:30.090 ⇒ 00:03:33.329 Robert Tseng: yeah, Annie, you share this. Csv.
16 00:03:33.852 ⇒ 00:03:37.209 Robert Tseng: yeah, you mentioned that there are some nulls here.
17 00:03:38.440 ⇒ 00:03:42.795 Robert Tseng: I guess, did she? I don’t see where you shared this with her.
18 00:03:45.130 ⇒ 00:03:49.000 Robert Tseng: did she like, is she okay with this like I just wanna I don’t know.
19 00:03:49.000 ⇒ 00:03:51.349 Annie Yu: No, I think she hasn’t, replied.
20 00:03:52.060 ⇒ 00:03:57.711 Robert Tseng: Okay, okay, I see it in in slack now. And
21 00:04:02.790 ⇒ 00:04:09.270 Robert Tseng: when you, when we say quite a few nulls like, what is like, what does that mean like? How do we quantify it like?
22 00:04:09.680 ⇒ 00:04:13.489 Robert Tseng: Is it 20 sentinels, or like.
23 00:04:16.100 ⇒ 00:04:23.309 Annie Yu: So there are separate fields. So there’s a dosage, and there’s unit of measures.
24 00:04:24.310 ⇒ 00:04:29.649 Annie Yu: And then we have dispense quantity, and I’m aggregating each.
25 00:04:30.140 ⇒ 00:04:38.949 Annie Yu: I’m aggregating by product, name, and dosage, and then show how many
26 00:04:39.330 ⇒ 00:04:43.040 Annie Yu: dispense quantity, how many quantity was dispensed.
27 00:04:44.232 ⇒ 00:04:57.839 Annie Yu: There are just so for each product. There are one row that’s with like no value in dosage.
28 00:04:58.000 ⇒ 00:05:04.140 Annie Yu: and the total dispense quantity for those rows are pretty high numbers.
29 00:05:04.270 ⇒ 00:05:09.649 Annie Yu: But I don’t think we can do anything as of now.
30 00:05:12.123 ⇒ 00:05:16.026 Annie Yu: If you see the Csv. That I shared you.
31 00:05:16.460 ⇒ 00:05:17.920 Robert Tseng: Have it open here.
32 00:05:18.430 ⇒ 00:05:21.709 Annie Yu: Yeah. So I think for that 1st row.
33 00:05:22.750 ⇒ 00:05:24.210 Annie Yu: That’s no.
34 00:05:29.510 ⇒ 00:05:41.130 Robert Tseng: I mean, Lotte said, that we don’t really have dosages for things beyond Semaglutide. This is coming straight from Rebecca. Right? So if this, if if we’re missing stuff here that’s on her or like I’m trying, I’m trying to understand.
35 00:05:41.130 ⇒ 00:05:42.260 Annie Yu: No, no, no.
36 00:05:42.260 ⇒ 00:05:42.960 Robert Tseng: Yeah, we yeah.
37 00:05:42.960 ⇒ 00:06:01.689 Annie Yu: We’re not using the Google sheet that she filled out. The the model that’s using that currently, we don’t have any date or time based field. So we can’t really tell. Like, if it was from January to May or so. So we’re just using would. It’s a
38 00:06:02.140 ⇒ 00:06:08.290 Annie Yu: I think it’s a raw table from baskets. Bask order, update.
39 00:06:09.090 ⇒ 00:06:12.179 Demilade Agboola: And then join that with fact. Transactions.
40 00:06:12.320 ⇒ 00:06:14.010 Annie Yu: And thin products.
41 00:06:14.270 ⇒ 00:06:17.780 Annie Yu: So we’re not using that Google sheet that she shared.
42 00:06:21.450 ⇒ 00:06:22.270 Robert Tseng: Okay.
43 00:06:23.010 ⇒ 00:06:31.680 Robert Tseng: yeah, I’m not sure the details. There. I mean, I’m just trying to receive this as Rebecca. If I’m Rebecca and I receive this I would be like.
44 00:06:32.020 ⇒ 00:06:33.030 Robert Tseng: well.
45 00:06:33.490 ⇒ 00:06:43.720 Robert Tseng: I don’t really know what to make sense of this. Do I just sum this column and send it to Boothway and say, this is how much you should have paid like I think it’s we gotta like, do some of the
46 00:06:43.890 ⇒ 00:06:44.720 Robert Tseng: we got.
47 00:06:45.070 ⇒ 00:06:56.510 Robert Tseng: We gotta let her know like what constraints there are like. I understand that you wrote that there are some nulls here, but like I don’t think this necessarily I don’t. I don’t think this would be enough for her, because I yeah, I would. I mean
48 00:06:56.950 ⇒ 00:06:58.340 Robert Tseng: on what you should do.
49 00:06:59.020 ⇒ 00:07:05.260 Annie Yu: Yeah, we we are also aware of that. But I don’t really know if there’s a better solution as no.
50 00:07:10.099 ⇒ 00:07:13.490 Demilade Agboola: Yeah. So we have the data from January to May.
51 00:07:14.350 ⇒ 00:07:25.979 Demilade Agboola: I think it would really help if we knew what level of like, so we could do from like each month, January, February, March, April, May. But since hubs themselves change like
52 00:07:27.530 ⇒ 00:07:35.230 Demilade Agboola: change over time, and we don’t have a historical cloud sheets, which is what I’ve been trying to get. We we’ve only Rebecca.
53 00:07:35.350 ⇒ 00:07:37.810 Demilade Agboola: so please send us if it doesn’t exist.
54 00:07:38.050 ⇒ 00:07:40.820 Demilade Agboola: I’ve spoken to Rebecca about how we can deal with that.
55 00:07:42.010 ⇒ 00:07:48.159 Demilade Agboola: And she asked me for, like you know, product, I said, I’ll do all of them. But we could start off with Sema
56 00:07:48.726 ⇒ 00:08:08.889 Demilade Agboola: but there isn’t a historical courtship that we can go, hey? From orders between this date and this date. They will make that calculation of how much it should have cost them. How much bookings have gotten. So the best we can do is either find the level of granularity that she wants or she desires, and show. This is how much you dispense within that period
57 00:08:10.860 ⇒ 00:08:13.039 Demilade Agboola: got the code. So then they applied to it.
58 00:08:18.880 ⇒ 00:08:29.949 Robert Tseng: Okay, yeah. I mean, I understand. I understand that. There, there’s yeah. I I don’t think that’s communicated to her. I don’t think she understands like what she’s looking at here. So like, I think
59 00:08:30.180 ⇒ 00:08:53.309 Robert Tseng: we need to like write. It’s it’s just a matter of presentation. I’m not necessarily saying we can or can’t do anything more. It’s just like we sent her a Csv and didn’t really give her much context. It was just like, Hey, here it is, some of this is null, and it’s like, Well, I don’t know what she’s going to do with that. So we need to tell her we could. There’s 20% missing. We could be doing better if we had Xyz from you.
60 00:08:53.520 ⇒ 00:09:01.529 Robert Tseng: But this is what we have so far like. Let’s hop on a call. If you have any questions like, I think that’s that’s what it? That’s what I want to see more from when we’re like sharing
61 00:09:01.530 ⇒ 00:09:03.189 Robert Tseng: sharing stuff with the stakeholders.
62 00:09:08.400 ⇒ 00:09:11.349 Robert Tseng: Okay, so can we rework this and like, try to.
63 00:09:11.570 ⇒ 00:09:28.080 Robert Tseng: It’s not. It’s just a matter of presentation. It’s just a matter of like making sure she knows what she’s receiving, what she’s doing, what the next steps could be. And then, yeah, I mean, this is important, for we need to get her attention. She needs to. She needs to get on the call with you, even if she hasn’t responded. So I think like
64 00:09:28.530 ⇒ 00:09:31.269 Robert Tseng: that’s, I think that’s what we’re missing here.
65 00:09:33.360 ⇒ 00:09:42.089 Robert Tseng: Okay, so yeah, please follow up with her like using what I’ve described here.
66 00:09:46.820 ⇒ 00:09:48.420 Robert Tseng: Okay, we’ll move on.
67 00:09:49.900 ⇒ 00:09:54.510 Robert Tseng: Yeah. Marketing stuff. I would say, Mattesh hasn’t really said anything, so I’m gonna skip that
68 00:09:55.063 ⇒ 00:09:59.030 Robert Tseng: I will call out that on the refunds. I don’t know if refunds is still in cycle.
69 00:09:59.140 ⇒ 00:10:02.459 Robert Tseng: But I think that’s a
70 00:10:05.860 ⇒ 00:10:10.180 Robert Tseng: I’m just gonna have but who worked on the last refund ticket.
71 00:10:13.730 ⇒ 00:10:15.889 Demilade Agboola: I believe I did. It was a spike
72 00:10:16.010 ⇒ 00:10:18.419 Demilade Agboola: to figure out what was gonna do with us.
73 00:10:18.420 ⇒ 00:10:19.080 Robert Tseng: Okay?
74 00:10:19.280 ⇒ 00:10:23.006 Robert Tseng: Yeah. Yeah. Can you meet with
75 00:10:25.760 ⇒ 00:10:27.300 Robert Tseng: What’s her name? Katie?
76 00:10:37.790 ⇒ 00:10:38.585 Robert Tseng: Yeah,
77 00:10:50.280 ⇒ 00:10:52.290 Robert Tseng: we’re gonna do this.
78 00:10:59.730 ⇒ 00:11:09.109 Robert Tseng: Yeah. If you could just reach out to Katie. Say that you’re gonna talk to her about refunds. She’s like pinging me doesn’t still like doesn’t understand where we’re at like. I think there’s just the pharmacy team.
79 00:11:10.440 ⇒ 00:11:29.099 Robert Tseng: you know. There’s an operational crunch. People are freaking out because performance is not great. I feel like we’re not doing a good job of like keeping them updated on the progress we’re making on data. So I’m just getting random dms from Rebecca, from Katie being like, Hey, can we hop on a call, and like.
80 00:11:29.100 ⇒ 00:11:55.069 Robert Tseng: if I have to hop on a call with them, then we’re not communicating well with them. So like I’m not the one making these changes and the sending the Csv, there’s they’re clearly not seeing it. And so we need to get in front of them like more with with with the updates. So once again, it’s like another ticket. That’s not necessarily any engineering work. It’s just getting her getting them aligned on stuff. So I think we’re missing that last mile right now, especially with this team
81 00:11:55.070 ⇒ 00:12:06.103 Robert Tseng: where they’re just not. I don’t. They’re not looking, or that I don’t know. We’re not making enough noise like whatever it is like, I think you guys need to be need to own like the the handoff. Once we’ve once we’ve
82 00:12:06.520 ⇒ 00:12:13.603 Robert Tseng: once we ship something. So I’m just flagging that as like something that as well. So
83 00:12:14.360 ⇒ 00:12:18.409 Robert Tseng: yeah, if you could just grab time with her and and meet with her. I think that would be
84 00:12:18.860 ⇒ 00:12:22.513 Robert Tseng: that that would get that off my my plate.
85 00:12:24.510 ⇒ 00:12:29.101 Robert Tseng: okay? And then, yeah, we were saying we were gonna test and shift this
86 00:12:33.490 ⇒ 00:12:35.019 Robert Tseng: Where are we with it? With this.
87 00:12:41.100 ⇒ 00:12:42.100 Demilade Agboola: Oh, no.
88 00:12:42.920 ⇒ 00:12:44.339 Demilade Agboola: Gotten the package. That’s okay.
89 00:12:46.400 ⇒ 00:12:52.499 Demilade Agboola: Oh, yeah, it’s still accepting but yeah, I was like, I’ll stick it today.
90 00:12:53.309 ⇒ 00:13:00.649 Demilade Agboola: Urban central, like higher priority estate, because we’re trying to make sure that we get like the numbers are in front of them.
91 00:13:01.231 ⇒ 00:13:03.759 Demilade Agboola: But yeah, we’ll definitely. I’ll take this to the.
92 00:13:07.830 ⇒ 00:13:10.330 Robert Tseng: Okay, yeah, please, please get this out today.
93 00:13:10.470 ⇒ 00:13:11.250 Robert Tseng: Yeah.
94 00:13:13.342 ⇒ 00:13:28.549 Robert Tseng: Like, yes. The due date was shift shifted to yesterday. But they asked for this, like, you know, 4 weeks ago. And yeah, I think, just yeah. Anyway, I think we’re just kind of slowing down on on the pharmacy side. And I like, I think that it’s it’s starting. The backlog is starting to catch up.
95 00:13:29.460 ⇒ 00:13:31.710 Robert Tseng: Okay, cogs updates.
96 00:13:35.717 ⇒ 00:13:39.652 Demilade Agboola: So yes, I have conversations with Rebecca and Christiana.
97 00:13:40.780 ⇒ 00:13:52.490 Demilade Agboola: they don’t have access to the historical cogs. Well, they don’t have a historical cogs data, but I would ask them if we can rebuild it. So I have had a conversation with Rebecca about that.
98 00:13:52.630 ⇒ 00:13:54.760 Demilade Agboola: She’s asking for where?
99 00:13:54.980 ⇒ 00:14:07.210 Demilade Agboola: Like, if, like what we want, what scope, what the scope should be, I said ideally, I want us to do everything. But obviously the most important should be summer, because summer is, you know, the
100 00:14:07.480 ⇒ 00:14:10.840 Demilade Agboola: largest or the biggest seller amongst what we have.
101 00:14:11.351 ⇒ 00:14:22.789 Demilade Agboola: But yeah, so I’m just trying to work with them to be able to build out like that historical archive of like different days in which exchange, because it wasn’t. It wasn’t a team that was explicitly noted.
102 00:14:22.920 ⇒ 00:14:33.040 Demilade Agboola: and as a result, like they just change the values of the call sheets and the different sheets without like matching when it was valued from the value to. And that’s why we don’t have a historical
103 00:14:33.707 ⇒ 00:14:38.780 Demilade Agboola: data. In some cases we also put the new value in there. So that’s why we have duplicate calls.
104 00:14:39.010 ⇒ 00:14:43.260 Demilade Agboola: But just being able to prove on the system is kind of what is a work in progress. Basically.
105 00:14:44.050 ⇒ 00:14:49.530 Robert Tseng: I thought Christiana said was gonna give you like a was gonna get you something like last week.
106 00:14:52.100 ⇒ 00:15:00.579 Demilade Agboola: Yeah, I I reached out to her about that, she because I asked for she was going to reach out to Rebecca and get the historical plugs.
107 00:15:00.740 ⇒ 00:15:10.850 Demilade Agboola: she said, that doesn’t exist. So she’s Rebecca. And so Rebecca and I are talking about everything, how to build that out that historical fox data out.
108 00:15:22.600 ⇒ 00:15:24.350 Demilade Agboola: okay, this is your conversation.
109 00:15:25.100 ⇒ 00:15:30.979 Robert Tseng: Yeah, you can see some of the conferences. Here’s here’s separate thing. So I mean, like related. But yeah, I think
110 00:15:33.680 ⇒ 00:15:43.340 Robert Tseng: pair for a deep dive web hook, plus missing data. With with basket.
111 00:15:58.320 ⇒ 00:16:03.360 Robert Tseng: I think we have a lot of like floating things. Of like.
112 00:16:05.340 ⇒ 00:16:26.579 Robert Tseng: yeah, just these these data issues. I’ve I’ve asked Josh to set up time with mask we’re having like a 1 h deep dive with them next week. I think I’ll probably include Demode and and Henry on that call for sure. I think I’ll decide if we want to include in more people. Probably not and so they’re gonna basically come to that meeting. And we’re gonna
113 00:16:27.260 ⇒ 00:16:34.430 Robert Tseng: be able to. We’re gonna be able to tell them like this is what’s missing, or whatever. So you have a log of all these things, of
114 00:16:34.530 ⇒ 00:16:44.330 Robert Tseng: what limited capabilities we have from bask. I would like you to kind of put it in a notion, Doc, so that we can start to build this kind of
115 00:16:44.900 ⇒ 00:17:04.159 Robert Tseng: and build this out together, and I want to send it to them as a pre-read by end of the week. So I’m tentatively scheduling. That call for Tuesday is kind of what I’m aiming for. Hopefully, that gives us enough time to to get everything. But yeah, I think just I would say even this, this situation that you’re describing of historical Cox changes.
116 00:17:04.160 ⇒ 00:17:27.346 Robert Tseng: I mean bask should have a reflection of all of those events that they fire in the Ui when we’ve made changes so they should be able to provide that data. So I would say that that’s even something that even if Rebecca is not doing like, if we keyed in those changes which we had to in order to get it to work in bask. That’s what that should have been reflected in like. That’s something that we should be able to get from them as well.
117 00:17:28.220 ⇒ 00:17:29.730 Robert Tseng: Does that make sense.
118 00:17:34.430 ⇒ 00:17:40.160 Demilade Agboola: Yes, I agree. There’s just a lot of like data gaps, and especially for this matter of bugs.
119 00:17:40.671 ⇒ 00:17:53.949 Demilade Agboola: It’s not. I don’t even think it’s sustainable to have them keep building out changes every single time, because they’ll have to reflect that team across multiple systems. And I don’t think our system will necessarily be the highest priority.
120 00:17:55.085 ⇒ 00:17:58.790 Demilade Agboola: So just being able to go, that’s all we are. Yeah.
121 00:17:59.500 ⇒ 00:18:11.601 Robert Tseng: Yeah, let’s consider this this like our one time, like opportunity to just tell Bask everything that’s wrong with the data we’re getting from them. Yeah. And I would consider this part of part of that. So
122 00:18:13.150 ⇒ 00:18:18.830 Robert Tseng: I think that’s that’s what we that’s what we can do. Heading into early next week.
123 00:18:22.470 ⇒ 00:18:27.359 Robert Tseng: Okay? And then last thing on you, Dan Lotto, before I move on, I just, I’m like.
124 00:18:28.640 ⇒ 00:18:41.420 Robert Tseng: and the Rebecca mentioned something about it’s like, yeah, just, I’m just pulling this. So what you’re this is, is this related like, what am I looking at? Here?
125 00:18:49.080 ⇒ 00:18:52.059 Demilade Agboola: So she’s asking for like an aggregation of
126 00:18:52.590 ⇒ 00:18:58.125 Demilade Agboola: the data, basically of the different astronomises and files.
127 00:18:58.860 ⇒ 00:19:02.130 Demilade Agboola: but that requires some of the
128 00:19:02.960 ⇒ 00:19:05.099 Demilade Agboola: like. We can do what we have.
129 00:19:05.440 ⇒ 00:19:14.139 Demilade Agboola: But like, since we’ll not be getting basket ex exports regular, there will be some gaps that technically there will be some data gaps that we can just accounts for.
130 00:19:14.280 ⇒ 00:19:21.620 Demilade Agboola: So we could do what we have. That’s fine. But like it would not necessarily be the fullest range of everything.
131 00:19:21.880 ⇒ 00:19:28.710 Demilade Agboola: because there is a limitation on fast, and the constant like data exports that have not been happening every week.
132 00:19:31.340 ⇒ 00:19:37.969 Robert Tseng: Yeah. So as long as they get us the consistent product, you know, lists all these like
133 00:19:38.280 ⇒ 00:19:42.499 Robert Tseng: parameters, are they there like all these? All these attributes, I guess.
134 00:19:46.540 ⇒ 00:19:49.438 Demilade Agboola: Yeah. A large percentage of the address are there?
135 00:19:49.760 ⇒ 00:19:56.439 Robert Tseng: Okay. So it’s just that because we haven’t been getting weekly product updates from bask, we cannot do this.
136 00:19:59.273 ⇒ 00:20:00.340 Demilade Agboola: Yeah, basically.
137 00:20:01.450 ⇒ 00:20:02.110 Robert Tseng: Okay?
138 00:20:04.990 ⇒ 00:20:12.900 Robert Tseng: Well, yeah. So this would be another thing. I would log in that sheet that you’re that you’re gonna start. So like, yeah, does that? Okay? So I think, this is
139 00:20:14.920 ⇒ 00:20:39.108 Robert Tseng: I, I mean, I feel like we. We get a lot of these ad hoc requests, and we’re blocked by the same things. And then we spend a lot of time talking through like oh, and like, you know, we’re pointing, pointing fingers at like different things. And it’s we understand that like, it’s the same stuff that’s like causing us to be blocked. I don’t think it’s communicated well, in like a central place. So I think, even even before we present that to to
140 00:20:39.740 ⇒ 00:20:44.569 Robert Tseng: to basketball, and I’ll make sure Rebecca’s on that call, too. So whatever that that
141 00:20:44.940 ⇒ 00:20:55.929 Robert Tseng: as we’re preparing for that talk with Basque next week. Yeah, I just, I think it’ll be just good to align with everyone team. So we stop spending time like
142 00:20:56.110 ⇒ 00:21:07.203 Robert Tseng: saying the same thing like, I feel like, this is like, I’ve yeah, anyway. So I think that’s that’s what we need to do from like a like a client management perspective.
143 00:21:07.740 ⇒ 00:21:13.199 Robert Tseng: they’re just sending us down rabbit holes that we cannot solve because we’re running into the same issues.
144 00:21:21.890 ⇒ 00:21:25.619 Robert Tseng: Okay? So I’m also gonna pull that in
145 00:21:29.950 ⇒ 00:21:33.470 Robert Tseng: last thing on the yeah. I guess
146 00:21:35.630 ⇒ 00:21:43.629 Robert Tseng: later, later, today, I’m Henry and I are gonna meet with Bobby. We’re gonna ask more stuff on the customer. I/O side.
147 00:21:44.094 ⇒ 00:22:04.809 Robert Tseng: And then, yeah, I guess. Well, that’s that’s that. I guess there are a couple other things that were blocked. Anything that’s in blocked, I would say. My pharmacy forecast is still blocked. End of month is coming up soon. Finance is gonna like be hounding me for this, probably starting next week. So like, when can I start this with
148 00:22:05.088 ⇒ 00:22:19.559 Robert Tseng: with our vile like I just, I don’t feel confident in our in our in our model yet, like we I don’t know what the quant. I don’t know how to quantify the notes yet. Like I just, I’m what’s what is going on like we’ve we’ve been blocked here for like
149 00:22:19.700 ⇒ 00:22:21.590 Robert Tseng: for for a while, like I.
150 00:22:24.230 ⇒ 00:22:28.550 Demilade Agboola: This works, but there are limitations to it. The limitations are
151 00:22:29.041 ⇒ 00:22:49.599 Demilade Agboola: number one. It’s literally only summer. And when the whole booking request came in. It was not just going to be semi. It was just literally it was booking as a host. So we decided to use the bus Updated web book to see that. So that had that had an all of them. And that’s what was reflected in the Dosage
152 00:22:51.770 ⇒ 00:22:58.729 Demilade Agboola: what we have does exist. And also the problem is what we do. Well, the model only attributes it to
153 00:22:59.120 ⇒ 00:23:06.230 Demilade Agboola: the current state and time. So at any point in time, it tells us how many valves are being shipped, and how many valves are
154 00:23:06.410 ⇒ 00:23:08.750 Demilade Agboola: going to the ship at that point in time.
155 00:23:09.530 ⇒ 00:23:14.200 Demilade Agboola: What Rebecca’s request was was, she’s
156 00:23:14.340 ⇒ 00:23:23.800 Demilade Agboola: at the different points in time. How many valves are shipped on the second day, and a certain time which the model could we could rework, is but given the fact that it only Stemmer.
157 00:23:24.290 ⇒ 00:23:31.169 Demilade Agboola: I didn’t see the upside and reworking it for just a smaller use case when there are other things that could also be there as well.
158 00:23:31.763 ⇒ 00:23:37.099 Demilade Agboola: So that’s why I decided to just aggregate it based off the web hook in basket.
159 00:23:37.572 ⇒ 00:23:46.539 Demilade Agboola: So this still works. But again. It’s literally just going to be semi upsetting variants, because, although some variants don’t have anything in there as well.
160 00:23:49.300 ⇒ 00:24:14.889 Robert Tseng: Okay. So to me, this is another opportunity where we’re gonna put in the Basque, Doc, it’s like, Hey, this is our care capability. We can only accurately report to this level of granularity for a single pharmacy on a single set of product category like a single product category. We need the ability to expand this across other products. We’re limited or like, we get nulls in Xyz areas like I. So I think that this is another one, that to to add to the to to the doc.
161 00:24:19.470 ⇒ 00:24:23.139 Robert Tseng: Okay? So yeah, I I think there’s.
162 00:24:24.220 ⇒ 00:24:53.279 Robert Tseng: I’m I’m sure you have a handle of it. I think we’re just trying to get it to a place where we can communicate it like, yes, we’re blocked. We need to communicate the blocker so we can get unblocked. We don’t want to be limited to just what we currently have. We have the opportunity to put to put it back in like, I mean, I’m trying to create that forum so that we can like actually just bring it to bass directly they can choose not to fix it. But at least everybody will know that this is. These are the like perennial issues that we’re dealing with. And like, I think
163 00:24:53.360 ⇒ 00:24:59.919 Robert Tseng: we just yeah like that’ll help defend us from like having to take on random ad hoc stuff that we’re not able to do.
164 00:25:04.130 ⇒ 00:25:14.736 Robert Tseng: Okay? So yeah, I think this is kind of double clicks to me that this is like it really important for us to kind of get get squared away on.
165 00:25:15.200 ⇒ 00:25:26.000 Robert Tseng: okay, we’ve kind of gone through a lot of this already. Yeah, once again, this is like vile quantities. This treatment journey summary is not
166 00:25:26.130 ⇒ 00:25:35.339 Robert Tseng: urgent yet. So I don’t think we’re gonna end up taking this on this cycle. So I’ll probably move this out. Or I will. We can do later. Yeah.
167 00:25:36.730 ⇒ 00:25:44.568 Robert Tseng: anything else I’m missing. I think. You know, Henry, we’re gonna talk later. So we didn’t really mention anything from our from from your scope. But
168 00:25:45.860 ⇒ 00:25:50.790 Robert Tseng: yeah, Damalade and Annie, I guess, are kind of what? Anything else.
169 00:25:54.640 ⇒ 00:25:57.430 Mitesh Patel: If you’re done. I have a couple of quick questions.
170 00:25:58.390 ⇒ 00:25:59.489 Robert Tseng: Yeah. Go ahead.
171 00:25:59.710 ⇒ 00:26:08.209 Mitesh Patel: Yeah. So I’ll I just put them in the notes. But in analytics, only a little while ago, maybe an hour hour and a half ago I posted a question about
172 00:26:08.340 ⇒ 00:26:14.109 Mitesh Patel: the each time I look at the product Roas, Ltv report.
173 00:26:15.025 ⇒ 00:26:19.440 Mitesh Patel: The new customer count number declines.
174 00:26:20.667 ⇒ 00:26:23.660 Mitesh Patel: I’d like to understand why that’s happening.
175 00:26:24.540 ⇒ 00:26:28.040 Mitesh Patel: You know. Are we like removing cancellations?
176 00:26:28.675 ⇒ 00:26:55.609 Mitesh Patel: And and what it? What it affects is, you know, from a marketing perspective. I have to drive. I make campaign and and channel investment decisions based on that target. Ncac, right? Since the spend remains the same, the Ncac keeps growing of like like June Ncac. When I was looking at the looking at it at the end of June, was, you know, well, within our target of 500 or lower for injectable Sema.
177 00:26:56.255 ⇒ 00:27:00.210 Robert Tseng: On Sunday that Ncat, because a new customer count had.
178 00:27:00.530 ⇒ 00:27:21.679 Mitesh Patel: Is lower now for June. The Ncac. Had grown to 534 today, you know, 3 days later it’s 536. So just why, you know, I can’t have a moving target for Ncac. Love for your thoughts on how you know one. Why is that number changing? And 2. How can we address this moving Ncac.
179 00:27:24.980 ⇒ 00:27:36.509 Robert Tseng: Yeah, I think, number one. You’re right, I think. It’s just the business cancellations, because they all start in abandoned state or whatever, and like at least in the product roast. I don’t think it should. It should already.
180 00:27:37.240 ⇒ 00:27:56.290 Robert Tseng: I mean, I think I need. We need to double check on it shouldn’t be moving as much in the for Josh report, which I think is not the same report. He wants to view it like a. He wants to see a daily like customer account of like, like maximum potential, new or or customer orders. So we include everyone in there. But then for the other dashboards. We’re only including those that are like valid. So.
181 00:27:56.290 ⇒ 00:27:59.990 Mitesh Patel: That’s the only one that’s the only one I had. The 4 Josh report like.
182 00:28:00.040 ⇒ 00:28:27.029 Mitesh Patel: you know, the the numbers are changing on the row as Ltv. Dashboard. But you know I was like, I remember, a lower row as the only way. The only place I could find in you know anything close is. I was looking at the 30 day number from the report that ran on July first.st So if the 3, rd I know that yesterday’s data includes, you know, orders that might still that that are still not confirmed. But does the 30 day number also include that?
183 00:28:27.480 ⇒ 00:28:29.759 Mitesh Patel: If it does, that explains it right.
184 00:28:29.760 ⇒ 00:28:30.430 Robert Tseng: Yeah.
185 00:28:30.430 ⇒ 00:28:38.480 Mitesh Patel: But definitely the product roas. Ltv dashboard report is changing also, are they
186 00:28:39.300 ⇒ 00:28:40.780 Mitesh Patel: number, and it is dropping.
187 00:28:41.740 ⇒ 00:28:59.710 Demilade Agboola: Yeah, I would have to look into that. That should not drop. There should be no drop in the numbers over time. But yeah, the for just report is based off, like household potentially abandon orders that could potentially convert so that can drop over time. So I think
188 00:29:00.010 ⇒ 00:29:09.629 Demilade Agboola: that report in terms of looking at caps or any caps, might not be the most useful, so it will just be set up for us, which obviously should not help, so we’ll have to look into that and get back to you and.
189 00:29:09.630 ⇒ 00:29:30.190 Mitesh Patel: Yeah, I wasn’t looking at that report for ncax. I don’t right, I but I was like, I remember then it being better when I looked at. You know the Roas report at the end of June and early January, but I didn’t have a snapshot of it. I didn’t have a copy of it, that’s all. That’s why I was like maybe the 3.rd I can rely on the 30 day number from the for Josh report, but I understand.
190 00:29:30.360 ⇒ 00:29:31.200 Mitesh Patel: Alright.
191 00:29:31.756 ⇒ 00:29:41.559 Mitesh Patel: Demoda, did you have a chance to look into? And are you able to pull any new product ids from basket? Or is that the same blocker you’re dealing with.
192 00:29:41.990 ⇒ 00:29:51.783 Robert Tseng: Yeah, same blocker. We’ve been trying to get them to send it weekly. Between that and like what we get internally from Christiana like, that’s how we update our product.
193 00:29:52.090 ⇒ 00:29:52.530 Robert Tseng: yeah.
194 00:29:52.530 ⇒ 00:29:56.930 Robert Tseng: So they don’t send it to us daily. Yeah. So.
195 00:29:57.960 ⇒ 00:29:58.570 Mitesh Patel: Okay.
196 00:29:58.860 ⇒ 00:30:12.270 Robert Tseng: Yeah, I I mean, we’re we’re we’re gonna meet with Bass next next week. I think you had Josh set it up. So this is something that I’m gonna flag like, basically, yeah, anyway. So I’m trying to push them to get send this to us daily.
197 00:30:12.970 ⇒ 00:30:14.000 Mitesh Patel: Alright, awesome.
198 00:30:14.000 ⇒ 00:30:14.350 Robert Tseng: Yeah.
199 00:30:14.350 ⇒ 00:30:23.839 Mitesh Patel: And then, I think the last last week I joined a meeting where I asked for the marketing reports. Just a different view of it with a date filter where I can, instead of just by week.
200 00:30:25.610 ⇒ 00:30:29.640 Robert Tseng: Yeah, I think we’ve did. We finish that? Annie?
201 00:30:30.890 ⇒ 00:30:32.320 Annie Yu: Which one is that for.
202 00:30:36.320 ⇒ 00:30:39.040 Robert Tseng: I don’t see it in. Okay.
203 00:30:39.040 ⇒ 00:30:41.019 Mitesh Patel: You added it to this list.
204 00:30:43.100 ⇒ 00:30:50.210 Robert Tseng: Okay, I mean, yeah, it’s possible I might have. I might have not. I thought I might have.
205 00:30:50.430 ⇒ 00:30:58.310 Robert Tseng: Yeah, sorry. I think I might have not added it in related to that.
206 00:30:58.310 ⇒ 00:30:59.750 Annie Yu: That’s a marketing.
207 00:30:59.750 ⇒ 00:31:00.130 Robert Tseng: Okay.
208 00:31:03.440 ⇒ 00:31:12.589 Mitesh Patel: Yeah. So the Andy you had created the views for me, the marketing and the growth weekly reports, Kpi weekly reports
209 00:31:13.170 ⇒ 00:31:17.519 Mitesh Patel: I need. I like those weekly reports. I continue to use them.
210 00:31:17.640 ⇒ 00:31:21.750 Mitesh Patel: but I wanted to be able to set a custom date range for those as well.
211 00:31:23.661 ⇒ 00:31:36.200 Annie Yu: Okay, I think right now, we by custom, by custom, date range. Do you mean? Because I think right now we can select the start, date and end date. And do you mean you want the individual exact date.
212 00:31:36.200 ⇒ 00:31:55.500 Mitesh Patel: Yes, I want the yeah. I can select the start date and end dates. But you still give, as I had asked for, for that those reports I need to continue. But you give me them in blocks, week blocks. Right? So. But I can’t select, like, for example, if I want that same report, the same data. June 1st to June 30.th I can’t do that.
213 00:31:58.230 ⇒ 00:32:01.809 Mitesh Patel: So it was just creating a different sort of view of it. I guess.
214 00:32:03.070 ⇒ 00:32:05.919 Annie Yu: So not aggregated by week.
215 00:32:06.500 ⇒ 00:32:09.469 Mitesh Patel: Keep those reports by week. Keep those as is.
216 00:32:11.310 ⇒ 00:32:19.539 Mitesh Patel: But give me the same. I guess data reports, tables for which I can select the start. Date and end date.
217 00:32:19.540 ⇒ 00:32:24.320 Annie Yu: Okay? Okay, for both gross Kpis and marketing Kpis.
218 00:32:24.320 ⇒ 00:32:24.990 Mitesh Patel: Yes.
219 00:32:40.680 ⇒ 00:32:45.874 Robert Tseng: Okay, can we just like create a ticket? And then like, well, so I mean, I’m I
220 00:32:46.850 ⇒ 00:32:51.149 Robert Tseng: update marketing views with custom date filters. I’m just gonna sign to you.
221 00:32:57.040 ⇒ 00:32:59.310 Mitesh Patel: Alright. I gotta. I gotta jump. Thank you so much. Guys.
222 00:32:59.310 ⇒ 00:32:59.900 Robert Tseng: Thanks.
223 00:32:59.900 ⇒ 00:33:00.630 Mitesh Patel: Yeah, bye.
224 00:33:17.400 ⇒ 00:33:30.889 Robert Tseng: yeah, I thought this was like a similar request to what Rebecca had asked for, which was basically just to add custom date ranges to the tables that you had built. So I I might have. I might have just like assumed it was the same thing and didn’t split it out.
225 00:33:31.550 ⇒ 00:33:39.259 Robert Tseng: Okay, that’s it. I think I gotta. I gotta. We gotta hop. I gotta meet with Henry. So we’re gonna that’s it.
226 00:33:41.390 ⇒ 00:33:42.970 Robert Tseng: Thanks. Everyone. Bye.