Question
Closed
Solved
In an Offer flow, how to query whether previous emails have been opened?
I am working with outgoing email campaigns that send several emails. I have a requirement to make a decision in the Offer flow based on whether the recipient has opened one of the previous emails:
- send email 1
- send email 2
- if (recipient has opened email 1 or 2)
... do something
else
... do something different
I don't see any obvious way to do something like this. Can anyone point me in the right direction?
***Edited by Moderator: Pooja Gadige to add platform capability tag***
To see attachments, please log in.
Accepted Solution
Posted: 3 years ago
Updated: 3 years ago
Updated: 7 Jul 2021 14:18 EDT
Crestone Technology
Crestone Technology
MX
@RuleSmith I figured out an approach to do this.
In Data-Decision-IH-Fact
- created a report ImpressionsAndClicksForCustomerInCampaign
- accepts parameters
- CampaignID (WorkID of Campaign)
- CustomerID (pySubject of Customer)
- returns records where pyOutcome is in (Impression, Clicked)
- accepts parameters
- created Data Page D_ImpressionsAndClicksForCustomerInCampaign to call the report and pass the same parameters
In PegaMKT-Work-Offer
- created When condition HasCustomerInterractedWithThisCampaign
- returns true when the Data Page has some results: 0<D_ImpressionsAndClicksForCustomerInCampaign[CustomerID:.CustomerID, CampaignID:.CampaignID].pxResultCount
I call the When condition from Offer flows. If someone is reading this and wants more details, feel free to ask.