Repo with SQL Queries needed to setup DataViews in SFMC
Caution: Works with unencrypted user data, in case encryption is required apply hashing to appropriate fields in SQL.
Documentation on field values: https://help.salesforce.com/articleView?id=sf.mc_as_data_views.htm&type=5
Steps:
-
Create data extensions according to documentation
-
Automation Studio
- Use these SQL Queries to fill the Data Extensions
- Export the Data extensions to SFMC SFTP