Qlik Sense solution for e-commerce for online stores on Magento

Project team of A2 Consulting implemented a solution for e-commerce analysis in Qlik Sense based on data from Magento.

Magento

Magento is one of the most popular open electronic systems for organizing e-commerce in the net: more than 100 thousand online stores are based on it, third-party developers created more than 2 thousand extensions; project community has about 375 thousand participants.

  • In January 2017 Magento received another 250 million investment for development in the growing Asian e-commerce markets.
  • Magento is the leading platform for e-commerce, which has about 30% of the market.

Application includes KPI for key indicators such as Sales, Revenue, Number of New Customers, AOV (average order value), UPT (unit per transaction), and their dynamics over different time periods. To upload data from the accounting system, we use only authorized Qlik Tech connectors. The data in the application is updated every hour for convenience control of KPIs in the application’s dashboard.

magento

To monitor changes in customer behavior, a cohort analysis was implemented.

magento1

New buyers, repeat buyers and VIP-buyers are analyzed separately to form personal offers and their retention.

magento2

To monitor all indicators on a single dashboard, the application integrates data from Google Analytics.

magento3

 

If you want to fing out more about this integration - please make a request