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
- Evaluate current instance data and values
- Agree upon standardized values and data types with marketing and sales for system alignment
- 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
- 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.
Stephanie Pence is a Revenue Engineer for The Pedowitz Group. She has an Eloqua Master Certification along with 8 years experience in Sales, Marketing and PR.
- Posted by Stephanie Pence
- On 07/08/2016
- 0 Comments