Import User Data

OVERVIEW

You can import the user data who visits your website or engage with your campaigns. Simply convert their existing data into a CSV file format and upload it. You need to follow certain guidelines to avoid any kind of discrepancies.

Understand User Profile Data

The user profile data comprises all the information regarding your users such as their names, date of birth, email id, etc. The attributes that are already defined by NotifyVisitors are system attributes such as the last_name, or email of the users. Another set of attributes is custom attributes. You can add the custom attributes(age, score, membership Id, and place) while uploading the CSV file.

📘

Your CSV file is a mix of system and custom attributes.

While uploading a CSV file, you need to define the system attributes and custom attributes. Also, define their corresponding data types.

Prerequisites of CSV file

Your upload will only be successful if your file complies with the CSV standards.

  • The size of the file should never exceed 50 MB.

  • Your file must have a unique user id for every user.

  • The attribute values shall be of the following data types :Boolean, integer, string or array.

Steps to upload CSV file in NotifyVisitors

How To Access

Navigate to the Settings> Upload section in the panel.

13791379

Uploading CSV file

Click on the “Upload user data” to upload the CSV file.

13851385

Upload the file that you have created manually.

13851385

Once you upload the file, define its variables :

  • CSV column : These are the attributes that you created in the excel and uploaded as a CSV file.

  • Data type: Select the data type for the attributes that you have uploaded, whether they belong to string,
    integer, Boolean or array category.

  • Operation : You can use the following operations on profile properties :

    a. set : You can use this operation to replace the current value in any user attribute.

    b. delete : This operation will be used to delete any user property, for example you can remove the
    property, email and all the values in it.

    c. increment : The following operation will enable you to increase the integer property.
    For e.g. Lifetime Value.

    d. decrement : Decrement will allow you to decrease the value of integer property.

    e. add : Add will help you to add multiple values in the array property, for example, if you will pass
    "abcd,qwer" in excel, both these values will be merged to the existing values of the user.

    f. remove : This operation will remove the multiple values in the array property

  • Attributes : Map the CSV columns with the attributes that are already configured in the system. You can
    create a custom attribute as well from here, if it is not present in the list. You can scroll down from the
    drop- down menu and create a custom attribute and save it.

13861386

Once you define all the attributes and their values, click on the next button.

Status of the CSV file

You can check the validation of the uploaded file through the following statuses:

  • Error : Error status signifies the fault in the file that you have uploaded. If you have left any row empty while creating the file, it will show the error status.

  • Success: The following status shows that your file has been successfully uploaded.

  • Scheduled : The scheduled status signifies that the file you uploaded is still in process of being uploaded.

13851385

Validate Uploaded Users

You can view the uploaded users and their attributes by navigating to the SEGMENTS > USERS LIST section.

13681368