Monday.com Board Data Quality Audit
Find missing, inconsistent and stale entries.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Audit data quality on this monday.com board using the export: [BOARD_EXPORT]. Expected rules for entries: [DATA_RULES]. Today's date: [TODAY]. Describe the checks in the order you ran them so I can repeat them with a filter on the board. Calculate the number of items, the share with no owner, no date and no status; items with end dates before start dates; items marked Done with future dates; items not updated in more than 30 days; and inconsistent status labels. Give the share affected by each problem and by at least one, with arithmetic. Example (invented board of 150 items): no owner 18 (12 percent), no date 27 (18 percent), end before start 4. Warn me if the export lacks columns needed for a check or is too short to draw conclusions. Return a table with counts and examples, a clean-up plan ordered by effort, and rules to prevent recurrence (required columns, automations). Do not delete items, and list questions for the board owner about unclear data.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.
See an example result (fictional data)
Invented board of 150 items. No owner 18 (12 percent). No date 27 (18 percent). End before start 4. Done but future dated 6. Untouched over 30 days 33 (22 percent). At least one problem: 61 of 150 = 40.7 percent. Plan: required owner and date columns; clean-up list of 61 items; 90 minutes. Reading: 4 in 10 items have at least one problem, and missing dates are the biggest group. Fix in order: fill owners (18), fill dates (27), correct end-before-start (4) and done-but-future (6), then review the 33 stale items with owners. Prevention: make owner and date required where possible and add an automation that flags items with no update in 30 days [VERIFY].
Illustrative only, made-up data. Your results will differ and must be reviewed.