Tutorial Before we dive into our tutorial, I want to note one thing related to building queries that isn't entirely intuitive: when SELECTING multiple columns, string them together using a comma between each. You don't need to use commas when jumping from one clause to another. Let's move on to the Google Sheet I've set up to practice what we've learned here. Start with the instructions tab for a quick overview, review and familiarize yourself with the data in the " data " tab, then head to the " query - easy " tab to test your new skills in request. Finally, I'm working on adding a more advanced section which will be in the ' query - advanced ' tab, but you'll need to check
that out so be sure to sign up for our newsletter if you're interested. Also, don't forget to read another one of our articles on essential formulas for a blog, post it on social media, and the likes and shares start pouring in. You lie down, admiring your employee email list noble achievement, like Michelangelo in the Sistine Chapel. Looking at Google Analytics a few weeks later, you're shocked to find that the flow of social media traffic has slowed and, to make matters worse, your post hasn't achieved an organic ranking. Which give? Optimizing for posts that have performed well on social media but not in organic search is a quick
win opportunity because the topics have essentially been pre-approved for the interest of your audience. With the right settings, you can easily turn your one-trick social ponies into SEO workhorses. The success factors for social media posts are different from the success factors for organic search. When a blog post does well on social media but doesn't rank organically, what does that tell you? Perhaps the topic is inherently interesting and clickable, but the post is not optimized for SEO ranking factors. Maybe your social media channel's messaging and aesthetics