commissions_eq |
1 = trangular equation distribution, largest first. 2 = harmonic equation, largest first. 3 = geometric tuned equation of the trianglular distribution biased to sales revenue for each affiliate.
|
growth_curve_eq |
0 = ignore. 1 = Logistic curve, 2 = Positive Sign curve.
These equations are set to take intervals anywhere between 0 to 12 inclusive. Fractional decimals are fine.
For the Logistic curve, the target_revenue is reached at about 12.
For the Positive Sign curve, target_revenue is reached at interval 6 and decreases to 0% at 12 --useful to test extreme negative growth scenarios.
|
interpolate_last_band_p |
Set this to 1 to have the largest sale tier iterpolated. (default = 0)
This is useful for modeling infrequent, large sales volumes with varying, significant quantities. |
interval_count |
Number of intervals iterated. |
interval_size |
added to period_start for each interval |
interval_start |
The value for the first period's interval |
pct_pooled |
the commission from total revenue (as a decimal percentage) |
period_unit |
The unit that represents each period. |
revenue_target |
the target amount of sales. The total revenue for each period is one sale above target. |
sale_max |
the maximum value of a single sale. |
sales_curve_name |
Name of sales curve to use. Name must be unique |
sales_curve_tid |
Table ID of sales_curve to use. |
sample_rate |
Percentage of rows per period to be sampled. (The percent is represented as decimal: 100% = 1). |