ExactTarget for Coremetrics LIVEmail3

Audience

This document is intended for ExactTarget users who are considering integrating or who are preparing to integrate their ExactTarget tracking data with their Coremetrics LIVEmail3 analytics package.

Prerequisites

To utilize the Coremetrics data transformation, you must use the Vertical Solutions for Retail configuration of Coremetrics LIVEmail3. Future releases will enable additional vertical solutions.

Integrating ExactTarget with Coremetrics LIVEMail3

Integrating ExactTarget with Coremetrics LIVEmail3 is the process of setting up Coremetrics LIVEmail3 and ExactTarget to expect data from each other and provide the expected data. This integration combines metrics from Coremetrics regarding customer clicks and abandoned cart items with ExactTarget information on sends, clicks, bounces, and more information.

Setting up your account to integrate ExactTarget with Coremetrics LIVEmail3 requires the following steps:

1. Tagging email links
2. Creating data extract activities
3. Creating file transfer locations and file transfer activities
4. Creating a data extension to hold your remarketing data
5. Creating an import activity
6. Creating a program to automate and schedule the activities

What Information Does The LIVEmail3 Integration Provide

The LIVEmail3 integration imports web analytics data into your account, transforming it along the way into a series of rows that can be used to plan more specifically targeted email sends. This transformation takes data from Coremetrics and provides it to ExactTarget as a segmented, normalized text file. This file can then be imported into a data extension and used in queries to help produce targeted email campaigns.

For example, the data of an abandoned shopping cart from your website may be recorded in the following manner:

As the ExactTarget application imports the data from Coremetrics, it transforms entries like this into separate rows based on whether delimited data is present in one or more of the columns:

Returning Email Send Information to Coremetrics

LIVEmail3 can also return data from an email send to Coremetrics for use in the web analytics process. The data returned includes the following columns:

• Date - The date of the email send
• JobID - The unique ID number for the email send
• JobName - The name of the email send
• MessageType - The type of message used in the send, such as "email"
• ListID - The unique ID number of the subscriber list used in the email send
• ListName - The name of the subscriber list used in the email send
• Sent - The number of emails sent as part of the email send
• Delivered - The number of emails delivered to user accounts as part of the email send
• Opens - The number of emails opened as part of the email send
• Clicks - The number of links clicked as part of the email send
• Soft Bounces - The number of soft bounces sent as part of the email send
• Hard Bounces - The number of bounces received from a blocked account as part of an email send
• Total Bounces - The number of total bounces sent as part of the email send
• Unsubscribed - The number of subscribers who unsubscribed as part of the email send
• Subscribed - The number of recipients to subscribed to a mailing list as part of the email send
• Forwarded - The number of times a message was forwarded as part of the email send
• Suppressed - The number of subscribers excluded from an email send
• Complaints - The number of complaints received as part of an email send

To move data from the ExactTarget application to your Coremetrics instance, create a data extract and import that data into Coremetrics.

?CM_MMC=Vendor-_-Categories-_-lm_%%JobID%%-_-Linkname Detail

http://example.com/limitedtimeoffer.htm?CM_MMC=ExactTarget-_-Marketing-_-lm_%%JobID%%-_-limitedoffer1

How to Enable the Coremetrics LIVEmail3 Integration

Before the data from Coremetrics LIVEmail3 can be used in the ExactTarget application, this data must be deployed to your ExactTarget account. Follow these steps to enable the integration between your Coremetrics instance and your ExactTarget account.

1. Log in to your Coremetrics account and navigate to the LIVEmail3 screen.
2. Create the integration by dragging the the ExactTarget icon to the integrations slot at the bottom of your screen.
3. Enter the Export Name for your export.
4. Choose the FTP location in the FTP Destination dropdown menu. Click the Add New Location link if you want to add a new FTP location.
5. Choose the fields you want to include in your export.
6. Click Save & Publish to export the data to your internal FTP site. The ExactTarget application takes the data from this FTP site and imports it into your account.

How to Configure an Coremetrics LIVEmail3 FTP Site in your ExactTarget Account

If an Coremetrics LIVEmail3 FTP site is not already configured for your account, contact your account manager or technical support. You should have your account information ready to assist with this call.

How to Create a Data Extract Activity for Coremetrics LIVEmail3

Data extract functionality must be enabled in your account before you can perform this procedure. If you do not see Data Extract in step 3, contact technical support or your account manager. After you complete this procedure, you can include the activity in a program. This extract should be created and sent to Coremetrics every day.

Use the following steps to create a data extract activity:

1. Click the Interactions tab on the navigation bar.
2. Click Activities.
3. Click Data Extract.

The Data Extract workspace appears.

4. Click Create from the toolbar.
5. Complete the information in the Properties section:

6.  Complete the information in the Fields section:

7. Click Save. The transformed file retains the same name as the original file except for the suffix -t. For example, extract.csv becomes extract-t.csv.

How to Create a File Transfer Activity for Coremetrics LIVEmail3

You perform this procedure five times to create five file transfer activities: three to download files from Coremetrics LIVEmail3 and two to upload files to Coremetrics LIVEmail3.

Before you begin this procedure, ExactTarget must create file transfer locations to your directories in Coremetrics LIVEmail3. After you complete this procedure, you can include the activities in a program.

Use the following steps to create a file transfer activity:

1. Click the Interactions tab on the navigation bar.
2. Click Activities.
3. Click File Transfer.

The File Transfer workspace appears.

4. Click Create from the toolbar.
5. Select the Transfer Type. Click Downloads to download files and click Upload to upload files.
6. Complete the information in the Transfer Settings section:

7. Click Save.

How to Create a Data Extension for Coremetrics LIVEmail3

Use the following steps to create a data extension. After you complete this procedure, you can import Coremetrics LIVEmail3 data to the data extension.

1. Click the Subscribers tab from the navigation bar.
2. Click Data Extensions.
3. Click My Data Extensions.
4. Click the Create button.

The New Data Extension screen appears.

5. Complete the information in the Properties section:

6. Complete the information in the Type section.

7. Complete the information in the Fields section for each field. Click Add to create each new field in the data extension. Use the following information to create those fields:

Leave the Primary Key checkboxes clear for all fields in this data extension and check the Nullable checkboxes for all fields.

8. Click Save.

How to Create an Import Activity for Coremetrics LIVEmail3

You use this procedure to create three import activities, one for each file you retrieved from Coremetrics LIVEmail3 and uncompressed. This procedure will import the data into the data extensions you created. After you complete this procedure, you include the import activities in a program.

1. Click the Interactions tab on the navigation bar.
2. Click Activities.
3. Click Import. The Import workspace appears.
4. Click Create from the toolbar.
5. Complete the information in the Properties section:

6. Complete the information in the Source section:

7.  Complete the information in the Import Action Settings section:

8. Complete the information in the Import Completion Settings section:

9. Click Save.

How to Create a Program for Coremetrics LIVEmail3

You can create just one program for your integration to extract and transfer both the metrics and campaign files. You must create the data extract and file transfer activities to include in the program before you perform this procedure. After you complete this procedure, you can schedule the program.
Use the following steps to create a program:

The Program Process screen appears.

1. Click the Interactions tab from the navigation bar.
2. Click Programs.
3. Click My Programs.
4. Click the Create button from the toolbar.
5. Complete the information in the Properties section:
6.  Complete the information in the Notifications section:
7. Click Edit Process.
8. Click Add task. The Interactions window appears.
9. Select the data extract activity.
10. Click Add task.
11. Select the file transfer activity.
12. Click Save.

If you want to schedule the program, click Edit Schedule. See step 6 of the procedure How to Schedule a Program.

How to Schedule a Program

You must create the program before you perform this procedure. After you complete this procedure, you can start the program. The program will not execute according to the schedule until you start the program.

Use the following steps to schedule a program:

1. Click the Interactions tab on the navigation bar.
2. Click Programs.
3. Click My Programs.
4. Select the checkbox next to the program to schedule.
5. Click the Schedule button.
6. Complete the fields:

7. Click Save.

How to Start a Program

You must create and schedule the program before you perform this procedure. After you complete this procedure, you can stop the program to prevent the steps that have not already started from occurring. Use the following steps to start a program:

1. Click the Interactions tab on the navigation bar.
2. Click Programs.
3. Click My Programs.
4. Select the checkbox next to the program to start.
5. Click the Start button.
6. Select Start using the recurring schedule as the start option.
7. Click the Start button.

How to Update Coremetrics LIVEMail3 with Missing ExactTarget Tracking Data

In the event the automated Program responsible for delivery of Tracking Data to Coremetrics is interrupted or fails to complete, you can supply the missing tracking data to Coremetrics on a later date. The process leverages a similar methodology to the existing Data Extract Activity for the Coremetrics integration.

The Coremetrics import process requires data to be delivered in 1-day increments. Therefore, you must generate a separate file for each day where historic tracking data is absent. Follow the instructions below to update this information.

1. Click the Interactions tab on the navigation bar.
2. Under the Activities heading, select Data Extract.
3. Click Create.
4. Enter Manual Coremetrics Tracking Data Extract in the Name field.
5. Enter your external key in the External Key field (optional).
6. Enter your description in the Description field (optional).
7. Enter the identical file naming pattern as the one found in your existing Coremetrics data extract activity in the File Naming Pattern field.
8. Select Coremetrics LiveMail 2 in the Extract Type drop-down menu.
9. Select a specific range of one day (such as 8/15/2011 to 8/16/2011 (12AM to 12AM)) in the Specific Range field.
10. Replace the year, month, and day wildcards in the file naming pattern with the date of the end date from step 6.
11. Click Save.
12. Click File Transfer.
13. Click Create.
14. Select the Upload radio button.
15. Enter Manual Coremetrics Tracking File Transfer in the Name field.
16. Enter your external key in the External Key field (optional).
17. Enter your description in the Description field (optional).
18. Select your Coremetrics FTP file location in the File Location drop-down menu.
19. Use the same file naming pattern as specified in step 7 in the File Naming Pattern field.
20. Click Save.
21. Click My Programs.
22. Click Create.
23. Enter Manual Coremetrics Tracking Program in the Name field.
24. Enter your external key in the External Key field (optional).
25. Enter your description in the Description field (optional).
26. Click the Send Status Notification checkbox if you wish to be notifed of the program's status (optional).
27. Click Edit Process.
28. Click Add Task.
29. Add the data extract activity created in step 3 as the only task in the program's first step.
30. Click Add Step.
31. Click Add Task.
32. Select the file transfer activity from step 13 as the only task in the program's second step.
33. Click Save.
34. Click Save again.
35. Click Start.
36. Select the Start immediately, run once radio button.
37. Click Start.

Running the program imports the data manually.

NOTE: For each additional day, update the date value in step 9 and the file naming pattern in steps 7 and 14 with the new day's date. Re-run the program as described in step 29.