Adding Contextual Utility to Reports Without Writing a Novel

Michael Wiegand, Director of Analytics

Reporting can be a chore. Even with all the data automation in the world, to frame our results, we feel the need to write an executive summary and hope we touch on the why behind all the painstakingly-created charts and graphs.

But sometimes, we might not be able to boil down the proper context for the client in just those few introductory paragraphs. So let’s explore some simple ways to have the data elaborate on itself.

Annotations

Annotations can be as simple as “campaign starts” with an arrow pointing to a place on the timeline.

Screenshot of a GDS line graph report that shows an arrow indicating when in the data Portent's work beganto forecasted click data for the same future time period

They can also be as simple as a caption under a point in the graph you want your client to pay attention to.

Secondary Dimensions

You have two pages in your report to address channel performance and landing page performance? Why not combine them? Adding two dimensions to one data table can frame a combination of things that lead to better performance and keeps the overall page count in your reports down.

Why not show campaign, country, and device while we’re at it?

Screenshot of a GDS report with a red box calling out the campaign, country, and device data columns

Titles and Subtitles

I’m a big fan of teeing each page in the report up with a question in the title and answering it with the subtitle and the ensuing data. In the title and subtitle, you can lay out:

  • Where you got the data
  • What baked-in comparisons exist
  • What business question you’re trying to answer with the report

Screenshot of a GDS report titled "How efficient are our paid campaigns?" and the subtitle "Last year's conversion and CPA data from all Google Ads campaigns" that answers where the data is from, and what is being compared

Benchmarks

How many of us have been in a client meeting and heard the question: “Is this performance good?”

Good compared to what? Their past performance or the performance of their competitors? In either case, as consultants, we should provide the answers and have them available quickly.

Screenshot of a GDS report that includes the benchmark CTR for the campaigns at the bottom of the data, for quick reference

Ratios

Our clients’ conversions were up 20% over last month. Great! But was that just because they spent more money? Or just because they got more traffic? Or did we really drive higher conversion rates? Add the ratios alongside volume to have it there in case the question comes up.

Screenshot of a GDS report that shows the click-through rate next to the number of clicks

Cost

Like it or not, we live in an ROI-focused time. Never leave Cost Per metrics off of your report! Cost Per Everything: Impression, Click, Lead, Sale. If the client is going to have to answer to their CFO for how much they’re spending on customer acquisition, give them Cost Per every step of the acquisition funnel.

Screenshot of a GDS report that shows three cost metrics side by side: CPM, CPC, and CPA

Trendlines and Forecasts

We can’t predict the future, but there are several forecasting models that come pretty darn close. These forecasts can help clients estimate results, which makes it easier for them to write our campaigns and marketing costs into their budgets.

Screenshot of a GDS report that shows actual click data for a time period next to forecasted click data for the same future time period

Context, Not Writing

If we can’t figure out how to provide the context in our reports without writing a novel of an executive summary every month, we’re gonna spend an awful lot of time writing summaries and answering questions. So try some of these to create contextual utility in the data visualizations you already provide. And if all else fails, change the chart type! Switch your pie chart back to a simple table and add several more metrics. Never settle on a visualization that can’t explain itself.

Michael Wiegand, Director of Analytics
Director of Analytics

Over two decades as a marketer, Michael's experience has run the gamut from design, development, direct mail, multivariate testing, print and search. He now heads Portent's analytics practice, overseeing everything from Google Tag Management, to CRM integration for closed-loop analytics, to solving ponderous digital marketing questions. Outside of work, he enjoys recording music, playing D&D, and supporting Seattle Sounders FC.

Start call to action

See how Portent can help you own your piece of the web.

End call to action
0

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Close search overlay