# Category / topic subscription stats as means to identify the most valuable, attractive or non-interesting content **URL:** \ **Category:** Feature\ **Created:** [2016年一月1日 06:21 UTC](https://meta.discourse.org/t/category-topic-subscription-stats-as-means-to-identify-the-most-valuable-attractive-or-non-interesting-content/37350 "2016-01-01T06:21:11Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![meglio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/meglio/32/71444_2.png) [@meglio](https://meta.discourse.org/u/meglio)\ **Post date:** [2016年一月1日 06:21 UTC](https://meta.discourse.org/t/category-topic-subscription-stats-as-means-to-identify-the-most-valuable-attractive-or-non-interesting-content/37350/1 "2016-01-01T06:21:11Z")
May I propose the following: add category / topic subscription stats for admins. This would help to identify which content attracts the most on your Discourse instance. The proposed spect is to let admin: - view the categories list by most subscriptions, depending on subscription type (muted, normal, watch etc). - the same for topics, either global or in a particular category - include/exclude mods from the stats (we usually subscribe to every single category in our forums) - view for various date ranges: week, month, quarter, year, all time - show dynamics to answer the following question - which category or topic is gaining/losing popularity in terms of subscriptions number the most this week/month/etc ---
**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\ **Post date:** [2016年一月1日 06:39 UTC](https://meta.discourse.org/t/category-topic-subscription-stats-as-means-to-identify-the-most-valuable-attractive-or-non-interesting-content/37350/2 "2016-01-01T06:39:27Z")
You could query this in [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin as needed. ---
**Author:** ![meglio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/meglio/32/71444_2.png) [@meglio](https://meta.discourse.org/u/meglio)\ **Post date:** [2016年一月1日 08:11 UTC](https://meta.discourse.org/t/category-topic-subscription-stats-as-means-to-identify-the-most-valuable-attractive-or-non-interesting-content/37350/3 "2016-01-01T08:11:10Z")
I suppose the `category_users` table stores what I need. How would I interpret the `notification_level : integer` column? ---
**Author:** ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)\ **Post date:** [2016年一月16日 00:16 UTC](https://meta.discourse.org/t/category-topic-subscription-stats-as-means-to-identify-the-most-valuable-attractive-or-non-interesting-content/37350/4 "2016-01-16T00:16:02Z")
0 = muted, 1 = regular, 2 = tracking, 3 = watching. ---
**Author:** ![meglio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/meglio/32/71444_2.png) [@meglio](https://meta.discourse.org/u/meglio)\ **Post date:** [2016年一月16日 01:23 UTC](https://meta.discourse.org/t/category-topic-subscription-stats-as-means-to-identify-the-most-valuable-attractive-or-non-interesting-content/37350/5 "2016-01-16T01:23:32Z")
Thanks. It would be great if comments were added to all database columns and then shown in the [data explorer](https://meta.discourse.org/t/32566?silent=true). ---
**Author:** ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)\ **Post date:** [2016年一月16日 02:34 UTC](https://meta.discourse.org/t/category-topic-subscription-stats-as-means-to-identify-the-most-valuable-attractive-or-non-interesting-content/37350/6 "2016-01-16T02:34:21Z")
They are in there, they’re supposed to show up when you hover the **i**. The styling is wacked right now, so you can’t actually read the content.