How do you manage expiration dates?

There are many reasons you may be managing or monitoring expiration dates relating to your customers. Your customers may have payment plans, licenses, or even recurring donations and you want to reach out to them before the expiration date. There are a few ways to manage expiration dates by using views, reports and/or workflows on the platform.

Nobody likes expired milk.

Nobody likes milk that has gone bad.

The first step, before using any of the following methods, is to create a field for your expiration date. If you already have one, then you can begin. If not, then ask your administrator to add it and start adding the data.

Creating a New View for a contact or account record is the quickest and easiest way for a user to manage expiration dates in First click on the Create New View button and give your new view a title like Expiring Accounts or Expiring Licenses. Make it descriptive for your situation. Next, add any filters to remove irrelevant contacts or accounts. You can even add a filter based on a date. For example, if you want to see expiration dates occurring in the current month, you can create a filter to see only expiration dates for THIS MONTH. Lastly, add the field with the expiration date to the view. Now you can view all the expiration dates. The View list also allows you to toggle from earliest to latest, alphabetically, or numerically.

Steps to Create New View to Manage Expiration Dates:

1) Click on the Tab that holds the records with the expiration date: Contacts, Accounts, Leads, etc.
2) Click Create New View
3) Name New View
4) Choose Filters
5) Add Field with expiration date to View

Reports are another way to monitor expiration dates. Click on reports and select the object with the expiration date. You can then drag and drop the fields you want to see along with the expiration date. You can also easily remove any fields you do not want to see. And, similar to creating a New View, you can be very specific with filters and filter logic. Since reports are based on time, has convenient built-in time frames, like fiscal year, this month, next month, and current fiscal quarter. There is even a built-in date range for the next 120 days. Reports can also be viewed on your personal dashboard alongside other data or information that you monitor daily. Filtering data from related objects and viewing the report on your dashboard are both benefits of the report method. Once a report is created it is easily accessible and customizable.

Steps to build an Expiration Date Report for the Dashboard:

1) Click on Reports
2) Select the Report Type or the Object or Objects with the Expiration Date
3) Add Filters
4) Choose between your records or all
5) Choose a Date Range
6) Save and Name the Report
7) Run the Report

The final way to manage expiration dates is automatically with a time-dependent workflow. This method alerts the user with an email or task when a license, support plan or recurring donation is going to expire or has expired. The workflow method is very different from Views and Reports because the task and email is relevant to one record, contact or account. If you have very few expiration dates to monitor and it is unlikely that you need to look at a view or report daily or weekly, then a workflow is a good alternative. However, if you manage hundreds of expiration dates per month, then a workflow that creates a task or email may be overwhelming.

Steps to build a Time-Dependent Workflow:

1) Ask your administrator

Each method is different and has unique benefits. We recommend using a combination of two or all three. The views are helpful for planning. The reports are helpful when measuring. And, the workflows are a great back up plan for bringing attention to an expiration date. It is much easier to hold on to what you got, than go after what you lost.

Special Note: In the Service Cloud, offered by, there is Entitlement Management. With it, a business can manage service contracts with varying support levels for its customers; add time-dependent processes, like sending out an automatic notice for renewal of the service; create reports; and, even add it to their customer portal where customers can make their own changes.

ACT! business acquired by Kristi Smith Consulting, Interlinx to focus on

Kristi Smith Consulting, based out of Chicago,
Illinois and Southern Wisconsin, has acquired the Interlinx Associates ACT!
business of Minneapolis, Minnesota. Interlinx to focus on

Broadband Internet “from border to border”

Mark your calendar on August 4, 2015, for the first ever Rural Broadband Day, to be held in conjunction with the Minnesota Farmfest.  I remember 30 plus years ago, my brother traveled from Hardin, Montana, to attend Farmfest in Southern Minnesota.  That year it rained, and he, his wife and little kids, and my mom,…

Innovate with Interlinx

Innovation is the engine that powers Interlinx Associates and it is driving us in a new direction. We have decided to focus our time and talents on, and hope our customers come along for the ride. In order to make this a quick and successful transition, we are recommending the following paths for our…

Peter Coffee visits the Twin Cities Salesforce User Group

In May of 2014 (last year), my husband and I took our teenage daughters to grab a bite at Sea Salt Eatery and see Minnehaha Falls, a place they had seen many times as young children from the back of a Burley or bike. Minnehaha Falls is a beautiful place with people from all walks…

Why do we have middle names?

One of our administrators knows the answer to why we have middle names. She was recently featured on WCCO news and shared her genealogy knowledge on the history of middle names.  The question was raised after the birth of Prince William and Princess Kate’s daughter Charlotte Elizabeth Diana. Watch the video to learn where…

Problem/Solution sets: Handling the flood of sample requests

Problem: This client generated hundreds of email sample requests that would be manually created, sometimes with different templates that the field sales person would have to keep track of and the sample clerks would have to fulfill. There were different types of sample requests (example 1), and different fulfillment locations. The original template was designed…

Getting Started with Choosing an Email Service Provider

Using email to communicate with your customers, members or subscribers is an inexpensive marketing tool when compared with printing and mailing costs. Also with the emarketing reports that many of the email service providers (ESP’s) now offer, an email campaign can provide valuable information.  Who clicked on a link, when or did they open it,…

Picking a Partner–Right Sizing

What makes a good CRM implementation partner?  At the end of the day (or at the end of the project) what really matters?  What determines success or “just ok?”  These are the top 10 factors in picking the right partner. Price: This is on the list not because it is the most important, but because…

Dreamforce 2014 Dreamforce 2014 Convention, San Francisco, CA- The first Dreamforce Convention I attended was in 2009.  At that time, we were amazed that there were around 20,000 attendees, “crammed” into Moscone Center.  Chatter was one of the big announcements.  It seemed like everyone was YOUNG! Attendees were the renegades of their company, on the…