---
schema_version: "1"
id: 5b38da8fd927e67df1896e7a1cfe103e32b1d01b54b1b0e1cb6dd5d4fe33cb66
title: Extract Mode Use Case
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_extract_mode_use_case.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_extract_mode_use_case.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bc404aa08d2b0486b28628d39cce541695baf5749bdd5ff10109b46f00752926
description: Learn more about extract modes in Data 360 with a specific scenario.
products:
  - Data 360
release: "264"
---
# Extract Mode Use Case

Learn more about extract modes in Data 360 with a specific scenario.

The following example uses a data extension with the following column headers: Claim Number (Data Type: Number); Claim Status (Data Type: Text); Claim Created Date (Data Type: DateTime); Claim Updated Date (Data Type: DateTime).

## Raw Data in Marketing Cloud Engagement

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:17.793594306049823%">
          <col style="width:29.181494661921707%">
          <col style="width:28.647686832740217%">
          <col style="width:24.377224199288257%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="4" style="vertical-align:top;" id="d157257e51">Day 1 Snapshot in Marketing Cloud Engagement</th>
          </tr>
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d157257e57">Claim Number</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d157257e60">Claim Status</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d157257e63">Claim Created Data</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d157257e66">Claim Updated Date</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Claim Number" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e57 ">1</td>

            <td data-label="Claim Status" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e60 ">New</td>

            <td data-label="Claim Created Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e63 ">12/1/2019</td>

            <td data-label="Claim Updated Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e66 ">12/1/2019</td>

          </tr>
          <tr class="">
            <td data-label="Claim Number" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e57 ">2</td>

            <td data-label="Claim Status" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e60 ">New</td>

            <td data-label="Claim Created Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e63 ">12/1/2019</td>

            <td data-label="Claim Updated Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e66 ">12/1/2019</td>

          </tr>
          <tr class="">
            <td data-label="Claim Number" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e57 ">3</td>

            <td data-label="Claim Status" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e60 ">New</td>

            <td data-label="Claim Created Data" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e63 ">12/1/2019</td>

            <td data-label="Claim Updated Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e51 d157257e66 ">12/1/2019</td>

          </tr>
        </tbody>
      </table> <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:17.761989342806395%">
          <col style="width:30.19538188277087%">
          <col style="width:26.287744227353464%">
          <col style="width:25.754884547069274%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="4" style="vertical-align:top;" id="d157257e138">Day 2 Snapshot in Marketing Cloud Engagement</th>
          </tr>
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d157257e144">Claim Number</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d157257e147">Claim Status</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d157257e150">Claim Created Date</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d157257e153">Claim Updated Date</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Claim Number" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e144 ">1</td>

            <td data-label="Claim Status" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e147 ">New</td>

            <td data-label="Claim Created Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e150 ">12/1/2019</td>

            <td data-label="Claim Updated Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e153 ">12/1/2019</td>

          </tr>
          <tr class="">
            <td data-label="Claim Number" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e144 ">2</td>

            <td data-label="Claim Status" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e147 ">In Review</td>

            <td data-label="Claim Created Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e150 ">12/1/2019</td>

            <td data-label="Claim Updated Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e153 ">12/2/2019</td>

          </tr>
          <tr class="">
            <td data-label="Claim Number" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e144 ">3</td>

            <td data-label="Claim Status" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e147 ">New</td>

            <td data-label="Claim Created Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e150 ">12/1/2019</td>

            <td data-label="Claim Updated Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e153 ">12/1/2019</td>

          </tr>
          <tr class="">
            <td data-label="Claim Number" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e144 ">4</td>

            <td data-label="Claim Status" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e147 ">New</td>

            <td data-label="Claim Created Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e150 ">12/2/2019</td>

            <td data-label="Claim Updated Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e153 ">12/2/2019</td>

          </tr>
          <tr class="">
            <td data-label="Claim Number" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e144 ">5</td>

            <td data-label="Claim Status" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e147 ">New</td>

            <td data-label="Claim Created Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e150 ">12/2/2019</td>

            <td data-label="Claim Updated Date" class="slds-cell-wrap" style="vertical-align:top;" headers="d157257e138 d157257e153 ">12/2/2019</td>

          </tr>
        </tbody>
      </table>

## Goal

Make sure that Data 360 has the most recent data.

## Option 1: Set Extract Method to Full Refresh

1. On day 1, data for all time is sent, in this case three rows of data. Rows corresponding to Claims #1, 2, 3 are sent.
2. On day 2, data for all time is sent again, in this case now five rows of data. Rows corresponding to Claims #1, 2, 3, 4, 5 including updated Status for Claim #2 are sent.

**Outcome**: Goal achieved. Data 360 has all up-to-date data.

## Option 2: Set Extract Method to Numeric Change Date Capture (CDC) based on the Claim Number column

1. On day 1, all initial data is sent in this case three rows of data. Rows corresponding to Claims #1, 2, 3 are sent.
2. On day 2, the claims that accumulated between the penultimate claim number maximum of 3 and the newest claim number maximum of 5 are sent. Rows corresponding to Claims #4 and 5 are sent.

**Outcome**: Goal not achieved. Data 360 has data for all 5 claims, but it doesn't have the most recent status for Claim #2.

## Option 3: Set Extract Method to Date Time CDC based on Claim Updated Date column

1. On day 1, all initial data is sent, in this case three rows of data. Rows corresponding to Claims #1, 2, 3 are sent.
2. On day 2, the claims that accumulated between the penultimate claim updated date maximum of 12/1/2019 and the newest claim updated date maximum of 12/2/2019 are sent. Rows corresponding to Claims #2, 4, and 5 are sent.

**Outcome**: Goal achieved. Data 360 has data for all 5 claims and it has the most recent status for Claim #2.

## Option 4: Set Extract Method to Date Time CDC based on Claim Created Date column

1. On day 1, all initial data is sent, in this case three rows of data. Rows corresponding to Claims #1, 2, 3 are sent. On day 2, the claims that accumulated between the penultimate claim created date maximum of 12/1/2019 and the newest claim created date maximum of 12/2/2019 are sent. Rows corresponding to Claims #4 and 5 are sent.

**Outcome**: Goal not achieved. Data 360 has data for all 5 claims, but it doesn't have the most recent status for Claim #2.

## Conclusion

The Full Refresh option and the Date Time CDC with Claim Updated Date high-water mark result in the most up-to-date data for Data 360. But the Full Refresh option means that Data 360 processed 8 total rows of data: 3 rows on day 1 and 5 rows on day 2. The Date Time CDC option means that Data 360 processed 6 total rows of data: 3 rows on day 1 and 3 rows on day 2. Date Time CDC extract based on updated date column is the most efficient option when scaling your use case.

## Caveats

If the data extension is extracted from Engagement for an existing automation, the UI reflects the previously configured Extract Mode and high-water mark field.