/
Pricer Portfolio

Pricer Portfolio

Owned by Kaitlyn Niemann (Unlicensed), created
Last updated: Apr 26, 2024 by Albert Saludaga
2 min read

Requirements and Purpose

Allows individual Pricers and Managers to view their upcoming inventory and their relevant performance and market data for that event where applicable.

Report Definition

  1. Stakeholders

    1. @Kaitlyn Niemann (Unlicensed)

    2. @Mark Shaver

    3. Jake Kern

  2. Author

    1. @Kaitlyn Niemann (Unlicensed)

  3. Subject matter expert(s)

    1. Department employee

  4. Presentation Medium

    1. SSRS Reporting

  5. Fields (data)

    1. Pricer

    2. eEvent

    3. eVenue

    4. eDate

    5. Available Quantity

    6. Sold Quantity

    7. Last7DaysSales

    8. SevenDayVelocity

    9. PercSold

    10. MktInv

    11. GetIn

    12. TotalSale

    13. TotalCost

    14. Margins

    15. MaxPODate

    16. MasSODate

    17. DayTilEvent

    18. PossibleSalesQuantity

    19. SalesVelocity

    20. OverallVelocity

Data source(s)

The data gathered in this report is from the Eibo-215 Database and the STG Database. Using the stored procedure sr_GetPricerPortfolio.

  1. eiboxoffice

    1. dbo.TicketGroup

    2. dbo.BuyOrderTicketGroup

    3. dbo.BuyOrder

    4. dbo.SellOrderTicketGroup

    5. dbo.SellOrder

    6. dbo.Event

    7. dbo.Venue

    8. dbo.Region

    9. dbo.Production

  2. STG

    1. stg.users

    2. stg.pricerevents

Calculations

Column Name

Data Type

Calculation

Description

Column Name

Data Type

Calculation

Description

sc

Integer

=CHARINDEX(ISNULL(@event,h.eventname),h.eventname)+CHARINDEX(ISNULL(@event,o.eventname),o.eventname) > 0

search value for event

vc

Integer

=CHARINDEX(ISNULL(@venue,v.venuename),v.venuename)+CHARINDEX(ISNULL(@venue,r.RegionName),r.RegionName)+CHARINDEX(ISNULL(@venue,v.City),v.City) > 0

Search Value for Venue

eEvent

String

=CASE WHEN tg.SecondaryEventID = 1
THEN h.EventName
ELSE CONCAT(h.EventName,'\',o.EventName)
END eEvent,

Concatenation of Primary and Secondary Events

margin

decimal

(so.TotalTicketPrice-((tg.AverageTicketCost*s.Quantity)+0.0001))/(so.TotalTicketPrice+0.0001)

Calculates margins of sold inventory

PossibleSalesQuantity

decimal

CASE WHEN ISNULL(ad.SoldQuantity,0) = 0 THEN 0 ELSE (DATEDIFF(dd,@date,ad.eDate)*ad.SoldQuantity)/(DATEDIFF(dd,ad.MaxPODate,@date)+1.00) END PossibleSalesQuantity



SalesVelocity

decimal

CASE WHEN ISNULL(ad.SoldQuantity,0) = 0 THEN 0 ELSE ad.AvailableQuantity/(DATEDIFF(dd,ad.MaxPODate ,@date)+1.00) END SalesVelocity,



OverallVelocity

decimal

CASE WHEN ISNULL(ad.SoldQuantity,0) = 0 THEN 0 ELSE ad.SoldQuantity/(DATEDIFF(dd, ad.MaxPODate, @date)+1.00) END OverallVelocity



Parameters

  1. Filters

    1. Event

    2. Venue

    3. Event Start Date

    4. Event End Date

    5. Pricer

    6. Category

    7. Sold Start Date

    8. Sold End Date

    9. Sold Minimum %

    10. Sold Maximum %

    11. Margin Minimum %

    12. Margin Maximum %

  2. Grouping

    1. Pricer

    2. EventDate

    3. Event

    4. Venue

  3. Page breaks (Dashboards/Worksheets/Etc.)

  4. Intentions for printing vs. online viewing

    1. The report is delivered via SSRS

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

    1. SSRS On Demand

  6. Future maintenance tasks or manually maintained items

    1. None

Results

  1. Data Accuracy

    1. Report accuracy and reasons

  2. Limitations

    1. Report shortfalls

Change Log

  1. https://ticketboat.atlassian.net/browse/SP-272

  2. https://ticketboat.atlassian.net/browse/SP-276

  3. https://ticketboat.atlassian.net/browse/SP-286

Images

Related content