You are here:

AB Treatments Tool

The AB Treatments tool assists the user in determining which group is the best fit for AB testing. This is appropriate in cases where the test will be carried out on a set of test units from the same group, based on user specified selection measures (between 2 and 5 measures can be selected). For a number of common test situations (particularly those that make use of broadcast media such as radio or television), a "group", such as a designated market area (DMA), needs to be selected to implement the test, with the units (e.g., stores, customers) in the group being the treatment units in the test. The tool returns a report with a rank ordered list of groups based on how well the average unit in the group meets the selected criteria based on a Euclidean distance measure.

This tool uses the R programming language. Go to Options > Download Predictive Tools to install R and the packages used by the R Tool.

Input

An Alteryx data stream with a unit identifier, a group identifier, and two or more measures to compare different groups to the overall average for those measures.

Configuration Properties

Configuration

Minimum number of treatment units for a group: The minimum number of units that need to be in a group in order to have that group considered (a filter). A rule of thumb is to have ten or more units receive the same treatment in order to provide a reasonable level of power for a test.

Data Input

Choose Object ID (String) Field: The field with the unit identifier (e.g., store, customer). This field must be some sort of character based type such as String or V-String.
Choose Group ID (String) Field: The field with the group identifier (e.g., geographic region, segment). This field must be some sort of character based type such as String or V-String.
Choose Variable 1 Field: The first numeric field used to compare the average unit in a group to the overall average of all units.
Choose Variable 2 Field: The second numeric field used to compare the average unit in a group to the overall average of all units.
Choose Variable 3 (Optional) Field: The third numeric field used to compare the average unit in a group to the overall average of all units. Specifying this field is optional.
Choose Variable 4 (Optional) Field: The fourth numeric field used to compare the average unit in a group to the overall average of all units. Specifying this field is optional.
Choose Variable 5 (Optional) Field: The fifth numeric field used to compare the average unit in a group to the overall average of all units. Specifying this field is optional.

Outputs

A set of report snippets that includes the group identifier, the number of objects (units) in the group, and a score for each group that ranges from 1 (the closest to the overall average) to 0 (the furthest from the overall average) for the best ten groups based on the score measure.
A data stream that contains all the information contained in the report for all eligible groups (those that meet the minimum number of units criteria), along with the average, minimum, and maximum index value for each measure used to assess a group relative to the overall average. These additional measures are index numbers, so a group that has a value of one on a measure has an average for that group that exactly matches the overall average for that measure. If the index value is less than one, then, on average, that group has units that have an average value on that measure which is below the overall average, while an index over one indicates that the reverse is true. The minimum and maximum value for the index number of each measure is provided for each group, so that the user can understand the variability in each measure for members in each group.