sfmc // SQLPRODUCTION

Latest Unique Click per Subscriber

Collapse click tracking to one latest engagement timestamp per subscriber.

sqlclickmaxengagement

Trust & provenancePRODUCTION

Evidence tierPRODUCTIONOfficial sources0Other sources0Last verified2026-10-05

Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.

EvidencePRODUCTION

Difficultyfoundation

Verified2026-10-05

Use when

Creating engagement flags or churn inputs.

SELECT
    SubscriberKey,
    MAX(EventDate) AS LastClickDate
FROM _Click
WHERE IsUnique = 1
GROUP BY SubscriberKey

Why it works

MAX returns the latest timestamp after the source has been constrained to unique click events.

Operational notes

For large audiences, add the smallest time window that still satisfies the business question.

Subscriber Engagement — 120 Day Flags

Create recent-open/recent-click flags and last engagement dates for an audience.

→

First Unique Open in a Window

Return the first unique open date per subscriber within a defined analysis window.

→

Latest Unique Click per Subscriber

Keep following the context.