Data Cleaning Tool

Good data leads to

good decisions.

www.surveygizmo.com

800-609-6480

Make Informed Decisions

• The goal of your survey is to collectaccurate data so you canmakeinformeddecisions

Bad Data = Bad Decisions

• Pooranswerqualitymuddy’s yourdata

•You needhigh qualitydata to makethe right decisions

ManualData Cleaning

• Sifting through data is time consuming

•Reviewingdata introducesinterpretation bias

Automated Data Cleaning

• Automatingdata cleaningprocess saves time

• Eliminatesinterpretation bias

Why You Need to Clean Your Data:

-Poor Data Quality – Contributor 1

Poor Data Quality – Contributor 4

Questions are irrelevant to respondent

Disengaged respondent

Respondent is speedingthrough the survey

Respondent is not providingtruthful answers

What Causes Poor Data Quality:

Poor Data Quality – Contributor 3

Clean Data

= Data you can act on!

Quarantine

• Speeders

• Suspect Answers

• Review & Remove

Quarantine Low Quality Responses:

Quarantine

Speeders

Disengaged

Respondents

Suspect Answers

Dirty Data

1Easily identify poor quality responses.

2Define the acceptable bad data threshold.

3Automatically remove poor responses.

Benefits of A Data Cleaning Tool:

Start Cleaning Your Data!

SpeedingSpeeding through a survey is the biggest indicator that a responding is

ready and answering your questions truthfully.

Other Poor Data Indicators:

• Straight-lining or Patterned Responses

• Gibberish Text Responses

• Fake Answers – incorrect phone or email

• Trap/Red Herring Questions

• Consistency Check questions don’t match

• All Checkboxes are selected

• Single Checkboxes are selected

You’re in Control of Your Data:

• Select which flag to use

• Define flag weight

• Set dirty data score threshold

Logic Condition for Trap Questions

Dirty Data Indicators:

Quarantine Threshold

Review Quarantined Responses

Select individual responses to view data details.

Quarantine or Restore Responses:

. You have the option to restore all or specific quarantined responses.

Report on Clean Data:• Only clean data is displayed in the Summary Report

Clean Data =

Data you can act on!

www.surveygizmo.com

800-609-6480