Subscribe to Feed
Excel Dashboard With Essential Metrics for Online Marketers
Like many data-rich subjects, online marketing represents a challenge when it comes to clearly seeing real and actionable information. Cutting through the clutter requires one to stay focused on metrics with true meaning and purpose.
For example, web analytics dashboards that focus too much on click-thorugh rates and not enough on conversion rates will hurt the online marketer because he or she will “forget” that their real goal is to increase those activities that bring maximize ROI - i.e. bring the most conversions. How can that be, you ask. Are people that silly? Well, put a complicated dashboard in front of you with a thousand blinking metrics and you’ll lose sight of your goal too. Especially if you are just learning a new field.
Paring down your data world into those essential metrics that matter is the key to providing a valuable, easy to use dashboard.
Download the Essential Metrics Excel Dashboard for a look at how a simple, basic approach based solidly on a few key metrics can outperform much fancier dashboards.
This dashboard is provided by the hard-working Marketing Experiments team as part of their study on Improving Website Conversion: Essential Metrics for Online Marketers. Check that link for an explanation of the metrics used to track conversions. There is even an interesting, in-depth audio recording that explains the dashboard.
Here is a screenshot of the first tab of the excel dashboard.
The tabs of the worksheet are Time Series Projection, Subscription, Retail, Services, Metrics Selection, Essential Metrics, and Seasonality.
The clarity of this dashboard comes from the understanding that at the core of web analytics, there are really four elements that you can measure:
The amount of activity on your site (page views, visitor stats, etc)
The source of that activity (referrer info, search terms, etc)
The nature of that activity (entry pages, exit pages, time per page, etc)
The results of that activity (orders, signups, click trails, etc)
In terms of the metrics, the 2 basic ratios being measured are
The Cost per Desired Interaction
The Yield per Desired Interaction
Here is a graphic depicting the organization questions:
This dashboard focuses you on the metrics that matter to your particular business model.
Tags: Excel Dashboard for Online Marketing Metrics, Web Analytics Dashboard
Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.
What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.
Leave a Reply
Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:
- Enterprise Dashboard for Marketing Campaign Management ...
- Excel Dashboard for Monitoring the Competitive Landscape ...
- Building an Executive Dashboard in Excel 2007 with Conditional Formatting ...
- A Look at Building Dashboards in Excel ...
- So Where are the Excel 2007 Dashboards? ...
- Ingredients for Building Excel Dashboards ...
- Excel Dashboard for Hospital Bed Management ...
- The Excel 2007 final look and feel - brace yourselves for plenty of do-it-yourself dashboards and scorecards ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Hospital Financial Management Dashboard
- Restaurant Performance Dashboard
- Business Intelligence Architectural Stack
- 3 Steps for Performance Improvement
- More on the Pie Chart
- Dell IdeaStorm Dashboard
- Excel Tool Tips
- Rube Goldberg Dashboard
- Dashboard Spy White Paper Collection Launches
- Excel Visualization of Olympic Medal Count
