Audience Builder: Aggregate week over week | Community
Skip to main content
RyanMoravick
New Participant
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
Parvesh_ParmarAccepted solution
New Participant
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
New Participant
October 1, 2024

Thank you again for your assistance @parvesh_parmar