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
- Click Report Builder in the sidebar and add the event you want to analyze as the metric (for example Schedule).
- Set the Date Range (for example This month).
-
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
- In the panel, click Download, then Download CSV.
- Save the file to your computer.
Step 3: Import the CSV into Google Sheets
- Open Google Sheets (free for anyone with a Google account).
- Create a new spreadsheet.
- Click File > Import.
- Upload the CSV file you downloaded from Cometly.
- Confirm the import. Your data now appears in the sheet.
- Make a copy of this Google Sheet, which already contains the formulas.
- Copy your data from the imported CSV and paste it into columns A to I of that sheet.
Optional: build the Google Sheet yourself
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:Step 5: Create a “time between” column
In column L, enter this formula:Step 6: Calculate the average
In an empty cell, enter this formula, changingL74 to the last row of your data: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 to see the other places you can download data from.
- Build a report in Report Builder to change the metric, filters or date range behind the contact list.
- Build a cohort analysis dashboard to track how a group of contacts converts over time.
- Attribution models and windows to understand how conversions are credited to your ads.