Each request to backlinks_new_lost costs 1 row.
Each result costs 0.2 row.
Using 'offset' costs 5 rows.
Using 'where' costs 5 rows.
Using 'having' costs 5 rows.
| Column | Type | Where | Having | Description |
|---|---|---|---|---|
| date | date | + | + | Date the backlink was tagged as New or Lost. |
| type | string | + | + | Indicates whether the backlink is New or Lost. |
| ahrefs_rank | int | + | + | URL Rating of the referring page. |
| domain_rating | int | + | + | Domain Rating of the referring domain. |
| url_from | string | + | + | URL of the page where the backlink is found. |
| url_to | string | + | + | URL of the page the backlink is pointing to. |
| links_internal | int | + | + | Number of internal links found in the referring page. |
| links_external | int | + | + | Number of external links found in the referring page. |
| encoding | string | + | + | Character encoding of the referring page, for example "utf8" or "iso-8859-1" (Latin-1). |
| http_code | int | + | + | HTTP code that was last returned for the referring page. |
| title | string | + | + | Title of the referring page. |
| origin | string | + | + | Either "fresh", "drop", or "recrawl". |
| first_seen | date | + | + | Date when the Ahrefs crawler was able to visit the backlink for the first time. |
| last_visited | date | + | + | Most recent date when the Ahrefs crawler was able to visit the backlink. |
| prev_visited | date | + | + | Second to the most recent date when the Ahrefs crawler was able to visit the backlink |
| sitewide | boolean | + | + | Indicates if backlinks appear in all pages of a single website, such as in a footer or header. |
| original | boolean | + | + | Indicates whether the backlinks was present on the referring page when the Ahrefs crawler first visited it. |
| link_type | string | + | + | Either "href", "redirect", "frame", "form", "canonical", "rss", or "alternate". |
| redirect | int | + | + | For redirected links, the Redirect Code (3XX), zero otherwise. |
| nofollow | boolean | + | + | Indicates whether the backlink is NoFollow. |
| alt | string | + | + | Alternative text of the image backlink, if exists. |
| anchor | string | + | + | Anchor text of the backlink. |
| text_pre | string | + | + | Snippet before the anchor text. |
| text_post | string | + | + | Snippet after the anchor text. |
<?xml version="1.0" encoding="UTF-8"?>
<AhrefsApiResponse>
<refpages>
<refpage>
<date>
2013-11-07
</date>
<type>
new
</type>
<ahrefs_rank>
11.724579
</ahrefs_rank>
<domain_rating>
49.000000
</domain_rating>
<url_from>
http://www.aletenky.cz/letenky/Praha/Lond%C3%BDn
</url_from>
<url_to>
http://ahrefs.com/serps/positions/ahrefs.com
</url_to>
<links_internal>
0
</links_internal>
<links_external>
1
</links_external>
<encoding>
raw
</encoding>
<http_code>
301
</http_code>
<title>
301 Moved Permanently
</title>
<origin>
fresh
</origin>
<first_seen>
2013-11-07T06:48:09Z
</first_seen>
<last_visited>
2013-11-07T06:48:09Z
</last_visited>
<prev_visited>
1970-01-01T00:00:00Z
</prev_visited>
<sitewide>
false
</sitewide>
<original>
true
</original>
<link_type>
redirect
</link_type>
<redirect>
301
</redirect>
<nofollow>
false
</nofollow>
<alt>
</alt>
<anchor>
</anchor>
<text_pre>
</text_pre>
<text_post>
</text_post>
</refpage>
<refpage>
<date>
2013-11-07
</date>
<type>
new
</type>
<ahrefs_rank>
11.717881
</ahrefs_rank>
<domain_rating>
59.000000
</domain_rating>
<url_from>
http://www.sagive.co.il/professional-library/web-marketing/yahoo-site-explorer-close/
</url_from>
<url_to>
http://ahrefs.com/pricing-plans
</url_to>
<links_internal>
38
</links_internal>
<links_external>
26
</links_external>
<encoding>
utf8
</encoding>
<http_code>
200
</http_code>
<title>
סופו של Yahoo Site Explorer ~ שגיב SEO
</title>
<origin>
fresh
</origin>
<first_seen>
2013-11-07T21:48:58Z
</first_seen>
<last_visited>
2013-11-07T21:48:58Z
</last_visited>
<prev_visited>
1970-01-01T00:00:00Z
</prev_visited>
<sitewide>
false
</sitewide>
<original>
true
</original>
<link_type>
href
</link_type>
<redirect>
0
</redirect>
<nofollow>
true
</nofollow>
<alt>
</alt>
<anchor>
ahrefs
</anchor>
<text_pre>
האלטרנטיבה השלישית היא
</text_pre>
<text_post>
. שירות קצת יקר ביחס למתחרים אבל
</text_post>
</refpage>
</refpages>
</AhrefsApiResponse>