#shipping data

This data is accurate as of 8th/9th March 2025 and has been done over two days due to the length of time it takes to create and frequent AO3 errors over the past 48 hours. Errors aside, it is likely will continue doing this in future as sleep before 2am sounds great actually.

Last month adding Sublime to the roster meant having to redo a big chunk of the formula that form the spreadsheet due to multiple breakages. Upside is this led to them being further refined and less chances of errors. Also added a specific row for a freeze pane to make inputting data easier.

At the time of typing XY's tags are still pretty broken and any Sublime variants are very hit and miss whether they pick up correctly. The latter was expected and will likely improve with time.

In general the numbers have been very erratic. There's been lots of single losses which generally tracks with deletions/removals and also far bigger ones? While one instance can be put down to a possible keyboard slip as the numbers were next to one another, others not so much and it is unknown what caused them. There has been a big jump in Sabrina/Zoé which looking at the page can be put down to Femslash February doing their bit. Otherwise gains have been minor bar expected increases in the 'big' ships.

Also discovered another weird tag instance where "Centi Couffaine" went to a tag for Sentibug? Mean one way to discover they have their own tag.

Every relationship tag is assumed to have been applied correctly.

The key for the first part of the spreadsheet is as follows:

Y (Green) - At least 20 entries

P (Yellow) - Less than 20 entries

N (Red) - Zero entries

The colours are primarily designed for quick glance usage.

The key for the second part of the spreadsheet is as follows:

Green has 0 entries and is checked monthly

Blue has 1-10 entries

Light yellow has 11-14 entries

Saturated yellow has 15-20 entries and is checked monthly

Light grey has 21-50 entries

Medium grey has 51-100 entries

Black has more than 100 entries

Black entries have the data input at the time of the spreadsheet update and are hidden purely so they are checked manually and auto pilot brain does not do it more often than required.

As of 8th/9th March 2025, these were all the pairings that have more than 1K works under their tags:

Adrien/Marienette - 38652 Alya/Nino - 7808 Luka/Marinette - 4349 Marc/Nathaniel - 2405 Juleka/Rose - 2375 Adrien/Luka - 1340 Adrien/Kagami - 1296 Kagami/Marinette - 1083

Marc/Nathaniel has overtaken Juleka/Rose from the last round up.

Honourable mention to the next closest to the 1k mark/over 900:

Ivan/Mylène - 967

After this there is one ship at 851, another at 776 and 712, then it drops to 525, 514, 492 and 473 respectively. From this point the rest are much closer to 300 or less. In a random fun tidbit, Kim/Marinette had exactly 300 entries when this data was compiled.

This data is accurate as of 23rd July 2024. Every relationship tag is assumed to have been applied correctly. It should be noted that Conrad is currently tagged as "Shannon Longhannon's girlfriend" so that's something to have a crack at fixing.

The key for the first part of the spreadsheet is as follows:

Y (Green) - At least 20 entries

P (Yellow) - Less than 20 entries

N (Red) - Zero entries

The colours are primarily designed for quick glance usage.

The key for the second part of the spreadsheet is as follows:

Green has 0 entries and is checked monthly

Blue has 1-10 entries

Light yellow has 11-14 entries

Saturated yellow has 15-20 entries and is checked monthly

Light grey has 21-50 entries

Medium grey has 51-100 entries

Black has more than 100 entries

Black entries have the data input at the time of the spreadsheet update and are hidden purely so they are checked manually and auto pilot brain does not do it more often than required.

This data is accurate as of 9th July 2024. Every relationship tag is assumed to have been applied correctly. Félix/Marinette has a surprising increase in numbers which may be down to a large spike in uploads (Not impossible) though there may also have been continued issues with the surname change being resolved. There has been a notable decrease in the odd tags going down by one or two, flipping some ships back to red in some cases, which are suspected to be due to deletions or archiving.

There was a minor formula issue that is unknown when it occurred so it is being noted here. The Mireille/Alya cell above the grey line in the numbered spreadsheet now correctly looks where it's supposed to for ensuring the numbers match. Very likely this was caused by a software quirk which if you know, you know.

The key for the first part of the spreadsheet is as follows:

Y (Green) - At least 20 entries

P (Yellow) - Less than 20 entries

N (Red) - Zero entries

The colours are primarily designed for quick glance usage.

The key for the second part of the spreadsheet is as follows:

Green has 0 entries and is checked monthly

Blue has 1-10 entries

Light yellow has 11-14 entries

Saturated yellow has 15-20 entries and is checked monthly

Light grey has 21-50 entries

Medium grey has 51-100 entries

Black has more than 100 entries

Black entries have the data input at the time of the spreadsheet update and are hidden purely so they are checked manually and auto pilot brain does not do it more often than required.

Please excuse the screenshot clipping the highlighted cell at the side there.

As of 9th July 2024, these were all the pairings that have more than 1K works under their tags:

Adrien/Marinette - 37203 Alya/Nino - 7545 Luka/Marinette - 4113 Juleka/Rose - 2238 Marc/Nathaniel - 2229 Adrien/Luka - 1246 Adrien/Kagami - 1236 Kagami/Marinette - 1015

Honourable mention to the next closest to the 1k mark:

Ivan/Mylène - 923

After this there is one ship at 810, another at 744 before a big drop off to sub 500.

In addition to the above, fun stats! The way AO3 treats character tags for the Miraculous fandom means alternate versions of characters such as Chat Blanc and Cat Walker point to Adrien. This means it cannot be searched separately unless it's a non-character tag addition. This has occurred with Alternate Alya, however it has not occurred for the other three introduced with Miraculous Paris. As such by using the below format specifically due to AO3 restrictions to ensure they correctly flag:

Alternate Marinette Dupain-Cheng | Shadybug Alternate Adrien Agreste | Claw Noir Alternate Gabriel Agreste | Betterfly

You can find them.

At the time of typing:

Shadybug/Claw Noir - 100 entries Chat Noir/Shadybug - 6 entries Ladybug/Claw Noir - 1 entry Claw Noir/Alternate Nino - 1 entry

While this data is produced as neutrally as possible it should be said the ever increasing homogenisation of the fandom into lovesquare or bust is proving a concern. While shipping tags are presumed to have been used in good faith, many are not resulting in even canon and "canon" pairings not having as many works as it might appear. If you happen to branch out a bit and enjoy a work, do let the author know! Kudos and comments are a scarcity the further away you go and writing for the void gets exhausting after a while. You never know, while one ship might not click with you you might find one you never thought about before that you quite enjoy.

This data is accurate as of 9th/10th November 2024 and has been done over two days due to the length of time it takes to create and real life factors. Every relationship tag is assumed to have been applied correctly. As the poll dictated, XY, Fei Wu and Jessica Keynes have been added to the check list. Hopefully the numbers will prove interesting.

Two strange tagging issues have been noticed during this update which are:

There is one Kim/Fei fic which for some reason when you click the specific ship tag it says Master Fu. Clearly some weirdness is going on there and whatever it is is prevented the drop down option appearing.

XY's character tags are a mess. At a guess several variants have appeared over the years which isn't too surprising but they have not been merged together correctly. This has resulted in some versions simply not working even if the ship tag actually exists. At the moment not entirely sure what to do about that one.

In general numbers have gone down in many rarepairs including one deletion dropping a formerly partial ship back to zero. The only ones bucking this trend are the so-called canon ships. Take that as you will.

The key for the first part of the spreadsheet is as follows:

Y (Green) - At least 20 entries

P (Yellow) - Less than 20 entries

N (Red) - Zero entries

The colours are primarily designed for quick glance usage.

The key for the second part of the spreadsheet is as follows:

Green has 0 entries and is checked monthly

Blue has 1-10 entries

Light yellow has 11-14 entries

Saturated yellow has 15-20 entries and is checked monthly

Light grey has 21-50 entries

Medium grey has 51-100 entries

Black has more than 100 entries

Black entries have the data input at the time of the spreadsheet update and are hidden purely so they are checked manually and auto pilot brain does not do it more often than required.

Please excuse the screenshot clipping the highlighted cell at the side there.

As of 9th/10th November 2024, these were all the pairings that have more than 1K works under their tags:

Adrien/Marienette - 37948 Alya/Nino - 7683 Luka/Marinette - 4234 Juleka/Rose - 2316 Marc/Nathaniel - 2300 Adrien/Luka - 1296 Adrien/Kagami - 1267 Kagami/Marinette - 1043

Honourable mention to the next closest to the 1k mark:

Ivan/Mylène - 954

After this there is one ship at 846, another at 759, one hilariously at 666 when checked yesterday then it drops to 521, 504 and 493 respectively. After this point the rest are much closer to 300 or less.

Checking in with the canon alternatives they do seem to have found a small niche with 20 more Shadybug/Claw Noir than four months ago. Otherwise it appears to have stagnated so longer term trends will be interesting to see.

Shadybug/Claw Noir - 120 entries Chat Noir/Shadybug - 7 entries Ladybug/Claw Noir - 1 entry Claw Noir/Alternate Nino - 1 entry

This year seems to be flying because it's time for the four monthly update on the fandom's rarepairs! Due to adding more criteria and additional juggling it took a lot longer to finish. Still, data is data right? Next month will also be one entire year of this being produced! All the more reason to do a few changes.

This data is accurate as of 9th November 2023. Every relationship tag is assumed to have been applied correctly. After several months of shipping tags not being marked as common they suddenly were in the past couple of weeks which was a big help. It also appears that the tagging system works by surname first so for example it will search Marc Anciel/Luka Couffaine whereas Luka Couffaine/Marc Anciel may come up blank despite the tag existing.

Socqueline Wang has been added to the lineup. Due to most of Season 5 having now aired worldwide (It has yet to finish in some countries such as the UK) and how she appears in more than one episode, writers are increasingly including her in their work.

Once again the numbers have been run though some adjustments have been made to allow for a clearer picture of how things are looking.

The updated key is as follows:

Green has 0 entries and is checked monthly Blue has 1-10 entries Light yellow has 11-14 entries Saturated yellow has 15-20 entries and is checked monthly Light grey has 21-50 entries Medium grey has 51-100 entries Black has more than 100 entries

As of 8th November 2023, these were all the pairings that have more than 1K works under their tags:

Adrien/Marinette - 35724 entries Alya/Nino - 7318 entries Marinette/Luka - 3900 entries Juleka/Rose - 2139 entries Marc/Nathaniel - 2121 entries Adrien/Kagami - 1176 entries Adrien/Luka - 1142 entries

Honourable mention as the next closest to the 1k mark:

Kagami/Marinette - 945 entries

Lots to chew on there! Given I stayed up past 1am finishing this up I'ma gonna have a nice chill day.

It's four months since the last Big Check which meant it was once again time to sink several hours into doing the big monthly check of rarepairs! Monthly just check any coming up to 20 and the Nos, the fourth monthly is checking every single Partial so it takes a while.

This data is accurate as of 9th July 2023. Every relationship tag is assumed to have been applied correctly. The Zoé (Miraculous Ladybug) and Zoé Lee tag seem to have finally stopped tripping out in that they don't seem to be treated as entirely separate. Félix Graham de Vanily appears to have officially changed to Félix Fathom though the search system does occasionally trip.

As a bonus while I was doing this I also ran the numbers! As there's no key:

Black boxes have already hit 20 entries and were not included Green has 0 entries Blue has 1-10 entries Pale yellow has 11-14 entries Saturated yellow has 15 or more entries and will be checked for movement each month

As you can see some Partials are only in it with a single entry and usually due to events. Others are very close to joining the ranks of Yes and may well flip soon.

Hey fandom. If you want some raw data based on a shufty in the AO3 Miraculous shipping tags for your writing or maybe even your fanart needs well here you go. Some of the results aren’t surprising at all, Love Square of course will have loads, others that they hadn’t even made a page was very unexpected. Mylène in particular often had a single oneshot created for a rarepair week meaning her numbers are very low despite the Partial flags.

Might need to put this image into it’s own tab because of tumblr squashing screenshots to fit.

Data is accurate as of December 5th.

If you don't know what I'm referring to, it's this which will be getting the monthly check in tomorrow:

Adding a new person or persons seems the best idea which is where the poll comes in! Doing this early allows prep to be done in advance should it be needed :) Choose who you will and whatever wins will be done going forward!