E10: Data Cleansing Flashcards
Maintaining accurate, current, and relevant data about your customers demonstrates…
Respect for them.
Name 5 marketing activities that data is key for.
segmentation, personalization, lead scoring, lead routing, marketing analysis.
As a best practice, ensure that your contacts provide you with…
clean data.
What is a good way to think of data management?
As a see-saw between a marketer and a customer - the more effort your customer puts in to provide clean data, the less effort you need to put in.
Maintaining clean data helps optimize use of Eloqua in the following ways: (1) _____ (2) Signature rules (3) Accurate segmentation (4) Accurate lead scoring and more precise lead routing (5) Push normalized data back to CRM
Dynamic content
Maintaining clean data helps optimize use of Eloqua in the following ways: (1) Dynamic content (2) _____ (3) Accurate segmentation (4) Accurate lead scoring and more precise lead routing (5) Push normalized data back to CRM
Signature rules
Maintaining clean data helps optimize use of Eloqua in the following ways: (1) Dynamic content (2) Signature rules (3) _____ (4) Accurate lead scoring and more precise lead routing (5) Push normalized data back to CRM
Accurate segmentation
Maintaining clean data helps optimize use of Eloqua in the following ways: (1) Dynamic content (2) Signature rules (3) Accurate segmentation (4) _____ (5) Push normalized data back to CRM
Accurate lead scoring and more precise lead routing
Maintaining clean data helps optimize use of Eloqua in the following ways: (1) Dynamic content (2) Signature rules (3) Accurate segmentation (4) Accurate lead scoring and more precise lead routing (5) _____
Push normalized data back to CRM
In the SAP case study, mergers and acquisitions had resulted in an incomplete, inconsistent, and decayed database. What did they do to improve their operations?
A Marketing Operations organization was established with a separate department focusing solely on data.
In the BI case study, a new education nurture campaign depended on reliable data and field completeness. How did the company clean their database?
Marketing & Sales identified and deleted junk data, built a new Contact Washing Machine, standardized field values, and decreased blank fields.
Name five ways data is added into a marketing solution.
1 - Form submits 2 - Contact lists 3 - Events 4 - Webinars 5 - CRMs
True or false? Data cleansing is a continual process.
True.
The six phases of the Data Quality Process are (1) _____ (2) Analyze (3) Clean (4) Update and integrate (5) Report (6) Monitor
acceptance criteria
The six phases of the Data Quality Process are (1) acceptance criteria (2) _____ (3) Clean (4) Update and integrate (5) Report (6) Monitor
Analyze
The six phases of the Data Quality Process are (1) acceptance criteria (2) Analyze (3) _____ (4) Update and integrate (5) Report (6) Monitor
Clean
The six phases of the Data Quality Process are (1) acceptance criteria (2) Analyze (3) Clean (4) _____ (5) Report (6) Monitor
Update and integrate
The six phases of the Data Quality Process are (1) acceptance criteria (2) Analyze (3) Clean (4) Update and integrate (5) _____ (6) Monitor
Report
The six phases of the Data Quality Process are (1) acceptance criteria (2) Analyze (3) Clean (4) Update and integrate (5) Report (6) _____
Monitor
How can you enforce a high threshold for data quality acceptance criteria?
Help your customers input accurate data through form submits.
Give three examples of things to check for when analyzing data.
Email addresses in standard format? Zip Codes have at least five digits? Phone Numbers hae right number of digits and area codes?
Cleaning may involve what two processes?
Data standardization and data enrichment.
What is data standardization?
Updating data as per the company’s or global standards - for example, making sure all telephone numbers have country codes.
What is data enrichment?
Adding to or enhancing the existing information; for example, updating the contact’s state based on the zip code.