+44 203 287 0899 info@solvaa.co.uk
Flatlay showing a computer keyboard, notepad and pen with text overlay “Calculate lead to customer conversion times”.

When you’re running a business it’s important to stay on top of your figures, and you should measure key performance indicators to review performance and plan for the future.  One of these metrics is the lead time from when a prospect is created to when they become a customer.  If you know how long that period is then you can adjust your nurture sequence if the timescale is longer or shorter than expected.

As your leads may be added using one system and sale conversions recorded in another, it can be hard to extract that data unless you do it manually, which isn’t very efficient.  Our favourite way of streamlining this process is to use Zapier to trigger and perform the calculation when the relevant data has been updated.

Our zap can be used for any business scenario where you need to calculate the difference between two date/time values.  For example, the time between a customer signing up to an email list and them becoming a paid subscriber, or the time between invoice creation and payment.

Our example uses a Google Sheet to store the data but could equally use Microsoft Excel spreadsheet instead.

The Google Sheet already contains the lead’s name and timings, which can be created automatically from web forms and your CRM using Zapier.  Examples of web forms that integrate with Zapier include Ninja Forms, WP Forms, and Zoho Forms.  CRMs include Pipedrive, Salesforce, Dubsado, and Hubspot.

 

Video demonstrating how to calculate lead to customer conversion time

Our new video shows how to calculate lead to customer conversion time, in both days and hours. 

The steps are:

  • Create a trigger event for when the Google Sheet was updated with the time the prospect became a customer.
  • Use Formatter By Zapier’s Date/Time action event (with Format transform option) to convert the timestamp of the first enquiry to a Unix time which is the number of seconds since a prescribed date in the past and used by computers for date/time calculations.
  • Use the Date/Time action event again to convert the timestamp of the lead becoming a customer to a Unix time.
  • Use Formatter By Zapier’s Numbers action event (with Spreadsheet-Style Formula transform option) to calculate the number of days between the two dates. Use the formula (X-Y)/86400.
  • Use the Numbers action event again to calculate the number of hours between the two date/times. Use the formula (X-Y)/86400 *24 or (X-Y)/3600.
  • Update the spreadsheet with the resulting figures.

You could add in another step to calculate the number of minutes, using the formula (X-Y)/86400 *24 *60 or (X-Y)/60.

 

Find out more

If you’d like to dig deeper into the world of Formatter By Zapier to unlock the power of what you can do with its functions then you can get our free cheat sheet below. 

Watch the video and subscribe to our YouTube channel

Save some time and download the Zap template

If you liked the video and can use process in your business, go ahead and download the ready-made template below. Once you have the template, just open it up in your Zapier account and customise it to your needs.

Save time and grab our pre-built Zap template

 

Read more about how our certified experts use Zapier workflow automations to simplify processes and increase efficiency.

Solvaa is a process and automation consultancy specialising in improving sales, operations and financial administration workflows. We help you to simplify and streamline existing processes, integrate your business tools to make data transfer more efficient and automate manual tasks to increase productivity. We are Zapier Certified Experts, Pipedrive Certified Experts and Xero Certified Advisors. 

Contact us today to discuss how Solvaa can help you simplify, improve and automate all aspects of your business with Zapier to save you time, reduce costs and keep you agile as you grow.

Related Posts

Flatlay with notebooks and pens, plant, glasses and text overlay which says ‘Supercharging Productivity With Automation Masterclass’

Free Masterclass: Supercharging Productivity With Automation

  Our Chief Problem Solver, Kelly, recently had the pleasure of speaking at the Practically Perfect virtual summit for assistants, talking all about the tools and technologies which can help VAs, executive and personal assistants to boost efficiency. If you’re a...
Cover of the book ‘Automate it With Zapier’ with byline ‘Boost your business productivity using effective workflow automation techniques’ by author Kelly Goss.

Automate It with Zapier Book

Writing a Zapier book was a natural step for our founder, Kelly Goss as she is so passionate about helping business owners increase productivity in their companies.  As a Certified Zapier Expert, Kelly is the perfect person to impart everything she’s learned using...
Blackboard with rainbow coloured arrows pointing right, with word PRODUCTIVITY drawn with chalk

How to be more productive in 2021

Have you thought about what it could mean for your business if you were more productive?  It’s sometimes hard to measure productivity gains, but think about how you could use the time you save by being more efficient in your business. Recently, our chief problem...
Virtual assistant concept featuring a young woman with background of illustrated icons including 'like', 'share' and other digital marketing themes.

How To Use Zapier As A Virtual Assistant

So many people are choosing to be Virtual Assistants these days, as it is a flexible freelance role that is packed with variety.  There are many different types of VA, for example, Social Media VAs, Marketing VAs, Technical VAs, and eCommerce and Finance VAs. ...

How to automate thanking your customers for paying their Xero invoices

Learning how to automate sending an email using Zapier when a Xero invoice is paid is a really simple but useful workflow that saves time and provides great customer service. Xero is a cloud-based accounting system which includes a host of features to reduce...
Mocked up book cover with a background of shades of teal in a geometric pattern, a retro robot image and a title "Automate!" with a subtitle of "The essential guide to business productivity", written by Kelly Goss with a Solvaa logo.

Download our free automation ebook

Do you feel overwhelmed and busy ALL THE TIME?   Do you wish you could afford another pair of hands to do the boring, mundane tasks that suck up your time? I have the answer! I’m Kelly Goss, founder of Solvaa, business process automation specialists. It’s no...
Desk flatlay with yellow coffee cup, yellow notebook on a white background with white text on a blue shape saying “Create and send a sales proposal from your CRM”.

Create And Send A Bespoke Sales Proposal PDF From Your CRM

When you need to create and send a bespoke sales proposal PDF from your CRM, you can either shell out for software that will do it for you, do it completely manually or let Zapier do it for you. Automating this task is really simple and will save time, money, and...
Mobile phone with a ‘new message received’ message with a cursor hovering over a ‘show’ button and thumb poised to select it.

How to harness the power of automating text messages using SMS by Zapier

Automating text messages can be extremely useful in business, and using SMS by Zapier is really powerful, easy – and free! In this article we cover the following: Why is SMS such a powerful business tool? What is SMS by Zapier? What could I use SMS by Zapier for? What...
Closeup of a section of a light grey keyboard with a blue ‘Organise’ button. Solvaa logo in top right hand corner.

How to organise your zaps

If you’re a new Zapier user then learning how to organise your zaps will help you manage them efficiently from Day 1.  As an existing Zapier user, if your zaps aren’t organised then you may find that it gets harder and harder to find the zap you’re looking for....
Female dentist examining a patient with a mirror whilst a male dental assistant looks on and smiles.

Client Success Story : How Ascent Dental Group saved many hours of manpower by automating their dental practice

Ascent Dental Group is based in the Midlands, with 36 reception and patient-care staff plus 35 dentists across four practice locations.  They wanted to implement automations to increase productivity, reduce manual administrative tasks and improve communication with...
Image shows a pen next to a bank statement and data chart next to a calculate. Text is overlaid which says ‘How Xero automation saves time and reduces errors’.

How Xero automation saves time and reduces errors

If you’re running a business then you want your workflows to be as slick as possible, particularly the finances.  If your staff are spending hours on repetitive manual tasks such as entering data into a spreadsheet then you are wasting time and money which could be...

How to automate adding invoices to Xero from Pipedrive

If you use a Customer Relationship Management (CRM) app in your business, it is often a common workflow requirement to create an invoice in your accounting system once a deal or opportunity reaches a certain stage in the CRM. If an integration exists between your two...
Closeup of coins in increasing piles, with someone adding three coins to the biggest pile as a concept to represent earning more money using automation.

How business automation using Zapier can improve your pricing and earn you more money

There's no doubt about it – business automation is a key component to success in today's economy. But what if you could take your business automation to the next level to increase your profits? Zapier is a tool that allows you to connect different applications and...
Concept of a sales funnel featuring small silver balls feeding into a metal funnel with a neat row coming out the other side. A red sign is pointing at the funnel which reads 'Leads'.

How to avoid losing leads

  Winning new business isn’t easy, so it’s vital to learn how to avoid losing valuable leads.  Sometimes you’re so busy juggling your everyday tasks that you neglect your prospects and ultimately lose them to a competitor.  Automation can be a game-changer...
Wooden desk with a laptop, phone and stationery with blue square featuring the text “How to send a daily digest of all paid Xero invoices using Slack”

How to send a Slack message with a daily digest of paid Xero invoices

Using Zapier to send a Slack message with a daily digest of paid Xero invoices can provide useful data which is sent to your team automatically.  Knowing when invoices have been paid is business-critical information, but it can be time-consuming to check your...
A piece of corrugated card with the text Process Automation on it, alongside a black market pen and some wooden discs with letters printed on them. This is overlaid with text which says : Automate tasks using Zapier : 5 quick wins! Includes a small Solvaa logo in the corner.

Automate tasks using Zapier : 5 quick wins!

Running a business can be a rewarding experience, but there’s no doubt that there are certain processes that take up far too much time.  Manual tasks that seemingly only take a couple of minutes can soon add up and often require a follow-up action too. For example,...
Vintage blue toy robot isolated on a white background with black text “Will Zapier work for my business?” and Solvaa logo.

Will Zapier work for my business?

We get asked a lot whether Zapier will work for a particular business, because maybe some of the use cases we talk about don’t necessarily translate exactly to a particular sector.  Maybe you have a service-based business but have seen more product-based business case...
Toy robot on an orange background with the text “What are the benefits of using Zapier” in black along with a Solvaa logo.

What Are The Benefits Of Using Zapier?

If you’re wondering how Zapier can benefit your business then think about what your ‘pain points’ are, because the chances are it can address many of them.  Most people do not sail through the day, working in the most streamlined, optimised manner possible.  I would...
Rear view of successful businessman relaxing in his office with his hands behind his head.

The benefits of automation in business

Everyone is talking about automation in business but many people aren’t sure what it actually means and what the benefits are.  It sounds really complicated and time-consuming, and (even worse) expensive!  Who would actually bother finding out?  We want to bust those...
Businessman holding a mobile device with automation concept and text which says ‘Marketing Automation’.

How to use Zapier to automate your marketing processes and win more business

Are you tired of doing the same tasks over and over again every day? Do you wish there was a way to automate some of your marketing processes? Well, there is! With Zapier, you can connect different applications to create automated workflows. This can save you time and...
Get our free ebook

Get our free ebook

Learn about how business process automation with Zapier can help you to run your business on autopilot. The ebook is packed with real-life examples, use cases, and success stories. Whatever kind of business you have, you can use automation to help you work smarter, not harder.

Thanks! Your ebook is on the way.

Pin It on Pinterest

Shares