Trying to figure out how to get data (ideally aggregate) on card activity dates

Hi Barnaby,

CSV export is not the best source for this because it is mainly useful for card fields, not for calculating workflow-stage history. Trello’s JSON export/API can contain action history, but it is harder to parse in Excel: https://support.atlassian.com/trello/docs/making-sense-of-trellos-json-export/

For a no-code setup, I’d suggest using these two options together:

1. Board Assistant - Extended Activity Log
   https://trello.com/power-ups/685016dd47b5654ae385bba6
   This can help track and export card activity such as when cards were moved between lists.
2. Cross-Board Reporting & Dashboards
   https://trello.com/power-ups/66291013ec3abfbf13b255c6
   This is better for building dashboards/tables and filtering cards by dates, boards, lists, etc.

For future tracking, the cleanest setup is to add a date custom field like Finished Date, then create an automation rule that sets this field when a card is moved to the finished list. Trello’s automation docs also describe using a Completion Date custom field for reporting: https://support.atlassian.com/trello/docs/creating-reports-with-butler/

Then you can report on Created date vs Finished Date, and calculate average days much more reliably.