Skip to main content

How to Calculate Time Between Profile Creation and Event Using Cometly Data

You can easily calculate time between profile creation and a specific event using Cometly reports and a Google Sheets workflow. This guide walks you through how to do that step by step.

Updated over a week ago

In this example, we’ll calculate the average number of days between when a profile was created and when a “Schedule” event occurred for the current month.

Step 1: Create and Open a Cometly Report

  1. In Cometly, create a report filtered to the event you want to analyze (e.g., Schedule).

  2. Set the date range (for example, This Month).

  3. Open the report to view all matching events.

    • You’ll see rows that include:

      • Event Date

      • Profile Created Date

Step 2: Export the Report as a CSV

  1. Click Download CSV from the report.

  2. Save the file to your computer.

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 will now appear in the sheet.

  6. Make a copy of this Google Sheet

  7. Copy and paste your data from your imported CSV into the Columns A-I of the above Google Sheet

If you want to build out the formulas in those columns instead of just copying the google sheet above, you can do that by following the additional steps below:

Optional Steps (If you want to build the Google Sheet yourself)

Step 4: Format Date Columns Correctly

For calculations to work properly, Google Sheets must recognize the date columns as dates.

  • In Column J, format the Event Date column by entering the following formula:

=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, format the Profile Created Date column by entering the following formula:

=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}"))

Once formatted, the dates should display in a standard date format instead of raw timestamp values.

Step 5: Create a “Time Between” Column

  • Create a column L for "Time between dates", enter the following formula:

    • =DAYS(J2,K2)

  • Press Enter, then drag the formula down to apply it to all rows.

This will return the number of days between profile creation and the event for each record.

Step 6: Calculate the Average Time Between

To calculate the average across all events:

  • In an empty cell, enter:

    • =AVERAGE(L2:L74)

This gives you the average number of days between profile creation and the event across the selected date range.

Did this answer your question?