
Use Case - Creating a new clickstream summary
2 Tasks
30 mins
Intermediate
Pega Customer Decision Hub '24.2
Next Best Action
English
Scenario
The technical team has successfully developed the infrastructure for streaming web activity data, and the Pega Customer Decision Hub™ application contains an installation of the Behavioral data accelerator component.
As a result, the U+ Comms website is now streaming the web activity of subscriptions to the ProcessClickstreamData data flow. The integration team provides the following information:
- The website creates clickstream events only if the user has successfully authenticated on the U+ Comms website and has a valid cookie.
- Currently, the website creates clickstream events only for the Account page and the Home page. However, the product pages will begin streaming events in a later phase of the project.
- The following example shows a sample JSON payload for the BehavioralData clickstream service:
{
"CustomerID":"1111111111",
"InterestedIn":"",
"InterestLevel":"",
"DeviceType":"PC",
"EventType":"PageView",
"PageType":"Account",
"PageViewActiveTime":"45",
"CookieID":""
}
- The integration team also shares the following data structure with you:
Field ID Description Type List of Values CustomerID
CustomerID
The unique ID of the Subscription. Maps to the SubscriptionID in Customer Decision Hub.
Text
1111111111, 2222222222….
Device type
DeviceType
The type of device the visitor used to access the page
Text
PC
MobilePage location
PageLocation
The actual URL of the page. This value is not used for aggregation.
Text
www.uplus.com
Event type
EventType
Type of event that occurred:
PageView when the user is authenticated and logs in to the website.Text
PageView
AccessEvent timestamp
EventTimestamp
The timestamp when the event occurred. By default, the shipped summaries aggregate on system time rather than on EventTimestamp
DateTime
20240101T112714.204 GMT
Page type
PageType
The type of page that the visitor visited.
Text
Home (the login page in U+Comms)
Account (the page after successful login)
Offer (the page after clicking on an action)Page view active time
PageViewActiveTime
The time in seconds the visitor spent on the page
Integer
123, 234….
Cookie ID
CookieID
Currently not used.
Currently not used.
Unavailable
Prospect ID
ProspectID
Same as CookieID. Specific to certain third-party integrations, otherwise leave this field blank.
Currently not used.
Unavailable
Tip: A variation of this scenario exists in Creating new aggregates on streamable data.
Detailed Tasks
1 Other details
- In the Profile Data Sources, add the Process clickstream data Data flow to the allowlist. For the Event timestamp, select Use System time.
- In the Profile Data Sources, create a new Summary named UComms Clickstream that aggregates the data in the Process clickstream data data flow for each CustomerID.
- In the UComms Clickstream summary, create the following aggregations:
Aggregate Name ID Detail Avg Active Secs Acct Last 1 Day
AvgActiveSecsAcctLast1Day
Calculates in seconds the average time spent on the Account page over the last day.
Avg Active Secs Home Last 1 Day
AvgActiveSecsHomeLast1Day
Calculates in seconds the average time spent on the Home page over the last day.
Last Page
LastPage
Calculates the last page type visited by the subscriber over all time.
- Associate the UComms Clickstream summary with the Subscription entity, where SubscriptionID maps to CustomerID.
- Using Prediction Studio, add the newly defined aggregates to the Web Click Through Rate Subscription adaptive model.
- On the exercise landing page, log in to the U+ Comms website with the following profiles to generate clickstream data:
- Log in to the U+ Comms website as Bhuvi.
- Log out from the U+ Comms website.
- Log back into the U+ Comms website as Bhuvi.
- Log in to the U+ Comms website as Bhuvi.
- Confirm the aggregates are calculated for Bhuvi (SubscriptionID: 1111111111) on the Behavioral data tab, in the Customer Profile Viewer.
2 Acceptance criteria
- Use Customer Profile Viewer to confirm that the values in the UComms Clickstream summary for Bhuvi are aggregated correctly.
- The predictors are added to the Web Click Through Rate Subscription adaptive model.
Available in the following mission:
If you are having problems with your training, please review the Pega Academy Support FAQs.
Want to help us improve this content?