The 80/20 Rule of Reporting
John Liu
Most agencies waste 80% of their time on manual data collection and formatting. True value lies in the remaining 20%: applying domain expertise to provide strategic recommendations and contextual interpretation.
A fully automated report doesn’t add much value. But you do!
The first week of every month is often hell for most marketers. Your schedule is packed with client update meetings. Clients are banging at your door to understand why performance dropped last month.
For smaller clients, a quick summary may work. However, bigger clients want to see more: “What has been done, what works, what didn't work, which platform is performing well, how different metrics perform across various dimensions, and what should we do next?”
You easily spend more than 3 hours per client pulling data from multiple platforms, pasting results into spreadsheets, and manually writing insights to explain the numbers. Then you spend another hour checking for typos and adjusting charts to follow brand guidelines.
When you finally present it, the client asks: "So what's your recommendation?" or "How's our competitor doing?"
You realize that working on basic updates has already consumed your hours...non-billable hours. Meanwhile, there's no time left to leverage your expertise for deeper insights. It's frustrating.
The golden 80/20 rule still applies
The Pareto Principle suggests that 80% of results come from 20% of efforts. In reporting, this means 80% of the work is repetitive data pulling and formatting, while only 20% is the valuable analysis and strategic thinking that actually drives results.
The problem? Most agencies are stuck in that 80%. These are mundane tasks that don't require expertise. Meanwhile, the 20% that truly showcases your value gets squeezed into whatever time is left.
This is where automation should step in, but here's the catch: You do not want to automate everything. A fully automated report is just a data dump with no context. What clients really pay for is your interpretation, your strategic recommendations, and your expertise in knowing what the numbers actually mean for their business. Your domain knowledge is worth far more than the raw data.
Sharing a case: The Human Element
I recently saw a video by Branden Gillen where he shared how domain knowledge in e-commerce plays a role in interpreting GA4 data.
One day, he saw the conversion funnel drop significantly among mobile users. AI can describe the situation and suggest technical reasons—loading times, invisible buttons, or API timeouts. However, a seasoned marketer will immediately check the site and might notice a promotional banner is blocking the checkout button. Why? Because they've seen this exact issue before.
Can AI do that? Maybe, but it’s you, having worked closely with the client, who can spot the problem immediately. This is why the future of reporting isn't about full automation—it's about intelligent automation that handles the 80% so you can focus on the 20% that matters.
What are the most important 20%?
While the 80% is about efficiency, the 20% is about expertise. Here is what separates good reports from great ones:
- Customization: Using industry terms and jargon that make the report relatable to the client.
- Strategic recommendations: Understanding how data connects to specific goals and market positions.
- Industry-specific insights: Applying domain knowledge to spot patterns generic AI simply can't recognize.
- Proactive problem-solving: Identifying issues before they become crises based on past experience.
- Competitive intelligence: Contextualizing performance against industry trends and competitor movements.
- Actionable next steps: Translating data into a prioritized action plan.
Why SMAQ automates the right 80%
SMAQ is built on this principle. We automate the data collection, formatting, chart generation, and basic performance summaries. But we leave space for what makes you valuable: your strategic insights and your understanding of the client's business context.