Enhancing Octeth's Suppression List Table: Implementing Insertion Date for Improved Email Campaign Analysis

Enhancing Octeth's Suppression List Table: Implementing Insertion Date for Improved Email Campaign Analysis

Enhancing Octeth's Suppression List Table: Implementing Insertion Date for Improved Email Campaign Analysis

Purpose of Customization

The suppression list table in Octeth is a crucial component that maintains the list of email addresses which have been detected as hard bounced (invalid), spam complaint, and unsubscribed.

These email addresses are always filtered from outgoing email campaigns to protect the sender's delivery reputation.

However, the current structure of the suppression list table only stores email addresses, without any information about when these addresses were added to the list.

By customizing the table to include an "insertion date", you can gain insights into the timeline of suppression, which can be valuable for analyzing trends, troubleshooting issues, and improving your email campaigns.

Who Should Implement This

This customization should be implemented by developers and system administrators who are responsible for managing the Octeth MySQL database server.

How to Implement

To add the insertion date to the suppression list table, you need to execute the following SQL query on the Octeth MySQL database server:

ALTER TABLE `oempro_suppression_list`
ADD COLUMN `InsertionDate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN `InsertionYear` INT AS (YEAR(`InsertionDate`)) STORED,
ADD COLUMN `InsertionMonth` INT AS (MONTH(`InsertionDate`)) STORED,
ADD COLUMN `InsertionDay` INT AS (DAY(`InsertionDate`)) STORED,
ADD INDEX `IDX_INSERTION_DATE` (`InsertionDate`),
ADD INDEX `IDX_INSERTION_YEAR` (`InsertionYear`),
ADD INDEX `IDX_INSERTION_MONTH` (`InsertionMonth`),
ADD INDEX `IDX_INSERTION_DAY` (`InsertionDay`);

This query will add a new column, InsertionDate, to the oempro_suppression_list table. This column will automatically record the current timestamp whenever a new email address is added to the suppression list.

Additionally, the query will create three stored columns (InsertionYear, InsertionMonth, InsertionDay) that extract the year, month, and day from the InsertionDate, respectively.

These columns can be used for more granular analysis of the suppression list.

Finally, the query will add indexes on these four columns to optimize the performance of queries that filter or sort by these dates.

⚠️
WARNING! Please note that you should back up your database before making any changes to its structure. If you encounter any issues during this process, please contact your database administrator or seek professional help.
💠
image

Homepage Customer Area Community Portal Contact Us

Footer Social Icons

©Copyright Octeth, Inc. All rights reserved.