Meeting Title: [Eden] Daily Standup Date: 2025-05-05 Meeting participants: Annie Yu, Demilade Agboola, Robert Tseng, Rob, Awaish Kumar
WEBVTT
1 00:03:44.920 ⇒ 00:03:45.980 rob: Hey, guys.
2 00:03:49.050 ⇒ 00:03:49.719 Robert Tseng: Hey! Rob!
3 00:03:49.720 ⇒ 00:03:50.430 Demilade Agboola: Hi, rob.
4 00:03:55.510 ⇒ 00:03:57.530 Robert Tseng: 1st time I’ve seen you with your hat off.
5 00:03:59.130 ⇒ 00:04:07.289 rob: Oh, yeah, I do usually wear a hat I went to. Usually I go to the gym later, so I shower after the gym, so I don’t wanna like.
6 00:04:07.940 ⇒ 00:04:12.969 rob: But I I showered this morning because I took my kids to do a cold plunge really early.
7 00:04:15.070 ⇒ 00:04:16.539 Robert Tseng: How do? How do they like it?
8 00:04:17.390 ⇒ 00:04:21.990 rob: They love them, man. I I couldn’t believe they wanted to go. It was like 5 Am. When we went.
9 00:04:23.570 ⇒ 00:04:32.229 Robert Tseng: We’re talking about like a real, like a real lake, or like I don’t know in New York or just people, and they have a tub in their on their back.
10 00:04:32.230 ⇒ 00:04:41.540 rob: This is a place like this is a. It’s a like a Nordic cycle. So you do a sauna, and then a cold plunge. Sauna cold plunge so. Oh, wow!
11 00:04:41.540 ⇒ 00:04:42.160 Robert Tseng: Wow!
12 00:04:42.160 ⇒ 00:04:45.089 rob: Contrast therapy place. It’s actually pretty fun, but.
13 00:04:45.270 ⇒ 00:04:45.880 Robert Tseng: Huh!
14 00:04:46.490 ⇒ 00:04:49.730 Robert Tseng: Not something I would imagine kids enjoy. But yeah.
15 00:04:49.730 ⇒ 00:04:52.079 rob: I know they they love it, though man.
16 00:04:52.370 ⇒ 00:04:53.699 Robert Tseng: Great. Yeah.
17 00:04:53.700 ⇒ 00:05:04.649 rob: I just saw your message about the steps, the only one I’m not. I’ll all right, but the only one I’m not sure. On timing is prescription and treatment, like which of those comes first.st
18 00:05:04.650 ⇒ 00:05:09.459 Robert Tseng: Okay, yeah, I think that’s the one that I was hung up onto. So just wanted to get your second opinion on that.
19 00:05:10.080 ⇒ 00:05:19.609 rob: I think that the treatment comes first, st but I’m not positive, and so I think they. They determine the treatment, and then they send the prescription over to the
20 00:05:19.940 ⇒ 00:05:21.620 rob: pharmacy, but.
21 00:05:21.620 ⇒ 00:05:22.270 Robert Tseng: Okay.
22 00:05:22.390 ⇒ 00:05:24.340 rob: I can check that, to be sure.
23 00:05:24.710 ⇒ 00:05:26.820 Robert Tseng: Yeah, would appreciate that.
24 00:05:29.146 ⇒ 00:05:30.480 Robert Tseng: Hey, everyone.
25 00:05:31.390 ⇒ 00:05:39.274 Robert Tseng: I guess, Rob, I know that you responded to my question on Friday. I didn’t actually get a chance to look into it yet. So
26 00:05:40.210 ⇒ 00:05:44.759 Robert Tseng: kind of yeah, it was basically like, okay, well, we need to get the mer reporting done
27 00:05:44.920 ⇒ 00:05:51.249 Robert Tseng: early this week. So let’s just trying to make. I I think you mentioned everything’s in there except for Vibe. The Api was kind of like delayed.
28 00:05:51.584 ⇒ 00:06:02.609 rob: So it turns out like their Api was down when I wrote that. So I thought, that’s why we didn’t have the data. But actually, when we dumped drip, we shut off Vibe.
29 00:06:02.780 ⇒ 00:06:11.079 rob: and I guess it has to do with I I don’t know that it was just drip, but I think it had to do with the Sema to glp one.
30 00:06:11.200 ⇒ 00:06:17.269 rob: So basically, we don’t have any vibe spend for the last week. That’s why I thought it was broken, but we had paused them all.
31 00:06:17.440 ⇒ 00:06:18.969 rob: So that is accurate.
32 00:06:19.860 ⇒ 00:06:21.020 Robert Tseng: Okay, good to know.
33 00:06:23.480 ⇒ 00:06:30.049 Robert Tseng: yeah. And that’s the main thing. I’m gonna just kind of go through everything with the team here. So feel free to jump off if you want. If you want to see.
34 00:06:30.327 ⇒ 00:06:39.760 rob: I will jump off but I I’ll I’m going to get that today into bigquery. I was going to do it Friday, but I had another contract I had to work on so.
35 00:06:40.040 ⇒ 00:06:41.730 Robert Tseng: Okay. No. Worries. Yeah.
36 00:06:41.990 ⇒ 00:06:43.910 rob: Alright, thanks, guys. See ya!
37 00:06:43.910 ⇒ 00:06:45.100 Robert Tseng: Yep. See you, rob
38 00:06:48.200 ⇒ 00:06:55.664 Robert Tseng: alright happy Monday to everyone else. Or I guess if you’re away I don’t know if it’s Monday anymore. But
39 00:06:58.240 ⇒ 00:07:01.050 Robert Tseng: Monday night. Okay, nice.
40 00:07:03.080 ⇒ 00:07:16.649 Robert Tseng: yeah. I know I didn’t update these tickets. We gotta kind of just groom through these pretty quick. But I think, like usual for Mondays and Fridays like to start more high level. So I just want to kind of talk about ongoing projects. Things are in cycle for this next sprint.
41 00:07:18.340 ⇒ 00:07:28.010 Robert Tseng: yeah. So we’ll kind of just start there and then, you know. So 1st thing is the form Ops like order, customer, journey, dashboard thing like that should be done like
42 00:07:28.160 ⇒ 00:07:35.989 Robert Tseng: well, I I know that we were waiting on a couple of things to to change, but I want I would like to just move this off today.
43 00:07:36.510 ⇒ 00:07:47.020 Robert Tseng: And then, as far as like Cmo dashboard. Yeah, I think annual. Probably this will come to you the marketing dashboard. The main adjustment we need to make
44 00:07:47.350 ⇒ 00:08:12.240 Robert Tseng: was really that mer report that we’ve been talking about for a while. Mer is marketing efficiency ratio, which is just like a ratio of revenue to like overall marketing spend. And so yeah, we were waiting on Rob to pass a Google sheet over to us before wish could do the marketing modeling. But it’s there. So we will be able to bring in paid channels
45 00:08:13.282 ⇒ 00:08:16.659 Robert Tseng: or sorry, unpaid, unpaid. Spend there.
46 00:08:17.252 ⇒ 00:08:20.349 Robert Tseng: I will also. Oh, yeah, go ahead.
47 00:08:21.470 ⇒ 00:08:36.859 Awaish Kumar: So we also have spend in the data warehouse as well. We just need to build a model, depend on how the dashboard is going to use it. Otherwise, offline and data from North Wind. Both are available in bigquery.
48 00:08:37.440 ⇒ 00:08:38.020 Robert Tseng: Okay?
49 00:08:39.100 ⇒ 00:08:48.000 Robert Tseng: Great, yeah. So that’s that’s what we’re gonna do. As far as like getting clarity on what, how it needs to be displayed. I have, like some of the ideas of the requirement. I mean
50 00:08:48.480 ⇒ 00:08:58.530 Robert Tseng: the requirements. I’m just gonna go back into our old channels with Mattesh and try to figure that out. So I that I can. That’s on me to go and just confirm with the team what we’re going to be building.
51 00:08:58.710 ⇒ 00:09:05.130 Robert Tseng: My understanding is just it’s just gonna be similar to what we’ve been doing on the paid
52 00:09:05.270 ⇒ 00:09:10.410 Robert Tseng: marketing side. Where we have like product level by channel
53 00:09:12.580 ⇒ 00:09:22.700 Robert Tseng: or we have product level spend. But yeah, we we want to enable channel level spend. But the focus is more on like an overall like
54 00:09:23.251 ⇒ 00:09:30.489 Robert Tseng: marketing budget efficiency ratio. So I think this will just be like an aggregation of all the different
55 00:09:32.240 ⇒ 00:09:33.980 Robert Tseng: channels with
56 00:09:34.300 ⇒ 00:09:44.950 Robert Tseng: with probably one degree of drill down so that you can actually look at it by channel in the same view. So I believe in that dashboard right now we have, like stacked bar chart, where every
57 00:09:46.490 ⇒ 00:09:49.789 Robert Tseng: saddle is kind of just like a section of that bar.
58 00:09:49.960 ⇒ 00:10:04.360 Robert Tseng: I’ll clarify that. So we don’t. We don’t need to like kind of. I I guess I don’t think it’s I. My point is, I don’t think it’s that hard. We’re just. There’s like a there’s a there’s a roll up to a full marketing budget, and we need to be able to break it up by channel. That’s it.
59 00:10:04.590 ⇒ 00:10:05.440 Awaish Kumar: So.
60 00:10:10.249 ⇒ 00:10:25.529 Robert Tseng: Yeah. So marketing data more is gonna leave that in there because this model enables the reporting here. Intake reporting. So things have priorities have changed here. So Embeddables is not moving forward. And so we’re kind of go gonna go back to
61 00:10:26.100 ⇒ 00:10:35.420 Robert Tseng: basically what we had before. Yeah. Sorry devil out a I mean, wasn’t my decision, but looks like they just decided not to keep going with that
62 00:10:37.960 ⇒ 00:10:38.479 Demilade Agboola: Is that under?
63 00:10:38.480 ⇒ 00:10:39.930 Demilade Agboola: But yeah, what’s up.
64 00:10:40.550 ⇒ 00:10:43.729 Demilade Agboola: Or like a technical theme.
65 00:10:44.260 ⇒ 00:10:54.529 Robert Tseng: I mean, I was also kind of confused, for, like, why do they keep using different form providers? It’s not like we were missing data like, I think I’ve been saying this to the team.
66 00:10:54.750 ⇒ 00:11:08.619 Robert Tseng: I think Ryan, who’s the champion there, I mean. He kind of came to a similar conclusion that Akash and I came to like weeks ago, which was like, you’re not actually missing data from these forms. I think people just didn’t know how to get get to it. So
67 00:11:09.126 ⇒ 00:11:21.570 Robert Tseng: you know, like, basically like, there’s no point in buying like paying for embeddables as a separate product. If you’re able to get all the questions and answers you want out of it. From from the from the forms, as is.
68 00:11:21.790 ⇒ 00:11:49.809 Robert Tseng: I. I guess there’s maybe a layer of customization and embeddables allows you to take the same form and put it into different platforms easily. So if they want to put forms in their email versus like their website or the landing pages like, there’s some modularity with that. I think that’s really the sacrifice that they that they make by not continuing to go with it, because they have to build a custom solution for everything now. But whatever I get this that was, that’s I think that’s why they made that decision.
69 00:11:53.440 ⇒ 00:11:54.130 Robert Tseng: It.
70 00:11:56.060 ⇒ 00:11:57.679 Demilade Agboola: That’s fair, but that makes sense.
71 00:11:58.090 ⇒ 00:11:58.740 Robert Tseng: Okay.
72 00:11:59.750 ⇒ 00:12:18.109 Robert Tseng: yeah. And then I think I, you know, I mentioned a couple of things that would under other impact our work. So yeah, I think a way should we discuss this? But I pretty much convinced Eden to just keep north beam. I was like switching to corral and having corral. Give us this data, all this stuff. It’s like it’ll get us pretty much the same thing.
73 00:12:18.220 ⇒ 00:12:29.290 Robert Tseng: Maybe it’s a bit more reliable than North theme, because at least we understand the connections. And where that data is how that data is coming in. But I just don’t really think it’s that.
74 00:12:29.400 ⇒ 00:12:47.440 Robert Tseng: like the cost savings are very negligible to them. So yeah, I think corral. I’m trying to convince them still to just use it for Zanodi. I really don’t want this team to take on Spa reporting because the Spa business is less than $100,000 a month, and it’s just like not worth it for us to spend our time there.
75 00:12:48.127 ⇒ 00:12:55.770 Robert Tseng: So I think that’s still like a Tbd, but yeah, as far as like 10 min.
76 00:12:55.770 ⇒ 00:12:57.210 Robert Tseng: and we’re oh, go ahead.
77 00:12:59.000 ⇒ 00:13:00.210 Awaish Kumar: I just said, Okay.
78 00:13:00.570 ⇒ 00:13:01.740 Robert Tseng: Okay, yeah.
79 00:13:01.930 ⇒ 00:13:08.053 Robert Tseng: sorry. I’ll I should. I should pause more. I feel like I say things. And then I just keep going.
80 00:13:08.630 ⇒ 00:13:18.110 Robert Tseng: yeah. And then regarding segment. So yeah, I spent a lot of time in segment today. And you know, I’ve been negotiating with the segment team and trying to understand where it sits in the tech stack.
81 00:13:18.620 ⇒ 00:13:35.140 Robert Tseng: You know. I I know I’m I’m the one making most of these decisions right now. I I also partly want to involve. I mean, I would say, like, Dave probably would like, want you to be more involved on the technical decisions here. Yeah, I know, like
82 00:13:35.580 ⇒ 00:13:36.780 Robert Tseng: oasis.
83 00:13:36.850 ⇒ 00:13:46.839 Robert Tseng: I I you know we we we were kind of having this conversation before. And like, Okay, well, what’s do we need to like Aes on this on this project, and I think
84 00:13:46.880 ⇒ 00:14:08.789 Robert Tseng: the answer is, yes, like it helps to have some redundancy. And there’s like there is some delineation. Maybe, Dave, a lot of owns everything products and Ops now and then away. She kind of owns marketing. But obviously a wish. You’re kind of like. I mean, just based on what you guys have expressed interest in. And Dave, a lot of wanting to be kind of more involved in some of these architecture decisions.
85 00:14:08.790 ⇒ 00:14:19.610 Robert Tseng: I’d love to kind of just loop you into more of these conversations. So I’m exploring rudder, stack, and high touch these are both Cdp or kind of like platforms as well.
86 00:14:21.440 ⇒ 00:14:30.919 Robert Tseng: yeah, these are both possible segment replacements. So if if like, I just wanna kind of put that out there is like I want.
87 00:14:31.040 ⇒ 00:14:43.339 Robert Tseng: I would. I mean, yeah, I’d like to involve you more in that in that decision that it’s not urgent, but like in the next month or 2 months, we’re gonna have to make that decision.
88 00:14:46.410 ⇒ 00:14:48.393 Demilade Agboola: Okay, that sounds good.
89 00:14:49.050 ⇒ 00:14:58.359 Demilade Agboola: we can definitely just figure that out. And like, plan how we want to like like the criteria that we will use to like we them, and then make a decision on them.
90 00:14:58.860 ⇒ 00:14:59.470 Robert Tseng: Yeah.
91 00:15:01.120 ⇒ 00:15:14.489 Robert Tseng: The last thing I mentioned was like a shift to life cycle and Crm analytics. So a lot of what we’ve been doing up to this point, obviously, is setting up the basic reporting, doing a lot more top of funnel performance measure marketing measurement.
92 00:15:15.107 ⇒ 00:15:37.089 Robert Tseng: But yeah, I think, with where we’re at now, I’m trying to get us into a place where we can actually do more behavioral and customer driven analysis. And so I’ve been trying to get the mixed panel stuff in order. I think this will be something that Annie, you and I will collaborate more closely on. So you know, I mean, I’ll just kind of show team real quick. But, for example.
93 00:15:37.545 ⇒ 00:15:45.224 Robert Tseng: today I was working on kind of like redesigning, like the the events that they have. So this is just
94 00:15:48.180 ⇒ 00:15:56.680 Robert Tseng: basically have like a cleaner event data schema that doesn’t fan out so much because right now, if you kind of just go into
95 00:15:57.310 ⇒ 00:16:06.790 Robert Tseng: segment. I know most of you aren’t in this tools, but I do want to show you kind of what’s going on here. This is basically their connector tool. They have all these different sources and web hooks set up here.
96 00:16:07.280 ⇒ 00:16:14.080 Robert Tseng: I would say. Most of the events come from the web. Oh, it times out like every
97 00:16:14.570 ⇒ 00:16:16.309 Robert Tseng: 15 min. Question mark.
98 00:16:20.000 ⇒ 00:16:22.270 Robert Tseng: Sorry. Let me just route to that real quick.
99 00:16:23.100 ⇒ 00:16:24.889 Robert Tseng: So on the web flow side.
100 00:16:25.220 ⇒ 00:16:39.475 Robert Tseng: Yeah. So obviously, most of their event volume is coming from here. A lot of this is just like, you know what you would see in a Google analytics. Right? These are page events track events identify events. If you look at it, there’s just like a bunch of different
101 00:16:39.890 ⇒ 00:16:41.100 Robert Tseng: names.
102 00:16:41.760 ⇒ 00:16:44.879 Robert Tseng: Let’s look at like the debugger, for example.
103 00:16:45.120 ⇒ 00:17:01.719 Robert Tseng: So you can see that there’s just like there’s like, almost like kind of seemingly infinite number of names because of this, the way that this been set up so the way that I would have what way I’m redesigning it is like a page view is just like a single event. And
104 00:17:01.840 ⇒ 00:17:24.610 Robert Tseng: we’re not gonna have, like a million different types of page views, you know. So there’s like some consolidation that I’ve done, or I guess normally normalize normalizing and then kind of just like tracking key milestones. And so the idea is that just as we have the order journey kind of like, clearly mapped out in a funnel from a user perspective. We have that as well from
105 00:17:25.030 ⇒ 00:17:44.089 Robert Tseng: like landing on the site, and it’s just like navigating different pages, things that they click on intake. There’s a few steps to intake the cart cart slash checkout, and then the portal. So these are really only the 3 main workflows that a customer would go through, you know. Obviously, it’s the e-comm site. So it’s not a very complicated product.
106 00:17:44.607 ⇒ 00:17:50.849 Robert Tseng: So yeah, I do think that, you know, simply like less than 20 events should capture everything that they have there.
107 00:17:51.295 ⇒ 00:17:57.470 Robert Tseng: As opposed to what they currently have, which is just this, like huge mess of events that nobody understands.
108 00:17:59.870 ⇒ 00:18:04.900 Robert Tseng: I guess, for anybody who’s on this call, I mean, have you worked with
109 00:18:05.250 ⇒ 00:18:11.560 Robert Tseng: this is, have you worked with the event data before? I I just kind of want to know, like who like right?
110 00:18:11.760 ⇒ 00:18:22.559 Robert Tseng: I mean. I know I’ve I, said Annie, but like I’m also wanting to gauge, like I know, we haven’t really touched on this product analytics work before. But just want to know, like who who has experience in this and who doesn’t.
111 00:18:25.220 ⇒ 00:18:27.390 Awaish Kumar: I mean, I have one didn’t know.
112 00:18:30.480 ⇒ 00:18:33.169 Demilade Agboola: I was just saying. I have worked on like event detail before.
113 00:18:33.590 ⇒ 00:18:37.630 Robert Tseng: Okay, yeah. I mean, it’s not super complicated. Right? And then away, she were saying.
114 00:18:38.390 ⇒ 00:18:44.685 Awaish Kumar: Yeah, I think I, we discussed this that. I worked on like, kind of Gf, 4 kind of data
115 00:18:45.000 ⇒ 00:19:05.080 Robert Tseng: We did discuss this last week. Yeah, yeah, okay. So I mean, similar to a 4 data just rather than just kind of setting all that up in Google tag, manager, or whatever we’re using like a tool like segment or whatnot to. Instead of using pixel base tracking we’re using, like, you know, Javascript, it’s like, more server side tracking. So
116 00:19:05.240 ⇒ 00:19:17.650 Robert Tseng: yeah, so this is the tracking side. And then, once these events live in mixed panel, then that’s like a different reporting environment. That is, we’ll do some more like funnel and behavior based reporting in there.
117 00:19:18.110 ⇒ 00:19:27.300 Robert Tseng: So that’s what I’ve been really trying to get get us going on so hopefully, it’s like, not only tableau reporting like, want us to also be doing this type of stuff, too.
118 00:19:30.020 ⇒ 00:19:37.150 Robert Tseng: So that’s why I’ve kind of prioritized this as a high priority project that I’ve put myself on. So I’m actually gonna move this down
119 00:19:37.820 ⇒ 00:19:49.050 Robert Tseng: medium. This. This is still important, the intake form but I think it’s really gonna be unlocked through what I’m doing in segment. So I think this just means less. I’m just gonna
120 00:19:49.470 ⇒ 00:19:53.260 Robert Tseng: it’s it’s not really something that you’re top of mind working on.
121 00:19:55.100 ⇒ 00:20:03.239 Robert Tseng: product, launch dashboard. There’s probably a couple of other things that need to be hap, that need to happen there. Obviously, we don’t have like location based segmentation yet.
122 00:20:04.160 ⇒ 00:20:04.990 Robert Tseng: yeah.
123 00:20:05.430 ⇒ 00:20:11.259 Robert Tseng: I I could go and implement those. But I’m trying to just assess with the Eden team like.
124 00:20:11.470 ⇒ 00:20:15.980 Robert Tseng: who’s doing that? Or if we’re gonna take that on
125 00:20:16.200 ⇒ 00:20:18.929 Robert Tseng: because I haven’t actually pushed a single change to event
126 00:20:19.100 ⇒ 00:20:27.569 Robert Tseng: data. I’ve only like, deleted events, I’ve never added anything. So I’m trying to sort out like how we’re actually gonna make the changes there.
127 00:20:29.610 ⇒ 00:20:58.760 Robert Tseng: and then on the Elt business reporting side. Yeah, there’s some more kind of interesting, longer term advanced stuff that I want to kind of bring back into the foray. So I haven’t actually wrote out the tickets yet, so I think that’s to be continued. But you know I’ll I’ll say this that we have pacing now, for, you know, month like monthly revenue. But I want to actually build in that predictive Ltv Component, too. So yeah, wanting any to kind of kind of
128 00:20:58.910 ⇒ 00:21:05.619 Robert Tseng: to to take that on. And yeah, we’re gonna try to bring in some of these predictive elements into our reporting now.
129 00:21:08.390 ⇒ 00:21:09.190 Robert Tseng: Yeah.
130 00:21:09.420 ⇒ 00:21:18.480 Robert Tseng: So the last. Yeah, that’s at a high level. What? What’s going on here? I’ll probably like, kind of remove or deprioritize the stuff here. But
131 00:21:18.620 ⇒ 00:21:23.330 Robert Tseng: yeah, I guess any questions kind of in terms of things that we
132 00:21:23.510 ⇒ 00:21:28.959 Robert Tseng: that we’re that you can expect to work on this week, and really for the next sprint.
133 00:21:36.760 ⇒ 00:21:44.349 Demilade Agboola: Not necessarily something to work on, but just something to call out. But, like Eden, has been releasing a bunch of like products recently.
134 00:21:44.610 ⇒ 00:21:45.150 Robert Tseng: Yep.
135 00:21:45.310 ⇒ 00:21:50.150 Demilade Agboola: That has been flagged by our model. I have just been reaching out to
136 00:21:50.320 ⇒ 00:21:55.580 Demilade Agboola: Cutter to ask him questions about how he wants them to be named as products.
137 00:21:58.440 ⇒ 00:22:06.170 Demilade Agboola: yeah, that’s just that’s just it. But like, there’s nothing to like do per se. But like it’s just we, I’m just on top of it. I just wanted to call it out.
138 00:22:06.680 ⇒ 00:22:18.599 Robert Tseng: Okay? Great, yeah, I know that this is this product data standardization thing. They launched 13 to 15 new products, recent like, so I’m sure you’re gonna get a lot of stuff around that so let’s yeah, we’ll just stay
139 00:22:18.720 ⇒ 00:22:20.120 Robert Tseng: kind of stay on top of that.
140 00:22:23.350 ⇒ 00:22:27.370 Demilade Agboola: Also just to follow up on this product thing. Especially with med kids.
141 00:22:29.250 ⇒ 00:22:41.312 Demilade Agboola: yeah. The idea is, I just will. I’ll roll out the sample version. Looking at the refills and just trying to like see that the 1st one is start and the subsequent ones are refills, and they go to the maintenance
142 00:22:41.800 ⇒ 00:22:44.340 Demilade Agboola: version, and we’ll see how that works like
143 00:22:45.260 ⇒ 00:22:58.360 Demilade Agboola: we’ll show up like sample, like orders, and how that works in terms of numbers distribution. I think some of the questions we’re asking the even team. I think it’s a bit abstract to them if they don’t have like dollar amounts where they see. Oh.
144 00:22:58.900 ⇒ 00:22:59.340 Robert Tseng: Exactly.
145 00:22:59.340 ⇒ 00:23:07.960 Demilade Agboola: 100 and 246. So that that doesn’t make sense. Actually, we need to do it this way. I think that that point. It’s Clara to them to answer
146 00:23:08.120 ⇒ 00:23:11.199 Demilade Agboola: rather than the current way, where we’re just kind of talking abstractly.
147 00:23:11.560 ⇒ 00:23:23.520 Robert Tseng: Yeah, no, I agree, we need to put numbers in front of them. So on that note, like, yeah, I know, I tagged you in a message. Rebecca changed the way that she she basically no longer wants Christina manually updating our sheet, which
148 00:23:23.710 ⇒ 00:23:33.779 Robert Tseng: I’m telling her like, look, our time is more expensive than Christine assigned, but whatever she wants us to do it. And so this is really the sheet that she updates when they
149 00:23:33.880 ⇒ 00:23:47.030 Robert Tseng: and I don’t understand all this color coding, and I’ve already asked some questions about like what the heck is, totals and average like is that like all time totals, or is that you know, it’s average like month to date and stuff like that? I’ve asked. But
150 00:23:47.270 ⇒ 00:23:57.300 Robert Tseng: I I think basically her ask is just like for us to use this sheet to update the the sheet we use in our data model. So
151 00:23:58.030 ⇒ 00:24:08.770 Robert Tseng: like, she mentioned switching vendors on a particular skew, or they updated the the cost, the cogs on on one of these skews as well.
152 00:24:09.360 ⇒ 00:24:11.440 Robert Tseng: And before
153 00:24:11.800 ⇒ 00:24:31.930 Robert Tseng: like, I guess Christiana would then take her updates, and then go and put it into our sheet. Supposedly but now, like they just want us to do it. So I I know it seems kind of manual. I wonder if we could just set up something so that every time there’s a change like on a weekly basis, we just have like a
154 00:24:32.120 ⇒ 00:24:44.439 Robert Tseng: a process that like looks for any changes, and that helps us to identify quickly where to update our model. But I guess didn’t want him. This is gonna end up in on for for you to own.
155 00:24:45.140 ⇒ 00:24:57.927 Demilade Agboola: Yeah, I mean, what we could do is we could just set up a if it’s a sheet we could set up a view like in bigquery based off the sheet. So every time Dbt runs it would always be getting the latest data in terms of
156 00:24:59.140 ⇒ 00:25:04.459 Demilade Agboola: like whatever the cogs is, or whatever anything is, we could just set up a view based off that.
157 00:25:04.820 ⇒ 00:25:15.466 Robert Tseng: Okay, yeah, I mean, I know this is structured differently from what we use currently. So I think there’s gonna be some like, you know you’ve got you’re gonna have to manipulate it a bit to get the view you want. But
158 00:25:16.040 ⇒ 00:25:20.630 Robert Tseng: but yeah, I’m I tried to get access to this to share with you. So.
159 00:25:20.880 ⇒ 00:25:22.975 Demilade Agboola: Okay? Sounds good also.
160 00:25:23.610 ⇒ 00:25:32.749 Demilade Agboola: what? What’s is the plan with? Are we still using bask like the ex, like the weekly expose? Because we’re not having like 3 weeks now. 4 weeks now.
161 00:25:36.480 ⇒ 00:25:38.580 Robert Tseng: The weekly exports.
162 00:25:38.890 ⇒ 00:25:41.260 Robert Tseng: Oh, from office.
163 00:25:42.010 ⇒ 00:25:53.459 Robert Tseng: Oh, they haven’t done it! Oh, I see. Yeah. Well, I’ll I’ll message him. But yeah, no, we we assume to be on bask until July, I think, is their timeline.
164 00:25:54.550 ⇒ 00:26:00.949 Demilade Agboola: Okay, cause I I was just wondering if that was still happening. And like, if if that’s still happening, then
165 00:26:01.460 ⇒ 00:26:05.090 Demilade Agboola: it seems like what we’ll be getting from here would just be more of the cogs.
166 00:26:05.280 ⇒ 00:26:05.780 Robert Tseng: Right.
167 00:26:06.010 ⇒ 00:26:06.240 Demilade Agboola: Yeah.
168 00:26:06.240 ⇒ 00:26:08.240 Robert Tseng: Because everything else would come from his sheet.
169 00:26:11.960 ⇒ 00:26:19.119 Robert Tseng: Okay, yeah. I mean, can you? Can you do you mind just like asking him for this I know he stopped doing his weekly thing, but to
170 00:26:19.290 ⇒ 00:26:23.911 Robert Tseng: ask him. And then I’m gonna try to get this into a ticket so we can
171 00:26:24.460 ⇒ 00:26:26.649 Robert Tseng: barely see like what you need to do to get it in.
172 00:26:27.620 ⇒ 00:26:28.850 Demilade Agboola: Okay. Sounds good.
173 00:26:31.040 ⇒ 00:26:39.199 Robert Tseng: Okay, let’s kinda just quickly move through some of the stuff that’s in flight. Then I’m gonna skip anything that’s pending feedback. Unless
174 00:26:39.730 ⇒ 00:26:44.209 Robert Tseng: anything here that anybody wants to call out to me. Otherwise I’m just gonna skip to progress.
175 00:26:46.860 ⇒ 00:26:47.730 Robert Tseng: Oops.
176 00:26:52.030 ⇒ 00:27:01.049 Robert Tseng: Okay? If not, then we’ll keep going. Yeah. So is this fixed.
177 00:27:05.910 ⇒ 00:27:06.670 Annie Yu: Yes.
178 00:27:07.310 ⇒ 00:27:08.330 Robert Tseng: Okay. Sorry.
179 00:27:08.330 ⇒ 00:27:08.840 Annie Yu: Thank you.
180 00:27:09.260 ⇒ 00:27:11.239 Robert Tseng: I did not review it. So
181 00:27:11.820 ⇒ 00:27:15.110 Robert Tseng: actually, I’m just gonna move it to internal feedback.
182 00:27:16.180 ⇒ 00:27:17.520 Robert Tseng: Be updated.
183 00:27:21.420 ⇒ 00:27:30.530 Robert Tseng: Thank you. And then, yeah, embeddable stuff is, I’m just gonna toss it out. It’s gonna be gone.
184 00:27:31.450 ⇒ 00:27:33.080 Robert Tseng: This is gone.
185 00:27:37.170 ⇒ 00:27:39.489 Robert Tseng: This is
186 00:27:43.160 ⇒ 00:27:48.750 Robert Tseng: is this the same thing? Or I think we mentioned that this is like a slightly different. You know, this is.
187 00:27:50.200 ⇒ 00:28:00.770 Robert Tseng: yeah, more to like, give so specific use case so that Rebecca could like understand, like patient level
188 00:28:00.890 ⇒ 00:28:04.100 Robert Tseng: data based on like quantity
189 00:28:04.380 ⇒ 00:28:12.420 Robert Tseng: and refills. I mean, it was like mostly similar to what we had already. I don’t, do we? Do. We remember the context. On this, Annie.
190 00:28:14.065 ⇒ 00:28:19.740 Annie Yu: I think last Friday we were trying to figure out how to get
191 00:28:20.950 ⇒ 00:28:29.649 Annie Yu: how to know the refill remaining for each customer.
192 00:28:31.270 ⇒ 00:28:36.140 Robert Tseng: Yeah, I believe that I asked questions, and then we got to an answer.
193 00:28:36.620 ⇒ 00:28:40.392 Annie Yu: Yeah, I remember you did have a threat with them.
194 00:28:41.170 ⇒ 00:28:49.770 Annie Yu: so yeah, I know there are some questions answered, but I am not sure about the next step. Is that something that we will
195 00:28:49.980 ⇒ 00:28:53.389 Annie Yu: probably need them a lot to do, some modeling work.
196 00:29:00.030 ⇒ 00:29:07.360 Annie Yu: Cause. I I did read through it, and I saw that Rob said, there is a key for remaining refills.
197 00:29:07.870 ⇒ 00:29:16.180 Annie Yu: and that number will get updated each time a new treatment is updated.
198 00:29:26.820 ⇒ 00:29:33.470 Robert Tseng: Okay. I mean, I’m gonna assume that you guys can handle that like it. I I’m gonna
199 00:29:34.600 ⇒ 00:29:38.119 Robert Tseng: I guess. Where? What’s where do you need. Where do you need me? There.
200 00:29:39.718 ⇒ 00:29:49.479 Demilade Agboola: I’ll just think with any like I have a like later today on this, and I will tell you what I understand about this, and like how best it will be to look at it.
201 00:29:49.760 ⇒ 00:29:52.960 Demilade Agboola: And if that works from a dashboard perspective.
202 00:30:01.670 ⇒ 00:30:03.899 Robert Tseng: I don’t know which what the field is called exactly.
203 00:30:07.080 ⇒ 00:30:07.940 Annie Yu: Okay, let’s
204 00:30:08.292 ⇒ 00:30:19.569 Annie Yu: one question for you, Robert. For this part, do we expect kind of like a a more comp comprehensive page? Or it could be just like a text table where people can
205 00:30:20.540 ⇒ 00:30:21.810 Annie Yu: dive in.
206 00:30:22.060 ⇒ 00:30:28.239 Robert Tseng: Yeah, I think just a table is fine. They didn’t give any direction on the visualization. So let’s just give them like.
207 00:30:28.580 ⇒ 00:30:30.020 Robert Tseng: yeah, the table like a table.
208 00:30:30.020 ⇒ 00:30:31.729 Annie Yu: Further. Investigate. Okay.
209 00:30:31.730 ⇒ 00:30:32.820 Robert Tseng: Yeah. Yeah.
210 00:30:35.850 ⇒ 00:30:40.329 Robert Tseng: I mean, I think in the request itself, here’s an example of a type of question
211 00:30:40.740 ⇒ 00:30:45.969 Robert Tseng: like, I get different variations of this from her. But it’s just like, Hey, in the past.
212 00:30:46.110 ⇒ 00:30:49.810 Robert Tseng: Yeah, I got one this morning in the past week. How many?
213 00:30:50.100 ⇒ 00:31:05.350 Robert Tseng: Some more in patients like, ordered 1.6 milligrams or whatever, and like something like that where it’s yeah, I could run the query, but it’s like we might as well, just build like a table with some filters that she can go and click some stuff on if she wants to go and answer that.
214 00:31:05.870 ⇒ 00:31:07.330 Robert Tseng: Yeah, yeah.
215 00:31:07.800 ⇒ 00:31:13.689 Robert Tseng: Okay, yeah. Product, launch dashboard.
216 00:31:13.920 ⇒ 00:31:16.320 Robert Tseng: We is this considered done? Or.
217 00:31:16.745 ⇒ 00:31:21.850 Annie Yu: Yeah, last week the top line revenue was weird. But that’s updated.
218 00:31:24.350 ⇒ 00:31:27.460 Annie Yu: So I think that’s about it.
219 00:31:28.380 ⇒ 00:31:35.787 Robert Tseng: Okay, I’m gonna go and just make a note to okay. Revenue updated.
220 00:31:39.000 ⇒ 00:31:54.179 Demilade Agboola: Just a very random question. It’s not related to this task, but it came to my mind right now, and I’ll definitely ask if I forget for some products that are coming in so like something like semaglutide. There is one of them like one like there’s a product, that is.
221 00:31:54.530 ⇒ 00:32:01.740 Demilade Agboola: it looks like it’s semagluta, but it looks misspelled. So it’s instead of SEMA. It’s SEAM.
222 00:32:01.990 ⇒ 00:32:06.939 Demilade Agboola: Glutide now, obviously, because we were using Regex. It doesn’t catch that.
223 00:32:07.510 ⇒ 00:32:13.829 Demilade Agboola: So my my opinion is, do we modify the rejects to catch that? Or do we push it back to them for them to fix that.
224 00:32:16.110 ⇒ 00:32:20.979 Robert Tseng: Yeah, let’s push it back to them first.st yeah. I mean they. They should fix that.
225 00:32:20.980 ⇒ 00:32:25.870 Demilade Agboola: So we should push it back to who’s specifically bask or the marketing team. Alright.
226 00:32:26.580 ⇒ 00:32:30.790 Robert Tseng: I would just like, put in that analytics channel and just
227 00:32:31.300 ⇒ 00:32:45.399 Robert Tseng: tech cutter. Or, yeah, I mean, he’s the he’s he’s brought a guy like they’re like, Hey, this is, this is spelled wrong. Just want to make sure that this is not actually a new product like we can play dumb here and just be like, is this semi glutide and like, make them decide like.
228 00:32:45.660 ⇒ 00:32:46.760 Demilade Agboola: So what to do with that
229 00:32:46.760 ⇒ 00:32:49.990 Demilade Agboola: actually did try that. And he didn’t respond. So.
230 00:32:50.160 ⇒ 00:32:50.940 Robert Tseng: Oh, really.
231 00:32:50.940 ⇒ 00:32:53.290 Demilade Agboola: Yeah, I could tag you in it, but.
232 00:32:54.100 ⇒ 00:32:58.646 Robert Tseng: Oh, okay, yeah. Sorry that not too many things. But
233 00:32:59.810 ⇒ 00:33:08.730 Robert Tseng: Okay, yeah. If you ever don’t get a response from something like that you you just just tag me, and then I will just tag like 5 other people like.
234 00:33:08.920 ⇒ 00:33:10.240 Demilade Agboola: Gotcha! We’ll do.
235 00:33:10.590 ⇒ 00:33:16.430 Robert Tseng: Yeah, I think that’s just like silly. We don’t think we should change our Regex for that. So
236 00:33:20.580 ⇒ 00:33:25.990 Robert Tseng: okay. And then the you know, you’re obviously monitoring the the product level product stuff.
237 00:33:26.260 ⇒ 00:33:34.840 Robert Tseng: Alright, I know we’re at time. We didn’t talk about stuff that’s in cycle. There’s a couple of things that we’re in queue up on. Yeah, we could just kind of close things out for today. And then.
238 00:33:35.289 ⇒ 00:33:45.420 Robert Tseng: yeah, I think I’m I’m gonna really. Okay, I’ll I’ll bring some more stuff into cycle. So we can keep keep moving on this throughout this week.
239 00:33:49.710 ⇒ 00:33:55.782 Robert Tseng: Okay, yeah, if any other questions, let me know. Otherwise we’ll be be in touch, and then
240 00:33:57.230 ⇒ 00:33:58.149 Robert Tseng: talk on slack.
241 00:33:59.020 ⇒ 00:33:59.870 Annie Yu: Awesome. Thank you.
242 00:33:59.970 ⇒ 00:34:01.180 Robert Tseng: Alright! Thanks everyone. Bye.
243 00:34:01.180 ⇒ 00:34:01.530 Awaish Kumar: Bye.