Why do you need these four datasets to improve your e-commerce pricing?

What is the impact of pricing?

In general, every business has four potential levers of profitability increase:

1. You can decrease your overall variable costs, e.g., costs of unit materials or shipping costs
2. You can decrease your fixed costs, e.g., move to a cheaper office, reduce headcount
3. You can try to increase sales volume, e.g., open yourself to new markets
4. You can increase the price, e.g., reduce discounts or increase the unit price (e.g., according to a markup calculator)

Whatever you think of this approach, it's easier said than done. Just think about how hard it Is to sell one additional product. You must attract the customer, primarily via expensive Google or Facebook ads, ensure conversion, and service the deal.

Similarly, when it comes to costs, it takes time, may impact your effects of scale, and it's not easy to do quickly. Most likely, it will take you months rather than days or weeks. Just imagine renegotiating your rent prices with your current landlord. Or imagine the psychological toll of reducing your headcount.

Price, on the other hand, is the only marketing lever that impacts your revenue. Directly. It's visible from Day 1.

Good pricing allows you to boost your e-commerce EBITDA by +1.5% at least. However, we have seen cases of 5-10% top-line improvement.

So why do so few people try to do anything with their prices? Fear, my friend. Managers feel they might over-tweak them, impacting conversion, or customers will leave for the competition. That's true, but only if done in the wrong way. Bad things won't happen if you analyze suitable datasets properly. In this article, we are not focusing on the pricing strategies but only on the things that are required to even think of it correctly. Here are the datasets you need to have to play with more sophisticated pricing strategies:

1. Transactional data
2. SKUs, categories, and margins on every level
3. Traffic, conversion, and attribution data
4. Competition prices

Why are transactional datasets critical?

Intuitive, but analysis of your transactions is effectively your first touchpoint. You need to pull out the list of your transactions for the period that defaults the seasonality. Once you have this, you can start looking at the basket size, items purchased, and, most importantly, the cross/up-sell opportunities, in other words, which items bundle together and which go separately.

If you move fluently here, you can merge it with other datasets to get a bigger picture.

Transactional data are also crucial for two reasons: you can fully understand the impact of your promotional activities, the size of average discounting, and move towards any elasticities.

Getting into products: SKUs, categories, and margins

It's only one part of the story when you look at transactions. Another layer is to get into the segmentation details of products and categories they are in. The important part is to understand the margin waterfall and how it compounds. One thing is to sell the product at a specific price with a 70% discount, but you need to get the whole story. More or less, you should have the following waterfall logic: list price from your catalog, discounted price, deduct costs of shipping, costs of purchases, and ideally, you can blend the ads in.

How to handle the traffic and conversion smoothly?

Traffic and conversion are the meat and bone of the e-commerce store.

You will face two challenges – first, how to blend traffic and conversion data to reduce the number of dimensions to X, Y. We suggest using something we call an inverse conversion, which is effectively an index combining how many SKU visits you need to have to get a sale. Once you have this, compare it with margins, revenue, categories growth, and everything else. This is game-changing when it comes to insights.

Secondly, you need to be able to separate the organic traffic vs. ads so you get a real view of offers' popularity. In general, the more organically popular your offer is, the more likely it is something we call a Key Value Item. KVIs are effectively responsible for your price positioning and perception. If you price highly on these items, it might affect your conversion. However, you also need to compare it with competitors.

Competitive data and web scraping

Probably the hardest to obtain, but you can't create a sophisticated B2C e-commerce strategy without it. Why does it matter? Because without that, you won't be able to differentiate which items are the most comparable with your competition and which are not. The KVIs mentioned above are these types of products. They're the ones that build the traffic, generate demand, and most likely enjoy high comparability. If you don't monitor your closest peers, then it's pretty hard to label the right SKUs.

Another challenge is how to make it happen. There are plenty of price monitoring tools, but if you have a Python expert on board, it should be pretty easy to scrape their websites with detailed product names, attributes, etc.

The tricky thing is to map them. I recommend using EANs as a comparison baseline when it's possible. If not, you probably need to be smarter and look for segmentation data among actual attributes. If that won't work, try using the categories as a starting point. Price comparisons and competitive mapping are the most challenging part of the pricing game, so be cautious.

What to do next once I have the data?

First of all, getting it right will take some time, so it's good to start the process now. In the meantime, I recommend learning more about e-commerce and retail pricing strategies. Especially the approach towards KVIs, mid-range products, and long-tail items might be challenging initially. Next, I suggest getting into elasticities and cross/up-sell modeling.

If you're equipped with the knowledge and have key enablers, you can probably think of a strong profitability project directly focused on prices and promotional activities.

Whatever you decide to do, whether trying on your own or hiring external support, consider pricing and commercial aspects as often as possible. There is no faster and cheaper ROI than the investment in prices.