How to upload a demographics file, and how that information is used for making your Polly data more meaningful.
Who can use demographic segmentation?
Polly users on an Enterprise plan or a legacy Pro/Business plan can create demographic segments for their audience in Slack.
To start using it, click on the Demographics tab on the left-hand sidebar, and then click on the Update Population button.
💡Learn more about what each plan includes here.
What are the ways that Demographics files are used?
Once you have uploaded a demographics file on the web dashboard, it's retroactively applied to all of your past results and future results as well. This is incredibly powerful because you can now splice and dice your data with powerful segmentation that you've defined.✨
Specifically, you can filter your polly results for attributes that you've included in your file, such as "Office Location" or "Role" to see how certain groups of segments respond to your polly.
Additionally, this information is automatically captured when you export as well. Note that demographics is only applied to non-anonymous, or confidential pollys. Anonymous is truly anonymous.
If I change my historical pollys anonymity setting from anonymous to confidential, will I be able to apply demographics data to it?
For non-recurring pollys, the response visibility cannot be changed from anonymous to confidential. For recurring pollys the response visibility can be changed to confidential only for future instances of the polly. Historical pollys with confidential responses can have demographic data applied to them.
What kind of file upload can I do for my demographics segmentation?
Currently we accept .CSV formats for demographic segmentation uploads. For an accurate demographic upload, there are a few criteria to follow:
- Demographic attributes must be the first row as column headers – each attribute is an individual column.
- The very first column must be the Slack email: we use this to match email addresses your users have set up with their Slack accounts.
- Every row after the attribute column headers should have the users attribute information.
Here’s an example of a CSV upload:
✏️Note: The size of your chosen audience needs to be > 5 for the Demographics functionality to work. There will be empty boxes in your CSV export/pollys data if you have less than 5 values against a certain attribute.
Example: The demographics sheet you have uploaded has 2 attributes; gender and location. Within location there are 3 locations; Asia, Africa, America.
The single question polly that you sent, it got 10 responses. Let’s say 6 responses came from Asia, 3 from Africa and 1 from America. Now, the location information in front of the responses from Africa and America will be blank as the response count on that attribute is less than 5. Location information will be visible in front of the Asian respondents as they are > 5.
For confidential pollys, a segment value (i.e. value of an attribute example Asia) is only kept out if it applies to less than 5 responders, not the entire population. In the above example, there are more than 5 people in Africa, but only three of them responded, so it did not display.
For the same question, if the responses from the other attribute i.e. gender were 5 female and 5 male, the gender data will be visible.
What does “applied to responses before” mean?
When you upload a demographic roster via CSV, it applies to all of your polly responses retroactively, regardless of when you uploaded the file.
If you have only applied one demographic population, then that is automatically set as the current and will apply to all responses. But if you have more than one upload (if you’ve updated your population) for each date that you upload a population will be the date which all responses will be applied to.
However, you can change the date for when responses will be applied to the population of choice – just click on the icon right next to the date, and select the desired date. All responses prior to the date selected, will be applied with the population upload.
How often should I update my population demographics?
It depends on how often your employee roster changes, and what your attributes are. We recommend for every big shift in employee changes to update your population demographics as necessary – for example, you just hired 100 new people and are about to send out a survey to them, you likely would want to segment your results by your new employees’ metadata.
I have just updated my demographic data and I want it to apply to the exports I will do for my pollys in the last 3 months. How can I make this happen?
When you upload a demographic file, it applies to all of your polly responses, regardless of when you uploaded the file. Demographics have date ranges you can apply them, this way you can set the range that that demographic set should apply for. Alternatively, you can just delete older demographic sets which makes the application date infinitely long.
I uploaded the wrong demographic file. If the previous one is removed and new one is added, how will it impact the results of the ongoing Polly?
It will have no impact on the ongoing Polly results. You can replace the demographics file any time as it is independent of responses collection. Basically, you can change the demographics file even after the results have been collected.
How do I see what rows were successfully uploaded?
After you’ve uploaded a demographic population, you can either click on the File Name to view it. When you click on it, a window will pop open with all the successful rows that were imported.
But if we are unable to match email addresses, then there will be a banner at the top and also noted next to the email, as shown below:
You can either choose to ignore and continue or cancel the import and re-upload if you come across errors. By choosing to ignore and continue, the CSV will successfully upload with the attributes matched to the correct users – and will even apply attributes to all results retroactively unless the results were anonymous.
Does my demographic data export with polly results, too?
If you’ve already uploaded your demographic data – then yes!
- For all of your pollys where results were either made public or confidential, then your export will include demographic data.
- For confidential pollys, it will include all demographic data except for usernames.
- For anonymous pollys, no demographic data will be included with your export.
✏️ Note: The functionality of getting the survey results or upload with demographics through an API isn't available currently. You can only get these results through through CSV exports or Google Sheets Integration. More here about API related fields