Google Analytics Real Time Reporting API Work

updated 18-9-2013

OBJECTIVE: we need to pull,record and present data from Google Analytics over a 3-4 week period starting asap.

Main times to record are between 0800GMT - 2200GMT but ideally this should be 24/7, ideally every 30 seconds, preferably every 15 seconds.

I believe this can be done using the Real Time Reporting API
https://developers.google.com/analytics/devguides/reporting/realtime/v3/#user_reports

Main metric we would like is (active) visitors, if possible unique visitors too.

If possible, we'd also like (top 10) City and (top 10) Source at any one time.

Start date and deadline is asap.

In terms of deliverables, I guess the data would be best delivered in a spreadsheet, pivot table better, some form of dashboard preferable. We'd want access to the raw data too.

Examples of what we'd want =
* to look up unique visits/active visitors over a time period, e.g. 30 seconds, 5 minutes, 10 minutes, on any day

* to look up visits/active visitors in a location for a particular length of time.

The reason for this is due to a television campaign

I'd need to see a quick mock up of how the data would be delivered.

Look forward to reading your proposals.

Si