/
AtoZ 1.0: Decoding Column Data and Representations

AtoZ 1.0: Decoding Column Data and Representations

Owned by Fritze Calderon
Last updated: Jan 11, 2024
5 min read

Goal: Optimize Market Operations and Expand Opportunities through Automated Buying and Enhanced Market Visibility

Objectives:

1: Consolidate Primary and Secondary Markets for Total Market Overview

  • Develop a unified system that combines primary and secondary market data to provide a comprehensive view of the entire market.

  • Implement robust data integration and analysis mechanisms to track and analyze market trends, demand patterns, and pricing dynamics.

2: Automate Buying Process from the Secondary Market

  • Design and implement an automated buying system that leverages machine learning algorithms to identify and execute favorable purchasing opportunities in the secondary market.

  • Integrate the automated buying system with relevant platforms and databases to streamline the procurement process.

  • Implement automated systems for Purchase Orders (P.O.), pricing, sale-invoicing, and delivery to reduce manual errors and increase transactional efficiency.

Getting Started:

  1. Log in to http://192.168.10.210/

  2. Click on AZ-AZ-Level 1 report.

Note: The primary column should represent the sum of tickets from primary market such as Ticketmaster, Evenue, http://tickets.com , Tessitura, and Eventbrite. Currently, our data collection is primarily focused on Ticketmaster, serving as the source of the primary data. However, as we expand, we will include other primary markets at the AtoZ Level 1 report and update this documentation accordingly. Similarly, the secondary column represents data sourced from SeatGeek, secondary markets are seatgeek, TEVO, EIBO, APEX.

Understanding the Columns:

A to Z Columns

Description

Calculations

A to Z Columns

Description

Calculations

Event Name

 

 

Event Time

Date and time of event

 

Venue Name

Event venue

 

Venue City

Event city.

 

Venue State

Event state.

 

Days Since First Secondary Sale

The first sale on the secondary market, like SeatGeek, TEVO, EIBO, etc. Can be recognized by a decrease in inventory numbers.

MIN(PurchasedDatetime) from api.SeatgeekSales

Days Until Event

This is the duration in days between the current date and the date when the event is scheduled to take place.

 

Tickets Sold Total Primary

Number of tickets sold in the primary. (Assume sold)

venuecapacity-ticketsavailableprimary = tickets sold primary

Tickets Sold Total Secondary

 

SUM(api.seatgeeksales.Quantity)

Listings Primary

Number of ticket groups.

COUNT(*) from PrimaryMarkets.dbo.ticketmaster_offers2

Tickets Available Primary

Total ticket counts.

SUM(Quantity)  from PrimaryMarkets.dbo.ticketmaster_seating2 WHERE FACE_VALUE > 0 and INVENTORY_TYPE <>  'resale'

Standard Tickets Available Primary

Total counts of standard tickets.

TicketsAvailablePrimaryStandard = SUM(Quantity) from PrimaryMarkets.dbo.ticketmaster_seating2
FACE_VALUE > 0 and
INVENTORY_TYPE <> 'resale' and
(offer.name LIKE '%Standard%') 

Non-Standard Tickets Available Primary

Total counts of non-standard tickets, including platinum, premium, VIP tickets and other variations.

ticketsavailableprimarynonstandard = ABS(ticketsavailableprimary - ISNULL(ticketsavailableprimarystandard,0))

Tickets Available Primary Standard Non-Single

Total counts of standard consecutive seats/tickets.

ticketsavailableprimarynonstandard = ABS(ticketsavailableprimary - ISNULL(ticketsavailableprimarystandard,0))

Listings Secondary

Number of listings on the secondary market. (Seatgeek as source of data counts)

COUNT(api.marketlistings.*) WHERE TicketTypeisSeatGeek

Tickets Available Secondary

Total ticket counts available.

SUM(api.marketlistings.availableQuantity) WHERE TicketType = SeatGeek

Get-In Secondary

This would be the cheapest price of any tickets on the secondary market.  Making sure to exclude things such as parking, VIP passes, etc

MIN(api.marketlistings.WholesalePrice) WHERE TicketType is SeatGeek

Get-In Primary

This is the cheapest priced tickets on the primary market.

MIN(Face_Value) from PrimaryMarkets.dbo.ticketmaster_offers2

Primary Per Ticket Fee

This is the add of fees per ticket from the primary market.

MIN(dbo.ticketmaster_offers.total_price - dbo.ticketmaster_offers.face_value)

Primary Total Price

This is the face value+the per ticket fee+ the per order fee.

 

Primary Per Order Fee

This is the per order fee if they have a per order fee.

MIN(dbo.ticketmaster_offers.total_charges - dbo.ticketmaster_offers.total_price + dbo.ticketmaster_offers.face_value)

Spread

This is the difference between the get in secondary minus the get in primary total price.

 

Category

This is the category of the event, examples would be NFL, MLB, country, rock, theater, etc.

 

Pricer

This would be the individual from TicketBoat company that is the current pricer of the event.

 

Venue Capacity

This is the capacity of the venue the event is being held at. (source: TM)

SUM(Seats) from PrimaryMarkets.VENUE_CAPACITY

% Remaining

Capacity remaining

(TicketsAvailablePrimary / VenueCapacity ) * 100

Date Event First Seen

First date the event was seen in our database.

 

URL

Primary market URL for the event.

 

Inventory Held

This is the amount of inventory Ticket Boat current has for the event.

 

Inventory Sold

This is the number of tickets that Ticket Boat has sold for this event.

 

Margin %

How much we are making per ticket overtime.

 

Sold-out

Standard tickets for the event have been completely sold out on the primary market. (YES or NO tagging)

 

Effective Sell-Out

Evaluating the level of sell-out effectiveness based on the number of remaining single tickets, tickets that are almost sold out, and standard pairs (sets of two tickets)

 

Cancelled

This is if the event has been cancelled on the primary market. (YES or NO tagging)

 

InHand

 

 

InHand On

Dates of tickets in hand

 

GA Seats

Total GA seats.

 

Reserved Seats

Tota available reserved seats.

 

Eibo Status

We retrieve all productions in EiBO, specifically those with an active or pending status. This ensures comprehensive coverage of events in the EiBO platform, including pending events.

 

Smoothed Velocity

 

 

Should Sell-out

Velocity sold vs.  velocity available

 

Tickets at a Get In

Remaining quantity of tickets that are at the lowest price break (current)

 

% of Get-ins

This column represents the percentage of the total available tickets that are at the lowest price break.

(Original cheapest Price Tickets / Total Tickets) * 100

% of Get-ins Remaining

This column represents the percentage of the current number of cheapest price tickets that are still available.

(Cheapest Price Tickets Remaining / Original Cheapest Price Tickets) * 100

Last Updated On

Timestamp of the most recent data update.

 

Buy Request

This would be if Ticket Boat has put in an automated buy request on this event.

 

Notes

This is the button to click in order to add notes to the event.

 

Ignored

Allow users the option to toggle whether they want to exclude or disregard the event.

 

 

Understanding of the purpose and calculation methods for each filter utilized in the AtoZ level 1 report.

FILTERS

Purpose

Calculations

FILTERS

Purpose

Calculations

Pricer

Filter by pricer (can be filtered by multiple pricer)

 

Venue Name

 

 

Min-Max Tickets Available

(Primary Standard Non-Single)

 

 

Category

Filter by Category (can be filtered by multiple category)

 

Event Date (Start)

To filter the start date.

 

Event Date (End)

To filter the end date.

 

Only Winners

This Filter should tell us about the shows that are going to sell out and have not sold out yet.

winnersecondaryformula = velocitysecondary * daysuntilevent - ticketsavailablesecondary


winnerprimaryformula   = velocityprimary * daysuntilevent - ticketsavailableprimary

Matched Events Only

Events that have been matched between the primary and secondary market.

 

Only Sold-out Shows

Lists of sold-out shows.

 

Only Cancelled Shows

Lists of cancelled shows.

 

Less than 5% Primary

 

(TicketAvailablePrimaryNon-Single/VenueCapacity)

Only New Events

Events observed within a 7-day timeframe, focusing on newly added events.

 

Show Ignored Events

To show the lists of ignored events.

 

Filter by Per Price-Break

A method that enables us to identify when the best price breaks for tickets are approaching sell-out, rather than waiting for the last 20 tickets which tend to be the least desirable.

 

Filter by Inventory

Filter to look by inventory available on Ticketmaster and highest SeatGeek sales.

 

 

Related content