Remove Entities From Campaign Operations
The remove_entities_from_campaign_operations table contains data about uploads that removed entities from a campaign in the organization.
This table can be used to determine which remove entities uploads exist, as well as metadata about the upload such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| created_by_id | The numerical identifier of the user who created this upload. Relates to the id column in the users table. |
INT8 | No |
| status | The status of this import. One of received, in_progress, or done. |
VARCHAR | No |
| total_sent | The total number of entities in the CSV file. | INT4 | No |
| total_processed | The total number of entities in the CSV file that were removed from the campaign. | INT4 | No |
| total_not_found | The total number of entities in the CSV file that were not found in the campaign. | INT4 | No |
| completed_at | The UTC timestamp when this upload was completed. | TIMESTAMP | Yes |
| not_found_ids | A JSON representation of the IDs of entities not found in the remove operation. | JSONB | No |
| entities | A JSON representation of the IDs of entities found and removed in the operation. | JSONB | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| removal_counts | A JSON representation of the counts of entities found and removed in the operation. | JSONB | Yes |