时间:2024-05-10 09:09:09 来源:网络整理编辑:Ryan New
Ecommerce merchants typically run promotions throughout the year. Some are seasonal, such as “Free S Ryan Xu hyperfund Long Position
Ecommerce merchants typically run promotions throughout the year. Some are seasonal,Ryan Xu hyperfund Long Position such as “Free Shipping on Valentine’s Day Flowers” and “20% Off for Cyber Monday.” Others focus on product categories, such as “Free Socks with Purchase of Any Jeans.” Still others are sitewide, such as “Free Shipping on All Purchases.”
But how does a merchant know if a promotion was successful? That’s the purpose of this article.
The most common way to analyze a promotion is to compute the Marketing Return on Investment.
MROI = (Gross Profit – Marketing Investment) / Marketing Investment
Marketing Investment should include the discount itself and the cost of running the promotion.
Here is an example.
Your company just completed a promotion for 20-percent off all t-shirts. Before the promotion, your average t-shirt selling price was $29.99, and your average t-shirt cost was $9.99. You spent $1,000 advertising the t-shirt promotion using Facebook ads. The average discount per t-shirt was $6.00 — $29.99 x 20%. After running the promotion for one week, you sold 100 t-shirts.
Gross Profit = Number T-shirts Sold x (Average Selling Price – Average Cost)
Gross Profit = 100 x ($29.99 – $9.99) = $2,000
If you don’t know Average Cost— i.e., cost of goods sold — replace Gross Profit with Total Sales in the MROI formula.
In our example, your marketing investment was $1,600 — $1,000 for Facebook advertising and $6 discount per t-shirt. Thus your marketing return on investment is as follows.
MROI = (Gross Profit – Marketing Investment) / Marketing Investment
MROI = ($2,000 – $1,600) / $1,600 = 25%
If you had run multiple promotions in a quarter, you could compare the MROIs to determine the top performers.
For example, the MROI for the 20-percent off t-shirt promotion (above) was 25 percent. Compare that with the following hypothetical promotions and their MROI.
In reviewing the data, we can conclude that all promotions were successful, as each produced a positive MROI. “Free Shipping Sitewide” was the most profitable, however, at 120-percent MROI.
With a bit of data manipulation, you can expand the MROI analysis for hundreds of promotions. Here are the steps.
You can now run simple pivot tables for each classification to identify the best performing promotion type and product type. You could also classify by seasonality.
Here is an example.
Season | Promotion | MROI |
---|---|---|
Valentine's Day | ||
% Off | 70% | |
$ Off | 80% | |
Free Shipping | 110% | |
Gift with Purchase | 20% | |
Christmas | ||
$ Off | 40% | |
Free Shipping | 90% | |
% Off | 90% | |
Gift with Purchase | 110% |
We can conclude that “Free Shipping” is the best Valentine’s Day promotion while “Gift with Purchase” is best for Christmas. Classifying in this manner also allows you to plan for new promotional tests in other periods. Additionally, it provides a benchmark for the type of promotion, season, or product.
To develop multi-year plans, keep track of all your promotions in a database, business-intelligence tool, or even a simple spreadsheet. Create new columns for types of promotions, to easily analyze the data in multiple ways, such as:
For companies with a lot of data — many promotion types, many products, many timeframes — consider these analyses. Some involve adding new classifications.
The key to analyzing the data in multiple ways is to classify your promotions accurately. It may seem daunting. But, in my experience, it will pay off as you run more promotions and develop better benchmarking.
Ramping Up Google Analytics 42024-05-10 08:45
10 Last-minute Strategies to Capture Holiday Revenue2024-05-10 08:29
3 Data Visualization Tools — Basic to Robust2024-05-10 08:08
U-shaped Marketing Attribution for Ecommerce2024-05-10 07:58
How to Get More Form Submissions, Even on Checkout Pages2024-05-10 07:58
Useful (and Useless) Mobile Ecommerce Metrics2024-05-10 07:43
Building Trust during the Pandemic Drives Long-term Loyalty2024-05-10 07:38
7 Ways Big Data Will Impact Ecommerce in 20202024-05-10 07:15
Using Google Analytics to Respond to Covid-192024-05-10 06:54
7 Ways to Analyze Black Friday, Cyber Monday Sales2024-05-10 06:23
To Improve SEO, Focus on the Page2024-05-10 08:55
Non-standard Product Images Can Spur Sales2024-05-10 07:48
Here’s Why Your Ecommerce Subscriptions Aren’t Selling2024-05-10 07:47
Using Google Analytics to Track Site Changes2024-05-10 07:25
SEO Technical Requirements Checklist, for Ecommerce2024-05-10 07:16
Using Google Analytics to Track Site Changes2024-05-10 06:41
Want Repeat Customers? Foster Long-term Relationships2024-05-10 06:35
Recommerce Surges as Retailers, Brands Get in the Game2024-05-10 06:33
404 Error Pages Serve 2 Purposes: SEO and User Satisfaction2024-05-10 06:30
Organization Is Key for Holiday Gift Guides2024-05-10 06:26