Meeting Title: BASC Attribution Stitching Debugging Date: 2025-11-06 Meeting participants: Henry Zhao, Zoran Selinger
WEBVTT
1 00:01:49.460 ⇒ 00:01:50.490 Zoran Selinger: Hi, Henry.
2 00:01:52.870 ⇒ 00:01:55.270 Henry Zhao: Can you hear me? Yeah. Hey, how are you?
3 00:01:55.980 ⇒ 00:01:58.429 Zoran Selinger: Yeah, good, good.
4 00:01:58.640 ⇒ 00:01:59.190 Henry Zhao: Good.
5 00:02:01.990 ⇒ 00:02:04.480 Henry Zhao: Okay, I’ll be quick. So here’s the issues around.
6 00:02:04.680 ⇒ 00:02:08.320 Henry Zhao: I’m trying to stitch together, right, the entire intake journey.
7 00:02:08.600 ⇒ 00:02:13.199 Henry Zhao: So I’m doing a test where I have UTM source equals Henry test identifies, okay?
8 00:02:14.310 ⇒ 00:02:15.530 Henry Zhao: So… Cool.
9 00:02:15.650 ⇒ 00:02:27.440 Henry Zhao: We added, we added this BASC user ID and edge user ID to webflow.identifies, which works fine. The problem is, I need it on the pages table also, because…
10 00:02:27.640 ⇒ 00:02:31.539 Henry Zhao: if I access this page, like, without having to log in.
11 00:02:31.840 ⇒ 00:02:35.580 Henry Zhao: Then, only page loaded fires and not identifies.
12 00:02:37.410 ⇒ 00:02:38.150 Henry Zhao: So, I’m…
13 00:02:38.150 ⇒ 00:02:41.460 Zoran Selinger: Yes, we removed the identify.
14 00:02:41.460 ⇒ 00:02:42.440 Henry Zhao: goal.
15 00:02:42.620 ⇒ 00:02:50.759 Zoran Selinger: in GTM, from every page. We only do it on the, on the order completed.
16 00:02:51.470 ⇒ 00:02:59.430 Zoran Selinger: At the moment. You know that that was… that was interfering with, with, Mixpanel.
17 00:02:59.900 ⇒ 00:03:01.670 Zoran Selinger: So we reverted that.
18 00:03:02.080 ⇒ 00:03:05.390 Henry Zhao: So, are we firing segment order completed when the order’s completed?
19 00:03:07.560 ⇒ 00:03:09.340 Zoran Selinger: Let me check…
20 00:03:10.690 ⇒ 00:03:14.310 Henry Zhao: Because if we have that, then I can stitch it together, probably.
21 00:03:15.180 ⇒ 00:03:16.339 Zoran Selinger: Let me check…
22 00:03:31.960 ⇒ 00:03:40.619 Henry Zhao: Because basically, when my completed order, right now, I’m only getting his page loaded, I need something that fires into Webflow table that has the edge layer ID, right?
23 00:03:40.620 ⇒ 00:03:44.449 Zoran Selinger: We are firing order completed.
24 00:03:45.960 ⇒ 00:03:47.480 Zoran Selinger: Two segments, yes.
25 00:03:50.360 ⇒ 00:03:51.860 Henry Zhao: Alright.
26 00:03:51.860 ⇒ 00:04:00.589 Zoran Selinger: one has… Does it have anything? Yeah, it doesn’t have any identifiers apart from the transaction ID, you know.
27 00:04:00.590 ⇒ 00:04:03.069 Henry Zhao: Alright, let’s test it. Okay, so…
28 00:04:03.550 ⇒ 00:04:11.940 Henry Zhao: Is it going into user ID? Let’s, let’s try it. Webflow.ordercompleted.
29 00:04:12.760 ⇒ 00:04:20.550 Zoran Selinger: So, is what… what does web flow mean? Is that where the segment table, segment data, ends up in?
30 00:04:22.089 ⇒ 00:04:22.749 Henry Zhao: Yes.
31 00:04:25.589 ⇒ 00:04:28.769 Henry Zhao: Webflow order completed. Yeah, this is a Webflow from segment.
32 00:04:29.340 ⇒ 00:04:30.220 Zoran Selinger: context.
33 00:04:30.760 ⇒ 00:04:32.420 Henry Zhao: Context campaign source.
34 00:04:38.600 ⇒ 00:04:41.159 Henry Zhao: Yeah, it’s not. So that’s the issue, right? So…
35 00:04:41.500 ⇒ 00:04:44.029 Henry Zhao: Order completed are not going into this table.
36 00:04:46.210 ⇒ 00:04:49.450 Henry Zhao: So I can’t use order completed. And I’ve put that in this, like, doc.
37 00:04:49.590 ⇒ 00:04:55.740 Henry Zhao: like, I can’t… do not use Webflow order completed, because it’s not, like, and does not…
38 00:04:56.130 ⇒ 00:04:58.249 Henry Zhao: Have all order completed data.
39 00:05:07.020 ⇒ 00:05:09.150 Zoran Selinger: Okay…
40 00:05:10.360 ⇒ 00:05:18.200 Henry Zhao: So… Why can’t the edge layer ID be the BASC user ID? Why do we need.
41 00:05:18.200 ⇒ 00:05:20.899 Zoran Selinger: I mean, that doesn’t exist on the edge.
42 00:05:22.910 ⇒ 00:05:23.550 Henry Zhao: Yeah.
43 00:05:24.020 ⇒ 00:05:25.180 Zoran Selinger: Yeah, so…
44 00:05:25.180 ⇒ 00:05:27.559 Henry Zhao: It does exist, can it be replaced with the mask user ID?
45 00:05:27.940 ⇒ 00:05:39.199 Zoran Selinger: Do you understand what Edge is? Yes. I just want to be perfectly clear there. So they still haven’t loaded the page yet, they just sent a request, and we are just jumping in
46 00:05:39.340 ⇒ 00:05:44.740 Zoran Selinger: Especially, obviously, our original table is just
47 00:05:44.740 ⇒ 00:06:01.210 Zoran Selinger: That can literally be a person that never arrived at our site before, and this is literally their first page view. So, yeah, we don’t have any of those identifiers at that point in time. Only what we create and, you know, PIIs.
48 00:06:01.210 ⇒ 00:06:04.379 Zoran Selinger: Like… Ip and stuff like that.
49 00:06:04.590 ⇒ 00:06:15.830 Zoran Selinger: We don’t have anything else at that point. We are very limited in that, but that… the data that is there is 100% correct. That’s… that’s the benefit, right?
50 00:06:17.070 ⇒ 00:06:23.949 Henry Zhao: Okay, so how can we add the edge layer… can we add… so is it possible to add the edge layer ID to page loaded?
51 00:06:24.340 ⇒ 00:06:25.340 Henry Zhao: Pages?
52 00:06:27.220 ⇒ 00:06:32.910 Zoran Selinger: Mmm… Let me see what we have… yeah, yeah, so they…
53 00:06:33.800 ⇒ 00:06:41.979 Zoran Selinger: Segment best, page viewed. Oh, no, that’s… that’s a post. So, let me see what they have. Add to cart…
54 00:06:42.630 ⇒ 00:06:50.240 Zoran Selinger: We can… maybe… Segment page event. Custom desk screen view.
55 00:06:50.830 ⇒ 00:06:52.819 Zoran Selinger: That’s what I see from the…
56 00:06:57.320 ⇒ 00:07:00.460 Zoran Selinger: analytics.page requests.
57 00:07:02.440 ⇒ 00:07:03.689 Henry Zhao: That should end up here, man.
58 00:07:03.690 ⇒ 00:07:04.060 Zoran Selinger: Right?
59 00:07:04.060 ⇒ 00:07:13.840 Henry Zhao: Yeah, this is coming from, I think, webflow plus BaskWeb… Should be feeding into… BigQuery as pages.
60 00:07:14.210 ⇒ 00:07:15.309 Henry Zhao: That’s what I believe.
61 00:07:18.710 ⇒ 00:07:23.640 Zoran Selinger: So there is a… Do you have a question?
62 00:07:23.770 ⇒ 00:07:25.110 Zoran Selinger: fielded there.
63 00:07:25.400 ⇒ 00:07:30.130 Zoran Selinger: This is what I see. Question and answer, what I see in the tag.
64 00:07:30.130 ⇒ 00:07:32.810 Henry Zhao: But how did you add edge layer ID to the identifies call?
65 00:07:35.430 ⇒ 00:07:37.089 Zoran Selinger: A true cookie.
66 00:07:39.490 ⇒ 00:07:42.050 Henry Zhao: Okay, so can you use the cookie also to add it to pages?
67 00:07:43.470 ⇒ 00:07:53.680 Zoran Selinger: I can edit two pages, but I just need to make sure what that… to make sure I understand what that means. So, for the page call…
68 00:07:54.020 ⇒ 00:07:55.670 Henry Zhao: Yeah, any of these…
69 00:07:56.120 ⇒ 00:08:01.409 Zoran Selinger: Hmm… So, let me see what we have. Segment snippet…
70 00:08:01.610 ⇒ 00:08:05.510 Zoran Selinger: It’s gonna fire on every consent update.
71 00:08:06.160 ⇒ 00:08:11.089 Zoran Selinger: Okay… So this is their… their snippet.
72 00:08:13.440 ⇒ 00:08:17.019 Zoran Selinger: Analytics load, and then we have analytics page.
73 00:08:17.370 ⇒ 00:08:19.370 Henry Zhao: If I send…
74 00:08:19.880 ⇒ 00:08:30.329 Zoran Selinger: an identify call here. You remember that we were… I was doing an identify call on every session start, and that was interfering with your mix panel.
75 00:08:30.500 ⇒ 00:08:31.170 Henry Zhao: Right.
76 00:08:33.919 ⇒ 00:08:37.219 Zoran Selinger: So, now you’re asking me to do… do that again.
77 00:08:38.340 ⇒ 00:08:43.540 Henry Zhao: Hmm… No, I’m asking you to do what you did with the edge layer ID added to identifies.
78 00:08:44.070 ⇒ 00:08:49.910 Henry Zhao: Remember, you took away the identifies call, but somehow you were able to add edge layer ID and BASC user ID to the identifies table.
79 00:08:49.910 ⇒ 00:08:53.489 Zoran Selinger: Yeah, let me, let me check. So, our custom… so…
80 00:08:53.660 ⇒ 00:08:56.769 Zoran Selinger: Custom sign-up is, yeah, it’s using the.
81 00:08:56.770 ⇒ 00:08:57.160 Henry Zhao: I’m gonna share?
82 00:08:57.160 ⇒ 00:08:57.950 Zoran Selinger: bank?
83 00:08:58.000 ⇒ 00:08:59.379 Henry Zhao: So I can see what you’re talking.
84 00:08:59.380 ⇒ 00:09:00.220 Zoran Selinger: Yeah.
85 00:09:12.710 ⇒ 00:09:18.619 Zoran Selinger: Okay, so… So this is what’s happening on our sign-up.
86 00:09:20.520 ⇒ 00:09:22.639 Zoran Selinger: We have our user ID.
87 00:09:23.110 ⇒ 00:09:27.100 Zoran Selinger: from the Basque, and we have our… Edge user ID.
88 00:09:27.440 ⇒ 00:09:32.980 Zoran Selinger: So, we won’t have the Basque user ID available to us
89 00:09:33.190 ⇒ 00:09:37.280 Zoran Selinger: on every page load. Only… only on Busk.
90 00:09:39.660 ⇒ 00:09:42.319 Henry Zhao: Yeah, I don’t need it, I just need the cookie ID on every page load.
91 00:09:44.440 ⇒ 00:09:46.150 Zoran Selinger: You need the cookie ID.
92 00:09:46.280 ⇒ 00:09:46.910 Henry Zhao: Yeah.
93 00:09:47.740 ⇒ 00:09:55.370 Zoran Selinger: That’s what we’ve done before. Let me show you, let me show you, let me… Just make sure,
94 00:10:01.560 ⇒ 00:10:03.510 Zoran Selinger: Custom identify…
95 00:10:03.510 ⇒ 00:10:08.509 Henry Zhao: While you’re doing that, let me double-check my query, just to make sure that that would work. So, I don’t want to talk about it if it’s not even gonna work.
96 00:10:08.700 ⇒ 00:10:11.220 Henry Zhao: Alright, any Basque user ID with lethagism?
97 00:10:43.410 ⇒ 00:10:47.609 Henry Zhao: Or is BASC able to send the Edge user ID when an order is completed?
98 00:10:51.400 ⇒ 00:10:52.030 Henry Zhao: Like, are we able.
99 00:10:52.030 ⇒ 00:10:56.839 Zoran Selinger: I mean, that’s… we are doing that. We are doing that. Let me… let me show you. We are doing that.
100 00:10:57.450 ⇒ 00:11:01.569 Zoran Selinger: Where am I? Okay, cool, yeah.
101 00:11:06.010 ⇒ 00:11:08.430 Zoran Selinger: At least, what custom identified.
102 00:11:08.730 ⇒ 00:11:10.670 Zoran Selinger: This is what we’re doing.
103 00:11:11.090 ⇒ 00:11:12.709 Zoran Selinger: We are sending both.
104 00:11:12.920 ⇒ 00:11:15.740 Zoran Selinger: The… we are sending both.
105 00:11:18.780 ⇒ 00:11:22.030 Zoran Selinger: On the order completed, we are sending both.
106 00:11:22.280 ⇒ 00:11:32.249 Zoran Selinger: I want to show you this. So, we were initially sending the identifying session start. Can you hear the noise? Can you hear my kids through my…
107 00:11:32.480 ⇒ 00:11:33.399 Henry Zhao: No, I can’t.
108 00:11:33.630 ⇒ 00:11:42.959 Zoran Selinger: Okay, good. Noise reduction is working really well. So, I was, doing the identify call.
109 00:11:43.870 ⇒ 00:11:52.179 Zoran Selinger: whenever we have… when there’s a session start, and we have our edge user ID, I was putting it into this identify call.
110 00:11:52.390 ⇒ 00:11:56.560 Zoran Selinger: I wonder… And that was interfering
111 00:11:56.840 ⇒ 00:12:00.379 Zoran Selinger: with your mix panel. That’s what we concluded, right?
112 00:12:01.340 ⇒ 00:12:04.390 Zoran Selinger: I wonder if I can leave this empty.
113 00:12:05.230 ⇒ 00:12:09.709 Zoran Selinger: and do the edge user ID as one of the traits.
114 00:12:09.750 ⇒ 00:12:15.910 Henry Zhao: No, I think it’s the user ID, I think it’s the user ID. I think it’s the edgy ID that was ruining Mixpanel, not the user ID.
115 00:12:19.330 ⇒ 00:12:26.590 Zoran Selinger: Yes, yes. So what we did, we reverted, let me show you, we reverted back to…
116 00:12:34.390 ⇒ 00:12:38.100 Zoran Selinger: So the identifier will get the BASC ID,
117 00:12:38.330 ⇒ 00:12:42.040 Zoran Selinger: And the… and the edge user ID will be in the trades.
118 00:12:44.130 ⇒ 00:12:45.000 Zoran Selinger: Okay.
119 00:12:45.160 ⇒ 00:12:45.740 Henry Zhao: Yeah, okay, maybe.
120 00:12:45.740 ⇒ 00:12:46.589 Zoran Selinger: Oh, no.
121 00:12:47.140 ⇒ 00:12:52.310 Zoran Selinger: Yeah, but I cannot give you a Basque ID outside of Basque.
122 00:12:53.390 ⇒ 00:12:54.970 Zoran Selinger: So what do I do?
123 00:12:55.120 ⇒ 00:12:57.410 Zoran Selinger: What do I do on every page load?
124 00:12:57.610 ⇒ 00:13:00.670 Zoran Selinger: But that’s not Basque. What do I do there?
125 00:13:02.030 ⇒ 00:13:10.110 Henry Zhao: I guess… I guess we need in segment to fire the order completed properly, with the… Edge Layer ID.
126 00:13:10.540 ⇒ 00:13:12.040 Henry Zhao: I think that’s where we need.
127 00:13:12.040 ⇒ 00:13:16.360 Zoran Selinger: We should… we should be able to do that. You see the order completed here?
128 00:13:16.360 ⇒ 00:13:17.130 Henry Zhao: Back?
129 00:13:17.220 ⇒ 00:13:18.399 Zoran Selinger: Or segment?
130 00:13:18.510 ⇒ 00:13:23.159 Zoran Selinger: And we have… the traits of that event.
131 00:13:24.240 ⇒ 00:13:28.950 Zoran Selinger: If you want me to add… the edge…
132 00:13:29.830 ⇒ 00:13:34.750 Henry Zhao: And can you also add the BASC ID, or the BASC… Transaction ID or something?
133 00:13:35.050 ⇒ 00:13:37.690 Zoran Selinger: I should be able to do…
134 00:13:37.880 ⇒ 00:13:42.099 Henry Zhao: all of that. Something that I can connect it to Basque or to complete it with.
135 00:13:42.340 ⇒ 00:13:43.240 Henry Zhao: Basically, it’s.
136 00:13:43.240 ⇒ 00:13:44.889 Zoran Selinger: We’ll be able to do all of that.
137 00:13:45.460 ⇒ 00:13:49.450 Henry Zhao: Because then all I need to do is connect the anonymous ID and segment, so that works.
138 00:13:49.730 ⇒ 00:13:51.510 Henry Zhao: Yeah, okay, that works. Yeah.
139 00:13:51.900 ⇒ 00:13:52.980 Zoran Selinger: Will that work?
140 00:13:53.290 ⇒ 00:13:54.119 Henry Zhao: Yes, it will work.
141 00:13:54.120 ⇒ 00:13:58.910 Zoran Selinger: So, I will give you All of the properties
142 00:13:59.430 ⇒ 00:14:11.939 Zoran Selinger: that I can here. It’s gonna contain Basque user ID, it’s gonna contain Edge user ID, it’s going to contain the transaction ID, it can contain BASC order ID as well.
143 00:14:12.950 ⇒ 00:14:16.020 Zoran Selinger: I think I have all of that at this point.
144 00:14:16.640 ⇒ 00:14:17.220 Henry Zhao: Okay.
145 00:14:18.350 ⇒ 00:14:24.889 Zoran Selinger: So, are you… are you sure that when I do track order completed.
146 00:14:25.740 ⇒ 00:14:29.840 Zoran Selinger: And add traits here, this is… you’re going to see this.
147 00:14:30.480 ⇒ 00:14:32.620 Henry Zhao: Let’s add it, and then I will figure that out today.
148 00:14:32.850 ⇒ 00:14:33.720 Zoran Selinger: Okay.
149 00:14:34.040 ⇒ 00:14:38.470 Zoran Selinger: Cool. Okay, let me, let me work on it, and I’ll let you know.
150 00:14:38.750 ⇒ 00:14:44.919 Henry Zhao: Yeah, so anything you can add, transaction ID, BASC order ID, and edge… BASC order or user ID, and then edge layer ID.
151 00:14:44.920 ⇒ 00:14:48.139 Zoran Selinger: Can you, while I have you, can you check?
152 00:14:48.340 ⇒ 00:14:49.570 Zoran Selinger: that table.
153 00:14:50.160 ⇒ 00:14:53.930 Zoran Selinger: already have a transaction ID in there from.
154 00:14:53.930 ⇒ 00:14:55.519 Henry Zhao: Board ID? Okay, let me check.
155 00:14:55.660 ⇒ 00:14:56.790 Henry Zhao: In, the…
156 00:14:56.790 ⇒ 00:14:59.960 Zoran Selinger: Order ID. Let’s… let’s see if that’s already there.
157 00:15:09.640 ⇒ 00:15:12.380 Henry Zhao: It should be called order ID, right? Or DLV Transaction ID.
158 00:15:12.380 ⇒ 00:15:16.429 Zoran Selinger: I mean, you, you see, no, no, no, it should be under order ID.
159 00:15:19.500 ⇒ 00:15:23.269 Henry Zhao: This is just what the variable is called inside GTM.
160 00:15:24.940 ⇒ 00:15:27.749 Henry Zhao: But I completed an order yesterday and it didn’t fire. Do you know why that is?
161 00:15:28.840 ⇒ 00:15:31.870 Henry Zhao: Like, segment needs to be firing the order completed event.
162 00:15:34.490 ⇒ 00:15:38.660 Zoran Selinger: There is… let me see, what’s the purchase exception?
163 00:15:39.600 ⇒ 00:15:41.500 Zoran Selinger: No, this is a new health club.
164 00:15:44.870 ⇒ 00:15:46.650 Henry Zhao: Maybe it’s not firing for test orders?
165 00:15:48.710 ⇒ 00:15:49.730 Zoran Selinger: Burchase.
166 00:15:52.170 ⇒ 00:15:55.299 Henry Zhao: Meanwhile, I’m gonna do a left join and just see how many transaction IDs
167 00:15:55.560 ⇒ 00:15:58.940 Henry Zhao: in this month so far are not in Webflow order completed.
168 00:16:09.900 ⇒ 00:16:12.610 Zoran Selinger: I just wanna check something…
169 00:16:20.840 ⇒ 00:16:25.589 Zoran Selinger: Yeah, so purchase should be there. We have no other conditions.
170 00:16:27.140 ⇒ 00:16:34.670 Zoran Selinger: your… Your segment should fire on the… On the test.
171 00:16:35.410 ⇒ 00:16:45.479 Henry Zhao: Okay, so count distinct, B transaction ID, count distinct C.orderID from this, where B.TimestampDate…
172 00:16:47.310 ⇒ 00:16:50.479 Henry Zhao: Is greater than or equal to… when did you implement this?
173 00:16:51.960 ⇒ 00:16:53.400 Zoran Selinger: Which one? This?
174 00:16:53.400 ⇒ 00:16:54.550 Henry Zhao: Yeah, order completed.
175 00:16:54.850 ⇒ 00:16:55.990 Zoran Selinger: for segment.
176 00:16:56.360 ⇒ 00:16:59.899 Zoran Selinger: Yeah. That was… that was already there, I’ve never worked on this.
177 00:17:00.960 ⇒ 00:17:03.089 Zoran Selinger: That was already there when I came.
178 00:17:10.670 ⇒ 00:17:12.430 Henry Zhao: So where is this data going into, then?
179 00:17:16.310 ⇒ 00:17:18.330 Henry Zhao: Cause it’s very few, look, let me show you.
180 00:17:19.140 ⇒ 00:17:19.700 Zoran Selinger: Yeah.
181 00:17:19.990 ⇒ 00:17:25.590 Zoran Selinger: I… I… I mean, I don’t have an answer for you. I don’t… I still am catching up on…
182 00:17:26.170 ⇒ 00:17:32.050 Zoran Selinger: I don’t know how data pipelines are done here, I… no idea yet. Okay.
183 00:17:32.050 ⇒ 00:17:32.740 Henry Zhao: What?
184 00:17:32.960 ⇒ 00:17:33.690 Henry Zhao: Let’s go to…
185 00:17:33.690 ⇒ 00:17:35.060 Zoran Selinger: All of that works.
186 00:17:39.600 ⇒ 00:17:44.200 Henry Zhao: I wonder… No.
187 00:17:45.920 ⇒ 00:17:49.370 Henry Zhao: I wonder if Mixpanel’s getting it, actually, let me see.
188 00:17:52.030 ⇒ 00:17:58.400 Henry Zhao: I know how to do this. Events… Yesterday… Order completed.
189 00:18:00.920 ⇒ 00:18:05.990 Henry Zhao: Filter… City.
190 00:18:25.020 ⇒ 00:18:26.520 Henry Zhao: Dean? Ugh.
191 00:18:27.080 ⇒ 00:18:29.839 Henry Zhao: One second, one second. Stay with me, please.
192 00:18:30.260 ⇒ 00:18:32.390 Henry Zhao: We still have 11 minutes.
193 00:18:32.990 ⇒ 00:18:35.379 Henry Zhao: I’ll do source Henry Test Identifies.
194 00:18:42.880 ⇒ 00:18:43.640 Henry Zhao: Nope.
195 00:18:45.610 ⇒ 00:18:49.049 Henry Zhao: So even in Mixpanel, it’s not firing in order completed.
196 00:18:50.400 ⇒ 00:18:54.220 Henry Zhao: And that’s what I need for attribution, right? We need to figure out what happens right before…
197 00:18:56.130 ⇒ 00:19:00.370 Zoran Selinger: Yeah, and do we see… do we see others? Is this… Is this…
198 00:19:00.600 ⇒ 00:19:06.530 Zoran Selinger: The case that it didn’t fire that one time, or do we see other… Hmm…
199 00:19:07.050 ⇒ 00:19:07.390 Henry Zhao: A lot.
200 00:19:07.390 ⇒ 00:19:08.749 Zoran Selinger: acting in the segment.
201 00:19:08.750 ⇒ 00:19:12.280 Henry Zhao: If you look at the data, it’s like… 90% are not firing.
202 00:19:12.790 ⇒ 00:19:16.549 Henry Zhao: So this is the total FASC order completed, this is how many fired in segments.
203 00:19:18.200 ⇒ 00:19:18.920 Zoran Selinger: What?
204 00:19:19.420 ⇒ 00:19:20.649 Henry Zhao: See, that’s the issue.
205 00:19:25.450 ⇒ 00:19:30.760 Zoran Selinger: Do you see a way… Do not rely on segment.
206 00:19:32.420 ⇒ 00:19:34.330 Henry Zhao: Hold on one second, 1-0-0-4.
207 00:19:41.310 ⇒ 00:19:43.890 Henry Zhao: Well, we want segment because of the anonymous ID, right? So…
208 00:19:50.320 ⇒ 00:19:52.889 Henry Zhao: So here, I’ve signed up, identified, page loaded.
209 00:19:54.010 ⇒ 00:19:55.760 Henry Zhao: Yeah, there’s nowhere to complete it anywhere.
210 00:19:57.860 ⇒ 00:20:00.020 Henry Zhao: But did it go to Mixpanel?
211 00:20:10.600 ⇒ 00:20:11.920 Henry Zhao: No, I don’t think so.
212 00:20:19.120 ⇒ 00:20:21.099 Zoran Selinger: Okay, I mean.
213 00:20:25.130 ⇒ 00:20:26.510 Henry Zhao: It’s been working…
214 00:20:31.640 ⇒ 00:20:35.459 Zoran Selinger: You’ll need to check, yeah, even then you flagged, someone flagged.
215 00:20:36.410 ⇒ 00:20:44.069 Zoran Selinger: But this is potentially not firing. I don’t see why it wouldn’t, because the trigger is a purchase event.
216 00:20:44.320 ⇒ 00:20:46.829 Zoran Selinger: Which is happening.
217 00:20:49.420 ⇒ 00:20:55.540 Zoran Selinger: But I can dig into that with… with Ryan. I’m not sure if we’re gonna be able to… to…
218 00:20:55.770 ⇒ 00:20:58.110 Zoran Selinger: debug that tomorrow.
219 00:21:02.170 ⇒ 00:21:03.710 Henry Zhao: Should I maybe ask Robert for help?
220 00:21:06.090 ⇒ 00:21:09.620 Zoran Selinger: For… I mean, what’s… what’s he gonna do?
221 00:21:10.090 ⇒ 00:21:11.190 Zoran Selinger: I mean, if…
222 00:21:11.640 ⇒ 00:21:14.249 Henry Zhao: Figure out how to get the order completed to fire.
223 00:21:15.590 ⇒ 00:21:22.870 Zoran Selinger: I mean, that’s… that’s a GTM problem. I can solve that. That’s not… I wasn’t aware that that issue exists.
224 00:21:23.140 ⇒ 00:21:23.780 Henry Zhao: Okay.
225 00:21:24.050 ⇒ 00:21:24.620 Zoran Selinger: Yeah.
226 00:21:25.350 ⇒ 00:21:32.640 Henry Zhao: So when the order’s completed, like, whenever Bask fires order completed, we should have that fire as a segment event also into the table webflow.orderCompleted.
227 00:21:33.610 ⇒ 00:21:40.070 Zoran Selinger: So, this, into the table. How does that happen? I don’t know… can you explain that to me?
228 00:21:41.710 ⇒ 00:21:44.820 Zoran Selinger: Segment to receive an order complete event.
229 00:21:45.590 ⇒ 00:21:46.310 Zoran Selinger: Yeah.
230 00:21:46.310 ⇒ 00:21:50.410 Henry Zhao: It should be… from Webflow plus Bask ID, this thing.
231 00:21:50.750 ⇒ 00:21:53.639 Henry Zhao: So the source is Webflow plus BASC.
232 00:21:54.640 ⇒ 00:21:55.590 Henry Zhao: Web?
233 00:21:55.820 ⇒ 00:22:00.389 Henry Zhao: And the destination is BigQuery?
234 00:22:02.430 ⇒ 00:22:03.480 Zoran Selinger: Right…
235 00:22:03.600 ⇒ 00:22:05.649 Henry Zhao: And I don’t know how they set this up, but…
236 00:22:06.840 ⇒ 00:22:09.280 Henry Zhao: I think it’s just this, order completed here.
237 00:22:11.170 ⇒ 00:22:13.719 Zoran Selinger: And then you go in, you see the properties.
238 00:22:13.720 ⇒ 00:22:18.509 Henry Zhao: Yeah, so when you add the property for X layer, it should be in here, yeah. Right now, it’s not, obviously.
239 00:22:19.020 ⇒ 00:22:19.870 Henry Zhao: But it should be one of these.
240 00:22:21.230 ⇒ 00:22:22.339 Zoran Selinger: Do we have?
241 00:22:22.650 ⇒ 00:22:26.090 Zoran Selinger: the order ID in… yeah, order ID is in there.
242 00:22:28.990 ⇒ 00:22:31.780 Zoran Selinger: So I’m hoping… Huh.
243 00:22:33.070 ⇒ 00:22:43.460 Henry Zhao: Basically. Yeah, so basically we just need to feed it into this orderCompleted with these properties, and add the edge layer and transaction ID, like you said. But like you said, transaction ID should already be the order ID, but it needs to get filled in.
244 00:22:43.590 ⇒ 00:22:44.970 Henry Zhao: Because right now, they’re not filming.
245 00:22:45.300 ⇒ 00:22:55.290 Zoran Selinger: Okay, so we potentially… you think, right now, you think that if we fire order completed segment correctly.
246 00:22:56.270 ⇒ 00:23:00.250 Zoran Selinger: Segment order completed. With these additional properties.
247 00:23:00.620 ⇒ 00:23:03.499 Zoran Selinger: You will be able to do what you need to do.
248 00:23:04.080 ⇒ 00:23:18.189 Henry Zhao: Yes. And then the other one is the thank you page. So we’re gonna have two last clicks. One is a thank you page, and one is the order completed. So that solves the order completed part. The second part is a thank you page. For that, I’m going to be using thank you page visits.
249 00:23:19.180 ⇒ 00:23:20.020 Zoran Selinger: Yes, excellent.
250 00:23:20.020 ⇒ 00:23:26.359 Henry Zhao: But I… so… I think I can join that to edge layer raw data using user ID equals order ID, right?
251 00:23:32.190 ⇒ 00:23:34.939 Zoran Selinger: So, order ID… equals which order ID?
252 00:23:35.250 ⇒ 00:23:39.330 Henry Zhao: Wait, TYPV is… Hold on.
253 00:23:47.490 ⇒ 00:23:48.860 Henry Zhao: Sounds driving me crazy.
254 00:23:51.930 ⇒ 00:23:54.360 Henry Zhao: Yeah, I need to know how to join this also, so…
255 00:23:55.330 ⇒ 00:23:56.480 Zoran Selinger: Yeah, yeah, yeah.
256 00:23:57.940 ⇒ 00:23:59.600 Zoran Selinger: So what do you need here?
257 00:23:59.960 ⇒ 00:24:01.840 Henry Zhao: Oh, transaction ID is what I meant.
258 00:24:01.840 ⇒ 00:24:02.500 Zoran Selinger: Yeah.
259 00:24:03.890 ⇒ 00:24:11.000 Zoran Selinger: Transaction ID, yeah, you’ll have to look… you can look it up in the order completed table and find any identifiers that you need.
260 00:24:13.990 ⇒ 00:24:17.369 Zoran Selinger: So that transaction ID will correlate with… with…
261 00:24:17.550 ⇒ 00:24:21.270 Zoran Selinger: all the data in the order completed table from Basque.
262 00:24:21.350 ⇒ 00:24:25.299 Henry Zhao: But I should be joining on user ID, right? This user ID should match the user ID in the edge layer.
263 00:24:25.840 ⇒ 00:24:28.210 Zoran Selinger: That is the Edge Layer user ID, yes.
264 00:24:28.210 ⇒ 00:24:33.169 Henry Zhao: Okay, then that’s the one I’m going to use. So, user ID equals edge layer or user ID.
265 00:24:33.860 ⇒ 00:24:36.299 Henry Zhao: So that join is fine, join fine.
266 00:24:37.120 ⇒ 00:24:43.730 Henry Zhao: And then I also want to look at segment data before thank you page visits, because I need the people that came before you set this up in November, you know what I mean?
267 00:24:43.910 ⇒ 00:24:45.400 Zoran Selinger: Only first, of course, yeah, yeah.
268 00:24:45.400 ⇒ 00:24:46.140 Henry Zhao: So…
269 00:24:46.140 ⇒ 00:24:46.680 Zoran Selinger: Okay.
270 00:24:48.770 ⇒ 00:24:49.740 Henry Zhao: So…
271 00:24:49.740 ⇒ 00:24:51.449 Zoran Selinger: on this tomorrow.
272 00:24:52.280 ⇒ 00:24:58.160 Henry Zhao: So I guess what I would do is, for the thank you page visits, I would have…
273 00:24:59.260 ⇒ 00:25:01.690 Henry Zhao: So those would be the same thing, right? It would be the order completed.
274 00:25:01.920 ⇒ 00:25:05.159 Henry Zhao: I’ll join it to the order completed, because they need to have an order completed.
275 00:25:06.900 ⇒ 00:25:10.879 Henry Zhao: Because you can’t add Bask User ID. Can you add Bas user ID to this thank you page visits?
276 00:25:12.630 ⇒ 00:25:14.390 Henry Zhao: Since it’s after Basque?
277 00:25:14.930 ⇒ 00:25:19.210 Zoran Selinger: No, because, again, I’m not loading the website.
278 00:25:20.040 ⇒ 00:25:27.729 Henry Zhao: Okay, so then, so for this join, I will need to join TYPV transaction ID to VASC order completed.
279 00:25:30.370 ⇒ 00:25:33.280 Henry Zhao: And then join that two segment.
280 00:25:33.500 ⇒ 00:25:35.579 Henry Zhao: Based on piece one, right?
281 00:25:36.480 ⇒ 00:25:38.639 Henry Zhao: So piece one is this order completed stuff.
282 00:25:39.770 ⇒ 00:25:41.549 Henry Zhao: So for that, I just need…
283 00:25:41.710 ⇒ 00:25:49.999 Henry Zhao: So Zoran will be adding edge ID to segment dot order completed.
284 00:25:50.440 ⇒ 00:25:52.179 Henry Zhao: And make sure that fires.
285 00:25:53.800 ⇒ 00:25:57.119 Henry Zhao: then Henry, join on anonymous ID.
286 00:25:59.720 ⇒ 00:26:01.970 Henry Zhao: To get historical. Okay, that should work.
287 00:26:04.710 ⇒ 00:26:14.459 Zoran Selinger: just before you go, I want to ask a completely irrelevant question. What’s the editor? I like that. I like the editor.
288 00:26:14.460 ⇒ 00:26:19.560 Henry Zhao: Oh, thank you, this is, sublime Text.
289 00:26:19.560 ⇒ 00:26:22.169 Zoran Selinger: That’s sublime, okay, very nice, very nice.
290 00:26:22.420 ⇒ 00:26:29.389 Zoran Selinger: I like the minimal look. Thank you. And I like the team as well. The team is phenomenal.
291 00:26:30.300 ⇒ 00:26:34.480 Henry Zhao: Oh, thank you. So then for this one, I will also replace order completed with segment.
292 00:26:34.950 ⇒ 00:26:37.900 Henry Zhao: then join on, Edge ID.
293 00:26:38.030 ⇒ 00:26:38.680 Henry Zhao: Right? Okay.
294 00:26:38.680 ⇒ 00:26:39.150 Zoran Selinger: Yeah.
295 00:26:39.440 ⇒ 00:26:40.060 Henry Zhao: That should work.
296 00:26:40.060 ⇒ 00:26:53.419 Zoran Selinger: So, yeah, it’ll be easy to add stuff to the payload, we just need to debug why it’s not firing. Are you sure that your analysis, in terms of when it’s firing and when it’s not, is correct?
297 00:26:55.020 ⇒ 00:26:56.650 Henry Zhao: Am I sure of my analysis of what?
298 00:26:57.020 ⇒ 00:27:02.980 Zoran Selinger: Yeah, so you were… you were doing a count of order completed events from segment, Somewhere else.
299 00:27:03.590 ⇒ 00:27:04.629 Henry Zhao: 100% of that, yeah.
300 00:27:04.630 ⇒ 00:27:06.000 Zoran Selinger: Okay, cool, okay.
301 00:27:06.490 ⇒ 00:27:07.019 Henry Zhao: That has always been.
302 00:27:07.020 ⇒ 00:27:09.300 Zoran Selinger: I’ll write it up and work on this tomorrow.
303 00:27:09.760 ⇒ 00:27:10.590 Henry Zhao: Okay, thank you.
304 00:27:11.760 ⇒ 00:27:12.829 Zoran Selinger: Thank you, Henry.
305 00:27:12.830 ⇒ 00:27:15.020 Henry Zhao: Alright, thank you. Bye. Bye-bye.