SOLVED
Audience Builder: Aggregate week over week
Im curious if its possible to aggregate by week in audience builder. For example, I want to create an audience of customers who complete 2 purchases in different weeks in the past 8 weeks.
Below is an example, but I think this format will become an issue when looking at customers who completed 3-5 transactions in different weeks in the past 8 weeks
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
1 Accepted Solution
Correct answer by
Hello @RyanMoravick ,
Based on my understanding after reading this document, it is currently not possible, but it is planned for the future.
URL:
https://experienceleague.adobe.com/en/docs/experience-platform/xdm/schema/best-practices
Quick solution: If you have a fixed time period, such as always looking back one month, you can use computed attributes. In this case, you can first aggregate the purchase events from the last month and then use this value in your segment builder.
URL: https://experienceleague.adobe.com/en/docs/experience-platform/profile/computed-attributes/overview
Kind regards,
Parvesh
Correct answer by
Hello @RyanMoravick ,
Based on my understanding after reading this document, it is currently not possible, but it is planned for the future.
URL:
https://experienceleague.adobe.com/en/docs/experience-platform/xdm/schema/best-practices
Quick solution: If you have a fixed time period, such as always looking back one month, you can use computed attributes. In this case, you can first aggregate the purchase events from the last month and then use this value in your segment builder.
URL: https://experienceleague.adobe.com/en/docs/experience-platform/profile/computed-attributes/overview
Kind regards,
Parvesh
