How we can allow audience ranking and set a limit in the AEP

[moni268]

Hi Team,

We want to explore options within AEP for setting a limit to the number of members who qualify for a segment.
For example : I am looking of options where we can rank members by their last activity date or their last purchase date and only qualify 10,000 members for an audience.  

Can you help us to provide which approaches we can consider another that audience portal rank feature, as it has limitation to rank only on numeric values attributes?

Thanks.

[nnakirikanti]

@moni268 Quick question do you have Data Distiller SKU? 

~cheers,

NN.

[DavidRoss91]

@moni268 I know that within Audience Composition and Federated Audience Composition, there is a toggle for limiting profiles based on rank. I'm not sure if this answers your question but the link to doc is here:
https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/ui/audience-composition

[brekrut]

Hello @moni268 

Ideally if you looking to perform limit the number of profiles which qualify for an audience, I recommend looking into the condition activity of Adobe Journey Optimizer.

The profile cap allows you to allow you to provide a limit on the number of profiles for a branch.

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/orchestrate-journeys/about-journe...

[RiteshY18]

@moni268 i would suggest looking into: audience composition: Rank and Split 

https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/ui/audience-composition#...

[supratim320 · Accepted solution]

To add one more option (nnakirikanti might have already hinted though), you can use scheduled sql job by using:

1. Ranking by using: ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ..)
2. Limiting to 10k records: LIMIT BY 10000