Advertising Continue reading below Once you've changed your start and end dates and configured the reports as per the examples shown in the screenshot above, navigate to the Google Analytics add-on and click "run reports". Once generated, each report will be displayed on a new sheet without any formatting. The next step is to create a 'dashboard' tab to reference the data from each report so that it is easily accessible and digestible through a single sheet. Step 4: Customize your e-commerce dashboard eCommerce KPIs e-commerce statistics - tables To create these tables, create a header describing each of the reports and add appropriate column headers as shown above. Next, you need to reference the cells displaying the relevant data in the individual report sheets you generated.

To add the comparisons, add the formula below, format the cells as percentages, and add conditional formatting rules: Advertising image masking service Continue reading below For YOY comparisons: = (CURRENT MONTH-YOY) / YOY For YTD comparisons: = (YTD-YOY) / YOY Revenues and projections since the beginning of the year To create the revenue projection chart against target and yearly data, you can use the FORECAST function to project the coming year's data based on previous performance. To create a chart to represent this data, you will need to ensure that your forecast column is next to your YTD and YOY data in a separate sheet before selecting all three columns and inserting a chart via the insert menu.

Projection board Orders broken down by city To view the breakdown of orders by city for the current month and the previous year, select the cities and session columns in the individual report sheets and insert a pie chart based on the selection: orders distributed by city Best performing products To view the top performing products as a graph on your dashboard, you need to go to the individual top products report sheet and make sure the product names and product total revenue columns are selected before creating a bar chart based on the selection: ecom-top-products Step 5: Automate and share your report Now that you've created your reports, you need to make sure your reports are updated automatically. To do this, navigate to the Google Analytics add-on menu, click schedule reports , and enable reports to run at appropriate intervals to suit your needs.