Docstoc

google analytics scorecard showing eCommerce metrics

Document Sample
google analytics scorecard showing eCommerce metrics Powered By Docstoc
					Ready to Use eCommerce Scorecard Five Key Metrics Showing Current, Previous, Last Year Comparisons and Sparkline
How's the overall health of your eCommerce? Is Revenue rising? Are transactions increasing? Are the conversions better than last period or last year? What was the average order value?


                 Metric           Current          Previous Month              Last Year                   13 Month Trend
                                                                                                                                                                                             Pre-built widgets make it easy to
                                                                                                                                                              7634 Max.                        build refreshable dashboards.
                 Visits                  6,308           6,752           -7%           943          569%                                                      4187 Median
                                                                                                                                                               943 Min.
                                                                                                                                                                                            Re-arrange and customize the cells.
                                                                                                                                                             10366 Max.
                 Revenue           $    10,133     $    10,366           -2% $             -          0%                                                      7157 Median
                                                                                                                                                                   Min.
                                                                                                                                                                                            Make your reports auto-refreshable,
                                                                                                                                                               148 Max.
                 Transactions               140           148            -5%               -          0%                                                       101 Median
                                                                                                                                                                                           use Past N periods and Period to Date.
                                                                                                                                                                   Min.                   (you may need to adjust the chart range)
                 Conversion                                                                                                                                     2.8 Max.
                                            2.2%          2.2%           0%            0.0%           0%                                                        1.7 Median
                 Rate
                                                                                                                                                                0.0 Min.
                                                                                                                                                                 74 Max.
                                                                                                                                                                                               Combine web site data with
                 Avg Order
                                   $     72.38     $     70.04           3% $              -          0%                                                         70 Median                         social media data
                 Value
                                                                                                                                                                 62 Min.                          in the same report


                                                                                                                                                                                             Put multiple web properties and
                                                                                                                                                                                                   social media pages
                                                                                                                                                                                                   in the same report
prompt,add,WIDGET_NAME,,20
prompt,add,[GA_PROFILE_ID],
prompt,add,[GA_SEGMENT],&segment=gaid::-1

GetGoogleAnalyticsData,,,[GA_PROFILE_ID],LastCalendar 13 Months,GoogleData.csv,"[GA_SEGMENT]&max-results=1000&di
ImportDataFiles,GoogleData.csv,"nxrowlabel_Year,nxtext_Month,nxnumeric_Visits,nxnumeric_Revenue,nxnumeric_Transact
ConcatenateTextColumns,Year~Month,-,Date
SwapTextColumnWithRowLabel,Date
MathOperationOnTwoPositions,column,Transactions,Visits,Divide,AB,Conversion Rate
MathOperationOnTwoPositions,column,Revenue,Transactions,Divide,AB,Avg Order Value
Swap
PageCaption,WIDGET_NAME-a
AddAggregates,Row
SortCustom,Sum~Maximum~Median~Minimum
InvertSelection,False,True
MoveColumns,Copy,WIDGET_NAME-a,0,Last
MathOperation,FillEmptyWithValue,0,0,Row,Actual
uiSaveInWorksheet,Current,WIDGET_NAME_data,overwrite,invisible,1,1,unformatted,-1,-1
SEGMENT]&max-results=1000&dimensions=ga:year,ga:month&metrics=ga:visits,ga:transactionrevenue,ga:transactions"
eric_Revenue,nxnumeric_Transactions",0,1,utf-8,,yyyy-MM-dd,en-US,,""
,ga:transactions"
*                 2010-08         2010-09          2010-10          2010-11          2010-12        2011-01
Visits                      943             1343             3069             1675             2558         3020
Revenue                       0                0                0                0                0         5323
Transactions                  0                0                0                0                0           86
Conversion Rate               0                0                0                0                0 0.028476821
Avg Order Value               0                0                0                0                0 61.89534884
2011-02     2011-03      2011-04      2011-05      2011-06      2011-07      2011-08
       4187         4501         5346         7634         7002         6752         6308
       7157         7855         9859         8762         7919        10366        10133
        101          106          142          124          116          148          140
0.024122283 0.023550322 0.026561915 0.016243123 0.016566695 0.021919431 0.022194039
70.86138614 74.10377358 69.42957746 70.66129032 68.26724138 70.04054054 72.37857143
Sum         Maximum     Median      Minimum
      54338        7634        4187         943
      67374       10366        7157           0
        963         148         101           0
0.179634631 0.028476821 0.016566695           0
557.6377297 74.10377358 70.35091543 61.89534884

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:10/26/2011
language:English
pages:7