Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Ahrefs data to
Ahrefs Connector Reference
49 metrics53 dimensions
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 Backlinks Stats fields
The Backlinks Stats report of the Ahrefs connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| backlinks_historical | NUMERIC | Historical Backlinks | The total number of links from other websites pointing to your target for all time. |
| backlinks_num | NUMERIC | Backlinks | The total number of links from other websites pointing to your target. |
| domains_num | NUMERIC | Referring Domains | The total number of unique domains linking to your target. Costs 5 Ahrefs API units per row. |
| refdomains_historical | NUMERIC | Historical Referring Domains | The total number of unique domains linking to your target for all time. Costs 5 Ahrefs API units per row. |
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 | 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. |
| paid_cost | NUMERIC | Paid Cost | The estimated cost of your target's monthly paid search traffic, in USD. Costs 10 Ahrefs API units per row. |
| paid_keywords | NUMERIC | Paid Keywords | The total number of keywords that your target ranks for in paid search results. |
| paid_pages | NUMERIC | Paid Pages | The total number of pages from a target ranking in paid search results. |
| paid_traffic | 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. |
| dofollow_links | 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 | 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 | Last Seen | The date your target lost its last live backlink for the referring domain. | |
| links_to_target | NUMERIC | Links To Target | The number of backlinks from the referring domain to your target. |
| lost_links | NUMERIC | Lost Links | The number of backlinks lost from the referring domain for the selected time period. |
| new_links | 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 | 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 | 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 |