You check your Amazon KDP sales. Then your email marketing reports. Then your Amazon Ads. Then your latest book promotion results.
Somewhere between the fifth browser tab and your third cup of coffee, you wonder: Is any of this marketing actually working?
If that sounds familiar, you’re not alone.
Indie authors have access to more marketing data than ever. The problem? That data lives in different places, making it difficult to see which efforts are bringing in readers, generating royalties, and helping your author business grow.
That’s where an analytics dashboard comes in.
And the good news is that you don’t need expensive software, a statistics degree, or a spreadsheet wizard’s hat to get started.
An analytics dashboard is a centralized place to track your book sales, royalties, marketing expenses, promotions, and audience growth. It helps you understand what’s working, what’s costing you money, and where to focus your marketing efforts next.
To build one:
Our recommendation: Start with a free Google Sheet containing four tabs: Sales, Promo Log, Audience, and Ads. If you’re comfortable using AI, consider asking it to build the initial spreadsheet for you. Add Google Looker Studio later if you want visual charts.
You may be able to build a basic first version in a couple of hours, although authors with multiple retailers, formats, and marketing campaigns should expect to spend more time organizing their data.
Why Indie Authors Need an Analytics Dashboard
The Six Metrics Every Author Should Track
How to Build an Analytics Dashboard in 7 Steps
Which Dashboard Tools Should You Use?
How to Turn Your Data Into Better Marketing Decisions
Common Analytics Mistakes to Avoid
FAQs
If you publish exclusively through Amazon, you probably already use your KDP dashboard.
But what happens when you also sell books through Kobo, Apple Books, Barnes & Noble, or your own website?
Your numbers become scattered across multiple reporting systems.
Add Facebook Ads, email promotions, and newsletter campaigns, and it’s easy to lose track of the bigger picture.
An analytics dashboard brings that information together.
Instead of asking, “How many books did I sell yesterday?” you can start asking more valuable questions:
The goal isn’t to collect more numbers. It’s to make better decisions with the numbers you already have.
And unlike checking your sales rank every twenty minutes, reviewing a dashboard can actually tell you what to do next.
You could track dozens of metrics. But more data doesn’t necessarily mean more clarity.
Start with these six.
| Metric | What It Tells You | Why It Matters |
| Royalties by retailer | Where your book income originates | Identifies profitable retailers and formats |
| KENP reads | Kindle Unlimited pages read | Helps measure KU engagement and estimated earnings |
| Series read-through | How readers progress through your series | Reveals the long-term value of attracting a reader |
| Promotion ROI | Estimated return from each promotion | Helps evaluate marketing spending |
| Cost per subscriber | What you spend acquiring email subscribers | Measures audience growth efficiency |
| Series-wide ROAS | Royalties generated relative to advertising costs | Shows whether advertising may pay off across multiple books |
Imagine you’re promoting the first book in a three-book mystery series.
You earn $1.50 in royalties from each book-one sale, but acquiring that sale costs $2.
At first glance, you’re losing money.
However, if enough readers continue to books two and three, the total royalties generated by those readers may exceed the acquisition cost.
That’s why series read-through can be more valuable than looking at individual book sales alone.
A practical way to estimate book-one-to-book-two read-through is:
Read-through rate = Book two paid units ÷ Book one paid units × 100
For example, if book one sells 200 copies and book two sells 120 copies, your estimated read-through rate is 60%.
This is an approximation, not a measure of individual reader behavior. Existing readers, free downloads, Kindle Unlimited activity, and different publication dates can affect the calculation. Compare consistent sales periods and reader cohorts whenever possible.
For authors with a series, this is one of the most useful numbers to understand before investing heavily in advertising.
Start with a simple formula:
Promotion ROI = (Incremental royalties − Promotion cost) ÷ Promotion cost × 100
Suppose you run a $50 email promotion.
Your book normally earns $10 in royalties over seven days. During the seven-day measurement window, it earns $90.
Your estimated incremental royalties are $80.
Your estimated ROI is:
($80 − $50) ÷ $50 × 100 = 60%
That’s a promising result!
However, it isn’t proof that the promotion caused every additional sale. Other advertising, organic discovery, and normal fluctuations can contribute.
For a more useful comparison, measure every promotion using the same seven-day window and record your normal sales baseline.
Also remember that a free ebook promotion should be measured differently. Free downloads represent reader reach, not immediate royalty revenue.
For example, a Freebooksy email promotion might generate hundreds of free downloads. Your dashboard should track cost per download and subsequent series sales rather than treating those downloads as paid purchases.
Building a comprehensive analytics dashboard can feel like a big undertaking, especially if you’re not comfortable working with spreadsheets, formulas, or data from multiple platforms. And that’s okay!
The steps below walk you through how to build your dashboard manually using Google Sheets or Excel. But if you’re already using AI tools like ChatGPT or Claude, you can make the process much easier and faster.
For example, you can ask AI to create a spreadsheet template with the tabs, columns, and formulas you need to track your book sales, royalties, promotions, and marketing expenses. You can even ask it to help you organize your data and build charts to visualize your results.
You’ll still need to provide accurate data and double-check the calculations, but AI can take much of the technical setup off your plate.
The goal isn’t to become a spreadsheet expert. It’s to create a system that helps you make smarter marketing decisions without taking valuable time away from writing.
Ready to put your numbers to work?
Here’s how to build an analytics dashboard without turning book marketing into a second full-time job.
Open Google Sheets or Excel and create a new workbook.
Add four tabs:
Keep one row per date, title, retailer, or campaign, as appropriate.
Avoid merged cells and inconsistent date formats. These make future calculations and visualizations unnecessarily difficult.
Start with Amazon KDP Reports, where you can access orders, estimated royalties, and Kindle Unlimited reading activity.
If you publish wide, add information from other retailers or distributors, including Kobo, Apple Books, Google Play, and Draft2Digital.
Your Sales tab might look like this:
| Date | Retailer | Book | Units | KENP Read | Estimated Royalties |
| Oct. 1 | Amazon | Book One | 12 | 1,500 | $24 |
| Oct. 1 | Kobo | Book One | 4 | 0 | $10 |
| Oct. 2 | Amazon | Book Two | 7 | 900 | $21 |
Illustrative data only.
Add columns for format, currency, and free versus paid units where applicable. Record actual royalty payments separately from estimates.
Include audiobook sales and direct-store purchases if those are part of your publishing business.
Tip: Retailer reports update on different schedules. Don’t compare incomplete data as though every platform reports sales instantly.
This is arguably the most important tab.
Your retailer dashboard can tell you how many books sold. It usually can’t tell you which external email promotion influenced those sales.
Your Promo Log helps connect the dots.
Track:
For example, if you schedule a Bargain Booksy email promotion for a discounted first-in-series ebook, record the promotional cost and measure sales across the following seven days.
Over time, tracking these results can help you identify which promotional approaches are worth repeating and where you might want to test something new.
For campaigns linking to your own author store, use tagged URLs so website analytics can identify traffic sources.
Your email list is an audience you can communicate with directly, without relying entirely on retailer algorithms.
Add these columns to your Audience tab:
Then calculate:
Cost per subscriber = Campaign cost ÷ New subscribers acquired
For example, suppose you spend $75 on a subscriber acquisition campaign and gain 150 subscribers.
Your cost per subscriber is $0.50.
But don’t stop there.
Track whether those subscribers open your emails, click your book links, and remain subscribed.
A smaller, engaged list can be more valuable than a large list that rarely interacts with your content.
If you run your own Amazon Ads, Facebook Ads, or Instagram Ads, record:
Pay particular attention to return on ad spend (ROAS).
ROAS compares revenue generated with advertising spending. For authors, a royalty-based version is often more useful because retail sales revenue isn’t the same as author earnings.
Royalty-based ROAS = Estimated royalties ÷ Ad spend
A result of 1.5 means you’re estimating $1.50 in royalties for every $1 spent.
If you’re promoting a series, include reasonable estimates of royalties from later books.
If you’re using a managed advertising service like Written Word Media’s Reader Reach Ads, your tracking process may look a little different from campaigns you manage yourself. Record your campaign dates and investment, then monitor changes in retailer sales, royalties, and series performance to better understand the broader impact of your promotion.
Remember, your dashboard is there to help you understand your marketing performance, whether you’re running campaigns independently or working with a promotional partner.
Now for the satisfying part: turning rows of numbers into something you can understand at a glance.
Create a Summary tab with four headline numbers:
Monthly royalties | Paid units | KENP read | Cost per subscriber
Underneath, add four simple charts:
Use conditional formatting to highlight campaigns with negative estimated ROI or declining engagement.
Keep your dashboard to one page if possible.
If you want interactive charts, connect your spreadsheet to Google Looker Studio. Its Google Sheets integration makes it possible to visualize data without building a custom application.
Your dashboard is only useful if you actually use it.
Fortunately, you don’t need to spend hours analyzing it.
Weekly: 15 minutes
Check sales, KENP activity, recent promotion results, and upcoming marketing dates.
Monthly: 45 minutes
Update royalties, review completed campaign windows, compare marketing costs, and check audience growth.
Most importantly, record what you change and why.
Your future self will appreciate knowing whether sales improved because you adjusted your price, updated your cover, or scheduled a promotion.
You don’t need the fanciest technology. You need something you’ll maintain.
| Tool | Best For | Main Limitation |
| Google Sheets or Excel | Beginners and budget-conscious authors | Manual updates |
| Google Sheets + Looker Studio | Authors wanting visual reports | More initial setup |
| Sales aggregation software | Authors publishing across multiple retailers | Subscription costs and coverage differences |
| Airtable or Notion | Authors already managing their business there | More configuration for detailed analytics |
| Custom dashboard | Technical authors with complex reporting needs | Development and maintenance |
For most indie authors, Google Sheets is the best place to start.
It’s flexible, familiar, and capable of tracking something that many dedicated sales tools overlook: the relationship between promotional spending and royalty results.
You can always upgrade later.
Building a dashboard is the setup. Using it to improve your author business is where the real value begins.
Here are some common patterns to watch.
| Your Dashboard Shows | What to Investigate | Your Next Move |
| Plenty of ad clicks, few sales | Book description, cover, pricing, reviews | Improve the retailer page |
| Strong book-one sales, weak read-through | Series positioning and reader expectations | Evaluate book two before increasing spend |
| High promotion costs, limited royalty lift | Channel, genre, pricing, timing | Test a different approach |
| Subscriber growth but falling engagement | Subscriber quality and email content | Segment your list by acquisition source |
| Strong sales in one retailer | Market-specific demand | Consider targeted marketing there |
Here’s an especially useful principle:
Don’t increase marketing spending until you understand what happens after readers discover your book.
If readers love book one and continue through your series, additional promotion may make sense.
If readers consistently stop after book one, spending more on discovery might not solve the underlying problem.
For example, if your dashboard shows that a discounted book promotion generated a noticeable increase in sales, you might consider testing another promotion or reaching a new audience through a service like Bargain Booksy.
The key is to use your results to guide your next marketing decision rather than relying on guesswork.
And remember, knowing which marketing opportunities to pursue is only part of the equation. Reaching the right readers and executing effective promotional campaigns are equally important pieces of a successful book marketing strategy.
Even a beautifully organized dashboard can lead to poor decisions if you misinterpret the numbers.
Watch out for these common mistakes.
Remember: Your dashboard should reduce marketing stress, not create a new source of it.
An author analytics dashboard is a centralized reporting system that combines book sales, royalties, advertising costs, promotional activity, and audience growth. It helps authors evaluate marketing performance and make informed publishing decisions.
Yes. Google Sheets and Excel are practical starting points, and Google’s free Looker Studio offering can turn spreadsheet data into visual reports. Some advanced integrations and third-party connectors require paid subscriptions.
A basic four-tab spreadsheet may take a couple of hours to set up. However, the time required depends on the number of retailers, book formats, and campaigns you track. Authors managing multiple sales channels may need additional time to organize and standardize their data.
It depends on your publishing goals. Royalties are essential for tracking income, while series read-through is particularly valuable for authors publishing connected books. Promotion ROI and cost per subscriber help evaluate marketing efficiency.
A weekly review is sufficient for many authors, with a more detailed monthly review for royalties, marketing ROI, and audience growth. During launches or active campaigns, more frequent checks can help identify problems.
Yes. You can combine data from Amazon KDP, Kobo, Apple Books, Barnes & Noble, Google Play, distributors, and direct sales channels. The challenge is standardizing different report formats, currencies, and reporting periods.
No. Basic spreadsheet skills are enough to create a useful dashboard. You can add charts, formulas, and automated reporting as your publishing business grows.
You became an author to write books, not spend your days decoding spreadsheets.
But understanding your marketing numbers can help you spend less time guessing and more time reaching the readers who will love your work.
Start small. Track your royalties, promotions, and audience growth. Review your results regularly. Then make one informed improvement at a time.
Your analytics dashboard doesn’t have to be perfect.
It just has to help you write a better business story.
Ready to Put Your Data to Work?
Building an analytics dashboard is one way to take control of your book marketing, but you don’t have to handle every part of your marketing strategy on your own.
Whether you’re looking to reach more readers, boost downloads, or promote your next release, Written Word Media’s book promotion services can help you put your insights into action.
📚 Know an author who has more spreadsheets than works in progress? Share this guide and help them bring their book marketing numbers together.