API Connectors

users-love-us medal soc2
Send your Ahrefs data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Ahrefs Connector Reference

49 metrics53 dimensions
Fields

The Ahrefs connector exposes 102 fields (49 metrics, 53 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Ahrefs Fields

Ahrefs Organic Keywords fields

The Organic Keywords report of the Ahrefs connector includes 30 fields.

ID Type Name Description
best_position NUMERIC Best Position The top position your target ranks for in the organic search results for a keyword.
best_position_has_thumbnail BOOLEAN Best Position Has Thumbnail The top position has a thumbnail.
best_position_has_video BOOLEAN Best Position Has Video The top position has a video.
best_position_kind TEXT Best Position Kind The kind of the top position: organic, paid, or a SERP feature.
best_position_set TEXT Best Position Set The ranking group of the top position.
best_position_url TEXT Best Position URL The ranking URL in organic search results.
cpc NUMERIC CPC Cost Per Click shows the average price that advertisers pay for each ad click in paid search results for a keyword, in USD.
is_best_position_top_11_50 BOOLEAN Is Best Position Top 11-50 The ranking group of the top position is 11-50.
is_best_position_top_3 BOOLEAN Is Best Position Top 3 The ranking group of the top position is Top 3.
is_best_position_top_4_10 BOOLEAN Is Best Position Top 4-10 The ranking group of the top position is 4-10.
is_branded BOOLEAN Is Branded User intent: branded. The user is searching for a specific brand or company name.
is_commercial BOOLEAN Is Commercial User intent: commercial. The user is comparing products or services before making a purchase decision.
is_informational BOOLEAN Is Informational User intent: informational. The user is looking for information or an answer to a specific question.
is_local BOOLEAN Is Local User intent: local. The user is looking for information relevant to a specific location or nearby services.
is_navigational BOOLEAN Is Navigational User intent: navigational. The user is searching for a specific website or web page.
is_transactional BOOLEAN Is Transactional User intent: transactional. The user is ready to complete an action, often a purchase.
keyword TEXT Keyword The keyword your target ranks for.
keyword_country COUNTRY Keyword country The country of a keyword your target ranks for.
keyword_difficulty NUMERIC Keyword Difficulty An estimation of how hard it is to rank in the top 10 organic search results for a keyword on a 100-point scale. Costs 10 Ahrefs API units per row.
keyword_paid_traffic NUMERIC Keyword Paid Traffic An estimation of the number of monthly visits that your target gets from paid search for a keyword. Costs 10 Ahrefs API units per row.
keyword_traffic NUMERIC Keyword Traffic An estimation of the number of monthly visitors that your target gets from organic search for a keyword. Costs 10 Ahrefs API units per row.
last_update TIMESTAMP Last Update The date when we last checked search engine results for a keyword.
search_volume NUMERIC Search Volume An estimation of the number of searches for a keyword over the latest month. Costs 10 Ahrefs API units per row.
search_volume_desktop_pct NUMERIC Search Volume Desktop Percentage The percentage of the total search volume that comes from desktop devices.
search_volume_mobile_pct NUMERIC Search Volume Mobile Percentage The percentage of the total search volume that comes from mobile devices.
serp_features_count NUMERIC SERP Features Count The number of SERP features that appear in search results for a keyword.
serp_language TEXT SERP Language The SERP language.
serp_target_main_positions_count NUMERIC SERP Target Main Positions Count The number of target URLs ranking for a keyword excluding positions in Sitelinks, Top stories, Image packs, and posts on X (Twitter).
serp_target_positions_count NUMERIC SERP Target Positions Count The number of target URLs ranking for a keyword.
words NUMERIC Words The number of words in a keyword.

Ahrefs Overview fields

The Overview report of the Ahrefs connector includes 8 fields.

ID Type Name Description
organic_cost NUMERIC Organic Cost The estimated value of your target's monthly organic search traffic, in USD. Costs 10 Ahrefs API units per row.
organic_keywords NUMERIC Organic Keywords The total number of keywords that your target ranks for in the top 100 organic search results.
organic_keywords_1_3 NUMERIC Organic Keywords Top 3 The total number of keywords that your target ranks for in the top 3 organic search results.
organic_traffic NUMERIC Organic Traffic The estimated number of monthly visitors that your target gets from organic search. Costs 10 Ahrefs API units per row.
NUMERIC Paid Cost The estimated cost of your target's monthly paid search traffic, in USD. Costs 10 Ahrefs API units per row.
NUMERIC Paid Keywords The total number of keywords that your target ranks for in paid search results.
NUMERIC Paid Pages The total number of pages from a target ranking in paid search results.
NUMERIC Paid Traffic The estimated number of monthly visitors that your target gets from paid search. Costs 10 Ahrefs API units per row.

Ahrefs Refdomains fields

The Refdomains report of the Ahrefs connector includes 15 fields.

ID Type Name Description
dofollow_linked_domains NUMERIC Dofollow Linked Domains The number of unique root domains with dofollow links linked from the referring domain.
NUMERIC Dofollow Links The number of links from the referring domain to your target that don't have the “nofollow” attribute.
dofollow_refdomains NUMERIC Dofollow Referring Domains The number of unique domains with dofollow links to the referring domain. Costs 5 Ahrefs API units per row.
first_seen TIMESTAMP First Seen The date we first found a backlink to your target from the referring domain.
is_root_domain BOOLEAN Is Root Domain The domain name is a root domain name.
is_spam BOOLEAN Is Spam Indicates whether the backlink comes from a known spammy domain.
last_seen TIMESTAMP Last Seen The date your target lost its last live backlink for the referring domain.
NUMERIC Links To Target The number of backlinks from the referring domain to your target.
NUMERIC Lost Links The number of backlinks lost from the referring domain for the selected time period.
NUMERIC New Links The number of new backlinks found from the referring domain for the selected time period.
refdomain_ip TEXT Referring Domain IP The referring domain IP address.
refdomain_keywords NUMERIC Referring Domain Keywords The number of keywords that the referring domain ranks for in the top 100 positions.
refdomain_rating NUMERIC Referring Domain Rating The strength of a domain's backlink profile compared to the others in our database on a 100-point scale.
refdomain_traffic NUMERIC Referring Domain Traffic The referring domain's estimated monthly organic traffic from search. Costs 10 Ahrefs API units per row.
referring_domain TEXT Referring Domain A referring domain that has at least one link to your target.

Ahrefs Top Pages fields

The Top Pages report of the Ahrefs connector includes 21 fields.

ID Type Name Description
ai_responses_chatgpt NUMERIC AI Responses ChatGPT The number of ChatGPT responses in which the page appeared, in the selected country (or summed across all countries). This includes cases where the page was cited as a source or only retrieved in the background. Powered by Brand Radar; requires the corresponding index. Costs 10 Ahrefs API units per row.
ai_responses_copilot NUMERIC AI Responses Copilot The number of Microsoft Copilot responses in which the page appeared, in the selected country (or summed across all countries). This includes cases where the page was cited as a source or only retrieved in the background. Powered by Brand Radar; requires the corresponding index. Costs 10 Ahrefs API units per row.
ai_responses_gemini NUMERIC AI Responses Gemini The number of Gemini responses in which the page appeared, in the selected country (or summed across all countries). This includes cases where the page was cited as a source or only retrieved in the background. Powered by Brand Radar; requires the corresponding index. Costs 10 Ahrefs API units per row.
ai_responses_google_ai_mode NUMERIC AI Responses Google AI Mode The number of Google AI Mode responses in which the page appeared, in the selected country (or summed across all countries). This includes cases where the page was cited as a source or only retrieved in the background. Powered by Brand Radar; requires the corresponding index. Costs 10 Ahrefs API units per row.
ai_responses_google_ai_overviews NUMERIC AI Responses Google AI Overviews The number of Google AI Overviews responses in which the page appeared, in the selected country (or summed across all countries). This includes cases where the page was cited as a source or only retrieved in the background. Powered by Brand Radar; requires the corresponding index. Costs 10 Ahrefs API units per row.
ai_responses_grok NUMERIC AI Responses Grok The number of Grok responses in which the page appeared, in the selected country (or summed across all countries). This includes cases where the page was cited as a source or only retrieved in the background. Powered by Brand Radar; requires the corresponding index. Costs 10 Ahrefs API units per row.
ai_responses_perplexity NUMERIC AI Responses Perplexity The number of Perplexity responses in which the page appeared, in the selected country (or summed across all countries). This includes cases where the page was cited as a source or only retrieved in the background. Powered by Brand Radar; requires the corresponding index. Costs 10 Ahrefs API units per row.
page_keywords NUMERIC Page Keywords The total number of keywords that your target ranks for in the top 100 organic search results.
page_traffic NUMERIC Page Traffic An estimation of the monthly organic search traffic that a page gets from all the keywords that it ranks for. Costs 10 Ahrefs API units per row.
page_traffic_value NUMERIC Page Traffic Value The estimated value of a page's monthly organic search traffic, in USD. Costs 10 Ahrefs API units per row.
page_type TEXT Predicted Page Type Comma-separated list of AI-predicted hierarchical page type paths. Each value is a slash-prefixed path (e.g. /Article/How_to).
referring_domains NUMERIC Page Referring Domains The number of unique domains linking to a page. Costs 5 Ahrefs API units per row.
top_keyword TEXT Top Keyword The keyword that brings the most organic traffic to a page.
top_keyword_best_position NUMERIC Top Keyword Best Position The ranking position that a page holds for its top keyword.
top_keyword_best_position_kind TEXT Top Keyword Best Position Kind The kind of the top position: organic, paid or a SERP feature.
top_keyword_best_position_title TEXT Top Keyword Best Position Title The title displayed for the page in its top keyword's SERP.
top_keyword_country COUNTRY Top Keyword Country The country in which a page ranks for its top keyword.
top_keyword_search_volume NUMERIC Top Keyword Search Volume An estimation of the average monthly number of searches for the top keyword over the latest month or over the latest known 12 months of data depending on the "volume_mode" parameter. Costs 10 Ahrefs API units per row.
top_page_raw_url TEXT Top Page Raw URL The ranking page URL in encoded format.
top_page_url TEXT Top Page URL The ranking page URL.
url_rating NUMERIC URL Rating URL Rating (UR) shows the strength of your target page’s backlink profile on a 100-point logarithmic scale.

Ahrefs other fields

The Ahrefs connector has 24 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID Account ID in Windsor.ai.
account_name TEXT Account Name Account name in Windsor.ai.
ahrefs_rank NUMERIC Ahrefs Rank The strength of your target's backlink profile compared to the other websites in our database, with rank #1 being the strongest. Domain Rating
country COUNTRY Country Ahrefs `country` value. Metrics by Country
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date The date the metrics are reported on. Snapshot reports return the end of the requested date range. Overview (history)
day_of_month TEXT Day of month Day of the month
domain_rating NUMERIC Domain Rating The strength of your target's backlink profile compared to the other websites in our database on a 100-point logarithmic scale. Domain Rating
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20