#i am very much not a statisician so if any of these are wildly wrong and my method is incorrect do let me know and i'll clean things up

[mrcowboydeanwinchester]

🌸 Sapphicnatural Statistics Spreadsheet 🌸

link for the spreadsheet here!

hello hello! in may 2024 i completed a university essay studying the subversive shipping conventions of sapphicnatural fanfic in the Sapphicnatural Collection over on AO3, with the thesis that sapphicnatural ships are often rarepairs with little-to-no grounds in canon (e.g: a guest character/one-off character who have never met on screen), conversely to standard fanfic practice. as part of this, i gathered some statistics about the fics in the collection, got slightly carried away with the scope, and made a giant spreadsheet with 6 sheets of various data. with the project over, i thought it would be nice to share it with tumblr in case anyone else finds it helpful or just interesting!! i'm likely going to post the essay that i wrote alongside this in the next few weeks, so give me a shout too if that's something you'd like to see

to pique your interest, the spreadsheet includes:

Notes on methodology and the vocabulary used

Statistics on the popularity of each sapphicnatural ship in the collection and the frequency of characters featured

Analysis on some significiant ship factors: whether the characters have met in canon and how frequently characters re-occured in the show

'Ship potency', a new framework i'm workshopping to quantify how 'viable/strong' a ship is, specifically when measuring the makeup of femslash ships against mlm ships

i've written up some of the key points i found and some extra analysis about them under the cut, so read more if you're interested! <3

Contextual note: there are 129 fanfics in the Sapphicnatural collection.

Top 5 most popular Sapphicnatural ships:

donna/jody (10 fics)

anna/mary (7 fics)

jo/cassie (6 fics)

anna/ruby (5 fics)

kaia/claire (4 fics)

21 unique ships have 3 fics per ship. 24 unique ships have 2 fics per ship, and 52 unique ships have 1 fic per ship. So, only a quarter (25.3% of ships) have more than 3 fics written about them.

Rarepairs (and thus multishipping) are much more frequent in Sapphicnatural fanfiction than across most fandom fanfic collections which often centre around a specific ship

Have the characters met in canon?

Only 34.2% of ships involve two or more characters who have met on-screen in the show, with 59.6% of ships featuring two or more characters who have never met

4 out of the 5 top ships are between characters who met in the show's canon

BUT the most common dynamic is between two characters who could potentially meet in canon (are alive through the same seasons/at the same location (hell/heaven) at the same time) but who never meet in the show

This idea of 'canon potential' is the most exciting space for a lot of sapphicnatural writers, where finding gaps in the existing narrative and placing two similar women together to explore what their relationship could look often seems to be more inviting than those established on-screen

What is the spread of side/guest/one-off characters in ships?

A third (32.9%) of ships are made-up side/guest character

None of the characters featured are main characters (as none of the women spn characters can be realistically classed as 'main characters' lolol)

17 ships feature at least one one-off character, with 3 being one-off/one-off

Sapphicnatural fanfiction has a unique appreciation for reinforcing attention to minor characters, often as part of a feminist agenda to restore their agency

How frequently are individual characters featured?

Jo Harvelle is the most popular character in the sapphicnatural collection, involved in 15 unique ships across 34 fics. So, over a quarter (26.4%) of the fanfics in the collection feature Jo

Author's note: honestly this could be my individual impact on the collection as a jogirl oops

Mary Winchester is involved in 14 unique ships across 25 ships, so both Jo and Mary are significantly multi-shipped. Mary features twice across the top 5 ships

Sapphicnatural writers often write in service of a particular character rather than a ship - ie. exploring Jo's sapphic identity is more important than who her relationship is with

Charlie, Anna, Ruby, Claire, and Bela are the other characters involved in more than 10 fics each across the collection

Ship potency:

I explain this concept more on the sheet itself, but I essentially assign numerical values to whether a ship is (possible in) canon or not, how frequently characters re-occur in the show, and how popular a ship is respective to the fandom (as sapphicnatural is small, donna/jody is popular with 10 fics, for example)

This is to gain a measure of how 'strong' a ship is, assuming that a standard mlm ship will rank highly in most of these criteria (control variable of destiel ranks 29.5/30, whereas the average potency sum for a sapphicnatural ship is 11.8)

Across the top 5 ships, the average potency sum is 20.9

4/5 of the most popular sapphicnatural ships are in the top 5 for ship potency, with donna/jody, anna/mary, kaia/claire and anna/ruby having strong canon foundations and so high potency ratings.

jo/cassie is irregular as the third most popular ship because they only rank 14th for ship potency, as the pairing have not met on-screen in canon, and features a one-off character

Ships with higher potency sums do tend to be slightly more popular, but there isn't a clear pattern among any of the ships. I'd like to do some more work with this to fine-tune the system

Wordcount, kudos, and hits:

Average wordcount of a fic is 3,511 words. This fits with my other working theory (links to my post about my history essay on women's fiction through the feminist waves) that sapphicnatural writers utilise short stories and one-shots to most succesfully explore sapphic identities

Average kudos is 48, with a median of 13

Average hits is 353, with a median of 122

So: sapphicnatural fanfics receive a fairly low level of interaction, especially when compared to the mlm ships in the Supernatural fandom (destiel, etc). This is in-line with most fandoms and femslash as a whole - a small, dedicated community are reading and writing sapphicnatural

I didn't explore much here, but it would be interesting to go into further depth anout how many fics in the collection are written by different authors, etc

and that's it from me! if you've made it down here, you're an absolute gem and thank you for sticking with me! hope you foundd it as interesting to read through as i did to write up - and that you give the spreadsheet a nosey too if you fancy <3