How we can allow audience ranking and set a limit in the AEP | Community
Skip to main content
M
moni268
New Participant
February 6, 2025
Solved

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

  • February 6, 2025
  • 5 replies
  • 922 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.


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:

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

5 replies

S
supratim320Accepted solution
New Participant
February 13, 2025

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
    RiteshY18
    RiteshY18
    New Participant
    February 7, 2025

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

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

     

      brekrut
      brekrut
      Employee
      February 6, 2025

      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

        DavidRoss91
        DavidRoss91
        New Participant
        February 6, 2025

        @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

          nnakirikanti
          nnakirikanti
          New Participant
          February 6, 2025

          @moni268 Quick question do you have Data Distiller SKU? 

           

           

          ~cheers,

          NN.

            Terms & ConditionsAccessibility statement

            Loading footer...