In which this took all day: Sales n’ Spreadsheets #blogwanking

This will be tiny and illegible, but those of you who care can click on it for a larger and actually readable edition. You still may have to scroll a bit, since I work with a 27″ monitor and this image is all sorts of horizontal:

Screen Shot 2015-01-24 at 7.17.30 PMBasically, a day of fiddling with Excel and every sales report I can get anyone to give me has convinced me that I need to start fresh and on my own with 2015, as not nearly enough of the data I have for 2014 can give me specific dates on which I made sales– or, at least, dates on which I made sales anywhere other than Amazon.  Smashwords’ date data seems to fall into a black hole after 30 days, so I’ll have to keep track of that separately and on my own if I want to be able to see it.  Thus, this Excel spreadsheet, which keeps track of each book and each venue the book is available at.  I have to manually enter day-by-day sales and then it totals everything up for me; line graphs are on the next sheet.

Interesting fact: As of last night (I had six BA sales yesterday!) I’ve sold more books in January than there are days in January.  That’s a first for me if you don’t count the couple of KDP Select free days that I gave Benevolence Archives 1 when it was on Select at Amazon; those garnered hundreds of downloads.  If I was able to make BA free at Amazon I would get a lot more visibility for it.  Select has been good for Skylights, hands down, no debate, and I suspect when BA 2 launches in April it will be on Select as well.

It remains to be seen if my nonsense is finally starting to catch on a bit, if Select is solely responsible for this, or if people just buy more books in January than they do in December.  But it’s probably worth pointing out that my January check from Amazon will probably be at least a fourth of my income from writing in all of 2014.  That’s gotta mean things are looking up, right?

And, just for the hell of it:

They’re good.  I promise!