--- version: "Working version" language: "en" --- # Analytics ## Analytics Precision, compliance and flexibility in one unified solution [Get Started](https://analytics-docs.piano.io/en/analytics/v1/piano-analytics-user-interface.md) ### Quick Links * #### [API](https://analytics-docs.piano.io/en/analytics/v1/api.md) Developer documentation for the Piano Analytics API. * #### [Analytics Release Notes](https://analytics-docs.piano.io/en/analytics/v1/analytics-release-notes.md) Discover what's new in Piano Analytics. * #### [FAQs](https://analytics-docs.piano.io/en/analytics/v1/faq-piano-analytics.md) Browse frequently asked questions about Piano Analytics. Access Rights (FAQ) Activation Insights (FAQ) Administration (FAQ) Ad Revenue Insights (FAQ) API v3 (F... ### Explore documentation #### [Piano Analytics interfaces](https://analytics-docs.piano.io/en/analytics/v1/piano-analytics-user-interface.md) #### [Piano Analytics modules](https://analytics-docs.piano.io/en/analytics/v1/piano-analytics-modules.md) #### [PA Connect](https://analytics-docs.piano.io/en/analytics/v1/pa-connect.md) #### [Privacy center](https://analytics-docs.piano.io/en/analytics/v1/privacy-center.md) #### [Analytics Training courses](https://analytics-docs.piano.io/en/analytics/v1/certifications-and-formations.md) #### [Analytics Consulting Services](https://analytics-docs.piano.io/en/analytics/v1/analytics-consulting-services.md) #### [FAQs](https://analytics-docs.piano.io/en/analytics/v1/faq-piano-analytics.md) #### [Video tutorials](https://analytics-docs.piano.io/en/analytics/v1/video-tutorials.md) --- version: "Working version" language: "en" --- # 3rd party connectors ## Snowflake's integration catalogue You can connect third party tools from Snowflake's integration catalogue to your raw Piano Analytics data. The Snowflake ecosystem is made up of more than 70 native integrations - BI, Data Science, Data Visualisation, Security, Data Integration, ETL... ![image-20241104-102426.png](https://analytics-docs.piano.io/__attachments/a_c79cc7c211f0e5657392df4f4cddffb2601aa0655d352aa0ddd8c91ea1bacb4f/image-20241104-102426.png?cb=8045467ef93b59e212023a4c970c4f0b) ### Example integration between Tableau and Snowflake using Data Sharing ![image-20241104-102406.png](https://analytics-docs.piano.io/__attachments/a_737334c86cd61e3996f6ce28b66964ae5881f53f496f1d6fed961ad96d2b523a/image-20241104-102406.png?cb=6e3094d05a95d016bc98e1f20bc89041) *Tableau's native integration with Snowflake using Data Sharing* Implement this integration in two steps: * Reach out to your account manager to subscribe to Piano Analytics' Data Sharing product. * In Tableau: select the Snowflake native connector and enter the server name, Snowflake login and password as per the video below. --- version: "Working version" language: "en" --- # A/V Insights * [Introduction to A/V Insights](https://analytics-docs.piano.io/en/analytics/v1/introduction-to-a-v-insights.md) --- version: "Working version" language: "en" --- # AB Tasty ## About AB Tasty AB Tasty is an A/B testing solution that's simple and intuitive. AB Tasty enables you to modify the pages of a website or a mobile application without any technical knowledge in order to conduct A/B tests. The solution also offers an audience segmentation tool to personalise navigation experiences and content. Other analysis tools enrich this suite: session replay, heatmaps, sales animation, notifications, email collection, etc. Learn more: ## Interconnect AB Tasty \& Piano Analytics AB Tasty and *Piano Analytics* have developed a module enabling you to automatically tag your testing campaigns in order to display results in your analytics solution. This integration enables you to track the performance of different populations (original, variation A, variation B, etc.) and to study your visitors' behaviour in detail (segmentation, retention, cohorts, etc.). AB Tasty uses the *Piano Analytics* "**MV Testing** " tagging module to track A/B test displays. (more info here: [https://developers.atinternet-solutions.com/piano-analytics/data-collection/how-to-send-events/standard-events#mv-testing)](https://developers.atinternet-solutions.com/piano-analytics/data-collection/how-to-send-events/standard-events#mv-testing) ### Note There are several versions of this connector, compatible with the different versions of your tag: * "AT Internet" (*xtcore*SDK) * "AT Internet SmartTag" (*SmartTag*SDK) * "Piano Analytics" (*Piano Analytics*SDK) ![schéma update.png](https://analytics-docs.piano.io/__attachments/a_52031ce8ba02cc41be6a9d20dd2e8ef2eee0462a81fdbc7525d5a650d6947359/19865500834322?cb=5f7ab0db6b17e5c1f109972e70bd6ea3) ### Enable *Piano Analytics* tagging in the AB Tasty interface The process is simple -- connect to your AB Tasty interface, go to the [Integrations](https://app2.abtasty.com/settings/integration/third-party-tools) configuration page and activate the *Piano Analytics* connector. ![21018683001106](https://analytics-docs.piano.io/__attachments/a_719f0ef19124a3ecdb8dd894b61167ed94901302a63a91e5dc3498af9afb9cba/21018683001106?cb=da4d904ca4c3bff7cbf5259acd9ba333) When you activate the integration, the interface prompts you to enter a wave number. This variable enables you to add an extra level of granularity to your analysis, should you wish to distinguish between several versions of your campaign, for instance. You can also fill in this field arbitrarily with any integer. Once this configuration has been set, integration will be automatically activated for your new A/B test campaigns. To activate it for your existing campaigns, go to the advanced campaign options and select the *Piano Analytics* connector. ![21018697171474](https://analytics-docs.piano.io/__attachments/a_ccf08a6b30f675fac5234a95a871f63d02e2b386c47a76e74e23615e43d45467/21018697171474?cb=5979292e567337dda17edf1604f74c6c) ## Analyse your AB testing performance Once *Piano Analytics* tagging has been activated on your AB Tasty campaigns, you will be able to view the results from Explorer's "**Content \> MV Testing** " analysis, or from any application in the *Piano Analytics* suite. The connector feeds the following properties from the "mv_test.display" event: ![21018697171986](https://analytics-docs.piano.io/__attachments/a_81ddc019acb285f66440f230a7cc2c0602c423cb0bfa386f0528c5bc6688a243/21018697171986?cb=e944a26b297fe23fd03bbdb329008632) ## Export your Piano Analytics audiences (segments) You can export your Piano Analytics audiences to AB Tasty. To benefit from the segment Pull integration, you must first create an API Key from your Piano Analytics profil ([documentation](https://support.piano.io/hc/en-us/articles/4466006444306-API-Keys)). Next, you'll need to declare a new property in your Piano Analytics data model, which will contain AB Tasty's visitor ID. This ID will be the matching key, so that AB Tasty can correctly identify the users of your Piano Analytics segments in their solution. Here's the property to declare: ![capture process segment import.png](https://analytics-docs.piano.io/__attachments/a_3884cdba969ac62b24ba93189f11359f352bf86e665c59d9238c31e17ad4a5bd/19864895691794?cb=112d883f98b62e102f9c56bcc32b3576) Remember to enter the exact same "abtasty_visitor_id" key, to ensure a perfect matching with the AB Tasty tag. Also remember to select the "Visit" scope so that your AB Tasty's visitor ID is present in every event of the visit for each of your visitors. You will then need to get your site ID, available from the [Data Collection Portal](https://collection.atinternet-solutions.com/#/dashboard) : ![17476793262226](https://analytics-docs.piano.io/__attachments/a_5c732e5319a89606f7d7b90eb9a8c7e6abe569ab7248a18a0eba7553f334e70f/17476793262226?cb=dc0b635dbe186b44024ceac8ce42268e) Then go to the AB Tasty interface and follow the steps below: 1. Access **Integrations \> Integration Hub \> Pull**. 2. Search for and select **Piano Analytics**. 3. Click **Setup connector.** ![17476793269778](https://analytics-docs.piano.io/__attachments/a_b1e90ed218d66278dac9e48eb43e87c167a708507e7b29f14a9bfd0360945173/17476793269778?cb=bd3a83a58042034cc01ca49b02e91ac8) 4. Give the connector a name so you can find it easily, then enter your API key in *accesskey_secretkey* format*,* as well as your Site ID: ![17476793282706](https://analytics-docs.piano.io/__attachments/a_7fc54c0df6029b53f0dfa990c0c48d9481f232b08b1a1b3ba7c1f2e44cce557e/17476793282706?cb=8c31cb4c097705fed554d6f3abb8659c) Piano Analytics is now set up. No other action is required here. This will allow AB Tasty to display the audiences that will be sent by Piano Analytics. Once you have activated and configured an integration, you can retrieve your segment traits in the segment builder (available when you create a new segment). ![12111719195036](https://analytics-docs.piano.io/__attachments/a_e25b0bc8455c308f83c32a589216db9ab189b0ffdb2dfadf967cc201f007ca29/12111719195036?cb=17d8fc2c3fd00ce75eec57ef1d8fcc06) For more details, please consult the official AB Tasty documentation : ## Privacy Activating this partnership activates the import of AB Tasty data into *Piano Analytics* tools. Only the data necessary for the proper functioning of the bridge are imported. ## Additional resources * Partner's website: * Partner's documentation: --- version: "Working version" language: "en" --- # About Workspaces ## Introduction Workspaces are a new way to get the most out of Piano Analytics data. Workspaces make it easy for analysts and business users to collaborate and get insights, regardless of their skill level. * **Effortlessly create and share boards**: Workspaces make it quick and easy to create and share boards that combine Piano Analytics' out-of-the-box and custom reports. * **Easily meet diverse data and reporting requirements**: Workspaces are highly flexible and can be customized to meet the needs of any team. * **Empower end users to make better decisions**: Workspaces give business users the power to analyze data and turn it into actionable insights without having to be analysts. ## Overview ![image-20260729-083536.png](https://analytics-docs.piano.io/__attachments/a_88f1e7afabae4abe73f7388183ff6e67f3d4c00fcf4c50bcba064f6429379c02/image-20260729-083536.png?cb=f79b48e413db31afd2d5d5566576e08e) ## Access Rights ### Editing * Only users with a "Manage data" role or higher can create a board or a workspace. * Only the editors of a board (or the administrator of the organization) can edit, share or delete that board. ### Viewing ➡️ Public boards: * All users, regardless of their role, can view a public board. * Private reports incorporated into a public board are visible to all users who view it. They cannot be viewed outside the board. ➡️ Private boards: * Only the owners of a private board can view it. ## Manage the Workspaces bar The Workspaces bar corresponds to the list of Workspaces displayed on the left. From it, you can create Workspaces, control which ones appear, set a default, and change their order. ### Create a Workspace To create a new Workspace, click the **"+"** button on the Workspaces bar, on the left. ![image-20260729-083256.png](https://analytics-docs.piano.io/__attachments/a_23352f31382453e47e38607250c592240c7ca7a8d029371e2840aaea5e96a5d8/image-20260729-083256.png?cb=e06cbe46878392ece72ac05f16297c25) ### Reorder the Workspaces You can change the order in which Workspaces appear in the bar: 1. Open the hamburger menu (the three horizontal lines above the list of Workspaces). 2. Click the edit pencil. 3. Hover over the Workspaces --- drag-and-drop icons appear on the left. 4. Drag a Workspace to the position you want and drop it. ### Set a default Workspace You can define a Workspace to open automatically each time you launch Piano Analytics. This lets you skip the manual selection step and land directly on the Workspace you use most often. Your default Workspace is a **personal preference** --- it only affects your own experience and doesn't change what other users see. To set a Workspace as your default: 1. Open the **hamburger menu** (the three horizontal lines above the list of Workspaces). 2. Click the **edit**pencil. 3. Hover over the Workspace you want to set as default. A **"..."** icon appears at the end of the Workspace name. 4. Click the **"..."** icon and select **Set as default Workspace**. ![Animation13-20260702-100747.gif](https://analytics-docs.piano.io/__attachments/a_0a128bd7366a4a05819dcbdc425d92cdcbcd524f5f8880ed5e6b6ef5be9d0b63/Animation13-20260702-100747.gif?cb=97bd5704e0697789ff423e7f99d5f7c4) The next time you access Piano Analytics, this Workspace will load automatically. You can change your default at any time by repeating these steps with a different Workspace. ### Remove a Workspace from the bar Removing a Workspace from the bar takes it off your list but does not delete it --- you can add it back at any time. 1. Open the hamburger menu. 2. Click the edit pencil. 3. Hover over the Workspace you want to remove. A **"..."** icon appears at the end of the Workspace name. 4. Click the **"..."** icon and select **Remove**. ![image-20260729-083731.png](https://analytics-docs.piano.io/__attachments/a_08a46bf452e123fc1fff5e744add8f98988929587d865827728ffd7b483f8756/image-20260729-083731.png?cb=7e5c6d9ab3f1fc845ef286c9b3887e51) ### Add a Workspace back to the bar If you previously removed a Workspace, you can add it back to the bar: 1. Open the Workspace from the Library. 2. In the Workspaces bar, a **"+"** button appears. 3. Click the **"+"** button to add the Workspace back to the bar. --- version: "Working version" language: "en" --- # Access security ## Introduction Administrators can control access to the Solution via a list of authorized IPs. Once the feature is activated, only users in the organization who log in with one of the specified IPs will be able to access Piano Analytics. ### Note This feature is only available to the organization's administrators, excluding delegated administrators. ## Application scope By default, there are no IP address restrictions for access to the Piano Analytics solution. The organization's administrator has the option of limiting access by expressly declaring the permitted IP addresses in the form of rules. One rule applies to the entire organization: * Access to the Piano Analytics solution and API Data calls are restricted according to the rules defined by the administrators * All Piano Analytics suite products are affected by the application of the rules ### Note SSO user access is also subject to this rule. ## Creating a rule Authorizations are configured in the "Access Management" application, then in the Security \> Permitted IP addresses submenu. Administrators can declare IP addresses in three IP/CIDR/RANGE formats: * IP: in the following format: 192.0.2.1 * CIDR: IP address grouping in the following format: 192.0.2.0/24 * RANGE IP: range of IP addresses, in the following format: 192.0.2.1 - 192.0.2.255 ### Be careful! The administrator must declare their own IP address (displayed in the interface) when creating the first rule: a check is made at the time of validation and a warning message appears if necessary. Steps: 1. Choose the type of IP address 2. Declare the value(s) 3. Define a name for the rule ![image-20241004-100629.png](https://analytics-docs.piano.io/__attachments/a_b25bc5dab07dd72804fdef99220ea4a516b63b7b0df3f268833a1ec193a32cb3/image-20241004-100629.png?cb=f7e21c4889fa20567c485364bbd1192a) #### Be careful! Only public IP addresses can be declared in a rule. After being created, the rule appears in the list with: * the type (IP/CIDR/RANGE) * the value(s) * the name of the rule * the email of the administrator who created it * the creation date Once the permissions are activated, any user attempting to connect to the Piano Analytics solution or make an API Data call will be denied access (HTTP 403 error) if their IP address is not one of the permitted addresses. ## Deleting a rule A rule cannot be edited but can be deleted by clicking on the trash can icon in the listing table. ![image-20241004-100646.png](https://analytics-docs.piano.io/__attachments/a_af5693c18676ff2948a512b717f365f58febdefef17b19276017df3301e36b10/image-20241004-100646.png?cb=5b7d955d00a96bd24b3fc8d7dc605e9e) --- version: "Working version" language: "en" --- # Access & security management * [Organisations](https://analytics-docs.piano.io/en/analytics/v1/organisations.md) * [Delegations](https://analytics-docs.piano.io/en/analytics/v1/delegations.md) * [Users](https://analytics-docs.piano.io/en/analytics/v1/users.md) * [Sites](https://analytics-docs.piano.io/en/analytics/v1/sites.md) * [Teams](https://analytics-docs.piano.io/en/analytics/v1/teams.md) * [Access management API](https://analytics-docs.piano.io/en/analytics/v1/user-management-api.md) * [Multi-Factor Authentication (MFA)](https://analytics-docs.piano.io/en/analytics/v1/multi-factor-authentication-mfa.md) * [Enterprise Single-Sign-On (SSO)](https://analytics-docs.piano.io/en/analytics/v1/enterprise-single-sign-on-sso.md) * [Access security](https://analytics-docs.piano.io/en/analytics/v1/access-security.md) --- version: "Working version" language: "en" --- # Accessing and editing scheduled exports [Accessing and editing scheduled exports.mp4](https://analytics-docs.piano.io/__attachments/a_4f01a454904da3c8615e2a06e6ede619dbf00cb8ab7cca06e776700576cebe0a/Accessing%2520and%2520editing%2520scheduled%2520exports.mp4.md?cb=a4f36d7b218231b90a5e0f2c41528082) --- version: "Working version" language: "en" --- # Accessing & creating new data flows ## Create multiple Flows for an unlimited number of use cases Data Flow consists of a point-and-click user interface enabling you to create various flows to share granular data in the right format to the right stakeholders. ![Flows.png](https://analytics-docs.piano.io/__attachments/a_da1888bd8f9ee9884be8029c755cb8595a9890a9c3b2648bd99ea29894a0347b/8281621869970?cb=e2757fbd3c6823d488b0e741c64bbac8) ## Subscribing to Data Flow Data Flow is a paid option that can be activated on your organization. In order to access Data Flow reach out to your account manager via your administrator or contact our consulting team. ## Interface ### Creating a new data flow Flows can be configured directly from our Export interface, in the form of scheduled exports (++*Menu \> Configuration \> Exports*++). A dedicated interface will enable you to configure your data flows. You will be able configure the following aspects of your data flows: * **Cross-site:**Select a site, several sites or all the sites belonging to your organization * **Properties:**Choose which properties you wish to include in your exports (standard and custom). * **Format:**Choose the type of separator and the export format -- between CSV, JSON, PARQUET. * **Schedule:**Choose the export frequency - 15, 30 or 60 minutes * **Export location:**Choose the location of the export, sFTP, Amazon S3 ## Accessing to the Data Flow interface To connect to the *Data Flow* interface, go to the [*Export*](https://analytics.piano.io/exports/#/planned-documents)[app](https://apps.atinternet-solutions.com/Exports/): ![Data_Flow_delta.png](https://analytics-docs.piano.io/__attachments/a_bbc5bdf22da75e048af71b5a5a8aba1ba945b60365d4ef096110f73e65eca930/4465946451218?cb=1e8198041058633a7a2eeab0f91c1336) You will be able to create a scheduled export directly on the export interface. ## Creation of a Data Flow export Click on "*Create a Data Flow export*" to create a new scheduled data export. ![DF_Button.png](https://analytics-docs.piano.io/__attachments/a_671563f90eb9c0dff65d6bb231d35bf90f5bb4f9a1d080ea8af0059baa69528b/8281753618706?cb=317b11edf8699888caa45bbd57106512) You will access to the following 2 step process: ### ++STEP 1: Flow contents++ ![screen_1.png](https://analytics-docs.piano.io/__attachments/a_22d7a4beaf693247ce2b8f27440f42805e53bb473664ccc4dd60dc0719f3a635/4465918669842?cb=b43d8d0f3c4598fb024bd5967dc2e8e3) |------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | ![mceclip3.png](https://analytics-docs.piano.io/__attachments/a_58ef6022c83aa49ac016026f1180c1a295b9507bb2e65bf8a96e3c484d5e2646/4465918726034?cb=ffb2d0b18174daa8b9720b0017505db0) | ++The scope of your export++ Do you wish to retrieve information relating to all your sites? or only one or a subset of your websites? | | ![mceclip4.png](https://analytics-docs.piano.io/__attachments/a_9e2c71817596600ffa4d48a2b7b8d670168786fd66bcec0829b8a08dcd24a5a3/4465927038994?cb=6ee5144468b530cd55c9fce3973e5bdc) | ++Activation of the privacy filter++ You have the possibility to activate the privacy filter in order to comply with regulations. With the privacy filter activated, you can exclude data from users who have not granted their consent. If you decide not to activate the privacy filter, you will have to purge some of the data received after receiving all the Piano Analytics data in order to comply with your country's regulations. The privacy filter is based on the property value "visitor_privacy_consent = false". | | ![10.png](https://analytics-docs.piano.io/__attachments/a_2310502ee7e279495aafbecd6ce7fb0b5830bf2b0d9448f4c272ddd97fc78cc0/4880817825426?cb=93ca729357e184b6e0526e3e7170fd33) | ++Customizing your data flows++ Do you want to exclude specific properties or do you prefer to export all your existing and future properties? * When you select "*Custom Data*", 7 mandatory properties are preselected: site_id,visit_id,event_time,hit_time_utc,event_time_utc,visitor_privacy_mode,visitor_privacy_consent * Please note: any retroactive import made via the enrichment interface available in "Data Management" will not be included in your data flows. | ### ++STEP2 : Flow configuration++ ![screen_2.png](https://analytics-docs.piano.io/__attachments/a_7c792a965d7bc9a373d1c5bdcc55c833d7788a242e302009ad6160f47eef132b/4465933339794?cb=5eec398dce49937f80205ba37503a5ba) |------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | ![mceclip3.png](https://analytics-docs.piano.io/__attachments/a_58ef6022c83aa49ac016026f1180c1a295b9507bb2e65bf8a96e3c484d5e2646/4465918726034?cb=ffb2d0b18174daa8b9720b0017505db0) | ++Flow name++ Name your data flow | | ![mceclip4.png](https://analytics-docs.piano.io/__attachments/a_9e2c71817596600ffa4d48a2b7b8d670168786fd66bcec0829b8a08dcd24a5a3/4465927038994?cb=6ee5144468b530cd55c9fce3973e5bdc) | ++Flow format++ Choose your export format: CSV, JSON or Parquet. Configuration change automatically for each format you select. Please note that JSON is actually NDJSON (Newline Delimited JSON). Please refer to for more information. | | ![mceclip7.png](https://analytics-docs.piano.io/__attachments/a_e9ba46fbc1eea22e022fe0eff7f9d6c69f171b7e3fe76c436718b6748ea44256/4465969099154?cb=93ca729357e184b6e0526e3e7170fd33) | ++Flow frequency++ * Choose your scheduled export frequency (15, 30, 60 minutes) its partitioning, and your flow destination (Amazon S3, FTP, sFTP). * Aa delivery report is automatically added. It's a ".report" file containing the files generated and sent, after export. It permits you to check if the generation of your files worked well: =\> missinglefile: false =\> all worked well =\> missinglefile: true =\> missing file * Save your new export and you are done! | ## Configuring Amazon S3 connections Configuring Amazon S3 connections is a straight forward process. In order to start, select "*Amazon S3*" as the type sending mode when setting up to your scheduled Export. Then select "*create a new connection*": ![1.png](https://analytics-docs.piano.io/__attachments/a_d8562f259e343dae4c455639afcfe17f6bed55884b883a9461c5369fcda8b58a/14487186192146?cb=26dbca8f3e3a20c74df05c9f9832fc92) You will be prompted with the following configuration window. In order for to know where to push the files and have the necessary rights to send the files we need the following information: ![Create S3 config.png](https://analytics-docs.piano.io/__attachments/a_83f06dfdacfd1c4aa6050c56e3eede5fe2f103139a392cdc9a64f9e84c614788/14487571244690?cb=381c404ce2e063201dc36514b4fa4fab) 1. **S3 Configuration Name** - the information requested here is for your reference. This will enable you to find and edit your connection amongst your other Amazon S3 connections you may have configured with Piano Analytics 2. **Bucket Name** - We need inforation regarding the name of your Amazon S3 bucket. This is a unique identifier specific to your bucket only. This will enable us to send the files to the right place 3. **Destination Folder** - If you wish to send the exports to place other than the main bucket folder you can specify the path here, sub-folders should be seperated by "/" 4. **Access configuration rule** - Access to the customer's S3 storage bucket is done through AWS role authentication. Piano Analytics will provide the customer with the ARN of a role to authorize on its bucket to allow write access to deposit files. The customer is responsible for setting up the "Bucket Policy" giving access to the Piano Analytics role. 5. **Test the connection** - when you press the "test the connection" button we will send a small file over to your Amazon S3 Bucket which will enable us to confirm that the information you have provided is correct and the connection has been set up correctly \& hit save! When you return to the configuration, hit: to refresh the Amazon S3 connection list. You should see the connection you've just configured appear in the drop-down list. ## Configuring FTP or sFTP connections Select "*FTP*" as your send method when setting up to your Export. Then select "*create a new connection*": ![3.png](https://analytics-docs.piano.io/__attachments/a_0eba8c9df56994d1f928c57c8f68f371e1e5095bc2818cfc5fe6098c7a98234e/14487186205970?cb=4d0fba09be3e26790e59b358b9f15b20) You will be prompted with the following configuration window. In order for to know where to push the files and have the necessary rights to send the files Piano Analytics needs the following information: ![Create FTP config.png](https://analytics-docs.piano.io/__attachments/a_20acdbb8d265e1ab1ce8e2b5a168b9f9db9f81185add72966cd1b12d330363be/14487314640274?cb=a566924374675cf06364e7d531ac6a09) 1. **Name of the FTP configuration** - the information requested here is for your reference. This will enable you to find and edit your connection amongst your other FTP connections you may have configured with Piano Analytics 2. **IP/Server Name** - We need inforation regarding the IP or server name of where your FTP server is located 3. **Protocol** - in this section you will be able to specify which protocol you wish to use: FTP or sFTP 4. **Port** - In this section you are able to specify which port you would like to use. 5. **Login \& Password** - For us to deposit the file we need to have valid login \& password details with sufficient access rights 6. **Destination Folder** - If you wish to send the exports to place other than the main bucket folder you can specify the path here, sub-folders should be seperated by "/" 7. **Testing the connection** - when you press the "test the connection" button we will send a small file over to the FTP which will enable us to confirm that the information you have provided is correct and the connection has been set up correctly. \& hit save! ### Do you need to whitelist IP addresses for security reasons? You can contact our support center to get the most recent IP addresses to whitelist. ## Data Availability Some data will not be available on*Data Flow*. The reason is simple: these properties are calculated "on-the-fly" and are not stored. For example, we don't know in advance if a ongoing visit will be considered as "bounce" visit. Because of this, the property "visit_bounce" can't be included to Data Flow. ## Scheduling The*Data Flow* export scheduling system are not based on complete time periods. Every time a file is sent (every 15, 30 or 60 minutes), all new data inserted in the database since the last export is sent. Because of this certain events relating to an earlier file may be included in the latest file. Because of this process we can ensure we do not miss out on any events. Data Flow exports are valid for 12 months, at which time they will exire. You will receive a notification via email 1 month prior to the expiration date reminding you to extend the export. ## Data Partitioning *Data Flow* includes a new feature: partitioning. Since files do not cover complete time periods, partitioning allows you to organize your files according to the time period they contain. This period is based on the UTC date of data collection (hit_time_utc property). You can choose your level of partitioning: * Date * Date / Time * Date / Time / Half hour * Date / Time / Quarter hour Let's take a concrete example. Let's imagine that you have created an export with a date/time level partitioning. The export is called myExport, it is sent to a folder "myFolder". The content of the table at the time of extraction is as follows: |---------------------|--------------|-----| | **Hit_time_utc** | **event_id** | ... | | 08/04/2021 10:58:14 | 192746238290 | ... | | 08/04/2021 10:59:27 | 192746857489 | ... | | 08/04/2021 11:00:28 | 387362092413 | ... | | 08/04/2021 11:01:45 | 238290192746 | ... | The dataset spans accross two hour intervals, it will therefore be split into two different files. In the case of an S3 export destination : myFolder/myExport/data/**date=2021-04-08/hour=10**/data_36_019ac5aa-3252-4738-0000-03d5ba4052ba_001_0_0.csv.gz and myFolder/myExport/data/**date=2021-04-08/hour=11**/data__36_019ac5aa-3252-4738-0000-03d5ba4052ba_001_0_0.csv.gz The first file will contain the extracted events with hit_time_utc property values between 10:00:00 and 10:59:59, the second file will contain events with a hit_time_utc property values between 11:00:00 and 11:59:59. If in the next iteration we identify new events belonging to the 11:00:00 - 11:59:59 time interval, a new file will be created in the /hour=11/ folder. In the case of a (s)FTP upload, the logic is similar, only the file name change. As folders cannot be dynamically created, it is the file names themselves that carry the time interval information: myFolder/myExport_**2021-04-08_10**_data_36_019ac5aa-3252-4738-0000-03d5ba4052ba_001_0_0.csv.gz myFolder/myExport_**2021-04-08_11**_data_36_019ac5aa-3252-4738-0000-03d5ba4052ba_001_0_0.csv.gz ## Format Once your flow is created, you will receive the files generated by *Data Flow* directly on your Amazon S3/sFTP server. Each generated file is compressed in GZ format. The file names include a naming convention managed by Snowflake which can be found at the end of the file name as follows: data_#GUID#_#NumberingSnowFlake#.format You will find examples in the previous paragraph. In order to speed up the processing, Snowflake executes the request in different parts on several machines. Because of this you may receive multiple files for the same time interval. **Important :** Regarding **CSV**exports, we recommend you not to base your treatments on the columns indexes or property names but on their property key, as we column indexes \& property names are subject to change. In **JSON**exports, properties with a null value won't appear for the relevant event. ## Delivery report After each files generation on your Amazon S3 bucket / sFTP, you will also receive a ".report" file which will contain the list of all generated files' names you have just received. If you have received a file which name is not included in any delivery report, then this file is not complete and you should not take it into account. Receiving this delivery report validates the generation and delivery of exports on a given time period. E.g. : at 10:20 UTC a generation is launched, resulting in three generated data files: * myFolder/myExport/data/date=2021-10-31/hour=09/min=45-60/data_019ac5aa-3252-4738-0000-03d5ba4052ba_001_0_0.csv.gz * myFolder/myExport/data/date=2021-10-31/hour=10/min=00-15/data_049fc5da-3372-8338-1200-08f7bc4801cz_001_0_0.csv.gz * myFolder/myExport/data/date=2021-10-31/hour=10/min=00-15/data_049fc5da-3372-8338-1200-08f7bc4801cz_002_0_0.csv.gz Once these three files have been *entirely* sent to your S3 bucket / sFTP, a delivery report named *#timestamp#_delivery.report* will be sent to you, it will contain all three delivered filenames and will validate the fact that you can import their content with confidence. ### History generation Regeneration exports relating to past time intervals will be based on the same level of partitioning as your production exports. The regeneration can be done in a separate folder. In order to be able to generate datasets for past time periods from date X to date Y and to minimize the risk of duplicates or data gaps, here is the procedure to follow: * If you have not already done so, set your flow live with the desired frequency. * At Y+1, you have to delete the data that you have ingested from your database with a query as follows: DELETE \* FROM #mytable# WHERE hit_time_utc \< Y+1 * The Piano Analytics team will create a past interval regeneration ticket for the Export team specifying : * Your customer account on which the production export was created * The name of your export * The exact period to be regenerated (X to Y) **It is possible that some flows in production may contain duplicates** . This is not inherent to*Data Flow* but to the collection of data. These duplicates will also appear in *Data Query* on the day in real time. Duplicates are removed on D+1 in the real-time data table, but this has no impact on Data Flow files already consumed. In case of a real time delay, events not included in a file will be included in the following files, always based on their date of insertion in the table. In which case, one can have smaller files than usual over a period and then larger files in the following iteration(s). --- version: "Working version" language: "en" --- # Subscription Insights * [Introduction to Subscription Insights](https://analytics-docs.piano.io/en/analytics/v1/introduction-to-activation-insights.md) * [Explorer Module and Boards](https://analytics-docs.piano.io/en/analytics/v1/explorer-module-and-boards.md) * [Data Model Structure](https://analytics-docs.piano.io/en/analytics/v1/data-model-structure-2.md) * [Feature support](https://analytics-docs.piano.io/en/analytics/v1/feature-support.md) * [FAQ - Subscription Insights](https://analytics-docs.piano.io/en/analytics/v1/faq-activation-insights.md) * [Subscription Insights Workspaces Boards](https://analytics-docs.piano.io/en/analytics/v1/activation-insights-workspaces-boards.md) * [Subscription Lifetime Value](https://analytics-docs.piano.io/en/analytics/v1/subscription-lifetime-value.md) * [Data Model Structure: Events with Properties](https://analytics-docs.piano.io/en/analytics/v1/data-model-structure-events-with-properties.md) --- version: "Working version" language: "en" --- # Subscription Insights Acquisition Performance Board The Acquisition Performance Board is designed to evaluate and understand the value of Composer in the context of acquisition, as well as to identify opportunities for optimizing the subscription. The content is organized into three main analytical use cases: * **Overall Composer Revenue and Value**: Analyze the revenue generated by Composer and assess the value it brings to the client. This section also helps identify changes in acquisition trends (Summary tab). * **Effectiveness of Audience Targeting**: Evaluate the effectiveness of targeting strategies and uncover potential opportunities by using the Revenue per Visitor metric (Audience tab). * **Impact of Changes on Composer Experience**: Assess the impact of modifications to the Composer experience, including structure, settings, and acquisition marketing tools such as campaigns or promotions (Composer tab). *The board defaults to a time period of the past 7 days, with period comparison enabled.* ## **Summary Tab** ### KPI tiles The KPI tiles highlight the most important metrics to summarize the value of Composer activities in the context of new conversions and new revenue. Three main metrics are used in the KPI tiles: 1. **Experience Revenue as New Composer Revenue**: This metric summarizes all revenue generated through Composer experiences, including new purchases for subscriptions, one-time payments, gifts, etc. It excludes renewals or conversion revenue originating outside of Composer experiences. 2. **Experience Payment Converted Visitors as New Composer Payment Converted Visitors**: This metric identifies unique visitors (defined at the cookie level) who have made a purchase, including payment or dynamic term conversions. 3. **Experience Converted Visitors as New Composer Converted Visitors**: This metric captures the total number of conversions, including non-monetary conversions such as registration term conversions, AdBlock disablement, access redemption, and more. ![image-20240808-085829.png](https://analytics-docs.piano.io/__attachments/a_313b261da5a2068811d5dea19c761497cf0d5841bb45abc192e003a6fcb913cf/image-20240808-085829.png?cb=9cc86b3e9e2e2aec35a95fd76f4489e2) ### Overall new Composer revenue The chart illustrates the monetary value of Composer conversions over time, with the goal of identifying unexpected drops and spikes in the revenue trend. To evaluate non-monetary conversions, such as registrations, alongside monetary ones, simply select "Experience Converted Visitors" from the dropdown list of metrics. It excludes renewals or conversion revenue originating outside of Composer experiences. ![image-20240808-090907.png](https://analytics-docs.piano.io/__attachments/a_bea842a20aca4841a4dc0eec5051133dbd48059f85a29d0cc148544ca78eeb2c/20907670441746?cb=8aab87c9e6560d24d112770c35abfaa4) ### Payment conversions by billing period This chart is designed to analyze the volume of payment conversions by term billing period over time. To analyze revenue instead of volume, select the "Experience Revenue" metric from the dropdown list. For a client running a subscription business, it's crucial to understand the ratio of new acquisition periods, as longer billing periods typically lead to better retention and higher lifetime value. The chart provides a period-over-period comparison. ![image-20240808-091650.png](https://analytics-docs.piano.io/__attachments/a_de9191be36529121fe7caa34053d1248cef3de075e5e243519b1b5a8c8718918/20907670445970?cb=d3a24e072af095b368449dab96bece16) ### Top 5 terms by revenue \& Top 5 terms by conversions \& Top 5 terms by Subscription Lifetime Value Both charts comparing the top 5 terms should highlight the difference between the total conversions and the revenue generated by each term. For instance, while there may be many conversions from Term X with a monthly billing period, the most valuable term in terms of revenue could be Term Y, which has an annual billing period. In these tiles you can find the conversion values in the context of Subscription Lifetime Value ![Docu picture.png](https://analytics-docs.piano.io/__attachments/a_ad0cd51375cfa3dfa9a30180955574347447e9db596e3577f648b7d17db4dd5b/Docu%20picture.png?cb=6bd917c89202b2b9873ef6980a1051a0) ### Goal types conversions If you are running different acquisition strategies and have various conversion goal types, this chart can be used to analyze the total value of all conversions. ![image-20240808-092346.png](https://analytics-docs.piano.io/__attachments/a_01802dec76245444b73c2cadad75491c2cfb5e608751aaf5ddcbc5a8e6d14e72/20907670449426?cb=8a6bcb5008c7a1d4a37c51623b4538bc) ## **Audience tab** ### Top 5 countries The goal of the chart is to compare the proportions of visitor segments by country, the revenue per visitor and relative metric. If a specific country shows significantly higher revenue per visitor, you may consider implementing country-specific targeting in Composer. ![image-20250104-184607.png](https://analytics-docs.piano.io/__attachments/a_4cc9ee8032e876e5cfe8b0f6f34463e81f9cdf1ef0d144b3e4c3b20f17710637/image-20250104-184607.png?cb=2fdd818cd8bb8e6dd2002ba017c918c3) ### Top 10 regions For clients with region-focused content, it's important to understand how each region is performing in terms of revenue per visitor. ![image-20250104-184709.png](https://analytics-docs.piano.io/__attachments/a_143bef9782cdf5bbc3fe6abdf29a65f5509041e1b25581789b9dd03385d93cdb/image-20250104-184709.png?cb=04fea289e30df18998e8deba017b130a) ### Top 3 devices Many clients target specific devices and tailor their messaging because most conversions come from desktops. To understand the value of such customized targeting, use these chart tiles. ![image-20250104-184802.png](https://analytics-docs.piano.io/__attachments/a_044dfc5e0e2399db454177ac2dadfdd0b5d7bf1a2f35bc4b915137fd5a45cd7f/image-20250104-184802.png?cb=1d5003e5abda17fc2e660b36b9fbfb72) ### Likelihood To subscribe (LTs) score These charts are beneficial for clients using the C1x segment Likelihood to Subscribe (LtS) metric, as they help assess the overall effectiveness of subscription acquisition targeting by LtS segment. The goal is to ensure that segments with the highest propensity scores (7, 8, and 9) generate the highest revenue per visitor. To learn more about C1x segment Likelihood to Subscribe please see the [documentation](https://docs.piano.io/lts-likelihood-to-subscribe/). If the data in the chart are empty, please make sure you are using the segment in the live experiences so we can collect the data. ![image-20250104-185059.png](https://analytics-docs.piano.io/__attachments/a_0296bc3c191ebb2c8fa1d9338d042ebb7f241fba6d0b7f80fd8b815a6b126201/image-20250104-185059.png?cb=e11907e8476a81490ce094049a6525fb) ### Top 5 sources One of the most important questions in acquisition strategies is, "Where are my converting visitors coming from?" Understanding this can help you invest more effectively in acquiring new audiences. This chart helps you evaluate the value of different traffic sources in terms of revenue per visitor. ![image-20250104-185152.png](https://analytics-docs.piano.io/__attachments/a_07639add45d259db4760e2d5c9965d28ec33bdb2744272f54cd72ee207a23846/image-20250104-185152.png?cb=acca9ada2e31e570ffbc4477e6ce0bdf) ## **Acquisition tab** If you work regularly with Composer---setting up or editing experiences, creating new templates and offers, and defining targeting criteria---this tab in the Acquisition Performance Board can help you understand the impact volume of any changes in your acquisition strategy. ### Revenue by experience This chart helps you understand the greatest impact on revenue in relation to different experiences. The timeline view allows you to analyze the effect of newly launched experiences. To view all experiences, maximize the tile view. If you want to assess the impact of experiences in the context of different metrics, select the desired metrics from the KPI dropdown. ![image-20240820-123606.png](https://analytics-docs.piano.io/__attachments/a_60aecb5f6483450adae5877caae3e6c29a7bf0f0f2849c9b7cc191fe4122b76b/20907670467730?cb=e63acd9d6b0d75d938e4f64cae814e5e) ### Experiences broken down by terms For a detailed breakdown of conversions and revenue in the context of experiences and terms, use the following table. This table is valuable for understanding the acquisition types that each experience generates. ![image-20240820-123854.png](https://analytics-docs.piano.io/__attachments/a_c5ce1cdaf5001388613e9bbef955519ba7609de10b935276a63f15fb8cafaf6c/20907670470162?cb=611a2372d02bbb54480d1c91fee1a264) ### Revenue by templates To identify the most impactful template from a revenue perspective, use this board tile. This chart can also be used to analyze the impact of newly launched templates. ![image-20240820-124028.png](https://analytics-docs.piano.io/__attachments/a_70826d80c547d2beaf7cb38e60fd082c8045fde530142be66e90026dd57c3219/20907670472978?cb=0e434265bd1f4dfa2ce97883c911f961) ### Revenue by offers To identify the most impactful offer from a revenue perspective, use this board tile. This chart can also be used to analyze the impact of newly launched offers. ![image-20240820-124143.png](https://analytics-docs.piano.io/__attachments/a_1fe16bd98c214cce1bb29df35821e83cf12bc3a3f4e0abd356d8d65b0cd90a96/20907670476050?cb=4fc5a4903c1aa967871308255a27cbfa) ### Revenue by promotions To evaluate the impact of promotions used in acquisition campaigns, use this tile. If you are also offering 100% price promotions, select a different metric than revenue to assess the impact of these zero-revenue promotions. ![image-20240820-124418.png](https://analytics-docs.piano.io/__attachments/a_f3c7b6ac26eeeb21748123cfd944964ba63742e4481ac009207829d1ca9b667e/20907670477714?cb=6d9fc2604ec1911f93401caa28d6d1fd) ### Revenue by campaigns If you are using a parameter campaign for conversion events, you can analyze its impact using the following board tile. ![image-20240820-124531.png](https://analytics-docs.piano.io/__attachments/a_c8b43e59873a8b8c8e70079187cdfbf71d7370a2c37f7be7c7ad15f64698bcbb/20907670482066?cb=cafa359beea55d949ed2df87696337ac) ### Revenue by medium If you are using the parameter medium for conversion events, you can analyze its impact using the following board tile. ![image-20240820-124605.png](https://analytics-docs.piano.io/__attachments/a_e56f0d6ff9be3db767052cb9c63c3834c2d80912a9d591363fe79de2fbd08556/20907670487954?cb=db1ee1f88a7e0c5baf3e1da832372bbd) If you are interested in other UTM properties, follow these steps: 1. Expand the chart tile. 2. Click on the property dropdown. 3. Start typing the property you are looking for. 4. Select the metric and click Apply. Alternatively, you can adjust the data in the data query tool. ![image-20240820-124910.png](https://analytics-docs.piano.io/__attachments/a_5a8d5f9823cc70c34af9b60c3a35b490c4a9275b9c03a87a0177c0d356921f82/20907670500754?cb=7be1d8653bd2cb6891c04f2c061e378e) ### Payment Conversions by Experience Versions over Time In case you are looking for a potential source of a sudden spike or drop in the revenue or targetting trends and you are suspicious that a new Experience version was created, you can use this chart to identify these changes. To see the full list of experiences and versions, expand the tile. If you are interested in looking at specific experiences, use the tile filter to narrow the data. ![image-20250104-185632.png](https://analytics-docs.piano.io/__attachments/a_7bedbec5e2826d0e38deacc1dd6bd626d52151f6c35b061c964f8c14e0e851c9/image-20250104-185632.png?cb=2813287d70e2ad9486367d1809aa49a1) ### Payment Conversions by Template Variant over Time In case you are looking for a potential source of a sudden spike or drop in the revenue or targetting trends and you are suspicious that a new Template version was used, you should use this chart to identify these changes. To see the full list of templates and versions, expand the tile. If you are interested in looking at a specific template, use the tile filter to narrow the data. ![image-20250104-185812.png](https://analytics-docs.piano.io/__attachments/a_18af48c4295fd27d8e339837e8850aa72269e24efd73c4228d36fa263b9aefa8/image-20250104-185812.png?cb=3263eb8acf4cfd5d9cfe4783210658f3) ### New accounts by Social Sign-in method The chart displays the number of new accounts created over the analyzed time period. Values for the social sign-in method are shown if the client is using the Piano Identity Social Sign-In feature and the user registered using a social account. `N/A` values are displayed in cases of standard (non-social) registration. ![image-20250630-085531.png](https://analytics-docs.piano.io/__attachments/a_4058711bb2ff4c13d6d50a7dc0159864b2d9187f5c1fe66f0a896eb110169180/image-20250630-085531.png?cb=483d2510f8ef930e503033bdcbb0eca6) ### New accounts \& Login events by Social Sign-in method To understand the total volume of new accounts and login events by social sign-in method, we recommend reviewing these charts. Login event data is available only for Piano Identity ![image-20250630-085621.png](https://analytics-docs.piano.io/__attachments/a_8fd6210e6e7a416ee6f07fb23ef4055fcaac17a62b9374e113033996516a8172/image-20250630-085621.png?cb=e09cd353fdae7a916e49d03d73ef0b28) --- version: "Working version" language: "en" --- # Activation Insights Editorial Performance Board The Editorial Performance Board evaluates the content impact in the context of the audience acquisition journey and subscription revenues The content is organized into three main analytical use cases: * **Understand the new subscription revenue in the context of site traffic** and content that is being produced. * **Compare the readership preferences and browsing behavior** for most important audience segments such as "Anonymous" visitors, "Known users without access" to restricted content, and "Subscribers" with the ability to alter the segments * **Analyze the impact of acquisition strategies in the context of articles** and identify which content attributes have better total and relative performance results. * **Learn additional insights about content**impact on subscription revenues by analyzing additional data coming from Audience - Content profiles. *The board defaults to a time period of the past 7 days, with period comparison enabled.* ## Overview tab ### KPI tiles The KPI tiles help to highlight the most important data points regarding audience traffic and new revenue. There are two tiles displayed side by side: the first tile considers all types of content, while the second is filtered specifically for article content type. * **Total Site Traffic: Main KPIs** provide insights into the overall traffic volume and new subscription revenues. A key KPI to track over time is the Subscription ARPU, which represents the average new subscription revenue per 1,000 visitors to the website. * Article Content Traffic: Main KPIs focus on a subset of traffic specific to articles, identified using the "content type" meta tag in your data. By comparing the two KPI tiles side by side, you can understand the proportion of traffic and content that is relevant for total site traffic versus article-specific traffic. ![image-20250104-095031.png](https://analytics-docs.piano.io/__attachments/a_1300c91715df7e9fc07ab092242944873607af0a0da15a7986ff680954248b47/image-20250104-095031.png?cb=97c7a27058e10cec5a7a337737be14b2) #### Bar and timeline charts If you want to understand how content is being tagged and the traffic or revenue associated with it, refer to the set of charts below the KPI tiles. These charts reflect how conversions are attributed to articles, landing pages, or other content types. If there is a significant portion of "N/A" values, we recommend addressing this by refining the data definitions in the Composer or PA SDK. To learn more check our [documentation](https://docs.piano.io/implementing-pianos-latest-sdk?paragraphId=5ab19322743d9a1). ![image-20250104-095929.png](https://analytics-docs.piano.io/__attachments/a_c0532534cdafd611273c9ee45a51899cf278eb1f329bd1d25066ecee366b7148/image-20250104-095929.png?cb=a3a56172787437940b7fe586899dd3d3) ### Audiences Gaining insights into audience behavior differences---such as editorial preferences and browsing habits---is crucial for making data-driven decisions to optimize acquisition strategies or improve subscription retention. Understanding these behavioral differences between segments can help identify key attributes that inform decisions about optimizing Composer experiences or determining which content to lock or keep accessible to a broader audience. The segments used on the Audience page of the Editorial Performance Board are as follows: * **Anonymous Visitors**: Represents any visitor browsing the website who is either logged out or not registered. * **Registered Without Access**: Identifies logged-in users who do not have access to locked content. * **Subscribers**: Represents users with access to locked content through a purchased subscription. These segments can be adjusted using the filter function on each chart tile. For example, if you want to compare the behavior of **Site Licensing Subscribers**, you can do so by selecting that segment in the tile filter instead of one of the segments mentioned above. #### Traffic KPIs To analyze the volume of traffic or engagement statistics for each segment, refer to the initial KPI charts. You can adjust the chart metrics by clicking on the "Visitor" metric. ![image-20250104-101111.png](https://analytics-docs.piano.io/__attachments/a_e296c21082e99f8840120a5bdd59141e79408fa087a7899bd577393087daeaee/image-20250104-101111.png?cb=ba364ee4467ab74f363f90bf9ec5d626) #### Traffic by content type The breakdown of browsing patterns by content type for each audience segment helps identify the level of internal browsing circulation, particularly between the homepage, articles, and front page. If you notice a significant portion of "N/A" values, we recommend reviewing the [SDK implementation](https://docs.piano.io/implementing-pianos-latest-sdk?paragraphId=5ab19322743d9a1), specifically the "Content type" field. ![image-20250104-101733.png](https://analytics-docs.piano.io/__attachments/a_a819bf870935713f860a32a24cc3290a2cd6cb95bad3004201f23105253d8e1d/image-20250104-101733.png?cb=43563bc1bc1bcd42b03f9d8da83ed515) #### Traffic by content section To identify which sections generate the most interest among the Anonymous audience or contribute to increased retention for Subscribers, refer to the next set of charts. To view the full list of all sections, expand the tile. ![image-20250104-102901.png](https://analytics-docs.piano.io/__attachments/a_c535111cc7422ac4396a2b7f90f8f5db527d7371ba91f4b17baced2334fc0c9e/image-20250104-102901.png?cb=4ec18bff0b093caa6f635bdf985968b1) #### Trending Articles To discover which articles are effectively acquiring new anonymous audiences, increasing engagement among known audiences, or performing well across all audience segments, refer to the next set of charts. ![image-20250104-103307.png](https://analytics-docs.piano.io/__attachments/a_cc387adf45a35bd2b995dea9157706de69fae175421e819c6989126a33d7a7fe/image-20250104-103307.png?cb=2c471ca79c086e950a3d009dd92e3c86) #### Trending Authors To analyze author preferences across different audience segments, refer to the next set of charts. These charts help identify which authors drive engagement, attract new audiences, or contribute to retention. By exploring the data, you can understand how content from specific authors resonates with each segment. ![image-20250104-103611.png](https://analytics-docs.piano.io/__attachments/a_b003bb5a6f720daf3ec9ddcb595aa31f39baed87289009b6618af12d8d928d6d/image-20250104-103611.png?cb=435675ce93524e0354e057fd84f06fb7) #### Article Visit Sources To learn how the audience navigates to articles, see the next set of charts. The sources represent the origin of visits that resulted in an article pageview. This set of charts helps evaluate the effectiveness of your communication with the audience across multiple channels, such as social media and email, as well as the overall performance of your SEO strategy. ![image-20250104-103942.png](https://analytics-docs.piano.io/__attachments/a_5f7a275f0c85f1594870cfac86f0f3b417d6048372ee6ac41fd5921a88c92387/image-20250104-103942.png?cb=ea006d90dd988da51f790014f3dff4d3) #### Trending Content Concepts These charts help you understand which types of content --- represented by content concepts --- are preferred by your segments. Concepts refer to abstract ideas or general notions that convey meaning beyond specific entities or individuals. They encapsulate broader themes, categories, or topics that help in understanding the subject matter of the text. Concepts often represent relationships, processes, or ideologies rather than tangible, named entities. ![image-20251013-085302.png](https://analytics-docs.piano.io/__attachments/a_190b6b17959157f4466e9dd73fdb6602b85c31b083ec148c882d5937e9d004c9/image-20251013-085302.png?cb=38243d4247fb85d0708c634c6079a313) #### Trending Content People To learn about which types of content --- represented by content people --- your segments prefer, use these charts. Content people represent celebrities or personalities mentioned in an article. They capture references to well-known individuals, helping you identify which public figures or personalities resonate most with your audience. ![image-20251013-085548.png](https://analytics-docs.piano.io/__attachments/a_c0bc567e271d1ebe4152e0ec9d949e89636251b24b197b4ffe6fc94a69087f10/image-20251013-085548.png?cb=c9f815740f57277309ad5bf5719993da) ### Articles If you want to understand the value of the content you produce in the context of subscription acquisition and identify which editorial pieces contribute the most to both total and relative subscription growth, refer to the Article page. #### Article KPIs The set of KPIs is designed to provide valuable insights into how article content is being consumed, as well as its total and relative revenue value. * **Articles Metric**: Represents the number of articles read within the analyzed time period, using a distinct count of article names. * **Page Views per Article**: Reflects the relative value of page views per article. * **Experience Conversions**: Describes the total number of any conversion type acquired through Composer. * **Experience Turnover**: Represents the total amount associated with experience conversion events paid by visitors. * **Subscription ARPU:** Indicates the average new subscription revenue per 1,000 visitors to the website. ![image-20250104-123749.png](https://analytics-docs.piano.io/__attachments/a_e16588c54c104cd04a68f8d34cb828efe59bc09ba50ee69d9e3ddb1015c07bdc/image-20250104-123749.png?cb=f400fbb6029fda50ec42aaeb0059f578) #### Top 10 Articles To understand the relationship between traffic volumes and new subscription revenues in relative terms, and to identify articles with the highest relative value in the context of subscriptions, refer to these charts. The property "Article" used in these charts represents the last article viewed before the conversion event. This means that even if you attribute conversions to a landing page, these charts allow you to analyze the true content source of the conversion event. For more details about the "Content that Converts" mechanism, refer to our [documentation](https://support.piano.io/hc/en-us/articles/17006092333330-Feature-support#Contentthatconverts?). ![image-20250104-180751.png](https://analytics-docs.piano.io/__attachments/a_f42c8b20693c5433a4016846baa9b576fb98fdd5d8cc0064c6a27b888c575092/image-20250104-180751.png?cb=6cb4a4952297b190b0f433671ff02743) #### Top 10 Sections Use these charts to gain insights into the total and relative value of each section in the context of subscriber acquisition. The Subscription ARPU metric helps identify sections that contribute not only the highest total traffic or new subscription revenues but also the highest relative value. For example, while the "Travel" section may not rank at the top for Page views or Experience turnover, it has the highest Subscription ARPU. This suggests that focusing more on the monetization of "Travel" articles could improve subscriber acquisition. ![image-20250104-181926.png](https://analytics-docs.piano.io/__attachments/a_6db968cc80174aa91c1817efb9f5cf5bca4bb24348226b1343df37ab857d4280/image-20250104-181926.png?cb=7077db3aeaa241171e919f99be85c070) #### Top 10 Authors To evaluate an article author's performance in terms of traffic and new subscription revenue, refer to the following charts. ![image-20250104-183202.png](https://analytics-docs.piano.io/__attachments/a_6407144b85f9a153aa8dadf3cf8fbf9e61497514a823f1012c528327e0c4b8a7/image-20250104-183202.png?cb=4e760050db0dd9dcc4a11efe7886045b) ### Content profiles If you have a licensed Piano Audience account, we offer additional insights into the editorial impact on subscription acquisition. These insights are based on data processed using a powerful crawler, our in-house NLP algorithm, and a self-hosted LLM. More information about Content Profiles can be found on this dedicated [page](https://analytics-docs.piano.io/en/analytics/v1/introduction-to-content-profiles). If you do not have licenced Piano Audience but you want to learn more about the product, please contact you account manager. #### Content Classification To evaluate an article's performance in the context of content classification, in terms of traffic and new subscription revenue, refer to the following charts. Content Classification is topic of the article's content, according to the classification proposed by the IAB ([here](https://github.com/InteractiveAdvertisingBureau/Taxonomies/blob/main/Content%20Taxonomies/Content%20Taxonomy%203.0.tsv)). ![image-20251013-100939.png](https://analytics-docs.piano.io/__attachments/a_98bb6e2e85d35993dee9e16093a3f4268cad91ea716a921ae683006ac631866d/image-20251013-100939.png?cb=a674f29f06a6e5fc077bd1a891f63280) #### Content People Use these charts to learn about which types of content --- represented by content people --- perform in terms of traffic and new subscription revenue. Content people represent celebrities or personalities mentioned in an article. They capture references to well-known individuals, helping you identify which public figures or personalities resonate most with your audience. ![image-20251013-101000.png](https://analytics-docs.piano.io/__attachments/a_6c702c9b32bc7d0b99ff4938ca8fa6974c83496c4f8ae86231c1094008fc9f4a/image-20251013-101000.png?cb=fdf25ac775201aa74888db92d7ffe897) #### Content Sentiment Analyze which types of content sentiment perform in terms of traffic and new subscription revenue. Content sentiment analyzes the overall emotional tone of your articles, helping you understand how sentiment impacts content performance. ![image-20251013-101053.png](https://analytics-docs.piano.io/__attachments/a_be8b7ee96a5c6121351bb6c1e2067d220d46476be495b971d66f83e9dc46ed22/image-20251013-101053.png?cb=29a10806fd7b44ada4e018d1be93702e) #### Content Companies Understand which companies mentioned in the content perform in terms of traffic and new subscription revenue. Content companies are organizations (companies, political parties, institutions, clubs, ...) mentioned in an article such Apple, Spotify, Democrats, Manchester United... ![image-20251013-101155.png](https://analytics-docs.piano.io/__attachments/a_d3041a759ecedb3351682912d50c4e9e5a6cd315b218251cd85ea47ff302ed5c/image-20251013-101155.png?cb=62a230519290a9ed579f4122d4ed2541) #### Content Locations Learn about which locations mentioned in the content perform in terms of traffic and new subscription revenue. Content locations are places, locations, geographical areas mentioned in an article such as France, Germany, Paris, Texas, ... ![image-20251013-101217.png](https://analytics-docs.piano.io/__attachments/a_1d5d3fed359ace80e2d8e526eeff4477192c028505ffc3eceeafe99da23edc3a/image-20251013-101217.png?cb=80f156567985f573ab58dc2c13028d53) --- version: "Working version" language: "en" --- # Activation Insights (FAQ) * [How to enable Subscription Insights for a site?](https://analytics-docs.piano.io/en/analytics/v1/how-to-enable-subscription-insights-for-a-site.md) * [How to troubleshooting missing or unexpected Subscription Insights data?](https://analytics-docs.piano.io/en/analytics/v1/how-to-troubleshooting-missing-or-unexpected-subscription-insights-data.md) * [Why do Composer, Piano Analytics, and Piano DMP give different numbers?](https://analytics-docs.piano.io/en/analytics/v1/why-do-composer-piano-analytics-and-piano-dmp-give-different-numbers.md) --- version: "Working version" language: "en" --- # Subscription Insights Subscription Performance Board The Subscription Performance Board is designed to evaluate and understand the value of subscription businesses managed in Subs billing, with a focus on retention, passive and active churn, and the Subs billing site licensing feature. The content is organized into four main analytical use cases: * **Overall Subscription Revenues and Value**: Analyze the value of newly acquired and retained subscriptions. This page also identifies the growth of the subscription base and the revenue share from long-term vs. short-term subscriptions (e.g., annual vs. monthly plans). * **Passive Churn Details**: Understand why renewal payments fail and uncover opportunities to reduce passive churn using data-driven decisions. * **Active Churn Insights**: Gain data on subscribers turning off auto-renewal or canceling subscriptions, and evaluate Active Churn experiences in Composer. * **Site Licensing Insights**: Evaluate subscriber statistics related to site licensees and contracts. *The board defaults to a time period of the past 7 days, with period comparison enabled.* ## Overview tab ### KPI tiles The KPI tiles highlight key data on subscription management performance. * **Subscription revenue overview**: This set of KPIs provides insights into revenues managed via Subs billing. For clients with multi-currency revenues, the Revenue metric automatically converts revenues into a default currency. Learn more about how the automatic exchange rate works in the documentation. * **Subs billing revenue**as the value of total revenues including the new and renewal revenues * **New Subs billing revenue**as the value of revenues obtained from new payment conversions * **Renewal Subs billing revenue**as the value of all renewal payments for subscriptions * **Subscription overview**: Analyze the growth or decline of the subscription base with metrics such as: * **Active subscriptions** are a daily snapshot of all subscriber types across various terms, including Payment, Dynamic, Linked, Site Licensing, Gift, and External. * **New subscriptions** as the value of new subscriptions created in Subs billing, upgrades are excluded from this number * **Lost subscriptions** represent the value of churned subscriptions. ![image-20241218-105854.png](https://analytics-docs.piano.io/__attachments/a_bb81c2fa3ccd92000ac8a25884e6bcccb2772001b7df6261ebb9f97f9338bbe1/image-20241218-105854.png?cb=0a751fffb693d86d1e9e5991fa017973) #### Subscription revenue over time Analyze revenue trends, spikes, or drops over time. Adjust the chart to view **New Subs billing Revenue** or **Renewal Subs billing Revenue** using the metric dropdown. To predict revenues or analyze anomalies, switch to the **AXON chart type.** More about AXON charts can be found in [its documentation](https://support.piano.io/hc/en-us/articles/4465640949138-AXON-Analyst-Anomaly-detection-prediction). #### Active subscriptions over time Understand subscription base growth or analyze new and lost subscriptions over time. The default metric is **Active Subscriptions** , which can be switched to **New Subscriptions** or **Lost Subscriptions** using the dropdown. ![image-20241218-110440.png](https://analytics-docs.piano.io/__attachments/a_ba87d291d49aed7dc15030195c5f7c46afe309ab2b6280f6e2434cbc274489d3/image-20241218-110440.png?cb=7ed98e472ed5ce3f415816c59ca1143e) #### Subscription revenue by billing period over time Identify revenue shares from short-term and long-term billing periods. ![image-20241218-110956.png](https://analytics-docs.piano.io/__attachments/a_3cf79119fa40fe984cfefee807498970d4cd13f5b32bff959d0f263c05cab064/image-20241218-110956.png?cb=d22042c9ff2e0915bb4b57a0620e10c0) #### Revenue by term To understand revenues as **Total Subs billing revenue** or **New Subs billing revenue** or **Renewal Subs billing revenue**by term, please use the following charts. There are displayed top 10 terms and if you need to see the whole list, please expand the chart tile and use the table. ![image-20241218-114624.png](https://analytics-docs.piano.io/__attachments/a_a26f7cb69fb567368827006787f5972cdbcd20d22b3f8a99bcb28bdbdf4d2c10/image-20241218-114624.png?cb=d30818660d972010ca4d1e9d2f15a46f) #### Revenue by resource To understand revenues as **Total Subs billing revenue** or **New Subs billing revenue** or **Renewal Subs billing revenue**by resource, please use the following charts. There are displayed top 10 resources and if you need to see the whole list, please expand the chart tile and use the table. ![image-20241218-114715.png](https://analytics-docs.piano.io/__attachments/a_5dc537c5a8b98bfce6dd588ec712d7e60ae4359c411bd2f75b164f2d1a74d248/image-20241218-114715.png?cb=60113140538f44832ed49d44fbfcd3cc) ### Retention The Retention Board provides key KPIs to evaluate digital subscription performance, including detailed cohort-based retention metrics. The Cohort Retention table shows how many users who subscribed in a given month remain active over time, helping identify retention trends and estimate subscription lifetime value. For deeper insights, use filters to analyze specific cohorts or terms over longer time periods. #### Cohort size The Cohort Size chart provides insights into the volume of new subscriptions created during each specific month-year cohort period. It is used to calculate cohort retention by evaluating the ratio of still-active subscriptions out of all conversions within the cohort. The chart displays the most recent cohorts in descending order; to view the full list, expand the tile or refer to the table below. All subscription terms are aggregated in the chart---use the tile filter to view data for a specific term. ![image-20250630-095342.png](https://analytics-docs.piano.io/__attachments/a_858d1522e282966a5d8789b378f8980d75c9b1c4d6a2e9e71c49527d56b20fa3/image-20250630-095342.png?cb=4639549e504a9e895d2aa0d686c7e15b) #### Cohort retention rate The Cohort Retention Rate chart displays the percentage of active subscriptions remaining within each month-year cohort. The retention rate is calculated as the ratio of active subscriptions to the total number of subscriptions originally created in that cohort. The chart shows the most recent cohorts in descending order; to view all cohorts, expand the tile or refer to the table below. All subscription terms are aggregated---use the tile filter to focus on a specific term if needed. ![image-20250630-095751.png](https://analytics-docs.piano.io/__attachments/a_bbe25b6a4a43fa7dad1b34fe99888dd9b9bdc46a13f3af9b0b863c0534e57bda/image-20250630-095751.png?cb=c2c67eb1b1c800eeb8cf48f572d5f35e) #### Cohort retention rate by term For a summary of cohort KPIs by subscription term, refer to the table at the bottom of the page. It provides insights into cohort size, retained subscriptions at the end of the analyzed period, and the subscription retention rate. If certain terms include a long list of cohorts, we recommend using the tile filter to focus on a specific cohort or term. ![Screenshot 2025-06-30 120649.jpg](https://analytics-docs.piano.io/__attachments/a_3bbd219c5b73c4bd73afa7b912fab1d18598dabc4758dafeecfb9dc4b2e5a375/Screenshot%202025-06-30%20120649.jpg?cb=ffa4d6d281233c3b71087ccfcd509611) ### Passive churn Passive churn represents the failure to renew subscriptions upon renewal due to various payment processing issues. The **Passive Churn** board page focuses on describing the volume of passive churn in existing subscriptions, providing detailed insights into the reasons for these failures, with an emphasis on annual and monthly subscriptions. The board is designed to help you understand how the [Passive churn feature](https://docs.piano.io/passive-churn-prevention/) should be set up in Subs billing. #### Passive churn - Subscriptions with renewal failure To understand the total volume of subscriptions that had renewal failure within the analyzed period see the initial charts on the Passive churn page. ![image-20241218-132252.png](https://analytics-docs.piano.io/__attachments/a_9dfbe83173554b27149f70914fdb5ead566ace10ad55d5f9e77e5c605153dd60/image-20241218-132252.png?cb=df7d6aef16607fd5eef94f08716199f1) #### Passive churn recovery rate - Subscriptions To understand the volume of revenues impacted by passive churn but still recoverable because the subscriptions are in the grace period, refer to the following tiles. These are differentiated by the length of the billing period - monthly and annual. ![image-20250630-090429.png](https://analytics-docs.piano.io/__attachments/a_74f038dcb4a3fdcc222a2eef4675a17107b6b8179c7a8a6700437cb71b68b934/image-20250630-090429.png?cb=a3f7d05a161beb9afbd282bdd8481b7f) If you need to see data for different billing periods, please use the tile filter to select a specific period. ![image-20241218-132637.png](https://analytics-docs.piano.io/__attachments/a_bb18e25a55dde539686a1fef6f002e056d9c1bdda4d977886fca81efd548052d/image-20241218-132637.png?cb=cf2aa666f99e25c7722b55af4150bda0) #### Passive Churn - Subscriptions with renewal failure by terms If you are wondering about the volume of passive churn in relation to specific terms, see the next charts. If you do consider setting up the [Passive churn prevention](https://docs.piano.io/passive-churn-prevention/) scenario or targeting subscribers in grace via the C1x segment [**Expiring subscribers**](https://docs.piano.io/composer-1x-segments?paragraphId=7f964bc8d9c48c2), this chart should help you to understand the specifics of passive churn per term. ![image-20241218-132904.png](https://analytics-docs.piano.io/__attachments/a_d11520a374d487f02570ae08229a38c26bd51b3ef7ac8158f6644d5136c89ee3/image-20241218-132904.png?cb=4903ed7f1a86a6a070071c5429d1c468) #### Passive Churn recovery rate - subscriptions with renewal failure by terms To understand the passive churn recovery rate for terms with the highest number of renewal failures during the analyzed time period, refer to the chart below. The passive churn recovery rate represents the ratio of subscriptions that experienced a renewal failure within the analyzed period but were subsequently recovered and renewed. ![image-20250630-090614.png](https://analytics-docs.piano.io/__attachments/a_941efa3ad29507ab153e5eeb95dc83f10b10676ce2b888b26b0467961859a414/image-20250630-090614.png?cb=38d0b9ccb9d826205474432c165ea251) #### Passive churn- Subscriptions with renewal failure by payment methods To deep dive into details of payment methods that are attributed to passive churn use the following charts. ![image-20241218-133817.png](https://analytics-docs.piano.io/__attachments/a_1da07feb5a2f97de0f88e93aebc691c5305c22b95b09a5cbf20c38b3b999fc16/image-20241218-133817.png?cb=deb3ff389d505632b6f4312bf49aecc0) #### Passive churn- Subscriptions with renewal failure by payment errors A payment error represents a decline code processed by the payment provider upon a failed renewal. The Passive Churn feature allows you to customize the renewal failure email based on the specific error message. ![image-20241218-134034.png](https://analytics-docs.piano.io/__attachments/a_212853e0f3e3fd7db9ee5b5f8263212ac5afd533b3c7f0bdfd32efa31c039350/image-20241218-134034.png?cb=245e3a020191a2757ae43cad1a832c77) #### Passive churn- Subscriptions with renewal failure by retry attempts The logic of retry attempts is tied to the length of the grace period. The charts help analyze the Passive churn recovery rate at various levels of retry attempts. ![image-20241218-134055.png](https://analytics-docs.piano.io/__attachments/a_64287facc6305d7e9aeab3386ed2bb46951d9b824f23bca91e9c391de89690b8/image-20241218-134055.png?cb=0c78e71ebd3a326f3212113f18753983) ### Active churn Active churn is an essential aspect of retention. In the context of subscription businesses, it refers to proactive subscription cancellations or the customer disabling subscription auto-renewal. To optimize active churn, it is important to understand its volume, identify the factors driving it, and evaluate strategies that help to reduce it. The board page focuses on the evaluation of active churn, provides insights into the C1x segment [Likelihood to Cancel](https://docs.piano.io/composer-1x-segments/#ltc), and offers the evaluation of the [Active churn prevention](https://docs.piano.io/template-interaction-active-churn-prevention/) feature. #### Active Churn - Subscriptions Turning Autorenewal Off Active churn evaluation relies on Subs billing subscriptions. In Subs billing, a subscription can either be canceled with immediate effect, or the customer can disable auto-renewal, allowing the subscription to expire at the next renewal date. It is important to monitor active churn events and to understand the volume of subscriptions that are still active but set to expire upon the next renewal because such subscribers can be targeted in Composer as C1x segment [Expiring subscribers](https://docs.piano.io/composer-1x-segments/#expiringsubscribers). ![image-20250102-125242.png](https://analytics-docs.piano.io/__attachments/a_4e92297e3fdb9197289e82717e3c375ae1f3e8b220e73484c0ec034f2890a70a/image-20250102-125242.png?cb=356ce3997d35d6a65f93d4eb58686bb3) #### Active Churn - Subscriptions Turning Autorenewal Off by Billing Period To understand differences in active churn by billing periods or to identify any time series anomaly, use the next chart. There are two default metrics to be used: "Expired subscriptions" and "Cancelled subscriptions". ![image-20250102-130127.png](https://analytics-docs.piano.io/__attachments/a_67eb859f89f110993869beafa6d44d05f0d022962d3906861bc2ff5bd8dca32c/image-20250102-130127.png?cb=aa809ef6357131069dbda0738011bb09) #### Active Subscriptions With Autorenewal Off by Term If you are interested in the current subscription base which has auto-renewal turned off to identify an opportunity to win these subscribers back, see the next charts by a specific term. If you want to see the full list of terms, expand the chart tile. ![Screenshot 2025-01-02 140728.png](https://analytics-docs.piano.io/__attachments/a_b0699a8bb74199d50e7a1c2426f869f3cabbe907b15aba441d682fe1c20b8064/Screenshot%202025-01-02%20140728.png?cb=f522425dbc9b51a918aa7090f5fd8e60) #### Prediction Model - Likelihood to Cancel The Likelihood to Cancel category of segments leverages Piano's LtC algorithm to segment subscribers based on the likelihood they would cancel their subscription, allowing you to identify the biggest factors driving cancellation and target high and low-cancellation-risk subscribers individually. Models output a probability score between 0 to 100 for each subscriber based on their likelihood to cancel. Subscribers are then broken into 10 segments that can be targeted using Composer, with 0-9 as the least likely to cancel and 90-100 as the most likely to cancel. ![image-20250102-130705.png](https://analytics-docs.piano.io/__attachments/a_54be5b565006140ed21299fb8e889b31e880c34f69550c681749ad8665ff2fcf/image-20250102-130705.png?cb=4c7b68c005ef55e0296e77af8f762b8c) #### Active Churn Prevention Experience Active Churn Prevention is a feature that allows you to engage subscribers when they are on the verge of cancellation. Reacting to their actions in My Account with responsive and interactive Composer flows, you present targeted messaging, special offers, and feedback mechanisms stimulating user retention. The following section of the Active churn page in the subscription board focuses on the most important churn prevention KPIs to understand the ratios of customers exposed to churn prevention templates or upgrade offers. ![image-20250102-131617.png](https://analytics-docs.piano.io/__attachments/a_99e8fcc3fcb46404733a3852bda2341cad9c53923c10274d9802b1d403a91cb5/image-20250102-131617.png?cb=733414c3151f92420e3544ca66c635bc) #### Active Churn over Time To understand the evolution of active churn and long-term trends, see the next chart with **Active churn prevention exposed users** and **Subscribers prevented churn**. ![image-20250102-132524.png](https://analytics-docs.piano.io/__attachments/a_bbd5e8c108904cead141b67807e32f229adb005670ce591d42d7ba2b1d604387/image-20250102-132524.png?cb=029f0b26e5f909a8bd354b36560834bf) #### Active Churn - Churn Feedback Form If you are collecting the churn feedback via Composer Show Form action, you can find key KPIs with collected responses in the last two tiles of the Active churn page. To see the full list of collected responses, expand the KPI tile. ![Screenshot 2025-01-02 142810.png](https://analytics-docs.piano.io/__attachments/a_ab5108f903e51cb157bbb0065046eb987e9e345feafb252bc939039c63fd9170/Screenshot%202025-01-02%20142810.png?cb=3774ebcb48de73e0cd344a7eaeb14564) ### Site Licensing Site licensing is a Subs billing feature that allows you to create a Licensee with your partners to redeem access to your site by visiting a landing page and registering. "Licensee" is the term for a group that you have a licensing agreement with, such as another company or a university. #### Active Site Licensing Overview The main KPIs show how many seats are managed in the Site Licensing feature, and what is the volume and ratio of redeemed site licensing accesses. ![image-20250102-134055.png](https://analytics-docs.piano.io/__attachments/a_0bfd93663a48d6975560b33fff1fb97286e0b90e5310ca9d6cd79b4acab08646/image-20250102-134055.png?cb=5d3c7d4aaf4005dd75ad7d617d6bef50) #### Active Site Licensing Users over Time To see the trend of site licensing subscribers see the next chart. ![image-20250102-134319.png](https://analytics-docs.piano.io/__attachments/a_cd4a86076da5942aca23311d5afb9159ff7fdd8a2433a62bea1f33843fcc9f45/image-20250102-134319.png?cb=2f881a1415a703a35e30344b3d6099ff) #### Top 15 Site Licensing Terms \& Activated Seats Rate for Top 15 Terms To understand the top Site licensing contracts which are represented in data as terms, see the next charts. ![Screenshot 2025-01-02 144427.png](https://analytics-docs.piano.io/__attachments/a_7407678a0da9d54df57aa99a3aee548b38f5a33541333e723d6d252980860696/Screenshot%202025-01-02%20144427.png?cb=bd6dede412f0bf4d40b2b6bc4a3aa456) #### Site Licensing - Details The last table on the Site Licensing page on the board provides detailed insights into each Licensee and Site licensing contract. The KPIs available in this table are the following and a full list of contracts and licensees is available in expand tile mode. * **Total site licensing seats**: It is the maximum setup in Subs billing if the maximum of seats is not defined, then it is empty * **Active site licensing users**: Number of users who redeemed the access and have the status "Active" * **Pending site license users**: Number of users with the status "Pending". Pending status represents the user who has been invited but has not yet redeemed access. * **Revoked site license users**: Number of users whose access was revoked by a member of the client team. * **Invalid email site license users**: For email-based site licensing contracts - The user has an incorrect email. * **Site licensing activated seats rate**: Calculation: Active site license users / Total site license seats. ![Screenshot 2025-01-02 144757.png](https://analytics-docs.piano.io/__attachments/a_668966ab3b5b83d1b0fde25ef6b076149e8e11b6e64facb0b2342475784b75d3/Screenshot%202025-01-02%20144757.png?cb=c1cc4087be069089576f14754c0c15ae) --- version: "Working version" language: "en" --- # Subscription Insights Workspaces Boards * [Subscription Insights Acquisition Performance Board](https://analytics-docs.piano.io/en/analytics/v1/activation-insights-acquisition-performance-board.md) * [Subscription Insights Editorial Performance Board](https://analytics-docs.piano.io/en/analytics/v1/activation-insights-editorial-performance-board.md) * [Subscription Insights Subscription Performance Board](https://analytics-docs.piano.io/en/analytics/v1/activation-insights-subscription-performance-board.md) ## **Board features and adjustments** ### Metrics preference In the Summary tab, you can select your own metrics to display in the chart by clicking on the dropdown menu within the three predefined KPIs. This option to change metrics is available for all other charts and board tiles as well. ![image-20240808-085955.png](https://analytics-docs.piano.io/__attachments/a_90ecc08134b2265c5edfd03eff16515c0336af2e60b509c09b1834d4d32622f1/20907670504594?cb=87e224b2ae00a000d60d68e5a7a30a6d) If you are not sure which metric to choose because you do not understand the metric definition, hover over to the metric and click on the info icon to display the tooltip with the metric definition: ![image-20240808-090143.png](https://analytics-docs.piano.io/__attachments/a_39fac4f42c22baef2bc2924448f3d7f5f8e191679e7818c0b4c634302d8c8e89/20907670507666?cb=858f1198fdf99fe55a071d48f44bcdcd) ### Expanding tile and presentation mode Each tile can be expanded to full screen and used directly for presentations. There is no need to copy charts and paste them into a slideshow; you can present them directly within the Piano Analytics interface. ![image-20240820-125824.png](https://analytics-docs.piano.io/__attachments/a_e4edb39f822444948d44e90342a6091d61ce9ab74877f54983bce6304a005b4b/20907670511506?cb=13f1873cb642ad1ee69df79b76ccfb96) ### Chart modifications with AXON You can change each chart according to your preference and you can also use two AXON charts including predictions and anomaly detection. ![image-20240820-130801.png](https://analytics-docs.piano.io/__attachments/a_66610b5a42fc90221022795583da3cab8cb7f1ac32a4d618439fc6d066069c38/20907670515346?cb=14a30d82abccffa9b2dbceabf40a1a6a) ### Using global filters To limit all KPIs in the board to a specific Experience, Device, geo-location or user segment, use the global segment feature. It is available on each board and you can use either suggested properties, look for specific ones or create and use your custom segments. More information is in the [segment feature description](https://analytics-docs.piano.io/en/analytics/v1/filters-segmentation.md). ![image-20240820-131129.png](https://analytics-docs.piano.io/__attachments/a_09436f2352aad5a3f2785df9f7fc2cbf00eb9d88d72527356fab084aac9e3ab7/20907670525202?cb=3b687805668d84c01a7be537e4030089) ### Data customization and advanced data analytics Each chart can be expanded into the presentation mode and you can add additional properties to the data or for more advanced data modifications click on "Open in Data Query" to work with the data. ![image-20240820-132033.png](https://analytics-docs.piano.io/__attachments/a_74ef198f0462d6175663652a20c2d4ec59b4163f497f353cd88051a8a0e2efaf/20907670533138?cb=baa6cc39de4013b8c5cb30d2b9525bf5) Many more useful tips for working with Workspace boards can be found on our dedicated [documentation page](https://analytics-docs.piano.io/en/analytics/v1/workspaces-boards.md). --- version: "Working version" language: "en" --- # Ad performance * [Introduction to Ad Performance](https://analytics-docs.piano.io/en/analytics/v1/introduction.md) * [Key Information](https://analytics-docs.piano.io/en/analytics/v1/key-information.md) * [Getting Started and Onboarding Process](https://analytics-docs.piano.io/en/analytics/v1/getting-started-and-onboarding-process.md) * [Data Visualization](https://analytics-docs.piano.io/en/analytics/v1/data-visualization.md) * [Data Model - Ad Performance](https://analytics-docs.piano.io/en/analytics/v1/data-model-1.md) --- version: "Working version" language: "en" --- # Ad Revenue Insights * [Introduction to Ad Revenue Insights](https://analytics-docs.piano.io/en/analytics/v1/introduction-to-ad-revenue-insights.md) * [Ad Revenue Insights Boards](https://analytics-docs.piano.io/en/analytics/v1/ad-revenue-insights-boards.md) * [Data Model Structure](https://analytics-docs.piano.io/en/analytics/v1/data-model-structure.md) * [Additional Resources](https://analytics-docs.piano.io/en/analytics/v1/additional-resources.md) --- version: "Working version" language: "en" --- # Ad Revenue Insights Boards ## Introduction to Ad Revenue Insights Boards ### Introduction Ad Revenue Insights provides two standard reporting boards that meet the needs of individuals with different roles within your organization. If you are also a Piano Analytics customer, as detailed below, a version of each board can be saved, manipulated and modified to suit your needs. ![Overview.png](https://analytics-docs.piano.io/__attachments/a_bde33eaae7668d528038f83f20f9a35ecdcdedaca6a8e939b161941141ccb38f/Overview.png?cb=2028154379903315f88318f7ffec335c) More information on how to use workspaces can be found [here](https://analytics-docs.piano.io/en/analytics/v1/workspaces-boards.md). ### Location The two standard Ad Revenue Insights boards are available in your Piano Analytics library alongside all of your other Piano Analytics ressources. The boards are located in Boards \> Piano Analytics \> All Ressources section of your library. ![Location.png](https://analytics-docs.piano.io/__attachments/a_e4260efd2df44457f858ccfd03f22c7503d1eb7340a79d6c632f8cb45600b7cb/Location.png?cb=c4967e9034fa075d14ba736493931967) ## \[Ad Revenue Insights\] Ad Ops: Ad Revenue Tracking This board offers a comprehensive view of ad revenue trends over time, segmented by order name, line item type, advertiser, and content section. Designed for ad operations teams and stakeholders who require granular ad data, it provides the tools needed to analyze fluctuations in ad revenue and optimize performance effectively. With this board, users can quickly pinpoint the root causes of ad revenue variances, address technical issues, assess vendor and sales performance, and make data-driven decisions about the ad stack. By delivering these insights, the board empowers teams to identify revenue opportunities in real time, enhance operational efficiency, and drive smarter, more strategic decision-making to maximize overall ad revenue. ### Overview tab In the Overview tab, users can analyze general ad revenue data through 10 interactive visualizations, providing a comprehensive summary of their performance. The overview tab contains the following reports : #### Overview - KPIs The KPI tile displays key metrics by default, including Ad Revenue, Ad Impressions, CPM, RPS, and Direct Sell-Through Rate. It also compares these metrics to the same period from the previous cycle. Users can customize the displayed metrics and comparison period as needed. ![Overview KPI tiles.png](https://analytics-docs.piano.io/__attachments/a_b5bcd99b4a1cd33fb15fc3d3c0b11d4221db3408ed19f3305077ef2b9d7a50e8/Overview%20KPI%20tiles.png?cb=5f98234539cc3edc82ea0ae0a1ae2528) #### Overall Ad Revenue This tile presents a time series of total ad revenue, allowing users to track and analyze fluctuations over the analysis period. ![Overview Overall Ad Revenue.png](https://analytics-docs.piano.io/__attachments/a_db2c6d79c0f962b8f9a96cf0d77eff77f73c22ecdffd34c8aa41b2484636ad17/Overview%20Overall%20Ad%20Revenue.png?cb=265306aff842d5632c061051f3ad46f3) #### Ad Revenue \& Ad Impressions by platform These two tiles provide a breakdown of total revenue and ad impressions by ad platforms. The Ad Platforms property categorizes the different types of SSPs and native advertising platforms utilized. #### Ad Revenue \& Ad Impressions by line item type The next two tiles break down total revenue and ad impressions by line item. Line items represent the individual campaigns or configurations set up across your various SSPs and Native Advertising Platforms. #### Ad Revenue \& Ad Impressions by advertiser These two tiles break down total revenue and ad impressions by advertiser. The Advertiser property includes details about the advertisers displayed in the ads. ![Ad Revenue & Ad impression.png](https://analytics-docs.piano.io/__attachments/a_fbf90bed67462ce49913332f79025ede779829d64c9e2037c66d31c08b7e99e3/Ad%20Revenue%20&%20Ad%20impression.png?cb=4ebeebdec999c72028226d03559ef73a) #### Direct sell-through rate and RPM by content section The final two tiles on the Overview tab provide insights into Direct Sell-Through Rate and RPM (Revenue per Mille), broken down by your site's content sections. The Direct Sell-Through Rate reflects the percentage of ad space sold directly compared to the total ad space sold. ![DSTR & RPM by content section.png](https://analytics-docs.piano.io/__attachments/a_e8c6137cf80daaa530303b9caf3605f97b60518c1eb8c03234ee161be1456e15/DSTR%20&%20RPM%20by%20content%20section.png?cb=b596812b133d07e4bd630996c6e68066) ### Direct tab #### Direct KPIs The KPI tile displays key metrics by default, including Ad Revenue, Ad Impressions and CPM. This tile is focusing on direct ads by filtering on standard, sponsorship and prefered deal line items. It also compares these metrics to the same period from the previous cycle. Users can customize the displayed metrics and comparison period as needed. ![Direct 1 - direct KPIs.png](https://analytics-docs.piano.io/__attachments/a_6a11d8a7b25a616e360faf14fb5fbed18a4d4cc1da569cb7a9b92dab7ed33de0/Direct%201%20-%20direct%20KPIs.png?cb=154624e350df8b0596f8c82560880091) #### Overall KIPs The KPI tile displays Page Views, Ad Impressions per Page View, and Direct Sell-Through Rate using unfiltered data by default. This tile is designed to help users contextualize direct activity within their overall performance. ![Direct 2 - overall KPIs.png](https://analytics-docs.piano.io/__attachments/a_e2d78a9b8adb0dea04bba13ae2ae76391f931f60a17d33828ec733ed67e7cbe2/Direct%202%20-%20overall%20KPIs.png?cb=12a1890d7f786185656d7b513dc2cd96) #### Direct Ad Revenue This tile presents a time series of total ad revenue for Direct activity, allowing users to track and analyze fluctuations over the analysis period. ![Direct 3 - Ad Revenue.png](https://analytics-docs.piano.io/__attachments/a_919fa80636737854a7a49bf4a84f9d498bcf99b9e19e0d86b97da132fefcdf95/Direct%203%20-%20Ad%20Revenue.png?cb=c996e8204972fa2242ab1d1304d62f50) #### Ad Revenue by Order name The next two tiles allow users to analyze Direct Activity Ad Revenue by order name. The first tile provides insights into overall fluctuations over time, while the treemap tile visualizes the proportional distribution of ad revenue across various orders. ![Direct 4 - line item.png](https://analytics-docs.piano.io/__attachments/a_9914a190f23d72ffb7e88f604eaebcdac83049e4f5233a832e43a6c7ea9ae6f7/Direct%204%20-%20line%20item.png?cb=bd26018106e167da2817f1ebe48c10e0) #### Ad Revenue by Line item type The two tiles related to line items provide the ability to analyze Ad Revenue, Ad Impressions, and CPM, broken down by line item and order name. The first tile presents trends over time, while the second tile provides a detailed table for in-depth analysis. ![Direct 5 - line item.png](https://analytics-docs.piano.io/__attachments/a_b9e4632a7c72551ad70be5f0e64a1d9656fd0d653b234aa9266e8987436c0f1c/Direct%205%20-%20line%20item.png?cb=f7ec4d384fb3a026fec1de84060f9a73) #### Ad Revenue by Target segment The next two tiles are similar to the previous ones but focus on breaking down the data by target segment. They provide a trend analysis over time in the first tile and an in-depth breakdown in a detailed table in the second tile. ### Programmatic/Indirect Ad Revenue tab #### Programmatic KPIs The KPI tile displays key metrics by default, including Ad Revenue, Ad Impressions and CPM. This tile is focusing on programmatic ads by filtering on standard, sponsorship and prefered deal line items. It also compares these metrics to the same period from the previous cycle. Users can customize the displayed metrics and comparison period as needed. ![mceclip1 (8).png](https://analytics-docs.piano.io/__attachments/a_f5280a285dde174a5b4e7d25c7862559663e887390925e6f00492b1d201e246c/mceclip1%20(8).png?cb=757fa98098d5844b4fc5f95c3b008257) #### Overall KPIs The KPI tile displays Page Views, Ad Impressions per Page View, and Direct Sell-Through Rate using unfiltered data by default. This tile is designed to help users contextualize programmatic activity within their overall performance. ![télécharger.png](https://analytics-docs.piano.io/__attachments/a_18236f435e6f2a67bcf3d1cc20b65d470af65a81ed06c168596989ec83d518e2/t%C3%A9l%C3%A9charger.png?cb=d72fdb6e1362bdd696f1ff1b8e92a380) #### Programmatic/Indirect Ad Revenue This tile presents a time series of total ad revenue for Programmatic activity, allowing users to track and analyze fluctuations over the analysis period. ![mceclip3 (2).png](https://analytics-docs.piano.io/__attachments/a_892e722aab97ae1fd9a95433160f506b9a7d64e99d93492930160c3e63da8c20/mceclip3%20(2).png?cb=e78785d01e4256a02daf59937f3b5d2b) #### CPM \& Ad Revenue by Advertiser The next section includes two tiles for analyzing programmatic activity by advertising data. The first tile highlights the CPM metric, broken down by advertiser, to identify the most profitable advertisers with the highest CPMs. The second tile presents an ad revenue time series, illustrating trends and the evolution of revenue share by advertiser over time. ![mceclip4 (2).png](https://analytics-docs.piano.io/__attachments/a_b5e300e1c28e200a176de04c4b6f0e6a6de3439b1628b41b3a4c7b5e43b79a2a/mceclip4%20(2).png?cb=8d0516f097ddde54b346fcf989fa4bcb) #### CPM \& Ad Revenue by Line Item This section features two tiles focused on analyzing programmatic activity using line data. The first tile showcases the CPM metric, broken down by line item, allowing you to identify the top-performing line items with the highest CPMs. The second tile displays a time series of ad revenue, providing insights into trends and the changes in revenue share by line items over time. ![mceclip5 (1).png](https://analytics-docs.piano.io/__attachments/a_9b811deb229cd8f2982bdf9dba6f55194ec1a4ca71ca239285c1beae5a371b9c/mceclip5%20(1).png?cb=d7b715264a09cae55c4ba0a30baf8dfb) #### CPM \& Ad Revenue by Ad Slot Code This section presents two tiles designed to analyze programmatic activity through ad slot code data. The first tile highlights the CPM metric, categorized by ad slot code, helping you pinpoint the highest-performing ad slot codes with the best CPMs. The second tile offers a time series of ad revenue, tracking trends and shifts in revenue share by ad slot code over time. ![mceclip6 (1).png](https://analytics-docs.piano.io/__attachments/a_012fd857d13bcd7e3601fd913eae380fc66fdfe67f5907ba610a2afce8c8a4d8/mceclip6%20(1).png?cb=fc1223a7b6457065ea5abfd1a74c2ff1) ### Native Advertising Platform tab #### Native Advertising Platforms -- KPIs The KPI tile displays key metrics by default, including Ad Revenue and Ad Impressions. It also compares these metrics to the same period from the previous cycle. Users can customize the displayed metrics and comparison period as needed. This tile, like all tiles in the Native Advertising Platform tab is focused only on native advertising platform activity by filtering on widget.impression events. #### Native Advertising Platforms -- Ad Revenue Over Time This tile displays a time series of total ad revenue from Native advertising platform activity, enabling users to monitor and analyze fluctuations throughout the selected period. #### Native Advertising Platforms - Ad Revenue by Device Type, Country \& Ad Slot Code The next three tiles break down Native advertising platform ad revenue by device type, country, and ad slot code. Using stacked bar charts, these tiles provide insights into the revenue share for each device, country, and ad slot code over time. ## \[Ad Revenue Insights\] Total Revenue Optimization ### Overview tab This tab provides top-level metrics on ad and new subscription revenue along with breakdown by ad and subscription ARPU (defined as new revenue per 1000 unique visitors). #### Overall Revenue KPIs The KPI tile displays key advertising and subscription revenue metrics by default, including ARPU (Average Revenue Per User), Ad ARPU, Subscription ARPU, Ad Revenue, and Experience Revenue. These metrics can be customized based on your preferences. This tile provides users with a comprehensive overview of both revenue streams. ![mceclip7.png](https://analytics-docs.piano.io/__attachments/a_34b24fc812f7ad74e3b3a0d985f0995cf42eb9ef0c0aca3b81566c10b697dc90/mceclip7.png?cb=1175eda873129d4ea9ec1578ebf619f0) #### Ad ARPU \& Subscription ARPU Both of these tiles present a time series of Ad ARPU and Subscription ARPU, allowing users to track and analyze fluctuations over the analysis period. ![mceclip8.png](https://analytics-docs.piano.io/__attachments/a_54c6d1b42b4865d88b1d93b98c6fa2b9d98d0bbeadd3a902c596e33b7f1f07e5/mceclip8.png?cb=797d8d792eb63e9fbc381cc8f511997c) ### Audience tab This tab allows users to monitor changes in traffic and differences in ad and subscription value across a range of attributes. #### Audience KPIs The KPI tile displays key audience-related metrics by default, including Visitors, Visits, Page views, Ad Impressions \& Experience revenue. It also compares these metrics to the same period from the previous cycle. Users can customize the displayed metrics and comparison period as needed. ![mceclip9.png](https://analytics-docs.piano.io/__attachments/a_6cf37cd7db305a2b0b2473c4ddb38142cf11c53dd0389b309ab0d85b2cdbee69/mceclip9.png?cb=470569beb0ecf61372702bd41618a66c) #### Visitors, Ad Revenue \& Subscription Revenue Over Time The next three tiles present trends over time for Total Visitors, Total Ad Revenue, and Total Experience Revenue, offering insights into overall performance metrics. ![mceclip10.png](https://analytics-docs.piano.io/__attachments/a_b67af6ba093db98d1187b96e4d35c00a823913c57ad8cc20d1dc54ad923013b0/mceclip10.png?cb=44cd50274806e251ae991ba2935fb6b9) #### Visitors, Ad ARPU \& Subscription ARPU By Traffic Source, Geography, Device and Likelyhood to Subscribe Score The final nine tiles use various bar charts to visualize the distribution of Visitors, Ad ARPU, and Subscription ARPU across traffic sources, geographic locations, device types, and likelihood-to-subscribe score buckets. ![mceclip11.png](https://analytics-docs.piano.io/__attachments/a_9c82e0e6d21800344ad3ea3cb3bdc57d5b5c465e0f4d2d3bf19ae23ab82d577e/mceclip11.png?cb=c7945d340a99f50cc4ac9f01244cad73) ![mceclip12.png](https://analytics-docs.piano.io/__attachments/a_4875a01aedeec622a8f46426bc1a22a639cb8fca9753c8d3e0982293894ac672/mceclip12.png?cb=59067ac036a9db04271fe822a9435720) ### Editorial tab This tab helps users assess the monetary value of editorial content and its impact on both subscribers and non-subscribers. All tiles in this tab are filtered on article pages only. #### Editorial KPIs The KPI tile displays key content-related metrics by default, including Visitors, Visits, Page views, Ad Impressions \& Experience revenue. It also compares these metrics to the same period from the previous cycle. Users can customize the displayed metrics and comparison period as needed. ![mceclip13.png](https://analytics-docs.piano.io/__attachments/a_05c162a02c456f60b36f76fb3cdbba95e771d626c112129a715bdc8a9a90464a/mceclip13.png?cb=ffdd38a711a64fc38e8910b46e9edd68) #### Total Revenue, Visitors, Ad ARPU, Subscription ARPU, Non-subscribers, Subscribers by Article The next six tiles present performance metrics broken down to the most granular content level: individual articles. Non-subscriber and subscriber statuses are defined using the visitor access status property. ![mceclip14.png](https://analytics-docs.piano.io/__attachments/a_51cbda2a929eb7553028585ab04b3ea98846c2d714ccf9a83de3692fb1b26fac/mceclip14.png?cb=aeec00c89cb998c65897107e1bd63d21) #### Total Revenue, Visitors, Ad ARPU, Subscription ARPU, Non-subscribers, Subscribers by content section The last six tiles present performance metrics broken down to the most granular content level: individual content sections. Non-subscriber and subscriber statuses are defined using the visitor access status property. ![mceclip15.png](https://analytics-docs.piano.io/__attachments/a_17c9bb324822ef99502b5cde096b5295a5c56c31f5e704906ef2a889433e530f/mceclip15.png?cb=99b5bee2231c521a9d63d2487ad54c59) ### Dynamic Paywall tab This tab provides insight into the performance of the dynamic paywall model. #### Dynamic Paywall Overall Revenue The first tile on this tab uses a stacked area chart to break down ad revenue and new subscription revenue by dynamic paywall score buckets over time. This helps users understand how advertising \& subscription revenue is distributed across different audience segments based on their likelihood to subscribe. ![mceclip16.png](https://analytics-docs.piano.io/__attachments/a_d9136abb6fbea96d0f7c9c8e7351df60a1231ab48ac91b295e4ce47a29eb2e76/mceclip16.png?cb=e1fca2fc5edefa466b789cec01d932df) #### Dynamic Paywall Subscription Revenue \& Ad Revenue The next two tiles focus on experience revenue and ad revenue, presenting both metrics over time using stacked area charts segmented by dynamic paywall score buckets. These charts enable users to identify trends and patterns in audience behavior and revenue contributions, offering a deeper understanding of how different paywall strategies impact overall performance. ![mceclip17.png](https://analytics-docs.piano.io/__attachments/a_b05fab90e3815c2f0236fab2a77dfa98f4faeea4d435031bbd88a2ad78cbd43e/mceclip17.png?cb=c2f4951786373bf02d131e994c3463f2) #### ARPU, Subscription ARPU, Ad ARPU, Subscription Revenue \& Ad Revenue per 1000 Pageviews The next five tiles provide a detailed breakdown of multiple key metrics, categorized by the same three dynamic paywall score buckets. These tiles are designed to offer a comprehensive view of how different audience segments---based on their likelihood to subscribe---contribute to various aspects of performance. Each tile focuses on a specific metric, such as ARPU, Subscription ARPU, Ad ARPU, or subscription and ad revenue, enabling users to gain nuanced insights into the behavior and value of these segments. By consistently using the same dynamic paywall score buckets, these visualizations make it easier to compare and analyze trends across different dimensions, helping users refine their paywall strategies and optimize monetization efforts. ![mceclip18.png](https://analytics-docs.piano.io/__attachments/a_86ee43fa21020109f9be91d6e0dec3efe0d4527e7e523070ef831525f345ac46/mceclip18.png?cb=9ad990697c1367e9927309fd59de69fa) #### Subscription Revenue \& Ad Revenue Individual Medium \& High Segments The final two tiles offer insights into the revenue share generated by different dynamic paywall score segments. * The first tile focuses on the distribution of experience revenue across medium and high dynamic paywall score segments, providing a clear view of how these groups contribute to overall subscription revenue. * The second tile highlights the distribution of ad revenue across medium and low dynamic paywall score segments, shedding light on the revenue impact of these audience categories. Together, these tiles help users understand the financial performance of specific paywall score segments, enabling more informed decisions about audience targeting and paywall optimization. ![mceclip19.png](https://analytics-docs.piano.io/__attachments/a_4a28c4f0239843e13754d6b91e6c7d17850512cf3677b8afdc56c0fd249eb10b/mceclip19.png?cb=445e09b29f10d213ba1f4e0fd45572b9) --- version: "Working version" language: "en" --- # Ad Revenue Insights (FAQ) * [What's the difference between Ad Performance and Ad Revenue Insights?](https://analytics-docs.piano.io/en/analytics/v1/what-s-the-difference-between-ad-performance-and-ad-revenue-insights.md) * [How do I integrate Google Ad Manager (or another ad platform) with Piano Analytics?](https://analytics-docs.piano.io/en/analytics/v1/how-do-i-integrate-google-ad-manager-or-another-ad-platform-with-piano-analytics.md) --- version: "Working version" language: "en" --- # Additional Resources These Ad Revenue Insights boards, as powerful as they are, are just the beginning of what can be done in Piano Analytics. For Composer clients, in addition to all the rich ad and subscription data available within these Workspaces, the entire Composer Insights data model is also accessible and can be leveraged in analysis. For more details on the Composer Insights data model, see [this documentation](https://analytics-docs.piano.io/en/analytics/v1/data-model-structure.md). For clients with access to the entirety of Piano Analytics, when any one of these boards is opened in full screen mode, you can open these boards in Data Query, which is the advanced analyst tool at the heart of Piano Analytics that enables far greater levels of data manipulation and analysis. Within Data Query, you can not only modify the existing reports, you can build new ones with the full expanse of data points available, including the ability to create your own filters, segments, and custom metrics. After familiarizing yourself with the Ad Revenue Insights Boards, if you want to explore the capabilities of Data Query, please contact your Account Manager to discuss whether there is incremental cost (which is dependent on the scope of your current contract) and to arrange a demo of these advanced Piano Analytics capabilities. --- version: "Working version" language: "en" --- # Adjust ## About Adjust Adjust is a mobile attribution and marketing analytics platform used by businesses to measure and optimize the effectiveness of their advertising campaigns on mobile apps. Adjust helps attribute app installs and user actions to specific sources, whether they are paid ads, organic campaigns, or other marketing channels. Adjust also offers features like ad fraud protection, cohort analysis, and user segmentation, providing companies with the tools they need to make data-driven decisions and enhance their overall mobile performance. To learn more: ## PA Connect Adjust The integration between Piano Analytics and Adjust enables you to combine precise attribution data with in-depth analysis of user behavior. This enables you to measure the effectiveness of your marketing campaigns, track the origin of each application installation, and optimize your conversion strategies, while guaranteeing optimal data quality and a better return on investment. ## Connector principles The PA Connect Adjust enables Piano Analytics to receive attribution data measured in Adjust via automated callbacks. Follow the steps of this documentation to start receiving app install and uninstall events, and benefit from Piano Analytics' tools to uncover new insights. ![Implement the code-20241009-090022.png](https://analytics-docs.piano.io/__attachments/a_2e3ba60c4968d25f4de2c2da870696c838341f9dcd9279d114bd542418793d66/Implement%20the%20code-20241009-090022.png?cb=ad7987ea6ad40e11b082e14b8f9871ba) **Prerequisites :** * Have a Piano Analytics account. * Have an Adjust account. * Have sufficient rights in Piano Analytics ("Admin", "Data Supervisor"), and Adjust (Admin, Editor). ## Configurations in Piano Analytics The integration with Adjust allows you to collect the following events: * adjust.installs * adjust.reinstalls * adjust.uninstalls * adjust.reattributions These events must be declared as such (case-sensitive) from your Data Model in Data Management \> [Events](https://analytics.piano.io/datamanagement/#/data-model/events/list/): ![mceclip0-20241009-090048.png](https://analytics-docs.piano.io/__attachments/a_cd6468e8b01f0ba4aa38c00abdd9e765f1f47bf556de941f90142660ef458804/mceclip0-20241009-090048.png?cb=250a3b27d17f67a7c00e5e6e4880da5e) [Under this link](https://support.piano.io/hc/en-us/articles/4465959709202-Events#Createanevent) you will find instructions for declaring a Piano Analytics event. When the user performs one of these actions (install, reinstall...), Adjust uses methods like the advertising identifier (IDFA for iOS or GAID for Android) or fingerprinting techniques to associate the action with a previous click or impression. This click or impression is then linked to the specific advertising campaign and other relevant metadata (for reference, after the installation of an application (or other action), Adjust continues to track in-app events (such as purchases, sign-ups, etc.) and attributes them to the initial installation source). Each event we collect is therefore sent with campaign parameters related to the attribution performed by Adjust. Here is the mapping of the parameters we collect through the events: |---------------------------|------------------------------------------------------------|------------------------------------| | **Adjust SDK parameters** | **Information** | **Piano Analytics SDK parameters** | | `{session_count}` | Number of sessions recorded by the current Adjust SDK | app_sc | | `{installed_at}` | Installation timestamp (i.e. first time the app is opened) | app_fsd | | `{created_at}` | Activity timestamp | device_timestamp_utc | | `{network_name}` | Name of the network, as taken from the tracker | src_medium | | `{campaign_name}` | Name of the campaign, as taken from the tracker | src_campaign | | `{adgroup_name}` | Name of the adgroup, as taken from the tracker | src_creation | | `{creative_name}` | Name of the creative, as taken from the tracker | src_format | | `{device_manufacturer}` | Name of device manufacturer | device_manufacturer | | `{device_model}` | Device model name | device_model | This list is not exhaustive, as you can track custom parameters according to your needs (see Mapping below). ## Configurations in Adjust Once in your Adjust interface, under **Campaign Lab \> Partners**, add a new partner: ![mceclip7-20241009-090149.png](https://analytics-docs.piano.io/__attachments/a_620f60773d5938725f661684137a187b4e13a0ba804698601c1040d6613dbaeb/mceclip7-20241009-090149.png?cb=f8fe817331b1a7048e792f53d4f52b5b) Look for **Piano Analytics** : ![mceclip1-20241009-093150.png](https://analytics-docs.piano.io/__attachments/a_18e15fe62e53c8ec3dd6ca51ea23a0381062f126db97ea1a343fea8105fad5e5/mceclip1-20241009-093150.png?cb=a95462d61c359b2fc066c5bd3a9e63c5) Then select your application, normally already registered: ![mceclip2-20241009-093207.png](https://analytics-docs.piano.io/__attachments/a_80ebd3eb5452b094fce2ce7170890e6280ae441d6f6e6ceb723e95b5f5af0326/mceclip2-20241009-093207.png?cb=5926a14f4bc2177ec1d1ca804cce5ba9) From the Data Sharing menu, you'll need to authorize data sharing between the two solutions. Click on "Edit" and enter the collection domain of your application perimeter, as well as its site ID (you'll find this information in the Data Collection Portal, [here](https://analytics.piano.io/datacollection/#/dashboard) for the site ID, and [there](https://analytics.piano.io/datacollection/#/collection-domains) for the domain) : ![mceclip4-20241009-093245.png](https://analytics-docs.piano.io/__attachments/a_d2281aaa23151965bc09e0eee2b767b377d425591f15713f4808349a834421bf/mceclip4-20241009-093245.png?cb=c01bed88002ff899e98dc57c232c79f9) When sharing is enabled, by default the integration sends the 4 events install, reinstall, uninstall, reattribution. You can choose to send **additional data** via the Mapping option, by checking the "Parameters" box: ![mceclip1-20241009-093259.png](https://analytics-docs.piano.io/__attachments/a_5128a8f309f927133719fd24e254ac8a66183a5fe4d705710d22096942505300/mceclip1-20241009-093259.png?cb=0abbcd5c96e7f1d05b71df325338e550) Partner parameters (available from version 4.0 of the Adjust SDK) enable Adjust to collect custom data points from your application and send them directly to Piano Analytics. Piano Analytics then receives custom event details for each of your events. ### ***Add parameters through the Mapping option*** Before adding new parameters to the Adjust SDK, make sure that no other predefined partner settings already meet your requirements. To share partner settings with Piano Analytics, proceed as follows: 1. Configure partner parameters in SDK Adjust. 2. Once the "Parameters" box has been ticked, select "Map parameter" in the box that has just appeared. 3. In the SDK Parameter field, enter the name of the Adjust SDK parameter you wish to track, and in the Partner Parameter field, enter the Piano Analytics parameter corresponding to the SDK Adjust parameter: ![mceclip0-20241009-093314.png](https://analytics-docs.piano.io/__attachments/a_162eaabb826b0e62ae838fbfb2d5f6cb52c23fe1dd1bb58cdc7d18bef3d6ba9d/mceclip0-20241009-093314.png?cb=8474e3e9be75a8e0b408134e1923565c) Once you are satisfied with your configuration, validate the integration: ![mceclip5-20241009-093327.png](https://analytics-docs.piano.io/__attachments/a_4734449317bc56562f96841e4c438a264949f9cc9ebc333f838acc78b2f1e186/mceclip5-20241009-093327.png?cb=82dafb79ba79002bd2fa797ffa4c8f80) The integration now appears in your partners as active: ![mceclip6-20241009-093341.png](https://analytics-docs.piano.io/__attachments/a_ba987ba86a715f9ff33cdf5e96581f75fc75f043b4c4c0e0afb2e4f86f620b80/mceclip6-20241009-093341.png?cb=27e4f7ff6aa47f35f9cf0b7defc1ae87) ## Additional resources * Partner documentation: * Patner website: --- version: "Working version" language: "en" --- # Advanced Certifications Discover best practices, share your experiences with peers, and explore new ways to apply your skills! ## Advanced User Certification - 3 Days (+ Test) 🔗[**Access to certification program**](https://pianodrive.sharepoint.com/:b:/s/ClientServices2/Eft0iZBZIytPokXYGGHrkUcBZm_pyX-bzwtAap7QQ_9TPw?e=xHnLh4) *Piano Analytics* Advanced User Certification program consists of the following: * 3-days training program (21 hours) * Certification test Both training program and Certification test can be taken individually upon request. Average satisfaction rate (for all respondents): 8.7 / 10 in 2024 💡 **In a nutshell...** ⏲️ Duration: 3 day 🧑‍💻 Profiles: Digital Analyst, Advanced Digital Analyst, Data Scientist, Administrator 🎯 Certification goals: * Understand the Digital Analytics fundamentals (metrics, dimensions and tree structure) * Discover the *Explorer* tool, including its main features and analyses * Create relevant reporting for tracking your analytics KPIs * Deepen and refine your analyses using the Segmentation engine and *Custom Metrics* * Master dashboarding to monitor digital activity and share eye-catching dashboards * Learn to manage the *Data Query* tool and the API to extract data * Get an overall picture of our tools by learning the methods and best practices of digital performance management (defining KPIs, implementing dashboards) 🌍 Piano offices (Paris 9) or Customer offices or Remote - No hybrid format 💰 Pricing (excl. VAT): starting at 2350 € / person (test included) *** ** * ** *** ## Technical User Certification - 3 Days (+ Test) 🔗[**Access to certification program**](https://pianodrive.sharepoint.com/:b:/s/ClientServices2/ER1nj6n9D2hBo4KUF8mQo6ABKIIaZpP5WuKOhyIvY-t35A?e=Zcug3Y) *Piano Analytics* Technical User Certification program consists of the following: * 3-days training program (21 hours) * Certification test Both the training program and Certification test can be taken individually upon request. Average satisfaction rate (for all respondents): 9.5 / 10 in 2024 💡 **In a nutshell...** ⏲️ Duration: 3 day 🧑‍💻 Profiles: Digital Analyst, Advanced Digital Analyst, Administrator, Developer/Integrator 🎯 Certification goals: * Managing the deployment of *Piano Analytics* solution, defining and updating tagging plans * Managing data quality and data consistency within the organisation * Reprocessing data which has been collected in order to change or create new analyses (Data Manager module) * Checking data which is collected and shared internally or externally to make sure that it is reliable * Managing access rights to Piano Analytics, and other configurations 🌍 Piano offices (Paris 9) or Customer offices or Remote - No hybrid format 💰 Pricing (excl. VAT): starting at 2350 € / person (test included) --- version: "Working version" language: "en" --- # Advanced Training Courses - Explore & Share Data ## Data Query, Segmentation \& Calculated Metrics Training - 1 Day 🔗 [**Access to training program**](https://pianodrive.sharepoint.com/:b:/s/ClientServices2/EXsxa0cyijtLhdimesTTco4BYGdytR7FWaiN1C0FAykMXA?e=QKTaXc) You have already mastered the analyses presented in the *Explorer* tool and you would like to go further and create customised reports based on your data model. Do you want to work on your data dynamically in Excel, or in a dataviz tool (Power BI, Tableau Software etc.). Or do you want to connect your digital data into your information systems? *Data Query* is equipped with various data visualisation and export capabilities and enables you to meet these needs. 💡 **In a nutshell...** ⏲️ Duration: 1 day 🧑‍💻 Profiles: Business User, Digital Analyst, Advanced Digital Analyst, Administrator 🎯 Training goals: * Master *Data Query* in order to create your own data templates and export them * Acquire an excellent understanding of the segmentation tool * Learn to create custom metrics corresponding to your own KPIs 🌍 Piano offices (Paris 9) or Customer offices or Remote - No hybrid format 💰 Pricing (excl. VAT): starting at 1125 € (initial rate, for up to 5 participants) *** ** * ** *** ## Defining Relevant KPIs, Boards \& Dashboards Training - 1 Day 🔗[**Access to training program**](https://pianodrive.sharepoint.com/:b:/s/ClientServices2/ETUfmEtOSPNMiT9a0Tn6EJQB1quI101v46ww8HJNDAsjzw?e=xMZuGX) Do you wish to effectively manage and drive your digital platforms, and have access to key indicators that are perfectly adapted to your activities, your positioning and your digital strategy? Do you wish you could quickly and simply communicate this performance tracking to the relevant stakeholders and teams? This training will help you understand the key methods and concepts of managing performance and defining KPIs. When paired with the *Dashboards*tool, this training will enable you to put these concepts into practice by building a dashboard using a real data set. 💡 **In a nutshell...** ⏲️ Duration: 1 day 🧑‍💻 Profiles: Digital Analyst, Advanced Digital Analyst, Data Scientist, Administrator 🎯 Training goals: * Understand key principles of managing digital performances * Learn to define your own KPIs according to your digital goals * Work autonomously to create your own dashboards, enabling efficient decision-making * Acquire best practices for performance management and dashboarding for each business industry 🌍 Piano offices (Paris 9) or Customer offices or Remote - No hybrid format 💰 Pricing (excl. VAT): starting at 1125 € (initial rate, for up to 5 participants) *** ** * ** *** ## Traffic Sources, Marketing Campaigns \& Attribution Training - 0.5 Day 🔗[**Access to training program**](https://pianodrive.sharepoint.com/:b:/s/ClientServices2/ES41eGEciV9DuMfXSMDxoOgBU6jCl1Xg4i1RY7V-gfjkTA?e=7rZDt8) Is generating traffic to your site a major challenge for your company? Do you need to do an in-depth analysis of the investments made in your company's organic positioning and marketing campaigns to identify optimisation levers? If the answer to any of the se questions is yes, then you must know how to make the most of the traffic sources analysis in the *Piano Analytics*. 💡 **In a nutshell...** ⏲️ Duration: 0.5 day 🧑‍💻 Profiles: Traffic manager, Digital Analyst, Advanced Digital Analyst, Administrator 🎯 Training goals: * Gain a better understanding of the fundamentals of Analytics (organic sources and marketing sources) * Understand the tagging of marketing sources (declaration, use of variables, definition of sources) * Discover *Attribution* , from its definition to the analysis under *Explorer* 🌍 Piano offices (Paris 9) or Customer offices or Remote - No hybrid format 💰 Pricing (excl. VAT): starting at 720 € (initial rate, for up to 5 participants) *** ** * ** *** ## Export Data with Piano - 0.5 Day 🔗[**Access to training program**](https://pianodrive.sharepoint.com/:b:/s/ClientServices2/ETTioA-sh2VMqOZxFWCXWnUBNNAtwFWBhVh4r5S8fMhhTA?e=Zc1jXi) Piano offers data export tools to meet all your requirements and your ambitious data science projects. This training explores the different possibilities offered by our tool. It is aimed at an audience already familiar with the basics of Piano Analytics. Whether you already have an export solution in place and are curious about existing alternatives, or whether you are currently studying this subject. 💡 **In a nutshell...** ⏲️ Duration: 0.5 day 🧑‍💻 Profiles: Digital Analyst, Advanced Digital Analyst, Data Scientist, Administrator 🎯 Training goals: * Determine the most relevant export solution for your needs * Understand the mechanics of data export and the limitations of each solution * Anticipate the types of data available and unavailable in the different export options provided 🌍 Piano offices (Paris 9) or Customer offices or Remote - No hybrid format 💰 Pricing (excl. VAT): starting at 720 € (initial rate, for up to 5 participants) --- version: "Working version" language: "en" --- # Adverity ## About Adverity Adverity is a company specializing in data management and business intelligence, specifically in the field of marketing analytics. The company offers a data integration and analytics platform, often referred to as "Adverity Insights," which helps businesses collect, manage, and analyze marketing data from various sources. Adverity's platform is designed to assist users in making informed decisions, optimizing advertising campaigns, and improving overall marketing performance. To learn more, please visit : ## *PA Connect* Adverity and Piano Analytics have developed a bridge that enables you to send *Piano Analytics* data to the Adverity platform in order to discover new insights, by cleaning, harmonizing or simply transfering your batches into new tools. ## Connector principles Using Adverity's web connect to fetch your Piano Analytics data is pretty straight forward. Get the API call from your Data Query template, and start playing with your data using Adverity's tools, to discover new insights. ![Generate a PA API Key and set up the data source via Adverity-20240918-152000.png](https://analytics-docs.piano.io/__attachments/a_ce031ec150f62a615e3e6239b9edfd7053878db48ab6a5f08f53ac0ea4e573bd/Generate%20a%20PA%20API%20Key%20and%20set%20up%20the%20data%20source%20via%20Adverity-20240918-152000.png?cb=057d68b23357700268aba1f081fbbc0e) **Prerequisites :** * Have a Piano Analytics account. * Have an Adverity account. * Have sufficient access rights (at least "Analyst"). * Create an [API Key](https://analytics-docs.piano.io/en/analytics/v1/api-keys.md) ## Setting up the integration ### 1. Configure Piano Analytics as a data source in Adverity First, you will need to authenticate with your API Key, using Adverity's web connect: ![mceclip0-20240918-152338.png](https://analytics-docs.piano.io/__attachments/a_2a5ad917f44b06c2c08d7b105ff79f411e449fd173508aa71a2b8ca76d41b2b5/mceclip0-20240918-152338.png?cb=3929f25ec1a6d11e37e8bfc8da27230e) Do not use the "Piano" or "Piano ESP" connectors as they are only compatible with other Piano Suite tools. ![mceclip1-20240918-152410.png](https://analytics-docs.piano.io/__attachments/a_e8066cb6ada8f0a0ff2185ef3e7c0c9ecd2d908f3a84fced34f86e406f4c0579/mceclip1-20240918-152410.png?cb=e1fb3eb3b8945af02e1ca322028289e3) At this point, if you did not create an API Key yet from your Piano Analytics profil, please do by following this documentation: [API Keys](https://analytics-docs.piano.io/en/analytics/v1/api-keys.md). Then, connect with your API credentials: username being your *access key* , and password the *secret key*: ![mceclip2-20240918-152610.png](https://analytics-docs.piano.io/__attachments/a_a190adb1265d838681168a86b63031f84421f838c9bdf1ebe7d2d654f2844fc0/mceclip2-20240918-152610.png?cb=9c2a2513008702ab8e9a21dd0df82e4e) ### *2. Start fetching Piano Analytics data* From the "Datastream" tab, you will be able to query your Piano Analytics data: ![mceclip3-20240918-152810.png](https://analytics-docs.piano.io/__attachments/a_1956005adf91ecbca776e2e286bc168805748fadcd2f03a2c1840fd9e01fefcf/mceclip3-20240918-152810.png?cb=05b4a8487b13b4c4ba9dc1953364a1ee) In the "Request" section, enter the URL endpoint and body of your Data Query template: ![mceclip9-20240918-152829.png](https://analytics-docs.piano.io/__attachments/a_67577e3f2588ea5f3d3de3c9e137911b770121b24ac73cad427d34c639d3555d/mceclip9-20240918-152829.png?cb=1d0a7cb11eccfe3137f78e398890aec3) You can get these information directly from Data Query, by clicking the "Open in" button \> Copy the API body POST: ![mceclip5-20240918-152851.png](https://analytics-docs.piano.io/__attachments/a_deae2a6a62684cb8a4db05c727d29682dd082b63312610b2206662190ebea00f/mceclip5-20240918-152851.png?cb=bde9c9af5903b6bdf9790a0ffa5f560d) ![mceclip7-20240918-152903.png](https://analytics-docs.piano.io/__attachments/a_3b1884014d083a4023af41df274c49fde97d7d12a645e9a5903862a1ac81957e/mceclip7-20240918-152903.png?cb=13ce5cc8fbde2a3bb22819981a613cdc) Make the following modifications to match Piano Analytics API format: ![mceclip8-20240918-152920.png](https://analytics-docs.piano.io/__attachments/a_7bb52a9676580f412ee6885f30930cc8de96bbbddddcfdf6a0d45e0058319418/mceclip8-20240918-152920.png?cb=4ef105e2d0eea821c8f2898e1cd99d93) You are all set now, just fetch the Piano Analytics data and start building reports or digging deeper into it ! ## Additional resources * Partner's website: * Partner's documentation : --- version: "Working version" language: "en" --- # AI in Data Query We've introduced new AI features in Data Query to help you explore your data faster and get more out of every report. ## AI Reveal AI Reveal was already available in Workspaces --- we've now made it available in Data Query as well. Once you've created a dataset, you can launch **AI Reveal** to let our AI system analyze your data and surface actionable insights. ![Animation5-20260519-090202.gif](https://analytics-docs.piano.io/__attachments/a_30cadfd2782be0da4757da2fabcfe56ff50357344cad158b9ef854656f7d0f8f/Animation5-20260519-090202.gif?cb=1d564d6edee01267073f2580df28fa07) Check out our full [AI Reveal documentation](https://analytics-docs.piano.io/en/analytics/v1/piano-ai-reveal) for detailed instructions on how to use it, and what is taken into account. ## AI Query ### What is Piano AI Query? **Piano AI Query** is a generative AI-powered assistant that simplifies data exploration by allowing you to **generate datasets directly from natural language prompts** . Integrated into **Data Query**, it enables both beginners and advanced users to access complex data without writing a single line of code. With AI Query, you can: * **Ask questions in natural language** and get a relevant dataset in return. * **Save time** by skipping the manual setup of properties, metrics, and filters. ### How to use Piano AI Query To get started: 1. Open **Data Query** in [++Piano Analytics++](https://analytics.piano.io/library/#/). 2. Look for the **AI Query input** at the bottom of the page. 3. Type your question (e.g., *"What are the top traffic sources last month?"*). 4. Hit enter and watch your prompt turn into a fully functional dataset. ![Animation2-20260507-145416.gif](https://analytics-docs.piano.io/__attachments/a_3ea626affee3c30282e8219d292ec3750aa7c87839b123e0e608e6213ce487de/Animation2-20260507-145416.gif?cb=c4b1f4fe7b8ccd16516144f23cc67eaf) ### What Piano AI Query takes into account To build the dataset, Piano AI Query relies on a combination of your prompt and the underlying data model, including: * **Property and metric names and descriptions** * **Queryable time ranges** * **Access rights for sites** No prior configuration is needed, but the **quality of metadata** (naming conventions, descriptions) significantly improves the relevance of the generated queries. ### Best practices for better results * Use clear, business-oriented language in your prompt (e.g., *"How many visits came from mobile devices this year?"*). * Make sure your data model is well-documented (titles, descriptions, consistent naming). * Avoid vague or ambiguous terms when possible. * Explore alternative phrasings if the first result isn't quite right. Using **Piano AI Query** or [**Piano MCP**](https://analytics-docs.piano.io/en/analytics/v1/mcp) will result in the same output; there is no difference in using one or the other method. ### Transparency Piano AI Query is powered by **Claude**, a large language model developed by Anthropic. Behind the scenes, the feature relies on **a set of structured interactions with the model** rather than a single prompt. These exchanges are designed to: * Interpret your natural language request. * Understand and match it to the data model (properties, metrics, filters, segments, etc.). * Build a valid dataset query, iteratively refining it when needed. Currently, only **metadata and model structure** (e.g., available properties and metrics) are used in prompts. **No user-level data is passed to the model** at this stage. ⚠️ However, this may evolve: As we introduce support for more advanced query features---such as filters and segments---we may need to access parts of the **underlying dataset (e.g., from Snowflake)** to correctly format or interpret those inputs. This could involve limited exposure of user-level data in a secure and controlled way. We will update this note accordingly when that happens. All processing is conducted within the **geographic region associated with your contract**, and no data is stored beyond the active session. --- version: "Working version" language: "en" --- # Airship \[Old\] ## About Airship Launched in 2011 by Digital CRM entrepreneurs, Airship develops and provides the most advanced Push Notification Technology for Mobile Apps, Websites and Facebook Messenger. Operating in 70 countries on 5 continents, Airship is the European #1 Push Notification Technology, with over 6 billion Push Notifications sent to 750 million consumers monthly. Learn more: [https://www.airship.com/](https://www.accengage.com/) ## Discover the connector Activate your data through the connector between Airship and the *Analytics Suite 2*. Airship is a push notification tool available as a SaaS solution which enables CRM and Marketing managers to accelerate the engagement of their app users and website visitors by empowering them with all the necessary tools and features to send targeted, personalized and automated Push Notifications to their customers on desktops, mobiles, tablets and smartwatches: * Create visitor segments in *Analytics Suite 2* based on visitors behavior on your site and share them in Airship to customize the push notifications you will send; * Tag all your push campaigns to follow them in the *Analytics Suite 2* and understand which ones allow the most conversions. ## Tag your push notification Usually done by marketing teams in order to get it back on the interface. ### Tips Be careful, you have to make sure to get the xto parameter in the push notification and thus ask the developers to get this element. When using *Piano Analytics* SDK, you can add the tracker to Airship campaign in order to measure your performances on *Piano Analytics* tools. In order parameters to be correctly transmitted to the *Piano Analytics* SDK, it will be necessary to make sure that the Custom params are tracked by Airship SDK: * For iOS * Push notification : * Inapp notifications : * For Android * Through Airship , you can add custom settings to the following campaigns: * click push notifications * Inapp to display and / or click * Scheduled click alerts In order to allow the *Piano Analytics* SDK to retrieve the tracking parameters, you must follow the following steps on developers website : Once set up, you can add the AT trackers in the following form for example: * Key: xto * Value: AD-3030- \[ad_Version_7\] - \[without_text\] - \[468\] - \[[http://www.site.com](http://www.site.com/) \] - \[GT\] - \[top_page\] ![mceclip0.png](https://analytics-docs.piano.io/__attachments/a_f3d23692d26bf7c61916689b03bc5b7f8c50babde36efde9c7bf551c2ad70709/21017218134674?cb=6a86881252a02b5a0a172ec715e85093) ## Send segment to Airship *Piano Analytics* segmentations done in *Data Query* can also be sent to Airship in order to send a personalized push following visitors behavior. One use case could be to target all visitors who have seen an episode of a sitcom. The export will be composed of all these users and sent to an Airship FTP. Airship will then be able to target all the visitors of dedicated information. Use case below have been done by a streaming customer: * A segment is created to list all users who have seen an episode of The Walking Dead ![mceclip1.png](https://analytics-docs.piano.io/__attachments/a_be688e6d033744e6727f00ab50ced0a6dd6a9a35b3cf2f0a07ba42ed96f860ee/21017218136082?cb=53f5fb9d975c28d44d9af400b81a58c7) ## Privacy Activating this partnership activates the import of Airship data into *Piano Analytics* tools and the export of *Piano Analytics* data into Airship. Only the data necessary for the proper functioning of the bridge are imported an exported. --- version: "Working version" language: "en" --- # Amazon S3 WS ## About Amazon S3 Amazon S3 is an online storage service offered by Amazon Web Services (AWS). It allows users to securely and scalably store and retrieve data on the internet. The service is similar to a vast digital warehouse where you can store a variety of files, including images, videos, documents, data backups, and much more. Many businesses and developers use Amazon S3 to store their data, host static websites, and support various applications that require reliable and scalable storage. Learn more: ## Connect *Piano Analytics* with Amazon S3 ### Configure the Amazon S3 connection The sending configuration is managed from the Export tool interface, available from the main menu: ![image-20241002-095140.png](https://analytics-docs.piano.io/__attachments/a_02cdc76a1a21ff9840630ac260d367996a9f95a17cf386cb9982c36f8b3609eb/image-20241002-095140.png?cb=54b62b4c8b951b55e48e6c0917b2907e) Once on the interface, you can set a configuration from the "List of sending configurations" tab: ![image-20241002-094815.png](https://analytics-docs.piano.io/__attachments/a_2bd12f5ddbc52d9ae57188db1d02205e258f6b2ef15e75ba02c4ae6a82bd3dee/image-20241002-094815.png?cb=b8a73f01151065dac48a58cfd4d44982) Setup only takes four simple steps: 1. Fill-in connection details (name, bucket and destination folder name). 2. Enable file reception by adding the provided code into your Amazon S3 bucket access settings. 3. Make sure the connection is working by using the test button (it sends a "test" file to your destination folder). 4. Validate your settings. ![image-20241002-094856.png](https://analytics-docs.piano.io/__attachments/a_c086878fb4730c5d79fbd245baaa576570b6d32b035b54832eb6ebbe7a6e39b0/image-20241002-094856.png?cb=44226e9d34fa6fb35f3969577085ec54) After saving, your configuration will be available on the "List of sending configurations" tab. From there, you can edit or delete your configurations. ### Activate the Amazon S3 connection #### ***When creating automatic data exports from the Data Query tool*** From Data Query, once your dataset has been generated, you can export it in CSV format (held within a GZIP) using the export button: ![image-20241002-094950.png](https://analytics-docs.piano.io/__attachments/a_83b94de55b559de4bb3d3a61a0e57f07bc78ffad42ded47f1e90dabb4b076285/image-20241002-094950.png?cb=8b1cf33e38f15f51c2d9237eb1088949) By ticking the "Scheduled" type, you can access your Amazon S3 configurations: ![image-20241002-095007.png](https://analytics-docs.piano.io/__attachments/a_9bc2b2f1b0e622b9eb1075e7115a0afcfbb2eea3a71607d93c916875b2cc658d/image-20241002-095007.png?cb=b7e8e4a17c45217f29803d4a109ebf6b) ##### Notes If you have not yet set up an Amazon S3 export configuration from the dedicated interface, you can create one here by selecting "Add an Amazon S3 configuration". You will then be redirected to the same creation interface (detailed in Part 1). #### ***When creating a Data Flow export*** ##### Information Data Flow is a chargeable option from Piano Analytics solution, enabling you to export massive volumes of granular data in real time. For more information, please visit the Product page: [Data Flow](https://analytics-docs.piano.io/en/analytics/v1/data-flow.md) On the Exports tool, go to the "Scheduled exports" tab to create a Data Flow export: ![image-20241002-095119.png](https://analytics-docs.piano.io/__attachments/a_4600f6d43b91f7a034344e72b5ce734e22fe355698036e7712dd7720a4b8eeaf/image-20241002-095119.png?cb=b7e8e4a17c45217f29803d4a109ebf6b) By the end of the process, you will find the Amazon S3 connection type. Select your configuration from the drop down list: ![image-20241002-095047.png](https://analytics-docs.piano.io/__attachments/a_b2c8a7b2fb9c995901b3f07afa768af8a790974790a4bfce5e21ea3baf0cc412/image-20241002-095047.png?cb=297b46afc9d8c3652d22527dc7e0e2a1) ###### Notes If you have not yet set up an Amazon S3 export configuration from the dedicated interface, you can create one from this interface, by clicking on "Create a new connection". You will then be redirected to the same creation interface (detailed in Part 1). --- version: "Working version" language: "en" --- # Analyse and Explore your Data with Explorer ## Set the context of the analysis The functionalities allowing you to choose your perimeter of analysis (sites and periods) are located in the upper banner. ### Selecting sites The first drop-down menu allows you to select a site, several sites, or a level 2 site. The search engine integrated in the drop-down list (1) allows you to access the sites you wish to use more quickly. To select a site, click on its name (2). To select multiple sites, click on the corresponding checkboxes (2) and then click on the "OK" button. A summary of your selection is available via the link at the bottom of the drop-down list (3). ![Analyse-01.png](https://analytics-docs.piano.io/__attachments/a_20ed54833d0b27e632c626c9d31da6aa20ef56d1ba1cd50229abd5ee4e72318c/4465635934994?cb=4195694a0d8011b53f466e03abbf9d6c) On the overview screen you can view the list of selected sites, modify your selection by deleting one or more sites (1), reset your selection (2), or return to the list of all sites (3). You will then have to re-select at least one site for new data to be displayed. ![Analyse-02.png](https://analytics-docs.piano.io/__attachments/a_66f5e5f5f420e4ab15ac62d4eaa1382fe04b14524549f609840b9d74ac37a285/4465636021010?cb=097648dd8f386f622c7af1d3f82e0a62) When you select multiple sites, a "save" button allows you to save your selection as a group of sites. Once at least one site group has been created, you can find, edit or delete it from the "groups" tab (1). #### Notes The default site used will be the same as the one specified in the personalisation of your account. ### Period selection In the second menu (1) you can select the period to be analysed. Numerous shortcuts allow you to select a specific analysis period with one click without having to configure it manually (current year, current quarter, current day, etc.) (2). The scan period can also be manually configured with a start and end date entered in a calendar (3). ![Analyse-03.png](https://analytics-docs.piano.io/__attachments/a_d4382819440ae527ea331496ca8e4e204555a3fa5c73a1a913db870fcd85e1eb/4465628810130?cb=1a493cbc4a500bf81fb837d0104d8034) ### Comparison period It is possible to compare the values of the current period with those of a past period. To use this feature, you must enable the "Enable comparison" option. ![Analyse-04.png](https://analytics-docs.piano.io/__attachments/a_7f8195e05901ac1cd2df1cd428202eba5f694d923ad140320ed4366839265b82/4465606664338?cb=629336af200b78313d6c252727995d25) By default we compare the data of the current period with those of the previous period. It is possible to customize the comparison period. This option is available in the calendar : ![Analyse-05.png](https://analytics-docs.piano.io/__attachments/a_8dd13ea37695de672852fd1768767451c455c4a8e5bfa107532c2c6113429a04/4465606737042?cb=155fcb938fdf30fc63b4a59429f2c351) The comparison values will be visible on the curves and indicators of the "Preview" analyses, on the histograms (grey bars), as well as in the tables of all other analyses. ### Real time / current day You can study the evolution of the data of your site or application on the current day. To do this, select the shortcut "Today" (1) in the period selector. The analyses will be refreshed and will cover the whole day, up to the last minute of available data. Please note, for your navigation comfort, the data are not automatically updated. If you wish to refresh them, you will have to click on the "refresh" button (2). ![Analyse-06.png](https://analytics-docs.piano.io/__attachments/a_90d29e2cdaae1c0ccd3ed8dbb4f81d8b83869f53c5dbb9bf5a67dfe1c38e8ac4/4465621649810?cb=7e508e5d282c3c0003cdd1db04eab1da) #### Notes It is not possible to combine data from the current day with data from previous days in the same analysis. ## Anatomy of the analyses The vast majority of the analyses are as follows: \[1\]: Analysis information \[2\]: Graph area \[3\]: Graph toolbar \[4\]: Table area \[5\] : Segmentation \[6\]: Actions to take on the analysis ![image-20241031-090848.png](https://analytics-docs.piano.io/__attachments/a_36ebabe49ad0cab2ec82ee1641039f87d1eca74618b815f8f72711e91984c698/image-20241031-090848.png?cb=743795fd799169e2cf4db78e6098fc89) ## Analysis tree Explorer In order to guarantee quick and easy access to the data, *Explorer* offers only three levels of tree structure: family of analyses (1), analyses (2), sub-analyses (3). ### Information ![image-20241031-090832.png](https://analytics-docs.piano.io/__attachments/a_51de373c0fb4a97f57273d92d95d118e2a91ea2ddd680ad286771cfd0038fb25/image-20241031-090832.png?cb=6652fd8d4b12a455895e32b42fe90704) The URLs used in Explorer allow direct access to analyses in the context of your choice. However, these URLs may change in the future. Therefore, we do not recommend bookmarking them, but rather creating customised views. ## Working with graphs Each graph has a toolbar. From this toolbar, it is possible to * Changing the type of graph (by default, curves are proposed) (1) * In the case of curves, change the granularity (2) * Select the metric to be used in the graph (3) * Enable / disable options, depending on the type of graphic (4) : * Histograms: switch to horizontal histograms * Curves: show / hide min \& max, average, trend, enable / disable graph comparison, enable / hide event log display * Pie chart: show / hide the "Others" part * *AXON Analyst*: show/hide anomalies, trend, baseline and prediction ![image-20241031-090815.png](https://analytics-docs.piano.io/__attachments/a_40fa32c26c1e88b26bccfffe60b3300e990fc838e63ab41cc47d63fa765eedb4/image-20241031-090815.png?cb=cfb40192a10ecb52aa8952b98b595f9f) ## Working with tables ### Headers In order to facilitate the understanding and analysis of the data, the definition of each element (properties, metrics) in the table is proposed when hovering the mouse over the element's name (1). Each column can be sorted (it is not possible to sort several columns at the same time). The type of sorting as well as the filtered column are highlighted via an icon (2). Filters can be applied to the elements of each column and can fulfil several OR, or AND conditions. Each condition must contain a filter criterion (strictly superior, superior or equal, equal, inferior or equal, ...) (3) It is possible to combine filters from several columns. ![image-20241031-090801.png](https://analytics-docs.piano.io/__attachments/a_db3caba0e55f68bd70743e236e21f98b29e154f5ebdcfd081e4397dac3a2250c/image-20241031-090801.png?cb=24b7ede6eb93618dd76760c3f7f555cb) By default, only the most commonly used metrics are displayed. Additional metrics can be displayed - or hidden using the "Metrics" button at the top right of the table. ### Values ![image-20241031-090749.png](https://analytics-docs.piano.io/__attachments/a_ac7cdf305ff1fc3c0b297da5d1497bea3d071110c78d8eff92225740e52f2b65/image-20241031-090749.png?cb=dc5d829929b6b51511aedc1c2fd15b2f) The values in the table are sorted by default on the first metric in descending order. ### Drill down Some scans allow you to access additional information without having to reload the screen. This drill down functionality is materialised by a chevron, preceding each entry in the table (1). To activate it, simply click on the chevron. The drill down allows up to 3 sub-analyses to be displayed. For each one, we propose a top 5 of the elements in terms of visits (this metric is likely to change according to the analyses). If you wish to obtain the complete list of elements, click on the title of the drill down (2). ![image-20241031-090656.png](https://analytics-docs.piano.io/__attachments/a_68aaba66aa6275d1cf4ebc388ee47002e62e40cfe1de43cb9132af3e24c070be/image-20241031-090656.png?cb=544ecdcb03fb18abbce85e2730d4382e) ### Combinations To go further in your analysis, you can create cross-combination of data. To do this, click on the "combine with" button (1), then select the property on which you wish to combine. A new column is added to the table, with the property you have just added. You can add up to 3 properties in addition to the standard one in the analysis. To delete a combination, reopen the menu and deselect the items. #### Notes ![image-20241031-090642.png](https://analytics-docs.piano.io/__attachments/a_29c9438a25684f84457f6c771ed1a74dbcceb3e48bcd172ac98c7cb5fe624ba4/image-20241031-090642.png?cb=bd5b269d521db5cb735735a019bd26dd) The "total" line shows the sum of all the elements of the analysis and not the total of the displayed elements. ### Updating the graph The chart area can be manipulated from the table. It is possible to choose the elements to be displayed or hidden from each line. The interaction can be managed in two ways, depending on the needs: 1/ By clicking on the block at the beginning of the line. If the block is coloured, the line concerned will be displayed in the graph. If the block is in black and white, the line concerned will not be displayed in the graph. 2/ By selecting the elements to be displayed in the graph and then on the "Replace the items" button that appears at the top of the table. This action allows to "override" the elements of the graph and to replace them by the elements of the selection. ## Specific analyses ### Audience loyalty analysis The Audience loyalty analysis provides a very interesting perspective into how and when your visitors return to your brand's various websites and applications following a visit made on a given day. Using this analysis you will be able to instantly visualise the proportion of visitors that have returned to your site and in which timeframe. The Audience loyalty analysis is available for the following timeframes: |-----------------------|-----------------| | **Période d'analyse** | **Granularité** | | 7 derniers jours | Jours | | 14 derniers jours | Jours | | 4 dernières semaines | Semaine | | 14 dernières semaines | Semaine | | 3 derniers mois | Mois | | 6 derniers mois | Mois | **Example**: With the following retention analysis: ![image-20241031-090627.png](https://analytics-docs.piano.io/__attachments/a_9e1fe659d800701cf203e936c1055d66b6f08ad756a2a633b87636b9f15bd5aa/image-20241031-090627.png?cb=cf29f645a9cd79b670f975fbc05a8b1b) The results should be read in the following way: (1) 724 visitors visited the website on the 20th of October 2021 (2) 14.0% of those visitors returned on the following day (3) 13.7% of those visitors returned 6 days later ### Venn Diagram Visualisation The Venn Diagramme visualisation provides a very interesting perspective into the cross over between two elements. Using this visualisation will enable you to instantly visualise user behaviour across many properties. **Example**: With the following Venn Diagramm on users' devices: ![image-20241031-090612.png](https://analytics-docs.piano.io/__attachments/a_ca9e31aefeddffb1d7d4d2d6747e31ba0b89eb4c09a853c7c2f4882f770c939e/image-20241031-090612.png?cb=3c93a974b6bcbf5a85b18a505eafb964) The results should be read in the following way: (1) 404 users reached the site exlusively via mobile phones. (2) 508 users reached the website at least once via a mobile phone. (3) 89 users reached the site exlusively via mobile phones \& tablets. (4) No user reached the website at least once via a mobile phone and a tablet. ![image-20241031-090556.png](https://analytics-docs.piano.io/__attachments/a_1a4e5f56ed70ede563e5258b4e3f1bd13bacec6335d752a5851f846a1d9423e8/image-20241031-090556.png?cb=4117ee9a25b963b3f29607ea2e15a9e0) (5) The Venn Diagram will highlight the corresponsing area when you hover over a specific element with your mouse. In this example, the area highlighted in green represents the user that reached the website exclusively with Tablets, excluding cross over with mobile phones and desktop. ## Segmentation ### Create a segment Each analysis can be segmented according to the criteria of your choice. Segments can be created or selected from the "Segmentation" bar. To create a segment from the segmentation bar, click on the "Add a segment" button (1). You will then have the possibility to create a segment on the fly, or to apply a segment previously created in *Explorer* or *Data Query* (2). ![image-20241031-090533.png](https://analytics-docs.piano.io/__attachments/a_ffb60e20b717b19803df92238a9b182a76188aee4919fb2a36681de90ec7dcb7/image-20241031-090533.png?cb=79b53333a9ae78fbe416c29728d48be0) Any segment created on the fly will be available in all analyses - as long as the browser session remains open. #### Good to know A segment on the fly can cover up to 3 properties at a time. Each property can then contain up to 10 selected elements. For more advanced needs we recommend the use of advanced segmentation. ### Use a saved segment Segmentation in *Explorer* can also be performed from segments that you have created and saved in *Explorer* or *Data Query*. By default, all saved segments you have access to are listed in the "Existing segments" tab. #### Good to know ![image-20241031-090512.png](https://analytics-docs.piano.io/__attachments/a_ff2acd33462a24389415c0bbd81d48971b4cd9182c1f60e68887d1dbf31ffe02/image-20241031-090512.png?cb=041611a83193a9277f394fccefad123f) It is not possible to combine several recorded segments with each other, nor is it possible to combine a "live" segment created on the fly with a saved segment. ### Apply a segment In the segmentation bar, each segment is represented by a button. The bar makes it easy to switch from one segment to another in order to easily and efficiently compare the data of an analysis according to different segmentation criteria. This toggle is done via the "segment" button. Each button is built in the same way: (1) Scope of the segment (by default, in *Explorer* , the scope is "visit") (2) Actions to take on the segment: Activate, Deactivate or Delete ![image-20241031-090458.png](https://analytics-docs.piano.io/__attachments/a_6a018ef28ef3cef4a177f4a8f527fc02c55861dcfdfc3af31e0a6aaba89de56e/image-20241031-090458.png?cb=a18c6b929fb8b3d6ec3458e14ec7997e) If no segment is applied, select the "Activate" action of the segment of your choice to activate it. Proceed in the same way if you wish to switch to another segment than the one applied. The old segment will automatically be deactivated in favour of the one you have just selected. If you wish to deactivate a segment, use the "Deactivate" action. When a segment is activated, the corresponding button is highlighted with an orange border. Once the segment has been applied, an orange band summarises its composition at the top of the analysis. #### Tip It is possible to compare segmented and non-segmented traffic via the "Comparison: non-segmented" option of the curves. ## Customised views You can save all the modifications (filters, sorting, cross-referencing, etc.) made in an analysis in the form of "Views". These are then accessible in the Explorer submenus. ### Create a view Click on the star at the top right of the analysis to save your view (1). Enter the information required to create it: name (required), description (optional, this will allow you to understand the details of what is behind the view), default view or not (see below). Once you have validated the creation of the view, it will appear in the level 3 menu, instead of the standard analysis. Click on the chevron next to the analysis name to display all the views available for this analysis (2). #### Note ![image-20241031-090433.png](https://analytics-docs.piano.io/__attachments/a_297144b3a84d10a9f89a74035d15e381a56b2e41cedc857465c21db1a80223f5/image-20241031-090433.png?cb=81e1a9e8dd7c4dac958fef546ba5c700) The saved items are as follows: * Graph type (including *AXON Analyst*) * Graph options (except comparison) * Graph Metrics * Combinations * Filters, sorting applied in the table * Metrics added / deleted in the table * Hidden columns This means that segments, sites and analysis periods are not taken into account when saving. ### Set a default view You can replace the standard view of an analysis at any time with the customised view of your choice. This setting can be managed directly when creating the view, or by clicking on the 🏠 icon in the list of analysis views : ![image-20241031-090414.png](https://analytics-docs.piano.io/__attachments/a_bb11a4e4b1e258e55cb8daaad730b9244fc428ab01dbdf5c25938e91ea5c7b04/image-20241031-090414.png?cb=ccbea9e3137624cb19470b1420f81119) ### Share a view It is possible to share your views with other users in your organisation. To do this, select the option "Everyone can use this view" when you register. ![image-20241031-090344.png](https://analytics-docs.piano.io/__attachments/a_fd6dce5e74383a61be906821b60606aa6245131ab08b35e47c0f15ce1277baf9/image-20241031-090344.png?cb=34e2c8086bdf15d3fde186a46ce39f1e) The shared views are displayed in the same place as your own views, in the "Shared views" category. ### Delete a view To delete a view, hover over the list of views in the scan and click on the bin next to the view. You will be asked for confirmation before the final deletion. #### Note Standard views cannot be deleted. Only the owner of a view can delete it. ## Events \& notes It is possible to annotate Explorer's analyses to record contextual information that may be useful: current event, launching a new application version, server problems, beginning \& end of sales etc. These events can be created from any analysis. To create an event, you must display your data in the form of a curve. By hovering over the curve, and for each of the drawn points, you will have the possibility to add an annotation via the "+" button. ![image-20241031-090326.png](https://analytics-docs.piano.io/__attachments/a_f02f3e3db3679ef717999aaa0b7a6fa7375e9a9eb4a99141b3a0a7518d8bb340/image-20241031-090326.png?cb=aa1668ddb6343268ba0ff59fb6f3f43a) Enter your text, as well as the scope of the annotation. By default, this is "public", which means that it is visible to all members of your organisation. If you do not wish to share this information, simply deselect the "public" box and validate. ![image-20241031-090256.png](https://analytics-docs.piano.io/__attachments/a_09a59f9c4c65947dc88fc2dd806f99bf0e3b780fcddd6b8c6cdade2a1bfb300c/image-20241031-090256.png?cb=43df87bfff250dbbdeaacea63ca11bd6) The events created appear as bubbles at the top of the curve. To display the text of the annotation, click on the speech bubble. To delete it, hover over the text: then click on the trash can. You will be asked for confirmation. To avoid visual overloads, you can disable the display of this event log. To do this, open the options in the graph and deselect the option "display events". ![image-20241031-090244.png](https://analytics-docs.piano.io/__attachments/a_a97fd376a2c23d200ee2c2a4dab6508d68a2f419385ba05f333b47fd1a0b2882/image-20241031-090244.png?cb=e5694e755f589dd2acd66a43897adbae) ### Information Shared annotations can be administered by all members of your organisation, which means that they can be deleted by people other than you. --- version: "Working version" language: "en" --- # Analytics Consulting Services ## **Maximize the value of your Piano Analytics data!** The Piano Professional Services team supports you to ensure that every piece of data collected is reliable, structured, and actionable, so you can accurately steer your performance and make truly data-driven decisions. ### **We understand your challenges** ![image-20260106-095603.png](https://analytics-docs.piano.io/__attachments/a_9192c6762053ac20bd0b74c341fee9d9832118e274b53ee274c3e2d27ee2b17b/image-20260106-095603.png?cb=efb1decc4fa6609c59c12979db7add1b) ## **Our consultants support you at every key phase of your Analytics projects** ![image-20251229-092019.png](https://analytics-docs.piano.io/__attachments/a_d16036cf7f2d6dee5cafc3df7a617916322095edb2eeadf80f10b57993f5b63d/image-20251229-092019.png?cb=9593bf2948daab3ae576cd78efe08a56) **Onboarding** ### **Where it all begins** We lay the foundations of Piano Analytics by aligning your business challenges with your analytics needs. The goal is to define what to measure, why to measure it, and how to monitor it from day one, in order to build a clear view of your performance. → Frame your business objectives and translate them into relevant KPIs → Align teams around a shared tagging plan and data model → Deploy initial reports to immediately analyze your data and user journeys *** ** * ** *** **Data collection** ### **Capture the data that drives your decisions** We ensure reliable, continuous data collection across all your environments and new features, building a solid foundation for clear and consistent analysis. → Define a structured tagging plan that reflects your journeys and objectives → Ensure clean, stable data collection, deployed with or without a TMS → Configure and enrich Piano so your marketing and behavioral data are properly leveraged *** ** * ** *** **Monitoring** ### **Illuminate your decisions with reliable, actionable insights** We analyze your journeys, user behaviors, and conversion dynamics to understand what drives interest, creates value, and limits performance. → Detect breaks, key variations, and weak signals impacting your results → Analyze journeys to identify levers of interest, engagement, and conversion → Extract clear trends to guide your marketing, product, and business decisions *** ** * ** *** **Optimization** ### **Identify gaps and hidden opportunities** We audit your journeys, dashboards, and configurations to uncover improvement levers, simplify what exists, and strengthen what creates value. → Identify high-impact improvement opportunities → Reveal untapped opportunities within your existing journeys, indicators, and reports → Improve tagging efficiency to collect data that truly supports decision-making *** ** * ** *** **Data governance** ### **Ensure controlled, consistent, and compliant data to support decisions** We structure a clear and sustainable Analytics framework aligned with your business challenges and regulatory obligations (GDPR, ePrivacy, HIPAA, etc.). The goal is to guarantee reliable, secure, and responsibly used data across the organization. → Ensure KPIs are consistent and interpreted the same way by all teams → Structure simple, accessible documentation to streamline usage and knowledge transfer → Integrate privacy requirements (GDPR, consent, data minimization) into all Analytics practices ## **Let's discuss your upcoming projects with a Piano Analytics expert (20 min)** A short discussion to identify your challenges, critical data, and immediate actions to take (no commitment). 📧[**Contact us !**](mailto:consulting.analytics@piano.io) --- version: "Working version" language: "en" --- # API Keys ## Definition An API Key is a string of characters that can be generated by a user after the authentication on Piano Analytics. An API Key aims at being used when querying Piano Analytics REST API instead of providing login details using basic authentication. ## Rely on an API Key An API Key gives the same permissions as the user who created it. If the user loses rights on a site, then he won't be able to use his API key to get data on this site anymore. If the user gets rights on a new site, then he will be able to use his API key to get data on this site. The API Key aims at being used with REST URLs retrieved from . We invite you to use an API Key instead of providing login details using basic authentication, when querying the API with an external tool (Script or other). If you are an SSO user, you must use an API Key to query Piano Analytics REST API. ## Rights to create an API Key An API Key can only be created by an authenticated user who can manipulate data. This user must have at least one of the following roles: * Administrator * Delegates * Advanced Analyst * Analyst * or Custom Role with the "Handle data" tool * Data Supervisor The API Key is created, enabled, disabled and deleted by each user independently. ## Display your existing API Keys The API Keys are displayed under your Profile page \> API Keys tab, in a table providing the user with the following information: 1. Name of the API Key 2. Description of the API key 3. First characters of the API Key (Access Key) 4. Creation date 5. Date of last use 6. Status of the API Key: Active/Inactive ![2023-10-25_16h09_40.png](https://analytics-docs.piano.io/__attachments/a_dcdfb55957774c9b8f55a9db6c3c9b90b47c936e5eb10574b281ea72842ea7f0/14659588213906?cb=250f39ef0c233f04e0d7dcfd3e05ca86) ## Create an API Key 1. Click on \<\< See profile \>\> 2. Open the*\<\< API KEYS \>\>*tab 3. Click on the button \<\< Create a new API Key \>\> 4. Enter a name and a description 5. Validate with the button *\<\< Create a new API key \>\>* 6. Copy the API Key by clicking on the Copy button and save it in a safe place 7. Confirm the action by checking the check box ![2023-10-25_15h13_12.png](https://analytics-docs.piano.io/__attachments/a_f2b41f8c7b085234b4fb6049178232af331218ee780b737e73fd43f790ffbc95/14659588222482?cb=df1c65c85660d2cd7e5422f301cea16d) ![2023-10-25_15h10_50.png](https://analytics-docs.piano.io/__attachments/a_e967fac54380c475ded21801eb7442b69903a9cc5932e51d715262ec3f6837f7/14659528456978?cb=feb7e43199c06f57417aac0c242ec7d3) Please note that for security reasons, the full API key(accesskey_secretkey) will only be displayed once during the process described above. A user can generate an API Key for each project/use of Piano Analytics REST API. To easily identify the API Key on the interface, we recommend that you give clear and accurate name and description to each API key. ## Use an API Key Depending on the environment requesting the API, you can use various parameters: ### From an external environment like Postman [Postman](https://www.getpostman.com/product/api-client)is a program that can help you trigger API calls outside your browser, specifying request headers and handle authentication. In Postman or any other solution you use to call APIs you can rely on these 2 methods. * **Request header** After adding your API call URL in the GET field, get in the Headers tab and add a new request header named *x-api-key* with the value matching this format *accesskey_secretkey* . * **Basic authorization** You can get in the *Authorization* tab to pick *Basic Auth* and fill *UserName* field with your *Access Key* and *Password* with your *Secret Key* . ![16338385417490](https://analytics-docs.piano.io/__attachments/a_84aed7f16fa12444e00d20cbd84aa6b1216be50164ef2a7ca995951a7847738f/16338385417490?cb=c17755c42b48e0df24793516cee09253) ![16338385403666](https://analytics-docs.piano.io/__attachments/a_b456e4ad7294ff41149d36f4d46797d426ba158f87c8fb0c26a9116f8493d367/16338385403666?cb=3c89c2973e4a0261744a4aaab94f474c) #### From a browser * **Standard direct URL** NoteThis method is the least secured, because your credentials could potentially be listened/stolen by malicious software. If you can rely on any other method please do the switch. Pick your configured API call URL from *Data Query* and trigger the call in a new tab. You will then see a login form from your browser requesting an *Access Key* and a *Secret Key* . Fill these fields in, press enter and get your results. * **Prefixed URL** Pick your configured API call URL from *Data Query* and add your *Access Key* and *Secret Key* like this *accesskey:secretkey@* as a prefix to your call. This will add the *Access Key* and *Secret Key* as a request header when you trigger the call and get your results. https://3d0860524341:ee5076836541d5g75he2f49e5d133dacc8762ccb@api.atinternet.io/data/v2/json/getData?&columns={d_source_global,m_visits}&sort={-m_visits}&space={s:123456}&period={R:{D:'-1'}}&max-results=50&page-num=1 ![16338398432914](https://analytics-docs.piano.io/__attachments/a_2cd9f49f95e7ccb33abef3f473ea61f13e5c063491748bda735f6a336966b71f/16338398432914?cb=a23ee783051a6996fbb7d08be6c1416b) ## Edit an API Key From the table displaying all the API Keys, the user can edit each of them to: 1. Update the name or description 2. Make the API Key Inactive As soon as an API Key is inactive, it can be deleted by the user. Please note that deleting an API Key is a definitive action. A deleted API Key cannot be recovered. ## Secure your API Key If you use API Keys, please make sure: * To keep them in a safe place. * If you have to share an API Key with someone, create a new one with a specific name and description and then disable or delete it as soon as you can. * To delete the useless API Keys on a regular basis. * To renew the API Keys used in your programs on a regular basis. ## Check your organisation's API Keys usage ### Quick view Administrators and delegates can see in Access Rights' Users table, the last use of an API Key per account. ![mceclip0.png](https://analytics-docs.piano.io/__attachments/a_f1c5c19ec0eee665858cf52951c6d4ecfe34c1b178e42ca850719eb49da6434c/4466036579602?cb=b233e9c3ef36d17acb962bde9c0703dc) --- version: "Working version" language: "en" --- # Which metrics are specific to mobile apps? The Explorer menu "App Analytics" offers analysis proper to your mobile apps data, also available in Data Query. You can know more about the metrics' calculations methods by hovering their label from our tools. Here is a list of definitions associated to these metrics: | **Metric label** | **Metric key** | **Definition** | |---------------------------------------|--------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | **App - Sessions** | `m_app_session` | A set of events that begins when an application is launched or brought into the foreground, and ends when the application is sent to the background for more than 60 seconds (adjustable) or when the application is closed. Calculated from the property `app_sessionid` (App - Session ID). | | **App - New visitors** | `m_app_newvisitors` | Number of visitors who install the application for the first time, or reinstall it after having uninstalled it. During a given day, a visitor can only have a single status: New or Returning. Calculated from the property `app_visitor_status` (App - Visitor status). | | **App - Returning visitors** | `m_app_returnv` | Number of visitors on a given day who are not new (2nd day of use). Calculated from the property `app_visitor_status` (App - Visitor status). | | **App - Crashes** | `m_app_crash` | A technical incident which closes the application and interrupts the user experience. Calculated from the property `app_crash` (App - Error name). | | **App - 1st sessions** | `m_app_news` | Number of 1st sessions that took place following the application installation, or following its uninstallation and reinstallation. Calculated from the properties `app_sessionid` (App - Session ID) and `app_session_status` (App - Session status). | | **App - New visitors sessions** | `m_app_session_newvr` | Number of sessions made by a new visitor. Calculated from the properties `app_sessionid` (App - Session ID) and `app_visitor_status` (App - Visitor status). | | **App - Returning visitors sessions** | `m_app_session_returnvr` | Number of sessions made by a visitor from the 2nd day of use (they become a returning visitor). Calculated from the properties `app_sessionid` (App - Session ID) and `app_visitor_status` (App - Visitor status). | | **App - Time spent / session** | `m_time_spent_per_app_session` | Average time spent per app session for the site. Calculation: cumulative time spent / app sessions with duration. Calculated from the metrics `m_time_spent` (Time spent) and `m_app_session` (App - Sessions). | For more information regarding properties proper to mobile apps, you can also reach [our technical documentation](https://developers.piano.io/analytics/data-collection/how-to-send-events/collection-api#application-lifecycle). --- version: "Working version" language: "en" --- # Appsflyer ## PA Connect AppsFlyer Integration ### About AppsFlyer AppsFlyer is a leading mobile marketing analytics and attribution platform. It enables businesses to accurately measure campaign performance across channels, attribute user acquisitions to specific marketing efforts, and optimize strategies through AI-powered insights while maintaining privacy compliance. With strengths in processing data from billions of devices, offering robust fraud protection, and providing over 2,000 platform integrations, AppsFlyer serves as an essential tool in today's fragmented digital landscape, helping marketers transform complex data into clear, actionable decisions that drive growth and enhance customer engagement while navigating evolving privacy regulations. ### PA Connect AppsFlyer Transform your mobile marketing strategy with **PA Connect AppsFlyer**. This powerful integration creates a unified data ecosystem that bridges mobile attribution with comprehensive user analytics, enabling you to make data-driven decisions across the entire customer journey. By connecting Piano Analytics' advanced segmentation capabilities with AppsFlyer's robust attribution platform, you eliminate data silos and unlock deeper insights into user acquisition and engagement. Track complete user journeys from initial campaign interaction through app installation and beyond. Leverage AppsFlyer's precise attribution data to understand which marketing channels drive the highest-value users, while utilizing Piano Analytics' behavioral insights to optimize post-install engagement strategies. Access unified reporting that combines acquisition metrics with detailed user behavior analysis, empowering you to measure true campaign ROI and lifetime value attribution across all touchpoints. ### Connector Principles **AppsFlyer Integration:** AppsFlyer's attribution system initiates when users engage with marketing campaigns and completes at **first app launch** (attribution is based on launch timestamp rather than download time). The integration operates through: • **SDK Implementation**: Mobile applications incorporate AppsFlyer's SDK, generating a unique AppsFlyer ID during initial app launch A postback notification is subsequently transmitted to Piano Analytics to validate the `app.install` event, including comprehensive marketing source attribution data. The AppsFlyer postback also includes the user_id (Piano Analytics identifier) containing the AppsFlyer customer user ID for seamless cross-platform tracking. **Piano Analytics Integration:** AppsFlyer events are automatically synchronized with Piano Analytics visits without requiring manual intervention. The marketing source identified by AppsFlyer becomes the attributed traffic source for the corresponding Piano Analytics visit. **Implementation Requirements:** * Active Piano Analytics account * Configure the `app.install` event within your Piano Analytics Data Model * Active AppsFlyer account with proper SDK integration ### Analytics \& Reporting in Piano Analytics Access comprehensive reporting on marketing sources that drive application installations, combined with detailed analysis of subsequent user engagement patterns and behaviors. --- version: "Working version" language: "en" --- # Are periods limited on the Reporting API? Information in this article is not only restricted to the Reporting API, but also all the other Piano Analytics interfaces (Boards, Data Query, etc.) Yes. By default, Piano Analytics enforces a **25-month rolling data retention period** for all organizations. For example, if your organization's retention is 25 months, **data from January 2020 would no longer be available starting in February 2022**. ## How retention works (rolling window) * The retention window is **rolling**, meaning it continuously moves forward with time. * Once data is older than the configured retention period, it is **purged** and is **not retrievable** via the UI or API. ## Availability considerations * The **oldest available data** for any organization is generally **the current date minus the retention period** (25 rolling months by default). * If your organization migrated from a previous analytics solution or legacy interface, **historical availability can differ** due to differences in processing and platform deployment timelines. In that case, your earliest accessible date may be later than what the retention period alone would suggest. ## Keeping data longer than 25 months If you need access to data beyond the default retention period, consider these options: * **Historization (recommended):** Set up a process to **export and store datasets regularly** (weekly, monthly, or yearly) so you retain your own historical archive outside of Piano Analytics. * **Retention extension:** Piano can offer **extended retention options** beyond 25 months. Contact your **Account Manager** to discuss feasibility and pricing. --- version: "Working version" language: "en" --- # As an admin, why can't I delete a specific user account? If the **Delete** button for a user account is greyed out/disabled, it is typically because the user is assigned as a **Delegate** in one or more **Delegations**. Delegate accounts cannot be deleted while they still have an active delegate role. ## How to enable deletion for a delegate user To delete the user, you must first remove them from all delegations where they are a delegate: 1. In the **Access Management** , select the relevant **Delegation** as a perimeter. 2. Go to **Delegates management**. 3. Locate the user in the delegates list. 4. Click the **cross (×)** at the end of the user's line to remove them as a delegate. 5. Repeat for any other delegations where the user is listed as a delegate. Once the user is no longer a delegate in any delegation, return to the user's profile---the **Delete** button should now be enabled, and you can delete the account. ## Troubleshooting * **Delete is still disabled after removing the delegate:** Confirm the user was removed from **every** delegation (a user can be a delegate in multiple delegations). The delete option will remain disabled until all delegate assignments are removed. --- version: "Working version" language: "en" --- # Attribution in Explorer ## The Tool's Objective ### Introduction Attribution in online marketing is the process which credits conversions to the correct marketing activity (or combination of activities). With the rapid increase in the number of channels and platforms available, it has become essential for marketers to be able to correctly evaluate the contribution of each campaign and each online action to determine which combinations of the marketing mix increases conversions/revenue. The Attribution analysis provides an in-depth analysis of your marketing activities' performance over a chosen analysis period according to you chosen attribution models. Custom-built visualisations and innovative analysis customisation features have been added within this analysis' work environment to enable you to tailor the analysis to your needs. ### Location The attribution analysis is located in P*iano Analytics*' side menu: ![image-20241108-103007.png](https://analytics-docs.piano.io/__attachments/a_40d157ecc4dc8f315e7056893fdffa293f01074d3fb46fc3ba98d127ce89089c/image-20241108-103007.png?cb=3e521ccb1c784bfa884ded494ac29826) ### Definitions **Touchpoint** --- interaction between a brand's marketing advertisement and a customer. **Attribution lookback window**--- the length of time (in days) used to reconstruct the consumer journey prior to the conversion. **Conversion sequence** --- the series of touchpoints preceding a conversion. ### Analysis data prerequisites Ensure you are collecting the correct data in order to have an accurate and fully functioning attribution analysis. The attribution analysis enables you to attribute credit for sale revenue or any of the goal types you have set up. Make sure you are collecting this information via tags in order to have this data available in the analysis. The attribution analysis can attribute campaign information. Make sure you are collecting this information properly to have an accurate distribution of your sales credits amongst your various marketing activities. ### User stitching To attribute the correct credit to the various marketing activities, we recreate user journeys for each conversion that took place in the analysis window. To do this, we look back at all the interactions between the user and the brand (touchpoints) and stitch them together using two identifiers: * **User ID** --- When available, we use the User ID first to stitch interactions across devices. This is how Piano achieves accurate cross-device tracking for logged-in or identified users. * **Visitor ID** --- Cookie-based or mobile identifier. Used to retrieve interactions from before a user was identified (e.g., before login or registration). The attribution lookback window parameter determines how far back the analysis will look to reconstruct user paths. **Don't use a default User ID for unidentified users** Setting a default value such as `"guest"` or `"anonymous"` for all unidentified users is a very bad tagging practice. Because the attribution algorithm relies on the User ID to stitch user paths, passing the same value for many users will cause them to be treated as a single user --- producing one large, artificial user path made up of millions of touchpoints. The result will be **inaccurate attribution data** that doesn't reflect actual user behavior, and downgraded performance. ### How touchpoints are counted A few rules govern how touchpoints are identified within a conversion sequence. Understanding them helps you interpret your attribution results correctly. #### One source per visit Each visit contributes one touchpoint to the sequence, identified by the **source of the visit** . If a visitor enters your site via Direct Traffic and later interacts with a Sponsored Link within the same visit, the touchpoint for that visit remains **Direct Traffic** --- the Sponsored Link will not appear as a separate touchpoint. This reflects how visit sourcing works in Piano Analytics: the source is attributed at the start of the visit and doesn't change mid-session. #### Visits without a source Some visits may not have an identifiable source. Rather than removing these from the sequence (which would inflate the credit given to other touchpoints), they appear as `-` in the touchpoint sequence. This preserves the structure of the user journey while signaling that no source could be attributed. #### Organic and marketing sources both inform the calculation When attributing by **campaign**, only campaign touchpoints appear in the displayed results --- but the model still considers all sources (organic and marketing) during the calculation itself. This avoids overweighting campaigns. For example, take a path of `Direct Traffic → Sponsored Link → Direct Traffic`. If organic sources were excluded before the calculation, Sponsored Link would receive 100% of the credit --- overlooking the role of the two Direct Traffic touchpoints in the actual journey. By keeping all sources in the calculation, the model distributes credit more realistically. ## Attribution models **First-touch**--- In a first-click model, the first touchpoint obtains 100% of the credit for a conversion. **Last-touch**--- In a last-click model, the last touchpoint obtains 100% of the credit for a conversion. **Last non-direct touch** --- In a last non-direct touch model, each conversion is attributed to the last non-direct traffic interaction preceding a conversion. If the consumer journey consists solely of direct traffic interactions, the conversion is attributed to direct traffic. **Linear** --- In a linear (or uniform) model, the credit is shared evenly between the various touchpoints. **U-shaped** --- In a U-shaped model, the credit is shared between all touchpoints in the following way: * 40% for the first touchpoint * 40% for the last touchpoint * 20% shared amongst all other touchpoints **Time Decay** --- In a time decay model, the credit is shared amongst all the touchpoints with weights increasing linearly the closer in time a touchpoint is to the sale. **Shapley Value** --- The Shapley value model attributes a conversion according to weightings defined by our Shapley value algorithmic model based on each interaction's contribution. The model evaluates the importance of each source by analyzing how often conversions occur **without** that source: if very few paths convert without a given source, that source is considered highly important and receives more credit. The Shapley Value model is well suited to understanding which touchpoints are genuinely driving conversions, beyond their position in the journey. ## Work Environnement ### Analysis scope ![image-20241108-102944.png](https://analytics-docs.piano.io/__attachments/a_998522085ad0a0d80519543083d505f62c750ec8dc60bdca638375d790829d4a/image-20241108-102944.png?cb=3e521ccb1c784bfa884ded494ac29826) 1. **Site Scope** --- For each attribution analysis, you will need to specify the site or group of sites you wish to analyse. This site selector benefits from useful features such as an integrated search engine to facilitate access when searching for your analysis perimeter. 2. **Calendar** --- Within the calendar dropdown, you will be able to select the period you wish to analyse. The attribution analysis will look at all sales or primary and secondary conversions that took place within this period and attribute their value to the various marketing activities. ### Attribution parameters ![image-20241108-102930.png](https://analytics-docs.piano.io/__attachments/a_74d06d98c4bfd05f6e3cd6b8c15e4bc7623be5616f63dfe1509241f640d91ca4/image-20241108-102930.png?cb=6b358b40e288834395fe3df93aef3417) 1. **Attribution lookback window**--- with this selector you can choose how many days before a conversion the analysis will look back to reconstruct the consumer journey. 2. **Touchpoint type**--- with this selector you can select the level of granularity of your analysis. You can choose to attribute overall traffic sources, or attribute all the way down to marketing campaign level. 3. **Conversion type** --- Choose whether to attribute **revenue** or **goal-based conversions**: * **Monetary** --- Attributes the revenue value of each sale to the contributing touchpoints. * **Goal-based** --- Attributes the number of conversions (one per completed goal). Choose a primary, secondary, or custom goal. * You will find additional information on how to tag a goal type [here](https://support.piano.io/hc/en-us/articles/4465982438546-Declare-a-goal-with-Data-Management#Portingoverthepagegoaldeclaration). 4. **Attribution models** --- With this selector, you can choose one or more attribution models to credit conversions to your different marketing activities. 5. **Run button**--- The run button updates the attribution results based on the parameters you selected above. For data quality reasons, **offsite conversion events** (events without a visit ID) are ++not++ included in the attribution analysis. ## Available analyses ### **Sequences** The sequences analysis is the first tab in Attribution. Once configured with your attribution parameters, the sequences tab contains top-line KPIs as well as a line graph summarising your performance over the analysis period. The sequences table highlights the top 20 most frequently used paths over the attribution lookback window for the conversions that took place over the analysis period. ![image-20241108-102916.png](https://analytics-docs.piano.io/__attachments/a_04f3937e846438b3dd034c205dd9d4cb08eb27404838a9ffbb3fa7c56fb76180/image-20241108-102916.png?cb=93d0317647b2ffaa5189d85daf6f664e) ### **Models** The models tab highlights the credit attributed to your traffic sources or campaigns based on the attribution models you chose in the analysis configuration. ![image-20241108-102902.png](https://analytics-docs.piano.io/__attachments/a_0a9cac34a8baead0ca2a333b3120cdb5b95571dd6c0b36c9bdd5a4548ef32c07/image-20241108-102902.png?cb=cc7ba7ac9ce5d0c35f86b8de0dd18b5e) ### **Conversions** The conversions tab organises conversions by number of touchpoints types present in each sequence. For example: * A conversion with the following sequence: "direct traffic \> search engines" will be classified in the column "2" * A conversion with the following sequence: "direct traffic \> direct traffic"\>"Search Engines" will be classified in the column "3" ![image-20241108-102845.png](https://analytics-docs.piano.io/__attachments/a_da9ecd2d8d14396152b0eec88725b0c7d02c5c069aaefd8821d488b8080b7d49/image-20241108-102845.png?cb=83fb90ebe3885ac42916ba5241190b0a) ### **Duration** The duration tab organises your conversions by the number of days that went by between the first touchpoint and the conversion. For example: * A conversion where one day went by between the first interaction and the conversion will be sorted in the column "1". * A conversion where a user first visited the site on the 1st of December and made a purchase on 3rd of December will be sorted in the column "2". ![image-20241108-102835.png](https://analytics-docs.piano.io/__attachments/a_c0adddd819cbc35de59c7bee7eb96456fbc2d3d406202f233d96e1d7584aeedd/image-20241108-102835.png?cb=ace67909ddcfa8309523038c2ce5fa7e) --- version: "Working version" language: "en" --- # AV Insights (FAQ) * [AV Insights tracking without the Piano Analytics SDK.](https://analytics-docs.piano.io/en/analytics/v1/how-do-i-manage-av-insights-in-server-side.md) * [How is time spent on page and AV Insights contents calculated?](https://analytics-docs.piano.io/en/analytics/v1/how-is-time-spent-on-page-and-av-insights-contents.md) * [What is the difference between AV - Playbacks / AV - Plays / AV Sessions ?](https://analytics-docs.piano.io/en/analytics/v1/what-is-the-difference-between-av-playbacks-and-av.md) * [Why AV Insights has different values between real time and historical data?](https://analytics-docs.piano.io/en/analytics/v1/why-av-insights-has-different-values-between-real-.md) * [What processing is done on the AV Session - ID property (av_session_id)?](https://analytics-docs.piano.io/en/analytics/v1/what-processing-is-done-on-the-av-session-id-prope.md) * [What is EBVS and how do I reduce a high EBVS rate?](https://analytics-docs.piano.io/en/analytics/v1/what-is-ebvs-and-how-do-i-reduce-a-high-ebvs-rate.md) * [Why is my playback time exceeding the content duration?](https://analytics-docs.piano.io/en/analytics/v1/why-is-my-playback-time-exceeding-the-content-duration.md) * [How does the av.heartbeat event work?](https://analytics-docs.piano.io/en/analytics/v1/how-does-the-av-heartbeat-event-work.md) * [How do AV sessions work in Piano Analytics?](https://analytics-docs.piano.io/en/analytics/v1/how-do-av-sessions-work-in-piano-analytics.md) --- version: "Working version" language: "en" --- # AV property calculation between two events Data Flow strives to provide you with the highest quality information as quickly as possible on each event collected. However, some information (such as the time spent between two events for example) can only be calculated once the second event has been received. For technical reasons, the information concerning the difference between two events can only be calculated and attributed back to the second event. This is problematic for the following reason, let us take two events: 1. av.start at 12:00:00 2. av.pause at 12:01:00 The av_duration property will be equal to 00:01:00 and when shared in real time by Data Flow would be attributed to the second event. In reality, the event that lasted one minute was the first, av.start event. For this reason, this technical nuance in the data can lead to misunderstandings and consequently to incorrect calculations. As we always aim to provide you with the highest quality information, we have chosen not to include the following metrics from Data Flow while providing you with the precise calculation rules to recreate them on your end once the data is received: * av_duration * av_cursor_difference * av_playback_duration * av_buffer_duration * av_rebuffer_duration Here are the precise rules to calculate these properties between events if you wish to recreate them on your end: * **av_duration :** difference between event_time ++AND++ event_time * **av_cursor_difference :** difference between av_position ++AND++ av_position * **av_playback_duration :** difference between event_time ++AND++ event_time ++WHEN++ : event_name = ('av.heartbeat','av.start','av.resume') ++OR++ (event_name = ('av.forward','av.backward') ++AND++ (event_name = ('av.heartbeat','av.pause','av.buffer.start','av.rebuffer.start'))) ++OR++ (event_name = ('rm.refresh','rm.play','rm.info')) * **av_buffer_duration :** difference between event_time ++AND++ event_time ++WHEN++ event_name = ('av.buffer.heartbeat','av.buffer.start') * **av_rebuffer_duration :** difference between current event_time ++AND++ event_time ++WHEN++event_name = ('av.rebuffer.heartbeat','av.rebuffer.start') **Caution**: these calculations must be done by segmenting on visit_id, av_session_id, av_content_id. --- version: "Working version" language: "en" --- # Axeptio ## About Axeptio Axeptio is a French consent management platform, GDPR and ePrivacy compliant. The tool relies on simple integration with no technical prerequisites, as well as a pleasant user experience that respects users. Axeptio strives to establish a bond of trust between the platform and its users so that consent is given in full awareness. The solution is installed on over 33,000 sites and applications, and reaches nearly 33 million users every day. To learn more, visit: ### PA Connect Axeptio The Axeptio connector allows you to manage the visitor consent through the audience measurement cookies thanks to our "Consent Management" tagging methods, but also to automatically tag your visitors' interactions with your consent management platform. This provides you with numerous indicators for analyzing consent, such as: * Number of times the CMP is displayed * Response rate * Consent rate * etc #### Important Marking interactions on your CMP is based on the declaration of two custom events (see below). Collecting these events is optional (the option must be checked via the Axeptio CMP). If you accept and declare these events in your Piano Analytics Data Model, they will be invoiced like standard events. ### Connector principles This document aims at guiding you through the activation of the Hybrid measure using ***PA Connect*** ***Axeptio***. Hybrid measure combines the best of both worlds by allowing you to combine CNIL exemption with consent (opt-in). ![CMP (1).png](https://analytics-docs.piano.io/__attachments/a_5dc33fe4f8da2541bd434d19645dcc3976f5bfdec33098785c64cf271dd51131/19074993146770?cb=ca20d73bf0915d8a14614fc3956ee64f) #### Prerequisites * Your site must be tagged with the Piano Analytics SDK * You must have access to Axeptio and Piano Analytics The Axeptio connector calls on events and properties that are not included in the default Piano Analytics data model. It is then necessary to configure these elements so that they are taken into account. ##### Privacy If you benefit from the ePrivacy exemption, it is necessary to authorize the collection of these elements prior to the collection of consent: you must include them in the list of authorized elements for your default consent mode. More information here : ## Installation guide ### Setting up the integration on Axeptio Once in your project, click on the parameters, then Analytics Connectors: ![mceclip0.png](https://analytics-docs.piano.io/__attachments/a_4c79fa7a8aa37e76352e40f1737239c543df345b68ae8c2a14bd06e6c0a2ae07/18973774197138?cb=239fe4e66ba332d8805fe1ccefa6bd67) In the pop-up window that opens, you can choose to activate the two options managed by this connector: 1. **Check to activate the service**. The consent.display and consent.answer events will be sent (see "Customizing the Piano Analytics data model" below). 2. **Check the privacy mode to manage the Consent of your visitors**. The consent mode will be updated if the visitor validates the Piano Analytics vendor in the Axeptio widget. ![mceclip1.png](https://analytics-docs.piano.io/__attachments/a_da787e07b3e0a0bd14c25eb59a144df764b537af3c8edab0727e3d086acbbe34/18973774223506?cb=ecf3bfda272ac4c5e0bd897cdfcc6c7b) Publish your widget with Piano Analytics enabled. Once these steps have been completed, Piano Analytics will start collecting data from your visitors' interactions with the Axeptio consent form. ### Customizing the Piano Analytics data model The PA Connect Axeptio requires the declaration of two events in the Piano Analytics data model: * **consent.display** (On site) - Event corresponding to the display of the consent management platform (CMP) * **consent.answer** (On site) - Event corresponding to an explicit response from the user (click on a CMP button, CMP exit click, save preferences, etc.) And two properties attached to the **consent.answer** event: * **privacy_consent_value** (string) - Property indicating the value of the consent expressed: 'full', 'partial' or 'refusal'. * **privacy_consent_type** (boolean) - Property indicating the type (binary) of consent expressed:*true* in the case of total or partial consent, or *false* in the case of refusal Events can be declared from the interface [Data Management \> Data Model \> Events](https://management.atinternet-solutions.com/#/data-model/events/list). More information [here](https://analytics-docs.piano.io/en/analytics/v1/events.md). Properties can be declared from the interface [Data Management \> Data Model \> Properties](https://management.atinternet-solutions.com/#/data-model/properties/list). More information [here](https://analytics-docs.piano.io/en/analytics/v1/properties.md). ### Configuring some performance indicators To analyze the events collected by the connector, it can be useful to set up customized segments, metrics and reports. Here are a few examples: * Number of times the CMP is displayed * : To get this indicator, start by creating a segment to include only the **consent.display** events: ![12336184391826](https://analytics-docs.piano.io/__attachments/a_0e196c94be1104a2c1f414f7e64444ce80e22158ef1ef911a9a50f79c2f6500b/12336184391826?cb=175b0fc7326032073b59d05a08d9e8ff) Next, create a custom metric to display the total number of events, to which we apply the previously created segment in integer format: ![12336246482450](https://analytics-docs.piano.io/__attachments/a_3eeb192408b8f3d84a8828fbcc1b94d746bb8b06a03ba27e382d4a60ab9f138e/12336246482450?cb=9982a68372ac04860bb615150a544f27) * Response rate: The response rate is the ratio between the number of times the consent platform is displayed and the number of responses obtained. To get this indicator, start by creating a segment to include only **consent.answer** events, corresponding to the number of responses obtained: ![12336218504338](https://analytics-docs.piano.io/__attachments/a_2845fb753a17772945d9e02c1c401e029976ae5ab93ee06ca32f50bc28b89cb2/12336218504338?cb=f8ddf447cb4034d06f02058b2ada6e6c) Next, create a custom metric to calculate the ratio between the number of responses and the number of displays, using the segments created previously: ![12336279994130](https://analytics-docs.piano.io/__attachments/a_28d7fba2e83ffad1456956b0f4c6a68d9f153fb4dc5d445fc4a4f7762a2e5b5e/12336279994130?cb=6814ee090ae2c8dc4b0e8df589288a95) * Consent rate The consent rate is the ratio between the number of consents obtained and the number of modal displays. To get this indicator, start by creating a segment to include only**consent.answer** events with the **privacy_consent_type=true** property, corresponding to obtained consent: ![12336294358034](https://analytics-docs.piano.io/__attachments/a_1621edae253ba03133f102f0d53f7454dd4cf47e411a4fc23b3a25deb8a7120e/12336294358034?cb=1939d2044fa05e048207beab39cac18f) Next, create a custom metric to calculate the ratio between the number of consents and the number of displays: ![12336298072082](https://analytics-docs.piano.io/__attachments/a_b8c307606869f28c2d26bd0d9df3e3f9a59b6f136cf15320a181db5d8ce11f8a/12336298072082?cb=59ecc99072be492e62688dcb32c13847) By applying this methodology, it is possible to obtain numerous indicators enabling in-depth analyses of user consent: * Number of responses * Number of consents * Number of non-consents * Rate of consent among respondents * Non-response rate * Rate of non-consent * Number of visits with consent * Number of consenting visitors * Rate of visits with consent * Rate of consenting visitors * Etc Here is an overview of the results: ![12337079306898](https://analytics-docs.piano.io/__attachments/a_6f1c4b8971ec235d533c530d34cc58e158d278bef74541e17beb1438877693f7/12337079306898?cb=7183de192ccc8bbfd8519b29a5439bdf) --- version: "Working version" language: "en" --- # AXON Analyst - Anomaly detection & prediction ## Introduction The Anomaly Detection and Prediction features are *Piano Analytics* ' two time series functionalities powered by data science. The Anomaly detection \& Prediction functionalities are located under the graph type selection button on board tiles. These features are available in all time series graphs within *Workspaces*. ![image-20250124-101110.png](https://analytics-docs.piano.io/__attachments/a_dee843353e04f06424e59379cd26c2c4354e5d6d9461216fc61cde13c02a2d84/image-20250124-101110.png?cb=bdfeee92dc4e3a56f96e68458f90cf46) ### Anomaly detection Anomalies are detected when our statistical model identifies suspicious variations for a given metric within the context of the analysis. **Example**: A large decrease in visits on a Saturday may seem suspicious within the context of a week, however prove to be a perfectly ordinary variation as the scale of a year (decreases in traffic can be observed each weekend). Anomalies are illustrated on the graph with round symbols overlaid on the time series. Positive anomalies will be shown in green: ![Pos_Anom.png](https://analytics-docs.piano.io/__attachments/a_be577b6609a5f48ba1a00a4e19d8b2c27b90702633704aa5bb6bb771be3e3e90/4465668264082?cb=dc0e239451a793540b18e8f06133eec1) Negative anomalies will show up in red: ![Neg_Anom.png](https://analytics-docs.piano.io/__attachments/a_0b3bc4219ac49225171bea86845d203869087333729268473e9113cd93214333/4465647673874?cb=f3a93096c1796c91c9e8371f04c39933) For anomaly detection to be available, the first element analyzed in your data must have enough historical data. For example, if you're analyzing anomalies by traffic source, Direct Access typically has enough history for the model to work. On the other hand, if you're analyzing a recently created campaign with no accumulated history, anomaly detection won't be available --- an error message will explain why. ### Prediction The prediction functionality will provide you with the expected future values of a given metric based on your historical data: * In **hourly**granularity, we forecast the following 24 hours after the last hour of the analysis. When analyzing the current day in real time, the forecast runs from the current hour through to the end of the day. * In **daily**granularity, we forecast the following 30 days after the last day of the analysis. * In **weekly**granularity, we forecast the following 12 weeks after the last week of the analysis. * In **monthly**granularity, we forecast the following 12 months after the last month of the analysis. ## Availability ### Analyses The Anomaly detection \& Prediction functionalities can be selected as graph types on all *Workspaces*tiles. ### Graph granularities Anomaly Detection \& Prediction functionalities are available on all graph granularities: hour, day, week, month. When analyzing the current day, the actual line will be overlaid with the day's forecast, giving you hourly targets for the day. ### Data requirements A minimum of 2 weeks of historical data (with less than 30% of the historical data being zeros) is necessary to identify anomalies and to provide forecasts on hourly and daily granularities. A minimum of 2 years worth of historical data is necessary (with less than 30% of the historical data being zeros) for weekly and monthly anomaly detections \& predictions. If your site is new, you will have to wait until enough historical data is collected for our model to satisfy goodness-of-fit assumptions. Consequently, an explicit error message is shown until you have enough data. For optimal accuracy in our model, we recommend at least 8 weeks and 3 years of data, respectively. ### Metrics The Anomaly detection \& Prediction features are available for all metrics (absolute values and ratios). ## Basic concepts When in the "AXON Analyst" mode, you are able to customize which information is displayed on the graphs with the "options" drop down list. ![image-20250124-101454.png](https://analytics-docs.piano.io/__attachments/a_74cdf15b9f4c33239ee8c95cb5987cd7cef76eebebbee20c12ab0b319dcce4a6/image-20250124-101454.png?cb=b0b344fa448edd4c316a48d5a6482021) ### Anomaly When the anomaly option is selected, a "tolerance" area is shown on the graph. We expect the line to remain within the boundaries of this area. Any data point of the line outside this zone will be flagged as an anomaly. ![Screenshot_3_-_Anomalies.png](https://analytics-docs.piano.io/__attachments/a_29f63a26465ecbbcc8fa5c1c002354aaf98f343768a3c3920101c0a128e06a31/4465647745042?cb=8f0a953ad566ada065c076c196bc6937) ### Trend The trend illustrates macro fluctuations in your data over time. The trend is illustrated using a dashed line. ![Screenshot_4_-_Trend.png](https://analytics-docs.piano.io/__attachments/a_df7e860ce6ae95b3b474602cb2b373b73b02a49b38cfa5d419650d156fc2a3f1/4465659978386?cb=53a3e0ebee5e39fe7de458c99c8da058) ### Baseline The Baseline illustrates how the metric would have evolved without the intervention of external factors. The baseline is illustrated using a dotted line. ![Screenshot_5_-_Baseline.png](https://analytics-docs.piano.io/__attachments/a_b9c0d6db431952cbab32fae234efeebaab97ba64d2cbddf0439665972c9f245d/4465660005778?cb=e8fb7ad696e156be0943d94155224900) ### Forecast The forecast is a prediction based on your historical data. The forecasted values are shown on the graph using a green dotted line. The forecast has its own level of accuracy, which we illustrate using the light green area around the predicted line. ![Screenshot_6_-_Forecast.png](https://analytics-docs.piano.io/__attachments/a_b2b83cd841094536b79130d7929b7a9bacc7b9233e89888b125b88c3b93d7e4c/4465668529042?cb=c5d549ea666b60d4a49d848522f1cb31) ### Algorithm sensitivity The detection sensitivity will affect the algorithm's tolerance area. Three levels of sensitivity are available: low, medium, high. With a low level of sensitivity, the algorithm will be more tolerant, resulting in a larger tolerance area, and fewer alerts. On the contrary, a high level of sensitivity will result in a small tolerance area around the line, and thus more alerts will be identified. The detection sensitivity can be changed on the graph options. #### Low ![Low.png](https://analytics-docs.piano.io/__attachments/a_c1ee61efaf48b7dafabdc3c3c37a51aa4cfa0c978ba9e711ac8ed3f8d73976b3/5829088465554?cb=14cce01f702b10e75136f30b098b040a) #### Medium ![Med.png](https://analytics-docs.piano.io/__attachments/a_99e5aa65f2a29750c12b42e4da35fd2bc26493f9cb8436a92cc55b3a3a410dd2/5829073166354?cb=a4d7f14fb61b688604de2f3b9183f44e) #### High ![High.png](https://analytics-docs.piano.io/__attachments/a_a59fe9d25bdb2e9ae5ff1252ce6f719b09d7947a3811d5886f287c28bf034b97/5829109746834?cb=e5c8c8a39ecf04d95a7e08972d12e734) ## Technical Information and FAQ ### Technical Information The Anomaly Detection \& Prediction features are in-house, custom-built data science models founded on a hybridization of time series decomposition models and clustering methods. The basic models have been tweaked, improved using millions of data points, and adapted to web analytics data. ### FAQ **Does the model compensate for known events such as Christmas or Black Friday?** The Anomaly Detection \& Prediction models do not adapt for known recurrent events such as Christmas or Black Friday. Therefore, fluctuations in your data taking place on those dates will be treated similarly to fluctuations on any other day. **The trend doesn't seem to fit my data properly, is this normal?** The trend reflects macro fluctuations in your data. It is possible your analysis timeframe is too small to show long term fluctuations in your dataset. Due to this phenomenon, the trend can appear to be distant from the rest of your data. By increasing your analysis timeframe you will see the trend illustrates macro fluctuations in your data. --- version: "Working version" language: "en" --- # Batch ## About Batch **Batch** is a marketing platform for managing push notification and inApp message campaigns. Thousands of applications use Batch to manage the sending of push notifications, to automatically segment audiences (new users, engaged users, etc.) and to do so predictively. Learn more on [https://batch.com/.](https://batch.com/) ### *PA Connect* Batch Activate your data with the **PA Connect Batch**. This integration enables you to better communicate with your customers, by automating the sending of notifications based on reliable, comprehensive data. The partnership between Piano Analytics and Batch helps you get the most out of both tools, avoiding any siloing of your data. Track the opening of push / in-app Batch notifications from Piano Analytics. Engage personalized audiences with segmented Piano Analytics data. Monitor the performance of your push notification campaigns in easy-to-use dashboards. ## Connector principles (PA SDK version) The first configuration concerns the implementation of the Dispatcher SDK Batch, which enables events to be sent to Piano Analytics. It will then be necessary to set up push notifications/inApp messages via the Batch interfaces. These push notifications can be tagged with campaigns, so that they can be tracked directly in Piano Analytics. You can then play around with the Piano Analytics interfaces to build your datasets, then decide to import your audience segments directly into Batch from their dedicated interface. Push notification = campaign as source In App = event onsite Ad ![image-20241106-132616.png](https://analytics-docs.piano.io/__attachments/a_e5f15e8c794b82891d669cc7b59a08d245ac4887e7dede288b4e2ee9d24d3b60/image-20241106-132616.png?cb=d5a0c052ef03ccb33fe6a4c74ed79a8b) **Prerequisites :** * Have a Piano Analytics account * Have a Batch account * Implement Batch Dispatcher to benefit from the integration. [Android](https://doc.batch.com/android/advanced/event-dispatchers) / [iOS](https://doc.batch.com/ios/advanced/event-dispatchers). ## Tracking Batch data Piano Analytics only allows you to associate a single campaign with each visit on your application (as a traffic source). However, Batch allows you to trigger several campaigns per visit. To solve this problem, Batch data is sent to two Piano Analytics modules: the On-Site Advertising module and the Marketing Sources module. ### On Site Ad Module: The Batch Piano-dispatcher can send two types of events to Piano Analytics: * **Onsitead native events** (standard Batch Piano-dispatcher configuration): - publisher.impression - publisher.click * **Custom events** (you need to add the associated [Batch Piano-dispatcher configuration](https://doc.batch.com/android/event-dispatchers/#piano-analytics), but also to [declare the custom events](https://analytics-docs.piano.io/en/analytics/v1/events.md) on your PA Data Model): - batch_notification_open : triggered when a push notification is displayed - batch_in_app_show : triggered when a push notification is clicked - batch_in_app_close : triggered when an in-app message is explicitly closed by the user (using the close button or a CTA) - batch_in_app_auto_close : triggered when an in-app message is closed by the auto-close timer. - batch_in_app_click : triggered when an in-app Click-To-Action is clicked or when the in-app is touched (unless the CTA is a close, in which case a "close" event is triggered). The data retrieved (Piano Analytics properties) in each of the above events are as follows: * onsitead_type: type of Onsite campaign measured * onsitead_advertiser: advertiser associated with Onsite ad campaigns * onsitead_campaign: details of Onsite advertising campaigns * onsitead_format: format associated with Onsite advertising campaigns ### Marketing Sources Module : The Batch Dispatcher allows you to take into account the "at_" and "utm" marketing campaign tagging that you set up via your push notifications and In-App messages (see following section of this documentation). This enables you to define a source for each visit to your application. Only the first campaign detected during a visit is available in Piano Analytics (retrieved via the visit's first event). However, it is possible to force the marketing source of a visit even if we have already retrieved another one from past events, by setting the ["src_force"](https://developers.atinternet-solutions.com/piano-analytics/data-collection/how-to-send-events/marketing-campaigns#force-visit-marketing-source) Boolean parameter to "true". Parameters available and mandatory when setting up a marketing campaign: * at_medium : global family for campaign * at_campaign : name of the campaign that generated a visit on your site Or: * utm_medium * utm_campaign ## Setting up your communication channels on Batch ### Push campaigns tracking The dispatcher collects the "at_" or "utm_" parameters from the deeplink URL and your campaign's custom payload. You can use either one or the other. If both are filled, the "at_" / "utm_" parameters from the custom payload will take precedence over the deeplink parameters. ![image-20241106-132637.png](https://analytics-docs.piano.io/__attachments/a_ece68ca560a06a939b712d8da2ca653eed3bed4dee13f6668dda897fa88fc1c8/image-20241106-132637.png?cb=2997ce8ee0a36356a359f25849268fba) ### In-App messages campaigns tracking The dispatcher collects the "at_"/"utm" parameters from the deeplink URL and the Tracking ID field of your campaign. ![https://downloads.intercomcdn.com/i/o/718177387/89bd3598814f8bdaae2ba0d1/609ccb26-2810-4e18-a894-d82767d23ac2](https://downloads.intercomcdn.com/i/o/718177387/89bd3598814f8bdaae2ba0d1/609ccb26-2810-4e18-a894-d82767d23ac2) ## Displaying results in Piano Analytics Now that mobile push notification and in-App tracking is enabled, you can track the results of your campaigns in Piano Analytics as shown in the following capture: ![image-20241106-132701.png](https://analytics-docs.piano.io/__attachments/a_aa6a174ca84aa74a862d483c75cbce713a48ccec9673ee54e87d74030f47d345/image-20241106-132701.png?cb=611075172586306588e5fa2458ae49ac) ## Sending PA segments to Batch You can then create segments in Data Query and send them to Batch. They will be available in Batch as custom audiences. Segments can be sent in CSV format to an FTP server (to be defined with Batch). ![image-20241106-132712.png](https://analytics-docs.piano.io/__attachments/a_811e465efe570f27a32e3e69d9131508f7dc9705164cafe061f8014c4a509aba/image-20241106-132712.png?cb=9a2ded4e94eafceb75925b024f57558c) ## Additional resources * Technological partner page Batch x *Piano Analytics* - * Documentation for the Event Dispatcher Android - * GitHub Batch Piano Analytics Dispatcher Android - * Documentation Event Dispatcher iOS - * GitHub Batch Piano Analytics Dispatcher iOS - --- version: "Working version" language: "en" --- # Botify ## About Botify Botify is a global enterprise software company focused on enabling the most ambitious brands to leverage organic search as a high-impact, performance marketing channel. Powered by AI and a proprietary unified data model, Botify's platform ensures web and mobile sites are optimized for search, the foundation of being found by consumers in today's dynamic digital environment. As the leader in organic search innovation, Botify is trusted by more than 500 of the world's most visible brands, including Expedia, L'Oréal, Crate \& Barrel, and The New York Times, all of whom have succeeded in leveraging organic search for exponential, long-term results and revenue growth. Use cases Piano x Botify * Understand the true ROI of organic search through a holistic view of your website's organic funnel from crawl to conversions. * Measure the impact \& the success of your website optimization in terms of visits and conversions and compare performances with previous periods. * Monitor major shifts in your organic traffic with dedicated alerts and act upon them with dedicated recommendations. * Understand which sections or pages of your website generate the most organic visits and revenue over time. * Uncover meaningful insights by zeroing in on the pages impacted by a loss or gain of traffic or conversions. To learn more: ## Discover the connector Website analytics, one of the core data sets that powers Botify's unified data, helps to ensure your SEO efforts are contributing as expected: increase traffic to your website, drive more on-site conversions, and grow your digital revenue. By integrating Piano metrics with Botify, including visits data, bounce rates, conversion, and revenue data, you can easily diagnose traffic and conversion issues and gain more relevant insights, and understand the business impact of organic search. This integration makes it easy to get visits and conversion data from Piano into Botify. There is no need to configure data feeds, saving you time and resources. The seamless data sync allows you to analyze your search performance and make data-driven decisions quickly and effectively. It's also easier to prove the ROI of organic search on your business. ## Configuring the Integration The configuration for the Piano integration with Botify is done entirely within your Piano account; there is no configuration required within Botify. To configure the integration, complete the following steps, referring to the linked Piano documentation: 1. Log into your Piano account. 2. [Create an API key](https://analytics-docs.piano.io/en/analytics/v1/api-keys.md#Create-an-API-Key). 3. [Obtain your Piano Space ID](https://analytics-docs.piano.io/en/analytics/v1/how-do-i-retrieve-my-site_id.md) for the configuration through one of the following methods: * Through Data Query. * Through the Data Collection Portal interface (has limited access rights). 1. [Declare conversion data to use in the Botify platform](https://analytics-docs.piano.io/en/analytics/v1/declare-a-goal-with-data-management.md). 2. Select the Piano metrics you want to have available in Botify. Please refer to the [API Conversion Metrics](https://support.botify.com/hc/en-us/articles/6171598463004#h_01GG5A1CPMR4H1N2XDPCKCP4YM) section below. 3. Complete and submit this [form](https://docs.google.com/forms/d/e/1FAIpQLSe8bZcDXsQyr_vv-fxs7izeV_sbShU4IXMWmBbsUE8C6Zpgyw/viewform?pli=1&pli=1) with the following information: * Full API key, also known as accesskey_secretkey (Step 1) * List of sites IDs (Step 2) * Start date from when to get the data * Piano property name to use for the URL field (default is event_url) * The link to your Botify project The Support Team will notify you when the configuration is complete. ## API Conversion Metrics With the Piano integration, Botify can retrieve any of your metrics or conversion data from Piano. The following are metrics you may want to consider using in Botify: ### **Visits** * m_visits * m_page_views * m_time_spent * m_bounces #### **Conversion** * m_conv1_uv * m_conv1_iv * m_v_sales_per_uv * m_v_sales_per_iv ## FAQs ### Can I use my Piano account for all my projects? Yes, the Piano integration can be connected to several of your properties. For each property, please submit a separate request with the specific Piano Site ID. Expect more time to run the full synchronizations. ### How frequently does Piano data refresh? Piano data is refreshed daily. ### How much historical Piano data can I retrieve? Once the synchronization is complete, we retrieve the previous month of data. ### Can I modify my conversion metrics visible in Botify? Once your connector is activated, you will be able to modify your conversion data used in the Botify platform. Please reach out to Support to request these changes. ### Can I retrieve the URL winners/losers? After the synchronization begins, it will take 2 months before the winners and losers appear on organic revenue. --- version: "Working version" language: "en" --- # Bucketing properties Bucketing lets you group the values of a property into your **own custom categories**, directly in Data Query. Instead of analyzing dozens or hundreds of raw values, you define a handful of meaningful groups (like "Young / Adult / Senior" or "Active / Inactive"), and Data Query does the sorting for you. A bucket is a new, derived property built from a single existing property. **You decide the rules** : *if a value meets a condition, then it belongs in this group.* The result is a cleaner, more readable report that reflects the categories your team actually cares about. Because a bucket is applied when your report runs, **it works on the fly and is fully retroactive**. It applies across any period you analyze, including data collected long before you created the bucket, so you can reorganize your historical values instantly. Unlike a data management rule, there's nothing to configure ahead of time and no need to wait for new data to come in. ## When to use bucketing Reach for bucketing whenever a property has more detail than you need for a given analysis. A few common cases: * **Turning a numeric property into bands** (age into age groups, order value into price tiers). * **Grouping many text values into fewer categories** (dozens of page paths into a few site sections). * **Flagging records against a threshold** (last visit before a cut-off date into "Active" vs. "Inactive"). ## How bucketing works A bucketing property is built from a few simple pieces: * **A property.** You bucket the values of one existing property at a time. * **An output type.** You choose what kind of value your new property produces: String, Number, or Boolean. * **One or more buckets.** Each bucket has one or more conditions and an output value. When a record matches a bucket's conditions, it receives that bucket's output value. * **An optional default bucket.** This is the "everything else" case. It has no conditions and applies to any record that did not match another bucket. ## Creating a bucket In your report table, click the property you want to group to reveal its actions, then select **Create a bucketing** . (If the property is already a bucket, this option reads **Edit bucketing** and reopens the existing setup.) ![Animation16-20260803-142409.gif](https://analytics-docs.piano.io/__attachments/a_4b9a835f0987e3d0c7add6ffd97089bc89d8965361bdaaeef16f320dd4306291/Animation16-20260803-142409.gif?cb=6023008849346fec24d210184a4ae031) ### General settings * **Property**: The property you're grouping, shown here for reference. Each bucket is based on a single source property. * **Output type**: The type of value your bucket produces, either String, Number, or Boolean (true/false). Set this before defining conditions, since every output value must match it. Mismatches are highlighted so you can fix them before applying. ![image-20260803-142531.png](https://analytics-docs.piano.io/__attachments/a_44c0ce3813a3737da6c32f3bb20ccdb9ad19d4d8207f44fc36aeb45428df0795/image-20260803-142531.png?cb=071b422c1f205b8730ec435095f23606) ### Conditions Each condition has two parts: an **if** that decides which records match, and a **then** that sets the value those records receive. * **if** : Choose an operator and select one or more values to match on the source property (up to 2,000 values per condition). The operators available depend on the property's type (listed under Supported operators below). To require more than one rule in the same condition, click **Add rule**. Rules are combined with AND, so a record must satisfy all of them to match. * **then**: Set the value matching records receive, in one of two ways: * **set with value** : Assigns a fixed constant to the bucket, such as `Young` or `High value`. This is the most common choice. * **set with property value**: Uses the value of another property instead of a constant. Only properties whose type matches your output type are available. Click **Add condition** to create another group, or **Add default** to add a catch-all that applies when no other condition matches. Use the up/down controls on a condition to change the order in which conditions are evaluated. ![image-20260803-142647.png](https://analytics-docs.piano.io/__attachments/a_11ae1a7cc331f330a071c5a1636471aa265f9876a7e5cfb5e5dd9249e3e19fa9/image-20260803-142647.png?cb=fa9b28cf992495a6ad259952a393d864) * A bucket needs at least two conditions, or one condition + a default, and can include up to 15 conditions + one optional default. * Each condition other than the default must contain at least one rule. * The default is always last and has no *if* rules; it simply catches everything not matched above. Click **Apply**. The button activates once your setup is valid, and your new bucket replaces the original property column. ### Supported operators The operators available depend on the type of the source property you're grouping: | **Source property type** | **Available operators** | |------------------------------|-------------------------------------------------| | Numeric (integer or decimal) | `=`, `!=`, `<`, `>`, `<=`, `>=`, is (not) empty | | String | `=`, `!=`, is (not) empty | | Boolean (true/false) | `=`, `!=`, is (not) empty | | Date | `=`, `!=`, `<`, `>`, `<=`, `>=`, is (not) empty | | String array | `=`, `!=`, is (not) empty | * `=` and `!=` accept multiple values, so they work like "is any of" and "is none of." * **is empty** matches records where the property has no value. ## Using a bucketing property Once applied, a bucket appears as a column in your report and behaves like any other property: you can filter on it just as you would any other property. However, functions such as counts, sums, or averages can't be applied to a bucket. If several conditions produce the same output value, those results are grouped into a single row in your report. To adjust a bucket later, click its column to reveal its actions and select **Edit Bucketing**. From there you can change its conditions, output values, or output type. A bucket is **saved**as part of the report it belongs to. Once you save the report, your bucket is reused every time you open it, and any report that contains a bucket can be added to a board just like any other report. ![image-20260803-142816.png](https://analytics-docs.piano.io/__attachments/a_026c16ec804298d59f8cc9ce4a383c90e8bb8df9cd6228921e1fa930995d23de/image-20260803-142816.png?cb=3f988e08dd5704c937ef5a8f09b38326) ## Examples ### Age banding (Numeric to String) Imagine you have a numeric `user age` property, with a different value for almost every visitor. On its own, that level of detail is hard to read in a report: a breakdown by age would produce dozens of rows. Bucketing lets you collapse those raw ages into three familiar life stages, so you can compare behavior across meaningful groups instead of individual ages. You'd set the source property to `user age` and the output type to String, then define one condition per band: * If age `<` 25, then `Young` * If age `>=` 25 and age `<` 65, then `Adult` * If age `>=` 65, then `Senior` Once applied, the age column is replaced by a `Young / Adult / Senior` column. Every visitor is sorted into exactly one band, and you can filter or break down your report by these groups just as you would any other property. ### Active vs. inactive users (Date to String) Here the goal is a simple engagement flag rather than a full set of bands. Starting from a `last login date` property, you want to separate users who haven't logged in since the start of the year from everyone else. A single condition handles the "inactive" case, and a default catches the rest, so you don't have to describe every possible recent date. Set the source property to `last login date` and the output type to String, then: * If last login date `<=` 2026-01-01, then `Inactive` * Default, then `Active` This produces a clean two-value column you can use to segment or compare active and inactive audiences. If some users have never logged in at all, their `last login date` is empty and won't match the "inactive" condition. To capture them explicitly, add a condition using the **is empty** operator on `last login date` and assign it to whichever group fits your analysis, for example `Inactive`. --- version: "Working version" language: "en" --- # Can a page be tagged via an HTML iframe? Yes. An iframe can contain Piano Analytics tags, as well as any JavaScript you need to measure the iframe's own content (for example, clicks and other interactions). ## Where to implement tagging Tagging should be implemented on the **child page** (the page loaded *inside* the iframe), not on the parent page. All code included in the iframe content is executed in the iframe's context and can send events normally. When an iframe is loaded on a partner page, all tagging contained within the iframe will still execute, because it runs as part of the iframe's document. ## Recommended approach: use the latest Piano Analytics library (SDK) We recommend using the latest version of the Piano Analytics JavaScript library to tag an iframe. 1. Load the library on the iframe page: 2. Configure the SDK (example): pa.setConfigurations({ site: 123456, collectDomain: "https://your-collect-domain.com" }); 3. Send events as usual (example): pa.sendEvent('page.display', { page: 'Page_Name' }); All methods available in the Piano Analytics SDK can be used in an iframe. The iframe can be treated like a normal page loaded within a parent document. ## Namespaces and avoiding conflicts (important) Our SDKs use global variables, which can create conflicts if analytics code is present both on: - the parent page where the iframe is embedded, and - the iframe content itself To avoid conflicts, use **unique namespaces** so that global objects and configuration do not collide between the parent page and the iframe. ## Cross-domain considerations (visitor identification) If the parent page and the iframe are on **different domains** , visitor identification may not automatically align between the two contexts. In that case, you may need to **synchronize the client ID** between the parent page and the iframe to preserve consistent visitor tracking across both environments. --- version: "Working version" language: "en" --- # Can a user belong to several teams? Absolutely, a user can belong to several teams and have different roles depending on the teams. For instance, a user could be an Advanced Analyst in one team, and an Analyst in another. --- version: "Working version" language: "en" --- # Can an HTTPS site be the referrer for an HTTP site? When site A uses the HTTPS protocol and site B uses HTTP, the referrer is not passed along when going from site A to site B. As a result, the source of the visit to site B will be **Direct access**. This behavior is enforced by browsers for security/privacy reasons: when navigating from a secure page (HTTPS) to a non-secure page (HTTP), referrer information is typically suppressed to avoid leaking potentially sensitive URL details to an insecure destination. ## How to preserve referrer and source attribution If you need to identify your site's referrers despite the difference in protocol, use one of the following approaches: * **Move the destination site to HTTPS (recommended).** Referrer information is retained when navigating from **HTTPS → HTTPS**, so standard traffic source attribution will work as expected. * **Use marketing campaign tracking.** Add campaign parameters to links so visits can be attributed even when the browser does not send a referrer header (for example, when going from HTTPS to HTTP). --- version: "Working version" language: "en" --- # Can I assign a page label based on the URL? You can use Data Manager to gather information from the URL and parse it into your page label. Let's take a page with the URL http://www.site.com/MyPageName/ , where the page label should be "MyPageName". Warning: this is a general example and may not be applicable in all situations. We recommend you go into Data Management \> Properties, then in the property "Page". You will be able to set the processing rule as in the example below: ![image-20250218-112234.png](https://analytics-docs.piano.io/__attachments/a_6f90b2540ea863b6ed8705a0711ad8887311a03dedb585cbf532b8bb80281d6a/image-20250218-112234.png?cb=9b3a238e22deb152a92a439b58f6b285) This processing rule allows you to set the 4th element of the URL to the property thanks to the "/" separator. The example above is taken into account only if the event is equal to "page.display". The result will be "MyPageName". --- version: "Working version" language: "en" --- # Can I give administration rights to a user? It is possible to give administration rights to any user. ## Grant full administrative rights (entire organization) 1. In Piano Analytics, go to **Access rights**. 2. In the **Admin management** section, assign the user **administration** rights. By default, users added in **Admin management** will be able to administrate **all access rights across the entire organization**. ## Grant administrative rights for a limited scope (specific sites) To grant administrative rights only on a limited group of sites, it is necessary to create a **delegation**. --- version: "Working version" language: "en" --- # Can I know what technical architecture is used by Piano? You can consult our Public Information Security Policy here enclosed. [Piano - Information Security Policy v1.3.pdf](https://analytics-docs.piano.io/__attachments/a_430abc31a55912be4e7280e96a3969fd582bfa89c7c8aa2edb5456e0921add47/Piano%2520-%2520Information%2520Security%2520Policy%2520v1.3.pdf.md?cb=1d9944142f7283ecddeb7f0180fe9a48) --- version: "Working version" language: "en" --- # Can I load your JavaScript library asynchronously? The Piano Analytics SDK recommended loading method is asynchronous: [Javascript \| Piano Analytics Developers Documentation](https://developers.atinternet-solutions.com/piano-analytics/data-collection/sdks/javascript#standard-implementation--6160) We also provide specific methods detailed in our [developer documentation](https://developers.atinternet-solutions.com/piano-analytics/data-collection/sdks/javascript#asynchronous-tagging) that allows queuing commands, which will be executed as soon as the SDK is loaded. You can also, if needed, change the variable name in charge of queuing commands to avoid conflict with third-party tools. --- version: "Working version" language: "en" --- # Can I obtain the number of lines of my API query? The [getRowCount](https://developers.atinternet-solutions.com/data-api-en/reporting-api-v3/methods-en/api-methods/) function is used to obtain the number of lines in an API V3 call: https://api.atinternet.io/v3/data/getData?param={"columns":["page","m_visits"],"sort":["-m_visits"],"space":{"s":[XXXXX]},"period":{"p1":[{"type":"D","start":"2022-12-25","end":"2022-12-25"}]},"max-results":50,"page-num":1,"options":{"ignore_null_properties":true}} Replacing the **getData** function with **getRowCount**will allow you to get the number of rows of your previous query. https://api.atinternet.io/v3/data/getRowCount?param={"columns":["page","m_visits"],"space":{"s":[XXXXX]},"period":{"p1":[{"type":"D","start":"2022-12-25","end":"2022-12-25"}]},"options":{"ignore_null_properties":true}} ![mceclip1.png](https://analytics-docs.piano.io/__attachments/a_5657b43b4ea867a10f10c10de91dc5fac3fa08643da3c6d78fb6a957ee7b4e0c/9281734592786?cb=f1ee9cdaacd44d85061345a1f1fc2a98) The **getRowCount** function can't be used with the following API parameters: * sort * max-result * page-num With these parameters, the API call will return an error. [Next Page](https://analytics-docs.piano.io/llms-full.txt/1)