Meeting Title: US x BF | Standup Date: 2025-10-01 Meeting participants: Emily Giant, Demilade Agboola, Amber Lin, Awaish Kumar
WEBVTT
1 00:00:54.540 ⇒ 00:00:55.500 Demilade Agboola: Hi, Emily.
2 00:01:00.430 ⇒ 00:01:03.709 Emily Giant: Sorry, I just took a bite when you said hi. Hello.
3 00:01:04.340 ⇒ 00:01:05.180 Amber Lin: Hi!
4 00:01:11.280 ⇒ 00:01:19.769 Amber Lin: I invited Awish and Utem, but I invited Awish last minute, so don’t blame him if he doesn’t join. And Utem most likely
5 00:01:20.170 ⇒ 00:01:22.069 Amber Lin: Does not have time.
6 00:01:22.180 ⇒ 00:01:23.480 Amber Lin: So…
7 00:01:23.600 ⇒ 00:01:37.689 Amber Lin: Going through these… Oh, Emily, I saw your notes on the tickets that has been groomed. I’ll also pick out a few other ones that needs grooming, but for now, we’ll just put it there.
8 00:01:37.840 ⇒ 00:01:46.529 Amber Lin: And… Okay, let’s start… Let’s start here. Could we close the ticket for Perry?
9 00:01:49.020 ⇒ 00:01:50.539 Demilade Agboola: Oh, yes, I believe we can.
10 00:01:50.540 ⇒ 00:01:51.090 Amber Lin: Okay.
11 00:01:51.090 ⇒ 00:01:52.420 Emily Giant: I don’t even know what that is, but…
12 00:01:52.420 ⇒ 00:01:59.089 Amber Lin: Was that… that was ad hoc. Was this for… did we complete this last week, or is this within this week?
13 00:01:59.480 ⇒ 00:02:06.890 Demilade Agboola: It’s something that came up where Perry was looking at the numbers of summer 2024, and they paid low.
14 00:02:08.160 ⇒ 00:02:12.179 Demilade Agboola: Yeah, but, like, it’s not come up since, and I guess we can just close it.
15 00:02:12.480 ⇒ 00:02:13.180 Amber Lin: Okay.
16 00:02:15.180 ⇒ 00:02:22.130 Amber Lin: And… We’re meeting with her today, I think fact?
17 00:02:23.070 ⇒ 00:02:27.910 Amber Lin: Effect support borders… Oh, okay, Emily’s helping with that.
18 00:02:30.210 ⇒ 00:02:36.400 Amber Lin: Did you guys think on 282, the split line items?
19 00:02:37.890 ⇒ 00:02:43.899 Demilade Agboola: Yeah, so Emily shared some document with me about that, so I’ll…
20 00:02:45.620 ⇒ 00:02:46.470 Amber Lin: Okay.
21 00:02:47.380 ⇒ 00:02:57.560 Amber Lin: So we have… I think, Debilon, on your plate, we have these three. Can I get a point and due dates for them?
22 00:03:00.910 ⇒ 00:03:02.040 Amber Lin: Points for this.
23 00:03:03.490 ⇒ 00:03:08.190 Demilade Agboola: So, for that, the points for unscheduling models is probably…
24 00:03:09.060 ⇒ 00:03:13.279 Demilade Agboola: I’ll say 2 points, just in case things break, but ideally it should be 1 point.
25 00:03:13.320 ⇒ 00:03:14.290 Amber Lin: Okay.
26 00:03:14.600 ⇒ 00:03:22.139 Demilade Agboola: And then… due date, so today is the 1st, I think we can leave it for the 3rd.
27 00:03:22.140 ⇒ 00:03:24.850 Amber Lin: Okay, what about the suborders?
28 00:03:25.230 ⇒ 00:03:28.849 Amber Lin: We can’t do it yet, right, because the order’s… the model’s not ready?
29 00:03:29.660 ⇒ 00:03:39.130 Demilade Agboola: So yeah, it’s tied to that. So Emily is working on adding some OMS part of it.
30 00:03:39.570 ⇒ 00:03:41.860 Demilade Agboola: So, yeah.
31 00:03:43.040 ⇒ 00:03:43.710 Amber Lin: Okay.
32 00:03:44.380 ⇒ 00:03:51.070 Amber Lin: So I think we just have… we have these two. What’s the priority of the split line items?
33 00:03:53.980 ⇒ 00:03:56.470 Emily Giant: I’d say it’s pretty high, because that’s what…
34 00:03:56.470 ⇒ 00:03:57.850 Demilade Agboola: I think…
35 00:03:58.470 ⇒ 00:04:00.130 Emily Giant: Go ahead, Demolate.
36 00:04:00.430 ⇒ 00:04:05.199 Demilade Agboola: We’re gonna say it’s pretty high, because that is part of what plays a role in the reverence.
37 00:04:05.200 ⇒ 00:04:06.110 Emily Giant: calculation.
38 00:04:06.930 ⇒ 00:04:17.420 Demilade Agboola: So that… and according to Emily, that’s something that Peru will probably mention, or, like, refer to in part of the revenue calculation.
39 00:04:18.510 ⇒ 00:04:20.560 Demilade Agboola: I would say it’s high priority.
40 00:04:20.560 ⇒ 00:04:21.209 Amber Lin: Okay.
41 00:04:22.079 ⇒ 00:04:26.359 Amber Lin: Hi, Awash! This is Emily. Emily, this is Awash.
42 00:04:26.710 ⇒ 00:04:28.390 Emily Giant: Hi, nice to meet you.
43 00:04:28.890 ⇒ 00:04:30.899 Awaish Kumar: Hi, Emily, nice to meet you.
44 00:04:31.710 ⇒ 00:04:40.389 Amber Lin: Yesterday we groomed a few of the tickets, which, on your plate, so… I think we have…
45 00:04:40.620 ⇒ 00:04:56.549 Amber Lin: We added this ticket. We moved out one of them, because that doesn’t make sense, and we added… we added this one. So this is a modeling request, and then we also don’t know the requirements, what tests we should add for fact transactions,
46 00:04:57.740 ⇒ 00:05:00.530 Awaish Kumar: That also Putam said, I can go and explore.
47 00:05:00.860 ⇒ 00:05:01.659 Amber Lin: Yeah, okay.
48 00:05:02.300 ⇒ 00:05:10.959 Awaish Kumar: Yeah. But before going into any of these, I need access to GitHub and the Redshift.
49 00:05:11.340 ⇒ 00:05:12.889 Awaish Kumar: Be able to see the data.
50 00:05:13.370 ⇒ 00:05:21.540 Amber Lin: Yeah, Emily, do you think, is it Zach who will give access there, or could you give access?
51 00:05:22.030 ⇒ 00:05:24.299 Demilade Agboola: I think it’s a commission of Zach and Alex.
52 00:05:24.300 ⇒ 00:05:28.880 Emily Giant: Yeah, it’s not me with Redshift, it’s… I would reach out to Alex.
53 00:05:28.880 ⇒ 00:05:30.669 Amber Lin: Mmm, what about GitHub?
54 00:05:31.480 ⇒ 00:05:32.070 Emily Giant: Same.
55 00:05:32.070 ⇒ 00:05:33.770 Demilade Agboola: That’s probably… yeah.
56 00:05:33.770 ⇒ 00:05:39.530 Amber Lin: Okay, let me go grab them real quick. Sorry, that’s my rent payment.
57 00:05:39.650 ⇒ 00:05:44.909 Amber Lin: And… nope, right here.
58 00:05:46.410 ⇒ 00:05:52.300 Amber Lin: Mmm… Oh, sorry, I have not invited Andrew yet, I’m just checking with…
59 00:05:52.300 ⇒ 00:05:53.040 Emily Giant: That’s okay.
60 00:05:53.470 ⇒ 00:05:59.379 Amber Lin: my internal team, because each seat is a little bit extra, I just want to get signed off before I add that.
61 00:05:59.650 ⇒ 00:06:00.929 Amber Lin: I think…
62 00:06:00.930 ⇒ 00:06:09.130 Emily Giant: Amber, we could probably consolidate to, like, the tech at Urban Stems account, if it’s easier for, like, to just have me and then one other Urban Stems account.
63 00:06:09.130 ⇒ 00:06:10.309 Amber Lin: I think that will be best.
64 00:06:10.310 ⇒ 00:06:12.719 Emily Giant: Yeah, let me send you that email address real quick.
65 00:06:13.210 ⇒ 00:06:16.889 Amber Lin: Maybe, except for PK, because I don’t know…
66 00:06:16.890 ⇒ 00:06:17.870 Emily Giant: I would…
67 00:06:17.870 ⇒ 00:06:19.400 Amber Lin: I’d rather use that.
68 00:06:19.960 ⇒ 00:06:27.300 Amber Lin: So, Udon Rougeh… Okay, Alex…
69 00:06:57.200 ⇒ 00:06:58.050 Amber Lin: Okay.
70 00:06:58.400 ⇒ 00:07:03.240 Amber Lin: added, and what did Utam say?
71 00:07:07.650 ⇒ 00:07:08.939 Amber Lin: Back here.
72 00:07:09.420 ⇒ 00:07:15.170 Amber Lin: Yeah, so these are… Let’s assume all of these are blocked.
73 00:07:15.300 ⇒ 00:07:20.039 Amber Lin: Because you don’t have GitHub access. Except for maybe the North Beam issue?
74 00:07:21.220 ⇒ 00:07:22.910 Awaish Kumar: Yeah, I can spike them.
75 00:07:24.020 ⇒ 00:07:25.230 Awaish Kumar: Yeah, okay.
76 00:07:25.340 ⇒ 00:07:26.040 Awaish Kumar: Yeah.
77 00:07:26.180 ⇒ 00:07:39.599 Awaish Kumar: I have a question for Dameel. When we are saying tests, like, I see we already added Metaplane, so we still want to add DB tests, or we want to add them in metaplane?
78 00:07:40.250 ⇒ 00:07:41.130 Amber Lin: Mmm.
79 00:07:41.590 ⇒ 00:07:47.619 Demilade Agboola: So the idea is we have tests and tests, so at least we can confirm integrity of the table.
80 00:07:47.790 ⇒ 00:07:55.299 Demilade Agboola: So there’s, like, unique tests, and just, like, not normal for primary keys, this sort of test, so that if anything…
81 00:07:55.670 ⇒ 00:07:57.310 Demilade Agboola: He’s hop in.
82 00:07:58.850 ⇒ 00:08:01.919 Demilade Agboola: Yes, in dbt, so we just added a couple.
83 00:08:02.170 ⇒ 00:08:08.710 Demilade Agboola: But I know we can also set that up in Metaplane if that… if that would be easier.
84 00:08:09.100 ⇒ 00:08:10.310 Demilade Agboola: suggest, too.
85 00:08:10.700 ⇒ 00:08:11.390 Demilade Agboola: Oh.
86 00:08:11.390 ⇒ 00:08:22.060 Awaish Kumar: It depends on… if we want to move towards Metaplane, then I can just end there. If we… if we don’t have… we don’t have a decision on that yet, I can add dbt tests.
87 00:08:23.130 ⇒ 00:08:33.530 Demilade Agboola: Yeah, so we don’t have a clear decision in terms of moving everything off Metaplane. I know we’re still demoing Metaplane for the client, and I’m not sure if they’ve necessarily confirmed that they want to fully
88 00:08:33.690 ⇒ 00:08:35.650 Demilade Agboola: embrace Metapay, so…
89 00:08:36.179 ⇒ 00:08:38.360 Awaish Kumar: Okay, okay, got it. Thank you.
90 00:08:39.789 ⇒ 00:08:41.539 Amber Lin: Okay,
91 00:08:42.020 ⇒ 00:08:55.450 Amber Lin: I do want to point out that we need to send Zach the North Beam dock. I think, based on what Demolan has said, we should do the spike first.
92 00:08:55.600 ⇒ 00:09:00.110 Amber Lin: Before we send… send over the document.
93 00:09:00.350 ⇒ 00:09:02.729 Amber Lin: What do you guys think?
94 00:09:06.670 ⇒ 00:09:09.290 Awaish Kumar: Hi, Carol.
95 00:09:09.300 ⇒ 00:09:17.480 Amber Lin: Yes, actually, I wish, are you even able to do the spike if you don’t have access? If not, maybe Demlader will have to do it.
96 00:09:18.920 ⇒ 00:09:24.839 Awaish Kumar: Yeah, I… I don’t know, like, for North Beam, do we have… do we have credentials in OnePlus?
97 00:09:27.760 ⇒ 00:09:28.249 Awaish Kumar: Yeah, I mean?
98 00:09:28.250 ⇒ 00:09:33.090 Demilade Agboola: I believe so… Oh, give me one second…
99 00:09:37.250 ⇒ 00:09:38.730 Awaish Kumar: Okay, yeah, but, like.
100 00:09:38.730 ⇒ 00:09:40.639 Demilade Agboola: Yes. Yes, we do.
101 00:09:41.100 ⇒ 00:09:55.909 Awaish Kumar: Okay, I can look into what, like, if we can do anything in the Northbeam, and if we can get data from Northbeam itself, but on the second part, where we are talking about Shopify and
102 00:09:56.740 ⇒ 00:10:01.959 Awaish Kumar: And maybe data in warehouse, like, I can’t do it until I get access.
103 00:10:01.970 ⇒ 00:10:03.900 Amber Lin: I see.
104 00:10:04.700 ⇒ 00:10:20.120 Amber Lin: Can the manual export… I think there’s two parts of the question. We already know that we can’t get it from the Northbeam API. The question is, can we manually export it, or can we get it through Shopify data?
105 00:10:21.130 ⇒ 00:10:24.399 Amber Lin: Is this second question able to be answered in North Beam?
106 00:10:25.120 ⇒ 00:10:35.550 Awaish Kumar: But for the first part, where it says, but no way to get it directly from Northstream, I don’t know, like, who spiked on that, because we…
107 00:10:35.550 ⇒ 00:10:36.829 Amber Lin: I think this is what…
108 00:10:37.270 ⇒ 00:10:41.860 Awaish Kumar: We do get… to get spend data and orders data from NodeMe.
109 00:10:41.990 ⇒ 00:10:46.739 Awaish Kumar: But what we can’t get, I don’t know if… We worked on this.
110 00:10:47.880 ⇒ 00:10:49.669 Demilade Agboola: So I think this was what Ultimate.
111 00:10:49.780 ⇒ 00:10:53.610 Demilade Agboola: had been working on, and basically, I think the issue was
112 00:10:54.140 ⇒ 00:11:00.899 Demilade Agboola: Due to not be in API, and I think that’s where the conclusion of all he had gotten to.
113 00:11:01.020 ⇒ 00:11:05.670 Demilade Agboola: to not be an API, it’s hard to do any attribution to the…
114 00:11:05.860 ⇒ 00:11:07.580 Awaish Kumar: Shopify order data.
115 00:11:08.080 ⇒ 00:11:13.479 Demilade Agboola: And so the idea is… One, is there any way we can…
116 00:11:13.950 ⇒ 00:11:18.199 Demilade Agboola: Do some of the… do that you’ve shown, your Shopify data.
117 00:11:18.340 ⇒ 00:11:21.129 Demilade Agboola: And it’s then where we can manually export it.
118 00:11:21.290 ⇒ 00:11:30.339 Demilade Agboola: if we can’t access it through the API, is there a way we can manually export it and still get the education done? And then, basically, if we can figure out how
119 00:11:30.830 ⇒ 00:11:36.679 Demilade Agboola: we can do auto-attuion through NotBeam, either through a manual export, or…
120 00:11:37.030 ⇒ 00:11:46.320 Demilade Agboola: a way we can tie it to Shopify, then we can present the solution to the issue. I haven’t fully spiked on this, to be honest, so it’s basically off the reports that I’ve read.
121 00:11:46.870 ⇒ 00:11:52.299 Awaish Kumar: Okay, so, like, does that mean we want to see, for the orders coming
122 00:11:52.900 ⇒ 00:12:03.940 Awaish Kumar: like, we are getting orders on Shopify, and through Northstream, we are not able to get where these orders came from. For example, did they come from Facebook ads, TikTok ads?
123 00:12:05.170 ⇒ 00:12:06.600 Amber Lin: Exactly.
124 00:12:06.700 ⇒ 00:12:11.940 Amber Lin: I think specifically the norm being API returns no result for spend.
125 00:12:12.710 ⇒ 00:12:19.630 Amber Lin: Using that API key. Also, no orders between Like, the last… Months.
126 00:12:20.290 ⇒ 00:12:26.710 Awaish Kumar: Okay, that… that context is… yeah, I can dig deeper into it if… if I…
127 00:12:26.710 ⇒ 00:12:31.500 Amber Lin: Let me forward you this email. I think that will be really helpful.
128 00:12:31.500 ⇒ 00:12:33.750 Awaish Kumar: Updream side, and then…
129 00:12:33.750 ⇒ 00:12:38.619 Amber Lin: Man, Demlade, I think you will have to look at the Shopify site.
130 00:12:38.920 ⇒ 00:12:44.389 Amber Lin: Because there’s no way for Wish to do it right now. I really want to send this stock today.
131 00:12:46.550 ⇒ 00:12:47.960 Amber Lin: Is it possible?
132 00:12:50.580 ⇒ 00:12:58.760 Demilade Agboola: I mean, I think the Shopify side is also still tied to the opium side, so… I mean, we can think on it, I wish and I just get to the bottom of it.
133 00:12:58.940 ⇒ 00:13:07.919 Emily Giant: So, okay. With attribution data, like, are we talking, like, the source or, like, the landing page, or what exactly is that? Because we do have a similar field in Shopify.
134 00:13:08.520 ⇒ 00:13:22.009 Awaish Kumar: Yeah, it means that if we ran some ad on TikTok, and somebody clicked that, and then placed an order, that means that order basically came from TikTok ads. We need to attribute that.
135 00:13:22.010 ⇒ 00:13:22.670 Emily Giant: Yep.
136 00:13:22.900 ⇒ 00:13:33.499 Emily Giant: We have, in… sorry, I’m looking at Looker right now. We have one called Source in Shopify.
137 00:13:33.920 ⇒ 00:13:35.040 Emily Giant: orders.
138 00:13:35.410 ⇒ 00:13:43.760 Emily Giant: And, in the, I think it’s in the metadata section, let me find the exact name, because that might be exactly what you’re looking for.
139 00:13:45.340 ⇒ 00:13:47.790 Emily Giant: From Shopify. Do you know what I’m talking about, Demolade?
140 00:13:48.940 ⇒ 00:13:50.140 Demilade Agboola: I haven’t…
141 00:13:51.660 ⇒ 00:13:55.599 Emily Giant: Shopify orders Customer Journey, and then…
142 00:13:56.090 ⇒ 00:14:01.419 Emily Giant: order metadata. It says, buyer accepts marketing, landing site.
143 00:14:01.770 ⇒ 00:14:05.190 Emily Giant: Referring site, source name, those are all, like.
144 00:14:06.750 ⇒ 00:14:11.170 Emily Giant: Similar to that attribution data as As you defined it.
145 00:14:11.170 ⇒ 00:14:15.719 Demilade Agboola: So… Yeah, I’ll look into that and just be sure that it at least to…
146 00:14:16.290 ⇒ 00:14:23.500 Demilade Agboola: what NOPIM is also pushing out, so we can then attribute it together if… It’s doable.
147 00:14:24.110 ⇒ 00:14:27.979 Emily Giant: Okay, maybe even, like, referring site, who knows, but…
148 00:14:29.180 ⇒ 00:14:29.820 Emily Giant: Yeah.
149 00:14:30.430 ⇒ 00:14:41.810 Amber Lin: Would you guys be able to sink and spike on that? I really want to get Zach this. I know I haven’t been pushing earlier, so this is a little bit late.
150 00:14:42.210 ⇒ 00:14:44.570 Amber Lin: And Zach has asked about it yesterday.
151 00:14:48.620 ⇒ 00:14:50.780 Demilade Agboola: Yeah, I wish I was inkling this.
152 00:14:50.780 ⇒ 00:14:51.340 Amber Lin: Okay.
153 00:14:51.340 ⇒ 00:14:54.410 Demilade Agboola: We’ll discuss the bottom of it.
154 00:14:54.410 ⇒ 00:14:56.079 Amber Lin: Yeah, I’ll just put a ticket there.
155 00:14:56.080 ⇒ 00:15:02.449 Emily Giant: Let me know if I can help at all, like, I’m still a little unclear on, like, what Northbeam needs.
156 00:15:03.500 ⇒ 00:15:07.739 Awaish Kumar: Yeah, if you can maybe… what you’re seeing, if you can share the screenshot with us.
157 00:15:07.950 ⇒ 00:15:13.760 Emily Giant: Yeah, definitely. Can you tell me, like, what…
158 00:15:14.070 ⇒ 00:15:25.919 Emily Giant: North Beam needs exactly, like, I just don’t understand what they’re asking for, because if they, like, need a way to connect to a specific customer, or, like, are you looking for the join? I just don’t know what you’re looking for.
159 00:15:26.200 ⇒ 00:15:29.050 Awaish Kumar: Yeah, we wanna connect our conversion
160 00:15:29.630 ⇒ 00:15:37.030 Awaish Kumar: from the marketing platform, like, I spent $15,000 on TikTok ads. How much do I got from there?
161 00:15:37.410 ⇒ 00:15:38.180 Emily Giant: Got it, okay.
162 00:15:38.180 ⇒ 00:15:41.880 Awaish Kumar: $2,000 on Google Ads, how much revenue I got from that.
163 00:15:42.450 ⇒ 00:15:44.960 Emily Giant: Alright, so if I did, like, select unique…
164 00:15:45.870 ⇒ 00:15:51.209 Emily Giant: referring site in mode. I should be able to tell right away if that’s…
165 00:15:51.500 ⇒ 00:16:00.460 Awaish Kumar: Yeah, for each order, if I can see, like, from what is the reference site, we can basically send it back to some platform.
166 00:16:00.460 ⇒ 00:16:12.120 Emily Giant: Yeah, we can definitely do that. I know that we can. It’s in the customer journey table, and Demolata used the customer journey table in the final, like, the order summary, the fact orders. It’s called
167 00:16:12.310 ⇒ 00:16:19.710 Emily Giant: source medium, and there’s also the landing site, and that connects back to order ID, so… and customer email, so we should have enough
168 00:16:19.910 ⇒ 00:16:21.460 Emily Giant: In there, for sure.
169 00:16:21.660 ⇒ 00:16:23.090 Emily Giant: To be able to do that.
170 00:16:26.520 ⇒ 00:16:27.579 Awaish Kumar: Sounds good.
171 00:16:28.140 ⇒ 00:16:28.890 Emily Giant: Alright.
172 00:16:29.180 ⇒ 00:16:37.259 Emily Giant: Is there anything you need from me on that front? Like, I can just send a screenshot, but Demolade, I feel like you know what I’m talking about. In fact, orders.
173 00:16:38.100 ⇒ 00:16:43.680 Demilade Agboola: So, I built Fact dollars, like, 2 weeks ago, so it’s hard for me to remember every single column, so…
174 00:16:43.800 ⇒ 00:16:49.240 Demilade Agboola: Yes, I’ll have to look into and then, figure it out. But yeah, I know it shouldn’t be too hard to get.
175 00:16:50.630 ⇒ 00:16:51.440 Emily Giant: Perfect.
176 00:16:53.010 ⇒ 00:16:53.640 Awaish Kumar: Yeah.
177 00:16:53.760 ⇒ 00:16:55.349 Awaish Kumar: Thank you so much, bye.
178 00:16:56.970 ⇒ 00:17:03.809 Amber Lin: Okay, awesome. Thank you both. That was the most important thing I wanted to address, and then gotta hop to the other meeting.
179 00:17:05.359 ⇒ 00:17:05.889 Awaish Kumar: Good.
180 00:17:06.410 ⇒ 00:17:06.970 Amber Lin: Thanks.