System Tracking Fields
|
Field |
Column |
Description |
|
AID |
A |
Application ID, a 10-digit code that uniquely identifies each application within Piano's system. |
|
App Name |
B |
The name of application that you registered under. |
|
Term ID |
C |
The term ID that was assigned to the term the user converted on upon creation of that term. |
|
Term Name |
D |
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 the client. |
|
Term Type |
E |
Type of term that the user converted on upon creation of that term (Payment, External Service, Registration, or Custom). |
Payment and Tracking Information
|
Field |
Column |
Description |
|
Currency |
F |
Type of currency (i.e, USD, EUR, etc). |
|
Daily New Users Revenue* |
I |
Total revenue generated from new users converting on the term on the specified day. |
|
MTD New Revenue Subtotal* |
K |
Month-to-date revenue generated from new users (excluding tax). |
|
MTD New Revenue Tax* |
L |
Month-to-date sales tax generated from new users. |
|
MTD New Revenue Total* |
M |
Total month-to-date revenue generated from new users (including tax). |
|
Daily Renewals Revenue Total |
O |
Total revenue from renewals on selected day. |
|
MTD Renewals Subtotal |
Q |
Month-to-date revenue generated from renewals (excluding tax). |
|
MTD Renewals Tax |
R |
Month-to-date sales tax generated from renewals. |
|
MTD Renewals Total |
S |
Total month-to-date revenue generated from renewals (including tax). |
|
Daily Refunds Cash Out Total |
U |
Revenue lost from refunds on the specified day. |
|
MTD Refunds Subtotal |
W |
Revenue lost from refunds in the given month to the specified date. |
|
MTD Refunds Tax |
X |
Tax reversed due to refunds in the given month to the specified date. |
|
MTD Refunds Total |
Y |
Total month-to-date revenue lost due to refunds (including tax). |
Subscription Information
|
Field |
Column |
Description |
|
Current Active Accesses |
G |
Number of people who have access to the term on the selected day. |
|
Daily New Users* |
H |
Number of new users who have converted to the term on the selected day. |
|
MTD New Users |
J |
Month-to-date number of new users who have converted on the term. |
|
Daily Renewals |
N |
Number of renewals on the selected day. |
|
MTD Renewals |
P |
Month-to-date number of renewals. |
|
Daily Refunds |
T |
Number of refunds processed on the specified day. |
|
MTD Refunds |
V |
Number of refunds processed in the given month to the specified date. |
|
Daily Cancelled |
Z |
Number of cancellations on specified day. |
|
MTD Cancelled |
AA |
Month-to-date number of cancellations. |
|
Daily Expired |
AB |
Number of expirations on the specified day. |
|
MTD Expired |
AC |
Month-to-date number of expirations. |
* "New users," "New revenue," and related terms refer to a conversion in the indicated time window on any term that is not a renewal of an existing subscription.