Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/matomo-org/matomo.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPatryk Andrzejewski <p.andrzejewski@clearcode.cc>2014-09-22 10:45:28 +0400
committerPatryk Andrzejewski <p.andrzejewski@clearcode.cc>2014-09-22 10:45:28 +0400
commitce8061d6240ec8a9cf3b9ee702426bd91d6292e9 (patch)
tree3158eeac0eeed823c9b9f593bff449e809a5e1d9 /tests/PHPUnit/Integration/expected
parente6c66c8a35ea9d93867dde72880e6a56bdcf2443 (diff)
parent89d0ceac119f0f7e5529029c3352bf5d73e971c5 (diff)
Merge remote-tracking branch 'upstream/master'
Diffstat (limited to 'tests/PHPUnit/Integration/expected')
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldAppear__Actions.getPageUrls_month.xml120
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldAppear__VisitsSummary.get_month.xml20
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldNotAppear__Actions.getPageUrls_month.xml109
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldNotAppear__VisitsSummary.get_month.xml20
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__Actions.getPageUrls_week.xml73
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__VisitsSummary.get_week.xml20
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldAppear__Actions.getPageUrls_month.xml73
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldAppear__VisitsSummary.get_month.xml20
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__Actions.getPageUrls_week.xml62
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__VisitsSummary.get_week.xml20
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear__Actions.getPageUrls_month.xml62
-rw-r--r--tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear__VisitsSummary.get_month.xml20
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml49
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml33
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithColumnLimiting__Referrers.getKeywords_week.xml33
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithCsvOutput__Referrers.getKeywords_week.csvbin0 -> 458 bytes
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithJsonOutput__Referrers.getKeywords_week.json1
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml123
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable_WhenSegmentUsedInRequest__Referrers.getKeywords_week.xml11
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml39
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable_WhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml57
-rw-r--r--tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml57
22 files changed, 1022 insertions, 0 deletions
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldAppear__Actions.getPageUrls_month.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldAppear__Actions.getPageUrls_month.xml
new file mode 100644
index 0000000000..823b29f7a5
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldAppear__Actions.getPageUrls_month.xml
@@ -0,0 +1,120 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="2010-03">
+ <row>
+ <label>category</label>
+ <nb_visits>6</nb_visits>
+ <nb_hits>6</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>2</entry_nb_visits>
+ <entry_nb_actions>12</entry_nb_actions>
+ <entry_sum_visit_length>2</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <subtable>
+ <row>
+ <label>/Page1</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>2</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>2</entry_nb_visits>
+ <entry_nb_actions>12</entry_nb_actions>
+ <entry_sum_visit_length>2</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+ <sum_daily_entry_nb_uniq_visitors>2</sum_daily_entry_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page1</url>
+ </row>
+ <row>
+ <label>/Page2</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>2</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page2</url>
+ </row>
+ <row>
+ <label>/NewPage</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/NewPage</url>
+ </row>
+ <row>
+ <label>/Page3</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page3</url>
+ </row>
+ </subtable>
+ </row>
+ <row>
+ <label>/Contact</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>2</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/Contact</url>
+ </row>
+ <row>
+ <label>/Home</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>2</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/Home</url>
+ </row>
+ <row>
+ <label>Contact</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>2</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <exit_nb_visits>2</exit_nb_visits>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>100%</exit_rate>
+ <subtable>
+ <row>
+ <label>/ThankYou</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>2</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <exit_nb_visits>2</exit_nb_visits>
+ <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+ <sum_daily_exit_nb_uniq_visitors>2</sum_daily_exit_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>100%</exit_rate>
+ <url>http://example.org/Contact/ThankYou</url>
+ </row>
+ </subtable>
+ </row>
+ </result>
+ <result date="2010-04" />
+ <result date="2010-05" />
+ <result date="2010-06" />
+ <result date="2010-07" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldAppear__VisitsSummary.get_month.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldAppear__VisitsSummary.get_month.xml
new file mode 100644
index 0000000000..b445490f4b
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldAppear__VisitsSummary.get_month.xml
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="2010-03">
+ <nb_uniq_visitors>2</nb_uniq_visitors>
+ <nb_users>1</nb_users>
+ <nb_visits>2</nb_visits>
+ <nb_actions>12</nb_actions>
+ <nb_visits_converted>0</nb_visits_converted>
+ <bounce_count>0</bounce_count>
+ <sum_visit_length>2</sum_visit_length>
+ <max_actions>6</max_actions>
+ <bounce_rate>0%</bounce_rate>
+ <nb_actions_per_visit>6</nb_actions_per_visit>
+ <avg_time_on_site>1</avg_time_on_site>
+ </result>
+ <result date="2010-04" />
+ <result date="2010-05" />
+ <result date="2010-06" />
+ <result date="2010-07" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldNotAppear__Actions.getPageUrls_month.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldNotAppear__Actions.getPageUrls_month.xml
new file mode 100644
index 0000000000..d4056f1f70
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldNotAppear__Actions.getPageUrls_month.xml
@@ -0,0 +1,109 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="2010-03">
+ <row>
+ <label>category</label>
+ <nb_visits>3</nb_visits>
+ <nb_hits>3</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>1</entry_nb_visits>
+ <entry_nb_actions>6</entry_nb_actions>
+ <entry_sum_visit_length>1</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <subtable>
+ <row>
+ <label>/Page1</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>1</entry_nb_visits>
+ <entry_nb_actions>6</entry_nb_actions>
+ <entry_sum_visit_length>1</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <sum_daily_entry_nb_uniq_visitors>1</sum_daily_entry_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page1</url>
+ </row>
+ <row>
+ <label>/Page2</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page2</url>
+ </row>
+ <row>
+ <label>/Page3</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page3</url>
+ </row>
+ </subtable>
+ </row>
+ <row>
+ <label>/Contact</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/Contact</url>
+ </row>
+ <row>
+ <label>/Home</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/Home</url>
+ </row>
+ <row>
+ <label>Contact</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <exit_nb_visits>1</exit_nb_visits>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>100%</exit_rate>
+ <subtable>
+ <row>
+ <label>/ThankYou</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <exit_nb_visits>1</exit_nb_visits>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <sum_daily_exit_nb_uniq_visitors>1</sum_daily_exit_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>100%</exit_rate>
+ <url>http://example.org/Contact/ThankYou</url>
+ </row>
+ </subtable>
+ </row>
+ </result>
+ <result date="2010-04" />
+ <result date="2010-05" />
+ <result date="2010-06" />
+ <result date="2010-07" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldNotAppear__VisitsSummary.get_month.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldNotAppear__VisitsSummary.get_month.xml
new file mode 100644
index 0000000000..b19f6f9e63
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite1_NewDataShouldNotAppear__VisitsSummary.get_month.xml
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="2010-03">
+ <nb_uniq_visitors>1</nb_uniq_visitors>
+ <nb_users>1</nb_users>
+ <nb_visits>1</nb_visits>
+ <nb_actions>6</nb_actions>
+ <nb_visits_converted>0</nb_visits_converted>
+ <bounce_count>0</bounce_count>
+ <sum_visit_length>1</sum_visit_length>
+ <max_actions>6</max_actions>
+ <bounce_rate>0%</bounce_rate>
+ <nb_actions_per_visit>6</nb_actions_per_visit>
+ <avg_time_on_site>1</avg_time_on_site>
+ </result>
+ <result date="2010-04" />
+ <result date="2010-05" />
+ <result date="2010-06" />
+ <result date="2010-07" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__Actions.getPageUrls_week.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__Actions.getPageUrls_week.xml
new file mode 100644
index 0000000000..bcd758b7c5
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__Actions.getPageUrls_week.xml
@@ -0,0 +1,73 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="From 2010-01-04 to 2010-01-10">
+ <row>
+ <label>category</label>
+ <nb_visits>6</nb_visits>
+ <nb_hits>9</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>2</entry_nb_visits>
+ <entry_nb_actions>18</entry_nb_actions>
+ <entry_sum_visit_length>2</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <subtable>
+ <row>
+ <label>/Page1</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>3</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>2</entry_nb_visits>
+ <entry_nb_actions>18</entry_nb_actions>
+ <entry_sum_visit_length>2</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+ <sum_daily_entry_nb_uniq_visitors>2</sum_daily_entry_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page1</url>
+ </row>
+ <row>
+ <label>/Page2</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>3</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page2</url>
+ </row>
+ <row>
+ <label>/NewPage</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>2</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/NewPage</url>
+ </row>
+ <row>
+ <label>/Page3</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page3</url>
+ </row>
+ </subtable>
+ </row>
+ </result>
+ <result date="From 2010-01-11 to 2010-01-17" />
+ <result date="From 2010-01-18 to 2010-01-24" />
+ <result date="From 2010-01-25 to 2010-01-31" />
+ <result date="From 2010-02-01 to 2010-02-07" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__VisitsSummary.get_week.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__VisitsSummary.get_week.xml
new file mode 100644
index 0000000000..c494788d70
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__VisitsSummary.get_week.xml
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="From 2010-01-04 to 2010-01-10">
+ <nb_uniq_visitors>2</nb_uniq_visitors>
+ <nb_users>1</nb_users>
+ <nb_visits>2</nb_visits>
+ <nb_actions>18</nb_actions>
+ <nb_visits_converted>0</nb_visits_converted>
+ <bounce_count>0</bounce_count>
+ <sum_visit_length>2</sum_visit_length>
+ <max_actions>12</max_actions>
+ <bounce_rate>0%</bounce_rate>
+ <nb_actions_per_visit>9</nb_actions_per_visit>
+ <avg_time_on_site>1</avg_time_on_site>
+ </result>
+ <result date="From 2010-01-11 to 2010-01-17" />
+ <result date="From 2010-01-18 to 2010-01-24" />
+ <result date="From 2010-01-25 to 2010-01-31" />
+ <result date="From 2010-02-01 to 2010-02-07" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldAppear__Actions.getPageUrls_month.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldAppear__Actions.getPageUrls_month.xml
new file mode 100644
index 0000000000..ad5d8b5c44
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldAppear__Actions.getPageUrls_month.xml
@@ -0,0 +1,73 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="2010-01">
+ <row>
+ <label>category</label>
+ <nb_visits>6</nb_visits>
+ <nb_hits>9</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>2</entry_nb_visits>
+ <entry_nb_actions>18</entry_nb_actions>
+ <entry_sum_visit_length>2</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <subtable>
+ <row>
+ <label>/Page1</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>3</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>2</entry_nb_visits>
+ <entry_nb_actions>18</entry_nb_actions>
+ <entry_sum_visit_length>2</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+ <sum_daily_entry_nb_uniq_visitors>2</sum_daily_entry_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page1</url>
+ </row>
+ <row>
+ <label>/Page2</label>
+ <nb_visits>2</nb_visits>
+ <nb_hits>3</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>2</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page2</url>
+ </row>
+ <row>
+ <label>/NewPage</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>2</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/NewPage</url>
+ </row>
+ <row>
+ <label>/Page3</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page3</url>
+ </row>
+ </subtable>
+ </row>
+ </result>
+ <result date="2010-02" />
+ <result date="2010-03" />
+ <result date="2010-04" />
+ <result date="2010-05" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldAppear__VisitsSummary.get_month.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldAppear__VisitsSummary.get_month.xml
new file mode 100644
index 0000000000..847356998f
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldAppear__VisitsSummary.get_month.xml
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="2010-01">
+ <nb_uniq_visitors>2</nb_uniq_visitors>
+ <nb_users>1</nb_users>
+ <nb_visits>2</nb_visits>
+ <nb_actions>18</nb_actions>
+ <nb_visits_converted>0</nb_visits_converted>
+ <bounce_count>0</bounce_count>
+ <sum_visit_length>2</sum_visit_length>
+ <max_actions>12</max_actions>
+ <bounce_rate>0%</bounce_rate>
+ <nb_actions_per_visit>9</nb_actions_per_visit>
+ <avg_time_on_site>1</avg_time_on_site>
+ </result>
+ <result date="2010-02" />
+ <result date="2010-03" />
+ <result date="2010-04" />
+ <result date="2010-05" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__Actions.getPageUrls_week.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__Actions.getPageUrls_week.xml
new file mode 100644
index 0000000000..3f580dfcf7
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__Actions.getPageUrls_week.xml
@@ -0,0 +1,62 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="From 2010-01-04 to 2010-01-10">
+ <row>
+ <label>category</label>
+ <nb_visits>3</nb_visits>
+ <nb_hits>3</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>1</entry_nb_visits>
+ <entry_nb_actions>6</entry_nb_actions>
+ <entry_sum_visit_length>1</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <subtable>
+ <row>
+ <label>/Page1</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>1</entry_nb_visits>
+ <entry_nb_actions>6</entry_nb_actions>
+ <entry_sum_visit_length>1</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <sum_daily_entry_nb_uniq_visitors>1</sum_daily_entry_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page1</url>
+ </row>
+ <row>
+ <label>/Page2</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page2</url>
+ </row>
+ <row>
+ <label>/Page3</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page3</url>
+ </row>
+ </subtable>
+ </row>
+ </result>
+ <result date="From 2010-01-11 to 2010-01-17" />
+ <result date="From 2010-01-18 to 2010-01-24" />
+ <result date="From 2010-01-25 to 2010-01-31" />
+ <result date="From 2010-02-01 to 2010-02-07" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__VisitsSummary.get_week.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__VisitsSummary.get_week.xml
new file mode 100644
index 0000000000..85a94d8af8
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear_BecauseWeekWasNotInvalidated__VisitsSummary.get_week.xml
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="From 2010-01-04 to 2010-01-10">
+ <nb_uniq_visitors>1</nb_uniq_visitors>
+ <nb_users>1</nb_users>
+ <nb_visits>1</nb_visits>
+ <nb_actions>6</nb_actions>
+ <nb_visits_converted>0</nb_visits_converted>
+ <bounce_count>0</bounce_count>
+ <sum_visit_length>1</sum_visit_length>
+ <max_actions>6</max_actions>
+ <bounce_rate>0%</bounce_rate>
+ <nb_actions_per_visit>6</nb_actions_per_visit>
+ <avg_time_on_site>1</avg_time_on_site>
+ </result>
+ <result date="From 2010-01-11 to 2010-01-17" />
+ <result date="From 2010-01-18 to 2010-01-24" />
+ <result date="From 2010-01-25 to 2010-01-31" />
+ <result date="From 2010-02-01 to 2010-02-07" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear__Actions.getPageUrls_month.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear__Actions.getPageUrls_month.xml
new file mode 100644
index 0000000000..80d2fcadd7
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear__Actions.getPageUrls_month.xml
@@ -0,0 +1,62 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="2010-01">
+ <row>
+ <label>category</label>
+ <nb_visits>3</nb_visits>
+ <nb_hits>3</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>1</entry_nb_visits>
+ <entry_nb_actions>6</entry_nb_actions>
+ <entry_sum_visit_length>1</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <subtable>
+ <row>
+ <label>/Page1</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <entry_nb_visits>1</entry_nb_visits>
+ <entry_nb_actions>6</entry_nb_actions>
+ <entry_sum_visit_length>1</entry_sum_visit_length>
+ <entry_bounce_count>0</entry_bounce_count>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <sum_daily_entry_nb_uniq_visitors>1</sum_daily_entry_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page1</url>
+ </row>
+ <row>
+ <label>/Page2</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page2</url>
+ </row>
+ <row>
+ <label>/Page3</label>
+ <nb_visits>1</nb_visits>
+ <nb_hits>1</nb_hits>
+ <sum_time_spent>0</sum_time_spent>
+ <sum_daily_nb_uniq_visitors>1</sum_daily_nb_uniq_visitors>
+ <avg_time_on_page>0</avg_time_on_page>
+ <bounce_rate>0%</bounce_rate>
+ <exit_rate>0%</exit_rate>
+ <url>http://example.org/category/Page3</url>
+ </row>
+ </subtable>
+ </row>
+ </result>
+ <result date="2010-02" />
+ <result date="2010-03" />
+ <result date="2010-04" />
+ <result date="2010-05" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear__VisitsSummary.get_month.xml b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear__VisitsSummary.get_month.xml
new file mode 100644
index 0000000000..cbe0ead9bb
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_Archive_InvalidationWebsite2_NewDataShouldNotAppear__VisitsSummary.get_month.xml
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result date="2010-01">
+ <nb_uniq_visitors>1</nb_uniq_visitors>
+ <nb_users>1</nb_users>
+ <nb_visits>1</nb_visits>
+ <nb_actions>6</nb_actions>
+ <nb_visits_converted>0</nb_visits_converted>
+ <bounce_count>0</bounce_count>
+ <sum_visit_length>1</sum_visit_length>
+ <max_actions>6</max_actions>
+ <bounce_rate>0%</bounce_rate>
+ <nb_actions_per_visit>6</nb_actions_per_visit>
+ <avg_time_on_site>1</avg_time_on_site>
+ </result>
+ <result date="2010-02" />
+ <result date="2010-03" />
+ <result date="2010-04" />
+ <result date="2010-05" />
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml
new file mode 100644
index 0000000000..d98cace554
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+ <result idSite="1">
+ <result date="2010-01-01" />
+ <result date="2010-01-02" />
+ <result date="2010-01-03">
+ <row>
+ <col name="label">this search term</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="2. Yokohama, Kanagawa, Japan">1</col>
+ <col name="3. Melbourne, Victoria, Australia">2</col>
+ </row>
+ <row>
+ <col name="label">search term 2</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="2. Yokohama, Kanagawa, Japan">2</col>
+ <col name="3. Melbourne, Victoria, Australia">0</col>
+ </row>
+ <row>
+ <col name="label">search term 3</col>
+ <col name="1. Toronto, Ontario, Canada">2</col>
+ <col name="2. Yokohama, Kanagawa, Japan">0</col>
+ <col name="3. Melbourne, Victoria, Australia">0</col>
+ </row>
+ <row>
+ <col name="label">search term 4</col>
+ <col name="1. Toronto, Ontario, Canada">2</col>
+ <col name="2. Yokohama, Kanagawa, Japan">0</col>
+ <col name="3. Melbourne, Victoria, Australia">0</col>
+ </row>
+ <row>
+ <col name="label">that search term</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="2. Yokohama, Kanagawa, Japan">0</col>
+ <col name="3. Melbourne, Victoria, Australia">2</col>
+ </row>
+ <row>
+ <col name="label">search term 1</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="2. Yokohama, Kanagawa, Japan">1</col>
+ <col name="3. Melbourne, Victoria, Australia">0</col>
+ </row>
+ </result>
+ <result date="2010-01-04" />
+ <result date="2010-01-05" />
+ <result date="2010-01-06" />
+ <result date="2010-01-07" />
+ </result>
+</results> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..05553ef4f8
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml
@@ -0,0 +1,33 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+ <row>
+ <label>this search term</label>
+ <Google>1</Google>
+ <Bing>0</Bing>
+ </row>
+ <row>
+ <label>search term 2</label>
+ <Google>0</Google>
+ <Bing>0</Bing>
+ </row>
+ <row>
+ <label>search term 3</label>
+ <Google>1</Google>
+ <Bing>0</Bing>
+ </row>
+ <row>
+ <label>search term 4</label>
+ <Google>0</Google>
+ <Bing>1</Bing>
+ </row>
+ <row>
+ <label>that search term</label>
+ <Google>1</Google>
+ <Bing>0</Bing>
+ </row>
+ <row>
+ <label>search term 1</label>
+ <Google>0</Google>
+ <Bing>1</Bing>
+ </row>
+</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithColumnLimiting__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithColumnLimiting__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..ac43686db0
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithColumnLimiting__Referrers.getKeywords_week.xml
@@ -0,0 +1,33 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+ <row>
+ <col name="label">this search term</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="Others">3</col>
+ </row>
+ <row>
+ <col name="label">search term 2</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="Others">2</col>
+ </row>
+ <row>
+ <col name="label">search term 3</col>
+ <col name="1. Toronto, Ontario, Canada">2</col>
+ <col name="Others">0</col>
+ </row>
+ <row>
+ <col name="label">search term 4</col>
+ <col name="1. Toronto, Ontario, Canada">2</col>
+ <col name="Others">0</col>
+ </row>
+ <row>
+ <col name="label">that search term</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="Others">2</col>
+ </row>
+ <row>
+ <col name="label">search term 1</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="Others">1</col>
+ </row>
+</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithCsvOutput__Referrers.getKeywords_week.csv b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithCsvOutput__Referrers.getKeywords_week.csv
new file mode 100644
index 0000000000..a465a67a14
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithCsvOutput__Referrers.getKeywords_week.csv
Binary files differ
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithJsonOutput__Referrers.getKeywords_week.json b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithJsonOutput__Referrers.getKeywords_week.json
new file mode 100644
index 0000000000..25e1824fc6
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithJsonOutput__Referrers.getKeywords_week.json
@@ -0,0 +1 @@
+[{"label":"this search term","1.\u00a0Toronto, Ontario, Canada":false,"2.\u00a0Yokohama, Kanagawa, Japan":1,"3.\u00a0Melbourne, Victoria, Australia":2},{"label":"search term 2","1.\u00a0Toronto, Ontario, Canada":false,"2.\u00a0Yokohama, Kanagawa, Japan":2,"3.\u00a0Melbourne, Victoria, Australia":false},{"label":"search term 3","1.\u00a0Toronto, Ontario, Canada":2,"2.\u00a0Yokohama, Kanagawa, Japan":false,"3.\u00a0Melbourne, Victoria, Australia":false},{"label":"search term 4","1.\u00a0Toronto, Ontario, Canada":2,"2.\u00a0Yokohama, Kanagawa, Japan":false,"3.\u00a0Melbourne, Victoria, Australia":false},{"label":"that search term","1.\u00a0Toronto, Ontario, Canada":false,"2.\u00a0Yokohama, Kanagawa, Japan":false,"3.\u00a0Melbourne, Victoria, Australia":2},{"label":"search term 1","1.\u00a0Toronto, Ontario, Canada":false,"2.\u00a0Yokohama, Kanagawa, Japan":1,"3.\u00a0Melbourne, Victoria, Australia":false}] \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml
new file mode 100644
index 0000000000..0b88c2ff59
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml
@@ -0,0 +1,123 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+ <row>
+ <col name="label">0</col>
+ <col name="1. /index">1</col>
+ <col name="2. /14">0</col>
+ <col name="3. /13">0</col>
+ <col name="4. /12">0</col>
+ <col name="5. /11">0</col>
+ <col name="6. /15">0</col>
+ <col name="7. /16">0</col>
+ <col name="8. /19">0</col>
+ <col name="9. /18">0</col>
+ <col name="10. /17">0</col>
+ <col name="11. /10">0</col>
+ <col name="12. /9">0</col>
+ <col name="13. /3">1</col>
+ <col name="14. /2">1</col>
+ <col name="15. /1">1</col>
+ <col name="16. /4">0</col>
+ <col name="17. /5">0</col>
+ <col name="18. /8">0</col>
+ <col name="19. /7">0</col>
+ <col name="20. /6">0</col>
+ <col name="21. /0">1</col>
+ </row>
+ <row>
+ <col name="label">1</col>
+ <col name="1. /index">1</col>
+ <col name="2. /14">0</col>
+ <col name="3. /13">0</col>
+ <col name="4. /12">0</col>
+ <col name="5. /11">0</col>
+ <col name="6. /15">0</col>
+ <col name="7. /16">0</col>
+ <col name="8. /19">0</col>
+ <col name="9. /18">0</col>
+ <col name="10. /17">0</col>
+ <col name="11. /10">0</col>
+ <col name="12. /9">0</col>
+ <col name="13. /3">0</col>
+ <col name="14. /2">0</col>
+ <col name="15. /1">0</col>
+ <col name="16. /4">1</col>
+ <col name="17. /5">1</col>
+ <col name="18. /8">0</col>
+ <col name="19. /7">1</col>
+ <col name="20. /6">1</col>
+ <col name="21. /0">0</col>
+ </row>
+ <row>
+ <col name="label">2</col>
+ <col name="1. /index">1</col>
+ <col name="2. /14">0</col>
+ <col name="3. /13">0</col>
+ <col name="4. /12">0</col>
+ <col name="5. /11">1</col>
+ <col name="6. /15">0</col>
+ <col name="7. /16">0</col>
+ <col name="8. /19">0</col>
+ <col name="9. /18">0</col>
+ <col name="10. /17">0</col>
+ <col name="11. /10">1</col>
+ <col name="12. /9">1</col>
+ <col name="13. /3">0</col>
+ <col name="14. /2">0</col>
+ <col name="15. /1">0</col>
+ <col name="16. /4">0</col>
+ <col name="17. /5">0</col>
+ <col name="18. /8">1</col>
+ <col name="19. /7">0</col>
+ <col name="20. /6">0</col>
+ <col name="21. /0">0</col>
+ </row>
+ <row>
+ <col name="label">3</col>
+ <col name="1. /index">1</col>
+ <col name="2. /14">1</col>
+ <col name="3. /13">1</col>
+ <col name="4. /12">1</col>
+ <col name="5. /11">0</col>
+ <col name="6. /15">1</col>
+ <col name="7. /16">0</col>
+ <col name="8. /19">0</col>
+ <col name="9. /18">0</col>
+ <col name="10. /17">0</col>
+ <col name="11. /10">0</col>
+ <col name="12. /9">0</col>
+ <col name="13. /3">0</col>
+ <col name="14. /2">0</col>
+ <col name="15. /1">0</col>
+ <col name="16. /4">0</col>
+ <col name="17. /5">0</col>
+ <col name="18. /8">0</col>
+ <col name="19. /7">0</col>
+ <col name="20. /6">0</col>
+ <col name="21. /0">0</col>
+ </row>
+ <row>
+ <col name="label">4</col>
+ <col name="1. /index">1</col>
+ <col name="2. /14">0</col>
+ <col name="3. /13">0</col>
+ <col name="4. /12">0</col>
+ <col name="5. /11">0</col>
+ <col name="6. /15">0</col>
+ <col name="7. /16">1</col>
+ <col name="8. /19">1</col>
+ <col name="9. /18">1</col>
+ <col name="10. /17">1</col>
+ <col name="11. /10">0</col>
+ <col name="12. /9">0</col>
+ <col name="13. /3">0</col>
+ <col name="14. /2">0</col>
+ <col name="15. /1">0</col>
+ <col name="16. /4">0</col>
+ <col name="17. /5">0</col>
+ <col name="18. /8">0</col>
+ <col name="19. /7">0</col>
+ <col name="20. /6">0</col>
+ <col name="21. /0">0</col>
+ </row>
+</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable_WhenSegmentUsedInRequest__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable_WhenSegmentUsedInRequest__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..52686d6610
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable_WhenSegmentUsedInRequest__Referrers.getKeywords_week.xml
@@ -0,0 +1,11 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+ <row>
+ <col name="label">that search term</col>
+ <col name="1. Melbourne, Victoria, Australia">2</col>
+ </row>
+ <row>
+ <col name="label">this search term</col>
+ <col name="1. Melbourne, Victoria, Australia">2</col>
+ </row>
+</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..8112e991f5
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+ <row>
+ <col name="label">this search term</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="2. Yokohama, Kanagawa, Japan">1</col>
+ <col name="3. Melbourne, Victoria, Australia">2</col>
+ </row>
+ <row>
+ <col name="label">search term 2</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="2. Yokohama, Kanagawa, Japan">2</col>
+ <col name="3. Melbourne, Victoria, Australia">0</col>
+ </row>
+ <row>
+ <col name="label">search term 3</col>
+ <col name="1. Toronto, Ontario, Canada">2</col>
+ <col name="2. Yokohama, Kanagawa, Japan">0</col>
+ <col name="3. Melbourne, Victoria, Australia">0</col>
+ </row>
+ <row>
+ <col name="label">search term 4</col>
+ <col name="1. Toronto, Ontario, Canada">2</col>
+ <col name="2. Yokohama, Kanagawa, Japan">0</col>
+ <col name="3. Melbourne, Victoria, Australia">0</col>
+ </row>
+ <row>
+ <col name="label">that search term</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="2. Yokohama, Kanagawa, Japan">0</col>
+ <col name="3. Melbourne, Victoria, Australia">2</col>
+ </row>
+ <row>
+ <col name="label">search term 1</col>
+ <col name="1. Toronto, Ontario, Canada">0</col>
+ <col name="2. Yokohama, Kanagawa, Japan">1</col>
+ <col name="3. Melbourne, Victoria, Australia">0</col>
+ </row>
+</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable_WhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable_WhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..6ab5630422
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable_WhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+ <row>
+ <col name="label">this search term</col>
+ <col name="1. Google">1</col>
+ <col name="2. Yahoo!">1</col>
+ <col name="3. Ask">1</col>
+ <col name="4. Bing">0</col>
+ <col name="5. Alexa">0</col>
+ <col name="6. Babylon">0</col>
+ </row>
+ <row>
+ <col name="label">search term 2</col>
+ <col name="1. Google">0</col>
+ <col name="2. Yahoo!">0</col>
+ <col name="3. Ask">0</col>
+ <col name="4. Bing">0</col>
+ <col name="5. Alexa">1</col>
+ <col name="6. Babylon">1</col>
+ </row>
+ <row>
+ <col name="label">search term 3</col>
+ <col name="1. Google">1</col>
+ <col name="2. Yahoo!">0</col>
+ <col name="3. Ask">1</col>
+ <col name="4. Bing">0</col>
+ <col name="5. Alexa">0</col>
+ <col name="6. Babylon">0</col>
+ </row>
+ <row>
+ <col name="label">search term 4</col>
+ <col name="1. Google">0</col>
+ <col name="2. Yahoo!">1</col>
+ <col name="3. Ask">0</col>
+ <col name="4. Bing">1</col>
+ <col name="5. Alexa">0</col>
+ <col name="6. Babylon">0</col>
+ </row>
+ <row>
+ <col name="label">that search term</col>
+ <col name="1. Google">1</col>
+ <col name="2. Yahoo!">1</col>
+ <col name="3. Ask">0</col>
+ <col name="4. Bing">0</col>
+ <col name="5. Alexa">0</col>
+ <col name="6. Babylon">0</col>
+ </row>
+ <row>
+ <col name="label">search term 1</col>
+ <col name="1. Google">0</col>
+ <col name="2. Yahoo!">0</col>
+ <col name="3. Ask">0</col>
+ <col name="4. Bing">1</col>
+ <col name="5. Alexa">0</col>
+ <col name="6. Babylon">0</col>
+ </row>
+</result> \ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..1adf9d722a
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+ <row>
+ <col name="label">this search term</col>
+ <col name="Google">1</col>
+ <col name="Yahoo!">1</col>
+ <col name="Ask">1</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
+ </row>
+ <row>
+ <col name="label">search term 2</col>
+ <col name="Google">0</col>
+ <col name="Yahoo!">0</col>
+ <col name="Ask">0</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">1</col>
+ <col name="Babylon">1</col>
+ </row>
+ <row>
+ <col name="label">search term 3</col>
+ <col name="Google">1</col>
+ <col name="Yahoo!">0</col>
+ <col name="Ask">1</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
+ </row>
+ <row>
+ <col name="label">search term 4</col>
+ <col name="Google">0</col>
+ <col name="Yahoo!">1</col>
+ <col name="Ask">0</col>
+ <col name="Bing">1</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
+ </row>
+ <row>
+ <col name="label">that search term</col>
+ <col name="Google">1</col>
+ <col name="Yahoo!">1</col>
+ <col name="Ask">0</col>
+ <col name="Bing">0</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
+ </row>
+ <row>
+ <col name="label">search term 1</col>
+ <col name="Google">0</col>
+ <col name="Yahoo!">0</col>
+ <col name="Ask">0</col>
+ <col name="Bing">1</col>
+ <col name="Alexa">0</col>
+ <col name="Babylon">0</col>
+ </row>
+</result> \ No newline at end of file