Skip to main content

Insights Behavioral: Create a Cohort of Customers Based on Starting Month

Zuora

Insights Behavioral: Create a Cohort of Customers Based on Starting Month

One of the most useful analyses you can create about your subscription business is a customer cohort analysis based on starting month. You can perform a cohort analysis in Insights by creating a segment.

This tutorial demonstrates how to use Insights to create a segment that includes all of your accounts that started their first subscription in January 2015.

To create the segment:

  1. Navigate to Insights > Segments.

    The Segments page opens and displays a list of segments.

  2. Click Create Account Segment:

    Insights_Tutorial_02_Create_Account_Segment_Button.png

    The query builder opens.

  3. Click Add criterion, then select Where an attribute value is.

  4. Select Account Start Date:

    Insights_Tutorial_04_Account_Start_Date.png

  5. Select is between, then specify 1 January 2015 and 31 January 2015:

    Insights_Tutorial_04_Account_Start_Date_Between.png

    Insights displays a preview of the accounts that will be included in the segment. For example:

    Insights_Tutorial_04_Segment_Preview.png

    See Create a Segment for more information about using the segment builder.

  6. Click Save as Segment.

    The Save Account Segment page opens.

  7. Name the segment "Cohort: Start Month: 2015-01", then click Save.

Insights displays the profile page of the new segment. On the profile page, you can monitor the rate of cancellations for the cohort over time:

Insights_Tutorial_04_Segment_Trends.png

You can also view summary statistics that you can subsequently compare with other monthly cohorts:

Insights_Tutorial_04_Segment_Dashboard.png

Including statistics like a breakdown of active and churned subscribers in the cohort.

Insights_Tutorial_04_Segment_Dashboard_Metrics.png