# Reading data extensions, filters and segments

*Marketing Cloud Engagement Foundations Study Guide · Data Management · Last updated November 3, 2026 · https://www.certifyforce.com/study-guide/marketing-cloud-engagement-foundations/data-management/reading-data-extensions-filters-and-segments*

How to read data to find the right audience: when a data extension beats a list, what the primary key says about rows versus people, what the Properties tab shows, how data filter groupings and operators evaluate, and when to use filtered or random data extensions.

- Certification: Salesforce Marketing Cloud Engagement Foundations
- Exam section: Data Management
- Study guide: https://www.certifyforce.com/study-guide/marketing-cloud-engagement-foundations

**Official exam objective:**

> Given a scenario, recommend the best way to interpret a data extension to identify the desired target data

## What the exam expects

- Recommend a data extension instead of a list when the data is relational or the audience is large.
- Work out whether a data extension's rows are unique people or something else, from its primary key.
- Read the Properties tab (record count, external key, retention) and explain why expected rows are missing.
- Predict which records a data filter keeps from its conditions, operators and AND/OR groupings.
- Choose a filtered or a random data extension for a segment.
- Key terms: **list** (a collection of subscribers whose attributes describe each subscriber); **primary key** (the field whose values are unique per row); **data filter** (conditions evaluated against each subscriber or row to build a segment); **grouping** (conditions joined by AND or OR); **filtered and random data extensions** (a criteria-based subset, or a random selection, of a source data extension).

## Key facts

| Fact | Detail | Source |
|---|---|---|
| List attributes | Can't exist without a subscriber | [Organize Your Data](https://trailhead.salesforce.com/content/learn/modules/audience-segmentation/organize-your-data) |
| Relational data | Data extensions, not lists | [List vs. Data Extension](https://help.salesforce.com/s/articleView?id=mktg.mc_es_list_versus_data_extension.htm&type=5&language=en_US) |
| Primary key values | Unique for each row | [Create a Data Extension](https://help.salesforce.com/s/articleView?id=mktg.mc_es_create_data_extension.htm&type=5&language=en_US) |
| Data Records | Number of rows in the table | [Data Extensions in Contact Builder](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_data_extensions.htm&type=5&language=en_US) |
| Retention Period | Time after which unmodified data is deleted | [Data Extensions in Contact Builder](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_data_extensions.htm&type=5&language=en_US) |
| Data extension filter | Uses that data extension's field columns | [Data Filter Definition](https://help.salesforce.com/s/articleView?id=mktg.mc_es_data_filter_definition.htm&type=5&language=en_US) |
| OR grouping | One or more conditions met | [Data Filter Definition](https://help.salesforce.com/s/articleView?id=mktg.mc_es_data_filter_definition.htm&type=5&language=en_US) |
| AND grouping | All conditions met | [Data Filter Definition](https://help.salesforce.com/s/articleView?id=mktg.mc_es_data_filter_definition.htm&type=5&language=en_US) |
| Random data extension | Random selection from a source data extension | [Learn About Data Extensions](https://trailhead.salesforce.com/content/learn/modules/marketing-cloud-contact-management/learn-about-data-extensions) |

## Check yourself

- When would you open the Records tab instead of the Properties tab?
- When does an attribute's Required flag matter while reading the Properties tab?
- Why might a marketer look up one person in a list but not in a data extension?
- Which Properties tab date shows when a user last saved a change to the data extension?

## Sources

- [Data Extensions in Contact Builder](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_data_extensions.htm&type=5&language=en_US)
- [Email Studio List vs. Email Studio Data Extension](https://help.salesforce.com/s/articleView?id=mktg.mc_es_list_versus_data_extension.htm&type=5&language=en_US)
- [Data Filter Definition for Marketing Cloud Engagement](https://help.salesforce.com/s/articleView?id=mktg.mc_es_data_filter_definition.htm&type=5&language=en_US)
- [Organize Your Data (Trailhead)](https://trailhead.salesforce.com/content/learn/modules/audience-segmentation/organize-your-data)
- [Learn About Data Extensions (Trailhead)](https://trailhead.salesforce.com/content/learn/modules/marketing-cloud-contact-management/learn-about-data-extensions)
- [Create a Data Extension in Email Studio](https://help.salesforce.com/s/articleView?id=mktg.mc_es_create_data_extension.htm&type=5&language=en_US)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 8 linked practice questions, and unlimited timed mock exams are included with the Marketing Cloud Engagement Foundations pack (USD $19): https://www.certifyforce.com/practice-exams