•Customers Not Living in Canada
•Customers Who Purchased Events Occurring on or Before December 31, 2024
•Customers with Combined Orders Totalling More than $500.00
•Customers with Addresses in Similar Postal Codes
•Customers Who Answered 'Yes' or 'Blank' for a Marketing Data Question
In this example, we will set up the criteria for a customer query intended to return customers that:
•Live in Canada.
•Do not live in Canada.
•Have purchased events which occur on or before December 31, 2017.
•Have a combined order purchase of $500.00 or more.
•Have addresses in similar postal codes.
•Answered Yes or not at all to a marketing question.
The following tables describe the criteria to use and the settings for each. Use the steps provided in Creating a BI Query complete this example.
Customers Living in Canada
Field |
Value |
Category/Criteria |
Customer Address/Country |
Type |
Match Condition |
Function |
Blank |
Condition |
Equals |
Values |
Canada |
Customers Not Living in Canada
Field |
Value |
Category/Criteria |
Customer Address/Country |
Type |
Match Condition |
Function |
Blank |
Condition |
Does not equal |
Values |
Canada |
Customers Who Purchased Events Occurring on or Before December 31, 2024
Field |
Value |
Category/Criteria |
Order Admissions/Event Start Date |
Type |
Match Condition |
Function |
Date |
Condition |
Less than or equal to |
Values |
2024-12-31 |
Customers with Combined Orders Totalling More than $500.00
Field |
Value |
Category/Criteria |
Order/Order Grand Total |
Type |
Match Condition |
Function |
Sum |
Condition |
Greater than |
Values |
500 |
Customers with Addresses in Similar Postal Codes
Field |
Value |
Category/Criteria |
Customer Address/Postal Zip Code |
Type |
Match Condition |
Function |
First Word |
Condition |
Equals or Blank |
Values |
M6S |
Customers Who Answered 'Yes' or 'Blank' for a Marketing Data Question
Field |
Value |
Category/Criteria |
Customer Marketing/Data 1 |
Type |
Match Condition (include blanks) |
Function |
Blank |
Condition |
Equals |
Values |
Yes |
