Ma long table tennis

We’ve updated our Periodic Table Of SEO Success Factors that was created in 2011 to add several new elements, drop a few, broaden it to include “success factors” rather than just “ranking factors” and adjusted weightings of several elements on the table. For those curious about the details, here’s the rundown. First, if you’re not familiar with the table, see our main post today, Now Updated: The Periodic Table Of SEO Success Factors. It will give you an overview as to what the table is about and how to use it. Here’s a quick preview of the table. Clicking on the image takes you to the table’s home page, where you can see a larger version, an expanded version with descriptions, plus download copies to print or get code to place on your site: The original table was created in 2011 by the Search Engine Land editors deciding what seemed to make sense to list and how to weight various factors. For the update, we ran a survey listing … [Read more...] about What’s Changed With The Periodic Table Of Search Engine Optimization

In the previous posts of this Excel series for Search Engine Marketers (Part 1, Part 2, Part 3, Part 4), I’ve shared various tips and tricks for the tool. However, today’s post is just going to cover pivot tables, as I feel they are such an important piece for online marketers to not just grasp, but master. Excel itself can be intimidating and pivot tables are doubly so. I hope this will be the definitive guide to pivot tables for anyone in this industry who has yet to feel one hundred percent comfortable with this crucial Excel feature. By the time you finish this post, you will be a Pivot Table champ (or your money back! LOL.) The first thing to understand is why you would need to put your data in a pivot table. Well, not all data needs to be pivoted. However, when you have a table of data that you’re trying to analyze, pivot tables allow you to quickly extract meaningful information by easily changing columns, rows, and filters to get those useful insights. … [Read more...] about How To Excel At Excel For SEM Applications, Part 5: Master Pivot Tables

I’m proud to announce that Seer Interactive is now a Google Analytics 360 Premium Reseller! Can you explain what that means to someone who might not know? Well, it means that we can now sell the enterprise version of Google Analytics, GA360, to our clients! Usually to purchase GA360, a company must go through a reseller, and we then not only sell that company the product, but we service it and support them as well. So, someone wants to have GA360. They contact Seer, and you can sell them GA360? That’s right! But we don’t just sell you GA360, we are an active partner to help you get the most out of it. We provide unlimited SLA support, which is a way of saying that if you have any problems logging into Google Analytics, or you are missing some data that should be there, we’ll help you, day or night, as long as it takes. We always include a batch of monthly support hours to help you and your team use the product (and all its potential integrations such as … [Read more...] about LOOK MA! We’re Google Analytics Partners + Premium Resellers

Google’s recent changes to their Search Console API have allowed for interesting data analysis via Impressions and Clicks data. Leveraging the power of Excel and Pivot Tables, an unprecedented level of detail is available to fine-tune your search marketing campaign. Querying The Queries Google’s API documentation has excellent code samples and query structure guidance, and it should be considered essential reading for any SEO looking to push data to the fore in their SEO strategies. For today’s article, I’m going to cover the “Search Analytics: query” section, which explains how to use the Search Console API to query your search traffic. The API allows segmentation of your data that mimics much of the functionality in the web interface. So, why not just perform analysis in the web interface? Because by extracting the data, we can further filter it to gain real granular insight. In doing this through the API, we can automate repeating that analysis. … [Read more...] about Use Google’s Search Console API & Pivot Tables To Supercharge Your Long-Tail SEO

If there’s one task most marketers share — whether their focus is SEO, paid search, or social media — it’s collecting and interpreting data. Being able to slice and dice the data to find actionable insights is key to effective analysis. Yet, one of the biggest mistakes marketers make is trying to wrangle static data instead of taking advantage of Excel’s table formatting, which basically turns your data range into an interactive database. I hope to rectify that injustice against innocent data with this guide. Microsoft introduced table formatting in its 2007 version (2011 for Mac). For me, it was love at first sight. You’ll understand why when you see all the cool things you can do with your data once you format it as a table. We’ll just use one of the built-in styles for now but then customize one later in the post to show how easy it is to create a branded table. I’ll demonstrate using a data dump from SEMRush for a shoe website I … [Read more...] about A Marketer’s Guide To Table Formatting In Excel