Note: this article describes how to update an existing sample. To create a new sample please see ‘Add new local sample‘
Important: Member variables should always match the Column name in Excel and the correct data type should be used:
So in this example, for the Age variable an Integer Number is expected. If you would populate a cell in the Age column in Excel with ‘Thirty’ instead of ’30’, the member variable will not be updated.
Updating existing members
Existing members always have a unique MemberId. The MemberId is used to match the data to the corresponding member. When you want to update update existing members you can:
Update existing member variables
Select the sample that you want to update.
- Download the members to Excel.
- Update the desired values in the cells.
- Save the file.
- Select Import or update members from Excel.
- Upload the updated file.
- Set the import settings (unique email addresses/ phone numbers are usually recommended).
- Review and finish the import.
- The import process will take place (depending on the size of the sample and the number of variables it can take a few minutes).
- View the Last import result to see how many members were updated.
- Optional: view the updated member details.
In this example the following variables are updated:
MemberId 1
– Email is updated to jane.doe@email.com.
– First name is updated Jane.
– Region is updated to Region 6.
MemberId 2
– Language is updated to NL (Dutch)
In case you delete a column from the Excel file and import the file, this member variable will be ignored (not updated or deleted). In case you delete a row from the file and import the file, the corresponding member will be ingored (not updated or deleted). For deleting members, please see this page.
Add additional member variables
If you want to add an additional member variable (column in Excel) and populate this member variable with values you can follow the steps below:
- Navigate to Variables to see the existing member variables.
- Click on Add Content to add an additional custom member variable.
- Select the desired data type.
- Determine the variable name.
- Navigate back to the Members overview.
- Click on Download members to Excel.
- Open the file from downloads.
- Populate the corresponding column with the desired values.
- Save the Excel file.
- Click on Import or update members from Excel.
- Select the updated file.
- Set the import settings (unique email addresses/ phone numbers are usually recommended).
- Review and finish the import.
- The import process will take place (depending on the size of the sample and the number of variables it can take a few minutes).
- View the Last import result to see how many members were updated.
- Optional: view the updated member details.
In this example an additional custom member variable is added. It regards the variable Age of the type integer number.
Add new members to existing sample
The MemberId column determines whether existing members will be updated, or whether new members will be added. If you delete the MemberId column from the Excel file, you will automatically create new members when uploading the Excel file. You can find an example of the steps below:
- Download the members to Excel.
- Delete the MemberId column.
- Add the desired members or data to the Excel File (usually you would copy this from your data source file).
- Note: the Email, Cell Phone Number and Code columns should contain unique values (or be empty)
- Save the Excel file.
- Click on Import or update members from Excel.
- Select the updated Member file.
- Set the import settings (unique email addresses/ phone numbers are usually recommended).
- Review and finish the import.
- The import process will take place (depending on the size of the sample and the number of variables it can take a few minutes).
- View the Last import result to see how many members were updated.
- Optional: view the updated member details.
In this example, two new members are added to an existing sample. For the Code column the following behaviour applies:
- The code should be unique accross the workspace.
- In case you delete the code column, the member variable will not be updated.
- If you leave the code column empty, a unique code will be generated.
- If you populate the code column with values, you can determine the code.