> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cometly.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Calculate the time between contact creation and an event

> Calculate the time between contact creation and an event: export a report's contact list from Cometly and average the days in Google Sheets.

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.

[Calculating Time Between Profile Creation and Event Completion](https://www.loom.com/embed/85bfab5b71024826aa6e583ca63d2458)

## 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](https://docs.google.com/spreadsheets/d/1wHJqiyOBUVQ7XQH8J6LD9jnJb4MgFIxnnhxep1rIbm0/edit?usp=sharing), 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.

> [accordion] Optional: build the Google Sheet yourself
>
> ### 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:
>
> ```text theme={null}
> =DATEVALUE(REGEXEXTRACT(G2,"[A-Za-z]+ [0-9]{1,2}, [0-9]{4}")) + TIMEVALUE(REGEXEXTRACT(G2,"[0-9]{1,2}:[0-9]{2} [APM]{2}"))
> ```
>
> In column K, convert the Profile Created date (column H) with this formula:
>
> ```text theme={null}
> =DATEVALUE(REGEXEXTRACT(H2,"[A-Za-z]+ [0-9]{1,2}, [0-9]{4}")) + TIMEVALUE(REGEXEXTRACT(H2,"[0-9]{1,2}:[0-9]{2} [APM]{2}"))
> ```
>
> 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:
>
> ```text theme={null}
> =DAYS(J2,K2)
> ```
>
> 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:
>
> ```text theme={null}
> =AVERAGE(L2:L74)
> ```
>
> 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

* [Export and analyze Cometly data](https://docs.cometly.com/guides/analyzing-data/export-data.md) to see the other places you can download data from.
* [Build a report in Report Builder](https://docs.cometly.com/guides/report-builder/build-a-report.md) to change the metric, filters or date range behind the contact list.
* [Build a cohort analysis dashboard](https://docs.cometly.com/guides/dashboards/cohort-analysis.md) to track how a group of contacts converts over time.
* [Attribution models and windows](https://docs.cometly.com/guides/analyzing-data/attribution-models-and-windows.md) to understand how conversions are credited to your ads.

Still have questions or need a hand? We're happy to help. Reach our team at [support@cometly.com](mailto:support@cometly.com).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.