+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

More Youtube tutorials

We have other Youtube video tutorials which will help you work smarter, not harder.

Our other resources

We also have plenty of free resources:

And finally, our founder / chief problem solver / chief automator Kelly Goss’ new book, Automate It with Zapier, is out now and is the most comprehensive Zapier guide on the market. It will get you up and running and to the stage where you can build and debug advanced automations. Buy your own copy today directly from publisher Packt using this link.  Or here are links to Amazon (.co.uk) and Amazon (.com) if you prefer.

 

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

Solvaa blog header image: AI-tomation: How Zapier is using AI to make automation easy. Part 2 - Using AI to create Zaps and Zap actions

AI-tomation: how Zapier is using AI to make automation easy

Part 2 of our series of blogs on using AI in Zapier will delve into using AI to create Zaps and Zap actions. If you missed Part 1, which gives an overview of all the places that you can find AI in Zapier, check it out here: Part 1 - An overview of AI in Zapier In this...
A man's hand hovering over a laptop keyboard with the screen showing available appointment slots for a meeting.

How calendar apps can help you be more productive when booking meetings

 One of the biggest time sucks in business can be all the to-ing and fro-ing that you get when you're trying to organise a meeting with someone. You start by saying you're available on Mondays and Tuesdays, they then suggest a Tuesday, but you have a dentist...
Wooden blocks spelling 'LEARN' on a wooden surface with plain blocks in the foreground and background.

Free checklist to help you justify an automation learning budget

If you’re keen to learn more about automation then it’s likely you’ll need to justify the budget with your boss.   You may be competing with many other requests for finance so it’s vital to ensure you have a good business case. So where do you start?   We have the...

8 Fun automations to do with Zapier

  While there’s no denying that Zapier can be a powerful tool to save you time and money in your business, there are actually some really fun, cool automations you can do with it which aren’t work-related! New apps are being added all the time to the already-huge...
How-IQ-Glass-saves-45-hours-per-week-with-Zapier-automations : Blue graphic with text “Client Success Story: How IQ Glass saves 45 hours per week with Zapier Automations” over a background of a glass wall with blue/grey frames.

Client Success Story : How IQ Glass saves 45 hours per week with Zapier automations

We love to share our success in helping clients improve their business because it demonstrates how spending a little time on process improvement and automation can deliver massive results. IQ Glass is a great example of this, a business that had put all the right...
Jigsaw pieces which have text for the benefits of automation and a separate piece which says Automation Blueprint, as a concept of the blueprint being the missing piece of the jigsaw.

Our automation blueprint : the perfect way to learn how to use Zapier

  We often talk about the benefits of business process automation but do you find the idea of automation a bit daunting? You may be keen to improve business performance, reduce human error and get rid of all the boring mundane tasks but wonder where on earth to...
Virtual assistant at a work desk facing the camera and smiling with a computer monitor in the foreground.

5 Reasons why Virtual Assistants should learn automation

  When our chief problem solver, Kelly Goss spoke recently at the Practically Perfect PA Virtual Summit, she talked about the wealth of opportunities that automation can bring to Assistants and Online Business Managers.  After transitioning to a remote working...
Blog featured image for Solvaa blog post Using business automation software and excited to automate something new? Do these things first!

Using business automation software and excited to automate something new? Do these things first!

In the ever-evolving landscape of business processes, automation has become the cornerstone of efficiency and productivity. In this post, we'll delve into the art of enhancing your existing automation infrastructure by seamlessly integrating new automations into the...
Solvaa blog header image: Automate sales and marketing to make your holidays more jolly

Marketing and Sales Automations to Make Your Holidays More Jolly

Between Black Friday, Thanksgiving, and the holidays, November and December are busy times for businesses. Your busiest days may be yet to come, but if you want to get ahead, you need to start preparing as soon as possible. This post offers tips for automating and...
: A laptop and plants on a wooden desk with grey wall, with text overlay saying ‘save contact form submissions in a spreadsheet’.

How to automatically save contact form submissions in a spreadsheet

If you use a form on your website for visitors to contact you then you will usually get their details emailed to you so that you can then respond.  Whilst this works adequately as a lead notification system, what would be more useful is to save contact form...
A calculator with some graphs and charts to measure the financial position of a business. A colourful 3D pie chart sits on top of the reports.

How to automate your finance and reporting processes to help your business grow

If your business is growing quickly then it can be tricky to deal with the increased accounting transactions you receive as a result of more sales. On the one hand, this sounds like a lovely problem to have, but if you don't streamline your financial processes then...
Side view of a girl with a superhero cape, with Solvaa logo and text 'Become an automation superhero'.

Become an automation superhero with Zapier

Although Zapier is brilliant at connecting the apps you use every day, it also comes with over 20 inbuilt functions which will help you become an automation superhero in no time! These functions are a range of helper apps that we’ve listed on our free cheatsheet which...
Featured image for blog post: AI-tomation: How Zapier is using AI to make automation easy. Part 4: No code? No problem. Build an AI chatbot using Zapier.

AI-tomation Part 4: No code? No problem. Build an AI chatbot using Zapier.

Zapier's chatbots feature has graduated from its first version into beta, so if you've been thinking about creating your own AI chatbot, now's a great time to take the plunge! In this article, we'll cover how to create your chatbot and everything else that you need to...
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...

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...
Blog title image "There's an app for that, but do you need it?"

There’s an app for that, but do you need it?

From lead management to turning on the office coffee machine, there's an app for everything these days. When a task or process is time-consuming or difficult, it can be easy to jump straight to looking for something to do it for you. It's worth taking time to pause...
Yellow and orange post-it notes on a white wall, containing details of business tasks to be undertaken, representing a productivity concept. Overlaid text with ‘4 Productivity Tools That Will Change The Way You Do Business’ in black on a light blue background.

4 Productivity Tools That Will Change The Way You Do Business

As a business owner, life can get overwhelming. Between working on client assignments, running your own company, and maintaining some kind of family or social life, it’s almost impossible to do it all without a solid foundation and proper organisation. Productivity...

Automate It with Zapier book : Initial Reviews

Since our founder, Kelly's Automate It with Zapier book was released it has received some fantastic reviews on Amazon.  We knew the book would help new Zapier users but didn’t realise how useful it would be for people with different levels of Zapier knowledge. When...
Automate ebook

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...
The head image for the blog post showing a photo of a calendar on a yellow background. Next to the calendar is the Solvaa Automation academy & consultancy logo. Under that are the logos for the Calendly and Zapier apps.

Create a Zap for rescheduled Calendly events by adding one simple step

When you're using Zapier, it can be frustrating if the trigger or action you need doesn't exist. If you're technically minded, you may be able to build your own, but sometimes there's a simpler solution. If you're using Calendly with Zapier, you'll know that there...
Automate 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