---
schema_version: "1"
id: 4d09d49563cc54bc63fab0da7d3bf007505d0f3a4e9159605d19b5a2c39b974a
title: "Data View: Open"
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_open.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_open.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 434a3a1d4b218dfc4a4e75649b5e39501bb97923c27d400957f6da7b1f2daff0
description: To view email opens for your account, query the _Open data view in Automation Studio. Open data is retained for six months.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Data View: Open

To view email opens for your account, query the \_Open data view in Automation Studio. Open 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.

## Columns

    
| 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 accounts. This field applies to enterprise accounts only. | int | Number | X |
| JobID | The job ID number for the email send | int | 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 | int | 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 open took place | datetime | Date |   |
| Domain | The domain at which the open occurred | varchar(128) | Text |   |
| IsUnique | Whether the event is unique or repeated | bool | Boolean | X |
| TriggererSendDefinitionObjectID | The object ID for the triggered send definition | varchar(36) | Text | X |
| TriggeredSendCustomerKey | The customer key for the triggered send | varchar(36) | Text | X |