Grab-and-go resources 🗂

%%[ SET @fn = IIF(Empty(AttributeValue("FirstName")), "there", AttributeValue("FirstName")) ]%%
Hi %%=v(@fn)=%%,

%%[ SET @country = AttributeValue("Country") ]%%
%%[ IF @country == "UK" THEN ]%%
  <p>Call us: 0800 123 456</p>
%%[ ELSEIF @country == "US" THEN ]%%
  <p>Call us: 1-800-123-456</p>
%%[ ELSE ]%%
  <p>Visit our website for your local number.</p>
%%[ ENDIF ]%%

%%[
  SET @rawDate  = AttributeValue("ExpiryDate")
  SET @niceDate = FormatDate(@rawDate, "d MMMM yyyy")
]%%
Offer expires: %%=v(@niceDate)=%%

%%[
  SET @sk   = AttributeValue("SubscriberKey")
  SET @tier = Lookup("LoyaltyDE", "Tier", "SubscriberKey", @sk)
  IF Empty(@tier) THEN
    SET @tier = "Standard"
  ENDIF
]%%
Your tier: %%=v(@tier)=%%

SELECT DISTINCT s.SubscriberKey, s.EmailAddress, s.FirstName
FROM [Master_Subscribers] s
INNER JOIN [_Open] o ON s.SubscriberKey = o.SubscriberKey
  AND o.EventDate >= DATEADD(day, -90, GETDATE())
WHERE s.OptInStatus = 'Subscribed'

SELECT SubscriberKey, EmailAddress, FirstName, JoinDate
FROM [Master_Subscribers]
WHERE JoinDate >= DATEADD(hour, -24, GETDATE())
  AND OptInStatus = 'Subscribed'

SELECT s.SubscriberKey, s.EmailAddress
FROM [Master_Subscribers] s
WHERE s.OptInStatus = 'Subscribed'
  AND s.SubscriberKey NOT IN (
    SELECT DISTINCT SubscriberKey FROM [_Open]  WHERE EventDate >= DATEADD(day,-180,GETDATE())
    UNION
    SELECT DISTINCT SubscriberKey FROM [_Click] WHERE EventDate >= DATEADD(day,-180,GETDATE())
  )

SELECT SubscriberKey, EmailAddress, FirstName, DateOfBirth
FROM [Master_Subscribers]
WHERE
  DATEPART(month, DateOfBirth) = DATEPART(month, DATEADD(day,1,GETDATE()))
  AND DATEPART(day,   DateOfBirth) = DATEPART(day,   DATEADD(day,1,GETDATE()))
  AND OptInStatus = 'Subscribed'