Signal-based scoring is easier than you think and you don’t need Machine Learning — Product manager, analyst, growth hacker, designer or a marketer — understanding user personas is invaluable for any of those roles. While third-party tools can be helpful for gaining initial insights, having your hands on the raw data is incredibly valuable to create accurate models of user behavior. This blog post…

A BigQuery SQL + Data Studio Solution — This is a follow-up post to this post where I shared how BigQuery data can be used to understand user journeys. …

Understand user journeys without investing in a third-party tool — If you use Firebase and BigQuery, here’s how you can tap into clickstream data from iOS native app and turn it into actionable insights about user journeys. You don’t need any third-party apps for it, and you can customize your analysis for the deep dives. Untapped Goldmine of Clickstream Data If you’re using Firebase for…

On a Subscription Based Example — Consider these as primers to customer lifetime value: these 3 parts are quite easy to digest and will give you a good intro to LTV. In Part 1, I went through the logical piece, so if you’re interested, go check it out! In (a small) Part 2, I showed an…

As a Sum of Cohort Retention, not a Proof but an Experiment A Bit of Inspiration This is a short-read follow-up post to the one I wrote on determining the average lifetime value of a cohort using retention, which you can find here. There, I have suggested a way how you…

CLV or LTV as they call it — This is Part I of the two-part series dedicated to estimating customer lifetime value. In this post, I will describe how to estimate LTV, on a conceptual level, in order to explain what we’re going to be doing in Part II with the Python code. First of all, why LTV…

Thoughts on a scraper design that could save your time — In this post, I am sharing my first experience with web scraping and the tools I have used (Scrapy and Selenium). I hope this piece will be helpful to someone seeking for general guidance as I am covering the learnings I find valuable and things I wish I knew when…

This was my first attempt to perform customer clustering on real-life data, and it’s been a valuable experience. While articles and blog posts about clustering using numerical variables on the net are abundant, it took me some time to find solutions for categorical data, which is, indeed, less straightforward if…