Cohort Table Settings

Last update: 2023-05-31
  • Created for:
  • Intermediate

There are several ¨ settings that allow you to customize your view of retention or churn. See them highlighted in this video.


All right, this is Travis Sabin, a product manager on the Adobe Analytics team, and today I’m going to share with you some new settings we’ve added to the Cohort Table in Analysis Workspace. So here I have my pre-built cohort table using the features that we released earlier this year. But now I want to walk you through some additional settings that we’ve introduced here in Analysis Workspace. So if I come over to the gear icon, and I click on this, I now can see that I have three new Display in Cell settings that I can go through and I can use individually or I can use collectively. So they are: Only show percent, Round percent to the nearest whole, and Show Average Percent Row. So the first one is, if I Only show percent, I can remove that raw numeric value from the columns here on the table. This is really helpful so I can compare, across the board, my percents, without having to get the clutter of the other numbers there, as well. And especially if I’m going to export, now I don’t have to worry about stripping out those numeric values. The second one is Rounding percent to the nearest whole. So if I want to just do some quick, handy visual changes, I can now just see the raw whole numbers for the percents here, again making it easier for some quicker comparisons. And then, the last option is to show the Average Percent Row. And what this will do, will introduce a new row here, within the cohort table labeled Average Retention. And what this does is it takes the column and averages each of these percents and returns the average for that specific column. So here, in the plus one month, across each of the different periods, my average retention is 7%. In plus two, it’s six, and so on. So now this is really great, because I can see, first of all, how my retention is trending over time, collectively. In this case, I’m trending down over time. But I can also see, period by period, which periods are performing better or worse than what I would normally expect. I was doing a little bit better here, in the beginning, and maybe I have some adjustments to make here, in these later periods. Really good, visual, quick gut-checks, to see how my retention is doing over time and across various periods. So again, these are the three settings you have. You can use them individually, or collectively, however you choose. And the other great thing with them is not only will they work here in the standard retention, but they work in any of the other settings that you choose within the Cohort Table Builder. So if you run a Churn, I can get the same thing back, with the percents, and so on. And the same thing is true if I use Rolling Calculation, a Latency Table, or Custom Dimension Cohort. Any of the new settings will work with these great new display features. So we hope that this makes your life a little bit easier, and helps you get insights faster within Analysis Workspace. Thanks.

Customizations for the Cohort Table include the ability to

  1. Display percentages only
  2. Round percentages to the nearest whole number
  3. Show/hide an average percent row at the top of the table.

The average row is especially helpful in viewing retention or churn overall, rather than by individual cohort rows.

For more information regarding cohort analysis, visit the documentation.

On this page