How to create a computed attribute that counts the total of email opens in the last month?
Dear Community,
I am a RTCDP and AJO user who is trying to create a computed attribute that counts the amount of emails a user has opened in the previous month. I am struggling to create it and I am writing to see whether anybody can help me solving the issue. The purpose is to a have this field at profile level, even knowing that we can count the amount of emails opened when creating audiences.
How was it created?
It was created by applying the following settings:
-select interactionType event
-equals "Message opened"
-Count
-1 Month
-Fast refresh is checked
The definition looks like this:
It generates the following expression:
xEvent[_experience.customerJourneyManagement.messageInteraction.interactionType in ["open"]].count()
After creating it, I noticed the info "Summary data is not available for this field due to lack of clustered values" in the InteractionType field. Is this somehow related to the Summaries job? I admit I didn't understand it.
Value distribution is empty, last evaluated on 03/23/2025, 10:00 PM:
This is the link I've followed to create the attribute:
Other links I navigated to:
https://experienceleague.adobe.com/en/docs/experience-cloud-kcs/kbarticles/ka-25851
My apologies for the long post. I am new to computed attributes and I did my best to share here what I've done so far.
Any help here would be highly apprecitaed.
Best Regards,
Filipe C. Freitas
