Understanding computed attributes

Adobe Experience Platform enables you to easily import and merge data from multiple sources in order to generate Real-Time Customer Profiles. Each profile contains important information related to an individual, such as their contact information, preferences, and purchase history, providing a 360-degree view of the customer.

Some of the information collected in the profile is easily understood when reading the data fields directly (for example, “first name”) whereas other data requires performing multiple calculations or relying on other fields and values in order to generate the information (for example, “lifetime purchase total”). To make this data easier to understand at a glance, Platform allows you to create computed attributes that automatically perform these references and calculations, returning the value in the appropriate field.

Computed attributes include creating an expression, or “rule”, that operates on incoming data and stores the resulting value in a profile attribute. Expressions can be defined in multiple different ways, allowing you to specify which events to aggregate on, aggregate functions, or the lookback durations.

Functions

Computed attributes let you define event aggregates in a self-serve manner by leveraging pre-defined functions. The details on these functions can be found below:

Function
Description
Supported data types
Example usage
SUM
A function that sums up the specified value for qualified events.
Integers, Numbers, Longs
Sum of all purchases in the last 7 days
COUNT
A function that counts the number of events that have occurred for the given rule.
N/A
Count of purchases in the last 3 months
MIN
A function that finds the minimum value for the qualified events.
Integers, Numbers, Longs, Timestamps
First purchase data in the last 7 days
Minimum order amount in the last 4 weeks
MAX
A function that finds the maximum value for the qualified events.
Integers, Numbers, Longs, Timestamps
Last purchase data in the last 7 days
Maximum order amount in the last 4 weeks
MOST_RECENT
A function that finds the specified attribute value from the latest qualified event. This function gives both the value as well as the timestamp of the attribute.
All primitive values, Arrays of primitive values
Latest product viewed in the last 7 days