Reports within dynamic custom date range

Reports within dynamic custom date range

Hi everyone,

I would like to create a set of dynamic reports to help our sales people better manage their contacts with leads and accounts.

Would it be possible to create a set of report with the following criteria?

Leads
  • If status of lead = hot then return report with all leads that has not seen activity for more than 7 days.
  • If status of lead = medium then return report with all leads that has not seen activity for more than 30 days.
  • If status of lead = cold then return report with all leads that has not seen activity for more than 30 days.
Accounts
  • If status of account = "VIP" then return report with all leads that has not seen activity for more than 7 days.
  • If status of lead = "Important" then return report with all leads that has not seen activity for more than 30 days.
  • If status of lead = "Normal" cold then return report with all leads that has not seen activity for more than 30 days.

This will help keep track of client that have not seen any activity on their account for a while so that sales people can have an indication of who to contact and when to follow up since their last contact.

Any help or suggestions will be useful.