Balance

Any number

The rule selects only members who have more than this number of units in the select Balance Type.

Balance Type

Any configured balance type

Used in conjunction with the Balance option to specify the balance type in which the member must have a certain number of units.

Over a Period of Time

Cleared

Selected

The rule only selects members whose units were earned over the combined Earning Period and Earning Period Unit.

Earning Period

Any number

The specified time period over which a member's units were earned.

Earning Period Unit

Day

Week

Month

Year

Determines the length of time over which a member's units were earned.

No. of items

Any number

The number of items that a member must have purchased to be selected by this rule.

Item class

Any configured item class

Only items in the selected class are counted when evaluating the No. of items.

Item

Any configured item

Only the selected item is counted when evaluating the No. of items.

Film

Any configured film

Only tickets to the selected film are counted when evaluating the No. of items.

Note: only applies to Box Office items.

Last no. of days

Any number

The rule only selects members who have bought the No. of items within the entered number of days before the current date.

Site

Any configured site

Only items purchased at the selected site are counted when evaluating the No. of items.

Cinema group

Any configured cinema group

Only items purchased at the selected cinema group are counted when evaluating the No. of items.

Format

Any configured format

Only tickets to films with the selected format are counted when evaluating the No. of items.

Note: only applies to Box Office items.

Format Class

Any configured format class

Only tickets to films configured with a format in the selected format class are counted when evaluating the No. of items.

Note: only applies to Box Office items.

Sales Channel

Any configured sales channel

Only items purchased through the selected sales channel are counted when evaluating the No. of items.

Amount spent

Any currency value

The amount of money that a member must have spent to be selected by this rule.

Item class

Any configured item class

Only items bought in the selected class are counted when evaluating the Amount spent.

Item

Any configured item

Only the selected item is counted when evaluating the Amount spent.

Film

Any configured film

Only tickets to the selected film are counted when evaluating the Amount spent.

Note: only applies to Box Office items.

Last no. of days

Any number

The rule only selects members who have spent the Amount spent within the entered number of days before the current date.

Site

Any configured site

Only purchases at the selected site are counted when evaluating the Amount spent.

Cinema group

Any configured cinema group

Only purchases at the selected cinema group are included when evaluating the Amount Spent.

Format

Any configured format

Only tickets to films with the selected format are counted when evaluating the Amount spent.

Note: only applies to Box Office items.

Format Class

Any configured format class

Only tickets to films configured with a format in the selected format class are counted when evaluating the Amount spent.

Note: only applies to Box Office items.

Sales Channel

Any configured sales channel

Only purchases through the selected sales channel are counted when evaluating the Amount spent.

Time range

Any configured time range

Only sessions in the selected time range are counted when evaluating attended sessions .

Session between

Any date range

Only sessions between the selected date range are counted when evaluating attended sessions.

Last no. of days

Any number

The rule only selects members who have attended sessions during the Time range within the specified number of days before the current date.

Genre

Any configured genre

Only sessions of films with the selected genre are counted when evaluating attended sessions.

Site

Any configured site

Only sessions at the selected site are counted when evaluating attended sessions.

Cinema group

Any configured cinema group

Only sessions at the selected cinema group are included when evaluated attended sessions.

Format

Any configured format

Only sessions of films with the selected format are counted when evaluating attended sessions.

Format Class

Any configured format class

Only sessions of films configured with a format in the selected format class are counted when evaluating attended sessions.

Sales Channel

Any configured sales channel

Only tickets purchased through the selected sales channel are counted when evaluating attended sessions.

Recognition

Any configured recognition

The rule only includes members whose status (with respect to the selected recognition) has changed.

New status

Any configured status

Only members whose recognition has changed to the selected status are included by the rule.

Last no. of days

Any number

The rule only selects members whose recognition status has changed within the specified number of days before the current date.

Site

Any configured site

Only purchases at this site are counted when evaluating the minimum transaction Value.

Cinema Group

Any configured cinema group

Only purchases made at this cinema group are counted when evaluating the minimum transaction Value.

Cinema type

Any configured cinema type

Only purchases at cinemas of this type are counted when evaluating the minimum transaction Value.

Session between

Only transactions made between the selected dates are included when evaluating the minimum transaction Value.

Value

The rule only selects members who have spent above this value at the locations and times given by the other options in this section.

Format

Any configured format

Only purchases including tickets to films, with the selected format, are counted when evaluating the minimum transaction Value.

Format Class

Any configured format class

Only purchases including tickets to films, configured with a format in the selected format class, are counted when evaluating the minimum transaction Value.

Sales Channel

Any configured sales channel

Only tickets purchased through the selected sales channel are counted when evaluating the minimum transaction Value.

Occurs

Today

This Week

Next Week

This Month

Next Month

In Date Range

The rule selects members whose birthday occurs in the chosen period.

For example: Loyalty > Members > Add/Modify Member > Demographics and Preferences > Birthday.

Birthday between

Selects members whose birthday occurs between the specified dates.

Note: The field Occurs must be set to In Date Range to enable this option.

Sales Channel

Any configured sales channel

The rule selects only members who signed up to Loyalty through the selected channel.

A member's sales channel can be found in the following screen: Loyalty > Members > Add/Modify Member > Club Details > Created on Sales Channel.

Membership Anniversary between

The rule selects only members whose membership was created between the chosen dates.

The date that a membership was created can be found in the following screen: Loyalty > Members > Add/Modify Member > Club Details > Member Created.

Expire between

The rule selects only members whose membership expires between the chosen dates.

A membership's expiry date can be found on the following screen: Loyalty > Members > Add/Modify Member > Club Details > Membership Expires.

Lowest age

00–99

The rule selects only members whose age is equal to or greater than the chosen number of years.

Highest age

00–100+

The rule selects only members whose age is equal to or lower than the chosen number of years.

Gender

Male

Female

The rule selects only member of the chosen gender.

Note: this field may be left blank.

Geography

Any configured geography

The rule selects only members whose geography (determined by the member's Post Code) includes the chosen geography.

For example: Loyalty > Members > Add/Modify Member > Club Details > Post Code.

Preferred site

Any configured site

The rule selects only members whose preferred sites include the chosen site.

For example: Loyalty > Members > Add/Modify Member > Demographics and Preferences > Preferred Sites.

Preferred site is favourite

Cleared

Selected

The rule selects only members whose favourite site is the chosen Preferred Site.

Pick-up site

Any configured site

The rule selects only members whose Pick Up Card From setting is the chosen site.

For example: Loyalty > Members > Add/Modify Member > Club Details > Pick Up card From.

Genre

Any configured genre

The rule selects only members whose preferred genres include the chosen genre.

For example: Loyalty > Members > Add/Modify Member > Demographics and Preferences > Set Genres.

Preference

Any configured preference

The rule selects only members whose preferences include the chosen preference.

For example: Loyalty > Members > Add/Modify Member > Demographics and Preferences > Set Preferences.

Member level

Any configured level

The rule selects only members of the selected level.

For example: Loyalty > Members > Add/Modify Member > Demographics and Preferences > Education Level.

Method

Email

Mail

Phone

SMS

Fax

The rule selects only members whose Contact Via settings include the chosen method.

For example: Loyalty > Members > Add/Modify Member > Contact Information > Contact Via.

Third Party

True

False

When selected, the rule includes only members whose Allow Contact by Third Party setting (as defined in Loyalty > Members > Add/Modify Member > Contact Information > Allow Contact By Third Party) matches the chosen value.

Bad email

Cleared

Selected

When selected, the rule includes only members with matching Bad email settings (as defined in Loyalty > Members > Add/Modify Member > Contact Information > Bad Email).

Bad mailing address

Cleared

Selected

When selected, the rule includes only members with matching Bad mailing address settings (as defined in Loyalty > Members > Add/Modify Member > Contact Information > Bad Mailing Address).

Activation status

Not Activated

Activated

The rule includes only members whose Member Activated setting matches the selected value.

For example: Loyalty > Members > Add/Modify Member > Club Details > Membership Activated.

Description

1- 500 characters

Displays an error message if an error occurs while a custom rule is executed.

Query

1 - 4000 characters

The custom SQL query created to retrieve specified data.

For example:

SELECT member_membershipid FROM cognetic_members_member WHERE member_SpecialRequirements = 'EmailBounced'

Selects members whose special requirements field has the value "EmailBounced".

System rule

Note: This field is for Vista internal use only.