Year: 2010

  • GACP Summit at the GooglePlex

    This week, Google held their annual summit for Google Analytics Certified Partners (GACP: Previously Google Analytics Authorized Consultant (GAAC)) I first attended the GAAC/GACP summit in 2007 as an employee of Lunametrics, and to this day, I consider it one of the best summits I’ve ever attended. On top of all of the sights, such […]

  • Intro to Google Analytics

    I was recently watching some of the presentations from Google Analytics Conversion University and decided to go back and watch the Intro to Google Analytics video again. As I watched, I realized that this would be a great video for my clients to watch. If you are one of my clients, or you even have […]

  • Microsoft and Yahoo Analytics

    While Google Analytics is by far the best analytics package I’ve ever used, I’m disappointed to see that neither Microsoft nor Yahoo! have been able to stick it out in the web analytics arena. Microsoft Gatineau (Probably better known as Microsoft AdCenter Analytics) was an interesting but short-lived attempt at web analytics with demographics. We […]

  • September Special – Free Keyword Analysis

    For September, we are offering a free keyword analysis for your online marketing efforts. We will analyze your website and will talk with you about which keywords you intend to target. Then, we will research related keywords to determine the level of competition and difficulty to rank for those keywords. Finally, we will recommend at […]

  • Gmail Priority Inbox

    Google just released the Gmail Priority Inbox and I already think it’s a fantastic improvement to email as we know it. Gmail has always had the “star” feature to flag important emails, but if you’re anything like me, those emails just move down the list with all the rest, never to be seen again. The […]

  • Excel Macro to Generate SQL Insert

    I am in the process of creating a database of County information, and I needed to insert several thousand records. I was able to get the data into Excel, but now I needed to write an SQL Insert statement to get the records into my database. SQL wizards, I’m sure you know a more efficient […]

  • Test Your Google Analytics IQ

    Google is now offering a Google Analytics course for web analytics! Plus, if you want to get your Google Analytics Individual Qualification you can pay $50 to take a test. If you score at least 75% on the test, you become qualified. They say that this is proof of your Google Analytics competency, but there’s […]

  • I Love Google But…

    I love Google! They provide incredible services to the online community for free! Plus, they’re giving away Gmail stickers now too! However, I agree with Brian Clark at CopyBlogger in that we shouldn’t use so much energy to game the system. We need to concentrate on excellent content that is useful to many people. Writing […]

  • Excel VLookup Function

    A wonderfully powerful and easy to use way of comparing data across Excel worksheets is the VLookup function. I’ve been helping a lot of people with this function lately, so I thought I’d get a quick tutorial out there. Let’s start with the syntax of the VLookup function: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) Here’s an example […]

  • Outlook Attachment Reminder Macro

    How many times have you written an email about “the attached file” only to forget to attach the file before hitting send? If you follow the instructions in this post, that’ll never happen again! We’re going to add a VBA macro to Microsoft Outlook that searches your email for the text “attach” when you click […]