How to use sales data to negotiate in the field

Sales data to the rescue of field sales staff

Arthur d'Achon
December 8, 2021 - 5 min reading
Updated April 25, 2024

The more uncertain the environment, the more businesses need benchmarks to rely on. The solution is to use and interpret the data wisely to make the right decisions.

In this article, we'll take a look at the sales data that will be most useful to your area managers, and the best practices for making the most of them.

Commercial data sources

As a national brand, you can exploit a large amount of commercial data:

  • Sales data :
    • Sales by product: Analyze quantities sold, revenues generated by product and changes in product performance over time.
    • Sales by store or brand: Evaluate the performance of different points of sale and identify high- and low-performing stores.
    • Sales seasonality: Observe sales trends according to season or during special periods such as holidays or promotions.
  • Customer demographics :
    • Age, gender and geographic location: This essential information helps you segment your customers and personalize your offers.
    • Demographics by store or brand: Understand the profile of customers who visit each store to better tailor your inventory and local marketing campaigns.
  • Behavioral data :
    • Buying behavior: Track purchase frequency, product categories, average basket and brand preferences.
    • Customer journey: Identify typical customer journeys in the store or on your online site, as well as the touch points that influence the purchasing decision.
  • Logistics data :
    • Stock levels: Manage inventories, identify out-of-stocks and optimize product distribution.
    • Delivery times: Measure store replenishment times and supply chain efficiency.
  • Marketing data and promotions :
    • Promotional responses: Evaluate the performance of different promotional offers and analyze the effectiveness of discounts, coupons and other incentives.
    • Online engagement: Track interactions with your digital campaigns, click-through rates and ad conversion.

This wealth of data offers many opportunities, but it's essential not to lose focus. Focus on the data most relevant to your brand, the data that will enable you to make the best strategic decisions. Here, we'll focus on four types of data frequently used by brands distributing their products in supermarkets.

E-commerce: leveraging online and offline data

The pandemic has prompted consumers to turn to e-commerce, a trend which, although slightly down in 2023, remains robust. In Europe, around 5% of consumers now shop online, while in France this figure rises to 12%, an increase of 7 points compared to 2023.

This represents a significant opportunity to collect valuable data.

If you've set up an e-commerce site, you can also track trends relating to your products or the marketing strategies you've adopted. However, it's important to note that online sales volumes tend to be lower than those in supermarkets and hypermarkets. This information may reveal general trends, but you shouldn't rush into anything without a thorough analysis.

And with good reason: online and offline shopping often differ significantly. For example, supermarkets' online offering is increasingly evolving into a profitable, independent format with a unique value proposition. According to McKinsey, supermarket e-commerce sites are set to grow faster than the overall grocery/retail market over the next few years, including pure-players.

McKinsey also points out that consumers expect different value propositions depending on whether they shop online or offline, as these channels cater to distinct shopping needs. For example, 37% of UK consumers (an increase of two percentage points on 2023) still choose different retailers for their online versus offline purchases, reflecting their channel-specific needs. In addition, UK consumers place more importance on in-store promotions, whereas for online purchases, price takes precedence over promotions.

So, limiting yourself to e-commerce data is not enough to fully meet and satisfy the diverse expectations of consumers, and intrinsically increase your sales.

Panellist data

More specifically, data from retailer panels. Panels are marketing research tools that systematically and continuously collect data from a representative sample of sales outlets. This data is then analyzed and communicated to manufacturers and brands operating in the mass retail sector, not without a financial consideration.

Why is this data of interest to your brand?

This information provides valuable insight into sales, stocks, prices and other aspects of product distribution in supermarket networks. Panellist data will enable you to decipher the overall performance of products sold in supermarkets, track market and sales trends, and assess the effectiveness of marketing and sales strategies.

Data collected by your sales force

The data collected by your sales reps in the field is probably the most crucial source of information for several reasons:

  • Customization: This data is specific to your brand, meeting your business needs and objectives. You can specifically target the data you want to collect on your products and those of your competitors, through price, merchandise or competitor surveys.
  • Exclusivity: This source of information is unique, as it is inaccessible to other players, unlike panel data, for example. Bear in mind, however, that if you collect information on your competitors (such as price or number of facing), your competitors can do so too.
  • Accuracy: Field data enables detailed analysis by point of sale, product or category, offering a granularity that other sources cannot provide.

It's essential to structure the way this information is fed into your crm. This data is generally collected by your area managers, and a data entry error or oversight can quickly occur. To minimize these risks, it's crucial to equip your teams with an adapted CRM system, functional on mobiles and tablets. Such a system must enable them to fill in their shelf-space statements even without an Internet connection, directly in-store. This level of detail and accessibility optimizes the quality and usefulness of the information collected, reinforcing your sales and marketing strategies.

Datasharing

Last but not least, as our British neighbors would say: your sell-out.

Sell-outs are the data that retail outlets collect when consumers pass through the checkout while shopping. It's also known as datasharing, as retailers share this data with brands, but not without a financial consideration or at least prior negotiation.

We've written an article on how to obtain and analyze your sell-outs.

Datasharing analysis enables us to determine which products are selling well, when, and in which stores. This data, a veritable log of store transactions, can be enriched by loyalty card scans, enabling purchases to be linked to specific customers.

Why is this data of interest to your brand?

Sell-out represents actual sales made in-store. It's the most reliable way of knowing the real value of your sales. But beyond that, datasharing offers valuable insights into consumer buying behavior, at a highly granular level of detail. This data also supports your area managers when they're swamped: having this automatic feedback enables them to keep track of sales without the need for systematic site visits.

How can you make the most of your sales data?

There are commercial data and commercial data. We began to see this a little earlier with the data collected in the field by area managers: how can we be sure that the data collected is reliable? We assure you, this is one of DNV's major problems.

If you want to make your data reliable, it's important to simplify the work of your sales forces in the field. Once collected, we advise you to follow a few key principles to make the most of it.

Collaborative data, in full transparency

Beware of silo effects: everyone at the same hierarchical level must have the same level of information. The more data is shared, the better the organization's responsiveness.

If your area managers have easy access to the sales data that can help them, they'll use it in their sales pitches.

The solution with Sidely: Share relevant information via reminders on their agendas and mobile/tablet apps. For example, if your area managers visit a store to sell a pirate promotion, as soon as they open their app, the relevant information should be highlighted on the store card, such as the purpose of the visit, the product involved, as well as sales data from the last promotion for that same product or store.

Our CRM enables collaborative sharing of information (appointments, notes, progress on objectives, contacts...), facilitating day-to-day management and improving your team's performance.

Data control

Data is by its very nature delicate, for two main reasons:

  • Risk of misuse: Data can be complex to interpret. If they're not understood, they won't be useful, and even less so in a sales context where clarity is essential.
  • Data confidentiality: It's not always appropriate to share all data. Too much information can overwhelm your area managers, leaving them lost in a flood of information. It's advisable to keep things concise, and only share information that will be of real use to them.

The solution with Sidely: Use Sidely's rights and roles management to determine who has access to which information. This makes data management safer and more efficient.

Real-time data

For an area manager, access to real-time data is an undeniable asset. This immediacy of information means they can react quickly in the field. And for strategic decision-making, it's just as important for head office to have real-time information from the field.

It's truly a collaborative effort. For example, when an area manager detects a stock shortage in a store, he or she can immediately pass on this information to the logistics team. An order is then placed without delay, and delivery is rapidly organized. Responsiveness is one of the keys to good customer service.

The solution with Sidely: The ability for field sales staff to use Sidely on their mobile, even offline. Our CRM automatically synchronizes, so that information can be transferred from mobile to web, and from field to head office, in real time.

Data traceability

Data are multiplying and are sometimes difficult to interpret. To overcome this problem, data traceability is essential. Where does the data come from? How did it evolve during its life cycle? The answers to these questions are difficult to obtain with human processing alone. Here again, the power of tools is often the answer to the problems encountered.

The solution with Sidely: commercial follow-up accompanies the field workers from the preparation of their tour to their customer relations.

The strength of a unique tool

When it comes to data, you don't want to spread yourself too thin! For this reason, having a single tool is an extremely advantageous solution. There are several advantages to having a centralized, reliable source of data. Indeed, integrating and entering data from numerous points of sale every day will directly facilitate sales decision-making. The competitive advantage is therefore considerable, especially when the data can be easily exploited by all stakeholders.

Trusting your data and sharing it with all those involved in your day-to-day business success is the key to success, especially when uncertainty reigns! Crises are often an opportunity to correct what's not working, and get back on track... And what if Sidely could help you do just that?

How can sales data help your field sales force?

As you can see, data is indispensable... as long as you know how to use it!

How to use data to negotiate more effectively: a practical example

You're a brand that sells fruit-based desserts.

Dessert type Fruity yogurt Compote Fruit dessert
Number of items in store 80 15 120
Market share of your brand by panelist 5 % 17 % 4 %
Number of items that should be in the store 4 2.55 4.8
Number of references in agreements 2 3 5

For this store, your Area Manager has a dual objective:

  • Picking up fruity yogurts. He has 2 references to pick up.
  • Use point-of-sale displays to maximise visibility and boost sales.

Having access to panellist data and your own sales and merchandising data will enable him to negotiate more effectively. Your area manager will therefore negotiate with the floor manager to find the 2 missing references, highlighting :

  • Loss of earnings: if the market share is not respected, in terms of number of products or categories, the store risks selling less. Your area managers can advise the department manager;
  • The added bonus: your area manager can highlight data from other stores in which your fruit yogurts are selling very well. This can be done using a variety of data: your checkouts from other stores, sales volume trends, merch placement analysis...

Your data will also help you to optimize your product assortments in supermarkets or to better sell your promotions.

Le CRM pour tous vos réseaux de distribution
Essayez Sidely gratuitement pendant 15 jours. 
Request a demo
On the floor
Your daily source of sales advice
Sign up now
Ready to conquer the field? 
Request a demo