Page 1 of 1

Linktrack Statistics: Message click rate is zero?

PostPosted: 2:46pm, Wed 02 Jul, 2008
by pinoguin
*Attached is a screenshot from a client of mine with several phplist installations.

All of them have a zero click rate % :?: Is this normal?


edit: file won't attach somehow:
Image

PostPosted: 6:35pm, Wed 02 Jul, 2008
by J_S
this may sound pretty obvious;
but have you got click-tracking enabled?

PostPosted: 1:34am, Thu 03 Jul, 2008
by pinoguin
Hi,

Yes , on both installations.

define('CLICKTRACK',1);

Re: Statistics: Message click rate is zero?

PostPosted: 6:58pm, Wed 16 Sep, 2009
by NoahJenda
I'm having the same problem with the message click statistics showing a click rate of 0.00% for all available messages.

Once I go into the click details for an individual message, the click rates are all calculated as expected.

Is there a fix for this problem yet?

Re: Statistics: Message click rate is zero?

PostPosted: 7:29pm, Wed 16 Sep, 2009
by CS2
Do you have the [USERCLICK] placeholder somewhere in the email?

Re: Statistics: Message click rate is zero?

PostPosted: 8:36pm, Wed 16 Sep, 2009
by NoahJenda
CS2 wrote:Do you have the [USERCLICK] placeholder somewhere in the email?


I have the placeholder [USERTRACK] at the bottom of the message template.

I also have enabled the clicktrack setting in my config.php file:
define('CLICKTRACK',1);

I don't see anything in the docs about the [USERCLICK] placeholder.

Click tracking is working. I get the numbers for the clicks, users and links. It's just the rate that is always shown as 0.00%.

Re: Statistics: Message click rate is zero?

PostPosted: 9:08pm, Wed 16 Sep, 2009
by CS2
I'm sorry, yes, [USERTRACK] is the correct placeholder, not [USERCLICK].

Re: Statistics: Message click rate is zero?

PostPosted: 9:15pm, Wed 16 Sep, 2009
by NoahJenda
My stats look exactly the same as the screen capture in the first post of this thread.

So click tracking is working, but something is going wrong when it calculates the click rate percentage.

Re: Statistics: Message click rate is zero?

PostPosted: 10:05pm, Wed 16 Sep, 2009
by CS2
This is a shot in the dark, but try changing line 49 of mclicks.php from:
Code: Select all
    $perc = sprintf('%0.2f',($row['numclicks'] / $row['total'] * 100));
to
Code: Select all
    $perc = sprintf('%0.2f',($row['totalclicks'] / $row['users'] * 100));


Make a copy of mclicks.php first.

wrong rate for statistics

PostPosted: 6:54am, Wed 26 May, 2010
by steph@ne
in ?page=mclicks , I have always a rate set to 0.00%
looking in the code, the line 49 is as follows:

$perc = sprintf('%0.2f',($row['numclicks'] / $row['total'] * 100));

but the select is

$req = Sql_Query(sprintf('select distinct messageid, subject, sum(clicked) as totalclicks, count(distinct userid) as users, count(distinct linkid) as linkcount from %s as linktrack, %s as message
where clicked and linktrack.messageid = message.id %s group by messageid order by entered desc limit 50',

and it seems that numclicks and total columns are not set

Re: wrong rate for statistics

PostPosted: 3:43am, Tue 01 Jun, 2010
by H2B2
Could you mention which phpList version you are using?

Re: wrong rate for statistics

PostPosted: 5:09am, Tue 01 Jun, 2010
by steph@ne
sorry.
version 2.10.12

Re: Statistics: Message click rate is zero?

PostPosted: 6:58pm, Tue 01 Jun, 2010
by H2B2
I checked in the online demo and can confirm this issue for v2.10.12. Merged this topic with an older related thread.

I'm not a programmer, and can't help debugging I'm afraid. You might take a look at this post by CS2: viewtopic.php?p=68198#p68198

Apparently no bug report has yet been entered in the bug tracker. Would you mind filing a bug report in http://mantis.phplist.com ? Thx!

EDIT: Filed this mantis report: http://mantis.phplist.com/view.php?id=15501

Re: Linktrack Statistics: Message click rate is zero?

PostPosted: 12:51am, Wed 04 Aug, 2010
by unbellver
You can use this one to get average clicks by user (c/u)

$perc = sprintf('%0.2f',($row['totalclicks'] / $row['users'] ));

$ls->addColumn($row['messageid'].' '.substr($row['subject'],0,50),$GLOBALS['I18N']->get('rate'),$perc.' c/u');

Re: Linktrack Statistics: Message click rate is zero?

PostPosted: 9:14pm, Sun 22 Aug, 2010
by H2B2
Thx! Added your suggestion to the mantis entry. :)

Haven't tested your code though, as I'm not using clicktracking on my system.