How to Create a Cohort Analysis for Multiple Objects without a Unique Key
Introduction
This guide will help you create a Cohort Analysis for multiple objects in Revlitix when a unique key is unavailable. Follow these step-by-step instructions to set up and save your analysis.
Steps to Generate Cohort Analysis for a Multi-Object
Step 1: Access the Reports Section
Go to View Reports.
Click on New Report.
Step 2: Add Widgets to Your Report
If you want to add new widgets to an existing report, click on Add Widgets.
Step 3: Choose or Create a Widget Template
Select a Preexisting Template: Choose from Select your templates or Select from the Revlitix templates.
Create a New Template: Click on Create Custom Widget.
Enter the widget name in the provided space.
Click the Save icon.
Step 4: Configure the Widget
Choose the Widget Type as Cohort Analysis.
2. Describe the widget.
3. Set the Channel Name to Salesforce.
4. Choose Multi-Object from the options available under Object Type.
Step 5: Select Objects and Stages
Select the Primary and Secondary Objects.
Define the Funnel Stages.
Step 6: Handle the Unique Key Question
When asked, "Is there a unique key to link these objects?" click No.
The first common hardcoded field, Email (Revlitix field), will be available.
For the Primary and Secondary Object fields, input will be taken from the respective Object fields.
Note: Email and Company names are hardcoded, with Email being a mandatory field.
Step 7: Exclude Standard Domains
Email is mandatory, so enter the domain names to be excluded from the Exclude Standard Domain field.
Step 8: Set the Time Range
Choose the time period for which you want to view the cohort analysis.
Step 9: Select Aggregation
Choose from the aggregation options: Weekly, Monthly, and Quarterly.
Step 10: Preview the Chart
After providing the necessary configuration details, a preview cohort chart will be available.
Step 11: Switch Views
Toggle between charts and graphs using the Switch button.
Step 12: Show Totals
Check the Show Total checkbox to view the total.
Step 13: Save the Template
Check the box to save this template and the configuration for future use.
Step 14: Create the Widget
Click Create Widget to save the widget to the Reports for future reference.
Click 'Save Report' to see the Reports in the details page.
Following these steps, you can create and save a Cohort Analysis for multiple objects in Revlitix, even when a unique key is unavailable.