Help with Analyzing & Creating Mixed Design Variables
I am looking for advice on analyzing and creating variables. I ran an experiment with a mixed design, with both between-group and within-group factors. The study design is 2 (Intervention: between-group) x 2 (Message-Tone: within-group) x 6 (Repeated messages). Participants received an intervention or control, then watched 6 videos in total: 3 with a positive tone and 3 with a negative tone. These videos are randomized. After watching a video, participants evaluated the message content. To collect the data, I needed to create a survey for each one of the condition. For example, 1) Experiment Positive Tone 1, 2) Control Positive Tone 1, 3) Experiment Negative Tone 1, 4) Control Negative Tone 1, etc., for a total of 12 separate surveys.
Now that I have collected all of my data, I have merged the files, cleaned my data, and am now trying to create variables, but when I try to run a reliability analysis for the dependent variable based on message-tone condition, I am getting an error message because "there are too few cases (N = 0) for analysis." I think this is because SPSS is counting missing responses in the between-group condition, since the control group did not respond to the same survey as the experimental group, and vice versa. So there is a big gap in the missing data by case and it looks like the participants in the control group did not respond to items in the experimental group (which they shouldn't have).
My question is whether there is an easier way to analyze this data. Should I create a variable based on the within-group condition, or is there a different way to approach my data? Any advice would be greatly appreciated.