Siebel Loyalty Administration Guide > Setting Up Siebel Loyalty Promotions > Configuring Common Promotions >

Creating a Promotion That Applies on the Member's Anniversary


You can create a promotion that gives members a bonus on the anniversary of the date they joined the program.

You must begin by creating two new fields that include just the month and day (not the year) of the member's start date and the system date, so you can create a rule that compares these values.

To create a promotion that applies on the member's anniversary

  1. In Siebel Tools, configure Siebel Loyalty as follows:
    1. In the business component LOY Member, create a calculated field called Join Date, calculated using the function Left([Start Date],5).
    2. In the business component LOY Engine Member, create the same calculated field.
    3. In the business component LOY Transaction, create a calculated field called System Date, calculated using the function Left(Today(),5).
    4. In the business component LOY Engine Transaction, create the same calculated field.
  2. In Siebel Tools:
    1. Design a work flow that internally checks the member's Joined date with the system date and creates Queued txn with the needed bonus point when these dates match.
    2. Set up a job (using Workflow Batch Process Manager) component to run this workflow.
  3. In Siebel Loyalty:
    1. In the List of Values Administration view, add a new record for LOY_ATTRIB_FIELDS_MEMBER with the value Join Date.
    2. In the List of Values Administration view, add a new record for LOV LOY_ATTRIB_FIELDS_TXN with the value System Date.
    3. Create a Member Attribute based on the field Join Date.
    4. Create a Transaction Attribute based on the field System Date.
    5. Create a promotion with a rule that:
      • Includes a criterion that compares the attribute for the Join Date and the attribute for the System Date.
      • Includes an action that gives a bonus if this criterion is true (Join Date equals System Date).

For general information about adding new fields that are used in promotion criteria, see Allowing Added Member Fields to Be Used in Loyalty Promotion Criteria.

Siebel Loyalty Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.