Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Select Test & Control Markets (DMA)

bertal34
8 - Asteroid

Hello,

 

I have been tasked with selecting 2 test markets and 2 control markets (based on DMA) which have similar characteristics.  Three characteristics include: # of stores within market, # of customers, and total sales.

 

What would be the best way to go about this?

 

thanks,

Jesse

1 REPLY 1
CharlieS
17 - Castor
17 - Castor

Hi @bertal34 

 

I see two major steps here: 
1. Generate the necessary data (the characteristics mentioned above) for all DMAs. 

2. Create groupings of DMAs based on those characteristics. I'd recommend checking out the Predictive Grouping tool category for this. 

Where are you at in the project and what can the Community help with?

Labels