Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Trello Report showing Each User's Most Recent Activity

Hi all, 

I am brand new to the Atlassian Community, but have been working in Trello for a few months. I work with a volunteer group who uses Trello to organize our tasks. Individual volunteers can log in and join a card any time they are free. 

We're noticing quite a bit of user bloat. That is, we have a number of people who have signed up to volunteer but never joined a card or completed tasks on a card. We'd like to be able to run a report showing something relating to user activity that **includes** inactive users. 

A few potential examples of what we have in mind: 

  • number of cards joined OR tasks completed in a specific date range (best, but probably the most difficult to achieve)
  • number of cards joined or number of tasks completed (without a date range, this would require some tracking to determine whether the user is still active or has only been active in the past)
  • last login (wouldn't necessarily show us user activity, but would give us something)

We are open to using a powerup, though I haven't been able to find one that would give us an off the shelf fix. It seems like this *might* be possible in the future when we are able to upgrade to a paid account and use the expanded Butler features, but I don't see a clear pathway to exporting the data we're looking for.

Any help is greatly appreciated. Our org is hosting a fundraising event this weekend and we expect to have access to funds for a solution shortly.

Thanks very much! JNS

3 answers

1 accepted

1 vote
Answer accepted
Iain Dooley Community Leader Sep 23, 2020

@Jordan Stoeger This Trellinator function will give you a list of members who are not a member of any card in the board that was edited in the last month:

You can run it by copying and pasting the code into BenkoBot here:

Just update the board name up the top, then run the code. You can save a link to that snippet to re-run it once per month or whenever you like in order to see a list of people who haven't been joining any cards on which there was activity this month.

There's more you could do with the code obviously, the documentation for Trellinator is here although only a subset of the total functionality is executable inside BenkoBot currently:

Thank you so much @Iain Dooley !

This is exceptional!! I do have a few questions:

How is "this month" defined? If it's run today, 9/24, does it look back to 8/24? Or does it check the past days in the current month (9/1 to 9/24) or... something different altogether? 

Benko took a few minutes to run, and afterward, it says, "You have used up 4 of your 600 free minutes" -- I went to but there doesn't seem to be a place where I can learn more about the pricing structure. As a budding non-profit, we have to be very careful about which tools we become dependent on. Obviously, we could go a good long while on 600 minutes at this rate! But I'd still like to be able to tell the team what we can expect going into the future.

Many thanks! JNS

Iain Dooley Community Leader Sep 25, 2020

@Jordan Stoeger glad it helps, the "edited:month" is just Trello's standard search modifier, it will look back one month from today, so if it's the 14th of October, edited:month will return cards that have been changed since the 14th of September. You can also do something like "edited:30" for the previous 30 days:

It's actually 10 free minutes that you get with BenkoBot, there's a bug in the interface that prints the number of seconds but calls it minutes :)

We have developed pricing for it but haven't published it yet. It's also going to be extended to allow things like notification handling and scheduled functions, as well as a "library" that would operate similar to board buttons to save your functions/snippets.

There will be an "ad-hoc" plan where you can execute one off code only (as you did above) which will cost USD$10 for 1,000 minutes with a 12 month expiry. Other plans then allow you to have notification triggers/scheduled commands and so on.

You can also run Trellinator functions in Google Apps Script which means you can host it in a Google user account, so for example if you already use G-Suite you can just setup a Trellinator instance in your own user account and it won't cost you anything. You can read more about this version of Trellinator here:

Trellinator is actually an open source project I developed, and BenkoBot is the commercial hosting version of it, and Google Apps Script is like the free "community" edition.

The Google Apps Script version already has notification handling and scheduled commands, it's just much trickier to setup.

None of this is presented with anything approaching any clarity on the website yet :)

Feel free to email if you need any further information.

Awesome. Thank you so much.

If there were other tasks similar to this, would Benko be interested in working with us to develop code snippets like this one? 

Our team will be discussing Benko tomorrow at our meeting. Thanks again!!

Like Iain Dooley likes this
Iain Dooley Community Leader Sep 28, 2020

@Jordan Stoeger yep, that's what we do :) Email and we can set up a call to discuss

Hi @Iain Dooley  --

I am having problems with the BenkoBot API today. Every time I try to authenticate it gives me this error: 

Failed to fetch undefined

I tried going into my Trello account's settings to revoke and re-authenticate, but it gives the same error (although when I go to settings, it is clear that it was authorized).

Can you help me get it working again?

Thank you.

Iain Dooley Community Leader Oct 15, 2020

@Jordan Stoeger what a headache for you! I can't really investigate very easily without knowing your Trello username, can you send me the Trello username that you have registered with to Thanks!

Iain Dooley Community Leader Oct 20, 2020

@Jordan Stoeger just wanted to make sure you received my follow up email about this. We got it sorted over the weekend. Thanks!

Iain Dooley Community Leader Oct 20, 2020

@Jordan Stoeger oh hello just got your reply :)

I seem to be late in this topic, but maybe it helps other latecomers. We had the same requirements at UBit and implemented our own solution that we are now offering to the community. Trial version is free. Good comments will be rewarded with a free licence!

@Jordan Stoeger 

 the user events mentioned in your post are recorded as Trello actions on a card(except login). The access to these events where you need an immediate response is usually with Butler or other automation tools. But if you are looking to some analysis using reports, then you have to fetch these actions via API, combining through the board for member and card statuses. Here’s an example that uses a combination of Butler, the API etc for an unassigned member on the board.

Note also to report on checklist item assignment and due dates (not entire checklist) is still a challenge within Trello but doable ... read the discussion here

Let me know should you have more questions. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Trello

A Trello template to help you clean up your Confluence Space

Calling all Trello + Confluence users! We're celebrating all things Work and Wellness in our Confluence collection, where our team has been sharing activities to create more mindfulness around the ...

958 views 4 13
Read article

Atlassian Community Events