Author Topic: open rate? (Read 2172 times)

bbc · « **on:** April 20, 2006, 08:04:34 pm »

How do you track open rates?
Don't see anything obvious-
I spoze I could put a pixel in, but that wouldn't track text only ones

Any other solution?

DW · « **Reply #1 on:** April 21, 2006, 12:32:42 am »

Greetings,

I believe it is difficult if not impossible to track text-only emails. If you want to track HTML email there's a custom script available for this and some further discussion and debate. Let's see... a quick search for "img" returned the following relevant posts:

http://listmailpro.com/forum/index.php?topic=7.0
http://listmailpro.com/forum/index.php?topic=237.0

Please let me know if you have any more questions!

Regards

bbc · « **Reply #2 on:** April 21, 2006, 11:12:24 am »

thanks a lot- i'll try this

do you put the FAQs in the help section?, or sticky them in the forum?

bbc · « **Reply #3 on:** April 21, 2006, 11:21:01 am »

About the script in http://listmailpro.com/forum/index.php?topic=7.0

I'm confused- it asks for username, pw, etc. for the track database- but you use the create table sql- so I don't create this db with cpanel, or i do both? you didn't mention creating another db so i got confused

thanks!
B

DW · « **Reply #4 on:** April 21, 2006, 05:12:31 pm »

You don't need to create a new database, but rather a new table in an existing (or new) database.

What you need to do is go into the "DB manager" (PhpMyAdmin) from cPanel, browse to your ListMail database, and run the table creation code as recommended.

Code: [Select]

CREATE TABLE `track` (
`autoid` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`uid` TINYTEXT NOT NULL ,
`msgid` TINYTEXT NOT NULL ,
`stamp` TIMESTAMP NOT NULL

);

Providing you do this in the existing ListMail database you would then configure the script to use the same host, user, pass, and db as set in ListMail's config.php.

Regards

bbc · « **Reply #5 on:** April 23, 2006, 04:30:15 pm »

k thx will try that