{"id":9373,"date":"2017-07-24T18:45:12","date_gmt":"2017-07-24T16:45:12","guid":{"rendered":"https:\/\/chartmogul.com\/blog\/?p=9373"},"modified":"2023-08-10T17:10:55","modified_gmt":"2023-08-10T15:10:55","slug":"tips-tricks-cohort-analysis","status":"publish","type":"post","link":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/","title":{"rendered":"Tips & Tricks: Creating a cohort analysis to understand user acquisition"},"content":{"rendered":"

A cohort analysis enables you to observe how a specific group of customers evolves over time. In ChartMogul you can easily create and compare cohorts in the different charts to understand your customers behaviour. In this article, we will segment customers by quarter to see trends in acquisition and retention.<\/p>\n

\"cohort<\/p>\n

How to compare customer cohorts by quarter<\/h1>\n
    \n
  1. Create a segment for the first quarter of 2016 by using the following filter:\u00a0Customer since | Between | 2015-01-01 – 2015-03-31\u00a0<\/strong>and save the segment as “Q1 2015″<\/em>.<\/li>\n
  2. Do the same for every other quarter that you would like to add to you cohort analyses.<\/li>\n
  3. Select\u00a0Line<\/strong>\u00a0and\u00a0Stacked<\/strong>\u00a0at the top left of the chart.<\/li>\n<\/ol>\n
    \n

    \"\"<\/a>\u00a0Want to become a cohort analysis pro?<\/strong><\/em><\/p>\n

    Check out The Ultimate Cohort Analysis Cheat Sheet<\/a>, available for free on the ChartMogul\u00a0Resources<\/a> page! It includes:<\/em><\/p>\n

    What is a Cohort Analysis?<\/em><\/p>\n

    Why are they useful?<\/em><\/p>\n

    How to read a Cohort Analysis chart<\/em><\/p>\n

    Making Cohorts actionable with segmentation<\/em><\/p>\n

    \n

    What we learned<\/h1>\n

    In this example comparison, we can see that the user acquisition slowed down after the Q2 2015 quarter but accelerated again in Q2 of 2016.\u00a0Furthermore, we can see that there is a problem with retention that manifested in the Q2 2016 cohort. This is showing up as a steep decline in customer numbers after a few months:<\/p>\n

    \"cohort<\/p>\n

    Next steps\u00a0<\/h1>\n

    Other than looking at the number of customers, we can also check the MRR retention of a cohort to see if the customers that are cancelling are large accounts, mainly small accounts or a mix of both. This might help us narrow down the root causes of the acceleration in cancellations.<\/p>\n

    Further, we can compare the same cohorts by plan to see if customers are being acquired at a faster rate on one of them. Secondly, we can check if they are more likely to churn on a specific plan. This might help the sales and marketing team to double down their efforts on promoting the plan with the best\u00a0performance.<\/p>\n

    \n
    \n

    Share your analysis\u00a0<\/h1>\n

    Do you have a particular analysis in ChartMogul that has helped gain unique insights? Do you think it could help other users? Please send it to us at\u00a0support@chartmogul.com<\/a>.<\/p>\n<\/div>\n<\/article>\n","protected":false},"excerpt":{"rendered":"

    In this week’s edition of Tips & Tricks, we take a look at one of many ways to make cohort analyses actionable, digging deeper into user acquisition.<\/p>\n","protected":false},"author":20,"featured_media":9174,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-9373","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gtm"],"yoast_head":"\nTips & Tricks: Creating a cohort analysis to understand user acquisition<\/title>\n<meta name=\"description\" content=\"In this week's edition of Tips & Tricks, we take a look at one of many ways to make cohort analyses actionable, digging deeper into user acquisition.\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<link rel=\"canonical\" href=\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tips & Tricks: Creating a cohort analysis to understand user acquisition\" \/>\n<meta property=\"og:description\" content=\"In this week's edition of Tips & Tricks, we take a look at one of many ways to make cohort analyses actionable, digging deeper into user acquisition.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/\" \/>\n<meta property=\"og:site_name\" content=\"ChartMogul\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/chartmogul\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-24T16:45:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-10T15:10:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"3000\" \/>\n\t<meta property=\"og:image:height\" content=\"1250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Ingmar Zahorsky\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@chartmogul\" \/>\n<meta name=\"twitter:site\" content=\"@chartmogul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ingmar Zahorsky\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/\"},\"author\":{\"name\":\"Ingmar Zahorsky\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/58f65a634d6409df11b691b1d05810d9\"},\"headline\":\"Tips & Tricks: Creating a cohort analysis to understand user acquisition\",\"datePublished\":\"2017-07-24T16:45:12+00:00\",\"dateModified\":\"2023-08-10T15:10:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/\"},\"wordCount\":373,\"publisher\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg\",\"articleSection\":[\"GTM\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/\",\"url\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/\",\"name\":\"Tips & Tricks: Creating a cohort analysis to understand user acquisition\",\"isPartOf\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg\",\"datePublished\":\"2017-07-24T16:45:12+00:00\",\"dateModified\":\"2023-08-10T15:10:55+00:00\",\"description\":\"In this week's edition of Tips & Tricks, we take a look at one of many ways to make cohort analyses actionable, digging deeper into user acquisition.\",\"breadcrumb\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#primaryimage\",\"url\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg\",\"contentUrl\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg\",\"width\":3000,\"height\":1250,\"caption\":\"Tips & Tricks\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/chartmogul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tips & Tricks: Creating a cohort analysis to understand user acquisition\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#website\",\"url\":\"https:\/\/chartmogul.com\/blog\/\",\"name\":\"ChartMogul\",\"description\":\"Get all your SaaS & Subscription Metrics with a Single Click! MRR, churn, LTV and much more.\",\"publisher\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/chartmogul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#organization\",\"name\":\"ChartMogul\",\"url\":\"https:\/\/chartmogul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2019\/05\/ChartMogul-Logo.png\",\"contentUrl\":\"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2019\/05\/ChartMogul-Logo.png\",\"width\":278,\"height\":52,\"caption\":\"ChartMogul\"},\"image\":{\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/chartmogul\",\"https:\/\/x.com\/chartmogul\",\"https:\/\/www.linkedin.com\/company\/chartmogul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/58f65a634d6409df11b691b1d05810d9\",\"name\":\"Ingmar Zahorsky\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f66837da1fbc9f825950e87b5d2e87938cb2d09a2b29b60f78352e719556c2b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f66837da1fbc9f825950e87b5d2e87938cb2d09a2b29b60f78352e719556c2b6?s=96&d=mm&r=g\",\"caption\":\"Ingmar Zahorsky\"},\"description\":\"VP of Customer Success\",\"url\":\"https:\/\/chartmogul.com\/blog\/author\/ingmar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tips & Tricks: Creating a cohort analysis to understand user acquisition","description":"In this week's edition of Tips & Tricks, we take a look at one of many ways to make cohort analyses actionable, digging deeper into user acquisition.","robots":{"index":"index","follow":"follow"},"canonical":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/","og_locale":"en_US","og_type":"article","og_title":"Tips & Tricks: Creating a cohort analysis to understand user acquisition","og_description":"In this week's edition of Tips & Tricks, we take a look at one of many ways to make cohort analyses actionable, digging deeper into user acquisition.","og_url":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/","og_site_name":"ChartMogul","article_publisher":"https:\/\/www.facebook.com\/chartmogul","article_published_time":"2017-07-24T16:45:12+00:00","article_modified_time":"2023-08-10T15:10:55+00:00","og_image":[{"width":3000,"height":1250,"url":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg","type":"image\/jpeg"}],"author":"Ingmar Zahorsky","twitter_card":"summary_large_image","twitter_creator":"@chartmogul","twitter_site":"@chartmogul","twitter_misc":{"Written by":"Ingmar Zahorsky","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#article","isPartOf":{"@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/"},"author":{"name":"Ingmar Zahorsky","@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/58f65a634d6409df11b691b1d05810d9"},"headline":"Tips & Tricks: Creating a cohort analysis to understand user acquisition","datePublished":"2017-07-24T16:45:12+00:00","dateModified":"2023-08-10T15:10:55+00:00","mainEntityOfPage":{"@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/"},"wordCount":373,"publisher":{"@id":"https:\/\/chartmogul.com\/blog\/#organization"},"image":{"@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#primaryimage"},"thumbnailUrl":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg","articleSection":["GTM"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/","url":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/","name":"Tips & Tricks: Creating a cohort analysis to understand user acquisition","isPartOf":{"@id":"https:\/\/chartmogul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#primaryimage"},"image":{"@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#primaryimage"},"thumbnailUrl":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg","datePublished":"2017-07-24T16:45:12+00:00","dateModified":"2023-08-10T15:10:55+00:00","description":"In this week's edition of Tips & Tricks, we take a look at one of many ways to make cohort analyses actionable, digging deeper into user acquisition.","breadcrumb":{"@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#primaryimage","url":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg","contentUrl":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2017\/06\/tips.jpg","width":3000,"height":1250,"caption":"Tips & Tricks"},{"@type":"BreadcrumbList","@id":"https:\/\/chartmogul.com\/blog\/tips-tricks-cohort-analysis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/chartmogul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Tips & Tricks: Creating a cohort analysis to understand user acquisition"}]},{"@type":"WebSite","@id":"https:\/\/chartmogul.com\/blog\/#website","url":"https:\/\/chartmogul.com\/blog\/","name":"ChartMogul","description":"Get all your SaaS & Subscription Metrics with a Single Click! MRR, churn, LTV and much more.","publisher":{"@id":"https:\/\/chartmogul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/chartmogul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/chartmogul.com\/blog\/#organization","name":"ChartMogul","url":"https:\/\/chartmogul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2019\/05\/ChartMogul-Logo.png","contentUrl":"https:\/\/chartmogul.com\/blog\/wp-content\/uploads\/2019\/05\/ChartMogul-Logo.png","width":278,"height":52,"caption":"ChartMogul"},"image":{"@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/chartmogul","https:\/\/x.com\/chartmogul","https:\/\/www.linkedin.com\/company\/chartmogul\/"]},{"@type":"Person","@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/58f65a634d6409df11b691b1d05810d9","name":"Ingmar Zahorsky","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/chartmogul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f66837da1fbc9f825950e87b5d2e87938cb2d09a2b29b60f78352e719556c2b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f66837da1fbc9f825950e87b5d2e87938cb2d09a2b29b60f78352e719556c2b6?s=96&d=mm&r=g","caption":"Ingmar Zahorsky"},"description":"VP of Customer Success","url":"https:\/\/chartmogul.com\/blog\/author\/ingmar\/"}]}},"_links":{"self":[{"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/posts\/9373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/comments?post=9373"}],"version-history":[{"count":0,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/posts\/9373\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/media\/9174"}],"wp:attachment":[{"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/media?parent=9373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/categories?post=9373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartmogul.com\/blog\/wp-json\/wp\/v2\/tags?post=9373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}