Exporting board activity but most all entries have the same "Last Activity Date"

[Heath]

I see that I can view the activity on a board, and I see that I can export to a CSV. The problem with viewing the activity is that I can't really get any metrics on the activity being only viewable in the board activity list to the right. When I export to CSV, I see the activity but noticed the last activity dates for almost all of our activities are the same date (2023-10-23). 

I know this is not true, but it makes the CSV export unusable to get metrics from the board activity.

The metrics I'm trying to get is user activity on the board whether commenting, creating a new card, moving a card to the "Done" list, etc.

How are others getting activity metrics or is this not possible?

[Rasmus Wulff Jensen · Accepted solution]

The Reason Last Activity Date are the same, is because it also include position of a card in a list as an activity, so if you move a card to the top of the list every card below get a new position and thereby a new "last activity" (making that field completly useless) 😢

The data for "true last activity can only really be found using the Trello API as far as I know (that is how I do it)

[Heath]

Very nice explanation. We'll look into the API. Much appreciated!