/
A to Z 2.0

A to Z 2.0

Owned by Raymund Sanchez
Last updated: Jan 11, 2024
4 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 Ticket Boat Portal

  2. Click on AtoZ 2.0

Note: The primary column should represent the sum of tickets from primary market such as Ticketmaster, Evenue, Tickets.com - A Ticket Exploration Engine - Sports, Concerts, Theater, Arts & More , 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

 

 

 

 

City

 

Event city.

 

 

 

State

Event state.

 

 

 

 

Lead Type

 

 

 

 

 

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

 

 

 

On-Sale Date

 

 

 

 

 

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 Last 24 Hours

 

 

 

 

 

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'

 

 

 

Tickets Available Primary Standard

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%') 

 

 

 

Tickets Available Primary Non-Standard

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))

 

 

 

Tickets Sold Secondary

 

SUM(api.seatgeeksales.Quantity)

 

 

 

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

 

 

 

Get-In w/o Fees

 

 

 

 

 

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)

 

 

 

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)

 

 

 

Venue Capacity

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

SUM(Seats) from PrimaryMarkets.VENUE_CAPACITY

 

 

 

% Remaining Primary

Capacity remaining

(TicketsAvailablePrimary / VenueCapacity ) * 100

 

 

 

Date Event First Seen

First date the event was seen in our database.

 

 

 

 

Ticketmaster URL

Primary market URL for the event.

 

 

 

 

Last Updated

Timestamp of the most recent data update.

 

 

 

 

Is Sold out?

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

 

 

 

 

Is Cancelled?

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

 

 

 

 

Inventory Sold

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

 

 

 

 

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.

 

 

 

 

% of Get-in Primary

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-in Primary 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

 

 

 

Eibo Production ID

 

 

 

 

 

Genre

 

 

 

 

 

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.

 

 

 

 

Match Type

 

 

 

 

 

Matched_PKID

 

 

 

 

 

TM_Matched

 

 

 

 

 

SG_Matched

 

 

 

 

 

WINNERPRIMARYFORMULA

 

 

 

 

 

WINNERSECONDARYFORMULA

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

FILTERS

Purpose

Calculations

FILTERS

Purpose

Calculations

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