Looker

Marketplace

Develop for Marketplace

Blocks

Dynamic Cohort Analysis

By Data Clymer
The Looker Block for Dynamic Cohort Analysis allows users to isolate a cohort and perform second-level analysis on that group.
The Looker Block for Dynamic Cohort Analysis allows users to isolate a cohort and perform second-level analysis on that group.

Overview

This is not an officially supported Google product.

Anyone doing a deep dive analysis on customer behavior will want to easily look at a cohort and see what kinds of interesting insights can be discovered about that cohort. For instance, one simple but powerful question like "Of the customers that purchased Product A, what other products did they purchase?" can help sales target upsell or cross-sell opportunities.

In the world of SQL, this kind of question requires a sub-query to define the cohort (customers who purchased product A) and a main query to answer a question (what other products did they purchase). In the spirit of creating a friction-free, self-service analytics environment, the question is: how can we give end users the capability of dynamically creating ad-hoc cohorts at run-time and then asking other questions about the behavior of those cohorts? All without having to develop any LookML or write custom queries!

Data Clymer is a certified Looker Partner specializing in full cloud data system implementation and data culture change. For more information, please visit www.dataclymer.com or contact your designated Looker Analyst.

Category

Blocks

Related Content

Amazon Redshift Administration

GoogleFine-tune your Redshift deployment with a comprehensive view of performance and query analysis.Blocks

BigQuery Information Schema Performance Monitoring

GoogleMonitor and Explore your BigQuery Usage and PerformanceBlocks

© 2025 Looker Data Sciences, Inc.
Privacy | Terms | Cookies