0

Is it possible to change the data retention settings of an already-created DE? I have DE's that are automated. An automation puts data view information into these DE's but when I edit, I cant see the option to modify the retention settings.

Also when it comes to time format for event dates in the data views (https://help.salesforce.com/articleView?id=mc_as_data_view_open.htm&type=5)

Is it for MC to store it as an EPOCH time instead of a specific time zone?"

5

You can change data retention settings for existing data extensions, even when they contain data. This can for sure be done in Contact Builder: enter image description here Just click on Edit under Data Retention, and change the setting to On: enter image description here If Data Retention is already set, using same approach should also allow you to change the settings.

With regards to timezone, all the event timestamps in SFMC (e.g. open and click timestamps) are stored in system time, which is UTC-6.

| improve this answer | |
  • OOOOOO Thanks the data retention settings are not viewable in email studio, but in contact builder. Very helpful. With the timestamp it is NOT possible to change from utc-6? just wondering - so our developers would have to do a conversion function – Bloodborne Feb 20 at 12:49
  • You're welcome @Bloodborne - remember to mark the answer as accepted/upvote if it has been helpful. You can't change the default system time, unfortunately. – Lukas Lunow Feb 20 at 12:50

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.