As 2019 starts to wrap up, and 2020 planning is upon us, we’ve compiled our top 10 blog posts of the year (in case you missed ‘em). Check out the posts that our readers couldn’t get enough of this year and let us know what your favorites were in the comments below and on social (@SeerInteractive)!
Learning how to use =QUERY in a familiar setting like Google Sheets is a pretty good way to start your journey towards working with big data.
In this step-by-step tutorial, you’ll learn how to use the powerful =QUERY function. Whether or not you’ve used it before, you’ll get an introduction to the syntax and function plus a Google Sheets tutorial (and template!) to apply what you learn.
Building relationships in Power BI is a powerful way to better leverage your data for analysis. Learn how to create a Many to Many relationship in Power BI using a bridge table in just 6 easy steps.
From avid users to newbies, this tutorial is for the Search Analyst who wants to use Power BI for analyzing which search terms are converting alongside related organic keyword rankings to find opportunities for optimizing and/or creating new content.
If you use Google Data Studio for reporting/analysis, check out my tutorial on how to create new fields using CASE statements for manipulating your data into more useful categories. Included in this post are 12 copy/paste CASE statements you can apply to your own Data Studio dashboard for better analysis of common data points.
Google Data Studio can be a really powerful reporting tool for SEOs – providing extra layers of analysis and insights.
We’re not surprised that yet another easy-to-follow Google Data Studio tutorial made our top 10 list this year! In this post, Joe shares Seer’s favorite tips & tricks to use GDS for your SEO reports – it’s a must read if you want to level up your data visualization game.
Do you use Google Tag Manager for website tagging? If so, are you prepared for the worst, even while hoping for the best?
This post will help you ensure you know how to take action and quickly fix your data when something goes wrong with your GTM implementation. From how to troubleshoot broken tags and how to roll back a container version to the most common mistakes to avoid – bookmark this post if you use Google Tag Manager or send it to a colleague who does!
While Store Visit reports in Google Ads have been around for awhile, Google Analytics just got the memo this year. If you do business offline, this post is for you! You’ll learn how to use Google Analytics Store Visits in Beta to analyze the impact of online behavior on driving customers to your stores offline (and vice versa!).
If you have ever tried to diagnose a decline in Organic Search traffic, you should know by now it’s not easy. There are just so many variables involved with understanding the performance change of such an important digital marketing channel.
Check out this SEO post for 18 ways to diagnose what happened to your Organic traffic (plus get next steps for reversing the trend!)
If you run TV ads, or report on their impact for a living, this post will walk you through a quick and dirty method for applying to your analysis. You’ll learn how to measure your online traffic and the behavior of users who land on your site after they’ve been influenced by your TV ad(s) in one of our top posts of 2019.
Search Engine Optimization (SEO) can be incredibly effective at improving your website’s experience and gaining visibility in search results pages. If you do a lot of SEO work on your website, it can often be hard to keep track of all your SEO optimizations over time.
Enter Google Data Studio’s “Blended Data” feature. While data blending can be leveraged for a variety of use cases – this post shows you how to use it for reporting on the impact of your SEO optimizations on website performance.
Last but surely not least – this post launched not too long ago and quickly became a favorite for our readers. For Google Optimize users, and those who plan on using the tool in the future, you can’t afford to miss this. From the basic setup of an A/B test and choosing KPIs for judging results to defining statistical significance and levelling up your strategy with personalized experiences – this comprehensive guide is for any Google Optimize user!
The following made the Top 20 list – deserving honorable mentions for holding it down at the 11-20 spots:
- The Essential SEO Starter Kit: 55 Resources for New Analysts
- Google Analytics App + Web – The New Frontier In Digital Analytics?
- How to Communicate the Value of SEO to Executives
- YouTube Expands Advertiser Access to 15-Second Non-Skippable Ads
- What is Hotjar Used For and How Does it Work?
- How Google Analytics Data Sampling Works & What You Can Do
- Google Analytics 360 Benefits
- Introducing ‘Attribution Beta’ in Google Analytics
- UX Checklist Series: Form Design
- Introduction to Search Ads 360 and Display & Video 360
🎉Wrapping Up 2019
There you have it, Seer Interactive’s top 10 and top 11-20 blog posts of 2019. These posts were the most read and most shared out of all of the content we brought you this year – cheers to that! 🥂
What do you want us to tackle in 2020? Leave a comment below and let us know what you’re most excited to read about next year!
Sign up for our newsletter for more posts like this – delivered straight to your inbox!