Walmart Canada was established in 1994 and has grown to more than 400 locations, serving over 1.2 million customers daily. Its online store, walmart.ca, draws 600,000 customers daily. And with more than 95,000 associates, Walmart Canada is one of Canada’s largest employers and ranks among the most influential brands.
Before launching a nationwide online grocery business, Walmart Canada wanted to better understand the shoppers who had been using the service in test markets, so they could extrapolate and apply the results to other markets. For such a major project, the retailer wanted to anticipate their customers’ behavior and predict sales from the new service at an individual store level. The analysis needed to be grounded in data so that executives would be confident in their decision to expand the online grocery program and the major investment it entailed. In particular, Walmart Canada wanted to know if there were any common demographics, behaviors, lifestyles and attitudes exhibited by online grocery shoppers in both the test markets and markets across Canada.
Drawing on the PRIZM segmentation system, analysts examined the behavior of Walmart’s online grocery customers in its test market stores over an eight-month period. After linking lifestyle and transactional data to consumers’ postal codes, researchers identified the best performing lifestyle segments, their demographic profile, preferred purchase categories and level of loyalty.
An innovative machine learning model was developed that identified a unique combination of five variables—from more than 70 that were evaluated—that proved effective in predicting online grocery order volume at the individual store level. The analysis indicated that Walmart’s most loyal and frequent online shoppers tended to be higher income, diverse and living in urban and suburban communities.
Walmart then prioritized the roll-out of the new service according to the lifestyles and demographics of each store location’s customer base. In addition, marketers used insights from the analysis to develop more targeted messaging for print media campaigns.
Walmart Canada’s online grocery expansion was a strategic and financial success, with annual sales exceeding the company goal by more than 40 percent. Building on this initial achievement, Walmart started expanding the program to more cities. At the same time, executives are using customer segmentation insights from the project to refine offerings beyond online grocery and to optimize day-to-day marketing. Analysts now examine online sales by PRIZM segment daily and integrate the results into the company’s CRM database for email marketing and customer profiling.