Data Dictionary (for reporting users)

A data dictionary page is available under the "Data Sources" menu item. The data dictionary shows information about the fields available in your CDP. This page also serves to explain which fields are well populated and can be used for segmentation and which fields should have more data collected before using for segmentation.

Data Dictionary Fields

The Data Dictionary view has many fields to explain your database. Listed below are definitions for each field.

Category Name

This is the category that the field shows in, which appears as a folder in the Audience Selector fields library and in the Campaign output fields.

In the screenshot above, Customer Aggregates & Contactability are the categories

AS360 Alias Name

This is the "friendly" name of the field.

In the screenshot above, SPAM Law Authority, Has Email, Email Permission Status and Email Domain Extension are the alias names.

Sort Order

This is the order the field appears in (within its category) inside Audience Selector's Fields Library and the BI tool.

Population Rate

This shows how well populated the field is. If you see a low population rate, using that field for segmenting is not advised. Population rate can also tell you what kind of data is missing from your CDP. If you find that you are missing certain types of data, like demographics, reach out to your CSM to learn about a demographic data append may suit your needs.

Distinct Count

This shows how many distinct values are available in the field. This field is also a link to the drill-down distinct count report.

Field Description

This tells you more about the selected field: the kind of values it contains, what the "meaning" of the field is, or how the data is aggregated.

Show ___ fields

These fields (Show in Audience Selector, Show in Mail Output, Show in Email Output, Show in BI View) display where the field is available for use. If you'd like to use a field in Audience Selector but it is set to "No" for that field, reach out to your CSM to update the field's display.

Distinct Count Drill Down Report

Click on the Distinct Count value to open the field drill down report.

The field drill down report shows the number of transactions or individuals (depending on the level of the field) who are assigned each value. This can help determine which selections will get you the largest segment in Audience Selector.

Click the "Data" button to show the data as a table rather than a bar chart.

Schedule Refresh

Your data dictionary is refreshed every Sunday to recalculate the populate rates, distinct counts and add any new fields. However, you can schedule a refresh at any time by clicking the "Schedule Refresh" button in the upper right corner. 

After clicking the "Schedule Refresh" button, a dialog will open to allow you to schedule a refresh of your data dictionary.

If your data dictionary has been refreshed in the last 24 hours, you will not be allowed to refresh it again. The dialog box will tell you when you will be allowed to schedule your next refresh