Dashboard by Pb4J22

VIEWS: 0 PAGES: 17

									[Your logo/company name here]
                                                                                          Web Analytics
                                                                                           Dashboard

                 Select reporting period:                                      Select segment:
                 July 08                           19               July 08 1 S1                January 07 WebDataS1
                                                                                                              S2



                 July 08                                                                                                                                      S1
                                                                     Current                      Previous            Same Month
                 Site Statistics                                                                                                         Trend
                                                                      Month                         Month              of Last Year
                                                                                                                                                    99,716    5
                                                                   65,319                          75,422               56,386                                –
                 Unique Visitors                                              -13%                                                16%
                                                                                                                                                    80,448    6
                                                                                                                                                    61,179
                                                                                                                                                   143,990    5
                                                                   88,158                           99,511              77,688                                –
                 Visits                                                       -11%                                                13%
                                                                                                                                                   112,824    6
                                                                                                                                                    81,658
                                                                                                                                                        1.4   5
                                                                        1.3                              1.3                1.4                               –
                 Visits/Visitor                                                2%                                                 -2%
                                                                                                                                                        1.4   6
                                                                                                                                                        1.3
                                                                                                                                                      39%     5
                                                                       37%                              41%                33%                                –
                 Bounce Rate                                                  -8%                                                 15%
                                                                                                                                                      35%     6
                                                                                                                                                      31%
                                                                                                                                                 1,825,012    5
                                                                  978,512                          988,742            1,141,189                               –
                 Page Views                                                   -1%                                                 -14%
                                                                                                                                                 1,450,044    6
                                                                                                                                                 1,075,075
                                                                                                                                                      14.5    5
                                                                       11.1                               9.9              14.7                               –
                 Page Views/Visits                                            12%                                                 -24%
                                                                                                                                                      13.0    6
                                                                                                                                                      11.4
                 Comment about site statistics




                                                                                                                                                                           1/17
Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.                                            1/3/2012 8:38 PM
[Your logo/company name here]
                                                                                          Web Analytics
                                                                                           Dashboard


                 July 08                                                                                                                                    S1
                                                                      Current                     Previous            Same Month
                 eCommerce                                                                                                              Trend
                                                                       Month                        Month              of Last Year
                                                                                                                                                   5,341    5
                                                                   2,491.0                         2,138.0              3,306.0                             –
                 Customers                                                     17%                                               -25%
                                                                                                                                                   4,085    6
                                                                                                                                                   2,828
                                                                                                                                                   5,648    5
                                                                   2,629.0                          2,202.0             3,466.0                             –
                 Orders                                                        19%                                               -24%
                                                                                                                                                   4,297    6
                                                                                                                                                   2,946
                                                                                                                                                  53,559    5
                                                                 25,371.0                         19,759.0             31,474.0                             –
                 Items                                                         28%                                               -19%
                                                                                                                                                  40,835    6
                                                                                                                                                  28,111
                                                                                                                                                    10.2    5
                                                                         9.7                              9.0               9.1                             –
                 Items/Order                                                   8%                                                 6%
                                                                                                                                                      9.5   6
                                                                                                                                                      8.8
                                                                                                                                                  $56.36    5
                                                         $          53.83            $               52.01       $       48.50                              –
                 Average Order Size                                            4%                                                 11%
                                                                                                                                                  $52.67    6
                                                                                                                                                  $48.99
                                                                                                                                                $298,297    5
                                                         $ 141,526.95                $       114,518.97          $ 168,087.59                               –
                 Revenues                                                      24%                                               -16%
                                                                                                                                                $226,409    6
                                                                                                                                                $154,521
                                                                                                                                                    4.7%    5
                                                                      3.0%                             2.2%                4.5%                             –
                 eCommerce Conversion                                          35%                                               -33%
                                                                                                                                                    3.9%    6
                                                                                                                                                    3.0%
                 Comment about ecommerce




                                                                                                                                                                         2/17
Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.                                          1/3/2012 8:38 PM
[Your logo/company name here]
                                                                                          Web Analytics
                                                                                           Dashboard


                 July 08                                                                                                                               S1
                                                                      Current                     Previous            Same Month
                 Online Events                                                                                                         Trend
                                                                       Month                        Month              of Last Year
                                                                                                                                               5,648   5
                                                                     2,629                           2,202                 3,466                       –
                 Orders                                                       19%                                              -24%
                                                                                                                                               4,297   6
                                                                                                                                               2,946
                                                                                                                                               1,382   5
                                                                        964                           1,095               1,091                        –
                 Success Event 1                                             -12%                                              -12%
                                                                                                                                               1,211   6
                                                                                                                                               1,040
                                                                                                                                               3,515   5
                                                                     1,585                            1,835               2,538                        –
                 Success Event 2                                             -14%                                              -38%
                                                                                                                                               2,742   6
                                                                                                                                               1,969
                                                                                                                                               4,653   5
                                                                     2,810                            3,857               2,780                        –
                 Success Event 3                                             -27%                                                 1%
                                                                                                                                               3,811   6
                                                                                                                                               2,969
                                                                                                                                               12.3%   5
                                                                         9%                               9%               13%                         –
                 Success Rate                                                  0%                                              -29%
                                                                                                                                               10.9%   6
                                                                                                                                                9.4%
                 Comment about conversions




                                                                                                                                                                    3/17
Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.                                     1/3/2012 8:38 PM
[Your logo/company name here]
                                                                                               Web Analytics
                                                                                                Dashboard

                                                         1) Select a time period and a segment on the left.
                                                         2) Modify data in the WebData sheets ONLY




                                                         Comment
                                                         General statistics for the site. Compare month to month (M2M) and Year To Year (Y2Y) data.


                                                         General site statistics. The 3 numbers beside the sparkline are the upper and lower limits (+/-
                                                         1xStandard Deviation) and the middle number is the average.

                                                         General site statistic. In most cases, an increase in visits will correlate directly with higher outcomes.


                                                         Degree of fidelity toward the site.


                                                         Are you bringing quality traffic?


                                                         General site statistic. Can be considered an indicator of engagement.


                                                         Depending on the context, this can indicate interest in your content... Or lost trying to find
                                                         something.

                                                         Space reserved for the analyst comments, edited through WebData sheet.




                                                                                                                                                                                  4/17
Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.                                                   1/3/2012 8:38 PM
[Your logo/company name here]
                                                                                             Web Analytics
                                                                                              Dashboard




                                                         This section focus on typical ecommerce metrics.
                                                         General metric.


                                                         General metric.


                                                         General metric.


                                                         General metric.


                                                         Share of wallet.


                                                         Bottom line...


                                                         Orders by Visit (or could also be Customers/Visitors)


                                                         Space reserved for the analyst comments, edited through WebData sheet.




                                                                                                                                              5/17
Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.               1/3/2012 8:38 PM
[Your logo/company name here]
                                                                                             Web Analytics
                                                                                              Dashboard




                                                         Same as eCommerce above.


                                                         Significant activity


                                                         Significant activity


                                                         Significant activity


                                                         Percentage of visits that result in a positive outcome.


                                                         Space reserved for the analyst comments, edited through WebData sheet.




                                                                                                                                              6/17
Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.               1/3/2012 8:38 PM
                  Instructions: Data for 13 months trend of 1st segment
                  1) Change Segment1 to your liking
                  2) Adjust the column names Success Event 1 through Success Event 3
Segment1          3) Edit only the non-grayed out columns.

                                                                                                     New
    Date               Site Statistics             eCommerce                  Conversions
                                                                                                    Visitors

    January 07                                                                                        58,270
   February 07                                                                                        53,231
      March 07                                                                                        52,216
       April 07                                                                                       45,318
        May 07                                                                                        49,823
       June 07                                                                                        54,300
        July 07                                                                                       46,089
     August 07                                                                                        63,553
  September 07                                                                                        48,811
    October 07                                                                                        54,623
  November 07                                                                                         95,921
  December 07                                                                                         93,828
    January 08                                                                                        88,429
   February 08                                                                                        67,965
      March 08                                                                                        69,373
       April 08                                                                                       62,023
        May 08                                                                                        58,514
       June 08                                                                                        62,107
        July 08 Comment about site statistics Comment about ecommerce   Comment about conversions     53,360
     August 08
  September 08
    October 08
  November 08
  December 08
Returning   Unique                                Single Page                  Page          Page
                       Visits   Visits/Visitor                  Bounce Rate
 Visitors   Visitors                                 Visits                    Views      Views/Visits

  10,607 68,877 95,393                      1.4       35,583           37%    1,408,432            14.8
  10,923 64,154 88,952                      1.4       37,857           43%    1,363,719            15.3
  10,228 62,444 84,958                      1.4       33,464           39%    1,113,951            13.1
   9,183 54,501 73,038                      1.3       28,287           39%      990,800            13.6
   9,950 59,773 80,527                      1.3       34,413           43%    1,079,432            13.4
  10,596 64,896 87,695                      1.4       30,443           35%    1,375,959            15.7
  10,297 56,386 77,688                      1.4       25,252           33%    1,141,189            14.7
  11,103 74,656 99,609                      1.3       30,691           31%    1,482,814            14.9
  10,413 59,224 80,133                      1.4       23,102           29%    1,107,592            13.8
  10,856 65,479 89,882                      1.4       25,620           29%    1,297,132            14.4
  13,849 109,770 160,623                    1.5       62,838           39%    1,990,525            12.4
  19,502 113,330 168,884                    1.5       64,318           38%    2,132,301            12.6
  21,452 109,881 160,027                    1.5       63,330           40%    1,819,795           11.4
  15,570 83,535 116,725                     1.4       41,885           36%    1,647,381           14.1
  14,772 84,145 117,105                     1.4       39,178           33%    1,647,494           14.1
  14,429 76,452 107,889                     1.4       38,248           35%    1,345,066           12.5
  13,705 72,219 100,477                     1.4       36,270           36%    1,272,023           12.7
  13,315 75,422 99,511                      1.3       40,489           41%      988,742             9.9
  11,959 65,319 88,158                      1.3       32,925           37%      978,512           11.1
               0                  #DIV/0!                         #DIV/0!                   #DIV/0!
               0                  #DIV/0!                         #DIV/0!                   #DIV/0!
               0                  #DIV/0!                         #DIV/0!                   #DIV/0!
               0                  #DIV/0!                         #DIV/0!                   #DIV/0!
               0                  #DIV/0!                         #DIV/0!                   #DIV/0!
                                                                    Average       eCommerce    Success
Customers   Orders      Items     Items/Order         Revenues
                                                                   Order Size     Conversion   Event 1

    6,773       7,403    60,245               8   $   322,652.70   $     43.58          7.8%          0
    6,782       7,441    71,484              10   $   362,377.23   $     48.70          8.4%          0
    4,874       5,278    40,679               8   $   248,930.13   $     47.16          6.2%          0
    4,481       4,883    39,565               8   $   330,940.83   $     67.77          6.7%          2
    3,379       3,632    33,077               9   $   185,588.88   $     51.10          4.5%        260
    3,856       4,030    35,324               9   $   194,748.88   $     48.32          4.6%      1,078
    3,306       3,466    31,474               9   $   168,087.59   $     48.50          4.5%      1,091
    4,336       4,508    44,824              10   $   217,078.61   $     48.15          4.5%      1,271
    3,538       3,710    33,624               9   $   179,342.09   $     48.34          4.6%      1,154
    3,898       4,117    44,219              11   $   215,698.95   $     52.39          4.6%      1,210
    4,769       4,990    53,969              11   $   273,648.23   $     54.84          3.1%      1,436
    7,021       7,449    63,740               9   $   368,074.92   $     49.41          4.4%      1,155
    4,485       4,748    42,204               9   $   244,620.16   $      51.52         3.0%      1,596
    5,246       5,584    56,426              10   $   304,227.24   $      54.48         4.8%      1,224
    4,726       5,051    47,499               9   $   305,119.26   $      60.41         4.3%      1,366
    3,779       3,900    36,000               9   $   224,794.85   $      57.64         3.6%      1,109
    3,367       3,505    31,743               9         $186,578            $53         3.5%      1,075
    2,138       2,202    19,759               9         $114,519            $52         2.2%      1,095
    2,491       2,629    25,371              10         $141,527            $54         3.0%        964
                                   #DIV/0!                             #DIV/0!     #DIV/0!
                                   #DIV/0!                             #DIV/0!     #DIV/0!
                                   #DIV/0!                             #DIV/0!     #DIV/0!
                                   #DIV/0!                             #DIV/0!     #DIV/0!
                                   #DIV/0!                             #DIV/0!     #DIV/0!
Success    Success
                      Success Rate
Event 2    Event 3

       0          0           8%
       1          0           8%
      12          1           6%
       5          2           7%
     718        733           7%
   3,002      2,874          13%
   2,538      2,780          13%
   3,186      3,011          12%
   2,336      2,967          13%
   2,623      3,176          12%
   4,067      4,311           9%
   4,074      5,281          11%
   3,383      5,111           9%
   2,799      4,348          12%
   2,835      4,348          12%
   2,322      3,830          10%
   2,065      3,716          10%
   1,835      3,857           9%
   1,585      2,810           9%
                        #DIV/0!
                        #DIV/0!
                        #DIV/0!
                        #DIV/0!
                        #DIV/0!
                  Instructions: Data for 13 months trend of 2nd segment
                  1) Change Segment2 to your liking
                  2) Adjust the column names Success Event 1 through Success Event 3
Segment2          3) Edit only the non-grayed out columns.

                                                                                                           New
    Date               Site Statistics               eCommerce                    Conversions
                                                                                                          Visitors

    January 07                                                                                     132,797
   February 07                                                                                     124,776
      March 07                                                                                     125,917
       April 07                                                                                     97,360
        May 07                                                                                     109,054
       June 07                                                                                     110,933
        July 07                                                                                     99,775
     August 07                                                                                     109,512
  September 07                                                                                      95,984
    October 07                                                                                     114,704
  November 07                                                                                      136,692
  December 07                                                                                      124,398
    January 08                                                                                     117,056
   February 08                                                                                      99,666
      March 08                                                                                     133,698
       April 08                                                                                    112,241
                                           previous month/previous All indicators worse than previous month/previous year.
                                                                       year.
        May 08 All indicators worse thanAll indicators worse than previous month/previous year.     94,815
                                          Warning! Significantly lower indicators worse than
                                                                        usual.
       June 08 Slight increase in visits/visitor but lower traffic thanAll ecommerce activities! previous month/previous year.
                                                                                                    84,085
                                               Overall improvement, but below time year results for the
                                                                                 last period.
                  Overall improvement, but below last year results for the same Overall improvement same time period.
                                                                                What about looking for brand
        July 08                                                                 information?                 100,000
     August 08
  September 08
    October 08
  November 08
  December 08
Returning   Unique                                Single Page                  Page          Page
                       Visits    Visits/Visitor                 Bounce Rate
 Visitors   Visitors                                 Visits                    Views      Views/Visits

  24,025    156,822    220,005              1.4        73,044          33%    3,569,114            16.2
  22,784    147,560    203,715              1.4        73,252          36%    3,091,298            15.2
  21,985    147,902    199,380              1.3        74,422          37%    3,011,963            15.1
  18,506    115,866    157,111              1.4        54,217          35%    2,454,251            15.6
  19,311    128,365    173,373              1.4        63,505          37%    2,648,190            15.3
  20,030    130,963    179,249              1.4        59,734          33%    2,509,708            14.0
  19,347    119,122    162,612              1.4        51,117          31%    2,314,531            14.2
  19,563    129,075    178,641              1.4        57,302          32%    2,607,757            14.6
  18,303    114,287    160,258              1.4        58,330          36%    2,164,233            13.5
  20,134    134,838    185,433              1.4        57,734          31%    2,735,351            14.8
  22,551    159,243    223,166              1.4        70,488          32%    3,316,555            14.9
  22,749    147,147    209,572              1.4        57,753          28%    3,092,245            14.8
  24,535    141,591    199,718              1.4       60,670           30%    2,592,343            13.0
  19,984    119,650    166,929              1.4       55,405           33%    2,507,390            15.0
  19,921    153,619    209,917              1.4       71,172           34%    3,089,683            14.7
  21,886    134,127    192,807              1.4       63,289           33%    2,810,432            14.6
  20,955    115,770    163,707              1.4       53,178           32%    2,326,323            14.2
  10406      94,491    142,931              1.5       47,410           33%    1,782,854            12.5


   17794 117,794 156,340                   1.3        55,169          35% 1,900,944               12.2
               0                       #DIV/0!                      #DIV/0!                     #DIV/0!
               0                       #DIV/0!                      #DIV/0!                     #DIV/0!
               0                       #DIV/0!                      #DIV/0!                     #DIV/0!
               0                       #DIV/0!                      #DIV/0!                     #DIV/0!
               0                       #DIV/0!                      #DIV/0!                     #DIV/0!
                                                                Average      eCommerce     Success
Customers   Orders      Items     Items/Order     Revenues
                                                               Order Size    Conversion    Event 1

   13,797      15,005   161,499             11   $576,835.97   $   38.44           6.8%       3,575
   11,219      12,147   130,647             11   $500,285.08   $   41.19           6.0%       2,992
   13,161      14,254   120,167              8   $542,725.47   $   38.08           7.1%       3,139
   10,540      11,346    99,606              9   $442,322.17   $   38.98           7.2%       2,874
   11,876      12,674   125,685             10   $518,165.38   $   40.88           7.3%       2,809
   10,737      11,307   104,588              9   $451,351.23   $   39.92           6.3%       2,664
    9,982      10,573    98,463              9   $422,185.45   $   39.93           6.5%       2,773
   11,268      11,954   125,946             11   $487,324.87   $   40.77           6.7%       2,915
    9,163       9,883   100,818             10   $407,026.25   $   41.18           6.2%       2,770
   11,919      12,969   135,781             10   $514,939.50   $   39.71           7.0%       2,991
   14,513      16,378   152,481              9   $595,940.90   $   36.39           7.3%       3,063
   14,090      15,263   145,946             10   $673,740.64   $   44.14           7.3%       2,494
    8,886       9,505    96,702             10   $439,162.68   $    46.20          4.8%       3,524
   10,833      11,991   163,292             14   $613,287.69   $    51.15          7.2%       2,807
   13,356      14,467   131,655              9   $672,311.71   $    46.47          6.9%       3,059
   10,450      11,214   106,762             10   $579,843.12   $    51.71          5.8%       2,800
    9,275       9,946    88,397              9   $464,776.38          $47          6.1%       2,555
    6,732       7,208    60,823              8     $318,717           $44          5.0%       2,377


    7,277       7,777    74,646            10      $354,156           $46          5.0%       4,639
                                       #DIV/0!                     #DIV/0!       #DIV/0!
                                       #DIV/0!                     #DIV/0!       #DIV/0!
                                       #DIV/0!                     #DIV/0!       #DIV/0!
                                       #DIV/0!                     #DIV/0!       #DIV/0!
                                       #DIV/0!                     #DIV/0!       #DIV/0!
Success    Success
                      Success Rate
Event 2    Event 3

   4,733      3,633          12%
   4,200      3,426          11%
   4,215      3,519          13%
   3,686      3,337          14%
   3,681      3,043          13%
   3,307      2,874          11%
   3,071      2,770          12%
   3,315      3,037          12%
   2,669      2,900          11%
   3,216      3,258          12%
   3,376      3,627          12%
   3,331      4,040          12%
   3,127      3,898          10%
   2,747      3,174          12%
   3,388      3,968          12%
   3,231      3,924          11%
   2,415      3,318          11%
   2,056      2,751          10%


   2,032      2,587          11%
                           #DIV/0!
                           #DIV/0!
                           #DIV/0!
                           #DIV/0!
                           #DIV/0!
                Instructions: Lookup information, do not edit this spreadsheet directly, all values are
                automatically derived from the two WebDataSegments pages
                1) Change column names of Succes Event 1 through Success Event 3 to your liking
Control                                                        Visits/Visi Single Bounce Page Views
Limits          New         Returning Unique                   tor         Page   Rate
                Visitors    Visitors  Visitors      Visits                 Visits
Upper Limit        50,028       10,542       61,179     81,658         1.3 25,816     31%   1,075,075
Average            66,507       13,940       80,448   112,824          1.4 40,319     35%   1,450,044
Lower Limit        82,986       17,339       99,716   143,990          1.4 54,822     39%   1,825,012



                                                                              Single
             New            Returning Unique                      Visits/Visi Page      Bounce
Month Offset Visitors       Visitors  Visitors        Visits      tor         Visits    Rate   Page Views
          -12      46,089       10,297       56,386      77,688          1.4   25,252      33%     1,141,189
          -11      63,553       11,103       74,656      99,609          1.3   30,691      31%     1,482,814
          -10      48,811       10,413       59,224      80,133          1.4   23,102      29%     1,107,592
           -9      54,623       10,856       65,479      89,882          1.4   25,620      29%     1,297,132
           -8      95,921       13,849      109,770     160,623          1.5   62,838      39%     1,990,525
           -7      93,828       19,502      113,330     168,884          1.5   64,318      38%     2,132,301
           -6      88,429       21,452      109,881     160,027          1.5   63,330      40%     1,819,795
           -5      67,965       15,570       83,535     116,725          1.4   41,885      36%     1,647,381
           -4      69,373       14,772       84,145     117,105          1.4   39,178      33%     1,647,494
           -3      62,023       14,429       76,452     107,889          1.4   38,248      35%     1,345,066
           -2      58,514       13,705       72,219     100,477          1.4   36,270      36%     1,272,023
           -1      62,107       13,315       75,422      99,511          1.3   40,489      41%       988,742
            0      53,360       11,959       65,319      88,158          1.3   32,925      37%       978,512
Page         Customers    Orders      Items            Items/Ord Revenues           Average    eCommerce
Views/Visits                                           er                           Order Size Conversion

       11.4       2,828       2,946           28,111         8.8 $ 154,520.52       $   48.99          3%
       13.0       4,085       4,297           40,835         9.5 $ 226,408.92       $   52.67          4%
       14.5       5,341       5,648           53,559        10.2 $ 298,297.31       $   56.36          5%




Page                                                   Items/Ord                    Average    eCommerce
Views/Visits Customers    Orders      Items            er        Revenues           Order Size Conversion
       14.7       3,306       3,466           31,474         9.1   $   168,087.59   $   48.50         4.5%
       14.9       4,336       4,508           44,824         9.9   $   217,078.61   $   48.15         4.5%
       13.8       3,538       3,710           33,624         9.1   $   179,342.09   $   48.34         4.6%
       14.4       3,898       4,117           44,219        10.7   $   215,698.95   $   52.39         4.6%
       12.4       4,769       4,990           53,969        10.8   $   273,648.23   $   54.84         3.1%
       12.6       7,021       7,449           63,740         8.6   $   368,074.92   $   49.41         4.4%
       11.4       4,485       4,748           42,204         8.9   $   244,620.16   $   51.52         3.0%
       14.1       5,246       5,584           56,426        10.1   $   304,227.24   $   54.48         4.8%
       14.1       4,726       5,051           47,499         9.4   $   305,119.26   $   60.41         4.3%
       12.5       3,779       3,900           36,000         9.2   $   224,794.85   $   57.64         3.6%
       12.7       3,367       3,505           31,743         9.1   $   186,578.11   $   53.23         3.5%
        9.9       2,138       2,202           19,759         9.0   $   114,518.97   $   52.01         2.2%
       11.1       2,491       2,629           25,371         9.7   $   141,526.95   $   53.83         3.0%
Success      Success     Success      Success
Event 1      Event 2     Event 3      Rate

     1,040       1,969        2,969        9%
     1,211       2,742        3,811       11%
     1,382       3,515        4,653       12%



Success      Success     Success
Event 1      Event 2     Event 3      Success
                                      Rate
     1,091       2,538        2,780       13%
     1,271       3,186        3,011       12%
     1,154       2,336        2,967       13%
     1,210       2,623        3,176       12%
     1,436       4,067        4,311        9%
     1,155       4,074        5,281       11%
     1,596       3,383        5,111        9%
     1,224       2,799        4,348       12%
     1,366       2,835        4,348       12%
     1,109       2,322        3,830       10%
     1,075       2,065        3,716       10%
     1,095       1,835        3,857        9%
       964       1,585        2,810        9%

								
To top