How to download access data for each page with Google Analytics

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.

1. How to download access data for each page with Google Analytics

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.

After logging in to Google Analytics,

1. Click [Custom> Custom Report]
2. Click [New Custom Report]
Google Analytics report confirmation screen
3. Select [User] in the metric group (add other metrics in the same way)
4. Select [Page] for the dimension
5. Click [Save]
Google Analytics Custom Report Confirmation Screen

Then we were able to summarize the access data of each page including the number of unique users.

6. Click [Export] to download the access data of each page as Excel.
How to download Google Analytics data

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.

2. How to download access data for each page in Anatomy

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
Porter screen of access analysis tool "Anatomy"
2. Select the date of the data you want to get
3. Click Download
The access analysis tool "Anatomy" allows you to download Google Analytics data in Excel format on any date.

Conclusion

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.

Click here for related articles ▼