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

Hunt, Gather Accelerates Operational Insights by 95% with Fivetran

Fivetran Logo
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

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.