Table of Contents
September 2020
Upgrades to downloaded and emailed reports in Excel format.
If you often download reports in Excel format - great news! We've made some upgrades to the download format to make Excel exports from SalesData & LibraryData easier to work with. Notably:
- Blank cells will properly register as "Blanks" when using tools like Find > Go to Special > Blanks
- Numerical columns are formatted as numbers, and can be automatically summed, averaged, and counted in Excel's bottom toolbar.
If you use any pre-saved macros, you may want to check that they will still work with these changes.
My Reports: More Clarity about the Saved and Scheduled Status of your reports
The My Reports page now includes additional information about your saved reports, particularly some additional clarity around whether they have been Shared to any colleagues or are set as part of a Scheduled Email.
- If a report IS shared or scheduled, you will see "View/Edit" in the "Share Report" and "Schedule Email" columns.
- If a report IS NOT shared or scheduled, you will see "Share" or "Schedule" in those columns.
This can help you remember if other colleagues may be receiving or using your reports before you make changes to or delete a saved report.
July 2020
How to Hard Reset your Browser if the SalesData site isn't loading properly:
We did a feature release on the SalesData site overnight, so there may be a conflict between the version online now and the version in your browser's cache that might cause some issues.
Clearing your browser's cache or doing a "hard reload" should solve the issue.
- On Chrome, you can do a hard reload by opening View > Developer > Developer Tools, and then right-clicking on the reload icon (the circular arrow next to the URL bar) and selecting "Empty Cache and Hard Reload"
- On Edge: Hold down the Ctrl key and then press your F5 key, or, hold down the Ctrl key and then click the Refresh button.
- On Firefox: Hold down the Ctrl Key and then press F5, or hold down the Shift key and Ctrl key, and then press the R key.
...
We have updated this to better reflect the marketplace and the data we have available to better account for copies that may have been received and sold during a week period. This change better reflects sell through, especially for new books.
The calculation is now: Units sold in the given period / (On Hand in the given period + Units Sold in the given period)
So, for a book this week that has 10 Units Sold and 50 copies On Hand:
...
When setting up a Buying Gaps report, you may notice that some markets' names in the "Select a home market" dropdown are now followed by an asterisk (*):
Markets with an asterisk have insufficient inventory data, usually because one or more of the retailers contributing to that aggregate don't supply inventory data. This means the Buying Gaps report may return titles that are in stock in the selected home market, since the inventory data we have is incomplete and therefore can't be verified. The Buying Gaps report will always return titles that have no sales reported in the selected home market.
Gap Analysis: Inventory Performance
The "Select a home market" dropdown in the Inventory Performance Gap Analysis report has also been modified so you can more easily identify markets with complete and actionable inventory data available — after all, you can only analyze inventory performance if you have data about a market's inventory!
To make your Inventory Performance home market selection process speedier, we've marked aggregates with unavailable inventory data with an asterisk (*), and you will not be able to run Inventory Performance reports on home markets without inventory data.
Update your saved passwords!
The password for the SalesData Research Portal has changed, so if you want access to all of BookNet's subscriber-only research reports you'll want to swing by the Research Portal box in the right-hand sidebar of the home page for the new password.
...
July 2017
Home Page Customization: You can now view your home page data in either Units Sold or Value Sold (List)
...