On the Delivery Statistic, the Open mails stats displays the total number of email recipient who read your mailings, when you click the Open mails link it will show the specific domains who have read the mail.
At first when I was making my test mailing, open mail stats are displaying the correct counts of who openned my mails,
when you click the Open mails link it willDelivery Statistics:
Open Mails: 7
list the domains and how many who have read my mailings are shown correctly,
then when I have finished my test, and have imported my mailing list, adding a new field which is the "domain" field, alphanumerical and length of 100. I noticed my open rate mail stats on my previous mailings has change to this:Opened Mails:
Open rate over time
Domain Opened mails
----------------------------------------------------
fastmail.fm 1
test-account.com 1
yahoo.com 2
gmail.com 1
aol.com 1
hotmail.com 1
----------------------------------------------------
total 7
fastmail.fm being the first mailing I have opened and have logged on the open rate. And adding the other domain to fastmail.fmOpened Mails:
Open rate over time
Domain Opened mails
----------------------------------------------------
fastmail.fm 7
----------------------------------------------------
total 7
So after scratching my head so many times, on what wrong steps I have done, I have recalled adding some new fields, and the domain field is included on that field. Since open rate mail are not displaying the domains that have read my mailings, I concentrated my search to domains, on the code and the database.
and found this:
I have decide to rename the domain field to webhostdomain, rather than changing the word "domain" on the code.mysql> desc customer_1_tbl;
+---------------+--------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------------------+----------------+
| customer_id | int(11) | NO | PRI | NULL | auto_increment |
| email | varchar(100) | YES | MUL | NULL | |
| gender | int(11) | NO | | 0 | |
| mailtype | int(11) | YES | | 0 | |
| firstname | varchar(100) | YES | | NULL | |
| lastname | varchar(100) | YES | | NULL | |
| creation_date | timestamp | NO | | 0000-00-00 00:00:00 | |
| change_date | timestamp | NO | | CURRENT_TIMESTAMP | |
| title | varchar(100) | YES | | NULL | |
| datasource_id | int(11) | NO | | 0 | |
| domain | varchar(100) | YES | | NULL | |
| city | varchar(100) | YES | | NULL | |
| country | varchar(100) | YES | | NULL | |
| startdate | date | YES | | NULL | |
| enddate | date | YES | | NULL | |
| plan | varchar(100) | YES | | NULL | |
| plantype | varchar(100) | YES | | NULL | |
+---------------+--------------+------+-----+---------------------+----------------+
17 rows in set (0.00 sec)
mysql> alter table customer_1_tbl change domain webhostdomain varchar(100);
Query OK, 1059 rows affected (0.23 sec)
Records: 1059 Duplicates: 0 Warnings: 0
after the alter table, I checked again the open rate stats, and It was back to normal.mysql> desc customer_1_tbl;
+---------------+--------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------------------+----------------+
| customer_id | int(11) | NO | PRI | NULL | auto_increment |
| email | varchar(100) | YES | MUL | NULL | |
| gender | int(11) | NO | | 0 | |
| mailtype | int(11) | YES | | 0 | |
| firstname | varchar(100) | YES | | NULL | |
| lastname | varchar(100) | YES | | NULL | |
| creation_date | timestamp | NO | | 0000-00-00 00:00:00 | |
| change_date | timestamp | NO | | CURRENT_TIMESTAMP | |
| title | varchar(100) | YES | | NULL | |
| datasource_id | int(11) | NO | | 0 | |
| webhostdomain | varchar(100) | YES | | NULL | |
| city | varchar(100) | YES | | NULL | |
| country | varchar(100) | YES | | NULL | |
| startdate | date | YES | | NULL | |
| enddate | date | YES | | NULL | |
| plan | varchar(100) | YES | | NULL | |
| plantype | varchar(100) | YES | | NULL | |
+---------------+--------------+------+-----+---------------------+----------------+
17 rows in set (0.00 sec)
Is this a bug?Opened Mails:
Open rate over time
Domain Opened mails
----------------------------------------------------
fastmail.fm 1
test-account.com 1
yahoo.com 2
gmail.com 1
aol.com 1
hotmail.com 1
----------------------------------------------------
total 7
maybe you can change the domain keyword on code to openemm-domain? So that other user can add a "domain" name field on the db, even if they dont read this post.
I hope this post can help other users if they encounter this problem.
