Reporting: can you extract monthly activity statistics?

[Stuart Sheridan]

I'd like to be able to extract and visualise momentum/activity statistics around:

- New Cards created per month

- Cards in Progress per month

- Cards Completed per month

- Cards Blocked per month

Is there a data extraction/CSV/API that can enable us to do this type of reporting?

[Iain Dooley · Accepted solution]

@Stuart Sheridan The trello API is very comprehensive. This is a good primer on using Apps Script to create reporting:

http://www.littlebluemonkey.com/blog/automated-trello-reporting-using-google-spreadsheets

You might also be interested in this tool I wrote in part inspired by the work of Little Blue Monkey:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271