Getting Analytics Pageviews into a sheet

If you followed Do something useful with GAS in 5 minutes, you'll already know how to use a spreadsheet as a database, and in Get analytics profiles in a sheet you found out how to get Google Analaytics properties into a sheet. To be able to get analytics data, you'll need the id of the profile you are interested in. It's the column named 'id' from Get analytics profiles in a sheet 

Here's how to get your pageviews into a Sheet. This is the second step if you are interested in Displaying analytics data on site pages, or otherwise playing around with you Analytics data.
do something in 5 with gas-5-anltycs

do something in 5 with gas-5-anltycs


For more snippets like this see Google Apps Scripts snippets
For help and more information join our forumfollow the blogfollow me on twitter

You want to learn Google Apps Script?

Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.




Comments