Skip to main content

Customer Activity Date and Days Filters

Filter customers based on when key activities happened using fixed dates or rolling days since today.

Kolleno Support avatar
Written by Kolleno Support
Updated this week

Use these filters to analyze customer engagement, payments, and communications over time or in continuously updating views.

Date vs Days Filters

Kolleno provides two types of activity filters depending on how you want to analyze customer behavior.

Date filters

Use Date filters when you need to review activity within a specific, fixed time period.

Example
โ€‹Review customers contacted during a campaign
Date of Company last communication between December 1 2025 and January 01 2026


Days filters

Use Days filters when you want to analyze activity relative to today.

Example
โ€‹Follow up customers you have not contacted recently
Company days since last communication > 14


Available Filters

Date Filters (Specific Dates)

Use these filters to find customers based on an exact activity date.

  • Date of Company last action

  • Date of Company last communication

  • Date of Company last manual communication

  • Date of Customer last action

  • Date of Customer last communication

  • Date of last action (Company or Customer)

  • Date of last payment received

Supported operators
Equals, before, after, and date range.


Days Filters (Relative to Today)

Use these filters to find customers based on how many days have passed since an activity occurred.

  • Company days since last action

  • Company days since last communication

  • Company days since last manual communication

  • Customer days since last action

  • Customer days since last communication

  • Days since last action (Company or Customer)

  • Days since last payment received

Supported operators
Greater than, less than, equals, and ranges.

A Days filter calculates the number of days between today and the selected activity:

  • Positive numbers mean the activity happened in the past

  • Zero means the activity happened today

  • Negative numbers indicate a future date

Because these filters are based on โ€œlast action,โ€ records with negative values will not return results.

Did this answer your question?