Meeting Title: US | Ticket Grooming Date: 2025-09-30 Meeting participants: Emily Giant, Amber Lin
WEBVTT
1 00:00:04.740 ⇒ 00:00:05.510 Emily Giant: They’re so cute.
2 00:02:05.330 ⇒ 00:02:06.660 Amber Lin: Hi there!
3 00:02:07.760 ⇒ 00:02:09.020 Emily Giant: Hi, how are you?
4 00:02:09.160 ⇒ 00:02:12.130 Amber Lin: Oh, good. So sorry to grab you again.
5 00:02:12.130 ⇒ 00:02:18.690 Emily Giant: And so that you can see that I’m smiling, even though my voice sounds like I’m, like.
6 00:02:22.070 ⇒ 00:02:25.749 Amber Lin: Oh, I have to show you this shirt, I think you’ll like it.
7 00:02:25.750 ⇒ 00:02:28.029 Emily Giant: Oh my god, I love it so much.
8 00:02:30.010 ⇒ 00:02:31.539 Emily Giant: It’s awesome.
9 00:02:32.120 ⇒ 00:02:45.129 Amber Lin: Oh, man, I was just thinking… my cat was just right beside me. She gets, like, obsessed with me when I come back from a trip, because she thinks I’ve abandoned her. She was just, like, right here, like, rubbing me on my face. Oh, they’re so cute!
10 00:02:45.130 ⇒ 00:02:47.619 Emily Giant: Yeah, as soon as I pressed join, she was like, no.
11 00:02:47.620 ⇒ 00:02:48.400 Amber Lin: Excellent.
12 00:02:48.400 ⇒ 00:02:51.040 Emily Giant: But yeah, that shirt is awesome.
13 00:02:52.890 ⇒ 00:03:02.769 Amber Lin: Yeah, I… Mostly I panicked, because I met with Utam and Awash and Demlade, and Utam was gonna hand off some tasks to Awash.
14 00:03:03.390 ⇒ 00:03:12.039 Amber Lin: And he was like, none of these have requirements. Why don’t these have requirements? I was like, I don’t know, they just don’t have requirements, I’m sorry.
15 00:03:12.040 ⇒ 00:03:29.460 Emily Giant: It’s totally fine. I’m glad we’re doing this. I think, like, the… I think the break was a good time for me. Like, I was just so busy to, like, take a step back and be like, okay, we have 2 months left in our, like, contract, like, what can we focus on and, like, knock out in that time? I’m…
16 00:03:29.670 ⇒ 00:03:49.450 Emily Giant: currently working on, like, anything that Demolade has that’s been deployed in the fact marks, I’m just adding it to Looker, I’m almost done, just so that, like, once I get an idea of what he had in mind for this, that we can just go. Like, I think my disconnect was that, like.
17 00:03:49.810 ⇒ 00:03:55.219 Emily Giant: I don’t completely understand what the new deployments are replacing.
18 00:03:55.280 ⇒ 00:04:13.309 Emily Giant: And because they only start at 11-7-20-24, I need to know exactly what it is meant to replace so that I can make that historical replica, and then, like, blend them all together. I don’t think it’ll be very hard, and I don’t expect
19 00:04:13.700 ⇒ 00:04:26.269 Emily Giant: Brainforge to do any of the historical stuff, unless it’s, like, super difficult and becomes a blocker, but I think just, like, getting on the same page with, like, okay, fact order lines is meant to replace OMS suborders.
20 00:04:26.270 ⇒ 00:04:27.150 Amber Lin: Great.
21 00:04:27.150 ⇒ 00:04:28.650 Emily Giant: and then I can see, like.
22 00:04:29.450 ⇒ 00:04:41.270 Emily Giant: if there’s still elements missing from the dashboards, going back in and saying, hey, this is usable, but it’s not done. Like, we need to do XYZ. But right now, I’m just still, like.
23 00:04:41.580 ⇒ 00:04:42.549 Emily Giant: I don’t know.
24 00:04:42.670 ⇒ 00:04:46.039 Emily Giant: I don’t know what these tables are. I know, like.
25 00:04:46.310 ⇒ 00:04:53.240 Emily Giant: personally, how I would use them, but, I didn’t know if there was, like, a more specific target…
26 00:04:53.450 ⇒ 00:04:58.199 Emily Giant: Like, need from the stakeholders that they’re targeting with the individual tables.
27 00:04:59.020 ⇒ 00:04:59.730 Amber Lin: Yeah.
28 00:05:00.620 ⇒ 00:05:06.119 Amber Lin: I unfortunately cannot help you with that. I think the Miladi will be able to help.
29 00:05:06.120 ⇒ 00:05:11.200 Emily Giant: I think we’ll knock it out in a half hour tomorrow morning. I think he’ll be able to, like.
30 00:05:11.460 ⇒ 00:05:19.140 Emily Giant: just show me, and that way I’ll have a better idea. But let’s definitely groom these tickets a little bit more, especially… I don’t know a waysh,
31 00:05:19.260 ⇒ 00:05:21.340 Emily Giant: New person jumping in to help?
32 00:05:21.550 ⇒ 00:05:45.099 Amber Lin: Yeah, Awish is a tech lead on our team, so he’s the most senior engineer we have apart from Utam, so he does data engineering and does analytic engineering, so he does all of it, it just… Utem has less and less time, and we don’t… things get dropped here, so we just looped Awish in to say, hey, can you help here? I’ll introduce him in a bit, and then there’s a few access items I would need for him.
33 00:05:45.430 ⇒ 00:05:46.250 Emily Giant: Cool, yeah.
34 00:05:46.250 ⇒ 00:05:57.200 Amber Lin: But I just want to go through some tickets. As you can see, most of them have zero descriptions. Like this one, like, I don’t… I remember we…
35 00:05:57.200 ⇒ 00:05:57.600 Emily Giant: Yeah.
36 00:05:57.600 ⇒ 00:05:59.199 Amber Lin: We created this, but…
37 00:05:59.670 ⇒ 00:06:06.210 Amber Lin: we don’t know what the end deliverable is, like, what… what are we trying to do?
38 00:06:06.210 ⇒ 00:06:23.219 Emily Giant: do. So, this is great. Okay, including categories, bundle, individual product, free gifts. So, this is all part of fulfillment line items in Shopify. So, I would say, firstly, this ask relates to revenue.
39 00:06:24.220 ⇒ 00:06:28.180 Emily Giant: As revenue relates to items that are bundled.
40 00:06:29.830 ⇒ 00:06:37.320 Emily Giant: So, right now, the team uses, Components XF.
41 00:06:39.080 ⇒ 00:06:48.990 Emily Giant: And ComponentsXF is… Unable to… Correctly calculate revenue for…
42 00:06:49.410 ⇒ 00:06:53.469 Emily Giant: Bundled line items that received a forced upgrade.
43 00:06:54.200 ⇒ 00:06:59.700 Emily Giant: So, what this is specifically asking is, what Shopify table
44 00:06:59.990 ⇒ 00:07:07.939 Emily Giant: is replacing component… complaining the lineage of components XF, because it’s a very complicated one.
45 00:07:08.250 ⇒ 00:07:10.829 Emily Giant: And we do know that that is…
46 00:07:11.070 ⇒ 00:07:21.060 Emily Giant: the Shopify fulfillments tables. I have a PR right now for those, but what Demolati needs to do is incorporate
47 00:07:21.250 ⇒ 00:07:25.370 Emily Giant: the… logic that splits
48 00:07:25.620 ⇒ 00:07:33.029 Emily Giant: the portion of related revenue to the individual elements of the kit. So, for example, like.
49 00:07:33.370 ⇒ 00:07:35.930 Emily Giant: There’s an entire table that takes
50 00:07:36.140 ⇒ 00:07:42.429 Emily Giant: a SKU that’s a candle, a bouquet, and a vase, and it assigns based on
51 00:07:42.850 ⇒ 00:07:53.100 Emily Giant: the original cost of those items assigns a percentage of the bundle price that that item would take up. So, even though the
52 00:07:53.750 ⇒ 00:07:57.230 Emily Giant: Typical retail price of the firecracker is $150.
53 00:07:57.690 ⇒ 00:08:08.459 Emily Giant: maybe the whole bundle is $150, and we don’t count revenue that way. If it’s a bundle, we actually, like, only use the percentage of the bundle that the firecracker is. So if the…
54 00:08:08.740 ⇒ 00:08:12.069 Emily Giant: If separately not sold together, the candle’s 40,
55 00:08:12.390 ⇒ 00:08:21.539 Emily Giant: The bouquet’s 10. What it does is it takes the total cost of the bundle, which might be $125, and says.
56 00:08:21.890 ⇒ 00:08:26.159 Emily Giant: This is the weight of percentage of the revenue.
57 00:08:26.520 ⇒ 00:08:33.549 Emily Giant: gained in this… Bundle. So, the bouquet gets 80%, the candle gets…
58 00:08:34.309 ⇒ 00:08:37.609 Emily Giant: 15%, the vase gets 5. So…
59 00:08:37.730 ⇒ 00:08:43.679 Emily Giant: we need this new table based on Shopify items, so that we can correctly
60 00:08:44.620 ⇒ 00:08:53.349 Emily Giant: There’s a whole lot to this one, and it’s only a piece of a bigger picture, because this is the one that, like, we’re also building, like, does the order have a forced upgrade?
61 00:08:53.890 ⇒ 00:08:57.789 Emily Giant: It wasn’t sent as, a completed
62 00:08:58.240 ⇒ 00:09:04.990 Emily Giant: unit, or, like, was the kit broken, or did it send as a complete kit? So I think this is just that portion.
63 00:09:05.320 ⇒ 00:09:12.090 Emily Giant: Of, like, breaking out, how kitted revenue relates
64 00:09:12.810 ⇒ 00:09:17.889 Emily Giant: To, like, in the bigger picture of, like, if they were ordered separately versus a discounted price.
65 00:09:18.710 ⇒ 00:09:27.289 Emily Giant: And I can write that up, too, since that was a whole lot of words. Yes, I’m trying to understand.
66 00:09:27.290 ⇒ 00:09:28.470 Amber Lin: Yeah.
67 00:09:28.670 ⇒ 00:09:29.520 Emily Giant: Okay.
68 00:09:30.550 ⇒ 00:09:34.469 Emily Giant: So, let me find that ticket. It’s number 323.
69 00:09:34.470 ⇒ 00:09:35.080 Amber Lin: Yeah.
70 00:09:35.080 ⇒ 00:09:38.850 Emily Giant: I feel so bad for anyone that has to listen to my voice today. I… I can’t…
71 00:09:38.850 ⇒ 00:09:39.280 Amber Lin: Barely.
72 00:09:39.280 ⇒ 00:09:40.520 Emily Giant: You can listen to it, so…
73 00:09:46.780 ⇒ 00:09:48.600 Emily Giant: Read 23… okay.
74 00:09:52.320 ⇒ 00:09:55.870 Emily Giant: Alright, I’m just gonna put, like, a… do you want me to do a comment?
75 00:09:56.180 ⇒ 00:09:57.110 Emily Giant: And then you can…
76 00:09:57.110 ⇒ 00:10:03.409 Amber Lin: You can just edit in the main part, because this is, like, what I wrote, I also don’t understand.
77 00:10:03.560 ⇒ 00:10:08.290 Emily Giant: Yeah, no, it was a whole lot of nonsense, with a broken voice, so…
78 00:10:08.440 ⇒ 00:10:10.570 Emily Giant: I’ll just add up some notes up here.
79 00:10:30.260 ⇒ 00:10:32.459 Emily Giant: Oh no, oh, sorry, my cat’s barfing.
80 00:10:32.630 ⇒ 00:10:33.950 Emily Giant: Oh, sissy.
81 00:10:34.820 ⇒ 00:10:37.750 Emily Giant: Oh… Hold on, I’ll be right back.
82 00:10:37.750 ⇒ 00:10:38.939 Amber Lin: Shaya, go ahead.
83 00:10:38.940 ⇒ 00:10:40.389 Emily Giant: Oh, baby, you’re okay.
84 00:10:40.540 ⇒ 00:10:41.420 Emily Giant: Intact.
85 00:10:42.880 ⇒ 00:10:43.790 Emily Giant: Good girl.
86 00:10:43.990 ⇒ 00:10:45.220 Emily Giant: Oh, yeah.
87 00:10:45.890 ⇒ 00:10:47.759 Emily Giant: Good girl. Oh, man.
88 00:10:50.160 ⇒ 00:10:51.720 Emily Giant: Giant hairball.
89 00:10:52.700 ⇒ 00:10:57.070 Emily Giant: She’s just not been able to go outside and eat grass, because she’s been stuck at…
90 00:10:57.930 ⇒ 00:10:59.509 Emily Giant: She’s doing it again.
91 00:10:59.750 ⇒ 00:11:03.250 Emily Giant: I’m so sorry, this is a lot of drama. One second.
92 00:11:04.710 ⇒ 00:11:07.909 Emily Giant: You got it, you got it. Good girl, good girl.
93 00:11:08.440 ⇒ 00:11:09.880 Emily Giant: Oh, how many?
94 00:11:11.190 ⇒ 00:11:12.050 Emily Giant: You’re welcome.
95 00:11:15.710 ⇒ 00:11:17.120 Emily Giant: Okay.
96 00:11:18.420 ⇒ 00:11:20.170 Emily Giant: Alright, sick.
97 00:11:20.960 ⇒ 00:11:28.490 Emily Giant: Okay, so I wrote, this ticket is related to the need to be able to break out the percentage of weight.
98 00:11:28.680 ⇒ 00:11:32.480 Emily Giant: That an item… in a bundle.
99 00:11:32.690 ⇒ 00:11:33.690 Emily Giant: has.
100 00:11:34.300 ⇒ 00:11:40.249 Emily Giant: Or the percentage of… The whole bundle.
101 00:11:41.900 ⇒ 00:11:48.079 Emily Giant: That an individual Item within the bundle.
102 00:11:50.360 ⇒ 00:11:52.709 Emily Giant: Should be assigned.
103 00:11:54.350 ⇒ 00:12:04.330 Emily Giant: The original logic for this… is in OMS Comp XF.
104 00:12:05.110 ⇒ 00:12:06.090 Emily Giant: Base.
105 00:12:07.280 ⇒ 00:12:14.410 Emily Giant: You can see… Okay, that’s earth convex half-base.
106 00:12:16.830 ⇒ 00:12:23.369 Emily Giant: We do not use the individual…
107 00:12:26.770 ⇒ 00:12:28.320 Emily Giant: Products revenue.
108 00:12:29.670 ⇒ 00:12:33.850 Emily Giant: When it is sold, As part of a kit.
109 00:12:36.830 ⇒ 00:12:46.790 Emily Giant: Instead, we use the… Instead, we take… the price…
110 00:12:51.640 ⇒ 00:13:01.570 Emily Giant: of… the individual… item… And… Use it to wait.
111 00:13:03.040 ⇒ 00:13:09.840 Emily Giant: What portion… Of the kit revenue, Which…
112 00:13:09.950 ⇒ 00:13:12.860 Emily Giant: Will be less than the total.
113 00:13:12.960 ⇒ 00:13:14.779 Emily Giant: Of the individual products.
114 00:13:19.290 ⇒ 00:13:24.339 Emily Giant: And then I would just use AI to make sense of this, because they might still be like.
115 00:13:24.480 ⇒ 00:13:28.059 Emily Giant: I think Demolati will understand, though.
116 00:13:29.410 ⇒ 00:13:39.890 Amber Lin: We are trying to get a way to help with this, is… do you know what the… what is the end deliverable? Is it a logic that needs to be added in?
117 00:13:39.890 ⇒ 00:13:43.640 Emily Giant: Yes, and deliverable is… I’ll write that in.
118 00:13:45.660 ⇒ 00:13:50.899 Emily Giant: That in final… Revenue table.
119 00:13:56.390 ⇒ 00:14:01.400 Emily Giant: the correct… amount of revenue.
120 00:14:01.550 ⇒ 00:14:03.100 Emily Giant: is assigned.
121 00:14:04.280 ⇒ 00:14:07.529 Emily Giant: To each element of the kit.
122 00:14:09.190 ⇒ 00:14:14.210 Emily Giant: if… the product… was replaced.
123 00:14:16.860 ⇒ 00:14:20.249 Emily Giant: AKA, a forced upgrade.
124 00:14:22.990 ⇒ 00:14:24.470 Emily Giant: This item?
125 00:14:25.830 ⇒ 00:14:26.990 Emily Giant: should…
126 00:14:28.020 ⇒ 00:14:36.819 Emily Giant: Okay, this is where I probably need to talk to Awash, because, like, Utam and I have talked about this a lot of times, and I think we want to do it both ways, but,
127 00:14:39.460 ⇒ 00:14:44.710 Emily Giant: The item that actually received revenue?
128 00:14:45.080 ⇒ 00:14:49.379 Emily Giant: Say, like, we did a forced upgrade, so they ordered sunflowers, we sent them roses.
129 00:14:49.680 ⇒ 00:15:01.150 Emily Giant: I don’t necessarily… I want them to be able, stakeholders, to be able to say what items or what the customer ordered online versus what did they receive. And then…
130 00:15:02.110 ⇒ 00:15:06.220 Emily Giant: If they’re running a query about bundles and kits.
131 00:15:06.240 ⇒ 00:15:09.780 Amber Lin: what earned money, I want them to be able to see.
132 00:15:09.780 ⇒ 00:15:14.270 Emily Giant: That, like… The sunflowers were what earned the money.
133 00:15:14.680 ⇒ 00:15:15.710 Emily Giant: But…
134 00:15:15.710 ⇒ 00:15:34.849 Emily Giant: that the roses were what was sent, and that the kit was broken. So there should be the ability to say, what did people order versus what did people receive, and that information needs to be able to be tied together, because we’re missing that right now, and I think it has a lot to do with churn, like, that is influencing churn. When people don’t get what they need.
135 00:15:34.850 ⇒ 00:15:39.220 Emily Giant: or what they ordered or originally wanted. It’s like if you ordered a top and somebody sent you pants.
136 00:15:39.360 ⇒ 00:15:43.459 Emily Giant: And they were like, we didn’t have the jobs, here’s something else. Like, I think I’d be miffed.
137 00:15:43.460 ⇒ 00:15:43.950 Amber Lin: Hmm.
138 00:15:43.950 ⇒ 00:15:44.810 Emily Giant: So, this is…
139 00:15:44.810 ⇒ 00:15:46.469 Amber Lin: That could be a different ticket.
140 00:15:47.090 ⇒ 00:15:54.330 Emily Giant: Yes, but this is a piece of that. It’s that right now, we are not able to do that with the current structure of the table.
141 00:15:55.240 ⇒ 00:15:57.250 Emily Giant: Demolati does know this.
142 00:15:57.430 ⇒ 00:15:59.930 Emily Giant: And I’m wondering if…
143 00:16:00.210 ⇒ 00:16:08.510 Emily Giant: Awash would be better suited to, like, build out subscriptions than to do this, when Demolade’s already super familiar with this
144 00:16:08.770 ⇒ 00:16:13.210 Emily Giant: shitshow. Like, this is the craziest part of any…
145 00:16:13.210 ⇒ 00:16:15.900 Amber Lin: Urban STEMS, thing that…
146 00:16:15.900 ⇒ 00:16:22.910 Emily Giant: Other businesses don’t necessarily have as an issue, because they usually just cancel an order if they don’t have what you want.
147 00:16:29.950 ⇒ 00:16:33.089 Emily Giant: So, including categories in DIM product.
148 00:16:36.410 ⇒ 00:16:38.690 Amber Lin: So, what would the…
149 00:16:38.690 ⇒ 00:16:43.020 Emily Giant: So, you know what, I wouldn’t even say… I wouldn’t even… call this ticket.
150 00:16:43.330 ⇒ 00:16:55.010 Emily Giant: this. I think it should just be, like, 86. Like, don’t do this one. Because the other logic has to be captured in the Mart thing, and that’s what I think this is meant to be.
151 00:16:56.010 ⇒ 00:17:02.709 Emily Giant: This, this does not need to be part of your work, I don’t think.
152 00:17:02.820 ⇒ 00:17:08.880 Emily Giant: So, sorry for all of that, just to say, I think we should capture this in a different ticket and leave DIM products alone.
153 00:17:09.099 ⇒ 00:17:18.059 Amber Lin: All good. So let’s… let’s say, you said there was a ticket that you wanted us to do to make sure that what they order and what they get is cashed.
154 00:17:18.710 ⇒ 00:17:20.099 Amber Lin: Something we need to do, right?
155 00:17:20.109 ⇒ 00:17:24.479 Emily Giant: Yes, let’s see, in issues… it should already exist.
156 00:17:25.619 ⇒ 00:17:27.210 Amber Lin: What would that be?
157 00:17:27.430 ⇒ 00:17:29.799 Emily Giant: I’m looking… Oh, no.
158 00:17:35.720 ⇒ 00:17:42.760 Emily Giant: It’s gotta be in revenue, so if I go to all issues, Can I filter for revenue?
159 00:17:43.530 ⇒ 00:17:47.189 Amber Lin: Yeah, you can go into Projects and click on Revenue.
160 00:17:47.190 ⇒ 00:17:47.970 Emily Giant: Great.
161 00:17:50.370 ⇒ 00:17:55.349 Amber Lin: So you’re saying this DIM products, it wouldn’t be Brainforge work, it would be for you guys?
162 00:17:55.350 ⇒ 00:17:57.859 Emily Giant: It doesn’t need to be. As long as,
163 00:17:58.590 ⇒ 00:18:08.320 Emily Giant: as long as Demolati’s able to set up the revenue tables, on Shopify information, I’ll be able to connect it from there.
164 00:18:08.530 ⇒ 00:18:09.250 Amber Lin: Okay.
165 00:18:10.130 ⇒ 00:18:11.800 Emily Giant: I think some of, like, the more…
166 00:18:11.920 ⇒ 00:18:17.259 Emily Giant: difficult logic is what I need help with at the end of the day. And I can take…
167 00:18:18.180 ⇒ 00:18:38.139 Emily Giant: this is kind of a separate conversation from grooming, but I think going forward, I will take any ad hoc ticket, unless I’m like, Utam, Demolade, I need your help. And that way, it frees up all of their time to just focus on, like, what we’re trying to get through, and I know that was impossible last week when I was gone, but,
168 00:18:38.270 ⇒ 00:18:45.389 Emily Giant: Just going forward, I’m happy to take those tickets and leave my sprints a little lighter in anticipation of needing to, like, pick up that slack.
169 00:18:45.600 ⇒ 00:18:46.679 Amber Lin: Gotcha, okay.
170 00:18:50.170 ⇒ 00:18:59.650 Emily Giant: incremental strategy. Okay, I’m seeing 211, this is looking like a thing. To improve performance at… no, that’s just incremental strategy.
171 00:19:00.420 ⇒ 00:19:08.129 Emily Giant: Build int split line item strikethrough. That’s… that’s what it is. Everything I just explained is in 282.
172 00:19:08.720 ⇒ 00:19:10.020 Amber Lin: Absolutely.
173 00:19:10.330 ⇒ 00:19:13.020 Amber Lin: 282…
174 00:19:21.150 ⇒ 00:19:24.599 Emily Giant: And it’s already assigned to Demolade, so…
175 00:19:24.700 ⇒ 00:19:25.720 Amber Lin: Sounds great.
176 00:19:34.780 ⇒ 00:19:35.660 Amber Lin: T.
177 00:19:38.290 ⇒ 00:19:48.950 Emily Giant: But I would say that’s, like, one of the most important models for he and I to be, like, in communication about how it works, because it’s such a mess.
178 00:19:50.530 ⇒ 00:19:56.679 Amber Lin: Yeah, so for… Let’s see, for this one…
179 00:20:01.770 ⇒ 00:20:08.770 Amber Lin: Like, I… which part of this overlaps with the ticket we were just talking about?
180 00:20:10.460 ⇒ 00:20:18.310 Emily Giant: none of it needs to. I think that it’s actually confusing to have that ticket open, because it could accidentally cause
181 00:20:18.560 ⇒ 00:20:27.679 Emily Giant: overlap, and we can just literally delete that ticket. I won’t forget that we need to add categories to,
182 00:20:28.610 ⇒ 00:20:30.650 Emily Giant: to the pro- the DIM products.
183 00:20:31.070 ⇒ 00:20:36.669 Amber Lin: Okay, so this one, I feel like these are not accurate.
184 00:20:38.650 ⇒ 00:20:42.540 Amber Lin: Is this still the valid, the right business question?
185 00:20:44.040 ⇒ 00:20:45.800 Emily Giant: Yeah, to a degree.
186 00:20:45.920 ⇒ 00:20:50.500 Emily Giant: Which kits are broken or replaced, and how does that affect SKU level reporting?
187 00:20:50.900 ⇒ 00:20:53.059 Emily Giant: Yeah, that’s definitely one of them.
188 00:20:53.340 ⇒ 00:20:59.379 Emily Giant: Not really how does it affect SKU-level reporting, but how does that affect, I would say, turnover?
189 00:20:59.580 ⇒ 00:21:02.880 Emily Giant: Or, like, customer churn. Sorry, not turnover, customer churn.
190 00:21:05.130 ⇒ 00:21:11.369 Emily Giant: and inventory planning, which I guess is SKU-level reporting, but yeah.
191 00:21:11.370 ⇒ 00:21:12.670 Amber Lin: This is more straightforward.
192 00:21:12.670 ⇒ 00:21:13.600 Emily Giant: Yeah, totally.
193 00:21:13.600 ⇒ 00:21:19.640 Amber Lin: So this is essentially… this is the context of… they don’t… people don’t get what they order.
194 00:21:19.640 ⇒ 00:21:20.390 Emily Giant: Correct.
195 00:21:24.720 ⇒ 00:21:25.620 Amber Lin: All right.
196 00:21:25.730 ⇒ 00:21:27.380 Amber Lin: And then…
197 00:21:27.380 ⇒ 00:21:35.099 Emily Giant: And the current model… here, let me write in the current model that it’s… the logic is based in. I think that will be helpful for him to see.
198 00:21:35.840 ⇒ 00:21:36.660 Emily Giant: Mmm.
199 00:21:36.850 ⇒ 00:21:37.960 Emily Giant: Yep.
200 00:21:38.190 ⇒ 00:21:42.930 Emily Giant: Yep, he’s already got it all, actually. This is… pretty solid.
201 00:21:48.420 ⇒ 00:21:49.170 Emily Giant: Oh!
202 00:21:49.490 ⇒ 00:21:51.340 Emily Giant: I just wanted a little bit of code.
203 00:21:54.140 ⇒ 00:21:54.910 Emily Giant: Whatever.
204 00:21:59.230 ⇒ 00:22:00.910 Emily Giant: Alright, in…
205 00:22:04.370 ⇒ 00:22:09.369 Emily Giant: Logic is… Currently in OMS.
206 00:22:10.420 ⇒ 00:22:11.330 Emily Giant: Comp.
207 00:22:13.090 ⇒ 00:22:14.080 Emily Giant: XF.
208 00:22:14.240 ⇒ 00:22:15.190 Emily Giant: Base.
209 00:22:18.910 ⇒ 00:22:19.820 Emily Giant: I know.
210 00:22:23.250 ⇒ 00:22:24.949 Emily Giant: And upstream.
211 00:22:26.230 ⇒ 00:22:30.050 Emily Giant: tables… Include.
212 00:22:31.130 ⇒ 00:22:33.729 Emily Giant: Split line items.
213 00:22:34.700 ⇒ 00:22:44.240 Emily Giant: And… Components… These should ideally be replaced.
214 00:22:44.430 ⇒ 00:22:48.020 Emily Giant: with… the Shopify.
215 00:22:50.000 ⇒ 00:22:51.420 Emily Giant: fulfillment tables.
216 00:22:53.890 ⇒ 00:22:55.369 Emily Giant: I’ll add the PR.
217 00:22:56.530 ⇒ 00:22:59.179 Emily Giant: That these are gonna be based on.
218 00:23:13.870 ⇒ 00:23:16.619 Emily Giant: I’ve got jet lag bad, Amber.
219 00:23:18.490 ⇒ 00:23:21.510 Emily Giant: I, didn’t get back till 4am today.
220 00:23:21.740 ⇒ 00:23:25.090 Amber Lin: Oh, wow, you went straight back into work.
221 00:23:25.580 ⇒ 00:23:30.989 Emily Giant: Yeah, I didn’t mean to, our last flight got really funky.
222 00:23:31.230 ⇒ 00:23:31.990 Amber Lin: Hmm.
223 00:23:31.990 ⇒ 00:23:32.810 Emily Giant: So…
224 00:23:32.950 ⇒ 00:23:42.189 Emily Giant: Alas, we wound up not making our flight to Fort Wayne, where I live, and we had to drive from Detroit to Fort Wayne, like, at 10 o’clock at night.
225 00:23:42.190 ⇒ 00:23:42.870 Amber Lin: Oof.
226 00:23:42.870 ⇒ 00:23:43.690 Emily Giant: Yah.
227 00:23:45.940 ⇒ 00:23:46.880 Emily Giant: Okay.
228 00:24:01.510 ⇒ 00:24:09.210 Emily Giant: Okay, and then… PR… With… oh, we’re sorry, putting that in the wrong spot.
229 00:24:22.760 ⇒ 00:24:23.570 Emily Giant: Okay.
230 00:24:26.870 ⇒ 00:24:31.429 Emily Giant: So, Deliverable is a replacement for ComponentsXF in Looker.
231 00:24:36.890 ⇒ 00:24:42.460 Emily Giant: Or, actually, it’s called… component data.
232 00:24:42.730 ⇒ 00:24:44.810 Emily Giant: So, a replacement for…
233 00:24:48.620 ⇒ 00:24:54.870 Emily Giant: the component… Data Explorer in Looker.
234 00:24:57.040 ⇒ 00:24:59.910 Emily Giant: As well, well, yeah.
235 00:25:01.980 ⇒ 00:25:04.750 Emily Giant: That’s kind of, like, confusing, though, because…
236 00:25:05.210 ⇒ 00:25:11.119 Emily Giant: this is a very big ticket, so I guess what it would actually be is replacement for…
237 00:25:11.740 ⇒ 00:25:17.110 Emily Giant: If I look in dbt, It’d be for Components XF.
238 00:25:23.820 ⇒ 00:25:27.570 Emily Giant: And then… and… plus N.
239 00:25:27.720 ⇒ 00:25:28.870 Emily Giant: DBT.
240 00:25:39.660 ⇒ 00:25:41.040 Emily Giant: In DPT,
241 00:25:46.490 ⇒ 00:25:52.270 Emily Giant: Okay. Do you think that will make sense? There’s not very many downstream tables.
242 00:25:52.380 ⇒ 00:25:56.090 Emily Giant: of components XF, but I can write them in.
243 00:25:57.890 ⇒ 00:26:02.180 Amber Lin: Checking… Do you think…
244 00:26:02.420 ⇒ 00:26:09.640 Amber Lin: Someone other than the Milate would be able to take this task, or is this… is this too context-heavy?
245 00:26:09.640 ⇒ 00:26:10.980 Emily Giant: Yeah, no way.
246 00:26:11.520 ⇒ 00:26:12.580 Amber Lin: Okay.
247 00:26:14.110 ⇒ 00:26:19.060 Emily Giant: This is probably the only one that I think that’s the case, for what it’s worth.
248 00:26:19.560 ⇒ 00:26:22.089 Amber Lin: Huh. How many points do you think it would be?
249 00:26:23.980 ⇒ 00:26:25.190 Amber Lin: Well, how many hours?
250 00:26:30.460 ⇒ 00:26:32.890 Emily Giant: Probably 6 to 10?
251 00:26:34.430 ⇒ 00:26:38.669 Amber Lin: Okay, I’ll put 7 for now. Once the melody looks, you’ll have it.
252 00:26:38.990 ⇒ 00:26:40.389 Amber Lin: He’ll have an idea.
253 00:26:41.660 ⇒ 00:26:45.920 Amber Lin: Going back here…
254 00:26:52.820 ⇒ 00:27:01.680 Amber Lin: Is this the right… I guess this is enough context for this ticket, right?
255 00:27:03.100 ⇒ 00:27:05.810 Emily Giant: Let me see… Excuse me.
256 00:27:07.930 ⇒ 00:27:17.170 Emily Giant: Kind of. It’s probably enough context, but I think the deliverable is unclear, because there are many
257 00:27:18.460 ⇒ 00:27:34.260 Emily Giant: there are a lot of different promo category fields in Looker already, but they are making… They’re not necessarily based on that, and they’re incredibly inefficient and manual. Like, right now,
258 00:27:34.840 ⇒ 00:27:36.940 Emily Giant: There’s a promo category.
259 00:27:38.380 ⇒ 00:27:51.540 Emily Giant: field in Looker that’s, like, 800 lines long, because it’s all logic on, like, individual, I know, individual, like, auto-generated customer codes that come in.
260 00:27:52.140 ⇒ 00:27:57.909 Emily Giant: that needs to be replaced, and I can reference that in the ticket, like.
261 00:27:58.370 ⇒ 00:28:05.790 Emily Giant: That that should be a piece of, like, putting promo logic in a…
262 00:28:06.660 ⇒ 00:28:20.410 Emily Giant: non-manual, like, sustainable table that marketing isn’t Updating by hand, or updating… Based on their…
263 00:28:20.750 ⇒ 00:28:23.799 Emily Giant: what’s it called? Promotions and…
264 00:28:25.180 ⇒ 00:28:27.379 Emily Giant: Campaigns, that’s the word I’m looking for.
265 00:28:28.550 ⇒ 00:28:30.749 Emily Giant: And this could come from North Beam.
266 00:28:32.320 ⇒ 00:28:37.529 Emily Giant: That could, like, help to supplement this, but this is largely gonna come from Shopify data.
267 00:28:39.510 ⇒ 00:28:46.489 Amber Lin: I sent the link off of this ticket in the chat. I’m trying to put down what you said, but I bet I missed a few.
268 00:28:46.490 ⇒ 00:28:47.370 Emily Giant: Thank you again.
269 00:28:49.170 ⇒ 00:28:50.820 Emily Giant: I definitely think…
270 00:28:51.390 ⇒ 00:28:59.729 Emily Giant: that PK could QA this, but it would probably be way faster for, like, a wish or someone to do this.
271 00:29:00.450 ⇒ 00:29:11.819 Emily Giant: in dbt, because, like, he’s great with Looker, but he’s still learning dbt, and I’ll have to, like, probably, like, sidecar with him at first for all of his tasks, which is great, it’s fine, but,
272 00:29:12.700 ⇒ 00:29:21.419 Emily Giant: he’s gonna have a lot of insight on how to build this, or how they should be categorized, and where it… the logic lives in Looker right now, but…
273 00:29:21.770 ⇒ 00:29:29.489 Emily Giant: as far as, like, where to grab that from either Northbeam or Shopify, and how to identify, like.
274 00:29:29.950 ⇒ 00:29:39.030 Emily Giant: promos versus discounts. I don’t think I’ll know how to do that in the native tables yet, but I do think anyone could pop in and do it from Brainforge.
275 00:29:39.600 ⇒ 00:29:40.430 Amber Lin: Okay.
276 00:29:40.740 ⇒ 00:29:48.360 Amber Lin: Let’s see… Can we write this ticket out together?
277 00:29:48.360 ⇒ 00:29:48.960 Emily Giant: Yep.
278 00:29:49.820 ⇒ 00:29:52.939 Emily Giant: I think you have a meeting, though. I saw it pop up.
279 00:29:52.940 ⇒ 00:29:58.030 Amber Lin: I know, I told her that I can push this, it’s a one-on-one call, so…
280 00:29:58.030 ⇒ 00:30:07.940 Emily Giant: Okay, are you sure? Because I can write this up. If you need to hop to a meeting, I can go through some of these and, like, continue, or especially this one, to, like, groom it out so that…
281 00:30:08.050 ⇒ 00:30:10.459 Emily Giant: A new person would have whatever they need.
282 00:30:10.650 ⇒ 00:30:18.329 Amber Lin: Okay, actually, let’s just… let’s go through, and I’ll send you a list of tickets that needs grooming, and then you can also just…
283 00:30:18.860 ⇒ 00:30:25.350 Amber Lin: enter with voice, and then I can… I can clean them up. I just need context, I don’t… I don’t need to.
284 00:30:25.350 ⇒ 00:30:25.820 Emily Giant: Yeah.
285 00:30:25.820 ⇒ 00:30:27.060 Amber Lin: Very pretty.
286 00:30:28.350 ⇒ 00:30:31.119 Emily Giant: Do you think you could, like, for all of them, just…
287 00:30:31.360 ⇒ 00:30:36.459 Emily Giant: either flag them in here somehow, or just drop it into the chat in Slack.
288 00:30:36.460 ⇒ 00:30:45.749 Amber Lin: Yeah, I’ll copy all of them, and then I’ll send them to you. Like, even for stuff like dbt tests, I don’t really know what we’re testing for.
289 00:30:46.000 ⇒ 00:30:47.649 Emily Giant: Okay, me neither.
290 00:30:47.650 ⇒ 00:30:53.500 Amber Lin: I see. And I think if you… if you don’t have contact with some of them, you can always comment.
291 00:30:53.500 ⇒ 00:30:53.990 Emily Giant: Okay.
292 00:30:53.990 ⇒ 00:30:56.700 Amber Lin: I don’t, I don’t have contacts, and that will be okay.
293 00:30:58.720 ⇒ 00:30:59.180 Emily Giant: Okay.
294 00:30:59.180 ⇒ 00:31:06.780 Amber Lin: I’ll send you the list, I’ll send you a prioritized list, because I don’t want to overwhelm you, but there’s some stuff that we urgently need, and some stuff
295 00:31:07.190 ⇒ 00:31:08.370 Amber Lin: It’s good to have.
296 00:31:08.610 ⇒ 00:31:13.899 Emily Giant: Okay, perfect. I’ll just find that in Slack then, and I’ll… I’ll do that this… this afternoon.
297 00:31:13.900 ⇒ 00:31:15.130 Amber Lin: Okay, thank you so much.
298 00:31:15.280 ⇒ 00:31:16.309 Emily Giant: Talk to you soon.
299 00:31:16.310 ⇒ 00:31:16.960 Amber Lin: I…