Delete SimpleMH Clicks and Opens

Introduction

GreenArrow provides a command to delete old Engine clicks and opens from the clickthrough_clicks table.

Command Invocation

To delete entries in clickthrough_clicks that are older than 90 days, run the following command:

greenarrow engine_clicks_opens_delete --older-than-days=90 --confirm

We recommend that any server that uses SimpleMH click and open tracking put this into a crontab for regular invocation (daily or monthly).

Caveats

• This will not free disk space immediately, but can limit future growth of the table if run regularly.

• This will cause click and open statistics to appear inaccurately in the UI and API for sends which included the deleted clicks and opens.