I note that when you send an email to a Salesforce Audience from Content Builder (e.g. a Salesforce Campaign or Report) it creates a Salesforce Send under-the-hood and creates a temporary DE in your root folder (with a filename
SalesForce-[GUID]) and applies a retention policy of 5 days, which you can't change (unless you use the API).
The issue is that all VAWP links break after the DE is deleted and Subscribers see the following message when they click on the link:
The system is temporarily unavailable. We apologise for any inconvenience. Please try again later.
This apologetic message is misleading as they can't simply "try again later"...
The only solution that I can think of is to create an automation that runs daily and includes a Script Activity that performs the following tasks:
- Retrieve all DEs prefixed with
SalesForcethat have been created in the past 24 hours
- Use WSProxy to update the Retention Policy of these DEs from 5 days to something more sensible (like 3 months)
Am I missing something here? How do others workaround this issue?