20 docs tagged with "SQL"

Marketing Automation is as powerful as the database quality behind it. To make it good you must first remove the bad. Let's do it.

Create, customise and enhance SFMC Send Log for debugging and reporting.

Dive deep into SMS System Data Views - the backend Marketing Cloud data. Actionable pearls await.

Group rows and apply aggregate functions to see the big picture in your data extensions.

SELECT your data FROM Salesforce Marketing Cloud WHERE drag-and-drop Filters are not enough.

Empower your Marketing Cloud queries with conditional SQL CASE logic.

Break from the limits of Data Extension data types. Use full power of SQL to control your values.

Take control over dates with built-in SQL functions. Let the query do the job.

Make finding problems with email delivery in Salesforce Marketing Cloud great again. SQL with Query Studio to the rescue.

Your Automations crash due to longer than expected values coming from the external source? Make your life easier with SQL.

Tell the SQL query FROM where you need the data.

Data Extensions. System Data Views. With the JOIN statement, use one query to rule them all.

Get a LIKE and build more flexible SQL queries.

IS NULL, or IS NOT NULL, that is the question. Ways of working with NULL values in SFMC SQL.

Take control over numbers with built-in SQL functions. Let the query do the job.

Selected information on the SELECT statement in SFMC SQL.

Take control over strings with built-in SQL functions. Let the query do the job.

Query with style. Readable, bug-free code is a few shifts & spaces away.

Use WHERE to make your query lean and to the point. Less is more.

Dive deep into System Data Views - the backend Marketing Cloud data. Actionable pearls await.