MEET BUMBLEBEE

Associations cite record duplication and matching across multiple systems as one of their biggest data challenges. They also struggle with cleansing dirty data, identifying missing or incorrect information, and normalizing nonstandard data formats. Many associations try to tackle these issues with manual effort but are unable to keep up. This is not the way forward!

Drawing upon our background in data and automation, we set out to build a tool to help associations - of any size - better manage their data. This tool, Bumblebee, automates data transformation and cleansing activities while using data science to provide fast and accurate duplicate identification and record matching.

BUMBLEBEE

HOW DOES IT WORK?

Bumblebee assesses and transforms your data in four key ways:

Duplication ID & Matching

  • Using Bumblebee's proprietary matching technology, your data is analyzed to identify duplicates within a single file and/or matches between multiple files. Identified match candidates are returned to you with shared group ID and a confidence score.

Completeness

  • All supplied data fields will be assessed for incomplete data: NULL, Blank, #N/A, etc. You'll receive a detailed report of missing data by field.

Standardization

  • Where possible, your data is transformed to conform to a standard format (e.g. phone number format) and case usage.

Validation

  • Where possible, your data is transformed to correct invalid data (e.g. emails without '@', leading/trailing white space, URLs having 'wwww', phones/zips without required numeric characters, etc.)

Once the transformation is complete, we'll return your data back to you labeled and cleansed. From there you can begin using your new and improved data or add on additional data projects like appending, email and address validation, research and more.

WHEN SHOULD I USE BUMBLEBEE?

Data deduplication and cleansing with Bumblebee can be done at any time but we highly recommend using it if you are:

  • changing your AMS
  • integrating data analytics
  • implementing a data governance strategy
  • acquiring a new data set of unknown quality

Bumblebee is also available as a subscription service that allows you to schedule quarterly deduplication cleansing as part of your data governance strategy.

WHAT KIND OF DATA CAN BUMBLEBEE TRANSFORM?

Bumblebee is optimized to transform association membership data but can be used to transform other record types as well. Have a different type of data that you're interested in having transformed? Drop us an email at data@associationtrends or give us a call to discuss your specific data challenges.

HOW LONG DOES IT TAKE?

Most projects can be completed in as little as one to two weeks from receipt of data. Additional data projects (appending, research, etc.) are on a case by case basis.

HOW MUCH DOES IT COST?

Bumblebee data transformation services are available on an individual project basis and as an annual ongoing data transformation cleansing service. Packages start at just $2,000 for a single data source and up to 50,000 records.

IS MY DATA PROTECTED?

Your data will never be used for any other purpose other than its transformation and cleansing. We maintain strict data privacy policies internally and with our third party vendors.

WHERE DOES THE NAME BUMBLEBEE COME FROM?

AT Bumblebee's name has not one, but two origin stories. Firstly, bees are some of the most organized creatures on earth. A colony of bees can move into an abandoned hive, clean it up and get it back in working order, just like Bumblebee does with your data. Second, we are big fans of the Transformers and Bumblebee is everyone's favorite good guy!

DO YOU PROVIDE OTHER DATA SERVICES?

Bumblee is an extremely efficient tool to get your data in shape but often associations need more help to improve and enhance their data. Below is a list of other data services that our team can provide.

  • Smart-appending empty fields
  • Data merging & mapping
  • NCOA & email validation
  • Custom prospect research
  • Ongoing cleansing services (annual subscription)
  • Data mining on unstructured data
  • Data science consulting for modeling projects

WANT TO KNOW WHERE YOUR DATA STANDS BEFORE YOU GET STARTED?

GET YOUR DATA REPORT CARD!

Take the first step in data improvement when you submit a sample of your data for review by Bumblebee. You'll receive a Data Report Card with grades for Duplication, Completeness, Validation, Standardization. You'll also receive an action plan to improve your data.

DUPLICATION

F*15%

COMPLETENESS

C-72.4%

VALIDATION

A93.6%

STANDARDIZATION

B+86.8%

SUBMITTING YOUR DATA FOR SCORING

  • For organziational records, sort by organization name alphabetically and send the first or last 1,000 records
  • For person records, sort by last name and select the first or last 1,000 records
  • Excel or any flat file format is acceptable
  • Report cards are typically returned within 5 business days
  • Send files via email to data@associationtrends.com

*Unlike the other areas of grading, duplication does not follow the typical percentage ranges of the grading scale. The following scale is used. (0-1%) (2-4%) (5-9%) (10-14%) (15%+)

I Have a Data Challenge... HELP!

In order to improve upon the ongoing challenge of providing complete and accurate data, which is user-generated by our members, we began licensing select data through a custom data project. In addition to the additional data they provided, the AT data team provides data hygiene services, and we couldn’t be more pleased with the results. Not only have we found the data to be complete, but the implementation process was truly a custom solution for our unique needs.

Christine ‘Shimo’ Shimasaki
DMAI

^