Certified Marketing Cloud Developer

By Salesforce · Question Mode

QuestionQ73

VerifiedScripting and Automation

A developer is writing a query to select distinct subscribers who opened any emails sent since the start of the previous day.

Which query would return that result?

Explanation

_Open supplies the subscribers associated with open events, and joining it to _Job by JobID allows the query to filter on the job’s PickupTime, which represents the relevant email-send timing. Applying DISTINCT to SubscriberKey returns each qualifying subscriber only once.

Community Discussion

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