One of our top use cases for CJA is being able to see journeys based on audience membership from RT-CDP. For example, the question is typically, "for people who were in my audience on x date when it was activated, how many visited x site or bought x product".
Our way of doing this involved creating an event dataset that tracks audience membership, so we get an event every time they enter or exit an audience. We then count entrances as 1, exits as -1, and sum them in a derived field. The people that sum to 1 were in the audience. We do this sum over a specific date range. For example, if the audience was created on 11/1, and we want to see the audience population on 12/1, then the date range set in the derived field would be 11/1, 12/1.
This is the problem. Since we need to set the date range in the derived field, no matter what the date range is in the panel is workspace, it will only show events between 11/1 and 12/1 since that was set in the derived field. This is rather useless, because if the audience was activated on 12/1, analysts want to see conversions that occurred after that.
Is this fixable? And if not, is there any other way people have done this use case in the past that I am not thinking of?
Thanks so much!
