{"id":5060,"date":"2024-03-07T14:59:47","date_gmt":"2024-03-07T14:59:47","guid":{"rendered":"https:\/\/staging.elixirrdigital.com\/us\/?post_type=case_study&p=5060"},"modified":"2026-03-16T10:38:01","modified_gmt":"2026-03-16T10:38:01","slug":"major-merchandise-retailer","status":"publish","type":"case_study","link":"https:\/\/staging.elixirrdigital.com\/us\/case-studies\/major-merchandise-retailer\/","title":{"rendered":"Unlocking customer insights through clickstream data for a major retailer"},"content":{"rendered":"\n
\n
\n
\n
\n Back to Case Studies<\/a> <\/div>\n

\n Case Study<\/p>

\n Major Merchandise Retailer<\/h1> <\/div>\n
\n
\n

Online customer behavior data made valuable that resulted in more clicks and leads.<\/p>\n <\/div>\n <\/div>\n<\/div>\n <\/div>\n <\/section>\n\n\n\n\n\n

\n
\n

About the brand<\/h2>\n

The Major Merchandise Retailer operates a nationwide chain of retail stores. The Company, through its retail stores, sells a wide assortment of merchandise principally including domestic merchandise and home furnishings, as well as food, giftware, health and beauty care items, and infant and toddler merchandise.<\/p>\n

The challenge<\/h2>\n

The Major Merchandise Retailer kicked off two big-data initiatives. The first business case was to bring in clickstream Omniture data from Adobe into the data warehouse so that the customer analytics team could understand online behavior tied to their website. In the existing state, the data was sent on request by Adobe which led to long delays in data acquisition. Secondly, the warehouse team required a platform to house low latency and seldom queried data that was clogging up their existing Netezza and Teradata systems.<\/p>\n

The solution<\/h2>\n

Elixirr Digital architected a solution to build out a Hortonworks Hadoop cluster to serve as a data lake and ingestion platform for incoming enterprise data. Hive was utilized to store daily clickstream data which was then parsed and sent to Netezza. Using Netezza UDFs, the clickstream data was further parsed into data that could be tied to customer activity around college searches, product and event lists, and visitor keywords. Further, Hadoop\u2019s HDFS was leveraged as an archival location for the data that was no longer required to exist on Teradata and Netezza.<\/p>\n

The results<\/h2>\n

Leveraging Hadoop, Major Domestic Merchandise Retailer enabled the ability to analyze clickstream data as well as laid the groundwork for a cheap storage alternative in the form of a data lake.<\/p>\n <\/div>\n <\/div>\n<\/section>\n\n\n\n

\n
\n
\n Unlocking real-time data insights for Houston Airport <\/div>\n Previous<\/a> <\/div>\n
\n Next<\/a>
\n Building a scalable global data platform for iRobot <\/div>\n <\/div>\n <\/div>\n
\n See all case studies<\/a> <\/div>\n<\/section>\n\n\n \n
\n
\n
\n

\n Related case studies<\/h2> <\/div>\n
\n
\n View all case studies<\/a> <\/div>\n <\/div>\n<\/div>\n
\n
\n
\n
\n
\n \"\" <\/div>\n
\n
\n

\n Case Study <\/p>\n \n

\n Driving 45% of traffic through organic search for a B2B events agency\n <\/h2>\n <\/a> <\/div>\n
\n
\n Generating monthly inbound lead growth through SEO-led website redesign. <\/div>\n
\n
\n
\n Content Strategy <\/div>\n
\n SEO <\/div>\n
\n User Experience <\/div>\n
\n UX Design <\/div>\n
\n Website Migration <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/article>\n <\/div>\n
\n
\n
\n \"\" <\/div>\n
\n
\n

\n Case Study <\/p>\n \n

\n Turning complex global content into a governed, scalable system\u00a0\n <\/h2>\n <\/a> <\/div>\n
\n
\n Establishing a streamlined process for high-quality content creation and governance. <\/div>\n
\n
\n
\n Standards & Certification <\/div>\n |<\/span>\n
\n Content Marketing <\/div>\n
\n Digital Strategy <\/div>\n
\n User Experience <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/article>\n <\/div>\n
\n
\n
\n \"A <\/div>\n
\n
\n

\n Case Study <\/p>\n \n

\n Creating a faster, more intuitive search experience for Bidwells users\n <\/h2>\n <\/a> <\/div>\n
\n
\n Redesigning search and listings pages to create a smoother, more intuitive user experience. <\/div>\n
\n
\n
\n User Experience <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/article>\n <\/div>\n <\/div>\n
\n
\n \n\n\n<\/g>\n<\/svg>\n <\/div>\n
<\/div>\n
\n \n\n\n<\/g>\n<\/svg>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/section>\n\n\n \n
\n
\n
\n
\n
\n

\n Featured Service<\/p>

\n UX Research & Analysis<\/h3> <\/div>\n
\n
\n

Gain deep user insights to refine design, usability, and engagement.<\/p>\n <\/div>\n

\n UX Research & Analysis<\/a> <\/div>\n <\/div>\n<\/div>\n <\/article>\n
\n
\n
\n

\n Featured Service<\/p>

\n Website Design<\/h3> <\/div>\n
\n
\n

Develop stunning, user-friendly websites that align with business goals.<\/p>\n <\/div>\n

\n Website Design<\/a> <\/div>\n <\/div>\n<\/div>\n <\/article>\n <\/div>\n <\/div>\n <\/section>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":6,"featured_media":0,"template":"","related_service":[49,48],"related_industry":[154],"class_list":["post-5060","case_study","type-case_study","status-publish","hentry"],"acf":[],"card":"
\n
\n
\n

\n Featured Case study <\/p>\n \n

\n Unlocking customer insights through clickstream data for a major retailer\n <\/h2>\n <\/a> <\/div>\n
\n
\n
\n
\n Retail <\/div>\n |<\/span>\n
\n Data and Analytics <\/div>\n
\n IT Services <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/article>\n","_links":{"self":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/case_study\/5060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/case_study"}],"about":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/types\/case_study"}],"author":[{"embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/users\/6"}],"wp:attachment":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/media?parent=5060"}],"wp:term":[{"taxonomy":"related_service","embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/related_service?post=5060"},{"taxonomy":"related_industry","embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/related_industry?post=5060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}