Write an SQL query and the purpose is to insert all the unsubscribed data into the data extension.

 SELECT

    U.SubscriberKey,
    U.JobID,
    U.EventDate AS UnsubscribeDate,
    J.EmailName,
    J.EmailSubject,
    S.EventDate AS SendDate,
    'Austin Marketing' AS 'Austin Unit'
FROM
    _Unsubscribe AS U
INNER JOIN
    _Job AS J ON U.JobID = J.JobID
INNER JOIN
    _Sent AS S ON U.JobID = S.JobID
WHERE
    U.IsUnique = '1'
    AND U.EventDate >= DATEADD(DAY, -1, CAST(GETDATE() AS DATE))
    AND U.EventDate < CAST(GETDATE() AS DATE)

Comments

Post a Comment

Popular posts from this blog

What are the different Content Blocks in SFMC ?

  In Salesforce Marketing Cloud (SFMC), there are various Content Blocks that you can use to create dynamic and personalized email content. Here are some examples of commonly used Content Blocks with brief explanations: Text Content Block: Description: This block allows you to add text content to your email, including headings, paragraphs, and inline styling. Example: Adding a text block to provide a brief introduction or description of a product or promotion. Image Content Block: Description: This block enables you to insert images into your email. Example: Including a product image or a promotional banner to visually enhance the email content. Button Content Block: Description: This block allows you to create call-to-action buttons with customizable text, URLs, and styling. Example: Adding a "Shop Now" button that links to a specific product page on your website. HTML Content Block: Description: This block lets ...
Read more

What is the different email-sending options in SFMC with examples?

Salesforce Marketing Cloud (SFMC) offers various email-sending options to cater to different use cases and requirements. Here are some of the commonly used email-sending options in SFMC, along with examples: Standard Send: Description: The Standard Send option allows you to send an email to a specified list or data extension. Example: Sending a promotional email to a segment of subscribers who meet specific criteria, such as customers who have made a purchase in the last 30 days. Triggered Send: Description: Triggered Sends are initiated by specific events or actions, such as a subscriber filling out a form on a website or making a purchase. Example: Sending a welcome email to a new subscriber immediately after they sign up on your website. User-Initiated Send: Description: User-Initiated Sends allow users to manually send an email to a specific recipient or a small group of recipients. Example: Sending a personalized email response to an...
Read more

Data Extension and List in SFMC

   Q1. What is Difference between Data Extension and List ?   Q2. Why Most the Marketers they go with Data Extension ?  --  List :  List is a storing data method in SFMC. Collection of subscribers that receive your communications. You can create as many lists as you want to segment your subscribers.    1. Your lists contain  500,000 subscribers or fewer. 2. You prefer simplicity over performance. 3. You don’t  require fast import speed. 4. You plan to use a  limited number of subscriber attributes. (First Name, Last Name, Email Address, Status.) Advantages: 1. A List can be configured to  send a welcome email when a new subscriber opts in. 2. Lists also give you the option to  enable double opt-ins for new subscribers to receive an email  containing a link to confirm their email address.   Disadvantages: 1. If we have data of  more than 500,000 then we can't use List. 2. If a  recipient u...
Read more