Meeting Title: Brainforge Data Setup and Strategy Sync Date: 2025-12-12 Meeting participants: Sezim Zhenishbekova, Henry Zhao
WEBVTT
1 00:00:44.250 ⇒ 00:00:45.320 Henry Zhao: Brooklynns.
2 00:00:46.140 ⇒ 00:00:47.020 Sezim Zhenishbekova: Hi.
3 00:00:47.020 ⇒ 00:00:48.310 Henry Zhao: Hey, Sizum, how are you doing?
4 00:00:48.310 ⇒ 00:00:54.479 Sezim Zhenishbekova: Good, good. Thank you so much for jumping on this, even during your vacation period.
5 00:00:54.480 ⇒ 00:00:55.110 Henry Zhao: Problem.
6 00:00:56.540 ⇒ 00:00:59.649 Sezim Zhenishbekova: So, basically, it’s gonna be brief.
7 00:00:59.860 ⇒ 00:01:08.909 Sezim Zhenishbekova: I had a call with Demilada and Vaish, and I read your emails. So they helped me to set up my Tableau on a desktop.
8 00:01:09.260 ⇒ 00:01:10.010 Henry Zhao: Okay, cool.
9 00:01:10.010 ⇒ 00:01:15.859 Sezim Zhenishbekova: And then, right now, I’m still working the VAP, because I’m having issues with the passcode.
10 00:01:16.180 ⇒ 00:01:16.910 Henry Zhao: Oh, okay.
11 00:01:17.290 ⇒ 00:01:21.099 Sezim Zhenishbekova: So, because they need the product key, and I don’t have that product key.
12 00:01:21.800 ⇒ 00:01:23.090 Sezim Zhenishbekova: But in addition…
13 00:01:23.090 ⇒ 00:01:26.800 Henry Zhao: I think for now, you probably don’t need Tableau. I think you can just work with the data in Excel.
14 00:01:27.040 ⇒ 00:01:28.880 Sezim Zhenishbekova: Yeah. Oh, yeah.
15 00:01:29.170 ⇒ 00:01:30.770 Henry Zhao: And then Monday, we can discuss Tableau.
16 00:01:31.630 ⇒ 00:01:33.780 Sezim Zhenishbekova: I really do think that’s the best option, yeah.
17 00:01:33.780 ⇒ 00:01:34.320 Henry Zhao: Yeah.
18 00:01:34.700 ⇒ 00:01:38.709 Sezim Zhenishbekova: So I just go to BigQuery, download everything I need, and put it in the…
19 00:01:38.710 ⇒ 00:01:40.650 Henry Zhao: I think the engineers can help you get the data.
20 00:01:40.650 ⇒ 00:01:44.489 Sezim Zhenishbekova: Yeah, yeah. So once they help me with the data, I just put all that, put it in the.
21 00:01:44.490 ⇒ 00:01:49.840 Henry Zhao: I think Demolati is pretty good at getting that data. Like, I know you tagged me in a message, but I think Demolati can help you with that.
22 00:01:49.840 ⇒ 00:01:51.210 Sezim Zhenishbekova: Oh, okay.
23 00:01:51.210 ⇒ 00:01:52.570 Henry Zhao: Any kinds of questions you can ask me.
24 00:01:52.990 ⇒ 00:02:00.189 Sezim Zhenishbekova: Okay, amazing then, and thank you for breaking down the tasks. I think, for me, it was very overwhelming just to have done.
25 00:02:00.190 ⇒ 00:02:00.509 Henry Zhao: Oh, yeah.
26 00:02:00.510 ⇒ 00:02:06.739 Sezim Zhenishbekova: idea, and I was, like, I didn’t know where to start, but the way that you subtasked it actually…
27 00:02:06.740 ⇒ 00:02:11.729 Henry Zhao: This is what I was kind of alluding to, right? Like, it’s very overwhelming, I think. Just between you and me, I think…
28 00:02:11.730 ⇒ 00:02:12.230 Sezim Zhenishbekova: Yeah.
29 00:02:12.230 ⇒ 00:02:16.139 Henry Zhao: sometimes Robert and Utam, like, have very high expectations, which is fine.
30 00:02:16.420 ⇒ 00:02:17.340 Sezim Zhenishbekova: Yeah.
31 00:02:17.340 ⇒ 00:02:20.290 Henry Zhao: They don’t realize how overwhelming it is.
32 00:02:20.670 ⇒ 00:02:38.649 Sezim Zhenishbekova: Yeah, because, like, even for the scorecard, I think it was supposed to be only, like, for them, it’s only 3-4 hours work, but it took me much longer than expected, because of the data and all the sheets, and I added additional charts, because I wanted to make it better, so it took me more time. So, yeah.
33 00:02:38.650 ⇒ 00:02:43.129 Henry Zhao: We’re talking about this on Monday. I’m gonna see him in person on Monday, I’m going to Austin, like, in a few hours.
34 00:02:43.130 ⇒ 00:02:43.470 Sezim Zhenishbekova: Yeah.
35 00:02:43.470 ⇒ 00:02:55.829 Henry Zhao: And just kind of tell them about that, but yeah, just basically, just try to show as much impact as you can in the first two weeks, and I’ll help you with that, just so that you can, you know, continue on with, Brainforge.
36 00:02:56.070 ⇒ 00:03:13.180 Sezim Zhenishbekova: Okay, so then, with the add-on, you would propose me just to build the Excel sheet with the data that’s provided by the Milada, and then on Monday, after maybe strategy call, we can have a Tableau walkthrough of how to do it manually? Okay, okay.
37 00:03:13.180 ⇒ 00:03:16.690 Henry Zhao: Yeah, it shouldn’t be too difficult. I think the difficult part is understanding the data and being.
38 00:03:16.690 ⇒ 00:03:17.320 Sezim Zhenishbekova: Yes.
39 00:03:17.320 ⇒ 00:03:23.419 Henry Zhao: like, do the formulas. I think that’s the real… Tableau’s not hard. It’s like dragging and dropping things, right?
40 00:03:23.420 ⇒ 00:03:24.210 Sezim Zhenishbekova: Yeah, yeah, yeah.
41 00:03:24.210 ⇒ 00:03:25.399 Henry Zhao: The hard part is, like, yeah.
42 00:03:26.990 ⇒ 00:03:45.810 Sezim Zhenishbekova: for me, it was basically getting to know the BigQuery, and then trying to figure out where, what’s located, and if that information is accurate enough for me or not. So that’s why now I identified it, and I just think I… once they melata, it lets me know how, where it’s located, it should be more of a coding work now.
43 00:03:45.810 ⇒ 00:03:51.960 Henry Zhao: Yeah, another thing that might be tricky for you is, like, understanding new customer revenue versus returning customer revenue.
44 00:03:51.960 ⇒ 00:03:52.410 Sezim Zhenishbekova: Yeah.
45 00:03:52.410 ⇒ 00:04:05.050 Henry Zhao: So I would just take a look at that, see if it, like, matches with the retention curves, because the returning customer revenue should be the retained users, right? So when you add up returning customer revenue, it should add up to whatever you project with the retention curves.
46 00:04:05.210 ⇒ 00:04:08.109 Henry Zhao: It’s not gonna match exactly, but it should be roughly, right?
47 00:04:08.490 ⇒ 00:04:10.960 Sezim Zhenishbekova: Can you repeat that, but slowly? Yeah.
48 00:04:10.960 ⇒ 00:04:21.010 Henry Zhao: So, like, this month, we’re gonna have new users, new customers, right? So people that are buying their first treatment, and starting off. And then the rest is returning customer revenue, so that’s, like.
49 00:04:21.320 ⇒ 00:04:27.930 Henry Zhao: Refills, new treatments for, like, people that were already customers.
50 00:04:28.500 ⇒ 00:04:30.470 Henry Zhao: Right? So…
51 00:04:30.710 ⇒ 00:04:40.660 Sezim Zhenishbekova: Do you categorize them based on, like, the first order, and then after 3 months, and that’s how you… you just sort that based on that, like, retention rate of some sort? Like, return.
52 00:04:40.660 ⇒ 00:04:48.030 Henry Zhao: us, like, the first order for the customer ID, or the email, whatever it may be, is a new customer order, everything else is returning.
53 00:04:48.280 ⇒ 00:04:50.410 Sezim Zhenishbekova: Okay, okay. And then when you add up the retention.
54 00:04:50.410 ⇒ 00:04:54.979 Henry Zhao: It should be the same. It should, right? By theory, it should be the same, but it’s not.
55 00:04:54.980 ⇒ 00:04:55.619 Sezim Zhenishbekova: Yeah, yeah, yeah.
56 00:04:55.620 ⇒ 00:04:58.809 Henry Zhao: I don’t know why. So that’s, I think, the tricky part that you’re gonna have to figure out.
57 00:04:58.810 ⇒ 00:05:09.869 Sezim Zhenishbekova: Okay, okay. So, okay, sounds good then. Once I have all that data, I will just follow Johann’s Excel sheet formulas and code in there, and then put it in the Excel.
58 00:05:09.870 ⇒ 00:05:24.190 Henry Zhao: Yeah. So, like, this month’s returning customer revenue should be, like, 80% from last month, 60% from 2 months ago, like, 10% from 3 months ago. Once you add all that up, it should equal the returning customer revenue, but it won’t. So, we’ll figure out… once you see how close it is, we can figure out if we need.
59 00:05:24.190 ⇒ 00:05:24.700 Sezim Zhenishbekova: Okay.
60 00:05:24.700 ⇒ 00:05:25.680 Henry Zhao: bug or anything like that.
61 00:05:25.680 ⇒ 00:05:28.479 Sezim Zhenishbekova: Okay, sounds good.
62 00:05:28.480 ⇒ 00:05:33.540 Henry Zhao: like, you might see, like, oh, it doesn’t match because there was a big spike from, like, 7 months ago, right? Or…
63 00:05:34.000 ⇒ 00:05:48.860 Henry Zhao: a lot of people from 8 months ago didn’t renew their treatments. And then that, I think, can be things that we put into the forecast, or things that we even address with Eden to say, like, why did 8 months ago people not renew their medications? Is it because the price was bad?
64 00:05:48.860 ⇒ 00:05:56.560 Henry Zhao: Or is it because we didn’t do email marketing, or did the alerts not go out, right? So those are things that we can look at for the clients.
65 00:05:56.700 ⇒ 00:06:04.540 Sezim Zhenishbekova: yeah. Okay, okay, got it. Thank you, Henry, and I will be pinning you, maybe throughout the week, if you’re a weekend.
66 00:06:04.540 ⇒ 00:06:05.100 Henry Zhao: Please, yeah.
67 00:06:05.100 ⇒ 00:06:07.700 Sezim Zhenishbekova: But if not, I’ll talk to you on Monday.
68 00:06:07.700 ⇒ 00:06:09.710 Henry Zhao: Yeah, sounds good. Yeah, I’ll be sure to check my messages.
69 00:06:09.710 ⇒ 00:06:10.940 Sezim Zhenishbekova: Thank you, have a.
70 00:06:10.940 ⇒ 00:06:11.340 Henry Zhao: Bye.
71 00:06:11.340 ⇒ 00:06:12.450 Sezim Zhenishbekova: You too.