Follow these steps to create a new computed attribute in Data Studio:
- Go to the Customer Data section in the left-hand menu.
- Click Data Studio.
- Open the Computed Attributes tab.
- Click the + COMPUTED ATTRIBUTE button in the top-right corner.
- Enter a name for the computed attribute and click OK.
On the next screen, configure the computed attribute using the following inputs:
- Description: A summary for additional context.
-
Function: Choose how the attribute should be calculated (e.g., Sum, Count, Last).
- Use the Most frequent function to identify the value that occurs most often across events or product attributes—such as the most visited store or most purchased brand.
- Event: Select the goal event whose data will be used.
-
Attribute: Select a field from the chosen event or from product attributes to compute on.
- The list of attributes depends on the selected function and goal event. For example, choosing Sum with Purchase will surface numeric fields such as
revenue
ordiscount
.- Extended event attributes are included in the dropdown. They appear only for the event selected in the Event field.
- Extended product attributes are included in the dropdown. They are always visible and are not tied to a specific event.
- The list of attributes depends on the selected function and goal event. For example, choosing Sum with Purchase will surface numeric fields such as
Extended schema availability
Starting with the September 2025 release, all customers can access the extended schema when creating computed attributes.
- Extended event attributes: Previously limited to Advanced Data Package customers. They are now available to all customers.
- Extended product attributes: Newly introduced in the September 2025 release and available to all customers.
These attributes appear automatically in the attribute selection dropdown, giving you greater flexibility when defining computed attributes. No additional package or feature activation is required.
Supported functions
The table below lists the available functions you can apply:
Function | Description | Example use cases | Permitted attribute data types |
---|---|---|---|
Sum | Total of a numeric event or product attribute |
|
Numeric |
Count | Number of times an event occurs |
|
NA |
Count unique | Count of unique values in a list |
|
All |
First | First value of an event or product attribute |
|
All |
Last | Last value of an event or product attribute |
|
All |
Average | Average of a numeric event or product attribute |
|
Numeric |
Most frequent | Returns the most frequently occurring value of an event or product attribute |
|
String, integer, double, date (cardinality < 10,000) |
About the Most frequent function
The Most frequent function helps identify the most commonly occurring value of a selected attribute within the last 30 days. You can use it with event or product attributes of data types like string, integer, double, or date (cardinality < 10,000).
Set conditions (optional)
Use conditions to filter the events used in your calculation. Each condition includes:
-
Attribute: Event field to evaluate (e.g.,
brand
,sku
). -
Operator: Logical comparison (e.g.,
equals
,contains
,>
). - Value: Target value for filtering.
Select the time window
This defines the range of events included in the computation:
- This month: Current calendar month.
- This quarter: From the start of the current calendar quarter to today.
- This year: From January 1 of the current year to today.
-
Within past: A relative window, e.g.,
Last 30 days
. -
Between moving window: Custom start and end window, e.g.,
From 90 days ago to 30 days ago
.
These inputs define the behavior of the computed attribute. After configuration, proceed to validation and launch.
Validate and launch
Once the configuration is complete, use the controls in the top-right corner to finalize the setup:
- Save: Save the attribute as a draft and return to it later.
- Validate: Run the logic for a sample user to confirm expected results.
- Launch: Activate the attribute. Computation will begin and run on a daily schedule.
Once launched, a computed attribute will count toward your quota of active attributes. For more details, refer to the packaging and limits.
⏱️ Availability & refresh schedule
Once launched, computed attributes are typically available within an hour. They are automatically refreshed every day at 01:00 UTC.
📄 Where to find it
Once launched, you can view the computed attribute in the Computed Attributes tab of Data Studio. It will also appear in the Customer Schema tab, alongside other profile attributes.
Comments
0 comments