Understanding IsUnique in _Click Data View: Demystifying Unique Clicks in Salesforce Marketing Cloud

In the context of the _Click data view in Salesforce Marketing Cloud, the "IsUnique" field indicates whether a click is unique for a specific job or send, rather than being unique to a particular link. Here are some scenarios to understand its behavior:

1. Subscriber Clicks: A subscriber can click multiple links within an email or even click the same link multiple times.
2. IsUnique Value: The IsUnique field in the _Click data view will be true (or 1) for the first click of the subscriber in that specific send or job.
3. Non-Unique Clicks: Any clicks on any link after the first click for that specific job will not be considered unique for that job.
4. Unique Click Example: If a link has already registered a click for a subscriber, clicking on the same link for the first time in any subsequent job will be considered unique for that particular job.
5. To find the number of clicks per link or URL, you can access the aggregates per link in the user interface (UI) of the Tracking section in Email Studio. Additionally, you can extract the same information using the tracking extract feature.

Understanding the IsUnique field helps differentiate unique clicks within a job, providing insights into subscriber interactions with specific links in your email campaigns.

Testing Scenario:

I have sent myself a test email and clicked the links as below:

1. Web-version - 2 times
2. Privacy policy - 1 time
3. Other links - not clicked

How is this populated in _Click Data View?

A record appears in _click data view for every click, but only one record is treated as a unique click. This is because all the other link clicks are duplicates for this send Job.

Number of clicks per link or URL

Access aggregates per link in UI, on the click tab of tracking in email studio. For the scenario above, the results will be as below:

The same can be extracted using the tracking extract as below.