This article contains conceptual, procedural, and scenario information about overlaying your ExactTarget email campaign sends against your Webtrends web analytics data within the Webtrends Insight interface.

Prerequisites

Your ExactTarget account must have microsites with the landing pages functionality enabled. You must also have a Webtrends WTOD/Insight account.

What Is the ExactTarget RSS Feed for Webtrends Insight

The ExactTarget RSS Feed for Webtrends Insight exposes an RSS feed from an ExactTarget landing page for use with the information from your Webtrends account.

Why Use the ExactTarget RSS Feed for Webtrends Insight

The integration between Webtrends Insight and ExactTarget enables you to:

  • Consolidate your email marketing and analytics data into one reporting interface that visually represents marketing campaigns in the context of your overall site analytics.
  • Understand the impact your marketing programs are driving at a glance - right within Webtrends Insight - and helps you visually interpret campaign results.
  • Optimize your email campaigns by conversion and contribution to revenue and overall site success.

How to Setup the ExactTarget RSS Feed for Webtrends Insight

Follow the instructions below to create and implement the RSS feed and integration. You will enter information both in the ExactTarget application and in Webtrends.

ExactTarget Application

Follow these steps to create the RSS feed for use in Webtrends Insight:

  1. Log in to your ExactTarget account.
  2. Click the Content tab and select My Microsites.
  3. Create a new microsite or select an existing microsite in which to create the landing page. This is done in the Content tab in the My Microsites section.
  4. Create the landing page within the appropriate microsite using the Create button shown below.
  5. Fill out the necessary information to create the page.
  6. Set the Content Type dropdown menu to RSS.
  7. Copy the feed code sample below into the landing page content editor. You can alter the code to fit your needs, such as changing the time frame of sends you wish to view in Insight or changing the RSS feed metadata values like name and description.
    <?xml version="1.0" encoding="utf-8"?>
        <rss version="2.0">
            <channel>
                <title>ExactTarget Email Campaign Feed</title>
                <link>http://www.exacttarget.com</link>
                <description>This feed provides the last sixth months of e-mail campaign metrics to be overlaid within Webtrends Insight.</description>
                <language>en-us</language>
                <copyright>Copyright (C) 2011 ExactTarget</copyright>
                <script language="javascript"  runat="server">
                    // load the ExactTarget core SSJS library
                    Platform.Load("Core", "1");
    
                    // set retrieve to the last 180 days, you can adjust to different value if you wish
                    var today = new Date();
                    var interval = -180;
                    var sixMonths = new Date(today.getFullYear(), today.getMonth(), today.getDate()-0+interval);
                    var filter = { Property:"ScheduledTime", SimpleOperator:"greaterthanorequal", Value:sixMonths};
                    
                    // retrieve the tracking data for each send and create friendly day/month values for display
                    var sendTracking = Send.Tracking.Retrieve(filter);
                    var weekday=new Array("Sun","Mon","Tue","Wed","Thu","Fri","Sat");
                    var monthname=new Array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
    
                    // loop through the tracking data for each send and create the rss feed items
                    for (var x = 0; x < sendTracking.length; x++){
                        var sent = sendTracking[x].Sends.Total;
                        if (sent != 0) {
                            var d1= sendTracking[x].ScheduledTime;
                            var a1 = sendTracking[x].ScheduledTime;
                            var pubDate=Date.parse(a1);
                            var d = new Date(pubDate);
                            var formattedDate = weekday[d.getDay()] + ', ' + d.getDate() + ' ' + monthname[d.getMonth()] + ' ' + d.getFullYear() + ' 00:00:01 GMT';
                            var openrate = ((sendTracking[x].Opens.Unique / sent)*100).toFixed(1);                        
                            var ctr = ((sendTracking[x].Clicks.Unique / sent)*100).toFixed(1);
                            var emailName = sendTracking[x].EmailName.replace(/^\s+|\s+$/g,"");
                            var emailSubject = sendTracking[x].EmailSubject.replace(/^\s+|\s+$/g,"");
    
                            // write out the rss feed xml for each send
                            Write("<item>");
                            Write("<title>" + emailName + " - Total Sent: " + sent + " - Open Rate: " + openrate + "% - CTR: " + ctr + "%</title>");
                            Write("<link>https://members.exacttarget.com/Content/Tracking2/ListSends/Pages/Overview.aspx?jobid=" + sendTracking[x].SendID + "</link>");
                            Write("<pubDate>" + formattedDate + "</pubDate>");
                            Write("<description><![CDATA[Subject Line: " + emailSubject + "<br/>From Name: " + sendTracking[x].FromName + "]]></description>");
                            Write("</item>");
                            }
                        }
                    </script>
            </channel>
        </rss>
  8. Click Save to save the landing page.
  9. Publish the new page to make it active for use.
  10. Copy the URL of the landing page listed in the URL heading of the ExactTarget user interface.

Webtrends

  1. Log in to your Webtrends WTOD/Insight account: http://insight.webtrends.com
  2. Navigate to the appropriate Webtrends profile. The default view of the profile contains the key metrics trend graph where you will overlay the ExactTarget campaign RSS feed.
  3. Click Feeds in the navigation menu and add an RSS feed.
  4. Give the feed a name and copy the ExactTarget landing page URL into the location field, as shown below. You do not have to enter a username and password.
    /Global/Documentation/6766/create_rss_feed.png
  5. Select the feed and wait for it to load (load time depends of amount of data being returned). Review the visual display of your email sends overlayed against your key web metrics data such as page views or time-on-site. Use this information to evaluate the effectiveness of your email campaign.
    /Global/Documentation/6766/wt_insight.png Click to Enlarge

 

Was This Page Helpful?
Last updated by lthomas at 13:07, 9 Jan 2013