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

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

Make Google Analytics Weeks Start on Mondays

Frustrated that Google Analytics displays weekly metrics starting on Sunday? With NEXT Analytics, querying weekly data that starts on Mondays is easy—like “you’ve got to be kidding me” easy. In fact, you can tell NEXT to fetch weekly data starting on any day of the week. With NEXT Analytics, you’re in control. Select your dimensions [...]