Pivoting

I’ve just been doing some analysis on that spreadsheet I’ve been putting together. I’ve managed to combine all the Amazon spreadsheets for the period from July 2012 to August 2014. I really wish I knew how to record macros that worked because I know there’s an easier way, but since I didn’t want to take the time to learn how to do it, I just plowed through copy and pasting all that data into one big sheet.

I still need to add Barnes and Noble, Smashwords, Createspace, and all the others, but since the vast majority of my sales come from Amazon, I wanted to run some preliminary analysis because I don’t plan to use any more time tonight adding the other data. I’ll do it another day.

Until I had the data split out by title, I had no idea how much money I’ve been passing up by rotating between my series so equally.

It’s actually kind of ridiculous. I can no longer justify taking so much time between the release of books in my best selling series to make time for books and stories in all my other series. I knew it, but I didn’t know it in a way I couldn’t deny. Now there’s no denying. Ouch.

Still, it shouldn’t be a hardship to spend more time on one series than another, since I love all my books. :D And it might make the next few months really interesting when it comes to income growth. I’d certainly like to see that!