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 ...
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql × 943marketing-cloud × 879
automationstudio × 264
query × 237
dataextensions × 186
data-views × 63
journeybuilder × 50
automation × 39
sqlserver × 30
ampscript × 26
data × 26
soql × 22
ssjs × 21
email × 14
date × 13
database × 13
marketing-cloud-connect × 12
subscriber × 12
sfmc-business-unit × 12
sql-studio × 11
apex × 10
datetime × 9
activity × 7
reporting × 6
cloudpage × 6