Fivetran Case Studies Fivetran Facilitates Growth and Efficiency for Frontify's Branding Platform

Edit This Case Study Record

	Fivetran Facilitates Growth and Efficiency for Frontify's Branding Platform Fivetran

Fivetran Facilitates Growth and Efficiency for Frontify's Branding Platform

Fivetran

Technology Category	Infrastructure as a Service (IaaS) - Cloud Databases Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries	Cement Equipment & Machinery
Applicable Functions	Sales & Marketing Warehouse & Inventory Management
Use Cases	Building Automation & Control Time Sensitive Networking
Services	Data Science Services
Challenge	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
About Customer	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
Solution	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 Log in to view content
Contents

Technology Category

Infrastructure as a Service (IaaS) - Cloud Databases

Platform as a Service (PaaS) - Application Development Platforms

Applicable Industries

Cement

Equipment & Machinery

Applicable Functions

Sales & Marketing

Warehouse & Inventory Management

Use Cases

Building Automation & Control

Time Sensitive Networking

Services

Data Science Services

Challenge

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.

About Customer

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.

Solution

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.

Impact #1	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.

Impact #1

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.

Benefit #1	Reports that previously took a month are now accessible within 30 minutes
Benefit #2	Snowflake now runs 760 tables and 670 million rows
Benefit #3	ThoughtSpot has two million rows, 34 tables, and six worksheets

Benefit #1

Reports that previously took a month are now accessible within 30 minutes

Benefit #2

Snowflake now runs 760 tables and 670 million rows

Benefit #3

ThoughtSpot has two million rows, 34 tables, and six worksheets

Download PDF Version

Overview

Fivetran Facilitates Growth and Efficiency for Frontify's Branding Platform

Operational Impact

Quantitative Benefit