Columns and signals
Every column a Screen can filter on, sort by or show: what it measures, where its value comes from, and the plan that opens it.
The screener, Views, Digests, the API and the MCP read the same list, under the names below. A Signal column is one a View hunts on, such as a price move or a demand score; the rest set the scope or a floor.
Read a column
ea.columns describe the event's market,e.the event itself andv.its venue.pa.columns describe the performer across all of their events, andp.namenames them._currentis the newest reading._delta_7dis the change over 7 days in the column's own unit,_pct_7dthe same change in percent, and_d1or_d7the change in a score or a rank.aipin a name means the all-in price, fees included. A price without it is the seller's price before fees.- A column labeled SH, SG, TM, TM resale or MLB reads that one source. An unlabeled price column reads Ticker's main resale source, shown as VS where a label compares the two.
- An as-of column says when its group's reading was taken. Gate on it so an old reading does not screen as live.
- A z column, in σ, measures a move against the event's own normal swing: past 2 either way stands out. (peer) sets the event against similar events, the same subcategory at a similar distance from event day. (tour) sets it against the performer's other dates.
- The type says where a value comes from. Observed is read from a market. Change compares two readings. Derived is worked out from readings. As of stamps a reading. Social reads the performer's X account, and Prediction market reads a traded chance.
Plans
A column that names a plan shows its values on that plan and above. On a lower plan the column stays in the list and its values are withheld: a Screen that filters or sorts on it is refused with the plan that opens it. A column with no plan named reads on every plan.
Event & timing
| Column | What it measures |
|---|---|
Days to eventea.days_to_eventEvent fact, days | Whole days until the event. Negative once it has passed. |
Priced as ofea.last_price_snapshot_dateObserved, date | The day of the price reading behind this row. Filter on it to keep stale prices out of a screen. |
Categorye.category_idEvent fact, category | Concerts, Sports or Theater. |
Date addede.created_atEvent record, time | The day Ticker first found the event. A recent date often means a newly announced event. |
Date TBDe.date_tbdEvent fact, yes or no | Yes while the date is not announced. The date columns are not reliable while it is yes. |
Event ide.event_idEvent record, id | The event's id, the key that joins its event, analytics and performer columns. Use Public id to name an event to someone. |
Evente.event_nameEvent fact, text | The event's name as it is listed. |
If necessarye.if_necessaryEvent fact, yes or no | Yes when the event takes place only if it is needed, like a playoff game that may not be played. |
Last pricede.last_price_collectedEvent record, time | When Ticker last took a price reading of the event. Empty before the first one. |
Local datee.local_dateEvent fact, text | The date and start time in the venue's own time zone, as text. Compare times with UTC date. |
Prioritye.monitoring_priorityEvent fact, 1 to 10 | How closely Ticker follows the event, from 1, the closest, to 10. Read an as-of column to see how fresh a reading is. |
On-sale datee.onsale_dateEvent fact, time | When tickets go on sale. Many events have none; use 'is empty' to find them. |
Performer ide.performer_idEvent record, id | The id of the event's main performer, the key to the performer columns. Empty when the performer is not known. |
Presale datee.presale1_dateEvent fact, time | When the first presale starts. Many events have none; use 'is set' to find them. |
Statuse.statusEvent fact, text | Active, inactive or canceled. A Screen only reads active events. |
Subcategorye.sub_category_idEvent fact, category | Genre, league or format, for example Rock, NBA or Musical. |
Time TBDe.time_tbdEvent fact, yes or no | Yes while the start time is not announced. |
Primary statuse.tm_event_statusEvent fact, text | The primary market's own status for the event: onsale, offsale, cancelled, rescheduled or postponed. Separate from Status: an event can be active in Ticker and off sale on the primary market. |
Last primary reade.tm_last_collected_atEvent record, time Max plan | When Ticker last read the primary market for the event. To gate primary prices, use 'TM as of', which stamps the reading itself. |
Primary on-sale starte.tm_onsale_start_atEvent fact, time | When the public on-sale starts on the primary market. Prefer On-sale date, which includes this value and leaves out placeholder dates. |
Primary on-sale ende.tm_onsale_end_atEvent fact, time | When the public on-sale ends on the primary market. A time in the past means the primary sale window is closed. |
UTC datee.utc_dateEvent fact, time | The date and start time in UTC. |
Venue ide.venue_idEvent record, id | The id of the event's venue, the key to the venue columns. |
Performerp.namePerformer fact, text | The performer the row's performer columns describe. For a game this is one team, not the event name. Filter it with 'contains'. |
Public ide.public_idEvent fact, id | Ticker's id for the event: the one in its page link, exports, the API and the MCP. Use it to name an event to someone. |
Primary hot evente.tm_hot_eventEvent record, yes or no Max plan | The primary market's own high-demand flag for the event. Empty when the primary market does not state it. |
Primary checkout opene.tm_transactableEvent record, yes or no Max plan | Yes when the primary market sells tickets for the event at all. Empty when it does not state it. |
Location
| Column | What it measures |
|---|---|
Venuev.venue_nameVenue fact, text | The venue's full name. Example: Madison Square Garden, never 'MSG'. |
Capacityv.capacityVenue fact, count | Seats in the room. Roughly: under 1,000 is a club, 1,000 to 4,999 a theater or hall, 5,000 to 19,999 an arena, 20,000 and over a stadium or festival. Empty where the size is not known, so a size filter leaves those events out. |
Cityv.cityVenue fact, text | The venue's city. Example: New York. Brooklyn and Elmont are separate values. |
Statev.stateVenue fact, text | The venue's state or province. Example: NY. US and Canada only. |
Countryv.country_codeVenue fact, text | The venue's country. Example: US. |
Pricing
| Column | What it measures |
|---|---|
Lowest faceea.lowest_face_value_currentObserved, dollars | Lowest face value printed on the tickets on sale. Only events where the marketplace states a face value carry it, so a screen on it leaves the rest out. |
Highest faceea.highest_face_value_currentObserved, dollars | Highest face value printed on the tickets on sale. Empty when no ticket states a face value. |
Lowest all-inea.lowest_aip_price_currentObserved, dollars | Lowest price with all fees included, so what a buyer pays at checkout. |
Lowest priceea.lowest_price_currentObserved, dollars | Lowest price on sale before fees. |
Median priceea.median_price_currentObserved, dollars | Middle price on sale before fees: half cost more, half cost less. |
Median all-inea.median_aip_price_currentObserved, dollars | Middle price with all fees included: half cost more, half cost less. |
P25 priceea.p25_price_currentObserved, dollars | A quarter of the tickets on sale cost less than this, before fees. |
P75 priceea.p75_price_currentObserved, dollars | Three quarters of the tickets on sale cost less than this, before fees. |
Lowest price %Δ7dea.lowest_price_pct_7dChange, percent | How far the cheapest ticket price has moved since a week ago, as a percentage. Positive means the entry price got more expensive. |
Median price Δ7dea.median_price_delta_7dChange, dollars | How many dollars the middle price has moved since a week ago. Positive means prices went up. |
Median price Δ14dea.median_price_delta_14dChange, dollars | How many dollars the middle price has moved since two weeks ago. Slower than the 7 day change, so it shows the trend instead of the noise. |
Median price Δ28dea.median_price_delta_28dChange, dollars | How many dollars the middle price has moved since four weeks ago. The slowest of the price-change columns, best for reading the direction over a month. |
Median price %Δ7dea.median_price_pct_7dChange, percent | How far the middle price has moved since a week ago, as a percentage. Positive means the whole market got more expensive, not just one listing. |
P25 price %Δ7dea.p25_price_pct_7dChange, percent | How far the P25 price moved in a week, in percent. |
P75 price %Δ7dea.p75_price_pct_7dChange, percent | How far the P75 price moved in a week, in percent. |
Avg faceea.average_face_value_currentObserved, dollars | Average face value printed on the tickets on sale. Compare it with Median price to see how far above face the market trades. |
Median price 7d agoea.median_price_7d_agoObserved, dollars | The middle price before fees a week ago. |
Resale / primary all-inea.resale_to_primary_aip_ratioDerived, multiple Max plan | Cheapest resale ticket with fees, divided by the cheapest box-office ticket with fees. Under 1 means resale is cheaper than the box office; 1.5 means resale costs half as much again. Gate on 'TM as of' and 'Priced as of' so both prices are fresh. |
VS / TM resale all-inea.vs_to_tmr_aip_ratioDerived, multiple Max plan | Cheapest ticket with fees, divided by the cheapest TM resale ticket with fees. Over 1 means TM resale is cheaper; 1.25 means this price is a quarter above TM resale. The two cheapest tickets are often in different sections. Gate on 'TM as of' and 'Priced as of' so both prices are fresh. |
VS minus TM resale all-inea.vs_minus_tmr_aip_spreadDerived, dollars Max plan | Cheapest ticket with fees, minus the cheapest TM resale ticket with fees, in dollars. Positive means TM resale is cheaper by that much. Gate on 'TM as of' and 'Priced as of' so both prices are fresh. |
Median faceea.median_face_value_currentObserved, dollars | Middle face value of the tickets on sale. Less pulled by one odd ticket than Avg face. |
P25 faceea.p25_face_value_currentObserved, dollars | A quarter of the tickets on sale carry a face value below this. Empty with fewer than 2 tickets that state one. |
P75 faceea.p75_face_value_currentObserved, dollars | Three quarters of the tickets on sale carry a face value below this. Empty with fewer than 2 tickets that state one. |
Lowest all-in Δ1dea.lowest_aip_price_delta_1dChange, dollars | How far Lowest all-in moved since the day before, in dollars. Positive means it went up. |
Lowest all-in Δ7dea.lowest_aip_price_delta_7dChange, dollars | How far Lowest all-in moved over a week, in dollars. Positive means it went up. |
Lowest all-in %Δ1dea.lowest_aip_price_pct_1dChange, percent | How far Lowest all-in moved since the day before, in percent. |
Lowest all-in %Δ7dea.lowest_aip_price_pct_7dChange, percent | How far Lowest all-in moved over a week, in percent. |
Lowest price Δ1dea.lowest_price_delta_1dChange, dollars | How far Lowest price moved since the day before, in dollars. Positive means it went up. |
Lowest price Δ7dea.lowest_price_delta_7dChange, dollars | How far Lowest price moved over a week, in dollars. Positive means it went up. |
Lowest price %Δ1dea.lowest_price_pct_1dChange, percent | How far Lowest price moved since the day before, in percent. |
Median price Δ1dea.median_price_delta_1dChange, dollars | How far Median price moved since the day before, in dollars. Positive means it went up. |
Median price %Δ1dea.median_price_pct_1dChange, percent | How far Median price moved since the day before, in percent. |
P25 all-inea.p25_aip_price_currentObserved, dollars | A quarter of the tickets on sale cost less than this, fees included. Empty with fewer than 2 listings that state an all-in price. |
P75 all-inea.p75_aip_price_currentObserved, dollars | Three quarters of the tickets on sale cost less than this, fees included. Empty with fewer than 2 listings that state an all-in price. |
P25 price Δ1dea.p25_price_delta_1dChange, dollars | How far P25 price moved since the day before, in dollars. Positive means it went up. |
P25 price Δ7dea.p25_price_delta_7dChange, dollars | How far P25 price moved over a week, in dollars. Positive means it went up. |
P25 price %Δ1dea.p25_price_pct_1dChange, percent | How far P25 price moved since the day before, in percent. |
P75 price Δ1dea.p75_price_delta_1dChange, dollars | How far P75 price moved since the day before, in dollars. Positive means it went up. |
P75 price Δ7dea.p75_price_delta_7dChange, dollars | How far P75 price moved over a week, in dollars. Positive means it went up. |
P75 price %Δ1dea.p75_price_pct_1dChange, percent | How far P75 price moved since the day before, in percent. |
SH
| Column | What it measures |
|---|---|
SH lowest all-inea.sh_lowest_aip_price_currentObserved, dollars Max plan | Cheapest SH resale ticket with all fees included, from the newest SH reading. Empty when there is no reading or no listing. Gate on 'SH as of'. |
SH lowest priceea.sh_lowest_price_currentObserved, dollars Max plan | Cheapest SH resale ticket before fees, from the newest SH reading. Gate on 'SH as of'. |
SH median all-inea.sh_median_aip_price_currentObserved, dollars Max plan | Middle all-in price of the listings in the newest SH reading. Gate on 'SH as of'. |
SH median priceea.sh_median_price_currentObserved, dollars Max plan | Middle price before fees of the listings in the newest SH reading. Gate on 'SH as of'. |
SH ticketsea.sh_tickets_currentObserved, count Max plan | Tickets listed in the newest SH reading. Zero means read and empty; empty means never read. Counts do not compare across sources. Gate on 'SH as of'. |
SH lowest all-in Δ7dea.sh_lowest_aip_price_delta_7dChange, dollars Max plan | How far the cheapest SH ticket with all fees moved in a week. SH sets its fee level per read, so this can move on fees alone. Gate on 'SH as of'. |
SH lowest all-in %Δ7dea.sh_lowest_aip_price_pct_7dChange, percent Max plan | The same weekly move as a percentage. Gate on 'SH as of'. |
SH lowest price Δ7dea.sh_lowest_price_delta_7dChange, dollars Max plan | How far the cheapest SH ticket before fees moved in a week. Empty until SH has a reading from a week before. Gate on 'SH as of'. |
SH lowest price %Δ7dea.sh_lowest_price_pct_7dChange, percent Max plan | The same weekly move as a percentage. Gate on 'SH as of'. |
SH as ofea.sh_asof_atAs of, time Max plan | When the newest SH reading was taken. Filter on it so an old reading does not screen as live. |
SG
| Column | What it measures |
|---|---|
SG lowest all-inea.sg_lowest_aip_price_currentObserved, dollars Max plan | Cheapest SG resale ticket with all fees included, from the newest SG reading. Empty when there is no reading or no listing. Gate on 'SG as of'. |
SG lowest priceea.sg_lowest_price_currentObserved, dollars Max plan | Cheapest SG resale ticket before fees, from the newest SG reading. Gate on 'SG as of'. |
SG median all-inea.sg_median_aip_price_currentObserved, dollars Max plan | Middle all-in price of the listings in the newest SG reading. Gate on 'SG as of'. |
SG median priceea.sg_median_price_currentObserved, dollars Max plan | Middle price before fees of the listings in the newest SG reading. Gate on 'SG as of'. |
SG ticketsea.sg_tickets_currentObserved, count Max plan | Tickets listed in the newest SG reading. Zero means read and empty; empty means never read. Counts do not compare across sources. Gate on 'SG as of'. |
SG lowest all-in Δ7dea.sg_lowest_aip_price_delta_7dChange, dollars Max plan | How far the cheapest SG ticket with all fees moved in a week. SG sets its fee level per read, so this can move on fees alone. Gate on 'SG as of'. |
SG lowest all-in %Δ7dea.sg_lowest_aip_price_pct_7dChange, percent Max plan | The same weekly move as a percentage. Gate on 'SG as of'. |
SG lowest price Δ7dea.sg_lowest_price_delta_7dChange, dollars Max plan | How far the cheapest SG ticket before fees moved in a week. Empty until SG has a reading from a week before. Gate on 'SG as of'. |
SG lowest price %Δ7dea.sg_lowest_price_pct_7dChange, percent Max plan | The same weekly move as a percentage. Gate on 'SG as of'. |
SG as ofea.sg_asof_atAs of, time Max plan | When the newest SG reading was taken. Filter on it so an old reading does not screen as live. |
TM resale
| Column | What it measures |
|---|---|
TM resale lowest priceea.tmr_lowest_price_currentObserved, dollars Max plan | Cheapest ticket resold on TM, before fees. Empty when the event has no TM resale market. Gate on 'TM as of'. |
TM resale all-inea.tmr_lowest_aip_price_currentObserved, dollars Max plan | Cheapest TM resale ticket with all fees included. Gate on 'TM as of'. |
TM resale median priceea.tmr_median_price_currentObserved, dollars Max plan | Middle price before fees on the TM resale market. Empty when the event has no TM resale market. Gate on 'TM as of'. |
TM resale median all-inea.tmr_median_aip_price_currentObserved, dollars Max plan | Middle price with all fees included on the TM resale market. Empty when the event has no TM resale market. Gate on 'TM as of'. |
TM resale ticketsea.tmr_tickets_currentObserved, count Max plan | How many tickets are being resold on TM. Gate on 'TM as of'. |
TM
| Column | What it measures |
|---|---|
TM lowest priceea.tm_lowest_price_currentObserved, dollars Max plan | Cheapest box-office ticket, not a resale, before fees. Many events have no TM box office, so gate on 'TM as of'. |
TM lowest all-inea.tm_lowest_aip_price_currentObserved, dollars Max plan | Cheapest box-office ticket with all fees included. Gate on 'TM as of'. |
TM ticketsea.tm_tickets_currentObserved, count Max plan | How many tickets the box office still has. Empty means not reported, zero means none left; gate on 'TM as of'. |
TM tickets Δ1dea.tm_tickets_delta_1dChange, count Max plan | How many more or fewer tickets the box office has than the day before its latest reading. Negative means fewer are left. Gate on 'TM as of'. |
TM tickets Δ7dea.tm_tickets_delta_7dChange, count Max plan | How many more or fewer tickets the box office has than a week before its latest reading. Negative means the box office is emptying. Gate on 'TM as of'. |
TM lowest price Δ7dea.tm_lowest_price_delta_7dChange, dollars Max plan | How far the cheapest box-office ticket moved in a week, before fees. Gate on 'TM as of'. |
TM lowest all-in Δ7dea.tm_lowest_aip_price_delta_7dChange, dollars Max plan | How far the cheapest box-office ticket with all fees moved in a week. Gate on 'TM as of'. |
TM lowest all-in %Δ7dea.tm_lowest_aip_price_pct_7dChange, percent Max plan | How far the cheapest box-office ticket with all fees moved in a week, in percent. Gate on 'TM as of'. |
TM tickets %Δ3dea.tm_tickets_pct_3dChange, percent Max plan | How far the box office's ticket count moved in three days, in percent. -100% means it went from tickets on sale to none. Gate on 'TM as of'. |
TM sellse.tm_sellsEvent fact, yes or no Max plan | Yes when TM sells the event as its own box office. No when TM does not list it, lists only resale, or lists another company's sale. |
TM as ofea.tm_asof_atAs of, time Max plan | When the TM columns were last read. Filter on it so an old reading does not screen as live. |
MLB
| Column | What it measures |
|---|---|
MLB lowest priceea.mlb_lowest_price_currentObserved, dollars Max plan | Cheapest ticket on the club's own box office, before fees, ordinary public seats only. Gate on 'MLB as of'. |
MLB lowest all-inea.mlb_lowest_aip_price_currentObserved, dollars Max plan | Cheapest box-office ticket with the fees the club discloses. Can be empty while the face price is known. Gate on 'MLB as of'. |
MLB ticketsea.mlb_tickets_currentObserved, count Max plan | How many tickets the club's box office has available. Zero means the box office was read and had none; empty means no reading. Gate on 'MLB as of'. |
MLB currencyea.mlb_currencyObserved, text Max plan | USD or CAD. Prices are never converted, so filter on it before comparing clubs. |
MLB as ofea.mlb_asof_atAs of, time Max plan | When the box office itself measured the MLB columns. Filter on it so an old reading does not screen as live. |
MLB completenessea.mlb_completenessObserved, category Max plan | complete, partial (a newer read failed, values are the last good ones) or unknown. Gate on 'MLB as of'. |
MLB price methodea.mlb_price_methodObserved, category Max plan | How the box office priced the reading: exact-pricepoint, reserved-detail, macro-reference, mixed or unsupported. Gate on 'MLB as of'. |
MLB lowest price Δ1dea.mlb_lowest_price_d1Change, dollars Max plan | How far the cheapest box-office ticket moved since the day before, before fees. Gate on 'MLB as of'. |
MLB lowest all-in Δ1dea.mlb_lowest_aip_price_d1Change, dollars Max plan | How far the cheapest all-in box-office ticket moved since the day before. Gate on 'MLB as of'. |
MLB tickets Δ1dea.mlb_tickets_d1Change, count Max plan | How many more or fewer tickets the club's box office has than the day before. A change in what is available, never a count of purchases. Gate on 'MLB as of'. |
Inventory & demand
| Column | What it measures |
|---|---|
Absorbed 1dea.absorption_count_1dObserved, count | How many tickets left the market on the day of 'Absorption as of': listings that disappeared, not confirmed purchases, because a seller can also pull a listing or let it expire. A ticket that comes back on sale comes off the count, so a day can be negative. Read it beside Added 1d. |
Absorbed 7dea.absorption_count_7dObserved, count | How many tickets left the market in the 7 days ending on 'Absorption as of': listings that disappeared, not confirmed purchases, because a seller can also pull a listing, move it to another exchange or let it expire. Read it as a stand-in for demand. A ticket that comes back on sale comes off the count, so a figure can go down later and can be negative. Judge it against Tickets. |
Absorption rate 7dea.absorption_rate_7dDerived, 0 to 1 | The share of the market that emptied out in the 7 days ending on 'Absorption as of': tickets gone divided by tickets gone plus tickets listed on that day. From 0 to 1 whenever Absorbed 7d is 0 or more. When Absorbed 7d is negative the rate is negative too and can fall far below -1, so read Absorbed 7d beside it. |
Added 1dea.listings_added_count_1dObserved, count | How many tickets sellers put up on the day of 'Absorption as of'. Empty, not 0, when the event has no ticket-flow reading. |
Added 7dea.listings_added_count_7dObserved, count | How many tickets sellers put up in the 7 days ending on 'Absorption as of'. A jump means supply is piling in, which often pushes prices down. |
Absorption coverageea.absorption_grainDerived, text | Whether Ticker follows the event's listings closely enough to count tickets in and out. 'listing' means it does; empty means the ticket-flow columns have no reading. |
Absorption qualityea.absorption_data_qualityDerived, 0 to 1 | How complete the ticket-flow reading behind Absorbed and Added is, from 0 to 1. Low means thin coverage, not a quiet market. Keep it at 0.5 or more to leave weak readings out. |
Absorption as ofea.absorption_asof_dateAs of, date | The day the ticket-flow columns describe. The 1d columns are that day, and the 7d columns are the 7 days ending on it. |
Inv velocityea.inventory_velocity_1dDerived, 0 to 1 | How much the number of listings changed in a single day, as a share of the listings on sale. Beyond about 0.15 either way is a big one-day swing in supply. |
Listingsea.listings_currentObserved, count | Resale listings on sale now, not box-office stock. One listing can hold several tickets, so this counts listings, not seats. |
Listings Δ1dea.listings_delta_1dChange, count | How far Listings moved since the day before, as a count. Positive means it went up. |
Listings Δ7dea.listings_delta_7dChange, count | How many more or fewer listings there are than a week ago. Negative means sellers are leaving the market. |
Listings %Δ1dea.listings_pct_1dChange, percent | How far the number of listings moved since the day before, in percent. |
Listings %Δ7dea.listings_pct_7dChange, percent | How far the number of listings moved in a week, in percent. |
Inv velocity (tour)ea.inventory_velocity_1d_xs_z_tour_tteDerived, σ | Inv velocity set against the performer's other dates at a similar distance from event day. Past 2 either way stands out. Empty when there are fewer than 5 such dates. |
Secondary remainingea.percent_remainingObserved, percent | Listed tickets as a share of venue capacity on the secondary market, meaning resale rather than box office. Above 100 means more tickets are listed than the room holds, which points at a wrong capacity rather than at the market. Empty when there is no snapshot yet. |
Ticketsea.tickets_currentObserved, count | Tickets on sale across every resale listing, not box-office stock. This one counts seats, not sellers. |
Tickets Δ1dea.tickets_delta_1dChange, count | How far Tickets moved since the day before, as a count. Positive means it went up. |
Tickets Δ7dea.tickets_delta_7dChange, count | How many more or fewer tickets are on sale than a week ago. Negative means fewer seats are available. |
Tickets %Δ1dea.tickets_pct_1dChange, percent | How far the number of tickets on sale moved since the day before, in percent. |
Tickets %Δ7dea.tickets_pct_7dChange, percent | How far the number of tickets on sale moved in a week, in percent. |
Inv velocity rank (peer)ea.inventory_velocity_1d_pct_rank_subcat_tteDerived, 0 to 1 | Where Inv velocity ranks among similar events, the same subcategory at a similar distance from event day, from 0 for the lowest to 1 for the highest. Empty when there are fewer than 30 similar events. |
Inv velocity (peer)ea.inventory_velocity_1d_xs_z_subcat_tteDerived, σ | Inv velocity set against similar events: the same subcategory at a similar distance from event day. Past 2 either way stands out. Empty when there are fewer than 30 similar events. |
Primary remainingea.tm_percent_remainingObserved, percent Max plan | Tickets the box office still has, as a share of venue capacity, on the primary market. Above 100 means more tickets are listed than the room holds, which points at a wrong capacity. Empty when the venue capacity is not known. Gate on 'TM as of'. |
Primary remaining Δ7dea.tm_percent_remaining_delta_7dChange, percent Max plan | How many points the box office's share of the room moved in a week, on the primary market. Negative means the box office is emptying. Empty when either reading or the venue capacity is missing. Gate on 'TM as of'. |
Primary GA tickets remainingea.tm_ga_tickets_currentObserved, count Max plan | General admission tickets the box office still has, with every GA area added together, so a floor and a pit read as one total. GA floors at seated venues count too. Zero means none left. Empty means no usable GA count, which includes events with no GA section. Price columns beside it, such as Median %Δ7d, cover the whole event. Gate on 'GA as of'. |
GA as ofea.tm_ga_asof_atAs of, time Max plan | When the box office reported the reading behind the GA count. It is that reading's own time, not when the count last changed. Filter on it so an old GA reading does not screen as live. |
Demand
| Column | What it measures |
|---|---|
Interestea.interestObserved, score | A demand score for how much attention the event is getting on the marketplace, over a recent window. Higher means more interest, which often shows before prices move. Empty before the first reading. |
Interest Δ1dea.interest_d1Change, score | How much Interest moved since the day before. Positive means attention is building. |
Interest Δ7dea.interest_d7Change, score | How much Interest moved over a week. Steadier than the 1 day change, so better for a real trend. |
Conversionea.conversionDerived, multiple | Sales divided by Interest: how much of the attention turns into buying. Zero means people are looking and the Sales score is zero, which is most events; empty when nobody is looking. Gate on 'Demand as of'. |
Salesea.salesObserved, score | A demand score for how fast tickets are moving on the marketplace, over a recent window. A score, not a count of tickets. Read it against the event's own history, not against Interest, which runs far larger. |
Sales Δ1dea.sales_d1Change, score | How much Sales moved since the day before. Positive means demand is picking up. |
Demand as ofea.demand_asof_dateAs of, date | The day the demand readings were taken. Filter on it so an old reading does not screen as live. |
Momentum & signals
| Column | What it measures |
|---|---|
Data qualityea.data_quality_scoreDerived, 0 to 1 | How much price history stands behind the event's signal columns, from 0 to 1. Below 0.5 there is too little history to trust them. It does not say whether the data is correct. |
Pace zea.pace_z_3d_vs_14dDerived, σ | Whether tickets have started leaving faster or slower over the last 3 days than they did over the two weeks before. Negative means listings are emptying faster. |
Pace z rank (peer)ea.pace_z_3d_vs_14d_pct_rank_subcat_tteDerived, 0 to 1 | Where Pace z ranks among similar events, the same subcategory at a similar distance from event day, from 0 for the lowest to 1 for the highest. Empty when there are fewer than 30 similar events. |
Pace z (peer)ea.pace_z_3d_vs_14d_xs_z_subcat_tteDerived, σ | Pace z set against similar events: the same subcategory at a similar distance from event day. Empty when there are fewer than 30 similar events. |
Peer countea.peer_n_subcat_tteDerived, count | How many similar events, the same subcategory at a similar distance from event day, the peer columns compare against. The peer columns are empty below 30. |
Tour peer countea.peer_n_tour_tteDerived, count | How many of the performer's dates at a similar distance from event day the tour columns compare against. The tour columns are empty below 5. |
Price z (tour)ea.price_self_z_7d_xs_z_tour_tteDerived, σ | Price z 7d set against the performer's other dates at a similar distance from event day. Past 2 either way stands out. Empty when there are fewer than 5 such dates. |
Pace z (tour)ea.pace_z_3d_vs_14d_xs_z_tour_tteDerived, σ | Pace z set against the performer's other dates at a similar distance from event day. Past 2 either way stands out. Empty when there are fewer than 5 such dates. |
Vol regime (tour)ea.vol_regime_ratio_xs_z_tour_tteDerived, σ | Vol regime set against the performer's other dates at a similar distance from event day. Past 2 either way stands out. Empty when there are fewer than 5 such dates. |
Price z 1dea.price_self_z_1dDerived, σ | How unusual the latest 1 day price move is for the event, against its own recent swing. Past 2 either way stands out. |
Price z 7dea.price_self_z_7dDerived, σ | How unusual this week's price move is for this event, measured against its own normal swing. Past 2 either way is a genuinely odd move rather than everyday noise. |
Price z rank (peer)ea.price_self_z_7d_pct_rank_subcat_tteDerived, 0 to 1 | Where Price z 7d ranks among similar events, the same subcategory at a similar distance from event day, from 0 for the lowest to 1 for the highest. Empty when there are fewer than 30 similar events. |
Price z (peer)ea.price_self_z_7d_xs_z_subcat_tteDerived, σ | How unusual the event's weekly price move is next to similar events: the same subcategory at a similar distance from event day. Empty when there are fewer than 30 similar events. |
Vol regimeea.vol_regime_ratioDerived, multiple | This event's price swing over the last week divided by its swing over the last month. Above 1.5 means prices have turned much choppier than they normally are. |
Vol regime rank (peer)ea.vol_regime_ratio_pct_rank_subcat_tteDerived, 0 to 1 | Where Vol regime ranks among similar events, the same subcategory at a similar distance from event day, from 0 for the lowest to 1 for the highest. Empty when there are fewer than 30 similar events. |
Vol regime (peer)ea.vol_regime_ratio_xs_z_subcat_tteDerived, σ | Vol regime set against similar events: the same subcategory at a similar distance from event day. Past 2 either way stands out. Empty when there are fewer than 30 similar events. |
Vol 7dea.volatility_7dDerived, percent | How much the middle price bounced around over the last week, as a percentage of its own average. Higher means a less settled market. |
Vol 14dea.volatility_14dDerived, percent | How much the middle price bounced around over the last two weeks. Steadier than the 7 day reading. |
Vol 28dea.volatility_28dDerived, percent | How much the middle price bounced around over the last four weeks. This is the everyday baseline the shorter swings get judged against. |
P25 z 7dea.p25_price_self_z_7dDerived, σ | This week's move in P25 price, against the event's own normal swing. Cheap tickets clearing out near the event move it less than Price z 7d, and the two compare directly. Past 2 either way stands out. |
P25 z rank (peer)ea.p25_price_self_z_7d_pct_rank_subcat_tteDerived, 0 to 1 | Where P25 z 7d ranks among similar events, the same subcategory at a similar distance from event day, from 0 for the lowest to 1 for the highest. Empty when there are fewer than 30 similar events. |
P25 z (peer)ea.p25_price_self_z_7d_xs_z_subcat_tteDerived, σ | P25 z 7d set against similar events: the same subcategory at a similar distance from event day. Past 2 either way stands out. Empty when there are fewer than 30 similar events. |
P25 z (tour)ea.p25_price_self_z_7d_xs_z_tour_tteDerived, σ | P25 z 7d set against the performer's other dates at a similar distance from event day. Past 2 either way stands out. Empty when there are fewer than 5 such dates. |
Weather
| Column | What it measures |
|---|---|
Weatherea.weather_stateObserved, category Pro plan | Bad, Cleared or Fair for the event's day. Bad is a storm or snow, a 60% chance of rain, a quarter inch of rain, or strong wind inside 7 days, or an uncomfortable temperature inside 10. Cleared was Bad and is calm again. |
Rain chanceea.weather_rain_chanceObserved, percent Pro plan | The highest chance of rain over the event's day. |
Rainea.weather_rain_inObserved, inches Pro plan | Total rain forecast over the event's day, in inches. |
Windea.weather_wind_mphObserved, mph Pro plan | The strongest sustained wind forecast over the event's day. |
Feels likeea.weather_feels_like_fObserved, °F Pro plan | What the temperature feels like at the hour the event starts. |
Roofea.venue_roofObserved, category Pro plan | Open to the sky, a retractable roof, or fixed (a dome, an arena, a theater). Unknown until the venue is labeled. |
Performer
| Column | What it measures |
|---|---|
Avg likespa.avg_likes_currentSocial, count | Average likes per post on the performer's X account. Empty without X data. |
Avg likes Δ1dpa.avg_likes_delta_1dChange, count | How far Avg likes moved since the day before, as a count. Positive means it went up. |
Avg likes Δ7dpa.avg_likes_delta_7dChange, count | How far Avg likes moved over a week, as a count. Positive means it went up. |
Performer lowest pricepa.avg_lowest_price_currentObserved, dollars | Average lowest price before fees across the performer's active events. |
Performer lowest price Δ1dpa.avg_lowest_price_delta_1dChange, dollars | How far Performer lowest price moved since the day before, in dollars. Positive means it went up. |
Performer lowest price Δ7dpa.avg_lowest_price_delta_7dChange, dollars | How far Performer lowest price moved over a week, in dollars. Positive means it went up. |
Performer lowest price %Δ1dpa.avg_lowest_price_pct_1dChange, percent | How far Performer lowest price moved since the day before, in percent. |
Performer lowest price %Δ7dpa.avg_lowest_price_pct_7dChange, percent | How far Performer lowest price moved over a week, in percent. |
Performer median pricepa.avg_median_price_currentObserved, dollars | Average middle price before fees across the performer's active events. |
Performer median price Δ1dpa.avg_median_price_delta_1dChange, dollars | How far Performer median price moved since the day before, in dollars. Positive means it went up. |
Performer median price Δ7dpa.avg_median_price_delta_7dChange, dollars | How far Performer median price moved over a week, in dollars. Positive means it went up. |
Performer median price %Δ1dpa.avg_median_price_pct_1dChange, percent | How far Performer median price moved since the day before, in percent. |
Performer median price %Δ7dpa.avg_median_price_pct_7dChange, percent | How far Performer median price moved over a week, in percent. |
Performer price zpa.avg_price_self_z_7dDerived, σ | How unusual this week's price move is across all of the performer's events, against their own normal. Past 2 either way stands out. Gate on Price density. |
Performer eventspa.event_countObserved, count | How many active events the performer has on sale. |
Likespa.likes_currentSocial, count | Likes across the performer's recent X posts. |
Likes Δ1dpa.likes_delta_1dChange, count | How far Likes moved since the day before, as a count. Positive means it went up. |
Likes Δ7dpa.likes_delta_7dChange, count | How far Likes moved over a week, as a count. Positive means it went up. |
Performer listingspa.listings_currentObserved, count | Resale listings across all of the performer's active events. |
Performer listings Δ1dpa.listings_delta_1dChange, count | How far Performer listings moved since the day before, as a count. Positive means it went up. |
Performer listings Δ7dpa.listings_delta_7dChange, count | How far Performer listings moved over a week, as a count. Positive means it went up. |
Postspa.posts_currentSocial, count | How many recent posts the performer's X account has, averaged across readings. |
Posts Δ1dpa.posts_delta_1dChange, count | How far Posts moved since the day before, as a count. Positive means it went up. |
Posts Δ7dpa.posts_delta_7dChange, count | How far Posts moved over a week, as a count. Positive means it went up. |
Price densitypa.price_data_densityDerived, 0 to 1 | How many of the last 28 days have a price reading for the performer, from 0 to 1. Keep it at 0.5 or more before you trust Performer price z. |
Performer vol 7dpa.price_volatility_7dDerived, percent | How much the performer's average middle price bounced around over the last week, as a percentage of its own average. |
Performer vol 14dpa.price_volatility_14dDerived, percent | How much the performer's average middle price bounced around over the last two weeks, as a percentage of its own average. |
Repliespa.replies_currentSocial, count | Replies across the performer's recent X posts. |
Replies Δ1dpa.replies_delta_1dChange, count | How far Replies moved since the day before, as a count. Positive means it went up. |
Replies Δ7dpa.replies_delta_7dChange, count | How far Replies moved over a week, as a count. Positive means it went up. |
Repostspa.retweets_currentSocial, count | Reposts across the performer's recent X posts. |
Reposts Δ1dpa.retweets_delta_1dChange, count | How far Reposts moved since the day before, as a count. Positive means it went up. |
Reposts Δ7dpa.retweets_delta_7dChange, count | How far Reposts moved over a week, as a count. Positive means it went up. |
Social densitypa.social_data_densityDerived, 0 to 1 | How many of the last 28 days have an X reading for the performer, from 0 to 1. Keep it at 0.5 or more before you trust the social z columns. |
𝕏 Buzz zpa.social_engagement_self_z_7dDerived, σ | How much more or less reaction the performer's X posts get this week than they usually do. Past 2 either way is a real spike in attention. Gate on Social density. |
Likes zpa.social_likes_self_z_7dDerived, σ | How unusual this week's likes are for the performer, against their own normal. Past 2 either way stands out. Gate on Social density. |
Views zpa.social_views_self_z_7dDerived, σ | How unusual this week's views are for the performer, against their own normal. Views are easier to inflate than likes or replies, so 𝕏 Buzz z is the stronger read. Gate on Social density. |
Performer ticketspa.tickets_currentObserved, count | Tickets on sale across all of the performer's active events. |
Performer tickets Δ1dpa.tickets_delta_1dChange, count | How far Performer tickets moved since the day before, as a count. Positive means it went up. |
Performer tickets Δ7dpa.tickets_delta_7dChange, count | How far Performer tickets moved over a week, as a count. Positive means it went up. |
Viewspa.views_currentSocial, count | Views across the performer's recent X posts. |
Views Δ1dpa.views_delta_1dChange, count | How far Views moved since the day before, as a count. Positive means it went up. |
Views Δ7dpa.views_delta_7dChange, count | How far Views moved over a week, as a count. Positive means it went up. |
Popularity rankpa.popularity_rankObserved, rank | Where the performer sits on the marketplace's ranking by recent sales. Higher is better. Empty when the performer is unranked. Gate on 'Rank as of'. |
Lifetime rankpa.lifetime_rankObserved, rank | Where the performer sits on the marketplace's ranking by sales across their whole history. Higher is better. Empty when the performer is unranked. |
Popularity rank Δ7dpa.popularity_rank_d7Change, rank | How many places the performer moved on the recent ranking over a week. Positive means climbing. |
Popularity rank Δ28dpa.popularity_rank_d28Change, rank | How many places the performer moved on the recent ranking over four weeks. Positive means climbing, and the longer window cuts out week-to-week noise. |
Rank as ofpa.rank_asof_dateAs of, date | The day the ranking was read. Filter on it so an old ranking does not screen as current. |
Performer interestpa.interestObserved, score | The Interest score across everything the performer has on sale, not one event. It runs far larger than the event's Interest, so never reuse a threshold between the two. |
Performer interest Δ1dpa.interest_d1Change, score | How much Performer interest moved since the day before. Positive means attention on the act is building. |
Performer interest Δ7dpa.interest_d7Change, score | How much Performer interest moved over a week. Steadier than the 1 day change. |
Performer salespa.salesObserved, score | The Sales score across everything the performer has on sale, not one event. A score, not a count of tickets. Blunt at the low end, where most acts sit, so rank on Performer interest instead. |
Performer sales Δ1dpa.sales_d1Change, score | How much Performer sales moved since the day before. Most acts sit too low for a change of 1 to mean much, so prefer Performer interest Δ1d. |
Performer demand as ofpa.demand_asof_dateAs of, date | The day the performer's demand reading was taken. Filter on it so an old reading does not screen as live. |
Playoff probabilitypa.playoff_prob_currentPrediction market, 0 to 1 | The traded chance, from 0 to 1, that the team or player qualifies for the next stage of its competition, usually a league postseason. Read it as qualifies, not always as makes the playoffs. Empty when no such market maps to the performer. |
Playoff prob as ofpa.playoff_prob_asof_dateAs of, date | The day of the reading behind Playoff probability. |
Market probabilitypa.kalshi_prob_currentPrediction market, 0 to 1 | The traded chance, from 0 to 1, on the one prediction market the performer maps to. The question differs per performer, such as top a chart, win a division or win an award, so two rows rarely compare. For a team's playoff chances use Playoff probability. |
Market as ofpa.kalshi_prob_asof_dateAs of, date | The day of the reading behind Market probability. |
Market Δ7dpa.kalshi_prob_delta_7dChange, 0 to 1 | How far Market probability moved against a reading at least 7 days earlier, on the 0 to 1 scale. Empty without an earlier reading. |
Market zpa.kalshi_prob_self_z_7dDerived, σ | How unusual Market probability is against its own previous seven days of readings. Past 2 either way stands out. Empty with fewer than three earlier days. |