Piano: Most-used fields

The table below gives information about most-used fields that you can import from Piano. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
Access Count	Access Count	Total number of visits made by a user over their entire existence.	metric
Company Name	Company Name	The name of the publisher’s application or organization associated with the data.	dimension
Conversion rate	Conversion rate	The percentage of users who completed a desired action, such as a subscription or registration, as tracked by the Conversions Report.	metric
Conversions	Conversions	The total number of times a user completed a specific desired action (e.g., purchase, registration), as reported in the Conversions Report.	metric
Currency	Currency	The currency used for transactions and pricing (e.g., USD, EUR).	dimension
Date	Date	The date associated with an event, such as a conversion, subscription, or user action.	dimension
Email	Email	The email address associated with the user’s account.	dimension
Experience ID	Experience ID	Unique identifier for a user experience or campaign within Piano’s Composer, used in the Conversions Report (exp_id).	dimension
Has Trial?	Has Trial?	Indicates whether the subscription is currently in a trial period.	dimension
Money Spent	Money Spent	The total monetary amount spent by a user on subscriptions or other purchases.	dimension
Name	Name	The full name of the user.	dimension
Next Billing Date	Next Billing Date	The date when the next payment for the subscription is due.	dimension
User ID	User ID	A unique identifier for the user account.	dimension
source	Source	The origin or referrer of the user’s first visit to the digital property, such as a search engine, social media platform, or direct access.	dimension