Unified Loyalty Events table¶

The Unified Loyalty Events table contains a row for loyalty program events, unique by Amperity ID and event datetime.

Note

Loyalty events are unique by Amperity ID and event datetime when:

The fk-loyalty-id semantic tag is applied to the same source field as the loy-event/loyalty-id field.
The loy-event/email semantic tag is applied to fields that contain email addresses.

Add table¶

The Unified Loyalty Events table is an optional table for the customer 360 database. It may be built as a passthrough table.

To add the Unified Loyalty Events table

From the Customer 360 page, under All Databases, select the menu for the customer 360 database, and then click Edit.
From the Database Editor, click Add Table.
Name the table “Unified Loyalty Events”.
Set the build mode to Passthrough.
From the Source Table drop-down, select the Unified Loyalty Events table.
Click Next.
Add a table description. This enables a tooltip that is visible from other areas in Amperity.
From the Table Semantics drop-down, select Unified Loyalty Events.
Under Version History, select Enable table version history.
Click Save.

Column reference¶

The Unified Loyalty Events table contains the following columns:

Column name	Data type	Description
Amperity ID	String	The unique identifier that is assigned to clusters of customer records that all represent the same individual. The Amperity ID does not replace primary and foreign keys, but exists alongside them within unified profiles. Note Loyalty events are unique by Amperity ID and event datetime when: The fk-loyalty-id semantic tag is applied to the same source field as the loy-event/loyalty-id field. The loy-event/email semantic tag is applied to fields that contain email addresses.
Accrual Amount	Integer	The loyalty rewards amount that was accrued.
Accrual Datetime	Datetime	The date and time at which loyalty rewards were accrued.
Award ID	String	The unique ID for an award that is associated with a redemption or accural event.
Current Point Balance	Integer	The loyalty rewards balance that is associated with the current loyalty event.
Current Tier	String	The loyalty tier that is associated with the current loyalty event.
Email	String	The email address that is associated with a loyalty ID. Also in: Unified Loyalty
Event Datetime	Datetime	Required. The date and time at which a loyalty event occurred. Note For transactions that represent accruals this value can also represent the date and time of the transaction.
Event Description	String	A description of the loyalty event.
Event Type	String	Required. The loyalty event type. May be one of the following values: “redemption”, “opt-out”, or “tier change”, or a custom event type.
Expiration Datetime	Datetime	The date and time at which loyalty awards accrue or the loyalty tier changes.
Loyalty ID	String	Required. The unique ID for a loyalty profile. Also in: Unified Loyalty
Order Datetime	Datetime	The date and time at which an order that used accrued or redeemed loyalty rewards was made.
Order ID	String	The unique ID for an order that is associated with a redemption or accural event.
Previous Point Balance	Integer	The loyalty rewards balance that is associated with the previous loyalty event.
Previous Tier	String	The loyalty tier that is associated with the previous loyalty event.
Redemption Amount	Decimal	The loyalty rewards amount that was redeemed.
Redemption Datetime	Datetime	The date and time at which loyalty rewards were redeemed.
Reservation Datetime	Datetime	The date and time at which a reservation that used accrued or redeemed loyalty rewards was made.
Reservation ID	String	The unique ID for a reservation that is associated with a redemption or accural event.
Tier End Datetime	Datetime	The date and time at which the current loyalty tier ends (or ended).
Tier Start Datetime	Datetime	The date and time at which the current loyalty tier starts (or started).