Meeting Title: Urban Stems Subscription Revenue Troubleshooting Date: 2026-01-08 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:00:07.020 ⇒ 00:00:08.540 Emily Giant: Hello again!
2 00:00:09.040 ⇒ 00:00:10.419 Demilade Agboola: Hi, Emily, how are you.
3 00:00:11.060 ⇒ 00:00:14.990 Emily Giant: Oh, not bad, it’s really nice out here today. It’s, like, 50 degrees.
4 00:00:15.950 ⇒ 00:00:19.750 Demilade Agboola: Okay, you seem… I thought you were being sarcastic, because you have, like, you seem very…
5 00:00:21.770 ⇒ 00:00:27.620 Emily Giant: I don’t… now, 50 degrees when you’re sitting still on a computer still sucks, but…
6 00:00:27.620 ⇒ 00:00:28.170 Demilade Agboola: Alright.
7 00:00:28.170 ⇒ 00:00:43.560 Emily Giant: It is for sure nicer outside. I’m trying to convince the cats to go out so that they stop just staring at me all day. I’m like, get up there, it’s nice, but they don’t believe me, so I might have to, like, toss them through the window here in a sec.
8 00:00:43.800 ⇒ 00:00:46.369 Emily Giant: Okay, okay, that’s cool.
9 00:00:46.390 ⇒ 00:00:47.489 Demilade Agboola: What’s it?
10 00:00:47.720 ⇒ 00:00:49.870 Emily Giant: Your jacket, it’s really cool.
11 00:00:50.090 ⇒ 00:00:51.769 Demilade Agboola: Yeah, it’s an Arsenal jacket.
12 00:00:52.070 ⇒ 00:00:54.370 Emily Giant: Oh, sweet!
13 00:00:54.370 ⇒ 00:01:02.560 Demilade Agboola: This is Arsenal’s icon, like, they have… this is from, like, the 80s or 70s, but, like, they’ve kept it, and I like it. It’s one of… I really like it, because…
14 00:01:03.140 ⇒ 00:01:10.619 Demilade Agboola: It’s one of those things that most people cannot tell is a nice jacket, and that’s why I love it, because it’s just one of those jackets that looks really cool.
15 00:01:10.640 ⇒ 00:01:12.560 Emily Giant: But the back has, like…
16 00:01:13.010 ⇒ 00:01:25.369 Demilade Agboola: Oh, sweet! That’s awesome! Yeah, it’s 49. So Arsenal went 49 games without losing across, like, 2 years. It’s the longest streak in Premier League history.
17 00:01:25.710 ⇒ 00:01:31.559 Emily Giant: Oh my god. Did you get it at a vintage shop, or, like, eBay, or how did you get this jacket?
18 00:01:31.560 ⇒ 00:01:33.839 Demilade Agboola: So, I went to the Arsenal Stadium.
19 00:01:34.610 ⇒ 00:01:42.829 Demilade Agboola: And then they have, like, a shop underneath, so I went there and I was looking around, and I didn’t plan to spend any money, but I saw this jacket, and I was like.
20 00:01:43.090 ⇒ 00:01:45.410 Demilade Agboola: Yeah, I’m gonna… I’m going to…
21 00:01:45.700 ⇒ 00:01:53.349 Emily Giant: That’ll last forever, though, and you, like, not that you would ever resell it, but the resale value on those is probably really high, so…
22 00:01:53.530 ⇒ 00:01:57.559 Demilade Agboola: I got it for, like, I don’t know, it was a little over 100 pounds, which…
23 00:01:57.560 ⇒ 00:01:59.569 Emily Giant: Oh, that’s less than I thought it would be.
24 00:02:00.020 ⇒ 00:02:05.260 Demilade Agboola: Yeah, I mean, pounds would probably be, like, with 100 pounds, probably, like, maybe $160? 170?
25 00:02:05.260 ⇒ 00:02:05.640 Emily Giant: Yeah.
26 00:02:05.640 ⇒ 00:02:10.540 Demilade Agboola: It was not the worst, but it was… it was… it was, like, a good,
27 00:02:10.800 ⇒ 00:02:16.800 Demilade Agboola: random purchase, and when I was talking back to Malta, on the first flight, when I was leaving Minneapolis.
28 00:02:18.540 ⇒ 00:02:30.600 Demilade Agboola: I was wearing this jacket, and then the flight attendant saw me, and he goes, oh, Arsenal jackets, and I’m like, you’re an Arsenal fan? He’s like, yeah. And we kind of bonded over that. So it’s like one of those, like, random, like, signals, but…
29 00:02:30.600 ⇒ 00:02:47.959 Emily Giant: Well, people aren’t casual Arsenal fans. Like, if you’re a fan, you’re insane. Like, there’s no one that’s like, oh, I kind of like them. I feel like everyone who likes them is, like, gonna know what you’re wearing. But, like, you know, for a second, I was like, is that for, like.
30 00:02:48.160 ⇒ 00:02:49.549 Emily Giant: the angels? Like, what is…
31 00:02:49.550 ⇒ 00:02:49.930 Demilade Agboola: with the.
32 00:02:49.930 ⇒ 00:02:55.619 Emily Giant: Okay, but then you showed me the whole logo, and I was like, no, that is not a logo that I’ve seen. That’s super cool.
33 00:02:55.880 ⇒ 00:02:57.950 Demilade Agboola: Yeah, that’s pretty cool. That’s pretty cool.
34 00:02:58.860 ⇒ 00:03:04.540 Emily Giant: Well, I have a very specific task, or two, rather, that I want to go over today, because
35 00:03:04.540 ⇒ 00:03:19.200 Emily Giant: Tuesday, Monopoly was like, what the hell? Like, literally said, what the hell? And I was like, it’s not me! But it partially was. So, what happened was, because the delivery dates, remember how they, like, weren’t getting things marked as fulfilled in Shopify?
36 00:03:19.200 ⇒ 00:03:19.940 Demilade Agboola: Yeah.
37 00:03:19.940 ⇒ 00:03:23.989 Emily Giant: That made everything fail, because there is, like, no…
38 00:03:24.310 ⇒ 00:03:35.370 Emily Giant: way outside of Shopify actually populating those dates to pull in the delivery date, because there was no, like, join key for OMS. We knew this, and I said, like, well, this isn’t really ours to fix.
39 00:03:35.550 ⇒ 00:03:54.100 Emily Giant: So it’s fixed, because she came down on me, at which point Alex was pulled in and had to fix it. So, that’s the good news. The bad news is, I know, right? So we have data there now that makes sense. A fulfilled revenue is a number that isn’t zero.
40 00:03:54.100 ⇒ 00:03:54.610 Demilade Agboola: Hmm!
41 00:03:54.610 ⇒ 00:03:58.929 Emily Giant: I know, woo! That’s a huge win. But,
42 00:03:59.480 ⇒ 00:04:11.509 Emily Giant: two things are still weird that I’m… I need to help with. I just think it’ll be so much faster since you built most of these models. Subscriptions are, like, still…
43 00:04:11.730 ⇒ 00:04:22.449 Emily Giant: not marking… okay, let me just show you. It’ll be easier, because you’ll know what I’m talking about. It will all come back to you. Essentially, the subscription product
44 00:04:22.550 ⇒ 00:04:27.560 Emily Giant: And the products are all getting revenue assigned, but…
45 00:04:28.790 ⇒ 00:04:33.800 Emily Giant: We had built logic to say, like, if it’s a subscription,
46 00:04:35.600 ⇒ 00:04:38.829 Emily Giant: Let me pull the… I actually wrote down the order number, where is it?
47 00:04:38.830 ⇒ 00:04:43.350 Demilade Agboola: Sure. While you’re pulling that up, I have the copy machine on, so I’ll just pat myself for copy.
48 00:04:43.550 ⇒ 00:04:46.799 Emily Giant: Go for it. That sounds like a really smart idea.
49 00:04:49.260 ⇒ 00:04:50.120 Emily Giant: Okay.
50 00:06:21.070 ⇒ 00:06:22.220 Demilade Agboola: Okay, back.
51 00:06:23.080 ⇒ 00:06:34.739 Emily Giant: And I’m ready! Okay, so a couple weird things are happening here. So the seasonal subscription, that’s fine that it’s still coming in. We had done work to, like, pull subscription
52 00:06:34.880 ⇒ 00:06:46.589 Emily Giant: out of, like, the product name and put it in, like, subscription SKU, but that’s really easy to do, so I’m not worried about that. What I’m worried about is this, is that subscriptions are supposed to overwrite
53 00:06:46.860 ⇒ 00:06:50.540 Emily Giant: Total accrued revenue, so that…
54 00:06:50.650 ⇒ 00:06:55.159 Emily Giant: The snowfall would get the 75, and the vase would get the zero.
55 00:06:55.540 ⇒ 00:07:02.269 Emily Giant: And this would be… it can be 75, it just can’t add into the total,
56 00:07:02.620 ⇒ 00:07:05.189 Emily Giant: Let me see if it does, because sometimes Looker is super smart.
57 00:07:05.190 ⇒ 00:07:07.169 Demilade Agboola: I can’t see what you’re sharing.
58 00:07:07.490 ⇒ 00:07:09.720 Emily Giant: Oh! Well, that would probably help.
59 00:07:09.990 ⇒ 00:07:11.339 Demilade Agboola: I can see GitHub.
60 00:07:11.340 ⇒ 00:07:12.670 Emily Giant: One sec.
61 00:07:13.380 ⇒ 00:07:17.400 Demilade Agboola: Because I was like, what you’re… like, what you’re talking about doesn’t seem to be… I was just so.
62 00:07:17.400 ⇒ 00:07:23.820 Emily Giant: Oh, that… oh my god, that is just my repo. Okay.
63 00:07:24.470 ⇒ 00:07:30.130 Emily Giant: Which desktop to? Share? Okay.
64 00:07:30.440 ⇒ 00:07:30.920 Emily Giant: Okay.
65 00:07:30.920 ⇒ 00:07:34.280 Demilade Agboola: Like, now, now… Yes, now, like, these subscriptions.
66 00:07:34.710 ⇒ 00:07:39.010 Emily Giant: And I can send you the link, too, if you want to open it in Looker on your… nope!
67 00:07:39.300 ⇒ 00:07:40.460 Emily Giant: Where are you?
68 00:07:41.170 ⇒ 00:07:45.100 Emily Giant: Okay, well, I’ve lost you, so I’ll send it when I find you. Oh, here.
69 00:07:45.300 ⇒ 00:07:46.520 Emily Giant: Okay.
70 00:07:49.200 ⇒ 00:07:53.520 Emily Giant: Chat… This is…
71 00:07:54.850 ⇒ 00:08:01.300 Demilade Agboola: I’ve clearly forgotten how to use Zoom in the 3 weeks since I’ve seen you. Okay. What’s having a good holiday, then?
72 00:08:03.680 ⇒ 00:08:09.899 Emily Giant: Alright, so… Couple weird things. Delivery date isn’t getting attributed to the floral SKU.
73 00:08:10.690 ⇒ 00:08:12.700 Emily Giant: But it is coming through on the vase.
74 00:08:13.240 ⇒ 00:08:15.270 Emily Giant: So I’m not sure why that’s happening.
75 00:08:16.310 ⇒ 00:08:16.890 Demilade Agboola: Oh my god.
76 00:08:16.890 ⇒ 00:08:21.400 Emily Giant: That’s less important. That seems like something I could probably figure out.
77 00:08:21.570 ⇒ 00:08:22.870 Emily Giant: But…
78 00:08:24.490 ⇒ 00:08:33.349 Emily Giant: Oh, this is supplementary delivery details. That’s… that’s why I shouldn’t be using that one. That’s an old model that is,
79 00:08:39.700 ⇒ 00:08:45.460 Emily Giant: Oh, fun. Okay, so I can fix that on the back end. I’m more concerned about the… the revenue
80 00:08:45.960 ⇒ 00:08:54.889 Emily Giant: is summing the… all of the separate product costs when the logic should be overriding it, so…
81 00:08:55.030 ⇒ 00:08:57.090 Emily Giant: If I open up the metal…
82 00:09:09.290 ⇒ 00:09:13.120 Emily Giant: So it’s gonna be in fact ordered line items, I believe.
83 00:09:13.840 ⇒ 00:09:14.510 Demilade Agboola: Okay.
84 00:09:19.570 ⇒ 00:09:24.310 Emily Giant: So… Line subterline total.
85 00:09:24.530 ⇒ 00:09:28.240 Demilade Agboola: Yeah, there’s a subscription case when statement, somewhere.
86 00:09:28.240 ⇒ 00:09:29.000 Emily Giant: Huh.
87 00:09:33.280 ⇒ 00:09:38.950 Emily Giant: Okay, so maybe this is the issue. I don’t see… is fax subscriptions in here?
88 00:09:40.270 ⇒ 00:09:41.080 Emily Giant: Yes.
89 00:09:41.370 ⇒ 00:09:43.269 Emily Giant: Okay. So, like, search for subs.
90 00:09:43.510 ⇒ 00:09:44.160 Emily Giant: Yeah.
91 00:09:45.660 ⇒ 00:09:47.989 Demilade Agboola: Let’s see… alright, yeah.
92 00:09:48.660 ⇒ 00:09:49.350 Emily Giant: Okay.
93 00:09:50.080 ⇒ 00:09:52.519 Emily Giant: Yeah, you have all of it.
94 00:09:53.230 ⇒ 00:10:03.270 Emily Giant: So… If it’s a re-delivery, it’s zero. Cool. When isFulfilled is true, and sub Shopify order ID is null.
95 00:10:03.520 ⇒ 00:10:05.560 Emily Giant: Then, line item subtotal.
96 00:10:06.620 ⇒ 00:10:13.340 Emily Giant: So, should I… what is this for? Oh, that’s fulfilled revenue. Sorry, I don’t care about that just yet. I need accrued. Okay.
97 00:10:14.730 ⇒ 00:10:21.790 Emily Giant: When is re-delivery 0 then 0, when sub Shopify order ID is null, then line item subtotal, minus…
98 00:10:23.400 ⇒ 00:10:25.190 Emily Giant: Refunds, etc.
99 00:10:27.360 ⇒ 00:10:34.810 Emily Giant: And then, when Shopify order ID is not null, sub… then… And it’s the floral.
100 00:10:35.260 ⇒ 00:10:38.419 Emily Giant: Then line item of adjusted revenue, else zero.
101 00:10:39.440 ⇒ 00:10:42.550 Emily Giant: So… I’m guessing.
102 00:10:42.830 ⇒ 00:10:45.330 Emily Giant: that the Shopify order ID is null.
103 00:10:45.510 ⇒ 00:10:54.369 Emily Giant: And that’s why. Because we were looking at that model the other day, and a lot of the orders didn’t seem to be coming through, so I guess I need to check.
104 00:10:55.870 ⇒ 00:10:59.450 Emily Giant: the subs to see if that order ID is in there.
105 00:10:59.930 ⇒ 00:11:03.790 Demilade Agboola: Yes, that’ll be… that’ll be our first. So, fax subscriptions, let’s see if we can see…
106 00:11:19.620 ⇒ 00:11:26.600 Emily Giant: kind of forget if it’s this number that starts with 6 or the number that starts with 3, but we’ll figure it out soon.
107 00:11:31.920 ⇒ 00:11:32.660 Emily Giant: Excuse me.
108 00:11:33.250 ⇒ 00:11:34.070 Emily Giant: Act.
109 00:11:41.370 ⇒ 00:11:43.179 Emily Giant: Is there just order ID?
110 00:11:45.310 ⇒ 00:11:49.010 Emily Giant: E… A, B, C, D, yep.
111 00:11:50.120 ⇒ 00:11:51.570 Emily Giant: OMS order ID.
112 00:12:03.060 ⇒ 00:12:03.750 Emily Giant: Huh.
113 00:12:23.760 ⇒ 00:12:24.700 Emily Giant: Nope.
114 00:12:26.850 ⇒ 00:12:31.370 Demilade Agboola: Okay, so there isn’t… the order ID.
115 00:12:32.230 ⇒ 00:12:35.109 Emily Giant: not, in fact, subscriptions. Let me see if it’s in the…
116 00:12:35.110 ⇒ 00:12:36.650 Demilade Agboola: Can we… can we use the…
117 00:12:36.760 ⇒ 00:12:39.049 Demilade Agboola: Sorry, can I go back and see the join?
118 00:12:39.480 ⇒ 00:12:40.170 Emily Giant: Yeah.
119 00:12:41.340 ⇒ 00:12:42.840 Demilade Agboola: Mark in the… yeah.
120 00:12:45.080 ⇒ 00:12:51.109 Demilade Agboola: The join was done using Shopify. Can we see what the… can we see what the Shopify order ID is, though?
121 00:12:51.780 ⇒ 00:12:52.530 Emily Giant: Yes.
122 00:13:03.730 ⇒ 00:13:06.020 Emily Giant: It is… this.
123 00:13:07.170 ⇒ 00:13:09.650 Demilade Agboola: Okay, so can we see it in fax subscriptions?
124 00:13:12.120 ⇒ 00:13:20.449 Demilade Agboola: And also, is this tied to what we pointed out, like, earlier this week about, like, the drop-off in subscriptions orders?
125 00:13:20.450 ⇒ 00:13:24.519 Emily Giant: It might be. That might be why this is happening. It’s not catching
126 00:13:24.760 ⇒ 00:13:28.360 Emily Giant: That it’s a subscription, so it’s not overriding the revenue.
127 00:13:28.660 ⇒ 00:13:29.260 Demilade Agboola: Yeah.
128 00:13:33.130 ⇒ 00:13:38.680 Emily Giant: And I did build out, like, the staging table for the gift subscription model.
129 00:13:39.030 ⇒ 00:13:39.740 Demilade Agboola: Okay.
130 00:13:39.740 ⇒ 00:13:42.489 Emily Giant: So, that might be able to backfill some of these.
131 00:13:42.490 ⇒ 00:13:50.130 Demilade Agboola: Alright, so… let me see, can we… Let me open my… Redshift… Very red tall.
132 00:13:55.950 ⇒ 00:13:58.459 Demilade Agboola: That the whole rebars are hardly.
133 00:13:58.460 ⇒ 00:13:58.780 Emily Giant: Nope.
134 00:13:58.780 ⇒ 00:14:00.940 Demilade Agboola: La-la-la-la-la.
135 00:14:01.810 ⇒ 00:14:03.480 Demilade Agboola: I’m preparing.
136 00:14:03.480 ⇒ 00:14:07.579 Emily Giant: We’re doing it in August, so… Preparing for next year.
137 00:14:07.580 ⇒ 00:14:10.299 Demilade Agboola: Exa… for this year.
138 00:14:10.590 ⇒ 00:14:12.519 Emily Giant: Oh, you’re right, you’re right.
139 00:14:12.520 ⇒ 00:14:13.409 Demilade Agboola: Oh my god.
140 00:14:14.690 ⇒ 00:14:17.689 Emily Giant: Okay, let me see if it’s in the raw table.
141 00:14:17.880 ⇒ 00:14:19.710 Demilade Agboola: Yeah, that’s what I was going to do, so…
142 00:14:20.850 ⇒ 00:14:25.489 Emily Giant: And then I can check the gift subscriptions one, too, and that might make all the difference, but…
143 00:14:25.890 ⇒ 00:14:32.200 Emily Giant: But I wish there was some way we could trust that they would just have the data in it.
144 00:14:39.880 ⇒ 00:14:42.460 Demilade Agboola: I still have my Christmas tree up, so… I can always…
145 00:14:42.460 ⇒ 00:14:53.600 Emily Giant: I just took mine down this weekend, and mine is made of wine bottles that I sponge-painted different colors of green. It’s so time-consuming,
146 00:14:53.740 ⇒ 00:14:54.890 Emily Giant: really…
147 00:14:55.030 ⇒ 00:15:01.779 Emily Giant: The consuming of the wine and the building of the tree. Very time-consuming. I saved balls for, like, over a year.
148 00:15:02.600 ⇒ 00:15:04.590 Demilade Agboola: Yeah, you’re dedicated to the craft.
149 00:15:04.590 ⇒ 00:15:06.579 Emily Giant: I am. I am. It’s all for Christmas.
150 00:15:07.530 ⇒ 00:15:11.930 Demilade Agboola: We thank you for the… The effort that you put in.
151 00:15:11.930 ⇒ 00:15:13.110 Emily Giant: some service.
152 00:15:13.310 ⇒ 00:15:14.070 Demilade Agboola: Yeah.
153 00:15:14.850 ⇒ 00:15:18.470 Emily Giant: So it is in… the orders model.
154 00:15:18.740 ⇒ 00:15:22.540 Demilade Agboola: Yeah, so… That’s… so we’re definitely losing its…
155 00:15:23.020 ⇒ 00:15:23.770 Emily Giant: Yeah.
156 00:15:23.770 ⇒ 00:15:30.870 Demilade Agboola: down that process. So, once That’s the first step. The next step will be to fix the drop-off, which…
157 00:15:30.870 ⇒ 00:15:31.600 Emily Giant: Yeah.
158 00:15:32.580 ⇒ 00:15:37.739 Demilade Agboola: I sent, like, the flow, so you can kind of see… staging loop order seems fine.
159 00:15:38.200 ⇒ 00:15:41.419 Demilade Agboola: But then when you start going down to, like, the merge loops.
160 00:15:41.790 ⇒ 00:15:48.489 Demilade Agboola: others, we lose some, and then when you go to, like, the loop with fara skew, we lose even more, and then…
161 00:15:48.490 ⇒ 00:15:48.930 Emily Giant: Who knows?
162 00:15:48.930 ⇒ 00:15:50.889 Demilade Agboola: what shows up in the fax subscriptions.
163 00:15:51.710 ⇒ 00:15:55.160 Demilade Agboola: So, fax optional is fine, you don’t need to look at that model, it’s the…
164 00:15:55.610 ⇒ 00:15:56.600 Emily Giant: In between.
165 00:15:56.600 ⇒ 00:16:02.399 Demilade Agboola: the merge loop sub with orders and the loop with Flora SKU, those are the two models you need to troubleshoot.
166 00:16:16.830 ⇒ 00:16:20.210 Demilade Agboola: Did you hear that Trump banned Nigerians from…
167 00:16:20.780 ⇒ 00:16:22.880 Emily Giant: It draws on one of the banned countries.
168 00:16:23.980 ⇒ 00:16:38.339 Emily Giant: I… I can’t with him. No, I didn’t, because if I hear his voice, I feel physically ill. So, I did not realize. But, any reason? Just…
169 00:16:38.800 ⇒ 00:16:46.600 Emily Giant: art, like, art at a board, besides, like, blatant racism and ignorance? Or is that pretty much…
170 00:16:47.160 ⇒ 00:16:52.750 Demilade Agboola: I mean, they have their numbers, but, like, it’s one of those things where… I feel…
171 00:16:53.720 ⇒ 00:17:04.070 Demilade Agboola: it’s like international politics, and I will be honest, I don’t think Nigeria also covers itself with the best glory in the sense that we don’t actually have, right now, we don’t have any ambassadors.
172 00:17:04.119 ⇒ 00:17:15.780 Demilade Agboola: like, the new president came in and we called all ambassadors, and we have non-ambassadors, so we don’t have any, like, foreign voice to advocate for us consistently. That being said, yeah, they said stuff about, like, overstay rates.
173 00:17:15.920 ⇒ 00:17:23.669 Demilade Agboola: As well as, so you’ve heard about, like, in northern… parts of northern Nigeria, they’re, like,
174 00:17:23.910 ⇒ 00:17:26.340 Demilade Agboola: There’s some terrorist activity going on, like, sometimes.
175 00:17:26.349 ⇒ 00:17:34.279 Emily Giant: Yeah, really… I meant to actually reach out to you, and… because that was, like, 2 weeks ago, wasn’t it? Where there was, like, an uptick in…
176 00:17:34.549 ⇒ 00:17:38.469 Emily Giant: Or in the United States, it was suddenly in the news, a lot.
177 00:17:38.790 ⇒ 00:17:47.550 Demilade Agboola: Oh, yeah, good. Yeah, they started talking about it quite a bit, which is fascinating. It feels very much like Venezuela in the sense that, like.
178 00:17:48.250 ⇒ 00:18:01.499 Demilade Agboola: it’s been going on for, like, 10, 15 years, and obviously it’s horrible that it’s been going on, I’m not trying to… but, like, the sudden interest now, when there wasn’t, like, a major activity, does feel kind of suspicious. Right.
179 00:18:01.500 ⇒ 00:18:08.270 Emily Giant: Like, that it’s suddenly part of our news cycle seems, like, very convenient, given that it’s not new.
180 00:18:08.410 ⇒ 00:18:08.920 Demilade Agboola: But…
181 00:18:09.080 ⇒ 00:18:17.430 Demilade Agboola: Yeah, it’s just… it’s just one of those things, and at this point, yeah, they… apparently, they sent some… they sent some drones, like, not drones, fighter pilots and bombs.
182 00:18:17.810 ⇒ 00:18:19.389 Demilade Agboola: Places and estates.
183 00:18:19.560 ⇒ 00:18:21.200 Demilade Agboola: That was, like, 2 weeks ago.
184 00:18:21.200 ⇒ 00:18:25.359 Emily Giant: Oh, God. Is that anywhere near where your family that lives there is?
185 00:18:25.360 ⇒ 00:18:28.110 Demilade Agboola: Oh, no, no, no, that’s all up north. My family lives down south.
186 00:18:28.300 ⇒ 00:18:29.810 Emily Giant: Okay, that’s good.
187 00:18:29.810 ⇒ 00:18:37.880 Demilade Agboola: So, yeah, but it was… it was quite… it’s been quite fascinating. So right now, I actually don’t know if I could enter the U.S. right now as we speak.
188 00:18:38.180 ⇒ 00:18:44.950 Demilade Agboola: So, that’s quite fascinating. We’ll see, I guess we’ll see as things evolve over the next couple weeks slash months.
189 00:18:45.330 ⇒ 00:18:49.130 Emily Giant: Oh my god. Well, he changes…
190 00:18:49.360 ⇒ 00:19:00.040 Emily Giant: travel bans, like, every couple weeks, and… okay, so it’s not in this model, but, I wouldn’t be surprised if, like, that’s different in 2 weeks, but…
191 00:19:00.040 ⇒ 00:19:00.790 Demilade Agboola: Oh, yeah.
192 00:19:00.790 ⇒ 00:19:10.409 Emily Giant: It’s just so… just… feels like he’s shooting from the hip. Like, there’s…
193 00:19:10.750 ⇒ 00:19:11.930 Demilade Agboola: Oh yeah, yeah, it’s, it’s…
194 00:19:12.190 ⇒ 00:19:21.349 Demilade Agboola: I think the wildest one was just that Venezuela stuff, like, just waking up thinking that he kidnapped the entire president of the country, and I’m like, what the heck?
195 00:19:21.910 ⇒ 00:19:29.479 Emily Giant: So crazy. And, like, when I lived in Brooklyn, the place where they had him, like, detained was, like, two blocks from my house. It’s just, like.
196 00:19:29.970 ⇒ 00:19:35.200 Emily Giant: rebuilding in Brooklyn. It’s, like, inconceivable to me that the president
197 00:19:35.360 ⇒ 00:19:43.909 Emily Giant: and wife of Venezuela. We’re just, like, chillin’ in the place where I… next to where I get my driver’s license. It makes no… it’s so…
198 00:19:44.380 ⇒ 00:19:51.030 Emily Giant: crazy. And it has nothing to do with nothing, but that we want oil. And it…
199 00:19:51.030 ⇒ 00:19:55.699 Demilade Agboola: And you’ve got oil, apparently. Maybe there’s some deal that has been made now, so…
200 00:19:56.640 ⇒ 00:20:08.909 Emily Giant: It’s just a… no, we’re gonna get banned. From everywhere. Just wait. By the end of this presidency, we will not be able to travel to Canada, or anywhere. Like, Mexico’s gonna be like, no thank you. So…
201 00:20:09.000 ⇒ 00:20:15.509 Demilade Agboola: I mean, to be fair, I mean, to be fair, he has rejoined me from, like, a number of organizations, so, like, you’re fine, you’re good.
202 00:20:17.220 ⇒ 00:20:19.800 Emily Giant: Now… It’s only been a year!
203 00:20:21.020 ⇒ 00:20:22.269 Demilade Agboola: I think that’s the crazy part.
204 00:20:22.550 ⇒ 00:20:23.130 Emily Giant: Yeah.
205 00:20:23.890 ⇒ 00:20:25.920 Emily Giant: It feels like a lot longer.
206 00:20:27.320 ⇒ 00:20:28.370 Demilade Agboola: Okay.
207 00:20:28.570 ⇒ 00:20:29.760 Emily Giant: Psst, okay.
208 00:20:30.370 ⇒ 00:20:33.890 Demilade Agboola: Alright, so I’m trying to see what… Y…
209 00:20:35.350 ⇒ 00:20:39.460 Demilade Agboola: And… okay, so it’s loop with florals, you…
210 00:20:44.330 ⇒ 00:20:45.189 Emily Giant: Like, is it?
211 00:20:45.190 ⇒ 00:20:48.530 Demilade Agboola: Is it… is it in the… One second.
212 00:20:51.500 ⇒ 00:20:52.860 Demilade Agboola: I think I’m in the wrong model.
213 00:20:55.660 ⇒ 00:20:56.075 Demilade Agboola: Mmm…
214 00:20:57.180 ⇒ 00:20:59.440 Emily Giant: If I look at just this one…
215 00:21:00.790 ⇒ 00:21:02.999 Emily Giant: I wanna just make sure it’s in staging.
216 00:21:03.540 ⇒ 00:21:06.470 Demilade Agboola: Was he in the loop subs with orders, though?
217 00:21:08.400 ⇒ 00:21:12.639 Demilade Agboola: Yeah, int subscriptions, merge loop subs with orders. Yeah, that’s where we’re at.
218 00:21:13.840 ⇒ 00:21:17.000 Demilade Agboola: Yeah, but is that… is that subscription order in there?
219 00:21:18.970 ⇒ 00:21:19.700 Emily Giant: No.
220 00:21:20.840 ⇒ 00:21:22.519 Demilade Agboola: Okay, so that’s the first layer.
221 00:21:23.540 ⇒ 00:21:26.129 Demilade Agboola: That’s the one directly from staging.
222 00:21:26.780 ⇒ 00:21:34.419 Demilade Agboola: Alright, so it’s Loop Subs… Alright, so what’s going on here is that they’re missing subscriptions.
223 00:21:35.290 ⇒ 00:21:38.630 Demilade Agboola: Because the only thing that’s going on here is we’re joining loop orders.
224 00:21:47.550 ⇒ 00:21:55.169 Emily Giant: It’s not even showing up in the staging model for me. Oh, wait, that’s because I probably haven’t done a full crush on my dev in 100 years.
225 00:21:56.010 ⇒ 00:21:57.659 Emily Giant: Oh, I’m trying, I’m trying…
226 00:22:00.810 ⇒ 00:22:04.190 Emily Giant: I spent, like, an hour today trying to get
227 00:22:04.760 ⇒ 00:22:12.389 Emily Giant: the staging environment up to date, that would be a whole day of my life, just trying to get the staging on PRs, like.
228 00:22:12.820 ⇒ 00:22:21.830 Emily Giant: back-synced with… okay, so it is in staging, it is fine, but it’s on subscription ID, I hear what you’re saying, and we need to…
229 00:22:22.310 ⇒ 00:22:23.160 Emily Giant: Okay.
230 00:22:23.160 ⇒ 00:22:32.410 Demilade Agboola: We might need to flip… so, two things, right? The easy thing… easy fix for now is you can flip the join around, so instead of it joining from
231 00:22:32.970 ⇒ 00:22:34.820 Demilade Agboola: Actually, no, he’s joining from orders to…
232 00:22:34.820 ⇒ 00:22:37.800 Emily Giant: We did that the other day, I immediately deployed that.
233 00:22:37.980 ⇒ 00:22:41.040 Demilade Agboola: Okay, so… Can you check…
234 00:22:43.280 ⇒ 00:22:48.379 Demilade Agboola: So it should… it should be in… in subscriptions, loop… merge loop orders. Can you check that, please?
235 00:22:49.530 ⇒ 00:22:49.930 Demilade Agboola: Yes.
236 00:22:49.930 ⇒ 00:22:52.999 Emily Giant: for this? It was probably my dev environment.
237 00:22:57.570 ⇒ 00:22:58.310 Emily Giant: Okay.
238 00:23:04.140 ⇒ 00:23:06.449 Demilade Agboola: Did you know about the Minneapolis shooting?
239 00:23:07.540 ⇒ 00:23:09.719 Emily Giant: Which… when? When was it?
240 00:23:09.720 ⇒ 00:23:10.600 Demilade Agboola: Yesterday.
241 00:23:10.860 ⇒ 00:23:12.760 Emily Giant: No, I didn’t. What happened?
242 00:23:13.020 ⇒ 00:23:17.629 Demilade Agboola: Apparently, I shot a 37-year-old, lady in Minneapolis.
243 00:23:18.000 ⇒ 00:23:19.960 Demilade Agboola: And she unfortunately passed.
244 00:23:20.170 ⇒ 00:23:21.590 Emily Giant: Oh my god.
245 00:23:21.590 ⇒ 00:23:26.030 Demilade Agboola: Yeah, so… That’s been… Absolutely.
246 00:23:26.180 ⇒ 00:23:26.690 Emily Giant: She’s a…
247 00:23:26.690 ⇒ 00:23:30.320 Demilade Agboola: American, American, like, you know, white woman, American, like…
248 00:23:30.960 ⇒ 00:23:32.370 Emily Giant: Oh my god.
249 00:23:32.370 ⇒ 00:23:33.170 Demilade Agboola: Yeah, so…
250 00:23:33.940 ⇒ 00:23:37.740 Emily Giant: That, well… That is horrific.
251 00:23:37.740 ⇒ 00:23:40.079 Demilade Agboola: Yeah, so, I mean, there’s flights…
252 00:23:40.230 ⇒ 00:23:43.539 Demilade Agboola: on the rest in Minneapolis, nothing too crazy, yeah.
253 00:23:44.250 ⇒ 00:23:46.869 Demilade Agboola: Oh my god. That’s where my girlfriend stays.
254 00:23:46.870 ⇒ 00:23:53.090 Emily Giant: Things laying down, so they’re gonna… things are… Gonna get wild.
255 00:23:53.090 ⇒ 00:23:53.740 Demilade Agboola: Yeah.
256 00:23:55.150 ⇒ 00:24:02.460 Emily Giant: Oh my god, that’s so sick. Like, just so unnecessary. Okay, it’s saying it’s not in there.
257 00:24:02.950 ⇒ 00:24:05.720 Demilade Agboola: Okay, so now we have to, like, investigate.
258 00:24:05.980 ⇒ 00:24:06.510 Emily Giant: Yeah.
259 00:24:12.040 ⇒ 00:24:12.980 Emily Giant: Okay.
260 00:24:12.980 ⇒ 00:24:15.430 Demilade Agboola: Alright, let me compile this.
261 00:24:21.190 ⇒ 00:24:24.739 Demilade Agboola: Interesting. Deputy’s changed how certain things look.
262 00:24:25.300 ⇒ 00:24:29.029 Emily Giant: They sure have, and I feel like it’s worse.
263 00:24:29.170 ⇒ 00:24:32.770 Emily Giant: I’m still getting used to it, but…
264 00:24:38.120 ⇒ 00:24:41.539 Demilade Agboola: It just feels very strange right now. I’m just like, what’s going on?
265 00:24:41.970 ⇒ 00:24:48.860 Emily Giant: Did I… okay, Shopify order ID. How am I pulling that into this model? It should be from the orders model.
266 00:24:52.280 ⇒ 00:24:53.949 Emily Giant: Okay, that’s correct.
267 00:24:56.700 ⇒ 00:24:59.200 Demilade Agboola: So, Shopify…
268 00:25:06.150 ⇒ 00:25:09.230 Demilade Agboola: The table, tag subscriptions…
269 00:25:17.340 ⇒ 00:25:29.869 Emily Giant: Nope, nothing. Wait, where… okay, there’s this condition of where orders, which I never remember adding, but if I take that where orders.ordersProcessed is not null.
270 00:25:30.260 ⇒ 00:25:34.250 Emily Giant: I wonder if… it will show.
271 00:25:36.150 ⇒ 00:25:37.280 Demilade Agboola: Let’s see…
272 00:25:39.160 ⇒ 00:25:42.879 Emily Giant: That feels… no, okay. That is a weird…
273 00:25:43.700 ⇒ 00:25:45.200 Demilade Agboola: filter condition.
274 00:25:46.050 ⇒ 00:25:48.360 Emily Giant: I’m just gonna take away.
275 00:25:48.360 ⇒ 00:25:49.490 Demilade Agboola: We’ll wear closes?
276 00:25:49.810 ⇒ 00:25:50.430 Emily Giant: Yeah.
277 00:25:51.970 ⇒ 00:25:55.320 Demilade Agboola: Let’s see, can you send the order ID, please?
278 00:25:55.910 ⇒ 00:25:56.660 Emily Giant: Yes.
279 00:26:01.640 ⇒ 00:26:03.970 Emily Giant: Okay, chat…
280 00:26:09.130 ⇒ 00:26:10.500 Demilade Agboola: Thank you.
281 00:26:29.080 ⇒ 00:26:29.980 Emily Giant: Gay?
282 00:26:31.880 ⇒ 00:26:32.780 Emily Giant: that.
283 00:26:36.270 ⇒ 00:26:39.220 Emily Giant: Am I referencing, like, a wrong model or something?
284 00:26:40.260 ⇒ 00:26:46.389 Demilade Agboola: No, I’ll give him a second, I will… Dive into it.
285 00:26:47.880 ⇒ 00:26:49.779 Demilade Agboola: It’s like, oh, fuck.
286 00:26:55.880 ⇒ 00:26:59.179 Demilade Agboola: Yeah, it’s Dev Analytics. I was going to point that out.
287 00:26:59.180 ⇒ 00:26:59.560 Emily Giant: Yeah.
288 00:26:59.790 ⇒ 00:27:05.529 Demilade Agboola: So… We will… so can we try again, Bo, with…
289 00:27:06.600 ⇒ 00:27:07.190 Emily Giant: Yeah.
290 00:27:08.240 ⇒ 00:27:10.140 Demilade Agboola: Non-dev analytics.
291 00:27:22.060 ⇒ 00:27:23.420 Emily Giant: It’s gonna work.
292 00:27:23.930 ⇒ 00:27:26.260 Emily Giant: Yup, okay. So…
293 00:27:27.390 ⇒ 00:27:28.070 Demilade Agboola: Don’t Christmas?
294 00:27:28.280 ⇒ 00:27:29.539 Demilade Agboola: We have to work with…
295 00:27:29.740 ⇒ 00:27:33.499 Emily Giant: Yeah, I wonder if I… yeah, add these back in.
296 00:27:33.910 ⇒ 00:27:35.940 Emily Giant: Which one it’s gonna put on.
297 00:27:35.940 ⇒ 00:27:40.759 Demilade Agboola: You don’t have to run it, I’m actually running the initial query. Okay, so if you…
298 00:27:41.690 ⇒ 00:27:44.689 Demilade Agboola: Have all the where clauses back in, it doesn’t work.
299 00:27:46.160 ⇒ 00:27:46.530 Emily Giant: Okay.
300 00:27:46.530 ⇒ 00:27:51.209 Demilade Agboola: I’ll also try to see if it’s just the orders.orderprocessed, that is the culprit.
301 00:27:53.590 ⇒ 00:27:57.180 Emily Giant: I just ran it with that, and it… still populated.
302 00:28:01.680 ⇒ 00:28:05.809 Demilade Agboola: Yeah, it is not the culprit, it’s one of these two.
303 00:28:06.450 ⇒ 00:28:08.769 Demilade Agboola: The cancellation reason, or…
304 00:28:11.050 ⇒ 00:28:11.600 Emily Giant: Oop!
305 00:28:14.770 ⇒ 00:28:16.139 Demilade Agboola: It’s the constitutional reason.
306 00:28:16.720 ⇒ 00:28:18.810 Emily Giant: Oh, so this is an internal cancel?
307 00:28:19.180 ⇒ 00:28:19.770 Demilade Agboola: Yeah.
308 00:28:20.090 ⇒ 00:28:23.500 Emily Giant: Let me see if that’s… Accurate.
309 00:28:37.980 ⇒ 00:28:42.830 Demilade Agboola: Well, it’s internal reason, not equals to… yes, it’s an internal council.
310 00:28:44.890 ⇒ 00:28:46.879 Emily Giant: Yeah, it shouldn’t, it shouldn’t.
311 00:28:48.490 ⇒ 00:28:50.139 Emily Giant: the internal cancel.
312 00:28:50.560 ⇒ 00:28:52.020 Demilade Agboola: Okay…
313 00:28:52.660 ⇒ 00:28:54.950 Emily Giant: Because internal cancel is, like, for testing.
314 00:28:58.260 ⇒ 00:29:03.840 Demilade Agboola: Well, let’s see… so, does that come from subscriptions or from the orders, I mean?
315 00:29:05.320 ⇒ 00:29:06.460 Demilade Agboola: Look at that.
316 00:29:07.070 ⇒ 00:29:11.030 Emily Giant: It is from… Subscriptions.
317 00:29:11.360 ⇒ 00:29:16.160 Demilade Agboola: Yes, from subscriptions, alright, so give me one second… Sort on…
318 00:29:30.410 ⇒ 00:29:34.400 Demilade Agboola: Take the whole nipples around me trying to ride.
319 00:29:36.160 ⇒ 00:29:38.819 Demilade Agboola: Taste the season to be.
320 00:29:39.730 ⇒ 00:29:40.820 Demilade Agboola: Surely.
321 00:29:43.710 ⇒ 00:29:45.139 Emily Giant: I love that you’re singing that.
322 00:29:45.510 ⇒ 00:29:48.689 Emily Giant: And in between, you’re like, did you hear about the shooting?
323 00:29:48.690 ⇒ 00:29:51.440 Demilade Agboola: Pala-la-la-la, la-la-la-la.
324 00:29:52.180 ⇒ 00:29:53.569 Emily Giant: How about the drones?
325 00:29:53.900 ⇒ 00:29:58.860 Emily Giant: You know what? Oh my, this is so dark.
326 00:30:04.990 ⇒ 00:30:07.499 Demilade Agboola: Okay, so there are 61 internal console.
327 00:30:07.660 ⇒ 00:30:10.450 Demilade Agboola: Subscriptions?
328 00:30:11.460 ⇒ 00:30:14.330 Demilade Agboola: I will send a list of them to you right now.
329 00:30:15.430 ⇒ 00:30:16.839 Emily Giant: Is this one of them?
330 00:30:18.730 ⇒ 00:30:26.669 Demilade Agboola: to this point, I just actually wanted to see how many, like, what the spread of that was. So, they’re not too many, it’s just 61.
331 00:30:28.310 ⇒ 00:30:29.800 Demilade Agboola: Then…
332 00:30:37.840 ⇒ 00:30:40.060 Demilade Agboola: Yes, this is N2P.
333 00:30:55.540 ⇒ 00:31:02.829 Demilade Agboola: Funny enough, I actually have a friend who got a master’s into… like, an MBA into admission into…
334 00:31:04.010 ⇒ 00:31:05.530 Demilade Agboola: I’m trying to remember the school.
335 00:31:07.470 ⇒ 00:31:08.800 Demilade Agboola: Give me one second.
336 00:31:09.140 ⇒ 00:31:13.290 Demilade Agboola: But he basically got his admission, and because of the ban, he can’t apply for a visa.
337 00:31:13.290 ⇒ 00:31:13.740 Emily Giant: Ugh.
338 00:31:13.740 ⇒ 00:31:15.619 Demilade Agboola: So, so now he’s looking at…
339 00:31:15.810 ⇒ 00:31:16.960 Emily Giant: Oh my god.
340 00:31:16.960 ⇒ 00:31:17.730 Demilade Agboola: Yeah.
341 00:31:18.630 ⇒ 00:31:27.419 Emily Giant: I wonder if they’ll make any exceptions for that. I mean, they were pretty nuts earlier this year about, like.
342 00:31:28.750 ⇒ 00:31:35.859 Emily Giant: any students that were protesting Israel that were not from America at any college.
343 00:31:36.050 ⇒ 00:31:38.329 Emily Giant: But that’s very different.
344 00:31:38.960 ⇒ 00:31:40.730 Demilade Agboola: Yeah, I mean, this is just…
345 00:31:41.520 ⇒ 00:31:43.460 Emily Giant: It… yeah, that is…
346 00:31:44.070 ⇒ 00:31:50.629 Emily Giant: a shame for the United States, is what that is. I mean, for your friend, obviously, more so, but, like…
347 00:31:51.820 ⇒ 00:31:57.650 Emily Giant: When you’re no longer… Having, like, people that could…
348 00:31:57.930 ⇒ 00:32:12.330 Emily Giant: gainfully, like, the thought of someone in that cohort from Nigeria getting an MBA, like, what that could teach the other people that are just all from the same place.
349 00:32:12.490 ⇒ 00:32:16.090 Emily Giant: Like, doing the same thing, that’s a huge miss.
350 00:32:17.380 ⇒ 00:32:19.240 Demilade Agboola: Yeah, oh yeah, you’re going to Michigan Ross.
351 00:32:19.690 ⇒ 00:32:20.850 Emily Giant: Oh, wow!
352 00:32:20.850 ⇒ 00:32:21.630 Demilade Agboola: Yeah.
353 00:32:21.630 ⇒ 00:32:22.920 Emily Giant: Is that in Ann Arbor?
354 00:32:23.980 ⇒ 00:32:29.470 Demilade Agboola: I’m not sure, actually. I just… like, I just looked at, because, again, I had conversations with him.
355 00:32:30.330 ⇒ 00:32:36.679 Demilade Agboola: And I know he was like, yeah, because I bring one of the… it’s a very good business school.
356 00:32:37.490 ⇒ 00:32:38.649 Emily Giant: I, I think it’s the…
357 00:32:38.650 ⇒ 00:32:40.180 Demilade Agboola: It’s, yeah, it’s a novel.
358 00:32:40.180 ⇒ 00:32:43.130 Emily Giant: It’s like an Ivy League school. My brother lives in Ann Arbor.
359 00:32:43.130 ⇒ 00:32:44.140 Demilade Agboola: Yeah, it’s not an hour.
360 00:32:44.290 ⇒ 00:32:51.969 Emily Giant: Yeah. It’s the coolest city. Actually, like, there’s a Minneapolis-esqueness about it.
361 00:32:52.370 ⇒ 00:32:53.040 Demilade Agboola: Okay.
362 00:32:53.310 ⇒ 00:32:56.370 Emily Giant: But… but obviously way smaller.
363 00:32:57.370 ⇒ 00:32:59.750 Emily Giant: But it’s a really cool town.
364 00:33:01.060 ⇒ 00:33:02.580 Emily Giant: for being in Michigan.
365 00:33:03.700 ⇒ 00:33:04.600 Demilade Agboola: Oh, fair.
366 00:33:05.830 ⇒ 00:33:08.579 Demilade Agboola: Yeah, so, yeah, I was quite, like…
367 00:33:08.970 ⇒ 00:33:16.029 Demilade Agboola: Oh, no for him, because he’s been on it for, like, a year, trying to, you know, get his GREs, all of that stuff.
368 00:33:16.530 ⇒ 00:33:20.249 Demilade Agboola: Write his letters, all get his recommendations.
369 00:33:20.500 ⇒ 00:33:22.370 Demilade Agboola: And then, that’s out the door.
370 00:33:23.450 ⇒ 00:33:29.100 Emily Giant: That’s crazy. My… I’m gonna tell my brother that, like, not that he can do anything, but he is,
371 00:33:29.210 ⇒ 00:33:33.620 Emily Giant: the director of, Urban Development for that city.
372 00:33:33.740 ⇒ 00:33:35.360 Emily Giant: And, like, I know that would…
373 00:33:35.680 ⇒ 00:33:42.400 Emily Giant: Piss him off so royally to think that, like, something like that was happening to…
374 00:33:42.790 ⇒ 00:33:44.529 Emily Giant: The city where he lives.
375 00:33:45.110 ⇒ 00:33:45.950 Demilade Agboola: Yeah.
376 00:33:46.150 ⇒ 00:33:52.880 Emily Giant: So… Is there any chance that it will change? Like, when is he meant to start?
377 00:33:54.030 ⇒ 00:33:56.450 Demilade Agboola: I believe it was,
378 00:33:56.820 ⇒ 00:33:59.919 Demilade Agboola: I believe he was applying for fall, I believe?
379 00:34:00.160 ⇒ 00:34:01.530 Demilade Agboola: Like, fall admission.
380 00:34:02.490 ⇒ 00:34:10.629 Emily Giant: maybe it will change by then. It just seems like, especially in a school like that, like, they would really fight for…
381 00:34:11.230 ⇒ 00:34:17.049 Emily Giant: the people that they accepted, because it’s a pretty narrow list, I’m guessing.
382 00:34:17.710 ⇒ 00:34:21.779 Demilade Agboola: Yeah, it’s… it’s quite disappointing, but it’s fine.
383 00:34:22.239 ⇒ 00:34:26.389 Emily Giant: I mean, he’s already looking at schools in Europe and trying to see if… Yeah.
384 00:34:26.389 ⇒ 00:34:31.629 Demilade Agboola: gets his stuff ready in time, and all that, like… Well, you have to…
385 00:34:31.960 ⇒ 00:34:34.439 Demilade Agboola: You have to keep moving, you can’t just…
386 00:34:37.030 ⇒ 00:34:39.790 Emily Giant: It’s… disgraceful.
387 00:34:40.750 ⇒ 00:34:42.509 Demilade Agboola: Okay, so here’s the thing.
388 00:34:46.179 ⇒ 00:34:52.039 Demilade Agboola: I can’t seem to sit amongst the… the…
389 00:34:53.179 ⇒ 00:34:58.189 Demilade Agboola: consult… internal council orders, but there are some internal consult orders, by the way, that…
390 00:34:58.190 ⇒ 00:34:58.690 Emily Giant: Hmm.
391 00:34:58.690 ⇒ 00:35:03.349 Demilade Agboola: have been… They’re… oh, they’re from, like, last month and the month before.
392 00:35:03.960 ⇒ 00:35:09.359 Emily Giant: Yeah, they’re probably all from Andrew Wilcox, who does all the development for subscriptions.
393 00:35:09.920 ⇒ 00:35:10.300 Demilade Agboola: Okay.
394 00:35:10.300 ⇒ 00:35:14.270 Emily Giant: This is, like, wild orders, so that’s why I put that filter in.
395 00:35:15.680 ⇒ 00:35:17.329 Demilade Agboola: Oh, okay. Let’s see.
396 00:35:19.070 ⇒ 00:35:21.070 Demilade Agboola: So it’s not here…
397 00:35:35.540 ⇒ 00:35:38.370 Demilade Agboola: This is throwing me in a loop, give me one second.
398 00:35:40.260 ⇒ 00:35:43.250 Demilade Agboola: I need to figure out what’s going on here.
399 00:36:16.780 ⇒ 00:36:17.910 Demilade Agboola: Nooooo…
400 00:36:24.790 ⇒ 00:36:28.309 Demilade Agboola: Oh, I got it, I know what the issue is.
401 00:36:31.390 ⇒ 00:36:32.920 Emily Giant: Is it in the staging model?
402 00:36:33.200 ⇒ 00:36:36.040 Demilade Agboola: No, so the issue is, it is null.
403 00:36:36.200 ⇒ 00:36:38.620 Demilade Agboola: It’s not in subscriptions.
404 00:36:38.790 ⇒ 00:36:40.079 Demilade Agboola: For some reason.
405 00:36:40.220 ⇒ 00:36:46.079 Demilade Agboola: And so when we’re filtering out It’s… give me one second.
406 00:36:59.170 ⇒ 00:37:03.730 Demilade Agboola: So… When you write queries sometimes, if you… if there are null values.
407 00:37:03.890 ⇒ 00:37:06.710 Demilade Agboola: It will filter out the null values as well.
408 00:37:07.290 ⇒ 00:37:07.910 Emily Giant: Ugh.
409 00:38:09.110 ⇒ 00:38:15.000 Demilade Agboola: Hmm, so this… Also, as soon as I need a modified version, that should work.
410 00:38:18.960 ⇒ 00:38:24.680 Demilade Agboola: Yeah, this… this error thing has happened to me before, and it’s one of the most frustrating.
411 00:38:24.680 ⇒ 00:38:27.689 Emily Giant: new one, for me. So odd.
412 00:38:28.240 ⇒ 00:38:32.739 Demilade Agboola: Yeah, it’s quite frustrating because it’s just like, alright, so I fixed it.
413 00:38:33.090 ⇒ 00:38:35.159 Emily Giant: It’s quite frustrating, because it’s like…
414 00:38:35.880 ⇒ 00:38:40.300 Demilade Agboola: why the fuck is this not working? Yeah, like, if you do, like…
415 00:38:40.300 ⇒ 00:38:43.150 Emily Giant: Equals internal canceled, same thing.
416 00:38:43.170 ⇒ 00:38:44.200 Demilade Agboola: What’s up?
417 00:38:45.660 ⇒ 00:38:49.029 Demilade Agboola: This is what it should look like. So I sent it from the subscriptions, though.
418 00:38:49.150 ⇒ 00:38:50.350 Demilade Agboola: get too many.
419 00:38:50.780 ⇒ 00:38:53.049 Demilade Agboola: constant, those might, like, that many…
420 00:38:54.460 ⇒ 00:38:55.020 Emily Giant: Rose.
421 00:38:55.020 ⇒ 00:38:57.729 Demilade Agboola: characters into this. I’ll send you a Slack.
422 00:38:57.980 ⇒ 00:38:58.540 Emily Giant: Okay.
423 00:38:59.650 ⇒ 00:39:01.949 Emily Giant: My Slack has been so quiet today.
424 00:39:02.470 ⇒ 00:39:03.679 Demilade Agboola: And I think…
425 00:39:03.680 ⇒ 00:39:09.819 Emily Giant: I… yeah, either that, or it is… it’s broken, because it has not been quiet lately.
426 00:39:10.360 ⇒ 00:39:15.380 Emily Giant: I mean, actually, probably said, do not talk to her until our dashboards are up and running.
427 00:39:15.900 ⇒ 00:39:19.830 Emily Giant: Which, honestly, thank you, Menakshi. It is working.
428 00:39:20.410 ⇒ 00:39:21.000 Emily Giant: Okay.
429 00:39:21.970 ⇒ 00:39:26.270 Demilade Agboola: So just, I did fix… it’s basically… this is from the subscriptions…
430 00:39:27.790 ⇒ 00:39:33.850 Demilade Agboola: ordered. So the only change I made, actually, is I… put a Quales on…
431 00:39:34.340 ⇒ 00:39:40.809 Demilade Agboola: the subscriptions… cancellation reason, basically. You’ll see. That’s the only change. You don’t have to change anything else, actually.
432 00:39:42.900 ⇒ 00:39:47.430 Demilade Agboola: So you’ll see that this is what I do with QALS, SOPS, this is that.
433 00:39:48.280 ⇒ 00:39:49.020 Emily Giant: Got it.
434 00:39:49.430 ⇒ 00:39:50.200 Demilade Agboola: Mmm…
435 00:39:50.390 ⇒ 00:39:58.190 Emily Giant: Well, that’s real annoying, but here we are, and it’s solved. Okay, so…
436 00:39:59.870 ⇒ 00:40:08.700 Demilade Agboola: So now, every value has a string value that you can now do, is not included in it until we remove it.
437 00:40:15.010 ⇒ 00:40:16.830 Emily Giant: Okay, select this.
438 00:40:17.350 ⇒ 00:40:22.410 Demilade Agboola: Yeah, so if you compile it and test it now, you’ll see that the value comes out.
439 00:40:26.930 ⇒ 00:40:30.550 Demilade Agboola: Oh, no, that’s not the full query, though. If you want the full query, I can send it to you.
440 00:40:30.660 ⇒ 00:40:32.240 Demilade Agboola: I only sent you the CT.
441 00:40:32.920 ⇒ 00:40:35.859 Emily Giant: Oh, oh, oh, oh, okay. No, I don’t need the full query.
442 00:40:37.210 ⇒ 00:40:39.230 Emily Giant: But this is what you sent. This is…
443 00:40:40.160 ⇒ 00:40:45.279 Demilade Agboola: Yeah, it’s just the last two. Yeah, but it’s just… yeah, you still have to put the first parts…
444 00:40:48.060 ⇒ 00:40:49.229 Demilade Agboola: We’ll get there.
445 00:40:51.890 ⇒ 00:40:52.460 Emily Giant: Okay.
446 00:40:54.090 ⇒ 00:40:55.290 Emily Giant: Bada bing.
447 00:41:39.500 ⇒ 00:41:41.580 Emily Giant: You can do it! Come on!
448 00:41:44.760 ⇒ 00:41:48.400 Emily Giant: Wow, what’s this… No!
449 00:41:49.120 ⇒ 00:41:50.880 Demilade Agboola: Bro, can we see the… can I see?
450 00:41:51.340 ⇒ 00:41:54.510 Demilade Agboola: This, this… can you go to the Quales Park?
451 00:41:56.750 ⇒ 00:41:59.299 Demilade Agboola: Okay, that’s fascinating.
452 00:41:59.530 ⇒ 00:42:02.509 Demilade Agboola: It’s working on my end, I don’t… let me see…
453 00:42:02.510 ⇒ 00:42:04.740 Emily Giant: Oh, wait a minute, I know why.
454 00:42:05.180 ⇒ 00:42:06.470 Demilade Agboola: Oh, he’s still deaf.
455 00:42:07.130 ⇒ 00:42:09.099 Emily Giant: Because I repasted it.
456 00:42:15.070 ⇒ 00:42:16.960 Emily Giant: That’s fascinating.
457 00:42:17.460 ⇒ 00:42:18.400 Emily Giant: Okay.
458 00:42:24.530 ⇒ 00:42:25.940 Emily Giant: Alright, there it is.
459 00:42:27.070 ⇒ 00:42:28.820 Demilade Agboola: Yeah, so that’s…
460 00:42:32.560 ⇒ 00:42:36.810 Emily Giant: Alright, and then… Total price, 75.6.
461 00:42:37.160 ⇒ 00:42:39.990 Emily Giant: Don’t understand that discount, but that’s okay.
462 00:42:42.440 ⇒ 00:42:44.940 Emily Giant: Then, adjusted lifetime revenue.
463 00:42:46.100 ⇒ 00:42:50.510 Demilade Agboola: What’s the… Discounts is quite… seems fine… seems very weird.
464 00:42:52.060 ⇒ 00:42:59.870 Emily Giant: It’s probably, you know what? I don’t know what it is. It’s probably a prepaid subscription.
465 00:43:00.280 ⇒ 00:43:01.000 Demilade Agboola: Hold on.
466 00:43:01.270 ⇒ 00:43:04.780 Emily Giant: But here, okay. This is the payment summary.
467 00:43:08.680 ⇒ 00:43:10.509 Emily Giant: I do not see…
468 00:43:14.210 ⇒ 00:43:15.759 Emily Giant: Let me open it and loop.
469 00:43:29.510 ⇒ 00:43:35.619 Emily Giant: Yeah, that’s odd. I think it’s taking the products that it zeroed out and adding them together.
470 00:43:36.270 ⇒ 00:43:38.979 Demilade Agboola: Yeah, it tends to do that, to be fair.
471 00:43:39.360 ⇒ 00:43:39.770 Emily Giant: Yeah.
472 00:43:39.770 ⇒ 00:43:43.330 Demilade Agboola: It has a zero order, so it believes the discount is…
473 00:43:43.610 ⇒ 00:43:47.100 Demilade Agboola: That. Which is kind of why we don’t necessarily…
474 00:43:47.300 ⇒ 00:43:55.030 Demilade Agboola: Which is why we have that unique calculation for revenue, because we don’t want to include the discount, because it will give us, like, to throw our calculation into a loop.
475 00:43:55.690 ⇒ 00:43:56.560 Emily Giant: Yep.
476 00:43:59.580 ⇒ 00:44:00.440 Emily Giant: Okay.
477 00:44:01.980 ⇒ 00:44:04.170 Emily Giant: Adding $0 products.
478 00:44:06.560 ⇒ 00:44:07.370 Emily Giant: Okay.
479 00:44:07.740 ⇒ 00:44:09.740 Emily Giant: So that’s easy enough to fix.
480 00:44:10.660 ⇒ 00:44:14.640 Emily Giant: Alright, so, with that, I would need to do…
481 00:44:15.000 ⇒ 00:44:18.890 Demilade Agboola: Also, there’s… you should… can you do, like, a count?
482 00:44:19.130 ⇒ 00:44:26.810 Demilade Agboola: Of, like, with this new joint, can you do a count of the altitude and compare it to the initial order’s count?
483 00:44:29.670 ⇒ 00:44:32.329 Demilade Agboola: So you can… so, like, yeah, so you could just do…
484 00:44:33.340 ⇒ 00:44:42.580 Demilade Agboola: Oh, I mean, it should be lower, but because… it shouldn’t be too much lower, because we’ve… it’s just 61 internal canceled, and I’m not sure how many product SKUs there are.
485 00:44:42.850 ⇒ 00:44:44.530 Demilade Agboola: That have that, like.
486 00:44:46.790 ⇒ 00:44:53.379 Demilade Agboola: also, yeah, the… where other processes, not known is also… I don’t know how many that would be as well.
487 00:44:58.310 ⇒ 00:45:00.420 Demilade Agboola: Yeah, you need to put a comma after…
488 00:45:00.420 ⇒ 00:45:01.150 Emily Giant: weird.
489 00:45:01.640 ⇒ 00:45:04.210 Emily Giant: And also, it’s final, there’s a typo.
490 00:45:06.810 ⇒ 00:45:07.770 Emily Giant: Find us all.
491 00:45:14.090 ⇒ 00:45:20.709 Emily Giant: I don’t know who it was, said to me on a meeting the other day, they were like, if somebody had to watch me type, I couldn’t do my job. I’m like, if…
492 00:45:21.110 ⇒ 00:45:31.340 Emily Giant: I couldn’t do my job when somebody watched me type, but I couldn’t do my job. All we do is watch each other spell things wrong all day long, not for commas. Okay, so it’s 60…
493 00:45:31.820 ⇒ 00:45:33.670 Emily Giant: 1,534.
494 00:45:34.260 ⇒ 00:45:41.109 Demilade Agboola: Okay, so that’s not too bad, because this is 60,000, like, the loop orders is $60,556.
495 00:45:41.300 ⇒ 00:45:48.749 Demilade Agboola: So… That… that makes it a bit more… Sense, like, compared to…
496 00:45:49.220 ⇒ 00:45:51.999 Demilade Agboola: What it was before, let me see what the numbers were before.
497 00:45:54.260 ⇒ 00:45:56.280 Demilade Agboola: Return out the lights.
498 00:45:57.600 ⇒ 00:45:58.950 Demilade Agboola: I don’t know, plants.
499 00:46:00.300 ⇒ 00:46:01.200 Demilade Agboola: Turning now.
500 00:46:03.360 ⇒ 00:46:04.520 Demilade Agboola: Hmm, hmm…
501 00:46:04.520 ⇒ 00:46:08.149 Emily Giant: ID, does that… it also exists in orders, I think.
502 00:46:11.090 ⇒ 00:46:14.269 Demilade Agboola: So, before, it would have been…
503 00:46:22.190 ⇒ 00:46:27.760 Demilade Agboola: Alright, so prior to a fixed… So, 60,534, right?
504 00:46:28.360 ⇒ 00:46:29.320 Demilade Agboola: Yeah.
505 00:46:29.780 ⇒ 00:46:37.530 Demilade Agboola: our fix now makes it… it was $9,000 before, or something. Yeah, I don’t… you know, that’s a…
506 00:46:38.970 ⇒ 00:46:40.260 Demilade Agboola: quite the graphic, kind of.
507 00:46:40.260 ⇒ 00:46:41.610 Emily Giant: Huge difference.
508 00:46:42.050 ⇒ 00:46:42.740 Demilade Agboola: Yeah.
509 00:46:44.020 ⇒ 00:46:44.810 Emily Giant: Okay.
510 00:46:45.680 ⇒ 00:46:49.509 Emily Giant: So… I’ll have to… Sorry, go ahead.
511 00:46:49.690 ⇒ 00:47:00.659 Demilade Agboola: Yeah, so, like, I literally just did it, so now that I did it, it’s $16,534, before it would have been 9,972, so that’s where a lot of your drop was coming from, like, the missing…
512 00:47:00.950 ⇒ 00:47:09.100 Demilade Agboola: values… So that’s the first one. I think there’s also a drop in the next model, which is…
513 00:47:09.280 ⇒ 00:47:12.340 Emily Giant: Yes. This one.
514 00:47:13.340 ⇒ 00:47:15.069 Emily Giant: Loop with floral skew.
515 00:47:16.320 ⇒ 00:47:20.599 Demilade Agboola: Yes, look for our scale. But I think that was a slight drop, but we just…
516 00:47:21.560 ⇒ 00:47:23.539 Demilade Agboola: Let me see if we can quickly get an eye on it.
517 00:47:24.150 ⇒ 00:47:24.790 Emily Giant: Okay.
518 00:47:25.090 ⇒ 00:47:32.750 Demilade Agboola: Sugar, we’re taking this… From this, we’re taking loans from others. This…
519 00:47:33.510 ⇒ 00:47:38.469 Demilade Agboola: Partitioning on this, we’re joining the other lines with…
520 00:47:40.280 ⇒ 00:47:45.400 Demilade Agboola: The product types, cool. We’re removing the floral types.
521 00:47:56.540 ⇒ 00:48:00.990 Demilade Agboola: I actually think things should be fine. It’s a left join based off…
522 00:48:02.130 ⇒ 00:48:05.170 Demilade Agboola: merge loop with this. Let me… let me try.
523 00:48:05.490 ⇒ 00:48:06.240 Emily Giant: Yeah.
524 00:48:07.720 ⇒ 00:48:08.360 Demilade Agboola: Nice.
525 00:48:08.490 ⇒ 00:48:13.670 Demilade Agboola: Let’s see… Where is this?
526 00:48:43.030 ⇒ 00:48:44.839 Demilade Agboola: Alright, let’s do this.
527 00:48:50.350 ⇒ 00:48:52.560 Demilade Agboola: Oh, okay…
528 00:48:59.340 ⇒ 00:49:04.765 Demilade Agboola: Yeah, this… this is weird. So… The…
529 00:49:09.030 ⇒ 00:49:12.540 Demilade Agboola: Actually, no, I take that back. It does appear there is a drop.
530 00:49:16.810 ⇒ 00:49:23.690 Demilade Agboola: So, like, I just did a count all based on loop orders. So, loop orders is $60,556.
531 00:49:24.150 ⇒ 00:49:29.419 Demilade Agboola: merge loops up with others is 9,972, like I said before.
532 00:49:31.260 ⇒ 00:49:37.269 Demilade Agboola: And subscriptions loop with floral skew is 2. That is weird. Like, why are there only 2 rows?
533 00:49:37.860 ⇒ 00:49:38.680 Emily Giant: Who?
534 00:49:39.130 ⇒ 00:49:39.800 Demilade Agboola: Yes.
535 00:49:43.590 ⇒ 00:49:44.630 Demilade Agboola: Alright.
536 00:49:49.320 ⇒ 00:49:50.250 Emily Giant: Alright.
537 00:49:50.540 ⇒ 00:49:51.159 Emily Giant: Let me come.
538 00:49:51.160 ⇒ 00:49:51.970 Demilade Agboola: Boom.
539 00:49:52.250 ⇒ 00:49:57.910 Demilade Agboola: Shopify Row Rank is 1… Oh yeah, I’m guessing the same thing is applying here.
540 00:49:58.940 ⇒ 00:50:05.389 Demilade Agboola: If you’re filtering on the row rank from the left join, where it’s not coalesced.
541 00:50:05.540 ⇒ 00:50:09.370 Demilade Agboola: So I think when it’s known, it will… exclude it.
542 00:50:11.600 ⇒ 00:50:14.789 Emily Giant: So, this error… from, like, 91 to 99.
543 00:50:15.960 ⇒ 00:50:19.409 Demilade Agboola: Sorry, I’m looking at your screen, I was looking at my screen, can you… can I…
544 00:50:19.410 ⇒ 00:50:20.290 Emily Giant: Yep, easy.
545 00:50:20.750 ⇒ 00:50:29.910 Demilade Agboola: Alright, so, yeah, so if you go to… my straight-up guess will be the same thing we just did before. So if you go to, like, 91 to 99, yeah, we have raw rank.
546 00:50:31.300 ⇒ 00:50:32.279 Demilade Agboola: And then…
547 00:50:34.160 ⇒ 00:50:37.179 Emily Giant: Wait, I don’t see… I only see my screen.
548 00:50:37.660 ⇒ 00:50:39.639 Demilade Agboola: No, no, no, no, I’m not sharing my screen, I was looking
549 00:50:40.060 ⇒ 00:50:42.189 Demilade Agboola: I was looking at my screen before, but now I’m looking at you.
550 00:50:42.350 ⇒ 00:50:46.189 Demilade Agboola: So if you go to 91 to 99, you would have rural rank.
551 00:50:46.330 ⇒ 00:50:48.269 Demilade Agboola: Which is what you’re doing.
552 00:50:48.610 ⇒ 00:50:54.509 Demilade Agboola: But then, you know, like, how I just… like, what we just did now, if there isn’t… if it’s not explicitly said.
553 00:50:55.530 ⇒ 00:51:02.350 Demilade Agboola: that it is there. If it’s a null value, it eliminates it. So what you need to do…
554 00:51:02.850 ⇒ 00:51:06.440 Demilade Agboola: in this case, is do a QALS
555 00:51:06.790 ⇒ 00:51:10.410 Demilade Agboola: You know, let me just quickly tell you, or let me just quickly write it.
556 00:51:10.560 ⇒ 00:51:11.960 Emily Giant: Okay. Call us…
557 00:51:13.580 ⇒ 00:51:16.830 Demilade Agboola: of… Shopify…
558 00:51:24.750 ⇒ 00:51:25.715 Emily Giant: 2.
559 00:51:29.000 ⇒ 00:51:31.729 Demilade Agboola: Yeah, that was quite funny, to be honest.
560 00:51:33.320 ⇒ 00:51:43.419 Demilade Agboola: Alright, so now… this should be fine. Let me send you… so it’s the final select statement, I just made modifications, so you don’t need to change much from…
561 00:51:43.990 ⇒ 00:51:52.529 Demilade Agboola: before… So, I just basically did it as a Shopify rank, yes, but also make it 1.
562 00:51:52.880 ⇒ 00:51:54.300 Demilade Agboola: Like, by default?
563 00:51:54.630 ⇒ 00:51:55.260 Emily Giant: Okay.
564 00:51:55.510 ⇒ 00:51:58.399 Demilade Agboola: And so, in the case where it is…
565 00:52:00.800 ⇒ 00:52:02.590 Demilade Agboola: So, have you seen this in the Zoom chat?
566 00:52:03.660 ⇒ 00:52:05.630 Emily Giant: Oh, yes, I copied it.
567 00:52:05.820 ⇒ 00:52:06.540 Demilade Agboola: Oh, God.
568 00:52:06.800 ⇒ 00:52:08.849 Demilade Agboola: Well, I believe that should make you fine.
569 00:52:10.450 ⇒ 00:52:10.990 Emily Giant: Okay.
570 00:52:19.640 ⇒ 00:52:24.439 Emily Giant: Alright, I will… Test that out.
571 00:52:25.050 ⇒ 00:52:29.420 Emily Giant: just running it. There might also be a problem with how I’ve…
572 00:52:29.650 ⇒ 00:52:36.190 Emily Giant: done this part. Like, only selecting the floral and not the vase, and that way it’s, like, not written, but…
573 00:52:36.610 ⇒ 00:52:42.280 Demilade Agboola: Yeah, but that should not affect… because remember, it’s a left join, right? Right. So all that should mean is that the Shopify…
574 00:52:43.130 ⇒ 00:52:45.839 Demilade Agboola: for our product ID and stuff should be null.
575 00:52:46.210 ⇒ 00:52:46.730 Emily Giant: Yeah.
576 00:52:46.730 ⇒ 00:52:49.140 Demilade Agboola: Filtered out, so it’s the…
577 00:52:49.580 ⇒ 00:52:53.889 Demilade Agboola: It’s the whole thing of, like, if it’s looking for a value, and it is.
578 00:52:53.890 ⇒ 00:52:54.570 Emily Giant: Hmm.
579 00:52:55.200 ⇒ 00:52:56.300 Emily Giant: It just filters it out.
580 00:52:56.300 ⇒ 00:52:59.680 Demilade Agboola: Exactly, which is what we did, which is what happened earlier.
581 00:52:59.980 ⇒ 00:53:05.519 Emily Giant: Well, that’s effin’ horrifying. Like, why has it decided to do that suddenly?
582 00:53:06.760 ⇒ 00:53:12.630 Emily Giant: Like, now I’m like, what other models have I not coalesced? And it’s just felt…
583 00:53:13.060 ⇒ 00:53:17.920 Emily Giant: It could be hundreds. I need to do a full refresh on this, but I’m guessing…
584 00:53:17.920 ⇒ 00:53:23.459 Demilade Agboola: So what you can do is you can compile it and just do a count, or that’s kind of what we just need to see.
585 00:53:24.760 ⇒ 00:53:28.160 Demilade Agboola: And then, as long as it’s not 2, we should be gone.
586 00:53:28.410 ⇒ 00:53:30.020 Emily Giant: It’s gonna take me the rest of my life.
587 00:53:30.020 ⇒ 00:53:35.690 Demilade Agboola: It’s probably going to be, like, 9,000, because we’ve not done a full refresh on the uptream model, so it’s…
588 00:53:39.170 ⇒ 00:53:41.280 Demilade Agboola: And then we just need to replace, like…
589 00:53:42.560 ⇒ 00:53:44.730 Demilade Agboola: The dev as well, dev analytics.
590 00:53:45.470 ⇒ 00:53:51.500 Emily Giant: Yes. Let me do… Comma, final, not fenizzle.
591 00:53:51.500 ⇒ 00:53:53.219 Demilade Agboola: No, Fineso? You sure?
592 00:53:53.220 ⇒ 00:53:55.049 Emily Giant: No finessell. Not today.
593 00:53:55.820 ⇒ 00:53:59.840 Emily Giant: And then, I’m final, and then dev…
594 00:54:08.730 ⇒ 00:54:10.430 Demilade Agboola: Okay, so we can run that.
595 00:54:12.750 ⇒ 00:54:21.039 Demilade Agboola: So as long as we get, like, 9,000-ish, we’re fine. 9,000, 972, we’re fine, because the logic will just do the same. So yeah, it’s doing 2 now.
596 00:54:21.940 ⇒ 00:54:30.899 Demilade Agboola: Interesting. Can you… Good dawn… Sorry, so let’s go down, like, to the bottom.
597 00:54:32.330 ⇒ 00:54:35.640 Demilade Agboola: We have done the rank as this…
598 00:54:38.370 ⇒ 00:54:41.430 Demilade Agboola: Let me see… alright, just cause one…
599 00:54:47.510 ⇒ 00:54:48.650 Demilade Agboola: Interesting.
600 00:54:49.240 ⇒ 00:54:54.089 Demilade Agboola: Alright, so I’ll look at this and get back to you and just try and figure out why that’s 2. So 2 is ridiculously low.
601 00:54:54.510 ⇒ 00:55:01.539 Emily Giant: Does it… not tracking for me. But yeah, I’ll look at it too, but,
602 00:55:02.290 ⇒ 00:55:18.240 Emily Giant: Yeah, very strange. Okay. Well, I’m glad that we both found this strange. I was like, what is happening? All right, cool. I’ll keep working on this and let you know if I figure it out, but I do have to hop. I’m sure you have a meeting at 3-2, or 2? Yeah.
603 00:55:18.240 ⇒ 00:55:32.370 Demilade Agboola: Just so we’re on the same page, I’m, like, I’m wondering what the plan for engagement is, like, going forward? Yeah. Like, how many hours would you say you need? And, like, would it just be, like, the weekly working session, or, like, do you need…
604 00:55:32.370 ⇒ 00:55:47.490 Emily Giant: So, for now, I need to negotiate with Zach. Right now, like, the one hour a week, like, don’t feel the need to do any extra work on this this week, until we have it figured out, because right now, it’s just hourly, and, like, yep, if it’s,
605 00:55:47.990 ⇒ 00:55:50.440 Emily Giant: One hour is fine.
606 00:55:50.770 ⇒ 00:55:55.749 Emily Giant: if you need more, I have to, like, propose it to him, and say the hours that it would take.
607 00:55:56.050 ⇒ 00:55:56.790 Demilade Agboola: Oh, okay.
608 00:55:56.790 ⇒ 00:56:02.900 Emily Giant: Yeah, don’t worry about this, I think we’re in a good direction, but I will write you as soon as I talk to him tomorrow.
609 00:56:03.210 ⇒ 00:56:04.260 Demilade Agboola: You’re welcome.
610 00:56:04.260 ⇒ 00:56:12.820 Emily Giant: because I’ll pose the issues to them and be like, I can’t do this before Valentine’s Day, it’s too much. So, I’ll follow up.
611 00:56:13.070 ⇒ 00:56:13.860 Emily Giant: Real quick.
612 00:56:14.180 ⇒ 00:56:33.520 Demilade Agboola: Alright, so just let me know, because, like, part of the new year thing is, like, I’ve also gotten promoted to, like, handle things around customer engagement and stuff, so I would need to be able to get context of that, put it to UTAM, and then we can figure out, like, staffing for Urban Stems prior to…
613 00:56:33.670 ⇒ 00:56:38.419 Demilade Agboola: Valentine’s Day, like, how many hours from me, how many hours from my wage, if we’re gonna have, like, that in…
614 00:56:38.790 ⇒ 00:56:43.720 Demilade Agboola: As a concept, because we’re also on other projects, and we need to know how to delegate
615 00:56:43.850 ⇒ 00:56:46.390 Demilade Agboola: Across all of that, so… Excuse…
616 00:56:46.390 ⇒ 00:56:52.219 Emily Giant: But, yeah, I’ll talk to him. We talk, like, every day, so I’ll make sure to get that all…
617 00:56:52.930 ⇒ 00:56:54.180 Emily Giant: ASAP.
618 00:56:54.180 ⇒ 00:57:04.240 Demilade Agboola: Alright, sounds good, sounds good. If it’s just gonna be the one hour, that’s fine, too. I just, again, just for us to be able to know how… how many hours to budget, and, like, how to make that work, amongst the brain frauds team.
619 00:57:04.710 ⇒ 00:57:09.139 Emily Giant: I’m assuming it’s going to be a request for more,
620 00:57:09.140 ⇒ 00:57:09.870 Demilade Agboola: Oh, okay.
621 00:57:10.440 ⇒ 00:57:19.520 Emily Giant: But let’s… for sure, the one hour a week is, like, signed, sealed, delivered, that’s fine. But, yeah, I’ll get back with you ASAP, I know how busy you guys are.
622 00:57:19.520 ⇒ 00:57:20.780 Demilade Agboola: Alright, sounds good.
623 00:57:20.780 ⇒ 00:57:25.329 Emily Giant: Alright, thank you, Dak, the halls look beautiful! I’ll talk to you later.
624 00:57:26.840 ⇒ 00:57:28.050 Demilade Agboola: Bye then.