Loading
Journeys and Automations in Marketing Cloud Engagement
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Data View: Click

            You are here:

            1. Salesforce Help
            2. Docs
            3. Engagement: Journey Builder and Automation Studio

            Data View: Click

            To view click data for emails sent from your account, query the _Click data view in Automation Studio. Click data is retained for six months.

            Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.

            Note
            Note When profile attributes are created in Enterprise 2.0 accounts, new columns are added to the _EnterpriseAttribute table. Data view queries in Enterprise 2.0 accounts can return results from profile attribute columns in addition to the columns listed here.
            Name Description DataType Data Extension Data Type Nullable
            AccountID Your account ID number. int Number  
            OYBAccountID The account ID number for any related On-Your-Behalf (OYB) accounts. This field applies to enterprise accounts only. int Number X
            JobID The job ID number for the email send bigint Number  
            ListID The list ID number for the list used in the send int Number  
            BatchID The batch ID number for any batches used in the send bigint Number  
            SubscriberID The subscriber ID for the affected subscriber. This number represents the unique ID for each subscriber record. int Number  
            SubscriberKey The subscriber key for the affected subscriber nvarchar(254) Text  
            EventDate The date the click took place datetime Date  
            Domain The domain at which the click occurred varchar(128) Text  
            URL The URL for the link clicked. No AMPscript or variables are populated in this column, for example, www.example.com?%%attribute%% varchar(900) Text X
            LinkName The link name assigned in the email send varchar(1024) Text X
            LinkContent The link content assigned in the email send. AMPscript and variables are populated in this column, such as www.example.com?12345 varchar(max) Text X
            IsUnique

            Whether the event is unique or repeated

            Note
            Note Clicks are processed in asynchronous batches. The earliest click event written to the database will have IsUnique set to true.
            		 bit Boolean  
            TriggererSendDefinitionObjectID The object ID for the triggered send definition uniqueidentifier Text X
            TriggeredSendCustomerKey The customer key for the triggered send varchar(36) Text X

            See Also

             
            Loading
            Salesforce Help | Article