---
schema_version: "1"
id: ce3f0d7ca401e33c55debe5ee8b23672ccc31f982a34ce63b888682a2142a976
title: "Data View: Subscribers"
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_subscribers.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_subscribers.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 769f496994955a0fd790a1ab7287ac63ed54e9827481da4c813ba8c89c9ef134
description: To view email subscribers and their statuses, query the _Subscribers data view in Automation Studio. Subscriber attributes aren’t available. This data view only returns results at the Enterprise level, and not for child business units.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Data View: Subscribers

To view email subscribers and their statuses, query the \_Subscribers data view in Automation Studio. Subscriber attributes aren’t available. This data view only returns results at the Enterprise level, and not for child business units.

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.

## Columns

The SubscriberID, EmailAddress, and SubscriberKey columns are indexed.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:31.515151515151512%">
          <col style="width:31.515151515151512%">
          <col style="width:13.636363636363635%">
          <col style="width:13.636363636363635%">
          <col style="width:9.696969696969697%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d10196e60"> Name </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d10196e63"> Description </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d10196e66"> DataType </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d10196e69"> Data Extension Data Type </th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d10196e72"> Nullable </th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Name" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e60 ">SubscriberID </td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">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="d10196e66 "> bigint </td>

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">The date an email for the subscriber was returned as
              undeliverable </td>

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

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">The date the subscriber joined your list </td>

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

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">The date the subscriber unsubscribed from your list </td>

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

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">The domain of the subscriber </td>

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

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">The subscriber's email address </td>

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

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">The total number of bounces accrued by the subscriber </td>

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

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">A potential alternate identifier for subscribers. Defaults to the
              value of Email Address. </td>

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

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">
              <p>The subscriber type for the affected subscriber </p>
              <ul>
                <li>ExactTarget (Marketing Cloud Engagement)</li>
                <li>Salesforce Lead</li>
                <li>Salesforce Contact</li>
                <li>Unknown External System (Triggered Send Hidden Manage List)</li>
                <li>MS CRM Contact</li>
                <li>MS CRM Lead</li>
                <li>MS CRM Account</li>
              </ul>
            </td>

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

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

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

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

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10196e63 ">The status of the subscriber: active, held, unsubscribed, or
              bounced. </td>

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

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

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

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