skip to content

Analysis / Revenue operations and CRM hygiene

Find impossible lifecycle dates in CRM records

Use Proforma to find impossible lifecycle dates in CRM records. Get lifecycle timestamp exception table from your business data with this copyable prompt.

A starting point for

Revenue operations manager · Sales operations analyst

Bring this question into Chat

Your starting prompt.

Validate lifecycle timestamps for [record cohort]. Find reversed sequences, future dates, missing milestones and unusual zero-duration transitions under our supplied lifecycle rules. Group exceptions by import batch and source timezone to locate likely data causes. Show original timestamps and the failed rule for each record. Do not repair dates by guessing; prepare a prioritized investigation list with affected metric counts.

Copy this starting point, then replace the placeholders with your own inputs.

Method and review

Keep the assumptions visible.

Check ownership, identifiers, stage definitions and activity dates before interpreting performance. Preserve the original record IDs and send ambiguous cases for review.

For this task, check

Historical imports can legitimately collapse timestamps unless original lifecycle dates are available.

This starting prompt has no published worked example yet. Begin with a small sample and check the calculations before relying on the result.

Before you begin

  • Uploaded exports or permitted Data covering the listed inputs

Work with permitted files or queryable data. Verify the result against the original records.

Take the next step

Make it your investigation.

Copy the prompt above, create or open your Workspace, and paste it into Chat. Add the inputs you have permission to use and adapt the assumptions with your agent.

Start exploring

Your prompt is carried by copy and paste. Signing up does not submit it or start this work automatically.

Or start with your own agent

The setup prompt includes this public task. Your agent will help you connect when needed and use the access you approve.

Choose Claude, Codex, or Cursor—or copy the prompt to use anywhere.