Getting started

What’s New

Roadmap

Octeth Training Program

Installation & Setup

Requirements

Architecture

Server Setup

Oempro Installation

Community Edition Install

SSL Certificates

Version Upgrade

Troubleshooting

Video Tutorials

Video Tutorials

Administration

Quick Walkthrough

Security

Sub Admin Accounts

Settings

Delivery Servers

Global Segments

Global Custom Fields

Bounce Processing

Spam Complaints

Suppression List

Plug-Ins

Delivery Report

User Management

Maintenance

Audience Management

Introduction

Subscriber Lists

Custom Fields

Segments

Subscribers

Webhooks

Website Event Tracking

Email Marketing

Introduction

Auto Responders

Email Campaigns

Sender Domain Man.

Journeys (Automation)

Bounce Processing

Email Personalization

FBL Processing

Email Builder Integrations

Email Deliverability

Sender Domain Management

Plug-Ins & Add-Ons

AI Plug-In

RSS Plug-In

Bounce Catcher Add-On

Link Proxy Add-On

Developers

Introduction

Single Sign On

API

Plug-In Development

Database

Advanced

Reverse Proxy

Cookbook

Help

Troubleshooting

Contact Us

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.

On this page

• Enhancing Octeth's Suppression List Table: Implementing Insertion Date for Improved Email Campaign Analysis
• Purpose of Customization
• Who Should Implement This
• How to Implement