▪️Imported Segments

Overview

Imported segments are used for two purposes:

• You have a custom list of players that you build outside of Smartico and you want to make a segment from them

• You want o update some properties in Smartico side with data that is not available in the normal integration flow between your platform and Smartico.

How to Import a Segment

To create an imported segment navigate to the Segments section, click on the "Create" button, and select the "Import Segment" option:

Once clicked It will open a window where you'll have to add a name for the segment and upload the already prepared CSV file. Please note that there is a special formatting required for the data in order for the import to be successful. You can also download a template of the CSV file.

Depending on a Label setting in the CSV file, you must have one or two mandatory columns - the user_ext_id and core_sm_brand_id. In most cases the only mandatory column is user_ext_id.

user_ext_id - is the user's external ID (without the brand indication in the beginning):

core_sm_brand_id - is the brand ID for the brand of which the given user belongs. You can find this number in the user profile, the number standing before the user's external ID. In the example case is 31.

Note that core_sm_brand_id column is required in case you have multiple brand and non-unique user_ext_id across them. For example you have user with id 55 in brand A and user with same ID in brand B. In order for Smartico to understand which exactly user should be imported, you need to specify the ID of brand

Once prepared the CSV file should look like this:

After adding the file, a quick check will identify any errors in the uploaded user data. Once the check is completed, you can proceed with the import by clicking '"Continue".

Once you click "Continue", the file validation process will begin. During this phase, you can decide whether to proceed with the import or stop the process.

If you choose to proceed with importing the CSV file, the import process will begin, and the segment will be created. However, it will remain in the 'Importing' status until all users are successfully imported.

You can check the Import status inside the segment as well.

After the import is complete, you can view the successfully imported users under the 'Imported Users' tab. Any users who do not match existing usernames in the system will also be displayed under the 'Imported Users' tab.

Updating other properties of user while importing segment

You can add multiple columns in your CSV with names that correspond to name of properties in Smartico system. For example you have found that some deposits where not sent to Smartico and you want to update properties acc_last_deposit_date and acc_last_deposit_amount. You will need to prepare a file with additional columns exactly with these names and values for users that you want to update. For the format of values, please see table below.

CSV Import – Guidelines & Rules

When creating a CSV Segment, please follow these important rules and behaviors to ensure a successful upload:

✅ File Requirements

• The file must be in plain text CSV format (comma-separated).

• Do not use quotation marks in any fields.

• Each property in the file must match a supported data type (see below).

📊 Supported Data Types

Supported date formats:

⚙️ Upload & Validation Process

1. Initial Validation:

   • The system checks only the first 20 users in the CSV file.

   • If there’s an incorrect value in these rows, an error will specify the problematic column.

1. Full Import:

• If invalid values are found after the first 20 users, those specific rows will be skipped and there is a message with the number of the skipped users.

🚫 Unsupported Properties

• Some user properties cannot be updated via CSV import.

• These will appear greyed out in the UI and will be skipped automatically during the upload.