Data

How it fits together

Think of it as Jira for sponsorships. A property is a workspace. Contracts feed it assets, the way epics hold work. Each asset breaks into tickets: deliveries, approvals, activations, hospitality, reports and contract deadlines.

Entities

click a box to open it
1 → 51 → many1 → manymany ↔ many1 → many1 → many1 → many1 → many1 → manyPortfolioConstellation field mktgBusiness unit5 · WBU, SBU, SEBU, EBU, CBUGrouping8 · e.g. WBU-02, SBU-01Property / workspace158 · team, venue, eventContract2 loaded · term, years, clausesRights holderVenue, team, league entityAsset (epic)48 · what the contract grantsTicket162 · one piece of delivery workClauseDeadline, approval, remedyChecklist + notesProof of performance, recaps

Ticket workflow

from the Scrum Board template
Backlog→To do→In progress→To be verified→Done
Asset stage (Done, In progress, To do, On hold, as in the Loop asset tracker) rolls up from its tickets unless set by hand.

Ticket types

Delivery Something the rights holder or we must deliver: signage live, spots produced
Approval Creative or marks approval with the rights holder
Activation Event, watch party, theme night, promotion
Hospitality Suites, seats, ticket bank, VIP experiences
Report Proof of performance, recaps, competitive reports
Obligation Contract deadline or rule: brand selection, forfeiture, renewal

Worked example: one contract, three workspaces

AAC · Mavs · Stars 2024-28 has three rights holders, each with its own schedule.
American Airlines Center · Sch. 2.1→ shows in both Mavericks and Stars workspaces as shared venue assets
Dallas Mavericks · Sch. 2.2→ Mavericks workspace (SBU, Tier 1)
Dallas Stars · Sch. 2.3→ Stars workspace (SBU, Tier 2)
An asset like Consumer watch parties: 6 per season becomes six Activation tickets with a checklist. Radio: two :30 spots per broadcast becomes a monthly proof-of-performance Report ticket.
Open the contractSee the assets

Source files

26_CBI Field Marketing Properties.xlsxPortfolio, BUs, groupings, properties (verified)
Staffing Plan workbookAssignee roles and BU hours (hours only)
DallasMavs-Stars_CBI_2024-2028_Executed.pdfContract, rights holders, assets, clauses (verified)
SoFiStadium Amendment01.pdfContract dates and clauses (verified); assets are placeholders
CBI RFP FM.pdf (Loop asset tracker)Asset stages and how assets read as rows
Scrum Board.pdfTicket workflow columns
EXP Event Planning.pdfActivation checklist items
SponsorCX deckLook and navigation reference