Meeting Title: BASC Data Integration Sync Date: 2025-11-12 Meeting participants: Zoran Selinger, Henry Zhao
WEBVTT
1 00:01:34.040 ⇒ 00:01:36.350 Zoran Selinger: Oh, you’re in? Okay. Cool.
2 00:01:36.350 ⇒ 00:01:38.589 Henry Zhao: I invited you to segment, can you just check if you got that part?
3 00:01:38.590 ⇒ 00:01:40.450 Zoran Selinger: Yes, I’m in.
4 00:01:40.790 ⇒ 00:01:50.149 Zoran Selinger: Just configured my profile. Cool, alright, let me go to GTM, see what we have there.
5 00:01:52.700 ⇒ 00:01:55.829 Zoran Selinger: So, you see events coming in, right?
6 00:01:56.060 ⇒ 00:01:56.759 Henry Zhao: Yeah, yeah.
7 00:01:59.990 ⇒ 00:02:03.020 Zoran Selinger: That is crazy, that that’s not available.
8 00:02:03.500 ⇒ 00:02:06.170 Henry Zhao: Take a look at, the change…
9 00:02:08.919 ⇒ 00:02:12.899 Zoran Selinger: First, can we comment the volume at all?
10 00:02:13.640 ⇒ 00:02:14.320 Henry Zhao: identified.
11 00:02:14.320 ⇒ 00:02:15.709 Zoran Selinger: The number, yeah, yeah.
12 00:02:16.250 ⇒ 00:02:18.919 Henry Zhao: Yeah, see, it’s got much better. So you implemented probably the 7th.
13 00:02:18.920 ⇒ 00:02:20.220 Zoran Selinger: Okay, excellent.
14 00:02:20.820 ⇒ 00:02:24.309 Henry Zhao: So I was, like, trying to figure out, is, like, order ID…
15 00:02:24.690 ⇒ 00:02:28.459 Henry Zhao: Or is it, like, which ID did you put it in? Like, trying to figure that out.
16 00:02:29.520 ⇒ 00:02:31.749 Henry Zhao: I guess it’s not null for every… hold on one second.
17 00:02:36.270 ⇒ 00:02:39.600 Zoran Selinger: The main thing you needed is the Eden,
18 00:02:40.680 ⇒ 00:02:43.899 Zoran Selinger: the edge user ID, right? That’s the main thing you needed.
19 00:02:44.410 ⇒ 00:02:48.270 Henry Zhao: That one, yeah, I need that, but now I also need to be able to connect it to Basque.
20 00:02:51.230 ⇒ 00:02:53.400 Henry Zhao: Maybe it’s coming in now, let’s check.
21 00:02:56.880 ⇒ 00:02:58.039 Henry Zhao: Wow, shoot.
22 00:02:58.290 ⇒ 00:03:01.720 Zoran Selinger: It’s too big, but it’s okay, I already ran it, so the cost is there.
23 00:03:04.430 ⇒ 00:03:05.670 Zoran Selinger: And while we see.
24 00:03:06.700 ⇒ 00:03:12.429 Henry Zhao: So I need either the user ID or the order ID. So the user ID is… oh, okay, this is there for some of them now.
25 00:03:12.810 ⇒ 00:03:15.910 Henry Zhao: I don’t know why it’s not there for all of them, because you need to be identified in order.
26 00:03:15.910 ⇒ 00:03:23.309 Zoran Selinger: Wait, that’s not… but that’s not… this is the user ID. Yes, edge user ID, that’s the important one. I mean, that’s the one that I added.
27 00:03:23.860 ⇒ 00:03:24.490 Zoran Selinger: Okay.
28 00:03:24.840 ⇒ 00:03:30.030 Henry Zhao: But now I need to connect it to Basque, so I was gonna either use user ID, which it has it for some of them, so it’s not good enough.
29 00:03:30.760 ⇒ 00:03:33.450 Henry Zhao: Oh, here it is Okay.
30 00:03:33.780 ⇒ 00:03:34.920 Henry Zhao: Now it’s showing up.
31 00:03:35.260 ⇒ 00:03:42.599 Zoran Selinger: Yeah, so order ID is the transaction ID, you see, yeah, yeah, cool. So that’s enough, yeah, you should be able to work on it.
32 00:03:42.820 ⇒ 00:03:45.369 Henry Zhao: Okay, well, let’s just double check, let’s double check.
33 00:03:50.930 ⇒ 00:03:56.080 Henry Zhao: Alright, so this is my query. Everything runs off of FASC order completed.
34 00:03:57.270 ⇒ 00:03:59.770 Henry Zhao: Okay, so when I join it to…
35 00:04:00.320 ⇒ 00:04:02.700 Henry Zhao: Webflow, I’m gonna use order completed.
36 00:04:02.800 ⇒ 00:04:04.840 Henry Zhao: And I’m gonna use transaction ID.
37 00:04:05.050 ⇒ 00:04:09.820 Henry Zhao: When I do an edge layer, I’m going to use the edge layer ID, Yes, correct.
38 00:04:10.460 ⇒ 00:04:12.690 Henry Zhao: And then for thank you page…
39 00:04:12.840 ⇒ 00:04:17.079 Henry Zhao: I’m gonna join that to… oh, yeah, so thank you, Pager’s the other one we need to talk about,
40 00:04:17.800 ⇒ 00:04:21.040 Henry Zhao: For a thank you page, we can also use But that’s.
41 00:04:21.040 ⇒ 00:04:24.619 Zoran Selinger: Yeah, we did touch on this last time.
42 00:04:25.720 ⇒ 00:04:27.950 Henry Zhao: What did we say we were gonna do for Thank You, Paige?
43 00:04:28.460 ⇒ 00:04:29.120 Henry Zhao: Just while I have.
44 00:04:29.120 ⇒ 00:04:32.550 Zoran Selinger: I mean, on thank you page, we have the transaction ID.
45 00:04:34.120 ⇒ 00:04:36.010 Henry Zhao: Oh, yes. Oh, we do, right?
46 00:04:36.010 ⇒ 00:04:36.750 Zoran Selinger: Yes.
47 00:04:37.040 ⇒ 00:04:38.490 Henry Zhao: We do, that’s life-changing.
48 00:04:39.110 ⇒ 00:04:42.160 Zoran Selinger: Yeah, yeah, I mean, that’s the whole idea, yes.
49 00:04:42.750 ⇒ 00:04:44.180 Henry Zhao: Oh, we didn’t have it! That’s life-changing.
50 00:04:44.180 ⇒ 00:04:46.199 Zoran Selinger: We… we… we do have it.
51 00:04:46.460 ⇒ 00:04:47.419 Zoran Selinger: Have a look.
52 00:04:47.650 ⇒ 00:04:49.549 Henry Zhao: Okay, that’s life-changing. Alright, done.
53 00:04:50.270 ⇒ 00:05:03.690 Henry Zhao: And I was looking at user ID, so no, we don’t need it, we just use the transaction ID. We don’t need this user ID. Well, keep it, but I don’t need it because I can use the transaction ID. So basically, my sector is fast order completed, right? Because that’s how all the tables are built.
54 00:05:03.690 ⇒ 00:05:13.130 Henry Zhao: Like, the from is order completed from BASC, so I cannot, like, pivot it to something else, so I needed to get from BASC order completed, and then be able to join everything to that. Make sense?
55 00:05:13.130 ⇒ 00:05:14.549 Zoran Selinger: Yes, it does, it does.
56 00:05:14.550 ⇒ 00:05:17.540 Henry Zhao: Now that I have this web, I can… I can do it. Alright, thanks, Lauren.
57 00:05:17.540 ⇒ 00:05:18.840 Zoran Selinger: Excellent, thank you.
58 00:05:19.050 ⇒ 00:05:19.709 Henry Zhao: We appreciate it.
59 00:05:19.710 ⇒ 00:05:20.339 Zoran Selinger: I picked up.