Meeting Title: US x BF | Standup Date: 2025-10-15 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:00:17.040 ⇒ 00:00:18.100 Demilade Agboola: I’m moving.
2 00:00:18.590 ⇒ 00:00:20.409 Emily Giant: Long time no see.
3 00:00:20.760 ⇒ 00:00:22.239 Demilade Agboola: Yeah, it’s been ages.
4 00:00:22.240 ⇒ 00:00:23.610 Emily Giant: Oh, I know, I’m…
5 00:00:23.750 ⇒ 00:00:28.209 Emily Giant: I feel like I… I’m just totally lost on what’s going on in your life, and…
6 00:00:28.700 ⇒ 00:00:34.239 Emily Giant: what you’re working on… I’m kidding. Is Amber back today?
7 00:00:34.800 ⇒ 00:00:36.270 Demilade Agboola: No, I believe it’s tomorrow.
8 00:00:36.470 ⇒ 00:00:37.310 Emily Giant: Okay.
9 00:00:38.220 ⇒ 00:00:45.309 Emily Giant: No worries. Well, as long as a wish joins, hopefully we can run through the GA4 stuff.
10 00:00:45.880 ⇒ 00:00:50.900 Emily Giant: Yeah, I mean, to be fair, we do have a grooming session after a beautiful time will be there, so it’ll be easier to…
11 00:00:50.970 ⇒ 00:00:51.970 Demilade Agboola: Kinda.
12 00:00:52.500 ⇒ 00:00:56.100 Demilade Agboola: Scope out things for the rest of this sprint, as well as next sprint.
13 00:00:56.270 ⇒ 00:00:57.630 Emily Giant: Yeah, that makes sense.
14 00:01:00.820 ⇒ 00:01:08.870 Emily Giant: So, with subscriptions… I’m just working on the union. You know how, like.
15 00:01:09.290 ⇒ 00:01:18.140 Emily Giant: casting the correct type, yada yada yada, between the legacy and the loop orders. That’s, like, I’m down to that. And then I have a couple more, like.
16 00:01:19.490 ⇒ 00:01:24.270 Emily Giant: A couple more cleanup things that I’d like to do, but it’s really, really close.
17 00:01:25.430 ⇒ 00:01:28.250 Demilade Agboola: But the revenue numbers, like, fine.
18 00:01:30.140 ⇒ 00:01:30.940 Emily Giant: Yeah.
19 00:01:30.940 ⇒ 00:01:33.789 Demilade Agboola: I know you did mention that we have dupes, so…
20 00:01:34.450 ⇒ 00:01:40.350 Emily Giant: The dupes are gone, now I’m just… it’s truly, like, so… here, show you real quick.
21 00:01:48.050 ⇒ 00:01:51.569 Emily Giant: Okay, so if I go to,
22 00:01:53.080 ⇒ 00:01:57.809 Emily Giant: this is where I’m merging the… this is all the loop stuff.
23 00:01:59.580 ⇒ 00:02:02.299 Emily Giant: And then there’s a field called,
24 00:02:03.500 ⇒ 00:02:10.769 Emily Giant: It might error, I just was trying to extract something new, yeah. So I’m trying to extract something new, and I think it’s giving, like, a JSON parse error.
25 00:02:11.160 ⇒ 00:02:11.950 Emily Giant: Yeah.
26 00:02:13.940 ⇒ 00:02:15.479 Emily Giant: Let me do this real quick.
27 00:02:17.690 ⇒ 00:02:19.350 Emily Giant: I was trying to say, like.
28 00:02:20.420 ⇒ 00:02:27.380 Emily Giant: if, so it’s this, like, as long as the SKU is filled in, it’s gonna get attributed the correct
29 00:02:28.110 ⇒ 00:02:29.090 Emily Giant: price.
30 00:02:29.240 ⇒ 00:02:32.449 Emily Giant: And then I have the historical doing the same thing.
31 00:02:32.550 ⇒ 00:02:35.110 Emily Giant: But… where’s that parse error?
32 00:02:39.920 ⇒ 00:02:41.230 Emily Giant: It’s this.
33 00:02:44.990 ⇒ 00:02:45.820 Demilade Agboola: Oh, okay.
34 00:02:46.010 ⇒ 00:02:48.590 Emily Giant: I’m just gonna do end and see if I can run it then.
35 00:02:55.690 ⇒ 00:02:59.060 Emily Giant: It’s incremental, though, so I feel like it needs a full refresh.
36 00:03:02.170 ⇒ 00:03:04.740 Demilade Agboola: Gotcha, but it seems to be a syntax error.
37 00:03:06.060 ⇒ 00:03:10.730 Emily Giant: Yeah, it was the… I was trying to, I’ll show you what the column looks like.
38 00:03:11.170 ⇒ 00:03:16.109 Emily Giant: I was trying to extract, like, if for any reason,
39 00:03:16.890 ⇒ 00:03:26.229 Emily Giant: the SKU fails to populate, or the name of the subscription fails to populate. I was trying to have it default to,
40 00:03:27.010 ⇒ 00:03:28.490 Emily Giant: Where is lines?
41 00:03:28.490 ⇒ 00:03:29.850 Demilade Agboola: But how’s that happened?
42 00:03:30.610 ⇒ 00:03:35.989 Emily Giant: Not yet, but because we’re getting all of these, like, different subscription…
43 00:03:36.410 ⇒ 00:03:48.639 Emily Giant: products. I’m afraid that it will, so I’m trying to, like, guard it against that. So I’m trying to pull, the SKU, if all else fails, but the problem is there’s two different lines of SKU.
44 00:03:48.980 ⇒ 00:04:02.329 Emily Giant: So I think that’s why I was failing, because it didn’t know, like, which one to grab. So I just need to, like, clean that up a little bit. But I’ve been able to extract a lot of stuff out of this, where we don’t have the information, so…
45 00:04:03.570 ⇒ 00:04:12.860 Emily Giant: it should be okay. I just want to show you the revenue column. Once this is done refreshing.
46 00:04:15.330 ⇒ 00:04:19.559 Emily Giant: But yeah, I’m working on… Just making sure that…
47 00:04:19.980 ⇒ 00:04:24.840 Emily Giant: all the columns align in fact suborder, or fact, subscriptions, and then…
48 00:04:25.910 ⇒ 00:04:36.419 Emily Giant: everything else has been looking good, but I am getting greedy and trying to, like, fill in every little gap, hence the trying to extract the SKU from the JSON.
49 00:04:36.530 ⇒ 00:04:40.210 Emily Giant: But I can just bypass that for now and, like, continue iterating.
50 00:04:40.780 ⇒ 00:04:43.170 Emily Giant: So that you can work with the… the…
51 00:04:43.340 ⇒ 00:04:50.499 Emily Giant: revenue. What else do you need in here? Do you need, like, the product variant? Do you need anything like that outside of the order number?
52 00:04:54.050 ⇒ 00:05:01.790 Demilade Agboola: things like SKU would be helpful, but the order number, if the order number exists, I can always tie it back to the Shopify factor number.
53 00:05:02.190 ⇒ 00:05:07.750 Demilade Agboola: And get the… get what I need from that… that table, basically.
54 00:05:07.990 ⇒ 00:05:11.599 Emily Giant: Okay, the Shopify ID and the OMS ID are both…
55 00:05:12.040 ⇒ 00:05:17.370 Emily Giant: Like, it will fail if they’re not… If they’re null.
56 00:05:17.840 ⇒ 00:05:20.859 Emily Giant: So, they should both be there.
57 00:05:22.030 ⇒ 00:05:23.130 Demilade Agboola: Sounds good, then.
58 00:05:23.930 ⇒ 00:05:30.440 Emily Giant: I want to show this revenue stuff… So, yeah.
59 00:05:30.600 ⇒ 00:05:37.480 Emily Giant: like, for this, I have… it’s called, like, amortized… subscription revenue?
60 00:05:37.800 ⇒ 00:05:47.060 Emily Giant: I’ll probably update the name to match, whatever I had in the legacy models, because I think it made more sense. It was, like, line item revenue, something like that, but…
61 00:05:51.210 ⇒ 00:05:52.470 Demilade Agboola: You’re doing good.
62 00:05:53.330 ⇒ 00:05:54.200 Emily Giant: Pardon?
63 00:05:54.630 ⇒ 00:05:55.890 Emily Giant: That looks good.
64 00:05:58.680 ⇒ 00:06:01.769 Emily Giant: Not null OMS order ID. Why?
65 00:06:02.230 ⇒ 00:06:07.829 Emily Giant: 670 null. Okay, I’ve got to work on that. That doesn’t make sense. But…
66 00:06:14.270 ⇒ 00:06:15.540 Demilade Agboola: Yeah, I really like a studio.
67 00:06:16.390 ⇒ 00:06:20.629 Demilade Agboola: Without… and at least, you know, show Perry today. Oh, sorry.
68 00:06:22.030 ⇒ 00:06:27.439 Demilade Agboola: Ideally, so at least we can get some feedback, get an idea of how good the revenue looks.
69 00:06:27.550 ⇒ 00:06:30.420 Demilade Agboola: From a general perspective, from a…
70 00:06:32.500 ⇒ 00:06:36.809 Demilade Agboola: what’s that thing called? From a general perspective, and just from a quick, like.
71 00:06:37.030 ⇒ 00:06:41.349 Demilade Agboola: insights perspective, too. So, like, oh, these are what we’re seeing.
72 00:06:41.470 ⇒ 00:06:45.410 Demilade Agboola: the top, you know, SKUs are for the past, like, 3 months, 2 months.
73 00:06:45.410 ⇒ 00:06:46.160 Emily Giant: TV.
74 00:06:46.610 ⇒ 00:06:52.829 Demilade Agboola: just get an idea of, like, if that tracks with what she sees, what she expects, things like that. So…
75 00:06:54.650 ⇒ 00:06:57.859 Demilade Agboola: that’s kind of why I’ll really like us to tie this up, like, today.
76 00:06:57.860 ⇒ 00:07:05.800 Emily Giant: Yeah. You know, get ready for tomorrow or something. Yeah, I… I’m… Thinking about, like, where…
77 00:07:06.460 ⇒ 00:07:11.410 Emily Giant: You could step in to help here, but it’s so close to being done that it’s like.
78 00:07:11.910 ⇒ 00:07:13.750 Emily Giant: It might take me longer to…
79 00:07:13.930 ⇒ 00:07:19.739 Emily Giant: ask for help than to just finish it, trying to find that. So, amortized subscription revenue…
80 00:07:20.460 ⇒ 00:07:25.260 Emily Giant: So, yeah, it’s like… turning out
81 00:07:26.490 ⇒ 00:07:28.919 Emily Giant: There’s no zeros, there’s no, like…
82 00:07:29.390 ⇒ 00:07:34.910 Emily Giant: I’ll add a test so that if it’s not one of the accepted values, it will flag it.
83 00:07:35.940 ⇒ 00:07:40.800 Emily Giant: But for now, Like, yeah, so this was a…
84 00:07:42.340 ⇒ 00:07:46.000 Emily Giant: Prepaid, but it’s still correctly coming through as 75.
85 00:07:54.720 ⇒ 00:07:56.810 Emily Giant: Don’t know why that’s 70, but whatever.
86 00:07:57.670 ⇒ 00:08:07.730 Emily Giant: Okay, so, as far as the fact subscriptions, I’m still just, cleaning this up here.
87 00:08:09.550 ⇒ 00:08:18.010 Emily Giant: So that all of these are present. What I can do is, just deploy the loop part.
88 00:08:18.710 ⇒ 00:08:23.350 Emily Giant: And then you could use that, and then, I could…
89 00:08:23.610 ⇒ 00:08:26.710 Emily Giant: retroactively go back and add the historical, would that help?
90 00:08:27.490 ⇒ 00:08:29.320 Demilade Agboola: Yeah, yeah, that’ll be quite helpful.
91 00:08:29.320 ⇒ 00:08:39.650 Emily Giant: Okay, let’s just do… I’ll do… In the subscriptions, where’s the mart?
92 00:08:43.909 ⇒ 00:08:45.350 Emily Giant: So if I do temp.
93 00:08:57.250 ⇒ 00:09:05.190 Emily Giant: I mean… You could technically just use… I just deployed this, but… Anyway, let’s…
94 00:09:30.970 ⇒ 00:09:37.970 Emily Giant: Then, what I need to update is it’s saying things are null that are, like, actually not needing to be null.
95 00:09:44.310 ⇒ 00:09:45.599 Emily Giant: Jupiter now.
96 00:09:48.320 ⇒ 00:09:50.560 Emily Giant: Yep, there is subscription tier.
97 00:09:50.870 ⇒ 00:09:52.840 Emily Giant: Does not need to be null.
98 00:09:53.000 ⇒ 00:09:54.900 Emily Giant: That does not need to be null.
99 00:09:57.450 ⇒ 00:10:00.600 Emily Giant: These, I’ll just leave as null, because you don’t need them right now anyway.
100 00:10:02.080 ⇒ 00:10:02.920 Demilade Agboola: Yeah.
101 00:10:24.550 ⇒ 00:10:25.580 Emily Giant: Did it fail?
102 00:10:30.930 ⇒ 00:10:36.540 Emily Giant: Yes, it does! I just need to do, like, a… Full refresh.
103 00:10:37.050 ⇒ 00:10:40.890 Demilade Agboola: You know what, can you, like, how long do you think it’ll take you to finish up everything?
104 00:10:41.180 ⇒ 00:10:42.250 Emily Giant: Everything?
105 00:10:42.430 ⇒ 00:10:42.860 Demilade Agboola: Yeah.
106 00:10:42.860 ⇒ 00:10:46.340 Emily Giant: An hour?
107 00:10:46.740 ⇒ 00:10:50.649 Demilade Agboola: Yeah, in that case, that’s fine, because, like, ultimately, I…
108 00:10:50.970 ⇒ 00:10:52.889 Demilade Agboola: Probably will work on this, like.
109 00:10:53.260 ⇒ 00:10:57.800 Demilade Agboola: Later, either later at night or early tomorrow morning, like, my time, so we’ll see.
110 00:10:57.800 ⇒ 00:11:04.159 Emily Giant: Okay, so I’ll just keep working on that finished model, and, yeah, okay.
111 00:11:04.680 ⇒ 00:11:08.770 Emily Giant: If for any reason it’s not done, I’ll just deploy the temporary one.
112 00:11:09.300 ⇒ 00:11:10.860 Demilade Agboola: Oh, okay, alright, sounds good.
113 00:11:11.130 ⇒ 00:11:13.299 Emily Giant: Alright, cool. I’ll see you at grooming.
114 00:11:13.300 ⇒ 00:11:14.480 Demilade Agboola: Alright then, take care.
115 00:11:14.480 ⇒ 00:11:15.389 Emily Giant: Bye, bye.