Certified Marketing Cloud Developer

By Salesforce · Question Mode

QuestionQ110

VerifiedData Modeling and Management

Northern Trail Outfitters prefixes the name of every test email with the word TEST.

Which query returns the subscribers to whom those emails were sent?

Explanation

The _Job data view supplies the email job’s EmailName, while _Sent supplies records of subscribers sent an email and includes its JobID. Joining _Job and _Sent on J.JobID = S.JobID, then filtering with J.EmailName LIKE 'TEST%', returns send records for email names that begin with TEST.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!