Calculate your sales cycle

At the moment, you can't calculate the average sales cycle of your team within the app. However, you can automate report creation for this by using a Zap that pushes data on the creation and close dates of opportunities and/or lead statuses into a Google Sheets workbook.

Here is a Zapier template to get you started --

Calculate Sales Cycle Using Lead or Opportunity Status

What you’ll need

  • A Close account and your API key
  • A Zapier account that allows multi-step zaps
  • A Google Sheets account and spreadsheet where you want the data to go

How the integration works

  • Dates of the lead (or opportunity) creation and status change from Close are pushed into a Google Sheet
  • The amount of days between statuses is automatically calculated
  • You can average the days to see what the average sales cycle time is for your leads

📘

This Zap can be setup for both lead and opportunity status changes.

Set up your spreadsheet in Google Sheets

Lead ID

User name

Lead name

New status name

Old status name

Date of status change

Days since creation

Days since last status change

Set up your Zap

Log into your Zapier account and click the orange “Make A Zap!” button.

Step 1: Trigger on New Lead in Status in close

Choose Close as the application and for the trigger step, choose New Lead in Status.

685685

If you haven’t already, connect your Close account by entering your Close API key as requested.

329329

If you want the Zap to trigger on every Status Change, make sure to leave the Old Status ID and New Status ID fields blank.

10471047

📘

Only interested in tracking certain statuses?

Make the Zap only trigger on specific status changes by filling both the new and old statuses above.

Step 2: Create a spreadsheet row for each new status change

Choose Google Sheets as the application and Create Spreadsheet Row for the action.

11351135

Under Set up Action, select the name of your Google Sheet and Worksheet where you will be storing the data.

17141714

Once selected, the columns from your Google Sheet will appear. Map the fields from Close to your columns in Google Sheets.

16981698

Click Continue, then Send Test to Google Sheets.

538538

You will see a row of test data populate in your Google Sheet document.

16001600

Look good? Click Finish and turn it on! You're all set.

11081108

Now that you know how long your average sales cycle is, you can take steps to shorten it.


Did this page help you?