# Data strategy, subscriber keys and segmentation design

*Marketing Cloud Engagement Consultant Study Guide · Discovery and Architecture · Last updated November 3, 2026 · https://www.certifyforce.com/study-guide/marketing-cloud-engagement-consultant/discovery-and-architecture/data-strategy-subscriber-keys-and-segmentation-design*

How a consultant turns data requirements into a strategy: database of record first, only the data campaigns use, keys and links that hold together, channel-aware opt-outs, attribute groups and populations, and data feeds that stay fresh.

- Certification: Salesforce Marketing Cloud Engagement Consultant
- Exam section: Discovery and Architecture
- Study guide: https://www.certifyforce.com/study-guide/marketing-cloud-engagement-consultant

**Official exam objective:**

> Demonstrate how to gather requirements in order to put together a data and segmentation strategy for the customer.

## What the exam expects

- Gather data sources and pick the database of record before designing anything else.
- Decide which fields to import from what campaigns will segment or personalize on, and keep unneeded sensitive data out.
- Identify foreign, primary and contact keys, and spot key strategies that will break (channel-bound values, digit collisions, shared household emails, internal IDs).
- Recommend attribute-group, population and link designs, and explain that an Email Studio unsubscribe doesn't reach other channels.
- Plan how data stays fresh: scheduled imports, and synchronized CRM data copied into sendable, shareable data extensions.
- Key terms: **DBOR** (database of record: source of truth for opt-in status and subscriber info); **contact key** (unique contact identifier, the subscriber key in Email Studio); **foreign key** (fields that connect two tables); **primary key** (unique row identifier); **attribute group** (linked data extensions); **population** (a large, distinct group of contacts).

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Database of record | Source of truth for opt-in status and general subscriber info | [Design Your Data Model](https://trailhead.salesforce.com/content/learn/modules/marketing-cloud-data-management/design-your-mc-data-model) |
| Sensitive data | Store only if essential for segmentation or transactional messages | [Design Your Data Model](https://trailhead.salesforce.com/content/learn/modules/marketing-cloud-data-management/design-your-mc-data-model) |
| Subscriber key length | Limited to 254 English characters | [Subscriber Key](https://help.salesforce.com/s/articleView?id=mktg.mc_es_subscriber_key.htm&type=5&language=en_US) |
| Spam complaints | Tied to the email address, not the key | [Subscriber Key](https://help.salesforce.com/s/articleView?id=mktg.mc_es_subscriber_key.htm&type=5&language=en_US) |
| Contact ID, Subscriber ID | Internal surrogate keys; not for marketing activities | [Contact Builder Best Practices](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_contact_builder_best_practices.htm&type=5&language=en_US) |
| Email Studio unsubscribe | Doesn't stop MobileConnect or MobilePush messages | [Contact Builder Best Practices](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_contact_builder_best_practices.htm&type=5&language=en_US) |
| Populations | Three or fewer | [Contact Builder Best Practices](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_contact_builder_best_practices.htm&type=5&language=en_US) |
| Numeric identifiers | Convert to string before linking to Contact Key | [Contact Builder Best Practices](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_contact_builder_best_practices.htm&type=5&language=en_US) |
| Outside data in | Data Copy or Import activity, schedulable in an automation | [Organize Your Data](https://trailhead.salesforce.com/content/learn/modules/audience-segmentation/organize-your-data) |
| Synchronized data extensions | Not sendable; query into a sendable or shared data extension | [SDS Best Practices](https://help.salesforce.com/s/articleView?id=mktg.mc_co_implement_synchronized_data_sources_best_practices.htm&type=5&language=en_US) |

## Check yourself

- Which field types does the data model module use to label incoming data?
- When does the module say populations are beneficial?
- Why might a long composite subscriber key fail?
- How can a Data Copy or Import activity map source columns to the destination?

## Sources

- [Design Your Data Model (Trailhead)](https://trailhead.salesforce.com/content/learn/modules/marketing-cloud-data-management/design-your-mc-data-model)
- [Contact Builder Best Practices](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_contact_builder_best_practices.htm&type=5&language=en_US)
- [Subscriber Key in Marketing Cloud Engagement](https://help.salesforce.com/s/articleView?id=mktg.mc_es_subscriber_key.htm&type=5&language=en_US)
- [Organize Your Data (Trailhead)](https://trailhead.salesforce.com/content/learn/modules/audience-segmentation/organize-your-data)
- [Synchronized Data Sources Best Practices](https://help.salesforce.com/s/articleView?id=mktg.mc_co_implement_synchronized_data_sources_best_practices.htm&type=5&language=en_US)
- [Audit Your Account (Trailhead)](https://trailhead.salesforce.com/content/learn/modules/marketing-cloud-account-optimization/audit-your-account)
- [Best Practices for Exporting and Retrieving Data](https://help.salesforce.com/s/articleView?id=000355942&language=en_US&type=1)

## About the full unit

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