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).
- Event: Select the goal event whose data will be used.
-
Attribute: Pick a specific field from the selected event to compute on.
- The list of events or product attributes shown will depend on the selected function and goal event. For example, selecting Sum and Purchase will surface compatible numeric fields such as
revenue
ordiscount
.
- The list of events or product attributes shown will depend on the selected function and goal event. For example, selecting Sum and Purchase will surface compatible numeric fields such as
Attribute visibility depends on your plan
All users can create computed attributes with access to a limited event attribute schema. Accounts with the Profiles and schemas package can access a broader set of attributes. To enable extended schema access or increase your active attribute limit, please contact your Customer Success Manager (CSM).
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 |
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