Cohort Customer Report

What is a Cohort?

Cohort - a group of people banded together or treated as a group.

Introduction

The Cohort Customer report groups customers by time periods and shows how those customers behaved following their initial purchase.  It helps answer these business questions such as:

  • What is the lifetime value of customers who purchased more than 12 months ago?
  • Is that particular Facebook campaign profitable?
  • What is the quality of the traffic generated by a particular affiliate?
  • Can I afford to pay a particular affiliate more if they demand it?
  • What percentage of my auto order (recurring) customers remain after 90 days?

Running the Report

The report is located under:

When you get to this page you'll see the following screen:

The report will default to the last 12 calendar months.  You can run this report for any time period, but customers are grouped into monthly cohorts.

There are a number of filter options that you can use which will change the type of customers included in the report:

FilterDescription
AffiliateRun the report for a specific affiliate.  Only customers where the first order is from that particular affiliate are shown in the report and then subsequent orders by those customers (regardless of whether the affiliate received commission on the subsequent orders).
Affiliate Orders OnlyRuns the report for only customers where the first order was attributed to an affiliate.
Non-Affiliate Orders OnlyRuns the report for customers where no affiliate was involved on the original order.
Auto Orders OnlyRuns the report for customers where the original order was an auto order plus all the rebills that have occurred.
UTM SourceIf you're using UltraCart Analytics and tagging your traffic with UTM parameters, then you can report on orders associated with that source.  For example, you can report on all your Facebook traffic.    Once you select a UTM source, you can optionally select a particular campaign.  A third option will also appear to allow you to decided if you want to report on orders in the future that also interacted with a different marketing campaign.
Initial Order Contains at Least One of Item Id(s)The initial order that the customer placed must contain at least one of the item ids specified.  Put the item item ids one per line.

Finally there is an option to decide whether or not you want to report on revenue order profit.  It's very important to clarify the definition of profit for this report:

profit = SUM((quantity_for_item * cost_of_item) - (discount_off_item) - cogs_of_item) - subtotal_discount - affiliate_commissions

There are other factors that reduce your profit that are not accounted for in this calculation.  It's a limitation of the report to keep that in mind when judging the results of the report.


Reading the Report

When this report downloads to your Excel, you need to click "Enable Editing" because this report uses complex formulas over a raw data set.

There are four tabs across the bottom of the report by default. There is a fifth if you're looking at auto orders.

TabDescription
InstructionsProvides a link to this documentation.
Cumulative AnalysisThis view will show you how each cohort of customers performs cumulatively over time.  Each time period is contains cumulative values.
Monthly AnalysisThis view shows how the customers in each cohort perform over each monthly time period since their first order.
Churn Analysis (auto orders only report)This shows the attrition of customers that signed up for the auto order in the cohort and when they dropped off.
MRR DataThe raw data that all of the formulas in the spreadsheet are calculating off of.  If you disagree with an answer in the report, you can review the underlying raw data.
Auto OrdersThis tab appears for merchants with auto orders.

Cumulative Analysis

Across the top are each month as a Cohort.  The months are shown in YYYY-MM format.  Within each column are the initial purchases of the months above.  The older the cohort the more likely that those customers have purchased again and again thus the number of months will increase.  In the cumulative analysis view the very top number in the column is the total for that cohort.  Down at the bottom of the spreadsheet there are statistics about the over all cohort.

StatisticsDescriptionHow its totaled
Total Number of People in CohortThe number of customers contained within the cohort.Sum of all the customers across all the cohorts
Avg Customer LTVAverage customer life time value.Sum of the revenue / Sum of all the customers across all the cohorts
Total Revenue in CohortTotal revenue in the cohort.Sum of the revenue
Max Period in CohortThe maximum number of periods (months) for the customers contained within the cohortn/a

Monthly Analysis

Across the top you will see that each month is a Cohort.  You'll see the label in YYYY-MM format.  Within each column you will see the initial purchase and then the months below.  The older the cohort the more likely that those customers have purchased again and again thus the number of months will increase.  In the monthly analysis view each cell contains the revenue for that particular cohort within the month.  Down at the bottom of the spreadsheet there are statistics about the over all cohort.

StatisticsDescriptionHow its totaled
Average Rev. Per CustomerAverage revenue per customer within the cohort.Sum of the revenue across the cohorts. / Sum of the customers across all cohorts.
Total Cohort RevenueTotal revenue in the cohort.Sum of the revenue across the cohorts.
Number People in CohortThe number of people in the cohort.Sum of the customers across all cohorts.

Churn Analysis

The churn analysis report shows the percentage of customers that remain active on their auto order as each month goes along.  This reports how each cohort behaves from a retention perspective over time.  

StatisticsDescriptionHow its totaled
Remaining ActivePercentage of customers that remain active within the cohort.n/a
People Still ActiveNumber of people still active within the cohort.Sum of the people still active across the cohorts
Number People in CohortNumber of people that signed up for an auto order in the cohort.Sum of the people across the cohorts
Max Period in CohortThe maximum number of periods (months) for the customers contained within the cohort.n/a