SOLVED
Average Monthly Unique Visitors by Channel
Hello!
This is a follow up to a previous post that I made re: average monthly unique visitors. I used Josh Stephens solution of the Column mean function to find average monthly unique visitors using the Month dimension. However, I have been asked to compare average monthly unique visitors by channel with a YoY comparison while putting it in a graph (that will hopefully look like the below screenshot). I am having issues with this because it is difficult to have the month dimension in a table that compares the three months of Q1 of 2024 and Q1 of 2025 with the different channels and calculating a mean for all of those functions in a neat and understandable way. I hope this makes sense!
1 Accepted Solution
Correct answer by
The way I would do this is I would first create a calculated metric for average monthly visits by doing visits (or sessions because I'm using CJA) divided by a distinct count of months.
Then you can put this in your table and add a time period column for YoY. Then from the table you just do a bar chart (or line, or whatever viz you want).
One thing to keep in mind with this, make sure your date ranges are full months so that you get an accurate average. But using the count of months will account for if you change your date range from 3 to 4 months, for example. Otherwise you could always just do visits divided by 3, if it's always going to be 3 months.
Correct answer by
The way I would do this is I would first create a calculated metric for average monthly visits by doing visits (or sessions because I'm using CJA) divided by a distinct count of months.
Then you can put this in your table and add a time period column for YoY. Then from the table you just do a bar chart (or line, or whatever viz you want).
One thing to keep in mind with this, make sure your date ranges are full months so that you get an accurate average. But using the count of months will account for if you change your date range from 3 to 4 months, for example. Otherwise you could always just do visits divided by 3, if it's always going to be 3 months.
