Best Practice - What Does Good Transaction Data Look Like?

Best Practice - What Does Good Transaction Data Look Like?


First of all, we want to make it clear that the system offers a high degree of flexibility, and any transaction input is very likely to work:
  • Combining currency symbols and numeric value in transaction data (ex: "$123")?
    • Not a problem - learn more about currency handling here.
  • Using employee IDs instead of user names / emails in transaction data?
    • Not a problem - learn more about how user aliases are used for crediting here.
  • Using per-product costs / quantities instead of total revenue in transaction data?
    • Not a problem - learn more about revenue calculations here.

However, an ideal transaction would include the following fields:
  • A transaction date
  • A unique transaction ID (learn more)
  • A product name
  • A customer name
  • A total revenue
  • A total tax amount (if the revenue includes taxes)
  • An event name (ex: "Ship", "Refund", etc.)
  • A single "Sold By / Owner" field (ex: with the salesperson's email address)
  • A "Team / Territory" field
  • Currency information

    • Related Articles

    • Best Practice - Use Meaningful Transaction Dates

      When importing transactions, you must map a field to category "Transaction Date". This field will be used to determine whether a transaction is valid for a given time period (ex: Q3, November, etc.). It's important that the chosen field and ...

    • Best Practice - Use Simulations To Forecast Sales Incentive Spend

      Running a calculation in simulation mode allows you to forecast sales incentive spend, attainment levels, and reward assignment. By drawing past simulations at random, while "pretending" they happened in the future, you fulfill the claim that "the ...

    • Best Practice - How Can I Audit Calculation Results?

      To audit calculation results, we recommend exporting data from calculations. Consider watching this short video for a brief overview. Export Credits Credits represent the attribution of transactions to users or teams. Credits are used for attainment ...

    • Best Practice - Adjusting Commissions

      Here are some recommendations when manually adjusting commissions. Adjusting commissions is a complex topic because they are different ways to adjust. We hope the following recommendations will help you. Analyze Adjustment Frequency Assuming your ...

    • Best Practice - Handling Terminated Payees

      When an employee leaves your organization, you may want to: Ensure they cannot access online commission statements Stop paying for a Sales Cookie license Finalize remaining owed commissions Below are different actions you can perform when an employee ...