Support/MetricsDashboardPRD
< Support
Jump to navigation
Jump to search
This PRD is just a draft.
Absolute must-haves
- Flexible framework where new metrics can easily be added via new SQL queries
- Metrics should be able to be categorized so that they don't just all pile up on a single page
- Metrics may have different date ranges (e.g. last week, last month, etc.) and should be clearly labeled as such
- Historic tracking of metrics -- similar to how we're saving metrics over time on the Weekly Metrics spreadsheet
Should be considered for inclusion
- TikiWiki integration -- not entirely clear what this means (needs discussion)
- Automatic import of data from Omniture -- there is an API to pull data from Omniture, so this should be possible. Alternatively, Omniture might be able to export/send data.
- Dynamic reporting -- i.e. specify what you want and what time period and have it generate just that report rather than only showing static reports
- Tabbed/folded interface (because otherwise it'd be very cluttered, or the page of stats will be very long)
Future ideas (not formal requirements)
- Graphing of data over time -- piecharts, histograms, etc.
- Access to individual results (specific pages or specific locales or specific users -- may need restrictions).
- This means that you can say, click on "Firefox crashes when you open it" and see how many people get there via search vs from forums vs from front page vs Google and also what the CSAT data for that page was like and also how these things trended over time
- Or see how CSAT data is in /fr/ vs /de/ or something. Tracking by users is necessary for karma anyway so setting up a way to track it here would give us a head start on that.
Needs decision or investigation
- Do we have any similar dashboard projects done in the past?
- Any code we can reuse?
- Any previous work on scope/implementation we can apply here?
- Static or dynamic data?
- In a nutshell, are we just going for a list of SQL queries that are cron-jobbed daily/weekly/monthly and continue to do special/ad-hoc queries manually?
- OR, do we store the data we periodically gather in a way that enables us to select date ranges for the data.
- Are we aiming for TikiWiki integration, or are we something separate?
- What about productization of SUMO?
- Other SUMO installations might not have Omniture -- do we need an interface between site metrics and TikiWiki metrics so Omniture can easily be replaced with e.g. Urchin, Google Analytics, or whatever other sites might be using?