Meeting Title: Urban Stems Data Debugging Session Date: 2025-11-17 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:00:45.930 ⇒ 00:00:47.010 Emily Giant: Hey, hey.
2 00:00:47.720 ⇒ 00:00:49.230 Demilade Agboola: Hi, Emily, how are you?
3 00:00:49.900 ⇒ 00:00:54.809 Emily Giant: itchy. I have poison ivy again, because I was working in the yard all weekend. How was your weekend?
4 00:00:55.290 ⇒ 00:01:01.470 Demilade Agboola: I was pretty okay. I don’t know, not much really happened, to be honest.
5 00:01:02.190 ⇒ 00:01:04.290 Emily Giant: Sometimes, it’d be like that.
6 00:01:04.360 ⇒ 00:01:05.280 Demilade Agboola: Yeah.
7 00:01:05.280 ⇒ 00:01:10.439 Emily Giant: One second, I filled up a huge glass of water for myself, and then left it in the kitchen. I’ll be right back.
8 00:01:22.890 ⇒ 00:01:27.300 Emily Giant: Oh, God. Well, hopefully this isn’t an indication of my day. It was just behind my computer.
9 00:01:28.850 ⇒ 00:01:41.389 Emily Giant: I ran in there and was like, where is it? And then I was walking back in the room and saw it just, like, blocked by my laptop screen. Okay, so I did a lot of work over the weekend, just, like, debugging.
10 00:01:41.570 ⇒ 00:01:54.619 Emily Giant: But, of course, it led to, like, so many upstream fixes, so I won’t deploy any of those during the day. But, yeah, there were a lot of issues in historical revenue, and by no fault of
11 00:01:55.270 ⇒ 00:01:59.260 Emily Giant: Anything, but that the data’s super weird and requires, like.
12 00:01:59.540 ⇒ 00:02:02.550 Emily Giant: Logic after logic after logic to get it all there?
13 00:02:03.030 ⇒ 00:02:07.070 Emily Giant: But I can show you what I was outlining in that,
14 00:02:08.030 ⇒ 00:02:10.640 Emily Giant: In the, chat just now.
15 00:02:11.410 ⇒ 00:02:13.280 Demilade Agboola: Okay, very helpful.
16 00:02:13.490 ⇒ 00:02:14.610 Emily Giant: Okay.
17 00:02:17.460 ⇒ 00:02:19.620 Emily Giant: So, let me pull up dbt.
18 00:02:20.880 ⇒ 00:02:22.509 Emily Giant: Can you see by DBT?
19 00:02:24.080 ⇒ 00:02:25.180 Demilade Agboola: Yes.
20 00:02:25.590 ⇒ 00:02:27.869 Demilade Agboola: Well, more than, but… yeah.
21 00:02:27.870 ⇒ 00:02:29.599 Emily Giant: Oh, wrong screen then, one sec.
22 00:02:35.630 ⇒ 00:02:36.450 Emily Giant: Okay.
23 00:02:37.330 ⇒ 00:02:50.249 Emily Giant: Let me save this real quick. So, I’ve just been, like, doing QA, so I can find, like, every little lingering thing. Essentially, in the OMS…
24 00:02:50.850 ⇒ 00:02:52.410 Emily Giant: Let me save this all.
25 00:02:54.410 ⇒ 00:03:01.079 Emily Giant: In this model, the logic was to, like, override any
26 00:03:01.150 ⇒ 00:03:16.520 Emily Giant: not first suborder, so that the revenue didn’t get redistributed to the second and so on suborder. And for all the, like, actual revenue-producing second sub-orders, which doesn’t happen… it happens, actually, like, quite a bit.
27 00:03:17.340 ⇒ 00:03:24.369 Emily Giant: So I had to remove that logic, and then I noticed, like, when I was doing QA here… let’s see if this even builds right now…
28 00:03:24.990 ⇒ 00:03:33.550 Emily Giant: That a lot of the deleted line items were still getting, revenue redistributed to them?
29 00:03:33.880 ⇒ 00:03:39.829 Emily Giant: And so, I was like, okay, looking into those orders, and then noticing that they actually were…
30 00:03:40.040 ⇒ 00:03:54.290 Emily Giant: why is this failing? It was not failing, like, 10 minutes ago. But, was noticing that they weren’t, like, properly getting the strikethrough, and they were still getting revenue, so I had to pull in this old model, stacks here near as…
31 00:03:55.000 ⇒ 00:04:04.270 Emily Giant: Okay, so I had to go into this forced upgrade model, or the staging line item tags.
32 00:04:04.540 ⇒ 00:04:10.579 Emily Giant: And, this is a model where, like, it says what happened to orders.
33 00:04:10.930 ⇒ 00:04:18.660 Emily Giant: And so I pulled in the component number, since it’s all, like, OMS data, and, was able to, like.
34 00:04:19.390 ⇒ 00:04:29.679 Emily Giant: see where items that were deleted were not getting, like, properly deleted in the live model. So it’s called,
35 00:04:29.930 ⇒ 00:04:41.439 Emily Giant: component is deleted, and then, you can kind of glean what happened, like, whether it was add line item to suborder, or remove line item from suborder. So, I went back into this
36 00:04:41.680 ⇒ 00:04:44.190 Emily Giant: Redistribution model and tied in
37 00:04:44.480 ⇒ 00:04:50.589 Emily Giant: That to say, like, if the line item is marked as deleted in components, or…
38 00:04:50.770 ⇒ 00:04:57.660 Emily Giant: It’s actually a forced upgrade and was removed from the order to more accurately, like, redistribute the revenue.
39 00:05:00.050 ⇒ 00:05:03.890 Emily Giant: hold on, I don’t know what the deal is right now. I think I was in the middle of, like.
40 00:05:04.020 ⇒ 00:05:12.579 Emily Giant: Fixing something, and then didn’t… didn’t finish doing it, but, does that make sense so far?
41 00:05:13.390 ⇒ 00:05:15.130 Demilade Agboola: Yes, that makes sense so far.
42 00:05:15.130 ⇒ 00:05:21.389 Emily Giant: And then, okay, so it’s gonna be a huge PR, but, like, it just is what it is. I will test it till the ends of the earth.
43 00:05:21.520 ⇒ 00:05:35.310 Emily Giant: But instead of the fact legacy order components, which isn’t really the same thing as, the Mart Unified, I built a new model that’s almost like it, but is more aligned with, like.
44 00:05:35.420 ⇒ 00:05:37.649 Emily Giant: exactly what Order Lines is.
45 00:05:38.020 ⇒ 00:05:44.590 Emily Giant: And it’s not gonna run now, because this one’s not gonna run, but I can go into dbt and show you, like, what it looks like. So…
46 00:05:44.890 ⇒ 00:05:51.280 Demilade Agboola: Also, I was gonna say, part of the reasons why, for instance, I use the first order
47 00:05:51.520 ⇒ 00:05:55.389 Demilade Agboola: thingy, is that, the first order
48 00:05:55.540 ⇒ 00:05:58.110 Demilade Agboola: Kinda to be the revenue generating.
49 00:05:58.140 ⇒ 00:06:00.939 Emily Giant: And subsequently, there were, like, food deliveries.
50 00:06:01.570 ⇒ 00:06:03.910 Demilade Agboola: Yeah. Shopify, the way Shopify groups it.
51 00:06:04.930 ⇒ 00:06:11.470 Emily Giant: it’s not uncommon, but it’s uncommon enough that I had to pull in
52 00:06:11.620 ⇒ 00:06:18.899 Emily Giant: the re-delivery… staging OMS active re-delivery is the most used model in dbt, to, like.
53 00:06:19.200 ⇒ 00:06:29.449 Emily Giant: just say, it’s gotta be a re-delivery. Instead of assuming it, now it’s, like, definitive. Like, if it’s in the list, then do this, but if not, you can redistribute it.
54 00:06:29.740 ⇒ 00:06:35.669 Emily Giant: to the other suborders, but it makes sense that, like, you probably would have seen a ton of Dash 2 orders that were re-deliveries.
55 00:06:36.330 ⇒ 00:06:41.910 Emily Giant: Lamar, so… I don’t think it’s like that in… the current…
56 00:06:43.780 ⇒ 00:06:47.479 Emily Giant: revenue, though, is it? Because, like, re-deliveries are generally…
57 00:06:47.880 ⇒ 00:06:52.610 Emily Giant: or not generally, they’re always a completely different order in Shopify.
58 00:06:52.610 ⇒ 00:06:54.120 Demilade Agboola: It’s just always there.
59 00:06:54.810 ⇒ 00:06:58.650 Demilade Agboola: Yeah, that’s… that’s why… that’s why the logic kind of worked.
60 00:06:58.810 ⇒ 00:06:59.740 Demilade Agboola: The…
61 00:07:03.900 ⇒ 00:07:12.339 Emily Giant: Yeah, like, if you were to pull a handful of suborders, I can see how those might all be Dash 2 re-deliveries, but there are just enough that aren’t.
62 00:07:12.380 ⇒ 00:07:24.770 Emily Giant: that, it’s just a little more exact, to just reference the re-delivery model specifically. So with this, because we had all of the, like.
63 00:07:25.610 ⇒ 00:07:36.639 Emily Giant: The order total, the, line item subtotal, the line level discount, which we should chat through the discount thing,
64 00:07:37.040 ⇒ 00:07:40.169 Emily Giant: Just so that, like, it is what the team expects.
65 00:07:40.600 ⇒ 00:07:48.229 Emily Giant: I made some upstream models that mirror exactly what order line items does, so that, like.
66 00:07:48.730 ⇒ 00:07:59.579 Emily Giant: you can get the item shipping amount, you can get the item tax amount, and it does it at that, like, component level, and then aggregates into the order. And that way, like.
67 00:07:59.830 ⇒ 00:08:09.380 Emily Giant: all of the stuff in Mart Unified isn’t null. It can, like, roll up into that order total, but that,
68 00:08:09.730 ⇒ 00:08:18.260 Emily Giant: what this required, you’re gonna be like, you did not have a weekend, but I still managed to get raging poison ivy, so I definitely did other stuff but work.
69 00:08:19.150 ⇒ 00:08:27.079 Emily Giant: So, had to rework some of the subscription models to, like, set the revenue only on the floral.
70 00:08:28.280 ⇒ 00:08:42.470 Emily Giant: because in historicals, it was still being weird, since it was only at the order level. It was, like, as it got split out into line items, it was still showing revenue against, like, bases and candles and whatnot. But…
71 00:08:43.340 ⇒ 00:08:44.440 Emily Giant: Where are the…
72 00:08:44.560 ⇒ 00:08:51.439 Emily Giant: The big ones that I added, which were, like, part of what I was supposed to be doing, is the…
73 00:08:52.120 ⇒ 00:08:57.100 Emily Giant: the forced upgrades to get the line items, I did int OMS refunds.
74 00:08:58.030 ⇒ 00:09:02.539 Emily Giant: So that you could, like, Get the net totals correctly.
75 00:09:02.940 ⇒ 00:09:20.699 Emily Giant: And that one… it’s essentially the exact same thing as the revenue redistribution, but uses staging totals and pulls the refunds to break it into the component parts of that refund, so that you can see, like, what tax was refunded, what shipping was refunded.
76 00:09:21.300 ⇒ 00:09:24.650 Emily Giant: So, and this one was, like, it’s pretty straightforward.
77 00:09:24.850 ⇒ 00:09:28.729 Emily Giant: But, let’s see if it lets me build anything while I have that error.
78 00:09:30.750 ⇒ 00:09:44.190 Emily Giant: And then I did the same thing for deductions. So the major staging model that I had to rework was staging totals, because it was never correct. Like, I don’t know what the hell was up with that model, but, like.
79 00:09:44.360 ⇒ 00:09:52.350 Emily Giant: over time, I think Steven just had added so much stuff to it that, like, it no longer…
80 00:09:52.560 ⇒ 00:09:56.400 Emily Giant: It was just never, like, Perfect.
81 00:09:56.510 ⇒ 00:10:03.460 Emily Giant: And, now, like, discounts, promos… And,
82 00:10:03.910 ⇒ 00:10:07.990 Emily Giant: What category they should actually be in are, like.
83 00:10:08.360 ⇒ 00:10:13.389 Emily Giant: to… to the letter. So, promo codes…
84 00:10:13.690 ⇒ 00:10:22.299 Emily Giant: Those are, like, if there is… here, I’ll bring up staging totals after this pulls up and show you, because I think we need to split these out in,
85 00:10:22.600 ⇒ 00:10:33.100 Emily Giant: the… current data. Promos are, like, if there’s a code applied, Or, like, some kind of… customer…
86 00:10:33.580 ⇒ 00:10:44.749 Emily Giant: campaign thing, whereas discounts are, like, employee discounts, or, like, long-term… I think we talked about this, like, a very long time ago, but they’re, like, the long-form
87 00:10:45.210 ⇒ 00:10:49.419 Emily Giant: forever discounts, because you have.
88 00:10:50.800 ⇒ 00:10:56.549 Emily Giant: something applied to your profile, and it’s not, like, a website-facing thing.
89 00:10:57.440 ⇒ 00:11:05.820 Emily Giant: But this… And I still need to do some QA for non-full refunds.
90 00:11:06.570 ⇒ 00:11:18.290 Emily Giant: But it’ll take an order that has a refund, and then split it into its pieces, and apply the refund and the reason for the refund to, like, the item that actually caused it.
91 00:11:18.730 ⇒ 00:11:21.660 Emily Giant: But… Let me find one with, like…
92 00:11:22.030 ⇒ 00:11:29.640 Emily Giant: Here. So, for example, this is the floral on the order. This was the price that the customer paid as a subtotal.
93 00:11:30.660 ⇒ 00:11:33.069 Emily Giant: And then, the refunded amount.
94 00:11:33.670 ⇒ 00:11:35.300 Emily Giant: That’s for the whole order.
95 00:11:35.730 ⇒ 00:11:39.539 Emily Giant: And then it will show the component refund. So, like.
96 00:11:39.990 ⇒ 00:11:43.490 Emily Giant: At the end of the day, this is what was refunded.
97 00:11:43.720 ⇒ 00:11:47.660 Emily Giant: For the floral, this is what was refunded for…
98 00:11:48.050 ⇒ 00:12:02.820 Emily Giant: the, the vase, and the total of it will equal the order total that they paid. But you can see it, like, each progression, like, this is how much the refund was… or the promo was refunded, this is how much tax was refunded.
99 00:12:03.000 ⇒ 00:12:07.180 Emily Giant: And then shipping. So it just splits all of the…
100 00:12:07.960 ⇒ 00:12:16.450 Emily Giant: pieces of the refund into chunks, so that if anyone wanted to see, like, how much shipping we refunded, they can, instead of just the, like.
101 00:12:16.750 ⇒ 00:12:18.369 Emily Giant: the item itself.
102 00:12:19.810 ⇒ 00:12:23.009 Demilade Agboola: Okay, I mean, they all sum up to the same amount.
103 00:12:23.010 ⇒ 00:12:25.200 Emily Giant: Yeah, there’s a… there’s a test in there.
104 00:12:26.310 ⇒ 00:12:34.589 Demilade Agboola: Okay, because the item here was 60, so I’m just curious if that works.
105 00:12:34.960 ⇒ 00:12:38.649 Emily Giant: It’s 60 AD2 plus 13.
106 00:12:39.480 ⇒ 00:12:42.390 Emily Giant: And then, this is without shipping.
107 00:12:42.790 ⇒ 00:12:44.600 Emily Giant: So that’s just the line item.
108 00:12:44.840 ⇒ 00:12:49.530 Demilade Agboola: Yeah, but I think, wasn’t the value of that individual line $55?
109 00:12:49.810 ⇒ 00:12:55.000 Emily Giant: a subtotal. So that’s without promos. So, you would need to, like.
110 00:12:55.610 ⇒ 00:13:02.999 Emily Giant: Do all of the allowances and deductions on it before saying the line item refunded total.
111 00:13:03.940 ⇒ 00:13:11.850 Emily Giant: So, like, this is Yeah, it’s the subtotal minus promos, and shipping.
112 00:13:12.630 ⇒ 00:13:15.150 Emily Giant: And, credits.
113 00:13:15.750 ⇒ 00:13:18.110 Emily Giant: plus… Tax.
114 00:13:20.100 ⇒ 00:13:20.980 Demilade Agboola: Okay.
115 00:13:21.690 ⇒ 00:13:23.219 Emily Giant: So, this is, like.
116 00:13:23.220 ⇒ 00:13:24.420 Demilade Agboola: But what was the puzzle?
117 00:13:24.420 ⇒ 00:13:25.720 Emily Giant: Sorry, go ahead.
118 00:13:25.720 ⇒ 00:13:29.549 Demilade Agboola: What’s the price of the amount? What’s the original price of the amount?
119 00:13:29.960 ⇒ 00:13:36.910 Emily Giant: It, the original price… was 55 as a line item total, so if I pull up the order…
120 00:13:52.340 ⇒ 00:13:58.789 Emily Giant: 74.41 is the…
121 00:13:59.370 ⇒ 00:14:08.460 Emily Giant: Refunded total, so these are the subtotal items, and then there was a $15 shipping charge, which got refunded, and then
122 00:14:08.760 ⇒ 00:14:16.889 Emily Giant: A $13 remove from the The subtotal. So, the two line items.
123 00:14:17.580 ⇒ 00:14:27.199 Emily Giant: If I go back to DBT, Let’s, should equal, 7410.
124 00:14:28.410 ⇒ 00:14:29.150 Demilade Agboola: Yeah.
125 00:14:40.460 ⇒ 00:14:42.800 Emily Giant: Alright, this is way too many, hold on.
126 00:14:47.960 ⇒ 00:14:51.539 Emily Giant: Alright, so this order we were looking at because it has 2.
127 00:14:52.900 ⇒ 00:15:01.290 Emily Giant: So if I go to the item refunded total… So that is… with shipping. Here, it’s $74.09.
128 00:15:01.510 ⇒ 00:15:05.050 Emily Giant: So, essentially, 7410.
129 00:15:05.670 ⇒ 00:15:06.380 Demilade Agboola: You know.
130 00:15:09.020 ⇒ 00:15:13.189 Emily Giant: So, I can write in these definitions in the YAML also.
131 00:15:13.730 ⇒ 00:15:20.079 Emily Giant: But… Yeah, so this one seems to check out. I did a bunch of QA on it.
132 00:15:21.530 ⇒ 00:15:25.890 Emily Giant: But I thought that that would be a better vantage point,
133 00:15:26.440 ⇒ 00:15:31.869 Emily Giant: To work with from refunds, since that’s pretty much how you have it split out in order line items.
134 00:15:32.410 ⇒ 00:15:33.380 Demilade Agboola: And yeah.
135 00:15:34.730 ⇒ 00:15:40.010 Emily Giant: And then I did… it’s almost the exact same model, just not for refunds.
136 00:15:41.140 ⇒ 00:15:48.240 Emily Giant: On deductions, because there were no deductions listed out prior to… Order line items.
137 00:15:49.560 ⇒ 00:15:53.650 Demilade Agboola: So, deductions here are the… Promos, or…
138 00:15:53.650 ⇒ 00:15:54.570 Emily Giant: Yeah.
139 00:15:56.310 ⇒ 00:15:58.330 Emily Giant: Promos, tax, shipping.
140 00:15:58.660 ⇒ 00:16:08.300 Emily Giant: So anything that would need to be split out from the subtotal, I have in this model, and it’s the same logic as the revenue redistribution.
141 00:16:08.480 ⇒ 00:16:13.510 Emily Giant: So… Let’s… Preview it.
142 00:16:18.680 ⇒ 00:16:20.389 Emily Giant: So, it says the price.
143 00:16:22.860 ⇒ 00:16:31.880 Emily Giant: And then breaks it down to the tax. The… and this is, like, for the order total, but then it has the line item total tax here.
144 00:16:32.440 ⇒ 00:16:39.519 Emily Giant: And then, line item shipping, line item order total should end up being $8,508.
145 00:16:41.230 ⇒ 00:16:43.659 Emily Giant: Which… Pretty close.
146 00:16:43.780 ⇒ 00:16:45.890 Emily Giant: It’s, like, within a cent.
147 00:16:49.090 ⇒ 00:16:54.169 Emily Giant: But that way… It aligns with them better.
148 00:16:54.730 ⇒ 00:17:03.360 Emily Giant: fact revenue model that is coming from Shopify. So, I just wanted it to be, like, a very unified look across orders and time.
149 00:17:03.610 ⇒ 00:17:10.540 Emily Giant: And then, instead of using, fact legacy order components.
150 00:17:10.660 ⇒ 00:17:20.749 Emily Giant: we’ll use fact suborder revenue, and I can switch that out into the MART, but this is just building the model prior to, like, unioning it in that MART unified view.
151 00:17:21.510 ⇒ 00:17:23.839 Demilade Agboola: Oh, okay, gotcha, gotcha.
152 00:17:23.849 ⇒ 00:17:25.979 Emily Giant: So it’s a lot of junk, but, like.
153 00:17:26.119 ⇒ 00:17:29.269 Emily Giant: At the end of the day, it’ll make it a lot more one-to-one.
154 00:17:29.509 ⇒ 00:17:37.619 Emily Giant: And this data just has so many problems that, Shopify doesn’t. The one thing that…
155 00:17:38.059 ⇒ 00:17:44.539 Emily Giant: we don’t have an either model that I know people are going to want, or I need to look into…
156 00:17:44.639 ⇒ 00:17:49.909 Emily Giant: order line items, too. For the SKU, in…
157 00:17:50.519 ⇒ 00:17:58.729 Emily Giant: Our prior model, it has, like, the piece component, which is the, like, granular level skew.
158 00:17:59.089 ⇒ 00:18:00.609 Emily Giant: That was sent.
159 00:18:00.839 ⇒ 00:18:05.619 Emily Giant: And then the quantity. And, there’s also, like.
160 00:18:06.200 ⇒ 00:18:09.520 Demilade Agboola: What do you mean? Isn’t that the product SKU?
161 00:18:10.530 ⇒ 00:18:16.789 Emily Giant: Kind of. There’s component SKUs, and then there’s, like.
162 00:18:17.270 ⇒ 00:18:29.749 Emily Giant: the customer-facing. There’s the firecracker, and then there’s triple the firecracker. The component of triple the firecracker is just a single firecracker times three. But then there’s the, like.
163 00:18:30.080 ⇒ 00:18:31.330 Emily Giant: bundled.
164 00:18:31.790 ⇒ 00:18:38.470 Emily Giant: product, which is 1 double the firecracker quantity 1. So in the old model, we have that.
165 00:18:38.780 ⇒ 00:18:43.239 Emily Giant: And for the new one, We only have…
166 00:18:43.590 ⇒ 00:18:47.330 Emily Giant: what I think might be just, like, double the firecracker times one.
167 00:18:50.080 ⇒ 00:18:50.960 Demilade Agboola: Gotcha.
168 00:18:51.580 ⇒ 00:18:52.270 Emily Giant: Yeah.
169 00:18:53.020 ⇒ 00:19:02.689 Emily Giant: But there is… I saw something, especially for bundles, I don’t think it’s gonna be that hard once all the numbers are there, to pull that.
170 00:19:03.320 ⇒ 00:19:16.689 Emily Giant: and there is a column that will say the bundle SKU if it is part of a bundle in Shopify. I forget what model it’s in, but once I find that, like, that will be the easy-to-pull-out bundle SKU.
171 00:19:16.920 ⇒ 00:19:26.369 Emily Giant: But then, I’ve got to figure out… or not even figure out, because it’s already done in the old model, the, like, parent SKU,
172 00:19:26.880 ⇒ 00:19:30.319 Emily Giant: to add in here from the DIM union line items model.
173 00:19:30.950 ⇒ 00:19:31.730 Demilade Agboola: Okay.
174 00:19:31.730 ⇒ 00:19:35.809 Emily Giant: So, that’s, like, the last piece of this that I need to work on.
175 00:19:36.020 ⇒ 00:19:44.870 Emily Giant: But do you want to talk about promos and discounts? Because I know that that was, like, one thing that actually has to be updated in the current Mart.
176 00:19:47.480 ⇒ 00:19:54.210 Demilade Agboola: So right now, it’s just… it appears we’re using, like, everything is a discount from Shopify.
177 00:19:55.440 ⇒ 00:19:57.369 Demilade Agboola: So it’s hard to suss out.
178 00:19:58.570 ⇒ 00:20:01.419 Emily Giant: Yeah, so it’s hard to suss out, because, like, everything, like.
179 00:20:01.420 ⇒ 00:20:03.890 Demilade Agboola: comes in. Like, I’m using everything as a discount.
180 00:20:05.780 ⇒ 00:20:12.350 Demilade Agboola: I’m guessing the difference between a promo and a discount would be the use of a certain promo code, right?
181 00:20:12.730 ⇒ 00:20:15.030 Emily Giant: Yeah, it would be, like, a customer…
182 00:20:15.350 ⇒ 00:20:17.920 Emily Giant: A tag in a customer profile.
183 00:20:20.120 ⇒ 00:20:21.130 Emily Giant: So, like…
184 00:20:21.130 ⇒ 00:20:24.419 Demilade Agboola: So the disc for the promo will be tagging the customer profile.
185 00:20:25.860 ⇒ 00:20:33.739 Emily Giant: I believe so. But, I can definitely… Validate that.
186 00:20:33.900 ⇒ 00:20:36.479 Emily Giant: So if I pull everything from
187 00:20:37.680 ⇒ 00:20:41.869 Emily Giant: analytics. I’m just gonna pull any order that I’ve ever placed.
188 00:20:42.010 ⇒ 00:20:46.340 Emily Giant: From… Act. Order.
189 00:20:47.120 ⇒ 00:20:48.420 Emily Giant: Line items.
190 00:20:59.950 ⇒ 00:21:04.909 Emily Giant: Is there, like, customer email in this? I can look up my Shopify ID.
191 00:21:05.020 ⇒ 00:21:05.900 Emily Giant: But…
192 00:21:11.030 ⇒ 00:21:11.930 Emily Giant: Okay, shh.
193 00:21:14.620 ⇒ 00:21:16.159 Emily Giant: Shopify order ID.
194 00:21:21.650 ⇒ 00:21:25.890 Emily Giant: Alright, well, I’ll just… look in Shopify and pull one of my order numbers.
195 00:21:40.240 ⇒ 00:21:44.159 Emily Giant: Looks like I’ve got a couple of profiles going on here, okay.
196 00:21:44.330 ⇒ 00:21:46.230 Emily Giant: Gotta merge those bad boys.
197 00:21:46.520 ⇒ 00:21:53.100 Emily Giant: Okay, so… Don’t remember that, but… I guess I did.
198 00:21:53.660 ⇒ 00:21:54.590 Emily Giant: Oh.
199 00:21:55.920 ⇒ 00:21:58.640 Emily Giant: Okay, that’s really old.
200 00:22:00.660 ⇒ 00:22:01.710 Emily Giant: Hold on.
201 00:22:16.400 ⇒ 00:22:19.090 Emily Giant: Oh my god, that’s like 4 jobs ago.
202 00:22:22.240 ⇒ 00:22:25.260 Demilade Agboola: I mean, you… it seemed you liked Oren Stems.
203 00:22:25.500 ⇒ 00:22:26.029 Demilade Agboola: for food.
204 00:22:26.030 ⇒ 00:22:28.120 Emily Giant: Yeah, from afar.
205 00:22:28.250 ⇒ 00:22:28.790 Demilade Agboola: Yeah.
206 00:22:28.790 ⇒ 00:22:33.679 Emily Giant: I’ll go ahead and say I probably had no idea that I was even actually,
207 00:22:33.970 ⇒ 00:22:39.489 Emily Giant: ordering from Urban Stems. When I did that, I was probably just panicking that I missed someone’s birthday.
208 00:22:40.520 ⇒ 00:22:41.770 Emily Giant: Where…
209 00:22:54.320 ⇒ 00:23:01.800 Emily Giant: Okay, so I want to see where the discount… okay, so line total amount… Incredibly cheap.
210 00:23:03.060 ⇒ 00:23:08.449 Emily Giant: So we’ve got total discount is $67.74.
211 00:23:10.420 ⇒ 00:23:14.539 Emily Giant: Which, employee discount, Employee discount shipping.
212 00:23:15.210 ⇒ 00:23:16.090 Demilade Agboola: Yeah. Yep.
213 00:23:16.410 ⇒ 00:23:26.090 Emily Giant: And then, whatever the hell that is. Oh, probably, like, a loyalty points code. Which, I don’t know where they want those to be. I don’t know if they want that to be a discount or a promo. I’m…
214 00:23:26.830 ⇒ 00:23:32.380 Emily Giant: just not sure. They might even want it to be its own column. But, like, all of these things…
215 00:23:32.490 ⇒ 00:23:39.180 Emily Giant: Should be classified under discount, as opposed to… Promo.
216 00:23:39.880 ⇒ 00:23:46.239 Demilade Agboola: I thought promo was… The tag on the customer, discount was their one-time use.
217 00:23:47.710 ⇒ 00:23:48.529 Demilade Agboola: Am I mixing it?
218 00:23:48.530 ⇒ 00:23:51.909 Emily Giant: Other way around. I think we actually have an article.
219 00:23:52.490 ⇒ 00:23:54.500 Emily Giant: In Confluence.
220 00:24:07.190 ⇒ 00:24:08.700 Emily Giant: Excuse me!
221 00:24:09.620 ⇒ 00:24:15.300 Emily Giant: I didn’t really sleep because I was up scratching my legs the whole night.
222 00:24:16.040 ⇒ 00:24:17.790 Emily Giant: Discount promo.
223 00:24:24.160 ⇒ 00:24:24.900 Emily Giant: Yeah.
224 00:24:25.440 ⇒ 00:24:26.270 Emily Giant: Okay.
225 00:24:27.800 ⇒ 00:24:36.279 Emily Giant: Current discounts and subscription. Customer can redeem loyalty points. These discounts are now tracked separately from promotions. Okay. So, Yachtpo.
226 00:24:37.430 ⇒ 00:24:40.799 Emily Giant: And then, prepaid subscriptions, discounts are null.
227 00:24:41.180 ⇒ 00:24:48.509 Emily Giant: promo is… Codes, so these discounts are temporarily available to the public, applied at checkout.
228 00:24:48.820 ⇒ 00:24:52.629 Emily Giant: Discount is a permanent customer-specific discount.
229 00:24:52.770 ⇒ 00:24:56.539 Emily Giant: That don’t expire and are not available to the general public.
230 00:24:57.000 ⇒ 00:25:00.220 Emily Giant: Examples include investor codes and employee discounts.
231 00:25:00.790 ⇒ 00:25:01.700 Demilade Agboola: Okay.
232 00:25:01.700 ⇒ 00:25:03.270 Emily Giant: Let me share this with you.
233 00:25:06.180 ⇒ 00:25:09.110 Demilade Agboola: But I think the next question is if, when you look at the…
234 00:25:10.160 ⇒ 00:25:12.350 Demilade Agboola: When you look at the Shopify data.
235 00:25:14.390 ⇒ 00:25:16.410 Demilade Agboola: There isn’t necessarily a flag for that.
236 00:25:17.390 ⇒ 00:25:20.230 Emily Giant: Yeah, I think I’ll have to, like, parse it out.
237 00:25:21.030 ⇒ 00:25:21.899 Demilade Agboola: Are you scared?
238 00:25:21.900 ⇒ 00:25:23.020 Emily Giant: table.
239 00:25:28.480 ⇒ 00:25:29.150 Emily Giant: Huh.
240 00:25:46.070 ⇒ 00:25:49.220 Emily Giant: Where… Order.
241 00:26:11.490 ⇒ 00:26:12.270 Emily Giant: Okay.
242 00:26:12.870 ⇒ 00:26:15.730 Emily Giant: ShopMoney445.
243 00:26:19.600 ⇒ 00:26:25.629 Emily Giant: Amount 44.5. So… These, interestingly, did.
244 00:26:26.180 ⇒ 00:26:28.330 Emily Giant: Come off as separate discount lines.
245 00:26:28.870 ⇒ 00:26:33.580 Emily Giant: I don’t see the $18 shipping discount, though.
246 00:26:33.750 ⇒ 00:26:39.699 Demilade Agboola: Yeah, but also, like, how… is there a flag? Can you… can I just look at the… is there a flag for what…
247 00:26:40.050 ⇒ 00:26:44.579 Demilade Agboola: Because it’s not really about, like, the different lines, it’s about knowing what the different lines represent.
248 00:26:45.100 ⇒ 00:26:47.369 Emily Giant: Right, that’s what I gotta look in this, like…
249 00:26:47.470 ⇒ 00:26:49.620 Emily Giant: If there’s some kind of status.
250 00:26:49.620 ⇒ 00:26:50.969 Demilade Agboola: Can you stretched out a bit?
251 00:26:51.230 ⇒ 00:26:54.509 Emily Giant: Yeah, it won’t let me do it in mode, so I’m gonna paste it in here.
252 00:27:02.450 ⇒ 00:27:05.619 Emily Giant: shop money amount currency code US dollars…
253 00:27:08.810 ⇒ 00:27:10.860 Emily Giant: That looks the same.
254 00:27:11.080 ⇒ 00:27:13.670 Emily Giant: So, I think the next would be…
255 00:27:14.180 ⇒ 00:27:17.690 Emily Giant: Like, is there a promo code applied?
256 00:27:17.850 ⇒ 00:27:25.379 Emily Giant: like, discount allocations may not be the right table, because these are both not promos.
257 00:27:25.780 ⇒ 00:27:32.489 Emily Giant: I wonder what a promo looks like in this table. It will probably have, like, a code to it, so…
258 00:27:33.030 ⇒ 00:27:39.180 Emily Giant: I mean, nobody orders from Urban Stems without a discount, so… let’s just find an order.
259 00:27:42.770 ⇒ 00:27:44.560 Emily Giant: Orders…
260 00:27:48.820 ⇒ 00:27:50.500 Emily Giant: This one looks discounty.
261 00:27:53.050 ⇒ 00:27:54.120 Emily Giant: Yep, okay.
262 00:28:18.190 ⇒ 00:28:21.209 Emily Giant: I wonder if it’s too new. They just placed that.
263 00:28:25.830 ⇒ 00:28:27.659 Demilade Agboola: But yeah, that’s pretty new.
264 00:28:27.950 ⇒ 00:28:35.150 Emily Giant: Yeah, let me do… Well, let me just, do this.
265 00:28:35.340 ⇒ 00:28:38.819 Emily Giant: Oh yeah, that happened one minute ago.
266 00:28:41.670 ⇒ 00:28:44.150 Demilade Agboola: But we don’t have that sort of real-time data yet.
267 00:28:44.450 ⇒ 00:28:45.320 Emily Giant: Yeah.
268 00:28:48.710 ⇒ 00:28:50.910 Emily Giant: Now, these are, like, old as…
269 00:28:58.230 ⇒ 00:29:02.520 Emily Giant: Alright, maybe it’s easier to find it in Dash, since these are all today.
270 00:29:06.070 ⇒ 00:29:09.009 Emily Giant: 2.05 AM. Go to bed!
271 00:29:12.310 ⇒ 00:29:13.000 Emily Giant: Okay.
272 00:29:14.470 ⇒ 00:29:15.300 Emily Giant: Let’s see…
273 00:29:19.370 ⇒ 00:29:20.760 Emily Giant: Set the table.
274 00:29:39.940 ⇒ 00:29:45.410 Emily Giant: 819… so, okay, it’s spread it across the, items.
275 00:29:55.360 ⇒ 00:29:57.230 Emily Giant: Yeah, it doesn’t give the…
276 00:29:57.440 ⇒ 00:29:58.679 Demilade Agboola: So it’s gotta be…
277 00:29:58.680 ⇒ 00:30:00.469 Emily Giant: Different table, maybe.
278 00:30:01.320 ⇒ 00:30:08.490 Emily Giant: like, which one has a promo code? Because if it has a promo code in it, then…
279 00:30:09.000 ⇒ 00:30:11.309 Emily Giant: You’re gonna know it’s a promo instead of…
280 00:30:14.150 ⇒ 00:30:16.340 Demilade Agboola: Let’s see.
281 00:30:49.260 ⇒ 00:30:50.530 Emily Giant: Discount codes, okay.
282 00:30:50.910 ⇒ 00:30:53.600 Demilade Agboola: Alright, can you go to… can you go to orders?
283 00:30:53.910 ⇒ 00:30:55.660 Emily Giant: Yeah, that’s exactly what I’m doing.
284 00:30:55.940 ⇒ 00:30:58.399 Emily Giant: Alright, so if I pull it from orders…
285 00:31:04.250 ⇒ 00:31:05.070 Emily Giant: Oh.
286 00:31:06.340 ⇒ 00:31:07.220 Emily Giant: Where?
287 00:31:09.210 ⇒ 00:31:11.080 Emily Giant: What’s it called in this?
288 00:31:12.690 ⇒ 00:31:13.780 Emily Giant: ID, maybe?
289 00:31:13.780 ⇒ 00:31:15.819 Demilade Agboola: maybe 80, yeah, probably Spain.
290 00:31:53.090 ⇒ 00:31:54.589 Emily Giant: Must be a big table.
291 00:31:56.180 ⇒ 00:31:58.899 Demilade Agboola: Yeah, I mean, it is all the orders.
292 00:31:58.900 ⇒ 00:32:01.480 Emily Giant: Yeah, that’s… that’s a thing.
293 00:32:06.940 ⇒ 00:32:07.690 Emily Giant: Okay.
294 00:32:07.820 ⇒ 00:32:11.889 Emily Giant: So this should have set the table in the promo codes column.
295 00:32:26.980 ⇒ 00:32:29.879 Emily Giant: Okay, here’s discount applications.
296 00:32:30.980 ⇒ 00:32:33.420 Emily Giant: Discount codes set the table.
297 00:32:37.670 ⇒ 00:32:39.220 Emily Giant: So, okay.
298 00:32:39.500 ⇒ 00:32:43.090 Demilade Agboola: But then… but this is on… but this is on an order level, though, that’s the problem.
299 00:32:43.090 ⇒ 00:32:48.370 Emily Giant: that’s fine. Like, you have the whole logic to split it out already in there.
300 00:32:51.010 ⇒ 00:32:55.729 Demilade Agboola: Yes, in the discount table that you created.
301 00:32:57.250 ⇒ 00:32:59.480 Emily Giant: You, you have, like, a whole model.
302 00:32:59.670 ⇒ 00:33:00.890 Demilade Agboola: Can we see?
303 00:33:02.530 ⇒ 00:33:08.119 Demilade Agboola: Can we see the one that you’re ordered? Can we see how that looks like in here?
304 00:33:08.280 ⇒ 00:33:14.229 Emily Giant: Yeah, we are on the same wavelength. I had already copied that number just to see what…
305 00:33:14.680 ⇒ 00:33:20.020 Emily Giant: this line, in particular. So, loyalty always starts with L dash.
306 00:33:23.310 ⇒ 00:33:26.770 Emily Giant: Which is a good way to say, like, that’s how it’s categorized.
307 00:33:42.850 ⇒ 00:33:46.930 Emily Giant: Oh, look at… happy MFN 40th birthday. Nice note.
308 00:33:51.860 ⇒ 00:33:53.440 Demilade Agboola: Kante doesn’t sound like you.
309 00:33:53.440 ⇒ 00:33:54.215 Emily Giant: Yes.
310 00:33:56.920 ⇒ 00:33:59.389 Emily Giant: I am nothing if not myself.
311 00:34:00.360 ⇒ 00:34:02.489 Emily Giant: Okay, OH! Look at that!
312 00:34:02.890 ⇒ 00:34:05.399 Emily Giant: Discount type, automatic.
313 00:34:06.770 ⇒ 00:34:12.539 Demilade Agboola: So it has the title, employee discount, the value… Can I see the discount code, though?
314 00:34:12.540 ⇒ 00:34:13.420 Emily Giant: Yeah.
315 00:34:14.460 ⇒ 00:34:16.509 Emily Giant: No. Get out of there.
316 00:34:17.120 ⇒ 00:34:21.149 Emily Giant: Oh my gosh, I can’t deal with how Mode does some UX stuff.
317 00:34:25.719 ⇒ 00:34:27.390 Emily Giant: Okay, discount code…
318 00:34:37.190 ⇒ 00:34:39.830 Emily Giant: Just so… Total discounts.
319 00:34:43.510 ⇒ 00:34:44.300 Emily Giant: Okay.
320 00:34:44.409 ⇒ 00:34:51.840 Emily Giant: So, code L dash… So that’s, like, the yacht poke mode.
321 00:34:54.040 ⇒ 00:34:55.269 Demilade Agboola: Okay, so…
322 00:34:55.940 ⇒ 00:34:57.440 Emily Giant: Or loyalty.
323 00:35:04.050 ⇒ 00:35:08.170 Demilade Agboola: So, I don’t… I don’t know if it would be best to spread it across…
324 00:35:08.400 ⇒ 00:35:09.950 Demilade Agboola: I don’t know, should we…
325 00:35:18.110 ⇒ 00:35:21.550 Demilade Agboola: So this complication is… it says…
326 00:35:22.010 ⇒ 00:35:27.460 Demilade Agboola: So, is the discount application a sum of, let me see, it’s the automatic, so the value’s 50.
327 00:35:29.170 ⇒ 00:35:35.010 Demilade Agboola: And then, shipping value’s 7 to 5. So, that’s the percentage, though.
328 00:35:35.430 ⇒ 00:35:36.310 Demilade Agboola: Right?
329 00:35:37.880 ⇒ 00:35:40.479 Emily Giant: And then there’s a discount code of 5.
330 00:35:40.750 ⇒ 00:35:41.790 Demilade Agboola: Dollars.
331 00:35:43.520 ⇒ 00:35:45.410 Emily Giant: Okay, automatic.
332 00:35:45.410 ⇒ 00:35:46.570 Demilade Agboola: So it’s percentage.
333 00:35:46.570 ⇒ 00:35:47.770 Emily Giant: Yes, yeah.
334 00:35:47.770 ⇒ 00:35:54.480 Demilade Agboola: 50%, and then it’s 75% of shipping, and then it’s $5 value.
335 00:35:55.210 ⇒ 00:35:55.890 Demilade Agboola: he’s gone.
336 00:35:56.330 ⇒ 00:35:58.250 Emily Giant: But there should also be a line.
337 00:35:59.530 ⇒ 00:36:03.569 Demilade Agboola: Yeah, that’s the total discount. That’s what we’re seeing in the model.
338 00:36:05.110 ⇒ 00:36:06.610 Emily Giant: Yeah, and that’s…
339 00:36:08.090 ⇒ 00:36:13.699 Demilade Agboola: But now we want to be able to see, instead of it being just total discounts, we want to be able to see
340 00:36:14.100 ⇒ 00:36:20.930 Demilade Agboola: The promo value, the total to promo value, and the total discount value, right?
341 00:36:20.930 ⇒ 00:36:29.249 Emily Giant: Right. Exactly. So that’s when that other discount allocations model would come into play, because that actually splits out those.
342 00:36:29.670 ⇒ 00:36:30.570 Emily Giant: Amounts.
343 00:36:30.820 ⇒ 00:36:33.200 Demilade Agboola: No, I think this splits out the amount, though.
344 00:36:35.750 ⇒ 00:36:39.590 Demilade Agboola: Because once you can extract it, you can be able to say, hey, like.
345 00:36:40.910 ⇒ 00:36:45.219 Demilade Agboola: No, say if you go back to the JSON, like, the JSON part of this model.
346 00:36:46.920 ⇒ 00:36:49.879 Demilade Agboola: So, like, discount allocations and discount code.
347 00:36:56.400 ⇒ 00:36:57.729 Emily Giant: Yeah, it does.
348 00:36:57.730 ⇒ 00:37:08.400 Demilade Agboola: It does. So, for every single type, we can basically say, hey, if the value is… if the value type is percentage, do the value… do that value multiplied by…
349 00:37:09.460 ⇒ 00:37:12.899 Demilade Agboola: The total amount, and divide it by 100.
350 00:37:13.430 ⇒ 00:37:17.180 Demilade Agboola: And then, if there’s another percentage for shipping, do it for shipping.
351 00:37:17.490 ⇒ 00:37:21.860 Demilade Agboola: And then, when the discount is a fixed type, just subtract it.
352 00:37:21.860 ⇒ 00:37:22.410 Emily Giant: Yeah.
353 00:37:22.410 ⇒ 00:37:30.610 Demilade Agboola: Basically, we’ll just use that to create new columns that say, hey, for this transaction, the total promo amount was this, the total discount amount was this.
354 00:37:30.770 ⇒ 00:37:32.700 Emily Giant: Yeah, that, that totally works.
355 00:37:33.160 ⇒ 00:37:36.760 Emily Giant: I want to see if in total shipping it shows the discount.
356 00:37:38.490 ⇒ 00:37:39.190 Emily Giant: No.
357 00:37:39.190 ⇒ 00:37:40.050 Demilade Agboola: I don’t think so.
358 00:37:42.000 ⇒ 00:37:46.700 Emily Giant: I guess… It’s not 50% off of shipping, though. It’s, like, a different.
359 00:37:46.700 ⇒ 00:37:47.340 Demilade Agboola: Bye.
360 00:37:47.560 ⇒ 00:37:48.849 Demilade Agboola: It’s on 5%.
361 00:37:49.660 ⇒ 00:37:55.160 Emily Giant: Okay. If you go to the discount… go to the discount, total discount again, or the discount column.
362 00:37:56.280 ⇒ 00:38:02.669 Demilade Agboola: No, not the total discount in that case, sorry, it’s a discount, allocatement, or something?
363 00:38:08.350 ⇒ 00:38:10.650 Demilade Agboola: Or… it’s beside discount code.
364 00:38:10.650 ⇒ 00:38:12.150 Emily Giant: It was like, discount something.
365 00:38:12.150 ⇒ 00:38:14.619 Demilade Agboola: Yeah, if you can find discount code…
366 00:38:14.620 ⇒ 00:38:15.219 Emily Giant: There we go.
367 00:38:15.220 ⇒ 00:38:16.950 Demilade Agboola: Yeah, discount information. So, if you look at the…
368 00:38:16.950 ⇒ 00:38:19.519 Emily Giant: 2 million? Oh, 75%.
369 00:38:19.520 ⇒ 00:38:27.690 Demilade Agboola: Yeah, that’s awesome. Yeah, okay. So everything is actually just there, you just need to be able to get it and say, hey.
370 00:38:28.000 ⇒ 00:38:32.700 Demilade Agboola: This… So, I think… can you…
371 00:38:33.150 ⇒ 00:38:36.510 Demilade Agboola: Can you close the search bar, please? Thank you.
372 00:38:36.930 ⇒ 00:38:37.390 Emily Giant: Yeah.
373 00:38:37.390 ⇒ 00:38:40.389 Demilade Agboola: Do, the different titles.
374 00:38:40.590 ⇒ 00:38:50.159 Demilade Agboola: So, employee discounts, or, like, we could call them promos. Are employee discounts the only sort of promos, or are they the only sort of discounts, sorry, are there other types of discounts?
375 00:38:51.420 ⇒ 00:38:59.620 Emily Giant: There are other types of discounts. I could do, select distinct…
376 00:39:00.040 ⇒ 00:39:08.000 Demilade Agboola: Yeah, don’t worry, I’ll dig into it, that’s no problem. I just wanted to just hear. So basically, anything discount code would be… I would attribute that to…
377 00:39:08.260 ⇒ 00:39:09.060 Demilade Agboola: promos.
378 00:39:09.250 ⇒ 00:39:14.329 Demilade Agboola: And the others, I would probably just… I would look at them and just be sure that it’s all discounts.
379 00:39:14.760 ⇒ 00:39:15.220 Emily Giant: Yep.
380 00:39:15.220 ⇒ 00:39:18.709 Demilade Agboola: So I’ll just do total discount and total promos for these.
381 00:39:19.260 ⇒ 00:39:20.100 Emily Giant: Yep.
382 00:39:20.240 ⇒ 00:39:21.969 Demilade Agboola: Alright, sounds good then.
383 00:39:22.320 ⇒ 00:39:25.850 Emily Giant: Okay, so that was the one thing. I don’t think there was anything…
384 00:39:25.920 ⇒ 00:39:27.690 Demilade Agboola: Else that was…
385 00:39:27.730 ⇒ 00:39:31.860 Emily Giant: Incorrect outside of, like.
386 00:39:32.540 ⇒ 00:39:41.080 Emily Giant: the order status, and, like, overriding until Alex can do that, retroactive fix. I was thinking…
387 00:39:41.080 ⇒ 00:39:46.160 Demilade Agboola: is the delivery status? Because I had looked at it for a quick bit, and I’d seen that,
388 00:39:46.670 ⇒ 00:39:55.370 Demilade Agboola: And… In Status OMS sub-orders, we do have delivery status.
389 00:39:55.590 ⇒ 00:40:02.340 Demilade Agboola: I haven’t, like… Property… dug into it yet, but I just did a quick peek.
390 00:40:02.340 ⇒ 00:40:05.900 Emily Giant: I think so. There’s also order status.
391 00:40:06.030 ⇒ 00:40:06.880 Emily Giant: And…
392 00:40:06.880 ⇒ 00:40:10.279 Demilade Agboola: It’s, like, too high, high level?
393 00:40:11.240 ⇒ 00:40:12.190 Emily Giant: Probably.
394 00:40:12.190 ⇒ 00:40:13.940 Demilade Agboola: Yeah. Yeah.
395 00:40:13.940 ⇒ 00:40:15.809 Emily Giant: Delivery status makes sense.
396 00:40:16.410 ⇒ 00:40:19.800 Demilade Agboola: Yeah, because that allows us to also use it for the fulfilled items.
397 00:40:20.080 ⇒ 00:40:21.810 Emily Giant: Yeah, that totally makes sense.
398 00:40:21.810 ⇒ 00:40:22.360 Demilade Agboola: Fair.
399 00:40:23.430 ⇒ 00:40:27.620 Emily Giant: Yeah, I think that delivery status should be… on the money.
400 00:40:29.110 ⇒ 00:40:36.499 Demilade Agboola: Yeah, I wouldn’t… everything’s always so weird. Like, we could look at it now, and then it just…
401 00:40:37.620 ⇒ 00:40:40.230 Demilade Agboola: might have its own issues, but yeah, I get what you mean.
402 00:40:40.600 ⇒ 00:40:44.039 Emily Giant: Yeah, I opened a document for Alex,
403 00:40:45.150 ⇒ 00:40:50.450 Emily Giant: that was all the unfulfilled orders, and it was, like, in the… I think it was 50,000.
404 00:40:53.430 ⇒ 00:40:55.769 Demilade Agboola: That’s a lot. That’s definitely a lot.
405 00:40:56.740 ⇒ 00:40:57.420 Emily Giant: Yeah.
406 00:40:58.150 ⇒ 00:41:03.490 Emily Giant: Shopify… orders showing in Shopify… okay. No, these are all Shopify…
407 00:41:04.670 ⇒ 00:41:09.199 Emily Giant: Anyway, that should overwrite it for now, just so that we can, like, get it out there to the world.
408 00:41:10.220 ⇒ 00:41:16.100 Emily Giant: But he needs to, like, Mark that stuff as fulfilled, because it is.
409 00:41:16.730 ⇒ 00:41:20.429 Demilade Agboola: Alright, so here’s the problem, I’m just looking at… I’m hoping to share my screen.
410 00:41:20.740 ⇒ 00:41:21.470 Emily Giant: Okay.
411 00:41:27.780 ⇒ 00:41:30.839 Demilade Agboola: So, the delivery status…
412 00:41:32.130 ⇒ 00:41:37.359 Demilade Agboola: it isn’t just, like, I mean, obviously we have, like, delivered, all of that, but we also have, like, weird stuff like this.
413 00:41:37.360 ⇒ 00:41:38.320 Emily Giant: Not bad.
414 00:41:38.590 ⇒ 00:41:39.510 Emily Giant: Rick?
415 00:41:40.310 ⇒ 00:41:42.940 Emily Giant: Can you pull what orders those are?
416 00:41:44.530 ⇒ 00:41:45.870 Emily Giant: What?
417 00:42:43.210 ⇒ 00:42:44.989 Emily Giant: You might have to use
418 00:42:45.490 ⇒ 00:42:50.420 Emily Giant: Where delivery date is less than current date, if this is as crazy as it looks.
419 00:42:52.840 ⇒ 00:42:54.829 Demilade Agboola: I just wanted to get the very specific one.
420 00:42:54.830 ⇒ 00:42:55.860 Emily Giant: Yeah.
421 00:43:10.070 ⇒ 00:43:22.029 Emily Giant: While we’re waiting on this, have you noticed the cursor gets tired at night and does worse work? Either I’m giving it worse commands, or it really gets tired and it’s like, I can’t do this for you anymore. I gotta go to bed. I think it’s just a person.
422 00:43:23.720 ⇒ 00:43:26.729 Demilade Agboola: Artificial intelligence is anonymous individuals.
423 00:43:27.990 ⇒ 00:43:29.520 Demilade Agboola: That’s what AI stands for.
424 00:43:30.260 ⇒ 00:43:31.999 Emily Giant: What is it? What did you say?
425 00:43:32.000 ⇒ 00:43:35.459 Demilade Agboola: I said AI stands for Anonymous individual.
426 00:43:35.460 ⇒ 00:43:38.669 Emily Giant: Yeah, totally. It’s just anonymous.
427 00:43:39.100 ⇒ 00:43:41.890 Emily Giant: Like, collegiate tech bro.
428 00:43:41.890 ⇒ 00:43:45.299 Demilade Agboola: It’s just like, I’m tired, like, Edit an app.
429 00:43:45.600 ⇒ 00:43:51.189 Emily Giant: Yeah, it’s… truly. Like, it will just miss commas, like, it will do stuff that, like.
430 00:43:51.910 ⇒ 00:43:56.819 Emily Giant: that a tired, tired person would do, and I’m like, this is just a man.
431 00:43:57.210 ⇒ 00:44:01.540 Emily Giant: India, who’s extremely smart, and this is his daytime.
432 00:44:03.800 ⇒ 00:44:08.719 Emily Giant: Okay, can we look at that order in Dash and see if it actually got delivered?
433 00:44:10.920 ⇒ 00:44:12.379 Demilade Agboola: We’re not closer to she’s delivered at.
434 00:44:12.380 ⇒ 00:44:18.610 Emily Giant: Looks… yeah, I would just do delivered at as… not null.
435 00:44:19.050 ⇒ 00:44:20.770 Emily Giant: Something like that.
436 00:44:31.670 ⇒ 00:44:35.949 Demilade Agboola: Dash does this weird thing where once in a while, he refuses to let me come in.
437 00:44:37.780 ⇒ 00:44:40.230 Demilade Agboola: Like, no, you have.
438 00:44:40.230 ⇒ 00:44:41.780 Emily Giant: don’t. Yep.
439 00:44:42.970 ⇒ 00:44:44.489 Demilade Agboola: You have to be one of us.
440 00:44:45.770 ⇒ 00:44:47.609 Emily Giant: I see that email address.
441 00:45:01.660 ⇒ 00:45:05.149 Demilade Agboola: Okay. It’s like, no, you can’t use Gmail. You have to…
442 00:45:06.350 ⇒ 00:45:07.679 Demilade Agboola: Sign in properly.
443 00:45:07.680 ⇒ 00:45:08.769 Emily Giant: Sit with us.
444 00:45:09.480 ⇒ 00:45:11.030 Emily Giant: Yeah, it’s delivered!
445 00:45:11.900 ⇒ 00:45:12.840 Emily Giant: Ugh.
446 00:45:13.190 ⇒ 00:45:13.930 Emily Giant: Okay.
447 00:45:14.070 ⇒ 00:45:21.060 Emily Giant: Yeah, I would just use delivery date. Although… It… it might be…
448 00:45:21.480 ⇒ 00:45:25.350 Emily Giant: Good to use, like, is canceled, also, just in case.
449 00:45:25.540 ⇒ 00:45:31.260 Emily Giant: I wouldn’t think it would have a delivery date, because those are a webhook from a carrier.
450 00:45:33.230 ⇒ 00:45:35.010 Demilade Agboola: Which… what’s his? The…
451 00:45:35.010 ⇒ 00:45:38.680 Emily Giant: the delivery date is a webhook from, like, EasyPost.
452 00:45:39.340 ⇒ 00:45:49.400 Emily Giant: So, it’s supposed to track, like, the actual delivery date once Scanned by the delivery party.
453 00:45:53.170 ⇒ 00:45:55.030 Demilade Agboola: Okay…
454 00:46:00.370 ⇒ 00:46:06.620 Emily Giant: Yeah, if isCanceled is 0 and delivery date is not null, just in case… I mean, I wouldn’t think…
455 00:46:07.390 ⇒ 00:46:13.649 Emily Giant: Why is delivery status so… I should fix that in the suborder model.
456 00:46:14.250 ⇒ 00:46:17.219 Emily Giant: Also, like, if it’s delivery status.
457 00:46:18.840 ⇒ 00:46:21.940 Emily Giant: That might be the way to go, too, just in suborders.
458 00:46:22.740 ⇒ 00:46:24.259 Emily Giant: For delivery status.
459 00:46:25.590 ⇒ 00:46:28.720 Emily Giant: If it has one of those strings and it’s not marked as canceled.
460 00:46:29.590 ⇒ 00:46:31.159 Emily Giant: Market is delivered.
461 00:46:31.600 ⇒ 00:46:32.340 Demilade Agboola: Yeah, yeah.
462 00:46:33.000 ⇒ 00:46:34.439 Demilade Agboola: I would deliver that date, so…
463 00:46:34.440 ⇒ 00:46:37.490 Emily Giant: Yeah, yeah. The delivered ad is reliable.
464 00:46:51.510 ⇒ 00:46:55.350 Emily Giant: I say that, but prove me wrong. I’m sure it won’t be hard.
465 00:46:55.880 ⇒ 00:46:59.420 Demilade Agboola: I mean, at this point, I don’t think anything is particularly reliable.
466 00:46:59.420 ⇒ 00:47:03.860 Emily Giant: I know. That was my weekend. It’s like, we didn’t do anything wrong.
467 00:47:04.600 ⇒ 00:47:07.910 Emily Giant: We just have the craziest data.
468 00:47:08.010 ⇒ 00:47:15.600 Emily Giant: That you have to, like, wrangle 15 different models to… get what a flower costs.
469 00:47:16.820 ⇒ 00:47:17.830 Demilade Agboola: Yeah.
470 00:47:43.650 ⇒ 00:47:46.140 Demilade Agboola: But there are some…
471 00:47:47.940 ⇒ 00:47:49.260 Emily Giant: Are they canceled?
472 00:47:50.800 ⇒ 00:47:53.249 Demilade Agboola: With that, yeah, that’s the next one, let’s look at.
473 00:48:02.040 ⇒ 00:48:06.269 Demilade Agboola: Some are, some aren’t. So, let’s look at the ones that aren’t.
474 00:48:14.050 ⇒ 00:48:16.530 Demilade Agboola: Back the holes all honey.
475 00:48:17.690 ⇒ 00:48:19.739 Emily Giant: It’s always that one, too.
476 00:48:23.930 ⇒ 00:48:26.489 Demilade Agboola: Alright, man, you have to have your go-to Christmas chorole.
477 00:48:26.490 ⇒ 00:48:27.190 Emily Giant: Yeah.
478 00:48:31.330 ⇒ 00:48:34.600 Demilade Agboola: This looks fine. Can’t see anything wrong with it.
479 00:48:35.350 ⇒ 00:48:40.790 Emily Giant: Except that it’s in suborder printed status. They never updated it. Like, Dash never updated.
480 00:48:41.370 ⇒ 00:48:42.769 Emily Giant: That’s interesting.
481 00:48:48.370 ⇒ 00:48:49.380 Demilade Agboola: So…
482 00:48:49.810 ⇒ 00:48:51.829 Emily Giant: That’s like a system crap out.
483 00:48:53.780 ⇒ 00:48:55.350 Demilade Agboola: Surprise, surprise!
484 00:49:01.470 ⇒ 00:49:05.499 Demilade Agboola: Surprise, surprise. Okay, so… If they can’t give us anything to work with.
485 00:49:10.640 ⇒ 00:49:12.219 Demilade Agboola: So, how many or two?
486 00:49:14.100 ⇒ 00:49:19.910 Demilade Agboola: To deliver that signal, and… Ace Consult…
487 00:49:23.170 ⇒ 00:49:25.820 Demilade Agboola: It is equals to zero.
488 00:49:41.300 ⇒ 00:49:42.490 Demilade Agboola: Yeah, so…
489 00:49:42.790 ⇒ 00:49:44.979 Emily Giant: I wanna see what those…
490 00:49:45.490 ⇒ 00:49:49.620 Emily Giant: And, can we add and,
491 00:49:49.850 ⇒ 00:49:52.609 Emily Giant: Delivery status is not equal to delivered.
492 00:50:21.360 ⇒ 00:50:22.159 Demilade Agboola: It’s all settlement.
493 00:50:23.130 ⇒ 00:50:24.080 Emily Giant: Damn? Okay.
494 00:50:25.260 ⇒ 00:50:27.889 Emily Giant: Fun stuff, fun stuff.
495 00:50:27.890 ⇒ 00:50:32.140 Demilade Agboola: basically, if… We try to use this.
496 00:50:34.600 ⇒ 00:50:39.090 Demilade Agboola: Let me look at the… there’s still the issue, potential issue, that we’ll have.
497 00:50:39.910 ⇒ 00:50:41.200 Demilade Agboola: some stuff.
498 00:50:41.520 ⇒ 00:50:44.249 Demilade Agboola: That have been delivered.
499 00:50:44.860 ⇒ 00:50:51.719 Demilade Agboola: But I don’t think we might be able to escape some of the unfulfilled ones that have been fulfilled, potentially.
500 00:50:53.740 ⇒ 00:50:54.520 Emily Giant: Yeah.
501 00:50:54.700 ⇒ 00:50:59.770 Emily Giant: That’s true. Like, if we did a date, like, and created at as greater than…
502 00:50:59.990 ⇒ 00:51:07.670 Emily Giant: 11, 6, 2024. That will at least give you the, like, the post-migration orders, because Shopify is…
503 00:51:08.100 ⇒ 00:51:13.239 Emily Giant: the big problem here. And a lot of these that we pulled up were old-ass orders.
504 00:51:17.390 ⇒ 00:51:26.810 Demilade Agboola: So, the issue… I didn’t get that. I wasn’t, like, I was trying to… So, if we do create that greater than the migration date.
505 00:51:28.080 ⇒ 00:51:32.530 Demilade Agboola: What are we expecting?
506 00:51:34.400 ⇒ 00:51:35.240 Emily Giant: less.
507 00:51:35.840 ⇒ 00:51:37.370 Demilade Agboola: Oh, definitely, we’ll definitely have less.
508 00:51:38.850 ⇒ 00:51:40.640 Demilade Agboola: But.
509 00:51:42.470 ⇒ 00:51:45.409 Emily Giant: Just seeing if this is, like, okay, so…
510 00:51:45.810 ⇒ 00:51:46.740 Demilade Agboola: Still a telephone.
511 00:51:46.740 ⇒ 00:51:47.560 Emily Giant: Moons.
512 00:51:50.200 ⇒ 00:51:55.140 Emily Giant: Can’t… Can we do select distinct delivery status with that criteria?
513 00:52:11.920 ⇒ 00:52:21.220 Demilade Agboola: basically, I, like… part of what I hope we’re trying to use this process So the subwater printed.
514 00:52:23.650 ⇒ 00:52:25.099 Demilade Agboola: The waiting pickup.
515 00:52:29.700 ⇒ 00:52:31.450 Demilade Agboola: It’s left from antenna.
516 00:52:31.870 ⇒ 00:52:34.009 Demilade Agboola: This batch work order printed.
517 00:52:34.150 ⇒ 00:52:35.730 Demilade Agboola: This path is received.
518 00:52:36.340 ⇒ 00:52:37.430 Demilade Agboola: In transit.
519 00:52:38.060 ⇒ 00:52:39.460 Demilade Agboola: out for delivery.
520 00:52:42.040 ⇒ 00:52:46.530 Emily Giant: At least there’s no nulls, that’s… Something.
521 00:52:51.590 ⇒ 00:52:55.740 Emily Giant: If they’re in received, definitely should not count as fulfilled.
522 00:53:00.820 ⇒ 00:53:05.159 Emily Giant: There are 3 of those statuses that should not be marked as fulfilled if
523 00:53:05.880 ⇒ 00:53:09.419 Emily Giant: if what I’m seeing is true, and it’s batchwork printed.
524 00:53:10.870 ⇒ 00:53:14.909 Emily Giant: Suborder… or… 4. Sub-order printed, batched.
525 00:53:16.520 ⇒ 00:53:22.289 Emily Giant: received and batchwork printed. Like, those are not statuses of something that was ever picked up.
526 00:53:22.290 ⇒ 00:53:24.130 Demilade Agboola: You said it’s a water printed.
527 00:53:24.750 ⇒ 00:53:25.750 Emily Giant: Batched.
528 00:53:26.470 ⇒ 00:53:27.760 Emily Giant: Received.
529 00:53:27.760 ⇒ 00:53:30.330 Demilade Agboola: And password printed.
530 00:53:30.650 ⇒ 00:53:33.259 Demilade Agboola: Yeah, but then, the one we looked at just now.
531 00:53:35.470 ⇒ 00:53:36.650 Emily Giant: what’s delivered.
532 00:53:37.670 ⇒ 00:53:39.250 Demilade Agboola: So, border printed.
533 00:53:41.580 ⇒ 00:53:42.510 Emily Giant: That’s true.
534 00:53:44.380 ⇒ 00:53:47.549 Emily Giant: Let’s look at one post-migration that’s suborder printed.
535 00:53:48.780 ⇒ 00:53:50.280 Demilade Agboola: Alright, can I say fine.
536 00:54:08.860 ⇒ 00:54:14.179 Demilade Agboola: You said it was batch what color printer received, batched, and sub water printed, right?
537 00:54:14.460 ⇒ 00:54:15.210 Emily Giant: Yep.
538 00:54:15.750 ⇒ 00:54:16.420 Demilade Agboola: Okay.
539 00:54:19.160 ⇒ 00:54:25.429 Emily Giant: the received ones, I find very, very sketchy. Like, those I would think, are actually not fulfilled.
540 00:54:26.890 ⇒ 00:54:28.310 Demilade Agboola: We’ll just look at this.
541 00:54:29.700 ⇒ 00:54:37.710 Emily Giant: And the rest could be, like, a missed scan. But received, that does not in any way look like it was touched.
542 00:54:53.650 ⇒ 00:54:55.200 Demilade Agboola: Post-migration…
543 00:54:59.760 ⇒ 00:55:01.570 Demilade Agboola: What should I have been?
544 00:55:02.700 ⇒ 00:55:03.800 Demilade Agboola: delivery status.
545 00:56:22.360 ⇒ 00:56:25.210 Demilade Agboola: Alright, so… Do I have a couple.
546 00:56:26.520 ⇒ 00:56:27.620 Demilade Agboola: Here…
547 00:56:55.670 ⇒ 00:57:00.999 Demilade Agboola: This happened… On the 26th of November last year.
548 00:57:04.200 ⇒ 00:57:06.450 Emily Giant: Oh my gosh, look at that order. Absolutely.
549 00:57:06.450 ⇒ 00:57:12.340 Demilade Agboola: April and 16th for how So it’s just not committed, it’s not non-lotted.
550 00:57:12.340 ⇒ 00:57:17.319 Emily Giant: Yeah, everything… everything is wrong with this order. Can you hit View Tracking?
551 00:57:18.620 ⇒ 00:57:19.500 Demilade Agboola: What is that?
552 00:57:19.870 ⇒ 00:57:20.820 Emily Giant: Yeah.
553 00:57:25.670 ⇒ 00:57:26.600 Demilade Agboola: Rejects.
554 00:57:28.900 ⇒ 00:57:30.679 Demilade Agboola: It’s still on the way.
555 00:57:31.290 ⇒ 00:57:34.419 Emily Giant: Oh, those flowers are not alive.
556 00:57:37.300 ⇒ 00:57:39.270 Demilade Agboola: I’ll… I’ll go there one day.
557 00:57:39.720 ⇒ 00:57:44.150 Emily Giant: Yep. Oh, that’d be sick. It’s, like, been a year.
558 00:57:49.610 ⇒ 00:57:56.439 Emily Giant: Okay, I… I thought you were gonna click Get Status Updates. I was like, you were invested.
559 00:57:59.300 ⇒ 00:58:05.750 Emily Giant: Okay, it… I mean, it looks like it was fulfilled… But just never delivered.
560 00:58:05.900 ⇒ 00:58:06.980 Emily Giant: So I guess…
561 00:58:07.430 ⇒ 00:58:09.060 Demilade Agboola: How does that work?
562 00:58:10.290 ⇒ 00:58:12.519 Emily Giant: Well, I would… ugh.
563 00:58:12.780 ⇒ 00:58:15.380 Emily Giant: Carriers lose things all the time.
564 00:58:16.110 ⇒ 00:58:18.680 Emily Giant: So, that’s helpful, though.
565 00:58:18.680 ⇒ 00:58:20.270 Demilade Agboola: What’s fulfillment in this case?
566 00:58:24.100 ⇒ 00:58:25.939 Emily Giant: Did we refund these people?
567 00:58:27.750 ⇒ 00:58:29.770 Demilade Agboola: I can’t see… I can’t see any refund.
568 00:58:29.770 ⇒ 00:58:30.330 Emily Giant: Oh, my
569 00:58:32.450 ⇒ 00:58:44.180 Emily Giant: and don’t realize the person never got it, and they probably don’t even speak to each other now, because, like, Mindy didn’t thank whoever sent it. Anyway… oh, Mindy said it to herself, thank God.
570 00:58:45.580 ⇒ 00:58:47.529 Emily Giant: I would call that fulfilled.
571 00:58:47.660 ⇒ 00:58:49.719 Emily Giant: If the carrier picked it up.
572 00:58:51.350 ⇒ 00:59:00.959 Demilade Agboola: But we… the problem here is… isn’t necessary, it’s that, like, is there, like, there’s no overarching logic to just go, like, this is fulfilled.
573 00:59:00.960 ⇒ 00:59:02.049 Emily Giant: I know. That’s a problem.
574 00:59:03.150 ⇒ 00:59:06.980 Emily Giant: I would just implement what should work.
575 00:59:07.280 ⇒ 00:59:15.670 Emily Giant: Not should, meaning if the data made any sense at all, which is… status equals… not received.
576 00:59:16.150 ⇒ 00:59:20.210 Emily Giant: And… Assume.
577 00:59:21.440 ⇒ 00:59:24.120 Emily Giant: That it’s largely correct, but…
578 00:59:25.600 ⇒ 00:59:26.000 Demilade Agboola: Wait.
579 00:59:26.000 ⇒ 00:59:33.620 Emily Giant: You’ll get the… you’ll get the majority of orders that are actually fulfilled in Shopify with the logic that we initially
580 00:59:33.830 ⇒ 00:59:39.619 Emily Giant: proposed, and then the rest of those, I’m like, what are we supposed to do about it?
581 00:59:39.850 ⇒ 00:59:41.370 Demilade Agboola: But the logic carries.
582 00:59:41.540 ⇒ 00:59:43.959 Demilade Agboola: It’s fulfilled if it’s delivered at…
583 00:59:45.870 ⇒ 00:59:48.700 Demilade Agboola: Or, it has a status of…
584 00:59:49.480 ⇒ 00:59:52.060 Demilade Agboola: That is not in, like, received, so what.
585 00:59:52.060 ⇒ 00:59:52.720 Emily Giant: Yeah.
586 00:59:52.720 ⇒ 00:59:57.839 Demilade Agboola: But then, this is the water printer that you think is… this is the second Subwater Printer that you think is fulfilled.
587 00:59:59.760 ⇒ 01:00:01.080 Emily Giant: Say that again, I’m sorry.
588 01:00:01.080 ⇒ 01:00:04.490 Demilade Agboola: I think this is the second suborder printed order that you think.
589 01:00:04.490 ⇒ 01:00:05.360 Emily Giant: Yeah.
590 01:00:06.970 ⇒ 01:00:12.830 Emily Giant: Received is the one where I think they are not fulfilled. Like, very strong chance they were never fulfilled.
591 01:00:25.960 ⇒ 01:00:30.449 Demilade Agboola: I think sometimes we need to have, like, Alex on this call so he has an idea of, like, how, like, messed up the data is.
592 01:00:30.450 ⇒ 01:00:31.110 Emily Giant: Yeah.
593 01:00:31.250 ⇒ 01:00:32.370 Emily Giant: I agree.
594 01:00:40.220 ⇒ 01:00:43.920 Demilade Agboola: So it’s sometimes quite easy to, like, why is this not… why haven’t this spell?
595 01:00:43.920 ⇒ 01:00:44.720 Emily Giant: Yeah.
596 01:00:46.530 ⇒ 01:00:47.420 Demilade Agboola: Earth’s like…
597 01:00:47.420 ⇒ 01:00:49.849 Emily Giant: This is becoming our problem now.
598 01:00:53.180 ⇒ 01:00:54.550 Demilade Agboola: So what am I looking at?
599 01:00:54.550 ⇒ 01:01:01.940 Emily Giant: So, received is, like, when an order comes in, and this looks like it hasn’t been touched, but I do see view tracking.
600 01:01:06.880 ⇒ 01:01:10.310 Emily Giant: I have to hop in, like, a second. Oh!
601 01:01:17.660 ⇒ 01:01:24.230 Emily Giant: On the way, great, okay. So, there’s no real great way to do this, then, unless I can, like.
602 01:01:24.630 ⇒ 01:01:30.779 Emily Giant: override it with some other, like, tracking platform, but we’re not gonna even get into that this week. I would just do…
603 01:01:31.270 ⇒ 01:01:32.730 Emily Giant: Is not unreceived.
604 01:01:33.630 ⇒ 01:01:35.089 Emily Giant: And is not canceled.
605 01:01:35.580 ⇒ 01:01:36.630 Emily Giant: Oh, okay.
606 01:01:36.740 ⇒ 01:01:41.460 Emily Giant: And… this is not… we didn’t do this.
607 01:01:41.750 ⇒ 01:01:45.500 Emily Giant: So, like, what can we do if the data doesn’t make sense, you know?
608 01:01:45.620 ⇒ 01:01:51.939 Emily Giant: I gotta hop, I’m a couple minutes late for a call, but I will… I’ll see you at the…
609 01:01:52.170 ⇒ 01:01:53.170 Emily Giant: Touch base.
610 01:01:53.460 ⇒ 01:01:54.609 Demilade Agboola: Alright, sounds good.
611 01:01:54.610 ⇒ 01:01:55.240 Emily Giant: Bye.