Create a report that shows only the last activity logged in the timeline per each account

  • 1
  • Idea
  • Updated 5 days ago
My client is trying to create a report that only shows the last activity logged in the timeline per each customer. We were hoping to be able to create a new field and populate it with a rule to flag the last activity for each customer, however, the rules engine can't write to Activity Timeline fields.

Photo of Irit Eizips

Irit Eizips, Champion

  • 2,038 Points 2k badge 2x thumb
  • Limited

Posted 1 week ago

  • 1
Photo of Sagan Sherlin

Sagan Sherlin, Champion

  • 4,866 Points 4k badge 2x thumb
Hi Irit, I had a similar question - Looking for a way to report on my customers hadn't had a Timeline Post in X time.  [And how to report on the Customers that didn't have a post.]

Here is a snippet from the post regarding creating the Report for customers not touched in x time - 

"In your Show field, pick Activity Date - choose Aggregation of Max Date (the latest date)
In your By field, pick Account Name
Then Filter by Max Date not being in last 7 days - this will show you list of customers and the last activity date
Note I also included a filter for Today as it seems Activity from CTAs can post with future activity dates "

I hope this helps!

Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 25,930 Points 20k badge 2x thumb
Hi Irit, another community member had a similar question and I outlined a solution here: