Is there anyone who summarizes the access data of each page in Excel every week?
Here, we will show you how to download the access data of each page with Google Analytics and also a tool that can easily summarize it in Excel.
Google Analytics can download the access data by clicking the export in the upper right.
For example, suppose you need data that summarizes each metric, including the number of unique users, for each page. By default, it only shows pageviews, visits per page, average time on page, visits, bounce rate, and exit rate, so you need to add metrics such as unique users in custom reports.
- 1. Click [Custom> Custom Report]
2. Click [New Custom Report]
- 3. Select [User] in the metric group (add other metrics in the same way)
4. Select [Page] for the dimension
5. Click [Save]
- 6. Click [Export] to download the access data of each page as Excel.
After logging in to Google Analytics,
Then we were able to summarize the access data of each page including the number of unique users.
When downloading data other than the ones listed by default in Google Analytics as Excel, it is necessary to use a custom report, which is a little troublesome.
The access analysis tool "Anatomy" that "visualizes" Google Analytics allows you to download access data without creating a custom report.
It is a great thing that you can download the latest 12 weeks of access data of up to 15 items below in an Excel file with just 3 clicks.
Number of page views, unique users, number of visits by page, number of inflows, number of inflows (search), number of inflows (SNS), number of inflows (ads), number of bounces, bounce rate, number of exits, number of exits, number of orders, Orders / contributions / contributions
- 1. Click the 12 week data download in the portal
- 2. Select the date of the data you want to get
3. Click Download
I want to reduce the work of compiling data into Excel as much as possible. If you are a little troublesome to export Google Analytics, try "Anatomy" once.
If you have any concerns about your Google Analytics settings, such as not being able to measure the pages you care about, there is also a service that can diagnose the settings of Google Analytics.