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

Report: most visited pages by day

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, 

 

I want to create report named "Most visited pages by day". I want to have in such report:

 

date - most visited page - sessions number

date2 - most visited page - sessions number

 

etc.

one date = ona page.

 

I was trying custom reports but I don't see any way to do what I want, even with pivot tables.

1 Expert replyverified_user

Re: Report: most visited pages by day

Rising Star
# 2
Rising Star
While custom reports are great they do not give you the flexibility to only extract one page worth of information per day. Create your custom report export it into Excel then sort the data by date then by pageviews. Then you can use the wonder of Excel math to create a custom report that will pull the first unique record based upon date or use pivot tables inside of Excel to give the data from different angles. I personally preffer to view my data inside of Excel as opposed to GA so much more I can do with it. GA is great at providing the data Excel is great for analyzing the data.