I've finally updated all my Fimfiction spreadsheets!

If you don't know what I'm talking about, check out this video.

Here's the updated basic Fimfiction statistics spreadsheet:

https://docs.google.com/spreadsheets/d/1Wsj45jwHofcWpow4hXgJa3-BSOQcD1FnKSEcWREKgXA/edit#gid=0

Scroll to the right to get the current numbers. Worth noting is that Fimfiction no longer shows a rating for stories with less than 10 likes/dislikes. This has resulted in 35% of the stories on the site with no visible rating.

Another thing of note is that the average amount of words being added per day has been generally decreasing.



But still, 800k words added per day is still staggering to the point that no human can read all that in one lifetime, so please don't complain that the fandom is dying.

While words added per day has gone down, views for each story have increased.



Of the new genres which were added in the last year, Drama has come out on top as the most popular.



But the new genres are dwarfed in comparison to the existing genres.



(The legend of this graph is ordered from highest percentage to lowest)

Up next is the character spreadsheet. (I don't have access to the character tags, which would be more accurate, instead I parsed through the descriptions of every story on Fimfiction to see what names popped up the most often).

https://docs.google.com/spreadsheets/d/1-tB--cReIT_cLE1mOtGfbs08ZNFuGeQaDGQgArcYmgc/edit#gid=0

(There's three sheets in there, the first is sorted by amount, the next is percentage, and the final one is a ranking that notes any changes over the updates in a character's popularity.)

The top three most popular characters to write about are still:

1. Twilight Sparkle

2. Celestia

3. Rainbow Dash

The next spreadsheet is for story data. If you wanted to sort by most liked/disliked story on the site, this would be the place to do it. (Be warned though, this is a large spreadsheet that might take a while to load)

https://docs.google.com/spreadsheets/d/1QLePdTstrxeMhPlKUtGcFRuyhAujbN7xXPcpUsw2o_g/edit#gid=778242561

As always you can fiddle around with the data by using filters to select categories you want to see.



As well as sort the stories by most viewed/liked/disliked.



Remember, that if a story has a like/dislike count of -1, in reality it's rating is still hidden.

And the last spreadsheet is for Author data. This one is by far the most massive as it contains all the information I could scrape using Fimfictions normal API about authors.

https://docs.google.com/spreadsheets/d/16ZWp3OWY0XgNg3nNt7R4Npfec1QEKuqjMqEcgCt0tbI/edit?usp=sharing

That spreadsheet is currently sorted by most words written.

Funnily enough #5 shortskirtsandexplosions and #6 Imploding Colon, are in fact the same person, making him the most prolific author on the site.

Thank you, as always, to the Fimfic archive, the staff of Fimfiction itself for having an API, and to all you amazing writers and readers!