Google announced today that it has released a new Google Analytics feature, that enables data from GA to be put into any Apps Script-supported product more easily. That includes Google Docs, Sites and Spreadsheets.
“Many people have been asking for a simple way to put Google Analytics data into a Google Spreadsheet,” says Google engineer Nick Mihailovski. “Once the data is inside a Google Spreadsheet, users can easily manipulate Google Analytics data, create new visualizations, and build internal dashboards.”
Here, you can see what Google Analytics data accessed via Apps Script, and displayed in a Google Spreadsheet might look like:
“We know that a popular use case of this integration will be to create dashboards that automatically update,” writes Mihailovski. “To make this easy to do, we’ve added a script to the Spreadsheets script gallery that handles all this work – no code required. The script is called Google Analytics Report Automation (Magic).”
He provides the following video demo of how to use the script to build a dashboard:
You can find the Google Analytics Apps Script documentation here. And here’s a tutorial for automated access to Google Analytics data in Google Spreadsheets.