Cohort Analysis | Online Help - Zoho CRM

Cohort Analysis

What is cohort analysis?

Cohorts are groups of users, customers, or data that share similar characteristics at any given point of time. Cohort analysis can be helpful for understanding customer behavior across the sales life cycle or their buying trends and patterns, for analyzing support costs over a specific time period, or other similar metrics. Results drawn from the analysis can be used to adjust existing services or products offered to the identified cohorts and observing the resultant impact on the overall health of the business.

Types of cohort analysis

Time-based cohort analysis

Time-based cohorts are helpful for understanding a pattern or change that happens weekly, monthly, yearly, or quarterly. For example:

  • Studying month-wise deal closure pattern: You can run a cohort analysis to see the deal closure pattern for the past few months. The total number of deals that were closed in the first, second, third, and fourth month from the month they were created in will help you understand how the deal closure pattern varies by mont. The cohort below shows that the deals created in February and March were most likely to be closed the first and second months from deal creation and that there was a considerable drop inclosure rates after the second month from deal creation.
     
  • Day-wise product purchase frequency: In retail businesses, it is useful to see how often a particular product is purchased by customers. You can run a cohort analysis for the product category with a timeline from sale start to sale end date (purchase end date) and see how many times a product was bought from the first to fifth day of a sale period. The data below shows a considerable increase in the purchase on the third day. The data also indicates that customers made more purchases in the electronics category than the other categories.

Segment-based cohort analysis

Customers can be segmented based on various parameters such as the type of product purchased or the subscription type or type of service they chose. From a sales perspective, you can group your leads based on their source of origin, geographic location, or occupation. Some organizations find it useful to group their customers based on business size such as startup, medium-sized, or enterprise-level and industry type to analyze their buying frequency and product preferences. 

Analysis of a segment helps you develop deeper insights about a group's interest, purchasing patterns, and behavior, allowing you to pitch a more personalized marketing campaign. It also lets you draw specific inferences that can be used to optimize existing processes for better results.

Buying pattern after sale: For example, you analyzed the buying pattern six months after an "end of season" sale and noticed that most of the customers who purchased during that time continued to make purchases from you every consecutive month. You now consider them as loyal buyers and focus more on retaining and engaging them by sending personalized campaigns like early bird offers, exclusive discounts, and coupons.

Business size-wise purchase pattern: Let's look at another example where the marketing strategies can be tweaked based on product's purchase frequency. A cohort analysis of different business sizes versus their purchase frequency can help you understand if a certain product interests a certain type of business or not and then market the products based on the audience's interest and requirements. 

This analysis shows that a particular product has not been purchased much by small-sized businesses, B2B, and other organizations, but there has been a consistent increase in the purchase rate in medium and enterprise level organizations. So you can conclude that the latter group is more interested in the product than the former cohort group. Instead of targeting all the organizations, you can target your marketing efforts towards the two groups that have shown most interest. You may also want to review how you have been marketing to the group with the lowest purchase rates to see if you can identify any issues with the product or service offered or find ways to market them better to this group.

Configuring cohorts

In Zoho CRM, you can create three types of cohorts:
  • Basic: A basic cohort lets you analyze by date. For example, you can choose the date a record was created or modified, the date of last activity or any other custom date/time field. 
  • Standard: A standard cohort lets you run an analysis using dimensions or pick-list fields. You can use standard or custom picklist fields such as industry type, product category, lead source, lead status, and record owner.
  • Advanced: This is a combination of basic and standard cohorts. You can analyze using either dates or dimensions as the parameter and add additional metrics such as the total annual revenue, total number of leads, number of purchases, or average unit price. Any number field can be used for additional metrics.
     

To configure cohort analysis

  1. Click Add Component in the Analytics tab and select Cohort.
  2. Select your desired cohort type: basic, standard, or advanced.
  3. Enter the following details in the Cohort Builder page
    • Component Name: Enter the component name, such as "purchase frequency after end-of-season sale" or "sales cohort for lead sources".
    • Cohort Analysis For: Select a module and grouping from the dropdown list. Note: You can group by either date or dimension.
    • Cohort Data: Select the number fields you want to run the cohort for, e.g., record count, total purchases, product count versus the number of records.
    • Criteria Filter: Specify a criteria if you only want specific records to be considered for analysis.
    • Duration from: Select the duration of your analysis, e.g.,sales start to end date, purchase start to end date, created time to modified time. Note: Only date and date/time fields will be listed here.
    • Duration interval: Choose Day, Week, Month, Quarter, or Year.
    • Duration Range: Select the range you want for the results, e.g. 1-4 or 1-6. The maximum duration range is 1-10.
    • Additional Metric: Click Add Metrics to add more values from any number field to the cohort. You can also define criteria to consider specific records only.
  4. Click Done to save the additional metrics.
  5. Click Add & Reorder to change the configuration.
  6. Click Save.

    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now





              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training



                      Zoho DataPrep Resources

                        Zoho DataPrep Demo

                        Get a personalized demo or POC

                        REGISTER NOW


                          Design. Discuss. Deliver.

                          Create visually engaging stories with Zoho Show.

                          Get Started Now











                                              • Related Articles

                                              • Trend Analysis

                                                Assume you haven't been checking the progress of deal closure for a while and suddenly notice a drop in the revenue due to less number of closures. Now, unless you monitor the status manually, there are chances that you will miss important details ...
                                              • Creating Dashboards

                                                Dashboard is a summarized view of the custom report data in Zoho CRM. It provides a platform for a real-time analysis of the sales stages and business operations. You can create a dashboard and share it with all the users or few selected users. You ...
                                              • Quadrant Analysis

                                                What is quadrant analysis? You can measure or compare a limited set of business data using a chart or KPIs, but if you have a large amount of data and want to pinpoint the areas to focus on, a quadrant analysis may be more suitable. Quadrant analysis ...
                                              • How do I create a dashboard and share with other users in the organization?

                                                Dashboard provides a platform for a real-time analysis of the sales stages and business operations. You can create dashboards to get an overview of varied business activities such as email analytics, lead status, marketing metrics, and activity ...
                                              • Email Sentiment Analysis

                                                Sales team receive hundreds of emails every day but the ones that have a negative tone usually require an immediate attention over the others. But to identify the emails that need to be prioritized or require immediate attention, a rep has to leaf ...

                                              Resources

                                              Videos

                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                              eBooks

                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                              Webinars

                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                              CRM Tips

                                              Make the most of Zoho CRM with these useful tips.



                                                Zoho Show Resources