Joining across multiple CTE
I m trying to create a table that shows the the number of unique user(Sessions) on every page of the website, grouped by marketing channel, then grouped click events, count of the clicks event and download that are have been attributed to those groups.
I am not exactly sure how to best explain this but that table will be used to calculate the conversion rate at row level for each groups.
see below