NUPANCH
  • Home
  • Services
  • Customers
  • About
  • Contact
  • Blog

Stay informed on the latest in e-commerce analytics

How to forecast sales of new products

6/22/2018

1 Comment

 
Picture
One of the biggest problems that eCommerce companies face is inventory management. Having too little or too much inventory for a product lowers profitability. Lack of inventory can also mean a lost customer.

There are many solutions for inventory management today. Most of these focus on forecasting sales for existing products or newer versions of existing products. There are fewer and less proven methods for forecasting sales of completely new products. And understandably so - without any historical sales data for comparable products, it is more intuition than science.

Read More
1 Comment

Smart Strategies to get answers from data

6/4/2018

0 Comments

 
You get your hands on a new data set. The goal - to get a deeper understanding of a specific phenomenon, say churn. You do the due diligence - eyeball the data to see what data points it contains and prepare some basic summaries (averages, medians etc.). Then you start asking questions of the data to get a better understanding of churn.

However, after building out a few reports, nothing stands out. The behavior of users who end up churning seems very similar to users who renew. Their interactions with your product/service are not very different. Customer support metrics are equally positive. ​

This leaves you confused and a bit apprehensive. If there are no visible differences or indicators, how do you optimize renewal?

Read More
0 Comments

The easy way to read sql

5/29/2018

6 Comments

 
Remember the first time you saw a large SQL query written by somebody else? I do. Meaningless aliases, no comments, all sub-queries and no common-table-expressions. Almost zero readability. What’s worse is that I had to debug this query because it was resulting in a discrepancy. Where on earth do I start?

Read More
6 Comments

A holistic picture of customer lifetime value

4/17/2018

3 Comments

 
Picture
Many eCommerce companies calculate Customer Lifetime Value (CLV) as the sum of all historical purchases for each customer. However, CLV, by definition, is a forward-looking statement. By simply considering historical purchases, the underlying assumption is that the customer will not make any further purchases. There has been significant statistical research into creating reliable probabilistic models to calculate Residual Customer Value (RLV) i.e. the dollars your customers are yet to spend.

Read More
3 Comments

Do you need a business intelligence tool?

3/5/2018

1 Comment

 
Picture
The short answer is Yes. Heck Yes. At some point during an e-commerce company’s growth, teams begin to organically form, and team members begin asking “why” and “how many” questions. This often happens when new customers are being acquired, and it’s not easily clear where they came from. You’re no longer measuring marketing ROI by the revenue that came in during the campaign only. Now you’re looking at customer lifetime revenue as the “return” part of the equation.

Read More
1 Comment

Flattening the magento eav structure in SQL

2/2/2018

1 Comment

 
Picture
The Magento EAV structure is one that is designed for scalability, but loses efficiency when it comes to data analysis. Due to the use of multiple tables for storing the “entity”, “attribute” and then the “value”, a SQL query to perform complex product analyses is required to perform joins across several tables. This article outlines an approach to “flatten” this structure so that all products and their associated attributes are stored in the same table, allowing for easy analysis.

Read More
1 Comment

magento bi - Getting the most out of it

1/25/2018

1 Comment

 
Picture
In July 2016, Magento acquired RJMetrics, a business intelligence platform designed primarily for e-commerce analytics. This product has now been branded as Magento Business Intelligence, offering a full stack BI product to Magento merchants.

Read More
1 Comment

      stay up to date with the happenings in e-commerce. 

      Subscribe today!

    Subscribe to Newsletter

    Archives

    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018

    Categories

    All

    RSS Feed

Home

About

Contact









​Data migration icon used on the home page is by "unlimicon" from The Noun Project.
Report building, account cleanup and data structuring icons used on the home page are by "Dinosoft Labs" from The Noun Project.
Getting the most out of icon used on the blog page is by "Luis Prado" from The Noun Project. 

  • Home
  • Services
  • Customers
  • About
  • Contact
  • Blog