Reported impact
Business outcome
Hot Topic saved more than $200,000 in one weekend by curbing unprofitable split shipments, empowered more than 1,000 employees with 10x faster queries, and made campaign and merchandising decisions faster with unified omnichannel insight.
- Cost Reduction
- Customer Experience
- Productivity Improvement
- Revenue Growth
Solution
Hot Topic moved customer and product analytics onto Snowflake to create a single source of truth across ecommerce, stores, campaigns, and order fulfillment. Data once split across Epsilon, Oracle Retail Analytics, and manually produced spreadsheets is centralized in Snowflake, giving analysts and leaders one place to query customer 360, sales, inventory, and campaign performance. Robling runs retail analytics on the same foundation to identify fulfillment and order-allocation issues, including unprofitable split shipments created by the order-management stack. The platform also supports executive drill-downs, omnichannel reporting, and AI-assisted product tagging that improves ecommerce searchability. By combining customer and product data in Snowflake and pushing insights directly into merchandising, fulfillment, and leadership workflows, Hot Topic shortened reporting cycles from days to minutes, expanded self-service access, and connected digital and store experiences more tightly.
Data flow
Customer data from Epsilon and product, sales, inventory, and order data from retail systems are centralized in Snowflake. Robling analyzes the curated data to surface fulfillment and profitability issues, and business teams use the resulting insights for merchandising, marketing, and executive decisions.