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
How to Downsize Your Agency, with Carson Pierce — Ep.176

About this Episode In this episode, Marcel and Carson dive into the uncomfortable but necessary topic on every agency owner's mind right now—how to navigate uncertainty when your pipeline is shaky, cash feels tight, and decisions get harder by the day. They share real...

Financial Planning for Agency Owners, with Jason Peck — Ep. 175

About this Episode In this episode of the Agency Profit Podcast, Marcel sits down with Jason Peck, a Certified Financial Planner at EverWise Wealth Management, to dig into the nitty-gritty of personal finance for agency owners. Jason shares his unique journey from...

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

How to Downsize Your Agency, with Carson Pierce — Ep.176

About this Episode In this episode, Marcel and Carson dive into the uncomfortable but necessary topic on every agency owner's mind right now—how to navigate uncertainty when your pipeline is shaky, cash feels tight, and decisions get harder by the day. They share real...

read more