Marketing reports damage my car.
Sometimes, when I walk out of a meeting, usually a quarterly or monthly There-Is-A-Very-Important-Person-In-The-Room kind of meeting, I head to my car. I close the door. I crank up the radio. Then I punch the roof as hard as I can while screaming “fuuuuuuuuuuuuuuuuuuu.”
Most of the time, that’s because I failed to persuade the Very Important Person In The Room.
And most of the time, that’s because I provided a report about as consumable as a bag of 6-week-old broccoli you keep shoving further back in the vegetable drawer.
Face it: When it comes to reporting, digital marketers suck. We lecture clients about audience awareness. Then we create reports that ignore our own audience. We dive down into the details too fast, or we deliver no detail at all. We make it hard for clients to get more information. Our reports are backward. Upside-down and sideways. Mish-mashed. Cattywampus. Higgledy-piggledy.
Want to fix it? Stop dumping data in the client’s lap. Use progressive detail.
Progressive detail is layered. The top layers show metrics and KPIs most directly connected to overall business performance. Deeper layers get more and more tactical. They show metrics that support day-to-day decision making but may not mean much to executives who spend their time looking at overall business performance.
Progressive detail creates this layered presentation with multiple formats:
Progressive detail helps digital marketers stand out, not as tactical nerds, but as marketers who understand the big picture. It means fewer roof-punching moments.
Here’s how to do it.
Short version: A kick-ass report combines dashboards, detailed findings and recommendations, and tabular data. Treat reports like user manuals. But read the rest of this section if you want examples.
I see marketers say “report” and mean one of these:
Cow dung. Those are just formats, and a format does not make a meaningful report.
Kick-ass reports don’t follow a one-size-fits-all format. Instead, they use multiple formats to deliver information to various audiences: Dashboards (or slides), tabular data, and detailed findings and recommendations. These are the formats:
Dashboards are slides, graphics, web pages, or spreadsheets designed for at-a-glance consumption:
Overall KPI Performance
They can include annotation. Just avoid the blah-blah-blah this went up, this went down stuff. The graphics should already speak for themselves. Tell your clients something they don’t know:
Annotated dashboard - email marketing performance
Don’t learn dashboard design from me. Learn from the masters:
Stephen Few: Information Dashboard Design and Now You See It. This is practical stuff you can’t find anywhere else.
Everything ever written by Edward Tufte. Given a choice, I’d pick his brain over John Malkovich. Sorry, John.
I have a couple of practical rules, though. When you create dashboards:
Dashboards are great for illustrating conclusions and guiding the discussion. They aren’t great for details. Which is why you also need this next format.
Eventually, someone looks at the dashboard and needs two things:
That’s what detailed findings and recommendations are for. This is the deep dive, with full explanation of what you found, as well as actionable advice. It’s all the information you can’t put in a dashboard. Use this format to deliver the detailed narrative and step-by-step recommendations:
If you want to create proper detailed findings and recommendations:
Divide detailed findings and recommendations into smaller chunks
Anyone looking at dashboards or the details may question the data. That’s what tables are for.
There are plenty of folks who will question the data no matter what you show them. Please read my yet-to-be-published post, “Dealing With Lunatics.”
Tables show raw information as tabular data. They’re not designed to explain. They’re designed to enable analysis and serve as a kind of data bibliography: They show readers the source of your analysis.
By the way: Tables can be annotated and used in a dashboard. I’m not a fan of this approach, though. Tables aren’t the best way to show change over time. They’re lousy comparison tools. Use them instead as a way to deliver raw, tabular data.
Tabular format shows unfiltered performance data
They’re any tabular presentation. Software doesn’t define a table. Want to use Excel? Sure. Google Sheets? If you must. But you might use HTML (gag), or a dashboard reporting tool that spits out information in a tabular format. It doesn’t matter if you use fridge magnets, as long as your client can read it.
Don’t get lazy! Don’t throw data into a table and fling it at the client. Tables are not reports. They’re the reference behind the report.
Phew! Made it! You now know the ingredients of a kick-ass report. It’s time to put it all together.
Short version: There isn’t one. Keep reading.
You have to assemble the ingredients—the dashboards, details, and tables—for your readers. That means using progressive detail.
A report uses ‘progressive detail’ when:
All clients have at least three levels of readers. It might be a single person in multiple roles or teams spread across a large organization. A report using progressive detail delivers layers of information, each layer more granular than the last:
Layers in a progressively detailed marketing report
Your report may have more layers or more dashboards. This is just an example.
Different layers cater to different audiences:
The very top layer is for the CEO/CMO/CxO. The board has hired them, or they own the business.
They’re hired to provide a long-term vision but get their ass fired (or go out of business) if they miss their two-month numbers.
The C-whatever-O needs to see overall business performance and the top one or two KPIs. They need a clear picture of the state of digital marketing at their company.
Show them one or two dashboards tied directly to their KPI goals:
Marketing report layers for the CxO
Most C-whatever-Os stop here. If they want more, they head “down” to the next layer.
The VP/Director/Senior is stuck in the middle. The C-whatever-O wants More ROI or Whatever They’ve Read About In This Month’s Forbes. The practitioners want to know why the VP ignores their concerns about dev resources, why they’re forced to record their hours, and why the CEO just told them to switch to NLP AI Machine Learning Data Driven Virtual Paper Identity Persona Powered Enhanced Marketing (again, Forbes).
They need to see what’s working and decide what’s not and guide my team’s decision-making accordingly.
Show them two or three layers of data, from top-level business performance to channel-by-channel data. That drives their decision making.
Marketing report layers for the VP type person: Still dashboards
A masochistic VP-type person can always dive even deeper, looking at the practitioner data.
The practitioners are the doers. Week-to-week, day-to-day, hour-to-hour, they execute the campaigns.
I don’t think it’s plagiarism if I cite The Doors for that reference.
For them, it’s all about the tactics.
Show them everything: The dashboards for the C-whatever-O and the VP types, then all the detail that follows. Help them justify their existence. Give them the raw data, and specific findings and recommendations. Written reports. The whole shebang:
Practitioners want it all: Tabular data, detailed recommendations, and dashboards
Progressive detail is not drill down.
Never provide “drill down” capabilities for C-whatever-Os or VP types. Drill-down means the user interacts with the report, selecting dimensions and filters to get more detail. Drill-down is helpful for practitioners, but the last thing I want is my C-whatever-O or VP getting frustrated as they try to find the right drop-down menu. They don’t have time for this.
So the first three layers of my report are pure dashboards. You might include a date range selector, but that’s it. Allow data exploration with successive dashboards and navigation.
It’s not because CxOs and VP types are dumb. Some of my best friends are CxOs. Heck, so am I. Give us simple navigation instead of drill down because we don’t have time or brainspace to do in-depth data exploration.
Make it easy for us.
It’s tempting to cut corners. You may think “This is the monthly report. Only the VP will read it. I don’t need the top-layer dashboards.”
That’s a huge mistake. Reports always make their way up and down the food chain.
So every report should start from the “top.” The practitioner’s findings and recommendations should also include the most recent version of all dashboards. The VP-types’ channels dashboards should include the top layer dashboards.
And, every report should provide access to the next layers “down.”
Be sure the VP types can get access to the detailed findings and recommendations. Make sure the C-whatever-Os can see the channel dashboards. You could do that by delivering the complete report to everyone, or by linking to the lower layers. Whatever. Just make sure everyone has the option of getting progressively more detailed.
Here’s a walkthru of the final product. I’m delivering my monthly report to the Beets, Inc. VP of Marketing.
Why beets? Because I hate them. They’re freaky and strange, and they’re not food. They make more sense in a slingshot than a salad. If I can create a good report about beets, I can do anything.
I know they will pass it on to the CEO and the practitioners, so I’ve covered it all:
These are the highest-level dashboards. If you’re using 16:9 format, like slides, you should have no more than two. Everyone needs to see this stuff.
Digital Marketing Dashboard: Top Level
These are the next layer of dashboards. Two-thirds of your audience needs to see this.
If you’re using 16:9 format, you can have two, four, or four hundred, but remember progressive detail. Put the less-detailed, more-strategic stuff first.
Digital Marketing Dashboard: Channels
One-third of your audience needs to see this.
Detailed Findings And Recommendations
Tabular data backs up detailed recommendations, shows where the dashboards came from, and shows that you did your homework.
Tabular Data Backs It Up
With multiple formats, it’s hard to create a single document. Dashboards are usually 16:9-ish. Detailed recommendations are traditional 8.5 x 11. Tables are tables—they don’t fit anywhere.
Link ’em. Don’t get fancy. You can use PDF to combine it all, of course, but I like to use links and connect stuff where it makes sense:
This link connects detailed recommendations to even greater detail in a CSV file
And, of course, put it all in a folder somewhere so your client can access it.
These are random things I frequently get right (or wrong) that may seem silly. But clients appreciate it:
Progressive detail is all about crushing our competitors. It’s about growing our industry, developing our careers and growing our agencies/departments.
Reporting using progressive detail makes data more consumable. It makes it less intimidating and draws even the busiest client into the story. It also helps clients independently understand the data and your conclusions.
That lets you spend more time talking about next steps and strategy. It lets your analytics team focus on opportunity analysis and integration. It moves us from report generators to bringers of value. So it increases client retention (or gets you a raise).
It also improves the perception of our industry as a whole. If you’ve read my writing over the last few years, you know I’m frustrated by the fact that digital marketers still struggle for relevance against big, traditional agencies. We should rule the marketing world. Progressive detail can help us do that.
Contact me with questions any time: @portentint
Google has always presented businesses with unprecedented opportunities to start, sustain, and grow online. It’s also created an unhealthy dependence…
NOTE: we are not lawyers. Please talk to your legal counsel before proceeding with compliance measures. In May of 2018,…
When asked by a less digital-savvy acquaintance, “What do you do?” I usually answer by saying, “Connecting people and businesses.”…
Web accessibility standards improve how users interact with your website and ensure everybody has an equal experience. Accessible content, as…
Before I first started wearing my Fitbit, I had no idea how many steps I took in a day, or…
WordPress plugins have been shaping the way users extend WordPress for years. As plugin development evolves, it is essential to…