A few tips on grouping, counting or simply showing unique values.

EXISTS is used to return a boolean value, JOIN returns a whole other table. EXISTS is only used to test if a subquery returns results, and short circuits as soon as it does. JOIN is used to extend a result set by combining it with additional fields from another table to which there is a relation.

A short recipe for a good-looking bullet list for emails.

This is an AMPScript snippet I submitted for the Baby Shark AMPScript Challenge organized by the How-to-SFMC Community. The total number of characters ended up at 361 (no spaces).

You have the two tables Table1 and Table2, both with a Column. To get the records from the Table1 that are not present in the Table2 (difference between T1-T2) use the following:

These are notes from a Salesforce webinar - SFMC Lookup Answers - dedicated to Server Side JavaScript. SSJS is an old version of JS and it works synchronously. API calls have asynchronous options.

CloudPages are public by defualt with no out-of-the-box solution to limit access for logged in users. The default randomized URLs provide some security through obscurity only.

These are notes from a Salesforce webinar - SFMC Lookup Answers - dedicated to AMPScript.

Content of a CloudPage is stored on an Akamai CDN thus refreshing a page (cache) may take up to 5 minutes. This little hack saves hundreds of minutes and pulled hairs every month spent on debugging AMPScript or SSJS.
%%=TreatAsContent(HTTPGet(“URL”))=%%

A simple use case for using measures.

These articles from Litmus explain how to fix auto-linking by Gmail and Apple Mail and iOS devices. Auto-linking results in a default style for all links in email that is blue color and underline.

Marketing Cloud przechowuje dane o kontakcie w postaci profilu i atrybutów. Do atrybutów należą głównie dane demograficzne jak imię, nazwisko, adres. Dane behawioralne dostępne są w innych widokach dla kampanii emailowych.