Meeting Title: Honey Stinger Klaviyo Data Analysis Sync Date: 2025-11-13 Meeting participants: Uttam Kumaran, Samuel Roberts, Henry Zhao
WEBVTT
1 00:00:07.750 ⇒ 00:00:08.750 Uttam Kumaran: Hey, dude.
2 00:00:11.430 ⇒ 00:00:18.560 Uttam Kumaran: For Klaviyo, like, can we just log in via the UI? I don’t know if we need to log in via SSO.
3 00:00:21.220 ⇒ 00:00:22.860 Samuel Roberts: For Klaviyo, is that what’s going on?
4 00:00:23.210 ⇒ 00:00:24.450 Uttam Kumaran: Yeah…
5 00:00:26.020 ⇒ 00:00:32.419 Uttam Kumaran: I just don’t know… I don’t think we have… I think you may have reset the password, but I don’t have the new password.
6 00:00:32.980 ⇒ 00:00:35.350 Samuel Roberts: Oh, that might have happened.
7 00:00:39.430 ⇒ 00:00:41.430 Uttam Kumaran: We can just add it to one pass.
8 00:00:41.430 ⇒ 00:00:42.920 Samuel Roberts: The password for…
9 00:00:43.900 ⇒ 00:00:44.970 Uttam Kumaran: for Klaviyo.
10 00:00:45.150 ⇒ 00:00:46.939 Samuel Roberts: For Klaviyo specifically with that email?
11 00:00:47.180 ⇒ 00:00:48.000 Samuel Roberts: Yeah.
12 00:00:48.240 ⇒ 00:00:50.650 Samuel Roberts: Yeah, let me… let me see what I did there.
13 00:00:56.010 ⇒ 00:00:58.610 Samuel Roberts: Yeah, I did. Okay, let me share that.
14 00:01:06.580 ⇒ 00:01:11.879 Samuel Roberts: Yeah… Or I’ll just drop that in Slack then, or…
15 00:01:13.260 ⇒ 00:01:13.870 Uttam Kumaran: Yeah.
16 00:01:14.100 ⇒ 00:01:14.790 Samuel Roberts: Okay.
17 00:01:20.340 ⇒ 00:01:21.110 Samuel Roberts: Oops.
18 00:01:21.220 ⇒ 00:01:23.950 Samuel Roberts: There we go. Okay, yeah, sorry about that, didn’t realize that.
19 00:01:24.780 ⇒ 00:01:25.580 Uttam Kumaran: Very good.
20 00:01:25.580 ⇒ 00:01:27.540 Samuel Roberts: And take… oh, let me remind you this.
21 00:01:27.980 ⇒ 00:01:32.900 Samuel Roberts: Yeah, so without the… Without any Shopify or…
22 00:01:33.570 ⇒ 00:01:34.090 Uttam Kumaran: Yeah.
23 00:01:34.090 ⇒ 00:01:36.619 Samuel Roberts: I have Shopify, but yeah, Walmart or Amazon.
24 00:01:38.300 ⇒ 00:01:39.769 Uttam Kumaran: I don’t know what we’re gonna do.
25 00:01:39.770 ⇒ 00:01:40.590 Samuel Roberts: Yeah.
26 00:01:44.720 ⇒ 00:01:47.579 Uttam Kumaran: Okay, I’ll wait for Henry, and we can ask what he thinks.
27 00:01:47.580 ⇒ 00:01:48.480 Samuel Roberts: Okay, cool.
28 00:02:02.880 ⇒ 00:02:07.480 Uttam Kumaran: Wait, Sam, you put the… those credentials in… One pass?
29 00:02:09.630 ⇒ 00:02:10.340 Uttam Kumaran: For Klaviy?
30 00:02:10.340 ⇒ 00:02:11.910 Samuel Roberts: Yeah. Yeah.
31 00:02:12.470 ⇒ 00:02:13.160 Uttam Kumaran: Oh.
32 00:02:13.400 ⇒ 00:02:14.920 Samuel Roberts: I just slacked it to you.
33 00:02:15.170 ⇒ 00:02:16.690 Uttam Kumaran: Oh.
34 00:02:20.260 ⇒ 00:02:23.840 Samuel Roberts: When we share that one pad, is that keeping it updated, or is that just sharing, like…
35 00:02:24.430 ⇒ 00:02:25.360 Uttam Kumaran: Me too.
36 00:02:25.560 ⇒ 00:02:27.469 Uttam Kumaran: I would just make sure it’s in the vault.
37 00:02:28.330 ⇒ 00:02:31.680 Samuel Roberts: Okay, I don’t have a… I would… this maybe is the one.
38 00:02:31.680 ⇒ 00:02:32.110 Uttam Kumaran: Oh.
39 00:02:32.110 ⇒ 00:02:35.110 Samuel Roberts: Using 1Password, then. Is there a vault for Honey Stinger?
40 00:02:35.110 ⇒ 00:02:36.060 Uttam Kumaran: Yeah, there is.
41 00:02:36.060 ⇒ 00:02:40.669 Samuel Roberts: That I don’t have. Okay, that’s why I’m… that’s probably why I had to reset it even. Okay, I didn’t get added to that.
42 00:02:41.150 ⇒ 00:02:42.040 Uttam Kumaran: Okay, let me, yeah.
43 00:02:42.040 ⇒ 00:02:42.930 Samuel Roberts: My bad.
44 00:02:43.280 ⇒ 00:02:44.770 Uttam Kumaran: No, you’re good, let me put you in there.
45 00:02:46.810 ⇒ 00:02:47.890 Uttam Kumaran: So…
46 00:02:52.880 ⇒ 00:02:55.010 Uttam Kumaran: Okay, you should have the vault now.
47 00:02:55.250 ⇒ 00:02:55.830 Uttam Kumaran: Yep.
48 00:02:55.830 ⇒ 00:02:57.720 Samuel Roberts: Alright, well, it popped right up. Yep.
49 00:02:58.230 ⇒ 00:03:03.969 Uttam Kumaran: You can move it there, and then send it to… entering the channel.
50 00:03:04.220 ⇒ 00:03:06.940 Uttam Kumaran: And then, Henry, you can log in to Klaviyo that way.
51 00:03:07.600 ⇒ 00:03:08.040 Samuel Roberts: Oh.
52 00:03:08.040 ⇒ 00:03:13.219 Henry Zhao: What is the workspace ID? Is that the T… no, that’s the public API. Public Huntingsteiner.
53 00:03:15.960 ⇒ 00:03:18.529 Samuel Roberts: Okay, just… alright, cool, that’s moved in.
54 00:03:21.170 ⇒ 00:03:22.270 Henry Zhao: Okay.
55 00:03:22.420 ⇒ 00:03:29.399 Samuel Roberts: And then sharing that, where did that go?
56 00:03:32.330 ⇒ 00:03:33.030 Samuel Roberts: Hmm.
57 00:03:37.390 ⇒ 00:03:40.360 Henry Zhao: No, that’s not the Klaviyo workspace… workplace ID.
58 00:03:41.930 ⇒ 00:03:43.450 Henry Zhao: That’s the API key.
59 00:03:47.700 ⇒ 00:03:51.050 Uttam Kumaran: Yeah, no, we have to just log in via user email.
60 00:03:52.360 ⇒ 00:03:53.900 Henry Zhao: Okay, do we have logins for that?
61 00:03:55.070 ⇒ 00:03:56.570 Uttam Kumaran: Yep, Sam is sending that.
62 00:03:56.570 ⇒ 00:04:00.599 Samuel Roberts: Yeah, so yeah, it’s in the vault now, and I just shared it on Slack.
63 00:04:00.830 ⇒ 00:04:01.520 Henry Zhao: Okay.
64 00:04:03.660 ⇒ 00:04:06.590 Henry Zhao: Copy… Into this one.
65 00:04:07.140 ⇒ 00:04:17.510 Henry Zhao: Email… Save in 1Password, save… I’m not a robot… Login.
66 00:04:17.740 ⇒ 00:04:21.799 Samuel Roberts: I had that so many times, trying to get that Walmart thing earlier, because I kept doing it, and it…
67 00:04:22.550 ⇒ 00:04:27.190 Samuel Roberts: It was this longest little press-and-hold thing that Woman had.
68 00:04:27.560 ⇒ 00:04:32.320 Henry Zhao: I’m trying to figure out if we have 208,000… 209,000 subscribers.
69 00:04:34.500 ⇒ 00:04:36.750 Samuel Roberts: Oh, nice, okay. Yeah.
70 00:04:42.860 ⇒ 00:04:44.789 Henry Zhao: Oh, no, I don’t want to do this yet.
71 00:04:45.390 ⇒ 00:04:48.709 Henry Zhao: I don’t want to authorize FiveChan yet, or should we… can we?
72 00:04:50.470 ⇒ 00:04:52.959 Uttam Kumaran: Well, I guess it’s up to you, like…
73 00:04:54.470 ⇒ 00:04:56.729 Uttam Kumaran: Can you get that data through Fivetran?
74 00:04:59.610 ⇒ 00:05:00.680 Samuel Roberts: Polyatomic?
75 00:05:01.800 ⇒ 00:05:03.580 Uttam Kumaran: Yeah, because they won’t have it by Monday, but…
76 00:05:03.980 ⇒ 00:05:10.750 Uttam Kumaran: So, if you open the Fivetran, I guess, maybe, Sam, you can look to see if this… if Fivetran for Klaviyo gives us the message data.
77 00:05:15.310 ⇒ 00:05:20.310 Uttam Kumaran: Yeah, so just, just type in Fivetran, Klaviyo, and Google.
78 00:05:28.740 ⇒ 00:05:29.830 Samuel Roberts: What are we looking for?
79 00:05:30.660 ⇒ 00:05:32.680 Henry Zhao: Campaign messages.
80 00:05:34.760 ⇒ 00:05:35.690 Samuel Roberts: So, go, go.
81 00:05:35.690 ⇒ 00:05:38.070 Uttam Kumaran: Go to the API configuration.
82 00:05:40.530 ⇒ 00:05:44.930 Uttam Kumaran: Sorry, not… maybe not be here, maybe it’s in Setup Guide.
83 00:05:47.570 ⇒ 00:05:50.759 Samuel Roberts: I think it’s the top level, if you just click on cloud… oh, okay, I’m gonna do it.
84 00:05:51.570 ⇒ 00:05:54.210 Uttam Kumaran: Well, it should tell you somewhere, like, what data is.
85 00:05:54.540 ⇒ 00:05:58.500 Henry Zhao: Campaigns… What about inside of campaigns?
86 00:05:59.380 ⇒ 00:06:03.039 Uttam Kumaran: So click on… so, wait, click on schema information, scroll down.
87 00:06:03.710 ⇒ 00:06:04.960 Henry Zhao: some information.
88 00:06:05.650 ⇒ 00:06:06.510 Samuel Roberts: Okay.
89 00:06:09.050 ⇒ 00:06:11.400 Uttam Kumaran: Yep, so this is… so this will give you everything.
90 00:06:16.670 ⇒ 00:06:17.340 Henry Zhao: this?
91 00:06:18.380 ⇒ 00:06:21.799 Uttam Kumaran: Well, this is gonna… this is what you would get if you hooked it up to 5trip. Yep.
92 00:06:21.800 ⇒ 00:06:23.310 Samuel Roberts: campaign message there.
93 00:06:24.480 ⇒ 00:06:25.800 Henry Zhao: Where do you see it? This?
94 00:06:26.590 ⇒ 00:06:29.999 Samuel Roberts: I just typed it in the search, and it looks like it’s on the far right, over…
95 00:06:31.070 ⇒ 00:06:33.089 Samuel Roberts: Zoom out a little bit. It’s…
96 00:06:33.090 ⇒ 00:06:34.080 Henry Zhao: Yeah, I see it.
97 00:06:34.080 ⇒ 00:06:34.790 Samuel Roberts: Okay.
98 00:06:35.550 ⇒ 00:06:38.850 Henry Zhao: Yeah, so we have the template ID, so then it gives us the email template, which is here.
99 00:06:39.860 ⇒ 00:06:42.730 Henry Zhao: So this is where the HTML and all that stuff is stored.
100 00:06:44.290 ⇒ 00:06:45.679 Uttam Kumaran: So I guess, like…
101 00:06:45.700 ⇒ 00:06:48.350 Henry Zhao: So Polyta got us to here, but we need to get here.
102 00:06:48.790 ⇒ 00:06:49.789 Samuel Roberts: Got it, okay.
103 00:06:49.790 ⇒ 00:06:52.859 Uttam Kumaran: Yeah, so it’s up to you, Henry, like, if you run that.
104 00:06:53.590 ⇒ 00:06:57.420 Uttam Kumaran: I guess maybe we can start with, tell me where you’re at, and then if you want, we can…
105 00:06:58.490 ⇒ 00:07:04.939 Uttam Kumaran: you can run this, and then if you want to try to do some analysis before tomorrow, I don’t know, doesn’t seem like we’re gonna get far.
106 00:07:04.940 ⇒ 00:07:05.600 Henry Zhao: don’t.
107 00:07:05.600 ⇒ 00:07:07.539 Uttam Kumaran: At all on the customer stitching, so…
108 00:07:09.080 ⇒ 00:07:12.859 Henry Zhao: Yeah, we’re not gonna get far on this either by Friday, for sure, because.
109 00:07:12.860 ⇒ 00:07:13.520 Uttam Kumaran: Okay.
110 00:07:13.520 ⇒ 00:07:29.580 Henry Zhao: We need to have AI progress to be able to categorize them, but you can… we can tell you, like, what to talk about in terms of the plan, right? So, it’s to get this data, look at the template, kind of categorize it. But also, I’ve subscribed to Honey Stinger’s emails, and I don’t think it’s that complex.
111 00:07:29.880 ⇒ 00:07:31.479 Henry Zhao: So I don’t know how much…
112 00:07:32.120 ⇒ 00:07:37.489 Uttam Kumaran: I mean, I feel like if we got all the emails, it’s actually not that hard to run AI over it. That’s, like, not that hard.
113 00:07:38.190 ⇒ 00:07:40.989 Henry Zhao: I just don’t know how many nuggets we’d get from there. I think…
114 00:07:41.330 ⇒ 00:07:46.139 Henry Zhao: From playing around with the Klaviyo data, we already have a lot of stuff that we can dig into.
115 00:07:46.140 ⇒ 00:07:48.460 Uttam Kumaran: Okay, yeah, you tell me about that, yeah.
116 00:07:48.720 ⇒ 00:08:02.250 Henry Zhao: So the first thing I did was, everything is basically in the Klaviyo events table. This is what we discovered yesterday. So I dumped a sheet of, like, all of the literal event names that are in Klaviyo, and just figured out, like, what are the things that we would care about?
117 00:08:03.710 ⇒ 00:08:08.460 Henry Zhao: So, I got to this list, so I’m just gonna get rid of the blanks and the laters.
118 00:08:10.000 ⇒ 00:08:14.460 Henry Zhao: And the ignores… there’s some ignore stuff, because they’re, like, just deprecated.
119 00:08:14.730 ⇒ 00:08:20.840 Henry Zhao: And then I try to kind of understand, are these actual correct events or not? Just by looking at, like, how many instances there are.
120 00:08:21.050 ⇒ 00:08:24.519 Henry Zhao: And group them into categories, right? So…
121 00:08:24.850 ⇒ 00:08:43.489 Henry Zhao: For conversions, I want to look at, you know, the orders… products that were ordered, the orders that were placed, add to cart, if anything was canceled and the checkout was started. But I am a little bit unsure if we’re capturing all checkouts, because if… I tested a checkout with the Klaviyo,
122 00:08:45.750 ⇒ 00:08:51.500 Henry Zhao: extension, and I’m just not sure if Klaviyo is on all checkout pages, but…
123 00:08:51.500 ⇒ 00:08:54.070 Uttam Kumaran: Oh, okay. Cool, so that’s one thing.
124 00:08:55.570 ⇒ 00:09:01.189 Henry Zhao: But there is quite a lot of instances of checkout started, and I kind of plotted that.
125 00:09:01.630 ⇒ 00:09:07.040 Henry Zhao: Over time, with the amount in the checkout started, so the next thing I want to look into is, like, what are these spikes? Are these even real?
126 00:09:07.040 ⇒ 00:09:07.900 Samuel Roberts: Hell yeah.
127 00:09:09.800 ⇒ 00:09:11.690 Henry Zhao: Or were there bots or something like that?
128 00:09:12.760 ⇒ 00:09:21.020 Henry Zhao: So the next thing I was gonna look at is actual order placed, but I want to make sure that it’s just this event, that there’s not,
129 00:09:21.440 ⇒ 00:09:27.940 Henry Zhao: I think it’s gonna be placed order, as well as… Placed order… order placed…
130 00:09:28.860 ⇒ 00:09:30.979 Henry Zhao: Recur… what’s it called?
131 00:09:33.020 ⇒ 00:09:34.140 Samuel Roberts: For the subscriptions?
132 00:09:34.770 ⇒ 00:09:40.439 Henry Zhao: No, it’s, order placed… Rekin… no, rechar.
133 00:09:40.440 ⇒ 00:09:41.900 Samuel Roberts: Recharge, yeah, that’s the thing.
134 00:09:42.690 ⇒ 00:09:48.440 Henry Zhao: It looks like Recharge Subscriptions, so my next thing I was gonna analyze is,
135 00:09:48.920 ⇒ 00:09:51.999 Henry Zhao: Subscriptions versus one-time purchases over time.
136 00:09:52.990 ⇒ 00:09:55.480 Henry Zhao: So I think to do that, I would look at…
137 00:09:55.590 ⇒ 00:10:02.430 Henry Zhao: purchases by… with Recharge, plus… this event,
138 00:10:03.450 ⇒ 00:10:05.510 Henry Zhao: Started subscription, I think. Where is it?
139 00:10:06.450 ⇒ 00:10:12.530 Henry Zhao: Start a subscription… Use this for subscriptions versus one-time purchase.
140 00:10:14.430 ⇒ 00:10:19.420 Henry Zhao: And then there’s also ended subscription, or canceled subscription.
141 00:10:20.310 ⇒ 00:10:24.080 Henry Zhao: So I’m gonna look at that over time also. Cancel subscription.
142 00:10:25.740 ⇒ 00:10:31.279 Henry Zhao: And, subscription in versus out over time.
143 00:10:36.610 ⇒ 00:10:42.359 Henry Zhao: And then a lot of this stuff is for, like, emails, so, like, I want to look at, are we getting legitimate emails, or are they bouncing?
144 00:10:43.600 ⇒ 00:10:46.570 Henry Zhao: What are the campaigns that people are opening, and, like.
145 00:10:46.730 ⇒ 00:10:50.009 Henry Zhao: Do they purchase before opening emails or after?
146 00:10:50.870 ⇒ 00:10:52.660 Henry Zhao: But, like, I did a test on myself.
147 00:10:53.510 ⇒ 00:10:58.829 Henry Zhao: And so, it always starts with, like, active on site, so when you get active on site, you already get assigned an ID,
148 00:10:59.010 ⇒ 00:11:03.350 Henry Zhao: And then you get subscribed to a list, subscribe to email marketing, received email, opened email.
149 00:11:03.540 ⇒ 00:11:09.870 Henry Zhao: And then the purchase photos, viewed product, added to cart, checkout started, and then probably, order… Purchased.
150 00:11:10.590 ⇒ 00:11:13.630 Uttam Kumaran: Oh, I just requested edit access to this dog.
151 00:11:15.890 ⇒ 00:11:17.909 Uttam Kumaran: And then.
152 00:11:20.330 ⇒ 00:11:23.890 Henry Zhao: I’m just putting all my stuff here, and then all my, like, SQL notes here.
153 00:11:24.230 ⇒ 00:11:26.279 Henry Zhao: Just to… just for the sake of time.
154 00:11:27.150 ⇒ 00:11:31.760 Uttam Kumaran: And then I guess another thing, can we move this to the, client folder?
155 00:11:32.310 ⇒ 00:11:34.170 Uttam Kumaran: Which is this one.
156 00:11:34.870 ⇒ 00:11:37.830 Uttam Kumaran: I’ll send it in, I’ll send it in Slack for you.
157 00:11:40.970 ⇒ 00:11:43.989 Uttam Kumaran: That way, I can just send this whole thing to Byron.
158 00:11:44.220 ⇒ 00:11:44.970 Uttam Kumaran: We can just…
159 00:11:44.970 ⇒ 00:11:48.980 Henry Zhao: But either way, what I’m trying to say is there’s a lot of stuff that we can analyze just from the Klaviyo data, it seems like.
160 00:11:49.400 ⇒ 00:11:51.420 Uttam Kumaran: Yeah, so if I could just…
161 00:12:05.750 ⇒ 00:12:13.169 Henry Zhao: And then I was also going to analyze email versus SMS. So, like, what is the effectiveness of people that are subscribed to email versus SMS versus both?
162 00:12:13.980 ⇒ 00:12:16.450 Henry Zhao: So if you see here, well…
163 00:12:17.730 ⇒ 00:12:24.229 Henry Zhao: It’s very small, people that are just a SMS or email, so… I guess we look at SMS as, like, a cohort.
164 00:12:24.880 ⇒ 00:12:30.320 Uttam Kumaran: So, if… can we note down… I’m just creating a new sheet, which we can just note down some of, like, the…
165 00:12:30.740 ⇒ 00:12:34.380 Uttam Kumaran: The questions or hypotheses that we’re going after?
166 00:12:34.520 ⇒ 00:12:35.100 Henry Zhao: Okay.
167 00:12:35.380 ⇒ 00:12:41.300 Uttam Kumaran: Maybe we can… so I followed you a little bit on…
168 00:12:41.700 ⇒ 00:12:43.670 Uttam Kumaran: Okay, we’re gonna look at, like…
169 00:12:45.110 ⇒ 00:12:49.360 Uttam Kumaran: One, we’re just gonna look at, like, is it… are we capturing all checkouts?
170 00:12:54.710 ⇒ 00:12:58.860 Henry Zhao: And what are these spikes? So I’m gonna look at orders and see, like, what that looks like.
171 00:12:59.300 ⇒ 00:13:03.000 Henry Zhao: I mean, I was about to get to it. I just needed to check the ordered events.
172 00:13:03.000 ⇒ 00:13:05.989 Uttam Kumaran: So what are those checkout event spikes?
173 00:13:06.340 ⇒ 00:13:08.540 Uttam Kumaran: Okay, and then…
174 00:13:08.740 ⇒ 00:13:11.459 Henry Zhao: It’s like a few hours were spent just on understanding the data, so the analysis.
175 00:13:11.460 ⇒ 00:13:12.140 Uttam Kumaran: Yeah.
176 00:13:12.140 ⇒ 00:13:13.109 Henry Zhao: I mean, more and more.
177 00:13:14.340 ⇒ 00:13:19.229 Uttam Kumaran: And then, tell me about the funnel sheet again, so that’s, like, user funnel for metrics.
178 00:13:20.770 ⇒ 00:13:27.670 Henry Zhao: Yeah, I just tested myself, like, I pretended I was a customer going through the funnel, just to make sure that the events that I’m looking at are actually correct.
179 00:13:28.550 ⇒ 00:13:35.120 Henry Zhao: Okay. Right, because if I… if I think purchase… order purchase is this, but it’s not, like…
180 00:13:35.280 ⇒ 00:13:36.680 Henry Zhao: Something, something is wrong.
181 00:13:37.050 ⇒ 00:13:45.169 Uttam Kumaran: So, confirming the funnel events… And then, what was the SMS question that we’re trying to answer?
182 00:13:45.170 ⇒ 00:13:57.259 Henry Zhao: So, I was gonna look at whether people that are subscribed to SMS are more likely to purchase, or are they better customers, but it’s very few people are. So, like, there’s 208 people subscribed to email.
183 00:13:57.440 ⇒ 00:14:01.769 Henry Zhao: And only, like, 1,900 subscribed to SMS.
184 00:14:01.980 ⇒ 00:14:02.630 Uttam Kumaran: Okay.
185 00:14:04.080 ⇒ 00:14:07.200 Uttam Kumaran: And then what was this, the metrics in events?
186 00:14:07.770 ⇒ 00:14:09.110 Uttam Kumaran: C, again.
187 00:14:09.570 ⇒ 00:14:10.839 Henry Zhao: metrics and events?
188 00:14:11.990 ⇒ 00:14:12.310 Uttam Kumaran: Yeah.
189 00:14:14.340 ⇒ 00:14:19.170 Henry Zhao: Oh, this is just, event types… And to deuce.
190 00:14:20.950 ⇒ 00:14:25.360 Uttam Kumaran: So, basically, what is this showing, like, if you were to explain to them?
191 00:14:25.360 ⇒ 00:14:35.270 Henry Zhao: Yeah, yeah, so the event table is basically just a, like, a big list of all the events that happen. So anytime somebody resolves a ticket, anytime someone orders a product.
192 00:14:35.610 ⇒ 00:14:41.069 Henry Zhao: So they’re called metrics in Klaviyo, but they’re actually just event names.
193 00:14:41.290 ⇒ 00:14:43.949 Henry Zhao: So that’s why I’ll make this event name…
194 00:14:44.580 ⇒ 00:14:49.009 Henry Zhao: And here I’m just saying, like, do I want to look at this, or do I… and for what reason?
195 00:14:49.130 ⇒ 00:14:55.380 Henry Zhao: And then here I’m just saying, like, what do I need to do about them? And then here I’m just taking notes and, like, saying what the fields are, and…
196 00:14:55.530 ⇒ 00:14:57.030 Henry Zhao: what I can analyze.
197 00:14:58.160 ⇒ 00:14:58.760 Uttam Kumaran: Okay.
198 00:15:00.460 ⇒ 00:15:05.160 Henry Zhao: So, like, I had to look into submitted form step, because this is also email subscribes.
199 00:15:05.390 ⇒ 00:15:11.500 Henry Zhao: But I wanted you to see if this is additional subscribes, or if this is, like, a subset of the subscribe to emails.
200 00:15:12.700 ⇒ 00:15:17.090 Henry Zhao: Right? Because I need to make sure my data is actually also accurate before I start doing all this analysis.
201 00:15:18.210 ⇒ 00:15:32.869 Uttam Kumaran: the… so I guess, like, what I’m trying to lay out more is, like, when we present them, I want to present, like, hey, we… we’re going through the… through your Klaviyo data, and, like, these are the questions that we’re trying to answer, so… I’m… I’m kind of writing those down in the questions hypothesis, yeah.
202 00:15:36.510 ⇒ 00:15:42.729 Henry Zhao: And I guess before SMS versus email, it’s like, who are the people that are adding… Subscribing to SMS.
203 00:15:43.350 ⇒ 00:15:48.700 Henry Zhao: We have two types of SMS subscriptions. There’s Subscribe to SMS Marketing, Subscribe to SMS transactional.
204 00:15:48.890 ⇒ 00:15:55.090 Henry Zhao: There’s various subscribe to SMS marketing, and like, so who are those people, and do we want to get people to subscribe to SMS marketing?
205 00:15:56.470 ⇒ 00:15:57.190 Uttam Kumaran: Okay.
206 00:15:59.450 ⇒ 00:16:03.840 Henry Zhao: Actually, this is weird. So, I have 37,000… let’s do count distinct also.
207 00:16:05.550 ⇒ 00:16:10.000 Henry Zhao: Relationshipsprofile.id, keen profile.id.
208 00:16:13.210 ⇒ 00:16:14.180 Henry Zhao: Oops.
209 00:16:16.560 ⇒ 00:16:28.370 Henry Zhao: Mother Duck is pretty cool. So we have 30,000 people that have subscribed to SMS marketing, but in the profile, there’s only 2,000 that say they have consented to SMS. So what’s the actual correct number?
210 00:16:30.580 ⇒ 00:16:32.480 Uttam Kumaran: but consent to SMS.
211 00:16:37.620 ⇒ 00:16:39.839 Henry Zhao: So I wonder how many people are actually getting SMSs.
212 00:16:40.300 ⇒ 00:16:43.789 Henry Zhao: Which I guess I can figure out from, like, Received S Invest, take a look at received estimates.
213 00:16:43.790 ⇒ 00:16:46.449 Uttam Kumaran: But consent to SMS doesn’t mean they’re receiving it, right?
214 00:16:49.060 ⇒ 00:16:52.499 Henry Zhao: But I’m saying there’s more people that subscribe to SMS than that have consent.
215 00:16:55.690 ⇒ 00:16:58.000 Uttam Kumaran: Oh, okay. By about a thousand.
216 00:16:59.940 ⇒ 00:17:06.669 Uttam Kumaran: Okay, yeah, but I’m… I guess I’m, like, less… oh, where? But I’m seeing 37K versus the 36K, right?
217 00:17:06.980 ⇒ 00:17:15.440 Henry Zhao: No, versus 2K. So 2K in the profiles have consent to SMS, but 37,000 people have subscribed to SMS marketing.
218 00:17:17.430 ⇒ 00:17:18.180 Uttam Kumaran: Oh.
219 00:17:18.599 ⇒ 00:17:23.449 Henry Zhao: I’m checking right now how many people received SMS, and that’ll give us an idea. If it’s, like, 2,000, then it’s that number.
220 00:17:23.770 ⇒ 00:17:28.999 Henry Zhao: 6K, it’s… I don’t know, it’s, 23K, which is not what I wanted to see.
221 00:17:29.800 ⇒ 00:17:30.600 Samuel Roberts: Oh, boy.
222 00:17:30.600 ⇒ 00:17:44.269 Henry Zhao: There’s probably tens of thousands of people that have subscribed to SMS marketing. So I want to look at these people, and the people that are subscribed. So I want to look at SMS only, email only, and email and SMS, and look at what the difference in terms of checkouts, purchases, and LTV are.
223 00:17:44.940 ⇒ 00:17:46.890 Uttam Kumaran: Okay. And then…
224 00:17:49.130 ⇒ 00:17:59.680 Uttam Kumaran: And can you, can you walk me through, like, can you walk me through what data is in… like, are we getting… what sales data we are getting from Amazon or Walmart? Like, just so I can have an understanding?
225 00:17:59.680 ⇒ 00:18:01.770 Henry Zhao: That’s Sam. So, Sam, you have 10… I’ve only looked at.
226 00:18:01.770 ⇒ 00:18:06.249 Samuel Roberts: Yeah. I think the Walmart stuff doesn’t look like it’s anything sales. It still looks like it’s just…
227 00:18:06.410 ⇒ 00:18:12.170 Samuel Roberts: advertising stuff. The Amazon… there’s…
228 00:18:12.380 ⇒ 00:18:18.229 Samuel Roberts: some stuff in there, but it wasn’t anything that I could identify as orders, and that’s when I realized we didn’t have the seller account.
229 00:18:18.460 ⇒ 00:18:22.080 Samuel Roberts: I think it’s just the… vendor account?
230 00:18:22.700 ⇒ 00:18:25.090 Samuel Roberts: Which syncs different things, it looked like.
231 00:18:29.700 ⇒ 00:18:33.459 Samuel Roberts: Let me get the right door open here.
232 00:18:34.680 ⇒ 00:18:41.939 Henry Zhao: I also want to look at purchase in Cloud to see if I can figure out where they’re from, because then this… we probably don’t even need that, right, Sam?
233 00:18:43.340 ⇒ 00:18:44.730 Samuel Roberts: Repeat that, sorry.
234 00:18:45.600 ⇒ 00:18:52.329 Henry Zhao: I’m gonna look at my ordered… placed order event in Klaviyo and see if I… it tells me if it’s Walmart or Amazon or whatever.
235 00:18:52.550 ⇒ 00:18:56.560 Henry Zhao: Cause then we might not even need… that data.
236 00:18:56.970 ⇒ 00:18:57.650 Samuel Roberts: I…
237 00:18:58.310 ⇒ 00:19:04.050 Samuel Roberts: I mean, I bet, though, Klaviya is only tied to the Shopify checkout, I bet, because if… it seems like if they’re doing…
238 00:19:04.220 ⇒ 00:19:09.949 Samuel Roberts: you know, 1P with… Amazon and Walmart, all the checkouts there are gonna be…
239 00:19:10.400 ⇒ 00:19:11.460 Henry Zhao: Let me just check right now.
240 00:19:11.800 ⇒ 00:19:12.780 Henry Zhao: Yeah.
241 00:19:12.780 ⇒ 00:19:19.059 Samuel Roberts: Yeah, yeah, I can’t… because if it’s just going to be a checkup from Amazon and Walmart, you know, it’s as if you’re buying from Amazon and Walmart, it’s not like you’re…
242 00:19:19.870 ⇒ 00:19:22.940 Samuel Roberts: I’d be, yeah, I’d be curious to see what the sources are there.
243 00:19:24.580 ⇒ 00:19:27.619 Henry Zhao: So this is a purchase order purchased. Let’s take a look at it.
244 00:19:27.930 ⇒ 00:19:28.530 Samuel Roberts: Okay.
245 00:19:28.530 ⇒ 00:19:29.900 Henry Zhao: Order purchased.
246 00:19:31.740 ⇒ 00:19:32.700 Henry Zhao: Jeez.
247 00:19:35.230 ⇒ 00:19:38.670 Samuel Roberts: Oh boy, yeah, Shopify, I see some Shopify URLs.
248 00:19:38.670 ⇒ 00:19:40.100 Henry Zhao: It says Shopify…
249 00:19:41.060 ⇒ 00:19:41.740 Samuel Roberts: Yeah.
250 00:19:41.980 ⇒ 00:19:45.150 Henry Zhao: I wanna see if there’s, like, a platform, field.
251 00:19:45.750 ⇒ 00:19:51.440 Henry Zhao: Because then I can just group by that and see if there’s only Shopify, or if there’s also Walmart. Oh, wait, what was that?
252 00:19:51.770 ⇒ 00:20:02.270 Henry Zhao: That’s Shopify So this is only Shopify, and… cast… events, properties…
253 00:20:04.050 ⇒ 00:20:06.370 Henry Zhao: as… aren’t you, I don’t know.
254 00:20:06.750 ⇒ 00:20:08.160 Henry Zhao: Never done more than a duck.
255 00:20:13.730 ⇒ 00:20:15.209 Samuel Roberts: with a pro.
256 00:20:16.550 ⇒ 00:20:18.379 Henry Zhao: Another deck will suggest the corrections one.
257 00:20:18.380 ⇒ 00:20:19.860 Samuel Roberts: Yeah, it’s pretty good about that.
258 00:20:21.740 ⇒ 00:20:22.750 Henry Zhao: And it is.
259 00:20:24.990 ⇒ 00:20:28.379 Henry Zhao: Let’s just see if there are any, and what those look like, and then we’ll know.
260 00:20:42.630 ⇒ 00:20:44.959 Henry Zhao: Anything else you want to talk about in the meantime while we run this?
261 00:20:47.950 ⇒ 00:20:52.939 Uttam Kumaran: No, I guess I would say…
262 00:20:53.700 ⇒ 00:20:57.009 Uttam Kumaran: Just run it on the last year, because otherwise it’s going to take forever, right?
263 00:21:00.960 ⇒ 00:21:02.889 Uttam Kumaran: Or how long are these taking, typically?
264 00:21:03.810 ⇒ 00:21:05.009 Henry Zhao: Very fast, 5 seconds.
265 00:21:05.010 ⇒ 00:21:05.790 Uttam Kumaran: Oh, okay, okay.
266 00:21:05.790 ⇒ 00:21:07.580 Samuel Roberts: Yeah, but with the cast, I bet it’s…
267 00:21:11.840 ⇒ 00:21:17.069 Henry Zhao: So, I’m gonna… This is already shared with everyone, but… where’s the client folder?
268 00:21:17.750 ⇒ 00:21:20.590 Uttam Kumaran: I sent it in the channel.
269 00:21:21.510 ⇒ 00:21:22.230 Henry Zhao: And also…
270 00:21:22.230 ⇒ 00:21:24.949 Uttam Kumaran: So, yeah, I think it’s also probably worth…
271 00:21:25.210 ⇒ 00:21:29.829 Uttam Kumaran: talking to Amber, and… because she’s been accelerating, sort of, like, how fast
272 00:21:30.060 ⇒ 00:21:35.859 Uttam Kumaran: she does analysis, like, using cursor, I feel like it’s… Somebody worked just like that.
273 00:21:36.540 ⇒ 00:21:37.810 Henry Zhao: Okay, I’ll take a look at this.
274 00:21:40.050 ⇒ 00:21:41.580 Henry Zhao: And I’ll add some slides in there.
275 00:21:43.600 ⇒ 00:21:45.449 Henry Zhao: By end of day, and then I’ll ping you.
276 00:21:46.350 ⇒ 00:21:51.450 Henry Zhao: That way, by tomorrow, we can, like, fine-tune the story and figure out what else we need to supplement with
277 00:21:51.650 ⇒ 00:21:53.570 Henry Zhao: To, get it ready for the meeting.
278 00:21:54.930 ⇒ 00:21:57.160 Uttam Kumaran: Wait, say that one more time? Sorry, my headphones just died.
279 00:21:57.160 ⇒ 00:22:04.580 Henry Zhao: I’m just gonna make some slides by end of day, and then I’ll ping you, and then that way, by tomorrow morning, you can, like, fine-tune it, and get it ready for the meeting.
280 00:22:04.760 ⇒ 00:22:10.190 Uttam Kumaran: Yeah, as soon as you ping me today, I’ll take a look. I would say call Amber, though, now that you have all the data.
281 00:22:10.200 ⇒ 00:22:11.189 Henry Zhao: Yeah, I have, yeah.
282 00:22:11.190 ⇒ 00:22:13.310 Uttam Kumaran: Okay, yeah. She’s,
283 00:22:13.420 ⇒ 00:22:24.819 Uttam Kumaran: I don’t know, she’s doing something really nifty in cursor on, like, how she’s running analysis. It’s, like, helping her do a lot. Like, the default folks today were, like, blown away, because… and she’s been able to move really fast, so…
284 00:22:24.970 ⇒ 00:22:28.959 Uttam Kumaran: I haven’t called her yet to get a lowdown, but,
285 00:22:29.730 ⇒ 00:22:36.650 Uttam Kumaran: she’s basically, I think, loading CSVs or having it query, and then Cursor is able to, like, run through quick analysis and, like, pivot its queries.
286 00:22:37.070 ⇒ 00:22:39.610 Uttam Kumaran: I don’t know what’s been helping here.
287 00:22:40.080 ⇒ 00:22:44.789 Uttam Kumaran: Is she using Mother Duck? Because it might even be using the DuckDB command line stuff.
288 00:22:45.280 ⇒ 00:22:46.969 Uttam Kumaran: For default? No, oh, for.
289 00:22:46.970 ⇒ 00:22:47.590 Samuel Roberts: Okay.
290 00:22:47.590 ⇒ 00:22:50.609 Uttam Kumaran: It is, it is using, yeah, I think she’s using the DuckDV CLI.
291 00:22:50.610 ⇒ 00:22:54.850 Samuel Roberts: Yeah, because my cursor knows probably plenty of that, which would make it really powerful.
292 00:22:54.850 ⇒ 00:22:55.560 Uttam Kumaran: Yeah.
293 00:22:57.820 ⇒ 00:23:00.279 Samuel Roberts: Sandra, you might want to try that out.
294 00:23:01.630 ⇒ 00:23:04.389 Henry Zhao: Yeah, I just haven’t been able to connect Mother Duck to Cursor yet.
295 00:23:05.920 ⇒ 00:23:07.760 Uttam Kumaran: Why don’t we do that? Why don’t we do that now?
296 00:23:10.340 ⇒ 00:23:14.640 Uttam Kumaran: So, if you type, like, I don’t know, or you can call Amber and ask her to join this.
297 00:23:18.260 ⇒ 00:23:21.909 Henry Zhao: But we already did a session yesterday, and we’re kind of stuck.
298 00:23:22.310 ⇒ 00:23:23.150 Henry Zhao: Sure enough.
299 00:23:28.030 ⇒ 00:23:32.759 Uttam Kumaran: I feel like, yeah, it should be pretty easy just to install the duck… the Mother Duck CLI.
300 00:23:35.690 ⇒ 00:23:41.230 Samuel Roberts: Yeah, there was a way to tie that then to MotherDuck once you install that. Just run some command.
301 00:23:41.860 ⇒ 00:23:42.790 Henry Zhao: Sorry, say that again?
302 00:23:43.510 ⇒ 00:23:45.850 Samuel Roberts: So, yeah, you should ins… yeah, I would say…
303 00:23:46.720 ⇒ 00:23:50.109 Samuel Roberts: Do you have to install the DuckDB command line?
304 00:23:51.020 ⇒ 00:23:51.840 Samuel Roberts: Okay.
305 00:23:51.840 ⇒ 00:23:52.960 Henry Zhao: Can you help me with that?
306 00:23:52.960 ⇒ 00:23:53.460 Samuel Roberts: Yeah.
307 00:23:53.460 ⇒ 00:23:58.120 Henry Zhao: I think I’m pointing to… ZSH, I’ve done this before.
308 00:23:58.120 ⇒ 00:23:59.210 Samuel Roberts: Okay, yeah.
309 00:23:59.900 ⇒ 00:24:05.359 Henry Zhao: So I did brewinstall.duckDB, but I get this ZHSSH, so I forgot how to reset the path variables and stuff.
310 00:24:05.360 ⇒ 00:24:07.510 Samuel Roberts: Oh, see, it may not.
311 00:24:08.310 ⇒ 00:24:10.139 Samuel Roberts: So you have homebrew, but it’s just not…
312 00:24:10.510 ⇒ 00:24:13.599 Henry Zhao: I think, I think Ryan’s pointing to ZSH on the wrong path, so…
313 00:24:13.600 ⇒ 00:24:16.829 Samuel Roberts: Yeah, that hap… I… variables are the worst.
314 00:24:16.830 ⇒ 00:24:19.690 Henry Zhao: piano.zsh or something?
315 00:24:20.000 ⇒ 00:24:22.540 Samuel Roberts: To edit it? Yeah, ZSHRC.
316 00:24:23.300 ⇒ 00:24:25.110 Henry Zhao: And then, what do I put in here to get home?
317 00:24:25.110 ⇒ 00:24:28.869 Samuel Roberts: No, no, no, no, you gotta get out of there. It’s ZSHRC.
318 00:24:29.300 ⇒ 00:24:30.070 Henry Zhao: Okay.
319 00:24:30.390 ⇒ 00:24:34.019 Samuel Roberts: But you had it right, yes, yeah, just know that you have that, yeah, RC…
320 00:24:34.760 ⇒ 00:24:36.530 Samuel Roberts: Oh, it’s nothing there. -Oh, okay.
321 00:24:36.530 ⇒ 00:24:38.169 Henry Zhao: That’s why I got confused yesterday.
322 00:24:38.170 ⇒ 00:24:41.229 Samuel Roberts: Yeah, let me see real quick what the…
323 00:24:46.370 ⇒ 00:24:47.120 Samuel Roberts: What?
324 00:24:47.410 ⇒ 00:24:49.230 Samuel Roberts: You gotta add to that.
325 00:24:49.700 ⇒ 00:24:58.990 Samuel Roberts: Yeah, okay, so I just have… I don’t know… Where’s brew? Homebrew…
326 00:25:00.840 ⇒ 00:25:03.270 Samuel Roberts: you may want to just Google,
327 00:25:04.580 ⇒ 00:25:09.289 Samuel Roberts: or Mac default… have you made any other changes there for path and stuff?
328 00:25:09.740 ⇒ 00:25:11.660 Henry Zhao: Not that I remember.
329 00:25:12.270 ⇒ 00:25:13.070 Samuel Roberts: Okay.
330 00:25:15.730 ⇒ 00:25:20.310 Samuel Roberts: I just want to see if we can find a default, ZSH config.
331 00:25:21.590 ⇒ 00:25:23.050 Henry Zhao: It used to work, I don’t know what happened.
332 00:25:23.050 ⇒ 00:25:26.489 Samuel Roberts: Yeah, okay, there is no default, it’s just blank. I would say…
333 00:25:32.720 ⇒ 00:25:37.539 Samuel Roberts: What’s the folder here? Okay. Yeah, add this to the file, let me…
334 00:25:37.810 ⇒ 00:25:39.569 Samuel Roberts: I’ll send it over real quick.
335 00:25:41.340 ⇒ 00:25:42.899 Samuel Roberts: Hopefully it’s that.
336 00:25:47.780 ⇒ 00:25:50.250 Samuel Roberts: So that should go into the ZSHRC.
337 00:25:50.820 ⇒ 00:25:51.639 Henry Zhao: Where did you send it?
338 00:25:51.640 ⇒ 00:25:53.250 Samuel Roberts: Oh, in the chat here, on Zoom.
339 00:25:53.250 ⇒ 00:25:53.920 Henry Zhao: enough.
340 00:25:59.610 ⇒ 00:26:03.519 Samuel Roberts: So yeah, that should make brew work for this run, but you want to add it to the… nope, okay.
341 00:26:05.670 ⇒ 00:26:11.520 Samuel Roberts: Yeah, try adding it to the ZSHRC.
342 00:26:12.790 ⇒ 00:26:13.970 Henry Zhao: Oh, Addison there, okay.
343 00:26:13.970 ⇒ 00:26:15.919 Samuel Roberts: Yeah, and then.
344 00:26:15.920 ⇒ 00:26:16.780 Henry Zhao: Just like that.
345 00:26:17.170 ⇒ 00:26:19.679 Samuel Roberts: I think so, yeah, I don’t think you need to add anything else.
346 00:26:20.380 ⇒ 00:26:22.120 Samuel Roberts: And then save that.
347 00:26:41.120 ⇒ 00:26:41.980 Samuel Roberts: -Oh.
348 00:26:42.610 ⇒ 00:26:43.679 Samuel Roberts: Ren, are you there?
349 00:26:46.820 ⇒ 00:26:47.490 Henry Zhao: Never.
350 00:26:47.770 ⇒ 00:26:48.660 Uttam Kumaran: Robot.
351 00:26:49.120 ⇒ 00:26:53.549 Samuel Roberts: Yeah, you’re a little… I don’t know if it’s laggy or just timing out or whatever, but…
352 00:27:07.820 ⇒ 00:27:09.260 Samuel Roberts: -Oh, yep.
353 00:27:32.410 ⇒ 00:27:33.180 Samuel Roberts: Okay.
354 00:27:34.020 ⇒ 00:27:35.200 Samuel Roberts: Still not working?
355 00:27:36.380 ⇒ 00:27:38.169 Henry Zhao: Just my profile is salt.
356 00:27:38.420 ⇒ 00:27:43.139 Samuel Roberts: Oh, okay, if you ran that, you have to run source, ZSHRC, I think, to re…
357 00:27:43.310 ⇒ 00:27:47.570 Samuel Roberts: redo that, but if it’s not working with the manual run, I don’t think it’s…
358 00:27:47.570 ⇒ 00:27:53.789 Uttam Kumaran: Oh, wait, actually, here, like, why are we… I don’t… you should just do everything in cursor, you should do all your terminal stuff in cursor, so…
359 00:27:53.790 ⇒ 00:27:58.409 Samuel Roberts: Yeah, yeah, that’s true, but if it’s not able to install, it’s gonna get real confused, hopefully.
360 00:27:58.410 ⇒ 00:27:59.779 Uttam Kumaran: Oh, well, okay, well, just…
361 00:27:59.780 ⇒ 00:28:02.499 Samuel Roberts: But try it, yeah, see what you see, because Kirsten might be able to figure this out even, too.
362 00:28:02.500 ⇒ 00:28:08.249 Uttam Kumaran: No, no, no, okay, so first thing, Henry, open wherever your folder is for Honey Stinger, like, open that…
363 00:28:09.030 ⇒ 00:28:12.660 Uttam Kumaran: So go to File, An open folder.
364 00:28:13.640 ⇒ 00:28:14.400 Henry Zhao: folder?
365 00:28:14.690 ⇒ 00:28:16.820 Uttam Kumaran: And then just open the Honey Stinger.
366 00:28:18.800 ⇒ 00:28:19.480 Samuel Roberts: Yeah.
367 00:28:19.480 ⇒ 00:28:21.119 Henry Zhao: The GitHub repo?
368 00:28:21.120 ⇒ 00:28:22.810 Uttam Kumaran: Yeah, yeah, yeah, so you can hit open.
369 00:28:24.070 ⇒ 00:28:25.200 Henry Zhao: This is not the GitHub repo, though.
370 00:28:25.200 ⇒ 00:28:26.559 Samuel Roberts: No, that’s just the…
371 00:28:26.560 ⇒ 00:28:29.130 Uttam Kumaran: Oh, yeah, they get, yeah, whatever, they can have repo.
372 00:28:30.200 ⇒ 00:28:32.479 Henry Zhao: Oh, I need to get it first.
373 00:28:32.770 ⇒ 00:28:34.149 Samuel Roberts: Do we have a Honey Singer one?
374 00:28:34.450 ⇒ 00:28:35.460 Uttam Kumaran: Yeah, absolutely.
375 00:28:35.460 ⇒ 00:28:37.170 Henry Zhao: Is it in the one you added me to today?
376 00:28:38.530 ⇒ 00:28:41.270 Uttam Kumaran: I… I guess I didn’t do that.
377 00:28:41.270 ⇒ 00:28:43.550 Samuel Roberts: I just added you to the organization, I don’t know.
378 00:28:44.090 ⇒ 00:28:45.739 Samuel Roberts: What the repo was there.
379 00:28:46.340 ⇒ 00:28:48.800 Henry Zhao: Can you make sure I’m added to the repo, Lujan?
380 00:28:51.560 ⇒ 00:28:55.169 Uttam Kumaran: Well, I have to jump, but, like, I… what I would say is, like.
381 00:28:56.080 ⇒ 00:29:05.180 Uttam Kumaran: You just should, one, like, yeah, I mean, you should… whoever was helping you with this, ask them. I can’t… I’m not gonna do this. Second is…
382 00:29:05.300 ⇒ 00:29:10.800 Uttam Kumaran: You should just run everything in cursor, so you have a cursor help you to run whatever commands to connect.
383 00:29:11.080 ⇒ 00:29:17.180 Uttam Kumaran: it will… it will do that. So, if you need help, I can hop on probably after this, later, but…
384 00:29:17.390 ⇒ 00:29:17.860 Henry Zhao: Okay.
385 00:29:17.860 ⇒ 00:29:23.859 Uttam Kumaran: Again, like, Amber, Sam, everybody’s using cursor, so everybody should be able to walk you through it.
386 00:29:24.290 ⇒ 00:29:26.570 Samuel Roberts: Yeah, I’m adding you to that… I see the Honey Stinger…
387 00:29:26.710 ⇒ 00:29:31.680 Uttam Kumaran: I would totally get Sublime and get out of a terminal, like, do everything through cursor.
388 00:29:31.680 ⇒ 00:29:32.180 Samuel Roberts: Yeah.
389 00:29:32.900 ⇒ 00:29:33.480 Uttam Kumaran: Yeah.
390 00:29:34.360 ⇒ 00:29:36.410 Uttam Kumaran: Okay, I gotta jump to the next…
391 00:29:36.790 ⇒ 00:29:37.370 Henry Zhao: Okay.
392 00:29:37.680 ⇒ 00:29:42.040 Uttam Kumaran: Just, just, yeah, send me notes as you guys get it, and I’ll be on the rest of the day, so…
393 00:29:43.310 ⇒ 00:29:44.670 Uttam Kumaran: I’ll make you host of this.
394 00:29:45.380 ⇒ 00:29:45.920 Samuel Roberts: Cool.
395 00:29:47.630 ⇒ 00:29:48.680 Uttam Kumaran: You guys…
396 00:29:49.220 ⇒ 00:29:50.040 Samuel Roberts: Alright.
397 00:29:50.420 ⇒ 00:29:53.259 Samuel Roberts: Like, I just added you to the Honey Stinger one, so it should be…
398 00:29:54.520 ⇒ 00:29:59.170 Samuel Roberts: Should be one there. You gotta… Yeah…
399 00:30:01.070 ⇒ 00:30:06.290 Samuel Roberts: No, I don’t know if it’s that one, I think the Honey Stinger’s the one I just added you to, so you might have to go back to find that one now.
400 00:30:06.290 ⇒ 00:30:08.210 Henry Zhao: Oh, because that’s the one that Amber was using.
401 00:30:08.520 ⇒ 00:30:12.200 Samuel Roberts: Oh, okay, yeah, well, there’s a Honey Singer that just got created yesterday.
402 00:30:12.340 ⇒ 00:30:13.170 Henry Zhao: Oh, okay.
403 00:30:15.110 ⇒ 00:30:16.360 Henry Zhao: You guiding me where?
404 00:30:16.780 ⇒ 00:30:18.040 Henry Zhao: In GitHub?
405 00:30:18.530 ⇒ 00:30:22.860 Samuel Roberts: Yeah, you should see… there should be another, repo you have access to.
406 00:30:23.200 ⇒ 00:30:25.709 Samuel Roberts: On the Brainforge AI, at least, yeah.
407 00:30:26.020 ⇒ 00:30:29.509 Samuel Roberts: I don’t know, this looks like it hasn’t been set up yet, it seemed like it was just a…
408 00:30:29.950 ⇒ 00:30:31.310 Samuel Roberts: an initial setup.
409 00:30:35.580 ⇒ 00:30:37.889 Samuel Roberts: But we can start working from there.
410 00:30:41.390 ⇒ 00:30:42.970 Samuel Roberts: Yeah, there you go, okay.
411 00:30:44.580 ⇒ 00:30:45.380 Henry Zhao: Alright.
412 00:30:45.570 ⇒ 00:30:48.199 Samuel Roberts: Yeah, so now you can, probably, yeah, do that.
413 00:30:48.480 ⇒ 00:30:49.170 Samuel Roberts: Yep.
414 00:30:57.410 ⇒ 00:31:02.640 Samuel Roberts: Okay, so yeah, so now in here, I would say…
415 00:31:03.900 ⇒ 00:31:06.510 Samuel Roberts: So that, so basically, have you used Cursor at all yet?
416 00:31:06.840 ⇒ 00:31:07.360 Henry Zhao: Yeah,
417 00:31:07.360 ⇒ 00:31:13.180 Samuel Roberts: Okay, cool. But yeah, I would just say the agent’s view and the editor view, I would just say, you know, you want to add DuckDB to this…
418 00:31:14.030 ⇒ 00:31:17.989 Samuel Roberts: Director BCLI, And let it…
419 00:31:18.560 ⇒ 00:31:25.639 Samuel Roberts: let it figure out your, ZSH problem, too, once it realizes it can’t homebrew it. It might even just try to curl it or not, I don’t know.
420 00:31:26.270 ⇒ 00:31:26.890 Henry Zhao: Hmm?
421 00:31:28.240 ⇒ 00:31:31.900 Samuel Roberts: But yeah, I’ve honestly just been letting it do things, and it figures it out pretty well.
422 00:31:32.410 ⇒ 00:31:37.880 Samuel Roberts: Using the README, okay… Did it actually install?
423 00:31:39.160 ⇒ 00:31:41.389 Samuel Roberts: No, it did not. Okay, oh, there we go, okay.
424 00:31:42.450 ⇒ 00:31:47.760 Samuel Roberts: Okay, I would say run brew, or just copy the brew install and say run this, you know?
425 00:31:48.060 ⇒ 00:31:51.780 Samuel Roberts: Or it’ll ask it to run it, yeah, and then it’ll see the errors and figure it out, hopefully.
426 00:31:52.830 ⇒ 00:31:56.070 Samuel Roberts: You have to, give it… you know.
427 00:31:56.980 ⇒ 00:31:59.119 Samuel Roberts: The, authority wants to…
428 00:31:59.850 ⇒ 00:32:00.440 Henry Zhao: Where?
429 00:32:00.720 ⇒ 00:32:02.050 Samuel Roberts: Oh yeah, I don’t know what happened there.
430 00:32:07.900 ⇒ 00:32:14.319 Samuel Roberts: So again, now allow that, click run on the side there, and then hopefully it’ll… yeah, see, hopefully it figures this out.
431 00:32:14.460 ⇒ 00:32:18.379 Samuel Roberts: Yeah, there we go. Good. This is exactly the kind of stuff we had to kind of try to nail.
432 00:32:20.630 ⇒ 00:32:23.420 Samuel Roberts: No, okay.
433 00:32:25.620 ⇒ 00:32:26.480 Samuel Roberts: I would…
434 00:32:29.130 ⇒ 00:32:34.779 Samuel Roberts: Yeah, whichever way you want to do it, just let it guide you, I guess. You can either run that, or…
435 00:32:35.210 ⇒ 00:32:36.580 Samuel Roberts: Yeah, exactly.
436 00:32:40.980 ⇒ 00:32:45.449 Samuel Roberts: Yeah, the nice thing of when it runs the commands is it gets the output automatically, you don’t have to feed it back in.
437 00:32:45.450 ⇒ 00:32:46.430 Henry Zhao: Cool, okay.
438 00:32:47.430 ⇒ 00:32:49.269 Henry Zhao: I thought I had Homebrew, I’ve definitely installed, like.
439 00:32:49.430 ⇒ 00:32:51.900 Samuel Roberts: There might be some… yeah, but again, it might just be…
440 00:32:52.120 ⇒ 00:32:58.549 Samuel Roberts: something with the ZSA, so I would just let that… or hit run, and let that do its thing. Because if it is installed, hopefully it’ll figure it out.
441 00:33:03.180 ⇒ 00:33:07.329 Samuel Roberts: Yeah, try that, this is the one we want, actually. Okay, so you might have to run it with sudo.
442 00:33:11.860 ⇒ 00:33:12.740 Samuel Roberts: Yeah.
443 00:33:13.400 ⇒ 00:33:14.389 Henry Zhao: So I have to do this.
444 00:33:17.000 ⇒ 00:33:23.940 Samuel Roberts: Yeah, but yeah, let’s… And then enter your password there.
445 00:33:28.870 ⇒ 00:33:29.490 Henry Zhao: Dammit.
446 00:33:29.490 ⇒ 00:33:32.699 Samuel Roberts: It’s the worst when it doesn’t show you the… yeah, I hate…
447 00:33:32.850 ⇒ 00:33:35.450 Samuel Roberts: Command stuff for the… there you go, cool.
448 00:33:41.200 ⇒ 00:33:44.350 Samuel Roberts: Yeah, so I think this probably will update even if it’s not.
449 00:33:45.910 ⇒ 00:33:50.350 Henry Zhao: Oh, I… I know why now, I don’t have HomeRoot on this. I got a new laptop recently.
450 00:33:50.730 ⇒ 00:33:53.360 Samuel Roberts: Oh, okay, yeah, that’s good then. All right, well, that sounds.
451 00:33:53.360 ⇒ 00:33:55.940 Henry Zhao: All right.
452 00:33:56.390 ⇒ 00:33:57.550 Henry Zhao: Now we know why.
453 00:33:57.550 ⇒ 00:33:59.500 Samuel Roberts: Yeah, that makes a lot more sense.
454 00:33:59.500 ⇒ 00:34:01.270 Henry Zhao: I totally forgot about that.
455 00:34:01.600 ⇒ 00:34:05.929 Samuel Roberts: That’s funny. Yeah, honestly, I hate that, like, you’re still used to a certain setup, and then…
456 00:34:06.210 ⇒ 00:34:08.670 Samuel Roberts: a new setup, and yeah. I’ve been trying to, like.
457 00:34:08.670 ⇒ 00:34:14.779 Henry Zhao: Every Mac and every iPhone is so similar, like, two days after you get a new one, you’ve totally forgot you got a new one, because it’s like…
458 00:34:14.780 ⇒ 00:34:15.710 Samuel Roberts: Exactly.
459 00:34:15.719 ⇒ 00:34:18.979 Henry Zhao: It’s the exact same thing, so I’m gonna stop, like, getting new iPhones.
460 00:34:23.270 ⇒ 00:34:25.780 Henry Zhao: This is pointless. Alright, let’s see if my mother duck ran.
461 00:34:26.440 ⇒ 00:34:28.889 Samuel Roberts: Oh yeah, good call. How about that?
462 00:34:29.500 ⇒ 00:34:32.320 Henry Zhao: Zero roads, yeah, it’s all Spotify data. Okay, so you’re good.
463 00:34:32.320 ⇒ 00:34:36.730 Samuel Roberts: Yeah, I think… and because I think that’s… they don’t control the checkout for Amazon and Walmart.
464 00:34:36.730 ⇒ 00:34:38.529 Henry Zhao: Yeah, yeah, it makes sense. It makes sense.
465 00:34:38.530 ⇒ 00:34:40.679 Samuel Roberts: Yeah. Okay.
466 00:34:43.520 ⇒ 00:34:44.660 Henry Zhao: Add it to my notes.
467 00:34:46.889 ⇒ 00:34:47.980 Henry Zhao: Purchased.
468 00:34:52.380 ⇒ 00:34:57.900 Henry Zhao: Okay, so I can’t even really fully analyze order purchases, because I’m only getting, like, one platform of purchases.
469 00:34:57.900 ⇒ 00:34:59.620 Samuel Roberts: Yeah, and I’m not sure we’re gonna…
470 00:34:59.890 ⇒ 00:35:04.820 Samuel Roberts: I don’t know what we’re gonna be able to get from Walmart or Amazon, because it doesn’t seem like there’s access to any of that.
471 00:35:05.260 ⇒ 00:35:05.819 Henry Zhao: Amazon stuff.
472 00:35:05.820 ⇒ 00:35:06.680 Samuel Roberts: is…
473 00:35:07.770 ⇒ 00:35:10.609 Henry Zhao: is just… Someone identifies as, like, a question, right?
474 00:35:10.610 ⇒ 00:35:10.950 Samuel Roberts: Yeah.
475 00:35:11.200 ⇒ 00:35:13.850 Henry Zhao: So, Otem can ask for, like, what are the next steps?
476 00:35:13.850 ⇒ 00:35:15.740 Samuel Roberts: But at least it shows that we’ve done work.
477 00:35:16.160 ⇒ 00:35:16.890 Samuel Roberts: Definitely.
478 00:35:22.620 ⇒ 00:35:23.570 Samuel Roberts: Okay.
479 00:35:23.960 ⇒ 00:35:25.180 Henry Zhao: Trying to think what else.
480 00:35:25.880 ⇒ 00:35:28.700 Henry Zhao: I only have, like, another hour or so to work on this today.
481 00:35:28.890 ⇒ 00:35:31.900 Henry Zhao: And he said, we only have 40 hours a month to work on Honey Stinger, right?
482 00:35:32.460 ⇒ 00:35:34.480 Samuel Roberts: Yeah, it was pretty low, I think, so…
483 00:35:34.480 ⇒ 00:35:35.330 Henry Zhao: Yeah, so…
484 00:35:35.740 ⇒ 00:35:36.590 Samuel Roberts: for, yeah.
485 00:35:37.120 ⇒ 00:35:41.050 Samuel Roberts: So I should probably skip off this meeting now so I can stop logging time.
486 00:35:41.050 ⇒ 00:35:46.100 Henry Zhao: So my question to you is, like, are we supposed to have to, onboard to new clients like this quickly?
487 00:35:47.000 ⇒ 00:35:51.499 Henry Zhao: Because, like, when you get a new client, or when you start working at a new company, right, you have to have time to understand the data, and, like.
488 00:35:51.500 ⇒ 00:35:54.849 Samuel Roberts: Yeah, I think, I think we’re just trying to get them feeling comfortable.
489 00:35:55.350 ⇒ 00:35:56.170 Henry Zhao: What’s that?
490 00:35:56.170 ⇒ 00:35:58.240 Samuel Roberts: I think we’re trying to get them feeling comfortable, you know?
491 00:35:58.240 ⇒ 00:35:58.569 Henry Zhao: Yeah, yeah.
492 00:35:58.570 ⇒ 00:36:03.550 Samuel Roberts: Because we want to make sure that they sign for longer things. I think it really is just kind of a…
493 00:36:04.650 ⇒ 00:36:13.019 Samuel Roberts: let’s explain to them anything we can find about their data, and get it all connected. But yeah, it is pretty quick, but I think it just seems to be the nature of this contract more than anything, so…
494 00:36:13.020 ⇒ 00:36:13.650 Henry Zhao: Yeah.
495 00:36:15.200 ⇒ 00:36:18.899 Henry Zhao: Because I was able to, like, go heads down today, because I didn’t have that much other distractions, but, like.
496 00:36:18.900 ⇒ 00:36:19.460 Samuel Roberts: Yeah.
497 00:36:19.460 ⇒ 00:36:25.200 Henry Zhao: this is not sustainable for all… if I’m getting, like, new clients every week, I can’t, like, pump out analysis every week.
498 00:36:25.200 ⇒ 00:36:29.319 Samuel Roberts: That’s true, yeah, no, I hear you, I hear you. Hopefully it’s not gonna be quite that same…
499 00:36:29.320 ⇒ 00:36:36.699 Henry Zhao: And I understand cursor makes things faster, but I don’t think Cursor replaces any, like, human… because Cursor could have told me that, like.
500 00:36:37.600 ⇒ 00:36:45.170 Henry Zhao: these… these are checkout started, but only as a human looking at it did I know that, like, this is placing order, this is order product, like, what are the nuances?
501 00:36:45.520 ⇒ 00:36:51.049 Samuel Roberts: Right. Yeah. I mean, it might be able to pull out some of that information, but yeah, who knows what it’s gonna actually…
502 00:36:51.940 ⇒ 00:37:02.139 Samuel Roberts: what it’s gonna find, because, yeah, it’s good at certain things, if it’s seen it before, so, like, if it’s seen this Shopify or Klaviyo stuff before, it might have good insight, but it doesn’t always…
503 00:37:02.140 ⇒ 00:37:07.250 Henry Zhao: But also, the example I shared on the data team yesterday, like, I was able to ask that question effectively because I understood the data.
504 00:37:07.560 ⇒ 00:37:12.000 Henry Zhao: Right. It’s just saving me the tedious work of, like, actually going through all the joins and whatever, but I…
505 00:37:12.000 ⇒ 00:37:12.500 Samuel Roberts: Exactly.
506 00:37:12.500 ⇒ 00:37:21.669 Henry Zhao: Because I know how the things work. But if I’m just getting on a new client for now, I can’t just put this stuff in and say, like, analyze this for me, because it’s not gonna know the context.
507 00:37:22.590 ⇒ 00:37:23.350 Samuel Roberts: Right, right.
508 00:37:23.350 ⇒ 00:37:25.120 Henry Zhao: I would not have known that…
509 00:37:26.040 ⇒ 00:37:33.550 Henry Zhao: that, like, to get checkouts, I need to combine these three events. That to ignore this one and include these 3, like, I wouldn’t have known that.
510 00:37:34.180 ⇒ 00:37:35.230 Samuel Roberts: That’s true.
511 00:37:35.230 ⇒ 00:37:35.790 Henry Zhao: Yeah.
512 00:37:40.220 ⇒ 00:37:44.670 Samuel Roberts: Okay. But it would be able to probably explain the spike to me. It might figure out that spike, yeah, exactly.
513 00:37:44.670 ⇒ 00:37:48.100 Henry Zhao: We could do a group buy and be like, alright, here’s what it is, but, you know…
514 00:37:48.640 ⇒ 00:37:49.790 Samuel Roberts: Right, right.
515 00:37:49.790 ⇒ 00:37:50.920 Henry Zhao: Why did this go down over here?
516 00:37:52.690 ⇒ 00:37:54.530 Samuel Roberts: Yeah, that’s crazy, what’s going on with that?
517 00:37:54.530 ⇒ 00:37:56.169 Henry Zhao: It doesn’t even look like it went down.
518 00:37:58.980 ⇒ 00:38:00.570 Henry Zhao: That 8-9 was down.
519 00:38:02.960 ⇒ 00:38:03.880 Henry Zhao: Oh, cool.
520 00:38:05.430 ⇒ 00:38:08.479 Henry Zhao: Alright, alright, here we go. Now that we’ve done that.
521 00:38:11.840 ⇒ 00:38:12.969 Henry Zhao: Okay, proceed.
522 00:38:14.000 ⇒ 00:38:16.699 Samuel Roberts: So that installed Homebrew, now we gotta add, like, okay, right, right.
523 00:38:18.330 ⇒ 00:38:21.530 Samuel Roberts: Okay, so now it’s… now it’s verifying, that’s good, okay.
524 00:38:22.990 ⇒ 00:38:24.729 Henry Zhao: Okay, well, I figured out why I didn’t have homebrew, so that’.
525 00:38:24.730 ⇒ 00:38:26.499 Samuel Roberts: Yeah. Okay, now we should be good.
526 00:38:26.500 ⇒ 00:38:28.830 Henry Zhao: Now I feel better, because I was like, what could have gone wrong?
527 00:38:28.830 ⇒ 00:38:32.660 Samuel Roberts: I know, that’s so frustrating, when you’re like, what, nothing should have changed here, but…
528 00:38:32.660 ⇒ 00:38:38.340 Henry Zhao: I’m just saying, I feel more settled now that I’ve figured out why I don’t have it, so I know it’s not, like, a computer issue, it’s…
529 00:38:38.680 ⇒ 00:38:40.090 Henry Zhao: I just forgot that I got a new laptop.
530 00:38:40.860 ⇒ 00:38:45.780 Henry Zhao: But I was more worried that, like, I set up some path that, like, was pointing me to, I don’t know.
531 00:38:46.160 ⇒ 00:38:47.240 Samuel Roberts: Yeah, yeah.
532 00:38:47.700 ⇒ 00:38:49.900 Samuel Roberts: Cool, okay. Nice, okay.
533 00:38:50.490 ⇒ 00:38:56.799 Samuel Roberts: So now, from this, there’s some way where you tie it to Mother Duck, and I don’t remember what that is.
534 00:38:58.150 ⇒ 00:39:04.329 Samuel Roberts: And then you should be able to run similar commands from the command line here, and get Cursor to help you run those.
535 00:39:09.790 ⇒ 00:39:10.570 Samuel Roberts: Yeah.
536 00:39:14.080 ⇒ 00:39:17.280 Henry Zhao: Also, when you write prompts for AI, do you say please sometimes?
537 00:39:17.280 ⇒ 00:39:33.440 Samuel Roberts: Sometimes, yeah, I’m pretty polite with it. I actually had done an experiment, this was a while back now, so I’d be curious to run it again, where one way I was super polite, and the other way I was super rude and, like, very angry about it, like, you did this wrong, you know, and it went better polite, so…
538 00:39:33.440 ⇒ 00:39:34.769 Henry Zhao: Oh, okay, interesting.
539 00:39:36.030 ⇒ 00:39:38.660 Henry Zhao: I just wonder, like, how that was, like, set up, like…
540 00:39:39.190 ⇒ 00:39:40.570 Samuel Roberts: Yeah, I don’t know. Alright, so…
541 00:39:40.570 ⇒ 00:39:41.290 Henry Zhao: Yep.
542 00:39:43.610 ⇒ 00:39:49.999 Samuel Roberts: Yeah, we might want to make a new folder, maybe, for… I don’t know what’s in this analytics folder, but I think it’s the dbt stuff, so we might want to make a new folder, and…
543 00:39:50.000 ⇒ 00:39:50.870 Henry Zhao: Her mother duck?
544 00:39:50.870 ⇒ 00:39:52.849 Samuel Roberts: And run that in there, yeah.
545 00:39:53.540 ⇒ 00:40:00.129 Henry Zhao: Okay, so… Let’s go to Brainforge and Stinger…
546 00:40:01.680 ⇒ 00:40:03.149 Henry Zhao: Oh, no, this is my folder.
547 00:40:03.150 ⇒ 00:40:05.440 Samuel Roberts: You can just do a red and cursor if you want to just do it over there.
548 00:40:05.440 ⇒ 00:40:07.160 Henry Zhao: Oh yeah, okay, so how do I…
549 00:40:07.540 ⇒ 00:40:09.779 Samuel Roberts: I would just say to look… right-click over here.
550 00:40:11.020 ⇒ 00:40:12.670 Samuel Roberts: Let me just add a folder here.
551 00:40:12.670 ⇒ 00:40:13.120 Henry Zhao: Okay.
552 00:40:13.120 ⇒ 00:40:14.809 Samuel Roberts: So just, like, er, yeah, under… I would…
553 00:40:16.160 ⇒ 00:40:20.070 Samuel Roberts: Where is it? Oh, I have . Oh, is DuckTV already set up here?
554 00:40:21.310 ⇒ 00:40:23.120 Samuel Roberts: Wait, go back to that for a second?
555 00:40:24.540 ⇒ 00:40:28.130 Samuel Roberts: What’s in this dev.db?
556 00:40:28.670 ⇒ 00:40:35.789 Samuel Roberts: Okay, that’s… okay, maybe this is… that’s SeductDB, never mind, okay. I’d say make a new folder at the same level as, Analytics.
557 00:40:36.060 ⇒ 00:40:37.139 Henry Zhao: What do I call it?
558 00:40:37.140 ⇒ 00:40:39.529 Samuel Roberts: I would just call it Mother Duck for now, so we know what we’re looking at.
559 00:40:40.810 ⇒ 00:40:45.279 Samuel Roberts: And then, yeah, let me…
560 00:40:49.220 ⇒ 00:40:51.889 Samuel Roberts: I gotta remember what the command is. Attach…
561 00:40:55.160 ⇒ 00:40:57.699 Samuel Roberts: Okay, yeah, so I think you just run attach…
562 00:41:01.450 ⇒ 00:41:04.709 Samuel Roberts: No, just go to the… go to the command line here.
563 00:41:05.330 ⇒ 00:41:07.190 Henry Zhao: Okay. Let’s go to the terminal real quick.
564 00:41:08.070 ⇒ 00:41:14.390 Samuel Roberts: and then just run, attach, all caps, or then, I don’t know if all caps matters, and then just,
565 00:41:15.100 ⇒ 00:41:21.370 Samuel Roberts: Single quote, MD colon, Sorry, MD for Mother Duck.
566 00:41:22.620 ⇒ 00:41:26.929 Samuel Roberts: And then, single quote, and, semicolon.
567 00:41:27.030 ⇒ 00:41:30.500 Samuel Roberts: And then this should… prompt you to authenticate with Mother Duck.
568 00:41:30.880 ⇒ 00:41:33.030 Samuel Roberts: Oh, sorry, you gotta run DuckDB first.
569 00:41:33.160 ⇒ 00:41:36.709 Samuel Roberts: My bad. That was the terminal, we gotta be in DuckDB, just run DuckDB.
570 00:41:37.860 ⇒ 00:41:40.829 Samuel Roberts: And now run that Attach MD.
571 00:41:41.880 ⇒ 00:41:44.240 Samuel Roberts: And then this should just prompt you somehow.
572 00:41:44.780 ⇒ 00:41:47.790 Samuel Roberts: whether… I don’t know if it’s gonna be a browser thing.
573 00:41:49.260 ⇒ 00:41:49.580 Henry Zhao: Was it.
574 00:41:50.820 ⇒ 00:41:53.319 Samuel Roberts: Yeah, that’s what I just… yeah.
575 00:41:53.320 ⇒ 00:41:54.470 Henry Zhao: Invalid input error.
576 00:41:55.050 ⇒ 00:41:59.679 Samuel Roberts: What’s going on here? You connect Mother Duck by executing, it will automatically download and sign the MotherDuck extension.
577 00:42:00.070 ⇒ 00:42:00.970 Samuel Roberts: Huh.
578 00:42:02.870 ⇒ 00:42:06.690 Samuel Roberts: Oh, it’s not available for this DuckDB version? That’s not good.
579 00:42:08.450 ⇒ 00:42:10.160 Samuel Roberts: Let me see what the version says on the…
580 00:42:11.090 ⇒ 00:42:11.750 Henry Zhao: Okay.
581 00:42:11.750 ⇒ 00:42:15.319 Samuel Roberts: Okay, let’s see, Mother Duck currently supports…
582 00:42:16.960 ⇒ 00:42:22.110 Samuel Roberts: Wait, what version does that say? 1.4.2? It’s only valid for 1.4.1?
583 00:42:22.530 ⇒ 00:42:23.500 Samuel Roberts: What?
584 00:42:24.950 ⇒ 00:42:27.319 Samuel Roberts: Why is that… like that.
585 00:42:28.950 ⇒ 00:42:33.369 Samuel Roberts: Alright, so maybe we need to… ask Cursor to downgrade.
586 00:42:34.800 ⇒ 00:42:39.170 Samuel Roberts: your DuckDB… to 1.4.1.
587 00:42:39.840 ⇒ 00:42:42.170 Samuel Roberts: So I’m sure Brew can do that, I just don’t know.
588 00:42:42.800 ⇒ 00:42:44.199 Samuel Roberts: What the command would be.
589 00:42:50.460 ⇒ 00:42:53.559 Samuel Roberts: Oh.1.1, not 0.2. It is .2, I think.
590 00:42:53.910 ⇒ 00:42:54.390 Henry Zhao: Dennis?
591 00:42:54.390 ⇒ 00:42:56.360 Samuel Roberts: You can hit stop in the corner here.
592 00:42:57.320 ⇒ 00:42:58.430 Samuel Roberts: Yeah, there you go.
593 00:43:02.130 ⇒ 00:43:03.080 Henry Zhao: Really?
594 00:43:03.080 ⇒ 00:43:08.320 Samuel Roberts: Hopefully I wanted to re-download Xcode and stuff then to do that, so hopefully it should be fine.
595 00:43:12.330 ⇒ 00:43:14.919 Samuel Roberts: It’s probably just gonna be, like, a duck to be at, yeah.
596 00:43:18.750 ⇒ 00:43:20.479 Henry Zhao: 1.4x1, alright, all good.
597 00:43:26.650 ⇒ 00:43:27.610 Henry Zhao: Fatal.
598 00:43:29.250 ⇒ 00:43:30.619 Samuel Roberts: What is going on?
599 00:43:31.800 ⇒ 00:43:35.090 Samuel Roberts: Yeah, just to run that, that’ll just install it normally instead of with Brew.
600 00:43:36.800 ⇒ 00:43:38.160 Henry Zhao: Cursor scares me now.
601 00:43:38.670 ⇒ 00:43:43.700 Samuel Roberts: Yeah, once you give it… like, some… you can give it, like, access to automatically run things, but I don’t like doing that, so I just like…
602 00:43:43.700 ⇒ 00:43:45.930 Henry Zhao: Can you access to, like, just clean… clear my hard drive?
603 00:43:45.930 ⇒ 00:43:48.720 Samuel Roberts: Yeah, that’s why I’m scared, because I don’t know what it’s gonna spit out.
604 00:43:52.880 ⇒ 00:43:53.910 Samuel Roberts: Okay.
605 00:43:56.280 ⇒ 00:43:58.910 Samuel Roberts: Oh my goodness, this shouldn’t be this crazy.
606 00:43:59.340 ⇒ 00:44:00.210 Samuel Roberts: Hold on.
607 00:44:04.010 ⇒ 00:44:05.460 Henry Zhao: Alright, here we go.
608 00:44:09.200 ⇒ 00:44:11.430 Henry Zhao: 8.14, 1.4, okay.
609 00:44:11.600 ⇒ 00:44:14.969 Henry Zhao: Has been downgraded, you should now be able to connect to Mother DAC. Alright, so now let’s try it.
610 00:44:18.030 ⇒ 00:44:19.679 Samuel Roberts: Actually, I’d probably have to kill it.
611 00:44:19.680 ⇒ 00:44:21.470 Henry Zhao: Everybody have to… how do I kill it?
612 00:44:21.720 ⇒ 00:44:26.490 Samuel Roberts: I think… I just hit Command or Control-C, I think.
613 00:44:26.890 ⇒ 00:44:28.119 Samuel Roberts: Should exit out.
614 00:44:28.870 ⇒ 00:44:31.160 Henry Zhao: Maybe twice? Oh, that’s not doing it, okay.
615 00:44:31.160 ⇒ 00:44:35.169 Samuel Roberts: How do you quit DuckDB? And this is where I’m just like, I don’t even know DuckDB that well yet.
616 00:44:35.170 ⇒ 00:44:35.780 Henry Zhao: Kayla.
617 00:44:38.780 ⇒ 00:44:40.029 Samuel Roberts: Just exit, maybe?
618 00:44:40.180 ⇒ 00:44:43.550 Henry Zhao: Also, my… computer is, like, overheating now.
619 00:44:43.550 ⇒ 00:44:44.999 Samuel Roberts: Oh, no, okay.
620 00:44:45.000 ⇒ 00:44:45.920 Henry Zhao: dot exit.
621 00:44:45.920 ⇒ 00:44:48.139 Samuel Roberts: Yeah, okay, now try it again.
622 00:44:50.090 ⇒ 00:44:52.359 Samuel Roberts: And then, yeah, there’s 1.441, cool.
623 00:44:53.210 ⇒ 00:44:55.010 Henry Zhao: Wait, was there… no, there’s no…
624 00:44:55.010 ⇒ 00:44:56.069 Samuel Roberts: Yep, just like that.
625 00:44:56.190 ⇒ 00:44:58.110 Samuel Roberts: And now it’s gonna install the…
626 00:44:58.450 ⇒ 00:45:00.589 Samuel Roberts: the extension for Mother Duck, I think.
627 00:45:02.130 ⇒ 00:45:03.460 Samuel Roberts: There it is, cool.
628 00:45:05.210 ⇒ 00:45:07.130 Henry Zhao: I don’t know if this is a Coke, but okay.
629 00:45:07.630 ⇒ 00:45:10.229 Samuel Roberts: Yeah, right? I was just like, hopefully I was the right one at the right time.
630 00:45:10.340 ⇒ 00:45:13.850 Samuel Roberts: And then go back to the… Okay, cool, yeah.
631 00:45:15.900 ⇒ 00:45:18.340 Samuel Roberts: I’m back to cursor and see what it did there.
632 00:45:20.260 ⇒ 00:45:23.039 Samuel Roberts: Cool, okay, so now what you can do is get…
633 00:45:23.300 ⇒ 00:45:27.510 Samuel Roberts: cursor to run DuckDB against Mother Duck, I think, and that’s where…
634 00:45:27.510 ⇒ 00:45:28.289 Henry Zhao: I’m gonna get rid of this album.
635 00:45:29.250 ⇒ 00:45:31.220 Samuel Roberts: Yeah, I should be able to, yeah.
636 00:45:31.660 ⇒ 00:45:37.290 Samuel Roberts: Maybe, like, ask it to check, I don’t know, can it list the tables or something in Mother Duck or something like that?
637 00:45:37.290 ⇒ 00:45:38.860 Henry Zhao: Just to do a quick trick.
638 00:45:43.540 ⇒ 00:45:45.139 Henry Zhao: Alright, well, no one’s done.
639 00:45:47.130 ⇒ 00:45:49.359 Samuel Roberts: Hopefully it understands what’s going on with it.
640 00:45:50.670 ⇒ 00:45:53.360 Samuel Roberts: We don’t need a Mother Duck token that we did this already.
641 00:45:55.930 ⇒ 00:45:58.839 Samuel Roberts: Okay, just hit run and see what happens, because I don’t think it’s gonna work.
642 00:46:00.230 ⇒ 00:46:03.329 Samuel Roberts: Yeah, just, okay, hit that affect what we want, we don’t want to see the analytics.
643 00:46:06.770 ⇒ 00:46:09.019 Samuel Roberts: Yeah, that’s great, okay. Oh.
644 00:46:11.620 ⇒ 00:46:12.410 Samuel Roberts: Alright.
645 00:46:14.150 ⇒ 00:46:18.509 Samuel Roberts: I don’t know, I don’t know what to do about that.
646 00:46:18.650 ⇒ 00:46:24.550 Samuel Roberts: You may just have to play around a little bit, or see what it can do, but maybe… maybe ask Amber how she’s been doing it, because I thought this would have worked, but…
647 00:46:25.190 ⇒ 00:46:25.600 Henry Zhao: Okay.
648 00:46:25.600 ⇒ 00:46:31.180 Samuel Roberts: I don’t know. Sorry. We’ve now exhausted what I understand about DuckDB and Mother Duck, so…
649 00:46:31.180 ⇒ 00:46:34.749 Henry Zhao: Alright, no worries, we will release you, and I will get Amber to help as well.
650 00:46:34.750 ⇒ 00:46:35.380 Samuel Roberts: Okay.
651 00:46:35.380 ⇒ 00:46:37.030 Henry Zhao: Or Awish. Awash knows this stuff, too.
652 00:46:37.030 ⇒ 00:46:39.240 Samuel Roberts: Oh, yeah, we probably have… yeah, that’d be good. Okay.
653 00:46:40.090 ⇒ 00:46:40.780 Samuel Roberts: Alright, good luck.
654 00:46:41.120 ⇒ 00:46:42.099 Henry Zhao: Appreciate it.
655 00:46:42.100 ⇒ 00:46:43.720 Samuel Roberts: Alright, yep, bye-bye.