Overview of Cohort Tables in Analysis Workspace
- Topics:
- Visualizations
CREATED FOR:
- Intermediate
- User
The Rolling Calculation setting within Cohort Tables can be used to analyze cohorts period-over-period, to understand how the same users are retained (or churn) over time.
Transcript
In this video, I’m going to share with you an overview of the settings and features included in the cohort table in Analysis Workspace. So let’s begin. Here, you can see the builder state for the cohort table. There’s a lot here, and I’ll go through each feature individually to outline what tools are available and what they can do. So one of the first things you’ll notice is the section to define segments for both the inclusion and return criteria. You can drag a segment over from the left rail, or you can use the dropdown menu to select a segment. So let’s say I wanted to analyze my US users as part of my inclusion, but I only want to track Chrome users on return. I can add different segments to each of these sections, and I can add up to 10 different segments for both inclusion and 10 for return as well. As far as the actual criteria itself, you need to define a metric in order to actually build a cohort table. Segments are optional, as you can see. You can add up to three different metrics. So for example, I’ll select three different metrics here. We also have an operator, so you can choose to either group them all together so that the visitors must meet all three of these criteria, or you can set this to OR so they meet one of these three criteria. Additionally, we have operators and numeric values. So if you want to filter out or make users meet a certain threshold in terms of number of visits or orders or whatever it might be, you can come in and add and make changes to the operators here. So you can really filter and narrow down through the user groups that you want to include as part of your segment. You can do the same thing over here on return. You can add up to three different metrics. For this demonstration, we’ll keep things simple and compare visits and orders. But those are the inclusion and return criteria settings that enable you to add multiple segments and multiple metrics as needed to suit your criteria definition. Secondly, you can see down here we have two types of cohort tables. Retention is our default cohort table. It’s the tried and true standard one that you see. After it builds, you can see here is the standard cohort table. We also have a cohort type called churn. If you choose churn and select build, churn will do the inverse of our retention and is marked by the red indicating the fallout instead of the retention of users. That is how often are they churning and not returning to your GiveInsider app. Churn is a great, easy way to see the type of behavior of users who are not coming back and possibly the opportunity of those who you know you want to do a little bit more to engage and focus on that user set. Next, we have a setting called rolling calculation. Currently, the cohort is based on users who meet the inclusion criteria and do the return criteria at any point in the subsequent date range that you have. So users in month four don’t have to meet the return criteria in months three, two, and one. But if I change this to rolling calculation, now you can see I have a completely different type of cohort table. Users must meet the criteria in the previous period. So these five here in month two are of this 50 in month one, which are a subset of the inclusion group here of the 85,000. And that’s the same across the board. In order to be included in month two, you have to have met the criteria in month one and so on. And as you can see, the persistence of my users down through months three, four and five who are doing continual month after month behavior has dropped significantly down to one. And so rolling calculation is really good for period over period retention and analysis to know how your users are coming back on a repeat basis. The next setting is here under advanced where we have two features. The first is a latency table. Latency tables provide a good view of pre post analysis. So with a latency table, you can see that the cohort is a little bit different. Our inclusion has now shifted out to the middle and everything to the right of it is a standard cohort showing you repeat and return users after the inclusion event. But I can also now with the latency table, see pre inclusion activity on the same table really quickly and easily. So this is great for analyzing specific events like product launches or campaigns to see what the behavior was like before the event and then the change in behavior after. And so latency tables again are really good for pre post analysis. The last feature we’ll cover is a custom dimension cohort. And in many cases, we’ve had users request and say, hey, I want to do something not time based here on the left. I want to compare something else, a different dimension. And so the custom dimension cohort allows for that. So if I select the browser dimension, I want to compare browsers side by side to know which one is driving the most online orders for my company. So once that builds, I can now see instead of time here on the left, I have a list of my top 14 dimension items that have returned for that specific dimension. In this case, the different browsers. So I can see which browsers are driving a lot of inclusion and return. So Internet Explorer 6.0 is doing great here. But I can see how that stacks up against Safari, Firefox, Chrome and others to quickly evaluate which browsers are performing best at driving online orders and which ones might not be doing so well. So maybe my web experience on some of these other browsers isn’t as good, or maybe most of my visitors are coming from Internet Explorer. So I want to be doing specific things to improve their experience. But the dimension column is a great way to do some really cool non time based dimension analysis. So you could also compare campaigns, products, pages, any other dimension you can think of to do quick side by side, period over period analysis. You can also use the filter option here on the specific dimension if you want to analyze three or four specific dimensions and not the entire list. You can add those here, or if you have one that’s not on your top 14, you can find that as well. So those are some of the great features we have for the cohort table. I hope that these are useful to help you uncover new insights for your business. And thank you for your time.
For more information, please see the documentation.
This video is part of a playlist Visualizations for Customer Journey Analysis!
Analytics
- Analytics tutorials
- Introduction to Analytics
- What is analytics
- What Can Adobe Analytics Do For Me?
- How Adobe Analysis Workspace Can Change Your Business
- It’s More Than Data. It’s Customer Intelligence
- Adobe Sensei and Adobe Analytics
- Customer Use Case - ServiceNow
- Customer Use Case - Accent Group
- Customer Use Case - The Home Depot
- Summit 2019 Super Session - Travel and Hospitality
- Summit 2019 Super Session - Retail
- Summit 2019 Super Session - High Tech
- Strategy & thought leadership
- Transitioning from other platforms
- Analytics Basics
- Customizing the UI
- Getting Help
- Analysis Workspace
- Analysis Workspace Basics
- Analysis Workspace quick intro
- Analysis Workspace overview
- Navigate the new landing page
- Start your analysis with a pre-built report
- Building a Workspace project from scratch
- Create and manage custom templates in Analysis Workspace
- Understanding how data gets into your Analysis Workspace project
- Foundational metrics in Adobe Analytics
- Component management in Analysis Workspace
- Selecting a report suite in Analysis Workspace
- View Analysis Workspace performance metrics
- Create bot reports
- Tips and Tricks
- Navigating Workspace Projects
- Data Dictionary in Analysis Workspace
- Starting your first project
- Training tutorial template
- Use folders in Analysis Workspace
- Copy and insert panels and visualizations
- Create a table of contents
- Right-click for Workspace efficiency
- Keyboard shortcuts
- Annotations
- View density
- Use filters
- Use multi-select drop-down filters
- Real-time reports
- Using Panels
- Using Tables, Visualizations, and Panels in Analysis Workspace
- Quick Insights Panel in Analysis Workspace
- Using the Attribution IQ Panel
- Media Concurrent Viewers Panel in Analysis Workspace
- Media Playback Time Spent Panel
- Using Drop-down Filters
- Using Panels to Organize your Analysis Workspace Projects
- Choose segments for a panel
- Multiple Report Suites in Analysis Workspace
- Next/Previous and Page Summary Workspace Panels & Reports
- Understanding attribution panel and lookback windows
- Building Freeform Tables
- Understand your data–freeform tables
- Use the left rail to build freeform tables
- Easy drag and drop to blank projects
- Work with dimensions in a freeform table
- Work with metrics in a freeform table
- Row and column settings in freeform tables
- Freeform table totals
- Use the freeform table builder
- Right-click for workspace efficiency
- Reorder static rows
- Use Attribution IQ in freeform tables
- Cross-sell analysis
- Freeform table filters
- Time-parting dimensions
- Visualizations
- Visualization types and overview
- Visualization use cases
- Data visualization playbook
- Getting data into visualizations
- Using component drop-downs in Workspace
- Area and area stacked visualizations
- Bar and bar stacked visualizations
- Bullet graph visualization
- Donut visualization
- Histogram visualization
- Unlocking insights with histograms
- Line visualization
- Combo charts
- Adding trend lines to line visualizations
- Map visualization
- Summary number and summary change visualizations
- Key metric summary visualization
- Text visualization
- More than words - Using text visualizations and descriptions
- Scatterplot visualization
- Treemap visualization
- Venn diagram visualization
- Use the cumulative average function to apply metric smoothing
- Flexible layouts
- Changing the scale/axis on visualizations
- Dimension-graph live linking
- Set the granularity for visualizations
- Link inside or outside of your project
- Customize visualization legends
- 100% stacked visualizations
- Table and visualization data source settings
- Build a time-parting heatmap
- Analyzing Customer Journeys
- Applying Segments
- Apply segments to your Analysis Workspace project
- Apply ad hoc segments
- Use different Attribution IQ models with segments
- Choose segments for a panel
- Use segments as Dimensions in Analysis Workspace
- Use segments to limit data in Analysis Workspace
- Quick segments in Analysis Workspace
- Building Customer Journey Segments
- Building Customer Journey Segments - Part 2
- Metrics
- Dimensions
- Calendar and Date Ranges
- Curate and Share Projects
- Attribution IQ
- Using Cross-tab Analysis to Explore Basic Marketing Attribution
- Adding side-by-side comparisons of Attribution IQ Models
- Attribution IQ in Calculated Metrics
- Using Attribution IQ in Freeform Tables
- Using the Attribution IQ Panel
- Using different Attribution IQ models with segments
- Algorithmic Model in Attribution IQ
- Custom Look-back Windows in Attribution IQ
- Cohort Analysis
- Cohort Analysis in Analysis Workspace
- Understand your data–Cohort Tables
- Overview of Cohort Tables
- Cohort Table Settings
- Churn Analysis with Cohort Tables
- Cohort Analysis Using Any Dimension
- Latency Analysis with Cohort Tables
- Calculate Rolling Retention in Cohort Tables
- Use Cohort Analysis to Understand Customer Behavior
- Voice Analytics
- How to Manage and Track Your Voice Assistant App Data
- Understand Differences Across Voice-Enabled Devices
- Finding Opportunities To Increase Engagement for Voice Apps
- Reducing Error Rates and Improving Success Rates in Your Voice App
- Understand User Behavior on Voice Assistants
- Understanding the User’s Voice Journey
- Analysis Workspace Basics
- Administration
- Key Admin Skills
- Creating an empowered community
- Simplify and spend less time training users
- Getting the Right People on Your Analytics Team
- Gaining a seat at the table
- Telling impactful stories with data
- Translating Adobe Analytics technical language in a non-technical way
- Working cross-functionally
- Are you asking the right questions?
- Admin Tips and Best Practices
- Download the implementation playbook
- Audit your data dictionary
- Create standardized naming conventions
- Create standardized code templates
- Create basic videos and training
- Create an internal Adobe Analytics site
- Use a global report suite
- Create a news & announcements project
- Drive success with executive summary dashboards
- Create Operational Dashboards
- Company Settings
- User Management
- Manage Report Suites
- How to Configure General Account Settings
- Customize Calendar Settings
- Configure Paid Search Detection
- Set up marketing channels
- Create marketing channel processing rules
- Manipulating incoming data with Processing Rules
- Configuring Traffic Variables (props)
- Configure traffic classifications
- Configure hierarchy variables
- Configuring Variables in the Admin Console
- Configure conversion classifications
- Configuring List Variables
- Configure Finding Methods
- Set Internal URL Filters
- Configuring Zip and Postal Code Settings
- Enable the Timestamp Optional setting
- Configure bot rules in Analytics
- Data Governance and GDPR
- Traffic Management
- Logs
- Key Admin Skills
- Implementation
- Implementation Basics
- Experience Platform Tags
- Implement Experience Cloud solutions in websites using Tags
- Basic configuration of the Analytics extension
- Configure library management in the Analytics extension
- Configure general settings in the Analytics extension
- Configure global variable settings in the Analytics extension
- Use custom code in the Analytics extension
- Use a data layer to set variables
- Use doPlugins and implementation plug-ins
- Configure easy download link tracking
- Configure easy exit link tracking
- Prepare Tags for your Analytics implementation
- Create data elements for the Analytics implementation
- Create a global page load rule
- Validate the global page load rule
- Create rules for special pages
- Create rules for success events
- Publish Tags libraries to stage and production
- Using JavaScript
- Components
- Segmentation
- Segment builder overview
- Finding and creating segments
- Rolling date ranges in segments
- Segment comparison in Analysis Workspace
- Segment containers
- Segment management and sharing
- Applying segments in Analysis Workspace
- Using segments as dimensions
- Using segments to limit data
- Differences between the segment builder and quick segments
- Sequential segmentation
- Before/After sequences in sequential segmentation
- Segmentation on distinct dimension counts
- Dimension models in segmentation
- Use ‘equals any of’ in segmentation
- Analytics Insider Webinar - Customer Segmentation Strategies
- Now just wait a segment… Using segmentation to discover new insights
- Calculated Metrics
- Calculated metric builder overview
- Calculated metrics - implementation-less metrics
- Calculated metrics - segmented metrics
- Calculated metrics - functions
- Approximate count distinct function in calculated metrics
- Quick calculated metrics in Analysis Workspace
- Manage your calculated metrics
- Attribution IQ in calculated metrics
- Use dimensions in calculated metrics
- Take your data analysis to the next level with calculated metrics
- Classifications
- Virtual Report Suites
- Activity Map
- Segmentation
- Additional Tools
- Exporting
- From the UI
- Data Warehouse
- Data Feeds
- Report Builder
- Upgrade and reschedule workbooks
- Add Segments to Multiple Requests at Once in Report Builder
- Anomaly Detection in Report Builder
- Edit Metrics across Requests
- Using Report Builder to learn the Adobe Analytics API
- Get started with Report Builder
- Schedule a Report Builder request
- Use Report Builder advanced delivery options for Power BI
- Integrations
- Experience Cloud
- Audience Manager
- Target
- Adobe Advertising DSP
- Configuring Advertising Analytics
- Implementing tracking templates into search engines
- Introduction to the Adobe Advertising DSP integration
- Create a Pre-launch campaign analysis
- Report on Advertising DSP marketing channels
- Create Analytics site journey profiles
- Create Analytics segments for activation and reporting
- Create Advertising DSP alerts with Adobe Analytics
- Create Analytics custom metrics with Advertising DSP data
- Create Advertising DSP site entry reports
- Create Advertising DSP dashboards
- Ad Hoc Analytics
- Power BI
- Magento
- Data Science
- Vertical-Specific
- Media Analytics
- Mobile App Analytics
- APIs
- Analysis Use Cases