Online Agent Subs not in your fulfillment system

For online agent subs, such as Amazon, Apple and Google, that are not maintained by your fulfillment system use the new source type Online Agent and include the name of the agent (Apple, Amazon, Google) in the source name so that the agent’s production upload will find the source for you.  The production uploads use .CSV files that are sent to you by the agent or that can be made by saving the Excel files sent by the agent as a .CSV file.

In the Publication Schedule enter the beginning of each sale period for online agents in the OA Prodn St Date column in the appropriate line.  In weekly models leave the column blank for all weeks that are included in the same production period.

When uploading production from Amazon, Apple and Google MPMW counts includes each sub in the paid sub count for each issue covered by the period from the start of the production period to the end of the term.  Free trials are not uploaded.  If the auditing agencies do something different than that we will change the upload appropriately.  Amazon only reports the purchaser payment so the upload will ask for a remit % to be applied to that payment.  There will be one line for each term and separate lines for cancels.  Cancels are uploaded as negative subs. Since Apple does not give the USD equivalent of foreign currency subs those subs are included in the paid sub count on separate lines with no income attached.

When re-initialising, if there are no pointers in the Curr. Inv. block for an Online Agent source all effort lines earlier than the New Business Cage Date will be included in the calculations rather than only those from the New Business Cage Date on.  Since these agents don’t sell subs longer than one year and, usually you do not include a renewal % for them, you need only include new business up to a year old.

Digital Subs sold in the same effort as print subs

In the past you may have used separate model sources for digital subs sold through your own mailings and you can continue to do so if you like but there is now another way to model them using a single model source.

In the Computations tab of Options/Options check Allow Editions (in the Computations section) and if you want to be able to report digital subs by source separately from print subs check Report by Edition by Source (in the Reporting section).  This will create an Editions block towards the top of your model.

In the Editions block enter a code and edition number for each edition (up to 9).  The edition number is used in report definitions (see below).   In the Curr. Inv. Blocks for subs sources enter the source code for each edition and the edition code in the following Edition Code column.  This is used in production uploads.  All sub terms in new business and renewal blocks also now have an Edition Code field.  You can use Edit/Change Edition Code to change all blank edition code fields to the most common edition code (usually the Print Edition code).  Just leave the From field blank and enter the code in the To field.

In report definitions when you want to report by edition by source use report factors

                                F6n3sssfff and F6n4sssfff

Where e is the edition number, sss is the source or renewal source number and ff is the factor number.