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)!
Our Most-Read Blog Posts of 2019
#1: How to Query Data in Google Sheets with =QUERY Function by James Corr
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.
#2: How to Join Many to Many with a Bridge Table in Power BI by Christina Blake
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.
#3: How to Create CASE Statements in Google Data Studio by Kia Street
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.
#4: 3 Quick-Win Google Data Studio Tips for SEO Reporting by Joe Meola
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.
#5: Why Isn’t My Event Tag Firing? How to Troubleshoot Broken GTM Tags by Kevin Rutter
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!
#6: Tie Together Offline & Online Engagement with ‘Store Visits’ in Google Analytics by Aniqa Anwar
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!).
#7: 18 Ways to Diagnose a Decline in Organic Traffic by Katie Kirchner
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!)
#8: TV Advertising Effectiveness: How to Measure & Analyze Television Ads by Aniqa Anwar
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.
#9: 5 Steps To Track SEO Recommendations with Blended Data in GDS by Jackie Cammarata
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.
#10: Google Optimize How To Guide by Kevin Rutter
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!
Our Honorable Mentions of 2019 (because why not?)
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!