To view tracking data on content shared from your email sends via Social Forward, query the _SocialNetworkTracking data view.
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 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 | Data Type | Data Extension Type | Nullable |
|---|---|---|---|---|
| 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) | ||
| 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 | |
| SocialSharingSiteID | The ID of the social network used to share the content region | int | Number | |
| SiteName | The name of the social network involved in the sharing of the content region | varchar | Text | |
| CountryCode | The country code for the social network involved in the sharing of the content region | varchar | Text | |
| PublishedSocialContentID | The ID number for the content area published via Social Forward | varchar | Text | |
| RegionTitle | The title of the region shared via Social Forward | varchar | Text | |
| RegionDescription | The description of the region shared via Social Forward | varchar | Text | X |
| RegionHTML | The HTML associated with the social forward region | varchar | Text | X |
| ContentRegionID | The ID of the shared content region | varchar | Text | X |
| OYBMemberID | The ID number for any On-Your-Behalf (OYB) account involved in the sharing of the content area | int | Number | X |
| TransactionTime | The time at which the content area was shared | datetime | Date | |
| IsUnique | Whether the event is unique or not | bit | Boolean | |
| Domain | The domain from which the content was shared | varchar | Text | |
| PublishedSocialContentStatusID | The status ID for the published social content | varchar | Text | |
| ShortCode | The short code for the published social content status, which is Active, Inactive, or Deleted | varchar | Text | |
| PublishTime | The time the social content area was published | datetime | Date |