Meeting Title: Javy-Project-Internal-Review Date: 2024-11-07 Meeting participants: Luke Daque, Nicolas Sucari, Uttam Kumaran, Payas Parab, Robert Tseng
WEBVTT
1 00:04:44.470 ⇒ 00:04:45.530 Nicolas Sucari: Hi! Ryan.
2 00:04:46.800 ⇒ 00:04:48.490 Luke Daque: Hi, Nico! How’s it going.
3 00:04:52.830 ⇒ 00:04:53.660 Nicolas Sucari: Hey? Good!
4 00:04:54.255 ⇒ 00:04:58.880 Nicolas Sucari: There is no one here. Yes, I’m here, just, you know, bigger.
5 00:05:00.850 ⇒ 00:05:05.820 Luke Daque: I think you’re cutting off a bit. I I really didn’t understand what you were saying.
6 00:05:08.080 ⇒ 00:05:08.810 Nicolas Sucari: Sorry.
7 00:05:08.810 ⇒ 00:05:09.240 Luke Daque: Thank you.
8 00:05:09.240 ⇒ 00:05:09.960 Nicolas Sucari: Can you hear me now?
9 00:05:11.600 ⇒ 00:05:13.680 Luke Daque: Yeah, I think that’s better.
10 00:05:13.690 ⇒ 00:05:14.360 Nicolas Sucari: Okay.
11 00:05:15.380 ⇒ 00:05:16.080 Nicolas Sucari: cool.
12 00:05:20.030 ⇒ 00:05:23.519 Nicolas Sucari: I don’t know if we have like a lot today, we’re still working on.
13 00:05:44.120 ⇒ 00:05:46.040 Luke Daque: Oh, Nico, are you still there? I think
14 00:05:46.530 ⇒ 00:05:48.080 Luke Daque: you just got mute and.
15 00:05:49.730 ⇒ 00:05:52.829 Nicolas Sucari: Yeah, yeah, thank you. Just waiting for
16 00:05:53.090 ⇒ 00:05:54.330 Nicolas Sucari: you guys to join.
17 00:06:41.690 ⇒ 00:06:42.679 Payas Parab: What up guys.
18 00:06:45.010 ⇒ 00:06:46.569 Luke Daque: Hey! Hi! Payas! How’s it going.
19 00:06:47.240 ⇒ 00:06:48.519 Payas Parab: Pretty good. How about you?
20 00:06:49.140 ⇒ 00:06:50.149 Luke Daque: Yeah, doing? Well.
21 00:06:50.530 ⇒ 00:06:53.160 Payas Parab: Good to see you guys. Sorry I’m a little late.
22 00:06:53.650 ⇒ 00:06:54.929 Luke Daque: No worries.
23 00:06:57.530 ⇒ 00:06:58.309 Robert Tseng: Hey, guys.
24 00:07:07.590 ⇒ 00:07:09.465 Nicolas Sucari: Hey, guys, how are you?
25 00:07:10.130 ⇒ 00:07:11.650 Nicolas Sucari: Some connection issues?
26 00:07:11.870 ⇒ 00:07:13.490 Nicolas Sucari: But I can hear you.
27 00:07:13.920 ⇒ 00:07:15.000 Nicolas Sucari: Can you hear me? Well.
28 00:07:17.350 ⇒ 00:07:20.290 Payas Parab: Yeah, I can hear you. It’s a little little fuzzy, but I can hear you.
29 00:07:26.340 ⇒ 00:07:27.340 Nicolas Sucari: Cool. Okay.
30 00:07:27.610 ⇒ 00:07:29.700 Nicolas Sucari: I don’t know if we have a lot
31 00:07:29.730 ⇒ 00:07:31.210 Nicolas Sucari: today. Lisa.
32 00:07:31.846 ⇒ 00:07:35.139 Nicolas Sucari: we’re still working on the refund for return stuff
33 00:07:35.470 ⇒ 00:07:36.470 Nicolas Sucari: with Brian.
34 00:07:37.230 ⇒ 00:07:38.200 Nicolas Sucari: Yeah, yeah.
35 00:07:38.200 ⇒ 00:07:38.590 Luke Daque: What I’m.
36 00:07:38.590 ⇒ 00:07:39.812 Nicolas Sucari: The other thing
37 00:07:43.140 ⇒ 00:07:47.530 Luke Daque: And we also had that issue with the 5 Tran connector.
38 00:07:47.630 ⇒ 00:07:50.669 Luke Daque: I just created a ticket for that. The gorgeous connector.
39 00:07:50.780 ⇒ 00:07:55.369 Luke Daque: I created a ticket for that we haven’t received any reply yet. But yeah.
40 00:07:56.292 ⇒ 00:08:01.260 Luke Daque: it’s been broken for like, I don’t know at least 3 days now.
41 00:08:02.620 ⇒ 00:08:03.740 Luke Daque: So yeah.
42 00:08:09.020 ⇒ 00:08:18.250 Payas Parab: Got it. Nico, is there anything specific you want to go through? Because I’m actually gonna be jumping back to some Javi stuff today. I had a couple of items. I just wanted to go over with you guys, but we’ll let you guys run
43 00:08:18.370 ⇒ 00:08:19.739 Payas Parab: agenda as needed.
44 00:08:26.670 ⇒ 00:08:28.830 Uttam Kumaran: I wonder if he’s if his connection is off.
45 00:08:28.830 ⇒ 00:08:31.270 Payas Parab: It might be the connection. So I’m happy to kind of just go.
46 00:08:31.270 ⇒ 00:08:32.570 Uttam Kumaran: Yeah. Yeah. Go for it. Go for it.
47 00:08:32.570 ⇒ 00:08:55.070 Payas Parab: Yeah, a couple of items. So today, I’m gonna try and get like, make sure we get closer to some of this like gross margin. Some of those key metrics, now that we had I wanted to check in obviously, returns is a big component. But you guys have that under control. The other component I wanted to talk through was for fees. I think we were like looking essentially for the fees that we’re gonna be charged.
48 00:08:56.310 ⇒ 00:09:03.910 Payas Parab: There’s only like transaction fees, right? I didn’t know if there was like any other types of fees that we were able to find that could be part of that like
49 00:09:04.230 ⇒ 00:09:09.410 Payas Parab: gross margin analysis. I don’t know if there was. I can find the thread if needed. But
50 00:09:09.540 ⇒ 00:09:10.320 Payas Parab: yeah.
51 00:09:17.210 ⇒ 00:09:19.654 Luke Daque: Yeah, I’m pretty sure the fees are like
52 00:09:19.980 ⇒ 00:09:22.610 Luke Daque: just the fees that we have in 5 grand
53 00:09:23.751 ⇒ 00:09:28.089 Luke Daque: cause, because I think they have their like calculation, like how they
54 00:09:28.610 ⇒ 00:09:33.790 Luke Daque: how to get to that fees like that. We don’t have all the details like whether they did.
55 00:09:33.920 ⇒ 00:09:36.520 Luke Daque: There’s fees for bubble wrap, or whatever.
56 00:09:36.520 ⇒ 00:09:36.920 Payas Parab: Sure.
57 00:09:36.920 ⇒ 00:09:37.320 Luke Daque: Okay.
58 00:09:37.320 ⇒ 00:09:48.619 Payas Parab: But you, you basically took the the for artifact that Robert found. And like, put that into a table. Right? I was just wondering is that in prod, and like something that I can start to build real off of? Or are we still working.
59 00:09:49.000 ⇒ 00:09:53.380 Luke Daque: It’s in the Int model the in intermediate order line
60 00:09:53.470 ⇒ 00:09:58.939 Luke Daque: model, because it’s a per line item, basically based on that artifact. But
61 00:09:59.090 ⇒ 00:10:01.970 Luke Daque: yeah, you can check it out if if that’s really
62 00:10:02.400 ⇒ 00:10:03.030 Luke Daque: like
63 00:10:03.700 ⇒ 00:10:05.749 Luke Daque: if that matches with what they have.
64 00:10:05.990 ⇒ 00:10:06.710 Payas Parab: Okay.
65 00:10:06.710 ⇒ 00:10:07.380 Luke Daque: Yeah.
66 00:10:07.630 ⇒ 00:10:19.100 Payas Parab: Got it. Okay? So then, that that’s 1 thing I think, for the cost structure is like getting some of those fee things pulled in that like from that artifact. I can take it. Take a stab at that. Today. I can own that.
67 00:10:19.410 ⇒ 00:10:21.337 Payas Parab: The other item was
68 00:10:22.260 ⇒ 00:10:31.500 Payas Parab: that that was the other item actually was the artifact like, how do we implement that? And then the other was like getting the spreadsheet for the cogs? Assumptions for skews. I know you set everything up.
69 00:10:31.960 ⇒ 00:10:40.530 Payas Parab: I wanted to check. You know. Is there anything I think, like, Robert you discussed? I need to review the notes. But like, I think we’re just gonna like we talked to him on. And we’re gonna like.
70 00:10:40.600 ⇒ 00:10:45.549 Payas Parab: put in a template right? And just load that in to get it working
71 00:10:46.240 ⇒ 00:10:48.350 Payas Parab: for the cop assumptions
72 00:10:49.050 ⇒ 00:10:50.020 Payas Parab: from sheets.
73 00:10:50.020 ⇒ 00:10:54.733 Robert Tseng: We? I think we should produce the the template and just go with it.
74 00:10:55.560 ⇒ 00:10:59.259 Robert Tseng: yeah, I mean, I I can help build that. If you guys are.
75 00:10:59.260 ⇒ 00:11:05.079 Payas Parab: Because I think we discussed with them on. I just need to find the notes. What he said to just put. I think it’s like skew, and then a couple of cost items.
76 00:11:05.080 ⇒ 00:11:16.449 Robert Tseng: Yeah, I kind of I I think I repeated it on the call. So maybe check the meeting notes. If you don’t have it, I can send it over. But we kind of agreed on like a 2 sheet, a 2 tab Google sheet thing that we would run with.
77 00:11:16.840 ⇒ 00:11:25.429 Payas Parab: Got it? Is there any issues with the 5 tran connection? If it’s like multiple sheets, just wanna check. Or is it like if it’s multiple pages on the same worksheet or.
78 00:11:25.430 ⇒ 00:11:52.409 Uttam Kumaran: You have to create. You have to create a named range per connector. So if you have multiple sheets, just create one per. It doesn’t like. It’s yeah. Just create as many as you want. The steps are pretty straightforward. You’ll just have to invite the 5 trend and then create the named range. If the range is gonna ex like, expand over time, just make sure you select all of the rows with like no row limit thing in.
79 00:11:52.410 ⇒ 00:11:53.239 Payas Parab: Sure. Sure. Yeah.
80 00:11:53.240 ⇒ 00:11:54.160 Uttam Kumaran: Yeah.
81 00:11:55.008 ⇒ 00:11:57.690 Payas Parab: And in that case, if you’re selecting, like all
82 00:11:58.400 ⇒ 00:12:01.340 Payas Parab: all rows, it just basically will like only.
83 00:12:01.340 ⇒ 00:12:12.419 Uttam Kumaran: As new stuff comes in, it’ll take that. Yeah, yeah. I mean, the only other thing to make sure is that you have everything in the column. Just make sure it has the right data type.
84 00:12:12.794 ⇒ 00:12:24.359 Uttam Kumaran: Or it’s not empty, because if it’s empty, I think it’ll assume it’s a character, and then once you fill in a number later, it may. So if there’s something empty, if you could just put 0 or
85 00:12:24.720 ⇒ 00:12:28.010 Uttam Kumaran: something like that, that’d be helpful. If not, we can also figure it out later.
86 00:12:28.010 ⇒ 00:12:28.819 Payas Parab: Got it. Got it.
87 00:12:28.820 ⇒ 00:12:31.400 Uttam Kumaran: Easy to like. Remove these and do them again. So.
88 00:12:32.050 ⇒ 00:12:42.360 Payas Parab: Okay, excellent. Alright. I will also own that today, getting that set up based on the notes from Robert and I discussion with them on, get that set up. Hit you guys with like what we need to connect to 5 trans, so we can like, get it.
89 00:12:42.380 ⇒ 00:12:44.139 Payas Parab: Get that going as well. And.
90 00:12:44.140 ⇒ 00:12:49.440 Luke Daque: Just to clarify with the Google sheet. It’s just one Google sheet with multiple tabs. Right? Not.
91 00:12:49.440 ⇒ 00:12:50.110 Payas Parab: Multiple tasks.
92 00:12:50.110 ⇒ 00:12:50.960 Luke Daque: Google sheets.
93 00:12:50.960 ⇒ 00:12:51.610 Payas Parab: Yeah.
94 00:12:52.100 ⇒ 00:12:55.850 Luke Daque: So it’s not like multiple Google sheets one per week, or whatever right.
95 00:12:55.850 ⇒ 00:13:00.279 Payas Parab: Yeah, yeah. And we want it that way. Right? I’m just trying to cause we’re we’re gonna set it up. So I wanna make sure whatever.
96 00:13:00.280 ⇒ 00:13:01.510 Uttam Kumaran: Let’s do the one.
97 00:13:01.510 ⇒ 00:13:04.040 Payas Parab: 1. 1 worksheet with multiple tabs is the easy.
98 00:13:04.040 ⇒ 00:13:05.390 Uttam Kumaran: Yes, with individual.
99 00:13:05.390 ⇒ 00:13:06.160 Payas Parab: Named
100 00:13:06.450 ⇒ 00:13:07.340 Payas Parab: excellent.
101 00:13:07.520 ⇒ 00:13:08.060 Payas Parab: Okay.
102 00:13:08.450 ⇒ 00:13:18.930 Payas Parab: I will own that for today as well. So those are kind of the big items on my end. Yeah, we’ll throw it back to you guys if there’s any items, any questions or anything outstanding that I owe you guys let me know.
103 00:13:19.521 ⇒ 00:13:23.869 Payas Parab: Otherwise, those are the things I’m going to be tackling kind of today this afternoon. Primarily.
104 00:13:24.350 ⇒ 00:13:27.489 Uttam Kumaran: Ryan anything else on our side.
105 00:13:27.490 ⇒ 00:13:28.740 Luke Daque: Once I’m
106 00:13:29.285 ⇒ 00:13:34.080 Luke Daque: I’m currently creating a separate refunds model just trying to.
107 00:13:34.360 ⇒ 00:13:38.520 Luke Daque: But yeah, I should be able to create a Pr. Today for that one as well.
108 00:13:38.520 ⇒ 00:13:42.169 Uttam Kumaran: And is that joining the order line refunds and the other refunds based today.
109 00:13:42.170 ⇒ 00:13:48.549 Luke Daque: Yeah. And that’s where the complication is like. Not all the order line refunds are in the refunds table and
110 00:13:48.660 ⇒ 00:13:51.250 Luke Daque: like something like that. So I’m still trying to figure out.
111 00:13:51.250 ⇒ 00:13:51.889 Payas Parab: Well, did it like.
112 00:13:51.890 ⇒ 00:13:53.140 Luke Daque: What’s causing it, and.
113 00:13:53.140 ⇒ 00:13:59.320 Payas Parab: Ryan did, did, adjusting the dates and seeing the different dates for the process. That versus that did that resolve anything, or is.
114 00:13:59.320 ⇒ 00:13:59.760 Luke Daque: No it.
115 00:14:00.680 ⇒ 00:14:03.119 Luke Daque: I tried everything like process that.
116 00:14:03.120 ⇒ 00:14:06.410 Uttam Kumaran: Yeah, basically, what we found is, there’s some orders where they return.
117 00:14:06.700 ⇒ 00:14:13.209 Uttam Kumaran: They return all the line items. There’s some orders where they return the entire order, and then there’s there’s there’s in between.
118 00:14:13.210 ⇒ 00:14:13.980 Luke Daque: Partial. Yeah.
119 00:14:14.640 ⇒ 00:14:16.619 Uttam Kumaran: There’s partial. And
120 00:14:16.650 ⇒ 00:14:20.740 Uttam Kumaran: it’s just like, I don’t know why they have like an inconsistent process
121 00:14:20.820 ⇒ 00:14:23.044 Uttam Kumaran: because they should. Yeah, it’s
122 00:14:23.950 ⇒ 00:14:35.020 Uttam Kumaran: It’s just something. We’re gonna model away, basically. But Ryan, I’m pretty sure if we add, if we union those and like, you can basically just sum up at the order level. Get the refunds.
123 00:14:35.470 ⇒ 00:14:42.029 Uttam Kumaran: That’s probably it, because I don’t know. I don’t think we particularly need refunds at the line item level
124 00:14:43.190 ⇒ 00:14:44.419 Uttam Kumaran: at the moment. I don’t know.
125 00:14:44.420 ⇒ 00:14:45.030 Luke Daque: Okay.
126 00:14:45.220 ⇒ 00:14:49.780 Luke Daque: sounds good in. In that case. Yeah, I can just aggregate everything to the order level. And then.
127 00:14:50.480 ⇒ 00:14:53.369 Luke Daque: yeah, we’ll we’ll see. I’ll I’ll see what I can do. There.
128 00:14:53.690 ⇒ 00:14:54.360 Uttam Kumaran: Okay.
129 00:14:58.840 ⇒ 00:15:02.960 Payas Parab: Got it. And then I know you guys were building some of the key Kpi tables in
130 00:15:03.311 ⇒ 00:15:20.229 Payas Parab: real as well. The Meta base free trial is up. I don’t know if we were like, did we? Because we’re setting up the key Kpis, like aggregated by, you know, month or whatever right like that key dashboard. We’re setting that up in real with the key, Kpis, I was wondering, are we planning to also ship like a.
131 00:15:20.230 ⇒ 00:15:29.429 Uttam Kumaran: No, I thought I thought we agreed that they’re only using that like, I thought, we’re over the real thing, like if they that’s just like sticking around. But everything’s going into Meta Base.
132 00:15:29.430 ⇒ 00:15:30.979 Payas Parab: You can go into metamase. Okay.
133 00:15:32.350 ⇒ 00:15:37.670 Uttam Kumaran: That’s my understanding. That’s what cause I don’t want to bring up real to them again, at least for a while, because they just
134 00:15:38.390 ⇒ 00:15:41.910 Uttam Kumaran: they’re getting confused. So I just like, I think we just stick with metase.
135 00:15:41.910 ⇒ 00:15:48.309 Payas Parab: So then I, I basically have to start migrating some of those dashboards from real into metabase. Then right? Some of the views we’re creating.
136 00:15:49.635 ⇒ 00:15:51.659 Uttam Kumaran: Migrating I feel like is
137 00:15:52.100 ⇒ 00:15:57.589 Uttam Kumaran: probably like too strong. They just exist in real like there’s not really like anything there. It’s just like a
138 00:15:57.950 ⇒ 00:15:59.030 Uttam Kumaran: meaning
139 00:15:59.410 ⇒ 00:16:02.889 Uttam Kumaran: like, we just have probably have to make. Yeah, you have to make them in like.
140 00:16:02.890 ⇒ 00:16:03.989 Payas Parab: Into a dashboard right.
141 00:16:03.990 ⇒ 00:16:04.760 Uttam Kumaran: Yeah, yeah.
142 00:16:04.760 ⇒ 00:16:06.580 Payas Parab: Same underlying sequel.
143 00:16:07.060 ⇒ 00:16:18.209 Uttam Kumaran: But that’s that’s what I’m saying is that we shouldn’t have like logic in metabase. Hopefully, all that is in Dbt, and just we just hand you a table, basically to to create the dashboard from like, that’s the goal.
144 00:16:18.850 ⇒ 00:16:20.659 Payas Parab: I see. I see. Okay.
145 00:16:20.950 ⇒ 00:16:22.560 Uttam Kumaran: Does that make sense like
146 00:16:23.045 ⇒ 00:16:43.729 Uttam Kumaran: cause? I know in the past there was logic where you’re doing aggregation and stuff in Meta Base that’s going to be stuff that we have like no visibility into. And if something breaks, it’ll be really hard to manage. So like, put shove all that to Dbt, you basically get an aggregate table or the dimension tables you do light modeling there, that’s mainly like joins and filters.
147 00:16:44.673 ⇒ 00:16:47.690 Uttam Kumaran: But hopefully, like, that’s the.
148 00:16:48.200 ⇒ 00:17:02.440 Payas Parab: I see what you’re saying. Yeah, okay, I’m just so my, historically, like the company I work for before we did, we did just do everything in Meta Base. But with dbt, it sounds like, okay, whatever that table is set up. And it’s just like pushed into real right, like whatever weekly monthly views, or whatever I want to create
149 00:17:02.800 ⇒ 00:17:07.519 Payas Parab: create. But it shouldn’t be like a sequel based logic. It should just be like those filters.
150 00:17:07.520 ⇒ 00:17:09.710 Uttam Kumaran: 100%. Yeah, like, there’s
151 00:17:10.510 ⇒ 00:17:15.947 Uttam Kumaran: there’s gonna be healthy like back and forth between you and and Ryan, and that like, it’s like,
152 00:17:16.490 ⇒ 00:17:32.169 Uttam Kumaran: you may, you may write something just to get something done, and then we want to push it back into the Dbt layer, the reason being. And again, like, it’s just like when you use a metabase or a looker. This is like commonly just what happens. But in order to just like minimize sprawl and basically centralize all the logic.
153 00:17:32.240 ⇒ 00:17:38.359 Uttam Kumaran: Also, we have observability, like we’re watching for errors. For example, like, if we change a column type.
154 00:17:38.410 ⇒ 00:17:44.339 Uttam Kumaran: we can track how that impacts downstream models, but I can’t see that they broke something in metabase.
155 00:17:44.340 ⇒ 00:17:44.970 Payas Parab: See? Yeah.
156 00:17:44.970 ⇒ 00:17:50.839 Uttam Kumaran: Kind of minimize that basically like, save us some headache where we like, centralize everything.
157 00:17:50.840 ⇒ 00:17:51.170 Payas Parab: Yep.
158 00:17:51.500 ⇒ 00:17:56.519 Uttam Kumaran: It may take a little bit more time, but, like it’s, it’s for the better.
159 00:17:56.520 ⇒ 00:17:57.459 Payas Parab: The better. Okay.
160 00:17:57.460 ⇒ 00:18:04.819 Uttam Kumaran: I’ll share is like, if you’re like, I quickly need to do something. Let me just model in metabase the processes, do that, and then just hand that logic off
161 00:18:04.900 ⇒ 00:18:08.840 Uttam Kumaran: to Ryan. He can model it. And then you basically can just swap it once it’s done.
162 00:18:08.840 ⇒ 00:18:18.419 Payas Parab: I see, I see. Okay. So now, for like that dashboard I have shipped already, like I just can get rid of all that sequel logic and then pull in this like Kpi, that you guys.
163 00:18:18.420 ⇒ 00:18:27.299 Uttam Kumaran: And then and then just work. Work directly. If you’re like, Hey, we need this column. We need this dimension. This aggregation isn’t working, or this column type isn’t wrong. Those are things that we’ll just modify.
164 00:18:27.300 ⇒ 00:18:31.100 Payas Parab: Got it clear. Okay, awesome, super educational. To that. I appreciate you explaining all that.
165 00:18:31.100 ⇒ 00:18:37.390 Uttam Kumaran: Yeah, yeah, no, it’s it’s it’s not like again it. I feel it’s like, if you some people just start from different paths like.
166 00:18:37.390 ⇒ 00:18:37.960 Payas Parab: I don’t.
167 00:18:37.960 ⇒ 00:18:41.380 Uttam Kumaran: Yeah, analyst. So it’s just trying to build scalable models. So it’s.
168 00:18:41.380 ⇒ 00:18:42.060 Payas Parab: Makes sense.
169 00:18:42.060 ⇒ 00:18:45.660 Uttam Kumaran: Because this will be the 1st part of their stuff that we tackle. We’ll end up with
170 00:18:46.020 ⇒ 00:18:51.579 Uttam Kumaran: definitely like close to 100 models across int and marts. So
171 00:18:51.780 ⇒ 00:18:54.720 Uttam Kumaran: it’s just gonna become crazy to manage. So.
172 00:18:55.140 ⇒ 00:19:07.369 Payas Parab: Awesome. Yeah. And Robert sent me some examples of like how to best construct in Meta Base to not create technical debt. So I have those to review as well. So I’ll get that going as well. Kind of just removing all that logic from there shifting. That’ll be a 3rd thing that I will
173 00:19:07.480 ⇒ 00:19:10.940 Payas Parab: own for today. So we can flip something to Jared.
174 00:19:11.340 ⇒ 00:19:15.959 Uttam Kumaran: Okay? And then it looks like the only thing Nico mentioned is that recharge isn’t getting a lot
175 00:19:16.567 ⇒ 00:19:19.249 Uttam Kumaran: of stuff. I guess I should.
176 00:19:19.250 ⇒ 00:19:29.659 Luke Daque: Yeah, we’re only getting like 13 rows in orders. The orders table from Recharge, which is, I’m not sure if that’s correct or not, because we don’t have access to recharge.
177 00:19:29.720 ⇒ 00:19:32.129 Luke Daque: So if anybody can check on that.
178 00:19:32.130 ⇒ 00:19:37.740 Payas Parab: We do either, Robert, do we have Recharge X. Or maybe, is it like an amplitude? We can check the recharge events.
179 00:19:38.440 ⇒ 00:19:42.079 Robert Tseng: Yeah, we can check in amplitude. It’s definitely 13.
180 00:19:42.080 ⇒ 00:19:46.400 Uttam Kumaran: Like super low. I wonder if it’s something with the
181 00:19:47.320 ⇒ 00:19:53.149 Uttam Kumaran: their Api settings or something? Okay, maybe we’ll check. We’ll probably have to look at the 5 train logs.
182 00:19:53.670 ⇒ 00:19:56.395 Uttam Kumaran: Ryan, and see whether it like hit an error. But
183 00:19:56.940 ⇒ 00:20:07.189 Luke Daque: Yeah, I already did. It didn’t seem like there was an error or anything. Everything synced up well, like in orders, for example. But yeah, I don’t. I don’t know why. It’s only 13, so.
184 00:20:07.580 ⇒ 00:20:08.260 Uttam Kumaran: Okay.
185 00:20:09.300 ⇒ 00:20:11.729 Uttam Kumaran: okay, we’ll take that as a as A to do.
186 00:20:11.870 ⇒ 00:20:17.664 Payas Parab: I will. I will also get you guys that from amplitude, and just to see what volumes we might be expecting.
187 00:20:17.940 ⇒ 00:20:18.770 Luke Daque: That’d be great.
188 00:20:18.770 ⇒ 00:20:19.350 Payas Parab: Yeah.
189 00:20:19.940 ⇒ 00:20:22.400 Payas Parab: I’m looking right now, and I’ll I’ll send it to you after this call.
190 00:20:22.400 ⇒ 00:20:23.000 Robert Tseng: Yeah.
191 00:20:23.430 ⇒ 00:20:24.110 Luke Daque: Cool.
192 00:20:27.180 ⇒ 00:20:28.270 Uttam Kumaran: Okay. Cool.
193 00:20:30.430 ⇒ 00:20:39.229 Robert Tseng: So I think 1 1 thing on the as we’re trying to model out like this upsell refund nonsense that Javi has
194 00:20:39.670 ⇒ 00:20:51.349 Robert Tseng: like, I think, to your point, Uton. I feel like they’re just flying by the sea of their pants and continuing to change the logic. So I feel like as we’re trying to like, break this out into categories. Like, I,
195 00:20:51.700 ⇒ 00:21:06.329 Robert Tseng: I feel like we’re not going to catch everything. I if we can just have a cut off like at least we if we have a logic right for everything from like the past month moving forward. I don’t want to fix their logic from like 6 months ago. I feel like it was a waste of time. Yeah.
196 00:21:06.510 ⇒ 00:21:15.340 Uttam Kumaran: I agree? Yeah, as long as we can get. If we can get the high level kpis to match what they’re seeing in the dashboard for the last month. That’ll be it. That’s why.
197 00:21:15.340 ⇒ 00:21:20.170 Robert Tseng: Match last month. I’m I’m good with that, and I will push back on the other stuff like.
198 00:21:20.170 ⇒ 00:21:24.600 Uttam Kumaran: Okay? So that’s why, Ryan, if we can just aggregate the order level, and then we make sure that the
199 00:21:24.910 ⇒ 00:21:38.039 Uttam Kumaran: when you do the filter and shopify for refunds, it matches. Or if if we basically, if we’re if we’re doing the date match, then let’s just like kill it there. Hopefully, this like new refunds thing. Is that so?
200 00:21:40.300 ⇒ 00:21:41.490 Luke Daque: Sure sounds good.
201 00:21:42.680 ⇒ 00:21:43.333 Uttam Kumaran: Okay. Awesome.
202 00:21:46.520 ⇒ 00:21:47.780 Uttam Kumaran: Okay. Cool.
203 00:21:48.430 ⇒ 00:21:49.380 Uttam Kumaran: Anything else.
204 00:21:53.167 ⇒ 00:22:02.679 Robert Tseng: So yeah, Piusa, just quick. Quick. Note on. Yeah. So the the dashboard that you built if you can push that to Ryan to get that into the get that into Dbt.
205 00:22:03.360 ⇒ 00:22:12.459 Robert Tseng: I. We did tell Javi that we were going to send them kind of like a v, 1 of the the cog stuff. So I think if we can get that Google sheet, and then
206 00:22:12.540 ⇒ 00:22:14.359 Robert Tseng: we can get the Google sheet to them
207 00:22:14.550 ⇒ 00:22:22.520 Robert Tseng: today, that would be great just to like. Get that in front of Jared and have him sign off on it that could buy us another like few days for us to put.
208 00:22:22.520 ⇒ 00:22:24.249 Payas Parab: Sure. Yeah, that makes sense, you know.
209 00:22:24.250 ⇒ 00:22:24.630 Robert Tseng: Okay.
210 00:22:24.630 ⇒ 00:22:28.340 Payas Parab: I can get you something end of day, and I’ll message you offline for work streams for today.
211 00:22:28.710 ⇒ 00:22:29.400 Payas Parab: Cool.
212 00:22:34.330 ⇒ 00:22:36.370 Uttam Kumaran: Okay, thanks guys.
213 00:22:36.640 ⇒ 00:22:37.930 Robert Tseng: Yep, see ya.
214 00:22:37.930 ⇒ 00:22:38.860 Payas Parab: Thank you. Guys.
215 00:22:38.860 ⇒ 00:22:39.560 Luke Daque: Thanks.