Sales Overview
Monitor product capacity, utilization, and booking activity across all trips.
The Sales Overview report gives you a real-time view of how your trip products are performing. It shows capacity, reservations, and utilization status for every product across your workspace, helping you spot availability issues before they become problems.
How it works
The Sales Overview supports two view modes that give you different perspectives on your product performance. Switch between them using the View chip at the top-right of the filter bar.
View modes
Trip Products (default) -- One row per product within a trip. This is the demand-side view, showing how each individual trip product is performing. Each row displays the product type, trip name, product name, supplier, dates, and a utilization bar.
Inventory Products -- One row per inventory product, with data aggregated across every trip that consumes it. This is the supply-side view, showing how your inventory is being utilized in aggregate. Each row displays the product type, inventory product name (with SKU), supplier, the number of linked trip products, and aggregated utilization.
The inventory products view is useful when you want to see overall demand for a resource that is shared across multiple trips -- for example, a hotel room block used by three different tour packages.
Only products that have defined capacity or at least one reservation appear in the report. This keeps the view focused on products that matter. Cancelled booking lines are excluded from all calculations — only non-cancelled bookings within non-cancelled orders appear in results, so cancelled activity does not skew your counts or utilization figures.
Utilization status
Each product receives a color-coded utilization bar and status label based on the percentage of capacity used:
| Status | Color | Threshold |
|---|---|---|
| No reservations | Gray | No bookings yet (0 reserved) |
| Low | Amber | Less than 40% of capacity used |
| Normal | Green | Between 40% and 79% of capacity used |
| Near capacity | Blue | Between 80% and 99% of capacity used |
| Sold out | Indigo | Capacity completely used (100%) |
| Overbooked | Red | More reservations than available capacity |
| Uncapped | Striped | No capacity limit defined -- shows the reserved count without a percentage |
The utilization bar fills proportionally to show how close the product is to capacity. Overbooked products show a full bar with a label indicating how many reservations exceed the cap (e.g., "+3 over").
Capacity inheritance
Some trip products inherit their capacity from a linked inventory product rather than defining their own. These products display a link icon next to the product name with a tooltip showing which inventory product governs their capacity. In this case, the utilization bar reflects the inventory pool's capacity rather than any trip-product-level setting.
This shared pool model means multiple trip products may draw from the same inventory allocation. The inventory products view mode aggregates these consumers into a single row, giving you a clear picture of total demand against available supply.
Variants
Some products have multiple variants (e.g., room types or ticket classes). Each variant tracks its own capacity and reservation count independently. You can expand a product row to see the breakdown by variant. The parent row's utilization aggregates across all variants -- total reserved and total capacity are summed from the variant level. If any variant has no capacity limit, the aggregate is treated as uncapped.
Filters
Use the filter bar at the top of the report to narrow results. Filters appear as compact chips in a horizontal bar. The date filter is always visible. Other filters appear only when you add them, keeping the toolbar clean.
| Filter | Description |
|---|---|
| Date | Filter by product starting date. Defaults to the next 60 days. |
| Supplier | Show only products from one or more suppliers. |
| Inventory item | Filter by one or more linked inventory products. |
| Trip | Filter by one or more specific trips. |
| Segment | Filter by one or more order segments. |
| Label | Filter by one or more order labels. |
| Product type | Show only products of a specific type (e.g., Accommodation, Flight). |
| Search | Free-text search across product name and code. |
Each chip shows the filter name and its current value. You can:
- Click a chip to open its popover and change the value.
- Remove a chip by clicking the X icon on the chip.
- Add more filters by clicking the + button and choosing from the available options.
- Clear all filters by clicking the X button at the end of the filter bar to reset back to defaults.
Date filter options
The date filter has two settings: the date field and the date range.
Date field controls which date is used for filtering:
- Travels on (default) -- filters by the product's service/departure date. Use this to see what is coming up on specific dates.
- Booked on -- filters by when the booking was placed. Use this to analyze booking activity during a specific period regardless of when the trips actually depart.
Switch between these two modes using the toggle at the top of the date filter popover.
Date range supports two modes:
- Relative dates -- filter by a rolling window such as "next 60 days" or "last 3 months". You choose the direction (next or last), a number, and a unit (days, weeks, or months). Relative dates recalculate automatically each time you open the page.
- Absolute dates -- pick specific start and end dates using date pickers. Use this for fixed reporting periods.
Saved views
You can save your current filter and export configuration as a named view so you can quickly switch between different setups without re-configuring each time. Views store filters, column selections, and export modes together as a single named configuration.
Saving a view
- Set up the filters you want to save.
- Click the bookmark icon at the left side of the filter bar.
- Click + Save current.
- Enter a name for the view.
- Optionally check Share with workspace to make the view visible to all team members.
- Optionally check Make default for me to have this view load automatically when you open the Sales Overview.
- Click Save.
Private vs shared views
Views are private by default -- only you can see and use them. When you check Share with workspace, the view becomes visible to all team members. Shared views can be loaded by anyone, but only the owner can edit or delete them. This lets you prepare standard views for your team (e.g., "Next 30 Days - Accommodation Only") while team members can also create their own private views.
Loading a saved view
Click the bookmark icon to open the views popover. Your saved views are listed along with any views shared by other team members. Click a view name to apply its filters and export configuration. The active view is indicated with a checkmark.
Managing views
When you hover over a view you own, management controls appear:
- Star icon -- toggle whether this view is your personal default. When set, the view loads automatically each time you open the Sales Overview page (unless you navigate to the page with specific filters in the URL).
- People icon -- toggle whether the view is shared with your workspace. Shared views are visible to all team members but can only be edited or deleted by the owner.
- Trash icon -- delete the view. You are asked to confirm before deletion.
What views store
A saved view remembers:
- All filter settings (date range, supplier, inventory item, trip, segment, label, product type, search)
- Export configuration (change mode, row mode, and selected columns)
When you load a view, both the filters and the export panel configuration are restored. Changes to column selections while a view is active are auto-saved back to the view after a short delay.
Updating a saved view
If you modify the filters while a saved view is active, the bookmark icon shows an orange dot to indicate unsaved changes. Open the views popover and click Save changes to "[view name]" to update the view with your current filters. Only the view owner can save changes.
Clearing a view
To stop using a saved view and return to the default filters, open the views popover and click Clear.
Viewing bookings
Click on a product row to drill down into the individual bookings for that product. This shows all non-cancelled orders associated with the product, including participant and payment details.
The drill-down applies the trip product's capacity counting rules and each booking's quantity multiplier when computing reserved capacity. This means the reserved numbers in the drill-down match the parent row's Reserved value exactly.
Exporting data
The export workflow is accessible through the button group at the top-right of the filter bar, which offers four actions: Download (immediate CSV), Preview data, Deliver (send by email), and Configure columns. The full export panel has three tabs: Configure, Preview, and Deliver.
Export modes
You configure the export with two settings:
Change mode controls what data is included:
- Current Status -- One row per active booking as it currently stands. This is a snapshot of the current state.
- Changelog -- One row per change event within the selected date range. Includes who made the change, when, and what type of change (Added, Updated, or Deleted).
Row mode controls the level of detail:
- Per Booking -- One row per booking with participant counts summarized.
- Per Participant -- One row per individual participant, with full participant details including seat assignments and per-participant pricing.
Selecting columns
The export panel shows column groups that you can toggle on or off:
| Group | Columns included |
|---|---|
| Changelog (Changelog mode only) | Change type, reference, timestamp, and who made the change |
| Booking | Product name, type, variant, status, dates, days, nights, price, external reference, internal notes |
| Order | Order code, order status, trip name |
| Customer | Name, email, phone, unique ID, address, city, zip, country, nationality, customer type, company name, tax ID, date of birth |
| Participant | Participant name, type, email, phone, unique ID, nationality, date of birth, gender, seat reference, seat price, per-participant price |
The Days column counts both the start and end dates inclusively (e.g., a product running June 1--3 shows 3 days). The Nights column counts the difference between start and end dates (e.g., the same product shows 2 nights).
The Participant group expands or contracts based on your row mode selection -- in Per Booking mode it shows summary counts, while in Per Participant mode it shows full individual details.
Your column selections are remembered for each mode combination, so you only need to configure them once. When a saved view is active, column selections are stored with the view and auto-saved as you change them.
Previewing before export
After configuring the change mode, row mode, and columns, click the Preview tab to see a sample of the first 50 rows in a table directly in the panel. The preview uses the same filters and column configuration that the final export will use. This lets you verify the data shape before committing to a download or email send.
From the preview, you can:
- Download CSV -- downloads the full result set (not just the preview rows) as a ZIP file.
- Back to configure -- return to the column picker to adjust settings.
Downloading directly
Click the Download button in the button group to immediately download a CSV based on the current filters and column configuration. No need to open the export panel first.
Sending by email
Instead of downloading the CSV directly, you can have Itsy generate the export and email it to any address. This is useful for sharing reports with colleagues or scheduling regular data pulls.
- Click Deliver in the button group (or open the export panel and switch to the Deliver tab).
- Enter the recipient's email address (defaults to your own).
- Optionally add a message that will be included in the email.
- Click Queue delivery.
The export is generated server-side and delivered as a CSV attachment. You receive a confirmation notification when the delivery is queued.
How it connects
- Trip products view shows products from your Trips -- each row represents a product within a trip.
- Inventory products view shows products from your Inventory -- each row aggregates demand across all trips consuming that inventory item.
- Capacity and variant data are managed in Inventory. Products with inherited capacity show the inventory pool values.
- Supplier information links to your Suppliers configuration.
- Drill-down bookings connect to individual Orders.
- Segments and Labels are available as filters to narrow the report to specific business areas or custom groupings.