Meeting Title: Shopify Attribution Data Analysis Sync Date: 2025-10-01 Meeting participants: Awaish Kumar, Demilade Agboola
WEBVTT
1 00:03:14.360 ⇒ 00:03:15.370 Demilade Agboola: Oh, ish.
2 00:03:24.870 ⇒ 00:03:25.760 Awaish Kumar: Hello?
3 00:03:26.460 ⇒ 00:03:27.440 Demilade Agboola: How are you?
4 00:03:28.010 ⇒ 00:03:29.320 Awaish Kumar: Okay, can you hear me?
5 00:03:30.140 ⇒ 00:03:31.040 Demilade Agboola: Here’s a con.
6 00:03:31.520 ⇒ 00:03:32.300 Demilade Agboola: Okay.
7 00:03:33.930 ⇒ 00:03:41.500 Awaish Kumar: But I… yeah, like, what she said, if we are able to get that feel, like, we don’t need North Beach.
8 00:03:43.200 ⇒ 00:03:46.200 Demilade Agboola: So, yeah, there’s a field…
9 00:03:47.070 ⇒ 00:03:55.349 Demilade Agboola: again, because I’ve been hopping across projects, I’d forgotten. But yeah, there’s a field called Referring Site, which I had built into Fact Orders.
10 00:03:55.620 ⇒ 00:03:56.100 Awaish Kumar: Okay.
11 00:03:56.100 ⇒ 00:03:58.939 Demilade Agboola: effective.
12 00:03:59.250 ⇒ 00:04:05.640 Awaish Kumar: But she was mentioning, also, Something like in the customer journey, there’s…
13 00:04:06.030 ⇒ 00:04:08.269 Awaish Kumar: Is that the only field there, or…
14 00:04:11.620 ⇒ 00:04:12.109 Awaish Kumar: They’re gonna look.
15 00:04:12.110 ⇒ 00:04:15.960 Demilade Agboola: In terms of… The factoid in this.
16 00:04:15.960 ⇒ 00:04:17.690 Awaish Kumar: That’s what he was mentioning.
17 00:04:18.370 ⇒ 00:04:25.859 Awaish Kumar: Like, the… she was mentioning there’s a table on top of it, you have built the fact orders. There’s a field quality.
18 00:04:26.630 ⇒ 00:04:31.629 Demilade Agboola: Yeah, I’m not… I’m not sure about that. Give me one second.
19 00:04:32.260 ⇒ 00:04:32.990 Awaish Kumar: Okay.
20 00:04:34.080 ⇒ 00:04:43.479 Awaish Kumar: Maybe in the referring… referral side, Hmm, can we… Ronakiri, and… Pretty good online.
21 00:04:44.650 ⇒ 00:04:46.999 Awaish Kumar: Like, if you’re getting big chunk
22 00:04:47.540 ⇒ 00:04:54.119 Awaish Kumar: assigned to, like, Instagram, TikTok, Facebook, That is good enough, right?
23 00:04:56.280 ⇒ 00:04:57.370 Awaish Kumar: What did you say?
24 00:04:57.370 ⇒ 00:05:01.810 Demilade Agboola: Yeah, I think it depends on… Oh.
25 00:05:02.930 ⇒ 00:05:08.790 Demilade Agboola: what are we looking for in Northbeam, and where are they running campaigns, you know, so we can then compare.
26 00:05:09.030 ⇒ 00:05:15.569 Awaish Kumar: I just read in the North Beam data, North Beam, Document.
27 00:05:15.680 ⇒ 00:05:25.989 Awaish Kumar: From Utam, and it exactly mentions, if we are able to get… like, in Basque borders in India, basically, we get this UTM source, right?
28 00:05:26.270 ⇒ 00:05:27.180 Awaish Kumar: We don’t care…
29 00:05:27.180 ⇒ 00:05:27.950 Demilade Agboola: Yeah.
30 00:05:28.230 ⇒ 00:05:29.700 Awaish Kumar: We don’t care about…
31 00:05:29.830 ⇒ 00:05:37.290 Awaish Kumar: whatever is in Northwind, right? We just… from Northwind, we just get spend data, and then we, get.
32 00:05:37.290 ⇒ 00:05:38.969 Demilade Agboola: Attributes it to about the same.
33 00:05:39.180 ⇒ 00:05:46.029 Awaish Kumar: And we get orders from sales data, and the sales data, basically, all the order data come with UTM source, and we use that
34 00:05:46.510 ⇒ 00:05:51.590 Awaish Kumar: To say, okay, what is the conversion on this platform? Similarly here.
35 00:05:51.590 ⇒ 00:05:52.170 Demilade Agboola: Yeah.
36 00:05:52.170 ⇒ 00:06:01.610 Awaish Kumar: UTM source, or some kind of referral site, for example. If it can give us, like, okay, 50% of our orders came from
37 00:06:01.810 ⇒ 00:06:05.970 Awaish Kumar: Reference site is not ticked off, then that’s basically what we want.
38 00:06:09.310 ⇒ 00:06:12.700 Demilade Agboola: Yeah, so we have the referring site already there, so this is where…
39 00:06:13.370 ⇒ 00:06:17.479 Awaish Kumar: Frank side, yeah, that’s what I’m… yeah, we also have UTM Source.
40 00:06:17.860 ⇒ 00:06:18.620 Awaish Kumar: See?
41 00:06:18.620 ⇒ 00:06:19.650 Demilade Agboola: Yes.
42 00:06:19.900 ⇒ 00:06:23.330 Demilade Agboola: I’m trying to see if I can see the user.
43 00:06:23.700 ⇒ 00:06:25.909 Awaish Kumar: Do we have UTM source in the visits fields.
44 00:06:26.270 ⇒ 00:06:32.650 Awaish Kumar: UT Parameters, source, medium, Referral URL, like, all these.
45 00:06:32.650 ⇒ 00:06:36.330 Demilade Agboola: Oh, yeah, yeah, yeah. Yeah, so we have the ETM process source.
46 00:06:36.630 ⇒ 00:06:38.500 Awaish Kumar: I don’t have access if… if…
47 00:06:38.730 ⇒ 00:06:44.839 Awaish Kumar: if you can just use Refing site, and see how the…
48 00:06:45.000 ⇒ 00:06:52.609 Awaish Kumar: like, select count order, like, select distinct order ID, and… For each roofing site.
49 00:06:52.720 ⇒ 00:07:07.070 Awaish Kumar: Instagram, Facebook, like, if we group by and see if the numbers look good there, or if we could use UTM Source itself, if we could just run two, three queries and figure out what is the way to go, and we can just close this spike now.
50 00:07:17.870 ⇒ 00:07:18.660 Awaish Kumar: No.
51 00:07:18.990 ⇒ 00:07:24.170 Awaish Kumar: It just takes… referring site might need some cleaner… cleanup, as we do in…
52 00:07:24.670 ⇒ 00:07:28.870 Awaish Kumar: Eden, because maybe Instagram have 3 different ways of sending.
53 00:07:28.870 ⇒ 00:07:29.580 Demilade Agboola: excuse me.
54 00:07:29.710 ⇒ 00:07:31.960 Demilade Agboola: Yeah, the people.
55 00:07:32.870 ⇒ 00:07:33.980 Demilade Agboola: Perfect.
56 00:07:36.490 ⇒ 00:07:37.280 Awaish Kumar: Yeah.
57 00:07:39.790 ⇒ 00:07:40.350 Demilade Agboola: Okay.
58 00:07:41.180 ⇒ 00:07:41.850 Demilade Agboola: Thank you.
59 00:07:42.240 ⇒ 00:07:42.890 Awaish Kumar: Great.
60 00:07:44.460 ⇒ 00:07:45.680 Awaish Kumar: of the quarterback.
61 00:07:46.330 ⇒ 00:07:49.390 Demilade Agboola: I’m guessing it’s probably Shopify.
62 00:07:50.550 ⇒ 00:07:52.170 Demilade Agboola: Right, just…
63 00:07:53.700 ⇒ 00:07:54.910 Awaish Kumar: Okay.
64 00:07:59.060 ⇒ 00:08:04.100 Awaish Kumar: Okay, a lot of it is null, some of it is urban stems itself.
65 00:08:04.560 ⇒ 00:08:07.610 Awaish Kumar: Then we have Google, then we have Shopify itself.
66 00:08:09.230 ⇒ 00:08:10.120 Demilade Agboola: I don’t.
67 00:08:11.080 ⇒ 00:08:12.340 Awaish Kumar: That’s also none.
68 00:08:12.920 ⇒ 00:08:15.610 Awaish Kumar: from Facebook, it’s very low.
69 00:08:17.040 ⇒ 00:08:18.660 Awaish Kumar: Clear.
70 00:08:18.670 ⇒ 00:08:19.180 Demilade Agboola: Great.
71 00:08:19.180 ⇒ 00:08:19.960 Awaish Kumar: Okay, good.
72 00:08:20.820 ⇒ 00:08:22.310 Awaish Kumar: So, Rakuten.
73 00:08:23.060 ⇒ 00:08:24.020 Awaish Kumar: Can we go.
74 00:08:24.350 ⇒ 00:08:25.379 Awaish Kumar: a little bit…
75 00:08:25.710 ⇒ 00:08:31.740 Demilade Agboola: Let me check… let me check North Beam and see what… where they spend money on campaigns.
76 00:08:31.960 ⇒ 00:08:34.740 Demilade Agboola: That gives you an idea of what they should be expecting.
77 00:08:34.789 ⇒ 00:08:39.680 Awaish Kumar: Or can we just use… UTM parameter source. Maybe that’s…
78 00:08:40.370 ⇒ 00:08:42.840 Awaish Kumar: In the same query, just use that.
79 00:08:43.830 ⇒ 00:08:47.039 Demilade Agboola: Yeah, well, I’m not sure…
80 00:08:47.680 ⇒ 00:08:49.179 Awaish Kumar: And this is what Eden.
81 00:08:50.920 ⇒ 00:08:52.740 Awaish Kumar: This is definitely crazy.
82 00:09:03.400 ⇒ 00:09:08.330 Demilade Agboola: But for the UTM parameter source… It’s…
83 00:09:08.330 ⇒ 00:09:13.040 Awaish Kumar: Try running a query, it won’t… Maybe it solves our problem?
84 00:09:14.380 ⇒ 00:09:20.730 Demilade Agboola: Okay, so it’s… visits without staging customer visits… staging customer journey.
85 00:09:37.360 ⇒ 00:09:38.490 Demilade Agboola: Okay.
86 00:09:38.760 ⇒ 00:09:40.210 Awaish Kumar: Oral visit. Okay.
87 00:09:40.240 ⇒ 00:09:42.579 Demilade Agboola: Customer visit, that means it’s…
88 00:09:42.950 ⇒ 00:09:48.510 Awaish Kumar: It’s for the… Yeah, I’m like… customer came
89 00:09:48.660 ⇒ 00:09:53.600 Awaish Kumar: Yeah, but is it, like, I don’t know if it’s first UTM or last, like.
90 00:09:55.620 ⇒ 00:09:59.310 Demilade Agboola: Yeah, so that’s what… that’s why… I’m trying to see…
91 00:09:59.310 ⇒ 00:10:02.890 Awaish Kumar: If you go down, it’s… there is some last…
92 00:10:03.040 ⇒ 00:10:05.350 Awaish Kumar: Visit IT and first visit ID, or something.
93 00:10:06.720 ⇒ 00:10:07.530 Demilade Agboola: Yeah.
94 00:10:08.100 ⇒ 00:10:09.820 Awaish Kumar: Copy, maybe?
95 00:10:13.120 ⇒ 00:10:14.880 Awaish Kumar: Let’s maybe try.
96 00:10:16.790 ⇒ 00:10:17.740 Awaish Kumar: Running.
97 00:10:17.920 ⇒ 00:10:19.380 Awaish Kumar: That could be…
98 00:10:19.380 ⇒ 00:10:22.880 Demilade Agboola: the UTM parameter source, let’s see.
99 00:10:25.230 ⇒ 00:10:29.569 Awaish Kumar: Yeah, yeah, but, like, we can say, like, for… for this customer, let’s…
100 00:10:31.040 ⇒ 00:10:33.319 Awaish Kumar: We can figure out, like, if it is…
101 00:10:33.610 ⇒ 00:10:38.259 Awaish Kumar: Same for each order, or it’s changing across orders of the same customer, then…
102 00:10:39.290 ⇒ 00:10:42.399 Awaish Kumar: Like, we can just verify that as well.
103 00:10:44.390 ⇒ 00:10:50.660 Demilade Agboola: Yeah, so what I’m thinking, because I’m looking at it now, it seems we have customer base…
104 00:10:51.480 ⇒ 00:10:55.870 Demilade Agboola: Did we get to customize… Order ID…
105 00:10:59.160 ⇒ 00:11:00.720 Demilade Agboola: And then…
106 00:11:03.950 ⇒ 00:11:06.929 Demilade Agboola: Yeah, so each… it appears that each order.
107 00:11:09.780 ⇒ 00:11:14.700 Awaish Kumar: Yeah, so if it is for each order, and if we are getting UTM sold… And then…
108 00:11:14.700 ⇒ 00:11:16.250 Demilade Agboola: Manage visits, yeah.
109 00:11:17.250 ⇒ 00:11:19.920 Awaish Kumar: Let’s… let’s see what are the values.
110 00:11:21.080 ⇒ 00:11:24.219 Demilade Agboola: Okay, so I just count by distinct surrogate key.
111 00:11:25.610 ⇒ 00:11:27.170 Demilade Agboola: facilities, yeah.
112 00:11:30.310 ⇒ 00:11:31.040 Awaish Kumar: Hmm.
113 00:11:35.410 ⇒ 00:11:36.150 Demilade Agboola: Really?
114 00:11:36.600 ⇒ 00:11:37.650 Awaish Kumar: Distance arrival?
115 00:11:37.650 ⇒ 00:11:38.620 Demilade Agboola: It takes…
116 00:11:39.260 ⇒ 00:11:39.850 Awaish Kumar: Damn.
117 00:11:42.670 ⇒ 00:11:46.810 Demilade Agboola: And it’s comma… I’m using tech one.
118 00:11:47.500 ⇒ 00:11:48.250 Awaish Kumar: Okay.
119 00:11:51.810 ⇒ 00:11:56.530 Demilade Agboola: It’s my web, sorry. Yeah, I just was not… I was not paying attention.
120 00:11:56.690 ⇒ 00:12:02.620 Awaish Kumar: Okay, goodbye. Yeah, I do the…
121 00:12:15.510 ⇒ 00:12:16.490 Awaish Kumar: Oh, it’s phenomenal.
122 00:12:16.490 ⇒ 00:12:17.240 Demilade Agboola: Okay.
123 00:12:17.850 ⇒ 00:12:27.880 Awaish Kumar: So we have Google, Yeah, basically, like, in the first stage, We can… We can share this.
124 00:12:28.910 ⇒ 00:12:31.319 Awaish Kumar: And, and it didn’t rise.
125 00:12:31.560 ⇒ 00:12:38.500 Awaish Kumar: for example, for the Google, first time, like, there’s no… make sure there’s no duplication.
126 00:12:38.600 ⇒ 00:12:39.450 Awaish Kumar: maybe using.
127 00:12:39.450 ⇒ 00:12:40.000 Demilade Agboola: Yeah.
128 00:12:40.000 ⇒ 00:12:40.600 Awaish Kumar: E.
129 00:12:41.220 ⇒ 00:12:53.199 Awaish Kumar: We can standardize name if, like, there are multiple variations of same thing, but then we can share that with them, right? And if then they say, okay, there’s a lot of null, and we need more…
130 00:12:53.530 ⇒ 00:12:54.260 Awaish Kumar: Bye.
131 00:12:54.470 ⇒ 00:12:59.209 Awaish Kumar: We want to improve that, or things like that. That’s the second stage of it, right?
132 00:13:00.340 ⇒ 00:13:02.829 Demilade Agboola: Yeah, so I want to see…
133 00:13:03.620 ⇒ 00:13:12.759 Demilade Agboola: what it looks like, or… like, I want to know if the null is because things… this… if the null has been present before this year.
134 00:13:13.930 ⇒ 00:13:15.190 Awaish Kumar: Let me see.
135 00:13:15.740 ⇒ 00:13:20.379 Demilade Agboola: Like, if it’s a recent thing, or if, like, even the recent data has a lot of null.
136 00:13:20.380 ⇒ 00:13:21.110 Awaish Kumar: Understood.
137 00:13:21.110 ⇒ 00:13:24.189 Demilade Agboola: I see orders created at…
138 00:13:29.130 ⇒ 00:13:36.630 Awaish Kumar: Okay, we wanna… It was greater than 2020… January 2025, yeah.
139 00:13:41.240 ⇒ 00:13:42.180 Demilade Agboola: Paris.
140 00:13:42.180 ⇒ 00:13:43.170 Awaish Kumar: ES data.
141 00:13:43.170 ⇒ 00:13:43.800 Demilade Agboola: Excellent.
142 00:13:47.210 ⇒ 00:13:47.785 Demilade Agboola: B…
143 00:13:55.740 ⇒ 00:13:57.379 Demilade Agboola: Crystal of Knowles.
144 00:13:59.590 ⇒ 00:14:03.120 Awaish Kumar: Let’s try… Okay.
145 00:14:03.990 ⇒ 00:14:12.329 Demilade Agboola: I just want to get an idea of, yeah, still a lot of nulls. Okay, so it’s a current issue, still an ongoing issue, where there are a lot of nulls.
146 00:14:12.880 ⇒ 00:14:15.000 Awaish Kumar: Yeah, let’s say, let’s say less than…
147 00:14:15.760 ⇒ 00:14:19.209 Awaish Kumar: Date is less than 1st January 2025.
148 00:14:23.300 ⇒ 00:14:24.890 Demilade Agboola: The social is exposure.
149 00:14:24.910 ⇒ 00:14:31.000 Awaish Kumar: Data, yeah, older data, like, for the past data outlooks. When you say date, less than.
150 00:14:32.290 ⇒ 00:14:34.070 Awaish Kumar: It’s still greater, yeah.
151 00:14:34.610 ⇒ 00:14:36.859 Awaish Kumar: What is… what is the historical train?
152 00:14:37.980 ⇒ 00:14:42.579 Awaish Kumar: Can you remove… Date is less than…
153 00:14:45.750 ⇒ 00:14:52.060 Awaish Kumar: Yeah, I wanna see… date, created date, is less than January 2025.
154 00:14:53.650 ⇒ 00:14:55.070 Demilade Agboola: Okay, less than…
155 00:14:55.590 ⇒ 00:14:56.210 Awaish Kumar: Yeah.
156 00:14:56.870 ⇒ 00:15:00.140 Awaish Kumar: I want to see how it looked before.
157 00:15:05.650 ⇒ 00:15:08.719 Awaish Kumar: Okay, before that, it was really…
158 00:15:08.870 ⇒ 00:15:11.349 Awaish Kumar: Are they in business recently, or…
159 00:15:12.600 ⇒ 00:15:16.160 Demilade Agboola: Oh, no, no, they’ve been… but they migrated to Shopify.
160 00:15:16.570 ⇒ 00:15:19.689 Demilade Agboola: November of last year, if I remember correctly.
161 00:15:20.510 ⇒ 00:15:23.280 Awaish Kumar: Yeah, let’s see for Shopify only.
162 00:15:24.210 ⇒ 00:15:27.929 Awaish Kumar: Is that null coming from for Shopify only, or…
163 00:15:28.240 ⇒ 00:15:28.800 Awaish Kumar: Thank you.
164 00:15:28.800 ⇒ 00:15:34.569 Demilade Agboola: So right now, this… this… yeah, this is Shopify data. This is Shopify data that we’re using right now.
165 00:15:34.700 ⇒ 00:15:37.929 Awaish Kumar: Okay, all the data is Shopify. So, we are saying… No.
166 00:15:39.110 ⇒ 00:15:42.060 Demilade Agboola: So before, they had data before Shopify.
167 00:15:42.450 ⇒ 00:15:49.369 Demilade Agboola: But we’re building the current system based off Shopify data, because they migrated Shopify late last year.
168 00:15:50.400 ⇒ 00:15:54.599 Awaish Kumar: Last year means in 2024, they were on Shopify, right?
169 00:15:55.580 ⇒ 00:15:59.450 Demilade Agboola: it moves to Shopify 2020… November 2024.
170 00:16:00.580 ⇒ 00:16:03.500 Awaish Kumar: Okay, that makes sense, but we are seeing.
171 00:16:03.500 ⇒ 00:16:10.479 Demilade Agboola: So that’s why… Yes, that’s why some of the attributions and setups have not been properly done until…
172 00:16:11.630 ⇒ 00:16:12.210 Demilade Agboola: This year?
173 00:16:13.360 ⇒ 00:16:15.769 Awaish Kumar: So I… we can… we can say, like.
174 00:16:16.160 ⇒ 00:16:27.809 Awaish Kumar: Starting 2025, a lot of orders are being attributed, and we can show them the data, but still, a lot of them are nulls.
175 00:16:28.040 ⇒ 00:16:34.090 Awaish Kumar: We can also share that, and then we can figure out if there is
176 00:16:35.000 ⇒ 00:16:42.339 Awaish Kumar: Then we can, basically say, if we want to improve that attribution, we might need some
177 00:16:42.630 ⇒ 00:16:46.250 Awaish Kumar: someone like Henry or Zoran to come and help.
178 00:16:46.420 ⇒ 00:16:49.670 Awaish Kumar: Them, if they don’t have any… Oh.
179 00:16:50.140 ⇒ 00:16:51.839 Awaish Kumar: Any developer like that.
180 00:16:53.410 ⇒ 00:16:57.670 Demilade Agboola: Yeah, so I know this… yeah, there’s a lot of mates here.
181 00:17:00.110 ⇒ 00:17:02.220 Demilade Agboola: I know they had…
182 00:17:02.330 ⇒ 00:17:09.640 Demilade Agboola: These are some of their older models, but we’re trying to see… I’m trying to see if they had any, like.
183 00:17:11.200 ⇒ 00:17:13.700 Demilade Agboola: Way to tell where people are coming from.
184 00:17:16.010 ⇒ 00:17:16.920 Awaish Kumar: Okay.
185 00:17:16.920 ⇒ 00:17:18.039 Demilade Agboola: Over this thing.
186 00:17:19.240 ⇒ 00:17:20.770 Demilade Agboola: website sentiment.
187 00:17:20.940 ⇒ 00:17:21.690 Demilade Agboola: Right.
188 00:17:23.050 ⇒ 00:17:27.659 Demilade Agboola: But their old models are really, really bad, which is why we’re building new models for them.
189 00:17:28.569 ⇒ 00:17:30.149 Awaish Kumar: And what about.
190 00:17:49.350 ⇒ 00:17:53.700 Demilade Agboola: No, this is why they sent… yeah, why they sent the…
191 00:17:54.930 ⇒ 00:17:57.340 Demilade Agboola: the card. So it’s not that.
192 00:17:58.510 ⇒ 00:18:07.300 Demilade Agboola: Yeah, so I think this is where we can see from. I would ask Emily if there’s any other place we could… but I think this is it. This is what we had with, like.
193 00:18:07.970 ⇒ 00:18:10.450 Awaish Kumar: Yeah, but…
194 00:18:10.790 ⇒ 00:18:18.619 Awaish Kumar: For the shop, like, the bottom of the spike says he has confirmed from North VM team that
195 00:18:18.910 ⇒ 00:18:27.139 Awaish Kumar: We are not able to get attribution data for Shopify from using Northwam APIs.
196 00:18:28.090 ⇒ 00:18:45.530 Awaish Kumar: Right? If that is the case, then this is our only way to do it, right? And using UTM source from Shopify itself, and this is giving us the… this is the result from that. We can show them, we can get it.
197 00:18:47.260 ⇒ 00:18:56.479 Awaish Kumar: And this is the way to do it, but still, like, maybe 50% of the orders, or maybe 60% or 50% is unattributed.
198 00:18:56.860 ⇒ 00:19:05.099 Awaish Kumar: And yeah, then we can ask them, like, if… if they want… Us to focus on…
199 00:19:06.900 ⇒ 00:19:14.720 Awaish Kumar: attribution part as well. That might be we can, like, on the Shopify, like, something, and we can involve
200 00:19:14.870 ⇒ 00:19:16.170 Awaish Kumar: the Zoran directly.
201 00:19:16.170 ⇒ 00:19:16.830 Demilade Agboola: Yeah.
202 00:19:16.830 ⇒ 00:19:24.470 Awaish Kumar: Yes. But that’s what… But I think, that’s my idea. If you have a different opinion, Freakin’…
203 00:19:24.640 ⇒ 00:19:35.070 Demilade Agboola: Yeah, I think, yeah, I think that’s fine. I think, we can show them these numbers, I agree. It allows us to be able to see if they start putting campaigns in.
204 00:19:35.260 ⇒ 00:19:42.090 Demilade Agboola: we can start to see how much was spent, and how… what the UTM parameters, and how… how that has converted to…
205 00:19:42.520 ⇒ 00:19:43.730 Demilade Agboola: revenue.
206 00:19:44.280 ⇒ 00:19:47.320 Demilade Agboola: And so they can start to see how well.
207 00:19:47.870 ⇒ 00:19:57.739 Awaish Kumar: But when, like, if they are, like, obviously they are setting up these in some… somewhere in Shopify, right? The UTM parameters.
208 00:19:58.370 ⇒ 00:20:05.790 Awaish Kumar: And they’re not being tracked for all these orders. And we can, like, sell them that
209 00:20:05.910 ⇒ 00:20:14.690 Awaish Kumar: Okay, we have experts who can basically come in and help you with better attribution, if you want, and… but the current… this is the current
210 00:20:15.450 ⇒ 00:20:17.560 Awaish Kumar: scenario, and…
211 00:20:18.260 ⇒ 00:20:30.139 Awaish Kumar: 50% of our orders are everywhere, and we can help with this. And maybe you can put that in Notion Doc, which maybe you already have access to, shared by…
212 00:20:30.390 ⇒ 00:20:32.279 Awaish Kumar: Amber and Utong?
213 00:20:32.540 ⇒ 00:20:33.609 Awaish Kumar: I haven’t sure…
214 00:20:33.610 ⇒ 00:20:34.030 Demilade Agboola: Yeah.
215 00:20:34.030 ⇒ 00:20:43.699 Awaish Kumar: You can just add everything, what we just talked about, and and the data from… From this redshift.
216 00:20:43.850 ⇒ 00:20:47.750 Awaish Kumar: And then, like, basically we can share that with client.
217 00:20:48.540 ⇒ 00:20:53.389 Awaish Kumar: And get their feedback. Maybe… maybe ask of them to review if it happens, too.
218 00:20:55.350 ⇒ 00:20:59.249 Demilade Agboola: Okay, I’m writing this in a document now.
219 00:21:01.580 ⇒ 00:21:05.450 Awaish Kumar: Yeah, that’s what I think we should be doing.
220 00:21:05.810 ⇒ 00:21:09.290 Awaish Kumar: Right? Like, I don’t… Think of any other approach.
221 00:21:16.930 ⇒ 00:21:18.579 Awaish Kumar: Okay, are we good?
222 00:21:20.230 ⇒ 00:21:21.510 Demilade Agboola: Yeah…
223 00:21:23.370 ⇒ 00:21:24.290 Awaish Kumar: Okay.
224 00:21:28.870 ⇒ 00:21:32.970 Awaish Kumar: Okay, if you don’t have anything else, like, that’s all I have to say.
225 00:21:34.900 ⇒ 00:21:38.570 Demilade Agboola: Alright, it takes… yeah, that’s fine. I’ll just add it to the document now.
226 00:21:39.570 ⇒ 00:21:44.970 Awaish Kumar: Yeah, like, whatever we talk, maybe you can copy from Pavscript, editor, and also…
227 00:21:45.230 ⇒ 00:21:50.380 Awaish Kumar: the data, like, maybe download CSV or something and attach the version.
228 00:21:51.360 ⇒ 00:21:54.149 Awaish Kumar: And we can share that then with the client.
229 00:21:56.990 ⇒ 00:21:57.670 Demilade Agboola: Fair enough.
230 00:21:58.030 ⇒ 00:21:58.600 Awaish Kumar: Okay.
231 00:21:58.600 ⇒ 00:22:00.090 Demilade Agboola: Oh…
232 00:22:07.420 ⇒ 00:22:08.160 Awaish Kumar: Okay.
233 00:22:09.160 ⇒ 00:22:10.720 Demilade Agboola: Take care. Bye.