Overview
The Codes by Product Report provides a product-level, pivoted summary of all Bookshelf code activity. It shows code creation and redemption counts broken out by code type (billable, comp, sample, add-drop, and other non-billable codes) for each product. Use this report to monitor code volume trends and reconcile high-level activity before drilling into transaction-level detail.
Key Questions This Report Answers
How many codes were created and redeemed for a given product in a selected date range, broken out by code type?
Which products are generating the most code activity, and how does that break down between billable and non-billable codes?
How does redemption volume compare to creation volume for a specific product over a given period?
How to Use This Report
Start with the filters — Set your Filter Criteria (defaults to codes created OR redeemed in range) and Date Range first; both are required. Narrow further with Code Status, SKU, Item Name, Product Type, Code Distributor, or Publisher as needed.
Interpret the results — Each row represents a product (by SKU/Item Name); columns show counts of codes created and redeemed for each code type (billable, P+E, comp, add-drop, sample, and other non-billable).
Take action — Use the totals to monitor code volume trends by product and reconcile high-level activity. If you need transaction-level detail behind any total, refer to the companion Code Detail Report.
| 💡 Tip: Access is automatically scoped to the products your company owns in Manage, so you'll only see your own data. |
Filters
Filter Name | Description | Required? | Default Value | Example Values |
|---|---|---|---|---|
Filter Criteria | A multi-option filter that defines how the Date Range is applied to code activity (based on created date, redeemed date, or both). | Yes | Code Created (Date) OR Code Redeemed (Date) | Code Created (Date); Code Redeemed (Date); Code Created (Date) OR Code Redeemed (Date); Code Created (Date) AND Code Redeemed (Date) |
Date Range | Date range for when a code was created and/or redeemed, based on the Filter Criteria selected. | Yes | None specified | e.g., "Last 30 Days" or a specific date range |
Code Status | Current state of the code. | No | None | Values available in the report |
SKU | Item SKU the code was generated against. Supports multi-value search (up to 16,000 values pasted from a column or comma-separated list; semicolon-separated values are not supported). | No | None | One or more SKUs |
Item Name | Name of the product accessed using the code. | No | None | Product name |
Product Type | Format of the product the code was generated from. | No | None | Values available in the report |
Code Distributor | Company that distributed the code. | No | None | Distributor name |
Publisher | Publisher related to the distributed asset. | No | None | Publisher name |
Fields & Metrics
Field Name | Description | Data Type | Example Value |
|---|---|---|---|
SKU | Item SKU the code is generated against. | Text | SKU12345 |
Item Name | Name of the product accessed using the code. | Text | Example Product Title |
Publisher | Name of the publisher company related to the distributed code. | Text | Example Publisher Inc. |
Related Print ISBN | Related print ISBN of the code-generating VBID. | Text | e.g., a 13-digit ISBN |
Related Digital ISBN | Related digital ISBN of the code-generating VBID. | Text | e.g., a 13-digit ISBN |
License Duration (Online) | Duration of access to the online version of the material (in Bookshelf). | Text | e.g., 180 Days |
License Duration (Download) | Duration of access to the downloadable version of the material (in Bookshelf). | Text | e.g., 180 Days |
Product Type | Format of the product the code was accessed from (Demo, Package, Rental, Single). | Text | Package |
Billable Codes Created | Count of standard, billable codes created based on selected filters. | Number | e.g., 1,204 |
Billable Codes Redeemed | Count of standard, billable codes redeemed based on selected filters. | Number | e.g., 980 |
P + E Codes Created | Count of e-book codes created alongside a physical copy based on selected filters. | Number | e.g., 150 |
P + E Codes Redeemed | Count of e-book codes redeemed alongside a physical copy based on selected filters. | Number | e.g., 120 |
Comp Codes Created | Count of free digital copy codes created based on selected filters. | Number | e.g., 40 |
Comp Codes Redeemed | Count of free digital copy codes redeemed based on selected filters. | Number | e.g., 35 |
Add Drop Codes Created | Count of temporary codes created for day-one content access based on selected filters. | Number | e.g., 25 |
Add Drop Codes Redeemed | Count of temporary codes redeemed for day-one content access based on selected filters. | Number | e.g., 22 |
Sample Codes Created | Count of sampling codes created through the VitalSource sampling platform based on selected filters. | Number | e.g., 10 |
Sample Codes Redeemed | Count of sampling codes redeemed through the VitalSource sampling platform based on selected filters. | Number | e.g., 8 |
Other Non-billable Codes Created | Count of other non-billable codes created based on selected filters. | Number | e.g., 5 |
Other Non-billable Codes Redeemed | Count of other non-billable codes redeemed based on selected filters. | Number | e.g., 4 |
Frequently Asked Questions
Q: Why don't my numbers match the Code Detail Report?
A: This report shows pivoted summary totals, while the Code Detail Report shows transaction-level detail. Make sure your Date Range and Filter Criteria selections match between the two reports before comparing totals.
Q: What's the difference between "P + E" and "Comp" codes?
A: P + E codes are e-book access codes issued alongside a physical copy purchase. Comp codes are free digital copies issued outside of a standard sale.
Q: Why do I only see data for some of my products?
A: Access is automatically filtered to show only products that your company owns in Manage, so you'll only see totals for the products you're associated with.