Meeting Title: Revenue Calculation and Looker QA Sync Date: 2025-10-01 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:00:49.060 ⇒ 00:00:50.390 Emily Giant: Hey, hey!
2 00:00:50.390 ⇒ 00:00:52.000 Demilade Agboola: Hi, Emily, how are you?
3 00:00:52.750 ⇒ 00:00:58.250 Emily Giant: I’m good, my voice is a lot better today. Not 100%, but yesterday I was like…
4 00:00:58.530 ⇒ 00:01:01.660 Demilade Agboola: I could hear the train right there, but it’s.
5 00:01:01.660 ⇒ 00:01:02.410 Emily Giant: Yeah.
6 00:01:02.410 ⇒ 00:01:02.890 Demilade Agboola: Better.
7 00:01:03.580 ⇒ 00:01:16.870 Emily Giant: Yeah, a lot better than it was. I… I was chatting with Amber a lot yesterday, just to get caught up, and I felt so bad, because she just looked at me like, I have no idea what you’re saying. I was like, let’s just… let’s just write.
8 00:01:17.250 ⇒ 00:01:20.859 Emily Giant: Are you doing anything to celebrate Independence Day?
9 00:01:22.120 ⇒ 00:01:24.890 Demilade Agboola: No, not really, just working today.
10 00:01:25.530 ⇒ 00:01:35.749 Emily Giant: Just listening to the Afrobeats playlist, and working. Which, I guess, that’s what I’m doing to celebrate, too. So, how was the wedding?
11 00:01:36.340 ⇒ 00:01:44.410 Demilade Agboola: Oh, it was pretty good, busy, because I was the bestman, so there was a lot of, like, stuff going on around the wedding.
12 00:01:45.350 ⇒ 00:01:50.659 Demilade Agboola: But it was good, it was successful, they’re married, so that’s the…
13 00:01:50.660 ⇒ 00:01:52.340 Emily Giant: Yeah, it’s just…
14 00:01:52.490 ⇒ 00:02:00.260 Emily Giant: End goal, check. That’s hilarious. If it was successful, they’re married. That’s good. Did you have to give a speech?
15 00:02:00.870 ⇒ 00:02:02.849 Demilade Agboola: Oh yeah, I did, and people really liked my speech.
16 00:02:03.150 ⇒ 00:02:04.560 Demilade Agboola: So…
17 00:02:04.560 ⇒ 00:02:05.840 Emily Giant: I bet it was great.
18 00:02:06.360 ⇒ 00:02:14.280 Demilade Agboola: Yeah, I mean, I… I was able to… blend, like.
19 00:02:14.940 ⇒ 00:02:20.440 Demilade Agboola: Preferences that people would get with, just, like, a little bit of…
20 00:02:21.300 ⇒ 00:02:28.969 Demilade Agboola: you know, praising the groom, and just talking about them, and just, you know, wishing him the best and all that, and I was able to do it in a way that people were, like.
21 00:02:29.660 ⇒ 00:02:32.610 Demilade Agboola: Yeah, that’s a really good speak. People actually met me after.
22 00:02:32.610 ⇒ 00:02:33.360 Emily Giant: Oh, that’s great.
23 00:02:33.360 ⇒ 00:02:36.139 Demilade Agboola: I really So there we go, thanks.
24 00:02:36.430 ⇒ 00:02:37.210 Demilade Agboola: So…
25 00:02:37.210 ⇒ 00:02:38.359 Emily Giant: Yeah, I always, like…
26 00:02:38.730 ⇒ 00:02:52.729 Emily Giant: I’ve had to give speeches at weddings, like, 3 times, and I just am so nervous before doing it that I, like, do not have fun until after it’s done. I’m just… all I’m doing is thinking about the speech the whole time, so I hope that you were able to, like, let loose a little bit after
27 00:02:53.000 ⇒ 00:02:55.010 Emily Giant: All of your duties were done.
28 00:02:55.330 ⇒ 00:02:56.960 Demilade Agboola: To be fair, I…
29 00:02:57.390 ⇒ 00:03:13.580 Demilade Agboola: I… in, like, secondary school, or high school, as you would say, I was, like, the head boy, so that’s, like, the senior perfect, whatever. So I was responsible, like, assemblies, I would talk quite often, so that… that helped me overcome the nervousness.
30 00:03:13.580 ⇒ 00:03:14.070 Emily Giant: Yeah.
31 00:03:14.070 ⇒ 00:03:18.810 Demilade Agboola: crowd of people. So that helped, and…
32 00:03:18.810 ⇒ 00:03:19.480 Emily Giant: Yeah.
33 00:03:19.480 ⇒ 00:03:22.739 Demilade Agboola: Yeah, to be honest, a lot of the speech was…
34 00:03:23.520 ⇒ 00:03:34.479 Demilade Agboola: pre-thought, but not pre-written. Like, I had thought of what I was going to say, but I hadn’t necessarily, like, written it down and recited it to the point. I just knew what I wanted to hit.
35 00:03:35.840 ⇒ 00:03:36.500 Emily Giant: Yeah.
36 00:03:36.710 ⇒ 00:03:39.369 Demilade Agboola: kind of swing through with that. So, yeah, that.
37 00:03:39.370 ⇒ 00:03:45.719 Emily Giant: Those are the best, though. Like, then you can, like, be present in the moment. Like, when I’m at a wedding and somebody reads.
38 00:03:45.950 ⇒ 00:03:48.540 Emily Giant: Straight from a piece of paper, I’m like, ugh.
39 00:03:51.220 ⇒ 00:04:02.279 Emily Giant: They’re doing their best. Yeah, that’s true, they’re doing their best. That’s very nice. That’s true. They weren’t a prefect, so they probably don’t have a lot of experience, but still, I’m like, come on, guys.
40 00:04:02.670 ⇒ 00:04:09.840 Emily Giant: At least, like, at least say hello without looking at the piece of paper, but whatever. Alright.
41 00:04:09.840 ⇒ 00:04:10.470 Demilade Agboola: Super vacation.
42 00:04:10.470 ⇒ 00:04:12.470 Emily Giant: Away from work.
43 00:04:13.010 ⇒ 00:04:19.109 Emily Giant: Oh, yeah, I needed it really badly. I had been so burnt out that, like, I just needed time to, like.
44 00:04:19.310 ⇒ 00:04:24.930 Emily Giant: not think. I did get sick, obviously, but, I think…
45 00:04:25.070 ⇒ 00:04:28.229 Emily Giant: That was inevitable when you worked that long.
46 00:04:28.470 ⇒ 00:04:43.609 Emily Giant: without taking a break, like, your body’s just waiting to get sick. So… but it was great. We went to the Dolomites in northern Italy and hiked. Nice. And, yeah, it was really, really beautiful. And then I went to Oktoberfest.
47 00:04:43.720 ⇒ 00:05:02.580 Emily Giant: For, like, two… we were… yeah, yeah, it was super fun, but it was so crowded that, like, it was, I think, the most attendance they’ve ever had, and they had to shut it down one of the days we were there, like, to people coming in, and we left anyway, because we thought we were going to get trampled, but it just got a little out of control, so we were like, you know what?
48 00:05:02.720 ⇒ 00:05:09.780 Emily Giant: We did one day. That’s enough. So, Munich was really, really cool. I didn’t realize, like, how much
49 00:05:10.370 ⇒ 00:05:27.370 Emily Giant: like, architecture, history, like, they have this whole old town area. I don’t know if you’ve been to Munich, but, like, really interesting city. Tons of gardens. So, did just a lot of good sightseeing, and ate way too much, but that’s what you do.
50 00:05:27.370 ⇒ 00:05:27.820 Demilade Agboola: ended.
51 00:05:27.820 ⇒ 00:05:36.880 Emily Giant: like, so happy to be back home so I can make food with spice, because Germans, I guess they don’t like putting spice on their food. Everything is just, like…
52 00:05:37.170 ⇒ 00:05:52.340 Emily Giant: like, meat, potato, no salt, no spice. So, yeah, we made curry last night as soon as we got home. I was like, I need, like, Asian food, or, like, something interesting to eat, because I am just German-fooded out.
53 00:05:52.780 ⇒ 00:05:59.350 Demilade Agboola: You sound… you sound a lot like me when I first moved to Malta. I’m just like, why is there… why is everything just bread?
54 00:06:00.130 ⇒ 00:06:00.880 Emily Giant: Yeah.
55 00:06:00.880 ⇒ 00:06:08.389 Demilade Agboola: And even the pasta, it’s just bread, pasta, meat. It’s like…
56 00:06:08.390 ⇒ 00:06:09.140 Emily Giant: Yeah.
57 00:06:09.140 ⇒ 00:06:14.569 Demilade Agboola: It’s, like, can I get some, like, some hype, some good flavor and stuff?
58 00:06:15.010 ⇒ 00:06:18.069 Demilade Agboola: I would have paid triple for Indian food.
59 00:06:18.070 ⇒ 00:06:36.290 Emily Giant: Like, if it was available, just, like, give me anything that has, like, flavor. Yeah, by the end of it, I was like, what is… what’s going on? Like, why does the United States have, like, a better spice trade program going on than the countries directly next to this place? It doesn’t make any sense to me.
60 00:06:36.370 ⇒ 00:06:39.190 Emily Giant: It’s just… it’s their palates, I guess. They just…
61 00:06:39.190 ⇒ 00:06:39.670 Demilade Agboola: Yeah.
62 00:06:39.670 ⇒ 00:06:47.629 Emily Giant: There’s sauerkraut and potatoes and whatever, but I don’t ever need to eat German food again, at least this year. Like, I’m done.
63 00:06:47.740 ⇒ 00:06:59.710 Emily Giant: topped off, but yeah, it was good. I’m glad to be back. Two weeks is a long time. Like, it went fast, but at the same time, I was like, yeah, I… that was a minute to be away.
64 00:07:00.900 ⇒ 00:07:08.909 Emily Giant: But yeah. Anyway, okay, so I just wanted to, like, figure out where we’re at, what’s going on, and then mostly to, like.
65 00:07:10.240 ⇒ 00:07:16.800 Emily Giant: with Looker. I know that you have, like, the fact order lines and fact orders. I have it in Looker, but I just want to make sure that, like.
66 00:07:16.980 ⇒ 00:07:24.819 Emily Giant: the way that I’m putting these in Looker is… Like, aligned with… What you’re thinking the end…
67 00:07:24.930 ⇒ 00:07:41.919 Emily Giant: deliverable is with these specific tables, because I know there’s still work being built on top of them, but with the different fact tables, I’ve gotten a little lost in the sauce of, like, what’s still outstanding, and what’s done, and what I can start replacing, and what I can’t.
68 00:07:42.560 ⇒ 00:07:47.310 Demilade Agboola: Sounds good. So, high level…
69 00:07:48.100 ⇒ 00:07:51.720 Demilade Agboola: Right now, what we’re trying to do is put
70 00:07:53.570 ⇒ 00:07:57.929 Demilade Agboola: the different tables together, so we can start to have,
71 00:07:58.570 ⇒ 00:08:01.309 Demilade Agboola: An easy way to calculate the revenue.
72 00:08:01.810 ⇒ 00:08:17.189 Demilade Agboola: So, players want to be able to have revenue in one place, and that’s part of why we have our meeting, why we have our meeting with Perry today, where it’s like, how do we calculate revenue, and how is, like, how do you tie subscriptions to…
73 00:08:17.860 ⇒ 00:08:20.030 Demilade Agboola: Orders, and how do you go from
74 00:08:21.260 ⇒ 00:08:24.110 Demilade Agboola: Revenue for this month, or this week, or this day.
75 00:08:24.290 ⇒ 00:08:29.079 Demilade Agboola: And so that’s kind of where we’re trying to create, like.
76 00:08:29.500 ⇒ 00:08:43.420 Demilade Agboola: clean data sets of, like, orders, of transactions, of subscriptions, of refunds. And so once we have all of that, we can easily say, so our revenue is…
77 00:08:43.520 ⇒ 00:08:54.120 Demilade Agboola: when an order is placed, if it’s a subscription, this is how revenue is calculated. If it’s a… just a one-time payment, this is how it’s calculated. We subtract discounts, we subtract refunds.
78 00:08:55.250 ⇒ 00:08:58.259 Demilade Agboola: Like, yeah, just so we can get that clear, like, formula.
79 00:08:58.560 ⇒ 00:09:04.680 Demilade Agboola: And then start building out the end states. So that’s the goal. That’s why we have a meeting with Perry today.
80 00:09:05.500 ⇒ 00:09:10.269 Emily Giant: Okay, that sounds good. So as far as what I can put in Looker right now,
81 00:09:10.720 ⇒ 00:09:14.280 Emily Giant: what I’m doing… I’ll share my screen and just show you.
82 00:09:14.440 ⇒ 00:09:15.220 Demilade Agboola: Okay.
83 00:09:15.220 ⇒ 00:09:19.959 Emily Giant: Sorry, if I go mute, just assume that I’m coughing, and that you don’t want to hear it.
84 00:09:20.830 ⇒ 00:09:21.880 Demilade Agboola: Sounds good.
85 00:09:21.880 ⇒ 00:09:23.390 Emily Giant: Can you see my screen?
86 00:09:24.070 ⇒ 00:09:25.170 Demilade Agboola: Yes, yes, I can.
87 00:09:25.960 ⇒ 00:09:29.420 Emily Giant: Are you seeing, like, my calendar right now, or are you seeing just our meeting?
88 00:09:30.140 ⇒ 00:09:31.239 Demilade Agboola: No, I’m saying Looker.
89 00:09:32.220 ⇒ 00:09:38.560 Emily Giant: Okay, perfect. Okay, so… I’m using, right now, I think I’ll probably…
90 00:09:38.900 ⇒ 00:09:50.210 Emily Giant: change it to use, the fulfillment line items. Once that’s built out, we’ll see what we actually need there. But in the model…
91 00:09:51.990 ⇒ 00:09:53.710 Emily Giant: Wait, here, I already have it pulled up.
92 00:09:54.570 ⇒ 00:09:59.649 Emily Giant: So, the goal is to, like, replace Tableau Items XF,
93 00:10:00.820 ⇒ 00:10:19.450 Emily Giant: which is Sales Data Explorer, and Component Data Explorer. We’re pretty much overhauling all of these, and then, like, inputting the forecasts into it, so I have all the new ones towards the top in this model. So I have it called Shopify Orders. None of this is live, just stakeholders, by the way. This is all just, like.
94 00:10:19.610 ⇒ 00:10:35.889 Emily Giant: me taking the pieces of what I know you’ve done, and making sure it’s ready in Looker for when we, like, do a bigger demo. So, I’m using fact order lines as the base table. I figured, like, start with the most granular, and then, like, tie things
95 00:10:36.290 ⇒ 00:10:38.599 Emily Giant: With less granularity from there.
96 00:10:38.720 ⇒ 00:10:45.359 Emily Giant: So then I’ve got… the, so… Fact Order Lines is…
97 00:10:46.060 ⇒ 00:10:50.879 Emily Giant: this table of yours. The fact… Order lines items.
98 00:10:51.560 ⇒ 00:10:54.100 Emily Giant: And it looks like the most…
99 00:10:54.300 ⇒ 00:11:02.249 Emily Giant: granular level here is, like, the order line ID, right? Like, this is the unique key, and then it would tie
100 00:11:02.810 ⇒ 00:11:05.949 Emily Giant: To just fact orders via the…
101 00:11:06.070 ⇒ 00:11:08.960 Emily Giant: order… the Shopify order ID, and…
102 00:11:09.230 ⇒ 00:11:15.130 Emily Giant: That’s it, because there’s no, like, product-level granularity, I don’t think, in fact, quarters.
103 00:11:15.550 ⇒ 00:11:18.249 Emily Giant: No. Okay, and then… yeah.
104 00:11:19.360 ⇒ 00:11:29.450 Emily Giant: So, that’s how I’m doing it, is just going in and making sure that those are done and ready for when any additional table gets done, but I wanted to make sure I understood,
105 00:11:29.890 ⇒ 00:11:37.020 Emily Giant: Refunds. Refunds is already part of this fact table, right? It’s not a separate table. Okay, thought so.
106 00:11:37.020 ⇒ 00:11:42.550 Demilade Agboola: So right now, yeah, we have Seafish Gold to the right. I believe there’s a column For a refund.
107 00:11:44.550 ⇒ 00:11:52.500 Emily Giant: Not in this one, but I… oh, yeah! Is refund refund ID? Okay. So, when it comes to refund ID,
108 00:11:52.690 ⇒ 00:11:54.739 Emily Giant: Does there need to be…
109 00:11:55.420 ⇒ 00:12:04.130 Emily Giant: this is where I’m like, bleh. There’s gonna be refund information in both fact orders and fact order line items, I believe, so…
110 00:12:04.350 ⇒ 00:12:12.060 Emily Giant: I just want to make sure that I join these correctly in Looker. So, like, refunded line items, Interesting.
111 00:12:12.410 ⇒ 00:12:21.229 Demilade Agboola: Yeah, so refund orders is kind of like a summary of this. So, facts, other line items is, think of it like…
112 00:12:21.500 ⇒ 00:12:32.039 Demilade Agboola: If there are multiple sub-orders under that, or multiple things that comes to that order, factor that line items will have all of it, but the summary of everything should be the fact orders.
113 00:12:32.180 ⇒ 00:12:36.280 Demilade Agboola: So that one line that represents everything that happened in that transaction.
114 00:12:36.410 ⇒ 00:12:38.049 Demilade Agboola: In that order, basically.
115 00:12:43.060 ⇒ 00:12:50.139 Emily Giant: So will… if there were two separate refunds, will it create a separate line in fact orders?
116 00:12:50.360 ⇒ 00:12:52.490 Emily Giant: Or will it still be in the same line?
117 00:12:52.650 ⇒ 00:13:00.290 Demilade Agboola: It should sum it. The same way, like, every… like, all the… you’re having the sum of every single thing, like, the…
118 00:13:00.440 ⇒ 00:13:08.919 Demilade Agboola: Especially, like, think of, like, when you send multiple things in one order, it will just give you one order, like, order total.
119 00:13:09.400 ⇒ 00:13:15.729 Demilade Agboola: So, it should… it should be summed up. If we’re having duplicates, we will need to look into that, but yeah, we should be one.
120 00:13:16.130 ⇒ 00:13:19.920 Demilade Agboola: item. It should be one line, sorry, for every value.
121 00:13:20.740 ⇒ 00:13:27.790 Emily Giant: Okay. Demolade, one second, my cat that has, like, the tracking device on her has just arrived at my door without the tracking device.
122 00:13:27.920 ⇒ 00:13:37.339 Emily Giant: And they’re, like, really expensive, so I just have to let Matt know real quick that he needs to go on a tracking ID hunt. So naughty. Hold on.
123 00:13:37.980 ⇒ 00:13:38.780 Demilade Agboola: Oh, okay.
124 00:13:58.570 ⇒ 00:14:01.099 Emily Giant: Okay, I’m back. Sorry about that.
125 00:14:01.810 ⇒ 00:14:20.850 Emily Giant: I just saw her, like, roll up to the door, I would call it naked, this tracking device. I actually saw a ton of them in, Germany. I think people care more about their animals in Europe than they do in the United States, but, every time we lose them, it’s a real crisis. So, anyway, can you see my screen again?
126 00:14:21.200 ⇒ 00:14:22.359 Demilade Agboola: Yeah, it’s still here.
127 00:14:22.650 ⇒ 00:14:29.930 Emily Giant: Okay, okay. So, refunds should be summed if there are multiple .
128 00:14:31.440 ⇒ 00:14:32.210 Demilade Agboola: So that’s the Amazon.
129 00:14:32.210 ⇒ 00:14:36.940 Emily Giant: to see… Yeah, if there are dupes, Orders.
130 00:14:37.230 ⇒ 00:14:43.500 Emily Giant: That has… Multiple… Refunds.
131 00:14:44.110 ⇒ 00:14:48.630 Emily Giant: Okay, and then… Fact Order Lines is…
132 00:14:50.220 ⇒ 00:14:53.610 Emily Giant: This is, like, the broken down… everything that happened on the order.
133 00:14:55.340 ⇒ 00:14:59.969 Demilade Agboola: Yeah, so that’s the breakdown of everything. So, in this way, this technically is, like.
134 00:15:01.180 ⇒ 00:15:05.589 Demilade Agboola: Suborders in its own way, but…
135 00:15:06.550 ⇒ 00:15:10.060 Demilade Agboola: I will need to look into that, especially if you’re gonna tie it back to OMS.
136 00:15:11.050 ⇒ 00:15:21.599 Emily Giant: Yeah, I can work on that. It’s just through that fulfillment table that I need to tie it back, so as long as there’s Shopify order ID, which is right here.
137 00:15:21.770 ⇒ 00:15:27.200 Emily Giant: So what I would do is just use this table to tie it back to,
138 00:15:27.710 ⇒ 00:15:30.570 Demilade Agboola: I think it’s called Fulfillment Order Lines in DBT.
139 00:15:32.130 ⇒ 00:15:36.589 Emily Giant: Well, it’s in a PR right now, so it’s not going to be in my DBT.
140 00:15:36.760 ⇒ 00:15:43.349 Emily Giant: But that’s… I can do that, if you’d like, so that you can keep moving forward with the…
141 00:15:43.590 ⇒ 00:15:53.030 Emily Giant: I think what… for later today, what Perry’s gonna bring up in terms of revenue is, the model that you’ve seen
142 00:15:53.200 ⇒ 00:15:56.300 Emily Giant: a bunch of times, called LMS
143 00:15:56.870 ⇒ 00:16:01.929 Emily Giant: Comp XF base, and that’s where the calculation for bundles and kits
144 00:16:02.310 ⇒ 00:16:10.699 Emily Giant: gets brought into the equation. I tried to, like, flesh out the ticket a little bit more in linear so that it made more sense, but…
145 00:16:11.180 ⇒ 00:16:12.060 Emily Giant: Hold on.
146 00:16:13.040 ⇒ 00:16:19.160 Emily Giant: Oh, by the way, Coach wrote me this morning and said that the The payroll report is fixed.
147 00:16:20.710 ⇒ 00:16:21.140 Demilade Agboola: Nice.
148 00:16:21.140 ⇒ 00:16:24.910 Emily Giant: I know that was, like, yeah. That was the issue going on last week.
149 00:16:25.870 ⇒ 00:16:28.710 Demilade Agboola: Yeah, the one Michael… Michael brought up.
150 00:16:28.890 ⇒ 00:16:41.540 Emily Giant: Yep. Oh, yeah, I forget that everyone thinks his name is… well, it is, it’s Michael Pierce, but we all call him Coach, so when I start talking about Coach with y’all, nobody knows what I am talking about. But yeah,
151 00:16:41.790 ⇒ 00:17:01.710 Emily Giant: it just… it happens all the time, and it looks like Demolat… or you are Demolade… like, Utam has a plan of how to fix it going forward, but essentially, everything is time-dated, so, like, the packaging costs will say, this is summer florals from July to the end of August, and as soon as the end of August hits.
152 00:17:01.710 ⇒ 00:17:14.440 Emily Giant: the report fails, and then they make a new tab, which our database doesn’t know how to read automatically, so I talked to him yesterday and was like, we can’t do this anymore. We can’t have this breaking every two months, so, like.
153 00:17:14.770 ⇒ 00:17:31.350 Emily Giant: let’s just update the format so that instead of making a new tab, you just add the name of the season, and then eventually we’ll, like, put it into NetSuite, so that the way you enter the cost, like, you don’t have to do it in a spreadsheet, because spreadsheets will always break. They’re just not a good
154 00:17:31.670 ⇒ 00:17:37.160 Emily Giant: Standard way of operating. So, okay, what’s it called?
155 00:17:37.350 ⇒ 00:17:39.119 Emily Giant: Okay, LMS Comp.
156 00:17:40.050 ⇒ 00:17:40.970 Emily Giant: Base.
157 00:17:44.130 ⇒ 00:17:45.410 Emily Giant: So…
158 00:17:46.080 ⇒ 00:18:00.359 Emily Giant: this is that flow that takes, like, staging split line items, and then staging split line item components, and, like, pairs them together. It says, like, okay, this is the name of the item in
159 00:18:01.150 ⇒ 00:18:05.849 Emily Giant: line items, and this is the component, it’s part of a kit. So, like.
160 00:18:06.450 ⇒ 00:18:08.579 Emily Giant: Good, let me just get to the logic.
161 00:18:08.930 ⇒ 00:18:16.620 Emily Giant: But what it does is it, like, takes their actual cost, And… assigns…
162 00:18:16.900 ⇒ 00:18:25.460 Emily Giant: the percent weight that that item has within the bundle, based on how much they cost individual retail. Does that make sense?
163 00:18:26.320 ⇒ 00:18:27.510 Demilade Agboola: Can you repeat that, please?
164 00:18:28.030 ⇒ 00:18:32.680 Emily Giant: Yeah, let me actually pull up the ticket, because my voice is going in and out enough that, like…
165 00:18:33.380 ⇒ 00:18:34.870 Emily Giant: Alright, it’s called…
166 00:18:56.730 ⇒ 00:19:00.939 Emily Giant: Hmm… Built instant line items tracked through, okay.
167 00:19:01.130 ⇒ 00:19:02.400 Emily Giant: Bundle of rides.
168 00:19:03.860 ⇒ 00:19:06.579 Emily Giant: It’s this. Let me send you the link to this.
169 00:19:11.380 ⇒ 00:19:19.859 Emily Giant: But the more we can spare Perry from having to repeat this, the better. We have a lot of documentation on it. But basically,
170 00:19:21.290 ⇒ 00:19:26.170 Emily Giant: This is, like, part of… How they calculate revenue?
171 00:19:26.720 ⇒ 00:19:30.830 Emily Giant: But essentially, if there’s two items in a kit, Abe.
172 00:19:31.150 ⇒ 00:19:32.709 Emily Giant: Bouquet and a vase.
173 00:19:32.930 ⇒ 00:19:40.379 Emily Giant: The kit price is gonna be less than the price of those two individual items.
174 00:19:41.150 ⇒ 00:19:50.729 Emily Giant: If they were bought separately outside of that, like, kit featured product. But we don’t recognize revenue as the individual products, we still take that kit price
175 00:19:50.850 ⇒ 00:19:58.399 Emily Giant: And if… yeah, so if the bouquet is, like, 25, then…
176 00:19:58.900 ⇒ 00:20:02.550 Emily Giant: Whatever the kitted price is.
177 00:20:03.030 ⇒ 00:20:06.140 Demilade Agboola: The bouquet receives 3 quarters of the revenue.
178 00:20:06.180 ⇒ 00:20:17.189 Emily Giant: And the base receives a quarter of the revenue. So it’s just, like, making sure that that, for bundles and kits, is built into the logic, is the main thing.
179 00:20:18.090 ⇒ 00:20:18.890 Demilade Agboola: Gotcha.
180 00:20:19.290 ⇒ 00:20:22.670 Emily Giant: Yeah, so it’s like… Where is it?
181 00:20:28.050 ⇒ 00:20:30.400 Emily Giant: Peace price… so peace revenue.
182 00:20:31.370 ⇒ 00:20:38.120 Emily Giant: East price adjusted temp quantity… but yeah, this is where all the logic happens, is in OMS Comp XF base.
183 00:20:38.230 ⇒ 00:20:42.119 Emily Giant: And this is that one that, like, if there’s a forced upgrade, it gets…
184 00:20:42.310 ⇒ 00:20:51.150 Emily Giant: really funky, because the price of the bouquet is gonna show a zero, so there’s gonna be no revenue assigned to it, because it’s…
185 00:20:51.640 ⇒ 00:20:56.769 Emily Giant: It’s processing that… That bouquets 0% weight.
186 00:20:57.600 ⇒ 00:21:00.810 Emily Giant: of the… Of the kit, but…
187 00:21:01.630 ⇒ 00:21:10.439 Emily Giant: that’s just, like, how the data is ingested in OMS. I don’t think it does that in Shopify. It will still say, like, the retail price of the kit, so that
188 00:21:11.030 ⇒ 00:21:14.550 Emily Giant: The revenue is, normalized.
189 00:21:16.660 ⇒ 00:21:20.099 Demilade Agboola: But I have that in the ticket, like, where it points to this.
190 00:21:20.100 ⇒ 00:21:25.429 Emily Giant: And then subscriptions, perry will give us a good rundown, but, like.
191 00:21:26.020 ⇒ 00:21:29.339 Emily Giant: That is more complicated, only because it changes over time.
192 00:21:29.470 ⇒ 00:21:37.690 Emily Giant: they’re, like, years where… a fixed price was different than they are now. So…
193 00:21:38.220 ⇒ 00:21:43.600 Emily Giant: Yeah, we’ll see what she says about that, but I think that this is, like, the main…
194 00:21:43.720 ⇒ 00:21:53.710 Emily Giant: Thing that we need to make sure is functioning in revenue, and where that… lives…
195 00:21:53.990 ⇒ 00:22:00.509 Emily Giant: the… in Shopify, being able to, like, tie it to those line items is in the fulfillment tables.
196 00:22:00.630 ⇒ 00:22:06.040 Emily Giant: But we’ll still need the fact order lines for, like,
197 00:22:06.700 ⇒ 00:22:19.219 Emily Giant: the, like, summary of delivery date, of purchase date, like, because you and I discovered that it doesn’t look like the fulfillment tables actually load until they’re, like.
198 00:22:19.480 ⇒ 00:22:21.490 Emily Giant: In a fulfillment process.
199 00:22:21.660 ⇒ 00:22:25.049 Emily Giant: So, yeah, that’s kind of a blocker there.
200 00:22:27.210 ⇒ 00:22:31.609 Emily Giant: But yeah, okay, so that’s where we’re at with revenue. So I’ll just keep…
201 00:22:32.060 ⇒ 00:22:34.179 Emily Giant: Like, plugging away at the…
202 00:22:34.300 ⇒ 00:22:39.920 Emily Giant: tables in Looker to make sure that those are all working, and to, like, do any QA, just making sure, like.
203 00:22:40.810 ⇒ 00:22:46.050 Emily Giant: It’s what we expect to see, but… What else…
204 00:22:47.650 ⇒ 00:22:53.350 Emily Giant: The other thing I wanted to review, because I get where you’re at with, like, Shopify stuff?
205 00:22:53.770 ⇒ 00:22:59.889 Emily Giant: But with, like, OMS sub-orders, like, those old OMS tables, are we still planning on replacing those?
206 00:23:00.040 ⇒ 00:23:01.549 Emily Giant: Or are we just, like…
207 00:23:02.160 ⇒ 00:23:10.349 Emily Giant: saying, this will be our historical, we’re gonna stop using these starting when the Shopify data is functional.
208 00:23:11.060 ⇒ 00:23:17.870 Demilade Agboola: Yeah, so ideally, we would want to replace them with Shopify data, but also we are aware that
209 00:23:18.170 ⇒ 00:23:23.569 Demilade Agboola: Number one, OMS is still running, so that there’s still new data coming in.
210 00:23:23.780 ⇒ 00:23:24.290 Demilade Agboola: Oh, no.
211 00:23:24.290 ⇒ 00:23:25.080 Emily Giant: inside.
212 00:23:25.230 ⇒ 00:23:28.020 Demilade Agboola: Ideally, what we would want to do is we would want to have
213 00:23:28.360 ⇒ 00:23:36.269 Demilade Agboola: things that can be Shopify, Shopify, and then the rest would come from OMS data, so that’s kind of how we’ll merge everything together.
214 00:23:36.270 ⇒ 00:23:36.850 Emily Giant: Okay.
215 00:23:37.540 ⇒ 00:23:38.600 Emily Giant: Okay, cool.
216 00:23:38.950 ⇒ 00:23:45.500 Emily Giant: Alright, I’m trying to think if there’s anything else that I’m like, what’s going on here? But…
217 00:23:45.500 ⇒ 00:23:46.830 Demilade Agboola: Yeah, I mean, there was stuff about.
218 00:23:46.830 ⇒ 00:23:47.800 Emily Giant: Yeah.
219 00:23:48.160 ⇒ 00:23:52.089 Demilade Agboola: I can’t wait till we get, like, Tableau’s Items XF out of the way, because…
220 00:23:52.380 ⇒ 00:23:54.020 Emily Giant: Yeah, it’s Chip.
221 00:23:54.330 ⇒ 00:23:57.350 Demilade Agboola: Those errors over the, like, over the week.
222 00:23:57.700 ⇒ 00:23:58.880 Demilade Agboola: Past couple of weeks.
223 00:23:59.090 ⇒ 00:23:59.600 Demilade Agboola: Had the.
224 00:23:59.600 ⇒ 00:24:00.360 Emily Giant: Yeah.
225 00:24:00.650 ⇒ 00:24:04.620 Demilade Agboola: And then, just generally,
226 00:24:06.080 ⇒ 00:24:11.660 Demilade Agboola: you know, I think Perry felt some of the numbers of summer 2024 were, like, low.
227 00:24:12.650 ⇒ 00:24:13.520 Emily Giant: -Oh.
228 00:24:15.630 ⇒ 00:24:18.519 Demilade Agboola: I mean, we all kind of did, but maybe they’re just low.
229 00:24:18.760 ⇒ 00:24:22.159 Demilade Agboola: Yeah, she was in an AOV of, like, $40.
230 00:24:24.100 ⇒ 00:24:37.100 Emily Giant: Yeah, it does sound a little low, but if you’re using, like, vases and add-ons, that could easily… well, no, average order value. Yeah, that’s a little low, but…
231 00:24:39.020 ⇒ 00:24:42.619 Emily Giant: So that just happened with, like, the live data in Tableau?
232 00:24:44.150 ⇒ 00:24:51.139 Demilade Agboola: Yeah, I believe so. I’m trying to… I can’t remember. I think it was… was she… was it AOV? Was it… was it the… give me one second.
233 00:24:52.160 ⇒ 00:24:55.499 Demilade Agboola: I believe it… was it?
234 00:25:05.880 ⇒ 00:25:08.589 Demilade Agboola: Yes, the top line sales dash…
235 00:25:09.230 ⇒ 00:25:09.990 Emily Giant: Yeah.
236 00:25:12.470 ⇒ 00:25:13.959 Demilade Agboola: That’s… that’s Tableau, right?
237 00:25:14.770 ⇒ 00:25:16.370 Emily Giant: Yep, it sure is.
238 00:25:16.550 ⇒ 00:25:17.140 Demilade Agboola: Yeah.
239 00:25:17.870 ⇒ 00:25:24.449 Demilade Agboola: So, I just wanted us to get to a point where, like, we can replace it and, like, Perry feels confident, everyone.
240 00:25:25.370 ⇒ 00:25:27.080 Demilade Agboola: That’s part of why I said that.
241 00:25:27.690 ⇒ 00:25:28.620 Emily Giant: Yeah.
242 00:25:29.330 ⇒ 00:25:30.249 Demilade Agboola: So even if it’s low.
243 00:25:30.250 ⇒ 00:25:30.680 Emily Giant: Right.
244 00:25:30.850 ⇒ 00:25:34.899 Demilade Agboola: No, it’s low because it was low, not because it just seems to be low.
245 00:25:35.170 ⇒ 00:25:38.710 Emily Giant: Right, yeah, I think there’s gonna be a couple of those things that, like.
246 00:25:38.920 ⇒ 00:25:46.400 Emily Giant: It’ll be good to have me there to translate to her that, like, it’s because it was wrong in the past.
247 00:25:46.590 ⇒ 00:25:48.000 Emily Giant: And not because…
248 00:25:48.120 ⇒ 00:26:03.789 Emily Giant: you’re not building new tables that are correct. I think we’re gonna see some of that with revenue, unfortunately, but, like, we’ll be okay. The other piece that I’m, like, okay, wanna make sure I don’t lose sight of it is, like, carrier stuff.
249 00:26:04.010 ⇒ 00:26:12.610 Emily Giant: is… the shipping stuff, like, that’s all present in, like, fact order lines, right? Or fact orders?
250 00:26:15.130 ⇒ 00:26:16.560 Emily Giant: Because I know, yeah.
251 00:26:16.740 ⇒ 00:26:21.459 Demilade Agboola: I might need to double-check that. So, when you need shipping stuff, what are you referring to?
252 00:26:22.100 ⇒ 00:26:23.210 Demilade Agboola: what I… what exactly?
253 00:26:23.210 ⇒ 00:26:39.360 Emily Giant: what the carrier, yeah. Like, was it FedEx on track? Was it, like, bike career delivery? I think that, like, those… there might be separate needs, which aren’t in contract for you guys, so it’s okay. I just want to, like, keep my eye on, like, what is
254 00:26:39.720 ⇒ 00:26:55.200 Emily Giant: available to bring in versus what we still need to backfill with. Like, we had talked with Utam about, at the beginning of the engagement, like, the ability to bring in carrier pricing, so that it’s not having to be manually input. Like, right now.
255 00:26:55.610 ⇒ 00:27:08.310 Emily Giant: We have someone that, like, manually updates a spreadsheet with the average pricing every week for FedEx, and I know you’d worked with a company that, like, they set up a…
256 00:27:08.720 ⇒ 00:27:19.940 Emily Giant: some kind of integration where they were able to better estimate those prices, but, like, of course, I want to get revenue and subscriptions up and running first before we’re focusing on that, but, like, I just want to make sure that we have
257 00:27:20.100 ⇒ 00:27:30.070 Emily Giant: the base elements from Shopify, and if not, I can work on those tables, because right now, like, I’m gonna take all the ad hoc tickets that come in, but I was…
258 00:27:30.260 ⇒ 00:27:34.419 Emily Giant: mostly slated to work on historical subscriptions, but I can’t do that until
259 00:27:34.530 ⇒ 00:27:40.119 Emily Giant: the new version is, like, set up and approved, because I’ll wind up, like.
260 00:27:40.460 ⇒ 00:27:49.769 Emily Giant: creating a historical version that doesn’t align to the new table. So, I’m just trying to figure out where I can, like, jump in and help.
261 00:27:49.940 ⇒ 00:27:59.410 Emily Giant: So it sounds like I can do QA on, like, fact orders and fact order lines, make sure that those are up and running in Looker. I’ll connect all the Shopify product details to it.
262 00:27:59.520 ⇒ 00:28:05.000 Emily Giant: I think, like, that’s still kind of a missing piece. I’ll do QA on all of those.
263 00:28:05.440 ⇒ 00:28:18.270 Emily Giant: And then I can work on bringing in the OMS. Any information that’s still missing from OMS, like suborder ID, and line item ID, I can work on bringing those into
264 00:28:18.270 ⇒ 00:28:29.989 Emily Giant: the Shopify fulfillment tables, so that you can focus on, like, the logic, and I can backfill any of the, like, OMS-specific information that people are used to looking at, because it’s kind of, like.
265 00:28:30.880 ⇒ 00:28:32.319 Emily Giant: a pointless…
266 00:28:32.970 ⇒ 00:28:49.789 Emily Giant: thing. All of that OMS order ID, it’s just, like, a dash-generated ID, but it’s how stakeholders are used to looking at it. So there is a world where we, like, wean them off of that and use Shopify variant ID and order ID instead, but I’ll just see, like.
267 00:28:51.440 ⇒ 00:28:58.350 Emily Giant: how easy it is, or how, like, reliable it is, even, to use those Shopify fulfillment tables, if you think that would be helpful.
268 00:28:59.740 ⇒ 00:29:04.050 Demilade Agboola: Yeah, I mean, I think, like, long-term, being able to have
269 00:29:04.180 ⇒ 00:29:08.359 Demilade Agboola: One common thing that everyone is comfortable with is important.
270 00:29:08.560 ⇒ 00:29:12.550 Demilade Agboola: I think Shopify will be… Better?
271 00:29:13.070 ⇒ 00:29:17.349 Demilade Agboola: But I’m also a bit cautious about, like, locking in, because, like.
272 00:29:17.680 ⇒ 00:29:21.969 Demilade Agboola: if you move off Shopify, you know, you don’t want necessarily to change.
273 00:29:22.900 ⇒ 00:29:37.099 Demilade Agboola: that again, and go through that process, so there is that bit of concern in that regard. But yeah, I do feel like having… if there’s a way… like, that’s why I just wanted to know if there’s a way we could always tie it back to what they’re used to, that way, you know…
274 00:29:37.340 ⇒ 00:29:43.459 Demilade Agboola: we don’t have to change convention, and we can still get the benefits of having Shopify data.
275 00:29:44.410 ⇒ 00:29:53.329 Emily Giant: Okay, so I feel like, just because I’m so familiar with, like, all those numbers, not that you aren’t now, you are, that if I work on that piece.
276 00:29:53.760 ⇒ 00:30:00.379 Emily Giant: and you can just keep doing what you’re doing, we’ll meet in the middle. Does that sound plausible?
277 00:30:00.570 ⇒ 00:30:02.260 Demilade Agboola: Yeah, sounds good.
278 00:30:02.260 ⇒ 00:30:03.420 Emily Giant: Okay, cool.
279 00:30:04.000 ⇒ 00:30:08.810 Demilade Agboola: I do have… I have a pair I’m returning today for Facts or Borders.
280 00:30:10.290 ⇒ 00:30:12.909 Demilade Agboola: You can just take a look at that, and just kind of…
281 00:30:12.910 ⇒ 00:30:13.530 Emily Giant: Okay.
282 00:30:14.070 ⇒ 00:30:15.909 Demilade Agboola: off of that, so you don’t have to stuff it.
283 00:30:17.010 ⇒ 00:30:19.200 Emily Giant: Perfect. Alright, cool.
284 00:30:19.680 ⇒ 00:30:25.209 Emily Giant: Alrighty, well, I’ll let you go get some coffee. It’s probably that time.
285 00:30:25.210 ⇒ 00:30:27.869 Demilade Agboola: Yeah, I was literally about… about to get caught.
286 00:30:27.870 ⇒ 00:30:40.680 Emily Giant: Me too. I was like, let’s… wait, okay, before we break and go get our coffee, should I make tickets for these things? Because they’re kind of already ticketed, but not, like.
287 00:30:40.890 ⇒ 00:30:44.040 Emily Giant: Specifically, for me at least.
288 00:30:44.260 ⇒ 00:30:50.860 Demilade Agboola: Yeah, I think we might need to just groom the tickets we already have. I think we have multiple tickets, but just kind of, like, grooming instead.
289 00:30:51.570 ⇒ 00:30:55.720 Emily Giant: Okay, I’ll do that. I’ll just go in and do that, and then ping you in the ticket when it’s done.
290 00:30:55.720 ⇒ 00:30:59.750 Demilade Agboola: Okay, and also, I just wanted to say that there was… we also had some issues with products.
291 00:30:59.870 ⇒ 00:31:02.720 Demilade Agboola: Products, XF.
292 00:31:02.910 ⇒ 00:31:07.609 Demilade Agboola: I think I just saw that now, because I just saw… I had to fix that when you were gone, but that was…
293 00:31:07.940 ⇒ 00:31:16.720 Emily Giant: Oh, God. So we should be moving off of ProductsXF entirely, and using only, like, DIM… what’s it called?
294 00:31:16.720 ⇒ 00:31:17.590 Demilade Agboola: in products.
295 00:31:17.590 ⇒ 00:31:20.450 Emily Giant: DIM Product Union, I think?
296 00:31:21.340 ⇒ 00:31:25.350 Emily Giant: So I’ll work on, like, any… Sorry, what?
297 00:31:25.350 ⇒ 00:31:29.879 Demilade Agboola: I was gonna say, yeah, but there was… I can’t remember what the issue was.
298 00:31:30.440 ⇒ 00:31:35.390 Demilade Agboola: I know Perry brought that up, but, you know, like I said, we got things, we got things of…
299 00:31:36.210 ⇒ 00:31:45.489 Emily Giant: Oh, yeah, no, Zach told me, he was like, they spent most of the time working on ad hoc crap that came in. I was like, yep, that’s what happens, that’s my life. That’s why we hired him.
300 00:31:45.760 ⇒ 00:31:49.249 Emily Giant: Because all I can never do is keep up.
301 00:31:49.460 ⇒ 00:32:09.450 Emily Giant: So yeah, I totally get it, and so does Zach, it’s fine. Yeah, I remember, like, the third day, all of her, like, product categories were gone, so I just did, like, a really ugly, like, butterfly stitch to an old table, so she should have those now, but did something else happen with that after… it was probably, like.
302 00:32:10.250 ⇒ 00:32:12.790 Emily Giant: Thursday of the first week I was gone.
303 00:32:13.040 ⇒ 00:32:16.009 Demilade Agboola: Yeah, so on the 22nd, whichever is last week.
304 00:32:16.460 ⇒ 00:32:28.880 Demilade Agboola: Yep. She had an issue with a sheet and the product’s XF Explorer. It wasn’t running… had to run in a couple of days, so the thing she was updating in the sheet were not feeding into the dashboards.
305 00:32:28.880 ⇒ 00:32:29.980 Emily Giant: Oh, okay.
306 00:32:30.260 ⇒ 00:32:33.089 Demilade Agboola: So, I had to fix that.
307 00:32:33.550 ⇒ 00:32:35.100 Emily Giant: Ugh. Yeah.
308 00:32:37.390 ⇒ 00:32:38.749 Demilade Agboola: Yeah, but it was fun.
309 00:32:39.230 ⇒ 00:32:53.499 Emily Giant: Yeah, it… yeah, she didn’t have anything for me when I got back yesterday, so I was like, oh, okay, cool. Can you tag me in that conversation, just so I can make sure whatever you fix there, I also fix in, DIM Product Union?
310 00:32:54.760 ⇒ 00:32:56.739 Demilade Agboola: I would have to.
311 00:32:56.740 ⇒ 00:32:58.120 Emily Giant: Or maybe you already did.
312 00:32:58.530 ⇒ 00:32:59.220 Demilade Agboola: Okay. Yeah.
313 00:32:59.220 ⇒ 00:33:00.369 Emily Giant: I can look, too.
314 00:33:01.070 ⇒ 00:33:03.049 Demilade Agboola: So I think what happened was…
315 00:33:03.420 ⇒ 00:33:15.580 Demilade Agboola: Yeah, it’s been a minute, I run through so many things a day, I don’t always remember. Yeah. It was on the 23rd, it was a PR…
316 00:33:21.930 ⇒ 00:33:24.260 Demilade Agboola: Gotcha. So there was a change in…
317 00:33:24.450 ⇒ 00:33:27.999 Demilade Agboola: the nomenclature that wasn’t reflected in ProductsXF.
318 00:33:29.850 ⇒ 00:33:30.700 Emily Giant: Okay.
319 00:33:30.700 ⇒ 00:33:34.420 Demilade Agboola: That was… that was… I think, yeah, changed from…
320 00:33:34.920 ⇒ 00:33:38.670 Demilade Agboola: updated product type to Shopify product type. It was one of those things where you just.
321 00:33:38.670 ⇒ 00:33:39.700 Emily Giant: Yep.
322 00:33:39.700 ⇒ 00:33:40.710 Demilade Agboola: You know, what the…
323 00:33:40.710 ⇒ 00:33:41.300 Emily Giant: Yeah.
324 00:33:41.400 ⇒ 00:33:43.550 Demilade Agboola: was, and I think I changed that.
325 00:33:44.680 ⇒ 00:33:50.069 Emily Giant: Is it floral, it was getting in the air because floral didn’t exist, or something like that?
326 00:33:50.070 ⇒ 00:33:54.260 Demilade Agboola: It was updated product type that was there before, and now it was.
327 00:33:54.260 ⇒ 00:33:54.990 Emily Giant: Huh.
328 00:33:55.610 ⇒ 00:33:58.219 Demilade Agboola: It was now Shopify product type.
329 00:33:59.430 ⇒ 00:34:00.820 Emily Giant: Gotcha, okay.
330 00:34:00.820 ⇒ 00:34:04.179 Demilade Agboola: There’s a product XF old, and now there’s a product XF.
331 00:34:04.440 ⇒ 00:34:05.040 Demilade Agboola: diff those.
332 00:34:05.040 ⇒ 00:34:06.010 Emily Giant: Different.
333 00:34:06.010 ⇒ 00:34:08.840 Demilade Agboola: based off Shopify, and I think that’s where the error was come.
334 00:34:09.449 ⇒ 00:34:09.980 Demilade Agboola: So…
335 00:34:09.989 ⇒ 00:34:25.759 Emily Giant: Yep, yep, that makes total sense. I’ve noticed that, especially if there’s a PDT, when you do the content validator in Looker, it does not update PDTs, and that has caused a lot of errors that I wound up, like, ad hoc fixing, but yeah, that was…
336 00:34:25.949 ⇒ 00:34:37.569 Emily Giant: I’ll keep an eye out for that. If I change the name of anything, make sure that it’s updated in all reports, because the content validator does not 100% of the time catch all the instances where those things are used.
337 00:34:37.860 ⇒ 00:34:40.610 Demilade Agboola: Alright, let me just… I just entered PR now.
338 00:34:41.060 ⇒ 00:34:46.439 Demilade Agboola: Pr fix… So if you just want to have an idea of what broke…
339 00:34:46.449 ⇒ 00:34:48.399 Emily Giant: That’s what broke. Oh, yeah.
340 00:34:49.989 ⇒ 00:34:57.030 Demilade Agboola: I… It took me a longer time to figure out that was the… the cause.
341 00:34:57.880 ⇒ 00:35:12.289 Emily Giant: Oh, God, sorry. Especially Product Sense F, like, it’s such a piece… it’s like a turd. We need to just deprecate it after I figure… like, this won’t even be used, I’m sorry it took you so long, but I’m glad you fixed it.
342 00:35:12.540 ⇒ 00:35:17.690 Demilade Agboola: Yeah, well, it’s all good. So, like I said, we’re fixing things. The jobs are running better now.
343 00:35:17.840 ⇒ 00:35:18.830 Demilade Agboola: I’m working on.
344 00:35:18.830 ⇒ 00:35:20.490 Emily Giant: Yeah, way better.
345 00:35:20.490 ⇒ 00:35:26.379 Demilade Agboola: things I’m working on this, like, past week, or I have been working on is just…
346 00:35:26.700 ⇒ 00:35:29.250 Demilade Agboola: Running our jobs much, much better.
347 00:35:29.370 ⇒ 00:35:39.890 Demilade Agboola: I have… what’s the word? I have started settling down to, like, tackle them, incremental fixes.
348 00:35:40.110 ⇒ 00:35:48.659 Demilade Agboola: And just getting out the bloatware. Not everything needs to run on certain jobs, and just trying to ensure that we’re only running what needs to be run.
349 00:35:49.750 ⇒ 00:36:00.350 Emily Giant: Yeah, it’s been so much smoother. I… yeah, I looked at the Metaplane stuff when I got back, and I was like, damn, that’s going better, isn’t it? So, yeah, that’s great.
350 00:36:00.950 ⇒ 00:36:01.449 Demilade Agboola: So that’s all.
351 00:36:01.450 ⇒ 00:36:18.719 Emily Giant: Yeah, we’re getting there. I just, like, wanted to make sure. I got back yesterday, I was like, I don’t even know what I’m doing. I don’t even know what I’m doing right now. Like, I just need to talk to everyone and, like, figure this out, like, where we’re at and where support’s needed. But, I got you with, like, the suborder ID thing. I’ll work on that today.
352 00:36:18.750 ⇒ 00:36:25.419 Emily Giant: And hopefully, we’ll have that done, either, like, end of day today or midday tomorrow.
353 00:36:25.690 ⇒ 00:36:26.390 Demilade Agboola: Okay.
354 00:36:27.050 ⇒ 00:36:27.960 Demilade Agboola: Sounds good.
355 00:36:27.960 ⇒ 00:36:31.799 Emily Giant: All right, well, I will see you later at the meeting with Perry.
356 00:36:31.800 ⇒ 00:36:33.200 Demilade Agboola: Alright, Ben, sounds great.
357 00:36:33.730 ⇒ 00:36:35.030 Emily Giant: Alright, talk to you soon.
358 00:36:35.250 ⇒ 00:36:35.950 Demilade Agboola: Listen.