Live Offers

Viewing Data Extensions

Data extensions store valuable information marketers can use to plan their next campaigns, estimate the success of their current or most recent campaign, and issue reports about their campaigns.

You choose the data extension you want, such as CouponCodes, which contains information about the specific coupon codes issued for a campaign. The data extension creates the required columns, and you can include additional columns as well.

You can use the CouponRedeemers data extension to view information about redeemed coupons. The value of using CouponRedeemers offers information that can be used to report on offers distributed versus those coupons opened and those redeemed.

You can also use your CouponRedeemers data extension to store redemption data captured in your POS (point of sale) system, which you can then download to your system for reporting purposes.

For more information, see How to View the Data in a Data Extension section in this document.

NOTE: Enterprise 2.0 clients must place coupon information in data extensions specifically tied to the business unit containing the Live Offer. Do not place coupon information in shared data extensions.

Viewing Reports

The ability to track coupons and all sorts of actions means that you can gain a great deal of information about your customers and your coupon campaigns. As you receive feedback on who bought what where, you can continually make adjustments to get the most out of your campaigns.

You can view custom reports (as shown in the Viewing Reports section) to give you feedback for analysis and planning future campaigns. These custom reports can include a Campaign Summary report, which displays one row for each campaign you run. Each row may include information such as Total Coupons Uploaded, Total Coupons Assigned, and Number Remaining. You get to choose the attributes shown. You can also view a Campaign Redemption Summary report, which again displays one row for every campaign. This summary is based on information about people who redeemed their coupons, and again, you can choose which attributes to track, such as Total Redeemed, Redemption Rate, and Average Redemption Lag.

NOTE: These custom reports must be configured for your account and require a custom engagement from our Global Support team. Contact your ExactTarget representative for more information about enabling and configuring these reports to meet your needs.

Properties

The first field you must fill out is Name. Enter the Name you specified earlier in the How to Create the Email Message.

After you enter the name, you must enter the External Key. This is a value that uniquely identifies the coupon. Next, enter a Description for your coupon.

The Coupon Code Type includes a drop-down list. These choices are currently supported coupon code symbologies (such as barcodes) that tell ExactTarget how to render your coupon codes. You can use various classes of 2D coupon codes, coupon codes, or just rendered code text that serves as a coupon code. Valid values include:

• Codabar
• Code11
• Code 128
• Code 128-A
• Code 128-B
• Code 128-C
• Code 39
• Code 39 Extended
• Code 93
• Code 93 Extended
• EAN-13
• EAN-8
• Industrial 2 of 5
• Interleaved 2 of 5
• Mat 25
• MSI Plessey
• Postnet
• Planet
• Telepen
• UPC-A
• UPC-E
• OneCode
• Data Matrix
• PDF417
• Plain Text

• Inventory-Based: You must upload a set of coupon codes into a data extension and select that data extension in the window below the Coupon Code section. The subscriber receives the same coupon code each time the email message is rendered.
• Segment-Based: You must upload a set of coupon codes into a data extension and associate those codes with a subscriber key. Select that data extension in the window below the Coupon Code section. The subscriber receives the same coupon code each time the email message is rendered.
• Transaction-Based: You must upload a set of coupon codes into a data extension and associate those codes with a transaction key. Select that data extension in the window below the Coupon Code section. The subscriber receives the appropriate coupon code or series of codes for each transaction. Using this method, subscribers can claim multiple coupon codes per transaction.

Redemption is a drop-down list where you can choose to select the data extension containing your coupon redeemer information. The Redemption data extension is an optional data extension for saving store redemption information for the purposes of reporting. A customer would typically capture redemption information in their POS (point of sale) system and periodically upload it back to ExactTarget. Some of the information they may want to capture includes the campaign code, the coupon code, and the date the offer was redeemed. See the Viewing Reports section.

If using the Redemption reports, you will want to include a unique campaign code (user-specified) when uploading your coupon codes so the system can tie the offer to the number of redemptions.

Remember that data extensions must be created before you can use them. This is why they are presented in drop-down lists. See the Data Extensions Guide for information on creating a data extension.

The Coupon Period lets you specify your beginning and end dates for the coupon campaign. Note that pop-up calendars are available to help you choose. If you do not want your coupon to expire ever, leave the End on checkbox disabled. If you do not specify a start and stop date, ExactTarget will not render coupons as expired after your promotion ends.

You can change expiration at any time, affecting coupons already sent.

Image Properties

Here you see three boxes:

• Displayed for preview in editor: This is an image that is used as a placeholder when designing your email or previewing it in the editor.
• Displayed for invalid requests: This image is displayed when there are no more coupon codes assignable to a recipient.
• Displayed for expired requests: This image appears, stating that the coupon has expired, if the email is opened after the coupon period.

All images can be changed even after you have selected an initial image. Just click the change link below each image box.

Width (px) x Height (px) allows you to specify how large you want your coupon code images to display. Note that measurements are in pixels.

Alt Text lets you add any an alternative text tag for the coupon code image.

CouponCodes

Data extensions store valuable information that marketers can use to plan their next campaigns, estimate the success of the current campaign, and issue reports about the campaign.

The CouponCode data extension contains information about the specific coupon codes issued for a campaign. CouponCode is the only required field when uploading data. SubscriberKey is optional if you want to pre-assign coupons. All others are system generated.

• LiveContentInstanceID
• CampaignCode
• CouponCode
• SubscriberKey
• JobID
• BatchID
• DateAssigned

CouponRedeemers

This data extension contains information about redeemed coupons. The CouponRedeemers data extension contains these fields:

• CampaignCode
• CouponCode
• DateRedeemed

As an optional use, you could use the CouponRedeemers data extension to contain redemption data captured in your POS system you upload from your system for reporting purposes.

The value of using coupon redeemers is the ability to report on offers distributed versus those opened and those redeemed. This data, along with other, such as value of coupon, store location, etc., can provide invaluable information to marketing departments when planning their next campaign.

Campaign Summary

You can generate this report to display one row for each campaign you run. Each row may have the following columns (you may choose to filter out some columns):

• Campaign Code
• Campaign Name
• Start Date
• End Date
• Total Coupons Uploaded
• Total Coupons Assigned
• Number Remaining
• % of coupons distributed
• Date/Time of First Coupon Served
• Time Since First Coupon Served
• Avg. Coupons Severed per Hour
• Max coupons Severed per Hour

You will be able to filter based on Campaign, Campaign Start, and Campaign End.

A sample Campaign Summary Report follows.

Campaign Redemption Summary

This report displays one row for every campaign. This summary is based on information about people who redeemed their coupons. Each row may include these columns:

• Campaign Code
• Campaign Name
• Start Date
• End Date
• Total Assigned
• Total Redeemed
• Redemption Rate
• Avg. Redemption Lag

A sample Campaign Redemption Summary Report follows.

The example below shows an offer with several types of live content, including the coupon code.

You may forward this email. For example, you can use the Forward to a Friend feature to send this email to another party. The offer will contain the name of the subscriber who forwarded the email and the coupon of the forwarding subscriber.