PopSockets doubles profitability, boosts AOV by 25% with Fivetran

Company size
0-499
Region
North America
Industry
Retail & CPG
Key results
  • 2x increase in daily profitability from ad spend
  • 25% increase in Average Order Value (AOV)
  • Saved at least 1 headcount by eliminating manual tasks of a traditional data engineering role
“Fivetran has been able to replace the role of one full-time data engineer. With Fivetran, our team of data analysts can now focus on tasks that are more valuable to the business rather than just massaging the data and making sure it’s in the warehouse.”
— Kyle Chu, Sr. Business Intelligence Analyst at Popsockets

Founded in 2014, PopSockets has sold over 230 million of its iconic phone grips in 75 countries and now has an expanding ecosystem of related products, including phone cases, wallets and mounts.

Before Fivetran

Prior to Fivetran, PopSockets was struggling with reporting efficiencies and communicating insights cross-functionally. There were no strict timelines on when data would be refreshed and the team was enduring the tedious process of manually aggregating reports. As the company began to experience tremendous year-over-year growth and adopted an ERP system, the volume of data grew exponentially. PopSockets was looking for a scalable solution that would allow its small but mighty team of data engineers to build automated data pipelines for faster analytics and reporting. This led to the adoption of the modern data stack consisting of Fivetran and Snowflake.

Negative consequences

“In the past, we operated in silos. There was no real notion of data pipelines and of a centralized data warehouse to store data. We were manually pulling reports from various systems and platforms, and then trying to aggregate the data for meetings and company wide presentations.” — Kyle Chu, Sr. Business Intelligence Analyst at Popsockets

  • Struggling with data silos
  • Tedious and unscalable manual efforts to aggregate and store data in a single source of truth
  • Lacking visibility into marketing data to understand ROI of ad spend on various channels

Fivetran solution

As the company experienced explosive growth through various sales channels and increased its paid marketing efforts, Fivetran became a key solution in helping them centralize data and build models to uncover deeper insights — without having to grow its engineering team. When coupling Fivetran and Snowflake with their BI tool, PopSockets has been able to: 

  • Support and unify data from additional ERP systems as they scale across the world
  • Automate reports with reliable and up-to-date data 
  • Assess performance of individual ad campaigns on different channels more effectively

Outcomes

“By combining data across Salesforce Commerce Cloud, our ERP system and all ad platforms [with Fivetran], we've built a model that allows us to diagnose daily profitability and quickly shift spend across product categories and strategic initiatives. Layering in our COGS and fulfillment rates empowers us to understand true profitability, especially across product lines.” 
— Kyle Chu, Sr. Business Intelligence Analyst at Popsockets
  • Doubled daily ROAS
  • Increased AOV by 25%
  • Product segmentation - By pulling in ERP data, create leaderboards by SKU to show what products are contributing to not just sales and unit velocity, but also profitability 
  • Saved hours of resources by no longer having to manually download reports from various platforms and aggregate for analyses
  • Centralized growing ERP data as PopSockets scales worldwide 

Future roadmap:

  • Join ecommerce data and Klaviyo data to help segment customers and develop tailored marketing initiatives
  • Create a holistic view of product performance on Amazon by combining data from various Amazon ad channels and with Amazon Vendor central to see how products are influenced by ad spend on different channels 
  • Leverage a modern data stack to help with AI/ML by aggregating data to understand purchase behavior of different products in different regions

Required capabilities

  • Cloud-based modern data stack
  • User-friendly, low code application 
  • Access to broad range of SaaS based data sources
  • Plug-and-play solution that was both low maintenance and quickly implemented.
  • Adjustable data sync frequencies 

[CTA_MODULE]

The total economic impact of Fivetran

Learn how automated data movement boosts productivity and accelerates insights for your business.

Download the report
Centralized data drives enterprise growth

How real Fivetran customers accelerate analytics and AI

Get the guide
Why they chose Fivetran

Further reading
No items found.
No items found.
Related customer stories
Case study

RSG Group accelerates strategic decisions across 900+ global locations

Case study

LVMH achieves real-time insights and operational excellence

Case study

Tinuiti builds a scalable data lake for AI-driven marketing

Case study

Interloop scales Microsoft OneLake, cuts analytics project time by 50%

Case study

Scape unlocks real-time decision-making, cuts costs by 50%

Case study

ZURU boosts marketing efficiency by 20%, unlocks 6-figure returns

Case study

Adragos drives faster insights and global expansion with Fivetran

Case study

Oda scales customer growth by 5x with Fivetran

Case study

How Fivetran powers SKIMS’ fashion empire

Case study

Paddle accelerates financial reporting and global expansion with Fivetran