Anonymous

Project:LHS Graphs and Visualizations: Difference between revisions

From London Hackspace Wiki
no edit summary
No edit summary
Line 3: Line 3:
I'd like to supplement [http://hack.rs/cacti/graph_view.php?action=tree&tree_id=1 the Cacti graphs] that we have for LHS bandwidth and power with metrics that provide insight to the growth of our community and organisation over time.
I'd like to supplement [http://hack.rs/cacti/graph_view.php?action=tree&tree_id=1 the Cacti graphs] that we have for LHS bandwidth and power with metrics that provide insight to the growth of our community and organisation over time.


Phase 1 is complete and we now [http://hack.rs/cacti/graph_view.php?action=tree&tree_id=5 chart the following]:
We [http://hack.rs/cacti/graph_view.php?action=tree&tree_id=5 chart the following]:
* Number of members
* Number of members
* IRC activity
* IRC activity
Line 10: Line 10:
* Space occupancy
* Space occupancy


Later I'd like to investigate:
To chart the initial metrics various bits of data are exposed in a Cacti friendly way.
* Website visitors and/or page impressions


==In progress==
==Space occupancy==
''See project: [[Project:Spacensus|spacensus]]''
''See project: [[Project:Spacensus|spacensus]]''


==Desired==
==IRC statistics==
 
''See project: [[Project:Ircensus|ircensus]]''
====Website visitors and/or page impressions====
The main site and the Wiki use Google Analytics and this has an API. This [http://code.google.com/apis/analytics/docs/gdata/gdataCommonQueries.html documented method] looks promising:
  https://www.google.com/analytics/feeds/data?metrics=ga%3Avisits%2Cga%3Apageviews&start-date=2010-11-29&end-date=2010-12-13&max-results=50
 
==Done==
 
To chart the initial metrics various bits of data are exposed in a Cacti friendly way.


====Number of members====
==Number of members==


'''COMPLETE''' - but may have to wait 12 months before it becomes interesting.
We may have to wait 12 months before it becomes interesting.


This data is stored in an Sqlite database on [[Turing]].  See the [https://github.com/londonhackspace/hackspace-foundation-sites/blob/master/etc/schema.sql Schema]. It can be queried like so:
This data is stored in an Sqlite database on [[Turing]].  See the [https://github.com/londonhackspace/hackspace-foundation-sites/blob/master/etc/schema.sql Schema]. It can be queried like so:
Line 41: Line 33:
'''URL:''' http://london.hackspace.org.uk/member_stats.php
'''URL:''' http://london.hackspace.org.uk/member_stats.php


====Wiki statistics====
==Wiki statistics==
'''COMPLETE'''
 
* We get this using the MediaWiki API:
* We get this using the MediaWiki API:


Line 72: Line 62:
'''Code:''' https://github.com/londonhackspace/monitoring
'''Code:''' https://github.com/londonhackspace/monitoring


====IRC statistics====
==Mailing list activity==
''See project: [[Project:Ircensus|ircensus]]''
 
====Mailing list activity====
 
'''COMPLETE'''


* My thanks to JamesG for his assistance and '78.86.160.161' for the original idea. We poll and scrape the groups page for members and and message count.
* My thanks to JamesG for his assistance and '78.86.160.161' for the original idea. We poll and scrape the groups page for members and and message count.
1,649

edits