Meeting Title: Urban Stems Revenue Framework Discussion Date: 2025-10-01 Meeting participants: Emily Giant, Demilade Agboola, Emily’s Fellow Note Taker, Amber Lin, perry, Uttam Kumaran
WEBVTT
1 00:00:10.890 ⇒ 00:00:12.210 Emily Giant: Hello again.
2 00:00:16.219 ⇒ 00:00:17.699 Demilade Agboola: Long time no see.
3 00:00:18.000 ⇒ 00:00:19.500 Emily Giant: I know, I know.
4 00:00:19.680 ⇒ 00:00:26.930 Emily Giant: Checking to make sure, Perry… I’m pretty sure she accepted the meeting, but I know she got the invite
5 00:00:27.200 ⇒ 00:00:28.750 Emily Giant: Just today.
6 00:00:28.920 ⇒ 00:00:31.209 Demilade Agboola: Yeah, but I thought she accepted it.
7 00:00:31.210 ⇒ 00:00:32.959 Emily Giant: Oh, okay, perfect. She’ll be here.
8 00:00:40.540 ⇒ 00:00:41.690 Amber Lin: Hello!
9 00:00:42.140 ⇒ 00:00:43.090 Emily Giant: Hi!
10 00:00:44.580 ⇒ 00:00:46.380 Emily Giant: Oh, are you in the office today?
11 00:00:47.820 ⇒ 00:00:50.189 perry: Yeah. Pretty quiet here, but…
12 00:00:50.200 ⇒ 00:00:51.730 Emily Giant: Yeah, it’ll just stay.
13 00:00:52.160 ⇒ 00:00:55.299 Emily Giant: It’s a really sweet shot of the Empire State Building behind you, though.
14 00:00:55.580 ⇒ 00:01:01.170 Emily Giant: That’s really cool. I’ve never seen that before in, like, the background of someone’s office shot.
15 00:01:01.370 ⇒ 00:01:07.749 perry: Sweet. I think the only one you would have ever seen it was the room over in the corner, I think also has a shot, but…
16 00:01:09.040 ⇒ 00:01:11.780 perry: Yeah, there’s not as many people who sit on this side.
17 00:01:12.410 ⇒ 00:01:14.929 Emily Giant: Yeah, it almost looks fake. It’s really cool.
18 00:01:14.930 ⇒ 00:01:16.030 perry: It kind of just looks like it.
19 00:01:17.890 ⇒ 00:01:19.910 Emily Giant: Oh, we got the crew here, nice!
20 00:01:22.690 ⇒ 00:01:23.880 Uttam Kumaran: Hello?
21 00:01:24.370 ⇒ 00:01:25.040 Uttam Kumaran: We’re at this point.
22 00:01:25.040 ⇒ 00:01:25.420 Emily Giant: Yay!
23 00:01:27.570 ⇒ 00:01:28.620 Uttam Kumaran: Nice.
24 00:01:28.750 ⇒ 00:01:30.459 Uttam Kumaran: Welcome back, Emily.
25 00:01:30.980 ⇒ 00:01:32.740 Emily Giant: Thanks, it’s good to be back.
26 00:01:34.290 ⇒ 00:01:35.080 Uttam Kumaran: Awesome.
27 00:01:36.700 ⇒ 00:01:42.460 Emily Giant: Even though my voice does not work, sorry, I’m, like, very scratchy and just want to warn people before I’m not sick.
28 00:01:43.020 ⇒ 00:01:44.500 Uttam Kumaran: No worries.
29 00:01:44.500 ⇒ 00:01:45.360 Emily Giant: rating.
30 00:01:45.360 ⇒ 00:01:48.850 Amber Lin: It sounds very different from yesterday, it’s a lot better.
31 00:01:48.850 ⇒ 00:01:50.639 Emily Giant: Much better, yeah.
32 00:01:50.800 ⇒ 00:01:51.720 Amber Lin: Yeah.
33 00:01:51.890 ⇒ 00:01:57.600 Amber Lin: Barry, thank you for joining this meeting. I know it’s a bit late, and it’s almost at the end of your workday.
34 00:01:58.550 ⇒ 00:02:08.610 perry: Sorry, there’s family drama going on in the group chat. My mom’s trying to watch the Cubs game, and my dad has messed up our YouTube TV account somehow, and so she’s incapable of watching the Cubs game, and she’s very not happy about it, so…
35 00:02:08.610 ⇒ 00:02:09.320 Amber Lin: Okay.
36 00:02:09.610 ⇒ 00:02:14.120 perry: So, if anyone sees me frantically look at my phone, it’s my mother. I have to answer it.
37 00:02:14.120 ⇒ 00:02:15.840 Amber Lin: Okay.
38 00:02:16.020 ⇒ 00:02:34.000 Amber Lin: I know on the agenda, a few things that Demolati wanted to check with you, and then on our side, on the revenue stuff, we have a few models and works we want to sign off with you, just to confirm it’s good before we proceed. So that’s the two items I have on my end.
39 00:02:34.000 ⇒ 00:02:38.990 Amber Lin: I guess, Demolado, do you have anything else you want to add, or should we just get started?
40 00:02:39.160 ⇒ 00:02:45.350 Uttam Kumaran: Yeah, we just start there, and then if we have time at the end, I can talk through some of my, like, what’s in the PR for subscriptions.
41 00:02:45.770 ⇒ 00:02:52.679 Uttam Kumaran: But it’s not like, I haven’t vetted it through Emily yet, but if we have time, I would love to talk through that, so…
42 00:02:53.730 ⇒ 00:02:54.240 Demilade Agboola: Okay.
43 00:02:54.240 ⇒ 00:02:57.870 perry: My first question, just in general, would be, does this…
44 00:02:58.140 ⇒ 00:03:03.539 perry: also encompass the revenue misalignment in previous years? Or is this just…
45 00:03:04.990 ⇒ 00:03:07.679 perry: Per and onward logic that we’re reviewing.
46 00:03:07.940 ⇒ 00:03:11.410 perry: Or future, like, what would be future logic?
47 00:03:12.540 ⇒ 00:03:27.299 Demilade Agboola: So right now, the framework… so right now, the framework of what we’re building is largely forward-facing. Okay. However, we will also look to… the focus is forward-facing, but we’re also looking to, like, go backwards and also build with that logic previously.
48 00:03:28.780 ⇒ 00:03:29.780 perry: Yeah, okay, got it.
49 00:03:30.430 ⇒ 00:03:34.030 Demilade Agboola: So the… also, just to add, part of that
50 00:03:34.630 ⇒ 00:03:39.910 Demilade Agboola: Framework will be… part of the agenda for this call is also, like, a framework for…
51 00:03:40.120 ⇒ 00:03:54.550 Demilade Agboola: revenue and def… like, just how things are, because we’re trying to create clean data sets for everything right now, so, like, subscriptions, transactions, orders, and so refunds, and the idea is we would like to put everything together into, like.
52 00:03:54.870 ⇒ 00:03:57.300 Demilade Agboola: A framework of how revenue is defined.
53 00:03:57.500 ⇒ 00:04:07.349 Demilade Agboola: And so the idea, part of the agenda of this call is, you know, you’re, like, the expert on that in terms of, urban stems, so…
54 00:04:09.240 ⇒ 00:04:12.029 perry: I mean, my only caveat to that would be, like.
55 00:04:13.280 ⇒ 00:04:24.889 perry: finance and leadership should technically define revenue. I can give what I think is the soundest and most cohesive to previous in general, and, like, what it’s historically been, and that is a starting point, but
56 00:04:25.230 ⇒ 00:04:28.910 perry: like, Dean Mark and Minoxia are gonna have to sign off on to any changes.
57 00:04:29.130 ⇒ 00:04:34.429 perry: Because it’s not apples, it won’t be apples to apples, which might be the case, it’s totally fine if we have to change the way we define things.
58 00:04:34.610 ⇒ 00:04:41.040 perry: So I can give guidance, but I don’t want this to be considered sign-off, because it can’t be. I’m not… I’m not that important.
59 00:04:41.040 ⇒ 00:04:50.150 Uttam Kumaran: I think that’s fine. Yeah, I think basically, like, you’re the closest to our world, and so you’ll know the nuances. They’re gonna…
60 00:04:50.660 ⇒ 00:05:08.699 Uttam Kumaran: you know, what’s gonna happen is they’re gonna say, like, okay, what is your opinion? And so we want to make sure that we have… Totally. We have all that, and also, we can show variance, basically. So once we have a new definition, we can produce variances of, like, if you were to pull this lever, here’s kind of, like, what changes, what it looked like historically, stuff like that, yeah.
61 00:05:10.030 ⇒ 00:05:11.309 perry: That makes total sense.
62 00:05:17.010 ⇒ 00:05:23.079 Demilade Agboola: Okay, so, Latam, do you wanna, like, walk through the… or should I just quickly walk through what we’ve been doing?
63 00:05:23.480 ⇒ 00:05:24.899 Uttam Kumaran: Yeah, do you want to walk through?
64 00:05:25.420 ⇒ 00:05:28.609 Demilade Agboola: Alright, I could start.
65 00:05:29.700 ⇒ 00:05:37.409 Demilade Agboola: So, over the last couple of weeks, we’ve been putting together Forgive me one second…
66 00:05:47.710 ⇒ 00:05:48.400 Demilade Agboola: Right.
67 00:05:50.160 ⇒ 00:05:56.210 Demilade Agboola: Alright, so over the last couple of weeks, we’ve been putting together certain models where
68 00:05:57.350 ⇒ 00:05:59.360 Demilade Agboola: We’ve been able to…
69 00:06:00.060 ⇒ 00:06:09.540 Demilade Agboola: put together certain models for us to be able to get a clearer idea of what is happening with the orders. So we’re largely based on this off the Shopify
70 00:06:10.800 ⇒ 00:06:13.770 Demilade Agboola: Data, which is kind of why we said the revenue right now is.
71 00:06:13.770 ⇒ 00:06:14.480 perry: No.
72 00:06:15.330 ⇒ 00:06:29.760 Demilade Agboola: Well, we would also still go back and also, like, think about things from the previous system, and how that was handled, and then the ideas would merge everything together. But right now, we’re building the forward-facing part, where we’re trying to look everything in Shopify.
73 00:06:30.050 ⇒ 00:06:45.380 Demilade Agboola: And so right now, we’re cleaning… creating clean data sets for, like, the fact orders, and so right now, this is, like, a high level of what’s happening in every order. So it’s, like, a one line, or one row,
74 00:06:45.590 ⇒ 00:06:52.680 Demilade Agboola: summary of what’s going on. So we have the referrals, the person who did it, the… Taxis.
75 00:06:53.850 ⇒ 00:06:55.400 perry: the subtotal…
76 00:06:55.480 ⇒ 00:07:01.470 Demilade Agboola: And all of that, but discounts… again, the idea is this is, like, a one line.
77 00:07:01.700 ⇒ 00:07:03.500 Demilade Agboola: Idea of what’s going on there.
78 00:07:04.630 ⇒ 00:07:10.300 Demilade Agboola: Based off the Shopify data, refunded amounts, if any, refunded quantity, and…
79 00:07:10.600 ⇒ 00:07:21.449 Demilade Agboola: that allows us to have an idea of what’s going on. We also have the fact order line items, which is, in its own way, kind of like a…
80 00:07:21.790 ⇒ 00:07:35.260 Demilade Agboola: facts or borders, if you think about it. So now we have the orders broken down into each line item, and what’s going on in each line item, when to refund, where it’s the unit price, the quantity, all that line item.
81 00:07:35.340 ⇒ 00:07:46.809 Demilade Agboola: And so that’s kind of how we’re doing things right now, in terms of orders, so we have a clean data set, and that allows us to be able to put things together
82 00:07:47.120 ⇒ 00:07:54.879 Demilade Agboola: In a neat way to be able to find the… Total, basically, on each order.
83 00:07:55.450 ⇒ 00:08:00.630 Demilade Agboola: So that’s what’s been happening on this side. I know Utam’s been working on subscriptions.
84 00:08:00.830 ⇒ 00:08:03.730 Demilade Agboola: That’s also an important part of this.
85 00:08:07.460 ⇒ 00:08:08.110 perry: Okay.
86 00:08:08.310 ⇒ 00:08:09.820 perry: I think I follow so far.
87 00:08:11.350 ⇒ 00:08:19.149 Uttam Kumaran: So, I guess my question would be, like, what’s the best way to start to, like, QA this? Would it be helpful to, like.
88 00:08:19.490 ⇒ 00:08:23.040 Uttam Kumaran: We are producing scenarios where we look at, like, a single order.
89 00:08:23.040 ⇒ 00:08:41.109 perry: Yeah, I think the best way is work from problem orders forward. So I would look at CareTouch orders, I would look at orders during the Shopify relaunch, how they, like, how do they, with, like, kits and bundles. So, like, if someone orders the American Rose, which is a Vogue product, and adds on a candle, how does that report?
90 00:08:41.110 ⇒ 00:08:51.739 perry: how does just the American Rose Report. Like, I would just start picking, kind of, those oddity scenarios, but I would definitely start with care-touched orders, because those are going to be the wonkiest, they always are, because…
91 00:08:52.670 ⇒ 00:08:54.850 Uttam Kumaran: I believe, and like, correct me if I’m wrong.
92 00:08:55.030 ⇒ 00:09:11.029 perry: If a customer calls us and says, I want to change the bouquet to XYZ, I didn’t mean to order the Margo, I want to order the Autumn Sky, and there’s a $3 differential, we charge them that differential, and I do not know how that makes its way through Shopify and then into the updated revenue stream.
93 00:09:11.030 ⇒ 00:09:22.969 perry: So, I would certainly reach out to CARE, Ian, and Laura, and just, like, say, hand us your weirdest order numbers, and see what you can get there, and then definitely would hard test
94 00:09:23.050 ⇒ 00:09:35.179 perry: Vogue bundles, so anything that’s FLRK, 3-piece bundles, again, anything that’s FLRK, and then places where people ordered bundles and added on another add-on of the pre-bundled items.
95 00:09:35.310 ⇒ 00:09:40.430 perry: Those would be my, kind of, 3 starting points. Also, making sure to test heavily.
96 00:09:40.570 ⇒ 00:09:53.220 perry: Mother’s Day is probably a good box for this, although we might have done something more recently where we can pull promos. So, how is something that was put, had a promo on it running through? Just all those kind of different ones.
97 00:09:55.100 ⇒ 00:09:57.760 perry: Those are the main snares that come up in my mind.
98 00:09:59.430 ⇒ 00:10:04.260 Demilade Agboola: That’s very helpful to know. Is it possible to have a list of, problematic…
99 00:10:04.400 ⇒ 00:10:08.269 Demilade Agboola: order IDs, and then we can also then have the…
100 00:10:08.970 ⇒ 00:10:09.660 perry: I can…
101 00:10:09.660 ⇒ 00:10:29.139 perry: send a list of, like, what the scenarios are. I don’t currently have time to pull the order IDs. I’m a one-woman team, and I have back-to-back-to-back allocations right now, but Emily, if I give you the scenarios, I feel like you can create some parameters for a query. Okay, cool. And I would reach out to CARE. CARE will be able to get you the orders. Don’t waste your time for those ones. But I can outline the scenarios and then send that.
102 00:10:29.410 ⇒ 00:10:30.140 Uttam Kumaran: Okay.
103 00:10:30.940 ⇒ 00:10:44.389 Uttam Kumaran: Yeah, and then we’ll… we’ll basically just do, like, a… we’ll follow an ID through the whole thing, and then give you before and after. Like, that’s… that’s gonna be how we sort of get this whole thing. It’s gonna be too hard to look at, like, rough sums. Okay.
104 00:10:45.040 ⇒ 00:10:58.389 Emily Giant: Amber, I just want to call out that we might want to split that ticket that’s specifically about, like, bundle forced upgrades, into, like, these scenarios, because that one is pretty specific, and I think
105 00:10:59.130 ⇒ 00:11:11.690 Emily Giant: Right now, it’s written to encapsulate everything that Perry’s saying, but they really are handled differently at the end of the day. So, something to keep in mind, we might want to split that bundle ticket into more than one ticket.
106 00:11:11.980 ⇒ 00:11:15.909 Amber Lin: Okay. You mean the one currently owned Emilate, right?
107 00:11:16.610 ⇒ 00:11:17.620 Amber Lin: Okay, gotcha.
108 00:11:19.510 ⇒ 00:11:21.909 Amber Lin: You guys should continue, I’ll write that down.
109 00:11:26.720 ⇒ 00:11:27.450 Uttam Kumaran: Okay.
110 00:11:27.750 ⇒ 00:11:31.270 Uttam Kumaran: feel good about that. What other models,
111 00:11:32.160 ⇒ 00:11:35.790 Uttam Kumaran: Should we start tracking that through for Demolade?
112 00:11:39.120 ⇒ 00:11:41.769 Demilade Agboola: Sorry, I didn’t get that. Can you repeat that, please?
113 00:11:41.770 ⇒ 00:11:48.840 Uttam Kumaran: I guess, like, we’re looking at, orders and transactions, like, are there any models that we should start doing
114 00:11:49.120 ⇒ 00:11:52.330 Uttam Kumaran: scenarios for… I know we’re talking about suborders.
115 00:11:52.750 ⇒ 00:11:53.210 Demilade Agboola: Yeah.
116 00:11:55.130 ⇒ 00:12:02.439 Demilade Agboola: I think, yeah, subscriptions will be another major one, I guess, especially as, how, like.
117 00:12:02.630 ⇒ 00:12:05.279 Demilade Agboola: subs are defined in terms of revenue.
118 00:12:05.650 ⇒ 00:12:13.479 Demilade Agboola: So is it only counted as revenue, for instance, on every order that has been placed, or is it counted as revenue
119 00:12:14.140 ⇒ 00:12:18.849 Demilade Agboola: You know, ahead of time, like, just how that, like, how that flows into the revenue framework.
120 00:12:18.980 ⇒ 00:12:20.189 Demilade Agboola: Will be another important point.
121 00:12:20.190 ⇒ 00:12:20.700 Uttam Kumaran: Okay.
122 00:12:21.910 ⇒ 00:12:29.949 Uttam Kumaran: Okay, yeah, I mean, on the subscription side, and maybe I can just, I’ll just share, give me one second.
123 00:12:46.300 ⇒ 00:12:50.120 Uttam Kumaran: So… Couple things here,
124 00:12:52.010 ⇒ 00:12:57.909 Uttam Kumaran: on the revenue… on the subscription side, I’m working on a couple of different models,
125 00:12:58.400 ⇒ 00:13:05.359 Uttam Kumaran: But the main goal is really to end up with a subscriptions model that looks like this. So we have…
126 00:13:05.590 ⇒ 00:13:19.220 Uttam Kumaran: the subscription-related IDs, we have the customer information, all the different timestamps that’s needed, but also I want to pre-calculate things like lifetime value, cycle sends, like sends remaining.
127 00:13:19.360 ⇒ 00:13:26.660 Uttam Kumaran: And then also start to calculate things like retention, things like… the MRR, ARR,
128 00:13:27.150 ⇒ 00:13:33.800 Uttam Kumaran: discount percentages, and this is at the subscription level. So, I guess, like.
129 00:13:33.990 ⇒ 00:13:42.010 Uttam Kumaran: I know this is sort of a new area, and I kind of also want to exclude mapping old subscriptions into this, that’s a separate part, but…
130 00:13:42.050 ⇒ 00:13:57.360 Uttam Kumaran: Is there anything in particular that the team needs that would be kind of wonky within subscriptions that we should start to build scenarios for? Otherwise, I’m just going to try to build one that just has, like, all the bells and whistles, basically, given, like, kind of, like, what I’ve been seeing in the data.
131 00:13:58.090 ⇒ 00:14:00.019 perry: Yeah, I think the biggest…
132 00:14:00.750 ⇒ 00:14:16.019 perry: from my team’s perspective, the biggest thing that we need to make sure is incumbent in, subscriptions forward is the geo aspect, so not what FC it went out of, but what geo it’s going out of. I think PK is going to be your best bet for, kind of, that new MRR, ARR, all that, like, that’s his lane.
133 00:14:16.020 ⇒ 00:14:23.819 perry: So I don’t really have a lot of line of sight into that. I think it’s super valuable, but I just… I don’t know what else there possibly could be.
134 00:14:24.240 ⇒ 00:14:27.789 perry: I think the thing that we’ve struggled to historically
135 00:14:27.930 ⇒ 00:14:52.759 perry: put in there is that future send aspect, because people change the date, so I would pay special attention to how the logic around when the future send is, because that’s also something we need to be able to do. We need to be able to say, I have this many sends for the next 4 weeks out of this many geos, or this many, subscriptions, like Classic this tier, or, like, Luxe this tier, or all that, and when the customer decides to move them, or
136 00:14:52.760 ⇒ 00:14:55.180 perry: Cancel it, or whatever, that needs to then reflect.
137 00:14:55.570 ⇒ 00:14:58.849 perry: That’s historically been a tricky point for us.
138 00:14:59.340 ⇒ 00:15:05.159 perry: I’m trying to think… I think, with the new addition of…
139 00:15:05.380 ⇒ 00:15:22.389 perry: mystery SKU, I don’t know how this would come into play. My biggest question would be, we default them to a certain SKU, they get an email when it’s their second send, not their first send. They… that’s, like, a set thing. When it’s their second send, they get a default SKU, like, we assign them something by default.
140 00:15:22.730 ⇒ 00:15:23.929 perry: And then…
141 00:15:24.250 ⇒ 00:15:43.509 perry: if they go in and change it, they get something else, but I want to know if it was the default or not, because there’s not really, like, there’d be a manual way to track, like, what was the default at the time that season. So I think a yes-no flag on was default, yes or no would be helpful, because that would help identify how many people are actually changing behaviors and changing SKUs
142 00:15:43.510 ⇒ 00:15:51.300 perry: and listening to that email, or is 95% of people just letting the default be the thing when their subsequent sends? So I think that would be a big…
143 00:15:51.460 ⇒ 00:15:52.939 perry: That could be a big one for me.
144 00:15:53.730 ⇒ 00:15:54.540 Uttam Kumaran: Okay.
145 00:15:57.790 ⇒ 00:16:03.560 perry: I’m sure PK will have more. I would also reach out to Amanda Otero, with Sam Shield out on,
146 00:16:04.110 ⇒ 00:16:14.509 perry: Matt Leave, Amanda Otero, I think, is the other marketing, kind of, like, lead on subscriptions specifically. So she might have some notes from Sam Shield on what Sam Shield was hoping for reporting-wise that might be
147 00:16:14.920 ⇒ 00:16:17.310 perry: useful before Sam Schul gets back from that leave.
148 00:16:17.910 ⇒ 00:16:19.769 Amber Lin: How do I spell her name?
149 00:16:21.650 ⇒ 00:16:24.109 perry: Amanda Otero, or Sam Shield?
150 00:16:24.110 ⇒ 00:16:25.329 Amber Lin: And, okay.
151 00:16:25.330 ⇒ 00:16:26.390 perry: Yeah, Amanda.
152 00:16:27.370 ⇒ 00:16:29.609 perry: I believe her to be the only Amanda.
153 00:16:30.100 ⇒ 00:16:31.140 perry: Currently here.
154 00:16:31.310 ⇒ 00:16:32.340 Amber Lin: Sounds good.
155 00:16:34.010 ⇒ 00:16:44.269 Uttam Kumaran: Okay, great. So then I’ll ask PK about that, and then… otherwise, I feel pretty good. It’s not too complicated, but I am doing some logic around…
156 00:16:44.480 ⇒ 00:16:45.340 Uttam Kumaran: -Oh.
157 00:16:47.230 ⇒ 00:16:51.680 Uttam Kumaran: Rah… Well, I’ll just wash that.
158 00:16:54.070 ⇒ 00:17:04.040 Uttam Kumaran: Yeah, like, we’re doing some logic around… Like, subscription types, and then also…
159 00:17:04.210 ⇒ 00:17:10.489 Uttam Kumaran: Looking at things like, the amount of… basically the amount of cycles remaining. Is it…
160 00:17:10.680 ⇒ 00:17:14.439 Uttam Kumaran: recurring, and so these are things that I’m just gonna need someone to look at.
161 00:17:14.780 ⇒ 00:17:19.759 Uttam Kumaran: look at the data and give me, like, somewhere to compare a source of truth to.
162 00:17:20.200 ⇒ 00:17:25.689 perry: Yeah, I think that what the marketing… Yeah, I think Lube is just gonna be the answer on that. I don’t…
163 00:17:27.799 ⇒ 00:17:29.709 perry: Like, I don’t really…
164 00:17:30.819 ⇒ 00:17:46.109 perry: I don’t think… I mean, Emily, correct me if I’m wrong, I don’t think there’s a lot of internal movement on subs these days. I think the exception queue has largely been handled with logic changes on the backend, so I think loops should be the source of truth. So I think it should be a fairly easy reconcile on some of that stuff. If it’s not.
165 00:17:46.319 ⇒ 00:17:50.199 perry: That’s scary, and that means that other stuff is not working out how it’s supposed to.
166 00:17:50.540 ⇒ 00:17:51.260 Uttam Kumaran: Okay, okay.
167 00:17:51.260 ⇒ 00:17:53.330 perry: I don’t wanna… I don’t wanna think about that.
168 00:17:53.870 ⇒ 00:17:55.320 Uttam Kumaran: Okay, okay, cool.
169 00:17:56.090 ⇒ 00:18:00.339 Uttam Kumaran: Great, so yeah, I feel like… I feel pretty good about the subscription’s work.
170 00:18:00.480 ⇒ 00:18:04.339 Uttam Kumaran: So I think probably next steps for us is to get some of those
171 00:18:04.860 ⇒ 00:18:17.239 Uttam Kumaran: tricky IDs, and we’ll do a little bit of, like, just scenario analysis of what, like, the downstream revenue looks like based on those scenarios. And that’s something we can send over and then get feedback on.
172 00:18:17.550 ⇒ 00:18:25.000 Uttam Kumaran: You know, and then I think it’ll take probably a week or two to just iron out what we’re seeing and change logic before we can kind of go
173 00:18:25.150 ⇒ 00:18:31.659 Uttam Kumaran: We’ll start… and in that process, we’ll start to look at, like, what the total aggregates are downstream of all revenue by month, stuff like that.
174 00:18:34.370 ⇒ 00:18:35.220 Uttam Kumaran: Cool.
175 00:18:35.490 ⇒ 00:18:42.890 Demilade Agboola: Oh, also, I just… I was curious if, for the subs,
176 00:18:43.990 ⇒ 00:18:51.629 Demilade Agboola: because I… you mentioned… I just… for, like, you know, orders, we had, like, tricky scenarios. I think, since you said substitute, it was pretty straightforward.
177 00:18:51.820 ⇒ 00:18:58.360 Demilade Agboola: Is there anyone we could ask for… potentially… like…
178 00:18:59.020 ⇒ 00:19:17.110 Demilade Agboola: Or is there any way we could link… we could actually just… I was just thinking now. I was just thinking we could link the subs back to the orders, and just try and find a way in which the tricky orders, or the scenarios that are tricky, how that interacts with subscriptions as well, and potentially if that could play a role into how revenue is defined in those scenarios.
179 00:19:21.820 ⇒ 00:19:29.090 Demilade Agboola: Or will that be an entirely different thing? So, like, if, for instance, you mentioned the scenario where someone upgrades an order, for instance.
180 00:19:30.350 ⇒ 00:19:34.099 Demilade Agboola: And that’s a potential, like, how revenue is defined in Shopify that way.
181 00:19:34.100 ⇒ 00:19:35.570 perry: Yeah. If that also happens.
182 00:19:35.570 ⇒ 00:19:40.549 Demilade Agboola: would that also be a potential tricky scenario? So that’s kind of what I’m trying to see, if…
183 00:19:42.750 ⇒ 00:19:56.089 perry: I’ve never heard of someone calling us and asking us to change them from a classic to a seasonal, or a seasonal to a luxe, but it is certainly worth asking. We can’t. NCM, they say we can’t. But I would say…
184 00:19:56.300 ⇒ 00:20:17.599 perry: That’s a great question, and I would add to the list of things to ask for care. What are the worst things that they see when getting called or emailed about subscriptions? Because that’ll… anything that… anything in the care world that’s reoccurring are going to be your problem orders. Those manual touches on orders are always going to be your problem, children. So, I think as long as care has an idea, like, has a… knows that you guys are looking for
185 00:20:17.600 ⇒ 00:20:21.740 perry: scenarios of oddities, they can give you a healthy list, I’m sure.
186 00:20:23.580 ⇒ 00:20:27.120 Demilade Agboola: Okay, sounds good. Just wanted to kind of be ahead on that.
187 00:20:28.080 ⇒ 00:20:41.759 Demilade Agboola: In that case, I think if Otan doesn’t have anything else, I think we can kind of have an idea of how we want to define, or get a framework of how we want to define, like, revenue, and how the different things come into play.
188 00:20:42.480 ⇒ 00:20:43.810 Uttam Kumaran: Yeah, I guess one…
189 00:20:43.990 ⇒ 00:20:48.850 Uttam Kumaran: Sorry, one question from my side, too, is can we set up, like, a staging explorer?
190 00:20:49.010 ⇒ 00:20:51.090 Uttam Kumaran: Where we can.
191 00:20:51.550 ⇒ 00:20:57.030 Uttam Kumaran: Just start to, like… we can give this to a couple people, and then it’ll just make it easy for us to, like.
192 00:20:57.290 ⇒ 00:20:59.279 Uttam Kumaran: Look at graphs and stuff.
193 00:20:59.280 ⇒ 00:21:13.599 Emily Giant: We can definitely do that. I did that for, like, the Shopify orders tables, since, PK and Perry don’t have a way to, like, play with it in mode. I’m just adding them to, like, an access group, so it’s technically live, but they’re the only ones who can see it.
194 00:21:14.260 ⇒ 00:21:14.850 Uttam Kumaran: Okay.
195 00:21:15.470 ⇒ 00:21:18.100 Emily Giant: But yeah, did we cover… sorry,
196 00:21:18.340 ⇒ 00:21:24.599 Emily Giant: I spaced a little bit, I think I’m still pretty jet-lagged. Did we cover, like, paused subscriptions?
197 00:21:25.040 ⇒ 00:21:29.930 Emily Giant: Like, any of those elements that would affect forecasting for, like, the upcoming cycles?
198 00:21:30.500 ⇒ 00:21:37.380 Emily Giant: is that all going to be accessible in the subscriptions tables? I know that’s not, like, completely revenue-related, but it’s… Perry’s, like, other…
199 00:21:37.380 ⇒ 00:21:39.099 Uttam Kumaran: Yes. Side with planning.
200 00:21:39.600 ⇒ 00:21:43.450 Uttam Kumaran: Yeah, so there’s active, cancel, pause, and expired.
201 00:21:43.590 ⇒ 00:21:45.870 Uttam Kumaran: So you’ll have all that as a flag.
202 00:21:46.180 ⇒ 00:21:48.690 Uttam Kumaran: Amen.
203 00:21:48.690 ⇒ 00:21:53.869 perry: Do we offer… do we offer the ability… do we offer customers the ability to skip or just pause?
204 00:21:54.230 ⇒ 00:21:54.850 Emily Giant: Both.
205 00:21:55.250 ⇒ 00:21:56.559 perry: We should add Skip, then.
206 00:21:56.740 ⇒ 00:21:57.819 Emily Giant: Yeah, and then…
207 00:21:57.820 ⇒ 00:21:59.590 perry: How many… how many are skipped?
208 00:21:59.590 ⇒ 00:22:02.049 Emily Giant: Yeah. There should be a date of, like.
209 00:22:02.240 ⇒ 00:22:11.350 Emily Giant: when it comes back, because with one of the options, I don’t remember which one, but you can choose which date to reinstate your subscription, so it…
210 00:22:11.350 ⇒ 00:22:11.910 Uttam Kumaran: Hmm.
211 00:22:11.910 ⇒ 00:22:12.480 Emily Giant: Yeah.
212 00:22:12.480 ⇒ 00:22:12.920 Uttam Kumaran: That’s right.
213 00:22:12.920 ⇒ 00:22:15.919 Emily Giant: I’m not sure if that’s available in the data, but…
214 00:22:16.880 ⇒ 00:22:20.830 Uttam Kumaran: I guess what I should do… yeah, I should think about skipped.
215 00:22:21.360 ⇒ 00:22:23.499 Uttam Kumaran: Well, yeah, I should think about…
216 00:22:23.990 ⇒ 00:22:27.510 Emily Giant: Yeah, we have… you should try to order a subs… well, not try, but, like.
217 00:22:27.990 ⇒ 00:22:41.710 Emily Giant: mess around with ordering a subscription on our website, because there’s, like, too many options, in my opinion, but all of them are used by customers. Like, there’s delay, skip, pause.
218 00:22:42.270 ⇒ 00:22:48.660 Emily Giant: All of these different things that offer different options of when to kick back in with the next subscription.
219 00:22:48.830 ⇒ 00:22:49.819 Uttam Kumaran: Okay, okay.
220 00:22:50.360 ⇒ 00:22:52.239 Uttam Kumaran: So yeah, I can… you just…
221 00:22:55.550 ⇒ 00:23:00.040 Emily Giant: I can always refund you if you accidentally order it, so…
222 00:23:00.040 ⇒ 00:23:04.590 Uttam Kumaran: Okay, yeah, maybe I’ll… Brushes or fashion store supplies.
223 00:23:06.140 ⇒ 00:23:07.070 Uttam Kumaran: Her mom.
224 00:23:07.550 ⇒ 00:23:08.820 Emily Giant: Oh, that’d be sweet.
225 00:23:09.150 ⇒ 00:23:13.630 Uttam Kumaran: But then I’m on a subscription, and… Then you got me.
226 00:23:14.580 ⇒ 00:23:21.310 Emily Giant: It’s alright. I know some people, they can, they can refund that for you if it gets out of hand.
227 00:23:22.350 ⇒ 00:23:25.780 Uttam Kumaran: Okay, so I’m still going to figure out subscription policy.
228 00:23:26.580 ⇒ 00:23:27.609 Uttam Kumaran: It’s okay.
229 00:23:27.610 ⇒ 00:23:29.550 Amber Lin: Okay.
230 00:23:29.900 ⇒ 00:23:40.539 Amber Lin: If we’re done, I have a question of when is the next time that we’ll need stuff to get reviewed? Because I know Perry’s really, really busy, and I just want to have that in advance.
231 00:23:43.640 ⇒ 00:23:48.489 Uttam Kumaran: If we can get the order IDs and stuff, I feel like we can run a scenario and talk again next week.
232 00:23:48.870 ⇒ 00:23:49.610 Emily Giant: Yeah.
233 00:23:50.830 ⇒ 00:23:53.989 Amber Lin: Okay, Perry, would you be free next week?
234 00:23:57.730 ⇒ 00:23:59.769 Amber Lin: Oh, you’re on mute.
235 00:24:03.030 ⇒ 00:24:06.950 perry: Let me check… the sauna…
236 00:24:07.070 ⇒ 00:24:10.040 perry: What am I supposed to be doing next week? I don’t even know anymore.
237 00:24:13.300 ⇒ 00:24:20.419 perry: Demand plan V2. Okay, Demand Plan V2 is next week. Yeah, I’m a little bit more free next week, so that’s… I can do next week.
238 00:24:21.140 ⇒ 00:24:24.730 Amber Lin: Sounds good. Then I’ll probably…
239 00:24:24.730 ⇒ 00:24:26.209 perry: I do have a half day on Friday.
240 00:24:26.210 ⇒ 00:24:38.010 Amber Lin: Okay, I’ll meet with Emily, and then she can see your calendar, so I’ll… I’ll grab that time once we’re closer to getting, getting this done.
241 00:24:38.410 ⇒ 00:24:38.970 perry: Sounds good.
242 00:24:39.090 ⇒ 00:24:39.970 Amber Lin: Okay.
243 00:24:42.030 ⇒ 00:24:42.710 Emily Giant: Buh?
244 00:24:42.710 ⇒ 00:24:43.320 Amber Lin: Hey.
245 00:24:43.890 ⇒ 00:24:45.039 perry: Oh, thanks guys.
246 00:24:45.350 ⇒ 00:24:46.580 Uttam Kumaran: Thank you.
247 00:24:46.580 ⇒ 00:24:47.360 Emily Giant: Bye.
248 00:24:47.360 ⇒ 00:24:48.120 Uttam Kumaran: I agree.