Many organisations face the problem of having loads of data, but no clearly defined strategy for organising or presenting all this information.

Integrating multiple fragmented technologies that don’t talk to each other seems daunting. However, it’s important to realise that, without accurate reporting on your primary marketing efforts you are, in fact, running blind.

Let’s say you’re running an email and social media marketing campaign focused on B2B lead generation and lead nurturing. This campaign will involve capturing lead information, tracking response rates, analysing social media posts and measuring traffic to your content hub.

Here are four steps to optimising data analytics to gain a clear picture of the results from your B2B marketing.

1. Clean your data

Dirty data is a common issue B2B marketers face when trying to effectively analyse their data. Many data sheets include duplicate fields, incorrect date formats or unwanted records. Business Intelligence platforms such as Wave Analytics or DOMO allow you to clean, combine and transform your data. So get to work and prepare your data by clearing out the junk and eliminating any unwanted anomalies.

Dirty data is every B2B Marketer's worst nightmare Click To Tweet

Here are my tips for preparing your data for automation:

  • Use text filters to filter out records unwanted for analysis. For example, we exclude all email addresses containing ‘’.
  • Remove duplicate values of fields containing unique identifiers.
  • Join multiple data sources to create new custom datasets.
  • Convert ID fields (commonly misinterpreted as number fields) to text fields. If you leave the field type as number, you can add your IDs together (not useful), but you can’t group your records by ID (very useful).
  • Create time-stamped batch updates for historical trend analysis. Changes that occur in your data can be recorded, with a time-stamp, each time the data is refreshed. For example, we could keep track of when someone’s lead stage changes. This would then allow us to show a trend of where our leads sit in our Sales and Marketing Funnel over time.

2. Automate your data

Business Intelligence (BI) platforms are used to analyse data from multiple sources, find insightful information and present it – in real time – in an easily digestible way. These online data powerhouses extract data from sources in the cloud through scheduled API calls (Application Programming Interface, in software terminology). No more visiting multiple sites to manually extract reports. Once the connection has been made, you can sit back and relax while the machines do the work.

3. Visualise your data

The visualisation of data allows for easier analysis that sparks an insights process. By visualising the entire picture into dynamic dashboards, you can begin to see important trends, learn what’s working well, spot the red flags and identify areas that need more attention. Deep diving into the analytics to try and answer arising questions can lead to vital discoveries, ultimately influencing our B2B marketing decisions.

Four common examples of data visualisation in B2B marketing:

Sales and Marketing Funnels

Funnels help us show the progression of leads through the stages of our nurturing campaign. They encapsulate the performance of a marketing campaign as a whole. The top of the funnel shows how effectively lead generation is performing, while the following stages demonstrate Marketing’s ability to advance leads through the funnel until they’re ready to be passed on to Sales and converted from leads into clients.

Conversion Rate Gauges

Goals around lead conversion rates are set at the beginning of a campaign. The Marketing Qualified Lead (MQL) to Opportunity conversion rate is particularly important for marketers. Conversion rate gauges are a great way to focus on targets and make sure you’re working towards a high speed of lead progression through your pipeline.

Website Traffic Analytics (Google Analytics)

Many campaigns focus on bringing leads to an organisation’s website. Visualising website traffic trends helps to find what’s working and what needs improvement. Traffic Source data visualisation shows you where your website visitors came from. Drill downs can then compare how customers coming from these different sources behave across the website.

Social Media Engagement Trends

Social media engagement rates are a good measure of how a platform is performing relative to its audience size. Here you can see which posts are resonating well with the online social community and keep track of your online presence across multiple platforms.

4. Keep track of your data

Keeping on top of a large analytics dashboard can be time-consuming. Automated alerts are a great way to make sure you’re keeping your finger on the pulse. Alerts can be set up to send a text to a mobile phone number or email whenever a specified threshold is met, for example:

  • 10 new leads were converted from the MQL to Opportunity Stage
  • Website sessions increased to 25% above the monthly average
  • LinkedIn engagement rate increased/decreased by 5%

In summary…

Data analytics can be an intimidating task for many organisations, so remember the following:

  • Cleaning and preparing your data eliminates anomalies and customises it to your needs
  • Automating the extraction of data will ultimately save time and effort
  • Visualising data via an analytics dashboard gives insights, reveals trends and raises flags to guide a continuous improvement process
  • Setting up alerts allows you to stay on top of any important fluctuations such as the need for rapid action or key milestones reached
Four steps to optimising B2B data analytics

Tom Baker
Tom has been a part of Green Hat’s automation team for more than three years as a one of our Digital Marketing & Automation Specialists. His focus has been primarily on Marketo, driving forward numerous implementations and continuing on the journey with his clients to produce personalised experiences through automation. Tom also has a deep level of expertise in Green Hat’s preferred Business Intelligence platform, Domo, possessing strong skills in data transformation and dashboard visualisation.