consent date and email | Community
Skip to main content
Level 3
October 19, 2023
Solved

consent date and email

  • October 19, 2023
  • 1 reply
  • 686 views

Hello

 

I am trying to getthe latrst consent date for each email from the last 3 years.

 

I am not sure how to use the function properly

 

ex: max(consetDate) 

but how can I group by email at the same time?

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 ParthaSarathy

Hi @rbiri ,

Have you tried the solution provided in below thread?

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-retrieve-all-recipients-with-same-email-with-a-different/td-p/627533

In the Deduplication, use consentDate instead of last modified.

The result transition of Deduplication activity will give you the latest consent date for each email.

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
October 19, 2023

Hi @rbiri ,

Have you tried the solution provided in below thread?

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-retrieve-all-recipients-with-same-email-with-a-different/td-p/627533

In the Deduplication, use consentDate instead of last modified.

The result transition of Deduplication activity will give you the latest consent date for each email.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups