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

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

• Connect with Ben via LinkedIn
• Free Toolkit
• Parakeeto Foundations Course

Love the Podcast

Leave us a review here.