Meeting Title: Robert Tseng’s Personal Meeting Room Date: 2025-05-09 Meeting participants: Annie Yu, Demilade Agboola, Robert Tseng, Josh, Rob, Joanna, Cutter
WEBVTT
1 00:02:19.580 ⇒ 00:02:21.039 rob: What’s up, Buddy?
2 00:02:23.310 ⇒ 00:02:24.030 rob: Hey? Look!
3 00:02:24.030 ⇒ 00:02:24.860 Robert Tseng: How’s it going.
4 00:02:24.860 ⇒ 00:02:30.049 rob: No hat again this morning. So.
5 00:02:31.110 ⇒ 00:02:32.269 Robert Tseng: Oh, yeah, you play.
6 00:02:32.590 ⇒ 00:02:34.650 rob: Oh, yeah, you play at all.
7 00:02:35.000 ⇒ 00:02:36.990 Robert Tseng: I I do. Yes.
8 00:02:37.310 ⇒ 00:02:38.570 rob: Yeah, like a lot.
9 00:02:40.143 ⇒ 00:02:45.956 Robert Tseng: Not lately, since moving to the city actually haven’t played the past couple of months, but
10 00:02:46.820 ⇒ 00:02:48.360 rob: I have a.
11 00:02:48.970 ⇒ 00:02:51.859 Robert Tseng: I am. Yeah, I’m I’m like a 4. 0, yeah.
12 00:02:51.860 ⇒ 00:02:54.390 rob: Dang, man, I’m trying to get there.
13 00:02:54.630 ⇒ 00:02:58.890 rob: I had a pretty good morning, so I think I’ll go. I’m like a 3 7, but.
14 00:02:59.200 ⇒ 00:03:00.130 Robert Tseng: Oh!
15 00:03:00.400 ⇒ 00:03:01.909 rob: Yeah, I love it. Man.
16 00:03:02.490 ⇒ 00:03:04.098 Robert Tseng: Yeah, no, it’s it’s fun.
17 00:03:04.420 ⇒ 00:03:10.979 rob: I just started really playing a lot in the last year. So I play in this Friday morning League at 5 30. Am
18 00:03:11.630 ⇒ 00:03:12.779 rob: pretty fun, though.
19 00:03:13.180 ⇒ 00:03:18.420 Robert Tseng: Amazing. Yeah, I mean, I I just found a league that’s that that meets at 6 am.
20 00:03:18.917 ⇒ 00:03:22.519 Robert Tseng: I haven’t committed to it yet, but I’ve been thinking about about doing it.
21 00:03:22.520 ⇒ 00:03:23.270 rob: Yeah.
22 00:03:23.910 ⇒ 00:03:24.260 Robert Tseng: Yeah.
23 00:03:24.260 ⇒ 00:03:38.719 rob: The only thing I wanted to mention to you is, I fix the dates in that one thing that was easy, but and I did put all that data in the big query. So if you look at the data set
24 00:03:39.450 ⇒ 00:03:41.979 rob: called Offline ad spend.
25 00:03:42.410 ⇒ 00:03:42.750 Robert Tseng: Yeah.
26 00:03:42.750 ⇒ 00:03:44.019 rob: It’s all in there.
27 00:03:44.340 ⇒ 00:03:47.986 Robert Tseng: Okay, yeah. I think a wish was looking at it yesterday. So he saw it.
28 00:03:48.490 ⇒ 00:03:55.999 Robert Tseng: yeah, he’s out today. So I think I don’t know if he’ll he’ll update it. But yeah, thanks. That’s that’s that’s works for us.
29 00:03:56.300 ⇒ 00:04:14.369 rob: And then the Circle team they want like a 1 time data dump. So I’ll give that to them. But then I told them if they want ongoing reporting and data to put it in the analytics Channel request. So that’ll probably be coming. But just a heads up.
30 00:04:14.680 ⇒ 00:04:16.300 Robert Tseng: Okay. Good. To know.
31 00:04:17.649 ⇒ 00:04:19.129 rob: Do you have anything for me?
32 00:04:20.509 ⇒ 00:04:33.489 Robert Tseng: Well, I mean, I think you saw like you’re in a channel with Jonah’s request, I mean, general, I think we pretty much got that. And then Rebecca’s thing. I think we’ve finished. So we’re gonna just send a couple of things out just as a heads up. You’ll see.
33 00:04:33.750 ⇒ 00:04:36.839 rob: Is. Jonah’s pretty well defined now.
34 00:04:38.201 ⇒ 00:04:48.808 Robert Tseng: Well, I think he’s he’s asking good questions, I mean I I’ve I enjoy working with him honestly. I just think that he he thinks about the business in a in a clearer way.
35 00:04:49.380 ⇒ 00:04:50.510 Robert Tseng: yeah, so.
36 00:04:50.610 ⇒ 00:04:51.270 Robert Tseng: But I.
37 00:04:51.270 ⇒ 00:04:52.020 rob: Okay. Cool.
38 00:04:52.020 ⇒ 00:04:55.599 Robert Tseng: You know, there’s there’s a bit of translation between what he thinks. We
39 00:04:55.820 ⇒ 00:05:06.130 Robert Tseng: app versus what we actually have. And just yeah, kind of over communicating with him at this point. Just so he gets he he understands kind of what what we’re able to get him.
40 00:05:07.330 ⇒ 00:05:08.140 rob: Right on.
41 00:05:08.470 ⇒ 00:05:12.897 rob: Yeah. Well, then, I’ll jump if you don’t need me, because I got some other stuff to do. But
42 00:05:14.040 ⇒ 00:05:15.480 Robert Tseng: Cool. Yeah, that’s it.
43 00:05:15.840 ⇒ 00:05:21.439 rob: Hey, man, I’m gonna raise my game. So if you’re ever in Utah, we can play some pickleball.
44 00:05:21.770 ⇒ 00:05:27.399 Robert Tseng: Yeah, we should. I mean, I’m come. I’m gonna come to Salt Lake City sometime. Probably in the late summer.
45 00:05:27.830 ⇒ 00:05:41.280 rob: Okay, I play. But I play up in Sandy’s like South Salt Lake. That’s 1 of the 2 locations I play at. If you want the really high level, though you go down to Orem, cause.
46 00:05:41.280 ⇒ 00:05:47.550 Robert Tseng: Okay, it’s crazy. They’re like pros and stuff that are training there. And the coaches. They’re crazy. Good.
47 00:05:47.770 ⇒ 00:05:52.020 Robert Tseng: Yeah. So that’s fine. Alright, man, yeah, I’m glad to hear your pickleball player.
48 00:05:52.140 ⇒ 00:05:54.139 rob: Alright. We’ll see you, Ralph.
49 00:05:54.670 ⇒ 00:05:59.170 Robert Tseng: So, yeah, hey, Annie.
50 00:05:59.890 ⇒ 00:06:00.990 Annie Yu: Hello!
51 00:06:02.720 ⇒ 00:06:03.819 Robert Tseng: Happy. Friday.
52 00:06:04.100 ⇒ 00:06:08.689 Annie Yu: Yeah, I’m actually meeting I forgot her name right now. I’m.
53 00:06:08.690 ⇒ 00:06:09.220 Robert Tseng: Brunette.
54 00:06:09.622 ⇒ 00:06:10.829 Annie Yu: Yeah, later, today.
55 00:06:10.830 ⇒ 00:06:14.989 Robert Tseng: Yeah, yeah, yeah, she told me. Cool. I’m excited for y’all to meet.
56 00:06:15.200 ⇒ 00:06:16.759 Annie Yu: Nice! How’d you meet.
57 00:06:18.049 ⇒ 00:06:21.820 Robert Tseng: I was connected to her through a former client.
58 00:06:23.770 ⇒ 00:06:28.120 Robert Tseng: yeah, I think we were both working on the same client once. And then.
59 00:06:28.505 ⇒ 00:06:38.849 Robert Tseng: yeah. Just ended up coming friends. I guess she visits New York every now and then. I haven’t gone out to visit her in Portland, but I know she’s been out there, and I think she’s really great. So
60 00:06:39.387 ⇒ 00:06:45.430 Robert Tseng: she’s super helpful welcoming, and you know, I think she’s very well connected, and like kind of the tech world. So
61 00:06:45.720 ⇒ 00:06:47.549 Robert Tseng: I’m sure she can
62 00:06:47.660 ⇒ 00:06:51.899 Robert Tseng: find like kind of make, a good connection for you. If you’re interested in being anywhere.
63 00:06:52.030 ⇒ 00:06:54.039 Annie Yu: Yeah, cool. Thank you.
64 00:06:54.400 ⇒ 00:06:55.020 Robert Tseng: Yeah.
65 00:06:55.670 ⇒ 00:06:59.999 Annie Yu: Oh, Jo, josh is saying he can’t join the meeting.
66 00:07:01.480 ⇒ 00:07:03.100 Robert Tseng: Is that what he said.
67 00:07:03.760 ⇒ 00:07:05.090 Annie Yu: I think he at you.
68 00:07:05.850 ⇒ 00:07:06.659 Robert Tseng: Oh! Did he.
69 00:07:06.660 ⇒ 00:07:10.700 Annie Yu: He’s probably using that old link from Akash.
70 00:07:11.340 ⇒ 00:07:11.960 Robert Tseng: Oh.
71 00:07:15.690 ⇒ 00:07:19.139 Robert Tseng: which I already deleted, so I don’t even know how he still has that
72 00:07:19.660 ⇒ 00:07:21.500 Robert Tseng: you probably just saved it somewhere.
73 00:07:22.620 ⇒ 00:07:28.879 Annie Yu: I think the rest got removed, but not the Friday one, because it’s longer.
74 00:07:29.470 ⇒ 00:07:30.250 Robert Tseng: I see
75 00:07:38.760 ⇒ 00:07:40.860 Robert Tseng: I guess, like we can, just
76 00:07:40.980 ⇒ 00:07:42.619 Robert Tseng: while we wait on him to join.
77 00:07:42.840 ⇒ 00:07:45.410 Robert Tseng: Oh, there it is, hey, Connor.
78 00:07:45.650 ⇒ 00:07:46.530 cutter: What up, Buddy?
79 00:07:48.820 ⇒ 00:07:54.380 cutter: I like your color coordinated outfit, you fucking, making moves. That’s my voice.
80 00:07:55.500 ⇒ 00:07:56.380 Robert Tseng: Thank you.
81 00:07:56.930 ⇒ 00:08:00.410 Robert Tseng: It’s just feeling like a little sunshine today, because it’s raining so.
82 00:08:00.410 ⇒ 00:08:01.220 cutter: Been there.
83 00:08:01.960 ⇒ 00:08:02.570 Robert Tseng: Yeah.
84 00:08:11.260 ⇒ 00:08:14.880 Robert Tseng: I guess, Cutter, is there anything that’s top of mind for you that you wanted to chat about?
85 00:08:15.310 ⇒ 00:08:17.489 Robert Tseng: Otherwise we can keep going through our normal thing.
86 00:08:17.780 ⇒ 00:08:28.019 cutter: The the biggest thing for me is the product level drill down. Do we have to like specifically build each one of those for new products? Or can we just load it with new products.
87 00:08:28.610 ⇒ 00:08:33.439 Robert Tseng: Yeah, it should. New product should be there. Is there one that you feel like is missing?
88 00:08:33.960 ⇒ 00:08:37.039 cutter: Term. Odt. But I didn’t. I haven’t checked since.
89 00:08:37.500 ⇒ 00:08:40.090 cutter: I don’t know the last 24 h.
90 00:08:40.640 ⇒ 00:08:41.289 Robert Tseng: Okay.
91 00:08:43.419 ⇒ 00:08:50.709 cutter: And we’re we’re just we’re doing. Last week we put together. I don’t know 13 new products.
92 00:08:50.839 ⇒ 00:08:54.519 cutter: So yeah, gonna be big.
93 00:08:55.350 ⇒ 00:08:59.799 Robert Tseng: Yeah, I mean anything that was in that product list for the new launches like, we gotta
94 00:09:00.190 ⇒ 00:09:02.780 Robert Tseng: we got ahead of last week and kind of just
95 00:09:02.890 ⇒ 00:09:05.689 Robert Tseng: made changes to the data model so that we could
96 00:09:05.870 ⇒ 00:09:12.300 Robert Tseng: get capture them. I suppose we won’t know until they actually flow through, but if they already have. Then I think we should have it.
97 00:09:15.815 ⇒ 00:09:19.180 Robert Tseng: And cerm. O Dt, you said.
98 00:09:20.310 ⇒ 00:09:25.010 cutter: It might be in your sublingual Tomorrowland or.
99 00:09:26.980 ⇒ 00:09:33.589 Robert Tseng: I see. Maybe it’s still being caught as Marlin. But you want it to be broken out because I see like Odt order. Okay.
100 00:09:33.960 ⇒ 00:09:39.010 cutter: Yeah, this one’s different. Cogs are different. Everything on that one.
101 00:09:41.780 ⇒ 00:09:50.149 Josh : Yeah, we got a whole bunch of new products like I was trying to do a side by side, but I don’t know exactly what’s in and what’s not right now.
102 00:09:50.860 ⇒ 00:09:56.309 Robert Tseng: Yeah, I mean, there’s some new stuff that’s in that, like Yonto or Estradiol, or whatever.
103 00:09:56.850 ⇒ 00:10:03.710 Robert Tseng: I haven’t seen those before. So those are new, but I guess I guess the serm Odt wasn’t broken out, so I guess we have to make that change.
104 00:10:03.910 ⇒ 00:10:06.719 Josh : And then there’s like 4 different kinds of nad. Now.
105 00:10:08.260 ⇒ 00:10:11.609 Robert Tseng: Okay, so yeah, we need to break out the nads more.
106 00:10:11.760 ⇒ 00:10:13.220 Josh : Okay, I guess.
107 00:10:15.270 ⇒ 00:10:17.000 Robert Tseng: Dave Malaude.
108 00:10:18.564 ⇒ 00:10:30.469 Robert Tseng: Sorry. I know you just jumped on. But I’m just. I mean, this will be in the notes, but I’m just calling out that with the pro, with the new products that are coming in. I mean, we see some of the new ones coming in, but we need a breakout.
109 00:10:30.830 ⇒ 00:10:40.990 Robert Tseng: some of them. So Nad needs to be broken out to the 4 different types of Nad. And then some Moreland has a Somoreland Odt that needs to be broken out
110 00:10:41.150 ⇒ 00:10:45.389 Robert Tseng: as well. So that’s probably we’ll need to change to standardized product names.
111 00:10:47.420 ⇒ 00:10:50.730 Demilade Agboola: Okay, do you have a list of these things, or.
112 00:10:51.660 ⇒ 00:11:01.820 Robert Tseng: Yeah, I mean, I guess, Cutter, as we’re looking through it. If you look in any dashboards, you feel like something needs to be broken down more just let us know. But I mean these are the ones that they brought up so far.
113 00:11:02.930 ⇒ 00:11:04.030 cutter: Cool. I will.
114 00:11:04.630 ⇒ 00:11:05.310 Robert Tseng: Yes.
115 00:11:06.780 ⇒ 00:11:16.235 cutter: Another thing for me, Robert. Since we’re gonna maintain north beam as something.
116 00:11:16.980 ⇒ 00:11:17.540 Robert Tseng: Yeah.
117 00:11:17.720 ⇒ 00:11:24.130 cutter: Are you guys in charge of making sure that it’s firing, and all spends are tracked inside of North Bean.
118 00:11:24.868 ⇒ 00:11:37.590 Robert Tseng: No, I mean, we haven’t been doing north beam tracking. I mean anything that North Bean has that we come? Come, that comes in like I I handle that. But I didn’t set up the tracking within north beam, so.
119 00:11:38.440 ⇒ 00:11:39.930 cutter: Can we? Can I get
120 00:11:40.450 ⇒ 00:11:46.370 cutter: Mattesh to kinda give it a once over, and if anything’s missing, just send it over.
121 00:11:46.960 ⇒ 00:11:58.110 Robert Tseng: Yeah, yeah, that’s that’s fine. We can help with that. I know that that was like a Zack owning that before. I don’t know if Ryan touches north game tracking, I mean it. The technology is similar. It’s just a 1st party, Pixel, but
122 00:11:58.260 ⇒ 00:11:59.050 Robert Tseng: awesome.
123 00:11:59.270 ⇒ 00:12:01.890 Robert Tseng: Yeah, I don’t know who’s maintaining that right now.
124 00:12:02.760 ⇒ 00:12:03.420 cutter: Cool.
125 00:12:08.020 ⇒ 00:12:08.780 Robert Tseng: Okay?
126 00:12:09.160 ⇒ 00:12:14.420 Robert Tseng: Well, then, we’ll just kind of keep going through it. Going through things while you change things.
127 00:12:16.440 ⇒ 00:12:17.110 Robert Tseng: Yeah.
128 00:12:18.500 ⇒ 00:12:24.490 Robert Tseng: Okay, yeah, Annie, I know there’s a couple of outstanding things that we wanted to chat through. So maybe we’ll do that first, st and then we’ll do the
129 00:12:25.080 ⇒ 00:12:27.790 Robert Tseng: yeah. I need the, and then we’ll do the retro afterwards.
130 00:12:31.520 ⇒ 00:12:32.570 Robert Tseng: So
131 00:12:38.220 ⇒ 00:12:38.960 Robert Tseng: okay.
132 00:12:42.478 ⇒ 00:12:59.199 Robert Tseng: let’s start with this one on Natasha’s stuff. We were waiting for the Channel. Spend slash channel sales, summary models to be updated. Did a wish finish. I think I saw Pr. Did you finish that yesterday? And then, did you? Did you use? Did you Update it.
133 00:13:04.911 ⇒ 00:13:07.330 Annie Yu: Wait. Is that a question for me, or is this not on.
134 00:13:07.790 ⇒ 00:13:09.709 Robert Tseng: Yeah, yeah, this is a question for you, Annie. I got.
135 00:13:10.067 ⇒ 00:13:15.070 Annie Yu: Yeah, I haven’t. I haven’t seen that in bigquery, though. Either of them.
136 00:13:15.880 ⇒ 00:13:16.580 Robert Tseng: Okay.
137 00:13:21.530 ⇒ 00:13:24.272 Robert Tseng: okay, well, he’s out today. Let’s
138 00:13:26.370 ⇒ 00:13:30.600 Robert Tseng: I’m supposed to finish that yesterday. Okay, that’s fine.
139 00:13:30.720 ⇒ 00:13:31.580 Robert Tseng: I will.
140 00:13:31.710 ⇒ 00:13:33.870 Robert Tseng: I mean, I might. I might have to just go in.
141 00:13:35.510 ⇒ 00:13:40.690 Robert Tseng: It’s whatever whatever Rob was talking. It’s what Rob was talking about before he jumped. He hopped off this call. So
142 00:13:42.480 ⇒ 00:13:44.930 Robert Tseng: okay, then.
143 00:13:45.150 ⇒ 00:13:50.480 Robert Tseng: yeah, the model. We need to get this from stock. Can you request that from him? Have you done it yet?
144 00:13:53.593 ⇒ 00:13:56.239 Demilade Agboola: No, I haven’t. Actually, I’ll make that request today.
145 00:13:56.520 ⇒ 00:13:57.200 Demilade Agboola: Okay.
146 00:14:00.490 ⇒ 00:14:09.819 Robert Tseng: alright. And then this dash web hooks request. Yeah, I need a request, Zach. It’s not on the web hooks, so I have a request to make with him as well.
147 00:14:13.430 ⇒ 00:14:21.999 Robert Tseng: yeah. So this is like the follow up to Rebecca’s request yesterday I know that you had sent me some examples. Where we at with this Annie.
148 00:14:23.474 ⇒ 00:14:27.389 Annie Yu: Yeah. So those are what I have now. And
149 00:14:27.780 ⇒ 00:14:32.679 Annie Yu: I think that’s is that enough for what she needs now.
150 00:14:33.869 ⇒ 00:14:39.649 Robert Tseng: I mean, I’ll send it over. But I think she wanted to look at.
151 00:14:40.700 ⇒ 00:14:50.920 Robert Tseng: and we have number of patients, and I mean she may want to look at the patients themselves. So like I’m assuming we can drill down and export these lists like, I guess this looks like a tableau report, where is this living.
152 00:14:51.420 ⇒ 00:14:52.210 Annie Yu: Yeah.
153 00:14:52.330 ⇒ 00:14:54.699 Annie Yu: So we do want all the rows.
154 00:14:56.120 ⇒ 00:15:01.380 Robert Tseng: Yeah. Is that? Did you add it as a tab to the dashboard, or something? Or where is.
155 00:15:01.380 ⇒ 00:15:04.459 Annie Yu: Oh, no, that was just like a offline workbook.
156 00:15:04.980 ⇒ 00:15:06.010 Robert Tseng: Okay. Okay.
157 00:15:07.745 ⇒ 00:15:21.059 Robert Tseng: But yeah, I’m gonna she’ll she’ll probably be like, Okay, these are the High level metrics she wants to see. But then she’ll want to know, like, Okay, well, who are these personalized people and want to drill down to it? So customer order list.
158 00:15:21.060 ⇒ 00:15:27.720 Annie Yu: Yeah. And for these personalized plans, at least, the list that she provided currently are all
159 00:15:28.660 ⇒ 00:15:36.110 Annie Yu: injectable. Sema. So do we want like a specific section for that.
160 00:15:36.620 ⇒ 00:15:41.009 Annie Yu: And and you said, in which dashboard we will wanna add that.
161 00:15:41.733 ⇒ 00:15:46.869 Robert Tseng: Yeah, we don’t have to add into the dashboard yet. Let me just make sure this what she wants. I mean.
162 00:15:47.010 ⇒ 00:15:51.070 Robert Tseng: she wanted. Not just so, she said that Sema products like.
163 00:15:51.550 ⇒ 00:16:05.070 Robert Tseng: So there it it’s. I think it’s personalized dosing across all products. But she specifically gave the example like this. The Sema, you know, date is different. All the other
164 00:16:05.280 ⇒ 00:16:14.850 Robert Tseng: products are April 1st onwards, whereas the summer products are march 19.th So maybe that’s the confusion that I’m getting here because I’m only seeing 7 on here.
165 00:16:16.840 ⇒ 00:16:32.119 Annie Yu: Okay, so that’s so I think one question now is, I use those product lists that should provided to flag the new personalized plans. But then for other products, we want to use the dates and new customers.
166 00:16:32.650 ⇒ 00:16:34.060 Annie Yu: Is that correct?
167 00:16:35.740 ⇒ 00:16:40.289 Robert Tseng: Yeah, I mean, I honestly wouldn’t even trust the list that she sent, like I don’t know how she pulled it. I would trust.
168 00:16:40.290 ⇒ 00:16:46.730 Josh : So you guys know the use case, you guys know the use case. Let’s start there. What’s the use case that she asked you for?
169 00:16:48.050 ⇒ 00:16:54.339 Robert Tseng: She just wants to be able to to know, like, who’s on personalized plans, like, I think that’s all. That’s all it is. We didn’t have.
170 00:16:54.340 ⇒ 00:16:56.610 Josh : And when and when they started.
171 00:16:56.940 ⇒ 00:17:00.520 Josh : And the reason why is because she has to right now
172 00:17:00.660 ⇒ 00:17:02.630 Josh : make a bunch of decisions about
173 00:17:03.140 ⇒ 00:17:11.920 Josh : what pharmacy someone should be at based on when they came in. And what dose they’re on, and what product type they’re on all for summer.
174 00:17:15.300 ⇒ 00:17:16.209 Josh : Does that make sense.
175 00:17:16.210 ⇒ 00:17:19.440 Robert Tseng: This is only so, this is only so. This is only Sema.
176 00:17:20.020 ⇒ 00:17:22.814 Josh : Yeah. Just for stomach. Glutide injectable.
177 00:17:25.609 ⇒ 00:17:41.129 Robert Tseng: Okay, I mean, this is the only context that we got from her. So we’re like trying to like, obviously translate what she’s saying here. But like if she gave us 2 dates, there’s like all okay. So all new patients from April 1st onwards on injectable semi, they are on personalized plans.
178 00:17:42.819 ⇒ 00:17:47.559 Robert Tseng: But then also every product that was added in after
179 00:17:48.349 ⇒ 00:17:57.909 Robert Tseng: March 19.th So it seems like it’s not. She’s not just asking for injectable, Sema. There’s also all the other Sema products after this date that are.
180 00:17:57.910 ⇒ 00:18:01.300 Josh : When you say when you say other summer products, what do you mean?
181 00:18:01.870 ⇒ 00:18:03.130 Robert Tseng: Like.
182 00:18:03.240 ⇒ 00:18:10.753 Robert Tseng: I guess, the non injectable semi life product. So I mean, unless they all inject, I think there’s like some I don’t know.
183 00:18:11.490 ⇒ 00:18:14.860 Robert Tseng: that’s just I’ll just pull up something.
184 00:18:21.920 ⇒ 00:18:22.949 Robert Tseng: I guess.
185 00:18:25.040 ⇒ 00:18:28.959 Robert Tseng: Okay. So to her separate products is just different variants. It’s still.
186 00:18:28.960 ⇒ 00:18:36.610 Josh : Yeah, exactly. That’s I’m trying to help clarify, because I know what she’s asking for. She probably just didn’t ask it very clearly.
187 00:18:37.154 ⇒ 00:18:41.886 Josh : And because this is like, right now we have kind of like
188 00:18:42.530 ⇒ 00:18:53.264 Josh : it’s a little bit of a fire, because we have to make sure that we do things all like legally. And so like, we can’t transition a customer to a different type of Sema.
189 00:18:53.800 ⇒ 00:18:58.309 Josh : like, you know, like, if someone has like a it’s called like a B 12, Sema.
190 00:18:58.540 ⇒ 00:19:08.809 Josh : and then they’re on a B 12, Sema. But then we try to transition them to another pharmacy that only has regular Sema. That’s then that becomes Eden practicing medicine.
191 00:19:09.340 ⇒ 00:19:12.610 Josh : But we can transition A, B 12 customer
192 00:19:13.020 ⇒ 00:19:15.310 Josh : to another pharmacy that has B 12.
193 00:19:15.450 ⇒ 00:19:27.080 Josh : You see what I’m saying so. She’s trying to like, create a list to be able to like, manage this and make sure that, like none of these little guys, sneak through the cracks or slip through the cracks, and then we end up getting fucked. You know what I mean.
194 00:19:27.500 ⇒ 00:19:28.070 Robert Tseng: Yeah.
195 00:19:28.850 ⇒ 00:19:37.989 Josh : So I what I would tell you honestly, when you’re talking to these guys, too, like, just have them explain the problem statement. To give you more context, because otherwise
196 00:19:38.200 ⇒ 00:19:44.729 Josh : I feel like like a lot of these people have probably never worked with an analytics team. Just truthfully, I just don’t think they have.
197 00:19:44.890 ⇒ 00:19:50.618 Josh : And so like, I don’t think that they know that you guys need more context to make better decisions
198 00:19:51.270 ⇒ 00:19:54.349 Josh : like, I just think that they just don’t know that yet.
199 00:19:55.160 ⇒ 00:19:55.790 Robert Tseng: Okay.
200 00:19:56.530 ⇒ 00:19:57.100 Josh : So just 4.
201 00:19:57.100 ⇒ 00:19:57.500 Josh : So
202 00:19:57.500 ⇒ 00:20:14.940 Josh : I would say, like on these requests, like, I’m not trying to like add like extra work, but like, maybe it’s like a form. You know what I mean. It’s like a like a a form in Monday. That’s like context request timing kind of stuff. And then you guys can build your backlog more efficiently.
203 00:20:15.340 ⇒ 00:20:15.930 Robert Tseng: Yeah.
204 00:20:16.080 ⇒ 00:20:24.260 cutter: And, Robert, if you just list the questions that you want answered before anybody asks you to do shit.
205 00:20:24.630 ⇒ 00:20:36.569 cutter: Kron can build it inside of Monday, so it’s all done, and it it’ll load to your board. It’ll fire out to everybody else when it’s done, or if there’s questions on it. Still
206 00:20:37.050 ⇒ 00:20:40.790 cutter: just a doc or something, and then we can do that for you.
207 00:20:41.280 ⇒ 00:20:57.189 Robert Tseng: Okay, yeah, I know that you had the form before. I mean, I pretty much just told you I’m not gonna use it. And with anybody. I have to ask additional questions, anyway. And people like, yeah, I mean, it’s just it’s just very like, even with the questions with the form we had before.
208 00:20:58.760 ⇒ 00:21:05.010 Robert Tseng: I mean, it’s it doesn’t necessarily. I most of the time I still have to talk to people, anyway. So
209 00:21:06.500 ⇒ 00:21:11.217 Robert Tseng: but yeah, no, I hear you, I think. Yeah, we should. We should at least have some some.
210 00:21:13.270 ⇒ 00:21:17.810 Robert Tseng: I’ll I’ll bring. I’ll bring back some of the the I mean. I’d rather them ask.
211 00:21:17.810 ⇒ 00:21:28.110 Josh : If it’s not, if you don’t, yeah, if you don’t want it, it’s fine. I’m just trying to think of ways to help you guys cause. Like, if I’m coming in this meeting. And the record says, Hey, and you just need someone by this date and this date, that’s not gonna help.
212 00:21:28.920 ⇒ 00:21:29.630 Robert Tseng: Yeah.
213 00:21:32.360 ⇒ 00:21:46.039 Robert Tseng: okay. Anyway, I don’t want to compare, you know, across people, whatever. But I’m just some people give more context than others. And I think, regardless. I just ask them more questions. But yeah, I I should have asked. Well, I I thought this was clear enough, but it seems like.
214 00:21:46.850 ⇒ 00:21:47.540 Robert Tseng: did
215 00:21:47.990 ⇒ 00:21:59.609 Robert Tseng: I? I guess we we didn’t, we, didn’t I? I don’t think we got it wrong. I think, Annie, you you were actually right. You by limiting your search to just somehow you’re actually closer to what she’s asking for what I was saying about like
216 00:21:59.870 ⇒ 00:22:01.199 Robert Tseng: other products.
217 00:22:01.420 ⇒ 00:22:09.500 Robert Tseng: I’m wrong in my interpretation. So I think you actually are answering this question. So the only thing that we need to clarify is like
218 00:22:09.930 ⇒ 00:22:20.299 Robert Tseng: W. She also wants to know what what date they started to use these or like when they started to do the per personalized plan. And if she’s saying it’s like around
219 00:22:20.510 ⇒ 00:22:37.630 Robert Tseng: April first, st and like any product like we kind of have to do a bit of matching here, like any variance. Semi variance that was added after March 19th should be considered a personalized plan product. So I I think that’s that’s that to me is to take away from what he’s saying. Here.
220 00:22:38.970 ⇒ 00:22:50.990 Annie Yu: Okay and follow up on you said anything added after March 19.th Are you saying the product list? Or you mean, like a new customer that comes in after March 19.th
221 00:22:52.726 ⇒ 00:23:05.909 Robert Tseng: New customer after April 1st new product or products semi products added after 19.th So I mean, what she sent is really just like a list of products for Booth wins specifically, which is the pharmacy.
222 00:23:06.337 ⇒ 00:23:22.219 Robert Tseng: I mean, we should have in our warehouse like she probably pulled this for bass, not our data warehouse. We know when these products were added like or when we 1st saw them come through. So let’s just say like, if this set of 5 products came in like after
223 00:23:23.050 ⇒ 00:23:39.249 Robert Tseng: March 19.th Maybe we should just create another feature flag that says, like, you know, this is personalized dosing or something, or I don’t know if we want to flag that at the product level, or if we want to just do it at the, at the patient level. I think that’s kind of up to you. What you think is better.
224 00:23:42.340 ⇒ 00:23:43.210 Annie Yu: And
225 00:23:43.400 ⇒ 00:23:53.899 Annie Yu: how do I know? Okay, you said. We do have visibility on added product, on certain dates. And do you know where I can look at for that
226 00:23:54.120 ⇒ 00:23:54.820 Annie Yu: if we are.
227 00:23:54.820 ⇒ 00:24:14.810 Robert Tseng: I mean. So this is like a demo work work with them a lot of on this. He’s, you know, the the product mapping, I mean, we haven’t been getting weekly lists from from Zack anymore. But, like, when that was happening, we knew at least we would get like a full list of products every week, and anything that’s like seen for the 1st time, we would just consider that like.
228 00:24:15.080 ⇒ 00:24:17.940 Robert Tseng: that’s a new, that’s a new product that was added.
229 00:24:23.280 ⇒ 00:24:23.790 Annie Yu: Okay.
230 00:24:23.790 ⇒ 00:24:24.370 Robert Tseng: Does that make sense.
231 00:24:24.370 ⇒ 00:24:25.940 Annie Yu: You were gonna say something.
232 00:24:26.490 ⇒ 00:24:29.189 Demilade Agboola: Yeah. So I was, I was gonna ask if
233 00:24:30.720 ⇒ 00:24:33.250 Demilade Agboola: we’re just trying to look at it for the new patients.
234 00:24:37.030 ⇒ 00:24:37.860 Robert Tseng: Yeah.
235 00:24:39.130 ⇒ 00:24:42.340 Demilade Agboola: So so if I.
236 00:24:42.340 ⇒ 00:24:48.710 Robert Tseng: I mean, we can. We can ask that clarification. But it looks like everyone’s still on conventional dosing, except for new patients like kind of moving forward.
237 00:24:49.530 ⇒ 00:24:57.710 Robert Tseng: So. But then there’s going to be people who will be switching plans, and they maybe we might push them to different products, and that would be considered a new personalized plan plan product.
238 00:24:57.880 ⇒ 00:25:07.890 Robert Tseng: So it’s it’s not like a backfill. We need to go and fix everything from before April first.st It’s just April 1st onwards, like anybody that’s new
239 00:25:08.000 ⇒ 00:25:11.340 Robert Tseng: in a semi product is already on a personalized plan.
240 00:25:11.850 ⇒ 00:25:16.499 Robert Tseng: They will be using variants that are considered new
241 00:25:17.090 ⇒ 00:25:30.440 Robert Tseng: like after March after March 19.th And anybody that’s an existing customer that’s switching to these products that are after March 19.th They should also be flagged as personalized
242 00:25:30.570 ⇒ 00:25:32.900 Robert Tseng: plan patients.
243 00:25:34.250 ⇒ 00:25:46.450 Demilade Agboola: Okay? I mean using the variance. We could do that based on the orders and try and flag that, like a commission of the the variance that we have here, and the orders that exist
244 00:25:47.050 ⇒ 00:25:56.310 Demilade Agboola: and kind of like use, the date of the orders to like, figure out what plan these people are on and to flag that as either conventional or like a personalized plan.
245 00:25:58.760 ⇒ 00:26:04.910 Demilade Agboola: because, like, we don’t, yeah, cause we don’t necessarily have. Like the dates. The products came in, though. But we do know.
246 00:26:04.910 ⇒ 00:26:08.980 Robert Tseng: It would have to be off the orders. Yeah, yeah, I, yeah.
247 00:26:09.520 ⇒ 00:26:22.499 Robert Tseng: yeah, yeah, it’s not. We’re not. Yeah. So it should. Yeah, you’re right at the yeah. When orders that came in after the State that are new variants that we haven’t seen before, they should be considered
248 00:26:25.160 ⇒ 00:26:26.710 Robert Tseng: personalized plan variance.
249 00:26:29.260 ⇒ 00:26:36.609 Robert Tseng: Yeah. So I mean, Annie, I mean, you could take these meeting notes like, kind of write out the assumptions that you’re getting like, I know we’re talking about a lot of
250 00:26:36.720 ⇒ 00:26:37.420 Robert Tseng: like
251 00:26:37.780 ⇒ 00:26:43.969 Robert Tseng: small details here, but like, yeah, just just check your assumptions with me once. Once you make that change.
252 00:26:45.190 ⇒ 00:26:55.210 Annie Yu: Okay? And so one more question is, we don’t have to show pharmacy level detail, but like a
253 00:26:57.010 ⇒ 00:27:00.090 Annie Yu: like a, the trend of people
254 00:27:00.680 ⇒ 00:27:03.919 Annie Yu: being unpersonalized. I think that’s where I’m still confused.
255 00:27:06.231 ⇒ 00:27:12.550 Robert Tseng: It’s not like a trend. She just wants to have that list of customers. Soccer. Because I think
256 00:27:13.800 ⇒ 00:27:30.170 Robert Tseng: I yeah, I mean, you really should just be asking these questions to her directly, instead of kind of going through to me. But if I were to interpret it for her like she wants to be able to see, you know. Are there any patients that are supposed to be on personalized? But we haven’t moved them over yet, and we need to go and, like.
257 00:27:30.850 ⇒ 00:27:35.120 Robert Tseng: you know, target that segment of patients and to get them to switch to
258 00:27:35.220 ⇒ 00:27:38.689 Robert Tseng: the personalized plan product or whatever like that. There’s like a
259 00:27:38.880 ⇒ 00:27:49.219 Robert Tseng: there’s, there’s that’s 1 operational kind of thing that she needs to do. And then, yeah, she also just wants to monitor like for these new patients that are on the personalized plan.
260 00:27:49.490 ⇒ 00:27:54.230 Robert Tseng: Eventually, she’s gonna want to be able to see like, okay, well, how are they?
261 00:27:54.530 ⇒ 00:28:03.300 Robert Tseng: I mean, like, is there? I mean, obviously, it’s a very small share of revenue right now. But, like, how is that that trend that you’re describing like, how is that gonna change over time?
262 00:28:08.150 ⇒ 00:28:13.190 Josh : Yeah, I would. I would highly encourage you guys to talk to the Smes directly
263 00:28:13.580 ⇒ 00:28:17.909 Josh : like, if you’re working on this stuff like they can help you a lot more than us.
264 00:28:23.630 ⇒ 00:28:24.230 Robert Tseng: Yeah.
265 00:28:24.620 ⇒ 00:28:40.190 Robert Tseng: okay. You know, I I think probably would be best. And he’s like, you just get on a call with Rebecca. You can kind of recap your understanding based on what we talked about here. But I still feel like we’re not giving you like the level of confidence that you need to to finish this.
266 00:28:41.940 ⇒ 00:28:42.710 Annie Yu: Yeah.
267 00:28:42.840 ⇒ 00:28:43.540 Robert Tseng: Yeah.
268 00:28:43.780 ⇒ 00:28:49.639 Robert Tseng: So you’re in the channel in the farm. Ops analytics. Just tag, Rebecca. I’ll follow up and tag her as well. But.
269 00:28:49.987 ⇒ 00:28:53.070 Annie Yu: I don’t think, am I in that channel?
270 00:28:56.510 ⇒ 00:28:57.200 Robert Tseng: Probably.
271 00:28:58.030 ⇒ 00:28:58.580 Annie Yu: I don’t.
272 00:28:58.580 ⇒ 00:29:00.140 Annie Yu: I believe I am.
273 00:29:03.620 ⇒ 00:29:04.429 Robert Tseng: You are not.
274 00:29:07.930 ⇒ 00:29:08.790 Robert Tseng: Okay.
275 00:29:13.460 ⇒ 00:29:18.359 Josh : I mean, you can just send her a DM. Too, and just be like, Hey, I need to ask you a couple of questions.
276 00:29:19.190 ⇒ 00:29:27.353 Robert Tseng: Yeah. But, like, Rebecca doesn’t answer unless, like I push, she usually doesn’t respond to the people from my team. So like, I think that’s.
277 00:29:27.680 ⇒ 00:29:28.409 Josh : And then just tag.
278 00:29:28.410 ⇒ 00:29:29.750 Robert Tseng: Random channels. Yeah.
279 00:29:29.750 ⇒ 00:29:32.805 Josh : Just tag me in it. Then tag me in it when you
280 00:29:33.570 ⇒ 00:29:36.570 Josh : when you respond, just be like, Hey, Rebecca.
281 00:29:37.070 ⇒ 00:29:48.189 Josh : I need to have a better understanding of the use case. Here’s my current understanding. Blah blah, and then CC, me, put in CC, Josh on it. So you get what you need.
282 00:29:48.370 ⇒ 00:29:48.960 Josh : Okay.
283 00:29:48.960 ⇒ 00:29:56.870 Robert Tseng: Okay. Alright, yeah. Then we’ll we’ll keep it in the general analytics channel. Then I guess it’ll be noisy because everybody will get it. But that’s fine.
284 00:30:02.550 ⇒ 00:30:09.810 Robert Tseng: Okay, the other thing was this one?
285 00:30:10.150 ⇒ 00:30:22.210 Robert Tseng: Yeah. So this is like the thing that I was working on for Jonah yesterday. I handed off the query where I left off just wanted you to kind of check my work. But yeah, I saw that you were building upon things
286 00:30:22.887 ⇒ 00:30:26.880 Robert Tseng: anything you want to call out here all my things that you changed.
287 00:30:27.239 ⇒ 00:30:32.989 Annie Yu: One thing that I noticed that in your previous query you were filtering on only active
288 00:30:33.550 ⇒ 00:30:39.280 Annie Yu: customers. That out, and then added flag
289 00:30:39.390 ⇒ 00:30:46.749 Annie Yu: to flag active versus dropped. So I’m not sure if that’s what you need. Or we really just want to focus on active customers.
290 00:30:48.059 ⇒ 00:30:56.539 Robert Tseng: Well, I think Jonah just had, like a different active definition. It was just like someone who would place an order the past 6 months. So that’s why I just created my own. Yeah.
291 00:30:57.230 ⇒ 00:31:03.919 Annie Yu: No, I added that in the 1st active status that’s based on that definition.
292 00:31:04.210 ⇒ 00:31:05.010 Robert Tseng: Okay.
293 00:31:05.870 ⇒ 00:31:09.719 Annie Yu: So we flag. Anyone who hasn’t been ordered anything
294 00:31:10.250 ⇒ 00:31:13.510 Annie Yu: in the 1st in the last 6 months has dropped.
295 00:31:14.270 ⇒ 00:31:17.960 Robert Tseng: Oh, okay, are you? Okay? You just turned that into a stat, okay? Sure, yeah.
296 00:31:20.650 ⇒ 00:31:25.329 Robert Tseng: yeah, turn that into a status instead of instead of pre filtering the entire set on it.
297 00:31:25.470 ⇒ 00:31:32.460 Annie Yu: Yeah, yeah, I’m not sure. Are we presenting like a Csv file so she can filter using that.
298 00:31:33.130 ⇒ 00:31:46.080 Robert Tseng: Yeah, I’m just giving him. I I don’t think he’s gonna look at dropped customers. Honestly, I think he just wanted to look at active, which is why I filter that way, but it’s fine like he can go, and he’s savvy enough to go and use use the use. The filter.
299 00:31:46.600 ⇒ 00:31:47.360 Annie Yu: Okay.
300 00:31:47.640 ⇒ 00:31:48.270 Annie Yu: Yeah.
301 00:31:48.270 ⇒ 00:32:03.199 Robert Tseng: The objective is not to give him a visual. He’s he. He’s he’s good enough with data that like I’m just giving him a table. So I built out the table. I made the assumptions on what columns I think he needed. I think it gets him most of the way there just needed to wanted you to get a check on it.
302 00:32:03.380 ⇒ 00:32:18.710 Annie Yu: Yeah. Yeah. So I added another 2, those are days on treatment. So this is applicable for both active and those who dropped out also days since last order. So we can see, like how recent each person order
303 00:32:19.590 ⇒ 00:32:20.580 Annie Yu: something.
304 00:32:21.040 ⇒ 00:32:23.419 Annie Yu: But I think your query already had
305 00:32:24.226 ⇒ 00:32:27.909 Annie Yu: cover most of what we can provide.
306 00:32:28.880 ⇒ 00:32:32.856 Robert Tseng: Yeah. One. Sec. Let me just open this.
307 00:32:35.774 ⇒ 00:32:43.565 Robert Tseng: Yeah, he he’s aware of, like I’m already told him some things that we couldn’t get him. But yeah, cool, alright. Full, patient list.
308 00:32:45.720 ⇒ 00:32:50.360 Robert Tseng: 29,000. That’s even more. Oh, it’s because you included everyone. Yeah, okay,
309 00:32:53.940 ⇒ 00:33:02.589 Annie Yu: Yeah, but feel free to add that kind of filter on active customers back. If we only wanna give them
310 00:33:02.720 ⇒ 00:33:03.420 Annie Yu: that.
311 00:33:03.420 ⇒ 00:33:07.070 Robert Tseng: Yeah, no, let’s just skim everything. This, this is clean. This looks good. Okay?
312 00:33:07.496 ⇒ 00:33:10.759 Robert Tseng: But yeah, I mean, I guess you checked. You also checked.
313 00:33:11.570 ⇒ 00:33:13.190 Robert Tseng: How? I said, Okay, well.
314 00:33:14.600 ⇒ 00:33:20.228 Robert Tseng: yeah, I think the only thing that I told him was like, Well, yeah. So I don’t ever think that
315 00:33:22.890 ⇒ 00:33:28.749 Robert Tseng: this one will. I think these is all these should always be the same. I don’t. Oh, and actually
316 00:33:29.060 ⇒ 00:33:32.299 Robert Tseng: price that plan at end. So it’s like
317 00:33:34.320 ⇒ 00:33:41.040 Robert Tseng: I forgot what message I sent him. But I basically don’t expect
318 00:33:41.400 ⇒ 00:33:47.540 Robert Tseng: I guess I could just do a yes start and
319 00:33:55.140 ⇒ 00:34:01.559 Robert Tseng: like this whole like price plan price at the start on, and their 1st order and plan price at the end.
320 00:34:02.160 ⇒ 00:34:06.860 Robert Tseng: I had some questions around that I think I might have left that for you to think about.
321 00:34:06.860 ⇒ 00:34:08.969 Annie Yu: Yeah, yeah. So
322 00:34:10.460 ⇒ 00:34:18.110 Annie Yu: I built upon your kind of fallback logic. So now we are saying, if let’s say, look at men.
323 00:34:19.060 ⇒ 00:34:25.100 Robert Tseng: Let’s not say that, but the the start, if the start price is null, we’ll grab the.
324 00:34:25.260 ⇒ 00:34:26.520 Annie Yu: And price.
325 00:34:27.650 ⇒ 00:34:28.790 Annie Yu: But then, if
326 00:34:29.030 ⇒ 00:34:42.710 Annie Yu: and prices also null will grab the sum of order total, and if that sum of order total is null. That just means it. Truly, this person truly has just no data that we don’t have
327 00:34:43.909 ⇒ 00:34:45.830 Annie Yu: a legit number for that.
328 00:34:45.949 ⇒ 00:34:47.189 Annie Yu: Does that make sense.
329 00:34:48.300 ⇒ 00:34:56.429 Robert Tseng: Yeah. So let’s just pick this one. This one sticks out to me. So start is 2 96 and is 88 like that. How would that be possible? Like.
330 00:34:56.820 ⇒ 00:35:03.239 Robert Tseng: okay, 11 orders plan price this. I don’t believe that this dropped 88. So like,
331 00:35:08.860 ⇒ 00:35:12.080 Robert Tseng: yeah, like, I don’t know if you can help me, make sense of that.
332 00:35:15.830 ⇒ 00:35:19.880 Annie Yu: Okay, I think I will need more time to look into that.
333 00:35:20.550 ⇒ 00:35:22.480 Robert Tseng: It’s fine. I mean, some of this data. Just maybe
334 00:35:22.670 ⇒ 00:35:24.929 Robert Tseng: I don’t think anybody’s looked at patient level.
335 00:35:24.930 ⇒ 00:35:25.410 Annie Yu: Yeah, yeah.
336 00:35:25.410 ⇒ 00:35:28.200 Robert Tseng: We don’t. We didn’t really build out this object. Well, so.
337 00:35:28.200 ⇒ 00:35:29.513 Annie Yu: Yeah, but
338 00:35:31.940 ⇒ 00:35:49.699 Annie Yu: yeah, so I but the only thing I changed was that if Min is null would get the Max to substitute, and if the Max is null we’ll get the min as a substitute. So I think in this case that means neither of them were null, or else they would be the same.
339 00:35:51.500 ⇒ 00:35:51.860 Robert Tseng: Yeah.
340 00:35:51.860 ⇒ 00:35:55.815 Annie Yu: That just mean they were original. But I I can look into that
341 00:35:56.120 ⇒ 00:36:02.539 Robert Tseng: Okay, yeah. I mean, if you could, just you know, you saw what I did just especially look at the ones where there’s like a diff like I just
342 00:36:03.120 ⇒ 00:36:11.689 Robert Tseng: it’s like, it’s hard to explain, like why a plan price would have dropped, you know, like I I don’t. I don’t believe like. If anything, it should always be increasing like, I don’t
343 00:36:11.910 ⇒ 00:36:14.300 Robert Tseng: really think we’re making like big.
344 00:36:14.420 ⇒ 00:36:17.880 Robert Tseng: I mean, maybe there have been some small pricing adjustments, but I don’t think.
345 00:36:18.400 ⇒ 00:36:26.794 Josh : We have made a few but sometimes someone gets like a coupon or something like that applied, or they’ve had like a.
346 00:36:27.160 ⇒ 00:36:30.739 Robert Tseng: Make sense like a 300 to an $88 plan.
347 00:36:31.851 ⇒ 00:36:45.180 Josh : If they’ve swapped to a different product, too. Yes, but I don’t. I don’t know if they, if they might have gotten a big discount for having something messed up like that. One does seem like odd. But yeah.
348 00:36:46.440 ⇒ 00:36:46.780 Robert Tseng: Okay.
349 00:36:47.100 ⇒ 00:36:54.739 Josh : Like, if you ask if you if you get the order Id, you can give it to care and be like what happened to this customer.
350 00:36:56.920 ⇒ 00:36:57.570 Robert Tseng: Okay.
351 00:36:57.570 ⇒ 00:36:59.249 Josh : Or we have a name even.
352 00:36:59.440 ⇒ 00:37:01.840 Robert Tseng: Yeah, we have names, and like the customer, id.
353 00:37:04.790 ⇒ 00:37:05.280 Josh : What was that?
354 00:37:05.280 ⇒ 00:37:05.760 Robert Tseng: Oh!
355 00:37:05.760 ⇒ 00:37:08.479 joanna: This person related to Danny. Did they get a discount.
356 00:37:09.370 ⇒ 00:37:10.370 Josh : The last name.
357 00:37:10.370 ⇒ 00:37:10.900 joanna: Dates.
358 00:37:10.900 ⇒ 00:37:11.400 Robert Tseng: It’s, yeah.
359 00:37:11.400 ⇒ 00:37:14.530 Josh : Yeah, yeah, that’s his. That’s probably his mom or his dad. There you go.
360 00:37:15.890 ⇒ 00:37:17.340 Robert Tseng: Oh, I see.
361 00:37:19.500 ⇒ 00:37:20.420 Robert Tseng: Okay.
362 00:37:22.040 ⇒ 00:37:28.039 Josh : Yeah. So you want to yell at Danny, you can be like, I think you’re breaking terms of use with our our, yeah, that’s his mom.
363 00:37:28.560 ⇒ 00:37:29.530 Josh : There is as well.
364 00:37:29.530 ⇒ 00:37:30.110 Robert Tseng: Project.
365 00:37:31.660 ⇒ 00:37:33.630 Robert Tseng: Good. And now.
366 00:37:33.970 ⇒ 00:37:48.590 Robert Tseng: okay, yeah, I mean, I’ll just like hand pick a few of these and I’ll send it to the care team first.st Just have them. Look at it. Give me some more context. Yeah. I mean, I think, Annie, maybe there isn’t really anything wrong. I thank you for improving the fallback logic. I think what you said makes sense logically. So
367 00:37:49.013 ⇒ 00:37:54.340 Robert Tseng: yeah, maybe like there isn’t an action for you yet. Let me let me just go and get some more context on some of this.
368 00:37:54.340 ⇒ 00:37:56.110 Annie Yu: Okay, let me know. Thank you.
369 00:37:56.110 ⇒ 00:37:58.380 Robert Tseng: Yeah, okay, cool.
370 00:37:58.520 ⇒ 00:38:03.139 Robert Tseng: But yeah, I mean, otherwise, I think this is almost in a good place. We can probably send to Jonah today.
371 00:38:08.174 ⇒ 00:38:18.420 Robert Tseng: I know we ran over a bit. We didn’t really cover stuff yet. I’m assuming anything else kind of like that’s been closed out today that we need to touch on from either either of you.
372 00:38:20.006 ⇒ 00:38:25.059 Annie Yu: I think one thing I do wanna ask. The mulade was about that vial size.
373 00:38:26.040 ⇒ 00:38:26.770 Robert Tseng: Okay.
374 00:38:27.047 ⇒ 00:38:34.820 Demilade Agboola: Yeah. So I am working on it. And again, this should be done today. You know, we had a week, but like it should be done today.
375 00:38:35.780 ⇒ 00:38:50.109 Robert Tseng: Okay, yeah, we’re not adding, like a field called file size that we’re just, you know, it’s just like a proxy for quantity file size are interchangeable. Rebecca called the file size, but everyone else calls it quantity. So we don’t really actually have to add this as a new field.
376 00:38:50.110 ⇒ 00:38:55.659 Josh : There is a there is a difference, though. No, there is a difference, and that is correct.
377 00:38:56.200 ⇒ 00:38:58.790 Josh : Quantity is just the number shipped.
378 00:38:58.910 ⇒ 00:39:06.529 Josh : but vial size is important now, because there is a different sized vial for these semis coming from different
379 00:39:06.890 ⇒ 00:39:14.070 Josh : pharmacies, some of them ship in a 4 ml. Some of them ship in a 5 ml. Some of them can ship in and things up to a 10 ml.
380 00:39:14.410 ⇒ 00:39:19.310 Josh : so that is actually a requirement for the new stuff that we’re trying to figure out.
381 00:39:20.460 ⇒ 00:39:29.260 Robert Tseng: Okay. So like, for example, 2.5 1.7 like when, when, whenever Rebecca talked about vial size, I always just assume she’s talking about like the drug quantity.
382 00:39:29.840 ⇒ 00:39:31.900 Josh : Oh, no, no, it’s not. It’s different.
383 00:39:32.540 ⇒ 00:39:33.170 Robert Tseng: Okay.
384 00:39:34.310 ⇒ 00:39:36.550 Josh : Quantity is just number of vials.
385 00:39:39.447 ⇒ 00:39:44.029 Josh : You can have a such a scenario where we’re shipping 6 vials at once.
386 00:39:44.700 ⇒ 00:39:52.080 Josh : but we could be shipping 6 of the 5 ml. Vials. See what I’m saying, or we could be shipping 6 of the 4 Ml. Vials.
387 00:39:52.700 ⇒ 00:39:55.929 Josh : 1 1.7 file.
388 00:39:57.790 ⇒ 00:40:05.930 Robert Tseng: Okay, so quantity is like a function of like the number of files. But within each file you could have a different, you know, amount.
389 00:40:06.279 ⇒ 00:40:11.529 Josh : Yeah, well, you can have 3 things right. There is the strength. There’s the strength
390 00:40:11.720 ⇒ 00:40:18.010 Josh : of the milligram to Ml. Ratio. So you could have, like, you know, 2.5,
391 00:40:18.230 ⇒ 00:40:21.730 Josh : you know milligrams inside of a
392 00:40:21.840 ⇒ 00:40:37.939 Josh : per one ml. Or port, or you could have a 1.7 milligram per one ml, and then you could have 1, 3, 4, 5, 10 ml. Vial, and then you could ship between one and 12 of these at any time.
393 00:40:39.680 ⇒ 00:40:40.480 Robert Tseng: I see.
394 00:40:43.950 ⇒ 00:40:51.880 Robert Tseng: I guess. How would we tell vile size then? Like, because I guess we I mean, we’re only doing it off of the product names. And so we were just
395 00:40:52.280 ⇒ 00:41:02.030 Robert Tseng: extracting like the strength, if that’s what you call it strength. And obviously we have quantity. But then, like, how do you? How do you determine? Vile.
396 00:41:03.270 ⇒ 00:41:05.649 Josh : I think it’s by the pharmacy.
397 00:41:06.060 ⇒ 00:41:12.979 Josh : so it’s like we’ll be able to infer it by what the pharmacy is. Ship, what pharmacy is shipping.
398 00:41:13.590 ⇒ 00:41:14.700 Robert Tseng: Okay, very much.
399 00:41:14.700 ⇒ 00:41:20.210 Robert Tseng: Say, Booth, win like what I mean. You said there’s a range of like one to 12 files, right? So like.
400 00:41:20.210 ⇒ 00:41:39.900 Josh : Yeah, would never do, Booth. One would never do more than 3. So like they would be between one and 3, depending on the order type. And I think that this is done at a product level inside of Basque as well like these are details. I don’t have a hundred percent clear. I know how it works. I just don’t know. Like the details. I can’t answer the details, for you like that, like Christiana.
401 00:41:40.070 ⇒ 00:41:42.160 Josh : can probably answer the best for you.
402 00:41:42.570 ⇒ 00:41:43.210 Robert Tseng: Okay.
403 00:41:47.640 ⇒ 00:41:56.110 Robert Tseng: okay. Well, I mean, glad, I guess in a lot of good that you haven’t worked out this yet. We kind of need to update our. Let’s just let’s turn to a spike. So
404 00:41:58.240 ⇒ 00:41:59.490 Robert Tseng: spring.
405 00:42:00.260 ⇒ 00:42:04.620 Demilade Agboola: Well, actually was also gonna ask like, there’s some that don’t necessarily have a like
406 00:42:04.760 ⇒ 00:42:12.019 Demilade Agboola: milligram dosage in the name, like in the product name. So how do we make the assumption for that? Like the Val size there? So.
407 00:42:18.450 ⇒ 00:42:31.579 Robert Tseng: I mean Christiana is gonna tell you, and show you how she how she gets it in the vast ui. We probably don’t have the data that this is all we get that with that order level. This is all the product data we get. So we might, we might get stuff.
408 00:42:33.060 ⇒ 00:42:35.229 Demilade Agboola: Okay, I’ll reach out to her right now.
409 00:42:36.150 ⇒ 00:42:36.710 Robert Tseng: Yeah.
410 00:42:38.300 ⇒ 00:42:40.569 Josh : Cool, any other big stuff.
411 00:42:41.843 ⇒ 00:42:45.986 Robert Tseng: Yeah, no. I think those are the main things we’ve been trying to work on this week.
412 00:42:46.230 ⇒ 00:42:54.449 Annie Yu: Robert, I do. Wanna add one more thing. I think that’s not ticket to support what we wanted to build for the patient outcome. We
413 00:42:54.840 ⇒ 00:43:03.719 Annie Yu: and we also talk about this me and demalade. But it’s not in this ticket. It’s the refillable patient flag. So we want to determine after.
414 00:43:03.720 ⇒ 00:43:04.200 Robert Tseng: All right.
415 00:43:04.200 ⇒ 00:43:09.810 Annie Yu: This refill? Yeah, how many patients still have refills of that script.
416 00:43:11.530 ⇒ 00:43:20.199 Robert Tseng: So yeah, I mean, there’s 2 things right. We have the refillable. Whether or not it was a refillable order. We have that flag already. You’re talking about like how many
417 00:43:20.860 ⇒ 00:43:24.720 Robert Tseng: like doses left in their refill. Is that what you’re saying?
418 00:43:25.225 ⇒ 00:43:28.260 Annie Yu: How many refills each patient have.
419 00:43:28.810 ⇒ 00:43:31.699 Josh : It’s it depends on the plan type they’re on.
420 00:43:32.710 ⇒ 00:43:36.449 Josh : So if someone’s on a month to month, I think it’s written.
421 00:43:38.344 ⇒ 00:43:43.370 Josh : it’s a it’s interesting, right? So there’s a fills. And then there’s number of prescriptions, too.
422 00:43:43.520 ⇒ 00:44:11.579 Josh : And so this is a very detailed, nuanced question. Again I would ask Rebecca to give you a bunch of details on, because the way it works is like right now, for some of our products, like a good number of them like Sema. A doctor will write a prescription for up to 6 renewals, or like refills, right? But those don’t get triggered unless like a patient, you know, does something on, or if they’re on auto refill.
423 00:44:11.650 ⇒ 00:44:17.010 Josh : And I think right now, we’re like actually moving to get out of auto refills through this like whole
424 00:44:17.310 ⇒ 00:44:22.459 Josh : tumultuous like, you know, change in pharmacy all this other crazy shit that’s going on.
425 00:44:23.290 ⇒ 00:44:32.509 Josh : So I would say, that’s another great question. Get Rebecca into a room for half hour, and go over all your big questions with her and Christian.
426 00:44:33.940 ⇒ 00:44:34.540 Robert Tseng: Okay.
427 00:44:35.100 ⇒ 00:44:37.929 Josh : Alright. I gotta jump to another call. But thanks, guys.
428 00:44:37.930 ⇒ 00:44:39.300 Robert Tseng: Yeah, okay.
429 00:44:40.320 ⇒ 00:44:40.830 joanna: Thanks.
430 00:44:41.800 ⇒ 00:44:45.200 Robert Tseng: I guess Annie and Demotive could just stay on for a couple more minutes.
431 00:44:46.141 ⇒ 00:45:03.069 Robert Tseng: Yeah. So I guess. Yeah, that probably be the best. Let’s just kind of gather like what these questions are. I know that different things. I’ll help set up the meeting with Rebecca and Christiana, and then hopefully, we can just get get those. I don’t know if we’ll be available today, so it’s fine if we
432 00:45:03.230 ⇒ 00:45:06.248 Robert Tseng: end up pushing it off till early next week. But
433 00:45:07.330 ⇒ 00:45:10.889 Robert Tseng: yeah, I think the learning here for me is like.
434 00:45:11.600 ⇒ 00:45:29.840 Robert Tseng: Yeah, there’s just like so many nuances that we don’t fully understand. Like I’m trying to give the best direction I can make assumptions. I think I was right on some wrong, on others. So yeah, we just need to be able to get whenever we have products. Kind of questions.
435 00:45:30.320 ⇒ 00:45:35.029 Robert Tseng: Yeah, we we need to figure out how to get the answer directly from Rebecca.
436 00:45:35.980 ⇒ 00:45:39.600 Robert Tseng: It’s either Rebecca or Cutter, that, depending on the question.
437 00:45:40.790 ⇒ 00:45:41.810 Annie Yu: Okay.
438 00:45:41.810 ⇒ 00:45:42.580 Demilade Agboola: Okay.
439 00:45:42.790 ⇒ 00:45:44.254 Annie Yu: So does that mean?
440 00:45:45.703 ⇒ 00:45:53.930 Annie Yu: We still don’t have a definition or kind of the I an idea how we would get the refills.
441 00:45:54.920 ⇒ 00:46:06.742 Robert Tseng: Yeah, I don’t think we we know enough to answer the refill thing like I didn’t. I honestly didn’t really understand what Josh just said so I think the only thing that we could really move forward with was the 1st thing that we talked about
442 00:46:07.730 ⇒ 00:46:15.090 Robert Tseng: regarding da- da-da, the
443 00:46:18.810 ⇒ 00:46:24.089 Robert Tseng: I already? Oh, yeah, like the personalized, conventional thing like, I think you’re able to move forward there right.
444 00:46:24.830 ⇒ 00:46:30.270 Annie Yu: I think I I will still write some questions that I wanted to clarify.
445 00:46:30.660 ⇒ 00:46:38.279 Robert Tseng: Yeah, so personalized versus convention, strength file quantity, we need to figure out. And then also the refillable. So I mean, this is a lot
446 00:46:38.410 ⇒ 00:46:46.280 Robert Tseng: lot of concepts that we need to kind of get right? Yeah, I was gonna wanted to save some time to talk about this
447 00:46:46.900 ⇒ 00:46:50.350 Robert Tseng: doc roadmapping. But I think.
448 00:46:51.450 ⇒ 00:46:56.230 Robert Tseng: yeah, we we really just gotta go and try to get get on a call with with these folks. So
449 00:47:00.990 ⇒ 00:47:08.920 Robert Tseng: yeah, I guess, did both of you take time to review this yet.
450 00:47:11.078 ⇒ 00:47:13.319 Annie Yu: Guilty? Not yet, but I.
451 00:47:13.320 ⇒ 00:47:14.030 Robert Tseng: Okay.
452 00:47:14.520 ⇒ 00:47:15.010 Annie Yu: Today.
453 00:47:15.340 ⇒ 00:47:15.889 Robert Tseng: That’s all
454 00:47:15.890 ⇒ 00:47:23.470 Robert Tseng: totally fine. I will probably put this to Monday. Then I want to like, have a longer session on Monday. Want us to kind of talk through this.
455 00:47:23.889 ⇒ 00:47:43.089 Robert Tseng: Because, yeah, this is, yeah. You guys are asking me, like, how do we move from just building, you know, being dashboard monkeys to like doing insights like, well, this is it like these are the priorities? This is how I want to be talking about like the impact of our work to Josh and the leadership team. You know.
456 00:47:43.580 ⇒ 00:47:44.520 Robert Tseng: like, I,
457 00:47:45.110 ⇒ 00:47:53.630 Robert Tseng: I think there, I’ve I’ve left some questions that I think are ongoing conversations. We need to have the client. And then some like roadmap of like, what
458 00:47:53.740 ⇒ 00:47:56.689 Robert Tseng: analyses that we need to do in order to get there.
459 00:47:57.457 ⇒ 00:48:22.380 Robert Tseng: So yeah, like, the idea is to shift away from just measuring our output off of, like the number of reports or dashboards that we’re doing to support the team. But I want us to actually be able to be like, yeah, we we improved your payback optimization. You know you were. Your payback period was 30 days before, but because of the insights we’ve given you, they’ve dropped to 7 days, right? Or like 2 weeks or something, because of
460 00:48:22.490 ⇒ 00:48:37.430 Robert Tseng: whatever we made some pricing change, or like we told you like. There’s a particular product with a higher Ltv cac ratio that like you should be spending more ad dollars on, you know, stuff like that. So that gives me more leverage with Josh to be like.
461 00:48:37.550 ⇒ 00:48:49.960 Robert Tseng: yeah, we may not be like the product owner, Sme, or whatever like that’s doing all the operational stuff. But the advice that we’re giving you is like, you know, obviously valuable. It has a clear through line to
462 00:48:50.670 ⇒ 00:48:53.361 Robert Tseng: like impacting the business. So,
463 00:48:54.140 ⇒ 00:49:12.970 Robert Tseng: yeah, I may not have captured everything here. So I I think it’s a lot in this, Doc. I want you to kind of take some time to review it and think about like, can you see your work like, really? Like moving the needle on these things. And yeah, that’s that’s the level of conversation I want to be having with with this team
464 00:49:13.810 ⇒ 00:49:16.200 Robert Tseng: hopefully by Monday. That’s okay.
465 00:49:20.170 ⇒ 00:49:22.019 Demilade Agboola: Sounds good. That sounds exciting.
466 00:49:22.590 ⇒ 00:49:31.889 Robert Tseng: Okay, cool. Yeah. I mean, thank you, for the team is teams pushing us in this direction. So this is this is these are your ideas. I I want this. I wanted us to.
467 00:49:32.060 ⇒ 00:49:33.160 Robert Tseng: Yeah, like, kinda
468 00:49:33.300 ⇒ 00:49:41.849 Robert Tseng: take this to the next next level. So yeah, alright. Well, anyway, we have some things to chase. I’m gonna do all these follow ups now. So
469 00:49:42.660 ⇒ 00:49:43.480 Robert Tseng: thanks.
470 00:49:43.760 ⇒ 00:49:45.209 Annie Yu: Okay. Thank you.