By combining metrics from multiple data sources, you can create more informative, more insightful reporting dashboards.
Marketing | Sep 21
Abhay Kumar on June 26, 2018 (last modified on April 20, 2021) • 6 minute read
In my first job as a marketer, I got the opportunity to work with a SaaS-based company.
Most of the management and marketing team members were new to the world of digital marketing. To conform to the international content standard, we outsourced our content marketing to an external agency.
Things were going reasonably well, management was quite happy with the blog’s content and appealing visuals.
At the end of the month, the agency shared their performance report. It was a gigantic, 27-page PDF report, including data from Facebook, Twitter, and Google Analytics. Nobody from the management team looked into the details of the report, but everyone was optimistic about our new content marketing strategy and an increased presence on Facebook.
This pattern of end-of-month reporting continued for more than 3 months. We didn’t observe any improvement in leads, which was the metric that management ultimately cared about.
Then, we hired an external consultant to review the marketing process and ongoing marketing activities. The consultant shared a one-page weekly dashboard in an Excel sheet to track all the marketing activity, which could be regularly updated and tracked.
Here is what it looked like:
The report was generated from the best analytics platforms, so we knew we had accurate and comprehensive data. The data points should have given direction for the business goals and ongoing campaigns.
But instead, we were overwhelmed by the amount of data. The marketing team was not in a position to make any decision based on the shared data.
A few members of management were elated, as their preferred metrics like Facebook Page “likes” and followers showed an increasing trend.
But, we didn’t really know if these Facebook metrics were bringing any tangible results to the business. If we increased our budget on Facebook campaigns, would we really get any closer to our business goals?
We lost a few months while we tried to make sense of the overwhelming amount of data. But, although we weren’t able to make data-driven decisions, we learned how to improve our marketing reporting process so that all teams were aligned.
Today, there is no lack of data to measure marketing activities. The amount of data provided by Facebook & Google Analytics (GA) is humongous. Every data point is useful in some way or another, but we don’t have the resources to look at all the metrics.
Analytics tools provide generic data points for all companies. To get valuable data, we must extract the main metrics which can give insight into our business.
As we try to understand all of these marketing metrics, we must understand types of metrics.
Vanity Metrics- The metrics which look appealing but do not help you understand the performance of your business. You can’t make any actionable business decisions based on these metrics. We suggest that you avoid these metrics as they won’t help you reach the Goal.
A few vanity metrics are
Real metrics or actionable metrics – The metrics give a real indication of your business performance and help in the decision-making process. These metrics give feedback on current business processes and help you understand whether marketing is going in the right direction or not.
A few key metrics are:
These metrics are dependent on the marketing goal. Quite simply, if a metric helps you in reaching your goal, it’s a real/actional metric. Otherwise, it’s a vanity metric.
1- Set marketing objectives. Clearly define your objective. In technical terms, the objective should be SMART (Specific, Measurable, Attainable, Realistic and Timely). The marketing team should clearly know the quarterly objective and how each campaign will help them reach the quarterly objective.
A few examples:
2- Identity the key metric. Based on the set objective, find the key metrics which can help you make decisions and track the set objective.
If the objective is to increase new customers by 25%, you can track:
If outbound activity is part of lead generation plan, a few metrics to be tracked are:
3- Create a dashboard. A dashboard should include a collection of all the key metrics for a campaign. It combines all the metrics in one place and makes it visually presentable.
After you make one marketing dashboard, the next question that arises is how many dashboards you should create in total.
I follow a two-pronged approach to track all my metrics
1- Primary dashboard
This dashboard tracks overall quarterly goals or the main goal for the marketing team. Using the dashboard, you should able to track the progress made by the marketing team and returns on marketing investments.
A few key metrics used by most of the business are:
The primary data point varies for every industry and is also dependent on quarterly marketing goal. Here are a couple examples of marketing reporting templates from different industries.
Here’s an example of a Primary Dashboard that gives a clear picture about sales, leads and funnel flow.
2- Secondary dashboard
This dashboard tracks the respective campaign objectives. These are the campaigns that you have initiated to reach the quarterly objective.
Example – If a revenue increase of 25% is the quarterly target, you would plan and initiate several campaigns, like:
All the campaign key metrics should be identified and tracked.
Here’s an example of a secondary dashboard that tracks organic growth.
One quick insight – the number of new users is almost stagnant but there is major dip in organic traffic on the home page.
We are in era of data glut.
Although Google Analytics and other analytics tools provide all the required data, it’s the responsibility of the marketing manager to find the required set of metrics to be tracked and make the best decision that will help him or her reach the set goal.
Marketing | Sep 21
SEO | Sep 14
Marketing | Sep 2