Tags: how can admin see who is following what tags?

[brendand (Brendan)]

We use tags and are wondering how we can see which tags our members have chosen to follow (whether “watching”, “following”, etc.) specific tags?

We are looking to bulk delete some tags but first want to understand how many of our users are potentially following / care about each tag.

Thanks for your insight!

Brendan

[ChrisBeach (Chris)]

A data explorer query will do it:

SELECT 
    name, 
    user_id, 
    notification_level 
FROM tag_users tu 
    JOIN tags t ON tu.tag_id = t.id

[SidV]

Excellent @ChrisBeach !
I added your query to the list.

A doubt here, I see that are four notification levels, can you tell me the levels?
I mean, watching = 1? or 2 level? Muted = 4?

[neil (Neil Lalonde)]

The notification levels are listed here:

lib/notification_levels.rb

[Drew-ART (Drew)]

이 항목들이 통계 페이지에 추가되면 좋을 것 같습니다. 사용자가 사이트를 어떻게 활용하는지 최적화하는 데 도움이 되는 더 많은 옵션을 제공할 수 있습니다.