The following reports are available for the Mail module: Batch Analysis - Pending and Completed Mail Report, Daily Calls, Data Entry, Executive Summary, IMA Rules Usage, IMA Rules Usage by Action Type, Incoming Method Report, Incoming Method Report - Multiple Methods, Incoming Source, Issue Code Analysis of Mail and People, Letter Frequency, Letter Writing Backlog, Mail Aging, Mail and Workflow Productivity, Mail Issue Analysis, Open Mail Activity, Open Mail by Staff, Open Mail by Assigned and Approver, Opinion Summary Report, Outgoing Issue and Letter Analysis, Outgoing Mail Detail Report, Outgoing Mail Summary Report, Staff Mail Log, Staff Mail Log for Letter Batch and Staff Mail Log From Select List
This report provides batch owner, record id of oldest mail, along with a count of pending and completed mail in active or archived batches for a selected date range.
The following options are available for this report:
Date In From – To limit the report to mail within a specific date range, type a begin date or click the calendar icon and select a date from the calendar that appears. This date is required in order to run the report.
Through – Leave this date field empty and IQ will use the current date as the end date or you may enter or select another end date.
Include Targeted Mailings – Select Yes if you would like the report to include Mail records that are part of a targeted mailing. Select No to limit the report to Mail records that are not part of a targeted mailing.
Include Archived Batches – Select Yes to include archived batches in the report. Select No to limit the report to only active batches.
Output To – This defaults to Microsoft Word. Click in this field and select Microsoft Excel or PDF if you would like the report to be available in another output type.
There is also an option to run this report in the background, which is recommended when running the report for large volumes of mail.
The Daily Calls report lets you report on incoming correspondence for a selected incoming method. This report can be used, for example, to report on all incoming e-mail entered during a time period, or incoming phone calls entered by a particular staff member. The report contains the name and address of the people record, the incoming date and comments, the user that entered the incoming and the assigned staff. Note: IQ automatically excludes all Mail records with an Incoming Method of Nondeliverable for this report.
The following options are available for this report:
Incoming Method – Click in this field and select a method from the list that appears.
Starting and Ending Date – To limit the report to incoming correspondence created within a date range, type a begin and end date or click the calendar icon next to the fields and select a date from the calendar that appears. Both of these dates are required in order to run the report.
Limit Report to Selected Staff - Select No to run the report for all staff. Select Yes if you would like to limit the report to one or more users. If you select Yes, then click on the lookup icon to select the staff from the list.
Sort Report by – Select Incoming Date to sort this report by the date on which the incoming correspondence was entered; select Incoming Staff (Entered By) to sort this report by the staff member who entered the incoming correspondence.
The Data Entry report provides a count of mail records for a selected date range that were created by all staff. For each selected staff, the report displays the count for mail that was created by a posted Set in the Set Mail column and mail recreated outside of a Set in the Non-Set Mail column. Note: IQ automatically excludes all Mail records with an Incoming Method of Nondeliverable for this report.
The Executive Summary Report shows mail and workflow activity for a user-specified time period. It shows totals, volume trends, and numbers for staff major issues. You can choose to run this report for the latest week, the last two weeks, the current month to-date, or the past month (from the same day of the last month to the current day) by selecting one of these options when you run the report.
The top half of the report summarizes in text the following information:
The number of pending letters and open workflows on the current date.
The number of letters and workflows that were logged in and closed during the report period.
The top issue codes for letters and workflows added during the report period.
The staff member assigned the most new mail during the report period and the one with the most pending letters on the current date.
The staff member who opened the most workflows during the report period and the one with the most open workflows on the current date.
The average turnaround time for letters closed during the report period.
The number and percentage of form letters vs. individual letters used for mail records closed during the report period along with the mail records closed with no response.
Tables in the lower portion of the report reiterate the text portion of the report and give information for additional time periods, staff members, and issue areas.
These tables show letter and workflow numbers for the report time period.
Letter Volume Trends
# of letters for the time period
# of letters year-to-date
# of letters last 2 months
average # letters last 10 weeks
New Letters by Staff
(Top 5)
Pending Letters by
Staff (Top 5)
New Letters - Top 5
Issues
Workflow Volume Trends
# of workflows for this week
# of workflows year-to-date
# of workflows last 12 months
average # of workflows last 10 weeks
New Workflows by Staff
(Top 5)
New Unassigned Workflows
Open Workflows by Staff
(Top 5)
Open Unassigned Workflows
New Workflows
This report lists every IMA Rule that has fired within a specified period of time and shows the number of times each rule has fired. Included in this report is the rule action type, rule ID, rule name, rule status, the number of times the rule fired (usage count), and the last date on which the rule was fired.
The following options are available for this report:
Date Options
Status to Report On
Sort Options
This report lists every IMA Rule that has fired within a specified period of time, grouped by the rule action type. Included in this report is the rule action type, rule ID, rule name, rule status, the number of times the rule fired (usage count), and the last date on which the rule was fired.
The following options are available for this report:
Date Options
Status to Report On
The Incoming Method report lets you report on incoming correspondence for a selected incoming method. This report can be used, for example, to report on all incoming e-mail entered during a time period, or incoming phone calls entered by a particular staff member. The report contains the People and Outgoing IDs, name and address of the people record, the incoming date and comments, the user that entered the incoming and the assigned staff. Note: IQ automatically excludes all Mail records with an Incoming Method of Nondeliverable for this report.
The following options are available for this report:
Incoming Method – Click in this field and select a method from the list that appears.
Starting and Ending Date – To limit the report to incoming correspondence created within a date range, type a begin and end date or click the calendar icon next to the fields and select a date from the calendar that appears. Both of these dates are required in order to run the report.
Limit Report to Selected Staff - Select No to run the report for all staff. Select Yes if you would like to limit the report to one or more users. If you select Yes, then click on the lookup icon to select the staff from the list.
Sort Report by – Select Incoming Date to sort this report by the date on which the incoming correspondence was entered; select Incoming Staff (Entered By) to sort this report by the staff member who entered the incoming correspondence.
The Incoming Method - Multiple Methods report lets you report on incoming correspondence for more than one incoming method. The report contains the People and Outgoing IDs, name and address of the people record, the incoming date and comments, the user that entered the incoming and the assigned staff. Note: IQ automatically excludes all Mail records with an Incoming Method of Nondeliverable for this report.
The following options are available for this report:
Starting Date Opened - Type a begin date or click the calendar icon and select a date from the calendar that appears. This date is required to run the report.
Ending Date Opened - Leave this field empty and IQ will use the current date as the end date or you may enter or select another end date.
Methods to Report on - Select the Incoming Method(s) you want to report on using the Ctrl key to select multiple methods. Select All Values to report on all active Incoming Method codes in your code file.
The following information is available in the completed report:
Method In - The Incoming Method(s) being reported on.
Completed - The total number of correspondence records that have been completed during the selected date range and incoming method(s).
Pending - The total number of correspondence records that are pending for the selected date range and incoming method(s).
Total - The total number of both Completed and Pending correspondence records during the selected date range and incoming method(s).
Percent - The Incoming Methods by percentage for the date range selected.
This report shows the source of incoming mail (ZIP Code, City or County)) and the method by which it arrived (Fax, Walkin, E-Mail, Phone, U.S. Mail). You can run this report for a date range by entering dates in the Starting date and Ending date fields. Your selection in the Sort by field identifies the source and sorts the report by that field. There is an option to run this report in the background, which is recommended when running the report for large volumes of mail. Note: IQ automatically excludes all Mail records with an Incoming Method of Nondeliverable for this report.
This report provides counts of the number of People records and Mail records with an issue code for a specified date range. Note: IQ automatically excludes all Mail records with an Incoming Method of Nondeliverable for this report.
The following options are available for this report:
Date In From – To limit the report to incoming correspondence created within a date range, type a begin date or click the calendar icon and select a date from the calendar that appears. This date is required in order to run the report.
Through – Leave this date field empty and IQ will use the current date as the end date or you may enter or select another end date.
Include Targeted Mailings? - This defaults to Yes. Click in this field and select No if you do not want to include targeted mailings in the report.
Sort Order – This defaults to Issue Code. Click in this field and select Issue Translation, People Count (Descending) or Mail Count (Descending) if you would like to sort to report by another criteria.
Output To – This defaults to Microsoft Word. Click in this field and select Microsoft Excel or PDF if you would like the report to be available in another output type.
There is also an option to run this report in the background, which is recommended when running the report for large volumes of mail.
The Letter Frequency Report shows the names of all form letters in mail records with closed dates that fall within a specified range. The report does not check the Outgoing method, and reports on all methods (U.S. Mail, E-Mail, and so forth). You have the option to include Targeted Mail and customized letters. The letters on the report are sorted by frequency of use.
The Letter Frequency Report by Zip is identical but sorts the letters by ZIP Code. For each ZIP Code, the report shows all form letters sent during the time period, sorted by frequency of use. There is an option to run this report in the background, which is recommended when running the report for large volumes of mail.
The Letter Frequency Report by Method only reports on the outgoing methods USMail and E-Mail. It shows the total number of letters sent during the time period for each method and is sorted by frequency of use.
These reports show the form letter name and version, the number of times the letter was sent during the selected date range, and its percentage of the total letters sent during the date range.
The Letter Writing Backlog and Letter Writing Backlog By Issue both report on all pending mail for all or selected staff as of the date in which you run the report. The difference is that the Letter Writing Backlog report does not include Issue Codes, which results in different totals at the end of each reports. This is because mail records that contain multiple issue codes are counted multiple times on the Letter Writing Backlog by Issue report but not on the Letter Writing Backlog report. You can run these reports in the background, which is recommended when running the report for large volumes of pending mail.
The following options are available for these reports:
Sort Report By
Limit Report to selected
Assigned Staff
Based on a date range and two aging values (number of days), the Mail Aging report tallies the mail activity. There are two sections to this report. The first section shows the number of various types of mail opened, responded to, and pending for selected staff members. The second section of the report shows, for each selected staff member, the number of pending letters and how long they've been open based on user-defined criteria for recent and oldest letters.
Mail Aging report criteria let you select date in or date created, a date range and staff to report on. There is an option to run this report in the background and email the results, which is recommended when running the report for large volumes of mail. When you select the option to run the report in the background, there is an another option to Edit Background Job which opens the Background Job record where additional edits can be made to the job.
Date Criteria For Report
Date Options
Maximum Days for Most
Recent
Minimum Days for Oldest
Staff Options
For selected or all staff members in your office, the report shows the total number mail records that have not yet been closed. The second page of the report takes the remaining open mail records and "ages" them based upon your minimum and maximum aging values.
The first section of the report uses the date and staff criteria to report the following numbers for each staff member. A total for all staff members reported on is also given.
Open as of nn/nn/nnnn
Mail Received
Mail Completed
Unsolicited Mail
Total Mail Sent
Open as of nn/nn/nnnn
The second, or aging, portion of the report shows aging information for each user’s open (pending) mail—mail that has not been closed.
N
Days Old or Less
N-N
Days Old
N Days Old or More
Total Pending Letters
Total Days Pending
Average Days Pending
The Mail and Workflow Productivity report shows mail and workflow activity for a user-specified date range. There is also an option to run the report in the background. The first table in the report contains totals for pending, received, completed and turn around time for mail and workflow for the selected date range. The second table includes the count and percentage of closed mail by letter type (form or custom) for the selected date range. The third and fourth tables provide the following volume trends and top 5 issues for Mail and Workflow:
Mail Volume Trends
Mail for date range specified
Mail year-to-date
Mail last 2 months
Average mail last 10 weeks
New Mail - Top 5 Issues
New Mail by Staff (Top
5)
Pending Mail by Staff
(Top 5)
Workflow Volume Trends
Workflows for date range specified
Workflows year-to-date
Workflows last 12 months
Average workflows last 10 weeks
New Workflows
New Workflows by Staff
(Top 5)
Open Workflows by Staff
(Top 5)
Mail Issue Analysis reports let you review the issue codes associated with mail by zip code or county. The Mail Issue Analysis report displays the issue code, its description, and the number of times the code was part of a mail record during the date range you specify.
Mail Issue Analysis by County sorts and displays the information by County. This report shows all issues codes that were part of mail sent to each County.
A similar report, Mail Issue Analysis by Zip, sorts and displays the information by ZIP Code. This report shows all issue codes that were part of mail sent to each ZIP Code.
All three reports show the issue code, its translation, and a count and percentage for each code. There is an option to run these reports in the background, which is recommended if the selected date range results in a large volume of mail.
This report provides detailed activity for each open mail record for selected staff. The activity includes, but is not limited to, when the outgoing was created, the letter or method was changed or the set was posted. The report is sorted by staff and then by the outgoing mail record ID. Included on the report is the assigned staff, the Mail ID, the letter assigned to the mail record, the date entered and the People name information. You can run this report in the background, which is recommended when running the report for all staff.
The following options are available for this report:
Include Tmail
Include Form Letters
Limit report to mail received
after a specified date
Limit Report to selected
Assigned Staff
This report lists mail that has not been closed. Included on the report is the Mail ID, the letter assigned to the mail record, the date entered, the People name information, and any issue codes assigned to the record. The Open Mail by Staff report is sorted by User Name, Date In and then Outgoing ID.
The following options are available for this report:
Date Range
Include Targeted Mailings
Include Workflow Related
Mail
Staff Options
This report shows the number of open mail records assigned to each user 1 to 14 days ago, 15 to 21 days ago, and more than 21 days ago, and totals these three numbers in the Total Open column. For each user, an open mail count is given for the number routed to each approver, the number routed to Any Approver, the number with a status or On Hold Denied, and the number with a status of Approved and ready to be sent. The total number of pending letters for each user as well as a grand total of all pending letters is also provided. You have options to include or exclude targeted mail and workflow-related mail. There is also an option to run this report in the background, which is recommended if your database contains a large number of mail records.
The Opinion Summary Report lets you review the issue codes associated with mail that has an incoming method of Opinion. The report displays the issue code ID, its translation, and the number of times the code was part of a mail record during the date range you specify along with the percentage of the total count for each issue code.
The Outgoing Issue and Letter Analysis report lets you report on completed mail for all staff or selected staff for a user-defined date range. The report contains the Issue Code ID and Translation for the completed mail records. The text "No Issue Code" will appear in the Issue Code column for mail records that do not have a selected Issue Code. The letter names for each completed mail record appear in the Letter Name column on the same row as the associated Issue Code. Note that completed mail records without a letter name are not included in this report. The Count column displays the total count for each letter name. The Total column contains the total count of all letters for each Issue Code. The Pct column displays the percentage of the total.
The Outgoing Mail Detail Report lets you report on outgoings that have been closed within a user-defined time period. It shows letters closed by all or selected staff members, with the total number of each letter for the staff member. Note: IQ automatically excludes all Mail records from this report that have an Outgoing Method of No Response.
The following options are available for this report:
Date Range
Include Letter Type
Staff Options
Sort Report by
The Outgoing Mail Summary Report lets you report on outgoings that have been closed within a user-defined time period. It shows totals for each letter type closed during the time period. Note: IQ automatically excludes all Mail records from this report that have an Outgoing Method of No Response.
The following options are available for this report:
Date Range
Include Letter Type
Staff Options
Sort Report by
The Staff Mail Log is a detailed report on pending responses to incoming mail for selected staff for a selected date range. The Staff Mail Log for Letter Batch is a detailed report on pending responses to incoming mail for a selected batch. The Staff Mail Log From Select List is a detailed report on pending response The Staff Mail Log and Staff Mail Log for Letter Batch reports contain the incoming date, number of days pending, name and address, salutation, people ID, method, issue codes, staff, letter name and mail ID. The Staff Mail Log From Select List contains the incoming date, name and address, people ID, method, issue codes, staff, letter name and mail ID.
The report criteria for the Staff Mail Log report includes:
Date Options
Staff Options
The report criteria for the Staff Mail Log for Letter Batch report is Letter Batch to Report on. Click in the field and select the batch name from the list that you want to report on.
The report criteria for the Staff Mail Log From Select List report is Name of Mail Select List to Report on. Click in the field and select the list name that you want to report on.