Data Model Structure – Piano Support

Composer Insights automatically sends the most valuable Composer and VX data into Piano Analytics. In this article, you will be able to review the Data Model structure used to represent and calculate data displayed in Composer Insights.

When thinking about this data, it's important to understand three categories of data within the Data Model:

Events: Events are the primary data points ingested into Piano Analytics. A pageview or a template firing or a conversion are examples of events (an event, by nature, is a data point associated with a timestamp).
Properties: An event can have hundreds of pieces of metadata attached to it (for example, think of all the rich device, referrer, and geography data a pageview contains). Each piece of event metadata is a a property.
Metrics: Piano uses the combination of events, properties, (and other metrics) to calculate out-of-the-box metrics. Examples of metrics include experience conversion rate and lost subscriptions.

Note that all of this data can be combined in numerous ways using Piano Analytics' powerful data manipulation functionality in Data Query. The final table in this section shows the properties connected to each event to help you understand which properties are available for a given event.

Events

Events streamed as a part of Composer Insights implementation:

Name	Product	Description
experience.action	Composer	Event that specifies the visitor was exposed/targeted by the template/offer. Please note, that only the ShowTemplate or ShowOffer action cards are captured. If a template is shown by the function tp.template.show() within a Run JS action card, it is not taken into account.
experience.interaction	Composer	Event that specifies the visitor clicked on the template. Piano automatically logs every external link clicked inside our templates. "Close" button clicks are excluded.
composer.conversion	Composer	Event that specifies the visitor responded to your call-to-action. As a composer conversion, we understand for example AdBlock disablement, credit redeemed, etc.
identity.create	Identity	Identity create event is generated when a user creates a new account either within the checkout flow or through the signup method. The event is also created when the publisher creates new accounts through the support team or bulk creation when migrating/importing users.
identity.delete	Identity	Identity delete is generated when a user account is removed from the system.
identity.login	Identity	Identity login event is generated when users log in on the website to their account.
identity.logout	Identity	Identity login event is generated when users log out on the website from their account.
identity.password.reset.requested	Identity	Identity password reset request is generated when users forget their password and request for a reset through an email link.
identity.password.reset.success	Identity	Identity password reset success is generated when users successfully create a new password after the identity password reset request.
identity.password.updated	Identity	Identity password update is generated each time a password is updated - either via account management or password reset request.
identity.session.expire	Identity	Identity session expired is generated when a user is logged out from their account due to an expired session and is forced to log in again.
page.display	Composer and VX	Event indicating a page has been displayed on-site or on a mobile/App screen. This event is essential to measure traffic correctly and is the origin of the "Page Views" metric.
vx.conversion	VX	Event that specifies the visitor responded to your call-to-action. If you’re using Piano VX to show offers, a visitor accepting any term within that offer (by paying, registering, etc.) will automatically register as a conversion. Included are specifically "on-site" events. As a VX conversion, we understand for example payment term converted, free promo redeemed, the voucher purchased, etc.
vx.conversion.offsite	VX	Event that specifies the visitor responded to your call-to-action but it is done in an "off-site" way, for example, by the customer helpdesk. As a VX offsite conversion, we understand for example payment/registration term conversion done by the customer helpdesk, etc.
transaction.refund.offsite	VX	Event that specifies the previously successful monetary transaction has been refunded. It can be a partial refund, full refund, etc. Refund is done automatically by the system/in an "off-site" way.
subscription.action	VX	Event that specifies a change in subscription behavior. The change is done "on-site". For example, a subscription has been upgraded, or a user enabled auto-renewal in My Account, etc.
subscription.action.offsite	VX	Event that specifies a change in subscription behavior. The change is done "off-site" with the help of the customer helpdesk or automatically by the system, etc. For example, a subscription has been upgraded, or auto-renewal has been updated via the helpdesk.
identity.form.exposure	Composer/Identity	Event is generated when there is a form being exposed to visitor in Composer experience.
identity.form.submit	Composer/Identity	Event is generated when visitor submits the form with responses.

Properties

Either native to Piano Analytics’ standard data model and applicable for Composer Insights clients or implemented as a part of Composer Insights implementation:

Property Key	Property Format	Product	Name	Description
browser_id (not visible by the client)	string	Composer	Browser ID	Identifier of a visitor within Composer. Information within the \"event\" scope (several possible values per visit).
c1x_brand_relationship	string	Composer	C1x- Brand relationship	Segment definition of visitor from C1x segmentation engine: Registered Users, Gift Recipients, Free Trial Users, Paid Trial users, Subscribers, Churned Users. Segment values are populated only if the segment is used in live Composer experience
c1x_checkout_abandonment	string	Composer	C1x- Checkout abandonment	Segment of users that have entered the purchase funnel, but have not completed a transaction: Abandoned checkout in the last 48 hours, Abandoned checkout in the last 7 days, Abandoned checkout in the last 30 days. Segment values are populated only if the segment is used in live Composer experience
c1x_expiring_subscribers	string	Composer	C1x- Expiring subscribers	Users who have disabled the automatic renewal of their subscription payment, and who will terminate their subscription upon the subscription end date. Segment values are populated only if the segment is used in live Composer experience
c1x_ltc	string	Composer	C1x- LtC	The Likelihood to Cancel segment of subscribers is based on the likelihood they would cancel their subscription. The segment is broken into 10 categories, with 0 as the least likely to cancel and 9 as the most likely to cancel. Segment values are populated when at least one segment value from LtC is used in live Composer experience
c1x_lts	string	Composer	C1x- LtS	Segment of users based on the likelihood that they would subscribe to the website. The algorithm analyzes over a hundred different metrics in order to sort non-subscribers on a 0 to 10 scale in terms of likelihood to subscribe, broken into 10 categories, with 0 as the least likely to subscribe and 9 as the most likely to subscribe. Segment values are populated when at least one segment value from LtC is used in live Composer experience
c1x_likelihood_to_return	string	Composer	C1x- Likelihood to Return	Segment definition of visitors with propensity scores between 0 and 100 predicting a visitor’s likelihood of being amongst the most loyal visitors to a website over the next week
c1x_likelihood_to_register	string	Composer	C1x- Likelihood to Register	Segment definition of visitors with propensity scores between 0 and 100 predicting a visitor’s likelihood to register on the website
c1x_content_likely_to_convert	string	Composer	C1x- Content Likely to Convert	Machine learning model predicts which articles are the most likely to drive subscription conversions with propensity scores between 0 and 100
c1x_revenue_auto_optimization	string	Composer	C1x- Revenue Auto-Optimization	The Revenue Auto-Optimization model is optimizing two key revenue streams: advertising and subscription revenue. The model’s data are breaking down pageviews into 20 distinct segments. The segment value 0 represents the top 5% of pageviews with the highest propensity to be monetized by subscription. Each next segment increments 5% of the pageviews volume
c1x_subscription_length	string	Composer	C1x- Subscription Length	Segment of users based on the terms of their subscription. The segments from this category range: Weekly Subscribers, 4-week subscribers, Monthly subscribers, Quarterly subscribers, Bi-annual subscribers, Annual subscribers. Segment values are populated only if the segment is used in live Composer experience
c1x_subscription_tenure	string	Composer	C1x- Subscription tenure	Segment of users based on the amount of time they have been actively subscribed to the product. Segment values: First 24 hour subscribers, Week 1 subscribers, Week 2 subscribers, Week 3 subscribers, Week 4 subscribers, Month 1-2 subscribers, Month 3-6 subscribers, Month 6+ subscribers. Segment values are populated only if the segment is used in live Composer experience
c1x_visitor_frequency	string	Composer	C1x- User frequency	Segment of visitors based on their visit frequency (number of days with visits): 1 visit day last month, 2 visit days last month, 3-4 visit days last month, 5-9 visit days last month, 10+ visit days last month. Here, “Last month” means “last 30 days” based on the measurement date. Segment values are populated only if the segment is used in live Composer experience
c1x_visitor_interest	array string	Composer	C1x- Visitor interest	The User Interest segment category consists of machine learning generated segments based on the types of content users consume, to segment users based on the type of articles they read most often, and how much they read compared to others reading similar types of content. The 29 interest categories are based on the standard industry taxonomy provided by the IAB organization. Segment values are populated only if the segment is used in live Composer experience
c1x_visitor_recency	string	Composer	C1x- Visitor recency	Segments of visitors by the time since they last visited the site: Active last 24 hours, Active last 1-2 days, Active last 3-7 days, Active last 8-14 days, Active last 15+ days. Segment values are populated only if the segment is used in live Composer experience
card_action	string	Composer	Card action	Type of the card action within a specific Composer experience (\"Show template\", \"Show offer\", \"Show newsletter signup\", \"Show recommendations\", etc.).
card_id	string	Composer	Card ID	Identifier of an action card within a specific Composer experience.
card_name	string	Composer	Card name	Name of the card within a specific Composer experience.
content_authors	string	Composer	Content author	The person who writes the article.
content_publication_date	Date time	Composer	Content publication date	Article publish date.
content_section	String	Composer	Content section	A section is a collection of pages that get defined based on the publisher structure under the content of the article.
conversion_id	string	Composer	Conversion ID	Identifier of a conversion. Conversion is a desirable action taken by the visitor. The conversion itself is not a monetary action.
dynamic_term_internal_renewal_period_count	integer	VX	Dynamic term internal Renewal period count	Ordinal number of renewals within one access period
dynamic_term_external_renewal_period_count	integer	VX	Dynamic term external Renewal period count	Ordinal number of renewals from one access period to another
dynamic_term_billing_index	integer	VX	Dynamic term billing index	Ordinal index of the billing period from the start of the subscription across all access periods that have already passed
dynamic_term_next_external_renewal_flag	boolean	VX	Dynamic term next external renewal flag	Shows that during the next renewal the subscription will jump to the next access period of a dynamic term. Not sending for payment terms
experience_execution_id	string	Composer	Experience Execution ID	The internal ID that relates to the concrete execution of the experience
experience_exposed	boolean	Composer	Is experience exposed?	Is set to TRUE in case the template/offer is loaded on the page.
experience_id	string	Composer	Experience ID	Identifier of the Composer experience.
experience_name	string	Composer	Experience name	Name of the Composer experience.
experience_version	string	Composer	Experience version	Version of the Composer experience.
exp_interaction_type	array string	Composer	Interaction type	Interaction type specifies a visitor's behavior when an element is clicked. Unlike a simple href, which you'd use to create links to external pages, this directive can be used with Piano's custom Angular JS functions. For example, ng-click is commonly used to attach Piano's startCheckout method to the buttons used for selecting terms.
global_experience_id	string	Composer	Global experience ID	Identifier of the global experience. Global experience allows the client management and creation of cross-app Composer experience(s), so the client is not required to switch between dozens of apps to make changes.
global_experience_name	string	Composer	Global experience name	Name of the global experience. Global experience allows the client management and creation of cross-app Composer experience(s), so the client is not required to switch between dozens of apps to make changes.
has_access	array string	Composer	Has access?	Information about whether the visitor has access to any content. Is set to TRUE if the visitor has gained access to any resources via completion of any term (payment, registration, etc.).
meter_card_name	array string	Composer	Meter card name	Name of the pageview meter card within a specific Composer experience. Pageview meter card provides the client with the ability to give visitors a glimpse of the content by allowing a limited number of article views, sessions, or visit days per month.
page_card_name	string	Composer	Pages card name	Name of the very first card within a specific Composer experience. Effective pages card determines which web pages on the client site a given experience can fire on.
pageview_id	string	Composer	Pageview ID	Identifier of page view. Information within the \"event\" scope (several possible values per visit).
pid_event_source	string	Identity	Identity - Event Source	The source of the event that is coming from one of the sources: Any, Publisher, Customer, Social
pid_passwordless	boolean	Identity	Identity - Passwordless enabled	Data point to identify the enablement of the passwordless method by the user.
pid_social_signin	string	Identity	Identity - Social Sign-in method	If the user is using a social sign-in method. Values: EMAIL, FACEBOOK, GOOGLE, LINKEDIN, TWITTER, APPLE
publisher_aid	string	Composer	Publisher AID	Identifier of the Piano application.
segment_path	array string	Composer	Segment path	Names of the user segment cards within a specific Composer experience in sequence. User segment card provides the client with the ability to target specific audience segments with unique offers and custom experiences.
tags_array	array string	Composer	Tags	Freely definable tags for the page, as provided by the publisher.
term	Array object	Composer and VX	Term	Terms are the specifics of the deal you're striking with your audience. They define what a customer is giving you in return for access as well as how long that access lasts.
term_id	Sub-object (string)	Composer and VX	Term ID	ID of the term. Terms are the specifics of the deal you're striking with your audience. They define what a customer is giving you in return for access as well as how long that access lasts.
term_name	Sub-object (string)	Composer and VX	Term Name	Name of the term. Terms are the specifics of the deal you're striking with your audience. They define what a customer is giving you in return for access as well as how long that access lasts.
term_offer_id	string	Composer	Offer ID	Identifier of the offer. An offer is a collection of terms. Each offer can combine terms of different types.
term_offer_name	string	Composer	Offer name	Name of the offer. An offer is a collection of terms. Each offer can combine terms of different types.
term_type	Sub-object (string)	Composer and VX	Term Type	Type of the term. Terms are the specifics of the deal you're striking with your audience. They define what a customer is giving you in return for access as well as how long that access lasts.
template_closable	boolean	Composer	Template closable?	Is set to TRUE in case the close button is shown on the template. Is set to FALSE in case it is not.
template_display_mode	string	Composer	Template display mode	Information about whether the display mode of the template is inline or modal.
template_id	string	Composer	Template ID	Identifier of the template. Template is what a visitor sees during checkout.
template_name	string	Composer	Template name	Name of the template. Template is what a visitor sees during checkout.
template_variant_id	string	Composer	Template variant ID	Identifier of the template variant. Template variant is an iteration of the template that inherits all of their HTML/CSS, and allows for changes via content fields. A single template may have none, one, or multiple variants.
template_variant_name	string	Composer	Template variant name	Name of the template variant. Template variant is an iteration of the template that inherits all of their HTML/CSS, and allows for changes via content fields. A single template may have none, one, or multiple variants.
DEPRECATED term_name_v5	array string	Composer	Term name	Name of the term. Terms are the specifics of the deal you're striking with your audience. They define what a customer is giving you in return for access as well as how long that access lasts.
billing_country_code	string	VX	Billing country code	Short code representing the country or dependent area associated with the transaction. Can be empty if taxes are not configured for the application.
billing_period	string	VX	Billing period	Information on the duration of the period of a subscription not taking trial into account (1 month, 1 year, etc.).
created_via_upgrade	boolean	VX	Created via upgradec?	Is set to TRUE in case the subscription was created upon an upgrade to a different term (e.g. from a monthly to an annual subscription). Is set to FALSE in case there was no upgrade.
external_api_source	string	VX	External API source	Is in use for externally verified term conversions/renewals. An external API source specifies a connection to an external database.
is_full_refund	boolean	VX	Is full refund?	Is set to FALSE in case the refunded amount is lower than the original amount, in other words, in case of a partial refund. Is set to TRUE in case of a full refund.
is_in_trial	boolean	VX	Is in trial?	Is set to TRUE in case the subscription is in a free/paid trial period. Is set to FALSE in case the subscription is out of the trial period, or if there is no trial associated with the subscription.
licensee_id	string	VX	Licensee ID	Identifier of the site license. Site licensing allows any users associated with the contract to redeem access to the client´s site by visiting a landing page and registering. The site license has specified a resource to which access is provided, the maximum number of users who can redeem, as well as a landing page/invitation URL for users to follow.
next_billing_date	date	VX	Next billing date	Nearest date when the user should be charged to have further access. Is set or changed: on renewal, when the grace period is applied, when a user subscription is prolonged on redemption, etc.
next_verification_date	date	VX	Next verification date	Nearest date when the user should be verified to have further access. Is in use for externally verified subscriptions. Is set or changed: on renew, when the grace period is applied, when user subscription is prolonged on redemption, etc.
payment_authentication_required	boolean	VX	Payment - Authentication required	To know if 3DS or any other authentication is required on payment event.
payment_decline_reason	string	VX	Payment - Decline reason	Payment failure decline reason groups the error codes into meaningful categories that the client can take action on. Categories can be for example "Suspected fraud", "Insufficient funds", etc.
payment_error	string	VX	Payment - Error	Error code is an ID of payment failure from the payment provider.
payment_error_description	string	VX	Payment - Error description	Error description of payment failure from the payment provider.
payment_lost_amount_taxfree	decimal	VX	Payment - Lost amount (excl. tax)	Value of failed payment (excluding taxes).
payment_lost_amount_taxincluded	decimal	VX	Payment - Lost amount (incl. tax)	Value of failed payment (including taxes).
payment_provider	string	VX	Payment provider	Third-party integration that assists in accepting a wide range of payment methods and allows the transfer of a transaction from point A to point B safely and securely (Braintree Apple Pay, OBI Credit Card, etc.).
payment_rank	integer	VX	Payment - Rank	Order number of payment charge period since the beginning of subscription. If the initial payment was 0 value trial then it’s excluded from the charge count.
payment_retry_attempt	integer	VX	Payment - Retry attempt	Number between 0 to X defining the payment retry attempt.
pre_refund_transaction_amount	decimal	VX	Pre-refund transaction amount	Original amount paid by the end-user before the refund action. Tax is included.
resource_id	string	VX	Resource ID	Identifier of the resource. The resource is used to control access to content the client is gating. A visitor gains access to a resource by subscribing, registering, entering a promo code, etc.
resource_name	string	VX	Resource name	Name of the resource. The resource is used to control access to content the client is gating. A visitor gains access to a resource by subscribing, registering, entering a promo code, etc.
subscription_action	string	VX	Subscription action	Action that specifies how the behavior of the subscription is changing (Auto-renew enabled, Canceled, Renewed, etc.).
subscription_id	string	VX	Subscription ID	Identifier of the subscription. Subscription is an entity created upon conversion on the term type (Payment, External, Gift, etc.). It is an agreement to receive/give something for a specific period of time.
subscription_period_number	integer	VX	Subscription period number	Is set to 1 on the subscription creation and is increased by 1 when a subscription is renewed (extended). Is decreased by 1 when access is revoked.
term_billing_configuration	string	VX	Term billing configuration	Describes a billing configuration of a term (Subscription / Fixed time period). Applicable for payment terms.
trial_duration	string	VX	Trial duration	Information on the duration of the trial period of a subscription (1 week, 1 month, etc.).
upgrade_to_subscription_id	string	VX	Upgrade to subscription ID	Identifier of the subscription after the upgrade.
upgrade_to_term_id	string	VX	Upgrade to term ID	Identifier of the term after the upgrade.
vx_promotion_name	string	VX	Promotion	Promotion name created in VX
vx_promotion_amount	string	VX	Promotion amount	Monetary promotion amount in VX
vx_promotion_percentage	string	VX	Promotion percentage discount	Percentage promotion discount in VX
vx_promotion_id	string	VX	Promotion ID	ID of promotion created in VX
vx_promo_code	string	VX	Promo code	Promo code value
user_ltc	integer	Composer	C1x - Current LTc (user)	The Likelihood to Cancel segment of subscribers is based on the current likelihood they would cancel their subscription. The segment is broken into 10 categories, with 0 as the least likely to cancel and 9 as the most likely to cancel. Segment values are populated when at least one segment value from LtC is used in live Composer experience
user_brand_relationship	string	Composer	C1x - Current brand relationship (user)	Current segment definition of visitor from C1x segmentation engine: Registered Users, Gift Recipients, Free Trial Users, Paid Trial users, Subscribers, Churned Users. Segment values are populated only if the segment is used in live Composer experience
user_subscription_length	string	Composer	C1x - Current subscription length (user)	Current segment of users based on the terms of their subscription. The segments from this category range: Weekly Subscribers, 4-week subscribers, Monthly subscribers, Quarterly subscribers, Bi-annual subscribers, Annual subscribers. Segment values are populated only if the segment is used in live Composer experience
user_subscription_tenure	string	Composer	C1x - Current subscription tenure (user)	Current segment of users based on the amount of time they have been actively subscribed to the product. Segment values: First 24 hour subscribers, Week 1 subscribers, Week 2 subscribers, Week 3 subscribers, Week 4 subscribers, Month 1-2 subscribers, Month 3-6 subscribers, Month 6+ subscribers. Segment values are populated only if the segment is used in live Composer experience
user_expiring_subscribers	string	Composer	C1x - Currently expiring subscribers (user)	Current users who have disabled the automatic renewal of their subscription payment, and who will terminate their subscription upon the subscription end date. Segment values are populated only if the segment is used in live Composer experience.
experience_type	string	Composer	Experience type	Type of experience that can be created in Composer.
pid_form_id	string	Composer/Identity	Form ID	ID of the Piano Identity form used in Composer experience to collect zero party data or churn reason in the context of Active churn prevention.
pid_form_title	string	Composer/Identity	Form name	Name of the Piano Identity form used in Composer experience to collect zero party data or churn reason in the context of Active churn prevention.
pid_form_field	array object	Composer/Identity	Form fields	List of custom fields of the Piano Identity form used in Composer experience to collect zero party data or churn reason in the context of Active churn prevention.
pid_form_field:pid_form_field_id	string (subproperty)	Composer/Identity	Field ID	ID of the custom field in the Piano Identity form used in Composer experience to collect zero party data or churn reason in the context of Active churn prevention.
pid_form_field:pid_form_field_title	string (subproperty)	Composer/Identity	Field Title	Title of the custom field in the Piano Identity form used in Composer experience to collect zero party data or churn reason in the context of Active churn prevention.
pid_form_field:pid_form_field_value	string (subproperty)	Composer/Identity	Field Value	Submitted value of the custom field by visitor in the Piano Identity form used in Composer experience to collect zero party data or churn reason in the context of Active churn prevention.
has_access_to	Array object	Composer	Has access to	The list of terms & resources which the visitor has access to.
has_access_to:has_access_to_term_id	Sub-object (string)	Composer	Has access to Term ID	Term ID which the visitor has access to. Visitor can gain access to any resource via completion of any term (payment, registration, etc.).
has_access_to:has_access_to_term_name	Sub-object (string)	Composer	Has access to Term name	Term name which the visitor has access to. Visitor can gain access to any resource via completion of any term (payment, registration, etc.).
has_access_to:has_access_to_term_type	Sub-object (string)	Composer	Has access to Term type	Term type which the visitor has access to. Visitor can gain access to any resource via completion of any term (payment, registration, etc.).
has_access_to:has_access_to_resource_id	Sub-object (string)	Composer	Has access to Resource ID	Resource ID which the visitor has access to. Visitor can gain access to any resource via completion of any term (payment, registration, etc.).
has_access_to:has_access_to_resource_name	Sub-object (string)	Composer	Has access to Resource name	Resource name which the visitor has access to. Visitor can gain access to any resource via completion of any term (payment, registration, etc.).

Metrics

Either native to Piano Analytics’ standard data model and applicable for Composer Insights clients or implemented as a part of Composer Insights implementation:

Metric name	Tag	Definition
Bounce rate	ATI standard	Ratio between bounces and all visits.
Bounces	ATI standard	Number of visits with less than 2 pages (0 or 1, regardless of the number of events).
Conversions (pages)	ATI standard	Number of page loads for pages defined as the main goal.
Conversion rate	ATI standard	Ratio between the number of visits converted to the main goal and the total number of visits.
Conversion rate (user)	ATI standard	Ratio between the number of users who converted to the main goal and the total number of users. Calculation: converted users / users.
Converted users	ATI standard	Number of users who have converted to the main goals
Conversion rate (visitor)	ATI standard	Ratio between the number of visitors who converted to main goals and the total number of visitors. Calculation: Converted visitors / Visitors.
Converted visitors	ATI standard	Number of visitors who converted to the main objective
Converted visits	ATI standard	Number of visits that have loaded the main goal page at least once.
Conversions	ATI standard	Number of events where goal type is defined
Days	ATI standard	Number of days with traffic.
Entering visits	ATI standard	Number of visits with at least 2 page loads.
Entry rate	ATI standard	Ratio between entering visits (with 2 page views and more) and all page visits. Calculation: Entering visits / Visits.
Events	ATI standard	Number of times an event occurred.
Events (all)	ATI standard	Number of events counted, including excluded events.
Page views	ATI standard	Number of times a page has been loaded. If the analyzed element was not present on a page, the value of this metric will necessarily be 0. This metric has an Event scope and should not be confused with the "Pages Views (visits)" metric (which gives all the pages viewed during a visit, without relation to the analyzed page)
Page views / visit	ATI standard	Average number of page loads that occur during a visit. Calculation: page views / visits
Time spent	ATI standard	Total time spent on site. This metric is expressed in milliseconds.
Time spent (pages)	ATI standard	Cumulative time spent on pages. Calculation: Sum of inter-pages durations. Excludes bounced visit pages and last visit pages. This metric is expressed in seconds.
Time spent / event	ATI standard	Average time spent between events. Calculation: Time spent / number of events with duration
Time spent (page) / page	ATI standard	Time spent on the same page on average per page. Calculation: Cumulation of the durations of a page P / Loads of this page P (with duration). Excludes bounced visit pages and last visit pages. This metric has a Page range and is expressed in seconds.
Time spent / user	ATI standard	Average time spent on the site by users (visitors who have been identified).
Time spent / user (pages)	ATI standard	Average time spent on the site by visitors (those who have made at least 2 page loads within a visit).
Time spent / visitor	ATI standard	Average time spent on the site by visitors (those who have made at least 1 visit).
Time spent / visitor (pages)	ATI standard	Average time spent on the site by visitors (those who have made at least 2 page loads within a visit).
Time spent / visit	ATI standard	Average duration of visits to the site. Calculation: cumulative time spent / visits with duration. This metric has a Visit range and is expressed in milliseconds.
Time spent / visit (pages)	ATI standard	Average duration of visits to the site. Calculation: cumulative time spent / visits with duration. Visits without duration are excluded from this calculation. This metric has a Visit range and is expressed in seconds.
Visitors	ATI standard	Number of visitors (each people recognized mainly with a cookie and who has made at least 1 visit). These visitors are distincts on the period.
Users	ATI standard	Number of users (identified visitors). These users are quite distinct over the period.
Visits	ATI standard	A visit is defined as a set of events that occurred on your site ("onsite" event) by the same visitor. If no event is measured during a defined period of time (usually 30 minutes), the visit ends.
Visits / user	ATI standard	Average number of visits per user (identified visitors).
Visits / visitor	ATI standard	Average number of visits per visitor.
Average exposure (page)	Composer	Average number of experience exposure events per page views (with exposure). Calculation: Experience exposures / Page views with exposure.
Average exposure (visitor)	Composer	Average number of experience exposure events per experience exposed visitors. Calculation: Experience exposures / Experience exposed visitors.
Experience action visitors	Composer	Total number of visitors with at least one experience action (execution & exposure). Calculation: All distinct visitors have experience.action event.
Experience actions	Composer	Total number of experience action events (execution & exposure). Calculation: Count the number of experience.action events.
Experience actions / visitor	Composer	Average number of experience.action events (executions & exposures) per experience targeted visitor. Calculation: Experience actions / Experience action visitors.
Experience adblock disabled visitors	Composer	Total number of visitors with at least one experience Adblock disablement for all terms. Calculation: All distinct visitors have composer.conversion event with Goal type "Adblock disabled" and Experience ID assigned.
Experience completion rate (visitor)	Composer	Overall experience completion rate calculated on visitor level. Calculation: Experience converted visitors / Experience interaction visitors.
Experience conversion rate (visitor)	Composer	Overall experience conversion rate (for all terms) calculated on visitor level. Calculation: Experience converted visitors / Experience exposed visitors.
Experience conversions	Composer	Total number of experience conversion events for all terms. Calculation: Count the number of vx.conversion and composer.conversion events with Experience ID assigned.
Experience converted visitors	Composer	Number of visitors with at least one experience conversion for all terms. Calculation: All distinct visitors having composer.conversion or vx.conversion event with Experience ID assigned.
Experience CTR	Composer	Average number of experience interaction events (template & offer clicks except "close button" clicks) and experience exposure events. Calculation: Experience interactions / Experience Exposures.
Experience CTR (visitor)	Composer	Overall click-through rate calculated on visitor level. Calculation: Experience interaction visitors / Experience exposed visitors.
Experience custom converted visitors	Composer	Total number of visitors with at least one experience custom conversion for all terms. Calculation: All distinct visitors having or vx.conversion event with Goal type "Custom term converted" and Experience ID assigned.
Experience exposed visitors	Composer	Total number of visitors with at least one experience exposure. Calculation: All distinct visitors have experience.action event with property "Is experience exposed?" set to TRUE.
Experience exposures	Composer	Total number of experience exposure events. Calculation: Count the number of experience.action events with property "Is experience exposed?" set to TRUE.
Experience interaction visitors	Composer	Total number of visitors with at least one experience interaction (template & offer click except for "close button" click). Calculation: All distinct visitors have experience.interaction event
Experience interactions	Composer	Total number of experience interaction events (template & offer clicks except "close button" clicks). Calculation: Count the number of experience.interaction events
Experience payment converted visitors	Composer	Total number of visitors with at least one experience payment conversion for all terms. Calculation: All distinct visitors having vx.conversion event with Goal type "Payment term converted" and Experience ID assigned.
Experience registration converted visitors	Composer	Total number of visitors with at least one experience registration conversion for all terms. Calculation: All distinct visitors having vx.conversion event with Goal type "Registration term converted" and Experience ID assigned.
Experience turnover	Composer	Sum of all amounts associated with experience conversion event paid by visitors. Calculation: Sum of all values for the property "Amount (incl. tax)" for composer.conversion and vx.conversion event with Experience ID assigned.
Experience turnover / visitor	Composer	Average amount associated with experience conversion event paid by the visitor. Calculation: Experience turnover / Experience converted visitors.
ID - Users already logged in	Identity	Identified users who didn't use the login page during the time period analyzed.
ID - Users logging in	Identity	Number of unique users logging into the site. These login actions are managed by Piano Identity. Note that a user can already be logged in and then not use the login action.
ID - Users already logged in rate	Identity	Ratio of users already connected to all users.
ID - Reset password requests	Identity	Number of requests to reset password through an email link. This action is managed by Piano Identity.
ID - Reset password successes	Identity	Number of password resets that were successful. This action is managed by Piano Identity.
ID - Login frequency	Identity	Average number of login events per user logging in on the site.
ID - New accounts	Identity	Number of new accounts created with Piano Identity.
ID - Accounts deleted	Identity	Number of deleted accounts with Piano Identity due to Privacy compliance requests.
ID - Login events	Identity	Number of user login actions on the site. These login actions are managed by Piano Identity.
ID - Session expirations	Identity	Number of forced user logout actions due to session expiration. These expirations are managed by Piano Identity.
ID - Reset password success rate	Identity	Ratio between password reset success and password reset request.
Canceled subscriptions	VX	Number of subscriptions that were lost due to cancellation by the owner or admin. The associated access was revoked immediately. Calculation: Distinct subscription IDs for subscription.action event (onsite and offsite) with property "Subscription action" = "Canceled".
Complete subscription upgrades	VX	Number of successfully completed subscription upgrades. Calculation: Distinct subscription IDs for subscription.action event (onsite and offsite) with property "Subscription action" = "Upgrade completed".
Expired subscriptions	VX	Number of subscriptions that were lost because the auto-renew had been disabled prior to the renewal billing attempt, or due to an unsuccessful external verification attempt. Calculation: Distinct subscription IDs for subscription.action event (onsite and offsite) with property "Subscription action" = "Expired".
Failed subscription renewals	VX	Number of subscriptions that were lost due to a failed renewal attempt. No further renewal attempt will be performed. Calculation: Distinct subscription IDs for subscription.action event (onsite and offsite) with property "Subscription action" = "Renewal failed, will not retry".
Failed subscription upgrades	VX	Number of subscriptions that were lost due to a failed subscription upgrade. Calculation: Distinct subscription IDs for subscription.action event (onsite and offsite) with property "Subscription action" = "Upgrade failed"/"Upgrade failed, will not retry".
Lost subscriptions	VX	Number of lost subscriptions (excl. successfully performed upgrades). Calculation: Distinct subscription IDs for subscription.action event (onsite and offsite) with property "Subscription action" = "Canceled"/"Expired"/"Renewal failed, will not retry"/"Upgrade failed"/"Upgrade failed, will not retry".
Net new subscriptions	VX	Difference between new and lost subscriptions. Calculation: New subscriptions - Lost subscriptions.
New subscriptions	VX	Number of new subscriptions (excl. those created via upgrade). Calculation: Distinct subscription IDs for vx.conversion event (onsite and offsite) with property "Created via upgrade?" = FALSE.
New VX turnover	VX	Amount of money obtained from successful monetary transactions associated with a conversion. Calculation: Sum of all values for the property "Amount (incl. tax)" for vx.conversion event (onsite and offsite).
Refunded VX turnover	VX	Amount of money refunded on previously successful monetary transactions. Calculation: Sum of all values for the property "Amount (incl. tax)" for transaction.refund.offsite event.
Refund VX ratio	VX	Average percentage of a refund. Calculation: Sum of all values for the property "Amount (incl. tax)" for transaction.refund.offsite event / Sum of all values for the property "Pre-refund transaction amount" for transaction.refund.offsite event.
Refunds	VX	Number of refunded monetary transactions. Calculation: Count the number of transaction.refund.offsite events.
Renewal VX turnover	VX	Amount of money obtained from successful monetary transactions associated with renewal. Calculation: Sum of all values for the property "Amount (incl. tax)" for subscription.action event (onsite and offsite) with "Subscription action" = "Renewed".
Renewed subscriptions	VX	Number of subscriptions renewed into their next billing period. Calculation: Distinct subscription IDs for subscription.action event (onsite and offsite) with property "Subscription action" = "Renewed".
Successful transactions	VX	Number of successful monetary transactions. Calculation: Distinct "Transaction ID" assigned to the events vx.conversion and subscription.action (onsite and offsite).
VX turnover	VX	Amount of money obtained from successful monetary transactions. Calculation: Sum of all values for the property "Amount (incl. tax)" for the events vx.conversion and subscription.action (onsite and offsite).
Active churn prevention exposures	Composer	Number of templates or offers exposed to subscribers on the active churn attempt.
Active churn prevention exposed users	Composer	Number of unique users exposed to templates or offers on the active churn attempt.
Form exposures	Composer/Identity	Number of times the form was exposed (To be more explicit)
Form submissions	Composer/Identity	Number of times the form was submitted (To be more explicit)
Form submission rate	Composer/Identity	Form submission rate is to evaluate the success of filled forms.
Subscribers with active churn	Composer/Identity	Number of subscribers (users) who turned off autorenewals on subscriptions or immediate subscription cancellations
Subscribers prevented active churn	Composer/Identity	Ratio of disabled autorenewals or churns out of all subscribers attempting to churn
Subscribers active churn rate	Composer/Identity	Ratio of disabled autorenewals or churns out of all subscribers attempting to churn
Subscribers prevented active churn rate	Composer/Identity	Ratio of subscribers who had in the beginning intention to cancel subscription or turn off autorenewal but abandon the churn flow and continue to be subscribers

Events with Properties

Matrix of events with their corresponding properties:

Property name

Tag

identity.
create

identity.
delete

identity.
login

identity.
logout

identity.
password.
reset.
requested

identity.
password.
reset.success

identity.
password.
updated

identity.
session.
expire

page.

display

experience.

action

experience.

interaction

composer.

conversion

vx.

conversion

vx.

conversion.

offsite

transaction.

refund.

offsite

subscription.

action

subscription.

action.

offsite

identity.

form.

exposure

identity.

form.

submit

Event

Audience

Event timestamp

Audience

Event timestamp (UTC)

Audience

Site

Audience

User ID

Audience

Visit ID

Audience

Transaction ID

E-commerce

Transaction status

E-commerce

Goal type

E-commerce

Amount (incl. tax)

E-commerce

Amount (excl. tax)

E-commerce

Collection currency

E-commerce

Payment method

E-commerce

City

Geolocation

Continent

Geolocation

Country

Geolocation

Latitude

Geolocation

Longitude

Geolocation

Sub-region

Geolocation

Region

Geolocation

Identity - Event source

Identity

Identity - Passwordless enabled

Identity

Identity - Social sign-in method

Identity

Page

Pages

Content Author

Composer

Content Publication Date

Composer

Content Section

Composer

Tags Array

Composer

UTM Campaign

Sources

UTM Content

Sources

UTM Medium

Sources

UTM Source

Sources

UTM Term

Sources

Browser

Technology

Cookie accepted?

Technology

Browser - Group

Technology

Browser - Version

Technology

ISP

Technology

Connection organisation

Technology

Device - Brand

Technology

Device - Marketing name

Technology

Device - Technical name

Technology

OS - Group

Technology

OS version

Technology

Cumulated conversions (user)

User

Cumulated days (user)

User

Cumulated time spent (user)

User

Cumulated page views (user)

User

Cumulated order value (user)

User

Cumulated visits (user)

User

User frequency

User

First campaign (user)

User

First access date (user)

User

First source (user)

User

Last access date (user)

User

Browser ID

Composer

C1x- Brand relationship

Composer

C1x- Checkout abandonment

Composer

C1x- Expiring subscribers

Composer

C1x- LTc

Composer

C1x- LTs

Composer

C1x- Likelihood to Return

Composer

C1x- Likelihood to Register

Composer

C1x- Content Likely to Convert

Composer

C1x- Revenue Auto-Optimization

Composer

C1x- Subscription Length

Composer

C1x- Subscription tenure

Composer

C1x- User frequency

Composer

C1x- Visitor interest

Composer

C1x- Visitor recency

Composer

Card ID

Composer

Card name

Composer

Card action

Composer

Dynamic term internal Renewal period count

Dynamic term external Renewal period count

Dynamic term billing index

Dynamic term next external renewal flag

Experience ID

Composer

Experience name

Composer

Experience version

Composer

Has access

Composer

Interaction type

Composer

Is experience exposed?

Composer

Meter card name

Composer

Offer ID

Composer

Offer name

Composer

Pages card name

Composer

Pageview ID

Composer

Publisher AID

Composer

Segment path

Composer

Template closable?

Composer

Template display mode

Composer

Template ID

Composer

Template name

Composer

Template variant ID

Composer

Template variant name

Composer

Term ID

Composer and VX

Term name

Composer and VX

Term Type

Composer and VX

Billing country code

Billing period

Created via upgrade?

External API source

Is full refund?

Is in trial?

Licensee ID

Next billing date

Next verification date

Payment - Authentication required

Payment - Decline reason

Payment - Error

Payment - Error description

Payment - Lost amount (excl. tax)

Payment - Lost amount (incl. tax)

Payment provider

Payment - Rank

Payment - Retry attempt

Pre-refund transaction amount

Promotion

Promotion amount

Promotion code

Promotion ID

Promotion percentage discount

Resource ID

Resource name

Subscription action

Subscription ID

Subscription period number

Term billing configuration

Trial duration

Upgrade to subscription ID

Upgrade to term ID

event_time_utc

Composer/ID

page_title_html

Composer/ID

content_authors

Composer/ID

content_publication_date

Composer/ID

content_section

Composer/ID

page_content_type

Composer/ID

tags_array

Composer/ID

pageview_id

Composer/ID

user_id

Composer/ID

experience_id

Composer/ID

experience_execution_id

Composer/ID

experience_name

Composer/ID

experience_version

Composer/ID

experience_type

Composer/ID

card_id

Composer/ID

card_name

Composer/ID

card_action

Composer/ID

browser_id

Composer/ID

goal_type

Composer/ID

publisher_aid

Composer/ID

template_id

Composer/ID

template_name

Composer/ID

template_variant_id

Composer/ID

template_variant_name

Composer/ID

template_closable

Composer/ID

template_display_mode

Composer/ID

c1x_visitor_recency

Composer/ID

c1x_visitor_interest

Composer/ID

c1x_visitor_frequency

Composer/ID

c1x_brand_relationship

Composer/ID

c1x_subscription_tenure

Composer/ID

c1x_expiring_subscribers

Composer/ID

c1x_checkout_abandonment

Composer/ID

c1x_ltc

Composer/ID

c1x_lts

Composer/ID

c1x_likelihood_to_return

Composer/ID

c1x_likelihood_to_register

Composer/ID

c1x_content_likely_to_convert

Composer/ID

c1x_revenue_auto_optimization

Composer/ID

pid_form_id

Composer/ID

pid_form_title

Composer/ID

pid_form_field

Composer/ID

pid_form_field_id

Composer/ID

pid_form_field_title

Composer/ID

pid_form_field_value

Composer/ID

has_access_to

Composer/ID

has_access_to:has_access_to_term_id

Composer/ID

has_access_to:has_access_to_term_name

Composer/ID

has_access_to:has_access_to_term_type

Composer/ID

has_access_to:has_access_to_resource_id

Composer/ID

has_access_to:has_access_to_resource_name

Composer/ID

Events

Properties

Metrics

Events with Properties

Articles in this section