![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |