Fiction writer. Expert procrastinator. This is my life.
It’s pretty normal to be told that a post office box, as registered at a post office in the United States, doesn’t count as a physical address. And for some things, it really doesn’t. But for CAN-SPAM and email marketing, a PO box works just fine.
The reason is in the details.
Continue reading “Yes, for the purposes of CAN-SPAM, a PO Box is a physical address”Once I realized how unresponsive Amazon is to the surveys they send out, it was easy to start ignoring their survey emails. It’s also easy to see how much it isn’t about being helpful to authors and publishers on their platform and is about collecting information about their competition. And gaining leverage over the authors who use their platform to publish their books.
This latest survey purported to be a survey to improve their print publishing, but the first batch of questions were clearly focused on gathering as much information about the competition as possible.
Many people will give away their valuable business data and think nothing of it. I decided a while back it was better to send feedback in an email and ignore these surveys completely.
Naughty naughty Amazon. :D
Yeah, I just did the math for the earnings per word for my Kindle Vella story and although I knew it was bad, I hadn’t realized just how bad.
As of this moment, my Vella story has earned me $0.01833520 per word. Not per month, but for all time. I’ll bring this up again in a few months and see if things still look as pitiful.
Admittedly, I’m doing no advertising or other promotion of the story, because I have other priorities, and I always intended this just to be a way to get me writing regularly again, but the sad fact is, I have a lot of projects that I want to do, that will also earn me significantly more (I can’t even stress how much more) money than this project has been earning me.
I wanted to finish this in a reasonable time frame, but I just don’t think it makes sense in any world to do more than the bare minimum for this until I’m ready to actually sit down and finish it wholesale because I’m ready to publish it as a book.
Which, thank goodness I fully plan to sell this as a book later. Otherwise, I would feel like it was a lost cause and put it so far onto the back burner that I might never get around to picking it up again. I have a series I’ve let that happen to. I’m not happy about it, because I like writing the books, but I don’t like writing the books more than I like writing the other books in my other series and they make me a lot more money, so I’ve kept putting off that next book. It’s been about five years at this point.
I really need to spend more time writing.
And that’s another thing. This year, I’ve decided (as of this moment, to be honest) to stop saying I need to write faster. Because yes, on some level I do need to write faster and I wish I was better at that, but the true, underlying, number one reason I don’t write “faster” is because I don’t spend enough time writing.
So it’s time to own up to that and start talking about it in a way that is honest with myself.
Yes, there are days where I spend plenty of time writing and maybe I don’t write as much on some of those days as I wished because I’m not a 1,000 words per hour writer. But. And it’s a big but. Those days don’t happen as often as the days where I just do not spend enough time writing and end up with a word count commensurate with that effort.
Ah. Honesty is hard to swallow sometimes. And this post is a bit of an accountability post for me.
All that said, I’ve been giving a lot of thought to my 2022 goals even as late as it is into the new year (quarter one is done, for goodness’ sake). I’ll be back with a post about it when I’m ready.
I’ve been reading a lot lately about spreadsheets and inventories on another site.
Reading about the time involved in such a massive project has made me very happy that I’ve been tracking my stuff from the very beginning.
My main “publish-list” spreadsheet is up to ten tabs of data these days, and even includes all the sales links for my books on all the retailers I upload to. It’s been a handy thing to have.
I include so much in this spreadsheet that it’s difficult to think of something I can’t find there.
Within those tabs, I have a sheet called “File Updates” that tells me how long it’s been since I updated a file on any particular distributor site. It was a wake up call when I added that one because I ended up with a lot of titles in the “2000+ days” category, meaning all the back matter was way out of date.
I recently decided to tackle those old files and the way I’m doing it is to have a goal of updating at least one old file each week on an ongoing basis. That’s 52 files updated in a year, so that means I will have caught up within a year or so without adding in a lot of extra work or losing a lot of writing time.
(I have 34 titles at this point. Someday it will become more than a year’s worth of weeks of updates but I’ll worry about that when it happens.)
I also have a pretty streamlined EPUB generation system these days so this first year of updates will go a long way to making future updates take minutes instead of the hour or so it will take for some of these books now and will mean I should be able to easily update multiple books at a time instead of keeping it to one a week after this first round.
I update my publish-list spreadsheet every time I publish something or make a change that needs to be recorded. And keeping this thing updated is something I force myself to do every time I do anything that affects the data I keep up with. I don’t let myself off the hook on this, ever. It’s just too probable that something will slip through the cracks if I do.
I divorced some-odd years ago, and I’ve lagged with the name change for an online bank account and my PayPal account. I finally got around to it recently, and dear lord, it’s obvious to me now why I waited.
PayPal changes are a hassle. Their (new) website is glitchy and won’t accept my documents for the name change, and the email support is a run around, as is the chat support. First you get automated responses that make it near impossible to get hold of anyone real to deal with issues and then when you do, the wait time is interminable and the notifications to let you know the issue is being dealt with are nonexistent.
The only money I get through PayPal are my Smashwords deposits. Draft2Digital will do direct deposit to a bank account.
I haven’t wanted to switch, for a variety of reasons, but this might just be the thing that does it. If PayPal doesn’t get this done soon and right, I’m just going to close the account. If I close the account, Smashwords no longer makes sense as a distributor. And getting paid for Smashwords sales will become a hassle because I’ll have to go to a check.
However, if that’s what it takes, then so be it.
I do like that Smashwords is not just a distributor, but also a storefront. I do make money from that storefront and I do use the Smashwords coupons sometimes. Still, I’m not that happy with the payment set up because PayPal or check are the only options.
Smashwords really needs to get their house in order and start offering direct deposit.
*Despite the run-around, PayPal actually got this fixed. Crisis averted for the time being.
I’m going to sound smug for a moment, because frankly, that’s how I’m feeling right about now.
From the beginning, I’ve done everything I can to make life easier on myself, and it’s paid off in several ways in the long run.
I make all my links in my books go back to my own author website, including the link for my newsletter sign up.
Link to one of my books? It goes to my website (a page just for that book).
Link to my newsletter sign up form? It goes to my website (a page just for the form for the newsletter sign up).
This is part laziness on my part and part forward thinking. I’m always imagining worst case scenarios, and the worst thing I can imagine happening with links is some service going under and me being stuck with the task of editing who knows how many books and having to upload new files to all the distributors.
So here’s my advice to you, especially if you have a lot of books or plan to write a lot of them!
Link to your own website pages, no matter what anyone else recommends you do, or how much they swear you’ll earn more or get more subscribers or whatever.
I mean, I guess if you don’t mind the work, and doing it in a hurry too when something happens that screws up three hundred links you’ve put all over the web or inside your books and promo materials, then do what you want, but I will never recommend anyone link to anything but pages under their own control.
The end.
:-)
So day before yesterday, I spent an hour or so trying to find info on the Mailchimp changes I’d just been notified about by email.
I’m on the free plan, because my lists are tiny. Like, really super tiny, because I don’t promote them except in my books and on my websites, and I don’t do list building. (I can barely keep up my writing, so yeah.) My lists are 100% organic and I like it that way. I despise marketing, and dealing with that stuff ratchets up my stress levels to the point that I’d just as soon get another job in accounting as deal with it. At least I like accounting work!
Anyway, I had a feeling someone would put together a good post on the Mailchimp changes, and sure enough, yesterday, David Gaughran did.
Go read it if you use Mailchimp and you’re questioning what the heck they’re doing.
As for me, the first thing I did after reading the email was scoff and then tell my daughter it was obvious Mailchimp was looking for a way to inflate the numbers that they use to charge people for services. Gaughran’s post does a good job of laying it all out, and definitely supports my own view on that.
I can see why Mailchimp did it, but I still think the changes they’re making are kinda stupid. I mean, most people are going to see right through their blather about audiences and retargeting and blah-blah and see the move for what it is—an effort to offer less, earn more, and get out of the “forever free” promises they made in the past.
In all honesty, I think what it shows me is that Mailchimp can’t be trusted.
I went last night and finished up the profile I’d started with Mailerlite and got my account approved. I haven’t decided to bail just yet, but I guess I’ll have to. I have two lists, one of which has 6 subscribers (not joking!) and I’m not going to a paid plan to service that list.
I deleted my unsubscribed and cleaned emails from my main list at Mailchimp and exported it as a csv file, as I do every so often for backup, and over the next week or two I’ll figure out what I’m going to do.
Gaughran and several people in the comments of his post talk about archiving these unsubscribes, but from my reading of the Mailchimp help pages, delete works best for me. I want to be sure people’s info is scrubbed if I’m not using it, and I’m not using unsubscribed emails for any reason.
It’s pretty clear from my reading that people have the right to ask for their info to be deleted at any time, so I chose to be proactive and delete now. If I’m reading all that stuff wrong, I’ll deal with it. This is what I’d want done with my info, so I’m doing that for others.
After reading another post in a forum where someone has had a WordPress site hacked, I felt compelled to write this post.
Lots of authors let others set up websites for them and have no clue how they work, and the designer/developer decides to use WordPress to build the site because WordPress makes it easy for inexperienced website owners (authors) to post content and it’s free software.
But WordPress is not that easy to run for an inexperienced user, nor is it a set-it and forget-it solution, and that’s often totally forgotten.
I have a lot of WordPress-based websites and there are some key factors to keeping them safe you need to understand before you let anyone set up a site for you using WordPress.
I’m sure there are even more things to keep in mind if you’re letting someone set up a WordPress site for you, but these are the biggies that come to mind.
If you’re not comfortable with web stuff, using WordPress is not going to be a safe option for your website unless you have a designer/developer you can rely on and you’re not afraid to spend some money making sure things stay updated and safe.
WordPress is great. I love it. But I also know my way around a database, can do some light php coding, and have been building and running websites since 2001. There are definitely costs associated with WordPress-based websites, including real money and time. It’s a trade off. You learn to do a lot of things yourself and save the money, or you save the time and pay.
Anyway, if you ended up here because you’re thinking about letting someone set up a WordPress site for you, I hope this helps you make your decision with your eyes open.
:-)
Here’s a screenshot of a post on a forum. Maybe you can guess the forum, but I’m going to do the sane thing here and not mention it by name, because I’m not interested in sending goons after the bad guys and becoming a bad guy myself.
But ain’t that grand?
Personally, it’s just one of many reasons I stay far, far away from Amazon’s Kindle Unlimited program.*
(Also known as: Customers ripping off authors by downloading loads of books while signed up to a three-month trial of KU costing 99¢, stripping DRM from those books, reading those books in a way that won’t register for the author’s benefit (AKA authors not getting paid for pages read, because Amazon can’t stop this or account for it because payment is based on page reads instead of something reliably easy to track like, you know, borrows…), and then keeping those books indefinitely after canceling the KU membership.)
Pirating happens, and so does stealing, if one defines this kind of thing as theft. (I do, and although there are technicalities about why this might not be actual theft, I don’t care. Thievery is as good a name for it as any as far as I’m concerned.) There’s not much an author can do about this that won’t cost more in time and effort than is lost to the pirating (and theft), so I don’t worry about it much. Just nothing to be done.
Amazon has proven they’re unwilling to do anything. They switched from a system that worked around this kind of thievery to make sure authors got paid at least for the download to a system that pays literally as little as possible and makes authors eat any losses because of badly behaving Amazon customers.
In all honesty, I probably wouldn’t let this stop me from participating in KU if there were other benefits that I was interested in, but there aren’t, so I don’t. It’s an ugly system, and I choose to stay as far away from it as I can.
As for the pirating and thievery, well, people are either willing to pay or they aren’t. The money gets too slim, they’ll have to read someone else’s books because I won’t be writing, so tough on them if they really liked what they stole. And if they didn’t like it, well, too bad so sad for them. That’s a sweet revenge of a different sort. Reading that stolen book wasted their time, and that’s something they ain’t never getting back. :D
*I did have one book in KU way back when. I won’t bore you with details here but there’s a link if you want to know more.
I don’t know exactly what’s going on this morning with Amazon.co.uk and KDP, but I came across an odd value in my sales report from KDP for one of my books. I double checked the book on Amazon.co.uk, where the odd “royalty” came from, and realized Amazon.co.uk is price matching one of my books. The problem is, there’s no lower price anywhere for that ebook.
After a few clicks around the page, I found what I think is the root issue.
Amazon.co.uk appears to be having a sale on the paperback for this book, offering it at a significant discount—but only with orders of at least £10.00 of books.
Yay for them for having a sale.
Not so much yay for me.
I’m the one taking the hit on royalties earned for every sale of this book well in excess of what I’d make up for in volume because of the lower price, for a price match that isn’t even a real price match, because (1) they’re matching a paperback price and (2) the only way to get the low price is to buy £10.00 worth of books.
I have to say, I become less enamored by Amazon every year. Of course, I was part of the Amazon affiliate program well before I started publishing my books through KDP, so I never had a lot of the warm fuzzies for them as a business associate to begin with.
Still, every little blow just hardens my heart against them that much more.
Because this? Is not cool.
This post has been updated with an addendum. Turns out I was wrong.
I understand that technically I do not have to create a new edition of a paperback at CreateSpace just for a book cover change. But I’ve been mulling over my options and I’ve decided I should.
Here’s why: Resales.
If the book cover is different on more recently purchased copies of the book, anyone trying to list the old book for sale used is going to be listing a different product, because the book cover is an important part of the paperback.
When I buy a book, I expect it to come with the cover shown on the product detail page. If it were to arrive looking like a different book, I’d be pissed, because that’s not the book I thought I was buying. Covers matter to me and I’m sure they matter to a lot of people—especially people who collect paperbacks.
Therefore, I feel obligated to issue a new edition since I’m replacing the cover on the book in question. It only makes sense really.
The next question becomes do I leave the old edition for sale until the new edition makes it to Amazon and the other stores, or do I take it off the market as soon as I upload or approve my files?
I think I’m going to wait. No point in having the book off the market longer than necessary, right? Maybe I’ll even leave it up for a short while in case anyone wants to pick up the copy with the old cover before it disappears. (Okay, that’s probably not going to happen, but it’s fun pretending.)
Now, off to actually finish the new edition of that paperback. I’ve already corrected one lone typo and added some info to the front matter, but I still need to finish the actual new paperback cover design.
Addendum: As soon as I hit the Edition field in CreateSpace’s setup process for a new project, I started to have second thoughts.
That led me to a little more research, where I found this:
How do I tell one edition from another?
A new cover does not indicate a new edition as long as the publisher has not changed. What usually indicates a change in edition (providing the publisher has not changed,) is the change in the content of the book. This most often occurs with non-fiction books, especially textbooks.
So, now I’m thinking a new cover does not make a new edition, despite the issue with resales.
Then I continued, and found what Bowker had to say (Bowker issues ISBNs in the United States):
If changing the cover of a book, does a new ISBN have to be assigned?
US practice is if the book is just out or the idea is to give a marketing boost to the product, then no, a new ISBN should not be assigned. However, if the change in cover substantially changes the product (ie., would lead to customer complaints), then a new ISBN should be used.
I would complain if the cover was different, but I guess buying used copies, it’s just a chance you take.
Finally, I found some information in the Amazon KDP Support forums that makes a lot of sense after having read the previous two items. I can’t find a permanent link to the actual reply so here’s a link to the full thread and here are the relevant quotes:
I’m wanting to do a second edition of my novel…. There are minimal changes to the text (literally, MAYBE two words were corrected); the real reason for the second edition is that I have a completely new cover I’m wanting to use that will better fit my series…. [W]hat do I do in order to have my listing reflect the new cover and new edition without losing my reviews? Or is it unnecessary to make such a big deal out of a “second edition” when the cover is the only thing being updated?
The reply:
I would call that (as trad publishers do) a “reprint” and not a second edition. A second edition means significant content changes. Some of the publishers I work for have it down to a percentage requirement–such as, 40% of this book must change in the second edition. That’s the highest percentage I’ve seen; lowest was 20%. Changing the cover image does not, in my mind, warrant calling it a second edition. Second printing, if you’re printing–not that that really makes any sense in POD, of course. But with trad publishers who print up batches of something at one time, if they catch a few errors that they do wish to correct, but aren’t ready for a second edition, the email we get says “Let’s save this in a file for reprints” or “We’ll catch it in reprints.”
On that note, because there really are only very minor text changes to the book (one typo corrected and a few lines of updated front matter), I’m going to update the first edition with the new file and cover image and not create a second.
As for some other books I’ll be updating soon, they’ll have to be new editions, because the trim size will change and CreateSpace won’t let you do that as an update.
I had a thought that maybe there was a way to make updating my cumulative title sales spreadsheet easy enough that it would be worth keeping it up to date so I revisited the spreadsheet today for about an hour or so.
As you can see in the image above, I have several sheets in the workbook. The thing is, I know just enough Excel to know how much I don’t know.
But I had a thought and I followed up on it and that thought led to another and suddenly I’d found a way to make the currency conversions for the KDP sheet easily and quickly—and in a way that would work for future additions to the KDP sheet without requiring any additional effort on my part.
You see, if you’ve seen the KDP reports from Amazon, you’ve probably noticed they don’t include the currency conversion for the payments the way the reports from everywhere else does. It’s an inconvenience, but it is what it is.
My challenge was to find a way to prorate each month’s payment to each month’s sales. The way I chose to do it a few days ago was inelegant and not wholly accurate for each book. That bugged me, but it was a time versus accuracy dilemma, and my need to save time and effort won out.
But now I’ve figured out how to do it with zero additional upkeep.
#1
I created a column for a conversion factor in my book sales report where I track royalties earned and royalties paid by month for each vendor.
Sample row data (extraneous columns deleted):
| Oct 2016 | Amazon.de | EUR | 36.87 | 38.43 | 1.0423108 |
The conversion factor is simply the payment amount, which I have a column for ÷ earnings in the original currency, which I also already have a column for.
#2
I multiplied the foreign currency royalties in the KDP sheet by the conversion factor and got the USD royalties for each item (which I’d consolidated from the monthly KDP reports). I did this for all the rows in the KDP sheet.
If I’d had to do it manually, it would have taken forever.
The trick with the formula was to use the SUMIFS function because my royalty payments spreadsheet has only one row for every date and marketplace combination. That means the sum is always going to return only the conversion factor that matches the date and marketplace that the formula needs to calculate the USD royalty. It was just good luck that since KDP reports don’t show transaction dates, I had set up all my rows in the KDP sheet to contain only the period end date, which is also how I’d set up my royalty payments sheet (Oct 2016 is actually 10/31/2016 but set to the MMMYYYY format).
#3
I created a table so I could use the VLOOKUP function to solve the problem of having different names for the marketplaces in the two sheets (Amazon Kindle US Store vs. Amazon.com) but that was actually the easy part. :)
Anyway, what this means is that my brain spent a lot of time working on this while I wasn’t actively working on it—even after I’d decided it was too much trouble to keep up. But that happens sometimes.
I’m happy to say the sheet works well with the new formulas, even if my formulas are a bit of a hack. Updating the cumulative title sales will be a simple process that shouldn’t take more than half an hour every few months, and it’ll have the actual payment amounts from KDP applied to the correct months’ foreign sales.
I’m glad I was able to come up with a solution, and I swear, it feels like it’s taken me longer to write this post than it took me to fix the spreadsheet.
I had considered the idea of one massive spreadsheet that I could put into a PivotTable, but I didn’t consider that a good long term solution. The data between reports just isn’t standardized enough and I sure didn’t want to spend a bunch of time standardizing it each time I decided to update the cumulative title sales report. And I’m pretty happy with the solution I’ve come up with, because it means I can just copy and paste the new data into the appropriate sheets and I’ll be good to go.
Smashwords might be tricky, but my current plan is to just delete and re-add all the data from the updated reports, instead of append it. This is necessary because Smashwords throws in new transactions for some very old periods sometimes and trying to pick those transactions out of the whole would be a waste of time.
I don’t figure I’ll update this spreadsheet more than once a quarter anyway, but I’m tickled that it’ll be maintainable without a lot of effort. :D
Now, off to do some other stuff before I call it a night. It’s 12:03 a.m. and I swore I wasn’t going to bed late again! :o