How Ecommerce Analysts Can Prep for the Holiday Season

“It’s the most wonderful time of the year,” sang Andy Williams about the Christmas season, but a “wonderful time” might not be how analysts working in e-commerce and retail see the incredibly busy and stressful season. 

According to the National Retail Federation “Overall, holiday sales represent about 20 percent of annual retail sales each year, but the figure can be higher for some retailers. Hobby, toy and game stores report the highest share at about 30 percent.” 

In addition, because holidays sales don’t come with a corresponding increase in fixed costs, they can be much more profitable for retailers. And given the sheer volume of purchasing during that two month period, a lot is on the line when Santa comes calling.

The stress is even higher this year, as shopping and cheer are on the rise after an interesting couple of years, and as I explain below, a data warehouse with strong data strategy can be the foundation for powerful customer experience initiatives and demand forecasting models that will make any retailer more profitable.

A shift to online

The pandemic-induced shift to online shopping looks like it might be here to stay. Now, shoppers would rather stay home out of convenience rather than spending hours of their day driving to a shopping mall, circling parking lots while trying to find an empty parking slot, fighting with other shoppers over coveted toys, or trying to keep sane around a thousand strangers as little Jimmy goes off on one of his temper tantrums. 

The shorter-term Covid adjustments created a long-term trend that radically altered the e-commerce and retail landscape. 

Getting your data house in order

In their article "Getting Your Data House In Order," McKinsey & Company state, “Whatever one’s business, the realities of today’s marketplace mean that those with the best data systems and capabilities will win—and by an increasingly outsize margin.” 

But how do retailers build powerful data systems when their data warehouse is a jumble of various software products that do a variety of different things, including data mining, business intelligence, data virtualization, ETL work, digital marketing, and analytics? 

It starts with a shared strategy around your company’s data, one that goes beyond the analyst team (or a team’s analyst) so that everyone from Marketing to Finance knows which data to collect, why it’s being collected, and what it means. Taking the time to establish these “ground rules” yields crucial benefits to an organization, including: 

  • A common understanding of data, which helps users throughout the organization utilize it better.
  • Improved data quality, which makes the data more usable in general. 
  • A clear sense of what can be done with the data, from getting a 360-degree view of customers to protecting sensitive information.

Once the data has been quantified, tagged, and visualized, trends hidden within that data will be revealed. You won’t just gain important operational insight, but key customer insights that can shape holiday strategy from messaging to outreach.

Holiday season prep e-commerce analysts can do now 

Along with establishing a data strategy, retail analysts can get ahead of the holiday season by laying the groundwork for key metrics now. Robust customer segmentation, Recency Frequency Monetary (RFM), propensity to respond, lookalike audiences, A/B testing, and customer churn modeling can help e-commerce companies glean information from their data sets that will help make the busy holiday season a success. 

Customer intelligence

A deep dive analysis of current customer attributes can provide demographic and psychographic detail that could be used to target new customers. This is also incredibly useful in lookalike modeling, which can be done on platforms like Facebook, LinkedIn, Twitter, Instagram, among others. 

Likewise, RFM models allow retailers to get a deep understanding of who their best, worst, and most frequent customers are. This enables brands to focus their marketing and outreach on their most valuable customers and to make promotions count by targeting audiences that are most likely to spend. 

A propensity to respond model reveals how likely a person receiving a marketing offer will be to use that offer. For retailers who rely on direct mail, these models can reduce costs by identifying customers who are most likely to respond to a retailer’s offer. After segmenting out people who are unlikely to respond to an offer, the business can then focus only on those who are most likely to take up the offer, saving substantial money in the process. 

Churn prediction and prevention

In his article Smart Strategies Require Smarter KPIs, Michael Schrage argues just reducing customer churn is no longer good enough—companies now need to focus on “learning from churning” as a means of predicting and actively preventing customer loss.

Schrage suggests that, “Distinctions must be drawn between churn presumed (a customer who simply stops engaging, that is, no more visits, purchases, etc.) versus churn absolute (the customer who explicitly closes an account or discontinues a service).” 

For example, a customer who’s had a bad experience will need to be addressed differently than a customer who’s being wooed away by a competitor’s products. By figuring out why a customer might move on, retailers can create relevant save or win-back strategies.

Demand forecasting 

In his article Cross-Channel Predictive Analytics for Retail Distribution Decisions, James B. Coles notes that fashion products have short lifecycles with notoriously volatile demand, with items going from introduction through sold out and discontinued in as little as four weeks. “With such short lifetimes, it is critical to distribute inventory as accurately as possible to ensure maximum satisfaction of customer demand,” argues Coles.

Whereas many companies might see this rapid turnover as a curse, Zara sees it as a competitive advantage because constantly updated stock motivates customers to return once every two weeks to see what’s new. But meeting demand would be impossible without a strong data program underpinned by a powerful analytical solution that crunches all these inventory, customer intelligence, and demand forecasting numbers. 

In fact, Zara is famous for creating quick and accurate demand forecasts focused on periods of just 3-4 days. That enables the fast-fashion brand to keep every store stocked while avoiding costly inventory overruns at any one location.

While many—ok, most—retailers aren’t in a position to create this kind of fine-tuned forecasting, creating demand models that take the realities of their organization into account could be helpful in sustaining customer interest throughout the holiday shopping season that seems to be getting longer and longer each year.


A deep dive forensics into last year’s sales and marketing campaigns is a worthwhile endeavor to do before you hang your stockings. There’s no reason to wait until January to make improvements that might increase sales during the most important period.

If retailers can get their data house in order, the analytics ROI will follow. And Black Friday, Cyber Monday, Singles Day in China, Boxing Day in England and Australia, and New Year’s Day everywhere will be something for retailers to celebrate as they recognize that the holiday season might just be analysts’s most wonderful time of the year.

Get a free consultation with a data architect to see how to build a data warehouse in minutes.
Request Demo
Read more in:
Share this post:

Work smarter, better, and faster with monthly tips and how-tos.