Meeting Title: Simproven x Brainforge GA4 Sync Date: 2025-10-28 Meeting participants: Awaish Kumar, pk.arthur, Amber Lin
WEBVTT
1 00:01:11.240 ⇒ 00:01:12.220 pk.arthur: Hey there.
2 00:01:13.320 ⇒ 00:01:14.140 Awaish Kumar: Hello!
3 00:01:14.750 ⇒ 00:01:15.779 pk.arthur: Hey, how you doing?
4 00:01:16.460 ⇒ 00:01:18.829 Awaish Kumar: I’m good, how about you?
5 00:01:19.290 ⇒ 00:01:23.200 pk.arthur: I’m doing well. I don’t think we’ve actually met. This is our first time meeting, right?
6 00:01:23.390 ⇒ 00:01:24.190 Awaish Kumar: Yeah.
7 00:01:24.780 ⇒ 00:01:28.369 pk.arthur: Hi, I’m PK, I’m the marketing analyst here at Simproven.
8 00:01:29.130 ⇒ 00:01:35.010 Awaish Kumar: Okay, and my name is Amesh Kumahara, I am a data engineer at Brainforge.
9 00:01:36.000 ⇒ 00:01:37.390 pk.arthur: Nice to meet you, Josh.
10 00:01:37.840 ⇒ 00:01:41.179 Awaish Kumar: Yeah, thank you, nationality too.
11 00:01:41.900 ⇒ 00:01:46.359 Awaish Kumar: Yeah, like, I’m not sure if Amber is joining, let me ask her.
12 00:01:46.910 ⇒ 00:01:47.640 pk.arthur: Okay.
13 00:03:21.680 ⇒ 00:03:28.479 Awaish Kumar: Okay, I don’t know if they are joining, I would just, like.
14 00:03:28.980 ⇒ 00:03:31.109 Awaish Kumar: I don’t know if it… if it’s a call with…
15 00:03:31.710 ⇒ 00:03:35.730 Awaish Kumar: Scheduled with, with your, with your request, or it’s just…
16 00:03:36.600 ⇒ 00:03:44.660 pk.arthur: Oh, I think it was actually Amber who set it up. It was not my request, but I think I’m gonna talk about GA4?
17 00:03:44.870 ⇒ 00:03:46.849 pk.arthur: That was the goal, I believe.
18 00:03:47.170 ⇒ 00:03:50.349 Awaish Kumar: We had a conversation, I think, I don’t know who…
19 00:03:51.490 ⇒ 00:03:58.339 Awaish Kumar: I think it was you or someone talking about numbers, or regarding GA4 sessions.
20 00:03:59.010 ⇒ 00:04:03.239 pk.arthur: Yes, I believe… yeah, so, oh, okay, okay, yes, yes, so…
21 00:04:03.920 ⇒ 00:04:23.020 pk.arthur: The issue… so, I think it was, like, probably a few weeks back, a couple of weeks back, right? You sent in a query for me to run, and when I did run that query, I did see a lot of it as, like, the source, specifically as unattributed.
22 00:04:23.990 ⇒ 00:04:29.460 pk.arthur: That was what I was seeing, and I wanted to clarify if we could use a different dimension from GA4.
23 00:04:31.250 ⇒ 00:04:34.259 Awaish Kumar: Like, like, we had a difference in the number of…
24 00:04:36.670 ⇒ 00:04:43.640 Awaish Kumar: We don’t need, like, do you have any agenda, Amber, like, specific thing you want to discuss, or…
25 00:04:43.640 ⇒ 00:04:53.410 Amber Lin: No, I was just here, because I know Utum’s not here, and I just want to confirm that PK has all he needs, because I know we’ve been stuck, but this is the purpose of the meeting, so no.
26 00:04:54.200 ⇒ 00:04:55.789 Awaish Kumar: Oh, okay, yeah, we can…
27 00:04:55.790 ⇒ 00:04:59.480 Amber Lin: All good. Yeah, I’ll watch the recording, I’ll document anything I need.
28 00:04:59.480 ⇒ 00:05:00.250 Awaish Kumar: Okay.
29 00:05:00.410 ⇒ 00:05:01.030 Awaish Kumar: Awesome.
30 00:05:01.030 ⇒ 00:05:01.680 pk.arthur: Yeah.
31 00:05:02.000 ⇒ 00:05:06.240 pk.arthur: Let me show you what I’m looking… I can show you something real quick.
32 00:05:06.550 ⇒ 00:05:08.170 Awaish Kumar: Yeah, you can… yeah, sure, go ahead.
33 00:05:10.290 ⇒ 00:05:13.480 pk.arthur: So, Can you see my screen?
34 00:05:13.740 ⇒ 00:05:14.480 Awaish Kumar: Yes.
35 00:05:15.070 ⇒ 00:05:17.990 pk.arthur: I believe this was a query that you sent me…
36 00:05:18.130 ⇒ 00:05:20.119 pk.arthur: In one of our chats, or…
37 00:05:20.220 ⇒ 00:05:29.169 pk.arthur: just using, like, the… this table instead of what I was about using, right? And what I did notice was, like, the… there’s a high…
38 00:05:29.460 ⇒ 00:05:36.359 pk.arthur: Number of sessions that are basically being attributed to, unassigned.
39 00:05:38.640 ⇒ 00:05:47.470 pk.arthur: And I was wondering if we’re using the wrong dimension from GA4, because GA4, we have, a customized,
40 00:05:48.060 ⇒ 00:05:50.290 pk.arthur: A customized channel grouping.
41 00:05:51.080 ⇒ 00:05:56.199 pk.arthur: So that’s… that was my main question regarding this, like, table, or this out… this outlook.
42 00:05:56.500 ⇒ 00:06:01.300 Awaish Kumar: Okay, so, like, do you remember what that looks like? The…
43 00:06:01.840 ⇒ 00:06:09.310 Awaish Kumar: Like, we have sessions… like, I have multiple, channel groupings for sessions.
44 00:06:09.440 ⇒ 00:06:15.030 Awaish Kumar: I’m not sure which one, is what you need, like, do you have any name or something?
45 00:06:15.410 ⇒ 00:06:16.619 pk.arthur: From a GA4?
46 00:06:18.070 ⇒ 00:06:22.329 Awaish Kumar: Well, I… like, it’s… Let me open it in a…
47 00:06:24.890 ⇒ 00:06:26.869 Awaish Kumar: I think it was Stitch, or…
48 00:06:32.100 ⇒ 00:06:40.539 pk.arthur: Yeah, I’m not… I don’t think I even have access to Stitch, so… I’ve not looked at… I’ve not looked through Stitch, so… maybe you can show me what you see.
49 00:06:42.060 ⇒ 00:06:45.500 Awaish Kumar: Yeah, I’m just, opening it, let me…
50 00:06:49.700 ⇒ 00:06:56.770 Awaish Kumar: Thing is that number of sessions were different, and because of that, we…
51 00:07:00.530 ⇒ 00:07:03.030 Awaish Kumar: ended up… You wanna see.
52 00:07:12.910 ⇒ 00:07:15.689 Awaish Kumar: Yeah, sources from the phone.
53 00:07:50.210 ⇒ 00:07:58.020 Awaish Kumar: Okay, like, this is what I see, and these are the tables we can actually bring in.
54 00:07:59.100 ⇒ 00:08:03.480 Awaish Kumar: from, tier 4. So…
55 00:08:04.790 ⇒ 00:08:07.040 Awaish Kumar: Related to session, there are these…
56 00:08:08.430 ⇒ 00:08:11.169 Awaish Kumar: 1, 2, 3, 4, 5, 6 tables.
57 00:08:14.360 ⇒ 00:08:19.510 Awaish Kumar: I just use this default channel group, because kind of this.
58 00:08:19.890 ⇒ 00:08:22.780 Awaish Kumar: So, this made much more sense.
59 00:08:23.560 ⇒ 00:08:28.190 Awaish Kumar: In terms of when we just want to count the sessions, like, overall sessions.
60 00:08:30.070 ⇒ 00:08:33.639 pk.arthur: Yeah, I think that… that does make sense.
61 00:08:34.190 ⇒ 00:08:39.910 pk.arthur: But additionally, we’d like to, like, possibly even go to the granular level to see, like, where it’s coming from, you know what I mean? Like…
62 00:08:40.360 ⇒ 00:08:49.219 pk.arthur: whether it’s coming from Page Search, or Meta, or Page Social, you know what I mean? But I think that that does look right. Do you have anything that looks like…
63 00:08:49.220 ⇒ 00:08:53.490 Awaish Kumar: Yeah, we can bring this one, like, I can bring this one also, like, source and medium.
64 00:08:53.590 ⇒ 00:08:58.299 Awaish Kumar: Then you can see if it’s Google Ads, Meta, Facebook, whatever.
65 00:08:58.480 ⇒ 00:09:03.379 pk.arthur: Do you see anything that says Session Primary Channel Group in there?
66 00:09:03.900 ⇒ 00:09:05.179 pk.arthur: But that’s all.
67 00:09:05.880 ⇒ 00:09:08.959 Awaish Kumar: Yeah, I can’t see it here, but, like, that… I think…
68 00:09:10.860 ⇒ 00:09:15.219 Awaish Kumar: I don’t know, default channel group? It must be set up in the GF4 itself.
69 00:09:16.250 ⇒ 00:09:19.670 pk.arthur: Maybe, maybe. Let me see something real quick.
70 00:10:53.050 ⇒ 00:10:59.960 pk.arthur: Yeah, I think it was… it possibly was, set up in… GA4 itself.
71 00:11:01.650 ⇒ 00:11:06.979 pk.arthur: Looks like a custom group, so I think the one that you currently have should…
72 00:11:07.370 ⇒ 00:11:10.340 pk.arthur: should be right. I think we may be able to…
73 00:11:10.910 ⇒ 00:11:16.259 pk.arthur: Just manipulated to have it the same way that we We need, essentially.
74 00:11:21.600 ⇒ 00:11:22.570 Awaish Kumar: Okay.
75 00:11:23.620 ⇒ 00:11:26.630 Awaish Kumar: I’m bringing in a few more tables,
76 00:11:30.200 ⇒ 00:11:34.220 Awaish Kumar: These are called
77 00:11:35.660 ⇒ 00:11:42.650 Awaish Kumar: Like, apart from default group, if we want a default, like, channel group, if we want to have some…
78 00:11:44.030 ⇒ 00:11:48.820 Awaish Kumar: Traffic from some explicit source, and source platform.
79 00:11:49.220 ⇒ 00:11:50.529 pk.arthur: okay.
80 00:11:50.740 ⇒ 00:11:54.800 Awaish Kumar: So we… we’ll have all these tables in the… And the redshift.
81 00:12:01.730 ⇒ 00:12:04.139 pk.arthur: Okay, that might be helpful, I think.
82 00:12:07.400 ⇒ 00:12:08.570 pk.arthur: But.
83 00:12:08.730 ⇒ 00:12:12.869 Awaish Kumar: By campaign level, we can also get this one.
84 00:12:14.000 ⇒ 00:12:17.759 pk.arthur: I don’t… let me see, do I need campaign?
85 00:12:20.490 ⇒ 00:12:27.000 pk.arthur: I don’t… I think we need it at that granular level, but let me just double-check real quick.
86 00:12:28.470 ⇒ 00:12:32.780 pk.arthur: I think cap… yeah, I don’t think we need it by campaign level, based on Charlie does.
87 00:12:42.510 ⇒ 00:12:52.520 pk.arthur: Yeah, don’t buy campaign level, like, if we could just have it by, basically, the platform, that would be good as well, and additionally, this… this source.
88 00:12:53.670 ⇒ 00:12:54.640 Awaish Kumar: Okay.
89 00:12:57.680 ⇒ 00:12:59.989 Awaish Kumar: I could run it now.
90 00:13:05.410 ⇒ 00:13:09.110 Awaish Kumar: And, yeah, after it is done, it should be…
91 00:13:14.440 ⇒ 00:13:16.889 Awaish Kumar: Yeah, we should see those tables in,
92 00:13:24.460 ⇒ 00:13:28.050 Awaish Kumar: Let’s it.
93 00:14:22.220 ⇒ 00:14:25.050 Awaish Kumar: It takes around, like, 5-10 minutes.
94 00:14:25.490 ⇒ 00:14:26.170 pk.arthur: Okay.
95 00:14:26.170 ⇒ 00:14:26.769 Awaish Kumar: Is that a fault.
96 00:14:26.770 ⇒ 00:14:30.650 pk.arthur: Once Ryan, do you have access to GA4? Do you?
97 00:14:31.130 ⇒ 00:14:33.130 Awaish Kumar: I have access to view it.
98 00:14:35.420 ⇒ 00:14:40.649 pk.arthur: I guess you cannot see, like, the admin part of it, right? I’m guessing not?
99 00:14:41.760 ⇒ 00:14:44.749 Awaish Kumar: No, I can’t see the admin part, I’m only the…
100 00:14:45.000 ⇒ 00:14:47.529 Awaish Kumar: I think analyst or viewer or something.
101 00:14:48.380 ⇒ 00:14:51.109 pk.arthur: Okay, okay, okay. That’s probably why, okay.
102 00:14:54.480 ⇒ 00:15:07.190 pk.arthur: Yeah, so we do… so, I’m just double checking, and I think you’re right about us having custom fields in GA4 that populates as unattributed in Looker, so…
103 00:15:07.370 ⇒ 00:15:13.400 pk.arthur: I… I know… I now know why that was actually populated in that way.
104 00:15:14.740 ⇒ 00:15:19.260 pk.arthur: Do you recommend that we make… we make those changes and…
105 00:15:19.380 ⇒ 00:15:21.950 Awaish Kumar: DBT or Looker, or LookML.
106 00:15:24.000 ⇒ 00:15:26.430 Awaish Kumar: So, what are those changes, for example?
107 00:15:26.430 ⇒ 00:15:28.979 pk.arthur: So, let me show you. So…
108 00:15:31.020 ⇒ 00:15:33.930 pk.arthur: share my screen… wait, I do.
109 00:15:36.780 ⇒ 00:15:37.700 pk.arthur: Sure.
110 00:15:38.920 ⇒ 00:15:45.070 pk.arthur: So, I’m looking at my GA4 right now, right? And basically, We have.
111 00:15:45.190 ⇒ 00:15:47.110 Awaish Kumar: Custom channel groupings.
112 00:15:47.110 ⇒ 00:15:50.639 pk.arthur: That, like I was saying early on. So, I think…
113 00:15:50.710 ⇒ 00:16:05.370 pk.arthur: for the instances where we see, like, the high number that is unattributed or unassigned, that’s probably, like, from these rules over here, essentially. So we have different rules that say if the source is internal or Shopify app.
114 00:16:05.420 ⇒ 00:16:13.769 pk.arthur: a market as Shopify. So we have a bunch of these in here. That’s basically points…
115 00:16:13.910 ⇒ 00:16:16.830 pk.arthur: Pointed to the correct… to the correct channel in GA4.
116 00:16:17.120 ⇒ 00:16:19.890 pk.arthur: So that’s what we would like to see, and…
117 00:16:19.960 ⇒ 00:16:21.080 Awaish Kumar: Looker.
118 00:16:21.360 ⇒ 00:16:30.150 pk.arthur: So… so I was saying that, should we do this in, like, dbt or in LookML? I can do it in LookML. That… that could not be a problem, but, like, would that slow down?
119 00:16:30.150 ⇒ 00:16:32.779 Awaish Kumar: We can do it in dbt, right?
120 00:16:32.780 ⇒ 00:16:33.550 pk.arthur: Oh, okay.
121 00:16:33.550 ⇒ 00:16:39.559 Awaish Kumar: That way, like, this can be standardized to use it across, like, different data.
122 00:16:40.510 ⇒ 00:16:47.579 pk.arthur: Yeah, yeah, I agree, I… so you say you don’t have access to, like, this part?
123 00:16:47.740 ⇒ 00:16:48.720 pk.arthur: of…
124 00:16:48.720 ⇒ 00:16:52.149 Awaish Kumar: I don’t have access to this, but if I…
125 00:16:52.490 ⇒ 00:16:56.310 Awaish Kumar: If this mapping that you have, like, these logics, if you can.
126 00:16:56.710 ⇒ 00:16:57.570 Awaish Kumar: my own…
127 00:16:58.090 ⇒ 00:17:01.499 pk.arthur: Yeah. So what was I converted in SQL?
128 00:17:02.190 ⇒ 00:17:02.930 pk.arthur: Okay.
129 00:17:04.010 ⇒ 00:17:11.910 pk.arthur: Yeah, I could give you, just, The…
130 00:17:12.099 ⇒ 00:17:14.840 pk.arthur: An output of the logic, essentially, for each channel.
131 00:17:15.339 ⇒ 00:17:16.449 Awaish Kumar: Yeah, that one.
132 00:17:16.450 ⇒ 00:17:17.190 pk.arthur: Okay.
133 00:17:17.349 ⇒ 00:17:19.379 pk.arthur: Okay, yeah, I got you for sure.
134 00:17:19.930 ⇒ 00:17:24.220 pk.arthur: So that was it for GA4. Let me see…
135 00:17:28.900 ⇒ 00:17:35.080 pk.arthur: Another thing… So…
136 00:17:35.640 ⇒ 00:17:39.759 pk.arthur: Will you… do you… do you work on the… on our Shopify models, too, or no?
137 00:17:40.910 ⇒ 00:17:45.160 Awaish Kumar: I do… I have just started working on that, so I’m not sure…
138 00:17:45.530 ⇒ 00:17:46.670 pk.arthur: Okay, okay, okay.
139 00:17:46.670 ⇒ 00:17:49.319 Awaish Kumar: I will be able to answer everything.
140 00:17:49.590 ⇒ 00:17:50.200 pk.arthur: Thank you.
141 00:17:50.200 ⇒ 00:17:52.090 Awaish Kumar: We can go ahead with your questions.
142 00:17:52.560 ⇒ 00:17:57.310 pk.arthur: So with Shopify,
143 00:17:57.760 ⇒ 00:18:02.179 pk.arthur: I was talking to Emily and Demolade a couple of weeks ago about pulling in our…
144 00:18:02.670 ⇒ 00:18:10.700 pk.arthur: Promo, like, the promo code, like, the discount code itself, to see if we could pull that in, because we had a request to basically…
145 00:18:11.300 ⇒ 00:18:20.970 pk.arthur: match the promo codes to the marketing channel, essentially, to see, like, so let’s say, did the fall sale promo come from Facebook or…
146 00:18:21.560 ⇒ 00:18:26.779 pk.arthur: Google, right? So, I wanted to see if that’s possible. I know that’s possible, so I don’t think we can currently pull in
147 00:18:27.800 ⇒ 00:18:35.600 pk.arthur: either of those sources from Shopify, so I wanted to see if there’s any updates on that currently, but I don’t know if you’re the right person to ask, to be honest.
148 00:18:35.600 ⇒ 00:18:43.189 Awaish Kumar: What is your, like… What… sorry, the promo code are, like, run on Shopify, or…
149 00:18:43.630 ⇒ 00:18:54.789 pk.arthur: Yeah, so the, like, customers can put, like, a discount code, promo code in Shopify, right? And they get the… get a discount on their product. So I wanted to see, basically, how, like.
150 00:18:55.140 ⇒ 00:18:59.889 pk.arthur: Like, we wanted to attribute, promo code usage by the marketing channel.
151 00:19:01.910 ⇒ 00:19:02.850 Awaish Kumar: Okay.
152 00:19:02.950 ⇒ 00:19:03.630 Awaish Kumar: I’m wrong.
153 00:19:03.630 ⇒ 00:19:04.600 pk.arthur: So basically…
154 00:19:04.780 ⇒ 00:19:09.820 Awaish Kumar: So, like, how the promo… like, for example, I… I…
155 00:19:10.470 ⇒ 00:19:12.360 Awaish Kumar: I see the ad on Google.
156 00:19:13.030 ⇒ 00:19:18.129 Awaish Kumar: I click on, and then I come onto Shopify to make an order.
157 00:19:18.430 ⇒ 00:19:23.920 Awaish Kumar: And then I can able to use the promo codes, that’s what you’re saying?
158 00:19:23.920 ⇒ 00:19:24.720 pk.arthur: Yes.
159 00:19:24.720 ⇒ 00:19:30.700 Awaish Kumar: then you want to see, like, if 100 people were coming from Google, how many of them using
160 00:19:30.980 ⇒ 00:19:33.359 Awaish Kumar: Some promo code or something.
161 00:19:33.770 ⇒ 00:19:40.790 pk.arthur: Yeah, basically, yes, like, to some extent, I wanna see, basically, How many orders?
162 00:19:41.350 ⇒ 00:19:44.130 pk.arthur: use the promo code from Google.
163 00:19:44.130 ⇒ 00:19:45.600 Awaish Kumar: Or page search.
164 00:19:45.600 ⇒ 00:19:52.269 pk.arthur: How many orders use the promo code from Direct? How many orders use the promo code from Organic?
165 00:19:52.380 ⇒ 00:19:57.789 pk.arthur: they’re, like, broken down by marketing channel, but I think that we need that from Shopify to be able to get it accurately.
166 00:19:57.790 ⇒ 00:20:07.700 Awaish Kumar: Like, but that is what I’m trying to answer. Are the promo code linked to the channel, or promo codes are just a separate part, right?
167 00:20:07.700 ⇒ 00:20:08.440 pk.arthur: Yeah, yeah.
168 00:20:08.440 ⇒ 00:20:12.309 Awaish Kumar: that we got 100 orders today from Google.
169 00:20:12.470 ⇒ 00:20:15.920 Awaish Kumar: How many of them use the promobs, right?
170 00:20:15.920 ⇒ 00:20:17.449 pk.arthur: Yes, yes, yes, yes.
171 00:20:17.450 ⇒ 00:20:25.020 Awaish Kumar: Okay, like, if I can attribute orders to… if I can attribute orders to the channel.
172 00:20:25.410 ⇒ 00:20:29.270 Awaish Kumar: And then I can attribute orders to the promo codes. We can basically.
173 00:20:29.580 ⇒ 00:20:30.250 pk.arthur: Yeah.
174 00:20:30.250 ⇒ 00:20:31.760 Awaish Kumar: Make that connection.
175 00:20:31.760 ⇒ 00:20:32.260 pk.arthur: Yes.
176 00:20:32.260 ⇒ 00:20:37.409 Awaish Kumar: I can come… I can tell you that’s not possible, right now.
177 00:20:37.590 ⇒ 00:20:39.889 Awaish Kumar: I are not… I’m not sure about…
178 00:20:40.140 ⇒ 00:20:48.089 Awaish Kumar: how orders are being mapped with promo codes. Maybe we already have data somewhere. Demil Adam will know that. Right now.
179 00:20:48.090 ⇒ 00:20:48.450 pk.arthur: Yeah.
180 00:20:48.450 ⇒ 00:20:51.609 Awaish Kumar: an answer, I can, like, come up with an answer after…
181 00:20:52.290 ⇒ 00:20:53.380 pk.arthur: Yeah, I…
182 00:20:53.380 ⇒ 00:20:53.750 Awaish Kumar: But…
183 00:20:53.750 ⇒ 00:20:54.330 pk.arthur: No, I think…
184 00:20:54.330 ⇒ 00:21:01.919 Awaish Kumar: For the first part, I do have the answer. That’s why I said it’s not possible right now, but it will be possible in future.
185 00:21:02.490 ⇒ 00:21:09.479 Awaish Kumar: We don’t have attribution data between orders and the… which channel they are coming from. We don’t have…
186 00:21:09.590 ⇒ 00:21:16.279 Awaish Kumar: the full coverage, like, I was… I tried to use GF4 data, but I was,
187 00:21:16.610 ⇒ 00:21:24.440 Awaish Kumar: like Kisto said, that we are moving away from GA4 in the near future, and we are relying on attribution,
188 00:21:24.570 ⇒ 00:21:25.459 Awaish Kumar: From, like.
189 00:21:25.460 ⇒ 00:21:26.010 pk.arthur: from North being.
190 00:21:26.010 ⇒ 00:21:27.470 Awaish Kumar: Some road speed, right?
191 00:21:27.640 ⇒ 00:21:36.459 Awaish Kumar: Yeah. And I have tried to work on getting the attribution data from Northstream, but it’s not possible yet. We have requested for a new service.
192 00:21:36.810 ⇒ 00:21:41.079 Awaish Kumar: When that service is available, we can basically do that full funnel.
193 00:21:41.550 ⇒ 00:21:58.789 pk.arthur: Yeah, so that’s… that… alright, thank you, and that’s one… that’s only, like, one part, so that’s a different, like, topic. So, the Northbeam is, you’re going to see, like, where they first saw the ad, and when they clicked on the ad, right? But with the Shopify… I know that Shopify has a source medium.
194 00:21:58.800 ⇒ 00:22:03.970 pk.arthur: in their database. So, for Shopify, we only care about the last click, so basically what they clicked on.
195 00:22:03.970 ⇒ 00:22:04.800 Awaish Kumar: I do have that.
196 00:22:04.800 ⇒ 00:22:06.350 pk.arthur: We’re doing. Yeah, yeah.
197 00:22:06.350 ⇒ 00:22:06.910 Awaish Kumar: do have a…
198 00:22:06.910 ⇒ 00:22:10.470 pk.arthur: Yeah, yeah, so for that purpose, so for the…
199 00:22:10.580 ⇒ 00:22:20.379 pk.arthur: so for our promo purposes only, right, we wanted to just see where they last clicked on the ad and used a promo. So it’s kind of different from the attribution.
200 00:22:21.460 ⇒ 00:22:28.830 Awaish Kumar: Okay, although both are, like, both are called attributions, but, like.
201 00:22:28.930 ⇒ 00:22:32.260 Awaish Kumar: The other… the team is concerned about
202 00:22:32.690 ⇒ 00:22:39.189 Awaish Kumar: first touch, that’s why we’re using North Name. But if you are saying we just need last touch, which, as you said.
203 00:22:39.480 ⇒ 00:22:44.370 pk.arthur: Yeah, so, no, so, no, so, I would… we would want both for… it’s for different things, so, like, if…
204 00:22:44.370 ⇒ 00:22:45.239 Awaish Kumar: Yeah, 100%.
205 00:22:45.260 ⇒ 00:22:52.750 pk.arthur: Yeah, so for, like, the short term, just so, like, this is… this is from a request from Menaki. She wants to see, like, basically.
206 00:22:54.000 ⇒ 00:22:55.170 pk.arthur: where…
207 00:22:55.170 ⇒ 00:23:00.099 Awaish Kumar: Promo codes it’s coming from, right? There is a table called Fact Orders.
208 00:23:00.490 ⇒ 00:23:06.159 Awaish Kumar: In the fact orders table, you can basically find a field called UTM source.
209 00:23:07.760 ⇒ 00:23:12.880 Awaish Kumar: And that field can give you that order belongs to what channel.
210 00:23:13.240 ⇒ 00:23:14.210 Awaish Kumar: Right?
211 00:23:14.400 ⇒ 00:23:20.199 Awaish Kumar: But I don’t know if that table also have promo codes. I can ask them later and come back to you regarding that.
212 00:23:20.200 ⇒ 00:23:20.940 pk.arthur: Okay.
213 00:23:21.230 ⇒ 00:23:22.829 pk.arthur: So it’s called Fact Orders.
214 00:23:23.330 ⇒ 00:23:24.080 Awaish Kumar: Yeah.
215 00:23:24.400 ⇒ 00:23:26.150 pk.arthur: Okay, let me just see you real quick.
216 00:23:26.770 ⇒ 00:23:29.600 pk.arthur: DVT brain for retract orders.
217 00:23:39.100 ⇒ 00:23:43.080 Awaish Kumar: I can… Oops.
218 00:23:48.540 ⇒ 00:23:54.000 Awaish Kumar: The model structure, mods, orders, fact orders, and we have…
219 00:23:59.730 ⇒ 00:24:00.360 Awaish Kumar: That’s cool.
220 00:24:00.360 ⇒ 00:24:04.859 pk.arthur: Yeah, I don’t think… I’m looking at it right now, I don’t think it has promo code…
221 00:24:05.750 ⇒ 00:24:09.099 pk.arthur: We got, we have source… we have source name in it.
222 00:24:09.550 ⇒ 00:24:14.980 Awaish Kumar: We have… we have… we have, one… one is called Enhanced UTM Source.
223 00:24:15.500 ⇒ 00:24:22.490 Awaish Kumar: And the… there is another field called… It’s trend-rised UTM source, and.
224 00:24:23.170 ⇒ 00:24:34.569 Awaish Kumar: One is that I’m, like, if somebody says Google.com, and Google, and Google Google, or something like that, then we just clean our… clean it up, like, as a single Google.
225 00:24:35.240 ⇒ 00:24:36.560 pk.arthur: Yeah, yeah.
226 00:24:36.560 ⇒ 00:24:41.350 Awaish Kumar: So, we… I would recommend using a strain rice UTM source for your.
227 00:24:41.350 ⇒ 00:24:42.020 pk.arthur: Yep.
228 00:24:42.330 ⇒ 00:24:46.649 Awaish Kumar: That will do… If there are duplicate entries for Google, it will just make it work.
229 00:24:47.620 ⇒ 00:24:52.410 pk.arthur: Yeah, I mean, okay, so I think what would help, just like, just for our team.
230 00:24:52.750 ⇒ 00:25:01.339 pk.arthur: if, like, once I send you this channel list, like, from GA4, if you could use that same logic to, like, basically have the source
231 00:25:03.960 ⇒ 00:25:11.450 pk.arthur: user source data to the channel. Basically, so if you see something from, like, Google… like, Google Ads, it’ll be, like, paid search.
232 00:25:11.780 ⇒ 00:25:15.020 pk.arthur: Will that be possible in DBT? I’m pretty sure, right?
233 00:25:15.650 ⇒ 00:25:18.350 Awaish Kumar: Sorry, go… .
234 00:25:18.350 ⇒ 00:25:27.180 pk.arthur: So, you know how they show, like, the GA4, channel list, right? What we have for, like, Shopify, paid social, paid search, and all that, right?
235 00:25:27.350 ⇒ 00:25:27.655 Awaish Kumar: Nothing.
236 00:25:30.030 ⇒ 00:25:43.949 pk.arthur: Okay. I think… I think the final goal, instead of having, like, Google, Facebook, or whatever, we want to have it as paid search, organic search, Shopify, just like those channels, not, like, a source level, but at a channel level, right? So…
237 00:25:43.950 ⇒ 00:25:52.939 pk.arthur: if I send you, again, this GA4 logic that maps out the sources to the channel, could you also, like, add that next step of… No. Okay.
238 00:25:53.340 ⇒ 00:25:59.810 Awaish Kumar: So, that’s just… that is just, basically, we are categorizing into their different groupings. So, we are… Yes, yes.
239 00:25:59.810 ⇒ 00:26:00.380 pk.arthur: Yes.
240 00:26:00.380 ⇒ 00:26:03.550 Awaish Kumar: We have meta search, we might have something…
241 00:26:03.790 ⇒ 00:26:05.760 Awaish Kumar: Yahoo, and then you want to
242 00:26:06.180 ⇒ 00:26:09.579 Awaish Kumar: Maybe marked as search, or something like that.
243 00:26:09.580 ⇒ 00:26:11.179 pk.arthur: Yes, yeah, yes, yes, yes, yes.
244 00:26:11.530 ⇒ 00:26:24.519 pk.arthur: Yes, okay, so I will definitely send you that after this. So… but looking at it right now, I don’t see… I don’t think there is promos currently in there, right? Do you see promos in there? Or discounts?
245 00:26:24.520 ⇒ 00:26:28.730 Awaish Kumar: Yeah, yeah, I don’t see it either. I will ask Demila demo.
246 00:26:28.920 ⇒ 00:26:29.890 pk.arthur: Okay.
247 00:26:30.120 ⇒ 00:26:32.759 Awaish Kumar: Is I… and how urgent is that, like this?
248 00:26:33.160 ⇒ 00:26:39.500 pk.arthur: So, preferably so, because it’s been about 2 weeks since, like, she asked for it.
249 00:26:40.170 ⇒ 00:26:47.699 pk.arthur: So, I mean, I could reach out to him as well to find out if there are any, like, updates on that, because I reached out to him and Emily to see.
250 00:26:48.370 ⇒ 00:26:53.100 Awaish Kumar: Okay, so I have some final next steps here. Number one…
251 00:26:53.410 ⇒ 00:27:02.219 Awaish Kumar: I have already ingested the data, a few more tables from GA4 for you. You can look at it, and if you want to use it somewhere, you can do that.
252 00:27:02.800 ⇒ 00:27:11.529 Awaish Kumar: Second step is regarding UTM sources. We already have UTM sources from Shopify, but if you want me to…
253 00:27:11.570 ⇒ 00:27:23.620 Awaish Kumar: like, have more categorization. You can send me their logic, and I will put it in dbt. And third step is regarding promos, I will go back to Damilade and ask it.
254 00:27:23.880 ⇒ 00:27:26.370 Awaish Kumar: And, get it prioritized.
255 00:27:26.790 ⇒ 00:27:27.480 pk.arthur: Okay.
256 00:27:27.670 ⇒ 00:27:29.489 pk.arthur: Yeah, it sounds good. Thank you so much.
257 00:27:29.860 ⇒ 00:27:30.880 Awaish Kumar: Okay, thank you.
258 00:27:31.760 ⇒ 00:27:32.730 pk.arthur: Bye.
259 00:27:32.730 ⇒ 00:27:33.120 Awaish Kumar: Huh?