(Click the banner to go to the related Docs.Code.ExactTarget.com page.)
This document contains conceptual and procedural information for obtaining tracking information from Social Forward activities using tracking queries.
Prerequisites
You must have programs, data extensions, and query activities enabled for your ExactTarget account. Contact your ExactTarget representative for more information about turning these features on in your account.
Why Use Tracking Queries for Social Forward
These queries allow you to obtain tracking information, such as content impressions and shared content slots, regarding the information you shared through the Social Forward function.
How to Use Sample Tracking Queries for Social Forward
Use the sample tracking queries below in your query activities to obtain the specified information. The information can be viewed in the resulting data extension.
Sample Tracking Query: Count All Shared Content Impressions
Create a query activity with the following string:
- SELECT s.JobID, s.SocialSharingSiteID, s.SiteName, COUNT(s.JobID) AS TotalImpressions FROM _SocialNetworkImpressions s GROUP BY s.JobID, s.SocialSharingSiteID, s.SiteName
The results will look similar to the figure shown below, depending on your data:
Sample Tracking Query: Get All Shared Content Impressions
Create a query activity with the following string:
- SELECT s.JobID, s.SocialSharingSiteID, s.SiteName, s.TransactionTime AS EventDate FROM _SocialNetworkImpressions s
The results will look similar to the figure shown below, depending on your data:
Sample Tracking Query: Get All Shared Content Slots
Create a query activity with this string:
- SELECT s.JobID, s.SubscriberID, s.SocialSharingSiteID, s.SiteName FROM _SocialNetworkTracking s
The results will look similar to the figure shown below, depending on your data:
This page was last updated by Adam Evans on Tue, 10 Jan 2012 13:25:01 GMT.
If you require assistance with the ExactTarget application, please contact Global Support. If you wish to send Adam direct feedback, fill out the form below:
