Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Excel Dashboard template

VIEWS: 211 PAGES: 15

									[Your logo/company name here]                                                   Web AnalyticsDashboard




               all include
                                                                              Current                  Previous       Same Month
               Site Statistics                                                                                                           Trend
                                                                               Month                     Month         of Last Year
                                                                                                                                                   31,207    5
                                                                  26,763                                24,451          12,968                               –
               Unique Visitors                                                      9%                                         106%
                                                                                                                                                   22,013    6
                                                                                                                                                   12,820
                                                                                                                                                   41,037    5
                                                                  35,346                                 32,843         18,294                               –
               Visits                                                               8%                                            93%
                                                                                                                                                   29,154    6
                                                                                                                                                   17,272
                                                                                                                                                       1.4   5
                                                                        1.3                                    1.3          1.4                              –
               Visits/Visitor                                                      -2%                                            -6%
                                                                                                                                                       1.3   6
                                                                                                                                                       1.3
                                                                                                                                                   3339%     5
                                                                     23.84                                  24.80         19.78                              –
               Bounce Rate                                                         -4%                                            21%
                                                                                                                                                   1754%     6
                                                                                                                                                    170%
                                                                                                                                                  253,160    5
                                                                 180,732                                174,296        180,868                               –
               unique pageviews                                                     4%                                             0%
                                                                                                                                                  190,341    6
                                                                                                                                                  127,522
                                                                                                                                                       8.8   5
                                                                        5.1                                    5.3          9.9                              –
               unique pageviews/Visit                                              -4%                                            -48%
                                                                                                                                                       6.8   6
                                                                                                                                                       4.7




                                                                         Current                       Previous       Same Month
               eCommerce                                                                                                                 Trend
                                                                          Month                          Month         of Last Year
                                                                                                                                                   32,072    5
                                                                   23,514                                21,415                0                             –
               Customers                                                           10%                                             0%
                                                                                                                                                   16,909    6
                                                                                                                                                    1,747
                                                                                                                                                    1,135    5
                                                                       593                                    657             0                              –
               Orders                                                             -10%                                             0%
                                                                                                                                                      517    6
                                                                                                                                                     -100
                                                                                                                                                    2,187    5
                                                                     1,267                                  1,288             0                              –
               Items                                                               -2%                                             0%
                                                                                                                                                    1,000    6
                                                                                                                                                     -187
                                                                                                                                                             5
                                                                        2.1        9%                          2.0      #DIV/0! ##                           –
               Items/Order                                                          9%                                       #DIV/0!
                                                                                                                                                  #DIV/0!    6

                                                                                                                                                             5
                                                       $          172.94          17%    $               147.86         #DIV/0! ##                           –
               Average Order Size                                                  17%                                       #DIV/0!
                                                                                                                                                  #DIV/0!    6




Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.                              1/153/7/2011 3:48 PM
[Your logo/company name here]                                                   Web AnalyticsDashboard




                                                                                                                                                   $161,892   5
                                                      $     102,551.69                   $           97,143.24        $         -                             –
               Revenues                                                             6%                                                0%
                                                                                                                                                    $76,580   6
                                                                                                                                                    -$8,732
                                                                                                                                                       3.2%   5
                                                                    1.68%                                  2.00%               0.0%                           –
               eCommerce Conversion                                               -16%                                                0%
                                                                                                                                                       1.5%   6
                                                                                                                                                      -0.2%




                                                                           Current                     Previous           Same Month
               Goal Conversions (%)                                                                                                        Trend
                                                                            Month                        Month             of Last Year
                                                                                                                                                        00    5
                                                                       0.00                                0.00                 0.00                          –
               Goal 1                                                               0%                                                0%
                                                                                                                                                        00    6
                                                                                                                                                        00
                                                                                                                                                        00    5
                                                                       0.00                                   0.00             0.00                           –
               Goal 2                                                               0%                                                0%
                                                                                                                                                        00    6
                                                                                                                                                        00
                                                                                                                                                        00    5
                                                                       0.00                                   0.00             0.00                           –
               Goal 3                                                               0%                                                0%
                                                                                                                                                        00    6
                                                                                                                                                        00
                                                                                                                                                      0.0%    5
                                                                       0.00                                   0.00             0.00                           –
               Goal 4                                                               0%                                                0%
                                                                                                                                                      0.0%    6
                                                                                                                                                      0.0%
                                                                                                                                                      0.0%    5
                                                                       0.00                                   0.00             0.00                           –
               Goal 5                                                               0%                                                0%
                                                                                                                                                      0.0%    6
                                                                                                                                                      0.0%




Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.                                2/153/7/2011 3:48 PM
Start Date     2009-01-01                        1
End Date       2010-06-30                     Year      Month
Profile Name   all include   January 2009     2009   January
                             February 2009    2009   February
                             March 2009       2009   March
                             April 2009       2009   April
                             May 2009         2009   May
                             June 2009        2009   June
                             July 2009        2009   July
                             August 2009      2009   August
                             September 2009   2009   September
                             October 2009     2009   October
                             November 2009    2009   November
                             December 2009    2009   December
                             January 2010     2010   January
                             February 2010    2010   February
                             March 2010       2010   March
                             April 2010       2010   April
                             May 2010         2010   May
                                            2
Visitor Type   Visits                    Year      Month       Visitor Type     Visits
New Visitor    11622    January 2009     2009   January     Returning Visitor    5415
New Visitor    11464    February 2009    2009   February    Returning Visitor    6169
New Visitor    11130    March 2009       2009   March       Returning Visitor    7164
New Visitor    10994    April 2009       2009   April       Returning Visitor    6850
New Visitor    12033    May 2009         2009   May         Returning Visitor    6701
New Visitor    13450    June 2009        2009   June        Returning Visitor    6592
New Visitor    20438    July 2009        2009   July        Returning Visitor    8350
New Visitor    20334    August 2009      2009   August      Returning Visitor    7702
New Visitor    22772    September 2009   2009   September   Returning Visitor    8952
New Visitor    23608    October 2009     2009   October     Returning Visitor   10615
New Visitor    25422    November 2009    2009   November    Returning Visitor   13081
New Visitor    25599    December 2009    2009   December    Returning Visitor   13882
New Visitor    23541    January 2010     2010   January     Returning Visitor   11606
New Visitor    21442    February 2010    2010   February    Returning Visitor   11401
New Visitor    23546    March 2010       2010   March       Returning Visitor   11800
New Visitor    18142    April 2010       2010   April       Returning Visitor    9502
New Visitor     2279    May 2010         2010   May         Returning Visitor    1238
   3                             4
Year      Month    Visitors   Year      Month    Visits
2009   January       12952    2009   January     17037
2009   February      13101    2009   February    17633
2009   March         12968    2009   March       18294
2009   April         12851    2009   April       17844
2009   May           13743    2009   May         18734
2009   June          15085    2009   June        20042
2009   July          22536    2009   July        28788
2009   August        22361    2009   August      28036
2009   September     25092    2009   September   31724
2009   October       26257    2009   October     34223
2009   November      28586    2009   November    38503
2009   December      29050    2009   December    39481
2010   January       26429    2010   January     35147
2010   February      24451    2010   February    32843
2010   March         26763    2010   March       35346
2010   April         20910    2010   April       27644
2010   May            3080    2010   May          3517
2010   June               0   2010   June             0
                      5                                    6
Visits/Visitor     Year      Month    Bounce Rate(%)    Year
            1.32   2009   January               15.46   2009
            1.35   2009   February              17.82   2009
            1.41   2009   March                 19.78   2009
            1.39   2009   April                 21.68   2009
            1.36   2009   May                   21.99   2009
            1.33   2009   June                  11.18   2009
            1.28   2009   July                   0.57   2009
            1.25   2009   August                 0.51   2009
            1.26   2009   September              1.44   2009
            1.30   2009   October               31.97   2009
            1.35   2009   November              22.76   2009
            1.36   2009   December              21.16   2009
            1.33   2010   January                26.4   2010
            1.34   2010   February               24.8   2010
            1.32   2010   March                 23.84   2010
            1.32   2010   April                 20.61   2010
            1.14   2010   May                   22.71   2010
   #DIV/0!         2010   June                      0   2010
                                                                7
   Month    Unique Pageviews     unique pageviews/Visit      Year
January                173612                       10.19    2009
February               188098                       10.67    2009
March                  180868                         9.89   2009
April                  159791                         8.95   2009
May                    141664                         7.56   2009
June                   136747                         6.82   2009
July                   177377                         6.16   2009
August                 169130                         6.03   2009
September              198587                         6.26   2009
October                201723                         5.89   2009
November               264120                         6.86   2009
December               278339                         7.05   2009
January                211058                         6.01   2010
February               174296                         5.31   2010
March                  180732                         5.11   2010
April                  156811                         5.67   2010
May                     19445                         5.53   2010
June                         0          #DIV/0!              2010
   Month    New Visits    Revenue     Customer
January         11600             0              0
February        11447             0              0
March           11097             0              0
April           10970             0              0
May             12012             0              0
June            13416       5754.25          13416
July            20411      88701.34          20411
August          20309      85423.34          20309
September       22744      98261.46          22744
October         23567     104761.94          23567
November        25395     151050.38          25395
December        25543     163833.25          25543
January         23505      98055.99          23505
February        21415      97143.24          21415
March           23514     102551.69          23514
April           18114      79734.64          18114
May              2274       8916.14           2274
June                  0           0              0
   8                                 9
Year      Month    Transaction    Year      Month    Quantity
2009   January                0   2009   January            0
2009   February               0   2009   February           0
2009   March                  0   2009   March              0
2009   April                  0   2009   April              0
2009   May                    0   2009   May                0
2009   June                  27   2009   June              61
2009   July                583    2009   July           1033
2009   August              567    2009   August         1049
2009   September           671    2009   September      1254
2009   October             650    2009   October        1254
2009   November           1031    2009   November       2288
2009   December           1319    2009   December       2278
2010   January             629    2010   January        1226
2010   February            657    2010   February       1288
2010   March               593    2010   March          1267
2010   April               550    2010   April          1055
2010   May                   51   2010   May               85
2010   June                   0   2010   June               0
                      10
Quantity/Order      Year      Month    Revenue
   #DIV/0!          2009   January             0
   #DIV/0!          2009   February            0
   #DIV/0!          2009   March               0
   #DIV/0!          2009   April               0
   #DIV/0!          2009   May                 0
             2.26   2009   June          5754.25
             1.77   2009   July         88701.34
             1.85   2009   August       85423.34
             1.87   2009   September    98261.46
             1.93   2009   October     104761.94
             2.22   2009   November    151050.38
             1.73   2009   December    163833.25
             1.95   2010   January      98055.99
             1.96   2010   February     97143.24
             2.14   2010   March       102551.69
             1.92   2010   April        79734.64
             1.67   2010   May            6325.2
   #DIV/0!          2010   June                0
Average Order Value     E-commerce conversion rate
      #DIV/0!                                        0.00%
      #DIV/0!                                        0.00%
      #DIV/0!                                        0.00%
      #DIV/0!                                        0.00%
      #DIV/0!                                        0.00%
               213.12                                0.13%
               152.15                                2.03%
               150.66                                2.02%
               146.44                                2.12%
               161.17                                1.90%
               146.51                                2.68%
               124.21                                3.34%
               155.89                                1.79%
               147.86                                2.00%
               172.94                                1.68%
               144.97                                1.99%
               124.02                                1.45%
      #DIV/0!                        #DIV/0!
  11                                                12
Year      Month    Conversion Rate-Goal1(%)       Year      Month
2009   January                                0   2009   January
2009   February                               0   2009   February
2009   March                                  0   2009   March
2009   April                                  0   2009   April
2009   May                                    0   2009   May
2009   June                                   0   2009   June
2009   July                                   0   2009   July
2009   August                                 0   2009   August
2009   September                              0   2009   September
2009   October                                0   2009   October
2009   November                               0   2009   November
2009   December                               0   2009   December
2010   January                                0   2010   January
2010   February                               0   2010   February
2010   March                                  0   2010   March
2010   April                                  0   2010   April
2010   May                                    0   2010   May
2010   June                                   0   2010   June
                                 13
Conversion Rate-Goal2(%)       Year      Month    Conversion Rate-Goal3(%)
                           0   2009   January                                0
                           0   2009   February                               0
                           0   2009   March                                  0
                           0   2009   April                                  0
                           0   2009   May                                    0
                           0   2009   June                                   0
                           0   2009   July                                   0
                           0   2009   August                                 0
                           0   2009   September                              0
                           0   2009   October                                0
                           0   2009   November                               0
                           0   2009   December                               0
                           0   2010   January                                0
                           0   2010   February                               0
                           0   2010   March                                  0
                           0   2010   April                                  0
                           0   2010   May                                    0
                           0   2010   June                                   0
  14
Year      Month    Conversion Rate-Goal4(%)
2009   January                                0
2009   February                               0
2009   March                                  0
2009   April                                  0
2009   May                                    0
2009   June                                   0
2009   July                                   0
2009   August                                 0
2009   September                              0
2009   October                                0
2009   November                               0
2009   December                               0
2010   January                                0
2010   February                               0
2010   March                                  0
2010   April                                  0
2010   May                                    0
2010   June                                   0
  15
Year      Month    Conversion Rate-Goal5(%)
2009   January                                0
2009   February                               0
2009   March                                  0
2009   April                                  0
2009   May                                    0
2009   June                                   0
2009   July                                   0
2009   August                                 0
2009   September                              0
2009   October                                0
2009   November                               0
2009   December                               0
2010   January                                0
2010   February                               0
2010   March                                  0
2010   April                                  0
2010   May                                    0
2010   June                                   0

								
To top