How can I calculate stickiness or number of unique page views a user viewed in a single session?

Counting the number of unique URLs or pages a user viewed in a single session is crucial for understanding the amount of interest users show on your site. Combine this with the session duration and drill down to the users most popular paths allows you to understand how users behave on the site.

select unique_pages, count(distinct session_id) as sessions
(select session_id, count(distinct page_url) as unique_pages
from cooladata
where date_range(context)
and filters(context) 
group by session_id)
group by 1
order by 1