Creating aggregates

To analyze events in the context of an individual customer, create an aggregate.

Requirements


A tracking code implemented into the website.

Procedure


Aggregate wizard

  1. Go to Analytics icon Analytics > Aggregates > New aggregate.
  2. Enter the name of the aggregate.
  3. Optionally, to let other users know about the objective of the analysis, write a short description.
  4. By clicking the Three-dot icon button, define the type of aggregate result. You can choose from:

    • Exists - The result of an aggregate informs you whether a chosen event has occurred in the time range selected in the analysis. The result of the aggregate returns boolean.
    • Sum - The result of the aggregate returns the total value of the event parameter in the time range selected in the analysis.
    • Min - The result of the aggregate is the minimal value of the event parameter in the time range selected in the analysis.
    • Max - The result of the aggregate returns the maximal value of the event parameter in the time range selected in the analysis.
    • Average - The result of the aggregate returns the average value of the event parameter in the time range selected in the analysis.
    • Count - The result of the aggregate returns the number of event occurrences in the time range selected in the analysis.
    • LAST - The aggregate result shows the latest value of the event parameter in the time range selected in the analysis.
    • FIRST - The aggregate result shows the first value of the event parameter in the time range selected in the analysis.
    • FIRST_MULTI - The aggregate result shows a list of items of the defined size. There are two options for the completion of the list here - it can either be filled with parameters from only the first event, or it can be filled with parameters from the first event and subsequent events, if the first one did not contain enough items.
    • LAST_MULTI - The aggregate result shows a list of items of the defined size. There are two options for the completion of the list here - it can either be filled with parameters from only the last event, or it can be filled with parameters from the last event and preceding events, if the last one did not contain enough items.
  5. From the dropdown list, select an event. Customers who performed a specific action (that is reflected by the selected event) are considered in the analysis. To define the details of the event, perform the action described below:

    • If you want to be more specific and analyze a particular aspect of the event, click the Where button, to select event parameters.
  6. To determine the time range from which the data will be analyzed, click the calendar icon.

  7. Optionally, if you want to show this aggregate on a customer card, switch the Show in client card option on. As an effect, you can check the results of the aggregate for a particular customer on a customer card.

  8. To complete the process, click the Save button.

😕

We are sorry to hear that

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

😉

Awesome!

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.