---
schema_version: "1"
id: 8a1aa19103a3496fb8af112d08b49b7ee8620207070d7f370f35ac8172e48212
title: Create a Load Rule
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_adv_streams_rules_create.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_adv_streams_rules_create.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: fc7f70b5596ff566f22fdc66d1807743563d87728bcf6c2bf89495836da232d9
description: Data load rules filter out unwanted data before you upload data to Marketing Cloud Intelligence. After you create load rules, they can be applied to data streams.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Create a Load Rule

Data load rules filter out unwanted data before you upload data to Marketing Cloud Intelligence. After you create load rules, they can be applied to data streams.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d71064e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d71064e38 ">To define a load mode:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d71064e38 ">Admin</td>

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

1. Navigate to the **Connect & Mix** tab.
2. Expand **Data Streams**, and then expand **Data Streams List**.
3. Expand **Data Load Rules**.
4. Click **Add New**.
5. In the **General** section, add this information:
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><tbody><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Name</strong></td><td class="slds-cell-wrap">Name your load rule.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Match Action</strong></td><td class="slds-cell-wrap">Select the matching action to use. These match types are available: <span><strong class="uicontrol">Include Rows</strong> – Only data that matches the dimension values defined in the filter is uploaded. </span><span><strong class="uicontrol">Delete Measurements</strong> – Measurements are removed from the data according to the filter. </span><span><strong class="uicontrol">Fail the Entire Load</strong> – Any new raw file that meets the criteria doesn’t upload.</span></td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Description</strong></td><td class="slds-cell-wrap">Enter a description to describe what the load rule does.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Date Range</strong></td><td class="slds-cell-wrap">Enter a data range so that only data that meets the date range is added to the data stream.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Filter Rows Without Measurement Data</strong></td><td class="slds-cell-wrap">Exclude rows without measurement data. If a row contains “0” or “null”, it isn’t uploaded.</td></tr></tbody></table>
6. In the filters area, define the criteria. (If filters exist, they appear here and can be modified.)
7. To create a new filter, click **Add Filter**.
    
    Define the filter’s details. For example, to exclude a specific campaign, set **Campaign Name** as the dimension, choose **Not Equals**, and enter the campaign name.
    
    ![data stream advanced - filter details](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/data/data_adv_filters.png)
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/images/icon_note.png)
    
    Note Filters are not case-sensitive .
8. Save your work.