E10: Data Cleansing Flashcards

1
Q

Maintaining accurate, current, and relevant data about your customers demonstrates…

A

Respect for them.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Name 5 marketing activities that data is key for.

A

segmentation, personalization, lead scoring, lead routing, marketing analysis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

As a best practice, ensure that your contacts provide you with…

A

clean data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a good way to think of data management?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Dynamic content

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Signature rules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Accurate segmentation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Accurate lead scoring and more precise lead routing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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) _____

A

Push normalized data back to CRM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A Marketing Operations organization was established with a separate department focusing solely on data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

In the BI case study, a new education nurture campaign depended on reliable data and field completeness. How did the company clean their database?

A

Marketing & Sales identified and deleted junk data, built a new Contact Washing Machine, standardized field values, and decreased blank fields.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Name five ways data is added into a marketing solution.

A

1 - Form submits 2 - Contact lists 3 - Events 4 - Webinars 5 - CRMs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

True or false? Data cleansing is a continual process.

A

True.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

The six phases of the Data Quality Process are (1) _____ (2) Analyze (3) Clean (4) Update and integrate (5) Report (6) Monitor

A

acceptance criteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

The six phases of the Data Quality Process are (1) acceptance criteria (2) _____ (3) Clean (4) Update and integrate (5) Report (6) Monitor

A

Analyze

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

The six phases of the Data Quality Process are (1) acceptance criteria (2) Analyze (3) _____ (4) Update and integrate (5) Report (6) Monitor

A

Clean

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The six phases of the Data Quality Process are (1) acceptance criteria (2) Analyze (3) Clean (4) _____ (5) Report (6) Monitor

A

Update and integrate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

The six phases of the Data Quality Process are (1) acceptance criteria (2) Analyze (3) Clean (4) Update and integrate (5) _____ (6) Monitor

A

Report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

The six phases of the Data Quality Process are (1) acceptance criteria (2) Analyze (3) Clean (4) Update and integrate (5) Report (6) _____

A

Monitor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

How can you enforce a high threshold for data quality acceptance criteria?

A

Help your customers input accurate data through form submits.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Give three examples of things to check for when analyzing data.

A

Email addresses in standard format? Zip Codes have at least five digits? Phone Numbers hae right number of digits and area codes?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Cleaning may involve what two processes?

A

Data standardization and data enrichment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What is data standardization?

A

Updating data as per the company’s or global standards - for example, making sure all telephone numbers have country codes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

What is data enrichment?

A

Adding to or enhancing the existing information; for example, updating the contact’s state based on the zip code.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
What is updating?
Updating the cleaned data to your current database AND to the CRM if your marketing system is integrated.
26
In the data quality process, what should you report on?
Highlight the changes and share the new data.
27
What are the two types of Data Quality reports?
Contact Field Value report and Contact Field Completeness.
28
What does the Contact Field Value report show?
The percentage of Contacts with different values. For example, percentage of contacts from California.
29
What does the Contact Field Completeness report show?
How complete each field is, by percentage.
30
How can the Contact Field Completeness report be accessed?
Through the Database Health Dashboard.
31
What are the four C's of data management?
Consistent, Complete, Correct, Current
32
What does Eloqua provide to make entries for fields like Country, State or Province, and Industry consistent?
A set of pre-built standardized lists.
33
Where do most marketing databases stand with regard to completeness?
Most marketing databases have key fields that are 30% or less complete.
34
Six practices to keep data consistent include: (1) ____, (2) forms, (3) validation rules on forms, (4) social sign-on, (5) pre-populated form fields, (6) progressive profiling.
standardized data sets
35
Six practices to keep data consistent include: (1) standardized data sets, (2) _____, (3) validation rules on forms, (4) social sign-on, (5) pre-populated form fields, (6) progressive profiling.
forms
36
Six practices to keep data consistent include: (1) standardized data sets, (2) forms, (3) _____, (4) social sign-on, (5) pre-populated form fields, (6) progressive profiling.
validation rules on forms
37
Six practices to keep data consistent include: (1) standardized data sets, (2) forms, (3) validation rules on forms, (4) _____, (5) pre-populated form fields, (6) progressive profiling.
social sign-on
38
Six practices to keep data consistent include: (1) standardized data sets, (2) forms, (3) validation rules on forms, (4) social sign-on, (5) _____, (6) progressive profiling.
pre-populated form fields
39
Six practices to keep data consistent include: (1) standardized data sets, (2) forms, (3) validation rules on forms, (4) social sign-on, (5) pre-populated form fields, (6) _____.
progressive profiling
40
The Contact Data Washing Machine helps you to embed _____ into your operations.
best practices.
41
Set form fields that are primarily used for segmentation as...
Required fields
42
Think of the Contact Washing Machine as...
an oil filter within your car engine.
43
What data should you strategically focus on cleansing?
Data that will help your current marketing efforts.
44
What is an example of job title normalization?
Chief Marketing Officer can be standardized as CMO, lumped into a Marketing or Executive job function, and assigned a job level of C-Level.
45
True or false: A data quality process involves deleting contacts who are inactive.
False.
46
True or false: A data quality process involves checking the database regularly for inactive contacts.
True.
47
According to Sirius Decisions, how much does it cost to verify a record?
$1
48
According to Sirius Decisions, how much does it cost to cleanse a record for accuracy?
$10
49
According to Sirius Decisions, how much does it cost your business per record if you don't take the necessary steps to ensure that the contact information is accurate?
$100
50
Eloqua's _____ continually monitors contacts and initiates cleansing if it encounters erroneous contact data.
Contact Washing Machine
51
The Contact Washing Machine uses the following Eloqua tools: (1) _____ (2) Update Rules and (3) Cloud Connectors.
Lookup Tables
52
The Contact Washing Machine uses the following Eloqua tools: (1) Lookup Tables (2) _____ and (3) Cloud Connectors.
Update Rules
53
The Contact Washing Machine uses the following Eloqua tools: (1) Lookup Tables (2) Update Rules and (3) _____.
Cloud Connectors
54
When enabled and used in the Contact Washing Machine, where is a Cloud Connector executed from?
From a step within Program Builder.
55
_____ define the elementary values that Eloqua looks up during the Contact Washing Machine execution, and the values that are used to replace or update the existing values.
Lookup Tables
56
Define: Lookup Table:
A two column table of associated data values. In one column, a lookup can be performed; the second column holds a corresponding, associated value.
57
True or false: The Eloqua Lookup Table can upload a two-column data set to match against and update field values.
True.
58
How many columns must a Lookup Table have?
Two.
59
The two benefits of Lookup Tables are:
Keep your data consistent; validate data.
60
Give an example of using Lookup Tables to Find and Replace bad data.
Look up values like "Test" or "1234" and blank them out or replace them with a standard value.
61
Where do you create a lookup table?
Contacts: Data Tools: Data Tools drop-down menu: New Lookup Table
62
What are the two columns of the lookup table named?
Lookup Value and Replacement Value
63
To facilitate uploading a .csv file as a lookup table, use:
the Lookup Table Upload Wizard
64
What is an Update Rule?
A set of criteria used to update values in Contact, Account, or Custom Object fields. Each rule defines a field to update and an update action to take against the field value.
65
An Update Rule is used to update values in ____, ____, or ____ fields.
Contact, Account, or Custom Object fields
66
What is an Update Rule Set?
A collection of Update Rules to be run together in sequence.
67
In the Contact Washing Machine, what do Update Rules act on
The information provided in the Lookup Tables.
68
In Update Rules, what does "Append set value to field" do?
Adds a specified value, such as a text string, to the field value.
69
In Update Rules, what does "Apply Date Stamp" do?
Adds a date and time stamp to the selected field.
70
In Update Rules, what does "Overwrite value from other field" do?
Allows you to take a value from Field A and overwrite it on Field B.
71
In Update Rules, what does "Overwrite value from Lookup Table Field" do?
Allows you to overwrite values to a field from a table of lookup values.
72
In Update Rules, what does "Set to value" mean?
Allows you to write a hard-coded value into the field.
73
How many rules can be in each Update Rule Set?
Approximately 500.
74
What happens if you add more than 250 individual rules to an Update Rule Set?
The performance during rule execution degrades. You will receive warnings about the performance of the Rule Set after 250 rules.
75
Where do you create a new Update Rule Set?
Contacts: Data Tools: Data Tools drop-down menu: New Update Rule Set
76
When working with Update Rules, it is important to start by ______ your current data values.
analyzing and scoping
77
To analyze and scope your current data values, and determine how to logically group them, what report should you look at?
The Contact Field Values report.
78
In the "Normalizing Region Field" use case, what is done?
The Region value on the Contact record is updated based on the existing value in State or Province.
79
What do deduplication rules allow you to do?
Check data entities, such as Contacts and Accounts, to ensure there are no duplicate records in the database.
80
What kind of deduplication rule is used to deduplicate the same entity types?
A single-table deduplication rule.
81
What kind of deduplication rule is used to deduplicate one entity type against another (such as Contacts against Companies)?
A multi-table deduplication rule.
82
Name 4 data tools in Eloqua besides Lookup Tables and Update Rules.
Deduplication, Lead Stage Rules, Validation, and Match
83
What do Lead Stage Rules allow you to do?
Use Shared Lists, form processing steps, and Program Builder actions to designate a Contact or an Account as a lead, and identify its specific stage in the sales cycle.
84
What do Match Rules help you do?
Find data field values that match across different data entity records for Contacts and Accounts.
85
What do Validation Rules do?
Clean, check, or standardize data field values on existing data or incoming form data.
86
Program members may be...
Contacts, Custom Object Records, or Accounts.
87
Where can you review all Cloud Connector applications available for cleaning data?
Topliners - AppCloud, click Data Sources and Quality.
88
Name Eloqua's two Cloud Applications that are used for data cleansing.
Contact Data Normalizer and String Manipulation.
89
What does the Contact Data Normalizer do?
Allows mass normalization of common fields
90
What is an example of the Contact Data Normalizer working?
If a Contact's job title is VP Marketing, the application would populate the Job Level as Executive.
91
The Contact Data Normalizer includes...
maintained master Lookup Tables.
92
Using the Contact Data Normalizer, how can you normalize the Job Level based on a Contact's Job Title?
Select the "Title to Level" normalizer reference set.
93
What do you have to do first when cleaning data with Contact Data Normalizer?
Select the type of data you want to normalize.
94
What does String Manipulation do?
Perform simple or advanced Find and Replaces, trim extra spaces, and fix capitalization.
95
What do you need to do to completely automate the Contact Washing Machine?
Add a Program Feeder to automatically pull Contacts into the program on a regular basis.
96
What are the three ways to bring Contacts into a Program?
1. One-time addition 2. Forms 3. Feeders
97
Describe a one-time addition of Contacts into a Program.
Addition of individual Contacts or from a shared list or filter. The Program evaluates it once on demand.
98
Describe how forms push Contacts into programs.
Through the processing step "Add to Program."
99
What do feeders reference as the source of Contacts?
A shared list or filter.
100
5 steps to automating the Contact Washing Machine: (1) _____ (2) Add Update Rule with Lookup Table (3) Add the First Cloud App (4) Add the Second Cloud App (5) Remove Contacts from Program
Define a Program Feeder
101
5 steps to automating the Contact Washing Machine: (1) Define a Program Feeder (2) Add Update Rule with Lookup Table (3) _____ (4) Add the Second Cloud App (5) Remove Contacts from Program
Add the First Cloud App
102
5 steps to automating the Contact Washing Machine: (1) Define a Program Feeder (2) _____ (3) Add the First Cloud App (4) Add the Second Cloud App (5) Remove Contacts from Program
Add Update Rule with Lookup Table
103
5 steps to automating the Contact Washing Machine: (1) Define a Program Feeder (2) Add Update Rule with Lookup Table (3) Add the First Cloud App (4) _____ (5) Remove Contacts from Program
Add the Second Cloud App
104
5 steps to automating the Contact Washing Machine: (1) Define a Program Feeder (2) Add Update Rule with Lookup Table (3) Add the First Cloud App (4) Add the Second Cloud App (5) _____
Remove Contacts from Program
105
5 steps to automating the Contact Washing Machine:
(1) Define a Program Feeder (2) Add Update Rule with Lookup Table (3) Add the First Cloud App (4) Add the Second Cloud App (5) Remove Contacts from Program
106
What are the two Cloud Apps you add to the Contact Washing Machine?
Contact Data Normalizer and String Manipulation.
107
The first step in your Database Checklist is to create new Contact fields for storing _____
normalized data.
108
The first step in your Database Checklist is to
create new Contact fields for storing normalized data.
109
The second step in your Database Checklist is to ensure that you have full ______ access.
Cloud Connector
110
The third step in your Database Checklist is to make sure your personal user account has
API Users security access
111
The fourth step in your Database Checklist is to make sure you have _____
a cloudconnectors.eloqua.com account.
112
The fifth step in your Database Checklist is to create _______ based on your needs.
Lookup Tables
113
The sixth step in your Database Checklist is to create a _______ filter to find _____
create a Contact filter to find dirty contacts.
114
Database checklist (6 steps - shorthand)
Fields - Cloud - API - Account - Lookup - Filter
115
Which data tool allows you to define a field to update and to define the action to take against the field value?
Update Rule.
116
Which Update Role action allows you to write a hard-coded value into the field?
Set to value
117
Which cloud application allows you to normalize the data in a given field against a number of master Lookup Tables?
Contact Data Normalizer
118
Eloqua's Contact Washing Machine helps to improve ______ for better personalized marketing.
Contact profiles.
119
Eloqua's Contact Washing Machine helps to improve ______ by completing key fields for measuring lead quality.
lead scoring.
120
Eloqua's Contact Washing Machine helps to improve ______ by better assigning Contacts to nurture programs and campaigns based on accurate profiling.
Contact lead nurturing.
121
Eloqua's Contact Washing Machine helps to improve ____ by making marketing campaigns more effective.
ROI