System Tracking Fields
|
Field |
Column |
Description |
|
App Name |
A |
The name of your application, as you registered it upon signing up with Piano. |
|
Term ID |
B |
The term ID that was assigned to the term the user converted on upon creation of that term. |
|
Term Name |
C |
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. |
|
Term Type |
D |
Type of term that the user converted on upon creation of that term (Payment, External Service, Registration, Custom). |
Payment and Transaction Information
|
Field |
Column |
Description |
|
Currency |
E |
Type of currency used (ex: USD, EUR). |
|
New Revenue Subtotal |
H |
Amount of revenue generated from conversions in the given month, excluding renewals and tax. |
|
New Revenue Tax |
I |
Total tax on revenue generated from new conversions in the given month, not including renewals. |
|
New Revenue Total |
J |
Total revenue generated from new conversions in the given month, not including renewals (including tax). |
|
Renewals Subtotal |
L |
Amount of revenue generated from subscription renewals in the given month (excluding tax). |
|
Renewals Tax |
M |
Total tax on revenue generated from renewals in the given month. |
|
Renewals Total |
N |
Total revenue generated from renewals in the given month (including tax). |
|
Refunds Subtotal |
P |
Revenue lost from refunds during the given month (excluding tax). |
|
Refunds Tax |
Q |
Tax reversed due to refunds in the given month.. |
|
Refunds Total |
R |
Total revenue lost from refunds in the given month (including tax). |
Subscription Information
|
Field |
Column |
Description |
|
Current Active Accesses |
F |
Total number of accesses that were active in the given month. Note that one user may have more than one active access. |
|
New Users |
G |
Number of users who have converted on a term in the given month, excluding renewals. |
|
Renewals |
K |
Number of subscription renewals during the given month. |
|
Refunds |
O |
Number of refunds issued during the given month. |
|
Cancelled |
S |
The number of cancellations on the given term during the specified month. |
|
Expired |
T |
The number of expirations on the given term during the specified month. |