How to filter the different answers obtained in a quiz

1. Introduction.

2. Step by step.

3. Other specifications.

4. Related content.

1. Introduction.

Sometimes it is very useful to work with the participation Excel file from a campaign, to check certain data about the answers given by participants or the time they took to complete the form.

Below, we explain how to filter the different data in the participation Excel file.

2. Step by step.

Let's look at an example of how to filter quiz answers to find out how many participants selected each answer.

1. Download the list of participations. To do this, go to the 'Leads' section of the campaign.

2. Once inside, go to the 'Download' section in the left sidebar, download the complete list of participants and open it with Excel.

3. In the Excel file, find the column with the data you want to analyse or review. In our example, the one corresponding to the first quiz question. Right-click on the column header and choose 'Create a filter' (depending on your version of Excel, this option may appear here or in the top menu).

4. Click the icon (funnel) that has appeared next to the question to select one of the answers for that question and find out how many participants chose each one.

5. When you select each answer, check the message that appears at the bottom of the Excel file: that is where you will see the count for the selected answer.

3. Other specifications.

Bear in mind that the participation list itself includes filters that can be very useful: by name, dates, campaign, medium, source, referring domain, language, final screen, most chosen answer type, or participation status.

If you have any questions, contact us at help@cool-tabs.com.

4. Related content.

How to create a Random List Sweepstakes.