To view impression data on content shared from your email sends via Social Forward, query the _SocialNetworkImpressions data view in Automation Studio.
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 |
|---|---|---|---|---|
| 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 | |
| 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 | |
| ContentRegionID | The ID of the shared content region | int | Number | |
| SocialSharingSiteID | The ID of the social network involved in the sharing of 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 | |
| ReferringURL | The referring URL used in the Social Forward activity | varchar | Text | X |
| IPAddress | The IP address for the URL from which the content region was shared. | varchar(50) | Text | X |
| TransactionTime | The time at which the content area was shared | datetime | Date | |
| 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 |