Skip to main content

Reviews > Updated at

Tom Williams avatar
Written by Tom Williams
Updated this week

Dataset: Reviews from pull requests

Entity: Pull Request Review

Field ID: updated_at

Type: Datetime

Description: The datetime at which the review was last updated.

Source: App

From:

Github (Reviews)

updated_at

Gitlab (MRs)

review_event.created_at

Bitbucket (PRs)

pull_request.participants.*.participated_on

Azure DevOps (PR Threads)

lastUpdatedDate

Jira

N/A

ClickUp

N/A

Trello

N/A

Reporting Use Cases

The Updated At field from the Reviews dataset is a specialized timestamp that records the last time a review was modified after its initial submission, for instance, if it was edited or dismissed. Its primary use is for auditing and tracking changes to the review record itself.

  • Filtering for Changed Reviews: You can use this field to find reviews that were altered after they were first submitted.

    • To create a report of all edited reviews, you can use a formula where Updated At > Submitted At. This is useful for auditing purposes, especially to see if feedback was changed or clarified.

    • To find reviews that were recently dismissed or changed, you can use a filter like Updated At in the previous 7 days.

  • Analyzing Time to Update: You can measure the time between a review's submission and its subsequent modification to understand how and when feedback evolves.

    • A custom formula like (updated_at - submitted_at) / DAY() can calculate the "time to revision." A short duration might indicate a quick correction, while a long duration could be the result of a review being dismissed much later in the pull request's lifecycle.

  • Distinguishing from Core Timestamps: For all standard reporting on review cycle times and throughput, the Created At and Submitted At fields should be used. The Updated At field is reserved for the specific use case of tracking modifications to a review after it has already been completed.

Did this answer your question?