Access Reporting Log

Field

Column

Description

Access ID

A

The ID assigned to the user after the conversion is confirmed that uniquely identifies the nature of the user's access.

User ID

B

The unique ID pertaining to the user, assigned upon registration of the user account.

Term Type

I

The type of term that the user converted on for access.

Term ID

J

The term ID that was assigned to the term the user converted on upon creation of that term.

Term Name

K

The name of the term that the user converted on as it was at the time of conversion. This name was created and is editable by you.

Subscription ID

Q

The unique ID pertaining to the user's purchased subscription.

Campaign Codes

AA

The campaign code (if applicable) that the user followed prior to converting on the term.

Offer Template ID

AC

The unique template ID of the offer that contained the term that the user converted on.

Offer Template Name

AD

The name of the offer template at the time the user converted on the term. This may be different from the current name if you edited the name between the time of conversion and the time of generating the report.

URL

AI

The URL that the user was on when he or she converted on the subscription term.

PSC Account
Number

AJ

The Print Subscription Confirmation account number (if applicable) that uniquely identifies the user for a print subscription.

Field

Column

Description

 User Email

C

The email address that the user provided upon registering. Note that registration may have happened before the user converted on the term.

 First Name

D

The first name the user provided upon registering.

 Last Name

E

The last name the user provided upon registering.

 Device

AB

The type of device that the user was on when he or she converted on the subscription term (desktop, tablet, mobile, or external).

 City

AE

The city that the user was in upon converting on the term, collected using GeoIP. Note that this will be "N/A" for users who converted using an external service.

State

 AG

The state, province, or territory that the user was in upon converting on the term, collected using GeoIP. Note that this will be "N/A" for users who converted using an external service.

 Country

AH

The country that the user was in upon converting on the term, collected using GeoIP. Note that this will be "N/A" for users who converted using an external service.

 Print First Name

AK

Only for PSC and terms with address collection, the first name of the print subscription recipient.

Print Last Name

AL

Only for PSC and terms with address collection, the last name of the print subscription recipient.

Print Address

AM

Only for PSC and terms with address collection, the first line of the print subscription recipient's address.

Print Address Line

AN

Only for PSC and terms with address collection, the second line of the print subscription recipient's address.

Print City

AO

Only for PSC and terms with address collection, the city of residence of the print subscription recipient.

Print State

AP

Only for PSC and terms with address collection, the state of residence of the print subscription recipient.

Print Zip

AQ

Only for PSC and terms with address collection, the ZIP or postal code of the print subscription recipient.

Print Country

AR

Only for PSC and terms with address collection, the country of residence of the print subscription recipient.

Print Phone

AS

Only for PSC and terms with address collection, the phone number of the print subscription recipient.

Field

Column

Description

Start Date

F

The date that the subscription access began. Note that this is not necessarily the same as the purchase date.

Access Status

G

A boolean field providing the status of resource access (YES or NO).

Access
Expiration Date

H

The date and time that a user's access to the resource will end.

Subscription Status

R

The state of the user's subscription. Can be active, canceled, expired, or payment failed.

Cancellation Date

W

The date and time that a subscription was canceled (if applicable).

Subscription Trial
End Date

X

The date and time that a user's subscription trial will end, and the user will be prompted to pay to maintain access.

Subscription Grace
Period Start Date

Y

The date and time that a user's grace period began due to the end of a trial or the expiration of a previous subscription.

Auto Renew
Enabled

Z

A F/T field that indicates whether the user opted to have their subscription automatically renewed.

Field

Column

Description

Currency

L

The currency that the transaction occurred in.

Price

M

The listed price of the term that the user converted on.

Billing Plan

N

The enumeration of how the access is broken down, in the form of [PRICE|ACCESS_DURATION|CHARGE_COUNT]. Charge_count will be "*" if auto-renew is enabled.

Payment Source

O

The method of payment that the user chose to convert on the term.

Payment Type

P

The type of card that the user chose to convert on the term (Visa, MasterCard, etc.)

Last Payment Status

S

Reflects the user's payment status related to the first term conversion of the subscription. Can be verified, completed, or failed. For imported subscriptions without a payment, the value appears as N/A.

Last Billing Date

T

The date and time that the user was last billed for their subscription.

Next Billing Date

U

The date and time that the user will next be billed for their subscription.

Charge Count

V

The number of times that the user has been charged for renewal on their subscription.

Promo Code

AF

The promo code that the user redeemed (if applicable) at the time of purchasing the subscription.