This guide will show you how to collate, analyze and interpret complex data sets to maximize growth, and drive more revenue across your business.
The HubSpot CRM platform lets you see all of your data in one place, making it easy to get a full picture of business performance on the fly. It also allows you to easily integrate some of your favorite apps without any of the headaches of plugin management to measure, monitor, and report on all of your most important data right within HubSpot.
Data affects your entire organization. Whether it’s cultivating leads, caring for customers, or even communicating internally, with effective data analysis you can implement better commercial strategies across the board.
At its core, data-driven decision-making means making judgments based on information rather than intuition, assumptions, or disjointed observation. Done well, it can allow you to anticipate what your customers need before they even ask.
And what business wouldn’t benefit from being able to see into the future?
Predicting customer behavior enables you to offer a frictionless buying journey. Which means, you’ll be adding value to every interaction. The delight customers feel when a business delivers that level of satisfaction will not only keep them coming back for more, it will also turn them into an army of mini-marketers spreading the good word about your service. Can you afford to turn down free marketing?
“HubSpot research has shown that 77% of consumers shared positive experiences with their friends on social media or on review sites.”
Small-to-medium sized businesses report that word of mouth (including social media) is their single best source of referrals. But at the same time, failing to thrill your customers can be disastrous.
“94% of consumers have discontinued communications with a company because of irrelevant promotions or messaging.”
With so much at stake, you can’t count on your gut or guesswork to keep your customers happy. The more data you have, the more certain you can be in your decision making.
With information about your target audiences readily available, it’s possible to personalize and optimize at every stage of the customer journey. Everything from behaviour prediction, best-fit prospects, user research, beta testing, surveying support channels, industry trends, and more can all be researched, analyzed and acted upon, if you know what to look for.
But collecting data doesn’t have to be complicated. Sometimes data is right there, just waiting to be noticed. For example, on its way to becoming the world’s most popular music festival, Coachella used data from its online message board to figure out who were the most talked about acts amongst its most enthusiastic consumers. It would then use this information to help decide which performers to book at future festivals.
As Coachella grew and technology evolved, the festival created an app that allowed users to select the artists on the lineup they were most excited to see. Coachella then used the data gathered from the app to help it decide which acts should perform later in the day when more fans were there to enjoy them.
By unobtrusively gathering data from its customers using voluntary platforms, the festival organizers were able to create the best possible customer experience.
No wonder it’s become one of the most famous music events in the world.
This level of data-driven, user-centered approach is at the heart of inbound and crm-powered marketing. Inbound marketing meets customers wherever they are and offers engaging, valuable information to suit their needs.
HubSpot visualizes this business model like a flywheel, with the core activities of attracting, engaging and delighting the prospect at every stage of their journey. Any forces that make the flywheel spin faster, like investing in strategies that acquire and retain customers, increase momentum and growth. Any friction created, for example, when handing off customers between teams, can cause you to lose steam.
Let’s re-examine the Coachella example through the lens of inbound marketing and the flywheel model.
First, the festival attracted customers by creating an active online community of music fans looking for a place to talk about the music they love.
Next, it engaged those fans by offering a festival full of the same music they talked about online.
And finally, it delighted attendees by creating the best possible experience at the festival using more data it got from those same customers.
What can we learn from this example? Building a company around data means establishing a culture where people are not only driven by results but also driven by learning. This means teams that are not only looking to adapt, but also to innovate around the needs of the customer.
It’s important to mention that good data is clean data. Maintaining databases and ensuring information is accurate will help you build reports that are always up-to-date and reliable. This is the key to deploying automation that is personalized with confidence.
Well managed data accurately transformed into visual reports allows every stakeholder in your business to see the information they need to improve their small corner of the world. It also allows them to ensure they see the bigger picture and don’t make detrimental decisions in information silos.
The great news for you is most people end their data journey here. They fail to take the next crucial step and use the information they have to drive meaningful, growth-fueled change. They see reports as a tool to explain what happened without fully understanding their power to let you see into the future and predict behaviours.
But you’re different...
The DIKW model or DIKW pyramid is an often-used method, with roots in knowledge management, to explain the ways we move from data (the ‘D’) to information (I), knowledge (K) and wisdom (W) with a component of actions and decisions.
Essentially, that’s what we do in digital transformation. And with Industry 4.0, IoT and AI/ML the decisions/actions can also be (semi-)autonomous (although everything depends on the nature and purpose of the data).
DIKW is a model to look at various ways of extracting insights and value from all sorts of data: big data, small data, smart data, fast data, slow data, unstructured data, it doesn’t matter; we want outcomes, the ‘actionable intelligence’. The DIKW model is also often depicted as a hierarchical model as seen below:
In context, one moves from a phase of gathering parts (data), the connection of parts (information), formation of a whole (knowledge) and joining of wholes (wisdom).
In understanding, the DIKW hierarchy can also be seen as a process starting with researching, absorbing, doing, interacting, and reflecting.
These steps fluidly connect the DIKW hierarchy, no step is linked to a particular DIKW step. The DIKW hierarchy can also be regarded in terms of time. The data, information and knowledge levels are based on the past while the final step – wisdom – looks toward the future.
Logging, records, measurements, etc. are all data. And since data is a mass and includes many things, it needs to be contextualized to make sense: data alone does not provide meaningful results.
Let’s consider that one million subscribers use the SMS service of a telecom operator in the United States. Alone, the one million tells us nothing other than a volume. Why? When? How? These are the questions that still need to be answered IF that data set is to become useful.
For example, if one million SMS service users are analyzed, it could be found eight hundred thousand users using this service are in the 15-25 age range with 80% using the service between seven pm to eleven pm in the evening.
And if you take it one step further and also work out that 90% of these users use SMS service when there is no internet connection on their cell phone, things start to get interesting. The analyzed data becomes information.
The third level in the DIKW hierarchy is Knowledge. The Knowledge step aims to answer the How? question. Specific measures are identified and the information gained in the previous step is used to answer questions based on these measures, such as ‘How do teenagers use SMS services?’
The fourth and last step in the DIKW hierarchy is Wisdom. At the Wisdom stage, the knowledge found in the previous step is applied and implemented. Wisdom is the top-level reached in the DIKW hierarchy and answers the ‘Why?’ question.
If we consider our example scenario, an example of wisdom gained might be that 95% of the SMS service users use this service for short communication when they do not wait for a response from the other party. For instance, when a user wants to say goodnight to another party, or if someone arrives at the meeting point and seeks to notify another person, etc.
As you see, starting from the usage data of the SMS service from the beginning, we processed the data in the Information and Knowledge stages, and we found at the Wisdom step that most of the SMS users use this service for short communication with the other party. This is an example of how an IT service provider used the DIKW hierarchy as a model to convert data into actionable results based on wisdom.
To gather useful insights from data, you need clear reports displayed in an easy to understand format.
Once your data has been collated and sorted into a clear pattern (such as a graph), you’ll need to put this data into context and explain what’s happening. Look at a graph and see 5 good days where you get 200 form submissions and then 2 poor days where you see below 20 form submissions. The context you need is to find out which days the bad days are - are these weekends? Mid-week? What correlation is there between product usage and these days? Add context to your data visualization before you can interpret the data and turn it into insight or wisdom.
When presenting data, you need to keep in mind that a bunch of graphs tossed onto a dashboard do not necessarily make a good story. Data visualisation and the way you layout your data will help you weave together a story that helps tell a meaningful story.
Using data to tell a story is about sharing the reason why results occurred and weaving in context to the information you are sharing. It isn't about telling a narrative that suits your objective but rather adding context to your results in such a way that the information you’ve gathered provides actionable insights and meaningfully drives your business forward
Poor results should be presented in context and with the hope of finding a way to either mitigate this in future or to understand what happened. Using the DIKW model, you could share the results, what has happened at the time or what factors affected this result and then share insights regarding future actions that you could act on due to these insights.
One of the advantages of the HubSpot CRM platform is the powerful reports that come standard with each tool. Tools like Sequences in Sales Hub, Social or Traffic Analytics in Marketing Hub, Knowledge Base in Service Hub and Website Pages in CMS Hub all have their reports covering those specific tools.
Here are the reporting tools available in HubSpot and how you can use them:
Tools like Ads, Social Media, Sequences, Workflows, Knowledge Base all have reporting dashboards or analyze tabs available. These tabs offer insights on common metrics associated with these tools such as impressions, open-rates, conversions, etc.
These dashboards show the most common reports that anybody using these tools are likely to ask about the performance of the particular tool and actions you’re taking. While simple, these reports are powerful in helping determine which assets are performing and driving both traffic and conversions.
A powerful set of standard tools that show the analytics on sources of traffic, contacts and customers, lifecycle stage reports and more. These reports allow you to track the sales or service activity, understand which campaigns drive results, and track the changes in your recurring revenue.
These standard reports come standard within the relevant HubSpot packages/hubs as indicated below:
Analyze contacts, companies, deals, tickets, custom objects, activities, line items, or feedback submissions.
An advanced report builder that enables you to analyze objects concerning marketing, sales, and service activities.
Measure the conversion rates between certain stages in a customer's lifecycle or deal's pipeline. If you have an Enterprise subscription, you can also create a custom events funnel.
Measure which sources, assets, and interactions impacted lead generation (Marketing Hub and CMS Hub Enterprise only).
Measure which sources, assets, and interactions impacted deal generation (Marketing Hub Enterprise only).
Measure which sources, assets, and interactions had the greatest impact on revenue (Marketing Hub Enterprise only).
When it comes to building a data dashboard, ask yourself, “what problem does this board need to solve?” Forcing a dashboard when one isn’t needed is a great way to waste time and resources. Understand the purpose behind your board, your goals then what necessary metrics you need to identify, measure, and improve.
To start, focus on five to ten most important metrics and report on those per dashboard. If you do, you’ll have a clear understanding of when you’re adding value to the problem and when you’re not and will help tell the true story to stakeholders.
Not all clients are created equal. They come in many shapes and sizes and are often looking for different metrics depending on their department. Defining your target onlookers will help you:
What problems does this board need to solve?
Most teams have some understanding of why they exist. Your data dashboard should be related to that purpose and align with the target group’s overall objectives.
What metrics are most important to the target group?
Choosing the right metrics depends on many factors like the type of offering or product, business model (B2C/B2B), industry (e-commerce/SaaS), job function (product/marketing/sales), and more.
What does the group stand to gain from this dashboard?
Great metrics lead to insights — which lead to actions and results. Write down what clarity observers will walk away with after looking at the board.
Once you answer the questions above, you’ll have a better idea of who’s looking at your dashboard and can determine how in-depth you need to go with tracking.
Place your most important metrics in the top, left-hand corner. Structuring content to read from left to right is one of the best ways to improve comprehension.
If your viewer skips something or gets distracted, you want them to remember the essential details. You don’t want them to miss out on the good stuff because it lives in the wrong place.
There is nothing worse than going to a data dashboard and the information is all over the place. When you’re creating your data dashboard, focus on specific topics and groups. Grouping content together in a clear way is important to give a complete overview of data. Plus, it helps viewers access the right information, at the right time.
To know if a number’s good or bad your viewers need context. Would they know, for instance, that 42 new leads today is out of the ordinary?
One of the easiest ways to do this is to include past data. You could include the same metric for the previous day, or even a line or column chart showing how the metric tracks over a longer period. Another technique is to include the average or previous highs and lows.
If you’re working towards a goal, include the target as well as your current progress.
You can also add warnings for when a metric is above or below a certain threshold to make it easier to spot problems.
Another important thing to note is that all of your business data is related and changing. One thing in your business may affect multiple data points across many of your dashboards.
One of the hardest things to do is to spot and understand how one data point or set of data points correlates to another. We also recommend adding text blocks within your data to help identify different sections and even give your notes on how the data correlates. Doing so will make it much easier for your audience to understand what the data is telling you.
It’s easy for data to lie. One of the easiest ways to have your data lie to you is to have incorrect, inaccurate, or inconsistent time frames.
If you’re preparing several pieces of data for presentation, each piece likely needs to be set to the same time frame to avoid confusion or false assumptions.
Sometimes having different time frames is necessary. In most cases, it’s critical to clearly outline the different time frames and why they are different. The last thing that you want is the person that the data was prepared to misinterpret because they don’t realize that the time frames are not the same.
This last tip builds on the last one, but it’s important to account for how you’ll share your dashboards with a client. This can change how you structure the dashboard and what information you spell out clearly.
If you’re presenting the data in person, you can leave out some text blocks and explain the data within your presentation. However, it’s more likely you’ll be sending the dashboard to your audience and they’ll view the data on their own. If this is the case, give as much detail and explanation as possible. You don’t want your audience to misinterpret a data point in the dashboard — it could result in poor business decisions and mistakes.
Keep evolving your dashboards
Our final piece of dashboard design advice is the most important. Once you’ve built your dashboard don’t just leave it. Ask your team for feedback.
Use this feedback to iterate your dashboard. Check your dashboard is driving the behaviour you intended. Step back from your board now and then and look at how all the elements work together. Remind yourself what information you’re primarily trying to get across and how effectively those important elements stand out.
As your goals and priorities change, make sure you update your board so it acts as the heartbeat for whatever you’re doing.
A HubSpot custom report, however, enables you to dive into the details. For instance, with a custom report, you can further analyze the data at hand or review it in-depth, compare activities, and more.
For help building custom reports, use this guide from HubSpot.
Therefore, with custom reporting, you can analyze various objects and integrations in one place. This means you can have all your data sources at one spot rather than having to join data in Excel from scratch for building a report on another software.
To get started with creating a HubSpot custom report, you need to have four things in place:
Once you’re done making your HubSpot custom report, you can name and save it to your reports lists or dashboard. You can also export it to save it on your device.
Charts are perfect for comparing one or many value sets, and they can easily show the low and high values in the data sets.
To show comparison:
Use this type of chart to show how individual parts make up the whole of something, such as the device type used for mobile visitors to your website or total sales broken down by sales rep.
To show composition:
Distribution charts help you to understand outliers, the normal tendency, and the range of information in your values.
To show distribution:
If you want to know more information about how a data set performed during a specific period, there are specific chart types that do extremely well.
To show trends:
Relationship charts are suited to showing how one variable relates to one or numerous different variables. You could use this to show how something positively affects, has no effect, or negatively affects another variable.
To show relationships:
One of the advantages of the HubSpot CRM platform is the powerful reports that come standard with each tool. Tools like sequences in Sales, Social in Marketing,
Break up the text into short paragraphs and bulleted points so that it’s easy to skim (no "wall of words" to discourage your readers).
Keep the layout simple and uncluttered, with plenty of margin and white space (blank areas that give the eyes a chance to rest).
Left justify the text to make it easier to read. Readers sometimes overlook titles that are centred.
Make the text large enough for easy reading and choose highly readable fonts. Serif fonts have little strokes at the ends of letters; sans serif fonts do not.
For Web reports, experts usually recommend using a sans serif font for easy on-screen reading.
For printed reports, experts tend to recommend using a serif font for the main text and a sans serif font for headings, subheadings, and labels. Choose serif and sans serif fonts that are both easy to read and contrast well with each other.
Use boldface type to highlight important words and phrases. But use it sparingly, because large blocks of text in bold are hard to read.
Maintain high contrast between the text and background. Black text on a white or very light background is the most readable text.
Be cautious with colored text. Never put text in light colors such as orange or yellow against a light background.
Minimize use of “reversed-out” text (light text on a dark background), which is hard to read, especially in printed material. Also, if users will be printing the report themselves, reversed-out text requires too much ink, making printing costly.
Avoid printing text on colored backgrounds unless the background is very light (such as pale yellow). Shading the background reduces contrast and makes the text harder to read. For ease of reading, do not put text on top of photos or patterned backgrounds.
To guide people smoothly through your report, use text and graphics in combination to give clear, consistent navigation signals.
These signals help people notice what’s in the report and help them find the parts of personal interest without distracting or misleading them.
Use plenty of informative headings and subheadings. Make them pop out for easy skimming by creating a strong contrast between the text and the headings and leaving enough space around the headings.
Be consistent.
Consistent design helps orient people, facilitates skimming, and enables easy navigation through the report.
Keep the overall page layout and design features consistent
Although each page in your report may have different content, the basic design should be consistent. Keep the formatting of titles, headings, bulleted lists, labels, and other text the same throughout the report (same font, size, color, and so on).
Provide persistent navigation links for the main headings and keep them in the same position on each page.
Looking for help building insightful reports in HubSpot? Contact our team and we can assist you in building impactful campaigns and insightful reports to help track your campaign conversions.
A CRM is more than a contact database or system of record; it’s the heart of your customer’s experience with your brand. And it’s designed to ensure...
Because of today’s rapidly changing business environment and seemingly endless marketplace of ideas, perspectives and opportunities, many marketing...
This guide explores and explains how to harness the power of your data and turn your CRM into a revenue-generating growth machine.
