[plugin] Display message open statistics

[pdbrett]

For those who want to replace the current plugins with something more useful...

I have developed a plugin that gives open & bounce statistics for a message. Also shows you exactly who has viewed the message (and who hasn't...as far as it's possible to tell). It only works for HTML messages - it's not possible to know who opened text messages.

To enable open statistics you need to put the placeholder [USERTRACK] somewhere in your HTML message. A good idea is to put it in your default message footer via the configure page. See this topic.

Installation
Download the plugin as a zip file here.

To install, delete all the current contents of lists/admin/plugins. Unzip the plugins.zip file, being careful to keep the directory structure intact & copy all the files to lists/admin/plugins. That's it.

You will need to know the message id for the message you want info on. You can get this from the "messages" page - click "view" on the message you're interested in. If you're feeling brave you can download a modified version of lists/admin/messages.php here in zip form. This displays a link to the correct statistics directly next to the message.

Hope this is useful. If anyone improves it, please post the improvements here. Hopefully it will be superseded by a native stats module sometime in the future.

[pepesoto]

Hi Paul.

I have the Phplist ver. 2.6.5 ¿It will work for me...?

Cheers!
Pepe

[pdbrett]

I have the Phplist ver. 2.6.5 ¿It will work for me...?

Yes it should work in that version - I'm not sure when the [USERTRACK] functionality became available. If you have the file ut.php in the lists directory then your version will support this.

I forgot to mention that to get open statistics you have to embed the placeholder [USERTRACK] somewhere in your HTML message (probably put it in your default footer using the configure page). I have now updated the original topic to mention this.

[rdbartz]

Paul,

Thank you for a very helpful contribution. While it doesn't give total openings (some plain text and since some people disconnect from the internet before they read your HTML mail), it still is very nice to have these stats.

One minor change to your code in admin/messages.php enables the admin to go directly to a message's stats page, which I found more convenient than stepping through the main statistics page:

In the modified messages.php from messages.zip (available in this thread), change line 159-160:

# add following line to go directly to stats page 26/03/04
PageLink2("main","Stats","&pi=statistics&id=".$msg["id"]),

to read:

# add following line to go directly to stats page 26/03/04
PageLink2("openstats","Stats","&pi=statistics&id=".$msg["id"]),

From then on, a click on "stats" on any message in the messages list will open the stats page for that message without having to go through the main statistic page.

Thanks again for a very nice plugin that ought to go in the main distribution.

[wilfy]

hi guys

followed inststuctions to a tee... but i get "openstats -> Sorry not Implemented yet" when i click on the stats open in the 'messages' are. have added [usertrack] etc and the tracking seems to work but it would be nice to see who is opening them big brother and all that malarky!

cheers

[plmerlin]

Hi all,

I don't have a plugin menu on my phplist. I remember seen it on an older version but not the one I'm running (2.8.11)

Is there something to set "on"?

Thank you
Pierre

[abaykamau]

Received this after installing the plugin and modifying the code. Is there something additional that should be done?

Additionally, when modifying the code, you lose the tabs in the "message" option.

Finally, the plugin link does not appear to be present in v2.9.3, any thoughts of where to edit the code to show the link once again? Thanks.

[panthergrl]

Hi,

I know this is a little late, but hopefully it helps someone. If you want to see the plugins, do this:

1. Open up config/config.php
2. Go to LINE 417 :

# define("PLUGIN_ROOTDIR","plugins");

and uncomment the line (remove the #).

3. Save the file and replace it with the one on your server.

When you go to your Admin main page, you should now see links to your plugins.

I hope this helps.

[plmerlin]

Thank you, it works....

Pierre

[panthergrl]

Paul, thanks for this post. I now have a click through tracker.

You're welcome Pierre.

---Natasha

[mdj1]

Hi There,

Im getting the following error when I view the stats.

Database error 1146 Table 'XXXXXXdb.phplist_usermessage' doesn't exist

Whay hasnt this table been created?

[tennr]

The problem with this plugin by default is that is does not use the table prefix's. So if you use a prefix other than the default it will not work... this update pulls the correct prefix from the general config. This is for 2.8.12

--Aaron

[Shortpockets]

I think this mod is great. I was wondering if some one could help me out the PHP code. I am new to php and have not figured everything out yet.

This current mod has the headings of:

Message Id
User Id
Viewed
Email

I would like to add two of my user attributes. I am currently using First Name and Last Name. I would like the table to look like the following:

Message Id
User Id
Viewed
Email
First Name
Last Name


Any help with the coding would be greatly appreciated.
I do have some gmail invites to give to the person that helps with this. Just a little incentive.

[webdizzy]

I installed this plugin as instructed and also am using the modified messages.php file. The "stats" link shows up on the messages page, but when I click on it I get:

"openstats -> Sorry this page was not found in the plugin".

The openstats.php file is in the defaultplugin folder of my plugins folder.

Any ideas on what the problem is?

Thanks!

[imz]

hi ppl

followed inststuctions... but i get "openstats -> Sorry not Implemented yet" wen i click on the stats link in messages view....

ny suggestions please..