diff options
author | Stefan Giehl <stefan@matomo.org> | 2021-07-19 18:12:41 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2021-07-19 18:12:41 +0300 |
commit | 385b03640e609da4f8ab0ddbd89efebc5346198a (patch) | |
tree | 260901ec277e2ba51f0c7077810d44ea9722ea57 /plugins | |
parent | 475ea29f69361e8be36940a88ebd4d0f60a6b01f (diff) |
Fix filter in UserCountry.getCountry for Map of Maps (#17779)
* Fix filter in UserCountry.getCountry for Map of Maps
* Adds some tests & fixes other APImethods for multiple period & site request
Diffstat (limited to 'plugins')
19 files changed, 5902 insertions, 24 deletions
diff --git a/plugins/UserCountry/API.php b/plugins/UserCountry/API.php index 2e9c42a135..792a672de9 100644 --- a/plugins/UserCountry/API.php +++ b/plugins/UserCountry/API.php @@ -36,13 +36,7 @@ class API extends \Piwik\Plugin\API { $dataTable = $this->getDataTable(Archiver::COUNTRY_RECORD_NAME, $idSite, $period, $date, $segment); - $dataTables = [$dataTable]; - - if ($dataTable instanceof DataTable\Map) { - $dataTables = $dataTable->getDataTables(); - } - - foreach ($dataTables as $dt) { + $dataTable->filter(function(DataTable $dt) { if ($dt->getRowFromLabel('ti')) { $dt->filter('GroupBy', array( 'label', @@ -54,7 +48,7 @@ class API extends \Piwik\Plugin\API } )); } - } + }); // apply filter on the whole datatable in order the inline search to work (searches are done on "beautiful" label) $dataTable->filter('AddSegmentValue'); @@ -96,13 +90,7 @@ class API extends \Piwik\Plugin\API $separator = Archiver::LOCATION_SEPARATOR; $unk = Visit::UNKNOWN_CODE; - $dataTables = [$dataTable]; - - if ($dataTable instanceof DataTable\Map) { - $dataTables = $dataTable->getDataTables(); - } - - foreach ($dataTables as $dt) { + $dataTable->filter(function(DataTable $dt) use ($period, $date, $separator, $unk) { $archiveDate = $dt->getMetadata(DataTable::ARCHIVED_DATE_METADATA_NAME); // convert fips region codes to iso if required @@ -140,7 +128,7 @@ class API extends \Piwik\Plugin\API } )); } - } + }); $segments = array('regionCode', 'countryCode'); $dataTable->filter('AddSegmentByLabel', array($segments, Archiver::LOCATION_SEPARATOR)); @@ -187,13 +175,7 @@ class API extends \Piwik\Plugin\API $separator = Archiver::LOCATION_SEPARATOR; $unk = Visit::UNKNOWN_CODE; - $dataTables = [$dataTable]; - - if ($dataTable instanceof DataTable\Map) { - $dataTables = $dataTable->getDataTables(); - } - - foreach ($dataTables as $dt) { + $dataTable->filter(function(DataTable $dt) use ($period, $date, $separator, $unk) { $archiveDate = $dt->getMetadata(DataTable::ARCHIVED_DATE_METADATA_NAME); // convert fips region codes to iso if required @@ -231,7 +213,7 @@ class API extends \Piwik\Plugin\API } )); } - } + }); $segments = array('city', 'regionCode', 'countryCode'); $dataTable->filter('AddSegmentByLabel', array($segments, Archiver::LOCATION_SEPARATOR)); diff --git a/plugins/UserCountry/tests/Fixtures/ManySitesManyVisitsWithGeoIp.php b/plugins/UserCountry/tests/Fixtures/ManySitesManyVisitsWithGeoIp.php new file mode 100644 index 0000000000..e411cc99fb --- /dev/null +++ b/plugins/UserCountry/tests/Fixtures/ManySitesManyVisitsWithGeoIp.php @@ -0,0 +1,25 @@ +<?php +/** + * Matomo - free/libre analytics platform + * + * @link https://matomo.org + * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later + */ +namespace Piwik\Plugins\UserCountry\tests\Fixtures; + +use Piwik\Tests\Fixtures\ManyVisitsWithGeoIP; + +class ManySitesManyVisitsWithGeoIp extends ManyVisitsWithGeoIP +{ + public function setUp(): void + { + parent::setUp(); + + $this->idSite = 2; + $this->ips = array_reverse($this->ips); + $this->userAgents = array_reverse($this->userAgents); + + parent::setUp(); + } +} + diff --git a/plugins/UserCountry/tests/System/ApiTest.php b/plugins/UserCountry/tests/System/ApiTest.php new file mode 100644 index 0000000000..c13bbda957 --- /dev/null +++ b/plugins/UserCountry/tests/System/ApiTest.php @@ -0,0 +1,102 @@ +<?php +/** + * Matomo - free/libre analytics platform + * + * @link https://matomo.org + * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later + */ + +namespace Piwik\Plugins\UserCountry\tests\System; + +use Piwik\Plugins\UserCountry\tests\Fixtures\ManySitesManyVisitsWithGeoIp; +use Piwik\Tests\Framework\TestCase\SystemTestCase; + +/** + * @group UserCountry2 + * @group ApiTest + * @group Plugins + */ +class ApiTest extends SystemTestCase +{ + /** + * @var ManySitesManyVisitsWithGeoIp + */ + public static $fixture; + + /** + * @dataProvider getApiForTesting + */ + public function testApi($api, $params) + { + $this->runApiTests($api, $params); + } + + public function getApiForTesting() + { + $api = [ + 'UserCountry.getCountry', + 'UserCountry.getContinent', + 'UserCountry.getRegion', + 'UserCountry.getCity', + ]; + $startDate = substr(self::$fixture->dateTime, 0, 10); + $endDate = date('Y-m-d', strtotime($startDate) + 3600*24*2); + + $apiToTest = array(); + // single period + $apiToTest[] = array( + $api, + array( + 'date' => $startDate, + 'periods' => array('day'), + 'idSite' => 1, + 'testSuffix' => '' + ) + ); + // multi period + $apiToTest[] = array( + $api, + array( + 'date' => "$startDate,$endDate", + 'periods' => array('day'), + 'idSite' => 1, + 'testSuffix' => 'multi_period' + ) + ); + // multi sites + $apiToTest[] = array( + $api, + array( + 'date' => "$startDate", + 'periods' => array('month'), + 'idSite' => 'all', + 'testSuffix' => 'multi_sites' + ) + ); + // multi sites & multi period + $apiToTest[] = array( + $api, + array( + 'date' => "$startDate,$endDate", + 'periods' => array('day'), + 'idSite' => 'all', + 'testSuffix' => 'multi_periods_and_sites' + ) + ); + + return $apiToTest; + } + + public static function getOutputPrefix() + { + return ''; + } + + public static function getPathToTestDirectory() + { + return dirname(__FILE__); + } + +} + +ApiTest::$fixture = new ManySitesManyVisitsWithGeoIp();
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test___UserCountry.getCity_day.xml b/plugins/UserCountry/tests/System/expected/test___UserCountry.getCity_day.xml new file mode 100644 index 0000000000..26019b6a12 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test___UserCountry.getCity_day.xml @@ -0,0 +1,137 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <label>Besançon, Bourgogne-Franche-Comté, France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>47.249</lat> + <long>6.018</long> + <segment>city==Besan%C3%A7on;regionCode==BFC;countryCode==fr</segment> + <city_name>Besançon</city_name> + <region>BFC</region> + <country>fr</country> + <country_name>France</country_name> + <region_name>Bourgogne-Franche-Comté</region_name> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>123.456</lat> + <long>21.321</long> + <segment>city==Stratford-upon-Avon;regionCode==WAR;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Vancouver, British Columbia, Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>49.25</lat> + <long>-123.133</long> + <segment>city==Vancouver;regionCode==BC;countryCode==ca</segment> + <city_name>Vancouver</city_name> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> +</result>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test___UserCountry.getContinent_day.xml b/plugins/UserCountry/tests/System/expected/test___UserCountry.getContinent_day.xml new file mode 100644 index 0000000000..89804d2cfb --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test___UserCountry.getContinent_day.xml @@ -0,0 +1,55 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <label>Europe</label> + <nb_uniq_visitors>3</nb_uniq_visitors> + <nb_visits>6</nb_visits> + <nb_actions>18</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>4863</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>North America</code> + </row> +</result>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test___UserCountry.getCountry_day.xml b/plugins/UserCountry/tests/System/expected/test___UserCountry.getCountry_day.xml new file mode 100644 index 0000000000..9f10bbebc6 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test___UserCountry.getCountry_day.xml @@ -0,0 +1,119 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <label>Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>ca</code> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + <segment>countryCode==ca</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>fr</code> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + <segment>countryCode==fr</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Italy</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>it</code> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + <segment>countryCode==it</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> +</result>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test___UserCountry.getRegion_day.xml b/plugins/UserCountry/tests/System/expected/test___UserCountry.getRegion_day.xml new file mode 100644 index 0000000000..74cfdcae39 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test___UserCountry.getRegion_day.xml @@ -0,0 +1,126 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <label>Bourgogne-Franche-Comté, France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==BFC;countryCode==fr</segment> + <region>BFC</region> + <country>fr</country> + <country_name>France</country_name> + <region_name>Bourgogne-Franche-Comté</region_name> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + </row> + <row> + <label>British Columbia, Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==BC;countryCode==ca</segment> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> +</result>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getCity_day.xml b/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getCity_day.xml new file mode 100644 index 0000000000..62297771ed --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getCity_day.xml @@ -0,0 +1,307 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result date="2010-01-03"> + <row> + <label>Besançon, Bourgogne-Franche-Comté, France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>47.249</lat> + <long>6.018</long> + <segment>city==Besan%C3%A7on;regionCode==BFC;countryCode==fr</segment> + <city_name>Besançon</city_name> + <region>BFC</region> + <country>fr</country> + <country_name>France</country_name> + <region_name>Bourgogne-Franche-Comté</region_name> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>123.456</lat> + <long>21.321</long> + <segment>city==Stratford-upon-Avon;regionCode==WAR;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Vancouver, British Columbia, Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>49.25</lat> + <long>-123.133</long> + <segment>city==Vancouver;regionCode==BC;countryCode==ca</segment> + <city_name>Vancouver</city_name> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>Vancouver, British Columbia, Canada</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <lat>49.25</lat> + <long>-123.133</long> + <segment>city==Vancouver;regionCode==BC;countryCode==ca</segment> + <city_name>Vancouver</city_name> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Nuneaton and Bedworth, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>city==Nuneaton+and+Bedworth;regionCode==WAR;countryCode==gb</segment> + <city_name>Nuneaton and Bedworth</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>Stratford-upon-Avon, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>124.456</lat> + <long>22.231</long> + <segment>city==Stratford-upon-Avon;regionCode==WAR;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getContinent_day.xml b/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getContinent_day.xml new file mode 100644 index 0000000000..775cc337ec --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getContinent_day.xml @@ -0,0 +1,191 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result date="2010-01-03"> + <row> + <label>Europe</label> + <nb_uniq_visitors>3</nb_uniq_visitors> + <nb_visits>6</nb_visits> + <nb_actions>18</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>4863</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>North America</code> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>North America</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <code>North America</code> + </row> + <row> + <label>Asia</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>Asia</code> + </row> + <row> + <label>Europe</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>Europe</code> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>Europe</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>North America</code> + </row> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getCountry_day.xml b/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getCountry_day.xml new file mode 100644 index 0000000000..abc96bf20e --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getCountry_day.xml @@ -0,0 +1,270 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result date="2010-01-03"> + <row> + <label>Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>ca</code> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + <segment>countryCode==ca</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>fr</code> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + <segment>countryCode==fr</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Italy</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>it</code> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + <segment>countryCode==it</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>Canada</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <code>ca</code> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + <segment>countryCode==ca</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Indonesia</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>id</code> + <logo>plugins/Morpheus/icons/dist/flags/id.png</logo> + <segment>countryCode==id</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United States</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>us</code> + <logo>plugins/Morpheus/icons/dist/flags/us.png</logo> + <segment>countryCode==us</segment> + <logoHeight>16</logoHeight> + </row> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getRegion_day.xml b/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getRegion_day.xml new file mode 100644 index 0000000000..9e35cbbb29 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_period__UserCountry.getRegion_day.xml @@ -0,0 +1,285 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result date="2010-01-03"> + <row> + <label>Bourgogne-Franche-Comté, France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==BFC;countryCode==fr</segment> + <region>BFC</region> + <country>fr</country> + <country_name>France</country_name> + <region_name>Bourgogne-Franche-Comté</region_name> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + </row> + <row> + <label>British Columbia, Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==BC;countryCode==ca</segment> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>British Columbia, Canada</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <segment>regionCode==BC;countryCode==ca</segment> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getCity_day.xml b/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getCity_day.xml new file mode 100644 index 0000000000..bcdad0ff59 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getCity_day.xml @@ -0,0 +1,583 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result idSite="1"> + <result date="2010-01-03"> + <row> + <label>Besançon, Bourgogne-Franche-Comté, France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>47.249</lat> + <long>6.018</long> + <segment>city==Besan%C3%A7on;regionCode==BFC;countryCode==fr</segment> + <city_name>Besançon</city_name> + <region>BFC</region> + <country>fr</country> + <country_name>France</country_name> + <region_name>Bourgogne-Franche-Comté</region_name> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>123.456</lat> + <long>21.321</long> + <segment>city==Stratford-upon-Avon;regionCode==WAR;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Vancouver, British Columbia, Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>49.25</lat> + <long>-123.133</long> + <segment>city==Vancouver;regionCode==BC;countryCode==ca</segment> + <city_name>Vancouver</city_name> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>Vancouver, British Columbia, Canada</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <lat>49.25</lat> + <long>-123.133</long> + <segment>city==Vancouver;regionCode==BC;countryCode==ca</segment> + <city_name>Vancouver</city_name> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Nuneaton and Bedworth, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>city==Nuneaton+and+Bedworth;regionCode==WAR;countryCode==gb</segment> + <city_name>Nuneaton and Bedworth</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>Stratford-upon-Avon, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>124.456</lat> + <long>22.231</long> + <segment>city==Stratford-upon-Avon;regionCode==WAR;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + </result> + </result> + <result idSite="2"> + <result date="2010-01-03"> + <row> + <label>Unknown</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>12</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>3242</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Lhasa, Xizang Zizhiqu, China</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>29.65</lat> + <long>91.1</long> + <segment>city==Lhasa;regionCode==XZ;countryCode==cn</segment> + <city_name>Lhasa</city_name> + <region>XZ</region> + <country>cn</country> + <country_name>China</country_name> + <region_name>Xizang Zizhiqu</region_name> + <logo>plugins/Morpheus/icons/dist/flags/cn.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>123.456</lat> + <long>21.321</long> + <segment>city==Stratford-upon-Avon;regionCode==WAR;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>Unknown</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Nuneaton and Bedworth, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>city==Nuneaton+and+Bedworth;regionCode==WAR;countryCode==gb</segment> + <city_name>Nuneaton and Bedworth</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Rome, Lazio, Italy</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>41.9</lat> + <long>12.483</long> + <segment>city==Rome;regionCode==62;countryCode==it</segment> + <city_name>Rome</city_name> + <region>62</region> + <country>it</country> + <country_name>Italy</country_name> + <region_name>Lazio</region_name> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>Stratford-upon-Avon, Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>124.456</lat> + <long>22.231</long> + <segment>city==Stratford-upon-Avon;regionCode==WAR;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Vancouver, British Columbia, Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <lat>49.25</lat> + <long>-123.133</long> + <segment>city==Vancouver;regionCode==BC;countryCode==ca</segment> + <city_name>Vancouver</city_name> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + </result> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getContinent_day.xml b/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getContinent_day.xml new file mode 100644 index 0000000000..115859a61f --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getContinent_day.xml @@ -0,0 +1,383 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result idSite="1"> + <result date="2010-01-03"> + <row> + <label>Europe</label> + <nb_uniq_visitors>3</nb_uniq_visitors> + <nb_visits>6</nb_visits> + <nb_actions>18</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>4863</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>North America</code> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>North America</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <code>North America</code> + </row> + <row> + <label>Asia</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>Asia</code> + </row> + <row> + <label>Europe</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>Europe</code> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>Europe</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>North America</code> + </row> + </result> + </result> + <result idSite="2"> + <result date="2010-01-03"> + <row> + <label>Asia</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>12</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>3242</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <code>Asia</code> + </row> + <row> + <label>Europe</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>North America</code> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>Europe</label> + <nb_uniq_visitors>3</nb_uniq_visitors> + <nb_visits>6</nb_visits> + <nb_actions>15</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>4866</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>North America</code> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>Europe</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>North America</code> + </row> + </result> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getCountry_day.xml b/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getCountry_day.xml new file mode 100644 index 0000000000..e55eb3e6f6 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getCountry_day.xml @@ -0,0 +1,570 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result idSite="1"> + <result date="2010-01-03"> + <row> + <label>Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>ca</code> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + <segment>countryCode==ca</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>fr</code> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + <segment>countryCode==fr</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Italy</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>it</code> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + <segment>countryCode==it</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>Canada</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <code>ca</code> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + <segment>countryCode==ca</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Indonesia</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>id</code> + <logo>plugins/Morpheus/icons/dist/flags/id.png</logo> + <segment>countryCode==id</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United States</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>us</code> + <logo>plugins/Morpheus/icons/dist/flags/us.png</logo> + <segment>countryCode==us</segment> + <logoHeight>16</logoHeight> + </row> + </result> + </result> + <result idSite="2"> + <result date="2010-01-03"> + <row> + <label>Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>ca</code> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + <segment>countryCode==ca</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>China</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>cn</code> + <logo>plugins/Morpheus/icons/dist/flags/cn.png</logo> + <segment>countryCode==cn</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Indonesia</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>id</code> + <logo>plugins/Morpheus/icons/dist/flags/id.png</logo> + <segment>countryCode==id</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>fr</code> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + <segment>countryCode==fr</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Italy</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>it</code> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + <segment>countryCode==it</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United States</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>us</code> + <logo>plugins/Morpheus/icons/dist/flags/us.png</logo> + <segment>countryCode==us</segment> + <logoHeight>16</logoHeight> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>ca</code> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + <segment>countryCode==ca</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + </result> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getRegion_day.xml b/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getRegion_day.xml new file mode 100644 index 0000000000..cf989cc3f4 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_periods_and_sites__UserCountry.getRegion_day.xml @@ -0,0 +1,541 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result idSite="1"> + <result date="2010-01-03"> + <row> + <label>Bourgogne-Franche-Comté, France</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==BFC;countryCode==fr</segment> + <region>BFC</region> + <country>fr</country> + <country_name>France</country_name> + <region_name>Bourgogne-Franche-Comté</region_name> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + </row> + <row> + <label>British Columbia, Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==BC;countryCode==ca</segment> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>British Columbia, Canada</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <segment>regionCode==BC;countryCode==ca</segment> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>Unknown</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + </result> + </result> + <result idSite="2"> + <result date="2010-01-03"> + <row> + <label>Unknown</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>12</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>3242</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Xizang Zizhiqu, China</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==XZ;countryCode==cn</segment> + <region>XZ</region> + <country>cn</country> + <country_name>China</country_name> + <region_name>Xizang Zizhiqu</region_name> + <logo>plugins/Morpheus/icons/dist/flags/cn.png</logo> + </row> + </result> + <result date="2010-01-04"> + <row> + <label>Unknown</label> + <nb_uniq_visitors>2</nb_uniq_visitors> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Lazio, Italy</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==62;countryCode==it</segment> + <region>62</region> + <country>it</country> + <country_name>Italy</country_name> + <region_name>Lazio</region_name> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <nb_users>0</nb_users> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + </result> + <result date="2010-01-05"> + <row> + <label>British Columbia, Canada</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==BC;countryCode==ca</segment> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_uniq_visitors>1</nb_uniq_visitors> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <nb_users>0</nb_users> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + </result> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getCity_month.xml b/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getCity_month.xml new file mode 100644 index 0000000000..b1c0065ea7 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getCity_month.xml @@ -0,0 +1,785 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result idSite="1"> + <row> + <label>Unknown</label> + <nb_visits>8</nb_visits> + <nb_actions>23</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>6485</sum_visit_length> + <bounce_count>4</bounce_count> + <nb_visits_converted>8</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>8</nb_conversions> + <nb_visits_converted>8</nb_visits_converted> + <revenue>40</revenue> + </row> + <row idgoal='2'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + </goals> + <nb_conversions>12</nb_conversions> + <revenue>60</revenue> + <sum_daily_nb_uniq_visitors>4</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Vancouver, British Columbia, Canada</label> + <nb_visits>6</nb_visits> + <nb_actions>16</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>4865</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <sum_daily_nb_uniq_visitors>3</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <lat>49.25</lat> + <long>-123.133</long> + <segment>city==Vancouver;regionCode==BC;countryCode==ca</segment> + <city_name>Vancouver</city_name> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Warwickshire, United Kingdom</label> + <nb_visits>4</nb_visits> + <nb_actions>12</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>3242</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <lat>124.456</lat> + <long>22.231</long> + <segment>city==Stratford-upon-Avon;regionCode==WAR;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Besançon, Bourgogne-Franche-Comté, France</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <lat>47.249</lat> + <long>6.018</long> + <segment>city==Besan%C3%A7on;regionCode==BFC;countryCode==fr</segment> + <city_name>Besançon</city_name> + <region>BFC</region> + <country>fr</country> + <country_name>France</country_name> + <region_name>Bourgogne-Franche-Comté</region_name> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + </row> + <row> + <label>Hluboká nad Vltavou, Sankt-Peterburg, Russia</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Hlubok%C3%A1+nad+Vltavou;regionCode==SPE;countryCode==ru</segment> + <city_name>Hluboká nad Vltavou</city_name> + <region>SPE</region> + <country>ru</country> + <country_name>Russia</country_name> + <region_name>Sankt-Peterburg</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ru.png</logo> + </row> + <row> + <label>Lhasa, Xizang Zizhiqu, China</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <lat>29.65</lat> + <long>91.1</long> + <segment>city==Lhasa;regionCode==XZ;countryCode==cn</segment> + <city_name>Lhasa</city_name> + <region>XZ</region> + <country>cn</country> + <country_name>China</country_name> + <region_name>Xizang Zizhiqu</region_name> + <logo>plugins/Morpheus/icons/dist/flags/cn.png</logo> + </row> + <row> + <label>London, London, City of, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==London;regionCode==LND;countryCode==gb</segment> + <city_name>London</city_name> + <region>LND</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>London, City of</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Nuneaton and Bedworth, Warwickshire, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Nuneaton+and+Bedworth;regionCode==WAR;countryCode==gb</segment> + <city_name>Nuneaton and Bedworth</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Gevgelija, North Macedonia</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Stratford-upon-Avon;regionCode==18;countryCode==mk</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>18</region> + <country>mk</country> + <country_name>North Macedonia</country_name> + <region_name>Gevgelija</region_name> + <logo>plugins/Morpheus/icons/dist/flags/mk.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Kent, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Stratford-upon-Avon;regionCode==KEN;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>KEN</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Kent</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Sankt-Peterburg, Russia</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Stratford-upon-Avon;regionCode==SPE;countryCode==ru</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>SPE</region> + <country>ru</country> + <country_name>Russia</country_name> + <region_name>Sankt-Peterburg</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ru.png</logo> + </row> + <row> + <label>not a city, California, United States</label> + <nb_visits>1</nb_visits> + <nb_actions>1</nb_actions> + <max_actions>1</max_actions> + <sum_visit_length>0</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>1</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>1</nb_conversions> + <revenue>5</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>1</sum_daily_nb_users> + <lat>1</lat> + <long>2</long> + <segment>city==not+a+city;regionCode==CA;countryCode==us</segment> + <city_name>not a city</city_name> + <region>CA</region> + <country>us</country> + <country_name>United States</country_name> + <region_name>California</region_name> + <logo>plugins/Morpheus/icons/dist/flags/us.png</logo> + </row> + </result> + <result idSite="2"> + <row> + <label>Unknown</label> + <nb_visits>10</nb_visits> + <nb_actions>28</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>8107</sum_visit_length> + <bounce_count>5</bounce_count> + <nb_visits_converted>10</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>10</nb_conversions> + <nb_visits_converted>10</nb_visits_converted> + <revenue>50</revenue> + </row> + <row idgoal='2'> + <nb_conversions>5</nb_conversions> + <nb_visits_converted>5</nb_visits_converted> + <revenue>25</revenue> + </row> + </goals> + <nb_conversions>15</nb_conversions> + <revenue>75</revenue> + <sum_daily_nb_uniq_visitors>5</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <city_name>Unknown</city_name> + <city>xx</city> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Warwickshire, United Kingdom</label> + <nb_visits>4</nb_visits> + <nb_actions>12</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>3242</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <lat>124.456</lat> + <long>22.231</long> + <segment>city==Stratford-upon-Avon;regionCode==WAR;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Vancouver, British Columbia, Canada</label> + <nb_visits>4</nb_visits> + <nb_actions>11</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>3243</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <lat>49.25</lat> + <long>-123.133</long> + <segment>city==Vancouver;regionCode==BC;countryCode==ca</segment> + <city_name>Vancouver</city_name> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Hluboká nad Vltavou, Sankt-Peterburg, Russia</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Hlubok%C3%A1+nad+Vltavou;regionCode==SPE;countryCode==ru</segment> + <city_name>Hluboká nad Vltavou</city_name> + <region>SPE</region> + <country>ru</country> + <country_name>Russia</country_name> + <region_name>Sankt-Peterburg</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ru.png</logo> + </row> + <row> + <label>Lhasa, Xizang Zizhiqu, China</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <lat>29.65</lat> + <long>91.1</long> + <segment>city==Lhasa;regionCode==XZ;countryCode==cn</segment> + <city_name>Lhasa</city_name> + <region>XZ</region> + <country>cn</country> + <country_name>China</country_name> + <region_name>Xizang Zizhiqu</region_name> + <logo>plugins/Morpheus/icons/dist/flags/cn.png</logo> + </row> + <row> + <label>London, London, City of, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==London;regionCode==LND;countryCode==gb</segment> + <city_name>London</city_name> + <region>LND</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>London, City of</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Nuneaton and Bedworth, Warwickshire, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Nuneaton+and+Bedworth;regionCode==WAR;countryCode==gb</segment> + <city_name>Nuneaton and Bedworth</city_name> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Rome, Lazio, Italy</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <lat>41.9</lat> + <long>12.483</long> + <segment>city==Rome;regionCode==62;countryCode==it</segment> + <city_name>Rome</city_name> + <region>62</region> + <country>it</country> + <country_name>Italy</country_name> + <region_name>Lazio</region_name> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Gevgelija, North Macedonia</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Stratford-upon-Avon;regionCode==18;countryCode==mk</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>18</region> + <country>mk</country> + <country_name>North Macedonia</country_name> + <region_name>Gevgelija</region_name> + <logo>plugins/Morpheus/icons/dist/flags/mk.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Kent, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Stratford-upon-Avon;regionCode==KEN;countryCode==gb</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>KEN</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Kent</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Stratford-upon-Avon, Sankt-Peterburg, Russia</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>city==Stratford-upon-Avon;regionCode==SPE;countryCode==ru</segment> + <city_name>Stratford-upon-Avon</city_name> + <region>SPE</region> + <country>ru</country> + <country_name>Russia</country_name> + <region_name>Sankt-Peterburg</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ru.png</logo> + </row> + <row> + <label>not a city, California, United States</label> + <nb_visits>1</nb_visits> + <nb_actions>1</nb_actions> + <max_actions>1</max_actions> + <sum_visit_length>0</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>1</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>1</nb_conversions> + <revenue>5</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>1</sum_daily_nb_users> + <lat>1</lat> + <long>2</long> + <segment>city==not+a+city;regionCode==CA;countryCode==us</segment> + <city_name>not a city</city_name> + <region>CA</region> + <country>us</country> + <country_name>United States</country_name> + <region_name>California</region_name> + <logo>plugins/Morpheus/icons/dist/flags/us.png</logo> + </row> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getContinent_month.xml b/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getContinent_month.xml new file mode 100644 index 0000000000..9c98f46461 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getContinent_month.xml @@ -0,0 +1,215 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result idSite="1"> + <row> + <label>Europe</label> + <nb_visits>20</nb_visits> + <nb_actions>56</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>16214</sum_visit_length> + <bounce_count>10</bounce_count> + <nb_visits_converted>20</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>20</nb_conversions> + <nb_visits_converted>20</nb_visits_converted> + <revenue>100</revenue> + </row> + <row idgoal='2'> + <nb_conversions>10</nb_conversions> + <nb_visits_converted>10</nb_visits_converted> + <revenue>50</revenue> + </row> + </goals> + <nb_conversions>30</nb_conversions> + <revenue>150</revenue> + <sum_daily_nb_uniq_visitors>10</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_visits>9</nb_visits> + <nb_actions>23</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>6486</sum_visit_length> + <bounce_count>5</bounce_count> + <nb_visits_converted>9</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>9</nb_conversions> + <nb_visits_converted>9</nb_visits_converted> + <revenue>45</revenue> + </row> + <row idgoal='2'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + </goals> + <nb_conversions>13</nb_conversions> + <revenue>65</revenue> + <sum_daily_nb_uniq_visitors>5</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>1</sum_daily_nb_users> + <code>North America</code> + </row> + <row> + <label>Asia</label> + <nb_visits>4</nb_visits> + <nb_actions>10</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>3244</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>Asia</code> + </row> + <row> + <label>Unknown</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>Unknown</code> + </row> + </result> + <result idSite="2"> + <row> + <label>Europe</label> + <nb_visits>20</nb_visits> + <nb_actions>54</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>16216</sum_visit_length> + <bounce_count>10</bounce_count> + <nb_visits_converted>20</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>20</nb_conversions> + <nb_visits_converted>20</nb_visits_converted> + <revenue>100</revenue> + </row> + <row idgoal='2'> + <nb_conversions>10</nb_conversions> + <nb_visits_converted>10</nb_visits_converted> + <revenue>50</revenue> + </row> + </goals> + <nb_conversions>30</nb_conversions> + <revenue>150</revenue> + <sum_daily_nb_uniq_visitors>10</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>Europe</code> + </row> + <row> + <label>North America</label> + <nb_visits>9</nb_visits> + <nb_actions>23</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>6486</sum_visit_length> + <bounce_count>5</bounce_count> + <nb_visits_converted>9</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>9</nb_conversions> + <nb_visits_converted>9</nb_visits_converted> + <revenue>45</revenue> + </row> + <row idgoal='2'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + </goals> + <nb_conversions>13</nb_conversions> + <revenue>65</revenue> + <sum_daily_nb_uniq_visitors>5</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>1</sum_daily_nb_users> + <code>North America</code> + </row> + <row> + <label>Asia</label> + <nb_visits>4</nb_visits> + <nb_actions>12</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>3242</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>Asia</code> + </row> + <row> + <label>Unknown</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>Unknown</code> + </row> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getCountry_month.xml b/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getCountry_month.xml new file mode 100644 index 0000000000..f78544f4e3 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getCountry_month.xml @@ -0,0 +1,587 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result idSite="1"> + <row> + <label>United Kingdom</label> + <nb_visits>10</nb_visits> + <nb_actions>28</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>8107</sum_visit_length> + <bounce_count>5</bounce_count> + <nb_visits_converted>10</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>10</nb_conversions> + <nb_visits_converted>10</nb_visits_converted> + <revenue>50</revenue> + </row> + <row idgoal='2'> + <nb_conversions>5</nb_conversions> + <nb_visits_converted>5</nb_visits_converted> + <revenue>25</revenue> + </row> + </goals> + <nb_conversions>15</nb_conversions> + <revenue>75</revenue> + <sum_daily_nb_uniq_visitors>5</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Canada</label> + <nb_visits>6</nb_visits> + <nb_actions>16</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>4865</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <sum_daily_nb_uniq_visitors>3</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>ca</code> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + <segment>countryCode==ca</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Russia</label> + <nb_visits>4</nb_visits> + <nb_actions>11</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>3243</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>ru</code> + <logo>plugins/Morpheus/icons/dist/flags/ru.png</logo> + <segment>countryCode==ru</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United States</label> + <nb_visits>3</nb_visits> + <nb_actions>7</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>3</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>4</nb_conversions> + <revenue>20</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>1</sum_daily_nb_users> + <code>us</code> + <logo>plugins/Morpheus/icons/dist/flags/us.png</logo> + <segment>countryCode==us</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>China</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>cn</code> + <logo>plugins/Morpheus/icons/dist/flags/cn.png</logo> + <segment>countryCode==cn</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>France</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>fr</code> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + <segment>countryCode==fr</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Indonesia</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>id</code> + <logo>plugins/Morpheus/icons/dist/flags/id.png</logo> + <segment>countryCode==id</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Italy</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>it</code> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + <segment>countryCode==it</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>North Macedonia</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>mk</code> + <logo>plugins/Morpheus/icons/dist/flags/mk.png</logo> + <segment>countryCode==mk</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Unknown</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>xx</code> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + <segment>countryCode==xx</segment> + <logoHeight>16</logoHeight> + </row> + </result> + <result idSite="2"> + <row> + <label>United Kingdom</label> + <nb_visits>10</nb_visits> + <nb_actions>28</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>8107</sum_visit_length> + <bounce_count>5</bounce_count> + <nb_visits_converted>10</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>10</nb_conversions> + <nb_visits_converted>10</nb_visits_converted> + <revenue>50</revenue> + </row> + <row idgoal='2'> + <nb_conversions>5</nb_conversions> + <nb_visits_converted>5</nb_visits_converted> + <revenue>25</revenue> + </row> + </goals> + <nb_conversions>15</nb_conversions> + <revenue>75</revenue> + <sum_daily_nb_uniq_visitors>5</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>gb</code> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + <segment>countryCode==gb</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Canada</label> + <nb_visits>6</nb_visits> + <nb_actions>17</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>4864</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <sum_daily_nb_uniq_visitors>3</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>ca</code> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + <segment>countryCode==ca</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Russia</label> + <nb_visits>4</nb_visits> + <nb_actions>11</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>3243</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>ru</code> + <logo>plugins/Morpheus/icons/dist/flags/ru.png</logo> + <segment>countryCode==ru</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>United States</label> + <nb_visits>3</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>3</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>4</nb_conversions> + <revenue>20</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>1</sum_daily_nb_users> + <code>us</code> + <logo>plugins/Morpheus/icons/dist/flags/us.png</logo> + <segment>countryCode==us</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>China</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>cn</code> + <logo>plugins/Morpheus/icons/dist/flags/cn.png</logo> + <segment>countryCode==cn</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>France</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>fr</code> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + <segment>countryCode==fr</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Indonesia</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>id</code> + <logo>plugins/Morpheus/icons/dist/flags/id.png</logo> + <segment>countryCode==id</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Italy</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>it</code> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + <segment>countryCode==it</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>North Macedonia</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>mk</code> + <logo>plugins/Morpheus/icons/dist/flags/mk.png</logo> + <segment>countryCode==mk</segment> + <logoHeight>16</logoHeight> + </row> + <row> + <label>Unknown</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <code>xx</code> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + <segment>countryCode==xx</segment> + <logoHeight>16</logoHeight> + </row> + </result> +</results>
\ No newline at end of file diff --git a/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getRegion_month.xml b/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getRegion_month.xml new file mode 100644 index 0000000000..5925682051 --- /dev/null +++ b/plugins/UserCountry/tests/System/expected/test_multi_sites__UserCountry.getRegion_month.xml @@ -0,0 +1,615 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result idSite="1"> + <row> + <label>Unknown</label> + <nb_visits>8</nb_visits> + <nb_actions>23</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>6485</sum_visit_length> + <bounce_count>4</bounce_count> + <nb_visits_converted>8</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>8</nb_conversions> + <nb_visits_converted>8</nb_visits_converted> + <revenue>40</revenue> + </row> + <row idgoal='2'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + </goals> + <nb_conversions>12</nb_conversions> + <revenue>60</revenue> + <sum_daily_nb_uniq_visitors>4</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>British Columbia, Canada</label> + <nb_visits>6</nb_visits> + <nb_actions>16</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>4865</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <sum_daily_nb_uniq_visitors>3</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==BC;countryCode==ca</segment> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_visits>6</nb_visits> + <nb_actions>17</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>4864</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <sum_daily_nb_uniq_visitors>3</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Sankt-Peterburg, Russia</label> + <nb_visits>4</nb_visits> + <nb_actions>11</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>3243</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==SPE;countryCode==ru</segment> + <region>SPE</region> + <country>ru</country> + <country_name>Russia</country_name> + <region_name>Sankt-Peterburg</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ru.png</logo> + </row> + <row> + <label>Bourgogne-Franche-Comté, France</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==BFC;countryCode==fr</segment> + <region>BFC</region> + <country>fr</country> + <country_name>France</country_name> + <region_name>Bourgogne-Franche-Comté</region_name> + <logo>plugins/Morpheus/icons/dist/flags/fr.png</logo> + </row> + <row> + <label>Gevgelija, North Macedonia</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==18;countryCode==mk</segment> + <region>18</region> + <country>mk</country> + <country_name>North Macedonia</country_name> + <region_name>Gevgelija</region_name> + <logo>plugins/Morpheus/icons/dist/flags/mk.png</logo> + </row> + <row> + <label>Kent, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==KEN;countryCode==gb</segment> + <region>KEN</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Kent</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>London, City of, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==LND;countryCode==gb</segment> + <region>LND</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>London, City of</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Xizang Zizhiqu, China</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==XZ;countryCode==cn</segment> + <region>XZ</region> + <country>cn</country> + <country_name>China</country_name> + <region_name>Xizang Zizhiqu</region_name> + <logo>plugins/Morpheus/icons/dist/flags/cn.png</logo> + </row> + <row> + <label>California, United States</label> + <nb_visits>1</nb_visits> + <nb_actions>1</nb_actions> + <max_actions>1</max_actions> + <sum_visit_length>0</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>1</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>1</nb_conversions> + <revenue>5</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>1</sum_daily_nb_users> + <segment>regionCode==CA;countryCode==us</segment> + <region>CA</region> + <country>us</country> + <country_name>United States</country_name> + <region_name>California</region_name> + <logo>plugins/Morpheus/icons/dist/flags/us.png</logo> + </row> + </result> + <result idSite="2"> + <row> + <label>Unknown</label> + <nb_visits>10</nb_visits> + <nb_actions>28</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>8107</sum_visit_length> + <bounce_count>5</bounce_count> + <nb_visits_converted>10</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>10</nb_conversions> + <nb_visits_converted>10</nb_visits_converted> + <revenue>50</revenue> + </row> + <row idgoal='2'> + <nb_conversions>5</nb_conversions> + <nb_visits_converted>5</nb_visits_converted> + <revenue>25</revenue> + </row> + </goals> + <nb_conversions>15</nb_conversions> + <revenue>75</revenue> + <sum_daily_nb_uniq_visitors>5</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <region>xx</region> + <country>xx</country> + <country_name>Unknown</country_name> + <region_name>Unknown</region_name> + <logo>plugins/Morpheus/icons/dist/flags/xx.png</logo> + </row> + <row> + <label>Warwickshire, United Kingdom</label> + <nb_visits>6</nb_visits> + <nb_actions>17</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>4864</sum_visit_length> + <bounce_count>3</bounce_count> + <nb_visits_converted>6</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>6</nb_conversions> + <nb_visits_converted>6</nb_visits_converted> + <revenue>30</revenue> + </row> + <row idgoal='2'> + <nb_conversions>3</nb_conversions> + <nb_visits_converted>3</nb_visits_converted> + <revenue>15</revenue> + </row> + </goals> + <nb_conversions>9</nb_conversions> + <revenue>45</revenue> + <sum_daily_nb_uniq_visitors>3</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==WAR;countryCode==gb</segment> + <region>WAR</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Warwickshire</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>British Columbia, Canada</label> + <nb_visits>4</nb_visits> + <nb_actions>11</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>3243</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==BC;countryCode==ca</segment> + <region>BC</region> + <country>ca</country> + <country_name>Canada</country_name> + <region_name>British Columbia</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ca.png</logo> + </row> + <row> + <label>Sankt-Peterburg, Russia</label> + <nb_visits>4</nb_visits> + <nb_actions>11</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>3243</sum_visit_length> + <bounce_count>2</bounce_count> + <nb_visits_converted>4</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>4</nb_conversions> + <nb_visits_converted>4</nb_visits_converted> + <revenue>20</revenue> + </row> + <row idgoal='2'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + </goals> + <nb_conversions>6</nb_conversions> + <revenue>30</revenue> + <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==SPE;countryCode==ru</segment> + <region>SPE</region> + <country>ru</country> + <country_name>Russia</country_name> + <region_name>Sankt-Peterburg</region_name> + <logo>plugins/Morpheus/icons/dist/flags/ru.png</logo> + </row> + <row> + <label>Gevgelija, North Macedonia</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==18;countryCode==mk</segment> + <region>18</region> + <country>mk</country> + <country_name>North Macedonia</country_name> + <region_name>Gevgelija</region_name> + <logo>plugins/Morpheus/icons/dist/flags/mk.png</logo> + </row> + <row> + <label>Kent, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==KEN;countryCode==gb</segment> + <region>KEN</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>Kent</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Lazio, Italy</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==62;countryCode==it</segment> + <region>62</region> + <country>it</country> + <country_name>Italy</country_name> + <region_name>Lazio</region_name> + <logo>plugins/Morpheus/icons/dist/flags/it.png</logo> + </row> + <row> + <label>London, City of, United Kingdom</label> + <nb_visits>2</nb_visits> + <nb_actions>5</nb_actions> + <max_actions>4</max_actions> + <sum_visit_length>1622</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==LND;countryCode==gb</segment> + <region>LND</region> + <country>gb</country> + <country_name>United Kingdom</country_name> + <region_name>London, City of</region_name> + <logo>plugins/Morpheus/icons/dist/flags/gb.png</logo> + </row> + <row> + <label>Xizang Zizhiqu, China</label> + <nb_visits>2</nb_visits> + <nb_actions>6</nb_actions> + <max_actions>5</max_actions> + <sum_visit_length>1621</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>2</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>2</nb_conversions> + <nb_visits_converted>2</nb_visits_converted> + <revenue>10</revenue> + </row> + <row idgoal='2'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>3</nb_conversions> + <revenue>15</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>0</sum_daily_nb_users> + <segment>regionCode==XZ;countryCode==cn</segment> + <region>XZ</region> + <country>cn</country> + <country_name>China</country_name> + <region_name>Xizang Zizhiqu</region_name> + <logo>plugins/Morpheus/icons/dist/flags/cn.png</logo> + </row> + <row> + <label>California, United States</label> + <nb_visits>1</nb_visits> + <nb_actions>1</nb_actions> + <max_actions>1</max_actions> + <sum_visit_length>0</sum_visit_length> + <bounce_count>1</bounce_count> + <nb_visits_converted>1</nb_visits_converted> + <goals> + <row idgoal='1'> + <nb_conversions>1</nb_conversions> + <nb_visits_converted>1</nb_visits_converted> + <revenue>5</revenue> + </row> + </goals> + <nb_conversions>1</nb_conversions> + <revenue>5</revenue> + <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors> + <sum_daily_nb_users>1</sum_daily_nb_users> + <segment>regionCode==CA;countryCode==us</segment> + <region>CA</region> + <country>us</country> + <country_name>United States</country_name> + <region_name>California</region_name> + <logo>plugins/Morpheus/icons/dist/flags/us.png</logo> + </row> + </result> +</results>
\ No newline at end of file |