Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.
One of the easiest ways to track the success of marketing pieces like gift certificates and coupons is to add a tracking number or code to each gift certificate or coupon that you distribute. When gift certificates or coupons are redeemed, you can use these tracking numbers to record and categorize customer responses.
This article explains how you can add tracking numbers to batches of gift certificates or coupons that you create in Publisher.
Approaches to tracking
You can take a couple of different approaches when you incorporate tracking information into your publications. For example, you can do either of the following:
-
Add unique numbers to gift certificates By using a unique number on each certificate, you can track when gift certificates are redeemed, by whom, and for what product or service. In addition, by adding unique tracking numbers, you can ensure that the gift certificates are not duplicated or redeemed more than once.
-
Add specific codes to coupons to track customer responses Use different codes for your different marketing messages, advertisements, or promotions. These codes will enable you to keep track of how customers learned about your offer. The more you learn about who is drawn to your business and what attracts customers' attention, the better you can focus future marketing efforts.
Note: You can use the same method when you need to add sequential numbers to admission and raffle tickets, invoices, and any other type of publication.
Step 1: Create a data source that lists tracking numbers
To use mail merge to create a batch of gift certificates or coupons with tracking numbers, you need to set up a data source that contains a column listing the tracking numbers. If you plan to add only the tracking numbers to your publications, create a data source for the tracking numbers. If you also plan to use mail merge to insert additional information into your publications, such as customer names or addresses, you can add the column of tracking numbers to a data source that also lists the name and address data that you want to use.
You can use Publisher, Excel, Access, or Outlook to create a data source for your mail merge project. If you want to create a large list of unique, sequential numbers to use as tracking codes for gift certificates or coupons, however, you can use Excel to quickly generate this list.
Use Excel to create a list of unique tracking numbers
-
In Excel, open a new or existing worksheet.
-
In the first cell of the column where you want to add tracking numbers, type a label, such as Tracking Number, and then press ENTER to move to the row below.
-
In the second cell in the column, type the number for the first tracking number in the series. For example, type 1,000.
-
In the cell below, add 1 to the number you entered in the cell above, and then type that number. For example, type 1,001.
This establishes a pattern for the series of numbers that you are creating.
-
Select the cells that contain the starting values.
-
Drag the fill handle across the range of cells that you want to fill.
-
When you have created as many tracking numbers as you need, save your file.
Add specific predetermined tracking codes to a data source
If you have already developed a set of specific code numbers that you want to use to track and categorize customer responses, you can type these numbers into a column of the data source that you plan to use for the mail merge.
-
In Excel, open a new or existing worksheet.
-
Click the first cell in the column where you want to enter the data.
-
Type a label, such as Tracking Code, and then press ENTER to move to the row below.
-
Type a tracking code, and then press ENTER to move to the row below.
-
Repeat until you have listed all of the tracking codes that you plan to use.
Note: To create multiple copies of a gift certificate or coupon that all share a specific tracking code, you can type the same number multiple times within the column.
-
When you have created as many tracking codes as you need, save your file.
Step 2: Use Publisher to create a gift certificate or coupon
You can create a gift certificate or coupon publication using Publisher by starting with a pre-designed gift certificate publication or by designing a gift certificate from scratch.
-
To choose a pre-designed publication, choose the Gift Certificates category to find the gift certificate template you want, and then open, design, and save your certificate based on that template.
-
To design a certificate from scratch, you can either start with a completely blank publication or adapt an existing publication. Small-sized publication types, such as business cards, postcards, and labels can be adapted to serve as coupons. Flyers or brochures can be adapted for use as gift certificates. For more information, see Create a publication in Publisher.
Step 3: Use Mail Merge to add the tracking codes to your publication
After you set up your list of tracking numbers in the data source and design your publication, you are ready to merge your list of tracking numbers with your publication to create a batch of gift certificates or coupons that each displays a unique tracking number.
This particular mail merge project involves four broad steps:
-
Connect your gift certificate or coupon publication to the data source.
-
Insert a data field into your publication as a placeholder for the tracking number information.
Connect your publication to the data source
-
Save and close the data source that contains your list of tracking numbers.
-
Open your Publisher gift certificate or coupon publication.
-
On the Mailings tab, click the Mail Merge menu, and then click Step-by-Step Mail Merge Wizard.
-
In the Mail Merge task pane, under Create recipient list, select Use an existing list, and then click Next: Create or connect to a recipient list.
-
In the Select Data Source dialog box, locate the data source that contains your tracking numbers, select the file, and then click Open.
-
If your data source is an Excel worksheet, select the worksheet that you want from the list in the Select Table dialog box.
-
In the Mail Merge Recipients dialog box, you can select the tracking codes that you want to include in the merge. Select the check boxes next to the records that you want to include, and clear the check boxes next to the records that you want to exclude.
If you want to use only certain entries in your list, you can filter your list by a specific field or criterion. After you filter the list, you can use the check boxes to include and exclude records.
Filter items in the list
-
Click the arrow next to the column heading of the item that you want to filter by.
-
Click any of the following:
-
(Blanks) displays all the records in which the corresponding field is blank.
-
(Nonblanks) displays all the records in which the corresponding field contains information.
-
(Advanced) opens the Filter and Sort dialog box, which you can use to filter using multiple criteria. You also can click Filter under Refine recipient list in the Mail Merge Recipients dialog box to open the Filter and Sort dialog box.
Tip: If your data source contains records that share the same information, and there are ten or fewer unique values in the column, you can filter by specific information. For example, if there are multiple records that list Australia as the country/region, you can filter on Australia.
The Mail Merge Recipients dialog box displays only the designated records. To display all the records again, click (All)
-
Sort items in the list
-
In the Mail Merge Recipients dialog box, click the column heading of the item you want to sort by.
-
To quickly select or clear all items, select or clear the check box column heading.
-
To sort using multiple criteria, click Sort under Refine recipient list in the Mail Merge Recipients dialog box. In the Filter and Sort dialog box, select the criteria you want to sort by.
-
-
Click OK.
Insert a data field into your publication
After you connect your publication to the data source that you want to use, you can insert a data field into your publication in the location where you want the tracking number to appear.
-
In the Mail Merge task pane, under Prepare your publication, click the tracking number data field, and then drag it into your preferred location on the gift certificate.
-
If you want to insert data fields for additional information in your data source, such as customer names or addresses, drag those field names into your publication.
-
If you want to apply formatting to a data field to change the appearance of the merged data, select the field, click the Format tab and select the options that you want.
-
At the bottom of the Mail Merge task pane, click Next: Create merged publications.
-
Save your publication.
Preview the merge
Before you complete the merge, preview the merge results to make sure that the tracking numbers will display as you want them to in your publications. You can preview the merge in two ways: While you are refining the layout to review the layout of the individual coupon or gift certificate, or when you are getting ready to print, to preview the arrangement of coupons or gift certificates on the printed sheet.
-
On the Mailings tab, click Preview Results.
-
Click the navigation buttons to see how the other entries from your data source look in your publication.
Print the merged publication
-
In the Mail Merge task pane, under Create merged publications, click Print.
-
On the Print page, preview your print layout, select the printing options that you want, and then click Print.