We created high quality database with 10,000 contacts from scratch
Client Overview
-
Sector Insurance
-
Hired service: Virtual Assistants
-
Headquarter: California
-
Client since: 2021
Orion International Insurance specializes in different types of insurance like international employee benefits, health insurance for people living abroad, high-risk insurance, disability insurance with high coverage, and travel medical coverage.
One of Orion International Insurance's subsidiaries, called Student Care, wanted to grow their business by focusing on college students. To carry on with their plan, they needed to gather information about the market and potential customers.
William Cole, from Student Care, reached out to Virtual Employee for help. They wanted Virtual Employee to create a database with details of decision makers from the colleges. After conducting interviews, they selected Ribhanshu Raj for the job.
Data You Can Trust
To introduce a specialized insurance plan for students enrolled in colleges and universities, Student Care decided to reach out to the decision makers and pitch their insurance plans. Ribhashu was therefore tasked to scourge through the internet, college websites, social media and other sources to put together a contact database.
Targeting the decision makers
To reach the end users, i.e., the students, the company would need to gain approval from the decision makers at each college. Only upon their approval, the insurance provider could directly market to the students and facilitate offline connections with insurance agents.
Conduct research focused on one US states at a time. Find out the schools and college under United Healthcare Student Insurance. Highlight schools that do not have an active insurance provider.
Divide the institutions based on whether it was a private, public or community college and mention the number of enrolled students. Include information about the type of insurance, if any was available for the college. This would include differences in domestic and international plans for students and the charges for the same.
Exclude any educational institution with less than 300 students from the database. Including such institutions in the marketing campaign could undermine the profit margin for the company.
To Find UnitedHealthcare Student schools - https://www.uhcsr.com
To Find Schools – https://www.niche.com/colleges/search/best-medium-colleges
Find contact information: College websites, LinkedIn, Facebook
The Internet Detective
Data Analysis Professional
12 years of experience
Ribhanshu Raj, an experienced VA leveraged his analyst, and data mining skills to single-handedly plan the data collection system as well as implement it. Gradually a large repository of prospect data was created .
He had to conduct very specific research to procure relevant information for the client. What’s more, the client expected him to compile a dataset worth 3,000 to 4,000 prospects. But Ribhanshu compiled data from 10 states which accounted for over 10,000 prospects.
- Data Mining
- Data Collection
- Data Analysis and Visualization
- Primary and Secondary Research
Power of Persistence
From a bird's eye view, the approach may appear simplistic. However, when dealing with large data sets, unforeseen challenges inevitably arise. Here are two such challenges and how he solved them.
Challenge #1
At times, the official source for information are not enough to find the decision makers' contact details. The hierarchy is not clearly mentioned on the website or the information present has not been updated recently.
Solution
In situations like these, our VA decided to stray away from the more official data sources and depend on LinkedIn and even college Facebook sites. These portals are regularly updated and have the required information.
Challenge #2
Repetition is a common problem as some universities and colleges are repeated in the source websites. This happens often when a college has been renamed or when a single university system controls two or more universities.
Solution
He applied a formula on the database to highlight any repeated information, be it name of college or any contact information. This helped in eliminating any repetition and ensure all the 10,000 prospects were completely unique.
From Data to Decisions
Compiling raw data is a feat in itself but that only the initial step for planning a marketing campaign. What follows next, is analysing the data to identify patterns and trends that can be used to answer the arising questions for the campaign. And that's what our resource did next. He created demonstrative reports that had easily digestible data that made decision making process much easier for the client.
Coordinated,
Consistent, Complete
We chose three words, but out client William Cole had a lot more to say about our resource's work. It is rare to find an assistant who not only meets the set goals but consistently surpasses them. After witnessing Ribhanshu's high work standards, William decided to extend our contract, and as a result, VE and Orion International Insurance have maintained a strong partnership for over two years now.
