Fivetran Case Studies Fivetran Facilitates Growth and Efficiency for Frontify's Branding Platform
Edit This Case Study Record
Fivetran Logo

Fivetran Facilitates Growth and Efficiency for Frontify's Branding Platform

Fivetran
Infrastructure as a Service (IaaS) - Cloud Databases
Platform as a Service (PaaS) - Application Development Platforms
Cement
Equipment & Machinery
Sales & Marketing
Warehouse & Inventory Management
Building Automation & Control
Time Sensitive Networking
Data Science Services
Frontify, a platform that helps companies grow their brands, faced a significant challenge in building a single source of truth for their data. The company needed to understand how people interacted with their platform to optimize user experience and resource allocation. However, their data analytics team was small, and their data infrastructure was unstable. They relied on custom Python scripts to pull data from business applications into a MySQL database, which often resulted in slow, incomplete data. Their BI tool was user-unfriendly and slow, causing reluctance among employees to use it. The data team was burdened with the task of updating reports and dashboards. To address these issues and become truly data-driven, Frontify needed a scalable and powerful data stack that could be accessible to everyone.
Read More
Frontify, launched in 2013, is a cloud platform that helps companies grow their brands by connecting all the important elements and stakeholders in one place. The platform provides a holistic set of solutions, tools, integrations, and templates that cover every aspect of the brand journey. As part of a recent $50 million funding round, Frontify is focusing on further advancing its technology and enhancing its analytics capability, which is central to its mission. The company's data team, which has grown to four people, is now primarily focused on data engineering and analytics.
Read More
Frontify's data team evaluated Modern Data Stack components to find the best solution for their business. They chose Snowflake as their data warehouse vendor and Fivetran for automated ELT due to its range of connectors, encryption handling, ease of use, and transformation capabilities. ThoughtSpot was selected as their business intelligence tool to enable users to engage directly with their data. Transitioning from the MySQL database to the new stack involved building a raw data layer in Snowflake that incorporated Fivetran data sources and custom ETL scripts. A data mart was created for reporting and analytics with 'self-service' search-driven analytics on top. Fivetran connectors now feed data to Snowflake from various sources, including HubSpot for sales and marketing and Zuora and Recurly for recurring revenues. The new data infrastructure has transformed the roles of the data team, allowing them to focus on data engineering and analytics rather than building and fixing data pipelines manually.
Read More
The implementation of Fivetran, Snowflake, and ThoughtSpot has facilitated the creation of department-specific databases that can be queried by Frontify’s different stakeholders. Employees can now sync data faster into their data warehouse using Fivetran and create their own ThoughtSpot ‘Liveboards,’ which act like interactive dashboards and can be created in minutes. Key metrics are now presented at weekly revenue meetings, and the deal pipeline, year-on-year growth split by market, and average opportunity values are analyzed. The data team is now free from rudimentary tasks and can focus on projects that deliver long-term value to the business. The self-service element has also increased data accessibility and usability across the company.
Reports that previously took a month are now accessible within 30 minutes
Snowflake now runs 760 tables and 670 million rows
ThoughtSpot has two million rows, 34 tables, and six worksheets
Download PDF Version
test test