; Excel Dashboard Example
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Excel Dashboard Example

VIEWS: 0 PAGES: 14

  • pg 1
									[Your logo/company name here]

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




                                                                                                                                                                                        1/14
Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.                                                         1/13/2014 9:35 AM
[Your logo/company name here]

                                                                                                        Web Analytics
                                                                                                            Dashboard

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




                                                                                                                                                                                      2/14
Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.                                                       1/13/2014 9:35 AM
[Your logo/company name here]

                                                                                                        Web Analytics
                                                                                                            Dashboard

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




                                                                                                                                                                               3/14
Licensed under Creative Commons Attribution-Noncommercial-Share Alike 2.5 Canada License. Visit http://immeria.net.                                                1/13/2014 9:35 AM
                  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       Returning
   Date              Site Statistics           eCommerce                Conversions
                                                                                                Visitors    Visitors

    January 07                                                                                    58,270     10,607
   February 07                                                                                    53,231     10,923
     March 07                                                                                     52,216     10,228
       April 07                                                                                   45,318      9,183
      May 07                                                                                      49,823      9,950
      June 07                                                                                     54,300     10,596
       July 07                                                                                    46,089     10,297
    August 07                                                                                     63,553     11,103
 September 07                                                                                     48,811     10,413
   October 07                                                                                     54,623     10,856
  November 07                                                                                     95,921     13,849
  December 07                                                                                     93,828     19,502
    January 08                                                                                    88,429     21,452
   February 08                                                                                    67,965     15,570
     March 08                                                                                     69,373     14,772
       April 08                                                                                   62,023     14,429
       May 08                                                                                     58,514     13,705
      June 08                                                                                     62,107     13,315
                                           C
       July 08 Comment about site statistics omment about ecommerce Comment about conversions     53,360     11,959
    August 08
 September 08
   October 08
  November 08
  December 08
Unique                                Single Page                Page       Page Views/
           Visits    Visits/Visitor               Bounce Rate                              Customers
Visitors                                 Visits                  Views         Visits

 68,877     95,393             1.4        35,583         37% 1,408,432              14.8       6,773
 64,154     88,952             1.4        37,857         43% 1,363,719              15.3       6,782
 62,444     84,958             1.4        33,464         39% 1,113,951              13.1       4,874
 54,501     73,038             1.3        28,287         39%      990,800           13.6       4,481
 59,773     80,527             1.3        34,413         43%    1,079,432           13.4       3,379
 64,896     87,695             1.4        30,443         35%    1,375,959           15.7       3,856
 56,386     77,688             1.4        25,252         33%    1,141,189           14.7       3,306
 74,656     99,609             1.3        30,691         31%    1,482,814           14.9       4,336
 59,224     80,133             1.4        23,102         29%    1,107,592           13.8       3,538
 65,479     89,882             1.4        25,620         29%    1,297,132           14.4       3,898
109,770    160,623             1.5        62,838         39%    1,990,525           12.4       4,769
113,330    168,884             1.5        64,318         38%    2,132,301           12.6       7,021
109,881    160,027             1.5        63,330         40% 1,819,795              11.4       4,485
 83,535    116,725             1.4        41,885         36% 1,647,381              14.1       5,246
 84,145    117,105             1.4        39,178         33% 1,647,494              14.1       4,726
 76,452    107,889             1.4        38,248         35% 1,345,066              12.5       3,779
 72,219    100,477             1.4        36,270         36% 1,272,023              12.7       3,367
 75,422     99,511             1.3        40,489         41%     988,742             9.9       2,138
 65,319     88,158             1.3        32,925         37%     978,512            11.1       2,491
      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    Success
Orders      Items     Items/Order          Revenues
                                                        Order Size Conversion      Event 1    Event 2

    7,403    60,245                8   $   322,652.70   $     43.58        7.8%          0          0
    7,441    71,484               10   $   362,377.23   $     48.70        8.4%          0          1
    5,278    40,679                8   $   248,930.13   $     47.16        6.2%          0         12
    4,883    39,565                8   $   330,940.83   $     67.77        6.7%          2          5
    3,632    33,077                9   $   185,588.88   $     51.10        4.5%        260        718
    4,030    35,324                9   $   194,748.88   $     48.32        4.6%      1,078      3,002
    3,466    31,474                9   $   168,087.59   $     48.50        4.5%      1,091      2,538
    4,508    44,824               10   $   217,078.61   $     48.15        4.5%      1,271      3,186
    3,710    33,624                9   $   179,342.09   $     48.34        4.6%      1,154      2,336
    4,117    44,219               11   $   215,698.95   $     52.39        4.6%      1,210      2,623
    4,990    53,969               11   $   273,648.23   $     54.84        3.1%      1,436      4,067
    7,449    63,740                9   $   368,074.92   $     49.41        4.4%      1,155      4,074
    4,748    42,204                9 $ 244,620.16 $           51.52        3.0%      1,596      3,383
    5,584    56,426               10 $ 304,227.24 $           54.48        4.8%      1,224      2,799
    5,051    47,499                9 $ 305,119.26 $           60.41        4.3%      1,366      2,835
    3,900    36,000                9 $ 224,794.85 $           57.64        3.6%      1,109      2,322
    3,505    31,743                9         $186,578            $53       3.5%      1,075      2,065
    2,202    19,759                9         $114,519            $52       2.2%      1,095      1,835
    2,629    25,371               10         $141,527            $54       3.0%        964      1,585
                        #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
 Event 3     Rate

       0         8%
       0         8%
       1         6%
       2         7%
     733         7%
   2,874        13%
   2,780        13%
   3,011        12%
   2,967        13%
   3,176        12%
   4,311         9%
   5,281        11%
   5,111         9%
   4,348        12%
   4,348        12%
   3,830        10%
   3,716        10%
   3,857         9%
   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        Returning
   Date               Site Statistics            eCommerce                  Conversions
                                                                                                   Visitors     Visitors

    January 07                                                                                   132,797    24,025
   February 07                                                                                   124,776    22,784
     March 07                                                                                    125,917    21,985
      April 07                                                                                    97,360    18,506
       May 07                                                                                    109,054    19,311
      June 07                                                                                    110,933    20,030
       July 07                                                                                    99,775    19,347
    August 07                                                                                    109,512    19,563
 September 07                                                                                     95,984    18,303
   October 07                                                                                    114,704    20,134
  November 07                                                                                    136,692    22,551
  December 07                                                                                    124,398    22,749
    January 08                                                                                   117,056    24,535
   February 08                                                                                    99,666    19,984
     March 08                                                                                    133,698    19,921
       April 08                                                                                  112,241    21,886
       May 08                                                            previous
                                           All indicators worse thanAll indicators worse than year.
                  All indicators worse than previous month/previous year. month/previous previous month/previous year.
                                                                                                  94,815    20,955
      June 08                                                           All ecommerce activities! 84,085
                                           Warning! Significantly than usual.
                  Slight increase in visits/visitor but lower traffic lowerindicators worse than previous month/previous year.
                                                                                                             10406
                                                                        Overall improvement
                                          Overall year results but below last year results
               Overall improvement, but below lastimprovement, for the same time period. for the same time period.
                                                                        What about looking for
       July 08                                                          brand information?          100,000          17794
    August 08
 September 08
   October 08
  November 08
  December 08
Unique                                Single Page               Page     Page Views/
           Visits    Visits/Visitor               Bounce Rate                        Customers
Visitors                                 Visits                 Views       Visits

156,822 220,005                1.4        73,044         33% 3,569,114          16.2    13,797
147,560 203,715                1.4        73,252         36% 3,091,298          15.2    11,219
147,902 199,380                1.3        74,422         37% 3,011,963          15.1    13,161
115,866 157,111                1.4        54,217         35% 2,454,251          15.6    10,540
128,365 173,373                1.4        63,505         37% 2,648,190          15.3    11,876
130,963 179,249                1.4        59,734         33% 2,509,708          14.0    10,737
119,122 162,612                1.4        51,117         31% 2,314,531          14.2     9,982
129,075 178,641                1.4        57,302         32% 2,607,757          14.6    11,268
114,287 160,258                1.4        58,330         36% 2,164,233          13.5     9,163
134,838 185,433                1.4        57,734         31% 2,735,351          14.8    11,919
159,243 223,166                1.4        70,488         32% 3,316,555          14.9    14,513
147,147 209,572                1.4        57,753         28% 3,092,245          14.8    14,090
141,591    199,718             1.4        60,670         30% 2,592,343          13.0     8,886
119,650    166,929             1.4        55,405         33% 2,507,390          15.0    10,833
153,619    209,917             1.4        71,172         34% 3,089,683          14.7    13,356
134,127    192,807             1.4        63,289         33% 2,810,432          14.6    10,450
115,770    163,707             1.4        53,178         32% 2,326,323          14.2     9,275
 94,491    142,931             1.5        47,410         33% 1,782,854          12.5     6,732


117,794 156,340                1.3        55,169         35% 1,900,944          12.2     7,277
      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     Success
Orders      Items     Items/Order        Revenues
                                                      Order Size Conversion    Event 1     Event 2

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


    7,777    74,646             10        $354,156           $46      5.0%        4,639       2,032
                           #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
 Event 3     Rate

   3,633       12%
   3,426       11%
   3,519       13%
   3,337       14%
   3,043       13%
   2,874       11%
   2,770       12%
   3,037       12%
   2,900       11%
   3,258       12%
   3,627       12%
   4,040       12%
   3,898       10%
   3,174       12%
   3,968       12%
   3,924       11%
   3,318       11%
   2,751       10%


   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/         Single    Bounce Page Views
Limits          New         Returning Unique                   Visitor         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/         Page      Bounce
Month Offset Visitors       Visitors  Visitors     Visits      Visitor         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 Views/ Customers Orders     Items            Items/      Revenues     Average      eCommerce
Visits                                            Order                    Order        Conversion
                                                                           Size
       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%



                                                                           Average
Page Views/                                       Items/                   Order        eCommerce
Visits      Customers Orders     Items            Order       Revenues     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