---
schema_version: "1"
id: 0a640eecfc93d52ee8ac00983bd4064fd9a8cca8fb2d85b045c0261cdc361490
title: Key Performance Indicators
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/analytics_loyalty_kpis.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.analytics_loyalty_kpis.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b1383ddc206772b962dec873b74861f9c4c715d359b09749aebab762399a0898
description: Learn the definitions and calculations of key metrics shown in Analytics for Loyalty dashboards.
products:
  - Loyalty Management
release: "264"
---
# Key Performance Indicators

Learn the definitions and calculations of key metrics shown in Analytics for Loyalty dashboards.

### 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: <strong>Developer</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions that have Loyalty Management enabled</td></tr></tbody></table>

This table lists the key metrics and their calculations.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:23.640661938534276%">
          <col style="width:32.38770685579196%">
          <col style="width:43.97163120567376%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d9173e71">Metric</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d9173e74">Description</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d9173e77">Calculation</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Accrual Reversals</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total number of accrual reversal transactions in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of unique values in the Transaction Journal ID field in the Loyalty
                Ledger object.</p>
              <p>Filters applied:</p><a name="analytics_loyalty_kpis__ul_fh2_fgx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_fh2_fgx_gtb">
                <li>Event Type is Debit</li>
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Accrual Reversal</li>
                <li>Member Type is either Individual or Corporate</li>
                <li>Journal ID field values are the same in Loyalty Ledger object and the
                  Transaction Journal object</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Accrual Promo Spend</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total liability for a selected promotion program.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>(Number of Points Accrued x Cost Per Accrued Point) + (Number of Vouchers x
                Cost Per Voucher)</p>
              <p style="margin-bottom:0;">Filter applied: Journal Type is Accrual.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Acquisition by Channel</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Members enrolled through the same channel.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of members with the same Enrollment Channel field value in the Loyalty
                Program Member object.</p>
              <p style="margin-bottom:0;">Filter applied: Enrollment Date is during the period
                selected in the Duration filter.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Acquisition by Referral</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">
              <p>Members who joined through referrals.</p>
              <p style="margin-bottom:0;">Yes, if the member joined through a
                referral. Otherwise, no.</p>
            </td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 "><a name="analytics_loyalty_kpis__ul_gh2_fgx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_gh2_fgx_gtb">
                <li>If the member joined through a referral: Number of members with a value in the
                  Referred By Id in the Loyalty Program Member object.</li>

                <li>If the member didn’t join through a referral: Number of members with no value
                  in the Referred By Id field in the Loyalty Program Member object.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Accrued Points Reversed</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total accrued points reversed in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of all Points field values in the Loyalty Ledger object. </p>
              <p>Filters
                applied:</p><a name="analytics_loyalty_kpis__ul_b1s_qbx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_b1s_qbx_gtb">
                <li>Event Type is Debit</li>
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Accrual Reversal</li>
                <li>Journal ID field values are the same in the Loyalty Ledger object and the
                  Transaction Journal object</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Agent</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Name of the agent who modified the loyalty points.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">Value of the Created By field in the Loyalty Ledger object.</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Avg Transaction Amount by Membership Duration</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">The average transaction amount based on membership duration.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>(Sum of Transaction Amount field values in the Transaction Journal object) /
                (Number of members in the membership duration group)</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_c4n_vbx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_c4n_vbx_gtb">
                <li>The Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Accrual</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Change in NQP</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Change in non-qualifying points redeemed.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">((NQP Redeemed in the period selected in the Duration filter) - (NQP Redeemed
              in the period selected in the Compare To filter) / (NQP Redeemed in the period
              selected in the Compare To filter)) x 100 </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Change in NQP Redeemed for Products</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Percentage change in non-qualifying points redemption when compared to a
              previous period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">((NQP Redeemed during the period selected in the Duration filter - NQP Redeemed
              during the period selected in the Compare To filter) / (NQP Redeemed during the
              period selected in the Compare To duration)) x 100</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Credited Points</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total points credited.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of Points field values in the Loyalty Ledger object. </p>
              <p>Filters applied:
              </p><a name="analytics_loyalty_kpis__ul_e3z_xbx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_e3z_xbx_gtb">
                <li>Currency Type is either Non Qualifying or Qualifying</li>
                <li>Event Type is Credit</li>
                <li>Journal Id matches with Journal Id in Transaction Journal</li>
                <li>Activity Date in Transaction Journal is within the period selected in the
                  Duration filter</li>
                <li>Journal Type is Manual Points Adjustment</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">CSAT</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Customer Satisfaction score for a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">((Response Value) / (Max Question Choice Value)) x (Default Scale) /(Total
              Responses)</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Debited Points</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total points debited.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of Points field values in the Loyalty Ledger object. </p>
              <p>Filters applied:
              </p><a name="analytics_loyalty_kpis__ul_jc5_bcx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_jc5_bcx_gtb">
                <li>Currency Type is either Non Qualifying or Qualifying</li>
                <li>Event Type is Debit</li>
                <li>Journal Id matches with Journal Id in Transaction Journal</li>
                <li>Activity Date in Transaction Journal is within the period selected in the
                  Duration filter</li>
                <li>Journal Type is Manual Points Adjustment.</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Inactive Member Composition</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">
              <p>Composition of the inactive member base:</p><a name="analytics_loyalty_kpis__ul_hh2_fgx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_hh2_fgx_gtb">
                <li>Members with at least one transaction in the period selected in the Duration
                  filter and no transactions in the period selected in the Inactive Duration
                  filter.</li>
                <li>Members with no transactions in the period selected in the Duration filter and
                  the Inactive Duration filter, but have at least one transaction in the period
                  before the selected duration.</li>
                <li>Members with no transactions.</li>
              </ul>
            </td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 "><a name="analytics_loyalty_kpis__ul_ih2_fgx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_ih2_fgx_gtb">
                <li>Number of loyalty program members by the end of the period selected in the
                  Duration filter with at least one record in the Transaction Journal
                  object.<p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_ut1_hcx_gtb"><!-- --></a>
                  <ul id="analytics_loyalty_kpis__ul_ut1_hcx_gtb">
                    <li>Activity Date is within the period selected in the Duration filter</li>
                    <li>Journal Type is Accrual or Redemption</li>
                    <li>Member Type is either Individual or Corporate</li>
                    <li>No records exist in the period selected in the Inactivity Duration
                      filter</li>
                  </ul>
                </li>

                <li>Number of loyalty program members by the end of the period selected in the
                  Duration filter with at least one record in the Transaction Journal
                  object.<p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_d1m_kcx_gtb"><!-- --></a>
                  <ul id="analytics_loyalty_kpis__ul_d1m_kcx_gtb">
                    <li>Activity Date is before the period selected in the Duration filter</li>
                    <li>Journal Type is Accrual or Redemption</li>
                    <li>Member Type is either Individual or Corporate</li>
                    <li>No records exist in the period selected in the Inactivity Duration
                      filter</li>
                  </ul>
                </li>

                <li>Number of loyalty program members by the end of the period selected in the
                  Duration filter with no records in the Transaction Journal object.<p>Filters
                    applied: </p><a name="analytics_loyalty_kpis__ul_hwl_ncx_gtb"><!-- --></a>
                  <ul id="analytics_loyalty_kpis__ul_hwl_ncx_gtb">
                    <li>Journal Type is Accrual or Redemption</li>
                    <li>Member Type is either Individual or Corporate</li>
                  </ul>
                </li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Inactive Members</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">The number of members with no transactions in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of members with no records in the Transaction Journal object where the
                Activity Date is based on the period selected in the Inactivity Duration
                filter.</p>
              <p style="margin-bottom:0;">Filter applied: Journal Type is Accrual or Redemption.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Last Transaction</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total latest transaction amount.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of latest transactions by all loyalty program members in a month.</p>
              <p style="margin-bottom:0;">Filter
                applied: Member Type is either Individual or Corporate.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Liability</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total outstanding liability of a loyalty program.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">(Points Balance field value from the Loyalty Member Currency object x Cost per
              Unit field value from the Loyalty Program Currency object) + (Number of records in
              the Voucher object where the Status field value is Issued x Cost Per Voucher field
              value in the Voucher Definition object)</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Members by Membership Duration</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of members grouped by membership duration.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of members grouped by these membership duration groups:</p><a name="analytics_loyalty_kpis__ul_jh2_fgx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_jh2_fgx_gtb">
                <li>Less than 1 month</li>
                <li>1–3 months</li>
                <li>3–6 months</li>
                <li>6–9 months</li>
                <li>9–12 months</li>
                <li>1–2 years</li>
                <li>2–5 years</li>
                <li>5+ years</li>
              </ul>
              <p style="margin-bottom:0;">Member Duration = Today – Enrollment Date.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Members by Tier</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of members in a tier.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of all members with the same tier name.</p>
              <p style="margin-bottom:0;">Filter applied: Member Type is
                either Individual or Corporate.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Members by Type</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of Members who are of the same member type.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">Number of all members with the same Member Type.</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Member Services CSAT</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Customer Satisfaction for the assistance provided to the loyalty program
              members.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">(Response Value / Max Question Choice Value) x (Default Scale/Total
              Responses)</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Members with 0 Transactions</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Numbers of members with no transactions till date.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of Loyalty Program Member Id field values in the Loyalty Program Member
                object. </p>
              <p>Filters applied:</p><a name="analytics_loyalty_kpis__ul_glj_pcx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_glj_pcx_gtb">
                <li>No records exist in the Transaction Journal object</li>
                <li>Enrollment Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Accrual in the Transaction Journal object</li>
                <li>Member Type is either Individual or Corporate</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Members With One Transaction</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of members with only one transaction till date.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of Loyalty Program Member Id field values in the Loyalty Program Member
                object. </p>
              <p>Filters applied:</p><a name="analytics_loyalty_kpis__ul_icw_tcx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_icw_tcx_gtb">
                <li>Only one record in the Transaction Journal object</li>
                <li>Enrollment Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Accrual</li>
                <li>Status is Processed</li>
                <li>Usage Type is Loyalty</li>
                <li>Member Type is either Individual or Corporate</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Members with Modifications</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Members for whom manual changes were made.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 "><a name="analytics_loyalty_kpis__ul_kh2_fgx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_kh2_fgx_gtb">
                <li>When history tracking isn’t enabled: Number of unique Member Id field values
                  from the Transaction Journal object. <p>Filters applied:</p><a name="analytics_loyalty_kpis__ul_ew5_ycx_gtb"><!-- --></a>
                  <ul id="analytics_loyalty_kpis__ul_ew5_ycx_gtb">
                    <li>Activity Date is in the period selected in the Duration filter</li>
                    <li>Journal Type is Accrual Reversal, Redemption Reversal, or Manual Points
                      Adjustment.</li>
                  </ul>
                </li>

                <li>When history tracking is enabled and data exists in the Loyalty Member Tier
                  History object: Unique members from the Loyalty Ledger object (where Journal
                  Type is Accrual Reversal, Redemption Reversal, or Manual Points Adjustments) and
                  the Loyalty Member Tier History object (where Created Date is within the period
                  selected in the Duration filter, and both old and new values exist in the
                  Loyalty Tier field).<p>Filters applied: Journal Type is Redemption Reversal or
                    Member Type is either Individual or Corporate.</p>
                </li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Members With Transactions</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">The percentage of the member base with transactions in the selected
              period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>((Count of unique Member Id field values in the Transaction Journal object
                where Activity Date is in the period selected in the Duration filter and Journal
                Type is Accrual or Redemption) / (Count of loyalty program members by the end of the
                period selected in the Duration filter)) x 100</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_phk_fdx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_phk_fdx_gtb">
                <li>Journal Type is Accrual</li>
                <li>Member Type is either Individual or Corporate.</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Member Value</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">The value of the member based on points balance, NQP Accrued, NQP Redeemed, and
              Transaction Amount.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Member Value / Program Value</p>
              <p>Filters applied:</p><a name="analytics_loyalty_kpis__ul_s52_3dx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_s52_3dx_gtb">
                <li>Journal Type is Accrual</li>
                <li>Member Type is either Individual or Corporate.</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Members Whose Points Expired</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of members with expired points.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of unique members with Loyalty Program Member Id matching the Member Id
                in the Loyalty Ledger object.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_qx1_jdx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_qx1_jdx_gtb">
                <li>In the Loyalty Ledger object, Event Type is Expiry and Created Date is within
                  the period selected in the Duration filter</li>
                <li>Currency Type is Non-Qualifying in the Loyalty Program Currency object.</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Modifications</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of manual changes made.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of rows in the Transaction Journal object.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_ux1_4dx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_ux1_4dx_gtb">
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Accrual Reversal, Redemption Reversal, or Manual Points
                  Adjustment</li>
                <li>Journal Type is Redemption Reversal </li>
                <li>Member Type is either Individual or Corporate</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Modifications by Type</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Manual adjustments by Type.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of unique Transaction Journal Id field values in the Loyalty Ledger
                object.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_kxm_tdx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_kxm_tdx_gtb">
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>In the Transaction Journal object, Journal Type is Accrual Reversal,
                  Redemption Reversal, or Manual Points Adjustment where Event Type is either
                  Credit or Debit</li>
                <li>Member Type is either Individual or Corporate</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Number of Transactions</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of transactions in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of rows in the Transaction Journal object.</p>
              <p style="margin-bottom:0;">Filters applied: Journal
                Type is Accrual or Redemption, Activity Date is in the period selected in the
                Duration filter, and Member Type is either Individual or Corporate.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">NPS</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Net Promoter Score of a program for a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">(Total Promoters) - (Total Detractors) / (Total Responses)</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">NQP Accrued</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total non-qualifying points accrued in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>(Sum of points from Loyalty Ledger object where Transaction Journal type is
                Accrual, Ledger Event Type is Credit, and Currency Type is Non Qualifying) + (Sum of
                points from Loyalty Ledger object where Transaction Journal type is Manual Points
                Adjustment, Ledger Event Type is Credit, and Currency Type is Non Qualifying) - (Sum
                of points from Loyalty Ledger object where Transaction Journal type is Manual Points
                Adjustment, Ledger Event Type is Debit, and Currency Type is Non
                Qualifying)</p>
              <p style="margin-bottom:0;">Filters applied: Member Type is either Individual or
                Corporate.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">NQP Accrual Reversal Points</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total non-qualifying points debited because of accrual reversals.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of Points field values in the Loyalty Ledger object for a non-qualifying
                currency.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_rwq_f2x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_rwq_f2x_gtb">
                <li>Event Type is Debit</li>
                <li>Journal Id in the Loyalty Ledger object matches the Journal Id in the
                  Transaction Journal object</li>
                <li>Activity Date in Transaction Journal is within the period selected in the
                  Duration filter</li>
                <li>Journal Type is Accrual Reversal</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">NQP Expired</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total non-qualifying points expired in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of all Points field values in the Loyalty Ledger object.</p>
              <p>Filters applied:
              </p><a name="analytics_loyalty_kpis__ul_ayv_h2x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_ayv_h2x_gtb">
                <li>Event Type is Expiry</li>
                <li>Created Date is within the period selected in the Duration filter</li>
                <li>Currency Type is Non Qualifying</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">NQP Credited</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total non-qualifying points credited.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of Points field values in the Loyalty Ledger object where Currency Type is
                Non Qualifying.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_dwl_42x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_dwl_42x_gtb">
                <li>Event Type is Credit</li>
                <li>Journal Id matches with Journal Id in Transaction Journal</li>
                <li>Activity Date in Transaction Journal is within the period selected in the
                  Duration filter</li>
                <li>Journal Type is Manual Points Adjustment.</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">NQP Debited</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total non-qualifying points debited.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of Points field values in the Loyalty Ledger object.</p>
              <p>Filters
                applied:</p><a name="analytics_loyalty_kpis__ul_hqv_r2x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_hqv_r2x_gtb">
                <li>Currency Type is Non Qualifying</li>
                <li>Event Type is Debit</li>
                <li>Journal Id matches with Journal Id in Transaction Journal</li>
                <li>Activity Date in Transaction Journal is within the period selected in the
                  Duration filter</li>
                <li>Journal Type is Manual Points Adjustment</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">NQP Redeemed</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total non-qualifying points redeemed in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of points from Loyalty Ledger object. </p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_e1z_52x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_e1z_52x_gtb">
                <li>Transaction Journal Type is Redemption</li>
                <li>Ledger Event Type is Debit</li>
                <li>Currency Type is Non Qualifying</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">NQP Redemption Reversal Points</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total non-qualifying points credited because of redemption reversals.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of Points field values in the Loyalty Ledger object for a non-qualifying
                currency.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_s51_x2x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_s51_x2x_gtb">
                <li>Event Type is Credit</li>
                <li>Journal Id matches with Journal Id in Transaction Journal</li>
                <li>Activity Date in Transaction Journal is within the selected duration</li>
                <li>Journal Type is Redemption Reversal</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">NQP to Revenue Ratio</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">The ratio of non-qualifying points to Revenue.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">NQP Accrued / Total Revenue</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">New Members</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of new members in a loyalty program.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">Number of members who enrolled within the Enrollment Date in the period
              selected in the Duration filter.</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Partner NQPs Redeemed</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Non-qualifying points redeemed from a partner.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of all Points field values in the Loyalty Ledger object.</p>
              <p>Filters applied:
              </p><a name="analytics_loyalty_kpis__ul_tv4_z2x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_tv4_z2x_gtb">
                <li>Event Type is Debit</li>
                <li>Journal Id matches with the Journal Id in the Transaction Journal object</li>
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Redemption</li>
                <li>Status is Processed</li>
                <li>Currency Type is Non Qualifying</li>
                <li>Usage Type is Loyalty in the Transaction Journal object</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Percentage of Inactive Members</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">The inactive member base as a percentage of the total member base.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>((Inactive Members) / (Total Members)) x 100</p>
              <p style="margin-bottom:0;">Filter applied: Member Type is
                either Individual or Corporate.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Points Balance to Date</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total points balance as of today.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">Sum of all Points Balance field values in the Loyalty Member Currency
              object.</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Points Contribution to Liability</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">The impact of the accrued, redeemed, and expired points on the
              liability.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Increase in liability:</p><a name="analytics_loyalty_kpis__ul_lh2_fgx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_lh2_fgx_gtb">
                <li>Total NQP Accrued x Cost per Currency Unit</li>

              </ul>
              <p>Decrease in liability:</p><a name="analytics_loyalty_kpis__ul_mh2_fgx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_mh2_fgx_gtb">
                <li>Total NQP Redeemed x Cost per Currency Unit</li>

                <li>Total NQP Expired x Cost per Currency Unit</li>

              </ul>
              <p style="margin-bottom:0;">Filter applied: Member Type is either Individual or Corporate.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Product NQP Redeemed</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total non-qualifying points redeemed to purchase products or product
              categories.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of all Points field values in the Loyalty Ledger object.</p>
              <p>Filters applied:
              </p><a name="analytics_loyalty_kpis__ul_blj_2fx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_blj_2fx_gtb">
                <li>Either a Product Id or Product Category Id value exists in the Transaction
                  Journal object</li>
                <li>Currency Type is Non Qualifying</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Promotion Revenue</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Revenue generated by a promotion program.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of all Transaction Amount field values in the Transaction Journal object.</p>
              <p style="margin-bottom:0;" dir="ltr">Filter applied: Activity Date is within the period selected in the
                Duration filter.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">QP Credited</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total qualifying points credited.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of Points field values in the Loyalty Ledger object where Currency Type is
                Qualifying.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_uzw_ffx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_uzw_ffx_gtb">
                <li>Event Type is Credit</li>
                <li>Journal Id matches with Journal Id in Transaction Journal</li>
                <li>Activity Date in Transaction Journal is within the period selected in the
                  Duration filter</li>
                <li>Journal Type is Manual Points Adjustment</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">QP Debited</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total qualifying points debited.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of Points field values in the Loyalty Ledger object where Currency Type is
                Qualifying.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_ild_jfx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_ild_jfx_gtb">
                <li>Event Type is Debit</li>
                <li>Journal Id matches with Journal Id in Transaction Journal</li>
                <li>Activity Date in Transaction Journal is within the period selected in the
                  Duration filter</li>
                <li>Journal Type is Manual Points Adjustment</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Redemption Reversals</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total number of redemption reversal transactions in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of unique values in the Transaction Journal ID field in the Loyalty
                Ledger object.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_p4z_lfx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_p4z_lfx_gtb">
                <li>Event Type is Debit</li>
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Redemption Reversal</li>
                <li>Journal ID field values are the same in the Loyalty Ledger object and the
                  Transaction Journal object</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Redemption Partners</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of loyalty program partners with redemption transactions.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of all unique Loyalty Partner Id field values in the Transaction Journal
                object.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_fgw_4fx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_fgw_4fx_gtb">
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Redemption in the Transaction Journal object</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Redeemed Points Reversed</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total redeemed points reversed in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of all Points field values in the Loyalty Ledger object.</p>
              <p>Filters applied:
              </p><a name="analytics_loyalty_kpis__ul_r2p_fbx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_r2p_fbx_gtb">
                <li>Event Type is Debit</li>
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Redemption Reversal</li>
                <li>Journal ID field values are the same in the Loyalty Ledger object and the
                  Transaction Journal object.</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Redemption Products</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Products that members can purchase by redeeming the non-qualifying
              points.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of unique Product Id field values in the Transaction Journal object
                where the Product Id matches the Product Id in the Loyalty Partner Product object +
                Number of unique Product Category Id field values in the Transaction Journal object
                where the Product Category Id matches the Product Category Id in the Loyalty Partner
                Product object.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_afr_dbx_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_afr_dbx_gtb">
                <li>Journal Type is Redemption</li>
                <li>Activity Date is within the period selected in the Duration filter</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Redemption Reversals</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total number of redemption reversal transactions in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of unique values in the Transaction Journal ID field in the Loyalty
                Ledger object.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_dz5_z1x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_dz5_z1x_gtb">
                <li>Event Type is Debit</li>
                <li>Activity Date is in the period selected in the Duration filter</li>
                <li>Journal Type is Redemption Reversal</li>
                <li>Journal ID field values are the same in the Loyalty Ledger object and the
                  Transaction Journal object</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Redemption Rate</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Ratio of non-qualifying points redeemed to non-qualifying points
              accrued.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Non-qualifying points redeemed / Non-qualifying points Accrued.</p>
              <p style="margin-bottom:0;">Filters
                applied: Member Type is either Individual or Corporate.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Redemption Transactions by Partner</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of redemption transactions from a partner.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of unique Transaction Journal Id field values in the Loyalty Ledger
                object where the Journal Id matches the Journal Id in the Transaction Journal
                object.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_hz3_x1x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_hz3_x1x_gtb">
                <li>Event Type is Debit</li>
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Redemption</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Referrals</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of members who joined through referrals.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of Loyalty Program Member Id field values in the Loyalty Program Member
                object. </p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_zlm_v1x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_zlm_v1x_gtb">
                <li>A value exists in the Referred By Id field</li>
                <li>Enrollment Date is within the period selected in the Duration filter</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Referrers</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total number of referrers.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Number of unique members from the loyalty program with Member Id matching the
                Referred By Id of another record of the program.</p>
              <p style="margin-bottom:0;">Filter applied: Enrollment Date
                is within the period selected in the Duration filter.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Referrer to Referral Ratio</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">The ratio of referrers to referrals.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">Total number of referrals / Total referrers</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Revenue</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Revenue generated by a loyalty program in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Sum of all Transaction Amount field values in the Transaction Journal
                object.</p>
              <p>Filters applied: </p><a name="analytics_loyalty_kpis__ul_uyr_q1x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_uyr_q1x_gtb">
                <li>Activity Date is within the period selected in the Duration filter</li>
                <li>Journal Type is Accrual</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Responses</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Responses received for an NPS or CSAT survey question.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">Number of responses received.</td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Tier Changes</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Number of tier changes in a selected period.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>When history tracking is enabled and data exists in the Loyalty Member Tier
                History object, number of rows in the Loyalty Member Tier History object where both
                old and new values exist in the Loyalty Tier field. </p>
              <p>Example: If a member has a
                tier change from Silver to Gold and Gold to Platinum, then the total tier changes
                are two. The tier change history is Silver (old value) to Gold (new value) and
                Gold (old value) to Platinum (new value).</p>
              <p style="margin-bottom:0;">Filter applied: Created Date is
                within the period selected in the Duration filter.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Tier Change History</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">All tier changes</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>When history tracking is enabled and data exists in the Loyalty Member Tier
                History object, number of rows in the Loyalty Member Tier History object where
                both old and new values exist in the Loyalty Tier field.</p>
              <p>Example: If a member has a tier change from Silver to Gold and Gold to Platinum,
                then the total tier changes are two. The tier change history is Silver (old value)
                to Gold (new value) and Gold (old value) to Platinum (new value).</p>
              <p style="margin-bottom:0;">Filter applied: Created Date is within the period selected in the Duration
                filter.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Transactions</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total count of transactions in a selected promotion program.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>(Number of transactions in Ledger and Transaction Journal object) + (Number of
                transactions in the Voucher object)</p>
              <p dir="ltr">Filters applied: </p><a name="analytics_loyalty_kpis__ul_mww_l1x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_mww_l1x_gtb">
                <li>Journal Type is Accrual or Redemption</li>
                <li>Activity Date is within the period selected in the Duration filter. </li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Transaction Frequency</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">The frequency of transactions by loyalty program members.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">
              <p>Median (Average number of days between transactions by all members)</p>
              <p>Filters
                applied: </p><a name="analytics_loyalty_kpis__ul_nyv_f1x_gtb"><!-- --></a>
              <ul id="analytics_loyalty_kpis__ul_nyv_f1x_gtb">
                <li>Journal Type is Accrual or Redemption</li>
                <li>Member Type is either Individual or Corporate</li>
                <li>Activity Date is in the period selected in the Duration filter in the
                  Transaction Journal object</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Metric" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e71 ">Voucher Liability</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e74 ">Total voucher liability of a loyalty program.</td>

            <td data-label="Calculation" class="slds-cell-wrap" style="vertical-align:top;" headers="d9173e77 ">Number of records in the Voucher object where the Status field value is Issued
              x Cost Per Voucher field value in the Voucher Definition object.</td>

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

## Common Filters

These filters apply to all the metrics shown in Analytics for Loyalty dashboards:

- Status is Processed.
- Usage Type is Loyalty. This filter is applicable only for Transaction Journal object fields.