Methods and apparatus to identify retail pricing strategies
Methods and apparatus to identify retail pricing strategies are disclosed herein. An example apparatus for identifying a pricing strategy employed by a store includes a calculator to calculate a first pricing strategy variable for the store based on sales data of the store. The example apparatus includes an index creator to index the first pricing strategy variable against aggregated data for a plurality of stores to generate a pricing index. The example apparatus includes a pricing strategy identifier to identify a pricing strategy for the store based on the pricing index.
1. An apparatus for identifying a pricing strategy employed by a first store, the apparatus comprising:
memory;
instructions in the apparatus; and
processor circuitry to execute the instructions to:
calculate a first value of a first pricing strategy variable for a first product and a second value of the first pricing strategy variable for a second product, the first value and the second value based on sales data of the first store corresponding to the first product and the second product, each of the first product and the second product associated with a product category;
calculate a third value of a second pricing strategy variable for the first product and a fourth value of the second pricing strategy variable for the second product, the third value and the fourth value based on the sales data of the first store corresponding to the first product and the second product, the second pricing strategy variable different than the first pricing strategy variable, the first pricing strategy variable indicative of one of (a) a discount amplitude, (b) a discount frequency, or (c) a discount duration for the first product, and the second pricing strategy variable indicative of a different one of (a) the discount amplitude, (b) the discount frequency, or (c) the discount duration for the first product, the second pricing strategy variable not including the one of (a) the discount amplitude, (b) the discount frequency, or (c) the discount duration associated with the first pricing strategy variable;
aggregate the first value and the third value to generate a first aggregated value of the first pricing strategy variable;
aggregate the second value and the fourth value to generate a second aggregated value of the second pricing strategy variable;
aggregate the first aggregated value and a third aggregated value associated with a second store to generate a first national value of the first pricing strategy variable; and
aggregate the second aggregated value and a fourth aggregated value associated with the second store to generate a second national value of the second pricing strategy variable;
index the first aggregated value against the first national value and the second aggregated value against the second national value to generate, respectively, a first pricing index for the first pricing strategy variable for the first store and a second pricing index for the second pricing strategy variable for the first store; and
identify the pricing strategy for the first store from a set of pre-defined pricing strategies, the pre-defined pricing strategies having different combinations of reference pricing indices of pre-defined pricing strategy variables, the processor circuitry to identify the pricing strategy based on a comparison of the first pricing index and the second pricing index to the reference pricing indices of the pre-defined pricing strategy variables of the pre-defined pricing strategies.
2. The apparatus of claim 1 , wherein the processor circuitry is to identify the product category associated with the sales data of the first store, the processor circuitry to identify the pricing strategy for the first store for the product category.
3. The apparatus of claim 2 , wherein the processor circuitry is to identify the product category based on a uniform product code for the first product in the sales data and a uniform product code for the second product in the sales data.
4. The apparatus of claim 1 , wherein the pricing strategy is a first pricing strategy, and wherein the first store is associated with a retailer, the retailer associated with at least one of the second store or a third store, the processor circuitry to identify the pricing strategy for the retailer based on the first pricing strategy for the first store and a second pricing strategy for the at least one of the second store or the third store.
5. The apparatus of claim 1 , wherein the processor circuitry is to identify the pricing strategy for the first store based on a comparison of the first pricing index to first reference pricing indices of the set of pre-defined pricing strategies corresponding to the first pricing strategy variable.
6. The apparatus of claim 1 , wherein the processor circuitry pricing is to cluster the first store based on the first pricing index relative to the reference pricing indices.
7. The apparatus of claim 1 , wherein the processor circuitry is to generate the first aggregated value of the first pricing strategy valuable by:
weighting the first value with a first number of equalized units sold of the first product; and
weighting the second value with a second number of equalized units sold of the second product.
8. The apparatus of claim 7 , wherein the processor circuitry is to generate the second aggregated value of the second pricing strategy valuable by:
weighting the third value with the first number of equalized units sold of the first product; and
weighting the fourth value with the second number of equalized units sold of the second product.
9. The apparatus of claim 1 , wherein the processor circuitry is to generate the first national value of the first pricing strategy by weighting the first aggregate value with a number of equalized units of the first product and the second product sold by the first store.
10. A method for identifying a pricing strategy employed by a first store, the method comprising:
calculating, by executing an instruction with a processor, a first value of a first pricing strategy variable for a first product and a second value of the first pricing strategy variable for a second product, the first value and the second value based on sales data of the first store corresponding to the first product and the second product, each of the first product and the second product associated with a product category;
calculating, by executing an instruction with a processor, a third value of a second pricing strategy variable for the first product and a fourth value of the second pricing strategy variable for the second product, the third value and the fourth value based on the sales data of the first store corresponding to the first product and the second product, the second pricing strategy variable different than the first pricing strategy variable, the first pricing strategy variable indicative of one of (a) a discount amplitude, (b) a discount frequency, or (c) a discount duration for the first product, and the second pricing strategy variable indicative of a different one of (a) the discount amplitude, (b) the discount frequency, or (c) the discount duration for the first product, the second pricing strategy variable not including the one of (a) the discount amplitude, (b) the discount frequency, or (c) the discount duration associated with
aggregating, by executing an instruction with the processor, the first value and the third value to generate a first aggregated value of the first pricing strategy variable;
aggregating, by executing an instruction with the processor, the second value and the fourth value to generate a second value of the second aggregated pricing strategy variable;
aggregating, by executing an instruction with the processor, the first aggregated value and a third aggregated value associated with a second store to generate a first national value of the first pricing strategy variable;
aggregating, by executing an instruction with the processor, the second aggregated value and a fourth aggregated value associated with the second store to generate a second national value of the second pricing strategy variable;
indexing, by executing an instruction with the processor, the first aggregated value against the first national value and the second aggregated value against the second national value to generate, respectively, a first pricing index for the first pricing strategy variable for the first store and a second pricing index for the second pricing strategy variable for the first store; and
identifying, by executing an instruction with the processor, the pricing strategy for the first store from a set of pre-defined pricing strategies, the pre-defined pricing strategies having different combinations of reference pricing indices of pre-defined pricing strategy variables, the pricing strategy identified by comparing the first pricing index and the second pricing index to the reference pricing indices of the pre-defined pricing strategy variables of the pre-defined pricing strategies.
11. The method of claim 10 , further including:
identifying the product category associated with the sales data of the first store; and
identifying the pricing strategy for the first store for the product category.
12. The method of claim 10 , wherein the pricing strategy is a first pricing strategy, and wherein the first store is associated with a retailer, the retailer associated with at least one of the second store or a third store, the method further including identifying a pricing strategy for the retailer based on the first pricing strategy and a second pricing strategy for the at least one of the second store or the third store.
13. The method of claim 10 , further including identifying the pricing strategy for the first store based on a comparison of the first pricing index to first reference pricing indices of the set of pre-defined pricing strategies corresponding to the first pricing strategy variable.
14. The method of claim 10 , further including clustering the first store based on the first pricing index relative to the reference pricing indices.
15. A non-transitory computer-readable medium comprising instructions that, when executed, cause a processor to, at least:
calculate a first value of a first pricing strategy variable for a first product and a second value of the first pricing strategy variable for a second product, the first value and the second value based on sales data of a first store corresponding to the first product and the second product, each of the first product and the second product associated with a product category;
calculate a third value of a second pricing strategy variable for the first product and a fourth value of the second pricing strategy variable for the second product, the third value and the fourth value based on the sales data of the first store corresponding to the first product and the second product, the second pricing strategy variable different than the first pricing strategy variable, the first pricing strategy variable indicative of one of (a) a discount amplitude, (b) a discount frequency, or (c) a discount duration for the first product, and the second pricing strategy variable indicative of a different one of (a) the discount amplitude, (b) the discount frequency, or (c) the discount duration for the first product, the second pricing strategy variable not including the one of (a) the discount amplitude, (b) the discount frequency, or (c) the discount duration associated with the first pricing strategy variable;
aggregate the first value and the second value to generate a first aggregated value of the first pricing strategy variable data;
aggregate the third value and the fourth value to generate a second aggregated value of the second pricing strategy variable data;
aggregate the first aggregated value and a third aggregated value associated with a second store to generate a first national value of the first pricing strategy variable;
aggregate the second aggregated value and a fourth aggregated value associated with the second store to generate a second national value of the second pricing strategy variable;
index the first aggregated value against the first national value and the second aggregated value against the second national value to generate, respectively, a first pricing index for the first pricing strategy variable for the first store, and a second pricing index for the second pricing strategy variable for the first store; and
identify a pricing strategy for the first store from a set of pre-defined pricing strategies, the pre-defined pricing strategies having different combinations of reference pricing indices of pre-defined pricing strategy variables, the pricing strategy identified by comparing the first pricing index and the second pricing index to the reference pricing indices of the pre-defined pricing strategy variables of the pre-defined pricing strategies.
16. The computer-readable medium of claim 15 , wherein the instructions further cause the processor to:
identify the product category associated with the sales data of the first store; and
identify the pricing strategy for the first store for the product category.
17. The computer-readable medium of claim 15 , wherein the pricing strategy is a first pricing strategy, and wherein the first store is associated with a retailer, the retailer associated with at least one of the second store or a third store, and wherein the instructions cause the processor to identify a pricing strategy for the retailer based on the first pricing strategy for the first store and a second pricing strategy for the at least one of the second store or the third store.
18. The computer-readable medium of claim 15 , wherein the instructions cause the processor to identify the pricing strategy for the first store based on a comparison of the first pricing index to first reference pricing indices indexes of the set of pre-defined pricing strategies corresponding to the first pricing strategy variable.
19. The computer-readable medium of claim 15 , wherein the instructions cause the processor to cluster the first store based on the first pricing index relative to the reference pricing indices.
20. The computer-readable medium of claim 15 , wherein the pricing strategy is a first pricing strategy, and wherein the instructions further cause the processor to identify a second pricing strategy for the second stored from the from the set of pre-defined pricing strategies by comparing pricing indices of the second store to the reference pricing indices of the pre-defined pricing strategy variables of the pre-defined pricing strategies.
21. The computer-readable medium of claim 15 , wherein the second pricing strategy is different than the first pricing strategy.