Expand Cut Tags

No cut tags
artemisdart: (fire boots)
I added a few cards to the top of the dashboard for the total number of works, total wordcount, # of ships, and # of challenges. I also added counts for the four different ratings.

Here's the unfiltered version! I can change the date range or filter by ship/challenge to see how the stats and trends change.

If I had more data, I'd be able to report on more things. But I never built in fandom, Archive Warnings, Categories, or tags into the database. So to get those on the dashboard I'd have to make up the gap with a few new tables, most probably. All of those are multi-possible (a single fic can have more than one Fandom, etc.), so I'd have to build bridge tables between Dim_Work and the new tables... it's doable, just something I haven't wanted to take on.



Gosh, it's so pretty.

There are more words hiding in the pre-2023 and post-2026 years -- I have some words slotted into 9999-12-31 because it would take too much time and effort to figure out specifically what chapters of what works they should go into -- so the wordcount total isn't as high as in real life. But it's close enough -- only 10K or so off. In a total of about 1.8 million, that's only half a percent. I'll take it! :)
artemisdart: (math)
I had been lax about updating my little PostGreSQL database with all my kudos and wordcounts posted... for the past 3 or 4 months... but starting on Friday and finishing just now, I managed to catch myself up!

And what's more, I drew inspiration from a Discord conversation about connecting the database to PowerBI, and tackled the problem again. This time, I was able to get it done! So now my database is feeding PowerBI directly, mwahahahahaha! This is very exciting, because the Excel pivot tables and pivot charts I built were lackluster, to put it mildly. I've never liked Excel for this purpose.

(PowerBI has its own issues, too -- don't get me wrong -- but at least it was MADE TO BE a visual dashboard program. Excel was not.)

ANYWAY, check out this sick visual!

Screenshot of dashboard about AO3 Stats


I have this particular viz filtered to only the Star Wars Sequel Trilogy ships. You can see the line -- that's my kudos over time, layered over the columns representing the number of words posted over that same timeframe. Note that the scales for the two facts are wildly out of sync, because I post wordcounts in the thousands and get kudos in the dozens, haha.

I also have the wordcount columns color-coded by ship. You can see the vast blue sea that is all the Gingerpilot words I have posted, versus the others.

The Kudos Total is filtered down to only kudos that were associated with these particular works, so it provides a great comparison. I already knew that my Gingerpilot wordcount had fallen off -- way off -- but this viz really drives that home. Look how small the blue bar is for Qtr 1 2026! I need to do something!!!

I have many other ideas for different vizzes to add to the dashboard... here are a few to kick-start my memory later.

* Top kudos-leavers
* Cluster kudos-leavers into profiles (I bet there's a strong Gingerpilot profile, for instance, but I bet the data will reveal others)
* Named kudos vs. guest kudos by Rating (Explicit works have more guest kudos -- and also, the Anidala fic "Painted On Her Skin" has an insanely high guest kudos ratio for some reason)
* Ships in descending order by rank, with anything under 5 or 6 bucketed into an "Other Ships" bucket
* Wordcount and kudos posted by Rating over time (instead of by ship)
* Trends and forecasts! :D

I'm sure there are a bunch of other things I'm not thinking of. But for now, after having broken through this wall that has stymied me for over a year, I am well pleased and going to bed!
artemisdart: (sunrise)
Today, 2026-02-25, is the three year anniversary of the date I posted my first fanfic!

As of right now, here are my total stats:

User Subscriptions: 117
Kudos: 9,465
Comment Threads: 1,513
Bookmarks: 2,550
Subscriptions: 890
Word Count: 1,814,161
Hits: 178,264

138 works

In 62 fandoms:

click to expand 62 fandoms )

As for the fanfic I first posted, Mission Failed Successfully, here are its stats after three years!

Hits: 10,153
Kudos: 473
Comments: 46
Bookmarks: 165 (79 are public)
Subscriptions: 15

Not bad!

1.8!

Feb. 17th, 2026 08:03 am
artemisdart: (fractal)
With the weekend's progress on my pinch hit for the Five Figure Fanwork Exchange, my total wordcount on AO3 has crested 1.8 million words!

This astounds me. When I started, I thought I'd write a short story or two. But it turns out that I had a lot more to say!

I also used to be very worried about "using up" all my good ideas too soon. I no longer worry about that. There are infinite good ideas.
artemisdart: (hydra)
I updated my relational database fairly recently, including the numbers of words posted over the past few months, and wow, October this year was SO much lower than October 2024! That year, of course, was my Kinktober year, and I posted over 125K that month, which is by far the most I've ever posted in a month.

This October, I only posted 28K. Weak!

Still, if I average October for the past three years, it's 68K each. And if I average out the words posted this year so far by month, it's at 50K a month, even though we're only halfway through November.

A lack of words is not my major problem.
artemisdart: (elephant)
I just stayed up until after 1 AM getting my kudos and wordcount database back into sync! I had been sadly remiss for half of September and all of October, so I had quite the backlog to process, but finally it's all done.

There are a few small discrepancies because my kudos email from 2025-11-09 hasn't dropped yet, and I'm not going to stay up until it does. But once it does, I should be able to true things up... pretty well, at least. Impressive!

I'm thrilled to say that my database now has 4,121 unique users in it!

Progress

Sep. 6th, 2025 10:24 pm
artemisdart: (Garden)
Today I revised my main Smut Wars entry just a bit, improving it (in my opinion!). Could it be better? Certainly, but this is as good as I could get it in the time and energy I had.

I didn't have time to watch anything in preparation for writing Enemies to Lovers. Perhaps tomorrow!

I also posted one of the banked chapters I wrote on Labor Day, for Three and a Half Steps. This chapter had a cameo from one of my Gingerpilot friends; I used her physical appearance, including her glorious hair, to describe this NPC. I can't wait for her to read more about 'her' adventures in future chapters!

With that chapter, I have officially crossed the 1.6 million word mark!
artemisdart: (fractal)
My short, 924-word work from Day 6 of last year's Kinktober challenge has, by far, the greatest proportion of guest users of all my fics, and it's not even close.

It finally hit 100 kudos, and right now, those kudos are 75% guests, and only 25% logged-in users.

I'm still a bit perplexed as to why that is. I can only assume that the Prequel Trilogy crowd is unwilling to put their name on a fic where Padmé is mentally gloating about how she totally got Anakin to bone her through manipulating him, and how she hopes she's pregnant.

Without a way to poll the readers, I guess I'll never really know the whole truth!

Painted On Her Skin

artemisdart: (fire boots)
It's not my all time record, but yesterday's writing stint was quite productive. In addition to chapters 16 and 17 of Three and a Half Steps, which I'm saving to post these next two weekends, I wrote chapter 2 of a treat for Smut Wars that I can't talk about yet. All told, it added up to slightly over 13,000 words!

I hope to finish off my Smut Wars treat tonight or tomorrow.

I'm getting close to 1.6 million words posted!
artemisdart: (Nuts)
I stayed up late to get my relational database up to date. Then I ran a couple of queries to verify for myself that "A Helping Hand" (my Murderbot/Dr. Gurathin fic) really is as hot as I think it is, kudos-wise.

It is! A Helping Hand is currently in second place when it comes to the speed with which it gathered kudos in its first few days. Behold!

#1: What Happens on Peridea, with 115 kudos in its first 3 days (WOWWWW). I stayed up late one night after watching an episode of Ahsoka and knocked this out before 3 AM, and it was quiiiiiite popular. Shin Hati / Sabine Wren shippers are fierce!

#2: A Helping Hand, at 91 kudos in its first 3 days. I finished this at 3 AM the other night and posted without editing, haha.

#3: Bloodlines, with 81 kudos in its first 3 days. I wrote this late one night and posted it around 3 AM, and then it took off big-time immediately. You see, the movie Nimona was trending on Netflix at the time, and there were very few fics for Ambrosius / Ballister. So everyone clicked on mine and left a kudos, despite the fact that I had only posted a chapter or three at the time. (I ended up turning that fic into a monster -- 106K, and I took 9 months to finish it -- and by the end, none of my original 'crew' of readers were still around. Sadness! In hindsight, I probably should have wrapped it up when it was still hot. But I had a lot of story I wanted to get out!)

Hmm, maybe there is a trend here! All three of these were "of the moment," at least somewhat, and all three of them were written in the middle of the night.

The formula for success?!??!?!

My SQL:

SELECT
   "Kudos"."Kudos_work",
   "Work"."Work_name",
   SUM("Kudos"."Kudos_count") AS "Kudos_count"
FROM "Fact_Kudos" AS "Kudos"
   INNER JOIN "Dim_Work" AS "Work" ON "Kudos_work" = "Work_key"
WHERE "Kudos"."Kudos_date"
   < ("Work"."Work_reveal_date" + INTERVAL '3 days')
GROUP BY
   "Kudos"."Kudos_work",
   "Work"."Work_name"
ORDER BY SUM("Kudos"."Kudos_count") desc
artemisdart: (Nuts)
The other day I sat down and outlined my plot idea for Smut Wars, and I'm quite pleased with it!

In other news, my Murderbot fic gathered 62 kudos, 341 hits, and 9 comment threads after slightly more than a day up. What a huge difference from the results when I post for dead / dying fandoms and unknown ships! 😭
artemisdart: (elephant)
Yesterday, the seed of a smutty Murderbot/Gurathin story came to me and I was thinking about it off and on all evening.

Then, I thought of one more thing that could really put it over the top as a good idea.

So after going to bed at 11:30, I pulled out my laptop and started writing.

I churned out 4,664 words of porn without plot, finishing right around 3 am. Then I had to do the tags and end notes and publish it right away. Was finally snuggled down into my pillow around 3:30 am.

This morning it's already gathered 5 comments and 24 kudos after receiving 145 hits.

In contrast, Twice Born, which I worked very hard on and which has a ton of research and love poured into it over several weeks, only has 1 comment and 9 kudos over 129 hits, having been revealed to readers on July 4. And that work has 3 chapters, so the hit count should be slashed down by 2/3 to get the true count of how many people have seen it! And that fic had a built-in audience of all the Hurt/Comfort exchange participants!

Yes, my PWP Murderbot offering has over 3 times the hits, 5 times the comments, and almost 3 times the kudos as Twice Born, after being up for just a few hours... While not being part of any exchange... While not having any research at all put into it.

It really really really REALLY matters what fandom is hot right now. I guess Castlevania Nocturne was probably never all that big and now it's been over for several years.

To clarify: I don't write for kudos. I write when I see a story that no one else has written yet. THAT SAID, there's a huge difference between writing for no reaction and writing for an appreciative audience that wants more of what I'm brewing up.
artemisdart: (fractal)
This afternoon I posted the first chapter of something new, and in so doing, I finally hit the milestone of 1,500,000 words!

(And yes, I did deliberately ensure that my overall wordcount came out exactly at 1.5 million, by writing a chapter of exactly 4,991 words, haha!)

I'm happy about finally hitting the milestone, of course. It's not quite a month after my 50th birthday, which was my original goal -- but less than a month off is close enough!

However, by posting this chapter, I've put myself in the position of having 5 WIPs on AO3 at the same time. That's too many. I don't like having this many WIPs at once.

I think I'll try to hit Uncage Me seriously over the course of the next week. If I could finish that off, finally, I'd only have WIPs that include Armitage Hux, and that seems nice. 😁
artemisdart: (math)
As of this morning, there are 800 separate subscriptions to works of mine! Plus 85 subscriptions to me as a user -- each and every one of which I treasure. It's humbling to think that eighty-five different people have all independently decided that whenever I post ANYTHING, they want to know. Wow.

Here are the 55 works of mine with subscriptions (out of 112 works total), and how many each one has. Four of them are unfinished.

Unfinished? Subscriptions Title
X 149 Uncage Me
138 Bloodlines
96 Pocket Too Deep for Play
46 Stays on Peridea
45 What Happens on Peridea
29 Key Change
29 Not Out Yet
X 27 Three and a Half Steps
X 25 Cat on a Plasteel Roof
24 Hux's Special Cultural Envoy
24 Spanks For The Memories
14 Mission Failed Sucessfully
14 Blow the Man Down
13 Liquor is Quicker
13 #lifegoals
11 Hard Reset
10 Snake Eyes
9 Left in a Lyft
8 Dotted Lines
X 7 Six of a Kind
6 So Figging Good
6 The Hothouse
5 Falling for His Rival
4 The Real Deal
4 Tell me why can't it be true
3 Hammer Time
3 Sunny Skies with Extreme Turbulence
3 Wordplay
3 One Hundred Heaping Helpings
2 Okay With It
2 Internal Conflicts
2 Sharp as a Knife
2 Curiouser and Curiouser
2 Feast of Innocents
2 Body of Knowledge
2 Non Sum Dignus
1 The Value of a Man's Tongue
1 A Shortage of Priests
1 How the Light Gets In
1 Tipping the Scales
1 Rise up and Take the Power Back
1 Good Things Come in Threes
1 The Sweetness of Honey
1 Painted on Her Skin
1 The Ritual of Scattering Seed
1 One Less Thing to Worry About
1 Best Girl
1 Yet My Mouth Waters Still
1 Sticks and Stones
1 Between Alpha Shifts
1 The Fool
1 Flattery Will Get You Nowhere
1 Up Close and Personal
1 The Blending of Flour with Salt

There's no way to know which user subscribed to which work, although I can guess that a lot of my fellow Gingerpilot enjoyers may be subscribed to the two Gingerpilot WIPs I have at the moment.

Subscriptions aren't something I pay particularly close attention to. I don't track them in my database, because I'd have to harvest those numbers manually at regular intervals -- there's no email that notifies me about them -- and I don't want to take on the extra work. Still, a nice round number like 800 deserves at least a post about it. :)

50!

Jun. 22nd, 2025 09:05 am
artemisdart: (fire boots)
Today is my 50th birthday!

I didn't meet the goal of posting 1.5 million words on AO3 by today. My total is currently 1,477,690, which is 98.5% of the way there.

If I hadn't been away from home for the past 11 days I probably could have done it, but I was, so I couldn't. But that's fine; it was an arbitrary goal in the first place!

Today I'm flying from my vacation to a business conference, so I'm still not home yet. Soon I'll be reunited with my personal laptop and the Scrivener files on it... soon!!!
artemisdart: (math)
I was curious about how many guest kudos I receive versus attributed kudos.

Overall, the ratio is 2,388 / 6,817, or 35% guest kudos.

There are some works that fall far outside this norm, though. I've been noticing for months that "Painted on Her Skin," a sub-1K word work for the Anakin Skywalker / Padme Amidala ship, has a much higher ratio of guest kudos than other works.

Well, I just did the math from querying my relational database, and I was right! "Painted on Her Skin" is the highest, at a whopping 70.97% guest kudos and only 29.03% attributed kudos. I have no idea why! It's not even that explicit -- it's just Padme looking at the marks that Anakin left on her skin last night and feeling pretty damn smug about it.

I wonder if the Prequel Trilogy fandom is more shy about leaving their names on more explicit works? I'm a bit mystified about why this fic is so out of proportion in comparison to many of my other fics.

My only other idea is that maybe, people are more shy about leaving their names on works that are Non-Con in one way or another. "Painted on Her Skin" is pretty clear that Padme entrapped Anakin into doing what he did. So, he didn't really consent "as such" -- not with his unclouded, rational mind. Maybe people don't want to leave their names on that.

Fueling that theory is the fact that my four highest-ratio guest-kudos works are ALL non-con or dub-con:

Painted on Her Skin - 79.03% - Pretty safe to say that this is dub-con
Best Girl - 60.87% - Definitely non-con
The Blending of Flour with Salt - 60%: Non-con, although everyone ends up enjoying it. Note that this fic only has 5 kudos total, so it's not really fair to make a note of its ratio
The Ritual of Scattering Seed - 60% - Filthy explicit non-con

Or maybe it's specific to Non-Con & Dub-Con that results in pregnancy? 3 out of those 4 fics are in that category...

It's interesting to spin out theories, but in the end, I will probably never really know the whole truth.
artemisdart: (Garden)
I queried my database to find the top kudos-leavers on my fics, and here they are!

Coming in at #1 is the amazing Kiayla, who has left kudos on 48 of my 105 works, or 46% of them! I originally found Kiayla's work in the Naruto fandom a couple of years back and left her several kudos and comments on some of her stuff in the KakaIru ship, and I guess she followed me back, haha. But she doesn't kudos only my KakaIru fics -- her taste is more eclectic. That's great, because so is mine!

Two users are currently tied for second place -- Annvian and yongsanhotguy99, each at 28 kudos. They are both primarily interested in my Gingerpilot fics, of which I have written 26, and then they've branched out a bit more. Annvian left kudos on those twenty-six, and also on my silly piece of Poe Dameron 'art,' "Vote Poe Dameron!", and one of my original works, "How the Light Gets In." For their part, yongsanhotguy99 left kudos on those twenty-six, and also on my two Kylux fics, "Sharp as a Knife" and "Upper Hand."

Two users tied for third place -- sfvamp and irrationalgame, at 20 kudos each. I'm Discord friends with irrationalgame, who loves Gingerpilot probably even more than I do (and that's saying something!). Her boundless enthusiasm for generating new ideas has sparked inspiration in me more than once! We're in a Discord server together that seems to have started out as mostly about Kylux, but that also has a dedicated Gingerpilot channel, and other related content. It's extremely active, with multiple posts across multiple channels every day, and I really feel that I have made some friends there!

Next up is UtopiaPlanitia at 18 kudos, and then Saklani and MaudeZbornak, both at 17. All three of those people are friends through a different Discord server that's mostly about Gingerpilot. We have exchanged fics with each other, and sometimes, even physical cards and small gifts mailed to each other's homes for Christmas! It's pretty great to "know" people around the world through fandom. Sadly, that server seems to be winding down. People post less and less frequently. I keep hoping that it will revitalize, but at this point, far more activity happens on the first Discord server.

I deeply appreciate everyone who has left me a kudos, comment, bookmark, and/or subscription. I don't write "for" these tokens of appreciation, but gosh darn it seeing kudos and comments come in is VERY motivational for me to want to write more. If I were in a vacuum, writing just for my own self with no one else's feedback, I don't think I could have produced a fraction of my real-life output.

Kudos and comments (especially comments) really are writing fuel! :)
artemisdart: (Garden)
On Reddit earlier today I came across a disgruntled young person (they said they were young, I'm not assuming) who is very cast down that their original work is attracting almost zero attention on AO3.

I took a look at their linked fic, and found that it's in an existing fandom, but uses only Original Characters. That's a really tough combination, which I told them.

Similar works that I've posted attract about 0.05504 kudos per day.

Original-character works I've posted that were for challenges -- where there's a bit of a built-in audience; your gift recipient, if no one else -- attract about 0.161109 kudos per day, or about three times as many.

And works I've posted with known ships in known fandoms attract about 0.261748 kudos per day, or almost five times as many.

Keep in mind that's counting a bunch of unpopular fics of mine -- small ships, tiny fandoms, or just things no one wanted to read. The ten fics I've written that are the most popular all have well-known ships. They attract an average of 0.577138 kudos per day, which is over ten times as many as the Original-Character fics I've written.

People search for ships or genres they want to read. They're probably not going to randomly search for your Original-Character fic, sadly. And that's especially true if the Original-Character work you posted is your first work. In my case, I posted works for some relatively popular ships early on and attracted a few subscribers that way, and some of them are willing to give my original stuff a shot, too.

That's one reason I was so surprised to get a bunch of enthusiastic comments on Tournament of Dragons, and why I assumed they must have been from my gift recipient. Because who would randomly find that fic without knowing about me first? I was so surprised!

From looking at that reader's bookmarks, I got the feeling that they're trawling for ancient Rome and/or ancient China fics, which is probably how they found me -- which shows the true power of tagging. Without those tags, I never would have attracted that reader.
artemisdart: (elephant)
I'll be turning 50 in about 11 weeks. It just occurred to me that if I focus, I might just be able to hit 1.5 million words posted on AO3 by that deadline.

My current wordcount: 1,381,973

That's a difference of 118,027, or 10,729 words a week over 11 weeks. That's a lot.

I've put out that much in the past, it's true -- although not week after week for 11 weeks in a row.

Since all of these numbers and deadlines are merely arbitrary, I've decided not to attempt this as an overt goal. Of course, if it happens, that would be pretty cool. But no one is forcing me to write almost 11K words a week. That's probably 3 good solid sessions of writing time each and every week, and I can usually only manage 1 or 2, because I have other real life responsibilities to take care of, not just writing!
artemisdart: (math)
Sometimes I tinker around with the SQL in my little relational database to see if I can solve different problems. The other night, it occurred to me that it would be nice to know what calendar date I hit different milestones in my kudos counts -- 1,000, 2,000, and so on.

After an hour or so of messing around with SQL, I got this to work -- but only for one total at a time. So, if I want to know the different dates I hit multiple milestones, I will have to run it separately, one for each. Curses!

Still, this is pretty cool, and way better than anything AO3 has to offer in its reporting.

Here's the snippet:

-- Cumulative sums using nested subqueries
WITH "Pool" AS (
 WITH "Cumulative" AS (
   SELECT
    "K1"."Kudos_date",
    SUM("K2"."Kudos_count") AS "Cumulative_Kudos"
   FROM "Fact_Kudos" AS "K1"
    INNER JOIN "Fact_Kudos" AS "K2"
   ON "K1"."Kudos_date" >= "K2"."Kudos_date"
   GROUP BY
     "K1"."Kudos_date"
   ORDER BY
     "K1"."Kudos_date"
   )
  SELECT "Cumulative"."Kudos_date",
  (SELECT SUM("K2"."Kudos_count")
     FROM "Fact_Kudos" AS "K2"
     WHERE "Cumulative"."Kudos_date" >= "K2"."Kudos_date") AS "cumulative_consumption"
  FROM
     "Cumulative"
  ORDER BY
     "Cumulative"."Kudos_date"
)
SELECT MIN("Pool"."Kudos_date")
FROM
   "Pool"
WHERE
   "Pool"."cumulative_consumption" >= '6000'
GROUP BY
   "Pool"."Kudos_date"
ORDER BY
   "Pool"."Kudos_date"
LIMIT 1;

And here are my dates!

Kudos TotalDate
02023-02-25
1,0002023-08-17
2,0002023-12-12
3,0002024-06-20
4,0002024-10-16
5,0002024-12-21
6,0002025-03-12

Profile

artemisdart: (Default)
ArtemisDart

March 2026

S M T W T F S
123 45 67
8 9 10 11121314
15161718192021
22232425262728
293031    

Most Popular Tags

Syndicate

RSS Atom

Style Credit

Page generated Mar. 11th, 2026 05:40 pm
Powered by Dreamwidth Studios