Meeting Title: Eden segment help for henry Date: 2025-10-17 Meeting participants: Awaish Kumar, Henry Zhao
WEBVTT
1 00:00:57.940 ⇒ 00:00:58.830 Awaish Kumar: Hello?
2 00:00:59.260 ⇒ 00:01:00.970 Henry Zhao: Hey, OH, thank you for your help.
3 00:01:01.800 ⇒ 00:01:02.830 Awaish Kumar: No worries.
4 00:01:03.220 ⇒ 00:01:07.590 Henry Zhao: I tried on my own, I couldn’t figure it out, so… I think you have more…
5 00:01:08.020 ⇒ 00:01:09.729 Henry Zhao: Way more knowledge than me on this.
6 00:01:09.970 ⇒ 00:01:10.700 Henry Zhao: Alright.
7 00:01:11.630 ⇒ 00:01:17.159 Henry Zhao: Hopefully it won’t take too long… Alright, log into segment…
8 00:01:21.560 ⇒ 00:01:23.300 Henry Zhao: Go to Catalog…
9 00:01:27.310 ⇒ 00:01:32.450 Henry Zhao: So, functions, should I be using the, Destination function.
10 00:01:34.790 ⇒ 00:01:40.890 Awaish Kumar: Let’s start with, like, source function, like… What, what is…
11 00:01:40.930 ⇒ 00:01:41.780 Henry Zhao: Okay.
12 00:01:42.170 ⇒ 00:01:43.120 Henry Zhao: Got it.
13 00:01:43.120 ⇒ 00:01:46.660 Awaish Kumar: I mean… Not just what’s function, I mean?
14 00:01:46.950 ⇒ 00:01:54.550 Awaish Kumar: The… our source, like, where the… Data, you will be… pulling from…
15 00:01:55.020 ⇒ 00:01:59.400 Henry Zhao: Yeah, it’s that table that we worked on yesterday. Bigquery…
16 00:02:04.560 ⇒ 00:02:10.439 Henry Zhao: So I created a reverse ETL source to just basically pull from this table, catalyst successful orders.
17 00:02:10.449 ⇒ 00:02:17.009 Awaish Kumar: Okay, can I see the… Can you click on this? No, no, no, here, here, not in the…
18 00:02:18.610 ⇒ 00:02:21.120 Henry Zhao: Yeah, but it’s just the table. It’s just this.
19 00:02:21.620 ⇒ 00:02:25.280 Awaish Kumar: Oh, that’s great. What I needed here is…
20 00:02:25.510 ⇒ 00:02:27.560 Awaish Kumar: In the… can I go to settings?
21 00:02:32.030 ⇒ 00:02:38.370 Awaish Kumar: Okay, so that’s our source. Now we wanna… destination here, right?
22 00:02:38.990 ⇒ 00:02:40.989 Awaish Kumar: That’s what I can figure out.
23 00:02:41.240 ⇒ 00:02:43.759 Henry Zhao: So do I go to.
24 00:02:44.430 ⇒ 00:02:47.069 Awaish Kumar: Can I… okay, I’m gonna go back to overview.
25 00:02:47.430 ⇒ 00:02:48.040 Henry Zhao: Okay?
26 00:02:50.660 ⇒ 00:02:54.100 Henry Zhao: A little slow, I don’t know why, but… I’ll get that.
27 00:03:08.670 ⇒ 00:03:13.000 Awaish Kumar: like… Yeah, add mapping.
28 00:03:13.820 ⇒ 00:03:14.480 Henry Zhao: Okay?
29 00:03:16.430 ⇒ 00:03:19.790 Awaish Kumar: So we don’t… we… now we have this latest HPI.
30 00:03:20.990 ⇒ 00:03:24.840 Henry Zhao: Yeah, but it should only have connections and profiles, and none of these, I think, are the right one.
31 00:03:27.630 ⇒ 00:03:29.159 Awaish Kumar: Okay,
32 00:03:35.150 ⇒ 00:03:38.449 Awaish Kumar: Okay, so now we need a destination function.
33 00:03:38.550 ⇒ 00:03:45.290 Awaish Kumar: But I don’t know how you are… like, what needs to be in that function? I’m just trying to figure that out, because…
34 00:03:46.960 ⇒ 00:03:49.099 Henry Zhao: I can show you the function if this…
35 00:03:49.510 ⇒ 00:03:51.430 Awaish Kumar: Yeah, you can… if you can show me.
36 00:03:52.650 ⇒ 00:04:00.789 Henry Zhao: It’s just order ID, that’s it. And I need the timestamp to look at only new, new order ID. So you already have a JavaScript, right?
37 00:04:01.000 ⇒ 00:04:02.969 Henry Zhao: This is working and it’s done.
38 00:04:03.400 ⇒ 00:04:06.630 Awaish Kumar: Okay, so he can… okay, so he can create a test station.
39 00:04:07.860 ⇒ 00:04:08.500 Henry Zhao: Okay.
40 00:04:08.500 ⇒ 00:04:10.779 Awaish Kumar: So I can recruit a destination function already, right?
41 00:04:14.040 ⇒ 00:04:16.230 Henry Zhao: Or is it destination insert?
42 00:04:17.140 ⇒ 00:04:23.160 Awaish Kumar: No, no, it says… Destination is descend data from segment to anywhere, right?
43 00:04:23.300 ⇒ 00:04:26.379 Henry Zhao: Other one is a transformation. We don’t need any transformation.
44 00:04:27.080 ⇒ 00:04:27.720 Henry Zhao: Okay.
45 00:04:28.720 ⇒ 00:04:29.680 Henry Zhao: This one…
46 00:04:29.680 ⇒ 00:04:31.180 Awaish Kumar: Copy paste your code here.
47 00:04:32.770 ⇒ 00:04:33.680 Henry Zhao: Okay?
48 00:04:34.350 ⇒ 00:04:36.200 Awaish Kumar: Next, configure.
49 00:04:36.200 ⇒ 00:04:36.970 Henry Zhao: The nugget.
50 00:04:37.180 ⇒ 00:04:38.719 Henry Zhao: Oh, okay, so I don’t need to test.
51 00:04:41.990 ⇒ 00:04:46.929 Henry Zhao: So, actually, I don’t… I don’t need this one thing anymore, so let me go back.
52 00:04:47.390 ⇒ 00:04:53.110 Henry Zhao: I don’t need to check… For the event codes anymore.
53 00:04:58.790 ⇒ 00:05:00.060 Henry Zhao: Constito.
54 00:05:00.550 ⇒ 00:05:05.219 Henry Zhao: This was the part, this was what we were checking on order completed, but I don’t need any of this stuff anymore.
55 00:05:05.780 ⇒ 00:05:06.980 Henry Zhao: So…
56 00:05:08.160 ⇒ 00:05:10.229 Awaish Kumar: This is a, like, function.
57 00:05:13.470 ⇒ 00:05:15.850 Henry Zhao: So I don’t need any stuff anymore, right? For now?
58 00:05:15.850 ⇒ 00:05:17.390 Awaish Kumar: Okay, I’m gonna move it down.
59 00:05:17.600 ⇒ 00:05:19.920 Awaish Kumar: Okay, so now it can be run, like.
60 00:05:20.130 ⇒ 00:05:24.989 Awaish Kumar: Because we changed the code, right? So, I don’t know if… It’s working now.
61 00:05:26.450 ⇒ 00:05:28.189 Henry Zhao: But there’s no event to try it on, so…
62 00:05:33.800 ⇒ 00:05:41.999 Awaish Kumar: Oh, but… Yeah, we can just configure, and then we can test it in.
63 00:05:42.000 ⇒ 00:05:43.739 Henry Zhao: Open it somewhere.
64 00:05:44.110 ⇒ 00:05:46.639 Henry Zhao: So, destination name, I would say Catalyst, right?
65 00:05:47.030 ⇒ 00:05:49.790 Awaish Kumar: Get less successful orders, like, something like that.
66 00:05:52.280 ⇒ 00:05:54.560 Awaish Kumar: So easy to come back.
67 00:06:18.310 ⇒ 00:06:19.080 Henry Zhao: Okay?
68 00:06:19.760 ⇒ 00:06:21.420 Awaish Kumar: Now we have to…
69 00:06:25.010 ⇒ 00:06:26.310 Henry Zhao: Now I have to go here, right?
70 00:06:26.670 ⇒ 00:06:27.650 Awaish Kumar: Yeah, yeah.
71 00:06:28.640 ⇒ 00:06:34.310 Awaish Kumar: If we’re gonna add a… Mapping, yeah, we could.
72 00:06:38.970 ⇒ 00:06:41.589 Awaish Kumar: Oh, is our destination connected to BigQuery?
73 00:06:45.670 ⇒ 00:06:46.950 Henry Zhao: connects destination.
74 00:06:51.790 ⇒ 00:06:52.680 Awaish Kumar: Alright.
75 00:06:57.490 ⇒ 00:06:59.609 Awaish Kumar: Yeah, it says, add destination.
76 00:07:03.670 ⇒ 00:07:04.650 Henry Zhao: Inquiry?
77 00:07:12.790 ⇒ 00:07:14.819 Awaish Kumar: Okay, I don’t see it, Jimmy.
78 00:07:14.820 ⇒ 00:07:16.829 Henry Zhao: I’m gonna… That’s where I’m getting stuck.
79 00:07:17.060 ⇒ 00:07:20.230 Henry Zhao: I think it’s only allowing event streams, not tables.
80 00:07:24.340 ⇒ 00:07:28.400 Awaish Kumar: What particularly, like… I added it for…
81 00:07:32.980 ⇒ 00:07:36.659 Awaish Kumar: Let me open the segment on my screen.
82 00:07:37.210 ⇒ 00:07:38.020 Henry Zhao: Okay.
83 00:07:41.940 ⇒ 00:07:50.130 Awaish Kumar: Yeah, last time I added… I added… there are two different connections for BigQuery in segment, right? One is… the other one is called…
84 00:07:50.870 ⇒ 00:07:52.690 Awaish Kumar: Barrows or something.
85 00:07:52.840 ⇒ 00:07:57.090 Awaish Kumar: And I used the other one, and that just worked.
86 00:07:59.240 ⇒ 00:08:00.990 Awaish Kumar: Yeah, let’s see what yours looks like.
87 00:08:06.160 ⇒ 00:08:08.460 Awaish Kumar: Isolation…
88 00:08:32.460 ⇒ 00:08:34.600 Awaish Kumar: But did we edit a destination?
89 00:08:37.780 ⇒ 00:08:38.850 Henry Zhao: What do you mean?
90 00:08:39.890 ⇒ 00:08:41.639 Henry Zhao: We did add the destination, remember?
91 00:08:42.140 ⇒ 00:08:43.959 Henry Zhao: We did it… we just did it together.
92 00:08:43.960 ⇒ 00:08:45.509 Awaish Kumar: What is a destination function?
93 00:08:48.440 ⇒ 00:08:49.240 Henry Zhao: Like…
94 00:08:49.980 ⇒ 00:08:54.860 Awaish Kumar: There are a few things, right? There’s a source, There’s a destination.
95 00:08:55.330 ⇒ 00:08:55.710 Henry Zhao: Yeah.
96 00:08:55.710 ⇒ 00:08:57.840 Awaish Kumar: Then there is a destination function.
97 00:08:58.310 ⇒ 00:09:00.049 Henry Zhao: So, what’s the destination that I need?
98 00:09:00.900 ⇒ 00:09:04.610 Awaish Kumar: Yeah, that I’m, like, because right now you are…
99 00:09:05.230 ⇒ 00:09:12.580 Awaish Kumar: trying to upload to Catalyst, and Catalyst does not have the native connector in the site.
100 00:09:12.810 ⇒ 00:09:18.789 Awaish Kumar: So we just need a destination of type, JavaScript or something, which just executes.
101 00:09:18.790 ⇒ 00:09:19.200 Henry Zhao: Okay.
102 00:09:20.000 ⇒ 00:09:20.650 Awaish Kumar: So, I…
103 00:09:20.650 ⇒ 00:09:21.400 Henry Zhao: Okay.
104 00:09:21.630 ⇒ 00:09:27.880 Awaish Kumar: But I… I’m… I’m looking for that, and I can’t find… Dean?
105 00:09:33.390 ⇒ 00:09:37.180 Awaish Kumar: So, what should be the… Ken…
106 00:09:37.330 ⇒ 00:09:40.349 Awaish Kumar: Do you have any example? Like, some… did somebody…
107 00:09:41.040 ⇒ 00:09:43.519 Awaish Kumar: Added any… anything like that before?
108 00:09:43.750 ⇒ 00:09:45.210 Awaish Kumar: No.
109 00:09:49.940 ⇒ 00:09:51.750 Henry Zhao: I’m gonna see if any of these could be…
110 00:09:58.930 ⇒ 00:10:00.360 Awaish Kumar: Seattle…
111 00:10:06.030 ⇒ 00:10:07.880 Awaish Kumar: Okay.
112 00:10:10.440 ⇒ 00:10:14.850 Henry Zhao: That’s what I was saying, like, it would be so much easier, Bass could literally just add the transaction ID.
113 00:10:16.580 ⇒ 00:10:20.870 Henry Zhao: Like, we’re doing all this workaround just because Basque is so slow to respond to us and lazy.
114 00:10:35.640 ⇒ 00:10:37.540 Henry Zhao: Let me ask some other things in the meantime.
115 00:10:40.510 ⇒ 00:10:44.440 Awaish Kumar: Yeah, let me just… give me a… No minutes, I haven’t…
116 00:10:44.890 ⇒ 00:10:48.600 Awaish Kumar: Let’s have a look at the… A list of collectors.
117 00:17:13.849 ⇒ 00:17:17.650 Awaish Kumar: Hello?
118 00:17:20.010 ⇒ 00:17:20.980 Awaish Kumar: Hello?
119 00:17:21.630 ⇒ 00:17:22.349 Henry Zhao: Yes.
120 00:17:22.619 ⇒ 00:17:23.750 Henry Zhao: Me?
121 00:17:29.400 ⇒ 00:17:31.310 Henry Zhao: So, Oasis, you’re talking to me?
122 00:19:30.530 ⇒ 00:19:34.429 Awaish Kumar: Henry, I’m seeing, like, two different, functions.
123 00:19:34.650 ⇒ 00:19:37.219 Awaish Kumar: Destination function for successful order.
124 00:19:39.560 ⇒ 00:19:40.489 Henry Zhao: Say that again?
125 00:19:40.930 ⇒ 00:19:45.630 Awaish Kumar: I’m seeing two different functions. Can you go to the destinations? List of destinations?
126 00:19:46.180 ⇒ 00:19:47.810 Awaish Kumar: Not here.
127 00:19:48.080 ⇒ 00:19:50.399 Awaish Kumar: In the interesting discussions.
128 00:19:51.610 ⇒ 00:19:52.950 Henry Zhao: Existing destinations?
129 00:19:53.440 ⇒ 00:19:54.180 Awaish Kumar: Yep.
130 00:19:54.390 ⇒ 00:19:56.429 Awaish Kumar: And can we maybe scroll down?
131 00:20:01.440 ⇒ 00:20:02.530 Awaish Kumar: Hold on.
132 00:20:03.050 ⇒ 00:20:04.729 Awaish Kumar: Find catalysts, right?
133 00:20:06.980 ⇒ 00:20:07.660 Henry Zhao: Where?
134 00:20:08.450 ⇒ 00:20:12.500 Awaish Kumar: Yeah, it’s go up, like, there’s… There’s a destination for catalysts.
135 00:20:14.190 ⇒ 00:20:15.179 Henry Zhao: I created that, though.
136 00:20:15.180 ⇒ 00:20:18.020 Awaish Kumar: Yeah, yeah, these are two ones. Why is there… there are two?
137 00:20:18.730 ⇒ 00:20:21.059 Henry Zhao: I was just testing things, these ones I can delete.
138 00:20:36.390 ⇒ 00:20:37.250 Awaish Kumar: Oh, okay.
139 00:20:47.850 ⇒ 00:20:50.119 Awaish Kumar: Okay, so it’s working on my side.
140 00:20:52.010 ⇒ 00:20:53.250 Awaish Kumar: Can I open?
141 00:20:54.250 ⇒ 00:20:55.690 Awaish Kumar: Can I share my screen?
142 00:20:56.220 ⇒ 00:20:57.240 Henry Zhao: Yeah, sure.
143 00:20:59.840 ⇒ 00:21:02.529 Awaish Kumar: I’m in that other destination function.
144 00:21:02.860 ⇒ 00:21:07.150 Awaish Kumar: Right? I clicked on that, I found this model.
145 00:21:09.020 ⇒ 00:21:12.160 Awaish Kumar: I can click next. Now, what action do you need?
146 00:21:13.440 ⇒ 00:21:14.530 Henry Zhao: Centrac.
147 00:21:22.710 ⇒ 00:21:24.769 Awaish Kumar: And we want to add record.
148 00:21:26.350 ⇒ 00:21:30.929 Henry Zhao: Yeah, but this is the thing, it matches the segment profiles, and it’s not really a profile.
149 00:21:31.300 ⇒ 00:21:32.669 Henry Zhao: I tried this yesterday.
150 00:21:33.660 ⇒ 00:21:34.620 Awaish Kumar: Sorry?
151 00:21:34.880 ⇒ 00:21:40.669 Henry Zhao: I tried this yesterday, but this is sending to, profiles, and it’s not a profile, it’s literally just an event.
152 00:21:45.270 ⇒ 00:21:48.449 Henry Zhao: Like, it requires you to have some, like, unique identifier.
153 00:21:53.120 ⇒ 00:21:55.069 Henry Zhao: It’s fine if I add the user ID, I guess.
154 00:21:55.490 ⇒ 00:22:00.990 Awaish Kumar: Yeah, but we… We have a user ID.
155 00:22:01.630 ⇒ 00:22:06.709 Henry Zhao: Yeah, that’s fine. Let me quickly change the source to include the user ID, which I think I already have in Catalyst Successful Orders.
156 00:22:07.250 ⇒ 00:22:08.880 Henry Zhao: Hold on, let me second, let me…
157 00:22:10.860 ⇒ 00:22:17.370 Henry Zhao: Yeah, I have the user ID in there, and it should be the correct one. Yep, alright, that’s a good, good point. Let me add that real quick.
158 00:22:19.840 ⇒ 00:22:23.079 Awaish Kumar: So where… are you also here on this page?
159 00:22:23.670 ⇒ 00:22:26.200 Henry Zhao: No, no, one second, I’m gonna add user ID real quick.
160 00:22:26.710 ⇒ 00:22:27.690 Awaish Kumar: Oh, okay.
161 00:22:28.450 ⇒ 00:22:33.070 Henry Zhao: Alright, save query… Then I’m gonna make the unique identifier user ID.
162 00:22:33.770 ⇒ 00:22:35.089 Henry Zhao: Safe query…
163 00:22:35.280 ⇒ 00:22:39.890 Henry Zhao: Okay, now you should be able to map user ID to user ID. You might need a refresh, because I just made the change.
164 00:22:40.840 ⇒ 00:22:42.440 Awaish Kumar: Okay, I can…
165 00:22:46.020 ⇒ 00:22:47.219 Awaish Kumar: By the way up?
166 00:22:47.460 ⇒ 00:22:51.670 Awaish Kumar: The thing is, why we were not seeing it, like, when you were trying to map it.
167 00:22:52.870 ⇒ 00:22:54.780 Henry Zhao: No, I was seeing it, I just… it didn’t work.
168 00:22:57.750 ⇒ 00:23:00.949 Awaish Kumar: Yeah, but… But this is…
169 00:23:01.180 ⇒ 00:23:10.850 Awaish Kumar: get a successful order profile, like, is it the same connection you built for… Well, let’s try it. Let’s try it now that I’ve added user ID. Now that I think about it, this might work.
170 00:23:10.850 ⇒ 00:23:11.529 Henry Zhao: Yeah, go to a map.
171 00:23:11.530 ⇒ 00:23:19.469 Awaish Kumar: her profiles. This is recently even from this table. Oh, yeah. Yeah, but then why, like…
172 00:23:20.070 ⇒ 00:23:23.120 Henry Zhao: Let’s try it. Go to Add Mapping. Yeah, from the…
173 00:23:24.250 ⇒ 00:23:30.240 Awaish Kumar: I don’t… I don’t… I still don’t understand what did… what did you mean by ISPO files and not events?
174 00:23:31.870 ⇒ 00:23:42.720 Henry Zhao: It’s okay, because the destination function was looking for events, this is, like, updating someone’s profile. But that’s fine, I think this is okay, because now I’ve added user ID. So go to, yeah, go down to user ID,
175 00:23:44.380 ⇒ 00:23:46.650 Henry Zhao: Here, I can share my screen if you want me to edit this.
176 00:23:46.880 ⇒ 00:23:49.660 Awaish Kumar: No, no, it’s okay, I’m just reading.
177 00:23:52.140 ⇒ 00:23:53.680 Awaish Kumar: Okay.
178 00:23:54.390 ⇒ 00:23:59.399 Henry Zhao: Yeah, since we’re only paying on first-time orders, I think this could work, so if you put user ID and user ID…
179 00:24:00.370 ⇒ 00:24:01.920 Awaish Kumar: What about profile space?
180 00:24:01.920 ⇒ 00:24:03.880 Henry Zhao: Dev Eden, right, probably?
181 00:24:06.590 ⇒ 00:24:09.480 Henry Zhao: Event name, we can just call it Catalyst Success.
182 00:24:11.920 ⇒ 00:24:13.690 Henry Zhao: Just a static field, yeah.
183 00:24:18.490 ⇒ 00:24:22.129 Henry Zhao: No, no, you just type in title success, and it’ll just be the text stream, yeah.
184 00:24:26.100 ⇒ 00:24:27.490 Henry Zhao: There’s two C’s.
185 00:24:28.560 ⇒ 00:24:34.240 Awaish Kumar: Oh, catverse static values and functions?
186 00:24:38.630 ⇒ 00:24:39.400 Henry Zhao: Okay?
187 00:24:39.670 ⇒ 00:24:41.340 Henry Zhao: That’s it, you can just leave the box.
188 00:24:41.540 ⇒ 00:24:43.620 Henry Zhao: And then user ID is just user underscore ID.
189 00:24:45.920 ⇒ 00:24:47.640 Henry Zhao: There it is. Okay.
190 00:24:47.960 ⇒ 00:24:51.969 Henry Zhao: Alright, now you can scroll down to Properties and just add order ID and timestamp.
191 00:24:53.720 ⇒ 00:24:54.420 Awaish Kumar: Bye.
192 00:24:57.840 ⇒ 00:25:01.070 Henry Zhao: And then for destination field, I would call it Catalyst Order ID.
193 00:25:06.880 ⇒ 00:25:10.259 Henry Zhao: And then timestamp, catalyst, timestamp. Yeah, exactly.
194 00:25:18.980 ⇒ 00:25:21.999 Henry Zhao: Okay, now I can probably do sent test record to destination should work.
195 00:25:23.260 ⇒ 00:25:27.929 Henry Zhao: Okay. This is a way to do it. It’s a good idea. Let’s do it every hour, please.
196 00:25:31.170 ⇒ 00:25:32.589 Henry Zhao: Yeah, about every one hour.
197 00:25:37.880 ⇒ 00:25:39.100 Awaish Kumar: Okay?
198 00:25:45.290 ⇒ 00:25:47.240 Awaish Kumar: I can only digest this.
199 00:26:06.540 ⇒ 00:26:07.830 Awaish Kumar: Right.
200 00:26:08.880 ⇒ 00:26:10.140 Henry Zhao: Okay, I can share my screen now.
201 00:26:15.370 ⇒ 00:26:16.050 Awaish Kumar: Chrome.
202 00:26:16.050 ⇒ 00:26:17.250 Henry Zhao: And then when your design is done.
203 00:26:18.040 ⇒ 00:26:20.810 Awaish Kumar: Let me just… write a Chrome 4.
204 00:26:57.910 ⇒ 00:27:00.899 Awaish Kumar: What time zone, Eastern?
205 00:27:01.130 ⇒ 00:27:04.480 Henry Zhao: We just do it every hour, because I think we need it every hour to send two catalysts.
206 00:27:04.640 ⇒ 00:27:05.350 Henry Zhao: Yeah.
207 00:27:05.540 ⇒ 00:27:08.710 Awaish Kumar: It’s on the Eastern Nourle.
208 00:27:09.240 ⇒ 00:27:10.380 Henry Zhao: Eastern’s fine, yeah.
209 00:27:17.430 ⇒ 00:27:18.790 Awaish Kumar: Okay, bye.
210 00:27:43.130 ⇒ 00:27:44.889 Henry Zhao: I guess that’s it then, I guess…
211 00:27:46.320 ⇒ 00:27:49.160 Awaish Kumar: We can wait for the sync and see if the orders are…
212 00:27:49.340 ⇒ 00:27:58.500 Awaish Kumar: going, what… like, orders are flowing through, but what you have to verify is to go in the catalyst and see if…
213 00:27:59.250 ⇒ 00:28:03.110 Awaish Kumar: Orders are actually… Probably…
214 00:28:03.480 ⇒ 00:28:08.350 Henry Zhao: Well, it’s not, because we then need to use the JavaScript to send that value to Catalysts, using this…
215 00:28:08.630 ⇒ 00:28:09.530 Henry Zhao: function.
216 00:28:11.330 ⇒ 00:28:16.100 Henry Zhao: Like, we need to actually, we need to actually post it to this, webhook, this, endpoint.
217 00:28:20.300 ⇒ 00:28:21.620 Awaish Kumar: Oh, okay.
218 00:28:22.100 ⇒ 00:28:23.030 Henry Zhao: Does that make sense?
219 00:28:25.180 ⇒ 00:28:27.789 Awaish Kumar: So, currently, the distribution function, we…
220 00:28:29.450 ⇒ 00:28:35.530 Henry Zhao: just to send this event to Catalyst and say, okay, this order is paid. So right now, when I go to…
221 00:28:37.120 ⇒ 00:28:41.569 Henry Zhao: Yeah, I think it’s good I give you this explanation, so you understand what’s going on.
222 00:28:45.650 ⇒ 00:28:50.090 Henry Zhao: So right now, as I do the intake, right, there is a pixel that,
223 00:28:51.200 ⇒ 00:28:56.079 Henry Zhao: that, Catalyst has installed, right, so that they get the data of conversions.
224 00:28:56.890 ⇒ 00:28:58.240 Henry Zhao: And I’ll show you here.
225 00:28:58.400 ⇒ 00:28:59.110 Awaish Kumar: Okay.
226 00:29:10.900 ⇒ 00:29:11.740 Henry Zhao: Who’s this?
227 00:29:12.670 ⇒ 00:29:13.560 Henry Zhao: search bar.
228 00:29:15.170 ⇒ 00:29:17.540 Henry Zhao: So here they have this, like…
229 00:29:18.010 ⇒ 00:29:24.470 Henry Zhao: this Catalyst pixel that fires when the order’s completed, but it’s firing
230 00:29:27.820 ⇒ 00:29:32.190 Henry Zhao: Right now, before the order’s actually completed. It’s firing… come on.
231 00:29:35.290 ⇒ 00:29:36.120 Henry Zhao: Oh my gosh.
232 00:30:03.360 ⇒ 00:30:04.579 Henry Zhao: Why are so many questions?
233 00:30:04.730 ⇒ 00:30:05.350 Awaish Kumar: Perfect.
234 00:30:09.340 ⇒ 00:30:10.060 Awaish Kumar: Clerp?
235 00:30:14.200 ⇒ 00:30:20.680 Henry Zhao: So it’s firing here on the payment screen, and it still will fire, but it’s gonna fire now as a…
236 00:30:20.820 ⇒ 00:30:27.039 Henry Zhao: status of pending, okay? So that way we stop paying them for things that are only at this point.
237 00:30:27.580 ⇒ 00:30:35.679 Henry Zhao: Okay, so it’s gonna fire as pending, so it’s still gonna have a row here under conversions as pending, but we’re not gonna pay anything where the conversion status is pending.
238 00:30:35.790 ⇒ 00:30:38.710 Henry Zhao: But then, they need to figure out what we actually pay them, right?
239 00:30:38.910 ⇒ 00:30:46.790 Henry Zhao: So… when I submit this, They’re gonna hate me for submitting so many orders.
240 00:30:46.930 ⇒ 00:30:49.989 Henry Zhao: Then this pixel should be still there.
241 00:30:54.200 ⇒ 00:31:00.089 Henry Zhao: Yeah, it should still, so, still should be there. It’s still tracking, tracking, tracking, which now I have a new information we need to work on.
242 00:31:00.300 ⇒ 00:31:04.279 Henry Zhao: Once I get to here, this thank you page.
243 00:31:08.470 ⇒ 00:31:17.030 Henry Zhao: it’s not there anymore, does that make sense? So, the pixel is not there anymore, so we need to say, from this page, we need to send to this
244 00:31:17.310 ⇒ 00:31:19.530 Henry Zhao: Endpoint, which is,
245 00:31:19.850 ⇒ 00:31:25.950 Henry Zhao: this endpoint here, this DB rep offers blah blah blah, that it’s actually paid. So that’s why I’m actually sending
246 00:31:28.640 ⇒ 00:31:32.240 Henry Zhao: that the event is actually paid. I’m changing the order status to paid.
247 00:31:32.470 ⇒ 00:31:32.860 Awaish Kumar: Okay.
248 00:31:32.860 ⇒ 00:31:34.999 Henry Zhao: So that this conversion status becomes paid.
249 00:31:35.540 ⇒ 00:31:44.019 Henry Zhao: And this is something… this is what Basque added. So Basque, instead of adding a GTM container, because they said they cannot, they added an up… they fire, like, order updated.
250 00:31:45.270 ⇒ 00:31:46.810 Henry Zhao: Where the…
251 00:31:50.320 ⇒ 00:31:54.719 Henry Zhao: the order updated should become completed. So that’s what that table that I have in…
252 00:31:55.040 ⇒ 00:31:56.919 Henry Zhao: Catalyst Successful Orders does.
253 00:31:57.200 ⇒ 00:32:00.320 Awaish Kumar: Okay, I got that point, that…
254 00:32:00.420 ⇒ 00:32:05.109 Awaish Kumar: you got some event from PASC, and then you created a table, which.
255 00:32:05.700 ⇒ 00:32:11.869 Awaish Kumar: Only, selects the orders, which are finally, like, paid.
256 00:32:12.910 ⇒ 00:32:14.080 Awaish Kumar: from Catalyst.
257 00:32:14.380 ⇒ 00:32:21.380 Awaish Kumar: And then, now, what we just did with this, by destination, like, the mapping.
258 00:32:21.890 ⇒ 00:32:25.070 Awaish Kumar: Isn’t it sending those to Catlas, or…
259 00:32:25.990 ⇒ 00:32:28.440 Henry Zhao: Well, say that again? What… say that again?
260 00:32:28.730 ⇒ 00:32:34.970 Awaish Kumar: So, like, you already created that model, right? Yeah. Right now, we also added a mapping.
261 00:32:35.340 ⇒ 00:32:38.360 Awaish Kumar: Yeah. Did that not work? That’s my question.
262 00:32:39.800 ⇒ 00:32:45.499 Henry Zhao: Yeah, and now, from Matthias’s point, he also needs to send the product, because what’s happening is…
263 00:32:45.610 ⇒ 00:32:59.360 Henry Zhao: they are, like, charging us for GLP1, because that’s the intake they came in from, but they’re buying NAD+, so… that’s gonna also mess up our product ROAS table, because we’re paying in GLP1, they’re buying NAD+,
264 00:32:59.380 ⇒ 00:33:08.099 Henry Zhao: So the NAD Plus is gonna have revenue, and then the cost is gonna go to GLP-1, so our NCAC is going to still be wrong, which is the issue that Qatar is trying to solve.
265 00:33:08.300 ⇒ 00:33:10.879 Henry Zhao: So, we need to somehow also send them
266 00:33:11.040 ⇒ 00:33:15.710 Henry Zhao: Maybe product name, and then have them map it to, like, their product
267 00:33:15.920 ⇒ 00:33:22.580 Henry Zhao: That they’re charging us for, and making sure that that matches, or we pay them for whatever product they end up purchasing. Does that make sense?
268 00:33:23.190 ⇒ 00:33:27.309 Awaish Kumar: Yes. So, my question is that the mapping we did.
269 00:33:27.420 ⇒ 00:33:32.160 Awaish Kumar: Is it, like, like, that’s what we need to do, or is there anything else?
270 00:33:33.190 ⇒ 00:33:36.389 Henry Zhao: We need to send it to Catalyst, and now we need to also send the product name somehow.
271 00:33:36.840 ⇒ 00:33:46.009 Awaish Kumar: Yeah, we can do it, right? In the… like, the… we just send the user ID in properties, you send the timestamp in the properties, we can add, like.
272 00:33:46.010 ⇒ 00:33:49.020 Henry Zhao: I don’t think there’s user ID here. I asked them about that,
273 00:33:49.160 ⇒ 00:33:51.109 Henry Zhao: If there’s user ID here, then I think we can.
274 00:33:55.560 ⇒ 00:33:59.430 Henry Zhao: Let me schedule another call with the engineers, because I think this is…
275 00:33:59.660 ⇒ 00:34:03.579 Henry Zhao: If we can get that… I think I need to talk to the engineers, because I’ve done my part.
276 00:34:04.140 ⇒ 00:34:11.270 Awaish Kumar: But, like… Do you mean, like, agent engineers, or who…
277 00:34:11.429 ⇒ 00:34:14.249 Henry Zhao: Catalyst engineers. I just need to know what I can send to them.
278 00:34:14.739 ⇒ 00:34:19.409 Awaish Kumar: Okay, we… so there is no docs on what we can send?
279 00:34:20.290 ⇒ 00:34:23.270 Henry Zhao: Oh, there it is, I can show you. Let’s go. Let’s look at that together.
280 00:34:26.739 ⇒ 00:34:28.270 Henry Zhao: It’s here.
281 00:34:30.920 ⇒ 00:34:32.260 Henry Zhao: Nope, it’s here.
282 00:34:33.409 ⇒ 00:34:35.149 Henry Zhao: Oh, here, I got a solder.
283 00:34:35.790 ⇒ 00:34:36.610 Henry Zhao: Nope.
284 00:34:39.350 ⇒ 00:34:39.780 Awaish Kumar: Oh, boy.
285 00:34:40.239 ⇒ 00:34:41.899 Henry Zhao: Not that one. Sorry, one second.
286 00:34:43.380 ⇒ 00:34:44.679 Henry Zhao: There’s documentation.
287 00:34:52.270 ⇒ 00:34:57.929 Henry Zhao: The thing is, I think they made a specific sec- like, use case for us, so it might not be…
288 00:34:58.230 ⇒ 00:35:08.450 Henry Zhao: Exactly… the out-of-the-box… Thank you, page tracking.
289 00:35:15.940 ⇒ 00:35:19.890 Awaish Kumar: Like, can you send me this? I can read it if I find it.
290 00:35:20.070 ⇒ 00:35:23.960 Awaish Kumar: And, in the meantime,
291 00:35:24.380 ⇒ 00:35:28.050 Awaish Kumar: If also, like, if there’s any API through which.
292 00:35:28.500 ⇒ 00:35:34.050 Awaish Kumar: Let me know, like, we can write a… write a script, we don’t… Always happy.
293 00:35:34.050 ⇒ 00:35:34.570 Henry Zhao: API.
294 00:35:34.570 ⇒ 00:35:35.289 Awaish Kumar: We don’t always.
295 00:35:35.290 ⇒ 00:35:42.010 Henry Zhao: We talked about this yesterday, and this is the only way. This post endpoint or JavaScript is the only way.
296 00:35:42.010 ⇒ 00:35:45.360 Awaish Kumar: What I’m saying is…
297 00:35:46.400 ⇒ 00:35:55.289 Awaish Kumar: like, that post endpoint, if I get the documentation of that, I can read through it, maybe we can find something, because…
298 00:35:55.420 ⇒ 00:36:05.449 Awaish Kumar: Yeah, I can read it then. If we can send some product ID or anything, I will let you know, and we can just enhance the JavaScript function. That’s it.
299 00:36:05.450 ⇒ 00:36:06.100 Henry Zhao: Okay.
300 00:36:06.340 ⇒ 00:36:07.600 Awaish Kumar: Okay, thank you.
301 00:36:07.600 ⇒ 00:36:08.720 Henry Zhao: Okay, thank you.