_SocialNetworkImpressions
Social Forward impression events from email content regions. Six-month retention.
Schema last reviewed 2026-06-17
Opens _SocialNetworkImpressions in the interactive canvas with SQL Sandbox.
Social Forward impression events from email content regions. Six-month retention.
Schema last reviewed 2026-06-17
Opens _SocialNetworkImpressions in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
JobID |
Number | PK, FK | _Job.JobID _Sent.JobID |
Email send job ID. |
ListID |
Number | PK, FK | _ListSubscribers.ListID | List ID used in the send. |
RegionTitle |
Text | — | — | Social Forward region title. |
RegionDescription |
Text | NULL | — | Region description. |
RegionHTML |
Text | — | — | Region HTML content. |
ContentRegionID |
Number | — | — | Shared content region ID. |
SocialSharingSiteID |
Number | — | — | Social network ID. |
SiteName |
Text | — | — | Social network name. |
CountryCode |
Text(10) | — | — | Social network country code. |
ReferringURL |
Text | NULL | — | Referring URL for the share. |
IPAddress |
Text(50) | NULL | — | IP address of the share. |
TransactionTime |
Date | — | — | Time the region was shared. |
PublishedSocialContentStatusID |
Text | — | — | Published content status ID. |
ShortCode |
Text | — | — | Published content short code. |
PublishTime |
Date | — | — | Time the social content was published. |
SELECT TOP 100
JobID, ListID, RegionTitle, RegionDescription, RegionHTML, ContentRegionID
FROM _SocialNetworkImpressionsValid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.