Producing a report providing dates on when cards were moved to a particular column

[Peter Cranston]

Hi,

One of my clients has asked If I can produce a report providing date when cards are moved to a particular column. He plans to use this as a priority list for his team to complete actions associated with this column.

I am using Trello premium but cannot see how to access this date which is available on the activity at the bottom of the card.

Any guidance much appreciated.

Regards,

Peter C

[Lara · Accepted solution]

Hi Peter,

Thanks for reaching out!

Right now, the CSV export from Trello Premium doesn't include actions (such as card moves), because there isn't a great way to represent that kind of many-to-one data points in a spreadsheet. That information is available in our JSON export if you have access to an engineer.

We have more info on this here:

• Exporting data from Trello: https://support.atlassian.com/trello/docs/exporting-data-from-trello/
• Making sense of Trello's JSON export: https://support.atlassian.com/trello/docs/making-sense-of-trellos-json-export/

Please let us know if you have any other questions, and we'll be happy to help.

All the best,

Lara
The Trello Team

[Peter Cranston]

Thanks for the update,

In the meantime I have managed to get accurate enough information form a NAVE export which provides the duration in seconds that each card has been in a column. A little Excel adjustment and I have my dates.

I will also look at JSON for future requirements.

Many thanks,

Peter C.

[Cary Lee]

To resurrect this thread, what is the key text to look for in the JSON file that shows that a card has moved? For example, on the card itself, the text would be "<member> moved this card from <LIST 1> to <LIST 2> <date, time>". However, I can't seem to find the relevant string to isolate this (as a first step, to then analyse).

[Lara]

Hi Cary,

You'll want to look at the updateCard action. Within that, you'll see which member moved the card from original list (listBefore) to destination list (listAfter).

I hope that helps!