Document toolboxDocument toolbox

ADV User Guides Subscriptions

This article serves as a reference page and will provide information to better understand subscriptions in Advantage.

16 min read

Note
This is a review of CIR, or subscription, type orders.  Note that some field names and locations may vary slightly based on individual scripts used at Customer Activity.


Table of Contents


Subscription Information

 

Circulation Status

The current status of the subscription.

  • B = Billing Suspend, credit card declined

  • C = Customer Requested Cancellation

  • E = Expired

  • G = Gracing this status status allows Advantage to fulfill the customer and recoups the sent issues when the renewal has taken place by decreasing the new term with number of grace issues sent. 

  • N = Non-Pay Cancel, card declined and invoice has been closed due to non-payment. This generally occurs 45-90 days after a billing suspension is done.

  • P = Perpetual, lifetime complimentary

  • R = Regular, Receiving (Active) Subscription

  • S = Indefinite Suspension

  • T = Temporary Suspension

  • U = Undeliverable

  • W = Future Start

  • X = Folded Subscription, no longer active

Billing Status

The current billing status of the subscription.

  • A = On Approval

  • B = Billed

  • C = Complimentary

  • M = Cancellation Credit Memo

  • P = Paid Up

  • R = Reinstated Subscription

Subscription Type

Used for offers that include multiple levels to identify levels of a subscription. For example, if a subscription can be lifetime or not, it may be blank for regular subscribers but LIFE for lifetime customers. This is often used by affiliates to grant or restrict content on websites.

Membership Organization

Used for subscriptions that are part of a membership to identify the organization they are a part of.

Membership Category

Used for subscriptions that are part of a membership to identify the category they are a part of. 

Duplicate Subscription Ref

Populated when a customer has 2 concurrent subscriptions running under the same customer number. These are a result of duplicate account consolidations where the customer had 2 of the same subscriptions on 2 different accounts that have since been consolidated.

Promotion Code

Promotion code used for the selected term of the subscription. Codes starting with an A are associated with a term that was created automatically through an auto-renewal.

Current Term Issues To Go

Number of issues left in the current term

Total Issues To Go

Number of issues left total for the subscription including advanced early renewals. 

Rate

Price of the subscription.

Billing Currency

Currency the rate is associated with.

Term Length

Number of issues the customer will receive for the term.

Customer purchase order

The order number a customer sees on their confirmation of an order placed online via the Opium E-Commerce system. Note that web orders that are associated with affiliate shopping carts may not be populated.

Renewal Flag

Determines how the subscription will be renewed.

  • D = Discontinue Auto-Renewal, customer was on auto-renew and cancelled

  • Z = Abbreviated Renewal, customer was a Y flag but requested to stop receiving special renewal notices

  • N = No – Do not renew, customer will not receive renewal notices

  • A = Automatic Renewal, automatically renews with no charge for lifetime subscriptions

  • C =  Automatic Renewal with Auto-Charge, auto renews and charges credit card on file

  • Y = Subscribers receive renewal offers, will not automatically renew

Final Expiration Date

Date of last issue for the subscription including advanced early renewals.

Remaining Liability

Calculation of the number of issues to go for the term / rate of the term. This is used in determining the amount of a refund, however it does not reflect the refund policy.

Promotion Choice

The choice selected with the promotion code for the term.

Credit Policy Code

A credit policy which defines how credits are created when a sub is cancelled.

Original Sales Rep

The salesperson getting credit for orders from this customer.

Sales Rep

The Sales Rep associated with the subscription order.

Last Modified Order Number

The current order number associated with the subscription. Note that if the customer placed an order and then had a modification done on the subscription, this number would reflect the order number for the last modification performed.

Delivery Code

How the subscription is being sent to the customer

  • ML = Mail

  • ME = Mail and Email

  • EM = Email

  • FX = Fax                                               

  • EF = Email and Fax

  • WB = Web Online Delivery

  • PO = Mail (Used by London Affiliates)

  • PE = Mail and Email (Used by London Affiliates)

Last Issue Sent

Date of issue the customer last was pulled to receive.

Current Term Start

Date of first issue for the current selected term.

Current Term Expires

Date of last issue for the current term.

First Issue Sent

Date of first issue ever sent to the customer including previous terms.

Term Number

Number associated with the amount of times a customer has renewed/ordered a subscription. For example, the first time the customer orders, the Term Number is 1. When the term renews, that new term is term 2.

Times Renewed

The number of times the customer has renewed their subscription.


Additional Subscription Information

 

Original Order Number

Order number associated with the selected term for when the order was created.

Original Control Group Date

Date of the control group from the original order.

Original Control Group

ID of the control group from the original order.

  • O = Online

  • C or T = Customer Service & Telesales

  • M = Mail

  • A, Z = System created

Last Modified Order Number

Order number associated with the last modification performed for the subscription. If no modifications have been performed, the last modified order number and original order number will be the same.

Last Modified Control Group Date

Date of the control group associated with the last modification performed for the subscription. If no modifications have been performed, the last modified order control group date and original control group date will be the same.

Number of Decline Notifications

The number of notifications sent to the customer about a declined credit card payment.

Last Decline Notice Sent

The date of the last notification sent to the customer about a declined credit card payment.

Order Source

Source associated with orders that come in from outside of Advantage directly. These are orders that are processed through Order Stream.

Payment Type

The type of payment used for the order. Generally this is Credit Card or Check.

Cancel Reason

Used to identify the reason for a subscription cancellation. This will only show a value if the subscription is a Cancelled status.

Number of Renewal Reminders

The number of renewal reminders that have been sent to a customer. For a customer not on auto-renew, this would show the regular renewal series information for how many renewal reminders have been sent. For a customer on auto-renew, this would show the number of reminders sent about the upcoming automatic charge, generally 1.

Last Renewal Effort Sent

The date the last renewal effort was sent to the customer.

Advance Renewals

Number of renewals on the subscription that have not been fulfill.

Last Renewal Promo Code

The promotion code associated with the last renewal reminder sent to the customer.

Auto Renew Chain

Used for when a subscription is ordered with an auto renew chain associated with the promotion code. When available, this will show up as a hyperlink that you can click on for more details on what the chain is.

Chain Sequence

Associated with the Auto Renew Chain. This is the sequence the customer is on for the selected term.

Installment Billing Code

Used for when a subscription is ordered with an installment bill code associated with either the promotion code or used at payment screen.

Package Number

The Package Number identifies a group of items.

Package Group ID

The Package ID field is a last number that is used to group package components of a publication set.


Bill-to / Ship-to

 

Note
When searching for an account at Customer Activity, you are by default searching by the bill-to customer.  This means that if the customer has different account numbers associated with their bill-to and ship-to, the subscription will only show up in Customer Activity if you are looking at the bill-to customer.  Nothing for that subscription will display under the ship-to account number. You can change this search by selecting Receiving Customer as your Search By.


Website Login

 

Authentication ID

Unique identifier of the login.

Auth Group Description

The authentication group associated with the subscription's login. Some affiliates have one auth group for their site, while others have multiple auth groups setup based on their infrastructure of their website.

Auth Type

Displays the field to determine where the username/password will be displayed:

The username is listed under the Authentication Value field.

Auth Type Description

Description field related to the Authentication Type field. Denotes whether it is a customer's email address or a authentication value as the username.

Authentication Value

If the Auth Type is L, this is the username for the website login.

Email Address

If the Auth Type is E, this is the username for the website login.

Record Status

The status of the login.

  • A = Active

  • I = Inactive

Last Login

Shows the date and time of the last login the customer did on the website.

Last Updated

Shows the last date the information was edited.

Last Updated By Description

Displays the name/identity of the last user to update the login record.


Auto-Charge Information


Invoices / Payments


Email Addresses


Email Sent History


Order Transaction History


Previous Terms


Renewal Future Terms


Fulfillment History


Welcome Package Premium


Suspensions


Original Order Lines


Subscription Maintenance



Related Content

FAQs - Change Customer Account Information in Advantage

Read this guide

FAQs - Cancel a Subscription

Read this guide


Level up with a Masterclass

Advantage Customer Service: Account Maintenance

Get started!

Advantage Customer Service: Orientation

Get started!


com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.