Meeting Title: [Eden] Daily Standup Date: 2025-04-30 Meeting participants: Robert Tseng, Demilade Agboola, Annie Yu
WEBVTT
1 00:01:57.840 ⇒ 00:01:58.950 Robert Tseng: Hello! Again.
2 00:02:00.360 ⇒ 00:02:00.960 Demilade Agboola: Hello!
3 00:02:07.210 ⇒ 00:02:08.199 Robert Tseng: Okay.
4 00:02:12.750 ⇒ 00:02:13.420 Annie Yu: Hello!
5 00:02:14.610 ⇒ 00:02:15.519 Robert Tseng: Hey! Annie!
6 00:02:17.260 ⇒ 00:02:18.090 Demilade Agboola: Hi! Annie!
7 00:02:22.480 ⇒ 00:02:24.079 Robert Tseng: How’s everyone doing?
8 00:02:27.320 ⇒ 00:02:28.990 Demilade Agboola: Pretty good. Can’t complain.
9 00:02:31.700 ⇒ 00:02:33.570 Robert Tseng: Are you still? Jet lagged him a lot of.
10 00:02:35.450 ⇒ 00:02:40.749 Demilade Agboola: I mean a bit, but I always had like a messed up sleep cycle. So it’s not. It’s not the worst thing yet.
11 00:02:41.250 ⇒ 00:02:42.000 Robert Tseng: I see.
12 00:02:51.470 ⇒ 00:02:56.080 Robert Tseng: Aye, aye, aye, have a little logins.
13 00:02:56.880 ⇒ 00:03:00.289 Robert Tseng: Alright. I just wanna get this ready so I can pull up what? And you worked on.
14 00:03:04.620 ⇒ 00:03:12.230 Robert Tseng: Okay, alright. Well, I will.
15 00:03:18.340 ⇒ 00:03:25.500 Robert Tseng: Yeah. Let’s just let’s just get into it. Okay, I don’t expect anyone from the Eden side to be joining today. So hopefully.
16 00:03:26.220 ⇒ 00:03:28.559 Robert Tseng: we’ll get to spend a lot of time helping each other out.
17 00:03:28.910 ⇒ 00:03:37.610 Robert Tseng: So yeah, so help club pixel tracking. Still, kind of like in flight, basically kind of like connected
18 00:03:41.550 ⇒ 00:03:46.800 Robert Tseng: connected the Corel with faster than
19 00:03:50.010 ⇒ 00:03:55.870 Robert Tseng: cool, but more or less, this is kind of off our plate. And so I’m gonna move that
20 00:03:58.160 ⇒ 00:04:02.930 Robert Tseng: Yeah, product launch dashboard. We haven’t heard any new feedback correct.
21 00:04:03.420 ⇒ 00:04:07.630 Robert Tseng: So let me just go in and nudge.
22 00:04:25.940 ⇒ 00:04:26.750 Robert Tseng: Oh, gosh!
23 00:04:30.730 ⇒ 00:04:31.710 Robert Tseng: Cool!
24 00:04:32.440 ⇒ 00:04:35.020 Robert Tseng: Didn’t close out by the weekend.
25 00:04:35.780 ⇒ 00:04:38.720 Robert Tseng: You’re back cool.
26 00:04:39.140 ⇒ 00:04:40.030 Robert Tseng: So
27 00:04:44.160 ⇒ 00:04:46.599 Robert Tseng: no, just put her in there.
28 00:04:47.630 ⇒ 00:04:53.760 Robert Tseng: So anything. What I will do is also do.
29 00:04:57.350 ⇒ 00:05:00.739 Robert Tseng: I don’t want to bring any into this?
30 00:05:01.290 ⇒ 00:05:02.390 Robert Tseng: Oh.
31 00:05:06.040 ⇒ 00:05:10.120 Robert Tseng: so damn, then can I rename this?
32 00:05:11.110 ⇒ 00:05:12.830 Robert Tseng: Oh, I cannot.
33 00:05:14.840 ⇒ 00:05:15.690 Robert Tseng: Huh!
34 00:05:17.190 ⇒ 00:05:19.179 Robert Tseng: Thought I, could turn this into a channel.
35 00:05:25.360 ⇒ 00:05:31.530 Robert Tseng: Okay, all that nice product analytics.
36 00:05:35.820 ⇒ 00:05:44.120 Robert Tseng: I don’t know what my channels are called. Okay, whatever. I’ll just call it product analytics
37 00:05:45.570 ⇒ 00:05:48.690 Robert Tseng: and I will.
38 00:05:50.760 ⇒ 00:05:58.500 Robert Tseng: So many channels star is great.
39 00:06:01.700 ⇒ 00:06:06.060 Robert Tseng: Get off. Just say.
40 00:07:14.910 ⇒ 00:07:17.500 Robert Tseng: Okay, cool. Also.
41 00:07:30.600 ⇒ 00:07:36.419 Robert Tseng: Okay, I think this is all valid.
42 00:07:38.700 ⇒ 00:07:39.610 Robert Tseng: Okay.
43 00:07:43.360 ⇒ 00:07:52.940 Robert Tseng: let’s move on to yeah. I mean, there’s a few things here. This is all on me. So nothing there marketing spend side, I mean a waste in here. So I’m not gonna talk about it.
44 00:07:53.200 ⇒ 00:08:01.890 Robert Tseng: Any of the data platform documentation left. If there’s anything remaining, I’ll just tag the demo today. But I think I can pretty much use this.
45 00:08:04.770 ⇒ 00:08:07.439 Robert Tseng: Yeah, I know this is a on the bottleneck there.
46 00:08:08.430 ⇒ 00:08:18.870 Robert Tseng: Okay, so let’s talk about the order status journey thing. I think we can clear that out like this is pretty much done. It’s we have a new issue now, more or less. So
47 00:08:19.060 ⇒ 00:08:21.043 Robert Tseng: let’s just call this
48 00:08:24.856 ⇒ 00:08:27.170 Robert Tseng: added Gpt.
49 00:08:34.320 ⇒ 00:08:36.839 Robert Tseng: Okay, maybe I don’t know where where it is.
50 00:08:37.490 ⇒ 00:08:41.929 Robert Tseng: Forget it. This has.
51 00:08:42.669 ⇒ 00:08:44.540 Robert Tseng: I’m just gonna call this done
52 00:08:49.870 ⇒ 00:08:56.069 Robert Tseng: because we’re basically the investigation has shifted I’ve created another spike instead.
53 00:08:56.280 ⇒ 00:08:57.359 Robert Tseng: That’s done.
54 00:08:58.220 ⇒ 00:08:58.990 Robert Tseng: I.
55 00:09:02.720 ⇒ 00:09:09.780 Demilade Agboola: for the other flow. I don’t know if Annie has looked at the the model I built out in staging
56 00:09:16.800 ⇒ 00:09:20.020 Demilade Agboola: the fact order lifecycle. I believe it’s called.
57 00:09:23.360 ⇒ 00:09:30.029 Demilade Agboola: or is it or do? Were you able to like? Ask, answer all the questions you needed without, or you had without the the model.
58 00:09:32.100 ⇒ 00:09:34.749 Annie Yu: Wait. What can you repeat the question?
59 00:09:35.270 ⇒ 00:09:40.769 Demilade Agboola: So there is a model that I built out called fact, order, lifecycle
60 00:09:41.451 ⇒ 00:09:47.470 Demilade Agboola: and so that is where I combine, like the transactions, information with the orders information.
61 00:09:47.740 ⇒ 00:09:50.560 Demilade Agboola: So I was wondering if you’ve been able to like
62 00:09:51.210 ⇒ 00:09:54.609 Demilade Agboola: see it, use it, or if you had any questions about it.
63 00:09:56.180 ⇒ 00:10:00.270 Annie Yu: I haven’t used, or look into that one.
64 00:10:00.730 ⇒ 00:10:10.970 Annie Yu: Are we supposed to use that one for a dashboard, good or like, for future dashboard?
65 00:10:12.640 ⇒ 00:10:20.559 Demilade Agboola: To be honest, I I believe it’s I don’t know if it’s this, if it’s this dashboard. But I mean we’re trying to figure out like some of the information about this.
66 00:10:20.800 ⇒ 00:10:31.040 Demilade Agboola: So I’ve been able to put like orders and the transactions, and where the Tran, when the transaction happened, and the days from the transaction to
67 00:10:32.416 ⇒ 00:10:35.599 Demilade Agboola: like shipping and to delivery.
68 00:10:36.610 ⇒ 00:10:41.789 Annie Yu: For for this one we use. Order. Summary.
69 00:10:41.790 ⇒ 00:10:43.430 Demilade Agboola: Yeah, I believe you saw the summary.
70 00:10:44.030 ⇒ 00:10:46.319 Demilade Agboola: Yeah, I would like again.
71 00:10:47.150 ⇒ 00:10:53.989 Demilade Agboola: I don’t know if that’s what that’s what I’m asking. If there are any metrics you need that are not available here.
72 00:10:55.540 ⇒ 00:11:01.020 Demilade Agboola: or if this, if this is fine, then we can, like, forget about other summary or other lifecycle.
73 00:11:02.970 ⇒ 00:11:06.939 Robert Tseng: Yeah, no, actually, no. So you’re.
74 00:11:08.230 ⇒ 00:11:17.379 Robert Tseng: how do we describe it? So actually, like, this is really just an order journey dashboard. So like.
75 00:11:17.480 ⇒ 00:11:27.320 Robert Tseng: right. This is from when the order has been completed to when it was delivered, and demalade what you’ve created, it seems here
76 00:11:27.770 ⇒ 00:11:29.619 Robert Tseng: for fact, order, lifecycle.
77 00:11:29.810 ⇒ 00:11:36.009 Robert Tseng: Yes, this is but like this is like, is this trying to trace back to the transaction right.
78 00:11:36.960 ⇒ 00:11:51.320 Demilade Agboola: Yes, this that’s from the transaction. So we have transaction information, and we have order information. And then we have, like deltas from like. Oh! When the transaction was completed to when it was shipped to when it was delivered. All that stuff.
79 00:11:51.640 ⇒ 00:11:53.770 Demilade Agboola: So we have a.
80 00:11:55.270 ⇒ 00:12:00.189 Robert Tseng: So maybe we should even just call this
81 00:12:00.690 ⇒ 00:12:07.290 Robert Tseng: is it? In fact, order. Life cycle is still the right. But I I guess what I’m trying to say is like, I don’t think Andy needs to change
82 00:12:07.790 ⇒ 00:12:21.270 Robert Tseng: the model here, because the scope here is still a little bit more limited than what you’re just like, what we’ve been working on for. If she she doesn’t need the transaction level here.
83 00:12:22.290 ⇒ 00:12:23.430 Demilade Agboola: Okay, that’s fair.
84 00:12:23.610 ⇒ 00:12:24.520 Demilade Agboola: Yeah.
85 00:12:25.180 ⇒ 00:12:30.800 Robert Tseng: The transaction level stuff is important. It’s it’s for like a different view that we haven’t been built out yet. So.
86 00:12:31.470 ⇒ 00:12:38.340 Demilade Agboola: Okay? I mean, if that’s fine, then at least we know we have like gunpowder waiting to be used. So it’s fine, like.
87 00:12:39.860 ⇒ 00:12:44.659 Annie Yu: Okay, but it still sits in the stage. Only right fact, order, lifecycle.
88 00:12:44.660 ⇒ 00:12:57.519 Demilade Agboola: So it’s in staging, because I wanted you to look through it and just have an idea if there’s any other thing you wanted in the model, so I can make that fix, and then, once the fix is done like once that is done, I will push it to prod.
89 00:12:57.930 ⇒ 00:13:08.310 Annie Yu: Got it, got it. And on that note I actually do like I still can’t figure out what’s how to think of transaction or order, transaction, id and order number
90 00:13:08.720 ⇒ 00:13:12.130 Annie Yu: for Eden. What’s kind of their.
91 00:13:12.590 ⇒ 00:13:13.260 Robert Tseng: So.
92 00:13:13.260 ⇒ 00:13:14.453 Demilade Agboola: As well.
93 00:13:15.050 ⇒ 00:13:19.010 Robert Tseng: Yeah, it’s kind of confusing. And we we just learned this yesterday.
94 00:13:19.640 ⇒ 00:13:24.489 Robert Tseng: and we have. It’s not reflected in this model. But basically, you could think of it as like
95 00:13:24.700 ⇒ 00:13:32.419 Robert Tseng: transaction has a 1 to one or one to many relationship with treatment, which is a something we don’t even use right now.
96 00:13:33.930 ⇒ 00:13:41.480 Robert Tseng: or like, maybe I’ll I’ll take. Once we thought it was like a 1 to one or one to many relationship between transaction and order.
97 00:13:42.520 ⇒ 00:14:03.030 Robert Tseng: But it’s actually not because investigated it. And orders like, 30 to 50% orders don’t have transactions. So you can’t actually do a direct connection from transaction to order to get the full like that. That wouldn’t give you every everything that you need. So apparently there’s another intermediary
98 00:14:03.662 ⇒ 00:14:11.530 Robert Tseng: called treatment. And yeah, it’s like a 1-to-one or once transaction to treatment to order. And so we need to build that mapping
99 00:14:12.305 ⇒ 00:14:25.444 Robert Tseng: model. Somehow. It’s it’s like we that’s that. I think that’s what we need to build that we just haven’t. We haven’t done it yet, because we just learned of this treatment like concept yesterday. So,
100 00:14:25.910 ⇒ 00:14:27.900 Robert Tseng: yeah, like, I think that
101 00:14:29.330 ⇒ 00:14:39.659 Robert Tseng: the risk we could talk about the spike. This is kind of relevant. So feel free to read this ticket. If you’re interested, I can share it for those who want to know.
102 00:14:40.570 ⇒ 00:14:42.970 Robert Tseng: Drop it in our channel.
103 00:14:46.890 ⇒ 00:14:48.570 Robert Tseng: He didn’t.
104 00:14:50.700 ⇒ 00:14:51.550 Robert Tseng: They’re not.
105 00:14:51.760 ⇒ 00:14:53.430 Robert Tseng: They’re too big, shallow.
106 00:14:53.905 ⇒ 00:14:54.380 Annie Yu: This.
107 00:14:55.380 ⇒ 00:14:56.829 Robert Tseng: I literally don’t know.
108 00:14:58.990 ⇒ 00:14:59.670 Robert Tseng: Okay?
109 00:15:00.450 ⇒ 00:15:01.799 Robert Tseng: Oh, there, sure.
110 00:15:04.890 ⇒ 00:15:21.610 Robert Tseng: Well, no funky to fix on the transaction 6 min order.
111 00:15:25.797 ⇒ 00:15:39.200 Robert Tseng: Yeah. I mean, this is really in Dave. A lot of hands. I guess I kind of helped you nudge Rob, and Rob may have seen it before. If not, then we have to go figure it out. I’m assuming treatment must come in through one of the web hooks. And then.
112 00:15:39.330 ⇒ 00:15:50.589 Robert Tseng: yeah, we we need to go and create that mapping table so that we can actually assign a transaction. Id to every order. Id right like that, that part of the model makes sense right.
113 00:15:51.060 ⇒ 00:16:08.659 Demilade Agboola: Yeah, yeah, I get that. And that’s also why I hadn’t. Why, the current factor, the life cycle is in staging. Because again, like, when you have 30 to 40% of your models of your like data coming in when you’re unable to join it together. It’s just not a model. You’re confident to push into production.
114 00:16:08.960 ⇒ 00:16:13.010 Demilade Agboola: Yeah. So like being able to figure out like that, like, join from
115 00:16:13.730 ⇒ 00:16:20.070 Demilade Agboola: orders to treatment or transactions. Treatment to orders will be very helpful. So once we tie everything together.
116 00:16:20.190 ⇒ 00:16:29.739 Demilade Agboola: we can then say we have, like a full on view of what happens from when a transaction happens to when an order is shipped and an order is delivered, and you know
117 00:16:29.890 ⇒ 00:16:37.060 Demilade Agboola: and I know, like Josh said, that they don’t necessarily care about delivery that much, but it’s also something we can always have just in case they ever do need it.
118 00:16:37.400 ⇒ 00:16:38.460 Robert Tseng: Yeah, totally.
119 00:16:40.100 ⇒ 00:16:49.309 Robert Tseng: So, yeah, I mean, I guess once that ends up being updated, we may add like something to this table. But like, I I think I think this report itself is great, so
120 00:16:49.410 ⇒ 00:16:58.483 Robert Tseng: I think what would be. I’m assuming that you push all the changes I know, Andy. You left like a comment. Sorry I didn’t actually read the comment. What was it that you asked?
121 00:17:01.490 ⇒ 00:17:04.710 Robert Tseng: missing data ledger relationships.
122 00:17:04.710 ⇒ 00:17:11.119 Annie Yu: Oh, yeah, yesterday I was looking at. We only had data through
123 00:17:11.250 ⇒ 00:17:16.080 Annie Yu: April 13, I think. And I think that was just because
124 00:17:17.060 ⇒ 00:17:22.380 Annie Yu: the blending relationships in tableau. So I’m now using just an independent
125 00:17:22.510 ⇒ 00:17:31.800 Annie Yu: order summary for these ones and then for for the agent level, we still have those blending data sources.
126 00:17:33.340 ⇒ 00:17:42.049 Robert Tseng: Okay, great would you like to kind of record a loom to like?
127 00:17:42.340 ⇒ 00:17:46.970 Robert Tseng: Walk through this dashboard and I’ll I’ll share that with Rebecca.
128 00:17:51.260 ⇒ 00:17:56.610 Annie Yu: Okay, that includes, I guess, this page and the other.
129 00:17:57.700 ⇒ 00:18:00.230 Annie Yu: I guess I didn’t make them 2 pages.
130 00:18:00.970 ⇒ 00:18:03.260 Annie Yu: Well, there’s another one that was.
131 00:18:03.680 ⇒ 00:18:05.270 Robert Tseng: Lovely. This is great. Yeah.
132 00:18:05.270 ⇒ 00:18:08.740 Annie Yu: That was, that was me by Sahana, I think.
133 00:18:09.670 ⇒ 00:18:12.310 Annie Yu: No. The other second halfway.
134 00:18:14.430 ⇒ 00:18:15.139 Robert Tseng: Oh,
135 00:18:15.850 ⇒ 00:18:20.370 Annie Yu: I remember there was another half, and I I put them in another page.
136 00:18:20.737 ⇒ 00:18:24.350 Robert Tseng: I see! I see here!
137 00:18:27.520 ⇒ 00:18:30.030 Annie Yu: Yeah. And I didn’t really touch anything here.
138 00:18:30.510 ⇒ 00:18:31.700 Robert Tseng: That’s fine. Yeah.
139 00:18:34.300 ⇒ 00:18:39.210 Annie Yu: So if I am to record them, should I do
140 00:18:39.560 ⇒ 00:18:42.229 Annie Yu: like 2 pages, or just one.
141 00:18:43.920 ⇒ 00:18:47.940 Robert Tseng: Yeah, you know what I
142 00:18:50.290 ⇒ 00:18:56.729 Robert Tseng: but no want. I want you to. I mean you. You created this. So you you own this. And yeah, I wanna
143 00:18:57.980 ⇒ 00:19:02.348 Robert Tseng: I mean, I may. I may rename this. I think this is really the order.
144 00:19:02.640 ⇒ 00:19:09.869 Demilade Agboola: Also, Ronald question is, this is already customer facing or client facing.
145 00:19:10.200 ⇒ 00:19:11.179 Robert Tseng: Yeah, it is.
146 00:19:11.440 ⇒ 00:19:20.999 Demilade Agboola: Okay, I’m asking, because, like I, I need to update the like. Once things added, I try to update it in the tableau admin sheet, and like the cycles of
147 00:19:21.520 ⇒ 00:19:24.040 Demilade Agboola: refreshes and stuff. So just so anybody can
148 00:19:24.620 ⇒ 00:19:27.430 Demilade Agboola: handle it. If I come out of office, or I’m sick, or something.
149 00:19:27.870 ⇒ 00:19:33.080 Robert Tseng: Okay, cool. Yeah. Well, yeah, I mean, we don’t have to do this immediately. Now, I as well.
150 00:19:34.060 ⇒ 00:19:39.809 Annie Yu: I think if I’m not wrong, this is currently alive. Instead of a extract.
151 00:19:43.280 ⇒ 00:19:47.659 Robert Tseng: One of them is live. Yeah. Oh, I see. The one that you set up is live.
152 00:19:49.138 ⇒ 00:19:54.581 Robert Tseng: Yeah, I would say, you probably would need to change the extract. Oh, man,
153 00:19:55.400 ⇒ 00:19:59.920 Robert Tseng: okay, I know you didn’t. You haven’t published it before, like we have this whole process of like.
154 00:20:00.360 ⇒ 00:20:07.800 Annie Yu: Oh, yeah, I did. I did. Published one for the product drill down.
155 00:20:08.630 ⇒ 00:20:11.789 Robert Tseng: Oh, right is that one also live?
156 00:20:13.358 ⇒ 00:20:17.129 Annie Yu: No, I we if you click into.
157 00:20:21.350 ⇒ 00:20:27.760 Robert Tseng: Those are extracts. Okay? So yeah, they’re live connections to the extract. That’s yeah.
158 00:20:31.405 ⇒ 00:20:42.459 Robert Tseng: Believe that’s right. I can. Also you didn’t. And you use Re, you reused like existing sources here. So I’m assuming that this was just like a you didn’t have to set up anything here.
159 00:20:43.920 ⇒ 00:20:51.089 Annie Yu: Yeah, I publish that order. Summary B, 2. And then I reuse the product sales summary by transaction.
160 00:20:51.500 ⇒ 00:20:58.020 Robert Tseng: Okay, yeah, we have this like little thing where?
161 00:20:59.100 ⇒ 00:21:00.787 Robert Tseng: Aye, aye, aye,
162 00:21:06.070 ⇒ 00:21:10.512 Robert Tseng: she’s trying to get to the published data sources.
163 00:21:13.960 ⇒ 00:21:18.190 Robert Tseng: So okay, you already public, you moved to here. Okay? Great.
164 00:21:18.960 ⇒ 00:21:26.230 Robert Tseng: yeah. So I mean, these are all the ones that I guess Demo Lade has been scheduling to update, right or whatever. So
165 00:21:26.990 ⇒ 00:21:29.809 Robert Tseng: I don’t know why we have duplicates here. But whatever
166 00:21:31.670 ⇒ 00:21:45.260 Robert Tseng: yeah, we have all the published dashboards here. So yeah, it’s like anytime. We have a new data source. That’s live. Yeah, we we publish it here. We make sure that they’re extracts, daily extracts that are set up. And then we set up live connections within the workbook. To those extracts.
167 00:21:48.160 ⇒ 00:21:54.230 Annie Yu: Okay? So one question is, we, do we try to reuse the same one.
168 00:21:54.880 ⇒ 00:21:57.469 Robert Tseng: Yes, if we can, so we don’t.
169 00:21:57.900 ⇒ 00:22:04.269 Annie Yu: I think for me, like the problem would be cause, I think, for different dashboards. We do have
170 00:22:04.770 ⇒ 00:22:10.010 Annie Yu: have like different customized fields, and I don’t like to have
171 00:22:10.580 ⇒ 00:22:15.489 Annie Yu: all other customized fields when I don’t need it for that dashboard. If that makes sense.
172 00:22:16.440 ⇒ 00:22:17.720 Robert Tseng: No, that’s fine.
173 00:22:19.460 ⇒ 00:22:22.731 Robert Tseng: Yeah, no, that that makes sense to me.
174 00:22:25.510 ⇒ 00:22:27.840 Robert Tseng: I’m just trying to see like.
175 00:22:29.910 ⇒ 00:22:33.549 Robert Tseng: well, I know we’re putting like, v, 1 v. 2. Kind of thing.
176 00:22:33.980 ⇒ 00:22:42.000 Robert Tseng: I wonder if there’s like a better way that we could name it when we’re when we’ve adapted some things. It’s like, maybe
177 00:22:43.040 ⇒ 00:22:50.340 Robert Tseng: I don’t know. Order summary for order or like, Okay, maybe for now this is just the best way to do it, like
178 00:22:50.800 ⇒ 00:22:56.759 Robert Tseng: perhaps it doesn’t really matter to have so many data sources be refreshed.
179 00:22:57.330 ⇒ 00:23:04.379 Robert Tseng: I don’t know. I don’t really have much of an opinion on this but I I wonder if that just means every time we create a new dashboard.
180 00:23:05.100 ⇒ 00:23:06.519 Robert Tseng: we end up having a new data.
181 00:23:06.520 ⇒ 00:23:09.300 Annie Yu: Yeah. That’s also my question, too.
182 00:23:09.500 ⇒ 00:23:10.100 Robert Tseng: Yeah.
183 00:23:10.850 ⇒ 00:23:19.300 Demilade Agboola: So unless we’re like building like a building model, specifically for dashboards, which sometimes people do or like. Sometimes it can be done.
184 00:23:20.137 ⇒ 00:23:25.869 Demilade Agboola: If we can create multiple that answers multiple dashboards, it’s usually preferable.
185 00:23:26.511 ⇒ 00:23:37.709 Demilade Agboola: In terms of like, just the workload, the lift and if there’s now a case where we need a data source or like a data model for a specific dashboard that can now be done.
186 00:23:40.030 ⇒ 00:23:46.290 Demilade Agboola: I think. Yeah, I get your frustration in sense of like. It’s sometimes they’re just unnecessary things in there.
187 00:23:46.816 ⇒ 00:23:54.830 Demilade Agboola: But you know as best as possible we’re trying to just answer as many questions as possible with like one data source, or like one data model.
188 00:23:55.340 ⇒ 00:24:06.309 Demilade Agboola: And if we’re able to, if you need a custom like model, then you can let us know like, that’s not a problem. To build one out for you. It’s just like.
189 00:24:08.240 ⇒ 00:24:18.209 Demilade Agboola: if it’s a functional like data that’s unavailable or like a join that is currently not existing like this. Whole transaction orders. Treatment stuff like that doesn’t currently exist.
190 00:24:18.460 ⇒ 00:24:20.170 Demilade Agboola: So we’re creating something to answer that
191 00:24:21.860 ⇒ 00:24:25.770 Demilade Agboola: or, if you need it in a in a different form, I guess we could. We could do that.
192 00:24:25.900 ⇒ 00:24:31.209 Demilade Agboola: I guess the idea is, if we have too many, like, we have too many data models, it becomes hard to maintain
193 00:24:31.650 ⇒ 00:24:46.330 Demilade Agboola: and just figure out like what’s where. And if you, if we need to make a change in one place that change needs to propagate to multiple models. And we need to keep track of all the changes it becomes harder to maintain, I guess is the point I’m trying to say.
194 00:24:48.010 ⇒ 00:24:48.660 Annie Yu: Yeah.
195 00:24:50.870 ⇒ 00:25:03.119 Robert Tseng: Yeah. So, Annie, if it’s kind of like, there’s a lot of extra things that you don’t want to use in there, maybe. Still, just use it, because, like, I don’t think it’s, maybe it just looks a bit messier for you. But like
196 00:25:03.570 ⇒ 00:25:16.439 Robert Tseng: at least we have it. You know, we’re using the same model has everything in there. So maybe that’s like the heuristic issues. For obviously, if there’s something that’s missing, we need a new model for it. Then today we’ll always port point that we should just
197 00:25:17.300 ⇒ 00:25:24.230 Robert Tseng: like, yeah, I don’t. I don’t think we should use duplicate data sources for just like just
198 00:25:26.595 ⇒ 00:25:32.830 Robert Tseng: when you don’t, when you just want to use less data.
199 00:25:33.770 ⇒ 00:25:36.219 Robert Tseng: Am I saying that correctly? Does that make sense.
200 00:25:36.370 ⇒ 00:25:37.380 Annie Yu: Yeah, yeah.
201 00:25:37.380 ⇒ 00:25:37.895 Robert Tseng: Okay.
202 00:25:39.560 ⇒ 00:25:40.335 Robert Tseng: Alright,
203 00:25:41.860 ⇒ 00:25:49.270 Robert Tseng: okay. So that’s that’s fair. We’re good on that. And that makes sense. Seems like you need to update it for one of the dashboards. But okay.
204 00:25:51.860 ⇒ 00:25:53.779 Robert Tseng: yeah, then, if you could, just
205 00:25:54.200 ⇒ 00:26:02.029 Robert Tseng: you know, I want you to own that one. Make sure you move it to the Member experience collection
206 00:26:02.830 ⇒ 00:26:14.629 Robert Tseng: this for the customer journey dashboard, or I’m calling it the order journey dashboard, and so maybe have make sure that that’s reflected because it really isn’t the full customer journey.
207 00:26:15.460 ⇒ 00:26:23.810 Robert Tseng: yeah, it’s really not the full customer journey, because it doesn’t start from the transaction, and it only ends after the 1st order, like, I feel like it’s a bit of a misnomer.
208 00:26:24.610 ⇒ 00:26:31.159 Robert Tseng: A full customer journey would have to include, you know, 1st order first.st
209 00:26:31.300 ⇒ 00:26:46.660 Robert Tseng: You know how many orders like whether or not they’re what what they’re doing in app, that when they update their subscription, there’s like more behavioral stuff that we’re not capturing. So I I do feel like now that I’m looking at it. It’s a it’s kind of this misnomer. We should just call it like that order journey dashboard.
210 00:26:47.130 ⇒ 00:26:48.370 Annie Yu: Yeah, that makes sense.
211 00:26:48.370 ⇒ 00:26:48.920 Robert Tseng: Yeah.
212 00:26:54.810 ⇒ 00:27:10.970 Robert Tseng: okay, cool. So yeah, I mean, if you could do that, you know, get into the right place. And then you could record a walk through kind of talking through the different sessions that you’ve added specifically. And you know it doesn’t have to be anything crazy. I mean, maybe you’re you’re presenting it to
213 00:27:11.010 ⇒ 00:27:26.009 Robert Tseng: like, you know, the head of pharmacy operations, so you know, assume that she doesn’t really know how to use it. She doesn’t really understand, like what metrics they are. So I think she appreciates having this. It would save us having to do a call and like live walkthrough with her. So
214 00:27:26.800 ⇒ 00:27:33.710 Robert Tseng: and also it’ll give you more visibility. And I’ll I’ll be able to share that in the in the channel with them.
215 00:27:34.170 ⇒ 00:27:42.540 Annie Yu: Okay. So just to clarify, I do have to walk through everything in that dashboard. Not just the ones I changed right.
216 00:27:42.900 ⇒ 00:27:50.320 Robert Tseng: Yeah, I think you. I think you should just do it. Just assume that like he hasn’t seen it before, and like, especially since there’s now 2 tabs or something like.
217 00:27:51.750 ⇒ 00:27:57.559 Robert Tseng: Yeah, I think they’re just better to, just, you know. Do it fresh.
218 00:27:58.390 ⇒ 00:27:59.740 Annie Yu: Okay. Okay.
219 00:28:00.300 ⇒ 00:28:07.239 Robert Tseng: Okay, cool. Okay. So couple of other things I wanted to quickly touch on.
220 00:28:07.845 ⇒ 00:28:16.830 Robert Tseng: We already talked about the pipeline for the Embeddables. There’s a couple of things, you know. You’re you’re investigating that you’re also doing the spike here.
221 00:28:18.050 ⇒ 00:28:23.229 Robert Tseng: Yeah, I mean, I need to go catch up on like some of this mixed panel stuff, and then
222 00:28:23.530 ⇒ 00:28:34.939 Robert Tseng: questions here on, like the new product hierarchy. Just because this one is probably, I mean, they’re launching a bunch of new products next week. So just wanna make sure that we’re still
223 00:28:35.760 ⇒ 00:28:40.661 Robert Tseng: clear here. I do think that yeah, these med kits are fixed.
224 00:28:42.203 ⇒ 00:28:49.179 Demilade Agboola: My question now would be, how do we aggregate this across the different variant? Ids?
225 00:28:49.410 ⇒ 00:28:53.750 Demilade Agboola: That would be the question, and especially in terms of like value.
226 00:28:54.700 ⇒ 00:29:00.459 Demilade Agboola: Because we know. Okay, so event. Kit, for instance, maybe goes for 1, 47.
227 00:29:01.140 ⇒ 00:29:09.430 Demilade Agboola: How do we aggregate it across variants like, so make it one. How do you aggregate it across the the 1st variant id, and then the second variant id
228 00:29:10.161 ⇒ 00:29:23.139 Demilade Agboola: because if we’re going to split it. If different ids eventually link back to like, maybe Sema or we go. V. How do we then say so? We go. We had one order with a value of
229 00:29:23.360 ⇒ 00:29:25.149 Demilade Agboola: $40. For instance.
230 00:29:28.240 ⇒ 00:29:29.120 Robert Tseng: Yeah.
231 00:29:30.870 ⇒ 00:29:31.310 Demilade Agboola: Because there’s no.
232 00:29:33.800 ⇒ 00:29:34.630 Robert Tseng: Huh?
233 00:29:37.050 ⇒ 00:29:44.020 Robert Tseng: So basically, you’re trying to like, break out like the cost and pricing from the med kits into the different into the different products.
234 00:29:44.200 ⇒ 00:29:50.979 Demilade Agboola: Yeah, because I mean, that’s I. I believe that’s the idea of us being able to know what the components of each med kit is
235 00:29:51.140 ⇒ 00:29:56.790 Demilade Agboola: so it goes back to attribute it back to the initial products
236 00:29:57.170 ⇒ 00:30:04.040 Demilade Agboola: and say that for this product that was a sale was made yesterday, and it is this value.
237 00:30:07.900 ⇒ 00:30:09.649 Robert Tseng: For bundles, aren’t we? Just.
238 00:30:10.550 ⇒ 00:30:17.639 Demilade Agboola: So for bundles we just usually pick the 1st one that catches. To be fair, we did flag that that’s something we need to probably look into to be honest
239 00:30:20.010 ⇒ 00:30:33.009 Demilade Agboola: But like for this med kit, especially because we’re specifically trying to split it. Now we’re not just going. Oh, a med kit was sold, make it one or make it 2 was sold yesterday. We’re specifically trying to split into the variant ids that constitute that med kit.
240 00:30:34.150 ⇒ 00:30:34.580 Demilade Agboola: Yeah.
241 00:30:35.640 ⇒ 00:30:37.800 Demilade Agboola: So this very id had.
242 00:30:38.020 ⇒ 00:30:46.760 Demilade Agboola: you know, one order, one order for the other variant id, and for this total retail price of 1, 47, maybe 50 was for
243 00:30:47.554 ⇒ 00:30:49.010 Demilade Agboola: it’s very ideal.
244 00:30:49.600 ⇒ 00:30:56.689 Demilade Agboola: 97 goes to variety, too. So we know how much that comes up to in terms of total revenue
245 00:30:56.820 ⇒ 00:30:57.926 Demilade Agboola: for each
246 00:30:58.810 ⇒ 00:31:03.069 Demilade Agboola: products at the end of the day. So when we look at the product snapshots, we have an idea of
247 00:31:03.250 ⇒ 00:31:09.010 Demilade Agboola: what’s you know what’s revenue is, or do we just do? 50 50, but down the middle that way.
248 00:31:09.220 ⇒ 00:31:10.050 Demilade Agboola: like.
249 00:31:12.110 ⇒ 00:31:21.569 Robert Tseng: Yeah, can you? Can, you just like, yeah, you, we’re gonna have to like distill what you’re saying into a question we have to ask. Sd, so maybe I kind of break down
250 00:31:21.710 ⇒ 00:31:31.939 Robert Tseng: what it is we’re doing currently with bundles. We’re just using the 1st products. What you know now with most more than 2 products in these med kits. Like.
251 00:31:32.550 ⇒ 00:31:46.141 Robert Tseng: you know, just kind of bring up the question. Well, like, maybe this only using the 1st product approach doesn’t work anymore. And we need to do something else. And if you have a recommendation like, yeah, just kind of like package that together.
252 00:31:47.440 ⇒ 00:31:53.699 Robert Tseng: I mean, I can help you review the message and send it off, or whatever but like. Then we we I cut her, and Natasha will answer that question.
253 00:31:54.080 ⇒ 00:31:54.920 Demilade Agboola: Yeah, as long as.
254 00:31:54.920 ⇒ 00:31:55.470 Robert Tseng: This is good.
255 00:31:55.470 ⇒ 00:31:59.490 Demilade Agboola: I don’t. I don’t know if you saw it, but I actually asked you yesterday.
256 00:32:00.792 ⇒ 00:32:10.309 Demilade Agboola: I asked Christina that for each med kit. What’s the dollar amount from the total order that gets attributed to each parent? Id. And she hasn’t, responded.
257 00:32:12.740 ⇒ 00:32:13.869 Robert Tseng: I don’t mean she would know
258 00:32:14.190 ⇒ 00:32:17.017 Robert Tseng: she doesn’t make that decision. Yeah, let me let me
259 00:32:17.820 ⇒ 00:32:19.020 Demilade Agboola: This was the.
260 00:32:19.280 ⇒ 00:32:21.169 Robert Tseng: Yeah, yeah, I see. I see. Yeah,
261 00:32:26.760 ⇒ 00:32:29.209 Robert Tseng: yeah, I think we have to.
262 00:32:32.120 ⇒ 00:32:38.060 Robert Tseng: Yeah, she’s not the right person to ask me. We need we need to ask better.
263 00:32:39.230 ⇒ 00:32:39.990 Demilade Agboola: Yeah.
264 00:32:41.980 ⇒ 00:32:42.790 Robert Tseng: Yeah.
265 00:32:53.190 ⇒ 00:32:55.630 Demilade Agboola: Also, I have a meeting right after, so I have to hop.
266 00:32:56.090 ⇒ 00:33:10.999 Robert Tseng: Okay. Yeah. Okay. Well, we’ll we’ll call it here. It seems that we have some follow up to do. But yeah, I think, Annie, you’re you’re pretty clear on. You’re you’re cleared on on today. So I need. I need to bring some more stuff in the cycle for you. But okay.
267 00:33:11.220 ⇒ 00:33:12.629 Robert Tseng: alright. We’ll talk later.
268 00:33:13.850 ⇒ 00:33:14.900 Annie Yu: You, bye.