Why You’re Failing at Profitability Reporting — Ep.156

About this Episode

In this solo episode of the Agency Profit Podcast, Marcel dives deep into the essential principles of designing effective data systems for agencies. Drawing on six years of experience and hundreds of agency collaborations, Marcel unpacks why so many companies struggle to get value from their data. He explores the key elements of building a sustainable data framework, explains common pitfalls of treating data management as a “tools problem,” and challenges some assumptions that might be holding your agency back. By breaking down the three pillars of successful data systems—data, framework, and process—Marcel offers actionable insights that will help you get the most out of your data and make it work for your agency’s unique needs.

Watch this Episode

Points of Interest

• 00:01 – 01:00 – Introduction to Data Systems: Marcel introduces the episode’s focus on designing data systems that empower agencies and businesses to make decisions with clarity and alignment.
• 01:00 – 02:30 – Why Agencies Struggle with Data: Marcel explains why many agencies face challenges in getting value from their data, often due to incorrect frameworks and a lack of process around data management.
• 03:00 – 04:20 – The Pendulum of Tools: Marcel discusses how agencies often swing between using specialized tools and all-in-one platforms, creating unnecessary change management that doesn’t solve core data issues.
• 05:00 – 06:15 – Outdated Billing Models in Agency Systems: Marcel explains how traditional agency frameworks assume time-and-materials billing, which isn’t suitable for many agencies today that use retainer or project-based models.
• 07:30 – 08:45 – Misconception: Data Problems are Tool Problems: Marcel describes how agencies mistakenly frame data issues as tool problems, leading to constant tool changes without solving underlying issues.
• 09:15 – 10:45 – Introduction to the Core Framework: Marcel introduces the three key elements for a high-functioning data system: data, framework, and process, with each playing a unique role in creating reliable insights.
• 11:30 – 12:45 – The Four Essential Data Sets: Marcel explains the four critical types of data needed: finance, people, projects, and time, and why these are fundamental to any data system.
• 13:00 – 14:30 – Framework: Metrics, Formulas, and Relationships: Marcel breaks down the importance of a clear framework to define which metrics to track, their formulas, and how they relate to each other and the business.
• 15:30 – 17:00 – Challenges with Data Hygiene and Consistency: Marcel highlights the need for a process to maintain clean data and handle changes in structure, such as renaming teams or changing project codes.
• 17:15 – 18:45 – Importance of Change Management in Data Systems: Marcel emphasizes that change within the business, like adding new services or tools, can disrupt data systems, requiring adaptable frameworks.
• 19:30 – 21:00 – Realistic Expectations for Automation: Marcel cautions against fully automated data reporting, explaining that human oversight is essential for data hygiene and quality, even with AI assistance.
• 22:00 – 23:45 – Cadences for Accurate Reporting: Marcel discusses the need for regular cadences, such as weekly time tracking, to ensure data accuracy and completeness before analysis.
• 24:00 – 25:45 – How Parakeeto Helps Agencies with Data Management: Marcel concludes by inviting agencies to reach out if they need support with data frameworks and processes, emphasizing that Parakeeto’s approach can save agencies time and improve profitability.

Show Notes

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

Love the Podcast

Leave us a review here.