Product Use

Report Overview

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

Product Use 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

▤

View Sample Report

Open the Product Use PDF to see an example of the finished report, including product usage and revenue information.