Community Server Reporting

1 minute read

As I mentioned this weekend our interns have been working on a reporting framework for Community Server. The reporting application requires a separate database as it reads from an existing CS database (incrementally) and then re-organizes the data into a data structure designed for reporting.

Some details and screenshots below:

  • Over 50 reports covering all aspects of Community Server (Blogs, Forums, Photos, Files, and more)
  • Displays many reports using interactive Flash graphs
  • Includes many “Top <x>” style reports, as well as the ability to drill-down and see the full details of the report
  • Allows users to export any report/data into CSV/Excel format
  • Allows users to filter data based on given date ranges
  • Simple tasks to handle migrating and crunching of Community Server data
  • Migration tasks can be easily segregated by application type and function
  • Data can be migrated both incrementally or completely
  • Extendable, flexible reporting framework! Completely customizable
  • Ability to create new reports either programmatically via the API, or declaratively in configuration files
  • Customizable report layouts allow users to easily change the way reports are displayed or shown
  • Full web-based management of reports (adding, editing, disabling/enabling, etc…)

Chart from Blog Popularity Report (weblogs.asp.net for past 3 months)

 

Report from Blog Popularity (weblogs.asp.net for past 3 months):

Below are some of the reports that are supported:

Blogs:

  • Average Posts Per Blog
  • Blog Comments
  • Blogging Frequency per Blog
  • Blog Posts Created
  • Blog Views
  • Highest Rated Blogs
  • Most Popular Blogs
  • Posts Per Category
  • Rss Subscriptions Per Blog
  • Total Posts

Forums:

  • Most Replied To Topics
  • New Users
  • New Forum Posts
  • Average Post to User Ratio
  • Posts by Language / Country
  • Most Active Forums
  • Average Post Frequency
  • Active and Inactive Users
  • Inactive Threads
  • Moderation Statistics

The framework also make it really easy to add new reports either as stand-alone assemblies (for more advanced reports) or expressed through simple XML syntax that can just be plugged in.

Want to receive more great content like this for free?

Subscribe to our newsletter to get best practices, recommendations, and tips for digital marketers