• Home
  • Tools
    • PPC Signal
    • PPCexpo Keyword Planner
    • PPC Audit
    • ChartExpoTM PPC Charts
    • PPCexpo PPC Reports
    • Combinations Calculator
  • Pricing
  • Contact us
  • Resources
    • PPC Signal Dashboard
    • PPC Reports Templates
    • PPC Guide
    • Join Our Facebook Group
    • Charts
      • CSAT Score Survey Chart
      • Likert Scale Chart
      • Pareto Chart
      • Sankey Diagram
  • Blog
Categories
All Digital Marketing PPC SEO SMM Data Visualization
All Digital Marketing PPC SEO SMM Data Visualization

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok
Home > Blog > Digital Marketing > Data Visualization >

Storytelling With Data: A Comprehensive Guide for Busy Professionals

Any great story means great details and strategic use of visuals.

Let’s face it: Numbers bore people to death. And it is this particular reason you need to start storytelling with data. Stories have a profound effect on people. Yes, tell a tale compellingly, and you’ll have the full attention of everyone around you.

Storytelling with Data

People do love stories.

And if you want to take storytelling to a whole new level, try strategically incorporating images.

You see, the human brain processes visual content over 60,000 times faster than texts and numbers. And this creates a strong case for incorporating relevant visuals into your data story.

Storytelling with data can be intimidating, especially if you’re not an expert in data visualization. To create a compelling data story, you need a strategy, a plan, THE BIG IDEA, and most importantly, an easy-to-use visualization tool.

Storytelling with DataStorytelling with Data

In this blog post, we’ve rounded up thought-provoking tips, how-to, never-heard-before strategies, and other ingredients that will help you make your data story more compelling for audiences. And these tips do work. We use them to create compelling and actionable narratives for our clients, presentations, and meetings. And every time we use them, we get an overwhelming response.

We hope you’ll gain immense value from the blog.

Data Storytelling Using Visualization

Understanding and translating data into meaningful insights is crucial in any setting. And this is not limited to research, digital marketing, and business management. So if you aren’t connecting that information to your audience, they’ll have very little motivation to act on it.

And this is where data storytelling comes in.

Data stories help you communicate critical insights clearly and compellingly—driving change and inspiring action. If telling a story doesn’t come naturally to your analytical mind, you’re not alone. And luckily, you don’t have to be an English major to tell a good data story.

So what does it mean to “tell a story with your data?

Keep reading to discover more.

What is Storytelling with Data?

Data stories are narratives that explain how and why data changes over time—often through visuals. But data storytelling isn’t just about making great charts and data presentations.

It’s about communicating insights that deliver real value. And this should be accompanied by clarity and simplicity.

Compelling data narratives have three main elements, mentioned below:

  • Data
  • Visuals
  • Narrative

If you combine these elements strategically using tips you’ll learn in this blog post: you’ll have a compelling data story. And it doesn’t matter your audience provided you keep the context relevant and communication simple with a call-to-action (CTA) at the end.

There’s a tendency by some of you to use data visualization interchangeably with storytelling with data. The following section will clear the air by bringing out clear and practical distinctions.

Storytelling with DataStorytelling with Data

Data Stories vs. Data Visualization

Data stories and visualizations are connected but really distinct. Well, data visualization is simply a visual representation of information.

Visuals play an essential role in telling a story and communicating critical pieces of information. But the data narratives put that information into context and share why it matters and what actions to take. So data stories connect the audience with the data.

On the other hand, data visualizations support and enhance data stories, helping you communicate your insights elegantly and in an easy-to-understand way.

Now that you’ve learned about the distinction between data storytelling and visualization: Let’s jump to the following equally important section. Why do data stories matter to you?

Why is Storytelling with Data Important?

Data without a story lacks impact for two reasons, namely:

The data seldom comes distilled. And this means you don’t necessarily need more data to solve your problems or uncover opportunities. But you do need to identify and communicate value from the data you already have.

And secondly, data doesn’t support a BIG Idea. And this makes it difficult for our audience to grasp the actionable “news” it brings quickly.

  • Stories Attract and Maintain People’s Attention for Long

We live in a world characterized by a gazillion of information, ads, trend news, etc. And besides, with socioeconomic problems the current Coronavirus global pandemic has come with, such as mass loss of jobs, we’ve turned into a day-dreaming generation.

And it’s not surprising to see people nod as you speak but in reality they’re very far mentally. So it takes strategic use of emotional triggers, such as captivating narratives, to awaken people, or capture their full attention.

Just picture yourself in an afternoon meeting looking at Bob from the Finance Department presenting company revenue projections with massive tables. And don’t forget to add Bob’s bland demeanor to the mix.

So if you have numbers and want to explain their changes to any form of the audience (including engineers): use stories. And you’ll find your audience taking action you desire at the end of it all.

  • Numbers Without Stories are Boring

Like we said earlier, numbers without stories are pretty much noise. So if you want your audience to rent their ears to you, you need to arouse their emotions. And stories have been tested and proven to do so.

Let’s revisit the audiences with an engineering background. For starters, people in this profession are very analytical. And in other words, they’re the typical ‘show me the numbers’ guys in your office. Engineers, too, are humans capable of feeling emotions, albeit their profession has socialized them to be analytical.

Engineers with a sales background know how powerful stories can be, especially when marketing to fellow engineers.

So you need stories to transform your data into actionable insights to empower data-driven decision-making in your organization.

So let’s agree that numbers without captivating narratives are pretty dry and less attractive to audiences. And this brings us to the other crucial benefit.

  • Stories Communicate Insights with Unmatched Clarity

One of the core ingredients of a compelling story is simplicity in details. You might have stumbled upon a fascinating insight in your data that either communicates opportunity or impending risks. But your problem is to share these insights with the decision-makers for action-taking.

You use data narrative for change. There’s no doubt that stories can lead your audiences in the direction you want.

Now you have a clue about why data stories matter to you. So let’s delve into its core building blocks.

Top 6 Most Essential Elements In Data Storytelling

Below are essential tips you need to incorporate into your data narrative to make it more compelling.

  • Clutter is your Enemy

Picture a blank page or a blank screen.

And every single element you add to that page or screen takes up cognitive load on the part of your audience. In other words, it takes brainpower to process.

So you want to take a discerning look at the visual elements you allow into your data story. Start by identifying stuff that isn’t adding informative value or adding enough informative value to make up for its presence. And eliminate them without mercy.

Identifying and eliminating such clutter is the focus of this section.

Clutter is the #1 enemy of a compelling data story. And there’s a tendency by a majority of analysts to cram too much information into a single chart. Yet this is a very harmful practice because it distorts the insights you’re trying to communicate.

Tips

The design and other irrelevant stuff in your chart should fade away in the background. And this will allow your audience to grasp the insights you want.

Let’s agree on this one: keep your charts clutter-free for your audience to grasp insights instantly.

  • Choose an Effective and Relevant Chart

There are many different graphs and other types of visual displays of information. But only a handful will work for the majority of your needs.

Looking back over the number of visuals that we’ve created for workshops, client meetings, and consulting projects in the past years, we’ve only used slightly over a dozen.

Choosing the best chart possible to embody your data story boils down to your goals. Yes, it depends on the BIG IDEA you want to communicate to your audiences.

Let’s admit it. We’ve all been victims of boring, long, and disorganized presentations and meetings. One of the biggest fails in storytelling with data is the random use of charts.

Different charts come with different uses. So your choice of data is influenced by multiple factors, such as audience type, nature of the data, and most importantly, the main goal.

Check out the summary of charts and their relevant application.

    • Heat Maps: Heat maps transform tabular data into an easy-to-read visualization chart. So if your data is in tables, using a heat map is really a good idea.
Storytelling with Data
  • Graphs: These charts interact without our visual system, which is faster at processing information. There are 4 types of graphs, namely.
    • Area graphs: These charts are appealing to human eyes, especially if you want to communicate differences in variables (comparison)
    • Bar graphs: Use these charts to communicate differences in variable categories with clarity. And they include bar charts.
    • Line graphs: These charts are best used to visualize continuous data.
    • Slope Graphs: These charts come in handy if you want to compare variables or different times.
    • Point graphs: These charts are used to depict the relationship between two variables. And they include the Scatter Plot, among others.
  • Focus on the Attention of your Audiences

We’re sure you get motivated to tell your story more and more if people are listening. Yes, the listening factor matters a lot to the progress of any story.

Just imagine trying to communicate a story to people who aren’t paying attention. It hurts, right? In data storytelling, you can refocus your audience’s attention to particular insights with strategic use of colors and the size of the chart.

Take a look at the screenshot below: How many 3s are there in the cluster of numbers shown below?

Storytelling with Data

Now, answer the question above using the screenshot below. How many 3s are there in our data?

Storytelling with Data

Of course, it’s easier to spot the answers. And this is because of strategic highlighting of the details we want you to see. Similarly, you should deploy this strategy of highlighting the insights you want your listeners to take home when storytelling with data.

Rather than let them do all the work, make the findings low-hanging and easier to cherry pick with strategic use of colors. And this brings us to the other crucial element that can make or break your data story.

  • Importance of Context in Data Stories

Storytelling with data requires context. And this context has two elements:

  • The point you’re trying to make.
  • The audience you’re addressing.

Most likely, someone has asked you to explain why something has happened, such as why customers are churning. So this question serves as the basis for your hypothesis and the data you’ll use to answer the question.

Ideally, you’ll start by defining the problem. And it’s by defining the problem you’re seeking the solution for; you’ll get precise traction of your data story.

Storytelling with DataStorytelling with Data

The second important part of the context is the audience. Yes, the audience type influences the type of data visualization and storytelling language you use. For instance, the charts you would use for non-technical audiences need to be simple and straightforward at best. And this means you have to balance between not cluttering your chart with details and being informative at the same time.

  • The Big Idea

The big idea is more of the theme of your presentation.  Essentially, this is the part that answers the famous ‘So what?’ question.

For instance, if you’ve just discovered that sales in December and January have taken a slump, the reason why would be a BIG idea.

“During December and January, our sales took a nosedive by 45%, thereby erasing all the gains we made in the third quarter. And this is because of an increase in the number of product returns and refunds. So my recommendation is: there’s a need to investigate further into the product development process to know the cause of the money-draining problem”.

For you to create a compelling big idea, you’ve got to know your presentation very well. And I mean inside-out. The section can boil down into a sentence or a paragraph.

And this brings us to the critical part of your data story: the action you want your audience to take.

  • Call for Action

Insights have little value if you don’t recommend action, such as whether to invest or divest.

Imagine you’ve already explained what your data story is about and why it matters in some detail. But what should your audience do with this information?

Suppose Internet customers are churning because their connections are dropping too often. Should the company invest in the latest fiber optic cables or focus their marketing efforts only on specific areas?

The alternative is providing decision-makers with a set of choices or recommendations for them to make data-driven and informed decisions.

Providing actionable information is, after all, the goal of good data visualization and storytelling. And it’s thinking through the layers and making sure there’s continuity between where your story starts and its ending.

After doing all this, how do you make your story compelling? This other section provides you with the fundamental building blocks of a story.

Storytelling with DataStorytelling with Data

Data Visualization And Storytelling: Which Is The Right Chart?

So what makes a good story?

When you see a great play, watch a captivating movie, or read a fantastic book, you’ve experienced the magic of the story.

A compelling story grabs your attention and takes you on a journey, evoking an emotional response. And in the middle of it, you find yourself not wanting to turn away or put it down. After finishing it—a day, a week, or even a month later—you could easily describe it to a friend.

Wouldn’t it be great if you could ignite such energy and emotion in your audiences?

The story is a time‐tested structure; humans have been communicating with stories throughout history. Aristotle recognized the impact of stories centuries ago. And he went ahead and provided the building blocks of a captivating story. And they include:

  • Settings of a story
  • The brewing of conflict between protagonist and antagonist
  • Conflict resolution
  • The transformation (post-conflict period)

The first section sets up the story. And it introduces the protagonist, their relationships, and the world in which they live. After this setup, the main character is confronted with an incident.

Tips

The attempt to deal with this incident typically leads to a more dramatic situation. And this is known as the first turning point. The first turning point ensures that life will never be the same for the main character. And it raises the dramatic question—framed in terms of the main character’s call to action—to be answered in the climax of the story.

The second section makes up the bulk of the story. And it depicts the main character’s attempt to resolve the problem created through the first turning point.

Often, the main character lacks the skills to deal with the problem he faces and, as a result, finds himself encountering increasingly worsening situations. And this is known as the character arc, where the main character goes through significant changes in life due to what is happening.

The protagonist may have to learn new skills or reach a higher sense of awareness of who he is. And what he is capable of to deal with his situation.

The third section resolves the story and its subplots. And it includes a climax, where the tensions of the story reach the highest point of intensity. And finally, the dramatic question introduced in the first act is answered, leaving the protagonist and other characters with a new sense of life.

So there’s no need to reinvent the wheel in storytelling. Just use the centuries-old template to create a compelling data story for your audience.

Storytelling with DataStorytelling with Data

What’s Not Data Storytelling?

Data storytelling is a powerful tool for engaging stakeholders and inspiring action. However, when done incorrectly, it can lead to incomplete or misleading information and conclusions. And besides, it’s not a tool for propagating unethical persuasion or distributing propaganda with ill motives.

So storytelling with data should never lie, mislead, or misrepresent data. As you develop your data stories and visualize your data, don’t:

  • Cherry-pick data. Avoid showing the data that best supports your ideas: show the whole picture.
  • Manipulate scale. When visualizing data, don’t pick arbitrary variables to base your scale and units. You have an ethical obligation to present full context visually.
  • Be inconsistent. Avoid prioritizing aesthetics over communication. So avoid changing colors, labels, and conventions between visuals. And this is because inconsistencies across visuals and language can be confusing.

And besides, it’s difficult for your audience to follow the story and understand the data accurately.

Data-driven storytelling is a powerful way to:

  • Communicate complex ideas
  • Create buy-in
  • Inform better decision-making for leaders at every level.

By combining best practices in visualization, data analysis, and storytelling, you can create compelling data stories that inspire change.

To summarize this section: ensure you’re telling the whole story. And always use good data from credible sources to inform your interpretations and conclusions, and always provide context.

How to Tell a Story with Your Data?

So, how do you tell it effectively?

Use the steps below to get started.

  1. Identify your Story

The first step to telling a good data story is to uncover a story worth telling. And you can start by asking a question or forming a hypothesis, then compiling and digging into relevant data to find answers.

As you consider your data story, ask:

  • What are you trying to explain? 
  • What are your goals? 

There are several ways to approach data to uncover a story—and the story you set out to tell may not end up being the story you find. As you analyze your data, consider using the following approaches to help you identify a theme and develop a structure for your story:

  • Look for Relationships Between Variables

What connections do you see between data? And are there interesting or surprising correlations?

These relationships can provide a compelling foundation for a story.

  • Identify Trends in your Data

Trends indicate the direction of change. And it can go either upwards or downwards. For example, is there growth in a particular product or service your business offers? Or maybe you want to know your website traffic patterns over time—you may discover that certain days or times tend to be higher or lower volume.

Identifying new or evolving trends in your data is crucial.

  • Draw Comparisons Between Variables

Comparisons can help you uncover interesting correlations and understand how data relates to one another and why.

For example, you might compare open rates for two different email subject lines to see which subject line was more effective.

  • Look for Outliers

Outliers are one-off occurrences that you may spot in your data. And data that doesn’t fit in with the rest of your data settings can be just as valuable for you.

Look for outliers and ask questions.

Why is the data behaving that way? And what is the cause? You’ll uncover more interesting (and valuable) insights.

  • Pay Attention To Noise

Pay attention to any data that is counterintuitive or surprises you.

Are there any results that you didn’t expect?

What might cause those results? Some of the most compelling stories are those that are unexpected.

Storytelling with DataStorytelling with Data

  2. Mind your Audience

Always be aware of your audience when developing and sharing your data narratives. And if the story you want to tell isn’t relevant or interesting to your intended audience, it won’t have the impact you want.

As you build your data narrative, ask yourself:

  • Who is my audience?
  • Is this story relevant to my audience? Does it solve a problem they care about or provide needed insight?
  • Have they heard this story before?

Your audience’s age, demographics, job, and subject matter expertise influence how they understand and respond to your stories (and should inform how you tell your narrative).

So if you are speaking to a room full of engineers, you may want to provide more technical details and dig into the data sets more thoroughly as you tell a story. However, an audience of executives will likely be looking for simplified data with clear insights.

Develop a habit of customizing your story and approach it from different angles depending on your audience.

  3. Build your Story Bottom Up

With your data in hand and your audience in mind, you can start developing a story.

Consider:

  • Who are you talking to?
  • What do you want your audience to know or do?
  • How can you use your data to make your point?

A compelling story isn’t just an explanation of your data. So it should take your audience on a journey. And to do this, you need to follow this basic formula mentioned earlier:

Tips

  4. Use Visuals to Complement your Data Story

And lastly, a good data story needs visuals. And visuals are a powerful way to engage your audience and improve retention—especially when communicating with non-technical audiences.

Visualizing your data story enhances understanding at every level. So storytelling with data visualization helps you:

  • Simplify the information
  • Highlight the most important data
  • Communicate critical insights quickly. 

There are many ways to visualize your data, including:

  • Flowcharts
  • Bar graphs
  • Infographics
  • Pie charts
  • Scatterplots

And choosing relevant and easy-to-interpret charts make it easy for your audience to understand and engage with the data.

And this brings us to the meaty part of the blog: the best tool to use to create compelling charts that complement your story.

Please pay attention because this is one of the essential parts of the blog.

Storytelling with DataStorytelling with Data

Visualization Tools in Data Storytelling

Congratulations if you’ve reached this section. Keep in mind this section can single-handedly decide whether your story is captivating to the audience or not.

Remember, our brains process visual data over 60,000 times faster than texts and numbers.

So your choice of the visual chart to be used matters a lot. And to emphasize this point: you don’t want to use visuals that are barely supporting your data narrative due to their complexity. You want to choose a visualization chart that’s easy to understand and straightforward irrespective of the audience.

And this is because you don’t want to take chances with your audiences. Simplicity sells. So keep it stupid simple (KISS).

Your audience will not only appreciate your presentation but will also take the action you intend them to. In other words, you’ll have sold your idea, suggestion, solution, or recommendations successfully to your audience.

So you need a tool that can help you create easy-to-read and understand charts. Besides, you need a visualization tool that grants you the freedom to highlight the insights you want your audience to take home. And most importantly, you want a tool that’s considerate to your budget.

I already use Google Sheets for my visualization needs.

If the above statement is what is already running in your mind, it’s very understandable.

Yes, you can use Google Sheets to take care of your visualization needs at NO cost. And besides, this tool comes with a friendly and familiar user interface (UI).

However, it also comes with WEAKNESSES that can break your data story.

  • Firstly, Google Sheet’s library of chart templates is very SMALL. And this limits the options of the charts you can use depending on your target audience. Remember, you need a more comprehensive range of chart templates to test and decide the best one.
  • The resulting charts are not always beautiful and intuitive. And this means you have to spend additional time trying to customize them to complement your data story seamlessly.

We have a way of eliminating all these weaknesses to make your Google Sheets a powerful visualization tool. And the next section will address this fully. Keep reading.

So what’s the Solution?

We have an add-on for Google Sheet that and Excel has been created ground-up purposely to transform your Google Sheets into an incredibly reliable visualization monster. And the name of this highly affordable and easy-to-use tool is called ChartExpo.

So What is ChartExpo?

ChartExpo is a cloud-hosted add-on that transforms Google Sheets into a highly responsive data visualization tool.

Wait! That’s not all. 

So this highly affordable data visualization tool comes with over 50 chart templates to grant you a broader choice of visuals to select. With ChartExpo, you don’t need to know programming or coding. Yes, it’s that easy peasy to use.

Storytelling with DataStorytelling with Data

So when you are creating a data story, know you have a reliable data visualization buddy on your side. ChartExpo provides you unlimited freedom to customize your charts. So you can highlight the key insights you want your audience to take in with ease.  A few mouse clicks and BOOM…And you have a chart that fits seamlessly within your data narrative.

What do I Gain from Using ChartExpo?

  • ChartExpo has an in-built library with over 50 custom charts designed purposely for pay-per-click (PPC) management.
  • ChartExpo has custom and intuitive charts to provide you with a 360-degree view of your client’s ad campaigns.
  • ChartExpo add-on for Google Sheets comes with a free 7-day trial.

Essentially, if you’re not satisfied with the tool within a week, you can opt out as quickly as signing up for a trial.

  • ChartExpo add-in is ONLY $10 a month after the end of the trial period.
  • You have a 100% guarantee that your computer or Google Sheets won’t be slowed down.
  • When you sign-up for a trial to use ChartExpo, you get a free audit on your clients’ PPC ad campaigns. 
  • You can export your beautiful, easy-to-read, and intuitive charts in JPEG and PNG, the world’s most-used formats for sharing images.

So How Do You Install ChartExpo Add-on in your Google Sheets?

To Get Started with ChartExpo for Google Sheets Add-on , follow the Simple and Easy Steps Below.

    • Open your Google Sheets desktop application.
    • Open the worksheet and click on the ‘Add-ons’ menu.
    • You’ll see the ‘ChartExpo’ option in the dropdown menu.
    • Click on ‘ChartExpo’ to install your Add-on.
Storytelling with Data
    • If you don’t, please click on the ‘Refresh’ button.
    • Again select ChartExpo add-on and click on the ‘Insert’ button
    • The add-on will be added to the Google Sheets application, as shown in the screenshot below.
    • Now you can start using ChartExpo for Google Sheets
    • Click on the Create New Chart to continue.
Storytelling with Data
  • You’ll see an extensive library of visual charts categorized into 6 different groups.
  • More so, you can expand any group by clicking on it to see a list of available visualizations.

How can You Visualize your Data using ChartExpo Add-on for Google Sheets?

Comparison Sentiment and Stacked Grid Charts are among the 80-plus chart templates you’ll find in ChartExpo. So, we’ll use these chart templates for demonstration purposes.

We want your data storytelling skills to improve significantly with the new tips and tools you’ve learned in this blog.

  • Comparison Sentiment Charts

    Storytelling with Data

As the name suggests, Comparison Sentiment Charts are used to compare sentiments, which may be positive or negative. And you can use this chart to visualize feedback data provided by customers.

So How do you Create this Chart using ChartExpo Add-on in Google Sheets?

Imagine you run a restaurant. And you want to know how your customers rate your services. And you’re doing this with a view of improving your overall service delivery to outdo the competition and grow your customer base. So you do a survey to collect the voice of the customer (VOC) data.

Let’s imagine you’ve been conducting surveys for three years running. And you want to know how each financial year compares to the other with regard to service delivery.

The table has the data that embodies our imagination (mentioned above).

Year Topic Positive Negative
2016 Quality of food 11 12
2016 Ease of ordering 29 50
2016 Services 20 33
2016 Parking 2 4
2016 Cleanness 55 12
2016 Ease of reading the menu 12 7
2016 wait time to be seated 16 11
2016 Seating space in waiting area 8 8
2016 menu and drink choices 4 3
2016 Attitude of Waiter 3 5
2016 Payment method 12 15
2017 Quality of food 15 12
2017 Ease of ordering 51 1
2017 Services 28 12
2017 Parking 4 2
2017 Cleanness 45 11
2017 Ease of reading the menu 12 8
2017 wait time to be seated 16 18
2017 Seating space in waiting area 13 18
2017 menu and drink choices 4 1
2017 Attitude of Waiter 3 8
2017 Payment method 17 16
2018 Quality of food 18 12
2018 Ease of ordering 59 20
2018 Services 30 10
2018 Parking 2 0
2018 Cleanness 55 7
2018 Ease of reading the menu 18 10
2018 wait time to be seated 22 14
2018 Seating space in waiting area 13 16
2018 menu and drink choices 4 1
2018 Attitude of Waiter 2 4
2018 Payment method 13 14

Let’s export our table to our visualization tool of choice –Google Sheets-loaded with ChartExpo to visualize this data.

Storytelling with Data
    • Comparison Sentiment Charts are found under the category of Comparison Analysis Charts, as shown below.
Storytelling with Data
    • Input your metrics and dimensions, as shown by the screenshot below.
Storytelling with Data
    • Click Create Chart
Storytelling with Data
  • After clicking Create Chart, your chart should look like the one above.

How easy was this?

Storytelling with DataStorytelling with Data

So How Do You Read This Chart?

Each survey question is ranked according to the sentiments gathered (both positive and negative). The question with the highest number of positive sentiments ranks higher. And on the other hand, questions with a vast number of negative sentiments rank lower.

In the last three financial years, the ease of ordering food and cleanliness have been interchanging in the top spot. And it seems customers love the hygiene level and convenience of making an order in the restaurant.

On the other hand, the quality of food and ease of reading menu seem to form the bulk of customers’ issues about the restaurant. And this means you need to address these issues if you want to scale to another level.

And this brings us to the second example.

We hope you’ve enjoyed what you’ve read so far.

  • Stacked Grid Chart

Storytelling with Data

You can use this chart to visualize comparisons between categories of variables in your data.

Imagine you’re running a PPC campaign on behalf of a client. You create a compelling visual chart that shows the performance of keywords across metrics, namely impressions, click, conversion, and cost per acquisition.

A Stacked Grid Chart can complement the data story you’ll be creating. Assume your end goal is to persuade the client in question to increase his marketing budget.

The data in the table below embodies our example above.

Category SubCategory Period Measure
Mobile Impressions Current 2470
Mobile Clicks Current 109
Mobile Conversions Current 3
Mobile Cost Current 2030.9
Smartphone Impressions Current 2459
Smartphone Clicks Current 35
Smartphone Conversions Current 1
Smartphone Cost Current 803.1
Phone Impressions Current 2256
Phone Clicks Current 112
Phone Conversions Current 4
Phone Cost Current 2160
Mobile Phones Impressions Current 1802
Mobile Phones Clicks Current 87
Mobile Phones Conversions Current 1
Mobile Phones Cost Current 1469.9
Cellphones Impressions Current 750
Cellphones Clicks Current 56
Cellphones Conversions Current 0
Cellphones Cost Current 531.1
Mobile shop Impressions Current 637
Mobile shop Clicks Current 58
Mobile shop Conversions Current 0
Mobile shop Cost Current 1559.6
Free phones Impressions Current 627
Free phones Clicks Current 38
Free phones Conversions Current 0
Free phones Cost Current 377.6
Prepaid Phones Impressions Current 626
Prepaid Phones Clicks Current 21
Prepaid Phones Conversions Current 2
Prepaid Phones Cost Current 488.4
Cheap Phones Impressions Current 619
Cheap Phones Clicks Current 47
Cheap Phones Conversions Current 0
Cheap Phones Cost Current 4024.3
New Phones Impressions Current 587
New Phones Clicks Current 21
New Phones Conversions Current 0
New Phones Cost Current 477
Latest Mobile Phones Impressions Current 474
Latest Mobile Phones Clicks Current 31
Latest Mobile Phones Conversions Current 2
Latest Mobile Phones Cost Current 586.6
Best Phone Impressions Current 445
Best Phone Clicks Current 23
Best Phone Conversions Current 0
Best Phone Cost Current 487.3
Mobile Price Impressions Current 440
Mobile Price Clicks Current 28
Mobile Price Conversions Current 4
Mobile Price Cost Current 565.4

Let’s export this data into our Google Sheets for visualization using ChartExpo Add-on. And then, let’s unleash the ChartExpo add-on to visualize this data using a Stacked  Grid Chart, as shown below.

Storytelling with Data

Find a Stacked Grid Chart template by pressing a tab called General Analysis Chart.

Storytelling with Data

After clicking the General Analysis Chart, you’ll come across multiple charts. Just browse through to find a Stacked Grid Chart template, as shown by the screenshot below.

Storytelling with Data

Input the relevant metrics and dimensions. In our case, the Measure will be our metric. And our dimensions will be:

  • Category
  • Subcategory
  • Period

Fill in the respective metrics and dimensions, as shown below:

Storytelling with Data

Complete the process by clicking the Create Chart button.

Congratulations if you’ve followed the steps and created your first Stack Grid Chart. The trick lies in practice. Practice more, and you’ll be an expert sooner than you know.

After clicking Create Chart, your resulting chart should look like this:

Storytelling with Data

Note: the length of the bars represents performance. So the more significant the bars, the amazing the performance is. And the vice versa is also true.

Insights

  • The keywords to target most and increase bidding are Mobile Price, Latest Mobile Phones, and Prepaid phone. And this is because these keywords have a lower cost per acquisition (CPA) and higher conversion levels.
  • The broad keywords: Mobile and Phone are driving sizable conversion, but their costs are high. However, the overall ROI makes them worthy of pursuing them despite their soaring CPCs.
  • The keyword Cheap Phone should be done away with altogether. And this is because it’s costly and has zero commercial value. And in fact, it should be added to the Negative Keyword list.
Storytelling with DataStorytelling with Data

Wrap Up

Understanding and translating data into meaningful insights is crucial in any setting. And storytelling is one of the tested and proven media for passing actionable insights to your audiences.

And this is because stories have an emotionally appealing effect on our minds. We all have a story to tell about something that matters to us. Data story telling can be done efficiently with ChartExpo Library.

How much did you enjoy this article?

We will help your ad reach the right person, at the right time

PPC Signal

Your Data. Your Insights.

Actionable insights discovered for you. Now you can do more in less time.

PPCexpo Keyword Planner

Find the Perfect Keyword. Surprise Yourself.

PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.

PPC Audit

Free Google Ads Audit Report.

Frequent audits will help you optimize your PPC campaign for success.

ChartExpo PPC Charts

Picture a Thousand Numbers. See the Big Picture.

Visualizations give you the ability to instantly grasp the insights hidden in your numbers.

PPCexpo PPC Reports

Simple and Easy PPC Reporting. For Everyone.

Experience the new revolution in reporting … click your way to insights, don’t scroll.

Combinations Calculator

Do the Math.

Calculate the number of combinations in your PPC campaign. It may surprise you.

Insightful pay-per-click tips and tricks, delivered to your inbox weekly.

CTR Survey

ppc signal ad
chartexpo ad
ppc audit ad
keyword planner ad
116618

Related articles

next previous
Data Visualization7 min read

How to Visualize Data Using Pandemic Comparison Chart?

Click to learn how to get started with a pandemic comparison chart also to know about what is the trend of Covid-19 based on a graph?

Data Visualization7 min read

How to Create a Stacked Area Chart in Excel?

Click to learn how to plot a Stacked Area Chart in Excel. You’ll also learn how to read a Stacked Area Chart.

Data Visualization10 min read

Top 5 Google Sheets Charts for Your Data Stories

Click to learn the top 5 Google Sheets Charts for your data stories. Also, we’ll address the following question: what are Google Sheets Charts.

Data Visualization12 min read

Business Intelligence vs. Data Analytics: What's the Difference?

Click to learn about business intelligence vs. data analytics differences. We’ll also address the following question: what is business intelligence?

Data Visualization11 min read

Top 5 Types of Business Charts You Must Try

Click to discover the top 5 types of business charts you must try to present your data well.

PPCexpo

  • Home
  • Tools
  • Pricing
  • Contact us
  • PPC Guide
  • Blog
  • Sitemap
  • © 2022 PPCexpo, all rights reserved.

Company

  • Contact us
  • Privacy policy
  • Security
  • Patent

Tools

  • PPC Signal
  • PPCexpo Keyword Planner
  • PPC Audit
  • ChartExpo™ PPC Charts
  • PPCexpo PPC Reports
  • Combinations Calculator

Quick Links

  • PPC Guide
  • PPC Signal Dashboard
  • PPC Reports Templates
  • ChartExpo™ for Google Sheets
  • ChartExpo™ for Microsoft Excel
  • PPCexpo Keyword Planner Google Chrome Extension

Charts

  • CSAT Score Survey Chart
  • Likert Scale Chart
  • Pareto Chart
  • Sankey Diagram

Category

  • PPC
  • SEM
  • SEO
  • SMM
  • Data Visualization
  • Others
Join our group

Benefits

  • Q&A on PPC advertising
  • Get expert advice
  • Great PPC discussions
  • Stay updated with PPC news
  • Quick support on tools
  • Discounts and special offers