Page Comparison

The sub-queries, or nested queries, allows you to define a subgroup of conditions within the query.

Basically, it's like in mathematics when you use parentheses to differentiate between pieces of an equation that must be executed at first, before the result is applied to the whole equation.

Ex: 10 x 5 – ( 3+2 ) = 45 is different from  10 x 5 - 3 + 2 = 49

Here it is important to group 3 + 2 in parentheses so that they are performed together before being subtracted from the rest of the equation.

It's the same with sub-queries:

To create a sub-query:

1. Click on
2. Click on the default filter and change it to Individual > Contact (or Structure > Contact)
3. Click on the default operator and change it to in sub query
4. Click on edit sub query: in the new window, create you query as it was a standard target. Click "OK" when ready.

This menu includes some preset and most used filters. You may start with them, you'll find:

Contact has not printed print@home ticket for → contacts who have not printed their print@home ticket for a given performance

Contact is a member of → contacts being members of organization X (= the Member indicator is yes for organization X)

Contact is season ticket holder of → contacts being subscribers of organization X  (= the Subscriber indicator is yes for organization X)

Contact has bought more than → contacts who have purchased for an amount greater than

Contact has bought less than → contacts who have purchased for an amount less than

Contact is in static target → contacts part of static target X.

The main data from your contact cards are available in the first two filters (email, birthday date, source sales channel, the existence of a login, etc).
Some are specific for individuals (gender, title, etc) or to structures (structure type, website, etc). Pick individual or structure according to the type of contacts you are basing the query on.

The example below shows a query combining several operators and several individual entity fields.
This request will allow us to obtain the list of individuals with an email and a login who were created in the current month on the "Internet B2C" or "Internet B2B" sales channel.

The geographic and postal data of your contacts are available here.
The examplebelow shows a query combining several operators and several address entity fields. It allows you to obtain the list of all individuals living in Switzerland or France.

Information and communication authorizations for your contacts are available here.
The example presents a query allowing you to obtain the list of all individuals accepting communications from your organization.

According to GDPR, SAM Campaigns module will in any case filter out contacts who do not provide their authorization, unless you specifically choose otherwise: see this page for more info How to create a campaign

The data automatically calculated by S-360 based on the behavior of your contacts are available here.
To make a query based on an indicator, you first need to know what type of value is possible for your indicator: boolean (yes/no), numeric, etc.

Also remember that indicators have a level and a value. For example, the "Attendance" indicator will have the occasional  value and level 1  because the contact will have returned 1 time, thus classifying it in the occasional contact category.

The example shows a query to get a list of all individuals with the Social Media Engagement (Shares) metric set to Engaged.

Your contacts' qualification data are available here. If you have several organizations, the criteria can therefore be centralized (meaning that the value will be identical in all the organizations) or by organization (so specific for each one of them).
The example presents a query to obtain the list of all individuals who prefer to be contacted by email.

Your contacts' cultural history is available here. Please remember that a contact is a cultural contact when a ticket/item is linked to them, despite if they were bought directly or by someone else.
The example shows a query combining several operators and several fields from the Sales History entityfilters: it allows you to obtain the list of all individuals who made a purchase during the season on the "Internet B2C" or on "Guichet" sales channel.Image Removedhave a ticket for Aida that were bought on sales channel "B2C"

Image Added

This filter is usually crucial for most of the targets. It refers to the last status of the product linked to the cultural contacts.
Important: filtering a given product e.g. by ‘Cultural history Sale Type = Discard’ (in order to identify those who did not purchase it despite an initial selection) does not guarantee that customers did not buy it later!

Data relating to product families purchased by your contacts are available here.
The example shows a query combining several operators and several fields of the product family entity: it allows you to obtain the list of all individuals who have products belonging to subscriptions or memberships families.

Please remember SAM will target cultural contacts, so results will also include those whose tickets were bought for them by someone else.

Data relating to the prices configured in S-360 are available here.
The example shows a query that allows to obtain the list of all individuals who have season 1 items purchased with tariff  "Baby"

Data relating to the events product family linked to your contacts are available here.
The example below allows you to obtain the list of all the individuals who have tickets for "Don Giovanni"

Please remember SAM will target cultural contacts, so results will also include those whose tickets were bought for them by someone else.

Data relating to the visits product family linked to your contacts are available here. 
The example allows you to obtain the list of all individuals who have tickets for today's or tomorrow's visits.

Please remember SAM will target cultural contacts, so results will also include those whose tickets were bought for them by someone else.

Data relating to the season ticket product family linked to your contacts are available here.

The example allows you to obtain the list of all individuals who have the “Musical Legends”.

Please remember SAM will target cultural contacts, so results will also include those whose products were bought for them by someone else.

Data relating to the membership product family linked to your contacts are available here.

The example shows how to obtain the list of all individuals who have a “DUO Membership Card” membership.

Please remember SAM will target cultural contacts, so results will also include those whose products were bought for them by someone else.

As shown above for the main product families' filters, you have other filters that allow you to build specific queries on all the other product families managed by S-360.

The example shows how to obtain the list of all individuals who have a Gift voucher

Please remember SAM will target cultural contacts, so results will also include those whose products were bought for them by someone else.

Data relating to payment details are available here.

The example allows you to obtain the list of all individuals whose tickets with the "Credit Card" payment method.

Please remember SAM will target cultural contacts, so results will also include those whose products were bought for them by someone else.

Data relating to shipments are available here. It includes both information about how tickets/products were shipped (at hand, via post, etc.) as well as SAM specific campaigns recipients and details.

The example allows you to obtain the list of all individuals whose tickets for "La Traviata" were delivered as "print@home".

In this other example you can get the individuals who received the "Birthday" campaign

Ticket data for your contacts are available here.

The example allows you to obtain the list of all individuals having a ticket for a seat located in “block A”.

Please remember SAM will target cultural contacts, so results will also include those whose products were bought for them by someone else.

Data relating to interactions between your contacts and your institution are available here.

The example allows you to obtain the list of all individuals who have had an incoming “phone call” type interaction

Please remember SAM will target cultural contacts, so results will also include those whose products were bought for them by someone else.

Data relating to existing targets are included here.

The example allows you to obtain the list of contacts included in the intersection of the targets "Fundraising campaign" and "Romeo and Juliette".

Data relating to existing targets are included here, available to be easily removed if necessary from your query's result.

The example allows you to obtain the list of all individuals except those included in the existing target "France"