Meeting Title: Marketing Data Platform Sync Date: 2025-06-30 Meeting participants: Robert Tseng, Awaish Kumar
WEBVTT
1 00:04:20.490 ⇒ 00:04:21.170 Awaish Kumar: Hello!
2 00:04:22.350 ⇒ 00:04:23.209 Robert Tseng: They wish.
3 00:04:25.490 ⇒ 00:04:26.810 Robert Tseng: How’s your weekend.
4 00:04:28.140 ⇒ 00:04:28.990 Awaish Kumar: We’re just doing.
5 00:04:32.200 ⇒ 00:04:32.900 Robert Tseng: Nice.
6 00:04:35.120 ⇒ 00:04:35.929 Awaish Kumar: How about you?
7 00:04:38.000 ⇒ 00:04:48.129 Robert Tseng: It’s good. Tom was here the past few days. So I think we I mean, I’m sure you’ve seen a lot of what we’ve been doing on the other other channels.
8 00:04:50.350 ⇒ 00:04:56.489 Robert Tseng: yeah. So it’s good. Good planning. Just kind of figuring out what you need to do for the next next quarter.
9 00:04:58.420 ⇒ 00:05:03.220 Robert Tseng: yeah, I’m sure we’ll share more in the managers Channel, and like kind of meeting and channel and everything.
10 00:05:03.340 ⇒ 00:05:04.090 Robert Tseng: So.
11 00:05:05.780 ⇒ 00:05:06.380 Awaish Kumar: Okay.
12 00:05:09.560 ⇒ 00:05:17.004 Robert Tseng: Okay, cool. Well, then, we’ll just kind of go into it. We’ll just, I think, since this will be smoother, since it’s just me and you today?
13 00:05:18.360 ⇒ 00:05:20.884 Robert Tseng: so yeah, let me just start here. Think,
14 00:05:21.310 ⇒ 00:05:27.190 Robert Tseng: you know, with the projects you can see, I’ve kind of cut cut down the number of parallel things we’re working on and shifted things around.
15 00:05:28.008 ⇒ 00:05:35.580 Robert Tseng: Biggest change is we have the 2 pilots kicking off this week on the mixed panel segment side. So.
16 00:05:36.302 ⇒ 00:05:41.590 Robert Tseng: yeah, we have. I mean, we keep calling it mixed panel segment implementation. But it’s
17 00:05:41.850 ⇒ 00:05:49.030 Robert Tseng: maybe I should be more precise. It’s actually a Cdp implementation.
18 00:05:50.645 ⇒ 00:06:00.509 Robert Tseng: We’re one, either. We’re we’re in testing, continuing to use segments. And then we’re also running a pilot with router stack. So I’m gonna just
19 00:06:00.640 ⇒ 00:06:02.664 Robert Tseng: yeah. I’m I’m leading that
20 00:06:04.084 ⇒ 00:06:10.465 Robert Tseng: I’ve kind of shared like some of the experience, the the tests that we’re gonna be doing. But
21 00:06:12.040 ⇒ 00:06:16.420 Robert Tseng: yeah, I think that’s I’m I’m I’m gonna own that work stream.
22 00:06:17.060 ⇒ 00:06:19.390 Robert Tseng: And then I think I’ve kind of
23 00:06:19.570 ⇒ 00:06:29.900 Robert Tseng: you know, a couple of things that you kind of lead are, I would say, probably the highest priority. Now I think now that the some of the other things have been deprioritized.
24 00:06:30.130 ⇒ 00:06:33.290 Robert Tseng: the main thing that I want to catch up on
25 00:06:33.847 ⇒ 00:06:46.322 Robert Tseng: the marketing data. Mar, there’s some modeling that is like, not like the customer I/O stuff, and just any anything that’s just kind of loose ends around our marketing data model. I just want us to be like, really, on top of that this week.
26 00:06:47.311 ⇒ 00:06:51.448 Robert Tseng: I think there’s a few outstanding requests.
27 00:06:52.290 ⇒ 00:07:06.369 Robert Tseng: whether it’s this whole Ehc thing that I’m just reading about here, or like other things that Mattesh has been asking for, and his team have been asking for. I’ll try to get really clear on, like what those things are, and I’ll keep trying to push on those. But
28 00:07:07.020 ⇒ 00:07:09.579 Robert Tseng: yeah, I think that’s that’s probably the main thing.
29 00:07:10.205 ⇒ 00:07:15.740 Robert Tseng: I know you’re like talking to Rob right now about getting that app script thing set up.
30 00:07:17.110 ⇒ 00:07:17.790 Awaish Kumar: Like you might.
31 00:07:17.790 ⇒ 00:07:18.470 Robert Tseng: Already.
32 00:07:18.990 ⇒ 00:07:26.410 Awaish Kumar: We might move it to the Dexter, because, like Number one
33 00:07:27.234 ⇒ 00:07:41.460 Awaish Kumar: that, like, if I run it through the timer like, we can easily get running for now. But second thing is what, when I read the script, what it’s actually doing is it’s getting data for 2
34 00:07:41.986 ⇒ 00:07:59.910 Awaish Kumar: sources. It is getting from Apis. And for 2 other sources it is getting data from some sheets that marketing team maintain. And then they rob. Write a script which basically gets loads data in bigquery as well as in the sheet.
35 00:08:00.070 ⇒ 00:08:05.939 Awaish Kumar: So for us, it’s better that we start reading directly from bigquery instead of heats.
36 00:08:07.020 ⇒ 00:08:13.169 Robert Tseng: Yeah, I mean, I agree. I think whatever he built was just a very hacky solution. So as you’re kind of
37 00:08:13.420 ⇒ 00:08:23.339 Robert Tseng: rebuilding it. How you want. I I mean, I trust your decisions on that. So if we want to move to Daxter great, I just think obviously
38 00:08:25.400 ⇒ 00:08:29.600 Robert Tseng: really know how like if you couldn’t kind of
39 00:08:30.160 ⇒ 00:08:34.080 Robert Tseng: just make sure once you’re done, you don’t have to like you don’t have to.
40 00:08:34.520 ⇒ 00:08:47.769 Robert Tseng: I don’t want you to spend too much time on the documentation. I think it’s more important to to get it done. Since then it’s that that sheet has been out of commission for a week, so I know that’s very pressing to them, and I’m sure Josh will call me later today asking me why it hasn’t been done.
41 00:08:48.376 ⇒ 00:09:04.060 Robert Tseng: So I think. Just do what you can, and then let me just help me to understand, like, why the sis, the pro, the system that we built is better than like what was before. I think that always helps me when I’m like communicating what we’re doing.
42 00:09:06.300 ⇒ 00:09:07.020 Awaish Kumar: Okay.
43 00:09:07.240 ⇒ 00:09:08.069 Awaish Kumar: Yep. Sure.
44 00:09:09.220 ⇒ 00:09:16.455 Robert Tseng: Cool. So yeah, I mean, that’s so. I think that’s why I kind of put marketing data work more higher priority.
45 00:09:17.020 ⇒ 00:09:25.320 Robert Tseng: so maybe this isn’t really like marketing data. More, this is really just marketing data platform. Like, I, I don’t know what’s the most precise thing.
46 00:09:27.020 ⇒ 00:09:33.199 Robert Tseng: Yeah, MoD modeling, possible orchestration.
47 00:09:34.100 ⇒ 00:09:36.140 Robert Tseng: Yeah, so.
48 00:09:36.290 ⇒ 00:09:54.329 Robert Tseng: and the other thing which I guess this doesn’t have to be taken on today, it’s just it’s a it’s a bit of a shorter week. And we haven’t checked in with the Emr team in a while, so I’d like to kind of circle back with them. We did say we were going to give them some stuff that I don’t think we ever did
49 00:09:56.146 ⇒ 00:09:59.890 Robert Tseng: if you recall this, we did say we would
50 00:10:00.880 ⇒ 00:10:05.961 Robert Tseng: do that. So I just wanna make sure that we’re back on top of it a bit.
51 00:10:06.260 ⇒ 00:10:08.089 Awaish Kumar: Okay here. Actually, I
52 00:10:08.200 ⇒ 00:10:14.799 Awaish Kumar: had in in my mind. But yeah, last in the last week, also, like we had some other data modeling work
53 00:10:14.940 ⇒ 00:10:25.560 Awaish Kumar: which I have been working on. So I just pushed it. But like basically, the 1st step is to create a notion documents with each table, the schema of existing
54 00:10:25.660 ⇒ 00:10:29.620 Awaish Kumar: data which is coming from bask and then map it
55 00:10:29.810 ⇒ 00:10:33.500 Awaish Kumar: the way we want to get data from Emr, and then.
56 00:10:33.720 ⇒ 00:10:38.820 Awaish Kumar: like shift like the ship. The like new documentation with the Emr team like
57 00:10:38.990 ⇒ 00:10:45.970 Awaish Kumar: this is, we want the data to like, come in into the data platform like in the warehouse or
58 00:10:46.170 ⇒ 00:10:48.400 Awaish Kumar: in the Cgp, like whatever it is.
59 00:10:48.950 ⇒ 00:10:53.112 Robert Tseng: Great. Yeah. I mean, I think that’s that’s I agree that that’s the right approach.
60 00:10:53.720 ⇒ 00:11:03.174 Robert Tseng: yeah, I mean, you’re. I know it’s kind of challenging, working with an external engineering team. But I guess you’re the you’re the you’re the tech. Lead on on this, on this
61 00:11:03.580 ⇒ 00:11:10.879 Robert Tseng: on this client. So yeah, as much as you can be driving the conversation.
62 00:11:11.180 ⇒ 00:11:23.274 Robert Tseng: I can help you with any docs setting up meetings, or whatever like. I think I have a lot of more, maybe comfort doing that. But yeah. And I think that’s kind of how we can partner together on this.
63 00:11:24.200 ⇒ 00:11:33.339 Robert Tseng: because, yeah, basically, whatever you say to them, that’s how they’re gonna build. They’re gonna build according to your roadmap. So you you do have. Yeah, like, you’re you have the
64 00:11:33.680 ⇒ 00:11:37.159 Robert Tseng: you have the authority and the ownership to
65 00:11:37.340 ⇒ 00:11:42.829 Robert Tseng: to kind of steer this, however, you have. However, you choose. So I think.
66 00:11:43.490 ⇒ 00:11:44.270 Robert Tseng: Yeah.
67 00:11:44.400 ⇒ 00:11:50.849 Robert Tseng: make of it what you will. But like, I think that’s that’s that’s kind of the what we have on hand here. So
68 00:11:51.590 ⇒ 00:11:53.260 Robert Tseng: yeah, okay.
69 00:11:54.260 ⇒ 00:12:03.119 Robert Tseng: the other things. So there’s like some strategic finance work that I want to get cleaned up. Now that transactions is ready to go. I want to catch up on some of this. It’s just.
70 00:12:04.530 ⇒ 00:12:10.060 Robert Tseng: I guess Demi Demi is out today. It should be kind of rough, but I think
71 00:12:11.120 ⇒ 00:12:15.329 Robert Tseng: it seems like a big thing has moved forward with
72 00:12:19.740 ⇒ 00:12:22.589 Robert Tseng: looks like treatment. Id is now in
73 00:12:22.750 ⇒ 00:12:26.349 Robert Tseng: like we can now connect treatments to orders, which is pretty big.
74 00:12:27.180 ⇒ 00:12:35.840 Robert Tseng: I think that should unblock us on a few different things. So I need to work with Demi to figure out like what like, what I’m able to actually execute on for for this. Now
75 00:12:36.080 ⇒ 00:12:50.530 Robert Tseng: the things that are top of mind for me, one is like the forecast forecasting demand at the vial size level level I haven’t updated. I haven’t touched that forecast in over a month. So I wanna be able to update that with our new data models.
76 00:12:51.194 ⇒ 00:12:57.159 Robert Tseng: And then I think I’m just gonna have to spend some time with Jonah, the the Cfo and figure out like.
77 00:12:58.232 ⇒ 00:12:59.619 Robert Tseng: okay, well, we
78 00:12:59.950 ⇒ 00:13:05.390 Robert Tseng: planning out how we’re gonna bring stripe data in and like some of this other stuff
79 00:13:06.045 ⇒ 00:13:13.469 Robert Tseng: but nothing is really deliver like it’s not any nothing to deliver this week necessarily on this. This is just like another thing that’s on my mind.
80 00:13:14.020 ⇒ 00:13:17.069 Robert Tseng: So I think with how much
81 00:13:17.980 ⇒ 00:13:20.949 Robert Tseng: bandwidth we have this week, that’s all we can really take on.
82 00:13:21.900 ⇒ 00:13:23.870 Robert Tseng: But yeah, I don’t know. What do you? What do you think.
83 00:13:26.329 ⇒ 00:13:34.389 Awaish Kumar: Yeah, like, that’s like, I, I have a lot a lot on plate on these 2 things like marketing work. And then tmr, is a like
84 00:13:34.550 ⇒ 00:13:37.660 Awaish Kumar: pretty big anyway.
85 00:13:37.940 ⇒ 00:13:44.229 Awaish Kumar: So yeah, I I can easily work on this list in this week.
86 00:13:44.920 ⇒ 00:13:46.053 Robert Tseng: Okay. Great.
87 00:13:47.040 ⇒ 00:13:52.150 Awaish Kumar: Yeah, like, we have a product sales summary which needs to be refactored.
88 00:13:52.150 ⇒ 00:13:54.150 Robert Tseng: Yeah, you were doing some refactoring. There.
89 00:13:54.790 ⇒ 00:13:58.409 Awaish Kumar: Yeah, like, I haven’t done it. I will see if like.
90 00:13:58.580 ⇒ 00:14:01.169 Awaish Kumar: I can like. It’s not right
91 00:14:01.380 ⇒ 00:14:05.529 Awaish Kumar: priority, like, if I’m after the emr documentation like,
92 00:14:07.530 ⇒ 00:14:10.699 Awaish Kumar: if I get some time I I will just refactor it.
93 00:14:10.700 ⇒ 00:14:15.829 Robert Tseng: Yeah, I would just consider that tech deck cleanup. So yeah, as far as priority is probably lower, the priority.
94 00:14:16.470 ⇒ 00:14:17.010 Awaish Kumar: Hmm.
95 00:14:19.990 ⇒ 00:14:28.959 Robert Tseng: Okay, cool? Well, I guess with the remaining time, if we would just go in and just kind of talk through anything that we can move off of this, that this would help me start to do this later.
96 00:14:30.960 ⇒ 00:14:33.339 Robert Tseng: Yeah. Regarding the customer, I/O stuff.
97 00:14:35.780 ⇒ 00:14:44.760 Robert Tseng: I think I have what I need. I think Demote already sent me. I was like looking at this right before I got on this call. Seems like this is a request. I’ll just make sure I’ll try to close that out.
98 00:14:45.481 ⇒ 00:14:47.489 Robert Tseng: Don’t worry on that one
99 00:14:47.690 ⇒ 00:14:55.510 Robert Tseng: with Annie’s like thing. Here, product, journey dashboard. I’m just gonna close this out. This is done.
100 00:14:56.020 ⇒ 00:15:00.640 Robert Tseng: Okay, profits. Own bar chart.
101 00:15:15.190 ⇒ 00:15:17.400 Robert Tseng: yeah, I think this is more.
102 00:15:20.450 ⇒ 00:15:26.429 Robert Tseng: See, we even have a ticket.by dot one.
103 00:15:38.010 ⇒ 00:15:41.903 Robert Tseng: So I think there’s something in here about
104 00:15:55.600 ⇒ 00:15:57.409 Robert Tseng: yeah, it’s really this one.
105 00:16:00.370 ⇒ 00:16:03.660 Robert Tseng: This one still needs to be done by Demi when he’s when he’s back.
106 00:16:04.400 ⇒ 00:16:08.240 Robert Tseng: Okay? Well, then, in that case I think this one for now is also.
107 00:16:08.760 ⇒ 00:16:13.910 Awaish Kumar: Like there was one ticket about product mapping sheet. Like, we have some duplicates
108 00:16:14.170 ⇒ 00:16:19.889 Awaish Kumar: for same variant. We have multiple codes, and it was assigned to. I mean I can’t.
109 00:16:20.190 ⇒ 00:16:23.580 Awaish Kumar: Is there still there, or, for instance.
110 00:16:26.194 ⇒ 00:16:28.189 Robert Tseng: The duplicate issue.
111 00:16:29.010 ⇒ 00:16:32.250 Robert Tseng: I think it was done.
112 00:16:36.250 ⇒ 00:16:42.790 Awaish Kumar: Okay, I will check like. But I was seeing like in the last week I saw some duplicates.
113 00:16:43.550 ⇒ 00:16:45.250 Robert Tseng: We’re talking about this right?
114 00:16:46.050 ⇒ 00:16:47.040 Awaish Kumar: Which one like.
115 00:16:48.630 ⇒ 00:16:50.609 Robert Tseng: Are you seeing my screen so like
116 00:16:50.880 ⇒ 00:16:58.640 Robert Tseng: order, refund, summary, discount, like there were duplicates in the refunds per order.
117 00:16:58.960 ⇒ 00:17:05.519 Awaish Kumar: No, no, no, so product mapping sheet, which basically duplicates our
118 00:17:05.940 ⇒ 00:17:15.349 Awaish Kumar: orders data, in fact, transaction. So like, we have order data, we have order number and a variant id for a product when I join it with a
119 00:17:16.048 ⇒ 00:17:20.230 Awaish Kumar: product mapping sheet like there should be one variant
120 00:17:20.868 ⇒ 00:17:29.629 Awaish Kumar: id, and and and related like cogs for that product. Variant right? But instead, we have multiple, like
121 00:17:29.750 ⇒ 00:17:36.430 Awaish Kumar: variant id one, it will have 2 rows with different cogs in the product mapping sheet.
122 00:17:36.880 ⇒ 00:17:39.479 Awaish Kumar: Google Sheet, which is maintained by the Eden team.
123 00:17:40.110 ⇒ 00:17:41.060 Robert Tseng: Oh, right!
124 00:17:41.220 ⇒ 00:17:54.009 Awaish Kumar: Yeah, that basically, 1st of all, duplicating our data. Secondly, we can deduplicate. But the problem is, they have multiple cogs as well. So we don’t know which one is. The like correct cogs value.
125 00:17:54.550 ⇒ 00:17:55.210 Awaish Kumar: Again.
126 00:17:57.610 ⇒ 00:17:58.320 Robert Tseng: Yeah.
127 00:18:03.190 ⇒ 00:18:05.910 Robert Tseng: I mean by default, we’ve just been using the 1st one.
128 00:18:06.280 ⇒ 00:18:06.770 Robert Tseng: Alright.
129 00:18:09.300 ⇒ 00:18:10.399 Awaish Kumar: Yes, yes.
130 00:18:17.240 ⇒ 00:18:18.730 Robert Tseng: I mean, I don’t think
131 00:18:19.460 ⇒ 00:18:30.839 Robert Tseng: so that yeah, I mean that that definitely impacts our margin reporting. I guess it’s not the most pressing thing, so I can wait till the Lotte comes back to handle that. But okay, thanks for reminding me of that one.
132 00:18:33.480 ⇒ 00:18:38.839 Awaish Kumar: Yeah, like, it basically duplicates some of our revenue data.
133 00:18:39.020 ⇒ 00:18:39.560 Awaish Kumar: I agree.
134 00:18:39.560 ⇒ 00:18:41.910 Robert Tseng: Oh, okay, duplicates our revenue data, too.
135 00:18:42.390 ⇒ 00:18:43.540 Awaish Kumar: Yeah, yeah, I like this
136 00:18:43.650 ⇒ 00:18:53.070 Awaish Kumar: for sale for order. If we get 2 different variants, if we join it, it is basically creating duplicate rows for same order. Id.
137 00:18:53.310 ⇒ 00:18:57.770 Awaish Kumar: Hence, if I, if I, without deduplicating, if I sum revenue.
138 00:18:57.890 ⇒ 00:19:07.300 Awaish Kumar: it is going to increase it. But it is not like that it will be like 3 to 5,000. Something like that. The difference?
139 00:19:07.400 ⇒ 00:19:10.770 Awaish Kumar: Not that big, but still it is going to duplicate.
140 00:19:11.700 ⇒ 00:19:14.370 Robert Tseng: Yeah, okay, yeah, we should definitely handle that.
141 00:19:16.228 ⇒ 00:19:21.130 Robert Tseng: Okay, I’ll try to fill that out with more details after this this call. When I get the notes.
142 00:19:22.030 ⇒ 00:19:26.550 Robert Tseng: Okay, cool. So I’m just trying to like, clear up some other things.
143 00:19:27.630 ⇒ 00:19:29.150 Robert Tseng: So
144 00:19:34.330 ⇒ 00:19:35.730 Robert Tseng: this is
145 00:19:40.130 ⇒ 00:19:41.250 Robert Tseng: done.
146 00:19:43.020 ⇒ 00:19:45.811 Robert Tseng: Other things that we’re waiting for on bask
147 00:19:47.000 ⇒ 00:19:51.210 Robert Tseng: We were going to ask them for
148 00:19:54.480 ⇒ 00:19:59.840 Robert Tseng: right, spike I to us.
149 00:20:01.400 ⇒ 00:20:07.229 Robert Tseng: They’re gonna give that to us. But okay, not on this one.
150 00:20:08.380 ⇒ 00:20:14.030 Robert Tseng: Yeah, demo. They needed to finish this one. So this is still on him to finish
151 00:20:28.660 ⇒ 00:20:30.760 Robert Tseng: panel data sources.
152 00:20:30.950 ⇒ 00:20:39.280 Robert Tseng: I think this is done for now, like we. Are, you already fixed all the stuff in in the modeling. And I look, I remember looking at the dashboard. So it looks fine.
153 00:20:41.570 ⇒ 00:20:43.590 Robert Tseng: so no action necessary there.
154 00:20:44.800 ⇒ 00:20:47.470 Robert Tseng: Tracking plan stuff.
155 00:20:49.070 ⇒ 00:20:55.800 Robert Tseng: I mean, I’m just going to example.
156 00:21:00.137 ⇒ 00:21:01.780 Robert Tseng: There were some
157 00:21:03.040 ⇒ 00:21:08.780 Robert Tseng: issues with this, not a priority for me to be honest. So I’m not gonna touch it this week.
158 00:21:11.063 ⇒ 00:21:13.889 Robert Tseng: What else can we clear out of here?
159 00:21:15.260 ⇒ 00:21:17.580 Robert Tseng: The amortization thing?
160 00:21:30.180 ⇒ 00:21:31.740 Robert Tseng: Yeah, I just need to ask.
161 00:21:31.940 ⇒ 00:21:36.440 Robert Tseng: Zack asked for that. I’m gonna send that message after this call.
162 00:21:37.180 ⇒ 00:21:39.750 Robert Tseng: Member categorization.
163 00:21:42.900 ⇒ 00:21:49.749 Robert Tseng: I think de Mulante already dealt with this. So
164 00:21:51.080 ⇒ 00:21:53.200 Robert Tseng: think we can clear this out.
165 00:22:21.450 ⇒ 00:22:22.250 Robert Tseng: Whoa.
166 00:22:35.980 ⇒ 00:22:41.469 Robert Tseng: and not very easy pasting stuff. The linear.
167 00:22:57.780 ⇒ 00:22:58.490 Robert Tseng: Yeah.
168 00:22:58.840 ⇒ 00:23:08.940 Robert Tseng: Okay. Well, I don’t have to hold you here for now, I mean, is there anything else that’s like kind of relevant to you on here that you wanna kind of talk about. Otherwise I can just keep. I’ll just keep grooming this on my own.
169 00:23:09.430 ⇒ 00:23:11.720 Awaish Kumar: Okay, yeah, there’s nothing else.
170 00:23:11.930 ⇒ 00:23:12.640 Awaish Kumar: Okay?
171 00:23:12.640 ⇒ 00:23:13.440 Robert Tseng: Cool.
172 00:23:14.140 ⇒ 00:23:14.550 Awaish Kumar: Right.
173 00:23:14.550 ⇒ 00:23:16.950 Robert Tseng: Alright. Well, yeah, talk to you later.
174 00:23:17.570 ⇒ 00:23:18.080 Robert Tseng: Okay.