An Introduction to Data
Visualization for Marketers
Table of Contents
Introduction 3
Measure All Your Marketing in One Place 4
The Importance of Data as a Marketer 5
Types of Data Visualization 8
Data Visualization for Internal Teams and Stakeholders 21
Data Visualization for External Stakeholders and Public Audiences 24
Data Visualization Tools and Resources 26
6 Dos and Don'ts of Data Visualization 35
Closing 36
HubSpot Marketing Analytics 36
2
An Introduction to Data Visualization for Marketers
Introduction
What is data visualization and why is it important?
Your data is only as good as your ability to understand and communicate it. You need to be able to
understand and effectively tell the story behind the numbers. The right data with the wrong visual is
useless and can even mislead your audience. Ever heard of the 1954 book, How to Lie with Statistics?
(Spoiler: it’s actually a helpful book for those learning about statistics and contains a lot of really
useful info.)
When you can (correctly) visualize your data using graphs and charts, you’ll be more likely to uncover
patterns, correlations, and outliers, communicate insights to your boss, your team, company, or social
media audience, and make data-backed decisions.
With a few simple statistics, data, and spreadsheet lessons – and a few of our favorite tools of the
trade – this guide will teach you how to create data visualizations like a pro. You’ll learn the best ways
to present different types of data, the importance of data as a marketer (for both internal and external
stakeholders), and tips on analyzing and displaying your data effectively.
If your technical skills don’t extend much beyond Microsoft Excel, then
check out the list of the best data visualization tools we’ve included as well.
Ready to make a big impact with your data? Let’s jump right in.
3
An Introduction to Data Visualization for Marketers
Measure All Your Marketing in One Place
HubSpot’s software includes a powerful analytics platform that automatically
connects your marketing activities to individual contacts, allowing you to see
the ROI for every campaign. Run custom reports or use HubSpot’s built-in
reports and start using data to grow your business.
Learn more
4
An Introduction to Data Visualization for Marketers
The Importance of Data as a Marketer
Data is information meant to be analyzed organization and analysis, you can take action and
and “used to help decision-making,” per the help your team with data-backed decision-making.
Cambridge Dictionary.
Data visualization refers to showcasing data, numbers,
As a business, you are collecting data every day, and statistics through images and charts. When
from website visitor locations, to social media you display data visually, you can more easily tease
followers, to sales by region. By uncovering the out meaningful patterns from a set of otherwise
right information and pairing it with the right data indecipherable numbers, and draw conclusions
leading to informed decisions.
Data visualization refers to showcasing data,
numbers, and statistics through images and charts.
When you display data visually, you can more easily
tease out meaningful patterns from a set of otherwise
indecipherable numbers, and draw conclusions
leading to informed decisions.
Pro Tip: HubSpot Academy offers a free course .
on measuring and analyzing your content.
5
An Introduction to Data Visualization for Marketers
Here’s a simple example of using data visualization. The chart below shows sports
franchises by value, which are then plotted against championships and years competing.
Source: HubSpot
Each circle shows the franchise’s value and the color shows the sport. You may expect
American football to be those big yellow circles, but in fact, soccer is the most valuable
sport worldwide. Data visualization can show trends on a larger scale and include several
variables, revealing interesting findings!
6
An Introduction to Data Visualization for Marketers
Data visualization is especially helpful when you're presenting data to
others. You can more easily identify trends, answer questions, prove
theories, and—if you’re creating them for a business—showcase your
brand. When you visualize your data, you can more easily see numbers
in context and understand how they relate to one another.
When it comes to processing information, we are wired to
comprehend images much faster and more easily than text.
According to research from the American Management
Association, when paired with visuals, information is 70%
easier to remember than when displayed as text alone.
Marketers can use data visualization to showcase the results of a
campaign or better analyze results from a customer survey, thereby
affecting your marketing and sales strategy or budget decisions.
Arming yourself with data, you can impress key stakeholders by
proving the worth of your campaigns via ROI reporting, show how
you’ve reduced cost per acquisition with your organic SEO strategies,
or fight for more budget for your social team after showcasing their
audience growth and reach.
7
An Introduction to Data Visualization for Marketers
Types of Data Visualization
You can use data visualization to display part-to-whole data, ranking, correlation, geographical
distribution, deviation, timelines, and scale. You can compare your company’s growth over time to your
inspiration brand or competitor. Data can represent survey results, or common keywords in customer
service tickets, indicating where your product team may need to make improvements.
Look at the following data set.
Displayed as a simple spreadsheet
of numbers, the impact of this image
would not shine through.
When looking at this data as an
area chart stacked up against
each other, over time, and using
different colors, the audience is
able to clearly see how the makeup
of today’s society has changed
from what it looked like
100 years ago.
Source: Udacity
8
An Introduction to Data Visualization for Marketers
Types of data visualizations
Common types of data visualizations include charts, graphs, maps, and tables. You’ll often see many data visualizations
included in infographics, and data can be animated or coded to be manipulated and reveal data slowly or over time.
1 Bar Graphs
Bar graphs are very versatile, they’re best used to show change over time,
compare different categories, or compare parts of a whole.
Source: HubSpot
9
An Introduction to Data Visualization for Marketers
2 Pie Charts
Pie charts are best used for making part-to-whole comparisons with discrete
or continuous data. They are most impactful with a small data set.
Source: HubSpot
10
An Introduction to Data Visualization for Marketers
3 Line Graphs
Line graphs are used to show time-series relationships with continuous
data. They help show trends, acceleration, deceleration, and volatility.
Source: HubSpot
11
An Introduction to Data Visualization for Marketers
4 Area Charts
Area charts also depict a time-series relationship, but they’re
different than line charts in that they can represent volume.
Source: HubSpot
12
An Introduction to Data Visualization for Marketers
5 Scatter Plots
Scatter plots show the relationship between items based on two sets of variables.
They are best used to show correlation in a large amount of data.
Source: HubSpot
13
An Introduction to Data Visualization for Marketers
6 Bubble Charts
Bubble charts are good for displaying nominal comparisons or ranking relationships.
They showcase three variables of data and are a combo of a scatterplot and a proportional
area chart. These are helpful in comparing multiple data points on the same chart.
Source: HubSpot
14
An Introduction to Data Visualization for Marketers
7 Heat Maps
Heat maps display categorical data, using intensity of color to
represent values of geographical areas or data tables.
Source: HubSpot
15
An Introduction to Data Visualization for Marketers
8 Geographical Maps
Maps plotting data on geographical maps, showing the distribution of data across regions.
Source: HubSpot
16
An Introduction to Data Visualization for Marketers
9 Tables
Tables are a simple way to quickly compare sales by sales representative, like the table
below, or see where your top deals or blog views are coming from.
Source: HubSpot
17
An Introduction to Data Visualization for Marketers
Waterfall Charts
Source: HubSpot
10
Waterfall charts show value
over time and how various
cohorts perform over time.
11 Pictograms
Source: Venngage
Pictograms are simple ways to
display statistics using icons.
18
An Introduction to Data Visualization for Marketers
When to use different types of data visualization
When considering the type of chart, graph, or map to use when displaying your data, first, think about what
you want to show, learn, or prove. When comparing two variables against the same data set, a column bar
chart, like the one below, allows you to compare both at the same time and easily see gaps.
Source: Excel Easy
19
An Introduction to Data Visualization for Marketers
Source: EDUCBA Source: Data Flair
To show how the breakdown of a whole looks, like the
visitors on your homepage by location, or sources for blog
views, try a map or an area chart.
To better understand the distribution of your data, and
Source: DevExpress
identify trends, outliers, and patterns, use a scatterplot
or a line graph.
Many types of charts and graphs can be used for
different types of data visualization. Try these ten
tips to enhance your data, like flipping your x and
y axis, using a different type of chart, or omitting
unrelated data points to better tell a story.
Bubble charts can help you better see the relationship
between multiple things and can help compare bigger
picture topics like budget. 20
An Introduction to Data Visualization for Marketers
Data Visualization for Internal
Teams and Stakeholders
Data visualization is an important tool for internal organic page views, page shares, time spent on the
meetings or stakeholders. Depending on your page, amount of posts read or scrolled through, and
team and goals, use data when presenting things leads generated from your posts. All of these would
like subscriber growth over time (perhaps month have their own report, and you’ll update them regularly
over month), or email open rates by subject line. to check on your progress.
No matter your role within your company’s If you use a tool like HubSpot for both your blog
marketing team, you will use data both to do your and reporting, you’ll be able to easily access built-in
job and present information about the projects reports like traffic for your blog by source.
you’re working on. Almost all marketing decisions
are data-backed. Data includes qualitative and
quantitative information and spans anything that
can be measured, collected, and analyzed.
For example, if you are responsible for content
marketing, you’ll have goals or KPIs (key
performance indicators). On a content marketing
team, these goals will likely be centered around
number of blog posts written, page ranking,
Source: HubSpot
21
An Introduction to Data Visualization for Marketers
Having accurate and simple reporting will help you both succeed in your job by identifying which
topics are resonating with which audience, but they’ll help you to prove your worth to your boss
and other internal stakeholders, like your boss’s boss when it comes time to ask for more budget or
resources to grow your content program.
Examples of marketing data visualization on internal teams
Content marketing data visualization SEO data visualization
Blog views by source Organic website traffic by source
Source: Klipfolio Source: HubSpot
22
An Introduction to Data Visualization for Marketers
Paid data visualization Email and customer data visualization
Average cost per click for ad campaigns Average number of emails opened by
by keyword customers each month
Source: OptinMonster
Social media data visualization
Followers over time by network in a bubble graph
Source: Adbadger
23
An Introduction to Data Visualization for Marketers Source: Business2Community
Data Visualization for External
Stakeholders and Public Audiences
Data visualization will play a crucial part in your company’s annual reports, infographics, case studies,
benchmark reports, and more. With the right data and presentation, your company’s benchmark report could
become a key resource for other marketers in your industry, thus improving your company’s authority and
ranking for the report.
For example, let’s say you work on your company’s sales enablement team.
You likely create case studies and testimonials from your most successful clients.
Data visualization can help you to show the impact of how your product or service affected your client’s
metrics, like HubSpot’s Rock and Roll Hall of Fame case study below.
This line chart visualization shows the
bump in messages received, which led to
an 81% increase in their audience size.
Using data helps to bring the message
home and can help your sales
representatives close deals, illustrate
your product’s efficacy, and showcase
your brand on social media.
Source: HubSpot
24
An Introduction to Data Visualization for Marketers
Data visualization can be used in public-facing PDFs, case
Pro Tip: Ask your design team to create a .
studies, website pages, and reports. Make sure to sync up with
set of approved chart or graph templates
your brand team to ensure that any designs match with your
that are style-guide approved! These can
brand’s approved style guide.
be created in Excel or Google Sheets.
Examples of external data visualizations:
Annual report Benchmark report Statistics Statistics
Source: Toast
Source: Mixpanel
Source: Shopify Source: WHO
You can also use data visualization Case studies Social media images Follower data
for these reasons:
PDFs User data
25
An Introduction to Data Visualization for Marketers
Data Visualization Tools and Resources
To get started with data visualization, you’ll need some data. Many
CMSs and blogging tools have some built-in reporting, or you may
use a tool like Google Analytics to collect website data. Once you’ve
collected your data by exporting it from any number of tools (including
social media platforms, paid advertising platforms, customer data,
survey results, and more), you can use Microsoft Excel or Google
Sheets to get yourself familiar with organizing data.
You’ll need to learn a few key functions and formulas in order to get
your data to a place where you can start to identify trends and statistics.
Here’s a complete guide to Excel that will walk you through filters, piv-
ot tables, vlookups, and other functions that are fairly universal across
all versions of Excel and Google Sheets. Using pivot tables, you can
cross reference your data quickly and easily, and save yourself lots of
time doing manual work.
Once you’ve deleted all the irrelevant data, filtered what you need, and
created some preliminary tables, pivot tables, and sheets, you’re ready
to start making and spiffing up your visualizations.
26
An Introduction to Data Visualization for Marketers
Data Visualization Tools
There are many different tools and data visualization
software out there that you can use at varying levels of
expertise to analyze and present data. Microsoft Excel
and Google Sheets offer basic visualizations and allow
you to easily create pivot tables, charts, and graphs, and
see how the data presents.
After you’ve gotten comfortable with the ability to
manipulate the data and pore through trends, charts, and
graphics, it’s time to get fancy design and create charts
worthy of sharing. Start out with HubSpot’s Graphic
Design Essentials course, where you’ll learn color theory,
graphic design tools, and composing images within a
brand identity and style guide. After that, you can use a
tool like Canva to make additional branded charts and
social images.
When it comes to internal reporting, you can use your
CMS’s internal reporting and analytics options, like
HubSpot’s analytics dashboard, or external tools like
Google Analytics or Hotjar, a heatmapping software.
27
An Introduction to Data Visualization for Marketers
Here are some of the top data visualization and animation tools.
» Microsoft Excel
This is the most common tool for data visualization. Excel allows you to sort
and analyze data, then create data visualization using the chart wizard.
To learn more about using Excel, check out these resources below.
Source: Excel
28
An Introduction to Data Visualization for Marketers
» Statista
Statista is a database of studies, statistics, and forecasts that
provide market data for presentations.
Source: Statista
29
An Introduction to Data Visualization for Marketers
» Google Trends
Google Trends is a free tool from Google that shows search history of certain topics
and keywords over time. You can evaluate the popularity of certain terms, compare
them against other keyword variations, analyze how their popularity varies over
time and in different regions/languages, and shows related keywords, which can be
helpful in getting new keyword suggestions.
Source: Google Trends
30
An Introduction to Data Visualization for Marketers
» Canva
Canva is a really easy-to-use free tool with a new charts feature for creating
simple pie charts, bar graphs, and more in any sized template. This is a
great option for creating presentations, infographics, and social images.
Source: Canva
31
An Introduction to Data Visualization for Marketers
» Google Charts and Google Sheets:
Google Charts lets you embed graphs and charts onto a web page. It is an API tool
that lets you create custom graphs and charts with the option to animate them for
a more dynamic visualization. Google Sheets is a good option for creating simple
charts and graphs like you would in Excel.
Source: Google Charts
32
An Introduction to Data Visualization for Marketers
» HubSpot Analytics (or your CMS’s analytics tool)
Pull custom reports or use HubSpot’s own reports, then update your charts to your liking.
Source: HubSpot
» HubSpot Academy’s Course on Graphic Design Essentials
Learn the basics of graphic design and create the most visually appealing charts
and graphs for public-facing data content.
Source: HubSpot
33
An Introduction to Data Visualization for Marketers
» Google Analytics
Analyzes your website visitors and provides a live dashboard with data
visualization, charts, and graphs of your visitors’ behavior and actions.
Source: Google Chrome
34
An Introduction to Data Visualization for Marketers
6 Dos and Don'ts of Data Visualization
Dos Don'ts
9 Use colors to help enhance trends. 8 Overwhelm the viewer with bright colors
that clash.
9 Include statistics in readable formats for
those with vision difficulties and with 8 Forget to include the precise numbers and
precise numbers. only include charts without percentages.
9 Use data from the past five years. 8 Use data older than five years old.
9 Compare your data to previous 8 Lose your data as soon as you present it.
benchmarks.
8 Present your data out of order, forcing the
9 Present your data in an organized order audience
that helps the reader see trends. to dig for conclusions themselves.
9 Go for readability, include data markers 8 Go for aesthetic or visual appeal over
and percentages when applicable. practicality and readability.
35
An Introduction to Data Visualization for Marketers
Closing
Data visualization can seem difficult and
overwhelming, but with the tools and resources
provided in this guide, you will be ready to start
creating compelling data visualizations, persuasive
presentations, and find trends in the data you
already have.
Data can compel people to change global health
outcomes or affect perceptions. It can also help
HubSpot Marketing
marketing teams to create data-backed campaigns Analytics
and only invest in opportunities that are trackable
and can prove their own ROI. With data visualization, HubSpot’s data analysis tools allow you to access
you can share what you’ve discovered and showcase and customize a live reporting dashboard that
the research you’ve done in a visually appealing spans marketing and sales. Stay on top of your site’s
and effective way. With data on your side, you’ll help performance, find out where you’re generating the
to create an exponential uptick in marketing team most value, and learn how to recreate your best
performance, then show it off with your newfound performing campaigns by diving into the data.
ability to create incredible charts!
See what HubSpot
reporting can do
36
An Introduction to Data Visualization for Marketers