Access Ahrefs in Excel


Ahrefs rank

Quickly retreive the Ahrefs rank for a set of urls. This is aquick way to assess the quality of a set of urls.


Retrieve backlinks for a url.

- New & Lost

Contains the new or lost backlinks and details of the referring pages.

- New & Lost Counters

Contains new and lost backlink totals.

- Broken

Contains the broken links and details of the referring pages, such as anchor and page title.

- One per Domain

Contains the broken links and details of the referring pages, such as anchor and page title.


Domain Rating

Contains the backlinks and details of the referring pages, such as anchor and page title.


Metrics

Retrieves metrics for a url.

Note, SeoTools uses the metrics service instead of the metrics_extended service to preserve credits if possible.


Anchors

Given an url, retrieve anchor texts and backlink counts.

- Anchors Ref Domains

Contains connection between anchors and domains.

- Linked Anchors

Contains the anchor text and the number of outgoing links that have it.


Ref Domains

Contains the referring domains that contain backlinks to the target.

- Ref Domains by Metric Type

Contains the referring domains that contain backlinks to the target.

- Ref Domains by TLD Type

Top-level domain name and counts for which TLD statistics are provided.

- Ref Domains New & Lost

Contains the new or lost referring domains and their details.

- Ref Domains New & Lost Counters

Contains new and lost domains totals.


Pages

Retrieve additional metrics about a web page.


Refips

Returns the referring IP addresses that have at least one link to the target.


Where

Anchors, Backlinks and Pages allows for specifying a filter for what records to retreive.

Example: Only include backlinks that have ahrefs_ranks higher than 10:

ahrefs_rank>10

Example: Include all backlinks except those that contains the string "seotools":

!substring(url_from,"seotools")

Order by

Anchors, Backlinks and Pages also allows for specifying the order of the returned records:

Example: Order by ahrefs_rank in descending order:

ahrefs_rank:desc

Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation


Get help with this function in the community →