Meeting Title: Brainforge x Eden Mixpanel Project Sync Date: 2025-11-06 Meeting participants: Robert Tseng, Henry Zhao
WEBVTT
1 00:00:50.990 ⇒ 00:00:52.280 Henry Zhao: Hey, Robert, how’s it going?
2 00:00:52.930 ⇒ 00:00:53.610 Robert Tseng: Hey.
3 00:00:53.890 ⇒ 00:00:55.010 Robert Tseng: Good, how are you?
4 00:00:55.010 ⇒ 00:00:57.239 Henry Zhao: Good, thanks.
5 00:00:57.400 ⇒ 00:01:00.960 Henry Zhao: I guess you can go first, like, whatever you want to talk about, and then I can go last.
6 00:01:01.730 ⇒ 00:01:04.940 Robert Tseng: I didn’t prepare for this, so I don’t have anything.
7 00:01:05.440 ⇒ 00:01:08.070 Henry Zhao: Okay, were you able to look at the Mixpanel,
8 00:01:08.450 ⇒ 00:01:10.100 Henry Zhao: Project plan that I put together.
9 00:01:10.280 ⇒ 00:01:13.009 Robert Tseng: Not yet. Can you walk me through it?
10 00:01:13.180 ⇒ 00:01:13.930 Henry Zhao: Yeah.
11 00:01:14.650 ⇒ 00:01:16.040 Henry Zhao: It’s pretty straightforward.
12 00:01:16.040 ⇒ 00:01:16.650 Robert Tseng: Okay.
13 00:01:17.690 ⇒ 00:01:19.050 Henry Zhao: Let me… where’d I…
14 00:01:24.040 ⇒ 00:01:26.089 Henry Zhao: Da-da-da, where is it?
15 00:01:26.970 ⇒ 00:01:32.590 Robert Tseng: I have it pulled up, but, yeah, it’s in our, in our DMs, like, I have, I saw it there.
16 00:01:33.610 ⇒ 00:01:34.240 Henry Zhao: Okay.
17 00:01:35.140 ⇒ 00:01:38.370 Henry Zhao: We’ll do a VX panel first, I guess, and then attribution.
18 00:01:38.370 ⇒ 00:01:39.170 Robert Tseng: Okay.
19 00:01:40.350 ⇒ 00:01:47.849 Henry Zhao: Okay, so… Mixed panel rollout plan. Basically, I don’t want to go through all of this, like, with you right now, because there’s a lot of stuff here.
20 00:01:48.460 ⇒ 00:01:51.090 Robert Tseng: Sure. But basically, do you know what Danny V does?
21 00:01:51.910 ⇒ 00:01:57.600 Robert Tseng: Yeah, he’s the Webflow designer, or Webflow engineer, or whatever, their front… their front-end engineer.
22 00:01:58.410 ⇒ 00:02:07.549 Henry Zhao: Okay, so I’m just basically following UTAM’s, project, template, so all of this is just the template. Yeah. It has the stakeholders, the Mixpanel project.
23 00:02:07.870 ⇒ 00:02:18.639 Henry Zhao: Basically, we want to implement Mixpanel as a central behavior analytics tool, we want to have event instrumentation, we want to look at funnels, right? We want to look at the intake as a funnel to see where people are dropping off.
24 00:02:19.020 ⇒ 00:02:29.060 Henry Zhao: We want to then validate it with UTMs, we want to look at patient lifecycle, and then for Judd, we want to look at email campaign conversions. So I’m still sending in email clicks.
25 00:02:29.350 ⇒ 00:02:34.100 Henry Zhao: Because I want to look at, by email, like, how are they converting? And are they coming back?
26 00:02:35.230 ⇒ 00:02:45.189 Henry Zhao: And then out of scope, I don’t know… this was from your notes with ELT, so I don’t know if this is something you guys talked about, but did you guys want to look at credit card error tracking, and is that possible in Mixpanel?
27 00:02:45.710 ⇒ 00:02:48.660 Robert Tseng: Well, we don’t… we haven’t hooked up.
28 00:02:48.900 ⇒ 00:02:56.170 Robert Tseng: like, Stripe data into there, like, I… I don’t really… I think it’s…
29 00:02:58.400 ⇒ 00:03:04.630 Robert Tseng: there’s probably some easy things… I wouldn’t use mixed panel for that, you don’t really need it.
30 00:03:04.860 ⇒ 00:03:08.049 Henry Zhao: Okay, I’ll put it as out of scope, then. Yeah. Even though that was in the notes, right?
31 00:03:08.370 ⇒ 00:03:08.960 Robert Tseng: Yeah.
32 00:03:09.550 ⇒ 00:03:13.820 Henry Zhao: Okay, so then we want more than 3 active users by week 4 as the sex metric.
33 00:03:14.030 ⇒ 00:03:17.240 Henry Zhao: And we want, like, probably most of the events to be covered.
34 00:03:17.430 ⇒ 00:03:22.389 Henry Zhao: And then funnel optimization dashboard live by end of year.
35 00:03:22.730 ⇒ 00:03:23.360 Robert Tseng: Yeah.
36 00:03:24.800 ⇒ 00:03:33.719 Henry Zhao: Okay, so marketing, I guess, should own the reporting and exploration, and they should report biweekly to ELT, so we want to train marketing to be able to do that.
37 00:03:33.720 ⇒ 00:03:34.680 Robert Tseng: Yeah.
38 00:03:34.830 ⇒ 00:03:39.780 Henry Zhao: And then, I guess, either Engineering or Brainforge should maintain the event tracking and add new requested events.
39 00:03:39.950 ⇒ 00:03:45.560 Henry Zhao: And then the exec should review conversion outcomes and check out the ROI impact.
40 00:03:45.930 ⇒ 00:03:46.580 Robert Tseng: Yeah.
41 00:03:47.710 ⇒ 00:03:51.820 Henry Zhao: So this is all pretty self-explanatory, like, just the business problem.
42 00:03:51.950 ⇒ 00:03:55.910 Henry Zhao: This one I might get rid of, because we’re not going to do that.
43 00:03:56.080 ⇒ 00:03:58.610 Robert Tseng: In Mixpanel…
44 00:03:58.850 ⇒ 00:04:00.639 Henry Zhao: This is all kind of just the same.
45 00:04:01.290 ⇒ 00:04:01.950 Robert Tseng: Yeah.
46 00:04:02.850 ⇒ 00:04:13.840 Henry Zhao: But basically, the big thing is training is, like, none given, so we want to train two additional users on Mixpanel. I think Ryan already uses it, and Danny already knows how to use it, so we want to use Ryan as a resource to kind of help with the training.
47 00:04:14.290 ⇒ 00:04:15.840 Henry Zhao: And then…
48 00:04:15.840 ⇒ 00:04:20.960 Robert Tseng: So you saw Danny, when you looked at Nixpanel usage, so that’s kind of why you threw him in there? Yeah. Okay.
49 00:04:21.149 ⇒ 00:04:27.539 Henry Zhao: And when we did the, like, reconciliation… we did the conversion, analysis last week, he seems to know how to use it.
50 00:04:27.609 ⇒ 00:04:30.209 Robert Tseng: Yeah. So, but you can also participate in the training.
51 00:04:32.199 ⇒ 00:04:38.229 Henry Zhao: And then session replay and heat maps was something that Adam wanted, but that’s gonna be one of the open questions that you’ll see later.
52 00:04:38.590 ⇒ 00:04:39.270 Robert Tseng: Yeah.
53 00:04:40.420 ⇒ 00:04:44.030 Henry Zhao: So these are the open questions, right? Who owns taxonomy enforcement?
54 00:04:44.910 ⇒ 00:04:52.139 Henry Zhao: what retention horizon do we have for raw event data? Should we add edge layer data to Mixpanel, or just keep it as the attribution data we have now?
55 00:04:52.350 ⇒ 00:04:58.470 Henry Zhao: For Adam, what do we want to achieve with session replays and heat maps? So if he mentions this in the next meeting, just let me know.
56 00:04:58.640 ⇒ 00:05:04.009 Henry Zhao: What events are missing from Mixpanel that can bring additional insights to marketing? So far, we don’t have any events that are missing.
57 00:05:04.190 ⇒ 00:05:07.029 Henry Zhao: If we’re not gonna do credit card in MixedPanel.
58 00:05:07.540 ⇒ 00:05:11.290 Henry Zhao: And then, should we also analyze pharmacy performance and SLAs using Mixpanel?
59 00:05:13.720 ⇒ 00:05:19.890 Robert Tseng: I would say no, like, they’re not really… it’s not really at a, like, customer level, right? So…
60 00:05:22.060 ⇒ 00:05:28.100 Robert Tseng: We’re looking at order level, so that’s… that’s not… we don’t really want order level stuff coming into Nixpanel.
61 00:05:28.760 ⇒ 00:05:31.500 Henry Zhao: Okay, but there is, like, shipping stuff in Mixpanel, right?
62 00:05:32.680 ⇒ 00:05:35.980 Robert Tseng: Oh, well, I mean, there was, but I don’t…
63 00:05:37.210 ⇒ 00:05:39.030 Robert Tseng: I don’t think we’re still looking at it.
64 00:05:39.990 ⇒ 00:05:46.249 Henry Zhao: Okay, so… Do we really care, then, about this stuff? Like, Shippo…
65 00:05:46.860 ⇒ 00:05:48.840 Henry Zhao: Package update, like, this kind of stuff.
66 00:05:49.540 ⇒ 00:05:55.319 Robert Tseng: I mean, this is all helpful for, like, returns, refunds, like, under… yeah, SLA reporting, but if we’re all gonna…
67 00:05:56.960 ⇒ 00:05:58.530 Robert Tseng: I…
68 00:06:01.020 ⇒ 00:06:07.920 Robert Tseng: I mean, I personally have never seen any company be using MixedPanel or Amplitude for, kind of, fulfillment, or, like.
69 00:06:08.740 ⇒ 00:06:13.200 Robert Tseng: Yeah, like, reporting, so… Okay. I mean, I don’t really think it’s that important.
70 00:06:13.200 ⇒ 00:06:24.499 Henry Zhao: that in the pharmacy visit part of this call. Sure. Basically, then the target architecture design, so segment pixel goes to Mixpanel, then we look at behavioral events, goes to funnels and dashboards, and then marketing CRO uses it.
71 00:06:24.920 ⇒ 00:06:28.040 Henry Zhao: This stuff is just kind of explaining how things work.
72 00:06:29.320 ⇒ 00:06:35.880 Henry Zhao: Then, like, key metrics… Naming conventions…
73 00:06:38.120 ⇒ 00:06:40.349 Henry Zhao: I don’t think this is stuff we need to go over…
74 00:06:44.680 ⇒ 00:06:51.089 Henry Zhao: Decision log… so training will be owned by Brainforge. This one, I’m gonna also get rid of.
75 00:06:52.330 ⇒ 00:07:00.279 Henry Zhao: Credit card error tracking… And the photo tracking should be… more… Marketing.
76 00:07:05.060 ⇒ 00:07:06.000 Henry Zhao: Okay?
77 00:07:06.960 ⇒ 00:07:21.240 Henry Zhao: And then, this was the… my implementation plan that I had, so week one, which is us now, is evaluating this plan, which is what we’re doing right now. Next week, event taxonomy and GTM instrumentation, if somebody needs the run’s help on that. Verify events firing as expected.
78 00:07:21.240 ⇒ 00:07:32.660 Robert Tseng: if we’re gonna be pushing edge layer data, which I feel like we should. If we’re gonna, like, do attribution, like, we shouldn’t just… we shouldn’t have… like, it should… it should match, like, what our best capability, so…
79 00:07:32.660 ⇒ 00:07:37.229 Henry Zhao: Ugh, okay, alright. But also GTM for session replays, I think we need it.
80 00:07:38.580 ⇒ 00:07:39.420 Robert Tseng: Yeah, I see.
81 00:07:39.510 ⇒ 00:07:43.289 Henry Zhao: Yeah, this might be more than one week. I don’t know if Zoran can do it that quickly.
82 00:07:44.090 ⇒ 00:07:53.530 Henry Zhao: But then week 3, additional dashboards built, considering that’s done, training for Eden. Week 4, more training sessions. I want to give, like, 3 sessions so that people can have, if they have conflicts, can attend.
83 00:07:53.640 ⇒ 00:07:54.839 Henry Zhao: the correct session.
84 00:07:55.170 ⇒ 00:07:57.059 Henry Zhao: This one I’ll get rid of…
85 00:07:58.610 ⇒ 00:08:03.839 Henry Zhao: And then, after week 5 and beyond, we want to just kind of, like, verify adoption.
86 00:08:04.190 ⇒ 00:08:07.530 Henry Zhao: And make sure people are using it, and have, like, maybe office hours.
87 00:08:08.230 ⇒ 00:08:09.690 Henry Zhao: For peop- for questions.
88 00:08:12.610 ⇒ 00:08:16.530 Robert Tseng: Yeah, I mean, I think on the session replay stuff,
89 00:08:16.780 ⇒ 00:08:25.299 Robert Tseng: Yeah, we can enable it and, like, help people use it, but I mean, even without it being there, we could still be doing the reporting.
90 00:08:25.300 ⇒ 00:08:29.770 Henry Zhao: I just want to know what Adam wants to achieve, so we can make a decision on whether we want to do it or not.
91 00:08:30.510 ⇒ 00:08:35.039 Robert Tseng: He… I don’t think he knows, I think he just thinks that it’s, like…
92 00:08:35.179 ⇒ 00:08:45.110 Robert Tseng: people should know what to do with it. Like, he just thinks it’s a… which is true, like, I think, like, the best product analytics, like, feature is not so much, like.
93 00:08:45.750 ⇒ 00:08:57.110 Robert Tseng: Turning everything into quantitative, like, funnel reports, but just sometimes just watching what your users are doing, and, like, that gives you, you know, some… some signal on, like.
94 00:08:57.110 ⇒ 00:08:57.680 Henry Zhao: Okay.
95 00:08:57.680 ⇒ 00:08:59.370 Robert Tseng: Where they’re getting stuck.
96 00:09:01.840 ⇒ 00:09:06.260 Henry Zhao: I think we can roll this out maybe later on in the road, because right now we’ve removed ID, we’ll have some…
97 00:09:06.360 ⇒ 00:09:11.039 Henry Zhao: like, data to look at there, and then session replays, I think, can, like, complement that data.
98 00:09:11.560 ⇒ 00:09:12.260 Robert Tseng: Sure.
99 00:09:12.520 ⇒ 00:09:13.170 Henry Zhao: Yeah.
100 00:09:13.480 ⇒ 00:09:19.580 Henry Zhao: Okay, so if you agree with that, the rest is, like, kind of pretty much the same thing, you can look through it.
101 00:09:22.470 ⇒ 00:09:26.060 Henry Zhao: And then this is our design review, 11.6 today.
102 00:09:26.300 ⇒ 00:09:28.690 Henry Zhao: And then we can kind of go live next week.
103 00:09:29.400 ⇒ 00:09:30.560 Henry Zhao: If it looks good to you.
104 00:09:31.450 ⇒ 00:09:32.150 Robert Tseng: Okay.
105 00:09:34.000 ⇒ 00:09:47.110 Henry Zhao: Okay, next thing, just real quick, because the pharmacy visit is later today, just want to make sure, like… so one question I have is, all this stuff is in Pharmedica, right? Should I be asking for Rebecca, for access to Pharmedica? And, like, I don’t want to…
106 00:09:47.110 ⇒ 00:09:54.639 Henry Zhao: make the same mistake with, like, MongoDB from REME, like, if she asks if I’ve used Pharmetic before, like, what do I say? Like, what’s the best way to say…
107 00:09:56.080 ⇒ 00:10:00.849 Henry Zhao: like, respond to that, if I should get access, and, like, what my experience is with Fermetica.
108 00:10:01.860 ⇒ 00:10:10.690 Robert Tseng: Well, I mean, you can just say you’ve used other things like Vermetica. I mean, none of us have used Vermetica before, like, they are…
109 00:10:11.540 ⇒ 00:10:29.890 Robert Tseng: Like, I mean, this is just, like, a random niche software, like, I don’t think it’s just gonna expect you to know how to use it. But, I mean, it’s, like, it’s… it’s a… it’s a… it’s basically, like, a warehouse management system, but specifically performance. I don’t… I don’t… I don’t know what I don’t know, like, I… I don’t… I don’t think any of us have used it, so…
110 00:10:29.890 ⇒ 00:10:31.799 Henry Zhao: Okay. But I should get access to it, right?
111 00:10:31.800 ⇒ 00:10:32.170 Robert Tseng: Shit.
112 00:10:32.170 ⇒ 00:10:33.289 Henry Zhao: Look at the operational…
113 00:10:33.610 ⇒ 00:10:34.190 Robert Tseng: Yeah.
114 00:10:35.500 ⇒ 00:10:37.649 Henry Zhao: Okay, and basically, this is kind of the…
115 00:10:37.770 ⇒ 00:10:41.699 Henry Zhao: I’ve added the questions to this doc… do you have this document? Oh yeah, you do, you made it.
116 00:10:41.980 ⇒ 00:10:57.039 Henry Zhao: But I had an initial scoping call with Rebecca and Pete, who’s in the pharmacy. These are kind of the questions that they want to ask. So right now, Rebecca looks at a lot of stuff from Formatica in, like, a Google extension, right? It’s built by Josh, who isn’t there anymore. Do you know who Josh was?
117 00:10:57.640 ⇒ 00:11:00.950 Robert Tseng: No, it’s probably, like, the old…
118 00:11:01.070 ⇒ 00:11:06.930 Robert Tseng: He’s not even part of Eden, he’s probably part of, like… because they bought… they bought this pharmacy.
119 00:11:07.230 ⇒ 00:11:09.809 Robert Tseng: So whoever was the tech guy at that pharmacy.
120 00:11:10.230 ⇒ 00:11:14.969 Henry Zhao: So, is the point of today’s visit just to improve this pharmacy, or, like, all the pharmacies overall from Eden?
121 00:11:15.290 ⇒ 00:11:21.949 Robert Tseng: I mean, this one is probably most important for them, because this is the one that they control. Like, Eden owns this pharmacy, so…
122 00:11:22.970 ⇒ 00:11:27.750 Robert Tseng: You’re not going to be able to get the same level of data with any of the other pharmacies.
123 00:11:28.250 ⇒ 00:11:31.069 Robert Tseng: Because they’re not owned by Eden.
124 00:11:31.220 ⇒ 00:11:35.110 Henry Zhao: Do you have an idea of right now how the orders get routed to, like, which pharmacy?
125 00:11:35.480 ⇒ 00:11:38.669 Robert Tseng: Well, this one is… eventually, they want this to be, like…
126 00:11:38.670 ⇒ 00:11:39.210 Henry Zhao: all of them.
127 00:11:39.350 ⇒ 00:11:42.469 Robert Tseng: most of their orders. Right now.
128 00:11:42.650 ⇒ 00:11:47.219 Robert Tseng: I forgot what the number was, but last I checked, it’s something like…
129 00:11:49.220 ⇒ 00:11:57.069 Robert Tseng: Eden had their own pharmacy network, they had a few, obviously, like, things kind of burned with a couple of them, so that’s why they went and bought this pharmacy.
130 00:11:57.100 ⇒ 00:12:02.470 Robert Tseng: But that was handling, like, 50% of their orders. The other 50% is… you can just…
131 00:12:02.470 ⇒ 00:12:18.070 Robert Tseng: you… BAS will just… will just, has their own network as well, and so they just rely on BASS to do it. But they charge, like, a pretty fat premium on top of it. So, that’s why they’re trying to basically take themselves off of BASC’s pharmacy network.
132 00:12:18.070 ⇒ 00:12:21.260 Robert Tseng: So that they can fulfill it themselves with this… with this pharmacy.
133 00:12:22.030 ⇒ 00:12:29.289 Henry Zhao: Okay, so basically what they want is, like, real-time monitoring, so, like, is anyone overwhelmed? Who’s caught up? Like, is there… what’s the turnaround time?
134 00:12:29.290 ⇒ 00:12:42.749 Henry Zhao: And they wanted to create a micro-integration with Pharmetica, so I don’t know how to do that. Should I today just kind of gather the requirements, and then be… and then ask for, like, Brainforge help to just figure out, like, what kind of software we should use to get this stuff done?
135 00:12:42.920 ⇒ 00:12:55.170 Robert Tseng: Yeah, yeah, I mean, we have, Surf, who would probably be the one to help, architect that. So, if you have questions, you can ask him,
136 00:12:55.490 ⇒ 00:12:59.890 Robert Tseng: I mean, I don’t know when you’re meeting with him, but he might be able to give you some discovery questions.
137 00:13:00.440 ⇒ 00:13:13.419 Henry Zhao: Okay. Yeah, because I just need something that integrates with Pharmetica, right? Like, so I don’t know if that’s, like, an API, or if there’s some software that I need. But basically, like, the data that we need is pretty, pretty standard, right? Rxcount, fill is processed, Christmas is shipped.
138 00:13:14.310 ⇒ 00:13:20.620 Henry Zhao: And then we want to know, like, revenue per subscriber, prescribing habits, org pay, etc, yeah.
139 00:13:20.620 ⇒ 00:13:26.039 Robert Tseng: Revenue data, I don’t know if that will come out of here. Like, I’m expecting this to just be the…
140 00:13:26.400 ⇒ 00:13:28.630 Robert Tseng: operations stuff.
141 00:13:28.630 ⇒ 00:13:29.020 Henry Zhao: Okay.
142 00:13:30.090 ⇒ 00:13:39.590 Robert Tseng: Yeah, looking at it, it’s just shipping, it’s just messaging… Messaging, shipping…
143 00:13:39.830 ⇒ 00:13:40.919 Robert Tseng: I guess they do have a.
144 00:13:40.920 ⇒ 00:13:43.170 Henry Zhao: What do you mean by messaging? What do you mean by messaging?
145 00:13:43.170 ⇒ 00:13:44.700 Robert Tseng: patient messaging.
146 00:13:45.100 ⇒ 00:13:46.140 Henry Zhao: Patient messaging?
147 00:13:46.690 ⇒ 00:13:47.380 Robert Tseng: Yeah.
148 00:13:47.900 ⇒ 00:13:50.889 Henry Zhao: Like, your order’s ready, your order’s in process, whatever.
149 00:13:51.140 ⇒ 00:14:02.260 Robert Tseng: Well, that’s what… I don’t know what modules they’re using, so… but on their… on the Pharmedica website, they have all these modules listed there. I don’t know how much of it is being used, like, they have…
150 00:14:02.700 ⇒ 00:14:05.580 Robert Tseng: Yeah, like, I think you should figure that out, yeah.
151 00:14:05.580 ⇒ 00:14:09.690 Henry Zhao: Okay. Anything else that I should just keep in mind today for the visit?
152 00:14:12.190 ⇒ 00:14:31.899 Robert Tseng: Oh, yeah, I mean, I think just having a vision for, like, what the SLAs should be, and, like, then you’re kind of just trying to make sure that you can get access to the data to build that out. Also helpful to know, like, how much of Pharmatica they’re actually using. Like, I think you should be familiar with the modules. You shouldn’t…
153 00:14:32.160 ⇒ 00:14:38.989 Robert Tseng: Yeah, at this point, you shouldn’t be like, oh, I have no idea about anything with Pharmatic. Like, you could click around and figure some of this out.
154 00:14:39.310 ⇒ 00:14:39.900 Henry Zhao: Yep.
155 00:14:39.900 ⇒ 00:14:40.510 Robert Tseng: Yeah.
156 00:14:41.000 ⇒ 00:14:41.760 Henry Zhao: Okay.
157 00:14:42.160 ⇒ 00:14:43.389 Henry Zhao: Anything else?
158 00:14:45.030 ⇒ 00:14:47.080 Robert Tseng: No, I think that’s… that’s… that’s it.
159 00:14:47.970 ⇒ 00:14:57.959 Henry Zhao: Okay, this one… this one you just wanted me to see, like, if we have these… any of these columns could be useful in customer-enriched profiles that we don’t have right now, right?
160 00:14:58.280 ⇒ 00:15:12.170 Robert Tseng: Yeah, I think this is, like, I’m doing a segment, like, audit for another client right now, and I was like, huh, this is a lot more built out than what we had for Eden. I mean, we have, like, our… we basically moved the customer profiles into the warehouse, and so…
161 00:15:12.570 ⇒ 00:15:14.350 Robert Tseng: I was just curious, like.
162 00:15:15.240 ⇒ 00:15:21.370 Robert Tseng: Is there anything we can learn from this? Or if it’s just like, no, what we have is better?
163 00:15:21.620 ⇒ 00:15:22.430 Henry Zhao: Okay.
164 00:15:23.940 ⇒ 00:15:40.659 Henry Zhao: Cool. And then the last thing is attribution, so I just wanted to give you a quick update. So, attribution is still not done, because I need some additional columns from Zoran. Basically, the stitching was supposed to be very easy, because there’s a user ID that’s in common from segment data and Webflow data.
165 00:15:40.660 ⇒ 00:15:48.120 Henry Zhao: and, I mean, BASC data, but when… so Iran implemented the edge layer, he replaced that ID with the edge layer data.
166 00:15:48.120 ⇒ 00:15:48.930 Robert Tseng: So that basically…
167 00:15:48.930 ⇒ 00:15:51.340 Henry Zhao: Yeah, so that basically broke the join.
168 00:15:51.860 ⇒ 00:15:58.719 Henry Zhao: So I either am gonna have to have him, like, add it back, or… like, he already did it to Webflow Identifies.
169 00:15:59.010 ⇒ 00:16:00.420 Henry Zhao: Which is fine.
170 00:16:00.740 ⇒ 00:16:01.790 Henry Zhao: But
171 00:16:02.260 ⇒ 00:16:15.340 Henry Zhao: I realized an issue, right? So, basically what we did was, in identifies from segments, we added two columns. One is the BASC user ID, and one is the Edge user ID, but this is only available as of November,
172 00:16:15.820 ⇒ 00:16:18.749 Henry Zhao: 7-0… October 31st, which is when he added it.
173 00:16:18.980 ⇒ 00:16:24.069 Henry Zhao: So I don’t have anything retroactively, so we need to act on this really quickly.
174 00:16:24.310 ⇒ 00:16:32.340 Henry Zhao: But I also need it in pages instead of just identifies, because if I’m already logged in, and I go to a…
175 00:16:34.410 ⇒ 00:16:40.480 Henry Zhao: PLG intake, like, with some intake form, right? If I’m already logged in,
176 00:16:41.770 ⇒ 00:16:45.280 Henry Zhao: Only page loads is fired, identifies doesn’t re-fire.
177 00:16:46.210 ⇒ 00:16:47.710 Robert Tseng: Yeah, you’re already logged in, yeah.
178 00:16:47.710 ⇒ 00:16:52.650 Henry Zhao: So I want to capture the people that… if I want a true last click, I need to capture these page loadeds.
179 00:16:52.650 ⇒ 00:16:53.849 Robert Tseng: Huh.
180 00:16:54.320 ⇒ 00:16:58.090 Henry Zhao: And you can see here, like, the UTM persists, so that’s fine.
181 00:16:58.230 ⇒ 00:17:00.320 Henry Zhao: But yeah, basically…
182 00:17:00.590 ⇒ 00:17:06.899 Henry Zhao: That’s the last remaining piece, otherwise my query’s done, I just need to replace the joins once Iran fixes that for me, and then I can make.
183 00:17:06.900 ⇒ 00:17:07.530 Robert Tseng: How are you gonna back?
184 00:17:07.530 ⇒ 00:17:09.249 Henry Zhao: model. What’s that?
185 00:17:09.250 ⇒ 00:17:10.920 Robert Tseng: How are you gonna be able to backfill?
186 00:17:11.300 ⇒ 00:17:12.619 Henry Zhao: I’m not gonna be able to backfill.
187 00:17:13.490 ⇒ 00:17:14.640 Robert Tseng: Okay, so…
188 00:17:14.640 ⇒ 00:17:17.639 Henry Zhao: Anything before November, we’re gonna use the BASC UTM data.
189 00:17:18.030 ⇒ 00:17:19.040 Henry Zhao: Essentially.
190 00:17:21.810 ⇒ 00:17:25.490 Robert Tseng: Well… I guess that gives us a clear, like.
191 00:17:26.030 ⇒ 00:17:29.969 Robert Tseng: we got better. I hope it got better after… after that.
192 00:17:30.540 ⇒ 00:17:35.830 Henry Zhao: Yeah, and they’ll also need to know that, like, anything after November, the true first touch might not be true.
193 00:17:36.070 ⇒ 00:17:36.770 Henry Zhao: Whoa…
194 00:17:36.770 ⇒ 00:17:37.450 Robert Tseng: Chem.
195 00:17:37.450 ⇒ 00:17:42.249 Henry Zhao: I’ll have the first touch timestamp, so we’ll be able to filter out, like, anything that’s before November.
196 00:17:43.520 ⇒ 00:17:44.250 Robert Tseng: Okay.
197 00:17:44.690 ⇒ 00:17:45.070 Henry Zhao: Does that make sense.
198 00:17:45.070 ⇒ 00:17:50.479 Robert Tseng: Well, I mean, it’s definitely on us to measure, like, did it actually get better? I think at this point, nobody really knows, so…
199 00:17:50.650 ⇒ 00:17:54.539 Henry Zhao: So we won’t know until, like, maybe a few weeks down the road, but I’ll make sure that Eden knows that.
200 00:17:54.540 ⇒ 00:17:54.890 Robert Tseng: Okay.
201 00:17:54.890 ⇒ 00:18:00.049 Henry Zhao: Just wanted to give you a heads up, because when we make the deck, and when you present to ELT next week, you’ll have the context.
202 00:18:00.380 ⇒ 00:18:16.870 Robert Tseng: Great. Yeah, I mean, like, when we get there, and we’re able to share, kind of, something like you did for MixedPanel, it’s like, hey, we saved your money, and, like, that’s… that’s what ELT will care about. They’ll be like, cool, that sounds like we did better. So, that’s all… those are… those are the wins that we want to report on. Yeah.
203 00:18:16.940 ⇒ 00:18:23.969 Henry Zhao: And I try to make my email update, like, really quick and to the point, like, I don’t need to be too worried about, like, $6,000 a month or whatever.
204 00:18:24.150 ⇒ 00:18:25.090 Robert Tseng: Yeah, yeah, yeah.
205 00:18:25.270 ⇒ 00:18:25.900 Henry Zhao: Okay, cool.
206 00:18:25.900 ⇒ 00:18:30.029 Robert Tseng: So… Alright, I hope this… I hope this actually turns out well.
207 00:18:30.030 ⇒ 00:18:35.579 Henry Zhao: It will. I’m gonna talk to Zaron now to hear his concerns from the stand-up of why this is not that easy.
208 00:18:35.890 ⇒ 00:18:36.650 Robert Tseng: Alright.
209 00:18:36.650 ⇒ 00:18:37.480 Henry Zhao: Okay. Cool. Thank you.
210 00:18:37.480 ⇒ 00:18:38.670 Robert Tseng: Alright, thanks, Henry.
211 00:18:39.020 ⇒ 00:18:39.740 Henry Zhao: Soon. Bye.