Calculate your sales cycle

Right now you cannot find the average sales cycle for your team within the app. However, you can find this data using Zap that pushes data on creation and close dates from Close into a Google Sheets workbook.

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) status change in close

Choose Close as the application.

For the trigger step, choose New Lead Status Change.

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

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.

Only interested in tracking certain statuses?

Make the Zap only trigger on specific status changes using the filters in the trigger step.

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

Choose Google Sheets as the application.

For the action step, choose Create Spreadsheet Row.

Under Edit Template, select the name of your Google Sheet and Worksheet where you will be storing the data.

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

Click Continue, then Send Test to Google Sheets.

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

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

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

Calculate your sales cycle


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.