Integrating Ahrefs with Google Data Studio: A Complete Setup Guide

Integrating Ahrefs with Google Data Studio allows digital marketers and SEO professionals to visualize backlink profiles, keyword rankings, and site audits in a dynamic and customizable dashboard. This guide provides a step-by-step process to connect Ahrefs data seamlessly into Google Data Studio, enabling better data-driven decisions.

Prerequisites

An active Ahrefs account with API access
A Google account with access to Google Data Studio
Basic knowledge of APIs and data connectors
Google Sheets installed and accessible

Step 1: Obtain Ahrefs API Access

Sign in to your Ahrefs account and navigate to the API section. Generate an API key if you haven’t already. Ensure your plan supports API access and note down your API credentials for later use.

Verify API Permissions

Test your API credentials by making a simple request using tools like Postman or curl to confirm access to your data.

Step 2: Create a Google Sheet for Data Import

Open Google Sheets and create a new spreadsheet. Name it appropriately, e.g., “Ahrefs Data”. This sheet will serve as the intermediary to fetch and store API data before visualizing in Data Studio.

Set Up Data Retrieval Script

In your Google Sheet, go to Extensions > Apps Script. Paste the following script to fetch data from Ahrefs API:

Replace <YOUR_API_KEY> and other placeholders with your actual API details.

// Example script to fetch Ahrefs data
function fetchAhrefsData() {
  const apiKey = '<YOUR_API_KEY>';
  const url = 'https://apiv2.ahrefs.com?token=' + apiKey + '&from=backlinks&target=yourwebsite.com&mode=domain';
  const response = UrlFetchApp.fetch(url);
  const data = JSON.parse(response.getContentText());
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clearContents();
  // Parse and write data to sheet
  // Adjust according to actual API response structure
  sheet.appendRow(['Referring Domain', 'Backlink Count']);
  data.referring_domains.forEach(function(domain) {
    sheet.appendRow([domain.domain, domain.backlinks]);
  });
}

Step 3: Automate Data Refresh

In Apps Script, set up a trigger to run your fetch function periodically:

In Apps Script editor, go to Triggers > Add Trigger > select fetchAhrefsData > choose time-driven > set your preferred frequency.

Step 4: Connect Google Sheets to Data Studio

Open Google Data Studio and create a new report. Click on Add Data > Google Sheets. Select your spreadsheet and the specific sheet with your Ahrefs data. Connect and add it to your report.

Step 5: Visualize Your Data

Use Data Studio’s tools to create charts, tables, and dashboards. Customize your visualizations to highlight key backlinks, keyword rankings, or site health metrics derived from Ahrefs data.

Additional Tips

Regularly update your API script to match any API changes.
Use filters and calculated fields in Data Studio for deeper insights.
Secure your API keys and restrict access to your Google Sheets and Data Studio reports.

By following these steps, you can create a powerful, automated dashboard that consolidates Ahrefs SEO data within Google Data Studio. This setup enhances your ability to monitor and analyze your website’s SEO performance effectively.

Table of Contents