Deduplication on multiple variables

Avatar

Avatar

kenr68686816

Avatar

kenr68686816

kenr68686816

05-10-2019

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Jyoti_Y

MVP

Avatar

Jyoti_Y

MVP

Jyoti_Y
MVP

09-10-2019

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

Answers (3)

Answers (3)

Avatar

Avatar

Raj_bounteous

MVP

Avatar

Raj_bounteous

MVP

Raj_bounteous
MVP

08-10-2019

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

Avatar

Avatar

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

16-10-2019

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

Avatar

Avatar

kenr68686816

Avatar

kenr68686816

kenr68686816

09-10-2019

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

Ken