Meeting Title: Sync on Data Warehouse Design Date: 2026-01-20 Meeting participants: Samuel Roberts, Casie Aviles, Pranav Narahari
WEBVTT
1 00:00:31.820 ⇒ 00:00:32.790 Samuel Roberts: Hey.
2 00:00:34.050 ⇒ 00:00:34.899 Casie Aviles: Hey, Sam.
3 00:00:36.940 ⇒ 00:00:37.879 Samuel Roberts: How are you?
4 00:00:39.550 ⇒ 00:00:41.050 Casie Aviles: Yep, doing good.
5 00:00:42.370 ⇒ 00:00:45.809 Casie Aviles: I was just working a bit on the Liloch thing earlier.
6 00:00:46.250 ⇒ 00:00:50.299 Samuel Roberts: Yeah, yeah, good job. I mean, he seems very happy with it. I’m glad we got that.
7 00:00:50.490 ⇒ 00:00:53.770 Samuel Roberts: File size thing sorted out.
8 00:00:54.240 ⇒ 00:01:02.330 Casie Aviles: Yeah, I mean… It’s good that they caught that as well. I wasn’t testing with large images.
9 00:01:02.330 ⇒ 00:01:08.089 Samuel Roberts: Yeah, no, I mean, you’re good, you’re good. It was hopefully not too bad a fix, but I think…
10 00:01:08.150 ⇒ 00:01:11.140 Casie Aviles: Hopefully that’s way overkill anyway, but…
11 00:01:12.270 ⇒ 00:01:18.790 Samuel Roberts: I don’t really know what their designers might be putting in there, so… Cool.
12 00:01:19.960 ⇒ 00:01:30.530 Casie Aviles: Yeah, I think it makes sense that they use, like, higher file sizes because of the resolution. They might, you know, prefer, like, better resolution with the output, so…
13 00:01:30.810 ⇒ 00:01:39.309 Samuel Roberts: Yeah, that’s what I was thinking, like, there’s a chance they’re gonna be uploading higher stuff, but that still seems… and if they need it, we can adjust it, obviously, so it’s not the end of the world.
14 00:01:41.760 ⇒ 00:01:42.560 Pranav Narahari: Hey, guys.
15 00:01:44.120 ⇒ 00:01:44.699 Samuel Roberts: How’s it going today?
16 00:01:44.700 ⇒ 00:01:45.080 Casie Aviles: Hey.
17 00:01:45.790 ⇒ 00:01:51.010 Pranav Narahari: Pretty good. Trying to just, like, figure out right now with,
18 00:01:51.470 ⇒ 00:01:54.940 Pranav Narahari: with, like, the meta ads report, like, so all the data is looking good now.
19 00:01:54.940 ⇒ 00:01:55.430 Samuel Roberts: Yeah.
20 00:01:56.210 ⇒ 00:02:10.630 Pranav Narahari: I just was… so before, I was calculating things for the Meta’s channel using some Shopify data, because I guess I just wasn’t fully, like… I’m, like, learning a little bit about just, like, what all of these, like, terms mean.
21 00:02:10.630 ⇒ 00:02:12.019 Samuel Roberts: Yeah, yeah, that’s fair, yeah.
22 00:02:12.020 ⇒ 00:02:16.090 Pranav Narahari: So I just… well, I kind of knew, like, okay, the CAC is customer acquisition cost, like.
23 00:02:16.510 ⇒ 00:02:24.849 Pranav Narahari: But I just didn’t think that Meta would have, like, certain data in there, so I was doing, like, a more complex calculation using, like, Shopify.
24 00:02:24.850 ⇒ 00:02:26.060 Samuel Roberts: Oh, interesting.
25 00:02:26.060 ⇒ 00:02:32.399 Pranav Narahari: Yeah, but, like, Meta just, like, straight up gives you that metric, I just have to pull in that data, so…
26 00:02:32.400 ⇒ 00:02:38.919 Samuel Roberts: Oh, yeah, yeah, the acquisition cost should be there, and the return, probably what you need more for 5, I bet, right?
27 00:02:39.440 ⇒ 00:02:49.420 Pranav Narahari: Exactly, yeah. And so, I was asking, like, Bobby about, like, formulas before, and it’s literally, there’s no formulas. You just pull the data exactly as it is from the ads platform, so it’s actually super.
28 00:02:49.420 ⇒ 00:02:51.209 Samuel Roberts: Oh, never mind, there you go, perfect.
29 00:02:51.210 ⇒ 00:03:02.659 Pranav Narahari: Yeah. But, so, like, that’s all sorted. Now, though, I’m just trying to, like, figure out, like, styling-wise, with the report. So, like…
30 00:03:02.810 ⇒ 00:03:05.480 Pranav Narahari: Bobby gave, like, some inspiration, so it’s like…
31 00:03:05.480 ⇒ 00:03:05.980 Samuel Roberts: Yeah.
32 00:03:05.980 ⇒ 00:03:08.059 Pranav Narahari: I’m just, like, doing a bunch of, like…
33 00:03:08.500 ⇒ 00:03:16.999 Pranav Narahari: just test to see, like, does it look better? I think they kind of tend to like things that are, light mode versus dark mode, so…
34 00:03:17.000 ⇒ 00:03:21.780 Samuel Roberts: Yeah, they did kind of say they wanted to move away from dark mode anyway, so I think that’s… that’s totally fair.
35 00:03:21.780 ⇒ 00:03:22.190 Pranav Narahari: Yeah.
36 00:03:22.190 ⇒ 00:03:27.199 Samuel Roberts: We’ll get on that at some point, once this is all a little more solidified. That’ll probably be a big…
37 00:03:27.860 ⇒ 00:03:31.350 Samuel Roberts: One of the first big pushes to production, once we get this out.
38 00:03:31.350 ⇒ 00:03:31.950 Pranav Narahari: Geez.
39 00:03:32.430 ⇒ 00:03:33.819 Samuel Roberts: Oh yeah, I’m not too worried about that.
40 00:03:33.950 ⇒ 00:03:34.700 Pranav Narahari: Yeah.
41 00:03:35.050 ⇒ 00:03:41.750 Samuel Roberts: Cool. Before we jump in to talk about the Phase 2 stuff, I was actually going through the…
42 00:03:42.040 ⇒ 00:03:44.670 Samuel Roberts: The PR that you had?
43 00:03:44.860 ⇒ 00:03:45.560 Pranav Narahari: Yep.
44 00:03:45.560 ⇒ 00:03:48.930 Samuel Roberts: Two things. One, I mentioned it there, just adding a,
45 00:03:49.730 ⇒ 00:03:54.030 Samuel Roberts: a… like, a description. Curse is pretty good at generating those.
46 00:03:54.780 ⇒ 00:03:57.559 Samuel Roberts: From, like, all the changes, just because it’ll help me…
47 00:03:58.270 ⇒ 00:04:00.099 Samuel Roberts: Know what I’m looking for a little bit more.
48 00:04:00.100 ⇒ 00:04:01.240 Pranav Narahari: Totally, yeah.
49 00:04:01.240 ⇒ 00:04:02.940 Samuel Roberts: And then, one thing I noticed.
50 00:04:03.060 ⇒ 00:04:09.869 Samuel Roberts: And I’m glad I have both of you here, because… so the… the prisma.ts file in the backend.
51 00:04:10.050 ⇒ 00:04:12.009 Samuel Roberts: Yeah. I was looking at it, it, it just…
52 00:04:12.250 ⇒ 00:04:16.299 Samuel Roberts: It changed the quotes from double to single quotes.
53 00:04:16.300 ⇒ 00:04:16.700 Pranav Narahari: Yup.
54 00:04:16.700 ⇒ 00:04:21.160 Samuel Roberts: I realized we gotta get on the same page with Prettier and, like, auto…
55 00:04:21.290 ⇒ 00:04:25.780 Samuel Roberts: formatting and stuff, because otherwise, we’re gonna start getting a bunch of those, I bet, as, like.
56 00:04:26.130 ⇒ 00:04:37.379 Samuel Roberts: you know, cursor or Claude generates a bunch of code, and it might not be formatted the same way, and then we’re gonna get, like, random changes like this that really don’t do anything, and it’s just gonna clog up the…
57 00:04:38.740 ⇒ 00:04:39.410 Pranav Narahari: conventions.
58 00:04:39.410 ⇒ 00:04:42.069 Samuel Roberts: Oh, go ahead, yeah.
59 00:04:42.070 ⇒ 00:04:46.030 Pranav Narahari: on this one, so, like, this has not happened before. I wasn’t sure if, like…
60 00:04:46.820 ⇒ 00:04:51.350 Samuel Roberts: It might have been me at some point, I don’t know, but… because I’ve noticed a few of these I’ve tried to catch.
61 00:04:52.380 ⇒ 00:05:06.149 Pranav Narahari: Gotcha. Yeah, so, like, there was a… and maybe I just, like, ran the linting, and that’s what kind of just, like, caught a bunch of the stuff. And so, yeah, it would be weird if, like, you know, I ran a linter and, like, my linter’s saying something different than yours.
62 00:05:06.150 ⇒ 00:05:14.729 Samuel Roberts: That’s exactly… I just wanted… I don’t know if we have anything in that reap… I wasn’t sure… I just… I just saw it before we were hopping on, so I was like, let’s just talk about it real quick.
63 00:05:14.730 ⇒ 00:05:16.760 Pranav Narahari: I’m not sure what’s in the…
64 00:05:16.940 ⇒ 00:05:22.749 Samuel Roberts: Ditch… Okay, so we might… how’s gonna work, though, with the different…
65 00:05:23.280 ⇒ 00:05:26.099 Samuel Roberts: Repo, so we probably need to put, like, a,
66 00:05:26.950 ⇒ 00:05:31.250 Samuel Roberts: a prettier config at the top level of the Stitch platform repo?
67 00:05:32.570 ⇒ 00:05:37.320 Samuel Roberts: And then I’m trying to think, do we want to… Well, here’s another…
68 00:05:37.450 ⇒ 00:05:41.969 Samuel Roberts: hiccup in this. I realized my prettier hasn’t even been working on save.
69 00:05:42.700 ⇒ 00:05:46.369 Samuel Roberts: in cursor, and I just dug into it, there’s a,
70 00:05:47.180 ⇒ 00:05:49.959 Samuel Roberts: a bug in cursor that’s fixed in the new version that’s coming out.
71 00:05:51.370 ⇒ 00:05:51.810 Pranav Narahari: Nope.
72 00:05:51.810 ⇒ 00:05:55.380 Samuel Roberts: very timely. I was just like, why is this not working?
73 00:05:55.910 ⇒ 00:06:01.709 Samuel Roberts: And it’s literally, like, 3 hours ago, someone’s like, fixed in the new version, 2.4.2, and I’m on, like…
74 00:06:01.810 ⇒ 00:06:05.550 Samuel Roberts: 2.3 or something. And it’s not out yet, but…
75 00:06:05.770 ⇒ 00:06:10.820 Samuel Roberts: So hopefully that’ll help some things, but I think we probably want to do, like, a…
76 00:06:12.290 ⇒ 00:06:15.729 Samuel Roberts: I don’t know if we necessarily want, like, a pre-commit hook, or a, like, a pre…
77 00:06:16.080 ⇒ 00:06:18.379 Samuel Roberts: You do pre-pull hooks, pre-merge hooks?
78 00:06:20.790 ⇒ 00:06:27.609 Samuel Roberts: Anyway, this isn’t something I’m thinking about, I just wanted to bring it up, make sure we get on the same page there, because as this codebase gets bigger, it’s gonna get…
79 00:06:28.340 ⇒ 00:06:33.740 Samuel Roberts: you know, especially with a lot of AI-generated code, it doesn’t always follow the same format automatically, and we want to make sure it does.
80 00:06:33.950 ⇒ 00:06:35.319 Pranav Narahari: Yeah, so this, like…
81 00:06:35.920 ⇒ 00:06:45.189 Pranav Narahari: this PR is literally, like, one file changed with, like, actual, like, logic changes in the backend, and then the rest is just, like, linting stuff.
82 00:06:45.190 ⇒ 00:06:55.359 Samuel Roberts: Is that really all the rest of it? I hadn’t gone through it too closely yet, I was just scrolling through and saw that. Okay, if that’s the case, then we should definitely… okay, I was wondering, because I saw a lot of 26 files, I was like, oh shit.
83 00:06:55.360 ⇒ 00:06:56.939 Pranav Narahari: Yeah. No, it’s literally just like.
84 00:06:56.940 ⇒ 00:07:02.349 Samuel Roberts: It’s a lot of linting. Okay, I would say… That’s fine. Okay, let’s,
85 00:07:03.190 ⇒ 00:07:08.980 Samuel Roberts: I will put a little bit of thought into that after this meeting, get a prettier config in there. I don’t know if you guys have, like, strong preferences on any of that stuff.
86 00:07:09.680 ⇒ 00:07:10.050 Pranav Narahari: I don’.
87 00:07:10.050 ⇒ 00:07:16.129 Samuel Roberts: like… quotes and semicolons and how things are… I kind of just tend to go with the prettier defaults.
88 00:07:17.290 ⇒ 00:07:17.920 Pranav Narahari: I’m cool with that.
89 00:07:17.920 ⇒ 00:07:21.560 Samuel Roberts: If something is bothering us, we can change it later, but,
90 00:07:21.720 ⇒ 00:07:24.480 Samuel Roberts: Okay, I’ll set that up, I’ll run a big…
91 00:07:25.010 ⇒ 00:07:27.100 Samuel Roberts: lint on it, and then maybe I’ll do…
92 00:07:27.930 ⇒ 00:07:32.150 Samuel Roberts: Actually, that’s the other thing. So, Prabh, I know you were using Claude Code, right?
93 00:07:32.300 ⇒ 00:07:32.950 Pranav Narahari: Yep.
94 00:07:32.950 ⇒ 00:07:34.440 Samuel Roberts: Using that in-cursor.
95 00:07:34.920 ⇒ 00:07:38.650 Samuel Roberts: Or are you just using it in the command line, and how, like, are you using an IDE? Like, what is the…
96 00:07:39.090 ⇒ 00:07:55.249 Pranav Narahari: Yeah, so my setup is, I just have, like, a terminal window, and then I just use cursor as basically, like, how I was using VS Code before. Sometimes, though, I do hop into, like, the… like, the agent chat thing, and then, like, for smaller things.
97 00:07:55.250 ⇒ 00:07:55.840 Samuel Roberts: Okay.
98 00:07:55.840 ⇒ 00:07:56.490 Pranav Narahari: Yeah.
99 00:07:57.060 ⇒ 00:08:02.610 Samuel Roberts: That’s cool. Yeah, I just want to make sure, because, like, I would say, if you don’t already have the Prettier extension.
100 00:08:03.140 ⇒ 00:08:08.410 Samuel Roberts: It’s worth installing, because it’ll do, like, on save, so if you’re making changes and…
101 00:08:08.600 ⇒ 00:08:11.390 Samuel Roberts: It’ll just auto-format everything.
102 00:08:11.680 ⇒ 00:08:25.680 Samuel Roberts: Oh, cool. Once we have that prettier config, then it’ll know to do that, I think. Like I said, Cursor currently has a bug, but that should be fixed in the new version, hopefully coming out soon. So, I just want to make sure I wasn’t sure how you were doing it. Casey, you’re in Cursor most of the time, right?
103 00:08:26.970 ⇒ 00:08:29.540 Samuel Roberts: Okay, cool. Do you have Prettier installed, by the way?
104 00:08:30.540 ⇒ 00:08:33.239 Casie Aviles: Oh, no, not kidding, I’m installing right now.
105 00:08:33.240 ⇒ 00:08:43.800 Samuel Roberts: Yeah, yeah, it’s… it’s… it’s pretty good, and once we get it cleaned up, the code will be… it’ll be nice. Like, auto-formatting on save is good, and then maybe we’ll add, like, a pre…
106 00:08:44.690 ⇒ 00:08:57.090 Samuel Roberts: pre-commit hook, or something where it’s just going to run that linter just in case, but… Okay, that’s good. Thank you for pointing out that all these other ones are just linting changes, because I was… I wasn’t really… hadn’t dug too deep into it, I just happened to scroll all the way down and saw the…
107 00:08:58.520 ⇒ 00:09:02.329 Samuel Roberts: the Prismaware is just quotes, and I was like, okay. All right, cool.
108 00:09:03.470 ⇒ 00:09:07.640 Samuel Roberts: Thank you, guys. I will take a look at the Pretter config, and then…
109 00:09:07.810 ⇒ 00:09:12.070 Samuel Roberts: I’ll probably do another push that’s, like, relinting everything to whatever we want.
110 00:09:12.070 ⇒ 00:09:13.450 Pranav Narahari: For the default config.
111 00:09:14.520 ⇒ 00:09:21.580 Pranav Narahari: Yeah. And so, actually, why I asked that, like, that question about, like, do we want to just, like, merge our own PRs for right now?
112 00:09:21.580 ⇒ 00:09:22.250 Samuel Roberts: Yeah.
113 00:09:22.250 ⇒ 00:09:24.809 Pranav Narahari: Was just because, like…
114 00:09:24.850 ⇒ 00:09:29.860 Samuel Roberts: you know, for bug fixes, and like, since we’re kind of early on, moving pretty quickly, like, I don’t want to have to, like.
115 00:09:29.860 ⇒ 00:09:45.739 Pranav Narahari: bother you to, like, you know, get full context on something, if I’m pretty confident, like, it’s not a breaking change, and it’s gonna, like, touch a bunch of different things. But what I realized was, since we’re not admins, we don’t even have the ability to bypass that. So…
116 00:09:45.740 ⇒ 00:09:47.370 Samuel Roberts: Oh, shit, okay, well… Yeah.
117 00:09:47.370 ⇒ 00:09:59.560 Pranav Narahari: I think that may be something we should ask Zach to grant either all of us, or just one of us, or whatever. Just because, like, since Zach is out, and, like, there’s a breaking change in production, like.
118 00:09:59.560 ⇒ 00:10:02.160 Samuel Roberts: No, you’re absolutely right. That would be a hiccup.
119 00:10:02.160 ⇒ 00:10:02.690 Pranav Narahari: Yeah.
120 00:10:02.960 ⇒ 00:10:08.029 Samuel Roberts: Okay, yeah, let’s definitely ask them to make us all admins at the very least, and we can work with it from there.
121 00:10:08.410 ⇒ 00:10:23.989 Samuel Roberts: Yeah, I mean, I don’t… I don’t have, like, too much of an issue. There’s just something about, like, merging your own PR that, like, I’m sure you’ve tested it, but, like, who knows what you might have missed, kind of thing. And so just, like, a quick sanity check from someone else is usually… like, a hotfix is one thing, and we can always, like, you know, revisit it.
122 00:10:23.990 ⇒ 00:10:31.429 Samuel Roberts: But yeah, I think for… for most small things, just, like, just get someone else’s eyes on it. If it’s going into staging, at least. And I think what…
123 00:10:31.980 ⇒ 00:10:40.910 Samuel Roberts: well, this kind of gets to a little bit more of the StackDiff stuff I want to try to maybe move us towards eventually. I haven’t really worked that way yet, but I’ve been reading about it, and it looks…
124 00:10:41.080 ⇒ 00:10:43.280 Samuel Roberts: Pretty nice.
125 00:10:44.290 ⇒ 00:10:51.579 Samuel Roberts: But we don’t have to talk about that right now. The only other thing I wanted to say about that is the overall flow will probably be…
126 00:10:51.990 ⇒ 00:10:55.859 Samuel Roberts: Yeah, merging these changes in, I…
127 00:10:56.410 ⇒ 00:11:04.859 Samuel Roberts: I don’t know, I don’t love the idea of big PRs until we get to that stack stuff, but we might just have to do that way, like, into staging is, like, a decent-sized PR, but maybe we have more…
128 00:11:05.160 ⇒ 00:11:07.529 Samuel Roberts: You know, stable branches that we merge in.
129 00:11:07.900 ⇒ 00:11:12.360 Samuel Roberts: So, like… I don’t know. We’ll sort it out over time.
130 00:11:12.960 ⇒ 00:11:16.749 Samuel Roberts: But I think, yeah, the smaller they can be, the more contained they can be is always good.
131 00:11:16.950 ⇒ 00:11:20.360 Samuel Roberts: Obviously it’s not always doable, but…
132 00:11:20.830 ⇒ 00:11:28.059 Samuel Roberts: yeah, other eyes on it is always, always good, and unless there’s, like, a crazy, you know, kind of emergency, I would say.
133 00:11:28.370 ⇒ 00:11:29.549 Pranav Narahari: Yeah, that makes sense.
134 00:11:29.550 ⇒ 00:11:32.250 Samuel Roberts: Especially because there’s, like, 3 of us now. If it was just, like…
135 00:11:32.470 ⇒ 00:11:37.479 Samuel Roberts: You know, two of us, it might be a little harder to, like, make sure the other person sees it, but if there’s, you know.
136 00:11:37.710 ⇒ 00:11:48.580 Samuel Roberts: if, like, if you’re making this PR, either one of us can kind of take a look at it. If it’s small, and if it’s big, then, you know, it’s probably not a, like, gotta happen this moment kind of thing. It’s, like, something we’ve been working on, so hopefully that’s…
137 00:11:48.990 ⇒ 00:11:56.750 Samuel Roberts: hopefully that’s a good system, and again, it can change. We’re not a huge team that it takes forever to make changes to processes, so…
138 00:11:57.080 ⇒ 00:11:59.910 Pranav Narahari: Right, yeah. I like the idea of, like…
139 00:12:00.170 ⇒ 00:12:06.049 Pranav Narahari: you know, we kind of had to hit deadlines, too, so, like, let’s try to be as safe as possible to hit those deadlines. So, like.
140 00:12:06.050 ⇒ 00:12:07.000 Samuel Roberts: Yeah.
141 00:12:07.000 ⇒ 00:12:10.730 Pranav Narahari: We’re doing a good job of hitting deadlines, so let’s try to increase safety.
142 00:12:10.910 ⇒ 00:12:11.490 Samuel Roberts: Totally.
143 00:12:11.810 ⇒ 00:12:17.869 Pranav Narahari: Yeah, we can always kind of, like, find what that balance is and change the…
144 00:12:17.970 ⇒ 00:12:19.599 Pranav Narahari: Change the process in the future.
145 00:12:19.910 ⇒ 00:12:27.830 Samuel Roberts: Definitely. The other side of this is just, like, testing in general, and making sure that, like, you know, we have a little more automated way to know we’re not making any breaking changes.
146 00:12:29.580 ⇒ 00:12:35.569 Samuel Roberts: Which we haven’t really discussed yet, it’s not really even kind of on the statement of work as much as I remember.
147 00:12:36.100 ⇒ 00:12:45.309 Samuel Roberts: But that is partially the, like, move fast kind of thing anyway. But there’s definitely, like, a few things we probably want to make sure that, like, we just don’t accidentally break
148 00:12:45.730 ⇒ 00:12:46.579 Samuel Roberts: You know.
149 00:12:46.940 ⇒ 00:12:55.989 Samuel Roberts: chat, or, you know, the MCPs, or whatever it is that we want to try to do. So that might be something worth thinking about, this week even, but…
150 00:12:57.130 ⇒ 00:12:58.899 Pranav Narahari: We can kick that down the road.
151 00:12:59.260 ⇒ 00:13:00.340 Pranav Narahari: Yeah.
152 00:13:00.340 ⇒ 00:13:03.150 Samuel Roberts: So let’s actually talk what we’re here to talk about today.
153 00:13:03.550 ⇒ 00:13:06.240 Samuel Roberts: So…
154 00:13:06.570 ⇒ 00:13:12.649 Samuel Roberts: I don’t know if you guys have thoughts on this yet. I did a little bit of digging into Shopify’s API.
155 00:13:14.080 ⇒ 00:13:18.840 Samuel Roberts: So I have some stuff to report on that, but I just wanted to hear y’all’s thoughts before I jump into that.
156 00:13:19.840 ⇒ 00:13:22.539 Pranav Narahari: I mostly just have, like, questions. Yeah.
157 00:13:22.940 ⇒ 00:13:32.670 Pranav Narahari: So, with this data warehouse, is it primarily for storing Shopify data, or is it also going to be integrated with these other, like, ads platforms, like Klaviyo data?
158 00:13:35.550 ⇒ 00:13:40.140 Samuel Roberts: Yeah, I think, long-term, it’s definitely gonna be everything.
159 00:13:40.420 ⇒ 00:13:41.070 Pranav Narahari: Okay.
160 00:13:41.630 ⇒ 00:13:42.740 Samuel Roberts: the…
161 00:13:42.840 ⇒ 00:13:49.179 Samuel Roberts: the question right now is that kind of, like, for the proof of concept for the MVP, what is…
162 00:13:49.400 ⇒ 00:13:53.000 Samuel Roberts: Most critical, and not gonna, like, shoot us in the foot down the road.
163 00:13:53.000 ⇒ 00:13:53.880 Pranav Narahari: Totally, yeah.
164 00:13:55.320 ⇒ 00:14:03.149 Samuel Roberts: And so, like, I also don’t want to, like, you know, get hung up on, like, finding the right database and the ETL. Like, I kind of want to move quickly with the POC, at least.
165 00:14:05.010 ⇒ 00:14:11.140 Samuel Roberts: But yeah, eventually it’s going to be everything, and that’s where a lot of this metric stuff will be generated from, rather than hitting the API every time.
166 00:14:11.410 ⇒ 00:14:14.150 Samuel Roberts: Which I think is a good strategy. You know, I mean.
167 00:14:14.280 ⇒ 00:14:17.640 Samuel Roberts: We definitely have a, like, a data focus, like.
168 00:14:18.300 ⇒ 00:14:22.280 Samuel Roberts: Overall, like, company-wise, like, that’s sort of how the company, you know, the…
169 00:14:22.710 ⇒ 00:14:26.400 Samuel Roberts: genesis of the company is more data than the AI stuff, so, like.
170 00:14:26.590 ⇒ 00:14:39.030 Samuel Roberts: it’s good that we have the expertise if we need to, like, bounce ideas off people, but to move quickly this week, I’m not sure how we want to do it. But I think eventually it’s going to be everything. And then with the ability to potentially add more, who knows, you know, if they’re going to pull in other sources later, but…
171 00:14:39.370 ⇒ 00:14:45.280 Samuel Roberts: I think for those, you know, they want forecasting for, like, all the platforms eventually, so…
172 00:14:46.430 ⇒ 00:14:50.990 Pranav Narahari: Gotcha, okay. But, so, for Phase 2, the forecasting, like…
173 00:14:51.280 ⇒ 00:14:57.750 Pranav Narahari: that dashboard, from what I remember, is mostly Shopify data-related, right? It’s not really…
174 00:14:57.940 ⇒ 00:15:01.010 Pranav Narahari: It doesn’t really need to have…
175 00:15:01.380 ⇒ 00:15:05.039 Pranav Narahari: Data in the data warehouse from other… other places.
176 00:15:05.040 ⇒ 00:15:06.170 Samuel Roberts: I don’t…
177 00:15:06.870 ⇒ 00:15:15.589 Samuel Roberts: think it’s, if anything, it’s not the very beginning of Phase 2. I’m trying to see. I actually realized I don’t have the newest
178 00:15:16.560 ⇒ 00:15:26.959 Samuel Roberts: Shopify CAC by channel revenue target, yeah, editable inputs, that’s right, yeah. I think this is just Shopify, data pipeline is further down the road.
179 00:15:28.220 ⇒ 00:15:37.820 Samuel Roberts: It’s listed here in the MVP, but that might be the old one, because I think I’m on a… we had to merge the main branch into other things, so we have all the PRDs, but let me see what I got here in main.
180 00:15:41.470 ⇒ 00:15:42.470 Pranav Narahari: Yeah, for sure.
181 00:15:42.470 ⇒ 00:15:42.910 Samuel Roberts: Ms.
182 00:15:42.910 ⇒ 00:15:46.670 Pranav Narahari: Or you can look at the Gantt chart, too, to just see, like, the…
183 00:15:46.750 ⇒ 00:15:48.159 Samuel Roberts: Oh, thank you, yeah.
184 00:15:48.760 ⇒ 00:15:53.950 Samuel Roberts: I, for some reason, don’t think of a Gantt chart. I just immediately went to GitHub and looked at the statement of work.
185 00:15:53.950 ⇒ 00:15:58.100 Pranav Narahari: Yeah, I wish everything was in GitHub. Basically, everything is, except for the Gantt.
186 00:15:58.100 ⇒ 00:16:04.100 Samuel Roberts: That’s… I would love to figure that. That’s a whole other, you know, not Lilo thing specifically, but, like, if there’s a good way to…
187 00:16:04.950 ⇒ 00:16:12.670 Samuel Roberts: do Gantz that was user-friendly enough for other people to use it, but also, like, code-based, so we could use cursor.
188 00:16:12.790 ⇒ 00:16:16.790 Samuel Roberts: Would be… a game changer.
189 00:16:17.390 ⇒ 00:16:20.289 Samuel Roberts: Yeah. …it them, we could have changes there, we could also…
190 00:16:21.150 ⇒ 00:16:27.470 Samuel Roberts: you know, map things out differently. Yeah, anyway. Okay, so I’m looking at, Instagant…
191 00:16:28.720 ⇒ 00:16:30.760 Samuel Roberts: This is all updated with the most recent.
192 00:16:31.870 ⇒ 00:16:35.580 Pranav Narahari: Yeah, Utam said that he updated… updated this. Okay.
193 00:16:37.580 ⇒ 00:16:41.620 Pranav Narahari: I mean, maybe it’s worth just, like, double-checking with him, but it looks updated to me, like…
194 00:16:41.620 ⇒ 00:16:43.080 Samuel Roberts: Yeah, I just want to pull up the ad.
195 00:16:43.080 ⇒ 00:16:48.860 Pranav Narahari: aiming for some stuff, so, like, I assume he’s updated everything there.
196 00:16:49.100 ⇒ 00:16:53.609 Samuel Roberts: Okay, yeah, let me just go make sure the SOW makes sense here, too, then.
197 00:16:54.730 ⇒ 00:16:56.659 Samuel Roberts: Yeah, I mean, I think…
198 00:16:59.820 ⇒ 00:17:03.840 Samuel Roberts: Oh, that’s why we have these in parallel, isn’t it? The basic forecasting pacing model.
199 00:17:04.280 ⇒ 00:17:05.800 Samuel Roberts: And the data warehouse.
200 00:17:07.980 ⇒ 00:17:08.859 Samuel Roberts: Okay.
201 00:17:09.880 ⇒ 00:17:13.540 Samuel Roberts: I’m sorry, I can share screen, I realize I’m looking at something you guys aren’t looking at.
202 00:17:18.520 ⇒ 00:17:25.880 Samuel Roberts: So… Yeah, we’re talking data warehouse setup, basic forecasting model.
203 00:17:26.130 ⇒ 00:17:26.710 Pranav Narahari: Yup.
204 00:17:26.990 ⇒ 00:17:30.050 Samuel Roberts: Pacing Dashboard POC completes by… yeah.
205 00:17:34.230 ⇒ 00:17:43.049 Samuel Roberts: Yeah, okay. So I think… Okay, here’s my overall thoughts on this. I think the data warehouse is…
206 00:17:44.710 ⇒ 00:17:49.090 Samuel Roberts: gonna be important? I’m just not sure how important it is for the proof of concept,
207 00:17:52.380 ⇒ 00:18:00.000 Samuel Roberts: At least to get it in a way that’s gonna work for… multiple… Sources?
208 00:18:01.440 ⇒ 00:18:05.800 Samuel Roberts: Let me share with what I got about Shopify stuff, because that might help guide this a little bit.
209 00:18:05.950 ⇒ 00:18:06.990 Pranav Narahari: Okay.
210 00:18:09.050 ⇒ 00:18:13.899 Samuel Roberts: where is that tab now? I actually was… it was kind of neat, Shopify…
211 00:18:14.970 ⇒ 00:18:18.429 Samuel Roberts: Shopify’s Docs has a nice little AI chat assistant.
212 00:18:18.980 ⇒ 00:18:19.810 Pranav Narahari: Oh, nice.
213 00:18:19.810 ⇒ 00:18:29.920 Samuel Roberts: And it… it was… Oh, crap, hold on. Too many monitors, or too many, desktops.
214 00:18:29.920 ⇒ 00:18:32.450 Pranav Narahari: Quad has a similar thing, and so when I was, like.
215 00:18:32.730 ⇒ 00:18:42.129 Pranav Narahari: working through some bugs when I was onboarding, like, Bobby and Zach into, like, their vibe coding environments. Like, I was like, I don’t know exactly where to find this, but let me just ask the chatbot.
216 00:18:42.130 ⇒ 00:18:49.920 Samuel Roberts: Yeah! So, like, this, like, gave me code to do what I was trying to, like, export. So, I started up here…
217 00:18:49.920 ⇒ 00:18:50.260 Pranav Narahari: Yeah.
218 00:18:50.260 ⇒ 00:19:00.129 Samuel Roberts: Ignore the… ignore the actual page I’m on, but the chat here, which is a little hard to scroll through a bunch of stuff. I basically was like, I looked at, kind of, the…
219 00:19:01.380 ⇒ 00:19:10.819 Samuel Roberts: the spreadsheet over here, because this is kind of what we’re, you know, wanting to pull from. And so I was like, what… what does it need from Shopify, right? And so there’s just an order exports.
220 00:19:11.330 ⇒ 00:19:20.360 Samuel Roberts: you know, export all orders, and I was like, alright, how do we get that from the API? And it was like, you’re going to want to use the bulk, everything’s GraphQL now through Shopify.
221 00:19:21.370 ⇒ 00:19:25.560 Samuel Roberts: But there’s a bulk way to do it, and it gave me a whole mutation to call.
222 00:19:25.810 ⇒ 00:19:26.250 Pranav Narahari: Gotcha.
223 00:19:26.250 ⇒ 00:19:31.909 Samuel Roberts: Which was pretty nice. Very much overkill, and I immediately was like, we don’t need all this address information.
224 00:19:32.100 ⇒ 00:19:34.469 Samuel Roberts: It cut it down for me.
225 00:19:36.650 ⇒ 00:19:37.540 Pranav Narahari: Wow.
226 00:19:37.540 ⇒ 00:19:44.219 Samuel Roberts: And then I was just like, we’re doing a cohort analysis. What do we actually need? And it cut it down to just the orders and the customer information.
227 00:19:45.480 ⇒ 00:19:52.069 Samuel Roberts: as a bulk operation, so it’ll basically give you a URL that you can download the JSONL that’s going to be generated here.
228 00:19:52.230 ⇒ 00:19:53.179 Pranav Narahari: Oh, sick, yeah.
229 00:19:53.180 ⇒ 00:19:57.939 Samuel Roberts: And then it was, tell me your stack and I’ll tune it further.
230 00:19:58.100 ⇒ 00:20:07.269 Samuel Roberts: And so I explained, like, we only want, like, the last two years for now, so just threw that into the query, because I’m not super comfortable with GraphQL,
231 00:20:07.570 ⇒ 00:20:09.209 Samuel Roberts: Like, I can, you know…
232 00:20:09.400 ⇒ 00:20:23.459 Samuel Roberts: I know what it is when I see it, but I wouldn’t have known exactly where to throw that in. Haven’t done a ton of GraphQL, I’ll say. And then… I was just like, yeah, we would node with TypeScript, and it gave me this whole file for just doing this mutation.
233 00:20:23.820 ⇒ 00:20:26.689 Samuel Roberts: Downloading the bulk operation.
234 00:20:27.730 ⇒ 00:20:31.070 Samuel Roberts: running this… with the Shopify API.
235 00:20:32.450 ⇒ 00:20:37.659 Samuel Roberts: And then… somewhere down here, it says…
236 00:20:38.810 ⇒ 00:20:41.169 Samuel Roberts: This is where you’d load it into the database.
237 00:20:42.840 ⇒ 00:20:44.750 Samuel Roberts: So,
238 00:20:45.040 ⇒ 00:20:53.260 Samuel Roberts: I think the question I have here is, like, yeah, like, how do we want to store this right now? How do we want to store it long-term? Is it worth getting a database
239 00:20:53.520 ⇒ 00:20:56.109 Samuel Roberts: For, like, an actual warehouse stood up.
240 00:20:56.330 ⇒ 00:20:59.429 Samuel Roberts: to put the Shopify data in.
241 00:20:59.920 ⇒ 00:21:05.209 Samuel Roberts: you know, we could just throw this into Postgres for now, but I feel like if we’re gonna do that, it’s just kind of a stopgap for, like.
242 00:21:05.420 ⇒ 00:21:07.670 Samuel Roberts: a week, maybe, you know? Yeah.
243 00:21:07.800 ⇒ 00:21:09.580 Samuel Roberts: So it’s probably not worth it.
244 00:21:10.010 ⇒ 00:21:13.069 Samuel Roberts: That’s my current thoughts.
245 00:21:14.110 ⇒ 00:21:29.120 Pranav Narahari: Yeah, I think it makes sense to set up the data warehouse now, just because, yeah, we may not be integrating more than just Shopify, but we’ll still be integrating a lot of different brands, different models, like, whether it’s subscription or not subscription.
246 00:21:29.120 ⇒ 00:21:36.579 Pranav Narahari: And so, with proof of concept, just showing that, okay, we can, like, get data into the data warehouse, and then on…
247 00:21:36.980 ⇒ 00:21:45.269 Pranav Narahari: like… onload of that, forecasting page, we’re able to get that data from the data warehouse.
248 00:21:46.690 ⇒ 00:21:48.250 Samuel Roberts: Yeah. Okay.
249 00:21:48.640 ⇒ 00:21:52.349 Samuel Roberts: Yeah, I think that’s probably true. The question then becomes, like.
250 00:21:52.850 ⇒ 00:21:59.720 Samuel Roberts: what warehouse, how do we do it? Casey, have you done much stuff data-wise? Like, setting up a warehouse or anything?
251 00:22:00.690 ⇒ 00:22:08.110 Casie Aviles: I do know that we have BigQuery for the warehouse, and that’s also kind of what we’re doing with
252 00:22:08.720 ⇒ 00:22:12.410 Casie Aviles: ABC… We have it set up there.
253 00:22:13.340 ⇒ 00:22:19.650 Casie Aviles: Or I think… Yeah, a snowflake, I guess? Yeah, that’s also another one.
254 00:22:19.650 ⇒ 00:22:25.940 Samuel Roberts: Yeah, Snowflake’s the one I was kind of thinking of, because I’ve touched that a little more than I’ve touched BigQuery, but…
255 00:22:27.500 ⇒ 00:22:33.440 Samuel Roberts: I’m… this is a little outside my wheelhouse in terms of, like, which is the better one for this use case.
256 00:22:33.720 ⇒ 00:22:39.010 Samuel Roberts: Have you… you’ve checked both of them, Casey?
257 00:22:40.360 ⇒ 00:22:45.779 Casie Aviles: Yeah, I think… BigQuery is…
258 00:22:46.370 ⇒ 00:22:48.879 Casie Aviles: It feels a little more…
259 00:22:49.160 ⇒ 00:22:55.319 Casie Aviles: what’s, what’s, like, the right term? I don’t know if it’s, like, overkill or… Okay. …what, but…
260 00:22:56.330 ⇒ 00:23:03.039 Casie Aviles: It’s what also Eden is using. They have a lot of, like, data there, you know, for… from…
261 00:23:03.860 ⇒ 00:23:07.329 Casie Aviles: The pipelines that they have.
262 00:23:07.410 ⇒ 00:23:09.249 Samuel Roberts: But I think Snowflake was…
263 00:23:09.750 ⇒ 00:23:15.130 Casie Aviles: working fine, but I don’t kind of want to just put it into
264 00:23:15.870 ⇒ 00:23:21.650 Casie Aviles: like, I don’t know if it makes sense to have, like, different kinds of warehouses.
265 00:23:21.650 ⇒ 00:23:22.030 Samuel Roberts: Yeah.
266 00:23:22.030 ⇒ 00:23:27.800 Casie Aviles: Like, I don’t know, like, I don’t have, like, a clear picture yet of, like, trade-offs, if we choose.
267 00:23:27.800 ⇒ 00:23:29.640 Samuel Roberts: Same. Yeah, I think we need to.
268 00:23:29.640 ⇒ 00:23:31.220 Casie Aviles: warehouse over the other.
269 00:23:31.220 ⇒ 00:23:36.849 Samuel Roberts: Loop someone in that has a little more expertise on, like, the right warehouses for this purpose.
270 00:23:37.150 ⇒ 00:23:40.509 Samuel Roberts: I would say…
271 00:23:42.830 ⇒ 00:23:48.650 Samuel Roberts: Yeah, so I mean, I think I added Lutamo as an optional here, but it looked like he had something at the same time, so I don’t think…
272 00:23:50.570 ⇒ 00:24:00.229 Samuel Roberts: Okay, I think a good path forward then, because this is pretty… Where was it? Sorry, I just lost my window. I looked at the calendar and threw everything off.
273 00:24:01.300 ⇒ 00:24:06.300 Samuel Roberts: I kind of want to almost want to try this out and see if we can get this data working, because that was, like…
274 00:24:06.540 ⇒ 00:24:12.100 Samuel Roberts: You know, if this script does what we need, and we can pull out the right stuff here.
275 00:24:12.840 ⇒ 00:24:16.129 Samuel Roberts: That’s, like, a good chunk of the way towards getting the data.
276 00:24:16.800 ⇒ 00:24:21.200 Pranav Narahari: Yeah, and that is one of the tests that we just need to do for the POC, just, like, whether.
277 00:24:21.200 ⇒ 00:24:30.450 Samuel Roberts: Yeah. Within a CSV, whether you load it into a Postgres database. That’s kind of what I’m thinking. I’m thinking that maybe we just set up another database for now.
278 00:24:30.750 ⇒ 00:24:32.489 Samuel Roberts: In railway.
279 00:24:32.740 ⇒ 00:24:36.079 Samuel Roberts: So it’s separated from the, like, the transactional data?
280 00:24:36.590 ⇒ 00:24:44.169 Samuel Roberts: And then… make a decision about the warehouse with some input from, like, Utam or Awash, or…
281 00:24:44.530 ⇒ 00:24:49.649 Samuel Roberts: Whoever we feel is the… Person that would give us the best advice here.
282 00:24:50.200 ⇒ 00:24:53.829 Pranav Narahari: Yeah, I think, yeah, maybe if we want to schedule another call with Awash?
283 00:24:53.830 ⇒ 00:24:55.040 Samuel Roberts: And, like…
284 00:24:55.100 ⇒ 00:24:59.190 Pranav Narahari: In Utah, like, that sounds good to me. And we can just kind of, like.
285 00:24:59.330 ⇒ 00:25:03.229 Pranav Narahari: Give them context on the project, and then they can probably answer our questions, and…
286 00:25:03.490 ⇒ 00:25:17.919 Samuel Roberts: Yeah, I mean, the easiest thing might just be to, like, after this meeting, post on the Slack, and just be like, you know, hey, Tom, we talked about it a little bit, when we don’t feel like we have the expertise between, you know, Snowflake, or Inquiry, or he mentioned DuckDB,
287 00:25:18.170 ⇒ 00:25:19.969 Samuel Roberts: Mother Duck, like…
288 00:25:21.380 ⇒ 00:25:26.189 Samuel Roberts: you know, I don’t know how much data is really gonna come from the test one, at least. You know, I don’t know…
289 00:25:27.690 ⇒ 00:25:34.540 Samuel Roberts: So that might be something to figure out, like, what is this…
290 00:25:34.920 ⇒ 00:25:40.960 Samuel Roberts: how much data are we gonna get for the last 2 years? Because these are, you know, could be millions of bros, potentially, for some of these brands, so…
291 00:25:41.090 ⇒ 00:25:43.140 Samuel Roberts: Okay.
292 00:25:43.370 ⇒ 00:25:45.109 Samuel Roberts: Let’s, yeah.
293 00:25:45.370 ⇒ 00:25:50.589 Pranav Narahari: For this, the POC, I think we should, the idea is just to…
294 00:25:50.700 ⇒ 00:25:59.429 Pranav Narahari: the proof of concept for just one brand. Yeah. So, if there’s a way to even, like, filter just a specific brand, like New & Golf or whatever.
295 00:25:59.630 ⇒ 00:26:03.440 Samuel Roberts: Yeah, well, this is… this should just be pulling from one Shopify store at a given time.
296 00:26:03.440 ⇒ 00:26:04.760 Pranav Narahari: Oh, perfect. Okay.
297 00:26:04.760 ⇒ 00:26:09.469 Samuel Roberts: So that’s… this will have to tie into the access tokens that we have stored and everything.
298 00:26:09.470 ⇒ 00:26:10.810 Pranav Narahari: Right.
299 00:26:10.810 ⇒ 00:26:11.240 Samuel Roberts: You know…
300 00:26:11.240 ⇒ 00:26:13.350 Pranav Narahari: is, like, specific to the store.
301 00:26:13.350 ⇒ 00:26:28.019 Samuel Roberts: Yeah, yeah, so that’s not an issue. It’ll have to be, like, a separate process running for each one, or, you know, or we aggregate those somehow and do it, but I don’t think there’s a good way to do that in bulk. I think the… yeah, the shops keep it separate and everything, so…
302 00:26:28.020 ⇒ 00:26:29.479 Pranav Narahari: Okay, that works out for me right now.
303 00:26:29.480 ⇒ 00:26:32.570 Samuel Roberts: Yeah, I think that’s perfect, so I think…
304 00:26:33.750 ⇒ 00:26:42.290 Samuel Roberts: You could probably run with that, just set up another database and dump it in there, or at least get a count of, like, how much is actually coming out. Like, I’ll just export it and see what this JSONL looks like.
305 00:26:42.890 ⇒ 00:26:44.719 Samuel Roberts: Or Mutant, probably.
306 00:26:46.130 ⇒ 00:26:48.729 Samuel Roberts: Give us a sense of, do we, you know.
307 00:26:49.440 ⇒ 00:26:53.300 Samuel Roberts: do we need the warehouse, like, ASAP, or does a Postgres on…
308 00:26:53.490 ⇒ 00:26:56.459 Samuel Roberts: Railway work for now, for building it out.
309 00:26:56.960 ⇒ 00:26:57.520 Pranav Narahari: Yup.
310 00:26:57.780 ⇒ 00:26:59.880 Samuel Roberts: Okay.
311 00:27:01.330 ⇒ 00:27:05.090 Samuel Roberts: I think that sounds good. I’m…
312 00:27:05.930 ⇒ 00:27:08.379 Samuel Roberts: Okay, actually, as I say that, I’m happy to…
313 00:27:08.510 ⇒ 00:27:17.030 Samuel Roberts: take a stab at this. I don’t know what’s on your plates right now in terms of other things, or also this. I definitely want to make sure we get
314 00:27:17.150 ⇒ 00:27:18.759 Samuel Roberts: Nano Banana…
315 00:27:19.480 ⇒ 00:27:23.229 Samuel Roberts: Well, no, the native banana is pretty good, he seemed pretty happy with it. We can probably push all that up.
316 00:27:23.370 ⇒ 00:27:25.080 Samuel Roberts: Once we get the…
317 00:27:25.930 ⇒ 00:27:35.080 Samuel Roberts: your bug fix in, Pranav. I’ll probably just do, I guess. I’ll just make sure it goes in,
318 00:27:35.670 ⇒ 00:27:40.330 Samuel Roberts: Just so we can… Get this out to production.
319 00:27:40.900 ⇒ 00:27:43.530 Samuel Roberts: You still have a few things you want to change about the reports, though, right?
320 00:27:44.110 ⇒ 00:27:52.869 Pranav Narahari: Yeah, just, like, some design stuff. Right after that, I’m just gonna send over Bobby, like, this, like, light mode version.
321 00:27:52.870 ⇒ 00:27:53.460 Samuel Roberts: Okay.
322 00:27:53.740 ⇒ 00:27:58.460 Pranav Narahari: Yeah, and then… yeah, so no rush on merging that, like, right now.
323 00:27:58.460 ⇒ 00:27:59.310 Samuel Roberts: Cool, okay.
324 00:27:59.440 ⇒ 00:28:03.409 Pranav Narahari: Yeah, in terms of, like, what we have to do, like, I’m kind of…
325 00:28:03.610 ⇒ 00:28:13.839 Pranav Narahari: How I’m thinking about things is just, like, on a milestone schedule, so we have a milestone in 3 Fridays from now, so that gives us, like… And that’s the… that’s the POC milestone, it’s not even…
326 00:28:13.840 ⇒ 00:28:17.019 Samuel Roberts: MVP, so it’s really just this one, yeah, we’re pretty good with that, I think.
327 00:28:17.020 ⇒ 00:28:20.820 Pranav Narahari: Yeah, so I have, like, all those tickets, like, in linear right now.
328 00:28:21.240 ⇒ 00:28:24.370 Samuel Roberts: Let me pull that up, too. That’ll make sense.
329 00:28:24.780 ⇒ 00:28:27.669 Pranav Narahari: I didn’t assign anything to Casey yet.
330 00:28:27.670 ⇒ 00:28:28.400 Samuel Roberts: Okay.
331 00:28:29.920 ⇒ 00:28:31.429 Pranav Narahari: I’m still kind of like…
332 00:28:31.840 ⇒ 00:28:37.569 Pranav Narahari: working through to figure out, like, what everybody’s capacity is, like, on this project, you know? Like, I know that…
333 00:28:37.700 ⇒ 00:28:44.099 Pranav Narahari: you know, Sam, you’re splitting your time with, like, ABC and this. I’m primarily on this, but I do have.
334 00:28:44.530 ⇒ 00:28:50.230 Pranav Narahari: of, like, ABC stuff, and I think Casey’s primarily ABC doing a little bit here.
335 00:28:50.230 ⇒ 00:28:51.530 Samuel Roberts: Yeah, I think that’s accurate.
336 00:28:51.530 ⇒ 00:28:53.490 Casie Aviles: Also, Eden, yeah.
337 00:28:53.490 ⇒ 00:28:54.860 Samuel Roberts: Yeah, yeah, he’s hooked.
338 00:28:54.860 ⇒ 00:28:56.519 Pranav Narahari: Okay, okay, so that’s good to know.
339 00:28:56.660 ⇒ 00:28:58.880 Samuel Roberts: Yeah, I think… oh, go ahead, sorry.
340 00:28:59.070 ⇒ 00:29:17.679 Pranav Narahari: I was just gonna say, like, yeah, so I talked to Rico, I talked to, Shaysu, who’s… who’s new here, on the ops team, and I’m trying to… this is a little bit of, like, a side thing, but trying to get them to just, like, let me know, like, what everybody’s capacity is, like, on a at least weekly basis. And also just, like.
341 00:29:17.800 ⇒ 00:29:23.820 Pranav Narahari: what… Because I don’t even fully know, like, how many hours do we even have to spend per week?
342 00:29:23.820 ⇒ 00:29:26.630 Samuel Roberts: Yeah, no, this is something that we were getting…
343 00:29:27.140 ⇒ 00:29:35.679 Samuel Roberts: pretty good at, in terms of, like, they were, you know, at the beginning of the month doing allocations, and we had a sense of it. With this kind of…
344 00:29:36.150 ⇒ 00:29:42.309 Samuel Roberts: recent… I don’t know, shift in terms of, like, organization. I don’t know if allocations…
345 00:29:42.470 ⇒ 00:29:46.689 Samuel Roberts: happened quite the same way. Yeah. So yeah, that’s something we can…
346 00:29:46.690 ⇒ 00:29:52.469 Pranav Narahari: Based on my… based on my, like, conversations with, like, Rico and Utam.
347 00:29:52.470 ⇒ 00:29:52.940 Samuel Roberts: Yeah.
348 00:29:52.940 ⇒ 00:30:02.310 Pranav Narahari: So we have another EP meeting to… in a little bit. Okay. I’ll bring it up there. All that to just say, like, yeah, so I just didn’t know, like.
349 00:30:02.620 ⇒ 00:30:20.179 Pranav Narahari: what to assign for… mostly for Casey, and then also, like, yeah, same for you, I feel like the data warehouse stuff was, like, that’s gonna be a tall task. You know, just, like, doing the research and stuff. And so… yeah, I feel like that’s why I put that on your plate for right now. That’s fine. And then…
350 00:30:20.670 ⇒ 00:30:29.769 Pranav Narahari: A lot of these things, too, maybe we can break up. I feel like this first milestone will actually… we have a lot of buffer room, which I’m happy about, so…
351 00:30:30.160 ⇒ 00:30:35.100 Pranav Narahari: Yeah, I’m not too concerned about, like, Yeah, whatever…
352 00:30:35.560 ⇒ 00:30:42.189 Pranav Narahari: like, if we have to, like, break these up into, like, smaller tasks, like, we’re gonna hit this milestone for sure. Yeah. Yeah.
353 00:30:43.560 ⇒ 00:30:48.200 Samuel Roberts: Yeah, I mean, I imagine there’ll be other things that come up as well, like fixes and changes they’re gonna wanna see, so…
354 00:30:48.200 ⇒ 00:30:49.250 Pranav Narahari: Totally.
355 00:30:49.250 ⇒ 00:30:51.070 Samuel Roberts: in. Yeah, the way…
356 00:30:51.860 ⇒ 00:30:58.380 Samuel Roberts: I mean, I would definitely, yeah, get more clarity at the EP meeting. The way I’m kind of thinking about it is, like, you’re basically, like, on this…
357 00:30:58.780 ⇒ 00:31:04.139 Samuel Roberts: full-time-ish, and with a little bit of ABC. Yeah. I’m kind of…
358 00:31:05.080 ⇒ 00:31:07.869 Samuel Roberts: on this and ABC, but I’m not…
359 00:31:07.990 ⇒ 00:31:10.710 Samuel Roberts: coding as much on ABC, I’d say, right now.
360 00:31:11.310 ⇒ 00:31:11.660 Pranav Narahari: Dodge.
361 00:31:11.660 ⇒ 00:31:13.990 Casie Aviles: So, like, my deep work can kind of go to this.
362 00:31:14.070 ⇒ 00:31:16.490 Samuel Roberts: I would say then Casey…
363 00:31:16.770 ⇒ 00:31:22.030 Samuel Roberts: It’s kind of on your call, I guess, like, how much you feel like you can take on, and so, like.
364 00:31:22.030 ⇒ 00:31:27.120 Casie Aviles: Yeah, for… Yeah. I can give an idea now. So I…
365 00:31:27.880 ⇒ 00:31:33.270 Casie Aviles: So, majority of my time was allocated for ABC, but I haven’t been allocated
366 00:31:33.490 ⇒ 00:31:36.130 Casie Aviles: To my… to the… to other clients.
367 00:31:36.130 ⇒ 00:31:37.580 Samuel Roberts: Okay. But…
368 00:31:38.030 ⇒ 00:31:43.060 Casie Aviles: For Lilo, I… I think I can do, like, 10 hours per… per week.
369 00:31:43.360 ⇒ 00:31:44.010 Pranav Narahari: Okay. Okay.
370 00:31:44.010 ⇒ 00:31:48.989 Casie Aviles: And… I think the nano Banana work is just wrapping up, so…
371 00:31:48.990 ⇒ 00:31:49.490 Samuel Roberts: Yes.
372 00:31:49.490 ⇒ 00:31:51.459 Casie Aviles: I think I can take on some…
373 00:31:51.780 ⇒ 00:31:58.729 Casie Aviles: new stuff, maybe even if it’s, you know, about the… about pulling in the data, since I’ve worked
374 00:31:59.050 ⇒ 00:32:00.520 Casie Aviles: A bit on that.
375 00:32:00.710 ⇒ 00:32:02.550 Casie Aviles: Okay. Before, you know…
376 00:32:03.000 ⇒ 00:32:03.670 Samuel Roberts: Yeah.
377 00:32:04.110 ⇒ 00:32:09.780 Samuel Roberts: Yeah, I would say… That’s… that’s pretty good. I mean, I think…
378 00:32:10.260 ⇒ 00:32:16.170 Samuel Roberts: I definitely want to, like, run this stuff that they have in our, in the Shopify thing?
379 00:32:16.220 ⇒ 00:32:22.199 Pranav Narahari: I’ll see how that goes, and I can pass that along to either one of you, I guess, to run with the Shopify data ingestion.
380 00:32:22.230 ⇒ 00:32:26.949 Samuel Roberts: I… again, there’s also gonna be things that come up that…
381 00:32:27.160 ⇒ 00:32:36.440 Samuel Roberts: you know, might not be the highest priority stuff, but I think it will also be nice. Bobby had brought up a whole thing with, like, that spreadsheet and fixes.
382 00:32:36.600 ⇒ 00:32:43.049 Samuel Roberts: Yeah. And so, I know they don’t want us slowing down for that, but I don’t really feel like, with the three of us, with this…
383 00:32:43.180 ⇒ 00:32:47.609 Samuel Roberts: milestone, we’re gonna be moving too slowly for it, so I feel like…
384 00:32:47.890 ⇒ 00:32:57.020 Samuel Roberts: I want to do a lot of those changes, and so I’m wondering, like, how we allocate other time for, like, the UI revamp, getting into light mode, you know, things like that.
385 00:32:57.210 ⇒ 00:33:01.209 Samuel Roberts: So that might be something we also want to figure out, like, maybe…
386 00:33:01.640 ⇒ 00:33:09.330 Samuel Roberts: I don’t know, it depends how much that is, like, you know, for 10 hours a week, Casey, like, maybe a lot of your stuff could just be, like, you know, pulling a few of those tickets as they pop up.
387 00:33:11.290 ⇒ 00:33:21.490 Pranav Narahari: Yeah, honestly, I wouldn’t worry about picking up another ticket, Casey, because I think those things will bring you to that 10 hours. Finishing up Nano Banana.
388 00:33:21.640 ⇒ 00:33:25.749 Pranav Narahari: Maybe, like, pushing into production, we may see something happen there.
389 00:33:25.750 ⇒ 00:33:26.570 Samuel Roberts: Yeah…
390 00:33:26.570 ⇒ 00:33:34.670 Pranav Narahari: And, yeah, with, like… and there’s enough small things to work on that’ll get you to that 10 hours. So…
391 00:33:35.150 ⇒ 00:33:39.849 Samuel Roberts: That’s kind of what I’m thinking, because that way, if something does come up with one of the other clients, and it’s like…
392 00:33:40.090 ⇒ 00:33:46.229 Samuel Roberts: you know, something should hit the fan with ABC, and you have a ton to do, like, there.
393 00:33:46.500 ⇒ 00:33:49.430 Samuel Roberts: It’s not gonna… we’re not gonna have to reshuffle anything.
394 00:33:50.760 ⇒ 00:33:52.919 Casie Aviles: Yeah. That’s sort of my thought right now.
395 00:33:54.560 ⇒ 00:33:59.190 Samuel Roberts: But yeah, I mean, I, you know, I don’t wanna… I also want you guys, like, working on, you know, cool things, and I don’t want to.
396 00:33:59.190 ⇒ 00:34:00.050 Pranav Narahari: Yeah, I was just gonna say.
397 00:34:00.050 ⇒ 00:34:03.409 Samuel Roberts: I didn’t know anyone, so, I would say for maybe…
398 00:34:03.570 ⇒ 00:34:08.739 Samuel Roberts: let’s finish the nana banana stuff, and then see where we are at when I run the Shopify stuff, and get a sense of, like.
399 00:34:08.900 ⇒ 00:34:14.040 Samuel Roberts: Is this gonna be a ton to ingest? Because I think, honestly, like, I might have… if this script works.
400 00:34:14.250 ⇒ 00:34:19.290 Samuel Roberts: It might just do this, you know what I mean? Like, that might have been it.
401 00:34:19.290 ⇒ 00:34:23.710 Pranav Narahari: Yeah, that’s kind of the idea. Like, this was literally just to, like, download data for this test.
402 00:34:23.710 ⇒ 00:34:30.729 Samuel Roberts: Yeah, so I’m gonna… I’m gonna just run this, it might be a little… I have to jump through a few hoops to get the right API key and stuff out. Oh, no, we have that…
403 00:34:30.900 ⇒ 00:34:32.790 Samuel Roberts: stored in…
404 00:34:33.179 ⇒ 00:34:41.589 Samuel Roberts: 1Password, so I don’t even need to, like, decrypt anything right now. So I’ll give this a try, probably after this meeting, and just see how many lines we’ve got to deal with here.
405 00:34:41.710 ⇒ 00:34:48.020 Samuel Roberts: I would say let’s also make a post, like I said, about, You know, just…
406 00:34:48.130 ⇒ 00:34:52.020 Samuel Roberts: maybe tagging Utam and Awash. Utam definitely has, like, more…
407 00:34:52.400 ⇒ 00:34:58.319 Samuel Roberts: Context already, so he might be the best person to, like… really ask,
408 00:34:58.890 ⇒ 00:35:01.539 Samuel Roberts: And he knows the warehouses pretty well.
409 00:35:02.600 ⇒ 00:35:09.029 Pranav Narahari: Okay, yeah, did you… did you wanna start that thread in, engineering? Or did you want me to do that?
410 00:35:09.750 ⇒ 00:35:13.609 Pranav Narahari: Yeah, I’m happy to… I’m happy to type something up real quick, just to start a thread.
411 00:35:13.680 ⇒ 00:35:14.560 Samuel Roberts: Cool.
412 00:35:15.020 ⇒ 00:35:20.910 Samuel Roberts: I would say, yeah, focus on the… the reports…
413 00:35:21.260 ⇒ 00:35:25.560 Samuel Roberts: Yeah. …visuals, and hopefully if we can get that knocked out, what time are we at today? We are at…
414 00:35:25.730 ⇒ 00:35:31.790 Samuel Roberts: 3.30 Eastern, so I’m out of here at 5. But…
415 00:35:33.410 ⇒ 00:35:34.040 Pranav Narahari: Yeah.
416 00:35:34.040 ⇒ 00:35:38.780 Samuel Roberts: production, so I don’t know… Yeah, I mean, you guys can also do it after.
417 00:35:39.700 ⇒ 00:35:40.290 Pranav Narahari: Yup.
418 00:35:40.870 ⇒ 00:35:42.239 Samuel Roberts: Casey, did you put a hand up?
419 00:35:42.990 ⇒ 00:35:47.589 Casie Aviles: Oh, yeah, I was just going to ask a question about the ingestion.
420 00:35:47.780 ⇒ 00:35:48.450 Samuel Roberts: Sure.
421 00:35:49.880 ⇒ 00:35:56.159 Casie Aviles: So right now, are we going to, like, write our own congestion for Shopify?
422 00:35:57.430 ⇒ 00:36:02.999 Samuel Roberts: I think for now, yeah, that’s kind of what… like, it kind of threw this together already here, and I want to see how it looks.
423 00:36:03.670 ⇒ 00:36:04.360 Casie Aviles: Okay.
424 00:36:04.360 ⇒ 00:36:08.220 Samuel Roberts: Because for this data, it’s not a ton, it’s just orders, we’re not getting…
425 00:36:08.670 ⇒ 00:36:15.219 Samuel Roberts: all the customers and stuff right now. I think long-term, that might not be the right solution, but for this forecast…
426 00:36:15.220 ⇒ 00:36:15.630 Casie Aviles: testing.
427 00:36:15.630 ⇒ 00:36:20.479 Samuel Roberts: stuff, I think… Yeah. Especially for POC, but go ahead.
428 00:36:20.480 ⇒ 00:36:27.929 Casie Aviles: Yeah, that makes sense, because it’s just something that, you know, that was… Similar in…
429 00:36:28.310 ⇒ 00:36:34.870 Casie Aviles: And so on, like, before, where we also built a lot of, like, custom ingestion, but…
430 00:36:35.510 ⇒ 00:36:39.090 Casie Aviles: Eventually, we, we went with…
431 00:36:39.490 ⇒ 00:36:41.950 Casie Aviles: with a tool, I think we have…
432 00:36:42.520 ⇒ 00:36:47.180 Casie Aviles: polyatomic or airbite, I think that’s what you were looking into, right?
433 00:36:47.490 ⇒ 00:36:53.039 Samuel Roberts: Yeah, yeah, the, the Leo guys have mentioned there about a few times, so I think that’s another thing. I think long-term, we want to kind of…
434 00:36:53.500 ⇒ 00:36:56.160 Samuel Roberts: Move to that for data that is…
435 00:36:56.420 ⇒ 00:36:59.880 Samuel Roberts: the right way to… like, I want to do things the right way long-term,
436 00:37:00.520 ⇒ 00:37:04.380 Samuel Roberts: But for now, for, like, one brand of Shopify data, I’m not as concerned.
437 00:37:04.610 ⇒ 00:37:05.680 Casie Aviles: Yeah, that makes sense.
438 00:37:05.680 ⇒ 00:37:09.590 Samuel Roberts: But yeah, you’re right, I mean, maintaining that stuff is not where we want to be. We want to be focusing on the…
439 00:37:10.090 ⇒ 00:37:11.930 Samuel Roberts: the outputs here.
440 00:37:13.540 ⇒ 00:37:14.270 Casie Aviles: Right.
441 00:37:14.520 ⇒ 00:37:18.439 Samuel Roberts: I think that’s… it’s good to bring up, though, because you’re right, I don’t want to…
442 00:37:18.950 ⇒ 00:37:24.399 Samuel Roberts: Okay. Yeah, I think I will get this going just to see what the data looks like for Newton, at least.
443 00:37:25.340 ⇒ 00:37:32.979 Samuel Roberts: And then… I’ll post on, yeah, engineering and see what chat we can get up going.
444 00:37:33.120 ⇒ 00:37:37.529 Samuel Roberts: Any other thoughts, I guess?
445 00:37:37.660 ⇒ 00:37:39.939 Samuel Roberts: Other questions, things we had to discuss?
446 00:37:40.480 ⇒ 00:37:43.919 Samuel Roberts: Have you looked at the…
447 00:37:44.800 ⇒ 00:37:47.980 Samuel Roberts: Like, the cohort analysis and stuff that was in there.
448 00:37:48.190 ⇒ 00:37:48.750 Samuel Roberts: the.
449 00:37:48.750 ⇒ 00:37:49.430 Pranav Narahari: No.
450 00:37:49.740 ⇒ 00:37:51.870 Samuel Roberts: Be it where it was called? No. Okay.
451 00:37:52.140 ⇒ 00:37:54.450 Pranav Narahari: Yeah, that Colab notebook, right?
452 00:37:54.680 ⇒ 00:37:55.720 Samuel Roberts: Yeah, yeah.
453 00:37:56.090 ⇒ 00:37:58.259 Pranav Narahari: Yeah, not yet. I was just gonna…
454 00:37:58.620 ⇒ 00:38:00.759 Pranav Narahari: Yeah, finish up the first thing, and then…
455 00:38:00.760 ⇒ 00:38:01.350 Samuel Roberts: that…
456 00:38:01.350 ⇒ 00:38:01.880 Pranav Narahari: Tackle this.
457 00:38:03.380 ⇒ 00:38:06.799 Samuel Roberts: Hold on, is this… yeah, is this the… right? This gave me everything here.
458 00:38:07.050 ⇒ 00:38:10.409 Samuel Roberts: I’m just gonna post this doc into that ticket, so…
459 00:38:10.410 ⇒ 00:38:11.639 Pranav Narahari: Okay, perfect.
460 00:38:11.870 ⇒ 00:38:16.880 Samuel Roberts: Just for reference, okay.
461 00:38:17.540 ⇒ 00:38:22.830 Samuel Roberts: Yeah, I think… you know, we’re kind of making these trade-offs between, like, quick and
462 00:38:23.360 ⇒ 00:38:27.750 Samuel Roberts: you know, the right way. I think definitely long-term ETL is the way to go.
463 00:38:28.210 ⇒ 00:38:32.219 Samuel Roberts: It’ll be… but I want to get this data in so we can at least start doing this kind of stuff on it.
464 00:38:32.450 ⇒ 00:38:33.740 Casie Aviles: Yep. Yep.
465 00:38:34.720 ⇒ 00:38:35.330 Samuel Roberts: Okay.
466 00:38:36.550 ⇒ 00:38:40.070 Samuel Roberts: And if… what else? What else? While we’re all here, what else can we…
467 00:38:46.650 ⇒ 00:38:49.420 Samuel Roberts: Alright, just clicking through, trying to make sure I remember all this stuff.
468 00:38:51.820 ⇒ 00:38:57.889 Samuel Roberts: Okay. Yeah, I think… When this says to-do and Cycle, this is, like, everything for the…
469 00:38:59.870 ⇒ 00:39:01.829 Samuel Roberts: Up through the milestone?
470 00:39:02.050 ⇒ 00:39:03.929 Pranav Narahari: Yeah, that’s how I would say it.
471 00:39:04.350 ⇒ 00:39:06.819 Samuel Roberts: Okay, cool, yeah, alright, so that’s… I just wasn’t sure if there was.
472 00:39:07.330 ⇒ 00:39:07.870 Pranav Narahari: Yeah.
473 00:39:07.870 ⇒ 00:39:12.230 Samuel Roberts: like, something else after this for next week. I was like, alright, I think, yeah, I see what you’re saying now.
474 00:39:12.230 ⇒ 00:39:18.029 Pranav Narahari: Yeah, we get a little bit of a, you know, we can hop off the accelerator for a little bit.
475 00:39:18.030 ⇒ 00:39:22.190 Samuel Roberts: Yeah, that’s, yeah, no, I mean, there’s always a push and pull with that, but I think we’re…
476 00:39:22.310 ⇒ 00:39:25.030 Samuel Roberts: Getting to a good point when we get all this in production, and…
477 00:39:25.540 ⇒ 00:39:29.339 Samuel Roberts: Feel good about that. Yeah. Cool, okay.
478 00:39:29.950 ⇒ 00:39:32.719 Samuel Roberts: Yeah, I think that’s all I’ve really got.
479 00:39:32.720 ⇒ 00:39:33.310 Pranav Narahari: Cool.
480 00:39:34.990 ⇒ 00:39:38.629 Samuel Roberts: Other… other thoughts or concerns or anything else?
481 00:39:40.580 ⇒ 00:39:45.140 Samuel Roberts: I always feel like I’m missing something, which is why I always ask that question, because I’m like, I’m sure there’s something I’m not thinking of.
482 00:39:45.690 ⇒ 00:39:55.039 Pranav Narahari: No, I think, I feel pretty good, you know? Yeah, there are some unanswered questions for right now, like how we’ll do the data warehouse stuff.
483 00:39:55.040 ⇒ 00:39:55.620 Samuel Roberts: I don’t.
484 00:39:55.620 ⇒ 00:40:04.889 Pranav Narahari: But in terms of timeline, and like, just in terms of, like, what we need to get done this week, like, I’m still kind of thinking about, like, what’s in the internal review, which is the Slack messages, and then.
485 00:40:04.890 ⇒ 00:40:05.430 Samuel Roberts: Yes.
486 00:40:05.430 ⇒ 00:40:08.700 Pranav Narahari: banana banana stuff. So yeah, that’s why I’ve just…
487 00:40:08.980 ⇒ 00:40:16.980 Pranav Narahari: And we have, like, a pretty generous, like, timeline for the first milestone, so I feel pretty… pretty good about things.
488 00:40:16.980 ⇒ 00:40:19.390 Samuel Roberts: Yeah. Actually, while we’re on that,
489 00:40:19.630 ⇒ 00:40:26.339 Samuel Roberts: Nanobanana stuff, are we feeling good to merge that into staging now? That he said it was doing what he wanted?
490 00:40:27.370 ⇒ 00:40:30.399 Casie Aviles: Yeah, I think that’s… that’s good now, so…
491 00:40:30.400 ⇒ 00:40:31.250 Samuel Roberts: Okay.
492 00:40:31.920 ⇒ 00:40:36.160 Samuel Roberts: Yeah, I’d say go ahead and make a PR there. Oh, okay.
493 00:40:36.160 ⇒ 00:40:36.740 Casie Aviles: topic.
494 00:40:36.740 ⇒ 00:40:47.319 Samuel Roberts: Yeah, because let’s get that in staging and make sure nothing breaks there, because once we can get everything to staging, we actually have, like, no production environment, really, right now, so I just kind of want to just be like, boop, and, like, then we’re, you know.
495 00:40:48.000 ⇒ 00:40:52.960 Samuel Roberts: Good with, like, fresh stage, fresh production and everything, so…
496 00:40:53.510 ⇒ 00:40:54.650 Pranav Narahari: Yeah.
497 00:40:54.650 ⇒ 00:40:55.280 Samuel Roberts: No, no.
498 00:40:55.840 ⇒ 00:41:01.100 Samuel Roberts: Hopefully we can get that tonight, but I might… yeah, we’ll see. Either way.
499 00:41:02.080 ⇒ 00:41:11.589 Pranav Narahari: One thing that I’ve noticed, actually, that I just, is just kind of, like, in the back of the to-do list, is we don’t have a way within the UI to delete a brand.
500 00:41:11.780 ⇒ 00:41:13.070 Samuel Roberts: So… Yeah.
501 00:41:14.000 ⇒ 00:41:18.630 Pranav Narahari: We have that point, we just haven’t created, like, a button, like, on that.
502 00:41:18.630 ⇒ 00:41:31.240 Samuel Roberts: That’s fine. I did a little bit of stuff, and I did notice that, when I was redoing some of the URLs and, like, the settings and stuff. I think it added a couple things. I’m not sure if it added delete or not, but,
503 00:41:32.170 ⇒ 00:41:33.710 Samuel Roberts: I can check that real quick.
504 00:41:34.160 ⇒ 00:41:34.600 Pranav Narahari: Yeah.
505 00:41:34.600 ⇒ 00:41:38.359 Samuel Roberts: I did add, like, the edit, the name, and the URL and everything that wasn’t there before, so…
506 00:41:38.360 ⇒ 00:41:43.549 Pranav Narahari: Yeah, I saw the metadata, like, the brand, like, metadata, and, like, now.
507 00:41:43.550 ⇒ 00:41:49.689 Samuel Roberts: Yeah. Yeah, it just kind of threw that… it threw that in there, and I was like, alright, yeah, that’s… that’s fine.
508 00:41:49.820 ⇒ 00:41:53.660 Pranav Narahari: Because I’ve just been, like, putting that, like, at, like, kind of…
509 00:41:53.810 ⇒ 00:41:55.290 Pranav Narahari: The bottom of the to-do list, but…
510 00:41:55.290 ⇒ 00:42:03.000 Samuel Roberts: No, you’re absolutely right to do that. It was… honestly, if it hadn’t happened as part of that, like, whole URL thing, I wasn’t gonna worry about it, but… yeah, I would say…
511 00:42:05.720 ⇒ 00:42:20.520 Samuel Roberts: It’s not… yeah, the delete can be added if they need it. We can also just do it for… It could be nice, because QA is just like, you know, sometimes you’re trying to test something, and then that brand just exists there. True, you should see what I got locally on my database, it’s just like… do I have it running? I don’t even know if I do.
512 00:42:22.430 ⇒ 00:42:23.779 Pranav Narahari: How many brands do you got?
513 00:42:23.780 ⇒ 00:42:25.709 Samuel Roberts: Hold on, hold on, let me show you guys.
514 00:42:25.930 ⇒ 00:42:28.999 Samuel Roberts: This is my, like, local database right now.
515 00:42:29.000 ⇒ 00:42:32.770 Pranav Narahari: Okay, that’s not even too bad. It’s just test test… well, because I had a few of them, I…
516 00:42:32.770 ⇒ 00:42:34.100 Samuel Roberts: Amy ones, actually? Yeah.
517 00:42:34.390 ⇒ 00:42:38.529 Samuel Roberts: I forget which ones actually even have the keys on them. Like, I go every once in a while to, like, test something.
518 00:42:38.530 ⇒ 00:42:39.250 Pranav Narahari: Yeah.
519 00:42:39.250 ⇒ 00:42:41.560 Samuel Roberts: And it’s just, like, there’s nothing…
520 00:42:42.430 ⇒ 00:42:47.809 Pranav Narahari: Yeah, mine is just, like, test, and then the feature I’m trying to, like, test for.
521 00:42:47.810 ⇒ 00:42:54.730 Samuel Roberts: smart, yeah. This is going way back. I had to just wipe this thing at some point, but yeah, I’ll test, test, test. Anyway, okay.
522 00:42:55.040 ⇒ 00:42:57.169 Samuel Roberts: Yeah, let’s, maybe I’ll…
523 00:43:01.020 ⇒ 00:43:03.360 Pranav Narahari: It’s just something to do probably this week, like, when we, like.
524 00:43:03.360 ⇒ 00:43:04.090 Samuel Roberts: Yeah, you’re right.
525 00:43:04.090 ⇒ 00:43:09.130 Pranav Narahari: Like, we can just, it’ll be something quick, so, there’s no…
526 00:43:09.130 ⇒ 00:43:12.470 Samuel Roberts: I wouldn’t… no, that’s good, good call. That’s definitely… that might even be…
527 00:43:12.570 ⇒ 00:43:15.040 Samuel Roberts: One of the first things we push to prod after it’s.
528 00:43:15.050 ⇒ 00:43:17.089 Pranav Narahari: Yeah. Sounds good.
529 00:43:17.270 ⇒ 00:43:25.630 Samuel Roberts: Okay, yeah, so, Casey, PR for Nana Banana, I’ll hold off on the PR review for the…
530 00:43:25.850 ⇒ 00:43:29.479 Samuel Roberts: reports until I get the okay to review it from you, Pranav.
531 00:43:29.750 ⇒ 00:43:33.420 Samuel Roberts: And then hopefully we get all into staging.
532 00:43:33.650 ⇒ 00:43:37.060 Samuel Roberts: Nothing goes crazy deployment-wise, and then we just…
533 00:43:37.410 ⇒ 00:43:40.610 Samuel Roberts: Bump everything up to production, and
534 00:43:41.290 ⇒ 00:43:49.860 Samuel Roberts: you know, see how everything works, and hope that it’s good, and let them know. Whether or not that’s at 5 or not will be a question at this point, but,
535 00:43:50.880 ⇒ 00:43:51.710 Samuel Roberts: We’ll see.
536 00:43:53.840 ⇒ 00:43:54.400 Pranav Narahari: Yep.
537 00:43:54.800 ⇒ 00:43:59.320 Samuel Roberts: Yeah, I’m pretty… I have a pretty hard out at 5, because we have a new babysitter who’s headed out then, so I gotta…
538 00:43:59.320 ⇒ 00:44:04.529 Pranav Narahari: Oh, okay. Yeah, I think, you know, even if you have to log off even earlier than that, I think,
539 00:44:04.900 ⇒ 00:44:06.889 Pranav Narahari: We should be pretty good for today.
540 00:44:07.240 ⇒ 00:44:16.479 Samuel Roberts: Yeah, I think… I think so, Amy, if you… even if you guys need to… I… the only thing I wanted to do that’s not there yet is, like, I wanna… I don’t think we have an actual, like, production branch.
541 00:44:16.660 ⇒ 00:44:20.260 Samuel Roberts: We have main, and I want to kind of keep production as a separate branch.
542 00:44:20.710 ⇒ 00:44:25.610 Samuel Roberts: But we have a production one, we’ll just sync to that. Never mind, we’re good. I just want to make sure we…
543 00:44:26.150 ⇒ 00:44:32.360 Pranav Narahari: Yeah, I just realized, actually, in, external, and maybe we should just, like, figure out what we’re gonna say, is, like.
544 00:44:32.540 ⇒ 00:44:37.239 Pranav Narahari: Utam did mention, like, we discussed data at a warehouse plan this morning, team should be following up.
545 00:44:37.860 ⇒ 00:44:41.939 Samuel Roberts: Yeah, okay. I can let them know we’re gonna pull the data from Shopify and…
546 00:44:41.940 ⇒ 00:44:42.560 Pranav Narahari: Yeah.
547 00:44:42.830 ⇒ 00:44:44.099 Samuel Roberts: Start on that.
548 00:44:44.100 ⇒ 00:44:47.449 Pranav Narahari: Just letting them know, like, okay, we did talk about it, just so they’re not, like.
549 00:44:47.620 ⇒ 00:44:50.819 Pranav Narahari: like, waiting for a response there. Yeah, probably just give them, like, a… Sure.
550 00:44:51.140 ⇒ 00:44:56.769 Pranav Narahari: you know, update of, like, yeah, you know, through Shopify, we’re able to, like, run these scripts, get the data down for, like.
551 00:44:56.900 ⇒ 00:45:02.319 Pranav Narahari: Or we have a system in place for where we could get it done, even if you don’t do it today. Yeah.
552 00:45:02.540 ⇒ 00:45:04.369 Pranav Narahari: for Shopify, I think, you know.
553 00:45:04.660 ⇒ 00:45:05.700 Samuel Roberts: Yeah.
554 00:45:06.140 ⇒ 00:45:12.949 Samuel Roberts: Okay, yeah, I’ll throw a comment there, I’ll throw a comment in engineering, and I’ll wait for PR reviews.
555 00:45:13.110 ⇒ 00:45:15.970 Samuel Roberts: And then… I think we’re pretty good right now.
556 00:45:16.480 ⇒ 00:45:17.629 Pranav Narahari: Yes, sir. I think so, too.
557 00:45:17.630 ⇒ 00:45:20.889 Samuel Roberts: Alrighty, any other thoughts? Anything we missed?
558 00:45:22.980 ⇒ 00:45:24.289 Pranav Narahari: I don’t think so.
559 00:45:24.330 ⇒ 00:45:25.830 Samuel Roberts: Alright, cool.
560 00:45:25.830 ⇒ 00:45:26.310 Pranav Narahari: Yeah.
561 00:45:26.310 ⇒ 00:45:30.029 Samuel Roberts: Alright, well, yeah, I’ll still be online, like I said, I’ll be online till at least 5, so…
562 00:45:30.030 ⇒ 00:45:30.980 Pranav Narahari: Cool.
563 00:45:31.740 ⇒ 00:45:35.100 Samuel Roberts: 5 Eastern, I should say, so, just to clarify.
564 00:45:35.230 ⇒ 00:45:37.569 Samuel Roberts: Cool. Alright, well, thank you guys,
565 00:45:37.920 ⇒ 00:45:43.669 Samuel Roberts: Let me know if there’s anything I can help with, if anything comes up, but, yeah, that’s cool.
566 00:45:44.070 ⇒ 00:45:46.110 Pranav Narahari: Totally. Sounds good, guys. Talk soon.
567 00:45:47.760 ⇒ 00:45:48.149 Casie Aviles: Thank you.
568 00:45:48.150 ⇒ 00:45:49.799 Samuel Roberts: Sounds good. Thanks, guys.