Skip to main content
You can calculate the time between contact creation and an event by exporting a Cometly report and running the numbers in Google Sheets. A contact is a person Cometly has tracked, and an event is an action that person takes, such as scheduling a call or making a purchase. The result tells you how long people typically take to convert after they first appear in Cometly, so you know how long to wait before you judge a campaign’s results. In this example, we calculate the average number of days between when a contact was created and when a “Schedule” event occurred for the current month.

Before you start

  • The event you want to analyze (in this example, Schedule) must already be tracked in Cometly.
  • You need a Google account to use Google Sheets.

Step 1: Create a report and open its contact list

  1. Click Report Builder in the sidebar and add the event you want to analyze as the metric (for example Schedule).
  2. Set the Date Range (for example This month).
  3. In the report preview, click the event’s number or a point on the chart. A panel opens listing every contact behind that number, with one row per event. The rows include:
    • Event Date: when the event happened.
    • Create Date: when the contact was created in Cometly.

Step 2: Export the list as a CSV

  1. In the panel, click Download, then Download CSV.
  2. Save the file to your computer.
The CSV has nine columns, A to I: Profile, Name, Email, Event, Event Value, Contribution, Event Date, Profile Created, Location. Event Date is column G and Profile Created is column H.

Step 3: Import the CSV into Google Sheets

  1. Open Google Sheets (free for anyone with a Google account).
  2. Create a new spreadsheet.
  3. Click File > Import.
  4. Upload the CSV file you downloaded from Cometly.
  5. Confirm the import. Your data now appears in the sheet.
  6. Make a copy of this Google Sheet, which already contains the formulas.
  7. Copy your data from the imported CSV and paste it into columns A to I of that sheet.
The sheet calculates the days between the two dates for each row, and the average. If you would rather build the formulas yourself than copy the sheet, follow the optional steps below.

Step 4: Convert the date columns

For the calculations to work, Google Sheets must recognize the date columns as dates. Cometly exports dates as text such as “December 17, 2025 at 03:09 PM”, so convert them first.In column J, convert the Event Date (column G) with this formula:
In column K, convert the Profile Created date (column H) with this formula:
Drag both formulas down to apply them to all rows, then format columns J and K as dates.

Step 5: Create a “time between” column

In column L, enter this formula:
Press Enter, then drag the formula down to apply it to all rows. It returns the number of days between contact creation and the event for each row.

Step 6: Calculate the average

In an empty cell, enter this formula, changing L74 to the last row of your data:
This gives you the average number of days between contact creation and the event across the selected date range.

Check it worked

In your copy of the Google Sheet, every row you pasted shows the number of days between the contact’s Profile Created date and its Event Date, and the sheet shows the average across all rows. If a row shows an error instead of a number, check that your data starts in column A, so Event Date sits in column G and Profile Created in column H.

Frequently asked questions

What time zone are the dates in the Cometly export?

Both Event Date and Profile Created are exported in your Space’s time zone (a Space is one workspace in your Cometly account). Because both dates use the same time zone, the days between them are not affected by it.

Can I download the contact list as Excel instead of CSV?

Yes. In the panel, click Download, then Download Excel. The Excel file has the same nine columns in the same order, with the dates written as text in the same format, so the same formulas apply.

Does hiding columns in the panel change the export?

No. The download always contains the same nine columns in the same order, whichever columns you show or hide in the panel. Event Date stays in column G and Profile Created in column H.

Next steps

Still have questions or need a hand? We’re happy to help. Reach our team at support@cometly.com.