Data Snacks

Discover Which Source Brings in The Most New Opportunities for Your Business

Do you know which sources fuel your sales pipeline? In this episode of Data Snacks, we’ll show you how to set up and track your HubSpot Marketing data in order to decide which sources are worth the further investment.

Monja Dobnik Monja Dobnik on June 18, 2021 (last modified on November 26, 2021) • 5 minute read

Hello everyone. Welcome to another episode of Data Snacks. My name is Monja, and I’m the product marketer at Databox. 

Do you know which sources fuel your sales pipeline? 

Businesses invest in various marketing sources and channels to add new sales opportunities that the sales team can convert into customers. Doing so allows you to calculate return on marketing investment. But not all sources are equally productive at driving new sales opportunities.

google-analytics-kpi-dashboard-template-databox

In this Data Snack, we are going to show you how:

  • To track and visualize New Opportunities based on their source
  • Compare the success rate of those sources
  • Decide which ones are worth the further investment and which ones you can reduce in your marketing budget.

Below, you can view the full episode, or, keep reading for a fully transcribed version of the episode complete with relevant screenshots.

Time to Track New Opportunities by Sources

We are starting in Databox, and using HubSpot Marketing as our main data source.

First, we will navigate to the Databox Designer. Adding metrics is quite simple here. Simply choose the data source from the Metrics Library here on the left and drag-and-drop some of the available pre-built metrics.

In this case, we will visualize New Opportunities by Email Marketing Source, New Opportunities by Organic Search Source, New Opportunities by Paid Search Source, and New Opportunities by Paid Social Source in separate data blocks. By tracking these metrics, you will see which sources are bringing you the most new opportunities, decide which ones are worth investing in, and easily compare the numbers. That way you’ll make the best possible decision regarding which ones are worth continual investment. 

New Opportunities Sources

We can also choose different visualizations to track these metrics. For example, let’s drag and drop the table chart visualization onto the board here and add New Opportunities by Email Marketing Source as a metric. Here you can see which email campaigns have driven the most new opportunities. That provides insight into which email marketing strategies are having the biggest effect. Now let’s also show the total number of new opportunities for the last quarter. Or, you can adjust the data range as desired. 

Let’s Visualize The Data We Have

Let’s create a new data block to visualize New Opportunities by Organic Search Source using a pie chart. Now you can see which organic search source is bringing in the biggest share of new opportunities. Organic search is one of the most important sources as it shows how many people find your business naturally, without a paid ad showing up in front of them.

Pie chart visualization

As I add the rest of the metrics we want to track, I want to make sure that the total is visible in all of these visualizations. 

Now we have a finished dashboard and can see the results. Let’s see what our dashboard tells us. So we have several source types here, Organic Search, Email Marketing, Paid Search, and Paid Social, and for each of these, there are specific channels that you may be tracking. 

Interpreting The Data

So the first step is to look at all the totals for each source type. This tells you which ones are performing best overall and which ones could use some improvement. The total number of unique opportunities is the best way to compare the sources, as it can be viewed as the end result for each source. 

Next, we analyze the data within each source, so for example, in the Paid Social Source, your Facebook ads might be bringing in all the new Opportunities while your Google Ads might be underperforming. This can help you decide which ones are worth the further investment and which ones aren’t delivering desired results. When it comes to your Email Marketing Source, you can clearly see which campaigns were the most productive, and that can help shape your future email content. With Paid Search Sources, you can see which ones are working and which ones you can stop investing in. Or at least ensure that you improve the current approach, from writing more engaging copies to targeting better keywords. 

A dashboard showing which sources and channels create  New Opportunities most effectively helps us make better decisions when it comes to our marketing investments.

You are Now Ready to Track

We hope that we have shown you how you can track new opportunities by source in a way that provides you with a clear insight when it comes to your marketing ROI.

Just by glancing at each metric, you can see which sources are performing better, and if you dig deeper within each source, you can see which campaigns work best.

If you need help tracking and visualizing your New Opportunities by Source metrics, our Support team can actually help build your first dashboard for free. 

Just create your free Databox account and reach out to our team either via chat or email.

See you next time.

google-analytics-kpi-dashboard-template-databox
About the author
Monja Dobnik
Monja Dobnik is a Product Marketer here at Databox. She has a curious mind and a head full of ideas still waiting to come to life - either in text or video form.
You may also like...
Read more

How to Best Format Your Google Sheets for Databox Syncing

Learn how to format your Google Sheets to ensure accurate data visualization in your shareable dashboards.

Data Snacks   |  Jul 19

Read more

Comparing Your Current Blog Performance to Previous Periods

In this episode of Data Snacks, we show you how to properly track your blog performance over time.

Data Snacks   |  Jun 1

Read more

How to Identify and Analyze Your Most Successful Landing Pages

Discover just how effective your landing pages really are.

Data Snacks   |  Apr 11