Certified Marketing Cloud Developer

By Salesforce · Question Mode

QuestionQ120

VerifiedData Modeling and Management

A developer needs to populate a data extension with the date of each subscriber’s most recent click.

Which query accomplishes this?

Explanation

In the _Click data view, EventDate is the timestamp at which the click occurred. Grouping rows by SubscriberKey and using MAX(EventDate) returns the latest click date for each subscriber. IsUnique identifies unique versus repeated click events; it does not select the most recent click.

Learn more

Community Discussion

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