Covid-19 | Open as usual and here to help

We're open as usual

Quattro is open as usual to help you with HubSpot whenever you need us. While our office in Stratford upon Avon is closed, the team are all working remotely.

How to get in touch

Our usual office number (01789 608015) is still the right one to use. If you want to get in touch out of office hours you can email us at or fill in our contact form.

Remote-Working_crop READ OUR GUIDE TO REMOTE WORKING Continue Browsing Site

Need To Predict Sales Accurately But Have No Time Machine?

22 December 2016| Joy

HOME // BLOG // Need To Predict Sales Accurately But Have No Time Machine?

Whether you currently use a lead scoring system, statistical analysis, a time machine or meet with a clairvoyant, we all find it difficult to predict accurately which of our sales prospects will buy and when they're likely to do it.

The quickest way for a business to grow is to take charge and effectively manage the sales pipeline. The more up-to-date and accurate your sales pipeline, the more likely you are to increase revenue.

Most sales teams know these things yet still find it difficult to manage the sales cycle. Fortunately the team over at HubSpot have been busy compiling a free resource that we can all leverage to help us with our sales forecasting.

As HubSpot Partners we got an exclusive first look at what the team have come up with.

The next best thing to a CRM

There are three template resources on offer, all of which are free which is an added bonus. They fall into three categories; managing your sales funnel, forecasting your probability of closing and a management template where you can monitor the progress of each deal. Each one is a simple to use file neatly structured with built in calculations so all the hard work has been done for you.

We decided to take a look at the sales template as this is the one that will immediately help you on a day to day basis.

Sales Pipeline Template

Product_Shot_Sales_Pipeline_Template.pngAs with all things HubSpot, ease of use seems to have been the driver behind the creation of this template.

In a single view you can see the status of a deal and the probability of it closing. There are no complex or fancy calculations, just a simple, easy to use layout so you can quickly see where your sales team need to put their efforts and where the reward for this effort will fall.

Click on this link for your copy of the template at HubSpot then read through our tips below.

Using your template

Take a look at your current sales pipeline and ask yourself:

  1. How is it structured?

  2. How is it measured?

  3. How is it used to drive your company’s sales performance?

  4. What data do you currently monitor

“71% of sales reps say they spend too much time on data entry” (Toutapp)

With the answers to these questions  begin migrating your data across to this new template. If you already use Excel for your forecasting, run your existing template and the new sales template side by side for a week so you can see the difference.

How this sales template will help you:

  • It enables you to forecast revenue (weekly, monthly, quarterly, yearly) with up-to-date accuracy.

  • You can follow the status of every deal in your pipeline.

  • Know exactly the number of opportunities you have open at any given time.

  • Keeps your team organised and focussed on the right deals.

  • Create new deals with a single click.

  • The template automatically estimates the probability of every deal for you.

  • No advanced technical skills or training are needed for your team to start using the template.

  • Customisable to your business; industry, size of team.

  • Just click, drag and drop to produce multiple pipelines that can be viewed separately.

  • Enables you to create filters by name, owner, amount or buying stage giving you actionable insights in a fraction of the time.

  • Helps you to prioritise tasks, track individual and team performance.

  • Gives you an overview of your current sales process and the length of your average sales cycle so you can continually improve over time.

  • Allows your team to spend less time on admin’ and more time communicating with opportunities so speeding productivity and revenue.


“50% of sales time is wasted on unproductive prospecting” (The B2B Lead)

I would encourage all businesses that are serious about growth in 2018 to take charge of their sales pipeline and this template is the perfect way to start.

Download the template today, fill your pipeline with leads, let the template estimate the actual potential of each opportunity and start to draw conclusions and decisions to steer your sales activity. Use the template to continually improve your sales process over time.

Read my other blog "Helping is Selling" to inspire your sales methodology in 2018.

Take your sales pipeline planning to the next level with Hubspot's FREE CRM.

 Photos and images courtesy of Freepik


Topics: sales

beginner's guide to CRM



Subscribe to our blog via email

Subscribe Here!


This is what some of our clients say

"We’ve worked with Quattro on a variety of projects including HubSpot training, COS website development, email marketing, custom module design, and advanced sales and marketing reporting. Their team have proven themselves to be incredibly knowledgeable, proactive and dependable."

John Buttress

Managing Director, Sales and Marketing | PS Aspire

"We've been working with Quattro for over a year now and throughout that time, they've been a great partner, helping us with everything from our website and email tools to our inbound strategy, and beyond. We're in contact with the team almost daily, and they are a pleasure to work with."

Sarah Todd

Marketing Manager | Ecrebo