Skip to Main Content

MKTG 4650: Promotion Management & Strategy

Library Databases for Consumer Information

MRI Simmons' Crosstab tool allows users to search, pull, and edit criteria from survey data and add it to a report while sorting and filtering categories.

The Crosstab tool flows from left to right, where criteria are searched on the left side of the tool and added to the report on the right side of the screen.

For detailed information, visit the Using MRI Simmons guide.

To access the Crosstab tool, choose the Analyze tab from the menu at the top of the screen. Then, choose the menu option for Crosstab.

MRI Simmons menu ribbon with Analyze tab expanded. Crosstab is the first item in the list.

 

 

This will open the Composer tool, which you use to select information to be displayed in the Crosstab. As you select and refine, the categories will fill in the boxes from left to right, and prompt you to click, hold, and drag, or otherwise select information. You start by using search bar at the top of the tool, or choose criteria by using the dropdown menus in the box on the left side of the screen.

The Composer tool. As you select and refine information and categories, the tool will prompt you to further refine how and what the layout will be.

 

Once you have finished selecting what the categories, click Run Report in the bottom, right-hand corner. It will produce a table of values including Unweighted, Weighted, Vertical %, Horizontal %, and Index.

Click on the three dots in the upper right corner of the columns to filter the column information from least to most, or most to least. Typically users find it most helpful to filter by most-to-least by Index.

Use the Variables, Filters, Transpose, and Target Creator on the left-hand side hide or expand the columns, rows, layout, and other features of navigating the table.

If you find yourself needing to refine the survey variables themselves, click on Composer to add, delete, refine, or otherwise edit the survey data.

Crosstab table displayed. Menu for sorting by index shown. Also highlighsts Composer button, Variables, Filters, and Target Creator to assist in refining data.

To search for consumer information in Passport, choose the Consumers tab at the top of the screen, then Income and Expenditure.

You can then use the use a view Dashboards, Latest reports, or build and refine a dataset with the drop down menu. The Income and Expenditures page, you can peruse Dashboards, Latest reports, or build and refine a dataset with the drop down menu.

One option is to choose the Reports tab at the top of the screen. Then, choose the option for Consumer & Brand Reports. Here, you will find more information about consumer preferences and insights for various industries, including full dossiers and brand reports.

 

Statista reports page (or menu)

You may also find Market and Consumer insights helpful. To get to those surveys, select Insights, then Explore Market Insights or Explore Consumer Insights.

Statista insights page (or menu)

You can build out a dataset based on consumer survey information.

U.S. Census Bureau Demographic Information

Selection of Ebooks for Demographic Information

Bureau of Labor Statistics Consumer Expenditure Surveys