Multi-Session Activation Completion Rate¶

Definition¶

Multi-Session Activation Completion Rate measures the percentage of users who complete the full activation flow across more than one session. It helps track long-path engagement and sustained activation behavior.

Description¶

Multi-Session Activation Completion Rate is a key indicator of onboarding effectiveness across time, reflecting how many users return to complete setup, team invites, or critical actions after their initial session.

Its meaning shifts depending on complexity:

In enterprise SaaS, activation may span integrations, data imports, or security setup
In freemium tools, it often means re-engaging with incomplete setup flows
In technical products, it shows commitment to finish configuration despite friction

A rising rate signals motivated users and clear value paths, while a low rate may reveal setup friction or unclear progression. By segmenting by persona, plan type, or signup source, you can optimize multi-step UX, activation reminders, and lifecycle support.

Multi-Session Activation Completion Rate informs:

Strategic decisions, like product-led onboarding redesign or CS automation
Tactical actions, such as triggering email nudges, banners, or checklists
Operational improvements, including onboarding SLA tracking or funnel diagnostics
Cross-functional alignment, connecting product, CS, growth, and onboarding teams around activation success

Key Drivers¶

These are the main factors that directly impact the metric. Understanding these lets you know what levers you can pull to improve the outcome

Session-to-Session Continuity: Users need to know where they left off — and why it matters to continue.
Follow-Up Prompts and Value Reinforcement: Without a reminder of progress or benefit, users drop off after initial use.
Onboarding Flow Complexity: If completing activation feels like a chore, users won’t come back to finish.

Improvement Tactics & Quick Wins¶

Actionable ideas to optimize this KPI, from fast, low-effort wins to strategic initiatives that drive measurable impact.

If completion rate is low, add persistent progress bars and session resume logic to help users pick up where they left off.
Add triggered emails or push reminders tied to incomplete activation steps.
Run a test offering a reward or unlock (“Get X when you complete onboarding!”).
Refine onboarding copy to focus on why each step matters to the user’s outcome.
Partner with lifecycle and product to track drop-off patterns between Session 1 and 2.

Required Datapoints to calculate the metric
- List of Activated Users
- Session History (≥ 2 sessions)
- Activation Milestone Completion Timestamp
Example to show how the metric is derived

1,000 new users 470 completed activation after >1 session Formula: 470 ÷ 1,000 = 47% Multi-Session Activation Completion Rate

Formula¶

Formula

\[ \mathrm{Multi\text{-}Session\ Activation\ Completion\ Rate} = \left( \frac{\mathrm{Users\ Activated\ Across\ \geq 2\ Sessions}}{\mathrm{Total\ New\ Users}} \right) \times 100 \]

Data Model Definition¶

How this KPI is structured in Cube.js, including its key measures, dimensions, and calculation logic for consistent reporting.

ActivatedUsersSessionHistoryMultiSessionActivationCompletionRate

cube('ActivatedUsers', {
  sql: `SELECT * FROM activated_users`,
  measures: {
    activatedUserCount: {
      sql: `user_id`,
      type: 'countDistinct',
      title: 'Activated User Count',
      description: 'Count of unique users who have been activated.'
    }
  },
  dimensions: {
    userId: {
      sql: `user_id`,
      type: 'string',
      primaryKey: true,
      title: 'User ID',
      description: 'Unique identifier for each user.'
    },
    activationMilestoneCompletionTimestamp: {
      sql: `activation_milestone_completion_timestamp`,
      type: 'time',
      title: 'Activation Milestone Completion Timestamp',
      description: 'Timestamp when the user completed the activation milestone.'
    }
  }
});

cube('SessionHistory', {
  sql: `SELECT * FROM session_history`,
  measures: {
    multiSessionUserCount: {
      sql: `user_id`,
      type: 'countDistinct',
      title: 'Multi-Session User Count',
      description: 'Count of unique users with two or more sessions.'
    }
  },
  dimensions: {
    userId: {
      sql: `user_id`,
      type: 'string',
      primaryKey: true,
      title: 'User ID',
      description: 'Unique identifier for each user.'
    },
    sessionId: {
      sql: `session_id`,
      type: 'string',
      title: 'Session ID',
      description: 'Unique identifier for each session.'
    },
    sessionStartTime: {
      sql: `session_start_time`,
      type: 'time',
      title: 'Session Start Time',
      description: 'Timestamp when the session started.'
    }
  }
});

cube('MultiSessionActivationCompletionRate', {
  sql: `SELECT * FROM (
    SELECT
      au.user_id,
      COUNT(DISTINCT sh.session_id) as session_count
    FROM
      activated_users au
    JOIN
      session_history sh ON au.user_id = sh.user_id
    GROUP BY
      au.user_id
    HAVING
      COUNT(DISTINCT sh.session_id) >= 2
  ) as multi_session_users`,
  measures: {
    multiSessionActivationCompletionRate: {
      sql: `user_id`,
      type: 'countDistinct',
      title: 'Multi-Session Activation Completion Rate',
      description: 'Percentage of users who complete the activation flow across more than one session.'
    }
  },
  dimensions: {
    userId: {
      sql: `user_id`,
      type: 'string',
      primaryKey: true,
      title: 'User ID',
      description: 'Unique identifier for each user.'
    }
  },
  joins: {
    ActivatedUsers: {
      relationship: 'belongsTo',
      sql: `${CUBE}.user_id = ${ActivatedUsers}.user_id`
    },
    SessionHistory: {
      relationship: 'belongsTo',
      sql: `${CUBE}.user_id = ${SessionHistory}.user_id`
    }
  }
});

Note: This is a reference implementation and should be used as a starting point. You’ll need to adapt it to match your own data model and schema

Positive & Negative Influences¶

Negative influences

Factors that drive the metric in an undesirable direction, often signaling risk or decline.
- Session-to-Session Continuity: Poor session continuity can lead to users forgetting their progress or losing interest, reducing the likelihood of completing the activation flow.
- Onboarding Flow Complexity: Complex or cumbersome onboarding processes can discourage users from returning to complete the activation, negatively impacting the completion rate.
- Lack of Follow-Up Prompts: Without timely reminders or prompts, users may not see the value in returning to complete the activation, leading to a drop in completion rates.
- Inadequate Value Reinforcement: If users do not perceive a clear benefit from completing the activation, they are less likely to return, decreasing the completion rate.
- High Drop-off Rate After Initial Use: A significant drop-off after the first session indicates that users are not motivated to continue, negatively affecting the multi-session completion rate.
Positive influences

Factors that push the metric in a favorable direction, supporting growth or improvement.
- Effective Session-to-Session Continuity: Ensuring users can easily pick up where they left off encourages them to return and complete the activation flow, increasing the completion rate.
- Timely Follow-Up Prompts: Regular reminders and prompts can motivate users to return and complete the activation, positively impacting the completion rate.
- Simplified Onboarding Flow: A straightforward and engaging onboarding process can encourage users to return and complete the activation, boosting the completion rate.
- Strong Value Reinforcement: Clearly communicating the benefits of completing the activation can motivate users to return, enhancing the completion rate.
- Increased User Engagement: Higher engagement levels across sessions can lead to more users completing the activation flow, positively influencing the completion rate.

Involved Roles & Activities¶

Involved Roles

These roles are typically responsible for implementing or monitoring this KPI:

Data & Analytics
Customer Lifecycle Management
Product Management (PM)
Product Marketing (PMM)
UX Designer / Researcher
Activities

Common initiatives or actions associated with this KPI:

Onboarding Optimization
Activation Campaigns
Product Education
Session Design

Funnel Stage & Type¶

AAARRR Funnel Stage

This KPI is associated with the following stages in the AAARRR (Pirate Metrics) funnel:

Activation
Type

This KPI is classified as a Lagging Indicator. It reflects the results of past actions or behaviors and is used to validate performance or assess the impact of previous strategies.

Supporting Leading & Lagging Metrics¶

Leading

These leading indicators influence this KPI and act as early signals that forecast future changes in this KPI.
- Activation Rate: Activation Rate measures the share of users who reach a key activation milestone in their initial engagement. A higher Activation Rate signals that more users are experiencing early value, which is a strong predictor that they will be more likely to return and complete activation flows that span multiple sessions, thus increasing Multi-Session Activation Completion Rate.
- Drop-Off Rate: Drop-Off Rate identifies where users abandon the activation process, often in early or mid-funnel stages. High drop-off at specific steps forecasts lower Multi-Session Activation Completion Rate, while improvements here typically translate into better completion across multiple sessions.
- Onboarding Completion Rate: Onboarding Completion Rate directly precedes activation flows. Users who complete onboarding are more likely to persist and return for multi-session journeys, leading to higher Multi-Session Activation Completion Rate.
- Stickiness Ratio: Stickiness Ratio (DAU/MAU) shows how habit-forming the product is. Higher stickiness means users are coming back frequently, increasing the likelihood they will complete multi-session activation flows.
- Product Qualified Leads: Product Qualified Leads (PQLs) are users demonstrating meaningful product engagement. PQL behaviors often include completing or progressing through multi-session activation flows, thereby leading to higher Multi-Session Activation Completion Rate.
Lagging

These lagging indicators confirm, quantify, or amplify this KPI and help explain the broader business impact on this KPI after the fact.
- Percent of Accounts Completing Key Activation Milestones: This metric quantifies the proportion of accounts that reach important activation checkpoints, providing direct confirmation and explanation for trends seen in Multi-Session Activation Completion Rate, and helping to identify which milestones most impact overall completion.
- Activation Cohort Retention Rate (Day 7/30): This measures how well users who complete activation continue to engage over time. A strong Multi-Session Activation Completion Rate should correlate with higher retention in activation cohorts, confirming the quality and sustainability of activation.
- Signup Completion Rate: This metric tracks the efficiency of users completing the signup flow, which is often a prerequisite to starting the activation journey. It helps explain whether low Multi-Session Activation Completion Rate is due to upstream signup friction.
- Activation Conversion Rate: Activation Conversion Rate tracks the percentage of users who reach activation after onboarding. It amplifies insights from Multi-Session Activation Completion Rate by showing the conversion efficiency of the end-to-end flow.
- Percent Completing Key Activation Tasks: This measures the share of users who complete predefined activation tasks, providing granularity on where users succeed or fail within the multi-session flow and explaining variations in overall completion rates.