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

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

How Do I Find my Google Analytics Profile ID?

After running setup, the software will guide you through authorizing data access, and choosing your default profile. From then on, many reports will always use that default. Changing the Default Profile If you would like to change the default profile, simply select it from the profiles list and click “Save Default” A dashboard with multiple [...]