Paragraph 3 by Zip

When reporting circulation figures for AAM, it might be helpful to have a listing of circulation totals for a given date range by Zip code. The Paragraph 3 Report By Zip Code will provide you with this information.

Notes:

• Only Zip codes where at least 25 copies are delivered are listed individually.

• The totals on this report should balance to the paid circulation totals on the Daily Circulation Report. Verify this monthly.

• The report may not exactly balance to the Paragraph 3 Report by Town because of rounding when a date range is selected. This is especially true when there is not a one-to-one relationship between Zip and Town of 25.

• Business Rules determine whether AAM circulation history is stored by Zip code and, if so, whether each Town of 25 is stored or only the primary town in the Zip code. If AAM history is stored by Zip by Town of 25, run the Paragraph 3 Report by Zip By Town instead of this report (AAM | Paragraph 3 Zip/Town). It contains the same fields and a similar format to the Paragraph 3 by Zip report, but each Town of 25 within a Zip code is listed separately.

• If the business rule Do you allow digital addresses? is set to “yes” and a subscriber has no zip code, DIGITAL ADDRESS/UNKNOWN ZIP will be displayed in the CITY / ROUTE column.

• If creating an export file, you must have your AAM member number specified for the Business Rule— What is your AAM member number? (AAM section). You must also have AAM Publication Codes defined for your editions in Publication Edition setup (see Edition in the Setup Manual).

To produce the report:

• Select Paragraph 3 By Zip from the AAM menu to display the Paragraph 3 Report By Zip Code window.

  
• Click Add and complete the following fields.

  Field	Type	What to enter
  PRODUCT	setup	Enter the publication you are creating the report for (enter “*” to multi-select publications).
  START DATE END DATE	date	Enter the date range to cover in the report.
  PAID/QUALIFIED VERSION	yes/no	Indicate if you want to produce the paid/qualified version (e.g., the new version) of this report.
  PRINT BY EDITION	yes/no	Indicate whether to create a separate report for each edition of the publication(s).
  PRINT BY PRICE LEVEL	yes/no	If you keep AAM draw figures by price level, indicate whether draw for each Zip code should be broken out into price levels. See AAM Price Level in the Setup Manual for more information on price levels.
  PRINT DIGITAL NON-REPLICA DETAIL	yes/no	Indicate whether the detail for digital non-replica copies should be included in the report.
  CREATE EXPORT FILE	yes/no	Flag this field if the Paragraph 3 by ZIP Code report should be exported to a file. For example, you would use the export option if you are filing your AAM reports electronically. Create Export File will be active only if the start and end date entered are the same and the Paid/Qualified Version field is flagged. The file will be exported to the /dti/exchange/cm directory. See Appendix B for the file format.
  FILE NAME	open (30)	If exporting a file, enter the file name. Note that you can use the <P> and <p> tokens in the File Name field to include the product ID in the file name (in upper or lower case, respectively). If one of these tokens is used, multiple products will be exported to separate files. If one of these tokens is not used, the report will be exported to a single file, even if multiple products are selected.
  FILE OPTION	predefined	If exporting a file, indicate whether the file should append or replace the current file, if a file with the same name exists.

• Click OK and then Continue to process the report. The report lists the average daily draw figures by Zip (the total draw is divided by the date range and rounded).

Example—Paragraph 3 Report by Zip Code