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 data-driven 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:

Love the Podcast

Leave us a review here.

Why You're Failing at Profitability Reporting, With Marcel Petitpas

The Agency Profit Podcast

Why You're Failing at Profitability Reporting, With Marcel Petitpas