From Modèles de l'Économie Numérique

Main: Google

Following http://www.youtube.com/watch?v=rL4N3qFyycg

  • google drive: new spreadsheet project: M3
  • Tools/script Gallery/Search
  • "Analytics": Google Analytics Report Automation (magic)
  • install then authorize
  • Tools/script editor
  • Resources/Use Google API
  • Google API console to get API key
  • Create New project
  • Services/Enable Analytics API
  • API Access
  • Copy API Key (if needed)
  • Run the script
  • Back to Spreadsheet menu: Google Analytics tab appears
  • Google Analytics/Create Core report
  • Select the Analytics account/authorize
  • Query parameters in column 1:
    • query 1 (simplest query: get the number of visitors, visits in the last days10, per day)
    • type
    • ids (identity through Google Analytics/Find profile ids ga:77740xxx for example)
    • start-date
    • end-date
    • last-n-days 10
    • metrics ga:visitors, ga:visits
    • dimensions ga:date
    • sort
    • filters
    • segment
    • start-index
    • max-results
    • sheet-name report
  • Report contient les données
  • Visualisation en Charts
  • Triggers
  • Publication sur sites.google.com
    • create site
    • edit page, insert chart
    • save
  • Result: https://sites.google.com/site/du2013m3/

https://code.google.com/p/google-api-php-client/source/browse/#svn%2Ftrunk%2Fexamples%2Fanaly2Fanalytics%2Fdemo

Retrieved from http://dup2.free.fr/index.php?n=Main.Google
Page last modified on November 17, 2013, at 05:05 PM