ByCell

Description: Defines the audience using a custom SQL query.

Use Case: Offers maximum flexibility for creating complex, dynamic segments.

Requirement: This method requires advanced technical expertise and knowledge of the Thalamus database architecture.

How to setup a rule ByCell

1. General Settings

• Applicability type: A dropdown menu to select the method for determining applicability. The example shows ByCell selected.

• Party type: A dropdown menu to select the type of entity the rules will apply to (e.g., Person).

2. General Info

• File Name: A mandatory field for the descriptive name of the file import.

• Entity Type: A mandatory dropdown menu to select the type of entity contained within the file.

3. File to Upload

• Download file template: A button that downloads a template file to ensure the data for upload is correctly formatted.

• Upload file: A component for uploading the data file containing the list of participants.

4. Import Result This section displays read-only information and statistics about the uploaded file.

• File Name / File Size: Displays the name and size of the uploaded file.

• File Status: Shows the current processing status of the file.

• Rows processed / Rows processed successfully / Rows processed with errors / Rows skipped: Displays a running count of the rows processed by the system, broken down by their outcome.

• Download file: A link to download a results file, typically after the process is complete