Ecommerce Business: Template for Cohort Analysis
Originally published: 13/02/2017 14:08
Last version published: 02/03/2017 15:14
Publication number: ELQ-61611-2
View all versions & Certificate

Ecommerce Business: Template for Cohort Analysis

Estimate lifetime value for an Ecommerce business using a sample cohort analysis.

I’ve come across a lot of questions regarding how cohort analysis differentiates for an e-commerce business, where I got around designing a sample template.

Do keep in mind that this is a sample. The data used is dummy data so it should not be used for benchmark purposes. The file can be edited, as you wish.

Below, you will find the downloadable excel file which you can make your own. Along with it, there is an online methodology that contains essential information needed for the sample.

- Jeremy Liew

This Best Practice includes
1 Excel sheet, 1 methodology

Jeremy Liew offers you this Best Practice for free!

download for free

Add to bookmarks



keyboard_arrow_downShow all


Discussion feed for Ecommerce Business: Template For Cohort Analysis

The user community and author are here to help. Go ahead!

  • Nisa
    Hi there. How is the payback period calculated (row 48)? And what is the parameter for True/False payback (column u)?
    arrow_drop_uparrow_drop_downReply reply

    3.8 / 5 (34 votes)

    please wait...