More missing kudos emails
Feb. 13th, 2025 09:27 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
artemisdartLast night I was feeling extremely uncreative, so I decided to catch up on logging kudos into my relational database.
Turns out that I was 86 kudos off, and missing 7 emails! Apparently AO3 just didn't send out any kudos emails on January 25, 29-31, and February 1-3.
Annoying! BUT, here is where the genius of the database can shine. Knowing the differences in counts, the usernames that I have already logged, and the guest kudos count for each fic, I can figure out which usernames on AO3 are "new" and log them, as well as any guest kudos. It's true I won't know exactly which of the missing dates these kudos happened on, but I'll distribute them evenly and it won't be a big deal at all.
That way my stats will still be up to date, and I can answer important questions like whether my Explicit fics get more guest kudos (they really do) and how each of my Kinktober fics performed over their first 7 days...
Turns out that I was 86 kudos off, and missing 7 emails! Apparently AO3 just didn't send out any kudos emails on January 25, 29-31, and February 1-3.
Annoying! BUT, here is where the genius of the database can shine. Knowing the differences in counts, the usernames that I have already logged, and the guest kudos count for each fic, I can figure out which usernames on AO3 are "new" and log them, as well as any guest kudos. It's true I won't know exactly which of the missing dates these kudos happened on, but I'll distribute them evenly and it won't be a big deal at all.
That way my stats will still be up to date, and I can answer important questions like whether my Explicit fics get more guest kudos (they really do) and how each of my Kinktober fics performed over their first 7 days...
