Search through more than a hundred articles on every aspect of User.com

Alina Shafikova
Written by Alina Shafikova

Aggregators

How to aggregate data from events and from their attributes


What is an aggregator?

An aggragator is a module that lets you collect numerical data. You can either count event occurrences or sum up the value of their attributes.

Note: Aggregators can be activated only via automations.

How to use it

First, go to "Tools" -> "Aggregators" and click "Create".

Fill in the fields "Name" and "Description".

Set up the rest according to the descriptions below.

Calendar/Relative

If you select the option, "Calendar", the system will aggregate values for the exact period you specify.

If you select "Relative", the larger number typed will represent the beginning of the period (in days in the past), and the smaller, the end of the period (in days in the past). In the example below, the aggregator would count how many times the event was sent in the last 30 days.

Aggregation subject

The total number of event occurrences - The aggregator will return how many times the event was sent (e.g. Count how many purchases each user has made in the last X days).

The total number of event occurrences with a certain attribute - The aggregator will return the number of events of a given name that carries a specified attribute(s).

Sum of certain attributes - The aggregator will return the sum of values of a specified attribute(s) for events of a given name (e.g. Count the value of each user’s purchases in the last X days).

Event

Choose the desired event from the drop-down menu.

Attribute name

If, as the "Aggregation type", you select “Event count”, you can leave the field blank. Otherwise, select the attribute whose value you want to sum up or whose existence you want to check.

Aggregation subject

For all the users together - The aggregator will return the overall sum for all users in your database; the result of this calculation will be visible in the module, "Dashboards", and on the page of given aggregator.

For each user separately - The aggregator will calculate data for each user.

For each company based on employee events - The aggregator will calculate data for all the people from a given company.

Time interval

This field will be visible only if you choose “For all the users together” in the previous step.

Type the sum of days you previously set up in the section "Calendar/Relative".

Custom attribute

This field will be visible if you choose “For each user separately” or "For each company based on employee events” in the previous step.

Here, you choose the name of the attribute where the aggregation result will be stored.

Example

In the example below, the aggregator will go through your whole database looking for events called “purchase” that carried the attribute “template” and were sent in March 2018.

The result will be the number of how many such events were found.

Example 2

In the example below, the aggregator will return the number of applications each user created in the last year and will store the number in user attribute called “apps”.

How to activate an aggregator

To make the aggregator work, create an automation.

Go to "Automations" -> "Create".

You can trigger the automation with anything you want and add the module, "Aggregator" at the end. (You can find this module in the section "Actions".)

Aggregation results

Global

To see results of your aggregation, go to "Dashboards" and add a widget from the category "Aggregates".

For given user/For companies which user is assigned to

Results of your aggregation in these two cases are saved as a value of "Custom attribute selected" when creating your "Aggregator".

Categories: