Ad Hoc Comparative Sales Template

This report is focused on Direct Customer Info.  Ingram Wholesale Customer information will be rolled up to Ingram Wholesale.

Filters

• Date Range
• Direct Fulfillment
• EAN
• Title
• Medium
• Imprint
• Brand Category
• eCommerce Sale Ind
• Territory
• IPS Sales Region
• Market Segment
• Destination Region: This region is based on the destination country (regions are: USA, Canada, or International).
• Front List
• Sales Rep
• Publisher

Customer

• Destination Region: This region is based on the destination country (regions are: USA, Canada, or International).
• HQ Account Number: Headquarter Account Number
• Headquarter: The customer's headquarter name.
• The IPS Sales Region: The contractual sales region assignment for international, domestic and Canada customers.
• Market Segment: Customer Grouping at the Market level
• Market Segment Types (Not all Market Segments are listed)
  • Retail
  • Library International Wholesaler
  • Gift Retailer
  • Book Club
  • Catalog and Direct Response
  • Canadian Merchandising Wholesaler
  • Corporate Account, Retail Internet
  • Specialty Distribution Center
  • Wholesaler
• SL Account Number: An Ingram account number assigned to a customer’s shipping address, (Shipping Location).
• SL Country:  Shipping Location country.
• Shipping Location: Where product is shipped.
• Territory : Customer grouping based on channel.
• Territory Types:
  • • National
    • Digital
    • Publisher Account
    • Field Sales
    • Gift
    • Canada
    • Wholesale
    • Library
    • International
    • Special
    • Mass Merch
    • POD
    • Historical Load
    • Unknown
    • Wholesale Exports

Item

• Author: Author
• BISAC Category: Book Industry Standards and Communications. These are industry approved subject descriptors.
• Brand Category: Publisher defined category set up through the client manager and maintained in CoreSource.
• Canadian Price: The price the book is sold in Canada.
• Client Cost:  The cost assigned to the book in USD.
• Discount Code:  Discount Code defines the discount class to which an item belongs.  The code values are: C - Categorized Remainder, D - Destroy and R- Restock.
• Disposition: Instructions for how to handle the unit or carton return of a product.
• EAN: 13-digit code used to identify the product (ISBN).
• Format
• Format Types (Not all Formats are listed)
  • • Paperback / Softback
    • Hardback
    • Multiple Copy Pack
    • Spiral Bound
    • CD-Audio
    • Digital (Delivered Electronically)
    • Mobipocket
    • Digital Download
    • Epub
    • Ebook
    • PDF
• Front List: Front list are titles with a pub date in the last six months from the day the report is pulled.
• IBC Status:  The status of product at Ingram Book Company.
• IBC Status Types (Not all IBC Status Types are listed)
  • • Available
    • Out of Stock
    • Out of Stock Indefinitely
    • Out of Print
    • Not Available
    • Cancelled
    • Not Yet Received – Past Pub Date
    • Not Yet Received – Future Pub Date
• List Amount: The current list price of the title in USD.
• Medium: Identifies Physical vs Digital
• Print to Order: Identifies if an item is available from Lightning Source on a print-to-order basis. Values are Y=Yes or N=No.
• Product Type: Print, Audio, Other, etc.
• Pub Date: From CoreSource, publisher defined expected date for product to be available.
• Publisher Status: Publisher status of titles at Ingram, pulled in from CoreSource.
• Publisher Status Types (Not all Publisher Status Types are listed)
  • Active
  • Forthcoming
  • Postponed Indefinitely
  • Cancelled
  • No longer our product
  • Out of stock indefinitely
  • Out of print
  • Inactive
  • Unknown
  • Remaindered
  • Withdrawn from sale
  • Recalled
  • Active, but not sold separately
  • Recalled
  • Temporarily withdrawn from sale
  • Permanently withdrawn from sale
• Release Date:  The date initial new title backorders are released to the warehouse for fulfillment.
• Series: Series
• Title: Title

Publisher

• Publisher: Publisher name.

Publisher Sales Rep

• Publisher Sales Rep: Sales rep at the publisher.

Sales Measures

Current is the time frame selected (between Start Date and End Date).

• Current Gross Invc: All current Gross Invoices.
• Current Net Invc: Current Gross Invoices minus Return Credit.
• Current Return Credit: The current customer credit for Returned Units. 
• Current Return Percent: The percentage of Returns to Gross Sales.
• Net Invc Variance: The variance between current and previous time frames.

Previous is 1 year prior to the Current time frame selected (between [Current Start Date minus 1 year] and [Current End Date minus 1 year]).  

• Previous Gross Invc: All previous Gross Invoices.
• Previous Net Invc: Previous Gross Invoices minus Return Credit.
• Previous Return Credit: Previous customer credit for Returned Units. 
• Previous Return Percent: The percentage of Returns to Gross Sales.