Using the Map Report

After you send a mailing, you can view the Map Report to see a breakdown of results according to state or province. For example, let's say you do a mailing where three members live in New York. When you open the Map Report, it looks like this:

 

map_report_opening_view1.gif

 

As you can see, the "1" graphic points to New York State. To see cumulative statistics on all mail sent to that state, move the pointer over the "1" graphic. A popup appears and displays the statistics:

 

map_report_new_york_statistics.gif

 

In order for the Map Report to work, each member must have the following two demographics:

 

Country_

State_Province_

 

NOTE ListManager will only support a 3-character country code and 2-character state/province.

 

Important These names must be exact. If, for example, you already have a "Country" demographic but it doesn't end with an underscore, the Map Report will not work.

 

To add the necessary demographics to the members_ table

1. In the left Navigation bar, click Utilities : Administration : Server : Database : Add/Remove Member Columns : Add Column Wizard.

2. In the Description column under the Location sub-section, select Country and choose the three-character string - char(3) for the datatype and State/Province and choose the two character string - char(2) for the datatype.

3. Click OK.

 

To view the Map Report for a mailing

1. In the left Navigation bar, click Home.

2. Under Mailing Name, click the mailing you want.

3. In the lower right corner next to Where mails sent, click Click here.

 

click_here_link_for_map_report1.gif

 

NOTE After you add the necessary demographics, the Map Report becomes available for all mailings, including past ones.