Do You Need a Reporting Renovation?

6 Reasons Why You Need a Mailing and Data Governance Policy
19th Jun
Vanity metrics
3 Times Vanity Metrics Aren’t Useless
17th Jul
Show all
Marketo Reporting

Reporting is hands down one of the most terrifying parts of a marketer’s job. All our hard work, brilliant ideas, and nervous campaign executions are exposed, and we have to come to terms with the essential question that keeps us all employed…Did it work?

I get it; we as marketers employ a strange version of the Scientific Method. Equal parts science and art, we gather as much data as we can, come up with a wacky new concept, and throw it all against the wall to see what sticks. We form good hypotheses and try bold new things. Lather. Rinse. Repeat.

It can be daunting to go through this process over and over, month after month, quarter after quarter. Having to look forward AND backward at the same time can be exhausting. Which is why we’re taking it down to the studs…

You’re Reporting Renovation Begins

Here are a few steps to get your reporting system looking less Brutalist and more Contemporary. Note that none of these steps involve working with plumbing or electrical: the source data underneath the report.

Prerequisite: We’re going to assume you are thoughtfully and diligently using Marketo to capture, measure, and track your marketing engagements with proper program setup, naming conventions and data collection (and if you aren’t sure and need some help, let us know!)

Step One: Reporting Taxonomy

Go through all the reports that you pulled last quarter, and take a quick inventory of which of the following two categories each report fell into:

The Success Report

Marketo Reports Success

This report has a start and end date, measures performance over a defined length of time, and clearly and cleanly answers one single question: Did we achieve the goal we set when we began this campaign?

The Performance Report

This report measures campaigns that are currently in flight, and seeks to determine whether we are on track to meeting our previously stated goal.

This step is crucial. We need to understand the function behind each report so we know how to make sense of it. If we’re only ever compiling Performance Reports, we never get to step back and appreciate our successes or celebrate a really awesome quarter.

Conversely, if we only ever generate Success Reports, we are constantly blindsided by a campaign that we thought was going really well actually turning out to be a huge failure. Or we have a monster success of a campaign and we don’t really know why that happened and we could have capitalized on the momentum earlier.

Step Two: You Need A Goal

Notice that each of these above reports require a goal to be set first. A campaign-specific goal should have been defined at the onset of a campaign, a revenue-specific goal should have been defined at the beginning of the quarter or year, etc. Having a goal gives the report orientation and purpose, because it forms the question that the report is meant to answer.

No goal? Don’t bother pulling a report, because you won’t be able to make sense of it anyway. Sure, there are cases for running some numbers to establish a benchmark, but this is NOT the kind of report you want to send to your VP or executive team. Keep gut-check reports internal.

Note: If you are asked to generate a report without knowing what goal/question the report is to answer, don’t hesitate to ask! Avoid the trap of being held to numbers or expectations you aren’t aware of. You don’t want to be in a situation where you send a report with number you think are on target, only to be caught off guard when someone else disagrees.

Step Three: Interpret on Others’ Behalf

One of the worst things we can do is send off a report without any synthesis for the consumer of the report. You don’t want to leave any interpretation to chance, so make sure on each slide/report/graph you include a So What line, or a Summary statement that helps the report consumer make sense of what she is seeing, so that you are reaching similar conclusions together.

If your numbers are disappointing or otherwise hard to interpret, be honest about that, but make sure to provide some assurance going forward. By knowing that your AdWords campaign is performing terribly, you’re saving the company thousands in future wasted spend, and by seeing no pipeline created from a particular tradeshow, you now know that you can reallocate that spend toward doubling down on a high-performing show.

To summarize, provide some insights with your reports that help bring clarity to the message you want to get across. Which of the following will help your team attain a better glimpse into this month’s successes and shortcomings:

  • No Insights: Hello team, below is this month’s email report. Please let me know if you have any questions.
  • With Insights: As you can see with this month’s emails, the Best Practices content outperformed our average CTR by 42% (5.2% CTR). We may want to consider developing more of that content. For the third month in a row, The Monthly Bulletin unsubscribe rates continue to exceed all other communications. A further analysis is required.

Step Four: Build your Report Library

Marketo makes this so easy! Here is a common foldering structure I like to use in the Analytics section of Marketo:

Every folder here has the exact same report, just with a different date range.

By creating these reports once, validating them, and cloning them, you are making sure you have the exact same parameters for each. This allows you to compare period-over-period without worrying if the data for each is wrong. This also allows you to build Report Subscriptions so that your Last Month report gets sent to your inbox the first of every month, when the data is fresh and the most accurate.

Marketo Reporting folders

Example of a Marketo folder structure for streamlined insights.

Step Five: “Who, What, and When” your Reporting Needs

Make a spreadsheet that keeps track of all the reporting your team is responsible for. Have columns that display WHO the report is to be sent to, WHAT the data is supposed to show, and WHEN the report should be sent each month/quarter/year.

This will not only help the team prioritize reporting with other timely needs that come up, but might help you combine reports or find new ways to connect your data. If you’re sending one report that measures new leads from social, and another that measures new leads from webinars, perhaps combine them into a New Leads by Lead Source report.

Marketo reporting schedule

Summary

Defining your organization’s KPIs doesn’t have to resemble the rebuilding of a house. Use some of the above steps to help remodel what makes the most sense. Good luck remodeling.

Tyson Jurgens
Tyson Jurgens
Tyson is a RevEngine Marketing consultant and avid Marketo enthusiast who has held multiple demand generation and marketing operations roles at various software companies. A New Yorker by way of Kansas City, St. Louis, Seattle, Ithaca, and originally Lincoln, he enjoys sales and marketing alignment, thoughtful folder structures, his two dogs, and making frittatas.

DYN

Josh Verrill

Services: Strategy, Assessment, Ongoing Services

“RevEngine Marketing has helped Dyn reach amazing results. Within 60 days, REM helped Dyn establish repeatable best practices to improve marketing efficiencies over 50%. That enabled our business owners to focus on the business, not on our system.
With REM as our long term partner, we’ve seen marketing’s contribution revenue double over the past year. REM has helped us achieve success with everything from managing the lead lifecycle to gaining visibility into marketing effectiveness.”

451research

Coming soon…

Clavis Insights

Helped find the gaps in Solix marketing process to put on path for 5X improvement.

Centage

Created efficiencies reducing webinar setup time and other programs by 50%+.

Reduced reporting time on key video watching program by 10x. Insights now take minutes as opposed to hours.

Clavis Insights

Established best practice program and landing page strategy to streamline ongoing marketing as much as 50%.

Provided vision into marketing influence by creating multi touch attribution model to measure the impact of various touch points.

DYN

1. Created marketing efficiencies reducing day-to-day workload for select campaigns by 30%+.

2. Identified approx $1 million+ in bad/old data to cutting Marketo license costs, improving personalization and boosting marketing results.

3.Streamlined Marketo performance 30%+ with in-depth performance audit to disable old campaigns, eliminate unnecessary fields and optimize CRM sync.

4. Improved nurture journey reducing staffing 1/4 resource (or $25K) the time of sending manually.

Bullhorn

Created efficiencies reducing webinar setup time and other programs by 50%+.

Reduced reporting time on key video watching program by 10x. Insights now take minutes as opposed to hours.

DataGravity

Coming soon…

Fusion

Boost engagement by 167% including a 12X single day improvement leveraging a Triple Touch Methodology.

IngramMicro

Coming soon…

Kewill

Coming soon…

USAA

Develop a Second Chance nurture strategy to boost engagement 2X for previously unconsumed content.

Yearup

Coming soon…