The Product Use report provides an analysis of products and services ordered during a selected reporting period. Results can be grouped by event, revenue type, supplier, or event year, with options to filter by product type, customer type, and order status.
Description
This report displays products and services ordered within a selected range of order and event dates. It can be used to analyze product usage, quantities, and revenue across events.
The Group By parameter controls how results are organized, including options to group by event, revenue type, supplier, or year. You can also display results without grouping.
Use Products to Include to focus on standard products, custom items, cancellation fees, credits, telephone usage charges, or a combination of these product types.
Additional options allow you to print product codes, sort by quantity or revenue, separate Excel export results into tabs, and distinguish products by their selected attributes.
Report Example
Available Parameters
Use the following parameters to select the products and orders included in the report and customize how results are organized.
| Field Name | Available Values | Default |
|---|---|---|
| Customer Type(s) | Exhibitor EAC Show Organizer |
All Customer Type(s) |
| Status(es) | Payment Pending Confirmed Cancelled Closed |
Payment Pending Confirmed Closed |
| Event Date to Use | Event Start Dates Event End Dates |
None |
| Group By | None Event Only Revenue Type Only Event then Revenue Type Event then Supplier Event Start Year Event End Year |
Revenue Type |
| Starting Event Date | Any date | None |
| Ending Event Date | Any date | None |
| Order Start Date | Any date | Beginning of time |
| Order End Date | Any date | Today's date |
| Revenue Type(s) | All revenue types defined in your system | All |
| Print Product Codes | No Yes |
No |
| Products to Include | Standard Products Custom Items Cancellation Fees Credits Telephone Usage Charges |
All product types |
| Suppliers | Any supplier in the system with products | All suppliers with products |
| Sort By | Product Display Order Quantity Revenue |
Product Display Order |
| Separate Tabs on Excel Export | Yes No |
Yes |
| Group Product by Attributes | No | Not specified |
Parameter Details
Event Date to Use: Determines whether the event date range is evaluated using event start dates or event end dates.
Starting Event Date and Ending Event Date: Define the event date range used to filter results. These dates refer to either event start dates or event end dates, depending on the selected Event Date to Use option.
Group By: Determines how results are organized. Options include no grouping, grouping by event or revenue type, grouping events by revenue type or supplier, and grouping by event start or end year.
Products to Include: Controls which types of products and charges appear in the report. By default, all product types are included.
Separate Tabs on Excel Export: Controls whether the Excel export separates results into individual tabs.
Group Product by Attributes: Appends product attribute values to the product name so that different attribute selections appear as separate products in the report. For example, carpet in different colors can be reported separately rather than combined under one product name.
Tip: To identify your most frequently ordered products, select Quantity under Sort By. To compare products based on the revenue they generate, select Revenue. You can also use Group By to compare product activity across events, revenue types, or suppliers.
Sample Report
Open the Product Use PDF to see an example of the finished report, including product usage and revenue information.