The Audible Content Sales Royalty Report; downloadable in Excel XLS format, provides a summary of royalty earnings by country subtotaled by title. Each title is identified by an audible product code. To import Audible sales into our royalty software you must first create editions for each Audible ProductID under the appropriate tile. Use the Audible ProductID as the ISBN and assign a product format based on your royalty rules.
Sales Import Mappings
Due to the formatting of the Audible report; with merged columns and wrapping text, column headers may not always display in the drop down field lists. If this occurs use the field name indicated in the mapping table below.
Warning: Always reference the quantity and royalty earned amounts shown in the grand total section of the Audible report. These amounts are in columns 16 and 19.
Because the Audible files does not have columns for sale date or customer enter these values in the “or use this value” column.
The software will convert the 2 character Audible market code (Mkt) to the appropriate country name.
|Insert into:||From (your column headers):||or use this value:|
|ProductID||Product ID (Field2)|
|TotalSale||Field19 (Royalty Earned)|
Ignore when any of the following fields are blank should have a value of Mkt. This will cause the royalty software to ignore the title total and grand total rows in the Audible file.