Meeting Title: US x BF | Standup Date: 2025-10-03 Meeting participants: Amber Lin, Emily Giant, Emily’s Fellow Note Taker, Demilade Agboola, Awaish Kumar
WEBVTT
1 00:00:05.940 ⇒ 00:00:07.120 Amber Lin: Hello.
2 00:00:08.300 ⇒ 00:00:09.290 Emily Giant: Hi!
3 00:00:12.060 ⇒ 00:00:17.479 Amber Lin: Alright, I also invited PK, but I don’t know if he will be joining or not.
4 00:00:17.480 ⇒ 00:00:22.510 Emily Giant: Keith, I know, like, sometimes yes, sometimes no with, stand-ups.
5 00:00:22.510 ⇒ 00:00:23.300 Amber Lin: Huh.
6 00:00:24.400 ⇒ 00:00:25.290 Amber Lin: Okay.
7 00:00:25.970 ⇒ 00:00:34.810 Amber Lin: We’re at pretty good progress with… this sprint… I think… Let’s see…
8 00:00:36.150 ⇒ 00:00:53.019 Amber Lin: Oh, this is awesome. And I wanted to see this one. So, for the QA, I really want us to be able to start doing QA next week, and I know the care team might take some time to respond. Do you think we should schedule a meeting with them, or is this better?
9 00:00:53.650 ⇒ 00:00:54.680 Amber Lin: email, or…
10 00:00:54.680 ⇒ 00:01:01.399 Emily Giant: I was on the care team for 2 years, I can just do it. I know all of the scenarios, so… Okay. Yeah.
11 00:01:02.160 ⇒ 00:01:03.000 Amber Lin: Awesome.
12 00:01:03.360 ⇒ 00:01:09.560 Amber Lin: Okay, so I will… It would be great if we can have it before we start next week.
13 00:01:09.770 ⇒ 00:01:14.859 Emily Giant: Let me see if I can pull a doc, like, right now in the Google Drive.
14 00:01:32.640 ⇒ 00:01:47.089 Amber Lin: And… actually, let’s do these first. Then I have a question of the monthly or weekly review tables. Are they now unblocked now that we checked with Perry, or what are they still blocked by?
15 00:01:58.690 ⇒ 00:01:59.870 Demilade Agboola: Who’s the handle one?
16 00:02:01.130 ⇒ 00:02:05.030 Amber Lin: Huh? Sorry, wait, I only heard the last 5 words.
17 00:02:05.150 ⇒ 00:02:06.419 Amber Lin: Of what you said.
18 00:02:17.400 ⇒ 00:02:18.420 Amber Lin: I wish.
19 00:02:19.950 ⇒ 00:02:23.430 Amber Lin: Demolay, were you seeing anything on the…
20 00:02:24.030 ⇒ 00:02:26.759 Demilade Agboola: Okay, now I can hear you, I couldn’t, I couldn’t hear anything.
21 00:02:26.760 ⇒ 00:02:29.019 Amber Lin: Oh, I see, I see. I can hear you now.
22 00:02:29.470 ⇒ 00:02:34.069 Amber Lin: Are these two still blocked after we reviewed with Perry?
23 00:02:37.410 ⇒ 00:02:44.069 Demilade Agboola: We sort of. In the sense that we still have to get the care thing, the care troublesome.
24 00:02:44.710 ⇒ 00:02:46.600 Demilade Agboola: some care situations.
25 00:02:47.080 ⇒ 00:02:48.220 Amber Lin: Okay, so…
26 00:02:48.220 ⇒ 00:02:49.070 Demilade Agboola: have that.
27 00:02:50.860 ⇒ 00:02:54.339 Amber Lin: So we’ll finish the QA, and then we can do these, right?
28 00:02:55.180 ⇒ 00:03:00.179 Demilade Agboola: Yes, once we can QA and be sure that what we have is a good measure of
29 00:03:01.520 ⇒ 00:03:04.360 Demilade Agboola: Revenue, then we can start to put it together.
30 00:03:04.540 ⇒ 00:03:08.200 Amber Lin: Okay, gotcha. Marcus blocked by QA.
31 00:03:10.320 ⇒ 00:03:11.180 Amber Lin: Excellent.
32 00:03:11.740 ⇒ 00:03:12.590 Amber Lin: Okay.
33 00:03:13.930 ⇒ 00:03:18.020 Amber Lin: But we can do the subscription snapshot next week.
34 00:03:18.500 ⇒ 00:03:19.180 Amber Lin: Right.
35 00:03:20.250 ⇒ 00:03:21.360 Demilade Agboola: He, I believe…
36 00:03:21.360 ⇒ 00:03:22.290 Amber Lin: assertions.
37 00:03:22.870 ⇒ 00:03:24.989 Demilade Agboola: Yeah, some of the models I like, yeah, that’s not…
38 00:03:25.630 ⇒ 00:03:26.170 Amber Lin: Yeah.
39 00:03:27.190 ⇒ 00:03:28.010 Amber Lin: Okay.
40 00:03:29.850 ⇒ 00:03:31.050 Amber Lin: Alright.
41 00:03:31.820 ⇒ 00:03:38.119 Amber Lin: So… The subscription model summary is unblocked.
42 00:03:38.450 ⇒ 00:03:45.260 Amber Lin: This should be unblocked once Emily is done, or this PR gets merged.
43 00:03:45.260 ⇒ 00:03:49.719 Demilade Agboola: The subscription revenue summary still tied to… because we also had to get…
44 00:03:50.960 ⇒ 00:03:53.640 Demilade Agboola: It’s still part of the care thing, where we would need.
45 00:03:53.640 ⇒ 00:03:54.040 Amber Lin: together.
46 00:03:54.040 ⇒ 00:04:00.940 Demilade Agboola: Like, context on… What we have, and how that approximates to the troublesome use cases.
47 00:04:00.940 ⇒ 00:04:04.990 Amber Lin: I see, I see, I see. Okay, blocked by QA…
48 00:04:08.430 ⇒ 00:04:09.600 Amber Lin: blocked.
49 00:04:10.500 ⇒ 00:04:13.019 Amber Lin: Scoot that to next cycle.
50 00:04:13.190 ⇒ 00:04:14.150 Amber Lin: Okay.
51 00:04:15.370 ⇒ 00:04:22.289 Amber Lin: And so… Actually, how many points was… was these?
52 00:04:22.690 ⇒ 00:04:24.300 Amber Lin: I’m gonna add them.
53 00:04:25.380 ⇒ 00:04:37.410 Demilade Agboola: Oh, to disciple. So… 3… which was I looking at? 362… Was probably, like, 2 points.
54 00:04:38.160 ⇒ 00:04:38.880 Amber Lin: Okay.
55 00:04:39.550 ⇒ 00:04:44.680 Demilade Agboola: 343 was, like, 1 point.
56 00:04:46.760 ⇒ 00:04:51.969 Demilade Agboola: And then… Yeah, this was today 387.
57 00:04:52.480 ⇒ 00:04:54.839 Demilade Agboola: Was, like, 1 point as well.
58 00:04:55.250 ⇒ 00:04:56.319 Amber Lin: Okay, great.
59 00:04:56.940 ⇒ 00:05:01.460 Amber Lin: So today we have left, that will go to next week.
60 00:05:01.950 ⇒ 00:05:11.330 Amber Lin: Maybe even later. We have the unscheduled models, Shopify categorizations, that will most likely be next week.
61 00:05:11.900 ⇒ 00:05:15.659 Amber Lin: When we work on it with PK.
62 00:05:16.600 ⇒ 00:05:17.929 Amber Lin: And then…
63 00:05:18.690 ⇒ 00:05:24.300 Amber Lin: Just these two. Do you think this is possible this week, or it’s definitely gonna roll over to next week?
64 00:05:25.390 ⇒ 00:05:30.479 Demilade Agboola: So this will roll about to next week. The on-schedule models will be… will be done this week.
65 00:05:30.640 ⇒ 00:05:31.330 Amber Lin: Okay.
66 00:05:36.120 ⇒ 00:05:42.790 Amber Lin: Okay. So, it looks like we did a lot of ad hoc here.
67 00:05:43.810 ⇒ 00:05:44.860 Demilade Agboola: Yeah.
68 00:05:46.330 ⇒ 00:05:49.420 Amber Lin: Yeah, is there anything ad hoc that I didn’t capture?
69 00:05:50.490 ⇒ 00:05:56.429 Demilade Agboola: Not that I… I’m also currently kind of finishing up on other ad hoc
70 00:05:57.290 ⇒ 00:06:02.260 Demilade Agboola: So if you go to my tickets, I added some tickets today, but not to the cycle, to the…
71 00:06:02.260 ⇒ 00:06:03.350 Amber Lin: Next cycle.
72 00:06:03.720 ⇒ 00:06:04.410 Amber Lin: Okay.
73 00:06:06.380 ⇒ 00:06:12.160 Demilade Agboola: I’m trying to get the… the HP stuff around… Into myself.
74 00:06:13.620 ⇒ 00:06:16.819 Demilade Agboola: There should be stuff around, like, the product code.
75 00:06:18.180 ⇒ 00:06:23.779 Demilade Agboola: It’s right down… TK is adding product codes into Looker directly.
76 00:06:24.020 ⇒ 00:06:26.240 Demilade Agboola: Yeah, so 389.
77 00:06:27.450 ⇒ 00:06:33.319 Demilade Agboola: What I want to do is just create a meter way to do that within dbt, so that’s kind of what I’m looking at.
78 00:06:33.570 ⇒ 00:06:35.410 Demilade Agboola: That’s just not coming up at one pointer.
79 00:06:36.010 ⇒ 00:06:40.460 Amber Lin: Okay, this is also… Great.
80 00:06:41.820 ⇒ 00:06:49.760 Demilade Agboola: JSessions is not one point still. JA sessions… well, the ingestion might be one point. The building is good, because I’m going to build models off.
81 00:06:49.760 ⇒ 00:06:52.739 Amber Lin: Okay, so we’ll add, we’ll add more.
82 00:06:53.210 ⇒ 00:06:54.160 Amber Lin: Okay.
83 00:06:55.560 ⇒ 00:07:01.950 Amber Lin: And then… on Oasis’ side.
84 00:07:02.430 ⇒ 00:07:10.470 Amber Lin: What’s possible today? I know… I think you started on the dbt test and the pricing?
85 00:07:10.670 ⇒ 00:07:14.800 Amber Lin: No, I just confirmed that I got the access. I see, I see.
86 00:07:15.730 ⇒ 00:07:18.530 Awaish Kumar: 366 is done.
87 00:07:20.420 ⇒ 00:07:22.879 Awaish Kumar: I am not able to actually run on it.
88 00:07:23.120 ⇒ 00:07:25.320 Awaish Kumar: Finalize that, apart from that.
89 00:07:25.580 ⇒ 00:07:31.620 Awaish Kumar: I may be able to basically compile a list of tests, which I can
90 00:07:31.790 ⇒ 00:07:34.780 Awaish Kumar: We can implement for factorization customers.
91 00:07:34.950 ⇒ 00:07:35.590 Amber Lin: Okay.
92 00:07:35.900 ⇒ 00:07:37.630 Awaish Kumar: And then maybe.
93 00:07:37.780 ⇒ 00:07:46.449 Amber Lin: Yeah, I’ll move the refunds to next week. Question on this, is this something that we’re doing today, or are we doing next week?
94 00:07:52.900 ⇒ 00:07:56.050 Awaish Kumar: Is that… I’ll jump on? Like, he can move…
95 00:07:56.050 ⇒ 00:07:59.700 Amber Lin: I don’t think so… Sure.
96 00:08:00.570 ⇒ 00:08:07.010 Amber Lin: But it seems like short… I don’t know how many points it is. Seems like a short fix, but it might be a lot of…
97 00:08:07.190 ⇒ 00:08:12.280 Amber Lin: Stuff that comes up after we do it. How many points do you think it will be?
98 00:08:12.280 ⇒ 00:08:22.770 Awaish Kumar: So, what is the… Can you open the… Yeah, I, like…
99 00:08:23.150 ⇒ 00:08:25.470 Awaish Kumar: This is the table name, the one…
100 00:08:26.100 ⇒ 00:08:27.580 Amber Lin: I believe so.
101 00:08:29.540 ⇒ 00:08:31.950 Awaish Kumar: I’ll have to look into it, but if it’s…
102 00:08:35.480 ⇒ 00:08:38.750 Awaish Kumar: Yeah, so, like, this table should be somewhere in…
103 00:08:38.990 ⇒ 00:08:41.859 Awaish Kumar: Redshift, and then we might have to move that
104 00:08:44.940 ⇒ 00:08:52.259 Awaish Kumar: into the big carry. So, I can look into it, basically, today, but… Okay. Yeah, I can…
105 00:08:52.990 ⇒ 00:08:54.760 Awaish Kumar: You get the context properly.
106 00:08:56.540 ⇒ 00:08:57.400 Amber Lin: Alright.
107 00:08:57.630 ⇒ 00:09:06.280 Amber Lin: So, I’ll leave these, I’ll say 1 point for the spike, and then I’ll just leave these here, and we’ll see where we get to.
108 00:09:06.580 ⇒ 00:09:12.140 Amber Lin: And on Emily’s side, is anyone reviewing the effect suborders for you?
109 00:09:12.480 ⇒ 00:09:15.129 Emily Giant: Yeah, I think that it’s already been deployed.
110 00:09:15.130 ⇒ 00:09:15.750 Amber Lin: Oh.
111 00:09:16.090 ⇒ 00:09:20.520 Emily Giant: Yeah, done a lot I reviewed yesterday, and I did some tweaks, and… yep, that’s the.
112 00:09:20.520 ⇒ 00:09:21.020 Amber Lin: Correct.
113 00:09:21.020 ⇒ 00:09:22.290 Emily Giant: Base of it, anyway.
114 00:09:22.290 ⇒ 00:09:27.580 Amber Lin: So, the sub… Tess should be… unblocked.
115 00:09:28.490 ⇒ 00:09:29.160 Amber Lin: Yeah.
116 00:09:29.550 ⇒ 00:09:31.770 Amber Lin: So, we’ll try to do today…
117 00:09:35.060 ⇒ 00:09:39.120 Amber Lin: And… For…
118 00:09:41.110 ⇒ 00:09:43.150 Emily Giant: Yeah, fact orders is done.
119 00:09:43.750 ⇒ 00:09:44.540 Amber Lin: Okay…
120 00:09:48.980 ⇒ 00:09:54.450 Amber Lin: What’s the follow-up step for fact orders? Do we need to tell any stakeholders about this?
121 00:09:55.050 ⇒ 00:10:11.319 Emily Giant: I reached out to PK and Perry, and set up an access group for them in Looker, so that only they can see it, and PK is rebuilding some of his tables for marketing on… using it, and, Perry is doing the same, and
122 00:10:11.710 ⇒ 00:10:15.940 Emily Giant: Yeah, and they’re getting back to me, but so far.
123 00:10:16.120 ⇒ 00:10:19.319 Emily Giant: The data has been normal,
124 00:10:19.730 ⇒ 00:10:24.129 Emily Giant: But we just need to continue building upon it so that they have everything joined to it.
125 00:10:24.130 ⇒ 00:10:25.910 Amber Lin: Yeah, sounds good.
126 00:10:26.290 ⇒ 00:10:29.750 Amber Lin: So I’ll assign it… 2…
127 00:10:31.890 ⇒ 00:10:38.419 Amber Lin: Okay, and then, are we doing the LookML Explorer today? I know you also have an ad hoc.
128 00:10:38.420 ⇒ 00:10:48.320 Emily Giant: It’s done, but… when I think of fact line items, I… Feel like that revenue logic.
129 00:10:48.780 ⇒ 00:10:55.359 Emily Giant: should also be tied in, so I wasn’t sure. I wanted to, like, circle up with the group about that, and make sure that, like.
130 00:10:56.390 ⇒ 00:10:59.870 Emily Giant: The intention of this one is…
131 00:11:00.030 ⇒ 00:11:05.220 Emily Giant: completed. Like, I don’t know exactly what fact line items entails.
132 00:11:07.210 ⇒ 00:11:12.990 Amber Lin: I do know that we still have a ticket for the line items, but I’m not… like, we have…
133 00:11:13.290 ⇒ 00:11:17.580 Amber Lin: Split line items for bundle overrides for next week.
134 00:11:18.740 ⇒ 00:11:19.690 Emily Giant: Okay.
135 00:11:20.020 ⇒ 00:11:26.099 Emily Giant: So in that case, it’s done, as long as we are all on the same page that, like.
136 00:11:26.960 ⇒ 00:11:33.740 Emily Giant: That is not a complete… Usable table without the bundle element.
137 00:11:34.580 ⇒ 00:11:36.999 Amber Lin: Is there anyone that can help?
138 00:11:37.870 ⇒ 00:11:41.279 Amber Lin: Verify that, or see what you did, and…
139 00:11:41.680 ⇒ 00:11:42.690 Emily Giant: It’s all joint.
140 00:11:42.690 ⇒ 00:11:43.140 Amber Lin: Okay.
141 00:11:43.140 ⇒ 00:11:46.110 Emily Giant: The fact orders already, so it’s the same group that’s.
142 00:11:46.110 ⇒ 00:11:46.600 Amber Lin: Oh.
143 00:11:46.600 ⇒ 00:11:47.750 Emily Giant: contract orders.
144 00:11:47.750 ⇒ 00:11:48.650 Amber Lin: Okay. Okay.
145 00:11:48.650 ⇒ 00:11:57.690 Emily Giant: As I add these, I’m joining them in the same Explorer, so they’re both available in, it’s just called, like, Shopify orders.
146 00:11:57.930 ⇒ 00:11:58.570 Amber Lin: Okay.
147 00:11:59.010 ⇒ 00:12:03.700 Amber Lin: And then for this ad hoc, how long do you think that would take?
148 00:12:04.140 ⇒ 00:12:06.320 Emily Giant: It’s gonna be done today, I’m almost done.
149 00:12:06.320 ⇒ 00:12:06.990 Amber Lin: Okay.
150 00:12:08.060 ⇒ 00:12:18.019 Emily Giant: Although there is, one of the notes in there is that some of the problems are in the raw data, and I think it was only one that I pulled from that small sample, but
151 00:12:18.130 ⇒ 00:12:23.840 Emily Giant: some of the changes on the order are actually, like, not present in the raw table, so I wanted to
152 00:12:24.590 ⇒ 00:12:29.109 Emily Giant: figure out whether we should reach out to Polytomic, Or what to do there.
153 00:12:29.160 ⇒ 00:12:34.100 Amber Lin: Yeah, feel free to create a ticket or tag me, and then we can…
154 00:12:34.250 ⇒ 00:12:35.939 Emily Giant: Moved forward there as well.
155 00:12:36.280 ⇒ 00:12:51.319 Emily Giant: Oh yeah, so in the outstanding questions, yeah. Also notice that B2B orders don’t go through Shopify. They only go through Dash, because they’re, like, bulk uploaded, so we will need, like, a separate HEVO flow just for B2B.
156 00:12:57.110 ⇒ 00:12:59.959 Emily Giant: For now, anyway, I think they’re gonna put it in Shopify eventually.
157 00:12:59.960 ⇒ 00:13:04.180 Amber Lin: Are we going to be doing this, or are we gonna just ask Kivo, or…
158 00:13:04.180 ⇒ 00:13:05.259 Emily Giant: No, I’ll do it.
159 00:13:05.260 ⇒ 00:13:05.750 Amber Lin: Okay.
160 00:13:05.750 ⇒ 00:13:07.759 Emily Giant: You don’t add that to the stuff.
161 00:13:08.190 ⇒ 00:13:08.800 Amber Lin: Okay.
162 00:13:11.590 ⇒ 00:13:12.630 Amber Lin: Alright.
163 00:13:13.380 ⇒ 00:13:19.539 Amber Lin: For this one, would you mind adding descriptions for this ticket?
164 00:13:19.790 ⇒ 00:13:23.680 Amber Lin: Sure. Are you blocked on… are you still blocked on anything?
165 00:13:23.680 ⇒ 00:13:29.040 Emily Giant: No, I just need to review… nope, I need to review Utom’s tables, and then just build it from there.
166 00:13:31.980 ⇒ 00:13:35.600 Amber Lin: I… Doesn’t seem like we have time for it today, right?
167 00:13:35.670 ⇒ 00:13:38.460 Emily Giant: Definitely not. That will be next week.
168 00:13:38.460 ⇒ 00:13:41.429 Amber Lin: Yeah, let’s move that.
169 00:13:42.950 ⇒ 00:13:43.780 Amber Lin: Okay.
170 00:13:47.370 ⇒ 00:13:53.600 Amber Lin: We have one minute. I have a question on… Sorry, not on…
171 00:13:54.690 ⇒ 00:14:01.749 Amber Lin: on the North Beam stuff, I know we arrive of the short-term solution, the waste and time a lot. I…
172 00:14:01.980 ⇒ 00:14:05.040 Amber Lin: Do we plan to implement it?
173 00:14:05.190 ⇒ 00:14:15.530 Amber Lin: I was wondering if we need a ticket to implement it, or should we confirm, like, double-check, sign off from Zach and Christine, and… before we do that?
174 00:14:20.400 ⇒ 00:14:29.000 Demilade Agboola: Yeah, I mean, we’ve made the proposal to them. We should get feedback from them if they get… if they’re… if they agree with it.
175 00:14:29.000 ⇒ 00:14:29.320 Amber Lin: Okay.
176 00:14:29.320 ⇒ 00:14:35.459 Demilade Agboola: And then we can start building, because we don’t want to, like, put man hours into things that they might not necessarily…
177 00:14:35.460 ⇒ 00:14:38.639 Amber Lin: Makes sense. So I’ll assign this to me, and I’ll go ask them.
178 00:14:38.980 ⇒ 00:14:46.630 Amber Lin: to, yeah, if we get that approval, I’ll add some tickets to next sprint.
179 00:14:47.090 ⇒ 00:14:53.320 Amber Lin: I assume the skip delayed pause is going to be next.
180 00:14:54.260 ⇒ 00:14:58.069 Amber Lin: Melanie, do you know if this issue was resolved?
181 00:14:58.750 ⇒ 00:14:59.720 Amber Lin: I think so.
182 00:14:59.720 ⇒ 00:15:01.110 Emily Giant: It never was an issue.
183 00:15:01.110 ⇒ 00:15:01.550 Amber Lin: I think it was…
184 00:15:01.550 ⇒ 00:15:03.500 Emily Giant: that Gary hadn’t added the stuff.
185 00:15:03.500 ⇒ 00:15:06.579 Amber Lin: I see, okay, so I’ll just… I’ll cancel this.
186 00:15:07.020 ⇒ 00:15:07.710 Emily Giant: Yeah.
187 00:15:07.710 ⇒ 00:15:08.650 Amber Lin: Alright.
188 00:15:09.350 ⇒ 00:15:17.090 Amber Lin: That… will be… Can… do you guys think we can mark it as resolved?
189 00:15:18.250 ⇒ 00:15:19.579 Amber Lin: Because we…
190 00:15:20.270 ⇒ 00:15:27.390 Amber Lin: Like, we have the spend data, which we’re already getting, but the attribution data we’re not going to get. So is this still a valid ticket?
191 00:15:29.760 ⇒ 00:15:35.010 Awaish Kumar: Like, we… like, after you got… get the answer for…
192 00:15:35.830 ⇒ 00:15:38.609 Awaish Kumar: Before the spike, we are able to finalize that.
193 00:15:38.610 ⇒ 00:15:39.510 Amber Lin: Okay. Because…
194 00:15:39.520 ⇒ 00:15:40.610 Awaish Kumar: with us.
195 00:15:40.890 ⇒ 00:15:42.640 Awaish Kumar: With that ticket, like…
196 00:15:42.640 ⇒ 00:15:44.869 Amber Lin: Oh, we might do the manual pull, right?
197 00:15:45.080 ⇒ 00:15:46.520 Awaish Kumar: Yeah, we might have both.
198 00:15:46.520 ⇒ 00:15:52.140 Amber Lin: I see, gotcha. Okay, I’ll move this to next week. Alright, thanks everyone, I gotta hop.
199 00:15:52.980 ⇒ 00:15:54.520 Emily Giant: All right, sounds good.
200 00:15:54.520 ⇒ 00:15:55.460 Demilade Agboola: Bye.
201 00:15:55.460 ⇒ 00:15:56.490 Amber Lin: You too, bye.
202 00:15:56.970 ⇒ 00:15:57.530 Demilade Agboola: Right.