Viagogo fields in every export
The event record covers event identifier, name, performer, venue, city and country, event date and local time, the storefront it was collected from, the storefront language and currency, and the event URL.
Listing observations carry seating category and section where published, quantity available, price per ticket as displayed, fee treatment, the estimated or shown total, the currency, and any restriction noted on the listing such as ticket delivery method or seating together.
Storefront is a first class field on every row rather than an afterthought, because on this platform the same listing viewed from two countries is two observations with different numbers. Recording only a price and a currency loses the reason they differ.
Derived measures per observation and per storefront follow the same pattern as any resale collection: lowest available in each seating category, median, listing count and total quantity, all computed from stored rows.
Currency handling keeps the quoted currency as collected and records any conversion separately with its rate and date, so exchange movement is never mistaken for ticket price movement, which is a genuine risk in a multi market series.