How to Visualize Ahrefs Data with ChatGPT

SEOs have entry to a lot information that generally, it’s arduous to know what to do with all of it. I’ve been experimenting with visualizing Ahrefs information utilizing GPT-4, so I believed I’d share the outcomes with you all.

We’ve already launched some AI-enhanced options like search intent, however we made it even higher by including the site visitors share for every intent. Take a look at this write-up from Si Quan for some extra issues we would add.

For the visualizations, you’ll want GPT-4. There’s an API, however you may as well simply use ChatGPT Plus for $20 a month. I’m hoping to carry many of those visuals to life inside the device, however this stuff take time and you may create them now. Let me know your favorites and some other use instances you discover that you just wish to see us add!

Use case:

This lets you see outliers. When you have some phrases rating higher on Desktop vs Cell, you then may wish to have a look at cellular points or Core Web Vitals.

You’ll be able to see each cellular points and Core Net Vitals in Ahrefs’ Site Audit. You’ll have to run Web site Audit as cellular and connect with PageSpeed Insights.

Knowledge supply:

Obtain your desktop and cellular rankings from the Overview report in Rank Tracker (bear in mind to decide on the UTF-8 format). Add each information to ChatGPT.

Immediate:

Learn these 2 information that include desktop and cellular key phrase rankings.

Present me a scatter plot evaluating the desktop and cellular positions for every key phrase.

Label ones which have the largest hole between rankings.

Use case:

See the breakdown of site visitors and whole quantity by branded and unbranded terms. At a look, I can see that almost all of our site visitors comes from unbranded phrases.

Knowledge supply:

Obtain your key phrase rankings from the Natural Key phrases report in Site Explorer (be certain that to pick the UTF-8 file format) and add the file to ChatGPT.

Immediate:

Label every key phrase within the “Key phrase” column as branded or unbranded. Then create a pie chart that reveals the sum of “Present natural site visitors” for each classes.

Additionally create this chart with the sum of “Quantity” for every.

Use case:

See when you’re gaining or shedding clicks for branded or unbranded phrases between two dates. You could have evaluate mode enabled for this to work.

Knowledge supply:

Just like the earlier one, obtain your key phrase rankings from the Natural Key phrases report in Site Explorer and add the file.

Immediate:

Label every key phrase within the “Key phrase” column as branded or unbranded.

Create a visible that reveals me how the natural site visitors modified general for branded and unbranded key phrases based mostly on the sum of the info for every within the “Natural site visitors change” column.

Use case:

See the final time competing content material was up to date. If rivals are updating their content material lots, it may possibly point out a extra aggressive market.

Knowledge supply:

Enter a competitor’s web site into Content Explorer and export the checklist of pages (select UTF-8 because the export format). This will also be carried out with a key phrase or subject.

Immediate:

Present me what number of days for the reason that content material was up to date.

Use case:

See how lengthy backlinks have been stay on common. When you’re shedding plenty of backlinks early, you might wish to look into the explanation why. Learn our study on link rot to see most of the frequent causes.

You’ll be able to filter the Backlinks report for most of the frequent explanation why hyperlinks are misplaced.

Knowledge supply:

Export your hyperlink profile from the Backlinks report in Web site Explorer (select UTF-8 because the file format). Add this to ChatGPT.

Immediate:

Learn this file and provides me a histogram to point out the distribution of backlink lifespans.

Use case:

See any seasonal patterns on your acquired hyperlinks. Right here, I see an enormous spike in the course of 2022 and what appears to be a little bit of a spike in November the previous couple of years.

Knowledge supply:

Just like the earlier one, export your hyperlink profile from the Backlinks report in Web site Explorer. Add this to ChatGPT.

Immediate:

Search for seasonal patterns in backlink acquisition.

When you’d choose a heatmap just like the one beneath, use this immediate as a substitute:

Analyze patterns in hyperlink acquisition (e.g., weekdays vs. weekends, month-to-month tendencies) utilizing line charts or heatmaps to establish when most backlinks are acquired.

Use case:

See which tag teams are sturdy or weak vs rivals. I can shortly see we dominate for issues like hyperlink constructing, however we’re weak for the phrases in our normal advertising bucket, most likely as a result of we largely give attention to website positioning.

Knowledge supply:

Export the info from the Opponents – Tags report in Rank Tracker (use UTF-8 format).

Immediate:

Present me share of voice by tag and cut up it by competitor as properly.

Use case:

Forecasting site visitors or different metrics ahead. That is nice for getting buy-in.

Knowledge supply:

Export graph information from the Overview report in Web site Explorer. You’ll be able to select any time-series graph you want (natural site visitors, referring domains, and so on.)

Immediate:

Forecast this time sequence information ahead one yr

Lengthy story quick on this one. I had a model that wasn’t nearly as good as what Marie Haynes came up with, however I added to her visualization to make it even higher.

Use case:

The chart visualizes winners/losers for key phrase rankings and reveals me general if I’m doing higher or worse. From this picture, I can see that extra key phrases general are rating worse, however general rankings are up, so the constructive ones moved up much more than the damaging ones misplaced.

Knowledge supply:

Obtain your key phrase rankings from the Natural Key phrases report in Site Explorer and add the file.

Immediate:

I used a number of prompts to get the ultimate chart, however they may be capable of be simplified into one.

Present me a scatter plot that reveals the adjustments from the earlier place and the present place. Embrace adjustments to a decrease place as inexperienced and adjustments to the next place as crimson. Embrace a legend and trendline.

Add a rely for improved and worsened on the earlier chart. Additionally present me on the chart on common, how a lot did rankings enhance or decline

Take away the averages as they’re. I would like the general common change in rating place as one quantity.

Transfer the typical to the precise aspect of the chart so it’s readable

Use case:

Discover anomalies in time sequence information. On this case, a lot of the anomalies line up with main web site adjustments and Google algorithm updates.

Knowledge supply:

Export natural site visitors graph information from the Overview report in Web site Explorer.

Immediate:

Determine anomalies on this site visitors chart

Use case:

This tells me if sure tagged teams are doing higher or worse between the dates.

Knowledge supply:

Export information from the Tags report in Rank Tracker.

Immediate:

Present me share of voice over time by tag.

Use case:

See how site visitors modified for every tag between two dates. We’ve got a greater view for this coming in Rank Tracker that can present the evolution over time.

Knowledge supply:

Just like the earlier one, export information from the Tags report in Rank Tracker.

Immediate:

Present me how site visitors is evolving for every tag.

Use case:

See which teams of phrases have probably the most quantity vs the clicks that they’re getting. Excessive whole quantity and low clicks means you’ve gotten lots to work on.

Knowledge supply:

Export key phrases from the Overview report in Rank Tracker. (You’ll be able to select between desktop or cellular rating information with the toggle).

Immediate:

Visualize search quantity and clicks by tag.

Use case:

Reveals frequent SERP options for you and rivals that you could be wish to goal. If sure schema markup is required however you’re not utilizing it, it may possibly result in a straightforward win.

You might also have a difficulty along with your schema markup. Ahrefs’ Web site Audit validates in opposition to each schema.org and Google requirements.

Knowledge supply:

Export the info from the Content material Hole report in our Aggressive Evaluation device.

Immediate:

Present me which SERP options are commonest.

Ultimate ideas

I hope this has sparked some concepts for different SEOs on the market. I wish to see what you all will create.

Have a cool concept you wish to share? Let me know on X or LinkedIn.