Meeting Title: Shopify Orders and Sessions Sync Date: 2025-10-15 Meeting participants: Demilade Agboola, Emily Giant, pk.arthur
WEBVTT
1 00:00:19.240 ⇒ 00:00:20.680 Emily Giant: Hello!
2 00:00:22.880 ⇒ 00:00:24.470 Demilade Agboola: Hi, Emily, how are you?
3 00:00:25.380 ⇒ 00:00:32.450 Emily Giant: I’m good. I’m hoping that this morning is less chaotic than yesterday morning, when I had to, like, run around turning alarms off.
4 00:00:33.470 ⇒ 00:00:34.720 Demilade Agboola: I hope so, too.
5 00:00:35.040 ⇒ 00:00:36.370 Emily Giant: How are you?
6 00:00:36.370 ⇒ 00:00:40.769 Demilade Agboola: I’m doing alright. Just doing fine. How’s Piki, how are you?
7 00:00:41.160 ⇒ 00:00:42.959 pk.arthur: I’m doing well, good morning, guys.
8 00:00:42.960 ⇒ 00:00:44.100 Emily Giant: Good morning.
9 00:00:44.100 ⇒ 00:00:51.719 pk.arthur: Doing well. Trying to stay warm here on the East Coast. It’s just been… Very rainy and…
10 00:00:51.830 ⇒ 00:00:54.989 pk.arthur: And not sunny, so just trying to stay warm.
11 00:00:55.340 ⇒ 00:00:58.260 Emily Giant: Yeah, isn’t there, like, a lot of floods and stuff?
12 00:00:58.790 ⇒ 00:01:10.180 pk.arthur: I’ve heard about it, but, like, not really where… not in… not really Maryland, to be honest, but I’m sure there’s some… there’s some areas that are, like, below sea level that are…
13 00:01:10.180 ⇒ 00:01:10.840 Emily Giant: Yeah.
14 00:01:10.840 ⇒ 00:01:11.910 pk.arthur: Went through floods.
15 00:01:12.350 ⇒ 00:01:15.980 Emily Giant: I heard Long Island, is really getting hit.
16 00:01:16.160 ⇒ 00:01:18.539 pk.arthur: Mmm, that would make sense.
17 00:01:19.330 ⇒ 00:01:22.639 Emily Giant: Yeah, they are, like, in the middle of the ocean, so…
18 00:01:22.640 ⇒ 00:01:25.000 pk.arthur: That makes sense. Yeah.
19 00:01:25.820 ⇒ 00:01:34.460 Emily Giant: But my partner works for the airline industry, and he said… he’s not working right now because of his surgery, but, he said that, like.
20 00:01:34.590 ⇒ 00:01:38.190 Emily Giant: Everyone he knows, all of the other pilots are, like, stuck.
21 00:01:38.430 ⇒ 00:01:49.869 Emily Giant: And, like, flights are just not taking off because of the storms. And I was like, oh man, I didn’t even realize that anything was happening out there in the world. I’ve just been…
22 00:01:50.500 ⇒ 00:01:53.489 Emily Giant: At my computer, working on subscription models.
23 00:01:57.020 ⇒ 00:02:04.009 Demilade Agboola: No, I’m out here wondering… I’m actually out here wondering if, like, pilots get paid even if their flights get, like, canceled.
24 00:02:04.780 ⇒ 00:02:12.280 Emily Giant: That’s a good question, and the answer is yes. I think that they do, but they’re hourly employees, which is weird, so, like…
25 00:02:12.880 ⇒ 00:02:17.670 Emily Giant: I need to… I need to ask. I feel like if they make it to the airport.
26 00:02:18.180 ⇒ 00:02:21.190 Emily Giant: then they still get paid. But…
27 00:02:21.770 ⇒ 00:02:29.080 Emily Giant: But I have to ask, I don’t know. I don’t ask enough questions, because so many other people do, that I’m like, I don’t want to hound them with questions, but…
28 00:02:29.670 ⇒ 00:02:30.860 Emily Giant: a good one.
29 00:02:31.150 ⇒ 00:02:33.300 Demilade Agboola: Yeah, I was just curious.
30 00:02:33.300 ⇒ 00:02:39.160 Emily Giant: Well, I know they get paid for sitting on their butt at home for a year after a surgery.
31 00:02:39.160 ⇒ 00:02:42.840 Demilade Agboola: So… That’s a good one, though.
32 00:02:43.100 ⇒ 00:02:43.920 Emily Giant: Yep.
33 00:02:44.330 ⇒ 00:02:45.940 Demilade Agboola: Yep. That’s a good one.
34 00:02:46.310 ⇒ 00:02:50.030 Emily Giant: he had to get a CPAP, because he snores, and
35 00:02:50.160 ⇒ 00:02:57.979 Emily Giant: He got paid sick leave for, like, 2 months, because he just chose to get one that was, like.
36 00:02:58.450 ⇒ 00:03:16.349 Emily Giant: not deliverable for 2 months, even though there are thousands of CPAPs that are readily available. And you’re not allowed to fly. If you’ve been diagnosed with sleep apnea of any kind, you can’t fly until you have it. So he just got paid for 2 months, like, pretending to wait on a CPAP.
37 00:03:17.330 ⇒ 00:03:18.450 Demilade Agboola: That’s fascinating, huh.
38 00:03:18.450 ⇒ 00:03:21.390 Emily Giant: Yeah. They’ve got a lot of good loopholes like that.
39 00:03:23.590 ⇒ 00:03:24.140 Demilade Agboola: Interesting.
40 00:03:24.740 ⇒ 00:03:37.029 Emily Giant: Yeah. But anyway, I invited PK today because, we worked on the seed file yesterday, and I just wanted to, like, help him with next steps on some of the tickets, and I feel like you’ve been…
41 00:03:37.230 ⇒ 00:03:44.269 Emily Giant: a little closer to some of the Shopify models that are in the tickets, so… Okay.
42 00:03:44.660 ⇒ 00:03:47.730 Emily Giant: PK, did you want to start with your question about sessions?
43 00:03:48.330 ⇒ 00:03:50.280 pk.arthur: Yes, so…
44 00:03:50.390 ⇒ 00:03:59.170 pk.arthur: I spoke to Chris late last week about… I know how we discussed about how Shopify sessions, basically GA4 sessions.
45 00:03:59.570 ⇒ 00:04:03.990 Demilade Agboola: Yeah, so I just wanted to relay that information to him, but he…
46 00:04:03.990 ⇒ 00:04:12.500 pk.arthur: was… he, said that, there might actually be a few differences. So, for example, he says that both
47 00:04:12.680 ⇒ 00:04:17.319 pk.arthur: both Shopify and GA4 have their own,
48 00:04:17.959 ⇒ 00:04:34.279 pk.arthur: tracking tool that basically tracks users… that basically tracks users, right? So, the numbers might be different, and he does not think that Shopify gets it from GA4 directly, but I told him what you guys told me, and he said, yeah, he does not think that happened, so…
49 00:04:34.280 ⇒ 00:04:41.449 pk.arthur: if it would be able to… it would be possible to get sessions from Shopify, that would be very, very great as well.
50 00:04:42.040 ⇒ 00:04:48.750 pk.arthur: Additionally, another thing that I just noticed was… or last week, was that the orders… the orders from…
51 00:04:49.350 ⇒ 00:04:57.479 pk.arthur: Shopify on their platform does… does not really match the orders that’s populated into Looker.
52 00:04:58.380 ⇒ 00:05:02.969 pk.arthur: For some reason. So, if we could work on that today, that would be great.
53 00:05:03.100 ⇒ 00:05:08.950 Emily Giant: Yeah, can you… do you have any examples of, like… when you say orders, are you talking about, like.
54 00:05:09.140 ⇒ 00:05:12.150 Emily Giant: The count of orders, the revenue, like, what…
55 00:05:12.150 ⇒ 00:05:17.410 pk.arthur: Count and revenue. I have a example up I’m looking at right now.
56 00:05:18.600 ⇒ 00:05:21.260 pk.arthur: That I could share my screen if you guys want.
57 00:05:21.260 ⇒ 00:05:22.089 Emily Giant: Yeah, they’re great.
58 00:05:22.090 ⇒ 00:05:22.980 Demilade Agboola: That’ll be clear.
59 00:05:26.560 ⇒ 00:05:30.570 pk.arthur: to share… Can you guys see my screen?
60 00:05:30.570 ⇒ 00:05:31.200 Emily Giant: Yep.
61 00:05:31.410 ⇒ 00:05:36.259 pk.arthur: Okay, so this is basically just a Shopify dashboard for October 9th.
62 00:05:37.140 ⇒ 00:05:48.799 pk.arthur: And here you can see, like, the sessions, total sales is, like, 114, orders is $976, but when I go into this, Looker, and I…
63 00:05:49.020 ⇒ 00:06:06.810 pk.arthur: basically tried to fill, like, do the same thing. I was kind of confused within, like, the updated data and the created… created that date, so I messed around with both, but, like, neither of them, came close to that number that I was expecting to see from Shopify.
64 00:06:07.560 ⇒ 00:06:15.009 Emily Giant: So, one difference… okay, yeah, definitely there’s a discrepancy, but Shopify doesn’t have B2B orders,
65 00:06:15.680 ⇒ 00:06:20.270 Emily Giant: So I guess that wouldn’t be in this data either. I was, can you add…
66 00:06:21.430 ⇒ 00:06:24.320 Demilade Agboola: What was the number from Shopify directly?
67 00:06:24.530 ⇒ 00:06:25.150 Emily Giant: Yeah.
68 00:06:25.290 ⇒ 00:06:28.619 pk.arthur: Sales is 114, or this is 1976.
69 00:06:31.950 ⇒ 00:06:37.039 Demilade Agboola: Is there a way we can extract the list of the 976 orders?
70 00:06:37.040 ⇒ 00:06:37.920 Emily Giant: she…
71 00:06:38.630 ⇒ 00:06:39.499 pk.arthur: By the actual orders?
72 00:06:40.790 ⇒ 00:06:41.570 pk.arthur: Yeah, yeah.
73 00:06:42.110 ⇒ 00:06:45.739 Emily Giant: Yeah, I was gonna say the same thing to melade. I was like, let’s do a side-by-side.
74 00:06:46.020 ⇒ 00:06:49.749 pk.arthur: Like, to see, like, who exactly ordered it? Is that what you’re asking, right?
75 00:06:49.980 ⇒ 00:06:54.829 Demilade Agboola: You know, just, like, a list of all the orders, the 976 of those orders.
76 00:06:55.930 ⇒ 00:07:04.930 Emily Giant: So, is there a purchase date? Like, that’s what… can you go back to… well, do this first, but, like, also, I think we should be filtering on, purchase date.
77 00:07:06.240 ⇒ 00:07:08.049 pk.arthur: In Looker or Shopify?
78 00:07:08.560 ⇒ 00:07:09.410 Emily Giant: Looker.
79 00:07:10.830 ⇒ 00:07:18.220 Emily Giant: But do this first, do this first, and then we’ll go through the line of… Troubleshooting.
80 00:07:18.440 ⇒ 00:07:19.070 pk.arthur: Okay.
81 00:07:20.270 ⇒ 00:07:25.389 Demilade Agboola: You can do the second day, I’m trying to export it myself. The separate… you can export orders.
82 00:07:26.780 ⇒ 00:07:29.220 Demilade Agboola: So I’m trying to see if I can export that.
83 00:07:41.570 ⇒ 00:07:47.759 pk.arthur: So this is what you’re asking? So you’re just asking for, like, like, a list of users, or… sorry, I’m still trying to…
84 00:07:48.290 ⇒ 00:07:49.469 pk.arthur: Breathe it out.
85 00:07:52.730 ⇒ 00:07:53.799 Emily Giant: order numbers.
86 00:07:53.800 ⇒ 00:08:01.989 Demilade Agboola: So don’t worry, I’m actually exporting the list right now, so you can check what Emily’s talking about.
87 00:08:01.990 ⇒ 00:08:02.860 pk.arthur: So…
88 00:08:02.860 ⇒ 00:08:03.720 Demilade Agboola: participate.
89 00:08:03.990 ⇒ 00:08:07.420 pk.arthur: I don’t think there’s a purchase date in the order table.
90 00:08:07.420 ⇒ 00:08:11.919 Emily Giant: Can you do created at instead, because updated at’s gonna be when they’re fulfilled.
91 00:08:12.460 ⇒ 00:08:20.019 Emily Giant: Or when something in… The system changes, so, like, if there’s a forced upgrade, or something like that.
92 00:08:26.900 ⇒ 00:08:34.029 Emily Giant: And then the other thing that I would recommend adding is, alright, so that takes it…
93 00:08:34.429 ⇒ 00:08:35.890 Emily Giant: A little closer.
94 00:08:36.059 ⇒ 00:08:36.659 pk.arthur: Alright, give me a second.
95 00:08:36.659 ⇒ 00:08:36.979 Emily Giant: But…
96 00:08:37.510 ⇒ 00:08:39.100 pk.arthur: Just filter…
97 00:08:57.060 ⇒ 00:09:03.500 Emily Giant: Okay, so that’s way closer. And then I would… I would add,
98 00:09:04.860 ⇒ 00:09:09.679 Emily Giant: a flag for, like, isn’t canceled? I don’t know what it’s called, but I’m sure that
99 00:09:10.160 ⇒ 00:09:12.220 Emily Giant: There’s something like that in there.
100 00:09:12.770 ⇒ 00:09:15.079 Emily Giant: Or even order status.
101 00:09:15.850 ⇒ 00:09:18.100 Emily Giant: Something like order status might…
102 00:09:24.800 ⇒ 00:09:26.049 pk.arthur: Order status U.
103 00:09:26.050 ⇒ 00:09:28.530 Emily Giant: Yeah, let’s…
104 00:09:29.080 ⇒ 00:09:35.840 Emily Giant: Subscription status? No, none of the… it’s none of those. Try fulfillment status, add it as a filter.
105 00:09:37.320 ⇒ 00:09:39.460 Emily Giant: And then, let’s see what those options are.
106 00:09:40.810 ⇒ 00:09:41.380 pk.arthur: Hmm.
107 00:09:41.380 ⇒ 00:09:42.360 Emily Giant: Great, and fun.
108 00:09:42.700 ⇒ 00:09:44.669 pk.arthur: Let me just add it real quick to see.
109 00:09:44.830 ⇒ 00:09:46.359 pk.arthur: Actually, that would be…
110 00:09:46.360 ⇒ 00:09:47.330 Emily Giant: That’s a good idea.
111 00:09:47.490 ⇒ 00:09:47.920 pk.arthur: Yeah.
112 00:09:47.920 ⇒ 00:09:49.339 Emily Giant: Yeah, that’s a great idea.
113 00:09:50.140 ⇒ 00:09:53.129 Emily Giant: Because if… what I’m looking for is, like, canceled.
114 00:09:56.290 ⇒ 00:09:57.650 Emily Giant: Great, okay.
115 00:09:57.950 ⇒ 00:10:02.359 Emily Giant: It does exist, I don’t know why it’s saying that, but okay.
116 00:10:03.660 ⇒ 00:10:05.759 pk.arthur: Let me see…
117 00:10:06.990 ⇒ 00:10:11.830 Emily Giant: So it’s just not grabbing it from the table right now. I don’t know if it’s, like, something that we’ve added…
118 00:10:12.130 ⇒ 00:10:13.530 Emily Giant: or removed.
119 00:10:13.740 ⇒ 00:10:17.280 Emily Giant: In hindsight, but, like, I don’t… that’s really weird.
120 00:10:17.490 ⇒ 00:10:21.229 pk.arthur: So you think, like, you should be able… this should have, like, a cancel status, and…
121 00:10:21.380 ⇒ 00:10:28.380 Emily Giant: Yeah, what I’m looking for is, like, anything like that. Let’s try financial status and see if that one is a real thing.
122 00:10:31.320 ⇒ 00:10:35.430 Emily Giant: And then this is in the line items. I would think it… there would be something in the,
123 00:10:35.730 ⇒ 00:10:39.570 Emily Giant: the Shopify orders, as opposed to line items, that might be helpful.
124 00:10:40.980 ⇒ 00:10:44.580 pk.arthur: So, whatever this order status URL, maybe?
125 00:10:44.910 ⇒ 00:10:52.860 Emily Giant: Erase status, let’s just see what’s available at all in, the Shopify orders flags.
126 00:10:53.890 ⇒ 00:11:04.540 Emily Giant: So, the S-T-A-T? Oh. Okay, voided is 9. Paid $999. Closer… Refunded is 11.
127 00:11:05.250 ⇒ 00:11:10.380 pk.arthur: So yeah, definitely, if I… Just filter for pain, maybe?
128 00:11:11.350 ⇒ 00:11:14.870 Emily Giant: That one’s still, like, I feel like it’s still gonna be dirt, like, dirty.
129 00:11:14.870 ⇒ 00:11:16.500 pk.arthur: Somehow.
130 00:11:16.560 ⇒ 00:11:18.190 Emily Giant: How about the revenue?
131 00:11:19.080 ⇒ 00:11:22.340 Emily Giant: Or the sales amount. Is that closer there?
132 00:11:23.170 ⇒ 00:11:24.860 Emily Giant: That, minus the…
133 00:11:25.230 ⇒ 00:11:27.690 pk.arthur: The total amount for that day was $114.
134 00:11:27.920 ⇒ 00:11:35.050 pk.arthur: 114, 634, so when you add all this, like, very close, but if you only look at pay, then…
135 00:11:35.470 ⇒ 00:11:37.060 pk.arthur: It’s much lower.
136 00:11:37.390 ⇒ 00:11:40.369 Emily Giant: It’d be paid plus partially… yeah, you’re right.
137 00:11:40.840 ⇒ 00:11:46.190 Emily Giant: we need to find a better filter, I think. Can you X out of the find a field, the STAT?
138 00:11:48.670 ⇒ 00:11:51.120 Emily Giant: then go to Shopify Orders.
139 00:11:52.350 ⇒ 00:11:55.980 Emily Giant: And then… Is there a thing called, like, flags?
140 00:11:57.340 ⇒ 00:11:58.420 Emily Giant: No.
141 00:11:59.420 ⇒ 00:11:59.940 pk.arthur: Not that…
142 00:11:59.940 ⇒ 00:12:02.940 Emily Giant: Line item, aggregate, customer journey, customer…
143 00:12:03.410 ⇒ 00:12:07.770 Emily Giant: Try canceled at date, and then just say is null.
144 00:12:27.560 ⇒ 00:12:35.330 Demilade Agboola: Also, there could potentially be a time zone thing going on as well, to the 99… 976999.
145 00:12:35.740 ⇒ 00:12:40.859 pk.arthur: Yeah, that’s part… that’s one thing I was thinking about, too, because, like… That’s a reason.
146 00:12:42.480 ⇒ 00:12:47.239 pk.arthur: So, it was about 976 versus 1008.
147 00:12:48.930 ⇒ 00:12:52.399 Emily Giant: And Shopify doesn’t do… well, I guess this wouldn’t either.
148 00:12:53.900 ⇒ 00:13:01.429 Emily Giant: I was gonna say sub-orders, but I think, Demolata, you’re hitting the nail on the head. I think this is so close that it’s gotta be time zone.
149 00:13:02.730 ⇒ 00:13:07.390 Demilade Agboola: Yeah, so it could be time for another… thin…
150 00:13:08.590 ⇒ 00:13:21.600 pk.arthur: Well, you, like, if it was time zone, though, like, you would think that the number of orders and the sales amounts move in the same direction, right? But, like, you know, how over here is 1,008 for orders?
151 00:13:21.790 ⇒ 00:13:24.550 pk.arthur: And the sales is $1.11, right?
152 00:13:25.660 ⇒ 00:13:35.880 pk.arthur: I would think that it would move in the same direction, like, so let’s say orders would be less, and sales would be less, but, like, here, orders are less, and sales are more on Shopify versus Looker.
153 00:13:35.880 ⇒ 00:13:38.230 Emily Giant: But are they taking into account the refunds?
154 00:13:38.920 ⇒ 00:13:40.320 pk.arthur: That’s a good question.
155 00:13:41.780 ⇒ 00:13:44.179 pk.arthur: That, I honestly do not know.
156 00:13:45.010 ⇒ 00:13:46.040 pk.arthur: Yes.
157 00:13:46.040 ⇒ 00:13:47.460 Emily Giant: Just a good note.
158 00:13:48.490 ⇒ 00:13:55.010 Emily Giant: Yeah, it doesn’t look like it. Total sales equals net sales plus… well, net is minus refunds, right?
159 00:13:55.440 ⇒ 00:14:02.310 Demilade Agboola: Yeah, and also, I’m not… like, what you’re looking at in terms of the… What’s it called?
160 00:14:02.550 ⇒ 00:14:03.919 Demilade Agboola: the revenue.
161 00:14:04.160 ⇒ 00:14:09.140 Demilade Agboola: Doesn’t have shipping charges right now, and taxes right now.
162 00:14:09.580 ⇒ 00:14:11.400 Emily Giant: Yeah, that would make a huge difference.
163 00:14:11.400 ⇒ 00:14:13.160 pk.arthur: Okay, okay, go, okay.
164 00:14:14.490 ⇒ 00:14:18.550 Emily Giant: I’m still curious about the… I think the orders makes total sense that…
165 00:14:19.300 ⇒ 00:14:25.920 Emily Giant: Yeah. So, once we… Demolati’s been doing a ton of work on that, this week.
166 00:14:26.020 ⇒ 00:14:28.030 Emily Giant: With, like, lining up revenue.
167 00:14:28.910 ⇒ 00:14:31.460 Emily Giant: So, I bet…
168 00:14:31.870 ⇒ 00:14:32.250 Demilade Agboola: Yeah, cool.
169 00:14:32.250 ⇒ 00:14:34.520 Emily Giant: That reconciles a lot of that.
170 00:14:34.520 ⇒ 00:14:40.329 Demilade Agboola: Yeah, so, like, yeah, I appears using… I just want to confirm, are you using, in fact, other line items? Emily?
171 00:14:40.530 ⇒ 00:14:42.679 Demilade Agboola: For what, PK’s using right now.
172 00:14:43.140 ⇒ 00:14:45.049 Demilade Agboola: Because I can see other line items.
173 00:14:45.050 ⇒ 00:14:45.570 Emily Giant: targeting.
174 00:14:48.100 ⇒ 00:14:52.709 Emily Giant: Yeah, it’s, he’s using a combination, so I put them in the same Explorer.
175 00:14:52.900 ⇒ 00:14:55.090 Emily Giant: Since they’re never really used separately.
176 00:14:55.390 ⇒ 00:14:55.970 Demilade Agboola: Okay.
177 00:14:55.970 ⇒ 00:15:03.750 Emily Giant: And that way, it’s cleaner for users. So, you can’t actually see Shopify orders without opening Shopify order lines.
178 00:15:04.020 ⇒ 00:15:05.389 Demilade Agboola: Gotcha, gotcha.
179 00:15:05.700 ⇒ 00:15:13.920 Demilade Agboola: Alright, so I think that the thing right now is the, like, total sales amount slash revenue doesn’t yet…
180 00:15:14.510 ⇒ 00:15:21.890 Demilade Agboola: integrate, the… shipping costs. I will not add that to the…
181 00:15:23.320 ⇒ 00:15:27.280 Demilade Agboola: what’s that called? The order. I would add that to the orders, like, this week.
182 00:15:27.500 ⇒ 00:15:32.850 Demilade Agboola: But I just… so it’s shipping costs, taxes, they’re not, like, fully part of that yet.
183 00:15:34.060 ⇒ 00:15:34.420 pk.arthur: That’s right.
184 00:15:34.420 ⇒ 00:15:47.880 Demilade Agboola: Now, because I didn’t want to make things too wonky, I just wanted us to be sure that the numbers were lining up as they should to the actual sold amount, and then add shipping costs and, like, taxes and throwing that.
185 00:15:48.410 ⇒ 00:15:50.089 pk.arthur: Okay, that sounds good, thank you.
186 00:15:50.090 ⇒ 00:15:58.320 Demilade Agboola: Yeah. So that… that’s the… can I… can you… okay, don’t worry, I can just… yeah, can you… I was thinking, could you… I was thinking if you could hover over the orders…
187 00:15:58.670 ⇒ 00:15:59.990 pk.arthur: In Shopify?
188 00:15:59.990 ⇒ 00:16:03.810 Demilade Agboola: Yeah, and just kind of see how the number of orders across all sales channels.
189 00:16:04.810 ⇒ 00:16:07.969 Demilade Agboola: So, kind of, the way those, yeah, the way those are formula.
190 00:16:08.930 ⇒ 00:16:09.880 Demilade Agboola: Okay.
191 00:16:12.980 ⇒ 00:16:15.680 Demilade Agboola: Do they need completed orders, though?
192 00:16:18.260 ⇒ 00:16:24.489 Demilade Agboola: Another thing, can you do… can you try the, Explore and make it the 10th of October? I don’t see something.
193 00:16:25.540 ⇒ 00:16:28.350 pk.arthur: Here, right? Or you mean in Looker?
194 00:16:28.350 ⇒ 00:16:29.240 Demilade Agboola: Looker.
195 00:16:29.240 ⇒ 00:16:29.830 pk.arthur: Okay.
196 00:16:42.980 ⇒ 00:16:44.719 pk.arthur: So, this is the 10th.
197 00:16:54.890 ⇒ 00:17:02.409 Demilade Agboola: It’s so close, you could try… yeah, you see it, it’s so close, there’s something… It’s very close. Yeah. 8801…
198 00:17:04.800 ⇒ 00:17:07.709 Demilade Agboola: Something’s slightly off.
199 00:17:09.270 ⇒ 00:17:15.729 pk.arthur: It honestly could be down to a time zone issue, but by here, the only thing I’m noticing is that the sales and looker is…
200 00:17:15.859 ⇒ 00:17:19.469 pk.arthur: Higher than the sales number in Shopify.
201 00:17:20.470 ⇒ 00:17:25.899 Emily Giant: I think we should still try this export route, Demolade, of exporting both.
202 00:17:27.200 ⇒ 00:17:28.380 Demilade Agboola: Yeah, I agree.
203 00:17:28.980 ⇒ 00:17:31.730 Demilade Agboola: Yeah, I’m waiting for it to come in.
204 00:17:31.730 ⇒ 00:17:34.270 Emily Giant: Oh, that whole chestnut, okay.
205 00:17:34.270 ⇒ 00:17:39.150 Demilade Agboola: Yeah, because… so if you go to, like, even Shopify, PK.
206 00:17:39.500 ⇒ 00:17:41.619 Demilade Agboola: Shopify, and you go to Orders.
207 00:17:44.030 ⇒ 00:17:46.819 Demilade Agboola: You can actually… so if you click on orders.
208 00:17:47.430 ⇒ 00:17:48.449 pk.arthur: Oh, that’s right.
209 00:17:48.450 ⇒ 00:17:56.069 Demilade Agboola: Oh, yeah. So I tried to export the… from the 9th to the… from the 8th to the 10th, so I can get, like, the list of all the orders.
210 00:17:56.660 ⇒ 00:17:59.649 Demilade Agboola: Try and also then do a list of all the orders.
211 00:18:00.580 ⇒ 00:18:10.670 Demilade Agboola: And then comparing to, like, where we’re missing, if we’re missing anything, but that seems to be taking some time. It’s not coming yet, so it’s hard to…
212 00:18:11.480 ⇒ 00:18:13.250 Demilade Agboola: To say anything about that right now?
213 00:18:13.610 ⇒ 00:18:21.490 pk.arthur: Okay, let me know if I can do anything, and then we want to, like, just help make it faster, because there are different…
214 00:18:22.880 ⇒ 00:18:29.359 pk.arthur: It’s another tab where you could just, like, make a report yourself, but I think it’ll be the same thing, though.
215 00:18:31.610 ⇒ 00:18:33.170 Demilade Agboola: Yeah, yeah.
216 00:18:36.780 ⇒ 00:18:42.719 pk.arthur: But yeah, so, let me know how that goes, and keep an eye out for it.
217 00:18:43.130 ⇒ 00:18:45.099 Demilade Agboola: Oh, okay. Sounds good.
218 00:18:46.380 ⇒ 00:18:48.230 Emily Giant: Okay, are we on to the next?
219 00:18:48.470 ⇒ 00:18:55.230 pk.arthur: Yeah, so… Regarding the sessions, like, I was talking about, also.
220 00:18:56.150 ⇒ 00:19:00.670 pk.arthur: What do you guys think about all this? Because I’m honestly not sure, because he says…
221 00:19:01.300 ⇒ 00:19:08.049 pk.arthur: There are different ways, but, like, we’ve tried to get… to pull visitor information out, and that just never lined up, so…
222 00:19:08.340 ⇒ 00:19:11.240 pk.arthur: What do you guys think about that? What do you guys recommend?
223 00:19:11.810 ⇒ 00:19:14.389 Emily Giant: Do you think it’s a, like, a refresh thing?
224 00:19:16.580 ⇒ 00:19:17.130 pk.arthur: Oops.
225 00:19:17.880 ⇒ 00:19:19.719 Emily Giant: Like, how far off are they?
226 00:19:20.320 ⇒ 00:19:28.060 pk.arthur: So… on… the 10th of October, there were 12,000 sessions.
227 00:19:29.650 ⇒ 00:19:34.330 pk.arthur: Let’s see… I’ll have to go to visit Sable one time, huh?
228 00:19:35.030 ⇒ 00:19:35.810 Emily Giant: Yeah.
229 00:19:35.810 ⇒ 00:19:36.750 pk.arthur: Give me a second.
230 00:19:59.220 ⇒ 00:20:03.510 pk.arthur: another visit ID and write it as a…
231 00:20:19.040 ⇒ 00:20:25.059 Emily Giant: Oh, I’m so sorry, I can join this to the other table, so that you don’t have to pop back and forth.
232 00:20:25.720 ⇒ 00:20:28.800 pk.arthur: No, it’s… yeah, it’s… that would be great too, but…
233 00:20:28.800 ⇒ 00:20:30.850 Emily Giant: I’ll do that today. It’s really easy.
234 00:20:31.280 ⇒ 00:20:38.290 Emily Giant: Or you can do it, if you want to try doing it. We can do it together at some point, so you know how to join stuff in Looker, but anyway.
235 00:20:38.580 ⇒ 00:20:41.589 Emily Giant: Okay, let me go over the calendars real quick.
236 00:20:57.100 ⇒ 00:20:57.939 pk.arthur: Oh my god.
237 00:21:14.140 ⇒ 00:21:19.079 pk.arthur: So, 997 visits or sessions on the 10th, right?
238 00:21:19.320 ⇒ 00:21:24.540 pk.arthur: And this is… 12, 6… 12,000, basically.
239 00:21:27.580 ⇒ 00:21:30.070 Emily Giant: Can you go back to the… yeah.
240 00:21:30.070 ⇒ 00:21:33.270 Demilade Agboola: Well, that’s… but that’s… I believe this is individual…
241 00:21:33.270 ⇒ 00:21:34.740 pk.arthur: Be, like, unique.
242 00:21:35.320 ⇒ 00:21:36.800 Emily Giant: Users.
243 00:21:37.330 ⇒ 00:21:41.609 Demilade Agboola: Yeah. Yeah, so it’s not counting if the same person comes back a bunch of times.
244 00:21:42.180 ⇒ 00:21:44.250 Demilade Agboola: But I think that’s still a huge disparity, though.
245 00:21:45.370 ⇒ 00:21:50.310 Emily Giant: But the 12,000 versus 997’s really different. Yeah.
246 00:21:51.480 ⇒ 00:21:56.690 Emily Giant: What about GA4, though? Like… What does that table say?
247 00:21:58.720 ⇒ 00:22:01.889 Demilade Agboola: Do you, Pick, did you have access to global, GA?
248 00:22:02.250 ⇒ 00:22:04.850 pk.arthur: Like, yeah, that’s actually open right now.
249 00:22:06.720 ⇒ 00:22:09.359 pk.arthur: Give me a second, I’m gonna refresh this…
250 00:22:26.770 ⇒ 00:22:32.290 pk.arthur: So it’s an 11,000 sessions, so… Shopify slightly has more.
251 00:22:33.840 ⇒ 00:22:45.110 Emily Giant: Shopify also has been suffering from bots recently, and I wonder if GA4 is, like, normalizing any of that, because we were getting, like, a crazy amount of European traffic that was all bots.
252 00:22:47.350 ⇒ 00:22:53.060 pk.arthur: Yeah, actually, you’re right, that was on a specific, like, I think a few days last week, the early…
253 00:22:53.060 ⇒ 00:22:53.580 Emily Giant: Yeah.
254 00:22:53.580 ⇒ 00:22:54.529 pk.arthur: During the week.
255 00:22:55.250 ⇒ 00:23:03.200 Demilade Agboola: Yeah, so I think what… Because I’m just reading around, and even let me share a link right now.
256 00:23:05.830 ⇒ 00:23:11.279 Demilade Agboola: But even, like, Shopify staff, Well, like, they seem to advise using…
257 00:23:11.460 ⇒ 00:23:16.320 Demilade Agboola: GA4 for the sessions data for a bit more flexibility.
258 00:23:16.320 ⇒ 00:23:20.990 pk.arthur: If you send that to me, I can send that to Chris, just to relay that as well.
259 00:23:20.990 ⇒ 00:23:24.540 Demilade Agboola: Yeah, so I’m saying it’s in the chat right now, so you can open up the link.
260 00:23:24.540 ⇒ 00:23:27.580 pk.arthur: Chat, chat.
261 00:23:39.460 ⇒ 00:23:41.230 pk.arthur: Where did my Zoom go?
262 00:23:42.250 ⇒ 00:23:43.229 Demilade Agboola: It zoomed off.
263 00:23:43.230 ⇒ 00:23:46.729 pk.arthur: Yeah, you might have to…
264 00:23:48.250 ⇒ 00:23:52.369 Demilade Agboola: No, but can you see the, like, floating, like, thumbnail thingy?
265 00:23:52.370 ⇒ 00:23:54.399 pk.arthur: Yeah, oh, there it is, thank you.
266 00:23:54.950 ⇒ 00:23:56.920 Emily Giant: Loading thumbnail.
267 00:23:56.920 ⇒ 00:23:59.729 pk.arthur: Like, it says, like, your screen at the bottom of the screen.
268 00:23:59.730 ⇒ 00:24:02.910 Emily Giant: Oh, I was like, that sounds… sick.
269 00:24:06.610 ⇒ 00:24:08.530 Demilade Agboola: But.
270 00:24:11.890 ⇒ 00:24:16.620 pk.arthur: Oh, yeah, thank you, like, honestly, this is… it’s from a Shopify person.
271 00:24:16.990 ⇒ 00:24:20.999 Demilade Agboola: Yeah, so this is in their, like, dev community.
272 00:24:21.000 ⇒ 00:24:21.790 pk.arthur: Good.
273 00:24:23.030 ⇒ 00:24:28.519 pk.arthur: Okay, yeah, this would… I think this would be helpful, just to show them that, what you were saying.
274 00:24:29.140 ⇒ 00:24:30.690 Demilade Agboola: Yeah, so…
275 00:24:30.690 ⇒ 00:24:32.550 pk.arthur: Yeah, I appreciate that, thank you so much.
276 00:24:33.340 ⇒ 00:24:35.679 Emily Giant: So, I guess our next step is…
277 00:24:35.810 ⇒ 00:24:43.870 Emily Giant: like, can we immediately connect GA4 to the Shopify data for PK? And if so, how?
278 00:24:45.570 ⇒ 00:24:47.750 Demilade Agboola: Well, we’ll need to ingest the first.
279 00:24:48.140 ⇒ 00:24:53.570 Demilade Agboola: I think that task is assigned to OH, because, like, my focus right now is on revenue.
280 00:24:53.570 ⇒ 00:24:54.320 Emily Giant: Yeah.
281 00:24:54.490 ⇒ 00:24:56.139 Demilade Agboola: up to scratch.
282 00:24:56.370 ⇒ 00:25:04.990 Demilade Agboola: Hopefully, Yeah, but I’m not necessarily sure, so I’m trying to look at OASIS tasks…
283 00:25:06.080 ⇒ 00:25:13.730 Emily Giant: We’re ingesting GA4 data, for sure, and it has the Shopify number that comes in, so, I mean, I can do this if Oasis, like.
284 00:25:14.700 ⇒ 00:25:17.129 Emily Giant: Not, available.
285 00:25:17.410 ⇒ 00:25:20.860 Emily Giant: Like, when you go to, do you want me to share my screen?
286 00:25:21.400 ⇒ 00:25:22.330 Demilade Agboola: Yeah, sure.
287 00:25:22.480 ⇒ 00:25:30.800 Emily Giant: Okay. I know this isn’t your task, so it’s like, no, I don’t want you to, because this isn’t for me, but, just so you have context.
288 00:25:31.160 ⇒ 00:25:34.570 Emily Giant: If I go to DBT…
289 00:25:43.580 ⇒ 00:25:45.160 Emily Giant: GA4.
290 00:25:46.680 ⇒ 00:25:48.190 Emily Giant: Maybe it’s this one.
291 00:25:48.910 ⇒ 00:25:53.730 Emily Giant: So this is where I had to, like, put that,
292 00:25:55.160 ⇒ 00:26:00.009 Emily Giant: I think it’s this one, PK, do you remember? Yeah, it’s this one.
293 00:26:05.340 ⇒ 00:26:08.219 Emily Giant: It looks like, for some reason, this was, like, set back.
294 00:26:08.390 ⇒ 00:26:12.510 Emily Giant: From what… oh, it’s this, sorry. I was like, it’s like they changed my,
295 00:26:14.030 ⇒ 00:26:20.169 Emily Giant: because I had to adjust the order number after the migration, but pre,
296 00:26:23.480 ⇒ 00:26:27.810 Emily Giant: This has the Shopify order number in it, like… Straight out the gate.
297 00:26:27.970 ⇒ 00:26:32.769 Emily Giant: this, the transaction ID and order number.
298 00:26:33.220 ⇒ 00:26:36.220 Emily Giant: For… this is, like, obviously very old data.
299 00:26:36.970 ⇒ 00:26:41.049 Emily Giant: but it will connect. So, I don’t know if there’s any…
300 00:26:42.350 ⇒ 00:26:44.989 Emily Giant: Harm in me just copying over this model.
301 00:26:45.290 ⇒ 00:26:49.849 Emily Giant: time gating it, or I don’t even need to time gate it, because then it will transition.
302 00:26:51.760 ⇒ 00:26:54.270 Emily Giant: From Legacy to Shopify.
303 00:26:54.630 ⇒ 00:26:56.099 Emily Giant: Here, I’ll show you in mode.
304 00:26:56.100 ⇒ 00:26:58.409 Demilade Agboola: Isn’t this, like, the campaign, though?
305 00:26:58.810 ⇒ 00:27:00.469 Demilade Agboola: I’m gonna show you the sessions.
306 00:27:03.430 ⇒ 00:27:05.340 Emily Giant: Oh, yeah, yeah, yeah, yeah, I hear ya.
307 00:27:05.490 ⇒ 00:27:11.680 Emily Giant: Source, okay, so we need the GA4 sessions data.
308 00:27:12.150 ⇒ 00:27:14.130 Demilade Agboola: Yeah. Ideally.
309 00:27:15.790 ⇒ 00:27:22.879 Demilade Agboola: I don’t think we have it, because I know… I know I was looking… I was looking around when we were talking about this in, like, was it Hivo or Stitch? Yeah.
310 00:27:23.080 ⇒ 00:27:27.280 Emily Giant: We hadn’t selected, like, sessions to be ingested.
311 00:27:28.330 ⇒ 00:27:30.599 Demilade Agboola: Which is kind of what I was just like.
312 00:27:34.430 ⇒ 00:27:40.760 Emily Giant: Ugh, sorry, it’s not letting me into Stitch. Okay, I remember what you’re talking about, though, but didn’t we, like, turn on the table?
313 00:27:42.150 ⇒ 00:27:43.530 Emily Giant: When we were…
314 00:27:43.970 ⇒ 00:27:47.530 Emily Giant: Well, I guess we’ll never know, because I’m going to get myself locked out of this account.
315 00:27:48.910 ⇒ 00:27:54.629 Emily Giant: Hold on… Why does it want this from me?
316 00:27:56.250 ⇒ 00:28:02.140 Demilade Agboola: You know one of the best things ever? Password managers. I think password managers have saved lives in ways they don’t.
317 00:28:03.210 ⇒ 00:28:09.660 Emily Giant: I, yeah, I need to get one of those, because this is… bonkers. Alright.
318 00:28:10.000 ⇒ 00:28:16.929 Demilade Agboola: I actually have my personal one. I use NodPass, but I mean, there are a bunch of stuff out there.
319 00:28:17.330 ⇒ 00:28:19.200 Demilade Agboola: It literally saves my life.
320 00:28:20.170 ⇒ 00:28:25.769 pk.arthur: I have a feeling that if anything ever happens to, like, a password manager website.
321 00:28:25.880 ⇒ 00:28:30.290 pk.arthur: I will never, ever remember my password to anyone ever again.
322 00:28:30.290 ⇒ 00:28:41.279 Demilade Agboola: I’m serious, like, it’s that bad. I don’t remember anything. Like, you know, in the initial, like, infancy of the internet, it was kind of, like, very simple passwords.
323 00:28:41.280 ⇒ 00:28:42.010 Emily Giant: Yeah.
324 00:28:42.010 ⇒ 00:28:42.610 Demilade Agboola: It was like…
325 00:28:42.610 ⇒ 00:28:43.940 pk.arthur: dog name.
326 00:28:43.940 ⇒ 00:28:51.440 Demilade Agboola: And then maybe you add, like, an exclamation mark at the end and a number or something. Yeah, exactly. Nowadays.
327 00:28:51.870 ⇒ 00:28:58.209 Demilade Agboola: Passwords are just ridiculous. So, and yeah, I’m not putting that to my mind.
328 00:28:58.780 ⇒ 00:29:09.869 Emily Giant: Have you seen Jim Gaffigan’s comedy at all? He has a whole thing about passwords, like, about computers telling him he’s, like, too dumb to make his own passwords. It’s great.
329 00:29:10.120 ⇒ 00:29:17.540 Emily Giant: Okay, well, I’ll check on that, but I’m pretty sure when we met last time, that…
330 00:29:17.860 ⇒ 00:29:24.600 Emily Giant: we, turned on the sessions. Like, checked the box to ingest them.
331 00:29:25.260 ⇒ 00:29:27.579 Emily Giant: I guess I could look.
332 00:29:27.960 ⇒ 00:29:29.549 Demilade Agboola: Yeah, I’ll take a look at that.
333 00:29:31.180 ⇒ 00:29:34.020 Emily Giant: Here. I forgot that I could look, like, here, too.
334 00:29:36.450 ⇒ 00:29:45.959 Emily Giant: Order ads, order web, order demographics, order geoweb behavior… Session. Traffic acquisition. That’s new.
335 00:29:46.660 ⇒ 00:29:50.640 Emily Giant: Sorry.
336 00:29:56.360 ⇒ 00:29:57.760 Emily Giant: Yeah, yeah.
337 00:29:57.980 ⇒ 00:29:58.940 pk.arthur: Okay.
338 00:30:00.800 ⇒ 00:30:01.670 Emily Giant: Ken.
339 00:30:05.830 ⇒ 00:30:08.840 Demilade Agboola: Yeah, so, like, let me quickly share my screen.
340 00:30:13.160 ⇒ 00:30:16.620 Demilade Agboola: I mean, you’re sharing a screen share, I’m about to replace it.
341 00:30:16.620 ⇒ 00:30:17.929 Emily Giant: Oh, okay, go for it.
342 00:30:21.990 ⇒ 00:30:23.729 Demilade Agboola: Yeah, so this is basically…
343 00:30:23.940 ⇒ 00:30:31.270 Demilade Agboola: what we had to kind of look into. So, like, I was going to, like… I would kind of have to need to know what…
344 00:30:32.060 ⇒ 00:30:39.019 Demilade Agboola: each table represents, and kind of, like, decide which has the level of detail we need.
345 00:30:40.010 ⇒ 00:30:44.450 Demilade Agboola: And then use that table.
346 00:30:45.130 ⇒ 00:30:48.679 Demilade Agboola: Or how many of these tables we need to be able to put together.
347 00:30:49.160 ⇒ 00:30:54.209 Demilade Agboola: And then, use that to type back to, like.
348 00:30:54.700 ⇒ 00:30:59.240 Demilade Agboola: conversion, and see what’s happening from sessions all the way till…
349 00:30:59.910 ⇒ 00:31:06.119 Demilade Agboola: I at least have an idea of what’s happening all the way from sessions to… What’s that?
350 00:31:06.120 ⇒ 00:31:06.699 Emily Giant: You know…
351 00:31:06.860 ⇒ 00:31:07.680 Demilade Agboola: conversion.
352 00:31:08.090 ⇒ 00:31:11.689 Emily Giant: Yeah. So, weirdly, I think Chris is the owner of this account.
353 00:31:12.210 ⇒ 00:31:17.900 Emily Giant: So he might be able to create, a user for you, PK?
354 00:31:18.660 ⇒ 00:31:21.400 Emily Giant: And that way, you can go in and look at all these tables.
355 00:31:21.810 ⇒ 00:31:22.810 pk.arthur: Oh, Stitch?
356 00:31:22.810 ⇒ 00:31:26.009 Emily Giant: Yeah. I don’t know why, but I think he is.
357 00:31:26.310 ⇒ 00:31:29.400 Demilade Agboola: I mean, to be fair, I could always just… I could always do it. It’s just, like.
358 00:31:29.400 ⇒ 00:31:30.170 Emily Giant: Oh, yeah.
359 00:31:30.990 ⇒ 00:31:32.490 Demilade Agboola: need to…
360 00:31:32.960 ⇒ 00:31:41.929 Demilade Agboola: sit down and come up with that, but as I said, in terms of priority, like, my focus is really on the revenue right now.
361 00:31:43.510 ⇒ 00:31:47.899 Emily Giant: We could move on to this, though, Demolade. Like, I’m gonna be done with subscriptions really soon.
362 00:31:48.060 ⇒ 00:31:50.369 Emily Giant: I’m just doing, like, the last tweaks.
363 00:31:51.920 ⇒ 00:31:56.039 Emily Giant: So, PK and I can… In a waysh.
364 00:31:56.190 ⇒ 00:32:00.769 Emily Giant: Can meet, and… Work through some of this.
365 00:32:01.240 ⇒ 00:32:01.920 pk.arthur: Yeah.
366 00:32:04.540 ⇒ 00:32:12.020 Demilade Agboola: And also, just so I just remembered, I’ve been able to flatten the model and get it on a 1-hour schedule.
367 00:32:12.020 ⇒ 00:32:21.130 Emily Giant: Oh, yeah, I saw that. Can we look at it? I know it’s only, like, one day’s worth, or a couple hours’ worth, but, PK, you’re talking about inventory snapshots.
368 00:32:21.350 ⇒ 00:32:23.659 pk.arthur: Okay, okay, perfect, let’s see it.
369 00:32:24.410 ⇒ 00:32:25.080 Demilade Agboola: So…
370 00:32:28.100 ⇒ 00:32:31.920 Demilade Agboola: Basically, can you send an inventory number that we can look at?
371 00:32:31.920 ⇒ 00:32:33.170 Emily Giant: Yeah, I can.
372 00:32:33.170 ⇒ 00:32:40.640 Demilade Agboola: You should have access to it in Looker. It’s still the same table name and everything, I just changed certain things.
373 00:32:57.710 ⇒ 00:32:59.650 Demilade Agboola: Peggy, do you want to look at this in the looker?
374 00:32:59.650 ⇒ 00:33:03.499 pk.arthur: Yeah, it’s quickly loading. I can share my screen, but it’s…
375 00:33:03.940 ⇒ 00:33:06.409 Emily Giant: I’m looking to. It’s a race.
376 00:33:06.610 ⇒ 00:33:08.010 pk.arthur: I got you.
377 00:33:08.010 ⇒ 00:33:09.739 Emily Giant: Haha, you win, okay.
378 00:33:09.740 ⇒ 00:33:15.530 pk.arthur: Okay, so… Let’s run this… Whoa.
379 00:33:27.620 ⇒ 00:33:30.649 pk.arthur: So today, today’s the 14th.
380 00:33:32.140 ⇒ 00:33:35.050 pk.arthur: So this should have some results, right?
381 00:33:35.460 ⇒ 00:33:36.020 Emily Giant: Yeah.
382 00:33:36.660 ⇒ 00:33:38.620 Demilade Agboola: Yes, today’s 15th, actually.
383 00:33:38.620 ⇒ 00:33:42.710 pk.arthur: Yeah, but this, basically, like, in the range of the 14th.
384 00:33:44.190 ⇒ 00:33:46.480 Demilade Agboola: Let’s see… what’s the…
385 00:33:46.480 ⇒ 00:33:49.080 Emily Giant: But the, yeah, there should be some.
386 00:33:49.250 ⇒ 00:33:50.590 Demilade Agboola: Yeah, there definitely should be something.
387 00:33:50.590 ⇒ 00:33:52.649 Emily Giant: Can you change it to the 16th?
388 00:33:53.440 ⇒ 00:33:56.829 Emily Giant: Or the… I’m trying to think of when things actually expire.
389 00:33:56.970 ⇒ 00:34:01.699 Emily Giant: And it’s usually at the end of a week, so this might actually, like, weirdly cut off.
390 00:34:01.900 ⇒ 00:34:04.000 pk.arthur: Let’s see… 18th…
391 00:34:04.680 ⇒ 00:34:05.930 Demilade Agboola: Let me see…
392 00:34:11.500 ⇒ 00:34:14.699 Demilade Agboola: Okay, so what’s going on here?
393 00:34:15.409 ⇒ 00:34:17.560 Demilade Agboola: So we have one the 14th…
394 00:34:20.489 ⇒ 00:34:21.539 Emily Giant: Oh, is that accurate?
395 00:34:21.540 ⇒ 00:34:26.199 Demilade Agboola: There’s a filter between… yeah, it’s act… yeah, there’s a filter between…
396 00:34:27.440 ⇒ 00:34:30.480 Demilade Agboola: 8 a.m. and 1PM, so that’s…
397 00:34:32.889 ⇒ 00:34:35.429 pk.arthur: Unless maybe we’re out of it, or…
398 00:34:44.590 ⇒ 00:34:46.680 Emily Giant: I need to do some kind of join.
399 00:34:46.960 ⇒ 00:34:56.479 Emily Giant: so that it doesn’t show all the expired lots, because that’s not user-friendly, to have to filter with both of those. It doesn’t make sense.
400 00:34:57.360 ⇒ 00:35:00.860 Demilade Agboola: Oh, no, no, I’ve removed the expired lot.
401 00:35:01.550 ⇒ 00:35:03.519 Emily Giant: Oh, oh, oh, okay, nevermind.
402 00:35:03.670 ⇒ 00:35:04.810 Demilade Agboola: Pretty sure. Several.
403 00:35:05.540 ⇒ 00:35:08.039 Demilade Agboola: So, are you… are you out?
404 00:35:08.160 ⇒ 00:35:10.600 Demilade Agboola: firecrackers in Baltimore.
405 00:35:10.600 ⇒ 00:35:11.450 pk.arthur: Amazing.
406 00:35:11.690 ⇒ 00:35:13.999 Emily Giant: I was like, these might be gone.
407 00:35:14.650 ⇒ 00:35:16.600 pk.arthur: Huh.
408 00:35:17.230 ⇒ 00:35:20.059 Emily Giant: Just run it for both. Well, no, do whatever you’re gonna do.
409 00:35:20.340 ⇒ 00:35:24.250 pk.arthur: Because it was… because that might just be a lot of different products, right?
410 00:35:24.610 ⇒ 00:35:25.230 Emily Giant: Yeah.
411 00:35:25.870 ⇒ 00:35:28.700 Emily Giant: I’ll give you one that’s live, I’ll pull one from Dash.
412 00:35:28.740 ⇒ 00:35:30.119 Demilade Agboola: That would be really helpful.
413 00:35:32.940 ⇒ 00:35:37.129 Emily Giant: You might have to change it to, like… oh, never mind, because you can just use the product name.
414 00:35:40.220 ⇒ 00:35:46.229 pk.arthur: that’s what I did last time, just went to the website to see what was available.
415 00:35:46.640 ⇒ 00:35:50.110 Emily Giant: There’s 33 available firecrackers, and… Right.
416 00:35:50.230 ⇒ 00:35:51.090 Emily Giant: Yeah.
417 00:35:51.710 ⇒ 00:35:52.730 Demilade Agboola: In Baltimore?
418 00:35:52.730 ⇒ 00:35:53.490 Emily Giant: Huh.
419 00:35:53.930 ⇒ 00:35:54.860 Demilade Agboola: Interesting.
420 00:35:56.470 ⇒ 00:35:58.220 Emily Giant: Here, try the unicorn.
421 00:35:59.350 ⇒ 00:36:00.790 Demilade Agboola: Let me try…
422 00:36:09.950 ⇒ 00:36:15.380 pk.arthur: Yeah, that also has zero. I don’t know, maybe? I’m… I don’t know if it has, like, one of the filters.
423 00:36:15.380 ⇒ 00:36:18.360 Emily Giant: inventory lot, it’s filled for sale.
424 00:36:20.170 ⇒ 00:36:25.290 Emily Giant: Try on hand. Can you add the… on-hand measure.
425 00:36:25.830 ⇒ 00:36:27.780 Emily Giant: I just want to see if that also says 0.
426 00:36:29.370 ⇒ 00:36:31.380 pk.arthur: One single hand, okay.
427 00:36:34.190 ⇒ 00:36:39.340 Demilade Agboola: Hmm… Let’s see…
428 00:36:41.240 ⇒ 00:36:46.369 Emily Giant: Let me see when their expiration dates are. That could… oh, the expiration dates are on the 21st, guys.
429 00:36:46.590 ⇒ 00:36:47.520 Emily Giant: That’s why.
430 00:36:48.090 ⇒ 00:36:51.439 pk.arthur: Oh, So that also, I guess that…
431 00:36:52.010 ⇒ 00:36:56.790 Emily Giant: Do the 22nd, though, and Looker, you always want to go one day ahead, because it’s janky.
432 00:37:00.390 ⇒ 00:37:08.499 Demilade Agboola: Yeah, but… It shouldn’t… Okay, so it has on hand, but the available facility is zero.
433 00:37:09.360 ⇒ 00:37:09.770 Demilade Agboola: Oh.
434 00:37:12.690 ⇒ 00:37:18.269 Emily Giant: That doesn’t even… Makes sense. I mean, it does, but there should be…
435 00:37:18.470 ⇒ 00:37:21.470 Emily Giant: 58 on hand, 40 available for sale.
436 00:37:22.290 ⇒ 00:37:24.480 Emily Giant: Start date is the 12th.
437 00:37:28.250 ⇒ 00:37:28.610 Demilade Agboola: Excellent.
438 00:37:28.610 ⇒ 00:37:29.990 Emily Giant: the 21st.
439 00:37:30.190 ⇒ 00:37:34.309 Demilade Agboola: Let me see, can you… we’re looking at the unicorn…
440 00:37:35.400 ⇒ 00:37:38.049 Emily Giant: Oh, y’all, no, that’s totally correct.
441 00:37:38.440 ⇒ 00:37:42.069 Emily Giant: The 2 and the 0. There’s 2 on hand, and 0 available.
442 00:37:42.390 ⇒ 00:37:45.879 Emily Giant: For one of the lots, but there’s another lot with 40.
443 00:37:47.250 ⇒ 00:37:51.760 Demilade Agboola: Yeah, but are we… are we grouping by… aren’t we trying to summit?
444 00:37:52.230 ⇒ 00:37:52.800 Emily Giant: Yeah.
445 00:37:52.800 ⇒ 00:37:56.120 Demilade Agboola: Or is it just shown… Couldn’t,
446 00:37:57.660 ⇒ 00:38:00.959 Demilade Agboola: Like, what’s happening on the local end of things? That’s what I’m trying to understand.
447 00:38:00.960 ⇒ 00:38:01.840 Emily Giant: Yeah.
448 00:38:01.960 ⇒ 00:38:07.310 Emily Giant: Let me see what’s happening… Okay.
449 00:38:08.870 ⇒ 00:38:10.400 Emily Giant: This one…
450 00:38:11.600 ⇒ 00:38:16.250 Demilade Agboola: Also, can we use SKUs? Just because, for me, it’s easier to, like, debug.
451 00:38:16.790 ⇒ 00:38:17.110 pk.arthur: Here’s.
452 00:38:17.110 ⇒ 00:38:22.059 Emily Giant: PK, can you change the expiration to the 24th and see if it grabs the other one?
453 00:38:22.060 ⇒ 00:38:22.980 pk.arthur: Okay.
454 00:38:22.980 ⇒ 00:38:25.060 Emily Giant: I think it might, actually.
455 00:38:26.700 ⇒ 00:38:34.130 Demilade Agboola: Because, like, I’m trying to see things on the back end, like, and just want to be sure that typing in the unicorn can be tricky.
456 00:38:34.130 ⇒ 00:38:34.890 Emily Giant: Yeah.
457 00:38:35.660 ⇒ 00:38:36.590 pk.arthur: of…
458 00:38:36.990 ⇒ 00:38:38.269 Emily Giant: I don’t know what you’re saying.
459 00:38:40.640 ⇒ 00:38:42.140 Emily Giant: Oh, that’s correct.
460 00:38:42.140 ⇒ 00:38:43.959 pk.arthur: So that added it to it.
461 00:38:43.960 ⇒ 00:38:44.570 Emily Giant: Hmm.
462 00:38:44.830 ⇒ 00:38:48.479 Emily Giant: Do you, by any chance, know the SKU name? I do, I’m sending it in the chat right now.
463 00:38:48.480 ⇒ 00:38:49.100 pk.arthur: Okay.
464 00:38:51.240 ⇒ 00:38:57.090 Demilade Agboola: Alright, so for this… So, wait, what did we change to make it, like, populate?
465 00:38:57.280 ⇒ 00:39:02.110 Emily Giant: The… there were two lots, and one of the expiration dates was actually on the 23rd.
466 00:39:03.340 ⇒ 00:39:03.939 Demilade Agboola: Oh, so yeah.
467 00:39:03.940 ⇒ 00:39:07.990 Emily Giant: When I opened… yeah, when I opened it to the individual lots, it…
468 00:39:08.190 ⇒ 00:39:12.940 Demilade Agboola: So can you… can you remove that filter? Because, like, I actually have…
469 00:39:13.630 ⇒ 00:39:21.289 Demilade Agboola: Ensure that once it expires, it stops adding a new row for that, like, lot.
470 00:39:22.240 ⇒ 00:39:26.119 Demilade Agboola: So, it basically… so, for instance, if it expires on the 22nd.
471 00:39:26.130 ⇒ 00:39:26.620 pk.arthur: Hmm.
472 00:39:26.620 ⇒ 00:39:30.780 Demilade Agboola: at, the last… rural.
473 00:39:31.470 ⇒ 00:39:34.280 Demilade Agboola: That it flattens out to, will be…
474 00:39:35.070 ⇒ 00:39:37.449 Demilade Agboola: The… what’s the… what’s it called?
475 00:39:37.550 ⇒ 00:39:44.590 Demilade Agboola: the midnight of the following day. So after that, it doesn’t… there won’t be any new rules added for an expired lot.
476 00:39:46.200 ⇒ 00:39:53.239 Demilade Agboola: So, like, it doesn’t keep track of, like, it doesn’t show you what’s happening after that, so you don’t need that filter, basically.
477 00:39:53.460 ⇒ 00:39:54.060 pk.arthur: Bye.
478 00:40:06.040 ⇒ 00:40:09.560 Demilade Agboola: And if it turns out that you do need a few times, I need to look at things again.
479 00:40:09.910 ⇒ 00:40:12.660 Demilade Agboola: So, we need to… if it’s…
480 00:40:14.260 ⇒ 00:40:18.289 Demilade Agboola: Sorry, so we have 468 available for sale.
481 00:40:19.930 ⇒ 00:40:24.330 Demilade Agboola: Can we look at it across?
482 00:40:26.290 ⇒ 00:40:31.980 Demilade Agboola: The… okay, so can we… so since we have, like, large numbers, can we take a small chunk?
483 00:40:32.170 ⇒ 00:40:34.010 Demilade Agboola: And then look at her across different, like.
484 00:40:35.660 ⇒ 00:40:37.490 Demilade Agboola: How do we want to look at the FCs?
485 00:40:38.730 ⇒ 00:40:44.329 Demilade Agboola: Or do we want to look at it across, what’s it called, inventory numbers, like, is it spread, or do we need to…
486 00:40:45.750 ⇒ 00:40:46.910 Demilade Agboola: Give me one second.
487 00:40:47.540 ⇒ 00:40:48.779 Demilade Agboola: Let’s see…
488 00:40:55.580 ⇒ 00:41:03.280 Demilade Agboola: FLR… Hmm, F and B… 10107.
489 00:41:27.250 ⇒ 00:41:31.930 Demilade Agboola: Alright, can you… can we just scroll down? I just want to see how the numbers change over time, like, the…
490 00:41:34.700 ⇒ 00:41:37.609 pk.arthur: So… simulator doesn’t change.
491 00:41:38.060 ⇒ 00:41:42.320 pk.arthur: From, what is this? 6 to 7?
492 00:41:43.230 ⇒ 00:41:44.210 Demilade Agboola: Yeah.
493 00:41:44.340 ⇒ 00:41:50.380 pk.arthur: I can provide a… Hopefully it doesn’t go to 5,000.
494 00:41:52.410 ⇒ 00:41:53.569 pk.arthur: Let’s see…
495 00:41:58.130 ⇒ 00:41:59.000 pk.arthur: I’ll see.
496 00:41:59.610 ⇒ 00:42:06.510 pk.arthur: I think that’s… This is between the 12th and the 15th.
497 00:42:07.070 ⇒ 00:42:13.150 pk.arthur: So yeah, it didn’t really change. It changed… it didn’t really change that much. 468 to 464.
498 00:42:13.460 ⇒ 00:42:16.700 pk.arthur: At 3 p.m, 4 p.m.
499 00:42:19.150 ⇒ 00:42:21.300 pk.arthur: There’s the available for sale only…
500 00:42:21.700 ⇒ 00:42:26.370 pk.arthur: consider Baltimore FC, or that’s, like… Everywhere.
501 00:42:27.530 ⇒ 00:42:31.720 Demilade Agboola: So if the fulfillment center is filtered to Baltimore, obviously, it should…
502 00:42:31.720 ⇒ 00:42:32.390 Emily Giant: P.M.
503 00:42:33.870 ⇒ 00:42:37.689 pk.arthur: So what’s the difference between the quantity on hand and available for sale? Like, what’s the…
504 00:42:37.940 ⇒ 00:42:39.770 pk.arthur: Difference between these two metrics.
505 00:42:42.050 ⇒ 00:42:49.630 Demilade Agboola: I’m trying to remember. Emily’s probably the best to ask, because I worked on this, like.
506 00:42:50.310 ⇒ 00:42:59.820 Demilade Agboola: a while ago, I have to start digging into the formulas, but if I remember, available for sale is a function of, like, different things, quantity on order, quantity…
507 00:43:00.810 ⇒ 00:43:04.859 Demilade Agboola: On hand, and trying to remember all these things. Give me one sec.
508 00:43:04.860 ⇒ 00:43:06.950 Emily Giant: That’s what it is, and Buffer.
509 00:43:07.170 ⇒ 00:43:08.350 Demilade Agboola: RAM buffer.
510 00:43:09.270 ⇒ 00:43:12.120 Demilade Agboola: I’m trying to see… alright.
511 00:43:14.850 ⇒ 00:43:15.760 pk.arthur: So does…
512 00:43:20.190 ⇒ 00:43:29.339 pk.arthur: Quantity on hand being available, like, right now, and this would change, basically? Yeah. So this, like, over time, looks like, right? So if someone made a sale.
513 00:43:30.500 ⇒ 00:43:32.200 pk.arthur: Or someone, like, bought it.
514 00:43:35.310 ⇒ 00:43:36.190 Demilade Agboola: Excuse me.
515 00:43:37.050 ⇒ 00:43:42.260 Demilade Agboola: So I’m trying to look at the snapshots itself, so we can actually get an idea of, like.
516 00:43:43.070 ⇒ 00:43:45.270 Demilade Agboola: What’s going on? So what’s the time frame we’re looking at again?
517 00:43:45.670 ⇒ 00:43:50.879 pk.arthur: I’m looking at… On the 12th of October.
518 00:43:51.930 ⇒ 00:43:52.780 Demilade Agboola: Okay…
519 00:43:52.960 ⇒ 00:43:55.840 pk.arthur: So… Till the 16th.
520 00:45:29.010 ⇒ 00:45:30.879 Emily Giant: Sorry, what are we doing?
521 00:45:31.900 ⇒ 00:45:35.430 Demilade Agboola: Trying to validate these numbers.
522 00:45:37.490 ⇒ 00:45:38.290 Emily Giant: Gotcha.
523 00:46:20.960 ⇒ 00:46:31.020 Emily Giant: Ek, can you do me a favor and add either inventory number ID or NetSuite lot ID to this query? Just so I can, like, see what the NetSuite…
524 00:46:31.490 ⇒ 00:46:33.670 Emily Giant: Starting numbers were…
525 00:47:33.760 ⇒ 00:47:34.670 pk.arthur: You see it, Emily?
526 00:47:35.030 ⇒ 00:47:36.479 Emily Giant: Yep, thank you.
527 00:47:37.330 ⇒ 00:47:44.340 Emily Giant: So there’s 3 different one… 1, 2, 3, 4, 5… 6…
528 00:47:47.920 ⇒ 00:47:51.289 Emily Giant: Okay, can you do me another favor and add start date?
529 00:47:51.580 ⇒ 00:47:54.370 Emily Giant: Or expiration date, add expiration date.
530 00:48:05.220 ⇒ 00:48:06.740 Emily Giant: Perfect…
531 00:48:20.620 ⇒ 00:48:26.099 Emily Giant: Just want to see if there’s any that shouldn’t, or are unexpectedly creeping in.
532 00:48:26.330 ⇒ 00:48:28.720 Emily Giant: Yeah, there are future lots.
533 00:48:29.710 ⇒ 00:48:31.640 pk.arthur: Okay, wow, okay.
534 00:48:32.620 ⇒ 00:48:36.190 Emily Giant: So that’s where those inflated numbers are coming from, is the future lots.
535 00:48:37.360 ⇒ 00:48:44.889 Emily Giant: But, are those for sale right now? Because they are, I think. Like, for pre-sales.
536 00:48:48.290 ⇒ 00:48:49.570 Emily Giant: So, for you…
537 00:48:50.250 ⇒ 00:48:57.890 Emily Giant: For your purposes, you don’t want those, because you’re interested in on hand only. Like, physically present.
538 00:48:58.140 ⇒ 00:48:59.460 Emily Giant: Right? Like, that’s…
539 00:48:59.860 ⇒ 00:49:04.990 pk.arthur: Yeah, so the end goal, basically, is to see, like, how does… A…
540 00:49:05.240 ⇒ 00:49:11.280 pk.arthur: how does the quantity available of a specific SKU affect our conversion rate? Like… Yeah.
541 00:49:12.080 ⇒ 00:49:18.569 pk.arthur: Not… basically right now, so the future is not really as relevant, right now, to be honest.
542 00:49:19.090 ⇒ 00:49:29.099 Emily Giant: Okay, so I think that, like, what Demolade did as far as, like, expired is really good, but now there’s an element of, like.
543 00:49:29.310 ⇒ 00:49:35.650 Emily Giant: an actual necessary filter with start date. So, you want start date within the last 7 days.
544 00:49:36.080 ⇒ 00:49:40.530 Emily Giant: Because those would be the ones that are… physically there.
545 00:49:41.430 ⇒ 00:49:45.949 Demilade Agboola: So, what do you mean, start date? Because again, do you want me to ensure that
546 00:49:46.060 ⇒ 00:49:53.109 Demilade Agboola: the… because, like, you know right now, if it expires, it just stops counting. Like, just stops keeping track of
547 00:49:53.670 ⇒ 00:50:01.180 Demilade Agboola: what the lots available for sale and other metrics are. Do you want something similar for start dates, that until the start dates
548 00:50:01.530 ⇒ 00:50:03.240 Demilade Agboola: Start, quote-unquote.
549 00:50:03.390 ⇒ 00:50:08.249 Demilade Agboola: We will not keep track of the lots details.
550 00:50:08.930 ⇒ 00:50:11.209 Emily Giant: I don’t think so. I think that…
551 00:50:11.520 ⇒ 00:50:13.459 Emily Giant: The way you set it up is good.
552 00:50:13.720 ⇒ 00:50:29.259 Emily Giant: And that no one will ever want to look at those unusable lots with new snapshots, but I don’t think that’s the case for the future ones, because there are times when we sell out of everything on hand, and are relying on knowledge for, like, pre-sales.
553 00:50:29.320 ⇒ 00:50:39.789 Emily Giant: But I think for PK’s specific query, he needs to, in Looker, use the start date because of the analysis that he’s doing, which is…
554 00:50:39.970 ⇒ 00:50:43.310 Emily Giant: The conversion based upon on hand.
555 00:50:43.960 ⇒ 00:50:52.040 Emily Giant: So, I don’t think any work needs to be done in dbt on this, in my opinion. But if you think that it would be better to do it in dbt.
556 00:50:52.040 ⇒ 00:50:59.059 Demilade Agboola: I’m just… okay, so in this case, what would we do? So we’re gonna add a filter where the start date is…
557 00:51:01.080 ⇒ 00:51:02.610 pk.arthur: You said in the last 7 days?
558 00:51:05.150 ⇒ 00:51:06.959 Emily Giant: I think so, yeah.
559 00:51:07.170 ⇒ 00:51:15.680 Emily Giant: Because those would be… The launch, well, unless we extend the expiration date, then…
560 00:51:15.680 ⇒ 00:51:25.710 Demilade Agboola: Oh, we’re not using expiration date anymore, like, in the sense of, if it has expired, it will not pop up anymore. If it expired within the time frame which we’re looking at, it wouldn’t pop up anymore.
561 00:51:25.710 ⇒ 00:51:30.399 Emily Giant: Right, that’s perfect. That’s exactly… I think no one wants it to function any way but that.
562 00:51:30.550 ⇒ 00:51:35.389 Emily Giant: Unless you’re looking at, like, Past stuff, right?
563 00:51:35.590 ⇒ 00:51:36.560 Emily Giant: But…
564 00:51:38.970 ⇒ 00:51:43.319 Demilade Agboola: Yeah, but, like, basically, how it functions right now is…
565 00:51:44.660 ⇒ 00:51:47.929 Demilade Agboola: It shows the history of every lot.
566 00:51:51.330 ⇒ 00:51:52.970 Emily Giant: But it’s not snapping it.
567 00:51:53.580 ⇒ 00:51:56.999 Demilade Agboola: I mean, it’s still snapping it, but, like, I don’t flatten it out.
568 00:51:57.840 ⇒ 00:52:07.560 Demilade Agboola: So once the expiration date plus 1 has passed, there is no longer… we’re no longer keeping track of what happens by the hour, basically.
569 00:52:07.560 ⇒ 00:52:09.619 Emily Giant: Yeah, okay. Yeah.
570 00:52:10.440 ⇒ 00:52:21.560 Demilade Agboola: So, like, that’s why you don’t need an expression filter, because as long as you put our timestamp within a certain range, it would only… it would only ensure that things that have not expired
571 00:52:22.040 ⇒ 00:52:24.050 Demilade Agboola: Within that range will show up.
572 00:52:25.600 ⇒ 00:52:28.870 Emily Giant: Yeah, that’s… that’s fine, but…
573 00:52:29.380 ⇒ 00:52:35.250 Emily Giant: PK, you don’t want the lots… we might be saying the same thing, I’m not sure.
574 00:52:35.250 ⇒ 00:52:44.020 Demilade Agboola: is the start date part that I want us to be clear about. So take, for instance, row 109, where we have the unicorn.
575 00:52:44.370 ⇒ 00:52:47.450 Demilade Agboola: This, blah blah blah.
576 00:52:48.800 ⇒ 00:52:54.339 Demilade Agboola: Can we look at, like… there’s an available for sale of 48, but quantity on hand is zero.
577 00:52:56.230 ⇒ 00:52:58.569 Demilade Agboola: Is there a reason, like.
578 00:52:59.630 ⇒ 00:53:05.109 Demilade Agboola: does Piki only care about the quantity on hand? Or, like, is it possible that
579 00:53:07.590 ⇒ 00:53:12.299 Demilade Agboola: That value is only based off, like, to-be-received lots, like, the pre-sale.
580 00:53:14.840 ⇒ 00:53:17.110 pk.arthur: So what I care about, ultimately, is just…
581 00:53:17.280 ⇒ 00:53:27.740 pk.arthur: Can we sell it? Like, I don’t know the difference between available for sale and quantity on hand. All I just want to know is, like, is it… like, could it be sold right now, like, within this hour? Could it be sold…
582 00:53:28.820 ⇒ 00:53:37.479 Demilade Agboola: So basically, biggest question here is, at 6am on the 14th, those 48 available for sale, could they be sold right there, right then?
583 00:53:38.410 ⇒ 00:53:39.580 pk.arthur: Essentially, yes.
584 00:53:41.400 ⇒ 00:53:49.240 Emily Giant: But PK, you also wanted to know, and maybe this is a different question than the original, if it could be fulfilled within a two-day period, right?
585 00:53:49.240 ⇒ 00:53:56.060 pk.arthur: Yeah, that was… that was going for, like, late… later, so that’s, like, a second part, but, like, the first page… the first part is…
586 00:53:56.060 ⇒ 00:54:09.559 pk.arthur: Just to see how it affects our conversion rate, then later we’re gonna see how, if it can be fulfilled in the next 2 days, right? But obviously, someone who is living in a location
587 00:54:09.560 ⇒ 00:54:12.870 pk.arthur: that’s not close to Baltimore might have a different,
588 00:54:13.390 ⇒ 00:54:22.550 pk.arthur: It might have different implications on, like, just basically where the person lives, so we’re trying to use zip code for that, but that’s, like, that’s gonna be a later part of this analysis.
589 00:54:22.690 ⇒ 00:54:27.289 Emily Giant: Okay. In that case, then… You don’t need the start date.
590 00:54:27.520 ⇒ 00:54:39.409 Emily Giant: But I was still in my head, thinking through that original question of, like, if it’s not available within that 2-3 day delivery window. So that’s why I was harping on start date.
591 00:54:39.580 ⇒ 00:54:40.309 pk.arthur: Oh, okay.
592 00:54:40.310 ⇒ 00:54:40.900 Emily Giant: Yeah.
593 00:54:41.300 ⇒ 00:54:52.720 pk.arthur: So, yeah, so I think you’re registering about that, but that, was… that was a more complicated question, because I think that we have to use, like, where the user is, right? So, if, like.
594 00:54:52.950 ⇒ 00:55:05.859 pk.arthur: If you’re located in, like, let’s say California, would they ship you… would they ship you a lot from Baltimore? Probably not, so… that’s one thing we have to think about, in the future, a little bit more.
595 00:55:08.380 ⇒ 00:55:11.339 Demilade Agboola: Yep, okay, so to answer your question right now.
596 00:55:11.580 ⇒ 00:55:14.789 Demilade Agboola: I mean, it does appear quantity on hand is what he does need.
597 00:55:15.500 ⇒ 00:55:16.040 Demilade Agboola: dupe.
598 00:55:16.040 ⇒ 00:55:20.170 Emily Giant: It’s available for sale. Quantity on hand can be units that were already sold.
599 00:55:20.790 ⇒ 00:55:23.139 Demilade Agboola: Okay, so it’s available silver that he needs, so…
600 00:55:23.140 ⇒ 00:55:23.980 Emily Giant: Yes.
601 00:55:25.260 ⇒ 00:55:27.499 Demilade Agboola: So we’re all on the same page here. So you damage, you don’t…
602 00:55:27.500 ⇒ 00:55:30.089 pk.arthur: Available for sale, okay, I got you.
603 00:55:30.430 ⇒ 00:55:35.869 Demilade Agboola: Well, is it possible for something to be available for sale, and the start date is still in the future?
604 00:55:39.490 ⇒ 00:55:45.400 Emily Giant: Yeah, that’s… that’s why I was going with the start date thing, is that we have pre-sales.
605 00:55:45.990 ⇒ 00:55:46.930 Emily Giant: So…
606 00:55:47.050 ⇒ 00:55:56.350 Emily Giant: Quantity on hand, though, this is what’s odd, is quantity on hand should not be zero when available for sale is 48, because quantity on hand should take…
607 00:55:56.470 ⇒ 00:55:59.759 Emily Giant: Available for sale into consideration.
608 00:56:00.700 ⇒ 00:56:02.860 Emily Giant: Like, quantity on hand committed.
609 00:56:03.580 ⇒ 00:56:09.580 Emily Giant: is… Like, it’s just… If there’s 58…
610 00:56:10.940 ⇒ 00:56:15.570 Emily Giant: Available for sale. There should be 58 units there.
611 00:56:18.080 ⇒ 00:56:23.020 Emily Giant: I mean, I guess not, because those dates are in the future, and that’s why they’re zero.
612 00:56:23.930 ⇒ 00:56:25.250 Emily Giant: So, never mind.
613 00:56:27.050 ⇒ 00:56:30.240 Emily Giant: But what is this on-hand 60?
614 00:56:30.680 ⇒ 00:56:31.320 Demilade Agboola: So, I’m…
615 00:56:31.320 ⇒ 00:56:32.500 Emily Giant: a future date.
616 00:56:33.230 ⇒ 00:56:35.619 Demilade Agboola: Yeah, so what I’m just trying to, like…
617 00:56:35.730 ⇒ 00:56:42.829 Demilade Agboola: Especially when it comes to PK’s request right now, Does PK need to see…
618 00:56:43.830 ⇒ 00:56:53.559 Demilade Agboola: things that are on hand right now. Like, he’s trying to say, like, things that can be sold right here, right now, but does that mean, in terms of pre-sales, or just, like, if the customer needs it.
619 00:56:53.910 ⇒ 00:56:58.199 Demilade Agboola: today, they can get it today, sort of. That’s sort of the question.
620 00:57:00.350 ⇒ 00:57:01.340 Emily Giant: PK?
621 00:57:02.480 ⇒ 00:57:03.470 Emily Giant: What do you think?
622 00:57:04.080 ⇒ 00:57:06.499 pk.arthur: So, can I repeat that again? So, you’re asking…
623 00:57:07.690 ⇒ 00:57:14.510 Demilade Agboola: So, like, basically, I’m trying to understand, like, what numbers you need to see, and I’m trying to figure that out by asking…
624 00:57:15.980 ⇒ 00:57:17.870 Demilade Agboola: Do you need to, like, what…
625 00:57:18.100 ⇒ 00:57:30.000 Demilade Agboola: when you say something can be sold, do pre-sales count, basically? Or are you saying that, like, whatever is purchased today can start the motions right here, right now? Like, can start going…
626 00:57:30.140 ⇒ 00:57:33.850 Demilade Agboola: Can be, you know, Got in immediately.
627 00:57:35.640 ⇒ 00:57:37.840 pk.arthur: Hmm, that’s a good question. So…
628 00:57:41.060 ⇒ 00:57:46.500 pk.arthur: maybe I think I should probably explain, like, just, like, what the end goal is, right? So…
629 00:57:47.410 ⇒ 00:57:59.389 pk.arthur: basically, what the initial question Curiosity asked us about is that. So, we see that, so let’s say for the unicorn, right?
630 00:57:59.670 ⇒ 00:58:06.240 pk.arthur: let’s say I go to a website, and I’m trying to buy a unicorn.
631 00:58:06.810 ⇒ 00:58:24.699 pk.arthur: But I don’t see it available to deliver. That has an effect on our conversion rate, because I go to the website to have a session, but I don’t actually convert. So, what I want to know is that, how does the quantities available affect our conversion rates over time?
632 00:58:25.600 ⇒ 00:58:27.630 pk.arthur: What exact metric?
633 00:58:28.940 ⇒ 00:58:32.979 pk.arthur: whether it be available for sale or quantity on hand, I’m not quite sure, to be honest.
634 00:58:33.380 ⇒ 00:58:43.580 Demilade Agboola: Okay, so Emily, I think that goes back to Emily. So, when someone goes on the Urban Sam’s website, and is trying to purchase something, and it’s out of order, like, it’s unavailable.
635 00:58:43.910 ⇒ 00:58:48.180 Demilade Agboola: What number is used to determine the unavailability of it?
636 00:58:51.110 ⇒ 00:58:53.579 Emily Giant: It would be.
637 00:58:55.320 ⇒ 00:58:57.419 Demilade Agboola: And it’s funny if you don’t have the answer right now, but, like, I just want.
638 00:58:57.420 ⇒ 00:59:01.969 Emily Giant: It’s on-hand minus on-hand committed.
639 00:59:03.620 ⇒ 00:59:07.149 Demilade Agboola: So… That’s slightly different from…
640 00:59:07.430 ⇒ 00:59:12.800 Demilade Agboola: Because available for sale for, like, what we’re doing is quantity on hand plus quantity.
641 00:59:13.980 ⇒ 00:59:15.120 Demilade Agboola: on order.
642 00:59:15.130 ⇒ 00:59:15.950 Emily Giant: Yep.
643 00:59:15.950 ⇒ 00:59:22.219 Demilade Agboola: Minus the quantity pre-sale committed, minus the quantity on hand committed, minus the total care buffer.
644 00:59:22.570 ⇒ 00:59:23.340 Emily Giant: That’s normal.
645 00:59:23.340 ⇒ 00:59:26.479 Demilade Agboola: A hold buffer, so it’s an entirely different equation.
646 00:59:26.860 ⇒ 00:59:29.079 Demilade Agboola: what PK seems to care for.
647 00:59:29.520 ⇒ 00:59:30.140 Emily Giant: Yep.
648 00:59:30.390 ⇒ 00:59:33.999 Demilade Agboola: Alright. So there’s available for sale, and then I guess we should say, like.
649 00:59:34.330 ⇒ 00:59:36.120 Emily Giant: On hand for sale?
650 00:59:37.430 ⇒ 00:59:39.229 Demilade Agboola: Maybe. But, like.
651 00:59:39.230 ⇒ 00:59:41.589 Emily Giant: On the hand… yeah, we’ll figure it out, but…
652 00:59:41.970 ⇒ 01:00:00.550 Demilade Agboola: We know what PK wants, and that’s kind of what I was trying to get to the bottom of, because I don’t want… because he, like, the numbers seem too high for what he was trying to do, and it just appears that he just needs to know, hey, if the customer was on the site, and they needed to order it right here, right now, what would they see available?
653 01:00:02.870 ⇒ 01:00:10.619 Emily Giant: Yeah, okay. We know what he wants, so I don’t think it’s… we can… I feel like we can build that.
654 01:00:11.070 ⇒ 01:00:12.930 Emily Giant: No problem.
655 01:00:14.250 ⇒ 01:00:16.939 Demilade Agboola: Alright, so just text me the…
656 01:00:17.380 ⇒ 01:00:19.340 Demilade Agboola: Formula, like, what it will take off.
657 01:00:19.680 ⇒ 01:00:23.980 Demilade Agboola: like, what the… I think you said it’s on-hand minus on-hand committed, I’m not sure.
658 01:00:23.980 ⇒ 01:00:24.680 Emily Giant: Yes.
659 01:00:24.700 ⇒ 01:00:26.790 pk.arthur: Yep, I’ll slack it to you.
660 01:00:27.720 ⇒ 01:00:36.240 Demilade Agboola: So I will then just use that, add that as a new column, and basically PK can be on his way with this.
661 01:00:36.410 ⇒ 01:00:46.910 Demilade Agboola: But I will say, though, okay, yeah, Pete, that’s fine. Okay, I will just… I will just make that, and then you can use that for whatever analysis you need to do.
662 01:00:47.240 ⇒ 01:00:48.240 pk.arthur: Thank you.
663 01:00:50.960 ⇒ 01:00:55.369 Emily Giant: Alright, I gotta hop to my stand-up, but I will talk to y’all.
664 01:00:55.550 ⇒ 01:00:59.979 Emily Giant: later, and PK… I’ll talk to Awash about that ticket.
665 01:01:00.700 ⇒ 01:01:02.419 Emily Giant: with, sessions.
666 01:01:02.420 ⇒ 01:01:03.170 pk.arthur: Sessions? Okay.
667 01:01:03.390 ⇒ 01:01:07.350 Emily Giant: Yeah, and I’ll update that linear ticket so it’s clearer, like.
668 01:01:08.150 ⇒ 01:01:12.470 Emily Giant: what is expected for you to complete versus OASH.
669 01:01:12.970 ⇒ 01:01:13.670 pk.arthur: Okay.
670 01:01:13.990 ⇒ 01:01:14.580 Emily Giant: Okay, cool.
671 01:01:14.580 ⇒ 01:01:14.950 pk.arthur: Thank you.
672 01:01:14.950 ⇒ 01:01:16.820 Emily Giant: Alright, thanks everyone, talk to you soon.
673 01:01:16.880 ⇒ 01:01:17.980 pk.arthur: Bye.
674 01:01:17.980 ⇒ 01:01:18.710 Emily Giant: Bye.