Search & Analytics Year In Review
As we head into the holidays, we’re looking back at our own metrics for top posts of the year, and we wanted to share a recap of the most read stories in several categories on Search Engine Land.
In the Search & Analytics column, our experts cover everything from the basic installation of tracking codes and tags, to advanced statistical analysis to measure the success of your organic SEO activities, paid search campaigns, social media efforts and everything in between.
In 2012, search marketers were also faced with some bigger topics related to data analysis – with ‘big data’ being all the rage, changes in Google data sampling and the appearance of the ever frustrating (Not Provided).
Here’s a rundown of the analytics related topics that resonated most with search marketers:
Top 25 Posts Of 2012 By Search & Analytics Columnists
- How To Manage Big Data With Pivot Tables by Annie Cushing
- A Marketer’s Guide To Table Formatting In Excel by Annie Cushing
- How To Make Google Analytics Talk To Excel, In Plain English by Annie Cushing
- Google Analytics Update To Organic Reports by Daniel Waisberg
- Work Smart, Not Hard – An Introduction To Google Analytics Dashboards by Carrie Hill
- How To Turn (Not Provided) Into Useful, Actionable Data by Carrie Hill
- 10 Simple Tips To Make Your Excel Charts Sexier by Annie Cushing
- Using Google Analytics To Collect & Benefit From AdWords Position ROI by Carrie Hill
- Easy To Advanced Uses Of Cell Formatting In Excel by Annie Cushing
- How To: Google Analytics Installation For Novices & Beginners by Carrie Hill
- How The Era Of ‘Big-Data’ Is Changing The Practice Of Online Marketing by Nathan Safran
- How Much Is A Click Really Worth? by Benny Blum
- How To Go Picasso On Your Data With Conditional Formatting by Annie Cushing
- A Primer On AdWords Remarketing Using Google Analytics by Carrie Hill
- Conversion Rate Optimization In Paid Search: Why Click Through Rate Matters by Benjamin Vigneron
- Google Analytics Now Data Sampling: What’s The Catch? by Benny Blum
- Are You In Danger Of An Online Traffic Crisis? by Carrie Hill
- 5 Common Tracking Problems: How To Troubleshoot & Fix Them by Carrie Hill
- How To Gather Evidence To Help Determine If It’s Time For A Mobile Website by Carrie Hill
- Virtual Pageviews Or Event Tracking – Which Is Right For You? by Carrie Hill
- Justified – Beginning Steps To Proving Your Internet Marketing Point by Carrie Hill
- Understanding Your Analytics Versus Campaign Management Tools by Benny Blum
- Using Data To Better Understand Tablet Consumer Behavior by Benny Blum
- Dear Google: Take Me To Dinner First Before You Try To Score by Nathan Safran
- Reporting On Social Media Engagement by Carrie Hill
Annie Cushing’s Excel Master Class For Marketers
As you can see above, several of Annie Cushing’s articles landed towards the top of the list. Apparently, search marketers are in dire need of more Excel tutoring, especially for those on Macs, as Annie’s guides tend to offer some support for Apple fanatics since this segment of Excel users tend to be left out a little in the standard technical documentation. For 2013, it’s very likely we’ll keep some focus on this hot topic to help search marketers out with their reporting duties!
Here’s the complete guide, from start to finish, in case you missed any:
- A Marketer’s Guide To Table Formatting In Excel
- How To Manage Big Data With Pivot Tables
- Easy To Advanced Uses Of Cell Formatting In Excel
- How To Go Picasso On Your Data With Conditional Formatting
- 10 Simple Tips To Make Your Excel Charts Sexier
- How To Use Macros You Find Online In 6 Easy Steps
- How To Make Google Analytics Talk To Excel, In Plain English
Some opinions expressed in this article may be those of a guest author and not necessarily Search Engine Land. Staff authors are listed here.
(Some images used under license from Shutterstock.com.)
Analytics news and expert advice every Thursday.