Audience Builder - Operator training

And, or, inc ? Choose the good operator

Explanation of the game

The aim of these exercises is to understand the different kinds of operators which could be used to associate dimensions in order to create segmentations. In each case trainees will have to colour or hatch the areas on the diagrams that correspond to the operators used.

Case study 1 : OR Operator

A group of conditions associated with the logical OR operator is true if only one of these conditions is true. It is false otherwise. Suppose each condition is a subset of contacts, the result is a union of all of these subsets If you want to associate two or more sets of contacts that do not absolutely need to share all the same characteristics, you use the OR operator.

In this case you want to perform a segmentation of contacts who could be : 25 to 34 years old OR 35 to 44 years old. You join these sets of contacts with the OR operator.

Case study 2 : AND Operator

A group of conditions associated with the logical AND operator is true if only all of these conditions is true. It is false otherwise. Suppose each condition is a subset of contacts, the result is an intersection of all of these subsets If you want to associate two or more sets of contacts that absolutely need to share all the same characteristics, you use the AND operator.

In this case you want to perform a segmentation of contacts who could be : 25 to 34 years old AND Have purchase something last week. You join these sets of contacts with the AND operator.

Case study 3 : INC Operator

The INC Operator is used to associate characteristics not directly related to contacts such as purchases. A group of conditions associated with the logical INC operator returns the smallest subset included in all others (INC operator performs an inclusion).

In this case you want a segmentation of contacts who : Have purchase something last week INC(luding) For an amount < 50 € You join these sets of tickets with the INC operator to identify the contacts you want to target. Apparently INC Operator seems to act almost the same way as the AND operator. But if the AND Operator was used here, the segmentation would be contacts who bought something last week and and bought something for an amount inferior to 50€ but no matter when.

Case study 4 : Combination of AND Operator and INC Operator

In this case you want to perform a segmentation of contacts who could be : 25 to 34 years old AND : Have purchase something last week. INC(luding) For an amount < 50 €

You join the set of contact who purchased something within a week with the ones who purchased for an amount inferior to 50 € with the INC operator. Then join the resulting set with an AND operator to the set of contacts aged between 25 and 34 years.

Case study 5 : Combination of AND, INC Operators and Custom Criteria

In this case you want to perform the same segmentation as in case 4, but this time you want to focus only on people who are 25 year old : Custom criteria : Age = 25 AND Have purchase something last week. INC(luding) For an amount < 50 €

To do this, you use a custom criteria based on the age of contacts. Custom criterium are user defined filters (equals, superior than, inferior than,…) applied to contact characteristics You join the set of contact who purchased something within a week with the ones who purchased for an amount inferior to 50 € with the INC operator. Then join the resulting set with an AND operator to the set of contacts with a custom criteria filter based on their age.

Case study 6 : Combination of OR, AND, INC Operators

Last case will use the three operators.

This time contacts targeted are : 25 to 34 years old OR 35 to 44 years old. AND Have purchase something last week. INC(luding) For an amount < 50 €

You join the set of contact who purchased something within a week with the ones who purchased for an amount inferior to 50 € with the INC operator. You join the set of contacts which are 25 - 34 years old to the set of contacts which are 35 - 44 years old with the OR operator. Then join this two groups of sets with an AND operator.