/
T-Mobile Center Report Distressed and Comparing

T-Mobile Center Report Distressed and Comparing

Owned by Albert Saludaga
Last updated: Jan 10, 2024
1 min read

This report will show data from events of the T-Mobile Center for distressed and comparing.

Report Definition

  1. Author

    1. (TBA)

  2. Presentation Medium

    1. SSRS Portal

  3. Fields (Data)

    1. Event Name

    2. Opponent

    3. Venue Name

    4. Event DateTime

    5. Days On Market

    6. Days Until Show

    7. Seat Geek Sold Quantity

    8. Tickets Available Primary

    9. Velocity Sold

    10. Straight Line Number of Tickets Expected to Sell

    11. Surplus or Undersupply of Inventory

  4. Grouping

    1. Event Name

    2. Opponent

    3. Event Date Time

    4. Days on Market

    5. Days Until Show

  5. Intentions for printing vs. online viewing

    1. The report is delivered via SSRS

    2. This report can be accessed here: TBPortal → SSRS Reports → Asset → T-Mobile Center Report Distressed and Comparing

  6. Intended delivery mechanism (run on demand vs. delivered by subscription)

    1. On Demand

  7. Future maintenance tasks or manually maintained items

    1. N/a

Data Source(s)

The data used in this report is gathered from the STG Database. Also gets data from the Eibo-215 Database.

Calculations

 

Calculation

Description

 

Calculation

Description

Seat Geek Sold Quantity

SUM(sales.Quantity)

Returns the total quantity of tickets sold from Seat Geek on each event.

Tickets Available Primary

SUM(az.ticketsavailableprimary)

Returns the total quantity of tickets available primary.

Ticket Sold Primary

SUM(az.ticketssoldtotalprimary)

Returns the total quantity of tickets sold primary.

Velocity Sold

SUM(az.ticketssoldtotalprimary) * 1.0 / (DATEDIFF(DAY, p.CreatedDatetime, GETDATE()))

Calculates the velocity sold.

Straight Line Number of Tickets Expected to Sell

(SUM(az.ticketssoldtotalprimary) * 1.0 / (DATEDIFF(DAY, p.CreatedDatetime, GETDATE()))) * (DATEDIFF(DAY, GETDATE(), p.EventDate))

Calculates the straight line number of tickets expected to sell.

Surplus Or Undersupply of Inventory

SUM(az.ticketsavailableprimary) - ((SUM(az.ticketssoldtotalprimary) * 1.0 / (DATEDIFF(DAY, p.CreatedDatetime, GETDATE()))) * (DATEDIFF(DAY, GETDATE(), p.EventDate)))

Returns the number of surplus or undersupply of inventory.

 

Related content