If you have implemented Google Analytics e-commerce tracking, an e-commerce report can easily be generated from your Google Analytics data to display the following information: Revenue, order quantity, average order value, and average items per order based on last full month vs. last year and year-to-date data vs. last year: e-commerce statistics - tables Number of orders (broken down by city) based on last full month and year-to-date data: orders distributed by city Top products (ranked by revenue) for the last full month: ecom-top-products Projected revenue over one year and target: projected revenue chart To retrieve the information needed to create these reports, you must modify your report setup sheet to reflect the settings shown here: config report ecom.
Sample report setup (open image in separate tab to view details) Definition of automated date ranges In the screenshot hair masking service above, I've displayed the metrics, dimensions, and sorting options needed to create each of the reports that make up the eCommerce dashboard. Since you will be automating the generation of these reports, it is important that you set the start and end dates for each report to update automatically. We will use the DATE formulas in the report setup sheet to do this. Advertising Continue reading below In the examples shown in columns O, P, Q, S, and U, we are looking to create reports that include data for the last full month versus the same month of the previous year.
Therefore, in the report setup sheet, we need to ensure that the end date is automatically updated to the last day of the last calendar month, and that the start date is set 13 months before the end date column. In the End Date column , we would need to insert the following formula In the Start date column , we can use the EDATE function, to return the date 13 months before the end date (O6): EDATE (O6, -13) To compare this to the previous year (as displayed in the R&V columns on the sample setup sheet), you would reference the formulas listed above, minus one year: For the end date, choose a cell referencing the last day of the most recent month (O6, for example) and use the following formula: EDATE (O6, -12) For the start date, we can again use the EDATE function, to return the date 13 months before the end date as shown in the example above.