Various Interesting Dashboards about Danbooru

Posted under General

This will only be interesting to a subset of builders and data autists, but I already posted these on discord so might as well post them here too.

Over the past year or so I made some dashboards to display real time statistics about Danbooru that can't be covered by our reports:


https://danbooruanalytics.nonamethanks.xyz - Top Searches from Cloudflare.

This is heavily sampled, and the values displayed there should only be considered relative values, not the real amount of hits we get.
The most interesting part for me is looking at posts that go viral every once in a while. The old posts table's usually empty until they actually do go viral. You can set the time range to 7 days to see a few of them.
For example, for some reason some ero guro posts (post #9459475 & co) are currently getting a massive amount of views. Why? Who the hell knows.
Searches that have individual user details are filtered out from this.
Don't set this to a range larger than 7 days because it'll just crap out on you.


https://danboorustats.nonamethanks.xyz - Historical Data

This is mostly to monitor the historical state of pending posts/BURs, which is not something the main site can record. I like to go back to a few months ago and see how the average amount of posts in the queue changes. It's a good way to tell when we need a new batch of approvers.


https://promotions.nonamethanks.xyz - Promotion Candidates

This is the final evolution/consolidation of various bots and interfaces I've developed ever since I became mod. It's a dashboard of all users that can be considered for promotion to builder/contributor. I still need to add wiki/artist edits and forum posts to this

I always wanted to know about total data size of danbooru, so thanks for your analytics

An off-topic tech question: where are you storing the media assets? 33TiB is not a small number for a site without financial income

nonamethanks said:

https://promotions.nonamethanks.xyz - Promotion Candidates

This is the final evolution/consolidation of various bots and interfaces I've developed ever since I became mod. It's a dashboard of all users that can be considered for promotion to builder/contributor. I still need to add wiki/artist edits and forum posts to this

Oh woah. Was I on that front page not even 7 days ago, I wonder now?

These are all really cool stats and analytics. Thank you for sharing, it's good to see what's going on outside my own workspace on this site.

There appear to be 16 deactivated Builders and 44 deactivated Contributors. There are no deactivated Approvers, but that's because they get auto demoted if they're inactive for too long. You'd need to go through the Contributors individually to see which ones used to be Approvers.

blindVigil said:

There appear to be 16 deactivated Builders and 44 deactivated Contributors. There are no deactivated Approvers, but that's because they get auto demoted if they're inactive for too long. You'd need to go through the Contributors individually to see which ones used to be Approvers.

thank you both for your help, this is exactly what I wanted to know. did you count the deleted users manually, or other method?

using the data provided, and assuming it to be true:

440 builders + 919 contributors = 1359 promoted purple users

16 + 44 = 60 of them are deleted users

so the 'suicide ratio' is ~4.42%

this is staggeringly low, I was thinking it would be between 15-20%

here is a feature request then: in the users page, it would be nice to add another dropdown box (like 'level' and 'order') but with the name 'deleted', if toggled 'yes' it would allow to filter deleted builders & contributors e.g. user #499293

Iroshi2020qsound said:

here is a feature request then: in the users page, it would be nice to add another dropdown box (like 'level' and 'order') but with the name 'deleted', if toggled 'yes' it would allow to filter deleted builders & contributors e.g. user #499293

You can already filter for deleted users like this.

You can filter most pages on this site by their attributes. Users have a is_deleted field, so you can put search[is_deleted]=True in the url to filter by that. Since levels are numeric, you can use search[level]=>=32 (32 is the builder level number) to filter by all users at builder or above.

And since pages on this site have a standard amount of 20 entries, you can just look at the number of pages in a search and add the amount of results on the last page to get a precise count.

nonamethanks said:

You can already filter for deleted users like this.

You can filter most pages on this site by their attributes. Users have a is_deleted field, so you can put search[is_deleted]=True in the url to filter by that. Since levels are numeric, you can use search[level]=>=32 (32 is the builder level number) to filter by all users at builder or above.

And since pages on this site have a standard amount of 20 entries, you can just look at the number of pages in a search and add the amount of results on the last page to get a precise count.

many thanks chief, I was expecting your response
it's no doubt great that it is already possible to filter by deleted users in the URL field, however it is not as user-friendly as would be a dropdown box

so the number of deletions have been found to be lower, updating as follows:

15 deleted builders43 deleted contributors58 total purple deleted

440 builders + 919 contributors = 1359 promoted purple users

therefore, as of 19 June 2025, the 'suicide rate' of promoted users is ~4.27%

interesting data, I wonder how the value will change in 1 year from today, hopefully I will remember to return & check again then

1