Why not just use Pingdom which is designed for that?
One thing Docs is good for though is building custom dashboards on a $0 budget. We've got one at https://starthq.com that shows our key metrics and graphs cohorts for the last few weeks.
One thing Docs is good for though is building custom dashboards on a $0 budget. We've got one at https://starthq.com that shows our key metrics and graphs cohorts for the last few weeks.
- /:start/:end - number of users registered within date range
- /:start/:end/active - number of users registered within date range who were active within last week
etc. etc.
Then it's pretty straightforward to use ImportData & CONCATENATE, as well as fill down to create a matrix of cohorts, which can in turn be graphed.
In general it's best to pull in the raw data with ImportData and then calculate percentages and such in the spreadsheet. The latter are updated when the cells they reference refresh.
Docs refreshes ImportData sources once every hour, caching them in between, so the load on the server and DB is minimal and you end up with more or less current stats.
No, scratch that. You get 10 "checks" with pingdom free.