Finding User Sessions with SQL
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.
If a user opens Facebook, clicks around the timeline, looks at a few pictures, and then closes ... Though these tables typically include a lot of information—user IDs , ... Once you create this table, it's easy to figure out the average length of a ...