Audience sheet overview
Audience sheets can be found by going to Resources > Sheets in the left navigation menu. Then, type "audience" in the search box to see the system's available audience sheets.
Tip! If a system audience sheet doesn't meet your fielding needs, try creating your own audience sheet.
Audience sheets contain the following columns and information:
| Column | Required for | Description |
| id | Audience sheets |
The ID assigned to the option. Note, the option set used in the quota variable must match the option set in the sheet exactly. |
| text | Audience sheets | The text describing the option. |
| percent | Audience sheets | The percent allocated to the quota option (out of 100%). |
| sample_code | Auto-Sample applet |
The value stored in the database for the specific quota group. You must use a registered (expected) value so that the system can look up the quota criteria. |
| country |
Auto-Sample applet |
The country for which the quota group was created. Note, IntelliSurvey uses the Alpha2 reference for country codes. |
| difficult | -- |
This optional field is used with the Auto-Sample applet. The difficult column acts as a flag to the system, indicating that a specific quota group is more challenging to fill than others. If the cell has a value of '1', the software will request sample at a higher rate. If the cell is empty or has a value of '0', the software will request sample at a regular rate. |
Creating or customizing audience sheets
Customizing an audience sheet could be helpful when the system-provided audience sheets do not meet your fielding needs. Simply make edits to an existing audience sheet and "localize" it in your survey home by adding it directly to the survey's Sheets applet.
To get started, go to the "Home page," expand Resources, and click on Sheets. Choose any audience sheet and download it to use as a template.
Requirements
Audience sheets require these columns to be present in order to function: id, text, and percent. Additional columns can be added as needed. An example of an existing system audience sheet for standard US age groups is shown below.
Note: Custom audience sheets do not have any registered values for 'sample_code' at the system level, and are not available for use with the Auto-Sample applet.
Example
Editing the sheet
Suppose you need to combine the two older age groups shown in the standard US age groups above. First, remove the three optional columns if they are not needed — sample_code, country, and difficult. Next, delete the sixth row, and merge the upper two age bands into one single age group called "55+." Then, combine the two corresponding percentages and edit the percent allocated (16.6% + 20.7% = 37.3%). Make sure the percentages across all rows sum up to 100%.
Once the audience sheet is ready, upload the sheet to the survey's Sheets applet.
Tip! Read Creating and editing survey sheets for more information on formatting survey sheets.
Editing the survey code
In addition to the sheet changes, the source code must also be adjusted. First, update the list that has the same set of options as the audience sheet to reflect the changes made in the sheet. Then, update the audience sheet tag's input to reference the new local sheet.
setlist: AGELIST
1. 18 to 24
2. 25 to 34
3. 35 to 44
4. 45 to 54
5. 55+
AGE. What is your age group?
type: radio
optsfrom: AGELIST
AGEQ. Age group quota
type: quotas
audience sheet: serverid.audiencesheet_55plus
optsfrom: QAGE
Audience sheets are referenced in the same way sheets are referenced anywhere else in the IntelliSurvey platform.
Tip! If you need assistance with creating a custom audience sheet, please contact a Support agent via our chatbot or email help@intellisurvey.com.
Comments
0 comments
Please sign in to leave a comment.