Excel Web Analytics let's you track revenue and transactions

The original inspiration for this dashboard courtesy of Stéphane Hamel @ Immeria

Stay in tune with your eCommerce site performance with this easily refreshed monthly report. Using a scorecard approach, key metrics, trends and comparisons are provided on a single page, suitable for printing. The scorecard report includes:

  • Key metrics of visits, revenue, transaction count, average order size and conversion rate
  • Current month contrasted with previous month and the same month last year
  • Thirteen month trend lines with peak and median metrics
  • Conversion rates by medium (search, referral, etc)
  • A listing of the top 20 sources with key metrics for each

The entire report can be viewed for specific segments of your traffic -- by new or returning visitors, referral or search traffic, or only visits with conversion or transactions.

ecommerce scorecard 600

Download eCommerceScorecard.xlsx, open in Microsoft Excel and click Refresh on the Next Analytics menu. You will be prompted for your Google Analytics account, password and the website profile of interest.

Next Analytics for Excel required to refresh data.