About

Blog

Case Studies

FAQ

Why Most Reporting Systems Fail, & What to Do Instead, with Ben Zittlau — Ep.168

0 comments

Parakeeto

Parakeeto

Last updated Feb 18, 2025

Share

Why Most Reporting Systems Fail, & What to Do Instead, with Ben Zittlau — Ep.168

Last updated Feb 18, 2025 | 0 comments

Parakeeto

Share

About this Episode

In this episode of the Agency Profit Podcast, Marcel and Ben dive deep into the challenges agencies face when managing data across multiple tools. They debunk the myth of a “source of truth” system, highlighting why rigid integrations and all-in-one solutions often fall short. Instead, they advocate for a modern data approach—extract, transform, and load (ETL)—that prioritizes flexibility, accuracy over precision, and adaptability to change. With insights from Ben’s experience in scaling data operations at Jobber, they explore why agencies should focus on cleaning and structuring data post-collection rather than forcing compliance upfront. If you’re tired of messy reporting and want a better way to turn raw data into actionable insights, this episode is a must-listen!

Watch this Episode

Points of Interest

  • 01:00 – 01:45 – Guest Introduction: Marcel welcomes back his co-founder, Ben Zittlau, highlighting his expertise in data operations and agency growth strategies.
  • 03:35 – 05:50 – Scaling Data Operations: Lessons from Jobber: Ben shares insights from his experience at Jobber, detailing the challenges of building and scaling a data operations team in a fast-growing company.
  • 08:43 – 13:14 – Why Agencies Struggle to Get Insights from Their Data: Discussion on how agencies collect vast amounts of data across multiple tools but fail to derive meaningful insights due to fragmentation and inconsistency.
  • 13:15 – 16:05 – The Myth of a “Single Source of Truth: Marcel and Ben challenge the common belief that pushing all data into a single platform solves reporting issues, highlighting the reality of messy operational data.
  • 19:26 – 21:48 – The Limitations of All-in-One Software Solutions: Exploring why all-in-one agency management tools often fail to deliver on their promise of seamless reporting and data integration.
  • 24:43 – 27:44 – The Hidden Costs of Locking into a Single Platform: Discussion on how agencies become “trapped” by software providers, making it difficult to switch tools without major operational disruptions.
  • 30:29 – 35:53 – How to Integrate Data Without Sacrificing Flexibility: A deep dive into the challenges of stitching data from various tools while maintaining adaptability and historical accuracy.
  • 35:54 – 41:14 – Accuracy vs. Precision: Why Clean Data is a Myth: Why agencies should focus on broader trends instead of pursuing impossible data perfection, and how to handle data inconsistencies effectively.
  • 41:15 – 44:15 – A Modern Data Approach: Extract, Transform, Load (ETL): Introduction to the ETL process, which allows agencies to clean and transform data before reporting, improving reliability and flexibility.
  • 50:14 – 52:00 – Lessons from Finance: What Agencies Can Learn from Accounting: Marcel compares data operations to bookkeeping, explaining how structured financial workflows can serve as a model for better agency data management.

Show Notes

Love the Podcast

Leave us a review here.

Related Posts
Prove Your Value & Increase Retention, with Mari-Liis Vaher–Ep.173

About this Episode In this episode of the Agency Profit Podcast, we sit down with Mari-Liis Vaher, a seasoned marketing strategist and author of the upcoming book The Greatest Marketer in the World. With years of experience in marketing and entrepreneurship—including...

Understanding Your Agency Model, with Carson Pierce –Ep.172

About this Episode In this episode of the Agency Profit Podcast, Marcel and Carson dive into the major shift happening in agency structures—moving from in-house teams to a more flexible, contractor-heavy model. They break down why more agencies are leaning on...

Balancing Creativity and Profitability, with Tim Thompson –Ep.171

About this Episode In this episode of the Agency Profit Podcast, Marcel sits down with Tim Thompson, Owner and Chief Revolution Thinker at RevThink, to break down the financial frameworks that help creative agency owners take control of their cash flow and...

Get the Agency Profit Toolkit

The free tools, templates and training videos you need to measure the right metrics and improve your profitability.

Show/Hide Comments (0 comments)
L

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Articles

Understanding Your Agency Model, with Carson Pierce –Ep.172

About this Episode In this episode of the Agency Profit Podcast, Marcel and Carson dive into the major shift happening in agency structures—moving from in-house teams to a more flexible, contractor-heavy model. They break down why more agencies are leaning on...

read more