{"id":4332,"date":"2014-02-19T16:08:35","date_gmt":"2014-02-19T16:08:35","guid":{"rendered":"https:\/\/www.gosquared.com\/blog\/?p=4332"},"modified":"2019-11-28T12:19:59","modified_gmt":"2019-11-28T12:19:59","slug":"really-simple-cohort-analysis-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets","title":{"rendered":"Really Simple Cohort Analysis in Google Sheets"},"content":{"rendered":"<p><iframe loading=\"lazy\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/31389656?rel=0\" width=\"595\" height=\"485\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px 1px 0; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe> <\/p>\n<div style=\"margin-bottom:5px\"> <strong> <a href=\"https:\/\/www.slideshare.net\/gosquared\/cohort-analysis-in-google-sheets\" title=\"Simple Cohort Analysis in Google Sheets\" target=\"_blank\" rel=\"noopener noreferrer\">Simple Cohort Analysis in Google Sheets<\/a> <\/strong> from <strong><a href=\"http:\/\/www.slideshare.net\/gosquared\" target=\"_blank\" rel=\"noopener noreferrer\">GoSquared<\/a><\/strong> <\/div>\n<p>A step by step introduction to cohort analysis using the SUMIFS formula in the new Google Sheets. This guide will help you understand how your business is performing using one of the most effective and easy to understand techniques out there.<\/p>\n<p>As always, let us know if you have any comments or questions over on <a href=\"http:\/\/www.slideshare.net\/gosquared\" title=\"GoSquared on Slideshare\" target=\"_blank\" rel=\"noopener noreferrer\">Slideshare<\/a>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p><iframe loading=\"lazy\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/31389656?rel=0\" width=\"595\" height=\"421\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px 1px 0; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe> <\/p>\n<div style=\"margin-bottom:5px\"> <strong> <a href=\"https:\/\/www.slideshare.net\/gosquared\/cohort-analysis-in-google-sheets\" title=\"Simple Cohort Analysis in Google Sheets\" target=\"_blank\" rel=\"noopener noreferrer\">Simple Cohort Analysis in Google Sheets<\/a> <\/strong> from <strong><a href=\"https:\/\/www.slideshare.net\/gosquared\" target=\"_blank\" rel=\"noopener noreferrer\">GoSquared<\/a><\/strong> <\/div>\n<p>A step by step introduction to cohort analysis using the SUMIFS formula in the new Google Sheets. This guide will help you understand how your business is performing using one of the most effective and easy to understand techniques out there.<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1586],"tags":[96,254,399,608,844],"class_list":["post-4332","post","type-post","status-publish","format-standard","hentry","category-gosquared-updates","tag-analytics","tag-data","tag-google","tag-metrics","tag-stats"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.6 (Yoast SEO v19.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Really Simple Cohort Analysis in Google Sheets<\/title>\n<meta name=\"description\" content=\"A step by step introduction to cohort analysis in Google Sheets, helping businesses understand the the performance of their business in a quick glance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Really Simple Cohort Analysis in Google Sheets\" \/>\n<meta property=\"og:description\" content=\"A step by step introduction to cohort analysis in Google Sheets, helping businesses understand the the performance of their business in a quick glance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets\" \/>\n<meta property=\"og:site_name\" content=\"GoSquared Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GoSquared\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-19T16:08:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-28T12:19:59+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@HughHopkins\" \/>\n<meta name=\"twitter:site\" content=\"@GoSquared\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hugh Hopkins\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#organization\",\"name\":\"GoSquared\",\"url\":\"https:\/\/www.gosquared.com\/blog\/\",\"sameAs\":[\"https:\/\/instagram.com\/gosquaredteam\",\"https:\/\/www.linkedin.com\/company\/go-squared-ltd.\",\"https:\/\/www.facebook.com\/GoSquared\",\"https:\/\/twitter.com\/GoSquared\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.gosquared.com\/blog\/wp-content\/uploads\/2015\/07\/gosquared.png\",\"contentUrl\":\"https:\/\/www.gosquared.com\/blog\/wp-content\/uploads\/2015\/07\/gosquared.png\",\"width\":1270,\"height\":250,\"caption\":\"GoSquared\"},\"image\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#website\",\"url\":\"https:\/\/www.gosquared.com\/blog\/\",\"name\":\"GoSquared Blog\",\"description\":\"Turn visitors into customers.\",\"publisher\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gosquared.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#webpage\",\"url\":\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets\",\"name\":\"Really Simple Cohort Analysis in Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#website\"},\"datePublished\":\"2014-02-19T16:08:35+00:00\",\"dateModified\":\"2019-11-28T12:19:59+00:00\",\"description\":\"A step by step introduction to cohort analysis in Google Sheets, helping businesses understand the the performance of their business in a quick glance.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gosquared.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Really Simple Cohort Analysis in Google Sheets\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#webpage\"},\"author\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/64199c56bfdd77ef0cdacb2fc2b57d20\"},\"headline\":\"Really Simple Cohort Analysis in Google Sheets\",\"datePublished\":\"2014-02-19T16:08:35+00:00\",\"dateModified\":\"2019-11-28T12:19:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#webpage\"},\"wordCount\":71,\"publisher\":{\"@id\":\"https:\/\/www.gosquared.com\/blog\/#organization\"},\"keywords\":[\"Analytics\",\"Data\",\"Google\",\"Metrics\",\"Stats\"],\"articleSection\":[\"GoSquared Updates\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/64199c56bfdd77ef0cdacb2fc2b57d20\",\"name\":\"Hugh Hopkins\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9f571190db14d08cb79699d64f58e31e75dafde9cd3fb02a8f373da3743f156c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9f571190db14d08cb79699d64f58e31e75dafde9cd3fb02a8f373da3743f156c?s=96&d=mm&r=g\",\"caption\":\"Hugh Hopkins\"},\"description\":\"Hugh heads up Business Development at GoSquared.\",\"sameAs\":[\"http:\/\/gosquared.com\",\"https:\/\/twitter.com\/HughHopkins\"],\"url\":\"https:\/\/www.gosquared.com\/blog\/author\/hugh\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Really Simple Cohort Analysis in Google Sheets","description":"A step by step introduction to cohort analysis in Google Sheets, helping businesses understand the the performance of their business in a quick glance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets","og_locale":"en_US","og_type":"article","og_title":"Really Simple Cohort Analysis in Google Sheets","og_description":"A step by step introduction to cohort analysis in Google Sheets, helping businesses understand the the performance of their business in a quick glance.","og_url":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets","og_site_name":"GoSquared Blog","article_publisher":"https:\/\/www.facebook.com\/GoSquared","article_published_time":"2014-02-19T16:08:35+00:00","article_modified_time":"2019-11-28T12:19:59+00:00","twitter_card":"summary_large_image","twitter_creator":"@HughHopkins","twitter_site":"@GoSquared","twitter_misc":{"Written by":"Hugh Hopkins"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.gosquared.com\/blog\/#organization","name":"GoSquared","url":"https:\/\/www.gosquared.com\/blog\/","sameAs":["https:\/\/instagram.com\/gosquaredteam","https:\/\/www.linkedin.com\/company\/go-squared-ltd.","https:\/\/www.facebook.com\/GoSquared","https:\/\/twitter.com\/GoSquared"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.gosquared.com\/blog\/wp-content\/uploads\/2015\/07\/gosquared.png","contentUrl":"https:\/\/www.gosquared.com\/blog\/wp-content\/uploads\/2015\/07\/gosquared.png","width":1270,"height":250,"caption":"GoSquared"},"image":{"@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.gosquared.com\/blog\/#website","url":"https:\/\/www.gosquared.com\/blog\/","name":"GoSquared Blog","description":"Turn visitors into customers.","publisher":{"@id":"https:\/\/www.gosquared.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gosquared.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#webpage","url":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets","name":"Really Simple Cohort Analysis in Google Sheets","isPartOf":{"@id":"https:\/\/www.gosquared.com\/blog\/#website"},"datePublished":"2014-02-19T16:08:35+00:00","dateModified":"2019-11-28T12:19:59+00:00","description":"A step by step introduction to cohort analysis in Google Sheets, helping businesses understand the the performance of their business in a quick glance.","breadcrumb":{"@id":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gosquared.com\/blog"},{"@type":"ListItem","position":2,"name":"Really Simple Cohort Analysis in Google Sheets"}]},{"@type":"Article","@id":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#article","isPartOf":{"@id":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#webpage"},"author":{"@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/64199c56bfdd77ef0cdacb2fc2b57d20"},"headline":"Really Simple Cohort Analysis in Google Sheets","datePublished":"2014-02-19T16:08:35+00:00","dateModified":"2019-11-28T12:19:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gosquared.com\/blog\/really-simple-cohort-analysis-in-google-sheets#webpage"},"wordCount":71,"publisher":{"@id":"https:\/\/www.gosquared.com\/blog\/#organization"},"keywords":["Analytics","Data","Google","Metrics","Stats"],"articleSection":["GoSquared Updates"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/64199c56bfdd77ef0cdacb2fc2b57d20","name":"Hugh Hopkins","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gosquared.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9f571190db14d08cb79699d64f58e31e75dafde9cd3fb02a8f373da3743f156c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9f571190db14d08cb79699d64f58e31e75dafde9cd3fb02a8f373da3743f156c?s=96&d=mm&r=g","caption":"Hugh Hopkins"},"description":"Hugh heads up Business Development at GoSquared.","sameAs":["http:\/\/gosquared.com","https:\/\/twitter.com\/HughHopkins"],"url":"https:\/\/www.gosquared.com\/blog\/author\/hugh"}]}},"wps_subtitle":"Because you don\u2019t always have a data scientist on hand","_links":{"self":[{"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/posts\/4332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/comments?post=4332"}],"version-history":[{"count":0,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/posts\/4332\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/media?parent=4332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/categories?post=4332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gosquared.com\/blog\/wp-json\/wp\/v2\/tags?post=4332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}