Cohort Analysis: Analyse Magento Customers’ Behaviour

grandstand-330930_1280Understanding your customers natural behaviour can not only bring more sales to you, but also make your brand loved and honoured.

When average businessman hears about Cohort analytics, Latency Matrix or RFM reports, the only thing that arises in mind is pain or mess. You never know which side you should start from or what are the best practices for completing the analysis. Though there’s nothing too complicated – it is made to divide your customers by groups to work better with them via e-mail, phone or any other method of contact you may use.

________________________________________
A cohort is a group of people who make the same thing and whom we expect the typical ways behaviour in the future
________________________________________

Simple example of cohort sales analytics usage

Let’s say you sell toothbrushes. As per recommendations, people should change it at least once a month. Any toothbrush will be fine, so there’s no difference which one is bought, just the fact that it is ordered is considered as desirable shopper’s behaviour.

If the customer hasn’t ordered a toothbrush from you for over 2 months since the first purchase was made, you need to do everything to remind him/her about your store. Tell the shopper that the last toothbrush was ordered from your store and if he/she liked it, a new order should be placed once again.
In case buyer hasn’t ordered a toothbrush for 6-10 month period, you’ve lost him/her, as most likely his/her behaviour was changed and moved to another store. Customers with orders made over 12 months ago are considered as lost and you need to bring them back as new ones.

Get lost in the search results?

Let Promodo experts help your website index better by optimising your pages, improving your content, and enhancing your linking strategy.

By clicking this button you agree to our terms & conditions

The predictable action depends on product lifetime. Find out what is your customer’s normal behaviour.

How the cohort analytics can help you get those purchasers back? You can filter your customers by time period when they have placed their orders, for example, get the list of clients who have placed an order within last month. Then send them reminder that it is advisable to change toothbrush every month, forward details from dentists why it is important and try to make a second sale. It is our first simple cohort of customers, who have placed the order within one month and we want them to make a second purchase. The e-mail shouldn’t contain any discount code or coupon, but it need to be informative. Talk to your clients and they will keep the task of ordering toothbrush in mind and your store will be the first in the list where it can be ordered.

Next step is to find customers who have placed their orders within 1-2 month period. It is our second cohort. You should send these shoppers a kind of call-to-action e-mail in order to remind about importance of the toothbrush renewal and all horrors of using an old one.

Clients who have placed an order 2 – 6 months ago most likely are placing orders at some other store with toothbrushes or just do not care too much about their dental health. You can try to convince them with some offer or code in order to bring them back to your shop and turn these occasional buyers into your loyal clients.

While customers who haven’t placed an order for over 6 months should be treated differently, you should take care about them as well.

Filter customers by last interaction, to help them move forward

That’s simplest Cohort report with Recency as main parameter. This analytics can be executed right in Excel.
Just export the list of orders from your store for the last year, open it in Excel and in the new sheet insert “show unique” or “unique” to get the list of unique e-mails and in the next column add “sumif” formula to show the latest order date made by each customers.

Filter the list using dates to get your desired cohorts. You’ll get the lists of buyers to work with or send an e-mail via any mail client. According to the RFM model, a customer who has recently interacted with your store is more inclined to accept another interaction that you initiate.

Almost all ecommerce sites have 60% of one-time buyers

Though when working with cohorts this way you might miss some important points, like one-time buyer or customer who has placed 10 orders this far. You will treat the same way two customers who have spent $10 and $1000 as only the last order and the fact that it was placed will be taken into consideration. This way all the people, who have left order at you webshop are treated basing on their last purchasing action.

More complete analytics is shown in Recency, Frequency, Monetary report. It considers the number of purchases as well as total sum that customer has spent at your online store.

These types of reports you can check for your Magento store with Store Manager. Learn more about it or download it right away here.

3e56531This post is provided by guest contributor Oksana Semenyuk, CMO at eMagicOne  – company offering smart and convenient ecommerce solutions that make maintaining online business very easy and effortless.

 

Leave a Reply

avatar
  Subscribe  
Notify of

Recent posts

PPC Case Study: How to Increase Sales in the Online Store During the Lockdown

September 22, 2020

Many online marketers habitually classify PPC ads as a tool for boosting direct sales. However, this type of advertising can be an effective means to increase brand awareness. In this article, we share the case of a premium audio equipment retailer from the UK. Client Premium Sound is a Hi-Fi & home cinema equipment retailer Continue reading >

The Ultimate Guide on Google Shopping Campaigns

September 11, 2020

In 2019 Adwords shopping campaigns generated 29% more revenue year-over-year. Whereas paid search revenue increased by only 13% over that period. Is it possible to increase conversions from Shopping ads in 2020? – Yes! Learn the best practices from real cases explained by our PPC Specialist Vladislav Platonov. What is Google Shopping? Google Shopping is Continue reading >

Mobile app promotion: 9 effective ways to market an app

September 4, 2020

Mobile apps skyrocket the digital marketing space. Last year’s CEE eCommerce report showed that 69% of shopping sessions take place on mobile and generate 44% of revenue and 41% of transactions.  Mobile app promotion matters in 2020. In this article, we will give an overview of the most effective channels used to market an app, Continue reading >

16 Ethical Principles in Business from Promodo

August 21, 2020

It’s been 16 years since we created Promodo. If it were a human, by this age, Promodo could have applied for a driving licence, received a National Insurance number or even joined a trade union. As a Digital Marketing agency, by the age of 16 we weathered crises, acquired trust of partners all over the Continue reading >

Let's get the ball rolling

Please fill in this short form and we will be in touch with you soon

For any questions [email protected]

UK | USA | EST

+44 (0) 20 313 766 81
+44 7852 537715

Lincoln
The Terrace AT5,
Grantham Street,
LN2 1BD

+1 347 809 34 86

Las Vegas
6920 S. CIMARRON RD.,
Suite 100,
NV 89113

Tallinn
Roosikrantsi 2-K230,
Kesklinna linnaosa,
Harju maakond,
Tallinn 10119

CEE Ecommerce Report 2019

Based on the analytics data of 292 websites

enter correct name, please
enter correct e-mail, please
SEO

Cohort Analysis: Analyse Magento Customers’ Behaviour

0
start now

Start now