2.6K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
Guide Me

Traffic Numbers by Month

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

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.

1 Expert replyverified_user

Re: Traffic Numbers by Month

[ Edited ]
Rising Star
# 2
Rising Star

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.

Re: Traffic Numbers by Month

Rising Star
# 3
Rising Star