ThoughtSpot acquires Mode to define the next generation of collaborative BI >>Learn More

Analysis

Finding User Sessions with SQL

A lot of product questions are based on the idea of a user “session.” What do users do when they first log in? In what order do users take specific actions? How long do people use your site in an average sitting? Does activity vary by device?

A number of analytics tools define user sessions automatically. But, default definitions may not be appropriate for your unique product or, even if they are, there will be times you'll want to define sessions using your raw event data. This can seem daunting—but it doesn't need to be.

Read more

Editor’s picks in Analysis

Analysis

Types of Product Usage Segmentation

October 19, 2024

Analysis

The Modern Data Stack Guide for 2023

October 19, 2024

Analysis

Facebook's "Aha" Moment Was Simpler Than You Think

October 19, 2024

Get more from your data

Your team can be up and running in 30 minutes or less.