SEOgadget for Excel: How to Get Your Back Link Data with MajesticSEO’s API

bottle-house

One of the biggest problems we’ve always had with our new users getting to a confident user level with SEOgadget for Excel is simply put, the level of accessibility of the documentation. Learning a completely new syntax for 6 different API services is, hard. I really hope we’re helping there with the instruction manual, but I’m also in the process of recording some short videos on getting started with the tool itself. Here are the first two: How to Install SEOgadget for Excel Here’s the long over due “how to”…

Creating Efficient Data Collection Systems for SEO and Social

gears

As marketers we only have so many hours in the day. Nothing is worse than having your team spend time on menial tasks (like data entry) when there’s real work to do. That’s why it’s crucial for managers to create efficient systems – so teams can get more accomplished and make a bigger impact. Most data entry work is delegated far down the totem pole. Managers are removed from data entry, so making the process as efficient as possible isn’t always a priority. If you aren’t “technical,” it’s easy to accept…

The “Big” Content Promotion Tip That’ll Save You a Lot of Pain: Never Fail.

big-top

A good marketer knows when his idea sucks. Yet many marketers I come across relentlessly push their content without thought for one fundamental influencing factor of its likely success: appeal. You have all been involved, at some stage in your careers in a flawed attempt to be creative. You’ve had a “great” idea, everyone in the room agreed to it, you got the research done, you hired a designer, you hired a developer and everything looks great. The big day comes, it’s time to go live, to publish your work.…

SMX Stockholm 2013 – Google Analytics for SEO

4930590437_0094b620c9_b

This morning I had the pleasure of coming back to SMX Stockholm for a second year, this time to join a session on Google Analytics for SEO alongside Nikki Rae.  Instead of running through Analytics from purely a reporting perspective, I decided to give the topic a little twist and focus more on how to get specific actions points that you can inject directly into your SEO campaign. To get this across, I focused on four questions – and for each one looked at how you can use GA data…

Introducing SEOgadget for Excel

geordi-worf

For the longest time I’ve loved working with Excel in new ways. Our plugins for Excel have been hugely popular in the SEO community and today I’m hopeful you’ll love the next generation of our Excel Extensions, SEOgadget for Excel. Get the Brand New Downloadable PDF Guide There are lots of headlines for features, the main thing being a particularly handy new guide to everything the extension can do. That particular element of our tool has been a long time coming – basically, if you weren’t a member of my…

Scraping Schema Markup for Competitive Intelligence

scraping business intelligence using Outwit Hub

Structured mark up is crucial for e-commerce websites if they want to stand out in the SERPs. Because e-commerce sites are generally set up to scale, scraping all of their information is very easy. All it takes is a Screaming Frog crawl and Outwit Hub. For dropshippers and affiliate sites, harvesting competitor data within schema mark up tags can be extremely useful. If you are selling the same products as your competitors, you can compare pricing, product descriptions, calls to action/special promotions – anything – and analyze how you stack…

Why Your Expensive, Time-Consuming Content Doesn’t Work.

Peacock Alley, Photograph by © Andrew L. Moore http://www.andrewlmoore.com/photography/detroit/peacock-alley-detroit/

Which question would you kick-off a content strategy with? What do we put on our landing pages and in our white papers and on our blog? What gets our audiences excited or helps them do their job better? You might say #2 because it sounds right, and you’ve probably thought about this before. But check yourself. Is this really what you’re doing? Or are you producing content because that’s what sites are made of? Tell me if this sounds familiar: “We need to create landing pages to attract search traffic.…

The Future of Local Discovery is About the Story, Not the Place

Cover Photo courtesy of an Francisco History Center, San Francisco Public Library and FoundSF.org

Did I say the future? I mean the now. “Local” discovery in our books has historically been highly focused on optimizing for the right category, address, keywords, location, etc. What are people searching for in San Francisco? Make a page for it! But which one of these descriptions of the same place below is more powerful?: The absolute best lazy Saturday people-watching in the city, with a drop-dead gorgeous view to boot. Crissy Field It’s not the name of the place that captivates us (usually) but the story behind it; The history,…

Vanity Check: “Keyword Intelligence Tools”

ducks-rubber

It’s not about the tools you have, it’s about how you interpret the data. Most importantly, it’s how you evaluate what your data is really telling you. Look at this chart: Now, ask yourself what you see. Say it out loud, or in your head, whatever. I bet the first thing you said was: “The rankings on this site dropped”. That’s not correct. If you said, “The keyword rankings for this site have dropped according to Searchmetrics.” You’d be perfectly right. The problem with keyword intelligence The very name implies someone…

301 Redirect or A Google Webmaster Tools Change Of Address?

signpost

Or both? It is both, obviously. When you carry out an effective domain migration, there are a lot of changes at stake. If you follow a clear process for your site, things usually go according to plan. Have you heard the adage about car mechanics always have the worst cars? Or decorators have the least well maintained homes? When we migrated from SEOgadget.co.uk to SEOgadget.com I forgot something – the Google Webmaster Tools change of Address. Actually, “forgot” isn’t quite accurate. I couldn’t be bothered because I had lots of other…