下载PDF
PopSockets Enhances Profitability and AOV by 25% with Fivetran
技术
- 功能应用 - 企业资源规划系统 (ERP)
- 平台即服务 (PaaS) - 应用开发平台
适用行业
- 消费品
- 零售
适用功能
- 维护
- 销售与市场营销
用例
- 零售店自动化
- 供应链可见性(SCV)
服务
- 云规划/设计/实施服务
挑战
PopSockets 是一家零售和消费品公司,其数据管理和报告流程面临着重大挑战。该公司在电子商务、营销、商业智能、财务、会计、供应链和运营等各个部门之间的报告效率和见解交流方面遇到了困难。缺乏严格的数据更新时间表以及手动汇总报告的繁琐过程阻碍了公司的发展。随着 PopSockets 开始经历巨大的逐年增长并采用 ERP 系统,数据量呈指数级增长。该公司正在努力解决数据孤岛、在单一事实来源中聚合和存储数据的不可扩展的手动工作以及缺乏对营销数据的可见性以了解各种渠道广告支出的投资回报率的问题。 PopSockets 需要一个可扩展的解决方案,使其数据工程师小团队能够构建自动化数据管道,以实现更快的分析和报告。
关于客户
PopSockets 成立于 2014 年,已在 75 个国家销售了超过 2.3 亿个标志性手机手柄,目前拥有不断扩大的相关产品生态系统,包括手机壳、钱包和支架。该公司拥有 250 多名员工,为电子商务、营销、商业智能、财务、会计、供应链和运营等多个部门提供支持。 PopSockets 使用各种来源的数据,包括 Amazon Ads、Klaviyo、SQL Server、Google Ads、Bing Ads、MySql RDS、Google Analytics、Facebook Ads、Snapchat Ads、Pinterest Ads 和 Shopify。该公司的数据存储在Snowflake数据云中,并托管在AWS云平台上。
解决方案
PopSockets 采用现代数据堆栈解决方案 Fivetran 来集中数据并构建模型以获取更深入的见解。 Fivetran 与 Snowflake 和 PopSockets 的 BI 工具相结合,帮助该公司在其他 ERP 系统在全球范围内扩展时支持和统一来自这些系统的数据。它还使该公司能够利用可靠的最新数据自动生成报告,并更有效地评估不同渠道上各个广告活动的效果。 Fivetran 的解决方案是 PopSockets 战略的关键组成部分,该战略旨在通过各种销售渠道和加大付费营销力度来管理其爆炸性增长。该解决方案使该公司能够在全球范围内集中不断增长的 ERP 数据,无需从各个平台手动下载报告并将其汇总以进行分析,从而节省了资源时间,并按 SKU 创建排行榜来显示产品的贡献,而不仅仅是销售额和单位速度,还有盈利能力。
运营影响
数量效益
相关案例.
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Improving Production Line Efficiency with Ethernet Micro RTU Controller
Moxa was asked to provide a connectivity solution for one of the world's leading cosmetics companies. This multinational corporation, with retail presence in 130 countries, 23 global braches, and over 66,000 employees, sought to improve the efficiency of their production process by migrating from manual monitoring to an automatic productivity monitoring system. The production line was being monitored by ABB Real-TPI, a factory information system that offers data collection and analysis to improve plant efficiency. Due to software limitations, the customer needed an OPC server and a corresponding I/O solution to collect data from additional sensor devices for the Real-TPI system. The goal is to enable the factory information system to more thoroughly collect data from every corner of the production line. This will improve its ability to measure Overall Equipment Effectiveness (OEE) and translate into increased production efficiencies. System Requirements • Instant status updates while still consuming minimal bandwidth to relieve strain on limited factory networks • Interoperable with ABB Real-TPI • Small form factor appropriate for deployment where space is scarce • Remote software management and configuration to simplify operations
Case Study
How Sirqul’s IoT Platform is Crafting Carrefour’s New In-Store Experiences
Carrefour Taiwan’s goal is to be completely digital by end of 2018. Out-dated manual methods for analysis and assumptions limited Carrefour’s ability to change the customer experience and were void of real-time decision-making capabilities. Rather than relying solely on sales data, assumptions, and disparate systems, Carrefour Taiwan’s CEO led an initiative to find a connected IoT solution that could give the team the ability to make real-time changes and more informed decisions. Prior to implementing, Carrefour struggled to address their conversion rates and did not have the proper insights into the customer decision-making process nor how to make an immediate impact without losing customer confidence.
Case Study
Digital Retail Security Solutions
Sennco wanted to help its retail customers increase sales and profits by developing an innovative alarm system as opposed to conventional connected alarms that are permanently tethered to display products. These traditional security systems were cumbersome and intrusive to the customer shopping experience. Additionally, they provided no useful data or analytics.