Salesforce Marketing Cloud Data Views: _Click

The _Click data view in Salesforce Marketing Cloud (SFMC) tracks when subscribers click on links within your emails. This essential data view provides detailed insights into subscriber engagement by recording which links were clicked, how often, and by whom.

In this blog, we’ll explore the structure of the _Click data view, explain each field, provide use cases, and walk through example SQL queries to help you extract meaningful insights from your campaigns.

---

What is the _Click Data View?

The _Click data view captures all click activity related to links in emails. It retains records for up to six months and allows you to analyze engagement down to individual links and users.

Key Benefits of _Click Data View

• Track Link Engagement: Know which links are performing best.
• Understand Subscriber Interests: Segment users based on their click behavior.
• Optimize Content: Use link-level reporting to improve future emails.
• Campaign Attribution: Connect clicks to job IDs, subscriber IDs, and triggered sends.

---

Fields in _Click Data View & Their Uses

Field	Type	Description & Use Case
AccountID	Number	ID of the Marketing Cloud account where the email originated. Useful for enterprise tracking.
OYBAccountID	Number	ID of the parent account (in enterprise structures).
JobID	Number	Unique ID for the email send job. Used for campaign-specific click tracking.
ListID	Number	ID of the list used in the send. Helps analyze click behavior by audience list.
BatchID	Number	Batch ID for the send. Useful for analyzing large campaigns.
SubscriberID	Number	System-generated ID of the subscriber. Internal identifier.
SubscriberKey	Text(254)	External ID for the subscriber. Often the email address or custom ID.
EventDate	Date	The timestamp when the click occurred. Enables engagement timeline analysis.
Domain	Text(128)	The domain of the clicked link (e.g., www.example.com). Useful for link categorization.
URL	Text(900)	The raw URL clicked (with no personalization or AMPscript rendering).
LinkName	Text(1024)	The friendly name given to the link in Email Studio. Useful for identifying calls-to-action.
LinkContent	Text(max)	The rendered version of the link (with AMPscript/variables populated). Helpful for understanding final click destinations.
IsUnique	Boolean	Indicates whether the click was the subscriber’s first for that link in that send. Essential for unique click rate analysis.
TriggererSendDefinitionObjectID	Text(36)	ID of the triggered send definition. Tracks clicks from automated journeys.
TriggeredSendCustomerKey	Text(36)	Customer key for the triggered send. Important for automation-specific analysis.

---

When and Why to Use _Click Data View?

When to Use?

• To analyze which links perform best in a campaign.
• To segment subscribers based on what they clicked.
• When measuring engagement in triggered journeys.
• To track click behavior over time and compare across sends.

Why Use It?

• Understand Subscriber Intent: Clicks indicate interest.
• Drive Better Campaign Design: Know which CTAs are effective.
• Improve Personalization: Target content based on click patterns.
• Measure ROI: Attribute clicks to revenue-driving activities.

---

10 Example Scenarios and Queries

1. Retrieve All Clicks in the Past 7 Days

SELECT SubscriberKey, EventDate, URL, LinkName 
FROM _Click 
WHERE EventDate >= DATEADD(day, -7, GETDATE())

Use Case: Weekly click engagement reporting.

2. Identify Most Clicked Links

SELECT LinkName, COUNT(*) AS ClickCount 
FROM _Click 
GROUP BY LinkName 
ORDER BY ClickCount DESC

Use Case: Determine which CTAs are most effective.

3. Find Subscribers Who Clicked More Than Once

SELECT SubscriberKey, COUNT(*) AS TotalClicks 
FROM _Click 
GROUP BY SubscriberKey 
HAVING COUNT(*) > 1

Use Case: Identify highly engaged subscribers.

4. Click Activity by Domain

SELECT Domain, COUNT(*) AS Clicks 
FROM _Click 
GROUP BY Domain

Use Case: Understand performance by email client/ISP.

5. Clicks for a Specific Campaign (JobID)

SELECT SubscriberKey, URL, EventDate 
FROM _Click 
WHERE JobID = 123456

Use Case: Analyze clicks for a specific campaign.

6. Unique Clicks Report

SELECT SubscriberKey, URL, IsUnique 
FROM _Click 
WHERE IsUnique = 1

Use Case: Track unique engagement.

7. Clicks from a Triggered Send Journey

SELECT SubscriberKey, TriggeredSendCustomerKey, URL 
FROM _Click 
WHERE TriggeredSendCustomerKey = 'PostPurchaseJourney'

Use Case: Measure clicks from automated emails.

8. Match Clicks with Email Content (Using LinkContent)

SELECT SubscriberKey, LinkContent, EventDate 
FROM _Click

Use Case: See the final rendered URL that was clicked.

9. High Click Activity in Last 30 Days

SELECT SubscriberKey, COUNT(*) AS Clicks 
FROM _Click 
WHERE EventDate >= DATEADD(day, -30, GETDATE()) 
GROUP BY SubscriberKey 
ORDER BY Clicks DESC

Use Case: Identify top clickers for re-targeting.

10. Click Rate Over Time

SELECT CAST(EventDate AS DATE) AS ClickDate, COUNT(*) AS ClickCount 
FROM _Click 
GROUP BY CAST(EventDate AS DATE)

Use Case: Track engagement trends over time.

---

Conclusion

The _Click data view in SFMC offers deep insight into subscriber behavior and content performance. With link-level tracking and field-rich data, it’s a core element of any performance reporting or journey optimization strategy.

Use _Click in combination with _Sent, _Open, and _Bounce to build a complete email performance funnel.