Using Regression Analysis to Drive Ecommerce Sales

Using Regression Analysis to Drive Ecommerce Sales

November 13, 2018 10:05 pm

Have you ever ever questioned what drives your gross sales? Ecommerce companies sometimes know the supply of their income, the price of acquisition, and whether or not campaigns are working.

However what in the event you might drill down to seek out particular gross sales drivers? Utilizing regression evaluation, a enterprise can decide delicate causes, similar to:

  • The social media channel that impacts gross sales extra.
  • The quantity that gross sales ought to improve after a bump in marketing spend.
  • Whether or not free delivery or reductions contribute extra to gross sales.
  • Whether or not one product class must be marketed aggressively.

Regression Mannequin

Companies use regression fashions to know how modifications in a set of unbiased variables have an effect on a dependent one.

For ecommerce companies, the dependent variable is usually gross sales. It may also be conversion charges or e mail signups, as examples. For this text, I’ll assume the dependent variable is gross sales. The unbiased variables might be e-mail sends and expenditures on social media and search engine marketing, as examples. The regression mannequin lets enterprise house owners measure, one by one, every unbiased variable’s impression on gross sales.

In different phrases, a regression mannequin can predict, say, how a lot a 20 % improve in Fb advert spend will improve gross sales. It could use previous gross sales and, maybe, climate knowledge by date to foretell how a coming storm will sluggish or velocity gross sales. It may additionally offer you an concept of the rise or lower in gross sales ensuing from further e-mail sends — a lower would point out subscriber annoyance.

The chart under is a illustration of gross sales and web optimization spend. This ecommerce enterprise proprietor wanted solely gross sales quantities and price of search engine marketing to create a chart that predicts how search engine optimization spend impacts income.

An ecommerce owner needs only historical sales and cost of SEO to predict how SEO spend impacts revenue, as depicted on this chart.

An ecommerce proprietor wants solely historic gross sales and price of search engine optimization to foretell how search engine optimization spend impacts income, as depicted on this chart.

A easy regression components might be:

Y = A+B(X)

  • Y is the dependent variable — gross sales, e mail signups.
  • X is the worth of the unbiased variable — Fb advertisements, e-mail frequency.
  • B is a continuing that displays how a lot Y modifications for each worth of X. (Getting an correct quantity might require a mathematician or an app.)
  • A is a continuing that equals the worth of Y when X is zero. Decide A by plugging zero into X.

Statistical software akin to SAS or IBM SPSS (or packages out there for R or Python) could make this calculation easy. Plug in knowledge about gross sales (the dependent variable) and a marketing or product variation (the unbiased variable) and it measures B and Y.

Constructing a Regression Mannequin

1. Ask the suitable query. Earlier than constructing any statistical mannequin, perceive the issue you are attempting to unravel. In case you are trying to see why Fb efficiency is down, you in all probability don't want a time consuming and typically costly statistical mannequin. A easy evaluation will possible do the job. Nevertheless, if a easy evaluation doesn't determine why your general gross sales are down and lots of potential variables can influence gross sales, a regression mannequin is your doubtless answer.

2. Knowledge assortment and manipulation. The second step is often probably the most crucial and time-consuming. It's accumulating and manipulating the info in order that it’s usable. Your knowledge ought to be aligned throughout all sources for a similar interval — weekly, month-to-month. The extra knowledge factors you will have, the higher the mannequin.

What are potential sources of knowledge?

  • Seasonality is likely one of the most crucial knowledge factors. Breaking down your knowledge by the week or the month might help clarify a decline in gross sales.
  • Business knowledge may be costly, or inconceivable, to accumulate. However the main purpose why your gross sales are down might don't have anything to do together with your marketing. It might be that buyers’ tastes have modified, they usually not purchase into your class.
  • Gross sales knowledge is usually used to set your Y end result (dependent variable).
  • Product info. Plug in particular product gross sales numbers to find out the impression on general income. Extra analysis will reveal whether or not phasing it out is the best course.
  • Advertising knowledge. Look at advertising knowledge by supply, spend, and different elements. Pinpoint whether or not a selected advertising marketing campaign or channel contributes to gross sales will increase or declines.
  • Different sources. Relying on the enterprise, you might have further knowledge that may assist clarify gross sales efficiency. Examples are product availability, product high quality, worth, and so forth.

three. Interpret your evaluation. Hopefully, the outcomes in your regression evaluation will make sense. Suspicious or unclear outcomes, nevertheless, point out your work isn't carried out. A couple of sub-evaluation fashions can go deeper into causes, however you might want skilled assist to resolve your gross sales points.

four. Take motion. Insights from regressive fashions scale back prices and increase gross sales so long as you act on them.

For instance, the regression mannequin might have uncovered that operating Google Advertisements helps drive gross sales, and for those who improve your spend by 10 %, you need to see a 5 % gross sales improve. You'll be able to check that concept by growing your spend and monitoring the outcomes. (A regression mannequin is an estimate and will all the time be examined earlier than making giant-scale modifications.)

Different Instruments

There are different analytical and statistical fashions to derive key advertising and product-improvement insights. Nevertheless, in case you are taking a look at what drives your gross sales, the regression mannequin works properly.


You may also like...