ShufflePoint is a paid application that uses Excel’s built-in “Web Query” function to pull data from Google Analytics into Excel. It is an extremely powerful tool and allows you to take advantage of Excel’s data manipulation abilities. This gives you the freedom to develop compelling visuals that will help you quickly assess the performance of a website. When I was developing my first ShufflePoint report, I found that thinking about and planning data organization took the most time. My hope is that this article will help you graph your Google Analytics data in Excel with as little trial and error as possible.
If you’ve never heard of Enhanced Ecommerce, the documentation and information available might seem a little overwhelming or overly technical and focused on implementation. But don’t let that be an excuse to dismiss this great new feature and miss out on one of the most important updates to Google Analytics this year!
By the end of this post you will be able to answer the big questions about what it is and why you should use it.
Any time you make a significant change related to your website, whether that’s content or the underlying architecture, you should check to see if your changes have impacted the SEO best practices you’ve already put into place.
A few weeks ago, a client unexpectedly informed me that they migrated their web server to a different platform. As I scrambled to see if there were any SEO issues (there were), I realized how little was written on this topic, so I began asking questions and taking notes.
Disclaimer: I’m no expert on servers and web hosting.* However, I am one of the world’s most prolific practitioners of freaking out about things that could hurt a site’s search engine rankings.
Below are a few big takeaways regarding how server software can impact SEO and how to ensure your server switch is smooth with SEO. Read More…
During the start of my professional career, I stubbornly favored SEO and never entertained the idea of picking up some PPC skills in my free time. As time went on, the sands began to shift and I was asked to do some “light” work in paid advertising. I quickly became overwhelmed by the complicated user interface that had enough options to keep you clicking for days.
The flaw in my approach is obvious now, but hindsight is 20/20. I tried to jump into the middle of an intricate setup and understand it by clicking around, which was ineffective and a waste of my time. It was then that I realized I had to learn PPC from the ground up.
I learned the most and the fastest by planning, creating, managing, and tweaking my own AdWords account. These are the three most insightful things I learned from building a paid search account from the ground up: Read More…
Firing a Google Analytics Virtual Pageview with Google Tag Manager is easy, and far more powerful than ever before.
When our clients or training attendees upgrade from classic Google Analytics to Universal Analytics implemented through Google Tag Manager, we often get questions about how to transition these Virtual Pageviews from inline code to being implemented through GTM.
There are a number of different ways you can implement Virtual Pageviews, and hopefully this will provide one solution to help ease the transition to a GTM implementation of Google Analytics.
UTM campaign parameters. We love them. We hate them.
They make it easy to track both online and offline marketing efforts. But they aren’t very pretty to look at, and they’re difficult to implement reliably, especially for a layperson (i.e. non-technical person).
Often, there’s a situation where we want to track a number of different approaches or people contributing to a campaign. Imagine the pushback you’ll get when you suggest each person modifies their UTM parameters to personally identify themselves or the approach they’re using.
Fortunately, there’s an easier way to track certain types of activities without having to resort to including all those UTM parameters. We can use a simple URL hash and some Google Tag Manager magic to uniquely identify each person.
Every discussion about the importance of specialization in marketing comes with a disclaimer: it cannot come with the risk of total tunnel vision. Digital marketers must maintain a broad understanding of each channel in their marketing mix, applying lessons and strategies from one to the others.
This article provides a brief overview of public relations (PR) and the three things that we should all learn from publicists: Personalize, Evolve, and Provide Value. Read More…
If you’ve been working with Google AdWords for some time, then you understand how quickly features and tools within the platform can change. If you’re new to the AdWords game, welcome to the ongoing challenges of AdWords management and optimization. With this in mind, I can’t stress how important it is to stay up to date on the latest greatest AdWords updates.
So let’s bring you up-to-date and take a look at the AdWords changes that have been introduced or announced within the last month or so! Read More…
Google Analytics export to BigQuery is great for getting at the raw session-level data of Google Analytics. But, it’s only for GA Premium (GAP) subscribers. If you have other reasons to need GAP – like increased sampling limits, DoubleClick integration, or additional custom dimensions — and you have the money to spend, GAP is a great option.
Raw GA data?
But what if you’re not a GAP subscriber? Can you still get the raw, session-level data?
In a word: no (at least not from GA). All of the data in GA reports and in its associated reporting APIs is aggregated data. You can create and export reports full of dimensions and metrics, but there’s no report that can give you all of the information for each session the way BigQuery can. Read More…
As we look towards the end of this year and the beginning of 2015, consider how a training in Google Analytics, Google AdWords, or Google Tag Manager may help your career! Choose from seven different cities in the first quarter, ranging from Boston to San Francisco, with stops in Chicago and Denver along the way.
With trainings in cities around the country, we hope you can find a location that is easy to travel to and fun to explore!
Whether you’re just starting out in a new field or looking to get a deeper understandable of the tools you’re currently using, we have a class for you.
Learn how to better collect and analyze your data with our Google Analytics series, futureproof your website with the flexible Google Tag Manager, or drive qualified traffic to your site through paid search with our Google AdWords trainings.
Choose an option below to learn more about the specific topics we cover and decide which trainings would be right for you!
Google Analytics Google AdWords Google Tag Manager