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

Hunt, Gather Accelerates Operational Insights by 95% with 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

About The 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.

The 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.

The 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.

Operational Impact

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.

Quantitative Benefit

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