The Six Dashboards Every Marketer Needs

Jul 12, 2017 · 6 min read

Every Marketing team, B2C or B2B, faces similar challenges. They want quality leads, exponential growth at the top of the funnel and a high conversion rate from lead to sales opportunities. Sometimes marketing feels like a rollercoaster ride. But these challenges are what drive Marketing teams to think creatively and analytically.

But huddling in conference rooms thinking about ways to generate more leads by leveraging data isn’t enough. As data becomes more voluminous, it’s our responsibility to extract insights from data, create reports and turn those reports into action.

This process may seem arduous, but it doesn’t have to be complicated. At Chartio, we’ve created a cloud-based data exploration tool for all marketers. Together with Astronomer, you can consolidate data from all your data sources and visualize your data.

Why Visualize?

According to Business to Community, the human brain is more accustomed to processing images, often processing visuals 60,000 times faster than text. Which could explain the ever growing popularity of data visualization. With that, we believe the best way to overcome your marketing challenges is to use your data and create dashboard visualizations.

Start by asking questions: what are you doing and why are you doing it? If you’re launching a paid campaign, what goals do you want to attain?, What are the specific numbers that you want to hit? The list goes on.

Once you know your metrics and have a grasp on how your data is defined within your databases (Marketing Automation, email data, CRM, paid channels, etc.), then you can start thinking about the dashboard.

Great dashboards start with your data. In research conducted by Google, it revealed that “61% of marketing decision- makers said they struggled to access or integrate the data they need.” Fortunately, with solutions like Astronomer and Chartio, consolidating, accessing and visualizing your data is easy. Here are 6 dashboards that every CMO should know about:

KPI Dashboard

This sample KPI dashboard is tied to broader business goals. In this example, we’re tracking MQLs, because that’s a high-level company goal and how we calculate overall pipeline revenue.

From this dashboard, we can access the health of our top of funnel and drill down into what’s working and iterate on what isn’t working. In analyzing what’s working, we can improve our messaging for low performing channels and continue to grow the top of funnel pipeline. It’s clear visualization that enables us do this quickly.

Five Return on Investment Dashboards

As lead generation is always top of mind for Marketing teams, measuring overall ROI is close behind as one of their top challenges. To say the least, marketing tactics have always been tricky to measure, and when paired with today’s complex buyer’s journey — it’s all the more difficult. But, of course, it doesn’t have to be difficult.

As marketers continue to refine and optimize their campaigns, we’re also getting smarter about capturing data. With data pipelines and dashboards, you can easily consolidate all your marketing data and transform rows of raw data into invaluable insights for everyone on the Marketing team.

Here are just a five ROI dashboards that you can create:

Search Engine Marketing Dashboard

If you’re spending a lot of money on paid channels and search, chances are you’re going to want to meticulously track every dollar spent, so you know how and where you’re spending your money. As marketing budgets continue to fluctuate, the clearest way to prove Search Engine Marketing (SEM) value is through a dashboard, because data is always truthful.

Here are a few key metrics to track in your SEM dashboard:

  • Customer Acquisition Cost (CAC): The cost to acquire a customer
  • Top Performing Campaigns: A visualization of which campaigns are leading to the highest conversion, so you know where to focus budget
  • Leads (from paid search): This metric is about accurately attributed leads to paid search
  • Wins (from paid search): This metric is about accurately attributed revenue to paid search
  • ACV (of wins from paid search): Again, aligning your paid search efforts with its impact on revenue
  • Cost Per Click: The cost that you pay for every click coming from a search engine
  • Total Cost: The difference between how much money did you plan on spending and how much you actually spent

To create an optimal Paid Search dashboard, you’ll need to combine data from your website analytics, search engine data (AdWords, Bing) and CRM data.

Social Media Dashboard

According to a 2015 report by Social Media Examiner, “88% of marketers want to know how to measure their return on investment (ROI) for social media activities. With the continued importance on social, that number has more than likely grown. A Social Media dashboard contains all the metrics from your social channels, shares, engagements, followers, etc.


  • Page Likes
  • Page Views
  • Page Reach


  • Shares on Facebook
  • Shares on LinkedIn
  • Shares on Twitter
  • Shares on Google +

Click-Through Rate (CTR)

  • % of CTR
  • Bounce Rate

Paid Campaigns

  • Promoted Tweets
  • LinkedIn Sponsored Update
  • LinkedIn InMail
  • Facebook ADs

To create this dashboard, you’ll need to connect data from Marketing Automation, CRM and social channels (Facebook, LinkedIn, Twitter, Google +).

Content Marketing Dashboard

As Content Marketing continues to grow, metrics provide insights in how content is performing. Taking a page from Jay Baer’s book, content marketers can track: consumption, sharing, lead generation and sales metrics all from one dashboard.

Consumption Metrics

  • Page Views
  • Average Time on Page
  • New Visitors
  • Bounce Rate

Sharing Metrics

  • Social Shares
  • CTR from RSS

Lead Generation Metrics

  • Content first touch
  • Conversion Rate
  • MQLs generated

Sales Influenced Metrics

  • Pipeline generated
  • Opportunities influenced
  • Opportunities won

To create this dashboard, you’ll need to connect data from your Marketing Automation, CRM, content management system, social channels and website analytics.

Website Analytics Dashboard

A web analytics dashboard focuses on your web analytics data, detailing specific numbers such as site traffic and time spent on site.

Metrics on this dashboard should include:

  • Unique website visitors: Unique new visitors to your website
  • Return visitor information: Even if a person didn’t convert on their first visit, it’s important to know that they came back
  • Bounce rate: Tells you where visitors are dropping off, so you can better optimize the page or rethink strategy
  • Trials by Lead Source: Traffic source where leads are coming from (direct, organic, paid, referral)
  • Customer Wins by Lead Source: Tells you which source led to a closed deal ((direct, organic, paid, referral)

A website analytics dashboard gathers data from several different sources including website traffic, CRM, Marketing Automation, website optimization data and mobile analytics (if applicable).

Marketing Funnel Dashboard

A Marketing Funnel Dashboard visualizes the multi-stage process and ascension throughout the marketing lifecycle. It visualizes movement throughout the funnel from Top of Funnel to conversion goal.

Since Marketing encompasses a spectrum of disciplines, nearly every Marketing initiative has its own funnel:

  • Conversion funnel: Tracks a prospect’s progressions as they move through the funnel and towards the desired outcome such as a conversion to a sales opportunity
  • Customer Acquisition funnel: This funnel stems from digital marketing data and tracks campaign efforts
  • Content Marketing funnel: Showcasing when a new contact downloads a piece of content and monitors their journey throughout the buyer’s journey

Regardless of your Marketing team’s structure, funnel charts are essential. To create the above mentioned funnels, you’ll need to combine data from your CRM, Marketing Automation, website analytics and digital marketing data.


By design, marketing dashboards are meant to deliver insights that drive action and data-informed decisions. To get the definitive guide to marketing dashboards, download the white paper, The CMO’s Guide to Marketing Dashboards.

This article was originally published on Astronomer’s blog and was updated and formatted for Medium. Click here to read the original blog post, 6 Dashboards Every Marketer Needs.

The Astronomer Journey

The team behind Astronomer, a modern data engineering platform.


Written by


Cloud-based data exploration for all. Easily connect your data and create dashboards, without any SQL knowledge.

The Astronomer Journey

The team behind Astronomer, a modern data engineering platform.