Meeting Title: Honey Stinger Data Integration Sync Date: 2025-11-13 Meeting participants: Henry Zhao, Samuel Roberts
WEBVTT
1 00:00:07.380 ⇒ 00:00:08.829 Henry Zhao: Hey Sam, how’s it going?
2 00:00:10.320 ⇒ 00:00:12.040 Samuel Roberts: Good. How about you?
3 00:00:12.810 ⇒ 00:00:13.930 Henry Zhao: Good, thanks.
4 00:00:14.340 ⇒ 00:00:15.410 Henry Zhao: Share my screen.
5 00:00:15.680 ⇒ 00:00:16.650 Samuel Roberts: Yeah, yeah.
6 00:00:19.760 ⇒ 00:00:28.420 Henry Zhao: Yeah, so I’m pretty busy doing the analysis for the slides today, so I was wondering if you can just… I don’t have time to really set up Jupyter Notebook or Curse or anything like that right now.
7 00:00:28.440 ⇒ 00:00:29.560 Samuel Roberts: Yeah. So…
8 00:00:29.560 ⇒ 00:00:35.239 Henry Zhao: Do you have what you need to be able to set up these 5 scripts, to run based on the mother duck data that we have?
9 00:00:35.640 ⇒ 00:00:44.450 Samuel Roberts: Yeah, so I was actually, working with Cursor to figure out this, like, having… I had it do a first pass of, like, what’s going on here, and it is really good at summarizing that.
10 00:00:45.090 ⇒ 00:00:52.920 Samuel Roberts: And so what I’m doing now, I was just looking at the mother duck to figure out… so we’re looking for the Amazon and the Shopify customers, is that correct?
11 00:00:52.920 ⇒ 00:00:55.939 Henry Zhao: Yeah, which we have already, right? We have…
12 00:00:56.290 ⇒ 00:00:57.190 Samuel Roberts: Yeah.
13 00:00:57.190 ⇒ 00:01:01.339 Henry Zhao: Amazon here, Shopify here… is there anything else?
14 00:01:01.630 ⇒ 00:01:07.429 Samuel Roberts: That’s what I was… no, there’s the Shopify wholesale, and we… we don’t have Walmart access yet, but there should be Walmart access eventually.
15 00:01:08.070 ⇒ 00:01:09.500 Henry Zhao: Okay, so Ray, I’m just doing that.
16 00:01:10.700 ⇒ 00:01:13.179 Samuel Roberts: Yeah, there’s customers there. There’s also the…
17 00:01:13.480 ⇒ 00:01:16.769 Samuel Roberts: the wholesale. I guess we could include that, but I don’t know how much that’ll match.
18 00:01:16.930 ⇒ 00:01:19.610 Samuel Roberts: The Amazon, I wasn’t sure where the customers are here.
19 00:01:20.110 ⇒ 00:01:21.470 Henry Zhao: Oh, okay.
20 00:01:23.400 ⇒ 00:01:24.479 Samuel Roberts: See none.
21 00:01:28.130 ⇒ 00:01:31.770 Henry Zhao: Yeah, and then, like, how would we join that to the Klaviyo data, right?
22 00:01:31.770 ⇒ 00:01:37.429 Samuel Roberts: That’s… yeah, the Klaviyo, we can also probably pull out the names and match that. I can probably adapt this code.
23 00:01:37.980 ⇒ 00:01:41.940 Samuel Roberts: Is that what we’re looking? We want to match Klaviyo as well?
24 00:01:43.460 ⇒ 00:01:46.269 Henry Zhao: Mmm… probably if we can.
25 00:01:46.680 ⇒ 00:01:51.480 Samuel Roberts: Okay, yeah, it looks like Profiles has first name, Last name.
26 00:01:52.070 ⇒ 00:01:52.920 Samuel Roberts: Okay.
27 00:01:57.740 ⇒ 00:02:02.820 Samuel Roberts: But yeah, I wasn’t sure. Maybe I didn’t tie the right Amazon thing, but that’s what I had access to, so…
28 00:02:03.020 ⇒ 00:02:03.680 Henry Zhao: Yeah.
29 00:02:04.960 ⇒ 00:02:07.539 Samuel Roberts: Oh, it’s still sinking? Maybe it’s… what?
30 00:02:09.669 ⇒ 00:02:10.709 Henry Zhao: Let’s take a look at,
31 00:02:11.879 ⇒ 00:02:17.319 Henry Zhao: Do you think this is from Amazon, or is it from Polytomic? I don’t think it’s from Polytomic, right? Because there’s no Polytomic…
32 00:02:17.320 ⇒ 00:02:19.609 Samuel Roberts: No, it’s… this is from Fivetran.
33 00:02:20.150 ⇒ 00:02:21.100 Henry Zhao: Oh, okay.
34 00:02:21.480 ⇒ 00:02:26.839 Samuel Roberts: for Amazon and for Walmart, we were gonna have to use that, is what Utam had me set up. I just don’t see…
35 00:02:26.840 ⇒ 00:02:29.159 Henry Zhao: That’s called Vibrant Synced.
36 00:02:33.390 ⇒ 00:02:35.960 Samuel Roberts: Yeah, I don’t see it even in fact, so I don’t even…
37 00:02:37.070 ⇒ 00:02:40.599 Samuel Roberts: I think I just picked everything that would have been available.
38 00:02:42.330 ⇒ 00:02:46.200 Samuel Roberts: Unless I just missed… That’s pretty much everything there.
39 00:02:46.730 ⇒ 00:02:49.260 Henry Zhao: Yeah, I don’t see it in any of the order data tables either.
40 00:02:49.260 ⇒ 00:02:50.990 Samuel Roberts: Yeah, that’s weird, okay.
41 00:02:53.910 ⇒ 00:02:55.170 Samuel Roberts: So that might be an issue.
42 00:02:57.270 ⇒ 00:03:03.119 Samuel Roberts: Yeah, I will investigate that in Fivetran, then. I just don’t know…
43 00:03:05.700 ⇒ 00:03:09.299 Samuel Roberts: What other Amazon did they even have here to connect? Because I thought that was it.
44 00:03:10.600 ⇒ 00:03:12.110 Samuel Roberts: Added connections…
45 00:03:12.110 ⇒ 00:03:15.080 Henry Zhao: Yeah, this seems like more of the setup of Amazon, not the, like.
46 00:03:15.080 ⇒ 00:03:18.430 Samuel Roberts: It does, doesn’t it? Maybe I picked the wrong thing?
47 00:03:18.760 ⇒ 00:03:21.609 Samuel Roberts: Amazon ads, Amazon Selling Partner?
48 00:03:22.440 ⇒ 00:03:27.450 Samuel Roberts: Seller Central and Vendor Central, the official Amazon business to manage their Amazon sales activity, yeah.
49 00:03:28.330 ⇒ 00:03:30.269 Henry Zhao: Can you share your screen so I can see what you see?
50 00:03:30.440 ⇒ 00:03:32.700 Henry Zhao: Sure, sure, yeah, yeah.
51 00:03:32.700 ⇒ 00:03:37.310 Samuel Roberts: I’m looking at… Where am I? This… So…
52 00:03:37.480 ⇒ 00:03:39.710 Samuel Roberts: I just went into 5chan looking at what…
53 00:03:40.020 ⇒ 00:03:43.170 Samuel Roberts: What is… is DSP? Demand side?
54 00:03:44.050 ⇒ 00:03:48.859 Samuel Roberts: But what I set up was Amazon’s selling partner, and that’s what I seem to have access to, but it doesn’t seem to do…
55 00:03:49.750 ⇒ 00:03:52.560 Samuel Roberts: This must just manage the products, then, so we need…
56 00:03:53.730 ⇒ 00:03:54.290 Henry Zhao: But it doesn’t.
57 00:03:54.290 ⇒ 00:03:56.129 Samuel Roberts: How do you manage that?
58 00:03:56.630 ⇒ 00:04:00.770 Samuel Roberts: That’s what I would have thought it would have had here, but I don’t see anything about…
59 00:04:02.950 ⇒ 00:04:06.099 Samuel Roberts: Custom data. No, it’s not customer data.
60 00:04:07.180 ⇒ 00:04:12.189 Samuel Roberts: But if I go back up here, let’s see what the other Amazons are here. So there’s Amazon ads…
61 00:04:12.940 ⇒ 00:04:20.429 Samuel Roberts: That’s not it. Amazon Attribution… Amazon CloudFront, that’s CDN.
62 00:04:20.709 ⇒ 00:04:29.500 Samuel Roberts: DSP… That’s not what we want, though, right? This is… marketing.
63 00:04:29.500 ⇒ 00:04:31.030 Henry Zhao: All aspects.
64 00:04:32.560 ⇒ 00:04:33.220 Samuel Roberts: Sorry?
65 00:04:33.690 ⇒ 00:04:36.029 Henry Zhao: Meanwhile, I’ll ask Perplexity to see if they know anything.
66 00:04:36.320 ⇒ 00:04:37.689 Samuel Roberts: Oh, good idea, yeah.
67 00:04:38.670 ⇒ 00:04:39.889 Henry Zhao: Yeah, I’ll do that while you do this.
68 00:04:40.370 ⇒ 00:04:44.679 Samuel Roberts: Okay, yeah, that’s all they said. Amazon selling partner seemed like it would have been the right thing.
69 00:04:45.630 ⇒ 00:04:47.769 Samuel Roberts: Let me go to…
70 00:05:03.220 ⇒ 00:05:06.069 Samuel Roberts: Oh, wait a minute, maybe they don’t get that information.
71 00:05:07.670 ⇒ 00:05:10.370 Henry Zhao: Okay, perfect says Amazon’s selling partner, so…
72 00:05:10.910 ⇒ 00:05:11.430 Samuel Roberts: Yeah.
73 00:05:11.680 ⇒ 00:05:14.069 Henry Zhao: But it’s coming from orders and order items.
74 00:05:14.380 ⇒ 00:05:15.799 Henry Zhao: Do we have those tables?
75 00:05:16.010 ⇒ 00:05:19.690 Samuel Roberts: Orders, back to Mother Duh.
76 00:05:19.690 ⇒ 00:05:21.359 Henry Zhao: I think I saw order items.
77 00:05:22.290 ⇒ 00:05:25.379 Samuel Roberts: No, there’s items something. Oh, too far to the water.
78 00:05:28.190 ⇒ 00:05:30.540 Samuel Roberts: Ordered quantity details…
79 00:05:34.110 ⇒ 00:05:36.409 Samuel Roberts: It’s catalog, but that’s not it.
80 00:05:37.850 ⇒ 00:05:40.280 Samuel Roberts: Hmm… okay, hmm.
81 00:05:40.790 ⇒ 00:05:43.210 Henry Zhao: Do you not have the proper API permissions?
82 00:05:43.540 ⇒ 00:05:46.599 Samuel Roberts: That’s possible, I don’t know.
83 00:05:47.900 ⇒ 00:05:52.600 Henry Zhao: Because, see, I saw orders there. Can you go back to the previous screen you were just showing? I saw orders there, see?
84 00:05:53.000 ⇒ 00:05:54.889 Henry Zhao: Priority first thing, reports, finance, and orders model.
85 00:05:54.890 ⇒ 00:05:57.120 Samuel Roberts: Oh, yeah, you’re right, you’re right, okay, so there’s orders.
86 00:05:57.270 ⇒ 00:05:59.260 Samuel Roberts: Financial shipment event?
87 00:06:00.310 ⇒ 00:06:00.660 Henry Zhao: Did you mind?
88 00:06:00.660 ⇒ 00:06:02.220 Samuel Roberts: That’s what I did, though.
89 00:06:02.700 ⇒ 00:06:05.069 Henry Zhao: But yeah, it might be a permission issue, yeah.
90 00:06:08.910 ⇒ 00:06:10.519 Samuel Roberts: I thought I’d… hmm.
91 00:06:11.230 ⇒ 00:06:14.050 Henry Zhao: Why did somebody call it CockroachDB? That’s crazy.
92 00:06:14.520 ⇒ 00:06:16.210 Samuel Roberts: Isn’t that crazy? Yeah, I don’t know.
93 00:06:16.830 ⇒ 00:06:18.139 Samuel Roberts: Some things are weird.
94 00:06:18.430 ⇒ 00:06:20.509 Samuel Roberts: People got a better sense of humor.
95 00:06:21.790 ⇒ 00:06:29.739 Samuel Roberts: Okay, so, that’s the API configure, not the setup guide.
96 00:06:32.550 ⇒ 00:06:35.359 Samuel Roberts: Active and Vendor Central.
97 00:06:36.700 ⇒ 00:06:40.110 Samuel Roberts: I don’t remember what axis I even have here, which one was this?
98 00:06:41.430 ⇒ 00:06:43.729 Samuel Roberts: Yeah, Honey Singer, Amazon.
99 00:06:46.990 ⇒ 00:06:48.559 Samuel Roberts: Hold on, okay.
100 00:07:02.160 ⇒ 00:07:08.420 Samuel Roberts: I don’t want that okay,
101 00:07:14.150 ⇒ 00:07:16.129 Samuel Roberts: Another way to do this on…
102 00:07:25.420 ⇒ 00:07:27.590 Samuel Roberts: They’re the OTP… okay, hold on.
103 00:07:31.490 ⇒ 00:07:34.949 Samuel Roberts: That’s how it works. Good. Okay, we are not authorized. Okay, that’s weird.
104 00:07:35.280 ⇒ 00:07:36.740 Henry Zhao: There, there we go.
105 00:07:37.460 ⇒ 00:07:39.110 Samuel Roberts: But that definitely is…
106 00:07:40.780 ⇒ 00:07:45.459 Samuel Roberts: Oh, I set it to the wrong one, didn’t I? No, it’s here. Okay, I see what happened here.
107 00:07:46.620 ⇒ 00:07:50.170 Samuel Roberts: I made a mistake. Okay, we’re gonna go back. We’re gonna log in.
108 00:07:50.510 ⇒ 00:07:53.490 Samuel Roberts: We’re gonna do this the right way now. We’re gonna sign in.
109 00:07:54.050 ⇒ 00:07:57.589 Samuel Roberts: We gotta do… I think I messed up here, though, and I put it on the wrong account.
110 00:08:00.990 ⇒ 00:08:06.720 Samuel Roberts: Yeah, I messed up here. Okay, let me… I broke it now, Graves.
111 00:08:07.200 ⇒ 00:08:09.020 Samuel Roberts: Oh, boy.
112 00:08:18.650 ⇒ 00:08:20.199 Samuel Roberts: Didn’t receive code.
113 00:08:21.540 ⇒ 00:08:23.040 Samuel Roberts: I don’t know what’s going on here.
114 00:08:23.150 ⇒ 00:08:25.590 Samuel Roberts: Oh my goodness, I broke it so hard.
115 00:08:28.580 ⇒ 00:08:34.720 Samuel Roberts: Okay, let me explore this more, but then once we get that, we’re just looking to
116 00:08:34.960 ⇒ 00:08:40.089 Samuel Roberts: run that script, basically, with different inputs instead of the CSVs that it was before.
117 00:08:40.539 ⇒ 00:08:41.229 Henry Zhao: Yeah.
118 00:08:41.230 ⇒ 00:08:43.540 Samuel Roberts: Where the CS… instead of the CSVs.
119 00:08:43.710 ⇒ 00:08:48.880 Samuel Roberts: We’ll just run it on… whatever…
120 00:08:49.520 ⇒ 00:08:57.690 Samuel Roberts: profiles from Klaviyo, maybe, and the… customers from Shopify, Okay.
121 00:08:58.560 ⇒ 00:08:59.160 Henry Zhao: Yeah.
122 00:08:59.440 ⇒ 00:09:00.710 Samuel Roberts: Alright, yeah, the one thing I was…
123 00:09:00.710 ⇒ 00:09:03.319 Henry Zhao: The Shopify and Amazon ones, and then…
124 00:09:03.320 ⇒ 00:09:07.170 Samuel Roberts: We can figure out who can connect it to Klavi, which Klave just has one ID, so…
125 00:09:08.770 ⇒ 00:09:09.240 Samuel Roberts: Okay.
126 00:09:09.650 ⇒ 00:09:14.039 Henry Zhao: Profiles table. Yeah, you can look at their profiles table to see what we could join on.
127 00:09:17.880 ⇒ 00:09:18.689 Samuel Roberts: Say that again?
128 00:09:19.050 ⇒ 00:09:21.670 Henry Zhao: There’s the profiles table for,
129 00:09:22.670 ⇒ 00:09:24.630 Henry Zhao: Klaviyo, you can just see if that’s joinable.
130 00:09:25.600 ⇒ 00:09:26.360 Henry Zhao: I’ll be right back.
131 00:09:26.360 ⇒ 00:09:27.840 Samuel Roberts: Oh, yeah. Okay.
132 00:09:29.740 ⇒ 00:09:33.630 Samuel Roberts: Yeah, I got first name, last name… Okay.
133 00:09:40.940 ⇒ 00:09:46.250 Henry Zhao: Okay, just that. So yeah, just to look at the profile to see what you can join on, if it’s email, first name, last name, whatever.
134 00:09:46.430 ⇒ 00:09:47.180 Henry Zhao: Probably a year.
135 00:09:47.180 ⇒ 00:09:49.200 Samuel Roberts: Here we go to the Vendor Central. Okay, here we go.
136 00:09:49.900 ⇒ 00:09:52.809 Samuel Roberts: This is where I… this is how I connected it, maybe…
137 00:09:54.930 ⇒ 00:09:57.490 Samuel Roberts: So Vendor Central’s there, Merchant ID,
138 00:10:01.480 ⇒ 00:10:04.369 Samuel Roberts: Alright, I’ll keep digging into the Amazon stuff, see what I can figure out.
139 00:10:04.370 ⇒ 00:10:04.860 Henry Zhao: Okay.
140 00:10:04.860 ⇒ 00:10:05.790 Samuel Roberts: I will let you know.
141 00:10:06.270 ⇒ 00:10:07.300 Samuel Roberts: But yeah, I think I got…
142 00:10:07.300 ⇒ 00:10:07.950 Henry Zhao: north.
143 00:10:08.130 ⇒ 00:10:13.860 Samuel Roberts: I got a pretty good sense from Cursor, even. Actually, I can show you what Cursor suggested, but… Okay.
144 00:10:13.860 ⇒ 00:10:16.490 Henry Zhao: Yeah, I’ll sync with you again in one or two hours to see the progress.
145 00:10:16.490 ⇒ 00:10:17.120 Samuel Roberts: Sounds good.
146 00:10:17.290 ⇒ 00:10:18.110 Henry Zhao: Alright, thank you. Bye-bye.
147 00:10:18.110 ⇒ 00:10:19.990 Samuel Roberts: Yep, see what I can get. Bye.