6/24/24 Updates
Refreshes every 3 hours (previously 1x per day)
Added the last updated date and time to the report to avoid confusion over data refresh cycles
Added Seatgeek and TM Resale QTY and Get-Ins in addition to TN
Added the name + email of the last person to adjust the criteria on each event
Added the number of tickets with criteria in addition to listings for each event
Separated the day of week out into its own column for better filtering
Freeze key columns, so users don’t lose their place when scrolling through the data
DIMR Overview
The Daily Inventory Management Report or “DIMR” will help users manage their uptick workflows to price their inventory. It contains insights on all events that users have criteria set for. If there are no criteria set on an event, the event will not appear in the report.
Key Functions
Refresh Rate: The DIMR refreshes every 3 hours, with a label at the top of the report showing the last refresh.
Event Linkouts: Selecting the "eye" icon next to any event's title will open that event directly in Uptick.
Sorting and filtering the DIMR:
All available fields are sortable in sortable by clicking the column header.
Columns can be dragged to be reordered or dragged off screen to be removed completely.
DIMR will remember the order you used in your browser for next time!
Columns can be "frozen" to avoid issues with losing your place when scrolling.
Drag the column to the left until you see the "pin icon"
Event name, venue, and date are frozen by default.
Filtering the DIMR: All fields can be filtered by clicking the icon next to the column name.
Multiple columns can be sorted simultaneously, each will be added as an additional "AND" filter.
The sorting and filtering can be updated by to the default by selecting the column reset button!
Downloading: At the top right corner, users will see an Excel icon, if clicked, this will export the DIMR for that day as .csv file.
Columns, Defined:
Column | Column Definition |
Event Name | Event name (the icon next to the event name links out to the event in uptick) |
Venue | Event Venue |
Event Date | Event date and time (event local time) |
Event Color | The color of the event in Uptick |
SG Get-In | The lowest-priced listing on Seatgeek |
SG QTY | The # of tickets remaining on Seatgeek |
TN Get-In | The lowest-priced listing on Ticketnetwork |
TN QTY | The # of tickets remaining on Ticketnetwork |
TMR Get-IN | The lowest-priced listing on Ticketmaster Resale |
TMR Quantity | The quantity remaining on Ticketmaster Resale |
Last Criteria Update | The last time there was a save/edit/delete of criteria for that event (In UTC) |
Last Updated By | The name and email of the last user to save/edit/delete criteria for an event |
Tickets With Criteria | Total # of active tickets in the POS for an event with criteria |
Listings With Criteria | Total # of active listings in the POS with criteria |
Listings at Floor | Total # of active listings at the floor in the POS for an event |
% of Listings At Floor | Percentage of listings at the floor for an event |
Average CP | Average calculated (market price) across listings for an event |
Notes | Last saved event note in Uptick |
Listings Sold | Total # of listings sold for an event |
Last Sale | Time of last sale (UTC) |
QTY Sold | Tickets sold for an event |
Total Sales Volume | Total dollar amount of inventory sold for an event |
Cost Sold | Total cost of tickets sold for an event |
ROI | Return on investment for an event (Sales-Cost/Cost) |