In an Offer flow, how to query whether previous emails have been opened?

General
,
1

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?

2

@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)
  • 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.