Global Champions

Presenter Guide · Internal

The Global Champions Story

Follow one fan across tickets, tables and streaming — and watch scattered data become one picture management can act on.

Open the data model ↗
How to use this page. Read the story aloud; the navy Show it live box under each step links straight to the right record or tool. Badges: READY ready · PARTIAL partial · BUILD build before showtime.

What’s already in the portal

10
Fans / contacts
3
Stables
6
Tour events
8
GCTV programmes
2
VIP tables
11
Streaming sessions

The demo, as a story

STEP 1
Meet Hendrik — one fan, one full picture

Hendrik owns Stal de Vries and brings his daughter Lotte, a young rider. He buys tickets, hosts a VIP table in Paris, and streams every Grand Prix on GCTV. Today that story is spread across ticketing, the streaming platform and a spreadsheet. Here it’s a single screen.

▶ SHOW IT LIVE

“Everything Global Champions knows about Hendrik — in one place.”

Open HendrikOpen Stal de Vries
STEP 2
Who watched the Paris Grand Prix?

The morning after Paris, marketing wants everyone who watched the Grand Prix broadcast — to send the highlight reel and an early-bird offer. No export, no waiting on the streaming team.

▶ SHOW IT LIVE

“Open the programme, or the saved audience — Émilie, Hendrik, Lotte and Tom.”

Open ‘Paris – Grand Prix Live’Open list: Watched – Paris GP
STEP 3
Who sat at a VIP table in Paris?

Hospitality wants to thank the table hosts and re-book them, and invite their guests back in their own right — two messages, one reservation.

▶ SHOW IT LIVE

“Host and guests are labelled on the reservation, so follow-up gets personal.”

Open Paris VIP tableOpen Paris eventOpen list: VIP guests – Paris
STEP 4
Our most loyal owners

Commercial wants the stable owners who came to three or more events this season — exactly the people to talk to about premium packages. Hendrik is top of the list.

▶ SHOW IT LIVE

“The segment Dennis asked for, built and live — Hendrik de Vries.”

Open list: Stable owners – 3+ events
Filter: Community Role = Stable Owner AND ≥3 attended events in the last 8 months.
STEP 5
The people we’re missing

Marcus bought a table in Paris and Madrid but never checked in — nobody greeted a paying guest. Émilie streams every event on Premium yet has never bought a ticket. Both were invisible before; one a retention risk, one a first-ticket opportunity.

▶ SHOW IT LIVE

“The gaps between what people pay for, attend and watch — finally visible.”

Open Marcus (no-show)Open Émilie (superfan)
STEP 6
Turning signals into audiences

Combine watching, attendance and role into ready-to-use segments — “watched but never subscribed”, “subscribes but never comes live”, “VIP buyer who’s also a superfan”. Each one is a message waiting to be sent, and each is already built.

▶ SHOW IT LIVE

“Behaviour becomes audiences, without a data team.”

Viewer, not subscriberSubscriber, no live visitVIP buyer + streamer
STEP 7
The right message at the right moment

A heatwave hits the Paris weekend. One audience of VIP hosts, one of riders, one of streaming fans — three tailored messages, sent from the same data in minutes.

▶ SHOW IT LIVE

“Same event, three relevant messages — not one generic blast.”

Open Marketing EmailSee public events page
STEP 8
What management finally sees

A single board: tickets sold vs people who actually came, watch-time by rider, the size of every segment. The end of “let me pull that from a spreadsheet.”

▶ SHOW IT LIVE

“One dashboard leadership can trust — no Excel.”

Build the dashboard

Build checklist — every asset

Red rows need building before the showcase. Everything else is live now.

AssetTypeStatusOpen / build
Custom objects (Event, Programme, Viewing Session, Registration, Hospitality)SchemaREADYProgrammes
Company / Stable layer + Owner/Rider/Breeder labelsSchemaREADYStal de Vries
10 fans, 6 events, 8 programmes, 10 registrations, 2 VIP tables, 11 sessionsRecordsREADYContacts
rider_level (only Sofia + Lotte set)FieldPARTIALContacts
Activation derived fields (subscriber / attendance / VIP / viewer / watched)FieldsREADYContacts
This demo guide + the data model pageCMS pagesREADYData model
List: Watched – Paris Grand Prix LiveActive listREADYOpen
List: VIP table guests – ParisActive listREADYOpen
List: Stable owners – 3+ events (8 mo)Active listREADYOpen
Activation segment lists (3 built; breeder = final model)Active listsREADYOpen
events_attended_8m + derived-field maintenance workflowWorkflowBUILDBuild
Management dashboard + 6 reportsDashboardBUILDBuild
Last-minute marketing email (role personalised)Marketing emailBUILDBuild
Horse & Subscription objects, split identity fieldsFinal modelFINAL+Data model

“One record per fan → live segments → the right message → a dashboard leadership trusts.”

See the target data model ↗