Meeting Title: Robert Tseng’s Personal Meeting Room Date: 2025-06-03 Meeting participants: Robert Tseng, Fireflies.ai Notetaker Awaish, Annie Yu, Demilade Agboola, Awaish Kumar
WEBVTT
1 00:03:08.050 ⇒ 00:03:08.840 Robert Tseng: Candy.
2 00:03:10.030 ⇒ 00:03:11.200 Annie Yu: Hello, Robert!
3 00:03:13.540 ⇒ 00:03:14.260 Robert Tseng: Are you?
4 00:03:17.130 ⇒ 00:03:20.180 Annie Yu: Not too bad. How’s Amsterdam?
5 00:03:21.480 ⇒ 00:03:27.440 Robert Tseng: Good pace of life here is kind of slow. It’s kind of a sleepy town, so feel like.
6 00:03:27.440 ⇒ 00:03:28.520 Annie Yu: Oh, really.
7 00:03:29.020 ⇒ 00:03:35.840 Robert Tseng: Yeah, it’s a bunch of cafes, a lot of co-working spaces feel like people. The lifestyle here is pretty laid back.
8 00:03:37.390 ⇒ 00:03:38.710 Annie Yu: That’s good.
9 00:03:39.540 ⇒ 00:03:40.050 Demilade Agboola: Yeah.
10 00:03:40.050 ⇒ 00:03:40.849 Annie Yu: I always thought.
11 00:03:41.470 ⇒ 00:03:44.160 Demilade Agboola: That sounds like almost any city in Europe.
12 00:03:45.285 ⇒ 00:03:52.170 Annie Yu: Okay, yeah, I would imagine, like, Amsterdam is a little busier than than some of the others.
13 00:03:52.170 ⇒ 00:04:02.380 Robert Tseng: Oh, yeah, you would think. But I feel like there’s a lot of empty buildings like, I’m in the center of the city. So it’s supposed to be the busiest part, but there are a lot of empty buildings
14 00:04:02.847 ⇒ 00:04:20.130 Robert Tseng: the whole city is kind of built on top of a swamp, so like some of the houses are like tilting over. So I think people find that to be a risk it’s kind of like a situation where you see in like Venice canals, where everyone’s like leaving, because like the whole city, is sinking.
15 00:04:21.240 ⇒ 00:04:22.130 Annie Yu: Well.
16 00:04:22.920 ⇒ 00:04:25.330 Robert Tseng: Yeah, but that won’t happen in
17 00:04:25.790 ⇒ 00:04:28.919 Robert Tseng: anytime soon, so there’s plenty of time to visit.
18 00:04:32.170 ⇒ 00:04:43.589 Robert Tseng: Alright. I’m gonna jump into it just because I feel like I was I got I got. I got messaged a bunch this morning for the Eden team, and I’m gonna have to chat with Josh, like, right for this call. So.
19 00:04:44.107 ⇒ 00:04:46.329 Robert Tseng: yeah, I was like scrubbing this a bit.
20 00:04:46.734 ⇒ 00:04:49.170 Robert Tseng: I guess maybe we’ll just because it’s just.
21 00:04:50.170 ⇒ 00:04:56.720 Robert Tseng: And, Annie, we’ll just talk about stuff that’s relevant to you. We’ll start with Annie today
22 00:04:57.250 ⇒ 00:04:59.619 Robert Tseng: because we left off with you.
23 00:05:01.240 ⇒ 00:05:02.730 Robert Tseng: Yeah. So
24 00:05:03.110 ⇒ 00:05:08.050 Robert Tseng: I saw that you kind of knocked out a couple of the queries, which is great. I think those are ready to send
25 00:05:08.568 ⇒ 00:05:12.400 Robert Tseng: small adjustment on the sales breakdown by state. Let’s just like
26 00:05:13.000 ⇒ 00:05:28.986 Robert Tseng: not limited to Florida. Let’s just include all the States, because I think he changed this request yesterday. But yeah, I think for these things. I’m just like telling you who to tag in the General analytics channel, and you can just you can just send it to them directly.
27 00:05:29.300 ⇒ 00:05:33.830 Annie Yu: So should I send them the query, or like a Csv. Or so.
28 00:05:33.830 ⇒ 00:05:40.739 Robert Tseng: I think the Csv export would be better. So maybe I’ll just give you a better sense. So like this is like their Monday board. So the
29 00:05:41.210 ⇒ 00:05:56.499 Robert Tseng: they’re well. They added 4 more requests yesterday, I guess, but so it comes in through here. I triage it when it when we start working on it. I turn it into a linear ticket. So I think what you’ve been working on is for Jonah, Katie. And this Katie
30 00:05:56.931 ⇒ 00:06:19.910 Robert Tseng: I think this, the Jonah one and the Katie one are done. So I’m just like telling you to just send it back to them. And if you I mean. Just so like a 1 or 2 2 line thing I usually include, like the original request, or like, I paraphrase what they asked for, to give you enough context. But if you feel like you don’t know what to say, you can. Just you can ask me again, and I’ll follow up on your thread.
31 00:06:22.060 ⇒ 00:06:25.190 Annie Yu: Okay, I think I’ll copy you anyways.
32 00:06:25.370 ⇒ 00:06:26.959 Annie Yu: Yeah, yeah, you can.
33 00:06:26.960 ⇒ 00:06:27.870 Robert Tseng: CC. Me on anything.
34 00:06:27.870 ⇒ 00:06:29.989 Annie Yu: Anything more you want to add, yeah, okay.
35 00:06:30.610 ⇒ 00:06:31.160 Robert Tseng: Cool.
36 00:06:31.560 ⇒ 00:06:35.190 Robert Tseng: So that’s that. And then I think we are still.
37 00:06:35.800 ⇒ 00:06:41.559 Robert Tseng: Yeah. So we did get some feedback on this. So I do want to talk briefly about it.
38 00:06:43.560 ⇒ 00:06:52.820 Robert Tseng: yeah, I think the thing that I need to help with I was maybe
39 00:06:53.803 ⇒ 00:07:14.469 Robert Tseng: so like this is tied, related to helped with. Yeah, I mean, this particular request was to create a model for like Sema patients and like to to look at their margin over their life cycle. I think the actual Csv that we produced. You know, I I made this one. And then Annie added, a few more things
40 00:07:14.600 ⇒ 00:07:18.990 Robert Tseng: build on top of the query, yeah, we
41 00:07:19.170 ⇒ 00:07:26.499 Robert Tseng: it didn’t get us all the way there. It just kind of gives us like a overall view of like patient activity.
42 00:07:27.810 ⇒ 00:07:30.239 Robert Tseng: But then it doesn’t tell us, like.
43 00:07:31.490 ⇒ 00:07:38.157 Robert Tseng: yeah, it’s it’s just patient level prof profitability. I don’t even think it’s profitability. It’s just like,
44 00:07:40.510 ⇒ 00:07:50.839 Robert Tseng: yeah. Realize revenue and cogs. So I guess, yeah, just patient level revenue. And then we also share cogs. And then I guess you kind of infer profitability off of that.
45 00:07:51.040 ⇒ 00:08:01.849 Robert Tseng: There were other things that were discussed in the initial request. That, I think we’re going to help with doing like predictive churn, and also like to actually
46 00:08:02.010 ⇒ 00:08:07.440 Robert Tseng: well build in profitability into that model. So I listed out like, what are some of those other
47 00:08:07.540 ⇒ 00:08:14.780 Robert Tseng: kind of data points that we had discussed, and I was just trying to get Rebecca and Jonah to give some feedback on like what’s still important.
48 00:08:16.510 ⇒ 00:08:30.509 Robert Tseng: I know this is like pretty loaded request. So the conclusion now is, yes, they will want these things. And so I’ll I’m gonna split this off, create a couple more new tickets to add to enrich the existing query that we have here.
49 00:08:32.130 ⇒ 00:08:36.010 Robert Tseng: And but I think the more urgent thing is just
50 00:08:37.161 ⇒ 00:08:42.269 Robert Tseng: helping Rebecca with like forecasts.
51 00:08:42.610 ⇒ 00:08:50.850 Robert Tseng: So how that’s related. It’s not actually related to this. I think she didn’t really understand. Like she was just trying to
52 00:08:51.020 ⇒ 00:08:52.970 Robert Tseng: push her own agenda onto this.
53 00:08:53.140 ⇒ 00:08:58.250 Robert Tseng: So basically 2 tickets. One is like, I need to update the existing
54 00:08:58.787 ⇒ 00:09:07.129 Robert Tseng: like product level forecast that I did a couple of months ago. We didn’t do it by vial size. We just did it by product sales. And so
55 00:09:07.510 ⇒ 00:09:17.529 Robert Tseng: I don’t know if we have that capability yet. I know Dame Lottie has been working on vile stuff. So I’m going to do what I can to update my model. And then, you know, hopefully, that’ll
56 00:09:17.690 ⇒ 00:09:28.679 Robert Tseng: kind of run in parallel to what didn’t Lot is doing on the file size so I could push that out and then we’ll go on to cover these things in a second ticket. So
57 00:09:28.900 ⇒ 00:09:35.310 Robert Tseng: that’s just giving you an update like that’s kind of the ongoing discussion with why this one is still open.
58 00:09:35.996 ⇒ 00:09:41.130 Robert Tseng: So nothing to do for you, Annie. I’m just like, kind of letting, you know, like, this is, that’s where this is headed.
59 00:09:42.750 ⇒ 00:09:43.510 Robert Tseng: Yeah.
60 00:09:45.495 ⇒ 00:09:54.009 Robert Tseng: so yeah, that’s everything that we’re waiting on client wise. I think I think you were adding a couple of things.
61 00:09:54.410 ⇒ 00:09:56.610 Robert Tseng: Anything else can I close this out? Are we done here?
62 00:09:58.190 ⇒ 00:10:03.290 Annie Yu: No, I haven’t added the things that she requested to add.
63 00:10:03.290 ⇒ 00:10:03.900 Robert Tseng: Okay.
64 00:10:04.920 ⇒ 00:10:05.620 Robert Tseng: Okay.
65 00:10:06.030 ⇒ 00:10:12.739 Annie Yu: I actually add part of it. But I have to make that top line customizable.
66 00:10:14.630 ⇒ 00:10:21.240 Robert Tseng: Okay, is that you think that’s gonna take a while? Because if.
67 00:10:21.240 ⇒ 00:10:21.870 Annie Yu: It is.
68 00:10:21.870 ⇒ 00:10:23.729 Robert Tseng: I’d rather delay it, because it’s not.
69 00:10:23.730 ⇒ 00:10:27.189 Annie Yu: Yeah, I, yeah, for this one. It’s not just like a easy
70 00:10:27.832 ⇒ 00:10:32.460 Annie Yu: fix. I have to create like a different calculate field.
71 00:10:32.850 ⇒ 00:10:43.069 Robert Tseng: Okay, I’m just gonna push it to end of week. I don’t think she’s urgently asking for it. Feel like this is cosmetic. So definitely. Not the highest priority. For now.
72 00:10:43.750 ⇒ 00:10:44.360 Annie Yu: Okay.
73 00:10:44.830 ⇒ 00:10:45.450 Robert Tseng: Okay.
74 00:10:46.244 ⇒ 00:10:48.620 Robert Tseng: Couple other things. Yeah.
75 00:10:49.090 ⇒ 00:10:49.440 Annie Yu: This one.
76 00:10:49.440 ⇒ 00:10:49.920 Robert Tseng: Here.
77 00:10:49.920 ⇒ 00:10:56.579 Annie Yu: Yeah, we can close this. Yeah, this one was by Mattesh last Friday. And I, yeah, thanks.
78 00:10:57.310 ⇒ 00:11:06.160 Robert Tseng: So he did push these, or he did bring these up in the leadership. Kpis, okay. Well.
79 00:11:07.160 ⇒ 00:11:12.039 Robert Tseng: it’s fine. We can close it out for now. But since you work on it, you’ll have context. But
80 00:11:12.240 ⇒ 00:11:18.260 Robert Tseng: basically the leadership gave him some feedback on the Kpis. They want him to adjust some of these things. So
81 00:11:18.480 ⇒ 00:11:22.159 Robert Tseng: he’s gonna be reporting on this every week now. So
82 00:11:22.440 ⇒ 00:11:30.939 Robert Tseng: I’m gonna try to get ahead of it and just like tag him in something before it closes out and be like, okay, what? What did we need to change about this? But
83 00:11:31.657 ⇒ 00:11:34.929 Robert Tseng: yeah, I think that’s on me. Okay.
84 00:11:36.710 ⇒ 00:11:46.000 Annie Yu: Okay. They’re now all in like separate workbooks. I’m not sure if that’s a big deal. But just just so you’re aware.
85 00:11:46.000 ⇒ 00:11:47.160 Robert Tseng: They are right.
86 00:11:48.270 ⇒ 00:11:50.260 Annie Yu: They are in different workbooks. Yeah.
87 00:11:50.260 ⇒ 00:11:54.129 Robert Tseng: Okay, I think that’s fine. He didn’t ask to consolidate, though.
88 00:11:54.650 ⇒ 00:11:55.210 Annie Yu: Okay.
89 00:11:56.760 ⇒ 00:12:00.090 Robert Tseng: Yeah. Any more progress here.
90 00:12:03.246 ⇒ 00:12:10.199 Annie Yu: For this one I’m waiting for forgot if it was way short. Dibali, I think a weish.
91 00:12:11.670 ⇒ 00:12:14.049 Robert Tseng: Yeah, customer count and intact difference.
92 00:12:14.220 ⇒ 00:12:14.870 Annie Yu: Yeah, yeah.
93 00:12:14.870 ⇒ 00:12:18.420 Awaish Kumar: My, you can see the changes I pushed
94 00:12:20.409 ⇒ 00:12:27.990 Awaish Kumar: in the production. So tax should, like the spend should be completely aligned, and also
95 00:12:28.230 ⇒ 00:12:31.160 Awaish Kumar: the new customer count was little bit
96 00:12:32.960 ⇒ 00:12:36.750 Awaish Kumar: different after the fix as well, but I am not sure
97 00:12:36.950 ⇒ 00:12:41.059 Awaish Kumar: why I’m looking into it. But the the main difference was that
98 00:12:41.210 ⇒ 00:12:45.450 Awaish Kumar: actually in the product sales summary. We are also excluding abundant orders.
99 00:12:51.330 ⇒ 00:12:51.890 Awaish Kumar: And.
100 00:12:51.890 ⇒ 00:12:54.029 Annie Yu: I mean, abandoned, or.
101 00:12:55.560 ⇒ 00:13:00.859 Awaish Kumar: Yeah, abandoned orders are excluded in product sales, summary calculations.
102 00:13:01.140 ⇒ 00:13:08.970 Awaish Kumar: While we were having we were considering them in the cohort revenue pretension summary model.
103 00:13:09.140 ⇒ 00:13:09.900 Awaish Kumar: So now I.
104 00:13:09.900 ⇒ 00:13:10.340 Robert Tseng: Yeah.
105 00:13:10.340 ⇒ 00:13:12.460 Awaish Kumar: Filter them out from this new table.
106 00:13:16.040 ⇒ 00:13:16.885 Robert Tseng: Okay,
107 00:13:20.430 ⇒ 00:13:29.381 Robert Tseng: so, product sales summary. Correct me. If I’m wrong, we use that one. Do we use that for any of the operational or marketing. So I guess what my point is.
108 00:13:30.480 ⇒ 00:13:40.870 Robert Tseng: we want to be more conservative on what orders we include when we’re using, like when we’re doing financial and operational reporting, because
109 00:13:41.010 ⇒ 00:13:46.780 Robert Tseng: that’s gonna tell leadership. This is the actual number of real orders and real sales
110 00:13:46.950 ⇒ 00:14:00.539 Robert Tseng: for marketing. We can, I mean, I think, that we can be a little bit more loose and include, because many of those abandoned orders will turn into real orders. We’re just trying to get a leading indicator and an early indicator of
111 00:14:00.660 ⇒ 00:14:02.740 Robert Tseng: marketing performance. So
112 00:14:03.050 ⇒ 00:14:11.110 Robert Tseng: I’m okay with including marketing or including abandoned orders in the in the mark, in in models used for marketing.
113 00:14:11.300 ⇒ 00:14:16.350 Robert Tseng: I don’t know if that’s reflected in the way that we’ve been doing it, but that’s how I reason through it.
114 00:14:20.730 ⇒ 00:14:26.950 Awaish Kumar: So like the main table which we use to refer always is product sales summary
115 00:14:27.110 ⇒ 00:14:32.800 Awaish Kumar: by transaction because they are looking. They are looking at that for Ncac.
116 00:14:32.980 ⇒ 00:14:36.280 Awaish Kumar: And we are removing abandoned orders from this table.
117 00:14:36.970 ⇒ 00:14:37.410 Robert Tseng: Oh, we are!
118 00:14:37.410 ⇒ 00:14:39.410 Awaish Kumar: We include it in other tables. Yeah.
119 00:14:42.310 ⇒ 00:14:42.780 Robert Tseng: Okay.
120 00:14:42.780 ⇒ 00:14:43.249 Awaish Kumar: So, can you.
121 00:14:43.250 ⇒ 00:14:47.039 Robert Tseng: Well, if we are excluding it already there, then we might as well exclude it.
122 00:14:48.300 ⇒ 00:14:57.179 Awaish Kumar: Yeah, in the product sales summary by transaction, we exclude orders with status, canceled error, and abandon.
123 00:14:59.070 ⇒ 00:15:03.979 Annie Yu: Wait before for this one for the Ltv. Key map. We are including them right.
124 00:15:06.220 ⇒ 00:15:08.830 Awaish Kumar: We were if I if I.
125 00:15:08.830 ⇒ 00:15:09.460 Robert Tseng: Yeah.
126 00:15:09.460 ⇒ 00:15:12.460 Awaish Kumar: If I do not include them, then it will have the same
127 00:15:12.670 ⇒ 00:15:17.890 Awaish Kumar: customer count. If I include them, then the new customer count will increase.
128 00:15:20.430 ⇒ 00:15:21.410 Annie Yu: Oh!
129 00:15:26.480 ⇒ 00:15:34.739 Robert Tseng: So excluding having the same exclusions, will will make sure that the customer counts match right?
130 00:15:36.330 ⇒ 00:15:39.139 Robert Tseng: Or are you saying the opposite? I didn’t really quite catch that.
131 00:15:39.730 ⇒ 00:15:45.149 Awaish Kumar: Yeah, I’m saying, if I exclude, if we, if you use same exclusions, then the
132 00:15:45.380 ⇒ 00:15:48.390 Awaish Kumar: customer count is almost the same.
133 00:15:49.300 ⇒ 00:15:49.960 Robert Tseng: Okay.
134 00:15:51.430 ⇒ 00:15:56.010 Awaish Kumar: Otherwise it’s going to increase. If I include the abundant orders as well.
135 00:15:56.330 ⇒ 00:15:58.939 Awaish Kumar: Yeah, no, we. We should just get them to match.
136 00:15:59.680 ⇒ 00:16:00.270 Annie Yu: Okay.
137 00:16:00.270 ⇒ 00:16:00.890 Awaish Kumar: Okay.
138 00:16:01.260 ⇒ 00:16:01.800 Robert Tseng: Yeah.
139 00:16:01.910 ⇒ 00:16:08.789 Robert Tseng: if it’s off by a few like, it’s it’s fine. We should just ship it. And then, like we can, I can explain away the difference.
140 00:16:09.910 ⇒ 00:16:12.820 Awaish Kumar: It’s it’s like by 50 customers.
141 00:16:13.140 ⇒ 00:16:16.319 Robert Tseng: Oh, wow, okay, that’s not insignificant.
142 00:16:18.130 ⇒ 00:16:21.199 Robert Tseng: 50 customers over lifetime, I see.
143 00:16:22.830 ⇒ 00:16:29.019 Robert Tseng: Yeah, I mean, we still need to look into that. But I think it’s like appropriate to ship first.st
144 00:16:33.940 ⇒ 00:16:42.460 Robert Tseng: right cause if even if we ship it like, Andy can still build with it, you may change the you may, you may find something else later on, but at least she will be unblocked.
145 00:16:44.090 ⇒ 00:16:47.549 Awaish Kumar: Yeah, yeah, she can build it, and
146 00:16:48.480 ⇒ 00:16:53.869 Awaish Kumar: I can push the fix afterwards. But we just just know that there should be minor.
147 00:16:56.170 ⇒ 00:16:56.660 Annie Yu: Fascinating.
148 00:16:56.660 ⇒ 00:16:57.300 Awaish Kumar: Incorrect.
149 00:16:58.190 ⇒ 00:16:58.790 Annie Yu: Okay.
150 00:16:58.790 ⇒ 00:16:59.720 Awaish Kumar: For now.
151 00:16:59.720 ⇒ 00:17:03.649 Annie Yu: So for the new customer account. Even if we
152 00:17:03.990 ⇒ 00:17:13.839 Annie Yu: also exclude those abandoned orders, the numbers are still just a little different from the product sales. Summary. Right? Okay?
153 00:17:13.849 ⇒ 00:17:18.649 Awaish Kumar: If that’s yeah. If I include the abundant orders, then it it increases by
154 00:17:19.009 ⇒ 00:17:21.859 Awaish Kumar: like hundreds, like 2, 300 400 custom.
155 00:17:23.800 ⇒ 00:17:28.509 Awaish Kumar: Okay? And we don’t go ahead. Yeah, sorry.
156 00:17:28.900 ⇒ 00:17:30.330 Annie Yu: And we don’t know why.
157 00:17:31.600 ⇒ 00:17:36.479 Awaish Kumar: Yeah, I’m looking into it like I have not found any filter or anything.
158 00:17:37.060 ⇒ 00:17:41.600 Awaish Kumar: Could be the reason. So I’m not sure. Where is it coming from?
159 00:17:42.430 ⇒ 00:17:51.029 Annie Yu: Okay, okay, yeah. Cause Mattesh is aware of the difference. So I wanna get back to him and
160 00:17:51.890 ⇒ 00:17:56.679 Annie Yu: kind of explain how how it is different.
161 00:17:57.010 ⇒ 00:18:05.909 Robert Tseng: Yeah, it would be great. Yeah, even though, if we don’t fix it a wish. If you just have an explanation for why, it’s different. I think that that’d be helpful, for now.
162 00:18:06.740 ⇒ 00:18:07.360 Awaish Kumar: Okay.
163 00:18:07.860 ⇒ 00:18:15.100 Robert Tseng: Okay, okay, cool. So let’s keep pushing on this one. I’m gonna bring this one back into
164 00:18:15.310 ⇒ 00:18:21.440 Robert Tseng: in progress because Annie can be unblocked. And I’m gonna update the date. We’re gonna try to get this to him.
165 00:18:22.830 ⇒ 00:18:24.829 Robert Tseng: I would say, this is high priority.
166 00:18:25.420 ⇒ 00:18:27.389 Robert Tseng: because he’s been waiting on this for a while.
167 00:18:28.160 ⇒ 00:18:32.788 Robert Tseng: Okay, cool. So that’s that. And then,
168 00:18:36.240 ⇒ 00:18:40.229 Robert Tseng: yeah, I already talked about that product. Drill down stuff.
169 00:18:40.610 ⇒ 00:18:54.270 Annie Yu: This one, I would say, still work in progress. Well, I feel like this ticket is getting a little bit large, but I wasn’t able to do the category level yet.
170 00:18:55.111 ⇒ 00:18:59.179 Annie Yu: There’s some pending tickets there and then.
171 00:18:59.620 ⇒ 00:19:07.119 Annie Yu: the products switching as well. And then there’s another Ltv metric table that I
172 00:19:07.410 ⇒ 00:19:16.390 Annie Yu: a wish, and I were able to push. But then yesterday. If you scroll down to yeah, here, there’s also like
173 00:19:17.420 ⇒ 00:19:20.420 Annie Yu: number difference between
174 00:19:20.930 ⇒ 00:19:26.529 Annie Yu: the product revenue summary, which is what we are using for that Ltv metric table. For this
175 00:19:27.020 ⇒ 00:19:30.089 Annie Yu: for this dashboard, and compared to the
176 00:19:30.770 ⇒ 00:19:34.109 Annie Yu: the sales data, join monthly otv cohorts.
177 00:19:35.530 ⇒ 00:19:36.510 Robert Tseng: Yeah.
178 00:19:41.680 ⇒ 00:19:43.411 Annie Yu: Yeah. And they’re they’re not like.
179 00:19:44.940 ⇒ 00:19:46.130 Awaish Kumar: Are you using?
180 00:19:47.400 ⇒ 00:19:51.130 Awaish Kumar: Are you using sales data? Join monthly Ltv Cohorts table.
181 00:19:52.110 ⇒ 00:19:54.590 Annie Yu: I think that
182 00:19:59.360 ⇒ 00:20:04.649 Annie Yu: the current dashboard that they use is connected to that one. Yeah.
183 00:20:05.450 ⇒ 00:20:11.320 Awaish Kumar: So if you are using that table, it should not be different. Because if this table is based on product sales somebody
184 00:20:11.440 ⇒ 00:20:12.660 Awaish Kumar: by transaction.
185 00:20:14.827 ⇒ 00:20:19.690 Annie Yu: Then what about the product revenue summary? That’s the one we use for.
186 00:20:19.690 ⇒ 00:20:21.339 Awaish Kumar: That’s different. Yeah, that’s different.
187 00:20:23.290 ⇒ 00:20:23.970 Annie Yu: Okay.
188 00:20:23.970 ⇒ 00:20:25.350 Robert Tseng: Sounds like, yeah.
189 00:20:25.620 ⇒ 00:20:34.129 Robert Tseng: sorry. I don’t want to spend too much time on this. So any any wish, if you guys could meet seems like you both understand where it seems like there’s some miscommunication on what models to use here.
190 00:20:34.560 ⇒ 00:20:39.729 Robert Tseng: And then I guess this is for Joanna and Carter, right? So in the product
191 00:20:40.310 ⇒ 00:20:43.960 Robert Tseng: team analytics channel. If you can just give an update on like
192 00:20:44.150 ⇒ 00:20:47.519 Robert Tseng: where we’re at with this like what’s been done, what hasn’t been done.
193 00:20:47.780 ⇒ 00:20:50.599 Robert Tseng: If you need me to help word submit that I think it’d be helpful.
194 00:20:50.950 ⇒ 00:20:52.780 Robert Tseng: Yeah, I’m assuming. I guess you.
195 00:20:53.030 ⇒ 00:20:57.760 Annie Yu: And no, Joanna has been like pinging me
196 00:20:59.518 ⇒ 00:21:04.910 Annie Yu: and she’s she’s updated on what’s like the current status.
197 00:21:06.010 ⇒ 00:21:06.365 Robert Tseng: Okay.
198 00:21:09.030 ⇒ 00:21:16.880 Annie Yu: And I don’t think clatter is like very involved in this, at least this request, because things are coming from Joanna.
199 00:21:17.170 ⇒ 00:21:17.810 Robert Tseng: Okay.
200 00:21:21.450 ⇒ 00:21:36.599 Robert Tseng: yeah, I think it’d be helpful for me, though, because I’m talking to Josh in 10 min. And he’s gonna be like, what is the team working on. And I think if you’re it, seems like you guys have done a lot here. So I wanna make sure that I know how to tell him, like what we’re building for, Joanna, and where where we’re stuck.
201 00:21:40.330 ⇒ 00:21:44.690 Robert Tseng: I mean, I can go. I can review this as well. So yeah, just
202 00:21:45.920 ⇒ 00:21:54.129 Robert Tseng: you can, you guys meet on this? Try to get on blocks. I’m going to review this ticket and try to. I’ll summarize it. And and then you can correct me if I’m wrong.
203 00:21:54.790 ⇒ 00:21:55.890 Annie Yu: Okay. Okay.
204 00:22:03.550 ⇒ 00:22:04.160 Robert Tseng: Okay.
205 00:22:07.680 ⇒ 00:22:15.320 Robert Tseng: okay, yeah. A couple more things here, so that everything else is in progress. There’s some things that you’re trying to close out.
206 00:22:16.006 ⇒ 00:22:20.614 Robert Tseng: Yeah, let’s go to Dame Alade and wish
207 00:22:22.300 ⇒ 00:22:25.019 Robert Tseng: I think. Alright, we’ll go to Blotte.
208 00:22:25.970 ⇒ 00:22:27.100 Robert Tseng: So
209 00:22:28.440 ⇒ 00:22:39.059 Robert Tseng: yeah, anything that we can do here. Can we close this out, or I guess the med kit a couple of things broke. So are we all good there, or I’m sure that’s probably something that Josh is
210 00:22:39.230 ⇒ 00:22:45.089 Robert Tseng: why Josh want randomly wants to talk to me, because he probably saw it wasn’t there for a couple of times.
211 00:22:46.022 ⇒ 00:22:53.160 Demilade Agboola: Okay? So the market was being caught by the Rejects
212 00:22:53.300 ⇒ 00:23:05.030 Demilade Agboola: and the order name the other product name changed and that’s what happened like they changed the name. However. I have seen the
213 00:23:05.430 ⇒ 00:23:14.659 Demilade Agboola: product ids. So I am now using the product ids to catch it. So that was the error yesterday, but today was weird because
214 00:23:15.390 ⇒ 00:23:17.410 Demilade Agboola: the the Pdf.
215 00:23:17.530 ⇒ 00:23:26.219 Demilade Agboola: Didn’t have med kits, but the live dashboard, because, you know, he sent both the live dashboard as well as the Pdf. The live dashboard had it. So it was.
216 00:23:26.480 ⇒ 00:23:35.069 Demilade Agboola: I don’t know. It’s it’s weird in that result in that. It was just weird. So I basically had to download the Pdf and send that as a fix.
217 00:23:35.707 ⇒ 00:23:38.629 Demilade Agboola: But I will look at it.
218 00:23:39.270 ⇒ 00:23:53.740 Demilade Agboola: I will look at it to, you know, tomorrow morning. Just keep an eye, and just be sure that, like the actual full results get sent. But the the fix is there like we? We do, but we are tracking the med kits, and everything is fine.
219 00:23:55.850 ⇒ 00:24:00.710 Robert Tseng: Okay, do so. Do we know why there was a disparity?
220 00:24:03.440 ⇒ 00:24:09.889 Robert Tseng: So you’re basically saying the dashboard and the Pdf like weren’t weren’t the same, so you had to go and manually download it and send it out.
221 00:24:10.100 ⇒ 00:24:11.190 Robert Tseng: Yes, said.
222 00:24:11.640 ⇒ 00:24:21.656 Demilade Agboola: Yeah, I will look into like the subscription settings for like what? Like what we were asking of it. Also, speaking of subscriptions, I just wanted to also point out that
223 00:24:22.140 ⇒ 00:24:27.060 Demilade Agboola: Even at Greenford, us at AI, is being used to.
224 00:24:27.060 ⇒ 00:24:27.490 Robert Tseng: Oh, shoot!
225 00:24:27.490 ⇒ 00:24:31.929 Demilade Agboola: Descriptions. Yeah, and then automate and send that to like the slack channels.
226 00:24:32.050 ⇒ 00:24:41.699 Demilade Agboola: So I did that automatically. Today, I sent an effect I did automatically, and I did that manually today, but subsequently would either have to use another account.
227 00:24:41.980 ⇒ 00:24:47.050 Demilade Agboola: or we’ll have to put it back as if you were whichever.
228 00:24:47.050 ⇒ 00:24:51.869 Robert Tseng: You was there. Can we just use the Robert one, since you were using it already?
229 00:24:52.870 ⇒ 00:24:58.039 Demilade Agboola: Sure, but I’ll need to sign in and come and set like gmail filter rules and stuff.
230 00:24:59.190 ⇒ 00:25:03.179 Robert Tseng: Oh, shoot! Okay. I didn’t realize that that. Oh, okay,
231 00:25:05.100 ⇒ 00:25:10.289 Robert Tseng: dude like, if it’s easier to just bring it back like I’ll bring it back, but you might have to reset it up again.
232 00:25:10.590 ⇒ 00:25:23.899 Demilade Agboola: Oh, no, no! Subscriptions are fine, like the subscription are still there. All the tasks are still there. It just doesn’t consider the account as a viewer anymore. So it can’t give you access to that. So once we just put it back, it will be fine. It should be fine.
233 00:25:24.390 ⇒ 00:25:27.149 Robert Tseng: Okay, yeah. You know what? I’m just gonna
234 00:25:28.290 ⇒ 00:25:33.400 Robert Tseng: well, I was just add, it adds, like a couple $100 for them, like, I don’t. I don’t really care. I’ll just do it.
235 00:25:33.774 ⇒ 00:25:43.549 Robert Tseng: But it it may not happen right away. I think there’s like an up to a 12 h delay, so I’m gonna I’ll do it right away. But we’ll see if we can bring it back in.
236 00:25:43.820 ⇒ 00:25:45.389 Robert Tseng: I’ll I’ll tag you.
237 00:25:45.720 ⇒ 00:25:46.719 Demilade Agboola: Alright, sounds good.
238 00:25:47.290 ⇒ 00:25:47.930 Robert Tseng: Okay?
239 00:25:48.340 ⇒ 00:25:52.680 Robert Tseng: So yeah, that’s that’s my bad. I didn’t realize that that was
240 00:25:53.860 ⇒ 00:25:57.970 Robert Tseng: we were stuck on that. Okay? And then.
241 00:25:59.720 ⇒ 00:26:03.020 Robert Tseng: yeah, a couple of things I wanted to chat. So this one
242 00:26:03.350 ⇒ 00:26:11.450 Robert Tseng: intermediary pharmacy statuses I did haven’t touched on this in a while, because I know you were trying to catch up on the new products. But
243 00:26:14.300 ⇒ 00:26:20.049 Robert Tseng: yeah, just because and because we are trying to build towards like a end to end order.
244 00:26:20.350 ⇒ 00:26:25.440 Robert Tseng: right? We’re trying to add more steps to the order. Summary, yeah.
245 00:26:26.480 ⇒ 00:26:27.060 Demilade Agboola: So just
246 00:26:27.060 ⇒ 00:26:32.969 Demilade Agboola: is this is this data that’s available somewhere. Are we just trying to push that? We add it to some web hook somewhere.
247 00:26:34.032 ⇒ 00:26:42.209 Robert Tseng: Yeah, I I think this is more of like a I’m not sure like where it is like, I think I think we created this because Rob said that like.
248 00:26:42.960 ⇒ 00:26:49.879 Robert Tseng: you know, you can get some of these storage statuses in our web hooks. And you were gonna you were. Gonna look at the existing web hooks to see
249 00:26:50.210 ⇒ 00:26:55.229 Robert Tseng: if there’s anything else coming in that we’re not already modeled. And I think that’s basically what that was.
250 00:26:57.030 ⇒ 00:26:57.810 Demilade Agboola: Okay.
251 00:26:58.030 ⇒ 00:27:06.130 Demilade Agboola: Alright. I will just follow up with Rob on that and just see if there is anything
252 00:27:06.713 ⇒ 00:27:11.699 Demilade Agboola: like any other data that we’re not. We don’t have in scope, in terms of the statuses.
253 00:27:12.920 ⇒ 00:27:13.650 Robert Tseng: Yeah.
254 00:27:14.131 ⇒ 00:27:35.910 Robert Tseng: yeah, ideally, you would start to like, kind of take over the web hook stuff. So I mean, we’re not adding anything new. It’s just like, if there’s anything else that’s coming in that we don’t already have modeled, we can do that. But anything that’s like adding a new web hook that like, I’m kind of deflecting that because of the Emr deflection. You know. Migration, that’s happening. And
255 00:27:36.210 ⇒ 00:27:40.580 Robert Tseng: I don’t. Yeah, I’m I’m basically using that as the excuse for not taking on that work.
256 00:27:41.080 ⇒ 00:27:41.750 Demilade Agboola: Okay.
257 00:27:41.960 ⇒ 00:27:43.069 Demilade Agboola: Sounds good.
258 00:27:43.400 ⇒ 00:27:51.360 Robert Tseng: Okay, and then this one, I think, is this done?
259 00:27:55.452 ⇒ 00:27:56.980 Demilade Agboola: Yes, this is done.
260 00:27:57.300 ⇒ 00:27:57.930 Robert Tseng: Okay.
261 00:28:00.130 ⇒ 00:28:06.230 Robert Tseng: I don’t remember who asked for that. And okay, I hope that. Yeah, anyway. So that that’s like an old one.
262 00:28:07.860 ⇒ 00:28:13.698 Robert Tseng: Yeah. Okay? So yeah, Demo, I think,
263 00:28:14.410 ⇒ 00:28:19.110 Robert Tseng: yeah, between the med kits, just making sure all those reports are good. And then, yeah, just kind of
264 00:28:19.380 ⇒ 00:28:21.519 Robert Tseng: doing more investigation into
265 00:28:21.840 ⇒ 00:28:35.089 Robert Tseng: helping out with the vial thing, because I’m doing the forecasting and then making sure that we’re good on the order statuses. There’s nothing like urgent for you to push out today. I think it’s more of just like, you know. Get ready for this support on this stuff.
266 00:28:36.700 ⇒ 00:28:37.980 Demilade Agboola: That’s awesome.
267 00:28:38.470 ⇒ 00:28:40.470 Robert Tseng: Yeah, that always.
268 00:28:41.450 ⇒ 00:28:48.420 Robert Tseng: Yeah. Thank you for the investigation on the customer. I/O stuff. Yeah, if you can push that, I think that’d be helpful.
269 00:28:50.840 ⇒ 00:28:57.279 Robert Tseng: yeah. Once you check the segment syncs that’d be good. And then I also brought this back into cycle for you.
270 00:29:00.800 ⇒ 00:29:05.360 Robert Tseng: I don’t know if this is possible for us to do. I think you were telling me that like
271 00:29:06.990 ⇒ 00:29:15.060 Robert Tseng: we like, yeah, anyway, like, this is not not urgent, but it’s been going on for a while, and one of the.
272 00:29:15.060 ⇒ 00:29:16.049 Awaish Kumar: Which one is, that.
273 00:29:16.650 ⇒ 00:29:17.119 Robert Tseng: This is like.
274 00:29:17.120 ⇒ 00:29:18.720 Awaish Kumar: Built this script already.
275 00:29:19.182 ⇒ 00:29:33.980 Awaish Kumar: but I’m like we have never got anything to run it right? So I like I tested manually on mix panel as you showed me that you like, we can create a user and delete it. But for end to end flow.
276 00:29:34.090 ⇒ 00:29:39.200 Awaish Kumar: If we have some real user or maybe some test user, which is basically
277 00:29:39.749 ⇒ 00:29:46.930 Awaish Kumar: present in all the sources. So you can run end to end script. But right now we have just tested
278 00:29:47.705 ⇒ 00:29:51.489 Awaish Kumar: for example, in vex panel, but in other like I have not
279 00:29:52.157 ⇒ 00:29:58.600 Awaish Kumar: tested it. But what I mentioned was that skip is ready whenever we get an input we can
280 00:29:59.230 ⇒ 00:30:02.310 Awaish Kumar: then test and deploy on a schedule.
281 00:30:02.310 ⇒ 00:30:02.950 Robert Tseng: Okay.
282 00:30:07.540 ⇒ 00:30:08.390 Robert Tseng: got it.
283 00:30:09.680 ⇒ 00:30:15.820 Robert Tseng: Okay? Then, I don’t really think that there’s more work to do. This is more just. They need to give us something to delete which I haven’t gotten anything yet.
284 00:30:18.620 ⇒ 00:30:38.139 Robert Tseng: okay. So yeah, between customer I/O stuff. And then obviously, you saw that message. I think the Cro stuff is kind of urgent. I think Josh is gonna be talking to me about that as well in a couple of minutes. So we’ll just keep following up on that thread. But basically, we asked, we got, we gotta bring in the short term solution. So
285 00:30:38.539 ⇒ 00:30:45.810 Robert Tseng: yeah, I don’t know if, did you have any more thoughts kind of since I sent that message on slack. I didn’t really monitor the follow up there.
286 00:30:48.670 ⇒ 00:30:51.190 Awaish Kumar: Okay, no, I don’t have anything else here.
287 00:30:51.680 ⇒ 00:30:52.280 Robert Tseng: Okay.
288 00:30:52.750 ⇒ 00:31:02.980 Robert Tseng: Yeah. Looks like nobody said anything. So, okay, yeah.
289 00:31:04.910 ⇒ 00:31:10.619 Awaish Kumar: For the customer. I/O, okay, if the data comes in, we can. I can start modeling right.
290 00:31:10.890 ⇒ 00:31:11.420 Robert Tseng: Yep.
291 00:31:12.240 ⇒ 00:31:12.880 Awaish Kumar: Okay.
292 00:31:15.070 ⇒ 00:31:25.180 Robert Tseng: Okay, cool. Yeah, I’m gonna chat with Josh in a couple of minutes. I know we were just kind of reacting and trying to close out stuff. So yeah, I think we’ll spend.
293 00:31:25.330 ⇒ 00:31:27.649 Robert Tseng: We’ll we’ll do a little bit more bye.
294 00:31:29.730 ⇒ 00:31:42.903 Robert Tseng: like actual like more feature, like actual sprint sprint planning tomorrow onwards. Yeah. There’s like a few other things that are in cycle that I haven’t touched on, that you’re not actively working on. But
295 00:31:44.620 ⇒ 00:31:47.449 Robert Tseng: okay, yeah, hopefully, that’s that’s good for. Now.
296 00:31:51.470 ⇒ 00:31:52.880 Annie Yu: Okay. Thank you.
297 00:31:52.880 ⇒ 00:31:54.760 Robert Tseng: Alright! Thanks everyone. Bye.