Data Architecture

First-Party Platform DB: The ticketing app’s own database — the single place where a sale actually happens and the only system that knows a real buyer bought a real seat. Payments & Settlement: The payment provider’s record of what money moved — authorisations, refunds and the payouts that eventually land in the bank. Marketing Platforms: The advertising and messaging tools — what was sent, to whom, what it cost and which ticket sale the platform claims it caused. Public & Government Data: Official statistics — the census and survey releases that supply the denominators no company can produce for itself. Partner & Promoter Feeds: What the people who actually own the shows send in — venue capacities, performance dates, allocations and settlement terms. Batch ETL: The scheduled collection round — once a night (or once an hour) it fetches whole files from each source and brings them in together. Event Streaming: The live wire — transactions and app events arrive the second they happen instead of waiting for the nightly run. Landing Zone: A locked room where every incoming file is kept exactly as it arrived — encrypted, timestamped and untouched. Bronze — Raw: The permanent raw record: every field the source sent, kept in full, so the business can change its mind later and recompute from scratch. Silver — Validated: Where messy raw data becomes trustworthy data — same facts, made consistent, de-duplicated and legally usable. Gold — Business-Ready: The one version of each number the business argues from — revenue, refund rate, contribution per ticket — defined once and computed the same way every time. Finance & Unit Economics: The money view: what was sold, what was refunded, what tax is owed and what actually settled. Customer & Consent: Who the buyers are, what they have agreed to, and what the business is therefore allowed to send them. Events, Venues & Inventory: What is on sale, where, how much of it is left, and how much of the room actually filled. Marketing & Growth: What it costs to win a buyer, and whether the campaign actually caused the sale. Markets, Partners & Risk: The board’s view: which market to enter next, who the counterparty is, and what is currently going wrong. Campaign Activation: Turning a governed segment into an actual audience the marketing tools can send to. Dashboards & BI: The screens Leadership actually looks at — every tile carrying the file it came from and the label of what kind of data it is. APIs & ML Models: Machine-to-machine delivery — governed data feeds for partners, and models that price or predict. Consent & Privacy Enforcement: The control that decides, for every row, whether the business is legally allowed to use it for this purpose. Data-Quality Gates: Automated tests that stop a bad number reaching a dashboard, instead of someone spotting it afterwards. Lineage & Traceability: The paper trail: for any number on any screen, which file it came from and when that file was captured. Residency & Transfer Controls: The rules about where data is allowed to physically sit, and what has to be signed before it crosses a border.