Interview • 01.09.2016

Identifying purchase intentions: market basket analysis for brick-and-mortar retailers

The right software to understand and use data to improve profitability

Bernhard Webler, IRI
Bernhard Webler, IRI
Source: IRI

Neither magic nor a secret: sales receipt data can reveal information about consumer purchase behavior. Online retail already masters this type of analysis perfectly. In contrast, brick-and-mortar retail still needs technical support to understand collected purchase data.

Bernhard Webler, Business Development Manager at IRI Information Resources, talked with us about the possibility of processing sales receipt data by using software, so retailers are able to use this information to plan their product portfolio.

Mr. Webler, are most brick-and-mortar retailers aware of the possibilities market basket analysis provides to find out more about the purchase behavior of their customers?

Retailers are generally informed about the possibilities this data offers. Every retailer also consistently tries to determine which products are purchased in combination with others. Analyses such as cross-selling activities, for instance, are not continuously factored into the decisions of retailers. If anything, this only happens sporadically.

Why do you think this is?

That’s probably due to the additional effort it takes to define the right criteria to mine this data and the lack of experience in interpreting the results. Most retailers shy away from dealing with the large amounts of unfiltered data available at their disposal. That’s why from today’s point of view, a systematic integration of customer expectations into the retailer’s daily decisions and process optimization measures has not even begun yet.

Things are very different in the online retail sector …

Unlike brick-and-mortar businesses, online retailers have tried right from the start to sensibly integrate the extremely large amounts of purchase data into the interaction with the customer. Here, online retail partially relies on highly complex analyses. The results are systematically applied to understand customer expectations based on a time and product dimension and to include these results in the decision-making and supply chain processes.

Which information contains the market basket at first side?...
Which information contains the market basket at first side?
Source: IRI

Your solution is designed to make it easier for brick-and-mortar retailers to structure the vast amounts of collected sales receipt data and to interpret the results. What is your approach?

Our approach utilizes the complex correlations between products. They are used to develop customized guidance and navigation assistance- similar to a map - for retailers so that typical customer purchase intentions that were identified based on clustering algorithms can be viewed with the relevant detailed characteristics. The starting point for this analysis is the fact that customers fill their baskets based on their purchase intention with an explicit product selection during their shopping trip.

What market basket data can be utilized for this?

Our statistical method can allocate a concrete purchase intention to every market basket that contains more than one product. All of the market baskets from the past 24 months are being reflected here, even those without loyalty card identification. Clustering typically defines up to 20 explicit purchase intentions, of which every intention contains information about the date and scope of the underlying market baskets.

What’s your main focus in data clustering?

It’s extremely important to us for the retailer we collaborate with to be involved in the clustering process and definition of customer purchase intentions right from the start. This is the only way to ensure the retailer is able to, later on, take advantage of these results that subsequently can positively influence the planning of sales promotion campaigns, product portfolio, and regional offerings.

The major difference compared to previous sales data analyses is that the data is specifically filtered for the information that’s relevant to the respective retailer. What concrete information does a retailer obtain from this?

Customer groups such as “savers“ or “single-person households” for example are clearly identified based on the size of the sales receipt, spending amount, the represented product group and similar aspects. Based on these purchase intentions, a subsequent analysis provides the opportunity to assign individual characteristics to every store. This gives the retailer concrete suggestions to adapt stores to local customer expectations in a targeted manner, thereby further improving customer retention.

You believe suppliers are also able to benefit from these results.

Yes. Suppliers show enormous interest in information based on sales receipt data. When it comes to strategic product positioning, it provides the necessary information to better adapt sales promotion campaigns to customer groups and reconcile the required logistics processes to ensure prompt delivery with the retailer. In doing so, sales receipt data is able to help in avoiding gaps in logistics on a more customized level at the respective store.

Author: Natascha Mörs; iXtenso

related articles:

popular articles:

Thumbnail-Photo: Door-to-door delivery and returns service
13.08.2020   #online trading #fashion

Door-to-door delivery and returns service

Asda trials George parcel returns via home shopping deliveries

Starting last week, Asda has launched a two-store trial allowing customers to conveniently return George parcels at the same time as they receive their weekly shop.Customers in York and Milton Keynes can now return George online purchases for free ...

Thumbnail-Photo: Same-day delivery from 76 Costco warehouses across Canada...
03.08.2020   #food retail #delivery

Same-day delivery from 76 Costco warehouses across Canada

Partnership between Instacart and Costco

Instacart and Costco announced the companies have partnered to launch same-day delivery from 76 Costco warehouses across Canada. Following a successful two-month pilot in select Ontario warehouses, the nationwide collaboration brings Costco's ...

Thumbnail-Photo: Outdated last-mile delivery technology
07.07.2020   #logistic solutions #mobile computing

Outdated last-mile delivery technology

Transportation and logistics companies losing customers

Transportation and logistics (T&L) companies are losing customers and missing opportunities to expand their business due to outdated last-mile delivery technology, according to a new global research report by SOTI, which looks at the ...

Thumbnail-Photo: Delivery services: consumer and climate benefits...
14.08.2020   #e-commerce #customer satisfaction

Delivery services: consumer and climate benefits

Sustainable logistics solutions for last mile delivery

Convenient, fast, and affordable. By now, "sustainable" has also been added to the list of what makes for the perfect online ordering process. That’s why retailers and delivery services must rethink their ...

Thumbnail-Photo: Electronic bill of lading solutions to enhance safety and efficiency...
02.07.2020   #supply chain management #coronavirus

Electronic bill of lading solutions to enhance safety and efficiency

Consumer Brands spearheads contactless delivery task force

The Consumer Brands Association announced that it has brought together 23 consumer packaged goods (CPG) companies and retailers to launch a new task force that will study the impact of a contactless pick-up and delivery protocol to create greater ...

Thumbnail-Photo: Millennials averaged 50% more online deliveries than baby boomers …...
22.07.2020   #online trading #e-commerce

Millennials averaged 50% more online deliveries than baby boomers …

… even though millennials favor eco-friendly choices

Millennials have become online “super buyers” during the COVID-19 lockdown and are receiving an average of 50 per cent more deliveries every week than the over-55 “baby boomer” generation, a new survey of 2,000 consumers has ...

Thumbnail-Photo: Online retailers need to better inform customers about the status of...
21.07.2020   #online trading #e-commerce

Online retailers need to better inform customers about the status of their orders

E-Commerce Shipping Study 2020 by parcelLab

parcelLab has analysed for the second time the shipping services of 100 of the largest German online shops (according to EHI). The results show that 1 in 4 retailers in Germany only send a single email to their customers after their checkout. This ...

Thumbnail-Photo: Getting a taste for grocery deliveries
14.08.2020   #e-commerce #customer satisfaction

Getting a taste for grocery deliveries

What are the best online grocery delivery options?

Bread, cucumbers, tomatoes, pasta, butter ... Brick-and-mortar stores are no longer the only place where consumers turn to for their groceries. The COVID-19 crisis has spurred a boom in food delivery services. So how do groceries end up in your ...

Thumbnail-Photo: Key elements of successful supply chain management...
15.07.2020   #personnel management #logistic systems

Key elements of successful supply chain management

5 tips to optimize your supply chain and mitigate risk

A chain consists of many small individual links and only works as a whole when these links connect effectively. After all, a chain is only as strong as its weakest link. The same principle applies to supply chains. What are the best practices for ...

Thumbnail-Photo: Could drones deliver packages more efficiently by hopping on the bus?...
29.06.2020   #logistics #delivery

Could drones deliver packages more efficiently by hopping on the bus?

Aerial transport could take load off city streets – provided drones a ride

One-click purchases and instant delivery have helped fuel the growth of e-commerce, but this convenience has come at the cost of increased traffic congestion, longer commute times, and strained urban communities. A 2018 report from Texas A&M ...