Wishlist Use Case

A web-based retail store allows customers to specify items they are interested in by adding these items to a wish list. This client wants records of each instance of a customer adding an item to his/her wishlist, in order to gain additional insight into its customers. The client imports a generic event file containing this data.

Using this wishlist event data, the client creates profiles that leverage this information. One example is a profile of customers who have expressed interest in a given product by adding it to their wish lists. The client uses this profile to target a special offer to this customer segment. Other applications are also possible.

Using the CRMS, the client defines an event to record each instance of a customer (the subject) adding to his/her wishlist a product SKU. As part of the creation of the event definition, the client specifies a reference tag for the event, for example, “AddToWishList”.

This functionality does not require a master value.

The client also defines an event called RemoveFromWishList. When defining AddToWishList in the CRMS, the client defines RemoveFromWishList as the Reversing Event.

To implement this scenario, the following data integration is required:

  • Transaction and customer import file
  • Product catalog file
  • Generic Event import file

The client can then feed real time event data to TIBCO Reward through the API or send the same kind of data in batch files. Every instance of a customer adding to the wishlist or removing from the wishlist is recorded as an event. The event file used for batch processing can include multiple events.

The Wishlist data needs to include the following information:

  • Event reference tag (add to wishlist or remove from wishlist)
  • Event ID – Optional: Client can provide a unique identifier for the event. If the client does not provide this, TIBCO Reward will automatically assign its own unique event ID for internal processing purposes.
  • Customer ID (email address or other standard identifier as defined during on-boarding)
  • Date
  • Product SKU

When targeting, clients can create segments based on the customer wishlist events, including past events. For example, clients can create a segment for all customers who have added a net total of one or more items to the wishlist (additions minus removals) in the last month.