2025-10-20_qa_session_2_baa607e6

Meeting Title: QA Session 2 Date: 2025-10-20 Meeting participants: Emily Giant, Demilade Agboola, perry

---

WEBVTT

1 00:00:02.880 ⇒ 00:00:04.370 Emily Giant: Jeez. God.

2 00:00:11.310 ⇒ 00:00:12.940 Emily Giant: Oh. No.

3 00:00:13.490 ⇒ 00:00:15.000 Emily Giant: Whoopsie daisy.

4 00:01:48.830 ⇒ 00:01:55.200 Demilade Agboola: It’s been a slow day. I’ve had a fuckton of meetings, and AWS has been down, so…

5 00:01:57.480 ⇒ 00:01:59.089 Demilade Agboola: Not the best of days, but…

6 00:01:59.090 ⇒ 00:02:04.150 Emily Giant: No. With AWS going down, too, like, my dbt wouldn’t even load.

7 00:02:04.540 ⇒ 00:02:13.530 Emily Giant: For many hours. I painted a door. I was like, I’m not… I’m not gonna do fake work right now, pretending that I can do things without

8 00:02:14.300 ⇒ 00:02:17.510 Emily Giant: our warehouse working. So, hello!

9 00:02:18.280 ⇒ 00:02:22.349 Emily Giant: You’re almost there, my queen! You’re so close!

10 00:02:23.000 ⇒ 00:02:25.130 Emily Giant: It is very close.

11 00:02:25.130 ⇒ 00:02:30.259 perry: I have one hair that just… I liked it.

12 00:02:30.260 ⇒ 00:02:34.629 Emily Giant: It’s just like… I have a zit right here that I’ve had for over a month.

13 00:02:35.050 ⇒ 00:02:36.180 perry: Oh my god.

14 00:02:36.350 ⇒ 00:02:40.679 Emily Giant: And I don’t know… I’m like, do I go to a doctor at this point? Like…

15 00:02:40.860 ⇒ 00:02:42.000 Emily Giant: I didn’t know that they…

16 00:02:42.000 ⇒ 00:02:43.709 perry: That could be, like, an ingrown.

17 00:02:44.120 ⇒ 00:02:49.430 Emily Giant: it’s something, because I usually, like, I don’t… I mean, when I was younger, sure, but, like…

18 00:02:49.640 ⇒ 00:02:50.350 perry: We’re just like…

19 00:02:50.350 ⇒ 00:02:53.089 Emily Giant: It’s literally golden, I don’t get zits like that.

20 00:02:53.090 ⇒ 00:02:56.200 perry: Those are just like, oh, it’s healed for 12 hours, but it’s back.

21 00:02:56.200 ⇒ 00:02:59.760 Emily Giant: Yeah, it looked okay this morning, but then it got, like, a new…

22 00:03:00.020 ⇒ 00:03:02.680 Emily Giant: breath of fresh air, I guess, and just…

23 00:03:02.680 ⇒ 00:03:03.379 perry: A new life.

24 00:03:03.800 ⇒ 00:03:06.260 Emily Giant: came back with a vengeance, so…

25 00:03:06.260 ⇒ 00:03:07.640 perry: Jay, though.

26 00:03:07.650 ⇒ 00:03:14.750 Emily Giant: Yeah, I’m giving it, like, one more week before I go and, like, have my face sawed off. I don’t know. Just get a new face implant.

27 00:03:14.750 ⇒ 00:03:15.940 perry: That sounds reasonable.

28 00:03:15.940 ⇒ 00:03:17.479 Emily Giant: Replacement. Full replacement.

29 00:03:18.500 ⇒ 00:03:19.250 Emily Giant: Alright, well, I’m…

30 00:03:19.250 ⇒ 00:03:20.110 perry: transplant.

31 00:03:20.370 ⇒ 00:03:24.790 Emily Giant: I’m hoping that we can, and I… theory.

32 00:03:25.450 ⇒ 00:03:33.920 Emily Giant: recently, pinged Demolati to see if he could maybe stay on and help us, like, bang through that day replacement. Yeah.

33 00:03:34.350 ⇒ 00:03:44.830 Emily Giant: I do too, but I’m just… because it’s so bizarre and complicated, like how it was in there before, I want to make sure that it doesn’t rock the boat too much, because that was the one that was like, day to Saturday!

34 00:03:45.000 ⇒ 00:03:45.560 Emily Giant: like.

35 00:03:45.560 ⇒ 00:03:46.110 perry: Yeah.

36 00:03:46.110 ⇒ 00:03:46.830 Emily Giant: B.

37 00:03:46.830 ⇒ 00:04:01.529 perry: I don’t want to get rid of it, I just want to change the join in the feed. Like, I don’t want… because I don’t want to get rid of it, because I don’t want to ruin anything. So it’s like, I just want to change the join so that if I change that column, because I think it needs a unique identifier between that.

38 00:04:01.530 ⇒ 00:04:01.960 Emily Giant: the purchase.

39 00:04:01.960 ⇒ 00:04:21.920 perry: like, it needs… because the combination of purchase and delivery isn’t unique enough, I don’t think, for some reason. If we can set it up to be unique to purchase and delivery join, that’s fine, but if I need to just literally be like, okay, the number 1 starts here, and carry the number 1 down every single time, so it’s like every purchase day.

40 00:04:21.930 ⇒ 00:04:34.349 perry: So it’s like, one, purchase day, delivery day. Two, purchase day, same delivery day, you know what I mean? Like, that way, like, that’s fine, that’s easy to maintain. So I just want to swap out the joint, but I don’t want to get rid of it, because God knows where that shit’s tied.

41 00:04:34.350 ⇒ 00:04:43.260 Emily Giant: I, yeah, I was like, this seems like… when you had said it on Friday, like, can we just swap it out? I was like, you can! And then I looked at it, and I was like, let’s talk.

42 00:04:43.260 ⇒ 00:04:55.080 perry: I just want to remove it, because it’s not even used in the tables that are in Looker. I know it’s a part of that join of the feed into Looker, though, so I just want to change the join for the feed.

43 00:04:55.080 ⇒ 00:05:02.069 Emily Giant: Okay, that’s cool. I just, like, want to demo out of here just in case, because we’re doing so much stuff with revenue, and then we’re doing…

44 00:05:02.070 ⇒ 00:05:02.580 perry: Totally.

45 00:05:02.580 ⇒ 00:05:15.479 Emily Giant: historical, like, this week, and I’m like, this could really rock the boat. So, anyway, Demolade, I will let you take it away, and we’ll just… I’ll make tickets if things come up.

46 00:05:16.100 ⇒ 00:05:24.760 Demilade Agboola: Okay, I mean, to be fair, you just created the Explore, so it would be helpful if we could, like, look through the Explorer.

47 00:05:25.680 ⇒ 00:05:34.040 Emily Giant: Totally, okay. So… let me log into the looker of it all.

48 00:05:40.110 ⇒ 00:05:40.900 Emily Giant: Okay.

49 00:05:41.630 ⇒ 00:05:45.150 Emily Giant: I was trying to add, nope.

50 00:05:46.630 ⇒ 00:05:48.310 Emily Giant: Sorry.

51 00:05:52.330 ⇒ 00:05:53.470 Emily Giant: One sec…

52 00:05:55.890 ⇒ 00:06:05.180 Emily Giant: That’s why he can’t see it. I didn’t commit it yet. Okay, so, just starting from the top, it’s that same Explorer where I’m building everything onto it, and then,

53 00:06:05.250 ⇒ 00:06:18.630 Emily Giant: going to delete all of the old ones, not going to be your problem, because I probably won’t do that until Friday. But Explorer, and then Shopify Orders, Demolati, if you want to play with it, there are still a couple lingering Shopify things that aren’t… they’re going away.

54 00:06:18.720 ⇒ 00:06:28.750 Emily Giant: It’s in Shopify orders, and, revenue stuff is gonna be in this order line items area, and,

55 00:06:29.420 ⇒ 00:06:30.130 Emily Giant: prices.

56 00:06:30.130 ⇒ 00:06:33.649 perry: So once this is approved, will this just get max?

57 00:06:33.930 ⇒ 00:06:37.550 perry: Pushed out and replaced total revenue-generating orders.

58 00:06:37.700 ⇒ 00:06:38.730 Emily Giant: Okay, cool.

59 00:06:39.210 ⇒ 00:06:42.949 Emily Giant: It’ll be, like, the… where you can do the, like, swap, basically, thing.

60 00:06:43.080 ⇒ 00:06:44.340 perry: Exactly.

61 00:06:44.340 ⇒ 00:06:44.990 Emily Giant: Yep.

62 00:06:45.380 ⇒ 00:06:51.470 perry: My flag on that is that, historically, that has broken custom calculations.

63 00:06:51.910 ⇒ 00:07:02.709 perry: So you might have breaks the next day, because custom calculations do not update in that situation, and there might be dashboards that are revenue-facing where AOV is calc.

64 00:07:02.980 ⇒ 00:07:16.080 perry: And then that would require a refresh on that. So, whenever you do push this out, I would just have people on the lookout for errors, and have them send them your way, because you’ll just have to redo stuff like that.

65 00:07:16.080 ⇒ 00:07:20.569 Emily Giant: Okay, we probably won’t delete the old one for a long time, until we know…

66 00:07:20.570 ⇒ 00:07:27.999 perry: Once you swap it, if you swap it in a table, that calculation will break the minute. It’ll still be there, but you just have to manually redo the calculation.

67 00:07:28.000 ⇒ 00:07:31.460 Emily Giant: Yeah, yeah, with those, like, giant swaps, it does not work.

68 00:07:31.460 ⇒ 00:07:32.290 perry: Yeah.

69 00:07:32.700 ⇒ 00:07:37.480 Emily Giant: So, Demolade, shoot me a query that you would want me to pull up.

70 00:07:37.690 ⇒ 00:07:44.929 Emily Giant: on the Explorer, and we can make sure that it matches mode, too, because Looker gets its own notions about stuff sometimes.

71 00:07:45.930 ⇒ 00:07:56.789 Demilade Agboola: Okay, so I think the… I think we could look at this in, like, two slash maybe three phases. I mean, one is we could look at individual orders, and then two is we can kind of look at, like, revenue.

72 00:07:57.780 ⇒ 00:07:59.180 Demilade Agboola: across the months?

73 00:07:59.690 ⇒ 00:08:14.349 Demilade Agboola: So, like, we can look at that revenue, and then three is we could finally look at revenue across products, also maybe by month as well, so that way we can kind of get an idea of, like, hey, this doesn’t feel right that the highest sellout, the best revenue, is this product.

74 00:08:14.350 ⇒ 00:08:15.060 Emily Giant: I’m sure.

75 00:08:15.060 ⇒ 00:08:16.889 Demilade Agboola: I would assume this would have more.

76 00:08:17.330 ⇒ 00:08:18.040 Emily Giant: Yeah.

77 00:08:18.040 ⇒ 00:08:23.710 Demilade Agboola: So I think… We can start with any order. Is there any other you prefer, Perry?

78 00:08:24.830 ⇒ 00:08:29.070 perry: say that again? Sorry.

79 00:08:29.440 ⇒ 00:08:34.799 Demilade Agboola: So I was thinking we could do three phases. One is we could look at revenue across the different months overall.

80 00:08:34.809 ⇒ 00:08:36.279 perry: Okay, let’s…

81 00:08:36.330 ⇒ 00:08:36.919 Demilade Agboola: We could do.

82 00:08:36.929 ⇒ 00:08:37.259 perry: Yeah.

83 00:08:37.620 ⇒ 00:08:43.429 Demilade Agboola: Products across the different months as well, so you can get a feel of, like, that revenue doesn’t really make much sense for that product.

84 00:08:43.679 ⇒ 00:08:57.660 perry: On 3 is we could just also look at individual orders, so we can, like… Yeah. Let’s start with total time frame. Let’s just do, like, total revenue, total orders in November, October, November, December, January.

85 00:08:57.660 ⇒ 00:09:04.160 perry: And then we can pick and pull orders from there, so we can kind of tackle those two first, and then we can look at product level last.

86 00:09:04.390 ⇒ 00:09:04.890 Demilade Agboola: Gotcha.

87 00:09:04.890 ⇒ 00:09:05.720 perry: Makes sense.

88 00:09:05.720 ⇒ 00:09:06.510 Emily Giant: Yeah.

89 00:09:06.510 ⇒ 00:09:15.900 perry: Because October should be relatively the same, but November and December and January, we’ll start to see changes. Might even throw February in there, just to see what happens, and we can go from there.

90 00:09:16.150 ⇒ 00:09:17.769 Emily Giant: Of what year? This year?

91 00:09:18.030 ⇒ 00:09:19.020 Demilade Agboola: lost.

92 00:09:19.580 ⇒ 00:09:22.569 perry: From… oh, no, no, no, from last year, sorry, so…

93 00:09:22.570 ⇒ 00:09:23.170 Emily Giant: Okay.

94 00:09:23.170 ⇒ 00:09:27.560 perry: calendar October 2024 through calendar February 2025.

95 00:09:28.020 ⇒ 00:09:30.769 Demilade Agboola: But do we have October data, though? I think it’s from, like, November.

96 00:09:30.770 ⇒ 00:09:34.929 Emily Giant: No, because this is Shopify data, so let’s do.

97 00:09:34.930 ⇒ 00:09:38.480 perry: 11, yeah, do 11.1 then, or something like that. It was, like, 11.4 or something like that.

98 00:09:38.480 ⇒ 00:09:42.039 Emily Giant: 11.6. I’ve written it so many darn times.

99 00:09:42.250 ⇒ 00:09:46.970 perry: Because, like, I think of the Monday, because I know the Monday of that week was that, because it was a Wednesday changeover.

100 00:09:49.660 ⇒ 00:09:51.170 Emily Giant: So I’ve got…

101 00:09:51.510 ⇒ 00:10:00.140 Emily Giant: processed at is when the order was fulfilled, right? Because there’s the creation date, that’s when the order was placed, processed is when it was fulfilled.

102 00:10:00.360 ⇒ 00:10:06.730 Emily Giant: Refund, updated. And then… Okay.

103 00:10:08.210 ⇒ 00:10:10.409 Emily Giant: Order line ID…

104 00:10:10.690 ⇒ 00:10:15.459 Emily Giant: So we can just do, like, a general. I want to do, like, order statuses complete or canceled.

105 00:10:16.040 ⇒ 00:10:21.220 Emily Giant: Order… Or do you not care or complete? It should just be, like, revenue recognized.

106 00:10:21.490 ⇒ 00:10:22.879 perry: Revenue recognized is fine.

107 00:10:23.990 ⇒ 00:10:28.839 perry: Everything from that time period should be complete, or else something is majorly weird.

108 00:10:28.840 ⇒ 00:10:29.770 Emily Giant: Yeah…

109 00:10:29.770 ⇒ 00:10:31.790 perry: But still, who knows?

110 00:10:31.830 ⇒ 00:10:36.430 Emily Giant: Fulfillment status, I wish this would… pre-populate.

111 00:10:36.990 ⇒ 00:10:44.379 Emily Giant: I’m just gonna add it to the table so that we know what it is. Okay, let me just run this and see what we’re looking at here.

112 00:10:44.970 ⇒ 00:10:48.490 Demilade Agboola: Also, I would go… Buying.

113 00:10:48.490 ⇒ 00:10:56.140 Emily Giant: Fulfillment status does not exist. Okay, one sec. It’s gonna take a bunch of this, because, like, unless you click on every single…

114 00:10:56.360 ⇒ 00:11:00.850 Emily Giant: thing when you’re making these, it won’t tell you it doesn’t exist until…

115 00:11:01.310 ⇒ 00:11:03.030 Demilade Agboola: Order…

116 00:11:04.080 ⇒ 00:11:05.590 Emily Giant: Line item.

117 00:11:15.040 ⇒ 00:11:16.460 Emily Giant: Backed order lines.

118 00:11:17.730 ⇒ 00:11:19.480 Emily Giant: What was it, fulfillment status?

119 00:11:22.080 ⇒ 00:11:23.710 Demilade Agboola: Yeah, I believe so.

120 00:11:23.990 ⇒ 00:11:24.620 Emily Giant: Okay.

121 00:11:25.150 ⇒ 00:11:25.940 Emily Giant: Wink.

122 00:11:32.010 ⇒ 00:11:33.639 Emily Giant: Just remove that.

123 00:11:39.250 ⇒ 00:11:41.849 Emily Giant: Customer visits order revenue.

124 00:11:42.090 ⇒ 00:11:42.920 Emily Giant: What?

125 00:11:44.830 ⇒ 00:11:48.200 Emily Giant: Shopify customer visits order revenue. Sorry.

126 00:11:59.140 ⇒ 00:12:02.970 Emily Giant: I don’t even know why that’s on there. Okay, so I think I chose the wrong revenue.

127 00:12:03.780 ⇒ 00:12:10.510 Emily Giant: it should be not Shopify customer visits revenue, but we have accrued revenue, fulfilled revenue.

128 00:12:10.820 ⇒ 00:12:14.849 Emily Giant: And then, is there any other one, Demolade, that’s supposed to be on there?

129 00:12:15.030 ⇒ 00:12:17.010 Demilade Agboola: No, those are the two revenue.

130 00:12:18.560 ⇒ 00:12:19.260 Emily Giant: Okay.

131 00:12:33.450 ⇒ 00:12:35.999 Emily Giant: Okay, let’s remove this real quick.

132 00:12:36.290 ⇒ 00:12:37.190 Demilade Agboola: Yeah.

133 00:12:37.680 ⇒ 00:12:42.219 Emily Giant: And the Shopify ID, because that’s going to split it out in a way that we can’t really read it.

134 00:12:42.780 ⇒ 00:12:44.819 Demilade Agboola: And can we also group it by month?

135 00:12:45.700 ⇒ 00:12:49.810 Emily Giant: It should be grouped by month once I remove this to…

136 00:12:50.010 ⇒ 00:12:53.789 Emily Giant: fields, because they were just the individual orders. Okay.

137 00:12:54.250 ⇒ 00:12:56.910 Demilade Agboola: So, it’s giving us… sorry.

138 00:12:57.430 ⇒ 00:12:58.250 Emily Giant: No.

139 00:12:59.190 ⇒ 00:13:01.949 Emily Giant: Can y’all see this okay? Or is it tiny?

140 00:13:02.630 ⇒ 00:13:04.070 perry: It’s a little small, but…

141 00:13:04.090 ⇒ 00:13:07.080 Demilade Agboola: Okay, I can also throw you up on my monitor, and that’ll help.

142 00:13:08.660 ⇒ 00:13:11.599 perry: I just won’t look like I’m paying attention, but I am.

143 00:13:13.260 ⇒ 00:13:18.449 perry: Okay, let me pull up my sheet. Can you flip it, sort it the other way, just really quickly for me, on date?

144 00:13:19.480 ⇒ 00:13:26.529 perry: Okay, so the original numbers we had for… is this delivery? Sales ordered line items processed?

145 00:13:27.040 ⇒ 00:13:31.560 perry: means fulfilled, right? Not processed as in process from a website perspective.

146 00:13:32.630 ⇒ 00:13:34.000 Emily Giant: I believe it means fulfilled.

147 00:13:34.150 ⇒ 00:13:40.150 perry: Okay, so… my original number for… God.

148 00:13:43.210 ⇒ 00:13:48.330 Emily Giant: Is there a delivery date? Because I think the delivery date is how you count revenue.

149 00:13:48.540 ⇒ 00:13:58.559 perry: Yeah, because what I’m seeing is the original numbers be pulled back after, like, initial fixes and everything, but we still know those numbers are low, is 2.9 for the month of November.

150 00:14:01.620 ⇒ 00:14:02.090 Emily Giant: Hmm.

151 00:14:02.090 ⇒ 00:14:03.840 perry: And that’s fiscal?

152 00:14:06.490 ⇒ 00:14:07.850 Emily Giant: Two nights, so that’s not…

153 00:14:07.850 ⇒ 00:14:15.840 perry: I would expect a little variance, because I’m assuming this is calendar, so there’s a little bit of variance there. Yeah. But that means that this should be higher than my number.

154 00:14:16.850 ⇒ 00:14:19.590 Emily Giant: Demolati, does this subtract out refunds?

155 00:14:19.760 ⇒ 00:14:21.180 Emily Giant: I don’t think it does.

156 00:14:21.670 ⇒ 00:14:33.249 Demilade Agboola: So fulfilled revenue just means the revenue that was delivered. Okay. It doesn’t subtract our refunds, but right now, as it stands, it doesn’t have the shipping values, like, the cost of shipping.

157 00:14:33.900 ⇒ 00:14:35.019 Emily Giant: That’s what it is.

158 00:14:35.490 ⇒ 00:14:39.090 perry: cost of shipping from a FedEx perspective, or shipping revenue?

159 00:14:39.090 ⇒ 00:14:40.190 Emily Giant: Shipping revenue.

160 00:14:40.190 ⇒ 00:14:41.080 Demilade Agboola: Revenue.

161 00:14:41.830 ⇒ 00:14:43.200 perry: Why doesn’t it have that?

162 00:14:44.800 ⇒ 00:14:48.769 Demilade Agboola: Because that had to be done at a different level of granularity.

163 00:14:48.770 ⇒ 00:14:53.079 perry: Okay, so those things will be added together then to get to total revenue, though, right?

164 00:14:53.340 ⇒ 00:14:55.610 Demilade Agboola: Yes, so the…

165 00:14:56.630 ⇒ 00:14:58.240 perry: Way… Can you do a…

166 00:14:58.510 ⇒ 00:14:59.350 Emily Giant: Yeah, because…

167 00:14:59.480 ⇒ 00:15:03.939 Demilade Agboola: It’s gonna be in the fact… do you have fact orders there? Oh, let me just…

168 00:15:03.940 ⇒ 00:15:04.979 Emily Giant: I can pull it up.

169 00:15:05.400 ⇒ 00:15:08.309 Emily Giant: Oh, wait, yes, I do have fact orders. It’s, here.

170 00:15:08.560 ⇒ 00:15:12.080 Demilade Agboola: So, fact orders should have a total shipping…

171 00:15:15.440 ⇒ 00:15:19.769 Demilade Agboola: Toto na… Give me one second…

172 00:15:20.930 ⇒ 00:15:23.269 Emily Giant: You may have it whenever we…

173 00:15:23.270 ⇒ 00:15:29.970 perry: whenever we add that into the table, can we get that plus whatever the revenue measure is, so that I can look at that? Because that’s what the comparison should be.

174 00:15:29.970 ⇒ 00:15:30.470 Emily Giant: Yeah.

175 00:15:30.470 ⇒ 00:15:32.970 perry: For my end, just some spot checking.

176 00:15:33.470 ⇒ 00:15:39.150 Demilade Agboola: Give me one second, let me… hopefully AWS isn’t still throwing it.

177 00:15:40.180 ⇒ 00:15:41.749 perry: I mean, Slack works, so…

178 00:15:43.370 ⇒ 00:15:46.750 perry: Is that what was throwing things? Because I’ve noticed things were slow this morning, is that why?

179 00:15:47.000 ⇒ 00:15:52.899 Emily Giant: I couldn’t even log in to work. Like, I painted a door this morning because…

180 00:15:52.900 ⇒ 00:15:56.890 perry: It says a lot about my workday. It says a lot about my workday that I didn’t notice.

181 00:15:57.640 ⇒ 00:16:03.739 Emily Giant: every tool that I use to do anything worthwhile was offline. So eventually, I just was like, let me.

182 00:16:03.740 ⇒ 00:16:07.059 perry: I, like, slacked Dean. I was like, that’s what I did this morning. I was like.

183 00:16:09.460 ⇒ 00:16:12.080 perry: Tell me you’re about to leave without telling me you’re about to leave.

184 00:16:12.080 ⇒ 00:16:20.240 Emily Giant: Yeah, you know you’re about to leave when. Let me see, I’ll pull up facts… Borders…

185 00:16:21.710 ⇒ 00:16:24.839 Demilade Agboola: Yeah, so I’ll kind of looking at that as well.

186 00:16:27.770 ⇒ 00:16:29.690 Emily Giant: I don’t have it in here, but…

187 00:16:31.760 ⇒ 00:16:35.159 Emily Giant: That does not mean it’s not there, I haven’t updated that in forever.

188 00:16:37.210 ⇒ 00:16:39.220 Demilade Agboola: Man, Redshift is running so slow.

189 00:16:40.150 ⇒ 00:16:43.010 Emily Giant: I know, it’s… So annoying.

190 00:16:45.060 ⇒ 00:16:48.599 Demilade Agboola: Okay, so it’s loaded. Do I have it? Do I have it? Do I have…

191 00:16:49.910 ⇒ 00:16:54.779 Emily Giant: Total lines, quantity, not at the moment, but if I did napkin math.

192 00:16:55.430 ⇒ 00:17:05.460 Emily Giant: Let me get the count of orders, and then we’ll just do, like, some… Sanity checking with…

193 00:17:06.069 ⇒ 00:17:13.739 Demilade Agboola: So what more… So what I can quickly do is… I’m trying to see… dbt working…

194 00:17:14.559 ⇒ 00:17:19.009 Demilade Agboola: I could quickly create… I could quickly sum up the… the values.

195 00:17:19.219 ⇒ 00:17:20.059 Demilade Agboola: Yeah.

196 00:17:20.439 ⇒ 00:17:24.579 Demilade Agboola: For the different months, and then we can do a quick addition to that, so…

197 00:17:25.920 ⇒ 00:17:27.450 Emily Giant: Okay, yeah, that sounds good.

198 00:17:31.660 ⇒ 00:17:36.199 Demilade Agboola: So basically, we’re looking at 2.9? Therefore…

199 00:17:37.640 ⇒ 00:17:42.599 Demilade Agboola: have about 600, 700K in shipping revenue.

200 00:17:47.820 ⇒ 00:17:50.959 Emily Giant: sound like, oh, I see total shipping here. Did it not?

201 00:17:51.300 ⇒ 00:17:52.570 Emily Giant: Turn anything?

202 00:17:57.570 ⇒ 00:17:59.849 Demilade Agboola: Well, I’m not sure.

203 00:18:02.440 ⇒ 00:18:03.080 Demilade Agboola: Okay.

204 00:18:03.080 ⇒ 00:18:04.090 Emily Giant: It’s just blank for now.

205 00:18:04.090 ⇒ 00:18:06.419 perry: So, 41… 41,000…

206 00:18:06.610 ⇒ 00:18:13.280 perry: Because that should be the same, because the shipping doesn’t count as an order. Right. So, 41,823…

207 00:18:15.440 ⇒ 00:18:18.329 Emily Giant: And Demolade, is this units, or suborders?

208 00:18:18.330 ⇒ 00:18:21.909 perry: It has to be, because there’s only 25, 26,000 orders.

209 00:18:21.910 ⇒ 00:18:22.840 Emily Giant: Yes.

210 00:18:22.840 ⇒ 00:18:24.659 perry: From live, so it’s a lot.

211 00:18:24.660 ⇒ 00:18:25.520 Demilade Agboola: I agree.

212 00:18:25.700 ⇒ 00:18:29.620 perry: Yeah, that’s the 1.57 multiplier. Okay. Do we have orders?

213 00:18:37.240 ⇒ 00:18:38.730 perry: You want distinct orders? Yeah.

214 00:18:44.470 ⇒ 00:18:49.850 perry: That’ll always tell us if something’s missing, and then shipping revenue is added on top, like, doing what I said.

215 00:18:51.520 ⇒ 00:18:56.720 perry: Yeah. 24408, I have 25951. Would subscriptions be separate from this?

216 00:18:56.720 ⇒ 00:18:57.500 Emily Giant: -

217 00:18:57.830 ⇒ 00:18:59.729 perry: Subscription should be in this number.

218 00:19:01.490 ⇒ 00:19:03.910 Demilade Agboola: So what’s your number? 20… 21?

219 00:19:03.910 ⇒ 00:19:12.200 perry: 25951 is the fiscal number of orders that we had previously stated for November, so it surprises me that it would go.

220 00:19:12.200 ⇒ 00:19:17.090 Emily Giant: what are the November fiscal dates? Because I think it’s this process stat situation.

221 00:19:17.360 ⇒ 00:19:19.190 perry: 11-4…

222 00:19:20.090 ⇒ 00:19:26.730 perry: through the end of the week to 12.2, because you have to do Monday to Monday. So, 11.4 to 12.2.

223 00:19:26.730 ⇒ 00:19:29.060 Emily Giant: And we’re not gonna be able to get this 2 days’ worth.

224 00:19:29.060 ⇒ 00:19:31.230 perry: No, 12, 2, 24, no, yeah.

225 00:19:32.070 ⇒ 00:19:33.499 Emily Giant: I can just write that, Johnny.

226 00:19:39.780 ⇒ 00:19:42.490 Emily Giant: Well, we’ll try, see what it does for the 4th, but…

227 00:19:43.260 ⇒ 00:19:51.550 Emily Giant: Probably nothing. They’re all time-gated. So, we get what? Like, we get… 7,500 orders a week, roughly.

228 00:19:51.550 ⇒ 00:19:55.290 perry: I guess that’s true. I had… okay, that’s fair, okay.

229 00:19:56.370 ⇒ 00:20:03.279 perry: Nevermind, go back, go back real quick. Go back to how you had it, just go back to the other filters. Well, you could just… you could just hit back. I’m gonna redo this.

230 00:20:03.280 ⇒ 00:20:07.679 Emily Giant: I always forget, you tell me this every time, and I’m like, what? Like, I forget, literally.

231 00:20:07.680 ⇒ 00:20:08.520 perry: hit back.

232 00:20:08.690 ⇒ 00:20:09.679 Emily Giant: Every year.

233 00:20:11.860 ⇒ 00:20:13.240 perry: There you go. Rerun it.

234 00:20:15.210 ⇒ 00:20:23.740 perry: Because I’ll just use… I’m forgetting that there’s that, you’re right, that those two days, we did generate orders that we delivered. So if I look at December 33954,

235 00:20:24.200 ⇒ 00:20:29.180 perry: makes more sense that it’s going up, because I think, if anything, we were pretty convinced we were underreported there.

236 00:20:29.520 ⇒ 00:20:30.070 Emily Giant: Yeah, and this…

237 00:20:30.070 ⇒ 00:20:31.240 perry: 3954.

238 00:20:31.240 ⇒ 00:20:33.559 Emily Giant: Not the fiscal. So, okay.

239 00:20:33.560 ⇒ 00:20:34.010 perry: Exactly.

240 00:20:34.010 ⇒ 00:20:37.899 Emily Giant: quarter of business, I need to add the fiscal dates to the LookML.

241 00:20:38.480 ⇒ 00:20:39.370 Emily Giant: Which is…

242 00:20:39.370 ⇒ 00:20:41.269 perry: Yeah, this all has to match to fiscal.

243 00:20:41.270 ⇒ 00:20:42.800 Emily Giant: Yeah.

244 00:20:42.800 ⇒ 00:20:45.440 perry: So, that makes sense, though, because technically.

245 00:20:46.630 ⇒ 00:20:49.590 perry: New Year’s bleeds, so that makes sense. Wait, go back.

246 00:20:49.870 ⇒ 00:20:54.670 Emily Giant: Sorry, I keep forgetting you can see my screen. I’m still, like, my house is under construction, and I’m on…

247 00:20:54.670 ⇒ 00:20:57.730 perry: 36 for December makes sense.

248 00:20:58.260 ⇒ 00:21:01.290 perry: January being 33 makes sense.

249 00:21:01.950 ⇒ 00:21:03.440 perry: February…

250 00:21:05.070 ⇒ 00:21:16.309 perry: to here being 65,000. This anecdotally makes sense based on just, like, you’re within 2,000 orders every month, which means it’s probably the conversion between calendar to fiscal that’s doing it.

251 00:21:16.310 ⇒ 00:21:16.730 Emily Giant: Yeah.

252 00:21:16.730 ⇒ 00:21:23.240 perry: other side, because I’m looking fiscal. So, anecdotally, those order numbers make sense to me. I’d want to know what the shipping dollars are.

253 00:21:23.240 ⇒ 00:21:26.929 Emily Giant: Yeah, that will make a huge difference. The accrued revenue is…

254 00:21:28.090 ⇒ 00:21:38.419 perry: Yeah, will you throw the total in there? Because then I can just look at the 4-month total, and then whatever Demolade sums for the shipping, we can just add those two together, and I’ll look at the 4-month versus the 4-month, and see how close we are.

255 00:21:38.910 ⇒ 00:21:46.519 Emily Giant: But, Demolade, would you describe accrued versus fulfilled? I’m sure you get it, Perry, but just so that we’re all on the same page with, like…

256 00:21:46.950 ⇒ 00:21:49.400 Emily Giant: This $1 million difference here.

257 00:21:50.280 ⇒ 00:21:53.330 Demilade Agboola: So, the way Shopify keeps track of…

258 00:21:54.530 ⇒ 00:21:59.919 Demilade Agboola: Fulfillment status is once it goes out the door and is fulfilled, like, it’s delivered.

259 00:22:00.310 ⇒ 00:22:03.980 Demilade Agboola: It marks that as a fulfilled order.

260 00:22:04.220 ⇒ 00:22:17.379 Demilade Agboola: However, every single time someone places an order, it does have a monetary value assigned to it. So the way that works in current day terms is, if someone places an order today, or maybe places an order yesterday.

261 00:22:18.050 ⇒ 00:22:20.490 Demilade Agboola: In terms of fulfilled revenue, that would be zero.

262 00:22:21.180 ⇒ 00:22:21.880 perry: Yeah.

263 00:22:21.880 ⇒ 00:22:22.390 Demilade Agboola: But once again.

264 00:22:22.390 ⇒ 00:22:23.690 perry: So, accrued.

265 00:22:23.830 ⇒ 00:22:32.449 perry: So accrued is what will replace total gross revenue, because that’s what is being purchased. Fulfilled is, like, if you want to see during Mother’s Day.

266 00:22:32.940 ⇒ 00:22:39.739 perry: how much of the dollars have we fulfilled versus actually, like, what’s actually gone out the door, you would look at the fulfilled revenue.

267 00:22:40.460 ⇒ 00:22:45.270 Emily Giant: Not necessarily, because I do think a crude… takes into account.

268 00:22:46.860 ⇒ 00:22:48.170 perry: Sorry, I’m saying, like.

269 00:22:48.500 ⇒ 00:23:00.669 perry: if I’m in Mother’s Day, and I’m like, we have $11 million in accrued revenue, but I want to see it’s Wednesday, and I want to see how much of it’s actually gone out the door, I could look at fulfilled, and it would be like, you’ve fulfilled 5 of your accrued 11.

270 00:23:00.960 ⇒ 00:23:02.090 Demilade Agboola: Correct. Exactly.

271 00:23:02.320 ⇒ 00:23:07.869 perry: Got it. But accrued is what will replace total gross revenue in all these dashboards.

272 00:23:09.750 ⇒ 00:23:12.610 perry: Fulfilled is not what should… replace it.

273 00:23:12.610 ⇒ 00:23:15.310 Demilade Agboola: should definitely not replace Total Brushwrap.

274 00:23:15.460 ⇒ 00:23:16.400 perry: Yeah. Because…

275 00:23:16.400 ⇒ 00:23:18.680 Demilade Agboola: It’s not, like, because again… Exactly.

276 00:23:18.820 ⇒ 00:23:24.670 Demilade Agboola: what happens today is basically zero. So you have no revenue for today. Yeah.

277 00:23:24.670 ⇒ 00:23:34.879 perry: Because what we’re trying to keep track of is how much, basically, we’ve booked. So you want that accrued, whether it’s fulfilled or not, that’s what we’re looking at when we’re looking at all this revenue reporting. But we have the option to then also look at

278 00:23:35.180 ⇒ 00:23:36.180 perry: fulfilled.

279 00:23:36.800 ⇒ 00:23:41.510 Emily Giant: So, this is… but essentially, this is revenue recognized, right? Fulfilled.

280 00:23:41.510 ⇒ 00:23:42.020 perry: No.

281 00:23:42.640 ⇒ 00:23:44.939 perry: It’s revenue recognized before it’s fulfilled.

282 00:23:47.450 ⇒ 00:23:50.840 perry: Any completed order is revenue recognized.

283 00:23:50.840 ⇒ 00:23:55.600 Emily Giant: Oh, even if it’s canceled before our end of the bargain is… I always.

284 00:23:55.600 ⇒ 00:24:02.130 perry: So if it is, if it is, if it is placed but not canceled, it’s recognized. It becomes unrecognized when it’s canceled.

285 00:24:02.820 ⇒ 00:24:06.450 Emily Giant: Okay. So if it’s purchased, but not canceled.

286 00:24:06.450 ⇒ 00:24:14.039 perry: it’s still recognized. When a customer canceled it, it becomes not recognized and not fulfilled. So it can be purchased and not fulfilled.

287 00:24:14.370 ⇒ 00:24:15.770 perry: and recognized.

288 00:24:17.030 ⇒ 00:24:21.220 Emily Giant: Okay, so even if it is canceled, you want it to show in this line?

289 00:24:21.220 ⇒ 00:24:24.650 perry: No, once it’s canceled, it goes away. But it can be purchased…

290 00:24:25.120 ⇒ 00:24:28.340 perry: Not fulfilled, and still recognized.

291 00:24:28.560 ⇒ 00:24:29.490 Emily Giant: So…

292 00:24:29.490 ⇒ 00:24:30.830 perry: Until it’s canceled.

293 00:24:30.830 ⇒ 00:24:35.039 Emily Giant: My hesitation here, though, is that these should be equal then, because there’s nothing that would.

294 00:24:35.040 ⇒ 00:24:35.680 perry: No.

295 00:24:35.680 ⇒ 00:24:39.030 Emily Giant: Time period that would not have been fulfilled, right?

296 00:24:39.580 ⇒ 00:24:41.150 Emily Giant: Because this is all in the past.

297 00:24:41.150 ⇒ 00:24:41.620 perry: Yes.

298 00:24:41.620 ⇒ 00:24:46.080 Emily Giant: Maybe booked orders… That are still in the process of being fulfilled.

299 00:24:50.530 ⇒ 00:24:52.960 Emily Giant: So, there’s something in here…

300 00:24:53.760 ⇒ 00:24:56.450 Demilade Agboola: Isn’t fulfilled? Correct.

301 00:24:57.020 ⇒ 00:24:58.250 Emily Giant: But we know, we know that Forsy.

302 00:24:58.250 ⇒ 00:25:00.930 perry: throw… Throw a date, it, like, would…

303 00:25:00.930 ⇒ 00:25:05.319 Demilade Agboola: the month that has the biggest discrepancy. Also count as accrued revenue.

304 00:25:05.580 ⇒ 00:25:07.670 Demilade Agboola: But not fulfilled. I just…

305 00:25:09.410 ⇒ 00:25:10.420 Emily Giant: because of how Shopify.

306 00:25:10.420 ⇒ 00:25:11.640 perry: But we fulfill it.

307 00:25:12.880 ⇒ 00:25:16.569 Emily Giant: we fulfill it, but not the other item in the order. So this is.

308 00:25:16.570 ⇒ 00:25:18.580 perry: But then we’re double counting the accrued.

309 00:25:18.580 ⇒ 00:25:19.220 Emily Giant: Yes.

310 00:25:19.440 ⇒ 00:25:20.889 perry: No, we can’t do that.

311 00:25:20.890 ⇒ 00:25:25.709 Emily Giant: Yeah, it’s counting that. So fulfilled is actually what would replace.

312 00:25:25.710 ⇒ 00:25:26.769 perry: It can’t, though.

313 00:25:27.150 ⇒ 00:25:29.189 Emily Giant: Yeah, I know, because you need that forward… you need…

314 00:25:29.190 ⇒ 00:25:29.620 perry: Yeah.

315 00:25:29.620 ⇒ 00:25:30.519 Emily Giant: Know what’s happening.

316 00:25:30.520 ⇒ 00:25:33.219 perry: You can’t only look at revenue that’s fulfilled so far.

317 00:25:33.590 ⇒ 00:25:34.489 Emily Giant: Okay, let’s pick a…

318 00:25:34.490 ⇒ 00:25:41.159 perry: None of this should look at, like, in either world, once an order’s canceled, it doesn’t exist in either world.

319 00:25:41.590 ⇒ 00:25:45.759 perry: Once an order is forced upgrade, that first item no longer exists towards revenue.

320 00:25:47.320 ⇒ 00:25:51.689 perry: Only the item that is still remaining on the order can count towards revenue.

321 00:25:52.230 ⇒ 00:25:52.900 Demilade Agboola: Okay.

322 00:25:53.270 ⇒ 00:25:57.019 Emily Giant: Yeah, that makes sense. Let’s look at just this day.

323 00:25:57.620 ⇒ 00:25:59.270 Emily Giant: And,

324 00:26:00.560 ⇒ 00:26:05.669 Emily Giant: what else can I add? Like, orders? I want to see, like, if there’s an order that we can pull out that we know.

325 00:26:05.670 ⇒ 00:26:21.449 perry: I would actually look at Valentine’s Day, because you’re gonna have the biggest pool of forced upgrades during that time frame, so you’ll have the most amount of, like, actual test orders where that discrepancy is happening, so you’ll have the most order numbers to look at in terms of diagnosing how you want to fix it.

326 00:26:22.120 ⇒ 00:26:25.830 Emily Giant: Oh, this is funny, it’s because I have… That’s… yeah.

327 00:26:26.770 ⇒ 00:26:30.720 perry: You know what I mean? Like, there’s just the biggest amount of them during the holidays.

328 00:26:31.140 ⇒ 00:26:34.170 perry: And there was a $500,000 discrepancy between them.

329 00:26:34.380 ⇒ 00:26:35.170 perry: So…

330 00:26:38.460 ⇒ 00:26:39.810 Emily Giant: I need to get this out of there.

331 00:26:41.880 ⇒ 00:26:44.609 Emily Giant: Oh, this is… sorry, it’s just the wrong filter.

332 00:26:44.940 ⇒ 00:26:45.700 Emily Giant: Date it.

333 00:26:47.450 ⇒ 00:26:50.429 Emily Giant: We also need delivery date in this table.

334 00:27:01.480 ⇒ 00:27:02.200 Emily Giant: Right.

335 00:27:09.130 ⇒ 00:27:10.020 Emily Giant: Okay.

336 00:27:10.870 ⇒ 00:27:14.479 Emily Giant: And then, what else can we throw on here to see?

337 00:27:23.650 ⇒ 00:27:26.250 Emily Giant: Sorry, I’m trying to think of, like, what would be a good…

338 00:27:26.430 ⇒ 00:27:32.690 Emily Giant: red herring for an order that, like, has a forced upgrade or something. We can do line total amount…

339 00:27:33.920 ⇒ 00:27:35.649 perry: At that point, the AOV will be really high.

340 00:27:35.650 ⇒ 00:27:36.440 Emily Giant: Yeah.

341 00:27:36.440 ⇒ 00:27:37.999 perry: Because it’ll have two items.

342 00:27:39.090 ⇒ 00:27:39.960 Emily Giant: That’s true.

343 00:27:40.910 ⇒ 00:27:43.529 perry: Right, it’ll have two items that count as one order.

344 00:27:44.370 ⇒ 00:27:48.869 perry: And therefore, you just do a table calc for revenue divided by orders.

345 00:27:51.260 ⇒ 00:27:52.850 perry: And sorted on AOV.

346 00:27:54.220 ⇒ 00:27:55.839 Emily Giant: Let’s do this, we have an AOV.

347 00:27:56.760 ⇒ 00:28:01.019 perry: I just… okay, but which AOV is it? Like, is it accrued or is it fulfilled?

348 00:28:02.740 ⇒ 00:28:04.040 Emily Giant: Demolata, do you know?

349 00:28:04.590 ⇒ 00:28:07.299 Demilade Agboola: Sorry, I was looking at something else. I think you had the question.

350 00:28:07.890 ⇒ 00:28:09.040 Emily Giant: AOV.

351 00:28:09.210 ⇒ 00:28:10.680 Emily Giant: This is for the order.

352 00:28:11.380 ⇒ 00:28:15.520 Emily Giant: It’s in Shopify orders and not order line items, so it would be for the whole order.

353 00:28:16.730 ⇒ 00:28:19.719 Demilade Agboola: Could I add an AOV? I don’t think I did.

354 00:28:19.720 ⇒ 00:28:23.329 perry: Yeah, that’s why I would just do a table calc for accrued divided by orders.

355 00:28:23.670 ⇒ 00:28:24.280 Emily Giant: Okay.

356 00:28:29.440 ⇒ 00:28:34.750 perry: But orders also isn’t in here. Oh, distinct orders is, yeah. So I would just do accrued revenue.

357 00:28:35.220 ⇒ 00:28:36.529 perry: You know, you want revenue.

358 00:28:36.810 ⇒ 00:28:39.699 Emily Giant: Yeah. Accrued revenue over distinct orders.

359 00:28:50.320 ⇒ 00:28:55.119 perry: And then once it runs, you can sort it on, yeah, just look at the high ones.

360 00:28:57.130 ⇒ 00:28:59.060 perry: So we can look at that first one right away.

361 00:29:02.830 ⇒ 00:29:05.709 perry: If you go to visualization, it’ll let you actually copy them.

362 00:29:06.360 ⇒ 00:29:07.120 Emily Giant: Oh.

363 00:29:08.120 ⇒ 00:29:11.229 Emily Giant: You know so many things that have been lost in time.

364 00:29:11.230 ⇒ 00:29:13.080 perry: Copied and pasted a lot of data.

365 00:29:13.080 ⇒ 00:29:13.510 Emily Giant: In my back.

366 00:29:14.510 ⇒ 00:29:19.549 perry: So this, yeah, so that’s a good one. So this, let’s look at this. This was a Triple the Unicorn.

367 00:29:20.640 ⇒ 00:29:25.569 perry: It was a triple the satin that we replaced with a triple the unicorn. Wait, go up. Go up for a second.

368 00:29:26.100 ⇒ 00:29:30.240 perry: into the subcateg, I want to see the overview on the right side. The, like, order overview.

369 00:29:30.610 ⇒ 00:29:33.270 perry: Okay, so they ordered 2 triples.

370 00:29:38.350 ⇒ 00:29:40.020 perry: No, they ordered 2 doubles.

371 00:29:40.490 ⇒ 00:29:42.930 Emily Giant: Yeah, there are two doubles.

372 00:29:42.930 ⇒ 00:29:44.820 perry: But that’s too low for two doubles.

373 00:29:45.210 ⇒ 00:29:46.480 perry: 1.30 each.

374 00:29:46.780 ⇒ 00:29:47.530 Emily Giant: Fine.

375 00:29:47.850 ⇒ 00:29:49.850 perry: Those doubles should have been, like, $1.30 each.

376 00:29:50.110 ⇒ 00:29:50.880 Emily Giant: Yeah.

377 00:29:56.390 ⇒ 00:30:01.960 perry: It looks like there’s a 25% promo, so it probably got… yeah, exactly. So this is just the payment summary is wrong.

378 00:30:02.850 ⇒ 00:30:05.850 Emily Giant: Yeah, in Dash. Let me add it to…

379 00:30:05.850 ⇒ 00:30:06.320 perry: Surprising.

380 00:30:08.520 ⇒ 00:30:09.439 perry: But so that…

381 00:30:09.440 ⇒ 00:30:10.000 Emily Giant: who are…

382 00:30:10.000 ⇒ 00:30:12.589 perry: Even though that had a forced upgrade.

383 00:30:15.370 ⇒ 00:30:18.370 perry: When you go back to the shop, what do you… where do you…

384 00:30:18.370 ⇒ 00:30:23.810 Emily Giant: Sorry, I’m trying to add the order to this, so that I can add all the line items, and we can see, like, how this compares.

385 00:30:24.270 ⇒ 00:30:29.169 Emily Giant: If I add each line item to the Shopify breakdown, like, subtotal…

386 00:30:32.890 ⇒ 00:30:37.190 perry: I mean, my guess is that it’s… 328.

387 00:30:38.560 ⇒ 00:30:50.629 perry: A triple the unicorn is 55 times 3 times .8, that’s 132. So, my guess is it’s that 320 plus 2 triples. So, 323 was the total, plus

388 00:30:53.400 ⇒ 00:30:57.139 perry: inch .85 plus 133.23.

389 00:30:58.540 ⇒ 00:30:59.780 perry: 3.3.

390 00:31:00.870 ⇒ 00:31:09.960 perry: That’s 140. Yeah, plus 140, plus 323. Yeah, so what it is, is it’s 2 double the satins, plus 2 triple the unicorns.

391 00:31:10.640 ⇒ 00:31:12.820 perry: Which it shouldn’t be. It should just be…

392 00:31:13.290 ⇒ 00:31:23.930 perry: Because we give them that product at the expense of us, because we don’t, they didn’t pay for that. There’s an option now to charge them more, but that didn’t exist at this point. So what the only charge and statement on revenue should be

393 00:31:24.050 ⇒ 00:31:25.550 perry: the double the Veronas.

394 00:31:27.500 ⇒ 00:31:27.960 Demilade Agboola: Yep.

395 00:31:28.630 ⇒ 00:31:32.170 perry: the double the Verona dollars should apply to the Triple the Unicorn.

396 00:31:33.220 ⇒ 00:31:34.750 perry: Because we didn’t charge them.

397 00:31:35.240 ⇒ 00:31:39.189 Emily Giant: And that’s usually… What fulfilled revenue? I don’t know why… did they cancel it?

398 00:31:40.630 ⇒ 00:31:44.680 perry: Let’s take this down as an example, because I think this is a good example of a lot of things.

399 00:31:44.960 ⇒ 00:31:45.580 Demilade Agboola: Yeah.

400 00:31:46.240 ⇒ 00:31:54.360 perry: Especially, too, because it has an example of a messed up dash, which I think is important to note, just as people know that, like, I don’t know that Dash is ever gonna get fixed to some degree, so…

401 00:31:54.360 ⇒ 00:31:55.230 Emily Giant: Yeah.

402 00:31:55.230 ⇒ 00:31:56.630 perry: good documents.

403 00:31:56.630 ⇒ 00:32:02.110 Emily Giant: We’re never using it going forward after we get this down,

404 00:32:02.510 ⇒ 00:32:03.960 perry: Do we have to use it for fulfillment.

405 00:32:04.880 ⇒ 00:32:07.510 Emily Giant: For fulfillment, but not for our data.

406 00:32:07.770 ⇒ 00:32:11.140 Emily Giant: Okay, let me just… Bam, somewhere.

407 00:32:11.700 ⇒ 00:32:19.139 Emily Giant: Okay, so that’s a good one to look into. I don’t know why the fulfilled is coming up, though. Is it not showing as fulfilled in Shopify?

408 00:32:19.140 ⇒ 00:32:22.340 perry: Because your process date… go back to your Explorer?

409 00:32:23.430 ⇒ 00:32:24.270 Emily Giant: Yep.

410 00:32:24.270 ⇒ 00:32:25.600 perry: process date.

411 00:32:26.350 ⇒ 00:32:28.440 perry: Like, it was probably purchased.

412 00:32:30.300 ⇒ 00:32:30.790 Emily Giant: Let me just.

413 00:32:30.790 ⇒ 00:32:33.849 perry: Like, the delivery date, the delivery date is probably the 15th.

414 00:32:35.090 ⇒ 00:32:37.979 perry: Yeah, so if you do that, that probably changes it.

415 00:32:37.980 ⇒ 00:32:38.870 Emily Giant: Yep.

416 00:32:39.750 ⇒ 00:32:42.969 Emily Giant: You’re so good at this! We’re gonna miss you!

417 00:32:42.970 ⇒ 00:32:45.460 perry: Well, I would hope it changes it. If it doesn’t, then that’s something new.

418 00:32:45.710 ⇒ 00:32:46.510 Emily Giant: Yeah.

419 00:32:47.600 ⇒ 00:32:50.149 perry: But we’re clear on what that should do, right?

420 00:32:50.150 ⇒ 00:32:51.020 Emily Giant: I couldn’t change anything.

421 00:32:51.020 ⇒ 00:32:51.999 perry: Now it’s weird.

422 00:32:52.320 ⇒ 00:32:52.790 Demilade Agboola: Yeah.

423 00:32:52.790 ⇒ 00:32:57.670 perry: So, this… the way that I would expect this to report, is…

424 00:32:59.520 ⇒ 00:33:07.450 perry: In some ways, I would still expect double the Verona to populate, Mmm…

425 00:33:10.480 ⇒ 00:33:12.380 perry: Also, something weird about this…

426 00:33:13.550 ⇒ 00:33:24.400 perry: the triple the Verona… the double the Verona is being treated as 4 bouquets, which it is, but the triple the unicorn is only being treated as 2 when it’s actually six, so there’s a discrepancy there.

427 00:33:25.870 ⇒ 00:33:28.239 perry: That the unit language isn’t the same.

428 00:33:28.240 ⇒ 00:33:29.000 Emily Giant: Yeah.

429 00:33:30.940 ⇒ 00:33:31.870 Demilade Agboola: to the order.

430 00:33:32.300 ⇒ 00:33:35.850 Demilade Agboola: Okay, 3, 2, 3, okay, look at it in here.

431 00:33:35.850 ⇒ 00:33:39.879 perry: So that’s just odd, that’s not really the most important thing, but that’s odd.

432 00:33:39.960 ⇒ 00:33:43.070 Emily Giant: 4 doubles and 2 triples. That’s…

433 00:33:43.070 ⇒ 00:33:45.850 perry: So, in some ways, I would expect this to report

434 00:33:46.260 ⇒ 00:33:53.590 perry: $0inrevenueonthedoubletheVerona,$312, because that’s the original value of the Verona.

435 00:33:53.850 ⇒ 00:33:55.320 perry: on the unicorn.

436 00:33:57.400 ⇒ 00:34:01.229 perry: 6 units on the Triple the Verona, or Triple the Unicorn.

437 00:34:01.660 ⇒ 00:34:05.709 perry: zero units on the double the Verona, one distinct order.

438 00:34:07.610 ⇒ 00:34:08.820 Emily Giant: I’m gonna export this.

439 00:34:08.820 ⇒ 00:34:09.600 perry: stink?

440 00:34:10.120 ⇒ 00:34:13.380 perry: That’s like a judgment call. I don’t really… you know what?

441 00:34:14.739 ⇒ 00:34:18.319 perry: No, I take that back. I would expect the double Verona to not show up.

442 00:34:19.020 ⇒ 00:34:20.919 Emily Giant: Correct. That’s… that’s what I expected.

443 00:34:20.920 ⇒ 00:34:25.240 perry: That’s the correct answer. The double the corona should only be visible

444 00:34:25.370 ⇒ 00:34:28.250 perry: When you go to the dash order and see what happened.

445 00:34:34.330 ⇒ 00:34:37.589 perry: Well, if you just make a copy pa- if you just paste, Emily?

446 00:34:39.360 ⇒ 00:34:41.520 perry: No, like, down below, if you just paste.

447 00:34:41.870 ⇒ 00:34:47.149 perry: The same thing, like, recopy it and paste it, and then you can just zero out, so you just replicate what it should show.

448 00:34:47.400 ⇒ 00:34:49.900 Emily Giant: And then just zero out the double, the, like.

449 00:34:50.560 ⇒ 00:34:52.460 perry: Zero out those. That should be zero.

450 00:34:52.460 ⇒ 00:34:53.750 Emily Giant: there, right? This is…

451 00:34:53.750 ⇒ 00:34:55.090 perry: It should be 312, yeah.

452 00:34:55.090 ⇒ 00:34:55.729 Emily Giant: Huh.

453 00:34:56.610 ⇒ 00:35:12.210 perry: So the way I would do it, just for, like, sake of when you go back on this, in cell E8 for 306, set that equal to 302… 312 above, in the table above. Like, set it actually equal to, like, the equation. Do it as an equation and equal to, because then you’ll be able to trace your logic.

454 00:35:12.760 ⇒ 00:35:19.939 perry: But do it as the table above, because your table above is incorrect, your table below will be correct, and then you can basically look at what you’re trying to target.

455 00:35:20.210 ⇒ 00:35:21.250 perry: Does this make sense?

456 00:35:21.850 ⇒ 00:35:22.640 Emily Giant: Kind of.

457 00:35:23.620 ⇒ 00:35:25.839 perry: Share me, share me what you’re doing. Share me what you’re doing.

458 00:35:29.120 ⇒ 00:35:35.979 perry: Because I don’t want you guys to get, like, 3 days from now, and then see the hard-coded 312, and not understand where it came from, or, like, what’s going on.

459 00:35:38.370 ⇒ 00:35:41.089 Emily Giant: So this line would have, like, a strikethrough, right?

460 00:35:42.520 ⇒ 00:35:43.840 perry: Yeah, here, let me open it.

461 00:35:44.230 ⇒ 00:35:45.960 perry: I lost something else for a second.

462 00:35:46.830 ⇒ 00:35:54.280 perry: So… what I would expect, and then this would be… I mean, it wouldn’t really have a strikethrough, it just, like, either wouldn’t show up, or it would.

463 00:36:36.210 ⇒ 00:36:41.429 Emily Giant: So, this is funny, because it says 2 times this, and 2 times this. That’s why it says 4 in Shopify.

464 00:36:41.430 ⇒ 00:36:42.629 perry: I don’t even know about this.

465 00:36:42.630 ⇒ 00:36:46.470 Emily Giant: You know what I mean? Like, a few times, and then 3 times unicorn.

466 00:36:47.500 ⇒ 00:36:48.360 Emily Giant: Well, no.

467 00:36:48.360 ⇒ 00:36:49.350 perry: Zero.

468 00:36:49.350 ⇒ 00:36:50.800 Emily Giant: Makes sense.

469 00:36:51.190 ⇒ 00:36:51.820 Emily Giant: Or I…

470 00:36:51.820 ⇒ 00:36:52.440 perry: Yes.

471 00:36:52.440 ⇒ 00:36:53.340 Emily Giant: 321.

472 00:36:53.340 ⇒ 00:36:54.070 perry: zero.

473 00:36:54.810 ⇒ 00:36:58.810 perry: And then… Your totals should be…

474 00:37:05.350 ⇒ 00:37:10.569 perry: Because I’m doing this as equations so that, like, the math is visible, you know what I mean?

475 00:37:10.570 ⇒ 00:37:11.310 Emily Giant: Yeah.

476 00:37:11.780 ⇒ 00:37:16.110 perry: Because that way, when you guys are… So basically…

477 00:37:26.800 ⇒ 00:37:29.219 Emily Giant: Okay, this does say it’s unfulfilled.

478 00:37:31.730 ⇒ 00:37:33.140 Emily Giant: In Shopify.

479 00:37:33.260 ⇒ 00:37:37.910 Emily Giant: So the fulfilled thing is ac- looks like it’s correct.

480 00:37:38.140 ⇒ 00:37:43.849 perry: Yeah, that’s probably just, like, bad order ingestion shit from us.

481 00:37:45.090 ⇒ 00:37:47.279 perry: So, I would, I would suggest…

482 00:37:48.150 ⇒ 00:37:56.330 perry: post somewhat either pre- or post-publish, a crawl for unfulfilled orders in Shopify, and a way to force-mark them fulfilled.

483 00:37:56.330 ⇒ 00:37:57.150 Emily Giant: Yeah.

484 00:37:57.400 ⇒ 00:38:03.030 perry: And just, like, anything, basically, that is outstanding prior to whatever the current date is.

485 00:38:04.280 ⇒ 00:38:06.280 perry: Force… force them to be fulfilled.

486 00:38:06.990 ⇒ 00:38:11.469 perry: So, how do we… who’ll be responsible for that? Would that be the… No idea.

487 00:38:11.470 ⇒ 00:38:14.780 Emily Giant: Probably Alex, or, maybe Andrew.

488 00:38:17.150 ⇒ 00:38:18.350 Demilade Agboola: Okay, cause…

489 00:38:20.130 ⇒ 00:38:29.600 Demilade Agboola: And when you fulfill the entire order, how does it… how would it propagate over the actual order? Because some stuff were removed, some stuff still were fulfilled.

490 00:38:30.740 ⇒ 00:38:37.350 perry: But the order status is marked as unfulfilled. The order status needs to be changed to fulfilled, because this is an order from Valentine’s Day.

491 00:38:38.570 ⇒ 00:38:56.040 perry: like, I think that there’s just bad orders in the system that were never marked fulfilled when they were by FedEx, as, like, a result of how many orders come in the system. We get this occasionally. So this looks like probably a FedEx issue, that, like, either never arrived, or FedEx missed a scan, or something.

492 00:38:56.040 ⇒ 00:39:01.060 Emily Giant: And so, we just have to operate with the assumption that if something was still marked unfulfilled.

493 00:39:01.060 ⇒ 00:39:11.510 perry: 7 months ago, it was, in fact, fulfilled in one way or another, and we just need to, like, mark those all fulfilled. Because they were, most likely. Unless we have a reason not to.

494 00:39:14.060 ⇒ 00:39:18.169 Emily Giant: It’s ingested as two orders? This is a very weird order.

495 00:39:18.170 ⇒ 00:39:22.759 perry: This strikes me as something weird that happened a long time ago that we’ve probably since fixed.

496 00:39:22.760 ⇒ 00:39:24.870 Emily Giant: Yeah, I hope so.

497 00:39:25.950 ⇒ 00:39:27.030 Emily Giant: Yeah.

498 00:39:28.070 ⇒ 00:39:29.480 Emily Giant: Okay, I’ll look into that one.

499 00:39:29.480 ⇒ 00:39:30.980 perry: easy today, I’m so sorry.

500 00:39:30.980 ⇒ 00:39:32.049 Emily Giant: We all are.

501 00:39:32.950 ⇒ 00:39:37.619 Emily Giant: Okay, so… we need to add shipping.

502 00:39:37.950 ⇒ 00:39:44.430 Emily Giant: And then, as far as this…

503 00:39:45.070 ⇒ 00:39:50.370 Emily Giant: I think that makes sense. I want to see what one looks like that has been marked as fulfilled.

504 00:39:51.720 ⇒ 00:39:53.959 Emily Giant: Fair. Let me go back.

505 00:39:58.340 ⇒ 00:40:00.230 Emily Giant: And back again.

506 00:40:01.990 ⇒ 00:40:03.020 Emily Giant: Ugh.

507 00:40:16.700 ⇒ 00:40:19.850 Emily Giant: the AOV feels good. It doesn’t feel…

508 00:40:19.850 ⇒ 00:40:20.560 perry: Generally.

509 00:40:20.700 ⇒ 00:40:24.820 Emily Giant: Let me sort this…

510 00:40:25.460 ⇒ 00:40:32.070 perry: That 272 with 8… oh, well, you want to look at a fulfilled one. We could look at that 450 one at the top.

511 00:40:32.070 ⇒ 00:40:38.010 Emily Giant: Yeah, this is… Well, that’s a really easy way to send orders over that aren’t fulfilled.

512 00:40:38.550 ⇒ 00:40:39.790 perry: Yeah, you just want…

513 00:40:41.460 ⇒ 00:40:42.080 perry: Yeah.

514 00:40:47.150 ⇒ 00:40:49.150 Emily Giant: Thank you. Just add that.

515 00:40:49.650 ⇒ 00:40:50.690 Emily Giant: Run it.

516 00:40:52.740 ⇒ 00:40:55.650 Emily Giant: I’ll pull it up in here while we’re running it.

517 00:40:57.900 ⇒ 00:41:00.509 Emily Giant: Okay, so this looks legit.

518 00:41:00.510 ⇒ 00:41:01.040 perry: Oh.

519 00:41:03.680 ⇒ 00:41:04.780 Emily Giant: This is also…

520 00:41:04.780 ⇒ 00:41:05.200 perry: shut up.

521 00:41:05.200 ⇒ 00:41:05.830 Emily Giant: Ugh.

522 00:41:06.020 ⇒ 00:41:11.320 Emily Giant: It’s one of these, where the seasonal subscription shows as one, and the unicorn shows as another.

523 00:41:11.320 ⇒ 00:41:20.720 perry: So, the value of this, though, 450 divided by… 25.

524 00:41:21.830 ⇒ 00:41:25.750 perry: 6 cents. So they bought 6 cents, so the value of this…

525 00:41:29.020 ⇒ 00:41:30.340 perry: God, what even is it?

526 00:41:30.940 ⇒ 00:41:33.340 Emily Giant: Let’s see what our Explorer comes up with.

527 00:41:33.340 ⇒ 00:41:36.680 perry: So, the way that this, the way that this should populate.

528 00:41:38.480 ⇒ 00:41:45.700 perry: it’s kind of, like, different depending. So it should populate with… when you look at purchase date, it populates.

529 00:41:46.090 ⇒ 00:41:51.419 perry: As $4.50,because$4.50 is the accumulation of 675 cents.

530 00:41:52.120 ⇒ 00:42:01.080 perry: So, the system needs to, when the suborder comes in, split that sub-order into 6 line items with 6 delivery weeks.

531 00:42:01.960 ⇒ 00:42:05.219 perry: So that the purchase is still $4.50,

532 00:42:05.710 ⇒ 00:42:08.080 perry: But the delivery is 75 each.

533 00:42:08.570 ⇒ 00:42:09.849 perry: Does that make sense?

534 00:42:09.850 ⇒ 00:42:15.240 Emily Giant: So, like, accrued would be $450, fulfilled would be… Whatever. 75.

535 00:42:15.240 ⇒ 00:42:18.249 perry: Yeah, because 6 ends by now has all been fulfilled, yes.

536 00:42:19.150 ⇒ 00:42:21.409 perry: So, like, if you had…

537 00:42:24.420 ⇒ 00:42:30.660 perry: If I had delivery week filter, if I had a delivery week measure in here, I would expect 6 different line items.

538 00:42:32.280 ⇒ 00:42:33.090 Emily Giant: Okay.

539 00:42:33.090 ⇒ 00:42:34.469 perry: Because it’s 6th cents.

540 00:42:34.470 ⇒ 00:42:36.120 Emily Giant: Yeah, that makes sense. I’m checking…

541 00:42:36.120 ⇒ 00:42:37.470 perry: $75.

542 00:42:37.850 ⇒ 00:42:55.889 Emily Giant: So, I’m not sure, like, we QA’d this the other day, and the subscription revenue was coming in correctly. I don’t understand this particular order at all, because we looked at, like… and I know that in the table for subscriptions… let me pull that order from Fact Subscriptions…

543 00:43:00.210 ⇒ 00:43:02.209 Emily Giant: Oh wait, it’s OMS order ID here.

544 00:43:07.460 ⇒ 00:43:08.480 Emily Giant: -

545 00:43:14.700 ⇒ 00:43:19.720 Emily Giant: I don’t have a single line in this table that’s over…

546 00:43:20.060 ⇒ 00:43:28.410 Emily Giant: $275,andIonlyhave3thatareover$275, and those are just, like, people that order multiple products when they order their subscription, so that’s.

547 00:43:28.410 ⇒ 00:43:31.130 perry: And they ordered a subscription and a bouquet and a bit.

548 00:43:31.130 ⇒ 00:43:32.320 Emily Giant: Yes. Yeah.

549 00:43:32.320 ⇒ 00:43:33.280 perry: That gets tricky.

550 00:43:33.420 ⇒ 00:43:41.650 Emily Giant: I don’t know why this is… Why this wouldn’t pull… Ugh, alright.

551 00:43:41.770 ⇒ 00:43:46.140 Emily Giant: weird. We truly did a bunch of QA on subscriptions and, like…

552 00:43:46.140 ⇒ 00:43:46.800 perry: Awesome.

553 00:43:46.800 ⇒ 00:43:52.149 Emily Giant: It’s crazy. Did this not get fulfilled? Was this canceled? No, it was delivered. Okay.

554 00:43:52.640 ⇒ 00:43:53.539 Emily Giant: Alright, back to you.

555 00:43:53.540 ⇒ 00:43:56.769 perry: And also, but do you see what I’m saying? Like, as an example?

556 00:43:57.240 ⇒ 00:44:02.659 perry: It should basically show up As 6 line items.

557 00:44:03.180 ⇒ 00:44:08.800 perry: And as they get fulfilled, the product slots in, because the product won’t assort until a certain point.

558 00:44:09.660 ⇒ 00:44:24.670 perry: Okay. So you’ll have null product lines, because the products don’t fulfill for an order 6 months out, but, like, the way that… like, this… this one would fill each product line, so it would show whatever the send was for that, I don’t even know, was it a double unicorn, whatever, whatever it is.

559 00:44:25.110 ⇒ 00:44:28.820 Demilade Agboola: Sorry, quick question. Why would it be 6 line items?

560 00:44:29.090 ⇒ 00:44:29.970 perry: stands.

561 00:44:30.480 ⇒ 00:44:34.990 Emily Giant: It wouldn’t show for this order ID, though. It would have 6 different order IDs. It would…

562 00:44:34.990 ⇒ 00:44:36.949 perry: suborder, though, aren’t they?

563 00:44:37.260 ⇒ 00:44:38.289 perry: They’re not full independent.

564 00:44:38.290 ⇒ 00:44:41.790 Emily Giant: They don’t send 6 at once, though. It would be by subscription ID, so…

565 00:44:41.790 ⇒ 00:44:48.090 Demilade Agboola: So, like, this is just for this particular order associated with that subscription.

566 00:44:49.100 ⇒ 00:44:50.050 Emily Giant: So if I did subscribe.

567 00:44:50.050 ⇒ 00:44:51.950 perry: But then won’t we… but if we…

568 00:44:53.100 ⇒ 00:44:55.799 Demilade Agboola: So if you fill that by subscription ID, it should go out…

569 00:44:55.800 ⇒ 00:45:01.419 Emily Giant: 6, but it wouldn’t by the order, because every order number’s different for the subscription.

570 00:45:01.900 ⇒ 00:45:06.839 Emily Giant: You know what I mean? Like, it’s gonna have the same subscription ID for every send, but not the same order.

571 00:45:06.840 ⇒ 00:45:09.509 perry: But they all have the same court.

572 00:45:09.990 ⇒ 00:45:11.880 perry: Sub-order ID.

573 00:45:12.030 ⇒ 00:45:16.950 Emily Giant: - no, they’re all different. It’s only the same subscription ID.

574 00:45:17.770 ⇒ 00:45:20.639 perry: So then that order shouldn’t have a value of $4.50.

575 00:45:21.030 ⇒ 00:45:24.980 perry: Because it doesn’t. Correct. That’s one cent. It should have an amortized value.

576 00:45:24.980 ⇒ 00:45:26.090 Emily Giant: Yeah, switch it up.

577 00:45:26.090 ⇒ 00:45:27.539 perry: Okay. Got it.

578 00:45:28.490 ⇒ 00:45:29.899 Emily Giant: Did it just hide?

579 00:45:31.010 ⇒ 00:45:33.600 perry: So, the only time you would see $4.50.

580 00:45:34.220 ⇒ 00:45:35.910 Emily Giant: It’s if you had…

581 00:45:36.980 ⇒ 00:45:39.220 perry: After all the 6 are fulfilled.

582 00:45:40.570 ⇒ 00:45:45.500 perry: All 6 will appear as different order IDs, as amortized at 75.

583 00:45:47.720 ⇒ 00:45:54.489 perry: And, or, if you filtered separately and you were just looking at the subscription ID, the subscription ID would show 450, but those

584 00:45:54.810 ⇒ 00:46:01.829 perry: If you’re just looking at orders delivered in one week, it would only have one order ID with 75 for that one week.

585 00:46:03.390 ⇒ 00:46:05.249 perry: Right? Okay. Yeah.

586 00:46:06.410 ⇒ 00:46:11.359 perry: But the purchase day would all… what does the purchase day link back to? The subscription ID?

587 00:46:12.020 ⇒ 00:46:13.649 perry: Or the day it was triggered.

588 00:46:15.270 ⇒ 00:46:17.479 Emily Giant: What does the subscription ID link back to?

589 00:46:17.770 ⇒ 00:46:19.999 perry: No, the… what is the purchase date linked back.

590 00:46:20.000 ⇒ 00:46:20.760 Emily Giant: Oh.

591 00:46:20.760 ⇒ 00:46:26.169 perry: when it was triggered, or when the subscription ID was purchased, because it should be when the subscription ID was purchased.

592 00:46:27.040 ⇒ 00:46:31.829 perry: The subscription ID purchase date should be the purchase date on all the orders.

593 00:46:33.000 ⇒ 00:46:33.820 Demilade Agboola: Oh.

594 00:46:33.820 ⇒ 00:46:34.340 Emily Giant: honey.

595 00:46:34.340 ⇒ 00:46:35.880 perry: Not the trigger date.

596 00:46:36.060 ⇒ 00:46:36.690 Emily Giant: So it’s not.

597 00:46:36.690 ⇒ 00:46:38.230 perry: Trigger date is internal.

598 00:46:39.620 ⇒ 00:46:42.650 Emily Giant: Gotcha. Okay. I didn’t know that.

599 00:46:42.650 ⇒ 00:46:49.080 perry: So, like, order created date for subscriptions doesn’t really matter, because we dictate that internally. That’s, like, artificial.

600 00:46:49.080 ⇒ 00:46:52.650 Emily Giant: So it would be the subscription start date, which, like, this is really…

601 00:46:52.650 ⇒ 00:47:02.899 perry: The subscription ID purchase date, yeah. Because start date and purchase date are different. Like, during Christmas, people buy their purchase, they purchase them the week of Christmas for their first send to start.

602 00:47:03.060 ⇒ 00:47:15.130 perry: or this is the way it used to be. If start date and purchase date are now synonymous, that’s okay, but start date used to be the day of the first send versus when it’s actually purchased. So the purchase ID, the purchase date.

603 00:47:15.270 ⇒ 00:47:23.110 perry: on any… orders of a subscription should be equal to the purchase date of the subscription ID.

604 00:47:23.760 ⇒ 00:47:27.569 Emily Giant: Okay, so, like, if you have a recurring subscription.

605 00:47:28.040 ⇒ 00:47:33.440 Emily Giant: And you have it for 2 years, all of those purchases are gonna be… For November.

606 00:47:33.440 ⇒ 00:47:33.900 perry: God.

607 00:47:33.900 ⇒ 00:47:35.260 Emily Giant: the past?

608 00:47:35.600 ⇒ 00:47:36.120 Emily Giant: that…

609 00:47:36.120 ⇒ 00:47:36.840 perry: God.

610 00:47:37.120 ⇒ 00:47:39.070 Emily Giant: You know what I mean? Is that… how it works?

611 00:47:39.070 ⇒ 00:47:40.270 perry: Oh, God.

612 00:47:43.930 ⇒ 00:47:46.930 perry: No, because that’s not… the cash is coming in each time.

613 00:47:46.930 ⇒ 00:47:47.740 Emily Giant: Yeah.

614 00:47:47.740 ⇒ 00:47:54.170 perry: So I’m assuming there’s separate logic, because in order to amortize the sends, you have to have separate logics for prepaid versus recurring, right?

615 00:47:54.980 ⇒ 00:47:55.600 Emily Giant: Yeah.

616 00:47:55.660 ⇒ 00:48:02.739 perry: So in the recurring… in the recurring logic, it stays as is, it’s purchased when the start date is.

617 00:48:03.150 ⇒ 00:48:06.349 perry: Because that’s… keeps going. I would leave recurring alone.

618 00:48:06.350 ⇒ 00:48:08.450 Emily Giant: It’s fine, I need to create that, though.

619 00:48:09.430 ⇒ 00:48:12.039 perry: It’s just the prepaid sense.

620 00:48:17.350 ⇒ 00:48:20.680 perry: Yeah, good call. So, prepaid sends alone…

621 00:48:20.890 ⇒ 00:48:22.190 Emily Giant: Prepaid sends.

622 00:48:22.700 ⇒ 00:48:30.490 perry: Each order of a prepaid subscription, the purchase date, should be equal to the purchase date of the subscription ID.

623 00:48:34.920 ⇒ 00:48:37.820 Emily Giant: And then… recurring…

624 00:48:37.820 ⇒ 00:48:40.630 perry: can lead… recurring can be whatever it is.

625 00:48:40.630 ⇒ 00:48:43.850 Emily Giant: Could post to the date that.

626 00:48:43.850 ⇒ 00:48:50.229 perry: whatever the date of the payment, like, whatever you get from Loop on, like, whenever that charges, that’s just what it is.

627 00:48:51.350 ⇒ 00:48:52.120 Emily Giant: Order.

628 00:48:58.560 ⇒ 00:48:59.280 Emily Giant: Okay.

629 00:48:59.660 ⇒ 00:49:03.500 Emily Giant: Subscriptions… Logic.

630 00:49:03.850 ⇒ 00:49:08.120 Emily Giant: for revenue… Prepaid.

631 00:49:08.120 ⇒ 00:49:09.520 perry: I would just say, yeah.

632 00:49:17.370 ⇒ 00:49:21.040 Emily Giant: That’s not that bad, though. That’s not that hard.

633 00:49:21.460 ⇒ 00:49:30.739 Emily Giant: It’s… what’s weird is that these aren’t showing up, like, in the fact subscriptions table, which makes me wonder… select…

634 00:49:31.000 ⇒ 00:49:32.620 Emily Giant: everything from…

635 00:49:32.620 ⇒ 00:49:35.790 perry: So, what if you did the subscription ID instead of the order ID?

636 00:49:36.050 ⇒ 00:49:38.600 Emily Giant: it wouldn’t pull it. Polyatomic loop.

637 00:49:39.540 ⇒ 00:49:42.410 perry: You had those order ID, though, in there, not the subscription ID.

638 00:49:44.620 ⇒ 00:49:50.210 Emily Giant: it didn’t… it should associate them all together. I’m just gonna see if it exists in the raw data.

639 00:49:57.110 ⇒ 00:50:00.719 Emily Giant: Where… I think it’s called something, like, not at all.

640 00:50:01.460 ⇒ 00:50:03.910 Emily Giant: sensible Shopify order number.

641 00:50:08.520 ⇒ 00:50:11.470 perry: I really want Chick-fil-A for dinner, but I’m trying to be good.

642 00:50:11.880 ⇒ 00:50:14.090 Emily Giant: It got expensive. I know that makes me sound.

643 00:50:14.090 ⇒ 00:50:18.359 perry: It’s not even that, I’m just trying not to eat, like, 1,200 calories worth of food.

644 00:50:18.360 ⇒ 00:50:19.460 Emily Giant: waffles.

645 00:50:19.460 ⇒ 00:50:22.969 perry: eyes, and frickin’… Chick-filet a sauce.

646 00:50:24.050 ⇒ 00:50:26.360 Emily Giant: I don’t know, Chick-fil-A’s really good.

647 00:50:26.360 ⇒ 00:50:27.800 perry: so good!

648 00:50:27.800 ⇒ 00:50:35.980 Emily Giant: I had Chinese food, like, Americanized Chinese food for dinner last night, and I don’t know if I’ll ever be the same. Like, I haven’t had it in forever.

649 00:50:35.980 ⇒ 00:50:37.149 perry: It’s so mad.

650 00:50:37.150 ⇒ 00:50:43.990 Emily Giant: It’s just, like, been really weird. Like, I can’t make a good fist. It was so salty.

651 00:50:44.730 ⇒ 00:50:46.099 perry: Yeah, that tracks.

652 00:50:46.540 ⇒ 00:50:49.870 Emily Giant: Alright, let me see if I’m maybe pulling the wrong…

653 00:50:50.200 ⇒ 00:50:55.030 Emily Giant: Because I had to do so much renaming of shit in this model. Let me see…

654 00:50:55.800 ⇒ 00:51:00.060 Emily Giant: And it also might be… Okay, did these all run?

655 00:51:00.310 ⇒ 00:51:01.619 perry: Oh, that’s probably the smart guy.

656 00:51:01.620 ⇒ 00:51:06.540 Demilade Agboola: Also, I’ve gotten the shipping… the shipping values. I would add it to the sheet you just sent.

657 00:51:07.650 ⇒ 00:51:09.210 Emily Giant: Oh. Okay, yeah.

658 00:51:09.880 ⇒ 00:51:11.740 Emily Giant: Alright.

659 00:51:12.400 ⇒ 00:51:13.669 perry: That’s for the 4 months.

660 00:51:14.520 ⇒ 00:51:19.059 Demilade Agboola: Well, I’ve got it for all Shopify, like, all-time Shopify, you know.

661 00:51:19.060 ⇒ 00:51:20.990 perry: Okay, cool, so we can sum it.

662 00:51:21.330 ⇒ 00:51:23.050 Demilade Agboola: Yeah.

663 00:51:23.290 ⇒ 00:51:24.569 Emily Giant: Yeah, why would… is this…

664 00:51:24.570 ⇒ 00:51:27.810 Demilade Agboola: I just asked for access, requested access to the sheet.

665 00:51:28.450 ⇒ 00:51:30.070 Emily Giant: Oh, oh, yep, yep.

666 00:51:45.920 ⇒ 00:51:52.880 Emily Giant: Okay, so is this actually, like, a… I am…

667 00:51:54.670 ⇒ 00:51:59.739 Emily Giant: I don’t know why this is not showing up in the raw data. That’s weird to me.

668 00:52:00.620 ⇒ 00:52:04.060 Emily Giant: Like, this is as far back as it… goes.

669 00:52:19.080 ⇒ 00:52:24.200 Emily Giant: Yeah, this should unequivocally be in Shopify and Loop.

670 00:52:24.510 ⇒ 00:52:27.240 Emily Giant: like… What?

671 00:52:28.770 ⇒ 00:52:30.400 Demilade Agboola: But it’s not showing there.

672 00:52:30.400 ⇒ 00:52:31.250 Emily Giant: No.

673 00:52:31.770 ⇒ 00:52:32.720 Demilade Agboola: functional loop.

674 00:52:33.010 ⇒ 00:52:33.690 Emily Giant: -

675 00:52:34.810 ⇒ 00:52:39.519 Emily Giant: That’s why it looks… it would have the right logic applied to it if it was showing.

676 00:52:39.670 ⇒ 00:52:41.900 Emily Giant: There is…

677 00:52:42.390 ⇒ 00:52:45.390 Demilade Agboola: Oh, is it possible to… can you access Loop, like…

678 00:52:47.290 ⇒ 00:52:49.440 Demilade Agboola: I’ll see if you can see the order itself.

679 00:52:52.530 ⇒ 00:52:54.569 Emily Giant: Oh, the subscription itself.

680 00:53:09.310 ⇒ 00:53:19.420 Emily Giant: Yeah, this is… okay. So the subscription ID is this. Let me try running at least the subscription ID to see if it comes up with anything.

681 00:53:19.540 ⇒ 00:53:20.420 Emily Giant: Where?

682 00:53:26.090 ⇒ 00:53:30.890 Emily Giant: Sorry, let me make sure that’s what ID is, because this is the raw table. Nope.

683 00:53:31.560 ⇒ 00:53:33.539 Emily Giant: ID looks like an order number.

684 00:54:17.150 ⇒ 00:54:22.710 Emily Giant: Okay, well… In this model…

685 00:54:27.320 ⇒ 00:54:36.809 Emily Giant: So, it’s coming through, but if I go one more downstream, it should say 75. It’s, like, the total adjusted. Select everything from…

686 00:54:41.310 ⇒ 00:54:45.730 Emily Giant: Can you use the analytics model? Yeah. So, let’s see if… Analytics.int.

687 00:54:46.150 ⇒ 00:54:49.620 Demilade Agboola: consistently running. Maybe it’s still.

688 00:54:50.170 ⇒ 00:54:51.700 Demilade Agboola: But it should still be better.

689 00:55:17.300 ⇒ 00:55:21.930 Emily Giant: I think adjusted line… yeah, this is correct. Adjusted line item revenue is $75.

690 00:55:23.090 ⇒ 00:55:25.850 Demilade Agboola: Okay, so this still seems good.

691 00:55:27.270 ⇒ 00:55:28.739 Demilade Agboola: Where does it fall off?

692 00:55:28.740 ⇒ 00:55:30.510 Emily Giant: Let me check something.

693 00:55:30.640 ⇒ 00:55:35.539 Emily Giant: I want to make sure that subscriptions is not somehow tied to my staging.

694 00:55:36.540 ⇒ 00:55:37.780 Emily Giant: subscriptions.

695 00:55:41.370 ⇒ 00:55:46.239 Emily Giant: Analytics Fact Subscriptions. Okay.

696 00:55:46.810 ⇒ 00:55:49.199 Emily Giant: Subscription ID, subscription ID…

697 00:55:56.820 ⇒ 00:56:06.390 Emily Giant: It should be tied… so this should be joined to Shopify order lines on… Shopify order ID.

698 00:56:06.730 ⇒ 00:56:11.110 Emily Giant: And… variant.

699 00:56:13.440 ⇒ 00:56:14.420 Emily Giant: Right?

700 00:56:14.640 ⇒ 00:56:16.880 Emily Giant: Maybe that’s what’s the problem here.

701 00:56:18.160 ⇒ 00:56:26.430 Emily Giant: Because if you pull it in mode, from… Order line items.

702 00:56:29.820 ⇒ 00:56:32.020 Emily Giant: What does it say for revenue?

703 00:56:35.680 ⇒ 00:56:39.370 Emily Giant: Okay, so I have a left outer, many to one.

704 00:56:42.270 ⇒ 00:56:52.670 Emily Giant: So that means… okay, so it’s tying… the main model here is what we’re looking at, is order line items. So there are going to be many lines with the Shopify order ID to the one line

705 00:56:53.770 ⇒ 00:56:56.690 Emily Giant: Maybe that’s what it is. Maybe it needs to be many-to-many?

706 00:57:07.500 ⇒ 00:57:15.090 Demilade Agboola: So we have the… so, if you’re saying Shopify fact orders, which is supposed to be… $500 stable itself.

707 00:57:16.400 ⇒ 00:57:19.470 Emily Giant: It’s not time to fact orders, it’s time-to-fact order line items.

708 00:57:19.580 ⇒ 00:57:23.899 Demilade Agboola: So it needs to not just tie on order ID, it needs to also tie on the SKU.

709 00:57:24.570 ⇒ 00:57:25.640 Demilade Agboola: First up.

710 00:57:25.640 ⇒ 00:57:26.940 Emily Giant: Right?

711 00:57:30.130 ⇒ 00:57:33.410 Demilade Agboola: So the order ID will tie it to the order ID.

712 00:57:34.440 ⇒ 00:57:37.889 Demilade Agboola: But I did do the join, though, in other line items.

713 00:57:40.680 ⇒ 00:57:44.269 Emily Giant: What did you use for the join? Because I need to do it again in Looker.

714 00:57:45.000 ⇒ 00:57:49.160 Demilade Agboola: So, for the join… Pentagon…

715 00:58:07.240 ⇒ 00:58:13.000 Demilade Agboola: So I just… I basically just used the subscriptions, order ID to order ID, however…

716 00:58:13.740 ⇒ 00:58:18.479 Demilade Agboola: I also then added a condition when I was using it that the

717 00:58:22.090 ⇒ 00:58:27.690 Demilade Agboola: because what I was trying to do was add the… Revenue to only be fulfilled.

718 00:58:29.530 ⇒ 00:58:33.039 Demilade Agboola: So that’s why I added the attributes product type physical floral.

719 00:58:35.340 ⇒ 00:58:36.809 Emily Giant: Gotcha, okay.

720 00:58:37.220 ⇒ 00:58:38.610 Demilade Agboola: So, if it’s…

721 00:58:42.580 ⇒ 00:58:43.709 Demilade Agboola: Let me see…

722 00:58:50.860 ⇒ 00:58:54.320 Demilade Agboola: Because, like, if we’re trying to, like, the issue join.

723 00:58:54.320 ⇒ 00:58:54.940 Emily Giant: Interesting.

724 00:58:55.090 ⇒ 00:59:01.530 Demilade Agboola: anything from subscriptions, and look at it, it would broadcast that value of subscriptions all over all the entire order ID.

725 00:59:01.530 ⇒ 00:59:06.670 Emily Giant: Yeah, and that’s… yeah, that’s what I’m wondering, if that’s happening. I need to, like, also have variant.

726 00:59:06.850 ⇒ 00:59:08.300 Emily Giant: or product SKU.

727 00:59:08.300 ⇒ 00:59:15.369 Demilade Agboola: Yeah, so you can also… you can also use the product… the product ID, but I didn’t use that, but you could use the product ID, that’s not a problem.

728 00:59:15.960 ⇒ 00:59:16.530 Emily Giant: Okay.

729 00:59:16.770 ⇒ 00:59:17.460 Demilade Agboola: join.

730 00:59:19.140 ⇒ 00:59:25.350 Demilade Agboola: My thing is, what are you trying to see? Because if… is it, is the value in fat subscriptions right now?

731 00:59:26.880 ⇒ 00:59:32.919 Emily Giant: So, if I look in Analytics, It is… 75.

732 00:59:33.400 ⇒ 00:59:34.090 Demilade Agboola: Okay.

733 00:59:34.320 ⇒ 00:59:37.899 Emily Giant: Or the line of adjusted revenue never shows $450.

734 00:59:38.490 ⇒ 00:59:42.750 Demilade Agboola: Okay, can we see it in… In fact, subscriptions.

735 00:59:42.750 ⇒ 00:59:46.280 Emily Giant: Yeah, maybe that’s where it’s bonking. Oops.

736 01:00:13.280 ⇒ 01:00:16.459 Emily Giant: I wanna feel the heat with somebody.

737 01:00:18.470 ⇒ 01:00:24.990 Emily Giant: I wanna dance with somebody, with somebody who loves me.

738 01:00:26.790 ⇒ 01:00:29.800 Emily Giant: Okay, so that’s what we pull in for revenue.

739 01:00:30.710 ⇒ 01:00:33.049 Demilade Agboola: The adjusted line revenue is there.

740 01:00:36.610 ⇒ 01:00:38.510 Demilade Agboola: Understood, yeah…

741 01:00:41.820 ⇒ 01:00:45.490 Demilade Agboola: Okay, so now let’s go to the fact order item.

742 01:00:45.900 ⇒ 01:00:51.889 Demilade Agboola: And can we see what the order line, like, what the order number is? Do we still know that?

743 01:00:52.160 ⇒ 01:00:53.389 Emily Giant: We do. It’s…

744 01:00:56.760 ⇒ 01:00:57.610 Emily Giant: Here.

745 01:00:58.580 ⇒ 01:01:00.609 Emily Giant: Okay. With all these different ones.

746 01:01:02.100 ⇒ 01:01:03.280 Demilade Agboola: So…

747 01:01:06.480 ⇒ 01:01:07.660 Demilade Agboola: Can you copy it?

748 01:01:07.790 ⇒ 01:01:15.009 Demilade Agboola: And then… I was actually thinking, can you copy the query that you had?

749 01:01:15.010 ⇒ 01:01:15.930 Emily Giant: Yeah.

750 01:01:16.580 ⇒ 01:01:17.290 Demilade Agboola: Functions.

751 01:01:17.450 ⇒ 01:01:18.300 Demilade Agboola: Here.

752 01:01:32.330 ⇒ 01:01:36.910 Emily Giant: And this, this is all correct, pre-pit cents remaining, zero. Perry.

753 01:01:37.760 ⇒ 01:01:38.879 Emily Giant: Are you still there?

754 01:01:39.920 ⇒ 01:01:45.800 Emily Giant: Okay, prepaid cycles. In the past, did this say how many they purchased?

755 01:01:46.260 ⇒ 01:01:47.760 Emily Giant: Or did it count down?

756 01:01:48.790 ⇒ 01:01:50.030 Emily Giant: Every time they sent one.

757 01:01:50.030 ⇒ 01:01:51.250 perry: I don’t know.

758 01:01:51.250 ⇒ 01:01:53.209 Emily Giant: Okay. I don’t know if that matters, but…

759 01:01:53.210 ⇒ 01:01:57.789 perry: I would outstand that question to someone on revenue to say just what they wanted to do this time.

760 01:01:58.020 ⇒ 01:01:58.770 Emily Giant: Okay.

761 01:01:58.900 ⇒ 01:02:03.370 Emily Giant: Cause this… shh… this should have been, like, 5, 4, 3, 2, 1.

762 01:02:03.590 ⇒ 01:02:06.160 Emily Giant: Like, the total generated orders, but when it.

763 01:02:06.160 ⇒ 01:02:08.990 perry: Yeah. Well, it should go 1, 2, 3, 4, 5, 6.

764 01:02:08.990 ⇒ 01:02:09.810 Emily Giant: Yeah.

765 01:02:18.920 ⇒ 01:02:21.029 Emily Giant: Does anyone know what prepaid credits are?

766 01:02:22.970 ⇒ 01:02:24.090 perry: I have no idea.

767 01:02:24.090 ⇒ 01:02:26.730 Emily Giant: Me neither. Okay, let me…

768 01:02:30.300 ⇒ 01:02:38.120 Emily Giant: Let me think… So… I’m wondering if the problem is… the SKU.

769 01:02:45.420 ⇒ 01:02:53.479 Emily Giant: Every time a subscription order generates, and this correctly showed in this, but, like, we’re looking at this order right now and seeing something very different.

770 01:02:54.630 ⇒ 01:02:57.950 Emily Giant: Than what we’re seeing in our actual table.

771 01:02:59.120 ⇒ 01:03:00.970 Emily Giant: Which is very weird.

772 01:03:02.020 ⇒ 01:03:07.060 Demilade Agboola: Okay, I… I think I know what the issue is.

773 01:03:07.260 ⇒ 01:03:07.980 Emily Giant: Okay.

774 01:03:08.320 ⇒ 01:03:14.660 Demilade Agboola: So, the issue appears to be that… There isn’t a floral type.

775 01:03:14.770 ⇒ 01:03:16.260 Demilade Agboola: That seems to be there.

776 01:03:16.900 ⇒ 01:03:17.740 Emily Giant: Mmm.

777 01:03:21.650 ⇒ 01:03:22.910 Demilade Agboola: Yes, so…

778 01:03:23.590 ⇒ 01:03:33.259 Emily Giant: Yeah, there isn’t in the shop… in the subscriptions table. However, I can totally pull that in. Like, what the SKU was that they wound up sending? Is that what you.

779 01:03:33.260 ⇒ 01:03:35.209 perry: Well, every subscription is floral.

780 01:03:35.590 ⇒ 01:03:36.930 perry: you’re, like…

781 01:03:37.650 ⇒ 01:03:44.129 Demilade Agboola: Yeah, but, like, okay, so if you run the… I just sent a query, so just, like, can you copy that and run it?

782 01:03:45.860 ⇒ 01:03:55.890 Demilade Agboola: So we have a Shopify, like, product attributes table where we try to categorize every single thing in there as, like, you know, floral.

783 01:03:59.490 ⇒ 01:04:06.210 Demilade Agboola: what we have now, like, if you run the query I just sent, it doesn’t categorize it as floral. None of them are floral.

784 01:04:06.580 ⇒ 01:04:12.260 Demilade Agboola: they are seasonal subscriptions, like, can you run it and you’ll see?

785 01:04:15.320 ⇒ 01:04:18.669 Demilade Agboola: So that… I don’t think those are floral.

786 01:04:19.540 ⇒ 01:04:26.910 Demilade Agboola: will categorize as floral, so that is why the query is literally, like, if the plant type is floral, then the…

787 01:04:28.780 ⇒ 01:04:38.869 Demilade Agboola: not just the line item revenue is broadcast to that item, the floral item, basically, because I didn’t want it to broadcast across every single thing, like, all, you know.

788 01:04:39.260 ⇒ 01:04:43.119 Demilade Agboola: We devised the floral item and everything.

789 01:04:43.260 ⇒ 01:04:46.959 Demilade Agboola: So we also need to look out for situations where, like, this kind of thing occurs.

790 01:04:48.760 ⇒ 01:04:53.910 Emily Giant: Gotcha. Okay, so what I need to do is add the actual SKU that was fulfilled.

791 01:04:54.440 ⇒ 01:04:58.340 Emily Giant: And that way, it will correctly join. Because right now, it’s joining on…

792 01:04:58.930 ⇒ 01:05:06.640 Emily Giant: a SKU, or it’s pulling in a SKU that isn’t the floral SKU, but that’s all available in loop. I can… I was just gonna, like…

793 01:05:06.950 ⇒ 01:05:11.899 Emily Giant: join it by order ID in Looker, but that doesn’t work for this, so…

794 01:05:12.060 ⇒ 01:05:13.849 Emily Giant: Should be very easy to fix.

795 01:05:14.540 ⇒ 01:05:17.800 Demilade Agboola: Okay. In that case, that would be…

796 01:05:18.250 ⇒ 01:05:19.440 Emily Giant: Cool, okay.

797 01:05:19.630 ⇒ 01:05:21.780 Emily Giant: Yep, let me make a ticket…

798 01:05:23.460 ⇒ 01:05:26.859 Demilade Agboola: Also, let me just do one more sanity check.

799 01:06:16.780 ⇒ 01:06:18.180 Emily Giant: Yeah, okay.

800 01:06:19.090 ⇒ 01:06:21.880 Emily Giant: Oh my gosh, this sequel is really crazy.

801 01:06:22.240 ⇒ 01:06:30.940 Emily Giant: Cool, so… This would not, and does not say 450 in…

802 01:06:31.330 ⇒ 01:06:35.699 Emily Giant: the data in mode. It’s just weirdly ingesting here.

803 01:06:36.260 ⇒ 01:06:40.449 Emily Giant: Because it needs to be, instead of the subscription SKU,

804 01:06:41.070 ⇒ 01:06:46.439 Emily Giant: if I add subscription… so, yeah, I see, okay.

805 01:06:46.860 ⇒ 01:06:49.449 Emily Giant: it is pulling the product SKU, but I want…

806 01:06:49.870 ⇒ 01:06:56.969 Emily Giant: this is what I was saying the other day, Demolade, with, like, pulling this out into a subscription SKU column, instead of having it be part of…

807 01:06:58.430 ⇒ 01:07:00.630 Emily Giant: the sent orders?

808 01:07:01.150 ⇒ 01:07:06.580 Emily Giant: But… it shouldn’t actually matter. It would say not…

809 01:07:07.620 ⇒ 01:07:13.859 Emily Giant: 75 for this, though, it would say 75 for this, and then 0 for the base.

810 01:07:14.470 ⇒ 01:07:21.220 Demilade Agboola: Yeah. Yeah. Also, I’m surprised that, like, the Fulfilled still has 450, because it… It does.

811 01:07:21.220 ⇒ 01:07:27.440 Emily Giant: It doesn’t actually make any sense. That’s why I’m like, this has to be a problem with the join that I made in Looker.

812 01:07:29.430 ⇒ 01:07:35.300 Demilade Agboola: Mmm… So, because, like, so connecting… can I just share my screen so I can show you?

813 01:07:35.300 ⇒ 01:07:36.280 Emily Giant: Definitely.

814 01:07:36.710 ⇒ 01:07:37.730 Demilade Agboola: joining us, and…

815 01:07:39.400 ⇒ 01:07:41.060 Emily Giant: in dbt.

816 01:07:43.450 ⇒ 01:07:47.929 Demilade Agboola: Dvt has been glitchy today.

817 01:07:47.930 ⇒ 01:07:49.610 Emily Giant: Yeah, it’s been crap.

818 01:07:51.930 ⇒ 01:07:54.069 Demilade Agboola: I could just use Cressa.

819 01:08:08.720 ⇒ 01:08:10.600 Demilade Agboola: And just move this here.

820 01:08:13.170 ⇒ 01:08:16.000 Demilade Agboola: So, if we look at cursor instead…

821 01:08:40.600 ⇒ 01:08:43.139 Demilade Agboola: Right… that’s when you drove this.

822 01:08:56.160 ⇒ 01:08:59.970 Demilade Agboola: I’m trying to just quickly find it. Alright, so it’s here.

823 01:09:00.430 ⇒ 01:09:07.189 Demilade Agboola: So, what I did was… I basically joined it to subscriptions here.

824 01:09:07.840 ⇒ 01:09:11.390 Demilade Agboola: Based off the subscription’s order ID,

825 01:09:11.870 ⇒ 01:09:16.669 Demilade Agboola: But then I wanted to ensure that it was only the… because I was thinking, like, if I joined it…

826 01:09:17.319 ⇒ 01:09:19.350 Demilade Agboola: by product SKU.

827 01:09:19.979 ⇒ 01:09:34.990 Demilade Agboola: unless each of the… if… unless the product themselves already have the value assigned to it, I need to ensure it’s only the floral that got the value. So then I joined the SKU to the product, like, to the attributes here.

828 01:09:35.800 ⇒ 01:09:36.380 Demilade Agboola: No.

829 01:09:36.830 ⇒ 01:09:44.340 Demilade Agboola: what I’m saying here is, hey, every single time, like, It’s… Fulfilled is true.

830 01:09:45.200 ⇒ 01:09:54.899 Demilade Agboola: Shopify order IDs? No, so that means it’s not a subscription. Use the regular formula to calculate that, which will be the unit price.

831 01:09:55.660 ⇒ 01:09:58.379 Demilade Agboola: All that refund amount item.

832 01:09:58.780 ⇒ 01:10:01.739 Demilade Agboola: And then, when it’s fulfilled.

833 01:10:02.990 ⇒ 01:10:11.989 Demilade Agboola: True, and the sub is not null, so that means it’s a subscription, and the attribute is the floral type, then use the

834 01:10:12.920 ⇒ 01:10:21.319 Demilade Agboola: Adjust the line item revenue. So then, 75, 55, 105, and then use it else, just make it zero.

835 01:10:21.520 ⇒ 01:10:25.060 Demilade Agboola: So, in that case, it should either be a 0.

836 01:10:26.310 ⇒ 01:10:29.819 Demilade Agboola: Of course. That’s why I’m surprised that we’re getting a 450 at all.

837 01:10:29.970 ⇒ 01:10:33.530 Demilade Agboola: There shouldn’t be 450, but then that’s…

838 01:10:33.850 ⇒ 01:10:38.750 Demilade Agboola: If you just go off this table, rather than just trying to join it.

839 01:10:40.050 ⇒ 01:10:45.920 Demilade Agboola: I think that join is replacing some of the… so, like, it’s overwriting some of these values.

840 01:10:48.510 ⇒ 01:10:49.300 Emily Giant: Yeah.

841 01:10:49.860 ⇒ 01:11:07.749 Emily Giant: Okay, let me… let me take a stab at fixing some of that stuff this evening, and adding the product ID as, like, a signed product… assigned subscription product or something, so that, like, you can actually join on the product ID of the floral instead of the subscription, and see if that makes a difference, because…

842 01:11:11.540 ⇒ 01:11:16.849 Emily Giant: I don’t know… What do you see here when you pull that order?

843 01:11:17.250 ⇒ 01:11:22.300 Demilade Agboola: So, in the… Shopify sales items financial.

844 01:11:23.220 ⇒ 01:11:30.599 Demilade Agboola: Here, it actually takes it differently. So normally, it had the whole price here, but it actually just has its 75…

845 01:11:30.880 ⇒ 01:11:35.559 Demilade Agboola: right here… But then, once you go to the…

846 01:11:40.430 ⇒ 01:11:44.400 Demilade Agboola: backdoor line items, it wouldn’t… it makes it zero.

847 01:11:44.930 ⇒ 01:11:48.300 Demilade Agboola: It’s my bad. It makes it zero because…

848 01:11:49.210 ⇒ 01:11:50.310 Emily Giant: Hmm, let’s join.

849 01:11:50.400 ⇒ 01:11:53.489 Demilade Agboola: Floral, yeah, it’s not a floral product. Like…

850 01:11:53.760 ⇒ 01:11:55.920 Demilade Agboola: The second part of it’s not for product.

851 01:11:57.470 ⇒ 01:12:00.239 Demilade Agboola: I mean, there’s some cases where…

852 01:12:08.020 ⇒ 01:12:11.010 Demilade Agboola: Yeah, so it just has bookload revenue and zero.

853 01:12:11.230 ⇒ 01:12:12.450 Emily Giant: Gotcha.

854 01:12:12.710 ⇒ 01:12:19.030 Demilade Agboola: overwriting the logic. So, like, I felt it should either be 075. I mean, obviously, Sun 5 is the right answer.

855 01:12:19.710 ⇒ 01:12:21.679 Demilade Agboola: Like, it should definitely not be 450.

856 01:12:21.680 ⇒ 01:12:22.360 Emily Giant: No.

857 01:12:23.540 ⇒ 01:12:25.120 Emily Giant: Yeah, the 450 is…

858 01:12:25.650 ⇒ 01:12:32.700 Emily Giant: utterly bizarre, considering that that might be, like, an AWS problem, or something like that, because that doesn’t make

859 01:12:33.890 ⇒ 01:12:43.450 Emily Giant: any sense. It’s not showing on the table where I am specifically, like, Referencing in that,

860 01:12:44.180 ⇒ 01:12:46.410 Emily Giant: in that Looker view, so…

861 01:12:48.410 ⇒ 01:13:02.870 Emily Giant: Okay, alright, let me… I… do we need to make any other tickets from this meeting? I know I have to do the prepaid versus recurring logic, I gotta pull in the product SKU, we gotta add shipping. Do you want me to make a ticket for shipping?

862 01:13:07.690 ⇒ 01:13:09.310 Demilade Agboola: For shipping…

863 01:13:10.010 ⇒ 01:13:12.500 Emily Giant: Or if we’re adding shipping revenue to…

864 01:13:12.720 ⇒ 01:13:17.360 Demilade Agboola: Oh, yeah, yeah, yeah, so I will add that to the fact orders table itself.

865 01:13:18.760 ⇒ 01:13:28.989 Demilade Agboola: That shouldn’t be… that shouldn’t be a long fix, basically. Oh, yeah, I sent… I added it in the script… in the… if we want to look at the top line, I added it to the sheet, so…

866 01:13:28.990 ⇒ 01:13:29.789 perry: Oh, right.

867 01:13:30.070 ⇒ 01:13:32.960 Emily Giant: Oh, great, okay. And then, Perry, in the past.

868 01:13:33.270 ⇒ 01:13:42.919 Emily Giant: Do you ever use, like, just the shipping line item, or can we just use it as, like, ugh, let me.

869 01:13:42.920 ⇒ 01:13:44.709 perry: It’s gonna matter in product category.

870 01:13:45.150 ⇒ 01:13:45.620 Emily Giant: Yeah.

871 01:13:45.620 ⇒ 01:13:54.309 perry: So previously, shipping hasn’t been its own product category on the component side, it’s only ever been on the parent side, so that’s been a complication, but if it can be a component, that’d be great.

872 01:13:54.470 ⇒ 01:13:56.769 perry: Okay, so…

873 01:13:57.630 ⇒ 01:14:08.919 perry: the number that we came up with originally in the Explorer was, like, 2.2 million for November. This has 3,75, so about 400,000, so that puts you at 2.6, so that’s slightly shy.

874 01:14:09.320 ⇒ 01:14:10.050 Demilade Agboola: Yeah.

875 01:14:11.340 ⇒ 01:14:23.900 perry: So, it’s close. I mean, I would want to see it again after delivery stuff is added, because I’m sure some of that is fiscal to delivery. But do we have time to go over that feed join? Yeah. To see if that’s an easy swap?

876 01:14:23.900 ⇒ 01:14:24.690 Emily Giant: Yeah, I do.

877 01:14:24.690 ⇒ 01:14:32.599 perry: This is actually something I want to… I want to be able to have time with Wilder to switch it over. Yeah. Because I’ve basically stopped updating those feeds so they’re empty until Wilder puts stuff in.

878 01:14:32.920 ⇒ 01:14:34.499 Emily Giant: Okay, give me one second.

879 01:14:34.500 ⇒ 01:14:35.020 perry: Tell us…

880 01:14:35.020 ⇒ 01:14:36.420 Emily Giant: The restroom, one… one…

881 01:14:36.420 ⇒ 01:14:37.340 perry: No.

882 01:14:38.260 ⇒ 01:14:39.430 perry: Not allowed.

883 01:14:39.940 ⇒ 01:14:40.290 Demilade Agboola: different.

884 01:14:40.290 ⇒ 01:14:56.980 perry: chat GPTing how to get my frickin’ air conditioning unit. In New York, there’s laws around when the building has to turn on the boiler to prevent people from being in, like, 50-degree apartments, and you either have to turn the boiler on to supply hot, like, heat.

885 01:14:57.320 ⇒ 01:15:03.820 perry: by October 1st, or if there’s 5 nights of 50 degree weather, like, in a row.

886 01:15:03.950 ⇒ 01:15:08.680 perry: And it’s been a warm fall, so it hasn’t been cold enough.

887 01:15:08.930 ⇒ 01:15:19.759 perry: But because it’s October, they have to turn the heat on. So now, even though my AC unit isn’t on, there’s hot water in it, so it’s just residually

888 01:15:20.060 ⇒ 01:15:21.190 perry: warm.

889 01:15:21.610 ⇒ 01:15:21.930 Demilade Agboola: But it’s.

890 01:15:21.930 ⇒ 01:15:40.019 perry: also only, like, it’s 70 degrees outside. So I’m like, I’m hot in my apartment, and I want AC, but I can’t have AC, because now my unit has been switched to heat. So I’m, like, frantically, like, how do I get this to cool down? Because at least I’m like, can I at least get outside air, just at the same temperature.

891 01:15:40.230 ⇒ 01:15:40.670 Demilade Agboola: Yeah.

892 01:15:40.670 ⇒ 01:15:51.589 perry: But because there’s a hot coil, like, it’s boiler water, so the air passes through, and then the boiler, like, it’s hot water that it passes by in, like, a metal pipe. So it still warms it up, because it’s a metal pipe.

893 01:15:51.700 ⇒ 01:15:58.119 perry: So I’m, like, frantically in chat GPT, like, how do I… how do I not? And they’re, like, really high tech.

894 01:15:59.090 ⇒ 01:16:00.659 perry: Turn it all the way to high.

895 01:16:00.820 ⇒ 01:16:01.590 perry: Yes.

896 01:16:01.850 ⇒ 01:16:07.219 perry: That’s its solution. Turn it all the way to high, because then the heat will dissipate the quickest.

897 01:16:09.050 ⇒ 01:16:10.970 perry: Great, why didn’t I think of that?

898 01:16:16.270 ⇒ 01:16:31.079 perry: I’m like, can’t I get an option? Because I’m… I’m someone who loves a cold apartment, so I’m like, can’t I get the option to just, like, opt out of heat? Like, I’ll buy a space heater instead of, like, having this. I’d rather be cold, and, like, I will buy a space heater, and I’ll sign a form that says, I don’t need hot. I’m good.

899 01:16:31.080 ⇒ 01:16:38.020 Emily Giant: We can switch houses. My basement does not have walls right now, so it is just the outside world, like, pouring.

900 01:16:38.020 ⇒ 01:16:39.860 perry: Well, in New York.

901 01:16:39.860 ⇒ 01:16:40.740 Emily Giant: So cool!

902 01:16:40.740 ⇒ 01:16:54.360 perry: required. In New York, they’re legally required to give heat during a certain amount of time. Like, the… so they switch the air conditioning. Like, my unit, it’s… they’re all water-based, so water pumps through them, and so water cools, and water heats.

903 01:16:54.360 ⇒ 01:17:04.239 perry: So when they turn the boiler on, that water, just any air that goes through it, the coil is now all hot the whole time, because they turned the boiler on. So I can’t opt out.

904 01:17:04.690 ⇒ 01:17:05.370 Emily Giant: Oh, good.

905 01:17:05.370 ⇒ 01:17:05.910 perry: stop…

906 01:17:05.910 ⇒ 01:17:06.430 Emily Giant: That’s amazing.

907 01:17:06.430 ⇒ 01:17:13.590 perry: And I literally, like, I’m, like, gonna text my super, be like, can you just, like, cut off the water supply to my unit? Or, like…

908 01:17:13.740 ⇒ 01:17:17.480 perry: How do I not get hot water? Because I don’t want hot water in my AC unit.

909 01:17:17.670 ⇒ 01:17:25.040 Emily Giant: Do you get the clink clink? The, like, think? No. Oh my gosh. I would wake up, like, screaming most nights, because my clanker was so…

910 01:17:25.040 ⇒ 01:17:27.179 perry: Oh, right now, I’m sleeping with my window open.

911 01:17:28.790 ⇒ 01:17:31.860 perry: I live on the second floor! I live on the second floor!

912 01:17:32.400 ⇒ 01:17:32.800 Emily Giant: I…

913 01:17:32.800 ⇒ 01:17:34.260 perry: On a very busy street.

914 01:17:34.570 ⇒ 01:17:35.559 Emily Giant: What’s your calling?

915 01:17:36.110 ⇒ 01:17:36.549 Demilade Agboola: That sounds cool.

916 01:17:36.550 ⇒ 01:17:40.490 perry: I’m on Chambers, so I’m on Chambers, which is tricky, because…

917 01:17:41.250 ⇒ 01:17:45.610 perry: I’m in… I’m in Tribeca. So the tricky part about Tribeca is that

918 01:17:46.210 ⇒ 01:18:02.390 perry: when you’re pointing west, there’s a bunch of one-ways in alternating directions. So it’s, like, one way, and then it’s, like, one way, and then it’s, like, one way, and then one way and one way, and chambers is one of the only two ways. So it’s, like, four one-ways in a row, and then chambers is a two-way.

919 01:18:02.500 ⇒ 01:18:06.759 perry: So I’m facing one of the only two ways towards the highway.

920 01:18:06.990 ⇒ 01:18:09.389 perry: That, like, dumps you onto the highway, so people use.

921 01:18:09.390 ⇒ 01:18:09.849 Emily Giant: Did you get to that.

922 01:18:09.850 ⇒ 01:18:10.680 perry: highway.

923 01:18:10.680 ⇒ 01:18:15.270 Emily Giant: I used it to get to the highway. I taught at a New York sports club in Tribeca, like, right there.

924 01:18:15.270 ⇒ 01:18:18.639 perry: Yeah. But then, it literally is like…

925 01:18:19.180 ⇒ 01:18:24.000 perry: Because it’s two lanes, it’s one lane on each side, ambulances and stuff use it.

926 01:18:24.510 ⇒ 01:18:35.139 perry: Because otherwise, if you’re on a one-way, you can get stuck behind other traffic, so then it’s like, all the ambulances use my street, so then it’s just, like, in the middle of the night, and then street cleaning happens 3 times a week, so then street cleaning happens at, like, 12.30 at night.

927 01:18:35.140 ⇒ 01:18:37.530 Emily Giant: Yeah, you will wake up screaming with street cleaning.

928 01:18:37.530 ⇒ 01:18:38.150 perry: path.

929 01:18:39.010 ⇒ 01:18:42.569 perry: Street cleaning, actually, I could sleep through the street cleaning. The street cleaning, honestly, isn’t that big of a.

930 01:18:42.570 ⇒ 01:18:43.389 Emily Giant: a deal.

931 01:18:43.390 ⇒ 01:18:46.840 perry: But it’s just, like, people screaming in the middle of the night, and I’m like, excuse me.

932 01:18:47.270 ⇒ 01:18:50.939 Emily Giant: Hooligans, go to sleep. Yeah, Tribeca is, like.

933 01:18:51.060 ⇒ 01:18:54.090 Emily Giant: It masquerades as quiet, and then it just could.

934 01:18:54.090 ⇒ 01:18:58.340 perry: It is 80% quiet, but it’s… that 20% can pop up.

935 01:18:58.760 ⇒ 01:19:00.159 perry: At various times.

936 01:19:00.160 ⇒ 01:19:03.619 Emily Giant: Which one are we looking at here? The budget purchase forecast, or the forecast?

937 01:19:03.620 ⇒ 01:19:05.780 perry: Oh, God.

938 01:19:05.780 ⇒ 01:19:07.360 Emily Giant: Sorry, I know.

939 01:19:07.360 ⇒ 01:19:09.619 perry: No, I know, I hate, I hate us for this.

940 01:19:10.070 ⇒ 01:19:17.570 perry: How… what’s the easiest way for me to give this to you? Because I know the… I know the… I know the spreadsheet name, and I know the looker.

941 01:19:18.700 ⇒ 01:19:20.200 perry: Chipotle is here, please hold.

942 01:19:20.470 ⇒ 01:19:22.610 Emily Giant: Okay. Oh, you got Chipotle instead of…

943 01:19:22.610 ⇒ 01:19:23.360 perry: remotely.

944 01:19:23.360 ⇒ 01:19:23.840 Emily Giant: Healthcare.

945 01:19:23.840 ⇒ 01:19:26.080 perry: Wow, it’s healthier.

946 01:19:28.310 ⇒ 01:19:30.530 perry: Why does this feel like most food’s been ordered?

947 01:19:30.750 ⇒ 01:19:38.839 Emily Giant: So, we’re still keeping the day sort, right? This is… so, this is called…

948 01:19:39.980 ⇒ 01:19:48.610 Emily Giant: This is… every time it does this, I’m like, hmm… because this is what happened when AWS crapped out this morning, and then did this for 3 hours.

949 01:19:48.940 ⇒ 01:19:50.230 Emily Giant: Oh my god.

950 01:19:50.560 ⇒ 01:19:54.250 Demilade Agboola: I’m using… I’m using the… the… can I quickly share my screen? I’ll show you.

951 01:19:54.250 ⇒ 01:19:54.670 Emily Giant: Yeah.

952 01:19:57.060 ⇒ 01:20:00.529 Demilade Agboola: So I’m using the, like, dbt, like, cursor, like, just…

953 01:20:00.530 ⇒ 01:20:04.180 Emily Giant: Okay, cursor’s working for you? My cursor even stopped working this morning.

954 01:20:05.590 ⇒ 01:20:06.510 Demilade Agboola: That sucks.

955 01:20:06.700 ⇒ 01:20:07.290 Emily Giant: Yeah.

956 01:20:07.480 ⇒ 01:20:08.340 Emily Giant: It was finely.

957 01:20:08.340 ⇒ 01:20:10.880 perry: That’s a lot of it. Oof, that’s awesome.

958 01:20:10.880 ⇒ 01:20:20.990 Emily Giant: I literally couldn’t do my job, so I’ll be working till 8 o’clock tonight, because I was not able to do work this morning, and I painted a door. That’s why I’m wearing this. Like, usually I try, like.

959 01:20:20.990 ⇒ 01:20:21.850 perry: We’re painting the door.

960 01:20:21.850 ⇒ 01:20:22.490 Emily Giant: stair.

961 01:20:23.190 ⇒ 01:20:26.680 perry: Okay, so the measure…

962 01:20:28.290 ⇒ 01:20:31.060 Emily Giant: What’s it called? I can look it up.

963 01:20:31.060 ⇒ 01:20:33.670 perry: I know, I can’t remember… hold on.

964 01:20:33.670 ⇒ 01:20:35.269 Emily Giant: It’s called Component Forecast?

965 01:20:35.270 ⇒ 01:20:40.669 perry: No, that’s different. That’s, the looker, like, the forecast forecast.

966 01:20:42.690 ⇒ 01:20:43.850 perry: Oh, I’m in.

967 01:20:48.490 ⇒ 01:20:50.180 Emily Giant: New component level forecast?

968 01:20:50.790 ⇒ 01:20:52.659 Emily Giant: I built… wait, no, I built a whole new one.

969 01:20:52.660 ⇒ 01:20:55.270 perry: Not component. Okay.

970 01:20:55.600 ⇒ 01:20:56.620 perry: So…

971 01:20:59.830 ⇒ 01:21:04.480 perry: Oh, good lord, why did we name it Forecasting and Planning Combined? We named it Forecasting and Planning Combined.

972 01:21:08.690 ⇒ 01:21:09.489 Emily Giant: It’s right here.

973 01:21:09.490 ⇒ 01:21:10.120 perry: Okay.

974 01:21:10.200 ⇒ 01:21:12.070 Emily Giant: So, right now, we have it run…

975 01:21:13.280 ⇒ 01:21:17.780 perry: people on delivery date week equals forecasted by Monday delivery week, purchase date.

976 01:21:18.340 ⇒ 01:21:20.850 perry: I think it’s that planning combined day thing.

977 01:21:21.230 ⇒ 01:21:25.090 perry: I don’t even know what that is, honestly, anymore. That, I think, is the legacy thing.

978 01:21:25.090 ⇒ 01:21:31.089 Emily Giant: Okay, so this is planning and forecast combined. I think this is the new one. I don’t know why.

979 01:21:31.090 ⇒ 01:21:32.920 perry: Yeah, no, I went to the Looker. I went to the.

980 01:21:32.920 ⇒ 01:21:33.290 Emily Giant: Looker.

981 01:21:33.290 ⇒ 01:21:35.929 perry: this. Like, this is in the current thing, so I know it’s this.

982 01:21:35.930 ⇒ 01:21:41.040 Emily Giant: Yeah, this is brand new. Like, if it’s under this, it means, like, it has been touched recently.

983 01:21:42.710 ⇒ 01:21:47.660 perry: So then, revenue to be booked is what the measure we want to look at. Like, we can look at that as, like.

984 01:21:47.660 ⇒ 01:21:48.270 Emily Giant: do.

985 01:21:49.890 ⇒ 01:21:51.800 Emily Giant: Okay, so…

986 01:21:54.850 ⇒ 01:21:58.080 Demilade Agboola: Wait, so it’s not the join, it’s the actual view?

987 01:21:58.370 ⇒ 01:21:58.980 Emily Giant: The revenue?

988 01:21:58.980 ⇒ 01:22:00.350 perry: I think it’s the join.

989 01:22:00.860 ⇒ 01:22:02.590 Emily Giant: Okay, so That’d be mine.

990 01:22:04.480 ⇒ 01:22:06.079 Emily Giant: Unless you mean the one thing.

991 01:22:06.270 ⇒ 01:22:07.689 Emily Giant: dbt itself.

992 01:22:08.150 ⇒ 01:22:11.509 perry: I don’t know, that’s… that’s the thing. Okay, so in the spreadsheet.

993 01:22:11.950 ⇒ 01:22:18.100 perry: We have Monday day delivery week, so that’s fine, that’s the first line. Delivery day week equals forecasting is that. Those are in there.

994 01:22:18.100 ⇒ 01:22:20.259 Emily Giant: Organized and planning combined per… wait, no, go back.

995 01:22:20.730 ⇒ 01:22:21.830 Emily Giant: Oh, sorry.

996 01:22:22.360 ⇒ 01:22:25.540 Emily Giant: I was gonna pull the spreadsheet up in…

997 01:22:25.540 ⇒ 01:22:26.060 perry: I have a lot.

998 01:22:26.060 ⇒ 01:22:26.600 Emily Giant: easy, because.

999 01:22:26.600 ⇒ 01:22:30.550 perry: Forecast and planning combined purchase date, that is in there. So it’s that last line.

1000 01:22:30.550 ⇒ 01:22:32.350 Emily Giant: This combined… this…

1001 01:22:32.350 ⇒ 01:22:43.029 perry: That last line that we need to figure out, if I remove… one, I want to double check what that forecast and planning combined day… what column that is referencing to, which we might have to do in the DPT,

1002 01:22:43.390 ⇒ 01:22:46.350 perry: Yep, if it’s referencing to what I think it is, that’s what we need to change.

1003 01:22:46.560 ⇒ 01:22:49.110 Emily Giant: Okay, let me see. Day to revenue…

1004 01:22:51.230 ⇒ 01:22:53.160 Emily Giant: We’re gonna go to the view first.

1005 01:22:54.120 ⇒ 01:22:58.730 Emily Giant: It’s not even in there! That’s why. It’s referencing nothing.

1006 01:23:00.100 ⇒ 01:23:01.659 Emily Giant: Okay, that’ll do it.

1007 01:23:02.780 ⇒ 01:23:05.220 perry: Just remove that last line, what happened?

1008 01:23:06.440 ⇒ 01:23:08.179 Emily Giant: Last line. This?

1009 01:23:09.650 ⇒ 01:23:14.000 perry: No, of the many-to-one statement that’s up there, like, if you just pull it…

1010 01:23:14.000 ⇒ 01:23:16.590 Emily Giant: Sorry, it’s actually referencing day.

1011 01:23:17.470 ⇒ 01:23:25.869 Emily Giant: So it’s referencing… this… day of week and time slot, so it’s that crazy Monday 9am, Tuesday day prior.

1012 01:23:25.870 ⇒ 01:23:27.259 perry: What do I want? I’m gone.

1013 01:23:27.260 ⇒ 01:23:27.970 Emily Giant: Okay.

1014 01:23:28.550 ⇒ 01:23:30.380 Emily Giant: Do we need it? At all?

1015 01:23:31.100 ⇒ 01:23:34.780 perry: No, but I don’t know what else is gonna break if we delete it, so I just wanna remove it.

1016 01:23:35.430 ⇒ 01:23:36.240 perry: For now.

1017 01:23:37.620 ⇒ 01:23:38.150 Emily Giant: Okay.

1018 01:23:43.360 ⇒ 01:23:46.850 Emily Giant: I’m just gonna leave it commented out so that if, shit hits the fan.

1019 01:23:47.170 ⇒ 01:23:49.859 Emily Giant: It’s really easy to put back.

1020 01:23:50.810 ⇒ 01:23:54.380 Emily Giant: Oops. Is this not how you comment things out in here?

1021 01:23:56.280 ⇒ 01:23:58.620 Emily Giant: Oh, I see.

1022 01:24:20.960 ⇒ 01:24:23.220 perry: And then before we publish it, can we test it? Like, can I…

1023 01:24:26.060 ⇒ 01:24:29.290 Emily Giant: Okay, let’s go to…

1024 01:24:29.990 ⇒ 01:24:31.409 perry: On a daily performance end?

1025 01:24:41.300 ⇒ 01:24:42.270 Emily Giant: Gonna refresh it.

1026 01:24:43.400 ⇒ 01:24:46.129 perry: No, this is the inventory, I want performance trend.

1027 01:25:04.760 ⇒ 01:25:05.990 perry: Alright, moment of truth.

1028 01:25:06.670 ⇒ 01:25:08.149 Emily Giant: I know,

1029 01:25:10.200 ⇒ 01:25:12.050 Emily Giant: Did it do it? Okay, reload.

1030 01:25:16.840 ⇒ 01:25:19.110 perry: It’s been taking a hot minute all day, so…

1031 01:25:19.580 ⇒ 01:25:22.469 Emily Giant: Yeah, it… I don’t even… hasn’t even refreshed all day?

1032 01:25:23.320 ⇒ 01:25:31.410 perry: Yeah, I have it up. No idea how old it is, but I have it up. Any of these tables down below, too, there’s a lot of them that, if they load, like, either of those three.

1033 01:25:32.210 ⇒ 01:25:34.480 Emily Giant: It is doggy today.

1034 01:25:42.780 ⇒ 01:25:47.710 Emily Giant: Come on… Show me the money, literally and figuratively.

1035 01:25:53.440 ⇒ 01:25:57.070 Emily Giant: I watched a really distributed documentary this weekend called.

1036 01:25:57.070 ⇒ 01:25:57.590 perry: Perfectly.

1037 01:25:57.590 ⇒ 01:25:58.280 Emily Giant: fair?

1038 01:25:58.860 ⇒ 01:26:02.190 Emily Giant: Has anyone watched Perfect Neighbor on Netflix?

1039 01:26:02.900 ⇒ 01:26:04.090 perry: No, who’s in it.

1040 01:26:04.690 ⇒ 01:26:12.900 Emily Giant: no one. It’s all police camp footage of this, like, horrible woman calling the cops on her neighbors, and her, like.

1041 01:26:13.070 ⇒ 01:26:19.060 Emily Giant: essentially… like… I don’t want to ruin it for you, but if.

1042 01:26:19.060 ⇒ 01:26:19.490 perry: still going on.

1043 01:26:19.490 ⇒ 01:26:23.219 Emily Giant: Things affect you for a long time, don’t watch it.

1044 01:26:23.220 ⇒ 01:26:24.290 perry: No, I will not be watching that.

1045 01:26:24.290 ⇒ 01:26:24.970 Emily Giant: Yeah.

1046 01:26:25.500 ⇒ 01:26:28.450 perry: Were we the ones who were talking about, too, the,

1047 01:26:29.240 ⇒ 01:26:31.510 perry: The woman who, like, harassed her child.

1048 01:26:32.140 ⇒ 01:26:32.869 Emily Giant: Oh my gosh.

1049 01:26:32.870 ⇒ 01:26:34.140 perry: I feel like I was talking to you about that.

1050 01:26:34.140 ⇒ 01:26:37.719 Emily Giant: Yeah. The one… yeah. That was…

1051 01:26:38.170 ⇒ 01:26:42.469 Emily Giant: nuts. We get a lot of really choice television in the States, Demolade.

1052 01:26:43.030 ⇒ 01:26:55.250 Emily Giant: This particular documentary she’s talking about, the mother was literally bullying her child, pretending to be a child, telling her that she was, like, a worthless piece of crap that should kill herself, and then…

1053 01:26:55.470 ⇒ 01:26:56.480 Demilade Agboola: For what?

1054 01:26:56.480 ⇒ 01:26:57.280 Emily Giant: Yep.

1055 01:26:57.280 ⇒ 01:26:58.400 perry: yours.

1056 01:26:58.400 ⇒ 01:27:01.139 Emily Giant: It’s called Unknown Number. It is… It’s fucking…

1057 01:27:01.140 ⇒ 01:27:06.699 perry: horrifying. It’s a really, really, really sad, like, state of the world that we live in.

1058 01:27:06.970 ⇒ 01:27:12.489 perry: Will you minimize, Emily, will you hit the three bars on the left of the looker sign, so that it makes everything bigger?

1059 01:27:13.450 ⇒ 01:27:17.509 Emily Giant: Why is this so big? Good God, I hate Looker’s interface, anyway.

1060 01:27:17.510 ⇒ 01:27:23.069 perry: Well, if you just hit the little three lines filter next to the X, it’ll collapse it. No, no, to the left. The one to the left.

1061 01:27:23.290 ⇒ 01:27:27.189 perry: No, no, no. In between the X and the three vertical dots.

1062 01:27:27.340 ⇒ 01:27:30.369 perry: The three, like, pyramid, upside-down pyramid thing?

1063 01:27:31.590 ⇒ 01:27:31.950 perry: Hit that.

1064 01:27:34.000 ⇒ 01:27:34.350 perry: Fair enough.

1065 01:27:34.350 ⇒ 01:27:38.250 Emily Giant: Got it, okay. So this is looking…

1066 01:27:39.260 ⇒ 01:27:42.280 perry: The batteries are running as the ones that I want.

1067 01:27:45.970 ⇒ 01:27:48.150 Emily Giant: So this is right, right? Today’s the 20th.

1068 01:27:49.200 ⇒ 01:27:52.549 Emily Giant: Planned… why is… that doesn’t have anything, though. Is that okay?

1069 01:27:52.550 ⇒ 01:27:54.340 perry: No, because that’s an actual… it should be empty.

1070 01:27:54.340 ⇒ 01:27:55.420 Emily Giant: Oh, gotcha.

1071 01:27:55.780 ⇒ 01:27:57.120 perry: The column to the right.

1072 01:27:57.630 ⇒ 01:28:02.519 perry: the column to the left, and the column, like, those are all the ones that I would expect to populate, so this looks good.

1073 01:28:04.150 ⇒ 01:28:05.520 Emily Giant: Sweet, okay.

1074 01:28:05.520 ⇒ 01:28:06.389 perry: Okay, cool.

1075 01:28:07.040 ⇒ 01:28:10.010 Emily Giant: Huzzah! Alright, well that… was not…

1076 01:28:10.120 ⇒ 01:28:12.290 Emily Giant: As hard as I thought it was gonna be.

1077 01:28:12.290 ⇒ 01:28:15.470 perry: Yeah, no, same, me neither. I thought that was gonna be really fucking annoying to deal with.

1078 01:28:15.470 ⇒ 01:28:19.720 Demilade Agboola: Yep, no, it’s good. Okay, let me know if anything… This is in our data right now.

1079 01:28:20.220 ⇒ 01:28:23.479 perry: Yeah, this is a feed, I’m trying to transition it to,

1080 01:28:24.400 ⇒ 01:28:29.649 perry: finance, and there’s this really weird legacy. Well, I guess the thing I actually have to do…

1081 01:28:32.160 ⇒ 01:28:33.839 perry: So if you remove the join.

1082 01:28:34.670 ⇒ 01:28:38.740 perry: it’s no longer looking at that, so it doesn’t matter, I populated it with those measures.

1083 01:28:38.990 ⇒ 01:28:43.430 perry: So if you’re rooted, it doesn’t matter, right? Like, Okay, cool. Great, nevermind.

1084 01:28:43.720 ⇒ 01:28:44.270 Emily Giant: Yep.

1085 01:28:45.360 ⇒ 01:28:47.749 Emily Giant: It should be fine. That’s, like, a real…

1086 01:28:49.590 ⇒ 01:28:54.420 Emily Giant: It shouldn’t matter whether it joins on that or not, because that’s a,

1087 01:28:54.700 ⇒ 01:29:02.970 Emily Giant: consequence of the dates that are already used in the join, right? Like, those dates… essentially create.

1088 01:29:02.970 ⇒ 01:29:09.170 perry: Exactly. The purchase and delivery combinations are unique in of themselves, which is why I never understood why we had to have this other thing, but…

1089 01:29:09.170 ⇒ 01:29:11.309 Emily Giant: I don’t think you do, yeah.

1090 01:29:11.310 ⇒ 01:29:13.180 perry: I mean, if it breaks, it breaks, we’ll fix it tomorrow.

1091 01:29:13.340 ⇒ 01:29:14.650 Emily Giant: Yeah, alright, cool.

1092 01:29:14.650 ⇒ 01:29:24.510 perry: Because if it breaks, and if Em says something and be like, why is this empty, or why is it broken? You can be like, we’re actively trying to transition this so that finance can own this, so, like, we’re in progress, we’re gonna get it fixed, like…

1093 01:29:24.510 ⇒ 01:29:25.260 Emily Giant: theater.

1094 01:29:25.820 ⇒ 01:29:28.279 Emily Giant: Okay, cool. These all look normal, though.

1095 01:29:29.040 ⇒ 01:29:31.870 perry: Yeah, it’s just those That’s all unrelated, yeah.

1096 01:29:31.900 ⇒ 01:29:33.380 Emily Giant: Okay. The one on the right…

1097 01:29:33.670 ⇒ 01:29:36.909 perry: And then those other tables are the ones that would have broken if they were going to.

1098 01:29:36.910 ⇒ 01:29:37.570 Emily Giant: Okay.

1099 01:29:37.910 ⇒ 01:29:40.010 perry: So, if you can push this out?

1100 01:29:40.260 ⇒ 01:29:41.459 Emily Giant: Yep, I’ll do it right now.

1101 01:29:41.460 ⇒ 01:29:42.370 perry: Oh, wait.

1102 01:29:45.910 ⇒ 01:29:47.290 perry: Wait a minute.

1103 01:29:50.860 ⇒ 01:29:54.930 perry: Go to that top right table, explore, that one.

1104 01:29:55.150 ⇒ 01:29:57.140 perry: Revenue is not $7.73.

1105 01:29:59.410 ⇒ 01:30:01.599 perry: Because that implies an AOS of 250.

1106 01:30:02.240 ⇒ 01:30:03.600 perry: Something’s wrong there.

1107 01:30:04.210 ⇒ 01:30:05.670 Emily Giant: Yeah.

1108 01:30:06.380 ⇒ 01:30:07.650 perry: And I don’t know…

1109 01:30:08.130 ⇒ 01:30:11.820 perry: That’s not what my report looks like right now, so can we explore that for a second?

1110 01:30:15.830 ⇒ 01:30:18.410 Emily Giant: Okay.

1111 01:30:23.190 ⇒ 01:30:26.239 Emily Giant: And this is not what your report looks like right now that you’re looking at?

1112 01:30:26.430 ⇒ 01:30:29.869 Emily Giant: Of the same thing? Oh, well, Dad, it’s because I… yeah.

1113 01:30:30.250 ⇒ 01:30:31.530 perry: It should look the same.

1114 01:30:32.200 ⇒ 01:30:35.309 perry: That’s the thing, the other tables look the same, so this is weird.

1115 01:30:35.980 ⇒ 01:30:38.009 Demilade Agboola: What are you getting for your table?

1116 01:30:38.770 ⇒ 01:30:40.010 perry: 418.

1117 01:30:40.840 ⇒ 01:30:42.620 Demilade Agboola: Oh, so it’s like 300 chemo.

1118 01:30:42.960 ⇒ 01:30:44.339 perry: Yeah, it’s, like, almost double.

1119 01:30:49.500 ⇒ 01:30:52.719 perry: I really hope my AirPods are doing what they need to do in…

1120 01:30:53.140 ⇒ 01:30:56.380 perry: minimizing the sound of me eating chips for you guys, I’m so sorry, that’s not…

1121 01:30:56.380 ⇒ 01:31:01.379 Emily Giant: hear any of it. Fantastic. Good money to pay to Apple.

1122 01:31:03.230 ⇒ 01:31:04.539 Emily Giant: Okay, so if I add that join back.

1123 01:31:04.540 ⇒ 01:31:05.550 perry: Shit.

1124 01:31:05.710 ⇒ 01:31:08.649 Emily Giant: Why is it doing that? That is so… that doesn’t make any sense.

1125 01:31:08.650 ⇒ 01:31:10.670 perry: Wait, can you, wait, wait, wait, try something for me?

1126 01:31:10.670 ⇒ 01:31:11.270 Emily Giant: Yeah.

1127 01:31:11.270 ⇒ 01:31:19.769 perry: Instead, put the current, because this is sales, instead of the forecast and planning combined Monday delivery week, put the sales data delivery week in there.

1128 01:31:28.750 ⇒ 01:31:35.640 perry: undo that is in the last one week, and remove the first one. And I’m gonna see if that changes it. Sometimes it depends on which.

1129 01:31:35.640 ⇒ 01:31:36.370 Emily Giant: Yeah.

1130 01:31:37.080 ⇒ 01:31:38.289 perry: One you look at.

1131 01:31:38.730 ⇒ 01:31:43.940 Emily Giant: I think I spent an entire year just trying to talk to people about dates and Looker. It was never you.

1132 01:31:44.730 ⇒ 01:31:49.230 Emily Giant: But, like, well, did you do it on the date it was purchased, or the date it was delivered?

1133 01:31:49.340 ⇒ 01:31:51.770 Emily Giant: Well, we’re not looking at the same thing, are we?

1134 01:31:52.020 ⇒ 01:31:53.250 perry: No, we’re not.

1135 01:31:53.920 ⇒ 01:32:01.529 perry: We almost never are. Half the questions I’ve ever gotten in the last couple years are like, I see this! I’m like, okay, well, where’d you get that number?

1136 01:32:01.730 ⇒ 01:32:02.470 Emily Giant: Yeah.

1137 01:32:04.280 ⇒ 01:32:05.680 Emily Giant: I can’t wait to, like, just…

1138 01:32:05.940 ⇒ 01:32:10.640 Emily Giant: decimate Looker. Like, just erase things that don’t make sense.

1139 01:32:11.660 ⇒ 01:32:13.310 perry: Someday.

1140 01:32:17.370 ⇒ 01:32:19.420 Emily Giant: Alright, I really hope this works.

1141 01:32:20.550 ⇒ 01:32:25.040 perry: I have a cheat that will work anyway, now that I think about it, if this doesn’t work.

1142 01:32:26.350 ⇒ 01:32:28.190 Emily Giant: No, it didn’t work.

1143 01:32:29.180 ⇒ 01:32:29.800 perry: Love.

1144 01:32:29.910 ⇒ 01:32:35.949 perry: Poor Kay. I don’t understand why it would do that.

1145 01:32:39.430 ⇒ 01:32:42.339 Emily Giant: Can we build in logic to create

1146 01:32:42.560 ⇒ 01:32:47.790 Emily Giant: those things, if… I don’t… I don’t get that either. So, Demolade, just so you have a…

1147 01:32:48.680 ⇒ 01:32:52.040 Demilade Agboola: Visual… ugh, no, AWS is down again, guys.

1148 01:32:53.430 ⇒ 01:32:59.450 perry: Okay, so for now, I have a cheat that’ll work, it’s fine.

1149 01:32:59.660 ⇒ 01:33:08.179 perry: Should I… Because it doesn’t actually need… No. Don’t. Because it doesn’t actually need to, like, say anything, it just needs to be filled, so I can actually just put…

1150 01:33:08.400 ⇒ 01:33:15.420 perry: one, like, three weeks prior Monday, and have that permanently dragged down, and it won’t matter. It’s just looking for anything, I think.

1151 01:33:17.580 ⇒ 01:33:19.130 Emily Giant: I just don’t get why that would…

1152 01:33:19.990 ⇒ 01:33:21.139 perry: I don’t either.

1153 01:33:21.140 ⇒ 01:33:30.090 Emily Giant: It’s this, Demolade, it’s the case when day equals prior Monday, then 1. And it’s just meant to sort it, right? Like… wait, what is day?

1154 01:33:30.090 ⇒ 01:33:32.710 perry: It’s a… it’s a slotting of revenue.

1155 01:33:33.760 ⇒ 01:33:35.199 perry: So maybe we do have to figure.

1156 01:33:35.200 ⇒ 01:33:35.989 Emily Giant: how to get rid of it.

1157 01:33:35.990 ⇒ 01:33:36.710 perry: Yes.

1158 01:33:36.710 ⇒ 01:33:38.280 Emily Giant: Day is, I think…

1159 01:33:39.010 ⇒ 01:33:40.620 Demilade Agboola: Whatever you have in your.

1160 01:33:40.620 ⇒ 01:33:43.220 Emily Giant: Sheeted day. Is it the current date?

1161 01:33:44.490 ⇒ 01:33:48.649 perry: No, day is I have that, and I want to stop populating that.

1162 01:33:48.890 ⇒ 01:33:53.229 perry: So that’s why I was like, get rid of it in the logic, and then I’ll stop carrying it forward.

1163 01:33:57.970 ⇒ 01:33:58.810 Emily Giant: Okay.

1164 01:34:05.640 ⇒ 01:34:06.840 Emily Giant: Yeah, I don’t know.

1165 01:34:07.500 ⇒ 01:34:08.539 Emily Giant: If you have a workaround.

1166 01:34:08.540 ⇒ 01:34:10.850 perry: Oh, you…

1167 01:34:11.160 ⇒ 01:34:18.019 perry: I don’t know why actual would inflate, though. That’s the thing that’s confusing me. I would understand if the plan number changed.

1168 01:34:18.200 ⇒ 01:34:21.090 perry: But if you look at it, the actual is what’s inflating.

1169 01:34:23.210 ⇒ 01:34:25.269 Emily Giant: Yeah, the total gross revenue, you mean, here?

1170 01:34:25.270 ⇒ 01:34:25.970 perry: Yeah.

1171 01:34:27.630 ⇒ 01:34:34.449 perry: Yeah. Like, if anything, I would expect the plan to have been what was weird, because we changed something about the way the plan works.

1172 01:34:36.260 ⇒ 01:34:38.240 Emily Giant: Yeah, I know what you mean, now.

1173 01:34:38.240 ⇒ 01:34:41.709 perry: Can you go… can you go back to the Market Forecast tab?

1174 01:34:43.490 ⇒ 01:34:44.519 perry: Can you go up?

1175 01:34:46.570 ⇒ 01:34:48.500 perry: To where the join is.

1176 01:34:48.500 ⇒ 01:34:49.029 Emily Giant: Oh, oh.

1177 01:34:49.530 ⇒ 01:34:51.680 Emily Giant: It’s in the top-line sales model.

1178 01:34:52.200 ⇒ 01:34:54.739 Emily Giant: Hold on, blah, blah, I’ll just…

1179 01:35:06.810 ⇒ 01:35:08.129 Emily Giant: Pulled forecast wrong?

1180 01:35:08.680 ⇒ 01:35:09.190 perry: No.

1181 01:35:09.390 ⇒ 01:35:10.770 Emily Giant: Cast revenue combined.

1182 01:35:10.770 ⇒ 01:35:11.360 perry: It’s…

1183 01:35:12.230 ⇒ 01:35:14.229 Emily Giant: It’s gotta say that, or it’s…

1184 01:35:19.650 ⇒ 01:35:20.800 perry: Try combined.

1185 01:35:26.280 ⇒ 01:35:28.160 perry: There it is.

1186 01:35:28.160 ⇒ 01:35:28.780 Emily Giant: Yeah.

1187 01:35:34.110 ⇒ 01:35:38.100 perry: Tableau delivery date and planning combined Monday delivery day.

1188 01:35:41.710 ⇒ 01:35:43.000 perry: So…

1189 01:35:48.490 ⇒ 01:35:49.940 perry: Wait, go up for a second.

1190 01:35:54.300 ⇒ 01:35:56.120 perry: Revenue booking pace.

1191 01:35:57.020 ⇒ 01:35:59.540 perry: Those new bookings pasted?

1192 01:35:59.850 ⇒ 01:36:04.889 perry: So… scroll down for a second, sorry. So if I understand this correctly, this is just saying…

1193 01:36:07.540 ⇒ 01:36:11.259 perry: No, that’s all different, that’s all re-delivery stuff, I don’t know what that is.

1194 01:36:11.260 ⇒ 01:36:12.580 Emily Giant: Yeah, this is, like, things that you.

1195 01:36:12.580 ⇒ 01:36:15.309 perry: So in this, this is saying…

1196 01:36:19.670 ⇒ 01:36:21.100 perry: join…

1197 01:36:23.820 ⇒ 01:36:30.609 Emily Giant: It’s saying, join your feed to our Tableau Items XF, or the sales data.

1198 01:36:30.800 ⇒ 01:36:35.989 Emily Giant: through the delivery date Monday week, so that the same dates for Monday

1199 01:36:36.390 ⇒ 01:36:40.169 Emily Giant: Apply… it knows what day to look at.

1200 01:36:40.390 ⇒ 01:36:43.710 Emily Giant: By the delivery date week and the purchase date.

1201 01:36:45.170 ⇒ 01:36:49.769 Emily Giant: So, this… there’s no way that this is… I just can’t imagine.

1202 01:36:50.370 ⇒ 01:36:52.780 Emily Giant: That this would impact.

1203 01:36:54.200 ⇒ 01:37:00.900 Emily Giant: Unless you were looking at Day as… Part of your,

1204 01:37:03.080 ⇒ 01:37:09.569 Emily Giant: I can see how it would affect some reports. Like, if you were looking at it by those date-day things, or the day sort.

1205 01:37:09.570 ⇒ 01:37:11.230 perry: Yeah, but it’s not in there.

1206 01:37:11.230 ⇒ 01:37:11.910 Emily Giant: Hmm.

1207 01:37:12.540 ⇒ 01:37:16.389 perry: So, what is in there… in that…

1208 01:37:17.070 ⇒ 01:37:18.739 perry: Go back to the Explorer real quick.

1209 01:37:21.820 ⇒ 01:37:23.360 perry: Can you go to the data side?

1210 01:37:31.680 ⇒ 01:37:34.810 perry: Base sales data, total gross revenue. So…

1211 01:37:34.810 ⇒ 01:37:41.059 Emily Giant: Let me add… Like, purchase date or something in here, and see if it’s doing some kind of weird…

1212 01:37:41.540 ⇒ 01:37:48.150 perry: Well, wait, because when it was infl… yeah, okay, fine. Because when it was inflating, it was on the other one, so it might be… well, it doesn’t matter.

1213 01:37:57.090 ⇒ 01:38:00.660 Emily Giant: I just want to see if any dates that aren’t today pop up in this.

1214 01:38:00.880 ⇒ 01:38:02.470 Emily Giant: Or aren’t in this…

1215 01:38:02.470 ⇒ 01:38:02.920 perry: Yeah.

1216 01:38:02.920 ⇒ 01:38:04.070 Emily Giant: Last one week.

1217 01:38:04.070 ⇒ 01:38:08.159 perry: So, like, what I’m trying to think about is it, without that unique thing, is it doubling lines?

1218 01:38:08.160 ⇒ 01:38:08.820 Emily Giant: Mmm.

1219 01:38:09.180 ⇒ 01:38:10.950 perry: For some God knows what reason.

1220 01:38:10.950 ⇒ 01:38:13.020 Emily Giant: Yeah, I don’t know why I would do that, though.

1221 01:38:23.660 ⇒ 01:38:26.789 Emily Giant: Does it want one, like, last complete week?

1222 01:38:27.030 ⇒ 01:38:27.940 Emily Giant: Or, like, what is.

1223 01:38:27.940 ⇒ 01:38:28.570 perry: No.

1224 01:38:28.570 ⇒ 01:38:29.380 Emily Giant: Okay.

1225 01:38:29.760 ⇒ 01:38:31.550 perry: That’s just saying, look at the current week.

1226 01:38:40.770 ⇒ 01:38:42.740 Emily Giant: Oh my gosh, this is taking so long.

1227 01:38:57.460 ⇒ 01:39:00.690 perry: Don’t understand. It’s not a function of the many-to-one, right?

1228 01:39:02.790 ⇒ 01:39:05.960 Emily Giant: But there’s not really many… there’s not many to one.

1229 01:39:06.380 ⇒ 01:39:10.080 perry: There’s one delivery date week to one delivery date week, and one…

1230 01:39:11.080 ⇒ 01:39:17.240 Emily Giant: Okay, so it’s including these days, is that okay? Doesn’t seem like it should be okay.

1231 01:39:17.240 ⇒ 01:39:18.490 perry: Yeah, no, it is.

1232 01:39:18.490 ⇒ 01:39:19.440 Emily Giant: Okay, the 27th.

1233 01:39:19.440 ⇒ 01:39:21.250 perry: People, people purchased…

1234 01:39:21.250 ⇒ 01:39:21.899 Emily Giant: Can you just…

1235 01:39:21.900 ⇒ 01:39:23.550 perry: We’ll purchase things, yeah.

1236 01:39:24.630 ⇒ 01:39:26.380 Emily Giant: Not sure why that’s null, though.

1237 01:39:27.630 ⇒ 01:39:30.480 perry: Because I don’t put numbers in for that early.

1238 01:39:30.480 ⇒ 01:39:31.869 Emily Giant: Okay, gotcha.

1239 01:39:33.780 ⇒ 01:39:37.010 Emily Giant: I’m just looking for something that looks, like, weird.

1240 01:39:37.250 ⇒ 01:39:41.469 perry: Will you just sort it, sort it on purchase date? Because it’s sorting on, I think, revenue right now.

1241 01:39:47.190 ⇒ 01:39:48.000 perry: Well, there it is.

1242 01:39:48.000 ⇒ 01:39:48.930 Emily Giant: Jay?

1243 01:39:48.930 ⇒ 01:39:49.260 perry: Yeah.

1244 01:39:50.170 ⇒ 01:39:56.329 perry: So it’s basically saying, 100,000 for yesterday is correct.

1245 01:39:58.410 ⇒ 01:39:59.740 perry: Should be. Yeah.

1246 01:39:59.940 ⇒ 01:40:04.120 perry: So it’s… something is weird with its join on the current day.

1247 01:40:06.470 ⇒ 01:40:07.730 Emily Giant: Yeah.

1248 01:40:11.050 ⇒ 01:40:12.170 Emily Giant: So, instead…

1249 01:40:12.170 ⇒ 01:40:14.900 perry: So the thing that… so the thing that changes…

1250 01:40:15.470 ⇒ 01:40:22.590 perry: from prior week to multi-week, like, in-week, when it goes to in-week, I have 4 Hold on.

1251 01:40:22.830 ⇒ 01:40:24.559 perry: I kind of have a weird idea.

1252 01:40:24.820 ⇒ 01:40:25.829 Emily Giant: So, could I just not do it.

1253 01:40:25.830 ⇒ 01:40:30.000 perry: Can you add… can you add day to this? Add that timeframe thing to this.

1254 01:40:30.280 ⇒ 01:40:33.230 perry: I have, I have an idea. Add the timeframe thing to this.

1255 01:40:35.320 ⇒ 01:40:36.930 perry: I think I know what’s going on.

1256 01:40:37.440 ⇒ 01:40:39.450 perry: And I actually think it’s not a problem.

1257 01:40:39.690 ⇒ 01:40:40.430 Emily Giant: Okay.

1258 01:40:40.930 ⇒ 01:40:41.709 Emily Giant: We can…

1259 01:40:41.710 ⇒ 01:40:44.920 perry: So I think what’s happening is that the forecast is built

1260 01:40:46.250 ⇒ 01:40:55.049 perry: on line items. So for Monday, there are 4 lines, and I break them out and I forecast them so that they aggregate to that 134,

1261 01:40:55.880 ⇒ 01:41:03.429 perry: And I think it’s repeating the total for today on each of those line items, so it aggregates to higher. And the solution is just that I have to condense my sheet.

1262 01:41:04.550 ⇒ 01:41:11.560 perry: Because I’m… the way that I forecast it right now is I do a Monday 9am, a Monday 1pm, a Monday 5pm, and a Monday midnight.

1263 01:41:13.000 ⇒ 01:41:14.570 Emily Giant: Oh, I gotcha, okay.

1264 01:41:14.700 ⇒ 01:41:20.039 perry: So, like, here, wait, let me share my screen real quick, because I’ll show you, and I think… I think my guess is this one’s… this is what’s happening.

1265 01:41:20.200 ⇒ 01:41:23.860 Emily Giant: I do want to find in the, like, budget feed, though, because I found…

1266 01:41:23.860 ⇒ 01:41:27.580 perry: like… Today, a year.

1267 01:41:29.330 ⇒ 01:41:32.920 perry: past planning data Monday, forecasted loading, also purchase date.

1268 01:41:33.810 ⇒ 01:41:35.119 Emily Giant: I think I hit it.

1269 01:41:35.120 ⇒ 01:41:36.770 perry: Probably.

1270 01:41:36.770 ⇒ 01:41:38.719 Emily Giant: HR revenue is the same thing, right?

1271 01:41:39.410 ⇒ 01:41:41.689 perry: I have no idea what that is, but we can figure that out.

1272 01:41:41.690 ⇒ 01:41:44.460 Emily Giant: Because it was joining on that, so…

1273 01:41:44.460 ⇒ 01:41:46.300 perry: I think that’s the thing, because if I, like.

1274 01:41:46.990 ⇒ 01:41:55.750 perry: Because basically how every day prior, but there’s 1, 2, 3, 4 slots, so if you take, what was that, 430… 437 divided by 4?

1275 01:41:56.980 ⇒ 01:41:58.799 perry: 437 divided by…

1276 01:41:59.960 ⇒ 01:42:08.360 perry: is, like, 100 grand, which is probably what we’ve generated today so far. It’s just repeating it 4 times, because in my feed, there are 4 lines.

1277 01:42:09.030 ⇒ 01:42:19.560 perry: So until I get rid of the four lines in my feed, I need to aggregate it to one, and then it won’t repeat. Because right now, there are four combinations of that purchase date and that delivery date.

1278 01:42:19.800 ⇒ 01:42:21.649 Emily Giant: Correct. Yeah, so once you take that.

1279 01:42:21.650 ⇒ 01:42:22.240 perry: I would bet.

1280 01:42:22.240 ⇒ 01:42:26.490 Emily Giant: Everything is in one line instead of separated out by those date days, it will work.

1281 01:42:26.650 ⇒ 01:42:38.750 perry: Exactly, so I think that that’s exactly how we want it, and then I’ll just do a bunch of changes tonight to the data that’s already in there, and then Wilder can… it’ll be unique forward, which is correct, but… Okay, it’s basically…

1282 01:42:39.040 ⇒ 01:42:44.950 perry: It’s the amalgamation of how it’s set up and how we want it to be set up. It’s a convergence of those two, yeah.

1283 01:42:44.950 ⇒ 01:42:47.240 Emily Giant: Yes, you are correct. Okay, that’s… that’s what it is.

1284 01:42:47.350 ⇒ 01:42:49.120 Emily Giant: It’s that, it’s… yeah.

1285 01:42:49.350 ⇒ 01:42:52.910 Emily Giant: It’s… Fanning out.

1286 01:42:52.910 ⇒ 01:42:57.390 perry: So those should be… Commented out, like, that should be commented out.

1287 01:42:58.150 ⇒ 01:42:58.530 Emily Giant: Still?

1288 01:42:58.530 ⇒ 01:42:59.050 perry: I’d…

1289 01:42:59.610 ⇒ 01:43:06.640 perry: Yeah, because once I fix the feed, it won’t repeat like that. There won’t be four line items for it to exaggerate revenue, actually, on.

1290 01:43:07.040 ⇒ 01:43:09.660 perry: It’s exaggerating right now, because it’s associating

1291 01:43:10.610 ⇒ 01:43:15.230 perry: 4 split line items of a forecast, with 4 totals for today.

1292 01:43:15.840 ⇒ 01:43:16.550 Emily Giant: Okay.

1293 01:43:17.010 ⇒ 01:43:21.190 Emily Giant: So I just… will you let me know when I can publish this? I’m just gonna get out of this branch.

1294 01:43:21.190 ⇒ 01:43:23.319 perry: Go ahead and publish it, and I’m gonna do it right now.

1295 01:43:23.320 ⇒ 01:43:23.870 Emily Giant: Okay.

1296 01:43:23.870 ⇒ 01:43:25.929 perry: Publish it, and that way, if it’s a shitshow.

1297 01:43:26.220 ⇒ 01:43:29.110 perry: I can Slack you sometime tonight and be like, never mind, put it back.

1298 01:43:29.490 ⇒ 01:43:31.339 Emily Giant: Okay, are you sure?

1299 01:43:31.340 ⇒ 01:43:34.210 perry: Yes, I’m… I am 99% confident in this.

1300 01:43:34.370 ⇒ 01:43:35.030 Emily Giant: Okay.

1301 01:43:35.160 ⇒ 01:43:42.709 Emily Giant: I know that that will work. It’s just the, like, the time difference. I can wait to do it until you have it set up, but it is…

1302 01:43:42.710 ⇒ 01:43:44.879 perry: Oh, because I wanna… I wanna talk to Wilder tomorrow.

1303 01:43:45.630 ⇒ 01:43:46.270 Emily Giant: Okay.

1304 01:43:48.550 ⇒ 01:43:50.380 Emily Giant: Alright, yep, I’ll push that out.

1305 01:43:51.450 ⇒ 01:44:00.039 Emily Giant: Okay, what else did I change? Shopify customer visits… oh, these all needed to be changed anyway, because it’s one of the things I was commenting out as we QA’d.

1306 01:44:00.350 ⇒ 01:44:01.850 Emily Giant: Removed…

1307 01:44:07.950 ⇒ 01:44:08.980 Emily Giant: Hmm…

1308 01:44:12.990 ⇒ 01:44:16.960 perry: I’m gonna do this, duplicate, and I’m gonna do…

1309 01:44:18.850 ⇒ 01:44:19.560 Emily Giant: Alright.

1310 01:44:20.070 ⇒ 01:44:24.900 Emily Giant: Cool. So, we only went 45 minutes over. Perfect.

1311 01:44:24.900 ⇒ 01:44:25.810 perry: Success.

1312 01:44:26.230 ⇒ 01:44:26.880 Emily Giant: Great.

1313 01:44:26.880 ⇒ 01:44:28.040 perry: I took a screenshot.

1314 01:44:28.600 ⇒ 01:44:31.840 Emily Giant: Alright, so that is updating now.

1315 01:44:32.720 ⇒ 01:44:40.130 Emily Giant: I’m going to work on adding the, product SKU to the… table, so that Demolade can…

1316 01:44:40.900 ⇒ 01:44:43.460 Demilade Agboola: So, I was going to quickly show you something.

1317 01:44:45.800 ⇒ 01:44:48.570 perry: She’s created, like, 4 copies of this.

1318 01:44:49.580 ⇒ 01:44:51.510 perry: And really, all I need to do…

1319 01:44:52.530 ⇒ 01:44:54.060 Demilade Agboola: So, for the…

1320 01:44:54.060 ⇒ 01:44:54.950 perry: Oh, goodness.

1321 01:44:55.900 ⇒ 01:44:59.770 Demilade Agboola: So we can see that this is… the line item.

1322 01:45:01.150 ⇒ 01:45:08.879 Demilade Agboola: There’s 75, so that’s one of the orders where we have the… Subscription ID coming through.

1323 01:45:08.880 ⇒ 01:45:09.510 Emily Giant: Yes.

1324 01:45:09.510 ⇒ 01:45:12.620 Demilade Agboola: And based off what we’re looking at here.

1325 01:45:13.680 ⇒ 01:45:17.290 Demilade Agboola: The product type is considered a subscription.

1326 01:45:17.290 ⇒ 01:45:18.000 Emily Giant: Yes.

1327 01:45:18.520 ⇒ 01:45:22.459 Demilade Agboola: But then I was like, okay, how can we go around that?

1328 01:45:22.460 ⇒ 01:45:23.640 Emily Giant: Oh…

1329 01:45:23.640 ⇒ 01:45:29.769 Demilade Agboola: And then, I try to do this, so, like, where the unit price is the same as the adjusted line item.

1330 01:45:29.890 ⇒ 01:45:30.759 Demilade Agboola: It’s so wonderful.

1331 01:45:32.210 ⇒ 01:45:36.209 Demilade Agboola: Then, the issue and why that hasn’t worked is, for some reason.

1332 01:45:36.450 ⇒ 01:45:43.080 Demilade Agboola: it appears this is fulfilled is false for this, which makes no sense, because I just…

1333 01:45:43.200 ⇒ 01:45:45.380 Demilade Agboola: I was just about to focus it now.

1334 01:45:45.960 ⇒ 01:45:51.160 Demilade Agboola: But it should… It shouldn’t be false.

1335 01:45:53.410 ⇒ 01:45:55.079 Emily Giant: It does sound unfulfilled.

1336 01:45:55.860 ⇒ 01:45:56.700 Demilade Agboola: It does.

1337 01:45:57.040 ⇒ 01:45:59.800 Emily Giant: Different order, sorry. Yeah, it says unfulfilled.

1338 01:46:00.090 ⇒ 01:46:00.850 Demilade Agboola: Alright.

1339 01:46:01.560 ⇒ 01:46:05.850 Demilade Agboola: So I think we might have our fix for, like, fulfilled orders.

1340 01:46:05.850 ⇒ 01:46:06.650 Emily Giant: Okay.

1341 01:46:10.680 ⇒ 01:46:18.669 Demilade Agboola: Yeah, I think we might basically have our fix for fulfilled orders. Okay. And recruit revenue, I will just basically remove this part of it.

1342 01:46:19.500 ⇒ 01:46:22.249 Demilade Agboola: So, the way in solution is null…

1343 01:46:23.440 ⇒ 01:46:26.929 Demilade Agboola: And the uni price is the same as the adjusted line item revenue.

1344 01:46:26.930 ⇒ 01:46:27.360 Emily Giant: True.

1345 01:46:27.860 ⇒ 01:46:30.690 Demilade Agboola: North Carolina SM Revenue in that case.

1346 01:46:32.260 ⇒ 01:46:38.020 Demilade Agboola: So, for this order… Yes, so we haven’t accrued a 75 on the appropriate line.

1347 01:46:38.020 ⇒ 01:46:39.090 Emily Giant: Nice. Okay.

1348 01:46:40.010 ⇒ 01:46:41.979 Demilade Agboola: So I’ll… I’ll push that fix.

1349 01:46:42.440 ⇒ 01:46:48.370 Emily Giant: Okay, and then I still need to fix the join in Looker, but I’ll just… I’ll… figure it out.

1350 01:46:48.540 ⇒ 01:46:50.889 Emily Giant: I have that order to play with, so…

1351 01:46:51.370 ⇒ 01:47:03.109 Emily Giant: I’ll just use that as an example, and mess with the, like… because what I’m worried about is that it’s, like, fanning out on all of the ordered IDs, and needs to also be joined on product SKU, but because…

1352 01:47:03.110 ⇒ 01:47:11.760 Demilade Agboola: I’m changing the joint to variant ID and product ID, so I will push the new update now, so you can kind of see and get an idea of what I’m doing, to kind of keep it…

1353 01:47:12.200 ⇒ 01:47:15.279 Demilade Agboola: To ensure that the revenue only stays on the right line.

1354 01:47:15.400 ⇒ 01:47:23.330 Demilade Agboola: Again, we can play around, I’m just trying to see if that remains consistent every single time, but yeah, I think this, this should work.

1355 01:47:23.480 ⇒ 01:47:29.239 Demilade Agboola: So I’m just bringing in the product attributes just to ensure that the product… because…

1356 01:47:29.550 ⇒ 01:47:31.949 Demilade Agboola: There’s no way to really identify

1357 01:47:32.220 ⇒ 01:47:37.710 Demilade Agboola: I mean, on the subscriptions, can we identify the right… Subscriptions have product ID, right?

1358 01:47:38.970 ⇒ 01:47:39.780 Emily Giant: They can.

1359 01:47:39.780 ⇒ 01:47:40.470 perry: Thanks.

1360 01:47:40.680 ⇒ 01:47:43.430 Emily Giant: I need to pull out of that JSON string, but I can.

1361 01:47:43.620 ⇒ 01:47:45.000 Demilade Agboola: Okay, but…

1362 01:47:45.290 ⇒ 01:47:52.360 Demilade Agboola: Is there a way to ensure that the right product ID gets the revenue, the amortized line revenue, though?

1363 01:47:52.780 ⇒ 01:47:54.260 Demilade Agboola: That would be my question.

1364 01:47:55.910 ⇒ 01:47:57.740 Emily Giant: I think s- I think so.

1365 01:47:57.920 ⇒ 01:48:03.809 Emily Giant: What needs to happen is that that floral should not be categorized as a subscription.

1366 01:48:03.940 ⇒ 01:48:06.490 Emily Giant: And it’s weird to me…

1367 01:48:07.090 ⇒ 01:48:09.590 Emily Giant: That the product table’s populating that way.

1368 01:48:09.680 ⇒ 01:48:27.639 Emily Giant: I think that’s the big… one of the problems here is that, like, the subscription SKU can be a subscription, but the floral that’s used to fulfill the subscription should not. That should be a floral. That way, like, because if Perry were to pull floral subscription

1369 01:48:27.880 ⇒ 01:48:31.250 Emily Giant: Revenue by, like, product category.

1370 01:48:31.490 ⇒ 01:48:40.880 Emily Giant: It would be wrong. So let me make a ticket for that, because I think that there’s something sinister about it, pulling as a subscription in the first place.

1371 01:48:41.340 ⇒ 01:48:41.930 Demilade Agboola: Gotcha.

1372 01:48:42.880 ⇒ 01:48:49.680 Demilade Agboola: Do you want me to push this backup way, or do you just want to tackle the product attributes?

1373 01:48:50.090 ⇒ 01:49:01.959 Emily Giant: I’ll do the attributes and, the adding the floral SKU to the subscription table. I think that I need that for the join in Looker, or it’s gonna do weird stuff.

1374 01:49:02.540 ⇒ 01:49:03.250 Demilade Agboola: Okay.

1375 01:49:03.580 ⇒ 01:49:04.200 Demilade Agboola: Alright.

1376 01:49:04.200 ⇒ 01:49:04.880 Emily Giant: Little part.

1377 01:49:04.880 ⇒ 01:49:16.499 Demilade Agboola: But you can also just switch it to the… so I will make the switch. So you should do the product tribute on the… you could just use product ID to the strict product ID.

1378 01:49:16.640 ⇒ 01:49:20.929 Demilade Agboola: And the, because that’s the push I’m going to make now.

1379 01:49:21.200 ⇒ 01:49:21.820 Emily Giant: Okay.

1380 01:49:22.270 ⇒ 01:49:25.020 Demilade Agboola: So, what do you need me to do to clean some things up, too, though?

1381 01:49:28.100 ⇒ 01:49:29.060 Emily Giant: Okay.

1382 01:49:29.060 ⇒ 01:49:30.870 Demilade Agboola: If you’re looking at the looker, John, I could…

1383 01:49:31.020 ⇒ 01:49:33.620 Demilade Agboola: Maybe look at the product attributes and clean that up.

1384 01:49:35.100 ⇒ 01:49:37.080 Demilade Agboola: But I might need a list of…

1385 01:49:37.210 ⇒ 01:49:41.689 Demilade Agboola: You know what, I’ll find it. I’ll find a list of subscriptions with florals, and then I will look at that.

1386 01:49:41.970 ⇒ 01:49:53.370 Emily Giant: Yeah, because it should be referencing the Shopify table of products, not… It’s, like, the product type…

1387 01:49:53.740 ⇒ 01:49:57.619 Demilade Agboola: Well, just to… just to be sure, the way to find…

1388 01:49:58.100 ⇒ 01:50:04.070 Demilade Agboola: The seasonal subscriptions that are products would be whether it’s the Urban Sam’s Fresh Selection.

1389 01:50:05.360 ⇒ 01:50:06.270 Emily Giant: Yeah. Okay.

1390 01:50:06.600 ⇒ 01:50:08.170 Emily Giant: It’s, yeah, yep.

1391 01:50:08.670 ⇒ 01:50:09.380 Emily Giant: Yep.

1392 01:50:09.870 ⇒ 01:50:15.329 Demilade Agboola: So, once I look into that, I will try and just ensure that we have them as well.

1393 01:50:15.550 ⇒ 01:50:19.199 Demilade Agboola: So that then we don’t have to rely, bless you, so that we don’t have to… Thank you.

1394 01:50:20.140 ⇒ 01:50:25.660 Demilade Agboola: of the… I’m, like, just in…

1395 01:50:25.660 ⇒ 01:50:31.580 perry: Oh my god, I’m so sneezy, I’m so sorry. That’s, like, my 50th sneeze of the day. Like, I swear to God, I’m so over it.

1396 01:50:32.040 ⇒ 01:50:37.340 perry: There was one time earlier today where I think I sneezed 14 times in a row, and I was just, like, dying.

1397 01:50:37.560 ⇒ 01:50:38.420 Emily Giant: Yay.

1398 01:50:38.590 ⇒ 01:50:44.280 Demilade Agboola: That sounds exactly like my sister. So my older sister had, like, serious, like, allergies. It was the…

1399 01:50:44.280 ⇒ 01:50:46.179 perry: I’m not even allergic to anything.

1400 01:50:47.090 ⇒ 01:50:47.820 perry: I mean, I clearly.

1401 01:50:47.820 ⇒ 01:50:51.369 Emily Giant: I clearly must be. I clearly must be. I’m like,

1402 01:50:51.370 ⇒ 01:50:53.159 perry: That’s, like, not the right answer.

1403 01:50:53.700 ⇒ 01:50:55.150 Emily Giant: You are. So, yeah.

1404 01:50:55.150 ⇒ 01:50:56.390 Demilade Agboola: Yeah, because my…

1405 01:50:56.390 ⇒ 01:50:57.340 perry: My god.

1406 01:50:57.340 ⇒ 01:50:58.220 Emily Giant: It was too bad.

1407 01:50:58.220 ⇒ 01:51:02.270 Demilade Agboola: Sometimes I just didn’t even say, bless you. I’ll just, like, wait until… oh…

1408 01:51:02.270 ⇒ 01:51:03.060 perry: Yeah!

1409 01:51:03.060 ⇒ 01:51:05.899 Demilade Agboola: You lost this in 5 minutes? Okay, now it’s time for bless you.

1410 01:51:05.900 ⇒ 01:51:12.000 Emily Giant: Yeah, you’ve hit your Bless you limit for the day. I’m now giving you one for every five sneeze. I have, in fact.

1411 01:51:12.000 ⇒ 01:51:12.959 perry: limit for the day.

1412 01:51:15.930 ⇒ 01:51:18.059 perry: Nobody can bless me anymore, I’m unblessable.

1413 01:51:20.640 ⇒ 01:51:26.260 perry: Alright, I will… I will get this feed stuff sorted out, tonight.

1414 01:51:28.530 ⇒ 01:51:31.980 Emily Giant: I’m gonna get the product stuff sorted.

1415 01:51:32.250 ⇒ 01:51:35.810 Emily Giant: And, tomorrow is your last day?

1416 01:51:35.920 ⇒ 01:51:36.789 Emily Giant: No, when.

1417 01:51:36.790 ⇒ 01:51:37.640 perry: Wednesday.

1418 01:51:37.910 ⇒ 01:51:39.630 perry: Thank God. I’m here Wednesday.

1419 01:51:39.630 ⇒ 01:51:43.290 Emily Giant: Okay. Yeah. Can we do one more sesh on Wednesday?

1420 01:51:44.290 ⇒ 01:51:45.729 perry: I will be in office, but sure.

1421 01:51:46.110 ⇒ 01:51:48.849 Emily Giant: Oh, God, okay. Maybe tomorrow?

1422 01:51:50.010 ⇒ 01:51:55.329 perry: Yeah, after 3 is best, because I have to lock the forecast and talk with Dean.

1423 01:51:55.700 ⇒ 01:51:56.350 Emily Giant: Okay.

1424 01:51:56.750 ⇒ 01:51:59.250 Demilade Agboola: Okay, sounds good. Alright, cool.

1425 01:52:00.900 ⇒ 01:52:03.260 Emily Giant: later.

1426 01:52:03.450 ⇒ 01:52:04.290 perry: Thanks, guys!

1427 01:52:04.290 ⇒ 01:52:04.760 Emily Giant: Bye!

1428 01:52:05.060 ⇒ 01:52:05.700 perry: Bye.