Meeting Title: [Javvy] Daily Standup Date: 2025-04-02 Meeting participants: Annie Yu, Robert Tseng, Awaish Kumar, Caio Velasco
WEBVTT
1 00:00:23.470 ⇒ 00:00:26.640 Robert Tseng: Hey? Wish, hope you’re feeling better
2 00:00:27.463 ⇒ 00:00:29.110 Awaish Kumar: Yeah, hello.
3 00:00:29.560 ⇒ 00:00:31.750 Awaish Kumar: This will be better. But yeah.
4 00:00:33.480 ⇒ 00:00:34.360 Robert Tseng: What happens.
5 00:00:35.800 ⇒ 00:00:41.230 Awaish Kumar: Get the call. And the yeah.
6 00:00:41.230 ⇒ 00:00:42.000 Robert Tseng: Okay.
7 00:00:43.152 ⇒ 00:00:47.580 Awaish Kumar: Did it impact everyone in your family, or just you
8 00:00:49.120 ⇒ 00:00:54.280 Awaish Kumar: like, half of the people are already here
9 00:00:56.178 ⇒ 00:01:00.059 Robert Tseng: Half of the people were already sick, and then you got sick from that. Maybe
10 00:01:00.710 ⇒ 00:01:01.360 Awaish Kumar: Yes.
11 00:01:01.360 ⇒ 00:01:03.800 Robert Tseng: Okay, yeah, that’s how it is.
12 00:01:09.590 ⇒ 00:01:13.710 Robert Tseng: Yeah. My my wife gets sick more frequently than I do
13 00:01:13.830 ⇒ 00:01:17.249 Robert Tseng: whenever she gets sick. I know that I’m gonna get sick. So
14 00:01:21.020 ⇒ 00:01:27.110 Robert Tseng: can’t imagine. Once, I mean, once, our family is bigger and kids and other people around. And it’s just
15 00:01:27.870 ⇒ 00:01:30.111 Robert Tseng: someone’s always gonna be sick.
16 00:01:44.280 ⇒ 00:01:54.679 Robert Tseng: Yeah, well, I guess you weren’t here yesterday. So I mean, just the heads up is, there is no formal Eden plan kind of session today. Stand up, Will. Just?
17 00:01:54.840 ⇒ 00:01:59.440 Robert Tseng: It’s it’s just a planning session, and no one, no one will be there except for me. So
18 00:02:01.220 ⇒ 00:02:01.910 Awaish Kumar: Okay.
19 00:02:02.940 ⇒ 00:02:05.379 Robert Tseng: Yeah. But I do know that I know you’re trying to
20 00:02:05.500 ⇒ 00:02:12.509 Robert Tseng: catch up and pick up on things. So if we need to meet, just let me know, and I’ll I’ll meet with you because
21 00:02:13.170 ⇒ 00:02:16.219 Robert Tseng: we’re wait. Yeah, obviously, we’re waiting on a couple of things. Review
22 00:02:18.962 ⇒ 00:02:33.813 Awaish Kumar: Yeah, for, like Hi, Fajabi, I know that we have this no model to build for any, for
23 00:02:35.990 ⇒ 00:02:41.659 Awaish Kumar: to build this like a cumulative revenue, and the cogs thing
24 00:02:43.410 ⇒ 00:02:49.670 Robert Tseng: Yeah, I guess we’ll talk through that more now. On this call. So no, no worries. But we’ll make sure you’re clear on that.
25 00:02:50.610 ⇒ 00:02:51.590 Robert Tseng: Annie.
26 00:02:53.350 ⇒ 00:02:54.270 Annie Yu: Hello guys.
27 00:02:58.570 ⇒ 00:02:59.609 Robert Tseng: How are you doing
28 00:03:01.350 ⇒ 00:03:04.990 Annie Yu: Pretty good trying to have my breakfast.
29 00:03:06.060 ⇒ 00:03:07.950 Annie Yu: In the meantime
30 00:03:09.020 ⇒ 00:03:13.900 Robert Tseng: Did. Did you have to change your schedule to be more early morning person
31 00:03:14.818 ⇒ 00:03:20.199 Annie Yu: Not really. I I think I can. I can do really early, but I can do really late.
32 00:03:20.400 ⇒ 00:03:23.400 Annie Yu: So I go to bed early. So this is not like
33 00:03:23.400 ⇒ 00:03:26.080 Robert Tseng: Okay, you can’t do very late. So you prefer that early
34 00:03:26.840 ⇒ 00:03:27.600 Annie Yu: Okay.
35 00:03:27.830 ⇒ 00:03:28.520 Robert Tseng: That’s good.
36 00:03:29.540 ⇒ 00:03:34.140 Annie Yu: My brain, my brain stops functioning after a certain time
37 00:03:34.600 ⇒ 00:03:40.319 Robert Tseng: I I agree every time I’m telling myself I want to try to finish something else.
38 00:03:40.490 ⇒ 00:03:43.619 Robert Tseng: And the evening it takes me like 5 times as long, so
39 00:03:44.105 ⇒ 00:03:44.590 Annie Yu: Yeah.
40 00:03:45.310 ⇒ 00:03:46.510 Robert Tseng: Yeah. Hey? Kyle.
41 00:03:49.200 ⇒ 00:03:50.780 Caio Velasco: Hello! How’s it going
42 00:03:52.140 ⇒ 00:03:52.990 Robert Tseng: Good
43 00:03:53.605 ⇒ 00:04:02.919 Robert Tseng: I think it’s just this group right now. I think Akash won’t be here, so I’ll be kind of trying to stand up today. Let me just share my screen, and then we can kinda get into it.
44 00:04:06.780 ⇒ 00:04:07.980 Robert Tseng: Yeah, I guess
45 00:04:13.040 ⇒ 00:04:30.539 Robert Tseng: I just, I just have a different style from Akash so apologies. But I I prefer to just go through without. Why, that one by one per person, because I think it’s good for everyone to talk through it. So maybe we’ll just talk through things that are in progress really quick. And then things that we’re waiting on here and testing.
46 00:04:30.700 ⇒ 00:04:31.655 Robert Tseng: So
47 00:04:32.900 ⇒ 00:04:36.900 Robert Tseng: Oh, and then we also have like this, pr review. So I just wanna clear that out, too.
48 00:04:37.951 ⇒ 00:04:44.209 Robert Tseng: Yeah. The gross margin. Qa, and comparing with shopify platform. Yeah, this is, we’re still
49 00:04:44.400 ⇒ 00:04:53.459 Robert Tseng: we need to reschedule time with a month. So this is still, gonna stay there. Platform of processing fees update. I’m pretty sure this is done a wish right? So I mean
50 00:04:53.810 ⇒ 00:04:55.959 Robert Tseng: using it. So we should be good there. Yeah.
51 00:04:56.390 ⇒ 00:04:58.893 Robert Tseng: So check you there.
52 00:05:01.740 ⇒ 00:05:08.080 Robert Tseng: alright. And then also same thing. Here. I think the Macro stream operations. This is also done
53 00:05:08.950 ⇒ 00:05:09.830 Annie Yu: This one.
54 00:05:10.700 ⇒ 00:05:20.427 Annie Yu: The dashboards was updated, and I just made a couple of fix a couple of changes.
55 00:05:21.330 ⇒ 00:05:29.499 Annie Yu: to that model. So I push a Pr. Re a Pr. Request, and I think Awaii probably will
56 00:05:29.500 ⇒ 00:05:30.170 Robert Tseng: Oh, okay.
57 00:05:30.170 ⇒ 00:05:32.320 Annie Yu: Do it and and merge it.
58 00:05:35.060 ⇒ 00:05:39.130 Annie Yu: Wait, actually, wait. Is this one? I think this one, yeah.
59 00:05:39.530 ⇒ 00:05:40.020 Awaish Kumar: If this were
60 00:05:40.020 ⇒ 00:05:40.490 Robert Tseng: This? Is it
61 00:05:40.490 ⇒ 00:05:42.660 Awaish Kumar: Can be done right. There is only
62 00:05:44.210 ⇒ 00:05:48.680 Awaish Kumar: so. The request on this ticket, like they were already done right
63 00:05:50.690 ⇒ 00:05:51.060 Annie Yu: Yeah.
64 00:05:51.590 ⇒ 00:05:54.879 Robert Tseng: Yeah, I I think so. This is like a week old side.
65 00:05:54.880 ⇒ 00:05:55.290 Robert Tseng: Yeah.
66 00:05:57.950 ⇒ 00:05:58.510 Awaish Kumar: Yeah.
67 00:05:58.770 ⇒ 00:06:04.174 Annie Yu: Yeah, there, there’s just like another Pr waiting to be reviewed, I believe.
68 00:06:04.590 ⇒ 00:06:08.360 Robert Tseng: On this on this one. Still, okay? Yeah. Actually.
69 00:06:09.220 ⇒ 00:06:11.240 Robert Tseng: do you? Do you mind adding that pr, think
70 00:06:11.270 ⇒ 00:06:11.910 Awaish Kumar: I think
71 00:06:11.910 ⇒ 00:06:19.800 Annie Yu: Akash. Actually, yeah, I’m not sure if it’s this one or or the the dashboard one.
72 00:06:20.220 ⇒ 00:06:21.040 Annie Yu: But
73 00:06:21.910 ⇒ 00:06:22.320 Robert Tseng: Got it.
74 00:06:25.050 ⇒ 00:06:27.320 Robert Tseng: I will check both
75 00:06:27.320 ⇒ 00:06:29.010 Annie Yu: That’s probably this one
76 00:06:29.010 ⇒ 00:06:31.230 Robert Tseng: Yeah, it was this one. Okay, cool.
77 00:06:32.680 ⇒ 00:06:34.630 Robert Tseng: So, yeah.
78 00:06:35.660 ⇒ 00:06:39.789 Robert Tseng: this one still needs to be merged or like, the Pr still needs to be reviewed. Right? So
79 00:06:42.810 ⇒ 00:06:43.370 Awaish Kumar: Okay.
80 00:06:48.920 ⇒ 00:06:55.189 Robert Tseng: Yeah, sorry. I don’t know which pr, it is. I would have dropped the link in here, but maybe next time, if we could add the link there, that’d be helpful
81 00:06:55.190 ⇒ 00:06:57.840 Awaish Kumar: No, I will check on Github
82 00:06:59.070 ⇒ 00:07:00.520 Robert Tseng: Okay. Cool.
83 00:07:00.520 ⇒ 00:07:01.440 Annie Yu: Fluoresh
84 00:07:02.430 ⇒ 00:07:09.740 Robert Tseng: Yeah, oops wrong client. Alright. So I’m just gonna close this one out.
85 00:07:10.010 ⇒ 00:07:18.360 Robert Tseng: And this one also. Finally done, I think, I will do the Amazon
86 00:07:19.890 ⇒ 00:07:29.350 Robert Tseng: investigation. I sent this doc to them. Basically, my conclusions were like most of the cancellations are coming from orders that are $50 or more.
87 00:07:29.832 ⇒ 00:07:56.119 Robert Tseng: On average, the cancellation rate is around 20%. And so and they’re all from that new customers. So I’m just wondering, like, How do we break out these net new customers. More? Maybe it would. Yeah. I mean, this goes back to the subscribe and save and the prime labeling but yeah, just wanted to kind of share this out with the team real quick, too. Kyle, your findings. I kinda just copy. Paste it as like kind of questions in here, and then I also shared your blockers.
88 00:07:56.507 ⇒ 00:08:02.329 Robert Tseng: But yeah. Then I also just share a bunch of queries that I ran in order to investigate this more.
89 00:08:02.919 ⇒ 00:08:21.009 Robert Tseng: So I think, yeah, the next. This is a pretty like early stage investigation, like, I want to be doing more analysis like this, especially for for Annie, and less like reporting, dashboarding, or we’re really trying to answer questions and come up with recommendations that we give them.
90 00:08:21.737 ⇒ 00:08:26.240 Robert Tseng: But yeah, so I think this is really the 1st one that we really put in front of them.
91 00:08:27.420 ⇒ 00:08:29.949 Robert Tseng: Yeah, I just wanted to share that out
92 00:08:29.950 ⇒ 00:08:44.929 Caio Velasco: Robert, that that looks good like. Do you mind sending me the the link to that form so that I can add to effects that I’m creating for for Javi, because I’m learning a lot about Amazon and my grading effects. And I can just add that to one of the lines for students
93 00:08:44.930 ⇒ 00:08:45.310 Robert Tseng: Oh, yeah.
94 00:08:45.310 ⇒ 00:08:46.860 Caio Velasco: Has its own motion.
95 00:08:47.690 ⇒ 00:08:48.380 Robert Tseng: Sure.
96 00:08:53.600 ⇒ 00:08:55.341 Robert Tseng: can I just tag you in linear?
97 00:08:55.590 ⇒ 00:08:55.965 Caio Velasco: Yeah.
98 00:08:56.580 ⇒ 00:09:06.219 Robert Tseng: Okay, I know. Sorry we have black, linear and all these places. But yeah, then I’ll do
99 00:09:09.330 ⇒ 00:09:10.040 Robert Tseng: right?
100 00:09:13.050 ⇒ 00:09:15.120 Robert Tseng: I think that’s actually right. Yeah, okay, that’s great.
101 00:09:15.120 ⇒ 00:09:15.710 Caio Velasco: The.
102 00:09:15.890 ⇒ 00:09:16.540 Robert Tseng: Oh.
103 00:09:22.110 ⇒ 00:09:29.520 Robert Tseng: yeah, the Klavio and attentive sample. I think we were still kind of blocked on the attentive side. Any more thoughts on this
104 00:09:32.020 ⇒ 00:09:32.670 Robert Tseng: await
105 00:09:33.257 ⇒ 00:09:36.192 Awaish Kumar: On the attentive. Yeah, we
106 00:09:37.940 ⇒ 00:09:42.780 Awaish Kumar: blocked I I had to check some events if they are triggered and we have data.
107 00:09:43.803 ⇒ 00:09:44.609 Awaish Kumar: But if
108 00:09:46.570 ⇒ 00:09:51.859 Awaish Kumar: but I have to go back and see if if is it is not, then I have to ask. Come in to
109 00:09:52.110 ⇒ 00:09:55.659 Awaish Kumar: send some test events, so we can see if we are catching the data
110 00:09:57.110 ⇒ 00:09:57.810 Robert Tseng: Okay.
111 00:10:01.710 ⇒ 00:10:05.190 Robert Tseng: Yeah, I will keep this here just because I want to.
112 00:10:11.370 ⇒ 00:10:17.070 Robert Tseng: Okay, also, can you find feedback?
113 00:10:18.630 ⇒ 00:10:27.389 Robert Tseng: Great? Alright? So Amazon colleagues into dim products data model. I know that you’ve been messaging a lot.
114 00:10:27.740 ⇒ 00:10:33.710 Robert Tseng: The channel, Kyle, I just got added to the group. So I haven’t actually checked what was set there. But maybe you want to give us an update. There
115 00:10:34.150 ⇒ 00:10:46.360 Caio Velasco: Yeah, no worries. So so 2 separate things. First, st it’s about the source which we have been asking Aman. And he created a group with this other person. I think it’s Alaya
116 00:10:47.540 ⇒ 00:10:48.869 Caio Velasco: Oh, okay.
117 00:10:49.160 ⇒ 00:11:02.000 Caio Velasco: yeah. And over there I I sent another like kind of like a big text, but very organized, so that he understands what is happening and what what are we trying to build with those
118 00:11:02.120 ⇒ 00:11:06.460 Caio Velasco: tabs that we added after the Amazon tab in in the spreadsheet?
119 00:11:07.386 ⇒ 00:11:18.421 Caio Velasco: Which is basically something that you know similar to shopify. But there might be other things by other assumptions or other costs and fees, assumptions that he can also add. And then I provided a lot of
120 00:11:18.890 ⇒ 00:11:25.519 Caio Velasco: of the research links for the research I’ve been been doing for in the Amazon Fba website.
121 00:11:25.640 ⇒ 00:11:29.020 Caio Velasco: And I actually just found like a table
122 00:11:29.734 ⇒ 00:11:37.390 Caio Velasco: in our database for Amazon, for for the Amazon selling partner source that has a table called listed item that has
123 00:11:37.620 ⇒ 00:11:49.520 Caio Velasco: 99 unique skews. So we kind of had them in the database. But we’re not sure if those are the only ones. So this is also new and and can support his.
124 00:11:49.800 ⇒ 00:12:00.350 Caio Velasco: his, his work. And this is spreadsheet. And yeah, I basically put everything that I had there. So this one. So we are waiting for for him to to pick up on this
125 00:12:01.150 ⇒ 00:12:18.859 Caio Velasco: and the second part is the Dean products I already have, like a version, one that I’m trying to like get from all the fact orders we have and the other int and and raw tables we have. I’m building like a 1st version of what should be in the Dean products
126 00:12:19.476 ⇒ 00:12:25.450 Caio Velasco: basically separating 2 parts from shopify from Amazon like 2 cities.
127 00:12:25.770 ⇒ 00:12:55.420 Caio Velasco: And I think I’m gonna commit there, at least for someone to just review it and see if it’s making sense, and then I can continue to do to do the work for the Amazon partner, for the shopify partner kind of have everything and just organize it there. But for the Amazon there are a few things that we don’t have. For example, there is a product type column in shopify coming from a product stable in shopify. But I didn’t see that table in in Amazon. So there’s a few new things
128 00:12:58.000 ⇒ 00:13:08.229 Robert Tseng: Okay. So what I heard is, you’re so we’re still missing. We’re missing a couple of fields from the Amazon data that we would not be able to, you know. That’s that’s more of a portable question. Right? So
129 00:13:08.230 ⇒ 00:13:08.560 Caio Velasco: Yep.
130 00:13:08.900 ⇒ 00:13:18.809 Robert Tseng: If yeah. So I think you want to kick that conversation off. So if there’s anything that we need to ask portable for then, like, I think that’s definitely part of this
131 00:13:20.020 ⇒ 00:13:20.980 Caio Velasco: Cool, hey!
132 00:13:27.940 ⇒ 00:13:29.050 Robert Tseng: And then.
133 00:13:32.360 ⇒ 00:13:33.749 Robert Tseng: is this other Robert?
134 00:13:42.890 ⇒ 00:13:48.159 Robert Tseng: yeah, I mean, definitely, your response is thorough. I will say that like I feel like
135 00:13:48.410 ⇒ 00:13:58.350 Robert Tseng: the Javi team has a hard time responding to long messages. So I just like default to scheduling a call with them. Yeah, especially
136 00:13:59.220 ⇒ 00:14:02.439 Caio Velasco: No, if it’s not too yeah.
137 00:14:03.320 ⇒ 00:14:14.090 Robert Tseng: Yeah, yeah, no. I think it’s good like this will help you if we hop on a call to reference these things as well, definitely better to have a paper trail. But yeah, just let you know how I’m gonna how I’m helping you to escalate this
138 00:14:15.830 ⇒ 00:14:17.130 Robert Tseng: I also don’t know.
139 00:14:17.710 ⇒ 00:14:35.820 Robert Tseng: Aliyah would really know all these details. Anyway. But that’s that’s on him on to help us figure out like he needs to put us in front of the right people if he connects us to up like the wrong people, and then we get delayed. That’s that’s their fault. So all we can really do is be proactive. And.
140 00:14:36.543 ⇒ 00:14:41.359 Robert Tseng: you know, sharing our findings, letting them know what we need.
141 00:14:41.850 ⇒ 00:14:51.030 Robert Tseng: And then I just will take helping you push them on to direct us to the right person. And yeah, I think that’s that’s all we can do after this, for now
142 00:14:51.560 ⇒ 00:14:53.210 Caio Velasco: Okay. Perfect. Sounds. Good.
143 00:14:54.250 ⇒ 00:14:58.229 Robert Tseng: Yeah, I mean, this is big. I call this 5 points.
144 00:14:59.010 ⇒ 00:15:05.950 Robert Tseng: So, okay, so I think this is also kind of a pending client feedback right now.
145 00:15:06.563 ⇒ 00:15:11.720 Robert Tseng: From online form format of cog sheet. Kind of similar situation. Right? You’ve already shared
146 00:15:11.720 ⇒ 00:15:14.810 Caio Velasco: Yeah, yeah, exactly. That’s the the other part.
147 00:15:16.710 ⇒ 00:15:22.263 Robert Tseng: Okay? And then the yeah, the products model. You already have a 1st draft kind of thing.
148 00:15:22.610 ⇒ 00:15:23.270 Caio Velasco: Yeah.
149 00:15:31.530 ⇒ 00:15:37.839 Robert Tseng: Yeah, when I mean, do you? Is that something you want to share for review? Or do you feel like it’s just like a complete for now
150 00:15:39.434 ⇒ 00:15:49.810 Caio Velasco: I had put it in review when I when I do the Pr. And then I have also a question for a wish. If I commit this 1st version of them products?
151 00:15:50.394 ⇒ 00:15:53.340 Caio Velasco: I know it goes into
152 00:15:55.056 ⇒ 00:16:07.640 Caio Velasco: that first.st but should we push it to pro, or because my idea is just like someone to review it. And then, if I have to change something, I change before merging. I’m not sure like, how does it work
153 00:16:07.640 ⇒ 00:16:10.583 Awaish Kumar: You. You can run in the staging. And
154 00:16:11.130 ⇒ 00:16:16.719 Awaish Kumar: like from your local computer, you can set the target as
155 00:16:16.860 ⇒ 00:16:21.755 Awaish Kumar: Cicd. Then it would load to the staging match, and
156 00:16:22.500 ⇒ 00:16:30.460 Awaish Kumar: the people, you might want it to be reviewed like Robert or someone. They have access to staging tables
157 00:16:31.290 ⇒ 00:16:32.090 Caio Velasco: Okay.
158 00:16:32.680 ⇒ 00:16:40.670 Robert Tseng: Yeah, that usually helps kyle, if you just like kind of added staging, and then like that allows me to go and like, run some initial queries and help with review.
159 00:16:41.223 ⇒ 00:16:41.910 Robert Tseng: So yeah.
160 00:16:42.680 ⇒ 00:16:44.780 Caio Velasco: Okay, cool. Cool, perfect. Thank you.
161 00:16:46.240 ⇒ 00:16:46.625 Robert Tseng: Okay.
162 00:16:54.230 ⇒ 00:17:03.910 Robert Tseng: alright. And then this is the same thing we’re talking about, Annie. So we’re we’re just gonna do this. Pr, I’m gonna move this to pending internal feedback. Great.
163 00:17:04.450 ⇒ 00:17:09.629 Robert Tseng: Alright, things are blocked. Yeah, let’s try to talk through this.
164 00:17:10.500 ⇒ 00:17:15.819 Robert Tseng: Yeah. The subscribe and save thing still blocked. Tiktok shop still blocked north be
165 00:17:16.325 ⇒ 00:17:19.020 Robert Tseng: and how are we on this? So
166 00:17:19.270 ⇒ 00:17:25.129 Robert Tseng: this is really, we were waiting for Aman taxpayment. Okay, right?
167 00:17:28.060 ⇒ 00:17:37.579 Robert Tseng: yeah. I think really the the real blocker here is like, what like do we have a good handle of north beam data in on Javi, like, I think
168 00:17:37.960 ⇒ 00:17:45.050 Robert Tseng: we met with Aman a couple of days ago. And basically he was just pointing out, like, you know.
169 00:17:45.620 ⇒ 00:17:58.820 Robert Tseng: we don’t really need any. He doesn’t hit from his perspective. We don’t need any like fancy modeling. You pull this straight out of North Beam, and they already have like tax and spend numbers. I mean, that’s not true like we do still need to do a little bit of modeling, but
170 00:17:58.930 ⇒ 00:18:06.615 Robert Tseng: all the all the spend should already like we think it should be in the warehouse if we have the northeast connector already.
171 00:18:07.170 ⇒ 00:18:10.379 Robert Tseng: so I guess the question here is like.
172 00:18:11.040 ⇒ 00:18:19.649 Robert Tseng: I mean, yeah, like a wish, or Kyle like, who who which of you is owning? Kind of like north beam north, being data in
173 00:18:20.180 ⇒ 00:18:22.060 Robert Tseng: like kind of in instantly
174 00:18:23.380 ⇒ 00:18:29.870 Awaish Kumar: Yeah, like, I don’t think for Javi. We ingested north beam data.
175 00:18:30.260 ⇒ 00:18:31.600 Awaish Kumar: And if you
176 00:18:31.600 ⇒ 00:18:32.619 Robert Tseng: You don’t think we have
177 00:18:32.970 ⇒ 00:18:35.170 Awaish Kumar: No, no, like.
178 00:18:35.170 ⇒ 00:18:35.710 Awaish Kumar: Okay.
179 00:18:35.710 ⇒ 00:18:42.443 Awaish Kumar: You have to. Will like ingest it first, st you know.
180 00:18:43.199 ⇒ 00:18:48.789 Robert Tseng: Okay? Well, then, that’s definitely something we need to make the higher priority. So
181 00:18:49.299 ⇒ 00:18:54.870 Robert Tseng: away, since you already did that with Eden, do you feel good about kind of figuring that out
182 00:18:55.460 ⇒ 00:19:10.190 Awaish Kumar: Yeah, I like for the modeling part. I work for ingestion. We are using data which is coming from a python script written by someone in the Eden team. So far
183 00:19:10.500 ⇒ 00:19:15.709 Awaish Kumar: for north Beam. We are not. We don’t have any connector which ingest data for Eden as well.
184 00:19:15.970 ⇒ 00:19:31.100 Awaish Kumar: We are using their their python script to ingest it. I I think we made a couple of requests to some vendors as well, so I will follow up and find out like if if anyone can help us with ingestion
185 00:19:32.910 ⇒ 00:19:33.330 Robert Tseng: Okay.
186 00:19:35.715 ⇒ 00:19:36.560 Awaish Kumar: Yeah.
187 00:19:36.560 ⇒ 00:19:41.786 Robert Tseng: I would say, that’s pretty high priority.
188 00:19:46.000 ⇒ 00:19:47.949 Robert Tseng: or this will be
189 00:19:52.220 ⇒ 00:19:54.611 Robert Tseng: okay. I’ll figure out where to categories that
190 00:19:55.820 ⇒ 00:19:58.329 Robert Tseng: I think we probably need a new project for that.
191 00:19:58.754 ⇒ 00:20:03.465 Robert Tseng: Okay, so any, you’re still blocked, there’s nothing to replicate until you have data. So
192 00:20:14.350 ⇒ 00:20:23.670 Robert Tseng: and then, okay, we’re still blocked this Amazon dashboard still blocked. We don’t have subscribe and save.
193 00:20:24.310 ⇒ 00:20:33.640 Robert Tseng: hey? Okay? And then, okay, this is the model that wish needs to build. Right? So
194 00:20:34.175 ⇒ 00:20:40.420 Robert Tseng: I’m not sure if we’ve created a ticket through model build. I know that
195 00:20:40.420 ⇒ 00:20:42.050 Awaish Kumar: I don’t think you’re covered.
196 00:20:42.930 ⇒ 00:20:45.419 Awaish Kumar: I don’t think we have a ticket, but I
197 00:20:45.590 ⇒ 00:20:52.630 Awaish Kumar: we are I, and any we discussed about the model. I have the required context.
198 00:20:52.780 ⇒ 00:20:55.710 Awaish Kumar: and I can work on it. But we just need a ticket there.
199 00:20:55.830 ⇒ 00:20:56.890 Awaish Kumar: It is getting better
200 00:20:56.890 ⇒ 00:20:59.550 Robert Tseng: Okay, what? What do you want me to call it? Like, what? Yeah.
201 00:21:01.335 ⇒ 00:21:02.400 Awaish Kumar: Yeah.
202 00:21:02.400 ⇒ 00:21:04.716 Robert Tseng: Like what? What like? How do we name this model?
203 00:21:06.280 ⇒ 00:21:10.119 Awaish Kumar: Oh, what should we name it?
204 00:21:10.578 ⇒ 00:21:14.249 Annie Yu: Monthly cohort summary. Would that be too generic
205 00:21:15.130 ⇒ 00:21:16.979 Awaish Kumar: Yeah, that’s okay.
206 00:21:16.980 ⇒ 00:21:17.999 Robert Tseng: Yeah, I think that works.
207 00:21:29.000 ⇒ 00:21:29.540 Robert Tseng: hey.
208 00:21:37.387 ⇒ 00:21:39.700 Awaish Kumar: Okay.
209 00:21:39.700 ⇒ 00:21:41.658 Robert Tseng: So we’re still blocked here.
210 00:21:56.170 ⇒ 00:22:01.480 Robert Tseng: okay, then, last here. Okay, the mer process of pl report.
211 00:22:03.820 ⇒ 00:22:04.290 Awaish Kumar: Hello!
212 00:22:04.290 ⇒ 00:22:10.550 Annie Yu: That this one. I think I’m just trying to figure out what data we don’t have. And if
213 00:22:12.360 ⇒ 00:22:12.830 Awaish Kumar: There’s
214 00:22:12.870 ⇒ 00:22:13.610 Robert Tseng: Wow!
215 00:22:14.940 ⇒ 00:22:16.809 Awaish Kumar: What’s up, man?
216 00:22:16.810 ⇒ 00:22:23.480 Robert Tseng: What data we don’t have in here. So spend we don’t have. That would be from north theme sales and orders. We should have
217 00:22:33.200 ⇒ 00:22:36.409 Robert Tseng: Yeah. So I think the idea is just to get
218 00:22:37.875 ⇒ 00:22:38.770 Awaish Kumar: Okay.
219 00:22:38.770 ⇒ 00:22:41.750 Robert Tseng: A specific port like this
220 00:22:48.395 ⇒ 00:22:49.010 Awaish Kumar: Yeah.
221 00:22:49.010 ⇒ 00:22:50.190 Robert Tseng: I’m thinking
222 00:22:51.264 ⇒ 00:22:51.859 Awaish Kumar: Okay.
223 00:22:54.420 ⇒ 00:23:03.270 Robert Tseng: Yeah, I mean, we have. We have a, we have this on the gross margin dashboard in shopify. We have it by customer type, product type. And so this is basically just a different
224 00:23:03.420 ⇒ 00:23:06.272 Robert Tseng: version version that we could just call
225 00:23:08.420 ⇒ 00:23:16.609 Robert Tseng: well, it’s not truly mer- mer is marketing efficiency ratio. It’s basically just ad spend over like sales. But like.
226 00:23:16.970 ⇒ 00:23:37.380 Robert Tseng: until we have ad spend, it’s not truly a mer dashboard. So I think we just focus on creating this pivot table, which we do have everything there. Maybe what? Like, once the north data comes in, we’ll have to like update it in a second tab or something and include like the ad spend data. But I think that’s kind of what the ask is here. It’s just to replicate this this tab
227 00:23:37.690 ⇒ 00:23:40.850 Annie Yu: So that pivot table one for now
228 00:23:40.850 ⇒ 00:23:41.460 Robert Tseng: Yeah.
229 00:23:41.930 ⇒ 00:23:43.920 Annie Yu: Okay, thanks.
230 00:23:44.690 ⇒ 00:23:49.890 Annie Yu: Well, then, okay, I can work on that as of now.
231 00:24:06.350 ⇒ 00:24:06.940 Robert Tseng: Great
232 00:24:07.410 ⇒ 00:24:07.790 Annie Yu: Thanks.
233 00:24:08.194 ⇒ 00:24:11.470 Robert Tseng: So you’re unblocked there, cool!
234 00:24:14.750 ⇒ 00:24:16.600 Robert Tseng: I think what you can do.
235 00:24:17.600 ⇒ 00:24:23.750 Robert Tseng: Let’s just add it as a separate tab for the gross margin dash. Eventually I will rename the gross margin dash.
236 00:24:23.880 ⇒ 00:24:27.950 Robert Tseng: just cause. Obviously, we’re doing more than just gross margin after a while.
237 00:24:28.577 ⇒ 00:24:31.689 Robert Tseng: But it’s okay. You can just include it as a separate tab there, for now
238 00:24:31.930 ⇒ 00:24:35.480 Annie Yu: So would this be called more
239 00:24:35.800 ⇒ 00:24:39.819 Annie Yu: in line of P. And L, or
240 00:24:41.076 ⇒ 00:24:50.450 Robert Tseng: I think it’s just like shopify sales by okay, product. But
241 00:24:50.450 ⇒ 00:24:51.740 Annie Yu: Okay. Yeah.
242 00:24:51.740 ⇒ 00:24:52.450 Robert Tseng: Yeah.
243 00:24:52.700 ⇒ 00:24:57.690 Robert Tseng: But in in my mind it’s like, there’s like a shop. It’s like becomes like a shopify key and l dash.
244 00:24:58.030 ⇒ 00:25:03.220 Robert Tseng: One tab is on is gross margin. One tab is, I guess, sales.
245 00:25:03.380 ⇒ 00:25:10.240 Robert Tseng: and then and then another tab would be like mer, or once we once we’re able to calculate that
246 00:25:11.903 ⇒ 00:25:12.499 Annie Yu: Gotcha
247 00:25:13.370 ⇒ 00:25:14.000 Robert Tseng: Yeah.
248 00:25:14.610 ⇒ 00:25:15.460 Robert Tseng: Okay.
249 00:25:17.543 ⇒ 00:25:19.740 Robert Tseng: I think that covers everything that’s blocked.
250 00:25:20.540 ⇒ 00:25:25.100 Robert Tseng: Before we do it. Talk about anything to do in cycle. Is there anything else that I’ve missed, that
251 00:25:25.240 ⇒ 00:25:26.169 Robert Tseng: I call out
252 00:25:32.554 ⇒ 00:25:37.310 Awaish Kumar: I I think 1, 3, 6 is done.
253 00:25:38.060 ⇒ 00:25:42.020 Awaish Kumar: I gave the access. I don’t know if there was any escalation after that
254 00:25:43.200 ⇒ 00:25:46.120 Robert Tseng: I don’t think so. Yeah, that’s fine. We can consider that done.
255 00:25:47.310 ⇒ 00:25:49.253 Robert Tseng: or you know what I’m just gonna call it.
256 00:25:50.580 ⇒ 00:25:55.018 Robert Tseng: I’ll check with the models. Were there okay? No dashboard investigation also done.
257 00:25:57.743 ⇒ 00:26:02.290 Awaish Kumar: Yeah, basically
258 00:26:02.290 ⇒ 00:26:09.630 Robert Tseng: We added, made some changes to filtering, and also like
259 00:26:11.310 ⇒ 00:26:13.349 Awaish Kumar: Yeah. That was.
260 00:26:22.110 ⇒ 00:26:22.585 Awaish Kumar: oh.
261 00:26:27.640 ⇒ 00:26:37.980 Robert Tseng: alright. So other things in cycle that maybe we want to bring in. So ingesting north beam data into snowflake. Yeah, that one I will follow up you with with you. On which just because
262 00:26:38.230 ⇒ 00:26:46.110 Robert Tseng: of the dashboards that we’re waiting on like the replicating and the north beam dashboard is the one that they care about the most.
263 00:26:46.390 ⇒ 00:26:50.800 Robert Tseng: So Amazon skew cogs for financial reporting.
264 00:26:51.780 ⇒ 00:26:52.600 Awaish Kumar: How are you?
265 00:26:52.600 ⇒ 00:26:57.639 Robert Tseng: Yeah, I mean, this is still gonna be blocked until Kyle gets the the sheet figured out
266 00:26:58.860 ⇒ 00:27:02.350 Robert Tseng: 1st subscription order fully loaded. Gross margin.
267 00:27:08.180 ⇒ 00:27:13.390 Robert Tseng: yeah, you know what I cannot take that on. I may just add this, I don’t think it
268 00:27:20.740 ⇒ 00:27:25.390 Robert Tseng: pretty sure we have something really close to that already. So that should be pretty easy.
269 00:27:29.010 ⇒ 00:27:32.387 Robert Tseng: I’m gonna set a due date myself. There.
270 00:27:37.630 ⇒ 00:27:44.959 Robert Tseng: Yeah, Tiktok shop. Api like is this, this is also flocked because of the portable thing. So
271 00:27:45.300 ⇒ 00:27:49.130 Robert Tseng: I don’t even think I’m gonna leave these in cycle like this is not gonna happen.
272 00:27:50.285 ⇒ 00:27:55.749 Robert Tseng: Okay, feature flag to exclude canceled orders from shopify.
273 00:27:56.670 ⇒ 00:27:58.460 Robert Tseng: Did we not do this already?
274 00:28:05.032 ⇒ 00:28:06.480 Awaish Kumar: I don’t know.
275 00:28:09.630 ⇒ 00:28:12.330 Awaish Kumar: Okay, this was a new request, right?
276 00:28:12.450 ⇒ 00:28:16.694 Robert Tseng: Oh, okay, you know what I think this is done. This is when I was building building out
277 00:28:19.060 ⇒ 00:28:25.790 Robert Tseng: the shopify gross margin dash actually could use fulfillment status. And I didn’t need a new feature flag
278 00:28:26.690 ⇒ 00:28:31.369 Robert Tseng: so good on that data into light dash trial. I think this is something that
279 00:28:32.020 ⇒ 00:28:35.002 Robert Tseng: who Tom is working on. So
280 00:28:36.620 ⇒ 00:28:38.620 Robert Tseng: you guys don’t have to worry about that.
281 00:28:43.940 ⇒ 00:28:44.505 Awaish Kumar: Yeah.
282 00:28:46.100 ⇒ 00:28:51.405 Annie Yu: And so does that mean I should make sure I have access to like that for it later
283 00:28:51.920 ⇒ 00:28:58.530 Robert Tseng: Yeah. So I guess the context here, I mean, basically, they don’t like the Meta base ui understandable. But like
284 00:28:58.900 ⇒ 00:29:01.283 Robert Tseng: whatever, if they want to pay for light. Dash! Go ahead!
285 00:29:03.110 ⇒ 00:29:13.950 Robert Tseng: I don’t know if we’re fully committing to the migration yet, so I think Tom is just spinning up like something we we do. Everyone should have access. We have shared one password here.
286 00:29:14.080 ⇒ 00:29:15.600 Robert Tseng: But yeah, I think.
287 00:29:15.750 ⇒ 00:29:24.389 Robert Tseng: And yeah, this will probably be most relevant to you that I know we’re still building some stuff in Meta Base right now, but eventually we may cut over to light, dash
288 00:29:24.390 ⇒ 00:29:32.320 Awaish Kumar: But in the ticket there is like credentials. If you want to go in and see way
289 00:29:32.320 ⇒ 00:29:33.130 Robert Tseng: Yeah.
290 00:29:35.120 ⇒ 00:29:35.900 Awaish Kumar: Okay.
291 00:29:46.870 ⇒ 00:29:48.250 Robert Tseng: I suppose?
292 00:29:55.190 ⇒ 00:29:59.069 Robert Tseng: you know I don’t want to sign this, Tom. Maybe Annie, like, do like.
293 00:29:59.790 ⇒ 00:30:02.769 Robert Tseng: do you want to look at kind of
294 00:30:03.040 ⇒ 00:30:05.730 Robert Tseng: loading the data in for the staff. First, st
295 00:30:08.700 ⇒ 00:30:11.089 Annie Yu: What do you mean?
296 00:30:11.830 ⇒ 00:30:16.010 Annie Yu: You mean building the recreating, the dashboards, or
297 00:30:18.010 ⇒ 00:30:24.539 Robert Tseng: Okay, you know I don’t. Yeah, I don’t. I don’t think we should do any of the handoff in this call, I think. Yeah, I think.
298 00:30:27.170 ⇒ 00:30:40.979 Robert Tseng: No, I don’t want us to do any like recreation of dashboard right now, like, I feel like, Yeah, never mind. For forget what I said, I think we probably just load the data for that. I mean, it’s really just like a couple of models, fact orders. And maybe fact order lines. And then.
299 00:30:41.100 ⇒ 00:30:41.960 Robert Tseng: if.
300 00:30:42.570 ⇒ 00:30:51.529 Robert Tseng: like, the demo goes well, or whatever, and Aman wants us to do some more development work in it, then we’ll actually create a ticket to rebuild the dash. There
301 00:30:52.130 ⇒ 00:30:52.830 Annie Yu: Okay.
302 00:30:53.170 ⇒ 00:30:54.070 Annie Yu: Yeah.
303 00:30:54.070 ⇒ 00:30:56.370 Robert Tseng: Okay. So forget what I said that
304 00:30:56.720 ⇒ 00:31:06.242 Robert Tseng: Meta based walkthrough, yeah, you have this going on today. Right? Do you feel ready for that I may or may not, or I’ll probably join the call late.
305 00:31:06.550 ⇒ 00:31:09.778 Annie Yu: Wait. Akash said you would be there.
306 00:31:10.240 ⇒ 00:31:10.690 Annie Yu: Really.
307 00:31:11.110 ⇒ 00:31:24.559 Annie Yu: I feel like I because Akash yesterday said we could, we probably would focus more on Amazon and gross margin. So I did spend some time on there. But I’m just not.
308 00:31:25.350 ⇒ 00:31:31.769 Annie Yu: I like would love for you to be there to chime in
309 00:31:31.900 ⇒ 00:31:34.859 Robert Tseng: Yeah, no, I’ll I’ll move things around. I’ll make sure I’ll I’ll be there
310 00:31:35.480 ⇒ 00:31:36.310 Annie Yu: Yeah.
311 00:31:37.810 ⇒ 00:31:43.909 Robert Tseng: Okay, good to know. I wasn’t sure if I need to be there. So I had something over it. But it’s fine
312 00:31:44.630 ⇒ 00:31:57.480 Annie Yu: Yeah, I do have one question about that is the Javi coffee, Google sheet. I think that one’s not like fully updated do we want to share that with lot as well
313 00:31:58.590 ⇒ 00:32:01.109 Robert Tseng: Yeah, the data documentation sheets
314 00:32:01.320 ⇒ 00:32:02.110 Annie Yu: Yeah.
315 00:32:04.040 ⇒ 00:32:05.260 Robert Tseng: Or the yeah.
316 00:32:09.170 ⇒ 00:32:16.190 Robert Tseng: which one’s not updated just the product stuff, or, oh, like even the dashboard metrics and definitions and things
317 00:32:19.410 ⇒ 00:32:28.553 Annie Yu: I I’ve I’ve updated some of the the sales metrics that I asked about, but for the others I’m not sure if they are fully up to date.
318 00:32:28.880 ⇒ 00:32:29.640 Robert Tseng: Okay.
319 00:32:29.640 ⇒ 00:32:30.130 Annie Yu: It’s 40,
320 00:32:30.130 ⇒ 00:32:32.019 Robert Tseng: That’s fine. We can share it as is
321 00:32:32.530 ⇒ 00:32:33.810 Annie Yu: Okay. Cool.
322 00:32:33.810 ⇒ 00:32:38.339 Robert Tseng: Yeah, it’s a good point. I’ll add it to the tickets. You should just share this
323 00:32:38.660 ⇒ 00:32:46.120 Annie Yu: And while we’re on this one more question is, I think in Amazon dashboard you call the sales
324 00:32:46.730 ⇒ 00:32:52.909 Annie Yu: you call the sales revenue net sales. So is that how we call it in in Amazon dash? Or should we
325 00:32:53.240 ⇒ 00:32:54.080 Robert Tseng: Man
326 00:32:55.250 ⇒ 00:33:00.990 Annie Yu: But if you want I can, I can make some change to just to the name, if if that’s easier
327 00:33:03.130 ⇒ 00:33:03.925 Robert Tseng: Yeah.
328 00:33:06.880 ⇒ 00:33:17.450 Robert Tseng: off the top of my head. To be honest, I I think there’s a slight difference with the Amazon calculation. We can leave it as net sales, for now I think I’ll probably spend most of the time just talking, walking through the shopify
329 00:33:18.570 ⇒ 00:33:19.900 Robert Tseng: gross margin, dash
330 00:33:20.492 ⇒ 00:33:26.550 Robert Tseng: like, when we actually do one of the excursion. But otherwise it’s gonna just be a very high level, like
331 00:33:26.760 ⇒ 00:33:35.239 Robert Tseng: architecture diagram, like walking through the different parts and like, I don’t really want to do too much like data investigation with them.
332 00:33:35.640 ⇒ 00:33:36.780 Annie Yu: Yep. Okay.
333 00:33:37.270 ⇒ 00:33:37.860 Robert Tseng: Yeah.
334 00:33:38.920 ⇒ 00:33:39.500 Annie Yu: Makes sense.
335 00:33:39.500 ⇒ 00:33:47.869 Robert Tseng: Okay, cool. I think we’re a bit over. So that’s that’s it. For now, I think we have enough to kind of keep us going.
336 00:33:49.420 ⇒ 00:33:54.719 Robert Tseng: Yeah, let me know if you have any questions, but otherwise I’ll see. Probably some of you on calls later today.
337 00:33:55.520 ⇒ 00:33:56.070 Annie Yu: Yeah.
338 00:33:56.456 ⇒ 00:33:57.230 Caio Velasco: Thanks. Team.
339 00:33:57.230 ⇒ 00:33:57.780 Caio Velasco: Thank you, Reverend
340 00:33:57.780 ⇒ 00:33:58.550 Robert Tseng: Thanks. Everyone.