Posts Tagged ‘Excel’

How to Build the Moz Keyword Difficulty Tool in Excel with Moz and SEMrush

How exciting is that? By combining SEMrush’s “phrase_organic” with Moz’s URL Metrics API call, you can cobble together a prototype keyword difficulty tool. My example in this video is a bit scrappy, but I’m sure you get the point: Check out the rest of our instructional videos on your Youtube channel: http://www.youtube.com/user/SEOgadget No SEMrush Account? If […]

The post How to Build the Moz Keyword Difficulty Tool in Excel with Moz and SEMrush appeared first on SEOgadget.

Find New and Lost Back Links with MajesticSEO and SEOgadget for Excel

One of the most pressing issues in current SEO strategy is developing your ability to monitor new links, and track lost links. It’s a sad fact of our day to day lives as marketers in search. Some of our time doesn’t get spent on marketing at all, it gets spent on undoing bad marketing through […]

The post Find New and Lost Back Links with MajesticSEO and SEOgadget for Excel appeared first on SEOgadget.

Grepwords – Powerful Keyword Research without Adwords

Google took away the Keyword Tool, and pretty much every SEO Agency’s API access earlier this year. Let’s not hold it against them, though, because Grepwords is amazing and it’s available in SEOgadget for Excel. You’ll remember that for the longest time, I’ve taught keyword research and categorisation methodologies using our Adwords API Extension for Excel. […]

The post Grepwords – Powerful Keyword Research without Adwords appeared first on SEOgadget.

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

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 […]

The post SEOgadget for Excel: How to Get Your Back Link Data with MajesticSEO’s API appeared first on SEOgadget.

Creating Efficient Data Collection Systems for SEO and Social

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 […]

The post Creating Efficient Data Collection Systems for SEO and Social appeared first on SEOgadget.

Introducing SEOgadget for Excel

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 […]

The post Introducing SEOgadget for Excel appeared first on SEOgadget.

Mining User Data in Excel with the FullContact API

Recognized and prominent brands (like Target) are turning to big data to mine user information to find the best ways to reach and retain their customer base. Why let the big guys have all the fun? If you have a list of your users’ email addresses you can access your users’ personally identifiable information and social profiles. All […]

The post Mining User Data in Excel with the FullContact API appeared first on SEOgadget.