Meeting Title: Hedra Client Reporting Strategy Sync Date: 2026-02-11 Meeting participants: Uttam Kumaran, Shri, shriramapte
WEBVTT
1 00:06:45.070 ⇒ 00:06:46.020 Uttam Kumaran: Yo.
2 00:06:46.300 ⇒ 00:06:48.310 Shri: Oh, what’s good, dude?
3 00:06:49.780 ⇒ 00:06:50.890 Uttam Kumaran: The usual.
4 00:06:51.140 ⇒ 00:06:51.870 Uttam Kumaran: Where you at?
5 00:06:53.750 ⇒ 00:06:54.670 Shri: Huh?
6 00:06:54.670 ⇒ 00:06:56.120 Uttam Kumaran: Are you, you’re in LA?
7 00:06:56.440 ⇒ 00:07:00.159 Shri: No, no, no, I’m in, I’m in, my office.
8 00:07:00.950 ⇒ 00:07:07.969 Uttam Kumaran: Oh, nice! Yeah, dude, I feel like I forgot what this… at least it looked like a dungeon in there.
9 00:07:08.230 ⇒ 00:07:11.669 Shri: Usually, usually I, like, have the camera like this, but…
10 00:07:11.670 ⇒ 00:07:12.160 Uttam Kumaran: Oh.
11 00:07:12.160 ⇒ 00:07:13.310 Shri: Not even easy.
12 00:07:14.740 ⇒ 00:07:16.299 Uttam Kumaran: Okay, okay, nice.
13 00:07:16.980 ⇒ 00:07:20.100 Uttam Kumaran: Dude, congrats, finally! You’re out.
14 00:07:21.550 ⇒ 00:07:23.619 Shri: I’m fuckin’ gone, see ya.
15 00:07:23.720 ⇒ 00:07:25.810 Shri: So happy to be done.
16 00:07:26.230 ⇒ 00:07:26.799 Uttam Kumaran: That’s right.
17 00:07:26.800 ⇒ 00:07:32.120 Shri: It was just draining me towards the end, like, I was just like… I don’t wanna fucking…
18 00:07:32.120 ⇒ 00:07:36.810 Uttam Kumaran: Yeah, dude, yeah, yeah, once you’re out, you’re like, it’s really hard to be back in at all.
19 00:07:37.160 ⇒ 00:07:37.840 Shri: Yeah.
20 00:07:39.820 ⇒ 00:07:40.950 Shri: Yeah.
21 00:07:42.480 ⇒ 00:07:48.929 Shri: What’s, so, what’s the latest with you?
22 00:07:49.840 ⇒ 00:07:56.760 Uttam Kumaran: Stuff’s good, dude. Yeah, we’re just hiring and growing, and shit is just… Crazy. So, like…
23 00:07:57.210 ⇒ 00:08:05.099 Uttam Kumaran: the shit I’m dealing… it’s funny, the more we grow, the easier the problems get, the harder it is to just find people to do it. Like, I don’t have time.
24 00:08:05.220 ⇒ 00:08:17.950 Uttam Kumaran: It’s totally easy. For example, in this case, we have a client, they’re this, like, Series B or Series A, they raise, like, a shit ton of money. AI client. They have, like, 5 people, one woman is, like, basically running all of their reporting internally.
25 00:08:19.110 ⇒ 00:08:30.369 Uttam Kumaran: She doesn’t… she comes from… she was… she worked at HeyGen before, but, like, not a big background in, like, financial reporting. Like, she’s more, like, growth reporting. And she just needs, like, a walkthrough on, like, yo, how do I think about, like.
26 00:08:30.950 ⇒ 00:08:37.280 Uttam Kumaran: allocating Stripe invoices to the right bucket, and think about, like, reporting for my CEO on, like.
27 00:08:37.750 ⇒ 00:08:39.140 Uttam Kumaran: our SaaS revenue.
28 00:08:39.409 ⇒ 00:08:40.049 Uttam Kumaran: And…
29 00:08:40.059 ⇒ 00:08:40.469 Shri: Yeah.
30 00:08:40.470 ⇒ 00:08:43.020 Uttam Kumaran: It would totally be something that, like, I would go do.
31 00:08:43.539 ⇒ 00:08:46.180 Uttam Kumaran: But I don’t have the time, so right now, we’ve…
32 00:08:46.280 ⇒ 00:08:52.729 Uttam Kumaran: We sort of built out their data warehouse, we built out their dbt models, we’re bringing stuff into Hex.
33 00:08:52.830 ⇒ 00:08:58.109 Uttam Kumaran: And then… she’s kind of, like, stuck. Like, she needs, like, more…
34 00:08:58.450 ⇒ 00:09:03.089 Uttam Kumaran: Kind of, like, strategy on, like, what do the executive use to build, and things like that, so…
35 00:09:03.780 ⇒ 00:09:04.100 Shri: Yep.
36 00:09:05.460 ⇒ 00:09:08.690 Shri: Where, alright, Hedra?
37 00:09:09.000 ⇒ 00:09:09.700 Uttam Kumaran: Yeah.
38 00:09:12.880 ⇒ 00:09:13.930 Shri: Right, Sydney.
39 00:09:15.310 ⇒ 00:09:18.070 Shri: Their pricing’s pretty straightforward, actually.
40 00:09:21.870 ⇒ 00:09:24.880 Shri: 1400 credits per month, yeah, upsell.
41 00:09:28.230 ⇒ 00:09:31.799 Shri: Perfect, yeah, I mean, this is, like, half…
42 00:09:32.060 ⇒ 00:09:36.810 Shri: A data and process problem, and to have a…
43 00:09:38.460 ⇒ 00:09:44.840 Uttam Kumaran: Yeah, so the one half I can solve, and we are solving. Like, because she just doesn’t even know how to, like, leverage our time effectively.
44 00:09:44.940 ⇒ 00:09:47.120 Shri: Yeah. Because she’s just calling us, like, when…
45 00:09:47.120 ⇒ 00:10:05.160 Uttam Kumaran: the CEO’s like, oh, this doesn’t look right, and she’s like, oh shit, like, let me dive in. Why did you guys, like, allocate it like this? I’m like, you didn’t give us any guidance, just did best practice, right? So, a good example, if she’s like, how does, like, invoicing period work? Like, do we want to… there’s, like, a 30-day period, or a different period, and, like.
46 00:10:05.270 ⇒ 00:10:10.730 Uttam Kumaran: She just has these, like, kind of business questions that the CEO’s too busy to answer or doesn’t know himself.
47 00:10:10.920 ⇒ 00:10:14.470 Uttam Kumaran: She doesn’t really know, she’s just, like, kind of, like, the reporting owner.
48 00:10:14.860 ⇒ 00:10:17.759 Uttam Kumaran: Probably just, like, a couple… her name is Sandra?
49 00:10:18.890 ⇒ 00:10:24.280 Uttam Kumaran: Sandra… Something… her name is Sandra,
50 00:10:24.860 ⇒ 00:10:29.350 Uttam Kumaran: Shit, I don’t even remember her last name, but she’s at… she’s at Hedra, I don’t know if you can look her up.
51 00:10:29.960 ⇒ 00:10:36.680 Shri: soon… Sandra, let me just go to… Sandra Notchforg?
52 00:10:38.080 ⇒ 00:10:40.200 Uttam Kumaran: Probably? She’s, like, European or something.
53 00:10:42.090 ⇒ 00:10:42.840 Shri: Yeah.
54 00:10:43.550 ⇒ 00:10:44.230 Uttam Kumaran: Yeah, yeah, yeah.
55 00:10:44.230 ⇒ 00:10:46.320 Shri: As a growth person trying to do…
56 00:10:46.970 ⇒ 00:10:50.760 Uttam Kumaran: So she runs all of reporting for them?
57 00:10:51.560 ⇒ 00:10:53.509 Shri: And they’re like a…
58 00:10:54.700 ⇒ 00:10:56.809 Uttam Kumaran: I don’t know, they’re like a 10, 15…
59 00:10:57.310 ⇒ 00:10:59.009 Uttam Kumaran: I don’t know, they’re, like, not that big.
60 00:10:59.120 ⇒ 00:11:03.569 Uttam Kumaran: And the CEO is, like, super slammed, like, he’s just sort of micromanaging the product.
61 00:11:03.810 ⇒ 00:11:05.800 Uttam Kumaran: They’re churning out the ass.
62 00:11:06.280 ⇒ 00:11:12.679 Uttam Kumaran: Like, they’re, like, fucking… they’re, like, really losing. We… so we were trying to get them to work with us, because they don’t have any product analytics.
63 00:11:13.240 ⇒ 00:11:16.730 Uttam Kumaran: They… they don’t have a clear view of, like, how to prevent churn.
64 00:11:16.850 ⇒ 00:11:19.990 Uttam Kumaran: And… but even most importantly, they don’t have, like, a clear view of, like.
65 00:11:20.490 ⇒ 00:11:31.400 Uttam Kumaran: revenue, user buckets, but again, like, we… I just, like, I could go… it’s actually not the fact… like, I could go do that, I just don’t, like, don’t have time, and we don’t have another person internally right now that can…
66 00:11:31.640 ⇒ 00:11:33.999 Uttam Kumaran: That, like, has that background, so…
67 00:11:34.690 ⇒ 00:11:36.990 Uttam Kumaran: I’m like, shit, okay, what do you think?
68 00:11:36.990 ⇒ 00:11:41.400 Shri: How much, so, she just wants, like, business outputs.
69 00:11:41.580 ⇒ 00:11:50.719 Uttam Kumaran: Yeah, let me even show you, like, I’ll show you what they have in Hex, I mean, I haven’t logged in in a sec, but, like, it’s actually… it’s gonna be more… it’s gonna be kind of you going in and being, like.
70 00:11:51.000 ⇒ 00:11:59.690 Uttam Kumaran: But kind of, like, how I see this playing out is, like, I’ll intro you, three of us will hop on a call, and I’ll be like, just lay it on us, like, where you’re having challenges.
71 00:11:59.780 ⇒ 00:12:13.109 Uttam Kumaran: And then we’ll get a little bit organized, and then some of it will maybe be like, hey, let me just sit with you and, like, define out how we want to do mid-month refunds, what are the core revenue buckets, and then you can just send that to us and be like, yo, build me this.
72 00:12:13.760 ⇒ 00:12:14.270 Shri: Yeah. Do the snowflake.
73 00:12:14.270 ⇒ 00:12:15.420 Uttam Kumaran: table that does this.
74 00:12:15.550 ⇒ 00:12:16.280 Shri: Yeah, yeah, yeah.
75 00:12:16.280 ⇒ 00:12:20.190 Uttam Kumaran: And then… and then when we give it to you, you can be like, okay, it’s here. And then…
76 00:12:20.190 ⇒ 00:12:20.920 Shri: No.
77 00:12:20.920 ⇒ 00:12:24.270 Uttam Kumaran: And then, partly, she’s also gonna need help, like, probably creating decks.
78 00:12:24.810 ⇒ 00:12:27.820 Uttam Kumaran: So then it’s, like, again, it’s up to you to decide, like, how much
79 00:12:28.380 ⇒ 00:12:35.740 Uttam Kumaran: you want to do the work versus, like, how much she can handle herself, like, it’ll be a little bit of, like, a learning… we’re just gonna have to figure it out.
80 00:12:36.610 ⇒ 00:12:38.740 Shri: Perfect! Do we want to do a call tomorrow?
81 00:12:38.940 ⇒ 00:12:45.970 Uttam Kumaran: Yeah, let me, let me just see what’s in… let me just see what’s in here.
82 00:13:03.240 ⇒ 00:13:08.239 Uttam Kumaran: I’m just trying to see if there’s anything in their hex that I can just, like, pull up and show you.
83 00:13:11.520 ⇒ 00:13:15.300 Uttam Kumaran: Yeah, like, my guy on our team, like, we,
84 00:13:19.600 ⇒ 00:13:23.620 Uttam Kumaran: He just is more of a data person, so he was like, dude, they’re having questions about, like.
85 00:13:23.720 ⇒ 00:13:27.869 Uttam Kumaran: more, like, logic, like, I don’t even know what to advise them, and I’m like, I don’t have the time.
86 00:13:29.370 ⇒ 00:13:33.980 Uttam Kumaran: And so we’re just sitting on, like… that’s sort of the state right now. We have, like, a bunch of clients where I’m, like.
87 00:13:34.140 ⇒ 00:13:35.979 Uttam Kumaran: We just need to hire more.
88 00:13:37.080 ⇒ 00:13:38.110 Shri: No, for sure.
89 00:13:43.610 ⇒ 00:13:46.230 Uttam Kumaran: What is the hex password?
90 00:14:27.060 ⇒ 00:14:32.360 Uttam Kumaran: Look, okay, I’ll figure it out again next, later today, but, like, here’s a good example,
91 00:14:35.010 ⇒ 00:14:41.790 Uttam Kumaran: There’s an issue with, like, how ARR and MRR, we’ve been issuing invoices for free plans, I noticed it divides the number of invoices.
92 00:14:41.790 ⇒ 00:14:42.370 Shri: Meh.
93 00:14:42.370 ⇒ 00:14:42.980 Uttam Kumaran: Yeah.
94 00:14:45.860 ⇒ 00:14:48.390 Uttam Kumaran: So this is, like, an example question, where it’s like…
95 00:14:49.540 ⇒ 00:14:55.489 Uttam Kumaran: There’s, like, some type of free plan logic that we need to implement to, like, account for free plans.
96 00:14:56.230 ⇒ 00:14:57.659 Uttam Kumaran: Where does that go?
97 00:14:57.770 ⇒ 00:15:01.630 Uttam Kumaran: And so, on our side, Awash, on my team, he’s like, yo, so the invoice is Euro.
98 00:15:01.910 ⇒ 00:15:02.919 Shri: Hang on, let me read it.
99 00:15:02.920 ⇒ 00:15:03.400 Uttam Kumaran: Yeah, yeah.
100 00:15:03.400 ⇒ 00:15:08.010 Shri: Previously issuing invoices for free plans.
101 00:15:08.750 ⇒ 00:15:18.020 Shri: Paid invoices to get error… Endeavor. So basically, they’re… they’re free plans that are actually paid plans.
102 00:15:18.330 ⇒ 00:15:19.150 Uttam Kumaran: Yes.
103 00:15:21.210 ⇒ 00:15:25.699 Uttam Kumaran: So, like, for example, like, this, this is like a.
104 00:15:28.830 ⇒ 00:15:31.810 Shri: And the invoice is marked to be saved as $0, yes, correct.
105 00:15:32.060 ⇒ 00:15:36.149 Shri: Oh, so it’s like the count… got it, yeah, that makes sense.
106 00:15:36.150 ⇒ 00:15:36.880 Uttam Kumaran: Yeah.
107 00:15:37.080 ⇒ 00:15:39.729 Shri: Basically, the count is to…
108 00:15:41.880 ⇒ 00:15:43.130 Uttam Kumaran: Yeah, so for example…
109 00:15:43.130 ⇒ 00:15:49.520 Shri: They shouldn’t… they shouldn’t do it based on payday, they should just do it based on… subscription date.
110 00:15:49.520 ⇒ 00:15:52.940 Uttam Kumaran: Yeah, and so, like, for example, she’s then looking at, like, stuff like this, like, okay.
111 00:15:53.260 ⇒ 00:15:59.639 Uttam Kumaran: for someone that purchased this, what’s the MRR, what’s the ARR? Because we’re… we’re ultimately just trying to multiply it by…
112 00:16:00.250 ⇒ 00:16:06.970 Uttam Kumaran: Like, we have to scale out… like, the problem is, like, some of these are not annual contracts, but they want to do the startup thing of, like.
113 00:16:07.090 ⇒ 00:16:08.430 Uttam Kumaran: This is our ARR.
114 00:16:09.000 ⇒ 00:16:13.910 Uttam Kumaran: So they’re like, should we multiply by 12, even though it’s not true ARR? Like, we’re showing that what is our…
115 00:16:14.490 ⇒ 00:16:17.120 Uttam Kumaran: All things say the same, what is our annual run rate?
116 00:16:18.770 ⇒ 00:16:26.800 Uttam Kumaran: Part of this is, like, again, someone just needs to sit with her and be like, let’s go through some scenarios, let’s agree on these scenarios.
117 00:16:27.040 ⇒ 00:16:31.780 Uttam Kumaran: my team can just go write the sequel, like, we’ll just build you whatever you need, it doesn’t matter.
118 00:16:32.050 ⇒ 00:16:33.519 Uttam Kumaran: And then she’ll get that.
119 00:16:33.520 ⇒ 00:16:36.289 Shri: I actually, yeah, I know…
120 00:16:36.620 ⇒ 00:16:39.379 Uttam Kumaran: I mean, that’s what I’m saying, it’s like, no, I don’t think it’s, like,
121 00:16:40.600 ⇒ 00:16:43.960 Uttam Kumaran: And then, so, but part of this, again, for our folks, it’s sort of like.
122 00:16:44.310 ⇒ 00:16:57.000 Uttam Kumaran: I’m also thinking about, like, how does this person win? Like, how does Sandra win? One is if she just nails accurate reporting, and she’s able to, like, find opportunities where product can make changes to drive these, it’s a big win for her.
123 00:16:57.170 ⇒ 00:17:02.620 Uttam Kumaran: Yeah. She’s, like, semi-technical, like, she can… she works in Hex, can query stuff.
124 00:17:03.850 ⇒ 00:17:06.060 Uttam Kumaran: But it doesn’t have, like, the…
125 00:17:06.060 ⇒ 00:17:16.830 Shri: The best way to set this up is that you have two tables. You kind of have, like, a orders table, or a contracts table, and then you have an ARR, or like a…
126 00:17:17.520 ⇒ 00:17:20.590 Shri: Like, revenue by customer table.
127 00:17:21.460 ⇒ 00:17:22.109 Uttam Kumaran: Wow.
128 00:17:23.640 ⇒ 00:17:25.789 Uttam Kumaran: Well, let me show you, like, what we have.
129 00:17:28.010 ⇒ 00:17:35.010 Uttam Kumaran: Let me show you what we have right now. Oh…
130 00:17:37.670 ⇒ 00:17:44.899 Shri: Yeah, dude, I can definitely help with this. Like, in my head, I have, like, this is what the table should be, these are what the columns should be.
131 00:17:46.080 ⇒ 00:17:46.590 Shri: Oh, I…
132 00:17:46.590 ⇒ 00:17:48.719 Uttam Kumaran: Yeah, so, like, for example.
133 00:17:48.850 ⇒ 00:17:53.129 Uttam Kumaran: we have, like, our dbt models here. If you go to our marts and our revenue.
134 00:17:53.260 ⇒ 00:17:54.930 Uttam Kumaran: We have all these modeled.
135 00:17:55.410 ⇒ 00:17:59.609 Uttam Kumaran: So, invoice lines, invoices, subscriptions.
136 00:18:00.130 ⇒ 00:18:06.400 Uttam Kumaran: one-off invoices canceled, so, like, we can create any view you need, and then here’s where we’re sort of calculating ARR.
137 00:18:06.550 ⇒ 00:18:09.330 Uttam Kumaran: So, if you look here, we’re pulling…
138 00:18:10.270 ⇒ 00:18:12.939 Uttam Kumaran: Stripe subscriptions daily. Okay, this is…
139 00:18:13.950 ⇒ 00:18:17.679 Uttam Kumaran: Okay, that’s a little bit of a weird example, but let’s pull, like, the daily ARR.
140 00:18:19.950 ⇒ 00:18:21.090 Shri: Daily, yeah, there you go.
141 00:18:21.090 ⇒ 00:18:25.749 Uttam Kumaran: one row per subscription with the MRR, ARR, and the churn date.
142 00:18:26.720 ⇒ 00:18:27.450 Uttam Kumaran: Encryption.
143 00:18:27.790 ⇒ 00:18:30.740 Shri: For ARR tables, you should do it per customer.
144 00:18:31.390 ⇒ 00:18:33.200 Uttam Kumaran: Yeah, so we could do… we could…
145 00:18:33.650 ⇒ 00:18:36.250 Uttam Kumaran: We could go do that per customer, too. Yeah, that’s fine.
146 00:18:37.640 ⇒ 00:18:42.400 Shri: Cause that’s… that’s where you’re probably running into issues of, like.
147 00:18:44.290 ⇒ 00:18:53.859 Shri: Yeah, and you need to also define, like, some of the business parameters, like, could a customer… like, do you want to count a customer who goes dormant
148 00:18:54.220 ⇒ 00:18:57.079 Shri: For a month, it has zero spend.
149 00:18:57.270 ⇒ 00:19:01.700 Shri: But reactivates as… Churn or not.
150 00:19:02.010 ⇒ 00:19:06.750 Uttam Kumaran: Yeah, so typically, like, this is the way I used to do it, is, like.
151 00:19:07.230 ⇒ 00:19:15.570 Uttam Kumaran: You sort of have, like, new, active, Downgrade… like, upgrade… churned.
152 00:19:15.730 ⇒ 00:19:17.200 Uttam Kumaran: like, reactivated.
153 00:19:17.860 ⇒ 00:19:20.849 Uttam Kumaran: Right? And that kind of gives you, like, the flows.
154 00:19:21.460 ⇒ 00:19:25.970 Uttam Kumaran: of, like, stuff. So some of these people are just, like, nothing happened. Some of these people are, like, new.
155 00:19:26.150 ⇒ 00:19:30.810 Uttam Kumaran: Some of these people are like, they were active and they downgraded, and so these are, like, revenue, you could do revenue.
156 00:19:31.010 ⇒ 00:19:33.149 Uttam Kumaran: Or you can do, like, user accounts.
157 00:19:34.060 ⇒ 00:19:38.400 Uttam Kumaran: So this is, like, another way of, like, kind of thinking about it that we’ve done.
158 00:19:39.700 ⇒ 00:19:40.390 Shri: Yeah, I…
159 00:19:40.390 ⇒ 00:19:44.290 Uttam Kumaran: What this allows you to show is, like, the flows between, because ultimately they’re trying to see, like.
160 00:19:44.720 ⇒ 00:19:46.479 Shri: You don’t… they’re trying to affect…
161 00:19:46.480 ⇒ 00:19:49.119 Uttam Kumaran: They’re like, holy shit, we lost, like, X amount.
162 00:19:49.600 ⇒ 00:19:54.869 Uttam Kumaran: Of revenue this month. And basically, what you should see is, like, you are adding
163 00:19:55.210 ⇒ 00:20:01.290 Uttam Kumaran: less… you’re adding less than you’re… than you’re losing, you are… you are a net dying.
164 00:20:01.700 ⇒ 00:20:02.230 Uttam Kumaran: Right?
165 00:20:02.230 ⇒ 00:20:02.930 Shri: Yeah.
166 00:20:03.570 ⇒ 00:20:09.259 Uttam Kumaran: And, like, this is the view that I did at, like, Flow Code, and… Stuff like that.
167 00:20:10.170 ⇒ 00:20:12.360 Shri: But, again, it’s sort of like.
168 00:20:12.770 ⇒ 00:20:14.760 Uttam Kumaran: It’s sort of like, whatever they need.
169 00:20:15.320 ⇒ 00:20:21.139 Uttam Kumaran: I mean, really, the things they’re gonna wanna, like, things like, okay, there’s a mid-month upgrade, right?
170 00:20:22.000 ⇒ 00:20:23.550 Uttam Kumaran: Are they prorating?
171 00:20:23.850 ⇒ 00:20:26.559 Uttam Kumaran: Like, or what’s happening in the invoice, right?
172 00:20:26.810 ⇒ 00:20:28.300 Uttam Kumaran: And, like, what should happen?
173 00:20:31.070 ⇒ 00:20:31.680 Shri: Yeah.
174 00:20:32.120 ⇒ 00:20:37.890 Uttam Kumaran: Like, there’s a mid-month, like, downgrade, or… like, mid-month refund.
175 00:20:38.020 ⇒ 00:20:38.840 Uttam Kumaran: Right?
176 00:20:40.000 ⇒ 00:20:41.720 Uttam Kumaran: What if there’s a refund?
177 00:20:42.710 ⇒ 00:20:44.510 Uttam Kumaran: On an annual plan.
178 00:20:45.230 ⇒ 00:20:47.639 Uttam Kumaran: like, what happens to that ARR, right? Like…
179 00:20:48.170 ⇒ 00:20:48.830 Shri: Bam.
180 00:20:48.830 ⇒ 00:20:59.350 Uttam Kumaran: Like, and for example, let’s say we produce an ARR number in November, but the refund happened now. Are we, like, going back and correcting? Is this a snapshot? Like, these are just, like, the mechanics.
181 00:21:00.180 ⇒ 00:21:03.980 Uttam Kumaran: I, like, I don’t know, we just have to go sit with her and, like, figure out.
182 00:21:06.340 ⇒ 00:21:08.430 Uttam Kumaran: I have…
183 00:21:08.670 ⇒ 00:21:12.259 Shri: like, tables I’ve used, I’m trying to fucking find it, but…
184 00:21:12.560 ⇒ 00:21:16.389 Uttam Kumaran: Yeah, like, the common one that I always… I always send people is, like, the…
185 00:21:16.930 ⇒ 00:21:23.930 Uttam Kumaran: like, the David Sachs sort of, like, Subscription metrics…
186 00:21:24.450 ⇒ 00:21:26.670 Uttam Kumaran: As, like, a primer for people to just, like.
187 00:21:28.450 ⇒ 00:21:32.159 Uttam Kumaran: Read about, like, how to measure Their subscription company.
188 00:21:32.430 ⇒ 00:21:39.739 Uttam Kumaran: Because also, dude, they’re immediately, once you solve this, they’re gonna ask for retention, and they’re gonna ask for… they’re gonna ask for everything.
189 00:21:40.220 ⇒ 00:21:46.669 Uttam Kumaran: So, kind of, like, what I’m saying is, like, I’m less worried about, like, you nailing this, more on, like, see, like, what…
190 00:21:47.480 ⇒ 00:21:52.169 Uttam Kumaran: See what they need from you, and like, if you… and see, kind of, like, what you want to do with them, because…
191 00:21:52.840 ⇒ 00:21:55.390 Uttam Kumaran: Probably in the next 3 weeks, I may have someone that can
192 00:21:55.520 ⇒ 00:22:03.740 Uttam Kumaran: fill in a little bit on the analyst side, but otherwise, I was gonna probably tell… I was probably gonna cancel our stuff with them, frankly, if we couldn’t support it, because I don’t…
193 00:22:04.540 ⇒ 00:22:09.709 Uttam Kumaran: we’re on, like, sort of a little bit of an hourly thing, and I’m like, I want them to sign something bigger.
194 00:22:09.950 ⇒ 00:22:13.150 Uttam Kumaran: Yeah. But I don’t have the… I don’t have, like, the analysis support right now.
195 00:22:13.910 ⇒ 00:22:15.750 Shri: Oh, thank God I have this, alright.
196 00:22:16.130 ⇒ 00:22:17.510 Shri: Show and closing.
197 00:22:17.510 ⇒ 00:22:19.210 Uttam Kumaran: Oh, and they’re NSF, by the way.
198 00:22:20.350 ⇒ 00:22:21.410 Shri: Perfect.
199 00:22:22.800 ⇒ 00:22:26.670 Shri: Oh, motherfucker.
200 00:22:28.060 ⇒ 00:22:29.720 Shri: This isn’t what I wanted.
201 00:22:30.410 ⇒ 00:22:33.900 Shri: Alright, let me show you… I can show you on a case study I did.
202 00:22:46.120 ⇒ 00:22:50.950 Shri: I thought I’d gotten everything off my computer, but I clearly didn’t. That’s always annoying.
203 00:23:01.100 ⇒ 00:23:05.240 Shri: So basically, this is in Excel, how do I screen share?
204 00:23:08.440 ⇒ 00:23:16.200 Shri: Google Chrome App Bundle… That’s the other annoying fucking thing with this.
205 00:23:16.550 ⇒ 00:23:18.690 Shri: Screen record… okay, that’s fine.
206 00:23:18.870 ⇒ 00:23:20.360 Uttam Kumaran: It’s gonna have you leave, maybe.
207 00:23:21.000 ⇒ 00:23:24.589 Shri: No, no, no, I was gonna… Oh, yeah.
208 00:23:25.470 ⇒ 00:23:26.520 Uttam Kumaran: Just leave and come back.
209 00:23:27.710 ⇒ 00:23:30.210 Shri: Yeah Cool.
210 00:24:42.390 ⇒ 00:24:43.070 shriramapte: Yo.
211 00:24:43.240 ⇒ 00:24:43.830 Uttam Kumaran: Yo.
212 00:24:44.280 ⇒ 00:24:47.539 shriramapte: Why are there two of me? Okay, so fuck. Alright,
213 00:24:49.990 ⇒ 00:24:53.679 shriramapte: Oh my god, dude, I’m fucking gonna kill my MacBook.
214 00:24:58.390 ⇒ 00:24:59.760 Uttam Kumaran: Not unemployed, bro.
215 00:25:25.370 ⇒ 00:25:26.720 shriramapte: I swear to fuck.
216 00:25:31.220 ⇒ 00:25:32.749 shriramapte: Okay, here we go.
217 00:25:33.410 ⇒ 00:25:34.150 shriramapte: Come on.
218 00:25:35.100 ⇒ 00:25:38.819 shriramapte: Hmm… Alright, so…
219 00:25:43.270 ⇒ 00:25:51.720 shriramapte: Mmm, why this is… Why the control key isn’t working. Alright, fuck it. So basically,
220 00:25:52.240 ⇒ 00:25:58.660 shriramapte: This is, like, an analysis I put together. And…
221 00:25:59.250 ⇒ 00:26:15.279 shriramapte: it, like, goes off of customer ID as, like, the main… in the table, and then down here, you basically… I… like, this is the Excel version, right? But you do, like, the diff calculations, and then you have…
222 00:26:15.660 ⇒ 00:26:18.480 shriramapte: Conditional logic that kind of…
223 00:26:18.990 ⇒ 00:26:24.680 Uttam Kumaran: Well, I guess the only… I guess, yeah, the only difference here is because it’s B2C, I wonder if that changes anything.
224 00:26:26.470 ⇒ 00:26:38.369 shriramapte: No, you still want it aggregated off of the customer. And then the other… the other interesting thing is, like, you also want a table indexed to…
225 00:26:39.130 ⇒ 00:26:43.299 shriramapte: You also want to create another table that’s indexed to join date.
226 00:26:43.420 ⇒ 00:26:46.830 shriramapte: Because then you can do different cohort analyses.
227 00:26:46.830 ⇒ 00:26:48.109 Uttam Kumaran: Yeah, we have that.
228 00:26:48.980 ⇒ 00:26:50.699 Uttam Kumaran: And then…
229 00:26:50.810 ⇒ 00:27:01.469 shriramapte: Yeah, dude, you just calculate, like, this waterfall. I guess because this is consumer, you would add, like, you would break new into new and reactivated.
230 00:27:02.780 ⇒ 00:27:04.850 shriramapte: But,
231 00:27:05.330 ⇒ 00:27:14.590 shriramapte: This is, like, how you’d set it up, and, like, you’d make it so that, because you do it off of customer.
232 00:27:15.750 ⇒ 00:27:22.650 shriramapte: And you build that table off of, like, the subscriptions table, or, like, an invoice report.
233 00:27:23.520 ⇒ 00:27:24.110 Uttam Kumaran: Okay.
234 00:27:24.380 ⇒ 00:27:33.050 shriramapte: that allows you to do a ton of different, like, wares, right? So if you can build a hex that has wear, like.
235 00:27:33.050 ⇒ 00:27:37.560 Uttam Kumaran: Yeah, yeah, yeah, like, I mean, this dude, this is exactly it. Bro, tomorrow, if you literally just…
236 00:27:38.790 ⇒ 00:27:43.709 Uttam Kumaran: I mean, you should just, like, show them this, or, like, flub the numbers and show them this.
237 00:27:44.010 ⇒ 00:27:47.369 Uttam Kumaran: And be like, here’s what we’re… here’s what I want to drive towards.
238 00:27:47.650 ⇒ 00:27:49.679 shriramapte: Yeah. It’s like, you’re gonna nail it.
239 00:27:50.240 ⇒ 00:27:51.060 shriramapte: Perfect.
240 00:27:51.870 ⇒ 00:27:57.729 Uttam Kumaran: Okay, so tell me, how much is it gonna cost, and how much time do you wanna ha- do you wanna put into this?
241 00:27:59.640 ⇒ 00:28:03.850 shriramapte: I mean, bro, I’m unemployed, so… tell me what I can do.
242 00:28:03.850 ⇒ 00:28:07.730 Uttam Kumaran: I feel like you… I feel like… If you’re down to do…
243 00:28:08.120 ⇒ 00:28:11.959 Uttam Kumaran: Like, $150 an hour, 10 hours a week, and start there.
244 00:28:13.380 ⇒ 00:28:19.700 Uttam Kumaran: If you expand this client, and I can do a bigger, bigger piece if it grows, we’re currently on hourly.
245 00:28:20.350 ⇒ 00:28:28.729 Uttam Kumaran: So if it ends up moving to, like, something like Retainer, then it’s sort of up to you. I think part of it… partly is just, like, see what you have a sense for, because…
246 00:28:29.440 ⇒ 00:28:34.649 Uttam Kumaran: I mean, I have, like, probably 2 or 3 other clients you can help with, but it… I don’t, like, it’s sort of up to you.
247 00:28:35.690 ⇒ 00:28:39.080 Uttam Kumaran: I think also, like, I don’t want you to have to, like, do a lot of the…
248 00:28:39.790 ⇒ 00:28:42.939 Uttam Kumaran: Like, your time is most valuably spent with them.
249 00:28:43.050 ⇒ 00:28:46.609 Uttam Kumaran: And, like, at this level, like, pass all the data shit to us.
250 00:28:47.590 ⇒ 00:28:51.460 Uttam Kumaran: and try to level her up a bit. So if you’re fine with that, like.
251 00:28:52.520 ⇒ 00:29:04.009 Uttam Kumaran: That’s great. Like, right now on our side, we’re able to get, like, 200, 250 for, like, senior-level folks like us, and we’re trying to push, like, 300 if we can.
252 00:29:04.890 ⇒ 00:29:07.560 Uttam Kumaran: It’s tough for the startups sometimes, but…
253 00:29:08.070 ⇒ 00:29:11.490 Uttam Kumaran: That’s kind of how we’re going, so if it’s, like, easy money for you, then that’s, like…
254 00:29:13.020 ⇒ 00:29:15.079 shriramapte: Yeah, dude, 10 hours a week would be great.
255 00:29:16.040 ⇒ 00:29:21.100 Uttam Kumaran: Okay. And then… Now, how can I be helpful? What else do you need?
256 00:29:21.230 ⇒ 00:29:26.229 Uttam Kumaran: I mean, I’ll see you next week, or whatever, yeah, the other week, or whatever, but how else can I be.
257 00:29:26.230 ⇒ 00:29:31.269 shriramapte: Yeah, yeah, yeah, when are you thinking of… when are you thinking of… again, I’m trying to figure out cars, and I think.
258 00:29:31.270 ⇒ 00:29:32.950 Uttam Kumaran: Yeah, I need to talk… I need…
259 00:29:33.230 ⇒ 00:29:35.790 Uttam Kumaran: Yeah, I should talk to Jess when she gets home.
260 00:29:36.430 ⇒ 00:29:36.920 shriramapte: Yeah.
261 00:29:36.920 ⇒ 00:29:40.190 Uttam Kumaran: if we’re gonna get a car or not. I might just get rent a car, dude.
262 00:29:40.860 ⇒ 00:29:42.010 shriramapte: You’re gonna rent a car.
263 00:29:42.010 ⇒ 00:29:42.610 Uttam Kumaran: Yeah.
264 00:29:43.280 ⇒ 00:29:45.620 shriramapte: Yeah, that might be a lot easier, because…
265 00:29:45.870 ⇒ 00:29:48.840 shriramapte: cramming you in with Hans and Katie will be tricky.
266 00:29:48.840 ⇒ 00:29:58.920 Uttam Kumaran: Yeah, and I don’t want… I don’t… and everybody else there is gonna be driving home, basically, right? So, like, we’re gonna have to go… so, like, I’ll probably just get a car, I have, like, Avis, so… I think it’s fine.
267 00:29:59.630 ⇒ 00:30:00.360 shriramapte: Okay.
268 00:30:00.400 ⇒ 00:30:04.119 Uttam Kumaran: Yeah. And I was gonna also… I’m gonna put, like.
269 00:30:04.430 ⇒ 00:30:09.219 Uttam Kumaran: us and, like, Hans and Katie in a group chat, because I don’t think Jess will know anybody else, so…
270 00:30:09.710 ⇒ 00:30:12.830 Uttam Kumaran: She doesn’t… I don’t think she’s met Hans or Katie either, but I feel like…
271 00:30:12.830 ⇒ 00:30:17.950 shriramapte: Yeah, I put her… I put her on a team… Cool. …with this…
272 00:30:18.350 ⇒ 00:30:28.360 shriramapte: a girl named Mary, who I think she’s gonna really… you’ve met Mary. I think she and Mary will really get along. And then I also put her with Mugda, because she’s.
273 00:30:28.360 ⇒ 00:30:28.720 Uttam Kumaran: Oh, cool.
274 00:30:29.170 ⇒ 00:30:31.220 shriramapte: Colonel Magda? Yeah.
275 00:30:32.100 ⇒ 00:30:35.880 shriramapte: So, I think, like, that’ll be… that’ll be good.
276 00:30:36.550 ⇒ 00:30:37.160 Uttam Kumaran: Sick.
277 00:30:37.750 ⇒ 00:30:41.800 Uttam Kumaran: And yeah, we’ll rent stuff from the sports… Chalet or basement.
278 00:30:43.820 ⇒ 00:30:47.070 Uttam Kumaran: I have a couple things, but yeah, I’ll get… I’ll get it from there.
279 00:30:48.030 ⇒ 00:30:50.989 shriramapte: Yeah, and let me know as soon as you have dates.
280 00:30:51.130 ⇒ 00:30:58.199 shriramapte: I might… I think Raj and Steph might also need a ride, so I might…
281 00:30:58.940 ⇒ 00:31:01.620 shriramapte: Hit, like, put you in touch with them?
282 00:31:01.620 ⇒ 00:31:01.990 Uttam Kumaran: Okay.
283 00:31:01.990 ⇒ 00:31:11.780 shriramapte: If… if you had to split the cost of a rental car, if your… if your dates line up, but if your dates don’t line up, then that might just be easiest.
284 00:31:12.220 ⇒ 00:31:13.450 Uttam Kumaran: Okay, okay.
285 00:31:15.200 ⇒ 00:31:15.990 shriramapte: Cool.
286 00:31:18.230 ⇒ 00:31:18.910 Uttam Kumaran: Okay.
287 00:31:19.300 ⇒ 00:31:23.940 Uttam Kumaran: What’s, like, what’s, like, what’s the next, like, what’s the next month look like? What are you doing?
288 00:31:25.210 ⇒ 00:31:40.559 shriramapte: Bro, I’m just doing shit like this, and then, I’m headed over to my friend Jake’s to, like, hack on our product idea. I’ll show you a demo as soon as I have it, but it’s basically, like, Anaplan, but, like,
289 00:31:42.150 ⇒ 00:31:52.999 shriramapte: like, agent-driven. So instead of delegating work and, like, follow-ups and all this bullshit to, like, people, you… agents, like, do that on your behalf.
290 00:31:54.840 ⇒ 00:31:57.649 shriramapte: And so, we’re cranking on that.
291 00:31:57.830 ⇒ 00:32:02.860 shriramapte: But bro, like… dude, this guy, like… he…
292 00:32:04.220 ⇒ 00:32:07.739 shriramapte: Broke off his engagement, but he’s still living with the girl?
293 00:32:08.220 ⇒ 00:32:13.590 shriramapte: Wait, what? This is your boy? Yeah, dude. Yeah, dude.
294 00:32:13.590 ⇒ 00:32:14.760 Uttam Kumaran: Where is this going?
295 00:32:15.700 ⇒ 00:32:17.189 shriramapte: So, I’m just like…
296 00:32:18.100 ⇒ 00:32:22.470 Uttam Kumaran: Dude’s just around, and you’re like, yo, check out this demo.
297 00:32:22.470 ⇒ 00:32:27.429 shriramapte: Yeah, bro! And he’s like… Wait, did he, he broke up with her because of this product?
298 00:32:28.460 ⇒ 00:32:29.240 shriramapte: Huh?
299 00:32:29.390 ⇒ 00:32:31.049 Uttam Kumaran: You broke up because of the product?
300 00:32:31.770 ⇒ 00:32:34.279 shriramapte: No, no, no, it’s separate things.
301 00:32:34.500 ⇒ 00:32:35.420 shriramapte: But…
302 00:32:35.650 ⇒ 00:32:42.960 shriramapte: he’s like, oh yeah, dude, let’s do this, like, as soon as we get into YC, like, I’ll quit, like, whatever.
303 00:32:43.360 ⇒ 00:32:51.269 shriramapte: But… like, I’m like, dude, like, should you be starting a company right now? Like…
304 00:32:52.580 ⇒ 00:32:53.780 shriramapte: You know what I mean?
305 00:32:55.070 ⇒ 00:32:59.500 Uttam Kumaran: I agree, bro. I, I… Yeah, I don’t know.
306 00:32:59.860 ⇒ 00:33:02.469 Uttam Kumaran: If I could do it again, I would… I would…
307 00:33:02.660 ⇒ 00:33:05.329 Uttam Kumaran: I just, like, it’s hard to do this alone.
308 00:33:05.620 ⇒ 00:33:07.860 Uttam Kumaran: But it is, like, way better.
309 00:33:08.010 ⇒ 00:33:09.520 Uttam Kumaran: But it’s way harder.
310 00:33:09.830 ⇒ 00:33:14.460 Uttam Kumaran: And so… Yeah, I don’t know, dude, it’s a lot of risk.
311 00:33:15.020 ⇒ 00:33:20.510 Uttam Kumaran: The people, like, don’t have their shit lightly together. The thing is, doing this… doing a business will just…
312 00:33:21.070 ⇒ 00:33:24.029 Uttam Kumaran: Hair at every loose end that you have.
313 00:33:24.320 ⇒ 00:33:31.080 Uttam Kumaran: So if his marriage or his engagement is the loose end, it’s not like it’s gonna get better.
314 00:33:32.120 ⇒ 00:33:32.470 shriramapte: Yeah.
315 00:33:32.470 ⇒ 00:33:34.159 Uttam Kumaran: He’s gonna have more time.
316 00:33:35.130 ⇒ 00:33:37.220 shriramapte: Yeah, I… yeah.
317 00:33:41.160 ⇒ 00:33:45.669 shriramapte: I, yeah, I don’t know.
318 00:33:46.330 ⇒ 00:33:47.180 Uttam Kumaran: That’s funny.
319 00:33:49.830 ⇒ 00:33:53.980 shriramapte: I don’t know, dude. Yeah, it’s… it’s… It’s kinda…
320 00:33:57.560 ⇒ 00:33:59.330 shriramapte: It is kind of tricky.
321 00:34:00.700 ⇒ 00:34:01.460 Uttam Kumaran: Yeah…
322 00:34:04.800 ⇒ 00:34:05.410 Uttam Kumaran: Okay, so.
323 00:34:05.410 ⇒ 00:34:06.210 shriramapte: Let me know, man.
324 00:34:06.210 ⇒ 00:34:10.110 Uttam Kumaran: Well, let me… I’ll send you a contract. I’ll try to get time tomorrow.
325 00:34:10.550 ⇒ 00:34:11.519 Uttam Kumaran: With her.
326 00:34:12.199 ⇒ 00:34:18.219 Uttam Kumaran: I’ll probably see if, like, 15 minutes before the call, me, you, and Awash or my team can meet.
327 00:34:18.889 ⇒ 00:34:21.209 Uttam Kumaran: Do you have any… are you, like, free…
328 00:34:21.460 ⇒ 00:34:26.240 Uttam Kumaran: she’s Pacific Time, but, like, do you… I can try to find some time tomorrow or Friday.
329 00:34:28.429 ⇒ 00:34:30.359 shriramapte: Yeah, tomorrow or Friday would be great.
330 00:34:31.770 ⇒ 00:34:36.250 Uttam Kumaran: you’re just like, oh, you’re on… well, you don’t have anything, so just at any point, if I can find time, that’s okay.
331 00:34:37.440 ⇒ 00:34:42.299 shriramapte: Yeah, yeah, yeah, my… I have, calls…
332 00:34:43.540 ⇒ 00:34:49.650 shriramapte: I have a call 10 to 11, tomorrow, but… and then Friday, I’m wide open.
333 00:34:50.770 ⇒ 00:34:52.729 Uttam Kumaran: Okay, I’ll just mark that.
334 00:34:55.060 ⇒ 00:34:56.229 Uttam Kumaran: Okay, cool, dude.
335 00:34:56.520 ⇒ 00:34:57.320 Uttam Kumaran: Yeah.
336 00:34:58.740 ⇒ 00:34:59.689 shriramapte: Hell yeah, dude.
337 00:34:59.690 ⇒ 00:35:02.769 Uttam Kumaran: Should be good, hopefully, let’s see what she says. They could use the help.
338 00:35:02.770 ⇒ 00:35:03.390 shriramapte: Damn.
339 00:35:04.940 ⇒ 00:35:05.780 shriramapte: Cool.
340 00:35:06.200 ⇒ 00:35:08.959 shriramapte: Alright. Cool, man. Keep me posted.
341 00:35:08.960 ⇒ 00:35:13.700 Uttam Kumaran: Dude, and we have a bunch of other clients that are actually, like, still need, like, larger finance help, so…
342 00:35:13.900 ⇒ 00:35:16.980 Uttam Kumaran: Give this a shot, and kind of see, like, what you think, like…
343 00:35:17.810 ⇒ 00:35:21.930 Uttam Kumaran: like, I don’t know if I told you, like, we’re working with Element, the, like…
344 00:35:22.030 ⇒ 00:35:26.869 Uttam Kumaran: Hydration company, like, huge business. Couple other businesses where they just need, like, kind of some…
345 00:35:27.110 ⇒ 00:35:29.349 Uttam Kumaran: Financial analysis stuff, and like…
346 00:35:29.930 ⇒ 00:35:35.140 Uttam Kumaran: growth stuff, so, like, as you need work, you just, like, I think we’ll start with this one, you let me know.
347 00:35:37.900 ⇒ 00:35:40.039 Uttam Kumaran: Sounds good, man. Yeah. Okay.
348 00:35:40.280 ⇒ 00:35:41.390 shriramapte: Excited.
349 00:35:42.380 ⇒ 00:35:45.209 Uttam Kumaran: Sick, bro. Alright, I’ll text you soon about skiing stuff.
350 00:35:45.910 ⇒ 00:35:47.240 shriramapte: Yeah, keep me posted.
351 00:35:47.470 ⇒ 00:35:48.300 Uttam Kumaran: Okay, alright.
352 00:35:49.030 ⇒ 00:35:49.680 shriramapte: later.