TrustRadius: an HG Insights company

SEOGadget for Excel

Score8 out of 10

3 Reviews and Ratings

What is SEOGadget for Excel?

SEOGadget for Excel is a tool developed by SEOgadget that aims to enhance SEO and keyword research capabilities within Microsoft Excel. According to the vendor, this tool allows users to connect directly to services such as Majestic SEO, Moz, and Grepwords within Excel, eliminating the need for manual data export and merging. It is marketed as a solution suitable for businesses of various sizes, including small startups and large enterprises. The tool caters to a range of professionals and industries, including SEO professionals, digital marketers, content marketers, business analysts, and marketing agencies.

Key Features

According to the vendor, SEOGadget for Excel offers the following key features:

Connects directly to services: The tool enables users to connect directly to services like Majestic SEO, Moz, and Grepwords within Microsoft Excel, streamlining the data retrieval process.

Quick data access from Moz: Users can access data and results quickly from the Moz URL Metrics API, facilitating efficient analysis, calculations, reporting, and problem-solving related to SEO and keyword research.

Easy data retrieval and manipulation: SEOGadget for Excel provides functions like MOZ_URLMetrics_toFit, MOZ_URLMetrics_toSheet, and MOZ_URLMetrics_toRange, allowing users to retrieve and manipulate data from the Moz API in a straightforward manner.

Filtering of data: Users can filter data from the Moz API to obtain specific types of information, such as Titles and Canonical URLs, enabling targeted analysis and reporting.

Helper functions for data management: The tool offers various helper functions like _toFit, _toSheet, and _toRange, which according to the vendor, facilitate the writing of data to tables, ranges, and cells.

Support for bit flags: According to the vendor, users can utilize bit flags to request specific data from the Moz API, such as Titles and Canonical URLs, enhancing flexibility and customization in data retrieval.

Moz Anchor Text API: SEOGadget for Excel provides the Moz Anchor Text API, which allows users to fetch anchor text data for a root domain, subdomain, or page, aiding in anchor text strategy analysis and optimization.

Sorting anchor text data: Users can sort anchor text data by domain authority using the Moz Anchor Text API, as claimed by the vendor, enabling the identification of high-quality backlinks and optimization of link building efforts.

Moz Links API: The tool integrates with the Moz Links API, allowing users to explore the links pointing to a URL, root domain, or subdomain, providing insights into their backlink profile and potential improvement opportunities.

Integration with Majestic API: According to the vendor, SEOGadget for Excel supports the Majestic API for querying the fresh and historic link indices, enabling users to analyze and monitor their website's backlink profile over time.

Categories & Use Cases

Top Performing Features

  • Backlink management

    The tool tracks existing backlinks, measures their impact on search rankings, alerts you of new backlinks, and helps surface backlink opportunities.

    Category average: 7.7

  • Integration with web analytics tools

    The tool integrates with web analytics tools such as Google Analytics and Adobe Analytics (SiteCatalyst).

    Category average: 8.7

  • Keyword analysis

    The tool analyzes the content of your site to help discover the right keywords.

    Category average: 8.7

Areas for Improvement

  • Social SEO

    The tool tracks social mentions and backlinks and their impact on SEO.

    Category average: 7.2

  • Site recommendations

    The tool recommends site structure improvements and other tasks to help with SEO.

    Category average: 7.4

  • Task management

    Users can track and manage the tasks associated with SEO.

    Category average: 6.8

SEOgadget is a Time Saver When Importing Moz, Majestic Link Data

Pros

  • Authentication is simple and requires no real in-depth knowledge
  • Importing of data into Excel saves time and saves us an extra step which is really important
  • Working with the data we need to see is much easier and faster
  • Collects multiple sources and saves time logging in
  • Data analysis is simple and straight forward

Cons

  • More flexibility in creating tables would be easier, as not all tables were able to be created this might be user error in some cases
  • More data imports would be nice this could be more of a one-and-done package, right now it only imports links
  • Added functionality to analyze data would be nice

Return on Investment

  • It is hard to quantify this realistically but it does save time and that is big
  • Importing data is a time suck, so the only real advantage here is the ability to do two or three imports instantly without downloading and visiting three sites, this could be expanded for even more ROI
  • We haven't had any negative impacts as this is mainly a time saver

Alternatives Considered

Analytics SEO, Conductor Searchlight, Moz and KNIME Analytics Platform

Other Software Used

Google Search Console, Screaming Frog SEO Spider, SEO Rank Monitor, Adobe Analytics, GoDaddy, SEO PowerSuite, SEO Rank Monitor