It’s Kinda Funny…

That the better I do at this writing thing the more inclined I am to quit altogether.

Sometime in March I passed a big milestone revenue-wise and probably hit one profit-wise and also came within spitting distance of a new monthly milestone, too.

And for the last few years I’ve earned enough from writing that it would pay a reasonable person’s bills if they lived in a reasonable area and weren’t too extravagant and hadn’t been stuck paying for their own MBA because their former employer pulled a bait and switch on them. (Thanks, George.)

In short, I’m doing better than most and making progress year-on-year.

Not near as well as some, that’s for sure. I think I’ve mentioned before that I know of some authors who are seven-figure-a-year authors and I personally know more than one that makes mid-ten-figures a month and I’m definitely not close to that.

But I’ve been steadily doing better each year. Enough to have some glimmer of hope. Some years are years that “pop” and suddenly I see an 8-fold increase from one year to the next. Others are more steady-risers that increase about 10% or so. But things have trended upward year-on-year as I add more product and figure out what I do that people want to pay for. And I’m doing it at a sustainable pace, too, so it’s not like I’m thinking to myself, “Oh my god, if I don’t work 20 hours a day, seven days a week, this all goes away tomorrow” like some I know.

And yet…

The better I do with my writing, the less optimistic I am about my potential to get to where I ultimately want to go.

I think that’s because when you first start out you think to yourself, “Wow, there are people who make seven figures a year at this. I could be one of those people. All I have to do is try and work hard at it.”

But then you try. And maybe you do work hard at it. But…you don’t make seven figures. Or six. Or five. or four. Or three.

Or you’re like me and you find that you just don’t want to work as hard at it as those other people did. One of the seven-figure authors I know of says she sits down and writes/edits for eight hours a day, Monday through Friday, every week of the year.

Me? I average 10 hours a week. I’m putting in a fourth of the time that woman is. Which is why she publishes 24 novels a year and I published three last year.

Or maybe you do work hard at it. Maybe you do put in those sixteen hour days. But then you put your book out there and…crickets. Or, worse, bad reviews. Or, you get, “Eh, okay, that was sort of good.” Your family and friends pat you on the back and say they enjoyed it. But they never ask for more. Neither do any of the strangers who bought it.

So you find that you’re not one of the crack-cocaine writers. You’re not addictive. People don’t crave what you write. They like it alright, maybe. But they don’t LOVE it. They don’t demand that everyone else read it. They don’t make absurd, unrealistic requests that you get the next book out NOW.

They just, you know, maybe will pick up the next one if it’s there and they can’t find something else they love more.

Those characters and those ideas that were so interesting and fascinating to you aren’t interesting and fascinating to anyone else. Or maybe they would be if your writing were better. You think maybe they would be. But that means that you’re writing isn’t that good right now? And who wants to think that? Especially if you’re a “that one story I’ve wanted to tell forever” writer.

Or maybe you do find fans. And you do work hard enough so you’re putting out enough books that it should work, but then you find out that there’s more to all of this than just writing books. There are so many other people who have written books, too, that you’re lost in the clutter. No one is finding your little adventure novel. No one is taking a taste and getting addicted.

You find out that it isn’t all about writing. You have to learn marketing. And cover design. And how to write ad copy.

Or maybe you have to pay for those things because you’re just not very good at those things. You can write a novel, but not a two-sentence zinger that gets someone to one-click.

And suddenly this thing that was going to make you a good living is costing you money instead. And you get bitter because wasn’t that cover beautiful enough? It if was, why didn’t anyone buy the book? Or why can’t you sell that book for more than 99 cents? Or $2.99? People spend more than that everyday on a cup of overpriced coffee that tastes bitter just to be cool and yet they won’t spend $2.99 on this novel that took you months to write?

And why does THAT book in your genre sell well when it’s so…not yours.

You start out all shiny and new and hopeful and optimistic that you’ll make it to the top. But then…life. And reality. Not everyone makes it to the top. Some barely get started. Some get stuck halfway. Some go up and then come crashing back down.

And the real kicker of it all is that it’s hard to know if you’ve reached the limit of your potential or if this is just a setback.

Is this moment, “Hey, you tried and you gave it your all, but this is as good as it gets.” Or is this the lull before you make that next leap up.

Maybe all you’ll ever be is that so-so writer that people don’t mind but don’t love. Or maybe you’ll turn the dial just a bit, try that next genre or that next idea or that next style of writing or reach that next reader who loves you so much they tell the world to read you, and it’ll all finally fall into place.

The further along you get the more it can start to feel like maybe there’s nothing left to turn.

Sure, you could write more, except…you know you’re not going to write more. You haven’t written more in five years.

Or you could write with more action and less emotion, except…that’s not the writer you are. If you want to do something that isn’t you there’s a nice comfy corporate job that comes with health insurance that’s a lot easier to do and doesn’t result in strangers on the internet making conjectures about your childhood.

You could write shorter. Or write longer. Switch genres. Learn how to be likeable online. Except…That’s not you. You know that maybe that’s how others succeeded, but…you aren’t them.

So then what do you do?

Do you try one more time? Or do you call it? Turn the dial or walk away? Because, really, life doesn’t have to be this hard. Does it?

Focusing On the Right Goal

This is a writing-related post, so if you’re not interested in that, now’s the time to bail.

When I first started self-publishing there was a lot of talk about two things: how many copies someone had sold (a million copies!) and whether they’d hit six-figures.

Which are both great and wonderful things to talk about, but as I discuss in detail in Data Analysis for Self-Publishers, can be the wrong metrics to focus on. You can sell a million copies and not make a living from your writing. You can also have six-figures a year in revenue and not making a living from your writing.

The number of copies sold ignores what those copies were sold for, and selling a million copies at 99 cents is going to have a vastly different outcome from selling them at $4.99. And, of course, if you pay too much for advertising then all the sales in the world aren’t going to make a difference if you lose money on each one.

(Which is not to say I don’t believe in advertising. I absolutely do. I just believe in advertising for a profit. If you can’t advertise and be profitable then you need to change your ad strategy, change up the cover etc on what you’re advertising to make it more desirable, or write something new that you will be able to advertise at a profit.)

But that’s not what prompted me to write this post today. I’m currently in a Facebook group that is focused on selling books everywhere, not just Amazon. And there was a recent product release of a sales tracker that provides these pretty little circular graphs with each store in a different color. Members of this group LOVE to post those photos and talk about how “isn’t it great that Amazon is only 40% of my sales?”

Every single time I see one of those posts, I wince. Because it’s focusing on the wrong metric. One of the ones I saw this week, the person was proud to have Amazon as only 50% of their revenue but they’d also only made $70 on Amazon. You can’t live on $140 a month.

To be clear, I am a strong advocate for being wide because as I told someone a few months ago I have no desire to contribute to the collapse of the self-publishing ecosystem by placing all of the power in Amazon’s hands. As soon as they can they will fuck us all over. So if I want to be able to self-publish five years from now or ten and make any sort of money from it, I need to be part of there being viable competition for Amazon.

But the reality is that Amazon, especially in the U.S., is the single biggest sales platform for self-published authors. We don’t get into bookstores that often. So our sales are coming from Amazon, Kobo, Nook, Google, and Apple primarily. And for U.S. sales, Amazon is probably 75% or more of that market.

So even being wide, I expect Amazon to be a big chunk of my revenue. That’s why every single time I see one of those posts in that group I wince. Because the goal should not be to replace Amazon with the other stores. It should be to keep or grow your Amazon revenue while ADDING the other stores on top of that.

What I want to see is bar graphs or line graphs of increasing revenue. “I went wide and my income went from $1,000 a month to $1,500 a month.” That’s being successful wide.

(And, let me tell you, that’s probably not what most could say. Again, I am all for being wide, but the reality is that Amazon is set up to advantage exclusive authors in about a dozen ways so most authors who go wide take a financial hit. And those who start wide have no idea what they’ve sacrificed by being wide.)

Look, this is a hard business. You have to take every win you can find to keep yourself going. I celebrate the units sold. I celebrate the revenue. I celebrate the good months on each platform. (Thank you, Apple, for what I suspect was a recent feature of a free run I did on my fantasy series.)

But at the end of the day what I have to ultimately focus on is the things that pay my rent. That bottom line number of profit and loss. That’s what will let me keep doing this long-term. None of the rest of it will. It’s part of it, but if the bottom line isn’t good enough? The rest doesn’t matter.

So, please, don’t let yourself be distracted by pretty graphs.

And 2 More New Releases

Yet again I am a little behind on announcing new releases. (I impulsively decided to sell my house this month and it required this thing called cleaning that it turns out takes time to do.)

Anyway. The 2019 versions of the Access books are now out, Access 2019 Beginner and Access 2019 Intermediate.

I prioritized these over the PowerPoint updates because it turns out they made one “major” change in Access 2019 compared to Access 2013 that throws me every time I have to use the program and that’s in the import section for External Data.

Now when I want to import an Excel file I actually have to go to the New Data Source dropdown menu, then choose From File, and then I can finally choose Excel from the seconday dropdown. For a new user to Access I thought that was a big enough change that I wanted to get the updated guides out sooner rather than later.

Other than that, though, as with the other guides you’re pretty much fine using either Access for Beginners and Intermediate Access or Access 2019 Beginner and Access 2019 Intermediate. The base knowledge on all of these programs doesn’t change so drastically between versions that you need to relearn it.

(At least not since that lovely 2007 release.)

An Interesting Excel Question

Today I received an interesting Excel question from a user and thought I’d share the solution I came up with here.

Here was the question: In excel, what is the formula for taking a cost times a 30% margin then rounding it up to the next $x.x5 or $x.x9     (example: $3.45 x 30% margin = $4.93, roundup to $4.95) or (example: $3.48 x 30% margin = $4.97, roundup to $4.99)

At first, I thought, there’s no easy way to do this. And there isn’t. A quick search for functions that would do this specific task resulted in nothing.

But then I remembered that I’d covered the CHOOSE function in Excel 2019 Formulas & Functions and that it could be used for this. As it turns out, it still wasn’t easy to do, but it is doable.

(And there may very well be a much simpler solution to the problem, but this seemed to work for me, so it’s what I went with.)

Here’s what I ultimately came up with:

=ROUND(A1/0.7,2)+IF(TRUNC(A1/0.7)-A1/0.7=0,0.05,IF(ROUND(A1/0.7,1)-ROUND(A1/0.7,2)=0,0.05,CHOOSE(RIGHT(ROUND(A1/0.7,2)),0.04,0.03,0.02,0.01,0,0.03,0.02,0.01,0)))

The first part of that formula, =ROUND(A1/0.7,2) is calculating the marked-up price on a value in Cell A1. That gives the $4.93 or the $4.97 value.

The second part of that formula is where it gets interesting. Let’s drop out the IF functions for now and look at the CHOOSE function:

CHOOSE(RIGHT(ROUND(A1/0.7,2)),0.04,0.03,0.02,0.01,0,0.03,0.02,0.01,0)))

It’s best to work from the inside out.

So we start with the (ROUND(A1/0.7,2) portion which is just giving us the number we’re working with.

Next is the RIGHT function. What that’s doing is taking the right-most digit of our number. So in the examples above that would either be the 3 of $4.93 or the 7 of $4.97.

Finally, we have the CHOOSE function which basically provides a different result depending on the value you give it. So in this case a 1 returns a value of .04. A 2 returns a value of .03, etc. Once we cross the 5 mark we have to switch things up a bit so that 6, 7, 8, and 9 will result in values that end in a 9 instead of values that end in a 5.

That value gets added to our original calculated value to create a result that ends in either a 5 or a 9.

But because I used the RIGHT function we have a problem. Any value that’s a whole number, like $9.00, isn’t going to calculate properly because RIGHT will pull in a value of 9 not 0. And any value like $7.30, $8.20, etc. will also not work properly because RIGHT will pull a 3 or a 2 or whatever the next actual digit is instead of the zero.

We can solve that, though, with IF functions. Namely,

IF(TRUNC(A1/0.7)-A1/0.7=0,0.05,

and

IF(ROUND(A1/0.7,1)-ROUND(A1/0.7,2)=0,0.05,

IF(TRUNC(A1/0.7)-A1/0.7=0,0.05 basically says that if it’s a whole number then add .05 to it. And IF(ROUND(A1/0.7,1)-ROUND(A1/0.7,2)=0,0.05 says that if the rounded value with one digit is the same as the rounded value with two digits, then also add .05.

A little messy, but it solves those two issues.

And I think all of it taken together answers solves the issue.

Choices, Choices

I have been wanting to write another fantasy novel for a couple years now. The last one I published was in 2017 and that series still makes me money with new readers but I have nothing for the folks who’ve already finished the series. Plus, fantasy is my first love and what I as a reader spend most of my time reading.

But I keep not doing that.

When I stop and think about this fact, those are the days when I really envy those people who have one direction in life that they’ve always wanted to go. That one story they’ve always wanted to tell. That one person they’ve always wanted to be.

I am not that person. I am the person who has eight zillion possibilities I can see at any given moment, about half of which seem really interesting.

At this point I have published over 2 million words: close to a million non-fiction across about ten broad categories, about half a million in speculative fiction, about 350K in romance, and about 320K in mystery.

And I have books I want to write that would not fit with anything I’ve already published. (*head desk*)

Just imagine if I’d published 2 million words of just one type of fiction…That would be about 20 fantasy novels. Or 50 cozies. If you can’t find an audience with twenty novels, then, hm, maybe time to move on to something else.

Alas. I would’ve died of boredom before I wrote 20 fantasy novels in a row.

So I bounce around and pay the consequences which is slower build-up and lost momentum sometimes.

Now, ironically, the reason I haven’t written a new fantasy is because I’ve paid enough attention to numbers to know it’s a huge risk to take to do so and I’ve been trying to focus better the last couple years.

It takes me X hours to write most non-fiction titles. A cozy mystery takes about 2X. But a fantasy takes 6X. At least the last one I wrote did.

And right now my overall profit per writing/editing hour for non-fiction is 20x my profit per hour for writing/editing fantasy.

So, of course I keep choosing the thing that takes 1/6 the time and pays 20x the profit.

But…

Fiction is a tricky beast. Because it’s hard to see the potential before it takes off. Non-fiction you can have a single standalone title that does well on its own so if you hit with a title you can immediately see the potential. But fiction can be one of those situations where nothing, nothing, nothing, and then BOOM all of it moves at once.

I know of more than one author whose earlier series didn’t start to sell well until their second or even their third series caught on with readers.

Fiction also has more potential for additional titles.

You might find this hard to believe given the number of titles I’ve written on certain subjects, but there are only so many books you can write about each non-fiction topic before you run out of new things to say.

With fiction, though, if you create an interesting world or an interesting character the number of potential titles is limitless as long as your readers stay with you and you can keep it fresh for yourself.

So with fiction it doesn’t always come down to the numbers you already have. Sometimes it comes down to that gut instinct that you’re leaving potential on the table.

Of course, sadly, the only way to test that you’re doing so is to put in the hours to get that next title out and see how it does. (I mean obviously if you’re getting unending fan letters asking for more that’s a pretty solid indicator. But for those of us who are not getting those letters, putting in the work and seeing what happens is pretty much the only choice.)

And I swear I am going to do that this year with a fantasy novel.

And maybe a romance, too, since the last couple sold thousands of copies.

I’m going to do it.

Right after I write these next three non-fiction titles. And maybe another cozy. And then…yeah. Sigh.

Damn it. Where did my workaholic tendencies go? If only I didn’t want downtime to read other people’s books and walk my dog and see my family and veg out on silly TV shows like Cake Wars.

Ah well.

What I do know is that even if I still don’t publish that fantasy novel this year I will keep moving forward in some direction or other so that by the end of the year I have another 300K words out there of some sort.

Because I may be foolishly building a barn, a house, and a fence around my property all at the same time, but at least if I keep working at it one of them will eventually turn into something useful. (I hope.)

7 New Releases

I had no intention of announcing the release of seven new books at one time, but, well, I forgot to announce the Word 2019 releases and then it happened that the Easy Excel 2019 proofs arrived at the same time as the Excel 2019 Formulas and Functions Study Guide was finished and here we are.

So, if you have an interest in Microsoft Word or Microsoft Excel 2019, read on. If not, you can skip this.

First up, the Microsoft Word 2019 versions of Word for Beginners and Intermediate Word are now out. Once more, if you bought the originals, no need to buy these ones, too. I don’t think there’s anything so drastically different between them that you’d need the new ones. I think I may have moved one item from the intermediate level to the beginner level but that’s about it.

You can click on the images below to be taken to the store of your choice.

Okay. Next up. The Easy Excel Essentials 2019 books are now out. These are intermediate-level titles that focus on one specific topic: PivotTables, Charts, Conditional Formatting, and The IF Functions.

In this case, I’d say there are substantial differences in the IF Functions title because Excel 2019 includes IFS, MAXIFS, and MINIFS which didn’t exist before. So if you’re looking forward and don’t need to worry about backwards compatibility, this is the book you want. If you work with a lot of different Excel users and so can’t risk using the latest and greatest, then stick with the old version. Excel 2019 Charts also covers histograms which was not covered in the original title and Excel 2019 Conditional Formatting is expanded a bit.

Also, the print versions of these books have very different formatting. I decided this time around to go with the standard computer book size formatting for the print versions so these are all 7.5″ x 9.25″. They also have larger text than the original series so may be better for those who struggle with small type.

The astute observer may also notice that the 2019 books do not include Formatting or Printing which were part of the original series. Mostly that’s because even though I meant the titles in this series to be bought as one-offs a lot of people buy the entire series at once so I wanted to focus in more this time around. Really, if you need formatting and printing, just buy Excel 2019 Beginner. It will cost you less and you will learn more.

Okay. Final release to announce, Excel 2019 Formulas and Functions Study Guide. This is the equivalent to the quiz books for the Excel Essentials series. Basically, it takes the content of Excel 2019 Formulas and Functions and walks through that content in a question and answer format. There are also ten bonus exercises at the end to test putting the functions to use in real-world scenarios.

Once more, if you already bought and worked with the original 50 Useful Excel Functions and 50 More Excel Functions and their associated quiz books, probably no need to buy this one. It does cover some new functions like TEXTJOIN and IFS but you can probably fill in the gaps from within Excel itself without needing to buy a new book for it.

(Not that I object to making money, so buy it if you want. Just saying you don’t have to.)

Errata – 50 Useful Fn Quiz Book

This last week I was working on the Excel 2019 Formulas & Functions Study Guide and it led me to review the 50 Useful Excel Functions Quiz Book and I noticed a few errors.

I submitted updated versions of the books today so anyone from tomorrow forward won’t see them, but for anyone who already owns that book (or the Excel Essentials Quiz Book), I wanted to mention the fixes I made.

(I think the book might be being used in a college class right now, so felt it was especially important to mention the updates.)

1. HOW FORMULAS AND FUNCTIONS WORK QUIZ, Question 7F and 8F. Those should be written as =(4+3)*2 and =(E1+A1)*C1, respectively or else the answer doesn’t work.

2. BASIC COUNT FUNCTIONS QUIZ ANSWERS, Question 11. Ignore the last sentence of the answer because there is actually overlap between COUNTBLANK and COUNTA.

3. VLOOKUP QUIZ ANSWERS, Question 5. The answer is actually one because you can use a VLOOKUP to look in the exact same column to find the closest answer to your lookup value.

Some Writerly Comments

First, if you have audiobooks and didn’t pay much attention to the latest ACX email they’ve made some pretty significant changes.

As of March you should actually be able to see returns on your dashboard. No more hiding the extent of the return issue in sales. Which becomes less relevant with another change they made as of the start of the year which is that if a return is made after more than 7 days they’ll eat the cost instead of charging it back to the publisher of the audiobook.

And no more seven-year lock-in. Not even for those with royalty share. If you can make a deal with your audiobook narrator you can move to non-exclusive. And after 90 days you can even remove your books from distribution with them.

It’s basically everything I would’ve liked to see them do about 9 months ago when I first realized that I was basically listing books with them so they could give them away for free.

For me it was too little, too late, though. I asked them to delist my audiobooks and that should happen within the next two weeks.

I was able to do that because they’re such a small part of my earnings. My wide audio makes 30x as much each month as my ACX audio. (We’re not talking big numbers there.)

I’m doing it because personally have no interest in being in business with someone who so patently prioritizes their interests over their business partners’ and doesn’t act to change anything until things publicly hit the fan. So…

Bye-bye, ACX.

Second, some nice new developments at Barnes & Noble where they’re clearly making some efforts to support self-publishers. As of this month they’re going to a flat 70% payout for all price points.

I know they had that site glitch last year that upset a lot of people but all in all I like working with them and am pleased to see those developments.

Google seems to be picking up some steam as well these days, so that’s nice as well. And I think Apple and Kobo are still in the hunt and making improvements, too. So some promise there.

Third, I just did my ad numbers for January and have to say I’m still pleased with AMS ads for my core books.

To be clear, the ads no longer work for all of my books. I just don’t have a deep enough catalog for them to work well in some areas, but overall they definitely move the needle for me.

And compared to what I need to do to set up a Facebook ad, which I also did some of this week, they’re a helluva lot easier to get up and running. No ad creative to come up with, no three fields of text to populate with something engaging, no need to worry that the link you provide in the ad will actually work for the reader…

As far as AMS goes, I was having a conversation earlier this week with someone about the ads and their effectiveness and I think the key point is that you need alignment between everything the potential customer sees along the way from search term to purchase.

If someone searches for “dragon fantasy” then the best possible match for that search term is a kick-ass cover with a dragon on it. (Not an okay dragon. A kick-ass one.) That has to be followed by a book description that’s all about dragons and fantasy worlds and a price point that matches the genre and reviews that are like, “OMG, the dragons!” The more every piece and step lines up, the better the ad performance is going to be.

Miss one step and you have an impression without clicks or clicks without sales. Enough of that and your ad dies or you’re out a lot of money or both.

Fourth, I’m having one of my periodic “what the hell am I doing with my life” thoughts, which I think most self-publishers (or writers) do at some point. (I know there are some who don’t, but not all of us have that stellar rise to the top and ability to stay there.)

Even though I’ve made steady progress year after year, this is not an easy business.

(That’s actually why I like it, which is absurd. I get bored with things I can do well and no amount of money makes up for that lack of challenge. Although I may feel differently about that when I’m 50 and unemployable and all I have to show for my life is my books…Haha. Sigh.)

Spending time and effort on something that can feel like slogging through molasses at times has to make you stop and wonder every once in a while what exactly you’re doing with your life. Like, wouldn’t I rather go back to that six-figure-a-year-part-time project where they treated me like a glorified admin than do this every day?

But I like my dog. And I like not having to be on 28 Zoom calls a week. (Like my brother right now.)

And I like living in my own head instead of trying to figure out how to get that semi-senior executive who thinks he knows all the answers to listen before something vital crashes and burns.

So I continue while I can and I put my faith in the powers that be that something will save me from me when the time comes that it all finally collapses. Haha.

Anyway. We live in interesting times.

What’s Possible

This month the husband and wife writing team Ilona Andrews self-published a title, Blood Heir, that ties back to one of their incredibly successful trade-published series about Kate Daniels and an Atlanta with waves of magic.

As I write this the ebook is ranked #167 in the Amazon U.S. store selling in ebook at a price of $6.99 and the paperback is ranked #4,403 selling at a price of $14.39. The book is available wide, meaning not just on Amazon, and is doing equally well on the other major retailers.

The book made #5 on the New York Times bestseller list which is almost unheard of for a self-published title. That’s also about as well as a title can perform. And the key is that it was self-published. Being able to hit that level of performance without using a publisher is HUGE.

I’ve been following the Ilona Andrews blog for a while now and it’s clear that they have an incredibly devoted fanbase. As I write this there are already 3,662 ratings on Amazon and the average rating is 4.8. Every time they post on their blog about publishing anything new, self-published or trade-published, a large number of people say, “Please!”, “Yes!”, “I’ll read anything by you.”

This was not the first title or series they’ve self-published. They’ve been hybrid for a while now. But I think this was a turning point and that they may very well focus on self-publishing for the time being. They’ve certainly indicated that’s the case for the next year.

It’ll be interesting to see how this evolves. For me one of the benefits of trade-publishing is on the print side. For example, Ilona Andrews has a series they’re currently wrapping up that’s published by Avon in a mass market paperback size for $7.99. Self-publishing is currently not capable of matching that price point without a print run. (Same with YA print. The price points they can offer books at are well below what I can get from POD printing.)

I know on the trade side they’ve been talking about the demise of mass market paperbacks forever, but for me as a reader that’s how I find a lot of my authors. I’ll happily spend $8 on a first-in-series title. $16? That’s harder to justify. For now it looks like their readers have followed them to the higher price point in print but I wonder if long-term that may slow down.

For Blood Heir they’re doing print on demand through Ingram, but theoretically they could do their own print run on a mass market paperback because unlike most self-published authors they know they have the numbers to justify the up-front cost.

If they go down that road things could get very, very interesting. So something to keep an eye on if you weren’t aware of it already.

(And man do I love those Luisa Pressler covers. I saw her work on Twitter a couple years back and reached out about a possible cover but she was just a little out of my reach at the time and I’m sure is completely out of my reach now. But I love her style so much…)

So You Got a Bookbub Deal

First, congratulations. It’s scary to spend that kind of money on a promotion, but in my experience it’s been worth it every time even with the ones that didn’t perform as well. (My worst took four days to pay for itself with sales of that book and followthrough sales and I’ve only ever had 99 cent deals on standalones.)

Second, on the day of the Bookbub do not freak out if the sales aren’t there when you think they should be. I’m in the middle of the United States and inevitably think my deal is a big dud because the Australian sales for me don’t report until the next day on Amazon and that’s always a big chunk.

Now, the reason I am writing this post is because I’ve seen one too many questions about how to adjust pricing for a deal, especially how that works for authors who are wide.

So I decided I’d just run through it here once and then anyone who wanted to could find it on the internet and I could just link to this post if it ever comes up in a group again. This is for a non-free deal. Usually 99 cents but I’ve seen a few $1.99 etc deals.

We’ll start easy:

Nook: Change the price to your U.S. deal price. Done, because it’s just U.S. sales.

Amazon: Change the U.S. price and then click on Other Marketplaces to show all other markets. Make sure that the prices in India, United Kingdom, Canada, and Australia match the price listed in the Bookbub acceptance email. (For 99 cent deals that’s 0.99 for all except India which is 65 INR.)

Apple: Change the base price and then go and confirm that all of your Bookbub markets are the price you want. There is no India option to worry about.

Google: Two options.

Simple option is to have one USD World listing and then one listing for each of the Bookbub countries (Canada, UK, Australia, India) using the deal price. So USD 99 cent WORLD and the rest are CAD 99 cent Canada, AUD 99 cent Australia, etc.

Make sure the tax-inclusive box is checked for each country so that you don’t end up with a 99 cent book priced at $1.06 which will mean that country doesn’t run as part of your Bookbub deal. (I do it for every country rather than try to figure out which ones have a VAT in place.)

The more complex option is to leave your usual listings in place and then for U.S. WORLD, Canada, UK, Australia, and India to list a second price for each country that includes your dates of your promotion and your sale price. This should mean that the deal shows as a discount off your full price on the book page.

I’ve been bit on this one before when it didn’t override my normal price because my normal price was not listed as tax-inclusive but my sale price was so I sometimes just go with the simple option instead.

Kobo: Two options here as well. Start on the set the price page for the book.

Your first option is to change the default list price to what you need and then make sure that the price listed for each country in your BB deal is what it should be.

Your second option is to leave that section alone and instead use the schedule a sale option. Works the same, basically price-wise, except you set dates for you promotion. (I tend not to use it because I end up cancelling the sale early because I always want it to end on the 14th but when you put in the 14th that means it will end on the 15th.)

Draft2Digital: They have a promotion option that lets you schedule a promotion but last I checked it was USD only, which I don’t trust because of currency conversion. So…

I go to the Publish page for the book, click on Manage Territorial Prices, and make sure that the USD price is set to what I need and then all the other prices are set to their requirement as well. To customize a country price you check the box next to that country and enter the price you want. Click Apply Territories when done and submit the change.


That’s it for the ones I use. I assume other stores would work the same. Basically, don’t rely on currency conversion to get the right prices for your deal.

Also, be sure to check your listings in each country before the day of your deal.

For Google you can add &gl= and then the two-letter country code at the end of the URL to see the price in each store. For Apple change the current two-letter country portion of the URL to the one you want to see. Same with Kobo.

(The UK two-letter code is GB.)

For Amazon you need to change the amazon portion of the address to match the amazon url for that country. So amazon.com becomes amazon.co.uk, for example.

You won’t have buy options in each store, but you should be able to see pricing to confirm that you got it right.