When creating an aggregate in your project, it can be tricky to find where you can view its values or to understand why they don't appear at all. This article will help you investigate this.
Where to find an aggregate value
Customer aggregate values appear directly in customer profiles. Navigate to the specific customer, then click AGGREGATES under Properties. Look up your aggregate by its name in the search bar if needed.
Reasons for missing aggregate value
Aggregate vs Running aggregate
Only regular (customer) aggregate values appear in the customer profile. If you have created a running aggregate, it becomes an event attribute and can't be looked up in the customer profile UI.
No matching events on the profile
Since aggregates are built only from existing customer data, if the data isn't present, an aggregate won't return any values. For example, if your aggregate sums all purchase prices and there are no purchase events on a customer profile, the aggregate will not show a value.
The filters are too restrictive or incorrect
If you are sure the customer should have a value in the aggregate, but the field is still empty, compare the aggregate setup with the customer profile. Check whether the same event, event attribute, and filters used in the aggregate are also present on that customer's profile. A good way to verify this is to open the relevant event directly in the profile and confirm that the expected attributes and values are really there.
Example
In the example below, the last(purchase.status)aggregate only checks purchase events with a specific payment method. On the customer profile, the purchase event has a different payment method. An empty value of last(purchase.status) is expected in this case.
Solution
Adjust the aggregate filter to include the required payment method, or remove it completely.
The date range excludes relevant events
The events you use in the aggregate may exist on the profile, but not within the time window defined in that aggregate. Adjust the time range to best match your goals.
The aggregate is a part of an initiative
If you are using initiatives to keep your data organized, it is important to understand that non-global aggregates within an initiative will not appear in the customer profile. Make your aggregate a Global object to both keep it within an initiative and see it in the customer profile.