Digital Marketing & Automation Blog

Marketing automation blog

SQL

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

SQL Query to find if email was delivered, opened, clicked and event-dates Read More »

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

Populating / Updating a Column in a Data Extension from Another DE in SFMC Read More »

Scroll to Top