The attributes listed in the following table are only available in the shopper profile category.
Attribute | Description | Visible to account-based shoppers | Site-specific (if multiple sites exist) |
---|---|---|---|
Email address | The shopper’s email address. | No | No |
Receive email | A shopper can opt in/opt out of email notifications | No | No |
Gender | The shopper’s gender. You can only use this attribute in a rule if you are collecting gender information in a custom widget. | No | No |
Lifetime spend | Grand total, including tax and shipping, of the shopper’s order totals. Orders must be qualifying orders. See Qualifying orders. | No | Yes |
Lifetime average order value | Average of the shopper’s order totals, including tax and shipping. Orders must be qualifying orders. See Qualifying orders. | No | Yes |
Number of orders | Number of orders for this shopper. Orders must be qualifying orders. See Qualifying orders. | No | Yes |
Last purchase amount | Total of the shopper’s last order, including tax and shipping. Order must be a qualifying order. See Qualifying orders. | No | Yes |
Registration date | The date that the shopper’s profile was created | Yes | No |
First purchase date | The date of the shopper’s first order. Order must be a qualifying order. See Qualifying orders. | No | Yes |
Last purchase date | The date of the shopper’s last order. Order must be a qualifying order. See Qualifying orders. | No | Yes |
Previous visit date | For a currently logged in shopper, the date of the visit before the current one. For a shopper who is not logged in, the date of the visit before the last one. Note: Another attribute, Last visit date, is the date of the current visit for a currently logged in shopper, or the date of the last visit for a shopper who is not logged in. | Yes | Yes |
Note:
If your Commerce Cloud site was up and running prior to this release, the lifetime value properties for your shoppers will reflect data beginning with your upgrade to this release, or if you skip this release, the first subsequent release to which you upgrade. This means that orders submitted prior to your upgrade will not be included in the Lifetime Spend, Lifetime Average Order Value, or Number of Orders values. In addition, the Last Purchase Amount, First Purchase Date, Last Purchase Date, and Previous Date values will only reflect purchases and visits made after the upgrade.
The Lifetime spend and Lifetime Average Order Value (AOV) properties are raw numbers, that is, they do not include a currency. If a site’s default currency changes, the values of Lifetime Spend and Lifetime AOV will become inaccurate.
If you use different default currencies on different sites, and you want to create audiences based on Lifetime Spend or Lifetime Average Order Value, define an audience for each site (currency). For example, you can define an audience “High Spenders USD” with the rule “Lifetime Spend > 1000” and another audience “High Spenders euro” with the rule “Lifetime Spend > 940”.
Qualifying orders
A qualifying order must meet the following conditions.
The order uses the default currency of the site on which the order was placed.
Note that if a site’s default currency is monetary, and shoppers can use loyalty points to pay for some or all of an order, then Lifetime spend and Lifetime average order value attributes reflect only the monetary portion of the total - even if this total consists only of tax and shipping.
The order is in one of the following states:
SUBMITTED
The order has completed the purchase process and has been submitted to the order management system.
PROCESSING
The order is being processed by the order management system.
NO_PENDING_ACTION
The order has been fulfilled, and processing of the order is complete.
Each payment associated with the order is in one of the following payment states:
AUTHORIZED
The payment has been authorized and can be debited.
SETTLED
The payment has been debited successfully.
PAYMENT_DEFERRED
Only applicable for invoice and PO orders where an invoice is sent to the shopper.
For more information on order and payment states, see the Manage Orders chapter in Extending Oracle Commerce Cloud.