There are many Google Analytics dashboards like it, but this one is mine:
Its a bare bones framework where I can start to publish publicly some of the R work I have been learning over the past couple of years.
At the moment the app has just been made to authenticate and show some generic output, but I plan to create a lot more interesting plots/graphs from it in the future.
How To Use It
- You need a Google Analytics account.
- Go to
- You'll see this screen. Pardon the over heavy legal disclaimers, I'm just covering my arse. I have no intention of using this app to mine data, but other's GA apps might, so I would be wary giving access to Google Analytics for other webapps, especially now its possible to add users via the management API.
- Click the "GA Authentication" link. It'll take you to the Google account screen, where you say its ok to use the data (if it is), and copy-paste the token it then displays.
- This token allows the app (but not me) process your data. Go back to the app and paste the token in the box.
- Wait about 10 seconds, depending on how many accounts you have in your Google Analytics.
- Sometimes you may see "Bad Request" which means the app is bad, and the GA call has errored. If you hard reload the page (on Firefox this is SHIFT + RELOAD), you need to reauthenticate starting from step 2 above. Sorry.
- You should now see a table of your GA Views on the "GA View Table" tab. You can search and browse the table, and choose the account and profile ID you want to work with via the left hand drop downs. Example using Sanne's Copenhagenish blog:
- If you click on "Charts" tab in the middle, you should see some Google Charts of your Visits and PageViews. Just place holders for now.
- If you click on the "Forecasts" tab you should see some forecasting of your visits data. If it doesn't show, make sure the date range to the far left covers 70 days (say 1st Dec 2013 to 20th Feb 2014).
- The Forecast is based on Holt-Winters exponential smoothing to try and model seasonality. The red line is your actual data, the blue the model's guess including 70 days into the future. The green area is the margin of error to 50% confidence, and the Time axis shows number of months. To be improved.
- Under the forecast model is a decomposition of the visits time series. Top graph is the actual data, second is the trend without seasonal, third graph the 31 data seasonal trend and the forth graph is the random everything else.
- In the last "Data Table" tab you can see the top 1000 rows of data.
That's it for now, but I'll be doing more in the future with some more exciting uses of GA data, including clustering, unsupervised learning, multinomial regression and sexy stuff like that.
Update 24th Feb
I've now added a bit of segmentation, with SEO and Referral data available trended, forecasted and decomposed.