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	The total number of times a user has accessed content or specific features within the Piano platform. This is typically derived from behavioral event data and analytics reports.	metric
Company Name	Company Name	The name of the company associated with the user, often captured as a custom user field during registration or profile updates. This information can be included in user exports.	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 primary email address registered to the user account in the Piano system, available through user exports.	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 a user currently has an active trial subscription, which is part of the subscription lifecycle events available in subscription detail reports.	dimension
Money Spent	Money Spent	The total monetary value spent by a user on subscriptions or other purchases through the Piano platform, typically found in subscription details or conversion reports.	dimension
Name	Name	The full name of the user as recorded in their Piano user profile, obtainable through user exports.	dimension
Next Billing Date	Next Billing Date	The scheduled date for the next payment or renewal of an active user subscription, provided in subscription detail reports.	dimension
User ID	User ID	A unique identifier assigned to each user within the Piano system, available in user records.	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