Hot answers tagged

2 votes
Accepted

Is there a way to process SQL queries in Salesforce Marketing Cloud based on criteria in another unrelated table?

Here's a pattern that I use for referencing a "parameter" data extension. You can reference the results of the join in a case statement or in the where-clause, depending on the specifics of ...
Adam Spriggs's user avatar
  • 30.2k
1 vote
Accepted

SQL Query Issue to get last 12 Months data from a DE in SFMC

Your query is only getting the data for November 2022 because you are using the = operator to compare the month and year parts of the date. This means that you are only selecting the records that ...
Tushar Jadav's user avatar
  • 1,067
1 vote

Export view details from Journey Builder

In your current SQL, you are searching for subscribers in the journey that received an email. However, on the screenshot, you have Update Contact Activity, which is not anyhow related to the email ...
Niko's user avatar
  • 2,650

Only top scored, non community-wiki answers of a minimum length are eligible