Tests for segments in Goals getItems methods.

13 files changed, 667 insertions, 0 deletions

diff --git a/tests/PHPUnit/Integration/EcommerceOrderWithItemsTest.php b/tests/PHPUnit/Integration/EcommerceOrderWithItemsTest.php
index c595b40bb0..9cba211992 100755
--- a/tests/PHPUnit/Integration/EcommerceOrderWithItemsTest.php
+++ b/tests/PHPUnit/Integration/EcommerceOrderWithItemsTest.php
@@ -50,9 +50,37 @@ class Test_Piwik_Integration_EcommerceOrderWithItems extends IntegrationTestCase
 
         $processedReportApi = array('API.getProcessedReport');
 
+        $apiWithSegments = array(
+            'Goals.getItemsSku', 'Goals.getItemsName', 'Goals.getItemsCategory'
+        );
+
         // Normal standard goal
         return array_merge(array(
 
+                array(
+                    $apiWithSegments,
+                    array(
+                        'idSite' => $idSite,
+                        'date' => $dateTime,
+                        'periods' => array('day', 'week'),
+                        'otherRequestParameters' => array('_leavePiwikCoreVariables' => 1),
+                        'segment' => 'pageUrl=@RODUCT THREE LEFT in cart',
+                        'compareAgainst' => 'ecommerceOrderWithItemsAndSegments'
+                    )
+                ),
+
+                array(
+                    $apiWithSegments,
+                    array(
+                        'idSite' => $idSite,
+                        'date' => $dateTime,
+                        'periods' => array('day', 'week'),
+                        'otherRequestParameters' => array('_leavePiwikCoreVariables' => 1),
+                        'segment' => 'countryCode==fr',
+                        'compareAgainst' => 'ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr'
+                    )
+                ),
+
                                 // day tests
                                 array($dayApi, array('idSite' => $idSite, 'date' => $dateTime, 'periods' => array('day'), 'otherRequestParameters' => array('_leavePiwikCoreVariables' => 1))),
 
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsCategory_day.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsCategory_day.xml
new file mode 100644
index 0000000000..f80dbb036c
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsCategory_day.xml
@@ -0,0 +1,84 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>Electronics &amp; Cameras</label>
+		<revenue>2500</revenue>
+		<quantity>3</quantity>
+		<orders>2</orders>
+		<nb_uniq_visitors>2</nb_uniq_visitors>
+		<nb_visits>3</nb_visits>
+		<nb_actions>6</nb_actions>
+		<avg_price>1000</avg_price>
+		<avg_quantity>1.5</avg_quantity>
+		<conversion_rate>66.67%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 1</label>
+		<revenue>1000</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>500</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 2</label>
+		<revenue>1000</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>500</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 4</label>
+		<revenue>1000</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>500</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 5</label>
+		<revenue>1000</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>500</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>Product Category not defined</label>
+		<revenue>611.22</revenue>
+		<quantity>7</quantity>
+		<orders>2</orders>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>3</nb_visits>
+		<nb_actions>5</nb_actions>
+		<avg_price>55.61</avg_price>
+		<avg_quantity>3.5</avg_quantity>
+		<conversion_rate>66.67%</conversion_rate>
+	</row>
+	<row>
+		<label>Category TWO LEFT in cart</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>2</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsCategory_week.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsCategory_week.xml
new file mode 100644
index 0000000000..801e94d486
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsCategory_week.xml
@@ -0,0 +1,93 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>Electronics &amp; Cameras</label>
+		<revenue>2500</revenue>
+		<quantity>3</quantity>
+		<orders>2</orders>
+		<nb_visits>3</nb_visits>
+		<nb_actions>6</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>1000</avg_price>
+		<avg_quantity>1.5</avg_quantity>
+		<conversion_rate>66.67%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 1</label>
+		<revenue>1000</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>500</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 2</label>
+		<revenue>1000</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>500</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 4</label>
+		<revenue>1000</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>500</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 5</label>
+		<revenue>1000</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>500</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>Product Category not defined</label>
+		<revenue>611.22</revenue>
+		<quantity>7</quantity>
+		<orders>2</orders>
+		<nb_visits>4</nb_visits>
+		<nb_actions>7</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>55.61</avg_price>
+		<avg_quantity>3.5</avg_quantity>
+		<conversion_rate>50%</conversion_rate>
+	</row>
+	<row>
+		<label>Tools</label>
+		<revenue>200</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<avg_price>100</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Category TWO LEFT in cart</label>
+		<nb_visits>3</nb_visits>
+		<nb_actions>3</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsName_day.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsName_day.xml
new file mode 100644
index 0000000000..2294e341d3
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsName_day.xml
@@ -0,0 +1,51 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>Canon SLR</label>
+		<revenue>1500</revenue>
+		<quantity>1</quantity>
+		<orders>1</orders>
+		<avg_price>1500</avg_price>
+		<avg_quantity>1</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT name</label>
+		<revenue>1011.22</revenue>
+		<quantity>3</quantity>
+		<orders>2</orders>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>5</nb_actions>
+		<avg_price>255.61</avg_price>
+		<avg_quantity>1.5</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT name BIS</label>
+		<revenue>600</revenue>
+		<quantity>6</quantity>
+		<orders>1</orders>
+		<avg_price>100</avg_price>
+		<avg_quantity>6</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT THREE LEFT in cart</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>4</nb_actions>
+		<avg_price>666</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT TWO LEFT in cart</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>2</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsName_week.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsName_week.xml
new file mode 100644
index 0000000000..af93456129
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsName_week.xml
@@ -0,0 +1,60 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>Canon SLR</label>
+		<revenue>1500</revenue>
+		<quantity>1</quantity>
+		<orders>1</orders>
+		<avg_price>1500</avg_price>
+		<avg_quantity>1</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT name</label>
+		<revenue>1011.22</revenue>
+		<quantity>3</quantity>
+		<orders>2</orders>
+		<nb_visits>2</nb_visits>
+		<nb_actions>5</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>255.61</avg_price>
+		<avg_quantity>1.5</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT name BIS</label>
+		<revenue>600</revenue>
+		<quantity>6</quantity>
+		<orders>1</orders>
+		<avg_price>100</avg_price>
+		<avg_quantity>6</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>TRIPOD - bought day after</label>
+		<revenue>200</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<avg_price>100</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT THREE LEFT in cart</label>
+		<nb_visits>3</nb_visits>
+		<nb_actions>6</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>1332</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT TWO LEFT in cart</label>
+		<nb_visits>3</nb_visits>
+		<nb_actions>3</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsSku_day.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsSku_day.xml
new file mode 100644
index 0000000000..2a22e08247
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsSku_day.xml
@@ -0,0 +1,45 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>SKU2</label>
+		<revenue>1500</revenue>
+		<quantity>1</quantity>
+		<orders>1</orders>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>1500</avg_price>
+		<avg_quantity>1</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>SKU VERY nice indeed</label>
+		<revenue>1011.22</revenue>
+		<quantity>3</quantity>
+		<orders>2</orders>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>3</nb_visits>
+		<nb_actions>8</nb_actions>
+		<avg_price>255.61</avg_price>
+		<avg_quantity>1.5</avg_quantity>
+		<conversion_rate>66.67%</conversion_rate>
+	</row>
+	<row>
+		<label>ANOTHER SKU HERE</label>
+		<revenue>600</revenue>
+		<quantity>6</quantity>
+		<orders>1</orders>
+		<avg_price>100</avg_price>
+		<avg_quantity>6</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>SKU IN ABANDONED CART TWO</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>2</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsSku_week.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsSku_week.xml
new file mode 100644
index 0000000000..a88519f762
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegmentsAndCountryCodeFr__Goals.getItemsSku_week.xml
@@ -0,0 +1,54 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>SKU2</label>
+		<revenue>1500</revenue>
+		<quantity>1</quantity>
+		<orders>1</orders>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>1500</avg_price>
+		<avg_quantity>1</avg_quantity>
+		<conversion_rate>100%</conversion_rate>
+	</row>
+	<row>
+		<label>SKU VERY nice indeed</label>
+		<revenue>1011.22</revenue>
+		<quantity>3</quantity>
+		<orders>2</orders>
+		<nb_visits>4</nb_visits>
+		<nb_actions>10</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>255.61</avg_price>
+		<avg_quantity>1.5</avg_quantity>
+		<conversion_rate>50%</conversion_rate>
+	</row>
+	<row>
+		<label>ANOTHER SKU HERE</label>
+		<revenue>600</revenue>
+		<quantity>6</quantity>
+		<orders>1</orders>
+		<avg_price>100</avg_price>
+		<avg_quantity>6</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>TRIPOD SKU</label>
+		<revenue>200</revenue>
+		<quantity>2</quantity>
+		<orders>1</orders>
+		<avg_price>100</avg_price>
+		<avg_quantity>2</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>SKU IN ABANDONED CART TWO</label>
+		<nb_visits>3</nb_visits>
+		<nb_actions>3</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsCategory_day.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsCategory_day.xml
new file mode 100644
index 0000000000..ac1d399b66
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsCategory_day.xml
@@ -0,0 +1,66 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>Electronics &amp; Cameras</label>
+		<nb_uniq_visitors>2</nb_uniq_visitors>
+		<nb_visits>3</nb_visits>
+		<nb_actions>6</nb_actions>
+		<avg_price>814.37</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Product Category not defined</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>3</nb_visits>
+		<nb_actions>5</nb_actions>
+		<avg_price>710.4</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Category TWO LEFT in cart</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>2</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 1</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 2</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 4</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 5</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsCategory_week.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsCategory_week.xml
new file mode 100644
index 0000000000..b52622c5d6
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsCategory_week.xml
@@ -0,0 +1,66 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>Product Category not defined</label>
+		<nb_visits>4</nb_visits>
+		<nb_actions>7</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>1376.4</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Electronics &amp; Cameras</label>
+		<nb_visits>3</nb_visits>
+		<nb_actions>6</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>814.37</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Category TWO LEFT in cart</label>
+		<nb_visits>3</nb_visits>
+		<nb_actions>3</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 1</label>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 2</label>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 4</label>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>Multiple Category 5</label>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsName_day.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsName_day.xml
new file mode 100644
index 0000000000..9deb55e85a
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsName_day.xml
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>PRODUCT name</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>5</nb_actions>
+		<avg_price>832.78</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT THREE LEFT in cart</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>4</nb_actions>
+		<avg_price>666</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT TWO LEFT in cart</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>2</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsName_week.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsName_week.xml
new file mode 100644
index 0000000000..1227743a30
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsName_week.xml
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>PRODUCT THREE LEFT in cart</label>
+		<nb_visits>3</nb_visits>
+		<nb_actions>6</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>1332</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT name</label>
+		<nb_visits>2</nb_visits>
+		<nb_actions>5</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>832.78</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>PRODUCT TWO LEFT in cart</label>
+		<nb_visits>3</nb_visits>
+		<nb_actions>3</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsSku_day.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsSku_day.xml
new file mode 100644
index 0000000000..b305ab5441
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsSku_day.xml
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>SKU VERY nice indeed</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>3</nb_visits>
+		<nb_actions>8</nb_actions>
+		<avg_price>697.71</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>SKU IN ABANDONED CART TWO</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>2</nb_visits>
+		<nb_actions>2</nb_actions>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>SKU2</label>
+		<nb_uniq_visitors>1</nb_uniq_visitors>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<avg_price>1111.11</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>
diff --git a/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsSku_week.xml b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsSku_week.xml
new file mode 100644
index 0000000000..d5058376fa
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_ecommerceOrderWithItemsAndSegments__Goals.getItemsSku_week.xml
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>SKU VERY nice indeed</label>
+		<nb_visits>4</nb_visits>
+		<nb_actions>10</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>1363.71</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>SKU IN ABANDONED CART TWO</label>
+		<nb_visits>3</nb_visits>
+		<nb_actions>3</nb_actions>
+		<sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+		<avg_price>0</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+	<row>
+		<label>SKU2</label>
+		<nb_visits>1</nb_visits>
+		<nb_actions>1</nb_actions>
+		<sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+		<avg_price>1111.11</avg_price>
+		<avg_quantity>0</avg_quantity>
+		<conversion_rate>0%</conversion_rate>
+	</row>
+</result>