Saturday, November 3, 2012

Automate GA Reports, Create Visualizations and Build Dashboards | API, Apps Script

API & Apps Script Integration in Google Spreadsheet

Google analytics data can be pulled into Apps script supported products such as Google Docs, Sites, or Spreadsheets using GA  API. This integration dramatically reduces the manual work required to pull Google Analytics data and  you can utilize all the great features of Google Spreadsheets, such as easy sharing, collaboration, automation, charting and visualization tools.

Components of Integration

  • Application Registration to Generate API Key
  • Enabling API in Google Script
  • Google Script Installation
  • Querying GA Data
  • Creating Reports, Automation and Building Dashboards
Benefits of Integration
  • Create GA reports using Google spreadsheet
  • Define & automate reporting tasks – Minutes / Hours / Days / Weeks / at any specified date
  • Access GA data by writing queries in spreadsheet, without logging to Google Analytics UI
  • Multiple queries to pull GA data can be made simultaneously  from Google spreadsheet
  • Create new visualizations
  • Build Dashboards
  • Pull any dimensions and metrics easily to the spreadsheet, even the ones that are not available in Google analytics UI
  • Kill the limitations of  being able to pull only 2 dimensions at a time

1 comment:

  1. My Brand is the new brand in India which aims to bring in the high-quality exported standard material at an unbelievable price. As you know the quality, comfort and price are the most important things beyond just BRAND name. Go for MY BRAND! You cannot get these rates anywhere else for this kind of high-quality garments..For More please visit the link below.