Traffic Numbers by Month
I have about 15 websites set up in Google Analytics. I'd like to run a report for each site showing: unique users, page views, sessions, pages per session and the bounce rate, and then by month for 2015.
I'd like to export this data into Excel and show all the data by site and by month. Is there an easy way to run this monthly report for each site and export? Right now all I am able to do is run a graphic version and hover over the month to see the numbers. I'd like the data (ie: numbers) versus a graphic version.
Re: Traffic Numbers by Month[ Edited ]
March 2016 - last edited March 2016
Sure thing set up a custom report.
For Type choose "Flat Table"
For your Dimension use "Month of Year"
For your Metrics choose "Users" "Pageviews" Sessions" "Pages/Session" "Bounce Rate"
Give it name select the views you wish to run it in and then Save.
Run each report in each view export it to Excel combine the reports, add a new column to define the website. Then create a pivot table on it so you can slice and dice it.
Should come out looking like the image below.