These were mentioned in the class.
- 5 Keys of Tracking Template
- How to Use Amazon Attribution
- Google Sheets: The Comprhenesive Masterclass: this is one of the best courses I’ve taken; if you want to level up your spreadsheet skills, start here. Wait until it’s “on sale” for $12 – $20 (this is the normal price) instead of $200.
- Spreadsheet with BookBub and Amazon Attribution data tied together via formulas
Why I calculate Revenue per Sale (sellthrough) and Revenue Per Borrow (readthrough) separately
I mentioned a video breaking this down in the live class; that was recorded pre-attribution links, so it’s somewhat outdated. The rationale behind calculating these separately is two-fold:
- Accuracy. If your RPS (sellthrough) and RPB (readthrough) are significantly different, say $12 and $8, the blended value in this example would underestimate the value of a sale and overestimate the value of a borrow. That leads to leaving unprofitable ads running and turning off profitable ads.
- Projecting out via revenue per click and profit per click. This is another analysis method for evaluating your ads’ profitability that I use for Amazon Ads, since it allows you how much each specific target (keyword, ASIN, etc.) is worth and thus set your bids accordingly. It can also be used for Facebook and BookBub.