Meeting Title: US x BF | Standup Date: 2025-11-25 Meeting participants: Emily Giant, Awaish Kumar, Demilade Agboola


WEBVTT

1 00:00:22.700 00:00:26.650 Awaish Kumar: Hello. Happy up!

2 00:00:31.020 00:00:32.290 Emily Giant: How’s everything?

3 00:00:34.600 00:00:36.060 Awaish Kumar: All good, how about you?

4 00:00:37.010 00:00:45.270 Emily Giant: Pretty good. Just struggling with, some of the requests I’m getting. Manakshi is…

5 00:00:45.680 00:00:52.999 Emily Giant: saying that yesterday the revenue is, like, $30,000 behind what Shopify says, and…

6 00:00:53.190 00:00:57.000 Emily Giant: all of the refreshes have gone through, so I’m just not sure why.

7 00:00:58.070 00:01:07.120 Emily Giant: But it’s the old model, so I don’t, like, want to fix it, per se, because we’re not going to use them, so it’s like a waste of time, but…

8 00:01:07.240 00:01:08.220 Emily Giant: At the same time.

9 00:01:08.960 00:01:14.690 Emily Giant: I want to make sure that they have as much accurate information as possible, so hopefully once

10 00:01:14.800 00:01:18.599 Emily Giant: Everyone else logs on, we can debug together a little bit.

11 00:01:21.400 00:01:22.110 Awaish Kumar: Okay.

12 00:01:27.580 00:01:32.710 Awaish Kumar: So, for which table? Like, is it for… Tableau Items Access, or…

13 00:01:33.770 00:01:35.330 Emily Giant: Yeah, exactly.

14 00:01:45.960 00:01:47.580 Awaish Kumar: Indy, anything went wrong.

15 00:01:49.900 00:01:53.899 Emily Giant: And then Demolade is back today, too, so he might be able to…

16 00:01:54.350 00:01:56.609 Awaish Kumar: Jump in and help, so…

17 00:02:03.840 00:02:08.259 Emily Giant: I guess we’ll wait a couple more minutes, but I’ll see if he’s coming to stand up and write to him.

18 00:02:09.970 00:02:14.100 Awaish Kumar: Okay, tableau item, etc.

19 00:02:14.370 00:02:15.070 Emily Giant: Yeah.

20 00:03:14.400 00:03:21.449 Emily Giant: Let me pull up the report and see, like, what Shopify says, so I know exactly, like, what she’s referring to, because…

21 00:03:22.150 00:03:28.270 Demilade Agboola: For some reason, I don’t know why, it appears I rejected this call, but I can’t We’re fixing it.

22 00:03:29.190 00:03:44.200 Emily Giant: It happens. I was talking to Awash about, Manakshi said that current revenue is, like, 40,000 behind Shopify for yesterday, so it’s still coming from Tableau ItemsXF, which, like, if it’s still…

23 00:03:44.460 00:03:47.730 Emily Giant: down by the end of the day, I’m just gonna have to replace…

24 00:03:47.830 00:03:52.240 Emily Giant: Those reports tonight with the new revenue model,

25 00:03:52.380 00:03:55.619 Emily Giant: But we were digging into, like, why…

26 00:03:55.830 00:04:00.500 Emily Giant: Like, where and why it would be… 30K behind.

27 00:04:01.120 00:04:01.919 Demilade Agboola: Okay?

28 00:04:02.050 00:04:06.149 Demilade Agboola: And our revenue models, are they the same? Do they match the numbers?

29 00:04:07.360 00:04:10.510 Emily Giant: I… our,

30 00:04:11.120 00:04:19.289 Emily Giant: I need to validate that, that’s a good point, just to, like, build it. The thing is, with… they’re comparing it to forecast, and…

31 00:04:19.290 00:04:22.380 Demilade Agboola: It joins on delivery date and on.

32 00:04:23.510 00:04:25.929 Emily Giant: purchase date, so I need to, like…

33 00:04:26.100 00:04:30.539 Emily Giant: Add delivery date to the revenue model in order to tie their forecast to it.

34 00:04:30.700 00:04:36.089 Emily Giant: It’s just a lot of stuff, but let me look at what they’re seeing.

35 00:04:38.230 00:04:44.730 Awaish Kumar: Yeah, I just looked at Metaplane, and the… so the Tableau item itself, like.

36 00:04:44.860 00:04:49.210 Awaish Kumar: It got refreshed on time, and it also has same number of rows.

37 00:04:51.210 00:04:51.990 Emily Giant: Yeah.

38 00:04:51.990 00:04:55.169 Awaish Kumar: Not normally in number of rows or anything?

39 00:04:56.770 00:04:57.890 Emily Giant: Yeah, that’s…

40 00:04:58.330 00:05:06.540 Emily Giant: what I was thinking, too. I don’t know if, like, there was a period of time where it just didn’t capture, but it ran a full refresh.

41 00:05:06.780 00:05:11.699 Emily Giant: So… Okay, let me open last 7 days total.

42 00:05:11.970 00:05:18.509 Emily Giant: Current and next week revenue budget, Let’s look at this one.

43 00:05:26.260 00:05:26.870 Awaish Kumar: books.

44 00:05:38.120 00:05:41.940 Emily Giant: So if I go to Shopify and pull up the orders for yesterday…

45 00:05:58.280 00:05:59.210 Emily Giant: -

46 00:06:17.900 00:06:22.890 Emily Giant: Okay, so it says for yesterday, No, that’s Sunday.

47 00:06:23.930 00:06:29.040 Emily Giant: I need… Monday.

48 00:06:38.410 00:06:39.360 Emily Giant: Why is it…

49 00:06:47.110 00:06:51.950 Emily Giant: Oh my gosh, this is being… really annoying.

50 00:06:53.830 00:06:55.120 Emily Giant: Yesterday.

51 00:06:55.290 00:06:56.560 Emily Giant: Apply.

52 00:06:56.960 00:06:58.139 Emily Giant: And the date.

53 00:07:00.040 00:07:06.649 Emily Giant: Oh, that’s the date in the past, I guess. Okay. So, it says yesterday we did 167344.

54 00:07:06.770 00:07:08.840 Emily Giant: And in Looker…

55 00:07:13.810 00:07:19.090 Emily Giant: 159… 387.

56 00:07:20.170 00:07:24.400 Demilade Agboola: Is this the accrued or fulfilled revenue that we’re looking at, or…

57 00:07:24.400 00:07:26.700 Emily Giant: This is from Tableau, so it’s a cruise.

58 00:07:26.700 00:07:28.839 Demilade Agboola: Okay, smart crew, yeah.

59 00:07:30.130 00:07:35.180 Demilade Agboola: So it is behind, but it’s like… 7K behind, or 5K behind?

60 00:07:35.180 00:07:36.939 Emily Giant: Yeah, not 30.

61 00:07:37.050 00:07:39.560 Emily Giant: Is she talking about this date?

62 00:07:42.470 00:07:46.030 Emily Giant: I mean, like, that’s not… it’s behind, but, like.

63 00:07:48.200 00:07:50.999 Demilade Agboola: And was there also a refresh issue?

64 00:07:51.660 00:07:54.839 Demilade Agboola: I think maybe he hadn’t refreshed, like, at that time.

65 00:07:55.260 00:07:56.799 Emily Giant: I think you might be right.

66 00:07:57.160 00:08:01.439 Demilade Agboola: It had the data, like, the last, maybe the last part of it was still missing.

67 00:08:01.940 00:08:07.420 Emily Giant: Yeah, I’m guessing so. It’s gotta be that, because that’s not 40K behind.

68 00:08:07.700 00:08:13.220 Emily Giant: At all. So let’s just check our accrued revenue in…

69 00:08:17.060 00:08:18.390 Emily Giant: new model.

70 00:08:39.210 00:08:40.500 Emily Giant: Order.

71 00:08:54.130 00:08:54.960 Emily Giant: Mmm…

72 00:09:09.750 00:09:10.660 Emily Giant: Oh.

73 00:09:11.520 00:09:12.960 Emily Giant: So, order.

74 00:09:13.640 00:09:15.519 Emily Giant: I need the other accrued.

75 00:09:16.670 00:09:18.889 Emily Giant: This one. Not this one.

76 00:09:33.190 00:09:36.230 Emily Giant: And this one is… way over.

77 00:09:39.260 00:09:42.600 Emily Giant: Not way over, but… 167…

78 00:09:48.120 00:09:50.149 Demilade Agboola: So this is, like, 12K over, basically.

79 00:09:50.150 00:09:50.710 Emily Giant: Yeah.

80 00:09:56.270 00:09:58.060 Emily Giant: But, if I did…

81 00:10:05.420 00:10:09.299 Emily Giant: Just out of curiosity, because that’s gonna include all the stuff that was, like.

82 00:10:09.910 00:10:13.940 Demilade Agboola: Yeah, well, yeah, we should be lower, like.

83 00:10:13.940 00:10:20.259 Emily Giant: Yeah, it won’t have been fulfilled yet, so… Yeah, I mean, that makes sense.

84 00:10:20.260 00:10:20.850 Demilade Agboola: Yeah. D.

85 00:10:20.850 00:10:23.860 Emily Giant: That much would have been fulfilled today from yesterday’s orders.

86 00:10:29.150 00:10:33.110 Emily Giant: Okay, I’m not… well, let’s see what… this is just the number.

87 00:10:33.650 00:10:35.360 Emily Giant: Without the summation.

88 00:10:36.290 00:10:38.779 Demilade Agboola: Okay, so how many orders does Shopify say

89 00:10:39.060 00:10:41.959 Demilade Agboola: Were fulfilled, and how many orders does this table fulfill?

90 00:10:42.200 00:10:43.079 Emily Giant: Let me see…

91 00:10:43.220 00:10:44.979 Demilade Agboola: Oh, like, no fulfills are accrued.

92 00:10:45.150 00:10:48.750 Emily Giant: Yeah. Let’s see… that’s a good question.

93 00:10:53.020 00:10:56.329 Emily Giant: Oh, that’s right, it’s not gonna sum, it’s gonna give every order’s revenue.

94 00:10:57.240 00:11:02.459 Demilade Agboola: Yeah… unless you could do a… could you do a count? Like, there’s some count, or… Yeah.

95 00:11:03.070 00:11:09.939 Emily Giant: There’s gonna be a quantity, too, in this order’s… fields, Shopify orders…

96 00:11:33.620 00:11:36.250 Emily Giant: Okay, 2167.

97 00:11:37.350 00:11:43.970 Emily Giant: Shopify says… Shopify, say?

98 00:11:52.610 00:11:54.410 Emily Giant: Hors d’oeuvres?

99 00:12:02.090 00:12:04.579 Demilade Agboola: Was that… is that orders or items, though?

100 00:12:05.070 00:12:06.410 Emily Giant: ERG.

101 00:12:06.620 00:12:10.800 Demilade Agboola: No, because we’re looking at orders in Shopify, but aren’t we summing the quantity

102 00:12:12.090 00:12:18.710 Demilade Agboola: in Looker, so that would be the number of items. If something… if an order… I have 3 things.

103 00:12:19.080 00:12:23.950 Emily Giant: Ray… oh, total items, yeah, yeah, yeah. You’re completely right.

104 00:12:28.430 00:12:30.339 Emily Giant: count distinct orders.

105 00:12:30.340 00:12:35.569 Demilade Agboola: Yes, it’ll be the count of distinct orders yesterday, or on the 24th, yeah, yesterday.

106 00:12:42.300 00:12:44.230 Emily Giant: 1392.

107 00:12:46.080 00:12:48.620 Demilade Agboola: Okay, so it is higher, though. Actually, it’s lower.

108 00:12:48.620 00:12:50.410 Emily Giant: Lower.

109 00:12:50.630 00:12:56.890 Demilade Agboola: It’s lowered by… 80… 5?

110 00:12:57.150 00:12:59.270 Emily Giant: Yeah, this has gotta be a time zone problem.

111 00:12:59.840 00:13:00.940 Demilade Agboola: Most likely.

112 00:13:00.940 00:13:01.500 Emily Giant: Yep.

113 00:13:04.450 00:13:09.109 Emily Giant: Yeah, I’m not offended by… Ours probably… mmm…

114 00:13:09.270 00:13:11.729 Emily Giant: I don’t know if ours is counting canceled orders, either.

115 00:13:11.920 00:13:17.979 Emily Giant: So… If it’s not counted canceled orders, it could be a combination of time zone and canceled.

116 00:13:18.610 00:13:25.990 Demilade Agboola: Yeah, so what I’m curious about is how can we have lower orders, but have a higher revenue? That’s what I’m curious.

117 00:13:25.990 00:13:27.510 Emily Giant: Yeah…

118 00:13:27.680 00:13:30.400 Demilade Agboola: That’s what I find by the sensing.

119 00:13:30.700 00:13:35.120 Emily Giant: Let me see, is there, like, an order status flag? Let’s see…

120 00:13:36.810 00:13:40.120 Demilade Agboola: I don’t think there’s a status flag.

121 00:13:56.350 00:14:00.879 Emily Giant: Yeah, probably… I… I don’t know.

122 00:14:04.050 00:14:06.219 Demilade Agboola: I could look into it.

123 00:14:06.220 00:14:06.650 Emily Giant: Yeah.

124 00:14:06.650 00:14:07.460 Demilade Agboola: I do.

125 00:14:08.450 00:14:13.470 Emily Giant: I think, like, this… Let me actually add the order numbers.

126 00:14:18.910 00:14:26.669 Demilade Agboola: Ultimately, the only thing we can do is we can look at the high order. The order IDs, or the order numbers with high value, revenue value.

127 00:14:27.060 00:14:28.679 Demilade Agboola: Kind of dig into those ones, and kind of…

128 00:14:28.680 00:14:29.710 Emily Giant: Yeah.

129 00:14:29.710 00:14:31.630 Demilade Agboola: If there’s an inflation going on somewhere.

130 00:14:33.080 00:14:36.069 Emily Giant: I don’t want line items, I want orders.

131 00:14:37.910 00:14:40.040 Emily Giant: Let’s get order number…

132 00:14:50.510 00:14:57.180 Emily Giant: Okay, I think order number has to come from… Something else.

133 00:14:59.820 00:15:03.249 Demilade Agboola: Yeah, there should be Shopify order ID, I believe.

134 00:15:11.420 00:15:12.400 Demilade Agboola: Yeah…

135 00:15:38.280 00:15:41.939 Emily Giant: 788. Okay, that’s really high.

136 00:15:42.270 00:15:43.639 Emily Giant: Let’s look at that.

137 00:15:48.750 00:15:50.129 Emily Giant: Nope, that’s not gonna work.

138 00:15:59.790 00:16:01.570 Emily Giant: Nope, it’s right.

139 00:16:03.760 00:16:07.180 Emily Giant: It’s 720 plus 4020… oh, well, no, plus…

140 00:16:08.060 00:16:10.620 Emily Giant: Okay, well, it should be 720.

141 00:16:15.510 00:16:20.599 Demilade Agboola: So it should be 727 of 7… 88, right.

142 00:16:22.790 00:16:23.410 Emily Giant: Yeah.

143 00:16:25.280 00:16:26.819 Emily Giant: Where’s that report?

144 00:16:28.540 00:16:35.520 Emily Giant: So that… I think this is just the line item total, though. Also, if I do it by this, I wonder if it’s counting…

145 00:16:36.570 00:16:42.580 Emily Giant: The subscription… because this is a subscription, but it’s supposed to be amortized.

146 00:16:43.120 00:16:46.720 Emily Giant: But Shopify wouldn’t know that, so it should still be…

147 00:16:47.960 00:16:50.090 Emily Giant: The same. Let’s check this one.

148 00:16:50.940 00:16:55.859 Emily Giant: Yeah, that’s what the difference is in money. It’s just some kind of tax, or something’s getting added.

149 00:16:55.950 00:16:57.020 Demilade Agboola: Yeah.

150 00:17:03.870 00:17:06.139 Emily Giant: So this should be $4.50.

151 00:17:06.450 00:17:07.729 Emily Giant: That’s what it is.

152 00:17:08.060 00:17:11.139 Demilade Agboola: It’s not looking at subscriptions for some reason.

153 00:17:11.339 00:17:12.609 Emily Giant: Yeah, huh.

154 00:17:13.660 00:17:17.149 Demilade Agboola: Alright, so I’ll look into that, that’s a weird one.

155 00:17:17.510 00:17:23.899 Demilade Agboola: So that explains the… so it’s basically assigning the price of subscriptions to the price of items, or the order itself.

156 00:17:24.109 00:17:24.839 Emily Giant: Yeah.

157 00:17:24.839 00:17:26.519 Demilade Agboola: Yeah, alright, gotcha.

158 00:17:26.900 00:17:29.140 Emily Giant: That’s probably fine, I think…

159 00:17:29.140 00:17:30.710 Demilade Agboola: like, because Shopify…

160 00:17:31.330 00:17:42.090 Emily Giant: Essentially, like, this should be lower because we amortized the subscriptions, but, something… is just getting…

161 00:17:43.150 00:17:44.589 Emily Giant: Some kind of tax.

162 00:17:44.980 00:17:47.120 Emily Giant: Select everything from…

163 00:17:59.150 00:18:00.999 Emily Giant: No, fact orders.

164 00:18:19.900 00:18:23.470 Emily Giant: And the 10K yesterday, that’s less.

165 00:18:23.720 00:18:27.350 Emily Giant: I’m guessing that actually is the difference between subscriptions.

166 00:18:27.850 00:18:29.889 Emily Giant: Being amortized and not.

167 00:18:30.150 00:18:32.089 Emily Giant: In the current model.

168 00:18:33.250 00:18:35.060 Demilade Agboola: That would be a good guess.

169 00:18:35.060 00:18:35.980 Emily Giant: Yeah.

170 00:18:37.090 00:18:37.830 Emily Giant: Okay.

171 00:18:38.690 00:18:40.560 Emily Giant: So, let’s get to the monies.

172 00:18:41.260 00:18:45.480 Emily Giant: So the order price… Total, $486.97.

173 00:18:49.160 00:18:49.990 Emily Giant: Correct.

174 00:18:53.570 00:18:56.590 Emily Giant: Subtotal. 450, correct.

175 00:18:58.150 00:19:08.810 Emily Giant: Order tax… Total discounts… Current total… So these are all correct.

176 00:19:09.220 00:19:09.770 Demilade Agboola: Bull.

177 00:19:10.170 00:19:13.819 Emily Giant: everything is correct, outside of I don’t see the $100 discount.

178 00:19:14.470 00:19:15.470 Emily Giant: Do you?

179 00:19:16.660 00:19:19.190 Demilade Agboola: The $100 discount? No, I do not.

180 00:19:24.590 00:19:28.910 Emily Giant: Okay, so that’s a question… But then what did Looker say it was?

181 00:19:29.600 00:19:32.040 Emily Giant: 552. Oh.

182 00:19:33.120 00:19:35.639 Emily Giant: I think that that has the discount added back in.

183 00:19:35.640 00:19:36.500 Demilade Agboola: Yeah.

184 00:19:37.790 00:19:43.450 Demilade Agboola: Because it’s… yeah, that’s 4 something, 102.

185 00:19:43.450 00:19:44.990 Emily Giant: Mmm, yep.

186 00:19:45.260 00:19:51.570 Emily Giant: Okay, so I think that’s what’s going on here, is just the discounts that aren’t… there?

187 00:19:52.650 00:19:54.739 Emily Giant: Are getting added back in.

188 00:19:56.760 00:20:01.359 Emily Giant: Let me see what this looks like in Dash, maybe the discount will be more obvious.

189 00:20:01.770 00:20:05.430 Demilade Agboola: Yeah… Or maybe the discount is somewhere else.

190 00:20:10.240 00:20:17.590 Emily Giant: Okay, so that’s what’s happening, is some random discount number is getting added back, so that’s the difference, and everything else looks perfect.

191 00:20:17.590 00:20:19.919 Demilade Agboola: Oh, I got, I know what, I know what the discount is.

192 00:20:19.920 00:20:20.570 Emily Giant: Okay.

193 00:20:20.570 00:20:24.660 Demilade Agboola: Counting the margot and the glass vase, the sum of it, as.

194 00:20:24.660 00:20:25.829 Emily Giant: Just calm down.

195 00:20:25.830 00:20:28.150 Demilade Agboola: From the price, because they’re canceled off.

196 00:20:28.420 00:20:32.900 Emily Giant: Oh… Okay.

197 00:20:33.860 00:20:37.419 Emily Giant: Brilliant. Yep, you’re totally right. It’s right there.

198 00:20:39.470 00:20:41.640 Emily Giant: Yep, yep, yep, yep, yep. Okay.

199 00:20:42.310 00:20:48.169 Emily Giant: Do you think you could work on that while I continue to bang my head against a wall with

200 00:20:48.570 00:20:55.150 Emily Giant: Updating… The component models, so that we can launch everything.

201 00:20:55.620 00:20:58.890 Demilade Agboola: Sure, so basically what we need now is we need it to…

202 00:20:59.220 00:21:02.919 Demilade Agboola: But why… I’m curious as to what happened to our mortality.

203 00:21:02.920 00:21:03.880 Emily Giant: descriptions!

204 00:21:05.410 00:21:08.479 Demilade Agboola: I’m actually just curious as to what happened with the amortization. It doesn’t seem

205 00:21:09.360 00:21:12.670 Demilade Agboola: Yeah, I’ll look into that and just kind of figure out what’s going on with that.

206 00:21:12.930 00:21:14.769 Emily Giant: Okay, the good news is, like.

207 00:21:15.100 00:21:16.929 Emily Giant: This does not look like a bad problem.

208 00:21:17.710 00:21:21.520 Demilade Agboola: Oh, yeah, yeah, I mean, even with this inflated number, it’s not that far off, like.

209 00:21:21.520 00:21:22.140 Emily Giant: Right.

210 00:21:22.140 00:21:26.049 Demilade Agboola: You know, so once we fix that, it will definitely be way, way closer.

211 00:21:26.050 00:21:37.140 Emily Giant: Yeah, yeah. Okay, that sounds good. And then a waist dropped, but yeah, just ping me later if you have any questions, but,

212 00:21:37.400 00:21:54.379 Emily Giant: Oh, I’ll be here all day and all night, banging my head against the wall. Actually, can you… no, you know what, I’ll just ask you later. This is more important to fix, and then once you have time, I have questions. Gotcha, gotcha. I’m in Minnesota, so I… Oh my gosh!

213 00:21:54.580 00:21:55.460 Demilade Agboola: Yeah.

214 00:21:55.460 00:22:00.839 Emily Giant: You… if you get bored, you and your girlfriend should come to Indiana, because that’s less boring.

215 00:22:02.720 00:22:06.590 Emily Giant: That would be so fun, though. How long are you there?

216 00:22:06.710 00:22:08.370 Emily Giant: Till the 14th.

217 00:22:08.720 00:22:15.749 Emily Giant: Okay, I was gonna say, if you’re here through December 30th, I’m going to get you a standby ticket to come to my birthday party.

218 00:22:16.270 00:22:18.409 Demilade Agboola: Oh, your birthday’s on the 30th?

219 00:22:18.410 00:22:19.650 Emily Giant: Of December.

220 00:22:20.220 00:22:22.730 Demilade Agboola: Interesting. That’s pretty cool.

221 00:22:22.730 00:22:33.209 Emily Giant: Yeah, it’s actually the least cool birthday, because it’s right after Christmas and the day before New Year’s Eve, so nobody ever wants to do anything.

222 00:22:34.320 00:22:35.649 Demilade Agboola: That’s fair, that’s fair.

223 00:22:35.650 00:22:50.660 Emily Giant: But this year they’re going to, because I’m turning 40, so it’s a big one. I know! I’m so aged! But anyway, yeah, if you guys get bored, we’ll cook for you at the farm. You can teach us some, like, Nigerian dishes, Matt would love that.

224 00:22:51.140 00:22:53.910 Demilade Agboola: Well, yeah, we’ll see, I’ll let you know.

225 00:22:53.910 00:23:00.679 Emily Giant: You’re like, okay. But anyway, welcome to my time zone. You’re welcome.

226 00:23:00.680 00:23:01.370 Demilade Agboola: Yeah.

227 00:23:01.370 00:23:04.890 Emily Giant: And yeah, just ping me later if you have any questions, I’ll be around.

228 00:23:05.130 00:23:06.110 Demilade Agboola: Alright, gotcha, gotcha.

229 00:23:06.110 00:23:07.100 Emily Giant: Bye.

230 00:23:07.100 00:23:07.750 Demilade Agboola: Right.