welcome to the publisher alley prior season analysis tutorial the prior season analysis compares a publishers suggested buys from a previou
Welcome to the Publisher Alley Prior Season Analysis Tutorial
The prior season analysis compares a publisher's suggested buys from a
previous season to the number of units actually sold by B&T during the
Before logging on to Pub Alley, follow download instructions at
AlleyTalk.com to get the prior season macro. The macro is a small
program that will run on your computer at the end of this
After log-in, open a prior season Buy Report. You can select one
from the homepage or click Buy Reports at left to see the
When the report opens, click Clone in the menu bar.
A dialog window pops up. Enter a new name for the report, choose
Clone Buy Quantities only, and click OK. Do not change the Buy
The screen will dim, and you'll have the choices shown above.
Click Open cloned report.
The cloned report opens. Note that it contains only the new titles
from this presentation, and that the suggested buy quantities are
preserved. Click Email in the menu bar.
The screen will dim. When prompted about category buying, click
In the dialog box that appears, confirm that the e-mail address is
yours and enter a Subject. Click Send at the bottom of the dialog
When the email arrives, double-click to open the report. We will
use this Excel worksheet only to cut and paste the ISBNs for
When the report opens, click once on the header for Column C to
select it. Then, right-click in the highlighted area and select
Open a new spreadsheet and click into cell A1. Right-click and
select "Paste." The column of ISBNs will appear.
Click Data and Sort from the toolbar. Sort by Column A as shown.
Copy the ISBNs to your clipboard so that you can paste them into
Pub Alley. (Contact us for additional copy/paste techniques if
needed.) Once you have copied a maximum of 100 ISBNs, leave this
spreadsheet and re-enter Publisher Alley.
After selecting the cells, hold down the Ctrl key and type the
letter C. The cells will then have a dotted line around them as
shown at left. Leave this sheet as-is and re-enter Publisher
We will transfer the ISBNs from your clipboard to the cloned
report. This tutorial works from the All Titles page. You can also
transfer ISBNs directly using the Add Comp Titles link in the
Click add multiple ISBNs. When the dialog box at left appears,
paste up to 100 ISBNs. Click Add. Then, click Submit.
When results appear, use the Check All button in the toolbar to
select all of the titles. Then, click Buy Report.
Select the radio button to add these as comparable books and click
Select the radio button next to the name of your cloned report.
Check the box for the first book listed in the cloned report.
Publisher Alley confirms that the titles were added as
comparables. Click The buy report to complete the export of data.
When the report opens, you'll see all of the titles added as
comparables to the ISBN you selected. We have combined ACTUAL
sales and demand data on the same report with your suggested buys.
Click Sort in the menu bar and select Category as the Primary
Sort. You can also apply a secondary sort within each
category--for example, "catalog page." Click OK.
Click Email in the menu bar. The screen will dim. Select No in
response to the question about category buying.
In the dialog box that appears, check to be sure your address is
correct. Enter a subject and click Send.
When the report arrives via email, double-click to open it.
IMPORTANT: When the report opens, do not click anywhere inside it.
The cell containing "Buy Recommendation Report" must remain
outlined as shown above.
Pull down the Tools menu and select "COMP Title Fix" (this is the
small program that you installed).
Click Start to begin the macro.
The macro will display its progress. Click OK when prompted.
Your final Prior Season Analysis report will include yellow rows
with Sell Thru calculations: these are the percentages of
recommended buy quantities that actually sold in the original time
period. (The period is 30 or 60 days, depending on the original
This is the summary tab of the report. The "Grand Totals" grid at
top shows results overall. In this case, suggested buys for IL and
NJ were too low, NV quantities were too high, and GA quantities
were very appropriate. The remainder of the summary divides
results by category.
This concludes the Publisher Alley Prior Season Analysis Tutorial.