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		metric
Address 1	Address 1		dimension
Address 2	Address 2		dimension
Address city	Address city		dimension
Address country	Address country		dimension
Address state	Address state		dimension
Auto Renew Enabled	Auto Renew Enabled		dimension
Billing Zip Code	Billing Zip Code		metric
Cancellation Date	Cancellation Date		dimension
Charge Count	Charge Count		metric
City	City		dimension
Company Name	Company Name		dimension
Conversion rate	Conversion rate		dimension
Conversions	Conversions		dimension
Country	Country		dimension
Currency	Currency		dimension
Date	Date		dimension
Email	Email		dimension
Experience ID	Experience ID		dimension
First Name	First Name		dimension
Has Trial?	Has Trial?		dimension
ID	ID		dimension
Last Billing Date	Last Billing Date		dimension
Last Name	Last Name		dimension
Money Spent	Money Spent		dimension
Name	Name		dimension
Name (first and last)	Name (first and last)		dimension
Next Billing Date	Next Billing Date		dimension
Offer Template ID	Offer Template ID		dimension
Offer Template Name	Offer Template Name		dimension
Phone	Phone		dimension
Postal code	Postal code		dimension
Price	Price		dimension
Promo Code	Promo Code		dimension
Renewed	Renewed		dimension
Resource ID (RID)	Resource ID (RID)		dimension
Resource Name	Resource Name		dimension
Start Date	Start Date		dimension
State	State		dimension
Status	Status		dimension
Subscription Grace Period Start Date	Subscription Grace Period Start Date		dimension
Subscription Trial End Date	Subscription Trial End Date		dimension
Tax	Tax		dimension
Tax base	Tax base		dimension
Tax country	Tax country		dimension
Tax rate	Tax rate		metric
Tax state/province	Tax state/province		dimension
Term ID	Term ID		dimension
Term Name	Term Name		dimension
Total $ Charged	Total $ Charged		metric
Total $ Refunded	Total $ Refunded		metric
URL	URL		dimension
User	User		dimension
User Access Expiration Date	User Access Expiration Date		dimension
User ID	User ID		dimension
User ID (UID)	User ID (UID)		dimension
device	Device	The type of device that the user was on when he or she converted on the subscription term. Most common options include desktop, tablet, mobile, but you might also see DMR (Digital media receivers, e.g. Roku), game consoles (e.g. PlayStation, Xbox), and other (e.g. wearables, smart TV’s, etc.).	dimension
source	Source	Conversion source (interactions, external, ESP etc.).	dimension