Solved

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

Forum|Forum|1 year ago
February 6, 2025
5 replies
924 views

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.

Experience Platform

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 supratim320

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

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

nnakirikanti

Community Advisor

@moni268 Quick question do you have Data Distiller SKU?

~cheers,

NN.

DavidRoss91

Community Advisor

@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

Adobe Employee

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-journey-building/condition-activity#profile_cap