- Create Account (Analytics, Admin, New account)
- Technique 1: google scripts
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