It seems my new way or procrastinating from doing edits is to load videos to YouTube.
Five and a half years ago (which feels like an eternity and at the same time feels like it was yesterday) I wrote and published a book called Excel for Self-Publishers. This was actually the book that caused me to write Excel for Beginners and Intermediate Excel, because all I wanted in life was for writers to learn how to use frickin’ pivot tables. So I wrote four books to get them there.
Of course, Amazon eventually got their head out of their you-know-what and set up reporting so that you could just see in a glance month-to-date sales. And so that you could see AMS ad performance over a time period instead of only the entire life of the ad. And so that you could see the KENP related to a particular AMS ad.
Which was great.
But it also made half of that book outdated and unnecessary. So I unpublished it. And pulled the related video course off of Udemy.
Except some of that material was still perfectly relevant. Like the concept of customer value and how to calculate that. Or how to look at how unit price affects income. Or how to understand that the more books you have the more you can earn.
So yesterday I posted those videos. The customer value ones walk through how to calculate customer value for both sales and borrows and then how to combine those for a weighted average customer value as well as the flaws in the approach. The pricing scenarios and income projections videos are just standalone videos.
I’m pretty sure there are others there that I could also post and probably will at some point. But that was enough for yesterday.
Here is the pricing scenarios one, because it also uses one of my favorite Excel tricks, the “two”-variable analysis grid:
M.L. Humphrey 