Download respondent background data

Do you want more data on your respondents, if you missed to ask them in the survey? 

Are you looking to invite previous respondents to a new study and need their Panelist ID? (Read more about Invite specific panelists in our Knowledge Base)

Then download the respondent background data from the Project Overview. 

How to open the file in Excel without losing data

Quick video tutorial

or follow these steps:

Download the .csv file
Open Excel
In Excel/'Data' tab select 'Get data From Text'
Select to open you .csv file
In the Excel 'Text Import Wizard Step 1' select the file is 'Delimited'
Click next
In the Excel wizard step 2 select the delimiter 'Comma' and nothing else
Click next
In the Excel wizard step 3 select all columns in the 'Data preview' and after that select data format 'Text'
Click 'Finish'

The file contains data on respondents that have interacted with the study in some way, thus the following respondent statuses are exported:

• Early screenout (status coded as 3, in the exported file)
• Started (status 1)
• Complete (status 5)
• Quota full (status 6)
• Timed out (status 9)
• Fraudulent (status 16)
• Suspicious (status 11)
• Quality terminate (status 17)

Read more about respondent statuses on our Knowledge Base.

The file contains the following 42 respondent profiling points, in English. Please note some data’s availability depends on the panelist’s choice to answer the profiling question:

• Project specific data:
• Respondent survey URL
• Respondent Code
• Panelist ID
• Respondent GUID
• Panel Name
• Respondent Status

• Target Group Name

• Basic demographic data of the respondent:
• Sex
• Postal code
• Age
• Country of respondent residence
• Ethnicity (if available in the country of the target group)
• Occupation
• Education
• Extended profiling data on the respondent:
• Access to car
• Car manufacturer (brand)
• Car was manufactured in (year)
• Car was purchased in (year)
• Estimates to purchase next car in (year)
• Panelist is main automotive decision maker
• Primary role in organization
• Company size
• Industry sector
• Field of expertise (department they work in)
• Decision Making Authority
• Marital status
• Accommodation
• Household size (no. of people living there)
• Main grocery shopper
• Supermarkets used
• Number of children
• Ages of children
• Gender of children
• Pets
• Average alcohol consumption, weekly
• Types of beverages
• Tobacco
• Finance – which bank (current account)
• Personal Income Classification
• Household Income classification
• Socio economic level (if available in the country of the target group)

 Do you want the background data in JSON format? Ask your Cint Representative to enable your account and sign up for the Developer Portal to get the questions and answers keys