Gift Card Solution Guide

What Is the Gift Card Solution

The gift card solution is the process of offering a subscriber an incentive to complete an action, then delivering a unique code that the subscriber can redeem to receive the incentive.  

You create a data extension and import your inventory of gift codes. When a subscriber earns a code, AMPscript on the landing page gets the next available code from the data extension and gives it to the subscriber. At the same time, the AMPscript also moves the code from the data extension of available codes to a data extension of codes that have been given out and updates the status to indicate that the code is no longer available.

Why Use a Gift Card Solution

Incentives can encourage subscribers to take action that benefits you and them and helps you build a stronger relationship. With the gift card solution, you can provide incentives to encourage subscribers to take an action, such as filling out a form or completing a survey, while maintaining the information on the incentive to track the subscriber's future behavior.

Use a gift card solution to strengthen your relationship with a subscriber by giving them an incentive to share information about themselves and their purchasing habits with you.

Scenario

Northern Trail Outfitters created an incentive program to give customers $25 off their next purchase when they purchase selected items from their online store.

%%[ Var @rows, @row, @code, @link, @inrows, @inrow, @delrows, @delrow, @f, @l, @e, @cnt Set @f = QueryParameter("f") Set @l = QueryParameter("l") Set @e = QueryParameter("e") 
Set @rows = LookupOrderedRows("Gift_Codes",1,"Gift_Code Asc","status","O") Set @row = Row(@rows,1) 
Set @code = Field(@row,"Gift_Code") Set @link = Field(@row,"Gift_Code_Link") 
Set @inrow = 
InsertData("Redeemed","Gift_Code",@code,"Gift_Code_Link",@link,"First_Name",@f,"Last_Name",@l,"Email_Address",@e) 
if @inrow == 1 then  Set @delrow = DeleteData("Gift_Codes","Gift_Code",@code) 
if @delrow == 1 then ]%%  <img src="http://image.exct.net/lib/ff001270756702/m/1/spacer.gif" width="1" height="1" onload="reDir('%%= v(@link) =%%')" alt="Thank You. You are being redirected." border="0" /> 
 %%[ endif ]%%  %%[ else ]%% 
<h1>There was an error with your form submission, Please Try Again.</h1> %%[ endif ]%%

<a href="%%= RedirectTo(Gift_Code_Link) =%%" title="Reserve My Gift Code" alias="Reserve My Gift Code" 
style="font: normal 12px Arial, Helvetica, sans-serif; color: #710;">Reserve My Gift Code</a>

Procedures

The following links take you to the procedures used in this solution.