1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
<?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
namespace Piwik\Plugins\Goals\DataTable\Filter;
use Piwik\Plugins\Goals\Archiver as GoalsArchiver;
use Piwik\Archive;
use Piwik\DataTable\BaseFilter;
use Piwik\DataTable;
use Piwik\Metrics;
use Piwik\Piwik;
use Piwik\Site;
class CalculateConversionPageRate extends BaseFilter
{
/**
* Constructor.
*
* @param DataTable $table The table to eventually filter.
*/
public function __construct($table)
{
parent::__construct($table);
}
/**
* @param DataTable $table
*/
public function filter($table)
{
// Find all goal ids used in the table and store in an array
$goals = [];
foreach ($table->getRowsWithoutSummaryRow() as $row) {
if (isset($row[Metrics::INDEX_GOALS])) {
foreach ($row[Metrics::INDEX_GOALS] as $goalIdString => $metrics) {
$goals[$goalIdString] = $goalIdString;
}
}
}
// Get the total top-level conversions for the goals in the table
$goalTotals = $this->getGoalTotalConversions($table, $goals);
if (count($goalTotals) === 0) {
return;
}
// Walk the rows and populate the nb_conversions_page_rate with nb_conversions_page_uniq / $goalTotals[goal id]
foreach ($table->getRowsWithoutSummaryRow() as &$row) {
if (isset($row[Metrics::INDEX_GOALS])) {
foreach ($row[Metrics::INDEX_GOALS] as $goalIdString => $metrics) {
if (isset($row[Metrics::INDEX_GOALS][$goalIdString][Metrics::INDEX_GOAL_NB_CONVERSIONS_PAGE_UNIQ])) {
$rate = Piwik::getQuotientSafe(
$row[Metrics::INDEX_GOALS][$goalIdString][Metrics::INDEX_GOAL_NB_CONVERSIONS_PAGE_UNIQ],
$goalTotals[$goalIdString],
3
);
// Prevent page rates over 100% which can happen when there are subpages
if ($rate > 1) {
$rate = 1;
}
$row[Metrics::INDEX_GOALS][$goalIdString][Metrics::INDEX_GOAL_NB_CONVERSIONS_PAGE_RATE] = $rate;
}
}
}
}
}
/**
* Get the conversions total for each goal in the top level datatable
*
* @param array $goalIds
* @return array
*/
private function getGoalTotalConversions(DataTable $table, array $goalIds): array
{
$goalTotals = [];
if (empty($goalIds)) {
return $goalTotals;
}
/** @var Site $site */
$site = $table->getMetadata('site');
if (empty($site)) {
return $goalTotals;
}
$idSite = $site->getId();
$period = $table->getMetadata('period');
$periodName = $period->getLabel();
$date = $period->getDateStart()->toString();
$date = ($periodName === 'range' ? $date . ',' . $period->getDateEnd()->toString() : $date);
$segment = $table->getMetadata('segment');
$archive = Archive::build($idSite, $periodName, $date, $segment);
$names = [];
foreach ($goalIds as $idGoal => $g) {
$names[$idGoal] = GoalsArchiver::getRecordName('nb_conversions', $idGoal);
}
$sum = $archive->getNumeric($names);
foreach ($names as $idGoal => $name) {
if (is_array($sum) && array_key_exists($name, $sum) && is_numeric($sum[$name])) {
$goalTotals[$idGoal] = $sum[$name];
} elseif (is_numeric($sum)) {
$goalTotals[$idGoal] = $sum;
}
}
return $goalTotals;
}
}
|
