-
Recent Posts
Categories
Category Archives: Web Analytics
PPC Variations Performance Analysis and Reporting
In a previous article, I showed how to set up an account structure for easy slicing and analysis across variations of keyword themes, product types, regions, etc…. This time around, I’m going to show you how to aggregate that data, … [READ MORE]
PPC Management and Data Analysis Made Easier in 4 Steps
One of my favorite toys for effective PPC management is Excel, which may be linked to my general enthusiasm for math and marketing. In my years of managing accounts, I’ve found several tricks that make it much simpler to pull … [READ MORE]
SEO Keyword Research Part II – Digging Into Analytics
Now that you know how to identify the 3 important types of keywords, it’s now time to start your research. Almost all of the information you need for keyword research is out there, whether it is through the Google Adwords … [READ MORE]
Google Analytics Goes Social
So, you have been promoting your business online for a while now – amassing fans and likes, tweeting your companies every move. You’ve made the jump to the latest Facebook design after seeing our webinar. And for what? Has all … [READ MORE]
8 things I’ve learned about bid management tools
Note: This is kind of a continuation of my bid tool rant #1, however it’s not really a rant. I’m going to try to be more open minded this time Here we go! It’s frustrating just trying to get … [READ MORE]
Excel Tips and Tricks for a Successful and Efficient Data Analysis
Excel is the most important and powerful search marketing tool. In PPC Management, Excel is a must-have tool in addition to AdWords (adCenter) Editors. Building keyword lists, writing ad copy, analyzing data and preparing reports – all these tasks mostly … [READ MORE]
Tips & information on 8 different search engine marketing tactics I learned at Mozcon
Two weeks ago I had the opportunity to attend Mozcon in Seattle. I got to see a number of search engine marketing pros speak, and these are some of my favorite Mozcon strategies & tips! 1. Use Micro conversions – … [READ MORE]
Analyzing Correlation Between Paid Search Metrics
One of the important questions is the relationships between the metrics. How does an average position depend on max CPC? Or, how does the conversion volume (revenue) correlate with spend? Microsoft Excel is a great platform for understanding and exploring these relationships between two PPC metrics. [READ MORE]
Got Wheat?
Looking at your data in Google Analytics can give you a false sense of security about how your account is doing (seriously). Let’s see how to avoid the misleading stuff and how to use segmentation to get at what we really need. [READ MORE]
Ad Copy A/B Testing for Statistical Significance is Easy! (UPDATED)
Calculate the statistical significance for your PPC text ad tests. What confidence level is enough to choose the winning ad copy? How much data you need? Read out blog to find answers on these questions and download the statistical significance calculator. [READ MORE]









