The number of books published in the last 30 days for this month and last month.Ranks of the #1 and #100 book in each category for this month and last month.You can use this to find appropriate categories for your own work, and to look at the ranks and level of activity in each category. And, there might be a time when you want to find everything underneath a particular category, I guess. parentName and parentBrowseNodeID are the name and browse node ID of the parent category for the current one again this isn’t super-useful, although I do use it to construct the ‘category path’ column.Practically as an author, you can probably ignore this, except it’s the best way to uniquely identify a specific category (handy in situations where there are two or more commonly-confused categories). Specifically, what the URL for the Top 100 for that category will be, as well as the ‘Last 30 Days’ page, the ‘Last 90 Days’ page, and the ‘Preorders’ page. There are a standard set of pages for each category: given the browse node ID for a category, you can work out what the URLs will be for them. browseNodeID is the unique reference number for each category.As above, nLast30Days (last month) is listed at the end of the spreadsheet if you want to compare them. Activity Trend tells you whether the number of books published in the last 30 days has gone up or down since last month.So it’s really only accurate to within an order of magnitude, but maybe still useful with that caveat. Frustratingly for us, Amazon rounds this heavily to the nearest 1000, or sometimes 10000. nLast30Days is the (rounded) number of books published in the last 30 days in this category, which is a crude proxy measure of activity.‘Book1Rank (last month)’ and ‘Book100Rank (last month)’ are listed at the end of the spreadsheet (to the right) if you want to check how big the increase or decrease is. Rank Trend tells you whether the Best Seller Rank of the #1 book has gone up or down since last month.This will change, of course, but it’s a crude proxy measure of how many books the category is selling. Book1Rank and Book100Rank are the Best Sellers Rank of the #1 and #100 book in the category as at the time I snapshotted it.just drop me an email and I’ll be happy to help you out. If you have any questions about sorting, filtering etc. If you don’t have any of those, Google Sheets is a good free online alternative. This is an XLSX file, so you can open it in pretty much any spreadsheet program: Excel, LibreOffice, Numbers.

Kindle store books