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
Are you a true data pioneer?

Our quiz will tell you where you are on your data journey and what tools you can unlock to level up.

Take the quiz
Why they chose Fivetran

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

FELFEL speeds up data integration by 20x with Fivetran

Case study

Trinny London achieves up to £260K in savings with Fivetran

Case study

National Australia Bank enhances customer experiences and powers GenAI

Case study

Envision Pharma Group and Fivetran: Pioneering faster paths in pharma

Case study

Raiffeisen Bank International uses real-time data to win more customers

Case study

Saks achieves data efficiency and enables AI with Fivetran

Case study

Cemex connects 1,800+ global facilities in real-time

Case study

Gill Capital unlocks SAP data with Fivetran, boosts sales by 25%

Case study

HubSpot powers GenAI, saves $100,000 with Fivetran

Case study

Deliveroo turns food delivery into a data-driven enterprise