Certified Marketing Cloud Developer

By Salesforce · Question Mode

QuestionQ3

VerifiedData Modeling and Management

A developer must identify every subscriber who was sent Job ID 420 but did not click any links.

Which SQL statement would return the required results?

Explanation

The _Sent data view records subscribers who received an email, and _Click records click events. A left join preserves the sent records, while testing c.SubscriberKey IS NULL selects only subscribers with no matching click record for Job ID 420.

Learn more

Community Discussion

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