Data Extension Retention Policies

Objective:

✅ Create three separate Data Extensions (DEs).
✅ Apply a different retention policy on each DE.
✅ Monitor & analyze the impact over time.

DE with Different Data Extension Retention Policies & Adding records

Create three Data Extensions with unique names:

• DE_IndividualRetention (For Individual Record Retention)

• DE_AllRecordsRetention (For All Records Retention)

• DE_FullDeletion (For Data Extension & Records Retention)

Data Extension Name	Retention Type	Settings
DE_IndividualRetention	Individual Records	Deletes specific rows after 30 days
DE_AllRecordsRetention	All Records	Clears all data but keeps structure every 60 days
DE_FullDeletion	Data Extension & Records	Deletes entire DE after 90 days

• Individual Records: Deleted specific rows after 30 days

• All Records: Clears all data but keep structure every 60 days

• Data Extension & Records: Clears all data but keeps structure every 60 days

Monitor & Analyze Over Time 📊

1️⃣ Track data changes daily or weekly in each DE.
2️⃣ Note when records start disappearing (Individual vs. All Records).
3️⃣ Confirm when DE_FullDeletion is permanently removed after 90 days.
4️⃣ Check Email Studio reports to ensure data is retained/deleted as expected.