PE-GPR/9.0.0/Help/cfgCustomers - Revision history

Vivian: Published

2020-08-04T12:37:26Z

Published

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

2020-07-25T02:30:18Z

Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"

2020-07-15T11:45:09Z

Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Vivian: Published

2020-05-26T15:31:02Z

Published

Vivian: Published

2020-03-05T20:01:41Z

Published

Vivian: Published

2020-02-20T12:54:36Z

Published

WikiSysop at 13:47, January 17, 2020

2020-01-17T13:47:24Z

Vivian: Published

2019-12-20T22:15:13Z

Published

New page

{{Article
|Standalone=No
|DisplayName=Import and manage Customer Profile data
|Platform=PureEngage
|TocName=Import and manage Customer Profile data
|ComingSoon=No
|Context=Use the sections and options in the Data Loader Application object to configure the Customer Profile schema and to import customer-related data that you can then use to create Predictors. For upload, you must gather the desired data into a CSV file having with a consistent schema. After import, you can append data or update the data.
|Section={{Section
|sectionHeading=Create a Customer Profile
|FAQHeading=How do I upload customer data from a CSV file?
|Type=Unstructured
|anchor=newCustProfile
|freetext=[[File:newCustProf.png|left|thumb|Select CSV file to upload data]]

#Click the '''Settings''' gear icon [[File:GPMsettingsGear.png|50px]], located on the right side of the top menu bar, to open the '''Settings''' menu (appears on the left side of the window).
#Click the''' Customer Profile''' tab to open the Customer Profile window.
#Click the '''Source File''' text box to browse for your CSV file, or drag and drop it into the text box.

The Predictive Routing application automatically determines the separator type. It reads the schema from the configuration you specified in the Data Loader Application object. See {{Link-SomewhereInThisVersion|manual=Deployment|topic=DL-CfgFile|display text=Configure Data Loader to upload data}} for details.

'''NOTE:''' You must reload this page to view updates made using the Predictive Routing API, such as appending data to the Customer Profile.
|Status=No
}}{{Section
|sectionHeading=Verify the Schema
|Type=Unstructured
|anchor=verifyCustProf
|freetext=At this stage, before the data is uploaded, review and configure your Customer Profile.

[[File:CustProfSetID.png|left|thumb|Verify Customer Profile Schema and Set ID]]

#GPR automatically identifies the correct field separator in your CSV file.
#Scroll down the list of fields and ensure that the datatypes have been discovered correctly. If any are incorrect, select the correct datatype from the '''Type''' drop-down list.
#*GPR supports the following datatypes: Boolean, Numeric, List, String, Timestamp, and Dict. See {{Link-SomewhereInThisManual|topic=DataSetup#csvSetup|anchor=top|display text=Setting Up a CSV File - Requirements and Limitations}} for how to correctly prepare your data, including characters that are unsupported or need special handling.
#Click the '''X''' in a row to remove it from the Customer Profile. If you change your mind before you upload your data (that is, before you click the '''Create''' button on the window), scroll to the bottom of the list of fields and click in the '''None Selected''' text box. Choose the field to be restored, and click '''Add Back'''.
#Set the '''ID Field''', which is used as a key when joining customer with interaction data. The drop-down list contains all fields with the String datatype. <br /> '''NOTE:''' ID Fields with a numeric datatype are not supported.
#(Optional) Click in the '''PII Fields''' text box to select the fields that contain personally identifiable or sensitive information, such as Social Security numbers, passwords, names and addresses, phone numbers, and so on. Data in these fields is anonymized when you create the Customer Profile. See {{Link-SomewhereInThisManual|topic=DataSetup#anonymize|anchor=top|display text=Data Anonymization}} for important information about how data is anonymized. Note that you cannot anonymize the '''ID Field'''.
#Click '''Create''' to upload the data.

*If you try to upload a file that contains more than 100 columns, GPR generates an error message. Cancel out of the upload procedure, edit your CSV file to reduce the number of columns, and then repeat the upload procedure.
*If you try to upload a file with too many columns using the GPR API, the error message appears in the Customer Profile '''Description''' field in the GPR application.
*If you try to upload more than 2.5 million rows to a Customer Profile, only the first 2.5 million rows are stored and the rest are discarded. A warning message appears on the Customer Profile '''Uploads''' tab specifying how many rows were discarded. The '''Append''' button is disabled until you delete some rows from the Customer Profile.
|Status=No
}}{{Section
|sectionHeading=View The Customer Profile Schema
|Type=Unstructured
|anchor=viewCustProfSchema
|freetext=After you create the Customer Profile, the Customer Profile schema appears. It shows all of the columns in your schema and includes the following information:

*'''Label''' and '''Type''' - The ''Label'' is the name of the column in the Customer Profile and the ''Type'' is the datatype for that field. You can adjust the datatype, if necessary.
*The field specified as the '''ID Field''' field is marked with a dot in the radio button for that row.
*'''Visible''' and '''Indexed''' - ''Visible'' fields appear in the display on the Customers tab (accessed from the top navigation bar). ''Indexing'' speeds access to values in that field. You can have up to 20 indexed fields.
*'''Cardinality''' - the number of unique values that occur in that column. If there are more than 1000, this field shows the value as '''1000+'''. Click the cardinality value to open a pop-up window that displays the first 1000 unique values that occur in the field.
*'''Expression''' - If you created a custom field (as described in {{Link-SomewhereInThisManual|topic=cfgCustomers#appendCustProf|anchor=top|display text=Append Data to the Customer Profile}}) the expression you used is indicated in this column.

You can sort the table by clicking any column header.
|Status=No
}}{{Section
|sectionHeading=Add Data to the Customer Profile
|FAQHeading=How do I add data to the Customer Profile?
|Type=Unstructured
|anchor=appendCustProf
|freetext=You can add data to the Customer Profile in either of two ways, by adding single fields, or by uploading additional CSV files. You can also create a custom field that is a expression built from existing Customer Profile fields.

To add single fields:

#Scroll to the bottom of the list of Customer Profile fields and click '''Add New Field'''.
#:If you click in the text box, any fields you previously removed are listed. You can select them to be added back into the Customer Profile.
#To add an entirely new field, type a new field name and press '''Enter'''. The custom field value must be an expression constructed from arithmetic operations, Python 3 built-in functions, and fields already included in the Customer Profile.
#*To access the built-in functions, press the '''SHIFT+@''' shortcut.
#Configure the desired field parameters, then click '''Save Schema''' (at the bottom of the window).

To add data using a CSV file:
[[File:AppendWindow.png|right|thumb|Select CSV file to append]]

#On the '''Settings''' menu '''Customer Profile''' tab, click '''Upload Data'''. The '''Append Data''' pop-up window opens.
#Select the desired CSV file. It must comply with the schema for the Customer Profile.
#:If you append a CSV file containing more columns than appear in the original schema, the extra columns are automatically discarded.
|Status=No
}}
}}

@@ Line 18: / Line 18: @@
 #Click the '''Settings''' gear icon [[File:GPMsettingsGear.png|50px|link=https://all.docs.genesys.com/File:GPMsettingsGear.png]], located on the right side of the top menu bar, to open the '''Settings''' menu (appears on the left side of the window).
 #Click the''' Customer Profile''' tab to open the Customer Profile window.
 All of the columns in your schema are listed and include the following information:
 *'''Label''' and '''Type''' - The ''Label'' is the name of the column in the Customer Profile and the ''Type'' is the datatype for that field.

@@ Line 5: / Line 5: @@
 |Context=View the fields, datatypes, anonymization status and other aspects of the Customer schema.
 |ComingSoon=No
-|Platform=GenesysEngage-onpremises
+|Platform=GenesysEngage-cloud
 |Section={{Section
 |alignment=Vertical

@@ Line 5: / Line 5: @@
 |Context=View the fields, datatypes, anonymization status and other aspects of the Customer schema.
 |ComingSoon=No
-|Platform=PureEngage
+|Platform=GenesysEngage-onpremises
 |Section={{Section
 |alignment=Vertical

@@ Line 23: / Line 23: @@
 '''NOTE:''' Making changes on this page to a schema uploaded using Data Loader will cause a mismatch and prevent any subsequent updates using Data Loader.
 *'''Label''' and '''Type''' - The ''Label'' is the name of the column in the Customer Profile and the ''Type'' is the datatype for that field.
 *The field specified as the '''ID Field''' field is marked with a dot in the radio button for that row.
-*'''Visible''' and '''Indexed''' - ''Visible'' fields appear in the display on the Customers tab (accessed from the top navigation bar). ''Indexing'' speeds access to values in that field. You can have up to 20 indexed fields.
+*'''Visible'''  - ''Visible'' fields appear in the display on the '''Customers''' tab (accessed from the top navigation bar).
 *'''Cardinality''' - The number of unique values that occur in that column. If there are more than 1000, this field shows the value as '''1000+'''. Click the cardinality value to open a pop-up window that displays the first 1000 unique values that occur in the field.
 *'''Expression''' -  If you created a custom field using an expression, the expression you used is shown in this column.

@@ Line 1: / Line 1: @@
 {{Article
 |Standalone=No
-|DisplayName=Import and manage Customer Profile data
+|DisplayName=View the Customer Profile schema
-|TocName=Import and manage Customer Profile data
+|TocName=View the Customer Profile schema
-|Context=Use the sections and options in the Data Loader Application object to configure the Customer Profile schema and to import customer-related data that you can then use to create Predictors. For upload, you must gather the desired data into a CSV file having with a consistent schema. After import, you can append data or update the data.
+|Context=View the fields, datatypes, anonymization status and other aspects of the Customer schema.
 |ComingSoon=No
 |Platform=PureEngage
@@ Line 11: / Line 11: @@
 |Status=No
 }}{{Section
-|sectionHeading=Create a Customer Profile
+|sectionHeading=View the schema
-|anchor=newCustProfile
+|anchor=viewCustProfSchema
 |alignment=Vertical
-|structuredtext=[[File:newCustProf.png|left|thumb|Select CSV file to upload data]]
+|structuredtext=After Data Loader uploads the Customer Profile, you can use the GPR web application to view the schema.
-#Click the '''Settings''' gear icon [[File:GPMsettingsGear.png|50px]], located on the right side of the top menu bar, to open the '''Settings''' menu (appears on the left side of the window).
+#Click the '''Settings''' gear icon [[File:GPMsettingsGear.png|50px|link=https://all.docs.genesys.com/File:GPMsettingsGear.png]], located on the right side of the top menu bar, to open the '''Settings''' menu (appears on the left side of the window).
 #Click the''' Customer Profile''' tab to open the Customer Profile window.
-#GPR automatically identifies the correct field separator in your CSV file.
+All of the columns in your schema are listed and include the following information:
-*If you try to upload a file that contains more than 100 columns, GPR generates an error message. Cancel out of the upload procedure, edit your CSV file to reduce the number of columns, and then repeat the upload procedure.
+'''NOTE:''' Making changes on this page to a schema uploaded using Data Loader will cause a mismatch and prevent any subsequent updates using Data Loader.
-*'''Label''' and '''Type''' - The ''Label'' is the name of the column in the Customer Profile and the ''Type'' is the datatype for that field. You can adjust the datatype, if necessary.
+*'''Label''' and '''Type''' - The ''Label'' is the name of the column in the Customer Profile and the ''Type'' is the datatype for that field.
 *The field specified as the '''ID Field''' field is marked with a dot in the radio button for that row.
 *'''Visible''' and '''Indexed''' - ''Visible'' fields appear in the display on the Customers tab (accessed from the top navigation bar). ''Indexing'' speeds access to values in that field. You can have up to 20 indexed fields.
 *'''Cardinality''' - The number of unique values that occur in that column. If there are more than 1000, this field shows the value as '''1000+'''. Click the cardinality value to open a pop-up window that displays the first 1000 unique values that occur in the field.
-*'''Expression''' -  If you created a custom field (as described in {{Link-SomewhereInThisManual|topic=cfgCustomers#appendCustProf|anchor=top|display text=Append Data to the Customer Profile}}) the expression you used is indicated in this column.
+*'''Expression''' -  If you created a custom field using an expression, the expression you used is shown in this column.
 You can sort the table by clicking any column header.
 |Status=No
 }}{{Section
-|sectionHeading=Add Data to the Customer Profile
+|sectionHeading=Update Profile data
 |anchor=appendCustProf
 |alignment=Vertical
-|structuredtext=You can add data to the Customer Profile in either of two ways: by adding single fields, or by uploading additional CSV files. You can also create a custom field that is a expression built from existing Customer Profile fields.
+|structuredtext='''NOTE:''' Although the GPR application presents buttons labeled '''Upload Data''' and '''Add New Field''', this functionality is deprecated. Changes to the data made in the GPR web application cause a mismatch between the schema configuration in the Data Loader <tt>Application</tt> object and the data presented in the GPR web application.
-To add single fields:
+If you need to ''change'' the schema for the Customer Profile, use the following procedure:
-#Scroll to the bottom of the list of Customer Profile fields and click '''Add New Field'''. If you click in the text box, any fields you previously removed are listed. You can select them to be added back into the Customer Profile.
+'''NOTE:''' Execute this procedure while the Predictive Routing is turned off or when the inbound call volume through GPR is low, to reduce impact on the scoring results.
-To add data using a CSV file:
+#Open the '''[dataset-customers]''' section in the Data Loader <tt>Application</tt> object from GAX or any other Genesys configuration manager application.
-[[File:AppendWindow.png|right|thumb|Select CSV file to append]]
+#Set the '''upload-dataset''' option value to <tt>false</tt>.
-#On the '''Settings''' menu '''Customer Profile''' tab, click '''Upload Data'''. The '''Append Data''' pop-up window opens.
+After Data Loader uploads the new Customer Profile, you can check the schema from the GPR web application.
 |FAQHeading=How do I add data to the Customer Profile?
 |Status=No
 }}
 }}

@@ Line 9: / Line 9: @@
 |sectionHeading=Create a Customer Profile
 |FAQHeading=How do I upload customer data from a CSV file?
-|Type=Unstructured
+|Standalone=No
 |anchor=newCustProfile
-|freetext=[[File:newCustProf.png|left|thumb|Select CSV file to upload data]]
+|structuredtext=[[File:newCustProf.png|left|thumb|Select CSV file to upload data]]
 #Click the '''Settings''' gear icon [[File:GPMsettingsGear.png|50px]], located on the right side of the top menu bar, to open the '''Settings''' menu (appears on the left side of the window).
@@ Line 23: / Line 25: @@
 }}{{Section
 |sectionHeading=Verify the Schema
-|Type=Unstructured
+|Standalone=No
 |anchor=verifyCustProf
-|freetext=At this stage, before the data is uploaded, review and configure your Customer Profile.
+|structuredtext=At this stage, before the data is uploaded, review and configure your Customer Profile.
 [[File:CustProfSetID.png|left|thumb|Verify Customer Profile Schema and Set ID]]
@@ Line 43: / Line 47: @@
 }}{{Section
 |sectionHeading=View The Customer Profile Schema
-|Type=Unstructured
+|Standalone=No
 |anchor=viewCustProfSchema
-|freetext=After you create the Customer Profile, the Customer Profile schema appears. It shows all of the columns in your schema and includes the following information:
+|structuredtext=After you create the Customer Profile, the Customer Profile schema appears. It shows all of the columns in your schema and includes the following information:
 *'''Label''' and '''Type''' - The ''Label'' is the name of the column in the Customer Profile and the ''Type'' is the datatype for that field. You can adjust the datatype, if necessary.
@@ Line 58: / Line 64: @@
 |sectionHeading=Add Data to the Customer Profile
 |FAQHeading=How do I add data to the Customer Profile?
-|Type=Unstructured
+|Standalone=No
 |anchor=appendCustProf
-|freetext=You can add data to the Customer Profile in either of two ways, by adding single fields, or by uploading additional CSV files. You can also create a custom field that is a expression built from existing Customer Profile fields.
+|structuredtext=You can add data to the Customer Profile in either of two ways, by adding single fields, or by uploading additional CSV files. You can also create a custom field that is a expression built from existing Customer Profile fields.
 To add single fields:

PE-GPR/9.0.0/Help/cfgCustomers - Revision history

Vivian: Published

WikiSysop: Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Vivian: Published

Vivian: Published

Vivian: Published

WikiSysop at 13:47, January 17, 2020

Vivian: Published

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"