Linktrack Statistics: Message click rate is zero?

Discuss, research, share, find, and solve bugs

Linktrack Statistics: Message click rate is zero?

Postby pinoguin » 2:46pm, Wed 02 Jul, 2008

*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
pinoguin
PL Nut
 
Posts: 44
Joined: 4:01pm, Sat 26 Jan, 2008

Postby J_S » 6:35pm, Wed 02 Jul, 2008

this may sound pretty obvious;
but have you got click-tracking enabled?
J_S
Admin
 
Posts: 674
Joined: 10:18pm, Fri 11 Apr, 2003

Postby pinoguin » 1:34am, Thu 03 Jul, 2008

Hi,

Yes , on both installations.

define('CLICKTRACK',1);
pinoguin
PL Nut
 
Posts: 44
Joined: 4:01pm, Sat 26 Jan, 2008

Re: Statistics: Message click rate is zero?

Postby NoahJenda » 6:58pm, Wed 16 Sep, 2009

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?
NoahJenda
phpLister
 
Posts: 6
Joined: 8:16pm, Sun 09 Aug, 2009

Re: Statistics: Message click rate is zero?

Postby CS2 » 7:29pm, Wed 16 Sep, 2009

Do you have the [USERCLICK] placeholder somewhere in the email?
CS2
PL Master
 
Posts: 216
Joined: 2:20am, Wed 04 Feb, 2009

Re: Statistics: Message click rate is zero?

Postby NoahJenda » 8:36pm, Wed 16 Sep, 2009

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%.
NoahJenda
phpLister
 
Posts: 6
Joined: 8:16pm, Sun 09 Aug, 2009

Re: Statistics: Message click rate is zero?

Postby CS2 » 9:08pm, Wed 16 Sep, 2009

I'm sorry, yes, [USERTRACK] is the correct placeholder, not [USERCLICK].
CS2
PL Master
 
Posts: 216
Joined: 2:20am, Wed 04 Feb, 2009

Re: Statistics: Message click rate is zero?

Postby NoahJenda » 9:15pm, Wed 16 Sep, 2009

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.
NoahJenda
phpLister
 
Posts: 6
Joined: 8:16pm, Sun 09 Aug, 2009

Re: Statistics: Message click rate is zero?

Postby CS2 » 10:05pm, Wed 16 Sep, 2009

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.
CS2
PL Master
 
Posts: 216
Joined: 2:20am, Wed 04 Feb, 2009

wrong rate for statistics

Postby steph@ne » 6:54am, Wed 26 May, 2010

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
steph@ne
PL Nut
 
Posts: 49
Joined: 10:46am, Wed 19 Sep, 2007

Re: wrong rate for statistics

Postby H2B2 » 3:43am, Tue 01 Jun, 2010

Could you mention which phpList version you are using?
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

Re: wrong rate for statistics

Postby steph@ne » 5:09am, Tue 01 Jun, 2010

sorry.
version 2.10.12
steph@ne
PL Nut
 
Posts: 49
Joined: 10:46am, Wed 19 Sep, 2007

Re: Statistics: Message click rate is zero?

Postby H2B2 » 6:58pm, Tue 01 Jun, 2010

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
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006

Re: Linktrack Statistics: Message click rate is zero?

Postby unbellver » 12:51am, Wed 04 Aug, 2010

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');
unbellver
phpLister
 
Posts: 11
Joined: 12:18am, Wed 07 Jul, 2010

Re: Linktrack Statistics: Message click rate is zero?

Postby H2B2 » 9:14pm, Sun 22 Aug, 2010

Thx! Added your suggestion to the mantis entry. :)

Haven't tested your code though, as I'm not using clicktracking on my system.
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006


Return to Bug Discussion

Who is online

Users browsing this forum: No registered users and 5 guests

cron