We have created sync Data Extensions of Salesforce objects such as Contact, Transactions and store location. We would like the ability to create filtered data extensions on this data for email sending and Ad Studio audiences.
Support has suggested we query (not filter) on sync Data Extensions as it causes errors. End users need the ability to use drag and drop because of no knowledge of SQL.
Reports is not an option because our exclusion lists are data extensions and they cannot be used in conjunction with a report.
Only solution we can come up with is create a query to replicate the sync DE's or create an import of the same information. Wondering what is the use of sync DE unless they are only for customers that write SQL only.
Would love your suggestion on how we could have access to all this information with drag and drop filter feature in Marketing Cloud.