Embed
Email

E Commerce dashboard

Document Sample
E Commerce dashboard
Description

The dashboard I use with e-commerce companies I invest in

Shared by: Mark MacLeod
Categories
Stats
views:
548
posted:
12/7/2011
language:
pages:
1
Fiscal Weeks Dashboard is done weekly

UNIQUE VISITORS (#)

New Unique 1st time visitors

% New Unique

Returning Visitors

% Returning Visitors % of all traffic from new 1st time visitors

Total Unique Visitors



USER COUNTS (#)

New Accounts New accounts created

Repeat (Re-Logins) Existing accounts that logged in

Total All log-ins for the week

Total # Accounts



ORDERS (#)

From New Clients # of new accounts created in the week that also bought

From Repeat Clients # of existing accounts that bought

% From New Clients

% From Repeat Clients

Total



ACTIVE SALES %

New % of new accounts that bought

Repeat % of existing accounts that bought

Total



CONVERSION RATE %

All UVs to All Orders Order count / visitor count

New UV to New Accounts % of new UVs that created an account

New Accounts to New Orders % of new accounts that bought



UNIT MIX Count of units sold by product category

Product category 1

Product category 2

Product category 3



$ MIX Sales $ by product category

Product category 1

Product category 2

Product category 3



BUYER MIX (% of orders w/ item) Count of buyers by product category

Product category 1

Product category 2

Product category 3



Customer Acquisition Cost

Marketing Staff $ Salaries for marketing & sales

Marketing spend Spend on customer acquisition, excluding salaries

Total



CAC / new buyer

$ CAC / new buyer (w/ staff) Total Customer acquisition spend/ # new buyers

$ CAC / new buyer (w/o staff) Marketing spend (no salaries)/ # new buyers



Average Basket Size

New Sales from new buyers / # of new buyers

Repeat Sales from repeat buyers / # of repeat buyers

Blended Sales / # buyers



Total Sales

$



Member $ Value

$/member Sales / all accounts



% Source Contribution to Sales ($) Attributing sales $ to source of the account

Direct

Email

Google Paid Ads

Referral

Organic



Refunds

Count

$

Top 5 reasons What is causing refunds? Fit? Shipping time? Etc?



People who don't complete purchase

% Carts abandonned % of accounts that put items in a shopping cart but don't buy


Related docs
Other docs by Mark MacLeod
Women in Technology - Call for Proposals
Views: 135  |  Downloads: 0
Executive Summary
Views: 533  |  Downloads: 2
E Commerce dashboard
Views: 548  |  Downloads: 42
IP assignment - employees
Views: 214  |  Downloads: 0
IP Assignment for Contractors
Views: 302  |  Downloads: 0
VC Presentation Grader
Views: 3646  |  Downloads: 270
IP 101 for Startups
Views: 692  |  Downloads: 19
SaaS Funding Decision Tree
Views: 828  |  Downloads: 32
Software valuation benchmarks
Views: 69  |  Downloads: 3
SaaS Valuation Benchmarks
Views: 204  |  Downloads: 8
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!