Best Practice - Apply Transactions Filtering To Plans

Best Practice - Apply Transactions Filtering To Plans


Normally, you want your sales incentive plans to only process sales transactions within a time period, but also matching a certain criteria (ex: exclude all line items of type "renewal", only consider transactions associated with new products, etc.).

Applying transaction filtering to your plans can:
  • Reduce the risk of commission overpayment
  • Avoid the system asking you for unnecessary input (ex: catalog entries) via system alerts
  • Increase calculation speed by processing fewer records
  • Avoid you having to pre-determine which specific transactions to import

To apply filtering, simply create a saved query, and apply it to your plan.

Importing all transactions, and then applying transaction filtering to your plan, is a winning combination.

    • Related Articles

    • Best Practice - Designing Plans Which Are Fair

      When designing a sales incentive plan, your goals typically include: Limiting total spend to a reasonable amount Maximizing the effectiveness of your spend Ensuring that top performers feel recognized Ensuring that participants are challenged to ...

    • Best Practice - Configure Formulas Only When Needed

      In many cases, you don't need to define formulas because default behaviors implemented by Sales Cookie are sufficient. For example: To control filtering, you can create a saved query and apply it to your plan - without using a dynamic transaction ...

    • Best Practice - Only Add Users You Need

      We recommend that you only add users you need. Our billing is per user. It is designed to match usage, our own costs performing incentive calculations, and complexity associated with managing records. Here are our recommendations to avoid unnecessary ...

    • Best Practice - Paying Commissions Ad-Hoc

      There are 3 recommended ways to pay ad-hoc commissions. Applicability The following assumptions apply: Estimated commissions are being calculated You want to manually release commission payouts Option #1 - Add a Release Date To Your Data Here are the ...

    • Best Practice - Legally Protect Your Sales Incentive Plans

      By clearly documenting your sales incentive plan's terms and conditions (and ensuring that potential beneficiaries are aware of those rules), you can: Increase transparency Reduce confusion Reduce the chance of disputes Reduce overall legal risk and ...