Meeting Title: Insomnia Tracker Final Polish Date: 2025-12-10 Meeting participants: Amber Lin, Sezim Zhenishbekova
WEBVTT
1 00:00:37.350 ⇒ 00:00:39.439 Sezim Zhenishbekova: Hey, Amber, how are you?
2 00:00:40.050 ⇒ 00:00:41.100 Amber Lin: Hi there!
3 00:00:46.400 ⇒ 00:00:47.929 Sezim Zhenishbekova: Thanks, good morning.
4 00:00:47.930 ⇒ 00:00:53.919 Amber Lin: Would you send me the link to the tracker, and then we can go through it together.
5 00:00:54.260 ⇒ 00:00:54.900 Sezim Zhenishbekova: Yes.
6 00:00:55.690 ⇒ 00:01:04.700 Amber Lin: Mostly just aesthetic changes. I think Robert’s okay with how… I know you guys made another version, so… just want to polish it off so the stakeholders.
7 00:01:04.700 ⇒ 00:01:05.570 Sezim Zhenishbekova: Yes.
8 00:01:06.250 ⇒ 00:01:15.950 Sezim Zhenishbekova: The thing is that I was backfilling the data, and every time I backfill it, my code, my formulas are crashing, so I’m trying to debug it, what’s happening.
9 00:01:16.550 ⇒ 00:01:20.810 Sezim Zhenishbekova: But so far, it’s, yeah, I’m backfilling for December right now.
10 00:01:21.940 ⇒ 00:01:22.990 Sezim Zhenishbekova: Awesome.
11 00:01:24.060 ⇒ 00:01:25.110 Sezim Zhenishbekova: She doesn’t.
12 00:01:26.360 ⇒ 00:01:27.170 Sezim Zhenishbekova: Sorry.
13 00:02:01.880 ⇒ 00:02:03.569 Amber Lin: Oh, I am in now.
14 00:02:03.980 ⇒ 00:02:06.779 Amber Lin: What’s the name of the tab I should go to?
15 00:02:19.700 ⇒ 00:02:21.370 Amber Lin: Oh, you’re on mute.
16 00:02:22.880 ⇒ 00:02:26.090 Sezim Zhenishbekova: Oh, oops, it’s on the daily summary sheet.
17 00:02:26.890 ⇒ 00:02:30.819 Sezim Zhenishbekova: And yesterday I had a call with Robert where he…
18 00:02:31.170 ⇒ 00:02:38.699 Sezim Zhenishbekova: set how I should, like, design it and make it similar to Insomnia. So, after I backfill all the data, I’m gonna do that.
19 00:02:42.010 ⇒ 00:02:42.830 Sezim Zhenishbekova: Awesome.
20 00:02:42.940 ⇒ 00:02:43.650 Sezim Zhenishbekova: Okay.
21 00:02:44.890 ⇒ 00:02:46.370 Sezim Zhenishbekova: Do you need any…
22 00:02:51.900 ⇒ 00:02:56.089 Sezim Zhenishbekova: Our new extra calculation, so we just wanted to change the…
23 00:02:56.550 ⇒ 00:03:03.060 Amber Lin: Oh, no, I’m just looking at the formatting and presentation. I’ll leave all the content to you.
24 00:03:03.420 ⇒ 00:03:04.340 Sezim Zhenishbekova: Oh, okay.
25 00:03:04.340 ⇒ 00:03:04.870 Amber Lin: Yeah.
26 00:03:05.840 ⇒ 00:03:06.740 Amber Lin: Mmm…
27 00:04:53.960 ⇒ 00:04:57.539 Sezim Zhenishbekova: If you could share the screen, I can also…
28 00:04:57.710 ⇒ 00:05:01.020 Sezim Zhenishbekova: Explain why we are going through it, if possible.
29 00:05:01.020 ⇒ 00:05:01.590 Amber Lin: Eric.
30 00:05:01.700 ⇒ 00:05:06.170 Amber Lin: I’m mostly looking at how they formatted before.
31 00:05:06.230 ⇒ 00:05:11.240 Sezim Zhenishbekova: Shadings here, if they have… if they use lines or colors.
32 00:05:12.540 ⇒ 00:05:22.630 Amber Lin: And then, let’s see… Then for this one, they don’t really have… We don’t use lines between…
33 00:05:24.170 ⇒ 00:05:29.130 Amber Lin: I think we could… Let’s see, on the daily summary slide…
34 00:05:30.530 ⇒ 00:05:34.649 Amber Lin: So, how would they… how would they usually navigate this?
35 00:05:35.830 ⇒ 00:05:46.220 Sezim Zhenishbekova: So, basically, they will go to the date that’s today. For example, I’m filling out the December date right now. It can go back to November 30th, for instance.
36 00:05:46.540 ⇒ 00:05:52.660 Sezim Zhenishbekova: And then, start with… this is the kidney data that we have.
37 00:05:52.880 ⇒ 00:05:56.620 Amber Lin: That explains the scorecard, the differences…
38 00:05:56.670 ⇒ 00:06:05.700 Sezim Zhenishbekova: Negatives, and then starting from paid media is work done between each ad platform, where we get the numbers.
39 00:06:06.250 ⇒ 00:06:07.710 Amber Lin: Mmm, I see.
40 00:06:07.710 ⇒ 00:06:19.379 Sezim Zhenishbekova: And then, like, instead of… if you don’t want to go through, like, Google or Meta, you can just go directly to the totals of the paid media that has summed up Google and Meta in one.
41 00:06:20.330 ⇒ 00:06:27.679 Sezim Zhenishbekova: Same goes to a promotional pack as well. There are, like, 5 promos, and total just sums everything up.
42 00:06:28.050 ⇒ 00:06:29.809 Sezim Zhenishbekova: Gives me a great result.
43 00:06:33.050 ⇒ 00:06:33.760 Sezim Zhenishbekova: Yeah.
44 00:06:34.330 ⇒ 00:06:35.630 Amber Lin: Gotcha.
45 00:06:35.630 ⇒ 00:06:38.200 Sezim Zhenishbekova: Everything that was in the bottom, I lifted up.
46 00:06:38.570 ⇒ 00:06:39.680 Sezim Zhenishbekova: Should claim.
47 00:06:39.960 ⇒ 00:06:42.329 Amber Lin: From the old version, I meant.
48 00:06:43.210 ⇒ 00:06:50.920 Amber Lin: Okay. When you say left it out, do you mean…
49 00:06:51.370 ⇒ 00:06:57.239 Sezim Zhenishbekova: For example, down… they are, like, social… that one is in the upside, yes.
50 00:06:57.600 ⇒ 00:06:58.320 Amber Lin: Okay.
51 00:06:59.140 ⇒ 00:07:05.760 Sezim Zhenishbekova: That one is… we have it, it’s empty. We have, like, scorecard totals on the upper side of the sheet.
52 00:07:05.760 ⇒ 00:07:07.130 Amber Lin: Okay.
53 00:07:07.750 ⇒ 00:07:09.500 Amber Lin: What did you say we left out?
54 00:07:10.510 ⇒ 00:07:16.220 Sezim Zhenishbekova: So, Florian, as of now, social followers gained, we don’t have anything there.
55 00:07:16.590 ⇒ 00:07:17.800 Amber Lin: Gotcha, okay.
56 00:07:18.600 ⇒ 00:07:21.110 Amber Lin: Mmm… Hmm.
57 00:07:22.980 ⇒ 00:07:27.540 Amber Lin: Is there a way that these things could be either… either…
58 00:07:27.540 ⇒ 00:07:45.810 Sezim Zhenishbekova: Yes, so basically, right now, the formula was tracking, like, that I wrote on a daily basis, but then I started going into the files, and it turns out the revenue comparison goes to the monthly comparison.
59 00:07:46.840 ⇒ 00:07:58.899 Sezim Zhenishbekova: That changes the whole logic, so I created an additional row and put it up in there so that it can incorporate. But now I need to fill in another field on the scorecard section.
60 00:07:59.650 ⇒ 00:08:02.240 Sezim Zhenishbekova: So, yeah, but percentages will be available.
61 00:08:05.520 ⇒ 00:08:06.410 Amber Lin: Huh? Sorry.
62 00:08:07.650 ⇒ 00:08:17.580 Sezim Zhenishbekova: What was the last sentence you said? But yeah, the percentages of revenue will be available, I’m just filling in, and then I realized after 25th.
63 00:08:17.830 ⇒ 00:08:23.279 Sezim Zhenishbekova: In November, we don’t really have a lot of data, there’s a lot of missing pieces on the scorecard.
64 00:08:23.700 ⇒ 00:08:24.450 Sezim Zhenishbekova: self.
65 00:08:24.940 ⇒ 00:08:27.670 Sezim Zhenishbekova: So that’s why there might be this…
66 00:08:27.840 ⇒ 00:08:33.970 Sezim Zhenishbekova: errors, and because of this visual representation, it seems empty, like, it’s actually, like…
67 00:08:34.100 ⇒ 00:08:36.200 Sezim Zhenishbekova: Has incorporated a lot of stuff.
68 00:08:36.510 ⇒ 00:08:37.090 Amber Lin: Okay.
69 00:08:37.360 ⇒ 00:08:38.390 Sezim Zhenishbekova: I can see.
70 00:08:39.010 ⇒ 00:08:43.849 Amber Lin: How can we expand the first column? It is not moving for me.
71 00:08:47.800 ⇒ 00:08:48.830 Amber Lin: Oh, there we go.
72 00:09:23.810 ⇒ 00:09:30.240 Amber Lin: I will do some… Feel free to keep going, I’ll just do some formatting changes, and I’ll ask you…
73 00:09:30.780 ⇒ 00:09:31.700 Amber Lin: It comes up.
74 00:09:31.960 ⇒ 00:09:34.020 Sezim Zhenishbekova: Okay, sounds good.
75 00:09:34.360 ⇒ 00:09:53.680 Sezim Zhenishbekova: So, but once… by 2, I think, I will fill in all the data after my meetings, and then I’ll just pin you to a place for free. But yeah, I will… I will go, like, edit, re-edit this time, because I’m doing QAs. I did QA yesterday, and today I’m doing another QA, and there is, again.
76 00:09:53.680 ⇒ 00:09:54.900 Sezim Zhenishbekova: I’ll send you into formula.
77 00:09:54.900 ⇒ 00:09:56.930 Sezim Zhenishbekova: I haven’t seen it, so I
78 00:09:57.250 ⇒ 00:10:00.289 Sezim Zhenishbekova: Because it’s a big dataset, it’s taking me time to…
79 00:10:00.290 ⇒ 00:10:02.020 Amber Lin: I see. See the dependencies.
80 00:10:02.520 ⇒ 00:10:07.739 Amber Lin: Sounds good. I just wanted to be ready before Robert’s called, but any time before that.
81 00:10:07.740 ⇒ 00:10:12.719 Sezim Zhenishbekova: Also, I wanted to show you the other pages I didn’t let you know.
82 00:10:13.450 ⇒ 00:10:17.380 Sezim Zhenishbekova: Could you please share your screen and show me the dynamics?
83 00:10:19.130 ⇒ 00:10:30.419 Sezim Zhenishbekova: So, if you go down, like, daily summary is a regular list that people fill it out. But other than that, we will have our weekly summaries.
84 00:10:31.460 ⇒ 00:10:41.339 Sezim Zhenishbekova: weekly summaries that breaks down by week every promotion’s values. Right now, it’s loading, because I’m changing the values. Then there is weekly mix.
85 00:10:41.880 ⇒ 00:10:43.709 Sezim Zhenishbekova: The weekly mix, that…
86 00:10:44.640 ⇒ 00:10:54.409 Sezim Zhenishbekova: Right there, it shows, like, breakdown between the every revenues over time, and then the executive summary, other than,
87 00:10:56.250 ⇒ 00:11:00.289 Sezim Zhenishbekova: Quarterly summary, and then another one is executive summary.
88 00:11:04.780 ⇒ 00:11:12.229 Sezim Zhenishbekova: This will give the overall vision of what’s happening right now, based on the selected week that you will be choosing.
89 00:11:13.360 ⇒ 00:11:20.420 Sezim Zhenishbekova: Yeah. But, once I finish today, like, re-editing and meeting with Robert, I will record alone, so…
90 00:11:20.690 ⇒ 00:11:21.630 Amber Lin: Gotcha, okay.
91 00:11:21.630 ⇒ 00:11:23.280 Sezim Zhenishbekova: and simplify.
92 00:11:23.280 ⇒ 00:11:26.399 Amber Lin: Sounds good. I’ll just touch the formatting parts.
93 00:11:26.450 ⇒ 00:11:28.710 Sezim Zhenishbekova: Perfect.
94 00:11:28.850 ⇒ 00:11:32.640 Amber Lin: Yeah, let me know once you’ve filled in the data so I can take another check.
95 00:11:32.820 ⇒ 00:11:36.290 Sezim Zhenishbekova: Okay, sounds good. Thank you, Amber. See you.
96 00:11:36.290 ⇒ 00:11:37.030 Amber Lin: Right.