Meeting Title: US x BF | Planning & Retro Date: 2025-11-17 Meeting participants: Uttam Kumaran, Demilade Agboola, Awaish Kumar, Emily Giant
WEBVTT
1 00:00:28.490 ⇒ 00:00:29.470 Uttam Kumaran: Hello.
2 00:00:30.310 ⇒ 00:00:32.990 Emily Giant: Hi, sorry, I couldn’t find the meeting link.
3 00:00:33.260 ⇒ 00:00:38.340 Uttam Kumaran: No, the meeting got transferred to me, and then I forgot to re-add a link.
4 00:00:38.340 ⇒ 00:00:40.010 Emily Giant: Oh, okay, gotcha.
5 00:00:40.250 ⇒ 00:00:41.280 Uttam Kumaran: That is on me.
6 00:00:41.280 ⇒ 00:00:44.880 Emily Giant: No worries. I find… I figured it out, and I’m here.
7 00:00:46.260 ⇒ 00:00:47.520 Uttam Kumaran: How’s everything going?
8 00:00:48.220 ⇒ 00:01:06.139 Emily Giant: It’s going. Just working through, like, the last finishing touches with the historical revenue. There were just a lot of abnormalities, and, like, everything leading up to it had to be tweaked. So, it’s going okay, though. It should be done today, but it’s gonna be pretty major.
9 00:01:06.420 ⇒ 00:01:07.090 Uttam Kumaran: Okay.
10 00:01:07.240 ⇒ 00:01:07.880 Emily Giant: Yeah.
11 00:01:09.150 ⇒ 00:01:12.030 Emily Giant: How… Sorry, go ahead.
12 00:01:12.030 ⇒ 00:01:21.480 Uttam Kumaran: Yeah, no, things are… things are good. Otherwise, I think Awash, is… we… we made some progress. I think I was happy last week that, like, we did a lot better job on…
13 00:01:21.620 ⇒ 00:01:39.459 Uttam Kumaran: Metaplane, and so I think a lot of the issues that are coming up are actual issues. Okay. Which is great. And so I know even, like, today there’s, like, an issue with full refresh, but at least what I’m… what I’m happy with is that all the issues that are popping up are things we should look at.
14 00:01:39.460 ⇒ 00:01:40.359 Emily Giant: Yeah, yeah, that’s…
15 00:01:40.360 ⇒ 00:01:42.450 Uttam Kumaran: You know…
16 00:01:43.030 ⇒ 00:01:48.730 Uttam Kumaran: Yeah, and then I guess maybe, Demolade, if you want to give an update on some stuff you’re working on.
17 00:01:50.300 ⇒ 00:01:55.329 Demilade Agboola: So Emily and I met today, we kind of aligned on things we need to…
18 00:01:55.520 ⇒ 00:02:00.740 Demilade Agboola: tackle. So right now, I’m currently working on the discounts. I’ve been able to extract them out.
19 00:02:00.970 ⇒ 00:02:11.290 Demilade Agboola: I’m trying to categorize them into promos versus discounts, and then also, like, shipping discounts, so that way we can kind of see
20 00:02:11.400 ⇒ 00:02:20.350 Demilade Agboola: How much, like, employees are using as discounts versus, like, promo codes that are being used all around, and what promo codes were used to redeem.
21 00:02:20.760 ⇒ 00:02:23.340 Demilade Agboola: Whatever percentage is, so that would be…
22 00:02:23.590 ⇒ 00:02:31.580 Demilade Agboola: that’s kind of what I’m working on right now. And then the next thing I want to do before close is the…
23 00:02:32.180 ⇒ 00:02:39.170 Demilade Agboola: kind of, like, the fulfilled revenue bit, where, like, I just want to have a feel-safe, like, if it’s…
24 00:02:39.360 ⇒ 00:02:49.959 Demilade Agboola: fulfilled through the current way, we look at it, that’s good. If it’s not, then I’ll integrate the new way where we look at, like, to deliver that status, as well as, certain other
25 00:02:50.110 ⇒ 00:02:54.419 Demilade Agboola: Categories to be able to market as a fulfilled order.
26 00:02:59.140 ⇒ 00:03:00.620 Emily Giant: Yeah,
27 00:03:01.040 ⇒ 00:03:06.460 Emily Giant: yeah, those are the points we had talked through for revenue to be done. I know we still need to add, like.
28 00:03:07.020 ⇒ 00:03:23.010 Emily Giant: the shipping details, like, they’re all in an intermediate model at this point, they just need to be, like, tied in. I don’t know, Demolati, if you imagine those being joined in Looker, by the order line ID, or if you want them to be in the revenue model, but,
29 00:03:23.010 ⇒ 00:03:25.910 Emily Giant: the shipping information.
30 00:03:25.910 ⇒ 00:03:45.489 Emily Giant: which I don’t think that necessarily has to do with revenue, so I don’t mind it being a separate fact model, and then just joining it in Looker, since we do have that, like, level of granularity on the order line ID from Shopify. The other outstanding thing that we had, like, very briefly touched on is just making sure that,
31 00:03:46.120 ⇒ 00:04:00.449 Emily Giant: the team looks at items by piece and by parent, which is like, if there’s a firecracker, you can buy a single, double, or triple. So a piece would be always the single with the quantity
32 00:04:00.530 ⇒ 00:04:17.209 Emily Giant: times however many of that unit were in the bouquet, so, like, you can get the SKU FLRL-T-1, and that’s the triple, because it’s got that T, and that’s a quantity of 1 for that SKU, but the piece quantity would be FLRLB-1
33 00:04:17.240 ⇒ 00:04:28.130 Emily Giant: quantity 3. So, I’m looking at fixing all of that, making sure it’s, like, really tidy and historical, and then, I can jump in
34 00:04:28.180 ⇒ 00:04:35.669 Emily Giant: And, pull that from Shopify so that Demolade can focus on, like, snapshots and discounts.
35 00:04:39.190 ⇒ 00:04:45.600 Demilade Agboola: But do we have… do we have the parent and PCU in the Shopify data as well, or is it just a historical thing?
36 00:04:45.820 ⇒ 00:04:54.429 Emily Giant: I think that we do. I believe that there’s, like, a JSON string that always says the, like, the kitted skew.
37 00:04:55.420 ⇒ 00:05:00.930 Emily Giant: And then, I need to look into it, I need to do a little bit more research on exactly how it pulls.
38 00:05:01.130 ⇒ 00:05:02.780 Emily Giant: But… I…
39 00:05:03.290 ⇒ 00:05:13.029 Emily Giant: I do think we can pull the piece information from inventory, like Polytomic, and join it there, and then just keep Shopify as is.
40 00:05:13.470 ⇒ 00:05:20.199 Emily Giant: But we don’t have that for historicals. So that makes sense to me and is fine. If we just are like, okay, this is the same order.
41 00:05:20.230 ⇒ 00:05:34.019 Emily Giant: And, there’s a… a, like, group ID in Shopify that, on another branch of mine, I extracted, and the, like, suffix is always the same between, like.
42 00:05:34.060 ⇒ 00:05:42.789 Emily Giant: related variants, so as long as I can pull that out, I’ll be able to tie it to the inventory count, and you don’t have to pull that from Shopify.
43 00:05:44.100 ⇒ 00:05:48.189 Demilade Agboola: Mmm… Okay, fair enough.
44 00:05:48.390 ⇒ 00:05:51.860 Emily Giant: Yeah, we’ll see if it works, but I should be able to do that, like…
45 00:05:52.080 ⇒ 00:05:54.769 Emily Giant: I’m right now, just doing, like.
46 00:05:55.070 ⇒ 00:06:00.719 Emily Giant: last testing on the historical with the, like, SKU and product name stuff.
47 00:06:01.000 ⇒ 00:06:07.200 Emily Giant: So once I wrap that, I can at least do, like, an hour of research to see, like, our opportunities there.
48 00:06:09.620 ⇒ 00:06:14.690 Emily Giant: But I do know that, like, people want revenue at both of those levels.
49 00:06:16.580 ⇒ 00:06:24.790 Demilade Agboola: Yeah, I also think that we should focus on getting the numbers stable, and then add that piece.
50 00:06:24.790 ⇒ 00:06:27.869 Emily Giant: Yeah, agreed. Fair enough. Yeah.
51 00:06:29.850 ⇒ 00:06:36.270 Emily Giant: So, yeah, I noticed, like, There’s still some strangeness with, like, subscriptions.
52 00:06:36.520 ⇒ 00:06:40.939 Emily Giant: Anyway, I don’t have a lot of formed thoughts about it, but all of the issues are, like.
53 00:06:41.350 ⇒ 00:06:46.129 Emily Giant: planted in my head, and I can bullet point them in the channel, but I did…
54 00:06:46.610 ⇒ 00:06:54.830 Emily Giant: share all of the current issues that I’m debugging and historical with Demolati this morning, so he knows what I’m up to in terms of, like, what’s still not right.
55 00:06:54.830 ⇒ 00:06:55.530 Uttam Kumaran: Okay.
56 00:06:55.900 ⇒ 00:07:02.580 Uttam Kumaran: Yeah, if you’re able to write those down, I probably have some time later this afternoon to sort of poke at things.
57 00:07:02.580 ⇒ 00:07:16.109 Emily Giant: Yeah, I’m hoping to deploy after our… I’m not doing any deployments anymore during business hours, it’s just not worth it. But hoping to deploy… I had to add, for revenue.
58 00:07:16.420 ⇒ 00:07:27.710 Emily Giant: the suborder level granularity to fact subscriptions. It was at the order level previously in that model, so I’m still, like, really, really hoping to get some forecasting.
59 00:07:27.910 ⇒ 00:07:34.469 Emily Giant: against that, and I have, like, a really crappy model built, but, like, I feel like your eyes would be great for that.
60 00:07:34.470 ⇒ 00:07:35.799 Uttam Kumaran: Okay, cool.
61 00:07:36.400 ⇒ 00:07:39.079 Emily Giant: Yeah, someday. Someday it’ll be out there.
62 00:07:39.510 ⇒ 00:07:43.760 Emily Giant: But I’m just so, like, obsessed with revenue right now, because I’m getting so many asks.
63 00:07:43.970 ⇒ 00:07:49.590 Emily Giant: That… that’s, like, all… all I’m really doing is just testing, testing, testing.
64 00:07:50.280 ⇒ 00:07:50.890 Uttam Kumaran: Okay.
65 00:07:52.090 ⇒ 00:07:59.390 Emily Giant: Yeah, and I’ll write out all the bullet points in the next little bit here in the channel, so that,
66 00:08:00.020 ⇒ 00:08:03.680 Emily Giant: If you do have time, you can… Potentially help in.
67 00:08:04.750 ⇒ 00:08:05.340 Uttam Kumaran: Okay.
68 00:08:06.410 ⇒ 00:08:07.110 Emily Giant: Yeah.
69 00:08:07.440 ⇒ 00:08:19.450 Emily Giant: But I feel… I feel like we’re gonna… like, I worked a lot this weekend, in addition to getting Raging Poison Ivy. It’s, like, one of my best talents, is getting it. But,
70 00:08:19.810 ⇒ 00:08:23.570 Emily Giant: I think we’re actually in a better spot
71 00:08:24.020 ⇒ 00:08:30.160 Emily Giant: than I thought we were Friday, with revenue, like, I don’t think it will take the whole week to get these things debugged.
72 00:08:31.890 ⇒ 00:08:36.999 Uttam Kumaran: Yeah, I guess I’m sort of, like, I think Damalada and you guys, as long as you’re sort of,
73 00:08:37.700 ⇒ 00:08:55.170 Uttam Kumaran: you’re sort of comfortable. We’re speaking with Zach tomorrow, just a little bit about, like, what kind of, like, what the next phase is going to look like, so I should have some ability to sort of talk through that after tomorrow. And then we have about, yeah, roughly this end of this week and next week.
74 00:08:55.170 ⇒ 00:08:57.420 Emily Giant: So if we should…
75 00:08:57.760 ⇒ 00:09:03.709 Uttam Kumaran: Yeah, so I think that’s kind of, like, based on tomorrow’s meeting, I’ll have some sort of understanding for this whole team on, like, what’s gonna happen next.
76 00:09:03.710 ⇒ 00:09:22.550 Emily Giant: Yeah. Utam, if you could… I know that Demolade’s been, like, instrumental in creating these, but the snapshot data, if Demolade could focus on revenue, and you could take a look at, like, the snapshot structure and why it’s so weird and not refreshing, that could be really helpful. You are always working on the snapshot data.
77 00:09:22.550 ⇒ 00:09:30.449 Uttam Kumaran: Yeah, Awash, do you want to take that? Because, yeah, I feel like the main reasons the snapshots changed a lot is, one, we… we ended up,
78 00:09:30.750 ⇒ 00:09:39.850 Uttam Kumaran: I think we just changed a bunch of columns, and then we ended up… that job just got paused, and so it kind of, like, caused some issues, so maybe Awash, do you want to take a look at that?
79 00:09:39.960 ⇒ 00:09:42.880 Uttam Kumaran: And then, yeah, we can also resolve that this week.
80 00:09:43.680 ⇒ 00:09:45.739 Awaish Kumar: Okay, yeah, I’ll take.
81 00:09:46.710 ⇒ 00:09:48.039 Emily Giant: Yeah, that would be awesome.
82 00:09:49.140 ⇒ 00:09:57.410 Uttam Kumaran: Okay, great. Alright, yeah, please, please send me any of the subscription issues, and then, yeah, anything on the forecast model, happy to look, and then… yeah, we’ll just chat and Slack.
83 00:09:57.580 ⇒ 00:09:58.960 Emily Giant: Alright, sounds good.
84 00:09:58.960 ⇒ 00:10:00.480 Uttam Kumaran: Okay. Thanks, everyone.
85 00:10:00.480 ⇒ 00:10:01.260 Emily Giant: Bye!
86 00:10:01.480 ⇒ 00:10:02.450 Awaish Kumar: We do, Mike.