+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

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...
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...
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...
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