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 [...]

Download-and-Analyze-Traffic-Source-Medium-Product-Revenue-Into-Excel

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 [...]

How Traffic Source and Medium affects your company’s Goal Completions

Do you care to know how Traffic Source and Medium affects your company's Goal Completions? If you know which sources and medium combinations drive highest values in goal completions, you can optimize your marketing activities to promote the more favourable combinations. For example, you can increase or decrease paid advertising or organic search along specific [...]

Google Adwords – Ad Group Analytics – Top Ranking and Long Tail Views

This sample spreadsheet lets you see the top ranking Ad Groups by month over one year. When you can see which months and which Ad Groups were performing better, you can imitate the winners and drop the losers. For each Ad Group, in each Month, you get the following data. Impressions aka ga:impressinos Ad Clicks aka ga:adClicks Ad Cost [...]