The export format for the Paragraph 3 by ZIP report is given below. This is the standard AAM electronic filing format.
One record is be exported for each ZIP Code with over 25 copies. ZIP Codes with under 25 copies are combined into a miscellaneous record by state (one record per state). The ZIP Code “99999” is exported for all miscellaneous records.
File type: Comma-delimited.
Location: /dti/exchange/cm. The file name is specified at run time.
Member #
1
Number
6
AAM Member # from the Business Rules.
Pub Code
2
Character
10
Publication code for main and branded editions (from Publication Edition setup).
Para3date
3
Date
6
Date of Para 3 Circulation, MMDDYY
Zip code
4
Number
5
Zip code (99999, if a miscellaneous record)
HD_Print
5
Number
8
Home delivery and mail print circulation
SC_ Print
6
Number
8
Single copy print circulation
BT_Print
7
Number
8
Business traveler print circulation (AAM column with a Paid/Verified Type of “Business/Traveler”)
Verified_Print
8
Number
8
Verified print circulation
Paid_DigRep
9
Number
8
All paid digital replica circulation
Verified_DigRep
10
Number
8
Verified digital replica circulation
Paid_DigNRep
11
Number
8
All paid, digital non-replica circulation
Verified_DigNRep
12
Number
8
Verified digital non-replica circulation
State Name
13
Text
25
State Name. Only for miscellaneous data rows.