Search the Omeda Knowledge Base

< All Topics
Print

Audience Builder – Product Field Library

Activation Date – This date field tracks the date a controlled magazine record or newsletter record becomes active.

Active Version – This field tracks what version the customer is currently receiving (may be different from what they originally requested):
– Print
– Digital
– Digital Only
– Both
– Blank

Audited Demo Verification Date 1yr/2yr/3yr – This is preset rollup that pulls in customer records who have an audited demographic verification date within 1 year, 2 years or 3 years

Batch Tracking Code – Unique identifier that allows us to pull the current batch (group) of records that were uploaded together from a file, webpage, etc. (e.g. OWS203301231501301922, DLR30222017112654)

Previous Batch Tracking Code – This field stores previous batch tracking codes on a customer’s product record.

BPA Type (required for all magazine records): Record categories that are necessary for BPA audit statements. Will be automatically assigned to records based on the input. On the first page of your audience report, Classes 1 and 2 will be broken out by BPA types.

  • ADV + Agency
  • Award Point
  • Gift
  • Individual
  • Membership/Association Benefit
  • Non-Qual Multi-Copy Same Address
  • Paid
  • Qual Multi-Copy Same Address
  • ROT or OCCAS
  • Samples
  • Seed
  • Single Copy Sales
  • Sponsored Individual Addressed
  • All Other

Class: These are the different categories that your product records will be part of. All customers can have only one class per product.

  • (1) Active Qualified – Records receiving the magazine and are qualified
  • (2) Active Non-Qualified – Records receiving the magazine that are non-qualified, typically non-qualified paid or comps
  • (3) Qualified Reserve – These are non-paid records that meet the qualification criteria and are waiting to be activated
  • (8) Soft Controlled Kills – These are issue deletes (perhaps they were too old or they can’t receive the issue for some reason (for example: US only for print and they are outside the US and they don’t have a valid email or they opted out of the digital edition)
  • (9) Controlled Kills – Hard deletes that can be deactivated if there are no other active products
  • (10) ACS Kills – Non-paid postal returns
  • (20) Expire Suspends – Paid records that did not renew
  • (21) Future Starts – Paid records that will be activated with a future issue
  • (22) Postal Suspends – Paid postal returns
  • (23) Credit Suspends – Bill me’s that did not pay
  • (24) Requested Suspends – Paid records that requested to stop receiving the magazine
  • (25) Kill/Refunds – Paid kills/refunds
  • (26) Non-Receiving Group Admin. – Group admins that are not receiving the magazine
  • (27) Non-Receiving Earning Admin. – Earning admins that are not receiving the magazine
  • (50) Passalong – Non-paid records a host has asked to receive the magazine (i.e. company request typically in the form of ‘Do you have any colleagues at your location that would be interested in receiving XYZ Magazine’ – address as well as company specific demos are copied from the host.)

Current Date – This is a rolling date field that groups records based on their verification date. This allows you to easily pull in customers who came onto the product 3 months ago, 6 months ago, 2 years ago, etc. This can be used instead of having a flex date range in ‘Verification Date’.

Deactivation Date – The Date field tracks the date an active controlled magazine or newsletter record is deactivated.

First Order Date – This date field will display when the customer subscribed to a specific product.

How Addressed – This will categorize how customer labels are addressed for print magazines.

  • Ind Cust by name,title,function
  • Ind Cust by name only
  • Title and/or function
  • Company name only
  • Multi-copy same address
  • Single copy sales
  • Blank

Last Issue Received – This field tracks the issue number of the most-recently-received. This gets populated when the final issue close process is run.
Note: The issue number is overwritten with each issue served, so only the most recent issue served to the customer will be returned.

Nixie Count – The number of postal nixies we have on file for a customer

Payment Status– Used to determine the current status of their payment

  • Paid on Invoice- Customer Paid after being invoiced
  • Paid with Order- Customer paid at the time of their order
  • Credit – Customer owes an outstanding balance on the subscription
  • Grace – Customer subscription is in grace
  • Free – Customer is being granted a free subscription, but isn’t necessarily qualified by the publisher
  • Controlled – Customer was selected by the publisher to receive subscription for free
  • Free Term – Customer was granted a paid subscription at no cost, but they have an expire date (formerly known as a comp)

Promo Code – Open Text field that stores the current campaign/source code that is on file for the current subscription.

Previous Promo Code – Open text field that stores all previous codes that were associated with customers for the product.

Renewal Count – The number of times a customer has renewed

Remaining Copies – The number of copies a customer has left before their expire/renewal date. Note: This will be the same count as their remaining issues unless this is a multi-copy order.

Remaining Issues – The number of issues a customer has left before their expire/renewal date

Requested Version – This field stores the product version the customer originally asked for:

  • Print
  • Digital
  • Digital Only
  • Both
  • Blank

Rollup Expire Date – This date field rolls up all of a record’s orders for a specific product, both active and pending, to show when the record will next expire and need to be renewed.

Source (required for all records loaded into the system) – A pre-defined list of BPA sources that define where a record comes from and categorizes it accordingly. Note: This source list cannot be edited or customized.

  • 0 – Undefined Source
  • 10 – Communication other Request – Written
  • 11 – Communication other Request – Telecom
  • 12 – Communication other Request – Internet/Electronic
  • 15 – Request from Company – Written
  • 16 – Request from Company – Telecom
  • 17 – Request from Company – Internet/Electronic
  • 20 – Direct Request – Written
  • 21 – Direct Request – Telecom
  • 22 – Direct Request – Agency
  • 23 – Direct Request – Internet/Electronic
  • 30 – Sources Other – Independent Field Reports
  • 40 – Sources Other – Association Rosters
  • 41 – Association/Society Membership – Independent
  • 42 – Association/Society Membership –Organization
  • 50 – Sources Other – Manufacturer Distributor List
  • 60 – Sources Other – Licenses/Government
  • 70 – Sources Other – Business Directory
  • 80 – Sources Other – Lists
  • 91 – Sources Other – Other

Term – Used to query the how many issues an order has

Verification Date – This date field will display when the customer subscribed/renewed to a specific product. It will always display the most recent date a customer came onto the product.

Verification Date 1yr/2yr/3yr – This is preset rollup that pulls in customer records who have a verification date within 1 year, 2 years or 3 years.

Paid Product Fields (LIVE)

These fields are specific for paid products and will only be configured into your database when there is a paid product available.

Amount– The amount a subscriber paid on their order

Batch#– is the unique number given to paid orders keyed manually by the paid dep

Bulk– is selecting the quantity records with the specific bulk (multiple copies) count

CC Expiration Date– pulls the records with a credit Card that expires in the queried date/ranges. Format is MMYY, where YY is the last two digital of the expired Credit card year

Credit Balance– used to query the balances of credit records

Date Entered– This date field is the date the order was entered into the database

Delivery Code– Code used to identify the method the order is delivered

Donor Id– The customer ID of the Donor record who donated a subscription to another

Earned Balance– Used to query the amount of money earned for specific orders

Earned Copies– Used to query the number of copies earned for specific orders

Earned Issues- Used to query the number of issues earned for specific orders

Expected Expire– This date field is the date a record’s current active order is expected to expire. This field doesn’t include any pending orders

Fee Amount- Used to query the amount of fees paid for specific orders

Gift Notice Sent– Date when a gift notification was sent to the gift subscription recipient

Gift Sub Code– Used to query if an order is a gift or not

Grace Issues– Used to query the number of grace issues given to subscribers

Group Active Count– Used to query the number of groups active for a product

Group Admin– The customer IDs of the Group Admin records who pay for the groups’ order

Group Code– The list of group codes for all groups to be queried

Number of Installments– Numeric field that returns the number of installment payments for an order

P&H- Used to query the amount of Postage and Handling paid for specific orders

Payment Status– Used to determine the current status of their payment

  • Paid on Invoice- Customer Paid after being invoiced
  • Paid with Order- Customer paid at the time of their order
  • Credit – Customer owes an outstanding balance on the subscription
  • Grace – Customer subscription is in grace
  • Free – Customer is being granted a free subscription, but isn’t necessarily qualified by the publisher
  • Controlled – Customer was selected by the publisher to receive subscription for free
  • Free Term – Customer was granted a paid subscription at no cost, but they have an expire date (formerly known as a comp)

Payment Type– Used to determine the order’s method of payment (Ex: cash, Credit Card, Wire Transfer)

PO Number– Used to query the PO number attached to a specific order

Premium Code – This field is used to query codes for items or offers used to entice an individual to purchase a magazine.

Premium Sent– Used to query the date a premium subscription was sent

Price Per Copy– The amount paid for each copy of the magazine

Price Per Issue– The amount paid for each issue on a subscriber’s order. (EX: A $12 subscription order with a term of 12 will have a price per issue of $1) 

Promocode– field used to query specific promo codes for paid records

Receive Notices– Used to determine if a subscriber receives invoice or renewal notices

Remaining Dollars – The dollar amount still left to be earned on a customer record

Remaining Liability– The remaining amount of money owed on an order and would be the current refund amount.

Renewal Code– Code used to show if a subscriber will receive an invoice, autorenewal notice, or no renewal notices upon expiration

Sales Channel– The sales channel used for the order

Sales Tax– Used to query the amount of Sales Tax paid for specific orders

Shipping Same as Billing Address– Used to confirm if shipping and billing addresses are the same or different for an order

SKU– Used to query SKU attached to an order

Source– Used to query the source of the Order

Start issue– used to find the issue an order started their subscription with

Status– The current status of the order, which may be any one of the following:

  • Active – Order is Actively receiving the issues
  • Pending – Order is on hold until the active order is fulfilled and expires
  • Expired – Order has been fulfilled and earned all its money so it is inactive
  • Canceled – Order has been ended before earning out and is inactive
  • Graced – Order has been earned out, but receiving a limited number of “free” issues.

Activation Date – This date field tracks the date a controlled magazine record or newsletter record becomes active.

Active Version – This field tracks what version the customer is currently receiving (may be different from what they originally requested):
– Print
– Digital
– Digital Only
– Both
– Blank

Audited Demo Verification Date 1yr/2yr/3yr – This is preset rollup that pulls in customer records who have an audited demographic verification date within 1 year, 2 years or 3 years

Batch Tracking Code – Unique identifier that allows us to pull the current batch (group) of records that were uploaded together from a file, webpage, etc. (e.g. OWS203301231501301922, DLR30222017112654)

Previous Batch Tracking Code – This field stores previous batch tracking codes on a customer’s product record.

BPA Type (required for all magazine records): Record categories that are necessary for BPA audit statements. Will be automatically assigned to records based on the input. On the first page of your audience report, Classes 1 and 2 will be broken out by BPA types.

  • ADV + Agency
  • Award Point
  • Gift
  • Individual
  • Membership/Association Benefit
  • Non-Qual Multi-Copy Same Address
  • Paid
  • Qual Multi-Copy Same Address
  • ROT or OCCAS
  • Samples
  • Seed
  • Single Copy Sales
  • Sponsored Individual Addressed
  • All Other

Class: These are the different categories that your product records will be part of. All customers can have only one class per product.

  • (1) Active Qualified – Records receiving the magazine and are qualified
  • (2) Active Non-Qualified – Records receiving the magazine that are non-qualified, typically non-qualified paid or comps
  • (3) Qualified Reserve – These are non-paid records that meet the qualification criteria and are waiting to be activated
  • (8) Soft Controlled Kills – These are issue deletes (perhaps they were too old or they can’t receive the issue for some reason (for example: US only for print and they are outside the US and they don’t have a valid email or they opted out of the digital edition)
  • (9) Controlled Kills – Hard deletes that can be deactivated if there are no other active products
  • (10) ACS Kills – Non-paid postal returns
  • (20) Expire Suspends – Paid records that did not renew
  • (21) Future Starts – Paid records that will be activated with a future issue
  • (22) Postal Suspends – Paid postal returns
  • (23) Credit Suspends – Bill me’s that did not pay
  • (24) Requested Suspends – Paid records that requested to stop receiving the magazine
  • (25) Kill/Refunds – Paid kills/refunds
  • (26) Non-Receiving Group Admin. – Group admins that are not receiving the magazine
  • (27) Non-Receiving Earning Admin. – Earning admins that are not receiving the magazine
  • (50) Passalong – Non-paid records a host has asked to receive the magazine (i.e. company request typically in the form of ‘Do you have any colleagues at your location that would be interested in receiving XYZ Magazine’ – address as well as company specific demos are copied from the host.)

Current Date – This is a rolling date field that groups records based on their verification date. This allows you to easily pull in customers who came onto the product 3 months ago, 6 months ago, 2 years ago, etc. This can be used instead of having a flex date range in ‘Verification Date’.

Deactivation Date – The Date field tracks the date an active controlled magazine or newsletter record is deactivated.

First Order Date – This date field will display when the customer subscribed to a specific product.

How Addressed – This will categorize how customer labels are addressed for print magazines.

  • Ind Cust by name,title,function
  • Ind Cust by name only
  • Title and/or function
  • Company name only
  • Multi-copy same address
  • Single copy sales
  • Blank

Last Issue Received – This field tracks the issue number of the most-recently-received. This gets populated when the final issue close process is run.
Note: The issue number is overwritten with each issue served, so only the most recent issue served to the customer will be returned.

Nixie Count – The number of postal nixies we have on file for a customer

Payment Status– Used to determine the current status of their payment

  • Paid on Invoice- Customer Paid after being invoiced
  • Paid with Order- Customer paid at the time of their order
  • Credit – Customer owes an outstanding balance on the subscription
  • Grace – Customer subscription is in grace
  • Free – Customer is being granted a free subscription, but isn’t necessarily qualified by the publisher
  • Controlled – Customer was selected by the publisher to receive subscription for free
  • Free Term – Customer was granted a paid subscription at no cost, but they have an expire date (formerly known as a comp)

Promo Code – Open Text field that stores the current campaign/source code that is on file for the current subscription.

Previous Promo Code – Open text field that stores all previous codes that were associated with customers for the product.

Renewal Count – The number of times a customer has renewed

Remaining Copies – The number of copies a customer has left before their expire/renewal date. Note: This will be the same count as their remaining issues unless this is a multi-copy order.

Remaining Issues – The number of issues a customer has left before their expire/renewal date

Requested Version – This field stores the product version the customer originally asked for:

  • Print
  • Digital
  • Digital Only
  • Both
  • Blank

Rollup Expire Date – This date field rolls up all of a record’s orders for a specific product, both active and pending, to show when the record will next expire and need to be renewed.

Source (required for all records loaded into the system) – A pre-defined list of BPA sources that define where a record comes from and categorizes it accordingly. Note: This source list cannot be edited or customized.

  • 0 – Undefined Source
  • 10 – Communication other Request – Written
  • 11 – Communication other Request – Telecom
  • 12 – Communication other Request – Internet/Electronic
  • 15 – Request from Company – Written
  • 16 – Request from Company – Telecom
  • 17 – Request from Company – Internet/Electronic
  • 20 – Direct Request – Written
  • 21 – Direct Request – Telecom
  • 22 – Direct Request – Agency
  • 23 – Direct Request – Internet/Electronic
  • 30 – Sources Other – Independent Field Reports
  • 40 – Sources Other – Association Rosters
  • 41 – Association/Society Membership – Independent
  • 42 – Association/Society Membership –Organization
  • 50 – Sources Other – Manufacturer Distributor List
  • 60 – Sources Other – Licenses/Government
  • 70 – Sources Other – Business Directory
  • 80 – Sources Other – Lists
  • 91 – Sources Other – Other

Term – Used to query the how many issues an order has

Verification Date – This date field will display when the customer subscribed/renewed to a specific product. It will always display the most recent date a customer came onto the product.

Verification Date 1yr/2yr/3yr – This is preset rollup that pulls in customer records who have a verification date within 1 year, 2 years or 3 years.

Paid Product Fields (LIVE)

These fields are specific for paid products and will only be configured into your database when there is a paid product available.

Amount– The amount a subscriber paid on their order

Batch#– is the unique number given to paid orders keyed manually by the paid dep

Bulk– is selecting the quantity records with the specific bulk (multiple copies) count

CC Expiration Date– pulls the records with a credit Card that expires in the queried date/ranges. Format is MMYY, where YY is the last two digital of the expired Credit card year

Credit Balance– used to query the balances of credit records

Date Entered– This date field is the date the order was entered into the database

Delivery Code– Code used to identify the method the order is delivered

Donor Id– The customer ID of the Donor record who donated a subscription to another

Earned Balance– Used to query the amount of money earned for specific orders

Earned Copies– Used to query the number of copies earned for specific orders

Earned Issues- Used to query the number of issues earned for specific orders

Expected Expire– This date field is the date a record’s current active order is expected to expire. This field doesn’t include any pending orders

Fee Amount- Used to query the amount of fees paid for specific orders

Gift Notice Sent– Date when a gift notification was sent to the gift subscription recipient

Gift Sub Code– Used to query if an order is a gift or not

Grace Issues– Used to query the number of grace issues given to subscribers

Group Active Count– Used to query the number of groups active for a product

Group Admin– The customer IDs of the Group Admin records who pay for the groups’ order

Group Code– The list of group codes for all groups to be queried

Number of Installments– Numeric field that returns the number of installment payments for an order

P&H- Used to query the amount of Postage and Handling paid for specific orders

Payment Status– Used to determine the current status of their payment

  • Paid on Invoice- Customer Paid after being invoiced
  • Paid with Order- Customer paid at the time of their order
  • Credit – Customer owes an outstanding balance on the subscription
  • Grace – Customer subscription is in grace
  • Free – Customer is being granted a free subscription, but isn’t necessarily qualified by the publisher
  • Controlled – Customer was selected by the publisher to receive subscription for free
  • Free Term – Customer was granted a paid subscription at no cost, but they have an expire date (formerly known as a comp)

Payment Type– Used to determine the order’s method of payment (Ex: cash, Credit Card, Wire Transfer)

PO Number– Used to query the PO number attached to a specific order

Premium Code – This field is used to query codes for items or offers used to entice an individual to purchase a magazine.

Premium Sent– Used to query the date a premium subscription was sent

Price Per Copy– The amount paid for each copy of the magazine

Price Per Issue– The amount paid for each issue on a subscriber’s order. (EX: A $12 subscription order with a term of 12 will have a price per issue of $1) 

Promocode– field used to query specific promo codes for paid records

Receive Notices– Used to determine if a subscriber receives invoice or renewal notices

Remaining Dollars – The dollar amount still left to be earned on a customer record

Remaining Liability– The remaining amount of money owed on an order and would be the current refund amount.

Renewal Code– Code used to show if a subscriber will receive an invoice, autorenewal notice, or no renewal notices upon expiration

Sales Channel– The sales channel used for the order

Sales Tax– Used to query the amount of Sales Tax paid for specific orders

Shipping Same as Billing Address– Used to confirm if shipping and billing addresses are the same or different for an order

SKU– Used to query SKU attached to an order

Source– Used to query the source of the Order

Start issue– used to find the issue an order started their subscription with

Status– The current status of the order, which may be any one of the following:

  • Active – Order is Actively receiving the issues
  • Pending – Order is on hold until the active order is fulfilled and expires
  • Expired – Order has been fulfilled and earned all its money so it is inactive
  • Canceled – Order has been ended before earning out and is inactive
  • Graced – Order has been earned out, but receiving a limited number of “free” issues.

Here is an alphabetical data dictionary of the most common product fields (both paid and free) for magazine and newsletter products found in Audience Builder. These can be used in a variety of queries in order to identify and segment out records you have on product(s).

Activation Date – This date field tracks the date a controlled magazine record or newsletter record becomes active.

Active Version – This field tracks what version the customer is currently receiving (may be different from what they originally requested):
– Print
– Digital
– Digital Only
– Both
– Blank

Audited Demo Verification Date 1yr/2yr/3yr – This is preset rollup that pulls in customer records who have an audited demographic verification date within 1 year, 2 years or 3 years

Batch Tracking Code – Unique identifier that allows us to pull the current batch (group) of records that were uploaded together from a file, webpage, etc. (e.g. OWS203301231501301922, DLR30222017112654)

Previous Batch Tracking Code – This field stores previous batch tracking codes on a customer’s product record.

BPA Type (required for all magazine records): Record categories that are necessary for BPA audit statements. Will be automatically assigned to records based on the input. On the first page of your audience report, Classes 1 and 2 will be broken out by BPA types.

  • ADV + Agency
  • Award Point
  • Gift
  • Individual
  • Membership/Association Benefit
  • Non-Qual Multi-Copy Same Address
  • Paid
  • Qual Multi-Copy Same Address
  • ROT or OCCAS
  • Samples
  • Seed
  • Single Copy Sales
  • Sponsored Individual Addressed
  • All Other

Class: These are the different categories that your product records will be part of. All customers can have only one class per product.

  • (1) Active Qualified – Records receiving the magazine and are qualified
  • (2) Active Non-Qualified – Records receiving the magazine that are non-qualified, typically non-qualified paid or comps
  • (3) Qualified Reserve – These are non-paid records that meet the qualification criteria and are waiting to be activated
  • (8) Soft Controlled Kills – These are issue deletes (perhaps they were too old or they can’t receive the issue for some reason (for example: US only for print and they are outside the US and they don’t have a valid email or they opted out of the digital edition)
  • (9) Controlled Kills – Hard deletes that can be deactivated if there are no other active products
  • (10) ACS Kills – Non-paid postal returns
  • (20) Expire Suspends – Paid records that did not renew
  • (21) Future Starts – Paid records that will be activated with a future issue
  • (22) Postal Suspends – Paid postal returns
  • (23) Credit Suspends – Bill me’s that did not pay
  • (24) Requested Suspends – Paid records that requested to stop receiving the magazine
  • (25) Kill/Refunds – Paid kills/refunds
  • (26) Non-Receiving Group Admin. – Group admins that are not receiving the magazine
  • (27) Non-Receiving Earning Admin. – Earning admins that are not receiving the magazine
  • (50) Passalong – Non-paid records a host has asked to receive the magazine (i.e. company request typically in the form of ‘Do you have any colleagues at your location that would be interested in receiving XYZ Magazine’ – address as well as company specific demos are copied from the host.)

Current Date – This is a rolling date field that groups records based on their verification date. This allows you to easily pull in customers who came onto the product 3 months ago, 6 months ago, 2 years ago, etc. This can be used instead of having a flex date range in ‘Verification Date’.

Deactivation Date – The Date field tracks the date an active controlled magazine or newsletter record is deactivated.

First Order Date – This date field will display when the customer subscribed to a specific product.

How Addressed – This will categorize how customer labels are addressed for print magazines.

  • Ind Cust by name,title,function
  • Ind Cust by name only
  • Title and/or function
  • Company name only
  • Multi-copy same address
  • Single copy sales
  • Blank

Last Issue Received – This field tracks the issue number of the most-recently-received. This gets populated when the final issue close process is run.
Note: The issue number is overwritten with each issue served, so only the most recent issue served to the customer will be returned.

Nixie Count – The number of postal nixies we have on file for a customer

Payment Status– Used to determine the current status of their payment

  • Paid on Invoice- Customer Paid after being invoiced
  • Paid with Order- Customer paid at the time of their order
  • Credit – Customer owes an outstanding balance on the subscription
  • Grace – Customer subscription is in grace
  • Free – Customer is being granted a free subscription, but isn’t necessarily qualified by the publisher
  • Controlled – Customer was selected by the publisher to receive subscription for free
  • Free Term – Customer was granted a paid subscription at no cost, but they have an expire date (formerly known as a comp)

Promo Code – Open Text field that stores the current campaign/source code that is on file for the current subscription.

Previous Promo Code – Open text field that stores all previous codes that were associated with customers for the product.

Renewal Count – The number of times a customer has renewed

Remaining Copies – The number of copies a customer has left before their expire/renewal date. Note: This will be the same count as their remaining issues unless this is a multi-copy order.

Remaining Issues – The number of issues a customer has left before their expire/renewal date

Requested Version – This field stores the product version the customer originally asked for:

  • Print
  • Digital
  • Digital Only
  • Both
  • Blank

Rollup Expire Date – This date field rolls up all of a record’s orders for a specific product, both active and pending, to show when the record will next expire and need to be renewed.

Source (required for all records loaded into the system) – A pre-defined list of BPA sources that define where a record comes from and categorizes it accordingly. Note: This source list cannot be edited or customized.

  • 0 – Undefined Source
  • 10 – Communication other Request – Written
  • 11 – Communication other Request – Telecom
  • 12 – Communication other Request – Internet/Electronic
  • 15 – Request from Company – Written
  • 16 – Request from Company – Telecom
  • 17 – Request from Company – Internet/Electronic
  • 20 – Direct Request – Written
  • 21 – Direct Request – Telecom
  • 22 – Direct Request – Agency
  • 23 – Direct Request – Internet/Electronic
  • 30 – Sources Other – Independent Field Reports
  • 40 – Sources Other – Association Rosters
  • 41 – Association/Society Membership – Independent
  • 42 – Association/Society Membership –Organization
  • 50 – Sources Other – Manufacturer Distributor List
  • 60 – Sources Other – Licenses/Government
  • 70 – Sources Other – Business Directory
  • 80 – Sources Other – Lists
  • 91 – Sources Other – Other

Term – Used to query the how many issues an order has

Verification Date – This date field will display when the customer subscribed/renewed to a specific product. It will always display the most recent date a customer came onto the product.

Verification Date 1yr/2yr/3yr – This is preset rollup that pulls in customer records who have a verification date within 1 year, 2 years or 3 years.

Paid Product Fields (LIVE)

These fields are specific for paid products and will only be configured into your database when there is a paid product available.

Amount– The amount a subscriber paid on their order

Batch#– is the unique number given to paid orders keyed manually by the paid dep

Bulk– is selecting the quantity records with the specific bulk (multiple copies) count

CC Expiration Date– pulls the records with a credit Card that expires in the queried date/ranges. Format is MMYY, where YY is the last two digital of the expired Credit card year

Credit Balance– used to query the balances of credit records

Date Entered– This date field is the date the order was entered into the database

Delivery Code– Code used to identify the method the order is delivered

Donor Id– The customer ID of the Donor record who donated a subscription to another

Earned Balance– Used to query the amount of money earned for specific orders

Earned Copies– Used to query the number of copies earned for specific orders

Earned Issues- Used to query the number of issues earned for specific orders

Expected Expire– This date field is the date a record’s current active order is expected to expire. This field doesn’t include any pending orders

Fee Amount- Used to query the amount of fees paid for specific orders

Gift Notice Sent– Date when a gift notification was sent to the gift subscription recipient

Gift Sub Code– Used to query if an order is a gift or not

Grace Issues– Used to query the number of grace issues given to subscribers

Group Active Count– Used to query the number of groups active for a product

Group Admin– The customer IDs of the Group Admin records who pay for the groups’ order

Group Code– The list of group codes for all groups to be queried

Number of Installments– Numeric field that returns the number of installment payments for an order

P&H- Used to query the amount of Postage and Handling paid for specific orders

Payment Status– Used to determine the current status of their payment

  • Paid on Invoice- Customer Paid after being invoiced
  • Paid with Order- Customer paid at the time of their order
  • Credit – Customer owes an outstanding balance on the subscription
  • Grace – Customer subscription is in grace
  • Free – Customer is being granted a free subscription, but isn’t necessarily qualified by the publisher
  • Controlled – Customer was selected by the publisher to receive subscription for free
  • Free Term – Customer was granted a paid subscription at no cost, but they have an expire date (formerly known as a comp)

Payment Type– Used to determine the order’s method of payment (Ex: cash, Credit Card, Wire Transfer)

PO Number– Used to query the PO number attached to a specific order

Premium Code – This field is used to query codes for items or offers used to entice an individual to purchase a magazine.

Premium Sent– Used to query the date a premium subscription was sent

Price Per Copy– The amount paid for each copy of the magazine

Price Per Issue– The amount paid for each issue on a subscriber’s order. (EX: A $12 subscription order with a term of 12 will have a price per issue of $1) 

Promocode– field used to query specific promo codes for paid records

Receive Notices– Used to determine if a subscriber receives invoice or renewal notices

Remaining Dollars – The dollar amount still left to be earned on a customer record

Remaining Liability– The remaining amount of money owed on an order and would be the current refund amount.

Renewal Code– Code used to show if a subscriber will receive an invoice, autorenewal notice, or no renewal notices upon expiration

Sales Channel– The sales channel used for the order

Sales Tax– Used to query the amount of Sales Tax paid for specific orders

Shipping Same as Billing Address– Used to confirm if shipping and billing addresses are the same or different for an order

SKU– Used to query SKU attached to an order

Source– Used to query the source of the Order

Start issue– used to find the issue an order started their subscription with

Status– The current status of the order, which may be any one of the following:

  • Active – Order is Actively receiving the issues
  • Pending – Order is on hold until the active order is fulfilled and expires
  • Expired – Order has been fulfilled and earned all its money so it is inactive
  • Canceled – Order has been ended before earning out and is inactive
  • Graced – Order has been earned out, but receiving a limited number of “free” issues.

Activation Date – This date field tracks the date a controlled magazine record or newsletter record becomes active.

Active Version – This field tracks what version the customer is currently receiving (may be different from what they originally requested):
– Print
– Digital
– Digital Only
– Both
– Blank

Audited Demo Verification Date 1yr/2yr/3yr – This is preset rollup that pulls in customer records who have an audited demographic verification date within 1 year, 2 years or 3 years

Batch Tracking Code – Unique identifier that allows us to pull the current batch (group) of records that were uploaded together from a file, webpage, etc. (e.g. OWS203301231501301922, DLR30222017112654)

Previous Batch Tracking Code – This field stores previous batch tracking codes on a customer’s product record.

BPA Type (required for all magazine records): Record categories that are necessary for BPA audit statements. Will be automatically assigned to records based on the input. On the first page of your audience report, Classes 1 and 2 will be broken out by BPA types.

  • ADV + Agency
  • Award Point
  • Gift
  • Individual
  • Membership/Association Benefit
  • Non-Qual Multi-Copy Same Address
  • Paid
  • Qual Multi-Copy Same Address
  • ROT or OCCAS
  • Samples
  • Seed
  • Single Copy Sales
  • Sponsored Individual Addressed
  • All Other

Class: These are the different categories that your product records will be part of. All customers can have only one class per product.

  • (1) Active Qualified – Records receiving the magazine and are qualified
  • (2) Active Non-Qualified – Records receiving the magazine that are non-qualified, typically non-qualified paid or comps
  • (3) Qualified Reserve – These are non-paid records that meet the qualification criteria and are waiting to be activated
  • (8) Soft Controlled Kills – These are issue deletes (perhaps they were too old or they can’t receive the issue for some reason (for example: US only for print and they are outside the US and they don’t have a valid email or they opted out of the digital edition)
  • (9) Controlled Kills – Hard deletes that can be deactivated if there are no other active products
  • (10) ACS Kills – Non-paid postal returns
  • (20) Expire Suspends – Paid records that did not renew
  • (21) Future Starts – Paid records that will be activated with a future issue
  • (22) Postal Suspends – Paid postal returns
  • (23) Credit Suspends – Bill me’s that did not pay
  • (24) Requested Suspends – Paid records that requested to stop receiving the magazine
  • (25) Kill/Refunds – Paid kills/refunds
  • (26) Non-Receiving Group Admin. – Group admins that are not receiving the magazine
  • (27) Non-Receiving Earning Admin. – Earning admins that are not receiving the magazine
  • (50) Passalong – Non-paid records a host has asked to receive the magazine (i.e. company request typically in the form of ‘Do you have any colleagues at your location that would be interested in receiving XYZ Magazine’ – address as well as company specific demos are copied from the host.)

Current Date – This is a rolling date field that groups records based on their verification date. This allows you to easily pull in customers who came onto the product 3 months ago, 6 months ago, 2 years ago, etc. This can be used instead of having a flex date range in ‘Verification Date’.

Deactivation Date – The Date field tracks the date an active controlled magazine or newsletter record is deactivated.

First Order Date – This date field will display when the customer subscribed to a specific product.

How Addressed – This will categorize how customer labels are addressed for print magazines.

  • Ind Cust by name,title,function
  • Ind Cust by name only
  • Title and/or function
  • Company name only
  • Multi-copy same address
  • Single copy sales
  • Blank

Last Issue Received – This field tracks the issue number of the most-recently-received. This gets populated when the final issue close process is run.
Note: The issue number is overwritten with each issue served, so only the most recent issue served to the customer will be returned.

Nixie Count – The number of postal nixies we have on file for a customer

Payment Status– Used to determine the current status of their payment

  • Paid on Invoice- Customer Paid after being invoiced
  • Paid with Order- Customer paid at the time of their order
  • Credit – Customer owes an outstanding balance on the subscription
  • Grace – Customer subscription is in grace
  • Free – Customer is being granted a free subscription, but isn’t necessarily qualified by the publisher
  • Controlled – Customer was selected by the publisher to receive subscription for free
  • Free Term – Customer was granted a paid subscription at no cost, but they have an expire date (formerly known as a comp)

Promo Code – Open Text field that stores the current campaign/source code that is on file for the current subscription.

Previous Promo Code – Open text field that stores all previous codes that were associated with customers for the product.

Renewal Count – The number of times a customer has renewed

Remaining Copies – The number of copies a customer has left before their expire/renewal date. Note: This will be the same count as their remaining issues unless this is a multi-copy order.

Remaining Issues – The number of issues a customer has left before their expire/renewal date

Requested Version – This field stores the product version the customer originally asked for:

  • Print
  • Digital
  • Digital Only
  • Both
  • Blank

Rollup Expire Date – This date field rolls up all of a record’s orders for a specific product, both active and pending, to show when the record will next expire and need to be renewed.

Source (required for all records loaded into the system) – A pre-defined list of BPA sources that define where a record comes from and categorizes it accordingly. Note: This source list cannot be edited or customized.

  • 0 – Undefined Source
  • 10 – Communication other Request – Written
  • 11 – Communication other Request – Telecom
  • 12 – Communication other Request – Internet/Electronic
  • 15 – Request from Company – Written
  • 16 – Request from Company – Telecom
  • 17 – Request from Company – Internet/Electronic
  • 20 – Direct Request – Written
  • 21 – Direct Request – Telecom
  • 22 – Direct Request – Agency
  • 23 – Direct Request – Internet/Electronic
  • 30 – Sources Other – Independent Field Reports
  • 40 – Sources Other – Association Rosters
  • 41 – Association/Society Membership – Independent
  • 42 – Association/Society Membership –Organization
  • 50 – Sources Other – Manufacturer Distributor List
  • 60 – Sources Other – Licenses/Government
  • 70 – Sources Other – Business Directory
  • 80 – Sources Other – Lists
  • 91 – Sources Other – Other

Term – Used to query the how many issues an order has

Verification Date – This date field will display when the customer subscribed/renewed to a specific product. It will always display the most recent date a customer came onto the product.

Verification Date 1yr/2yr/3yr – This is preset rollup that pulls in customer records who have a verification date within 1 year, 2 years or 3 years.

Paid Product Fields (LIVE)

These fields are specific for paid products and will only be configured into your database when there is a paid product available.

Amount– The amount a subscriber paid on their order

Batch#– is the unique number given to paid orders keyed manually by the paid dep

Bulk– is selecting the quantity records with the specific bulk (multiple copies) count

CC Expiration Date– pulls the records with a credit Card that expires in the queried date/ranges. Format is MMYY, where YY is the last two digital of the expired Credit card year

Credit Balance– used to query the balances of credit records

Date Entered– This date field is the date the order was entered into the database

Delivery Code– Code used to identify the method the order is delivered

Donor Id– The customer ID of the Donor record who donated a subscription to another

Earned Balance– Used to query the amount of money earned for specific orders

Earned Copies– Used to query the number of copies earned for specific orders

Earned Issues- Used to query the number of issues earned for specific orders

Expected Expire– This date field is the date a record’s current active order is expected to expire. This field doesn’t include any pending orders

Fee Amount- Used to query the amount of fees paid for specific orders

Gift Notice Sent– Date when a gift notification was sent to the gift subscription recipient

Gift Sub Code– Used to query if an order is a gift or not

Grace Issues– Used to query the number of grace issues given to subscribers

Group Active Count– Used to query the number of groups active for a product

Group Admin– The customer IDs of the Group Admin records who pay for the groups’ order

Group Code– The list of group codes for all groups to be queried

Number of Installments– Numeric field that returns the number of installment payments for an order

P&H- Used to query the amount of Postage and Handling paid for specific orders

Payment Status– Used to determine the current status of their payment

  • Paid on Invoice- Customer Paid after being invoiced
  • Paid with Order- Customer paid at the time of their order
  • Credit – Customer owes an outstanding balance on the subscription
  • Grace – Customer subscription is in grace
  • Free – Customer is being granted a free subscription, but isn’t necessarily qualified by the publisher
  • Controlled – Customer was selected by the publisher to receive subscription for free
  • Free Term – Customer was granted a paid subscription at no cost, but they have an expire date (formerly known as a comp)

Payment Type– Used to determine the order’s method of payment (Ex: cash, Credit Card, Wire Transfer)

PO Number– Used to query the PO number attached to a specific order

Premium Code – This field is used to query codes for items or offers used to entice an individual to purchase a magazine.

Premium Sent– Used to query the date a premium subscription was sent

Price Per Copy– The amount paid for each copy of the magazine

Price Per Issue– The amount paid for each issue on a subscriber’s order. (EX: A $12 subscription order with a term of 12 will have a price per issue of $1) 

Promocode– field used to query specific promo codes for paid records

Receive Notices– Used to determine if a subscriber receives invoice or renewal notices

Remaining Dollars – The dollar amount still left to be earned on a customer record

Remaining Liability– The remaining amount of money owed on an order and would be the current refund amount.

Renewal Code– Code used to show if a subscriber will receive an invoice, autorenewal notice, or no renewal notices upon expiration

Sales Channel– The sales channel used for the order

Sales Tax– Used to query the amount of Sales Tax paid for specific orders

Shipping Same as Billing Address– Used to confirm if shipping and billing addresses are the same or different for an order

SKU– Used to query SKU attached to an order

Source– Used to query the source of the Order

Start issue– used to find the issue an order started their subscription with

Status– The current status of the order, which may be any one of the following:

  • Active – Order is Actively receiving the issues
  • Pending – Order is on hold until the active order is fulfilled and expires
  • Expired – Order has been fulfilled and earned all its money so it is inactive
  • Canceled – Order has been ended before earning out and is inactive
  • Graced – Order has been earned out, but receiving a limited number of “free” issues.

Here is an alphabetical data dictionary of the most common product fields (both paid and free) for magazine and newsletter products found in Audience Builder. These can be used in a variety of queries in order to identify and segment out records you have on product(s).

Table of Contents
Scroll to Top