Measuring Customer Lifetime Value in Google Analytics

Last Updated: May 26, 2022

In this article, you will learn to measure the Customer Lifetime Value in Google Analytics for mobile app users and website users through the ‘Lifetime Value’ report.

In Google Analytics, there is a report (still in beta), called the lifetime value report through which you can measure the lifetime value (also known as LTV) for website users / mobile app users.

Lifetime value is the projected revenue (sales), a person may generate during his/her lifetime, as a customer, for your business.

Through the lifetime value report, you can understand, how valuable website / mobile app users are to your business.

You can also compare the users acquired through different marketing channels (organic search, paid search, etc) to determine the channels which bring high-value users to your website.

In Google Analytics, the lifetime value report is available in both ‘Website View‘ and ‘Mobile App view‘.

Follow the steps below to access the lifetime value report in the ‘Website view’:

Step-1: Login to your Google Analytics account.

Step-2: Navigate to the view which has been collecting ecommerce data.

Step-3: Navigate to Reporting tab > Audience > Lifetime value:

Measuring Customer Lifetime Value in Google Analytics

Follow the steps below to access the ‘lifetime value’ report in a mobile app view:

Step-1: Login to your Google Analytics account.

Step-2: Navigate to the mobile app view which has been collecting ecommerce data:

mobile appview

Note: You can use the mobile app view only when you have set up mobile app tracking

Step-3: Navigate to Reporting tab > Audience > Lifetime value:

lifetime value report

Going forward whatever I explained about the lifetime value report is equally applicable to both website users and mobile app users.

Attribution Modelling in Google Analytics and Beyond
Attribution Modelling in Google Ads and Facebook

 Click book covers to find out more

Components of the Lifetime Value Report

Following are the various components of this report:

  1. Acquisition Date Range
  2. LTV metrics
  3. Compare metric
  4. Graph
  5. Data table

Pay special attention to the various highlighted components of a lifetime value report:

ltv components
ltv components2

Acquisition date range

acqusition data range

The acquisition date range is the duration during which the website / mobile app users were acquired:

Any user which is acquired during this date range is included in the lifetime value report.

If you want to analyse the users acquired during the most recent single-day campaign then set the acquisition date range to ‘Yesterday’:

yesterday

If you want to analyse the users acquired during the most recent 1-week long campaign then set the acquisition date range to ‘Last Week’:

last week

Similarly, if you want to analyse the users acquired during the most recent 1-month long campaign then set the acquisition date range to ‘Last 30 days

You can also set a custom acquisition date range

For example, if you want to analyse the users acquired during a campaign which ran from say March 1, 2015 to Feb 1, 2016, then you can do that by selecting ‘custom‘ from the date range drop-down menu, as shown below:

custom data range


My step-by-step blueprint for selecting the best Excel charts for data analysis and reporting (40 pages)

Get the FREE e-book on Best Excel Charts For Data Analysis And Reporting (40 Pages)

Download the FREE ebook

 

Lifetime Time Value (LTV) metrics

The following seven LTV metrics are available in the lifetime value report:

  1. Appviews per user (LTV) – applicable only for mobile app users
  2. Pageviews per user (LTV) – applicable only for website users
  3. Goal completions per user (LTV)
  4. Revenue per user (LTV)
  5. Session duration per user (LTV)
  6. Sessions per user (LTV)
  7. Transactions per user (LTV)
ltv metrics

Note: Here, the user refers to your website / mobile app user.

Appviews per user (LTV)

It is the cumulative average appviews per user.

This metric is calculated as:

Cumulative Average Appviews per user (LTV) = Cumulative Appviews (LTV) / Users

Here,

A cumulative metric is the one, whose value increases by successive additions over time.

Users => total number of app users acquired during the selected acquisition date range.

appviews per user

For example:

Appviews (LTV) = 12,613

Users = 409

Cumulative Average Appviews Per User (LTV) = 12,613 / 409 = 30.84

appviews per user2

The graph below shows the cumulative average appviews in the first 30 days after acquisition:

Day 0 shows the cumulative average app views of users on the day of acquisition.

Day 1 shows the cumulative average app views of users on the first day after acquisition.

Similarly,

Day 29 shows the cumulative average app views of users on the 29th day after acquisition.

Since all of these 30 data points represent cumulative average metric, the last data point (29th data point) in the graph above represents the cumulative average appviews, which is also reported in the data table of the lifetime value report:

appviews per user3
week tab

If you want to see the x-axis on the graph to show one data point for each week, instead of one data point for each day, then select the ‘week’ tab:

week tab2

So if you select acquisition date range of last 30 days then you will see five 5 data points on the graph, where each data point represents one week:

Week 0 shows the cumulative average app views of users in the week when they were first acquired.

Week 1 shows the cumulative average app views of users in the first week after acquisition.

Similarly,

Week 4 shows the cumulative average app views of users in the fourth week after acquisition.

month tab

If you want to see the x-axis on the graph to show one data point for each month, instead of one data point for each day or week, then select the ‘month’ tab:

month tab2

So if you select acquisition date range of the last 30 days then you will see only one data point on the graph, which represents a month:

Note: Google Analytics calculates, cumulative LTV metrics for up to the first 90 days after acquisition.

Pageviews Per User (LTV)

It is the cumulative average pageviews per user.

This metric is calculated as:

Cumulative Average Pageviews per user (LTV) = Cumulative Pageviews (LTV) / Users

Here,

Users => total number of non- mobile app users acquired during the selected acquisition date range.

The graph below shows the cumulative average pageviews in the first 30 days after acquisition:

pageviews per user ltv

Day 0 shows the cumulative average pageviews of users on the day of acquisition.

Day 1 shows the cumulative average pageviews of users on the first day after acquisition.

Similarly,

Day 30 shows the cumulative average pageviews of users on the 30th day after acquisition.

Since all of these 31 data points represent cumulative average metric, the last data point (31th data point) in the graph above represents the cumulative average pageviews, which is also reported in the data table of the lifetime value report:

cumulative pageviews per user

If you want to see the x-axis on the graph to show one data point for each week, instead of one data point for each day, then select the ‘week’ tab:

week tab

Similarly, if you want to see the x-axis on the graph to show one data point for each month, instead of one data point for each day or week, then select the ‘month’ tab.

Goal Completions Per User (LTV)

It is the cumulative average goal completions per user.

This metric is calculated as:

Cumulative Average Goal Completions per user (LTV) = Cumulative Goal Completions (LTV) / Users

goal completions per user

For example:

Cumulative Goal Completions per user (LTV) = 58,030 / 15,605 = 3.72

Revenue Per User (LTV)

It is the cumulative average revenue per user. This metric is calculated as:

Cumlative Average Revenue per user (LTV) = Cumulative Revenue (LTV) / Users

Session Duration Per User (LTV)

It is the cumulative average session duration (in seconds) per user. This metric is calculated as:

Cumulative Average Session Duration per user (LTV) = Cumulative session duration (LTV) / Users

session duration per user

For example:

Cumulative session duration (LTV) = 1611:31:01

1611 is the number of hours,

31 is the number of minutes

1 is the number of seconds

Let us convert hours and minutes into seconds.

1611 hours * 3600 = 5799600 seconds

31 minutes * 60 = 1860 seconds

So, Total number of seconds = 5799600 seconds + 1860 seconds + 1 second = 5801461 seconds

Now,

Cumulative session duration (LTV) = 1611:31:01 = 5801461 seconds

So,

Session Duration Per User (LTV) = 5801461 seconds / 120,480 users = 48.15 seconds per user = 00:00:48

Sessions Per User (LTV)

It is the cumulative average sessions per user. This metric is calculated as:

Cumulative Average Sessions per user (LTV) = Cumulative Sessions (LTV) / Users

Transactions Per User (LTV)

It is the cumulative average transactions per user. This metric is calculated as:

Cumulative Average Transactions per user (LTV) = Cumulative Transactions (LTV) / Users

Comparing LTV metrics

plus button

To compare LTV metrics with each other, click on the following plus ‘+’ button next to the LTV metric, then select the metric you want to compare from the drop-down menu:

compare metric
compare metric2

Here we are comparing ‘Transactions Per User (LTV) with the ‘Tenure’ metric.

‘Tenure’ is the number of users who have been with your business for a particular time duration (days, weeks, or months).

Dimensions in Lifetime Value Report

Following four dimensions are available in the lifetime value report:

  1. Acquisition Channel
  2. Acquisition Source
  3. Acquisition Medium
  4. Acquisition Campaign
dimensions

These dimensions help you in analyzing the various LTV metrics in a different context.

Note: You can’t apply a secondary or custom dimension to the lifetime value report.

My best selling books on Digital Analytics and Conversion Optimization

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.

About the Author

Himanshu Sharma

  • Founder, OptimizeSmart.com
  • Over 15 years of experience in digital analytics and marketing
  • Author of four best-selling books on digital analytics and conversion optimization
  • Nominated for Digital Analytics Association Awards for Excellence
  • Runs one of the most popular blogs in the world on digital analytics
  • Consultant to countless small and big businesses over the decade