---
schema_version: "1"
id: fc84632f4ddcd5f73197365da73e6ab0a418c18503c7ad347388f8d8ab414fb4
title: Add Segmentation Rule Definition Columns
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/cg_task_admin_create_segmentation_rule_definition_column.md
canonical_url: https://help.salesforce.com/s/articleView?id=ind.cg_task_admin_create_segmentation_rule_definition_column.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 78d2998b9424c2ab72dbff7f40fa84b58bfa9a72742120db05661d3d43f10e16
description: Segmentation rule definition columns are definitions of placeholders that are added to a SOQL query in a segmentation rule definition. You can add one or more segmentation rule definition columns to a segmentation rule definition.
products:
  - Consumer Goods
release: "264"
---
# Add Segmentation Rule Definition Columns

Segmentation rule definition columns are definitions of placeholders that are added to a SOQL query in a segmentation rule definition. You can add one or more segmentation rule definition columns to a segmentation rule definition.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience in <strong>Professional</strong>, <strong>Enterprise</strong>, and <strong>Unlimited</strong> Editions that have Consumer Goods Cloud enabled</td></tr></tbody></table>

<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="d25857e63">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e63 ">To create segmentation rule definition columns:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e63 ">
              <p>CGCloud Business Admin</p>
              <p style="margin-bottom:0;">OR</p>
              <p style="margin-bottom:0;">CGCloud Retail Business Admin</p>
            </td>

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

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_retail_admin-264-0-0-production-enus/5bb7d7f5-119d-42d0-8596-95e762837019/images/icon_note.png)

Note You can add a segmentation rule definition column only to a segmentation rule that’s in the Initial state.

1. From the App Launcher, find and select **Segmentation Rules**, and then select a segmentation rule record.
2. From the Segmentation Rule Definition Columns related list, click **New Segmentation Rule Definition Column**.
3. Provide these details:
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:50%">
              <col style="width:50%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d25857e128">Field</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d25857e131">Description</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td class="slds-cell-wrap" colspan="2" style="vertical-align:top;" headers="d25857e128 d25857e131 ">Identification</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e128 ">Segmentation Rule Definition</td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e131 ">Name of the segmentation rule definition.</td>

              </tr>
              <tr class="">
                <td class="slds-cell-wrap" colspan="2" style="vertical-align:top;" headers="d25857e128 d25857e131 ">Field Settings</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e128 ">Field Title</td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e131 ">Title of a field.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e128 ">Field Type</td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e131 ">
                  <p>Type of a field. The options are:</p>
                  <ul>
                    <li>Text</li>
                    <li>Picklist</li>
                    <li>Number</li>
                    <li>Date</li>
                    <li>List</li>
                  </ul>
                </td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e128 ">Field Alias</td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e131 ">Values for the aliases defined in the segmentation query (SOQL binding). For
                  example, $AccCity$.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e128 ">Field Default</td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e131 ">Default value shown for a field.</td>

              </tr>
              <tr class="">
                <td class="slds-cell-wrap" colspan="2" style="vertical-align:top;" headers="d25857e128 d25857e131 ">Other Settings</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e128 ">Field List Template</td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e131 ">
                  <p>Template used for a field list. If the field type is List, then this field defines
                    the content of the list. The options are:</p>
                  <ul>
                    <li>Text</li>
                    <li>Picklist</li>
                    <li>Number</li>
                    <li>Boolean</li>
                  </ul>
                </td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e128 ">Field Picklist Target</td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e131 ">
                  <p>Field picklist target value. If the field type is Picklist or List, then this field
                    defines the picklist to choose.</p>
                  <p style="margin-bottom:0;">The format is <code>&lt;Object&gt;.&lt;Attribute&gt;</code>. For any other field type, this field is
                    ignored.</p>
                </td>

              </tr>
              <tr class="">
                <td class="slds-cell-wrap" colspan="2" style="vertical-align:top;" headers="d25857e128 d25857e131 ">Field Validations</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e128 ">Field Number Digits</td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d25857e131 ">Defines the number of digits after the decimal point for the Number type
                  fields.</td>

              </tr>
            </tbody>
          </table>
4. Save your changes.

- **[Segmentation Rule Definition Examples](https://help.salesforce.com/s/articleView?id=ind.cg_ref_admin_segmentation_example.htm&release=264.0.0&type=5)**  
    Review these examples of segmentation rule definitions.