Facebook Campaigns Overview

Top 10 by Spend, Clicks, and Value This fully automated report runs inside Microsoft Excel and helps you recognize which campaigns are your best and worst performers. It automatically fills in the report with data from your Facebook Ads Account and publishes the result as an attractive PDF file or Excel file. Files can be [...]

Facebook Campaigns Overview2017-02-12T13:05:55-04:00

Adwords Campaigns Overview Top 10 by Spend Clicks Value

Adwords Campaigns Overview Top 10 by Spend, Clicks, and Value This fully automated report runs inside Microsoft Excel and helps you recognize which campaigns are your best and worst performers. It automatically fills in the report with data from your Adwords Account and publishes the result as an attractive PDF file or Excel file. Files can [...]

Adwords Campaigns Overview Top 10 by Spend Clicks Value2017-02-12T13:05:55-04:00

Google Analytics Custom Events Dashboard and Reporting

Google allows you to store information about what a web visitor does while they are using your web site. By default, it gives you a wealth of information, but often you want to track things that are unique to your organization. They provide a couple of ways for you to store your own specific data [...]

Google Analytics Custom Events Dashboard and Reporting2017-02-12T13:05:55-04:00

Example Dashboard shows 12 month trend for all Adwords Metrics available in Google Analytics in an Excel spreadsheet

How effective is your Adwords spend? Get a complete 12 month overview of everything that happened relating to Adwords. This easily customizable Dashboard runs inside Excel and is free for users of NEXT Analytics. Just download it, and one click later, you'll know how well your pay per click campaigns are doing. Download it Download [...]

Example Dashboard shows 12 month trend for all Adwords Metrics available in Google Analytics in an Excel spreadsheet2017-02-12T13:05:56-04:00

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

Monthly Trend of Ecommerce Metrics (a Customizable Dashboard)2017-02-12T13:05:56-04:00

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

Download Google Analytics to your Computer2017-02-12T13:05:57-04:00

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

Google Adwords – Ad Group Analytics – Top Ranking and Long Tail Views2017-02-12T13:06:00-04:00

Google Analytics – All-in-one Dashboard

Get started in Analytics with this easy to use, easy to customize all-in-one dashboard it already has every single metric plotted for the past twelve months. Just click a button, and all your data shows up. It's easy to customize. There are three flavors of it, take your pick and customize one of them: [...]

Google Analytics – All-in-one Dashboard2017-02-12T13:06:01-04:00

How To Configure a Multi-Profile Report

Google Analytics allows you to create subsets of your web site data; each one is known as a PROFILE. It’s quite common for companies to create a PROFILE for each operational division of their business. For example, this might mean each country unit has its own PROFILE. Alternatively, it might be something other than geographic [...]

How To Configure a Multi-Profile Report2017-02-12T13:06:01-04:00