Skip to Main Content

Using MRI Simmons Catalyst: Creating Crosstabs

What is on this page

Here you can find both the user journey and illustrated step by step instructions on how to create a crosstab in MRI Simmons Catalyst. 

You can also learn about how to create these reports via the video below. 

Creating Crosstabs in MRI Simmons Catalyst- Instruction Video

Creating Crosstabs in MRI Simmons Catalyst

Below are step by step instructions on how to create a basic crosstab in MRI Simmons Insights.  The instructions are described via a clickstream below as well as by written-out steps and screen grabs.

Clickstream/User Journey= 

MRI Simmons> "Profile" tab, in dropdown > "Quick Reports">"Composer">"Composer", type in keyword relevant to research>relevant category/sub-category> variable of choice, drag variable of choice into add section> "Targets"> "Create"

STEP 1:

 

1) After accessing the MRI Simmons database click on the "Analyze" tab. In the "Profile" drop-down click on the "Crosstab" button. 

 

STEP 2:

Hitting the "crosstabs" button in the dropdown should take you to the composer interface. In this interface the easiest way to find something useful for your research is to search using a keyword in the search box. In this example, because we are looking to find information about energy drink users, we use "energy" which is circled in red.

(Hint: If a keyword does not bear fruit, something of interest might be listed under another keyword. Due to this, make sure to try synonyms or other relevant keywords.)

STEP 3:

After typing in your keyword you then need to choose one of the categories to explore. These categories can be found under the search bar on the left hand side of the screen.

Notice that when you choose a keyword many of these categories will disappear due to lack of that keyword being in the category. For this example the most relevant category was "Beverages Non-Alcoholic" shown by the red circle below.  

STEP 4:

After clicking on the category the majority of the time it will be broken down into sub-categories. For this example we chose "Energy Drinks & Shots", which is notated by the blue arrow and focused the research to look at the "brand summary" of users of energy drinks which is notated by the blue circle. This means that it will encompass all users of a particular brand of energy drink. Finally we then need to choose our brand, Red Bull, which can be chosen by clicking on the box beside it which is circled in red.  

It is important to note during this stage that their are a variety of different users we can research. For example, in the below screenshot, we can see "ALSO" and "MO" users. See definitions page for explanations of what these mean. 

STEP 5:

After selecting your variable of interest by checking the box next drag it over to "ADD TO" section, which is shown by the red arrow. Next click either  the "column" or "row" button at the bottom of the "ADD TO" section. 

STEP 5:

Once you have put your variable(s) of interest into the "Columns" section, you then need to do the almost the exact same process with the variable you want to set it against. The only difference will be be putting your other variable(s) into the "Rows" section.

In this example, I want to see which convenience stores red bull consumers have shopped at in the past four weeks. 

To do this I used the "CONVENIENCE STORES: CONVENIENCE STORES- SHOP LAST 4 WEEKS_ALL" variable which is notated by the blue arrow. Choosing this variable allowed me to choose all 17 of the convenience stores included the survey shown by the blue circle. 

To set it against Red Bull consumers I then need to click the "ROWS" button which is notated by a red arrow to put it into "Rows" section which is circled in Red.