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, If you send a mailing where three members live in New York. When you open the Map Report, it looks like this:
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:
In order for the Map Report to work, each member must have the following two demographics:
Country_
State_Province_Note
Aurea List Manager only supports a 3-character country code and 2-character state/province.
Also names must be exact.For example, you already have a Country demographic but it does not end with an underscore, the Map Report is not going to work.
To add the necessary demographics to the members_ table
- In the left Navigation bar, go to Utilities > Administration > Server > Database > Add/Remove Member Columns > Add Column Wizard
- 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.
- Click OK.
To view the Map Report for a mailing
In the left Navigation bar, click Home.
Under Mailing Name, click the mailing you want.
In the lower right corner next to Where mails sent, click Click here.
Note
After you add the necessary demographics, the Map Report becomes available for all mailings, including past ones