21 docs tagged with "SQL"

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

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

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

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 Marketing Cloud Engagement Send Log for debugging and reporting.

Dive deep into SMS System Data Views - the backend Marketing Cloud Engagement (MCE) 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 Engagement WHERE drag-and-drop Filters are not enough.

Empower your Marketing Cloud Engagement 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.

Clean up your MCE Contacts before they clean up your wallet. Step-by-step guide to identifying subscriber issues.

Make finding problems with email delivery in Salesforce Marketing Cloud Engagement (MCE) 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 Marketing Cloud Engagement SQL queries.

IS NULL, or IS NOT NULL, that is the question. Ways of working with NULL values in Marketing Cloud Engagement (MCE) SQL.

Selected information on the SELECT statement in Marketing Cloud Engagement SQL.

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

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