Consumer Report

Consumer Report

Overview

Compusense offers the Consumer report, which enables you to unpack your consumer data in a more meaningful way and look for demographic segments within your data.

Panelist Demographics and Sample Rating: The report can reveal to you potential relationship between your panelist demographics and their preference towards samples.

For example, in your decision making about the packaging format for your chocolate production, it can be highly important to know whether there is a relationship between the age group and the type of chocolate preference/purchase frequency. The Consumer report can show you if there is such relationship, and much more.
Warning
We recommend to keep demographic and sample related questions within the same section during the test setup. That way the Consumer report can be generated without the need for additional steps. If it happened that your test was set up with demographic questions in separate sections, you can still run the report but you will first need to filter the data based on the demographic question of your choice (= more work for you).


First Position Effect: Another useful functionality that the Consumer Report provides is splitting the data by the first sample position. This can be particularly useful when analyzing novel or surprising products.

Compatibility

The Consumer Report is compatible with the following:
  1. Sample and non-sample related question types below:
    1. Category

    2. Choose

    3. Rank

    4. Comment

  2. Standard test types and survey test types.

The report is not compatible with:
  1. Question types found in the Standard test that are not mentioned in the list above.

  2. Discrimination test types.

To Generate the Report 


  1. In the test, click Results . If you need to exclude specific samples and/or sample sets from the analysis, click Filters and specify your criteria.

  2. Click on the Reports menu and select Create report .

  3. Under the 1 Select Report Type , select Consumer report .
     
  4. Under the 2 Select Options , specify the options you wish to include in the report.

     
    1. Crosstabulations & Graphs: 
      1. Include Crosstabulations in the form of counts, percentages, or both.

      2. Set the number of decimal places in your report, from 0 to 4. The default is 0. Selection made here will reflect in the rounding of the data.

      1. Data splits: Specify whether and how you wish to split your data. To see the selected splits in your report, in the next steps you will have to indicate that you wish to include those sheets in the file.
        1. Split the data based on the samples' first position to take into consideration the first position effect.

        1. Split the data based on the responses in the demographic (non-sample related) questions in the test, such as purchase or consumption frequency.

          AlertOnly non-sample related Category and Choose 1 questions are eligible for data splits.


        1. Split the data based on the panelist information stored in the Panelists library , such as gender or dietary restrictions.

          AlertData splits are compatible only with panelist information stored in Choose 1 fields. Text and other field types are not compatible with the Consumer report.


          NotesThe report will use the snapshot of the data in the Panelists library the way it was at the time the panelist results were collected.

          If you make any changes to the panelist data after results are collected, those changes will not be reflected in the Consumer report.

          For example, panelist John Smith had in his panelist record that he consumed chocolate on daily basis. You conducted a consumer test and planned on splitting data on chocolate consumption field in the Panelists library. Right after the test, John clicked on the Account button and updated his chocolate consumption frequency to once a week. The next day, after all the expected results were collected, you generated the Consumer report. John's results were included in the calculations for the 'on daily basis' data split, because he updated his record after he completed your test, even though you generated the report after he made the change to his record/account.
        1. Include sheets: If the sheets outlined below are not selected for inclusion in the report, their corresponding data splits will not be in the report even if those splits were specified in the above Data splits steps. Details about each of the sheets are available further down on this page.

          1. Data summary. If any of the splits were selected, this sheet includes the original analysis per sample and all the splits per sample. Here is a small example:


          2. Within sample. If any of the splits were selected, this sheet includes the splits within each sample. This sheet will not generate in survey tests even if the option was selected. Here is a small example:


          3. Demographic splits. If any of the splits were selected, this sheet includes the splits within each sample. Here is a small example:

              
        2. Analysis options from defaults: Click Change advanced analysis options to update the Multiple comparison test as desired. You may select more than one Multiple comparison test if you wish.

          Idea The Consumer report always runs a 1-way ANOVA.

      1. Under the 3 Select Questions , select the questions that you wish to include in the report.

      2. The 4 Select Export Type has only one export type, .xlsx. You cannot deselect that or change it to something else.
        1. Click Create my report  to immediately generate the Consumer report. Click the download arrow, save the report to a location on your computer or network drive and open it.

        2. Click Schedule report to set up an automatic email with the Consumer report attached to it.



      Report Details

      Depending on the test setup, there can be up to five sheets in the report: 
      1. Demographics - This sheet is available when at least one of the following is in place:
        1. Demographic (non-sample related) questions with data in them were selected before running the report.
        2. Panelist fields from the Panelists library were selected for data splits prior to running the report.

          This sheet includes graphs and crosstabulations (if selected prior to running the report) showing counts and/or percentages. Even when no splits are selected, this sheet will generate when demographic questions are included in the analysis.


      2. Data Summary - This sheet is available when sample related questions with data in them were selected before running the report. Even when no splits are selected, this sheet will generate.

        The sheet includes:
        1. Crosstabulations for overall results and on any data splits (if selected prior to running the report).
        2. Means.
        3. Multiple comparison test for attributes that are not JAR (just about right). The Multiple comparison test is coming from the Advanced analysis options described in the steps for generating the report. You may select more than one Multiple comparison test if you wish.


          Idea The Consumer Report always runs a 1-way ANOVA.

        4. Collapsed frequencies for JAR (just about right) attributes. The report will display the frequencies for each point in a table, and in a table below that it will also collapse/combine the points (their frequencies). The top points will be combined in one row, the JAR frequencies will be in their own row (not combined with any other points), and the bottom points (those lower than the JAR point on the scale) will be combined and displayed in their own row. For example:

          NotesThe report will use the snapshot of the data in the Panelists library the way it was at the time the panelist results were collected.

          If you make any changes to the panelist data after results are collected, those changes will not be reflected in the Consumer report.

          For example, panelist John Smith had in his panelist record that he consumed chocolate on daily basis. You conducted a consumer test and planned on splitting data on chocolate consumption field in the Panelists library. Right after the test, John clicked on the Account button and updated his chocolate consumption frequency to once a week. The next day, after all the expected results were collected, you generated the Consumer report. John's results were included in the calculations for the 'on daily basis' data split, because he updated his record after he completed your test, even though you generated the report after he made the change to his record/account.
      3. Within Sample - The sheet contains the same details the Data Summary sheet does, except the information is further split within each sample based on the demographic data.


        This is an example of the collapsed frequencies for JAR (just about right) attributes in this sheet:


      4. Demographic Splits - The sheet contains data splits for every demographic question included in the analysis based on the demographic splits selected before generating the report.


      5. Comments - available if sample related Comment questions with data in them were selected before running the report.

        This sheet lists original comments from each panelist for each sample they commented on, and the counts for any data splits (if selected prior to running the report).



      Feel free to download and review the attached example Consumer report generated in a survey test (no sample related data).

        • Related Articles

        • Set Automated Reports Emails

          Overview In addition to being able to generate reports in Compusense, some of them you can set up to automatically email out to recipients of your choice. You can specify what triggers the report to automatically email out without any additional ...

        • Consumer Testing

          Welcome to the Consumer Testing Webinar! If you have any questions about any of the content in this webinar, please feel free to contact our friendly support team for assistance. Agenda: Samples as Images Test Set Up Add Questions For Selected ...

        • PowerPoint Report Review

          Overview The PowerPoint report is a great way to visualize your data. The customizable graphs will help you to share information with other teams. If you would like the PowerPoint Report to generate using your corporate template, please contact our ...

        • Panelist Report Types

          Overview In the Panelists library you can find reports related to panelist activity, incentives, attendance, and performance. Use the link below to access detailed steps for generating the corresponding report type. Check back soon for workflows that ...

        • Standard Report Review

          Overview The Standard Report provides a breakdown of results by attributes (where applicable) and samples, as well as the analysis that was selected while generating the report. Question Compatibility The report is compatible with the following ...