Click here for a sample Audit Issue Galley report (short version)
This report prints a list of all or some of the subscribers who received the audit issue. It can also provide breakdowns by business and occupation, by qualification source, by mailing address type and by geographic region. You should use this report for several purposes:
To create a full printed galley of the subscribers who received the audit issue. This would be something that you send to the auditor in lieu of the galley data file if he is unable to perform a "computer to computer" style of audit.
To print a test selection. After examining the full galley the auditor will ask you to print a selection of subscribers from the full galley, beginning with a specified number and selecting subscribers at fixed intervals thereafter.
To print lists of subscribers with particular characteristics. Say your initial publisher's statement indicates that you have 2,000 subscribers who are buyers of widgets. The auditor may ask you to prove that number by printing a galley of the subscribers whose qualification data indicates that they are buyers of widgets.
The data for this report comes from the galley data file that is produced automatically by the issue label update for each issue that is marked as an audit issue in the issue table. The galley data file is a dBASE file (albeit with a file name extension of QFDAT instead of DBF) that contains a list of every subscriber that received the audit issue and his or her classification, request type, qualification date, and qualification data.
The galley file's name is made up of the database name, publication code, and issue number. For example, if your audit issue for publication code WIDGET in the standard QuickFill database (that is the database files are named QFWDB*.QFDAT) was issue #144, the galley data file would be named QFWDB_WIDGET_0144.QFDAT.
This data file is located in the database directory. It should not be deleted. If it is, you will not be able to run the 'Audit issue galley' report for the issue associated with the file. QuickFill does allow you to generate a galley file in case of loss or damage to the original file, but it is always best to work with the original. Any changes in your database since the audit issue will be reflected in the reconstructed galley file; this file may not be the same as the original. In the event that a galley data file for a particular audit issue is deleted or damaged, you should first back up your current database, then restore your database and galley data file back to a point before the galley data file was deleted or damaged.
The filter screen for this report has three tabs
Publication
Enter the code for the publication on which you would like to report. You may enter the code directly or right click once to select from a list of publications.
Audit issue
QuickFill enters the most recent audit issue in this field. For example, if you ran your May audit issue, advanced the issue pointers, and then went to run the 'Publisher's statement', this field would default to the May issue—the most recent audit issue. If you would like to run this report for a different issue, simply type over the existing entry or right click once to select from a list of issues, but the issue you select must have been marked as an audit issue when it was served..
Business/Occupational Breakdown
Check this box if yout want a business/occupational breakdown. You may select a single question to be reported on or you may select any pair of questions. Selecting two questions (business and title, say) results in a cross-tab-style report that uses the first question for the row headings and the second question for the column headings. You may either enter the question numbers in the 'Row headings' and 'Columns' fields or right click to select from a list of the questions on the qualification form.
If you have subscribers with multiple responses to the question selected for the 'Business/Occupational Breakdown', only the first response entered will be counted if you create a cross-tab-style report. If you select only one question, thus creating a report that does not have a cross-tab-style, all of the subscribers' responses will be counted.
Qualification Source Breakdown
Check this box if you want a qualification source breakdown. This section shows the number of qualified subscribers broken down by the type of request and the age of the qualification data. The age of the data is determined by calculating the interval between the qualification date of the subscriber and the date specified in the 'Aging date' field.
Aging date
The default for this field is the first day of the month of the audit issue.
Mailing Address Breakdown
Check this box if you want a mailing address breakdown. This section shows the number of qualified subscribers broken down by the way they are addressed—by name and title, by name only, by company only, and so forth.
Geographical Breakdown
Check this box if you want a geographical breakdown. This section shows the number of qualified subscribers broken down by U.S. state and region as well as by Canadian province.
Note: Geographical breakdown by county or country
QuickFill provides the ability to produce a geographical breakdown by county or country instead of by U.S. state and Canadian province. Click here for details on creating a geographical breakdown by county. Click here for details on creating a geographical breakdown by country.
Include additional breakout of Other sources for Paragraph 3b
Check this box if you would like the report to include a breakdown of Category V ("Sources other than above") for Paragraph 3b. If your publication is audited by the BPA and Category V accounts for more than five percent of your qualified circulation, you will need this breakdown for your Publisher's statement.
Include paid subscriptions in paragraph 3b
Check this box if you would like the report to include paid subscriptions for Paragraph 3b. If your publication is audited by the BPA, inclusion of paid subscriptions in paragraph 3b is optional.
Service codes
Enter one or more service codes, and your report will only include customers whose order was entered with that service code. If your publication has separate editions and you use service codes to designate which edition a subscriber receives, you can use this field in conjunction with the 'Print paragraph 3 & 4 summary only' option to report on each edition separately.
Select names beginning at...
Enter the number in the galley at which you would like to start selecting names and the interval at which the names should be selected for the auditor's test selection. For example, if the auditor's instructions were to start at the fifth name on the galley list and select every tenth name, you would enter "5" in the 'Select names beginning at number' field and "10" in the 'and at an interval of' field.
Print full address
Select this option if you would like the report to display the full address for each customer included.
Print name, title, company, state, and zip
Select this option if you do not need to display the customers' full addresses. The name, title, company, and zip code will be displayed for each customer as opposed to the full address information.
Print paragraph 3 & 4 summary only
Select this option if you would like the report to omit the list of customers and include only the summarized information for paragraphs 3 and 4.
Click here for a description of the fields on the 'Subscriber 1 and 2' tab.
Click here for a description of the fields on the 'Subscriber 3' tab.
Click here for more information about Filter screens and Options for running reports.