Email template

Overview

Summary table for email click activity statistics. Statistics grouped in time buckets of 1 hour per link/template combo.

Object name	email_template_click_stats
Table name	psys_email_template_click_stats
Path	/preside-objects/email/email_template_click_stats.cfc

Properties

property name="template" relationship="many-to-one" relatedto="email_template"           uniqueindexes="clickstatlink|1";
property name="hour_start" type="numeric" dbtype="int" required=true indexes="hourstart" uniqueindexes="clickstatlink|2";
property name="link_hash"  type="string"  dbtype="varchar" maxlength=32 required=true    uniqueindexes="clickstatlink|3" indexes="linkhash";
property name="link"       type="string"  dbtype="varchar" maxlength=750  indexes="link";
property name="link_title" type="string"  dbtype="text";
property name="link_body"  type="string"  dbtype="text";

property name="click_count" type="numeric" dbtype="int" required=true default=0;