Wiki source code of 1. Overview

Version 14.1 by Admin User on 2026/07/30 14:23

Show last authors
1
2
3
4
5
6
7
8
9
10
11
12
13 ONEcount Fulfillment
14 How to Set Up a Magazine
15
16 Creating publications, reporting periods,
17 rate-base declarations, and your first issue
18
19 = 1. Overview =
20
21 Before you can run fulfillment reports, close issues, or generate mail files, you need to set up at least one magazine (publication) in the Fulfillment module. This guide walks through every step, from creating the publication record through building your first issue.
22
23 **The setup process has six steps:**
24
25 1. Create the Publication record (required).
26 1. Create Reporting Periods for the publication (required for RPT-11 Publisher's Statement and most audit reports).
27 1. Declare a Rate Base (required if your publication claims a guaranteed circulation).
28 1. Create your first Issue via the Issue Builder (required before running any issue-level reports).
29 1. Configure third-party integrations (AccuZip for address validation, optional but recommended).
30 1. Run the Setup Health check to verify everything is wired correctly.
31
32 Steps 1-3 are done under Fulfillment, then Setup. Step 4 is done under Fulfillment, then Issues. Steps 5-6 are back under Setup.
33
34 You need the fulfillment.setup permission to access the Setup pages. If you don't see the Setup menu item under Fulfillment, ask your administrator to grant this permission.
35
36 = 2. Before You Start =
37
38 **Before creating a publication, make sure:**
39
40 * The fulfillment schema has been applied to this silo. If you see a yellow warning banner on any Setup page saying a table hasn't been applied, contact your system administrator to run the fulfillment SQL scripts.
41 * You have a Magazine Resource (type 14) set up under Products with at least one term. This is the product definition that ties subscriptions to the magazine. If your magazine doesn't have a resource yet, create one under Products, then New Product (type: Magazine). When you select Magazine as the type, the form will show inline term fields ~-~- fill in the term title, format (e.g., Print, Digital Replica, Print + Digital), price, and duration. The resource and its terms are saved together in one step. You can add more terms later from the Terms section on the product edit page.
42 * If your publication will be audited by AAM (Alliance for Audited Media), you should have your demographic survey questions set up in the Form Builder. The publication setup form lets you link specific questions for RPT-05 cross-tabulation.
43
44 = 3. Step 1: Create the Publication =
45
46 == 3.1 Navigate to Publications ==
47
48 Go to Fulfillment, then Setup, then Publications. You will see the publications list. If this is a new installation, the list will be empty with a prompt to add your first publication.
49
50 [[image:fulfillment-magazine-setup-howto_a91724f79f10c70b.png||height="430" width="586"]]
51
52 == 3.2 Click Add Publication ==
53
54 Click the red Add Publication button in the upper right. The publication form opens with five sections: Identity, Classification, Subscriber Classes, Editorial, and Commercial.
55
56 [[image:fulfillment-magazine-setup-howto_2122b5f82f276fd0.png||height="637" width="586"]]
57
58 == 3.3 Fill in the Identity section ==
59
60 The Identity section at the top has four fields:
61
62 * Title (required) ~-~- The magazine name as it appears in all reports and throughout the module. Example: "Aviator's Guide".
63 * ISSN ~-~- The 9-digit International Standard Serial Number. Used by USPS Form 3526 (box 2). Leave blank if your publication doesn't have an ISSN.
64 * Publication number ~-~- Your organization's internal identifier for this title. Optional.
65 * Magazine Resource ~-~- Links this publication to an existing type-14 Magazine resource. This is how the fulfillment module knows which subscriptions (packages/terms) belong to this magazine. Reports query terms linked via the resource. Select your magazine resource from the dropdown. If your magazine resource isn't in the list, create it under Products first.
66
67 == 3.4 Demographic questions (AAM publications) ==
68
69 Below the Identity section are two demographic question pickers. These are optional for non-audited publications but important for AAM Business magazines:
70
71 * Business-type question ~-~- The demographic survey question that captures the subscriber's business type (e.g., "General Aviation", "Business Aviation"). This drives RPT-05 Para 3a.
72 * Job-function question ~-~- The demographic survey question that captures the subscriber's job function (e.g., "Private Pilot", "Flight Instructor"). This drives RPT-05 Para 3b.
73
74 Both pickers show only finite-response questions (Select, Radio, or Checkbox type) from your Form Builder. Text fields and textareas cannot be cross-tabulated and won't appear.
75
76 After saving the publication, you can return to the edit view and click Rank values next to each question. This opens a drag-and-drop modal where you prioritize the response values. When building an issue, subscribers with higher-ranked values are added first.
77
78 == 3.5 Fill in the Classification section ==
79
80 [[image:fulfillment-magazine-setup-howto_e7e28dc3ede18dd3.png||height="717" width="586"]]
81
82 The Classification section has four fields and three checkboxes:
83
84 * Type ~-~- "paid" (subscription revenue), "controlled" (free qualified circulation), or "mixed" (both paid and controlled subscribers). This affects how RPT-01 and RPT-02 break down circulation.
85 * Frequency ~-~- How often the magazine publishes: weekly, biweekly, monthly, bimonthly, quarterly, semiannual, annual, or irregular. RPT-02 uses this to compute the expected number of issues per reporting period.
86 * Audit bureau ~-~- "none" if not audited, "AAM_consumer" for AAM consumer magazines, or "AAM_business" for AAM business publications (Chapter D). This setting enables or disables audit-specific reports and fields throughout the module.
87 * Tax status ~-~- "for profit", "nonprofit", or "has changed in last 12 months". Used by USPS Form 3526 (box 12).
88
89 **Checkboxes:**
90
91 * Rate base claimed ~-~- Check this if your publication guarantees advertisers a minimum circulation. When checked, RPT-12 (Rate Base Compliance Dashboard) becomes active for this publication.
92 * Digital replica reported separately (RPT-01) ~-~- Check this if your digital edition should appear as a separate line on RPT-01 (Circulation by Issue) rather than being combined with print.
93 * Active ~-~- Uncheck to retire a publication without deleting it. Inactive publications don't appear in report wizards but their historical data is preserved.
94
95 == 3.6 Set the Subscriber Classes ==
96
97 [[image:fulfillment-magazine-setup-howto_26ea3325513300d4.png||height="717" width="586"]]
98
99 Subscriber classes tell the Issue Builder what subscriber statuses to use when building and managing issues. There are three pickers, each showing the subscriber status values configured for your silo:
100
101 * Receive class ~-~- The status assigned to subscribers who are actively receiving this publication. When the Issue Builder adds a subscriber to an issue, it sets their status to this value.
102 * Source class ~-~- The status pool that subscribers are drawn from when building an issue. These are your prospect or reserve subscribers who are eligible to receive the magazine but haven't been assigned to an issue yet.
103 * Removed class ~-~- The status assigned when a subscriber is removed from the active file. When a subscriber is dropped from an issue (e.g., expired, unqualified, moved), the Issue Builder sets their status to this value.
104
105 == 3.7 Fill in the Editorial section ==
106
107 [[image:fulfillment-magazine-setup-howto_ac0c25d462eb561b.png||height="717" width="586"]]
108
109 Four fields that appear on reports and official forms:
110
111 * Field served ~-~- A free-text description of the magazine's editorial focus area. Example: "General and business aviation for active pilots and aircraft owners." Used in AAM filings.
112 * Publisher ~-~- The name of the publisher.
113 * Editor ~-~- The name of the editor.
114 * Managing editor ~-~- The name of the managing editor.
115
116 == 3.8 Fill in the Commercial section ==
117
118 [[image:fulfillment-magazine-setup-howto_ac0c25d462eb561b.png||height="717" width="586"]]
119
120 Four fields used by mailing and audit reports:
121
122 * USPS permit # ~-~- Your USPS mailing permit number for this publication. Used by RPT-19 (Label / Mail File) and USPS Form 3526.
123 * Office of publication ZIP ~-~- The 5-digit ZIP code of the magazine's office of publication. RPT-10 (USPS Form 3526) uses this to determine in-county vs. outside-county circulation (items 15b(1) and 15b(2)). You can enter a ZIP+4; the system normalizes to the leading 5 digits.
124 * Annual price ($) ~-~- The annual subscription price in dollars. Used by RPT-03 (Average Subscription Price) and USPS Form 3526 (box 6).
125 * Nonqualified cap ~(%) ~-~- The threshold for nonqualified circulation. RPT-15 shows a warning when nonqualified share exceeds this percentage. Default is 0.50%.
126 * ACS digital conversion ~-~- When checked, the ACS Import tool defaults to converting nixie-returned subscribers to digital delivery instead of killing them, provided the subscriber has an email address on file. If unchecked, all ACS returns default to kills. The operator can override either default on a per-record basis during the import preview.
127
128 == 3.9 Save ==
129
130 Click Create publication. The system creates a row in fulfillment_publication and redirects you to the publications list. Your new publication now appears in every report wizard's publication picker.
131
132 = 4. Step 2: Create Reporting Periods =
133
134 A reporting period defines an audit window ~-~- typically a half-year (H1 or H2) for AAM publications. RPT-11 (Publisher's Statement) and several other reports anchor to a reporting period. You need at least one reporting period before you can close an issue.
135
136 == 4.1 Navigate to Reporting Periods ==
137
138 Go to Fulfillment, then Setup, then Reporting Periods.
139
140 [[image:fulfillment-magazine-setup-howto_5689c5fef37b9860.png||height="430" width="586"]]
141
142 == 4.2 Click Add Period ==
143
144 Click the red Add Period button. The form has five fields:
145
146 [[image:fulfillment-magazine-setup-howto_c09f0eac71911509.png||height="430" width="586"]]
147
148 * Publication (required) ~-~- Select the publication this period applies to.
149 * Period start (required) ~-~- The start date of the reporting window in YYYY-MM-DD format. For an H1 period, this would be January 1 (e.g., 2026-01-01).
150 * Period end (required) ~-~- The end date. For H1, this would be June 30 (e.g., 2026-06-30).
151 * Audit bureau ~-~- Defaults to the publication's audit bureau but can be overridden per period.
152 * Status ~-~- Defaults to "open" (accepting issues and activity). Set to "closing" when you're ready to prepare the Publisher's Statement. The "filed" status is set automatically by RPT-11 when the statement is finalized ~-~- you cannot set it manually.
153
154 == 4.3 Status lifecycle ==
155
156 Reporting periods move through three statuses:
157
158 1. open ~-~- The period is active. You can create issues, run reports, and make changes.
159 1. closing ~-~- You've decided to finalize the period. RPT-11 (Publisher's Statement) will only finalize when the period is in this state.
160 1. filed ~-~- RPT-11 has been finalized. The period is locked. No edits are allowed from this page. Reopening requires both the fulfillment.setup and fulfillment.statement_file permissions.
161
162 == 4.4 Typical setup ==
163
164 Most publications need two periods per year. For a monthly magazine audited by AAM, create:
165
166 * H1 2026: January 1, 2026 through June 30, 2026
167 * H2 2026: July 1, 2026 through December 31, 2026
168
169 Issues whose issue dates fall within a period are automatically associated with it.
170
171 = 5. Step 3: Declare a Rate Base =
172
173 If your publication guarantees advertisers a minimum circulation (a "rate base"), you declare it here. RPT-12 (Rate Base Compliance Dashboard) reads this to monitor whether your actual average circulation meets the commitment. Skip this step if your publication does not claim a rate base.
174
175 == 5.1 Navigate to Rate Base ==
176
177 Go to Fulfillment, then Setup, then Rate Base.
178
179 [[image:fulfillment-magazine-setup-howto_da08df28496b3b7d.png||height="430" width="586"]]
180
181 == 5.2 Click Add Declaration ==
182
183 Click the red Add Declaration button. The form has five fields:
184
185 [[image:fulfillment-magazine-setup-howto_4f730d0fbffa394a.png||height="430" width="586"]]
186
187 * Publication (required) ~-~- Select the publication.
188 * Effective start (required) ~-~- The date this rate base takes effect. Usually aligned with a reporting period start.
189 * Effective end ~-~- The date it expires. Leave blank for open-ended (the declaration stays active until a new one is created).
190 * Rate base (required) ~-~- The number of qualified copies promised per issue. Example: 50,000.
191 * Alert threshold ~(%) ~-~- RPT-12 fires a warning when your actual average circulation falls below this percentage of the declared rate base. Default is 5%.
192
193 = 6. Step 4: Create Your First Issue =
194
195 An issue represents a single mailing of the magazine. It ties together the subscriber list (who gets this issue), the mail date, and the reporting period. You create issues through the Issue Builder.
196
197 == 6.1 Navigate to Issues ==
198
199 Go to Fulfillment, then Issues. The issues list shows all issues across publications with their status, dates, and subscriber counts.
200
201 [[image:fulfillment-magazine-setup-howto_d5f3829912064a53.png||height="430" width="586"]]
202
203 == 6.2 Open the Issue Builder ==
204
205 Click Create Issue to open the Issue Builder. The Issue Builder lets you compose an issue from one or more subscriber sources (saved queries or saved lists).
206
207 [[image:fulfillment-magazine-setup-howto_406f00e5e5036819.png||height="544" width="586"]]
208
209 == 6.3 Set the issue metadata ==
210
211 At the top of the Issue Builder, set:
212
213 * Publication ~-~- The magazine this issue belongs to.
214 * Issue date ~-~- The cover date of the issue (YYYY-MM-DD). This determines which reporting period the issue falls into.
215 * Mail date ~-~- The planned mail date (YYYY-MM-DD). Used for CASS/NCOA recency checks at RPT-19.
216 * Reporting period ~-~- Auto-selected based on the issue date. If the issue date falls within a defined reporting period, it's linked automatically.
217
218 == 6.4 Add subscriber sources ==
219
220 Click Add Source to add subscriber rows to the issue. Each source can be:
221
222 * A saved query from the List Wizard ~-~- The query runs at issue build time and pulls the current matching subscribers. Print and digital counts are auto-classified from term format. You can adjust counts with +/- buttons and set an aging preference (newest or oldest first).
223 * A saved list ~-~- A frozen snapshot of subscriber OCIDs. Use this when you want an exact, pre-determined set of recipients. Counts are auto-classified but fixed (no +/- adjustment).
224 * Other ~-~- A manual entry for counts that don't come from a query or list. Enter a label (e.g., "bulk subs", "advertiser copies", "sponsored") and type the print and digital numbers directly. Use this for non-subscriber circulation components.
225
226 The Issue Builder auto-classifies query and list source rows into Print and Digital columns based on the product format. Other source rows have their counts entered directly. All source types contribute to the running subtotals and total circulation at the bottom of the table.
227
228 == 6.5 Preview and save ==
229
230 1. Click Preview 3B to see the live RPT-05 Para 3B cross-tab ~-~- a sanity check showing the demographic breakdown of the issue audience.
231 1. Click Save Issue to merge all sources into a composite saved list and create the issue record.
232 1. The issue status is set to "open" and appears on the Issues list.
233
234 == 6.6 Issue lifecycle ==
235
236 After creation, an issue moves through four statuses:
237
238 1. planned ~-~- Placeholder issue, not yet populated with subscribers.
239 1. open ~-~- Active issue with a subscriber list attached. Ready for reports.
240 1. locked ~-~- RPT-13 (Issue Close Preliminary) has been run, locking the subscriber file.
241 1. finalized ~-~- RPT-19 (Label / Mail File) has been generated and the serve log written to Cassandra. The issue is complete.
242
243 = 7. Step 5: Configure Integrations (Optional) =
244
245 The Integrations page lets you connect third-party services. The most important integration is AccuZip for address validation.
246
247 [[image:fulfillment-magazine-setup-howto_fc53ea54fe17f70.png||height="430" width="586"]]
248
249 == 7.1 AccuZip ==
250
251 AccuZip provides CASS certification, NCOALink change-of-address processing, and postal presorting. When configured, RPT-19 automatically validates your subscriber addresses through AccuZip before generating the mail file.
252
253 1. Navigate to Fulfillment, then Setup, then System Integrations.
254 1. In the AccuZip card, enter your API key (GUID format) and click Save Key.
255 1. Click Test Connection to verify. The page shows your account type, services enabled, and credits remaining.
256
257 For a detailed AccuZip setup walkthrough, see the separate How-To guide: fulfillment-accuzip-howto.docx.
258
259 = 8. Step 6: Run the Setup Health Check =
260
261 After completing your setup, run the health check to make sure everything is wired correctly.
262
263 == 8.1 Navigate to Setup Health ==
264
265 Go to Fulfillment, then Setup, then Setup Health.
266
267 [[image:fulfillment-magazine-setup-howto_c49bbf68761179b0.png||height="434" width="586"]]
268
269 == 8.2 What it checks ==
270
271 * All required fulfillment tables exist in the database.
272 * Each publication is linked to a valid Magazine Resource.
273 * Term format coverage ~-~- the publication's resource has terms covering print, digital, or both, as expected.
274 * Reporting periods are defined and current.
275 * No orphaned configuration (e.g., a rate base pointing to a deleted publication).
276
277 If any issues are found, the health check shows one-click fix buttons where possible. Address any warnings before proceeding with your first issue close.
278
279 = 9. What to Do Next =
280
281 With your magazine set up, you're ready to use the fulfillment reports. Here are the typical next steps:
282
283 * Run RPT-13 (Issue Close Preliminary) to lock an issue's subscriber file. See the Issue Close How-To guide for the full workflow.
284 * Run RPT-19 (Label / Mail File) to generate the printer-ready label file. If AccuZip is configured, this step also validates addresses.
285 * Run RPT-01 (Circulation by Issue) to see the circulation breakdown for a closed issue.
286 * At the end of a reporting period, set the period status to "closing" and run RPT-11 (Publisher's Statement) to generate the audit filing.
287
288 == 9.1 Related guides ==
289
290 * Fulfillment Module End-User Guide ~-~- comprehensive reference for all 20 reports. See docs/fulfillment/user-guide/.
291 * Issue Close How-To ~-~- end-to-end issue close workflow from saved list through mail file. See docs/fulfillment/howto-issue-close/.
292 * AccuZip How-To ~-~- AccuZip address validation setup and usage. See docs/fulfillment/howto-accuzip/.
293 * AAM Filing How-To ~-~- how to file your Publisher's Statement with AAM. See docs/fulfillment/howto-aam-filing/.
294 * USPS Form 3526 How-To ~-~- annual USPS Statement of Ownership filing. See docs/fulfillment/howto-usps-3526/.
295 * System Administration Guide ~-~- permissions, configuration, and maintenance. See docs/fulfillment/system-admin/.
296
297 = Appendix: Quick Reference =
298
299 == A.1 Publication fields at a glance ==
300
301 **Required fields:**
302
303 * Title
304
305 **Recommended fields:**
306
307 * Magazine Resource (links subscriptions to this publication)
308 * Type (paid, controlled, or mixed)
309 * Frequency (monthly, quarterly, etc.)
310 * Audit bureau (none, AAM_consumer, or AAM_business)
311 * Subscriber classes (receive, source, removed)
312
313 **Optional fields:**
314
315 * ISSN, Publication number
316 * Business-type question, Job-function question (AAM only)
317 * Tax status
318 * Rate base claimed, Digital replica reported separately
319 * Field served, Publisher, Editor, Managing editor
320 * USPS permit #, Office of publication ZIP
321 * Annual subscription price, Nonqualified cap %
322
323 == A.2 Permissions required ==
324
325 * fulfillment.setup ~-~- Access all Setup pages (Publications, Reporting Periods, Rate Base, Integrations, Health).
326 * fulfillment.view ~-~- See the Fulfillment menu and view reports.
327 * fulfillment.run ~-~- Launch and complete reports.
328 * fulfillment.close_issue ~-~- Authorize RPT-13 issue close.
329 * fulfillment.statement_file ~-~- Finalize RPT-11 Publisher's Statement.
330
331 == A.3 Setup page locations ==
332
333 * Fulfillment > Setup > Publications ~-~- create and manage magazine records.
334 * Fulfillment > Setup > Reporting Periods ~-~- define audit windows.
335 * Fulfillment > Setup > Rate Base ~-~- declare guaranteed circulation.
336 * Fulfillment > Setup > System Integrations ~-~- AccuZip, AAM, USPS credentials.
337 * Fulfillment > Setup > Setup Health ~-~- verify configuration.
338 * Fulfillment > Issues ~-~- create and manage issues via Issue Builder.