Somebody asked me to run an analysis of their data. They are testing whether rewards card would have impact on sales.
Design of the experiment:
They run an experiment, they invited four stores, 30 respondents given rewards card and 30 respondents given a purchase monitoring card. Two stores designated as the treatment (offers reward to 30 card holders with rewards card for every 10 store visits) and the two designated as the control (offers no reward but will stamp stickers to the card of the 30 respondents for store visit monitoring).
Data collected
They presented me with sales data (baseline and post experiment sales) but this aggregated sales in every stores and not on the purchase history of the respondents. I also asked the store visits of the 60 respondents but they only recorded the visits during the experiment period. So there is no baseline store visits data. There are demographic data as well, age and gender only.
Initial treatment
I run a two factor ANOVA without replication for the sales data they gave me and the results shows that only the treatment and control group is significant but the pre-post test sales is not. My analysis is that the huge variance of the average sales data between treatment and control stores contributes to the variation, but the sales between pre-post experiments, although post sales is higher but not so impressive.
I wanted to use the store visit data of the 60 respondents, the profile and the behavioral questions on loyalty, accessibility and price. So my question is, what alternative analysis/tool can I use to make use of this data?