Audience Builder: Aggregate week over week | Community
Skip to main content
RyanMoravick
Level 4
September 30, 2024
Solved

Audience Builder: Aggregate week over week

  • September 30, 2024
  • 1 reply
  • 697 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Parvesh_Parmar

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

1 reply

Parvesh_Parmar
Community Advisor
Parvesh_ParmarCommunity AdvisorAccepted solution
Community Advisor
October 1, 2024

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

Parvesh Parmar – Adobe Community Advisor https://www.linkedin.com/in/parvesh-parmar/
RyanMoravick
Level 4
October 1, 2024

Thank you again for your assistance @parvesh_parmar