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

[Barnaby Page]

I have a board for team workflow tracking. Cards are moved from one list to another as they progress through workflow stages. Eventually, they all end up in a "finished" list and stay there. So, pretty standard setup.

What I want to do is get data on the days between creation of a card and moving to the "finished" list. I hoped that CSV export might provide all the card activity dates, in which case I could easily extract the data in Excel, but it doesn't seem to.

My ultimate goal is to get the average days for all cards created in a given period, but having just the numbers for individual cards would be a good start.

Maybe there's a Power-Up that could do something like this?

[Oleksandr · Accepted solution]

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.