HomeAll TemplatesGoogle SheetsE-CommerceShopifyShopify Dashboard with Traffic and Sales report

Shopify Dashboard with Traffic and Sales report

E-Commerce

Use Template

Shopify

For use with Google Sheets

About the template

This is a unique Dashboard which infers data for 30 days, where the date can be changed by the user dynamically . This traffic dashboard contains vital data like Top Revenue Sources like Google Facebook etc. , Gross sales, Total sales, order quantity and key metrics like refund amount , tax amount, discount amount , net sales and shipping.

TOP 20 REVENUE SOURCES: This chart represents the top 20 Traffic sources with respect to their order quantity which is crucial in finding the sources like
GROSS SALES CHART: This chart represents the gross sales amount on each day for the chosen date range.
ORDER QUANTITY CHART: This chart represents the number of orders placed on each day for the chosen date range
CART OVERVIEW PIE CHART: This pie chart represent the total , fulfilled and unfulfilled orders for the chosen date range.
SALES OVERVIEW CHART: This chart represents all the vital metric data like orders, gross sales, discount, refund amount, shipping, tax and net amount for the chosen date range.
TOP 20 PRODUCTS BY SALES CHART: This chart displays the Top 20 products which has the highest sales with respect to its order quantity.

This helps to keep a track on your revenue and customers on monthly basis.