Skip to main content
Verify the version tags to ensure you are consuming the intended content or, complete the latest version.

Creating new aggregates on streamable data

In Pega Customer Decision Hub™, Pega Customer Profile Designer lets you define aggregated summaries on streamable data. You can add, edit, or remove aggregates directly on the summary rule using various functions and conditions.

Video

Transcript

This demo shows you how to add new aggregates to a summary and test the calculations.

The U+ Bank technical team has completed setting up the Customer Profile Designer Accelerator and integrated the U+ Bank website with Customer Decision Hub. The marketers want to extend the financial clickstream summary with a new attribute that calculates the average time customers spend on the account overview page in the last 7 days.

The technical team has notified you that every time a customer navigates the U+ Bank website, an event is sent to the clickstream service. They share the following data structure with you.

Property Description Type List of Values

Event

Type of event that occurred

Text

PageView

Login

Logout

Page Type

The type of page that the visitor visited

Text

Home

Account

Card

Deposit

Loan

Investment

Page View Active Time

The time in seconds the visitor spent on the page

Integer

 

To create a new aggregation, navigate to the Summaries tab on the Profile Data Sources landing page and launch the Financial services clickstream summary rule.

List of profile data sources

 

The Summary rule lists the attributes that define how the clickstream data is aggregated. Each aggregate must have a unique Name, an aggregate Function, and a time window. The type of aggregation function automatically determines the property type (text, integer, or decimal). Create a new aggregate that calculates the average time spent on the account overview page. Give the aggregate a unique name, Avg Active Secs Account Last 7 Days. The ID for the aggregate is set automatically. It is important to keep the name as short as possible.

You can use seven functions for the aggregations. Common mathematical functions such as Sum, Count, Average, Min, and Max are available for calculations. You can also use the First and Last functions for storing the first or last value of a given attribute. For example, the name of the last website page that the customer visited.

In the Function list, select Average. The selection forces you to choose the field for which you want to calculate the average. Note that you can select only numeric fields from the list of values because this function is a mathematical function. Select PageViewActiveTime. Now, enter the time window for the aggregation. You can let the aggregation occur without a time frame (since the start of the aggregation), or you can define a sliding window in minutes, days, or weeks.

Create avgactivesecsaccountlast7days aggregate

 

Now that you have entered the name, function, and time window for the aggregate, it is time to create a condition that filters only the relevant events that you want calculated. In this case, you want to calculate the average only when the Event is PageView and PageType is Account. Any other case where the condition is not satisfied is not considered during calculation.

Create the conditions

 

After you successfully add an aggregate and save the summary rule, the property is created and marked as relevant for availability in engagement policies.

Because the summary is already associated with the customer, test whether the values are being calculated and stored.

Launch the U+ Bank website and log in as Troy. Logging in creates a single web activity for Troy by accessing his Account overview page.

The account overview of Troy

 

Navigate back to Dev Studio, and then browse the Clickstream data set to confirm that the event data is sent to Customer Decision Hub.

Browse the data set to confirm that there is a single event. Take a closer look at the Event, PageType, and PageViewActiveTime attributes. When Troy logs in to the U+ Bank website, an event occured where the Event is PageView,and the PageType is Account, and the PageViewActiveTime is 25 seconds.

View the Event PageType and PageViewActiveTime values

 

The Financial services clickstream summary uses the Clickstream data set as its source. Every time an event is produced and the aggregate condition is satisfied, the corresponding attribute is re-calculated.

Now, browse the FSClickstream data set to view the AvgActiveSecsAccountLast7Days attribute. Because Troy viewed the Account overview page only once, the calculation is equal to the PageViewActiveTime.

Go back to the U+ Bank website, log out, and then log back in to create an additional event for the Account overview page.

Return to Dev Studio, and then browse the Clickstream data set. Notice that there are three events on the stream. The first event indicates the first login from Troy. Logging out and navigating to the home page generated another event. Then, logging back in as Troy sent a third event. Note that the average time spent on the page is 3 seconds.

Review the 3 records in the Clickstream

 

Browse the FSClickstream data set to confirm that the average is calculated.

Browse the FSClickstream data set

 

This demo has concluded. What did it show you?

  • How to create a new summary aggregate
  • What event data is generated in the Clickstream data set, and how this data is aggregated in the FSClickstream dataset

Challenge

Tip: To practice what you have learned in this topic, consider taking the Creating new aggregates on streamable data challenge.

This Topic is available in the following Module:

If you are having problems with your training, please review the Pega Academy Support FAQs.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Academy has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice