Usable data points for Sentinel

This article shows you how different data points are named in Future Demands data base. This is above all important for asking questions as specific as possible in Sentinel to get the right answers.

This article is relevant for: FD Live Professional

To get accurate results with Sentinel, it is crucial to ask questions that make sense in the context of the data schema with ideally no room for interpretation. For this purpose the Sentinel data schema is provided in this article.

How to get your information as fast as possible from this article and use it properly:

Depending if you are asking for the category event, transactions or customers you can scroll down to the right section.
Press Ctrl or Command + F to open the search function and type in the data point you are looking for to define your question in Sentinel. (i.e. artist, ticket type, composer,...)
Once you found the right name of the data point and you found also the name of the actual example for your question you can define your question.
For example:
- "Give me a list of customers where the city is Berlin and the ticket category is regular" To get all clients in Berlin who never bought a discounted ticket but only regular price tickets.
- "Give me a list of events where in the field composer is Mozart" to get all events where pieces of Mozart were part of the program

Events

This table contains the possible data points for events and production (lineups (artists) and setlists (program)).

Value	Type	Description	Example
id	text	The unique identifier of the event, which can be found at the end of the URL, if you click on a campaign or event in the Web App everything after event-id=	event-sim-01234
title	text	The title of the event	Tosca
category	text	Future Demand category of the event. It is limited to certain values (see below after this table). You have to ask for these values in order to get a correct answer.	Opera
date	date	Date of the event. It is not limited to a given format if you are asking questions in Sentinel	December 1st Next month June 2022
start	time	Time of the event. It is not limited to a given format if you are asking questions in Sentinel	11:00am Eleven o'clock
end	time	End time of the event. It is not limited to a given format if you are asking questions in Sentinel	11:00am Eleven o’clock
capacity	number	Maximum number of people the event hosts	888 More than 1000
price_category	number	Average of the tickets sold for this event	888 More than 1000
city	text	City of the event	Wien Berlin
description	text	Description of the event	My wonderful event. Please come.
work title	text	Name of a work performed in the event	Abbey road The Nutcracker
composer	text	Name of an artist who made a given work	Paul McCartney Tchaikovsky
artist_name	text	Name of an artist performing at a given event	Maria Callas
artist_type	text	Role of a given artist. It is limited to certain values. (see below after this table). You have to ask for these values in order to get a correct answer.	actor band

Events - category

Product/Service
Ballet
Chamber
Comedy
Dance
Education
Opera
Operetta Musical
Other
Rock Pop
Spoken
Symphony
Theater
Vocal

Events - artist type

acrobat
actor
author
band
choir
choreograph
comedian
composer
conductor
costume design
dancer
director
ensemble
light design
moderation
orchestra
other
producer
soloist
sound design
stage design
technician
LINEUP

Transactions

This table contains all data points for transactions (tickets).

Value	Type	Description	Example
id	text	The unique identifier of the transaction	xxx123
event_id	text	The unique identifier of the event, which can be found at the end of the URL, if you click on a campaign or event in the Web App everything after event-id=	event-sim-01234
customer_id	text	The unique identifier of the customer who bought the ticket	customer_01234
ticket_type	text	Future Demand ticket type. It is limited to certain values (see below after this table). You have to ask for these values in order to get a correct answer.	regular
date	date	Date of the sale. It is not limited to a given format	December 1st Next month June 2022
time	time	Time of the sale. It is not limited to a given format	11:00am Eleven o'clock
sold_price	number	Cost of the ticket after any possible discount	150.55 28 More than 100
ground_price	number	Cost of the ticket before any possible discount	150.55 28 More than 100
discount	number	The discount of a ticket. Essentially the difference between the sold and ground price	888 More than 1000
currency	text	Three letters value corresponding to the purchase currency	USD EUR

Transactions - ticket type

Regular: Less than 15% off the ground price.
Regular Discount: More than 15% and up to 50% off the ground price.
Discounted: More than 50% and up to 80% off the ground price.
Subscription: If the provided ticket category name includes the keywords like "Abonnement" or "subscription".
Free: More than 80% off the ground price.
Reserved: If the provided ticket category name includes the keywords like "reserved".
Cancelled: If the provided ticket category name includes the keywords like "storno" or "cancelled" or is marked as “cancelled” from the ticketing system.

Customers

This table contains all possible data points for customers.

Value	Type	Description	Example
id	text	The unique identifier of the customer	customer_01234
phone1	text	A phone number	24244476
phone2	text	A phone number	24244476
first_name	text	Customer’s first name	Max
last_name	text	Customer’s last name	Müller
street	text	Street where the customer lives	My street, 88
zip_code	text	Post code of the customer	10088
city	text	City where the customer lives	Berlin
email	text	Customer’s email	test@gmail.com
ads_opt_out	boolean	True if the customer doesn’t agree to receive emails	True
salutation	text	Raw value	Dr