Linktrack Statistics: Message click rate is zero?

[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:

[J_S]

this may sound pretty obvious;
but have you got click-tracking enabled?

[pinoguin]

Hi,

Yes , on both installations.

define('CLICKTRACK',1);

[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?

[CS2]

Do you have the [USERCLICK] placeholder somewhere in the email?

[NoahJenda]

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%.

[CS2]

I'm sorry, yes, [USERTRACK] is the correct placeholder, not [USERCLICK].

[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.

[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.

[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

[H2B2]

Could you mention which phpList version you are using?

[steph@ne]

sorry.
version 2.10.12

[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

[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');

[H2B2]

Thx! Added your suggestion to the mantis entry.

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