Foremost Insurance
Migrating 20 years worth of data
The Client
Foremost is a proud member of the Farmers Insurance Group of Companies, offering a wide variety of home, life, specialty, commercial and auto insurance products and services across the United States.
The Challenge
- More than 20 years of research data for specialty policies like Mobile Homes, Motorcycles, Boats, etc.
- Questionnaires changed throughout the years to reflect the marketplace
- Surveys were conducted through various survey panel providers and vendors
- Survey data was in different software formats, depending on who did the study
- Only a SAS expert could access prior results, creating a bottleneck for decision makers
The Solution
mTab’s survey analysis software is the ideal solution for Foremost Insurance to warehouse and analyze all of their survey data. The migration and standardization of 20 years of data from various vendors, including running quality checks of warehoused data against prior printed reports, was a seamless process. The migration did not require any involvement from Foremost’s IT department, and only took a few weeks to complete.
The Result
- Access to the software by the entire organization provided the ability to pull the reports and data they need
- Cut ad-hoc response time from a couple of days to less than an hour
- Surveys were conducted through various survey panel providers and vendors
- Ease-of-use encourages more usage and in turn provides more key business insight
- All surveys (past and present) can be accessed through one single software tool
- Ability to trend ongoing research projects and combine/compare between each one
“We use mTab to trend all years of our specialty lines research and to compare studies between product lines. Overall, we‘ve cut our ad-hoc response time from a couple of days to less than an hour.”
JoAnna Carey, Marketing Development Manager
Foremost Insurance Group
