Designing a Data Extension in SFMC: The Four Decisions First
SapotaCorp
Almost every new SFMC engagement starts the same way. The client sends a 40-column Excel file of customer data and says "import this into SFMC." The team creates a Data Extension that mirrors the Excel columns. Two weeks later the DE can't send email, can't relate to other DEs, and one field won't import because the data type is wrong. The fix is four decisions made before the DE is created, not after. Decision 1: What is this DE for? Sendable DE: will be used to send email. Tick "Is Sendable" i