Meeting Title: Grooming: Urban stems Date: 2025-10-15 Meeting participants: Awaish Kumar, Demilade Agboola, Uttam Kumaran, Emily Giant
WEBVTT
1 00:00:22.900 ⇒ 00:00:23.900 Uttam Kumaran: Hey, guys.
2 00:00:24.790 ⇒ 00:00:26.329 Uttam Kumaran: That’s so zoomed in.
3 00:00:36.250 ⇒ 00:00:43.369 Demilade Agboola: Oh, and so Emily says she has a meeting with Zach and Perry for, like, the first half of the call, but she will join after.
4 00:00:44.710 ⇒ 00:00:46.090 Uttam Kumaran: Okay, no problem.
5 00:00:47.040 ⇒ 00:00:56.279 Uttam Kumaran: Let’s get started. So, couple things I’m going to do here…
6 00:00:56.620 ⇒ 00:01:01.100 Uttam Kumaran: Is… one, we’re gonna just be focusing on…
7 00:01:20.630 ⇒ 00:01:30.540 Uttam Kumaran: Okay, so let’s… Talk first about, stuff in next cycle, so…
8 00:01:31.090 ⇒ 00:01:38.250 Uttam Kumaran: This one I have more familiarity with than Eden, so this… Okay…
9 00:01:44.610 ⇒ 00:01:45.130 Demilade Agboola: Awesome.
10 00:01:45.130 ⇒ 00:01:46.730 Uttam Kumaran: Tell me about… Go ahead.
11 00:01:46.730 ⇒ 00:01:58.390 Demilade Agboola: It’s about priority, but for some of the jobs that are running, they’re, like, clear deprecations that are… they, like, it wants to be fixed in the runs, but obviously it’s low priority.
12 00:02:10.220 ⇒ 00:02:13.380 Uttam Kumaran: Cool. Let’s talk about…
13 00:02:14.670 ⇒ 00:02:21.880 Uttam Kumaran: Okay, this one also, I need to kind of go into requirements and figure… remember what we did with this.
14 00:02:22.200 ⇒ 00:02:22.770 Uttam Kumaran: on…
15 00:02:22.770 ⇒ 00:02:26.510 Demilade Agboola: Yeah, so that’s for the… that was for the…
16 00:02:27.890 ⇒ 00:02:29.390 Uttam Kumaran: Redshift cleanups.
17 00:02:29.390 ⇒ 00:02:30.830 Demilade Agboola: Yeah, that’s true.
18 00:02:30.830 ⇒ 00:02:36.359 Uttam Kumaran: Yeah, so I just need to go find the list again, and then… should be pretty easy for us to take on.
19 00:02:36.750 ⇒ 00:02:38.060 Demilade Agboola: Yeah, well, that’s done, though.
20 00:02:38.970 ⇒ 00:02:39.810 Uttam Kumaran: Really? Okay.
21 00:02:40.070 ⇒ 00:02:42.990 Demilade Agboola: Yeah, that’s part of our audit that we… we did.
22 00:02:43.280 ⇒ 00:02:44.630 Uttam Kumaran: Did you actually drop them?
23 00:02:45.610 ⇒ 00:02:49.630 Demilade Agboola: Oh, I’m not sure if they’ve been dropped, I will need to confirm that, actually.
24 00:02:50.010 ⇒ 00:02:53.630 Uttam Kumaran: Okay, yeah, that’s the thing. I don’t… I think we just listed them, I don’t know if we actually dropped them.
25 00:02:55.400 ⇒ 00:02:58.119 Demilade Agboola: Gotcha. Yeah, I’m not sure about that part.
26 00:03:09.840 ⇒ 00:03:11.980 Uttam Kumaran: This one seems like you got it.
27 00:03:15.320 ⇒ 00:03:18.349 Demilade Agboola: Album Logistics Snapshot.
28 00:03:18.560 ⇒ 00:03:22.260 Demilade Agboola: I know we’re taking snapshot of the…
29 00:03:23.250 ⇒ 00:03:30.490 Demilade Agboola: inventory. I’m not sure if that is the non-optimal. I might need to, like, Look deeper into this.
30 00:03:30.850 ⇒ 00:03:43.519 Demilade Agboola: Okay. But I know we have snapshots of the inventory as the inventory changes and everything, and it’s part of what we’re doing, like, part of the things we’re doing in PK right now, so…
31 00:03:44.340 ⇒ 00:03:44.960 Uttam Kumaran: Okay.
32 00:03:49.640 ⇒ 00:03:51.670 Uttam Kumaran: Okay, so then I’m going to…
33 00:03:52.160 ⇒ 00:03:57.120 Uttam Kumaran: maybe talk… well, I’m just gonna say ready for development, we’re gonna… we’ll figure this out.
34 00:03:57.840 ⇒ 00:04:03.300 Uttam Kumaran: Maybe once Emily gets here. Yeah, clean up Metaplane channel.
35 00:04:03.500 ⇒ 00:04:05.570 Uttam Kumaran: I would probably put this as a…
36 00:04:06.330 ⇒ 00:04:09.759 Uttam Kumaran: Higher priority, because it’s probably just an easy thing to close out.
37 00:04:09.950 ⇒ 00:04:13.729 Uttam Kumaran: Move derived table, this one also is a medium.
38 00:04:14.930 ⇒ 00:04:17.940 Uttam Kumaran: Doesn’t need to be next cycle, though.
39 00:04:18.390 ⇒ 00:04:20.440 Uttam Kumaran: Ground stitch… yeah, go ahead.
40 00:04:20.839 ⇒ 00:04:26.739 Demilade Agboola: We will need to create a ticket for some Danish members, if I forget. Yeah.
41 00:04:29.859 ⇒ 00:04:38.049 Demilade Agboola: I mean, actually asked for us to be able to show the product code usage… promo code usage by marketing channel.
42 00:04:38.379 ⇒ 00:04:43.719 Demilade Agboola: And for us to use the marketing channel, we’re gonna have to rely on the UTM sources, basically.
43 00:04:46.620 ⇒ 00:04:49.430 Uttam Kumaran: So, this is, so you… Yeah, go ahead.
44 00:04:49.430 ⇒ 00:04:51.369 Awaish Kumar: I have a question here.
45 00:04:51.840 ⇒ 00:04:52.250 Demilade Agboola: Yeah.
46 00:04:52.250 ⇒ 00:04:57.519 Awaish Kumar: Lithium source utilization, do they need, like, first touch or last touch?
47 00:04:58.810 ⇒ 00:05:01.740 Demilade Agboola: It would have to, despite of the…
48 00:05:01.970 ⇒ 00:05:11.079 Demilade Agboola: scoping. I could show you the conversation, it’s literally just PK reaching out to us, like Emily and myself, and saying, hey, there’s a request from Milox.
49 00:05:12.100 ⇒ 00:05:28.700 Awaish Kumar: So, there was a conversation on Notion about it, and I… we already added a UTM source in our orders data, which covers 100% of orders, but that data is coming from Shopify, and that’s based on the… only the last touch.
50 00:05:29.070 ⇒ 00:05:30.780 Awaish Kumar: That reads…
51 00:05:31.260 ⇒ 00:05:37.899 Awaish Kumar: If a user came from 10 different sources, only the last one where it actually converted gets
52 00:05:38.050 ⇒ 00:05:40.390 Awaish Kumar: selected as a YouTube source.
53 00:05:40.510 ⇒ 00:05:45.719 Awaish Kumar: So, there are also… wanted us to use a dropspeed export.
54 00:05:45.910 ⇒ 00:05:53.599 Awaish Kumar: Because it… lastly, we can get first touch as well. So if a user came through Facebook, it will be first
55 00:05:53.780 ⇒ 00:06:00.670 Awaish Kumar: But when he came organically when placing the order, it will still be attributed to Facebook, so…
56 00:06:01.590 ⇒ 00:06:05.099 Awaish Kumar: That way, so… I think we need to have a…
57 00:06:05.600 ⇒ 00:06:15.060 Awaish Kumar: two different fields, one for UTM source from Shopify, and another UTM source from Northstream, which can cover both the scenarios.
58 00:06:16.950 ⇒ 00:06:20.210 Demilade Agboola: Okay, sounds good. I think right now,
59 00:06:20.550 ⇒ 00:06:28.220 Demilade Agboola: PK, who is one of the analysts, seems fine using just the Shopify, because they don’t have any… they don’t have any…
60 00:06:28.780 ⇒ 00:06:32.029 Demilade Agboola: way to, like, show any touch at all, like, any UTM touch.
61 00:06:32.030 ⇒ 00:06:38.949 Uttam Kumaran: Well, why don’t you just create… just leave it both there. Put a column for first touch, put a column for last touch. Then you can just… they can decide.
62 00:06:39.560 ⇒ 00:06:46.420 Awaish Kumar: Yeah, but the thing is, for the fu… like, we are getting data from Shopify. That is…
63 00:06:46.670 ⇒ 00:06:56.139 Awaish Kumar: like, last touch, right? But we don’t have data for first touch, and that is why we need to actually go through all the Northwim export thing.
64 00:06:59.180 ⇒ 00:07:10.139 Awaish Kumar: I see. We have to export order data from Northwave now, and I tried that today, but the problem is, I’m not getting 100%, like, the attribution there.
65 00:07:10.330 ⇒ 00:07:13.399 Awaish Kumar: It can cover maybe 50% of the orders.
66 00:07:13.500 ⇒ 00:07:17.309 Awaish Kumar: And I can bring that in as a last… as a first stitch.
67 00:07:17.890 ⇒ 00:07:20.590 Uttam Kumaran: Well, that’s fine, yeah, not everything’s gonna have attribution.
68 00:07:21.170 ⇒ 00:07:21.840 Awaish Kumar: Okay.
69 00:07:22.920 ⇒ 00:07:27.450 Uttam Kumaran: So, I would say… I would say probably the better route here is to put…
70 00:07:27.850 ⇒ 00:07:31.550 Uttam Kumaran: So you have it… the table, the table basically is, like.
71 00:07:31.780 ⇒ 00:07:33.530 Uttam Kumaran: I’m just gonna put it here.
72 00:07:33.880 ⇒ 00:07:40.720 Uttam Kumaran: You’re gonna have, like, the order details, you’re gonna have… Shopify, last touch.
73 00:07:41.010 ⇒ 00:07:42.470 Uttam Kumaran: And then north…
74 00:07:42.470 ⇒ 00:07:44.619 Awaish Kumar: Being first touch.
75 00:07:48.330 ⇒ 00:07:52.019 Awaish Kumar: But do we really need all these in a separate table? Like, I already.
76 00:07:52.020 ⇒ 00:07:52.560 Uttam Kumaran: Included.
77 00:07:53.020 ⇒ 00:07:53.930 Uttam Kumaran: Yeah, or put it…
78 00:07:54.340 ⇒ 00:07:55.840 Demilade Agboola: Yeah, put it in.
79 00:07:55.840 ⇒ 00:07:56.860 Uttam Kumaran: Yeah, yeah, yeah.
80 00:07:57.000 ⇒ 00:07:58.680 Uttam Kumaran: Yeah, you can put it in the same tab.
81 00:08:00.190 ⇒ 00:08:01.910 Uttam Kumaran: Modify fact orders, yeah.
82 00:08:02.400 ⇒ 00:08:03.210 Demilade Agboola: Okay.
83 00:08:05.550 ⇒ 00:08:09.780 Uttam Kumaran: Do you want a separate… Ticket for each… 1?
84 00:08:10.380 ⇒ 00:08:15.029 Awaish Kumar: No, the Shopify one is done already, so we just… I just need to work on North…
85 00:08:16.410 ⇒ 00:08:18.730 Uttam Kumaran: Do you have it in as Shopify Last Touch?
86 00:08:19.200 ⇒ 00:08:22.379 Awaish Kumar: Yeah, right now it’s called Utum Source, but I can rename it.
87 00:08:23.200 ⇒ 00:08:25.890 Uttam Kumaran: Shopify. Yeah, yeah, yeah, okay.
88 00:08:25.890 ⇒ 00:08:32.600 Demilade Agboola: Also, we’ll need to… I’ll just, like, once you’re done, I could just ask Emily to expose the data.
89 00:08:32.809 ⇒ 00:08:34.619 Demilade Agboola: in Looker, so that’s.
90 00:08:34.620 ⇒ 00:08:35.280 Uttam Kumaran: Yes.
91 00:08:36.870 ⇒ 00:08:42.710 Demilade Agboola: We can start doing some… like, we can start doing analysis on it for… The Daily Performance Report.
92 00:08:43.809 ⇒ 00:08:48.219 Awaish Kumar: But that is order attribution, right? But what was that promo code?
93 00:08:48.910 ⇒ 00:08:50.790 Demilade Agboola: What’s…
94 00:08:50.790 ⇒ 00:08:51.310 Awaish Kumar: Nope.
95 00:08:52.230 ⇒ 00:08:57.149 Demilade Agboola: No, it’s the… I mean, promo code should be in the table, but I will look through and just confirm.
96 00:08:59.580 ⇒ 00:09:00.310 Awaish Kumar: Okay.
97 00:09:01.200 ⇒ 00:09:03.440 Uttam Kumaran: Oh, so you want to put promo code here, too.
98 00:09:04.640 ⇒ 00:09:09.780 Demilade Agboola: Yes, there should be promo code in the other table, but I am not sure. I would have to look through and confirm.
99 00:09:11.450 ⇒ 00:09:12.070 Uttam Kumaran: Okay.
100 00:09:15.790 ⇒ 00:09:16.580 Uttam Kumaran: Okay.
101 00:09:20.060 ⇒ 00:09:26.969 Demilade Agboola: Alright, so that’s one of the themes. Another question, I know, I was trying to find a ticket, but I know we had stuff about sessions, data.
102 00:09:27.550 ⇒ 00:09:30.659 Demilade Agboola: for, like, GA4 sessions data ingesting it.
103 00:09:31.260 ⇒ 00:09:31.960 Demilade Agboola: I just…
104 00:09:31.960 ⇒ 00:09:34.880 Awaish Kumar: Yes, yes, I already worked on that ticket, right?
105 00:09:35.640 ⇒ 00:09:40.069 Awaish Kumar: So we, we have sessions data coming into Redshift.
106 00:09:40.440 ⇒ 00:09:46.049 Awaish Kumar: But using that, we can count total sessions, like, it’s not very granular, like.
107 00:09:46.430 ⇒ 00:09:49.459 Awaish Kumar: We are not getting each session event, right? Session ID.
108 00:09:49.890 ⇒ 00:09:56.270 Awaish Kumar: That’s basically giving us some… Segments, like, but using that, we can count the total
109 00:09:56.630 ⇒ 00:09:59.379 Awaish Kumar: Sessions by all the users.
110 00:09:59.630 ⇒ 00:10:05.029 Awaish Kumar: And, like, who can create the dashboard you showed me on Shopify?
111 00:10:05.880 ⇒ 00:10:12.009 Demilade Agboola: Okay, so I’ll ask, I’ll ask, Pique if that’s fine, if we can do high-level GA.
112 00:10:12.120 ⇒ 00:10:12.660 Demilade Agboola: Professor…
113 00:10:12.660 ⇒ 00:10:13.170 Awaish Kumar: June.
114 00:10:13.740 ⇒ 00:10:19.750 Demilade Agboola: number… total number of orders placed. If he wants more granular, then I will…
115 00:10:19.750 ⇒ 00:10:23.740 Awaish Kumar: Using that stitch connector, like, it was not possible to go…
116 00:10:24.720 ⇒ 00:10:27.419 Awaish Kumar: more granular, like, we might have to then…
117 00:10:27.760 ⇒ 00:10:29.940 Awaish Kumar: Bring it in some other way.
118 00:10:30.480 ⇒ 00:10:33.160 Demilade Agboola: Okay, alright, sounds good, I’ll let him know.
119 00:10:35.120 ⇒ 00:10:35.720 Uttam Kumaran: Okay.
120 00:10:36.160 ⇒ 00:10:40.400 Uttam Kumaran: Do I need… so I’ll just leave this like this?
121 00:10:42.180 ⇒ 00:10:46.459 Demilade Agboola: Yeah, that should be fine. I just wanted to confirm so I can let them know.
122 00:10:46.700 ⇒ 00:10:48.719 Demilade Agboola: Some of the things that are happening as well.
123 00:10:49.730 ⇒ 00:10:53.309 Uttam Kumaran: Okay, then I’m just gonna create a related ticket, related zero-point ticket.
124 00:11:06.150 ⇒ 00:11:08.609 Uttam Kumaran: Do you want me to include anything here, Demolade?
125 00:11:10.220 ⇒ 00:11:15.719 Demilade Agboola: Come from, I’ll come from JSK. Yeah, just reach out to PKA.
126 00:11:16.070 ⇒ 00:11:17.400 Demilade Agboola: To let him know.
127 00:11:18.280 ⇒ 00:11:23.099 Demilade Agboola: the outcome, and… Send feedback back to the BF team.
128 00:11:32.910 ⇒ 00:11:33.690 Demilade Agboola: Okay.
129 00:11:36.340 ⇒ 00:11:38.479 Demilade Agboola: I think that was the AI team or something.
130 00:11:39.200 ⇒ 00:11:40.290 Demilade Agboola: about the tags.
131 00:11:42.960 ⇒ 00:11:44.519 Demilade Agboola: Interesting, I don’t know what’s what you ate.
132 00:11:45.020 ⇒ 00:11:46.030 Uttam Kumaran: Okay, sorry.
133 00:11:46.370 ⇒ 00:11:50.050 Uttam Kumaran: Okay, great, so… that’s fine.
134 00:11:50.940 ⇒ 00:11:57.190 Uttam Kumaran: For these ones… Should I…
135 00:11:57.840 ⇒ 00:11:59.179 Demilade Agboola: So, for revenue…
136 00:11:59.690 ⇒ 00:12:00.130 Uttam Kumaran: Yeah.
137 00:12:00.130 ⇒ 00:12:12.450 Demilade Agboola: Emily wants to finish up subscriptions today, and amortized subscriptions revenue, so basically later today or early tomorrow, I’ll start… I’ll build out the framework of the revenue.
138 00:12:13.640 ⇒ 00:12:18.600 Uttam Kumaran: So I’m gonna move these here… And then…
139 00:12:20.190 ⇒ 00:12:26.710 Uttam Kumaran: What I’m gonna do is mark… This is urgent.
140 00:12:34.300 ⇒ 00:12:35.080 Uttam Kumaran: Okay.
141 00:13:15.310 ⇒ 00:13:18.150 Uttam Kumaran: This one is kind of, like, ongoing, right?
142 00:13:20.740 ⇒ 00:13:23.840 Demilade Agboola: Yeah, it’s an ongoing thing, basically.
143 00:13:25.750 ⇒ 00:13:27.790 Uttam Kumaran: Yeah, okay, so that’s fine.
144 00:13:32.060 ⇒ 00:13:35.500 Uttam Kumaran: This one, I’m gonna move to backlog.
145 00:13:36.030 ⇒ 00:13:38.019 Uttam Kumaran: Once things are stable…
146 00:13:53.490 ⇒ 00:13:54.979 Uttam Kumaran: This one’s done, right?
147 00:13:57.990 ⇒ 00:13:58.700 Demilade Agboola: Yes.
148 00:14:02.730 ⇒ 00:14:03.730 Uttam Kumaran: Ayy…
149 00:14:10.530 ⇒ 00:14:14.220 Uttam Kumaran: This one, maybe we can… I think we have to do this.
150 00:14:15.080 ⇒ 00:14:15.880 Uttam Kumaran: some point.
151 00:14:17.530 ⇒ 00:14:19.740 Uttam Kumaran: So, I’ll… I could message Emily.
152 00:14:25.850 ⇒ 00:14:30.970 Demilade Agboola: Yeah, I know she’s… part of what she’s… what she’s working on is also the keyway of the data.
153 00:14:31.560 ⇒ 00:14:39.949 Demilade Agboola: But yeah, because to be able to… because part of what I’m driving at is, you know, Paris… I believe Paris two weeks end, like, this week?
154 00:14:40.570 ⇒ 00:14:41.230 Uttam Kumaran: Yeah.
155 00:14:41.520 ⇒ 00:14:45.440 Demilade Agboola: So, I would really like to be able to see her just tomorrow, so we can…
156 00:14:45.650 ⇒ 00:14:50.009 Demilade Agboola: finalized the numbers and how they make sense.
157 00:14:50.010 ⇒ 00:14:50.570 Uttam Kumaran: Okay.
158 00:14:51.360 ⇒ 00:15:08.049 Demilade Agboola: Especially, like, subscriptions. Revenue is in a pretty good spot, and, like, we had done a QA earlier this week with Emily as well, and the numbers are pretty good. It’s just, like, revenue from orders specifically, fine. It’s subscriptions that, you know, we just want to get everything in total, in a good spot.
159 00:15:08.870 ⇒ 00:15:09.370 Uttam Kumaran: Okay.
160 00:15:22.120 ⇒ 00:15:26.500 Uttam Kumaran: This one, did we end up, like… Identifying this yet?
161 00:15:27.510 ⇒ 00:15:34.619 Demilade Agboola: I think we just kind of let it be, because we… it seemed to re-correct, towards the end of days.
162 00:15:34.850 ⇒ 00:15:37.640 Demilade Agboola: And since this is, like, the old model.
163 00:15:38.590 ⇒ 00:15:41.100 Demilade Agboola: That we will be replacing very soon.
164 00:15:42.230 ⇒ 00:15:43.690 Demilade Agboola: We just kind of freed it.
165 00:15:44.700 ⇒ 00:15:47.910 Uttam Kumaran: Do you think it’s worth sending something on it?
166 00:15:48.130 ⇒ 00:15:49.930 Uttam Kumaran: That thread, or no?
167 00:15:54.700 ⇒ 00:15:58.930 Demilade Agboola: I think we should probably… C.
168 00:15:58.930 ⇒ 00:15:59.940 Uttam Kumaran: I can send something.
169 00:16:00.400 ⇒ 00:16:11.920 Demilade Agboola: Yeah, because the numbers seem to really, like, regularize, quote-unquote, so it’s kind of one of those things you have to find in the moment, and if the moment’s passed, it’s kind of hard to detect it again.
170 00:16:12.240 ⇒ 00:16:16.470 Demilade Agboola: So… Potentially be…
171 00:16:16.470 ⇒ 00:16:17.050 Uttam Kumaran: Sweet.
172 00:16:17.310 ⇒ 00:16:18.380 Uttam Kumaran: If any…
173 00:16:18.560 ⇒ 00:16:24.459 Demilade Agboola: Just say, like, right now it seems to be in a good spot, but, like, if anything does happen, do let us know when it does.
174 00:16:24.870 ⇒ 00:16:25.850 Demilade Agboola: Maybe. Okay.
175 00:16:26.040 ⇒ 00:16:27.400 Demilade Agboola: Like, something of that.
176 00:16:28.520 ⇒ 00:16:29.090 Uttam Kumaran: Okay.
177 00:16:31.450 ⇒ 00:16:35.299 Demilade Agboola: And I think we added the… did we add it to the metaplane theme?
178 00:16:36.260 ⇒ 00:16:38.380 Uttam Kumaran: Yeah, that’s why Oakesha’s working on this.
179 00:16:42.100 ⇒ 00:16:48.159 Demilade Agboola: Another thing is, do we want to put Metaplane on old models? Like, things that we’ll be deprecating very soon, or the plan is to deprecate them?
180 00:16:48.990 ⇒ 00:16:54.179 Uttam Kumaran: I… I mean, I would any… I would put it on old stuff, for sure, just in case.
181 00:16:54.400 ⇒ 00:16:55.740 Uttam Kumaran: Like, those break.
182 00:16:56.730 ⇒ 00:16:58.200 Demilade Agboola: Okay, sounds good.
183 00:16:59.430 ⇒ 00:17:01.860 Uttam Kumaran: Okay, cool, so I feel like,
184 00:17:02.910 ⇒ 00:17:06.489 Uttam Kumaran: Yeah, like, I want to get these revenue items out.
185 00:17:06.730 ⇒ 00:17:12.739 Uttam Kumaran: If we look at things in the backlog, and things that we want to start requirements on.
186 00:17:18.050 ⇒ 00:17:32.679 Demilade Agboola: I think the huge win right now will be revenue. Anything concerning revenue will be important. So, them being able to see revenue properly by, you know, states, by fulfillment center, okay.
187 00:17:33.140 ⇒ 00:17:34.620 Demilade Agboola: product SKU…
188 00:17:34.820 ⇒ 00:17:40.149 Demilade Agboola: That sort of thing would be very helpful, because, like, their everyday data is generally not the best.
189 00:17:40.360 ⇒ 00:17:43.630 Demilade Agboola: Okay. Obviously, it’s a huge thing.
190 00:17:44.060 ⇒ 00:17:49.050 Demilade Agboola: Obviously, subscriptions, being able to add subscriptions as well, because they don’t have access to that right now.
191 00:17:49.210 ⇒ 00:17:50.919 Demilade Agboola: Would also be a huge thing as well.
192 00:17:58.270 ⇒ 00:18:01.279 Demilade Agboola: Yeah, so, like, they have a lot of revenue issues.
193 00:18:07.030 ⇒ 00:18:14.660 Demilade Agboola: So I feel like if we can, like, hammer home, especially, like, the inventory, like, I think I pointed out to you about PK being able to see
194 00:18:14.780 ⇒ 00:18:18.920 Demilade Agboola: Like, right now, we’re able to show them the exact time.
195 00:18:19.280 ⇒ 00:18:25.519 Demilade Agboola: that inventory went out of stock on their website. Like, when customers could not order anything anymore.
196 00:18:25.680 ⇒ 00:18:29.099 Demilade Agboola: And we can show them for how long that state was… he was in that state.
197 00:18:30.770 ⇒ 00:18:31.530 Uttam Kumaran: Yeah.
198 00:18:31.810 ⇒ 00:18:38.990 Demilade Agboola: You know, things like that, like, we’re, like, being able to show that, like, because we have snapshots, so we can see when the inventory number dropped below a certain amount.
199 00:18:39.140 ⇒ 00:18:44.340 Demilade Agboola: Or we can see, like, Yeah, we can just see a lot of stuff that’s going on there, basically.
200 00:18:47.030 ⇒ 00:18:52.660 Uttam Kumaran: This one, I’m gonna do daily, weekly… Monthly…
201 00:18:55.720 ⇒ 00:18:57.310 Uttam Kumaran: And then… okay.
202 00:18:57.550 ⇒ 00:19:00.929 Uttam Kumaran: So, that’s where I kind of, like, want to,
203 00:19:01.700 ⇒ 00:19:05.880 Uttam Kumaran: kind of, like, the way I think I want to structure it is, like, answering questions.
204 00:19:06.560 ⇒ 00:19:12.059 Uttam Kumaran: So, like, in that sense, The question there would be…
205 00:19:12.830 ⇒ 00:19:22.209 Uttam Kumaran: Like, what would be, like, the definition of, like, that question? Because ideally, what I could do is we can say, like, we can now answer this question, and then we could link to the Looker report where you can do that.
206 00:19:24.930 ⇒ 00:19:27.149 Demilade Agboola: The Peaky theme? The inventory theme.
207 00:19:27.510 ⇒ 00:19:28.210 Uttam Kumaran: Yeah.
208 00:19:29.260 ⇒ 00:19:34.009 Demilade Agboola: So, basically, PK’s question, or PK’s task, is he wants to know
209 00:19:34.560 ⇒ 00:19:40.849 Demilade Agboola: At what point in time, customers were unable to order stock, like, whatever, inventory stock.
210 00:19:43.460 ⇒ 00:19:54.199 Demilade Agboola: And so now, we’re able to show them, like, hey, this was the stock, this is how stock has changed hour by hour, and this is the exact point in time your stock went to zero or negative.
211 00:19:56.120 ⇒ 00:20:07.130 Demilade Agboola: And at that point, you can then use that to be able to say, hey, round for stock really early, was it a supply issue? Did we forecasting correctly? Did we, like, you know.
212 00:20:07.360 ⇒ 00:20:09.519 Demilade Agboola: Did it take us too long to restock?
213 00:20:09.980 ⇒ 00:20:14.580 Demilade Agboola: You know, you can kind of get an idea of How… and also.
214 00:20:15.020 ⇒ 00:20:21.059 Demilade Agboola: Part of what we’re doing with this revenue stuff is you can also see things where people order things, and
215 00:20:21.170 ⇒ 00:20:26.730 Demilade Agboola: It’s not available, so therefore they give them a new Product, like a new…
216 00:20:27.050 ⇒ 00:20:32.780 Demilade Agboola: products to replace that. So if I order, like, a rose, but it’s not available, and they say, hey, take
217 00:20:33.070 ⇒ 00:20:35.290 Demilade Agboola: you know, Pyrenees instead.
218 00:20:35.490 ⇒ 00:20:40.949 Demilade Agboola: That would allow us to see how much revenue, potentially, you lost because of that, you know.
219 00:20:53.560 ⇒ 00:20:54.180 Uttam Kumaran: Right.
220 00:21:05.400 ⇒ 00:21:07.000 Uttam Kumaran: Great, this… these would be great.
221 00:21:12.170 ⇒ 00:21:14.130 Uttam Kumaran: Okay, cool. So…
222 00:21:15.150 ⇒ 00:21:23.549 Uttam Kumaran: What I can do is, I can kind of send this to Emily and see, like, I’m… I feel pretty good about what the next week is gonna look like.
223 00:21:23.840 ⇒ 00:21:29.620 Uttam Kumaran: Yeah, I would like to see them a lot of, like, how I can drive to finish, like.
224 00:21:29.950 ⇒ 00:21:33.429 Uttam Kumaran: we can finish to get revenue up. I’m actually less concerned with
225 00:21:33.940 ⇒ 00:21:36.440 Uttam Kumaran: any of these items, so if you want, I can…
226 00:21:36.880 ⇒ 00:21:44.930 Uttam Kumaran: like, these, we can… we can have a ways to take a look at them, or… yeah, but I… I want to push as much towards, like, getting the revenue
227 00:21:45.500 ⇒ 00:21:46.770 Uttam Kumaran: items out.
228 00:21:47.210 ⇒ 00:21:49.029 Uttam Kumaran: So, let me know, like, how I can help.
229 00:21:50.220 ⇒ 00:21:54.010 Demilade Agboola: Yeah, sure. For the other ones, yeah, we’re basically… those ones are, like…
230 00:21:55.240 ⇒ 00:22:01.519 Demilade Agboola: the current block is the subscriptions bit, which, like I said,
231 00:22:01.990 ⇒ 00:22:11.669 Demilade Agboola: That makes I should be done in, like, an hour or so. So once that’s done, I will literally just push out, like, a ton of, like, revenue models, and… Okay.
232 00:22:12.260 ⇒ 00:22:21.169 Demilade Agboola: being able to show the revenue by, like, you know, different levels of granularity. That would be the final step, basically, and we can…
233 00:22:21.660 ⇒ 00:22:23.900 Demilade Agboola: We can review that, like, tomorrow.
234 00:22:25.010 ⇒ 00:22:33.349 Demilade Agboola: But the other stuff is stuff, like, it wasn’t heavy, it wasn’t high priority, but, like, given the fact that I was waiting for the other stuff, I just got that out the way.
235 00:22:34.100 ⇒ 00:22:35.139 Uttam Kumaran: Okay, okay.
236 00:22:40.690 ⇒ 00:22:45.070 Uttam Kumaran: Okay, great. Cool.
237 00:22:45.310 ⇒ 00:23:04.080 Uttam Kumaran: Anything else? So, one thing for next week’s grooming is… I’m just gonna look back through here. I think inventory, I feel pretty good. Revenue feel pretty good. I think I want to start to… we can start to talk about, like, what sources are coming after this next.
238 00:23:04.230 ⇒ 00:23:05.490 Uttam Kumaran: Ideally.
239 00:23:05.770 ⇒ 00:23:10.810 Uttam Kumaran: I’m gonna kind of present this to Zach and say, okay, like, where should we spend our next kind of effort?
240 00:23:11.090 ⇒ 00:23:15.060 Uttam Kumaran: Whether he wants to continue to ask… answer more questions on the revenue side, or we should
241 00:23:15.280 ⇒ 00:23:17.450 Uttam Kumaran: work in Looker, so I can find that out.
242 00:23:18.840 ⇒ 00:23:25.189 Demilade Agboola: Yeah, yeah, I will… I will say, though, that for…
243 00:23:27.490 ⇒ 00:23:30.260 Demilade Agboola: Like, looking forward, we probably will want to look
244 00:23:31.570 ⇒ 00:23:35.939 Demilade Agboola: It does appear that there’s a lot of stuff around marketing that, like, they haven’t answered.
245 00:23:35.940 ⇒ 00:23:36.380 Uttam Kumaran: Yeah.
246 00:23:36.380 ⇒ 00:23:36.949 Demilade Agboola: That’s true.
247 00:23:37.630 ⇒ 00:23:39.060 Demilade Agboola: Those two things.
248 00:23:39.370 ⇒ 00:23:40.449 Demilade Agboola: Oh, yeah.
249 00:23:40.740 ⇒ 00:23:42.900 Demilade Agboola: Potentially things that we could look into.
250 00:23:43.160 ⇒ 00:23:50.170 Demilade Agboola: And, so… Oh, hi, Emily.
251 00:23:51.800 ⇒ 00:23:54.349 Emily Giant: Hello, sorry about missing the first half.
252 00:23:55.600 ⇒ 00:24:00.509 Uttam Kumaran: We’re good, we’re actually towards the end, so I guess I have a couple questions I was gonna ping you anyways.
253 00:24:00.510 ⇒ 00:24:00.920 Emily Giant: Yes.
254 00:24:00.920 ⇒ 00:24:10.810 Uttam Kumaran: Yeah, so we basically went through and sort of cleaned up the board a little bit. Kind of overall goal is to just try to continue to push as much stuff out
255 00:24:10.910 ⇒ 00:24:13.380 Uttam Kumaran: For revenue as possible.
256 00:24:13.770 ⇒ 00:24:19.370 Uttam Kumaran: I guess I wanted to just get a sense for… These,
257 00:24:20.170 ⇒ 00:24:24.380 Uttam Kumaran: Did you want to still leave these for, like, next cycle, or should we just move these to, like.
258 00:24:24.850 ⇒ 00:24:26.500 Uttam Kumaran: Baroon Backlog.
259 00:24:28.140 ⇒ 00:24:28.866 Emily Giant: He’s like.
260 00:24:29.830 ⇒ 00:24:34.509 Emily Giant: Let’s move those to next. Any kind of QA, let’s move to next session, so that we can…
261 00:24:34.870 ⇒ 00:24:38.200 Emily Giant: Slot in the marketing stuff.
262 00:24:38.720 ⇒ 00:24:41.949 Emily Giant: That, Menakshi’s looking for.
263 00:24:42.540 ⇒ 00:24:45.710 Uttam Kumaran: Okay, cool. And then, yeah, we… we… we already,
264 00:24:45.990 ⇒ 00:24:48.140 Uttam Kumaran: Sort of triage that, and so…
265 00:24:48.330 ⇒ 00:24:52.779 Uttam Kumaran: I think we’re probably just, like, a few hours away from having that ordered by…
266 00:24:52.890 ⇒ 00:24:54.989 Uttam Kumaran: the UTM sources and stuff like that.
267 00:24:57.390 ⇒ 00:25:02.970 Uttam Kumaran: Cool, and then, yeah, I guess I was just gonna ask if there’s anything in the backlog that we need to…
268 00:25:03.720 ⇒ 00:25:09.139 Uttam Kumaran: move and, like, start to groom. Otherwise, like, these are the things that I’m going to…
269 00:25:09.410 ⇒ 00:25:11.759 Uttam Kumaran: Kind of put some effort into grooming.
270 00:25:12.090 ⇒ 00:25:17.309 Uttam Kumaran: But we have a fair bit of stuff already ready for the next…
271 00:25:18.270 ⇒ 00:25:20.190 Uttam Kumaran: You know, probably a sprint or two.
272 00:25:24.720 ⇒ 00:25:26.529 Emily Giant: This looks like enough.
273 00:25:26.540 ⇒ 00:25:27.350 Uttam Kumaran: Okay.
274 00:25:28.220 ⇒ 00:25:33.860 Uttam Kumaran: Are any of… I guess if you can give me a sense for, like, these three…
275 00:25:34.100 ⇒ 00:25:37.589 Uttam Kumaran: Like, what their priority would be, or, like, any details.
276 00:25:39.520 ⇒ 00:25:41.290 Emily Giant: That’s done. We fixed that.
277 00:25:41.740 ⇒ 00:25:42.340 Uttam Kumaran: Okay.
278 00:25:42.340 ⇒ 00:25:45.419 Emily Giant: I actually think you fixed that when I was gone.
279 00:25:45.660 ⇒ 00:25:46.880 Uttam Kumaran: Oh, yes, I did.
280 00:25:47.230 ⇒ 00:25:47.810 Emily Giant: Yeah.
281 00:25:48.100 ⇒ 00:25:48.839 Uttam Kumaran: They did.
282 00:25:49.220 ⇒ 00:25:51.430 Uttam Kumaran: This one…
283 00:25:51.800 ⇒ 00:25:53.980 Emily Giant: That is part of the marketing request.
284 00:25:54.130 ⇒ 00:25:59.100 Emily Giant: So, yeah, that one I would…
285 00:26:00.040 ⇒ 00:26:07.960 Emily Giant: say it’s, like, slotted into the marketing stuff. Basically, they need to know, like, if maps are open when
286 00:26:08.070 ⇒ 00:26:10.439 Emily Giant: A customer does not convert.
287 00:26:14.480 ⇒ 00:26:17.820 Uttam Kumaran: What is… wait, can you say that one more time in English?
288 00:26:18.430 ⇒ 00:26:33.570 Emily Giant: So, this is related to the marketing data and conversion, and not all of our delivery maps are available at every time of the day, so they’re trying to get an idea of if a customer is not purchasing.
289 00:26:34.430 ⇒ 00:26:38.429 Emily Giant: Based on delivery not being available in that area.
290 00:26:38.810 ⇒ 00:26:46.909 Emily Giant: Essentially, we are able to buy delivery areas, or pay more on the shipping front, with our providers.
291 00:26:47.020 ⇒ 00:26:59.619 Emily Giant: if there is an area that we see not converting, and it looks like it’s on a Friday because there’s no Saturday delivery. So it’s just being able to do that level of analysis with our delivery providers.
292 00:27:02.500 ⇒ 00:27:03.400 Uttam Kumaran: Great.
293 00:27:04.520 ⇒ 00:27:05.760 Emily Giant: Does that make more sense?
294 00:27:05.960 ⇒ 00:27:08.169 Uttam Kumaran: That makes a total sense, yeah.
295 00:27:09.120 ⇒ 00:27:14.840 Uttam Kumaran: I guess my question would be, Okay, so they should probably…
296 00:27:15.370 ⇒ 00:27:20.270 Uttam Kumaran: I guess, do you have a sense of, like, what models that could be used to answer the question?
297 00:27:25.040 ⇒ 00:27:27.110 Emily Giant: I don’t have a sense of…
298 00:27:28.340 ⇒ 00:27:32.289 Emily Giant: What would provide closed delivery windows?
299 00:27:32.690 ⇒ 00:27:43.320 Emily Giant: maybe Shopify? There’s a shipping table that I, haven’t dug into very far. I know that we used to have a Hivo table that provided,
300 00:27:43.600 ⇒ 00:27:45.219 Emily Giant: delivery windows.
301 00:27:45.570 ⇒ 00:27:47.640 Emily Giant: So, I think the information exists.
302 00:27:47.960 ⇒ 00:27:56.619 Emily Giant: I don’t think we’ll have to, like, Create any, like… New… newly ingested data.
303 00:27:57.250 ⇒ 00:28:00.160 Emily Giant: Okay. We just gotta find… we have to find where it exists.
304 00:28:01.840 ⇒ 00:28:04.169 Uttam Kumaran: Is this, like, a super… is this, like, a medium?
305 00:28:04.500 ⇒ 00:28:06.249 Emily Giant: It’s a medium, for sure.
306 00:28:06.250 ⇒ 00:28:06.880 Uttam Kumaran: Okay.
307 00:28:07.460 ⇒ 00:28:11.730 Emily Giant: Although, like, one thing I’d say is that I think I’d have trouble doing this without y’all.
308 00:28:11.880 ⇒ 00:28:22.079 Emily Giant: And so, like, at this juncture, I’m looking at things, like, that Emily could do on her own versus would need some expert assistance, and I think this is one of those.
309 00:28:22.370 ⇒ 00:28:22.940 Uttam Kumaran: Okay.
310 00:28:25.380 ⇒ 00:28:27.519 Uttam Kumaran: And then this one…
311 00:28:27.870 ⇒ 00:28:30.239 Emily Giant: That is actually pretty…
312 00:28:30.830 ⇒ 00:28:41.280 Emily Giant: important in that Shopify does not currently ingest B2B orders, so we do need to pad revenue with…
313 00:28:41.640 ⇒ 00:28:48.719 Emily Giant: there needs to be, like, a new Kivo table, I guess, from OMS, because that’s the only place where we capture B2B
314 00:28:49.310 ⇒ 00:28:50.860 Emily Giant: sales.
315 00:28:51.840 ⇒ 00:28:53.629 Demilade Agboola: Is there a flag for B2B sales?
316 00:28:58.710 ⇒ 00:29:08.399 Emily Giant: Yeah, because it’s the only thing that uses the bulk uploader, so there’s gotta be some, like, indication that, like, the order was ingested from bulk upload.
317 00:29:08.590 ⇒ 00:29:10.479 Emily Giant: But I’ll have to get that for you.
318 00:29:11.100 ⇒ 00:29:17.549 Demilade Agboola: Oh, that’s fine. Just a part of things just to think about, but yeah, we can always get B2B. That would probably be the…
319 00:29:19.430 ⇒ 00:29:20.430 Demilade Agboola: Final…
320 00:29:22.230 ⇒ 00:29:23.639 Emily Giant: The final revenue piece.
321 00:29:23.910 ⇒ 00:29:24.550 Demilade Agboola: Yeah.
322 00:29:32.860 ⇒ 00:29:38.340 Uttam Kumaran: Okay, that seems pretty… Groomed, to me.
323 00:29:38.690 ⇒ 00:29:39.470 Emily Giant: Yep.
324 00:29:42.030 ⇒ 00:29:47.100 Uttam Kumaran: Okay… Okay.
325 00:29:47.320 ⇒ 00:29:48.660 Awaish Kumar: Whoop, whoops.
326 00:29:48.970 ⇒ 00:29:51.630 Awaish Kumar: What is the source for the video we saved?
327 00:29:52.650 ⇒ 00:29:53.580 Demilade Agboola: OMS.
328 00:29:55.430 ⇒ 00:29:57.369 Awaish Kumar: Oh, well, awesome.
329 00:30:08.940 ⇒ 00:30:11.470 Uttam Kumaran: Okay, great. How about this one?
330 00:30:15.010 ⇒ 00:30:16.709 Emily Giant: This should all fix itself.
331 00:30:17.130 ⇒ 00:30:22.710 Emily Giant: with the revenue, so I would say won’t do, but I do want to,
332 00:30:22.900 ⇒ 00:30:31.150 Emily Giant: So, since Perry’s leaving, and she was, like, our human error detector, I do want to build in tests.
333 00:30:31.640 ⇒ 00:30:43.999 Emily Giant: That catch if… average order sales go below a certain number. If subscriptions are under $55, if,
334 00:30:45.120 ⇒ 00:30:51.349 Emily Giant: any of those, like, revenue gotchas, if AUR is, like, below $60,
335 00:30:54.280 ⇒ 00:30:58.590 Emily Giant: Yeah, just to make sure that, like, and it shouldn’t…
336 00:30:58.820 ⇒ 00:31:04.790 Emily Giant: It should just be a warning, not an error, per se, but, like, those are the things she checks every morning.
337 00:31:05.110 ⇒ 00:31:09.429 Emily Giant: That nobody’s going to be checking anymore. So…
338 00:31:09.430 ⇒ 00:31:10.000 Uttam Kumaran: Yay.
339 00:31:10.210 ⇒ 00:31:11.000 Emily Giant: Yeah.
340 00:31:11.000 ⇒ 00:31:14.060 Uttam Kumaran: So this one, I think we can create… you can…
341 00:31:14.640 ⇒ 00:31:18.939 Uttam Kumaran: I think you can create Metaplane alerts for this, and it would just come directly into the channel, so…
342 00:31:19.330 ⇒ 00:31:32.470 Emily Giant: That’d be great. Yeah, I also need to clean out Looker so that those errors are worthwhile. There’s just so many Looker errors right now, and 90% of them are not applicable, because they’re models that need to be archived, so…
343 00:31:32.470 ⇒ 00:31:39.369 Emily Giant: like, I want Metaplane to be useful for Looker errors at some point, but that’s not high priority, because that’s something I could do.
344 00:31:40.910 ⇒ 00:31:43.029 Uttam Kumaran: Yeah, so one thing for the… yeah, okay, okay.
345 00:31:44.020 ⇒ 00:31:44.720 Uttam Kumaran: Okay.
346 00:31:46.810 ⇒ 00:31:55.499 Uttam Kumaran: Cool. There’s also… there’s this ticket that I wanted to ask about, which is… we created this a while ago, but is there anything else we’re missing in Polyatomic, like, other data sources?
347 00:31:56.250 ⇒ 00:31:59.380 Uttam Kumaran: that we should… Consider bringing in.
348 00:31:59.780 ⇒ 00:32:10.130 Emily Giant: Yeah, I wanna say FedEx. Like, is there… a FedEx API that is… I mean, we do.
349 00:32:10.130 ⇒ 00:32:10.920 Uttam Kumaran: Do we have a, do we have a.
350 00:32:10.920 ⇒ 00:32:11.480 Emily Giant: of data into.
351 00:32:11.480 ⇒ 00:32:11.799 Uttam Kumaran: We have a…
352 00:32:11.800 ⇒ 00:32:12.780 Emily Giant: bye, so…
353 00:32:12.780 ⇒ 00:32:14.639 Uttam Kumaran: Okay. Do we have a contact there?
354 00:32:15.760 ⇒ 00:32:18.499 Emily Giant: We do. His name’s Mark with a Q.
355 00:32:19.700 ⇒ 00:32:25.870 Uttam Kumaran: Yeah, I’ve used… I’ve done some stuff with FedEx Data, it was…
356 00:32:26.030 ⇒ 00:32:30.760 Uttam Kumaran: Mail, though. They would email us CSVs, and we would pipe that in.
357 00:32:31.200 ⇒ 00:32:31.660 Emily Giant: Yeah.
358 00:32:31.660 ⇒ 00:32:32.130 Uttam Kumaran: So…
359 00:32:32.130 ⇒ 00:32:35.559 Emily Giant: Most of it’s, like, yeah, the FedEx cost. Like.
360 00:32:35.560 ⇒ 00:32:36.070 Uttam Kumaran: Yeah, yeah, yeah.
361 00:32:36.070 ⇒ 00:32:46.969 Emily Giant: Yeah, yeah, you got me. Because right now, I don’t think… we have, like, shipping revenue, and we get tracking numbers, yada yada, but we don’t get any FedEx costs, and I know that the, like…
362 00:32:47.110 ⇒ 00:32:52.410 Emily Giant: The process of… Accounting for that is always delayed and manual.
363 00:32:53.750 ⇒ 00:32:56.799 Emily Giant: Or any of our… shipping providers.
364 00:32:58.660 ⇒ 00:33:01.250 Emily Giant: But that also is something that might be happening.
365 00:33:02.090 ⇒ 00:33:03.819 Emily Giant: With the,
366 00:33:04.360 ⇒ 00:33:10.959 Emily Giant: all of our accounting is moving into NetSuite, so Polytomic would need to build out those tables in the future.
367 00:33:13.660 ⇒ 00:33:14.600 Uttam Kumaran: Hmm, okay.
368 00:33:14.710 ⇒ 00:33:19.370 Uttam Kumaran: So if you have this guy’s… email, then yeah.
369 00:33:19.370 ⇒ 00:33:19.730 Emily Giant: you know.
370 00:33:19.730 ⇒ 00:33:22.909 Uttam Kumaran: You could totally email him. We’ve done this before for a client, so…
371 00:33:22.910 ⇒ 00:33:23.540 Emily Giant: Okay.
372 00:33:23.860 ⇒ 00:33:26.140 Uttam Kumaran: Yeah. So I know, basically, you get a…
373 00:33:26.380 ⇒ 00:33:34.070 Uttam Kumaran: We’d have to tie it to the order, and then you’ll get all… you’ll get everything about, like, additional handling fees, the cost, the weight, the zone, all that.
374 00:33:35.090 ⇒ 00:33:37.369 Emily Giant: Yeah, that would be… clutch.
375 00:33:38.810 ⇒ 00:33:40.409 Uttam Kumaran: Is this, like, a low?
376 00:33:40.800 ⇒ 00:33:41.130 Emily Giant: Hello!
377 00:33:41.130 ⇒ 00:33:41.800 Uttam Kumaran: DM.
378 00:33:42.110 ⇒ 00:33:42.979 Emily Giant: So it’s good.
379 00:33:47.400 ⇒ 00:33:49.530 Uttam Kumaran: Right. Okay.
380 00:33:50.230 ⇒ 00:33:55.590 Uttam Kumaran: Yeah, I guess one thing that I could potentially help with, too, is, like.
381 00:33:56.100 ⇒ 00:34:02.950 Uttam Kumaran: is, like, Looker errors, is that… you think that’s worth, like… Taking a crack at.
382 00:34:06.090 ⇒ 00:34:17.089 Emily Giant: Not right now. Okay. I think once we’ve built all of the new models and people are using them, then we can just slash and burn. And it might be easier to slash and burn once we have…
383 00:34:17.209 ⇒ 00:34:20.759 Emily Giant: had, like, an adoption rate, because I think people are still…
384 00:34:21.219 ⇒ 00:34:26.049 Emily Giant: Under the assumption that some of this stuff that doesn’t work does, and I’d rather rock the boat once.
385 00:34:26.049 ⇒ 00:34:28.229 Uttam Kumaran: And majorly, then 50 times.
386 00:34:29.389 ⇒ 00:34:31.319 Uttam Kumaran: Okay, okay, okay, fair.
387 00:34:31.829 ⇒ 00:34:34.159 Uttam Kumaran: Okay, great.
388 00:34:34.639 ⇒ 00:34:40.939 Uttam Kumaran: So, otherwise, I feel pretty good. I think there’s just gonna be a lot riding on, like.
389 00:34:41.199 ⇒ 00:34:44.669 Uttam Kumaran: getting this QA’d, and then making the changes in Looker.
390 00:34:45.369 ⇒ 00:34:50.679 Uttam Kumaran: So, anything else we need to cover here?
391 00:34:51.679 ⇒ 00:34:57.449 Emily Giant: I don’t think so, but one thing I want to flag is historical revenue, and making sure that, like.
392 00:34:57.859 ⇒ 00:35:05.709 Emily Giant: Anything that we can clean up on that front prior to 11-6-24 is also part of the revenue marked.
393 00:35:17.040 ⇒ 00:35:18.740 Uttam Kumaran: What was the data again?
394 00:35:19.090 ⇒ 00:35:20.250 Emily Giant: 11, 6…
395 00:35:20.440 ⇒ 00:35:21.080 Demilade Agboola: Wonderful.
396 00:35:21.080 ⇒ 00:35:22.630 Emily Giant: 24. Yep.
397 00:35:24.060 ⇒ 00:35:27.089 Uttam Kumaran: And so, right now, the current FACT transaction…
398 00:35:30.820 ⇒ 00:35:37.619 Demilade Agboola: So the flex orders really starts from 11624, because that’s when that’s when the market said to Shopify.
399 00:35:37.870 ⇒ 00:35:40.130 Demilade Agboola: Social provider data starts from that point.
400 00:35:44.010 ⇒ 00:35:47.550 Demilade Agboola: Prior to that, we’ll need to rely on, like, the OMS data.
401 00:35:47.890 ⇒ 00:35:48.820 Emily Giant: Fully.
402 00:35:56.530 ⇒ 00:36:02.879 Demilade Agboola: But it’s part of what they have done, but, you know, revenue has been a tricky spot.
403 00:36:03.030 ⇒ 00:36:04.100 Demilade Agboola: Previously, so…
404 00:36:08.170 ⇒ 00:36:10.709 Emily Giant: I mean, once we’re not… once we don’t have to use
405 00:36:11.100 ⇒ 00:36:19.569 Emily Giant: Tableau Items XF, there won’t be as much risk of messing with the historical revenue models, because it won’t break anything that’s, like, being used.
406 00:36:20.270 ⇒ 00:36:23.120 Emily Giant: And that’s been our big…
407 00:36:24.070 ⇒ 00:36:29.170 Emily Giant: I think it’s been a blocker for any kind of significant changes in the historicals.
408 00:36:52.960 ⇒ 00:36:53.690 Uttam Kumaran: Okay.
409 00:36:55.210 ⇒ 00:37:00.010 Uttam Kumaran: And then, I, I put a note, we just need the scenarios for these.
410 00:37:01.460 ⇒ 00:37:01.930 Emily Giant: Okay.
411 00:37:03.340 ⇒ 00:37:17.160 Uttam Kumaran: ideally, kind of the way I would like to do this is we just have the scenarios, and even the best ways to, like, create a Looker dashboard with, like, here’s an example row, and, like, we just put text above it, which is, like, here’s what happened there.
412 00:37:17.360 ⇒ 00:37:18.060 Uttam Kumaran: And, like.
413 00:37:18.060 ⇒ 00:37:18.770 Emily Giant: Yeah.
414 00:37:18.770 ⇒ 00:37:22.049 Uttam Kumaran: That’s a good way to just show all the different scenarios for subscriptions.
415 00:37:22.350 ⇒ 00:37:26.360 Uttam Kumaran: Let me know if I… we can do 30 minutes to, like, do… to, like, get this…
416 00:37:27.620 ⇒ 00:37:29.230 Emily Giant: Yeah, I thought that I.
417 00:37:29.230 ⇒ 00:37:29.750 Uttam Kumaran: given.
418 00:37:31.030 ⇒ 00:37:33.449 Uttam Kumaran: I thought I had sent her a couple dashboards.
419 00:37:33.450 ⇒ 00:37:36.320 Emily Giant: To use as a proxy.
420 00:37:36.720 ⇒ 00:37:37.160 Uttam Kumaran: Yes. Okay.
421 00:37:37.160 ⇒ 00:37:45.840 Emily Giant: Let me find those right now, because that’s how I would QA with stakeholders, is, just plugging the new data in.
422 00:37:45.950 ⇒ 00:37:49.190 Emily Giant: And seeing how it compares and contrasts to, like.
423 00:37:49.390 ⇒ 00:37:52.009 Emily Giant: The old dashboards that they used to use.
424 00:37:54.420 ⇒ 00:37:55.010 Uttam Kumaran: Okay.
425 00:38:01.550 ⇒ 00:38:02.790 Emily Giant: Here’s one.
426 00:38:04.240 ⇒ 00:38:09.100 Emily Giant: So, I think a big one will be the future-looking subscriptions.
427 00:38:09.270 ⇒ 00:38:16.950 Emily Giant: So that’s… This is the forecast by day, but we should be able to do forecasts further in.
428 00:38:17.350 ⇒ 00:38:19.900 Emily Giant: to the future than that. This one…
429 00:38:47.280 ⇒ 00:38:48.390 Emily Giant: another…
430 00:38:53.910 ⇒ 00:39:01.240 Emily Giant: So those are two good starting points for… What has been lost in… The switch of subscription programs.
431 00:39:03.160 ⇒ 00:39:04.280 Uttam Kumaran: Okay…
432 00:39:09.480 ⇒ 00:39:19.610 Uttam Kumaran: Okay, cool, so let me… I’ll finish this… these requirements up, and then… Can slot this into… Next cycle.
433 00:39:23.130 ⇒ 00:39:32.690 Uttam Kumaran: Okay, cool, so I feel pretty good. I think we’ll have enough to work on for sure, and then a lot of the low prior work can move on, it’s fine.
434 00:39:32.840 ⇒ 00:39:38.299 Uttam Kumaran: And then, yeah, ideally, all of these that we are prioritizing for next cycle should be
435 00:39:39.040 ⇒ 00:39:43.409 Uttam Kumaran: basically high priority, so I’m gonna move all these to high.
436 00:39:44.990 ⇒ 00:39:51.189 Uttam Kumaran: And then we’ll start to peel off the additional high ones, and then…
437 00:39:51.500 ⇒ 00:39:54.250 Uttam Kumaran: This one is going to be… this one’s urgent.
438 00:39:54.780 ⇒ 00:40:00.940 Uttam Kumaran: And then… Yeah, this one should probably be the only one that kind of moves in from
439 00:40:01.270 ⇒ 00:40:08.120 Uttam Kumaran: Still needs crop grooming, so… Okay, cool. Anything else?
440 00:40:09.070 ⇒ 00:40:10.170 Uttam Kumaran: This week?
441 00:40:12.950 ⇒ 00:40:13.999 Emily Giant: I don’t think so.
442 00:40:14.960 ⇒ 00:40:20.090 Uttam Kumaran: Yeah, so we should have the first touch, last touch stuff in… Dune…
443 00:40:20.290 ⇒ 00:40:24.850 Uttam Kumaran: And then, I know we’ve been… I removed some tickets that were about, like, dbt…
444 00:40:24.990 ⇒ 00:40:33.150 Uttam Kumaran: job cleanup, because we’ve been kind of doing that on a recurring basis. I think once we have these two marts, we can maybe do a week of, like, kind of cleanup stuff.
445 00:40:34.430 ⇒ 00:40:34.990 Emily Giant: Beautiful.
446 00:40:35.440 ⇒ 00:40:36.470 Uttam Kumaran: But, okay.
447 00:40:37.540 ⇒ 00:40:44.380 Uttam Kumaran: And then, yeah, we have the North Beam and, like, Shopify attribution that we can bring in now, so…
448 00:40:45.290 ⇒ 00:40:45.880 Emily Giant: Great.
449 00:40:46.930 ⇒ 00:40:47.560 Uttam Kumaran: Okay.
450 00:40:48.010 ⇒ 00:40:48.559 Emily Giant: Alright, cool.
451 00:40:48.560 ⇒ 00:40:50.290 Uttam Kumaran: Thank you, everyone. Appreciate the time.
452 00:40:50.890 ⇒ 00:40:52.540 Awaish Kumar: Thank you.
453 00:40:52.540 ⇒ 00:40:54.740 Uttam Kumaran: Okay See you soon. Bye.