Wasn’t it fun? We just finished the chapter Product Analytics. Part 2!
I think it was a very intense chapter in terms of new learnings. We not only wrote queries with multiple window functions and learned new tricks but also leaned about activation and retention rates. All AARRR metrics are covered! Took us just 200 lessons!
All righty, before let’s recap what we’ve learned in this chapter to celebrate!
Calculating release dates from the activity stream
We started the chapter by learning a very useful technique – extracting starting dates...