Gold Penguin Logo with Text

Export Keywords On Ahrefs to Use With ChatGPT's Code Analysis Tool

SEO can be tricky, but with Ahrefs and ChatGPT, it's a whole lot easier. This guide shows you how to export keywords on Ahrefs and use ChatGPT in analyzing data to boost your SEO strategy. 
Updated October 29, 2023
upload keywords from Ahrefs to ChatGPT
upload keywords from Ahrefs to ChatGPT
Difficulty: Easy. Might help to know the basics of this tool/topic
Time Required: ~5 minutes

SEO is getting more challenging with Google’s frequent algorithm updates. 

Yet, in this ever-shifting landscape, keyword research remains the most effective strategy to optimize any website. 

I've found that one of the most powerful tools for this is Ahrefs. 

Now, think about the potential when we integrate it with ChatGPT's analysis capabilities. Here's how this pairing can supercharge your SEO efforts: 

  • Analyzing keyword data can help you determine what truly engages your audience. 
  • With ChatGPT, you can easily spot areas where your competitors have an edge and refine your strategies.
  • By continuously analyzing keyword data, you can quickly spot emerging trends and ensure you’re always a step ahead.

The goal of this tutorial is to show you how to export keywords on Ahrefs and upload them in ChatGPT for data analysis. By the end, you’ll learn how to leverage AI to boost your SEO strategies.

SEO analysis using ChatGPT

So, let’s get started!

Getting SEO Data from Ahrefs for Analysis

1) Login to Ahrefs

Log in to your Ahrefs account and go to the ‘Keywords Explorer’ tool.

First, you’ll need to select your audience’s location.

When doing keyword research, Ahrefs allows you to choose a specific country or cast a wider net globally. If you have a target audience in a particular country, make sure to select it.

For example, if you're targeting the US, choose ‘United States.’

2) Input Your Seed Keyword:

On the Keyword Explorer, type in a seed keyword that best describes your niche, something general but relevant.

find keywords using Ahrefs

For example, if you're in the beauty niche focusing on ethical products, you might use ‘vegan skincare products’ as your seed keyword.

3) Check the Keyword Overview

After entering your seed keyword, Ahrefs lays out an overview for you. 

generate keyword ideas using Ahrefs

You should see stats like keyword difficulty, search volume, and click data. These metrics provide a snapshot of the keyword's competitiveness and popularity.

4) Explore Keyword Ideas

On the left panel, you'll find several options to generate keyword ideas. Here’s a quick rundown:

  • Matching terms: This is where you’ll find keywords that contain the exact seed keyword.
  • Related terms: Here, you’ll find keywords that contain all the terms of your seed keyword but not necessarily in the same order.
  • Search suggestions: In this section, you’ll find keywords that other websites currently ranking for your seed keyword also rank for.

Now, you can click on each of these to get a list of potential keywords. 

5) Use filters and Keyword metrics

Ahrefs also allows you to filter keyword results based on volume, difficulty, and word count. This helps you narrow down to more specific and relevant keywords. 

For instance, you can add words like ‘how’ or ‘what’ under the ‘Include’ option to target the search intent.

use Ahrefs keyword filters

You can also narrow down your search based on a set of metrics:

  • Volume: This shows the average monthly searches for the keyword.
  • KD or Keyword Difficulty: Provides an estimate of how hard it will be to rank on the first page of search results.
  • CPC or Cost Per Click: Useful if you are considering a paid search.
  • Clicks: This is the total number of clicks on the search results for that keyword.
Ahrefs keyword metrics

Understanding these metrics is important so that you’ll know the competitiveness of each keyword.

For our example, we might find potential keywords like:

  • ‘best vegan skincare products’
  • ‘vegan skincare products for sensitive skin’
  • ‘vegan beauty products
  • ‘benefits of vegan skincare products’

6) Export Your Keyword List

Once you've identified potential keywords, it’s time to export them for further analysis in ChatGPT.

Simply click the export button located at the top right of your dashboard. Make sure that you download your file as a CSV.

export Ahrefs keywords

Enabling the Advanced Data Analysis Plugin in ChatGPT

1) Open the Account Settings

To tap into ChatGPT's analytical capabilities, we’ll first need to activate the Advanced Data Analysis plugin. Note that this feature is only accessible on ChatGPT Plus. If you want the extra features with faster response times, I can vouch that the subscription fee is worth every penny.

Now, log in to your ChatGPT account. On the left panel, click the three dots beside your profile name. Select Settings & Beta. This will open a pop-up with your account settings.

ChatGPT profile settings

2) Enable the ‘Advanced Data Analysis’ Plugin

Next, go to the Beta Features tab. Here, you'll find the 'Advanced Data Analysis' toggle. Switch it on. This little tweak will let you upload files directly into the chat.

enable ChatGPT Advanced Data Analysis

3) Make Sure the Plugin is Activated

Now, you’ll need to click the GPT-4 tab on the top of your screen. From the dropdown, make sure that the Advanced Data Analysis plugin is checked, as shown below.

enable ChatGPT Advanced Data Analysis

Once that's done, you're all set!

Analyzing Keywords from Ahrefs in ChatGPT

1) Upload Your File

Now, let’s ask ChatGPT to analyze our keywords from Ahrefs. Make sure that GPT-4 is selected. 

On your chat box, click the ‘+’ icon. Then, select and upload the Ahrefs file.

attach files in ChatGPT

2) Enter Your Prompt

Now, you want to give ChatGPT some detailed instructions about what you want to achieve with the data.

For example, you can ask ChatGPT to help you identify high-potential keywords and suggest blog post topics based on its analysis.

Here’s what I did:

Uploaded is a file containing the keyword analysis I exported from Ahrefs. Please analyze the data and identify low-competition keywords with high search volumes that we can use for our blog post topics. 

3) Review the Data Summary

Once your file is uploaded, ChatGPT will then load your data. It will also auto-correct any data inconsistencies using various encoding methods, as shown below.

ChatGPT analyzing file content

ChatGPT will then provide you with a summary of the data. You can review this to make sure the data has been interpreted correctly.

ChatGPT analyzing file content

You’ll also be presented with options for the next steps in the analysis. In our example, I’ve instructed ChatGPT to run with its default settings for the analysis thresholds.

ChatGPT analyzing file content

Below are the analysis results and keyword recommendations from ChatGPT.

4) Revise Your Prompt

One of the features I love about ChatGPT is its capability to hold a conversation. This allows you to refine your prompts and get the results you want.

Here, I asked ChatGPT to create a markdown table with columns for the keyword search volume, traffic potential, blog title suggestions, slug, and meta description.

Based on the results above, do a full SEO analysis and create a table with a list of blog post topics. Add columns for the search volume, traffic potential, blog title, slug, and meta description.

ChatGPT will then detail the steps it’ll take to arrive at the answers. This ensures that your AI understands your instructions. 

ChatGPT performing SEO analysis

If things seem off, just rephrase your prompt until you're confident the AI understands the task.

5) Review the Results

Now, let’s check the output. 

For our example, ChatGPT provided a clean table with the list of keywords, their search volumes, traffic potentials, suggested blog titles, slugs, and meta descriptions.

ChatGPT performing SEO analysis

With this information, you now have a solid starting point for creating your SEO content blueprint.

ChatGPT is changing the game in SEO, and its potential in content marketing is just scratching the surface.

So, use it well to step up your SEO strategies. In this guide, we’ve shown you how easy it is to analyze keywords with the help of AI. And if you love data visualizations, ChatGPT can generate that, too. Amazing, isn’t it?

But I don’t think it can replace our creativity just yet. With time, I’m sure AI will only get better. This will open up more opportunities for us to innovate.

Want To Learn Even More?
If you enjoyed this article, subscribe to our free monthly newsletter
where we share tips & tricks on how to use tech & AI to grow and optimize your business, career, and life.
Written by Christy Cañete
Christy Cañete is a software engineer who's passionate about front-end web design. Not only can she code, but she writes too! She loves breaking down technical topics into super easy tutorials. If you're looking to learn without the jargon, she's your go-to.
Notify of

Inline Feedbacks
View all comments
Join Our Newsletter!
If you enjoyed this article, subscribe to our newsletter where we share tips & tricks on how to make use of some incredible AI tools that you can use to grow and optimize a business