0 ×

MS-221 Random Coupons v03

Workflow

[Market Simulation] MS-221 Random Coupons
[Market Simulation] MS-221 Random Coupons Explores the effectiveness of sending coupons to randomly selected Customer Demographic groups. Uses the KNIME Extension: Market Simulation by Scientific Strategy - Community Edition A comprehensive description of this workflow with step-by-step instructions can be found at the Scientific Strategy website: https://scientificstrategy.com/ms-221/
Market Simulation (MS-221) - Random CouponsExplores the effectiveness of sending coupons to randomly selectedCustomer Demographic groups. Competitive Story:Spacely Sprockets has about a 50% share of the Sprockets market. He decides tosend coupons to randomly selected potential new Customers. He wishes to testfive different coupon strategies and compare the results to his existing sales: - 100% of existing Cogswell Cogs Customers get a $10 coupon - 40% of new Customers get a $20 coupon (Group A) - 30% of new Customers get a $30 coupon (Group B) - 20% of new Customers get a $40 coupon (Group C) - 10% of new Customers get a $50 coupon (Group D) Define the current state of theMarket comprising of two similarProducts sold by SpacelySprockets and Cogswell Cogs. Identify those Customers whodid not buy Spacely Sprocketsthen allocate them randomly toGroups A / B / C / D. Split each Customer Group andgive each potential newCustomer a Coupon (raisingtheir WTP by the same amount). Spacely gives all currentCogswell Cogs Customers a$10 Coupon to switch over toSpacely Sprockets instead. Predict the outcome of allCoupon strategies and collectthe results. Deduct the cost of eachredeemed Coupon from the totalProfit of each promotion strategy.Spacely SprocketsCogswell CogsWillingnessTo Pay (WTP)of CustomersDemographicGroup A / B / C / DCurrent MarketNo Coupons40% CustomersGet $20 CouponGroup AGet CouponsAfter Group ACouponsGroup BGet Coupons30% CustomersGet $30 CouponAfter Group BCoupons20% CustomersGet $40 CouponGroup CGet CouponsAfter Group CCoupons10% CustomersGet $50 CouponGroup DGet CouponsAfter Group DCouponsCollect ResultsTarget DemographicsSpacely SprocketResultsTop: All OtherBottom: SpacelyAllCustomers100% CogswellGet $10 CouponAfter All CustomersGet CouponsCollectAll ResultsProductArrayNo Coupon Value$10 Coupon Value$20 Coupon Value$30 Coupon Value$40 Coupon Value$50 Coupon ValueReduce ProfitBy Coupon CostTop: SpacelyBottom: CogswellSpacely SprocketsCoupon Profit Table Creator CustomerDistributions Random LabelAssigner Simulate Market Scale Demographic Row Splitter Simulate Market Row Splitter Scale Demographic Simulate Market Scale Demographic Row Splitter Simulate Market Scale Demographic Row Splitter Simulate Market Concatenate(Optional in) Row Splitter Row Splitter Concatenate Scale Demographic Simulate Market Concatenate(Optional in) Column Filter ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Math Formula Row Splitter GroupBy Bar Chart(JFreeChart) Market Simulation (MS-221) - Random CouponsExplores the effectiveness of sending coupons to randomly selectedCustomer Demographic groups. Competitive Story:Spacely Sprockets has about a 50% share of the Sprockets market. He decides tosend coupons to randomly selected potential new Customers. He wishes to testfive different coupon strategies and compare the results to his existing sales: - 100% of existing Cogswell Cogs Customers get a $10 coupon - 40% of new Customers get a $20 coupon (Group A) - 30% of new Customers get a $30 coupon (Group B) - 20% of new Customers get a $40 coupon (Group C) - 10% of new Customers get a $50 coupon (Group D) Define the current state of theMarket comprising of two similarProducts sold by SpacelySprockets and Cogswell Cogs. Identify those Customers whodid not buy Spacely Sprocketsthen allocate them randomly toGroups A / B / C / D. Split each Customer Group andgive each potential newCustomer a Coupon (raisingtheir WTP by the same amount). Spacely gives all currentCogswell Cogs Customers a$10 Coupon to switch over toSpacely Sprockets instead. Predict the outcome of allCoupon strategies and collectthe results. Deduct the cost of eachredeemed Coupon from the totalProfit of each promotion strategy.Spacely SprocketsCogswell CogsWillingnessTo Pay (WTP)of CustomersDemographicGroup A / B / C / DCurrent MarketNo Coupons40% CustomersGet $20 CouponGroup AGet CouponsAfter Group ACouponsGroup BGet Coupons30% CustomersGet $30 CouponAfter Group BCoupons20% CustomersGet $40 CouponGroup CGet CouponsAfter Group CCoupons10% CustomersGet $50 CouponGroup DGet CouponsAfter Group DCouponsCollect ResultsTarget DemographicsSpacely SprocketResultsTop: All OtherBottom: SpacelyAllCustomers100% CogswellGet $10 CouponAfter All CustomersGet CouponsCollectAll ResultsProductArrayNo Coupon Value$10 Coupon Value$20 Coupon Value$30 Coupon Value$40 Coupon Value$50 Coupon ValueReduce ProfitBy Coupon CostTop: SpacelyBottom: CogswellSpacely SprocketsCoupon ProfitTable Creator CustomerDistributions Random LabelAssigner Simulate Market Scale Demographic Row Splitter Simulate Market Row Splitter Scale Demographic Simulate Market Scale Demographic Row Splitter Simulate Market Scale Demographic Row Splitter Simulate Market Concatenate(Optional in) Row Splitter Row Splitter Concatenate Scale Demographic Simulate Market Concatenate(Optional in) Column Filter ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Math Formula Row Splitter GroupBy Bar Chart(JFreeChart)

Download

Get this workflow from the following link: Download

Nodes

MS-221 Random Coupons v03 consists of the following 33 nodes(s):

Plugins

MS-221 Random Coupons v03 contains nodes provided by the following 5 plugin(s):