Meeting Title: Data Team Weekly Sync Date: 2025-07-02 Meeting participants: Robert Tseng, Mitesh Patel, Demilade Agboola, Awaish Kumar, Josh
WEBVTT
1 00:02:13.240 ⇒ 00:02:14.070 Demilade Agboola: Add one.
2 00:02:16.340 ⇒ 00:02:18.590 Robert Tseng: He didn’t want it. Hey? Wish.
3 00:02:21.000 ⇒ 00:02:21.800 Awaish Kumar: Hello!
4 00:02:27.560 ⇒ 00:02:37.490 Robert Tseng: Okay, let’s let’s get into it. Let me screen okay. So
5 00:02:40.990 ⇒ 00:02:43.179 Robert Tseng: it seems like.
6 00:02:52.340 ⇒ 00:02:58.906 Robert Tseng: okay, I don’t. It doesn’t look like anything has moved since yesterday. But alright, we’ll just. We’ll just kind of go through each one.
7 00:03:00.310 ⇒ 00:03:05.550 Robert Tseng: I’m not gonna speak to any of these. Yeah. How about. We talk about this one
8 00:03:10.870 ⇒ 00:03:11.900 Robert Tseng: stimulated.
9 00:03:20.130 ⇒ 00:03:26.950 Demilade Agboola: Yeah. So this model has been merged into production. So it’s actually live right now only.
10 00:03:28.010 ⇒ 00:03:31.529 Demilade Agboola: But I don’t given that. We now have
11 00:03:35.010 ⇒ 00:03:38.250 Demilade Agboola: Given that we now have like treatment. Id.
12 00:03:38.690 ⇒ 00:03:43.939 Demilade Agboola: I might need to like, look into this again, to be honest, because if there’s a treatment Id.
13 00:03:44.920 ⇒ 00:03:49.980 Demilade Agboola: we could just potentially just get the refills directly from the treatment table.
14 00:03:52.550 ⇒ 00:03:54.990 Demilade Agboola: Yeah. So I don’t know how.
15 00:03:55.170 ⇒ 00:04:01.800 Demilade Agboola: If this is still the best way to go about. I’ll look into that if this is still the best way to go about it, or we just need to like, look into something else.
16 00:04:03.330 ⇒ 00:04:03.930 Robert Tseng: Okay.
17 00:04:06.740 ⇒ 00:04:18.050 Demilade Agboola: But yeah, it’s in production like this one. The version previous version is in production right now, it’s just like, Do we still want to do it this way, or should we try and change things depending on like the new.
18 00:04:22.840 ⇒ 00:04:28.519 Robert Tseng: Okay. Yeah. I’m gonna just wait for you to kinda tell me what whether we should change it or not.
19 00:04:29.260 ⇒ 00:04:32.960 Demilade Agboola: Yeah, that makes sense. I will. I’ll go through and let you know.
20 00:04:33.610 ⇒ 00:04:43.580 Robert Tseng: Okay? No, that’s that’s just for my own mental notes. So this, these are get requests that
21 00:04:43.740 ⇒ 00:04:48.000 Robert Tseng: we’re not picking on sending them to.
22 00:04:49.370 ⇒ 00:04:56.629 Robert Tseng: We didn’t text him, yeah, okay, yeah. I wish on this one.
23 00:05:01.330 ⇒ 00:05:06.530 Awaish Kumar: Yes, I am working on this. So
24 00:05:07.782 ⇒ 00:05:10.620 Awaish Kumar: it’s like everything else is working
25 00:05:10.890 ⇒ 00:05:19.289 Awaish Kumar: so. But the thing with the mix panel, it’s basically the Api endpoint is, is.
26 00:05:20.410 ⇒ 00:05:23.970 Awaish Kumar: it shows successful deletion. But it actually doesn’t delete
27 00:05:24.220 ⇒ 00:05:26.959 Awaish Kumar: the profile. I’m just looking at that.
28 00:05:29.190 ⇒ 00:05:40.659 Robert Tseng: Yeah, I mean, I think we just have to manually delete it. I don’t think that’s a problem. There’s only 4, right? So if you could add the other 3 in in this ticket. Remember, I just started one. And then, yeah, you’re you’re supposed to fill it out.
29 00:05:40.930 ⇒ 00:05:48.690 Awaish Kumar: Okay. So I, the other ticket about offline spend. I actually Mark marked it as done.
30 00:05:49.270 ⇒ 00:05:53.500 Awaish Kumar: I have shared the link in the zoom chat.
31 00:05:53.670 ⇒ 00:05:56.260 Awaish Kumar: Basically, this is the sheet where I’m
32 00:05:56.650 ⇒ 00:05:59.309 Awaish Kumar: like, I’ve written. Read it in the script
33 00:05:59.430 ⇒ 00:06:04.640 Awaish Kumar: now. It is running every hour in basically Dexter.
34 00:06:06.500 ⇒ 00:06:07.990 Awaish Kumar: It’s from.
35 00:06:09.650 ⇒ 00:06:10.640 Robert Tseng: Okay.
36 00:06:10.640 ⇒ 00:06:16.220 Awaish Kumar: So like. But I was with, and the old script is still running
37 00:06:16.390 ⇒ 00:06:20.350 Awaish Kumar: through the app script, and I was not able to.
38 00:06:21.090 ⇒ 00:06:29.950 Awaish Kumar: What you say deactivated. So I just created a new sheet where we are writing the data
39 00:06:30.670 ⇒ 00:06:34.479 Awaish Kumar: this. Yeah, the sheet? 5. Yeah, I have to just
40 00:06:35.000 ⇒ 00:06:40.930 Awaish Kumar: name it as the the sheet 5 is basically the joins all of them together toward.
41 00:06:42.310 ⇒ 00:06:44.159 Robert Tseng: Okay, can you? Yeah.
42 00:06:44.530 ⇒ 00:06:50.890 Robert Tseng: So we fix the aggregation problem here. All the other streams are pretty much. There’s there’s a live. I see. July first.st
43 00:06:51.050 ⇒ 00:06:54.100 Robert Tseng: I see July second. So
44 00:06:54.320 ⇒ 00:07:00.479 Robert Tseng: a little bit inconsistent. They seem like they come at different times of day. But generally this is daily data.
45 00:07:00.938 ⇒ 00:07:10.820 Robert Tseng: And so she 5. Is you fix the aggregation there? Okay? And then, can you? Can you just follow up and share that this with Kyle and Stuart in that thread.
46 00:07:12.620 ⇒ 00:07:14.169 Robert Tseng: or do you need me to point it out?
47 00:07:15.250 ⇒ 00:07:17.630 Awaish Kumar: No, I I will just let them know.
48 00:07:18.420 ⇒ 00:07:21.690 Robert Tseng: Okay, cool? So yeah, that should be fixed.
49 00:07:21.850 ⇒ 00:07:26.469 Robert Tseng: And we’re keeping. We’re keeping the app script. We just we just set it up on a different one.
50 00:07:26.760 ⇒ 00:07:28.399 Robert Tseng: I mean, this is gonna be.
51 00:07:28.400 ⇒ 00:07:34.960 Awaish Kumar: I don’t have the permission to deactivate it like we don’t need that, but I can’t be like
52 00:07:35.240 ⇒ 00:07:37.870 Awaish Kumar: anyone who has the permission can just
53 00:07:38.410 ⇒ 00:07:42.020 Awaish Kumar: read the sheet, or drop this app script.
54 00:07:42.950 ⇒ 00:07:53.399 Robert Tseng: Okay, I’ll probably keep it. Live for a week, just to make sure, in case I imagine they’ll take your sheet. But they’ll still reference both, and then, probably after a week, I’ll I’ll I’ll cut it off.
55 00:07:55.430 ⇒ 00:07:56.010 Awaish Kumar: Okay.
56 00:07:56.730 ⇒ 00:08:00.310 Robert Tseng: Okay. But we check that. This is the same like.
57 00:08:00.920 ⇒ 00:08:04.359 Awaish Kumar: Yeah, like, I have verified only few rows in the
58 00:08:04.870 ⇒ 00:08:07.770 Awaish Kumar: at the end. There are. There are more
59 00:08:07.960 ⇒ 00:08:14.429 Awaish Kumar: more rows, like one or 2, just because it ran at a different time. But yeah, everything else.
60 00:08:14.560 ⇒ 00:08:15.590 Awaish Kumar: It was the same.
61 00:08:17.150 ⇒ 00:08:25.550 Robert Tseng: Okay, cool. Then last thing before I ask Mattesh what he’s here for. But this one, yeah. Where are we at with this.
62 00:08:31.410 ⇒ 00:08:32.740 Demilade Agboola: What task is this?
63 00:08:36.260 ⇒ 00:08:37.160 Demilade Agboola: Oh! This one already.
64 00:08:37.169 ⇒ 00:08:38.299 Robert Tseng: Jonah. Yeah.
65 00:08:40.519 ⇒ 00:08:44.109 Demilade Agboola: Yeah, I need to push the model into production, actually.
66 00:08:44.809 ⇒ 00:08:47.509 Demilade Agboola: But I built it locally. I just need to push it.
67 00:08:48.279 ⇒ 00:08:49.219 Demilade Agboola: Okay, so.
68 00:08:49.220 ⇒ 00:08:49.819 Robert Tseng: Yes, yes.
69 00:08:49.820 ⇒ 00:08:50.610 Demilade Agboola: Based on this.
70 00:08:51.700 ⇒ 00:08:59.740 Robert Tseng: Remind me like what this like. Why, this is better like, I kind of wrote notes 2 weeks ago. I don’t really have context on this anymore.
71 00:09:01.699 ⇒ 00:09:09.610 Demilade Agboola: So this is just we have. We’ll have a model. And the idea of the model is the output is what the request is.
72 00:09:10.080 ⇒ 00:09:10.880 Robert Tseng: Yeah.
73 00:09:10.880 ⇒ 00:09:16.539 Robert Tseng: Monthly Monthly report by a State. That accounting is asked for before.
74 00:09:17.130 ⇒ 00:09:18.799 Demilade Agboola: Exactly so by the time
75 00:09:19.870 ⇒ 00:09:25.629 Demilade Agboola: it’s just the output we’ll just get the output from the model and send it to them. So it’s it’s we don’t have to like, keep
76 00:09:25.870 ⇒ 00:09:32.700 Demilade Agboola: writing your models or like adjusting it. It’s just, Hey, take the output from this model. Maybe we’ll filter it to the last month or something today.
77 00:09:33.880 ⇒ 00:09:35.880 Robert Tseng: Okay, I
78 00:09:36.220 ⇒ 00:09:47.020 Robert Tseng: it may be. Well, I don’t think the ask is, respond to this. I’m trying to. How is this related to the amortization kind of thing that we’re doing as well.
79 00:09:48.720 ⇒ 00:09:54.750 Demilade Agboola: Oh, the amortization is slightly different, because that will change. How we calculate revenue.
80 00:09:55.610 ⇒ 00:09:57.839 Robert Tseng: Will it impact this model is what I’m saying.
81 00:09:59.141 ⇒ 00:10:06.749 Demilade Agboola: I mean, if they want us to use revenue that way. Yes, like, if we change the definition of revenue that we’re using in this model. Yes.
82 00:10:07.700 ⇒ 00:10:08.290 Robert Tseng: Okay.
83 00:10:10.860 ⇒ 00:10:13.500 Demilade Agboola: Which I think we will us that wants this as well.
84 00:10:14.160 ⇒ 00:10:21.600 Robert Tseng: Yeah, that’s okay. We can cross that bridge when we get there. Okay, yeah, no. I think I think we should. Just, yeah, we should have this in production. First.st
85 00:10:24.150 ⇒ 00:10:33.150 Robert Tseng: Okay, moving that? Yeah. Mattesh, I guess. Did you have? What did you have any questions.
86 00:10:33.780 ⇒ 00:10:44.830 Mitesh Patel: Yeah, I have a couple of questions to help me understand the this report a little better, and then I have a request. I meant to write all this up, and I’ll submit it later if you still want me to write it up. But can I share my screen.
87 00:10:45.270 ⇒ 00:10:46.040 Robert Tseng: Yeah.
88 00:10:49.170 ⇒ 00:10:53.460 Mitesh Patel: It will just help me kind of point out things as I’m asking about them.
89 00:10:53.980 ⇒ 00:10:54.860 Mitesh Patel: Okay?
90 00:10:56.810 ⇒ 00:11:07.869 Mitesh Patel: So first, st this product revenue snapshot demalade explained to me that these numbers include abandoned orders. All the other reports do not.
91 00:11:08.050 ⇒ 00:11:22.609 Mitesh Patel: which is fine, I think that’s correct, and that’s fine. I have a question about the pending orders from yesterday. So yesterday for Sema injectable, Sema, we had a hundred 95 new customers, but then we had 22
92 00:11:23.310 ⇒ 00:11:24.360 Mitesh Patel: pending.
93 00:11:25.120 ⇒ 00:11:32.819 Mitesh Patel: I guess that’s payment pending what happens to these. Let’s say, maybe 10 of those payment comes through
94 00:11:33.260 ⇒ 00:11:43.469 Mitesh Patel: in today, right since this is yesterday’s numbers. If 10 of these comes through today. Will those 10 be here in
95 00:11:44.150 ⇒ 00:11:52.499 Mitesh Patel: today’s report which will be published tomorrow morning? I I like, how do I? How do I account for these 22 pending, going forward.
96 00:11:59.438 ⇒ 00:12:06.909 Demilade Agboola: So right now they’re not included in the new, because technically, the new are, they’re already included.
97 00:12:07.280 ⇒ 00:12:13.639 Demilade Agboola: if, like in the new customers yesterday. The 20 are already included in that number of 1 95.
98 00:12:13.830 ⇒ 00:12:14.900 Demilade Agboola: So that’s helpful.
99 00:12:14.900 ⇒ 00:12:20.180 Mitesh Patel: Already included. Sorry, so sorry. The 22 are already included in the 1 95.
100 00:12:21.790 ⇒ 00:12:24.479 Demilade Agboola: Oh, is this for Josh report, or is this.
101 00:12:24.480 ⇒ 00:12:26.340 Mitesh Patel: This is the Josh report. Yes, it’s the Josh.
102 00:12:27.390 ⇒ 00:12:31.320 Demilade Agboola: Yes, so yes, they’re included in the 1 95
103 00:12:31.490 ⇒ 00:12:33.630 Demilade Agboola: in the other reports they are not.
104 00:12:35.410 ⇒ 00:12:44.720 Mitesh Patel: Understood. Okay. So in all other reports the 22 are not included. So whatever the 1, 73 would be included in the other reports.
105 00:12:45.270 ⇒ 00:12:45.980 Demilade Agboola: Yes.
106 00:12:46.400 ⇒ 00:12:54.710 Mitesh Patel: Okay, good. Thanks for that. That’s just something I needed to understand. Yeah. And.
107 00:12:54.710 ⇒ 00:13:12.399 Robert Tseng: He wanted to see the pending, because it’s like we expect most of those to turn into real customers. But and so it’s more of like a leading indicator of like what we think. The total new is like they. It’s not. It’s not guaranteed, but like I guess Josh just wanted to see all the possible customers.
108 00:13:12.400 ⇒ 00:13:32.489 Mitesh Patel: It does. And and and this is more to, for you know that how our daily sort of acquisition campaigns are working. So that makes sense 1 95. Some of those will fall off, but as long as the 22 in the are in the 1 95, it kind of tells us that. Hey, here’s what, how the acquisition campaigns are working.
109 00:13:33.340 ⇒ 00:13:33.940 Robert Tseng: Yep.
110 00:13:34.410 ⇒ 00:13:40.459 Mitesh Patel: Okay, cool. I I did not. That was not clear to me before now.
111 00:13:41.509 ⇒ 00:13:47.499 Mitesh Patel: This view that this dashboard that Annie had created for me.
112 00:13:47.760 ⇒ 00:13:50.100 Mitesh Patel: So a data question
113 00:13:51.010 ⇒ 00:14:01.210 Mitesh Patel: for the glp ones. I remember the number specifically because I had to record a ice bucket challenge because I lost some bet. But when I ran this report
114 00:14:01.580 ⇒ 00:14:05.510 Mitesh Patel: I would say, maybe the 23rd or the 24, th
115 00:14:05.920 ⇒ 00:14:09.129 Mitesh Patel: this number said, 8, 73.
116 00:14:10.510 ⇒ 00:14:11.270 Mitesh Patel: Okay.
117 00:14:11.740 ⇒ 00:14:22.199 Mitesh Patel: when I obviously I’m running it today. I ran it yesterday, you know, it was like some few days ago it was. I think it was 8, 39, or it could have been like. So why would it change?
118 00:14:22.580 ⇒ 00:14:27.520 Mitesh Patel: What? What are the reasons that it changes from 8, 73 to 8, 36.
119 00:14:31.650 ⇒ 00:14:37.499 Mitesh Patel: Because this is supposed to be confirmed orders. There’s no, you know, potential or any pending orders in this.
120 00:14:40.230 ⇒ 00:14:48.279 Demilade Agboola: I will have to look into that. It sounds East. I would I could understand it going up. I don’t understand it coming down, so I would have to look into that.
121 00:14:48.620 ⇒ 00:14:49.520 Mitesh Patel: Okay.
122 00:14:49.520 ⇒ 00:14:54.639 Demilade Agboola: So it could go up cause like again over time, pending orders can, you know.
123 00:14:54.880 ⇒ 00:14:57.720 Demilade Agboola: get confirmed? And that would increase the number.
124 00:14:58.210 ⇒ 00:15:01.170 Demilade Agboola: But it’s coming down is is a strange one. To be honest.
125 00:15:01.170 ⇒ 00:15:02.919 Mitesh Patel: Yeah, by quite a bit. Right?
126 00:15:04.000 ⇒ 00:15:08.510 Mitesh Patel: 8, 73 to 8, 36 is. It’s a pretty big difference.
127 00:15:11.849 ⇒ 00:15:12.659 Demilade Agboola: Yes.
128 00:15:14.280 ⇒ 00:15:19.810 Demilade Agboola: again, to be honest, I have to look into that could be a filter. Could I have no idea why that happened.
129 00:15:20.990 ⇒ 00:15:43.670 Mitesh Patel: Alright excellent! That’s cool. Now, I have a new request. And it’s basically the same report which I asked for, you know, weekly. This is fantastic. I use this every day and and and for my weekly reporting. So I don’t want this to change. I need this. But is there a way I can get a version of this
130 00:15:43.940 ⇒ 00:15:58.900 Mitesh Patel: which gives me the numbers like, let’s say, you know, by by month, or you know, if I want to just look at yesterday’s data. So I I need a that date filter that we have on other reports here.
131 00:16:00.710 ⇒ 00:16:09.689 Mitesh Patel: So like, even if I say, hey, I just wanna see these for June. It again limits it by week, which is fine, because that’s what this report is supposed to be.
132 00:16:10.430 ⇒ 00:16:11.120 Robert Tseng: Yeah.
133 00:16:11.850 ⇒ 00:16:20.210 Robert Tseng: yeah, we yeah, we only aggregated by week in this model. So we would. I mean, we have it in day. We have it in days. So I just
134 00:16:26.710 ⇒ 00:16:32.592 Mitesh Patel: So basically. I want to see same, you know, breakdown by the same 3 groupings. Right?
135 00:16:32.960 ⇒ 00:16:33.759 Robert Tseng: Yeah, but you wanted to.
136 00:16:33.760 ⇒ 00:16:34.150 Mitesh Patel: Habits.
137 00:16:34.150 ⇒ 00:16:35.760 Robert Tseng: Do it by day, week or month.
138 00:16:35.760 ⇒ 00:16:38.509 Mitesh Patel: By day, by month by, you know. Sort of sort.
139 00:16:38.510 ⇒ 00:16:40.069 Robert Tseng: By whatever? Yeah, okay.
140 00:16:40.070 ⇒ 00:16:44.849 Mitesh Patel: Yeah, basically, this filter.
141 00:16:45.350 ⇒ 00:16:46.010 Robert Tseng: Okay.
142 00:16:50.250 ⇒ 00:16:59.179 Robert Tseng: yeah, I mean, Demo, it just sounds like we, we probably will need to just switch that model to a daily model. And then Annie can aggregate it within tableau right.
143 00:17:00.520 ⇒ 00:17:04.807 Mitesh Patel: Yeah, I still want this. By the way, I do want to maintain this weekly view. Okay.
144 00:17:05.540 ⇒ 00:17:10.490 Robert Tseng: Yeah. So maybe we’ll just create a separate one. I don’t know. We’ll just rename this. Call it weekly growth Kpis. And then
145 00:17:10.690 ⇒ 00:17:18.620 Robert Tseng: we will just like, basically do a spin off. That’s more exploratory and has more flexible date and date date. Filters.
146 00:17:19.099 ⇒ 00:17:19.669 Mitesh Patel: Yep.
147 00:17:20.069 ⇒ 00:17:20.849 Mitesh Patel: Cool.
148 00:17:21.199 ⇒ 00:17:22.419 Robert Tseng: Okay, that was it.
149 00:17:23.430 ⇒ 00:17:24.990 Robert Tseng: Okay, cool.
150 00:17:26.040 ⇒ 00:17:31.510 Robert Tseng: yeah. I also. I mean, I don’t know if you saw I sent you a message. Yeah, I was hoping that you know we’re
151 00:17:32.710 ⇒ 00:17:40.269 Robert Tseng: there’s a few other things I mean, just kind of going back to the doc that you had sent me like a couple of week couple of months ago.
152 00:17:40.960 ⇒ 00:17:48.510 Robert Tseng: yeah, I wanted to get a refresh on, like, you know, new priorities. Just kind of longer term roadmap stuff on like what you would want from us.
153 00:17:49.660 ⇒ 00:17:51.550 Robert Tseng: I know there’s some things are changing.
154 00:17:51.780 ⇒ 00:17:52.809 Mitesh Patel: Yeah, no, I missed
155 00:17:52.810 ⇒ 00:18:02.339 Mitesh Patel: message. I will look it up. I definitely have some, you know. More more needs. Longer term needs going forward. So I will reply to your message here.
156 00:18:02.840 ⇒ 00:18:11.280 Robert Tseng: Okay? Great. Yeah. No, no. Rush on that, I think. Yeah, whether we be, you know, this week or early next week. That’s that’s fine. Just wanted to put that on your radar.
157 00:18:11.750 ⇒ 00:18:13.830 Mitesh Patel: Alright! Great! Thank you so much. Thanks, all.
158 00:18:14.260 ⇒ 00:18:15.669 Robert Tseng: Cool, alright. Thanks, Natasha.
159 00:18:15.670 ⇒ 00:18:16.749 Mitesh Patel: Bye, alright, bye.
160 00:18:16.750 ⇒ 00:18:17.330 Robert Tseng: Bye.
161 00:18:18.040 ⇒ 00:18:18.780 Josh : Yo.
162 00:18:20.020 ⇒ 00:18:20.650 Robert Tseng: Hey!
163 00:18:24.100 ⇒ 00:18:25.370 Josh : What’s going on.
164 00:18:26.340 ⇒ 00:18:31.829 Robert Tseng: We? I mean, we’re just going through. Stand up, Natasha. Kind of popped in for a sec. So we just kind of
165 00:18:32.230 ⇒ 00:18:35.290 Robert Tseng: showed him some things, and then he made another request.
166 00:18:36.810 ⇒ 00:18:38.049 Robert Tseng: I’m gonna.
167 00:18:38.590 ⇒ 00:18:39.660 Josh : Kind of biggest.
168 00:18:39.660 ⇒ 00:18:40.060 Robert Tseng: I’m back.
169 00:18:40.449 ⇒ 00:18:44.340 Josh : Thing I still deeply care about is just figuring out
170 00:18:45.130 ⇒ 00:18:51.990 Josh : how we’re going to really incorporate some better understanding of the data at the Ehc. And then.
171 00:18:52.200 ⇒ 00:18:58.609 Robert Tseng: Yeah, I spoke with Danny yesterday. And basically what I told him was like.
172 00:18:59.200 ⇒ 00:19:12.229 Robert Tseng: well, I think, which I mean, he agrees. And we can. We can talk about it later. But I I think we should plug in corral and just have corral. It seems like the it gave him what he needed.
173 00:19:12.560 ⇒ 00:19:15.990 Robert Tseng: like we could replicate it, and probably take us like
174 00:19:16.080 ⇒ 00:19:19.443 Robert Tseng: one or 2 sprints to actually build it out. And
175 00:19:19.870 ⇒ 00:19:46.810 Robert Tseng: he’s kind of in a place where he doesn’t exactly know what he wants to see. So just being able to chat and like, do the self serve with the AI feature there like he’s he! He thought. That was helpful for him. So we’re thinking he could turn it on. Have it there for like 3 to 6 months, or however long it takes for him to have very clear requirements, and then we can just rebuild it and we can just then we can move that into tableau.
176 00:19:47.080 ⇒ 00:19:52.920 Robert Tseng: but with kind of where the maturity is there, I just don’t really think he has
177 00:19:53.050 ⇒ 00:20:04.690 Robert Tseng: like it. It feels like it will just be constantly changing. And it’s not that I think the tableau reports our workflow is not really set up to be that it’s not. It’s honestly not that flexible like
178 00:20:04.840 ⇒ 00:20:12.219 Robert Tseng: core Bi doesn’t change that much. Typically so I think it might be better to give him something that’s more flexible.
179 00:20:12.963 ⇒ 00:20:14.679 Robert Tseng: For him to just like.
180 00:20:15.230 ⇒ 00:20:20.400 Robert Tseng: figure out what he wants to see. And then, once it’s pretty settled that we can recreate that.
181 00:20:25.380 ⇒ 00:20:28.230 Josh : Got it. Okay, yeah, that makes sense. That makes sense.
182 00:20:29.070 ⇒ 00:20:40.481 Robert Tseng: Yeah, like, I, I, we already kind of copied all the data models. Or like, I, kinda I kind of figured out, I mean, I. Yeah. So from cause they did all this modeling, which is what takes a long time.
183 00:20:40.850 ⇒ 00:21:01.179 Robert Tseng: And so when once we are ready to replicate it, I’m confident we can like we’ve looked through the schema before. So but it’s just like, what are we gonna build towards end to end like on the reporting side. It’s not clear, so I think it might be better to just like, give him something that’s easier to kind of build what he wants.
184 00:21:03.040 ⇒ 00:21:05.689 Josh : Yep, I think it makes sense. I mean, there’s probably like a
185 00:21:06.350 ⇒ 00:21:11.169 Josh : cost difference a little bit like what is the rate.
186 00:21:13.120 ⇒ 00:21:16.310 Robert Tseng: It’s like 2,000 to 2,500 a month. Something like that.
187 00:21:16.570 ⇒ 00:21:22.627 Josh : Okay, that’s for give them 3 months. 6 grand. Yeah, it’s worth it.
188 00:21:23.180 ⇒ 00:21:24.159 Josh : Hopefully, it can figure.
189 00:21:24.160 ⇒ 00:21:29.469 Robert Tseng: If he can like settle it down in 6 and 3 months. Then, yeah, I think we can just
190 00:21:29.610 ⇒ 00:21:32.439 Robert Tseng: where we can shut it down, and we’ll just recreate it in house.
191 00:21:33.460 ⇒ 00:21:37.772 Josh : Yeah, let’s make sure that we earmark that shutdown date before we launch it.
192 00:21:39.520 ⇒ 00:21:46.760 Robert Tseng: Okay, yeah. So I I kicked off that conversation and and having corral, just kind of come back with, like, how fast they can turn it back on so.
193 00:21:47.730 ⇒ 00:21:51.630 Josh : Cool, cool, cool.
194 00:21:52.780 ⇒ 00:21:58.180 Josh : Okay, that’s what I really needed to know. And then, in terms of
195 00:21:58.480 ⇒ 00:22:02.489 Josh : what we’re trying to get from
196 00:22:03.000 ⇒ 00:22:06.329 Josh : this sprint. Did we get the sprint planned out.
197 00:22:07.880 ⇒ 00:22:11.176 Robert Tseng: Yeah. So I mean, there’s slight things that are in flight, I think.
198 00:22:12.700 ⇒ 00:22:22.419 Robert Tseng: and this stuff will be blocked on bask, like there’s I mean with the treatment Id that they finally added, like late last week, I think that’s
199 00:22:22.962 ⇒ 00:22:26.909 Robert Tseng: that’s unblocked us on a couple of things that Damon Lotti is working through.
200 00:22:29.480 ⇒ 00:22:51.229 Robert Tseng: yeah. So that that was big. But then I think to get ahead of like the accounting stuff like Jonah and Zoab want to like, recognize revenue differently. And so there’s like this whole amortization strategy thing still requires us to get data from stripe through best which they have not agreed to. I think this is kind of
201 00:22:51.410 ⇒ 00:23:00.120 Robert Tseng: they’ve seen my message, and I mean it’s just. It’s just there. So I don’t think Zach has responded to it. But so yeah, we’re we’re blocked there
202 00:23:00.620 ⇒ 00:23:10.880 Robert Tseng: and then other than that, there’s some intake stuff that we were dealing with. And then, yeah, really, just on the marketing side, we’ve replicated the
203 00:23:12.290 ⇒ 00:23:23.069 Robert Tseng: like the offline spend sheet that the marketing team wanted to do. So we’re giving that back to them today like this is now maintained by us. So I think we’re we’re we’re clear on that.
204 00:23:25.810 ⇒ 00:23:26.630 Josh : Got it.
205 00:23:31.920 ⇒ 00:23:38.700 Robert Tseng: Cool. Yeah. And then there’s a then for me. It’s just the the Cdp stuff. Think where
206 00:23:39.140 ⇒ 00:23:51.419 Robert Tseng: we’re just in the middle middle of trial right now, like I like, I like I’ve mentioned. I need like one or 2 weeks to basically make segment and rubber stack. Go head to head, and then we’ll make a decision on that by next week.
207 00:23:53.940 ⇒ 00:23:54.520 Josh : Cool.
208 00:23:57.900 ⇒ 00:23:58.440 Robert Tseng: Yeah.
209 00:23:59.320 ⇒ 00:24:09.888 Robert Tseng: okay, well, anyway. So for the other guys that are on the call, yeah, anything else we need to talk about on these tickets. I know we’re blocked here. Order to the delivery time.
210 00:24:10.390 ⇒ 00:24:12.130 Robert Tseng: have you got a chance to look at this?
211 00:24:13.610 ⇒ 00:24:15.360 Robert Tseng: Didn’t want it. Yeah.
212 00:24:16.278 ⇒ 00:24:23.979 Demilade Agboola: Yeah, I’ve looked at it, and I still haven’t seen where, like the delivery, I can see the shipment when the orders have been shipped
213 00:24:24.100 ⇒ 00:24:31.080 Demilade Agboola: and got sent to the pharmacy, but I can’t see when they’re delivered, Sue the customer.
214 00:24:31.350 ⇒ 00:24:33.840 Demilade Agboola: so I don’t know how they have the delivery time.
215 00:24:35.140 ⇒ 00:24:43.529 Robert Tseng: Okay. Well, I’m gonna talk to Sarah in like 10 min. So I’m sure she’s gonna ask me the same thing. So she’s gonna want to know, like how we’re calculating.
216 00:24:44.420 ⇒ 00:24:48.290 Robert Tseng: I mean, the problem is right. That farm is the farm Ops team
217 00:24:48.570 ⇒ 00:24:55.880 Robert Tseng: sees 2 different numbers on turnaround time. What we’re saying through tableau with ship, oh, is not what basket saying? And so.
218 00:24:56.100 ⇒ 00:25:08.170 Robert Tseng: yeah. Then, if you run into a dead end, and we need to ask Zach. Then just ask Zach, like I think I I mentioned that yesterday, so I don’t think we should be dragging out this kind of investigation any longer. Like, I, I think it’s
219 00:25:08.420 ⇒ 00:25:14.730 Robert Tseng: like we we need. We need to. We need to get an answer of that because she’s basically misreporting this every week.
220 00:25:15.940 ⇒ 00:25:18.060 Demilade Agboola: Okay. Sounds good.
221 00:25:19.110 ⇒ 00:25:21.770 Robert Tseng: Okay. So you’re gonna write that message to Bass. Then.
222 00:25:22.880 ⇒ 00:25:23.550 Demilade Agboola: Yeah.
223 00:25:24.090 ⇒ 00:25:24.700 Robert Tseng: Okay.
224 00:25:25.130 ⇒ 00:25:25.510 Demilade Agboola: During, that.
225 00:25:26.700 ⇒ 00:25:37.040 Robert Tseng: yeah, we’ll just we’ll just let him know. This is how we’re calculating it. What we know like, you know, how is yours different. Like, I think just something simple like that, I think you know. Hopefully, he’ll give us. He’ll give us some pointers there.
226 00:25:40.150 ⇒ 00:25:45.359 Robert Tseng: Okay? And then the last thing on. Well, that’s not the last. But I also wanna check on this.
227 00:25:45.520 ⇒ 00:25:52.729 Robert Tseng: So Cogs related things we talked about. I think the way she merged like the
228 00:25:52.850 ⇒ 00:26:04.279 Robert Tseng: the Pr. For handling the duplicates yesterday. Yeah, anything else that I think that’s connected to this. But I’m not entirely sure. Well, kind of
229 00:26:04.640 ⇒ 00:26:05.170 Robert Tseng: let’s
230 00:26:05.700 ⇒ 00:26:12.559 Awaish Kumar: Like that. That’s that was more like handling the duplicates on a granular in the
231 00:26:14.710 ⇒ 00:26:16.400 Awaish Kumar: in the downstream models.
232 00:26:16.600 ⇒ 00:26:23.989 Awaish Kumar: But I think this is more about deciding on in the product mapping sheet, like, I don’t know
233 00:26:25.170 ⇒ 00:26:31.010 Awaish Kumar: like a no, this is different one, right? This.
234 00:26:31.400 ⇒ 00:26:36.359 Awaish Kumar: this is a demo we’re working on this to get more granular fields. I don’t know.
235 00:26:36.910 ⇒ 00:26:38.240 Awaish Kumar: This is not okay.
236 00:26:39.180 ⇒ 00:26:47.029 Robert Tseng: Got it. So not about duplicate. It’s not. This is not the duplicated cogs ticket. This is the. This is just like getting more granular cogs.
237 00:26:47.330 ⇒ 00:26:49.620 Robert Tseng: Okay, yeah, where are we with this.
238 00:26:53.651 ⇒ 00:26:55.659 Demilade Agboola: So for more granular cogs.
239 00:26:56.280 ⇒ 00:27:01.130 Demilade Agboola: this is the modeling to allow for, like the switch in. When
240 00:27:02.540 ⇒ 00:27:12.150 Demilade Agboola: is this switch? Because I there are 2 things going on with cogs right now. One is we’re trying to figure out like the calculations for cogs. And 2 is we’re trying to figure out like when
241 00:27:12.710 ⇒ 00:27:15.049 Demilade Agboola: the active periods for different cogs
242 00:27:19.560 ⇒ 00:27:26.889 Demilade Agboola: like, however, better my goal. This cogs was active from the 1st of June till date, but before that it was a different body.
243 00:27:27.690 ⇒ 00:27:31.210 Robert Tseng: Yeah, no, I think that’s separate, although
244 00:27:31.760 ⇒ 00:27:43.799 Robert Tseng: I don’t know. Yeah, I don’t. I don’t remember the ticket for that one. But that’s important, because like, that’s cogs get updated. And we need to have like change logs. For when cogs are are changing so that we can, you know.
245 00:27:44.570 ⇒ 00:27:47.199 Robert Tseng: yeah, we we? So that we can figure out like
246 00:27:49.500 ⇒ 00:28:04.119 Robert Tseng: when products were purchased between, you know, last month the cogs were different than what they were this month, like we. We need to be able to to to say that right now. It’s just static, like, if we change it, it gets changed across the board.
247 00:28:08.570 ⇒ 00:28:11.890 Demilade Agboola: Yeah, so for this, this is 3 91.
248 00:28:11.890 ⇒ 00:28:16.020 Robert Tseng: Okay. So I mean, I I don’t. I wanna don’t want us to get confused there. So
249 00:28:16.170 ⇒ 00:28:18.309 Robert Tseng: there’s so many cogs things in here.
250 00:28:18.732 ⇒ 00:28:27.187 Robert Tseng: Okay, whatever. I don’t know which one it is. If there is an active ticket, you let me know. But I think this is like hogs change logs.
251 00:28:28.460 ⇒ 00:28:44.350 Robert Tseng: update model web browser, yeah, figure out how to like, need we log when logs values are changing so
252 00:28:44.690 ⇒ 00:28:46.509 Robert Tseng: we can retro.
253 00:28:47.010 ⇒ 00:28:48.420 Robert Tseng: Why? Pumped?
254 00:28:51.930 ⇒ 00:29:04.009 Robert Tseng: yeah, I I do think that’s that’s a very important thing to do, because that directly impacts like the way we report on margin. You know, if if Rebecca is randomly changing like
255 00:29:05.030 ⇒ 00:29:07.860 Robert Tseng: it’s not random. But if once, if she’s changing
256 00:29:08.130 ⇒ 00:29:18.610 Robert Tseng: cogs for certain products, and we don’t know when that’s happening. And we’re just it’s just like updating cogs. And we’re we’re misreporting margin for like
257 00:29:19.280 ⇒ 00:29:23.370 Robert Tseng: that product before it was changed. You understand? So like.
258 00:29:23.560 ⇒ 00:29:27.850 Robert Tseng: yeah, I think this. That’s that’s an important thing to figure out. I don’t remember.
259 00:29:30.600 ⇒ 00:29:32.899 Demilade Agboola: Yeah, that. Yeah, it’s definitely important to figure out.
260 00:29:34.830 ⇒ 00:29:45.320 Robert Tseng: Okay? So yeah, if you have any questions on that, like, I don’t know, like there must be some. There must be some threads with Rebecca here, like, I think she was asking about it. So cogs changes like, I don’t know.
261 00:29:47.550 ⇒ 00:29:53.823 Robert Tseng: Boom, boom right here. Okay, so
262 00:29:59.040 ⇒ 00:30:05.399 Robert Tseng: okay, so I’m gonna just take this and throw it into the ticket.
263 00:30:13.540 ⇒ 00:30:21.860 Robert Tseng: Okay, other things that are in progress. Yeah, this was like a
264 00:30:22.290 ⇒ 00:30:26.760 Robert Tseng: requests, Dim Lotte, were you able to handle this.
265 00:30:28.240 ⇒ 00:30:29.639 Demilade Agboola: Yes, this is done.
266 00:30:30.290 ⇒ 00:30:42.172 Robert Tseng: Okay, great and then list of new customers up a new treatment updated weekly.
267 00:30:44.190 ⇒ 00:30:47.599 Robert Tseng: yeah, I guess this was added, probably
268 00:30:48.100 ⇒ 00:30:50.305 Robert Tseng: that was allowed a while ago, but
269 00:30:56.390 ⇒ 00:30:56.950 Demilade Agboola: Good.
270 00:31:00.250 ⇒ 00:31:03.009 Robert Tseng: Yeah? Or what do we do? We think we can get this one done.
271 00:31:04.720 ⇒ 00:31:05.780 Demilade Agboola: Yes.
272 00:31:08.700 ⇒ 00:31:11.040 Demilade Agboola: Okay.
273 00:31:16.530 ⇒ 00:31:17.200 Robert Tseng: All right.
274 00:31:18.820 ⇒ 00:31:29.959 Robert Tseng: Okay, so yeah, once again, if you guys could update your in progress tickets and just move move things up anything that’s like recurring that you’re not actually doing or like this one shouldn’t be here.
275 00:31:30.270 ⇒ 00:31:35.000 Robert Tseng: so it hasn’t been touched in a while like it should it should be moved to, done or like.
276 00:31:35.560 ⇒ 00:31:38.819 Robert Tseng: I mean, you’re you’re gonna get a new ticket for this every 2 weeks.
277 00:31:39.070 ⇒ 00:31:39.690 Robert Tseng: Oh.
278 00:31:39.690 ⇒ 00:31:40.330 Demilade Agboola: Oh, okay.
279 00:31:40.330 ⇒ 00:31:42.659 Robert Tseng: Please please update that. And then.
280 00:31:43.010 ⇒ 00:31:47.873 Robert Tseng: obviously, Annie, stuff is not gonna move my stuff like I will, I will move it. But
281 00:31:48.650 ⇒ 00:31:53.480 Robert Tseng: yeah. Wish there’s a couple of things we didn’t talk about. One is kind of the.
282 00:31:55.080 ⇒ 00:32:03.239 Robert Tseng: you know. I guess you kind of handled the automation there. So you’re gonna kind of share the offline, spend sheet with with the team, and then also on the Emr.
283 00:32:03.240 ⇒ 00:32:03.830 Awaish Kumar: Side.
284 00:32:04.690 ⇒ 00:32:05.280 Robert Tseng: Yeah.
285 00:32:05.280 ⇒ 00:32:07.989 Awaish Kumar: I also have to update the downstream models
286 00:32:10.080 ⇒ 00:32:15.719 Awaish Kumar: like, after updating the sheet. It will like, I need to update the oh man
287 00:32:16.560 ⇒ 00:32:18.840 Awaish Kumar: like, because we now we have a new sheet.
288 00:32:19.060 ⇒ 00:32:24.919 Awaish Kumar: So data going to come from this sheet into the big query. So I have to upgrade that. And
289 00:32:26.080 ⇒ 00:32:26.630 Awaish Kumar: okay.
290 00:32:27.463 ⇒ 00:32:32.560 Robert Tseng: On the Emr side. Did you make any progress there like? Can we send something to them soon?
291 00:32:32.600 ⇒ 00:32:37.360 Awaish Kumar: No, yeah. Like, I plan to do that like
292 00:32:39.140 ⇒ 00:32:46.529 Awaish Kumar: in this play, I want to finish documentation this week. So what I haven’t done anything yet on this.
293 00:32:47.320 ⇒ 00:32:51.951 Robert Tseng: Okay, cool. Yeah, let’s let’s just try. Let’s try to get them something by tomorrow.
294 00:32:52.640 ⇒ 00:33:02.240 Robert Tseng: I don’t think we’re gonna end up meeting this week. Then if we don’t send it to them by tomorrow. But yeah, like, I, I think that’s that’s we should be be on top of that.
295 00:33:04.680 ⇒ 00:33:11.110 Robert Tseng: Okay, cool. I’m gonna go hop into a call with Sarah now. But I think that covers everything for now.
296 00:33:12.900 ⇒ 00:33:15.699 Robert Tseng: Yeah, as you heard from Josh. Like I’m
297 00:33:16.260 ⇒ 00:33:28.120 Robert Tseng: you’re not hearing from me much, because I’ve been trying to triage some other things, the Ehc data, basically, and rerouting that to turn on corral again. So we don’t have to go build out that pipeline
298 00:33:28.973 ⇒ 00:33:30.320 Robert Tseng: and then
299 00:33:30.560 ⇒ 00:33:45.569 Robert Tseng: yeah, on the segment rudder stack stuff I’m still, you know, doing the evaluation now. So that’s really more just working with those vendors specifically. So, there hasn’t really been anything that I needed to ask this team to do yet.
300 00:33:46.200 ⇒ 00:33:49.770 Robert Tseng: But probably at some point. Once we
301 00:33:50.440 ⇒ 00:34:01.559 Robert Tseng: yeah, there probably will be have to be a like a data model that will spin up in our warehouse. But it’s it’s just not happening now yet. Maybe in the next day I’ll probably have more requirements around that.
302 00:34:02.950 ⇒ 00:34:03.750 Robert Tseng: So
303 00:34:04.030 ⇒ 00:34:09.529 Robert Tseng: okay, cool. That’s it on my side. Let me know if you have any questions, and we’ll we’ll talk soon.
304 00:34:13.650 ⇒ 00:34:15.250 Demilade Agboola: Okay. Talk soon. Bye.