Meeting Title: Revenue and Subscription Data Review Date: 2025-10-14 Meeting participants: Emily Giant, Demilade Agboola
WEBVTT
1 00:00:28.210 ⇒ 00:00:29.230 Demilade Agboola: Alright, I’m moving.
2 00:00:29.430 ⇒ 00:00:31.259 Emily Giant: Hi, how are you?
3 00:00:31.820 ⇒ 00:00:32.969 Demilade Agboola: Pretty good, how are you?
4 00:00:33.350 ⇒ 00:00:41.280 Emily Giant: I’m good. Just working through some annoying duplicate problems with historical subs, but such is life.
5 00:00:43.420 ⇒ 00:00:45.600 Emily Giant: My house is, like…
6 00:00:46.000 ⇒ 00:00:51.690 Emily Giant: There’s no walls in the basement at all right now, so my house is freezing.
7 00:00:52.550 ⇒ 00:00:56.880 Emily Giant: But, yeah, I gotta send you a video of it. It’s… it’s crazy.
8 00:00:57.050 ⇒ 00:00:58.649 Emily Giant: Here, one sec.
9 00:00:59.120 ⇒ 00:01:00.419 Demilade Agboola: When will they be done?
10 00:01:00.800 ⇒ 00:01:07.240 Emily Giant: Never. I don’t… they told me they’d be done yesterday, and my house doesn’t have walls, so they better not be done.
11 00:01:09.720 ⇒ 00:01:15.750 Emily Giant: Yeah, it’s… it’s crazy. This is only, like, half of the basement that I’m sending you.
12 00:01:16.710 ⇒ 00:01:23.910 Demilade Agboola: I think they could just basically say, well, we’re done now, you know, happy, happy Halloween, you know?
13 00:01:23.910 ⇒ 00:01:32.610 Emily Giant: Yeah, right? Like, I don’t even know how I slept last night, given that, like, anyone could have crawled into my home at any point in time.
14 00:01:32.720 ⇒ 00:01:33.710 Demilade Agboola: But…
15 00:01:33.710 ⇒ 00:01:35.539 Emily Giant: Wait, now I have a better video than that.
16 00:01:36.060 ⇒ 00:01:37.860 Emily Giant: From the actual basement.
17 00:01:38.850 ⇒ 00:01:41.150 Emily Giant: It’s… So nuts.
18 00:01:43.770 ⇒ 00:01:45.230 Emily Giant: But, hold on.
19 00:01:47.930 ⇒ 00:01:53.290 Emily Giant: But yeah, it’ll be good that my house isn’t falling down, because it was literally falling down. So…
20 00:01:55.980 ⇒ 00:02:00.670 Emily Giant: Yeah, it would have, like, completely fallen within 5 years if we didn’t get it fixed, so…
21 00:02:01.200 ⇒ 00:02:07.540 Demilade Agboola: I mean, better no walls now than a falling house in Yeah, it’s…
22 00:02:08.169 ⇒ 00:02:14.230 Emily Giant: It’s crazy, but anyway. Alright, so we have our thing with Perry today, right?
23 00:02:15.970 ⇒ 00:02:17.040 Emily Giant: That’s okay.
24 00:02:17.040 ⇒ 00:02:18.170 Demilade Agboola: Catch on.
25 00:02:18.900 ⇒ 00:02:23.610 Emily Giant: I think… oh my god, is this my day? I literally have…
26 00:02:23.750 ⇒ 00:02:29.480 Emily Giant: One… one, two, three, four, five, six, seven meetings today.
27 00:02:30.830 ⇒ 00:02:31.790 Emily Giant: 7.
28 00:02:32.100 ⇒ 00:02:33.080 Demilade Agboola: That’s rough.
29 00:02:33.080 ⇒ 00:02:33.830 Emily Giant: Yeah.
30 00:02:33.970 ⇒ 00:02:35.130 Emily Giant: Yep.
31 00:02:35.560 ⇒ 00:02:36.160 Emily Giant: Wow.
32 00:02:36.160 ⇒ 00:02:38.809 Demilade Agboola: I can’t see a meeting with Paris, I’m not sure.
33 00:02:39.020 ⇒ 00:02:45.629 Emily Giant: No, it’s, sorry, I was seeing PK, but Perry’s is… when is our meeting with Perry again?
34 00:02:45.810 ⇒ 00:02:49.279 Demilade Agboola: I don’t seem to have one, I think. Can we schedule one for tomorrow?
35 00:02:49.280 ⇒ 00:02:49.980 Emily Giant: Yeah.
36 00:02:50.090 ⇒ 00:02:52.330 Emily Giant: Okay.
37 00:02:53.780 ⇒ 00:02:58.380 Emily Giant: I have… Maybe we can do it during the working session tomorrow.
38 00:02:59.710 ⇒ 00:03:02.609 Emily Giant: Would that work? Let me, let me text her and see.
39 00:03:06.200 ⇒ 00:03:09.289 Demilade Agboola: No, but okay, still be ready.
40 00:03:11.130 ⇒ 00:03:16.150 Demilade Agboola: Can do it some other time.
41 00:03:17.120 ⇒ 00:03:18.919 Emily Giant: But… is that my voice?
42 00:03:19.400 ⇒ 00:03:25.150 Emily Giant: Yeah, it’s the video you sent me, so I’m watching it. Oh, that was the weirdest thing ever.
43 00:03:25.330 ⇒ 00:03:28.770 Emily Giant: I was like… I don’t remember saying that.
44 00:03:29.520 ⇒ 00:03:33.190 Emily Giant: Wow, that really threw me.
45 00:03:33.640 ⇒ 00:03:34.620 Demilade Agboola: I can imagine.
46 00:03:34.620 ⇒ 00:03:36.360 Emily Giant: Oh my gosh.
47 00:03:36.360 ⇒ 00:03:39.430 Demilade Agboola: I was watching the second video set.
48 00:03:39.530 ⇒ 00:03:41.590 Emily Giant: Isn’t that crazy?
49 00:03:44.260 ⇒ 00:03:46.670 Emily Giant: Join the working session tomorrow at…
50 00:03:46.790 ⇒ 00:03:50.880 Emily Giant: I am to do final RevQA.
51 00:03:53.120 ⇒ 00:03:57.110 Emily Giant: Okay, I’ll get her response soon.
52 00:03:57.290 ⇒ 00:04:02.479 Emily Giant: Do you want to start with revenue stuff, or do you want me to start with subscription stuff?
53 00:04:03.380 ⇒ 00:04:07.850 Demilade Agboola: I mean, revenue stuff is basically in the same spot that…
54 00:04:08.470 ⇒ 00:04:15.750 Demilade Agboola: it was at yesterday that I gave you the… so now we have the iPod revenue, which is just, like, the total…
55 00:04:16.769 ⇒ 00:04:19.909 Demilade Agboola: Like, revenue from every single theme.
56 00:04:19.910 ⇒ 00:04:20.870 Emily Giant: Yeah.
57 00:04:20.870 ⇒ 00:04:23.740 Demilade Agboola: And then we have the…
58 00:04:26.830 ⇒ 00:04:29.930 Demilade Agboola: And we have the… What’s it called?
59 00:04:30.220 ⇒ 00:04:35.070 Demilade Agboola: The actual, like, the fulfilled revenue, which is revenue of everything that went out the door, so…
60 00:04:35.070 ⇒ 00:04:35.800 Emily Giant: Yeah.
61 00:04:36.080 ⇒ 00:04:42.960 Emily Giant: Okay, do you want to just do a couple, like, examples together to make sure…
62 00:04:43.600 ⇒ 00:04:44.580 Demilade Agboola: The…
63 00:04:44.580 ⇒ 00:04:50.619 Emily Giant: We’re all lined up, and then I’m excited to get some help with subscriptions!
64 00:04:51.300 ⇒ 00:04:53.930 Demilade Agboola: Okay, sounds good, so let’s…
65 00:04:55.300 ⇒ 00:05:00.220 Demilade Agboola: Look at the model, and start applying all the items.
66 00:05:01.500 ⇒ 00:05:02.640 Demilade Agboola: Okay.
67 00:05:02.960 ⇒ 00:05:06.120 Demilade Agboola: Do you have any wands you’ll want to send my way?
68 00:05:06.420 ⇒ 00:05:07.550 Emily Giant: Let me look.
69 00:05:12.380 ⇒ 00:05:23.570 Emily Giant: Do you know the song, The Entertainer, that’s like… I have it going through my head, like, over and over again, and it is…
70 00:05:23.770 ⇒ 00:05:27.970 Emily Giant: One of the more annoying songs that there is, so I wish I didn’t.
71 00:05:30.160 ⇒ 00:05:31.710 Emily Giant: Let’s see…
72 00:05:31.710 ⇒ 00:05:35.750 Demilade Agboola: That started recently? Like, in a movie or something.
73 00:05:35.750 ⇒ 00:05:37.010 Emily Giant: Nope.
74 00:05:39.500 ⇒ 00:05:46.540 Emily Giant: It’s just… it’s just there. I still need to listen to, the playlist you sent me.
75 00:05:46.850 ⇒ 00:05:47.640 Demilade Agboola: I’m like…
76 00:05:47.640 ⇒ 00:05:53.309 Emily Giant: very particular with music, and, like, when I listen to it, I have to be, like, in the right headspace, and, like.
77 00:05:53.430 ⇒ 00:05:56.530 Emily Giant: Yeah, and I’ve been in such a… like…
78 00:05:57.480 ⇒ 00:06:01.919 Emily Giant: such a mood with, like, all the sounds going on around me lately that, like…
79 00:06:02.090 ⇒ 00:06:05.979 Emily Giant: the jackhammers and whatnot, that I haven’t.
80 00:06:06.210 ⇒ 00:06:08.279 Demilade Agboola: And that doesn’t help music, too, so…
81 00:06:08.280 ⇒ 00:06:09.809 Emily Giant: It does not. It does not.
82 00:06:10.290 ⇒ 00:06:12.480 Emily Giant: I need to be, like, in a zen state.
83 00:06:12.700 ⇒ 00:06:18.120 Emily Giant: Okay, here we go… Let’s try that one.
84 00:06:19.300 ⇒ 00:06:23.999 Emily Giant: it’s a very normal order, so I just want to see a normal order, and then I’ll find a forced upgrade order.
85 00:06:27.120 ⇒ 00:06:29.010 Demilade Agboola: Okay, sounds good.
86 00:06:46.780 ⇒ 00:06:47.890 Emily Giant: LOL.
87 00:06:48.300 ⇒ 00:06:49.580 Emily Giant: Sorry.
88 00:06:50.280 ⇒ 00:06:51.310 Emily Giant: Hmm…
89 00:07:11.890 ⇒ 00:07:17.839 Demilade Agboola: So, for this… Their revenue is $162.28.
90 00:07:19.140 ⇒ 00:07:21.300 Demilade Agboola: Which… matches up.
91 00:07:24.210 ⇒ 00:07:25.600 Emily Giant: Let me…
92 00:07:32.190 ⇒ 00:07:35.180 Emily Giant: So, I have… 190.
93 00:07:35.310 ⇒ 00:07:36.489 Emily Giant: For that one.
94 00:07:36.840 ⇒ 00:07:38.260 Demilade Agboola: As the revenue.
95 00:07:38.950 ⇒ 00:07:39.959 Demilade Agboola: Yeah, that’s it.
96 00:07:39.960 ⇒ 00:07:52.200 Emily Giant: Oh, dah, sorry, 162 and 28. Yep, sorry, I’m a ding-dong. Yep, perfect. Okay, let’s get some order by… I’m just pulling some forced upgrade orders from…
97 00:07:52.330 ⇒ 00:07:58.590 Emily Giant: Inventory mart, since that’s where we now go to see them, which I like. Mart inventory…
98 00:08:00.910 ⇒ 00:08:03.020 Demilade Agboola: How do you see them in inventory mode?
99 00:08:04.420 ⇒ 00:08:06.880 Emily Giant: Velocity.
100 00:08:09.030 ⇒ 00:08:15.759 Emily Giant: Yeah, exactly. Well, no, there’s a… there’s a SKU, or a column called Forced Upgrade of SKU.
101 00:08:16.070 ⇒ 00:08:16.570 Emily Giant: And again.
102 00:08:16.570 ⇒ 00:08:17.090 Demilade Agboola: Oh, fuck.
103 00:08:17.090 ⇒ 00:08:18.580 Emily Giant: It was forced to upgrade it.
104 00:08:19.880 ⇒ 00:08:20.880 Demilade Agboola: Gotcha.
105 00:08:23.480 ⇒ 00:08:28.899 Emily Giant: Analytics… Why is it… Did I spell analytics wrong?
106 00:08:29.420 ⇒ 00:08:30.270 Demilade Agboola: Okay.
107 00:08:30.270 ⇒ 00:08:36.570 Emily Giant: Sorry. Ordered by adjustment date descending. I just want to get recent ones.
108 00:08:45.250 ⇒ 00:08:55.820 Emily Giant: Alright, I’ll send over a couple. A lot of times, they’re subscriptions, because the subscription SKUs will come in blank, and that’s why it’s hard to find, like, a normal order with a forced upgrade.
109 00:08:55.980 ⇒ 00:08:56.960 Emily Giant: So…
110 00:08:57.630 ⇒ 00:09:04.789 Emily Giant: possibly at the subscription mart, by using that for revenue to, like, override, that will take care of, like, the majority of forced upgrades.
111 00:09:05.070 ⇒ 00:09:07.339 Emily Giant: If there’s still a problem.
112 00:09:12.230 ⇒ 00:09:19.279 Emily Giant: Alright, now I just gotta find the meeting again.
113 00:09:21.320 ⇒ 00:09:23.720 Emily Giant: Here comes some orders.
114 00:09:31.830 ⇒ 00:09:36.219 Emily Giant: And then I want to find a bundle. Wait, that last one was a bundle, wasn’t it?
115 00:09:38.160 ⇒ 00:09:39.219 Emily Giant: I think it was.
116 00:09:45.730 ⇒ 00:09:46.829 Demilade Agboola: Oh, okay.
117 00:10:12.260 ⇒ 00:10:14.600 Demilade Agboola: Okay, so in this…
118 00:10:15.590 ⇒ 00:10:20.870 Demilade Agboola: We had the Margo removed, and then… but it’s a subscription, though, so it makes it.
119 00:10:20.870 ⇒ 00:10:25.770 Emily Giant: Okay. I’ll look through that list and see if there’s a non-subscription one.
120 00:10:26.110 ⇒ 00:10:28.510 Demilade Agboola: I mean, that’s the first one, I’ll look at the other ones.
121 00:10:28.510 ⇒ 00:10:29.280 Emily Giant: Yeah.
122 00:10:34.570 ⇒ 00:10:36.189 Demilade Agboola: Subscription as well.
123 00:10:39.030 ⇒ 00:10:43.389 Emily Giant: Oh my gosh. I’ll be right back. They’ve set my smoke alarm off. One second.
124 00:11:37.860 ⇒ 00:11:45.220 Emily Giant: Hey, I’m so sorry, can I… I have to go. There… something is happening where my carbon monoxide detector is, like, going crazy.
125 00:11:45.430 ⇒ 00:11:46.100 Demilade Agboola: Okay.
126 00:11:46.100 ⇒ 00:11:50.110 Emily Giant: I’ve got to make sure that there’s not, like, carbon monoxide pouring into my house.
127 00:11:50.770 ⇒ 00:11:55.500 Emily Giant: I’ll just… I’ll be right back. I’m just gonna put myself on mute and…
128 00:11:56.650 ⇒ 00:11:57.750 Demilade Agboola: Alright, I’ll be right here.
129 00:11:58.070 ⇒ 00:11:58.760 Emily Giant: Okay.
130 00:11:59.640 ⇒ 00:12:03.200 Emily Giant: Oh my god, sorry. One sec.
131 00:14:47.070 ⇒ 00:14:50.020 Emily Giant: Okay, I’m back. Sorry about that.
132 00:14:50.390 ⇒ 00:14:53.229 Emily Giant: I just wanted to make sure they didn’t, like, bust a gas line.
133 00:14:55.870 ⇒ 00:14:57.430 Demilade Agboola: Is everything settled down?
134 00:14:58.070 ⇒ 00:14:59.370 Emily Giant: Yes.
135 00:15:00.160 ⇒ 00:15:04.769 Emily Giant: But it was going off, and I was like, but I think it’s just the dust.
136 00:15:04.920 ⇒ 00:15:10.859 Emily Giant: So, I just unplugged it. So if suddenly I go silent, just call 911.
137 00:15:13.080 ⇒ 00:15:16.850 Emily Giant: Alright, okay, so back to it. Have we found one that’s not a subscription?
138 00:15:17.180 ⇒ 00:15:20.300 Demilade Agboola: No, all the ones you sent out, all subscriptions.
139 00:15:20.440 ⇒ 00:15:23.369 Emily Giant: Alright, let me adjust my query. I think I can say…
140 00:15:23.970 ⇒ 00:15:26.870 Emily Giant: is not a subscription in this. And…
141 00:15:41.200 ⇒ 00:15:44.210 Emily Giant: Subscription number is… no.
142 00:16:09.720 ⇒ 00:16:11.970 Emily Giant: Okay, running it, just…
143 00:16:39.720 ⇒ 00:16:41.110 Emily Giant: It’s taking forever.
144 00:16:55.310 ⇒ 00:16:57.479 Emily Giant: Alright, sorry, it’s taken forever.
145 00:17:01.180 ⇒ 00:17:02.010 Emily Giant: Okay.
146 00:17:02.540 ⇒ 00:17:04.030 Emily Giant: Got it.
147 00:17:11.760 ⇒ 00:17:12.750 Emily Giant: Alright.
148 00:17:17.119 ⇒ 00:17:18.290 Emily Giant: New batch.
149 00:17:19.550 ⇒ 00:17:20.460 Demilade Agboola: Norms.
150 00:17:41.220 ⇒ 00:17:49.449 Demilade Agboola: Okay, so… Seems like… this, this…
151 00:17:50.120 ⇒ 00:17:52.760 Demilade Agboola: Okay, so the deployment was removed.
152 00:17:54.240 ⇒ 00:17:55.680 Demilade Agboola: That’s what it’s… yeah.
153 00:18:34.250 ⇒ 00:18:36.120 Demilade Agboola: Alright, so…
154 00:18:43.310 ⇒ 00:18:47.599 Emily Giant: Alright. Can you reshare your screen? Sorry, I no longer am seeing it.
155 00:18:47.990 ⇒ 00:18:51.469 Demilade Agboola: My bad, I thought… I forgot I stopped sharing it.
156 00:18:52.820 ⇒ 00:18:54.920 Emily Giant: Alright, damn, Miguel.
157 00:18:56.690 ⇒ 00:19:00.630 Demilade Agboola: Alright, so the new moon was $84.
158 00:19:00.970 ⇒ 00:19:05.080 Demilade Agboola: Again, it uses the price rather than the…
159 00:19:07.190 ⇒ 00:19:10.900 Emily Giant: Okay, so that has to update.
160 00:19:11.080 ⇒ 00:19:14.479 Demilade Agboola: I need to use this, the 73, not this 84.
161 00:19:15.370 ⇒ 00:19:24.989 Emily Giant: Yeah, weirdly. Because that’s the thing that Perry was saying about, like, If it’s, a…
162 00:19:25.120 ⇒ 00:19:27.099 Emily Giant: Well, let me see which one this is.
163 00:19:27.820 ⇒ 00:19:30.439 Emily Giant: Custom added line item.
164 00:19:33.730 ⇒ 00:19:43.090 Emily Giant: Alt and 14… No, we don’t want the 7380… well, yeah, 7386 is what we want, I think.
165 00:19:44.130 ⇒ 00:19:58.469 Emily Giant: This might actually be a discount, though. Like, it’s that whole thing of, like, if it’s a double or triple, it gives the… always gives the struck-through price with the real price to signify to customers that, like, you’re getting a deal because you bought two instead of one.
166 00:19:58.830 ⇒ 00:20:03.529 Emily Giant: But… But that is never actually the,
167 00:20:04.360 ⇒ 00:20:07.400 Emily Giant: The revenue, because it was never the…
168 00:20:07.790 ⇒ 00:20:08.790 Demilade Agboola: Right.
169 00:20:08.790 ⇒ 00:20:10.189 Emily Giant: Yeah, you got me.
170 00:20:10.420 ⇒ 00:20:12.630 Emily Giant: So, in this one, I gotta look it up in…
171 00:20:13.870 ⇒ 00:20:19.650 Demilade Agboola: But is there a way to flag that? Is there an item price that we can compare against?
172 00:20:23.690 ⇒ 00:20:30.280 Emily Giant: So I think it’s the line… the line item sub… line subtotal amount is correct. That’s what we use for revenue, right?
173 00:20:30.460 ⇒ 00:20:38.139 Demilade Agboola: Yeah, but we also add… consider there’s a discount as well, so if there’s a discount, in this case, which is $10.14.
174 00:20:39.000 ⇒ 00:20:41.829 Demilade Agboola: Adding into it, and we’re getting 84.
175 00:20:41.980 ⇒ 00:20:42.730 Demilade Agboola: Fuck.
176 00:20:43.160 ⇒ 00:20:52.240 Demilade Agboola: But, like, how do I know what’s a cross line item? Like, what’s cross… the cross price versus the… an actual discount that we’re adding back to get the revenue?
177 00:20:52.840 ⇒ 00:20:56.329 Emily Giant: You know, I don’t know, so we can just ask Perry about this one.
178 00:20:56.520 ⇒ 00:20:57.370 Demilade Agboola: Okay.
179 00:20:58.630 ⇒ 00:21:03.760 Demilade Agboola: Well, in this case, yeah, what we get is the 84 for this.
180 00:21:04.920 ⇒ 00:21:09.700 Demilade Agboola: 24, 62 for this, 15, 15 for this.
181 00:21:09.980 ⇒ 00:21:12.340 Demilade Agboola: 11.36 for this.
182 00:21:13.270 ⇒ 00:21:15.149 Demilade Agboola: It says free, so it’s zero.
183 00:21:15.910 ⇒ 00:21:17.950 Demilade Agboola: And then the…
184 00:21:24.070 ⇒ 00:21:28.219 Demilade Agboola: And then this… The blood more.
185 00:21:28.470 ⇒ 00:21:30.100 Emily Giant: Is zero.
186 00:21:30.810 ⇒ 00:21:31.510 Demilade Agboola: Yeah.
187 00:21:32.020 ⇒ 00:21:32.780 Emily Giant: Perfect!
188 00:21:36.160 ⇒ 00:21:37.510 Emily Giant: Yeah, looks good.
189 00:21:40.680 ⇒ 00:21:43.169 Emily Giant: So, since that one wasn’t fulfilled.
190 00:21:43.550 ⇒ 00:21:45.959 Demilade Agboola: Yeah, because it wasn’t fulfilled, and you had to refund that amount.
191 00:21:47.050 ⇒ 00:21:47.800 Emily Giant: Yeah.
192 00:21:48.470 ⇒ 00:21:54.990 Demilade Agboola: So, refund ID… Okay, so it’s zero.
193 00:21:56.190 ⇒ 00:21:57.120 Emily Giant: Sweet.
194 00:21:58.470 ⇒ 00:21:59.140 Demilade Agboola: That’s…
195 00:21:59.140 ⇒ 00:21:59.830 Emily Giant: That’s great.
196 00:22:00.240 ⇒ 00:22:02.400 Demilade Agboola: Yeah, so let’s take another one.
197 00:22:06.540 ⇒ 00:22:09.760 Emily Giant: That was a crazy order. A lot of… a lot of junk.
198 00:22:10.030 ⇒ 00:22:17.170 Emily Giant: That’s a subscription? Oh, this is a culprit of… we have a problem with the system where…
199 00:22:17.400 ⇒ 00:22:25.639 Emily Giant: subscriptions are not getting tagged in the data. Like, it’s… It’s not our problem. So…
200 00:22:29.930 ⇒ 00:22:30.700 Emily Giant: Hmm.
201 00:22:32.190 ⇒ 00:22:34.150 Demilade Agboola: Those seem to be a fair number of them.
202 00:22:34.150 ⇒ 00:22:38.339 Emily Giant: Yeah Ugh, jeez.
203 00:22:42.850 ⇒ 00:22:44.350 Demilade Agboola: Yeah, only one in the world.
204 00:22:44.350 ⇒ 00:22:46.210 Emily Giant: Oh my gosh, okay.
205 00:22:47.970 ⇒ 00:22:51.139 Emily Giant: Well, let me grab some more and see. We can both check.
206 00:22:51.360 ⇒ 00:22:53.310 Demilade Agboola: Whether they’re subscriptions or not.
207 00:22:56.790 ⇒ 00:23:03.490 Emily Giant: That’s not good. I… they were supposed to fix that last week, and these are, like, from last week, so…
208 00:23:04.670 ⇒ 00:23:06.000 Emily Giant: Not great.
209 00:23:11.260 ⇒ 00:23:12.200 Emily Giant: Alright.
210 00:23:12.460 ⇒ 00:23:15.590 Emily Giant: I’ll check the ones starting at the bottom to see if they’re subs.
211 00:23:25.410 ⇒ 00:23:26.900 Emily Giant: Alright, here’s one.
212 00:23:27.680 ⇒ 00:23:31.030 Emily Giant: The one at the bottom, Is not a subscription.
213 00:23:31.990 ⇒ 00:23:33.989 Emily Giant: But it also looks exactly like…
214 00:23:34.420 ⇒ 00:23:37.260 Emily Giant: The order that we just looked at.
215 00:23:37.910 ⇒ 00:23:44.399 Emily Giant: Okay… One sec… Like, identical to the one we just looked at.
216 00:23:44.770 ⇒ 00:23:49.139 Emily Giant: With the tarot card, so let’s not do that.
217 00:23:49.480 ⇒ 00:23:50.500 Demilade Agboola: Interesting.
218 00:23:51.310 ⇒ 00:23:56.499 Demilade Agboola: With maybe one person or not the same thing for two different people, because it literally…
219 00:23:57.790 ⇒ 00:23:58.970 Emily Giant: Yeah.
220 00:24:01.050 ⇒ 00:24:01.650 Demilade Agboola: Hmm.
221 00:24:04.060 ⇒ 00:24:07.970 Demilade Agboola: Let’s see, okay, so this… is not.
222 00:24:29.930 ⇒ 00:24:33.130 Emily Giant: Oh, a video message! How does that come through?
223 00:24:38.260 ⇒ 00:24:43.010 Demilade Agboola: So, the video message will come through as…
224 00:24:46.110 ⇒ 00:24:46.840 Demilade Agboola: We do next.
225 00:24:46.840 ⇒ 00:24:48.609 Emily Giant: Video message. Cool.
226 00:24:49.430 ⇒ 00:24:51.140 Demilade Agboola: Quites on the nose.
227 00:24:51.440 ⇒ 00:24:52.330 Emily Giant: Yep.
228 00:24:58.610 ⇒ 00:24:59.640 Emily Giant: Alright, this…
229 00:25:00.880 ⇒ 00:25:01.980 Demilade Agboola: a seeding…
230 00:25:04.420 ⇒ 00:25:06.599 Emily Giant: And this hasn’t been fulfilled yet.
231 00:25:06.750 ⇒ 00:25:07.370 Emily Giant: So…
232 00:25:08.420 ⇒ 00:25:12.229 Demilade Agboola: So we have a revenue of $64… 68.
233 00:25:13.780 ⇒ 00:25:21.240 Demilade Agboola: 2 for the video message, because this was removed.
234 00:25:23.420 ⇒ 00:25:27.430 Demilade Agboola: And then, fulfilled revenue is yours. Once it gets delivered.
235 00:25:27.880 ⇒ 00:25:29.919 Demilade Agboola: It will… it won’t have root.
236 00:25:30.300 ⇒ 00:25:31.140 Demilade Agboola: Here.
237 00:25:31.350 ⇒ 00:25:33.590 Emily Giant: Yep, that’s great. Looks perfect.
238 00:25:34.270 ⇒ 00:25:40.869 Demilade Agboola: Okay, so, yeah, it’s just… Around a couple of the subscriptions…
239 00:25:47.530 ⇒ 00:25:53.250 Demilade Agboola: That’s the Firecracker… Oh, there’s no removal, this seems like a
240 00:26:04.690 ⇒ 00:26:09.029 Demilade Agboola: So, yeah, we have it for 74 and 15.
241 00:26:09.720 ⇒ 00:26:14.949 Demilade Agboola: Yeah, so, I mean… hopping around, but I have looked around, it seems pretty solid.
242 00:26:15.150 ⇒ 00:26:16.329 Emily Giant: Yeah, it does.
243 00:26:16.900 ⇒ 00:26:20.639 Demilade Agboola: I guess it’s just, like, the subscriptions element of it.
244 00:26:20.640 ⇒ 00:26:21.720 Emily Giant: Yep.
245 00:26:21.720 ⇒ 00:26:25.630 Demilade Agboola: right now, it’s… That goes everything at zero.
246 00:26:27.940 ⇒ 00:26:37.060 Demilade Agboola: But, like, that’s part of why I wanted to, like, see what subscriptions looks like, and basically, merge everything together.
247 00:26:37.390 ⇒ 00:26:44.150 Emily Giant: Yeah, okay, let’s, pop over to subs. I will share my screen.
248 00:26:44.280 ⇒ 00:26:45.829 Emily Giant: Show you where I’m at.
249 00:26:46.330 ⇒ 00:26:48.779 Demilade Agboola: We give you all the customary refund.
250 00:26:49.650 ⇒ 00:26:50.840 Emily Giant: -Oh.
251 00:26:52.160 ⇒ 00:26:54.170 Demilade Agboola: It was just… what is horrible.
252 00:26:58.970 ⇒ 00:27:02.689 Emily Giant: Two firecrackers removed from an order? Okay.
253 00:27:03.380 ⇒ 00:27:05.940 Demilade Agboola: One Firecracker removed, one Blood Moon removed.
254 00:27:05.940 ⇒ 00:27:06.920 Emily Giant: Oh.
255 00:27:07.100 ⇒ 00:27:14.379 Demilade Agboola: Now, they have the fairy rows, so these two are removed, the two up top are removed. It’s the bottom two.
256 00:27:18.120 ⇒ 00:27:22.149 Demilade Agboola: Yeah, so we have a fulfilled revenue of zero for both of them.
257 00:27:22.470 ⇒ 00:27:26.490 Demilade Agboola: 24 for the vase, and then 85 for the…
258 00:27:28.300 ⇒ 00:27:29.090 Emily Giant: Brilliant.
259 00:27:29.720 ⇒ 00:27:30.670 Demilade Agboola: There.
260 00:27:31.810 ⇒ 00:27:36.909 Demilade Agboola: And then there’s an accrued of four, which is part of, I guess, why they say you have four.
261 00:27:37.530 ⇒ 00:27:46.819 Demilade Agboola: for them to refund is because the refund amount And this was 74.
262 00:27:47.840 ⇒ 00:27:53.240 Demilade Agboola: But the paid… 78.
263 00:27:54.360 ⇒ 00:27:56.729 Emily Giant: Oh, I see, okay.
264 00:27:58.210 ⇒ 00:28:01.969 Demilade Agboola: It’s… Plus, or the item amount is 78.
265 00:28:03.780 ⇒ 00:28:04.440 Demilade Agboola: Cool.
266 00:28:04.960 ⇒ 00:28:11.229 Emily Giant: It looks, so, the fulfilled revenue should be…
267 00:28:12.600 ⇒ 00:28:16.810 Emily Giant: 78 still, right? We do owe them a refund, though, of $4.
268 00:28:17.470 ⇒ 00:28:18.350 Demilade Agboola: Yeah.
269 00:28:20.350 ⇒ 00:28:23.389 Demilade Agboola: Yeah, so they paid $78 for this, I guess.
270 00:28:24.050 ⇒ 00:28:25.869 Demilade Agboola: No, no, they pizza on C4.
271 00:28:27.870 ⇒ 00:28:29.870 Demilade Agboola: And they go with Manassell C4 in it.
272 00:28:34.990 ⇒ 00:28:43.270 Demilade Agboola: because I’m using the item price, and it’s supposed to be a 70, that’s what’s doing… that’s what is making us…
273 00:28:43.450 ⇒ 00:28:46.310 Demilade Agboola: A $4 refund.
274 00:28:46.770 ⇒ 00:28:49.610 Demilade Agboola: I’m guessing it’s from something here. I’ll have to look at it.
275 00:28:56.090 ⇒ 00:29:03.519 Demilade Agboola: Another thing is, like, there’s no real, like, shipping amount. It would just have to be, like, the overall shipping amount added to…
276 00:29:03.520 ⇒ 00:29:05.490 Emily Giant: Yeah, another line.
277 00:29:05.600 ⇒ 00:29:07.000 Emily Giant: Just for shipping.
278 00:29:07.770 ⇒ 00:29:10.949 Demilade Agboola: Or not the line, maybe when we brought it up to the other level.
279 00:29:13.130 ⇒ 00:29:17.810 Demilade Agboola: So, like, fulfilled revenue, equid revenue, we’ll just kind of add the shipping, yeah, to it.
280 00:29:20.680 ⇒ 00:29:25.210 Demilade Agboola: But yeah, that’s basically how it’s working so far.
281 00:29:25.660 ⇒ 00:29:33.510 Emily Giant: It looks good. Yeah, so just that shipping element then, since that factors into revenue, would be, like, a last pay… that in subscriptions.
282 00:29:34.050 ⇒ 00:29:34.370 Demilade Agboola: Yeah.
283 00:29:34.370 ⇒ 00:29:46.830 Emily Giant: are kind of the lingering pieces a bit here. Let me share. So, where I’m at with subs… this… I’m still working on historical this morning, but let’s look at,
284 00:29:47.650 ⇒ 00:29:51.609 Emily Giant: Let me see if I can get the model to run. If not, then,
285 00:29:51.780 ⇒ 00:29:58.159 Emily Giant: We’ll just have to use the compiled code, since I still have to, like, work on the union, but subscriptions…
286 00:29:59.100 ⇒ 00:30:03.079 Emily Giant: So right now, the Loop subscriptions are up top.
287 00:30:03.740 ⇒ 00:30:07.159 Emily Giant: And then… The sticky ones…
288 00:30:07.420 ⇒ 00:30:12.499 Emily Giant: I’m still deduplicating. I have 10 duplicates left to get rid of, but…
289 00:30:12.870 ⇒ 00:30:16.300 Emily Giant: Let’s just use this compiled…
290 00:30:20.310 ⇒ 00:30:27.359 Demilade Agboola: Well, my question is, I actually espresso wants to understand the logic of, like, how does… how do we type subscriptions into revenue?
291 00:30:27.890 ⇒ 00:30:35.890 Emily Giant: So, in the past, we’ve overridden the… what comes through on these lines with the amortized
292 00:30:36.100 ⇒ 00:30:38.820 Emily Giant: Cost of the prepaids?
293 00:30:39.010 ⇒ 00:30:44.349 Emily Giant: So, instead of, like, if they get 12 and it’s $900.
294 00:30:44.350 ⇒ 00:30:46.130 Demilade Agboola: We still only recognize.
295 00:30:46.130 ⇒ 00:30:59.690 Emily Giant: revenue for those that have been fulfilled. But the way it will come through, and we can validate this since we have a thousand subscription orders, if you pull that and it’s prepaid, it’s probably going to give you the full amount. So…
296 00:30:59.960 ⇒ 00:31:12.369 Emily Giant: once this table is done, it should never come through with the full cost of a prepaid subscription. It should always amortize it for the ones that have been sent.
297 00:31:12.620 ⇒ 00:31:15.809 Emily Giant: Does that make sense? So it’ll always be 105.
298 00:31:15.980 ⇒ 00:31:21.650 Emily Giant: 75, 65, or 55 for the historical ones.
299 00:31:22.320 ⇒ 00:31:26.570 Demilade Agboola: Does it amortize by line item, or does it amortize by order?
300 00:31:27.590 ⇒ 00:31:28.480 Emily Giant: Order.
301 00:31:28.800 ⇒ 00:31:29.170 Demilade Agboola: Oh, okay.
302 00:31:29.170 ⇒ 00:31:31.250 Emily Giant: But, in subscriptions.
303 00:31:31.360 ⇒ 00:31:43.339 Emily Giant: If there are multiple items, we don’t count… we always count the add-ons as zero. Zero dollar revenue. We just lump it into the floral for the subscription. For some reason, that’s just how they do it, I don’t know why.
304 00:31:43.730 ⇒ 00:31:50.120 Demilade Agboola: Alright, so, Mike, because I was trying to say, like, if you were going to do, like, a report on SKUs by state.
305 00:31:50.290 ⇒ 00:31:56.350 Demilade Agboola: Would you… in that case, well, your question answers it. You would lump the subscription revenue as floral.
306 00:31:57.500 ⇒ 00:31:58.660 Demilade Agboola: Amazing.
307 00:31:58.850 ⇒ 00:32:04.069 Demilade Agboola: You know, the other… the straight up, the ones that were bought straight up would just also add to it.
308 00:32:08.000 ⇒ 00:32:09.449 Emily Giant: Say that again? Sorry.
309 00:32:10.650 ⇒ 00:32:21.820 Demilade Agboola: So if we’re trying to do, like, the… We’re trying to do a dash based off the… a dashboard based off the SKU by state and revenue, like, revenue by SKU and state.
310 00:32:23.310 ⇒ 00:32:24.880 Demilade Agboola: or setting…
311 00:32:26.240 ⇒ 00:32:43.280 Demilade Agboola: The ones that are coming in, like, that are just bought directly, those ones, the revenue would… this model will work for it, but then the ones that are coming through subscriptions, we will just add the floral price, like the $105 or 75, just to the floral, as the… yeah.
312 00:32:43.510 ⇒ 00:32:52.190 Emily Giant: Yep, exactly So… This is still super duped, super duped. Maybe I’ll go up one…
313 00:32:52.510 ⇒ 00:32:56.680 Emily Giant: One in the lineage where it’s not so duplicated.
314 00:32:56.930 ⇒ 00:32:58.600 Demilade Agboola: But you know where the dupe is coming from?
315 00:32:59.150 ⇒ 00:33:00.290 Emily Giant: Not yet.
316 00:33:00.920 ⇒ 00:33:06.219 Emily Giant: I’m guessing it’s from where… I’m calculating, like, lifetime value.
317 00:33:07.650 ⇒ 00:33:09.880 Demilade Agboola: So are there dupes in this model, for instance?
318 00:33:10.110 ⇒ 00:33:11.059 Emily Giant: Let me see…
319 00:33:12.990 ⇒ 00:33:18.400 Demilade Agboola: We could just do a… Go compile it? I mean, do you have a test?
320 00:33:20.060 ⇒ 00:33:21.530 Emily Giant: I should have a test.
321 00:33:21.960 ⇒ 00:33:28.350 Demilade Agboola: Which is also, if you compile it and you have a unique key, you could just do the select count, or having.
322 00:33:28.350 ⇒ 00:33:29.180 Emily Giant: Yeah.
323 00:33:30.200 ⇒ 00:33:34.039 Emily Giant: So the unique key should be built in as subscription. Well…
324 00:33:34.210 ⇒ 00:33:40.179 Emily Giant: For this table, which one is it? Because there are two… two versions of…
325 00:33:40.340 ⇒ 00:33:44.010 Emily Giant: like, subscription tables. There’s one that’s just…
326 00:33:44.330 ⇒ 00:33:59.610 Emily Giant: a row for the subscription, and, like, the current state of it, and then there’s… the fact model is the subscription, as well as every order that has been associated with it. So yeah, this one’s failing for unique.
327 00:34:03.150 ⇒ 00:34:05.039 Emily Giant: There… hold on.
328 00:34:07.240 ⇒ 00:34:11.550 Emily Giant: So, 2000, are duplicated.
329 00:34:15.280 ⇒ 00:34:16.389 Emily Giant: Let me see…
330 00:34:41.110 ⇒ 00:34:41.790 Emily Giant: Okay.
331 00:35:12.790 ⇒ 00:35:18.480 Demilade Agboola: Alright, so can we look into that subscription ID, and just kind of see what’s happening by the multiple records?
332 00:35:19.600 ⇒ 00:35:25.180 Emily Giant: Yeah, so… Okay, so we get 12… can you see all 12 records here on my screen?
333 00:35:25.370 ⇒ 00:35:26.100 Demilade Agboola: Yeah.
334 00:35:26.100 ⇒ 00:35:26.770 Emily Giant: Okay.
335 00:35:27.620 ⇒ 00:35:30.629 Emily Giant: So, these dates are all the same.
336 00:35:47.320 ⇒ 00:35:49.259 Emily Giant: Oof, did you see this?
337 00:35:50.940 ⇒ 00:35:51.350 Demilade Agboola: Yeah.
338 00:35:51.350 ⇒ 00:35:52.360 Emily Giant: Who’s.
339 00:35:53.730 ⇒ 00:35:56.839 Demilade Agboola: It looks a lot like there are 12 versions of it.
340 00:35:56.840 ⇒ 00:36:02.519 Emily Giant: Oh, gosh! I’m like, maybe they actually sent it 12 times. That seems like a pretty desperate cry.
341 00:36:02.660 ⇒ 00:36:12.810 Emily Giant: So, yeah, lifetime value… So recurring… alright, but if we look at it…
342 00:36:13.220 ⇒ 00:36:16.690 Emily Giant: In the system, it’s probably just gonna have one order.
343 00:36:18.070 ⇒ 00:36:20.490 Demilade Agboola: Yeah, probably.
344 00:36:40.590 ⇒ 00:36:41.580 Emily Giant: Oh, oh, there.
345 00:36:45.270 ⇒ 00:36:47.940 Emily Giant: It’s literally the source subscription ID.
346 00:36:48.220 ⇒ 00:36:49.590 Emily Giant: Let’s try…
347 00:37:10.080 ⇒ 00:37:14.009 Emily Giant: Wait a minute… okay, 1, 2, 3, 4, 5…
348 00:37:19.620 ⇒ 00:37:22.779 Emily Giant: So they have a ton, they’ve had this forever.
349 00:37:25.740 ⇒ 00:37:30.859 Demilade Agboola: Okay, but… Are they… is it, like, delivering…
350 00:37:32.030 ⇒ 00:37:34.130 Emily Giant: It’s every one week.
351 00:37:35.100 ⇒ 00:37:44.020 Emily Giant: Next order… So, like, at a basic level, this is not pulling enough of these orders.
352 00:37:46.770 ⇒ 00:37:53.210 Emily Giant: They’ve had the… okay, so this is what’s going on with this one, which is weird. They’ve had it since before we had Shopify.
353 00:37:53.560 ⇒ 00:37:56.079 Emily Giant: Oh no, they got it, like, the week we got Shopify.
354 00:37:57.040 ⇒ 00:37:59.190 Emily Giant: But… net total.
355 00:38:01.660 ⇒ 00:38:03.790 Emily Giant: Oh, man.
356 00:38:08.610 ⇒ 00:38:17.219 Demilade Agboola: Well, my thing is, in data, there should be, like, a Shopify order ID that makes it distinct. There should be, like, a distinguishing factor if it’s different orders, and…
357 00:38:17.790 ⇒ 00:38:23.389 Emily Giant: Yeah, so… In this model, Where are we in mode?
358 00:38:29.650 ⇒ 00:38:32.619 Emily Giant: In this model, I’m like, is there a Shopify?
359 00:38:33.260 ⇒ 00:38:42.139 Emily Giant: I… because this is not the order model, this is the… just the subscriptions, and then if you go to Facts, there’s another model that’s just the orders.
360 00:38:52.100 ⇒ 00:38:57.110 Emily Giant: And then… Yeah, this is the one with just the orders, so if I’ve queried…
361 00:39:01.730 ⇒ 00:39:05.529 Emily Giant: this model for this subscription ID. Let’s see.
362 00:39:05.900 ⇒ 00:39:07.160 Emily Giant: Select…
363 00:39:15.070 ⇒ 00:39:20.480 Emily Giant: They’re called… Staging… I’ll be talking.
364 00:40:04.020 ⇒ 00:40:04.740 Emily Giant: Yeah.
365 00:40:05.730 ⇒ 00:40:11.489 Emily Giant: So, let me see… Order by Shopify, order ID.
366 00:40:24.950 ⇒ 00:40:27.869 Emily Giant: Just want to see if there’s dupes in this, too.
367 00:40:31.030 ⇒ 00:40:34.540 Demilade Agboola: But he seems to have… All 38 orders.
368 00:40:35.700 ⇒ 00:40:36.360 Emily Giant: Yep.
369 00:40:37.120 ⇒ 00:40:44.020 Demilade Agboola: So… My… it appears… I don’t know.
370 00:40:44.170 ⇒ 00:40:51.750 Demilade Agboola: shouldn’t… so, like, why… I’m not sure I got… so why are there 12 orders in the, like…
371 00:40:51.880 ⇒ 00:40:56.319 Demilade Agboola: There should be 1 subscription and 38 orders.
372 00:40:56.800 ⇒ 00:41:00.729 Emily Giant: Correct. There should be only one… so there’s something wrong with…
373 00:41:01.160 ⇒ 00:41:04.900 Emily Giant: this model, because there should only be…
374 00:41:05.110 ⇒ 00:41:16.839 Emily Giant: So, Uten built this, I added stuff to it, but, like, I think part of the problem is this. I do not know what this is or why this was added, this seed file.
375 00:41:19.040 ⇒ 00:41:21.289 Demilade Agboola: What’s this? Can you open it, please?
376 00:41:21.290 ⇒ 00:41:21.980 Emily Giant: Yeah.
377 00:41:24.220 ⇒ 00:41:28.600 Demilade Agboola: It’s the source, subscription ID, order number, product…
378 00:41:36.340 ⇒ 00:41:38.870 Emily Giant: Yeah, I just don’t… I don’t know what it is.
379 00:41:39.150 ⇒ 00:41:40.650 Emily Giant: And,
380 00:41:42.170 ⇒ 00:41:52.839 Emily Giant: I don’t know if this is, like, part of the problem here, that we don’t need this, and it’s creating duplicates, because it’s rejoining on this that has no additional information, but…
381 00:41:53.180 ⇒ 00:41:53.680 Demilade Agboola: Hmm.
382 00:41:53.680 ⇒ 00:42:01.630 Emily Giant: The title, and we shouldn’t… Like, I don’t know why… okay, if I pull this directly from the raw…
383 00:42:02.440 ⇒ 00:42:07.030 Emily Giant: Let’s see if it’s missing information, because I just don’t think that it would be.
384 00:42:07.470 ⇒ 00:42:09.050 Demilade Agboola: Okay, let’s look at that.
385 00:42:12.300 ⇒ 00:42:14.579 Emily Giant: Only I could spell.
386 00:42:25.240 ⇒ 00:42:26.429 Emily Giant: Let me figure out what that’s.
387 00:42:34.890 ⇒ 00:42:36.490 Emily Giant: It’s called subscription.
388 00:42:47.960 ⇒ 00:42:51.640 Emily Giant: It might be not subscription, though, it might be Shopify ID.
389 00:42:53.000 ⇒ 00:42:54.530 Emily Giant: I think it is, actually.
390 00:42:55.540 ⇒ 00:42:57.729 Demilade Agboola: I think it’s subscription ID, though.
391 00:42:57.730 ⇒ 00:42:58.560 Emily Giant: Yeah.
392 00:43:13.070 ⇒ 00:43:22.470 Emily Giant: I should have done the other raw model, because this will still give us all the rows like I did last… well, it should have been loop subscriptions, not orders.
393 00:43:58.490 ⇒ 00:44:00.930 Demilade Agboola: Is that Shopify ideal subscription ID?
394 00:44:02.370 ⇒ 00:44:07.750 Emily Giant: I think it’s the… Subscription ID,
395 00:44:07.990 ⇒ 00:44:10.979 Emily Giant: Yeah. So this is the one row, and this is…
396 00:44:12.670 ⇒ 00:44:16.739 Emily Giant: Successfully populating, so it’s like we don’t need that seed file.
397 00:44:17.190 ⇒ 00:44:18.410 Demilade Agboola: Okay.
398 00:44:18.740 ⇒ 00:44:19.570 Demilade Agboola: Aww.
399 00:44:19.570 ⇒ 00:44:20.820 Emily Giant: What’s my feeling here?
400 00:44:23.450 ⇒ 00:44:24.530 Demilade Agboola: Gotcha.
401 00:44:24.980 ⇒ 00:44:29.029 Emily Giant: Cause… does it not… Pull in all of the information.
402 00:44:32.900 ⇒ 00:44:38.800 Emily Giant: Shopify ID, ID… Yeah, I mean…
403 00:44:39.370 ⇒ 00:44:42.860 Emily Giant: It seems to me that we should be able to pull in
404 00:44:47.690 ⇒ 00:44:49.640 Emily Giant: the other info…
405 00:44:51.750 ⇒ 00:44:52.600 Demilade Agboola: Yeah.
406 00:44:53.200 ⇒ 00:44:54.349 Demilade Agboola: Let’s see…
407 00:45:10.980 ⇒ 00:45:14.849 Emily Giant: Alright, my enterprise is 60, so we know it’s a classic.
408 00:45:31.980 ⇒ 00:45:38.569 Emily Giant: I’m trying to think, like, did he add it because this is somehow missing something in the lines.
409 00:45:41.630 ⇒ 00:45:45.650 Emily Giant: Because that’s how I pulled a lot of the information that was, like, hard-keyed.
410 00:45:49.950 ⇒ 00:45:50.620 Demilade Agboola: kind of bat.
411 00:45:50.620 ⇒ 00:45:53.630 Emily Giant: this Here, let me see…
412 00:46:07.420 ⇒ 00:46:11.359 Emily Giant: No, this… this… that C file doesn’t… so this is how I pulled.
413 00:46:12.190 ⇒ 00:46:19.810 Emily Giant: any of the missing stuff was from this JSON data, and it’s all there. So, I’m gonna…
414 00:46:20.510 ⇒ 00:46:22.250 Demilade Agboola: Everybody’s scared of it.
415 00:46:22.250 ⇒ 00:46:24.469 Emily Giant: Yeah, comment it out, at least.
416 00:46:40.210 ⇒ 00:46:42.120 Emily Giant: So what is this? LF.
417 00:46:43.050 ⇒ 00:46:44.030 Demilade Agboola: And it’s LF…
418 00:46:46.750 ⇒ 00:46:48.979 Emily Giant: So, SKU and product name, don’t need it.
419 00:46:57.170 ⇒ 00:46:59.490 Emily Giant: Dated orders, count zero.
420 00:47:00.210 ⇒ 00:47:03.739 Emily Giant: This is not gonna work. I need to fix that logic.
421 00:47:05.620 ⇒ 00:47:09.240 Emily Giant: It needs to be, like, an aggregate.
422 00:47:09.890 ⇒ 00:47:12.860 Emily Giant: Like I did in the historical stuff.
423 00:47:38.280 ⇒ 00:47:39.190 Emily Giant: Oh.
424 00:47:39.560 ⇒ 00:47:40.290 Emily Giant: Nope.
425 00:47:45.130 ⇒ 00:47:50.889 Demilade Agboola: You can also do a preview sometimes, if you already have some of the dependent things in your branch.
426 00:47:54.270 ⇒ 00:47:59.430 Demilade Agboola: I mean, you don’t think privileges don’t help you know if, like, incremental models work properly.
427 00:47:59.720 ⇒ 00:48:00.630 Emily Giant: Yeah.
428 00:48:00.900 ⇒ 00:48:03.070 Demilade Agboola: You just want to see if the logic is fine.
429 00:48:08.990 ⇒ 00:48:17.009 Emily Giant: Oh, I see, he wrote simplified for now. Doesn’t need to be… Alright, so it looks like the logic works.
430 00:48:17.630 ⇒ 00:48:19.580 Emily Giant: So now we can just compile it.
431 00:49:08.710 ⇒ 00:49:10.120 Emily Giant: Oh, okay.
432 00:49:10.240 ⇒ 00:49:11.719 Emily Giant: Now it just returns one.
433 00:49:12.440 ⇒ 00:49:18.109 Demilade Agboola: Okay, yeah. So my guess is maybe there are multiple roles in the CSV, so it’s spread it out.
434 00:49:18.620 ⇒ 00:49:19.390 Emily Giant: Yep.
435 00:49:19.760 ⇒ 00:49:25.059 Demilade Agboola: Because, like I was saying, like, it should only either be 1 or 38. There shouldn’t be any number in between.
436 00:49:25.420 ⇒ 00:49:26.120 Emily Giant: Yeah.
437 00:49:26.860 ⇒ 00:49:30.229 Emily Giant: Okay, great. And so now what I need to do is just add.
438 00:49:30.540 ⇒ 00:49:32.470 Demilade Agboola: Like, a subquery that…
439 00:49:32.710 ⇒ 00:49:37.990 Emily Giant: Partitions… Oh, no, I guess I would need to do that in the…
440 00:49:38.870 ⇒ 00:49:42.090 Emily Giant: Other one, where it adds the lifetime value.
441 00:49:42.430 ⇒ 00:49:44.320 Emily Giant: And,
442 00:49:44.790 ⇒ 00:49:51.920 Emily Giant: Because it wouldn’t have the separate orders to aggregate the lifetime value in this one, so it shouldn’t be in this query at all.
443 00:49:52.190 ⇒ 00:49:52.860 Demilade Agboola: No.
444 00:49:53.560 ⇒ 00:50:02.229 Emily Giant: But, if it was passing through to revenue, you’re getting that line item discounted price. But you’re still gonna want that from orders, and not from…
445 00:50:03.380 ⇒ 00:50:18.590 Emily Giant: from this. This is just so that, like, if the thing is canceled, if it’s active, it’s more for forecasting and not for revenue. This specific… it’s so that they know how many subscriptions
446 00:50:18.820 ⇒ 00:50:25.790 Emily Giant: to plan for in future weeks, and then the other table is,
447 00:50:26.300 ⇒ 00:50:29.329 Emily Giant: The revenue gain from subscriptions, if that makes sense.
448 00:50:31.470 ⇒ 00:50:31.820 Demilade Agboola: It’s good.
449 00:50:31.820 ⇒ 00:50:34.490 Emily Giant: Bring it and commit that.
450 00:50:36.550 ⇒ 00:50:37.710 Emily Giant: Removed.
451 00:50:37.860 ⇒ 00:50:39.340 Emily Giant: CSV.
452 00:50:45.020 ⇒ 00:50:45.990 Emily Giant: Alright.
453 00:50:48.230 ⇒ 00:50:49.410 Emily Giant: So…
454 00:50:53.130 ⇒ 00:51:03.490 Emily Giant: Yeah, this is your… The staging polyatomic loop orders is gonna be where we, like, normalize it.
455 00:51:04.420 ⇒ 00:51:07.859 Emily Giant: To come through with the right subscription price.
456 00:51:08.420 ⇒ 00:51:18.980 Emily Giant: But I did see… One of the lines in mode was for 163 on that guy’s…
457 00:51:19.250 ⇒ 00:51:24.330 Emily Giant: So, total price… like, these are all… prepaid looking.
458 00:51:27.920 ⇒ 00:51:39.590 Emily Giant: And then line… so… Yeah, there still needs to be some work on this to… Total…
459 00:51:39.700 ⇒ 00:51:42.899 Emily Giant: to just override… Sorry.
460 00:51:46.630 ⇒ 00:51:48.020 Emily Giant: So…
461 00:51:51.100 ⇒ 00:52:00.620 Emily Giant: I’m wondering if… there is… a line in… the JSON that just pulls…
462 00:52:01.290 ⇒ 00:52:04.059 Emily Giant: the subscription price. There often is…
463 00:52:06.060 ⇒ 00:52:09.420 Emily Giant: I’ve done more with the historical stuff than the subscription stuff.
464 00:52:10.070 ⇒ 00:52:13.540 Emily Giant: So… Let me…
465 00:52:22.010 ⇒ 00:52:24.300 Emily Giant: So, like, that’s correct.
466 00:52:26.010 ⇒ 00:52:31.370 Emily Giant: But that is in… Just the subscription table.
467 00:53:07.020 ⇒ 00:53:13.349 Emily Giant: So, this is correct. Like, when you pull it from here, the total line item price is pulling as…
468 00:53:14.730 ⇒ 00:53:18.199 Emily Giant: Pull more samples, just to make sure that that remains true.
469 00:53:18.730 ⇒ 00:53:21.839 Demilade Agboola: But it seems to have changed. That’s the only reason why.
470 00:53:22.240 ⇒ 00:53:24.260 Demilade Agboola: Like, the order.
471 00:53:25.370 ⇒ 00:53:31.400 Emily Giant: Yeah, I’m like, did I use a different subscription number this time? Because this is now not right.
472 00:53:32.470 ⇒ 00:53:33.470 Emily Giant: Let’s see…
473 00:53:34.690 ⇒ 00:53:40.210 Emily Giant: And there’s no reason it should have changed. Is this this… it might be a different one. Is it still the I love you note?
474 00:53:40.730 ⇒ 00:53:41.950 Demilade Agboola: I’m not sure.
475 00:53:42.190 ⇒ 00:53:42.776 Emily Giant: Let me…
476 00:53:51.710 ⇒ 00:53:57.880 Emily Giant: Okay, so I know how to fix this, I just gotta pull it from, like… it should be in the lines data that, like.
477 00:53:58.080 ⇒ 00:54:01.329 Emily Giant: it’s always… a stable price.
478 00:54:02.760 ⇒ 00:54:04.270 Emily Giant: When it comes through.
479 00:54:04.530 ⇒ 00:54:05.620 Emily Giant: My price.
480 00:54:06.410 ⇒ 00:54:09.980 Emily Giant: Anyway, I can fix that. I just haven’t focused a lot on the,
481 00:54:11.420 ⇒ 00:54:16.790 Emily Giant: the current subscriptions, because I’ve been doing the historical, but this is easy enough to, like…
482 00:54:17.930 ⇒ 00:54:28.519 Emily Giant: If it’s a classic, it’s 60. If it’s a… Seasonal at 75, and… If it’s a…
483 00:54:28.750 ⇒ 00:54:31.399 Emily Giant: Whatever, it’s 105 lux.
484 00:54:32.500 ⇒ 00:54:33.580 Emily Giant: Okay, totally.
485 00:54:34.430 ⇒ 00:54:37.689 Emily Giant: I can write that in… it’s not this one, though, it’s this.
486 00:54:44.990 ⇒ 00:54:45.809 Demilade Agboola: Oh, okay.
487 00:54:48.470 ⇒ 00:54:50.240 Emily Giant: Sorry, go ahead.
488 00:54:50.410 ⇒ 00:54:53.380 Demilade Agboola: Okay, like, do you need any help with the… this?
489 00:54:54.090 ⇒ 00:54:57.780 Emily Giant: Let me think.
490 00:54:59.880 ⇒ 00:55:07.799 Emily Giant: Not necessarily. I’m definitely, like, still in the weeds with the historical subscriptions, but… Truly, if you just…
491 00:55:08.040 ⇒ 00:55:14.149 Emily Giant: take, like… The subscription tier, which is always populated.
492 00:55:14.290 ⇒ 00:55:20.210 Emily Giant: Then you can overwrite the cost, just with a case statement.
493 00:55:21.760 ⇒ 00:55:24.590 Demilade Agboola: Okay, put… Is there any…
494 00:55:24.590 ⇒ 00:55:25.530 Emily Giant: Sure.
495 00:55:26.280 ⇒ 00:55:27.390 Emily Giant: Sorry, go ahead.
496 00:55:27.670 ⇒ 00:55:31.389 Demilade Agboola: That is why we want to override the cost, let’s just use the cost that comes in.
497 00:55:34.530 ⇒ 00:55:42.360 Emily Giant: Yeah, the cost that comes in, so if I look in the raw data for… so, these are all prepaid.
498 00:55:44.020 ⇒ 00:55:49.440 Emily Giant: Why are they all… okay, there are some pay-as-you-goes, sorry, I was just making sure it was okay.
499 00:55:50.330 ⇒ 00:55:54.620 Emily Giant: So let’s take this seasonal subscription and look at the raw data.
500 00:56:14.980 ⇒ 00:56:16.480 Emily Giant: What?
501 00:56:28.550 ⇒ 00:56:34.130 Emily Giant: I mean, this is directly connected to the raw data, so that doesn’t… Make a ton of sense.
502 00:56:37.120 ⇒ 00:56:38.060 Demilade Agboola: Meow.
503 00:56:40.100 ⇒ 00:56:41.740 Emily Giant: Well, let’s just do this, then.
504 00:57:32.070 ⇒ 00:57:33.790 Demilade Agboola: Interesting. It’s the only reason…
505 00:57:36.860 ⇒ 00:57:38.660 Demilade Agboola: Yeah, there’s not…
506 00:58:27.330 ⇒ 00:58:29.580 Emily Giant: What? That’s really weird.
507 00:58:30.490 ⇒ 00:58:34.160 Emily Giant: I guess… I’m literally pulling it from that.
508 00:58:35.970 ⇒ 00:58:42.340 Emily Giant: Let me just compile it. Maybe it’s because it’s incremental, that it’s being… Pissy.
509 00:59:15.720 ⇒ 00:59:18.300 Emily Giant: It shouldn’t be like that from the raw data.
510 00:59:18.450 ⇒ 00:59:20.789 Emily Giant: Like, the data’s not incremental.
511 00:59:27.830 ⇒ 00:59:40.779 Emily Giant: Like, in what world does that make sense? It’ll still have the lines that we can look at for some kind of stable price, but, like, line item price, everything looks normal, but that…
512 00:59:42.300 ⇒ 00:59:43.870 Demilade Agboola: I think your stand-up has started.
513 00:59:44.130 ⇒ 00:59:49.829 Emily Giant: Oh, okay. I gotta hop then. I’ll see you at… I’m sure we have another meeting at some point today.
514 00:59:50.310 ⇒ 00:59:54.979 Demilade Agboola: If you need any help or anything, just let me know.
515 00:59:54.980 ⇒ 01:00:00.159 Emily Giant: I should be okay. I think I’ve got a good handle on it, I just haven’t paid attention to
516 01:00:00.330 ⇒ 01:00:07.109 Emily Giant: the… much but the historical, but I… yeah, I will ping you later today if I haven’t figured this out by, like, 2 o’clock.
517 01:00:07.520 ⇒ 01:00:08.880 Demilade Agboola: Okay, sounds good.
518 01:00:08.880 ⇒ 01:00:10.429 Emily Giant: Alright, I’ll talk to you soon.
519 01:00:10.650 ⇒ 01:00:12.309 Demilade Agboola: Talk to you soon. Bye.