Just wanted to post some ideas on how we're using CommitCRM reports:
1) Beginning of the month we run an Assets Listy by Warranty/License Expiration report.
> Reports > Assets > Assets List by Warranty/License Expiration then click Generate
- We leave everything checked except 'Not Active'
- We select the Wrnty./Lic. Exp: we choose the current month i.e. May 1 out two months i.e. July 31.
- We click on print preview to confirm we get the report we're looking for then print to PDF. We then work our way through the list calling customers getting OK to renew Antivirus, hardware warranties, GoDaddy SLL certs and much more.
2) Quarterly we run a report to see clients who have equipment older than 3 years. A great opportunity to find new sales opportunities within your existing client base.
> Reports > Assets > Assets Lists the click Generate
- We leave everything checked except 'Not Active'
- We select the Purchase date: we choose January 1, 2001 (or older) through the April 30, 2005 (current month and 3 years prior to current year.)
- We click on print preview to confirm we get the report we're looking for then print to PDF. We then call clients and work on getting them to ugprade equipment.
These are just a few of the reports, would love to hear other report ideas from CommitCRM users.
Thanks,
Brian Williams
Advantech NW
1) Beginning of the month we run an Assets Listy by Warranty/License Expiration report.
> Reports > Assets > Assets List by Warranty/License Expiration then click Generate
- We leave everything checked except 'Not Active'
- We select the Wrnty./Lic. Exp: we choose the current month i.e. May 1 out two months i.e. July 31.
- We click on print preview to confirm we get the report we're looking for then print to PDF. We then work our way through the list calling customers getting OK to renew Antivirus, hardware warranties, GoDaddy SLL certs and much more.
2) Quarterly we run a report to see clients who have equipment older than 3 years. A great opportunity to find new sales opportunities within your existing client base.
> Reports > Assets > Assets Lists the click Generate
- We leave everything checked except 'Not Active'
- We select the Purchase date: we choose January 1, 2001 (or older) through the April 30, 2005 (current month and 3 years prior to current year.)
- We click on print preview to confirm we get the report we're looking for then print to PDF. We then call clients and work on getting them to ugprade equipment.
These are just a few of the reports, would love to hear other report ideas from CommitCRM users.
Thanks,
Brian Williams
Advantech NW
Comment