Data science service: programming, analyses and data visualization
  • Data Science service
  • COVID-19 DASHBOARD
  • E-commerce
  • Blog
  • Subscribe
  • Contact
  • FRANÇAIS

Data science for e-commerce

E-commerce is one of the fastest growing industries. The following shows an overview of concrete case examples where data science can support significantly and improve your e-commerce.

Deployment of Dashboard Apps

To get insight into your e-commerce, such as customer behavior and product analysis, it may be valuable to produce dashboards that can be consulted by each business member of the team, at anytime, any place.  Such dashboards allow to visualize and interact with different aspects of the data, and can be fully customized to your business needs.

Customer segmentation analyses

Businesses need the best insight using customer segmentation analyses.
These analyses concern demographic metrics, – age, gender, education – , geographic metrics, – where do customers come from – , as well as behavioral characteristics, – which day and at what hour do customers buy their products online. These parameters altogether can be used to personalize marketing campaigning and optimize supply.
In addition to these metrics, there are also unknown dimensions that can be tapped and nevertheless segment customers in a useful way. These can be detected using unsupervised learning methods such as k-means clustering.

Barplot of behavioral characteristics
Ret_SalesVolume
Treemap of geographic characteristics
Ret-treemap_rev-countries
Worldmap of geographic characteristics
ret_worldmap

Tracking product sales using time-series

Product sales, expressed by volume and price, can be tracked using time-series analyses. Sales may differ across time of the day, as well as day of the week. By tracking the sales, the dynamics of total sales volume and price can be followed for each product. This is crucial to see sales evolution over time, and for example to decide if the stock supply should be adapted. Statistical metrics can be used to detect those products that show increasing trends versus those that show a decreasing trend across a certain time window.
Ret_ts_icsalesvolume

Ret_ts_dcsalesvolume

Seasonality effects

Seasonality effects may show up by differences in sales volume, unit price, number of customers, over different periods.
Ret_scatterplot
22933 - Baking mould Easter egg milk choc.
85049A - Traditional Christmas ribbons
22910 - Paper chain kit vintage Christmas


Relation between sales price and volume

In order to optimize profit and regulate supply, the relationship between product price and sales volume need to be established. This relationship can change across time, products, and customer segments. Another aspect that needs to be tracked are competitor prices using for ex. webscraping.
Ret_PriceVolume

Returning versus churning customers

It is well known that acquiring new customers is harder than retaining customers.
It is vital for businesses that customers are satisfied and return. For this reason it is essential to forecast if and when customers return, and how much time after a first purchase customers will make a second purchase. Marketing strategies can benefit from these data by designing personalized email campaigns, so customers receive an email just at the moment they are about to make their next purchase.

freqtable_NInvoicedates

Product affinity analyses

Product affinity analyses uses the purchase history to predict what customers are going to buy next. For example, if customers buy a certain product, there may be a high probability that they are also buying other products. This is for ex. the case for Art 85099B and Art 23203 in the heatmap underneath.

Ret_Heatmap

Customer lifetime value

Customer lifetime value is an indicator how much a customer is expected to spend during the whole customer relationship. This can help to segment customers in different categories and design marketing strategies.

About the data and visualizations
The online retail dataset was used for visualizations with Python Matplotlib and Plotly.
Images were taken from Unsplash and credits go to the following persons:
unsplash-logoBernard Hermant
Picture
Picture
Picture
Ruthger Righart
Ferney-Voltaire
France

Email: rrighart at googlemail dot com
Tel.: 0033 (0)770071310

Immatriculation au Registre du Commerce et des Sociétés: 833 982 358 R.C.S. Bourg-en-Bresse. Greffe du Tribunal de Commerce, 32 Av Alsace Lorraine, 01011 Bourg-en-Bresse Cedex.
  • Data Science service
  • COVID-19 DASHBOARD
  • E-commerce
  • Blog
  • Subscribe
  • Contact
  • FRANÇAIS