CRM Made Easy: How to Track Account Renewals

CRM Made Easy: How to Track Account Renewals
by Michael Hurley – September 2015

Are you using your CRM system to project final renewal numbers? Are you able to identify accounts that might be harder to renew?

The Way We Were

In 2012, during my first renewal campaign  with the Houston Astros working with then Director of Season Ticket Services, Alan Latkovic, our “CRM system” was an Excel spreadsheet with every single account listed as a line item and the columns  laid out to reflect “touch points” or times of contact with Season Ticket Holders (example below).

hurley tpm

This method of touch point management worked in lieu of an actual CRM system. But, there isn’t much tracking and it’s not easy to project renewals. When we rolled out Microsoft Dynamics CRM before the 2013 renewal campaign, our eyes were opened to the benefits of tracking renewals. Today, after years of tracking accounts and tendencies, we can project renewal numbers to the percentage point even before we receive the first response.

Using renewal scores we have real-time information on which accounts require a little more “love.” We quickly see which accounts have not responded at all. We strategically plan an offsite visit with them and maybe even take Orbit along.

orbit

Using CRM to Track Renewals

Alan Latkovic (@AlanLatkovic), Senior Director of Season Ticket Services and Operations with the Astros, accentuates the importance of using  CRM to track renewals and project the final renewal numbers.

“With the tools of CRM we are able to score accounts who respond to the initial renewal call daily, monthly, and annually.  Providing this data to our analytics team, we are then able to project renewals and carry the information over each season to create new renewal benchmarks.”

Tracking every conversation and response for each account ultimately makes the big picture become more clear. The Astros use a very simple but effective renewal tracking method throughout the renewal campaign. We categorize accounts based on an initial indication of renewal.  If an account’s initial response to us when they receive their invoice is that they are not renewing, we mark them as “unlikely to renew” in CRM, at the same time if an account lets us know they are planning on renewing and processing the invoice, or “the check is in the mail” we mark them as “likely to renew” in CRM.  Using renewal scores, we can project what an account will do, and by tracking the data of renewal scores over time, we then have an idea of what percentage of accounts in each score grouping will ultimately renew.

The Importance of Tracking Renewals

When it comes down to it, we simply cannot overlook the importance of tracking renewals and building renewal campaigns around the tools of CRM. Katherine Tran, Manager of Membership Services with FC Dallas, stresses the importance of being able to forecast future renewal cycles by using CRM:

“The importance of tracking renewals is second to none.  It allows teams to pinpoint customer trends over the seasons and helps forecast future renewal cycles.  Teams can plan their renewal efforts and campaigns based on data from previous years.”

When following trends in renewals over the years, and knowing which accounts renew and when, a much clearer picture emerges when forecasting renewal numbers.  While using Excel will get the job done, it’s no comparison to the benefits a true CRM system provides.


Cover photo courtesy of Ezhil Ramalingam, India.

 

The Impact of Data Visualization in Sports

The Impact of Data Visualization in Sports
by Katie Morgan – November 2014

Teams constantly research to find new data sources to enhance business. Data is the life blood of the organization. Data provides the ability to make key decisions based on factual information rather than projections based on personal experiences.

Big Data Questions

Some of the biggest questions teams face when finding new data sources include:

  • Now that we have all of this data, where do we store it?
  • When our data is in a usable format, how do we compile the information for our decision makers?

The Texas Rangers currently use a data warehouse to store all of our various data sources including:

  • Historical and Current Ticketing Data
  • Demographic Information
  • CRM Data
  • Team Performance Data (present and historical)
  • Weather Information (present and historical)
  • Secondary Market Data

Why do you need a data warehouse?

Justin Foote
Justin Foote

Justin Foote, Interactive Database Coordinator with the Texas Rangers, highlights benefits of using a data warehouse to store data.

“The use of a data warehouse has given us the ability to store and report on data, both past and present. Access to fan’s previous purchasing habits is crucial in determining future trends amongst our fans. Without the warehouse, the reports and visualizations we are using would have taken days to create, as opposed to  a couple of hours.”

Data provides you the information to help with various initiatives such as:

  1. vetting the best leads to distribute to sales representatives,
  2. provide real time visualizations,
  3. offer information on purchasing trends,
  4. provide the ability to do comparative analysis year over year, and various other projects.

Visualization with Tableau

The Texas Rangers, Cincinnati Reds, and Pittsburgh Pirates all chose to use a data visualization tool, Tableau, to provide dashboards on various initiatives and projects.

Jason Witzberger
Jason Witzberger

At the Pirates

Jason Witzberger, Manager of Business Analytics with the Pittsburgh Pirates, has been a Tableau user for just under a year. He states:

“The Pittsburgh Pirates use Tableau to visualize sales and marketing trends in real-time.  With Tableau, we have access to the most up-to-date information represented in a dynamic visual format, all available from any location.  Tableau makes the data easy to understand so that we can make smarter and more proactive decisions.”

Jason points out several key benefits to using a data visualization tool:

  • Access to the most up-to-date information. Whether you are making a key decision with your data, or trying to show a new trend, having the most up to date information is of utmost importance. The Texas Rangers update data every fifteen minutes in order to provide the most accurate information to the individuals using the data resources.
  • The data is easy to understand. When providing data to decision makers and others working on a specific initiative, you always want to provide easy-to-understand information. A simplified visualization provides imperative information in an readily comprehended format. Remember the audience and cater visualizations to their needs.
Chris Calo
Chris Calo

At the Reds

Visualization tools, and in this case Tableau, offer several different ways to represent data. Chris Calo, Business Systems Analyst with the Cincinnati Reds, uses several different types of visualizations to highlight important information for his organization.

“Tableau has helped Reds management view data in a totally different way.  Whether it is a stadium heat map, viewing suite availability in real-time, or filtering through data reports, Tableau has made the understanding of data a much easier process with their visualization tools.”

At the Rangers

The Texas Rangers currently use Tableau to showcase the following information:

  • Real Time Ticket Sales updates
  • Actual Sales vs Budgeted Sales Comparisons
  • Sales Representatives Inbound and Outbound Calls
  • Real Time Game Day Turnstile Reporting
  • Real Time Merchandise Sales
  • Breakdown of Ticket Sales in our various box offices, concierge, and phone room
  • Cell Phone Anaylsis
  • Seasonal Employee Payroll Monitoring

Use your data visualization tool to showcase data in easy to view, eye catching, and easy to understand format. These tools provide you with a plethora of options, and it’s key that you find the visualization that enhances the data you are showing so that a quick and productive decision can be made for your organization.

An abundance of unformatted data can seem like a daunting task. However, with the appropriate plan in place any team or organization can convert the data into a usable format and begin visualizing real time information in a brand new way!


 

 Cover photo courtesy of http://www.tableausoftware.com/