Fivetran Case Studies Hunt, Gather Accelerates Operational Insights by 95% with Fivetran

Edit This Case Study Record

	Hunt, Gather Accelerates Operational Insights by 95% with Fivetran Fivetran

Hunt, Gather Accelerates Operational Insights by 95% with Fivetran

Fivetran

Technology Category	Analytics & Modeling - Big Data Analytics Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries	Cement Equipment & Machinery
Applicable Functions	Product Research & Development Sales & Marketing
Use Cases	Real-Time Location System (RTLS) Time Sensitive Networking
Services	Cloud Planning, Design & Implementation Services Data Science Services
Challenge	Hunt, Gather, an Austin-based creative agency, was struggling with limited reporting tools that hindered their ability to share deep performance data with clients. The agency was in dire need of a holistic approach to the reporting of its digital marketing efforts. They required a suite of tools that would enable the collection and analysis of data, and ultimately the generation of key insights, all in a single location. The development team had previously built a few pipelines on their own, but these were time-consuming and costly. It could take up to six months to build pipelines in-house, and the team was also spending significant amounts on ELT platforms that were proving to be inefficient. Read More
About Customer	Hunt, Gather is a woman-owned creative agency based in Austin, Texas. The agency specializes in building creative campaign websites for brands, including Chipotle, Burger King, and GNC. They work with a variety of clients who require highly customized data reporting. The agency was continuously confronted by a frustrating problem: limited reporting tools kept them from sharing deep performance data with clients. They were in need of a solution that would enable them to develop a holistic approach to the reporting of their digital marketing efforts and provide key insights in a single location. Read More
Solution	The agency discovered Fivetran, a modern data stack that offered a faster, easier, and more cost-effective way to build pipelines and connect multiple data sources. With Fivetran connectors, the team was able to connect multiple sources with BigQuery in less than a day, a process that previously took months. The team also found that they saved more money with Fivetran compared to the ELT platforms they had previously used. Fivetran was implemented internally, reducing pipeline development time from a full month to just one day. The team was able to build SQL models and connect their data quickly, surfacing insights within minutes. They also set up connectors between their time tracking software and Google Sheets for internal reporting, automating the process and eliminating manual data entry. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Platform as a Service (PaaS) - Application Development Platforms

Applicable Industries

Cement

Equipment & Machinery

Applicable Functions

Product Research & Development

Sales & Marketing

Use Cases

Real-Time Location System (RTLS)

Time Sensitive Networking

Services

Cloud Planning, Design & Implementation Services

Data Science Services

Challenge

Hunt, Gather, an Austin-based creative agency, was struggling with limited reporting tools that hindered their ability to share deep performance data with clients. The agency was in dire need of a holistic approach to the reporting of its digital marketing efforts. They required a suite of tools that would enable the collection and analysis of data, and ultimately the generation of key insights, all in a single location. The development team had previously built a few pipelines on their own, but these were time-consuming and costly. It could take up to six months to build pipelines in-house, and the team was also spending significant amounts on ELT platforms that were proving to be inefficient.

About Customer

Hunt, Gather is a woman-owned creative agency based in Austin, Texas. The agency specializes in building creative campaign websites for brands, including Chipotle, Burger King, and GNC. They work with a variety of clients who require highly customized data reporting. The agency was continuously confronted by a frustrating problem: limited reporting tools kept them from sharing deep performance data with clients. They were in need of a solution that would enable them to develop a holistic approach to the reporting of their digital marketing efforts and provide key insights in a single location.

Solution

The agency discovered Fivetran, a modern data stack that offered a faster, easier, and more cost-effective way to build pipelines and connect multiple data sources. With Fivetran connectors, the team was able to connect multiple sources with BigQuery in less than a day, a process that previously took months. The team also found that they saved more money with Fivetran compared to the ELT platforms they had previously used. Fivetran was implemented internally, reducing pipeline development time from a full month to just one day. The team was able to build SQL models and connect their data quickly, surfacing insights within minutes. They also set up connectors between their time tracking software and Google Sheets for internal reporting, automating the process and eliminating manual data entry.

Impact #1	The implementation of Fivetran has revolutionized Hunt, Gather’s approach to data analytics and reporting. The agency can now easily track performance throughout the company and in client work. The team can build SQL models and connect their data quickly, surfacing insights within minutes. They have also automated their internal reporting, eliminating the need for manual data entry. The agency can now see everyone’s working hours in real time, broken down by month and by scope of work, making it easy to understand how each project is doing and what spending is needed. The team is also planning to connect QuickBooks and sync invoice data every 15 minutes, enabling them to easily make cash flow projections for the future. The agency is continuously building upon its data strategy to deliver insights both internally and externally, with Fivetran being the key to bringing it all together.

Impact #1

The implementation of Fivetran has revolutionized Hunt, Gather’s approach to data analytics and reporting. The agency can now easily track performance throughout the company and in client work. The team can build SQL models and connect their data quickly, surfacing insights within minutes. They have also automated their internal reporting, eliminating the need for manual data entry. The agency can now see everyone’s working hours in real time, broken down by month and by scope of work, making it easy to understand how each project is doing and what spending is needed. The team is also planning to connect QuickBooks and sync invoice data every 15 minutes, enabling them to easily make cash flow projections for the future. The agency is continuously building upon its data strategy to deliver insights both internally and externally, with Fivetran being the key to bringing it all together.

Benefit #1	Pipeline development time reduced from a full month to just one day
Benefit #2	Connected multiple data sources with BigQuery in less than a day, a process that previously took up to six months
Benefit #3	Significant cost savings compared to previous ELT platforms

Benefit #1

Pipeline development time reduced from a full month to just one day

Benefit #2

Connected multiple data sources with BigQuery in less than a day, a process that previously took up to six months

Benefit #3

Significant cost savings compared to previous ELT platforms

Download PDF Version

Overview

Hunt, Gather Accelerates Operational Insights by 95% with Fivetran

Operational Impact

Quantitative Benefit