SQL is a very critical skill for anybody who wants to make a successful career working in Marketing Cloud. In SFMC, data extensions and Contact Builder use a relational database. There comes SQL which provides a good way to execute queries and retrieve data for reporting or segmenting audiences. As a Marketing Cloud consultant, developer or data analyst, good knowledge of …
SQL Query to find if email was delivered, opened, clicked and event-dates
As an email marketer you will probably be in situations where you will be required to send a targeted marketing email to customers/prospects to achieve a desired outcome. And few days after the email is deployed you may be asked to provide a report to show how many emails were delivered/bounced, recipients who received the email, if they opened or …
Populating / Updating a Column in a Data Extension from Another DE in SFMC
This is a very common use case in Salesforce Marketing Cloud where you have been provided with a list of contacts (email addresses) and you are required to send a targeted message to those contacts that meet a certain condition. This could be status (engaged, unengaged, subscribed, unsubscribed), category affinity (services/products a contact prefers), last service call, last purchase date …