This is a Dashing dashboard for showing historical and realtime Google Analytics from a number of websites. We use this to keep an eye on our various microsites and web applications.
It shows historical Google Analytics session data for the last 7 days (including today), and refreshes it every hour. It refreshes the realtime visitor count every 10 seconds.
Here's an example with random data:
- clone the repo
- run
bundle install - setup a Google API key (see below)
- configure your websites in
websites.json - run
rackupand visit http://localhost:9292
You need to get a Google OAuth 2.0 Service account key and grant it access to the Google Analytics scope.
The Google API key comes in PKCS12 format. This must be converted to PEM format so it can be injected via an environment variable.
openssl pkcs12 -in Analytics-abc123.p12 -nodes -nocerts | fgrep -A 50 BEGIN > privatekey.pem
This is sensitive and shouldn't be in source control. So it will be injected using environment variables:
export GOOGLE_API_KEY="`cat privatekey.pem`"
Take the email address generated for your API key xxxx@developer.gserviceaccount.com and give it
permissions on the Google Analytics accounts and/or properties you want to show in the dashboard.
Also set change the google_account_id variable in jobs/google_analytics.rb.
google_account_id = 'xxx@developer.gserviceaccount.com'
This app runs on Heroku.
heroku config:set GOOGLE_API_KEY="`cat privatekey.pem`"
heroku config:set BASIC_AUTH_USER=a-username\
BASIC_AUTH_PASS=a-password
git push heroku