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.