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