Meeting Title: [Eden] Order Issues and Forecasting Sync Date: 2025-07-24 Meeting participants: Robert Tseng, Fireflies.ai Notetaker Tigran, Josh , Annie Yu, Tigran Sahakyan, Demilade Agboola, Amber Lin, Henry Zhao
WEBVTT
1 00:06:17.300 ⇒ 00:06:18.410 Josh : Yo what up?
2 00:06:19.500 ⇒ 00:06:20.309 Robert Tseng: Hey, Josh.
3 00:06:21.150 ⇒ 00:06:22.080 Josh : What’s going on.
4 00:06:24.050 ⇒ 00:06:33.230 Robert Tseng: Add, yeah, you just late night and then trying to
5 00:06:36.260 ⇒ 00:06:39.439 Robert Tseng: trying to keep us on track. Yeah, I don’t have too many thoughts right now.
6 00:06:41.471 ⇒ 00:06:44.488 Josh : It would be awesome if we could.
7 00:06:45.790 ⇒ 00:06:55.670 Josh : if we could. Get just a really clear answer of like depending and error and
8 00:06:56.350 ⇒ 00:07:04.200 Josh : issue orders like, somehow, some way today, like it’s
9 00:07:06.030 ⇒ 00:07:09.129 Josh : it’s I’m just. I’m just trying to
10 00:07:09.470 ⇒ 00:07:15.790 Josh : make this into a machine and like I can get it in through bask. It’s just bask sucks, dude.
11 00:07:16.730 ⇒ 00:07:21.210 Josh : and, like our team is just dying with this.
12 00:07:23.980 ⇒ 00:07:36.990 Robert Tseng: Yeah, I mean the the thing that Rebecca’s floating was more around forecasting. I don’t think she’s I mean I don’t know. I don’t think that’s what you’re talking about. So you’re still kind of focused on like the
13 00:07:37.520 ⇒ 00:07:39.339 Robert Tseng: orders or issues right?
14 00:07:39.820 ⇒ 00:07:44.759 Josh : Yeah, into some kind of like way to flag. And
15 00:07:44.920 ⇒ 00:07:59.730 Josh : you know, like, like, it would be great if, like, there’s just like a it’s breaching a certain threshold or number in a day, so we could start to see like, Oh, shit! Something is seriously wrong to fucking. Fix it.
16 00:08:00.860 ⇒ 00:08:02.050 Robert Tseng: Yeah.
17 00:08:02.350 ⇒ 00:08:12.229 Josh : Like cause. There’s no kind of like re, like reporting stuff like that. And that. So yeah, we can go through. And like, right now, I could see there’s like a thousand issues right now, right? And like.
18 00:08:12.380 ⇒ 00:08:20.979 Josh : you know, we can sort, we can do stuff inside a bask, and then we can have it. Send us a report. And then the team is just like working off of that thing.
19 00:08:22.117 ⇒ 00:08:23.640 Josh : It’s not great.
20 00:08:23.860 ⇒ 00:08:27.390 Josh : It works to an extent. But it’s like, you know.
21 00:08:28.750 ⇒ 00:08:39.570 Josh : I’m also just looking for ways to like start helping the team identify like patterns in this stuff. Because, like, I went through yesterday, and it’s like an hour in there, and was like, Oh, I see a couple of patterns. I see.
22 00:08:39.799 ⇒ 00:08:48.860 Josh : You know these new orders that are, you know, happening at we’re just okay
23 00:08:48.980 ⇒ 00:09:03.419 Josh : or so like, how does it get cleaned up? And then I saw like a couple of things. So like, you know, I’m like, Hey, like, maybe we need to make a process. Maybe we need to go from like oldest order at specific pharmacies and like, have teams set up around that.
24 00:09:03.740 ⇒ 00:09:09.080 Josh : So like, that’s that’s, kinda you know. That’s what what I’m trying.
25 00:09:09.680 ⇒ 00:09:13.320 Josh : Make him start thinking about is like, How do you just?
26 00:09:16.710 ⇒ 00:09:18.829 Josh : And yeah, there are.
27 00:09:19.310 ⇒ 00:09:20.860 Josh : They’re kind of struggling.
28 00:09:22.090 ⇒ 00:09:22.760 Robert Tseng: Okay.
29 00:09:23.306 ⇒ 00:09:34.420 Robert Tseng: so I actually, I haven’t walked the team through this as well. So I’ll just spend a couple of minutes. But this is basically what Bass was like trying to convince me is
30 00:09:34.750 ⇒ 00:09:40.820 Robert Tseng: try to so to help with order escalations. Before they’re set
31 00:09:41.160 ⇒ 00:09:50.649 Robert Tseng: to the pharmacy. I guess when you were in the product. Were you looking at this at all, I don’t know how much I should over explain this, Josh.
32 00:09:51.320 ⇒ 00:09:55.660 Josh : Yeah, no, no, I’m like, if you are, you in bask, just go to bask, and then.
33 00:09:55.660 ⇒ 00:09:56.260 Robert Tseng: I’m inbound.
34 00:09:56.260 ⇒ 00:10:00.180 Josh : Yeah, you just go to orders just literally just go to orders.
35 00:10:00.765 ⇒ 00:10:10.869 Robert Tseng: Okay, yeah, I could. But I I it takes so long to load. But like, yeah, I mean, I was in orders, like, I think I was doing stuff in there and sending to the team, but like.
36 00:10:11.650 ⇒ 00:10:24.720 Robert Tseng: I guess, like, he sorted these different types of errors. So in my mind, these are preset filters. For orders that before they’re sent to pharmacy.
37 00:10:24.910 ⇒ 00:10:26.380 Josh : We don’t even.
38 00:10:26.380 ⇒ 00:10:38.039 Robert Tseng: We don’t even have this. Yeah, like he’s, he said. He built this specifically for Rebecca, because Rebecca, kinda her issues kind of talked. You know, everything was about trying to catch
39 00:10:38.643 ⇒ 00:10:42.270 Robert Tseng: you know, delinquent orders, or as early as possible.
40 00:10:42.360 ⇒ 00:10:55.150 Robert Tseng: And so he’s kind of just like created different stages that she can look at supposedly. That are like Rx errors, or these are, you know, delayed treatments. And it’s not
41 00:10:55.150 ⇒ 00:11:12.949 Robert Tseng: only from order status filtering, because I agree with you if you go to orders and you use the order statuses, and you, they’re unreliable like that was one of the points that we made to them so, and he understand he has this on the back end, he under. They think they understand kind of like this whole.
42 00:11:13.040 ⇒ 00:11:32.510 Robert Tseng: There’s you use order statuses. You use kind of payment delays and you use treatments. He’s looking at 3 different objects to create these filters. Whereas, like from Rebecca’s perspective. And I guess just any layman user. You would only be looking at order statuses. You’re not really looking at like
43 00:11:32.640 ⇒ 00:11:38.289 Robert Tseng: you. You just assume that the payment and the treatment stuff is like kind of taken care of in the background. But
44 00:11:38.480 ⇒ 00:11:50.820 Robert Tseng: he’s tried to like kind of articulate what these different things are. I I feel like if this is what it says. Says it is like this kind of gets to what Rebecca wants is just maybe there’s an education gap where, like
45 00:11:51.010 ⇒ 00:11:54.820 Robert Tseng: her team, hasn’t really been trained to like, really use this.
46 00:11:54.920 ⇒ 00:12:23.729 Robert Tseng: But I mean, I think these are the buckets of the common issues that are happening before they get to the, to the pharmacy, and she could just pull up this list and then try to go triage these ones. It’s still kind of like you have to click on this filter, then hit the export button, and then I don’t really know exactly how her team dials up pharmacies to go figure this out. But yeah, like I I don’t know if, like, this is something that can be the that solution for her or not
47 00:12:23.910 ⇒ 00:12:33.009 Robert Tseng: like as the basically what I would do is we would try to replicate this in tableau like we. I believe that’s gonna take some time. We’re gonna have to go back and forth on like.
48 00:12:33.010 ⇒ 00:12:41.699 Josh : Yeah, it’s not worth. It’s not worth. You just have. Okay, it’s fine. Just leave it in bask. And it’s whatever hopefully we don’t even have to deal with this shit anymore.
49 00:12:43.180 ⇒ 00:12:47.539 Robert Tseng: Okay. But if it’s urgent, like, maybe we just kinda give.
50 00:12:47.890 ⇒ 00:12:56.812 Josh : I just know that also, like Rebecca’s, Rebecca’s out, basically for the rest of this week. And I’m just trying to make sure all these orders out I got
51 00:12:58.310 ⇒ 00:13:06.660 Josh : looks like we have a lot of errors. You know what I mean. We have a lot of things, and, like, you know.
52 00:13:08.160 ⇒ 00:13:10.010 Josh : like like the.
53 00:13:10.010 ⇒ 00:13:10.690 Robert Tseng: Yeah, you can.
54 00:13:10.690 ⇒ 00:13:11.159 Josh : See there!
55 00:13:11.160 ⇒ 00:13:12.660 Robert Tseng: All these errors there’s
56 00:13:12.980 ⇒ 00:13:18.530 Robert Tseng: I don’t. I don’t know how this is possible. 12,000 errors is like what is going on here, but.
57 00:13:20.270 ⇒ 00:13:31.709 Josh : Like. But the doctor errors are 606. So it’s like, you know, that’s that’s a different issue than than the pharmacy. So it’s like, Okay, pharmacy stuff’s fixed. But now the doctor’s thing is
58 00:13:32.334 ⇒ 00:13:38.690 Josh : so what needs to be action? And like, how does the team start fixing that stuff? That’s the question.
59 00:13:39.220 ⇒ 00:13:40.160 Josh : So.
60 00:13:41.170 ⇒ 00:13:41.840 Robert Tseng: Yeah.
61 00:13:42.550 ⇒ 00:13:59.869 Robert Tseng: because I look at this number 2, 87 h turnaround time from like order set to shift what? That’s like. A little over 3 days. That is basically what Annie has shown as well in the tableau report. She just doesn’t have all of these other errors of like it got stuck at the doctors, or there was like.
62 00:14:00.050 ⇒ 00:14:11.189 Robert Tseng: I guess we could. Probably I don’t know if our pharmacy number matches this. But anyway, like, it’s just yeah, we don’t have as clear buckets as as on the other, on the other types of errors here. So.
63 00:14:11.500 ⇒ 00:14:12.110 Josh : Yeah.
64 00:14:13.860 ⇒ 00:14:23.019 Josh : no, I understand. I understand and then I gotta jump here in just a second. But I so outside of this stuff. Then we also have
65 00:14:23.180 ⇒ 00:14:30.430 Josh : the Ehc stuff that we talked about, and then we have the. I saw your note about the marketing.
66 00:14:30.650 ⇒ 00:14:37.540 Josh : you know attribution stuff, and you’ve been digging in deeper and seeing that’s a little more challenging than you thought.
67 00:14:38.210 ⇒ 00:14:39.710 Josh : Blah blah! So.
68 00:14:39.710 ⇒ 00:14:54.119 Robert Tseng: Yeah, that should be. It should be fine today, like we, anyway. So but yeah, that this whole kind of it has taken us longer than I thought to to get that push that through regarding ehc, data. I actually jumped on the phone with corral yesterday.
69 00:14:54.699 ⇒ 00:14:59.810 Robert Tseng: I mean, they just they they flip their mind again. They said they’re willing to do month to month.
70 00:15:00.783 ⇒ 00:15:09.879 Robert Tseng: I was like, you’re not gonna get the deal. So I guess if you, if we want to consider that, I think that’s that’s that’s the options on the table again.
71 00:15:10.400 ⇒ 00:15:11.939 Josh : Well, yeah. Dude tell Danny.
72 00:15:12.300 ⇒ 00:15:14.379 Robert Tseng: Alright. Yeah. So I’m gonna tell Danny today.
73 00:15:14.510 ⇒ 00:15:15.220 Robert Tseng: Yeah.
74 00:15:15.800 ⇒ 00:15:17.419 Josh : Cool man cool.
75 00:15:20.790 ⇒ 00:15:25.619 Josh : Alright sounds good man, any any staffing you need for.
76 00:15:26.254 ⇒ 00:15:40.540 Robert Tseng: No. So I think message is actually gonna go out under the week. But just as a preview, I think, Henry and I have kind of, concluded the Cdp stuff. So we’re not switching to rudder stack. We’re staying on segment. The bill is being cut by like 60 70%
77 00:15:41.068 ⇒ 00:15:58.080 Robert Tseng: which is great. And then, yeah, I think we. I’ll also get Danny. But we do have. But we we did, and consolidating some of the features on segment and moving it around like we. Yeah, I think there is like a we’re
78 00:15:58.460 ⇒ 00:15:58.880 Robert Tseng: we’re gonna.
79 00:15:58.880 ⇒ 00:16:00.449 Josh : That new contract.
80 00:16:01.140 ⇒ 00:16:12.100 Robert Tseng: We have to sign it by the month which we have time like. It’s, you know, it’s July 31st is when this it’s it’s up, but they usually get. Yeah, I think we can sign it next week. But yeah.
81 00:16:13.941 ⇒ 00:16:17.320 Josh : Okay, well, let’s like not wait till the last minute, like, let’s
82 00:16:18.330 ⇒ 00:16:20.119 Josh : let’s get it signed this week.
83 00:16:20.900 ⇒ 00:16:27.240 Robert Tseng: Yeah. So yeah, okay, so we’re gonna send that out. Cool.
84 00:16:28.210 ⇒ 00:16:30.600 Robert Tseng: Yeah. So that’s that’s those are the big things.
85 00:16:30.960 ⇒ 00:16:35.580 Josh : Who needs to sign on it. Danny, me and I don’t care who signs.
86 00:16:35.580 ⇒ 00:16:41.980 Robert Tseng: I think Adam signed the previous one, so I don’t know if you want to keep the same sign or not, but I’ll I’ll have it in the exact channel.
87 00:16:42.280 ⇒ 00:16:46.950 Robert Tseng: There’s a couple of things that we just need to align on like vendor wise.
88 00:16:47.290 ⇒ 00:16:59.239 Josh : I mean, honestly, if it’ll be faster, just give it to me. Adam’s like gonna be working on pharmacy shit, you know. So if you want, you can just leave it. I’ll sign it as long as it’s a good deal. We’re good.
89 00:16:59.640 ⇒ 00:17:03.250 Robert Tseng: Yeah, yeah, no, it’s it’s a better deal than I thought they were. Gonna give us. So.
90 00:17:03.690 ⇒ 00:17:04.349 Josh : Cool.
91 00:17:04.579 ⇒ 00:17:05.149 Robert Tseng: Yeah.
92 00:17:05.480 ⇒ 00:17:14.220 Josh : Okay? Well, ehd, stuff marketing data. And then let’s, I guess the operation stuff we’ll just
93 00:17:14.849 ⇒ 00:17:17.892 Josh : do through bask for now. Okay.
94 00:17:18.599 ⇒ 00:17:18.989 Robert Tseng: Okay.
95 00:17:19.250 ⇒ 00:17:20.420 Josh : I finished this.
96 00:17:20.420 ⇒ 00:17:21.559 Robert Tseng: See ya bye.
97 00:17:24.730 ⇒ 00:17:27.767 Robert Tseng: Okay. Hello, everyone.
98 00:17:29.130 ⇒ 00:17:35.910 Robert Tseng: yeah. Sometimes. They just jump in the call, and he just wants to talk about the most urgent thing on his mind, so.
99 00:17:36.030 ⇒ 00:17:37.080 Amber Lin: Okay.
100 00:17:37.630 ⇒ 00:17:38.370 Robert Tseng: Yeah.
101 00:17:38.370 ⇒ 00:17:42.259 Amber Lin: I will ask you how I would handle that in the future. But.
102 00:17:42.720 ⇒ 00:17:43.130 Robert Tseng: Okay.
103 00:17:43.130 ⇒ 00:17:45.568 Amber Lin: And all that. So not my problem. Right now.
104 00:17:49.383 ⇒ 00:17:50.790 Amber Lin: I will.
105 00:17:51.140 ⇒ 00:17:53.540 Amber Lin: I will run this so.
106 00:17:53.830 ⇒ 00:17:55.630 Robert Tseng: Take it right over to you. Yeah.
107 00:17:57.180 ⇒ 00:17:58.260 Amber Lin: All right.
108 00:17:59.620 ⇒ 00:18:11.609 Amber Lin: So we had a few, a few new requests. I think we added these from the new project. Can you guys help me see who’s owning that, Robert? Is that gonna be you?
109 00:18:11.982 ⇒ 00:18:14.650 Amber Lin: Yeah, those are. You can just sign all those to me.
110 00:18:14.650 ⇒ 00:18:17.359 Amber Lin: Oh, do you have capacity.
111 00:18:18.600 ⇒ 00:18:19.180 Robert Tseng: So
112 00:18:19.180 ⇒ 00:18:25.910 Robert Tseng: yeah, well, so like this Andrew guy is he signed this morning. So he’s gonna come on today. I’m gonna
113 00:18:26.250 ⇒ 00:18:29.120 Robert Tseng: move. So I’m gonna basically reassign some of the stuff to him.
114 00:18:29.120 ⇒ 00:18:31.100 Amber Lin: Okay, sounds good.
115 00:18:31.420 ⇒ 00:18:33.209 Amber Lin: So we have.
116 00:18:33.380 ⇒ 00:18:38.919 Amber Lin: Oh, this Cdp, one who’s owning this.
117 00:18:42.670 ⇒ 00:18:44.630 Robert Tseng: I guess I mean, that’s
118 00:18:44.770 ⇒ 00:18:53.669 Robert Tseng: technically, Henry. I don’t know how much you can get done before you’re out, and Bobby still hasn’t sent over some stuff. But yeah, I I think this, we got.
119 00:18:53.670 ⇒ 00:19:03.509 Amber Lin: Put it there. If we don’t get it done, we’ll we’ll move it, the cycles ending so, and then this one, I assume it’s either Annie or Dama.
120 00:19:04.050 ⇒ 00:19:04.670 Robert Tseng: How many.
121 00:19:04.670 ⇒ 00:19:06.250 Amber Lin: Why is wrong? Rebecca.
122 00:19:06.670 ⇒ 00:19:15.808 Robert Tseng: Yeah, I was actually working on a new project. So I mean, I guess since Annie and Dave a lot of both here. Yeah, I think this is more than just a single task. And
123 00:19:16.690 ⇒ 00:19:24.690 Robert Tseng: I I did share the I built the original product forecasting model for Eden. Like back in like February.
124 00:19:25.484 ⇒ 00:19:32.899 Robert Tseng: I’ve been trying to like kind of chip away at it and get us kind of handle. Hand it over to our team to own moving forward. But.
125 00:19:33.752 ⇒ 00:19:40.560 Robert Tseng: We, I mean, it’s clearly been 3 months since then, and if it hasn’t 3 or 4 months, 4 months since then it hasn’t happened.
126 00:19:40.830 ⇒ 00:19:44.050 Robert Tseng: And now we’re kind of
127 00:19:45.210 ⇒ 00:19:51.479 Robert Tseng: yeah, like, I, I think I just need to turn that into an actual natural project rather than just.
128 00:19:51.880 ⇒ 00:20:08.519 Robert Tseng: There is a ticket on it in it for this that was like in the block stage for the longest time, where I was waiting for like vial size to come through in the modeling which it kind of is for one product category. But yeah, I think
129 00:20:08.640 ⇒ 00:20:09.630 Robert Tseng: there’s
130 00:20:10.790 ⇒ 00:20:24.890 Robert Tseng: I don’t think what Rebecca is asking for is achievable in tableau, which is why, even though she’s asking for a dashboard, I don’t believe the tab. The the dashboard is solution. I don’t think anybody does product forecasts. Yeah, in in tableau, like, it’s just not flexible enough.
131 00:20:25.380 ⇒ 00:20:31.019 Robert Tseng: So I I do think the the spreadsheet model is the way to go. I just.
132 00:20:31.330 ⇒ 00:20:32.960 Robert Tseng: I just need to.
133 00:20:33.930 ⇒ 00:20:39.630 Robert Tseng: Yeah, I mean, I, I need to update the the product model using kind of
134 00:20:40.200 ⇒ 00:20:48.959 Robert Tseng: I, I can make it more automated and try to pull in data into the Google sheet. But it’s this isn’t. Gonna this is gonna take another like 5 h of my time. Probably.
135 00:20:49.306 ⇒ 00:20:55.550 Amber Lin: So this is not something we’re doing. Currently, do you want me to convert that into a project.
136 00:20:55.900 ⇒ 00:21:06.140 Robert Tseng: Yeah, let’s convert to a project. She does. I know there’s a time crunch on it because she asked for this kind of stuff at the end of every month. So we we’ve just kind of
137 00:21:06.320 ⇒ 00:21:12.849 Robert Tseng: yeah. So I I think it has to be done next week, which is fine. I I should be able to do it next week. But yeah.
138 00:21:16.530 ⇒ 00:21:22.439 Amber Lin: Okay, so I will go. Move this.
139 00:21:23.680 ⇒ 00:21:25.310 Amber Lin: And then
140 00:21:29.920 ⇒ 00:21:33.450 Amber Lin: in one week, all right.
141 00:21:38.300 ⇒ 00:21:41.429 Amber Lin: Okay, Harry. Let’s start here, then
142 00:21:41.980 ⇒ 00:21:43.719 Amber Lin: can I close any of these.
143 00:21:45.890 ⇒ 00:21:47.330 Henry Zhao: Let’s see
144 00:21:48.270 ⇒ 00:21:53.219 Henry Zhao: Robert, what’s the update on the Meta? Did you? Were you able to turn off the track test tracking Pixel.
145 00:21:54.098 ⇒ 00:22:02.210 Robert Tseng: Yes, I didn’t actually switched off the test pixel yet. I mean the basically redid the model last night, I think.
146 00:22:02.210 ⇒ 00:22:04.130 Robert Tseng: Yeah. But it’s a waste out amber.
147 00:22:04.500 ⇒ 00:22:05.130 Henry Zhao: Yeah. Wishes out.
148 00:22:05.130 ⇒ 00:22:06.589 Amber Lin: Oh, where’d you saw today.
149 00:22:06.590 ⇒ 00:22:08.429 Henry Zhao: I’m going to look at the query that you sent.
150 00:22:08.920 ⇒ 00:22:10.379 Henry Zhao: It looks good so far.
151 00:22:11.220 ⇒ 00:22:22.590 Robert Tseng: Yeah. So I think once the query is good, I mean, I wanted to convert it into a Dvt model, and then kind of just sync that to segment. But if that’s too much to ask for this this week, I’ll just
152 00:22:22.840 ⇒ 00:22:30.129 Robert Tseng: put the query and segment, and it can. It can rip off of that. So yeah, other than that already set up.
153 00:22:30.696 ⇒ 00:22:35.500 Robert Tseng: The destination. There’s like a staging and prod. So in production.
154 00:22:35.985 ⇒ 00:22:43.070 Robert Tseng: You just have to remove the test, the the test snippet, and then it should. It should be. It should be in production.
155 00:22:43.070 ⇒ 00:22:43.800 Henry Zhao: Okay.
156 00:22:44.570 ⇒ 00:22:45.660 Henry Zhao: Sounds good. There.
157 00:22:45.790 ⇒ 00:22:46.290 Amber Lin: Okay.
158 00:22:46.290 ⇒ 00:22:46.860 Robert Tseng: Yeah.
159 00:22:52.060 ⇒ 00:22:54.900 Amber Lin: Are these in progress?
160 00:22:54.900 ⇒ 00:22:56.610 Henry Zhao: These 2 are gonna have to be.
161 00:22:57.050 ⇒ 00:23:00.649 Amber Lin: Probably the 1st week in August, unless I can get Andrew to.
162 00:23:01.380 ⇒ 00:23:04.610 Henry Zhao: But I yeah, I’d rather just do them when I get back in in August.
163 00:23:05.370 ⇒ 00:23:08.760 Amber Lin: Okay, I’m gonna move that.
164 00:23:08.910 ⇒ 00:23:11.959 Henry Zhao: Yeah, same thing. Reduce redundancy that might even have to be.
165 00:23:12.862 ⇒ 00:23:13.860 Henry Zhao: The following cycle.
166 00:23:15.420 ⇒ 00:23:15.900 Henry Zhao: Yeah.
167 00:23:15.900 ⇒ 00:23:19.902 Amber Lin: I see so move that
168 00:23:20.550 ⇒ 00:23:23.540 Henry Zhao: Why is there? Why is there no cycle for August 4th through 10.th
169 00:23:24.920 ⇒ 00:23:26.300 Amber Lin: Let’s see.
170 00:23:26.730 ⇒ 00:23:31.870 Amber Lin: Oh, interesting! Probably because I changed the dates. I will go change that. Don’t worry.
171 00:23:31.870 ⇒ 00:23:32.500 Henry Zhao: Okay.
172 00:23:32.857 ⇒ 00:23:35.719 Amber Lin: Are we? Gonna tell stakeholders before you leave.
173 00:23:38.800 ⇒ 00:23:41.889 Henry Zhao: Yeah, maybe I’m gonna talk to Robert later today.
174 00:23:42.240 ⇒ 00:23:43.170 Amber Lin: Okay.
175 00:23:43.390 ⇒ 00:23:49.780 Amber Lin: yeah, let let us know. I I know we said this was pretty important, so I’ll check on it.
176 00:23:50.710 ⇒ 00:23:53.039 Henry Zhao: Yeah, yeah, I can do it today. Yeah, after I just talk to Robert.
177 00:23:53.390 ⇒ 00:23:54.629 Amber Lin: Okay. Awesome.
178 00:23:55.370 ⇒ 00:23:58.149 Henry Zhao: Alright, Robert, can you make our one on one later today?
179 00:23:58.430 ⇒ 00:23:59.300 Robert Tseng: Yeah, yeah.
180 00:23:59.300 ⇒ 00:24:00.150 Henry Zhao: Okay, perfect.
181 00:24:00.150 ⇒ 00:24:00.960 Amber Lin: Hmm!
182 00:24:01.610 ⇒ 00:24:02.440 Amber Lin: Alright!
183 00:24:02.440 ⇒ 00:24:02.830 Robert Tseng: Out!
184 00:24:02.830 ⇒ 00:24:06.400 Amber Lin: And Robert, are your tickets? Update.
185 00:24:08.060 ⇒ 00:24:09.100 Amber Lin: No, no.
186 00:24:12.295 ⇒ 00:24:12.890 Amber Lin: Okay.
187 00:24:13.360 ⇒ 00:24:14.410 Amber Lin: Set on.
188 00:24:15.626 ⇒ 00:24:23.713 Robert Tseng: Yeah. So that’s gonna be the notion. I think I’m gonna send this out after this call so you can just consider it done
189 00:24:24.310 ⇒ 00:24:29.930 Robert Tseng: didn’t request a flexible tech team. I mean, I kind of just
190 00:24:32.490 ⇒ 00:24:36.560 Robert Tseng: yeah, we can consider that down. That doesn’t matter anymore. We basically took it on.
191 00:24:36.940 ⇒ 00:24:37.590 Robert Tseng: Oh.
192 00:24:39.900 ⇒ 00:24:40.890 Amber Lin: Okay.
193 00:24:41.160 ⇒ 00:24:42.280 Amber Lin: And then.
194 00:24:43.754 ⇒ 00:24:54.069 Robert Tseng: This is, I mean, this is a bigger task. We only only done this for Meta. So I think you, I think you created this ticket, and then we we kinda it’s a little bit
195 00:24:54.070 ⇒ 00:24:55.000 Robert Tseng: to General.
196 00:24:55.250 ⇒ 00:24:56.370 Amber Lin: I see.
197 00:24:56.690 ⇒ 00:24:58.139 Robert Tseng: Yeah, so.
198 00:24:58.140 ⇒ 00:25:02.690 Amber Lin: Delete. Say it’s duplicate. Say, it’s create a different one.
199 00:25:03.660 ⇒ 00:25:06.319 Robert Tseng: Well, I mean, I don’t. I think.
200 00:25:06.620 ⇒ 00:25:14.160 Robert Tseng: Yeah, we might. We should split it up. But, like the order is, you can write write this down. But it it we’re going Meta north beam.
201 00:25:14.440 ⇒ 00:25:20.629 Robert Tseng: reddit interest. And then Google. So to me, this is really 5 tickets, because they’re all kind of different. They’re not.
202 00:25:20.770 ⇒ 00:25:35.009 Robert Tseng: I mean, hopefully, the underlying model is about the same, and I don’t expect to create different models for every single one of them. But it will. Yeah, like it’s we’re gonna have to go one by one, and that’s where where I’m hoping Andrew is. Gonna help speed us up there.
203 00:25:36.386 ⇒ 00:25:41.969 Amber Lin: Okay, so I will, I will go edit this later.
204 00:25:42.210 ⇒ 00:25:42.800 Robert Tseng: Yeah.
205 00:25:43.240 ⇒ 00:25:44.280 Amber Lin: Oh!
206 00:25:46.980 ⇒ 00:26:00.679 Robert Tseng: Yeah, I mean the Meta. One has probably taken us like 5 HI hope the other ones will not take as long. Now that we’ve kind of hopefully gotten it. At least, the modeling doesn’t have to be Redone. Hopefully.
207 00:26:01.582 ⇒ 00:26:04.860 Robert Tseng: But yeah, I would say, each one of them is like 2 points.
208 00:26:05.030 ⇒ 00:26:05.970 Amber Lin: Okay.
209 00:26:05.970 ⇒ 00:26:06.560 Robert Tseng: Yeah.
210 00:26:08.360 ⇒ 00:26:09.850 Amber Lin: Sounds good.
211 00:26:10.780 ⇒ 00:26:13.610 Amber Lin: Oh, shit that out!
212 00:26:16.540 ⇒ 00:26:17.540 Amber Lin: That one.
213 00:26:18.470 ⇒ 00:26:22.290 Robert Tseng: Oh, yeah, we’re done. Yeah, I think I I know the
214 00:26:23.380 ⇒ 00:26:27.000 Robert Tseng: I shared a message with with the team already on that one.
215 00:26:28.130 ⇒ 00:26:28.810 Amber Lin: Okay.
216 00:26:29.600 ⇒ 00:26:31.890 Robert Tseng: Yeah. So this is that maybe, like
217 00:26:32.330 ⇒ 00:26:35.419 Robert Tseng: the other ticket broken down into each of the channels. This is.
218 00:26:36.670 ⇒ 00:26:37.980 Amber Lin: Oh, oh, cool!
219 00:26:38.480 ⇒ 00:26:41.200 Amber Lin: Are we doing Facebook.
220 00:26:41.520 ⇒ 00:26:46.989 Robert Tseng: Yeah, yeah. So we’re doing. That’s that’s the one that we’ve been trying to push out this week. So like, Meta.
221 00:26:46.990 ⇒ 00:26:48.040 Amber Lin: That’s Meta. I see.
222 00:26:48.040 ⇒ 00:26:50.059 Robert Tseng: Yeah, meta, meta Facebook, something. Yeah.
223 00:26:50.060 ⇒ 00:26:57.630 Amber Lin: I see. Okay, I’m I’m gonna get get rid of the other one.
224 00:26:59.210 ⇒ 00:26:59.820 Robert Tseng: Why is it?
225 00:27:00.230 ⇒ 00:27:00.940 Amber Lin: Probably.
226 00:27:03.490 ⇒ 00:27:05.090 Robert Tseng: Was it? Yeah. 4, 84. Yeah.
227 00:27:05.860 ⇒ 00:27:10.280 Amber Lin: Yeah, okay, so this is a duplicate. Actually.
228 00:27:10.280 ⇒ 00:27:10.960 Robert Tseng: Yes.
229 00:27:11.110 ⇒ 00:27:12.300 Amber Lin: Okay. Great.
230 00:27:14.150 ⇒ 00:27:19.260 Robert Tseng: And then, yeah, that’s what I’m doing right after this call. So there.
231 00:27:19.709 ⇒ 00:27:26.719 Robert Tseng: Yeah, we’re done here. So we can. Yeah, we’re just gonna it’s gonna be part of the message that hopefully we’ll we’ll send out to the team.
232 00:27:26.720 ⇒ 00:27:27.370 Amber Lin: Oh!
233 00:27:27.530 ⇒ 00:27:32.460 Robert Tseng: Oh, that’s blocked. Still, I yeah. So
234 00:27:32.650 ⇒ 00:27:38.640 Robert Tseng: we’re not touching that pharmacy forecast. So this is related to the pharmacy project that I was just talking about I mean.
235 00:27:38.640 ⇒ 00:27:39.029 Amber Lin: You can see.
236 00:27:39.030 ⇒ 00:27:43.669 Robert Tseng: See that we’d been trying to do this 7 weeks ago, but.
237 00:27:43.670 ⇒ 00:27:44.640 Amber Lin: As soon as it.
238 00:27:44.640 ⇒ 00:27:45.950 Robert Tseng: Happened. So.
239 00:27:46.910 ⇒ 00:27:47.430 Amber Lin: Right.
240 00:27:47.430 ⇒ 00:27:48.020 Robert Tseng: Yeah.
241 00:27:48.020 ⇒ 00:27:51.039 Amber Lin: So I’m gonna boot boot it to a different cycle.
242 00:27:51.040 ⇒ 00:27:51.400 Robert Tseng: Yeah.
243 00:27:53.350 ⇒ 00:27:56.600 Amber Lin: Map product names still blocked.
244 00:27:57.860 ⇒ 00:28:06.620 Robert Tseng: yeah, we’re still blocked on this because they want us to do something with trustpilot data, and no one gave us access. So it’s just like we’re not gonna really do anything.
245 00:28:13.130 ⇒ 00:28:14.690 Amber Lin: Reimplement.
246 00:28:15.040 ⇒ 00:28:23.516 Robert Tseng: Yeah. So we just talked about. And then the other ones are all gonna hopefully go to Andrew, Hc, team. Yeah, I I
247 00:28:24.020 ⇒ 00:28:29.099 Robert Tseng: when I was on site last week, I I checked in. So we can consider that time.
248 00:28:29.280 ⇒ 00:28:33.250 Amber Lin: Okay, awesome. And then if you, if you have time to ask for the call.
249 00:28:33.250 ⇒ 00:28:36.590 Robert Tseng: Yeah, yeah, yeah, okay, yeah.
250 00:28:36.590 ⇒ 00:28:49.489 Robert Tseng: So I’m I’m basically getting their signatures to sign off on polytomic. They’re gonna start paying for that. They’re gonna sign off on the new segment contract and start paying for that for next year pretty much. And then,
251 00:28:49.920 ⇒ 00:28:55.106 Robert Tseng: yeah, there’s corral data is coming back. So we don’t have to, so that we don’t have to touch
252 00:28:58.070 ⇒ 00:29:03.160 Robert Tseng: Ehc, data. So which I guess probably gave me a lot of his
253 00:29:03.320 ⇒ 00:29:06.770 Robert Tseng: seen the corral product before on the scene, but no one else on the scene had any.
254 00:29:06.770 ⇒ 00:29:08.630 Amber Lin: Hmm, I see.
255 00:29:08.840 ⇒ 00:29:12.470 Amber Lin: Okay. What about yours?
256 00:29:17.120 ⇒ 00:29:23.679 Demilade Agboola: Snapshot for anchor speeds is in production, so that is done.
257 00:29:25.570 ⇒ 00:29:32.639 Annie Yu: Then while they I just send you a message. So I realized that model is actually not static.
258 00:29:32.910 ⇒ 00:29:34.302 Annie Yu: So I’m using
259 00:29:36.770 ⇒ 00:29:40.060 Annie Yu: So yesterday, when I said the snapshot, as of
260 00:29:40.600 ⇒ 00:29:43.759 Annie Yu: July 23, and then order date
261 00:29:45.160 ⇒ 00:29:51.119 Annie Yu: 1st to 15 of July, 1st to 20th of July, and we had
262 00:29:51.710 ⇒ 00:29:55.169 Annie Yu: one row for each product combo.
263 00:29:55.350 ⇒ 00:29:59.599 Annie Yu: But then today, when I look at it, we have
264 00:30:00.740 ⇒ 00:30:05.270 Annie Yu: less rows than yesterday. So that means the
265 00:30:05.810 ⇒ 00:30:09.469 Annie Yu: however, it’s set up. It’s actually not static.
266 00:30:11.280 ⇒ 00:30:18.460 Demilade Agboola: Yeah, it. It would only capture a change. That’s the value from row or the value from column.
267 00:30:18.990 ⇒ 00:30:26.540 Demilade Agboola: So unless a change occurs, the value from would remain be Pre, like
268 00:30:27.240 ⇒ 00:30:29.829 Demilade Agboola: will remain a different date. Basically.
269 00:30:30.690 ⇒ 00:30:31.520 Demilade Agboola: So
270 00:30:32.280 ⇒ 00:30:41.739 Demilade Agboola: if there’s a new role that comes in and there’s a new value that comes in, it would assign the valid from role to be that date. So, for instance, today’s date.
271 00:30:42.000 ⇒ 00:30:45.470 Demilade Agboola: if nothing changes, if the values remain the same.
272 00:30:46.130 ⇒ 00:30:51.520 Demilade Agboola: everything from the previous day doesn’t change. It just remains how it was before.
273 00:30:51.760 ⇒ 00:30:58.660 Demilade Agboola: and the value to continue to remain absent like like null.
274 00:30:59.430 ⇒ 00:31:04.230 Demilade Agboola: And that that means that I think
275 00:31:04.680 ⇒ 00:31:08.400 Demilade Agboola: like what what we’re looking for are the change rights.
276 00:31:11.440 ⇒ 00:31:19.540 Annie Yu: No, I think we want. We want to present how the data looked like on that specific day.
277 00:31:22.720 ⇒ 00:31:26.819 Demilade Agboola: So yeah, so what we, what we will need to do is we’ll need to
278 00:31:27.870 ⇒ 00:31:35.760 Demilade Agboola: if wants to look at how it looks like it’s basically any day between the valid Dvt valid from
279 00:31:37.500 ⇒ 00:31:40.969 Demilade Agboola: the cores of the Dbt valley 2,
280 00:31:43.160 ⇒ 00:31:45.700 Demilade Agboola: and the current dates. So basically
281 00:31:45.850 ⇒ 00:31:52.219 Demilade Agboola: because the value 2 can be null. So it just require less of the DVD values on current date, and that allows us to know
282 00:31:52.460 ⇒ 00:31:54.020 Demilade Agboola: what exactly
283 00:31:54.310 ⇒ 00:32:03.180 Demilade Agboola: it was on that day. So if it falls between that setting region, we know that that was the value that it carried during that day within that range.
284 00:32:06.550 ⇒ 00:32:07.460 Annie Yu: Oh!
285 00:32:07.460 ⇒ 00:32:10.469 Amber Lin: Do you guys need a separate meeting about it today.
286 00:32:11.670 ⇒ 00:32:20.729 Demilade Agboola: Yeah, but also that that’s for that’s for different like snapshot task. To be honest, this snapshot task is for this specificities where I wanted to get the
287 00:32:21.635 ⇒ 00:32:33.959 Demilade Agboola: the unaggregated numbers, so that one I have done so. That allows me to see what’s changing pre aggregation and why the aggregation values. Values are not the same.
288 00:32:36.690 ⇒ 00:32:42.140 Annie Yu: Okay. So this is not for the snapshot version of Roas, Ltv. Dash.
289 00:32:42.920 ⇒ 00:32:47.580 Demilade Agboola: I mean, technically, it is. But like I was trying to explain yesterday
290 00:32:48.530 ⇒ 00:32:57.150 Demilade Agboola: the snapshots I did, for you are high level, rolled up numbers which
291 00:32:57.980 ⇒ 00:33:01.639 Demilade Agboola: that’s great, but like it doesn’t help me debug anything
292 00:33:01.960 ⇒ 00:33:08.399 Demilade Agboola: like if I if the numbers are changing, I don’t know why they’re changing, and if I don’t know why they’re changing. I can’t make any
293 00:33:09.346 ⇒ 00:33:14.749 Demilade Agboola: I can’t make any model to handle those changes. And I keep things static.
294 00:33:15.480 ⇒ 00:33:19.200 Demilade Agboola: So I did 2 different types of snapshots. I did one for you
295 00:33:19.400 ⇒ 00:33:28.250 Demilade Agboola: where you can actually see what’s happening. You can see the rolled up numbers. But I did some for myself, where I created a snapshot of
296 00:33:28.660 ⇒ 00:33:31.309 Demilade Agboola: the pre-aggregated numbers.
297 00:33:31.820 ⇒ 00:33:36.769 Demilade Agboola: So you your numbers roll up and say, maybe 2,000.
298 00:33:37.190 ⇒ 00:33:42.640 Demilade Agboola: My numbers will show the list of the 2,000. And so, if the numbers change from 2,000 to say
299 00:33:43.100 ⇒ 00:33:45.110 Demilade Agboola: 1,900,
300 00:33:45.590 ⇒ 00:33:57.119 Demilade Agboola: I will see which of the night, like what 100 rows vanished, quote unquote, like what 100 rows disappeared. And I’ll figure out what changed in those 100 rows that that’s basically what I did.
301 00:33:57.680 ⇒ 00:34:03.310 Demilade Agboola: It’s the same being quote unquote. But it’s just different, like different ways to go about it.
302 00:34:05.530 ⇒ 00:34:13.369 Annie Yu: Okay. So I guess with that setup I can’t really use that for the snapshot dashboard. That’s why I did.
303 00:34:13.600 ⇒ 00:34:17.399 Annie Yu: Because I thought that was one static row.
304 00:34:18.400 ⇒ 00:34:18.810 Amber Lin: Oh!
305 00:34:18.810 ⇒ 00:34:25.470 Demilade Agboola: But you, once you use the the bits between value
306 00:34:26.260 ⇒ 00:34:30.869 Demilade Agboola: that allows you to know. So what you need is a a date spine.
307 00:34:31.560 ⇒ 00:34:36.160 Amber Lin: Do you mind talking about it? I mean, we are. The meeting has to end.
308 00:34:36.664 ⇒ 00:34:39.810 Amber Lin: Alright, I think you guys will need a separate meeting.
309 00:34:41.360 ⇒ 00:34:42.440 Demilade Agboola: Sounds good.
310 00:34:42.449 ⇒ 00:34:46.282 Amber Lin: Yeah, I tried. Didn’t have time, unfortunately,
311 00:34:47.019 ⇒ 00:34:53.189 Amber Lin: one last minute before we hop any of these. That’s up to date, any of these that you can’t
312 00:34:53.319 ⇒ 00:34:55.539 Amber Lin: complete, and we’ll have to move.
313 00:34:57.698 ⇒ 00:35:08.871 Demilade Agboola: Before you, too. I will look at the the result of the snapshots and discover like that’s part. That’s why I did the snapshots. I’m trying to figure out what’s going on there.
314 00:35:11.550 ⇒ 00:35:12.760 Demilade Agboola: Then
315 00:35:17.390 ⇒ 00:35:20.839 Demilade Agboola: I will close out 3, 6, 3, 6, 6 today as well.
316 00:35:21.110 ⇒ 00:35:22.000 Amber Lin: Okay.
317 00:35:22.000 ⇒ 00:35:22.690 Demilade Agboola: Yeah, okay.
318 00:35:22.980 ⇒ 00:35:28.339 Amber Lin: Probably these you won’t be able to finish, because I know you’re leaving tomorrow.
319 00:35:28.700 ⇒ 00:35:35.650 Demilade Agboola: Yeah, I’ll try to see how far I can push them. But, like I, I don’t necessarily think I’ll be as finished up in clocks models before tomorrow.
320 00:35:35.650 ⇒ 00:35:37.020 Amber Lin: Okay, okay,
321 00:35:38.850 ⇒ 00:35:40.509 Amber Lin: So I will.
322 00:35:42.580 ⇒ 00:35:48.810 Amber Lin: Alright. Yeah. Whatever you can finish, we’ll we’ll do. And then whatever’s left will push over.
323 00:35:55.670 ⇒ 00:35:57.960 Amber Lin: okay, Rebecca confirmed.
324 00:35:58.620 ⇒ 00:36:02.490 Amber Lin: So done.
325 00:36:04.220 ⇒ 00:36:13.799 Amber Lin: Okay, Robert, did you have a chance to review the or someone else’s reviewing the data documentation from Annie.
326 00:36:15.671 ⇒ 00:36:18.179 Robert Tseng: No, I haven’t reviewed it.
327 00:36:18.180 ⇒ 00:36:18.800 Amber Lin: Okay.
328 00:36:18.800 ⇒ 00:36:19.640 Robert Tseng: Let’s wait.
329 00:36:20.910 ⇒ 00:36:22.529 Amber Lin: Okay, sounds good.
330 00:36:22.710 ⇒ 00:36:29.559 Amber Lin: I know the one is working on his documentation today. So maybe after both of them are done, you can review in one, go.
331 00:36:29.780 ⇒ 00:36:31.149 Robert Tseng: Yeah, that’d be ideal.
332 00:36:31.150 ⇒ 00:36:35.220 Amber Lin: Okay. Sounds good. Alright. I have to hop another client.
333 00:36:36.070 ⇒ 00:36:37.599 Robert Tseng: Thank you. Bye.
334 00:36:37.600 ⇒ 00:36:38.840 Demilade Agboola: Thank you. Bye.