Question
CBA (Commonwealth Bank of Australia)
IN
Last activity: 29 Aug 2024 8:39 EDT
Last Interaction and count of interactions of a customer in pega cdh
Hi Alll,
Trying to achieve below 2 requirements:
1) Last Interaction of customers
2) count of interactions of customers based on say outcome or decision time.
Tried using Activity>>RDB Methods with SQL Queries to get the results (Group by SubjectID)
Any other optimal way? Keeping performance in mind.
Can we use Summaries + Aggregates to achieve these both the requirements?
Any suggestion would be helpful.
Thanks!
Priyesh A
Pegasystems Inc.
IN
@Priyesh Can you explain the business use case or the requirement you are trying to accomplish? That will help us understand the need better and can provide the appropriate suggestions.
CBA (Commonwealth Bank of Australia)
IN
Thanks for your response.
Requirement is get the aggregate values based on some attributes (last 30,20 days count) and also to get last interaction based on say outcome time.
We are able to achieve these using Summaries in Profile Data Source.
We can further associate these summaries with Primary Context in Profile Designer.
Please add if you can suggest something else here.