Request Media Kit

Google Analytics Gets New Apps Script Automation

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...
Google Analytics Gets New Apps Script Automation
Written by Chris Crum
  • 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:

    Google Analytics in Spreadsheet

    “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.

    Get the WebProNews newsletter delivered to your inbox

    Get the free daily newsletter read by decision makers

    Subscribe
    Advertise with Us

    Ready to get started?

    Get our media kit