I’m spoiled now. I rarely go into the Google Analytics (GA) interface anymore. You know why? There are cool Excel plugins that will pull your data right into Excel. Of course, most of them are PC-swim only. Sorry, Mac users. I’m going to be testing out the only one I know of for Mac, but I can’t verify how good it is. (Disclaimer: I’m not in any way associated with any of the GA plugins for Excel or their manufacturers.) Before jumping in, let’s talk about some basics that you will need to understand to navigate the API. Learning The Language Of The API The trickiest part about using the GA API is wrapping your brain around all the geek speak. Instead of using the same labels the interface uses (which are intuitive to non-bots), the API switches everything up. But here are some spy-grade deciphering tips that will help you avoid some of the traps that threw me when I was an API fledgling: Path: You’ll see path this and path that all through the … [Read more...] about How To Make Google Analytics Talk To Excel, In Plain English
Block google analytics
A day after warning publishers against advertorials, will Google’s search team now have to penalize parts of its own company for running advertorials? Perhaps, and if so, it wouldn’t be the first time. It’s also another absurd chapter in Google’s war on paid links. Google Says: Advertorials, Beware! After news came out yesterday that Google had apparently penalized Interflora for running advertorials — and also reduced the PageRank values of many UK newspapers that carried these — Google finally blogged a general warning against such practices. From its post: Please be wary if someone approaches you and wants to pay you for links or “advertorial” pages on your site that pass PageRank. Selling links (or entire advertorial pages with embedded links) that pass PageRank violates our quality guidelines, and Google does take action on such violations But as Aaron Wall at SEO Book covers today, examples of Google running advertorials could put … [Read more...] about Will Google Penalize Chromebooks, Google Analytics, AdWords & Google+ For Using Advertorials?
Google is unwrapping a suite of products aimed at bringing simplicity to the often laborious work of unifying and syndicating marketing and advertising data across channels for large organizations. It's not necessarily a novel effort - Oracle, Adobe, even Facebook's Atlas are in this mix - but the suite's native integrations with AdWords and DoubleClick make it particularly noteworthy for search marketers. Dubbed Google Analytics 360 Suite, the package offers a mix of brand-new and rebranded solutions for the enterprise. First, a rundown of what's new: A data management platform: Google Audience 360 (in beta) is the company's long-awaited data management platform (DMP) that early reports had been calling DoubleClick Audience Center. A DMP has been the arrow missing from Google's advertising technology quiver (or layer of the stack if we're sticking with ad tech lingo). Here's what we know so far about Google Audience 360: It, of course, natively ties to DoubleClick and AdWords, but it … [Read more...] about Google unveils Google Analytics 360 Suite with a new DMP, landing page testing tool and more
Want to ask Jenny an SEO question for her bi-weekly column? Fill out our form or use #AskAnSEO on social media. This week, we received a question so big, I decided to dedicate an entire post to it. I’ve also received this question multiple times while presenting analytics presentations. How can I filter out spammy referral traffic to my site? I heard Google started filtering them out but still see them. –Kenneth F. via Twitter My static answer when giving presentations is to view the Google Analytics Solutions Gallery and search for referrer spam or block bots or similar. There are some great resources there for people just getting started. But the real answer to this question is a lot bigger, and it has many parts: Understand what you’re dealing with. It’s not just bots. Filter wisely: Set up a separate view. Block Bots in Analytics. Discover referrers manually. Create a “bad referrer” filter. Block bad bots from the website. Carefully. Part 1: … [Read more...] about Ask an SEO: Filtering Referral Spam in Google Analytics