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
Best application performance monitoring tools
Ah, what a summer! The initial concept of this In the Trenches column was to provide the day-to-day search engine marketer with tips, tricks, and news to make them better at their jobs. I have been wanting to do this Microsoft Excel series for over a year, so I thank again my editors here at Search Engine Land for letting me get this done. Excel is such a huge component to all of our workdays that I thought it deserved this level of attention. Once again, my goal was not an Excel 101 for everyone, but rather highlight some advanced techniques for online marketers to be more effective and efficient when using the tool. Based on the great feedback I’ve received, I think I’ve been able to hit the mark. But, if you’re going to social bookmark any of these posts, this final post is the one to tag. There’s a mini-guide to the previous five posts, a ranking scale of Excel ability, a twenty question skills test, as well as some final tips and tricks that I think … [Read more...] about Excel At Excel For SEM Applications, Part 6
There are a huge number of search engine optimization (SEO) tools out there. Creating SEO tools has become a cottage industry, and there are many companies out there making their living by providing tools and data. It seems like a new tool gets launched almost weekly. So, how do you know which ones to use? There are both free and paid tools, and you can spend a fortune every month licensing the paid ones. You can also spend a huge amount of time looking at these solutions, delving into reports, slicing and dicing the data they provide, and being overwhelmed by the sheer volume of data available, rather than working on the tasks that will actually improve your SEO and drive more organic traffic and conversions. Which tools produce the best ROI for your time and money? Some of my favorite SEO tools are below. Free Tools For those just starting out in search engine optimization, there are many excellent free tools available to you. Some of these are tools I would consider the basic … [Read more...] about Tools, Tools Everywhere! Which SEO Tools Are Worth Your Time?
In many ways, Bing Webmaster Tools is actually more advanced — and caters more to SEO professionals — than its Google counterpart, Google Search Console. For this, I give them a round of applause. I mean, would we have a Google Disavow Links Tool if Bing hadn’t released one first? Maybe; but I still applaud Bing for catering to SEOs. Bing Webmaster Tools has a lot to offer, and in this post, I aim to profile all of its major features. This information comes from both Bing documentation and firsthand experience. Adding & Verifying A Website Adding a site to Bing Webmaster Tools is easy. After logging in, enter the URL for your site’s home page and click the “Add” button. From there, you’ll be directed to a screen to enter basic information and a sitemap URL. Before you can begin maintaining your site and viewing data, the website must be verified. After adding a site, “Verify Now” will appear, giving you three options for … [Read more...] about The Ultimate Guide To Bing Webmaster Tools
Let’s face it: Content marketing is a bit overhyped. According to the Content Marketing Institute (CMI) and MarketingProfs, at least 86% of B2B marketers and 77% of B2C marketers are now engaged in content marketing. While I completely agree that content marketing is an essential component of a successful search engine optimization (SEO) initiative, it is not the only component required for success. I believe the vast majority of in-house and agency-related search engine marketers are involved, in some capacity, with their organization’s content marketing initiatives. According to the above-referenced reports, SEO is directly or indirectly related to nearly all facets of content marketing performance metrics for both B2B and B2C marketers. But I shouldn’t have to tell anyone who regularly reads this publication that productive search engine optimization is based on a combination of factors, for which content marketing provides an opportunity to execute a fair … [Read more...] about What To Do When Content Marketing Fails To Improve SEO Performance