1

I'm reading the documentation on retention policies for data extensions.

One thing is unclear - hoping someone can clarify.

If I set the retention policy to work on individual records, what happens if I update an existing record? Does the retention period reset? Or does the retention period strictly apply to the date/time the row was created?

1
  • 2
    The only time it can be 'reset' is when you choose the 'all data' or 'all data and DE' options - which you can select the Reset Retention Period On Import option which will reset the date for all records. The individual records retention does not give this option. You would need to either create your own retention via SQL or reinject the records once they are removed via import or SQL. Dec 20, 2019 at 13:58

1 Answer 1

6

The retention is set when the record is added to the Data Extension. At that time, there is a timestamp created in the database, which is not visible in the application. That field stores the date that the record was added. It then uses that field to compare it to the retention, to determine whether or not the record needs to be removed.

If a record is updated, it does not change that field's date. So if you add a record, with 180 day retention, it will be removed once that time has elapsed regardless of if it has been updated or not.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.