; WhatsChanged-AdwordCampaign.XLS - for Excel
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

WhatsChanged-AdwordCampaign.XLS - for Excel

VIEWS: 16 PAGES: 29

  • pg 1
									Adword Campaign What's Changed Report
Showing changes in web site traffic for various segments
This reports show past 14 days compared to previous 14 days. Delta must be larger than 0.5% to show here.



Overview
                       site metrics                         Prior    Current       Net      Growth
                                                           Period     Period    Change
                          visitors                             321       609         288       90%
                           visits                              448       908         460      103%
                         pageviews                             809     2,402       1,593      197%


Increase of visits by campaign
                         campaign                             Was        Now        Delta
                        GA in Excel                             0         976      13.6%
                        Pivot tables                            0         125       1.7%




Sub-Totals for these segments:                                   0       1101

Increase of visits by source
                            source                            Was        Now       Delta
                             bing                               3         179      2.5%
                            yahoo                             177         281      2.2%
                        google.com                             33         168      2.0%
                          live.com                             84         191      1.8%
                           (direct)                          2270        1751      1.8%
                   areyoureadingthis.com                        0         115      1.6%
                     analyticsedge.com                          6          82      1.1%



Sub-Totals for these segments:                               2573        2767
Increase of pageviews by landingPagePath
                     landingPagePath                          Was        Now       Delta
             /Nextanalytics-for-Google-Analytics                0        1594      9.5%
                   /Product/Dashboards                          0         236      1.4%
                       /Default.aspx                            0         213      1.3%
                     /google-analytics                         88         234      1.2%
                         /download                            229         296      1.1%
                        /easy-to-use                          239         279      1.0%
Sub-Totals for these segments:                       556    2852
Increase of pageviews by pagePath
                          pagePath                    Was   Now    Delta
          /Nextanalytics-for-Google-Analytics.aspx      0   1549   9.3%
                              /                      7598   4770   7.9%
                       /Product.aspx                    0    467   2.8%
                      /Download.aspx                    0    438   2.6%
                       /Default.aspx                    0    332   2.0%
                      /Company.aspx                     0    216   1.3%




Sub-Totals for these segments:                       7598   7772
Increase of visits by keyword
                          keyword                     Was   Now     Delta
                      excel dashboards                290   1012   11.2%
                        nextanalytics                4360   3503    5.3%




Sub-Totals for these segments:                       4650   4515


Increase of visits by country
                          country                    Was    Now    Delta
                            Brazil                    57     275   3.2%
                           Greece                     14     125   1.6%
                          Pakistan                    13      82   1.0%




Sub-Totals for these segments:                        84    482
                                                    Update using the Next Analytics Refresh menu

5% to show here.                                                     Google Analytics Segment
                                                                     All Visits

                                                                                         Definitions




           Decrease of visits by campaign
                                     campaign                               Was   Now         Delta
                                  Product launch                           9492   5974      -11.5%
                                   Dashboards                               433      0       -4.3%




           Sub-Totals for these segments:                                  9925   5974

           Decrease of visits by source
                                       source                               Was   Now        Delta
                                   truebleu.ca                              347      0       -3.5%
                                      google                               5334   3619       -2.8%
                                   bogcne.com                               166      0       -1.7%
                                 mail.google.com                            158      8       -1.5%
                                    trivial.com                             114      0       -1.1%
                                  afterlife.co.uk                           108      0       -1.1%




           Sub-Totals for these segments:                                  6227   3627
           Decrease of pageviews by landingPagePath
                                landingPagePath                            Was    Now        Delta
                                       /                                 21645    9274       -3.3%
                                 /demo/video1                             1177       0       -3.2%
                           /download/installation-guide                    549       4       -1.5%
                                  /comparison                              883     158       -1.5%
Sub-Totals for these segments:              24254   9436
Decrease of pageviews by pagePath
                         pagePath            Was    Now    Delta
                         /support           1271      57   -3.1%
                   /product/Product.html    2606     675   -3.0%




Sub-Totals for these segments:              3877    732
Decrease of visits by keyword
                           keyword           Was    Now    Delta
                    pivot table operation    802     362   -3.0%
                         orientation         223       9   -2.1%




Sub-Totals for these segments:              1025    371


Decrease of visits by country
                          country            Was    Now    Delta
                            Italy            395      73   -2.9%
                          Canada            3327    2200   -2.8%
                        United States       2876    1930   -2.1%




Sub-Totals for these segments:              6598    4203
;               This workbook requires the Next Analytics for Excel add-in. A free trial is available at:
;               http://www.nextanalytics.com
;
;                       Your Google Analytics account:
;
;                                               Password:
;
;                                     Website Profile ID:                               this is NOT your tracking number
;                                             What is this? http://analyticsedge.nextanalytics.com/2010/06/how-do-i-find-my-prof
;
;                                       Days per period:                     14
;                            Past 7 Days Start-End Dates:              2011-06-28               2011-07-11
;                                                                     now-start-date           now-end-date
;
;                         Sensitivity (smallest Delta %):                  0.5%         ADJUST THIS VALUE TO SUIT YOUR S
;
;                             Selections for ComboBox                 Descriptions                 ID's
;                                        These are all the All Visits                             gaid::-1
;                                     segments offered in New Visitors                            gaid::-2
;                                        Google Analytics Returning Visitors                      gaid::-3
;                                                             Paid Search Traffic                 gaid::-4
;                                                             Non-paid Search Traffic             gaid::-5
;                                                             Search Traffic                      gaid::-6
;                                                             Direct Traffic                      gaid::-7
;                                                             Referral Traffic                    gaid::-8
;                                                             Visits with Conversions             gaid::-9
;                                                             Visits with Transactions           gaid::-10
;                                                             Mobile Traffic                     gaid::-11
;                                                             Non-bounce Visits                  gaid::-12
;
;
; These are the Nextanalytics script commands that perform the Google Analytics query, load your data, and produce the analyz
; comment lines start with a semi-colon ( ; ). Text color is for convenience only.
uiSaveWorksheetTotxt,fixes,WhatsChanged_fixes.csv,[PAGES]
uiGetGoogleAnalyticsData
uiGetGoogleAnalyticsData
; import the previous period data
ImportDataFiles,"whatschanged-was.csv","nxrowlabel_was,nxnumeric_visitors,nxnumeric_visits,nxnumeric_pageviews",0,1,u
; swap axis so metrics are down the rows
Swap
ChangeLabelCaption,False,Column,*,Was
; label this 'page' in memory for reference
PageCaption,whatschanged-was
; do the same with the most recent period
ImportDataFiles,"whatschanged-now.csv","nxrowlabel_now,nxnumeric_visitors,nxnumeric_visits,nxnumeric_pageviews",0,1
Swap
ChangeLabelCaption,False,Column,*,Now
PageCaption,whatschanged-now
; calculate growth compared to previous period
Compare,ToAColumn,Growth,Actual,Column,,Was,-1,Was,0,0,False,True,whatschanged-was,
; Excel displays 1% for 0.01, so divide by 100
MathOperation,Divide,100,0,row,Actual
; copy delta column to current period page
ChangeLabelCaption,False,Column,*,Delta
select,column,First
MoveColumns,Copy,whatschanged-now,0,Last
; copy delta and now columns to previous period page
selectrange,column,0,2
MoveColumns,Copy,whatschanged-was,0,Last
; label this 'page' and display it in a worksheet 'data' at row 3, column 12
pagecaption,metrics
uiSaveInWorksheet,metrics,data,overwrite,invisible,3,12,unformatted

; dimension   country                                      metric              visits
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-country-now.csv,"nxrowlabel_country,nxnumeric_visits",0,1,utf-8,",",yyyy-MM-dd,en-CA,,""
ChangeLabelCaption,False,Column,*,Now
PageCaption,whatschanged-country-now
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-country-was.csv,"nxrowlabel_country,nxnumeric_visits",0,1,utf-8,",",yyyy-MM-dd,en-CA,,""
ChangeLabelCaption,False,Column,*,Was
select,column,First
MoveColumns,Copy,whatschanged-country-now,0,First
MathOperation,FillEmptyWithValue,0,0,row,Actual
pagecaption,country Base
; === Practical Significance Macro ===
; calculate the ratio to total for each column
Compare,ToAxis,Ratio,Sum,Column,,,-1,-1,0,0,False,False,Current,
; calculate the difference between the ratios
MathOperationOnTwoPositions,column,Was,Now,Subtract,BA,Delta
; copy the delta result to the base page
select,column,Last,
MoveColumns,Copy,country Base,0,Last
Sort,Delta,Descending
pagecaption,country all
; of the top 10, filter out anything below the sensitivity threshold
SelectRange,Row,0,10
KeepSelected
FilterByValue,KeepByVal,GreaterThan,Row,-1,Delta,False,0.005,0,True,Actual
PageCaption Increase of visits by country
; of the bottom 10, filter out anything above the sensitivity threshold
Select,Page,country all
ClearSelection,True,True
SelectRange,Row,Last,10
KeepSelected
Sort,Delta,Ascending
FilterByValue,KeepByVal,LessThan,Row,-1,Delta,False,-0.005,0,True,Actual
PageCaption Decrease of visits by country
; == end Practical Significance Macro ===
uisaveinworksheet,Increase of visits by country,data,nooverwrite,visible,3,2,unformatted
uisaveinworksheet,Decrease of visits by country,data,nooverwrite,visible,3,7,unformatted

; dimension   source                                   metric                     visits
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-source-now.csv,"nxrowlabel_source,nxnumeric_visits",0,1,utf-8,",",yyyy-MM-dd,en-CA,,""
ChangeLabelCaption,False,Column,*,Now
PageCaption,whatschanged-source-now
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-source-was.csv,"nxrowlabel_source,nxnumeric_visits",0,1,utf-8,",",yyyy-MM-dd,en-CA,,""
ChangeLabelCaption,False,Column,*,Was
select,column,First
MoveColumns,Copy,whatschanged-source-now,0,First
MathOperation,FillEmptyWithValue,0,0,row,Actual
pagecaption,source Base
; === Practical Significance Macro ===
; calculate the ratio to total for each column
Compare,ToAxis,Ratio,Sum,Column,,,-1,-1,0,0,False,False,Current,
; calculate the difference between the ratios
MathOperationOnTwoPositions,column,Was,Now,Subtract,BA,Delta
; copy the delta result to the base page
select,column,Last,
MoveColumns,Copy,source Base,0,Last
Sort,Delta,Descending
pagecaption,source all
; of the top 10, filter out anything below the sensitivity threshold
SelectRange,Row,0,10
KeepSelected
FilterByValue,KeepByVal,GreaterThan,Row,-1,Delta,False,0.005,0,True,Actual
PageCaption Increase of visits by source
; of the bottom 10, filter out anything above the sensitivity threshold
Select,Page,source all
ClearSelection,True,True
SelectRange,Row,Last,10
KeepSelected
Sort,Delta,Ascending
FilterByValue,KeepByVal,LessThan,Row,-1,Delta,False,-0.005,0,True,Actual
PageCaption Decrease of visits by source
; == end Practical Significance Macro ===
uisaveinworksheet,Increase of visits by source,data,nooverwrite,visible,16,2,unformatted
uisaveinworksheet,Decrease of visits by source,data,nooverwrite,visible,16,7,unformatted
; dimension   campaign                               metric                   visits
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-campaign-now.csv,"nxrowlabel_campaign,nxnumeric_visits",0,1,utf-8,",",yyyy-MM-dd,en-CA
ChangeLabelCaption,False,Column,*,Now
PageCaption,whatschanged-campaign-now
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-campaign-was.csv,"nxrowlabel_campaign,nxnumeric_visits",0,1,utf-8,",",yyyy-MM-dd,en-CA,
ChangeLabelCaption,False,Column,*,Was
select,column,First
MoveColumns,Copy,whatschanged-campaign-now,0,First
MathOperation,FillEmptyWithValue,0,0,row,Actual
pagecaption,campaign Base
; === Practical Significance Macro ===
; calculate the ratio to total for each column
Compare,ToAxis,Ratio,Sum,Column,,,-1,-1,0,0,False,False,Current,
; calculate the difference between the ratios
MathOperationOnTwoPositions,column,Was,Now,Subtract,BA,Delta
; copy the delta result to the base page
select,column,Last,
MoveColumns,Copy,campaign Base,0,Last
Sort,Delta,Descending
pagecaption,campaign all
; of the top 10, filter out anything below the sensitivity threshold
SelectRange,Row,0,10
KeepSelected
FilterByValue,KeepByVal,GreaterThan,Row,-1,Delta,False,0.005,0,True,Actual
PageCaption Increase of visits by campaign
; of the bottom 10, filter out anything above the sensitivity threshold
Select,Page,campaign all
ClearSelection,True,True
SelectRange,Row,Last,10
KeepSelected
Sort,Delta,Ascending
FilterByValue,KeepByVal,LessThan,Row,-1,Delta,False,-0.005,0,True,Actual
PageCaption Decrease of visits by campaign
; == end Practical Significance Macro ===
uisaveinworksheet,Increase of visits by campaign,data,nooverwrite,visible,29,2,unformatted
uisaveinworksheet,Decrease of visits by campaign,data,nooverwrite,visible,29,7,unformatted

; dimension   landingPagePath                        metric                   entrances
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-landingPagePath-now.csv,"nxrowlabel_landingPagePath,nxnumeric_entrances",0,1,utf-8,",",y
CombineDuplicates,Sum
Select,Column,First
RemoveSelected
ChangeLabelCaption,False,Column,*,Now
PageCaption,whatschanged-landingPagePath-now
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-landingPagePath-was.csv,"nxrowlabel_landingPagePath,nxnumeric_entrances",0,1,utf-8,",",y
CombineDuplicates,Sum
ChangeLabelCaption,False,Column,*,Was
select,column,Last,
MoveColumns,Copy,whatschanged-landingPagePath-now,0,First
MathOperation,FillEmptyWithValue,0,0,row,Actual
pagecaption,landingPagePath Base
; === Practical Significance Macro ===
; calculate the ratio to total for each column
Compare,ToAxis,Ratio,Sum,Column,,,-1,-1,0,0,False,False,Current,
; calculate the difference between the ratios
MathOperationOnTwoPositions,column,Was,Now,Subtract,BA,Delta
; copy the delta result to the base page
select,column,Last,
MoveColumns,Copy,landingPagePath Base,0,Last
Sort,Delta,Descending
pagecaption,landingPagePath all
; of the top 10, filter out anything below the sensitivity threshold
SelectRange,Row,0,10
KeepSelected
FilterByValue,KeepByVal,GreaterThan,Row,-1,Delta,False,0.005,0,True,Actual
PageCaption Increase of entrances by landingPagePath
; of the bottom 10, filter out anything above the sensitivity threshold
Select,Page,landingPagePath all
ClearSelection,True,True
SelectRange,Row,Last,10
KeepSelected
Sort,Delta,Ascending
FilterByValue,KeepByVal,LessThan,Row,-1,Delta,False,-0.005,0,True,Actual
PageCaption Decrease of entrances by landingPagePath
; == end Practical Significance Macro ===
uisaveinworksheet,Increase of entrances by landingPagePath,data,nooverwrite,visible,42,2,unformatted
uisaveinworksheet,Decrease of entrances by landingPagePath,data,nooverwrite,visible,42,7,unformatted

; dimension   pagePath                               metric                   pageviews
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-pagePath-now.csv,"nxrowlabel_pagePath,nxnumeric_pageviews",0,1,utf-8,",",yyyy-MM-dd,e
CombineDuplicates,Sum
Select,column,First
RemoveSelected
ChangeLabelCaption,False,Column,*,Now
PageCaption,whatschanged-pagePath-now
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-pagePath-was.csv,"nxrowlabel_pagePath,nxnumeric_pageviews",0,1,utf-8,",",yyyy-MM-dd,en
CombineDuplicates,Sum
ChangeLabelCaption,False,Column,*,Was
select,column,Last,
MoveColumns,Copy,whatschanged-pagePath-now,0,First
MathOperation,FillEmptyWithValue,0,0,row,Actual
pagecaption,pagePath Base
; === Practical Significance Macro ===
; calculate the ratio to total for each column
Compare,ToAxis,Ratio,Sum,Column,,,-1,-1,0,0,False,False,Current,
; calculate the difference between the ratios
MathOperationOnTwoPositions,column,Was,Now,Subtract,BA,Delta
; copy the delta result to the base page
select,column,Last,
MoveColumns,Copy,pagePath Base,0,Last
Sort,Delta,Descending
pagecaption,pagePath all
; of the top 10, filter out anything below the sensitivity threshold
SelectRange,Row,0,10
KeepSelected
FilterByValue,KeepByVal,GreaterThan,Row,-1,Delta,False,0.005,0,True,Actual
PageCaption Increase of pageviews by pagePath
; of the bottom 10, filter out anything above the sensitivity threshold
Select,Page,pagePath all
ClearSelection,True,True
SelectRange,Row,Last,10
KeepSelected
Sort,Delta,Ascending
FilterByValue,KeepByVal,LessThan,Row,-1,Delta,False,-0.005,0,True,Actual
PageCaption Decrease of pageviews by pagePath
; == end Practical Significance Macro ===
uisaveinworksheet,Increase of pageviews by pagePath,data,nooverwrite,visible,55,2,unformatted
uisaveinworksheet,Decrease of pageviews by pagePath,data,nooverwrite,visible,55,7,unformatted

; dimension   keyword                                metric                    visits
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-keyword-now.csv,"nxrowlabel_keyword,nxnumeric_visits",0,1,utf-8,",",yyyy-MM-dd,en-CA,,"
; remove all single instance keywords
FilterByValue,RemoveByVal,Equal,Row,-1,visits,false,0,1,true,Actual

ChangeLabelCaption,False,Column,*,Now
PageCaption,whatschanged-keyword-now
uiGetGoogleAnalyticsData
ImportDataFiles,whatschanged-keyword-was.csv,"nxrowlabel_keyword,nxnumeric_visits",0,1,utf-8,",",yyyy-MM-dd,en-CA,,""
FilterByValue,RemoveByVal,Equal,Row,-1,visits,false,0,1,true,Actual

ChangeLabelCaption,False,Column,*,Was
select,column,First
MoveColumns,Copy,whatschanged-keyword-now,0,First
MathOperation,FillEmptyWithValue,0,0,row,Actual
pagecaption,keyword Base
; calculate the ratio to total for each column
Compare,ToAxis,Ratio,Sum,Column,,,-1,-1,0,0,False,False,Current,
; remove the single keyword subtotal row and calculate the difference between the ratios
Select,Row,First
RemoveSelected
RepeatingCalculation,Diff
Select,column,Last
Keepselected
ChangeLabelCaption,False,Column,*,Delta
; keep only the top and bottom 10 rows; we won't report any more than this
Sort,Delta,Descending
SelectRange,Row,0,10
SelectRange,Row,Last,10
KeepSelected
pagecaption,keyword all
; keep the matching rows and copy over the Was and Now columns
select,page,keyword Base
SelectByCaptions,JustSelect,Row,-1,True,keyword all,False,,False,ExactMatch,0,
KeepSelected
invertselection,false,true
MoveColumns,Copy,keyword all,0,First
pagecaption,TopAndBottom 10
; keep rows over the sensitivity threshold
FilterByValue,RemoveByVal,LessThan,Row,-1,Delta,false,0.005,0,True,Actual
PageCaption Increase of visits by keyword
Select,page,TopAndBottom 10
Sort,Delta,Ascending
FilterByValue,RemoveByVal,GreaterThan,Row,-1,Delta,false,-0.005,0,True,Actual
PageCaption Decrease of visits by keyword
uisaveinworksheet,Increase of visits by keyword,data,nooverwrite,visible,68,2,unformatted
uisaveinworksheet,Decrease of visits by keyword,data,nooverwrite,visible,68,7,unformatted
e trial is available at:




ur tracking number
0/06/how-do-i-find-my-profile-id/



                    2011-06-14                2011-06-27
                   was-start-date            was-end-date

VALUE TO SUIT YOUR SITE. If you set it too high, nothing will appear.

             Selected Index            Selected ID
                         1                      gaid::-1




ta, and produce the analyzed results for the dashboard



             no                        whatschanged-now.csv      &metrics=ga:visitors,ga:visits,ga:pageviews&segment=gaid::-1&max-res
             no                        whatschanged-was.csv      &metrics=ga:visitors,ga:visits,ga:pageviews&segment=gaid::-1&max-res

xnumeric_pageviews",0,1,utf-8,",",yyyy-MM-dd,en-CA,,""




xnumeric_pageviews",0,1,utf-8,",",yyyy-MM-dd,en-CA,,""
           no                                     &dimensions=ga:country&metrics=ga:visits&segment=gaid::-1&max-re
                           whatschanged-country-now.csv
",",yyyy-MM-dd,en-CA,,""


           no                                     &dimensions=ga:country&metrics=ga:visits&segment=gaid::-1&max-re
                           whatschanged-country-was.csv
,",yyyy-MM-dd,en-CA,,""
          no                                   &dimensions=ga:source&metrics=ga:visits&segment=gaid::-1&max-res
                        whatschanged-source-now.csv
,yyyy-MM-dd,en-CA,,""


         no                                     &dimensions=ga:source&metrics=ga:visits&segment=gaid::-1&max-res
                        whatschanged-source-was.csv
yyyy-MM-dd,en-CA,,""
             no                                           &dimensions=ga:campaign&metrics=ga:visits&segment=gaid::-1&max-
                                   whatschanged-campaign-now.csv
f-8,",",yyyy-MM-dd,en-CA,,""


            no                                            &dimensions=ga:campaign&metrics=ga:visits&segment=gaid::-1&max-
                                   whatschanged-campaign-was.csv
-8,",",yyyy-MM-dd,en-CA,,""




            no                                                &dimensions=ga:landingPagePath&metrics=ga:entrances&segment=ga
                                      whatschanged-landingPagePath-now.csv
c_entrances",0,1,utf-8,",",yyyy-MM-dd,en-CA,,"WhatsChanged_fixes.csv"
           no                                                &dimensions=ga:landingPagePath&metrics=ga:entrances&segment=ga
                                     whatschanged-landingPagePath-was.csv
_entrances",0,1,utf-8,",",yyyy-MM-dd,en-CA,,"WhatsChanged_fixes.csv"




              no                                           &dimensions=ga:pagePath&metrics=ga:pageviews&segment=gaid::-1&
                                    whatschanged-pagePath-now.csv
,1,utf-8,",",yyyy-MM-dd,en-CA,,"WhatsChanged_fixes.csv"




              no                                            &dimensions=ga:pagePath&metrics=ga:pageviews&segment=gaid::-1&
                                     whatschanged-pagePath-was.csv
,1,utf-8,",",yyyy-MM-dd,en-CA,,"WhatsChanged_fixes.csv"
            no                                      &dimensions=ga:keyword&metrics=ga:visits&segment=gaid::-1&max-r
                             whatschanged-keyword-now.csv
8,",",yyyy-MM-dd,en-CA,,""




           no                                      &dimensions=ga:keyword&metrics=ga:visits&segment=gaid::-1&max-r
                             whatschanged-keyword-was.csv
,",",yyyy-MM-dd,en-CA,,""
gment=gaid::-1&max-results=1000000&start-date=2011-06-28&end-date=2011-07-11
gment=gaid::-1&max-results=1000000&start-date=2011-06-14&end-date=2011-06-27
egment=gaid::-1&max-results=1000000&start-date=2011-06-28&end-date=2011-07-11




egment=gaid::-1&max-results=1000000&start-date=2011-06-14&end-date=2011-06-27
gment=gaid::-1&max-results=1000000&start-date=2011-06-28&end-date=2011-07-11




gment=gaid::-1&max-results=1000000&start-date=2011-06-14&end-date=2011-06-27
&segment=gaid::-1&max-results=1000000&start-date=2011-06-28&end-date=2011-07-11




&segment=gaid::-1&max-results=1000000&start-date=2011-06-14&end-date=2011-06-27




 :entrances&segment=gaid::-1&max-results=1000000&start-date=2011-06-28&end-date=2011-07-11
:entrances&segment=gaid::-1&max-results=1000000&start-date=2011-06-14&end-date=2011-06-27




ews&segment=gaid::-1&max-results=1000000&start-date=2011-06-28&end-date=2011-07-11




ews&segment=gaid::-1&max-results=1000000&start-date=2011-06-14&end-date=2011-06-27
segment=gaid::-1&max-results=1000000&start-date=2011-06-28&end-date=2011-07-11




segment=gaid::-1&max-results=1000000&start-date=2011-06-14&end-date=2011-06-27
Increase of visits by country                      Decrease of visits by country

country     Was          Now        Delta          country    Was      Now
Brazil              57           275 0.032375      Italy           395       73
Greece              14           125 0.015907      Canada         3327     2200
Pakistan            13            82 0.010053      United States 2876      1930




Increase of visits by source                       Decrease of visits by source

source     Was        Now              Delta       source       Was      Now
bing                3            179    0.024724   truebleu.ca       347        0
yahoo            177             281    0.021574   google           5334     3619
google.com         33            168    0.020185   bogcne.com        166        0
live.com           84            191    0.018297   mail.google.com 158          8
(direct)        2270            1751    0.017656   trivial.com       114        0
                    0
areyoureadingthis.com            115    0.016077   afterlife.co.uk   108        0
analyticsedge.com 6               82    0.010863




Increase of visits by campaign                     Decrease of visits by campaign

campaign Was             Now        Delta          campaign Was        Now
GA in Excel          0           976 0.136446      Product launch 9492     5974
Pivot tables         0           125 0.017475      Dashboards      433        0




Increase of pageviews by landingPagePath           Decrease of pageviews by landingPagePath

           Was
landingPagePath       Now         Delta                      Was
                                                   landingPagePath       Now
                    0      1594
/Nextanalytics-for-Google-Analytics 0.09521        /             21645        9274
/Product/Dashboards 0       236 0.014096           /demo/video1 1177             0
/Default.aspx       0       213 0.012722                            549
                                                   /download/installation-guide 4
/google-analytics 88            234 0.011591   /comparison      883            158
/download        229            296 0.011472
/easy-to-use     239            279 0.010185




Increase of pageviews by pagePath              Decrease of pageviews by pagePath

pagePath Was          Now         Delta        pagePath Was          Now
                    0      1549 0.092522
/Nextanalytics-for-Google-Analytics.aspx       /support       1271        57
/                7598      4770 0.07896                       2606
                                               /product/Product.html     675
/Product.aspx       0       467 0.027894
/Download.aspx      0       438 0.026162
/Default.aspx       0       332 0.01983
/Company.aspx       0       216 0.012902




Increase of visits by keyword                  Decrease of visits by keyword

keyword Was          Now     Delta             keyword Was            Now
excel dashboards 290     1012 0.112491                            802
                                               pivot table operation      362
nextanalytics   4360     3503 0.052755         orientation        223       9
                       *         Was         Now       Delta
                       visitors        321          609 0.897196
           Delta       visits          448          908 1.026786
            -0.02942   pageviews       809         2402 1.969098
            -0.02827
            -0.02053




           Delta
            -0.03472
            -0.02778
            -0.01661
            -0.01469
            -0.01141
            -0.01081




           Delta
             -0.1146
            -0.04333




s by landingPagePath

           Delta
            -0.03287
            -0.03191
            -0.01464
                -0.0145




s by pagePath

           Delta
            -0.03105
            -0.03032




           Delta
             -0.0298
            -0.02111
remove_trailing_leading_whitespace,False
remove_periods,False
remove_commas,False
replace_underscore,False
convert_to_lower_case,True
convert_to_upper_case,False
convert_to_camel_case,False
pagePath,Regex,([^\?]*)\?(.*),$1
pagePath,Regex,(.+)/$,$1
landingPagePath,Regex,([^\?]*)\?(.*),$1
landingPagePath,Regex,(.+)/$,$1

								
To top