Monthly Trend of Ecommerce Metrics (a Customizable Dashboard)

All of the metrics relating to Ecommerce, conveniently in one screen. Shows the trend of values for every metric over a 12 month period. Get the spreadsheet here:google-analytics-ecommerce-metrics Click the Refresh Data button on the ribbon bar. Your own data will show. Customize It Open the worksheet named “_actions”. Change the year and month to [...]

Download Google Analytics to your Computer

Power Queries Do you need to build reports that are outside the scope of the free reports offered by Google? Multiple Account Multi-View Multi-segment Powerful ways to use goals, events, multi-channel funnels Up to ten dimensions and seven metrics -- downloaded in one query Re-usable queries over many accounts and views Big data, Efficient Refresh [...]

Build Reports and Dashboards with Multiple Google Analytics Segments

Build Reports and Dashboards with Multiple Google Analytics Segments Segments adds precision to your Business Intelligence Segments focus the values on a report to web events such as visits from specific geographies, those who looked at specific products, or visitors who landed on a specific set of pages. There are lots of reasons to use segments, these are just a few examples. Why [...]

Including Multiple Google Analytics Views

How To Build Reports and Dashboards with Multiple Google Analytics Views If you need to have multiple Google Analytics Views on the same dashboard or report, then this is the solution for you. You can build reports and dashboards in Excel, or save to a database for use with query, reporting, dashboard, or visualization tools. You can also [...]


Discover the channels that drive the sales of your best and worst sellers This is one immediately useful topic that you can invest your time and get a true payback. Start by getting Google Analytics dimensions “Source and Medium” and eCommerce “products” for the past year into an Excel Spreadsheet. This will show you: For each product, which channel performs [...]