Installation & Setup
Plug-Ins & Add-Ons
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 (
InsertionDay) that extract the year, month, and day from the
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.