Within the platform you can access the Create Dataset Schema wizard to upload a CSV file and determine various field types to create a Customer Attributes dataset schema, after which you can then upload a full file to create the dataset.
With AgilOne integration, you can skip the process of defining field types for Customer Attributes datasets by using its predefined schema and uploading that CSV file to the platform via SFTP.
| Header | Field Type |
|---|---|
customer_id | String |
email | String |
primary_organization | String |
primary_store | String |
primary_brand | String |
closest_store | String |
email_status | String |
do_not_email | String |
total_revenue_group | String |
last_12_months_group | String |
frequency_group | String |
recency_days_group | String |
average_discount_rate | String |
customer_age | Number |
customer_birth_month | Number |
customer_gender | String |
likelihood_to_buy | String |
likelihood_to_engage | String |
product_cluster | String |
likelihood_to_convert | String |
behavior_cluster | String |
execution_id | Number |
Setting Up the Integration
Follow these steps to establish the integration with AgilOne.
- Click the settings cog and then select Integration.
- Click the AgilOne tab on the Integration page.
- Click INTEGRATE AGILONE NOW.
- Name the AgilOne dataset and then click INTEGRATE.
Now that you have integrated AgilOne, you're ready to upload the dataset schema via SFTP.
Setting Up the SFTP Upload
- If you have not yet created any SFTP user credentials for the account or want to create user credentials specifically for this purpose, click CONFIGURE YOUR SFTP CREDENTIALS on the AgilOne tab.
- On the Sites tab is a table of existing SFTP users, if any have been created, as well as the CREATE SFTP USER button. Click it to create a new set of SFTP user credentials via the SFTP User Details modal.
- Configure your SFTP client with the following information from the Sites tab:
- Host —
sftp://sftp.monetate.net - Port —
22 - Protocol —
SFTP
- Host —
- Create the CSV file containing the AgilOne schema, and then upload it to the
/datasetsdirectory using your SFTP client.
Viewing the New Dataset
Once the upload is complete, you can view the newly created Customer Attributes dataset by following these steps.
- Click DATASETS in the top navigation bar, and then click Customer Attributes from the left-hand category listing.
- Scroll as necessary to find on the Customer Attributes list page the dataset you created, and then click the dataset's name to view its details page.
The Attributes tab of the dataset details page shows all the headers present in the CSV file you uploaded.
The Upload History tab shows the filename that was the dataset's initial upload sent via SFTP.
If the platform encountered an error during the upload, then a warning message appears in the entry for the dataset on the Customer Attributes list page. Click that message to view the File Upload Error modal that contains the specific error(s) encountered.
See Customer Attributes Dataset Details Page to better understand the information you can find on and what actions you can take from the dataset's details page.