Skip to main content

How to use Power Table

Power Table lets you build the exact performance table you need. Choose the information that should define each row, choose the numbers you want to compare, and Power Table organizes the results automatically.

Open Analytics → Power Table to get started.

The easiest way to begin

Choose one of the Quick layouts, such as By Book Title or By Author, and then adjust its columns. You do not need to build every table from scratch.

Power Table showing a nested book, country, and platform performance report with royalties, spending, and advertising metrics

The two types of columns​

Power Table has two simple column types:

Column typeWhat it doesExamples
AttributesDecide how the data is grouped and nestedBook Title, Author, Series, Book Tags, Country, Platform, Book Format, Month and Year
MetricsShow the numbers calculated for each groupTotal Gross Royalties, Total Paid Units, KENP Reads, Total Spending, Total Net Royalties, Ad Orders, CPC, CTR

Think of attributes as the question and metrics as the answer.

Total Spending combines AMZ Spend + FB Spend + BookBub Spend + External Expenses into one column. The individual spending columns remain available when you need to see the breakdown.

For example:

  • Book Title → Country asks: “How did each title perform in each country?”
  • Author → Book Title → Month and Year asks: “How did each author's books perform over time?”
  • Book Tags → Book Title asks: “How did the books in each tag perform?”

Build a table in three steps​

1. Apply the page filters​

Use the filters above the table to choose the data Power Table should include:

  1. Select a Time Period.
  2. Add any extra filters you need, such as Book Titles, Authors, Series, Book Formats, Book Tags, Countries, or Platforms.
  3. Click Apply filters.

Filters limit the source data before the table groups or calculates it. This is useful when you want to study one launch, one pen name, one series, one country, or one sales platform.

Shared accounts

If you have Shared Access, use the account selector at the top of the page first. Power Table only includes the selected accounts and always follows the author and book restrictions granted by each account owner.

The Account attribute is only available when someone has Shared Access with you.

2. Select attributes and metrics​

Click Select columns….

  • Tick an attribute or metric to add it.
  • Untick it to remove it.
  • Drag selected items to change their order.
  • Close the dropdown when you are finished.

The table reloads once after the dropdown closes. This lets you make several changes without waiting after every click.

Your chosen layout is saved in this browser, so it returns after a refresh.

3. Put attributes in the order you want to read them​

Attribute order defines the table hierarchy from left to right.

For this order:

  1. Book Title
  2. Author
  3. Month and Year

Power Table first shows book titles. If a title contains multiple author or month values, those values can appear as nested rows beneath it.

You do not need to configure separate pivot levels. Add the attributes in the order you want, and Power Table handles the nesting.

Start broad, then become specific

Place your broadest attribute first and your most detailed attribute last.

  • Good: Author → Book Title → Month and Year
  • Good: Series → Book Title → Country
  • Good: Platform → Country → Book Format

Use the Quick layouts​

The Quick layouts create familiar tables with one click:

  • By Book Title — compare individual books and show covers.
  • By Author — compare authors or pen names.
  • By Country — compare geographic markets.
  • By Platform — compare Amazon, Apple Books, Kobo, Shopify, and other connected sources.

After selecting a Quick layout, you can still add, remove, or reorder any attribute or metric.

Expand and collapse nested results​

When an attribute has multiple values, use its show control to open that branch.

  • Expand all opens the nested rows for the current page in one request.
  • Collapse all returns to the top-level groups.
  • Opening one row only expands that branch.

If a group has only one value at the next level, Power Table keeps the table compact instead of adding an unnecessary duplicate-looking row.

For large tables

Use a narrower date range or apply a Book Title, Author, Series, Tag, Country, or Platform filter before expanding a very broad table. This makes the table faster and easier to read.

Sort any attribute or metric​

Select a column heading to sort it.

  • Select the same heading again to reverse the direction.
  • Sorting an attribute controls that nested level.
  • Sorting a metric ranks groups by that number.

Examples:

  • Sort Total Gross Royalties from highest to lowest to find your top performers.
  • Sort Month and Year in ascending order to read a timeline.
  • Sort Total Net Royalties to find the most or least profitable groups.
  • Sort Ad Orders to compare advertising results.

The total displayed beneath a metric heading covers all data matching the applied filters and search—not only the visible pagination page.

Make wide tables easier to read​

Freeze the first columns​

Select Freeze columns and choose how many leading columns should stay visible.

Freezing always works from left to right as one continuous range:

  • Freeze the first column
  • Freeze the first 2 columns
  • Freeze the first 3 columns
  • And so on

You cannot freeze a later column without freezing every column before it. This keeps row alignment correct while you scroll horizontally.

Change the table text size​

Use the Text − / + controls to change table text from 80% to 150%.

  • Select − for more columns on screen.
  • Select + for easier reading.
  • Select the percentage to reset to 100%.

The setting is saved in this browser and does not reload the data.

Use Compact mode​

Keep Compact enabled to reduce row padding and fit more data on screen. Turn it off when you prefer more space between rows.

Show book covers​

Add Cover from the Attributes section when the table includes Book Title or Book ID / ASIN.

Covers are most useful for title-first tables. If a cover is unavailable in the authorized book metadata, Power Table cannot display it for that row.

Search and pagination​

Use Search to find matching values in the selected attributes. For example, search for a title, author, tag, country, or platform that is part of the current layout.

Use Show entries to control how many top-level groups appear on each page. Nested rows belong to their parent group and do not create separate top-level pagination pages.

Download the table​

Open Download and choose an export style:

Flat CSV​

Choose Flat CSV when you want to analyze the data in Excel, Google Sheets, or another reporting tool.

  • Produces one row for each final attribute combination.
  • Repeats parent attributes on every applicable row.
  • Works well for formulas, charts, filtering, and additional pivot tables.

Nested CSV​

Choose Nested CSV when you want the export to preserve the Power Table hierarchy.

  • Includes parent rows and their totals.
  • Includes the nested breakdown rows.
  • Works well for reviewing or sharing the same structure shown on screen.
Which export should I use?

Use Flat CSV for further analysis. Use Nested CSV when the hierarchy itself is important.

Practical table examples​

Example 1: Find your strongest books​

Attributes

  1. Book Title
  2. Book Format

Metrics

  • Total Paid Units
  • Total Gross Royalties
  • Total Spending
  • Total Net Royalties

Sort by Total Net Royalties from highest to lowest. This shows which books keep the most revenue after recorded spending.

Example 2: Review a pen name month by month​

Attributes

  1. Author
  2. Book Title
  3. Month and Year

Metrics

  • Total Paid Units
  • KENP Reads
  • Borrows
  • Total Gross Royalties

Apply an Author filter first if you only want to review one pen name.

Example 3: Compare launch or catalogue tags​

Attributes

  1. Book Tags
  2. Book Title
  3. Country

Metrics

  • Total Paid Units
  • Total Gross Royalties
  • Total Net Royalties

This works well for tags such as Launch 2026, Backlist, Romance, or Needs Ads.

Books with multiple tags

A book with multiple tags appears inside every applicable tag group. For example, a book tagged Launch 2026 and Romance contributes to both groups.

Do not add the tag rows together as if they were mutually exclusive. Power Table's overall and parent totals count the underlying book data once, but the individual tag groups intentionally overlap.

Example 4: Compare advertising efficiency​

Attributes

  1. Book Title
  2. Platform
  3. Country

Metrics

  • AMZ Spend
  • FB Spend
  • BookBub Spend
  • Ad Impressions
  • Ad Clicks
  • Ad Orders
  • CPC
  • CTR
  • Cost per Ad Order
  • Ad Conversion Rate

Use this table to compare advertising activity and efficiency across titles and markets.

Advertising metrics

Advertising values only appear when that advertising data is available and correctly associated with the relevant books. A muted zero means no matching value was found for that row and filter combination.

Example 5: Compare sales platforms and expenses​

Attributes

  1. Platform
  2. Country
  3. Book Format

Metrics

  • Total Gross Royalties
  • AMZ Spend
  • FB Spend
  • BookBub Spend
  • External Expenses
  • Total Spending
  • Total Net Royalties

This is useful when you sell through several stores or record external royalties and expenses.

Example 6: Review multiple Shared Access accounts​

Attributes

  1. Account
  2. Author
  3. Book Title

Metrics

  • Total Paid Units
  • Total Gross Royalties
  • Total Spending
  • Total Net Royalties

Select the accounts at the top of the page before building the table. Only accounts and books you are permitted to view are included.

Tips for reliable comparisons​

  • Compare like with like: use the same date range and filters when comparing two layouts.
  • Put time attributes near the end unless the main purpose is a timeline.
  • Start with four or five metrics, then add more only when they answer a specific question.
  • Use Total Net Royalties for profitability and Total Gross Royalties for revenue before spending.
  • Use Month and Year instead of separate Month and Year columns when you need a chronological monthly view.
  • Freeze only the identifying columns you need; freezing too many leaves less room for metrics.
  • Use muted zero values to scan past groups with no activity.
  • Download a Flat CSV when you need calculations that are not part of Power Table.

Common questions​

Why did the table change after I reordered attributes?​

Attribute order defines the hierarchy. Moving Country before Book Title answers a different question from moving Book Title before Country.

Why does one book appear under several tags?​

Book Tags are multi-value attributes. A book appears under every tag assigned to it. Overall totals still count the underlying data once.

Why do I not see the Account attribute?​

Account is only shown to users with Shared Access. The selected shared accounts and their permission rules also control which data can appear.

Why is a cover missing?​

The book may not have a cover stored in the authorized metadata, or the table may not include Book Title or Book ID / ASIN.

Why are some advertising values zero?​

There may be no ad activity for that row, or the campaign data may not be associated with the selected book and filters.

Does Power Table send every transaction to my browser?​

No. Power Table groups, filters, sorts, and paginates data on the server. The browser receives the grouped rows needed for the current table.

Will my layout remain after refreshing?​

Yes. The selected layout, Compact preference, frozen-column count, and text size are saved locally in the current browser. Your raw performance data are not stored in browser local storage.