Everything you need to know about building a Data Dictionary

A Data Dictionary is a master file that is used as a reference for all fields that live in Eloqua. This contains fields from all tables (contacts, accounts, campaigns, custom data objects) and displays their properties, settings and even where it’s used at a glance.  Ideally your Data Dictionary will encompass more than what data is in Eloqua, but also where that data integrates with other systems (for example your CRM).

A Data Dictionary can standardize data in your Eloqua instance and help eliminate errors in integrations when changes to fields are made. It can be used as a resource for onboarding new team members and allows you to quickly answer any questions that may arise in day-to-day activities. A Data Dictionary is a one-stop shop for all things related to fields in Eloqua.

How to build a Data Dictionary

  1. Evaluate current instance data and values
  2. Agree upon standardized values and data types with marketing and sales for system alignment
  3. Cleanse the data in your Eloqua instance through one-time uploads for non-picklist fields and a contact washing machine to maintain clean data for fields that utilize a picklist
  4. Document the clean version of all fields by using the data dictionary template

This is designed to be a living and breathing document. This document should be updated as fields change (both current and as new fields are added). There is a tab in the template that allows for tracking of changes. It is important to track changes and who signed off on those changes for troubleshooting purposes and to ensure the document is maintained.

Topliners is always a great resource if you need help with planning and executing a Data Dictionary. It will walk you through all the stages of creating a Data Dictionary along with best practice tips and advice.

You May Also Like…

Digital Transformation

Turn Strategy Into Action

Lead Management

Accelerate Leads to Revenue

Managed Services

Long-Term Support

Customer Experience

Wow Your Customers

Marketing ROI

Prove Your Power

Experts On Demand

Stop Troubleshooting

Inbound Marketing

Right Channel, Right Message

Account-Based Marketing

Accelerate ABM Success

Custom Training

Tailored Learning Solution

REVENUE
MARKETING
UNIVERSITY

Get the skills you need to drive more revenue with On Demand and live, virtual classrooms

Marketo Engage

Marketo Platinum Partner

Pardot

Accelerate Leads to Revenue

Microsoft Dynamics

Optimize Your Instance

Salesforce Marketing Cloud

Salesforce Certified Silver Partner

Salesforce CRM

12 Years of Integration Experience

Partners

Additional Technology Platforms

Oracle Eloqua

Oracle Platinum Partner

Adobe Marketing Cloud

Adobe Bronze Partner

Stop
Trouble-shooting

 

The help you need, when you need it with Experts On Demand

About TPG

Learn about TPG and meet the team.

Careers

Discover career openings with TPG.

Newsroom

Our latest thought leadership.

History

Explore our award-winning history.

Partners

Learn more about TPG’s Partners.

Ready to transform into a digital revenue machine?

 

Learn how TPG empowers digital revenue delivery through a blend of strategy, technology and execution.