Tag Archives: associate optimization

A Peek Into the Future of Store Analytics

We just did our first non-incremental release of the DM1 store analytics platform since we brought it to market. It brings new analytics views to the Workbench, a host of UI and analytic tweaks, new cloud options and, best of all, real-time and full-store playback functionality to the product. Real-time creates a bevy of opportunities to operationalize measurement in both operations and marketing. So DM1 can drive more value, faster. What’s next? At the end of my last post, I described some of the juicier features slated for upcoming release: a real-time, dedicated Store Managers console, full pathing and even some machine learning applications. But I want to step back from a feature list and talk a bit about where we see the DM1 platform headed and how we try to balance and prioritize new functionality as we shape the product. It’s hard to do because we love all the new features.

From a personal perspective, no part of building Digital Mortar is more interesting or more intellectually challenging than building DM1. On the one hand, building SaaS systems in the cloud today is incredibly gratifying. You can build powerful, beautiful stuff so much faster and easier than back in the ‘80s when I first started programming or even in the late ‘90s when Semphonic took an abortive shot at building a web analytics tool. But an embarrassment of riches is still an embarrassment. Throwing stuff at a wall doesn’t make for a coherent product road-map. So when we think about new feature prioritization for DM1, we start with our core product vision.

DM1 is designed to be the measurement backbone of the store. We see the store as a learning machine with the core methodologies we brought from digital: continuous improvement through test & measure driven by analytics based on behavioral segmentation (what people actually do) and the ability to break-down shopper journeys into discrete, analyzable steps.

That core vision shaped our initial DM1 release (what Valley folks love to call the MVP – an acronym that is surely designed to suggest the sporting world’s Most Valuable Player award but actually stands for Minimally Viable Product). When DM1 went live, just about every piece of it was specifically targeted to this core vision. It provided direct access to a bunch of journey metrics that described how the store performed, it included basic shopper segmentation to analyze cross-sell patterns and do simple day-time parting, and it included a pretty robust funnel tool for breaking down shopper journeys into individual (step) components.

Let’s call this basic shopper-journey, store measurement system DM1’s core. It’s the engine that drives and integrates every other aspect of what the product might eventually do. Coming out of the digital analytics world, we tend to map a lot of our thinking into that model. The DM1 core is the equivalent of Adobe Analytics in the broader Adobe Marketing Suite. It’s the analytic and measurement engine.

Right now, most of our focus will continue to be on building that core engine.

Of the significant features we have slated for short term development, here are the ones that contribute directly to the core function of the program:

New and More Comprehensive Associate Reporting: Track individual and team performance on the floor with optional integration to VoE, employee meta-data, and VoC from in-store visits. DM1 already includes a lot of generalized Associate analytics, but this report will distill that into a set of reports that are much easier to digest, understand and act on.

D3 Integration: DM1’s current charting capabilities are pretty basic. We use an off-the-self package and we provide straightforward bar and line charting. Probably the best part of the charting is how seamlessly DM1 picks the best chart types, intelligently maps to separate axes, and lets you easily combined “like indices” in a single chart. But we’re far from pushing the envelope on what we can do visually and by using D3 for our charting package, we’ll be able to considerably expand the range of our visualizations and support even deeper on-chart customization.

Full Pathing: We’ve been tinkering since day 1 with ways to bring full pathing to store analytics. On the one hands, it’s not really all that hard. The amount of data is much less than we’re used to in digital. Our engine passes the data exhaustively with every query, so full pathing isn’t going to strain us from a performance perspective. But stores don’t have discrete waypoint like pages on a Website which makes each shopper’s path potentially a snowflake. We’ve tried various strategies to meaningfully aggregate paths within the store and I think we’ll be able to produce something that’s genuinely interesting and useful in the next few months. This will supplement the funnel analytics and provide richer and more varied analysis of how shoppers flow through the store.

Segmentation Builder: DM1’s current segmentation capabilities are limited to basic filtering on a set of pre-defined types. It does provide a pretty nice ability to segment on uploaded meta-data, but you can’t build more complex segments using Boolean logic or Regex. Not only do I think that’s important for a lot of analytic purposes, it’s also something we can support fairly easily.

Machine Learning for Segmentation: On that same theme, I’m a believer in data-driven segmentation. Data-driven segmentation uses more data, is richer, more reflective of reality, and usually more interesting than rule-based segmentations even if produced in a fairly rich builder. Both GCP and Azure offer pretty amazing ML capabilities that will allow us to build out a good data-driven segmentation capability for DM1. I think the harder part is doing the UI justice.

Store Groups: DM1 handles lots of stores, but right now, the store is the ultimate unit of analysis. We don’t support regions or fleet-wide aggregations. There are a lot of analytic and reporting problems that would be solved or made much easier with Store Groups. It’s a capability we’ve considered since Day 1 and sooner rather later I except it to be in the product.

Fully Integrated Dashboard: V2 didn’t do much to evolve the dashboard capability of the product, but we have a pretty clear direction in mind. In the next release, I expect the Dashboard to be capable of containing ANY Workbench view. That’s a simple elegant way to let analysts customize the dashboard to their taste and produce exactly what they need for the business. I remember a computer scientist from the original deep-blue chess program saying something to the effect that “Exhaustive search means never having to say your sorry”. No matter how much capability we build out in the dashboard, analysts are always going to want something from the Workbench if it does more. So I think it just makes sense to unify them and let the Dashboard do EVERYTHING the Workbench does.

Not everything we have in mind is about the core though. In the next few months, we plan to release a Store Manager Console based on the new real-time capabilities. The Store Manager Console is a whole new companion capability for DM1 targeted to a fundamentally different type of user. DM1 core is for the corporate analyst. It’s a big, powerful enterprise measurement tool. It’s definitely more than most Store Managers could handle.

But while the centralized model works really well in digital analytics (since Websites are wholly centralized), it’s less than ideal in the store world. There are a lot of decisions that need to happen locally. DM1’s Store Manager console will continuously monitor the store. It will keep track of shopper patterns, monitor queue times, alert if shoppers aren’t getting the help they need, and make it easy for Store Managers to allocate staff most effectively and message them when plans need to change.

It’s a way to bring machine smarts and continuous attention to the Store Managers iPad. Most of the capabilities we’re baking into the Store Manager Console (SMC) were actually delivered in V2. The real-time store tracking, simulator and Webhooks for messaging are the core capabilities we needed to deliver the SMC and were always a part of that larger vision.

As I hope our rate of progress has already made clear, we’re ambitious. Software design usually embodies deep trade-offs between functionality and ease-of-use or performance. Those trade-offs are challenging but not inevitable. We’ve seen how digital analytics tools like Google Analytics and data viz tools like Tableau have sometimes been able to step outside existing paradigms to deliver more functionality side-by-side with better usability. Most of what we’ve done so far in DM1 is borrow creatively from two decades worth of increasing maturity in digital analytics. Still, tools like our Funnel Viz and – particularly – our Store Layout Viz have tackled location/store specific problems and genuinely advanced the state-of-the-art. As we tackle pathing and machine learning, I hope to do quite a bit more of that and find ways to bring more advanced analytics to the table even while making DM1 easier to use.

An Easy Introduction to In-Store Measurement and Retail Analytics with DM1

My last post made the case that investing in store measurement and location analytics is a good move from a career perspective. The reward? Becoming a leader in a discipline that’s poised to grow dramatically. The risk? Ending up with a skill set that isn’t much in demand. For most people, though, risk/reward is only part of the equation. There are people who will expend the years and the effort to become a lawyer even without liking the law – simply on the basis of its economic return. I’m not a fan of that kind of thinking. To me, it undervalues human time and overvalues the impact of incremental prosperity. So my last and most important argument was simple: in-store measurement and location analytics is fun and interesting.

But there’s not a ton of ways you can figure out if in-store measurement is your cup of tea are there?

So I put together another video using our DM1 platform that’s designed to give folks a quick introduction to basic in-store measurement.

It’s a straightforward, short (3 minute) introduction to basic concepts in store-tracking with DM1 – using just the Store Layout tool.

The video walks through three core tasks for in-store measurement: understanding what customer’s do in-store, evaluating how well the store itself performed, and drilling into at least one aspect of performance drivers with a look at Associate interactions.

The first section walks through a series of basic metrics in store location analytics. Starting with where shoppers went, it shows increasingly sophisticated views that cover what drew shoppers into the store, how much time shoppers spend in different areas, and which parts of the store shoppers engaged with most often:

retail analytics: measuring store efficiency and conversion with DM1

The next section focuses on measures of store efficiency and conversion. It shows how you can track basic conversion metrics, analyze how proximity to the cash-wrap drives impulse conversion, and analyze unsuccessful visits in terms of exit and bounce points.

DM1 Layout Overview Video

Going from what to why is probably the hardest task in behavioral analytics. And in the 3rd section, I do a quick dive into a set of Associate metrics to show how they can help that journey along. Understanding where associates ARE relative to shoppers (this is where the geo-spatial element is critical), when and where Associates create lift, and whether your deployment of Associates is optimized for creating lift can be a powerful part of explaining shopper success.

retail analytics with dm1 - analyzing associate performance, STARs and lift with DM!

The whole video is super-quick (just 3 minutes in total) and unlike most of what I’ve done in the past, it doesn’t require audio. There’s a brief audio introduction (about 15 seconds) but for the rest, the screen annotations should give you a pretty good sense of what’s going on if you prefer to view videos in quiet mode.

I know you’re not going to learn in-store measurement in 3 minutes. And this is just a tiny fraction of the analytic capability in a product like DM1. It’s more of an amuse bouche – a little taste –  to see if you find something enjoyable and interesting.

I’m going to be working through a series of videos intended to serve that purpose (and also provide instructional content for new DM1 users). As part of that, I’m working on a broader overview right now that will show-off more of the tools available. Then I’m going to work on building a library of instructional vids for each part of DM1 – from configuring a store to creating and using metadata (like store events) to a deep-dive into funnel-analytics.

I’d love to hear what you think about this initial effort!

Check it out:

Using In-Store Customer Journey Data: Associate Optimzation

If store layout/merchandising and promotion planning are the core applications for in-store customer journey measurement, staff optimization is their neglected and genius offspring. For most retail stores, labor costs are a huge part of overall operating expenses – typically around 15% of sales. And staff interactions are profoundly determinate of customer satisfaction. In countless analytic efforts around customer satisfaction and churn, the one constant driver of both is the quality of associate interactions. People matter.

The human factor is a huge part of the customer journey. Some in-store measurement solutions treat staff interactions the way digital solutions treat employee visits – as data to be culled out and discarded. The only thing worse is when they leave them in and don’t differentiate between customer and staff!

No part of the customer journey and no part of the store has a bigger impact on the journey, on the sale, and on the brand satisfaction than interactions with your sales associates. And, of course, labor costs are one of the biggest cost drivers at the store. So optimizing staff is critical on every front: revenue optimization, customer satisfaction and cost management. It’s rare that a single point of analysis drives across all three with so much impact, highlighting how important associate optimization really is.

With staff data integrated into customer journey measurement, you know how often associate interactions occurred, you know how long they lasted, and you know how often they resulted in sales. Some stores will already track at least some of this as part of their incentive programs, but customer journey data provides a true measure of opportunity and productivity. Some of these data points are straightforward, but there are interesting aspects to staffing data that go beyond basic conversion effectiveness. It’s possible, for example, to isolate the number and impact of cases where staff interactions should have happened but didn’t. It’s also possible to understand optimal contact strategies, answering questions like ‘how long should a customer be in a section before a contact becomes desirable or imperative? ‘  Even more interesting is the opportunity to bring sports-driven team and player metrics to bear on the problems of staffing. You can understand which associate combinations work best together, how valuable team cohesion is, and the value spread between a top associate and an average hire. This is all invaluable data when it comes time to plan out schedules and staffing levels and, when paired with weather data, can also be used to optimized staffing plans on a highly local basis.

Finally, there are deep opportunities to use this data to optimize broader aspects of staff optimization. By integrating Voice of Employee (VoE) data with associate effectiveness, you can hone in on the golden questions that will help you identify the best possible hires. Creating a measurement-driven, closed loop system to optimize associate hiring decisions isn’t what people generally think of when they evaluate in-store measurement. But it’s a unique and powerful use of the technology to drive competitive advantage.

 

Questions you can Answer

  • Are there days/times when a store is over/under staffed?
  • Are there better options of positioning staff?
  • What’s the best way to optimize staffing teams and placements?
  • How much does training impact staff performance?
  • What questions should I ask when I hire new staff to identify potential stars?
  • How successful is any given associate in converting opportunities?
  • What’s the right amount of dwell-time to allow a customer prior to an associate interaction?

To find out more about retail analytics and in-store customer journey tracking, check out my new company’s site: DigitalMortar.com