Section 1
Introduction
Section 2
The Maestro Interface
Section 3
Defining a Job
Section 4
Defining Recipients
Section 5
Defining Content
Section 6
Defining Tracking
Section 7
Sender and Delivery Options
Section 8
Outbox
Section 9
Delivered Jobs
Section 10
Reporting and Statistics
10.1.1 Adding a Data Source Continued
10.1.2 Result Settings Continued
10.2 Executing Reports Continued
Section 11
User Settings
Appendix A
24 Hour Clock
Appendix B
International Character Sets
Appendix C
Comma Separated Files
Appendix D
AOL Rich Text
Recipients details reports are only available for personal or anonymously tracked jobs because this report type is linked to recipient profile data. This report type displays a multi-frame table that lists each data source, and the column data from the define recipients file. Use the table to select which data sources and which columns will be downloaded. Data must be downloaded and imported into a statistical software program to generate charts and graphs.
Select the data sources from the top frame in the table by clicking the Select link. If a data source contains more than one job, all the jobs that have recipients with the same number of columns with the same column labels forming a "profile structure," will be grouped together into one "job-group." If the data source has more than one job and the recipients do not share the same profile structure, these jobs will have their own "job-groups" inside the data source.
The currently selected data source will appear in the lower frame along with the recipient column data for that job-group. Select the column data from the bottom frame using the Edit link or the Select All link. Select the file encoding for the download from the pull-down menu.
Figure 69 Downloading Recipient Details Report Data
10.2.3.1 Downloading Recipient Details Report Data
The collected data available for download is selected from the upper and lower frames of the report. Data sources for tracked events are selected from the top frame and column data pertaining to the recipient profiles is selected from the bottom frame.
Click the Select All link in the bottom frame to select all the columns of recipient data for download. Click the Edit link to add specific columns, subtract columns, and re-order the selected columns to change the data that is downloaded.
Figure 70 Column Selection for Downloading Recipient Details Report Data
Click OK to save the available columns and the order they appear. The Download Report Details screen will reopen. Choose the file encoding for the download from the pull-down menu. Click the Download button to begin downloading the data.
The rows in the downloaded data table are generated in a particular way. For each recipient that generated at least one of the events that are counted by the selected data source, one entry is made. Each entry consists of the profile values of this specific recipient, and are placed in their matching columns. However, only those profile values that match the columns selected will be used. All columns not selected are ignored. If all the columns are not used, recipients may not retain a unique profile. This happens only if the differences in the profiles of recipients are contained in columns that are not selected.
For example, if the columns "EMAIL", "GENDER", "CITY", were part of the recipients data, then each recipient probably has a different profile, because the combination of "EMAIL", "GENDER" and "CITY" is most likely unique for each recipient. But, if the column "EMAIL" is not selected, and the columns "GENDER" and "CITY" are selected, in all likelihood several recipients will have the same profile, namely all those of the same gender that live in the same city. Previously each profile was different because of the inclusion of the "EMAIL" column.
If, during the creation of the report, several recipients are found to have the same "condensed" profile (created by omitting columns that make up the recipient profile), this profile will be included in the report table only once. Instead of including the same profile several times, LISTSERV Maestro simply counts how many recipients share the same profile (for each profile).
In the special purpose column "{COUNT}" each instance of an event for the same profile is recorded. If this column is included, it will be populated with the number of recipients that were matched to the condensed profile defined by the other columns in the same row. The "{COUNT}" column can be used to find out interesting demographic statistics such as how many males from a certain city have clicked on a certain link, and similar information.
The order in which the columns are used can provide information as well, because the rows in the table are sorted in ascending order on the first column. If there are profiles with the same values in the first column, they will be sorted after their second column, and so on.
For example:
Assume that the full profile has the three columns from above: "EMAIL", "GENDER" and "CITY". Assume also that all columns plus the special purpose column "{COUNT}" are selected. The downloaded report table would look like this:
CITY,GENDER,EMAIL,{COUNT}
New York,female,sally@somewhere.com,1
New York,male,john@somewhere.com,1
New York,male,robert@somewhere.com,1
Washington,female,debby@somewhere.com,1
Washington,male,frank@somewhere.com,1
This table means that each of these recipients has generated one event of the type being counted by the data source. The sort order is apparent after first, second, and third columns.
Now, if the "EMAIL" column is omitted, the result would be:
CITY,GENDER,{COUNT}
New York,female,1
New York,male,2
Washington,female,1
Washington,male,1
John and Robert from New York, which differed only in their e-mail addresses, are now aggregated into the profile "male from New York", and there are now two events shown as coming from recipients that match this profile, one from John and one from Robert.
If the "GENDER" column is omitted as well the result would be:
CITY,{COUNT}
New York,3
Washington,2
The resulting data table shows that three events were counted that fit the New York profile and two events were counted that fit the Washington profile.
Click the Use for new job link at the bottom right of the screen to create a new job with a recipients list where each recipient that triggered one of the events counted by the selected data source would have an entry. This would be the same as selecting all columns in alphabetical order, but not the "{COUNT}" column, downloading that report, and then uploading it as the recipients list of a newly created job. The link takes the user to the Start New Job screen where it is only necessary will to type in a title for the new job. After that, a new job with recipients already defined is created.
10.2.3.2 Edit Report / Create Report
To change the definition of the current report, click the Edit Report icon. The Define Report screen opens if the user has the right to edit reports. The current report's General Settings, Data Sources, and Result Settings can be edited and saved to reflect any changes in the current report, or they can be saved as a new report. See Section 10.1, Figure 56, and Figure 57 for more details.
If the current report is a quick report from Delivered Jobs, clicking the Create Report icon will allow the user to create a new report based on the settings of the quick report. Type in a title for the report and then click the Save & Execute button to save the quick report as a regular report. The report title will then show up in the listing of current reports on the Tracking Reports screen. Edit the settings of this new report by clicking the Edit Report icon again. This option is not available for quick reports generated from delivery test data. See Section 9.2 Delivered Jobs Reports for more information.
Event Details reports are available for personal, anonymous, unique, and blind tracking jobs. This report type displays a multi-frame table that lists each data source. Use the top frame to select the data source, and the bottom frame to select the time zone and file encoding to be used to format the downloaded data. Data must be downloaded and imported into a statistical software program to generate charts and graphs.
Figure 71 Download Event Details Report Data
10.2.4.1 Downloading Sum of Events Report
Select the data source from the top frame by clicking the Select link. The currently selected data source will appear in the lower frame. Select the time zone from the top pull-down menu and the file encoding from the bottom pull-down menu. Click the Download button to download the raw data to a local drive.
To change the definition of the current report, click the Edit Report icon. The Define Report screen opens if the user has the right to edit reports. The current report's General Settings, Data Sources, and Result Settings can be edited and saved to reflect any changes in the current report, or they can be saved as a new report. See Section 10.1 and Figure 56 and Figure 57 for more details.
If the current report is a quick report from Delivered Jobs, clicking the Create Report icon will allow the user to create a new report based on the settings of the quick report. Type in a title for the report and then click the Save & Execute button to save the quick report as a regular report. The report title will then show up in the listing of current reports on the Tracking Reports screen. Edit the settings of this new report by clicking the Edit Report icon again. This option is not available for quick reports generated from delivery test data. See Section 9.2 Delivered Jobs Reports for more information.