---
schema_version: "1"
id: 0e98309afcd10522e83786c754d76b8e5a9df302f14edf6934f78c3f47d9abdc
title: "Data View: Click"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_data_view_click.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_click.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: edbcac9dfbc16bb185f954b6b7069e8d52e6866e2a4e3673db2cbb2c8a72934b
description: 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.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png)

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.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:32.80757097791798%">
          <col style="width:32.80757097791798%">
          <col style="width:14.195583596214512%">
          <col style="width:10.094637223974763%">
          <col style="width:10.094637223974763%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28355e51">Name </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28355e54">Description </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28355e57">DataType </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28355e60">Data Extension Data Type </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d28355e63">Nullable </th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">AccountID </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">Your account ID number.</td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">int </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Number </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">OYBAccountID </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The account ID number for any related On-Your-Behalf (OYB)
              accounts. This field applies to enterprise accounts only. </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">int </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Number </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">X </td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">JobID </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The job ID number for the email send </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">bigint </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Number </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">ListID </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The list ID number for the list used in the send </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">int </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Number </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">BatchID </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The batch ID number for any batches used in the send </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">bigint </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Number </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">SubscriberID </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The subscriber ID for the affected subscriber. This number
              represents the unique ID for each subscriber record. </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">int </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Number </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">SubscriberKey </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The subscriber key for the affected subscriber </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">nvarchar(254) </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Text </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">EventDate </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The date the click took place </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">datetime </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Date </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">Domain </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The domain at which the click occurred </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">varchar(128) </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Text </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">URL </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The URL for the link clicked. No AMPscript or variables are
              populated in this column, for example, www.example.com?%%attribute%% </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">varchar(900) </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Text </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">X </td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">LinkName </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The link name assigned in the email send </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">varchar(1024) </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Text </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">X </td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">LinkContent </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The link content assigned in the email send. AMPscript and
              variables are populated in this column, such as
              www.example.com?12345 </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">varchar(max) </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Text </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">X </td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">IsUnique</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">
              <p>Whether the event is unique or repeated </p>
              <div class="slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium">
                <div class="slds-media slds-media_responsive">
                  <div class="slds-media__figure"><span class="slds-icon_container slds-icon_container_circle slds-icon-note-note"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png" alt="Note"></span></div>
                  <div class="slds-media__body" style="padding-top:.5rem;padding-bottom:.5rem;"><span class="slds-text-title_caps">Note</span> Clicks are
                    processed in asynchronous batches. The earliest click event
                    written to the database will have IsUnique set to
                    true.</div>
                </div>
              </div>
            </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">bit</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Boolean</td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">TriggererSendDefinitionObjectID</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The object ID for the triggered send definition </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">uniqueidentifier</td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Text </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">X </td>

          </tr>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e51 ">TriggeredSendCustomerKey </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e54 ">The customer key for the triggered send </td>

            <td data-label="DataType" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e57 ">varchar(36) </td>

            <td data-label="Data Extension Data Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e60 ">Text </td>

            <td data-label="Nullable" class="slds-cell-wrap" style="vertical-align:top;" headers="d28355e63 ">X </td>

          </tr>
        </tbody>
      </table>

#### See Also

- [_External Link:_ Add Subscribers to an On-Your-Behalf Account](https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/adding_subscribers_to_an_on_your_behalf_account.htm)