A User in Piano Analytics is an authenticated visitor identified by a user_id property. This identifier — typically sourced from your CRM or authentication system — must be set explicitly through additional tracking.
When you use Piano Analytics, you have access to 11 properties giving you information about your users. You can find them simply by using the "User" tag or by searching for properties containing (user) in their wording. Here is the full list:
|
Property_key |
Display Name |
Definition |
|
user_all_conversions |
Cumulated conversions (user) |
Total number of conversions made by the user(s) over its existence. Property within reach of Users independent of the analysis period. |
|
user_all_days |
Cumulated days (user) |
Total number of days the user(s) visited the site. Property within reach of Users independent of the analysis period. |
|
user_all_duration |
Cumulated time spent (user) |
Cumulative time spent by the user(s) on the site. Property within reach of Users independent of the analysis period. |
|
user_all_pageviews |
Cumulated page views (user) |
Total number of page views by the user(s) over its existence. Property within reach of Users independent of the analysis period. |
|
user_all_turnover |
Cumulated order value (user) |
Sum of the revenue excluding tax of all transactions made by the user(s) over its entire existence. Property within reach of Users independent of the analysis period. |
|
user_all_visits |
Cumulated visits (user) |
Total number of visits made by the user(s) over its existence. Property within reach of Users independent of the analysis period. |
|
user_first_campaign |
First campaign (user) |
First campaign of the user(s) over its entire existence. Property within reach of Users independent of the analysis period. |
|
user_first_date |
First access date (user) |
Date of the first visit of the user(s) over its entire existence. Property within reach of Users independent of the analysis period. |
|
user_first_source |
First source (user) |
First source of the user(s) over its entire existence. Property within reach of Users independent of the analysis period. |
|
user_last_date |
Last access date (user) |
Date of the last visit of the user(s) over its entire existence. Property within reach of Users independent of the analysis period. |
|
user_visit_per_day |
No. of visits / day (user) |
Number of visits in the same day for the same user. |
How are these properties calculated?
As soon as we start receiving data for Users, we will increment all properties. For example, for each visit, we will add 1 to the "Cumulated visits" property and fill in the date properties.
For the first access sources and the first access date, if they are earlier than your data retention period, the information will be "NULL".
You don't want to expose those information?
You can set them to hidden in the Data Model.