Deduplication on multiple variables | Community
Skip to main content
kenr68686816
kenr68686816
New Participant
Oct 5, 2019 12:28 PM UTC
Solved

Deduplication on multiple variables

I’m working on a DM campaign and the requirement is to target 1 person per household based on this rankin:

  • Former customer
  • Recent responder
  • Top 4 deciles
  • Gender

my internal support suggests creating a view rather than doing the prioritization within Adobe?

Thoughts?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Jyoti_Yadav
    Jyoti_YadavAccepted solution
    Level 8
    Oct 10, 2019 6:33 AM UTC

    Hi Ken,

    You can achieve this via two ways:

    1) Dedup: You can also define these list of parameters for dedup and then select option for dedup method: 'using a list of values'.

    2) Query Activity: Use Group by in Advanced parameters. Define aggregate condition for fields on which you want to find latest records.

    Thanks,

    Jyoti

    View reply

    4 replies

    pablo_rosero1
    pablo_rosero1
    Level 9
    Oct 17, 2019 1:57 AM UTC

    Hi Ken,

    Moving this to Adobe Campaign Classic​. Please post your Campaign Classic questions directly here in the future.

    Thank you for participating in our community!

    Pablo

    Translate
    Jyoti_Yadav
    Jyoti_YadavAccepted solution
    Level 8
    Oct 10, 2019 6:33 AM UTC

    Hi Ken,

    You can achieve this via two ways:

    1) Dedup: You can also define these list of parameters for dedup and then select option for dedup method: 'using a list of values'.

    2) Query Activity: Use Group by in Advanced parameters. Define aggregate condition for fields on which you want to find latest records.

    Thanks,

    Jyoti

    Translate
      kenr68686816
      kenr68686816Author
      New Participant
      Oct 9, 2019 11:07 AM UTC

      Thank you.  We’re using Classic, so the merge option will work.

      Ken

      Translate
      Raj_Ganta-1
      Raj_Ganta-1
      Level 5
      Oct 9, 2019 12:47 AM UTC

      Hi,

      If you can create a view which satisfies the requirement, then that is the best way as you can avoid ETL process in Campaign. I have seen similar use case but that was in Classic and it has merge functionality in the dedup activity whereas Standard does not have merge function in the dedup activity.

      you can check this for the classic implementation and it is pretty good.

      Use the merge functionality within the deduplication activity

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...