Analytics
1.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
star_border
Reply

Google Analytics for sheets

Follower ✭ ✭ ✭
# 1
Follower ✭ ✭ ✭

Hi,

 

I created a report with Google analytics for sheets add-on.

 

1 ) Can i view only top 10 pages in the sheet as per pageviews. I don't want to view all the pages. Just top 10. is there any metric or dimension for this

 

2 ) The rows of my report are - pagepath, sessions, pageviews, unique pageviews and Average time on page. (For Feb, march and april months)

 

Now, i would like to create a dashboard for these 3 months. How can i do it

 

Thanks

 

 

2 Expert replyverified_user

Google Analytics for sheets

Rising Star
# 2
Rising Star

Hi Jackspwter,

 

Set Max Results to 10.  Smiley Happy  You an create the dashboard in the sheet, in Google data studio or using the embed api.

 

https://ga-dev-tools.appspot.com/embed-api/basic-dashboard/

 

Best,

 

Theo Bennett

Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn

Google Analytics for sheets

Follower ✭ ✭ ✭
# 3
Follower ✭ ✭ ✭

Thanks.

 

In googlea analytics for sheets, where can i set this. I mean max results 10. I will try what you said.

Re: Google Analytics for sheets

Rising Star
# 4
Rising Star

Hey Jackspwtr,

 

After you create the report, go to the report configuration tab, you'll see a field in the first column "Max Results" in the 2nd column, the one with you dimensions and metrics, add a 10 next to Max Results.

 

 ss sheets max results.png

Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn

Google Analytics for sheets

Rising Star
# 5
Rising Star

Not sure why my notation became a smiley, but it's sort of cute so I'll leave it in.

John Wedderburn, Advertiser Community, Rising Star
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.

Google Analytics for sheets

Rising Star
# 6
Rising Star

Thanks @John W I meant to add in those points.  Smiley Happy

Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn