Connect Ahrefs to Data Studio

Bring your Ahrefs data into Data Studio with Windsor.ai, so your reports read live SEO data.

Pick the Ahrefs fields you need, and Windsor.ai keeps them flowing without a CSV export in between.

Forget CSVs. Stop copy/paste. Connect in minutes. No code required.

Try It Free

Free forever plan

No credit card needed

Windsor.ai is your proven Ahrefs to Data Studio connector

Get your Ahrefs data into Data Studio

Ahrefs is connected once in Windsor.ai, and these are the use cases the fields support:

Find keywords close to page one

Best Position, Search Volume and Keyword Difficulty come per Keyword, so you can list the keywords ranking 11 to 20 that have enough searches to work on.

See which pages bring traffic

Page Traffic, Page Keywords and Top Keyword per Top Page URL show which pages get the most organic visits and the keyword behind each.

Follow new and lost links

New Links, Lost Links and Referring Domain Rating per Referring Domain show which sites added or removed links to you in the period you choose.

Using Windsor.ai to connect data from Ahrefs to Data Studio

Supported fields: 49 metrics53 dimensions

Windsor.ai moves your Ahrefs fields into Data Studio on a connection you set up once, so the reports stay on live records rather than a CSV someone exported last week.

Pick the fields you need and Windsor.ai handles the rest.

With Windsor.ai, you can build Data Studio reports that:

List keywords with a Best Position from 11 to 20, with Search Volume and Keyword Difficulty, sorted by Search Volume.
Show the 10 Top Page URLs with the most Page Traffic, with Page Keywords and Top Keyword.
List the Referring Domains with New Links this month, with their Referring Domain Rating and Dofollow Links.
Compare AI Responses ChatGPT and AI Responses Google AI Overviews for my 20 Top Page URLs with the most Page Traffic.
Show Domain Rating, Organic Traffic and Organic Keywords for my site.

Join over 25,000+ businesses that trust Windsor.ai to streamline Ahrefs to Data Studio integration

How to connect Ahrefs to Data Studio with Windsor.ai

Explore a step-by-step guide to integrate your Ahrefs data into Data Studio with the Windsor.ai connector.

Register and log in to Windsor.ai

Create a new Windsor.ai account or log in if you already have one.

Select your data source

Choose Ahrefs as your data source, enter your Ahrefs API key, and enter the target: the domain or URL you want to report on.

Select the reporting fields

Choose the Ahrefs fields you want in Data Studio on the right side, and preview your data before export.

Select Data Studio as your data destination

Scroll down to the list of data destinations and click Data Studio. Install the Windsor.ai connector by authorizing your account, selecting the required Ahrefs account(s), and clicking Connect, then Create Report.

FAQs

What is Ahrefs?

Ahrefs is an SEO and marketing platform with its own databases of backlinks, keywords and search results. Marketers use it to see which keywords a site ranks for, how much organic traffic its pages get, and which domains link to it.

What Ahrefs data can I load into Data Studio?

Windsor.ai gives access to 102 Ahrefs fields. These are the groups; the Ahrefs field reference lists all of them:

Site overview: Domain Rating, Ahrefs Rank, Organic Traffic, Organic Keywords, Organic Keywords Top 3, Organic Cost, Paid Traffic, Paid Keywords.
Backlinks: Backlinks, Referring Domains, Historical Backlinks, Historical Referring Domains, and per Referring Domain: Referring Domain Rating, Dofollow Links, New Links, Lost Links, First Seen, Last Seen, Is Spam.
Organic keywords: Keyword, Best Position, Best Position URL, Search Volume, Keyword Difficulty, CPC, Keyword Traffic, SERP Features Count, and search intent flags such as Is Informational and Is Commercial.
Top pages: Top Page URL, Page Traffic, Page Keywords, Top Keyword, URL Rating, and AI Responses for ChatGPT, Gemini, Perplexity, Copilot, Grok, Google AI Overviews and Google AI Mode.
Time and location: Date, Country, Keyword country.

How does Windsor.ai load Ahrefs data into Data Studio?

Windsor.ai provides a Data Studio connector. You authorize it once, select your Ahrefs account and the fields you want, and build the report on live data.

Can I combine Ahrefs data with other sources in my reports?

Yes. Windsor.ai supports 350+ data sources, so Ahrefs data can sit next to other connected sources in the same reports. For example, put Ahrefs Best Position and Keyword Traffic next to Google Search Console clicks and impressions for the same keywords, so estimated and measured search traffic sit in one table.

Do I need to code to connect Ahrefs to Data Studio?

No. You connect Ahrefs in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai handles the transfer.

How much does it cost to integrate Ahrefs with Data Studio using Windsor.ai?

The free forever plan covers 1 data source, so connecting Ahrefs on its own costs nothing and needs no credit card. Combining Ahrefs with other sources needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.

Do you have helpful links to get started with Ahrefs and Data Studio?

Yes. These are the resources to start with for the Ahrefs to Data Studio integration:

Tired of manual Ahrefs data exports? Try Windsor.ai today to work on live data

Access all your data from various sources in one place. Get started for free.

Start for Free Book a Demo