Cohorting Users by Creation Date and Order Transactions

See the code

Evaluating customer behavior over time can provide a number of insights into the lifetime purchasing patterns of your customer base.

Cohort analysis is a great way of measuring the behavior of various customer groups over time. With Looker, individual cohorts can be isolated and further segmented to understand your consumer base at every level. Use this Block to identify the characteristics that make certain cohorts more or less valuable than all others. This Block can be applied to any data where users are created and perform a transaction (such as purchase).

See the code

Related Blocks

BigQuery Table Date Range

The Looker Block for BigQuery Table Date Range limits querying to only necessary date ranges, significantly...

State or Status Data

The Looker Block for State Data makes it easy to conduct deep dive analysis on how data changes over time.

Sequencing Transactions

The Looker Block for Sequencing Transactions makes it easy to identify trends among returning customers.