Meeting Title: Looker Data Debugging Session Date: 2025-11-12 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:00:35.520 ⇒ 00:00:36.720 Emily Giant: Hello.
2 00:00:40.060 ⇒ 00:00:41.610 Demilade Agboola: Hi, I’m Lee, how are you?
3 00:00:42.220 ⇒ 00:00:48.660 Emily Giant: Oh, I’m fine, I slept last night, so that always helps with, everything.
4 00:00:48.660 ⇒ 00:00:49.630 Demilade Agboola: Definitely.
5 00:00:49.870 ⇒ 00:00:50.470 Emily Giant: Hey, y’all.
6 00:00:50.470 ⇒ 00:00:52.829 Demilade Agboola: Probably one of the best predictors of how long you live.
7 00:00:53.720 ⇒ 00:00:57.019 Emily Giant: Yeah, well, if that’s the case, I don’t know where I’m at.
8 00:00:57.130 ⇒ 00:01:04.199 Emily Giant: Because sometimes I sleep for, like, 12 hours, and sometimes I don’t sleep at all, but I think it comes out to, like.
9 00:01:04.310 ⇒ 00:01:06.750 Emily Giant: Pretty good, if you were to, like, average it.
10 00:01:09.050 ⇒ 00:01:11.400 Emily Giant: And I feel like you don’t sleep.
11 00:01:11.570 ⇒ 00:01:13.259 Emily Giant: Do you even sleep?
12 00:01:13.660 ⇒ 00:01:18.349 Demilade Agboola: I mean, I do… you know, funny enough, this is actually the phase of my life where I’m actually sleeping.
13 00:01:19.320 ⇒ 00:01:21.100 Demilade Agboola: Relatively.
14 00:01:21.690 ⇒ 00:01:28.990 Demilade Agboola: I mean, to be fair, like, I got, like, 8 hours of sleep last night, you know? Because I woke up, like, 2 hours ago, so…
15 00:01:29.390 ⇒ 00:01:32.150 Demilade Agboola: Okay. Yeah, but I do know…
16 00:01:33.170 ⇒ 00:01:51.269 Demilade Agboola: There was a phase of my life where I was getting, like, 4 hours of sleep, 5 hours… there were actually days where I didn’t sleep at all, because I had stuff to do. So yeah, relatively, this is a… this is a nice phase of my life, you know, right? Yeah. 8 hours is the goal, but, like, given my druthers, I will not wake up.
17 00:01:51.270 ⇒ 00:01:52.450 Emily Giant: I have to be, like…
18 00:01:52.650 ⇒ 00:02:04.980 Emily Giant: blasted awake with an alarm, or I will continue sleeping. But yeah, like, two nights ago, I was up till 4, and that, like, my body was just, like.
19 00:02:05.700 ⇒ 00:02:14.229 Emily Giant: I felt like I was 90 yesterday. Like, my body was… like, my brain was okay. Not great, but okay. But, like, my joints…
20 00:02:14.300 ⇒ 00:02:27.550 Demilade Agboola: Yeah. I can’t do it anymore. Yeah, you definitely feel it. And the crazy thing is my dad would… even up to his 50s, he could still go up… he could still, like, sleep at, like, 3 AM, and wake up, like, 6, and.
21 00:02:27.550 ⇒ 00:02:27.990 Emily Giant: Oh my god.
22 00:02:27.990 ⇒ 00:02:30.990 Demilade Agboola: I never… I never understood how he could do it, but…
23 00:02:31.190 ⇒ 00:02:32.479 Emily Giant: Is he a doctor?
24 00:02:32.480 ⇒ 00:02:34.000 Demilade Agboola: No, he was an accountant.
25 00:02:34.120 ⇒ 00:02:35.050 Emily Giant: Okay.
26 00:02:36.320 ⇒ 00:02:39.420 Emily Giant: Well, hey, I mean, tax season must have really, like, kept.
27 00:02:41.320 ⇒ 00:02:44.820 Demilade Agboola: Like, when it was the end of, like, the financial year, it was always crazy for him.
28 00:02:45.060 ⇒ 00:03:01.010 Demilade Agboola: And he was one of those people who couldn’t sleep, wake up, and work. Like, he couldn’t, like… because I could do it, maybe sleep earlier, like, maybe sleep at 10, wake up at 2, work until the morning. He couldn’t do that. He had to, like, just be up till he was done what he needed to do, then he could sleep.
29 00:03:01.390 ⇒ 00:03:11.419 Demilade Agboola: So it’s so crazy. He’ll sleep at, like, really weird hours at 2, 3… I wake up at, like, 6 to go to work, and I’m just like, goddamn, that’s crazy, but…
30 00:03:11.420 ⇒ 00:03:22.330 Emily Giant: Yeah. That’s insane to me. My dad was really similar. Like, he was a doctor, and because he would be on call, he could be, like, in…
31 00:03:22.860 ⇒ 00:03:32.650 Emily Giant: deep sleep, and then our phone would ring, because there weren’t cell phones, and in the middle of the night, and he’d just have to, like, pop up, so he, like, is never asleep. I don’t know if the man has ever slept.
32 00:03:32.900 ⇒ 00:03:40.739 Emily Giant: and I don’t know how he has survived as long as he has, because he went, like, 30 years without having real sleep.
33 00:03:40.740 ⇒ 00:03:43.530 Demilade Agboola: Yeah, doctors are, like, they’re superheroes.
34 00:03:43.900 ⇒ 00:03:44.380 Emily Giant: Yeah.
35 00:03:44.380 ⇒ 00:03:47.229 Demilade Agboola: And I’m just like, how do you keep doing this? This isn’t life.
36 00:03:47.650 ⇒ 00:03:50.310 Emily Giant: Yeah. Have you watched the show The Pit?
37 00:03:50.650 ⇒ 00:03:51.510 Demilade Agboola: No.
38 00:03:51.850 ⇒ 00:04:11.130 Emily Giant: it’s on HBO, I don’t know if you get it in Malta, but… because I had to, like, download a VPN to watch it when I was on… in Europe recently, but it is, like, a 24-hour period. There’s, like, I think 14 episodes, like, it covers an entire shift in an emergency room, and it gives you, like.
39 00:04:11.260 ⇒ 00:04:18.080 Emily Giant: My mom was a nurse, and my dad was a doctor, and they were like, it was the most realistic show of, like.
40 00:04:18.399 ⇒ 00:04:29.260 Emily Giant: just the… the atmosphere. I don’t know how they do it. They are amazing. Because… no. Like, I can get stressed out about data, but, like.
41 00:04:29.840 ⇒ 00:04:31.940 Emily Giant: No.
42 00:04:32.870 ⇒ 00:04:34.759 Emily Giant: It’s something else entirely.
43 00:04:34.930 ⇒ 00:04:36.080 Demilade Agboola: I feel you, I feel you.
44 00:04:36.080 ⇒ 00:04:36.620 Emily Giant: Thank you.
45 00:04:37.130 ⇒ 00:04:48.669 Emily Giant: Alright, so I have this meeting this morning with leadership, like Manakshi and everyone, and I was just trying to put together a couple sample reports in Looker, and, the snapshot data is being a bitch!
46 00:04:48.670 ⇒ 00:04:58.890 Emily Giant: So, I was hoping, like, you could just take a look and see if I’m filtering something wrong, or if, like, something is set up incorrectly in Looker, but I’m… I don’t know…
47 00:04:59.350 ⇒ 00:05:05.709 Emily Giant: why it’s being so sticky, because I’ve used it before, and it was fine.
48 00:05:06.340 ⇒ 00:05:12.520 Emily Giant: Here, let me sh- Shared… Okay.
49 00:05:15.050 ⇒ 00:05:20.519 Emily Giant: Alright, so… Pulled this example…
50 00:05:22.630 ⇒ 00:05:35.909 Emily Giant: Of the firecracker, because we sell a lot of it, and I said, the start date has to be in the last 7 days, and the timestamp has to be in the last 7 days, so that it would, like, only pull active lots. But it’s just showing zero sales.
51 00:05:36.230 ⇒ 00:05:42.200 Emily Giant: And the lot quantities aren’t moving over time. Like, if I pull a single lot…
52 00:05:43.970 ⇒ 00:05:47.679 Emily Giant: And I’m wondering, like, is it… is the data not refreshing?
53 00:05:50.300 ⇒ 00:05:53.239 Demilade Agboola: I mean, we do have the schedule running, so…
54 00:05:53.380 ⇒ 00:05:54.080 Emily Giant: No.
55 00:05:54.080 ⇒ 00:05:58.310 Demilade Agboola: Unless it’s not taking snapshots, which seems to be weird.
56 00:06:03.620 ⇒ 00:06:06.049 Demilade Agboola: Also, at those hours where it should change?
57 00:06:06.620 ⇒ 00:06:08.460 Demilade Agboola: Or are you looking at it by day?
58 00:06:08.910 ⇒ 00:06:10.640 Emily Giant: It’s just one day.
59 00:06:13.140 ⇒ 00:06:20.209 Emily Giant: So, the start date’s on the 9th. Why? These are weird, weirdly aligned dates, too. But this is,
60 00:06:20.340 ⇒ 00:06:24.849 Emily Giant: It’s just… 2 days in time, I guess, the 7th and the 6th.
61 00:06:26.640 ⇒ 00:06:31.980 Demilade Agboola: Can you check what it is right now? Like, can we just check on the side what it is, right? Can you, like.
62 00:06:32.350 ⇒ 00:06:33.010 Emily Giant: Yeah.
63 00:06:34.040 ⇒ 00:06:41.750 Emily Giant: like, the lot in NetSuite? I mean, in… Yeah, in Dash or anywhere, or, like, just… you could duplicate it and just kind of see.
64 00:06:42.360 ⇒ 00:06:44.499 Emily Giant: There’s 22 pre-sales.
65 00:06:45.990 ⇒ 00:06:49.780 Emily Giant: 48 on hand, 0 committed, 26 available.
66 00:06:49.910 ⇒ 00:06:52.330 Emily Giant: Alright. So if it just did, like, today?
67 00:06:55.110 ⇒ 00:06:58.599 Demilade Agboola: Can you duplicate your tab? Okay, or you could do that.
68 00:06:59.540 ⇒ 00:07:01.399 Emily Giant: And if you duplicate it… Yeah, I’ll duplicate it.
69 00:07:03.920 ⇒ 00:07:07.900 Demilade Agboola: And then you could try, like, looking at what it is right now.
70 00:07:09.190 ⇒ 00:07:10.769 Emily Giant: Yeah. Like, today.
71 00:07:10.770 ⇒ 00:07:11.760 Demilade Agboola: Basically.
72 00:07:13.690 ⇒ 00:07:15.320 Demilade Agboola: See if the numbers match.
73 00:07:17.360 ⇒ 00:07:23.459 Demilade Agboola: We know that, okay, it is keeping track appropriately, and maybe it was just… it just didn’t move quickly during that day.
74 00:07:24.170 ⇒ 00:07:29.580 Demilade Agboola: And then maybe picked up, like, just yet, so we get an idea of what’s going on. I think that’s the…
75 00:07:30.220 ⇒ 00:07:33.690 Emily Giant: Yeah, I need to look at a single lot. That lot got erased. One sec.
76 00:07:39.490 ⇒ 00:07:40.100 Demilade Agboola: corner.
77 00:07:52.810 ⇒ 00:07:53.860 Emily Giant: No results.
78 00:07:56.400 ⇒ 00:07:58.600 Demilade Agboola: Was, comedy yesterday.
79 00:07:59.030 ⇒ 00:07:59.670 Emily Giant: Yeah.
80 00:08:07.680 ⇒ 00:08:08.900 Demilade Agboola: Interesting.
81 00:08:09.090 ⇒ 00:08:10.660 Emily Giant: Yeah, right?
82 00:08:39.610 ⇒ 00:08:43.909 Emily Giant: No, it’s not the snapshot, it’s the… What’s it actually called?
83 00:08:45.380 ⇒ 00:08:48.050 Emily Giant: Snap marked in the jury lock table.
84 00:09:02.290 ⇒ 00:09:06.190 Demilade Agboola: Try looking at the jobs, be sure that it’s running appropriately.
85 00:09:10.790 ⇒ 00:09:14.189 Demilade Agboola: Just a heads up, I’ll be out of office on… next week.
86 00:09:14.640 ⇒ 00:09:15.390 Emily Giant: Okay.
87 00:09:15.390 ⇒ 00:09:15.970 Demilade Agboola: from.
88 00:09:15.970 ⇒ 00:09:16.790 Emily Giant: education?
89 00:09:17.960 ⇒ 00:09:19.619 Demilade Agboola: Solder.
90 00:09:19.820 ⇒ 00:09:22.469 Demilade Agboola: My friend’s getting married in the Dominican Republic.
91 00:09:22.630 ⇒ 00:09:24.410 Emily Giant: Oh my gosh, your friends need to…
92 00:09:25.120 ⇒ 00:09:28.269 Emily Giant: Align their weddings to different years.
93 00:09:28.700 ⇒ 00:09:29.180 Demilade Agboola: I’m.
94 00:09:29.180 ⇒ 00:09:31.219 Emily Giant: I’m glad you’re gonna be on a break.
95 00:09:31.380 ⇒ 00:09:39.700 Demilade Agboola: Yeah, I mean, at this point, not only bad advice. Part of why I went to, like, the UK was because my friend was planning to propose, so I just kind of helped him with it.
96 00:09:39.700 ⇒ 00:09:40.720 Emily Giant: fall…
97 00:09:41.500 ⇒ 00:09:44.199 Demilade Agboola: Logistics. Yeah, we’ve been friends since I was, like, 10.
98 00:09:44.350 ⇒ 00:09:45.650 Demilade Agboola: Some of my first friends.
99 00:09:45.970 ⇒ 00:09:46.440 Demilade Agboola: So…
100 00:09:46.440 ⇒ 00:09:52.650 Emily Giant: That is awesome. Weddings are fun. Is this one gonna be smaller than the last one?
101 00:09:52.650 ⇒ 00:10:00.789 Demilade Agboola: This is gonna be a… I mean, this is gonna be a proposal. He’s not planning to get married until, like, 2027, he just wants to propose right now.
102 00:10:01.630 ⇒ 00:10:02.839 Emily Giant: Okay, that’s cool.
103 00:10:02.840 ⇒ 00:10:03.600 Demilade Agboola: So…
104 00:10:04.220 ⇒ 00:10:10.759 Emily Giant: Aw, yay! Well, that’ll be fun. I’m glad you’re taking a break. You’ve been burning the midnight oil big time, so…
105 00:10:11.270 ⇒ 00:10:19.089 Demilade Agboola: Yeah, so I should be, but after that, outside the Dominican Republic, I will be going to the US. I should be in the US for, like, 3 weeks.
106 00:10:19.380 ⇒ 00:10:20.700 Emily Giant: Oh, nice!
107 00:10:20.700 ⇒ 00:10:23.630 Demilade Agboola: Then I’ll be back to Malta for Christmas.
108 00:10:25.030 ⇒ 00:10:26.849 Emily Giant: You’re gonna go with your family for Christmas?
109 00:10:27.060 ⇒ 00:10:28.229 Emily Giant: My pleasure.
110 00:10:28.550 ⇒ 00:10:31.909 Demilade Agboola: Yeah, something’s weird with it. My sister’s coming over for Christmas.
111 00:10:32.830 ⇒ 00:10:35.820 Emily Giant: Oh, that’s great.
112 00:10:35.970 ⇒ 00:10:37.659 Emily Giant: And her family?
113 00:10:37.660 ⇒ 00:10:41.609 Demilade Agboola: Yeah, so her husband, her kids, everyone’s coming over.
114 00:10:42.310 ⇒ 00:10:43.480 Emily Giant: That’s cool.
115 00:10:43.920 ⇒ 00:10:44.650 Demilade Agboola: Yep.
116 00:10:46.600 ⇒ 00:10:48.210 Emily Giant: Yeah, something’s weird with this.
117 00:10:50.450 ⇒ 00:10:51.520 Emily Giant: If I go…
118 00:10:55.860 ⇒ 00:11:05.340 Demilade Agboola: Alright, so let me look at this… Alright, let me… Here’s the fun stuff, debugging.
119 00:11:05.660 ⇒ 00:11:06.600 Emily Giant: Thank you.
120 00:11:08.440 ⇒ 00:11:10.560 Demilade Agboola: I said that a bit sarcastically, but I actually drew.
121 00:11:10.560 ⇒ 00:11:11.110 Emily Giant: Huh.
122 00:11:11.110 ⇒ 00:11:11.710 Demilade Agboola: Okay.
123 00:11:12.120 ⇒ 00:11:16.459 Emily Giant: Yeah, it’s great when it starts working again. And it’s getting easier, for sure.
124 00:11:16.590 ⇒ 00:11:20.620 Emily Giant: But snapshots are just… weird. Like, they never want to behave.
125 00:11:21.540 ⇒ 00:11:29.520 Emily Giant: I have that other snapshot that just errors in the jobs, and I don’t know why, because it’s set up exactly like this. For the,
126 00:11:29.750 ⇒ 00:11:31.290 Emily Giant: GA4 data.
127 00:11:31.730 ⇒ 00:11:32.540 Demilade Agboola: Okay.
128 00:11:32.760 ⇒ 00:11:44.760 Emily Giant: Because PK wants to look at that data next to this with, like, looks on pages and sales, or conversions, so you can see, like, if people are looking at a page for, like, a stocked-out item.
129 00:11:45.240 ⇒ 00:11:46.000 Demilade Agboola: Yeah.
130 00:11:47.300 ⇒ 00:11:50.259 Emily Giant: This is really… Taking a minute.
131 00:11:50.260 ⇒ 00:11:55.869 Demilade Agboola: Don’t stop this inventory. Goodness, don’t tell me someone did that.
132 00:12:02.580 ⇒ 00:12:05.850 Demilade Agboola: So we had a scheduled hourly run for…
133 00:12:11.710 ⇒ 00:12:15.840 Demilade Agboola: Yeah, so on, someone… someone unscheduled the job.
134 00:12:17.390 ⇒ 00:12:23.609 Emily Giant: I don’t think it was me, but I have no recollection of doing that, or why I would, unless it was failing.
135 00:12:24.110 ⇒ 00:12:32.389 Demilade Agboola: It was pretty hard, but… But the failure was… oh, damn it, dammit, dammit, damn it, dammit.
136 00:12:32.960 ⇒ 00:12:38.630 Demilade Agboola: So the failure was in building the lot, but, like, by turning it off, it stopped taking snapshots.
137 00:12:39.400 ⇒ 00:12:40.590 Emily Giant: Fun.
138 00:12:40.600 ⇒ 00:12:41.790 Demilade Agboola: Well…
139 00:12:42.220 ⇒ 00:12:50.749 Emily Giant: We’ll turn that bad boy back on, and I won’t demo this during the meeting, but as long as we know… as long as it… because it was working!
140 00:12:50.750 ⇒ 00:12:51.730 Demilade Agboola: We were doing it with.
141 00:12:51.730 ⇒ 00:12:52.889 Emily Giant: And I was like…
142 00:12:52.890 ⇒ 00:12:56.089 Demilade Agboola: It was turned off on the 9th, so it is fine.
143 00:12:56.090 ⇒ 00:12:58.100 Emily Giant: Oh, okay, that’s good.
144 00:12:58.880 ⇒ 00:13:01.190 Demilade Agboola: So, it hasn’t been off for that long.
145 00:13:04.480 ⇒ 00:13:07.630 Emily Giant: That was the… was that the day we were like… no, that was yesterday.
146 00:13:07.740 ⇒ 00:13:15.590 Emily Giant: That may actually have been me, if it was Saturday, because I know I was debugging jobs during the weekend.
147 00:13:16.350 ⇒ 00:13:21.760 Emily Giant: Well, what an idiot. This is still, if I go back in time.
148 00:13:22.040 ⇒ 00:13:25.020 Emily Giant: like, they should be… because I should be able to go back.
149 00:13:25.670 ⇒ 00:13:28.150 Emily Giant: And pull the snapshots from before, right?
150 00:13:28.690 ⇒ 00:13:37.050 Demilade Agboola: Yeah, so it stopped… the last run was on the… on the 8th… of November.
151 00:13:38.460 ⇒ 00:13:41.170 Demilade Agboola: So anything prior to that should be fine.
152 00:13:41.380 ⇒ 00:13:48.110 Demilade Agboola: like, you should have an idea of what happened hour by hour. I think the lot… the changes… something had…
153 00:13:50.230 ⇒ 00:13:54.150 Emily Giant: I committed those uncommitted order things, so it was bonking out.
154 00:13:54.150 ⇒ 00:13:55.300 Demilade Agboola: Exactly.
155 00:13:56.050 ⇒ 00:14:01.249 Demilade Agboola: And so we just needed to fix how we were expanding the models.
156 00:14:02.900 ⇒ 00:14:09.079 Emily Giant: Got it, okay. So yeah, this looks a little more normal. Let me just pull a single lot. Why is this?
157 00:14:09.570 ⇒ 00:14:12.340 Emily Giant: Oh, I removed the Baltimore filter.
158 00:14:18.030 ⇒ 00:14:18.620 Emily Giant: Alright.
159 00:14:18.620 ⇒ 00:14:19.210 Demilade Agboola: et cetera.
160 00:14:19.210 ⇒ 00:14:28.050 Emily Giant: I felt totally insane. I was like, I remember looking at this working for PK, and why is it, like, why have I lost my Looker skills here?
161 00:14:30.530 ⇒ 00:14:33.929 Demilade Agboola: Alright, so yeah, it was just the job was turned off, and…
162 00:14:37.700 ⇒ 00:14:43.050 Emily Giant: Okay, let me pull… so this is a lot on 1102 and 1029, so these should be the active lots.
163 00:14:43.190 ⇒ 00:14:45.879 Emily Giant: But what I’m seeing, still, is that, like.
164 00:14:47.440 ⇒ 00:14:53.020 Emily Giant: nothing is changing over the course of the day. It says 22 and 7 the whole day.
165 00:14:53.470 ⇒ 00:14:57.620 Emily Giant: like, if I pull… so these were the 3 active lots.
166 00:15:03.160 ⇒ 00:15:03.640 Emily Giant: Crystal.
167 00:15:03.640 ⇒ 00:15:07.170 Demilade Agboola: I mean, that is, like, 12 o’clock, though. Like, 12 AM.
168 00:15:07.370 ⇒ 00:15:12.009 Emily Giant: Yeah, it’s true. Hold on, let me… Just filter for this one.
169 00:15:12.900 ⇒ 00:15:18.610 Emily Giant: Or the three that we know were actually… Selling things.
170 00:15:19.620 ⇒ 00:15:20.989 Emily Giant: That were on hand.
171 00:15:24.490 ⇒ 00:15:25.540 Emily Giant: That’s already there.
172 00:15:27.190 ⇒ 00:15:28.969 Emily Giant: We’ll just do this, for example.
173 00:15:39.940 ⇒ 00:15:41.819 Emily Giant: Yeah, it’s the same all day.
174 00:15:44.980 ⇒ 00:15:53.180 Demilade Agboola: Oh, so let’s see, so it’s 4 all day… on this… Sixth…
175 00:15:58.100 ⇒ 00:16:04.179 Emily Giant: Also, I’m wondering why this, the start date’s on the 5th, that’s fine.
176 00:16:04.800 ⇒ 00:16:06.290 Emily Giant: This doesn’t need to be there.
177 00:16:34.900 ⇒ 00:16:40.010 Demilade Agboola: Okay, so we have the… That’s 4, all 3…
178 00:16:41.020 ⇒ 00:16:44.969 Demilade Agboola: Dang… can we keep… is it only for the 6th?
179 00:16:46.270 ⇒ 00:16:48.829 Emily Giant: Yeah, I can… I can expand this.
180 00:16:53.530 ⇒ 00:17:00.689 Emily Giant: maybe it’s because of what I’m filtering with, like, timestamp, hour, date? Oh.
181 00:17:00.690 ⇒ 00:17:03.599 Demilade Agboola: My bad, let me, let me look at something, just one second.
182 00:17:13.020 ⇒ 00:17:16.010 Demilade Agboola: This should still be fine. Can you also do the 7th as well?
183 00:17:20.609 ⇒ 00:17:22.650 Demilade Agboola: So, the things that are breaking…
184 00:17:23.250 ⇒ 00:17:25.930 Demilade Agboola: on this… like, how do I put it?
185 00:17:26.050 ⇒ 00:17:31.669 Demilade Agboola: it was still taking snapshots, which is why the run had to happen, right? Like…
186 00:17:32.260 ⇒ 00:17:37.519 Demilade Agboola: In the run that was broken, it’s doing both taking the snapshots.
187 00:17:38.390 ⇒ 00:17:42.590 Demilade Agboola: And then building out the, like, inventory changes into the.
188 00:17:42.590 ⇒ 00:17:42.960 Emily Giant: Yeah.
189 00:17:42.960 ⇒ 00:17:47.059 Demilade Agboola: or this thing. So by turning it off, it has stopped taking snapshots.
190 00:17:47.360 ⇒ 00:17:53.490 Demilade Agboola: But what was actually breaking was the expansion into, like, this, like, hour-by-hour change.
191 00:17:54.030 ⇒ 00:17:54.770 Emily Giant: Yes.
192 00:17:54.950 ⇒ 00:18:06.809 Demilade Agboola: So, ideally, even if it was still running, it would still keep taking the snapshot, just not expanding table well. So, the table expansion issue started on the 7th, when the previous changes were pushed in.
193 00:18:09.110 ⇒ 00:18:12.939 Demilade Agboola: And I’m believing that’s the last time… that’s the last change you’ll see.
194 00:18:13.390 ⇒ 00:18:19.229 Demilade Agboola: Can we try other lots and just kind of see other lots, and just see…
195 00:18:21.620 ⇒ 00:18:22.350 Emily Giant: Yeah.
196 00:18:25.210 ⇒ 00:18:29.320 Emily Giant: Let me pull… do you want me to just pull any lot in Baltimore during that time?
197 00:18:31.420 ⇒ 00:18:33.370 Emily Giant: That’s probably gonna be a lot.
198 00:18:33.730 ⇒ 00:18:35.849 Emily Giant: But, yeah, let’s just do it.
199 00:18:49.810 ⇒ 00:18:53.029 Emily Giant: Okay, so there’s the one we were looking at.
200 00:18:53.720 ⇒ 00:18:58.100 Emily Giant: Oh, this is still just for the firecracker, but… shouldn’t matter.
201 00:19:01.010 ⇒ 00:19:04.360 Emily Giant: Yeah, these all just stay the same, like, these numbers just repeat.
202 00:19:05.750 ⇒ 00:19:08.659 Demilade Agboola: Mmm… did you just…
203 00:19:12.660 ⇒ 00:19:14.149 Demilade Agboola: Yeah, that’s not good.
204 00:19:14.770 ⇒ 00:19:16.230 Emily Giant: Yeah, something’s funky.
205 00:19:17.200 ⇒ 00:19:18.440 Emily Giant: I… is it…
206 00:19:18.570 ⇒ 00:19:19.640 Demilade Agboola: Can we try…
207 00:19:19.640 ⇒ 00:19:23.330 Emily Giant: Dates are… is it how the dates are…
208 00:19:23.660 ⇒ 00:19:27.340 Emily Giant: filtering? That it’s, like, only looking at, like.
209 00:19:28.730 ⇒ 00:19:29.280 Demilade Agboola: I’ll need to.
210 00:19:29.280 ⇒ 00:19:30.739 Emily Giant: An hour and a date?
211 00:19:31.410 ⇒ 00:19:39.239 Demilade Agboola: So it was fine before, I just need to be able to, like, debug and figure out, like, where exactly things change, and what’s… what that change is looking like.
212 00:19:39.240 ⇒ 00:19:40.050 Emily Giant: Yeah.
213 00:19:40.050 ⇒ 00:19:47.840 Demilade Agboola: is… Inventory… Historical.
214 00:20:06.000 ⇒ 00:20:09.979 Demilade Agboola: So just run it now. I know it’s going to fail, but at least let’s get the latest snapshot.
215 00:20:10.730 ⇒ 00:20:11.410 Emily Giant: Okay.
216 00:20:28.200 ⇒ 00:20:32.680 Demilade Agboola: We rename things in the inventory… the Martin Inventory Law table, right?
217 00:20:34.170 ⇒ 00:20:34.970 Emily Giant: Yes.
218 00:20:35.330 ⇒ 00:20:36.400 Demilade Agboola: Okay.
219 00:20:38.460 ⇒ 00:20:43.270 Demilade Agboola: I will need to just figure out what the changes are.
220 00:20:45.280 ⇒ 00:20:51.940 Emily Giant: Oh, we’re back to Christmas carols?
221 00:20:52.380 ⇒ 00:20:53.540 Demilade Agboola: I’m in.
222 00:20:53.980 ⇒ 00:20:56.500 Emily Giant: we’re never really off of Christmas carols, right?
223 00:20:56.500 ⇒ 00:20:58.060 Demilade Agboola: Exactly.
224 00:20:59.810 ⇒ 00:21:02.289 Demilade Agboola: I was never wrong just early, you know?
225 00:21:04.500 ⇒ 00:21:12.359 Emily Giant: Let me try, like, a different filter or something. I don’t… Okay, inventory timestamp time…
226 00:21:20.190 ⇒ 00:21:21.070 Demilade Agboola: Hmm.
227 00:21:22.050 ⇒ 00:21:24.590 Emily Giant: It’s in the last… oh, it’s not range.
228 00:21:24.960 ⇒ 00:21:31.420 Emily Giant: Let’s do… just, like, a month ago. And… 01…
229 00:21:38.750 ⇒ 00:21:39.760 Emily Giant: 3.
230 00:21:41.120 ⇒ 00:21:43.660 Emily Giant: And then this slot’s not going to exist.
231 00:22:16.680 ⇒ 00:22:18.020 Demilade Agboola: Thank you, I don’t know.
232 00:22:36.110 ⇒ 00:22:39.210 Emily Giant: Okay, so the different filters doesn’t change it.
233 00:22:39.770 ⇒ 00:22:46.910 Demilade Agboola: I was looking at my… trying to just figure out, like, the changes in the schema. What are we doing right now?
234 00:22:47.720 ⇒ 00:22:52.460 Emily Giant: Oh, I was just running earlier dates to see if, like, Is this true?
235 00:22:52.460 ⇒ 00:22:53.640 Demilade Agboola: to start it, though.
236 00:22:54.670 ⇒ 00:22:56.290 Emily Giant: This is a different lot.
237 00:22:56.790 ⇒ 00:22:59.439 Demilade Agboola: But is this an active law? Like, is it within the start?
238 00:22:59.440 ⇒ 00:23:00.740 Emily Giant: Oh, it’s not active.
239 00:23:00.740 ⇒ 00:23:03.989 Demilade Agboola: It’s not active, so you wouldn’t expect it to change then.
240 00:23:04.550 ⇒ 00:23:09.140 Emily Giant: I would still expect, if I looked back, to show the changes over the course of that day.
241 00:23:11.460 ⇒ 00:23:17.479 Emily Giant: Like, it was active on this day, that’s what I’m… that’s what I’m trying to say. Yeah, yeah, yeah, it filtered for a lot that was active on this day.
242 00:23:17.630 ⇒ 00:23:18.330 Demilade Agboola: Gotcha.
243 00:23:19.710 ⇒ 00:23:21.969 Demilade Agboola: So, why is it being wonky?
244 00:23:23.010 ⇒ 00:23:29.550 Demilade Agboola: when does it… okay, can we see when it changed to 10, or when it changed away from 10? Like, at what period does it, like…
245 00:23:33.820 ⇒ 00:23:37.040 Emily Giant: So, let me just… Filter for that lot.
246 00:23:37.350 ⇒ 00:23:38.670 Emily Giant: and without…
247 00:23:39.120 ⇒ 00:23:40.909 Demilade Agboola: The time frame, yeah.
248 00:23:44.250 ⇒ 00:23:45.675 Demilade Agboola: Mmm… Hmm…
249 00:23:46.420 ⇒ 00:23:59.200 Emily Giant: And I have the song that, like, ride in my train, high on cocaine. I don’t know why. I… I’m not high on cocaine.
250 00:23:59.340 ⇒ 00:24:02.359 Emily Giant: I’m not on a train. None of it makes sense.
251 00:24:02.600 ⇒ 00:24:03.360 Demilade Agboola: Bye.
252 00:24:04.070 ⇒ 00:24:05.349 Emily Giant: Okay, so now we…
253 00:24:05.350 ⇒ 00:24:07.500 Demilade Agboola: Popcane is really popular here in Malta.
254 00:24:07.900 ⇒ 00:24:08.810 Emily Giant: It is.
255 00:24:08.810 ⇒ 00:24:09.950 Demilade Agboola: Yeah.
256 00:24:09.950 ⇒ 00:24:16.839 Emily Giant: That’s scary. I don’t know if it’s… like, in the United States, everyone dies from fentanyl, because they lace it.
257 00:24:17.690 ⇒ 00:24:20.789 Emily Giant: Hopefully it’s not the same case there, if it’s popular.
258 00:24:21.350 ⇒ 00:24:30.280 Demilade Agboola: I mean, I haven’t seen it, but people do be saying, like, it’s… if you go clubbing and go to certain parts of the club, you’ll… you’ll see cocaine. I’m like, alright.
259 00:24:31.110 ⇒ 00:24:31.770 Emily Giant: Yep.
260 00:24:32.580 ⇒ 00:24:34.740 Emily Giant: I’ll stay at this part of the club, then.
261 00:24:34.740 ⇒ 00:24:37.179 Demilade Agboola: Okay, so it goes from 104…
262 00:24:38.310 ⇒ 00:24:42.240 Emily Giant: Which is when it’s sold out. These are backward.
263 00:24:42.240 ⇒ 00:24:42.559 Demilade Agboola: I was like.
264 00:24:42.560 ⇒ 00:24:44.750 Emily Giant: That is the most confusing.
265 00:24:45.490 ⇒ 00:24:49.740 Emily Giant: Okay, it switches from… on…
266 00:24:51.610 ⇒ 00:24:52.449 Demilade Agboola: Okay, so that…
267 00:24:52.450 ⇒ 00:24:53.430 Emily Giant: 3rd.
268 00:24:55.760 ⇒ 00:24:58.920 Emily Giant: And then… On the 3rd.
269 00:24:58.920 ⇒ 00:25:01.670 Demilade Agboola: It just kind of jumps by 1 hour, basically.
270 00:25:01.670 ⇒ 00:25:02.600 Emily Giant: Yeah.
271 00:25:03.240 ⇒ 00:25:07.420 Demilade Agboola: Which, I don’t think in between 2 and 3, you sold.
272 00:25:07.550 ⇒ 00:25:08.320 Emily Giant: No.
273 00:25:08.320 ⇒ 00:25:09.020 Demilade Agboola: 19.
274 00:25:09.320 ⇒ 00:25:14.070 Emily Giant: That’s our hour, that’s our big hour, right there.
275 00:25:15.120 ⇒ 00:25:18.469 Demilade Agboola: Well, then it also starts off at 10, though. Is that…
276 00:25:19.000 ⇒ 00:25:20.810 Demilade Agboola: Was that, like, the presold quantity?
277 00:25:21.840 ⇒ 00:25:23.209 Emily Giant: I guess so, yeah.
278 00:25:23.360 ⇒ 00:25:24.809 Emily Giant: Has to have been.
279 00:25:27.050 ⇒ 00:25:28.370 Demilade Agboola: Okay.
280 00:25:28.660 ⇒ 00:25:32.220 Demilade Agboola: But it said the road, which results may be incomplete.
281 00:25:45.700 ⇒ 00:25:48.509 Demilade Agboola: Take it on away from me.
282 00:26:00.880 ⇒ 00:26:04.169 Emily Giant: And then it just appears that we never had any quantity on hand.
283 00:26:05.630 ⇒ 00:26:06.490 Demilade Agboola: Hmm…
284 00:26:07.900 ⇒ 00:26:08.750 Emily Giant: Very odd.
285 00:26:10.800 ⇒ 00:26:15.949 Demilade Agboola: I don’t know if this is a weird lot, or if this is just the model acting up.
286 00:26:16.210 ⇒ 00:26:20.410 Demilade Agboola: Can we check one more lot, and if, like, within the time frame, and if it’s…
287 00:26:20.960 ⇒ 00:26:23.550 Demilade Agboola: Doing the same, then we can go the model as axing up.
288 00:26:24.260 ⇒ 00:26:27.119 Emily Giant: Yeah, let me pull it from Dashie…
289 00:26:31.450 ⇒ 00:26:32.630 Emily Giant: Time…
290 00:26:35.880 ⇒ 00:26:37.080 Emily Giant: Balti.
291 00:26:45.540 ⇒ 00:26:47.750 Emily Giant: Riding my train.
292 00:26:50.170 ⇒ 00:26:51.210 Demilade Agboola: cocaine.
293 00:26:53.750 ⇒ 00:26:55.449 Emily Giant: Dooo, do, doo.
294 00:26:56.620 ⇒ 00:26:57.489 Demilade Agboola: Oh…
295 00:27:04.130 ⇒ 00:27:05.409 Emily Giant: No results.
296 00:27:06.770 ⇒ 00:27:07.679 Emily Giant: Oh, it’s.
297 00:27:07.680 ⇒ 00:27:08.250 Demilade Agboola: 7 days.
298 00:27:08.250 ⇒ 00:27:12.660 Emily Giant: Because I went to the wrong… I went to the completely wrong tab. Sorry. Muppy.
299 00:27:14.020 ⇒ 00:27:15.990 Emily Giant: So that was correct. This is…
300 00:27:16.230 ⇒ 00:27:18.529 Emily Giant: Should not be results for that time frame.
301 00:27:18.830 ⇒ 00:27:19.909 Emily Giant: Wait, what?
302 00:27:36.500 ⇒ 00:27:37.699 Emily Giant: No results.
303 00:27:38.430 ⇒ 00:27:40.549 Emily Giant: Oh, it’s probably not from Baltimore, hold on.
304 00:27:51.240 ⇒ 00:27:54.030 Emily Giant: Okay, is it not floral?
305 00:27:54.910 ⇒ 00:27:56.200 Emily Giant: It’s the Celine.
306 00:28:05.700 ⇒ 00:28:06.530 Emily Giant: Okay.
307 00:28:07.690 ⇒ 00:28:08.839 Emily Giant: This is…
308 00:28:13.970 ⇒ 00:28:20.380 Emily Giant: Okay, these are all, like… Old…
309 00:28:46.750 ⇒ 00:28:49.789 Emily Giant: No… it’s, like, not even turning results for some of these.
310 00:29:03.010 ⇒ 00:29:05.890 Demilade Agboola: Is it the floral of the filter? Perhaps?
311 00:29:06.100 ⇒ 00:29:08.079 Emily Giant: I removed all the filters.
312 00:29:08.080 ⇒ 00:29:08.830 Demilade Agboola: Oh, okay.
313 00:29:12.090 ⇒ 00:29:12.870 Emily Giant: Okay.
314 00:29:13.980 ⇒ 00:29:15.050 Demilade Agboola: Everyone…
315 00:29:16.280 ⇒ 00:29:22.840 Emily Giant: I wanna be forever young. Okay, I need more of a rose, I guess.
316 00:29:29.810 ⇒ 00:29:32.479 Demilade Agboola: Well, we’ve gone to zero, like, available for sale.
317 00:29:34.600 ⇒ 00:29:35.910 Emily Giant: Yeah, that’s…
318 00:29:36.500 ⇒ 00:29:37.589 Demilade Agboola: Can we, like…
319 00:29:45.050 ⇒ 00:29:46.720 Emily Giant: Where do we change?
320 00:29:47.000 ⇒ 00:29:50.530 Emily Giant: Quantity sold is 0, then it jumps to 64.
321 00:29:50.550 ⇒ 00:29:56.860 Demilade Agboola: Yeah, but can we… yeah, but that’s what I’m trying to say. Can we see why it changes? Does it just change, like…
322 00:29:57.870 ⇒ 00:29:59.529 Demilade Agboola: In one hour again.
323 00:29:59.990 ⇒ 00:30:01.810 Emily Giant: It… Yeah.
324 00:30:02.140 ⇒ 00:30:02.810 Demilade Agboola: Yeah.
325 00:30:03.850 ⇒ 00:30:05.120 Emily Giant: Yes, it did.
326 00:30:05.450 ⇒ 00:30:07.429 Demilade Agboola: Again, the same 2 to 4.
327 00:30:10.460 ⇒ 00:30:12.139 Demilade Agboola: Something is weird.
328 00:30:12.870 ⇒ 00:30:14.720 Demilade Agboola: Like, very, very weird.
329 00:30:15.740 ⇒ 00:30:17.679 Emily Giant: It’s not doing the thing.
330 00:30:21.390 ⇒ 00:30:28.220 Emily Giant: Let me see if, like, if it shows anything’s different, because half the time it’s just Looker.
331 00:30:37.470 ⇒ 00:30:38.580 Demilade Agboola: It’s jobs.
332 00:30:44.450 ⇒ 00:30:51.770 Demilade Agboola: Actually, that might be… Can I… what’s the time frame that you were looking at before?
333 00:30:52.370 ⇒ 00:30:55.060 Emily Giant: The time frame I was looking at before,
334 00:30:55.260 ⇒ 00:30:57.639 Emily Giant: Before a meeting just now in Looker?
335 00:30:57.640 ⇒ 00:30:58.390 Demilade Agboola: Yeah, yeah, yeah.
336 00:30:58.720 ⇒ 00:31:02.489 Emily Giant: There’s no time frame, I just filtered for a lot, so…
337 00:31:02.490 ⇒ 00:31:05.500 Demilade Agboola: But, like, what time frame do they fall into?
338 00:31:05.500 ⇒ 00:31:09.340 Emily Giant: Oh, 10… Like, 10 seconds.
339 00:31:09.340 ⇒ 00:31:09.950 Demilade Agboola: Okay.
340 00:31:10.550 ⇒ 00:31:15.970 Emily Giant: Yeah, it shows, like, all the way back to 9… 24.
341 00:31:16.700 ⇒ 00:31:22.609 Demilade Agboola: When there was a quantity available for sale. Let me, let me share my screen so you can kind of see what I think being sure is.
342 00:31:26.230 ⇒ 00:31:31.200 Demilade Agboola: Also, Zoom is quite rude, because as the host, I can actually just replace your screen.
343 00:31:31.200 ⇒ 00:31:38.789 Emily Giant: Oh, no, I like that, because I was still trying to click the button to figure out how, and you’ve already… Oh, yeah, yeah, yeah, yeah.
344 00:31:38.790 ⇒ 00:31:41.129 Demilade Agboola: This is the first, this is when I first started.
345 00:31:41.510 ⇒ 00:31:46.700 Demilade Agboola: And… This is 10… 10, like, 1410, or 10-14, like…
346 00:31:47.890 ⇒ 00:31:50.330 Demilade Agboola: So it’s 10-14 when it starts.
347 00:31:50.440 ⇒ 00:31:56.820 Demilade Agboola: And then the latest one was basically this. So right now, we have…
348 00:31:57.200 ⇒ 00:32:01.490 Demilade Agboola: it’s only to start tracking hourly, because this is when I set up the hourly runs.
349 00:32:03.460 ⇒ 00:32:04.890 Demilade Agboola: Between that period.
350 00:32:07.140 ⇒ 00:32:11.270 Emily Giant: So this should… this is from that period, though. The slot is from 10.
351 00:32:11.790 ⇒ 00:32:12.430 Demilade Agboola: 10.
352 00:32:12.930 ⇒ 00:32:13.530 Emily Giant: Yeah.
353 00:32:15.570 ⇒ 00:32:19.280 Emily Giant: Wait, let me see… I thought that was November.
354 00:32:20.060 ⇒ 00:32:25.209 Demilade Agboola: No, yeah, November is when it ended, but this is the first one I started the scheduled runs.
355 00:32:25.530 ⇒ 00:32:30.500 Emily Giant: Oh, oh, oh, oh, oh, okay, so if I pull a lot from 10…
356 00:32:31.240 ⇒ 00:32:36.090 Demilade Agboola: Anything between 10-14 to… 11.8.
357 00:32:36.350 ⇒ 00:32:37.470 Demilade Agboola: Should be fine.
358 00:32:38.510 ⇒ 00:32:40.260 Emily Giant: Okay, let me see…
359 00:32:45.850 ⇒ 00:32:50.060 Emily Giant: Okay, so if I do… and then the filter for…
360 00:32:51.420 ⇒ 00:32:54.280 Demilade Agboola: Alright, so now you can share your screen.
361 00:32:55.320 ⇒ 00:32:56.030 Emily Giant: Okay.
362 00:32:58.550 ⇒ 00:33:00.060 Emily Giant: Where is Zoom?
363 00:33:05.740 ⇒ 00:33:09.499 Emily Giant: Okay, so if I do, is on or after?
364 00:33:11.000 ⇒ 00:33:12.290 Emily Giant: 1014.
365 00:33:40.200 ⇒ 00:33:42.410 Emily Giant: Still not showing changes, though.
366 00:33:48.700 ⇒ 00:33:53.790 Demilade Agboola: I mean, it won’t change, because at that point, it had already become sold out, so there’s no… there’s no change to show anymore.
367 00:33:55.210 ⇒ 00:33:56.850 Demilade Agboola: Like, for that…
368 00:33:56.850 ⇒ 00:33:59.769 Emily Giant: For this lot. So if I do…
369 00:33:59.940 ⇒ 00:34:07.350 Demilade Agboola: Because at this point, it’s sold out, so every hour is still showing the fact that it’s sold out. But if there’s an active… if there was a lot that was active.
370 00:34:07.500 ⇒ 00:34:12.670 Demilade Agboola: Between 10-14, And 11.8.
371 00:34:13.110 ⇒ 00:34:14.559 Demilade Agboola: It should show.
372 00:34:14.830 ⇒ 00:34:18.140 Demilade Agboola: the changes that occurred within the active period.
373 00:34:22.620 ⇒ 00:34:24.770 Emily Giant: Okay, so this one started on the 8th.
374 00:34:25.739 ⇒ 00:34:28.429 Demilade Agboola: No, but that’s not 10-14, though, that’s after. That’s before.
375 00:34:28.429 ⇒ 00:34:32.439 Emily Giant: Okay, I see what you mean. So…
376 00:34:33.040 ⇒ 00:34:37.750 Demilade Agboola: So you could use… Yeah.
377 00:34:46.360 ⇒ 00:34:48.050 Emily Giant: Find the firecracker…
378 00:34:50.909 ⇒ 00:34:52.159 Demilade Agboola: The form…
379 00:35:04.950 ⇒ 00:35:06.060 Emily Giant: Okay, so…
380 00:35:18.150 ⇒ 00:35:20.909 Emily Giant: Did I choose the same one somehow?
381 00:35:23.280 ⇒ 00:35:24.480 Emily Giant: Guess so.
382 00:35:26.340 ⇒ 00:35:31.280 Emily Giant: Yes, this one should show, because it was… it had sales between the 12th and the 22nd.
383 00:35:31.710 ⇒ 00:35:32.880 Emily Giant: And…
384 00:35:33.100 ⇒ 00:35:38.499 Demilade Agboola: Okay, in that case. So yeah, but from 12 to the 14th, we’ll probably just be flat, but then…
385 00:35:42.290 ⇒ 00:35:44.439 Demilade Agboola: Is that the same person?
386 00:35:44.440 ⇒ 00:35:47.850 Emily Giant: But it always just shows quantity sold 64.
387 00:35:49.020 ⇒ 00:35:50.080 Demilade Agboola: About the same.
388 00:35:50.690 ⇒ 00:35:57.160 Emily Giant: Yeah, but it… it is within those dates. Let me find… One…
389 00:35:57.650 ⇒ 00:35:59.639 Demilade Agboola: Well, isn’t that… again, it starts on the 5th.
390 00:35:59.800 ⇒ 00:36:00.730 Demilade Agboola: of October.
391 00:36:01.030 ⇒ 00:36:04.680 Emily Giant: This one starts the 5th through the… okay, I see what you’re saying.
392 00:36:05.370 ⇒ 00:36:08.120 Emily Giant: Let’s do… where the start date is…
393 00:36:10.330 ⇒ 00:36:11.010 Demilade Agboola: Yeah.
394 00:36:14.730 ⇒ 00:36:18.359 Emily Giant: Okay, maybe…
395 00:36:21.740 ⇒ 00:36:22.709 Emily Giant: Let me just do it.
396 00:36:22.710 ⇒ 00:36:24.309 Demilade Agboola: Does it not to be Baltimoko?
397 00:36:25.310 ⇒ 00:36:26.100 Emily Giant: Yeah.
398 00:36:27.310 ⇒ 00:36:31.960 Emily Giant: Okay, so the autumn harvest… Starts on the 19th.
399 00:36:32.430 ⇒ 00:36:33.250 Emily Giant: Okay. October.
400 00:36:33.990 ⇒ 00:36:35.689 Demilade Agboola: That sh… that should be fine.
401 00:36:46.820 ⇒ 00:36:48.729 Emily Giant: This just shows zero for everything.
402 00:36:49.280 ⇒ 00:36:51.989 Emily Giant: Oh, it’s because it’s a puzzle. I think I…
403 00:36:52.270 ⇒ 00:36:54.680 Emily Giant: I think I copied the wrong thing.
404 00:36:55.950 ⇒ 00:37:00.590 Emily Giant: Oh, God. I’m like, puzzle? Why is that lauded?
405 00:37:01.100 ⇒ 00:37:11.070 Emily Giant: Where’s… Okay, so 10.15… Floral.
406 00:37:45.630 ⇒ 00:37:48.949 Emily Giant: Why is the on-hand always… yeah, this still doesn’t change.
407 00:38:25.620 ⇒ 00:38:31.750 Emily Giant: So either we only sold 5, and then never sold anymore, Which doesn’t sound likely.
408 00:38:34.240 ⇒ 00:38:35.419 Demilade Agboola: Laura, can I see that?
409 00:38:37.090 ⇒ 00:38:38.389 Emily Giant: See, it’s a lot.
410 00:38:39.000 ⇒ 00:38:40.169 Demilade Agboola: Well, you have a block.
411 00:38:40.170 ⇒ 00:38:40.910 Emily Giant: Sorry, yeah.
412 00:38:40.910 ⇒ 00:38:41.470 Demilade Agboola: room.
413 00:38:42.280 ⇒ 00:38:43.220 Emily Giant: It was…
414 00:38:58.350 ⇒ 00:39:01.680 Emily Giant: Nice… sorry, one second. What is that date?
415 00:39:02.270 ⇒ 00:39:03.620 Emily Giant: Okay, 14th?
416 00:39:03.860 ⇒ 00:39:05.980 Emily Giant: It’s the arrival, starts on the 15th.
417 00:39:23.930 ⇒ 00:39:25.689 Emily Giant: So it goes to 5.
418 00:39:29.590 ⇒ 00:39:31.069 Emily Giant: And then it just stops.
419 00:39:35.270 ⇒ 00:39:38.280 Demilade Agboola: So it goes to… quantity sold was 5…
420 00:39:39.720 ⇒ 00:39:42.910 Demilade Agboola: 110, and it just… did he expire?
421 00:39:44.200 ⇒ 00:39:48.340 Emily Giant: It probably did, but why is… there’s never a quantity on hand.
422 00:39:49.610 ⇒ 00:39:51.099 Emily Giant: And that’s odd.
423 00:39:51.100 ⇒ 00:39:54.039 Demilade Agboola: Everyone from, like, even at the top, there’s no quantity on hand.
424 00:41:00.660 ⇒ 00:41:05.449 Emily Giant: So, if… Okay, we have 12 available for sale.
425 00:41:08.430 ⇒ 00:41:09.680 Emily Giant: And then…
426 00:41:16.480 ⇒ 00:41:18.990 Emily Giant: Then it goes to 5 and 8.
427 00:41:20.460 ⇒ 00:41:27.430 Emily Giant: We should see… Spoilage at some point, if there were 3 that got spoiled out, or reconcile.
428 00:41:27.630 ⇒ 00:41:27.960 Demilade Agboola: Yeah.
429 00:42:06.800 ⇒ 00:42:15.860 Emily Giant: So, something’s up with how it’s snapshotting. I… I doubt I can… Do an example report.
430 00:42:16.650 ⇒ 00:42:19.060 Emily Giant: Before the session.
431 00:42:19.950 ⇒ 00:42:21.039 Demilade Agboola: What kind of depends on?
432 00:42:21.580 ⇒ 00:42:27.230 Emily Giant: It’s a 10.30. This is the deck. I just need to add, like…
433 00:42:28.410 ⇒ 00:42:32.150 Emily Giant: One more point for overall accuracy improvement.
434 00:42:35.350 ⇒ 00:42:38.900 Demilade Agboola: I’m trying to see… I know there were lots that came one second.
435 00:42:56.780 ⇒ 00:43:02.969 Emily Giant: Let me quickly see… If I can get any of that North Beam data from…
436 00:43:52.730 ⇒ 00:43:54.919 Emily Giant: I have an error. What?
437 00:44:08.500 ⇒ 00:44:16.899 Demilade Agboola: I’m trying to see… I know, PK was looking at the unicorn…
438 00:44:18.210 ⇒ 00:44:20.980 Demilade Agboola: And that seemed to be fine during that time period.
439 00:44:21.240 ⇒ 00:44:22.070 Emily Giant: Yeah.
440 00:44:22.520 ⇒ 00:44:28.139 Demilade Agboola: So that was… But he wasn’t at the product SKU level?
441 00:44:32.440 ⇒ 00:44:34.439 Demilade Agboola: Come on, let me try and send the thread.
442 00:44:41.270 ⇒ 00:44:44.339 Emily Giant: I need to see what’s in production for…
443 00:44:45.720 ⇒ 00:44:50.529 Emily Giant: in Shopify Sales Line Financials, because it looks messed up in my instance for no reason.
444 00:44:54.740 ⇒ 00:44:57.920 Emily Giant: Like, it all ran okay last night when I did it.
445 00:45:06.800 ⇒ 00:45:08.899 Emily Giant: Okay, yeah, it’s fine in production.
446 00:45:21.220 ⇒ 00:45:26.359 Emily Giant: However… The North Beam stuff isn’t… oh, that’s the wrong model. Derp.
447 00:45:48.960 ⇒ 00:45:50.980 Emily Giant: What is going on?
448 00:46:05.570 ⇒ 00:46:10.350 Emily Giant: Now I’m getting some, like, bizarre error error in staging with backed orders.
449 00:47:16.330 ⇒ 00:47:20.749 Emily Giant: It’s supposed to be because I switched branches, and it’s, like, not up-to-date or something, because…
450 00:47:21.730 ⇒ 00:47:25.809 Emily Giant: I ran a full refresh on this in production, and it was fine.
451 00:47:29.880 ⇒ 00:47:32.529 Demilade Agboola: Did you… have you pulled the changes from production?
452 00:47:33.130 ⇒ 00:47:34.499 Demilade Agboola: Like, the prod branch.
453 00:47:34.800 ⇒ 00:47:39.380 Emily Giant: I guess not, because this is not being fun.
454 00:47:39.760 ⇒ 00:47:43.439 Demilade Agboola: So try and come back and think, and see if there’s the option to pull from remote.
455 00:47:56.290 ⇒ 00:47:57.040 Emily Giant: Huh.
456 00:48:03.320 ⇒ 00:48:06.830 Emily Giant: see if I can just quickly add North Beam attribution…
457 00:49:58.410 ⇒ 00:49:58.965 Emily Giant: John…
458 00:51:21.860 ⇒ 00:51:25.649 Emily Giant: Okay, let’s see if the North Beam attribution works now.
459 00:51:52.910 ⇒ 00:51:59.309 Emily Giant: Don’t know what, date filter to use here, not tag…
460 00:52:02.680 ⇒ 00:52:03.840 Emily Giant: Maybe this.
461 00:52:28.650 ⇒ 00:52:32.129 Emily Giant: Okay, so it’s not pulling in anything, it doesn’t look like.
462 00:52:32.500 ⇒ 00:52:35.160 Emily Giant: Let me just do where it’s not null.
463 00:52:43.500 ⇒ 00:52:44.990 Demilade Agboola: And for nothing retribution.
464 00:52:45.380 ⇒ 00:52:46.170 Emily Giant: Yeah.
465 00:52:50.190 ⇒ 00:52:51.010 Emily Giant: Okay.
466 00:52:51.220 ⇒ 00:52:54.539 Emily Giant: And then, if I do orders…
467 00:52:55.130 ⇒ 00:52:56.210 Demilade Agboola: Or revenue.
468 00:52:56.690 ⇒ 00:52:58.050 Emily Giant: Oh, revenue, that’s great.
469 00:53:06.130 ⇒ 00:53:09.269 Emily Giant: Backed order line items, accrued revenue raw does not exist.
470 00:53:09.370 ⇒ 00:53:13.029 Demilade Agboola: So it’s not… oh, yeah, it’s not… it’s in fact orders, not factor lines.
471 00:53:14.010 ⇒ 00:53:15.130 Emily Giant: Oh, gotcha.
472 00:53:15.500 ⇒ 00:53:18.450 Demilade Agboola: So it’s in the orders itself, so it should be…
473 00:53:18.580 ⇒ 00:53:23.769 Emily Giant: Yeah, I chose the wrong ones. Oopsie days. So here, okay, accrued, fulfilled.
474 00:53:26.830 ⇒ 00:53:27.610 Emily Giant: Wait.
475 00:53:30.270 ⇒ 00:53:34.110 Emily Giant: Those should… these need to be hidden, because those are,
476 00:53:34.260 ⇒ 00:53:41.800 Emily Giant: Just the raw, in order to… Be able to aggregate these.
477 00:53:42.710 ⇒ 00:53:44.660 Demilade Agboola: Which ones? The…
478 00:53:44.660 ⇒ 00:53:46.340 Emily Giant: The ones that are dimensions.
479 00:53:46.370 ⇒ 00:53:47.370 Demilade Agboola: Oh, yeah, yeah.
480 00:53:47.370 ⇒ 00:53:53.899 Emily Giant: usually I hide those from… viewers, so that they’re not like, why doesn’t this ad… like, it…
481 00:53:54.540 ⇒ 00:54:02.970 Emily Giant: I just created this so that if you need to use it in a… Calculation. It shows up.
482 00:54:05.180 ⇒ 00:54:09.399 Emily Giant: This would be a real boon if this worked. Okay, and now I need…
483 00:54:11.300 ⇒ 00:54:18.640 Emily Giant: a time filter that makes sense, so let me… And Shopify orders…
484 00:54:21.090 ⇒ 00:54:22.540 Demilade Agboola: Oh, this is pretty cool.
485 00:54:22.540 ⇒ 00:54:24.260 Emily Giant: Yeah, this is rad.
486 00:54:24.430 ⇒ 00:54:32.220 Emily Giant: So not order line items, orders, so we’ll just say created at.
487 00:54:35.710 ⇒ 00:54:39.800 Emily Giant: And I’m just gonna add it to see, like, what kind of date it shows.
488 00:54:41.200 ⇒ 00:54:45.260 Demilade Agboola: Also, the revenue seems to be back up, like, it’s not as low as it was before.
489 00:54:45.810 ⇒ 00:54:48.889 Emily Giant: Yeah, yeah, I deployed that fix last night.
490 00:54:48.890 ⇒ 00:54:49.480 Demilade Agboola: Nice.
491 00:54:49.480 ⇒ 00:54:53.270 Emily Giant: So it should be… G2G.
492 00:55:01.840 ⇒ 00:55:04.029 Emily Giant: I had to, like, really figure out…
493 00:55:04.590 ⇒ 00:55:13.009 Emily Giant: what the definition of all those things were. Like, the net to make sure everything was added correctly to subtotal,
494 00:55:13.440 ⇒ 00:55:15.379 Emily Giant: Because that was the one that was bonking.
495 00:55:15.890 ⇒ 00:55:23.120 Emily Giant: Yeah. It was not… it was not anything you did, it was… Just Hivo, being Hivo.
496 00:55:25.860 ⇒ 00:55:35.899 Emily Giant: But I thought it was really cool, like, how you split up the, header discount and, like, added back whatever wasn’t in the line item discount. Okay, so the date is…
497 00:55:40.260 ⇒ 00:55:41.910 Demilade Agboola: That’s pretty cool, so you can see for each day.
498 00:55:43.000 ⇒ 00:55:44.510 Demilade Agboola: How much revenue’s coming in?
499 00:55:45.060 ⇒ 00:55:47.740 Emily Giant: Okay, and now I’m gonna filter it so that this is not…
500 00:55:50.480 ⇒ 00:55:53.310 Emily Giant: In the last 7 days, sure, why not?
501 00:56:10.890 ⇒ 00:56:17.199 Emily Giant: lordy, I have got to clean up this look, but… or the… the interface, but still.
502 00:56:17.770 ⇒ 00:56:18.550 Emily Giant: Okay.
503 00:56:19.210 ⇒ 00:56:22.559 Emily Giant: So I’m just gonna put, instead of date, I’ll do week.
504 00:56:24.050 ⇒ 00:56:25.450 Emily Giant: Created week.
505 00:56:26.600 ⇒ 00:56:28.560 Emily Giant: In orders…
506 00:56:36.490 ⇒ 00:56:39.859 Emily Giant: Rakuten. I do not know what Rat… Rakuten…
507 00:56:40.080 ⇒ 00:56:43.450 Emily Giant: Rakuten is, but it makes me think of Rasputin.
508 00:56:46.330 ⇒ 00:56:54.080 Demilade Agboola: Funny enough, I actually… I actually have a friend who works in Rakuten, but in Japan.
509 00:56:54.220 ⇒ 00:56:54.940 Demilade Agboola: Yeah.
510 00:56:57.120 ⇒ 00:56:58.140 Emily Giant: Okay, let me…
511 00:56:58.380 ⇒ 00:57:02.679 Demilade Agboola: But she… it’s pretty cool, because, like, we grew up… she went to my, like, primary school.
512 00:57:03.750 ⇒ 00:57:07.510 Demilade Agboola: Went to different secondary schools, but we met again when I went in university.
513 00:57:07.920 ⇒ 00:57:09.210 Demilade Agboola: And then…
514 00:57:09.630 ⇒ 00:57:14.050 Demilade Agboola: it’s just cool seeing her, like, all the way from, like, Nigeria and, like, Japan, like, working in.
515 00:57:14.050 ⇒ 00:57:14.920 Emily Giant: Yeah.
516 00:57:16.280 ⇒ 00:57:20.369 Emily Giant: That’s awesome. I would love to live in Japan. It’s so clean.
517 00:57:21.240 ⇒ 00:57:24.539 Demilade Agboola: She does seem to like it, she’s on my Instagram, so she does seem to like it.
518 00:57:24.540 ⇒ 00:57:26.640 Emily Giant: Yeah, is she in Tokyo?
519 00:57:28.680 ⇒ 00:57:33.509 Demilade Agboola: I’m not sure, to be honest, I haven’t asked. I do know she moves around quite a bit, but, like, in Japan.
520 00:57:33.510 ⇒ 00:57:34.170 Emily Giant: Beauty.
521 00:57:34.980 ⇒ 00:57:38.919 Emily Giant: It’s… how far is Japan from Malta?
522 00:57:39.620 ⇒ 00:57:42.789 Emily Giant: My guess will be pretty far.
523 00:57:44.190 ⇒ 00:57:45.030 Emily Giant: Okay.
524 00:57:45.030 ⇒ 00:57:50.250 Demilade Agboola: Like, yeah, to Osaka will be a 15-hour flight, to Tokyo will be 15 hours, too.
525 00:57:52.330 ⇒ 00:57:56.039 Emily Giant: Let me remove this so that it’s a little cleaner. 15?
526 00:57:56.430 ⇒ 00:58:05.630 Emily Giant: My god! I guess we go the other way around the world, or we go, like, over the top of the world, maybe? I forget that the world is round, and we don’t have to fly side to side.
527 00:58:06.320 ⇒ 00:58:08.259 Demilade Agboola: Yeah, because Molta’s kind of, like, in the middle.
528 00:58:08.470 ⇒ 00:58:16.510 Demilade Agboola: If you… if you think of it that way, which is why to, like, the US is, like, an 8-hour flight, or 9-hour flight, open way in the US, actually, it could be 12.
529 00:58:17.000 ⇒ 00:58:19.610 Emily Giant: Wait, Matt, what did you say? From Malta?
530 00:58:20.080 ⇒ 00:58:20.890 Emily Giant: Oh.
531 00:58:21.040 ⇒ 00:58:28.839 Emily Giant: No, he’s just being a jerk. Matt’s a pilot, so he was listening to us, and it was like, no, no. How far is Malta from Japan?
532 00:58:30.080 ⇒ 00:58:31.799 Emily Giant: You said far.
533 00:58:31.800 ⇒ 00:58:41.860 Demilade Agboola: Yeah, it stays far, like, because Malta is kind of like Europe in that part, and so it’s kind of far to Asia, and it’s kind of far to the US, so… Yeah.
534 00:58:43.380 ⇒ 00:58:53.730 Emily Giant: he was, making fun of me, because I said, I forget you can fly, like, you can go bottom and top, you don’t have to just go side to side, because the world is round. He goes, it’s not. He was pretending to be a flat earther, which is one of his favorite things.
535 00:58:53.840 ⇒ 00:59:00.749 Emily Giant: To pretend to be, since he can actually see, like, the curve of the world, when he works.
536 00:59:04.380 ⇒ 00:59:07.169 Demilade Agboola: The curve, you mean the straight line?
537 00:59:07.170 ⇒ 00:59:10.569 Emily Giant: Yeah, the straight line, and then you just hit the wall, and then have to turn around.
538 00:59:11.870 ⇒ 00:59:14.160 Emily Giant: Are you, like, fly into space?
539 00:59:18.090 ⇒ 00:59:29.579 Emily Giant: So nonsensical. Okay, I have to hop to my other meeting, but this does look like it’s working. I guess I’ll just, not include in this demo.
540 00:59:29.580 ⇒ 00:59:42.569 Emily Giant: The snapshot data is fine, as long as it… because I’m going to add it to, like, a Looker board so that they can reference them. I don’t want to show them during the meeting, I’m just going to say, here, go look at it when you want.
541 00:59:42.940 ⇒ 00:59:48.100 Emily Giant: Because I don’t… people will get, like, oh, do this, do this, do this, and I’m like, ugh…
542 00:59:48.300 ⇒ 00:59:51.429 Emily Giant: I only have 10 minutes to talk, people, so…
543 00:59:51.590 ⇒ 00:59:55.350 Emily Giant: Alright, I think this is gonna work, though. This is pretty cool.
544 00:59:55.660 ⇒ 00:59:58.950 Demilade Agboola: this north beam, and real clean looking, so…
545 00:59:58.950 ⇒ 01:00:07.109 Emily Giant: I just need to do a little bit of validation with the revenue, but it doesn’t look crazy at all to me. It looks, like, legit.
546 01:00:08.310 ⇒ 01:00:14.230 Emily Giant: And then I’ll just tell them, like, then we can tie it to forecast, and, like, do…
547 01:00:14.520 ⇒ 01:00:23.069 Emily Giant: Alright, let’s see, so 1027… We don’t have any data, because we probably weren’t ingesting it.
548 01:00:23.340 ⇒ 01:00:31.030 Emily Giant: I’m just gonna unpivot… And then do the last complete week.
549 01:00:33.240 ⇒ 01:00:41.720 Emily Giant: Alright, I gotta hop, but thank you so much for hearing me out on the snapshots, and I don’t think I have a lot today after this meeting.
550 01:00:41.950 ⇒ 01:00:54.140 Emily Giant: outside of a midday nap, that might happen. So, if you have any more questions, or want to work through that duplication in the revenue mark, because everything looks good, it’s just the dupes.
551 01:00:54.280 ⇒ 01:00:54.810 Emily Giant: Alright.
552 01:00:54.810 ⇒ 01:01:06.720 Demilade Agboola: I will… I will fix that… the dupe and the fulfill quantity on re-deliveries, and I’ll push that today. I’ll also work on the inventory snapshot thingy, because it was working fine before, I just want to get everything back.
553 01:01:07.090 ⇒ 01:01:08.469 Demilade Agboola: So, yeah.
554 01:01:09.370 ⇒ 01:01:14.660 Emily Giant: If and when you’re in there working on the inventory snapshot, can you look at the GA4 snapshot, too, and see, like…
555 01:01:14.890 ⇒ 01:01:16.100 Emily Giant: Why…
556 01:01:16.100 ⇒ 01:01:17.620 Demilade Agboola: Can you send me the name of the GF?
557 01:01:17.620 ⇒ 01:01:19.310 Emily Giant: Yeah, yeah, I will.
558 01:01:19.310 ⇒ 01:01:19.820 Demilade Agboola: Let’s hear that.
559 01:01:19.820 ⇒ 01:01:21.879 Emily Giant: Okay. Alright, I’ll talk to you soon. Gotta hop.
560 01:01:21.880 ⇒ 01:01:22.450 Demilade Agboola: article.
561 01:01:22.770 ⇒ 01:01:23.560 Emily Giant: Bye.