Demographics - Create and Manage Demographic Fields in Your Database

=== ===

(% style="color:#000000" %)Demographic BuilderQuestions are all the data fields/questions in your database. Questions may be used on forms, or they may exist only in the database for backend use, e.g. data imports, manual data entry, etc. This lesson describes how to create and manage questions.

8

9

Please refer to Quick Start Guide- Forms for information on basic concepts and rules relating to forms.

10

11

=== ORDER OF DEMOGRAPHICS ===

12

13

**The order that questions appear in the Demographic Builder is the order that they'll appear in User Detail and the Add New User windows.**

14

15

In User Detail the first ten demographic questions and responses will appear by default, and to see the remaining questions/responses you must click "More Information >>". So, for example, if you want to see First Name, Last Name, Email, Title, Company Name, Company Address, Address2, City, State/Province, Zip/Postal Code by default in the User Demographic window, put your questions in that order in the Question Builder. The same applies if you want to have certain questions appear first in the Add New User window (for quicker manual entry).

16

17

See directions below on how to change the order of questions.

18

19

=== First, click on the "move" icon to the left of the question ID number. ===

20

21

[[image:attach:media_1430423471858.png||style="vertical-align:center"]]

22

23

=== Next, drag and drop the question into its new location. It's that simple. ===

24

25

[[image:attach:media_1430423394229.png||style="vertical-align:center"]]

26

27

See below how First Name was moved to appear after Last Name.

28

29

[[image:attach:media_1430423572179.png||style="vertical-align:center"]]

30

31

=== OPENING THE DEMOGRAPHIC BUILDER ===

32

33

=== Select INVENTORY from the main menu. ===

34

35

[[image:attach:Screen Shot 2019-12-23 at 11.42.40.png||width="755"]]

36

37

=== Select DEMOGRAPHICS from the sub-menu. ===

38

39

40

This will open the Question Builder where you will see a list of existing questions and the options to Create/Update Download Template* and to Create Question (See below.)

41

42

[[image:attach:media_1439927100065.png||style="vertical-align:center"]]

43

44

*Create/Update Download templat allows you to create and save templates of demographic fields to include when downloading a list. These templates may be selected at the time of download in the List Wizard. Many times the same demographic fields are needed for multiple lists, and this will enable a user to simply select a previously created template rather than having to go through and select each field for each list. This functionality is available in version 11.6 and later.

45

46

To quickly find a question, use the Search functionality at the top of the page to search by question name or id.

47

48

=== HOW TO CREATE A DEMOGRAPHIC QUESTION / DATABASE FIELD ===

49

50

(% style="color:#d00000" %)**Questions are all the data fields/questions in your database. Questions may appear on forms, or they may exist only in the database for administrative use, e.g. data imports, manual data entry, etc.**

51

52

(% style="color:#cb0303" %)**Because these "questions" are the actual data fields, they are a part of a pool of data fields/questions that are shared among ALL forms. If you change or delete a question, the change/deletion will change/delete that data field in the database and the question on ALL forms that use the question.**

53

54

There are two types of questions: standard (generic questions that are part of ONEcount~-~-e.g first name, last name, email) and user-created. User-created questions are those that you create and are specific to your database and forms, i.e. the user information you wish to include in your database and gather from your forms. Many of your questions will be user-created. It is not recommended to delete standard questions from the database.

55

56

=== Click "Create Question" ===

57

58

[[image:attach:media_1441727092268.png||style="vertical-align:center"]]

59

60

This will open a pop-up window, as shown below, where you enter the question text, response type, question alias,eport header, Question Tag, and Lookup Question. More detail on this follows.

61

62

=== "Question Text" - Enter the question text to be displayed on a form on the front end. ===

63

64

[[image:attach:media_1434994642968.png||style="vertical-align:center"]]

65

66

The Question Text is the text that a visitor would see on a form on your website.

67

68

As described above, there are some standard questions that can be used in a form. It is best to use existing questions if they match what you want the question to be. (See warning below.)

69

70

(% style="color:#ca0000" %)//**Warning: Remember that any changes to the Question Text will apply to the data field in your database and apply to ALL forms that use that question, even those previously created.**//

71

72

=== "Response Type" - Select the ResponseType for each question from the drop-down menu. See information below for further explanation. ===

73

74

[[image:attach:media_1434994596771.png||style="vertical-align:center"]]

75

76

**Response Type** defines the type of answer expected for the question; e.g., it makes sense to allow a user to select a state from a pull down instead of asking them to fill in a text box. This ensures the ONEcount system has uniform data in the database.

77

78

The response type can be //text field, text area, password, checkbox, radio button, select.//

79

80

The different types of response types are as follows:

81

82

**Text Field, Text Area, and Password Field (Open Ended)**

83

//text field~:// the user must type in a response (e.g. first name, last name)

84

//text area~:// same as text field, except allows more characters

85

//password field~:// text entered is not shown~-~-converted to *

86

87

* Radio Button and Select (Single Select - user can select only one response)*

88

//radio button// - user clicks on round button to select one response (e.g. male / female, yes/no/maybe)

89

//select// - user selects one response from a drop-down menu of choices

90

91

**Checkbox List** (Multi Select)*

92

user can click on multiple check boxes to select multiple responses from a list of choices

93

94

(% style="color:#cb0303" %)//**Note: The system will automatically create values for Checkbox List-type responses. If you will be importing data to this field, these values must be replaced in the import file.**//

95

96

(% style="color:#000000" %)//**Warning: Remember that any changes to Response Type will apply to the question/data field in your database and to ALL forms that use that question, even those previously created.**//

97

98

DON'T change a select- or radio-button type question to a text or checkbox-type question. Select- and radio-button type questions are created to ensure consistency in response values, and changing to a text-type question allows for inconsistent responses. For example, Country is a select-type question with certain display text and database values. Changing the question to, e.g., to a text-type question would allow front-end users to enter any text as a response. Using "United States" as an example, users could enter US, USA, U.S.A., United States of America, Unites States (notice the misspelling), Estados Unidos, etc. To pull a list, generate a report, create a targeting persona, you would have to determine and then include every possible variation of United States to do so. By keeping it as a select-type question, data is uniform, and lists, reports, and personas can be created consistently and accurately.

99

100

It is best not change a text/radio button/select-type question to a checkbox-type question. Because the system assigns values to checkbox-type questions and stores them in a different manner than other question types, if users' profiles are not updated with the new value for the checkbox-type question, the previously assigned values won't match the new values created by the system and can't be translated to the new values. As a result, User Demographics and Demographic Activity will show a blank for the response to that question and the List Wizard won't be able to generate a list based on that demographic. This will also affect pulling analytics based on that demographic question from Web Analytics and creating a target segment in the Persona Manager. (Remember, if user profiles aren't updated to new values, the system won't be able to translate the previous values to the changed values because of the different way they are stored within the system.)

101

102

(% style="color:#000000" %)When selecting to "View" a generated list in the List Wizard (which allows you to run a product or demographic report and immediately view it), you can only select demographic questions with Radio Button or Select-type responses for rows and columns in the reports. Text Field, Text Area, Password Field, and Checkbox List type responses cannot be used.

103

104

For Checkbox, Radio, and Select-type questions the display will change, allowing you to enter the Display Text (1), and for Radio and Select-type questions you can enter the value (2) for each possible response, as shown below.

105

106

[[image:attach:media_1434993527344.png||style="vertical-align:center"]]

107

108

(1) **Display Text** is the text that a visitor will see on the form.

109

(2) **Value** is the value you want assigned in the ONEcount database for that response. Values can be numeric or alphabetic (e.g. in a Yes/No question Display Text “Yes” value could = 1 or Yes, and Display Text “No” value could = 2 or No.) .

110

111

**TAKE NOTE:**

112

(% style="color:#cb0303" %)**The system will automatically create values for Checkbox-type responses. The "Value" field is locked, so you cannot enter your own values. When you save the question, the system-generated values will be added. If you will be importing data to this field, these values must be replaced in the import file.**

113

114

(% style="color:#ff0000" %)**For select-type questions, be sure to create a default answer as the first response, such as “Select One” If this is not set, any user who doesn't select an answer for the question will automatically be assigned the first value, which could be incorrect.**

115

116

**Do NOT use comma separated values or special characters as a value in select- and radio button-type responses. This will cause an error when displaying reports, forms, and saving user data.**

117

118

**Do not create any display text or value longer than 255 characters. The full text will not be saved.**

119

120

The order of responses can be changed in checkbox list, select, and radio button types of responses by clicking on the gray icon to the left of "Text:" and dragging the row to the desired position.

121

122

Any blank responses will automatically be deleted upon pressing "Add New Question".

123

124

Text and Values may be edited by clicking in the entry field.

125

126

(% style="color:#ca0000" %)//**Warning: Remember that any changes to Response Value will apply to the data field in your database and to ALL forms that use that question, even those previously created.**//

127

128

=== "Question Alias" - Enter a Question Alias, if needed. ===

129

130

[[image:attach:media_1434993469253.png||style="vertical-align:center"]]

131

132

**Question Alias** is used for identifying a question for a specific form. For example, you may need to create a two (or more) identical questions with different response options because the question has different possible responses or you may need to create two (or more) questions with very similar Question Text. To avoid confusion among similar questions, enter an alias for the question. Or, you may want an alias of ALL for questions that can be used across all forms.

133

134

For example, if you have different publications and/or products to offer – one for, say, medical doctors and another for allied health professionals - and both forms have the Question Text “Medical Profession", the response options may need to be slightly different to reflect the different types of titles for the different verticals. In such a case, you can create a "Medical Profession" question, then duplicate it and create an alias for the questions so you can identify them, e.g. abbreviated name of the publication/product or "AH - PROF” for the question with Allied Health responses and “DOC - PROF” for other.

135

136

In the screenshot above, the Question Alias "AH - PROF" identifies that particluar question and it's responses should be used for forms for Allied Health Professionals. Note "Select One" is the first possible response.

137

138

(% style="color:#ca0000" %)//**Warning: Remember that any changes to the Question Alias will apply to ALL forms that use that question, even those previously created.**//

139

140

=== "Report Header" - Enter text to be displayed in reports. ===

141

142

[[image:attach:media_1434992692042.png||style="vertical-align:center"]]

143

144

When a list is downloaded, the Report Header is the text that will appear in the report.

145

146

If no text is entered in this field when creating the form, the complete Question Text will appear in the report. It is best to include a Report Header if the question text is more than several words.

147

148

In the screenshot above, GRAD YEAR will appear as the column header in the list/report rather than "Year of Graduation from Medical Schoool?"

149

150

=== "Question Tag" – Select Question/Field to Tag (v. 11.6 and later) ===

151

152

[[image:attach:media_1436990184743.png||style="vertical-align:center"]]

153

154

Question Tags are used in conjunction with progressive lookup, social media login, forgot password, and smartlinks. They are used to identify and map questions in ONEcount for purposes such as checking for duplicate/existing email addresses when completing a form, checking username and password, and for identifying the correct field in which to put data coming into the ONEcount system from outside sources such as social media login.

155

156

(% style="color:#ff0000" %)**QUESTION TAG CONFIGURATION SHOULD BE DONE UPON QUESTION CREATION. IF REQUIRED QUESTIONS, E.G. EMAIL, AREN'T CONFIGURED WITH A QUESTION TAG, PROGRESSIVE LOOKUP AND OTHER FEATURES MAY NOT WORK PROPERLY.**

157

158

**The Email question MUST be set with a Question Tag so that the system will know that is the field to check for an existing email when a user enters his/her email address in a form. If the email is identified, the user will be presented with a challenge question. When the question is answered correctly the user will automatically be logged in and the form auto-populated with the user's information. (See Progressive Lookup** **for more information on how ONEcount's progressive lookup feature works.)**

159

160

The Question Tag for Phone comes into account when progressive lookup needs to send a code to a mobile number. Other question tags like city, state, birthday, gender, etc. (the values that can be pulled up from social login) are used in social login to auto-populate those question fields in a form.

161

162

When a question is tagged, it says to the system, "This is the question ID for email" or "This is the question ID for username" or "This is the question ID for Last Name" so that ONEcount knows to match email or phone information with the correct question/field when input by a user or when being pushed to ONEcount from social media login.

163

164

*In Version 11.6 and prior, there are mappings for these questions in the Configuration Manager. However, the questions should also be tagged in the Question Builder. Questions/fields that should be tagged are those that will be used for checking for duplicate/existing email and phone data, Username and Password for login and duplicate checking, and fields that will be pulled into ONEcount upon logging into ONEcount va social media, such as first name, last name, city, state, zip, gender, etc.

165

166

*

167

** In post-Verion 11.6, the mappings will no longer be in the Configuration Manager and Question Tags will be the only mechanism to map questions. Question Tags will be pre-set for standard demographic questions that come with the ONEcount system.

168

169

=== "Lookup Question" – Select Yes or No (v. 11.6 and later) ===

170

171

[[image:attach:media_1434992788590.png||style="vertical-align:center"]]

172

173

Lookup Questions are used in conjunction with ONEcount's progressive lookup feature.

174

175

The default is "No", meaning that the question will not be used as a challenge question for progessive lookup on forms.

176

Selecting "Yes" means that the question will be used as a challenge question for progressive lookup on forms.

177

178

See Progressive Lookup documentation for more detail on progressive lookup functionality.

179

180

**If you set several lookup questions there is more probability that the system will present the user a challenge question instead of sending a verification code (see Progressive Lookup** **documentation).**

181

182

**Challenge questions will only appear if the question value is not empty; and they should be questions that are not being answered in the form. More selected lookup/challenge questions means more of a chance that a user has a response in the database to one of them and will be able to answer rather than requiring a verification code.**

183

184

=== Once Question Text, Response Type, Question Alias, Report Header, Question Tag, Lookup Question, and possible responses and values are completed, click "Add New Question" to save the question. ===

185

186

[[image:attach:media_1434993398198.png||style="vertical-align:center"]]

187

188

The new question will be assigned a Question ID and appear at the top of the list of questions. (See below.)

189

190

[[image:attach:media_1441726923283.png||style="vertical-align:center"]]

191

192

You can change question order by clicking on the icon to the left of the ID number and dragging the question to the desired location in the list.

193

194

**The order of questions in the Question Builder is the order that they will appear in User Detail and when adding a new user.**

195

196

=== HOW TO CREATE A DOWNLOAD TEMPLATE (v. 11.6 and later) ===

197

198

"Create/Update Download Template" allows you to create and/or edit templates used for repeated downloads that include the same demographic fields each time. Templates can then be selected when you download a report/file.

199

200

=== Click on "Create/Update Download Tempate". ===

201

202

[[image:attach:media_1441723894734.png||style="vertical-align:center"]]

203

204

This will open the "Manage Download" Template window where you'll see a list of existing templates, as shown below.

205

206

=== Click "Create Template". ===

207

208

[[image:attach:media_1441723967166.png||style="vertical-align:center"]]

209

210

This will open the "Add/Update Download list Template" pop-up window, as shown below.

211

212

[[image:attach:media_1441724079294.png||style="vertical-align:center"]]

213

214

Give the template a name, description, and select demographic fields you want to include in the template.

215

216

[[image:attach:media_1441724149285.png||style="vertical-align:center"]]

217

218

When finished selecting the demographic fields for the template, click anywhere outside of the Demographic Selection drop-down list and click "Save".

219

To cancel the operation, click "Cancel".

220

221

=== HOW TO EDIT A DOWNLOAD TEMPLATE ===

222

223

=== Click on "Create/Update Download Tempate". ===

224

225

[[image:attach:media_1441725850192.png||style="vertical-align:center"]]

226

227

This will open the "Manage Download" Template window where you'll see a list of existing templates, as shown below.

228

229

Note: to quickly locate a template, use the Search functionality.

230

231

=== Click the "expand" icon to see a list of demographic fields included in a template. ===

232

233

[[image:attach:media_1441725891669.png||style="vertical-align:center"]]

234

235

=== Click the "edit" icon. ===

236

237

[[image:attach:media_1441726213345.png||style="vertical-align:center"]]

238

239

This will open the "Add/Update Download List Template" pop-up window as shown below.

240

241

=== Add/remove demographic fields and/or change Name and Description. ===

242

243

[[image:attach:media_1441726416700.png||style="vertical-align:center"]]

244

245

To remove a question/field, click on the "x" to the right of the question.

246

To add a question/field, click anywhere in the Demographic Selection field to display a drop-down list of remaining demographic questions.

247

248

When done, click "Update".

249

To cancel the operation, click "Cancel".

250

251

=== HOW TO MANAGE QUESTIONS ===

252

253

Icons in the "Operation"" column are used to edit, delete, and copy questions.

254

255

[[image:attach:media_1430170179578.png||style="vertical-align:center"]]

256

257

=== To edit a question, click on the Edit icon. ===

258

259

[[image:attach:media_1430170224754.png||style="vertical-align:center"]]

260

261

This will open the "Update Question" window where all relevant fields for the question type may be edited. (See below.)

262

263

[[image:attach:media_1430170253054.png||style="vertical-align:center"]]

264

265

**Important Note:**

266

**It is best not change a text/radio button/select-type question to a checkbox-type question. Because the system assigns values to checkbox-type questions and stores them in a different manner than other question types, if users profiled are not updated with a value for the checkbox-type question, the previously assigned values won't match the new values created by the system and can't be translated to the new values. As a result, User Demographics and Demographic Activity will show a blank for the response to that question and the List Wizard won't be able to generate a list based on that demographic. This will also affect pulling analytics based on that demographic question from Web Analytics and creating a target segment in the Persona Manager. (Remember, if user profiles aren't updated to new values, the system won't be able to translate the previous values to the changed values because of the different way they are stored within the system.)**

267

268

=== To delete a question, click on the Delete icon. ===

269

270

[[image:attach:media_1430422138414.png||style="vertical-align:center"]]

**NOTES:**

(% style="color:#cb0303" %)**Because these "questions" are the actual data fields, they are a part of a pool of data fields/questions that are shared among ALL forms. If you change or delete a question, the change/deletion will change/delete that data field in the database and the question on ALL forms that use the question.**

275

276

(% style="color:#cb0303" %)**DO NOT DELETE ANY STANDARD QUESTIONS (THOSE QUESTIONS THAT CAME PRE-INSTALLED WITH ONECOUNT – QUESTION #s 1-14).**

277

278

(% style="color:#ff0000" %)**USE DELETE WITH CAUTION. IF YOU DELETE A QUESTION IT WILL BE DELETED FROM ALL FORMS THAT ARE USING IT. IF USERS HAVE RESPONDED TO A DELETED QUESTION, THE DATA WILL REMAIN IN THE DATABASE, BUT YOU WON'T BE ABLE TO RETRIEVE IT (E.G. USING THE LIST WIZARD TO RUN A LIST BY DEMOGRAPHIC).**

279

280

[[image:attach:media_1430422192271.png||style="vertical-align:center"]]

281

282

Select on the pop-up confirmation either "Cancel" to cancel the deletion or "OK" to proceed with the deletion.

283

284

(% style="color:#ff0000" %)**Remember that deleting a question will remove it from the database and from ALL forms it appears on.**

285

286

=== To copy a question, click on the Copy icon. ===

287

288

[[image:attach:media_1430422364988.png||style="vertical-align:center"]]

289

290

This will make a copy of the question, including Text/Type/Alias/Report Header and all response text and response values.

291

292

The new question will have the same question text as the old, with "_Copy" appended at the end, and it will appear at the bottom of the question list. In the screenshot below, the question "How many employees work at your company?" was copied.

293

294

[[image:attach:media_1430422601797.png||style="vertical-align:center"]]

295

296

Once the question is copied, you can rename and edit it just as you would any other question.

297

298

Note: If only adding or removing responses to a question, don't copy/create a new question.