Applying Analytical Patterns: Mastering Growth Accounting and Retention Analysis Day 1 Lab

The day one lecture. If you're taking this class for credit, make sure to switch to the other tab so that you get credit for it. So if you check out the lab. First off, we're going to be creating this DDL here. I'll explain how this DDL like kind of works. We're just gonna step through this first, so. Um, and we're actually going to be using this same table for their survivor analysis as well, and I think that will be very useful. Um, you'll see here we have user users growth accounting and then we have user ID obviously. Then we have a first active date, so this is the first day that that user showed up. Uh, this might not like this is where cumulative table design can kind of mess up where like they like if you start the accumulation on the wrong day, if you actually don't start at the beginning of of history, then you might uh end up saying a user's first active date is the wrong day and they were actually active much. Earlier, but like you just didn't start the accumulation and that's fine. That's like one of those things that like essentially that uh goes away over time. And then uh you have last active date is gonna be uh the last day they were active and then you have daily active state, weekly active state. So these are gonna be our um. Values that are going to be uh like growth accounting, you remember those like churned or resurrected, those kind of values. And then dates active and date. So dates active is we're just, we're keeping this around.